phpBB.nl

Code: Selecteer alles

UPDATE phpbb_users AS u, phpbb_posts AS p1 LEFT OUTER JOIN phpbb_posts AS p2 ON p1.poster_id = p2.poster_id AND p2.post_time < p1.post_time INNER JOIN phpbb_posts AS p3 ON p3.post_time = p1.post_time SET u.user_firstpost=p3.post_time WHERE p2.post_time IS NULL AND p1.poster_id = u.user_id
+++ Error: You have an error in your SQL syntax near 'AS u, phpbb_posts AS p1 LEFT OUTER JOIN phpbb_posts AS p2 ON p1.poster_' at line 1

Code: Selecteer alles

Unable to update user_firstpost

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'AS u, phpbb_posts AS p1 INNER JOIN phpbb_posts AS p2 ON p2.post_id = 2 ' at line 1

UPDATE phpbb_users AS u, phpbb_posts AS p1 INNER JOIN phpbb_posts AS p2 ON p2.post_id = 2 SET u.user_firstpost = 0 WHERE u.user_id = p2.poster_id AND u.user_firstpost = p2.post_time;

Line : 510
File : functions_post.php
 

Code: Selecteer alles

#
#-----[ OPEN ]------------------------------------------
#
includes/functions_post.php

#
#-----[ FIND ]------------------------------------------
#
					message_die(GENERAL_MESSAGE, $lang['Flood_Error']);
				}
			}
		}

#
#-----[ AFTER, ADD ]------------------------------------
#
		$sql = "UPDATE " . USERS_TABLE . " SET user_firstpost = " . $current_time . "
			WHERE user_id = " . $userdata['user_id'] . " AND user_firstpost = 0;";

		if ( !$db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Unable to update user_firstpost', '', __LINE__, __FILE__, $sql);
		}

#
#-----[ FIND ]------------------------------------------
#
		$sql = "DELETE FROM " . POSTS_TABLE . " 
			WHERE post_id = $post_id";

#
#-----[ BEFORE, ADD ]-----------------------------------
#
		// if this is the users first post, set user_firstpost to 0.
		$sql = "UPDATE " . USERS_TABLE . " AS u, " . POSTS_TABLE . " AS p1
				INNER JOIN " . POSTS_TABLE . " AS p2
				ON p2.post_id = " . $post_id . "
			SET u.user_firstpost = 0
			WHERE u.user_id = p2.poster_id AND u.user_firstpost = p2.post_time;";

		if ( !$db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Unable to update user_firstpost', '', __LINE__, __FILE__, $sql);
		}

		$resync = $db->sql_affectedrows();

#
#-----[ FIND ]------------------------------------------
#
		$sql = "DELETE FROM " . POSTS_TEXT_TABLE . " 
			WHERE post_id = $post_id";
		if (!$db->sql_query($sql))
		{
			message_die(GENERAL_ERROR, 'Error in deleting post', '', __LINE__, __FILE__, $sql);
		}

#
#-----[ AFTER, ADD ]------------------------------------
#
		if ($resync)
		{
			// if the previously deleted post was the users first post, redefine user_firstpost.
			$sql = "UPDATE " . USERS_TABLE . " AS u, " . POSTS_TABLE . " AS p1
					LEFT OUTER JOIN " . POSTS_TABLE . " AS p2
					ON p1.poster_id = p2.poster_id AND p2.post_time < p1.post_time
					INNER JOIN " . POSTS_TABLE . " AS p3
					ON p3.post_time = p1.post_time
				SET u.user_firstpost = p3.post_time
				WHERE p2.post_time IS NULL AND p1.poster_id = u.user_id AND u.user_id = " . $post_data['poster_id'] .";";

			if ( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, 'Unable to update user_firstpost', '', __LINE__, __FILE__, $sql);
			}
		}

Code: Selecteer alles

ALTER TABLE phpbb_users ADD user_firstpost int(11) NOT NULL;

UPDATE phpbb_users AS u, phpbb_posts AS p1
   LEFT OUTER JOIN
   phpbb_posts AS p2
   ON p1.poster_id = p2.poster_id AND
      p2.post_time < p1.post_time
   INNER JOIN
   phpbb_posts AS p3
   ON p3.post_time = p1.post_time
SET u.user_firstpost=p3.post_time
WHERE p2.post_time IS NULL AND
   p1.poster_id = u.user_id;

UPDATE phpbb_users
SET user_firstpost = user_regdate
WHERE user_posts <> 0 AND user_firstpost = 0;

INSERT INTO phpbb_config (config_name, config_value) VALUES ('zero_count',1),('zero_newest',1),('zero_group',1),('zero_list',1);