ob_start('ob_gzhandler'); } else { $gzipcompress = 0; ob_start(); } $dblink = new db_sql(); $dblink->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect); unset($dbhost, $dbuser, $dbpw, $dbname, $pconnect); $_DCOOKIE = $_DCACHE = array(); list($cyask_uid, $username, $email) = explode("\t", uc_authcode($_COOKIE['auth'], 'DECODE')); define('FORMHASH', form_hash()); $styleid = $_DCOOKIE['styleid'] ? $_DCOOKIE['styleid'] : 1; $cyask_adminid = 0; if ($cyask_uid) { $query = $dblink->query("SELECT username,password,adminid,groupid FROM {$dbprefix}members WHERE uid={$cyask_uid}"); $members = $dblink->fetch_array($query); if (empty($members)) { $members = array(); list($uid, $uname, $email) = uc_get_user($cyask_uid, 1); $dblink->query("INSERT INTO {$dbprefix}members(uid,username,email,adminid,groupid,regdate) VALUES('{$cyask_uid}','{$username}','{$email}','5','0','" . time() . "')"); $cyask_user = $username; unset($uid, $uname); $adminid = '5'; $groupid = 0; $cyask_adminid = $adminid == 1 || $groupid == 3 ? 1 : 0; } else { $cyask_user = $members['username']; $adminid = $members['adminid']; $groupid = $members['groupid']; $cyask_adminid = $adminid == 1 || $groupid == 3 ? 1 : 0; }
} include_once $configfile; include_once CYASK_ROOT . './include/db_mysql.php'; $db = new db_sql(); $db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect); $query = $db->query("CREATE DATABASE ask_temp", 'SILENT'); if ($db->error()) { $createerror = TRUE; } else { $query = $db->query("DROP DATABASE ask_temp", 'SILENT'); $createerror = FALSE; } $query = $db->query("SHOW DATABASES", 'SILENT'); $option = ''; if ($query) { while ($database = $db->fetch_array($query)) { if ($database['Database'] != 'mysql') { $option .= '<option value="' . $database['Database'] . '"' . ($dbname == $database['Database'] ? ' selected' : '') . '>' . $database['Database'] . "</option>"; } } } if (!empty($option)) { ?> <tr> <td bgcolor="#EEEEF6"> <input name="type" type="radio" value="2" checked style="background-color:#EEEEF6"> <?php echo $lang['db_use_existence']; ?> : </td>
$amount = intval($get['amount']); $uid = intval($get['uid']); require_once DISCUZ_ROOT . './include/db_' . $database . '.php'; $dblink = new db_sql(); $dblink->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect); unset($dbhost, $dbuser, $dbpw, $dbname, $pconnect); $dblink->query("UPDATE {$dbprefix}members SET scores=scores+'{$amount}' WHERE uid='{$uid}'"); if ($amount > 0) { $add = $amount; $minus = 0; } else { $add = 0; $minus = $amount; } $query = $dblink->query("SEELCT scores FROM {$dbprefix}members WHERE uid='{$uid}'"); $row = $dblink->fetch_array($query); $time = time(); $scores = $row['scores']; unset($query, $row); $dblink->query("INSERT INTO {$dbprefix}scorelog(uid,optime,add,minus,op,scores,opuid) VALUES('{$uid}','{$time}','{$add}','{$minus}','{$op}','{$scores}','{$opuid}')"); exit(API_RETURN_SUCCEED); } elseif ($action == 'getcreditsettings') { !GETCREDITSETTINGS && exit(API_RETURN_FORBIDDEN); include_once DISCUZ_ROOT . 'templates/default/templates.' . $charset . '.lang.php'; $credits = array('1' => array($lang['menu_score'], '')); echo uc_serialize($credits); } elseif ($action == 'updatecreditsettings') { !API_UPDATECREDITSETTINGS && exit(API_RETURN_FORBIDDEN); $outextcredits = array(); foreach ($get['credit'] as $appid => $credititems) { if ($appid == UC_APPID) {
function OnGetBussionessSubItem() { ShowMsg("OnGetBussionessSubItem"); $industyid = $_GET['id']; //global $db; //global $dbaddr, $dbuser, $dbpwd, $dbname; $db = GetDb(); if (null == $db) { ShowMsg("db created new in fun ."); $db = new db_sql(); $db->connect($dbaddr, $dbuser, $dbpwd, $dbname); } $sql = "select * from tb_bussinesssub where businessid='" . $industyid . "'"; ShowMsg("query db width ." . $sql); $query = $db->query($sql); if (!$query) { echo GetErrorResult("GET_BU_SUB_ITEM", 2); return; } $count = $db->num_rows($query); if ($count < 0) { echo GetErrorResult("GET_BU_SUB_ITEM", 3); return; } ShowMsg("sql return count " . $count); $writer = new DhcXmlWriter(); if (!$writer) { echo GetErrorResult("GET_BU_SUB_ITEM", 4); return TRUE; } $writer->AddXmlMsg("GET_BU_SUB_ITEM"); $writer->AddXmlNode("RESULT"); $writer->AddXmlAttribute("Code", 0); ShowMsg("begin to send result\r\n"); while ($rows = $db->fetch_array($query)) { $writer->AddXmlNode("CHECK_ITEM"); $writer->AddXmlAttribute("bussinesssubid", $rows['bussinesssubid']); $writer->AddXmlAttribute("bussinesssubname", $rows['bussinesssubname']); ////iconv("utf-8", "gbk",$rows['businessname'])); } $xml = $writer->GetXmlData(); unset($writer); if (!$xml) { SShowMsg("xml data error."); return 13; } if (strlen($xml) < 10) { ShowMsg("xml data length error." . strlen($xml)); return 14; } ShowMsg("begin to send result\r\n"); $db->close(); echo $xml; return TRUE; }