$val) { $val = is_array( $val ) ? array_map( 'stripslashes', $val ) : stripslashes( $val ); } foreach($_GET as $var => $val) { $val = is_array( $val ) ? array_map( 'stripslashes', $val ) : stripslashes( $val ); } foreach($_COOKIE as $var => $val) { $val = is_array( $val ) ? array_map( 'stripslashes', $val ) : stripslashes( $val ); } } Header('Cache-Control: private, no-cache, must-revalidate, max_age=0, post-check=0, pre-check=0'); header ("Pragma: no-cache"); header ("Expires: 0"); //make a new TemplatePower object echo " eFiction 1.1 to $version Upgrade "; $output = ""; define("_BASEDIR", "../"); include ("../includes/class.TemplatePower.inc.php"); if(isset($_GET['step']) && $_GET['step'] > 2) { include("../config.php"); $settings = dbquery("SELECT tableprefix, language FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix, $language) = dbrow($settings); define("SITEKEY", $sitekey); define("TABLEPREFIX", $tableprefix); } if(isset($language)) { if(file_exists("../languages/{$language}.php")) include ("../languages/{$language}.php"); else include ("../languages/en.php"); if(file_exists("../languages/{$language}_admin.php")) include ("../languages/{$language}_admin.php"); else include ("../languages/en_admin.php"); if(file_exists("languages/$language.php")) include ("languages/{$language}.php"); else include("languages/en.php"); } else { include ("../languages/en.php"); include ("../languages/en_admin.php"); include("languages/en.php"); } include("../includes/corefunctions.php"); // So I don't have to keep updating the version number in 3 different files. include("../version.php"); $tpl = new TemplatePower( "../default_tpls/default.tpl" ); $tpl->assignInclude( "header", "./../default_tpls/header.tpl" ); $tpl->assignInclude( "footer", "./../default_tpls/footer.tpl" ); $tpl->prepare( ); $tpl->newBlock("header"); $tpl->assign("sitename", "Upgrade eFiction 1.1 to eFiction $version"); $tpl->gotoBlock( "_ROOT" ); $tpl->newBlock("footer"); $tpl->assign( "footer", "eFiction $version © 2006. http://efiction.org/"); $tpl->gotoBlock( "_ROOT" ); switch($_GET['step']) { case "18": $output .= "
"._MISCDBUPDATE."
"; if(isset($_GET['install'])) { if($_GET['install'] == "automatic") { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $alter1 = dbquery("ALTER TABLE `".$tableprefix."fanfiction_characters` ADD `bio` TEXT NULL, ADD `image` VARCHAR( 200 ) NOT NULL"); $output .= write_message(_ALTER11CHARACTERS.($alter1 ? "" : "")); $alter1 = dbquery("ALTER TABLE `".$tableprefix."fanfiction_categories` CHANGE `locked` `locked` CHAR( 1 ) DEFAULT '0' NOT NULL"); $output .= write_message(_ALTER11CATEGORIES.($alter1 ? "" : "")); $alter1 = dbquery("ALTER TABLE `".$tableprefix."fanfiction_ratings` CHANGE `ratingwarning` `ratingwarning` CHAR( 1 ) DEFAULT '0' NOT NULL "); $output .= write_message(_ALTER11RATINGS.($alter1 ? "" : "")); $alter1 = dbquery("DROP TABLE IF EXISTS `".$tableprefix."fanfiction_settings_old`"); dbquery("alter table ".$tableprefix."fanfiction_categories drop index category;"); dbquery("alter table ".$tableprefix."fanfiction_categories drop index parentcatid;"); dbquery("create index byparent on ".$tableprefix."fanfiction_categories (parentcatid,displayorder);"); dbquery("create index forstoryblock on ".$tableprefix."fanfiction_chapters (sid,validated);"); dbquery("alter table ".$tableprefix."fanfiction_comments drop index nid;"); dbquery("alter table ".$tableprefix."fanfiction_comments add index commentlist (nid,time);"); dbquery("create index avgrating on ".$tableprefix."fanfiction_reviews(type,item,rating);"); dbquery("alter table ".$tableprefix."fanfiction_reviews drop index sid;"); dbquery("create index bychapter on ".$tableprefix."fanfiction_reviews (chapid,rating);"); dbquery("alter table ".$tableprefix."fanfiction_reviews add index byuid (uid,item,type);"); dbquery("alter table ".$tableprefix."fanfiction_stories drop index validated;"); dbquery("create index validateduid on ".$tableprefix."fanfiction_stories (validated,uid);"); dbquery("create index recent on ".$tableprefix."fanfiction_stories (updated,validated);"); $serieslist = dbquery("SELECT seriesid FROM ".$tableprefix."fanfiction_series"); $totalseries = dbnumrows($serieslist); while($s = dbassoc($serieslist)) { $numstories = count(storiesInSeries($s['seriesid'])); dbquery("UPDATE ".$tableprefix."fanfiction_series SET numstories = '$numstories' WHERE seriesid = ".$s['seriesid']." LIMIT 1"); } $storiesquery =dbquery("SELECT COUNT(sid) as totals, COUNT(DISTINCT uid) as totala, SUM(wordcount) as totalwords FROM ".$tableprefix."fanfiction_stories WHERE validated > 0 "); list($stories, $authors, $words) = dbrow($storiesquery); dbquery("UPDATE ".$tableprefix."fanfiction_stats SET stories = '$stories', authors = '$authors', wordcount = '$words' WHERE sitekey = '".$sitekey."'"); $chapterquery = dbquery("SELECT COUNT(chapid) as chapters FROM ".$tableprefix."fanfiction_chapters where validated > 0"); list($chapters) = dbrow($chapterquery); $authorquery = dbquery("SELECT COUNT(uid) as totalm FROM ".$tableprefix."fanfiction_authors"); list($members) = dbrow($authorquery); list($newest) = dbrow(dbquery("SELECT uid as uid FROM ".$tableprefix."fanfiction_authors ORDER BY uid DESC LIMIT 1")); $reviewquery = dbquery("SELECT COUNT(reviewid) as totalr FROM ".$tableprefix."fanfiction_reviews WHERE review != 'No Review'"); list($reviews) = dbrow($reviewquery); $reviewquery = dbquery("SELECT COUNT(uid) FROM ".$tableprefix."fanfiction_reviews WHERE review != 'No Review' AND uid != 0"); list($reviewers) = dbrow($reviewquery); dbquery("UPDATE ".$tableprefix."fanfiction_stats SET series = '$totalseries', chapters = '$chapters', members = '$members', newestmember = '$newest', reviews = '$reviews', reviewers = '$reviewers' WHERE sitekey = '".$sitekey."'"); $alltables = dbquery("SHOW TABLES"); while ($table = dbassoc($alltables)) { foreach ($table as $db => $tablename) { dbquery("OPTIMIZE TABLE `".$tablename."`"); } } $output .= write_message(_UPGRADE11END); } else $output .= write_message(_MISCDBUPDATEMANUAL._UPGRADE11END); } else $output .= write_message(_MISCDBUPDATEINFO."

