nuke/html/admin.php

<?PHP

######################################################################
# PHP-NUKE: Web Portal System
# ===========================
#
# Copyright (c) 2000 by Francisco Burzi (fburzi@ncc.org.ve)
# http://www.ncc.org.ve/php-nuke.php
#
# This modules is the main administration part
#
# This program is free software. You can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License.
######################################################################

include("auth.inc.php");
if (!IsSet($mainfile)) { include ('mainfile.php'); }

/*********************************************************/
/* Login Function                                        */
/*********************************************************/

function login() {
        include ('header.php');
?>

<form action="admin.php" method="post">
<table col=2>
<tr><td><?php echo translate("AdminID"); ?></td>
    <td><input type="text" NAME="aid" SIZE=20 MAXLENGTH=20></td></tr>
<tr><td><?php echo translate("Password"); ?></td>
    <td><input type="password" NAME="pwd" SIZE=20 MAXLENGTH=18> </td></tr>
    <input type="hidden" NAME="op" value="login">
<tr><td colspan=2><input type="submit" VALUE="<?php echo translate("Login"); ?>"></td></tr>
</table>
</form>
<?
        include ('footer.php');
}

/*********************************************************/
/* Administration Menu Function                          */
/*********************************************************/

function GraphicAdmin() {
        include ("config.php");
        if ($admingraphic) {
        echo "
        <center>$font4<b><a href=admin.php>".translate("Administration Menu")."</a></b>";
        if($banners) {
            echo"
            &nbsp;&nbsp;&nbsp;<b><a href=admin.php?op=BannersAdmin>".translate("Banners Administration")."</a></center></b><br><br>";
        } else {
            echo "</center><br><br>";
        }
        echo"
        <table border=0 width=100% cellspacing=1><tr>
        <td align=center><a href=admin.php?op=adminStory><img src=images/menu/admin/postnew.gif border=0></a><br>$font2<b>".translate("NEW Article")."</b>
        </td><td align=center><a href=admin.php?op=topicsmanager><img src=images/menu/admin/topicsman.gif border=0></a><br>$font2<b>".translate("Topics Manager")."</b>
        </td><td align=center><a href=admin.php?op=lblocks><img src=images/menu/admin/leftblock.gif border=0></a><br>$font2<b>".translate("Left Blocks")."</b>
        </td><td align=center><a href=admin.php?op=rblocks><img src=images/menu/admin/rightblock.gif border=0></a><br>$font2<b>".translate("Right Blocks")."</b>
        </td><td align=center><a href=admin.php?op=mod_users><img src=images/menu/admin/users.gif border=0></a><br>$font2<b>".translate("Edit Users")."</b>
        </td><td align=center><a href=admin.php?op=mod_authors><img src=images/menu/admin/authors.gif border=0></a><br>$font2<b>".translate("Edit Admins")."</b>
        </tr><tr>
        </td><td align=center><a href=admin.php?op=ablock><img src=images/menu/admin/adminblock.gif border=0></a><br>$font2<b>".translate("Admin Block")."</b>
        </td><td align=center><a href=admin.php?op=mblock><img src=images/menu/admin/mainblock.gif border=0></a><br>$font2<b>".translate("Main Block")."</b>
        </td><td align=center><a href=admin.php?op=create><img src=images/menu/admin/newpoll.gif border=0></a><br>$font2<b>".translate("Surveys/Polls")."</b>
        </td><td align=center><a href=admin.php?op=hreferer><img src=images/menu/admin/referer.gif border=0></a><br>$font2<b>".translate("HTTP Referers")."</b>
        </td><td align=center><a href=admin.php?op=sections><img src=images/menu/admin/sections.gif border=0></a><br>$font2<b>".translate("Sections Manager")."</b>
        </td><td align=center><a href=admin.php?op=links><img src=images/menu/admin/links.gif border=0></a><br>$font2<b>".translate("Web Links")."</b>
        </tr><tr>
        </td><td align=center><a href=admin.php?op=events><img src=images/menu/admin/events.gif border=0></a><br>$font2<b>".translate("Events")."</b>
        </td><td align=center><a href=admin.php?op=logout><img src=images/menu/admin/exit.gif border=0></a><br>$font2<b>".translate("Logout / Exit")."</b>
        </td></tr></table></center><br><br>$font3";
        
        } else {
        
        echo "
        <center>$font4<b><a href=admin.php>".translate("Administration Menu")."</a></b>";
        if($banners) {
            echo"
            &nbsp;&nbsp;&nbsp;<b><a href=admin.php?op=BannersAdmin>".translate("Banners Administration")."</a></center></b><br><br>";
        } else {
            echo "</center><br><br>";
        }
        echo "
        <table border=0 width=100% cellspacing=1><tr>
        <td align=center><a href=admin.php?op=adminStory>$font2<b>".translate("NEW Article")."</b></a>
        </td><td align=center><a href=admin.php?op=topicsmanager>$font2<b>".translate("Topics Manager")."</b></a>
        </td><td align=center><a href=admin.php?op=lblocks>$font2<b>".translate("Left Blocks")."</b></a>
        </td><td align=center><a href=admin.php?op=rblocks>$font2<b>".translate("Right Blocks")."</b></a>
        </td><td align=center><a href=admin.php?op=mod_users>$font2<b>".translate("Edit Users")."</b></a>
        </td><td align=center><a href=admin.php?op=mod_authors>$font2<b>".translate("Edit Admins")."</b></a>
        </tr><tr>
        </td><td align=center><a href=admin.php?op=ablock>$font2<b>".translate("Admin Block")."</b></a>
        </td><td align=center><a href=admin.php?op=mblock>$font2<b>".translate("Main Block")."</b></a>
        </td><td align=center><a href=admin.php?op=create>$font2<b>".translate("Surveys/Polls")."</b></a>
        </td><td align=center><a href=admin.php?op=hreferer>$font2<b>".translate("HTTP Referers")."</b></a>
        </td><td align=center><a href=admin.php?op=sections>$font2<b>".translate("Sections Manager")."</b></a>
        </td><td align=center><a href=admin.php?op=links>$font2<b>".translate("Web Links")."</b></a>
        </tr><tr>
        </td><td align=center><a href=admin.php?op=events>$font2<b>".translate("Events")."</b></a>
        </td><td align=center><a href=admin.php?op=logout>$font2<b>".translate("Logout / Exit")."</b></a>
        </td></tr></table></center><br><br>$font3";

        }
}

/*********************************************************/
/* Events Functions to have a Historic Events            */
/*********************************************************/

function events() {
    include ("header.php");
    GraphicAdmin();
    dbconnect();
    echo "
    <table border=0 width=100% cellpadding=0 cellspacing=1 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=0 bgcolor=FFFFFF><tr><td>
    <center><font face=Verdana,Arial,Helvetica size=4><b>".translate("Events")."</b></center><br><br>
    <font size=3><b>".translate("Add Event:")."</b><br><br><font size=2>
    <form action=admin.php method=post>";
    $nday = "1";
    echo "".translate("Day:")." <select name=did>";
    while ($nday<=31) {
        echo "<option name=did>$nday</option>";
        $nday++;
    }
    echo "</select>";
    $nmonth = "1";
    echo "".translate("Month:")." <select name=mid>";
    while ($nmonth<=12) {
        echo "<option name=mid>$nmonth</option>";
        $nmonth++;
    }
    echo "</select>".translate("Year:")." <input type=text name=yid maxlength=4 size=5><br><br>
    ".translate("Event Description:")."<br>
    <textarea name=content cols=60 rows=10></textarea><br><br>
    <input type=hidden name=op value=eventsadd>
    <input type=submit value=".translate("Send").">
    </form>
    
    <br><br>
    <font size=3><b>".translate("Event Maintenance (Edit/Delete):")."</b><br><br><foint size=2>
    <form action=admin.php method=post>";
    $nday = "1";
    echo "".translate("Day:")." <select name=did>";
    while ($nday<=31) {
        echo "<option name=did>$nday</option>";
        $nday++;
    }
    echo "</select>";
    $nmonth = "1";
    echo "".translate("Month:")." <select name=mid>";
    while ($nmonth<=12) {
        echo "<option name=mid>$nmonth</option>";
        $nmonth++;
    }
    echo "
    <br><br>
    <input type=hidden name=op value=eventsmaintenance>
    <input type=submit value=".translate("Edit").">
    </form>
    
    </td></tr></table></td></tr></table>
    ";
    include ('footer.php');
}

function eventsadd($did, $mid, $yid, $content) {
    dbconnect();
    mysql_query("insert into ephem values (NULL, '$did', '$mid', '$yid', '$content')");
    Header("Location: admin.php?op=events");    
}

function eventsmaintenance($did, $mid) {
    include ("header.php");
    GraphicAdmin();
    dbconnect();
    echo "<table border=0 width=100% cellpadding=0 cellspacing=1 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=0 bgcolor=FFFFFF><tr><td>
    <center><font face=Verdana,Arial,Helvetica size=4><b>".translate("Events Maintenance")."</b></center><br><br>";
    $result=mysql_query("select eid, did, mid, yid, content from ephem where did=$did AND mid=$mid");
    while(list($eid, $did, $mid, $yid, $content) = mysql_fetch_row($result)) {
    echo "<font face=Verdana,Arial,Helvetica size=2><b>$yid</b> [ <a href=admin.php?op=eventsedit&eid=$eid&did=$did&mid=$mid>".translate("Edit")."</a> | <a href=admin.php?op=eventsdel&eid=$eid&did=$did&mid=$mid>".translate("Delete")."</a> ]<br>
    <font size=1>$content<br><br><br>";
    }
    echo "</td></tr></table></td></tr></table>";
    include ('footer.php');
}

function eventsdel($eid, $did, $mid) {
    dbconnect();
    mysql_query("delete from ephem where eid=$eid");
    Header("Location: admin.php?op=eventsmaintenance&did=$did&mid=$mid");
}

function eventsedit($eid, $did, $mid) {
    include ("header.php");
    GraphicAdmin();
    dbconnect();
    $result=mysql_query("select yid, content from ephem where eid=$eid");
    list($yid, $content) = mysql_fetch_row($result);
    echo "
    <table border=0 width=100% cellpadding=0 cellspacing=1 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=0 bgcolor=FFFFFF><tr><td>
    <center><font face=Verdana,Arial,Helvetica size=4><b>".translate("Events Maintenance")."</b></center><br><br>
    <font size=3><b>".translate("Edit Event:")."</b><br><br><font size=2>
    <form action=admin.php method=post>";
    echo "".translate("Year:")." <input type=text name=yid value=$yid maxlength=4 size=5><br><br>
    ".translate("Event Description:")."<br>
    <textarea name=content cols=60 rows=10>$content</textarea><br><br>
    <input type=hidden name=did value=$did>
    <input type=hidden name=mid value=$mid>
    <input type=hidden name=eid value=$eid>
    <input type=hidden name=op value=eventschange>
    <input type=submit value=".translate("Send").">
    </form>
    </td></tr></table></td></tr></table>
    ";
    include ('footer.php');
}

function eventschange($eid, $did, $mid, $yid, $content) {
    dbconnect();
    $content = stripslashes(FixQuotes($content));
    mysql_query("update ephem set yid='$yid', content='$content' where eid=$eid");
    Header("Location: admin.php?op=eventsmaintenance&did=$did&mid=$mid");    
}

/*********************************************************/
/* Web Links Functions to have a fun Search Engine       */
/*********************************************************/

function links() {
    include ("header.php");
    GraphicAdmin();
    dbconnect();
    echo "
    <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
    <center><a href=links.php><img src=images/links/web.gif border=0></a><br><br>";
    $result=mysql_query("select * from links_links");
    $numrows = mysql_num_rows($result);
    echo "<font size=2 face=Arial,Helvetica>".translate("There are")." <b>$numrows</b> ".translate("Links in our Database")."";
    echo "</td></tr></table></td></tr></table><br>";

// List Links waiting for validation

    $result = mysql_query("select lid, cid, sid, title, url, description, name, email from links_newlink order by lid");
    $numrows = mysql_num_rows($result);
    if ($numrows>0) {
    echo "
    <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
    </center><font face=Arial,Helvetica size=3><b>".translate("Links Waiting for Validation")."</b><br><br><font size=2>";
    while(list($lid, $cid, $sid, $title, $url, $description, $name, $email) = mysql_fetch_row($result)) {
        echo "<form action=admin.php method=post>";
        echo "<font color=Blue>".translate("Link ID: ")."<font color=Black><b>$lid</b><br>";
        echo "".translate("Page Title: ")."<input type=text name=title value=\"$title\" size=50 maxlength=100><br>";
        echo "".translate("Page URL: ")."<input type=text name=url value=$url size=50 maxlength=100>&nbsp;[ <a target=_blank href=$url>".translate("Visit")."</a> ]<br>";
        echo "".translate("Description: ")."<br><textarea name=description cols=60 rows=10>$description</textarea><br>";
        echo "".translate("Name: ")."<input type=text name=name size=20 maxlength=100 value=\"$name\">&nbsp;&nbsp;";
        echo "".translate("Email: ")."<input type=text name=email size=20 maxlength=100 value=$email><br>";

        $result2=mysql_query("select cid, title from links_categories order by title");
        echo "<input type=hidden name=new value=1>";
        echo "<input type=hidden name=lid value=$lid>";
        echo "".translate("Category: ")."<select name=cat>";
        while(list($ccid, $ctitle) = mysql_fetch_row($result2)) {
            $sel = "";
            if ($cid==$ccid AND $sid==0) {
                $sel = "selected";
            }
            echo "<option value=$ccid $sel>$ctitle</option>";
            $result3=mysql_query("select sid, title from links_subcategories where cid=$ccid order by title");
            while(list($ssid, $stitle) = mysql_fetch_row($result3)) {
                $sel = "";
                if ($sid==$ssid) {
                    $sel = "selected";
                }
                echo "<option value=$ccid-$ssid $sel>$ctitle / $stitle</option>";
            }
        }
    echo "</select><input type=hidden name=op value=LinksAddLink><input type=submit value=".translate("Add")."> [ <a href=admin.php?op=LinksDelNew&lid=$lid>".translate("Delete")."</a> ]</form><br><hr noshade><br>";
        
    }
    echo "</td></tr></table></td></tr></table><br>";
    } else {
    }

// Add a New Main Category

    echo "
    <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
    </center><form method=post action=admin.php>
    <font face=Arial,Helvetica size=3><b>".translate("Add a MAIN Category")."</b><br><br>
    ".translate("Name: ")."<input type=text name=title size=30 maxlength=100>
    <input type=hidden name=op value=LinksAddCat>
    <input type=submit value=".translate("Add")."><br>
    </td></tr></table></td></tr></table></form><br>";

// Add a New Sub-Category

    $result = mysql_query("select * from links_categories");
    $numrows = mysql_num_rows($result);
    if ($numrows>0) {
    echo "
    <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
    </center><form method=post action=admin.php>
    <font face=Arial,Helvetica size=3><b>".translate("Add a SUB-Category")."</b><br><br>
    ".translate("Name: ")."<input type=text name=title size=30 maxlength=100>&nbsp;".translate("in")."&nbsp;";
    
    $result=mysql_query("select cid, title from links_categories order by title");
    echo "<select name=cid>";
    while(list($ccid, $ctitle) = mysql_fetch_row($result)) {
        echo "<option value=$ccid>$ctitle</option>";
    }
    echo "</select>
    <input type=hidden name=op value=LinksAddSubCat>
    <input type=submit value=".translate("Add")."><br>
    </td></tr></table></td></tr></table></form><br>";
    } else {
    }

// Add a New Link to Database

    $result = mysql_query("select cid, title from links_categories");
    $numrows = mysql_num_rows($result);
    if ($numrows>0) {
    echo "
    <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
    </center><form method=post action=admin.php>
    <font face=Arial,Helvetica size=3><b>".translate("Add a New Link")."</b><br><br>
    ".translate("Page Title: ")."<input type=text name=title size=50 maxlength=100><br>
    ".translate("Page URL: ")."<input type=text name=url size=50 maxlength=100 value=\"http://\"><br>";
    $result=mysql_query("select cid, title from links_categories order by title");
    echo "".translate("Category: ")."<select name=cat>";
    while(list($cid, $title) = mysql_fetch_row($result)) {
        echo "<option value=$cid>$title</option>";
        $result2=mysql_query("select sid, title from links_subcategories where cid=$cid order by title");
        while(list($sid, $stitle) = mysql_fetch_row($result2)) {
            echo "<option value=$cid-$sid>$title / $stitle</option>";
        }
    }
    echo "</select><br><br><br>
    ".translate("Description: (255 characters max)")."<br><textarea name=description cols=60 rows=5></textarea><br><br><br>
    ".translate("Name: ")."<input type=text name=name size=30 maxlength=60><br>
    ".translate("E-Mail: ")."<input type=text name=email size=30 maxlength=60><br><br>
    <input type=hidden name=op value=LinksAddLink>
    <input type=hidden name=new value=0>
    <input type=hidden name=lid value=0>
    <center><input type=submit value=".translate("Add URL")."><br>
    </td></tr></table></td></tr></table></form><br>";

    } else {
    }

// Modify Category

    $result = mysql_query("select * from links_categories");
    $numrows = mysql_num_rows($result);
    if ($numrows>0) {
    echo "
    <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
    </center><form method=post action=admin.php>
    <font face=Arial,Helvetica size=3><b>".translate("Modify Category")."</b><br><br>";
    $result=mysql_query("select cid, title from links_categories order by title");
    echo "".translate("Category: ")."<select name=cat>";
    while(list($cid, $title) = mysql_fetch_row($result)) {
        echo "<option value=$cid>$title</option>";
        $result2=mysql_query("select sid, title from links_subcategories where cid=$cid order by title");
        while(list($sid, $stitle) = mysql_fetch_row($result2)) {
            echo "<option value=$cid-$sid>$title / $stitle</option>";
        }
    }
    echo "</select>
    <input type=hidden name=op value=LinksModCat>
    <input type=submit value=".translate("Modify").">
    </td></tr></table></td></tr></table></form><br>";
    } else {
    }

// Modify Links

    $result = mysql_query("select * from links_links");
    $numrows = mysql_num_rows($result);
    if ($numrows>0) {
    echo "
    <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
    </center><form method=post action=admin.php>
    <font face=Arial,Helvetica size=3><b>".translate("Modify Links")."</b><br><br>
    ".translate("Link ID: ")."<input type=text name=lid size=12 maxlength=11>
    <input type=hidden name=op value=LinksModLink>
    <input type=submit value=".translate("Modify").">
    </td></tr></table></td></tr></table></form><br>";
    } else {
    }


    include ("footer.php");
}

