functions post (Hide Zero Posters)

Hulp nodig bij een modificaties of op zoek naar een MOD? Bekijk ons archief. Support wordt helaas niet meer verleend.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
phpBB2.0.x
Gesloten
Gebruikersavatar
Diablo Gamer
Berichten: 1394
Lid geworden op: 02 jan 2004, 20:33
Locatie: Dalen/Drenthe/Holland
Contacteer:

functions post (Hide Zero Posters)

Bericht door Diablo Gamer » 26 aug 2005, 13:35

ik wilde een post delete op mijn forum toe kreeg ik deze error

maar ik kreeg ook een sql error

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

functions post

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
 

dit is de install

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);
			}
		}

Gebruikersavatar
Diablo Gamer
Berichten: 1394
Lid geworden op: 02 jan 2004, 20:33
Locatie: Dalen/Drenthe/Holland
Contacteer:

Bericht door Diablo Gamer » 27 aug 2005, 10:39

iemand ? een idee

ik ben gek
Berichten: 1496
Lid geworden op: 25 mei 2005, 14:09

Bericht door ik ben gek » 27 aug 2005, 10:47

alle sqls gedaan?

Gebruikersavatar
Diablo Gamer
Berichten: 1394
Lid geworden op: 02 jan 2004, 20:33
Locatie: Dalen/Drenthe/Holland
Contacteer:

Bericht door Diablo Gamer » 27 aug 2005, 13:37

ja maar bij 1 krijg ik een error

PS ik maar het altijd in een db_update


ALTER TABLE phpbb_users ADD user_firstpost int(11) NOT NULL
+++ Successful

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

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

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


dit is de 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);

Gebruikersavatar
Diablo Gamer
Berichten: 1394
Lid geworden op: 02 jan 2004, 20:33
Locatie: Dalen/Drenthe/Holland
Contacteer:

Bericht door Diablo Gamer » 27 aug 2005, 21:42

ik weet dat ik nog niet mag kicken maar ik wil graag weer post delete

Gebruikersavatar
Diablo Gamer
Berichten: 1394
Lid geworden op: 02 jan 2004, 20:33
Locatie: Dalen/Drenthe/Holland
Contacteer:

Bericht door Diablo Gamer » 02 sep 2005, 22:39

weet echt niemand hier iets op :(

Gebruikersavatar
Diablo Gamer
Berichten: 1394
Lid geworden op: 02 jan 2004, 20:33
Locatie: Dalen/Drenthe/Holland
Contacteer:

Bericht door Diablo Gamer » 06 sep 2005, 10:24

weer een kick

Gebruikersavatar
Diablo Gamer
Berichten: 1394
Lid geworden op: 02 jan 2004, 20:33
Locatie: Dalen/Drenthe/Holland
Contacteer:

Bericht door Diablo Gamer » 07 sep 2005, 11:22

en nog een kick er bij

Gesloten