| [vhffs-dev] [926] Fixed the forum that was broken since commit 922 (  using   int8 instead of timestamp) | 
[ Thread Index | 
Date Index
| More vhffs.org/vhffs-dev Archives
] 
Revision: 926
Author:   crafty
Date:     2007-09-19 12:21:59 +0000 (Wed, 19 Sep 2007)
Log Message:
-----------
Fixed the forum that was broken since commit 922 (using int8 instead of timestamp)
Modified Paths:
--------------
    trunk/vhffs-forum/punbb-1.2.14_vhffs.patch
Modified: trunk/vhffs-forum/punbb-1.2.14_vhffs.patch
===================================================================
--- trunk/vhffs-forum/punbb-1.2.14_vhffs.patch	2007-09-15 15:11:33 UTC (rev 925)
+++ trunk/vhffs-forum/punbb-1.2.14_vhffs.patch	2007-09-19 12:21:59 UTC (rev 926)
@@ -584,9 +584,8 @@
 +		$language = 'English';
 +
 +		// creating new user in forum database
-+		$vhffs_inscription_timestamp = strtotime(substr($vhffs_inscription_date, 0, strpos($vhffs_inscription_date, ".")).'Z');
-+       		//echo "INSERT INTO ".$db->prefix."users (username, group_id, email, email_setting, save_pass, timezone, language, style, registered, registration_ip, last_visit, realname) VALUES (\'".$db->escape($form_username)."\', ".$intial_group_id.", \'".$vhffs_user_mail."\', 1, 1, 0 , \'".$db->escape($language)."\', \'".$pun_config['o_default_style']."\', ".$vhffs_inscription_timestamp.", \'".get_remote_address()."\', ".time().", \'".$vhffs_user_firstname."\ ".$vhffs_user_lastname."\' )";
-+       		$db->query('INSERT INTO '.$db->prefix.'users (username, password, group_id, email, email_setting, save_pass, timezone, language, style, registered, registration_ip, last_visit, realname) VALUES (\''.$db->escape($form_username).'\', \'\','.$intial_group_id.', \''.$vhffs_user_mail.'\', 1, 1, 0 , \''.$db->escape($language).'\', \''.$pun_config['o_default_style'].'\', '.$vhffs_inscription_timestamp.', \''.get_remote_address().'\', '.time().', \''.$vhffs_user_firstname.'\ '.$vhffs_user_lastname.'\' )') or error('Unable to create user in forum database. Error: '.$db->error(), __FILE__, __LINE__, $db->error());
++       		//echo "INSERT INTO ".$db->prefix."users (username, group_id, email, email_setting, save_pass, timezone, language, style, registered, registration_ip, last_visit, realname) VALUES (\'".$db->escape($form_username)."\', ".$intial_group_id.", \'".$vhffs_user_mail."\', 1, 1, 0 , \'".$db->escape($language)."\', \'".$pun_config['o_default_style']."\', ".$vhffs_inscription_date.", \'".get_remote_address()."\', ".time().", \'".$vhffs_user_firstname."\ ".$vhffs_user_lastname."\' )";
++       		$db->query('INSERT INTO '.$db->prefix.'users (username, password, group_id, email, email_setting, save_pass, timezone, language, style, registered, registration_ip, last_visit, realname) VALUES (\''.$db->escape($form_username).'\', \'\','.$intial_group_id.', \''.$vhffs_user_mail.'\', 1, 1, 0 , \''.$db->escape($language).'\', \''.$pun_config['o_default_style'].'\', '.$vhffs_inscription_date.', \''.get_remote_address().'\', '.time().', \''.$vhffs_user_firstname.'\ '.$vhffs_user_lastname.'\' )') or error('Unable to create user in forum database. Error: '.$db->error(), __FILE__, __LINE__, $db->error());
 +       		$user_id = $db->insert_id();
 +		$vhffs_user_import = true;
 +	}