function LinksModLink($lid) {
    include ("header.php");
    GraphicAdmin();
    $result = mysql_query("select cid, sid, title, url, description, name, email, hits from links_links where lid=$lid");
    echo "
    <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
    </center><font face=Arial,Helvetica size=3><b>".translate("Modify Links")."</b><br><br><font size=2>";
    while(list($cid, $sid, $title, $url, $description, $name, $email, $hits) = mysql_fetch_row($result)) {
        echo "<form action=admin.php method=post>";
        echo "<font color=Blue>".translate("Link ID: ")."<font color=Black><b>$lid</b><br>";
        echo "".translate("Page Title: ")."<input type=text name=title value=\"$title\" size=50 maxlength=100><br>";
        echo "".translate("Page URL: ")."<input type=text name=url value=$url size=50 maxlength=100>&nbsp;[ <a href=$url>Visit</a> ]<br>";
        echo "".translate("Description: ")."<br><textarea name=description cols=60 rows=10>$description</textarea><br>";
        echo "".translate("Name: ")."<input type=text name=name size=50 maxlength=100 value=\"$name\"><br>";
        echo "".translate("E-Mail: ")."<input type=text name=email size=50 maxlength=100 value=\"$email\"><br>";
        echo "".translate("Hits: ")."<input type=text name=hits value=$hits size=12 maxlength=11><br>";
        $result2=mysql_query("select cid, title from links_categories order by title");
        echo "<input type=hidden name=lid value=$lid>";
        echo "".translate("Category: ")."<select name=cat>";
        while(list($ccid, $ctitle) = mysql_fetch_row($result2)) {
            $sel = "";
            if ($cid==$ccid AND $sid==0) {
                $sel = "selected";
            }
            echo "<option value=$ccid $sel>$ctitle</option>";
            $result3=mysql_query("select sid, title from links_subcategories where cid=$ccid order by title");
            while(list($ssid, $stitle) = mysql_fetch_row($result3)) {
                $sel = "";
                if ($sid==$ssid) {
                    $sel = "selected";
                }
                echo "<option value=$ccid-$ssid $sel>$ctitle / $stitle</option>";
            }
        }
    echo "</select><input type=hidden name=op value=LinksModLinkS><input type=submit value=".translate("Modify")."> [ <a href=admin.php?op=LinksDelLink&lid=$lid>".translate("Delete")."</a> ]<br>";
        
    }
    echo "</td></tr></table></td></tr></table></form><br>";
    include ("footer.php");
}

function LinksModLinkS($lid, $title, $url, $description, $name, $email, $hits, $cat) {
    $cat = explode("-", $cat);
    if ($cat[1]=="") {
        $cat[1] = 0;
    }
    $title = stripslashes(FixQuotes($title));
    $url = stripslashes(FixQuotes($url));
    $description = stripslashes(FixQuotes($description));
    $name = stripslashes(FixQuotes($name));
    $email = stripslashes(FixQuotes($email));
    mysql_query("update links_links set cid='$cat[0]', sid='$cat[1]', title='$title', url='$url', description='$description', name='$name', email='$email', hits='$hits' where lid=$lid");
    Header("Location: admin.php?op=links");
}

function LinksDelLink($lid) {
    mysql_query("delete from links_links where lid=$lid");
    Header("Location: admin.php?op=links");
}

function LinksModCat($cat) {
    include ("header.php");
    GraphicAdmin();
    dbconnect();
    $cat = explode("-", $cat);
    if ($cat[1]=="") {
        $cat[1] = 0;
    }
    echo "
    <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
    <font size=3 face=Arial,Helvetica><b>".translate("Modify Category")."</b><br><br>";
    if ($cat[1]==0) {
        $result=mysql_query("select title from links_categories where cid=$cat[0]");
        list($title) = mysql_fetch_row($result);
        echo "<form action=admin.php method=get>
        ".translate("Name: ")."<input type=text name=title value=\"$title\" size=51 maxlength=50><br>
        <input type=hidden name=sub value=\"0\">
        <input type=hidden name=cid value=$cat[0]>
        <input type=hidden name=op value=LinksModCatS>
        <table border=0><tr><td><font size=3 face=Arial,Helvetica>
        <input type=submit value=".translate("Save Changes")."></td><td><font size=3 face=Arial,Helvetica></form>
        <form action=admin.php method=get>
        <input type=hidden name=sub value=\"0\">
        <input type=hidden name=cid value=$cat[0]>
        <input type=hidden name=op value=LinksDelCat>
        <input type=submit value=".translate("Delete")."></td></tr></table></form>";
    } else {
        $result=mysql_query("select title from links_categories where cid=$cat[0]");
        list($ctitle) = mysql_fetch_row($result);
        $result2=mysql_query("select title from links_subcategories where sid=$cat[1]");
        list($stitle) = mysql_fetch_row($result2);
        echo "<form action=admin.php method=get>
        ".translate("Category Name: ")."$ctitle<br>
        ".translate("Sub-Category Name: ")."<input type=text name=title value=\"$stitle\" size=51 maxlength=50><br>
        <input type=hidden name=sub value=1>
        <input type=hidden name=cid value=$cat[0]>
        <input type=hidden name=sid value=$cat[1]>
        <input type=hidden name=op value=LinksModCatS>
        <table border=0><tr><td><font size=3 face=Arial,Helvetica>
        <input type=submit value=".translate("Save Changes")."></td><td><font size=3 face=Arial,Helvetica></form>
        <form action=admin.php method=get>
        <input type=hidden name=sub value=1>
        <input type=hidden name=cid value=$cat[0]>
        <input type=hidden name=sid value=$cat[1]>
        <input type=hidden name=op value=LinksDelCat>
        <input type=submit value=".translate("Delete")."></td></tr></table></form>";
    }
    
    echo "</td></tr></table></td></tr></table><br>";
    include("footer.php");
}

function LinksModCatS($cid, $sid, $sub, $title) {
    if ($sub==0) {
        mysql_query("update links_categories set title='$title' where cid=$cid");
    } else {
        mysql_query("update links_subcategories set title='$title' where sid=$sid");
    }
    
    Header("Location: admin.php?op=links");
}

function LinksDelCat($cid, $sid, $sub, $ok=0) {
    if($ok==1) {
        if ($sub>0) {
            mysql_query("delete from links_subcategories where sid=$sid");
            mysql_query("delete from links_links where sid=$sid");
        } else {
            mysql_query("delete from links_categories where cid=$cid");
            mysql_query("delete from links_subcategories where cid=$cid");
            mysql_query("delete from links_links where cid=$cid AND sid=0");
        }
        Header("Location: admin.php?op=links");    

    } else {

        include("header.php");
        GraphicAdmin();
        echo "<TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=1 BORDER=0 BGCOLOR=000000><TR><TD COLSPAN=2>
        <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=8 BORDER=0 BGCOLOR=FFFFFF><TR><TD><center><br>";
        echo "<font face=Arial,Helvetica size=3 color=Red>";
        echo "<b>".translate("WARNING: Are you sure you want to delete this Category and ALL its Links?")."</b><br><br><font color=Black>";
    }
        echo "[ <a href=admin.php?op=LinksDelCat&cid=$cid&sid=$sid&sub=$sub&ok=1>".translate("Yes")."</a> | <a href=admin.php?op=links>".translate("No")."</a> ]<br><br>";
        echo "</TD></TR></TABLE></TD></TR></TABLE>";
        include("footer.php");  
    
}


function LinksDelNew($lid) {
    mysql_query("delete from links_newlink where lid=$lid");
    Header("Location: admin.php?op=links");
}

function LinksAddCat($title) {
    $result = mysql_query("select cid from links_categories where title='$title'");
    $numrows = mysql_num_rows($result);
    if ($numrows>0) {
        include("header.php");
        GraphicAdmin();
        echo "<TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=1 BORDER=0 BGCOLOR=000000><TR><TD COLSPAN=2>
        <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=8 BORDER=0 BGCOLOR=FFFFFF><TR><TD><center><br>";
        echo "<font face=Arial,Helvetica size=3 color=Red>";
        echo "<b>".translate("ERROR: The Category")." $title ".translate("already exist!")."</b><br><br>";
        echo "</TD></TR></TABLE></TD></TR></TABLE>";
        include("footer.php");
    } else {
        mysql_query("insert into links_categories values (NULL, '$title')");
        Header("Location: admin.php?op=links");
    }
}

function LinksAddSubCat($cid, $title) {
    $result = mysql_query("select cid from links_subcategories where title='$title' AND cid='$cid'");
    $numrows = mysql_num_rows($result);
    if ($numrows>0) {
        include("header.php");
        GraphicAdmin();
        echo "<TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=1 BORDER=0 BGCOLOR=000000><TR><TD COLSPAN=2>
        <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=8 BORDER=0 BGCOLOR=FFFFFF><TR><TD><center><br>";
        echo "<font face=Arial,Helvetica size=3 color=Red>";
        echo "<b>".translate("ERROR: The SubCategory")." $title ".translate("already exist!")."</b><br><br>";
        echo "</TD></TR></TABLE></TD></TR></TABLE>";
        include("footer.php");
    } else {
        mysql_query("insert into links_subcategories values (NULL, '$cid', '$title')");
        Header("Location: admin.php?op=links");
    }
}


function LinksAddLink($new, $lid, $title, $url, $cat, $description, $name, $email) {
    dbconnect();
    $result = mysql_query("select url from links_links where url='$url'");
    $numrows = mysql_num_rows($result);
    if ($numrows>0) {
        include("header.php");
        GraphicAdmin();
        echo "<TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=1 BORDER=0 BGCOLOR=000000><TR><TD COLSPAN=2>
        <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=8 BORDER=0 BGCOLOR=FFFFFF><TR><TD><center><br>";
        echo "<font face=Arial,Helvetica size=3 color=Red>";
        echo "<b>".translate("ERROR: This URL is already listed in the Database!")."</b><br><br>";
        echo "</TD></TR></TABLE></TD></TR></TABLE>";
        include("footer.php");
    } else {

// Check if Title exist
    if ($title=="") {
        include("header.php");
        GraphicAdmin();
        echo "<TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=1 BORDER=0 BGCOLOR=000000><TR><TD COLSPAN=2>
        <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=8 BORDER=0 BGCOLOR=FFFFFF><TR><TD><center><br>";
        echo "<font face=Arial,Helvetica size=3 color=Red>";
        echo "<b>".translate("ERROR: You need to type a TITLE for your URL!")."</b><br><br>";
        echo "</TD></TR></TABLE></TD></TR></TABLE>";
        include("footer.php");
    }
// Check if URL exist
    if ($url=="") {
        include("header.php");
        GraphicAdmin();
        echo "<TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=1 BORDER=0 BGCOLOR=000000><TR><TD COLSPAN=2>
        <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=8 BORDER=0 BGCOLOR=FFFFFF><TR><TD><center><br>";
        echo "<font face=Arial,Helvetica size=3 color=Red>";
        echo "<b>".translate("ERROR: You need to type a URL for your URL!")."</b><br><br>";
        echo "</TD></TR></TABLE></TD></TR></TABLE>";
        include("footer.php");
    }
// Check if Description exist
    if ($description=="") {
        include("header.php");
        GraphicAdmin();
        echo "<TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=1 BORDER=0 BGCOLOR=000000><TR><TD COLSPAN=2>
        <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=8 BORDER=0 BGCOLOR=FFFFFF><TR><TD><center><br>";
        echo "<font face=Arial,Helvetica size=3 color=Red>";
        echo "<b>".translate("ERROR: You need to type a DESCRIPTION for your URL!")."</b><br><br>";
        echo "</TD></TR></TABLE></TD></TR></TABLE>";
        include("footer.php");
    }
    $cat = explode("-", $cat);
    if ($cat[1]=="") {
        $cat[1] = 0;
    }
    $title = stripslashes(FixQuotes($title));
    $url = stripslashes(FixQuotes($url));
    $description = stripslashes(FixQuotes($description));
    $name = stripslashes(FixQuotes($name));
    $email = stripslashes(FixQuotes($email));
    dbconnect();
    mysql_query("insert into links_links values (NULL, '$cat[0]', '$cat[1]', '$title', '$url', '$description', now(), '$name', '$email', '0')");
    include("header.php");
    GraphicAdmin();
    echo "<TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=1 BORDER=0 BGCOLOR=000000><TR><TD COLSPAN=2>
    <TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=8 BORDER=0 BGCOLOR=FFFFFF><TR><TD><center><br>";
    echo "<font face=Arial,Helvetica size=3>";
    echo "".translate("New Link added to the Database")."<br><br>";
    echo "</TD></TR></TABLE></TD></TR></TABLE>";
    if ($new==1) {
        mysql_query("delete from links_newlink where lid=$lid");
        if ($email=="") {
        } else {
            $subject = "".translate("Your Link at $sitename")."";
            $message = "".translate("Hello")." $name:\n\n".translate("We approved your link submission for our search engine.")."\n\n".translate("Page Name: ")."$title\n".translate("Page URL: ")."$url\n".translate("Description: ")."$description\n\n\n".translate("You can browse our search engine at:")." $nuke_url/links.php\n\n".translate("Thanks for your submission!")."\n\n$sitename ".translate("team.")."";
            $from = "$sitename";
            mail($email, $subject, $message, "From: $from\nX-Mailer: PHP/" . phpversion());
        }
    }
    include("footer.php");
    }
}    


/*********************************************************/
/* Referer Functions to know who links us                */
/*********************************************************/

function hreferer() {
    include ("header.php");
    GraphicAdmin();
    dbconnect();
    echo "
    <center>$font4<b>".translate("HTTP Referers")."</b></center><br>
    <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
    <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
    <font face=Lucida,Verdana,Arial,Helvetica size=3>
    <center><b>".translate("Who is linking our site?")."</b></center><br><br>
    <font size=2>
    <table border=0 width=100%>";
    $hresult = mysql_query("select rid, url from referer");
    while(list($rid, $url) = mysql_fetch_row($hresult)) {
        echo "<tr><td bgcolor=CCCCCC><font face=Arial,Helvetica size=2>$rid</td>";
        echo "<td bgcolor=CCCCCC><font face=Arial,Helvetica size=2><a target=_blank href=$url>$url</a></td></tr>";
    }
    echo "</table>$font3";
    echo "<form action=admin.php method=post>";
    echo "<input type=hidden name=op value=delreferer>";
    echo "<center><input type=submit value=\"".translate("Delete Referers")."\"></center>";
    echo "</td></tr></table></td></tr></table>";
    include ("footer.php");
}

function delreferer() {
    mysql_query("delete from referer");
    Header("Location: admin.php?op=AdminMain");
}

/*********************************************************/
/* Banners Administration Functions                      */
/*********************************************************/

function BannersAdmin() {
        include ("header.php");
        GraphicAdmin();
        dbconnect();
        echo "<font size=4><center><b>".translate("Banners Administration")."</b></center><br><br>";
// Banners List
        echo "
        <a name=top>
        <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        <font face=Lucida,Verdana,Arial,Helvetica size=3>
        <center><b>".translate("Current Active Banners")."</b></center><br>
        <font size=3>
        <table width=100% border=0><tr>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("ID")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Impressions")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Imp. Left")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Clicks")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("% Clicks")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Client Name")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Functions")."</td><tr>";
        $result = mysql_query("select bid, cid, imptotal, impmade, clicks, date from banner order by bid");
        
        while(list($bid, $cid, $imptotal, $impmade, $clicks, $date) = mysql_fetch_row($result)) {
            $result2 = mysql_query("select cid, name from bannerclient where cid=$cid");
            list($cid, $name) = mysql_fetch_row($result2);
            if($impmade==0) {
                $percent = 0;
            } else {
                $percent = substr(100 * $clicks / $impmade, 0, 5);
            }
            
            if($imptotal==0) {
                $left = "".translate("Unlimited")."";
            } else {
                $left = $imptotal-$impmade;
            }
            echo "
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$bid</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$impmade</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$left</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$clicks</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$percent%</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$name</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white><a href=admin.php?op=BannerEdit&bid=$bid>".translate("Edit")."</a> | <a href=admin.php?op=BannerDelete&bid=$bid&ok=0>".translate("Delete")."</a></td><tr>
            ";
        }
        echo "</td></tr></table></td></tr></table></td></tr></table><br>";
// Finished Banners List
        echo "
        <a name=top>
        <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        <font face=Lucida,Verdana,Arial,Helvetica size=3>
        <center><b>".translate("Finished Banners")."</b></center><br>
        <font size=3>
        <table width=100% border=0><tr>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("ID")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Imp.")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Clicks")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("% Clicks")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Date Started")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Date Ended")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Client Name")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Functions")."</td><tr>";
        $result = mysql_query("select bid, cid, impressions, clicks, datestart, dateend from bannerfinish order by bid");
        
        while(list($bid, $cid, $impressions, $clicks, $datestart, $dateend) = mysql_fetch_row($result)) {
            $result2 = mysql_query("select cid, name from bannerclient where cid=$cid");
            list($cid, $name) = mysql_fetch_row($result2);
            $percent = substr(100 * $clicks / $impressions, 0, 5);
            echo "
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$bid</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$impressions</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$clicks</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$percent%</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$datestart</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$dateend</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$name</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white><a href=admin.php?op=BannerFinishDelete&bid=$bid>".translate("Delete")."</a></td><tr>
            ";
        }
        echo "</td></tr></table></td></tr></table></td></tr></table><br>";

// Clients List
        echo "
        <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        <font face=Lucida,Verdana,Arial,Helvetica size=3>
        <center><b>".translate("Advertising Clients")."</b></center><br>
        <font size=3>
        <table width=100% border=0><tr>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("ID")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Client Name")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Active Banners")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Contact Name")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Contact Email")."</td>
        <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Functions")."</td><tr>";
        $result = mysql_query("select cid, name, contact, email from bannerclient  order by cid");
        
        while(list($cid, $name, $contact, $email) = mysql_fetch_row($result)) {
            $result2 = mysql_query("select cid from banner where cid=$cid");
            $numrows = mysql_num_rows($result2);
            echo "
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$cid</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$name</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$numrows</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$contact</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$email</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white><a href=admin.php?op=BannerClientEdit&cid=$cid>".translate("Edit")."</a> | <a href=admin.php?op=BannerClientDelete&cid=$cid>".translate("Delete")."</a></td><tr>
            ";
        }
        echo "</td></tr></table></td></tr></table></td></tr></table><br>";
// Add Banner
    $result = mysql_query("select * from bannerclient");
    $numrows = mysql_num_rows($result);
    if($numrows>0) {
        echo"
        <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        <font face=Lucida,Verdana,Arial,Helvetica size=3>
        <b>".translate("Add a New Banner")."</b></center><br><br>
        <font size=3>
        <form action=admin.php?op=BannersAdd method=post>
        ".translate("Client Name: ")."
        <select name=cid>";
        $result = mysql_query("select cid, name from bannerclient");
        while(list($cid, $name) = mysql_fetch_row($result)) {
            echo "<option value=$cid>$name</option>";
        }
        echo "
        </select><br>
        ".translate("Impressions Purchased: ")."<input type=text name=imptotal size=12 maxlength=11> 0 = ".translate("Unlimited")."<br>
        ".translate("Image URL: ")."<input type=text name=imageurl size=50 maxlength=100><br>
        ".translate("Click URL: ")."<input type=text name=clickurl size=50 maxlength=200><br>
        <input type=hidden name=op value=BannersAdd>
        <input type=submit value=\"".translate("Add Banner")."\">
        </td></tr></table></td></tr></table></form>
        ";
    }
// Add Client
        echo"
        <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        <font face=Lucida,Verdana,Arial,Helvetica size=3>
        <b>".translate("Add a New Client")."</b></center><br><br>
        <font size=3>
        <form action=admin.php?op=BannersAddClient method=post>
        ".translate("Client Name: ")."<input type=text name=name size=30 maxlength=60><br>
        ".translate("Contact Name: ")."<input type=text name=contact size=30 maxlength=60><br>
        ".translate("Contact Email: ")."<input type=text name=email size=30 maxlength=60><br>
        ".translate("Client Login: ")."<input type=text name=login size=12 maxlength=10><br>
        ".translate("Client Password: ")."<input type=text name=passwd size=12 maxlength=10><br>
        ".translate("Extra Info:")."<br><textarea name=extrainfo cols=60 rows=10></textarea><br>
        <input type=hidden name=op value=BannerAddClient>
        <input type=submit value=\"".translate("Add Client")."\">
        </td></tr></table></td></tr></table></form>
        ";
        include ("footer.php");
}

function BannersAdd($name, $cid, $imptotal, $imageurl, $clickurl) {
    mysql_query("insert into banner values (NULL, '$cid', '$imptotal', '1', '0', '$imageurl', '$clickurl', now())");
    Header("Location: admin.php?op=BannersAdmin#top");
}

function BannerAddClient($name, $contact, $email, $login, $passwd, $extrainfo) {
    mysql_query("insert into bannerclient values (NULL, '$name', '$contact', '$email', '$login', '$passwd', '$extrainfo')");
    Header("Location: admin.php?op=BannersAdmin#top");
}

function BannerFinishDelete($bid) {
    mysql_query("delete from bannerfinish where bid=$bid");
    Header("Location: admin.php?op=BannersAdmin#top");
}

function BannerDelete($bid, $ok=0) {
        if ($ok==1) {
            dbconnect();
            mysql_query("delete from banner where bid='$bid'");
            Header("Location: admin.php?op=BannersAdmin#top");
        } else {
            include("header.php");
            dbconnect();
            GraphicAdmin();
            $result=mysql_query("select cid, imptotal, impmade, clicks, imageurl, clickurl from banner where bid=$bid");
            list($cid, $imptotal, $impmade, $clicks, $imageurl, $clickurl) = mysql_fetch_row($result);
            echo "<table border=0 bgcolor=000000 cellpadding=1 cellspacing=0 width=100%>
            <tr><td>
            <table border=0 bgcolor=FFFFFF cellpadding=1 cellspacing=0 width=100%>
            <tr><td><center>
            $font3<b>".translate("Delete Banner")."</b><br><br>
            <a href=$clickurl><img src=$imageurl border=1></a><br>
            <a href=$clickurl>$clickurl</a><br><br>
            <table width=100% border=0><tr>
            <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("ID")."</td>
            <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Impressions")."</td>
            <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Imp. Left")."</td>
            <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Clicks")."</td>
            <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("% Clicks")."</td>
            <td bgcolor=0000BA><font face=Arial,Helvetica color=white><center>".translate("Client Name")."</td><tr>";
            $result2 = mysql_query("select cid, name from bannerclient where cid=$cid");
            list($cid, $name) = mysql_fetch_row($result2);
            $percent = substr(100 * $clicks / $impmade, 0, 5);
            if($imptotal==0) {
                $left = unlimited;
            } else {
                $left = $imptotal-$impmade;
            }
            echo "
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$bid</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$impmade</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$left</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$clicks</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$percent%</td>
            <td bgcolor=008888 align=center><font face=Arial,Helvetica color=white>$name</td><tr>
            ";
        }
        echo "</td></tr></table><br>
        ".translate("Are you sure you want to delete this Banner?")."<br><br>
        [ <a href=\"admin.php?op=BannersAdmin#top\">".translate("No")."</a> | <a href=\"admin.php?op=BannerDelete&bid=$bid&ok=1\">".translate("Yes")."</a> ]</center><br><br></center>
        </td></tr></table></center></td></tr></table>";
        include("footer.php");
}

function BannerEdit($bid) {
        include("header.php");
        dbconnect();
        GraphicAdmin();
        $result=mysql_query("select cid, imptotal, impmade, clicks, imageurl, clickurl from banner where bid=$bid");
        list($cid, $imptotal, $impmade, $clicks, $imageurl, $clickurl) = mysql_fetch_row($result);
        echo"
        <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        <font face=Lucida,Verdana,Arial,Helvetica size=3>
        <center><b>".translate("Edit Banner")."</b><br><br>
        <img src=$imageurl border=1><br><br>
        <font size=3></center>
        <form action=admin.php?op=BannerChange method=post>
        ".translate("Client Name: ")."
        <select name=cid>
        ";
        
        $result = mysql_query("select cid, name from bannerclient where cid=$cid");
        list($cid, $name) = mysql_fetch_row($result);
        
        echo "<option value=$cid selected>$name</option>";
        $result = mysql_query("select cid, name from bannerclient");
        while(list($ccid, $name) = mysql_fetch_row($result)) {
            if($cid!=$ccid) {
                echo "<option value=$ccid>$name</option>";
            }
        }
        echo "</select><br>";
        if($imptotal==0) {
            $impressions = "".translate("Unlimited")."";
        } else {
            $impressions = $imptotal;
        }
        echo"
        ".translate("Add More Impressions: ")."<input type=text name=impadded size=12 maxlength=11> ".translate("Purchased: ")."<b>$impressions</b> ".translate("Made: ")."<b>$impmade</b><br>
        ".translate("Image URL: ")."<input type=text name=imageurl size=50 maxlength=60 value=\"$imageurl\"><br>
        ".translate("Click URL: ")."<input type=text name=clickurl size=50 maxlength=100 value=\"$clickurl\"><br>
        <input type=hidden name=bid value=$bid>
        <input type=hidden name=imptotal value=$imptotal>
        <input type=hidden name=op value=BannerChange>
        <input type=submit value=\"".translate("Change Banner")."\">
        </td></tr></table></td></tr></table></form>
        ";
        include("footer.php");
}

function BannerChange($bid, $cid, $imptotal, $impadded, $imageurl, $clickurl) {
        dbconnect();
        $imp = $imptotal+$impadded;
        mysql_query("update banner set cid='$cid', imptotal='$imp', imageurl='$imageurl', clickurl='$clickurl' where bid=$bid");
        Header("Location: admin.php?op=BannersAdmin#top");
}

function BannerClientDelete($cid, $ok=0) {
        if ($ok==1) {
            dbconnect();
            mysql_query("delete from banner where cid='$cid'");
            mysql_query("delete from bannerclient where cid='$cid'");
            Header("Location: admin.php?op=BannersAdmin#top");
        } else {
            include("header.php");
            dbconnect();
            GraphicAdmin();
            $result=mysql_query("select cid, name from bannerclient where cid=$cid");
            list($cid, $name) = mysql_fetch_row($result);
            echo "<table border=0 bgcolor=000000 cellpadding=1 cellspacing=0 width=100%>
            <tr><td>
            <table border=0 bgcolor=FFFFFF cellpadding=1 cellspacing=0 width=100%>
            <tr><td><center>
            $font3<b>".translate("Delete Advertising Client")."</b><br><br>
            ".translate("You are about to delete client:")." <b>$name</b> ".translate("and all its Banners!!!")."<br><br>";
            $result2 = mysql_query("select imageurl, clickurl from banner where cid=$cid");
            $numrows = mysql_num_rows($result2);
            if($numrows==0) {
                echo "".translate("This client doesn't have any banner running now.")."<br><br>";
            } else {
                echo "<font color=Red><b>".translate("WARNING!!!")."</b></font>$font3<br>
                ".translate("This client has the following ACTIVE BANNERS running in")." $sitename:<br><br>";
            }
            while(list($imageurl, $clickurl) = mysql_fetch_row($result2)) {
                echo"
                <a href=$clickurl><img src=$imageurl border=1></a><br>
                <a href=$clickurl>$clickurl</a><br><br>
                ";
            }
        }
        echo "".translate("Are you sure you want to delete this Client and ALL its Banners?")."<br><br>
        [ <a href=\"admin.php?op=BannersAdmin#top\">".translate("No")."</a> | <a href=\"admin.php?op=BannerClientDelete&cid=$cid&ok=1\">".translate("Yes")."</a> ]</center><br><br></center>
        </td></tr></table></center></td></tr></table>";
        include("footer.php");
}

function BannerClientEdit($cid) {
        include("header.php");
        dbconnect();
        GraphicAdmin();
        $result = mysql_query("select name, contact, email, login, passwd, extrainfo from bannerclient where cid=$cid");
        list($name, $contact, $email, $login, $passwd, $extrainfo) = mysql_fetch_row($result);
        echo"
        <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        <font face=Lucida,Verdana,Arial,Helvetica size=3>
        <center><b>".translate("Edit Advertising Client")."</b><br><br></center>
        <form action=admin.php?op=BannerClientChange method=post>
        ".translate("Client Name: ")."<input type=text name=name value=\"$name\" size=30 maxlength=60><br>
        ".translate("Contact Name: ")."<input type=text name=contact value=\"$contact\" size=30 maxlength=60><br>
        ".translate("Contact Email: ")."<input type=text name=email size=30 maxlength=60 value=\"$email\"><br>
        ".translate("Client Login: ")."<input type=text name=login size=12 maxlength=10 value=\"$login\"><br>
        ".translate("Client Password: ")."<input type=text name=passwd size=12 maxlength=10 value=\"$passwd\"><br>
        ".translate("Extra Info:")."<br><textarea name=extrainfo cols=60 rows=10>$extrainfo</textarea><br>
        <input type=hidden name=cid value=$cid>
        <input type=hidden name=op value=BannerClientChange>
        <input type=submit value=\"".translate("Change Client")."\">
        </td></tr></table></td></tr></table></form>
        ";
        include("footer.php");
}

function BannerClientChange($cid, $name, $contact, $email, $extrainfo, $login, $passwd) {
        dbconnect();
        mysql_query("update bannerclient set name='$name', contact='$contact', email='$email', login='$login', passwd='$passwd' where cid=$cid");
        Header("Location: admin.php?op=BannersAdmin#top");
}

/*********************************************************/
/* Administration Main Function                          */
/*********************************************************/

function adminMain() {
        include ('header.php');
//      dbconnect();
        echo"
        <table border=0 cellpadding=1 cellspacing=0 width=100% bgcolor=000000><tr><td>
        <table border=0 cellpadding=5 cellspacing=0 width=100% bgcolor=FFFFFF><tr><td>";
        $dummy = 0;
        $result = mysql_query("SELECT qid, subject, timestamp FROM queue order by timestamp");
        if(mysql_num_rows($result) == 0) {
                echo "<table width=\"100%\"><tr><td bgcolor=\"#cccccc\" align=\"center\">$font3<b>".translate("No New Submissions")."</b></td></tr></table>";
        } else {
                echo "<br><form action=\"admin.php\" method=\"post\"><table width=\"100%\" border=1 bgcolor=CCCCCC>";
                while (list($qid, $subject, $timestamp) = mysql_fetch_row($result)) {
                        $hour = "AM";
                        ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $timestamp, $datetime);
                        if ($datetime[4] > 12) { $datetime[4] = $datetime[4]-12; $hour = "PM"; }
                        $datetime = date(translate("datestring"), mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1]));
                        echo "<tr>
                        <td align=middle><font face=\"arial, helvetica\" SIZE=2>(<a href=admin.php?op=DeleteStory&qid=$qid>".translate("Delete")."</a>)</td>
                        <td width=100%><font face=\"arial, helvetica\" SIZE=3>
                        <a href=\"admin.php?op=DisplayStory&qid=$qid\">$subject</a></font>
                        </td><td align=right><font face=\"arial, helvetica\" SIZE=2>$timestamp</font>
                        </td></tr>";
                        $dummy++;
                }
                if ($dummy < 1) {
                        echo "<tr><td bgcolor=\"#cccccc\" align=\"center\"><b>".translate("No New Submissions")."</b></td></tr></table></form>";
                } else {
?>
                        </table></form>
<?php
                }
        }
        mysql_free_result($result);
        ?>
        <font face=Arial,Helvetica>
        <hr noshade>
        <?php
        GraphicAdmin();
        ?>
        <hr noshade>
        <?php echo "<center>$font4<b>".translate("Last")." $admart ".translate("Articles")."</b></center></font>"; ?>
        <br>
        <?php
        $result=mysql_query("select sid, title, time, topic, informant from stories order by time desc limit 0,$admart");
        echo "<center><table border=1 width=100%>";
            
            while(list($sid, $title, $time, $topic, $informant) = mysql_fetch_row($result)) {
                $ta=mysql_query("select topicname from topics where topicid=$topic");
                list($topicname) = mysql_fetch_row($ta);
                formatTimestamp($time);
                echo "
                <tr><td align=right>$font2<b>$sid</b>
                </td><td align=left width=100%>$font2<a href=article.php?sid=$sid>$title</a>
                </td><td align=right>$font2$topicname
                </td><td align=right>$font2<b>(<a href=admin.php?op=EditStory&sid=$sid>".translate("Edit")."</a>)</b>
                </td><td align=right>$font2<b>(<a href=admin.php?op=RemoveStory&sid=$sid>".translate("Delete")."</a>)</b>";
                echo "</td></tr>";
            }
        echo "</td></table></center>";
        ?>
        <center>
        <form action="admin.php" method="post">
        <?php echo translate("Story ID:"); ?> <input type="text" NAME="sid" SIZE=10>
        <select name="op">
                        <option value="EditStory" SELECTED><?php echo translate("EditStory"); ?></option>
                        <option value="RemoveStory"><?php echo translate("RemoveStory"); ?></option></select>
        <input type="submit" value="<?php echo translate("Go!");?>"></form></center>
        <hr noshade>
        <center>
        <?PHP
        $result = mysql_query("SELECT pollID, pollTitle, timeStamp FROM poll_desc ORDER BY pollID DESC limit 1");
        $object = mysql_fetch_object($result);
        $pollTitle = $object->pollTitle;
        echo translate("Current Poll:")." $pollTitle
        <br><br></td></tr></table></td></tr></table>";
        mysql_free_result($result);
        include ('footer.php');
}

