▲Denny▲
Умник
PHP:
stock SaveAccount(playerid)
{
new query[2000];
GetPlayerHealth(playerid, pinfo[playerid][health]);
GetPlayerIp(playerid, pinfo[playerid][lastip], 30);
format(query, sizeof(query), "UPDATE `accounts` SET `name` = '%s',", pinfo[playerid][name]);
format(query, sizeof(query), "%s `pass` = '%s',", query, pinfo[playerid][pass]);
format(query, sizeof(query), "%s `mail` = '%s',", query, pinfo[playerid][mail]);
format(query, sizeof(query), "%s `ref` = '%s',", query, pinfo[playerid][ref]);
format(query, sizeof(query), "%s `exp` = '%i',", query, pinfo[playerid][exp]);
format(query, sizeof(query), "%s `hours` = '%i',", query, pinfo[playerid][hours]);
format(query, sizeof(query), "%s `sex` = '%i',", query, pinfo[playerid][sex]);
format(query, sizeof(query), "%s `cloth` = '%i',", query, pinfo[playerid][cloth]);
format(query, sizeof(query), "%s `money` = '%i',", query, pinfo[playerid][money]);
format(query, sizeof(query), "%s `depoz` = '%i',", query, pinfo[playerid][depoz]);
format(query, sizeof(query), "%s `bmoney` = '%i',", query, pinfo[playerid][bmoney]);
format(query, sizeof(query), "%s `phone` = '%i',", query, pinfo[playerid][phone]);
format(query, sizeof(query), "%s `zak` = '%i',", query, pinfo[playerid][zak]);
format(query, sizeof(query), "%s `crime` = '%i',", query, pinfo[playerid][crime]);
format(query, sizeof(query), "%s `arrest` = '%i',", query, pinfo[playerid][arrest]);
format(query, sizeof(query), "%s `wanted` = '%i',", query, pinfo[playerid][wanted]);
format(query, sizeof(query), "%s `warns` = '%i',", query, pinfo[playerid][warns]);
format(query, sizeof(query), "%s `bans` = '%i',", query, pinfo[playerid][bans]);
format(query, sizeof(query), "%s `work` = '%i',", query, pinfo[playerid][work]);
format(query, sizeof(query), "%s `org` = '%i',", query, pinfo[playerid][org]);
format(query, sizeof(query), "%s `rang` = '%i',", query, pinfo[playerid][rang]);
format(query, sizeof(query), "%s `zavnar` = '%i',", query, pinfo[playerid][zavnar]);
format(query, sizeof(query), "%s `nark` = '%i',", query, pinfo[playerid][nark]);
format(query, sizeof(query), "%s `muts` = '%i',", query, pinfo[playerid][muts]);
format(query, sizeof(query), "%s `reg` = '%s',", query, pinfo[playerid][reg]);
format(query, sizeof(query), "%s `vip` = '%i',", query, pinfo[playerid][vip]);
format(query, sizeof(query), "%s `home` = '%i',", query, pinfo[playerid][home]);
format(query, sizeof(query), "%s `biz` = '%i',", query, pinfo[playerid][biz]);
format(query, sizeof(query), "%s `regip` = '%s',", query, pinfo[playerid][regip]);
format(query, sizeof(query), "%s `lastip` = '%s',", query, pinfo[playerid][lastip]);
format(query, sizeof(query), "%s `country` = '%i',", query, pinfo[playerid][country]);
format(query, sizeof(query), "%s `kod` = '%i',", query, pinfo[playerid][kod]);
format(query, sizeof(query), "%s `house` = '%i',", query, pinfo[playerid][house]);
format(query, sizeof(query), "%s `level` = '%i',", query, pinfo[playerid][level]);
format(query, sizeof(query), "%s `pcarid` = '%i',", query, pinfo[playerid][pcarid]);
format(query, sizeof(query), "%s `drunk` = '%i',", query, pinfo[playerid][drunk]);
format(query, sizeof(query), "%s `satiety` = '%f',", query, pinfo[playerid][satiety]);
format(query, sizeof(query), "%s `dir` = '%i',", query, pinfo[playerid][dir]);
format(query, sizeof(query), "%s `rod` = '%i',", query, pinfo[playerid][rod]);
format(query, sizeof(query), "%s `bait` = '%i',", query, pinfo[playerid][bait]);
format(query, sizeof(query), "%s `mask` = '%i',", query, pinfo[playerid][mask]);
format(query, sizeof(query), "%s `health` = '%f'", query, pinfo[playerid][health]);
mysql_format(connect, query, sizeof(query), "%s WHERE `id` = '%i'", query, pinfo[playerid][id]);
printf("%s", query);
mysql_pquery(connect, query);
return 1;
}
PHP:
forward BizLoad();
public BizLoad()
{
new rows, string1[256], bklass[20], blocked[20];
cache_get_row_count(rows);
if(rows)
{
for(new idx = 1; idx <= rows; idx++)
{
cache_get_value_name_int(idx-1, "id", binfo[idx][id]);
cache_get_value_name_int(idx-1, "class", binfo[idx][class]);
cache_get_value_name(idx-1, "name", binfo[idx][name]);
cache_get_value_name(idx-1, "owner", binfo[idx][owner], 24);
cache_get_value_name_float(idx-1, "ExitX", binfo[idx][ExitX]);
cache_get_value_name_float(idx-1, "ExitY", binfo[idx][ExitY]);
cache_get_value_name_float(idx-1, "ExitZ", binfo[idx][ExitZ]);
cache_get_value_name_float(idx-1, "EnterX", binfo[idx][EnterX]);
cache_get_value_name_float(idx-1, "EnterY", binfo[idx][EnterY]);
cache_get_value_name_float(idx-1, "EnterZ", binfo[idx][EnterZ]);
cache_get_value_name_float(idx-1, "Angle", binfo[idx][Angle]);
cache_get_value_name_int(idx-1, "lock", binfo[idx][lock]);
cache_get_value_name_int(idx-1, "price", binfo[idx][price]);
cache_get_value_name_int(idx-1, "dolg", binfo[idx][dolg]);
cache_get_value_name_int(idx-1, "materials", binfo[idx][materials]);
cache_get_value_name_int(idx-1, "price1", binfo[idx][price1]);
cache_get_value_name_int(idx-1, "price2", binfo[idx][price2]);
cache_get_value_name_int(idx-1, "price3", binfo[idx][price3]);
cache_get_value_name_int(idx-1, "price4", binfo[idx][price4]);
cache_get_value_name_int(idx-1, "price5", binfo[idx][price5]);
cache_get_value_name_int(idx-1, "price6", binfo[idx][price6]);
cache_get_value_name_int(idx-1, "price7", binfo[idx][price7]);
cache_get_value_name_int(idx-1, "price8", binfo[idx][price8]);
cache_get_value_name_int(idx-1, "price9", binfo[idx][price9]);
TOTALBIZS++;
binfo[idx][pickup] = CreatePickup(19132, 23, binfo[idx][EnterX], binfo[idx][EnterY], binfo[idx][EnterZ], 0);
switch(binfo[idx][class])
{
case 2: bklass = "Клуб", binfo[idx][icon] = CreateDynamicMapIcon(binfo[idx][EnterX], binfo[idx][EnterY], binfo[idx][EnterZ], 48, -1, 0), binfo[idx][point] = CreateDynamicCP(1154.0443,1536.5869,-33.5676, 1.0, binfo[idx][id], binfo[idx][id], -1, 10.0), binfo[idx][actor] = CreateActor(240, 1152.5938,1535.1040,-32.6676,267.9448), SetActorVirtualWorld(binfo[idx][actor], binfo[idx][id]), SetActorInvulnerable(binfo[idx][actor], 1);
case 3: bklass = "Заправка", binfo[idx][icon] = CreateDynamicMapIcon(binfo[idx][EnterX], binfo[idx][EnterY], binfo[idx][EnterZ], 47, -1, 0);
case 4: bklass = "Магазин 24/7", binfo[idx][icon] = CreateDynamicMapIcon(binfo[idx][EnterX], binfo[idx][EnterY], binfo[idx][EnterZ], 56, -1, 0), binfo[idx][point] = CreateDynamicCP(-861.1273,4900.3032,2211.1553, 1.0, binfo[idx][id], binfo[idx][id], -1, 10.0), binfo[idx][actor] = CreateActor(268, -859.2712,4900.7666,2211.1553,92.0649), SetActorVirtualWorld(binfo[idx][actor], binfo[idx][id]), SetActorInvulnerable(binfo[idx][actor], 1);
case 5: bklass = "Закусочная", binfo[idx][icon] = CreateDynamicMapIcon(binfo[idx][EnterX], binfo[idx][EnterY], binfo[idx][EnterZ], 17, -1, 0), binfo[idx][point] = CreateDynamicCP(3713.3315,159.9129,161.1153, 1.0, binfo[idx][id], binfo[idx][id], -1, 10.0), binfo[idx][actor] = CreateActor(167, 3713.2092,161.4412,162.0132,177.3015), SetActorVirtualWorld(binfo[idx][actor], binfo[idx][id]), SetActorInvulnerable(binfo[idx][actor], 1);
case 6: bklass = "Автозавод", binfo[idx][icon] = CreateDynamicMapIcon(binfo[idx][EnterX], binfo[idx][EnterY], binfo[idx][EnterZ], 51, -1, 0);
case 7: bklass = "Автосалон", binfo[idx][icon] = CreateDynamicMapIcon(binfo[idx][EnterX], binfo[idx][EnterY], binfo[idx][EnterZ], 55, -1, 0), binfo[idx][point] = CreateDynamicCP(4224.5549,544.01,411.1949, 1.0, binfo[idx][id], binfo[idx][id], -1, 10.0), binfo[idx][actor] = CreateActor(91, 4224.8213,546.3339,412.0949,179.2941), SetActorVirtualWorld(binfo[idx][actor], binfo[idx][id]), SetActorInvulnerable(binfo[idx][actor], 1);
case 8: bklass = "Ферма", binfo[idx][icon] = CreateDynamicMapIcon(binfo[idx][EnterX], binfo[idx][EnterY], binfo[idx][EnterZ], 13, -1, 0);
case 9: bklass = "СТО", binfo[idx][icon] = CreateDynamicMapIcon(binfo[idx][EnterX], binfo[idx][EnterY], binfo[idx][EnterZ], 12, -1, 0);
}
if(!strcmp(binfo[idx][owner], "-", false))
{
format(string1, sizeof(string1), "{12C305}---[ПРОДАЁТСЯ]---\n{B57609}Название: {FFFFFF}%s\n{B57609}Класс: {FFFFFF}%s\n{B57609}Владелец: {FFFFFF}%s\n{B57609}Состояние: {C02020}[Закрыто]\n{12C305}---[ПРОДАЁТСЯ]---", binfo[idx][name], bklass, binfo[idx][owner]);
binfo[idx][biztext] = Create3DTextLabel(string1, -1, binfo[idx][EnterX], binfo[idx][EnterY], binfo[idx][EnterZ], 20.0, 0);
}
else
{
switch(binfo[idx][lock])
{
case 0: blocked = "{17CD17}[Открыто]";
case 1: blocked = "{C02020}[Закрыто]";
}
format(string1, sizeof(string1), "---[%s]---\nНазвание: %s\nВладелец: %s\nСостояние: %s", bklass, binfo[idx][name], binfo[idx][owner], blocked);
binfo[idx][biztext] = Create3DTextLabel(string1, -1, binfo[idx][EnterX], binfo[idx][EnterY], binfo[idx][EnterZ], 20.0, 0);
}
}
}
}