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

Сохранение аккаунтов

Автор Глебушка, в Помощь по Скриптингу

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

Глебушка    0

Глебушка
Опубликовано

Как сделать систему сохранения аккаунтов на сервере ? 

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

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

Eduard Vestornович    165

Eduard Vestornович
Опубликовано

@Глебушка,через определенное время? То есть , например, каждые 5 минут? 


@Глебушка,вставляй в конец мода

forward SaveAcc();
public SaveAcc()
{
    new timeUser = GetTickCount();
	SendAdminMessage(COLOR_BLUE, "{FF8C00}[A] {DEB887}>> {3399FF}Выполняется сохранение всех аккаунтов");
	for(new j = 0; j <= MAX_PLAYERS; j++)
	{
		if(!IsPlayerConnected(j) || PlayerLogged[j] == 0) continue;
		SaveAccount(j);
		SetPlayerSkills(j);
	}
	format(totalstring, 128, "{FF8C00}[A] {DEB887}>> {3399FF}Сохранение прошло успешно, следующее через 5 минут. ({FF8C00} %i {3399FF}мс)", GetTickCount() - timeUser);
	SendAdminMessage(COLOR_BLUE, totalstring);	return true;
} 

Ошибки скидывай сюда , т.к я тебе скинул чистый код с другого сервера , тебе нужно будет его переделать под свой сервер , заменить переменные и т.д

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

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

Глебушка    0

Глебушка
Опубликовано

@Vestorn,ошибочки :3 - https://imgur.com/a/iQeFL

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

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

Eduard Vestornович    165

Eduard Vestornович
Опубликовано

Ко всем new
 

new PlayerLogged[MAX_PLAYERS] = 0;

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

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

Глебушка    0

Глебушка
Опубликовано

@Vestorn, https://imgur.com/a/0cvj6

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

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

Eduard Vestornович    165

Eduard Vestornович
Опубликовано

@Глебушка, тут все заменяете на свое (таблицы)

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),"adminn=%d,",PlayerInfo[playerid][pAdminn]);
	strcat(query,src,sizeof(query));
	format(src,sizeof(src),"admpass=%d,",PlayerInfo[playerid][pAdmPass]);
	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),"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='%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),"pCReg='%i',",PlayerInfo[playerid][pCReg]);
	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),"vzlom='%i',",PlayerInfo[playerid][pVzlom]);
	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;
} 
new totalstring[1024]; // 1024

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

Ссылка на сообщение
Поделиться на другие сайты
Гость
Эта тема закрыта для публикации ответов.
Авторизация  
Подписчики 0
Перейти к списку тем Помощь по Скриптингу

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

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

×

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

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

  Я принимаю