Lester.
Умник
Пытался перевести на MySQL R41-4 ,но не работает (
C++:
mysql_tquery(connects, "SELECT * FROM `items`", "LoadPlayerItems");
stock LoadPlayerItems(playerid)
{
new
rows = cache_num_rows(),
tick = GetTickCount();
new query[64];
format(query, sizeof query, "SELECT * FROM ITEMS WHERE UID = '%q'", PlayerInfo[playerid][pID]);
mysql_query(connects, query);
if(!rows)
{
print("[<Багаж>]: Багаж не найдены в базе данных.");
return 0;
}
for(new i; i < rows; i++)
{
new itemid, itemcount;
do
{
itemid = cache_get_value_name_int(i, "ITEM_ID");
itemcount = cache_get_value_name_int(i, "COUNT");
if(itemcount == 0) continue;
SetPlayerItemCount(playerid, itemid, itemcount);
}
}
return 1;
}
stock SavePlayerItems(playerid)
{
new query[128], Cache:result;
for(new i = 0; i != sizeof gItems; i++)
{
if(GetPlayerItemCount(playerid, i) == 0) continue;
format(query, sizeof query, "SELECT COUNT FROM ITEMS WHERE UID = '%d' AND ITEM_ID = %i", PlayerInfo[playerid][pID], i);
result = mysql_query(connects, query);
if(cache_num_rows())
{
format(query, sizeof query, "UPDATE ITEMS SET COUNT = %i WHERE UID = '%d' AND ITEM_ID = %i", GetPlayerItemCount(playerid, i), PlayerInfo[playerid][pID], i);
result = mysql_query(connects, query);
}
else
{
format(query, sizeof query, "INSERT INTO ITEMS (UID, ITEM_ID, COUNT) VALUES ('%d', %i, %i)", PlayerInfo[playerid][pID], i, GetPlayerItemCount(playerid, i));
result = mysql_query(connects, query);
}
cache_delete(result);
}
return 1;
}
Вложения
-
15.6 KB Просмотры: 12
