1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese

Threaded Mode
[Ajuda] Problema MYSQL nгo estб salvando
maikons
Gangsta
****
Posts: 537
Threads: 147
Joined: Jun 2013
Reputation: 0
#1

27.08.2015, 20:55
OnPlayerSave (chamado quando jogador disconecta)
Код:
stock OnPlayerSave(playerid) {
	new query[1250], ip[25];
	GetPlayerIp(playerid, ip, sizeof(ip));
	money[playerid] = GetPlayerMoneyEx(playerid);

	format(query, sizeof(query), "UPDATE `accounts` SET `Username` = '%s', `IP` = '%s', `scorelevel` = '%d', `maconha` = '%d', `sementes` = '%d', `BPsize` = '%d', `lastlogin` = '%d', `wanted` = '%d', `moneybag` = '%d', `COPskills` = '%d', `CRIMINALskills` = '%d', `PARAMEDICskills` = '%d', `admin' = '%d', `money` = '%d', `bank` = '%d', `kills` = '%d', `deaths` = '%d' WHERE `Username` = '%s' ",
	GetName(playerid),
	ip,
	scorelevel[playerid],
	maconha[playerid],
	sementes[playerid],
	BPsize[playerid],
	lastlogin[playerid],
	wanted[playerid],
	moneybag[playerid],
	COPskills[playerid],
	CRIMINALskills[playerid],
	PARAMEDICskills[playerid],
	admin[playerid],
	money[playerid],
	bank[playerid],
	kills[playerid],
	deaths[playerid],
	GetName(playerid));
	mysql_pquery(ConnectMYSQL, query);

	format(query, sizeof(query), "UPDATE `accounts` SET `eagleSPAWN` = '%d', `shotgunSPAWN` = '%d', `spazSPAWN` = '%d', `mp5SPAWN` = '%d', `akSPAWN` = '%d', `m4SPAWN` = '%d', `rifleSPAWN` = '%d', `sniperSPAWN` = '%d', `meleeSPAWN` = '%d' WHERE `Username` = '%s'",
	GetName(playerid),
	EagleSPAWN[playerid],
	shotgunSPAWN[playerid],
	spazSPAWN[playerid],
	mp5SPAWN[playerid],
	akSPAWN[playerid],
	m4SPAWN[playerid],
	rifleSPAWN[playerid],
	sniperSPAWN[playerid],
	meleeSPAWN[playerid],
	GetName(playerid));
	mysql_pquery(ConnectMYSQL, query);

	format(query, sizeof(query), "UPDATE `accounts` SET `DP` = '%d', `VIP` = '%d', `fmembro` = '%d', `fcargo` = '%d', `preso` = '%d', `presotime` = '%d', `startVIPdia` = '%d', `startVIPmes` = '%d', `startVIPano` = '%d', `carid` = '%d', `carpos0` = '%f', `carpos1` = '%f', `carpos2` = '%f', `carpos3` = '%f' WHERE Username = '%s'",
	DP[playerid],
	VIP[playerid],
	fmembro[playerid],
	fcargo[playerid],
	preso[playerid],
	presotime[playerid],
	startVIPdia[playerid],
	startVIPmes[playerid],
	startVIPano[playerid],
	carid[playerid],
	carpos[playerid][0],
	carpos[playerid][1],
	carpos[playerid][2],
	carpos[playerid][3],
	GetName(playerid) );
	mysql_pquery(ConnectMYSQL, query);
	
	format(query, sizeof(query), "UPDATE `accounts` SET `spawnpoint` = '%d', `housekey` = '%d', `idiom` = '%d', `tutorial` = '%d', `banned` = '%d', `leftBANdia` = '%d', `leftBANmes` = '%d', `leftBANano` = '%d' WHERE Username = '%s'",
	spawnpoint[playerid],
	housekey[playerid],
	idiom[playerid],
	tutorial[playerid],
	banned[playerid],
	leftBANdia[playerid],
	leftBANmes[playerid],
	leftBANano[playerid],
	GetName(playerid) );
	mysql_pquery(ConnectMYSQL, query);
}
Adicionei isso para ver que erros estavam dando:
OnGameModeInit:
Код:
mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG);
Код:
public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
	printf("[OnQueryError] errorid %i query %s", errorid, query);
	return 1;
}
Erros do MYSQL.log
Quando carrega o player
Код:
[19:18:42] [DEBUG] mysql_format - connection: 1, len: 512, format: "SELECT * FROM `accounts` WHERE `Username` = '%s'"
[19:18:42] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `accounts` WHERE `Username` = 'GOD'", callback: "OnConnection", format: "i"
[19:18:42] [DEBUG] CMySQLQuery::Execute[OnConnection] - starting query execution
[19:18:42] [DEBUG] CMySQLQuery::Execute[OnConnection] - query was successfully executed within 56.471 milliseconds
[19:18:42] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:18:42] [DEBUG] Calling callback "OnConnection"..
[19:18:42] [DEBUG] cache_get_data - connection: 1
[19:18:42] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[19:18:48] [DEBUG] mysql_format - connection: 1, len: 1024, format: "SELECT * FROM accounts WHERE Senha = '%e' LIMIT 0,1"
[19:18:48] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM accounts WHERE Senha = 'parede22' LIMIT 0,1", callback: "OnLogin", format: "d"
[19:18:48] [DEBUG] CMySQLQuery::Execute[OnLogin] - starting query execution
[19:18:48] [DEBUG] CMySQLQuery::Execute[OnLogin] - query was successfully executed within 1.13 milliseconds
[19:18:48] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:18:48] [DEBUG] Calling callback "OnLogin"..
[19:18:48] [DEBUG] cache_get_data - connection: 1
[19:18:48] [DEBUG] mysql_format - connection: 1, len: 512, format: "SELECT * FROM `accounts` WHERE `Username` = '%s'"
[19:18:48] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `accounts` WHERE `Username` = 'GOD'", use_cache: true
[19:18:48] [DEBUG] CMySQLQuery::Execute - starting query execution
[19:18:48] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 1.116 milliseconds
[19:18:48] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[19:18:48] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[19:18:48] [DEBUG] cache_get_data - connection: 1
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "UserID", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "UserID", data: "13"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "scorelevel", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "scorelevel", data: "510"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "maconha", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "maconha", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "sementes", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "sementes", data: "3"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "BPsize", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "BPsize", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "wanted", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "wanted", data: "4"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "moneybag", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "moneybag", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "COPskills", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "COPskills", data: "253"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "CRIMINALskills", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "CRIMINALskills", data: "257"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "PARAMEDICskills", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "PARAMEDICskills", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "admin", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "admin", data: "1337"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "money", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "money", data: "5008051"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "bank", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "bank", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "kills", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "kills", data: "1"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "deaths", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "deaths", data: "12"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "DP", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "DP", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VIP", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "VIP", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fmembro", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fmembro", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "fcargo", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fcargo", data: "5"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "preso", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "preso", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "presotime", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "presotime", data: "-1"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "startVIPdia", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "startVIPdia", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "startVIPmes", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "startVIPmes", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "startVIPano", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "startVIPano", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "carid", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "carid", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "spawnpoint", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "spawnpoint", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "housekey", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "housekey", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "tutorial", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "tutorial", data: "100"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "idiom", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "idiom", data: "2"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "banned", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "banned", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "leftBANdia", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "leftBANdia", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "leftBANmes", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "leftBANmes", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "leftBANano", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "leftBANano", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "eagleSPAWN", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "eagleSPAWN", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "shotgunSPAWN", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "shotgunSPAWN", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "spazSPAWN", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "spazSPAWN", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "mp5SPAWN", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "mp5SPAWN", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "akSPAWN", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "akSPAWN", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "m4SPAWN", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "m4SPAWN", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "rifleSPAWN", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "rifleSPAWN", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "sniperSPAWN", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "sniperSPAWN", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "meleeSPAWN", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "meleeSPAWN", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_int - row: 0, field_name: "lastlogin", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "lastlogin", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_float - row: 0, field_name: "carpos0", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "carpos0", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_float - row: 0, field_name: "carpos1", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "carpos1", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_float - row: 0, field_name: "carpos2", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "carpos2", data: "0"
[19:18:48] [DEBUG] cache_get_field_content_float - row: 0, field_name: "carpos3", connection: 1
[19:18:48] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "carpos3", data: "0"
Quando salva o player
Код:
[19:22:20] [DEBUG] mysql_pquery - connection: 1, query: "UPDATE `accounts` SET `Username` = '[8G]Tiago', `IP` = '255.255.", callback: "(null)", format: "(null)"
[19:22:20] [DEBUG] mysql_pquery - connection: 1, query: "UPDATE `accounts` SET `eagleSPAWN` = '91', `shotgunSPAWN` = '0',", callback: "(null)", format: "(null)"
[19:22:20] [DEBUG] mysql_pquery - connection: 1, query: "UPDATE `accounts` SET `DP` = '0', `VIP` = '0', `fmembro` = '0', ", callback: "(null)", format: "(null)"
[19:22:20] [DEBUG] mysql_pquery - connection: 1, query: "UPDATE `accounts` SET `spawnpoint` = '0', `housekey` = '0', `idi", callback: "(null)", format: "(null)"
[19:22:20] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:22:20] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:22:20] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 'money` = '0', `bank` = '0', `kills` = '1', `deaths` = '12' WHERE `Username` = '[' at line 1
[19:22:20] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 2.132 milliseconds
[19:22:20] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[19:22:20] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:22:20] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.936 milliseconds
[19:22:20] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:22:20] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[19:22:20] [DEBUG] Calling callback "OnQueryError"..
[19:22:20] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[19:22:20] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.784 milliseconds
[19:22:20] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

