mysql R41-4 help
#1

if i use this it working
PHP код:
new SoDL[300];
mysql_format(VungDuLieuSoDLsizeof(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(VungDuLieuSoDL"LuuTaiKhoan","d"playerid); 
but im use like that it not working save data what wrong with my script ?
PHP код:
mysql_format(VungDuLieuSoDLsizeof(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(VungDuLieuSoDL"LuuTaiKhoan","d"playerid); 
Reply
#2

Any error showing up ?
Reply
#3

no error showing
Reply
#4

i mean server log !
Reply
#5

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)
Reply
#6

Try this "mysql_tquery(VungDuLieu, SoDL);"
Reply
#7

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


Forum Jump:


Users browsing this thread: 2 Guest(s)