[MySQL or RegSys] Падения севера

Дата: Понедельник, 21.10.2013, 23:00 | Сообщение # 1

Уверенный в себе

Группа: Продвинутые

Сообщений: 235

Награды: 3

Город: Nab. Chelny

Репутация: 56

Замечания: 0%

Статус:

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

И вот настал тот день когда на сервер стало ломиться куча ~~проэрпешников~~школьников.

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

Код

[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