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

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

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

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

Mqsql не сохраняет

Статус
В этой теме нельзя размещать новые ответы.

edikzver

Ученик
Доброй ночи пользователи портала вот я в очередной раз прошу вашей помоши у меня такая проблема не сохраняются аккаунты в базу данных Mysql ни права ни уровень ничего но сам акаунт сохраняется,также если в бд прописую уровень допустим он загружается тоестсь проблема с самой функцие сохранения прошу вашей помоши
Вот сам сток Save account

HTML: 
stock SaveAccount(playerid)
{
	if(PlayerLogged[playerid] == 0) return true;
	new src[128];
	/////////////////////////////////
	format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
	format(src,sizeof(src),"ip='%s',", PlayerInfo[playerid][pPlIP]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"level=%d,",PlayerInfo[playerid][pLevel]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"admin=%d,",PlayerInfo[playerid][pAdmin]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"sex=%d,",PlayerInfo[playerid][pSex]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"ippassword='%s',",PlayerInfo[playerid][pIpPassword]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"model=%d,",PlayerInfo[playerid][pModel]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"loach=%d,",PlayerInfo[playerid][pChar]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"cash=%d,",GetMoney(playerid));
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"bank=%d,",PlayerInfo[playerid][pBank]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"mute=%d,",PlayerInfo[playerid][pMuted]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"warn=%d,",PlayerInfo[playerid][pWarn]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"leader=%d,",PlayerInfo[playerid][pLeader]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"member=%d,",PlayerInfo[playerid][pMember]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"rank=%d,",PlayerInfo[playerid][pRank]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pick=%d,",PlayerInfo[playerid][pPick]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"exp=%d,",PlayerInfo[playerid][pExp]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"news=%d,",PlayerInfo[playerid][pNews]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"crimes=%d,",PlayerInfo[playerid][pCrimes]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"wanted=%d,",PlayerInfo[playerid][pWanted]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"wantedtime=%d,",PlayerInfo[playerid][pWantedTime]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"wantedwho='%s',",PlayerInfo[playerid][pWantedWho]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"wantedreason='%s',",PlayerInfo[playerid][pWantedReason]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"jail=%d,",PlayerInfo[playerid][pJail]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"job=%d,",PlayerInfo[playerid][pJob]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"jailtime=%d,",PlayerInfo[playerid][pJailTime]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"checktime=%d,",PlayerInfo[playerid][pCheckTime]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"drugs=%d,",PlayerInfo[playerid][pDrugs]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"mats=%d,",PlayerInfo[playerid][pMats]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"heal='%f',",PlayerInfo[playerid][pHeal]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"married=%d,",PlayerInfo[playerid][pMarried]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"whomarried='%s',",PlayerInfo[playerid][pWhoMarried]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"paycheck='%i',",PlayerInfo[playerid][pPayCheck]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"fishing='%i',",PlayerInfo[playerid][pFish]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"lottery='%i',",PlayerInfo[playerid][pLottery]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"vip='%i',",PlayerInfo[playerid][pVIP]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"time='%i',",PlayerInfo[playerid][pTime]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"fstyle='%i',",PlayerInfo[playerid][pFightStyle]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"credits='%i',",PlayerInfo[playerid][pCredits]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"totalcredits='%i',",PlayerInfo[playerid][pTotalCredits]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"skin1='%i',",PlayerInfo[playerid][pSkin1]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"skin2='%i',",PlayerInfo[playerid][pSkin2]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"skin3='%i',",PlayerInfo[playerid][pSkin3]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"spawnchange='%i',",PlayerInfo[playerid][pSpawnChange]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"sdpistol='%i',",PlayerInfo[playerid][pGunSkill][0]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"deserteagle='%i',",PlayerInfo[playerid][pGunSkill][1]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"shotgun='%i',",PlayerInfo[playerid][pGunSkill][2]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"mp5='%i',",PlayerInfo[playerid][pGunSkill][3]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"ak47='%i',",PlayerInfo[playerid][pGunSkill][4]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"m4='%i',",PlayerInfo[playerid][pGunSkill][5]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"rpr='%i',",PlayerInfo[playerid][pRPR]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"glasses='%i',",PlayerInfo[playerid][pGlasses]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"satiety='%i',",PlayerInfo[playerid][pSatiety]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"rprgive='%i',",PlayerInfo[playerid][pRPRGive]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"healths='%f',",PlayerInfo[playerid][pHealthS]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"sportexp='%i',",PlayerInfo[playerid][pSportEXP]);
	strcat(query,src,sizeof(query));

	format(src,sizeof(src),"online='%i',",PlayerInfo[playerid][pOnline]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"zakon='%i',",PlayerInfo[playerid][pZakon]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"bolezn='%i',",PlayerInfo[playerid][pBolezn]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"ipcheck='%i',",PlayerInfo[playerid][ProverkaIP]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"hospital='%i',",PlayerInfo[playerid][pHospital]);
	strcat(query,src,sizeof(query));

	format(src,sizeof(src),"watch='%i',",PlayerInfo[playerid][pWatch]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"ciggare='%i',",PlayerInfo[playerid][pCiggare]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"sprunk='%i',",PlayerInfo[playerid][pSprunk]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"mask='%i',",PlayerInfo[playerid][pMask]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"phonebalance='%i',",PlayerInfo[playerid][pPhoneBalance]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"truckskill='%i',",PlayerInfo[playerid][pTruckSkill]);
	strcat(query,src,sizeof(query));


	format(src,sizeof(src),"cModel='%i',",PlayerInfo[playerid][cModel]);
	strcat(query,src,sizeof(query));
	
	format(src,sizeof(src),"cX='%f',",PlayerInfo[playerid][cX]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"cY='%f',",PlayerInfo[playerid][cY]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"cZ='%f',",PlayerInfo[playerid][cZ]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"cFa='%f',",PlayerInfo[playerid][cFa]);
	strcat(query,src,sizeof(query));

	format(src,sizeof(src),"cFuel='%i',",PlayerInfo[playerid][cFuel]);
	strcat(query,src,sizeof(query));

	format(src,sizeof(src),"cNumber='%s',",PlayerInfo[playerid][cNumber]);
	strcat(query,src,sizeof(query));
	
	format(src,sizeof(src),"cCarAr='%i',",PlayerInfo[playerid][cCarAr]);
	strcat(query,src,sizeof(query));
	
	format(src,sizeof(src),"cClass='%i',",PlayerInfo[playerid][cClass]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"cColor1='%i',",PlayerInfo[playerid][cColor][0]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"cColor2='%i',",PlayerInfo[playerid][cColor][1]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"cLock='%i',",PlayerInfo[playerid][cLock]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"cCost='%i',",PlayerInfo[playerid][cCost]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"cVehcom='%s',",PlayerInfo[playerid][cVehcom]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"cPaintjob='%i',",PlayerInfo[playerid][cPaintjob]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"morgan='%i',",PlayerInfo[playerid][pMorgan]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"morgantime='%i',",PlayerInfo[playerid][pMorganTime]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"spawn='%i',",PlayerInfo[playerid][pSpawn]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"vb='%i',",PlayerInfo[playerid][pVb]);
	strcat(query,src,sizeof(query));
	format(PlayerInfo[playerid][pPhones],16,"%i, %i, %i",
	PlayerInfo[playerid][pPhone][0],PlayerInfo[playerid][pPhone][1], PlayerInfo[playerid][pPhone][2]);
	format(src,sizeof(src),"phone='%s',",PlayerInfo[playerid][pPhones]);
	strcat(query,src,sizeof(query));
	format(PlayerInfo[playerid][pLics],40,"%i, %i, %i, %i, %i",
	PlayerInfo[playerid][pLic][0],PlayerInfo[playerid][pLic][1],PlayerInfo[playerid][pLic][2]
	,PlayerInfo[playerid][pLic][3],PlayerInfo[playerid][pLic][4]);
	format(src,sizeof(src),"lic='%s',",PlayerInfo[playerid][pLics]);
	strcat(query,src,sizeof(query));
	
	format(PlayerInfo[playerid][pWorkBook], 40, "%i, %i, %i, %i, %i, %i",
	PlayerInfo[playerid][pWB][0], PlayerInfo[playerid][pWB][1],PlayerInfo[playerid][pWB][2]
	,PlayerInfo[playerid][pWB][3],PlayerInfo[playerid][pWB][4], PlayerInfo[playerid][pWB][5]);
	format(src,sizeof(src),"workbook='%s',",PlayerInfo[playerid][pWorkBook]);
	strcat(query,src,sizeof(query));
	
	if(GetPVarInt(playerid, "GunCheat") == 0)
	{
		for(new i = 0; i < 13; i++)
		{
			GetPlayerWeaponData(playerid, i, PlayerInfo[playerid][pGun][i], PlayerInfo[playerid][pAmmo][i]);
		}
		format(PlayerInfo[playerid][pGuns],40,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
		PlayerInfo[playerid][pGun][0],PlayerInfo[playerid][pGun][1],PlayerInfo[playerid][pGun][2],
		PlayerInfo[playerid][pGun][3],PlayerInfo[playerid][pGun][4],PlayerInfo[playerid][pGun][5],
		PlayerInfo[playerid][pGun][6],PlayerInfo[playerid][pGun][7],PlayerInfo[playerid][pGun][8],
		PlayerInfo[playerid][pGun][9],PlayerInfo[playerid][pGun][10],PlayerInfo[playerid][pGun][11],PlayerInfo[playerid][pGun][12]);
		format(src,sizeof(src),"guns='%s',",PlayerInfo[playerid][pGuns]);
		strcat(query,src,sizeof(query));
		format(PlayerInfo[playerid][pAmmos],160,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
		PlayerInfo[playerid][pAmmo][0],PlayerInfo[playerid][pAmmo][1],PlayerInfo[playerid][pAmmo][2],
		PlayerInfo[playerid][pAmmo][3],PlayerInfo[playerid][pAmmo][4],PlayerInfo[playerid][pAmmo][5],
		PlayerInfo[playerid][pAmmo][6],PlayerInfo[playerid][pAmmo][7],PlayerInfo[playerid][pAmmo][8],
		PlayerInfo[playerid][pAmmo][9],PlayerInfo[playerid][pAmmo][10],PlayerInfo[playerid][pAmmo][11],PlayerInfo[playerid][pAmmo][12]);
		format(src,sizeof(src),"ammos='%s',",PlayerInfo[playerid][pAmmos]);
	}
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"skills='%d'",PlayerInfo[playerid][pGunSkill][6]);
	strcat(query,src,sizeof(query));
	new playername[32];
	GetPlayerName(playerid,playername,32);
	format(src,sizeof(src)," WHERE name='%s'",playername);
	strcat(query,src,sizeof(query));
	mysql_query(query);
	return true;
}
Вот логи Mysql

