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);
