From b09a3dfee3e12998f269405f7eb14a50cd26a79a Mon Sep 17 00:00:00 2001 From: Kazuki Przyborowski Date: Thu, 2 Aug 2007 14:19:55 +0000 Subject: [PATCH] Added edit reply/topic and fixed some errors. git-svn-id: svn://svn.code.sf.net/p/intdb/svn/trunk@62 2b68903e-0b30-0410-9a39-a2e4f3c5be39 --- inc/categories.php | 12 +-- inc/events.php | 8 +- inc/forums.php | 12 +-- inc/groupsetup.php | 8 +- inc/members.php | 30 +++--- inc/misc/functions.php | 4 +- inc/navbar.php | 6 +- inc/pm.php | 20 ++-- inc/prelogin.php | 8 +- inc/profilemain.php | 28 ++--- inc/replys.php | 284 +++++++++++++++++++++++++++++++++++++++++++++---- inc/rssfeed.php | 4 +- inc/searchs.php | 8 +- inc/stats.php | 4 +- inc/subcategories.php | 14 +-- inc/subforums.php | 14 +-- inc/topics.php | 22 ++-- inc/versioninfo.php | 4 +- topic.php | 13 ++- 19 files changed, 378 insertions(+), 125 deletions(-) diff --git a/inc/categories.php b/inc/categories.php index 888e147..0fa6578 100644 --- a/inc/categories.php +++ b/inc/categories.php @@ -11,13 +11,13 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: categories.php - Last Update: 08/01/2007 SVN 60 - Author: cooldude2k $ + $FileInfo: categories.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="categories.php"||$File3Name=="/categories.php") { require('index.php'); exit(); } -$prequery = query("select * from `".$Settings['sqltable']."categories` where `id`=%i and `ShowCategory`='yes'", array($_GET['id'])); +$prequery = query("select * from `".$Settings['sqltable']."categories` WHERE `id`=%i and `ShowCategory`='yes'", array($_GET['id'])); $preresult=mysql_query($prequery); $prenum=mysql_num_rows($preresult); $prei=0; @@ -44,7 +44,7 @@ if($CategoryType=="subcategory") { redirect("location",$basedir.url_maker($exfile['subcategory'],$Settings['file_ext'],"act=".$_GET['act']."&id=".$_GET['id'],$Settings['qstr'],$Settings['qsep'],$prexqstr['subcategory'],$exqstr['subcategory'],FALSE)); ob_clean(); @header("Content-Type: text/plain; charset=".$Settings['charset']); gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } } -$query = query("select * from `".$Settings['sqltable']."forums` where `ShowForum`='yes' and `CategoryID`=%i and `InSubForum`=0 ORDER BY `id`", array($CategoryID)); +$query = query("select * from `".$Settings['sqltable']."forums` WHERE `ShowForum`='yes' AND `CategoryID`=%i AND `InSubForum`=0 ORDER BY `id`", array($CategoryID)); $result=mysql_query($query); $num=mysql_num_rows($result); $i=0; @@ -76,7 +76,7 @@ $ForumDescription=mysql_result($result,$i,"Description"); $ForumType = strtolower($ForumType); $gltf = array(null); $gltf[0] = $ForumID; if ($ForumType=="subforum") { -$apcquery = query("select * from `".$Settings['sqltable']."forums` where `ShowForum`='yes' and `InSubForum`=%i ORDER BY `id`", array($ForumID)); +$apcquery = query("select * from `".$Settings['sqltable']."forums` WHERE `ShowForum`='yes' AND `InSubForum`=%i ORDER BY `id`", array($ForumID)); $apcresult=mysql_query($apcquery); $apcnum=mysql_num_rows($apcresult); $apci=0; if($apcnum>=1) { @@ -97,7 +97,7 @@ $gltnum = count($gltf); $glti = 0; $OldUpdateTime = 0; $UseThisFonum = null; if ($ForumType=="subforum") { while ($glti < $gltnum) { -$gltfoquery = query("select * from `".$Settings['sqltable']."topics` where `CategoryID`=%i and `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$gltf[$glti])); +$gltfoquery = query("select * from `".$Settings['sqltable']."topics` WHERE `CategoryID`=%i AND `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$gltf[$glti])); $gltforesult=mysql_query($gltfoquery); $gltfonum=mysql_num_rows($gltforesult); if($gltfonum>0) { @@ -108,7 +108,7 @@ $OldUpdateTime = $NewUpdateTime; } } @mysql_free_result($gltforesult); ++$glti; } } if ($ForumType!="subforum") { $UseThisFonum = $gltf['0']; } -$gltquery = query("select * from `".$Settings['sqltable']."topics` where `CategoryID`=%i and `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$UseThisFonum)); +$gltquery = query("select * from `".$Settings['sqltable']."topics` WHERE `CategoryID`=%i AND `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$UseThisFonum)); $gltresult=mysql_query($gltquery); $gltnum=mysql_num_rows($gltresult); if($gltnum>0){ diff --git a/inc/events.php b/inc/events.php index 20309de..d5dc208 100644 --- a/inc/events.php +++ b/inc/events.php @@ -11,14 +11,14 @@ 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/02/2007 SVN 61 - Author: cooldude2k $ + $FileInfo: events.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="events.php"||$File3Name=="/events.php") { require('index.php'); exit(); } if($_GET['act']=="view"||$_GET['act']==null) { -$query = query("select * from `".$Settings['sqltable']."events` where `id`=%i", array($_GET['id'])); +$query = query("select * from `".$Settings['sqltable']."events` WHERE `id`=%i", array($_GET['id'])); $result=mysql_query($query); $num=mysql_num_rows($result); $is=0; @@ -39,7 +39,7 @@ $EventStart=mysql_result($result,$is,"TimeStamp"); $EventEnd=mysql_result($result,$is,"TimeStampEnd"); $EventStart = GMTimeChange("M. j Y",$EventStart,null); $EventEnd = GMTimeChange("M. j Y",$EventEnd,null); -$requery = query("select * from `".$Settings['sqltable']."members` where `id`=%i", array($EventUser)); +$requery = query("select * from `".$Settings['sqltable']."members` WHERE `id`=%i", array($EventUser)); $reresult=mysql_query($requery); $renum=mysql_num_rows($reresult); $rei=0; @@ -51,7 +51,7 @@ $User1Title=mysql_result($reresult,$rei,"Title"); $User1Joined=mysql_result($reresult,$rei,"Joined"); $User1Joined=GMTimeChange("M j Y",$User1Joined,$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']); $User1GroupID=mysql_result($reresult,$rei,"GroupID"); -$gquery = query("select * from `".$Settings['sqltable']."groups` where `id`=%i", array($User1GroupID)); +$gquery = query("select * from `".$Settings['sqltable']."groups` WHERE `id`=%i", array($User1GroupID)); $gresult=mysql_query($gquery); $User1Group=mysql_result($gresult,0,"Name"); @mysql_free_result($gresult); diff --git a/inc/forums.php b/inc/forums.php index d8b265f..f3b2e2d 100644 --- a/inc/forums.php +++ b/inc/forums.php @@ -11,13 +11,13 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: forums.php - Last Update: 08/01/2007 SVN 60 - Author: cooldude2k $ + $FileInfo: forums.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="forums.php"||$File3Name=="/forums.php") { require('index.php'); exit(); } -$prequery = query("select * from `".$Settings['sqltable']."categories` where `ShowCategory`='yes' and `InSubCategory`=0", array()); +$prequery = query("select * from `".$Settings['sqltable']."categories` WHERE `ShowCategory`='yes' AND `InSubCategory`=0", array()); $preresult=mysql_query($prequery); $prenum=mysql_num_rows($preresult); $prei=0; @@ -31,7 +31,7 @@ $CategoryDescription=mysql_result($preresult,$prei,"Description"); $CategoryType = strtolower($CategoryType); $SubShowForums = strtolower($SubShowForums); if(isset($CatPermissionInfo['CanViewCategory'][$CategoryID])&& $CatPermissionInfo['CanViewCategory'][$CategoryID]=="yes") { -$query = query("select * from `".$Settings['sqltable']."forums` where `ShowForum`='yes' and `CategoryID`=%i and `InSubForum`=0 ORDER BY `id`", array($CategoryID)); +$query = query("select * from `".$Settings['sqltable']."forums` WHERE `ShowForum`='yes' AND `CategoryID`=%i AND `InSubForum`=0 ORDER BY `id`", array($CategoryID)); $result=mysql_query($query); $num=mysql_num_rows($result); $i=0; @@ -63,7 +63,7 @@ $ForumDescription=mysql_result($result,$i,"Description"); $ForumType = strtolower($ForumType); $gltf = array(null); $gltf[0] = $ForumID; if ($ForumType=="subforum") { -$apcquery = query("select * from `".$Settings['sqltable']."forums` where `ShowForum`='yes' and `InSubForum`=%i ORDER BY `id`", array($ForumID)); +$apcquery = query("select * from `".$Settings['sqltable']."forums` WHERE `ShowForum`='yes' AND `InSubForum`=%i ORDER BY `id`", array($ForumID)); $apcresult=mysql_query($apcquery); $apcnum=mysql_num_rows($apcresult); $apci=0; if($apcnum>=1) { @@ -84,7 +84,7 @@ $gltnum = count($gltf); $glti = 0; $OldUpdateTime = 0; $UseThisFonum = null; if ($ForumType=="subforum") { while ($glti < $gltnum) { -$gltfoquery = query("select * from `".$Settings['sqltable']."topics` where `CategoryID`=%i and `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$gltf[$glti])); +$gltfoquery = query("select * from `".$Settings['sqltable']."topics` WHERE `CategoryID`=%i AND `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$gltf[$glti])); $gltforesult=mysql_query($gltfoquery); $gltfonum=mysql_num_rows($gltforesult); if($gltfonum>0) { @@ -95,7 +95,7 @@ $OldUpdateTime = $NewUpdateTime; } } @mysql_free_result($gltforesult); ++$glti; } } if ($ForumType!="subforum") { $UseThisFonum = $gltf['0']; } -$gltquery = query("select * from `".$Settings['sqltable']."topics` where `CategoryID`=%i and `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$UseThisFonum)); +$gltquery = query("select * from `".$Settings['sqltable']."topics` WHERE `CategoryID`=%i AND `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$UseThisFonum)); $gltresult=mysql_query($gltquery); $gltnum=mysql_num_rows($gltresult); if($gltnum>0){ diff --git a/inc/groupsetup.php b/inc/groupsetup.php index 8528387..c004be8 100644 --- a/inc/groupsetup.php +++ b/inc/groupsetup.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: groupsetup.php - Last Update: 07/31/2007 SVN 59 - Author: cooldude2k $ + $FileInfo: groupsetup.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="groupsetup.php"||$File3Name=="/groupsetup.php") { @@ -21,7 +21,7 @@ if ($File3Name=="groupsetup.php"||$File3Name=="/groupsetup.php") { if(!isset($_SESSION['UserGroup'])) { $_SESSION['UserGroup'] = null; } if($_SESSION['UserGroup']==null) { $_SESSION['UserGroup']=$Settings['GuestGroup']; } $GruError = null; -$gruquery = query("select * from `".$Settings['sqltable']."groups` where `Name`='%s'", array($_SESSION['UserGroup'])); +$gruquery = query("select * from `".$Settings['sqltable']."groups` WHERE `Name`='%s'", array($_SESSION['UserGroup'])); $gruresult=mysql_query($gruquery); $grunum=mysql_num_rows($gruresult); if($grunum<=0) { $GruError = true; @mysql_free_result($gruresult); @@ -74,7 +74,7 @@ if($GroupInfo['CanViewBoard']=="no") { ob_clean(); echo "Sorry you can not view the board."; gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } // Member Group Permissions Setup -$perquery = query("select * from `".$Settings['sqltable']."permissions` where `PermissionID`=%i ORDER BY `ForumID` ASC", array($GroupInfo['PermissionID'])); +$perquery = query("select * from `".$Settings['sqltable']."permissions` WHERE `PermissionID`=%i ORDER BY `ForumID` ASC", array($GroupInfo['PermissionID'])); $peresult=mysql_query($perquery); $pernum=mysql_num_rows($peresult); $peri=0; $PerError = null; @@ -128,7 +128,7 @@ if($PerError==true) { $peri = $pernum; } ob_clean(); echo "Sorry could not load all permission data in database.\nContact the board admin about error."; gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } } @mysql_free_result($peresult); -$per2query = query("select * from `".$Settings['sqltable']."catpermissions` where `PermissionID`=%i ORDER BY `CategoryID` ASC", array($GroupInfo['PermissionID'])); +$per2query = query("select * from `".$Settings['sqltable']."catpermissions` WHERE `PermissionID`=%i ORDER BY `CategoryID` ASC", array($GroupInfo['PermissionID'])); $per2esult=mysql_query($per2query); $per2num=mysql_num_rows($per2esult); $per2i=0; $Per2Error = null; diff --git a/inc/members.php b/inc/members.php index b554688..ed7c6c9 100644 --- a/inc/members.php +++ b/inc/members.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: members.php - Last Update: 07/15/2007 SVN 44 - Author: cooldude2k $ + $FileInfo: members.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="members.php"||$File3Name=="/members.php") { @@ -50,14 +50,14 @@ if($_GET['ordertype']=="desc") { $orderlist .= " desc"; } } if(!is_numeric($_GET['gid'])) { $_GET['gid'] = null; } if($_GET['gid']!=null&&$_GET['groupid']==null) { $_GET['groupid'] = $_GET['gid']; } if(!is_numeric($_GET['groupid'])) { $_GET['groupid'] = null; } -$ggquery = query("select * from `".$Settings['sqltable']."groups` where `Name`='%s'", array($Settings['GuestGroup'])); +$ggquery = query("select * from `".$Settings['sqltable']."groups` WHERE `Name`='%s'", array($Settings['GuestGroup'])); $ggresult=mysql_query($ggquery); $GGroup=mysql_result($ggresult,0,"id"); @mysql_free_result($ggresult); if($_GET['groupid']==null) { -$query = query("select * from `".$Settings['sqltable']."members` where `GroupID`<>%i ".$orderlist, array($GGroup)); } +$query = query("select * from `".$Settings['sqltable']."members` WHERE `GroupID`<>%i ".$orderlist, array($GGroup)); } if($_GET['groupid']!=null) { -$query = query("select * from `".$Settings['sqltable']."members` where `GroupID`=%i and `GroupID`<>%i ".$orderlist, array($_GET['groupid'],$GGroup)); } +$query = query("select * from `".$Settings['sqltable']."members` WHERE `GroupID`=%i AND `GroupID`<>%i ".$orderlist, array($_GET['groupid'],$GGroup)); } $result=mysql_query($query); $num=mysql_num_rows($result); //Start MemberList Page Code (Will be used at later time) @@ -110,7 +110,7 @@ $MemList['PostCount']=mysql_result($result,$i,"PostCount"); $MemList['TimeZone']=mysql_result($result,$i,"TimeZone"); $MemList['DST']=mysql_result($result,$i,"DST"); $MemList['IP']=mysql_result($result,$i,"IP"); -$gquery = query("select * from `".$Settings['sqltable']."groups` where `id`=%i", array($MemList['GroupID'])); +$gquery = query("select * from `".$Settings['sqltable']."groups` WHERE `id`=%i", array($MemList['GroupID'])); $gresult=mysql_query($gquery); $MemList['Group']=mysql_result($gresult,0,"Name"); @mysql_free_result($gresult); @@ -135,7 +135,7 @@ if($MemList['Group']!=$Settings['GuestGroup']) { =1) { @@ -359,7 +359,7 @@ $YourIDM=mysql_result($resultlog,$i,"id"); $YourNameM=mysql_result($resultlog,$i,"Name"); $YourPassM=mysql_result($resultlog,$i,"Password"); $YourGroupM=mysql_result($resultlog,$i,"GroupID"); -$gquery = query("select * from `".$Settings['sqltable']."groups` where `id`=%i", array($YourGroupM)); +$gquery = query("select * from `".$Settings['sqltable']."groups` WHERE `id`=%i", array($YourGroupM)); $gresult=mysql_query($gquery); $YourGroupM=mysql_result($gresult,0,"Name"); @mysql_free_result($gresult); @@ -371,7 +371,7 @@ $NewHashSalt = salt_hmac(); $NewPassword = b64e_hmac($_POST['userpass'],$JoinedPass,$NewHashSalt,"sha1"); $NewDay=GMTimeStamp(); $NewIP=$_SERVER['REMOTE_ADDR']; -$queryup = query("update `".$Settings['sqltable']."members` set `Password`='%s',`HashType`='iDBH',`LastActive`='%s',`IP`='%s',`Salt`='%s' WHERE `id`=%i", array($NewPassword,$NewDay,$NewIP,$NewHashSalt,$YourIDM)); +$queryup = query("update `".$Settings['sqltable']."members` set `Password`='%s',`HashType`='iDBH',`LastActive`=%i,`IP`='%s',`Salt`='%s' WHERE `id`=%i", array($NewPassword,$NewDay,$NewIP,$NewHashSalt,$YourIDM)); mysql_query($queryup); @mysql_free_result($resultlog); @mysql_free_result($queryup); //session_regenerate_id(); @@ -575,8 +575,8 @@ if(!isset($_POST['TOS'])) { $_POST['TOS'] = null; } $Name = stripcslashes(htmlspecialchars($_POST['Name'], ENT_QUOTES)); $Name = preg_replace("/&#(x[a-f0-9]+|[0-9]+);/i", "&#$1;", $Name); $Name = @remove_spaces($Name); -$sql_email_check = mysql_query(query("select `Email` from `".$Settings['sqltable']."members` where `Email` = '%s'", array($_POST['Email']))); -$sql_username_check = mysql_query(query("select `Name` from `".$Settings['sqltable']."members` where `Name` = '%s'", array($Name))); +$sql_email_check = mysql_query(query("select `Email` from `".$Settings['sqltable']."members` WHERE `Email`='%s'", array($_POST['Email']))); +$sql_username_check = mysql_query(query("select `Name` from `".$Settings['sqltable']."members` WHERE `Name`='%s'", array($Name))); $email_check = mysql_num_rows($sql_email_check); $username_check = mysql_num_rows($sql_username_check); @mysql_free_result($sql_email_check); @mysql_free_result($sql_username_check); @@ -649,7 +649,7 @@ $Avatar = @remove_spaces($Avatar); $Website = stripcslashes(htmlspecialchars($_POST['Website'], ENT_QUOTES)); $Website = preg_replace("/&#(x[a-f0-9]+|[0-9]+);/i", "&#$1;", $Website); $Website = @remove_spaces($Website); -$gquerys = query("select * from `".$Settings['sqltable']."groups` where `Name`='%s'", array($Settings['MemberGroup'])); +$gquerys = query("select * from `".$Settings['sqltable']."groups` WHERE `Name`='%s'", array($Settings['MemberGroup'])); $gresults=mysql_query($gquerys); $yourgroup=mysql_result($gresults,0,"id"); @mysql_free_result($gresults); @@ -666,7 +666,7 @@ if($_POST['MinOffSet']<0) { $_POST['MinOffSet'] = "00"; } $_POST['YourOffSet'] = $_POST['YourOffSet'].":".$_POST['MinOffSet']; $query = query("insert into `".$Settings['sqltable']."members` values (".$yourid.",'%s','%s','%s','%s','%s','%s','%i','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')", array($Name,$NewPassword,"iDBH",$_POST['Email'],$yourgroup,$ValidateStats,"0",$_POST['Interests'],$_POST['Title'],$_POST['Joined'],$_POST['LastActive'],"0",$NewSignature,'Your Notes',$Avatar,"100x100",$Website,$_POST['YourGender'],$_POST['PostCount'],$_POST['YourOffSet'],$_POST['DST'],$Settings['DefaultTheme'],$_POST['UserIP'],$HashSalt)); mysql_query($query); -$querylogr = query("select * from `".$Settings['sqltable']."members` where `Name`='%s' AND `Password`='%s'", array($Name,$NewPassword)); +$querylogr = query("select * from `".$Settings['sqltable']."members` WHERE `Name`='%s' AND `Password`='%s'", array($Name,$NewPassword)); $resultlogr=mysql_query($querylogr); $numlogr=mysql_num_rows($resultlogr); if($numlogr>=1) { @@ -674,7 +674,7 @@ $ir=0; $YourIDMr=mysql_result($resultlogr,$ir,"id"); $YourNameMr=mysql_result($resultlogr,$ir,"Name"); $YourGroupMr=mysql_result($resultlogr,$ir,"GroupID"); -$gquery = query("select * from `".$Settings['sqltable']."groups` where `id`=%i", array($YourGroupMr)); +$gquery = query("select * from `".$Settings['sqltable']."groups` WHERE `id`=%i", array($YourGroupMr)); $gresult=mysql_query($gquery); $YourGroupMr=mysql_result($gresult,0,"Name"); @mysql_free_result($gresult); diff --git a/inc/misc/functions.php b/inc/misc/functions.php index 740bc0d..2d8dd8b 100644 --- a/inc/misc/functions.php +++ b/inc/misc/functions.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: functions.php - Last Update: 07/24/2007 SVN 52 - Author: cooldude2k $ + $FileInfo: functions.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="functions.php"||$File3Name=="/functions.php") { @@ -277,7 +277,7 @@ $phpsrcs = preg_replace("/\/i", "/i", "", $phpsrcs); return $phpsrcs; } function GetUserName($idu,$sqlt) { -$gunquery = query("select * from `".$sqlt."members` where `id`=%i", array($idu)); +$gunquery = query("select * from `".$sqlt."members` WHERE `id`=%i", array($idu)); $gunresult=mysql_query($gunquery); $gunnum=mysql_num_rows($gunresult); if($gunnum>0){ diff --git a/inc/navbar.php b/inc/navbar.php index e8e0be5..50df464 100644 --- a/inc/navbar.php +++ b/inc/navbar.php @@ -11,18 +11,18 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: navbar.php - Last Update: 07/17/2007 SVN 48 - Author: cooldude2k $ + $FileInfo: navbar.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="navbar.php"||$File3Name=="/navbar.php") { require('index.php'); exit(); } if($_SESSION['UserGroup']!=$Settings['GuestGroup']||$GroupInfo['CanPM']=="yes") { -$pmquery1 = query("select * from `".$Settings['sqltable']."messenger` where `PMSentID` = %i and `Read` = 0", array($_SESSION['UserID'])); +$pmquery1 = query("select * from `".$Settings['sqltable']."messenger` WHERE `PMSentID`=%i and `Read`=0", array($_SESSION['UserID'])); $pmresult1=mysql_query($pmquery1); $PMNumber=mysql_num_rows($pmresult1); @mysql_free_result($pmresult1); /* -$pmquery2 = query("select * from `".$Settings['sqltable']."messenger` where `SenderID` = %i and `Read` = 0", array($_SESSION['UserID'])); +$pmquery2 = query("select * from `".$Settings['sqltable']."messenger` WHERE `SenderID`=%i and `Read`=0", array($_SESSION['UserID'])); $pmresult2=mysql_query($pmquery2); $SentPMNumber=mysql_num_rows($pmresult2); @mysql_free_result($pmresult2); */ } diff --git a/inc/pm.php b/inc/pm.php index 62ca146..ceaee14 100644 --- a/inc/pm.php +++ b/inc/pm.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: pm.php - Last Update: 08/02/2007 SVN 61 - Author: cooldude2k $ + $FileInfo: pm.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="pm.php"||$File3Name=="/pm.php") { @@ -61,7 +61,7 @@ if($_GET['act']=="view") { Time Time ".$SentToName.""; } /", "
\n", nl2br($MessageText)); $MessageDesc=mysql_result($result,$is,"Description"); -$requery = query("select * from `".$Settings['sqltable']."members` where `id`=%i", array($SenderID)); +$requery = query("select * from `".$Settings['sqltable']."members` WHERE `id`=%i", array($SenderID)); $reresult=mysql_query($requery); $renum=mysql_num_rows($reresult); $rei=0; @@ -205,7 +205,7 @@ $User1Title=mysql_result($reresult,$rei,"Title"); $User1Joined=mysql_result($reresult,$rei,"Joined"); $User1Joined=GMTimeChange("M j Y",$User1Joined,$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']); $User1GroupID=mysql_result($reresult,$rei,"GroupID"); -$gquery = query("select * from `".$Settings['sqltable']."groups` where `id`=%i", array($User1GroupID)); +$gquery = query("select * from `".$Settings['sqltable']."groups` WHERE `id`=%i", array($User1GroupID)); $gresult=mysql_query($gquery); $User1Group=mysql_result($gresult,0,"Name"); @mysql_free_result($gresult); @@ -299,7 +299,7 @@ echo url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr - + @@ -430,14 +430,14 @@ $_POST['GuestName'] = @remove_spaces($_POST['GuestName']); $_POST['Message'] = stripcslashes(htmlspecialchars($_POST['Message'], ENT_QUOTES)); $_POST['Message'] = preg_replace("/&#(x[a-f0-9]+|[0-9]+);/i", "&#$1;", $_POST['Message']); //$_POST['Message'] = @remove_spaces($_POST['Message']); -$requery = query("select * from `".$Settings['sqltable']."members` where `Name`='%s'", array($_POST['SendMessageTo'])); +$requery = query("select * from `".$Settings['sqltable']."members` WHERE `Name`='%s'", array($_POST['SendMessageTo'])); $reresult=mysql_query($requery); $renum=mysql_num_rows($reresult); $rei=0; while ($rei < $renum) { $SendMessageToID = mysql_result($reresult,$rei,"id"); $SendToGroupID = mysql_result($reresult,$rei,"GroupID"); -$gquery = query("select * from `".$Settings['sqltable']."groups` where `id`=%i", array($SendToGroupID)); +$gquery = query("select * from `".$Settings['sqltable']."groups` WHERE `id`=%i", array($SendToGroupID)); $gresult=mysql_query($gquery); $SendUserCanPM=mysql_result($gresult,0,"CanPM"); $SendUserCanPM = strtolower($SendUserCanPM); diff --git a/inc/prelogin.php b/inc/prelogin.php index 68f6d48..3663100 100644 --- a/inc/prelogin.php +++ b/inc/prelogin.php @@ -11,14 +11,14 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: prelogin.php - Last Update: 07/15/2007 SVN 44 - Author: cooldude2k $ + $FileInfo: prelogin.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="prelogin.php"||$File3Name=="/prelogin.php") { require('index.php'); exit(); } $_SESSION['CheckCookie']="done"; -$querylog2 = query("select * from `".$Settings['sqltable']."members` where `Name` = '%s' and `Password`='%s'", array($_COOKIE['MemberName'],$_COOKIE['SessPass'])); +$querylog2 = query("select * from `".$Settings['sqltable']."members` WHERE `Name`='%s' AND `Password`='%s'", array($_COOKIE['MemberName'],$_COOKIE['SessPass'])); $resultlog2=mysql_query($querylog2); $numlog2=mysql_num_rows($resultlog2); if($numlog2>=1) { @@ -26,7 +26,7 @@ $il=0; $YourIDAM=mysql_result($resultlog2,$il,"id"); $YourGroupAM=mysql_result($resultlog2,$il,"GroupID"); $YourPassAM=mysql_result($resultlog2,$il,"Password"); -$gquery = query("select * from `".$Settings['sqltable']."groups` where `id`=%i", array($YourGroupAM)); +$gquery = query("select * from `".$Settings['sqltable']."groups` WHERE `id`=%i", array($YourGroupAM)); $gresult=mysql_query($gquery); $YourGroupAM=mysql_result($gresult,0,"Name"); @mysql_free_result($gresult); @@ -35,7 +35,7 @@ $UseThemeAM=mysql_result($resultlog2,$il,"UseTheme"); $YourDSTAM=mysql_result($resultlog2,$il,"DST"); $NewDay=GMTimeStamp(); $NewIP=$_SERVER['REMOTE_ADDR']; -$queryup = query("update `".$Settings['sqltable']."members` set `LastActive`='%s',`IP`='%s' WHERE `id`='%s'", array($NewDay,$NewIP,$YourIDAM)); +$queryup = query("update `".$Settings['sqltable']."members` set `LastActive`=%i,`IP`='%s' WHERE `id`=%i", array($NewDay,$NewIP,$YourIDAM)); $_SESSION['Theme']=$UseThemeAM; $_SESSION['MemberName']=$_COOKIE['MemberName']; $_SESSION['UserID']=$YourIDAM; diff --git a/inc/profilemain.php b/inc/profilemain.php index e5e500e..86d74f2 100644 --- a/inc/profilemain.php +++ b/inc/profilemain.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: profilemain.php - Last Update: 07/15/2007 SVN 44 - Author: cooldude2k $ + $FileInfo: profilemain.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="profilemain.php"||$File3Name=="/profilemain.php") { @@ -81,7 +81,7 @@ $profiletitle = " ".$ThemeSet['TitleDivider']." NotePad";
Profile updated click here to go back. ^_^
  if ($Error!="Yes") { setcookie("SessPass", $NewPassword, time() + (7 * 86400), $basedir); $_POST['Email'] = @remove_spaces($_POST['Email']); - $querynewuserinfo = query("update `".$Settings['sqltable']."members` set `Password`='%s',`HashType`='iDBH',`Email`='%s',`LastActive`='%s',`IP`='%s',`Salt`='%s' WHERE `id`=%i", array($NewPassword,$_POST['Email'],$NewDay,$NewIP,$NewSalt,$_SESSION['UserID'])); + $querynewuserinfo = query("update `".$Settings['sqltable']."members` set `Password`='%s',`HashType`='iDBH',`Email`='%s',`LastActive`=%i,`IP`='%s',`Salt`='%s' WHERE `id`=%i", array($NewPassword,$_POST['Email'],$NewDay,$NewIP,$NewSalt,$_SESSION['UserID'])); mysql_query($querynewuserinfo); } } } } ?>   /", "