Erros do server.log
Код:
[19:22:20] [OnQueryError] errorid 1064 query UPDATE `accounts` SET `Username` = 'GOD', `IP` = '255.255.255.255', `scorelevel` = '510', `maconha` = '0', `sementes` = '3', `BPsize` = '0', `lastlogin` = '237', `wanted` = '4', `moneybag` = '0', `COPskills` = '253', `CRIMINALskills` = '257', `PARAMEDICskills` = '0', `admin' = '1337', `money` = '0', `bank` = '0', `kills` = '1', `deaths` = '12' WHERE `Username` = 'GOD'
Find
Reply
zPain
Gangsta
****
Posts: 665
Threads: 6
Joined: Sep 2013
Reputation: 0
#2

27.08.2015, 20:59
Ao invйs de `admin`, vocк colocou `admin'.
Find
Reply
[BOPE]Seu._.Madruga
High-roller
*****
Posts: 1,079
Threads: 47
Joined: Nov 2011
Reputation: 0
#3

27.08.2015, 21:38
PHP код:
stock OnPlayerSave(playerid) {
    new query[1250], ip[25];
    GetPlayerIp(playerid, ip, sizeof(ip));
    money[playerid] = GetPlayerMoneyEx(playerid);

    format(query, sizeof(query), "UPDATE `accounts` SET `Username` = '%s', `IP` = '%s', `scorelevel` = '%d', `maconha` = '%d', `sementes` = '%d', `BPsize` = '%d', `lastlogin` = '%d', `wanted` = '%d', `moneybag` = '%d', `COPskills` = '%d', `CRIMINALskills` = '%d', `PARAMEDICskills` = '%d', `admin` = '%d', `money` = '%d', `bank` = '%d', `kills` = '%d', `deaths` = '%d' WHERE `Username` = '%s' ",
    GetName(playerid),
    ip,
    scorelevel[playerid],
    maconha[playerid],
    sementes[playerid],
    BPsize[playerid],
    lastlogin[playerid],
    wanted[playerid],
    moneybag[playerid],
    COPskills[playerid],
    CRIMINALskills[playerid],
    PARAMEDICskills[playerid],
    admin[playerid],
    money[playerid],
    bank[playerid],
    kills[playerid],
    deaths[playerid],
    GetName(playerid));
    mysql_pquery(ConnectMYSQL, query);

    format(query, sizeof(query), "UPDATE `accounts` SET `eagleSPAWN` = '%d', `shotgunSPAWN` = '%d', `spazSPAWN` = '%d', `mp5SPAWN` = '%d', `akSPAWN` = '%d', `m4SPAWN` = '%d', `rifleSPAWN` = '%d', `sniperSPAWN` = '%d', `meleeSPAWN` = '%d' WHERE `Username` = '%s'",
    GetName(playerid),
    EagleSPAWN[playerid],
    shotgunSPAWN[playerid],
    spazSPAWN[playerid],
    mp5SPAWN[playerid],
    akSPAWN[playerid],
    m4SPAWN[playerid],
    rifleSPAWN[playerid],
    sniperSPAWN[playerid],
    meleeSPAWN[playerid],
    GetName(playerid));
    mysql_pquery(ConnectMYSQL, query);

    format(query, sizeof(query), "UPDATE `accounts` SET `DP` = '%d', `VIP` = '%d', `fmembro` = '%d', `fcargo` = '%d', `preso` = '%d', `presotime` = '%d', `startVIPdia` = '%d', `startVIPmes` = '%d', `startVIPano` = '%d', `carid` = '%d', `carpos0` = '%f', `carpos1` = '%f', `carpos2` = '%f', `carpos3` = '%f' WHERE Username = '%s'",
    DP[playerid],
    VIP[playerid],
    fmembro[playerid],
    fcargo[playerid],
    preso[playerid],
    presotime[playerid],
    startVIPdia[playerid],
    startVIPmes[playerid],
    startVIPano[playerid],
    carid[playerid],
    carpos[playerid][0],
    carpos[playerid][1],
    carpos[playerid][2],
    carpos[playerid][3],
    GetName(playerid) );
    mysql_pquery(ConnectMYSQL, query);
    
    format(query, sizeof(query), "UPDATE `accounts` SET `spawnpoint` = '%d', `housekey` = '%d', `idiom` = '%d', `tutorial` = '%d', `banned` = '%d', `leftBANdia` = '%d', `leftBANmes` = '%d', `leftBANano` = '%d' WHERE Username = '%s'",
    spawnpoint[playerid],
    housekey[playerid],
    idiom[playerid],
    tutorial[playerid],
    banned[playerid],
    leftBANdia[playerid],
    leftBANmes[playerid],
    leftBANano[playerid],
    GetName(playerid) );
    mysql_pquery(ConnectMYSQL, query);
} 
Find
Reply
maikons
Gangsta
****
Posts: 537
Threads: 147
Joined: Jun 2013
Reputation: 0
#4

