mysql_query("CREATE TABLE ".$prefix."_journal (jid int(11) NOT NULL auto_increment, aid varchar(30) NOT NULL default '', title varchar(80) default NULL, bodytext text NOT NULL, mood varchar(48) NOT NULL default '', pdate varchar(48) NOT NULL default '', ptime varchar(48) NOT NULL default '', status varchar(48) NOT NULL default '', mtime varchar(48) NOT NULL default '', mdate varchar(48) NOT NULL default '', PRIMARY KEY (jid))");
mysql_query("CREATE TABLE ".$prefix."_journal_comments (cid int(11) NOT NULL auto_increment, rid varchar(48) NOT NULL default '', aid varchar(30) NOT NULL default '', comment text NOT NULL, pdate varchar(48) NOT NULL default '', ptime varchar(48) NOT NULL default '', PRIMARY KEY (cid))");
mysql_query("CREATE TABLE ".$prefix."_journal_stats (id int(11) NOT NULL auto_increment, joid varchar(48) NOT NULL default '', nop varchar(48) NOT NULL default '', ldp varchar(24) NOT NULL default '', ltp varchar(24) NOT NULL default '', micro varchar(128) NOT NULL default '', PRIMARY KEY (id))");
// Modules Table Alteration
mysql_query("ALTER TABLE ".$prefix."_modules ADD inmenu TINYINT(1) DEFAULT '1' NOT NULL");
// Banners Table Alteration
mysql_query("ALTER TABLE ".$prefix."_banner ADD alttext VARCHAR(255) DEFAULT '' NOT NULL AFTER clickurl");
if ($startdate == "") { $startdate = "September 2002"; }
if ($adminmail == "") { $adminmail = "webmaster@yoursite.com"; }
if ($anonpost == "") { $anonpost = 0; }
if ($Default_Theme == "") { $Default_Theme = "NukeNews"; }
if ($foot1 == "") { $foot1 = "<a href=\"http://phpnuke.org\" target=\"blank\"><img src=\"images/powered/nuke.gif\" border=\"0\" Alt=\"Web site powered by PHP-Nuke\" hspace=\"10\"></a>"; }
if ($foot2 == "") { $foot2 = "All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest ⌐ 2002 by $sitename"; }
if ($foot3 == "") { $foot3 = "You can syndicate our news using the file <a href=\"backend.php\">backend.php</a> or <a href=\"ultramode.txt\">ultramode.txt</a>"; }
if ($commentlimit == "") { $commentlimit = 4096; }
if ($anonymous == "") { $anonymous = "Anonymous"; }
mysql_query("CREATE TABLE ".$prefix."_config (sitename VARCHAR(255) NOT NULL, nukeurl VARCHAR(255) NOT NULL, site_logo VARCHAR(255) NOT NULL, slogan VARCHAR(255) NOT NULL, startdate VARCHAR(50) NOT NULL, adminmail VARCHAR(255) NOT NULL, anonpost TINYINT(1) DEFAULT '0' NOT NULL, Default_Theme VARCHAR(255) NOT NULL, foot1 TEXT NOT NULL, foot2 TEXT NOT NULL, foot3 TEXT NOT NULL, commentlimit INT(9) DEFAULT '4096' NOT NULL, anonymous VARCHAR(255) NOT NULL, minpass TINYINT(1) DEFAULT '5' NOT NULL, pollcomm TINYINT(1) DEFAULT '1' NOT NULL, articlecomm TINYINT(1) DEFAULT '1' NOT NULL, broadcast_msg TINYINT(1) DEFAULT '1' NOT NULL, my_headlines TINYINT(1) DEFAULT '1' NOT NULL, top INT(3) DEFAULT '10' NOT NULL, storyhome INT(2) DEFAULT '10' NOT NULL, user_news TINYINT(1) DEFAULT '1' NOT NULL, oldnum INT(2) DEFAULT '30' NOT NULL, ultramode TINYINT(1) DEFAULT '0' NOT NULL, banners TINYINT(1) DEFAULT '1' NOT NULL, backend_title VARCHAR(255) NOT NULL, backend_language VARCHAR(10) NOT NULL, language VARCHAR(100) NOT NULL, locale VARCHAR(10) NOT NULL, multilingual TINYINT(1) DEFAULT '0' NOT NULL, useflags TINYINT(1) DEFAULT '0' NOT NULL, notify TINYINT(1) DEFAULT '0' NOT NULL, notify_email VARCHAR(255) NOT NULL, notify_subject VARCHAR(255) NOT NULL, notify_message VARCHAR(255) NOT NULL, notify_from VARCHAR(255) NOT NULL, footermsgtxt TEXT NOT NULL, email_send TINYINT(1) DEFAULT '1' NOT NULL, attachmentdir VARCHAR(255) NOT NULL, attachments TINYINT(1) DEFAULT '0' NOT NULL, attachments_view TINYINT(1) DEFAULT '0' NOT NULL, download_dir VARCHAR(255) NOT NULL, defaultpopserver VARCHAR(255) NOT NULL, singleaccount TINYINT(1) NOT NULL DEFAULT '0', singleaccountname VARCHAR(255) NOT NULL, numaccounts TINYINT(2) DEFAULT '-1' NOT NULL, imgpath VARCHAR(255) NOT NULL, filter_forward TINYINT(1) DEFAULT '1' NOT NULL, moderate TINYINT(1) DEFAULT '0' NOT NULL, admingraphic TINYINT(1) DEFAULT '1' NOT NULL, httpref TINYINT(1) DEFAULT '1' NOT NULL, httprefmax INT(5) DEFAULT '1000' NOT NULL, CensorMode TINYINT(1) DEFAULT '3' NOT NULL, CensorReplace VARCHAR(10) NOT NULL, copyright TEXT NOT NULL, Version_Num VARCHAR(10) NOT NULL)");
