/** * 插入数据 支持批量插入 * @param boolean $replace 是否替换插入 * @return 返回插入主键值 如没有则为影响行数 出错返回false */ public function insert($replace = false) { $this->sql = ($replace ? 'REPLACE' : 'INSERT') . ' INTO ' . $this->_parseTable() . $this->_parseData('insert'); $query = $this->query($this->sql); $id = $this->db->insert_id(); return empty($id) ? $this->db->affected_rows() : $id; }
/** * 网页用户授权,用户信息插入数据库 */ public static function insertPageuserinfo($userinfo) { $db = new mysql(); $db->connect(DBHOST, DBUSER, DBPASSWORD, DBNAME); $sql = "insert into users\n (`openid`,`nickname`,`sex`,`language`,`city`,`province`,`country`,`headimgurl`) \n values(\n \n '" . $userinfo['openid'] . "',\n '" . $userinfo['nickname'] . "',\n '" . $userinfo['sex'] . "',\n '" . $userinfo['language'] . "',\n '" . $userinfo['city'] . "',\n '" . $userinfo['province'] . "',\n '" . $userinfo['country'] . "',\n '" . $userinfo['headimgurl'] . "'\n )"; $db->query($sql); $userid = $db->insert_id(); if ($userid) { return $userid; } else { return false; } }
/** * 记录微信发送的请求 * @param $request 微信发送的请求数组 * @return 返回刚刚插入的id, 失败返回false */ public static function logRequest($request) { $db = new mysql(); $db->connect(DBHOST, DBUSER, DBPASSWORD, DBNAME); $message = json_encode($request); $sql = "insert into messages(`message`) values('" . $message . "')"; $db->query($sql); $messageid = $db->insert_id(); return $messageid ? $messageid : false; }
function synlogin($user) { global $timestamp, $uc_key; list($winduid, $windid, $windpwd) = explode("\t", $this->base->strcode($user, false)); header('P3P: CP="CURa ADMa DEVa PSAo PSDo OUR BUS UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR"'); require_once "../../config/db.config.php"; require_once "../../app/include/mysql.class.php"; require_once "../../app/include/public.function.php"; require_once "../../data/plus/config.php"; $ip = fun_ip_get(); $time = time(); if ($config[sy_pw_type] == "pw_center") { $db = new mysql($db_config['dbhost'], $db_config['dbuser'], $db_config['dbpass'], $db_config['dbname'], ALL_PS, $db_config['charset']); $user_query = $db->query("SELECT * FROM {$db_config['def']}member WHERE `username`='{$windid}'"); while ($userrs = $db->fetch_array($user_query)) { $userinfo = $userrs; } //判断是否是重名用户 if ($userinfo["uid"] > 0) { if ($userinfo["pw_repeat"] != "1") { //判断账户名密码是否一致 if ($userinfo["password"] == md5($windpwd . $userinfo[salt])) { $db->query("UPDATE {$db_config['def']}member SET `pwuid`='{$winduid}' WHERE `uid`='{$userinfo['uid']}'"); $this->unset_cookie(); $this->add_cookie($userinfo[uid], $userinfo[username], $userinfo[salt], $userinfo[email], $userinfo[password]); } else { //不一致标注为重名用户 $db->query("UPDATE {$db_config['def']}member SET `pw_repeat`='1' WHERE `uid`='{$userinfo['uid']}'"); } } } else { //用户不存在 新建一个用户 $salt = substr(uniqid(rand()), -6); $pass = md5($windpwd . $salt); $db->query("INSERT INTO {$db_config['def']}member SET `username`='{$windid}',`password`='{$pass}',`salt`='{$salt}',`usertype`='1',`reg_ip`='{$ip}',`reg_date`='{$time}',`pwuid`='{$winduid}'"); $uid = $db->insert_id(); $db->query("INSERT INTO {$db_config['def']}resume SET `uid`='" . $uid . "'"); $db->query("INSERT INTO {$db_config['def']}member_statis SET `uid`='" . $uid . "'"); $this->unset_cookie(); $this->add_cookie($winduid, $windid, $salt, "", $pass); } } }
function synlogin($get, $post) { if (!API_SYNLOGIN) { return API_RETURN_FORBIDDEN; } header('P3P: CP="CURa ADMa DEVa PSAo PSDo OUR BUS UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR"'); require_once "../../data/db.config.php"; require_once "../../include/mysql.class.php"; require_once "../../include/public.function.php"; require_once "../../plus/config.php"; $ip = fun_ip_get(); $time = time(); if ($config[sy_uc_type] == "uc_center") { $db = new mysql($db_config['dbhost'], $db_config['dbuser'], $db_config['dbpass'], $db_config['dbname'], ALL_PS, $db_config['charset']); $user_query = $db->query("SELECT * FROM {$db_config['def']}member WHERE `username`='{$get['username']}'"); while ($userrs = $db->fetch_array($user_query)) { $userinfo[] = $userrs; } if ($config[sy_onedomain] != "") { $weburl = str_replace("http://www", "", $config[sy_onedomain]); } elseif ($config[sy_indexdomain] != "") { $weburl = str_replace("http://www", "", $config[sy_indexdomain]); } else { $weburl = str_replace("http://www", "", $config[sy_weburl]); } if (is_array($userinfo)) { $uid = $userinfo[0][uid]; $certokquery = $db->query("SELECT * FROM {$db_config['def']}company_cert where `uid`='{$uid} ' and `type`='1'"); while ($certrow = $db->fetch_array($certokquery)) { $certstatus = $certrow[status]; } if ($userinfo[0][username] == $get[username] && $userinfo[0][name_repeat] != "1") { $this->unset_cookie($weburl); if ($userinfo[0][password] == $get[password]) { if ($certstatus == "1" || $config[user_status] != "1" || $userinfo[0][usertype] == "2") { $this->add_cookie($weburl, $userinfo[0][uid], $userinfo[0][username], $userinfo[0][salt], $userinfo[0][email], $userinfo[0][password], $userinfo[0][usertype]); } } else { $db->query("UPDATE {$db_config['def']}member SET `password`='{$get['password']}',`email`='{$get['email']}',`salt`='{$get['salt']}' WHERE `uid`='{$uid}'"); if ($certstatus == "1" || $config[user_status] != "1") { $this->add_cookie($weburl, $userinfo[0][uid], $userinfo[0][username], $get[salt], $get[email], $get[password], $userinfo[0][usertype]); } } $db->query("UPDATE {$db_config['def']}member SET `login_ip`='{$ip}',`login_date`='{$time}',`login_hits`=`login_hits`+1 where `uid`='{$uid}'"); } } else { $db->query("INSERT INTO {$db_config['def']}member SET `username`='{$get['username']}',`password`='{$get['password']}',`email`='{$get['email']}',`salt`='{$get['salt']}',`usertype`='1',`reg_ip`='{$ip}',`reg_date`='{$time}'"); $uid = $db->insert_id(); $db->query("INSERT INTO {$db_config['def']}resume SET `uid`='" . $uid . "'"); $db->query("INSERT INTO {$db_config['def']}member_statis SET `uid`='" . $uid . "'"); $randstr = rand(10000000, 99999999); $db->query("INSERT INTO {$db_config['def']}company_cert SET `status`='0',`step`='1',`check`='{$get['email']}',`check2`='{$randstr}',`ctime`='" . mktime() . "',`type`='1',`uid`='" . $uid . "'"); $this->unset_cookie($weburl); if ($config[user_status] != "1") { $this->add_cookie($weburl, $uid, $get[username], $get[salt], $get[email], $get[password]); } } } }
function synlogin($get, $post) { if (!API_SYNLOGIN) { return API_RETURN_FORBIDDEN; } header('P3P: CP="CURa ADMa DEVa PSAo PSDo OUR BUS UNI PUR INT DEM STA PRE COM NAV OTC NOI DSP COR"'); //TODO:暂时不知道如何改成PLUS_PATH require_once $this->appdir . "config/db.config.php"; require_once $this->appdir . "app/include/mysql.class.php"; require_once $this->appdir . "app/include/public.function.php"; require_once dirname(dirname(dirname(__FILE__))) . "/data/plus/config.php"; //$ip = fun_ip_get(); $time = time(); if ($config[sy_uc_type] == "uc_center") { $db = new mysql($db_config['dbhost'], $db_config['dbuser'], $db_config['dbpass'], $db_config['dbname'], ALL_PS, $db_config['charset']); $user_query = $db->query("SELECT * FROM {$db_config['def']}member WHERE `username`='{$get['username']}'"); while ($userrs = $db->fetch_array($user_query)) { $userinfo[] = $userrs; } if ($config[sy_onedomain] != "") { $weburl = "." . $config[sy_onedomain]; } else { $weburl = str_replace("http://www", "", $config[sy_weburl]); } if (is_array($userinfo)) { $uid = $userinfo[0][uid]; $certokquery = $db->query("SELECT * FROM {$db_config['def']}company_cert where `uid`='{$uid} ' and `type`='1'"); while ($certrow = $db->fetch_array($certokquery)) { $certstatus = $certrow[status]; } //$pass = md5($userinfo[0][password].$get[salt]); if ($userinfo[0][username] == $get[username] && $userinfo[0][name_repeat] != "1") { $this->unset_cookie($weburl); if ($userinfo[0][password] == $get[password]) { if ($certstatus == "1" || $config[user_status] != "1" || $userinfo[0][usertype] == "2") { $this->add_cookie($weburl, $userinfo[0][uid], $userinfo[0][username], $userinfo[0][salt], $userinfo[0][email], $userinfo[0][password], $userinfo[0][usertype]); } } else { $db->query("UPDATE {$db_config['def']}member SET `password`='{$get['password']}',`email`='{$get['email']}',`salt`='{$get['salt']}' WHERE `uid`='{$uid}'"); if ($certstatus == "1" || $config[user_status] != "1") { $this->add_cookie($weburl, $userinfo[0][uid], $userinfo[0][username], $get[salt], $get[email], $get[password], $userinfo[0][usertype]); } } $db->query("UPDATE {$db_config['def']}member SET `login_ip`='{$ip}',`login_date`='{$time}',`login_hits`=`login_hits`+1 where `uid`='{$uid}'"); } } else { //创建用户但是无会员身份(usertype) $db->query("INSERT INTO {$db_config['def']}member SET `username`='{$get['username']}',`password`='{$get['password']}',`email`='{$get['email']}',`salt`='{$get['salt']}',`reg_ip`='{$ip}',`reg_date`='{$time}',`usertype`='0'"); $uid = $db->insert_id(); } } }
function step5($data) { if ($_POST['meta_name'] == "" || $_POST['alli_tag'] == "" || $_POST['alli_name'] == "" || $_POST['user_name'] == "" || $_POST['user_password'] == "" || $_POST['user_coords1'] == "" || $_POST['user_coords2'] == "") { return "Du musst alle Felder ausfüllen."; } echo "<div style=\"border:1px #000000 solid;width:400px;padding:3px;\"><b>Schritt 5: Abschluß der Installation</b><div style=\"text-align:left\">"; $t =& $_SESSION['install']['mysql']; $file = @fopen("../accdata.php", "w"); if (!$file) { echo "<div style=\"color:#800000\">Die Datei accdata.php konnte nicht zum schreiben öffnen. Trage die Mysqldaten bitte nachträglich ein.</div>"; } else { fwrite($file, "<?php\n // Account Daten\n \$db_info['host'] = '" . $t['host'] . "';\n \$db_info['user'] = '******'username'] . "';\n \$db_info['password'] = '******'password'] . "';\n \$db_info['dbname'] = '" . $t['database'] . "';\n \$pfadzumtick = '" . $_SESSION['install']['tic_adress'] . "'; // Der Schrägstrich am Ende ist wichtig!\n\n \$tic_status = array('" . implode("', '", $GLOBALS['status']) . "');\n \$tic_version = array(" . implode(", ", $GLOBALS['version']) . ");\n ?>"); fclose($file); @chmod("../accdata.php", 0777); } $mysql = new mysql(array('host' => $t['host'], 'user' => $t['username'], 'password' => $t['password'], 'dbname' => $t['database'])); unset($t); if (isset($_SESSION['install']['tables'])) { include "sql.php"; foreach ($_SESSION['install']['tables'] as $table) { $mysql->multiquery($sqlquery[$table]) or die($mysql->error(__FILE__, __LINE__)); } } $mysql->insert("gn4meta", "name, sysmsg", "'" . $_POST['meta_name'] . "', 'Wenn dieser Text zu lesen ist dann ist leuft der TIC diese Nachricht kann unter Managment geändert werden.'") or die($mysql->error(__FILE__, __LINE__)); $ticid = $mysql->insert_id(); $mysql->insert("gn4vars", "name, value, ticid", "'lastscanclean', '" . date("H:n d.m.Y.") . "', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'forumpriority', '0', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'lasttick', '" . date("H:n:s") . "', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'style', '../gnstyle', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'attplaner', 'aktiv', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'botpw', '', '" . $ticid . "'") or die($mysql->error(__FILE__, __LINE__)); $mysql->insert("gn4vars", "name, value, ticid", "'tickdauer', '15', '" . $ticid . "'") or die(mysql_error(__FILE__, __LINE__)); $mysql->insert("gn4allianzen", "ticid, name , tag", "'" . $ticid . "', '" . $_POST['alli_name'] . "', '" . $_POST['alli_tag'] . "'") or die($mysql->error(__FILE__, __LINE__)); $alli_id = $mysql->insert_id(); $mysql->insert("gn4accounts", "ticid, name, passwort, galaxie, planet, rang, allianz", "'" . $ticid . "', '" . $_POST['user_name'] . "', '" . md5($_POST['user_password']) . "', '" . $_POST['user_coords1'] . "', '" . $_POST['user_coords2'] . "', '5', '" . $alli_id . "'") or die($mysql->error(__FILE__, __LINE__)); echo "Die Installation wurde erfolgreich abgeschlossen.<br />Bitte lösche den Ordner installer vom Server.<br />Danach kannst du dich <a href=\"../index.php\">hier</a> mit deinen Accountdaten einloggen.</div>"; return ""; }