Доступ к архиву

Переход в группу "Пользователь"

300.00
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info
Статус
В этой теме нельзя размещать новые ответы.

Alex_Jemison

Изучающий
Пользователь
Регистрация
13 Апр 2018
Сообщения
202
Лучшие ответы
0
Репутация
0
Не сохраняются деньги и тд ...

PHP:
[18:43:44 01/18/19] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Podarok= 0 WHERE id=74 LIMIT 1' at line 1 (Query: "UPDATE accounts SET ip='95.27.166.121', level=2, age=22, cash=10000400, bank=250, warn=0, exp=0, news=0, thour=131, drugs=0, patron=0, gunamount=0, heal='100.000000', married=0, whomarried='None', paycheck=0, vip=0, viptime=0, robhouse=0, time=0, fstyle=0, spawnchange=2, sdpistol=0, deserteagle=0, shotgun=0, mp5=0, ak47=0, m4=0, hunger=100, sportexp=0, city=0, phonebalance=100, truckskill=0, cModel=0, cFuel=0, cMileage=0.0, cClass=0, cColor1=0, cColor2=0, cCost=0, cVehcom='0,0,0,0,0,0,0,0,0,0,0,0,0,0', cPaintjob=3, repcar='0, 0', improves='0, 0, 0, 0', phonenumber=0, phnumber1=0, phnumber2=0, phnumber3=0, phnumber4=0, phnumber5=0, phnumber6=0, phnumber7=0, phnumber8=0, licenses=0, timewarn=0, house=0, biz=0, gun='' Podarok= 0 WHERE id=74 LIMIT 1")
PHP:
stock SaveAccount(playerid)
{
	if(!IsPlayerConnected(playerid) || !gPlayerLogged[playerid]) return 1;
	
	if(pInfo[playerid][pCash] > 1000000000 || pInfo[playerid][pCash] < 0) pInfo[playerid][pCash] = 0;
	if(pInfo[playerid][pBank] > 1000000000 || pInfo[playerid][pBank] < 0) pInfo[playerid][pBank] = 0;
	
	new gunids[56], ammos[56], cnt, pgun[128], weapid, ammo;
	for(new i; i < 13; i++)
	{
		GetPlayerWeaponData(playerid, i, weapid, ammo);
		if(weapid && ammo && gGuns[playerid][i] == weapid && gAmmos[playerid][i] <= ammo)
		{
			if(!cnt)
			{
				format(gunids, sizeof(gunids), "%d", gGuns[playerid][i]);
				format(ammos, sizeof(ammos), "%d", gAmmos[playerid][i]);
			}
			else
			{
				format(gunids, sizeof(gunids), "%s|%d", gunids, gGuns[playerid][i]);
				format(ammos, sizeof(ammos), "%s|%d", ammos, gAmmos[playerid][i]);
			}
			cnt++;
			if(cnt >= 6) break;
		}
	}
	if(strlen(gunids) && strlen(ammos)) format(pgun,sizeof(pgun),"%s;%s",gunids,ammos);
	
	mysql_query_string = "UPDATE "T_ACCOUNTS" SET";
	format(mysql_query_string, 1000, "%s ip='%s', level=%d, age=%d, cash=%d, bank=%d, warn=%d,", mysql_query_string, pInfo[playerid][pIP], pInfo[playerid][pLevel], pInfo[playerid][pAge], pInfo[playerid][pCash], pInfo[playerid][pBank], pInfo[playerid][pWarn]);
	format(mysql_query_string, 1000, "%s exp=%d, news=%d, thour=%d, drugs=%d, patron=%d, gunamount=%d,", mysql_query_string, pInfo[playerid][pExp], pInfo[playerid][pNews], pInfo[playerid][pTimeHour], pInfo[playerid][pDrugs], pInfo[playerid][pPatron], pInfo[playerid][pGunAmount]);
	format(mysql_query_string, 1000, "%s heal='%f', married=%d, whomarried='%s', paycheck=%d, vip=%d, viptime=%d,", mysql_query_string, pInfo[playerid][pHeal], pInfo[playerid][pMarried], pInfo[playerid][pWhoMarried], pInfo[playerid][pPayCheck], pInfo[playerid][pVip], pInfo[playerid][pVipTime]);
	format(mysql_query_string, 1000, "%s robhouse=%d, time=%d, fstyle=%d, spawnchange=%d, sdpistol=%d, deserteagle=%d,", mysql_query_string, pInfo[playerid][pRobHouse], pInfo[playerid][pTime], pInfo[playerid][pFightStyle], pInfo[playerid][pSpawnChange], pInfo[playerid][pGunSkill][0], pInfo[playerid][pGunSkill][1]);
	format(mysql_query_string, 1000, "%s shotgun=%d, mp5=%d, ak47=%d, m4=%d,", mysql_query_string, pInfo[playerid][pGunSkill][2], pInfo[playerid][pGunSkill][3], pInfo[playerid][pGunSkill][4], pInfo[playerid][pGunSkill][5]);
	format(mysql_query_string, 1000, "%s hunger=%d, sportexp=%d, city=%d, phonebalance=%d, truckskill=%d, cModel=%d,", mysql_query_string, pInfo[playerid][pHunger], pInfo[playerid][pSportExp], pInfo[playerid][pCity], pInfo[playerid][pPhoneBalance], pInfo[playerid][pTruckSkill], pInfo[playerid][cModel]);
	format(mysql_query_string, 1000, "%s cFuel=%.0f, cMileage=%.1f, cClass=%d, cColor1=%d, cColor2=%d, cCost=%d, cVehcom='%s',", mysql_query_string, pInfo[playerid][cFuel], pInfo[playerid][cMileage], pInfo[playerid][cClass], pInfo[playerid][cColor][0], pInfo[playerid][cColor][1], pInfo[playerid][cCost], pInfo[playerid][cVehcom]);
	format(mysql_query_string, 1000, "%s cPaintjob=%d, repcar='%d, %d', improves='%d, %d, %d, %d', phonenumber=%d, phnumber1=%d, phnumber2=%d,", mysql_query_string, pInfo[playerid][cPaintjob], pInfo[playerid][pRepcar][0], pInfo[playerid][pRepcar][1],
	pInfo[playerid][pImprove][0], pInfo[playerid][pImprove][1], pInfo[playerid][pImprove][2], pInfo[playerid][pImprove][3], pInfo[playerid][pPhoneNumber], pInfo[playerid][pPhoneNumbers][0], pInfo[playerid][pPhoneNumbers][1]);
	format(mysql_query_string, 1000, "%s phnumber3=%d, phnumber4=%d, phnumber5=%d, phnumber6=%d, phnumber7=%d, phnumber8=%d,", mysql_query_string, pInfo[playerid][pPhoneNumbers][2], pInfo[playerid][pPhoneNumbers][3], pInfo[playerid][pPhoneNumbers][4], pInfo[playerid][pPhoneNumbers][5], pInfo[playerid][pPhoneNumbers][6], pInfo[playerid][pPhoneNumbers][7]);
	format(mysql_query_string, 1000, "%s licenses=%d, timewarn=%d, house=%d, biz=%d, gun='%s' Podarok= %d", mysql_query_string, pInfo[playerid][pLicenses], pInfo[playerid][pTimeToLastWarn], pInfo[playerid][pHouse], pInfo[playerid][pBiz], pgun, pInfo[playerid][pPodarok]);
	format(mysql_query_string, 1000, "%s WHERE id=%d LIMIT 1", mysql_query_string, pInfo[playerid][pID]);
 	return mysql_tquery(dbHandle, mysql_query_string, "", "");
}
 
Последнее редактирование:
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу