
<?

    $conn = mysql_pconnect("localhost", "poundl", "poundlisthebestcomicevah");

    mysql_select_db("poundl");

?>



<html>

 <head>

  <title>PoundL Comic Admin</title>

 </head>

 <body bgcolor="#FFFFFF">

  <center>

   <a href="http://poundl.com/"><img src="/images/pound-l.jpg" border="0"></a><br>

   [<a href="http://poundl.com/admin/">Reload Admin Page</a>]<br>

   [<a href="http://poundl.com/psd_files/">PSD Files</a>]<br>

   <br>



<?

    if (isset($form["saveedit"])) {

         // Update comic in database

         if ($picture != "none") {

            if (is_uploaded_file($picture)) {

                $picname = $form["id"] . ".jpg";

                copy($picture, "/usr/home/joseph/poundl/comics/$picname");

                echo "<B>Comic Image Uploaded: $picname</B><br><br>";

                $form["comicimage"] = $picname;

            }

        }

        if ($form["comicimage"]) {

            $form["dateshow"] = $form["year"]."-".$form["month"]."-".$form["day"]." ".$form["hour"].":00:00";

             $stmt = "UPDATE comics SET ";

            $stmt .= "dateshow = '". $form["dateshow"]. "', ";

            $stmt .= "comicimage = '".$form["comicimage"]. "', ";

            $stmt .= "title = '". addslashes($form["title"]). "' ";

            $stmt .= "WHERE id = ". $form["id"];

             $result = mysql_query($stmt,$conn);

            $news = "UPDATE posts SET ";

            $news .= "who = '". addslashes(ucwords($form["who"])) ."', ";

            $news .= "post = '". addslashes($form["post"]) ."' ";

            $news .= "WHERE id = ". $form["id"];

            $result = mysql_query($news,$conn);

            echo "<br><B>Comic and News Post added</B>:  ID Number:  ". $form["id"] ."  <br><br>";

        } else {

            echo "<B><font color=red>You MUST have a comic already uploaded or to upload now!</font></B><BR><BR>";

        }

    } elseif (isset($form["addcomic"])) {

         // add new comic and news to database

        $form["dateshow"] = $form["year"]."-".$form["month"]."-".$form["day"]." ".$form["hour"].":00:00";

         $stmt = "INSERT INTO comics (dateshow,comictype,title) ";

         $stmt .= "VALUES ('". $form["dateshow"]. "','d','". addslashes($form["title"]). "')";

         $result = mysql_query($stmt,$conn);

         $id = mysql_insert_id($conn);

         if ($id > 0) {

            $news = "INSERT INTO posts (id,who,post) ";

            $news .= "VALUES ($id,'". addslashes(ucwords($form["who"])) ."','". addslashes($form["post"]) ."')";

            $result = mysql_query($news,$conn);

            echo "<br><B>Comic and News Post added</B>:  ID Number:  $id  <br><br>";

        }

         if ($picture != "none") {

            if (is_uploaded_file($picture)) {

                $picname = $id . ".jpg";

                copy($picture, "/usr/home/joseph/poundl/comics/$picname");

                echo "<B>Comic Image Uploaded: $picname</B><br><br>";

            } else {

                echo "<B><font color=RED>Ass, you fucking broke something.  Fucking tell paul RIGHT NOW what you did.</font><B><br><br>";

            }

        } elseif ($form["comicimage"]) {

            $ci = $form["comicimage"];

            $picname = $id . ".jpg";

            // move comicimage to id.jpg

            copy ("/usr/home/joseph/poundl/comics/$ci","/usr/home/joseph/poundl/comics/$picname");

            echo "<B>Copied $ci to $picname and using $picname as comic image file.</B><br><br>";

        } else {

            echo "<B><font color=RED>You MUST fucking upload a picture, you retard.  Go edit this new entry and fix.</font></B><br><br>";

        }

        $stmt = "UPDATE comics SET comicimage = '$picname' WHERE id = '$id'";

        mysql_query($stmt,$conn);

    } elseif (isset($form["addtopic"])) {

        $stmt = "INSERT INTO randomquotes VALUES ('". htmlentities(addslashes($form["topic"])) ."')";

        mysql_query($stmt,$conn);

        echo "<B>New Topic Added</B><br><br>";

    } elseif (isset($form["addsponsor"])) {

        $stmt = "INSERT INTO sponsors VALUES ('". htmlentities(addslashes($form["sponsor"])) ."')";

        mysql_query($stmt,$conn);

        echo "<B>New Sponsor Added</B><br><br>";

    }



