oldscript.php

<?php
 /* #####################################################################
 * 
 * 	This code was made possible by the following people:
 * -Cal Henderson (http://www.iamcal.com)
 * -Travis "TeamColtra" McCrea (http://www.travismccrea.com)
 * -Club Ubuntu Team (http://www.club-ubuntu.org) #Club-Ubuntu Freenode
 * 
 * While part of the terms we do not REQUIRE you to keep attribution
 * we wouldn't mind it. :) 
 * 
 * Speaking of Licences:
 *   This file is part of Choose Your Own Adventure (Paradox Edition)
 *
 *  Choose 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 3 of the License, or
 *  (at your option) any later version.
 *
 *   Choose is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  inside the file "LICENCE".
 * ###################################################################*/
    $db = mysql_connect("**********", "**********", "**********"); 
    mysql_select_db("**********",$db); 

    if ($email){ 
        setcookie('email_cookie',$email,time()+(60*60*24*365)); 
    } 

    include('header.txt'); 

    $rooms = mysql_num_rows(mysql_query("SELECT * FROM choose_rooms",$db)); 
    $insert = "<b>Rooms:</b> $rooms"; 

    function getRoomDepth($room){ 
        global $db; 
        if ($room==1){return 1;} 
        $data = mysql_fetch_array(mysql_query("SELECT * FROM choose_rooms WHERE room_1=$room OR room_2=$room",$db)); 
        return 1+getRoomDepth($data[id]); 
    } 

    if ($addroom){ 
        mysql_query("INSERT INTO choose_rooms (email,blurb,text_1,room_1,text_2,room_2,end_here,ip) VALUES ('$email','$blurb','$choice1',0,'$choice2',0,'$end_here','$REMOTE_ADDR')",$db); 
        $id = mysql_insert_id(); 
        mysql_query("UPDATE choose_rooms SET room_$opt=$id WHERE id=$from",$db); 
        print "Your room has been added. <a href=\"room.php\">Click here</a> to start again."; 
        include('footer.txt'); 
        exit; 
    } 

    if ($room == '0'){ 
        $fromrow = mysql_fetch_array(mysql_query("SELECT * FROM choose_rooms WHERE id=$from",$db)); 
        $depth = getRoomDepth($from); 
        print "<!-- $depth -->"; 
        print "Now it's time for you to create your own adventure :)<br><br>"; 
        print "What happens when someone chooses &quot;".$fromrow["text_$opt"]."&quot;?<br>"; 
        print "<form method=\"post\">"; 
        print "<input type=\"hidden\" name=\"addroom\" value=\"1\">"; 
        print "<input type=\"hidden\" name=\"from\" value=\"$from\">"; 
        print "<input type=\"hidden\" name=\"opt\" value=\"$opt\">"; 
        print "your email: (it wont be shown on the site)<br><input type=\"text\" name=\"email\" size=\"50\" value=\"$email_cookie\"><br><br>"; 
        print "blurb:<br><textarea name=\"blurb\" cols=\"50\" rows=\"10\"></textarea><br><br>"; 
        if ($depth>9){ 
            print "<select name=\"end_here\"><option value=\"0\">The adventure continues...</option><option value=\"1\">The adventure ends here</option></select><br><br>"; 
        }else{ 
            print "<input type=\"hidden\" name=\"end_here\" value=\"0\">"; 
        } 
        print "choice 1:<br><input type=\"text\" name=\"choice1\" size=\"50\"><br><br>"; 
        print "choice 2:<br><input type=\"text\" name=\"choice2\" size=\"50\"><br><br>"; 
        print "<input type=\"submit\" value=\"Add My Room!\">"; 
        include('footer.txt'); 
        exit; 
    } 

    $room = ($room != '')?$room:1; 

    $data = mysql_fetch_array(mysql_query("SELECT * FROM choose_rooms WHERE id='$room'",$db)); 

    if (!$data[id]){ 
        print "error: room $room not found"; 
        include('footer.txt'); 
        exit; 
    } 

    $depth = getRoomDepth($room); 

    $data = mysql_fetch_array(mysql_query("SELECT * FROM choose_rooms WHERE id=$room",$db)); 

    if ($data[end_here]){ 
        print nl2br(htmlentities(chop($data[blurb]))); 
        print "<br><br><b>It's all over.</b> Why not <a href=\"room.php\">start again</a>."; 
    }else{ 
        print nl2br(htmlentities(chop($data[blurb]))); 
        print "<br><br><b>Choose:</b> "; 
        print "<a href=\"room.php?room=$data[room_1]&from=$room&opt=1\">".htmlentities($data[text_1])."</a>"; 
        print " or "; 
        print "<a href=\"room.php?room=$data[room_2]&from=$room&opt=2\">".htmlentities($data[text_2])."</a>"; 
    } 
    print "<br><br><br><br>Something wrong with this entry? Bad spelling/grammar? Too offensive? Then <a href=\"mailto:choose@iamcal.com?subject=entry $data[id]\">tell me</a>."; 

    include('footer.txt'); 

?>