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;