From 918b0a9fa8d7753bc980b461012f9de158bb0a5c Mon Sep 17 00:00:00 2001 From: Kazuki Przyborowski Date: Fri, 17 Aug 2007 07:37:20 +0000 Subject: [PATCH] Added smile table and fixed some errors. git-svn-id: svn://svn.code.sf.net/p/intdb/svn/trunk@85 2b68903e-0b30-0410-9a39-a2e4f3c5be39 --- inc/events.php | 27 ++++++++++++++++++++++++--- inc/javascript.php | 8 +++++++- inc/replys.php | 48 +++++++++++++++++++++++++++++++++++++++++++++--- inc/topics.php | 25 +++++++++++++++++++++++-- inc/versioninfo.php | 8 ++++---- javascript.js | 8 +++++++- setup/mkconfig.php | 20 ++++++++++---------- setup/mktable.php | 10 +++++----- 8 files changed, 125 insertions(+), 29 deletions(-) diff --git a/inc/events.php b/inc/events.php index 9a78913..0019ba4 100644 --- a/inc/events.php +++ b/inc/events.php @@ -11,7 +11,7 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: events.php - Last Update: 08/16/2007 SVN 84 - Author: cooldude2k $ + $FileInfo: events.php - Last Update: 08/17/2007 SVN 85 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="events.php"||$File3Name=="/events.php") { @@ -147,10 +147,31 @@ gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); }  "; ?> -Making a Topic in +Making a Event - + +
+ " style="vertical-align: middle; border: 0px; cursor: pointer;" title="" alt="" onclick="addsmiley('EventText','  ')" />   + + " style="vertical-align: middle; border: 0px; cursor: pointer;" title="" alt="" onclick="addsmiley('EventText','  ')" />
+
+
"> diff --git a/inc/javascript.php b/inc/javascript.php index 9cbe468..ac7728b 100644 --- a/inc/javascript.php +++ b/inc/javascript.php @@ -11,7 +11,7 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: javascript.php - Last Update: 05/26/2007 SVN 15 - Author: cooldude2k $ + $FileInfo: javascript.php - Last Update: 08/17/2007 SVN 85 - Author: cooldude2k $ */ @header("Content-Language: en"); @header("Vary: Accept"); @@ -41,4 +41,10 @@ for (var i = 0; i < usrname.length; i++) { if(usrname[i].innerHTML==text1) { usrname[i].innerHTML = text2; } } } +function addsmiley(id,code) { +var itm; +itm = document.getElementById(id); +var pretext = itm.value; +itm.value = pretext + code; } + diff --git a/inc/replys.php b/inc/replys.php index 20d7a3a..85d8706 100644 --- a/inc/replys.php +++ b/inc/replys.php @@ -11,7 +11,7 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: replys.php - Last Update: 08/15/2007 SVN 82 - Author: cooldude2k $ + $FileInfo: replys.php - Last Update: 08/17/2007 SVN 85 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="replys.php"||$File3Name=="/replys.php") { @@ -271,7 +271,28 @@ if($_GET['post']==null) { - +
Making a Reply in Topic
+ +
+ " style="vertical-align: middle; border: 0px; cursor: pointer;" title="" alt="" onclick="addsmiley('ReplyPost','  ')" />   + + " style="vertical-align: middle; border: 0px; cursor: pointer;" title="" alt="" onclick="addsmiley('ReplyPost','  ')" />
+
"> @@ -593,7 +614,28 @@ $TopicName = @remove_spaces($TopicName); - +
Editing a Reply in Topic
+ +
+ " style="vertical-align: middle; border: 0px; cursor: pointer;" title="" alt="" onclick="addsmiley('ReplyPost','  ')" />   + + " style="vertical-align: middle; border: 0px; cursor: pointer;" title="" alt="" onclick="addsmiley('ReplyPost','  ')" />
+
"> diff --git a/inc/topics.php b/inc/topics.php index eeadc33..3462dcd 100644 --- a/inc/topics.php +++ b/inc/topics.php @@ -11,7 +11,7 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: topics.php - Last Update: 08/15/2007 SVN 82 - Author: cooldude2k $ + $FileInfo: topics.php - Last Update: 08/17/2007 SVN 85 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="topics.php"||$File3Name=="/topics.php") { @@ -234,7 +234,28 @@ gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } - +
Making a Topic in
+ +
+ " style="vertical-align: middle; border: 0px; cursor: pointer;" title="" alt="" onclick="addsmiley('TopicPost','  ')" />   + + " style="vertical-align: middle; border: 0px; cursor: pointer;" title="" alt="" onclick="addsmiley('TopicPost','  ')" />
+
"> diff --git a/inc/versioninfo.php b/inc/versioninfo.php index 5eab784..2a8afce 100644 --- a/inc/versioninfo.php +++ b/inc/versioninfo.php @@ -11,7 +11,7 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: versioninfo.php - Last Update: 08/16/2007 SVN 84 - Author: cooldude2k $ + $FileInfo: versioninfo.php - Last Update: 08/17/2007 SVN 85 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="versioninfo.php"||$File3Name=="/versioninfo.php") { @@ -26,9 +26,9 @@ function version_info($proname,$subver,$ver,$supver,$reltype,$svnver,$showsvn) { if($showsvn!=true&&$showsvn!=null) { $return_var .= " ".$showsvn." ".$svnver; } return $return_var; } // Version number and date stuff. :P -$VER1[0] = 0; $VER1[1] = 1; $VER1[2] = 8; $VERFull[1] = $VER1[0].".".$VER1[1].".".$VER1[2]; -$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 84; $RName = "iDB"; $SFName = "IntDB"; -$SVNDay[0] = 08; $SVNDay[1] = 16; $SVNDay[2] = 2007; $SVNDay[3] = $SVNDay[0]."/".$SVNDay[1]."/".$SVNDay[2]; +$VER1[0] = 0; $VER1[1] = 1; $VER1[2] = 9; $VERFull[1] = $VER1[0].".".$VER1[1].".".$VER1[2]; +$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 85; $RName = "iDB"; $SFName = "IntDB"; +$SVNDay[0] = 08; $SVNDay[1] = 17; $SVNDay[2] = 2007; $SVNDay[3] = $SVNDay[0]."/".$SVNDay[1]."/".$SVNDay[2]; $VerInfo['iDB_Ver'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[1],$SubVerN,false); $VerInfo['iDB_Ver_SVN'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[1],$SubVerN,true); $VerInfo['iDB_Full_Ver'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[0],$SubVerN,false); diff --git a/javascript.js b/javascript.js index 1be3440..93f3590 100644 --- a/javascript.js +++ b/javascript.js @@ -10,7 +10,7 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: javascript.js - Last Update: 05/09/2007 SVN 1 - Author: cooldude2k $ + $FileInfo: javascript.js - Last Update: 08/17/2007 SVN 85 - Author: cooldude2k $ */ function getid(id) { var itm; @@ -36,3 +36,9 @@ usrname = document.getElementsByTagName(tag); for (var i = 0; i < usrname.length; i++) { if(usrname[i].innerHTML==text1) { usrname[i].innerHTML = text2; } } } + +function addsmiley(id,code) { +var itm; +itm = document.getElementById(id); +var pretext = itm.value; +itm.value = pretext + code; } \ No newline at end of file diff --git a/setup/mkconfig.php b/setup/mkconfig.php index 320fc52..a7333d1 100644 --- a/setup/mkconfig.php +++ b/setup/mkconfig.php @@ -12,7 +12,7 @@ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ iDB Installer made by Game Maker 2k - http://idb.berlios.net/ - $FileInfo: mkconfig.php - Last Update: 08/15/2007 SVN 82 - Author: cooldude2k $ + $FileInfo: mkconfig.php - Last Update: 08/17/2007 SVN 85 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="mkconfig.php"||$File3Name=="/mkconfig.php") { @@ -89,9 +89,9 @@ echo "
".mysql_errno().": ".mysql_error()."\n"; } if ($Error!="Yes") { require($SetupDir['setup'].'mktable.php'); /* -$query = query("INSERT INTO ".$_POST['tableprefix']."tagboard VALUES (1,-1,'Cool Dude 2k',".$YourDate.",'Welcome to Your New Tag Board. ^_^','127.0.0.1'), array(null)); +$query = query("INSERT INTO `".$_POST['tableprefix']."tagboard` VALUES (1,-1,'Cool Dude 2k',".$YourDate.",'Welcome to Your New Tag Board. ^_^','127.0.0.1'), array(null)); */ -$query = query("INSERT INTO ".$_POST['tableprefix']."categories VALUES (1,'Main','yes','category','yes',0,'The Main Category.')", array(null)); +$query = query("INSERT INTO `".$_POST['tableprefix']."categories` VALUES (1,'Main','yes','category','yes',0,'The Main Category.')", array(null)); mysql_query($query); if(!is_numeric($_POST['YourOffSet'])) { $_POST['YourOffSet'] = "0"; } if($_POST['YourOffSet']>12) { $_POST['YourOffSet'] = "12"; } @@ -112,13 +112,13 @@ $EventDay = GMTimeChange("d",$YourDate,0,0,"off"); $EventDayEnd = GMTimeChange("d",$YourDateEnd,0,0,"off"); $EventYear = GMTimeChange("Y",$YourDate,0,0,"off"); $EventYearEnd = GMTimeChange("Y",$YourDateEnd,0,0,"off"); -$query = query("INSERT INTO ".$_POST['tableprefix']."events VALUES (1, -1, 'Cool Dude 2k', 'Opening', 'This is the day the Board was made. ^_^', %i, %i, %i, %i, %i, %i, %i, %i)", array($YourDate,$YourDateEnd,$EventMonth,$EventMonthEnd,$EventDay,$EventDayEnd,$EventYear,$EventYearEnd)); +$query = query("INSERT INTO `".$_POST['tableprefix']."events` VALUES (1, -1, 'Cool Dude 2k', 'Opening', 'This is the day the Board was made. ^_^', %i, %i, %i, %i, %i, %i, %i, %i)", array($YourDate,$YourDateEnd,$EventMonth,$EventMonthEnd,$EventDay,$EventDayEnd,$EventYear,$EventYearEnd)); mysql_query($query); -$query = query("INSERT INTO ".$_POST['tableprefix']."forums VALUES (1,1,'Test/Spam','yes','forum',0,'http://',0,0,'A Test Board.','off','yes',1,1)", array(null)); +$query = query("INSERT INTO `".$_POST['tableprefix']."forums` VALUES (1,1,'Test/Spam','yes','forum',0,'http://',0,0,'A Test Board.','off','yes',1,1)", array(null)); mysql_query($query); -$query = query("INSERT INTO ".$_POST['tableprefix']."topics VALUES (1,1,1,-1,'Cool Dude 2k',%i,%i,'Welcome','Install was successful',0,0,1,1)", array($YourDate,$YourDate)); +$query = query("INSERT INTO `".$_POST['tableprefix']."topics` VALUES (1,1,1,-1,'Cool Dude 2k',%i,%i,'Welcome','Install was successful',0,0,1,1)", array($YourDate,$YourDate)); mysql_query($query); -$query = query("INSERT INTO ".$_POST['tableprefix']."posts VALUES (1,1,1,1,-1,'Cool Dude 2k',%i,%i,1,'Welcome to Your Message Board. :) ','Install was successful','127.0.0.1','127.0.0.1')", array($YourDate,$YourEditDate)); +$query = query("INSERT INTO `".$_POST['tableprefix']."posts` VALUES (1,1,1,1,-1,'Cool Dude 2k',%i,%i,1,'Welcome to Your Message Board. :) ','Install was successful','127.0.0.1','127.0.0.1')", array($YourDate,$YourEditDate)); mysql_query($query); $NewPassword = b64e_hmac($_POST['AdminPasswords'],$YourDate,$YourSalt,"sha1"); //$Name = stripcslashes(htmlspecialchars($AdminUser, ENT_QUOTES)); @@ -138,11 +138,11 @@ if($csrand==3) { $gpass .= chr(rand(97,122)); } ++$i; } $GuestPassword = b64e_hmac($gpass,$YourDate,$GSalt,"sha1"); $url_this_dir = "http://".$_SERVER['HTTP_HOST'].$this_dir."index.php?act=view"; $YourIP = $_SERVER['REMOTE_ADDR']; -$query = query("INSERT INTO ".$_POST['tableprefix']."members VALUES (-1,'Guest','%s','iDBH','%s',4,'no',0,'Guest Account','Guest',%i,%i,'0','0','0','[B]Test[/B] :)','Your Notes','http://','100x100','%s','UnKnow',1,'%s','%s','iDB','127.0.0.1','%s')", array($GuestPassword,$GEmail,$YourDate,$YourDate,"http://".$_SERVER['HTTP_HOST']."/",$AdminTime,$AdminDST,$GSalt)); +$query = query("INSERT INTO `".$_POST['tableprefix']."members` VALUES (-1,'Guest','%s','iDBH','%s',4,'no',0,'Guest Account','Guest',%i,%i,'0','0','0','[B]Test[/B] :)','Your Notes','http://','100x100','%s','UnKnow',1,'%s','%s','iDB','127.0.0.1','%s')", array($GuestPassword,$GEmail,$YourDate,$YourDate,"http://".$_SERVER['HTTP_HOST']."/",$AdminTime,$AdminDST,$GSalt)); mysql_query($query); -$query = query("INSERT INTO ".$_POST['tableprefix']."members VALUES (1,'%s','%s','iDBH','%s',1,'yes',0,'%s','Admin',%i,%i,'0','0','0','%s','Your Notes','%s','100x100','%s','UnKnow',0,'%s','%s','iDB','%s','%s')", array($_POST['AdminUser'],$NewPassword,$Email,$Interests,$YourDate,$YourDate,$NewSignature,$Avatar,$YourWebsite,$AdminTime,$AdminDST,$UserIP,$YourSalt)); +$query = query("INSERT INTO `".$_POST['tableprefix']."members` VALUES (1,'%s','%s','iDBH','%s',1,'yes',0,'%s','Admin',%i,%i,'0','0','0','%s','Your Notes','%s','100x100','%s','UnKnow',0,'%s','%s','iDB','%s','%s')", array($_POST['AdminUser'],$NewPassword,$Email,$Interests,$YourDate,$YourDate,$NewSignature,$Avatar,$YourWebsite,$AdminTime,$AdminDST,$UserIP,$YourSalt)); mysql_query($query); -$query = query("INSERT INTO ".$_POST['tableprefix']."messenger VALUES (1,-1,1,'Cool Dude 2k','Test','Hello Welcome to your board.\r\nThis is a Test PM. :P ','Hello Welcome',%i,0)", array($YourDate)); +$query = query("INSERT INTO `".$_POST['tableprefix']."messenger` VALUES (1,-1,1,'Cool Dude 2k','Test','Hello Welcome to your board.\r\nThis is a Test PM. :P ','Hello Welcome',%i,0)", array($YourDate)); mysql_query($query); $CHMOD = $_SERVER['PHP_SELF']; $pretext = " \ No newline at end of file -- 2.11.0