function allatthecho($login, $userid, $userright)
{
global $dbconnect;
if ($login == 0) {
$returntxt = "";
return $returntxt;
} else {
$sql = "SELECT * FROM `authdata` WHERE `user_id`='{$userid}'";
$results = queryArray($sql);
$imgurl[0] = "resources/img/bga.png";
$imgurl[1] = "resources/img/wow-32.png";
$imgurl[2] = "resources/img/s2-32.png";
$imgurl[3] = "resources/img/d3-32.png";
$imgurl[4] = "resources/img/pegasus-32.png";
$imgurl[5] = "resources/img/heroes-32.png";
$returntxt = "";
foreach ($results as $rowarr) {
if ($rowarr['auth_img'] < 1 || $rowarr['auth_img'] > 5 || $rowarr['auth_img'] != intval($rowarr['auth_img'])) {
$rowarr['auth_img'] = 0;
}
$returntxt = $returntxt . '
<li class="border-4">
<span class="game-icon">
<span class="png-fix"><img width="32" height="32" src="' . $imgurl[$rowarr['auth_img']] . '" alt=""></span>
</span>
<span class="account-info">
<span class="account-link">
<strong>
<a class="CN-WOW-mop-se" href="' . SITEHOST . 'normalauth.php?authid=' . $rowarr['auth_id'] . '">安全令名称：' . $rowarr['auth_name'] . '</a>
</strong><span class="account-id">
序列号：';
if ($userright == 0) {
$returntxt .= $rowarr['serial'];
} else {
$returntxt .= "共享账号无法获得该信息";
}
$returntxt .= '</span><span class="account-region">安全令ID：' . $rowarr['auth_id'] . '</span>
</span>
</span></li>';
}
return $returntxt;
}
}
$created = $data['created'];
$query = "INSERT INTO poll VALUES(NULL, {$owner}, '{$title}', '{$question}', '{$is_open}', {$created})";
mysql_query($query) or die(mysql_error());
$query = "SELECT id, owner as ownerId, title, question, is_open as isOpen, created FROM poll WHERE title like '{$title}'";
$ret = queryArray($query, Flight::get('pollCols'));
echo Flight::json($ret[0]);
});
//---------
// UPDATE
//---------
// ! PUT does not work for unknown reasons here. So we circumvent this problem by using a post to a different url instead
Flight::route('POST /api/poll/put', function () {
$json = Flight::request()->data->json;
$data = json_decode($json, true);
$id = $data['id'];
$owner = $data['ownerId'];
$title = $data['title'];
$question = $data['question'];
$is_open = getBoolean($data['isOpen']);
$created = $data['created'];
$query = "UPDATE poll SET owner={$owner}, title='{$title}', question='{$question}', is_open='{$is_open}', created={$created} WHERE id={$id}";
mysql_query($query) or die(mysql_error());
$query = "SELECT id, owner as ownerId, title, question, is_open as isOpen, created FROM poll WHERE title like '{$title}'";
$ret = queryArray($query, Flight::get('pollCols'));
echo Flight::json($ret[0]);
});
Flight::route('*', function () {
echo 'Invalid path requested!';
});
Flight::set('dbConn', getDBconn());
Flight::start();
define("SITEHOST", "https://myauth.us/");
define("SITEHOSTSAFEMODE", "http://myauth.us/");
} else {
define('SSLMODE', 0);
define("SITEHOST", "http://myauth.us/");
define("SITEHOSTSAFEMODE", "https://myauth.us/");
}
define("TITLENAME", "战网安全令在线版");
/* * 微博分享内容* */
define("SINAKEY", "11111");
define("TENCENTKEY", "1111");
define("SOHUKEY", "111fafas");
define("NETEASEKEY", "23121321321312");
define("WEIBOMESSAGE", "战网安全令,魔兽世界,暗黑破坏神,炉石传说,风暴英雄,星际争霸,创建战网安全令,还原战网安全令,台服,美服,欧服,国服,手机安全令,丢失安全令!");
$dbconnect = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
//连接数据库
include_once 'function.php';
@mysqli_select_db($dbconnect, DB_NAME);
@queryArray("set names utf8");
@queryArray("set time_zone = '+8:00'");
/**
* 非对称加密，盐
* 请自行生产KEY并提取KEY文件生成KEY值
* **/
define("RSA_SALT", "SHIORITAKEI");
define("RSA_KEY_ADD", "resources/rsa/yourkey.key");
define("RSA_KEY", "YOUROWNKEY");
if (!$dbconnect) {
include 'page_inc/db_error.php';
die;
}
include 'includes/config.php';
if (isset($_SESSION['loginuser']) && !empty($_SESSION['loginuser'])) {
$logincheck = 1;
}
if ($logincheck == 1) {
$user = mysqli_real_escape_string($dbconnect, htmlspecialchars($_SESSION['loginuser']));
$sql = "SELECT * FROM `users` WHERE `user_name`='{$user}'";
$rowtemp = queryRow($sql);
$user_id = $rowtemp['user_id'];
$user_right = $rowtemp['user_right'];
if ($user_right == 0) {
header('Content-Type: application/csv');
header('Content-Disposition: attachment; filename="myauth.csv"');
$output = fopen('php://output', 'w') or die(locationtogo());
$sql = "SELECT * FROM `authdata` WHERE `user_id`='{$user_id}'";
$result = queryArray($sql);
$list = array();
$list = "安全令名称,安全令序列号,安全令密钥,安全令还原码\r\n";
foreach ($result as $rowauth) {
$list .= $rowauth['auth_name'] . "," . $rowauth['serial'] . "," . $rowauth['secret'] . "," . $rowauth['restore_code'] . "\r\n";
}
$list = "" . $list;
fwrite($output, $list);
fclose($output) or die(locationtogo());
} else {
locationtogo();
}
} else {
}
function locationtogo()
{
$schools[] = $row;
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
}
$link->close();
return $schools;
}
$query = <<<SQL
SELECT * FROM lianjia_web_client where mobile <>'' and ctime>0 and client_id between %d and %d
SQL;
$i = 0;
$step = 1000;
while ($i < 1000) {
echo $i;
$s = $i;
$e = $i + $step;
$users = queryArray(sprintf($query, $s, $e));
foreach ($users as $user) {
$posts[] = array('mobile' => $user['mobile'], 'password' => $user['password'], 'clientId' => $user['client_id'], 'displayName' => $user['display_name'], 'ctime' => $user['ctime'], 'mtime' => $user['mtime'], 'appId' => $user['appid'], 'mobileMark' => 1);
}
foreach ($posts as $post) {
// 创建一个新cURL资源
$ch = curl_init();
$url = 'http://172.30.11.77:8080/uc/user/importUser';
// 设置URL和相应的选项
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $post);
// 抓取URL并把它传递给浏览器
$raw = curl_exec($ch);
function tableshowtext($logincheck, $user)
{
if ($logincheck == 1) {
$returntxt = "";
$imgurl[0] = "resources/img/bga.png";
$imgurl[1] = "resources/img/wow-32.png";
$imgurl[2] = "resources/img/s2-32.png";
$imgurl[3] = "resources/img/d3-32.png";
$imgurl[4] = "resources/img/pegasus-32.png";
$imgurl[5] = "resources/img/heroes-32.png";
$sql = "SELECT * FROM `users` WHERE `user_name`='{$user}'";
$rowtemp = queryRow($sql);
$user_id = $rowtemp['user_id'];
$user_right = $rowtemp['user_right'];
$sql = "SELECT * FROM `authdata` WHERE `user_id`='{$user_id}' LIMIT 20";
$result = queryArray($sql);
foreach ($result as $rowauth) {
if ($rowauth['auth_img'] < 1 || $rowauth['auth_img'] > 5 || $rowauth['auth_img'] != intval($rowauth['auth_img'])) {
$rowauth['auth_img'] = 0;
}
if ($rowauth['auth_moren'] == 1) {
$namebeizhu = "<img class='morenauthleftpic' src='" . SITEHOST . "resources/img/moren.png'>";
$txtbuttonmoren = '<button id="morenauthbutton' . $rowauth['auth_id'] . '" class="ui-button button1" disabled="disabled" onclick="authmoren(' . $rowauth['auth_id'] . ')"><span class="button-left"><span id="morenanquanlin' . $rowauth['auth_id'] . '" class="button-right">已为默认</span></span></button>';
} else {
$namebeizhu = "";
$txtbuttonmoren = '<button id="morenauthbutton' . $rowauth['auth_id'] . '" class="ui-button button1" onclick="authmoren(' . $rowauth['auth_id'] . ')"><span class="button-left"><span id="morenanquanlin' . $rowauth['auth_id'] . '" class="button-right">设置默认</span></span></button>';
}
$linkuel = 'onclick="location.href = \'' . SITEHOST . 'normalauth.php?authid=' . $rowauth['auth_id'] . '\'"';
$txtdisabalebut = "";
$onclickdata = 'authsync(' . $rowauth['auth_id'] . ')';
$returntxt = $returntxt . '<tr class="parent-row" id="henxiangtr' . $rowauth['auth_id'] . '">
<td ' . $linkuel . ' class="normaltd authbianhao" valign="top"><img class="tdimgauth" src="' . $imgurl[$rowauth['auth_img']] . '" alt=""> <a class="authida" href="normalauth.php?authid=' . $rowauth['auth_id'] . '">' . $rowauth['auth_id'] . '</a></td>
<td class="normaltd authmincheng" valign="top"><span id="morenpicspan' . $rowauth['auth_id'] . '">' . $namebeizhu . '</span><span ondblclick="ShowElement(this,' . $rowauth['auth_id'] . ')" id="authnamecode' . $rowauth['auth_id'] . '">' . $rowauth['auth_name'] . '</span></td>
<td ' . $linkuel . ' class="normaltd authxuliehao" valign="top"><span>';
if ($user_right == 0) {
$returntxt .= $rowauth['serial'];
} else {
$returntxt .= "共享账号无权查看";
}
$returntxt .= '</span></td>
<td ' . $linkuel . ' class="normaltd authhuanyuanma" valign="top"><span>';
if ($user_right == 0) {
$returntxt .= $rowauth['restore_code'];
} else {
$returntxt .= "无权查看";
}
$returntxt .= '</span></td>
<td ' . $linkuel . ' class="normaltd authshangcitongbushijian" valign="top"><span id="authshangcitongbushijian' . $rowauth['auth_id'] . '">' . chinesetime($rowauth['region']) . '</span></td>
<td valign="top" class="align-center">
<button id="authsyncbutton' . $rowauth['auth_id'] . '" class="ui-button button1" onclick="' . $onclickdata . '" ' . $txtdisabalebut . '><span class="button-left"><span id="jiaochenshijian' . $rowauth['auth_id'] . '" class="button-right">校正时间</span></span></button>
</td>
<td valign="top" class="align-center">
' . $txtbuttonmoren . '</td>
<td valign="top" class="align-center">
<button id="authdelbutton' . $rowauth['auth_id'] . '" class="ui-button button1" onclick="if(confirm(\'提交后将删除这枚安全令，除重新添加外无其他恢复方法，确定吗？\')) authdelete(' . $rowauth['auth_id'] . ') ;else return false;"><span class="button-left"><span id="shanchuauth' . $rowauth['auth_id'] . '" class="button-right">确认删除</span></span></button>
</td>
</tr>';
}
return $returntxt;
} else {
return "";
}
}
