public function getAllColumns($test_type_id = -1)
{
$this->refreshNames();
$sql = "select * from test_type";
if ($test_type_id != -1) {
$sql .= " where test_type_id={$test_type_id}";
}
$data = parent::query($sql);
$rows = array();
while ($row = $data->fetch()) {
$row['test_type_id_name'] = $this->names[$row['test_type_id']];
$row['grad_test_type_id_name'] = $this->grad_test_type_id_name($row['grad_test_type_id']);
$rows[] = $row;
}
return $rows;
}
if (is_numeric($receiver) && (strlen((string) $receiver) == 11 || strlen((string) $receiver) == 10)) {
if (strlen((string) $receiver) == 11) {
$receiver = substr($receiver, 1);
}
$orig = $originator;
if (strlen((string) $originator) == 11) {
$originator = substr($originator, 1);
}
$sel = "SELECT id FROM voicechanger_web.personal_info WHERE phone LIKE '%{$originator}%';";
$result = $db2->query($sel);
$id = $result->num_rows;
$db2->close();
$db->logfile("voicechanger; {$originator} ; count: {$id}; sql : {$sel}");
$originator = $orig;
$sql_subs = "select keyword from `{$csc}`.`subscribers` where `msisdn` = '{$originator}' limit 1";
$rs_subs = $db->query($sql_subs);
$nr_subs = $rs_subs->num_rows;
$db->logfile("voicechanger; {$originator} ; {$body}; {$carrier} ; {$nr_subs} ; {$sql_subs}");
$selectResId = "SELECT resellerid FROM CGS.trunk_master WHERE csc = {$csc};";
$rs = $db->query($selectResId);
#if($nr_subs > 0 && $id > 0 ){ # <--- REMOVED PROFILE CHECKING IF ACTIVE
if ($nr_subs > 0) {
$row_subs = $rs_subs->fetch_assoc();
$rs_sub = $rs->fetch_assoc();
$resellerid = $rs_sub["resellerid"] != "" ? $rs_sub["resellerid"] : 10130;
$keyword = $row_subs['keyword'];
$sql_EXP = "Insert into `asteriskvoip`.`vc` (caller, receiver, datetime, path, tag , carrier, keyword, resellerid) values ('" . $originator . "','" . $receiver . "',now(),'',0,'{$carrier}','{$keyword}','{$resellerid}') ";
$rsEXP = $db_voip->query($sql_EXP) or print $sql_EXP;
$db->logfile("voicechanger ; {$body} [{$originator}] Insert-> {$sql_EXP}\n");
#echo "$sql_EXP"; exit;
} else {
function judgeUser()
{
$uname = (string) $_POST['uname'];
$upass = (string) $_POST['upass'];
$logtype = (int) $_POST['logtype'];
if ($logtype == 1) {
//student
$query = "select s_user from student where s_user='******' and `s_pwd`=md5('{$upass}') and state=1";
} else {
//与数据库对应 2:dept 3:school 4当然不行
$query = "select m_user from manager where m_user='******' and `m_pwd`=md5('{$upass}') and state=1";
}
$con = new DB_Connect();
$stmt = $con->query($query);
if ($stmt->fetch() == null) {
$ret = 0;
} else {
$ret = 1;
session::initial($uname, $logtype);
}
echo json_encode($ret);
}
<?php
include 'inc/class.PassHash.inc.php';
include 'inc/class.db_connect.inc.php';
$checkedFormsFields = checkFormField::cleanFormField($_POST);
DB_Connect::test();
if (isset($checkedFormsFields['save'])) {
$today = date("Ymd");
$query = 'insert into users (username, pass, name, firstName, lastName, regDate) values ("' . $checkedFormsFields['username'] . '", "' . PassHash::hash($checkedFormsFields['password']) . '", "' . $checkedFormsFields['name'] . '", "' . $checkedFormsFields['firstName'] . '", "' . $checkedFormsFields['lastName'] . '", "' . $today . '")';
$result = DB_Connect::query($query);
if ($result == 1) {
header('Location: index.php');
}
} else {
$query = 'select * from users where username = "******"';
$result = DB_Connect::query($query);
$fila = mysql_fetch_assoc($result);
if ($checkedFormsFields['validateUsername']) {
echo json_encode($fila);
} else {
if (PassHash::check_password($fila["pass"], $checkedFormsFields['password'])) {
header('Location: success.php');
}
}
}
}*/
$tmp = split(" ", strtolower(trim($body)));
$q0 = $tmp[0];
$q1 = $tmp[1];
$SRVC_TYPE = trim(strtoupper($context));
$db->logfile("chatbox [{$originator}] [{$SRVC_TYPE}] {$datex} ");
if ($SRVC_TYPE == 'CHAT') {
$db->logfile("chatbox [{$originator}] [{$SRVC_TYPE}] [" . MYSQL_CHATBOX . "]");
$body = str_ireplace($SRVC_TYPE, '', $body);
$body = trim($body);
$db->logfile("chatbox [{$originator}] [{$SRVC_TYPE}] {$body} ");
//$db = new Database($host, $user, $pass, $dbms);
//$db = new DB_Connect(MYSQL_CHATBOX, true);
$sqls = "SELECT * FROM chatbox.chatbox_question WHERE originator = '{$originator}' AND que = 1 ORDER BY id DESC LIMIT 1";
$db->logfile("chatbox [{$originator}] [{$SRVC_TYPE}] {$sqls} ");
$rss = $db->query($sqls);
$sessionid = NULL;
$operatorid = NULL;
if ($rss->num_rows > 0) {
$rows = $rss->fetch_object();
$sessionid = $rows->sessionid;
$operatorid = $rows->operatorid;
$sqlss = "SELECT * FROM chatbox.chatbox_transaction WHERE originator = '{$originator}' AND sessionid = '{$sessionid}' AND operatorid = '{$operatorid}' AND marked = 0";
$db->logfile("chatbox [{$originator}] [{$SRVC_TYPE}] {$sqlss} ");
$rsss = $db->query($sqlss);
if ($rsss->num_rows > 0) {
$que = 0;
} else {
$sessionid = NULL;
$operatorid = NULL;
$que = 1;
