[mysql] does not read variables o.o
#1

PHP код:
mysql_format(sqlquerysizeof query"SELECT * FROM `user_weapon_pack1` WHERE `id` = %d"DB[playerid][ID]);
    
result mysql_query(sqlquery);
    
cache_get_field_content(0"pack_name"DB[playerid][Pack1Name]);
    
cache_get_field_content(0"hand"DB[playerid][Pack1Hand]);
    
cache_get_field_content(0"melee"DB[playerid][Pack1Melee]);
    
cache_get_field_content(0"unique"DB[playerid][Pack1Unique]);
    
cache_get_field_content(0"grenade"DB[playerid][Pack1Grenade]);
    
cache_get_field_content(0"secondary"DB[playerid][Pack1Secondary]);
    
cache_get_field_content(0"shotgun"DB[playerid][Pack1Shotgun]);
    
cache_get_field_content(0"sub-machine"DB[playerid][Pack1SubMachine]);
    
cache_get_field_content(0"primary"DB[playerid][Pack1Primary]);
    
cache_get_field_content(0"sniper"DB[playerid][Pack1Sniper]);
    
cache_get_field_content(0"missile"DB[playerid][Pack1Missile]);
    
cache_get_field_content(0"spray"DB[playerid][Pack1Spray]);
    
cache_delete(result); 
all of those [DB][playerid][Whatever] are still blank for some reason
Reply
#2

use
Код:
mysql_tquery(sql, query, "Loading", "i", playerid)
and after forward the Loading and put that cache function in it
Reply
#3

Try like that:
Код:
mysql_format(sql, query, sizeof(query), "SELECT * FROM `user_weapon_pack1` WHERE `id` = %d", DB[playerid][ID]);
mysql_tquery(sql, query, "LoadWeapons", "d", playerid);

forward LoadWeapons(playerid);
public LoadWeapons(playerid)
{
	cache_get_field_content(0, "pack_name", DB[playerid][Pack1Name]);
	cache_get_field_content(0, "hand", DB[playerid][Pack1Hand]);
	cache_get_field_content(0, "melee", DB[playerid][Pack1Melee]);
	cache_get_field_content(0, "unique", DB[playerid][Pack1Unique]);
	cache_get_field_content(0, "grenade", DB[playerid][Pack1Grenade]);
	cache_get_field_content(0, "secondary", DB[playerid][Pack1Secondary]);
	cache_get_field_content(0, "shotgun", DB[playerid][Pack1Shotgun]);
	cache_get_field_content(0, "sub-machine", DB[playerid][Pack1SubMachine]);
	cache_get_field_content(0, "primary", DB[playerid][Pack1Primary]);
	cache_get_field_content(0, "sniper", DB[playerid][Pack1Sniper]);
	cache_get_field_content(0, "missile", DB[playerid][Pack1Missile]);
	cache_get_field_content(0, "spray", DB[playerid][Pack1Spray]);
	return 1;
}
Reply
#4

https://sampwiki.blast.hk/wiki/MySQL/R33..._field_content
Read the red box.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)