[phpwsbb-commits] phpwsbb/boost install.sql,1.23,1.24 update.php,1.50,1.51

[Eloi G. <ada...@us...>]

Update of /cvsroot/phpwsbb/phpwsbb/boost
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24050/boost

Modified Files:
	install.sql update.php 
Log Message:
Feature Request [ 1034602 ] "view posts since last visit"
- Still need an icon for the button, though...

Index: install.sql
===================================================================
RCS file: /cvsroot/phpwsbb/phpwsbb/boost/install.sql,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -d -r1.23 -r1.24
*** install.sql	4 Feb 2006 04:18:24 -0000	1.23
--- install.sql	23 Feb 2006 06:16:36 -0000	1.24
***************
*** 125,128 ****
--- 125,130 ----
      suspendmonitors   smallint NOT NULL default '0',
      monitordefault    smallint NOT NULL default '0',
+     session_start     int NOT NULL default '0',
+     last_on           int NOT NULL default '0',
      PRIMARY KEY (user_id)
  );

Index: update.php
===================================================================
RCS file: /cvsroot/phpwsbb/phpwsbb/boost/update.php,v
retrieving revision 1.50
retrieving revision 1.51
diff -C2 -d -r1.50 -r1.51
*** update.php	4 Feb 2006 04:38:11 -0000	1.50
--- update.php	23 Feb 2006 06:16:36 -0000	1.51
***************
*** 348,351 ****
--- 348,358 ----
          $content .= '<div class="errortext">There was a problem creating the views settings in the settings table.</div>';
  
+     if ($status = $GLOBALS['core']->query('ALTER TABLE mod_phpwsbb_user_info ADD session_start int NOT NULL default "0", ADD last_on int NOT NULL default "0"', TRUE)) {
+         $content .= '* Added Settings for "View new posts" feature.<br />';
+         $GLOBALS['core']->query('UPDATE mod_phpwsbb_user_info SET session_start = '.time()-86400, TRUE);
+     }
+     else
+         $content .= '<div class="errortext">There was a problem creating the "View new posts" settings in the User Settings table.</div>';
+ 
      $content .= '* Copying images to /images/phpwsbb/<br />';
      /* Copy new image files */