HTML: 
[00:44:04] >> mysql_query( Connection handle: 1 )

[00:44:04] CMySQLHandler::Query(SELECT * FROM bans WHERE name = 'Edik_Zver') - Successfully executed.

[00:44:04] >> mysql_store_result( Connection handle: 1 )

[00:44:04] CMySQLHandler::StoreResult() - Result was stored.

[00:44:04] >> mysql_fetch_row_format( Connection handle: 1 )

[00:44:04] >> mysql_query( Connection handle: 1 )

[00:44:04] CMySQLHandler::Query(SELECT * FROM bans WHERE ip = '46.172.79.41') - Successfully executed.

[00:44:04] >> mysql_store_result( Connection handle: 1 )

[00:44:04] CMySQLHandler::StoreResult() - Result was stored.

[00:44:04] >> mysql_fetch_row_format( Connection handle: 1 )

[00:44:04] >> mysql_free_result( Connection handle: 1 )

[00:44:04] CMySQLHandler::FreeResult() - Result was successfully free'd.

[00:44:12] >> mysql_query( Connection handle: 1 )

[00:44:12] CMySQLHandler::Query(SELECT * FROM accounts WHERE name = 'Edik_Zver') - Successfully executed.

[00:44:12] >> mysql_store_result( Connection handle: 1 )

