[geeklog-cvs] geeklog-1.3/public_html/admin story.php,1.93,1.94

[geeklog-cvs-admin at lists.geeklog.net]

Update of /usr/cvs/geeklog/geeklog-1.3/public_html/admin
In directory internal.geeklog.net:/tmp/cvs-serv13303

Modified Files:
	story.php 
Log Message:
When attempting to edit a submission, check it's still there (may have been approved by another Admin in the meantime) to avoid getting an SQL error.


Index: story.php
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/public_html/admin/story.php,v
retrieving revision 1.93
retrieving revision 1.94
diff -C2 -d -r1.93 -r1.94
*** story.php	28 Jun 2003 12:52:38 -0000	1.93
--- story.php	1 Jul 2003 14:52:56 -0000	1.94
***************
*** 111,129 ****
      } elseif (!empty($sid) && $mode == "editsubmission") {
          $result = DB_query("SELECT *,UNIX_TIMESTAMP(date) AS unixdate FROM {$_TABLES['storysubmission']} WHERE sid = '$sid'");
!         $A = DB_fetchArray($result);
!         $A['show_topic_icon'] = 1;
!         $A["commentcode"] = $_CONF['comment_code'];
!         $A["featured"] = 0;
!         $A["statuscode"] = 0;
!         $A['owner_id'] = $A['uid'];
!         $result = DB_query ("SELECT group_id,perm_owner,perm_group,perm_members,perm_anon FROM {$_TABLES['topics']} WHERE tid = '{$A['tid']}'");
!         $T = DB_fetchArray ($result);
!         $A['group_id'] = $T['group_id'];
!         $A['perm_owner'] = $T['perm_owner'];
!         $A['perm_group'] = $T['perm_group'];
!         $A['perm_members'] = $T['perm_members'];
!         $A['perm_anon'] = $T['perm_anon'];
!         $access = 3;
!         $A['title'] = htmlspecialchars ($A['title']);
      } elseif ($mode == "edit") {
          $A['sid'] = COM_makesid();
--- 111,135 ----
      } elseif (!empty($sid) && $mode == "editsubmission") {
          $result = DB_query("SELECT *,UNIX_TIMESTAMP(date) AS unixdate FROM {$_TABLES['storysubmission']} WHERE sid = '$sid'");
!         if (DB_numRows ($result) > 0) {
!             $A = DB_fetchArray($result);
!             $A['show_topic_icon'] = 1;
!             $A['commentcode'] = $_CONF['comment_code'];
!             $A['featured'] = 0;
!             $A['statuscode'] = 0;
!             $A['owner_id'] = $A['uid'];
!             $result = DB_query ("SELECT group_id,perm_owner,perm_group,perm_members,perm_anon FROM {$_TABLES['topics']} WHERE tid = '{$A['tid']}'");
!             $T = DB_fetchArray ($result);
!             $A['group_id'] = $T['group_id'];
!             $A['perm_owner'] = $T['perm_owner'];
!             $A['perm_group'] = $T['perm_group'];
!             $A['perm_members'] = $T['perm_members'];
!             $A['perm_anon'] = $T['perm_anon'];
!             $access = 3;
!             $A['title'] = htmlspecialchars ($A['title']);
!         } else {
!             // that submission doesn't seem to be there any more (may have been
!             // handled by another Admin) - take us back to the moderation page
!             return COM_refresh ($_CONF['site_admin_url'] . '/moderation.php');
!         }
      } elseif ($mode == "edit") {
          $A['sid'] = COM_makesid();