Forums
First  << 1  2  3 >>  Last
Forum Main>>Announcements>> User purge
Super secret reinforced spam barrier 2.0
Ur_FaNtAsY_

ID: 264075
Level: 68
Posts: 14069
Score: 409
Ur_FaNtAsY_ [264075]Reply | Quote | Report

Posted on Mon Mar 26, 2007 02:45:16
Nice

fantasy-temptation.png
As Always Ur FaNtAsY!!
Super secret reinforced spam barrier 2.0
Kharma

ID: 156342
Level: 79
Posts: 6429
Score: 1576
(|)Kharma [156342]Reply | Quote | Report

Posted on Mon Mar 26, 2007 02:52:35
Sounds good and good job. Well needed purge
And don't let ppl get to you if they complain about updates coming quickly....I for one would rather have a smoother running TC than a sludgy TC with new things lol.

Super secret reinforced spam barrier 2.0
HummerxD
ID: 347486
Level: 29
Posts: 9
Score: 2
HummerxD [347486]Reply | Quote | Report

Posted on Mon Mar 26, 2007 02:59:15
All users who have not logged in during 2007, are under level 10, and are not donators have been removed. Full backups of the data affected have been made. This also includes messages and events.

This should keep us going for a while.

We have put the April updates on hold for a little bit, while we normalize the user tables. This means removing around 75 fields from the users table and splitting them up in to other tables. This 'should' speed up the site a LOT although it is a very big process. But I think you agree, very important if we are to bring new users in to Torn.

Thank you!


Edited by: Chedburn on 26/03/07 at 1:16:35 AM


For a while. Very convincing

Super secret reinforced spam barrier 2.0
jedi_josh

ID: 184550
Level: 30
Posts: 179
Score: 34
~BS~jedi_josh [184550]Reply | Quote | Report

Posted on Mon Mar 26, 2007 03:08:42
delete all the people in fed who are known multis and other offenders

61221873439qu2.png


2091qu9.png
Super secret reinforced spam barrier 2.0
Blindside

ID: 429804
Level: 71
Posts: 1911
Score: 689
~V~Blindside [429804]Reply | Quote | Report

Posted on Mon Mar 26, 2007 04:50:49
This is great news...look forward to the updates, too...but DB optimization should come first



Super secret reinforced spam barrier 2.0
Savior
ID: 352938
Level: 18
Posts: 67
Score: 0
Savior [352938]Reply | Quote | Report

Posted on Mon Mar 26, 2007 04:57:35
Yea, you should get rid of all unused accounts.

Super secret reinforced spam barrier 2.0
Jamming
ID: 106403
Level: 44
Posts: 2732
Score: -28
Jamming [106403]Reply | Quote | Report

Posted on Mon Mar 26, 2007 05:09:17
Good good. Prunning is in effect. Were inventories removed aswell?

"Only a true gentleman will lend you their pair of arabian goggles."
Super secret reinforced spam barrier 2.0
nygel
ID: 420319
Level: 30
Posts: 493
Score: 0
nygel [420319]Reply | Quote | Report

Posted on Mon Mar 26, 2007 05:23:35
i still want a pets update so i can a polar bear against a hyena


da_userbar.gif
Super secret reinforced spam barrier 2.0
Yuri_Orlov

ID: 175440
Level: 43
Posts: 3751
Score: 151
INFYYuri_Orlov [175440]Reply | Quote | Report

Posted on Mon Mar 26, 2007 05:27:48
ITS ABOUT FUCKING TIME!!!!

spamsociety.jpg
yuri.gif
screwyurifa4.jpg

OMG YURI_ORLOV I HATE HIM!!!
Super secret reinforced spam barrier 2.0
Angelos
ID: 360065
Level: 35
Posts: 114
Score: 0
Angelos [360065]Reply | Quote | Report

Posted on Mon Mar 26, 2007 05:29:21
i m ok with that

Super secret reinforced spam barrier 2.0
JSnows

ID: 14906
Level: 61
Posts: 8865
Score: 1965
JSnows [14906]Reply | Quote | Report

Posted on Mon Mar 26, 2007 05:54:46
finally ..

i'd go one step further and just delete all users who have not logged in during 2007 independent of level

x7dpz.png
Super secret reinforced spam barrier 2.0
-JT-

ID: 147132
Level: 63
Posts: 774
Score: 283
-JT- [147132]Reply | Quote | Report

Posted on Mon Mar 26, 2007 05:59:21
w00t w00t

Super secret reinforced spam barrier 2.0
Keygod

ID: 181200
Level: 81
Posts: 1736
Score: 17
3.0Keygod [181200]Reply | Quote | Report

Posted on Mon Mar 26, 2007 06:17:22
Nice work, as said before, if it benefits the players and the game, all for it.

Super secret reinforced spam barrier 2.0
Pabl0

ID: 33050
Level: 68
Posts: 87
Score: 18
Pabl0 [33050]Reply | Quote | Report

Posted on Mon Mar 26, 2007 06:42:58
GJ

Super secret reinforced spam barrier 2.0
Megadeth

ID: 24557
Level: 79
Posts: 9591
Score: 1525
JFKMegadeth [24557]Reply | Quote | Report

Posted on Mon Mar 26, 2007 07:11:01
If it makes TC fast, do it.