/*********************************************************/
/* Sections Manager Functions                            */
/*********************************************************/

function sections() {
        include("header.php");
        include("config.php");
        dbconnect();
        GraphicAdmin();
        $result = mysql_query("select secid, secname from sections order by secid");
        if (mysql_num_rows($result)==0) {
            echo "<table border=0 bgcolor=000000 cellpadding=1 cellspacing=0 width=95%>
            <tr><td>
            <table border=0 bgcolor=FFFFFF cellpadding=1 cellspacing=0 width=100%>";
        }
if (mysql_num_rows($result) > 0) {

        echo "<table border=0 bgcolor=000000 cellpadding=1 cellspacing=0 width=100%>
        <tr><td>
        <table border=0 bgcolor=FFFFFF cellpadding=1 cellspacing=0 width=100%>
        <tr><td>$font3<b><center>".translate("Current Active Sections")."</b><br>".translate("Click to Edit")."</center><br>
        <center><table border=0 width=100% align=center cellpadding=1><tr><td align=center>
        <font face=Arial,Helvetica>";
                while(list($secid, $secname) = mysql_fetch_array($result)) {
                ?>
                        
                <li><?php echo "<a href=admin.php?op=sectionedit&secid=$secid>"; ?><?php echo "$secname"; ?></a>
                <?php
                }
                echo "</td></tr></table>";

        ?>
        </td></tr></table></td></tr></table>
        <br>
        
        <table border=0 bgcolor=000000 cellpadding=1 cellspacing=0 width=100%>
        <tr><td>
        <table border=0 bgcolor=FFFFFF cellpadding=5 cellspacing=0 width=100%>
        <tr><td>
        <font face=Arial,Helvetica size=4><b><?php echo translate("Add Article in Sections"); ?></b><font size=2>
        <br><br>
        <form action="admin.php" method="post"><br>
        <b><?php echo translate("Title:"); ?></b><br>
        <input type="text" name="title" size=60 value=""><br><br>
        <?php
        $result = mysql_query("select secid, secname from sections order by secid");
        while(list($secid, $secname) = mysql_fetch_array($result)) {
        echo "<input type=radio name=secid value=$secid>$secname<br>";
        } ?>
        <br>
        <b><?php echo translate("Content:"); ?></b><br>
        <textarea name="content" cols=60 rows=10></textarea><br><br>
        
        <input type=hidden name=op value=secarticleadd>
        <INPUT type="submit" value="<?php echo translate("Add Article!"); ?>">
        </form>
        </td></tr></table></td></tr></table>
        <br>
        <table border=0 bgcolor=000000 cellpadding=1 cellspacing=0 width=100%>
        <tr><td>
        <table border=0 bgcolor=FFFFFF cellpadding=5 cellspacing=0 width=100%>
        <tr><td>
        <font face=Arial,Helvetica size=4><b><?php echo translate("Last"); echo " $admart "; echo translate("Articles"); ?></b><font size=2>
        <br><br>
        <ul>
        <?php
        $result = mysql_query("select artid, secid, title, content from seccont order by artid desc limit 0,$admart");
        while(list($artid, $secid, $title, $content) = mysql_fetch_array($result)) {
            $result2 = mysql_query("select secid, secname from sections where secid='$secid'");
            list($secid, $secname) = mysql_fetch_row($result2);
            echo "<li>$title ($secname) [ <a href=admin.php?op=secartedit&artid=$artid>".translate("Edit")."</a> ]";
        } ?>
        </ul>
        <form action="admin.php" method="post">
        <?php echo translate("Edit Article ID:"); ?> <input type="text" NAME="artid" SIZE=10>
        <input type=hidden name=op value="secartedit">
        <input type="submit" value="<?php echo translate("Go!");?>">
        
        <?php mysql_free_result($result); ?>

        </td></tr></table></td></tr></table></form>
        </ul>
<?php } ?>
        <table border=0 bgcolor=000000 cellpadding=1 cellspacing=0 width=100%>
        <tr><td>
        <table border=0 bgcolor=FFFFFF cellpadding=8 cellspacing=0 width=100%>
        <tr><td>
        <font face=Arial,Helvetica size=4><b><?php echo translate("Add a New Section"); ?></b><font size=2>
        <br><br>
        <form action="admin.php" method="post"><br>
        <b><?php echo translate("Section Name:"); ?></b><br>
        <input type="text" name="secname" size=40 maxlength=40><br><br>
        <b><?php echo translate("Section Image:"); ?> </b>&nbsp; <?php echo translate("(example: opinion.gif)"); ?><br>
        <input type="text" name="image" size=40 maxlength=50><br><br>
        
        <input type=hidden name=op value=sectionmake>
        <INPUT type="submit" value="<?php echo translate("Add Section!"); ?>">
        </form>
        </td></tr></table></td></tr></table></td></tr></table>
        <?php
        include("footer.php");
}

function secarticleadd($secid, $title, $content) {
        dbconnect();
        $title = stripslashes(FixQuotes($title));
        $content = stripslashes(FixQuotes($content));
        mysql_query("INSERT INTO seccont VALUES (NULL,'$secid','$title','$content','0')");
        Header("Location: admin.php?op=sections");
}

function secartedit($artid) {
        include("header.php");
        dbconnect();
        GraphicAdmin();
        $result = mysql_query("select artid, secid, title, content from seccont where artid='$artid'");
        list($artid, $secid, $title, $content) = mysql_fetch_array($result);
        ?>

        <table border=0 bgcolor=000000 cellpadding=1 cellspacing=0 width=100%>
        <tr><td>
        <table border=0 bgcolor=FFFFFF cellpadding=8 cellspacing=0 width=100%>
        <tr><td>
        <font face=Arial,Helvetica size=4><b><?php echo translate("Edit Article"); ?></b><font size=2>
        <br><br>
        <form action="admin.php" method="post"><br>
        <b><?php echo translate("Title:"); ?></b><br>
        <input type="text" name="title" size=60 value="<?php echo "$title"; ?>"><br><br>

        <?php
        $result2 = mysql_query("select secid, secname from sections order by secname");
        while(list($secid2, $secname) = mysql_fetch_array($result2)) {
        
        if ($secid2==$secid) { $che = "checked"; }
        echo "<input type=radio name=secid value=$secid2 $che>$secname<br>";
        $che = "";
        
        } ?>
        
        <br>
        <b><?php echo translate("Content"); ?></b><br>
        <textarea name=content cols=60 rows=10><?php echo "$content"; ?></textarea>
        <input type=hidden name=artid value="<?php echo "$artid"; ?>">
        <input type=hidden name=op value=secartchange>
        <table border=0><tr><td>
        <INPUT type="submit" value="<?php echo translate("Save Changes!"); ?>">
        </td><td></form>
        <form action="admin.php" method="post"><br>
        <input type=hidden name=artid value="<?php echo "$artid"; ?>">
        <input type=hidden name=op value=secartdelete>
        <INPUT type="submit" value="<?php echo translate("Delete Article!"); ?>">
        </form></td></tr></table>
        </td></tr></table></td></tr></table>    
        <?php
        include("footer.php");
}

function sectionmake($secname, $image) {
        dbconnect();
        $secname = stripslashes(FixQuotes($secname));
        $image = stripslashes(FixQuotes($image));
        mysql_query("INSERT INTO sections VALUES (NULL,'$secname', '$image')");
        Header("Location: admin.php?op=sections");
}

function sectionedit($secid) {
        include("header.php");
        dbconnect();
        GraphicAdmin();
        $result = mysql_query("select secid, secname, image from sections where secid=$secid");
        list($secid, $secname, $image) = mysql_fetch_array($result);
        
        $result2 = mysql_query("select artid from seccont where secid=$secid");
        $number = mysql_num_rows($result2);
        ?>
        <table border=0 bgcolor=000000 cellpadding=1 cellspacing=0 width=100%>
        <tr><td>
        <table border=0 bgcolor=FFFFFF cellpadding=8 cellspacing=0 width=100%>
        <tr><td>
        <?php echo "<img src=images/sections/$image border=0><br><br>"; ?>
        <font face=Arial,Helvetica size=4><b><?php echo translate("Edit Section:"); ?> <?php echo "$secname"; ?></b><font size=2>
        <br>
        (This Section has <?php echo "$number"; ?> Articles attached)
        <br><br>
        <form action="admin.php" method="post"><br>
        <b><?php echo translate("Section Name:"); ?></b> <?php echo translate("(40 characters Max.)"); ?><br>
        <input type="text" name="secname" size=40 maxlength=40 value="<?php echo "$secname"; ?>"><br><br>
        <b><?php echo translate("Section Image:"); ?></b> <?php echo translate("(example: opinion.gif)"); ?><br>
        <input type="text" name="image" size=40 maxlength=50 value="<?php echo "$image"; ?>"><br><br>
        <input type=hidden name=secid value="<?php echo "$secid"; ?>">
        <input type=hidden name=op value=sectionchange>
        <table border=0><tr><td>
        <INPUT type="submit" value="<?php echo translate("Save Changes!"); ?>">
        </td><td></form>
        <form action="admin.php" method="post"><br>
        <input type=hidden name=secid value="<?php echo "$secid"; ?>">
        <input type=hidden name=op value=sectiondelete>
        <INPUT type="submit" value="Delete Section!">
        </form></td></tr></table>
        
        </td></tr></table></td></tr></table>
        <?php
        include("footer.php");
}

function sectionchange($secid, $secname, $image) {
        dbconnect();
        $secname = stripslashes(FixQuotes($secname));
        $image = stripslashes(FixQuotes($image));
        mysql_query("update sections set secname='$secname', image='$image' where secid=$secid");
        Header("Location: admin.php?op=sections");
}

function secartchange($artid, $secid, $title, $content) {
        
        $title = stripslashes(FixQuotes($title));
        $content = stripslashes(FixQuotes($content));
        dbconnect();
        mysql_query("update seccont set secid='$secid', title='$title', content='$content' where artid=$artid");
        Header("Location: admin.php?op=sections");
}

