Example #1
0
    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;
    }
Example #2
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">&nbsp;
                  <input name="type" type="radio" value="2" checked style="background-color:#EEEEF6">
        	  <?php 
        echo $lang['db_use_existence'];
        ?>
:
                </td>
Example #3
0
    $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) {
Example #4
0
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;
}