requiredFiles(array( 'clientfunctions' )); $aInt->title = $aInt->lang('clients', 'mergeclient'); ob_start(); if( !$newuserid ) { echo "\n"; if( $error ) { echo "

" . $aInt->lang('clients', 'invalidid') . "

"; } echo "\n

"; echo $aInt->lang('clients', 'mergeexplain'); echo "

\n\n

getPhpSelf(); echo "?userid="; echo $userid; echo "\">\n\n\n\n\n\n

"; echo $aInt->lang('clients', 'firstclient'); echo "

"; $result = select_query('tblclients', '', array( 'id' => $userid )); $data = mysql_fetch_array($result); $useridselect = $data['id']; $firstname = $data['firstname']; $lastname = $data['lastname']; echo $firstname . " " . $lastname . " (" . $useridselect . ")"; echo "

"; echo $aInt->lang('clients', 'secondclient'); echo "

lang('invoices', 'merge'); echo "\" class=\"button\" />

"; echo $aInt->lang('clients', 'tofirst'); echo " "; echo $aInt->lang('clients', 'tosecond'); echo "

\n\n
\n

"; echo $aInt->lang('global', 'clientsintellisearch'); echo ":

\n
\n

Search Results

Matches will appear here as you type

\n\n

\n\n"; } else { check_token("WHMCS.admin.default"); $newuserid = trim($newuserid); $result = select_query('tblclients', 'id', array( 'id' => $newuserid )); $data = mysql_fetch_array($result); $newuserid = $data['id']; if( !$newuserid ) { redir("userid=" . $userid . "&error=1"); } if( $mergemethod == 'to1' ) { $resultinguserid = trim($userid); $deleteuser = trim($newuserid); } else { $resultinguserid = trim($newuserid); $deleteuser = trim($userid); } $tables_array = array( 'tblaccounts', 'tblcontacts', 'tbldomains', 'tblemails', 'tblhosting', 'tblinvoiceitems', 'tblinvoices', 'tblnotes', 'tblorders', 'tblquotes', 'tblticketreplies', 'tbltickets', 'tblactivitylog', 'tblsslorders', 'tblclientsfiles' ); foreach( $tables_array as $table ) { update_query($table, array( 'userid' => $resultinguserid ), array( 'userid' => $userid )); } update_query('tblcredit', array( 'clientid' => $resultinguserid ), array( 'clientid' => $userid )); $userid = $newuserid; foreach( $tables_array as $table ) { update_query($table, array( 'userid' => $resultinguserid ), array( 'userid' => $userid )); } update_query('tblcredit', array( 'clientid' => $resultinguserid ), array( 'clientid' => $userid )); $result = select_query('tblclients', 'credit', array( 'id' => $deleteuser )); $data = mysql_fetch_array($result); $credit = $data[0]; update_query('tblclients', array( 'credit' => "+=" . $credit ), array( 'id' => (int) $resultinguserid )); $result = select_query('tblaffiliates', '', array( 'clientid' => $deleteuser )); $data = mysql_fetch_array($result); $affid = $data['id']; if( $affid ) { $visitors = $data['visitors']; $balance = $data['balance']; $withdrawn = $data['withdrawn']; $result = select_query('tblaffiliates', '', array( 'clientid' => $resultinguserid )); $data = mysql_fetch_array($result); $newaffid = $data['id']; if( !$newaffid ) { $newaffid = insert_query('tblaffiliates', array( 'date' => "now()", 'clientid' => $resultinguserid )); } update_query('tblaffiliates', array( 'visitors' => "+=" . (int) $visitors, 'balance' => "+=" . $balance, 'withdrawn' => "+=" . $withdrawn ), array( 'id' => (int) $newaffid )); update_query('tblaffiliatesaccounts', array( 'affiliateid' => $newaffid ), array( 'affiliateid' => $affid )); update_query('tblaffiliateshistory', array( 'affiliateid' => $newaffid ), array( 'affiliateid' => $affid )); update_query('tblaffiliateswithdrawals', array( 'affiliateid' => $newaffid ), array( 'affiliateid' => $affid )); delete_query('tblaffiliates', array( 'clientid' => $deleteuser )); } logActivity("Merged User ID: " . $deleteuser . " with User ID: " . $resultinguserid, $resultinguserid); if( $resultinguserid != $deleteuser ) { deleteClient($deleteuser); } echo "\n"; } $content = ob_get_contents(); ob_end_clean(); $aInt->content = $content; $aInt->displayPopUp();