"._AUTO." "._OR." "._MANUAL2.""); break; case "17": $output .= "
"._NEWSUPDATE."
"; if(isset($_GET['install'])) { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); dbquery("ALTER TABLE `".$tableprefix."fanfiction_news` ADD `comments` INT NOT NULL DEFAULT '0'"); $newslist = dbquery("SELECT count(cid) as count, nid FROM ".$tableprefix."fanfiction_comments GROUP BY nid"); while($n = dbassoc($newslist)) { dbquery("UPDATE ".$tableprefix."fanfiction_news SET comments = '".$n['count']."' WHERE nid = ".$n['nid']); } $comments = dbquery("SELECT uname FROM ".$tableprefix."fanfiction_comments GROUP BY uname"); while($uname = dbassoc($comments)) { unset($uid); $nameinfo = dbquery("SELECT uid FROM ".$tableprefix."fanfiction_authors WHERE penname = '".$uname['uname']."'"); list($uid) = dbrow($nameinfo); if(empty($uid)) $uid = 0; dbquery("UPDATE ".$tableprefix."fanfiction_comments SET uname = '$uid' WHERE uname = '".$uname['uname']."'"); } $result2 = dbquery("ALTER TABLE `".$tableprefix."fanfiction_comments` CHANGE `uname` `uid` INT NOT NULL DEFAULT '0';"); $output .= write_message(_NEWSUPDATERESULT.($result2 ? "" : "")); $output .= write_message(""._CONTINUE.""); } else $output .= write_message(_NEWSUPDATEINFO."
"._CONTINUE.""); break; case "16": $output .= "
"._AUTHORUPDATE."
"; if(isset($_GET['install'])) { include("../config.php"); define("_BASEDIR", "../"); $settings = dbquery("SELECT tableprefix, defaultsort, displayindex, tinyMCE, storiespath FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($defaultsort, $displayindex, $tinyMCE, $storiespath) = dbrow($settings); $result = dbquery("INSERT INTO ".$tableprefix."fanfiction_authorprefs(`uid`, `newreviews`, `validated`, `userskin`, `level`, `categories`, `contact`) SELECT uid, newreviews, validated, userskin, level, categories, contact FROM ".$tableprefix."fanfiction_authors"); $result2 = dbquery("UPDATE ".$tableprefix."fanfiction_authorprefs set sortby = '$defaultsort', storyindex = '$displayindex', tinyMCE = '$tinyMCE'"); $authors = dbquery("SELECT author.penname, author.uid, count(stories.uid) as count FROM ".$tableprefix."fanfiction_authors as author, ".$tableprefix."fanfiction_stories as stories WHERE author.uid = stories.uid GROUP BY stories.uid"); while($author = dbassoc($authors)) { if( file_exists( _BASEDIR.STORIESPATH."/$author[penname]/") ) { $moved = rename(_BASEDIR.STORIESPATH."/$author[penname]/", _BASEDIR.STORIESPATH."/$author[uid]/"); $output .= $author['penname'].($moved ? "" : "")."
"; } } $output .= write_message(_AUTHORRESULT.($result ? "" : "")); $fields = dbquery("SELECT * FROM ".$tableprefix."fanfiction_authorfields WHERE field_on = 1"); while($f = dbassoc($fields)) { $col = dbquery("SHOW COLUMNS FROM ".$tableprefix."fanfiction_authors LIKE '".$f['field_name']."'"); if(dbnumrows($col) > 0) { $result = dbquery("INSERT INTO ".$tableprefix."fanfiction_authorinfo(`uid`, `info`) SELECT uid, ".$f['field_name']." FROM ".$tableprefix."fanfiction_authors WHERE ".$f['field_name']." IS NOT NULL AND ".$f['field_name']." != ''"); $result2 = dbquery("UPDATE ".$tableprefix."fanfiction_authorinfo SET field = ".$f['field_id']." WHERE field = 0"); } } $result2 = dbquery("ALTER TABLE `".$tableprefix."fanfiction_authors` DROP `validated`, DROP `userskin`, DROP `level`, DROP `contact`, DROP `categories`, DROP `carry`, CHANGE `admincreated` `admincreated` CHAR( 1 ) DEFAULT '0' NOT NULL;"); $output .= write_message(_AUTHORDROPRESULT.($result2 ? "" : "")); $output .= write_message(""._CONTINUE.""); } else $output .= write_message(_AUTHORUPDATEINFO."
"._CONTINUE.""); break; case "15": $output .= "
"._AUTHORFIELDS."
"; include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); if(isset($_GET['install'])) { if($_GET['install'] == "automatic") { $fields[] = array('4','lj','Live Journal','http://{info}.livejournal.com','','','0'); $fields[] = array('1','website','Web Site','','','','1'); $fields[] = array('5','AOL','AIM','','$output .= "
";','$thisfield = " ".format_email($field[\'info\'])."";','1'); $fields[] = array('5','ICQ','ICQ','','$output .= "
";','$thisfield = " ".$field[\'info\'];','1'); $fields[] = array('5','MSN','MSN IM','','$output .= "
";','$thisfield = "\""._MSN."\" ".format_email($field[\'info\']);','1'); $fields[] = array('5','Yahoo','Yahoo IM','','$output .= "
";','$thisfield = " ".format_email($field[\'info\'])."";','1'); $fields[] = array('4','da','Deviant Art','http://{info}.deviantart.com','','','0'); $fields[] = array('3','betareader','Beta-reader','','','','1'); $fields[] = array('4','dj','DeadJournal','http://{info}.deadjournal.com/','','','0'); $fields[] = array('4','xanga','Xanga','http://www.xanga.com/{info}','','','0'); $fields[] = array('2', 'gender', 'Gender', 'male|#|female|#|undisclosed', '', '', '0'); $fields[] = array('4','myspace','MySpace','http://www.myspace.com/{info}','','','0'); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $output .= ""; foreach($fields as $field) { $f = dbquery("INSERT INTO `".$tableprefix."fanfiction_authorfields` (`field_type`, `field_name`, `field_title`, `field_options`, `field_code_in`, `field_code_out`, `field_on`) VALUES('".$field[0]."', '".$field[1]."','".$field[2]."','".escapestring($field[3])."','".escapestring($field[4])."','".escapestring($field[5])."','".$field[6]."');"); $output .= ""; } $output .= "
"._FIELD.""._RESULT."
".$field[2]."" . ($f ? "" : "") ."
"; $output .= write_message(_FIELDAUTOFAIL." "._FIELDUPDATE."

"._CONTINUE.""); } else { $output .= write_message(_FIELDMANUAL," "._FIELDUPDATE."

"._CONTINUE.""); } } else $output .= write_message(_FIELDDATAINFO."

"._AUTO." "._OR." "._MANUAL2.""); break; case "14": $output .= "
"._UPDATECATORDER."
"; if(isset($_GET['install'])) { if($_GET['install'] == "automatic") { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $selectA = "SELECT category, catid FROM ".$tableprefix."fanfiction_categories ORDER BY leveldown, displayorder"; $resultA = dbquery($selectA); $countA = 1; while($cat = dbassoc($resultA)) { $count = 1; if($cat[parentcatid] = -1) { dbquery("UPDATE ".$tableprefix."fanfiction_categories SET displayorder = $countA WHERE catid = $cat[catid]"); $countA++; } $selectB = "SELECT category, catid FROM ".$tableprefix."fanfiction_categories WHERE parentcatid = '$cat[catid]' ORDER BY displayorder"; $resultB = dbquery($selectB) or die(_FATALERROR."Query: ".$selectB."
Error: (".mysql_errno( ).") ".mysql_error( )); while($sub = dbassoc($resultB)) { dbquery("UPDATE ".$tableprefix."fanfiction_categories SET displayorder = $count WHERE catid = $sub[catid]"); $count++; } } $output .= write_message(_ACTIONSUCCESSFUL."
"._CONTINUE.""); } } else { include("../config.php"); $output .= write_message(_UPDATECATORDERINFO."

"._CONTINUE.""); } break; case "13": $output .= "
"._FAVUPDATE."
"; if(isset($_GET['install'])) { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $favst = dbquery("INSERT INTO ".$tableprefix."fanfiction_favorites(uid, item, type) SELECT uid, sid, 'ST' FROM ".$tableprefix."fanfiction_favstor"); $output .= write_message(_FAV1.($favst ? "" : "")); $favau = dbquery("INSERT INTO ".$tableprefix."fanfiction_favorites(uid, item, type) SELECT uid, favuid, 'AU' FROM ".$tableprefix."fanfiction_favauth"); $output .= write_message(_FAV3.($favau ? "" : "")); $drop1 = dbquery("DROP TABLE `".$tableprefix."fanfiction_favstor`"); $output .= write_message(_FAV4.($drop1 ? "" : "")); $drop3 = dbquery("DROP TABLE `".$tableprefix."fanfiction_favauth`"); $output .= write_message(_FAV6.($drop3 ? "" : "")); $output .= write_message(""._CONTINUE.""); } else $output .= write_message(_FAVUPDATEINFO11."
"._CONTINUE.""); break; case "12": $output .= "
"._UPDATESTORIES11."
"; if(isset($_GET['install'])) { if($_GET['install'] == "automatic") { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $characters = dbquery("SELECT charid, charname FROM ".$tableprefix."fanfiction_characters"); while($char = dbassoc($characters)) { $character[stripslashes($char[charname])] = $char[charid]; } $ratlist = dbquery("SELECT * FROM ".$tableprefix."fanfiction_ratings"); while($rate = dbassoc($ratlist)) { $ratingslist[$rate['rating']] = $rate['rid']; } $classresults = dbquery("SELECT * FROM ".$tableprefix."fanfiction_classes"); while($class = dbassoc($classresults)) { $classlist[$class['class_name']] = array("id" => $class['class_id'], "type" => $class['class_type'], "name" => $class['class_name']); } $offset = isset($_GET['offset']) ? $_GET['offset'] : 0; $stories = dbquery("SELECT s.*, AVG( re.rating ) AS rating, count( re.rating ) AS reviews FROM ".$tableprefix."fanfiction_stories AS s LEFT JOIN ".$tableprefix."fanfiction_reviews AS re ON s.sid = re.chapid GROUP BY s.sid LIMIT $offset, 200"); while($chapter = dbassoc($stories)) { dbquery("INSERT INTO ".$tableprefix."fanfiction_chapters(`chapid` , `title` , `inorder` , `storytext` , `validated` , `wordcount` , `rating` , `reviews` , `sid` , `uid` ) VALUES('$chapter[sid]', '".addslashes($chapter[chapter])."', '".($chapter[inorder] + 1)."', '".addslashes($chapter[storytext])."', '$chapter[validated]', '$chapter[wordcount]', '".(empty($chapter[rating]) ? "0" : $chapter[rating])."', '$chapter[reviews]', '$chapter[psid]', '$chapter[uid]')"); if($chapter['sid'] == $chapter['psid']) { unset($genres, $warnings, $g, $w, $classes, $characters, $c, $clist, $rid); $characters = explode(",", $chapter['charid']); foreach($characters as $c) { $clist[] = $character[$c]; } $genres = explode(",", $chapter['gid']); foreach($genres as $g) { if($g && $g != " " && $classlist[$g]['type'] == 1) $classes[] = $classlist[$g]['id']; } $warnings = explode(",", $chapter['wid']); foreach($warnings as $w) { if($w && $w != " " && $classlist[$w]['type'] == 2) $classes[] = $classlist[$w]['id']; } $rid = $ratingslist[$chapter['rid']]; dbquery("UPDATE ".$tableprefix."fanfiction_stories SET rid = '$rid', classes = '".($classes ? implode(",", $classes) : "")."', charid = '".($clist ? implode(",", $clist) : "")."' WHERE sid = '$chapter[sid]'"); } } if(dbnumrows($stories)) $output .= write_message(_STORIES." ".($offset + 1)."-".($offset + dbnumrows($stories)).".
"._CONTINUE.""); else { dbquery("DELETE FROM ".$tableprefix."fanfiction_stories WHERE sid != psid"); dbquery("ALTER TABLE `".$tableprefix."fanfiction_stories` CHANGE `featured` `featured` CHAR( 1 ) DEFAULT '0' NOT NULL , CHANGE `validated` `validated` CHAR( 1 ) DEFAULT '0' NOT NULL , CHANGE `rr` `rr` CHAR( 1 ) DEFAULT '0' NOT NULL, DROP `chapter`, DROP `inorder`, DROP `storytext`, DROP `psid`, DROP `gid`, DROP `wid`, CHANGE `catid` `catid` VARCHAR( 100 ) DEFAULT '0' NOT NULL, ADD `rating` TINYINT( 4 ) NOT NULL"); $stories = dbquery("SELECT AVG(rating) as average, item FROM ".TABLEPREFIX."fanfiction_reviews WHERE type = 'ST' AND rating != '-1' GROUP BY item"); while($s = dbassoc($stories)) { dbquery("UPDATE ".TABLEPREFIX."fanfiction_stories SET rating = '".round($s['average'])."' WHERE sid = '".$s['item']."'"); } $stories = dbquery("SELECT COUNT(reviewid) as count, item FROM ".TABLEPREFIX."fanfiction_reviews WHERE type = 'ST' AND review != 'No Review' GROUP BY item"); while($s = dbassoc($stories)) { dbquery("UPDATE ".TABLEPREFIX."fanfiction_stories SET reviews = '".$s['count']."' WHERE sid = '".$s['item']."'"); } dbquery("UPDATE ".TABLEPREFIX."fanfiction_chapters SET rating = '0', reviews = '0'"); $chapters = dbquery("SELECT AVG(rating) as average, chapid FROM ".TABLEPREFIX."fanfiction_reviews WHERE type = 'ST' AND rating != '-1' GROUP BY chapid"); while($c = dbassoc($chapters)) { dbquery("UPDATE ".TABLEPREFIX."fanfiction_chapters SET rating = '".round($c['average'])."' WHERE chapid = '".$c['chapid']."'"); } $chapters = dbquery("SELECT COUNT(reviewid) as count, chapid FROM ".TABLEPREFIX."fanfiction_reviews WHERE type = 'ST' AND review != 'No Review' GROUP BY chapid"); while($c = dbassoc($chapters)) { dbquery("UPDATE ".TABLEPREFIX."fanfiction_chapters SET reviews = '".$c['count']."' WHERE chapid = '".$c['chapid']."'"); } $output .= write_message(_STORIESUPDATED."

"._CONTINUE.""); } } } else { include("../config.php"); $output .= write_message(_UPDATESTORIES11INFO."

"._CONTINUE.""); } break; case "11": $output .= "
"._REVIEWUPDATE."
"; if(isset($_GET['install'])) { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $alter = dbquery("ALTER TABLE `".$tableprefix."fanfiction_reviews` CHANGE `psid` `item` INT( 11 ) NOT NULL DEFAULT '0'"); $output .= write_message(_REVIEWALTER7.($alter ? "" : "")); $alter2 = dbquery("ALTER TABLE `".$tableprefix."fanfiction_reviews` ADD `type` VARCHAR( 2 ) NOT NULL DEFAULT 'ST'"); $output .= write_message(_REVIEWALTER2.($alter2 ? "" : "")); $alter3 = dbquery("ALTER TABLE `".$tableprefix."fanfiction_reviews` CHANGE `member` `uid` INT( 11 ) NOT NULL DEFAULT '0'"); $output .= write_message(_REVIEWALTER3.($alter3 ? "" : "")); $alter4 = dbquery("ALTER TABLE `".$tableprefix."fanfiction_reviews` ADD `respond` CHAR( 1 ) DEFAULT '0' NOT NULL"); $output .= write_message(_REVIEWALTER5.($alter4 ? "" : "")); $update1 = dbquery("UPDATE ".$tableprefix."fanfiction_reviews SET type = 'ST' WHERE item > 0"); $alter5 = dbquery("ALTER TABLE `".$tableprefix."fanfiction_reviews` CHANGE `sid` `chapid` INT( 11 ) NOT NULL DEFAULT '0'"); $output .= write_message(_REVIEWALTER6.($alter5 ? "" : "")); $output .= write_message(_REVIEWUPDATE1.($update1 ? "" : "")); $update3 = dbquery("UPDATE ".$tableprefix."fanfiction_reviews SET respond = 1 WHERE review LIKE \"%Author's Response:%\""); $output .= write_message(_REVIEWUPDATE3.($update3 ? "" : "")); $output .= write_message(""._CONTINUE.""); } else $output .= write_message(_REVIEWUPDATEINFO."
"._CONTINUE.""); break; case "10": $output .= "
"._UPDATESTORIESTABLE11."
"; if(isset($_GET['install'])) { if($_GET['install'] == "automatic") { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $result = dbquery("ALTER TABLE ".$tableprefix."fanfiction_stories ADD `classes` VARCHAR( 200 ) NULL AFTER `catid`;"); if($result) $result = dbquery("ALTER TABLE ".$tableprefix."fanfiction_stories CHANGE `summary` `summary` TEXT NULL"); if($result) $result = dbquery("ALTER TABLE ".$tableprefix."fanfiction_stories ADD `coauthors` tinyint(1) NULL AFTER `uid`"); if($result) $result = dbquery("ALTER TABLE ".$tableprefix."fanfiction_stories CHANGE `numreviews` `reviews` SMALLINT( 6 ) DEFAULT '0' NOT NULL"); if($result) $result = dbquery("ALTER TABLE ".$tableprefix."fanfiction_stories CHANGE `counter` `count` INT( 11 ) NOT NULL DEFAULT '0' AFTER `reviews`;"); if($result) $result = dbquery("ALTER TABLE ".$tableprefix."fanfiction_stories ADD `storynotes` TEXT NULL AFTER `summary`;"); if($result) $output .= write_message(_ACTIONSUCCESSFUL."
"._CONTINUE.""); } else if($_GET['install'] == "manual") { $output .= write_message(_UPDATESTORIESTABLEMANUAL11."
"._CONTINUE.""); } } else { include("../config.php"); $output .= write_message(_UPDATESTORIESTABLEINFO11." "._AUTO." "._OR." "._MANUAL2.""); } break; case "9": $output .= "
"._MOVECLASSES."
"; if(isset($_GET['install'])) { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $newclass = dbquery("INSERT INTO ".$tableprefix."fanfiction_classtypes (`classtype_name`, `classtype_title`) VALUES('genres', 'Genres');"); $genres = dbquery("SELECT * FROM ".$tableprefix."fanfiction_genres"); $output .= ""; while($g = dbassoc($genres)) { $result = dbquery("INSERT INTO ".$tableprefix."fanfiction_classes (`class_type`, `class_name`) VALUES('1', '".$g['genre']."')"); $output .= ""; } $output .= "
GenresResult
".$g['genre']."" . ($result ? "" : "") ."
"; // Ditto with the warnings $newclass = dbquery("INSERT INTO ".$tableprefix."fanfiction_classtypes (`classtype_name`, `classtype_title`) VALUES('warnings', 'Warnings');"); $output .= ""; $warnings = dbquery("SELECT * FROM ".$tableprefix."fanfiction_warnings"); while($w = dbassoc($warnings)) { $result = dbquery("INSERT INTO ".$tableprefix."fanfiction_classes (`class_type`, `class_name`) VALUES('2', '$w[warning]')"); $output .= ""; } $output .= "
WarningsResult
".$w['warning']."" . ($result ? "" : "") ."
"; $drop1 = dbquery("DROP TABLE `".$tableprefix."fanfiction_genres`"); $output .= write_message(_DROPGENRES.($drop1 ? "" : "")); $drop2 = dbquery("DROP TABLE `".$tableprefix."fanfiction_warnings`"); $output .= write_message(_DROPWARNINGS.($drop2 ? "" : "")); $output .= write_message(_MOVECLASSFAIL."
continue"); } else $output .= write_message(_MOVECLASSESINFO."
"._CONTINUE.""); break; case "8": $output .= "
"._MESSAGEDATA."
"; if(isset($_GET['install'])) { if($_GET['install'] == "automatic") { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $output .= ""; $settings = dbquery("SELECT * FROM ".$tableprefix."fanfiction_settings_old"); if(!$settings) $settings = dbquery("SELECT * FROM ".$tableprefix."fanfiction_settings"); $messages = dbassoc($settings); foreach($messages as $name => $text) { $msg = dbquery("INSERT INTO `".$tableprefix."fanfiction_messages` (`message_name`, `message_title`, `message_text`) VALUES ('$name', '".$defaulttitles[$name]."', '".addslashes($text)."');"); $output .= ""; } $msg = dbquery("INSERT INTO `".$tableprefix."fanfiction_messages`(`message_name`, `message_title`, `message_text`) VALUES ('printercopyright', '', 'Disclaimer: All publicly recognizable characters and settings are the property of their respective owners. The original characters and plot are the property of the author. No money is being made from this work. No copyright infringement is intended.');"); $output .= ""; $msg = dbquery("INSERT INTO `".$tableprefix."fanfiction_messages`(`message_name`, `message_title`, `message_text`) VALUES ('rules', 'Submission Rules', '

Submission Rules

\r\n
    \r\n
  1. All submissions must be accompanied by a complete disclaimer. If a \r\n suitable disclaimer is not included, the site administrators reserve the right \r\n to add a disclaimer.  Repeat offenders may be subject to further action \r\n up to and including removal of stories and account.\r\n
    \r\n
    Sample Disclaimer
    \r\n
    Disclaimer: All publicly recognizable characters, settings, etc. are the property of their respective owners. The original characters and plot are the property of the author.  \r\n The author is in no way associated with the owners, creators, or producers of any media franchise.  No copyright infringement is intended.
    \r\n
    \r\n
    2. \r\n
  2. Stories must be submitted to the proper category.  If there is an appropriate sub-category, DO NOT add your story to the main category.  The submission \r\n form allows you to choose multiple categories for your story, and we worked very hard to add that functionality for you.   So please \r\n do NOT add your story multiple times!
    3. \r\n
  3. Titles and summaries must be kid friendly.  No exceptions. 
    4. \r\n
  4. "Please read", "Untitled", etc. are not acceptable titles or summaries.
    5. \r\n
  5. A number of authors have requested that fans refrain from writing fan \r\n fiction based on their work.  Therefore submissions will not be \r\n accepted based on the works of P.N. Elrod, Raymond Feist, Terry Goodkind, \r\n Laurell K. Hamilton, Anne McCaffrey, Robin McKinley, Irene Radford, Anne Rice, \r\n and Nora Roberts/J.D. Robb. 
    6. \r\n
  6. Actor/actress stories are not permitted...not even if they\'re visiting an \r\n alternate reality.
    7. \r\n
  7. Correct grammar and spelling are expected of all stories submitted to this \r\n site.  The site administrators are not grammar Nazis.  However, the \r\n site administrators reserve the right to request corrections in submissions \r\n with a multitude of grammar and/or spelling errors.  If such a request is \r\n ignored, the story will be deleted.
    8. \r\n
  8. All stories must be rated correctly and have the appropriate warnings.  \r\n All adult rated stories are expected to have warnings.  After all, they \r\n wouldn\'t have that rating if there wasn\'t something to be warned about!  The site administrators recognize \r\n that there is an audience for these stories, but please respect those who do \r\n not wish to read them by labeling them appropriately. \r\n Please note: Stories containing adults having sex with minors are strictly forbidden. 
    9. \r\n
  9. Stories with multiple chapters should be archived as such and NEVER as \r\n separate stories.  Upload the first chapter of your story, then go to Manage Stories in \r\nyour account to add additional chapters. If you have trouble with this, please contact the site administrator or ask a \r\n friend to help you.
    10. \r\n
  10. As much as possible, spoiler warnings are expected on all stories. For categories with serialized content, such as series of books or television series, \r\n spoilers are mandatory for the current season and/or most recent part. An appropriate spoiler warning to place in your summary would be: Spoilers for Star Trek II: The Wrath of Khan. \r\n DO NOT do anything like this: Spoilers for the one where Spock dies.
    11. \r\n
\r\n

Submissions found to be in violation of these rules may be removed and the \r\n author\'s account suspended at the discretion of the site administrators and/or \r\n moderators.  The site administrators reserve the right to modify these \r\n rules as needed.

');"); $output .= ""; $msg = dbquery("INSERT INTO `".$tableprefix."fanfiction_messages`(`message_name`, `message_title`, `message_text`) VALUES ('tos', 'Terms of Service', 'This is the Terms of Service for your site. It will be displayed when a new member registers to the site.');"); $output .= ""; $msg = dbquery("INSERT INTO `".$tableprefix."fanfiction_messages`(`message_name`, `message_title`, `message_text`) VALUES('maintenance', 'Site Maintenance', '

This site is currently undergoing maintenance. Please check back soon. Thank you.

');"); $output .= ""; $output .= "
MessageResult
".$defaulttitles[$name]."" . ($msg ? "" : "") ."
Printable Copyright" . ($msg ? "" : "") ."
Submission Rules" . ($msg ? "" : "") ."
Terms of Service" . ($msg ? "" : "") ."
Site Maintenance" . ($msg ? "" : "") ."
"; $output .= write_message(_MESSAGEAUTOFAILUPGRADE."
continue"); } } else $output .= write_message(_MESSAGEDATAUPGRADE."
"._CONTINUE.""); break; case "7": $output .= "
"._BLOCKDATA."
"; if(isset($_GET['install'])) { if($_GET['install'] == "automatic") { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $blocklist = array( array("categories","Categories","categories/categories.php","1",""), array("featured","Featured Stories","featured/featured.php","1",""), array("info","Site Info","info/info.php","2",""), array("login","Log In","login/login.php","1",""), array("menu","Main Menu","menu/menu.php","1",""), array("random","Random Story","random/random.php","2",""), array("recent","Most Recent","recent/recent.php","2","a:1:{s:3:\"num\";s:1:\"1\";}"), array("skinchange","Skin Change","skinchange/skinchange.php","1",""), array("news","Site News","news/news.php","1","a:1:{s:3:\"num\";s:1:\"1\";}") ); $output .= ""; foreach($blocklist as $block) { $b = dbquery("INSERT INTO `".$tableprefix."fanfiction_blocks` (`block_name`, `block_title`, `block_file`, `block_status`, `block_variables`) VALUES('".$block[0]."', '".$block[1]."', '".$block[2]."', '".$block[3]."', '".escapestring($block[4])."');"); $output .= ""; } $output .= "
"._BLOCK.""._RESULT."
".$block[1]."" . ($b ? "" : "") ."
"; $output .= write_message(_BLOCKDATAFAILUPGRADE."

"._CONTINUE.""); } else { $output .= write_message(_BLOCKDATAMANUAL."

"._CONTINUE.""); } } else $output .= write_message(_BLOCKDATANEW."

"._AUTO." "._OR." "._MANUAL2.""); break; case "6": $output .= "
"._LINKDATA."
"; if(isset($_GET['install'])) { if($_GET['install'] == "automatic") { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $pagelist = array( array("home","Home","index.php","0","0"), array("recent","Most Recent","browse.php?type=recent","0","0"), array("login","Login","user.php?action=login","0","0"), array("adminarea","Admin","admin.php","0","2"), array("logout","Logout","user.php?action=logout","0","1"), array("featured","Featured Stories","browse.php?type=featured","0","0"), array("catslink","Categories","browse.php?type=categories","0","0"), array("members","Members","authors.php?action=list","0","0"), array("authors","Authors","authors.php?list=authors","0","0"), array("help","Help","viewpage.php?page=help","0","0"), array("search","Search","search.php","0","0"), array("series","Series","browse.php?type=series","0","0"), array("tens","Top Tens","toplists.php","0","0"), array("challenges","Challenges","modules/challenges/challenges.php","0","0"), array("contactus","Contact Us","contact.php","0","0"), array("rules","Rules","viewpage.php?page=rules","0","0"), array("tos","Terms of Service","viewpage.php?page=tos","0","0"), array("rss","\'RSS\'","rss.php","0","0"), array("login","Account Info","user.php","0","1"), array("titles","Titles","browse.php?type=titles","0","0"), array("register","Register","user.php?action=register","0","0"), array("lostpassword","Lost Password","user.php?action=lostpassword","0","0"), array("newsarchive","News Archive","news.php","0","0"), array("browse","Browse","browse.php","0","0"), array("charslink", "Characters", "browse.php?type=characters","0","0"), array("ratings", "Ratings", "browse.php?type=ratings", "0", "0"), array("genres_link", "Genres", "browse.php?type=class&type_id=1", "0", "0"), array("warnings_link", "Warnings", "browse.php?type=class&type_id=2", "0", "0") ); $output .= ""; foreach($pagelist as $page) { $pages = dbquery("INSERT INTO `".$tableprefix."fanfiction_pagelinks` (`link_name`, `link_text`, `link_url`, `link_target`, `link_access`) VALUES ('".$page[0]."', '".$page[1]."', '".$page[2]."', '".$page[3]."', '".$page[4]."');"); $output .= ""; } $output .= "
PagesResult
".stripslashes($page[1])."" . ($pages ? "" : "") ."
"; $output .= write_message(_LINKAUTOFAIL."
"._CONTINUE.""); } else { $output .= write_message(_LINKMANUAL."
"._CONTINUE.""); } } else $output .= write_message(_LINKDATAINFO." "._LINKSETUP." "._AUTO." "._OR." "._MANUAL2.""); break; case "5": $output .= "
"._PANELDATA."
"; if(isset($_GET['install'])){ if($_GET['install'] == "automatic") { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $panellist = array( array("submitted","Submissions", "","3","5","0","A"), array("versioncheck", "Version Check", "", "3", "7", "0", "A"), array("newstory","Add New Story","stories.php?action=newstory&admin=1","3","3","0","A"), array("addseries","Add New Series","series.php?action=add","3","3","0","A"), array("news","News","","3","5","0","A"), array("featured","Featured Stories","","3","5","0","A"), array("characters","Characters","","2","2","0","A"), array("ratings","Ratings","","2","3","0","A"), array("members","Members","","2","5","0","A"), array("mailusers","Mail Users","","2","6","0","A"), array("settings","Settings","","1","2","0","A"), array("blocks","Blocks","","1","3","0","A"), array("censor","Censor","","1","0","1","A"), array("admins","Admins","","1","6","0","A"), array("classifications","Classifications","","2","4","0","A"), array("categories","Categories","","2","1","0","A"), array("custpages","Custom Pages","","1","4","0","A"), array("validate","Validate Submission","","3","0","1","A"), array("yesletter","Validation Letter","","3","0","1","A"), array("noletter","Rejection Letter","","3","0","1","A"), array("links","Page Links","","1","5","0","A"), array("messages","Message Settings","","2","0","1","A"), array("login","Login","","0","0","1","U"), array("logout","Logout","","1","5","0","U"), array("revreceived","Reviews Received","","1","0","1","U"), array("editprefs","Edit Preferences","","1","2","0","U"), array("lostpassword","Lost Password","","0","0","1","U"), array("editbio","Edit Bio","","1","1","0","U"), array("register","Register","","0","0","1","U"), array("manageimages","Manage Images","","1","5","0","S"), array("manfavs","Manage Favorites","","1","2","0","F"), array("revres","Review Response","","1","0","1","U"), array("stats","View Your Statistics","","1","3","0","U"), array("newstory","Add New Story","stories.php?action=newstory","1","1","0","S"), array("newseries","Add New Series","series.php?action=add","1","3","0","S"), array("managestories","Manage Stories","stories.php?action=viewstories","1","2","0","S"), array("manageseries","Manage Series","series.php?action=manage","1","4","0","S"), array("reviewsby","Your Reviews","","1","0","1","U"), array("storiesby","Stories by {author}","","0","1","0","P"), array("seriesby","Series by {author}","","0","2","0","P"), array("reviewsby","Reviews by {author}","","0","3","0","P"), array("categories","Categories","","0","1","0","B"), array("characters","Characters","","0","2","0","B"), array("ratings","Ratings","","0","3","0","B"), array("titles","Titles","","0","5","0","B"), array("class","Classes","","0","0","1","B"), array("recent","Most Recent","","0","0","1","B"), array("featured","Featured Stories","","0","0","1","B"), array("panels","Panels","","1","1","0","A"), array("phpinfo","PHP Info","","1","7","0","A"), array("contact","Contact","","0","0","1","P"), array("series", "Series", "", "0", "4", "0", "B"), array("viewlog", "Action Log", "", "1", "8", "0", "A"), array("shortstories","10 Shortest Stories","toplists/default.php","0","6","0","L"), array("longstories","10 Longest Stories","toplists/default.php","0","5","0","L"), array("largeseries","10 Largest Series","toplists/default.php","0","1","0","L"), array("smallseries","10 Smallest Series","toplists/default.php","0","2","0","L"), array("reviewedseries","10 Most Reviewed Series","toplists/default.php","0","4","0","L"), array("prolificauthors","10 Most Prolific Authors","toplists/default.php","0","10","0","L"), array("prolificreviewers","10 Most Prolific Reviewers","toplists/default.php","0","12","0","L"), array("reviewedstories","10 Most Reviewed Stories","toplists/default.php","0","8","0","L"), array("readstories","10 Most Read Stories","toplists/default.php","0","9","0","L"), array("favstories","10 Most Favorite Stories","toplists/default.php","0","7","0","L"), array("favauthors","10 Most Favorite Authors","toplists/default.php","0","11","0","L"), array("favseries","10 Most Favorite Series","toplists/default.php","0","3","0","L"), array("favst","Favorite Stories","","0","0","1","F"), array("favse","Favorite Series","","0","0","1","F"), array("favau","Favorite Authors","","0","0","1","F"), array("favst","Favorite Stories","","0","0","1","U"), array("favse","Favorite Series","","0","0","1","U"), array("favau","Favorite Authors","","0","0","1","U"), array("favlist","{author}\'s Favorites","viewuser.php?action=manfavs","0","5","0","F"), array("skins", "Skins", "", "3", "6", "0", "A"), array("authorfields", "Profile Information", "", "1", "9", "0", "A"), array("maintenance", "Archive Maintenance", "", "1", "10", "0", "A"), array("manual", "Admin Manual", "", "3", "6", "0", "A"), array('modules', 'Modules', '', 1, "11", 0, 'A') ); $output .= ""; foreach($panellist as $panel) { unset($panels); $panels = dbquery("INSERT INTO `".$tableprefix."fanfiction_panels` (`panel_name`, `panel_title`, `panel_url`, `panel_level`, `panel_order`, `panel_hidden`, `panel_type`) VALUES ('".$panel[0]."', '".$panel[1]."', '".$panel[2]."', '".$panel[3]."', '".$panel[4]."', '".$panel[5]."', '".$panel[6]."');"); $output .= ""; } $output .= "
PanelResult
".stripslashes($panel[1])."" . ($panels ? "" : "") ."
"; $output .= write_message(_PANELAUTOFAIL."
"._CONTINUE.""); } else { $output .= write_message(_PANELMANUAL."
"._CONTINUE.""); } } else $output .= write_message(_PANELDATAINFO." "._PANELSETUP." "._AUTO." "._OR." "._MANUAL2.""); break; case "4": $output .= "
"._INSTALLTABLES."
"; if(isset($_GET['install'])) { if($_GET['install'] == "automatic") { include("../config.php"); $settings = dbquery("SELECT tableprefix FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); list($tableprefix) = dbrow($settings); $output .= ""; $authorfields = dbquery("CREATE TABLE `".$tableprefix."fanfiction_authorfields` ( `field_id` int(11) NOT NULL AUTO_INCREMENT, `field_type` tinyint(4) NOT NULL default '0', `field_name` varchar(30) NOT NULL default ' ', `field_title` varchar(255) NOT NULL default ' ', `field_options` text, `field_code_in` text, `field_code_out` text, `field_on` tinyint(1) NOT NULL default '0', PRIMARY KEY (`field_id`) ) ENGINE=MyISAM;"); $output .= ""; $authorinfo = dbquery("CREATE TABLE `".$tableprefix."fanfiction_authorinfo` ( `uid` int(11) NOT NULL default '0', `field` int(11) NOT NULL default '0', `info` varchar(255) NOT NULL default ' ', KEY `uid` (`uid`) ) ENGINE=MyISAM;"); $output .= ""; $authorprefs = dbquery(" CREATE TABLE `".$tableprefix."fanfiction_authorprefs` ( `uid` int(11) NOT NULL default '0', `newreviews` tinyint(1) NOT NULL default '0', `newrespond` tinyint(1) NOT NULL default '0', `ageconsent` tinyint(1) NOT NULL default '0', `alertson` tinyint(1) NOT NULL default '0', `tinyMCE` tinyint(1) NOT NULL default '0', `sortby` tinyint(1) NOT NULL default '0', `storyindex` tinyint(1) NOT NULL default '0', `validated` tinyint(1) NOT NULL default '0', `userskin` varchar(60) NOT NULL default 'default', `level` tinyint(1) NOT NULL default '0', `categories` varchar(200) NOT NULL default '0', `contact` tinyint(1) NOT NULL default '0', `stories` int(11) NOT NULL default '0', PRIMARY KEY (`uid`) ) ENGINE=MyISAM;"); $output .= ""; $blocks = dbquery("CREATE TABLE `".$tableprefix."fanfiction_blocks` ( `block_id` int(11) NOT NULL auto_increment, `block_name` varchar(30) NOT NULL default '', `block_title` varchar(150) NOT NULL default '', `block_file` varchar(200) NOT NULL default '', `block_status` tinyint(1) NOT NULL default '0', `block_variables` text NOT NULL, PRIMARY KEY (`block_id`), KEY `block_name` (`block_name`) ) ENGINE=MyISAM;"); $output .= ""; $chapters = dbquery("CREATE TABLE `".$tableprefix."fanfiction_chapters` ( `chapid` int(11) NOT NULL auto_increment, `title` varchar(250) NOT NULL default '', `inorder` int(11) NOT NULL default '0', `notes` text NULL, `storytext` text NULL, `endnotes` text NULL, `validated` char(1) NOT NULL default '0', `wordcount` int(11) NOT NULL default '0', `rating` tinyint(4) NOT NULL default '0', `reviews` smallint(6) NOT NULL default '0', `sid` int(11) NOT NULL default '0', `uid` int(11) NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`chapid`), KEY `sid` (`sid`), KEY `uid` (`uid`), KEY `inorder` (`inorder`), KEY `title` (`title`), KEY `validated` (`validated`) ) ENGINE=MyISAM;"); $output .= ""; $classes = dbquery("CREATE TABLE `".$tableprefix."fanfiction_classes` ( `class_id` int(11) NOT NULL auto_increment, `class_type` int(11) NOT NULL default '0', `class_name` varchar(100) NOT NULL default '', PRIMARY KEY (`class_id`) ) ENGINE=MyISAM;"); $output .= ""; $classtypes = dbquery("CREATE TABLE `".$tableprefix."fanfiction_classtypes` ( `classtype_id` int(11) NOT NULL auto_increment, `classtype_name` varchar(50) NOT NULL default '', `classtype_title` varchar(50) NOT NULL default '', PRIMARY KEY (`classtype_id`), KEY `classtype_title` (`classtype_title`) ) ENGINE=MyISAM;"); $output .= ""; $coauthors = dbquery("CREATE TABLE `".TABLEPREFIX."fanfiction_coauthors` ( `sid` int(11) NOT NULL default '0', `uid` int(11) NOT NULL default '0', PRIMARY KEY (`sid`,`uid`) ) ENGINE=MyISAM;"); $output .= ""; $codeblocks = dbquery("CREATE TABLE `".$tableprefix."fanfiction_codeblocks` ( `code_id` int(11) NOT NULL auto_increment, `code_text` text NOT NULL, `code_type` varchar(20) default NULL, `code_module` varchar(60) default NULL, PRIMARY KEY (`code_id`) ) ENGINE=MyISAM;"); $output .= ""; $favorites = dbquery("CREATE TABLE `".$tableprefix."fanfiction_favorites` ( `uid` int(11) NOT NULL default '0', `item` int(11) NOT NULL default '0', `type` char(2) NOT NULL default '', `comments` text NULL, KEY `uid` (`uid`) ) ENGINE=MyISAM;"); $output .= ""; $inseries = dbquery("CREATE TABLE `".$tableprefix."fanfiction_inseries` ( `seriesid` int(11) NOT NULL default '0', `sid` int(11) NOT NULL default '0', `subseriesid` int(11) NOT NULL default '0', `confirmed` int(11) NOT NULL default '0', `inorder` int(11) NOT NULL default '0', PRIMARY KEY (`sid`,`seriesid`, `subseriesid`), KEY `seriesid` (`seriesid`,`inorder`) ) ENGINE=MyISAM;"); $output .= ""; $logs = dbquery("CREATE TABLE `".$tableprefix."fanfiction_log` ( `log_id` int(11) NOT NULL auto_increment, `log_action` varchar(255) default NULL, `log_uid` int(11) NOT NULL, `log_ip` int(11) UNSIGNED default NULL, `log_timestamp` timestamp NOT NULL, `log_type` varchar(2) NOT NULL, PRIMARY KEY (`log_id`) ) ENGINE=MyISAM"); $output .= ""; $messages = dbquery("CREATE TABLE `".$tableprefix."fanfiction_messages` ( `message_id` int(11) NOT NULL auto_increment, `message_name` varchar(50) NOT NULL default '', `message_title` varchar(200) NOT NULL default '', `message_text` text NULL, PRIMARY KEY (`message_id`) ) ENGINE=MyISAM;"); $output .= ""; $modules = dbquery(" CREATE TABLE `".$tableprefix."fanfiction_modules` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default 'Test Module', `version` varchar(10) NOT NULL default '1.0', PRIMARY KEY (`id`), KEY `name_version` (`name`,`version`) )"); $output .= ""; $pagelinks = dbquery("CREATE TABLE `".$tableprefix."fanfiction_pagelinks` ( `link_id` int(11) NOT NULL auto_increment, `link_name` varchar(50) NOT NULL default '', `link_text` varchar(100) NOT NULL default '', `link_key` CHAR( 1 ) NULL, `link_url` varchar(250) NOT NULL default '', `link_target` char(1) NOT NULL default '0', `link_access` tinyint(4) NOT NULL default '0', PRIMARY KEY (`link_id`), KEY `link_text` (`link_text`), KEY `link_name` (`link_name`) ) ENGINE=MyISAM;"); $output .= ""; $panels = dbquery("CREATE TABLE `".$tableprefix."fanfiction_panels` ( `panel_id` int(11) NOT NULL auto_increment, `panel_name` varchar(50) NOT NULL default 'unknown', `panel_title` varchar(100) NOT NULL default 'Unnamed Panel', `panel_url` varchar(100) default NULL, `panel_level` tinyint(4) NOT NULL default '3', `panel_order` tinyint(4) NOT NULL default '0', `panel_hidden` tinyint(1) NOT NULL default '0', `panel_type` varchar(20) NOT NULL default 'A', PRIMARY KEY (`panel_id`), KEY `panel_hidden` (`panel_hidden`), KEY `panel_type` (`panel_type`) ) ENGINE=MyISAM;"); $output .= ""; $series = dbquery("CREATE TABLE `".$tableprefix."fanfiction_series` ( `seriesid` int(11) NOT NULL auto_increment, `title` varchar(200) NOT NULL default '', `summary` text NOT NULL, `uid` int(11) NOT NULL default '0', `isopen` tinyint(4) NOT NULL default '0', `catid` varchar(200) NOT NULL default '0', `rating` tinyint(4) NOT NULL default '0', `classes` varchar(200) NOT NULL default '', `characters` varchar(250) NOT NULL default '', `reviews` smallint(6) NOT NULL default '0', `numstories` INT NOT NULL DEFAULT '0', PRIMARY KEY (`seriesid`), KEY `catid` (`catid`), KEY `characters` (`characters`), KEY `classes` (`classes`), KEY `owner` (`uid`,`title`) ) ENGINE=MyISAM;"); $output .= ""; $stats = dbquery("CREATE TABLE `".$tableprefix."fanfiction_stats` ( `sitekey` varchar(50) NOT NULL default '0', `stories` int(11) NOT NULL default '0', `chapters` int(11) NOT NULL default '0', `series` int(11) NOT NULL default '0', `reviews` int(11) NOT NULL default '0', `wordcount` int(11) NOT NULL default '0', `authors` int(11) NOT NULL default '0', `members` int(11) NOT NULL default '0', `reviewers` int(11) NOT NULL default '0', `newestmember` int(11) NOT NULL default '0' ) ENGINE=MyISAM"); dbquery("INSERT INTO ".$tableprefix."fanfiction_stats(`sitekey`) VALUES('".$sitekey."')"); $output .= ""; $output .= "
TableResult
".$tableprefix."fanfiction_authorfields" . ($authorfields ? "" : "") ."
".$tableprefix."fanfiction_authorinfo" . ($authorinfo ? "" : "") ."
".$tableprefix."fanfiction_authorprefs" . ($authorprefs ? "" : "") ."
".$tableprefix."fanfiction_blocks" . ($blocks ? "" : "") ."
".$tableprefix."fanfiction_chapters" . ($chapters ? "" : "") ."
".$tableprefix."fanfiction_classes" . ($classes ? "" : "") ."
".$tableprefix."fanfiction_classtypes" . ($classtypes ? "" : "") ."
".$tableprefix."fanfiction_coauthors" . ($coauthors ? "" : "") ."
".$tableprefix."fanfiction_codeblocks" . ($codeblocks ? "" : "") ."
".$tableprefix."fanfiction_favorites" . ($favorites ? "" : "") ."
".$tableprefix."fanfiction_inseries" . ($inseries ? "" : "") ."
".$tableprefix."fanfiction_log" . ($logs ? "" : "") ."
".$tableprefix."fanfiction_messages" . ($messages ? "" : "") ."
".$tableprefix."fanfiction_modules" . ($modules ? "" : "") ."
".$tableprefix."fanfiction_pagelinks" . ($pagelinks ? "" : "") ."
".$tableprefix."fanfiction_panels" . ($panels ? "" : "") ."
".$tableprefix."fanfiction_series" . ($series ? "" : "") ."
".$tableprefix."fanfiction_stats" . ($stats ? "" : "") ."
"; $output .= write_message(_NEWTABLEAUTOFAIL11."
"._CONTINUE.""); } else if($_GET['install'] == "manual") { $output .= write_message(_NEWTABLESSETUP."
"._CONTINUE.""); } } else { include("../config.php"); $output .= write_message(_NEWTABLESSETUP." "._AUTO." "._OR." "._MANUAL2.""); } break; case "3": define ("_BASEDIR", "../"); include("../config.php"); define("SITEKEY", $sitekey); if(!$_GET['sect']) $sect = "main"; else $sect = $_GET['sect']; $settingsresults = dbquery("SELECT * FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); if(dbnumrows($settingsresults) == 0) { dbquery("INSERT INTO ".$settingsprefix."fanfiction_settings (`sitekey`) VALUES('".$sitekey."');"); $settingsresults = dbquery("SELECT * FROM ".$settingsprefix."fanfiction_settings WHERE sitekey = '".$sitekey."'"); } $settings = dbassoc($settingsresults); foreach($settings as $var => $val) { $$var = stripslashes($val); } define("TABLEPREFIX", $tableprefix); if((empty($sect) || $sect == "main") && !isset($_POST['submit'])) $output .= write_message(_SKINWARNING); if($sect == "submissions") { if($_POST['submit']) { $storiespath = descript($_POST['newstoriespath']); if(!file_exists($storiespath) && !file_exists("../".$storiespath)) { if(!strrchr($storiespath, "/") && !strrchr($storiespath, "\\")) $storiespath = "../$storiespath"; mkdir("$storiespath", 0755); chmod("$storiespath", 0777); } } } if($sect == "email" && $_POST['submit']) { $output .= "
"._SETTINGS."
"; $smtp_host = $_POST['newsmtp_host']; $smtp_username = $_POST['newsmtp_username']; $smtp_password = $_POST['newsmtp_password']; $result = dbquery("UPDATE ".$settingsprefix."fanfiction_settings SET smtp_host = '$smtp_host', smtp_username = '$smtp_username', smtp_password = '$smtp_password' WHERE sitekey = '".$sitekey."'"); if($result) { $output .= write_message(_ACTIONSUCCESSFUL); $output .= write_message(""._CONTINUE.""); } else include("../admin/settings.php"); } else include("../admin/settings.php"); break; case "2": $output .= "
"._CONFIGDATA."
"; define ("_BASEDIR", "../"); include("../config.php"); if(isset($_POST['sitekey'])) { // relative path if(file_exists("../".$databasepath."/dbconfig.php")) include("../".$databasepath."/dbconfig.php"); // absolute path else if(file_exists($databasepath."/dbconfig.php")) include($databasepath."/dbconfig.php"); include_once("../includes/dbfunctions.php"); $dbconnect = dbconnect($dbhost, $dbuser, $dbpass, $dbname ); $sitekey = !empty($_POST['sitekey']) ? descript($_POST['sitekey']) : random_string($randomcharset, 10); $settingsprefix = descript($_POST['settingsprefix']); $sitesettings = dbquery("INSERT INTO ".$settingsprefix."fanfiction_settings( `sitename`, `slogan`, `url`, `siteemail`, `store`, `autovalidate`, `multiplecats`, `reviewsallowed`, `ratings`, `roundrobins`, `submissionsoff`, `anonreviews`, `itemsperpage`, `imageupload`, `imageheight`, `imagewidth`, `skin`) VALUES('$sitename', '$slogan', '$url', '$siteemail', '$store', '$autovalidate', '$numcats', '$reviewsallowed', '$ratings', '$roundrobins', '$submissionsoff', '$anonreviews', '$itemsperpage', '$imageupload', '$imageheight', '$imagewidth', '$skin')"); if($sitesettings) $output .= write_message(""._SITESETTINGSMOVED); $handle = fopen("../config.php", 'w'); if(!$handle) { chmod("../config.php", 0666); $handle = fopen("../config.php", 'w'); } if ($handle) { $text = ""; fwrite($handle, $text); fclose($handle); @chmod("../config.php", 0644); $output .= write_message(""._CONFIG_WRITTEN."
"._CONTINUE.""); } else $output .= write_message(_ERROR_CONFIGWRITE); } else { $output .= "

"; $output .= write_message(_HELP_SITEKEY." "._SITEKEYNOTE); } break; default: $output .= "
Create Settings Table
"; include("../config.php"); if(isset($_POST['submit'])) { // relative path if(file_exists("../".$databasepath."/dbconfig.php")) include("../".$databasepath."/dbconfig.php"); // absolute path else if(file_exists($databasepath."/dbconfig.php")) include($databasepath."/dbconfig.php"); include("../includes/dbfunctions.php"); $dbconnect = dbconnect($dbhost, $dbuser, $dbpass, $dbname ); $settings = dbquery("SHOW TABLES LIKE '".$tableprefix."fanfiction_settings'"); if($settings) dbquery("RENAME TABLE ".$tableprefix."fanfiction_settings TO ".$tableprefix."fanfiction_settings_old"); $settings = dbquery("CREATE TABLE IF NOT EXISTS`".$_POST['settingsprefix']."fanfiction_settings` ( `sitekey` varchar(50) NOT NULL default '1', `sitename` varchar(200) NOT NULL default 'Your Site', `slogan` varchar(200) NOT NULL default 'It''s a cool site!', `url` varchar(200) NOT NULL default 'http://www.yoursite.com', `siteemail` varchar(200) NOT NULL default 'you@yoursite.com', `tableprefix` varchar(50) NOT NULL default '', `skin` varchar(50) NOT NULL default 'default', `hiddenskins` varchar(255) default '', `language` varchar(10) NOT NULL default 'en', `submissionsoff` tinyint(1) NOT NULL default '0', `storiespath` varchar(20) NOT NULL default 'stories', `store` varchar(5) NOT NULL default 'files', `autovalidate` tinyint(1) NOT NULL default '0', `coauthallowed` int(1) NOT NULL default '0', `maxwords` int(11) NOT NULL default '0', `minwords` int(11) NOT NULL default '0', `imageupload` tinyint(1) NOT NULL default '0', `imageheight` int(11) NOT NULL default '200', `imagewidth` int(11) NOT NULL default '200', `roundrobins` tinyint(1) NOT NULL default '0', `allowseries` tinyint(4) NOT NULL default '2', `tinyMCE` tinyint(1) NOT NULL default '0', `allowed_tags` varchar(200) NOT NULL default '



    • ', `favorites` tinyint(1) NOT NULL default '0', `multiplecats` tinyint(1) NOT NULL default '0', `newscomments` tinyint(1) NOT NULL default '0', `logging` tinyint(1) NOT NULL default '0', `maintenance` tinyint(1) NOT NULL default '0', `debug` tinyint(1) NOT NULL default '0', `captcha` tinyint(1) NOT NULL default '0', `dateformat` varchar(20) NOT NULL default 'd/m/y', `timeformat` varchar(20) NOT NULL default '- h:i a', `recentdays` tinyint(2) NOT NULL default '7', `displaycolumns` tinyint(1) NOT NULL default '1', `itemsperpage` tinyint(2) NOT NULL default '25', `extendcats` tinyint(1) NOT NULL default '0', `displayindex` tinyint(1) NOT NULL default '0', `defaultsort` tinyint(1) NOT NULL default '0', `displayprofile` tinyint(1) NOT NULL default '0', `linkstyle` tinyint(1) NOT NULL default '0', `linkrange` tinyint(2) NOT NULL default '5', `reviewsallowed` tinyint(1) NOT NULL default '0', `ratings` tinyint(1) NOT NULL default '0', `anonreviews` tinyint(1) NOT NULL default '0', `revdelete` tinyint(1) NOT NULL default '0', `rateonly` tinyint(1) NOT NULL default '0', `pwdsetting` tinyint(1) NOT NULL default '0', `alertson` tinyint(1) NOT NULL default '0', `disablepopups` tinyint(1) NOT NULL default '0', `agestatement` tinyint(1) NOT NULL default '0', `words` text, `version` varchar(10) NOT NULL default '".$version."', `smtp_host` varchar(200) default NULL, `smtp_username` varchar(50) default NULL, `smtp_password` varchar(50) default NULL, PRIMARY KEY (`sitekey`) ) ENGINE=MyISAM;"); if($settings) $output .= write_message(" "._SETTINGSTABLESUCCESS."
      "._CONTINUE.""); else $output .= write_message(_SETTINGSTABLEAUTOFAIL."
      "._CONTINUE." "); } else { $install = isset($_GET['install']) ? $_GET['install'] : false; if($install == "manual") { $output .= write_message(_SETTINGSTABLEMANUAL."
      "._CONTINUE.""); } else if($install == "automatic") { $output .= "

      "; $output .= write_message(_SETTINGSTABLENOTE); } else { $output .= write_message(_SETTINGSTABLESETUP." "._AUTO." "._OR." "._MANUAL2.""); } } } $tpl->assign("output", $output); $tpl->printToScreen(); if($step > 1) dbclose( ); ?>