Перейти к содержанию
Единые правила форума (ЕПФ)
Авторизация  
Подписчики 0
NikityshkaMedvedev

Помогите пожалуйста , не сохраняются аккаунты в базе данных MySQL-BD

Автор NikityshkaMedvedev, в Помощь по Скриптингу

Рекомендуемые сообщения

NikityshkaMedvedev    0

NikityshkaMedvedev
Опубликовано

Код : 

//Сохранение аккаунт.
stock SaveAccount(playerid)
{
	if(!PlayerLogged[playerid]) 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),"regip='%s',", PlayerInfo[playerid][pREGIP]);
	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),"pAdminPass='%d',",PlayerInfo[playerid][pAdminPass]);
	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),"warntime=%d,",PlayerInfo[playerid][pWarnTime]);
	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),"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),"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),"job=%d,",PlayerInfo[playerid][pJob]);
	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='%d',",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),"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_function_query(ConBD, query, true, "", "");
	SaveAllMyCar(playerid);
	return true;
}

mysql_log : 

[16:13:56] [ERROR] mysql_errno - invalid connection handle (id: 1)
[16:13:56] [ERROR] mysql_errno - invalid connection handle (id: 1)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[16:13:56] [ERROR] mysql_tquery - invalid connection handle (id: 0)

Помогите пожалуйста( 
 

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

16Shadows    101

16Shadows
Опубликовано

Неверный хендл соединения. Значит, соединение с SQL сервером не установлено.

  • Like 1

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

Для публикации сообщений создайте учётную запись или авторизуйтесь

Вы должны быть пользователем, чтобы оставить комментарий

Создать учетную запись

Зарегистрируйте новую учётную запись в нашем сообществе. Это очень просто!

Регистрация нового пользователя

Войти

Уже есть аккаунт? Войти в систему.

Войти
Авторизация  
Подписчики 0
Перейти к списку тем Помощь по Скриптингу

  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

×

Важная информация

Мы разместили cookie-файлы на ваше устройство, чтобы помочь сделать этот сайт лучше. Вы можете изменить свои настройки cookie-файлов, или продолжить без изменения настроек.

  Я принимаю