Guild war script needs fixing.

[Lucenzo]

Hey Me again! :L


Aeron - Wars


The problem is that when someone disbands a guild it still shows on that page, also when a war ends it still shows. But i would like the wars to be removed when guild goes disband or war ended, so it doesn't spam the page.

Not sure if this is only .php or lua also, it would be really amazing if someone could help.
Can pm all scripts by private x

 

[Cykotitan]

also when a war ends it still shows.

old wars war invitations are only removed on each server start (through the onStartup script), IIRC

 

[Lucenzo]

Well i have restarted the server previously many times and they are still there? :L
But i use different php script and other sql querries for it , as you can see on the website it's a bit different than Elfs.

db.executeQuery("DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin` < " .. (os.time() - 2 * 86400) .. ";")
db.executeQuery("UPDATE `guild_wars` SET `status` = 5, `end` = " .. os.time() .. " WHERE `status` = 1 AND `end` > 0 AND `end` < " .. os.time() .. ";")

http://www14.speedy*****malware.localhost/files/27973172/download/phpadmin.png

 

[Lucenzo]

Up

 

[Lucenzo]

Svoled myself. Close please x x