Slowing down forum trolls and cowards

[ashley]

you don't need to release the ip. just have a feature that shows other accounts the user has accessed from the same ip. phpbb records ip addresses by default so all it takes is a simple query.

SELECT username FROM phpbb_users WHERE user_ip = (SELECT user_ip FROM phpbb_users WHERE username = 'ryan_p');

Please learn2sql.

Don't use a sub select when you can join.

ignore the script, embrace the idea. sure there's a better way to do it

If you're going to do it, do it properly or not at all.

[deadly_habit]

you don't need to release the ip. just have a feature that shows other accounts the user has accessed from the same ip. phpbb records ip addresses by default so all it takes is a simple query.

SELECT username FROM phpbb_users WHERE user_ip = (SELECT user_ip FROM phpbb_users WHERE username = 'ryan_p');

Please learn2sql.

Don't use a sub select when you can join.

ignore the script, embrace the idea. sure there's a better way to do it

If you're going to do it, do it properly or not at all.

ashley is quickly becoming one of my fave users

[hellfire machina]

Ashley - slightly off topic but are you a serious script writer?

[fractal]

i got sent some weak ass script from a guy called clit bang or summat? it was jokes, had to unlink my e-mail after that tho

[Sirius]

i got sent some weak ass script from a guy called clit bang or summat? it was jokes, had to unlink my e-mail after that tho

clit bang is bass hertz!!

hahhhhahhahah.... SNAPPED!!!

SHAME ON A NIQQA!!!

!!chea

[ryan_p]

you don't need to release the ip. just have a feature that shows other accounts the user has accessed from the same ip. phpbb records ip addresses by default so all it takes is a simple query.

SELECT username FROM phpbb_users WHERE user_ip = (SELECT user_ip FROM phpbb_users WHERE username = 'ryan_p');

Please learn2sql.

Don't use a sub select when you can join.

ignore the script, embrace the idea. sure there's a better way to do it

If you're going to do it, do it properly or not at all.

just for you honey
SELECT u1.username FROM phpbb_users AS u1 LEFT JOIN phpbb_users AS u2 ON u1.user_ip = u2.user_ip WHERE u2.username = 'ryan_p'

[ashley]

you don't need to release the ip. just have a feature that shows other accounts the user has accessed from the same ip. phpbb records ip addresses by default so all it takes is a simple query.

SELECT username FROM phpbb_users WHERE user_ip = (SELECT user_ip FROM phpbb_users WHERE username = 'ryan_p');

Please learn2sql.

Don't use a sub select when you can join.

ignore the script, embrace the idea. sure there's a better way to do it

If you're going to do it, do it properly or not at all.

just for you honey
SELECT u1.username FROM phpbb_users AS u1 LEFT JOIN phpbb_users AS u2 ON u1.user_ip = u2.user_ip WHERE u2.username = 'ryan_p'

You're special.

[ashley]

Ashley - slightly off topic but are you a serious script writer?

I can write all sorts of shit.

I'm sure certain people here can tell you all sorts of stories.

If you need to ask me something I'm sure you can find me on AIM or by email.

[hellfire machina]

Ok, thanks bruv, I'll be in touch soon.

[ruckus49]

wow if only our governments were run more like this website

[qwaycee_]

Why not just delete people's second accounts?

[hellfire machina]

It was addressed earlier in the thread that deleting 2nd accounts won't work because there are legit reasons for having them, label/party promo etc.