seems like most n00bs come in with a question mark flag when their DNS usually resolves.

Also some people are from the mysterious nation of "Reserved"

please don't take my reserved away

Ever since goluigi wrote that wonderful story about Slimeball in the land of question marks I feel more than ever at home in the land of Unknown. :3

too bad u came to the usa and now you'll never be in nice question mark land : (

awwww

Epic caterpillar is finally revealed to be Canadian!!! Paesano!

comrades

I think the IP/country table needs to be updated periodically in the back end of botb for it to stay current...

Yes, I think that I need to make a chron job out of this.

When a BotBr's IP address changes is when BotB looks for the country of origin. I have it set to not replace a BotBr's current country if the new result is 'unknown' but need to add the 'reserved' exception as well.

How often should the lookup table be updated? Would once a week be plenty often enough? I really have no idea how often this type of thing changes around.

Currently, I manually download a zipped CSV text file and optimize it for BotB's database, replacing that table altogether. I don't think it would be too hard to automate this process. There's always a chance something could go curflooey for a BotBr's flag during this process . . .

i believe during non-peak hours everyday might be safe. 4:30AM EST should be good. most people on here are american and the cronjob shouldn't take that long.

maybe post up a notice with the merchant saying, "the god pukeseidon has stirred up the waves for a slow travel, matey. hold tight!" or something if the site remains functional.

Yes, but a lot of the americans are awake at that time regardless :D

`Tis true! ;D/

to compo? if people are just going to check a thread or two, i don't see a big deal. i just don't want to disturb OHBs or submissions to battles. i also think that certain intense cron jobs should be postponed the last few hours of battle submission time.