« Forum Index < News and Announcements | Livio |
Age: 31 Karma: 470 Posts: 9620 Gender: Male Location: Arizona, USA pm | email
|
Update: I fixed it! You may find a few topics from the past few days that are marked as "unread" again, but now everyone's logs are back to what they used to be on Monday.
If you're logged in, you'll notice that you have tons and tons of "unread" posts. The reason for this is that I accidentally deleted a ton of them, and I was trying to restore them all with a backup but that just wouldn't work for some reason. So the table has been reset, and you'll just have to go and click on the Mark All Topics Read button, and then maybe catch up on the latest posts using the More Topics page.
What happened was that I was deleting a bunch of spam accounts when I made a typo and accidentally deleted my account and some related info from other database tables. So I tried to restore a backup from a few hours ago, but something went wrong and the backup was never formed, so I had to use a backup from two nights ago instead. No posts, topics, levels, or anything similar were lost. Although, some post and karma counts may be slightly off.
However, the_grimace's account was lost. But I already made it so that he will be contacted when he tries to log in again.
So yeah, nothing major here. Move along... | | shos |
~Jack of all trades~
Age: 31 Karma: 389 Posts: 8273 Gender: Male Location: Israel pm | email
|
uh, great, NOW i see this...so ignore my postss on the bug reports...
seriously, this sucks. i'd say 'you fail' but that would just be mean, so i'll just think it silently...
| | jazz |
Karma: 108 Posts: 3050 pm | email
|
Livio,
YOU FAiL!!!
Note how I used 'i' instead of 'I' because Livio's system messes it up and it becomes Another thing to fix.
| | Livio |
Age: 31 Karma: 470 Posts: 9620 Gender: Male Location: Arizona, USA pm | email
|
nah, that's just censors overriding each other. Not worthy of fixing...
But this could explain why no one was here yesterday. They probably thought no one was posting. | | Livio |
Age: 31 Karma: 470 Posts: 9620 Gender: Male Location: Arizona, USA pm | email
|
FIXED!
Everyone's logs are back to normal now, so it's like none of this ever happened!
It's been reset to what it was on Monday now, so all the topics and posts from the past two/three days will be marked as unread again, but at least everything else isn't. Like I said, I couldn't restore it before because it was so big and the server would time out all the SQL queries. I tried breaking it into smaller queries, but each was still very huge and it still didn't work. So today I spent a few hours working on it; I spent a good while trying to figure out how to use regular expression to break then up into small ones.
so yeah, nothing's wrong anymore. | | shos |
~Jack of all trades~
Age: 31 Karma: 389 Posts: 8273 Gender: Male Location: Israel pm | email
|
ahh great, so now after i've fixed it, i'm gonna have to fix it again. sweet.
| | shos |
~Jack of all trades~
Age: 31 Karma: 389 Posts: 8273 Gender: Male Location: Israel pm | email
|
o, and you didn't reset karma and post count.
| | Livio |
Age: 31 Karma: 470 Posts: 9620 Gender: Male Location: Arizona, USA pm | email
|
Post-Count Recount!
The list shows what everyone's count used to be, followed by the new count. If you're name isn't here, it's because there was no change. Code: 112lolzz: 25 => 24
aych bee: 28 => 34
a_neezles_a: 407 => 408
Bmwsu: 797 => 799
canadianstickdeath: 2208 => 2204
Cedric_09_: 854 => 848
Ckjr: 1302 => 1304
Dando: 717 => 718
dando52: 183 => 182
DeathBunni X: 51 => 54
Dekudude: 283 => 285
Florida: 151 => 128
GF4: 715 => 707
guyguyxtreme: 551 => 551
imtimi: 113 => 112
Isa: 3757 => 3743
jebby: 496 => 503
jellsprout: 2941 => 2936
kk66464522: 83 => 87
krotomo: 2148 => 2144
Lion: 6 => 4
Livio: 7314 => 7297
Quirvy: 4773 => 4756
rosabellis: 788 => 802
shos: 3694 => 3699
Silver: 1657 => 1652
snowman: 1130 => 1124
soccerboy13542: 611 => 613
sup_mus: 74 => 75
Teo_pl: 1139 => 1142
the_grimace: 1 => 6
Yaya: 1556 => 1552 Why did some people go down? Well, it seems that if you posted on a level, video, or news post, and then that level, video, or news post was deleted, your postcount would not go down to what it should be. That's been fixed now, and what a fail that it wasn't noticed sooner. | | shos |
~Jack of all trades~
Age: 31 Karma: 389 Posts: 8273 Gender: Male Location: Israel pm | email
|
I remember a few days ago having 3701 posts. so this is not quite correct, and karma is still wrong..
| | Livio |
Age: 31 Karma: 470 Posts: 9620 Gender: Male Location: Arizona, USA pm | email
|
'Livio' said: Why did some people go down? Well, it seems that if you posted on a level, video, or news post, and then that level, video, or news post was deleted, your postcount would not go down to what it should be. That's been fixed now, and what a fail that it wasn't noticed sooner. shosConfusionCount++;
And right now I'm trying to figure out why a karma recount would result in different karma for some people whose karma shouldn't be changing. | | Livio |
Age: 31 Karma: 470 Posts: 9620 Gender: Male Location: Arizona, USA pm | email
|
'Shos’ postcount' said: 3700 'Livio’s postcount' said: 7300 whoa I almost mistook that to mean that I had changed everyone's postcount to 7300. lol false alarm... | | Livio |
Age: 31 Karma: 470 Posts: 9620 Gender: Male Location: Arizona, USA pm | email
|
Karma Recount
only displaying people who had their karma changed:
Code: aych bee: 2 => -2
a_neezles_a: -420 => -421
bang_jan: -37 => -45
canadianstickdeath: 180 => 186
Captain Oblivious: 7 => 8
Captain Obvious: 76 => 48
Ckjr: 27 => 26
Dando: 148 => 153
dando52: 24 => 31
DeathBunni X: 3 => 4
GF4: 44 => 35
guyguyxtreme: -6 => -8
InterBot: -46 => -23
Isa: 259 => 258
jebby: 32 => 36
jorster23: 3 => 8
kk66464522: -14 => -15
krotomo: 60 => 49
midnight: -4 => -5
Quirvy: 280 => 273
rocket guy: -28 => -34
rosabellis: 53 => 49
shos: 120 => 118
Silver: -11 => -10
soccerboy13542: 46 => 47
sup_mus: -23 => -24
ThedeglitcherXD: 22 => 20
the_grimace: 0 => 1
Possible reasons for why some people's karma changed:
-it was karma from the past few days which wasn't accounted for
-it had a manual karma increase from after the last karma recount after the karma war, in which people complained that their karma had lowered.
-in the case of some staff accounts, it could've had any other manual karma changes.
also, I made sure not to touch jell's karma.
At first I thought there was something wrong with the karma system, so I kept looking for possible holes in the system. After finding none, I guess it's plausible that the possible reasons I just gave are responsible for some of these karma changes. | | shos |
~Jack of all trades~
Age: 31 Karma: 389 Posts: 8273 Gender: Male Location: Israel pm | email
|
I'm not sure what happened here. today my karma went 121->119->120->118 ._.
| | soccerboy13542 |
~*~Soccer~*~
Karma: 450 Posts: 4466 Gender: Male Location: 1945 pm | email
|
livio. i had 49. then it went to 46. now its at 47!?!?!?
'Livio' said: You know, I was thinking of getting an internship at Microsoft, but I'm not sure I want their lameness to rub off on me. | | Harumbai |
[|]-X-[|]
Age: 30 Karma: 260 Posts: 1743 Location: New Zealand pm | email
|
LivioFailCount++;
I've lost 5 posts and my topics are all messed up still, Well done Livio!!
Upcoming HatPC level: Sanctuary, coming soon to an internet browser near you... | | |
« Forum Index < News and AnnouncementsIn order to post in the forums, you must be logged into your account. Click here to login.
|