?>



  <table border="0">

   <tr>

    <td align="center" colspan="2">

     <form method=post action="/admin/">

      Select Comic to Edit:<br>

      <select name="form[comicid]">

<?

    $stmt = "SELECT id,dateshow,title FROM comics WHERE comictype='d' ORDER BY dateshow DESC";

    $result = mysql_query($stmt,$conn);

    while ($row = mysql_fetch_array($result)) {

        $dyr = substr($row['dateshow'],2,2);

        $ryr = substr($row['dateshow'],0,4);

        $mo = substr($row['dateshow'],5,2);

        $da = substr($row['dateshow'],8,2);

        $hr = substr($row['dateshow'],11,2);

        echo "<OPTION value=\"". $row["id"]. "\">". $mo ."/". $da ."/". $dyr ." - ". stripslashes($row['title']) ."</OPTION>\n";

    }

?>

      </select><br>

      <input type="submit" value="Edit">

     </form>

    </td>

   </tr>



<?

    if (isset($form["newcomic"])) {

        ?>

        <form method="post" action="/admin/" ENCTYPE="multipart/form-data">

         <input type="hidden" name="form[addcomic]" value="1">

         <tr><td colspan="2">&nbsp;</td></tr>

         <tr><td bgcolor="#000000" colspan="2" align="center"><font color="#FFFFFF"><B>Adding New Comic</B></font></td></tr>

         <tr valign="top">

          <td align="right">Title:</td>

          <td align="left"><input type="text" name="form[title]" size="40"></td>

         </tr>

         <tr bgcolor="#e6e6e6">

          <td align="right">Comic Image File:<br>

          <td align="left">(Already on Server)<input type="text" name="form[comicimage]"><br><font size="-1"><i>/usr/home/joseph/poundl/comics/_______</i></font><br><br>(Upload from your PC)<input type="file" name="picture"></td>

         </tr>

         <tr>

          <td>&nbsp;</td>

          <td></td>

         </tr>

         <tr><td colspan="2">&nbsp;</td></tr>

         <tr>

          <td align="right">Date and Hour to Show:</td>

          <td align="left">

           <select name="form[month]">

            <option value="01">Jan</option>

            <option value="02">Feb</option>

            <option value="03">Mar</option>

            <option value="04">Apr</option>

            <option value="05">May</option>

            <option value="06">Jun</option>

            <option value="07">Jul</option>

            <option value="08">Aug</option>

            <option value="09">Sep</option>

            <option value="10">Oct</option>

            <option value="11">Nov</option>

            <option value="12">Dec</option>

           </select>

            /

           <select name="form[day]">

            <?

                while ($i < 32) {

                    $i++;

                    echo "<option>$i</option>\n";

                }

                $i = 0;

            ?>

           </select>

            /

           <select name="form[year]">

            <option>2001</option>

            <option>2002</option>

            <option>2003</option>

           </selecT>

            :

           <select name="form[hour]">

            <?

                echo "<option>00</option>\n";

                while ($i < 23) {

                    $i++;

                    echo "<option>$i</option>\n";

                }

                $i = 0;

            ?>

           </select>

          </td>

         </tr>

         <tr><td colspan="2">&nbsp;</td></tr>

         <tr>

          <td align="right">Your Name:</td>

          <td><input type="text" name="form[who]"></td>

         </tr>

         <tr valign="top">

          <td align="right"><br>Your News Post:<br>(or just write <br>that you have <br>none for today) </td>

          <td><textarea name="form[post]" rows="6" cols="45" wrap="virtual"></textarea></td>

         </tr>

         <tr>

          <td>&nbsp;</td>

          <td><input type="submit" value="Add New Comic!"></td>

         </tr>

        </form>

        <?

    } elseif (isset($form["newtitle"])) {

        // random title tag

        ?>

            <form method="post" action="/admin/">

             <tr>

             <input type="hidden" name="form[addtopic]" value="1">

             <tr><td colspan="2">&nbsp;</td></tr>

             <tr><td bgcolor="#000000" colspan="2" align="center"><font color="#FFFFFF"><B>Adding New Random Topic</B></font></td></tr>

             <tr><td>&nbsp;</td><td><font size="-1">I suggest using format:  <u>&lt;nickname-of-who-set-topic&gt; blah blah blah</u> and don't worry about the brackets</td></tr>

             <tr valign="top">

              <td colspan="2"><input type="text" name="form[topic]" width="70" size="70" length="70"></td>

             </tr>

             <tr>

              <td>&nbsp;</td>

              <td><input type="submit" value="Add New Topic"></td>

                 </tr>

            </form>

            <tr><td colspan="2">&nbsp;</td>

        <?

        $stmt = "SELECT quote FROM randomquotes";

        $result = mysql_query($stmt,$conn);

        while ($row = mysql_fetch_array($result)) {

            echo "<tr><td>&nbsp;</td><td bgcolor=#e6e6e6>".stripslashes($row["quote"])."</td></tr>\n";

        }

    } elseif (isset($form["newsponsor"])) {

        // random sponsor 

        ?>

            <form method="post" action="/admin/">

             <tr>

             <input type="hidden" name="form[addsponsor]" value="1">

             <tr><td colspan="2">&nbsp;</td></tr>

             <tr><td bgcolor="#000000" colspan="2" align="center"><font color="#FFFFFF"><B>Adding New Sponsor Tag</B></font></td></tr>

             <tr><td>&nbsp;</td><td><font size="-1">I suggest using format:  <u>Brought to you by Whatever!</u></td></tr>

             <tr valign="top">

              <td colspan="2"><input type="text" name="form[sponsor]" width="70" size="70" length="70"></td>

             </tr>

             <tr>

              <td>&nbsp;</td>

              <td><input type="submit" value="Add New SponsorLine"></td>

                 </tr>

            </form>

            <tr><td colspan="2">&nbsp;</td>

        <?

        $stmt = "SELECT sponsor FROM sponsors";

        $result = mysql_query($stmt,$conn);

        while ($row = mysql_fetch_array($result)) {

            echo "<tr><td>&nbsp;</td><td bgcolor=#e6e6e6>".stripslashes($row["sponsor"])."</td></tr>\n";

        }

    } elseif (isset($form["comicid"])) {

// Edit A Fucking Comic.

        $stmt = "SELECT id,dateshow,comicimage,title FROM comics WHERE id = ". $form["comicid"];

        $result = mysql_query($stmt,$conn);

        $comic = mysql_fetch_array($result, MYSQL_ASSOC);

        $stmt2 = "SELECT id,who,post FROM posts WHERE id = ". $form["comicid"];

        $result2 = mysql_query($stmt2,$conn);

        $news = mysql_fetch_array($result2, MYSQL_ASSOC);

            preg_match("/^(\d{4})-(\d{2})-(\d{2})(\s)?(-)?(\d{2})?/", $comic["dateshow"], $datearray);

            $comic['year'] = $datearray[1];

            $comic['month'] = $datearray[2];

            $comic['day'] = $datearray[3];

            if ($datearray[6]) {

                $comic['hour'] = $datearray[6];

            } else {

                $comic['hour'] = 0;

            }

        ?>

        <form method="post" action="/admin/" ENCTYPE="multipart/form-data">

         <input type="hidden" name="form[saveedit]" value="1">

         <input type="hidden" name="form[id]" value="<? echo $form["comicid"]; ?>">

         <tr><td colspan="2">&nbsp;</td></tr>

         <tr><td bgcolor="#000000" colspan="2" align="center"><font color="#FFFFFF"><B>Editing Comic ID# <? echo $form["comicid"]; ?></B></font></td></tr>

         <tr valign="top">

          <td align="right">Title:</td>

          <td align="left"><input type="text" name="form[title]" value="<? echo stripslashes($comic["title"]); ?>" size="40"></td>

         </tr>

         <tr bgcolor="#e6e6e6">

          <td align="right">Comic Image File:<br>

          <td align="left">

           <? 

            if (isset($comic["comicimage"])) {

                ?>(<a href="/comics/<? echo $comic["comicimage"]; ?>">Already on Server</a>)<?

            } else {

                echo "(Already on Server)";

            }

           ?>

           <input type="text" name="form[comicimage]" value="<? echo $comic["comicimage"]; ?>">

           <br>

           <font size="-1"><i>/usr/home/joseph/poundl/comics/_______</i></font>

           <br><br>

           (Upload from your PC)

           <input type="file" name="picture">

          </td>

         </tr>

         <tr><td>&nbsp;</td><td bgcolor="#e6e6e6">please make sure erase the filename in the "already on sever" field if you upload a new image.</td></tr>

         <tr>

          <td>&nbsp;</td>

          <td></td>

         </tr>

         <tr><td colspan="2">&nbsp;</td></tr>

         <tr>

          <td align="right">Date and Hour to Show:</td>

          <td align="left">

           <select name="form[month]">

            <option value="01" <? if ($comic["month"] == 01) { echo "SELECTED"; }?>>Jan</option>

            <option value="02" <? if ($comic["month"] == 02) { echo "SELECTED"; }?>>Feb</option>

            <option value="03" <? if ($comic["month"] == 03) { echo "SELECTED"; }?>>Mar</option>

            <option value="04" <? if ($comic["month"] == 04) { echo "SELECTED"; }?>>Apr</option>

            <option value="05" <? if ($comic["month"] == 05) { echo "SELECTED"; }?>>May</option>

            <option value="06" <? if ($comic["month"] == 06) { echo "SELECTED"; }?>>Jun</option>

            <option value="07" <? if ($comic["month"] == 07) { echo "SELECTED"; }?>>Jul</option>

            <option value="08" <? if ($comic["month"] == 08) { echo "SELECTED"; }?>>Aug</option>

            <option value="09" <? if ($comic["month"] == 09) { echo "SELECTED"; }?>>Sep</option>

            <option value="10" <? if ($comic["month"] == 10) { echo "SELECTED"; }?>>Oct</option>

            <option value="11" <? if ($comic["month"] == 11) { echo "SELECTED"; }?>>Nov</option>

            <option value="12" <? if ($comic["month"] == 12) { echo "SELECTED"; }?>>Dec</option>

           </select>

            /

           <select name="form[day]">

            <?

                while ($i < 32) {

                    $i++;

                    if ($i == $comic["day"]) {

                        echo "<option SELECTED>$i</option>\n";

                    } else {

                        echo "<option>$i</option>\n";

                    }

                }

                $i = 0;

            ?>

           </select>

            /

           <select name="form[year]">

            <option <? if ($comic["year"] == 2001) { echo "SELECTED"; } ?>>2001</option>

            <option <? if ($comic["year"] == 2002) { echo "SELECTED"; } ?>>2002</option>

            <option <? if ($comic["year"] == 2003) { echo "SELECTED"; } ?>>2003</option>

           </selecT>

            :

           <select name="form[hour]">

            <?

                if ($comic["hour"] == "00") {

                    echo "<option SELECTED>00</option>\n";

                } else {

                    echo "<option>00</option>\n";

                }

                while ($i < 23) {

                    $i++;

                    if ($i == $comic["hour"]) {

                        echo "<option SELECTED>$i</option>\n";

                    } else {

                        echo "<option>$i</option>\n";

                    }

                }

                $i = 0;

            ?>

           </select>

          </td>

         </tr>

         <tr><td colspan="2">&nbsp;</td></tr>

         <tr>

          <td align="right">Your Name:</td>

          <td><input type="text" name="form[who]" value="<? echo stripslashes($news["who"]); ?>"></td>

         </tr>

         <tr valign="top">

          <td align="right"><br>Your News Post:<br>(or just write <br>that you have <br>none for today) </td>

          <td><textarea name="form[post]" rows="6" cols="45" wrap="virtual"><? echo stripslashes($news["post"]); ?></textarea></td>

         </tr>

         <tr>

          <td>&nbsp;</td>

          <td><input type="submit" value="Update Comic #<? echo $form["comicid"]; ?>!"></td>

         </tr>

        </form>

        <?

    



    } else {

        ?>

           <tr>

            <td colspan="2" bgcolor="#e6e6e6">

             <form method="post" action="/admin/">

              <center>

               Click here to add a new Comic:

               <input type="hidden" name="form[newcomic]" value="1">

               <input type="submit" value="New Comic">

              </center>

             </form>

            </td>

           </tr>

           <tr><td colspan="2">&nbsp;</td></tr>

           <tr>

            <td colspan="2" bgcolor="#e6e6e6">

             <form method="post" action="/admin/">

              <center>

               Click here to add a new &lt;title&gt;:

               <input type="hidden" name="form[newtitle]" value="1">

               <input type="submit" value="New Title Tag">

              </center>

             </form>

            </td>

           </tr>

           <tr><td colspan="2">&nbsp;</td></tr>

           <tr>

            <td colspan="2" bgcolor="#e6e6e6">

             <form method="post" action="/admin/">

              <center>

               Click here to add a new Sponsor:

               <input type="hidden" name="form[newsponsor]" value="1">

               <input type="submit" value="New Sponsor Line">

              </center>

             </form>

            </td>

           </tr>

        <?

    }

?>





  </table>

  </center>

 </body>

</html>