function sectiondelete($secid, $ok=0) {
        if ($ok==1) {
            dbconnect();
            mysql_query("delete from seccont where secid='$secid'");
            mysql_query("delete from sections where secid='$secid'");
            Header("Location: admin.php?op=sections");
        } else {
            include("header.php");
            dbconnect();
            GraphicAdmin();
            $result=mysql_query("select secname from sections where secid=$secid");
            list($secname) = mysql_fetch_row($result);
            echo "<table border=0 bgcolor=000000 cellpadding=1 cellspacing=0 width=95%>
            <tr><td>
            <table border=0 bgcolor=FFFFFF cellpadding=1 cellspacing=0 width=100%>
            <tr><td><center>
            $font3<b>".translate("Delete Section: ")."$secname</b><br><br>
            ".translate("Are you sure you want to delete section")." $secname?<br>
            ".translate("This will delete ALL its articles!")."<br><br>
            [ <a href=\"admin.php?op=sections\">".translate("No")."</a> | <a href=\"admin.php?op=sectiondelete&secid=$secid&ok=1\">".translate("Yes")."</a> ]</center><br><br></center>
            </td></tr></table></center></td></tr></table>";
            include("footer.php");
        }
}

function secartdelete($artid, $ok=0) {
        if ($ok==1) {
            dbconnect();
            mysql_query("delete from seccont where artid='$artid'");
            Header("Location: admin.php?op=sections");
        } else {
            include("header.php");
            dbconnect();
            GraphicAdmin();
            $result = mysql_query("select title from seccont where artid=$artid");
            list($title) = mysql_fetch_row($result);
            echo "<table border=0 bgcolor=000000 cellpadding=1 cellspacing=0 width=95%>
            <tr><td>
            <table border=0 bgcolor=FFFFFF cellpadding=8 cellspacing=0 width=100%>
            <tr><td><center>
            $font3<b>".translate("Delete Article: ")."$title</b><br><br>
            ".translate("Are you sure you want to delete this article?")."<br><br>
            [ <a href=\"admin.php?op=sections\">".translate("No")."</a> | <a href=\"admin.php?op=secartdelete&artid=$artid&ok=1\">".translate("Yes")."</a> ]</center><br><br></center>
            </td></tr></table></center></td></tr></table>";
            include("footer.php");
        }
}

/*********************************************************/
/* Topics Manager Functions                              */
/*********************************************************/

function topicsmanager() {
        include("header.php");
        dbconnect();
        GraphicAdmin();
        $result = mysql_query("select topicid, topicname, topicimage, topictext from topics order by topicid");
        if (mysql_num_rows($result)==0) {
            echo "<table border=0 bgcolor=000000 cellpadding=2 cellspacing=0 width=95%>
            <tr><td>
            <table border=0 bgcolor=FFFFFF cellpadding=1 cellspacing=0 width=100%>";
        }
        if (mysql_num_rows($result) > 0) {

        echo "<table border=0 bgcolor=000000 cellpadding=2 cellspacing=0 width=100%>
        <tr><td>
        <table border=0 bgcolor=FFFFFF cellpadding=1 cellspacing=0 width=100%>
        <tr><td>$font3<b><center>".translate("Current Active Topics")."</b><br>".translate("Click to Edit")."</center><br>
        <center><table border=0 width=100% align=center cellpadding=2><tr>";


                while(list($topicid, $topicname, $topicimage, $topictext) = mysql_fetch_array($result)) {
?>
                        
                <td align=center>
                <?php echo "<a href=admin.php?op=topicedit&topicid=$topicid>"; ?><img src=<?php echo "$tipath$topicimage"; ?> border=0></a><br>
                <font face=Arial,Helvetica size=2><b><?php echo "$topictext"; ?>
                </td>
                <?php
                
                // Thanks to John Hoffmann from softlinux.org for the next 5 lines ;)
                
                $count++;
                if ($count == 5) {
                    echo "</tr></tr>";
                    $count = 0;
                }

                ?>
<?php
                }
        echo "</tr></table>";
        } 
        ?>
        </td></tr></table></td></tr></table>
        <br><a name=Add>
        <table border=0 bgcolor=000000 cellpadding=2 cellspacing=0 width=100%>
        <tr><td>
        <table border=0 bgcolor=FFFFFF cellpadding=5 cellspacing=0 width=100%>
        <tr><td>
        <font face=Arial,Helvetica size=4><b><?php echo translate("Add a New Topic"); ?></b><font size=2>
        <br><br>
        <form action="admin.php" method="post"><br>
        <b><?php echo translate("Topic Name:"); ?></b> <?php echo translate("(just a name without spaces - max: 20 characters)"); ?><br>
        <?php echo translate("for example: gamesandhobbies"); ?><br>
        <input type="text" name="topicname" size=20 maxlength=20 value="<?php echo "$topicname"; ?>"><br><br>
        <b><?php echo translate("Topic Text:"); ?></b> <?php echo translate("(the full topic text or description - max: 40 characters)"); ?><br>
        <?php echo translate("for example: Games and Hobbies"); ?><br>
        <input type="text" name="topictext" size=40 maxlength=40 value="<?php echo "$topictext"; ?>"><br><br>
        <b><?php echo translate("Topic Image:"); ?></b> <?php echo translate("(image name + extension located in"); ?> <?php echo "$tipath"; ?>)<br>
        <?php echo translate("for example: games.gif"); ?><br>
        <input type="text" name="topicimage" size=20 maxlength=20 value="<?php echo "$topicimage"; ?>"><br><br>
        <input type=hidden name=op value=topicmake>
        <INPUT type="submit" value="<?php echo translate("Add Topic!"); ?>">
        </form>
        </td></tr></table></td></tr></table>    
        <?php
        mysql_free_result($result);
        include("footer.php");
}

function topicedit($topicid) {
        include("header.php");
        dbconnect();
        GraphicAdmin();
        $result = mysql_query("select topicid, topicname, topicimage, topictext from topics where topicid=$topicid");
        list($topicid, $topicname, $topicimage, $topictext) = mysql_fetch_array($result)
        ?>
        <table border=0 bgcolor=000000 cellpadding=2 cellspacing=0 width=100%>
        <tr><td>
        <table border=0 bgcolor=FFFFFF cellpadding=5 cellspacing=0 width=100%>
        <tr><td>
        <img src=<?php echo "$tipath$topicimage"; ?> border=0 align=right>
        <font face=Arial,Helvetica size=4><b><?php echo translate("Edit Topic:"); ?> <?php echo "$topictext"; ?></b><font size=2>
        <br><br>
        <form action="admin.php" method="post"><br>
        <b><?php echo translate("Topic Name:"); ?></b> <?php echo translate("(just a name without spaces - max: 20 characters)"); ?><br>
        <?php echo translate("for example: gamesandhobbies"); ?><br>
        <input type="text" name="topicname" size=20 maxlength=20 value="<?php echo "$topicname"; ?>"><br><br>
        <b><?php echo translate("Topic Text:"); ?></b> <?php echo translate("(the full topic text or description - max: 40 characters)"); ?><br>
        <?php echo translate("for example: Games and Hobbies"); ?><br>
        <input type="text" name="topictext" size=40 maxlength=40 value="<?php echo "$topictext"; ?>"><br><br>
        <b><?php echo translate("Topic Image:"); ?></b> <?php echo translate("(image name + extension located in"); ?> <?php echo "$tipath"; ?>)<br>
        <?php echo translate("for example: games.gif"); ?><br>
        <input type="text" name="topicimage" size=20 maxlength=20 value="<?php echo "$topicimage"; ?>"><br><br>
        <input type=hidden name=topicid value="<?php echo "$topicid"; ?>">
        <input type=hidden name=op value=topicchange>
        <table border=0><tr><td>
        <INPUT type="submit" value="<?php echo translate("Save Changes!"); ?>">
        </td><td></form>
        <form action="admin.php" method="post"><br>
        <input type=hidden name=topicid value="<?php echo "$topicid"; ?>">
        <input type=hidden name=op value=topicdelete>
        <INPUT type="submit" value="<?php echo translate("Delete Topic!"); ?>">
        </form></td></tr></table>
        </td></tr></table></td></tr></table>
        <?php
        include("footer.php");
}

function topicmake($topicname, $topicimage, $topictext) {
        dbconnect();
        $topicname = stripslashes(FixQuotes($topicname));
        $topicimage = stripslashes(FixQuotes($topicimage));
        $topictext = stripslashes(FixQuotes($topictext));
        mysql_query("INSERT INTO topics VALUES (NULL,'$topicname','$topicimage','$topictext','0')");
        Header("Location: admin.php?op=topicsmanager#Add");
}

function topicchange($topicid, $topicname, $topicimage, $topictext) {
        dbconnect();
        $topicname = stripslashes(FixQuotes($topicname));
        $topicimage = stripslashes(FixQuotes($topicimage));
        $topictext = stripslashes(FixQuotes($topictext));
        mysql_query("update topics set topicname='$topicname', topicimage='$topicimage', topictext='$topictext' where topicid=$topicid");
        Header("Location: admin.php?op=topicsmanager");
}

