auto save on

[Calon]

in my server the samples look in DB save = 0 but when someone create a character his save = 1


how can i fix this ?

 

[Sonical]

Add to login.lua

if isPlayer(cid) == true then
    db.executeQuery("UPDATE `players` SET `save` = 0 WHERE `name` = "..getCreatureName(cid)..";")
end

 

[Calon]

not working

[13/09/2010 01:58:54] mysql_real_query(): UPDATE `players` SET `save` = 0 WHERE `name` = Admin Fouad; - MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Fouad' at line 1 (1064)

 

[president vankk]

/search.php

http://otland.net/f82/best-save-system-without-server-freeze-96044/

 

[Sonical]

/search.php

http://otland.net/f82/best-save-system-without-server-freeze-96044/

gtfo


@topic'

if isPlayer(cid) == true then
    db.executeQuery("UPDATE `players` SET `save` = 0 WHERE `save` = 1;")
end

 

[Bogart]

gtfo


@topic'

if isPlayer(cid) == true then
    db.executeQuery("UPDATE `players` SET `save` = 0 WHERE `save` = 1;")
end

+1.

 

[Fallen]

db.executeQuery("UPDATE `players` SET `save` = 0 WHERE `name` = "..db.escapeString(getCreatureName(cid))..";")

 

[Calon]

gtfo


@topic'

if isPlayer(cid) == true then
    db.executeQuery("UPDATE `players` SET `save` = 0 WHERE `save` = 1;")
end

+1.