sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_authors"));
if ($first == 0) {
$pwd = md5($pwd);
$the_adm = "God";
$sql = "INSERT INTO ".$prefix."_authors VALUES ('$name', '$the_adm', '$url', '$email', '$pwd', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '')";
$db->sql_query($sql);
if ($user_new == 1) {
$user_regdate = date("M d, Y");
$user_avatar = "blank.gif";
$commentlimit = 4096;
if ($url == "http://") { $url = ""; }
$sql = "INSERT INTO ".$user_prefix."_users (user_id, username, user_email, user_website, user_avatar, user_regdate, user_password, theme, commentmax, user_lang, user_dateformat) VALUES (NULL,'$name','$email','$url','$user_avatar','$user_regdate','$pwd','$Default_Theme','$commentlimit','english','D M d, Y g:i a')";
$db->sql_query($sql);
}
login();
}
}
$the_first = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_authors"));
if ($the_first == 0) {
if (!$name) {
include("header.php");
title("$sitename: "._ADMINISTRATION."");
OpenTable();
echo "
"._NOADMINYET."
"
."";
CloseTable();
include("footer.php");
}
switch($fop) {
case "create_first":
create_first($name, $url, $email, $pwd, $user_new);
break;
}
die();
}
require("auth.php");
if(!isset($op)) { $op = "adminMain"; }
$pagetitle = "- "._ADMINMENU."";
/*********************************************************/
/* Login Function */
/*********************************************************/
function login() {
include ("header.php");
mt_srand ((double)microtime()*1000000);
$maxran = 1000000;
$random_num = mt_rand(0, $maxran);
OpenTable();
echo ""._ADMINLOGIN."";
CloseTable();
echo "
";
OpenTable();
echo "";
CloseTable();
include ("footer.php");
}
function gfx($random_num) {
global $prefix, $db;
require("config.php");
$datekey = date("F j");
$rcode = hexdec(md5($_SERVER[HTTP_USER_AGENT] . $sitekey . $random_num . $datekey));
$code = substr($rcode, 2, 6);
$image = ImageCreateFromJPEG("images/admin/code_bg.jpg");
$text_color = ImageColorAllocate($image, 80, 80, 80);
Header("Content-type: image/jpeg");
ImageString ($image, 5, 12, 2, $code, $text_color);
ImageJPEG($image, '', 75);
ImageDestroy($image);
die();
}
function deleteNotice($id, $table, $op_back) {
global $db;
$db->sql_query("DELETE FROM $table WHERE id = '$id'");
Header("Location: admin.php?op=$op_back");
}
/*********************************************************/
/* Administration Menu Function */
/*********************************************************/
function adminmenu($url, $title, $image) {
global $counter, $admingraphic, $Default_Theme;
$ThemeSel = get_theme();
if (file_exists("themes/$ThemeSel/images/admin/$image")) {
$image = "themes/$ThemeSel/images/admin/$image";
} else {
$image = "images/admin/$image";
}
if ($admingraphic == 1) {
$img = "
";
$close = "";
} else {
$image = "";
$close = "";
}
echo "$img$title$close
| ";
if ($counter == 5) {
echo "";
$counter = 0;
} else {
$counter++;
}
}
function GraphicAdmin() {
global $aid, $admingraphic, $language, $admin, $prefix, $db;
$newsubs = $db->sql_numrows($db->sql_query("SELECT qid FROM ".$prefix."_queue"));
$sql = "SELECT radminarticle,radmintopic,radminuser,radminsurvey,radminsection,radminlink,radminephem,radminfaq,radmindownload,radminreviews,radminnewsletter,radminforum,radmincontent,radminency,radminsuper FROM ".$prefix."_authors WHERE aid='$aid'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$radminarticle = $row[radminarticle];
$radmintopic = $row[radmintopic];
$radminuser = $row[radminuser];
$radminsurvey = $row[radminsurvey];
$radminsection = $row[radminsection];
$radminlink = $row[radminlink];
$radminephem = $row[radminephem];
$radminfaq = $row[radminfaq];
$radmindownload = $row[radmindownload];
$radminreviews = $row[radminreviews];
$radminnewsletter = $row[radminnewsletter];
$radminforum = $row[radminforum];
$radmincontent = $row[radmincontent];
$radminency = $row[radminency];
$radminsuper = $row[radminsuper];
OpenTable();
echo ""._ADMINMENU."";
echo "
";
echo"";
$linksdir = dir("admin/links");
while($func=$linksdir->read()) {
if(substr($func, 0, 6) == "links.") {
$menulist .= "$func ";
}
}
closedir($linksdir->handle);
$menulist = explode(" ", $menulist);
sort($menulist);
for ($i=0; $i < sizeof($menulist); $i++) {
if($menulist[$i]!="") {
$counter = 0;
include($linksdir->path."/$menulist[$i]");
}
}
adminmenu("admin.php?op=logout", ""._ADMINLOGOUT."", "logout.gif");
echo"
";
CloseTable();
echo "
";
}
/*********************************************************/
/* Administration Main Function */
/*********************************************************/
function adminMain() {
global $language, $admin, $aid, $prefix, $file, $db, $sitename, $user_prefix;
include ("header.php");
$dummy = 0;
$Today = getdate();
$month = $Today['month'];
$mday = $Today['mday'];
$year = $Today['year'];
$pmonth = $Today['month'];
$pmday = $Today['mday'];
$pmday = $mday-1;
$pyear = $Today['year'];
if ($pmonth=="January") { $pmonth=1; } else
if ($pmonth=="February") { $pmonth=2; } else
if ($pmonth=="March") { $pmonth=3; } else
if ($pmonth=="April") { $pmonth=4; } else
if ($pmonth=="May") { $pmonth=5; } else
if ($pmonth=="June") { $pmonth=6; } else
if ($pmonth=="July") { $pmonth=7; } else
if ($pmonth=="August") { $pmonth=8; } else
if ($pmonth=="September") { $pmonth=9; } else
if ($pmonth=="October") { $pmonth=10; } else
if ($pmonth=="November") { $pmonth=11; } else
if ($pmonth=="December") { $pmonth=12; };
$test = mktime (0,0,0,$pmonth,$pmday,$pyear,1);
$curDate2 = "%".$month[0].$month[1].$month[2]."%".$mday."%".$year."%";
$preday = strftime ("%d",$test);
$premonth = strftime ("%B",$test);
$preyear = strftime ("%Y",$test);
$curDateP = "%".$premonth[0].$premonth[1].$premonth[2]."%".$preday."%".$preyear."%";
GraphicAdmin();
$sql = "SELECT radminarticle, radminsuper, admlanguage FROM ".$prefix."_authors WHERE aid='$aid'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$radminarticle = $row[radminarticle];
$radminsuper = $row[radminsuper];
$admlanguage = $row[admlanguage];
if ($admlanguage != "" ) {
$queryalang = "WHERE alanguage='$admlanguage' ";
} else {
$queryalang = "";
}
$sql = "SELECT main_module from ".$prefix."_main";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$main_module = $row[main_module];
OpenTable();
echo "$sitename: "._DEFHOMEMODULE."
"
.""._MODULEINHOME." $main_module
[ "._CHANGE." ]";
CloseTable();
echo "
";
OpenTable();
$guest_online_num = $db->sql_numrows($db->sql_query("SELECT uname FROM ".$prefix."_session WHERE guest='1'"));
$member_online_num = $db->sql_numrows($db->sql_query("SELECT uname FROM ".$prefix."_session WHERE guest='0'"));
$who_online_num = $guest_online_num + $member_online_num;
$who_online = ""._WHOSONLINE."
"._CURRENTLY." $guest_online_num "._GUESTS." $member_online_num "._MEMBERS."
";
$sql = "SELECT COUNT(user_id) AS userCount from $user_prefix"._users." WHERE user_regdate LIKE '$curDate2'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$userCount = $row[userCount];
$sql = "SELECT COUNT(user_id) AS userCount FROM $user_prefix"._users." WHERE user_regdate LIKE '$curDateP'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$userCount2 = $row[userCount];
echo "$who_online
"
.""._BTD.": $userCount - "._BYD.": $userCount2";
CloseTable();
echo "
";
OpenTable();
echo ""._AUTOMATEDARTICLES."
";
$count = 0;
$sql = "SELECT anid, aid, title, time, alanguage FROM ".$prefix."_autonews $queryalang ORDER BY time ASC";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$anid = $row[anid];
$said = $row[aid];
$title = $row[title];
$time = $row[time];
$alanguage = $row[alanguage];
if ($alanguage == "") {
$alanguage = ""._ALL."";
}
if ($anid != "") {
if ($count == 0) {
echo "";
$count = 1;
}
$time = ereg_replace(" ", "@", $time);
if (($radminarticle==1) OR ($radminsuper==1)) {
if (($radminarticle==1) AND ($aid == $said) OR ($radminsuper==1)) {
echo "| ("._EDIT."-"._DELETE.") | $title | $alanguage | $time |
"; /* Multilingual Code : added column to display language */
} else {
echo "| ("._NOFUNCTIONS.") | $title | $alanguage | $time |
"; /* Multilingual Code : added column to display language */
}
} else {
echo "| $title | $alanguage | $time |
"; /* Multilingual Code : added column to display language */
}
}
}
if (($anid == "") AND ($count == 0)) {
echo ""._NOAUTOARTICLES."";
}
if ($count == 1) {
echo "
";
}
CloseTable();
echo "
";
OpenTable();
echo ""._LAST." 20 "._ARTICLES."
";
$sql = "SELECT sid, aid, title, time, topic, informant, alanguage FROM ".$prefix."_stories $queryalang ORDER BY time DESC LIMIT 0,20";
$result = $db->sql_query($sql);
echo "";
while ($row = $db->sql_fetchrow($result)) {
$sid = $row[sid];
$said = $row[aid];
$title = $row[title];
$time = $row[time];
$topic = $row[topic];
$informant = $row[informant];
$alanguage = $row[alanguage];
$sql = "SELECT topicname FROM ".$prefix."_topics WHERE topicid='$topic'";
$ta = $db->sql_query($sql);
$row = $db->sql_fetchrow($ta);
$topicname = $row[topicname];
if ($alanguage == "") {
$alanguage = ""._ALL."";
}
formatTimestamp($time);
echo "| $sid"
." | $title"
." | $alanguage"
." | $topicname";
if (($radminarticle==1) OR ($radminsuper==1)) {
if (($radminarticle==1) AND ($aid == $said) OR ($radminsuper==1)) {
echo " | ("._EDIT."-"._DELETE.")"
." |
";
} else {
echo "("._NOFUNCTIONS.")"
." | ";
}
} else {
echo "";
}
}
echo "
";
if (($radminarticle==1) OR ($radminsuper==1)) {
echo ""
."";
}
CloseTable();
$sql = "SELECT pollID, pollTitle FROM ".$prefix."_poll_desc WHERE artid='0' ORDER BY pollID DESC LIMIT 1";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$pollID = $row[pollID];
$pollTitle = $row[pollTitle];
echo "
";
OpenTable();
echo ""._CURRENTPOLL.": $pollTitle [ "._EDIT." | "._ADD." ]";
CloseTable();
include ("footer.php");
}
if($admintest) {
switch($op) {
case "do_gfx":
do_gfx();
break;
case "deleteNotice":
deleteNotice($id, $table, $op_back);
break;
case "GraphicAdmin":
GraphicAdmin();
break;
case "adminMain":
adminMain();
break;
case "logout":
setcookie("admin");
$admin = "";
include("header.php");
OpenTable();
echo ""._YOUARELOGGEDOUT."";
CloseTable();
include("footer.php");
break;
case "login";
unset($op);
default:
$casedir = dir("admin/case");
while($func=$casedir->read()) {
if(substr($func, 0, 5) == "case.") {
include($casedir->path."/$func");
}
}
closedir($casedir->handle);
break;
}
} else {
switch($op) {
case "gfx":
gfx($random_num);
break;
default:
login();
break;
}
}
?>