Super secret reinforced spam barrier 2.0
Gaspy
ID: 83288
Level: 50
Posts: 584
Score: -15
Gaspy [83288]Reply | Quote | Report

Posted on Mon Mar 26, 2007 07:20:32
Nice, this will make TC even faster!

style8,Gasparo.png
Super secret reinforced spam barrier 2.0
Lieghn
ID: 421329
Level: 32
Posts: 142
Score: 0
Lieghn [421329]Reply | Quote | Report

Posted on Mon Mar 26, 2007 07:28:12
wow!that's great!!!
no more old...all new!
hehe..:P

Super secret reinforced spam barrier 2.0
Tkama
ID: 72301
Level: 55
Posts: 1561
Score: 71
Tkama [72301]Reply | Quote | Report

Posted on Mon Mar 26, 2007 08:12:12
promises is all i hear. have seen it before and will see it again. :-/

"I see dumb people... they're everywhere... they walk around like everyone else...

they don't even know that they're dumb."
Super secret reinforced spam barrier 2.0
The_Storm

ID: 24528
Level: 85
Posts: 3732
Score: 884
PTThe_Storm [24528]Reply | Quote | Report

Posted on Mon Mar 26, 2007 09:23:55
And how about delete all multis?
They should be thousands!

025198f3-6d3c-6677-60666.gif
Super secret reinforced spam barrier 2.0
Magg
ID: 298417
Level: 52
Posts: 1902
Score: 115
Magg [298417]Reply | Quote | Report

Posted on Mon Mar 26, 2007 09:39:15
And how about delete all multis?
They should be thousands!


good idea it could stop lag as we know it!

timeshiftcopy.png
Super secret reinforced spam barrier 2.0

ID:
Level:
Posts:
Score:
 []Edit | Reply | Quote | Report

Posted on Mon Mar 26, 2007 09:42:13
:s

Super secret reinforced spam barrier 2.0

ID:
Level:
Posts:
Score:
 []Edit | Reply | Quote | Report

Posted on Mon Mar 26, 2007 10:18:22
Haha, that will teach those suckers!

Nah, leave the multis alone, what have they done to you?

Super secret reinforced spam barrier 2.0
Captainjack71

ID: 213154
Level: 61
Posts: 322
Score: 0
Captainjack71 [213154]Reply | Quote | Report

Posted on Mon Mar 26, 2007 10:55:50
Good news about inactive accounts, any chance you guys can clear all the empty factions out too...

213154-Sig.gif
Super secret reinforced spam barrier 2.0
cobrachang

ID: 343620
Level: 40
Posts: 394
Score: 0
cobrachang [343620]Reply | Quote | Report

Posted on Mon Mar 26, 2007 11:45:03
Thanks Ched, Cleaning all those out should help allot. Anything to keep the system moving faster is a PLUS...

forumim.gif
divider04dragonbar-1.gif
Super secret reinforced spam barrier 2.0
Naznomarn
ID: 198074
Level: 58
Posts: 384
Score: 252
Naznomarn [198074]Reply | Quote | Report

Posted on Mon Mar 26, 2007 12:13:07
Lol. One of the first lessons in computing and IT, "How to normalise tables"
Good luck on that anyways.

naznomarn.png
Super secret reinforced spam barrier 2.0
26367
ID: 26367
Level: 47
Posts: 1612
Score: 58
26367 [26367]Reply | Quote | Report

Posted on Mon Mar 26, 2007 12:53:52
Fianlly after 200+ days of the other not logging on I can drop the 94 after my name!!:)

userbarKKK.png
colosus-sig.jpg
Why are you cryin'? I haven't even cut you yet.
Super secret reinforced spam barrier 2.0
Deek
ID: 78647
Level: 35
Posts: 150
Score: 0
Deek [78647]Reply | Quote | Report

Posted on Mon Mar 26, 2007 13:31:49
We have put the April updates on hold for a little bit, while we normalize the user tables. This means removing around 75 fields from the users table and splitting them up in to other tables. This 'should' speed up the site a LOT although it is a very big process.


nice to see you've broken your promises of 1 update per month already ched how long before the site goes down again...

deekdnc2.jpg
Super secret reinforced spam barrier 2.0
SoulRanger
ID: 297786
Level: 52
Posts: 11393
Score: 5
SoulRanger [297786]Reply | Quote | Report

Posted on Mon Mar 26, 2007 14:01:01
Good job!

starsigdm0.png
Super secret reinforced spam barrier 2.0
MrStealth
ID: 198414
Level: 52
Posts: 580
Score: 10
MrStealth [198414]Reply | Quote | Report

Posted on Mon Mar 26, 2007 14:04:51
yeah, why not for higher levels? many people just get "sick" of tc and quit, even lvl 20+ ppl

buying ecstacy in bulk pm and offer.
ca9c0ae5-a035-960c-198414.jpg
Super secret reinforced spam barrier 2.0
BigBadAndHeavy
ID: 422808
Level: 37
Posts: 712
Score: 3
BigBadAndHeavy [422808]Reply | Quote | Report

Posted on Mon Mar 26, 2007 15:59:08
So the database wasn't normalised No wonder there were so many problems with speed. If a databse was expected to take a hit evry few minutes I might not bother with normalisation, but for a site as busy as this - thats about as mad as only backing up the first row.

Forum Main>>Announcements>> User purge
First  << 1  2  3 >>  Last

This thread has been locked.