Sql update old=old+1
i use this plugin:
http://forums.alliedmods.net/showthread.php?t=130417 and add one more column to db: Code:
`improve` int(10) NOT NULL DEFAULT '0',i try; Code:
formatex(createinto, sizeof createinto - 1, "UPDATE `%s` SET time='%f', weapon='%s', date='%s', improve='+1' ,server='%s'%s%s WHERE authid='%s' AND mapname='%s'", style == PRO_TOP ? "kz_pro15" : "kz_nub15", newtime, g_weaponsnames[str_to_num(x2)], dia, server, style == PRO_TOP ? "" : gochecks, style == PRO_TOP ? "" : checkpoints, steam, map)Code:
Handle:Query=SQL_PrepareQuery( SqlConnection, "SELECT improve FROM `kz_pro15` WHERE authid='%s' AND mapname='%s'", authid, mapname)Code:
formatex(createinto, sizeof createinto - 1, "UPDATE `%s` SET time='%f', weapon='%s', date='%s', improve='$oldimprove+1' ,server='%s'%s%s WHERE authid='%s' AND mapname='%s'", style == PRO_TOP ? "kz_pro15" : "kz_nub15", newtime, g_weaponsnames[str_to_num(x2)], dia, server, style == PRO_TOP ? "" : gochecks, style == PRO_TOP ? "" : checkpoints, steam, map) |
Re: Sql update old=old+1
PHP Code:
|
Re: Sql update old=old+1
wtf :D its work, thanks :D
|
| All times are GMT -4. The time now is 23:18. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.