OSDN Git Service

(root) / idb / iDB.git.git / commitdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | patch | inline | side by side (parent: 768136a)
Added (Fix Topic User Names) and (Fix Reply User Names) to AdminCP.
authorKazuki Przyborowski <kazuki.przyborowski@gmail.com>
Wed, 11 Nov 2009 20:42:53 +0000 (20:42 +0000)
committerKazuki Przyborowski <kazuki.przyborowski@gmail.com>
Wed, 11 Nov 2009 20:42:53 +0000 (20:42 +0000)
git-svn-id: svn://svn.code.sf.net/p/intdb/svn/trunk@339 2b68903e-0b30-0410-9a39-a2e4f3c5be39

admin.php patch | blob | history
inc/admin/forums.php patch | blob | history
inc/admin/table.php patch | blob | history
inc/misc/functions.php patch | blob | history
inc/versioninfo.php patch | blob | history

diff --git a/admin.php b/admin.php
index 7e68127..325a2a2 100644 (file)
--- a/admin.php
+++ b/admin.php
@@ -11,7 +11,7 @@
     Copyright 2004-2009 iDB Support - http://idb.berlios.de/
     Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/
 
-    $FileInfo: admin.php - Last Update: 10/08/2009 SVN 324 - Author: cooldude2k $
+    $FileInfo: admin.php - Last Update: 11/11/2009 SVN 339 - Author: cooldude2k $
 */
 if(@ini_get("register_globals")) {
 require_once('inc/misc/killglobals.php'); }
@@ -63,6 +63,8 @@ if($_GET['act']=="addforum"||
        $_GET['act']=="deleteforum"||
        $_GET['act']=="retopics"||
        $_GET['act']=="rereplies"||
+       $_GET['act']=="fixrnames"||
+       $_GET['act']=="fixtnames"||
        $_GET['act']=="fpermissions")
 { $AdminMenu = "forums";
 require($SettDir['admin'].'forums.php'); }
diff --git a/inc/admin/forums.php b/inc/admin/forums.php
index febd5ca..923858a 100644 (file)
--- a/inc/admin/forums.php
+++ b/inc/admin/forums.php
@@ -11,7 +11,7 @@
     Copyright 2004-2009 iDB Support - http://idb.berlios.de/
     Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/
 
