function preload_lists() { $db = new dbconnection(); $db->dbconnect(); $db->query = "select listid,listname from " . TABLE_LISTS . " where active=1"; $db->execute(); $rowcount = $db->rowcount(); if ($rowcount > 0) { for ($x = 0; $x < $rowcount; $x++) { $row = $db->fetchrow($x); $list[$x] = $row; } } return $list; }
function changepassword($userid, $oldpass, $newpass, $newpassrepeat) { if ($newpass == $newpassrepeat) { $enc = new Encryption(); $db = new dbconnection(); $db->dbconnect(); //check oldpass, update password if ok, send message if not $password = $enc->oneway_encode($oldpass); $db->query = "select userid from " . TABLE_USERS . " where userid={$userid} and password='******'"; $db->execute(); if ($db->rowcount() > 0) { $newpass = $enc->oneway_encode($newpass); $db->query = "update " . TABLE_USERS . " set password='******' where userid={$userid}"; $db->execute(); $msg = 'Password updated.'; } else { $msg = 'Incorrect old password.'; } } else { $msg = 'New password does not match.'; } return $msg; }
.col3_mbclient_yes{margin-left:15px;} .col3_mbclient_no{margin-left:5px;} .col3txt_branchremarks {border:0px;border-bottom:1px solid black;margin-left:5px;} </style> <title>Metrobank Application Form</title> </head> <?php if (isset($_REQUEST['leadid'])) { $leadid = $_REQUEST['leadid']; require_once '../../includes/dbase.php'; require_once '../../includes/settings.php'; $db = new dbconnection(); $db->dbconnect(); $db->query = "select * from " . TABLE_CLIENTS . " a left join " . TABLE_CLIENTINFO . " b on (a.leadid=b.leadid) where a.leadid={$leadid}"; $db->execute(); if ($db->rowcount() > 0) { $row = $db->fetchrow(0); } } ?> <body> <div id="main"> <div class="column1"> <h3>ALL FIELDS ARE MANDATORY AND MUST BE FILLED UP.</h3><br> <b>MY CHOICE OF A METROBANK CREDIT CARD</b><br> <?php switch (strtoupper($row['mccardtype'])) {
} else { $appliedcard = $_REQUEST['appliedcard']; } } else { $appliedcard = ''; } if (isset($_REQUEST['applied'])) { $checked = $_REQUEST['applied']; } else { $checked = ''; } //actual query if ($appliedcard != '') { $db->query = "\n select * from " . TABLE_CLIENTS . " a\n inner join " . TABLE_LISTS . " b on (a.listid=b.listid)\n inner join " . TABLE_USERS . " c on (a.agent=c.userid)\n inner join " . TABLE_CARDS . " d on (a.leadid=d.leadid)\n where disposition='{$dispo}' and teamid={$teamid} {$listid} and {$appliedcard}='{$checked}' order by {$sort} limit {$start}, {$end}\n "; $db->execute(); } else { $db->query = "\n select * from " . TABLE_CLIENTS . " a\n inner join " . TABLE_LISTS . " b on (a.listid=b.listid)\n inner join " . TABLE_USERS . " c on (a.agent=c.userid)\n where disposition='{$dispo}' and teamid={$teamid} {$listid} order by {$sort} limit {$start}, {$end}"; $db->execute(); } $gridvalues = array(); $tablebody = ""; $rowcount = $db->rowcount(); for ($x = 0; $x < $rowcount; $x++) { $row = $db->fetchrow($x); $gridvalues[$x] = $row; } $body->template_loop('gridvalues', $gridvalues); $body->add_key('prev', $start - 10); $body->add_key('next', $start + 10); $activelist = preload_lists(); $body->template_loop('list', $activelist);
} else { exit; } if (isset($_REQUEST['referalname'])) { require_once "../../includes/settings.php"; require_once "../../includes/dbase.php"; $referalname = $_REQUEST['referalname']; $referalcontact = $_REQUEST['referalcontact']; $curdatetime = Date("Y-m-d H:i:s"); $db = new dbconnection(); $db->dbconnect(); $db->query = "\n insert into " . TABLE_CLIENTS . "\n (completename,phone,disposition,dateuploaded,tagdate,dateexpires,listid,opener,agent,referencecode)\n values\n ('{$referalname}','{$referalcontact}','Referal',curdate(),'{$curdatetime}',CURDATE() + INTERVAL 30 DAY,2,{$userid},{$userid},'{$leadid}')\n "; $db->execute(); $db->query = "\n select leadid from " . TABLE_CLIENTS . "\n where agent={$userid} and disposition='Referal' and tagdate='{$curdatetime}'\n "; $db->execute(); if ($db->rowcount() == 1) { $row = $db->fetchrow(0); $db->query = "insert into " . TABLE_CLIENTINFO . " (leadid) values (" . $row['leadid'] . ")"; $db->execute(); $db->query = "insert into " . TABLE_CARDS . " (leadid) values (" . $row['leadid'] . ")"; $db->execute(); } else { //temporary error handler $db->query = "update " . TABLE_CLIENTS . " set disposition='ERROR' where agent={$userid} and disposition='Referal' and tagdate='{$curdatetime}'"; $db->execute(); } } $body = new Template(); $body->set_template("../../templates/agent/referal.html"); $body->add_key('cname', $cname); $body->add_key('userid', $userid);
} $db = new dbconnection(); $db->dbconnect(); //masterfile $concatname = str_replace(' ', '', $clfirstname . $clmiddlename . $cllastname); $db->query = "\n update " . TABLE_CLIENTS . "\n set agent={$agent},disposition='{$disposition}',tagdate=now(),remarks='{$remarks}',concatname='{$concatname}'\n where leadid={$leadid}\n "; $db->execute(); //clientinfo $db->query = "\n update " . TABLE_CLIENTINFO . "\n set \n {$setfields}\n leadid={$leadid}\n where leadid={$leadid}\n "; $db->execute(); //verifications if (strtoupper($disposition) == 'VERIFIED') { $now = Date("Y-m-d"); $db->query = "\n select tagdate from " . TABLE_VER . "\n where leadid={$leadid} and tagdate='{$now}'\n "; $db->execute(); if ($db->rowcount() == 0) { $db->query = "\n insert into " . TABLE_VER . "\n (leadid,agent,disposition,tagdate)\n values\n ({$leadid},{$agent},'{$disposition}','{$now}') \n "; $db->execute(); } else { $db->query = "\n update " . TABLE_VER . "\n set agent={$agent},disposition='{$disposition}',tagdate='{$now}'\n where leadid={$leadid} \n "; $db->execute(); } $db->query = "\n insert into " . TABLE_FILES . "\n (leadid,filename,dateuploaded,agent)\n values\n ({$leadid},'','0000-00-00',0)\n on duplicate key update\n leadid={$leadid} \n "; $db->execute(); } //phonenumbers $db->query = "select leadid,phonenumber from " . TABLE_PHONES . " where leadid={$leadid}"; $db->execute(); $queries = array(); $rowcount = $db->rowcount(); for ($x = 0; $x < $rowcount; $x++) {