Example #1
0
function GetDb()
{
    global $db;
    global $dbaddr, $dbuser, $dbpwd, $dbname;
    if (null == $db) {
        $db = new db_sql();
        ShowMsg("create new db");
        $db->connect($dbaddr, $dbuser, $dbpwd, $dbname);
        ShowMsg("create new db ok");
    }
    return $db;
}
Example #2
0
 public static function getInstance()
 {
     if (self::$db_obj === null) {
         self::$objekt = new db_sql();
     }
     return self::$db_obj;
 }
Example #3
0
    $tmp = substr($_SERVER['PHP_SELF'], 0, strpos($_SERVER['PHP_SELF'], $DBDIR));
} else {
    $tmp = $_SERVER['PHP_SELF'];
}
if (empty($_SERVER['HTTP_HOST'])) {
    $baseurl = "http://{$_SERVER['HTTP_HOST']}" . substr($tmp, 0, strrpos($tmp, '/'));
} else {
    $baseurl = "http://{$_SERVER['HTTP_HOST']}" . substr($tmp, 0, strrpos($tmp, '/'));
}
if ($gzipcompress && function_exists('ob_gzhandler') && CURSCRIPT != 'wap') {
    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;
Example #4
0
define('FORMHASH', form_hash());
$magic_quotes_gpc = get_magic_quotes_gpc();
if (!$magic_quotes_gpc) {
    $_POST = daddslashes($_POST);
    $_GET = daddslashes($_GET);
    $_FILES = daddslashes($_FILES);
}
///////////////////////////////////运行参数/////////////////////////////////////////
$version = '3.2';
$timestamp = time();
$PHP_SELF = $_SERVER['PHP_SELF'] ? $_SERVER['PHP_SELF'] : $_SERVER['SCRIPT_NAME'];
$QUERY_STRING = empty($_SERVER['QUERY_STRING']) ? '' : '?' . $_SERVER['QUERY_STRING'];
$boardurl = 'http://' . $_SERVER['HTTP_HOST'] . preg_replace("/\\/+(api|archiver|wap)?\\/*\$/i", '', substr($PHP_SELF, 0, strrpos($PHP_SELF, '/'))) . '/';
$onlineip = $_SERVER['REMOTE_ADDR'] ? $_SERVER['REMOTE_ADDR'] : '0.0.0.0';
$command = empty($_POST['command']) ? $_GET['command'] : $_POST['command'];
$dblink = new db_sql();
$dblink->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
unset($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
$_DCOOKIE = $_DCACHE = array();
$prelength = strlen($cookiepre);
foreach ($_COOKIE as $key => $val) {
    if (substr($key, 0, $prelength) == $cookiepre) {
        $_DCOOKIE[substr($key, $prelength)] = daddslashes($val);
    }
}
unset($prelength);
list($cyask_uid, $cyask_user, $cyask_pw) = isset($_DCOOKIE['compound']) ? explode("\t", authcode($_DCOOKIE['compound'], 'DECODE', $cyask_key)) : array(0, '', '');
$cyask_uid = intval($cyask_uid);
$styleid = $_DCOOKIE['styleid'] ? $_DCOOKIE['styleid'] : 1;
///////////////////////提取身份///////////////////////////
if ($cyask_uid) {
Example #5
0
 public function __construct()
 {
     $this->db = db_sql::getInstance();
 }
Example #6
0
    !API_UPDATECLIENT && exit(API_RETURN_FORBIDDEN);
    $post = uc_unserialize(file_get_contents('php://input'));
    $cachefile = DISCUZ_ROOT . './uc_client/data/cache/settings.php';
    $fp = fopen($cachefile, 'w');
    $s = "<?php\r\n";
    $s .= '$_CACHE[\'settings\'] = ' . var_export($post, TRUE) . ";\r\n";
    fwrite($fp, $s);
    fclose($fp);
    exit(API_RETURN_SUCCEED);
} elseif ($action == 'updatecredit') {
    !UPDATECREDIT && exit(API_RETURN_FORBIDDEN);
    $credit = intval($get['credit']);
    $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);
Example #7
0
    echo $lang['check_admin_validity'];
    ?>

        <tr>
          <td>
            <hr noshade align="center" width="100%" size="1">
          </td>
        </tr>
        <tr>
          <td><b><font color="#FF0000">&gt;</font><font color="#000000"> <?php 
    echo $lang['select_db'];
    ?>
</font></b></td>
        </tr>
<?php 
    $db = new db_sql();
    $db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
    $db->select_db($dbname);
    echo "        <tr>\n";
    echo "          <td>{$lang['select_db']} {$dbname} " . result(1, 0) . "</td>\n";
    echo "        </tr>\n";
    echo "        <tr>\n";
    echo "          <td>\n";
    echo "            <hr noshade align=\"center\" width=\"100%\" size=\"1\">\n";
    echo "          </td>\n";
    echo "        </tr>\n";
    echo "        <tr>\n";
    echo "          <td><b><font color=\"#FF0000\">&gt;</font><font color=\"#000000\"> {$lang['create_table']}</font></b></td>\n";
    echo "        </tr>\n";
    echo "        <tr>\n";
    echo "          <td>\n";
Example #8
0
            <input type="button" name="exit" value="<?php 
        echo $lang['exit'];
        ?>
" style="height: 25" onClick="javascript: window.close();">
          </td>
        </tr>

        </form>
<?php 
    }
} elseif ($action == 'install') {
    $username = $_POST['username'];
    $password = $_POST['password'];
    include CYASK_ROOT . '/config.inc.php';
    include CYASK_ROOT . '/include/db_' . $database . '.php';
    $db = new db_sql();
    $db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
    $db->select_db($dbname);
    ?>
        <tr>
          <td><b><?php 
    echo $lang['current_process'];
    ?>
 </b><font color="#0000EE"> <?php 
    echo $lang['installing'];
    ?>
</font></td>
        </tr>
        <tr>
          <td>
            <hr noshade align="center" width="100%" size="1">
Example #9
0
function OnCheckRegId()
{
    ShowMsg("OnCheckRegId.");
    $userid = $_GET['memberid'];
    global $db;
    global $dbaddr, $dbuser, $dbpwd, $dbname;
    if (!$db) {
        $db = new db_sql();
        $db->connect($dbaddr, $dbuser, $dbpwd, $dbname);
        ShowMsg("receate db .");
    }
    if (!$db) {
        return;
    }
    $sql = "select userid from tb_members where userid='" . $userid . "'";
    ShowMsg("query db width ." . $sql);
    $query = $db->query($sql);
    if (!$query) {
        echo GetErrorResult("CHECK_MEM_ID", 0);
        $db->close();
        return;
    }
    $count = $db->num_rows($query);
    $db->close();
    if ($count > 0) {
        echo GetErrorResult("CHECK_MEM_ID", 2);
    } else {
        echo GetErrorResult("CHECK_MEM_ID", 0);
    }
    return TRUE;
}