Перейти к содержанию
Единые правила форума (ЕПФ)
  • 0
Авторизация  
Подписчики 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)

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

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

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

1 ответ на этот вопрос

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

  • 0

16Shadows    101

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

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

  • Like 1

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

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

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

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

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

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

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

Войти

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

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

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

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

×

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

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

  Я принимаю