Lua Function db.executeQuery

[Wezza]

Hello,



The idea from this function is to set the Guild which deals most dmg to a monster to become the owners of a castle... http://grand-ot.ddns.net/?subtopic=thecastle

when someone kills the King of the castle, It doesn't update the database for the new guildid owners..

The table name is Castle, and 2 columns in it, guildid and time..

function setCastleOwners(id, time)
    db.executeQuery("UPDATE `castle` SET `guildid` = '"  .. id .. "', `time` = '" .. time .. "' WHERE `time` > 0;")
end

for example if Guildid = 1 are the current castle owners, when guildid = 2 kill the king of the castle they, should become the castle owners but it doesn't update the column in the database (guildid)..

no errors in console, but maybe I wrote the queries wrong for the database;

please help

 

[Cornex]

Hello,



The idea from this function is to set the Guild which deals most dmg to a monster to become the owners of a castle... http://grand-ot.ddns.net/?subtopic=thecastle

when someone kills the King of the castle, It doesn't update the database for the new guildid owners..

The table name is Castle, and 2 columns in it, guildid and time..

function setCastleOwners(id, time)
    db.executeQuery("UPDATE `castle` SET `guildid` = '"  .. id .. "', `time` = '" .. time .. "' WHERE `time` > 0;")
end

for example if Guildid = 1 are the current castle owners, when guildid = 2 kill the king of the castle they, should become the castle owners but it doesn't update the column in the database (guildid)..

no errors in console, but maybe I wrote the queries wrong for the database;

please help

Have you tried run the query manually from database?

 

[Wezza]

I don't get it, how?

you mean changing the guildid to other id?

@Cornex

 

[Cornex]

I don't get it, how?

you mean changing the guildid to other id?

@Cornex

Try to run the query with any value.. etc

UPDATE `castle` SET `guildid` = 3 , `time` = 4354353132 WHERE `time` > 0

 

[Wezza]

It didn't update too.. I think queries are wrong.. what do u think

 

[Wezza]

bump

 

[Cornex]

bump

The whole query looks very weird to me, why would you set this values to all rows that have more than 0 in time? Need to get more info and also database structure.

 

[Wezza]

Its easy.. The Player kill a monster .. when monster is killed -- > check player guild .. --> set guildid to new guildid in database..

check this it will help you much; http://grand-ot.ddns.net/?subtopic=thecastle


the guild who dealt the most damage (all together), will be the new owners of the Castle.

New owners means updating the old guild owners (the guild that already own the castle) to new owners (the guild that are attacking -and dealing the most dmg- to the monster *Castle defender monster*) in database.. and this is what is not working.. everything else works like a charm.. im usingUniformserver, @Cornex

 

[Wezza]

bump