Esempio n. 1
0
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
For information about Extend-A-Story and its authors, please visit the website:
http://www.sir-toby.com/extend-a-story/
*/
require __DIR__ . "/include/Extend-A-Story.php";
use Extend_A_Story\HardStoryException;
use Extend_A_Story\Util;
Util::getSessionAndUserIDs($sessionID, $userID);
$storyName = Util::getStringValue("StoryName");
$siteName = Util::getStringValue("SiteName");
$storyHome = Util::getStringValue("StoryHome");
$siteHome = Util::getStringValue("SiteHome");
$method = Util::getStringParam($_POST, "method");
$text = Util::getStringParamDefault($_POST, "text", "");
$days = Util::getIntParamDefault($_POST, "days", 0);
$text = "%" . $text . "%";
$dbStatement;
$queryPart1 = "SELECT EpisodeID, " . "Title, " . "AuthorName " . "FROM Episode " . "WHERE ";
$queryPart2 = "AND ( Status = 2 OR Status = 3 ) " . "ORDER BY EpisodeID";
if ($method == "title") {
    $dbStatement = Util::getDbConnection()->prepare($queryPart1 . "Title LIKE :text " . $queryPart2);
    $dbStatement->bindParam(":text", $text, PDO::PARAM_STR);
} else {
    if ($method == "text") {
        $dbStatement = Util::getDbConnection()->prepare($queryPart1 . "Text LIKE :text " . $queryPart2);
        $dbStatement->bindParam(":text", $text, PDO::PARAM_STR);
    } else {
        if ($method == "author") {
            $dbStatement = Util::getDbConnection()->prepare($queryPart1 . "AuthorName LIKE :text " . $queryPart2);
            $dbStatement->bindParam(":text", $text, PDO::PARAM_STR);
Esempio n. 2
0
    }
} else {
    $linkCount = $maxLinks;
    for ($i = 0; $i < $linkCount; $i++) {
        $var1 = "linkID" . $i;
        $var2 = "targetEpisodeID" . $i;
        $var3 = "isBackLink" . $i;
        $var4 = "option" . $i;
        $var5 = "backlink" . $i;
        ${$var1} = 0;
        ${$var2} = 0;
        ${$var3} = "N";
        ${$var4} = "";
        ${$var5} = 0;
        ${$var4} = Util::getStringParamDefault($_POST, $var4, "");
        ${$var5} = Util::getIntParamDefault($_POST, $var5, 0);
    }
}
for ($i = 0; $i < $linkCount; $i++) {
    $var1 = "option" . $i;
    $var2 = "backlink" . $i;
    $var3 = "isBackLink" . $i;
    if (!empty(${$var1})) {
        $linkFound = true;
    }
    if ($editing && empty(${$var1})) {
        $warning .= "You must provide a description for option " . ($i + 1) . ".<BR>";
    }
    if (strlen(${$var1}) > 255) {
        $warning .= "The description for option " . ($i + 1) . " cannot be longer then 255 characters.<BR>";
    }
Esempio n. 3
0
    $orphans = $dbStatement->fetchAll(PDO::FETCH_NUM);
}
if ($command == "listDeadEnds") {
    $dbStatement = Util::getDbConnection()->prepare("SELECT Episode.EpisodeID " . "FROM Link " . "RIGHT OUTER JOIN Episode " . "ON Link.SourceEpisodeID = Episode.EpisodeID " . "WHERE Link.LinkID IS NULL " . "AND ( Episode.Status = 2 OR Episode.Status = 3 ) " . "ORDER BY Episode.EpisodeID");
    $dbStatement->execute();
    $deadEnds = $dbStatement->fetchAll(PDO::FETCH_NUM);
}
if ($command == "listRecentEdits") {
    $dbStatement = Util::getDbConnection()->prepare("SELECT MAX( EpisodeEditLogID ) FROM EpisodeEditLog");
    $dbStatement->execute();
    $row = $dbStatement->fetch(PDO::FETCH_NUM);
    if (!$row) {
        throw new HardStoryException("Unable to fetch the max EpisodeEditLogID record from database.");
    }
    $maxEpisodeEditLogID = (int) $row[0];
    $start = Util::getIntParamDefault($_GET, "start", 0);
    if ($start < 1 || $start > $maxEpisodeEditLogID) {
        $start = $maxEpisodeEditLogID;
    }
    $dbStatement = Util::getDbConnection()->prepare("SELECT EpisodeEditLogID, " . "EpisodeID, " . "EditDate, " . "EditLogEntry " . "FROM EpisodeEditLog " . "WHERE EpisodeEditLogID <= :start " . "ORDER BY EpisodeEditLogID DESC " . "LIMIT 20");
    $dbStatement->bindParam(":start", $start, PDO::PARAM_INT);
    $dbStatement->execute();
    $edits = $dbStatement->fetchAll(PDO::FETCH_NUM);
}
$dbStatement = Util::getDbConnection()->prepare("SELECT UserID, " . "LoginName " . "FROM User " . "ORDER BY LoginName");
$dbStatement->execute();
$users = $dbStatement->fetchAll(PDO::FETCH_NUM);
if ($command == "listOrphans") {
    ?>

<HTML><HEAD>
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
For information about Extend-A-Story and its authors, please visit the website:
http://www.sir-toby.com/extend-a-story/
*/
require __DIR__ . "/include/Extend-A-Story.php";
use Extend_A_Story\HardStoryException;
use Extend_A_Story\Util;
Util::getSessionAndUserIDs($sessionID, $userID);
$storyName = Util::getStringValue("StoryName");
$siteName = Util::getStringValue("SiteName");
$storyHome = Util::getStringValue("StoryHome");
$siteHome = Util::getStringValue("SiteHome");
$episode = Util::getIntParamDefault($_GET, "episode", 1);
?>

<HTML><HEAD>
<TITLE><?php 
echo $storyName;
?>
: Story Tree</TITLE>
</HEAD><BODY>

<CENTER>
<H1><?php 
echo $storyName;
?>
: Story Tree</H1>
<H2>
Esempio n. 5
0
    $lockDate = date("n/j/Y g:i:s A");
    $dbStatement = Util::getDbConnection()->prepare("UPDATE Episode " . "SET EditorSessionID = :sessionID, " . "LockDate        = :lockDate " . "WHERE EpisodeID = :episode");
    $dbStatement->bindParam(":sessionID", $sessionID, PDO::PARAM_INT);
    $dbStatement->bindParam(":lockDate", $lockDate, PDO::PARAM_STR);
    $dbStatement->bindParam(":episode", $episode, PDO::PARAM_INT);
    $dbStatement->execute();
    if ($dbStatement->rowCount() != 1) {
        throw new HardStoryException("Unable to update the lock on the episode.");
    }
}
$message = "";
$linkDescription = "";
$linkEpisode = 0;
if ($command == "AddLinkSave") {
    $linkDescription = Util::getStringParam($_POST, "description");
    $linkEpisode = Util::getIntParamDefault($_POST, "linkedEpisode", 0);
    if (empty($linkDescription)) {
        $message .= "You must enter the link description.<BR>";
    }
    if (strlen($linkDescription) > 255) {
        $message .= "The link description cannot be longer then 255 characters.<BR>";
    }
    if (Util::maximumWordLength($linkDescription) > 30) {
        $message .= "The link description cannot contain a word with more than 30 characters.<BR>";
    }
    if ($linkEpisode != 0) {
        if ($linkEpisode == $episode) {
            $message .= "The link cannot link back to the same episode you are editing.<BR>";
        }
        $dbStatement = Util::getDbConnection()->prepare("SELECT COUNT( * ) " . "FROM Link " . "WHERE SourceEpisodeID = :episode " . "AND TargetEpisodeID = :linkEpisode");
        $dbStatement->bindParam(":episode", $episode, PDO::PARAM_INT);
Esempio n. 6
0
 public static function getSessionAndUserIDs(&$sessionID, &$userID)
 {
     // log out all users after one hour of inactivity
     $dbStatement = Util::getDbConnection()->prepare("UPDATE Session " . "SET UserID = 0 " . "WHERE AccessDate < SUBDATE( NOW(), INTERVAL 1 HOUR )");
     $dbStatement->execute();
     $originalSessionID = Util::getIntParamDefault($_COOKIE, "sessionID", 0);
     $originalSessionKey = Util::getIntParamDefault($_COOKIE, "sessionKey", 0);
     $actualSessionID = 0;
     $actualUserID = 0;
     $actualSessionKey = 0;
     $dbStatement = Util::getDbConnection()->prepare("SELECT UserID, " . "SessionKey " . "FROM Session " . "WHERE SessionID = :originalSessionID");
     $dbStatement->bindParam(":originalSessionID", $originalSessionID, PDO::PARAM_INT);
     $dbStatement->execute();
     $row = $dbStatement->fetch(PDO::FETCH_NUM);
     if ($row) {
         if ($row[1] == $originalSessionKey) {
             $actualSessionID = $originalSessionID;
             $actualUserID = $row[0];
             $actualSessionKey = $originalSessionKey;
             $dbStatement = Util::getDbConnection()->prepare("UPDATE Session " . "SET AccessDate = NOW() " . "WHERE SessionID = :originalSessionID");
             $dbStatement->bindParam(":originalSessionID", $originalSessionID, PDO::PARAM_INT);
             $dbStatement->execute();
             if ($dbStatement->rowCount() != 1) {
                 throw new HardStoryException("Unable to update your session.");
             }
         }
     }
     if ($actualSessionID == 0) {
         // generate random session key
         $newSessionKey = mt_rand();
         // insert the session into the database
         $dbStatement = Util::getDbConnection()->prepare("INSERT " . "INTO Session " . "( " . "UserID, " . "SessionKey, " . "AccessDate " . ") " . "VALUES " . "( " . "0, " . ":newSessionKey, " . "NOW() " . ")");
         $dbStatement->bindParam(":newSessionKey", $newSessionKey, PDO::PARAM_INT);
         $dbStatement->execute();
         $actualSessionID = Util::getLastInsertId();
         $actualSessionKey = $newSessionKey;
     }
     setcookie("sessionID", $actualSessionID, time() + 60 * 60 * 24 * 370);
     setcookie("sessionKey", $actualSessionKey, time() + 60 * 60 * 24 * 370);
     // delete all sessions over 370 days old
     $dbStatement = Util::getDbConnection()->prepare("DELETE " . "FROM Session " . "WHERE AccessDate < SUBDATE( NOW(), INTERVAL 370 DAY )");
     $dbStatement->execute();
     $sessionID = $actualSessionID;
     $userID = $actualUserID;
 }
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
For information about Extend-A-Story and its authors, please visit the website:
http://www.sir-toby.com/extend-a-story/
*/
require __DIR__ . "/include/Extend-A-Story.php";
use Extend_A_Story\HardStoryException;
use Extend_A_Story\Util;
Util::getSessionAndUserIDs($sessionID, $userID);
$storyName = Util::getStringValue("StoryName");
$siteName = Util::getStringValue("SiteName");
$storyHome = Util::getStringValue("StoryHome");
$siteHome = Util::getStringValue("SiteHome");
$scheme = Util::getIntParamDefault($_POST, "scheme", null);
if (!isset($scheme)) {
    $dbStatement = Util::getDbConnection()->prepare("SELECT SchemeID FROM Scheme ORDER BY SchemeID");
    $dbStatement->execute();
    $row = $dbStatement->fetch(PDO::FETCH_NUM);
    if (!$row) {
        throw new HardStoryException("Unable to fetch the lowest scheme ID.");
    }
    $scheme = $row[0];
}
$dbStatement = Util::getDbConnection()->prepare("SELECT SchemeName, " . "bgcolor, " . "text, " . "link, " . "vlink, " . "alink, " . "background, " . "UncreatedLink, " . "CreatedLink, " . "BackLinkedLink " . "FROM Scheme " . "WHERE SchemeID = :scheme");
$dbStatement->bindParam(":scheme", $scheme, PDO::PARAM_INT);
$dbStatement->execute();
$row = $dbStatement->fetch(PDO::FETCH_NUM);
if (!$row) {
    throw new HardStoryException("Problem fetching scheme row from the database.");