Xcite

maciboss : gresesti , gamemode-ul acela are aproape un cuvant la fiecare textdraw . @ cauta la ongamemodeinit textdraw-urile ( sunt foarte multe , mam uitat si eu peste gm) si iti dai seama care sunt , le stergi / modifici.

Nu se cer scripturi + cine crezi ca iti face/da tie ceva aproape unic doar pe 1-2 servere daca e ?

Cauti la dialog / textul unde iti zice sa alegi si daca pune female , unde ii seteaza pSex adauga dupa: SetPlayerSkin(playerid, 193); PlayerInfo[playerid][pChar] = 193; 193 - inlocuiesti cu ce skin vrei

Nu e aranjat tutorialul , e pus doar +1 si pentru a te 'vota' cineva , 1/5 . Daca il aranjai frumos , cu code si fara culori , pur si simplu de copii , toate culorile acolo , font + bold .

Mersi , am rezolvat . Ai + la respect :tongue:

Apare asa : CMySQLHandler::Query(INSERT INTO `banlog` (`user`, `admin`, `reason`, `data`, `ip`) VALUES ('Chris', 'Chris', 'test', '09/08/2011 09:20', '127.0.0.1) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''127.0.0.1' at line 1) [09:20:42] >> mysql_query( Connection handle: 1 ) Vad ca nu introduce bine ip-ul , da eroare cand sa introduca ip-ul . ( ip e de la localhost , pentru ca lam pornit pe localhost )

Nimeni ? Precizez ca tabelul banlog e facut bine , daca introduc din phpmyadmin , comanda SQL merge , dar de la comanda /ban nu .

Am facut la comanda /ban sa introduca intr-un tabel mysql , dar nu se introduce , care poate fi problema: if(strcmp(cmd, "/ban", true) == 0) { if(IsPlayerConnected(playerid)) { tmp = strtok(cmdtext, idx); if(!strlen(tmp)) { SendClientMessage(playerid, COLOR_GRAD2, "USAGE: /ban [playerid/PartOfName] [reason]"); return 1; } giveplayerid = ReturnUser(tmp); if (PlayerInfo[playerid][pAdmin] >= 1) { if(IsPlayerConnected(giveplayerid)) { if(giveplayerid != INVALID_PLAYER_ID) { GetPlayerName(giveplayerid, giveplayer, sizeof(giveplayer)); GetPlayerName(playerid, sendername, sizeof(sendername)); new length = strlen(cmdtext); while ((idx < length) && (cmdtext[idx] <= ' ')) { idx++; } new offset = idx; new result[64]; while ((idx < length) && ((idx - offset) < (sizeof(result) - 1))) { result[idx - offset] = cmdtext[idx]; idx++; } result[idx - offset] = EOS; if(!strlen(result)) { SendClientMessage(playerid, COLOR_GRAD2, "USAGE: /ban [playerid/PartOfName] [reason]"); return 1; } if(bantime[playerid] == 1) return SendClientMessage(playerid, COLOR_GRAD2, "Are you trying to ban this server?"); new string23[128]; new Query[128]; new playersip[256]; GetPlayerIp(giveplayerid,playersip, sizeof(playersip)); new year, month, day, hour, minute , second; getdate(year, month, day); gettime(hour, minute, second); format(string23, sizeof(string23), "%02d/%02d/%d %02d:%02d", day, month, year, hour, minute); format(Query, sizeof(Query), "INSERT INTO `banlog` (`user`, `admin`, `reason`, `data`, `ip`) VALUES ('%s', '%s', '%s', '%s', '%s')", giveplayer, sendername, (result), string23, playersip); mysql_query(Query); mysql_free_result(); format(string23, sizeof(string23), "AdmCmd: %s was banned by %s, reason: %s", giveplayer, sendername, (result)); SendClientMessageToAll(COLOR_LIGHTRED, string23); SendClientMessage(giveplayerid,COLOR_GREEN,"|___________[BAN INFO]___________|"); format(string23, sizeof(string23), "Numele tau este: %s.",giveplayer); SendClientMessage(giveplayerid, COLOR_RED, string23); format(string23, sizeof(string23), "IP-ul tau este: %s.",playersip); SendClientMessage(giveplayerid, COLOR_RED, string23); format(string23, sizeof(string23), "Ai fost banat de: %s.",sendername); SendClientMessage(giveplayerid, COLOR_RED, string23); format(string23, sizeof(string23), "Motiv: %s.",(result)); SendClientMessage(giveplayerid, COLOR_RED, string23); format(string23, sizeof(string23), "Data: %d/%d/%d",day,month,year); SendClientMessage(giveplayerid, COLOR_RED, string23); SendClientMessage(giveplayerid,COLOR_GREEN,"|___________[BAN INFO]___________|"); SendClientMessage(giveplayerid,COLOR_RED,"Puteti face o cerere de unban pe forum www.EvGaming.Ro/forum"); SendClientMessage(giveplayerid,COLOR_RED,"Este necesara o poza cu aceste detalii despre ban !"); bantime[playerid] = 1; SetTimerEx("bant", 10000, 0, "%d", playerid); PlayerInfo[giveplayerid][pLocked] = 1; Kick(giveplayerid); return 1; } }//not connected } else { format(string, sizeof(string), " %d is not an active player.", giveplayerid); SendClientMessage(playerid, COLOR_GRAD1, string); } } return 1; } Care poate fi problema ? nu insereaza in baza de date .

Nu , din potriva daca citeati postul meu dupa a lui cristian , si intelegeai macar , nu cred ca e asa greu iti dadeai seama care e problema . In Gamemode e pus un IP , iar la conectare foloseste ip-ul game control panelului , e bug de la ei sau nu am idee . Folosesc pluginul lui g-stylezzz versiunea R4-2 pentru ca , cu asta nu primesc eroarea cu libmysqlclient.so.x pe debian . Nu imi ziceti sa iau R5 sau R6 pentru ca merge cu R4-2 pe vps meu , am testat asta . Problema e: in gamemode mysql_connect e pus pe un ip , dar la conectare foloseste alt IP , ip unde e gamecp .

Nu mai posta +1 daca nu stii ! ma crezi asa de tampit sa nu pun ? doamne... citeste de 100000 ori , pana cand intelegi . Nu o lua ca pe o jignire dar asta faci +1 , si nu ai inteles nimic din ce am zis .

+1 ? @stefanel: da pe linux , debian. @secret: nu posta daca esti pe langa cu ele .

Adaug eu: Nu se face conexiunea HOST SERVER - WEBHOST , dar PC - WEBHOST merge . Daca la remote mysql am ip-ul hostului si a pc-ului amandoua , nu merge niciunul sau daca e si IP-ul hostului printre altele . Daca scot IP-ul hostului de la server merge conexiunea PC - WEBHOST , dar daca il bag nu merge nici asa . Dar vreau sa pornesc de pe host , si nu se conecteaza , posibil sa aibe ceva firewall ? Doar pe hostul asta am patit , pe vps meu nu face asa dar am o problema cu debianul.

Aici nu se cer id-uri de messenger .

[12:56:18] [12:56:18] --------------------------- [12:56:18] MySQL Debugging activated (08/06/11) [12:56:18] --------------------------- [12:56:18] [12:56:18] >> mysql_connect( ) [12:56:18] CMySQLHandler::CMySQLHandler() - constructor called. [12:56:18] CMySQLHandler::CMySQLHandler() - Connecting to "IP" | DB: "domeniu_rpg" | Username: "domeniu_xcite" ... [12:56:39] CMySQLHandler::Connect() - Can't connect to MySQL server on 'IP' (10060) (Error ID: 2003) [12:56:39] >> mysql_ping( Connection handle: 1 ) [12:56:39] CMySQLHandler::Ping() - You cannot call this function now. (Reason: Dead Connection)

Am o problema cu conectarea la remote mysql database , adica vreau sa conectez serverul la baza de date de pe alt host . Pe localhost merge serverul , dar cand bag pe remote nu se conecteaza . Hostul l-am pus ip-ul de la webhost dar si domeniu.ro ( mentionez ca am pus ip-ul bun ) , DB si user si acelea sunt bine puse ( au prefix gen domeniu_ ) am pus cu si fara prefix si tot nu merge. Care poate fi problema ?

in debug.txt apare: [15:50:53] [15:50:53] --------------------------- [15:50:53] MySQL Debugging activated (08/01/11) [15:50:53] --------------------------- [15:50:53] [15:50:54] >> mysql_query( Connection handle: 1 ) [15:50:54] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead) [15:50:54] >> mysql_query( Connection handle: 1 ) Multe linii dinastea, iar pe localhost merge dar pe o baza de date de pe alt host nu merge , spre exemplu unde am hostat domeniul . Am adaugat la remote mysql ip-ul unde e hostat serverul dar tot nu vrea , am pus corect baza de date in gm ... iar la SQL_HOST am pus ip-ul hostului , am schimbat si in localhost.domeniu.ro si in domeniu.ro dar tot nu vrea...

Am spus mai sus ca e corecta , pe ip-ul hostului , baza de date corect.

Pluginul e a lui g-stylezz iar partea pawno e luata dintr-un gamemode a lui extr1ke.

Nu mi se creeaza niciun fisier mysql_log iar in server log apare: [16:01:52] MySQL: Connect to the server. [16:01:53] MySQL: Connection error, retrying... [16:01:54] MySQL: Ping: -1

Am o problema cu serverul pe baza de date mysql , l-am pornit in PC pe windows si nu se conecteaza la baza de date de pe alt host , unde e si site-ul hostat. Care poate fi problema ? Trebuie ca serverul sa fie pe acelasi host cu baza de date ? eu stiam ca merge daca adaug la Remote MYSQL , am adaugat IP-ul si tot nu merge.

Cand sa pornesc serverul cu gamemode pe mysql , primesc urmatoarea eroare: samp03svr: amx/amx.c:803: expand: Assertion `sc<64' failed. Am adaugat mysql.so .

Ai definite de 2 ori OnPlayerConnect si OnPlayerDisconnect , sterge sa ramana doar o singura data amandoua.

Multumesc irinel , cred ca asta era . Aveam createnote si altele , dar le-am scos ieri cand am mutat pe mysql pentru ca nu erau folositoare , iar acum am observat raspunsurile . EDIT: Bun , dar am o intrebare , acum mi-am amintit: dupa ce am modificat pAdmin in pAmdlvl tot si-a dat admin , de unde stia ca am pus pAmdlvl ... oricum e scoasa comanda pentru orice eventualitate + am mutat pe baza de date mysql , astfel nu mai poate edita tabelele ci doar acela daca ar fi sa mai am comanda .

Salut , am o MARE problema , niste hackeri retardati pentru ca altfel nu le pot zice din spania intra in fiecare seara , deja de 3 ori am patit si isi baga admin AUTOMAT , precizez ca sa nu faceti +1 care nu stiti , urmatorele: nu am comanda ascunsa de makeadmin , nu am comanda de ban . Ei isi baga admin 2012 sau 1338 sau orice vor iar sistemul meu e doar de la 1-5 rank. Am verificat peste tot si nu mai am idee ce sa fac , am modificat si pAdmin in pAmdlvl sau altceva si tot isi baga admin . Am postat aceasta problema si pe sa-mp.com , dar nu prea am gasit raspunsul .

Am modificat si am pus de la 2 , adica sar peste 0 si 1 care e parola si sqlid , acestea le am doar la public AutoLogin si public OnPlayerLogin , postez aici autlogin , nu cred ca e complet ... daca e gresit poate e lipsa ceva si imi ziceti ce sa adaug si la el si la onplayerlogin public AutoLogin(playerid) { new string[ 400 ] ; format(string,400,"SELECT * FROM `players` WHERE `username` = '%s'",ReturnName(playerid)); MySQL:query(string); MySQL:store_result(); if(MySQL:num_rows() != 0) { new row[128]; new field[125]; MySQL:fetch_row_format(row, "|"); explode(row, field, "|"); MySQL:free_result(); PlayerInfo[playerid][pLevel] = strval(field[2]); PlayerInfo[playerid][pAdmin] = strval(field[3]); PlayerInfo[playerid][pIP] = strval(field[4]); PlayerInfo[playerid][pHelper] = strval(field[5]); PlayerInfo[playerid][pHMuted] = strval(field[6]); PlayerInfo[playerid][pDonateRank] = strval(field[7]); PlayerInfo[playerid][gPupgrade] = strval(field[8]); PlayerInfo[playerid][pConnectTime] = strval(field[9]); PlayerInfo[playerid][pReg] = strval(field[10]); PlayerInfo[playerid][pSex] = strval(field[11]); PlayerInfo[playerid][pAge] = strval(field[12]); PlayerInfo[playerid][pRobSkill] = strval(field[13]); PlayerInfo[playerid][pRob] = strval(field[14]); PlayerInfo[playerid][pOrigin] = strval(field[15]); PlayerInfo[playerid][pCK] = strval(field[16]); PlayerInfo[playerid][pMuted] = strval(field[17]); PlayerInfo[playerid][pMuteTime] = strval(field[18]); PlayerInfo[playerid][pExp] = strval(field[19]); PlayerInfo[playerid][pCash] = strval(field[20]); PlayerInfo[playerid][pAccount] = strval(field[21]); PlayerInfo[playerid][pAccf] = strval(field[22]); PlayerInfo[playerid][pCrimes] = strval(field[23]); PlayerInfo[playerid][pKills] = strval(field[24]); PlayerInfo[playerid][pDeaths] = strval(field[25]); PlayerInfo[playerid][pArrested] = strval(field[26]); PlayerInfo[playerid][pWantedDeaths] = strval(field[27]); PlayerInfo[playerid][pWantedLevel] = strval(field[28]); PlayerInfo[playerid][pWantedPoints] = strval(field[29]); PlayerInfo[playerid][pPhoneBook] = strval(field[30]); PlayerInfo[playerid][pLottoNr] = strval(field[31]); PlayerInfo[playerid][pFishes] = strval(field[32]); PlayerInfo[playerid][pBiggestFish] = strval(field[33]); PlayerInfo[playerid][pJob] = strval(field[34]); PlayerInfo[playerid][pPayCheck] = strval(field[35]); PlayerInfo[playerid][pHeadValue] = strval(field[36]); PlayerInfo[playerid][pJailed] = strval(field[37]); PlayerInfo[playerid][pJailTime] = strval(field[38]); PlayerInfo[playerid][pMats] = strval(field[39]); PlayerInfo[playerid][pDrugs] = strval(field[40]); PlayerInfo[playerid][pLeader] = strval(field[41]); PlayerInfo[playerid][pCLeader] = strval(field[42]); PlayerInfo[playerid][pMember] = strval(field[43]); PlayerInfo[playerid][pCMember] = strval(field[44]); PlayerInfo[playerid][pFMember] = strval(field[45]); PlayerInfo[playerid][pRank] = strval(field[46]); PlayerInfo[playerid][pCRank] = strval(field[47]); PlayerInfo[playerid][pChar] = strval(field[48]); PlayerInfo[playerid][pContractTime] = strval(field[49]); PlayerInfo[playerid][pDetSkill] = strval(field[50]); PlayerInfo[playerid][pSexSkill] = strval(field[51]); PlayerInfo[playerid][pBoxSkill] = strval(field[52]); PlayerInfo[playerid][pLawSkill] = strval(field[53]); PlayerInfo[playerid][pMechSkill] = strval(field[54]); PlayerInfo[playerid][pJackSkill] = strval(field[55]); PlayerInfo[playerid][pCarSkill] = strval(field[56]); PlayerInfo[playerid][pNewsSkill] = strval(field[57]); PlayerInfo[playerid][pDrugsSkill] = strval(field[58]); PlayerInfo[playerid][pCookSkill] = strval(field[59]); PlayerInfo[playerid][pFishSkill] = strval(field[60]); PlayerInfo[playerid][pHealth] = strval(field[61]); PlayerInfo[playerid][pSHealth] = strval(field[62]); PlayerInfo[playerid][pInt] = strval(field[63]); PlayerInfo[playerid][pLocal] = strval(field[64]); PlayerInfo[playerid][pTeam] = strval(field[65]); PlayerInfo[playerid][pModel] = strval(field[66]); PlayerInfo[playerid][pPnumber] = strval(field[67]); PlayerInfo[playerid][pPhousekey] = strval(field[68]); PlayerInfo[playerid][pPcarkey] = strval(field[69]); PlayerInfo[playerid][pPcarkey2] = strval(field[70]); PlayerInfo[playerid][pPcarkey3] = strval(field[71]); PlayerInfo[playerid][pGangKey] = strval(field[72]); PlayerInfo[playerid][pPbiskey] = strval(field[73]); PlayerInfo[playerid][pPos_x] = strval(field[74]); PlayerInfo[playerid][pPos_y] = strval(field[75]); PlayerInfo[playerid][pPos_z] = strval(field[76]); PlayerInfo[playerid][pTow] = strval(field[77]); PlayerInfo[playerid][pCarLic] = strval(field[78]); PlayerInfo[playerid][pFlyLic] = strval(field[79]); PlayerInfo[playerid][pBoatLic] = strval(field[80]); PlayerInfo[playerid][pFishLic] = strval(field[81]); PlayerInfo[playerid][pGunLic] = strval(field[82]); PlayerInfo[playerid][pPassport] = strval(field[83]); PlayerInfo[playerid][pGun1] = strval(field[84]); PlayerInfo[playerid][pGun2] = strval(field[85]); PlayerInfo[playerid][pGun3] = strval(field[86]); PlayerInfo[playerid][pGun4] = strval(field[87]); PlayerInfo[playerid][pAmmo1] = strval(field[88]); PlayerInfo[playerid][pAmmo2] = strval(field[89]); PlayerInfo[playerid][pAmmo3] = strval(field[90]); PlayerInfo[playerid][pAmmo4] = strval(field[91]); PlayerInfo[playerid][pCarTime] = strval(field[92]); PlayerInfo[playerid][pPayDay] = strval(field[93]); PlayerInfo[playerid][pPayDayHad] = strval(field[94]); PlayerInfo[playerid][pWatch] = strval(field[95]); PlayerInfo[playerid][pCrashed] = strval(field[96]); PlayerInfo[playerid][pWins] = strval(field[97]); PlayerInfo[playerid][pLoses] = strval(field[98]); PlayerInfo[playerid][pAlcoholPerk] = strval(field[199]); PlayerInfo[playerid][pDrugPerk] = strval(field[100]); PlayerInfo[playerid][pMiserPerk] = strval(field[101]); PlayerInfo[playerid][pPainPerk] = strval(field[102]); PlayerInfo[playerid][pTraderPerk] = strval(field[103]); PlayerInfo[playerid][pTut] = strval(field[104]); PlayerInfo[playerid][pMissionNr] = strval(field[105]); PlayerInfo[playerid][pWarns] = strval(field[106]); PlayerInfo[playerid][pFwarns] = strval(field[107]); PlayerInfo[playerid][pVirWorld] = strval(field[108]); PlayerInfo[playerid][pFuel] = strval(field[109]); PlayerInfo[playerid][pMarried] = strval(field[110]); PlayerInfo[playerid][pMarriedTo] = strval(field[111]); PlayerInfo[playerid][pFishTool] = strval(field[112]); PlayerInfo[playerid][pInvWeapon] = strval(field[113]); PlayerInfo[playerid][pInvAmmo] = strval(field[114]); PlayerInfo[playerid][pLighter] = strval(field[115]); PlayerInfo[playerid][pCigarettes] = strval(field[116]); PlayerInfo[playerid][pRequestingBackup] = strval(field[117]); PlayerInfo[playerid][pRoadblock] = strval(field[118]); PlayerInfo[playerid][pMask] = strval(field[119]); PlayerInfo[playerid][pMaskuse] = strval(field[120]); PlayerInfo[playerid][pHideNumber] = strval(field[121]); PlayerInfo[playerid][pSpeaker] = strval(field[122]); PlayerInfo[playerid][pLocked] = strval(field[123]); PlayerInfo[playerid][pPunish] = strval(field[124]); GivePlayerMoney(playerid,PlayerInfo[playerid][pCash]); } SendClientMessage(playerid, 0xAFAFAFAA, "{FF0000}MySQL:{FFFFFF} You were automatically logged."); gPlayerLogged[playerid] = 1; return 1; } EDIT: Acum apare doar: error 048: array dimensions do not match error 048: array dimensions do not match 2 erori la fel.. in 2 locuri ( public onplayerlogin si public autologin la field .. )