Unrated severityNVD Advisory· Published Dec 24, 2020· Updated Aug 4, 2024
CVE-2020-35675
CVE-2020-35675
Description
BigProf Online Invoicing System before 3.0 offers a functionality that allows an administrator to move the records of members across groups. The applicable endpoint (admin/pageTransferOwnership.php) lacks CSRF protection, resulting in an attacker being able to escalate their privileges to Administrator and effectively taking over the application.
AI Insight
LLM-synthesized narrative grounded in this CVE's description and references.
CSRF in BigProf Online Invoicing System before 3.0 allows an attacker to escalate privileges to Administrator via admin/pageTransferOwnership.php.
Vulnerability
The BigProf Online Invoicing System before version 3.0 contains a Cross-Site Request Forgery (CSRF) vulnerability in the endpoint admin/pageTransferOwnership.php. This endpoint allows an administrator to move member records across groups, but it lacks CSRF protection. As a result, an attacker can trick an authenticated administrator into performing unintended actions. Affected versions are all prior to 3.0 [1].
Exploitation
An attacker can craft a malicious web page or email that, when visited by an authenticated administrator, triggers a forged request to admin/pageTransferOwnership.php. The attacker does not need any special network position beyond being able to deliver the crafted request to the victim. The administrator must be logged into the application for the attack to succeed. The attacker can specify parameters to transfer ownership or modify group assignments, leading to privilege escalation.
Impact
Successful exploitation allows the attacker to escalate their privileges to Administrator level, effectively taking over the application. This results in full compromise of the system, including the ability to modify data, access sensitive information, and perform administrative actions.
Mitigation
The vulnerability is fixed in version 3.0 of BigProf Online Invoicing System [1]. Users should upgrade to version 3.0 or later. There are no known workarounds for earlier versions. The CVE is not listed in the CISA Known Exploited Vulnerabilities (KEV) catalog as of the publication date.
AI Insight generated on May 26, 2026. Synthesized from this CVE's description and the cited reference URLs; citations are validated against the source bundle.
Affected products
2- BigProf/Online Invoicing Systemdescription
- Range: <3.0
Patches
1b5d21ebfba2aAs generated by AppGini 5.83
32 files changed · +90 −33
app/admin/getUsers.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ /*
app/admin/incFunctions.php+1 −1 modified@@ -263,7 +263,7 @@ function createThumbnail($img, $specs){ function makeSafe($string, $is_gpc = true){ static $cached = []; /* str => escaped_str */ - if(!db_link()) { sql("SELECT 1+1", $eo); } + if(!db_link()) sql("SELECT 1+1", $eo); // if this is a previously escaped string, return from cached // checking both keys and values
app/admin/pageAssignOwners.php+5 −0 modified@@ -21,6 +21,9 @@ // process ownership request if(count($_POST)) { + // csrf check + if(!csrf_token(true)) die($Translation['invalid security token']); + ignore_user_abort(); foreach($arrTablesNoOwners as $tn => $tc) { $groupID = intval($_POST["ownerGroup_$tn"]); @@ -145,6 +148,8 @@ function populateMembers(memberSelect, groupSelect) { </script> <form method="post" action="pageAssignOwners.php"> + <?php echo csrf_token(); ?> + <p> <?php echo $Translation['data ownership'] ; ?> </p>
app/admin/pageEditGroup.php+5 −0 modified@@ -12,6 +12,9 @@ // request to save changes? if($_POST['saveChanges'] != '') { + // csrf check + if(!csrf_token(true)) die($Translation['invalid security token']); + // validate data $name = makeSafe($_POST['name']); $description = makeSafe($_POST['description']); @@ -176,6 +179,8 @@ </div> <form method="post" action="pageEditGroup.php" class="form-horizontal"> + <?php echo csrf_token(); ?> + <input type="hidden" name="groupID" value="<?php echo $groupID; ?>"> <div class="form-group ">
app/admin/pageEditMemberPermissions.php+5 −0 modified@@ -27,6 +27,9 @@ // request to save changes? if(isset($_POST['saveChanges'])) { + // csrf check + if(!csrf_token(true)) die($Translation['invalid security token']); + // validate data foreach ($tables as $t => $tc) { eval(" @@ -122,6 +125,8 @@ </div> <form method="post" action="pageEditMemberPermissions.php"> + <?php echo csrf_token(); ?> + <input type="hidden" name="memberID" value="<?php echo $memberID->attr; ?>"> <div class="text-right" style="margin: 2em 0;">
app/admin/pageEditOwnership.php+5 −0 modified@@ -6,6 +6,9 @@ // request to save changes? if(isset($_REQUEST['saveChanges'])) { + // csrf check + if(!csrf_token(true)) die($Translation['invalid security token']); + // validate data $recID = intval($_REQUEST['recID']); $memberID = makeSafe(strtolower($_REQUEST['memberID'])); @@ -75,6 +78,8 @@ <div class="page-header"><h1><?php echo $Translation['edit Record Ownership']; ?></h1></div> <form method="post" action="pageEditOwnership.php" class="form-horizontal"> + <?php echo csrf_token(); ?> + <input type="hidden" name="recID" value="<?php echo html_attr($recID); ?>"> <div style="height: 1em;"></div>
app/admin/pageServerStatus.php+39 −6 modified@@ -1,6 +1,6 @@ <?php - $appgini_version = '5.81.1095'; - $generated_ts = '20/1/2020 7:50:38 PM'; + $appgini_version = '5.83.1106'; + $generated_ts = '13/7/2020 5:05:20 PM'; $currDir = dirname(__FILE__); require("{$currDir}/incCommon.php"); @@ -99,7 +99,7 @@ <span class="label label-info big-number"><?php echo number_format($uploads_size / 1024 / 1024, 2); ?> MB</span> <h3><?php echo $Translation['db storage']; ?></h3> - <div class="db-status"> + <div class="db-status scrollable"> <table class="table table-striped table-hover table-bordered"> <thead> <tr> @@ -128,7 +128,7 @@ <div class="col-lg-4"> <h3><?php echo $Translation['db status']; ?></h3> - <div class="db-status"> + <div class="db-status scrollable"> <table class="table table-striped table-hover table-bordered"> <?php foreach($db_status as $var => $val) { ?> <tr> @@ -143,7 +143,7 @@ <div class="col-lg-4" id="phpinfo"> <h3><?php echo $Translation['php info']; ?></h3> - <div class="db-status"> + <div class="db-status scrollable"> <?php echo $phpinfo[0]; ?> </div> </div> @@ -164,7 +164,7 @@ #phpinfo table tr:nth-child(odd) { background-color: #fff; } - .db-status { + .db-status.scrollable { max-height: 60vh; overflow-y: auto; } @@ -173,7 +173,40 @@ line-height: 10rem; margin: 0 1rem; } + .cursor-pointer { + cursor: pointer; + } + </style> +<script> + $j(function() { + // apply a zoom-in button to each grid cell + $j('<i class="glyphicon glyphicon-zoom-in resizer text-primary hspacer-sm cursor-pointer"></i>').prependTo('.col-lg-4 > h3:first-child'); + + // and for every zoom-in button, add a class 'zoomable-cell' to its grid cell + $j('.resizer').parents('.col-lg-4').addClass('zoomable-cell'); + + // on clicking a zoom button, maximize/restore its parent grid cell + $j('.row').on('click', '.resizer', function() { + var toggler = $j(this), + cell = toggler.parents('.zoomable-cell'), + maximized = cell.hasClass('col-lg-12'); + + toggler.toggleClass('glyphicon-zoom-in glyphicon-zoom-out'); + cell.toggleClass('col-lg-12 col-lg-4'); + cell.children('.db-status').toggleClass('scrollable') + + if(maximized) { + // restore default size + cell.parents('.row').children('.col-lg-4').removeClass('hidden'); + } else { + // otherwise, maximize + cell.parents('.row').children('.col-lg-4').addClass('hidden'); + } + }) + }) +</script> + <?php include("{$currDir}/incFooter.php");
app/admin/pageTransferOwnership.php+4 −0 modified@@ -14,6 +14,9 @@ $moveMembers (=0 or 1) */ + // csrf check + if(!csrf_token(true)) die($Translation['invalid security token']); + // validate input vars $sourceGroupID = intval($_GET['sourceGroupID']); $sourceMemberID = makeSafe(strtolower($_GET['sourceMemberID'])); @@ -156,6 +159,7 @@ <div class="page-header"><h1><?php echo $Translation['ownership batch transfer']; ?></h1></div> <form method="get" action="pageTransferOwnership.php" class="form-horizontal"> + <?php echo csrf_token(); ?> <div id="step-1" class="panel panel-default"> <div class="panel-heading">
app/ajax_combo.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ /*
app/clients_autofill.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ $currDir = dirname(__FILE__);
app/clients_dml.php+1 −1 modified@@ -2,7 +2,7 @@ // Data functions (insert, update, delete, form) for table clients -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ function clients_insert() {
app/clients_view.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ $currDir=dirname(__FILE__);
app/invoice_items_autofill.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ $currDir = dirname(__FILE__);
app/invoice_items_dml.php+1 −1 modified@@ -2,7 +2,7 @@ // Data functions (insert, update, delete, form) for table invoice_items -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ function invoice_items_insert() {
app/invoice_items_view.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ $currDir=dirname(__FILE__);
app/invoices_autofill.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ $currDir = dirname(__FILE__);
app/invoices_dml.php+1 −1 modified@@ -2,7 +2,7 @@ // Data functions (insert, update, delete, form) for table invoices -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ function invoices_insert() {
app/invoices_view.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ $currDir=dirname(__FILE__);
app/item_prices_autofill.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ $currDir = dirname(__FILE__);
app/item_prices_dml.php+1 −1 modified@@ -2,7 +2,7 @@ // Data functions (insert, update, delete, form) for table item_prices -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ function item_prices_insert() {
app/item_prices_view.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ $currDir=dirname(__FILE__);
app/items_autofill.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ $currDir = dirname(__FILE__);
app/items_dml.php+1 −1 modified@@ -2,7 +2,7 @@ // Data functions (insert, update, delete, form) for table items -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ function items_insert() {
app/items_view.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ $currDir=dirname(__FILE__);
app/lib.php+1 −1 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/
app/parent-children.php+2 −2 modified@@ -1,5 +1,5 @@ <?php -// This script and data application were generated by AppGini 5.81 +// This script and data application were generated by AppGini 5.83 // Download AppGini for free from https://bigprof.com/appgini/download/ /* Configuration */ @@ -191,7 +191,7 @@ foreach($childLookups as $ChildLookupField => $childConfig) { if($childConfig['parent-table'] == $ParentTable) { $TableIcon = ($childConfig['table-icon'] ? "<img src=\"{$childConfig['table-icon']}\" border=\"0\" />" : ''); - $tabLabels .= sprintf('<li%s><a href="#panel_%s-%s" id="tab_%s-%s" data-toggle="tab">%s%s</a></li>' . "\n\t\t\t\t\t",($tabLabels ? '' : ' class="active"'), $ChildTable, $ChildLookupField, $ChildTable, $ChildLookupField, $TableIcon, $childConfig['tab-label']); + $tabLabels .= sprintf('<li class="child-tab-label child-table-%s lookup-field-%s %s"><a href="#panel_%s-%s" id="tab_%s-%s" data-toggle="tab">%s%s</a></li>' . "\n\t\t\t\t\t", $ChildTable, $ChildLookupField, ($tabLabels ? '' : 'active'), $ChildTable, $ChildLookupField, $ChildTable, $ChildLookupField, $TableIcon, $childConfig['tab-label']); $tabPanels .= sprintf('<div id="panel_%s-%s" class="tab-pane%s"><img src="loading.gif" align="top" />%s</div>' . "\n\t\t\t\t", $ChildTable, $ChildLookupField, ($tabPanels ? '' : ' active'), $Translation['Loading ...']); $tabLoaders .= sprintf('post("parent-children.php", { ChildTable: "%s", ChildLookupField: "%s", SelectedID: "%s", Page: 1, SortBy: "", SortDirection: "", Operation: "get-records" }, "panel_%s-%s");' . "\n\t\t\t\t", $ChildTable, $ChildLookupField, addslashes($SelectedID), $ChildTable, $ChildLookupField); }
app/templates/clients_templateDV.html+1 −1 modified@@ -206,7 +206,7 @@ /* enable DV action buttons to float on scrolling down the form */ enable_dvab_floating(); - setTimeout(AppGini.focusFirstFormElement, 1500); + setTimeout(AppGini.focusFirstFormElement, 100); $j('form').eq(0).change(function() { if($j(this).data('already_changed')) return;
app/templates/invoice_items_templateDV.html+1 −1 modified@@ -127,7 +127,7 @@ /* enable DV action buttons to float on scrolling down the form */ enable_dvab_floating(); - setTimeout(AppGini.focusFirstFormElement, 1500); + setTimeout(AppGini.focusFirstFormElement, 100); $j('form').eq(0).change(function() { if($j(this).data('already_changed')) return;
app/templates/invoices_templateDV.html+1 −1 modified@@ -238,7 +238,7 @@ /* enable DV action buttons to float on scrolling down the form */ enable_dvab_floating(); - setTimeout(AppGini.focusFirstFormElement, 1500); + setTimeout(AppGini.focusFirstFormElement, 100); $j('form').eq(0).change(function() { if($j(this).data('already_changed')) return;
app/templates/item_prices_templateDV.html+1 −1 modified@@ -89,7 +89,7 @@ /* enable DV action buttons to float on scrolling down the form */ enable_dvab_floating(); - setTimeout(AppGini.focusFirstFormElement, 1500); + setTimeout(AppGini.focusFirstFormElement, 100); $j('form').eq(0).change(function() { if($j(this).data('already_changed')) return;
app/templates/items_templateDV.html+1 −1 modified@@ -97,7 +97,7 @@ /* enable DV action buttons to float on scrolling down the form */ enable_dvab_floating(); - setTimeout(AppGini.focusFirstFormElement, 1500); + setTimeout(AppGini.focusFirstFormElement, 100); $j('form').eq(0).change(function() { if($j(this).data('already_changed')) return;
online invoicing system.axp+1 −1 modified@@ -1,4 +1,4 @@ -<database><databaseName>online_inovicing_system</databaseName><databaseUser></databaseUser><databasePassword></databasePassword><databaseServer>localhost</databaseServer><charEncoding>UTF-8</charEncoding><noMySQLEncoding>False</noMySQLEncoding><timeFormat>12</timeFormat><rtl>False</rtl><timeZone>Europe/London</timeZone><hideNavMenu>False</hideNavMenu><hideLogin>False</hideLogin><adminServerStatus>True</adminServerStatus><sortTablesAlphabetically>False</sortTablesAlphabetically><styleSheetFile></styleSheetFile><themeFile>bootstrap.css</themeFile><theme3D>False</theme3D><themeCompact>True</themeCompact><scrollStyle>0</scrollStyle><dateFormat>2</dateFormat><dateSeparator>4</dateSeparator><version>5.81</version><lastGenDate>2019-12-17 15:39:55</lastGenDate><outputFolder>C:\xampp\htdocs\online-invoicing-system\app</outputFolder><autoCompleteSize>0</autoCompleteSize><homePageTheme></homePageTheme><filesToKeep><![CDATA[|]]></filesToKeep><filesToOverwrite><![CDATA[|thumbnail.php|link.php|checkMemberID.php|incCommon.php|parent-children.php|ajax_combo.php|admin\pageAssignOwners.php|admin\pageChangeMemberStatus.php|admin\pageDeleteGroup.php|admin\pageDeleteMember.php|admin\pageDeleteRecord.php|admin\pageEditGroup.php|admin\pageEditMember.php|admin\pageEditMemberPermissions.php|admin\pageEditOwnership.php|admin\pageHome.php|admin\pageMail.php|admin\pagePrintRecord.php|admin\pageSender.php|admin\pageSettings.php|admin\pageTransferOwnership.php|admin\pageViewGroups.php|admin\pageViewMembers.php|admin\pageViewRecords.php|admin\incCommon.php|admin\incFunctions.php|admin\index.php|admin\pageUploadCSV.php|admin\pageRebuildThumbnails.php|datalist.php|combo.class.php|date_combo.class.php|data_combo.class.php|defaultFilters.php|lib.php|setup.php|settings-manager.php|updateDB.php|ci_input.php|clients_view.php|clients_dml.php|clients_autofill.php|invoices_view.php|invoices_dml.php|invoices_autofill.php|invoice_items_view.php|invoice_items_dml.php|invoice_items_autofill.php|header.php|footer.php|index.html|language.php|defaultLang.php|index.php|home.php|login.php|membership_signup.php|membership_thankyou.php|membership_passwordReset.php|membership_profile.php|admin\incFooter.php|admin\incHeader.php|templates\clients_templateTV.html|templates\clients_templateTVS.html|templates\clients_templateDV.html|templates\clients_templateDVP.html|templates\children-clients.php|templates\invoices_templateTV.html|templates\invoices_templateTVS.html|templates\invoices_templateDV.html|templates\invoices_templateDVP.html|templates\children-invoices.php|templates\invoice_items_templateTV.html|templates\invoice_items_templateTVS.html|templates\invoice_items_templateDV.html|templates\invoice_items_templateDVP.html|templates\children-invoice_items.php|admin\adminStyles.css|admin\toolTipData.js|admin\toolTips.js|common.js.php|dynamic.css.php|blank.gif|table.gif|update.gif|Exit.gif|images\blank.gif|checked.gif|checkednot.gif|loading.gif|nicEdit.js|nicEditorIcons.gif|photo.gif|handshake.jpg|new.png|spinner.gif|admin\images\add_icon.gif|admin\images\approve_icon.gif|admin\images\data_icon.gif|admin\images\delete_icon.gif|admin\images\edit_icon.gif|admin\images\helpBg.gif|admin\images\mail_icon.gif|admin\images\member_icon.gif|admin\images\members_icon.gif|admin\images\stop_icon.gif|admin\images\view_icon.gif|admin\images\home.gif|logo.png|ajax_check_unique.php|ajax_check_login.php|ajax_admin_tools.php|admin\pageRebuildFields.php|admin\getUsers.php|admin\ajax-maintenance-mode.php|db.php|templates\clients-ajax-cache.php|templates\invoices-ajax-cache.php|templates\invoice_items-ajax-cache.php|items_view.php|items_dml.php|items_autofill.php|templates\items-ajax-cache.php|language-admin.php|templates\children-clients-printable.php|templates\children-invoices-printable.php|templates\children-invoice_items-printable.php|templates\items_templateTV.html|templates\items_templateTVS.html|templates\items_templateDV.html|templates\items_templateDVP.html|templates\children-items.php|templates\children-items-printable.php|hooks\README.html|admin\pageBackupRestore.php|item_prices_view.php|item_prices_dml.php|item_prices_autofill.php|templates\item_prices-ajax-cache.php|templates\item_prices_templateTV.html|templates\item_prices_templateTVS.html|templates\item_prices_templateDV.html|templates\item_prices_templateDVP.html|templates\children-item_prices.php|templates\children-item_prices-printable.php|ajax-update-calculated-fields.php|admin\pageServerStatus.php|admin\app-documentation.php|cli-update-calculated-fields.php|]]></filesToOverwrite><homepageFirstTableDoubleWidth>False</homepageFirstTableDoubleWidth><homepagePanelHeight>100</homepagePanelHeight><homepageTablesPerRow>4</homepageTablesPerRow><groups><![CDATA[None]]></groups><showTechnicalDocumentationAdminArea>False</showTechnicalDocumentationAdminArea><technicalDocumentationApp><![CDATA[]]></technicalDocumentationApp><table><name>invoices</name><allowInsert>False</allowInsert><allowUpdate>False</allowUpdate><allowCSV>True</allowCSV><allowDelete>False</allowDelete><allowDeleteOfParents>False</allowDeleteOfParents><allowFilters>True</allowFilters><filterFirst>False</filterFirst><allowPrint>True</allowPrint><allowMassDelete>True</allowMassDelete><homepageShowCount>True</homepageShowCount><allowDVPrint>True</allowDVPrint><allowSavingFilters>True</allowSavingFilters><allowSelection>True</allowSelection><hideSaveNewWhenEditing>False</hideSaveNewWhenEditing><allowSorting>True</allowSorting><caption><![CDATA[Invoices]]></caption><description><![CDATA[]]></description><detailViewLabel><![CDATA[Invoice data]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>50</recordsPerPage><redirectAfterInsert><![CDATA[invoices_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks>invoice_items;</lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>2</defaultSortField><defaultSortDirection>desc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[invoice_items&col;1&col;1&col;Invoice items&col;1&col;1&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;]]></parentChildrenSettings><tableIcon>attributes_display.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>0</groupID><allowHomepageAddNew>True</allowHomepageAddNew><TVTemplateID>horizontal</TVTemplateID><TVTemplateHasTitle>False</TVTemplateHasTitle><TVTemplateHideCaptions>False</TVTemplateHideCaptions><TVTemplateImageWidth>25%</TVTemplateImageWidth><TVClasses></TVClasses><DVClasses></DVClasses><technicalDocumentation><![CDATA[]]></technicalDocumentation><field><caption><![CDATA[ID]]></caption><description><![CDATA[]]></description><name>id</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>True</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>True</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Code]]></caption><description><![CDATA[]]></description><name>code</name><dataType>15</dataType><length>20</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>True</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>60</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>10</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Status]]></caption><description><![CDATA[]]></description><name>status</name><dataType>15</dataType><length>20</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>True</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[Unpaid]]></default><columnWidth>70</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[Unpaid;;Paid;;Cancelled]]></CSValueList><CSValueListType>2</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>12</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Date due]]></caption><description><![CDATA[]]></description><name>date_due</name><dataType>9</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[1]]></default><columnWidth>100</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>1</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client]]></caption><description><![CDATA[]]></description><name>client</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>250</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>name</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`name` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>True</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>2</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client contact]]></caption><description><![CDATA[]]></description><name>client_contact</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>200</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>contact</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`contact` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>3</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client address]]></caption><description><![CDATA[]]></description><name>client_address</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>address</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`address` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>4</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client phone]]></caption><description><![CDATA[]]></description><name>client_phone</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>100</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>phone</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`phone` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>5</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client email]]></caption><description><![CDATA[]]></description><name>client_email</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>50</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>email</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`email` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>6</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client website]]></caption><description><![CDATA[]]></description><name>client_website</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>website</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`website` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>8</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client comments]]></caption><description><![CDATA[]]></description><name>client_comments</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>comments</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`comments` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>7</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[9]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Subtotal]]></caption><description><![CDATA[Automatically calculated from invoice items.]]></description><name>subtotal</name><dataType>8</dataType><length>9</length><precision>2</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>True</readOnly><index>14</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>True</calculatedField><calculatedFieldSQL><![CDATA[SELECT IFNULL(ROUND(SUM(`invoice_items`.`unit_price` * `invoice_items`.`qty`), 2), 0.00) FROM `invoices` +<database><databaseName>online_inovicing_system</databaseName><databaseUser></databaseUser><databasePassword></databasePassword><databaseServer>localhost</databaseServer><charEncoding>UTF-8</charEncoding><noMySQLEncoding>False</noMySQLEncoding><timeFormat>12</timeFormat><rtl>False</rtl><timeZone>Europe/London</timeZone><hideNavMenu>False</hideNavMenu><hideLogin>False</hideLogin><adminServerStatus>True</adminServerStatus><sortTablesAlphabetically>False</sortTablesAlphabetically><styleSheetFile></styleSheetFile><themeFile>bootstrap.css</themeFile><theme3D>False</theme3D><themeCompact>True</themeCompact><scrollStyle>0</scrollStyle><dateFormat>2</dateFormat><dateSeparator>4</dateSeparator><version>5.83</version><lastGenDate>2020-07-13 17:05:20</lastGenDate><outputFolder>C:\xampp\htdocs\online-invoicing-system\app</outputFolder><autoCompleteSize>0</autoCompleteSize><homePageTheme></homePageTheme><filesToKeep><![CDATA[|]]></filesToKeep><filesToOverwrite><![CDATA[|thumbnail.php|link.php|checkMemberID.php|incCommon.php|parent-children.php|ajax_combo.php|admin\pageAssignOwners.php|admin\pageChangeMemberStatus.php|admin\pageDeleteGroup.php|admin\pageDeleteMember.php|admin\pageDeleteRecord.php|admin\pageEditGroup.php|admin\pageEditMember.php|admin\pageEditMemberPermissions.php|admin\pageEditOwnership.php|admin\pageHome.php|admin\pageMail.php|admin\pagePrintRecord.php|admin\pageSender.php|admin\pageSettings.php|admin\pageTransferOwnership.php|admin\pageViewGroups.php|admin\pageViewMembers.php|admin\pageViewRecords.php|admin\incCommon.php|admin\incFunctions.php|admin\index.php|admin\pageUploadCSV.php|admin\pageRebuildThumbnails.php|datalist.php|combo.class.php|date_combo.class.php|data_combo.class.php|defaultFilters.php|lib.php|setup.php|settings-manager.php|updateDB.php|ci_input.php|clients_view.php|clients_dml.php|clients_autofill.php|invoices_view.php|invoices_dml.php|invoices_autofill.php|invoice_items_view.php|invoice_items_dml.php|invoice_items_autofill.php|header.php|footer.php|index.html|language.php|defaultLang.php|index.php|home.php|login.php|membership_signup.php|membership_thankyou.php|membership_passwordReset.php|membership_profile.php|admin\incFooter.php|admin\incHeader.php|templates\clients_templateTV.html|templates\clients_templateTVS.html|templates\clients_templateDV.html|templates\clients_templateDVP.html|templates\children-clients.php|templates\invoices_templateTV.html|templates\invoices_templateTVS.html|templates\invoices_templateDV.html|templates\invoices_templateDVP.html|templates\children-invoices.php|templates\invoice_items_templateTV.html|templates\invoice_items_templateTVS.html|templates\invoice_items_templateDV.html|templates\invoice_items_templateDVP.html|templates\children-invoice_items.php|admin\adminStyles.css|admin\toolTipData.js|admin\toolTips.js|common.js.php|dynamic.css.php|blank.gif|table.gif|update.gif|Exit.gif|images\blank.gif|checked.gif|checkednot.gif|loading.gif|nicEdit.js|nicEditorIcons.gif|photo.gif|handshake.jpg|new.png|spinner.gif|admin\images\add_icon.gif|admin\images\approve_icon.gif|admin\images\data_icon.gif|admin\images\delete_icon.gif|admin\images\edit_icon.gif|admin\images\helpBg.gif|admin\images\mail_icon.gif|admin\images\member_icon.gif|admin\images\members_icon.gif|admin\images\stop_icon.gif|admin\images\view_icon.gif|admin\images\home.gif|logo.png|ajax_check_unique.php|ajax_check_login.php|ajax_admin_tools.php|admin\pageRebuildFields.php|admin\getUsers.php|admin\ajax-maintenance-mode.php|db.php|templates\clients-ajax-cache.php|templates\invoices-ajax-cache.php|templates\invoice_items-ajax-cache.php|items_view.php|items_dml.php|items_autofill.php|templates\items-ajax-cache.php|language-admin.php|templates\children-clients-printable.php|templates\children-invoices-printable.php|templates\children-invoice_items-printable.php|templates\items_templateTV.html|templates\items_templateTVS.html|templates\items_templateDV.html|templates\items_templateDVP.html|templates\children-items.php|templates\children-items-printable.php|hooks\README.html|admin\pageBackupRestore.php|item_prices_view.php|item_prices_dml.php|item_prices_autofill.php|templates\item_prices-ajax-cache.php|templates\item_prices_templateTV.html|templates\item_prices_templateTVS.html|templates\item_prices_templateDV.html|templates\item_prices_templateDVP.html|templates\children-item_prices.php|templates\children-item_prices-printable.php|ajax-update-calculated-fields.php|admin\pageServerStatus.php|admin\app-documentation.php|cli-update-calculated-fields.php|]]></filesToOverwrite><homepageFirstTableDoubleWidth>False</homepageFirstTableDoubleWidth><homepagePanelHeight>100</homepagePanelHeight><homepageTablesPerRow>4</homepageTablesPerRow><groups><![CDATA[None]]></groups><showTechnicalDocumentationAdminArea>False</showTechnicalDocumentationAdminArea><technicalDocumentationApp><![CDATA[]]></technicalDocumentationApp><table><name>invoices</name><allowInsert>False</allowInsert><allowUpdate>False</allowUpdate><allowCSV>True</allowCSV><allowDelete>False</allowDelete><allowDeleteOfParents>False</allowDeleteOfParents><allowFilters>True</allowFilters><filterFirst>False</filterFirst><allowPrint>True</allowPrint><allowMassDelete>True</allowMassDelete><homepageShowCount>True</homepageShowCount><allowDVPrint>True</allowDVPrint><allowSavingFilters>True</allowSavingFilters><allowSelection>True</allowSelection><hideSaveNewWhenEditing>False</hideSaveNewWhenEditing><allowSorting>True</allowSorting><caption><![CDATA[Invoices]]></caption><description><![CDATA[]]></description><detailViewLabel><![CDATA[Invoice data]]></detailViewLabel><hideTableView>True</hideTableView><quickSearch>1</quickSearch><recordsPerPage>50</recordsPerPage><redirectAfterInsert><![CDATA[invoices_view.php?SelectedID=#ID#]]></redirectAfterInsert><filterCount>10</filterCount><lstChildrenLinks>invoice_items;</lstChildrenLinks><separateDV>True</separateDV><hideLinkHomepage>False</hideLinkHomepage><hideLinkNavMenu>False</hideLinkNavMenu><defaultSortField>2</defaultSortField><defaultSortDirection>desc</defaultSortDirection><childrenLinksTV><![CDATA[]]></childrenLinksTV><parentChildrenSettings><![CDATA[invoice_items&col;1&col;1&col;Invoice items&col;1&col;1&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;&row;]]></parentChildrenSettings><tableIcon>attributes_display.png</tableIcon><tablePaginationAlignment>0</tablePaginationAlignment><enableDVABFloating>True</enableDVABFloating><groupID>0</groupID><allowHomepageAddNew>True</allowHomepageAddNew><TVTemplateID>horizontal</TVTemplateID><TVTemplateHasTitle>False</TVTemplateHasTitle><TVTemplateHideCaptions>False</TVTemplateHideCaptions><TVTemplateImageWidth>25%</TVTemplateImageWidth><TVClasses></TVClasses><DVClasses></DVClasses><technicalDocumentation><![CDATA[]]></technicalDocumentation><field><caption><![CDATA[ID]]></caption><description><![CDATA[]]></description><name>id</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>True</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>True</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>0</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>right</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Code]]></caption><description><![CDATA[]]></description><name>code</name><dataType>15</dataType><length>20</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>True</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>60</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>10</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Status]]></caption><description><![CDATA[]]></description><name>status</name><dataType>15</dataType><length>20</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>True</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[Unpaid]]></default><columnWidth>70</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[Unpaid;;Paid;;Cancelled]]></CSValueList><CSValueListType>2</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>12</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Date due]]></caption><description><![CDATA[]]></description><name>date_due</name><dataType>9</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>False</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[1]]></default><columnWidth>100</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField></parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField></parentIDField><parentTable></parentTable><useDefaultDVSQL>False</useDefaultDVSQL><customDVSQL><![CDATA[]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>1</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client]]></caption><description><![CDATA[]]></description><name>client</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>250</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>name</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`name` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>True</inheritPermissions><autoFill>False</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>2</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client contact]]></caption><description><![CDATA[]]></description><name>client_contact</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>200</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>contact</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`contact` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>3</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client address]]></caption><description><![CDATA[]]></description><name>client_address</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>address</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`address` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>4</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client phone]]></caption><description><![CDATA[]]></description><name>client_phone</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>100</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>phone</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`phone` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>False</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>5</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client email]]></caption><description><![CDATA[]]></description><name>client_email</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>50</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>email</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`email` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueListType>0</CSValueListType><parentDVLink>1</parentDVLink><hidden>True</hidden><hideInDetailView>False</hideInDetailView><notFiltered>False</notFiltered><readOnly>False</readOnly><index>6</index><textarea>False</textarea><htmlarea>False</htmlarea><linkBehavior>0</linkBehavior><linkDisplay>0</linkDisplay><linkDisplayField></linkDisplayField><checkBox>False</checkBox><dataFormat><![CDATA[0]]></dataFormat><lookupRadio>False</lookupRadio><filterBy></filterBy><alignmentTV>left</alignmentTV><embed></embed><embedDVWidth>0</embedDVWidth><embedDVHeight>0</embedDVHeight><embedTVWidth>0</embedTVWidth><embedTVHeight>0</embedTVHeight><calculatedField>False</calculatedField><calculatedFieldSQL><![CDATA[]]></calculatedFieldSQL><technicalDocumentation><![CDATA[]]></technicalDocumentation></field><field><caption><![CDATA[Client website]]></caption><description><![CDATA[]]></description><name>client_website</name><dataType>4</dataType><length>0</length><precision>0</precision><autoIncrement>False</autoIncrement><binary>False</binary><notNull>False</notNull><primaryKey>False</primaryKey><unique>False</unique><unsigned>True</unsigned><showColumnSum>False</showColumnSum><zeroFill>False</zeroFill><default><![CDATA[]]></default><columnWidth>150</columnWidth><forcedWidth>False</forcedWidth><maxLengthInTableView>0</maxLengthInTableView><allowImageUpload>False</allowImageUpload><tableImage>False</tableImage><thumbTVFullsize>False</thumbTVFullsize><thumbTVZoom>False</thumbTVZoom><thumbTVHeight>0</thumbTVHeight><thumbTVWidth>0</thumbTVWidth><detailImage>False</detailImage><thumbDVFullsize>False</thumbDVFullsize><thumbDVZoom>False</thumbDVZoom><thumbDVHeight>0</thumbDVHeight><thumbDVWidth>0</thumbDVWidth><tableLink>False</tableLink><detailLink>False</detailLink><maxUploadSize>0</maxUploadSize><allowedFileTypes></allowedFileTypes><deleteFiles>False</deleteFiles><noFileRename>False</noFileRename><parentCaptionField>website</parentCaptionField><parentCaptionField2></parentCaptionField2><parentCaptionSeparator><![CDATA[]]></parentCaptionSeparator><parentIDField>id</parentIDField><parentTable>clients</parentTable><useDefaultDVSQL>True</useDefaultDVSQL><customDVSQL><![CDATA[SELECT `clients`.`id`, `clients`.`website` FROM `clients` ORDER BY 2]]></customDVSQL><inheritPermissions>False</inheritPermissions><autoFill>True</autoFill><CSValueList><![CDATA[]]></CSValueList><CSValueList ... [truncated]
Vulnerability mechanics
Generated on May 9, 2026. Inputs: CWE entries + fix-commit diffs from this CVE's patches. Citations validated against bundle.
References
2- github.com/bigprof-software/online-invoicing-system/releases/tag/3.0mitrex_refsource_MISC
- labs.ingredous.com/2020/07/13/ois-transfer-csrf/mitrex_refsource_MISC
News mentions
0No linked articles in our index yet.