Clean the spam in newssection-comments... Some pages weighted 10 or more Megabytes of massive spam... Actually the spam created about 90% of the traffic on this site in the last month...
So you can not expect me to be very subtle about it. I did:
delete FROM `mapnc` WHERE ctext LIKE '%viagra%' OR (ctext like '%http%' AND newsid < 200)
means there will be some "good" posts gone too, where "http" occured.
Also, you need to be logged in to post comments on news now, too.
edit: that wasnt enough, now I think I really got 99% of the spam deleted, and quite some more useful posts too, sorry about that. modified by panschk[FP]
no problem, i dont think anyone will blame you for that. i am glad you still care about the site, and i would love to see you back actually. doesnt sc2 push you a bit back to mapping? ;>
I am thinking about doing sc2maps.net or something along the lines if a big part of the community here will convert to sc2. I dont play bw, and I prolly wont play sc2 online neither, so while I admire the mappers for what they do, I think my active mapping days are over for good.
Let's not speculate about a sc2maps.net yet though, there is no saying how busy my and your schedules will be when it comes out;) modified by panschk[FP]
Panschk fighting!~ Don't worry most posts made on the newsposts aren't usefull anyway^^ It's no problem at all, I'd rather lose some "oh noes this is cool" posts and lose the "You have a great website here. Please check out these viagra cars pharmisutical sites" :)
Yeah we'll worry about sc2 if/when it comes out ;) It might be like ghost^^
btw if you want to delete some spam you should check out compid 109, the one about the new bwm mappack, I can't edit/censor comments in competition threads, and my one post with the long stream of DDDDDDDDDDDD really fucked up the page :( Apparently it doesn't wrap there at all on top of not being able to edit/censor ;) modified by Nightmarjoo