\n", nl2br($MyPost)); $MyDescription=mysql_result($result,$i,"Description"); -$requery = query("select * from `".$Settings['sqltable']."members` where `id`=%i", array($MyUserID)); +$requery = query("select * from `".$Settings['sqltable']."members` WHERE `id`=%i", array($MyUserID)); $reresult=mysql_query($requery); $renum=mysql_num_rows($reresult); $rei=0; @@ -114,7 +114,7 @@ $User1Title=mysql_result($reresult,$rei,"Title"); $User1Joined=mysql_result($reresult,$rei,"Joined"); $User1Joined=GMTimeChange("M j Y",$User1Joined,$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']); $User1GroupID=mysql_result($reresult,$rei,"GroupID"); -$gquery = query("select * from `".$Settings['sqltable']."groups` where `id`=%i", array($User1GroupID)); +$gquery = query("select * from `".$Settings['sqltable']."groups` WHERE `id`=%i", array($User1GroupID)); $gresult=mysql_query($gquery); $User1Group=mysql_result($gresult,0,"Name"); @mysql_free_result($gresult); @@ -134,7 +134,7 @@ if($User1Name=="Guest") { $User1Name=$GuestName; if($User1Name==null) { $User1Name="Guest"; } } $MySubPost = null; if($MyEditTime!=$MyTimeStamp&&$MyEditUserID!=0) { -$euquery = query("select * from `".$Settings['sqltable']."members` where `id`=%i", array($MyEditUserID)); +$euquery = query("select * from `".$Settings['sqltable']."members` WHERE `id`=%i", array($MyEditUserID)); $euresult = mysql_query($euquery); $eunum = mysql_num_rows($euresult); $eui=0; while ($eui < $eunum) { @@ -174,7 +174,7 @@ echo "".$User1Name.""; } Time Posted: -
".$ThemeSet['EditReply']; ?>".$ThemeSet['DeleteReply']; ?> 
+
".$ThemeSet['EditReply']; ?>".$ThemeSet['DeleteReply']; ?> 
@@ -264,6 +264,7 @@ gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); }   +
 
  +
 
  + +
+ + + + + + + + + + + + +
+"> + "; ?>
Editing a Reply in Topic
+
"> + + + + + + + + + + + + +
+ + +
+
+
+ + + + + + +
+
 
+
 
+ +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+"> + "; ?>
 Edit Reply Message:
+
Your Reply Description is too big.
+
+
You Guest Name is too big.
+
+
You Topic Name is too big.
+
+
Sorry the referering url dose not match our host name.
+
+
You need to enter a Reply Description.
+
+
You need to enter a Guest Name.
+
+
You do not have permission to edit a reply here.
+
+
You need to enter a Topic Name.
+
+
You need to enter a Reply.
+

+ Reply to Topic was edited.
+ Click ">here to view topic.
  +
 
diff --git a/inc/rssfeed.php b/inc/rssfeed.php index 92630ab..13e5e93 100644 --- a/inc/rssfeed.php +++ b/inc/rssfeed.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: rss2.php - Last Update: 07/15/2007 SVN 44 - Author: cooldude2k $ + $FileInfo: rss2.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="rssfeed.php"||$File3Name=="/rssfeed.php") { @@ -67,7 +67,7 @@ else { if (stristr($_SERVER["HTTP_USER_AGENT"],"FeedValidator")) { } else { @header("Content-Type: text/xml; charset=".$Settings['charset']); } } } @header("Content-Language: en"); @header("Vary: Accept"); -$query = query("select * from `".$Settings['sqltable']."topics` where `ForumID`=%i ORDER BY `Pinned` DESC, `LastUpdate` DESC", array($_GET['id'])); +$query = query("select * from `".$Settings['sqltable']."topics` WHERE `ForumID`=%i ORDER BY `Pinned` DESC, `LastUpdate` DESC", array($_GET['id'])); $result=mysql_query($query); $num=mysql_num_rows($result); $Atom = null; $RSS = null; $i=0; diff --git a/inc/searchs.php b/inc/searchs.php index 0e24e12..4778de7 100644 --- a/inc/searchs.php +++ b/inc/searchs.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: searchs.php - Last Update: 07/17/2007 SVN 46 - Author: cooldude2k $ + $FileInfo: searchs.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="searchs.php"||$File3Name=="/searchs.php") { @@ -67,9 +67,9 @@ if($_GET['act']=="topics") {
0){ diff --git a/inc/stats.php b/inc/stats.php index 494b61d..e921aa2 100644 --- a/inc/stats.php +++ b/inc/stats.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: stats.php - Last Update: 07/15/2007 SVN 45 - Author: cooldude2k $ + $FileInfo: stats.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="stats.php"||$File3Name=="/stats.php") { @@ -31,7 +31,7 @@ $NewestMem = array(null); $NewestMem['ID']=mysql_result($nmresult,$nummembers-1,"id"); $NewestMem['Name']=mysql_result($nmresult,$nummembers-1,"Name"); if($NewestMem['ID']=="-1") { $NewestMem['ID'] = "0"; $NewestMem['Name'] = "Cool Dude 2k"; } -$sql_guest_check = mysql_query(query("select * from `".$Settings['sqltable']."members` where `id` = '%s'", array("-1"))); +$sql_guest_check = mysql_query(query("select * from `".$Settings['sqltable']."members` WHERE `id`=%i", array("-1"))); $guest_check = mysql_num_rows($sql_guest_check); @mysql_free_result($sql_guest_check); if($guest_check > 0) { $nummembers = $nummembers - 1; } ?> diff --git a/inc/subcategories.php b/inc/subcategories.php index 13303df..74c0b3b 100644 --- a/inc/subcategories.php +++ b/inc/subcategories.php @@ -11,13 +11,13 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: subcategories.php - Last Update: 08/01/2007 SVN 60 - Author: cooldude2k $ + $FileInfo: subcategories.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="subcategories.php"||$File3Name=="/subcategories.php") { require('index.php'); exit(); } -$checkquery = query("select * from `".$Settings['sqltable']."categories` where `id`=%s", array($_GET['id'])); +$checkquery = query("select * from `".$Settings['sqltable']."categories` WHERE `id`=%i", array($_GET['id'])); $checkresult=mysql_query($checkquery); $checknum=mysql_num_rows($checkresult); $checki=0; @@ -44,7 +44,7 @@ redirect("location",$basedir.url_maker($exfile['category'],$Settings['file_ext'] ob_clean(); @header("Content-Type: text/plain; charset=".$Settings['charset']); gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } @mysql_free_result($checkresult); -$prequery = query("select * from `".$Settings['sqltable']."categories` where `ShowCategory`='yes' and `InSubCategory`=%i", array($_GET['id'])); +$prequery = query("select * from `".$Settings['sqltable']."categories` WHERE `ShowCategory`='yes' AND `InSubCategory`=%i", array($_GET['id'])); $preresult=mysql_query($prequery); $prenum=mysql_num_rows($preresult); $prei=0; @@ -58,7 +58,7 @@ $CategoryDescription=mysql_result($preresult,$prei,"Description"); $CategoryType = strtolower($CategoryType); $SubShowForums = strtolower($SubShowForums); if(isset($CatPermissionInfo['CanViewCategory'][$CategoryID])&& $CatPermissionInfo['CanViewCategory'][$CategoryID]=="yes") { -$query = query("select * from `".$Settings['sqltable']."forums` where `ShowForum`='yes' and `CategoryID`=%i and `InSubForum`=0 ORDER BY `id`", array($CategoryID)); +$query = query("select * from `".$Settings['sqltable']."forums` WHERE `ShowForum`='yes' AND `CategoryID`=%i AND `InSubForum`=0 ORDER BY `id`", array($CategoryID)); $result=mysql_query($query); $num=mysql_num_rows($result); $i=0; @@ -90,7 +90,7 @@ $ForumDescription=mysql_result($result,$i,"Description"); $ForumType = strtolower($ForumType); $gltf = array(null); $gltf[0] = $ForumID; if ($ForumType=="subforum") { -$apcquery = query("select * from `".$Settings['sqltable']."forums` where `ShowForum`='yes' and `InSubForum`=%i ORDER BY `id`", array($ForumID)); +$apcquery = query("select * from `".$Settings['sqltable']."forums` WHERE `ShowForum`='yes' AND `InSubForum`=%i ORDER BY `id`", array($ForumID)); $apcresult=mysql_query($apcquery); $apcnum=mysql_num_rows($apcresult); $apci=0; if($apcnum>=1) { @@ -111,7 +111,7 @@ $gltnum = count($gltf); $glti = 0; $OldUpdateTime = 0; $UseThisFonum = null; if ($ForumType=="subforum") { while ($glti < $gltnum) { -$gltfoquery = query("select * from `".$Settings['sqltable']."topics` where `CategoryID`=%i and `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$gltf[$glti])); +$gltfoquery = query("select * from `".$Settings['sqltable']."topics` WHERE `CategoryID`=%i AND `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$gltf[$glti])); $gltforesult=mysql_query($gltfoquery); $gltfonum=mysql_num_rows($gltforesult); if($gltfonum>0) { @@ -122,7 +122,7 @@ $OldUpdateTime = $NewUpdateTime; } } @mysql_free_result($gltforesult); ++$glti; } } if ($ForumType!="subforum") { $UseThisFonum = $gltf['0']; } -$gltquery = query("select * from `".$Settings['sqltable']."topics` where `CategoryID`=%i and `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$UseThisFonum)); +$gltquery = query("select * from `".$Settings['sqltable']."topics` WHERE `CategoryID`=%i AND `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$UseThisFonum)); $gltresult=mysql_query($gltquery); $gltnum=mysql_num_rows($gltresult); if($gltnum>0){ diff --git a/inc/subforums.php b/inc/subforums.php index f8838ae..477f593 100644 --- a/inc/subforums.php +++ b/inc/subforums.php @@ -11,13 +11,13 @@ Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/ Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/ - $FileInfo: subforums.php - Last Update: 08/01/2007 SVN 60 - Author: cooldude2k $ + $FileInfo: subforums.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="subforums.php"||$File3Name=="/subforums.php") { require('index.php'); exit(); } -$checkquery = query("select * from `".$Settings['sqltable']."forums` where `id`=%s", array($_GET['id'])); +$checkquery = query("select * from `".$Settings['sqltable']."forums` WHERE `id`=%i", array($_GET['id'])); $checkresult=mysql_query($checkquery); $checknum=mysql_num_rows($checkresult); $checki=0; @@ -53,7 +53,7 @@ redirect("location",$basedir.url_maker($exfile['forum'],$Settings['file_ext'],"a ob_clean(); @header("Content-Type: text/plain; charset=".$Settings['charset']); gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } @mysql_free_result($checkresult); -$prequery = query("select * from `".$Settings['sqltable']."categories` where `ShowCategory`='yes' and `id`=%i ORDER BY `id`", array($CategoryID)); +$prequery = query("select * from `".$Settings['sqltable']."categories` WHERE `ShowCategory`='yes' AND `id`=%i ORDER BY `id`", array($CategoryID)); $preresult=mysql_query($prequery); $prenum=mysql_num_rows($preresult); $prei=0; @@ -70,7 +70,7 @@ redirect("location",$basedir.url_maker($exfile['index'],$Settings['file_ext'],"a ob_clean(); @header("Content-Type: text/plain; charset=".$Settings['charset']); gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } if($CatPermissionInfo['CanViewCategory'][$CategoryID]=="yes") { -$query = query("select * from `".$Settings['sqltable']."forums` where `ShowForum`='yes' and `CategoryID`=%i and `InSubForum`=%i ORDER BY `id`", array($CategoryID,$_GET['id'])); +$query = query("select * from `".$Settings['sqltable']."forums` WHERE `ShowForum`='yes' AND `CategoryID`=%i AND `InSubForum`=%i ORDER BY `id`", array($CategoryID,$_GET['id'])); $result=mysql_query($query); $num=mysql_num_rows($result); $i=0; @@ -101,7 +101,7 @@ $ForumDescription=mysql_result($result,$i,"Description"); $ForumType = strtolower($ForumType); $gltf = array(null); $gltf[0] = $ForumID; if ($ForumType=="subforum") { -$apcquery = query("select * from `".$Settings['sqltable']."forums` where `ShowForum`='yes' and `InSubForum`=%i ORDER BY `id`", array($ForumID)); +$apcquery = query("select * from `".$Settings['sqltable']."forums` WHERE `ShowForum`='yes' AND `InSubForum`=%i ORDER BY `id`", array($ForumID)); $apcresult=mysql_query($apcquery); $apcnum=mysql_num_rows($apcresult); $apci=0; if($apcnum>=1) { @@ -122,7 +122,7 @@ $gltnum = count($gltf); $glti = 0; $OldUpdateTime = 0; $UseThisFonum = null; if ($ForumType=="subforum") { while ($glti < $gltnum) { -$gltfoquery = query("select * from `".$Settings['sqltable']."topics` where `CategoryID`=%i and `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$gltf[$glti])); +$gltfoquery = query("select * from `".$Settings['sqltable']."topics` WHERE `CategoryID`=%i AND `ForumID`=%i ORDER BY `LastUpdate` DESC", array($CategoryID,$gltf[$glti])); $gltforesult=mysql_query($gltfoquery); $gltfonum=mysql_num_rows($gltforesult); if($gltfonum>0) { @@ -133,7 +133,7 @@ $OldUpdateTime = $NewUpdateTime; } } @mysql_free_result($gltforesult); ++$glti; } } if ($ForumType!="subforum") { $UseThisFonum = $gltf['0']; } -$gltquery = query("select * from `".$Settings['sqltable']."topics` where `ForumID`=%i ORDER BY `LastUpdate` DESC", array($UseThisFonum)); +$gltquery = query("select * from `".$Settings['sqltable']."topics` WHERE `ForumID`=%i ORDER BY `LastUpdate` DESC", array($UseThisFonum)); $gltresult=mysql_query($gltquery); $gltnum=mysql_num_rows($gltresult); if($gltnum>0){ diff --git a/inc/topics.php b/inc/topics.php index 05ac9b4..317973e 100644 --- a/inc/topics.php +++ b/inc/topics.php @@ -11,13 +11,13 @@ 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/02/2007 SVN 61 - Author: cooldude2k $ + $FileInfo: topics.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="topics.php"||$File3Name=="/topics.php") { require('index.php'); exit(); } -$prequery = query("select * from `".$Settings['sqltable']."forums` where `id`=%s", array($_GET['id'])); +$prequery = query("select * from `".$Settings['sqltable']."forums` WHERE `id`=%i", array($_GET['id'])); $preresult=mysql_query($prequery); $prenum=mysql_num_rows($preresult); $prei=0; @@ -60,12 +60,12 @@ if($CatPermissionInfo['CanViewCategory'][$ForumCatID]=="yes"&& if($ForumType!="redirect") { if($NumberViews==0||$NumberViews==null) { $NewNumberViews = 1; } if($NumberViews!=0&&$NumberViews!=null) { $NewNumberViews = $NumberViews + 1; } -$viewup = query("update `".$Settings['sqltable']."forums` set `NumViews`='%s' WHERE `id`=%i", array($NewNumberViews,$_GET['id'])); +$viewup = query("update `".$Settings['sqltable']."forums` set `NumViews`=%i WHERE `id`=%i", array($NewNumberViews,$_GET['id'])); mysql_query($viewup); } if($ForumType=="redirect") { if($RedirectTimes==0||$RedirectTimes==null) { $NewRedirTime = 1; } if($RedirectTimes!=0&&$RedirectTimes!=null) { $NewRedirTime = $RedirectTimes + 1; } -$redirup = query("update `".$Settings['sqltable']."forums` set `Redirects`='%s' WHERE `id`=%i", array($NewRedirTime,$_GET['id'])); +$redirup = query("update `".$Settings['sqltable']."forums` set `Redirects`=%i WHERE `id`=%i", array($NewRedirTime,$_GET['id'])); mysql_query($redirup); if($RedirectURL!="http://"&&$RedirectURL!="") { redirect("location",$RedirectURL,0,null,false); ob_clean(); @@ -93,7 +93,7 @@ gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } }
 
0){ @@ -221,7 +221,7 @@ gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } @@ -259,6 +259,7 @@ gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); }
-#"> +">  "; ?>
 
+
 
-#"> +">  "; ?> @@ -357,7 +358,7 @@ if ($_POST['TopicName']==null) { $Error="Yes"; ?> if ($Error!="Yes") { $LastActive = GMTimeStamp(); $topicid = getnextid($Settings['sqltable'],"topics"); $postid = getnextid($Settings['sqltable'],"posts"); -$requery = query("select * from `".$Settings['sqltable']."members` where `id`=%i", array($_SESSION['UserID'])); +$requery = query("select * from `".$Settings['sqltable']."members` WHERE `id`=%i", array($_SESSION['UserID'])); $reresult=mysql_query($requery); $renum=mysql_num_rows($reresult); $rei=0; @@ -371,7 +372,7 @@ $User1GroupID=mysql_result($reresult,$rei,"GroupID"); $PostCount=mysql_result($reresult,$rei,"PostCount"); if($PostCountAdd=="on") { $NewPostCount = $PostCount + 1; } if(!isset($NewPostCount)) { $NewPostCount = $PostCount; } -$gquery = query("select * from `".$Settings['sqltable']."groups` where `id`=%i", array($User1GroupID)); +$gquery = query("select * from `".$Settings['sqltable']."groups` WHERE `id`=%i", array($User1GroupID)); $gresult=mysql_query($gquery); $User1Group=mysql_result($gresult,0,"Name"); @mysql_free_result($gresult); @@ -398,6 +399,7 @@ mysql_query($queryupd);   +
 
 
diff --git a/inc/versioninfo.php b/inc/versioninfo.php index 242a143..ded08ac 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/02/2007 SVN 61 - Author: cooldude2k $ + $FileInfo: versioninfo.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="versioninfo.php"||$File3Name=="/versioninfo.php") { @@ -27,7 +27,7 @@ function version_info($proname,$subver,$ver,$supver,$reltype,$svnver,$showsvn) { return $return_var; } // Version number and date stuff. :P $VER1[0] = 0; $VER1[1] = 1; $VER1[2] = 6; $VERFull[1] = $VER1[0].".".$VER1[1].".".$VER1[2]; -$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 61; $RName = "iDB"; $SFName = "IntDB"; +$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 62; $RName = "iDB"; $SFName = "IntDB"; $SVNDay[0] = 08; $SVNDay[1] = 02; $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); diff --git a/topic.php b/topic.php index 6ae84bd..7d9e413 100644 --- a/topic.php +++ b/topic.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: topic.php - Last Update: 07/31/2007 SVN 57 - Author: cooldude2k $ + $FileInfo: topic.php - Last Update: 08/02/2007 SVN 62 - Author: cooldude2k $ */ require('preindex.php'); $usefileext = $Settings['file_ext']; @@ -28,7 +28,8 @@ if($_GET['act']==null) if(!is_numeric($_GET['id'])) { $_GET['id']="1"; } if($_GET['act']=="view"||$_GET['act']=="create"||$_GET['act']=="delete"|| - $_GET['act']=="makereply"||$_POST['act']=="makereplies") + $_GET['act']=="edit"||$_GET['act']=="makereply"||$_POST['act']=="makereplies"|| + $_GET['act']=="editreply"||$_POST['act']=="editreplies") { require($SettDir['inc'].'replys.php'); } require($SettDir['inc'].'endpage.php'); if(!isset($TopicName)) { $TopicName = null; } @@ -41,8 +42,12 @@ if($_GET['act']=="view") { change_title($Settings['board_name']." ".$ThemeSet['TitleDivider']." Viewing Topic ".$TopicName,$Settings['use_gzip'],$GZipEncode['Type']); } if($_GET['act']=="create") { change_title($Settings['board_name']." ".$ThemeSet['TitleDivider']." Making Reply in Topic ".$TopicName,$Settings['use_gzip'],$GZipEncode['Type']); } -if($_GET['act']=="create") { +if($_GET['act']=="delete") { change_title($Settings['board_name']." ".$ThemeSet['TitleDivider']." Deleting Reply in Topic ".$TopicName,$Settings['use_gzip'],$GZipEncode['Type']); } -if($_GET['act']=="maketopic"&&$_POST['act']=="maketopics") { +if($_GET['act']=="edit") { +change_title($Settings['board_name']." ".$ThemeSet['TitleDivider']." Editing Reply in Topic ".$TopicName,$Settings['use_gzip'],$GZipEncode['Type']); } +if($_GET['act']=="editreply"&&$_POST['act']=="editreplies") { +change_title($Settings['board_name']." ".$ThemeSet['TitleDivider']." Editing Reply in Topic ".$TopicName,$Settings['use_gzip'],$GZipEncode['Type']); } +if($_GET['act']=="makereply"&&$_POST['act']=="makereplies") { change_title($Settings['board_name']." ".$ThemeSet['TitleDivider']." Making Reply in Topic ".$TopicName,$Settings['use_gzip'],$GZipEncode['Type']); } ?> -- 2.11.0