function topicdelete($topicid, $ok=0) {
        if ($ok==1) {
            dbconnect();
            $result=mysql_query("select sid from stories where topic='$topicid'");
            list($sid) = mysql_fetch_row($result);
            mysql_query("delete from stories where topic='$topicid'");
            mysql_query("delete from topics where topicid='$topicid'");
            $result=mysql_query("select sid from comments where sid='$sid'");
            list($sid) = mysql_fetch_row($result);
            mysql_query("delete from comments where sid='$sid'");
            Header("Location: admin.php?op=topicsmanager");
        } else {
            include("header.php");
            dbconnect();
            GraphicAdmin();
            $result2=mysql_query("select topicimage, topictext from topics where topicid='$topicid'");
            list($topicimage, $topictext) = mysql_fetch_row($result2);
            echo "<table border=0 bgcolor=000000 cellpadding=2 cellspacing=0 width=95%>
            <tr><td>
            <table border=0 bgcolor=FFFFFF cellpadding=1 cellspacing=0 width=100%>
            <tr><td>
            <center><img src=$tipath$topicimage border=0><br>
            $font3<b>".translate("Delete Topic")." $topictext</b><br><br>
            ".translate("Are you sure you want to delete Topic")." $topictext?<br>
            ".translate("This will delete ALL it's stories and it's comments!")."<br><br>
            [ <a href=\"admin.php?op=topicsmanager\">".translate("No")."</a> | <a href=\"admin.php?op=topicdelete&topicid=$topicid&ok=1\">".translate("Yes")."</a> ]</center><br><br>
            </td></tr></table></td></tr></table>";
            include("footer.php");
        }
}

/*********************************************************/
/* MAIN Block Functions                                  */
/*********************************************************/

function mblock() {
        include("header.php");
        dbconnect();
        GraphicAdmin();
        $result = mysql_query("select title, content from mainblock");
        if (mysql_num_rows($result) > 0) {
                while(list($title, $content) = mysql_fetch_array($result)) {
                        echo "<center>$font4<b>".translate("Edit Main Block")."</center></b><br><br>$font3";
?>
                        <table width=100% border=0 cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
                        <table width=100% border=0 cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
                        <form action="admin.php" method="post">
                        <?php echo translate("Title:"); ?>
                        <input type="text" name="title" size="30" maxlength="60" value="<?php echo $title; ?>"><br>
                        <?php echo translate("Content:"); ?>
                        <br><textarea cols="50" rows="10" name="content"><?php echo $content; ?></textarea><br>
                        <input type="hidden" name="op" value="changemblock">
                        <input type="submit" VALUE="<?php echo translate("Go!"); ?>">
                        </td></tr></table></td></tr></table></form>
                        <br><br>
<?php
                }
        } ?>
        <?php
        include("footer.php");
}

function changemblock($title, $content) {
        dbconnect();
        $title = stripslashes(FixQuotes($title));
        $content = stripslashes(FixQuotes($content));
        mysql_query("update mainblock set title='$title', content='$content'");
        Header("Location: admin.php?op=adminMain");
}


/*********************************************************/
/* RIGHT Blocks Functions                                */
/*********************************************************/

function rblocks() {
        include("header.php");
        dbconnect();
        GraphicAdmin();
        echo "$font4<b><center>
        ".translate("Edit Right Blocks")."
        </b></center><br><br>
        <table width=100% border=0 cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table width=100% border=0 cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        $font3";
        $result = mysql_query("select id, title, content from rblocks");
        if (mysql_num_rows($result) > 0) {
                while(list($id, $title, $content) = mysql_fetch_array($result)) {
?>
                        <?php echo "$font3"; ?>
                        <form action="admin.php" method="post">
                        <?php echo translate("Title:"); ?>
                        <input type="text" name="title" size="30" maxlength="60" value="<?php echo $title; ?>"><br>
                        <?php echo translate("Content:"); ?>
                        <br><textarea cols="50" rows="6" name="content"><?php echo $content; ?></textarea><br>
                        <input type="hidden" name="id" value="<?php echo $id; ?>">
                        <select name="op">
                        <option VALUE="changerblock" SELECTED><?php echo translate("changerblock"); ?></option>
                        <option VALUE="deleterblock"><?php echo translate("deleterblock"); ?></option>
                        </select>
                        <input type="submit" VALUE="<?php echo translate("Go!"); ?>">
                        </form>
                        <br><br>
<?php
                }
        }
        echo "
        <hr noshade>
        $font4<b><center>
        ".translate("Create New Right Block")."
        </b></center><br><br>$font3";
        ?>
        <form action="admin.php" method="post">
        <?php echo translate("Title:"); ?><input type="text" name="title" size=30 maxlength=60><br>
        <?php echo translate("Content:"); ?><br>
        <textarea wrap=virtual cols=50 rows=6 name=content></textarea><br>
        <input type="hidden" NAME="op" VALUE="makerblock">
        <input type="submit" VALUE="<?php echo translate("makerblock") ?>">
        </td></tr></table></td></tr></table></form>
        <?php
        include("footer.php");
}

function makerblock($title, $content) {
        dbconnect();
        $title = stripslashes(FixQuotes($title));
        $content = stripslashes(FixQuotes($content));
        mysql_query("INSERT INTO rblocks VALUES (NULL,'$title','$content')");
        Header("Location: admin.php?op=rblocks");
}

function changerblock($id, $title, $content) {
        dbconnect();
        $title = stripslashes(FixQuotes($title));
        $content = stripslashes(FixQuotes($content));
        mysql_query("update rblocks set title='$title', content='$content' where id=$id");
        Header("Location: admin.php?op=rblocks");
}

function deleterblock($id) {
        dbconnect();
        mysql_query("delete from rblocks where id='$id'");
        Header("Location: admin.php?op=rblocks");
}


/*********************************************************/
/* LEFT Block Functions                                  */
/*********************************************************/

function lblocks() {
        include("header.php");
        dbconnect();
        GraphicAdmin();
        echo "$font4<b><center>
        ".translate("Edit Left Blocks")."
        </b></center><br><br>
        <table width=100% border=0 cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table width=100% border=0 cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        $font3";
        $result = mysql_query("select id, title, content from lblocks");
        if (mysql_num_rows($result) > 0) {
                while(list($id, $title, $content) = mysql_fetch_array($result)) {
?>
                        <form action="admin.php" method="post">
                        <?php echo translate("Title:"); ?>
                        <input type="text" name="title" size="30" maxlength="60" value="<?php echo $title; ?>"><br>
                        <?php echo translate("Content:"); ?>
                        <br><textarea cols="50" rows="6" name="content"><?php echo $content; ?></textarea><br>
                        <input type="hidden" name="id" value="<?php echo $id; ?>">
                        <select name="op">
                        <option VALUE="changelblock" SELECTED><?php echo translate("changelblock"); ?></option>
                        <option VALUE="deletelblock"><?php echo translate("deletelblock"); ?></option>
                        </select>
                        <input type="submit" VALUE="<?php echo translate("Go!"); ?>">
                        </form>
                        <br><br>
<?php
                }
        }
        echo "
        <hr noshade>
        $font4<b><center>
        ".translate("Create New Left Block")."
        </b></center><br><br>$font3";
        ?>
        <form action="admin.php" method="post">
        <?php echo translate("Title:"); ?><input type="text" name="title" size=30 maxlength=60><br>
        <?php echo translate("Content:"); ?><br>
        <textarea wrap=virtual cols=50 rows=6 name=content></textarea><br>
        <input type="hidden" NAME="op" VALUE="makelblock">
        <input type="submit" VALUE="<?php echo translate("makelblock"); ?>">
        </td></tr></table></td></tr></table></form>
        <?php
        include("footer.php");
}

function makelblock($title, $content) {
        dbconnect();
        $title = stripslashes(FixQuotes($title));
        $content = stripslashes(FixQuotes($content));
        mysql_query("INSERT INTO lblocks VALUES (NULL,'$title','$content')");
        Header("Location: admin.php?op=adminMain");
}

function changelblock($id, $title, $content) {
        dbconnect();
        $title = stripslashes(FixQuotes($title));
        $content = stripslashes(FixQuotes($content));
        mysql_query("update lblocks set title='$title', content='$content' where id=$id");
        Header("Location: admin.php?op=adminMain");
}

function deletelblock($id) {
        dbconnect();
        mysql_query("delete from lblocks where id='$id'");
        Header("Location: admin.php?op=adminMain");
}


/*********************************************************/
/* ADMIN Block Functions                                 */
/*********************************************************/

function ablock() {
        include("header.php");
        dbconnect();
        GraphicAdmin();
        echo "$font4<b><center>
        ".translate("Edit Admin Block")."
        </b></center><br><br>
        <table width=100% border=0 cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table width=100% border=0 cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        $font3";
        $result = mysql_query("select title, content from adminblock");
        if (mysql_num_rows($result) > 0) {
                while(list($title, $content) = mysql_fetch_array($result)) {
?>
                        <form action="admin.php" method="post">
                        <?php echo translate("Title:"); ?>
                        <input type="text" name="title" size="30" maxlength="60" value="<?php echo $title; ?>"><br>
                        <?php echo translate("Content:"); ?>
                        <br><textarea cols="50" rows="10" name="content"><?php echo $content; ?></textarea><br>
                        <input type="hidden" name="op" value="changeablock">
                        <input type="submit" VALUE="<?php echo translate("Go!"); ?>">
                        </td></tr></table></td></tr></table></form>
                        <br><br>
<?php
                }
        } ?>
        <?php
        include("footer.php");
}

function changeablock($title, $content) {
        dbconnect();
        $title = stripslashes(FixQuotes($title));
        $content = stripslashes(FixQuotes($content));
        mysql_query("update adminblock set title='$title', content='$content'");
        Header("Location: admin.php?op=adminMain");
}

/*********************************************************/
/* Story/News Functions                                  */
/*********************************************************/

function deleteStory($qid) {
        dbconnect();
        $result = mysql_query("delete from queue where qid=$qid");
                if (!$result)
                {
                        echo mysql_errno(). ": ".mysql_error(). "<br>";
                        return;
                }       Header("Location: admin.php?op=adminMain");
}

function displayStory ($qid) {
        global $user, $subject, $story;
        include ('config.php');
        include ('header.php');
        dbconnect();
        GraphicAdmin();
        $result = mysql_query("SELECT qid, uid, uname, subject, story, topic FROM queue where qid=$qid");
        list($qid, $uid, $uname, $subject, $story, $topic) = mysql_fetch_row($result);
        mysql_free_result($result);
        
        $subject = stripslashes($subject);
        $story = stripslashes($story);
        ?>

        <table width=100% bgcolor=000000 cellpadding=0 cellspacing=0 border=0><tr><td>
        <table width=100% bgcolor=FFFFFF cellpadding=8 cellspacing=2 border=0><tr><td>
        <font size=3 face=Arial,Helvetica>
        
        <form action="admin.php" method="post">
        <p><b><?php echo translate("Name"); ?></b><br>
        <input type="text" NAME="author" SIZE=50 value="<?PHP echo "$uname"; ?>">

        <p><b><?php echo translate("Subject"); ?></b><br>
        <input type=text name=subject size=50 value="<?PHP echo"$subject"; ?>">
        <?PHP
        if($topic=="") {
            $topic = 1;
        }
        $result = mysql_query("select topicimage from topics where topicid=$topic");
        list($topicimage) = mysql_fetch_row($result);
        echo "<br><br><center><table width=80% bgcolor=000000 cellpadding=0 cellspacing=0 border=0><tr><td>";
        echo "<table width=100% bgcolor=FFFFFF cellpadding=8 cellspacing=2 border=0><tr><td>";
        echo "<img src=$tipath$topicimage border=0 align=right>";
        themepreview($subject, $story);
        echo "</td></tr></table></td></tr></table></center>";
        ?>
        <p><b>Topic</b> <select name=topic>
        <?PHP
        $toplist = mysql_query("select topicid, topictext from topics order by topictext");
        echo "<OPTION VALUE=\"\">".translate("Select Topic")."</option>\n";
        while(list($topicid, $topics) = mysql_fetch_row($toplist)) {
        if ($topicid==$topic) { $sel = "selected "; }
            echo "<option $sel value=\"$topicid\">$topics</option>\n";
            $sel = "";
        }
        ?>
        </select>
        <p><b><?php echo translate("Intro Text"); ?></b><br>
        <textarea wrap=virtual cols=50 rows=7 name=hometext><?PHP echo "$story"; ?></textarea>
        <p><b><?php echo translate("Full Text"); ?></b><br>
        <textarea wrap=virtual cols=50 rows=8 name=bodytext></textarea><BR>
        <FONT size=2><?php echo translate("(Did you check URLs?)"); ?></FONT><P>

        <p><b><?php echo translate("Notes"); ?></b><br>
        <textarea wrap=virtual cols=50 rows=4 name=notes></textarea><br>

        <input type="hidden" NAME="qid" SIZE=50 value="<?PHP echo "$qid"; ?>">
        <input type="hidden" NAME="uid" SIZE=50 value="<?PHP echo "$uid"; ?>">
        <select name="op">
                <option value="DeleteStory"><?php echo translate("DeleteStory"); ?></option>
                <option value="PreviewAgain" SELECTED><?php echo translate("PreviewAgain"); ?></option>
                <option value="PostStory"><?php echo translate("PostStory"); ?></option>
        </select>
        <INPUT type="submit" value="<?php echo translate("Go!"); ?>">
        </td></tr></table></td></tr></table></form>
        <?PHP
        include ('footer.php');
}

function previewStory($qid, $uid, $author, $subject, $hometext, $bodytext, $topic, $notes) {
        global $user, $boxstuff;
        include ('config.php');
        include ('header.php');
        GraphicAdmin();
        $subject = stripslashes($subject);
        $hometext = stripslashes($hometext);
        $bodytext = stripslashes($bodytext);
        $notes = stripslashes($notes);
        ?>

        <table width=100% bgcolor=000000 cellpadding=0 cellspacing=0 border=0><tr><td>
        <table width=100% bgcolor=FFFFFF cellpadding=8 cellspacing=2 border=0><tr><td>
        <font size=3 face=Arial,Helvetica>

        <form action="admin.php" method=post>

        <p><b><?php echo translate("Name"); ?></b><br>
        <input type="text" NAME="author" SIZE=50 value="<?PHP echo"$author"; ?>">

        <p><b><?php echo translate("Subject"); ?></b><br>
        <input type=text name=subject size=50 value="<?PHP echo"$subject"; ?>">
        
        <?PHP
        $result = mysql_query("select topicimage from topics where topicid=$topic");
        list($topicimage) = mysql_fetch_row($result);
        echo "<br><br><center><table width=80% bgcolor=000000 cellpadding=0 cellspacing=0 border=0><tr><td>";
        echo "<table width=100% bgcolor=FFFFFF cellpadding=8 cellspacing=2 border=0><tr><td>";
        echo "<img src=$tipath$topicimage border=0 align=right>";
        themepreview($subject, $hometext, $bodytext);
        echo "</td></tr></table></td></tr></table></center>";

        ?>
        <p><b><?php echo translate("Topic"); ?></b> <select name=topic>
        <?PHP
        $toplist = mysql_query("select topicid, topictext from topics order by topictext");
        echo "<OPTION VALUE=\"\">".translate("All Topics")."</option>\n";
        while(list($topicid, $topics) = mysql_fetch_row($toplist)) {
        if ($topicid==$topic) { $sel = "selected "; }
            echo "<option $sel value=\"$topicid\">$topics</option>\n";
            $sel = "";
        }
        ?>
        </select>       
        <p><b><?php echo translate("Intro Text"); ?></b><br>
        <textarea wrap=virtual cols=50 rows=7 name=hometext><?PHP echo"$hometext"; ?></textarea>
        <p><b><?php echo translate("Full Text"); ?></b><br>
        <textarea wrap=virtual cols=50 rows=10 name=bodytext><?PHP echo"$bodytext"; ?></textarea><BR>
        <FONT size=2><?php echo translate("(Did you check URLs?)"); ?></FONT><P>

        <p><b><?php echo translate("Notes"); ?></b><br>
        <textarea wrap=virtual cols=50 rows=4 name=notes><?PHP echo"$notes"; ?></textarea><br>

        <input type="hidden" NAME="qid" SIZE=50 value="<?PHP echo"$qid"; ?>">
        <input type="hidden" NAME="uid" SIZE=50 value="<?PHP echo "$uid"; ?>">
        <select name="op">
                <option value="DeleteStory"><?php echo translate("DeleteStory"); ?></option>
                <option value="PreviewAgain" SELECTED><?php echo translate("PreviewAgain"); ?></option>
                <option value="PostStory"><?php echo translate("PostStory"); ?></option>
        </select>
        <INPUT type="submit" value="<?php echo translate("Go!"); ?>"></FORM>
        </td></tr></table></td></tr></table></form>
        
        <?PHP
        include ('footer.php');
}

function postStory($qid, $uid, $author, $subject, $hometext, $bodytext, $topic, $notes) {
        include("config.php");
        global $aid;
        dbconnect();
        if ($uid == -1) $author = "";
        if ($hometext == $bodytext) $bodytext = "";
        $subject = stripslashes(FixQuotes($subject));
        $hometext = stripslashes(FixQuotes($hometext));
        $bodytext = stripslashes(FixQuotes($bodytext));
        $notes = stripslashes(FixQuotes($notes));
        $result = mysql_query("insert into stories values (NULL, '$aid', '$subject', now(), '$hometext', '$bodytext', '0', '0', '$topic','$author', '$notes')");
        if (!$result) {
                echo mysql_errno(). ": ".mysql_error(). "<br>";
                return;
        }
        if ($uid == -1) {
        } else {
            mysql_query("update users set counter=counter+1 where uid='$uid'");
        }
            mysql_query("update authors set counter=counter+1 where aid='$aid'");
        if ($ultramode) {
            ultramode();
        }
        deleteStory($qid);
}

function editStory ($sid) {
        global $user, $subject, $hometext, $bodytext, $notes, $topic;
        include ('header.php');
        include ('config.php');
        dbconnect();
        GraphicAdmin();
        $result = mysql_query("SELECT title, hometext, bodytext, topic, notes FROM stories where sid=$sid");
        list($subject, $hometext, $bodytext, $topic, $notes) = mysql_fetch_row($result);
        mysql_free_result($result);

        $hometext = stripslashes($hometext);
        $bodytext = stripslashes($bodytext);
        $notes = stripslashes($notes);

        $result=mysql_query("select topicimage from topics where topicid=$topic");
        list($topicimage) = mysql_fetch_row($result);
        echo "<center><font size=4><b>".translate("Edit Article")."</b></center><br><br>";
        echo "<table width=100% border=0 cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table width=100% border=0 cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>";
        echo "<br><center><table width=80% border=0 cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table width=100% border=0 cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>";

        echo "<img src=$tipath$topicimage border=0 align=right>";

        themepreview($subject, $hometext, $bodytext);
        echo "</td></tr></table></td></tr></table></center><br><br>";
        ?>

        <form action="admin.php" method=post>
        <P><B><?php echo translate("Subject"); ?></B><br>
        <input type=text name=subject size=50 value="<?PHP echo"$subject"; ?>"><BR>
        <p><b><?php echo translate("Topic"); ?></b> <select name=topic>
        <?PHP
        $toplist = mysql_query("select topicid, topictext from topics order by topictext");
        echo "<OPTION VALUE=\"\">".translate("All Topics")."</option>\n";
        while(list($topicid, $topics) = mysql_fetch_row($toplist)) {
        if ($topicid==$topic) { $sel = "selected "; }
            echo "<option $sel value=\"$topicid\">$topics</option>\n";
            $sel = "";
        }
        ?>
        </select>
        <P><B><?php echo translate("Intro Text"); ?></B><br>
        <textarea wrap=virtual cols=50 rows=7 name=hometext><?PHP echo"$hometext"; ?></textarea>
        <P><B><?php echo translate("Full Text"); ?></B><br>
        <textarea wrap=virtual cols=50 rows=10 name=bodytext><?PHP echo"$bodytext"; ?></textarea><BR>
        <FONT size=2><?php echo translate("(Did you check URLs?)"); ?></FONT><P>

        <P><B><?php echo translate("Notes"); ?></B><br>
        <textarea wrap=virtual cols=50 rows=4 name=notes><?php echo "$notes"; ?></textarea><br>

        <input type="hidden" NAME="sid" SIZE=50 value="<?PHP echo"$sid"; ?>">
        <INPUT type="hidden" name="op" value="ChangeStory">
        <INPUT type="submit" value="<?php echo translate("ChangeStory"); ?>">
        </td></tr></table></td></tr></table></FORM>
        <?PHP
        include ('footer.php');
}

function removeStory ($sid, $ok=0) {
        if($ok) {
                dbconnect();
                mysql_query("DELETE FROM stories where sid=$sid");
                mysql_query("DELETE FROM comments where sid=$sid");
                Header("Location: admin.php");
        } else {
                include("header.php");
                GraphicAdmin();
                echo "<center>".translate("Are you sure you want to remove Story ID #")." $sid ".translate("and all it's comments?")."";
                echo "<br><br>[ <a href=\"admin.php\">".translate("No")."</a> | <a href=\"admin.php?op=RemoveStory&sid=$sid&ok=1\">".translate("Yes")."</a> ]</center>";
                include("footer.php");
        }
}


function changeStory($sid, $subject, $hometext, $bodytext, $topic, $notes) {
        global $aid;
        dbconnect();
        $subject = stripslashes(FixQuotes($subject));
        $hometext = stripslashes(FixQuotes($hometext));
        $bodytext = stripslashes(FixQuotes($bodytext));
        $notes = stripslashes(FixQuotes($notes));
        mysql_query("update stories set title='$subject', hometext='$hometext', bodytext='$bodytext', topic='$topic', notes='$notes' where sid=$sid");
        Header("Location: admin.php?op=adminMain");
}

function adminStory() {
        include ('header.php');
        include ('config.php');
        dbconnect();
        GraphicAdmin();
        echo "
        <a name=new></a>
        $font4<center><b>".translate("New Article")."</b></font></center><br><br>$font3"; ?>
        <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        <?php echo "$font3"; ?>
        <form action="admin.php" method=post>
        <p><b><?php echo translate("Title"); ?></b><br>
        <input type=text name=subject size=50 value=""><BR>
        <BR>
        <p><b><?php echo translate("Topic"); ?></b>
        <?php
        $toplist = mysql_query("select topicid, topictext from topics order by topictext");
        echo "<SELECT NAME=\"topic\">";
        echo "<OPTION VALUE=\"\">".translate("Select Topic")."</option>\n";
        while(list($topicid, $topics) = mysql_fetch_row($toplist)) {
            if ($topicid==$topic) { $sel = "selected "; }
                echo "<option $sel value=\"$topicid\">$topics</option>\n";
                $sel = "";
            }
        echo "</SELECT>";
        ?>
        <P><B><?php echo translate("The Story"); ?></B><br>
        <textarea wrap=virtual cols=70 rows=12 name=hometext></textarea><BR>
        <P><B><?php echo translate("Extended Text"); ?></B><br>
        <textarea wrap=virtual cols=70 rows=12 name=bodytext></textarea><BR>
        <FONT size=2><?php echo translate("(Are you sure you included a URL? Did ya test them for typos?)"); ?></FONT><P>
        <select name="op">
        <option value="PreviewAdminStory" SELECTED><?php echo translate("PreviewAdminStory"); ?></option>
        <option value="PostAdminStory"><?php echo translate("PostAdminStory"); ?></option>
        </select>
        <INPUT type="submit" value="<?php echo translate("Go!"); ?>">
        </td></tr></table></td></tr></table></form>
        <?PHP
        include ('footer.php');
}

function previewAdminStory($subject, $hometext, $bodytext, $topic) {
        global $user;
        include ('header.php');
        include ('config.php');
        GraphicAdmin();
        echo "
        $font4<b><center>".translate("Preview Story")."</b><br><br><br>
        <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        <form action=\"admin.php\" method=post>
        </b></center>$font3
        ";
        $subject = stripslashes($subject);
        $hometext = stripslashes($hometext);
        $bodytext = stripslashes($bodytext);
        $result=mysql_query("select topicimage from topics where topicid=$topic");
        list($topicimage) = mysql_fetch_row($result);
        echo "<center><br><table border=0 width=80% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>";
        echo "<table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>";
        echo "$font3";
        echo "<img src=$tipath$topicimage border=0 align=right>";
        themepreview($subject, $hometext, $bodytext);
        echo "</td></tr></table></td></tr></table></center>";
        ?>
        <p><b><?php echo translate("Title"); ?></b><br>
        <input type=text name=subject size=50 value="<?PHP echo"$subject"; ?>"><BR>
        <p><b><?php echo translate("Topic"); ?></b> <select name=topic>
        <?PHP
        $toplist = mysql_query("select topicid, topictext from topics order by topictext");
        echo "<OPTION VALUE=\"\">".translate("All Topics")."</option>\n";
        while(list($topicid, $topics) = mysql_fetch_row($toplist)) {
        if ($topicid==$topic) { $sel = "selected "; }
            echo "<option $sel value=\"$topicid\">$topics</option>\n";
            $sel = "";
        }
        ?>
        </select>
        <p><b><?php echo translate("The Story"); ?></b><br>
        <textarea wrap=virtual cols=70 rows=12 name=hometext><?PHP echo "$hometext"; ?></textarea><BR>
        <textarea wrap=virtual cols=70 rows=12 name=bodytext><?PHP echo "$bodytext"; ?></textarea><BR>
        <select name="op">
        <option value="PreviewAdminStory" SELECTED><?php echo translate("PreviewAdminStory"); ?></option>
        <option value="PostAdminStory"><?php echo translate("PostAdminStory"); ?></option>
        </select>
        <INPUT type="submit" value="<?php echo translate("Go!"); ?>">
        </td></tr></table></td></tr></table></form>
        <?PHP
        include ('footer.php');

}

function postAdminStory($subject, $introstory, $fullstory, $topic) {
        include("config.php");
        global $aid;
        dbconnect();
        $subject = stripslashes(FixQuotes($subject));
        $introstory = stripslashes(FixQuotes($introstory));
        $fullstory = stripslashes(FixQuotes($fullstory));
        $result = mysql_query("insert into stories values (NULL, '$aid', '$subject', now(), '$introstory', '$fullstory', '0', '0', '$topic', '$aid', '$notes')");
        if (!$result)
        {
                echo mysql_errno(). ": ".mysql_error(). "<br>";
                exit();
        }
        $result = mysql_query("update authors set counter=counter+1 where aid='$aid'");
        if ($ultramode) {
            ultramode();
        }
        Header("Location: admin.php?op=adminMain");
}

/*********************************************************/
/* Comments Delete Function                              */
/*********************************************************/

// This function is a big crap. I need to delete all babies comments
// maybe by setting a unique number for each Parent comment?
// Anyone, please help me to do this!

function removeComment ($tid, $sid) {
    dbconnect();
    mysql_query("update stories set comments=comments-1 where sid='$sid'");
    mysql_query("DELETE FROM comments where tid=$tid");
    mysql_query("DELETE FROM comments where pid=$tid");
    
    Header("Location: article.php?sid=$sid");
}

function RemovePollComment ($tid, $pollID) {
    dbconnect();
    mysql_query("DELETE FROM pollcomments where tid=$tid and pollID=$pollID");
    mysql_query("DELETE FROM pollcomments where pid=$tid");    
    Header("Location: pollBooth.php?op=results&pollID=$pollID");
}

/*********************************************************/
/* Admin/Authors Functions                               */
/*********************************************************/

function displayadmins() {
        $titlebar = "<b>".translate("current authors")."</b>";
        include("header.php");
        dbconnect();
        GraphicAdmin();
        echo "
        <center>$font4<b>
        ".translate("Edit Admins")."
        <br><br></center></b>
        <table width=100% border=0 cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table width=100% border=0 cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        ";
        $result = mysql_query("select aid, name from authors");
        echo "<table border=1>";
        while(list($a_aid, $name) = mysql_fetch_row($result)) {
                echo "<tr><td>$font3$a_aid</td>";
                echo "<td>$font3<a href=\"admin.php?op=modifyadmin&chng_aid=$a_aid\">".translate("Modify Info")."</a></td>";
                if($name=="God") {
                } else {
                    echo "<td>$font3<a href=\"admin.php?op=deladmin&del_aid=$a_aid\">".translate("Delete Author")."</a></td></tr>";
                }
        }
?>
</table>
<form action="admin.php" method="post">
<table cols=2 border=0>
<tr><td width=100><?php echo "$font3"; ?><? echo translate("Handle");?>*</td>
    <td><?php echo "$font3"; ?> <input type="text" name="add_aid" size=30 maxlength=30></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Name");?>*</td>
    <td><?php echo "$font3"; ?><input type="text" name="add_name" size=30 maxlength=50></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Email");?>*</td>
    <td><?php echo "$font3"; ?> <input type="text" name="add_email" size=30 maxlength=60></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("URL");?></td>
    <td><?php echo "$font3"; ?> <input type="text" name="add_url" size=30 maxlength=60></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Password");?>*</td>
    <td><?php echo "$font3"; ?> <input type="text" name="add_pwd" size=12 maxlength=12></td></tr>
<input type="hidden" name="op" value="AddAuthor">
<tr><td colspan=2><?php echo "$font3"; ?><input type=submit value="<?echo translate("Add Author");?>"></td></tr>
</table></form>
<?php echo translate("* indicates compulsory fields"); ?></font>
</td></tr></table></td></tr></table>
<?

        include("footer.php");
}

function modifyadmin($chng_aid) {
        $titlebar = "<b>".translate("update")." $chng_aid</b>";
        include("header.php");
        dbconnect();
        GraphicAdmin();
        echo "<table width=100% border=0 cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table width=100% border=0 cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>";
        $result = mysql_query("select aid, name, url, email, pwd from authors where aid='$chng_aid'");
        list($chng_aid, $chng_name, $chng_url, $chng_email, $chng_pwd) = mysql_fetch_row($result);
?>
<form action="admin.php" method="post">
<table cols=2 border=0>
<tr><td width=100><?php echo "$font3"; ?><? echo translate("Name");?></td>
    <td><?php echo "$font3"; ?> <?echo $chng_name ?><input type="hidden" name="chng_name" value="<? echo $chng_name ?>"></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Handle");?>*</td>
    <td><?php echo "$font3"; ?> <input type="text" name="chng_aid" value="<? echo $chng_aid?>"></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Email");?>*</td>
    <td><?php echo "$font3"; ?> <input type="text" name="chng_email" value="<? echo $chng_email?>" size=30 maxlength=60></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("URL");?></td>
    <td><?php echo "$font3"; ?> <input type="text" name="chng_url" value="<? echo $chng_url?>" size=30 maxlength=60></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Password")?></td>
    <td><?php echo "$font3"; ?> <input type="password" name="chng_pwd"  size=12 maxlength=12></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Retype Password");?></td>
    <td><?php echo "$font3"; ?> <input type="password" name="chng_pwd2" size=12 maxlength=12> <? echo translate("(for changes only)");?></td></tr>
<input type="hidden" name="op" value="UpdateAuthor">
<tr><td colspan=2><?php echo "$font3"; ?><input type="submit" value="<? echo translate("Update Author");?>"></td></tr>
</table></form>
<? echo translate("* indicates compulsory fields"); ?></font>
</td></tr></table></td></tr></table>
<?
        include("footer.php");
}

function updateadmin($chng_aid, $chng_name, $chng_email, $chng_url, $chng_pwd, $chng_pwd2) {
        if (!($chng_aid && $chng_name && $chng_email))
                Header("Location: admin.php?op=adminMain");

        if ($chng_pwd2 != "") {
                if($chng_pwd != $chng_pwd2) {
                        $titlebar = "<b>".translate("bad pass")."</b>";
                        include("header.php");
                        GraphicAdmin();
                        echo translate("Sorry, the new passwords do not match. Click back and try again");
                        include("footer.php");
                        exit;
                }
                dbconnect();
                $result = mysql_query("update authors set aid='$chng_aid', email='$chng_email', url='$chng_url', pwd='$chng_pwd' where name='$chng_name'");
                Header("Location: admin.php?op=adminMain");
        } else {
                dbconnect();
                $result = mysql_query("update authors set aid='$chng_aid', email='$chng_email', url='$chng_url' where name='$chng_name'");
                Header("Location: admin.php?op=adminMain");
        }
}

/*********************************************************/
/* Users Functions                                       */
/*********************************************************/

function displayUsers() {
        include("header.php");
        GraphicAdmin();
        echo "
        $font4<b><center>
        ".translate("Edit Users")."
        <br><br></b></center>
        <table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>$font3";
        echo "<form method=post action=\"admin.php\">";
        echo "<b>".translate("Handle/UserID").": </b> <input type=text name=\"chng_uid\" size=10>\n";
        echo "<select name=\"op\">";
        echo "<option value=\"modifyUser\">".translate("Modify User")."</option>\n";
        echo "<option value=\"delUser\">".translate("Delete User")."</option></select>\n";
        echo "<input type=\"submit\" value=\"".translate("Go!")."\"></form>";
?>
<form action="admin.php" method="post">
<table cols=2 border=0 width=100%>
<tr><td width=100><?php echo "$font3"; ?><? echo translate("Handle");?>*</td>
    <td><?php echo "$font3"; ?> <input type="text" name="add_uname" size=30 maxlength=25></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Name");?></td>
    <td><?php echo "$font3"; ?><input type="text" name="add_name" size=30 maxlength=50></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Email");?>*</td>
    <td><?php echo "$font3"; ?> <input type="text" name="add_email" size=30 maxlength=60></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Fake Email");?></td>
    <td><?php echo "$font3"; ?> <input type="text" name="add_femail" size=30 maxlength=60></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("URL");?></td>
    <td><?php echo "$font3"; ?> <input type="text" name="add_url" size=30 maxlength=60></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Password");?>*</td>
    <td><?php echo "$font3"; ?> <input type="text" name="add_pass" size=12 maxlength=12></td></tr>
<input type="hidden" name="op" value="addUser">
<tr><td colspan=2><?php echo "$font3"; ?><input type=submit value="<?echo translate("Add User");?>"></td></tr>
</table></form>
<?php echo "<center>$font3<font color=Red> ".translate("* indicates compulsory fields")." "; ?></font>
</td></tr></table></td></tr></table>
<?

        include("footer.php");
}

function modifyUser($chng_user) {
        include("header.php");
        dbconnect();
        GraphicAdmin();
        $result = mysql_query("select uid, uname, name, url, email, femail, pass from users where uid='$chng_user' or uname='$chng_user'");
        if(mysql_num_rows($result) > 0) {
                while(list($chng_uid, $chng_uname, $chng_name, $chng_url, $chng_email, $chng_femail, $chng_pass) = mysql_fetch_row($result)) {
                echo "
                $font4<b><center>
                ".translate("Update User").": $chng_uname
                <br><br></b></center>";
?>
<table border=0 width=100% cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
<table border=0 width=100% cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
<form action="admin.php" method="get">
<table border=0>
<tr><td><?php echo "$font3"; ?><? echo translate("User ID");?></td>
    <td><?php echo "$font3"; ?><? echo $chng_uid ?></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Handle");?>*</td>
    <td><?php echo "$font3"; ?><input type="text" name="chng_uname" value="<? echo $chng_uname ?>"></td></tr>
<tr><td width=100><?php echo "$font3"; ?><? echo translate("Name");?></td>
    <td><?php echo "$font3"; ?><input type="text" name="chng_name" value="<? echo $chng_name ?>"></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("URL");?></td>
    <td><?php echo "$font3"; ?> <input type="text" name="chng_url" value="<? echo $chng_url ?>" size=30 maxlength=60></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Email");?>*</td>
    <td><?php echo "$font3"; ?> <input type="text" name="chng_email" value="<? echo $chng_email ?>" size=30 maxlength=60></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Fake Email");?></td>
    <td><?php echo "$font3"; ?> <input type="text" name="chng_femail" value="<? echo $chng_femail ?>" size=30 maxlength=60></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Password")?></td>
    <td><?php echo "$font3"; ?> <input type="password" name="chng_pass"  size=12 maxlength=12></td></tr>
<tr><td><?php echo "$font3"; ?><? echo translate("Retype Password");?></td>
    <td><?php echo "$font3"; ?> <input type="password" name="chng_pass2" size=12 maxlength=12> <? echo translate("(for changes only)");?></td></tr>
<input type="hidden" name="chng_uid" value="<?php echo $chng_uid; ?>">
<input type="hidden" name="op" value="updateUser">
<tr><td colspan=2><?php echo "$font3"; ?><input type="submit" value="<? echo translate("Update User");?>"></td></tr>
</table></form>
<?
                }
                echo "<center>$font3<font color=Red>".translate("* indicates compulsory fields")."</font>";
                echo "</td></tr></table></td></tr></table>";
        } else {
                echo "<center>";
                echo translate("User doesn't exist!");
                echo "</center>";
        }
        include("footer.php");
}

function updateUser($chng_uid, $chng_uname, $chng_name, $chng_url, $chng_email, $chng_femail, $chng_pass, $chng_pass2) {
        $tmp = 0;
        if ($chng_pass2 != "") {
                if($chng_pass != $chng_pass2) {
                        $titlebar = "<b>".translate("bad pass")."</b>";
                        include("header.php");
                        GraphicAdmin();
                        echo "
                        <center>".translate("Sorry, the new passwords do not match. Click back and try again")."</center>";
                        include("footer.php");
                        exit;
                }
            $tmp = 1;
        }
        dbconnect();
        if ($tmp == 0) {
            mysql_query("update users set uname='$chng_uname', name='$chng_name', email='$chng_email', femail='$chng_femail', url='$chng_url' where uid='$chng_uid'");
        }
        if ($tmp == 1) {
            $cpass = crypt($chng_pass);
            mysql_query("update users set uname='$chng_uname', name='$chng_name', email='$chng_email', femail='$chng_femail', url='$chng_url', pass='$cpass' where uid='$chng_uid'");   
        }
        header("Location: admin.php?op=adminMain");
}


/*********************************************************/
/* Poll/Surveys Functions                                */
/*********************************************************/

function poll_createPoll() {
        include ('header.php');
        GraphicAdmin();
        ?>

        <font size=4><b><center><?php echo translate("Create new poll"); ?><br>
        <font size=2><a href=admin.php?op=remove><?php echo translate("Delete Polls"); ?></a><br><br></font></center>
        <table width=100% border=0 cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table width=100% border=0 cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        <font face=Arial,Helvetica>
        <form action="admin.php" method="post">
        <input type="hidden" name="op" value="createPosted">
        <p><?php echo translate("Polltitle"); ?>: <input type=text name="pollTitle" size=50 maxlength=100></p>
        <p><?php echo translate("Please enter each available option into a single field"); ?></p>

        <table>
        <?PHP
        for($i = 1; $i <= $maxOptions; $i++)
        {
                echo "<tr>";
                echo "<td><font face=Arial,Helvetica>".translate("Option")." $i:</td><td><input type=text name=\"optionText[$i]\" size=50 maxlength=50></td>";
                echo "</tr>";
        }

        echo "</tr></table>";
        echo "<input type=\"submit\" value=\"".translate("Create")."\">";
        echo "</td></tr></table></td></tr></table></form>";
        include ('footer.php');
}

function old_poll_createPosted() {
        global $maxOptions, $pollTitle, $optionText;
        dbconnect();
        $timeStamp = time();
        $result = mysql_query("INSERT INTO poll_desc VALUES (NULL, '$pollTitle', '$timeStamp')");
        if (!$result)   {
                echo mysql_errno(). ": ".mysql_error(). "<br>";
                return;
        }
        mysql_free_result($result);

        // create option records in data table
        for($i = 1; $i <= $maxOptions; $i++) {
                if($optionText[$i] != "")
                        $result = mysql_query("INSERT INTO poll_data VALUES ($id, '$optionText[$i]', 0, $i)");
                        if (!result) {
                                echo mysql_errno(). ": ".mysql_error(). "<br>";
                                return;
                        }
                        mysql_free_result($result);
        }
        Header("Location: admin.php?op=adminMain");
}

function poll_createPosted() {
        global $maxOptions, $pollTitle, $optionText;
        dbconnect();
        $timeStamp = time();
        $pollTitle = FixQuotes($pollTitle);
        if(!mysql_query("INSERT INTO poll_desc VALUES (NULL, '$pollTitle', '$timeStamp', 0)")) {
                echo mysql_errno(). ": ".mysql_error(). "<br>";
                return;
        }
        $object = mysql_fetch_object(mysql_query("SELECT pollID FROM poll_desc WHERE pollTitle='$pollTitle'"));
        $id = $object->pollID;

        for($i = 1; $i <= sizeof($optionText); $i++) {
                if($optionText[$i] != "")
                        $optionText[$i] = FixQuotes($optionText[$i]);
                        if(!mysql_query("INSERT INTO poll_data (pollID, optionText, optionCount, voteID) VALUES ($id, '$optionText[$i]', 0, $i)")) {
                                echo mysql_errno(). ": ".mysql_error(). "<br>";
                                return;
                        }
        }
        Header("Location: admin.php?op=adminMain");
}

function poll_removePoll() {
        include ('header.php');
        dbconnect();
        GraphicAdmin();
        ?>

        <font size=4><b><center><?php echo translate("Remove an existing poll"); ?></b></center><br><br></font>
        <table width=100% border=0 cellpadding=0 cellspacing=0 bgcolor=000000><tr><td>
        <table width=100% border=0 cellpadding=8 cellspacing=1 bgcolor=FFFFFF><tr><td>
        <h3><center><?php echo translate("WARNING: The chosen poll will be removed IMMEDIATELY from the database!"); ?></center></h3>
        <p><?php echo translate("Please choose a poll from the list below."); ?></p>
        <form action="admin.php" method="post">
        <input type="hidden" name="op" value="removePosted">
        <table>

        <?PHP
        $result = mysql_query("SELECT pollID, pollTitle, timeStamp FROM poll_desc ORDER BY timeStamp"); 
        if(!$result) {
                echo mysql_errno(). ": ".mysql_error(). "<br>";
                return;
        }

        // cycle through the descriptions until everyone has been fetched
        while($object = mysql_fetch_object($result)) {
                $pollID = $object->pollID;
                echo "<tr><td><input type=\"radio\" name=\"id\" value=\"".$object->pollID."\">".$object->pollTitle."</td></tr>";
        }

        echo "</table>";
        echo "<input type=\"submit\" value=\"".translate("Remove")."\">";
        echo "</td></tr></table></td></tr></table></form>";
        include ('footer.php');
}

function poll_removePosted() {
        global $id;
        dbconnect();
        mysql_query("DELETE FROM poll_desc WHERE pollID=$id");
        mysql_query("DELETE FROM poll_data WHERE pollID=$id");
        Header("Location: admin.php?op=adminMain");
}

function poll_viewPoll() {
        include ('header.php');
        GraphicAdmin();
        echo "<font size=4>".translate("View poll results")."</font>";
        dbconnect();
        echo "<p>";

        // select all descriptions
        $result = mysql_query("SELECT pollID, pollTitle, timeStamp FROM poll_desc ORDER BY timeStamp"); 
        if(!$result) {
                echo mysql_errno(). ": ".mysql_error(). "<br>";
                return;
        }

        echo "<form action=\"".basename($GLOBALS[PHP_SELF])."\" method=\"post\">";
        echo "<input type=\"hidden\" name=\"op\" value=\"viewPosted\">";
        echo "<table>";

        // cycle through the descriptions until everyone has been fetched
        while($object = mysql_fetch_object($result)) {
                echo "<tr><td><input type=\"radio\" name=\"id\" value=\"".$object->pollID."\">".$object->pollTitle."</td></tr>";
        }
        echo "</table>";
        echo "<input type=\"submit\" value=\"".translate("View")."\">";
        echo "</form>";
        include ('footer.php');
}

function poll_viewPosted() {
        include ('header.php');
        GraphicAdmin();
        global $id;
        echo "<font size=4>".translate("View poll results")."</font><p>";
        pollResults($id);
        include ('footer.php');
}

if($admintest) {
        switch($op) {
        
                case "eventsedit":
                        eventsedit($eid, $did, $mid);
                        break;
        
                case "eventschange":
                        eventschange($eid, $did, $mid, $yid, $content);
                        break;
                        
                case "eventsdel":
                        eventsdel($eid, $did, $mid);
                        break;
                        
                case "eventsmaintenance":
                        eventsmaintenance($did, $mid);
                        break;
                        
                case "eventsadd":
                        eventsadd($did, $mid, $yid, $content);
                        break;
                        
                case "events":
                        events();
                        break;
                        
                case "links":
                        links();
                        break;

                case "LinksDelNew":
                        LinksDelNew($lid);
                        break;

                case "LinksAddCat":
                        LinksAddCat($title);
                        break;

                case "LinksAddSubCat":
                        LinksAddSubCat($cid, $title);
                        break;

                case "LinksAddLink":
                        LinksAddLink($new, $lid, $title, $url, $cat, $description, $name, $email);
                        break;
                        
                case "LinksDelCat":
                        LinksDelCat($cid, $sid, $sub, $ok);
                        break;

                case "LinksModCat":
                        LinksModCat($cat);
                        break;

                case "LinksModCatS":
                        LinksModCatS($cid, $sid, $sub, $title);
                        break;

                case "LinksModLink":
                        LinksModLink($lid);
                        break;

                case "LinksModLinkS":
                        LinksModLinkS($lid, $title, $url, $description, $name, $email, $hits, $cat);
                        break;

                case "LinksDelLink":
                        LinksDelLink($lid);
                        break;

                case "BannersAdmin":
                        BannersAdmin();
                        break;

                case "BannersAdd":
                        BannersAdd($name, $cid, $imptotal, $imageurl, $clickurl);
                        break;

                case "BannerAddClient":
                        BannerAddClient($name, $contact, $email, $login, $passwd, $extrainfo);
                        break;

                case "BannerFinishDelete":
                        BannerFinishDelete($bid);
                        break;

                case "BannerDelete":
                        BannerDelete($bid, $ok);
                        break;

                case "BannerEdit":
                        BannerEdit($bid);
                        break;
                
                case "BannerChange":
                        BannerChange($bid, $cid, $imptotal, $impadded, $imageurl, $clickurl);
                        break;

                case "BannerClientDelete":
                        BannerClientDelete($cid, $ok);
                        break;

                case "BannerClientEdit":
                        BannerClientEdit($cid);
                        break;

                case "BannerClientChange":
                        BannerClientChange($cid, $name, $contact, $email, $extrainfo, $login, $passwd);
                        break;

                case "GraphicsAdmin":
                        GraphicAdmin();
                        break;

                case "hreferer":
                        hreferer();
                        break;

                case "delreferer":
                        delreferer();
                        break;

                case "adminMain":
                        adminMain();
                        break;

                case "topicsmanager":
                        topicsmanager();
                        break;

                case "topicedit":
                        topicedit($topicid);
                        break;

                case "topicmake":
                        topicmake($topicname, $topicimage, $topictext);
                        break;

                case "topicdelete":
                        topicdelete($topicid, $ok);
                        break;

                case "topicchange":
                        topicchange($topicid, $topicname, $topicimage, $topictext);
                        break;
                
                case "sections":
                        sections();
                        break;

                case "sectionedit":
                        sectionedit($secid);
                        break;

                case "sectionmake":
                        sectionmake($secname, $image);
                        break;

                case "sectiondelete":
                        sectiondelete($secid, $ok);
                        break;

                case "sectionchange":
                        sectionchange($secid, $secname, $image);
                        break;

                case "secarticleadd":
                        secarticleadd($secid, $title, $content);
                        break;
                
                case "secartedit":
                        secartedit($artid);
                        break;
                        
                case "secartchange":
                        secartchange($artid, $secid, $title, $content);
                        break;
                
                case "secartdelete":
                        secartdelete($artid, $ok);
                        break;
                        
                case "blocks":
                        blocks();
                        break;

                case "makeblock":
                        makeblock($title, $content);
                        break;

                case "deleteblock":
                        deleteblock($id);
                        break;

                case "changeblock":
                        changeblock($id, $title, $content);
                        break;

                case "rblocks":
                        rblocks();
                        break;

                case "makerblock":
                        makerblock($title, $content);
                        break;

                case "deleterblock":
                        deleterblock($id);
                        break;

                case "changerblock":
                        changerblock($id, $title, $content);
                        break;
                        
                case "lblocks":
                        lblocks();
                        break;

                case "makelblock":
                        makelblock($title, $content);
                        break;

                case "deletelblock":
                        deletelblock($id);
                        break;

                case "changelblock":
                        changelblock($id, $title, $content);
                        break;
                        
                case "ablock":
                        ablock();
                        break;

                case "changeablock":
                        changeablock($title, $content);
                        break;

                case "mblock":
                        mblock();
                        break;

                case "changemblock":
                        changemblock($title, $content);
                        break;

                case "DisplayStory":
                        displayStory($qid);
                        break;

                case "PreviewAgain":
                        previewStory($qid, $uid, $author, $subject, $hometext, $bodytext, $topic, $notes);
                        break;

                case "PostStory":
                        postStory($qid, $uid, $author, $subject, $hometext, $bodytext, $topic, $notes);
                        break;

                case "EditStory":
                        editStory($sid);
                        break;

                case "RemoveStory":
                        removeStory($sid, $ok);
                        break;

                case "RemoveComment":
                        removeComment($tid, $sid);
                        break;

                case "RemovePollComment":
                        RemovePollComment($tid, $pollID);
                        break;

                case "ChangeStory":
                        changeStory($sid, $subject, $hometext, $bodytext, $topic, $notes);
                        break;

                case "DeleteStory":
                        deleteStory($qid);
                        break;

                case "adminStory":
                        adminStory($sid);
                        break;

                case "PreviewAdminStory":
                        previewAdminStory($subject, $hometext, $bodytext, $topic);
                        break;

                case "PostAdminStory":
                        postAdminStory($subject, $hometext, $bodytext, $topic);
                        break;
                
                case "mod_authors":
                        displayadmins();
                        break;
                
                case "modifyadmin":
                        modifyadmin($chng_aid);
                        break;

                case "UpdateAuthor":
                        updateadmin($chng_aid, $chng_name, $chng_email, $chng_url, $chng_pwd, $chng_pwd2);
                        break;

                case "AddAuthor":
                        if (!($add_aid && $add_name && $add_email && $add_pwd)) {
                            echo translate("You must complete all compulsory fields");
                            return;
                        }
                        dbconnect();
                        $result = mysql_query("insert into authors values ('$add_aid','$add_name','$add_url','$add_email','$add_pwd','0')");
                        if (!$result) {
                                echo mysql_errno(). ": ".mysql_error(). "<br>"; return;
                        }
                        Header("Location: admin.php?op=adminMain");
                        break;

                case "deladmin":
                        $titlebar = "<b>".translate("delete")." $del_aid ".translate("- are you sure?")."</b>";
                        include("header.php");
                        echo "$font4<b> ".translate("Delete Author")."</b>$font3<br><br>";
                        echo translate("Are you sure you want to delete")." $del_aid? ";
                        echo "[ <a href=\"admin.php?op=deladminconf&del_aid=$del_aid\">".translate("Yes")."</a>&nbsp;|&nbsp;<a href=\"admin.php?op=adminMain\">".translate("No")."</a> ]";
                        include("footer.php");
                        break;

                case "deladminconf":
                        dbconnect();
                        mysql_query("delete from authors where aid='$del_aid'");
                        Header("Location: admin.php?op=adminMain");
                        echo mysql_error();
                        break;

                case "mod_users":
                        displayUsers();
                        break;

                case "modifyUser":
                        modifyUser($chng_uid);
                        break;

                case "updateUser":
                        updateUser($chng_uid, $chng_uname, $chng_name, $chng_url, $chng_email, $chng_femail, $chng_pass, $chng_pass2);
                        break;

                case "delUser":
                        include("header.php");
                        $titlebar = "<h3>".translate("Delete User")."</h3>";
                        echo $titlebar;
                        echo translate("Are you sure you want to delete") . " " . translate("user") . " $chng_uid? ";
                        echo "[ <a href=\"admin.php?op=delUserConf&del_uid=$chng_uid\">".translate("Yes")."</a> | <a href=\"admin.php?op=adminMain\">".translate("No")."</a> ]";
                        include("footer.php");
                        break;

                case "delUserConf":
                        dbconnect();
                        mysql_query("delete from users where uid='$del_uid' or uname='$del_uid'");
                        Header("Location: admin.php?op=adminMain");
                        echo mysql_error();
                        break;

                case "addUser":
                        if($crypt==1) $add_pwd=crypt($add_pwd);
                        elseif($crypt==2) $add_pwd=md5($add_pwd);
                        if (!($add_uname && $add_email && $add_pass)) {
                            echo translate("You must complete all compulsory fields");
                            return;
                        }
                        dbconnect();
                        $sql    = "insert into users ";
                        $sql    .= "(name,uname,email,femail,url,pass) ";
                        $sql    .= "values ('$add_name','$add_uname','$add_email','$add_femail','$add_url','$add_pwd')";
                        $result = mysql_query($sql);
                        if (!$result) {
                                echo mysql_errno(). ": ".mysql_error(). "<br>"; return;
                        }
                        Header("Location: admin.php?op=adminMain");
                        break;

                case "create":
                        poll_createPoll();
                        break;

                case "createPosted":
                        poll_createPosted();
                        break;

                case "poll_editPoll":
                        poll_editPoll($pollID);
                        break;

                case "ChangePoll":
                        ChangePoll($pollID, $pollTitle, $optionText, $optionCount, $voteID);
                        break;

                case "remove":
                        poll_removePoll();
                        break;

                case "removePosted":
                        poll_removePosted();
                        break;
    
                case "view": 
                        poll_viewPoll();
                        break;

                case "viewPosted":
                        poll_viewPosted();
                        break;

                case "logout":
                        setcookie("admin");
                        $titlebar = translate("Logged out");
                        include("header.php");
                        echo "<center><font size=4 face=Arial,Helvetica>";
                        echo translate("You are now logged out")."<br><br>";
                        include("footer.php");
                        break;

                default:
                        adminMain();
                        break;
        }
} else {
        login();
}

?>