29.08.2015, 22:49
Quote:
Originally Posted by [BOPE]Seu._.Madruga
Посмотреть сообщение
PHP код:
stock OnPlayerSave(playerid) {
    new query[1250], ip[25];
    GetPlayerIp(playerid, ip, sizeof(ip));
    money[playerid] = GetPlayerMoneyEx(playerid);
    format(query, sizeof(query), "UPDATE `accounts` SET `Username` = '%s', `IP` = '%s', `scorelevel` = '%d', `maconha` = '%d', `sementes` = '%d', `BPsize` = '%d', `lastlogin` = '%d', `wanted` = '%d', `moneybag` = '%d', `COPskills` = '%d', `CRIMINALskills` = '%d', `PARAMEDICskills` = '%d', `admin` = '%d', `money` = '%d', `bank` = '%d', `kills` = '%d', `deaths` = '%d' WHERE `Username` = '%s' ",
    GetName(playerid),
    ip,
    scorelevel[playerid],
    maconha[playerid],
    sementes[playerid],
    BPsize[playerid],
    lastlogin[playerid],
    wanted[playerid],
    moneybag[playerid],
    COPskills[playerid],
    CRIMINALskills[playerid],
    PARAMEDICskills[playerid],
    admin[playerid],
    money[playerid],
    bank[playerid],
    kills[playerid],
    deaths[playerid],
    GetName(playerid));
    mysql_pquery(ConnectMYSQL, query);
    format(query, sizeof(query), "UPDATE `accounts` SET `eagleSPAWN` = '%d', `shotgunSPAWN` = '%d', `spazSPAWN` = '%d', `mp5SPAWN` = '%d', `akSPAWN` = '%d', `m4SPAWN` = '%d', `rifleSPAWN` = '%d', `sniperSPAWN` = '%d', `meleeSPAWN` = '%d' WHERE `Username` = '%s'",
    GetName(playerid),
    EagleSPAWN[playerid],
    shotgunSPAWN[playerid],
    spazSPAWN[playerid],
    mp5SPAWN[playerid],
    akSPAWN[playerid],
    m4SPAWN[playerid],
    rifleSPAWN[playerid],
    sniperSPAWN[playerid],
    meleeSPAWN[playerid],
    GetName(playerid));
    mysql_pquery(ConnectMYSQL, query);
    format(query, sizeof(query), "UPDATE `accounts` SET `DP` = '%d', `VIP` = '%d', `fmembro` = '%d', `fcargo` = '%d', `preso` = '%d', `presotime` = '%d', `startVIPdia` = '%d', `startVIPmes` = '%d', `startVIPano` = '%d', `carid` = '%d', `carpos0` = '%f', `carpos1` = '%f', `carpos2` = '%f', `carpos3` = '%f' WHERE Username = '%s'",
    DP[playerid],
    VIP[playerid],
    fmembro[playerid],
    fcargo[playerid],
    preso[playerid],
    presotime[playerid],
    startVIPdia[playerid],
    startVIPmes[playerid],
    startVIPano[playerid],
    carid[playerid],
    carpos[playerid][0],
    carpos[playerid][1],
    carpos[playerid][2],
    carpos[playerid][3],
    GetName(playerid) );
    mysql_pquery(ConnectMYSQL, query);
    
    format(query, sizeof(query), "UPDATE `accounts` SET `spawnpoint` = '%d', `housekey` = '%d', `idiom` = '%d', `tutorial` = '%d', `banned` = '%d', `leftBANdia` = '%d', `leftBANmes` = '%d', `leftBANano` = '%d' WHERE Username = '%s'",
    spawnpoint[playerid],
    housekey[playerid],
    idiom[playerid],
    tutorial[playerid],
    banned[playerid],
    leftBANdia[playerid],
    leftBANmes[playerid],
    leftBANano[playerid],
    GetName(playerid) );
    mysql_pquery(ConnectMYSQL, query);
} 
Obrigado! Funcionou! +REP!
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese