zero_users
Geplaatst: 05 aug 2005, 18:42
ik heb de sql via http://www.phpbbhacks.com/forums/db_generator.php
maar dan krijg ik 2 error`s op
ALTER TABLE phpbb_users ADD user_firstpost int(11) NOT NULL
+++ Error: Duplicate column name 'user_firstpost'
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
wat is er fout aan
en als ik een Hide Zero Posters hack wil doen ook via de phpbbhack link
ALTER TABLE phpbb_users ADD user_firstpost int(11) NOT NULL
+++ Error: Duplicate column name 'user_firstpost'
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)
+++ Error: Duplicate entry 'zero_count' for key 1
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);ALTER TABLE phpbb_users ADD user_firstpost int(11) NOT NULL
+++ Error: Duplicate column name 'user_firstpost'
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
wat is er fout aan
en als ik een Hide Zero Posters hack wil doen ook via de phpbbhack link
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);
ALTER TABLE phpbb_users ADD user_firstpost int(11) NOT NULL
+++ Error: Duplicate column name 'user_firstpost'
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)
+++ Error: Duplicate entry 'zero_count' for key 1