Page 8 of 8
Re: Slowing down forum trolls and cowards
Posted: Wed Oct 06, 2010 6:07 pm
by ashley
fractal wrote:ashley wrote:ryan_p wrote: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.
Re: Slowing down forum trolls and cowards
Posted: Wed Oct 06, 2010 6:21 pm
by deadly_habit
ashley wrote:fractal wrote:ashley wrote:ryan_p wrote: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
Re: Slowing down forum trolls and cowards
Posted: Wed Oct 06, 2010 6:29 pm
by hellfire machina
Ashley - slightly off topic but are you a serious script writer?
Re: Slowing down forum trolls and cowards
Posted: Wed Oct 06, 2010 6:35 pm
by 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
Re: Slowing down forum trolls and cowards
Posted: Wed Oct 06, 2010 7:01 pm
by Sirius
fractal wrote: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
Re: Slowing down forum trolls and cowards
Posted: Wed Oct 06, 2010 7:17 pm
by ryan_p
ashley wrote:fractal wrote:ashley wrote:ryan_p wrote: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'
Re: Slowing down forum trolls and cowards
Posted: Wed Oct 06, 2010 7:21 pm
by ashley
ryan_p wrote:ashley wrote:fractal wrote:ashley wrote:ryan_p wrote: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.
Re: Slowing down forum trolls and cowards
Posted: Wed Oct 06, 2010 7:23 pm
by ashley
hellfire machina wrote: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.
Re: Slowing down forum trolls and cowards
Posted: Wed Oct 06, 2010 7:32 pm
by hellfire machina
Ok, thanks bruv, I'll be in touch soon.
Re: Slowing down forum trolls and cowards
Posted: Wed Oct 06, 2010 8:22 pm
by ruckus49
wow if only our governments were run more like this website
Re: Slowing down forum trolls and cowards
Posted: Thu Oct 07, 2010 1:11 am
by qwaycee_
DRTY wrote:Why not just delete people's second accounts?
Re: Slowing down forum trolls and cowards
Posted: Fri Oct 08, 2010 7:33 pm
by 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.