01:40
ОбновитьСмайлыУправление мини-чатом
МИНИ-ЧАТ
Главная страница!

 



 
        
Фильм by SAMP-RUS (16)
AlinaKA 12.09.2017 23:51
Физрук (16)
Phyliciavox 08.09.2017 17:49
 





Рекомендуем:
Добавить IP: 95.172.59.51:7777





Последние Файлы GTA 4 Последние Файлы GTA-MP Реклама
Скрипт GTA 4 элементы Watch... 07.09.2014
Ferrari 360 Spider [EPM con... 13.12.2013
Porsche Cayenne Turbo 2012 ... 13.12.2013
Shelby Terlingua Mustang v1... 13.12.2013
Hamann Lamborghini Gallardo... 27.10.2013
Dgun (AvnanceRP,SampRP,Dimo... 19.03.2016
SAMP скрипт SX Events (MySQ... 03.03.2016
Карта ASL мэрия для SAMP се... 03.03.2016
AIM для SA-MP 0.3.7 22.02.2016
Скачать GTA SAMP 0.3.7 - Кл... 20.07.2015
Страница 1 из 11
Модератор форума: AXE, Weddew 
Форум SAMP о мультиплеерах для GTA. » SAMP скачивание и обсуждение » Вопросы и Проблемы » [MySQL or RegSys] Падения севера
[MySQL or RegSys] Падения севера
RishatДата: Понедельник, 21.10.2013, 23:00 | Сообщение # 1
Уверенный в себе
Группа: Продвинутые
Сообщений: 232
Награды: 3
Город: Nab. Chelny
Репутация: 52
Замечания: 0%
Статус:
С друзьями возобновили старый проект, соответственно решили поменять основу моду. Старенький GF уже как то не вставляет bs
И вот настал тот день когда на сервер стало ломиться куча проэрпешниковшкольников.

При коннекте/регистрации нового пользователя сервер неожиданно падает.
Последние записи в логах:

Код
[21/10/2013 16:57:10] [join] Carlos_Ricci has joined the server (2:46.147.64.238)
[21/10/2013 16:57:17] strcat 294
[21/10/2013 16:57:17] query 1218
[21/10/2013 16:58:33] Incoming connection: 92.125.47.247:56647
[21/10/2013 16:58:34] [join] Aleksandr_Abdulov has joined the server (3:92.125.47.247)

// - Сервер лёг.

[21/10/2013 17:10:23] Incoming connection: 46.44.23.245:57113
[21/10/2013 17:10:23] [join] Nikita_Kot has joined the server (5:46.44.23.245)
[21/10/2013 17:11:10] strcat 292
[21/10/2013 17:11:10] query 1221

// - Опять же сервер лёг.

[21/10/2013 17:14:14] [join] Jeffrey_Vasco has joined the server (7:212.109.7.192)
[21/10/2013 17:14:14] strcat 295
[21/10/2013 17:14:14] query 1223

// - Опять же сервер лёг.


Мои предположения, что виноват мускул или обработка калбэка создания персонажа

[pwn]stock OnPlayerRegister(playerid, password[])
{
new query[128];
format(query, sizeof(query), "INSERT INTO `acc` (`Name`, `pPassword`) VALUES ('%s', '%s')", PlayerName[playerid], password);
mysql_function_query(MysqlConnect, query, false, "OnPlayerFinishRegister","i", playerid);
return 1;
}

// Тут начинается каллбэк Логина
new rows, fields,string[256],maximum[144];
cache_get_data(rows,fields);
if(!rows)
{
string = "";
strcat(string, "{C9C9C9}Äîáðî ïîæàëîâàòü íà íàø {FFFFFF}RolePlay Game {C9C9C9}ñåðâåð!\n");
new accauntinfo[512];
f(accauntinfo, "{C9C9C9}Àêêàóíò {FFB300}%s {C9C9C9}çàðåãèñòðèðîâàí. Ââåäè ïàðîëü:\n", PlayerNameEx[playerid]);
strcat(string, accauntinfo);
strcat(string, "{FF0000}Ââåä¸ííûé ïàðîëü íå âåðåí");
ShowDialog(playerid, LOG_ID, DIALOG_STYLE_INPUT, "Àâòîðèçàöèÿ", string, "Îê", "Âûéòè");
return 1;
}
cache_get_field_content(0, "pPassword", maximum),  strmid(PlayerInfo[playerid][pPassword], maximum, 0, strlen(maximum), 128);
cache_get_field_content(0, "pMail", maximum),   strmid(PlayerInfo[playerid][pMail], maximum, 0, strlen(maximum), 64);
cache_get_field_content(0, "pMarriage", maximum),  strmid(PlayerInfo[playerid][pMarriage], maximum, 0, strlen(maximum), 32);
cache_get_field_content(0, "pMoney", maximum),  PlayerInfo[playerid][pMoney] = strval(maximum);
cache_get_field_content(0, "pHelper", maximum),  PlayerInfo[playerid][pHelper] = strval(maximum);
cache_get_field_content(0, "pAdmin", maximum),   PlayerInfo[playerid][pAdmin] = strval(maximum);
cache_get_field_content(0, "pBankPass", maximum),  PlayerInfo[playerid][pBankPass] = strval(maximum);
cache_get_field_content(0, "pBalance", maximum),  PlayerInfo[playerid][pBalance] = strval(maximum);
cache_get_field_content(0, "pDonat", maximum),   PlayerInfo[playerid][pDonat] = strval(maximum);
cache_get_field_content(0, "pHealth", maximum),  PlayerInfo[playerid][pHealth] = floatstr(maximum);
cache_get_field_content(0, "pArmour", maximum),  PlayerInfo[playerid][pArmour] = floatstr(maximum);
cache_get_field_content(0, "pSex", maximum),PlayerInfo[playerid][pSex] = strval(maximum);
cache_get_field_content(0, "pZakon", maximum),PlayerInfo[playerid][pZakon] = strval(maximum);
cache_get_field_content(0, "pFight", maximum),PlayerInfo[playerid][pFight] = strval(maximum);
cache_get_field_content(0, "pKills", maximum),PlayerInfo[playerid][pKills] = strval(maximum);
cache_get_field_content(0, "pDeath", maximum),PlayerInfo[playerid][pDeath] = strval(maximum);
cache_get_field_content(0, "pWanted", maximum),PlayerInfo[playerid][pWanted] = strval(maximum);
cache_get_field_content(0, "pWarns", maximum),PlayerInfo[playerid][pWarns] = strval(maximum);
cache_get_field_content(0, "pMuteTime", maximum),PlayerInfo[playerid][pMuteTime] = strval(maximum);
cache_get_field_content(0, "pPasport", maximum),PlayerInfo[playerid][pPasport] = strval(maximum);
cache_get_field_content(0, "pSkin", maximum),PlayerInfo[playerid][pSkin] = strval(maximum);
cache_get_field_content(0, "pJailed", maximum),PlayerInfo[playerid][pJailed] = strval(maximum);
cache_get_field_content(0, "pJailTime", maximum),PlayerInfo[playerid][pJailTime] = strval(maximum);
cache_get_field_content(0, "pPayDay", maximum),PlayerInfo[playerid][pPayDay] = strval(maximum);
cache_get_field_content(0, "pPayTime", maximum),PlayerInfo[playerid][pPayTime] = strval(maximum);
cache_get_field_content(0, "pLeader", maximum),PlayerInfo[playerid][pLeader] = strval(maximum);
cache_get_field_content(0, "pMember", maximum),PlayerInfo[playerid][pMember] = strval(maximum);
cache_get_field_content(0, "pZam", maximum),PlayerInfo[playerid][pZam] = strval(maximum);
cache_get_field_content(0, "pVigovors", maximum),PlayerInfo[playerid][pVigovors] = strval(maximum);
cache_get_field_content(0, "pRank", maximum),PlayerInfo[playerid][pRank] = strval(maximum);
cache_get_field_content(0, "pBizz", maximum), PlayerInfo[playerid][pBizz] = strval(maximum);
cache_get_field_content(0, "pVehicle", maximum),PlayerInfo[playerid][pVehicle] = strval(maximum);
cache_get_field_content(0, "pHouse", maximum),PlayerInfo[playerid][pHouse] = strval(maximum);
cache_get_field_content(0, "pRent", maximum),PlayerInfo[playerid][pRent] = strval(maximum);
cache_get_field_content(0, "pRentPrice", maximum),PlayerInfo[playerid][pRentPrice] = strval(maximum);
cache_get_field_content(0, "pMats", maximum),PlayerInfo[playerid][pMats] = strval(maximum);
cache_get_field_content(0, "pSmats", maximum),PlayerInfo[playerid][pSmats] = strval(maximum);
cache_get_field_content(0, "pSklad", maximum),PlayerInfo[playerid][pSklad] = strval(maximum);
cache_get_field_content(0, "pJob", maximum),PlayerInfo[playerid][pJob] = strval(maximum);
cache_get_field_content(0, "pLevel", maximum),PlayerInfo[playerid][pLevel] = strval(maximum);
cache_get_field_content(0, "pMedKart", maximum),PlayerInfo[playerid][pMedKart] = strval(maximum);
cache_get_field_content(0, "pBankKart", maximum),PlayerInfo[playerid][pBankKart] = strval(maximum);
cache_get_field_content(0, "pHat", maximum),PlayerInfo[playerid][pHat] = strval(maximum);
cache_get_field_content(0, "pBandana", maximum),PlayerInfo[playerid][pBandana] = strval(maximum);
cache_get_field_content(0, "pSmoke", maximum),PlayerInfo[playerid][pSmoke] = strval(maximum);
cache_get_field_content(0, "pDrugs", maximum),PlayerInfo[playerid][pDrugs] = strval(maximum);
cache_get_field_content(0, "pDepend", maximum),PlayerInfo[playerid][pDepend] = strval(maximum);
cache_get_field_content(0, "pSprunk", maximum),PlayerInfo[playerid][pSprunk] = strval(maximum);
cache_get_field_content(0, "pPolicai", maximum),PlayerInfo[playerid][pPolicai] = strval(maximum);
cache_get_field_content(0, "pBeer", maximum),PlayerInfo[playerid][pBeer] = strval(maximum);
cache_get_field_content(0, "pFish", maximum),PlayerInfo[playerid][pFish] = strval(maximum);
cache_get_field_content(0, "pCfish", maximum),PlayerInfo[playerid][pCfish] = strval(maximum);
cache_get_field_content(0, "pGrib", maximum),PlayerInfo[playerid][pGrib] = strval(maximum);
cache_get_field_content(0, "pCgrib", maximum),PlayerInfo[playerid][pCgrib] = strval(maximum);
cache_get_field_content(0, "pToy", maximum),PlayerInfo[playerid][pToy] = strval(maximum);
cache_get_field_content(0, "pWine", maximum),PlayerInfo[playerid][pWine] = strval(maximum);
cache_get_field_content(0, "pRod", maximum),PlayerInfo[playerid][pRod] = strval(maximum);
cache_get_field_content(0, "pBait", maximum),PlayerInfo[playerid][pBait] = strval(maximum);
cache_get_field_content(0, "pMedkit", maximum),PlayerInfo[playerid][pMedkit] = strval(maximum);
cache_get_field_content(0, "pFuel", maximum),PlayerInfo[playerid][pFuel] = strval(maximum);
cache_get_field_content(0, "pJemmy", maximum),PlayerInfo[playerid][pJemmy] = strval(maximum);
cache_get_field_content(0, "pPhBook", maximum),PlayerInfo[playerid][pPhBook] = strval(maximum);
cache_get_field_content(0, "pPhBalance", maximum),PlayerInfo[playerid][pPhBalance] = strval(maximum);
cache_get_field_content(0, "pPhStyle", maximum), PlayerInfo[playerid][pPhStyle] = strval(maximum);
cache_get_field_content(0, "pPhNumber", maximum),PlayerInfo[playerid][pPhNumber] = strval(maximum);
cache_get_field_content(0, "pLicGun", maximum), PlayerInfo[playerid][pLicGun] = strval(maximum);
cache_get_field_content(0, "pLicBoat", maximum),PlayerInfo[playerid][pLicBoat] = strval(maximum);
cache_get_field_content(0, "pLicFish", maximum),PlayerInfo[playerid][pLicFish] = strval(maximum);
cache_get_field_content(0, "pLicCar", maximum),PlayerInfo[playerid][pLicCar] = strval(maximum);
cache_get_field_content(0, "pLicFly", maximum),PlayerInfo[playerid][pLicFly] = strval(maximum);
cache_get_field_content(0, "pSpawn", maximum),PlayerInfo[playerid][pSpawn] = strval(maximum);
cache_get_field_content(0, "pLiked", maximum),PlayerInfo[playerid][pLiked] = strval(maximum);
cache_get_field_content(0, "pPosX", maximum),PlayerInfo[playerid][pPosX] = floatstr(maximum);
cache_get_field_content(0, "pPosY", maximum),PlayerInfo[playerid][pPosY] = floatstr(maximum);
cache_get_field_content(0, "pPosZ", maximum),PlayerInfo[playerid][pPosZ] = floatstr(maximum);
cache_get_field_content(0, "pPosA", maximum),PlayerInfo[playerid][pPosA] = floatstr(maximum);
cache_get_field_content(0, "pMir", maximum),PlayerInfo[playerid][pMir] = strval(maximum);
cache_get_field_content(0, "pInt", maximum),PlayerInfo[playerid][pInt] = strval(maximum);
cache_get_field_content(0, "pGuns0", maximum),PlayerInfo[playerid][pGuns][0] = strval(maximum);
cache_get_field_content(0, "pGuns1", maximum),PlayerInfo[playerid][pGuns][1] = strval(maximum);
cache_get_field_content(0, "pGuns2", maximum),PlayerInfo[playerid][pGuns][2] = strval(maximum);
cache_get_field_content(0, "pGuns3", maximum),PlayerInfo[playerid][pGuns][3] = strval(maximum);
cache_get_field_content(0, "pGuns4", maximum),PlayerInfo[playerid][pGuns][4] = strval(maximum);
cache_get_field_content(0, "pGuns5", maximum),PlayerInfo[playerid][pGuns][5] = strval(maximum);
cache_get_field_content(0, "pGuns6", maximum),PlayerInfo[playerid][pGuns][6] = strval(maximum);
cache_get_field_content(0, "pGuns7", maximum),PlayerInfo[playerid][pGuns][7] = strval(maximum);
cache_get_field_content(0, "pGuns8", maximum),PlayerInfo[playerid][pGuns][8] = strval(maximum);
cache_get_field_content(0, "pGuns9", maximum),PlayerInfo[playerid][pGuns][9] = strval(maximum);
cache_get_field_content(0, "pGuns10", maximum),PlayerInfo[playerid][pGuns][10] = strval(maximum);
cache_get_field_content(0, "pGuns11", maximum),PlayerInfo[playerid][pGuns][11] = strval(maximum);
cache_get_field_content(0, "pGuns12", maximum),PlayerInfo[playerid][pGuns][12] = strval(maximum);
cache_get_field_content(0, "pAmmo0", maximum),PlayerInfo[playerid][pAmmo][0] = strval(maximum);
cache_get_field_content(0, "pAmmo1", maximum),PlayerInfo[playerid][pAmmo][1] = strval(maximum);
cache_get_field_content(0, "pAmmo2", maximum),PlayerInfo[playerid][pAmmo][2] = strval(maximum);
cache_get_field_content(0, "pAmmo3", maximum),PlayerInfo[playerid][pAmmo][3] = strval(maximum);
cache_get_field_content(0, "pAmmo4", maximum),PlayerInfo[playerid][pAmmo][4] = strval(maximum);
cache_get_field_content(0, "pAmmo5", maximum),PlayerInfo[playerid][pAmmo][5] = strval(maximum);
cache_get_field_content(0, "pAmmo6", maximum),PlayerInfo[playerid][pAmmo][6] = strval(maximum);
cache_get_field_content(0, "pAmmo7", maximum),PlayerInfo[playerid][pAmmo][7] = strval(maximum);
cache_get_field_content(0, "pAmmo8", maximum),PlayerInfo[playerid][pAmmo][8] = strval(maximum);
cache_get_field_content(0, "pAmmo9", maximum),PlayerInfo[playerid][pAmmo][9] = strval(maximum);
cache_get_field_content(0, "pAmmo10", maximum),PlayerInfo[playerid][pAmmo][10] = strval(maximum);
cache_get_field_content(0, "pAmmo11", maximum),PlayerInfo[playerid][pAmmo][11] = strval(maximum);
cache_get_field_content(0, "pAmmo12", maximum),PlayerInfo[playerid][pAmmo][12] = strval(maximum);
cache_get_field_content(0, "pPasport", maximum),PlayerInfo[playerid][pPasport] = strval(maximum); //
}[/pwn]

Будьте добры, помогите мне!
В долгу не останусь, вознаграждение в виде 100 wmr scare



[Open Source] GTO v.0.5.8 - 0.7.2 [all series]

[GM] GTA-EU Role Play (akka Awesome RPg)
[GM] MultiGTA - Rishat edition 2011

[MAP] Автошкола. (Los Santos)
[MAP] Hospital - Больница (Los Santos)


Сообщение отредактировал Rishat - Понедельник, 21.10.2013, 23:03
Форум SAMP о мультиплеерах для GTA. » SAMP скачивание и обсуждение » Вопросы и Проблемы » [MySQL or RegSys] Падения севера
Страница 1 из 11
Поиск:





 


 


 
Хостинг от uCoz SAMP-RUS.COM