[00:44:12] CMySQLHandler::StoreResult() - Result was stored.

[00:44:12] >> mysql_fetch_row_format( Connection handle: 1 )

[00:44:12] CMySQLHandler::FetchRow() - Return: 336|Edik_Zver|1236987|46.172.79.41|1339|qwerty|ghg@mail.ru|1|300|0|0||0|0|0|0|1|20|0|0, 0, 0, 0, 0|0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0|0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0|0, 0, 0, 0, 0, 0, 5000|0|0|0|0|0, 0, 0|0, 0, 0|0|0|0|0|None|None|70.0|0|0|0|0|0|None|None|0|0|0|0|0|0

[00:44:12] >> mysql_free_result( Connection handle: 1 )

[00:44:12] CMySQLHandler::FreeResult() - Result was successfully free'd.

[00:44:16] >> mysql_query( Connection handle: 1 )

[00:44:16] CMySQLHandler::Query(SELECT password FROM accounts WHERE name = 'Edik_Zver' LIMIT 1) - Successfully executed.

[00:44:16] >> mysql_store_result( Connection handle: 1 )

[00:44:16] CMySQLHandler::StoreResult() - Result was stored.

[00:44:16] >> mysql_fetch_row_format( Connection handle: 1 )

[00:44:16] CMySQLHandler::FetchRow() - Return: 1236987

