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 dologin($username, $password) { $enc = new Encryption(); $password = $enc->oneway_encode($password); $db = new dbconnection(); $db->dbconnect(); $db->query = "select * from " . TABLE_USERS . " where username='******' and password='******'"; $db->execute(); if ($db->rowcount() > 0) { $row = $db->fetchrow(0); $userid = $row['userid']; $ipaddr = $_SERVER['REMOTE_ADDR']; $lastlogin = Date("Y-m-d H:i:s"); $db->query = "update " . TABLE_USERS . " set lastlogin='******' where userid={$userid}"; $db->execute(); $db->query = "insert into " . TABLE_USERLOGS . " (userid,ipaddress,logdate,action)\n values ({$userid},'{$ipaddr}','{$lastlogin}','LOGIN')\n "; $db->execute(); return $row; } else { $db->dbclose(); return false; } }
.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'])) { case 'CLASSIC MASTERCARD':
} 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);