function checkimg($imgdir, $index = 0)
{
$dir = opendir($imgdir);
if ($dir == NULL) {
return;
}
while ($file = readdir($dir)) {
if ($file != "." and $file != "..") {
//echo $imgdir."/".$file."<br>";
$path = $imgdir . "/" . $file;
if (is_dir($path)) {
checkimg($path, $index + 1);
} else {
$filename = basename($path);
$ifused = getresultNumrows(getresult("select * from I_article where contents like '%" . $filename . "%'"));
if ($ifused <= 0) {
echo "删除：" . $path . "<br>";
unlink($path);
}
}
}
}
closedir($dir);
//呵呵，这个函数只能删除空文件夹，有文件的文件夹会失败
if ($index != 0) {
if (rmdir($imgdir)) {
echo "删除" . $imgdir . "<br>";
}
}
}
function showColumnstructure($columnid, $classindex = 0)
{
$query = "select childcolumn from I_column where id={$columnid}";
$result = getresult($query);
$count = getresultNumrows($result);
if ($count > 0) {
$childColumnId = getresultData($result, 0, "childcolumn");
//没有子栏目即返回
//echo $childColumnId."<br>";
if ($childColumnId == NULL || $childColumnId == 0 || $childColumnId == "") {
if ($classindex == 0) {
echo "<tr style=\"height:24px;\">\n";
echo "<td align='center' colspan='3'>" . gettext_r("haveNot") . gettext_r("column") . "</td>";
echo "</tr>\n";
}
return false;
}
$childId = explode("|", $childColumnId);
foreach ($childId as $id) {
echo "<tr class='list'>\n";
$getchildcolumnQuery = "select columnname,childcount from I_column where id={$id}";
$childColumn = getresult($getchildcolumnQuery);
$childColumnname = getresultData($childColumn, 0, "columnname");
$childCount = getresultData($childColumn, 0, "childcount");
echo "<td> " . $id . "</td>\n";
echo "<td> " . space($classindex) . $childColumnname . "</td>\n";
echo "<td align='center'>";
echo " ";
//如果为大栏目调整，不出现添子栏目菜单
if ($columnid != 0) {
echo "<a href=\"admin_column.php?action=add&columnid=" . $id . "\">" . gettext_r("add") . gettext_r("child") . gettext_r("column") . "</a>";
echo " ｜ ";
}
echo "<a href=\"javascript:jump('admin_column.php','modify'," . $id . ")\">" . gettext_r("update") . gettext_r("column") . gettext_r("attribute") . "</a>";
echo " ｜ ";
if ($columnid != 0) {
echo "<a href=\"admin_article.php?action=add&columnid=" . $id . "\">" . gettext_r("add") . gettext_r("article") . "</a>";
echo " ｜ ";
}
echo "<a href=\"javascript:if(confirm('" . gettext_r("deleteColumnTip") . "'))jump('admin_column.php','delete'," . $id . ")\">" . gettext_r("delete") . "</a>";
//echo " ｜ ";
//如果有子栏目则显示管理子栏目
/* if($childCount > 0)
echo "<a href=\"admin_column.php?columnid=".$id."\">管理子栏目($childCount)</a>\n";
else
echo "<a href=\"#\">管理子栏目($childCount)</a>\n";*/
echo "</tr>\n";
//如果为大栏目调整，则不递归显示子栏目
if ($columnid != 0) {
showColumnstructure($id, $classindex + 1);
}
}
} else {
return false;
}
}
function translatemylabel($mylabel)
{
$result = getresult("select * from I_mylabel where labelname='{$mylabel}'");
//echo "select * from I_mylabel where labelname='$mylabel'";
if (getresultNumrows($result) < 1) {
return $mylabel;
} else {
return getresultData($result, 0, "labelcontent");
}
}
function showpowerlist($adminid = 0)
{
if ($adminid != 0) {
$tempresult = getresult("select * from I_admin where id={$adminid}");
$functioncode = getresultData($tempresult, 0, "functioncode");
$functionarray = translatefunctioncode($functioncode);
$result = getresult("select * from I_column where parentid=0");
while ($row = getresultArray($result)) {
if ($functionarray[$row["id"]] === "1") {
echo "<tr>\n";
echo "<td><input checked=\"true\" type=\"checkbox\" name=\"columnid\" value=\"" . $row["id"] . "\" />" . $row["columnname"] . "</td>";
echo "<td><input checked=\"checked\" type=\"radio\" name=\"" . $row["id"] . "\" value=\"1\" />" . gettext_r("editer") . "<input type=\"radio\" name=\"" . $row["id"] . "\" value=\"2\" />" . gettext_r("column") . gettext_r("manager") . "</td>";
echo "</tr>";
echo "<tr class='segmentline'><td colspan='2'></td></tr>";
} elseif ($functionarray[$row["id"]] === "2") {
echo "<tr>\n";
echo "<td><input checked=\"true\" type=\"checkbox\" name=\"columnid\" value=\"" . $row["id"] . "\" />" . $row["columnname"] . "</td>";
echo "<td><input type=\"radio\" name=\"" . $row["id"] . "\" value=\"1\" />" . gettext_r("editer") . "<input checked=\"checked\" type=\"radio\" name=\"" . $row["id"] . "\" value=\"2\" />" . gettext_r("column") . gettext_r("manager") . "</td>";
echo "</tr>";
echo "<tr class='segmentline'><td colspan='2'></td></tr>";
} else {
echo "<tr>\n";
echo "<td><input type=\"checkbox\" name=\"columnid\" value=\"" . $row["id"] . "\" />" . $row["columnname"] . "</td>";
echo "<td><input type=\"radio\" name=\"" . $row["id"] . "\" value=\"1\" />" . gettext_r("editer") . "<input type=\"radio\" name=\"" . $row["id"] . "\" value=\"2\" />" . gettext_r("column") . gettext_r("manager") . "</td>";
echo "</tr>";
echo "<tr class='segmentline'><td colspan='2'></td></tr>";
}
}
if ($functionarray["vote"] === "1") {
echo " <tr>";
echo " <td colspan=\"2\"><input type=\"checkbox\" checked=\"true\" name=\"voteadmin\" value=\"1\" />" . gettext_r("vote") . gettext_r("manage") . "</td>";
echo " </tr>";
} else {
echo " <tr>";
echo " <td colspan=\"2\"><input type=\"checkbox\" name=\"voteadmin\" value=\"1\" />" . gettext_r("vote") . gettext_r("manage") . "</td>";
echo " </tr>";
}
return;
}
$result = getresult("select * from I_column where parentid=0");
while ($row = getresultArray($result)) {
echo "<tr>\n";
echo "<td><input type=\"checkbox\" name=\"columnid\" value=\"" . $row["id"] . "\" />" . $row["columnnamezh"] . "</td>";
echo "<td><input type=\"radio\" name=\"" . $row["id"] . "\" value=\"1\" />" . gettext_r("editer") . "<input type=\"radio\" name=\"" . $row["id"] . "\" value=\"2\" />" . gettext_r("column") . gettext_r("manager") . "</td>";
echo "</tr>";
echo "<tr class='segmentline'><td colspan='2'></td></tr>";
}
echo " <tr>";
echo " <td colspan=\"2\"><input type=\"checkbox\" name=\"voteadmin\" value=\"1\" />" . gettext_r("vote") . gettext_r("manage") . "</td>";
echo " </tr>";
}
public function getSource()
{
$timestamp = time();
// $oldTime = $timestamp - 300;
$oldTime = $timestamp;
$date = date('Y-m-d H:i:s',$oldTime);
$oldDate = date('Y-m-d H:i:s',$timestamp);
$workTime = $this->judgeTime(time());
if ($workTime) {
// SELECT * FROM `messages` inner join device on messages.device_id = device.id where 1;
$sql = 'select messages.id,messages.pic,messages.state from messages inner join device on messages.device_id = device.id where device.ver = 3 and messages.update_time < \''.$date.'\' and messages.state = 382';
}
else{
$sql = 'select messages.id,messages.pic,messages.state from messages inner join device on messages.device_id = device.id where device.ver = 3 and messages.update_time < \''.$oldDate.'\' and messages.state = 382';
}
// var_dump($sql);
$res = $this->connection->query($sql);
// var_dump($res);
// var_dump($res->num_rows);
if ($res->num_rows > 0) {
// echo "\n rows:".$res->num_rows;
while ($row = $res->fetch_assoc()) {
$duringTime = time() - $this->startTime;
if ($duringTime > 60) {
return;
}
$id = $row['id'];
$state = $this->getState($id);
if ($state != 382) {
continue;
}
$this->connection->query("update messages set state = 9 where id =$id");
$img_url = $this->baseUrl.'/'.$row['pic'];
// 注释
$translateRes = getresult($img_url);
// echo "\n"."messages come: ".mb_detect_encoding($translateRes);
// echo '对的';
if ($translateRes != 'error') {
$this->connection->query("set names utf8");
// echo "update messages set reply = '$translateRes',state = 41 where id = $id";
$this->connection->query("update messages set reply = '$translateRes',state = 41 where id = $id");
}
else{
$this->connection->query("update messages set state = 42 where id = $id");
}
}
}
// print_r($res);
}
function showfield($columnid)
{
$result = getresult("select * from I_field where columnid={$columnid}");
if (getresultnumrows($result) < 1) {
echo "<tr>";
echo "<td colspan='6' height='25' align='center'>" . gettext_r("haveNot") . gettext_r("field") . "</td>";
echo "<tr>";
return;
}
while ($row = getresultarray($result)) {
echo "<tr class='list'>";
echo "<td align='center'>" . $row["id"] . "</td>\n";
echo "<td align='center'>" . $row["fieldname"] . "</td>";
echo "<td align='center'>" . $row["info"] . "</td>";
echo "<td align='center' width='100'>";
echo "<a href=\"admin_field.php?action=modify&fieldid=" . $row["id"] . "&columnid={$columnid}\">" . gettext_r("update") . "</a>";
echo " ｜ ";
echo "<a href=\"javascript:if(confirm('" . gettext_r("ifDelete") . "'))jump('admin_field.php','delete'," . $row["id"] . ")\">" . gettext_r("delete") . "</a>";
echo "</td>\n";
echo "</tr>";
}
}
function showtemplatelist($type)
{
$tempresult = getresult("select count(*) as countoftemplate from I_template where templatetype={$type}");
$countoftemplate = getresultData($tempresult, 0, "countoftemplate");
if ($countoftemplate < 1) {
echo "<tr class='list'>\n";
echo "<td colspan='4' align='center'>" . gettext_r("haveNot") . gettext_r("template") . "</td>\n";
echo "</tr>";
return;
}
$query = "select * from I_template where templatetype={$type}";
$result = getresult($query);
while ($row = getresultArray($result)) {
echo "<tr class='list'>\n";
echo "<td> " . $row["id"] . "</td>";
echo "<td> " . $row["templatename"] . "</td>";
echo "<td> " . $row["path"] . "</td>";
echo "<td align='center'>";
echo "<a href=\"admin_template.php?type={$type}&action=modify&id=" . $row["id"] . "\">" . gettext_r("update") . "</a> | <a href=\"javascript:if(confirm('" . gettext_r("ifDelete") . "'))jump('admin_template.php','delete'," . $row["id"] . ")\">" . gettext_r("delete") . "</a>";
echo "</td>";
echo "</tr>\n";
}
}
function translatecolumnlist($template)
{
//匹配自定义文章列表标签正则
$flag = "/【columnlist】([\\s\\S]*?)【\\/columnlist】/";
preg_match_all($flag, $template, $matches, PREG_SET_ORDER);
//替换所有articlelist标签
$html = $template;
//echo $template."<br>".$flag;
//得到需要循环的部分
$str = $matches[0][1];
//echo $str ;
//得到子栏目id数组
$columnid = $_GET["columnid"];
$query = "select childcolumn,columnname from I_column where id={$columnid}";
$result = getresult($query);
if (getresultNumrows($result) < 1) {
//没有才此栏目
return str_replace($str, "No such column!", $html);
return;
}
$columnname = getresultData($result, 0, "columnname");
$childColumnId = getresultData($result, 0, "childcolumn");
if ($childColumnId == NULL || $childColumnId == 0 || $childColumnId == "") {
//没有子栏目
return str_replace($str, "No child column!", $html);
return;
}
$temphtml = "";
$childId = explode("|", $childColumnId);
foreach ($childId as $id) {
$tempstr = str_replace("【#columnid】", "{$id}", $str);
$tempstr = str_replace("【#columnname】", getcolumnformationBycolumnid($id, "columnname"), $tempstr);
$temphtml .= $tempstr;
}
$html = str_replace($matches[0][0], $temphtml, $html);
return $html;
}
}
} else {
if ($_POST[$row["id"]] != 0) {
$functioncode .= "," . $row["id"] . "|" . $_POST[$row["id"]];
}
}
}
if ($_POST["voteadmin"] == 1) {
if ($functioncode == "") {
$functioncode = "vote|1";
} else {
$functioncode .= ",vote|1";
}
}
$query = "update I_admin set adminname='{$adminname}',password='******',adminrole=1,functioncode='{$functioncode}' where id={$adminid}";
getresult($query);
echo "<script type=\"text/javascript\">alert('" . gettext_r("update") . gettext_r("success") . "');window.location='admin_admin.php';</script>";
die;
//echo $functioncode;
}
?>
<form id="form1" name="form1" method="post" action="" onsubmit="return admin_form_check()">
<table class="admininfo" cellspacing="0" cellpadding="3" border="1" bordercolor="#FFFFFF" style="border-collapse:collapse">
<tr>
<td class="label" width="80" align="right"><?php
echo gettext_r("manager") . gettext_r("name");
?>
：</td>
<td><input id="adminname" type="text" value="<?php
echo $adminname;
?>
function showLogpage($currentpage, $pagesize = 10, $logtype = 0)
{
$tempresult = getresult("select count(*) as countoflog from I_log where logtype={$logtype}");
$countoflog = getresultData($tempresult, 0, "countoflog");
if ($countoflog % $pagesize == 0) {
$allpage = $countoflog / $pagesize;
} else {
$allpage = floor($countoflog / $pagesize) + 1;
}
//消除文章数为零时显示下一页链接的bug
if ($countoflog == 0) {
$allpage += 1;
}
//echo $countofcomment%$pagesize." ".$currentpage;
echo gettext_r("total") . "<b> " . $allpage . " </b>" . gettext_r("page") . "(" . $pagesize . " " . gettext_r("piece") . gettext_r("article") . gettext_r("per") . gettext_r("page") . ") ";
if ($currentpage == 1) {
echo gettext_r("firstPage") . " | " . gettext_r("prePage") . " | ";
} else {
echo "<a href='admin_log.php?logtype={$logtype}¤tpage=1'>" . gettext_r("firstPage") . "</a> | <a href='admin_log.php?logtype={$logtype}¤tpage=" . ($currentpage - 1) . "'>" . gettext_r("prePage") . "</a> | ";
}
$temppage = 1;
if ($currentpage - 1 < 5) {
while ($temppage <= $currentpage) {
if ($currentpage == $temppage) {
echo "<b>" . $temppage . "</b> ";
$temppage++;
continue;
}
echo "<a href='admin_log.php?logtype={$logtype}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
}
} else {
while ($temppage <= $currentpage) {
if ($currentpage == $temppage) {
echo "<b>" . $temppage . "</b> ";
$temppage++;
continue;
}
if ($temppage == 1) {
echo "<a href='admin_log.php?logtype={$logtype}¤tpage={$temppage}'>" . $temppage . "</a> … ";
$temppage++;
continue;
}
if ($currentpage - $temppage > 3) {
$temppage++;
continue;
}
echo "<a href='admin_log.php?logtype={$logtype}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
}
}
if ($allpage - $currentpage < 5) {
while ($temppage <= $allpage) {
if ($temppage == 1) {
echo "<a href='admin_log.php?logtype={$logtype}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
continue;
}
echo "<a href='admin_log.php?logtype={$logtype}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
}
} else {
while ($temppage <= $allpage) {
if ($temppage == $allpage) {
echo " … <a href='admin_log.php?logtype={$logtype}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
continue;
}
if ($temppage - $currentpage > 3) {
$temppage++;
continue;
}
echo "<a href='admin_log.php?logtype={$logtype}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
}
}
if ($currentpage == $allpage) {
echo "| " . gettext_r("nextPage") . " | " . gettext_r("lastPage");
} else {
echo "| <a href='admin_log.php?logtype={$logtype}¤tpage=" . ($currentpage + 1) . "'>" . gettext_r("nextPage") . "</a> | <a href='admin_log.php?logtype={$logtype}¤tpage={$allpage}'>" . gettext_r("lastPage") . "</a>";
}
}
session_start();
include_once "conn.php";
$username = $_GET["username"];
$password = md5($_GET["password"]);
if ($username == NULL || $username == "" || $password == NULL || $password == "") {
if ($_COOKIE["username"] == NULL || $_COOKIE["username"] == "") {
die("notlogin");
}
}
try {
$query = "select * from I_user where username = '******' and password = '******'";
//echo $query;
$result = getresult($query);
if (getresultNumrows($result) < 1) {
throw new Exception("登录失败！");
} else {
if (getresultData($result, 0, "iflock") === "1") {
die("locked");
}
setcookie("username", getresultData($result, 0, "username"));
setcookie("userid", getresultData($result, 0, "id"));
$_SESSION["username"] = getresultData($result, 0, "username");
$_SESSION["userid"] = getresultData($result, 0, "id");
getresult("update I_user set logintimes=logintimes+1 where id=" . getresultData($result, 0, "id"));
//echo "update I_admin set logintimes=logintimes+1,lastip=".$_SERVER["REMOTE_ADDR"].",lasttime=CURRENT_TIMESTAMP where id=$id";
//echo getlogininfo("adminname");
echo "logined";
}
} catch (Exception $e) {
//die ( "notlogin" );
}
include "../library/admin.comment.php";
$functionarray = translatefunctioncode($_SESSION["functioncode"]);
$columnid = $_GET["columnid"];
$action = $_GET["action"];
$preurl = $_GET["url"];
$currentpage = $_GET["currentpage"] == NULL || $_GET["currentpage"] <= 0 ? 1 : $_GET["currentpage"];
switch ($action) {
case "delete":
if (!getresult("delete from I_comment where id=" . $_GET["commentid"])) {
echo "<script type=\"text/javascript\">alert('" . gettext_r("delete") . gettext_r("fail") . "');window.location=\"{$preurl}\";</script>";
} else {
echo "<script type=\"text/javascript\">alert('" . gettext_r("delete") . gettext_r("success") . "');window.location=\"{$preurl}\";</script>";
}
break;
case "pass":
getresult("update I_comment set ifpass="******"ifpass"] . " where id=" . $_GET["commentid"]);
break;
default:
echo "<div id='navigation'>" . gettext_r("quickLink") . "：";
showchildcolumncomment($columnid);
//echo "<a href=\"admin_comment.php?columnid=".$columnid."\">添加文章</a>\n";
echo "";
echo "</div>";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='1' class='function'>\n";
echo "<tr class='header'>\n";
echo "<td align='center' width='40'>" . gettext_r("checkIn") . "</td>\n";
echo "<td align='center' width='50'>" . gettext_r("serialNumber") . "</td>\n";
echo "<td align='center' width='140'>" . gettext_r("article") . "</td>\n";
echo "<td align='center' width='600'>" . gettext_r("contents") . "</td>\n";
echo "<td align='center' width='100'>" . gettext_r("author") . "</td>\n";
echo "<td align='center' width='100'>" . gettext_r("ifPass") . "</td>\n";
if ($_POST["votetype"] == 0) {
if ($_POST["option"] != NULL && $_POST["option"] != "") {
getresult("update I_vote set count" . $_POST["option"] . "=count" . $_POST["option"] . "+1 where id={$voteid}");
}
} else {
if ($_POST["option"] != NULL && $_POST["option"] != "") {
$option = $_POST["option"];
//echo count($option);
for ($i = 0; $i < count($option); $i++) {
getresult("update I_vote set count" . $option[$i] . "=count" . $option[$i] . "+1 where id={$voteid}");
}
}
}
}
//添加投票记录
if (!getresult("insert into I_iprecord(ip,action,actionid,user) values('" . $userip . "','vote'," . $voteid . ",'" . $_SESSION["username"] . "')")) {
//echo "insert into I_iprecord(ip,action,actionid,user) values('".$userip."','vote',".$voteid.",'".$_SESSION["userid"]."')";
}
}
$countOfOption = getresultData($result, 0, "attrcount") + 1;
$countOfAll = 0;
for ($i = 1; $i < $countOfOption; $i++) {
$countOfAll += getresultData($result, 0, "count" . $i);
}
echo "<tr><td height='46px' style='background:url(images/vote_fg2.png) repeat-y' valign='top' id='vote_title'>" . gettext_r("title") . "：" . getresultData($result, 0, "title") . "</td></tr>";
echo "<tr>";
echo "<td height='19px' style='background:url(images/vote_fg3.png) no-repeat'></td>";
echo "</tr>";
echo "<tr>";
echo "<td style='background:url(images/vote_fg4.png) repeat-y'>";
echo "<table width='820px' border='0' cellspacing='0' cellpadding='0' style='margin-left:70px'>";
</head>
<body style="padding:20px;" bgcolor="#f3f9ff">
<?php
if ($_POST["submit"] == "提交") {
include '../conn.php';
include '../library/basefunction.php';
$adminid = getlogininfo("adminid");
$result = getresult("select * from I_admin where id = {$adminid}");
if (md5($_POST["oldpassword"]) != getresultData($result, 0, "password")) {
die("<script type='text/javascript'>alert('旧密码错误');history.back(-1);</script>");
}
if ($_POST["newpwd"] != $_POST["newpwd1"]) {
die("<script type='text/javascript'>alert('两次密码输入不一致');history.back(-1);</script>");
}
if (getresult("update I_admin set password='******' where id={$adminid}")) {
die("<script type='text/javascript'>alert('密码修改成功\\n请重新登录');parent.location='logout.php';</script>");
}
}
?>
<div>
<form action="" method="post" onSubmit="return chpasswordcheck();">
<table cellspacing="0" cellpadding="3" border="1" bordercolor="#FFFFFF" style="border-collapse:collapse">
<tr>
<td class="label" width="100px">密码：</td>
<td><input type="password" name="oldpassword"></td>
<td valign="center" style="font-size:12px; color:#0000CC; padding-left:10px;">* 请输入您现在正在使用的密码 </td>
</tr>
<tr>
<td class="label">新密码：</td>
<td><input type="password" name="newpwd"></td>
include_once 'templatefunction/Iron.article.php';
include_once 'templatefunction/Iron.column.php';
include_once 'templatefunction/Iron.label.php';
loadlibrary("library/third/FirePHPCore/fb.php");
FB::log('Log message');
FB::info('Info message');
FB::warn('Warn message');
FB::error('Error message');
readcache();
$siteconfig = getresult("SELECT * FROM I_siteconfig LIMIT 0 , 1");
//如果没有网站配置项
if (getresultNumrows($siteconfig) < 1) {
die("<script type='text/javascript'>window.location='error.html'</script>");
}
$templateid = getresultData($siteconfig, 0, "indextemplate");
$templateinfo = getresult("select * from I_template where id={$templateid} limit 0,1");
if (getresultNumrows($templateinfo) < 1) {
die("<script type='text/javascript'>window.location='error.html'</script>");
}
$templatepath = getresultData($templateinfo, 0, "path");
$templatefile = getroot() . "/templates/" . $templatepath;
//echo $templatefile;
if (!file_exists($templatefile)) {
die("The template file doesn'n exit!");
}
$template = file_get_contents($templatefile);
//如果模板被删除
if (!$template) {
die("<script type='text/javascript'>alert('The template doesn't exists!')window.location='error.html'</script>");
}
$template = translatelabel($template);
function showpage($currentpage, $pagesize = 10)
{
$tempresult = getresult("select count(*) as countofuser from I_user");
$countofuser = getresultData($tempresult, 0, "countofuser");
if ($countofuser % $pagesize == 0) {
$allpage = $countofuser / $pagesize;
} else {
$allpage = floor($countofuser / $pagesize) + 1;
}
//消除文章数为零时显示下一页链接的bug
if ($countofuser == 0) {
$allpage += 1;
}
echo gettext_r("total") . "<b> " . $allpage . " </b>" . gettext_r("page") . "(" . $pagesize . " " . gettext_r("piece") . gettext_r("user") . gettext_r("per") . gettext_r("page") . ") ";
if ($currentpage == 1) {
echo gettext_r("firstPage") . " | " . gettext_r("prePage") . " | ";
} else {
echo "<a href='admin_user.php?columnid={$columnid}¤tpage=1'>" . gettext_r("firstPage") . "</a> | <a href='admin_user.php?columnid={$columnid}¤tpage=" . ($currentpage - 1) . "'>" . gettext_r("prePage") . "</a> | ";
}
$temppage = 1;
if ($currentpage - 1 < 5) {
while ($temppage <= $currentpage) {
if ($currentpage == $temppage) {
echo "<b>" . $temppage . "</b> ";
$temppage++;
continue;
}
echo "<a href='admin_user.php?columnid={$columnid}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
}
} else {
while ($temppage <= $currentpage) {
if ($currentpage == $temppage) {
echo "<b>" . $temppage . "</b> ";
$temppage++;
continue;
}
if ($temppage == 1) {
echo "<a href='admin_user.php?columnid={$columnid}¤tpage={$temppage}'>" . $temppage . "</a> … ";
$temppage++;
continue;
}
if ($currentpage - $temppage > 3) {
$temppage++;
continue;
}
echo "<a href='admin_user.php?columnid={$columnid}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
}
}
if ($allpage - $currentpage < 5) {
while ($temppage <= $allpage) {
if ($temppage == 1) {
echo "<a href='admin_user.php?columnid={$columnid}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
continue;
}
echo "<a href='admin_user.php?columnid={$columnid}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
}
} else {
while ($temppage <= $allpage) {
if ($temppage == $allpage) {
echo " … <a href='admin_user.php?columnid={$columnid}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
continue;
}
if ($temppage - $currentpage > 3) {
$temppage++;
continue;
}
echo "<a href='admin_user.php?columnid={$columnid}¤tpage={$temppage}'>" . $temppage . "</a> ";
$temppage++;
}
}
if ($currentpage == $allpage) {
echo "| " . gettext_r("nextPage") . " | " . gettext_r("lastPage");
} else {
echo "| <a href='admin_user.php?columnid={$columnid}¤tpage=" . ($currentpage + 1) . "'>" . gettext_r("nextPage") . "</a> | <a href='admin_user.php?columnid={$columnid}¤tpage={$allpage}'>" . gettext_r("lastPage") . "</a>";
}
}
default:
echo "<div id='navigation'>" . gettext_r("quickLink") . "：";
echo "<a href=\"admin_vote.php?action=add\">" . gettext_r("add") . gettext_r("vote") . "</a>\n";
echo "</div>";
echo "<table width='100%' border='0' cellpadding='0' cellspacing='1' class='function'>\n";
echo "<tr class='header'>\n";
echo "<td align='center' width='40'>" . gettext_r("checkIn") . "</td>\n";
echo "<td align='center' width='40'>" . gettext_r("serialNumber") . "</td>\n";
echo "<td align='center'>" . gettext_r("title") . "</td>\n";
echo "<td align='center' width='300'>" . gettext_r("operate") . "</td>\n";
echo "</tr>\n";
$adminid = getlogininfo("adminid");
if (getlogininfo("adminrole") === "0") {
$result = getresult("select * from I_vote");
} else {
$result = getresult("select * from I_vote where adminid={$adminid}");
}
if (getresultNumrows($result) < 1) {
echo "<tr class='list'>\n";
echo "<td colspan='4' align='center'>" . gettext_r("haveNot") . gettext_r("vote") . "</td>";
echo "</tr>";
}
while ($row = getresultArray($result)) {
echo "<tr class='list'>\n";
echo "<td align='center'><input type='checkbox' name='list' value='" . $row["id"] . "' /></td>";
echo "<td> " . $row["id"] . "</td>";
echo "<td> " . $row["title"] . "</td>";
echo "<td align='center'>";
echo "<a href='admin_vote.php?action=details&voteid=" . $row["id"] . "'>" . gettext_r("see") . gettext_r("result") . "</a> | <a href='admin_vote.php?action=modify&voteid=" . $row["id"] . "'>" . gettext_r("update") . "</a> | <a href='#' onclick=\"getvotecode(" . $row["id"] . ")\">" . gettext_r("getInvokeCode") . "</a>";
echo "</td>";
echo "</tr>";
function getarticleidlist($columnid)
{
global $childcolumnString;
getchildcolumnid_improveed($columnid);
if ($functionarray[$columnid] === "2" || getlogininfo("adminrole") === "0") {
$query = "select id from I_article where columnid in ({$childcolumnString})";
} else {
$query = "select id from I_article where columnid in ({$childcolumnString}) and adminid=" . getlogininfo("adminid");
}
$result = getresult($query);
if (getresultNumrows($result) < 1) {
return "-1";
} else {
$articleidlist = "";
while ($row = getresultArray($result)) {
if ($articleidlist == "") {
$articleidlist = $row["id"];
}
$articleidlist .= "," . $row["id"];
}
return $articleidlist;
}
}
<?php
session_start();
include_once 'conn.php';
include_once 'library/basefunction.php';
include_once 'lang/envinit.php';
include_once 'templatefunction/Iron.article.php';
include_once 'templatefunction/Iron.column.php';
include_once 'templatefunction/Iron.label.php';
include_once 'templatefunction/Iron.search.php';
$columnid = $_GET["columnid"];
$templatefile = getroot() . "/templates/searchresult.html";
if ($columnid != NULL && $columnid != '') {
$templateid = getcolumnformationBycolumnid($columnid, "searchtemplate");
$templatepath = getresultData(getresult("select * from I_template where id={$templateid}"), 0, "path");
$templatefile = getroot() . "/templates/" . $templatepath;
}
//echo $templatefile;
if (!file_exists($templatefile)) {
die("The template file doesn'n exit!");
}
$template = file_get_contents($templatefile);
//如果模板被删除
if (!$template) {
die("<script type='text/javascript'>alert('The template doesn't exists!')window.location='error.html'</script>");
}
$template = translatelabel($template);
$template = translateSearchlist($template);
$template = translateArticlelist($template);
$template = translateCommonlabel($template);
echo $template;
<?php
$initialValue = 20151125;
$row = 2947;
$column = 3029;
function getNumberOfIteration($row, $col)
{
$rangeRow = range(0, $row - 1);
$result = array_sum($rangeRow) + 1;
if ($col > 1) {
$rangeCol = range($row + 1, $col + $row - 1);
$result += array_sum($rangeCol);
}
return $result;
}
function getresult($nbIteration, $initialValue)
{
$result = $initialValue;
for ($i = 1; $i < $nbIteration; $i++) {
$result = $result * 252533 % 33554393;
}
return $result;
}
$nbIteration = getNumberOfIteration($row, $column);
$result = getresult($nbIteration, $initialValue);
print 'Part 1: ' . $result;
print PHP_EOL;
function getchildcolumnid($columnid, &$childidstring, $index = 0)
{
if ($index == 0) {
$childidstring = $columnid;
}
$query = "select childcolumn from I_column where id={$columnid}";
$result = getresult($query);
$count = getresultNumrows($result);
if ($count > 0) {
$childColumnId = getresultData($result, 0, "childcolumn");
//没有子栏目即返回
//echo $childColumnId."<br>";
if ($childColumnId == NULL || $childColumnId == 0 || $childColumnId == "") {
return false;
}
$childId = explode("|", $childColumnId);
foreach ($childId as $id) {
$childidstring .= "," . $id;
//echo $childidstring;
getchildcolumnid($id, $childidstring, $index + 1);
}
} else {
return false;
}
}
}
echo " </select></td></tr>\n";
echo "\t<tr><td class='label'>" . gettext_r("article") . gettext_r("template") . "：</td><td class='attributeinput'><select name=\"articletemplate\">\n";
//文章模板列表
$articletemplatelist = getresult("select id,templatename from I_template where templatetype=2");
while (list($id, $templatename) = getresultRow($articletemplatelist)) {
if ($id == $articletemplateid) {
echo "<option selected=\"selected\" value='{$id}'>{$templatename}</option>\n";
} else {
echo "<option value='{$id}'>{$templatename}</option>\n";
}
}
echo " </select></td></tr>\n";
echo "\t<tr><td class='label'>" . gettext_r("search") . gettext_r("template") . "：</td><td class='attributeinput'><select name=\"searchtemplate\">\n";
//搜索模板列表
$articletemplatelist = getresult("select id,templatename from I_template where templatetype=4");
while (list($id, $templatename) = getresultRow($articletemplatelist)) {
if ($id == $articletemplateid) {
echo "<option selected=\"selected\" value='{$id}'>{$templatename}</option>\n";
} else {
echo "<option value='{$id}'>{$templatename}</option>\n";
}
}
echo " </select></td></tr>\n";
echo "\t<tr><td class='label'>" . gettext_r("ifLock") . "：</td><td>";
if ($isopen == 0) {
echo gettext_r("yes") . "<input type=\"radio\" value=\"0\" name=\"isopen\" checked=\"checked\" />" . gettext_r("no") . "<input type=\"radio\" value=\"1\" name=\"isopen\" />";
} else {
echo gettext_r("yes") . "<input type=\"radio\" value=\"0\" name=\"isopen\" />" . gettext_r("no") . "<input type=\"radio\" value=\"1\" name=\"isopen\" checked=\"checked\" />";
}
echo "</td></tr>\n";
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>article</title>
<link type="text/css" rel="stylesheet" href="css/article.css" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/front.js"></script>
</head>
<body>
<?php
include "conn.php";
include 'frontshowfunction/frontbasefunction.php';
$articleid = $_GET["id"];
?>
<div id="article">
<?php
getresult("update I_article set hits=hits+1 where id = {$articleid}");
showarticle($articleid);
?>
</div>
</body>
</html>
echo "Find CProgrammingLanguage-BHH-ZJU/{$vvv->id}/{$vvv->id}_not_finished.c, and it will be renamed automatically.\n";
waitforret();
rename("CProgrammingLanguage-BHH-ZJU/{$vvv->id}/{$vvv->id}_not_finished.c", "CProgrammingLanguage-BHH-ZJU/{$vvv->id}/{$vvv->id}.c");
goto ready_for_upload;
} else {
echo "Uploading CProgrammingLanguage-BHH-ZJU/{$vvv->id}/{$vvv->id}.c, please wait...\n";
if (FALSE == uploadsrc($vvv->id, "CProgrammingLanguage-BHH-ZJU/{$vvv->id}/{$vvv->id}.c")) {
echo "Error: cannot upload. \n";
echo "fatal error.\n";
echo "If this problem persists, please contact me.\n";
exit(4);
} else {
$timer = 10;
while ($timer) {
$timer--;
$problem_result = getresult();
echo "Code: {$problem_result}\n";
if ($problem_result == '运行完毕') {
break;
}
sleep(1);
}
if ($problem_result != '运行完毕') {
echo "Your source code is incorrect? \n";
echo "Try to correct it, and then press Enter/Return to retry.\n";
waitforret();
goto ready_for_upload;
}
if ($src_flag) {
echo "It seems that my repo does not have your code.\n";
echo "Would you like to share (pull request) this to me?\n";
</td>
<td align="center">
第七章
</td>
<td align="center">
第八章
</td>
<td align="center">
第九章
</td>
</tr>
<?php
$query = "SELECT * FROM score ORDER BY usr_stuno";
$ret = mysql_query($query, $link);
while ($row = getresult($ret)) {
?>
<tr>
<td align="center">
<?php
echo $row['usr_stuno'];
?>
</td>
<td align="center">
<?php
echo $row['usr_name'];
?>
</td>
<td align="center">
<?php
echo $row['score_2_1'] + $row['score_2_2'];
<?php
include_once "../conn.php";
$commentid = $_GET["commentid"];
getresult("update I_comment set against=against+1 where id={$commentid}");
$password = md5(trim($_POST["password"]));
$realname = $_POST["realname "];
$email = $_POST["email"];
$sex = $_POST["sex"];
$qq = $_POST["qq"];
$phone = $_POST["phone"];
$address = $_POST["address"];
if (strlen($username) < 4 || strlen($password) < 6) {
die("<script type='text/javascript'>alert('Sorry ,You have not registed!');history.back(-1);</script>");
}
if (getresultNumrows(getresult("select * from I_user where username='******'")) > 0) {
die("<script type='text/javascript'>alert('Sorry ,The username have existed!');history.back(-1);</script>");
}
$query = "insert into I_user(username,password,realname,email,sex,qq,tel,address) values('{$username}','{$password}','{$realname}','{$email}',{$sex},'{$qq}','{$phone}','{$address}')";
//echo $query;
if (!getresult($query)) {
die("<script type='text/javascript'>alert('Sorry ,You have not registed!');history.back(-1);</script>");
} else {
die("<script type='text/javascript'>alert('Congratulations,You have registe successfully!');window.location='{$preurl}'</script>");
}
}
?>
<div align="center">
<div style="font-family:'微软雅黑','宋体'; font-size:24px; font-weight:bold; text-align:left; width:760px">用户注册</div>
<div style="width:760px; border:solid #e1e1e1 5px;">
<form name="form" method="post" action="" onsubmit="return check();">
<input type="hidden" name="action" value="login" />
<table width="100%" border="0" cellspacing="8" cellpadding="0">
<tr>
<td colspan="3" id="table1">请注意：带有<span style="color:#FF0000"> * </span>的项目必须填写</td>
</tr>
echo gettext_r("cancle");
?>
" /></td>
</tr>
</table>
</form>
<?php
break;
case "modify":
$label = getresult("select * from I_mylabel where id ={$id}");
if ($_POST["submit"] == gettext_r("submit")) {
//修改自定义标签
$id = $_GET["id"];
$labelcontent = $_POST["labelcontent"];
//echo "update I_mylabel set labelcontent='$labelcontent' where id=$id";
if (getresult("update I_mylabel set labelcontent='" . mysql_escape_string($labelcontent) . "' where id={$id}")) {
die("<script type=\"text/javascript\">alert('" . gettext_r("update") . gettext_r("success") . "');window.location='admin_mylabel.php'</script>");
} else {
//echo "update I_mylabel set labelcontent='$labelcontent' where id=$id";
die("<script type=\"text/javascript\">alert('" . gettext_r("update") . gettext_r("fail") . "');history.back(-1);</script>");
}
}
?>
<form action="" method="post">
<table width="100%">
<tr>
<td class='label' width="150px"><?php
echo gettext_r("selfDefineTip");
?>
：</td>
<td><input type="text" name="labelname" disabled="disabled" value="<?php
</td>
<td align="center">
第九章
</td>
</tr>
<tr>
<td align="center">
<?php
echo $_SESSION['user'];
?>
</td>
<td align="center">
<?php
$query = "SELECT * FROM score WHERE usr_name='" . $_SESSION['user'] . "'";
$ret = mysql_query($query, $link);
$row = getresult($ret);
echo $row['score_2_2'];
?>
</td>
<td align="center">
<?php
echo $row['score_3_2'];
?>
</td>
<td align="center">
<?php
echo $row['score_4_2'];
?>
</td>
<td align="center">
<?php
<?php
include "../conn.php";
$adminname = $_GET["adminname"];
$tempresult = getresult("select * from I_admin where adminname='{$adminname}'");
if (getresultNumrows($tempresult) >= 1) {
echo "exist";
} else {
echo "not";
}