BFR bug!

Arthus · Post by **Arthus** » Mon Jul 21, 2008 3:09 am

I just lost 120mil trebuchets on BFR. I bought 5 mil infantry and suddenly all of my trebuchets went down to 1. Please help.

Post by **Freenhult** » Mon Jul 21, 2008 12:09 pm

My guess is the number rolled over. You hit the limit.

Arthus · Post by **Arthus** » Mon Jul 21, 2008 4:11 pm

120 mil is the limit? Crap, I just lost 10mil cash worth of trebs then, hehehe. Will be sure to keep that in mind.

Slasher · Post by **Slasher** » Mon Jul 21, 2008 5:01 pm

Still a bug though, if the limit was hit, it should say something to the user like "You already have the maximum ammount of x"

Post by **bjornredtail** » Mon Jul 21, 2008 7:30 pm

Intresting... Troops is of type varchar(210).

Now... The way that troops are stored is like this:
#of troop1|#troop 2|#troop3|#troop4...
And so on.

So... If you have 120 mil of each...

120000000|120000000|120000000|120000000

That's a lot short of 210 characters... Darn. So much for the easy fix.

What's your warband number on BFR? PM it to me if you'd like... I'd like to see what that is set to.

Post by **Freenhult** » Mon Jul 21, 2008 9:02 pm

I adjusted his numbers already. He's Murder... on BFR Nev.

Post by **bjornredtail** » Mon Jul 21, 2008 9:39 pm

So... This wasn't simply an overflow of the field on the DBMS?

Arthus · Post by **Arthus** » Mon Jul 21, 2008 9:45 pm

Um, infantry now reduced to 1. I capped them at 120mil, but they still dropped to that. This is becoming highly annoying, lol. Empire name is Murder...
If the infantry can be restored like the trebuchets were, that would be nice.

Shadow I · Post by **Shadow I** » Mon Jul 21, 2008 9:57 pm

Cap isnt 120mil, I have more than that on WoA all the time. I think I was over 200mil in T1 for a while.

Post by **bjornredtail** » Tue Jul 22, 2008 7:04 am

The thing isn't so much a cap on an individual troop, but on all troops. See above where I described how troops are stored by the DBMS. (On an asside, I'm halfway tempted to re-implement that as a table join, but that would be a royal pain to do on a running game. In fact, it would be a royal pain to do no matter what...)

mysql> select empire, troops from bfr_players where num = 7;
That seems to reveal that none of the troop numbers read 1 in the database. So, this is most certainly NOT a database overflow... (I'm almost tempted to post the results of that query, but I don't want to reveal anything about his troopcounts!)

EDIT: Sure enough, viewing it through the admin account ingame seems to show nothing wrong. Have any of my fellow admins done anything again?

Post by **Freenhult** » Tue Jul 22, 2008 8:13 pm

http://frostnflame.org/forum/index.php?showtopic=3733

Frost And Flame Forums

BFR bug!

Members connected in real time