Should We Rewind to Friday?

[Lone]

with this thread in mind.
http://www.mirrevenge.com/forums/showthread.php?t=13204


the rewind will restore the database we backed up on friday evening.

if we do a rewind it will mean all the leveling/items gained since the reboot on friday evening will be lost, but we start with a clean database.

So the poll is up.


Do we rewind and see what happens or do we try to sort through those that were online and try to recover bits and pieces individually?



(Please only vote if you play the low rate server)

[Lone]

Wacey had a good idea which was to take a note of the current level and % and then do the rewind then simply level the people back to those levels - this way its only the items that will end up being lost.

i would prefer that as Shirley managed to get to 60 over the weekend and i got 52 on my wizzy. i wouldnt mind losing items i found as long the levels were able to be returned. (as shirley was grinding through the night to get the level)

im voting rewind - with the chance of releveling (if thats what we decide to do )

[Falky]

vote yes aslong as we keep the levels, and gamepoints? :S

[LonesGirlfriend]

as much as i really dont want a rewind i think it should be done to save more hassles and possible problems in the future.
the drops i had over the weekend i will get those again eventually, i really dont want to spend more late nights trying to regain my levels so i am happy with the screenie approach to get the levels and % back.

[Lone]

i've just had an idea - Was it only items that were affected in the problem???

because if my theory if right we might be able to restore just the UserItem table of the database from friday which should leave the CharInfo (which contains level/gold/exp/HP/MP/GG/GP/PKpoints etcetc) alone.

if this doesnt actually work it might cause more problems (although at the moment i cant see why) and may require the rewind anyway but you never know it might be a fairly simple fix although you would still lose the items that were gained over the weekend (on the plus side if you used EXP bars they should in theory return)

ill see if i can find any reason why that wouldnt work and we can see how the vote goes - but first i need a cup of tea.

much love

Lone



We might also need to reload the TrustMerchant table aswell to avoid conflicting items. this would mean that items would go back to how they were on friday, but the gold for sales will still remain.

[Petroni]

i've just had an idea - Was it only items that were affected in the problem???

because if my theory if right we might be able to restore just the UserItem table of the database from friday which should leave the CharInfo (which contains level/gold/exp/HP/MP/GG/GP/PKpoints etcetc) alone.

if this doesnt actually work it might cause more problems (although at the moment i cant see why) and may require the rewind anyway but you never know it might be a fairly simple fix although you would still lose the items that were gained over the weekend (on the plus side if you used EXP bars they should in theory return)

ill see if i can find any reason why that wouldnt work and we can see how the vote goes - but first i need a cup of tea.

much love

Lone

We might also need to reload the TrustMerchant table aswell to avoid conflicting items. this would mean that items would go back to how they were on friday, but the gold for sales will still remain.

Not sure if it was just items and I dont think there is a way to find out.

Trouble with databases is that they are just 'thick' and do excatly what they were told to do, even if what they were told was an error. We won tknow what this one was told to do by the unplanned error until we try to access something that later turns out to have stored wrongly/corruptly and then anything can happen but it wont be good.

My view would be rewind and do the legwork needed to replace/relevel players. Not an exact science but probably for the best . As Wacey says its a pain but we are only talking about 40 active users or so not as bad as it could be.

I have done most of the in game kit replacements already so players can continue to level etc so we have a few hours of thinking time, maybe make a decision at 7pm tonight after checking what will be involved and take a copy of the current DB as well to use as a checking tool for the inevitable 'I definately had a pro ring' stuff that tends to arise from lifes chancers

Penny

[Lone]

That does make sense - when i had a cup of tea and had a couple of bits pointed out it would seem that a rewind is probably for the best.

i have thursday and friday off so if we can get recovered ill see if i can get my event idea sorted out for this weekend to help cheer people up

[razzelranz]

shall i screeny my kit before 7pm tonight as u know cant normally get on that early due to misses and dont want to be left with no kit and no proof of what kit i had ?

[Petroni]

shall i screeny my kit before 7pm tonight as u know cant normally get on that early due to misses and dont want to be left with no kit and no proof of what kit i had ?

Yes please mate, and a screenie of the lvl/exp please

Also would the folowing players msg me in game

Aria4
Kiubi
2000
Torch
SleveTheWizzie
Ariana
Jinkx
Nitil

Thank you

Penny

[razzelranz]

errrmmm i have added items so do i need a screeny of each item ??? also what is command for scrennie LOL