-    $FileInfo: forums.php - Last Update: 10/08/2009 SVN 324 - Author: cooldude2k $
+    $FileInfo: forums.php - Last Update: 11/11/2009 SVN 339 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="forums.php"||$File3Name=="/forums.php") {
@@ -135,6 +135,142 @@ mysql_query($query);
 </tr>
 </table>
 </div>
+<?php } if($_GET['act']=="fixtnames") { 
+$admincptitle = " ".$ThemeSet['TitleDivider']." Fixing Topic User Names";
+$query = query("SELECT * FROM `".$Settings['sqltable']."topics` ORDER BY `TimeStamp` ASC", array(null));
+$result=mysql_query($query);
+$num=mysql_num_rows($result);
+$i=0;
+while ($i < $num) {
+$TopicID=mysql_result($result,$i,"id");
+$UserID=mysql_result($result,$i,"UserID");
+$GuestsName=mysql_result($result,$i,"GuestName");
+$NewUserID = $UserID;
+$NewGuestsName = $GuestsName;
+$NewGuestsName = GetUserName($NewUserID,$Settings['sqltable']);
+if($UserID==-1&&$GuestsName!=null) { $NewGuestsName = $GuestsName; }
+if($NewGuestsName==null&&$GuestsName!=null&&$UserID!==0) {
+$NewUserID = -1; $NewGuestsName = $GuestsName; }
+if($UserID==-1&&$GuestsName==null) {
+$NewUserID = -1; $NewGuestsName = "Guest"; }
+if($UserID===0&&$GuestsName!=null) {
+$NewUserID = -1; $NewGuestsName = "Guest"; }
+if($UserID===0&&$GuestsName==null) {
+$NewUserID = -1; $NewGuestsName = "Guest"; }
+if($UserID==$NewUserID&&$GuestsName==$NewGuestsName) {
+$NewUserID = $UserID; $NewGuestsName = $GuestsName; }
+$query = query("UPDATE `".$Settings['sqltable']."topics` SET `UserID`=%i,`GuestName`='%s' WHERE `id`=%i", array($NewUserID,$NewGuestsName,$TopicID));
+mysql_query($query);
+++$i; }
+@mysql_free_result($result);
+?>
+<div class="TableMenuBorder">
+<?php if($ThemeSet['TableStyle']=="div") { ?>
+<div class="TableMenuRow1">
+<?php echo $ThemeSet['TitleIcon']; ?><a href="<?php echo url_maker($exfile['admin'],$Settings['file_ext'],"act=view&menu=forums",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin']); ?>">Fixing Topic User Names</a></div>
+<?php } ?>
+<table class="TableMenu" style="width: 100%;">
+<?php if($ThemeSet['TableStyle']=="table") { ?>
+<tr class="TableMenuRow1">
+<td class="TableMenuColumn1"><span style="float: left;">
+<?php echo $ThemeSet['TitleIcon']; ?><a href="<?php echo url_maker($exfile['admin'],$Settings['file_ext'],"act=view&menu=forums",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin']); ?>">Fixing Topic User Names</a>
+</span><span style="float: right;">&nbsp;</span></td>
+</tr><?php } ?>
+<tr class="TableMenuRow2">
+<th class="TableMenuColumn2" style="width: 100%; text-align: left;">
+<span style="float: left;">&nbsp;Fixing Topic User Names: </span>
+<span style="float: right;">&nbsp;</span>
+</th>
+</tr>
+<tr class="TableMenuRow3">
+<td class="TableMenuColumn3">
+<div style="text-align: center;">
+       <br />Topic User Names fixed.<br />
+       <a href="<?php echo url_maker($exfile['admin'],$Settings['file_ext'],"act=view&menu=forums",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin']); ?>">Click here</a> to back to admin cp.<br />&nbsp;
+</div>
+</td>
+</tr>
+<tr class="TableMenuRow4">
+<td class="TableMenuColumn4">&nbsp;</td>
+</tr>
+</table>
+</div>
+<?php } if($_GET['act']=="fixrnames") { 
+$admincptitle = " ".$ThemeSet['TitleDivider']." Fixing Reply User Names";
+$query = query("SELECT * FROM `".$Settings['sqltable']."posts` ORDER BY `TimeStamp` ASC", array(null));
+$result=mysql_query($query);
+$num=mysql_num_rows($result);
+$i=0;
+while ($i < $num) {
+$PostID=mysql_result($result,$i,"id");
+$UserID=mysql_result($result,$i,"UserID");
+$GuestsName=mysql_result($result,$i,"GuestName");
+$NewUserID = $UserID;
+$NewGuestsName = $GuestsName;
+$NewGuestsName = GetUserName($NewUserID,$Settings['sqltable']);
+if($UserID==-1&&$GuestsName!=null) { $NewGuestsName = $GuestsName; }
+if($NewGuestsName==null&&$GuestsName!=null&&$UserID!==0) {
+$NewUserID = -1; $NewGuestsName = $GuestsName; }
+if($UserID==-1&&$GuestsName==null) {
+$NewUserID = -1; $NewGuestsName = "Guest"; }
+if($UserID===0&&$GuestsName!=null) {
+$NewUserID = -1; $NewGuestsName = "Guest"; }
+if($UserID===0&&$GuestsName==null) {
+$NewUserID = -1; $NewGuestsName = "Guest"; }
+if($UserID==$NewUserID&&$GuestsName==$NewGuestsName) {
+$NewUserID = $UserID; $NewGuestsName = $GuestsName; }
+$EditUserID=mysql_result($result,$i,"EditUser");
+$EditUserName=mysql_result($result,$i,"EditUserName");
+$NewEditUserID = $EditUserID;
+$NewEditUserName = $EditUserName;
+$NewEditUserName = GetUserName($NewEditUserID,$Settings['sqltable']);
+if($EditUserID==-1&&$EditUserName!=null) { $NewEditUserName = $EditUserName; }
+if($NewEditUserName==null&&$EditUserName!=null&&$EditUserID!==0) {
+$NewEditUserID = -1; $NewEditUserName = $EditUserName; }
+if($EditUserID==-1&&$EditUserName==null) {
+$NewEditUserID = -1; $NewEditUserName = "Guest"; }
+if($EditUserID===0&&$EditUserName!=null) {
+$NewEditUserID = "0"; $NewEditUserName = null; }
+if($EditUserID===0&&$EditUserName==null) {
+$NewEditUserID = "0"; $NewEditUserName = null; }
+if($EditUserID==$NewEditUserID&&$EditUserName==$NewEditUserName) {
+$NewEditUserID = $EditUserID; $NewEditUserName = $EditUserName; }
+$query = query("UPDATE `".$Settings['sqltable']."posts` SET `UserID`=%i,`GuestName`='%s',`EditUser`=%i,`EditUserName`='%s' WHERE `id`=%i", array($NewUserID,$NewGuestsName,$NewEditUserID,$NewEditUserName,$PostID));
+mysql_query($query);
+++$i; }
+@mysql_free_result($result);
+?>
+<div class="TableMenuBorder">
+<?php if($ThemeSet['TableStyle']=="div") { ?>
+<div class="TableMenuRow1">
+<?php echo $ThemeSet['TitleIcon']; ?><a href="<?php echo url_maker($exfile['admin'],$Settings['file_ext'],"act=view&menu=forums",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin']); ?>">Fixing Reply User Names</a></div>
+<?php } ?>
+<table class="TableMenu" style="width: 100%;">
+<?php if($ThemeSet['TableStyle']=="table") { ?>
+<tr class="TableMenuRow1">
+<td class="TableMenuColumn1"><span style="float: left;">
+<?php echo $ThemeSet['TitleIcon']; ?><a href="<?php echo url_maker($exfile['admin'],$Settings['file_ext'],"act=view&menu=forums",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin']); ?>">Fixing Reply User Names</a>
+</span><span style="float: right;">&nbsp;</span></td>
+</tr><?php } ?>
+<tr class="TableMenuRow2">
+<th class="TableMenuColumn2" style="width: 100%; text-align: left;">
+<span style="float: left;">&nbsp;Fixing Reply User Names: </span>
+<span style="float: right;">&nbsp;</span>
+</th>
+</tr>
+<tr class="TableMenuRow3">
+<td class="TableMenuColumn3">
+<div style="text-align: center;">
+       <br />Reply User Names fixed.<br />
+       <a href="<?php echo url_maker($exfile['admin'],$Settings['file_ext'],"act=view&menu=forums",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin']); ?>">Click here</a> to back to admin cp.<br />&nbsp;
+</div>
+</td>
+</tr>
+<tr class="TableMenuRow4">
+<td class="TableMenuColumn4">&nbsp;</td>
+</tr>
+</table>
+</div>
 <?php } if($_GET['act']=="addforum"&&$_POST['update']!="now") { 
 $admincptitle = " ".$ThemeSet['TitleDivider']." Adding new Forum";
 ?>
diff --git a/inc/admin/table.php b/inc/admin/table.php
index 15160b0..acd350a 100644 (file)
--- a/inc/admin/table.php
+++ b/inc/admin/table.php
@@ -11,7 +11,7 @@
     Copyright 2004-2009 iDB Support - http://idb.berlios.de/
     Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/
 
-    $FileInfo: table.php - Last Update: 10/08/2009 SVN 324 - Author: cooldude2k $
+    $FileInfo: table.php - Last Update: 11/11/2009 SVN 339 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="table.php"||$File3Name=="/table.php") {
@@ -96,6 +96,10 @@ if ($File3Name=="table.php"||$File3Name=="/table.php") {
 </tr><tr class="TableSMenuRow3">
 <td class="TableSMenuColumn3"><a href="<?php echo url_maker($exfile['admin'],$Settings['file_ext'],"act=rereplies",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin']); ?>">Recount Replies</a></td>
 </tr><tr class="TableSMenuRow3">
+<td class="TableSMenuColumn3"><a href="<?php echo url_maker($exfile['admin'],$Settings['file_ext'],"act=fixtnames",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin']); ?>">Fix Topic User Names</a></td>
+</tr><tr class="TableSMenuRow3">
+<td class="TableSMenuColumn3"><a href="<?php echo url_maker($exfile['admin'],$Settings['file_ext'],"act=fixrnames",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin']); ?>">Fix Reply User Names</a></td>
+</tr><tr class="TableSMenuRow3">
 <td class="TableSMenuColumn3"><a href="<?php echo url_maker($exfile['admin'],$Settings['file_ext'],"act=fpermissions",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin']); ?>">Forum Permissions</a></td>
 </tr><tr class="TableSMenuRow4">
 <td class="TableSMenuColumn4">&nbsp;</td>
diff --git a/inc/misc/functions.php b/inc/misc/functions.php
index e1346c1..77c5e12 100644 (file)
--- a/inc/misc/functions.php
+++ b/inc/misc/functions.php
@@ -11,7 +11,7 @@
     Copyright 2004-2009 iDB Support - http://idb.berlios.de/
     Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/
 
-    $FileInfo: functions.php - Last Update: 8/27/2009 SVN 318 - Author: cooldude2k $
+    $FileInfo: functions.php - Last Update: 11/11/2009 SVN 339 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="functions.php"||$File3Name=="/functions.php") {
@@ -350,7 +350,7 @@ $phpsrcs = file_get_source($filename,TRUE);
 $phpsrcs = preg_replace("/\<font color=\"(.*?)\"\>/i", "<span style=\"color: \\1;\">", $phpsrcs);
 $phpsrcs = preg_replace("/\<\/font>/i", "</span>", $phpsrcs);
 return $phpsrcs; }
-function GetUserName($idu,$sqlt) {
+function GetUserName($idu,$sqlt) { $UsersName = null;
 $gunquery = query("SELECT * FROM `".$sqlt."members` WHERE `id`=%i", array($idu));
 $gunresult=mysql_query($gunquery);
 $gunnum=mysql_num_rows($gunresult);
@@ -358,7 +358,7 @@ if($gunnum>0){
 $UsersName=mysql_result($gunresult,0,"Name"); }
 @mysql_free_result($gunresult);
 return $UsersName; }
-// Check to see if I'm hidden from you. >_> | ^_^ | <_<
+// Check to see if the user is hidden/shy. >_> | ^_^ | <_<
 function GetHiddenMember($idu,$sqlt) {
 $gunquery = query("SELECT * FROM `".$sqlt."members` WHERE `id`=%i", array($idu));
 $gunresult=mysql_query($gunquery);
diff --git a/inc/versioninfo.php b/inc/versioninfo.php
index 9a5aed2..4721e0c 100644 (file)
--- a/inc/versioninfo.php
+++ b/inc/versioninfo.php
@@ -11,7 +11,7 @@
     Copyright 2004-2009 iDB Support - http://idb.berlios.de/
     Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/
 
-    $FileInfo: versioninfo.php - Last Update: 11/11/2009 SVN 338 - Author: cooldude2k $
+    $FileInfo: versioninfo.php - Last Update: 11/11/2009 SVN 339 - 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] = 3; $VER1[2] = 1; $VERFull[1] = $VER1[0].".".$VER1[1].".".$VER1[2];
-$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 338; $RName = "iDB"; $SFName = "IntDB";
+$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 339; $RName = "iDB"; $SFName = "IntDB";
 $SVNDay[0] = 11; $SVNDay[1] = 11; $SVNDay[2] = 2009; $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);
Internet Discussion Boards is a message board system by Game Maker 2k. Its very easy to set up. Your web host needs PHP and CUBRID / MySQL / MariaDB / PostgreSQL / SQLite. Internet Discussion Boards is Open Source so you can make changes to it.
About OSDN
Find Software
Develop Software
Help