mysql R41-4 help - Printable Version

mysql R41-4 help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql R41-4 help (/showthread.php?tid=648274)

mysql R41-4 help - cuchipkg - 19.01.2018

if i use this it working

PHP код:



new SoDL[300];

mysql_format(VungDuLieu, SoDL, sizeof(SoDL), "UPDATE `TaiKhoan` SET \

    `TenTK`='%s', \

    `CapDo`=%d, \

    `CapAdmin`=%d, \

    `NhanVat`=%d, \

    `TiLeChet`=%d, \

    `TiLeGiet`=%d, \

    `Tien`=%d, \

        WHERE `ID`=%d",

    TaiKhoan[playerid][TenTK],

    TaiKhoan[playerid][CapDo],

    TaiKhoan[playerid][CapAdmin],

    TaiKhoan[playerid][NhanVat],

    TaiKhoan[playerid][TiLeChet],

    TaiKhoan[playerid][TiLeGiet],

    TaiKhoan[playerid][Tien],

TaiKhoan[playerid][IDDuLieu]);

mysql_tquery(VungDuLieu, SoDL, "LuuTaiKhoan","d", playerid);

but im use like that it not working save data what wrong with my script ?

PHP код:



mysql_format(VungDuLieu, SoDL, sizeof(SoDL), "UPDATE `TaiKhoan` SET \

    `TenTK`='%s', \

    `CapDo`=%d, \

    `CapAdmin`=%d, \

    `NhanVat`=%d, \

    `TiLeChet`=%d, \

    `TiLeGiet`=%d, \

    `Tien`=%d, \

    `Unit`=%d, \

    `Mau`=%f, \

    `Giap`=%f, \

    `KGTK`=%d, \

    `VTKG`=%d, \

    `ViTriNCX`=%f, \

    `ViTriNCY`=%f, \

    `ViTriNCZ`=%f, \

    `ChipKN`=%d, \

    `ViTriNCC`=%f, \

    WHERE `ID`=%d",

    TaiKhoan[playerid][TenTK],

    TaiKhoan[playerid][CapDo],

    TaiKhoan[playerid][CapAdmin],

    TaiKhoan[playerid][NhanVat],

    TaiKhoan[playerid][TiLeChet],

    TaiKhoan[playerid][TiLeGiet],

    TaiKhoan[playerid][Tien],

    TaiKhoan[playerid][Unit],

    TaiKhoan[playerid][MauNC],

    TaiKhoan[playerid][GiapNC],

    TaiKhoan[playerid][VTKG],

    TaiKhoan[playerid][KGTK],

    TaiKhoan[playerid][ViTriNCX],

    TaiKhoan[playerid][ViTriNCY],

    TaiKhoan[playerid][ViTriNCZ],

    TaiKhoan[playerid][ChipKN],

    TaiKhoan[playerid][ViTriNCC],

    TaiKhoan[playerid][IDDuLieu]);

    mysql_tquery(VungDuLieu, SoDL, "LuuTaiKhoan","d", playerid);

Re: mysql R41-4 help - Jokers98s - 19.01.2018

Any error showing up ?

Re: mysql R41-4 help - cuchipkg - 19.01.2018

no error showing

Re: mysql R41-4 help - Jokers98s - 19.01.2018

i mean server log !

Re: mysql R41-4 help - cuchipkg - 19.01.2018

my server log

Код:

*** Streamer Plugin v2.9.1 by Incognito loaded ***

[12:02:34]   Loaded.
[12:02:34]  Loading plugin: Whirlpool
[12:02:34]  
[12:02:34]  ==================
[12:02:34]  
[12:02:34]   Whirlpool loaded
[12:02:34]  
[12:02:34]  ==================
[12:02:34]  
[12:02:34]   Loaded.
[12:02:34]  Loaded 4 plugins.

[12:02:34] 
[12:02:34] Filterscripts
[12:02:34] ---------------
[12:02:34]   Loaded 0 filterscripts.

[12:02:34]  
[12:02:34] --------------------------------------
[12:02:34]  Anticheat Nex-AC loaded!
[12:02:34]  Anticheat version: 1.9.32
[12:02:34]  Author: Nexius
[12:02:34] --------------------------------------

[12:02:34] This server folder has been put together by Ricky Phelps.
[12:02:34] [Du Lieu] Ket Noi Vung Du Lieu Thanh Cong // it susces connect mysql
[12:02:34] 
|-------------PoCo-------------|
[12:02:34] -------Gamemode By CuChip-------
[12:02:34] |-------------PoCo-------------|

[12:02:34] Number of vehicle models: 0
[12:02:53] [connection] 127.0.0.1:57977 requests connection cookie.
[12:02:54] [connection] incoming connection: 127.0.0.1:57977 id: 0
[12:02:54] [join] Cu_Chip has joined the server (0:127.0.0.1)
[12:03:07] [part] Cu_Chip has left the server (0:1)

Re: mysql R41-4 help - Jokers98s - 19.01.2018

Try this "mysql_tquery(VungDuLieu, SoDL);"

Re: mysql R41-4 help - cuchipkg - 19.01.2018

oh i see what wrong error i want delete , from `ViTriNCC`=%f, \ to `ViTriNCC`=%f \
thanks for help REP+ for you