Author Topic: !bound module not working correctly after tonight's raid reset (Read 6090 times)

Kepha · « **Reply #15 on:** August 10, 2011, 03:17:49 pm »

I did do that Getrix, but yesterday it didn't work, not sure why. Today's morning I give it another try and it loaded well.

Still, the problem maintains. I need either to someone tell me how to remove the single quotes or share the file with changes made.

BoA-Gert · « **Reply #16 on:** August 10, 2011, 04:57:35 pm »

Quote from: Kepha on August 10, 2011, 10:35:53 am

I don't see single quotes (') to remove in bot_bound_instance or I don't know how to find them. Can you give me a "how-for-dummies"?

Click the Edit button on the line where the instance_fullname has a single quote...you can then just edit it by taking out the ' and clicking save.

The ones you have with single quotes are the 1,2,3 and 7 (based on your screenshot)

Getrix - from what I saw it's when the instance_fullname is used - when the bots work again with AoC, I'll re-add the single quote and post what happens.

Kepha · « **Reply #17 on:** August 10, 2011, 07:16:42 pm »

Was thinking something different but you meant the instance names themselfs, example "dragon's", etc.

Changed them and within a week we will see. I found weird if this is the problem. The table that saves the binds still had the previous, it didn't delete them. But we will see

Kepha · « **Reply #18 on:** August 16, 2011, 12:20:13 pm »

Well mates, problem continues. After tonight reset the !bound is messed up again. I removed the quotes in dungeons name, restarted bot and didn't work.
The problem should be related with the ID's and/or my SQL base. The instance_bound still contains the !bound's made, it didn't clear after reset and this only happens with T1,2,3,4. Rest seems to binb/unbind.

Getrix · « **Reply #19 on:** August 16, 2011, 12:55:50 pm »

It shouldnt clear the table..
Latest update made it so it stamp the bound (Start and End).
If End stamp is older then current time, you are not bound.

What OS do you use? Any special language setup?
Can you also provide phpinfo()?

When you do "!bound" for raid instance, script is doing this

Quote

$raid_reset = $this -> bot -> core("settings") -> get("Bound", "ServerResetTime");
$bound_finish = date('Y-m-d H:i:s', strtotime('next tuesday +'.$raid_reset.' hour'));

$raid_reset is the time difference for your server and funcom server for when raid reset is happening. There is different opinions on when this is, but something around 02:00 tuesday night is close i think. Check this with "!set bound"

$bound_finish sets the timestamp for next tuesday and also calculate the difference from your serverclock/offset you put in settings.
It could be that your server do not work with "strtotime" (wierd if so) or you have a language installation not supporting "next tuesday" (Also wierdo).

Could you post a screen of your current bound's sql table containing bounds?
And then do a new "!bound" on some raids location before taking another screenshot of table?

Getrix · « **Reply #20 on:** August 16, 2011, 01:23:01 pm »

Ok, i looked into the code again and tried running it on Windows. I get same error as you, i think..
So rewrote the $bound_finish abit and tested, this time it gives same stamp for windows and linux.

Replace line 144:

Code: [Select]

$bound_finish = date('Y-m-d H:i:s', strtotime('next tuesday +'.$raid_reset.' hour'));
With

Code: [Select]

$bound_finish = date('Y-m-d H:i:s', strtotime('+'.$raid_reset.' hour next tuesday'));
Uploaded new version here too: http://dump.sjef.biz/aoc/bebot/Bound/Bound.phps

Kepha · « **Reply #21 on:** August 16, 2011, 07:03:26 pm »

Oh boy. Getrix

I don't know what to say. That file just like the previous one you had, on starting the bot just loads all the "code". I can see all the text inside the file passing.. (not reading).
No !bound or nothing.

Getrix · « **Reply #22 on:** August 16, 2011, 07:06:29 pm »

Make sure you copy it correctly.. Not with the colorcodes..
If you right click and save you will get this colorcodes. Open the website, ctrl+a and ctrl-c to copy it into the file as text