[00:44:16] >> mysql_free_result( Connection handle: 1 )

[00:44:16] CMySQLHandler::FreeResult() - Result was successfully free'd.

[00:44:16] >> mysql_query( Connection handle: 1 )

[00:44:16] CMySQLHandler::Query(SELECT ipcheck FROM accounts WHERE name = 'Edik_Zver' LIMIT 1) - An error has occured. (Error ID: 1054, Unknown column 'ipcheck' in 'field list')

[00:44:16] >> mysql_store_result( Connection handle: 1 )

[00:44:16] CMySQLHandler::StoreResult() - No data to store.

[00:44:16] >> mysql_fetch_row_format( Connection handle: 1 )

[00:44:16] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[00:44:16] >> mysql_query( Connection handle: 1 )

[00:44:16] CMySQLHandler::Query(SELECT * FROM accounts WHERE name = 'Edik_Zver'  LIMIT 1) - Successfully executed.

[00:44:16] >> mysql_store_result( Connection handle: 1 )

[00:44:16] CMySQLHandler::StoreResult() - Result was stored.

[00:44:16] >> mysql_fetch_row_format( Connection handle: 1 )

[00:44:16] CMySQLHandler::FetchRow() - Return: 336|Edik_Zver|1236987|46.172.79.41|1339|qwerty|ghg@mail.ru|1|300|0|0||0|0|0|0|1|20|0|0, 0, 0, 0, 0|0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0|0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0|0, 0, 0, 0, 0, 0, 5000|0|0|0|0|0, 0, 0|0, 0, 0|0|0|0|0|None|None|70.0|0|0|0|0|0|None|None|0|0|0|0|0|0

[00:44:16] >> mysql_free_result( Connection handle: 1 )

[00:44:16] CMySQLHandler::FreeResult() - Result was successfully free'd.

[00:44:16] >> mysql_query( Connection handle: 1 )

[00:44:16] CMySQLHandler::Query(UPDATE accounts SET  online = '1' WHERE name = 'Edik_Zver' LIMIT 1) - An error has occured. (Error ID: 1054, Unknown column 'online' in 'field list')

[00:46:02] >> mysql_query( Connection handle: 1 )

[00:46:02] CMySQLHandler::Query(UPDATE accounts SET ip='46.172.79.41',level=1,admin=1339,sex=1,ippassword='qwerty',model=20,loach=0,cash=0,bank=0,mute=0,warn=0,leader=0,member=0,rank=0,pick=0,exp=0,news=0,crimes=0,wanted=0,wantedtime=0,wantedwho='',wantedreason='',jail=0,job=0,jailtime=0,checktime=0,drugs=0,mats=0,heal='100.000000',married=0,whomarried='',paycheck='0',fishing='0',lottery='0',vip='0',time='0',fstyle='0',credits='0',totalcredits='0',skin1='0',skin2='0',skin3='0',spawnchange='0',sdpistol='0',deserteagle='0',shotgun='0',mp5='0',ak47='0',m4='0',rpr='0',glasses='0',satiety='0',rprgive='0',healths='100.000000',sportexp='0',online='0',zakon='0',bolezn='0',ipcheck='0',hospital='0',watch='0',ciggare='0',sprunk='0',mask='0',phonebalance='1000',truckskill='0',cModel='0',cX='0.000000',cY='0.000000',cZ='0.000000',cFa='0.000000',cFuel='0',cNumber='',cCarAr='0',cClass='0',cColor1='0',cColor2='0',cLock='0',cCost='0',cVehcom='',cPaintjob='0',morgan='0',morgantime='0',spawn='0',vb='0',phone='0, 0, 0',lic='1, 0, 0, 0, 0',workbook='0, 0, 0, 0, 0, 0',guns='0,0,0,0,0,0,0,0,0,0,0,0,0',ammos='0,0,0,0,0,0,0,0,0,0,0,0,0',skills='16' WHERE name='Edik_Zver') - An error has occured. (Error ID: 1054, Unknown column 'ippassword' in 'field list')
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу