From efeb938f9cb0cfd17735047d6a620b699beed1f0 Mon Sep 17 00:00:00 2001 From: Kazuki Przyborowski Date: Sat, 11 Aug 2007 07:32:46 +0000 Subject: [PATCH] Small bug fixes and added user info checker. :P git-svn-id: svn://svn.code.sf.net/p/intdb/svn/trunk@75 2b68903e-0b30-0410-9a39-a2e4f3c5be39 --- inc/categories.php | 6 +++--- inc/forums.php | 6 +++--- inc/groupsetup.php | 41 ++++++++++++++++++++++++++++++++++++++++- inc/members.php | 18 +++++++++++------- inc/prelogin.php | 32 +++++++++++++++++++------------- inc/profilemain.php | 4 ++-- inc/replys.php | 17 +++++++++-------- inc/subcategories.php | 6 +++--- inc/subforums.php | 4 ++-- inc/versioninfo.php | 6 +++--- 10 files changed, 95 insertions(+), 45 deletions(-) diff --git a/inc/categories.php b/inc/categories.php index cc7a35b..1d9910b 100644 --- a/inc/categories.php +++ b/inc/categories.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: categories.php - Last Update: 08/09/2007 SVN 73 - Author: cooldude2k $ + $FileInfo: categories.php - Last Update: 08/11/2007 SVN 75 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="categories.php"||$File3Name=="/categories.php") { @@ -133,9 +133,9 @@ $oldtopicname=$TopicName; $oldusername=$UsersName; $TopicName=$TopicName1; $UsersName=$UsersName1; } $lul = null; if($UsersID!="-1") { $lul = url_maker($exfile['member'],$Settings['file_ext'],"act=view&id=".$UsersID,$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member']); -$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } +$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } if($UsersID=="-1") { -$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } } +$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } } if($LastTopic==null) { $LastTopic=" 
 "; } } @mysql_free_result($gltresult); if ($ForumType=="redirect") { $LastTopic="Redirects: ".$NumRedirects; } diff --git a/inc/forums.php b/inc/forums.php index ad22161..325330a 100644 --- a/inc/forums.php +++ b/inc/forums.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: forums.php - Last Update: 08/09/2007 SVN 73 - Author: cooldude2k $ + $FileInfo: forums.php - Last Update: 08/11/2007 SVN 75 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="forums.php"||$File3Name=="/forums.php") { @@ -119,9 +119,9 @@ $oldtopicname=$TopicName; $oldusername=$UsersName; $TopicName=$TopicName1; $UsersName=$UsersName1; } $lul = null; if($UsersID!="-1") { $lul = url_maker($exfile['member'],$Settings['file_ext'],"act=view&id=".$UsersID,$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member']); -$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } +$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } if($UsersID=="-1") { -$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } } +$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } } if($LastTopic==null) { $LastTopic=" 
 "; } } @mysql_free_result($gltresult); if ($ForumType=="redirect") { $LastTopic="Redirects: ".$NumRedirects; } diff --git a/inc/groupsetup.php b/inc/groupsetup.php index 393e250..175fff6 100644 --- a/inc/groupsetup.php +++ b/inc/groupsetup.php @@ -11,12 +11,51 @@ 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: 08/09/2007 SVN 73 - Author: cooldude2k $ + $FileInfo: groupsetup.php - Last Update: 08/11/2007 SVN 75 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="groupsetup.php"||$File3Name=="/groupsetup.php") { require('index.php'); exit(); } +// Check to make sure MemberInfo is right +if($_SESSION['UserID']!=0&&$_SESSION['UserID']!=null) { +$kgbquerychkusr = query("SELECT * FROM `".$Settings['sqltable']."members` WHERE `Name`='%s' AND `Password`='%s' AND `id`=%i", array($_SESSION['MemberName'],$_SESSION['UserPass'],$_SESSION['UserID'])); +$resultchkusr=mysql_query($kgbquerychkusr); +$numchkusr=mysql_num_rows($resultchkusr); +if($numchkusr==1) { +$ChkUsrID=mysql_result($resultchkusr,0,"id"); +$ChkUsrName=mysql_result($resultchkusr,0,"Name"); +$ChkUsrGroup=mysql_result($resultchkusr,0,"GroupID"); +$ChkUsrPass=mysql_result($resultchkusr,0,"Password"); +$ChkUsrTimeZone=mysql_result($resultchkusr,0,"TimeZone"); +$ChkUsrTheme=mysql_result($resultchkusr,0,"UseTheme"); +$ChkUsrDST=mysql_result($resultchkusr,0,"DST"); +$svrquery = query("SELECT * FROM `".$Settings['sqltable']."groups` WHERE `id`=%i", array($ChkUsrGroup)); +$svrgresultkgb=mysql_query($svrquery); +$ChkUsrGroup=mysql_result($svrgresultkgb,0,"Name"); +$_SESSION['Theme']=$ChkUsrTheme; +$_SESSION['MemberName']=$ChkUsrName; +$_SESSION['UserID']=$ChkUsrID; +$_SESSION['UserTimeZone']=$ChkUsrTimeZone; +$_SESSION['UserGroup']=$ChkUsrGroup; +$_SESSION['UserDST']=$ChkUsrDST; +$_SESSION['UserPass']=$ChkUsrPass; } +if($numchkusr<=0||$numchkusr>1) { @session_unset(); +@setcookie("MemberName", null, GMTimeStamp() - 3600, $basedir); +@setcookie("UserID", null, GMTimeStamp() - 3600, $basedir); +@setcookie("SessPass", null, GMTimeStamp() - 3600, $basedir); +@setcookie(session_name(), "", GMTimeStamp() - 3600, $basedir); +unset($_COOKIE[session_name()]); +$_SESSION = array(); @session_unset(); @session_destroy(); +@redirect("location",$basedir.url_maker($exfile['member'],$Settings['file_ext'],"act=login",$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member'],false)); @mysql_free_result($numchkusr); @mysql_free_result($svrgresultkgb); +ob_clean(); @header("Content-Type: text/plain; charset=".$Settings['charset']); +gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } +@mysql_free_result($numchkusr); @mysql_free_result($svrgresultkgb); } +if($_SESSION['UserID']==0||$_SESSION['UserID']==null) { +$_SESSION['MemberName'] = null; +$_SESSION['UserGroup'] = $Settings['GuestGroup']; } +if($_SESSION['MemberName']==null) { $_SESSION['UserID'] = "0"; +$_SESSION['UserGroup'] = $Settings['GuestGroup']; } // Member Group Setup if(!isset($_SESSION['UserGroup'])) { $_SESSION['UserGroup'] = null; } if($_SESSION['UserGroup']==null) { diff --git a/inc/members.php b/inc/members.php index 96a7c6f..95bb406 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: 08/09/2007 SVN 73 - Author: cooldude2k $ + $FileInfo: members.php - Last Update: 08/11/2007 SVN 75 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="members.php"||$File3Name=="/members.php") { @@ -375,6 +375,7 @@ $_SESSION['UserID']=$YourIDM; $_SESSION['UserTimeZone']=$YourTimeZoneM; $_SESSION['UserGroup']=$YourGroupM; $_SESSION['UserDST']=$YourDSTM; +$_SESSION['UserPass']=$NewPassword; if($_POST['storecookie']==true) { setcookie("MemberName", $YourNameM, time() + (7 * 86400), $basedir); setcookie("UserID", $YourIDM, time() + (7 * 86400), $basedir); @@ -683,18 +684,21 @@ $_SESSION['UserID']=$YourIDMr; $_SESSION['UserTimeZone']=$YourTimeZoneMr; $_SESSION['UserDST']=$YourDSTMr; $_SESSION['UserGroup']=$YourGroupMr; +$_SESSION['UserPass']=$YourPassM; if($_POST['storecookie']==true) { @setcookie("MemberName", $YourNameM, time() + (7 * 86400), $basedir); @setcookie("UserID", $YourIDM, time() + (7 * 86400), $basedir); @setcookie("SessPass", $YourPassM, time() + (7 * 86400), $basedir); } -//$SendPMtoID=$_SESSION['UserID']; -//$YourPMID = 1; -//$PMTitle = "Welcome ".$Name."."; -//$YourMessage = "Hello ".$Name.". Welcome to ".$Settings['board_name'].". I hope you have fun here. ^_^ "; -//$_POST['YourDate'] = $_POST['Joined']; -//$query = query("INSERT INTO `".$Settings['sqltable']."messenger` VALUES (null,'%s','%s','%s','%s','%s','%s',0)", array($YourPMID,$SendPMtoID,'',$PMTitle,$YourMessage,$_POST['YourDate'])); +/* +$SendPMtoID=$_SESSION['UserID']; +$YourPMID = 1; +$PMTitle = "Welcome ".$Name."."; +$YourMessage = "Hello ".$Name.". Welcome to ".$Settings['board_name'].". I hope you enjoy your stay here. ^_^ "; +$_POST['YourDate'] = $_POST['Joined']; +$query = query("INSERT INTO `".$Settings['sqltable']."messenger` VALUES (null,%i,%i,'%s','%s','%s','%s',0)", array($YourPMID,$SendPMtoID,'',$PMTitle,$YourMessage,$_POST['YourDate'])); //mysql_query($query); @redirect("refresh",$basedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],FALSE),"3"); +*/ ?> diff --git a/inc/prelogin.php b/inc/prelogin.php index 99d71af..075c7b1 100644 --- a/inc/prelogin.php +++ b/inc/prelogin.php @@ -11,28 +11,27 @@ 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: 08/09/2007 SVN 73 - Author: cooldude2k $ + $FileInfo: prelogin.php - Last Update: 08/11/2007 SVN 75 - 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' AND `id`=%i", array($_COOKIE['MemberName'],$_COOKIE['SessPass'],$_COOKIE['UserID'])); $resultlog2=mysql_query($querylog2); $numlog2=mysql_num_rows($resultlog2); -if($numlog2>=1) { -$il=0; -$YourIDAM=mysql_result($resultlog2,$il,"id"); -$YourGroupAM=mysql_result($resultlog2,$il,"GroupID"); -$YourPassAM=mysql_result($resultlog2,$il,"Password"); +if($numlog2==1) { +$YourIDAM=mysql_result($resultlog2,0,"id"); +$YourGroupAM=mysql_result($resultlog2,0,"GroupID"); +$YourPassAM=mysql_result($resultlog2,0,"Password"); $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); -$YourTimeZoneAM=mysql_result($resultlog2,$il,"TimeZone"); -$UseThemeAM=mysql_result($resultlog2,$il,"UseTheme"); -$YourDSTAM=mysql_result($resultlog2,$il,"DST"); +$YourTimeZoneAM=mysql_result($resultlog2,0,"TimeZone"); +$UseThemeAM=mysql_result($resultlog2,0,"UseTheme"); +$YourDSTAM=mysql_result($resultlog2,0,"DST"); $NewDay=GMTimeStamp(); $NewIP=$_SERVER['REMOTE_ADDR']; $queryup = query("UPDATE `".$Settings['sqltable']."members` SET `LastActive`=%i,`IP`='%s' WHERE `id`=%i", array($NewDay,$NewIP,$YourIDAM)); @@ -42,12 +41,19 @@ $_SESSION['UserID']=$YourIDAM; $_SESSION['UserTimeZone']=$YourTimeZoneAM; $_SESSION['UserGroup']=$YourGroupAM; $_SESSION['UserDST']=$YourDSTAM; +$_SESSION['UserPass']=$YourPassAM; setcookie("MemberName", $YourNameM, time() + (7 * 86400), $basedir); setcookie("UserID", $YourIDAM, time() + (7 * 86400), $basedir); setcookie("SessPass", $YourPassAM, time() + (7 * 86400), $basedir); -} if($numlog2<=0) { -redirect("location",$basedir.url_maker($exfile['member'],$Settings['file_ext'],"act=logout",$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member'],FALSE)); +} if($numlog2<=0||$numlog2>1) { @session_unset(); +@setcookie("MemberName", null, GMTimeStamp() - 3600, $basedir); +@setcookie("UserID", null, GMTimeStamp() - 3600, $basedir); +@setcookie("SessPass", null, GMTimeStamp() - 3600, $basedir); +@setcookie(session_name(), "", GMTimeStamp() - 3600, $basedir); +unset($_COOKIE[session_name()]); +$_SESSION = array(); @session_unset(); @session_destroy(); +@redirect("location",$basedir.url_maker($exfile['member'],$Settings['file_ext'],"act=login",$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member'],false)); @mysql_free_result($resultlog2); @mysql_free_result($gresult); ob_clean(); @header("Content-Type: text/plain; charset=".$Settings['charset']); gzip_page($Settings['use_gzip'],$GZipEncode['Type']); @mysql_close(); die(); } -@mysql_free_result($resultlog2); +@mysql_free_result($resultlog2); @mysql_free_result($gresult); ?> diff --git a/inc/profilemain.php b/inc/profilemain.php index c1407b8..2beeb38 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: 08/09/2007 SVN 73 - Author: cooldude2k $ + $FileInfo: profilemain.php - Last Update: 08/11/2007 SVN 75 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="profilemain.php"||$File3Name=="/profilemain.php") { @@ -584,7 +584,7 @@ if($YourPassword!=$OldPassword) { $Error="Yes"; ?>
- @@ -176,8 +177,8 @@ if($User1ID=="-1") { echo "".$User1Name.""; } ?> @@ -752,7 +753,7 @@ if ($_POST['ReplyDesc']==null) { $Error="Yes"; ?> diff --git a/inc/subcategories.php b/inc/subcategories.php index cd8ec36..7997704 100644 --- a/inc/subcategories.php +++ b/inc/subcategories.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: subcategories.php - Last Update: 08/09/2007 SVN 73 - Author: cooldude2k $ + $FileInfo: subcategories.php - Last Update: 08/11/2007 SVN 75 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="subcategories.php"||$File3Name=="/subcategories.php") { @@ -146,9 +146,9 @@ $oldtopicname=$TopicName; $oldusername=$UsersName; $TopicName=$TopicName1; $UsersName=$UsersName1; } $lul = null; if($UsersID!="-1") { $lul = url_maker($exfile['member'],$Settings['file_ext'],"act=view&id=".$UsersID,$Settings['qstr'],$Settings['qsep'],$prexqstr['member'],$exqstr['member']); -$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } +$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } if($UsersID=="-1") { -$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } } +$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } } if($LastTopic==null) { $LastTopic=" 
 "; } } @mysql_free_result($gltresult); if ($ForumType=="redirect") { $LastTopic="Redirects: ".$NumRedirects; } diff --git a/inc/subforums.php b/inc/subforums.php index 2e99107..878b243 100644 --- a/inc/subforums.php +++ b/inc/subforums.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: subforums.php - Last Update: 08/09/2007 SVN 73 - Author: cooldude2k $ + $FileInfo: subforums.php - Last Update: 08/11/2007 SVN 75 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="subforums.php"||$File3Name=="/subforums.php") { @@ -158,7 +158,7 @@ if($UsersName==null) { $UsersName="Guest"; } } if (strlen($UsersName)>15) { $UsersName1 = $UsersName1."..."; $oldtopicname=$TopicName; $oldusername=$UsersName; $TopicName=$TopicName1; $UsersName=$UsersName1; } -$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } +$LastTopic = "User: ".$UsersName."
\nTopic: ".$TopicName.""; } if($LastTopic==null) { $LastTopic=" 
 "; } } @mysql_free_result($gltresult); if ($ForumType=="redirect") { $LastTopic="Redirects: ".$NumRedirects; } diff --git a/inc/versioninfo.php b/inc/versioninfo.php index 99e1e45..73d3169 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/09/2007 SVN 74 - Author: cooldude2k $ + $FileInfo: versioninfo.php - Last Update: 08/11/2007 SVN 75 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="versioninfo.php"||$File3Name=="/versioninfo.php") { @@ -27,8 +27,8 @@ 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] = 8; $VERFull[1] = $VER1[0].".".$VER1[1].".".$VER1[2]; -$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 74; $RName = "iDB"; $SFName = "IntDB"; -$SVNDay[0] = 08; $SVNDay[1] = 09; $SVNDay[2] = 2007; $SVNDay[3] = $SVNDay[0]."/".$SVNDay[1]."/".$SVNDay[2]; +$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 75; $RName = "iDB"; $SFName = "IntDB"; +$SVNDay[0] = 08; $SVNDay[1] = 11; $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); -- 2.11.0
"> ( ) +"> ( )  
-
- +
".$ThemeSet['EditReply']; ?>".$ThemeSet['DeleteReply']; ?>"> 
@@ -419,11 +420,11 @@ mysql_query($queryupd); $queryupd = query("UPDATE `".$Settings['sqltable']."topics` SET `NumReply`=%i,LastUpdate=%i WHERE `id`=%i", array($NewNumReplies,$LastActive,$TopicID)); mysql_query($queryupd); $MyPostNum = $NewNumReplies + 1; -@redirect("refresh",$basedir.url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID,$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'],FALSE)."#post".$MyPostNum,"3"); +@redirect("refresh",$basedir.url_maker($exfile['topic'],$Settings['file_ext'],"act=view&id=".$TopicID,$Settings['qstr'],$Settings['qsep'],$prexqstr['topic'],$exqstr['topic'],FALSE)."#reply".$MyPostNum,"3"); ?>

Reply to Topic was posted.
- Click #post">here to view your reply.
  + Click #reply">here to view your reply.
 

Reply to Topic was edited.
- Click ">here to view topic.
  + Click ">here to view topic.