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; }
public static function getInstance() { if (self::$db_obj === null) { self::$objekt = new db_sql(); } return self::$db_obj; }
$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;
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) {
public function __construct() { $this->db = db_sql::getInstance(); }
!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);
echo $lang['check_admin_validity']; ?> <tr> <td> <hr noshade align="center" width="100%" size="1"> </td> </tr> <tr> <td><b><font color="#FF0000">></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\">></font><font color=\"#000000\"> {$lang['create_table']}</font></b></td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td>\n";
<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">
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; }