Jump to content

AsSsASIN

Membru
  • Posts

    71
  • Joined

  • Last visited

    Never

Everything posted by AsSsASIN

  1. Ba, pune in code scriptul ca nu inteleg nimic.
  2. Cand creaza Informatia Playerului ' Parola ' se aplica actiunea ' Encrypt ' ? Exista cateva posibilitati : 1. Formatul salvarii 2. Encrypt-ul. 3. Verificarea parolii De asta folosesc sql )
  3. AsSsASIN

    SQLite

    In fine 90% din tutorial stiam deja, si cand invatam eu sql nici nu era facut topicul asta ). PlayON, bravo ca ai stat sa explici ce face fiecare functie ... problema este ca nu toate au aceleasi functii, altele au callbackuri si totul se complica dar astea sunt in general la toate.
  4. else-ul il facusem ca test, si nu stiam de addplayerclass ). Orcum l-am rezolvat cu class. Closed.
  5. public OnPlayerRequestClass(playerid, classid) { new loginstring[ 256 ], loginname[ 64 ], regstring[ 256 ], string[ 256 ], escip[ 15 ], ip[ 15 ] ; GetPlayerIp(playerid, ip, 15); mysql_real_escape_string(ip, escip); GetPlayerName(playerid,loginname,sizeof(loginname)); if (gPlayerAccount[playerid] != 0) { if(gPlayerLogged[playerid] == 0) { format(loginstring,sizeof(loginstring),"{FFFFFF}Your IP is different, please enter your password.",loginname); ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"{FFFFFF}Login to the server.",loginstring,"Login", ""); } } else { gPlayerAccount[playerid] = 0; format(regstring,sizeof(regstring),"{FFFFFF}Welcome on {0000FF}eXtrike Federation{FFFFFF}.\n{FFFFFF}What's up {0000FF}%s{FFFFFF}? Please enter your password.",loginname); ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"{FFFFFF}Login to the server.",regstring,"Register", ""); } SetPlayerPos(playerid, -2482.26, -285.37, 40.54); SetPlayerFacingAngle(playerid, 90.00); SetPlayerCameraPos(playerid, -2485.67, -287.22, 42.34); SetPlayerCameraLookAt(playerid, -2481.59, -285.01, 40.49); if (classid == 0) { SetPlayerSkin(playerid, 180); format(string, sizeof(string), "~r~Bloodz"); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 1) { SetPlayerSkin(playerid, 67); format(string, sizeof(string), "~r~Bloodz"); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 2) { SetPlayerSkin(playerid, 297); format(string, sizeof(string), "~b~Cripz"); GameTextForPlayer(playerid,string,3500,6); } else if (classid == 3) { SetPlayerSkin(playerid, 21); format(string, sizeof(string), "~b~Cripz"); GameTextForPlayer(playerid,string,3500,6); } else classid = 0; SetPlayerTeamFromClass(playerid,classid); return 1; } public SetPlayerTeamFromClass(playerid,classid) { if (classid == 0) { SetPlayerSkin(playerid, 180); PlayerInfo[playerid][pGangTeam] = 1; } else if (classid == 1) { SetPlayerSkin(playerid, 67); PlayerInfo[playerid][pGangTeam] = 1; } else if (classid == 2) { SetPlayerSkin(playerid, 297); PlayerInfo[playerid][pGangTeam] = 2; } else if (classid == 3) { SetPlayerSkin(playerid, 21); PlayerInfo[playerid][pGangTeam] = 2; } } Ma fac de ras, dar asta este. Deci, dupa verificarea classid 3, 'trece la al 4' care nu exista, si tot asa 4,5,6,7,8 infinit, nu stiu cum doamne iarta-ma face asa, ca normal trebuia sa se intoarca la classid 0... Blank GM on mysql...
  6. sa inteleg ca tu nu ai gamemodul GodFather?
  7. Amarat de scripter. Macar daca ma puneai author, saracutul, cand o sa fac tutorial compley car ownership si mysql, o sa fi primul care posteaza pe ro ha? EDIT 1: In caz ca comentezi, exDDD > eXtrike DDD EDIT 2: Ai modificat putin tutorialul? cine nu stia faza cu return? EDIT 3: Nici macar nu sti sa minti, singurul Tutorial facut , a fost pe Arth. mai era pe Cyber-Network, dar era diferit, si orcum acum e sters, singurul link, arth.
  8. Tot incerc, si iar incerc, defapt am rezolvat cu salvarea, dar parola nu se salveaza cum trebuie ... public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) { new tmppass[64],loginstring[256],loginname[64],regstring[256]; GetPlayerName(playerid,loginname,sizeof(loginname)); if(response) { if(dialogid == 1) { if(strlen(inputtext)) { //Encrypt(tmppass); strmid(tmppass, inputtext, 0, strlen(inputtext), 255); OnPlayerLogin(playerid,tmppass); } else { format(loginstring,sizeof(loginstring),"{FF0000}WRONG PASSWORD!! {FFFFFF}please write the correct password.",loginname); ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"{FFFFFF}Login to the server.",loginstring,"Login", ""); } } if(dialogid == 2) { if(strlen(inputtext)) { //Encrypt(tmppass); strmid(tmppass, inputtext, 0, strlen(inputtext), 255); OnPlayerRegister(playerid,tmppass); } else { format(regstring,sizeof(regstring),"{FFFFFF}Welcome on {0000FF}eXtrike Federation{FFFFFF}.\n{FFFFFF}What's up {0000FF}%s{FFFFFF}? Please enter your password.",loginname); ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"{FFFFFF}Login to the server.",regstring,"Register", ""); } } return 1; } return 1; } public SavePlayerData(playerid) { new query[700]; format(query, 700, "UPDATE `players` SET `password` ='%s', `Admin` ='%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pAdmin], ReturnName(playerid)); mysql_query(query); return 1; } [14:12:09] MySQL Debugging activated (02/24/11) [14:12:09] --------------------------- [14:12:09] [14:12:44] >> mysql_real_escape_string( Connection handle: 1 ) [14:12:44] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD. [14:12:44] >> mysql_query( Connection handle: 1 ) [14:12:44] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(username) = LOWER('exDDD') LIMIT 1) - Successfully executed. [14:12:44] >> mysql_store_result( Connection handle: 1 ) [14:12:44] CMySQLHandler::StoreResult() - Result was stored. [14:12:44] >> mysql_num_rows( Connection handle: 1 ) [14:12:44] CMySQLHandler::NumRows() - Returned 0 row(s) [14:12:50] >> mysql_real_escape_string( Connection handle: 1 ) [14:12:50] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD. [14:12:50] >> mysql_real_escape_string( Connection handle: 1 ) [14:12:50] CMySQLHandler::EscapeString(******); - Escaped 6 characters to ******. [14:12:50] >> mysql_query( Connection handle: 1 ) [14:12:50] CMySQLHandler::Query(INSERT INTO players (username, password) VALUES ('exDDD', '******')) - Successfully executed. [14:12:54] >> mysql_query( Connection handle: 1 ) [14:12:54] CMySQLHandler::Query(SELECT password FROM players WHERE id = 104 LIMIT 1) - Successfully executed. [14:12:54] >> mysql_store_result( Connection handle: 1 ) [14:12:54] CMySQLHandler::StoreResult() - Result was stored. [14:12:54] >> mysql_fetch_row_format( Connection handle: 1 ) [14:12:55] >> mysql_query( Connection handle: 1 ) [14:12:55] CMySQLHandler::Query(SELECT password FROM players WHERE id = 104 LIMIT 1) - Successfully executed. [14:12:55] >> mysql_store_result( Connection handle: 1 ) [14:12:55] CMySQLHandler::StoreResult() - Result was stored. [14:12:55] >> mysql_fetch_row_format( Connection handle: 1 ) [14:13:04] >> mysql_query( Connection handle: 1 ) [14:13:04] CMySQLHandler::Query(SELECT password FROM players WHERE id = 104 LIMIT 1) - Successfully executed. [14:13:04] >> mysql_store_result( Connection handle: 1 ) [14:13:04] CMySQLHandler::StoreResult() - Result was stored. [14:13:04] >> mysql_fetch_row_format( Connection handle: 1 ) [14:13:04] >> mysql_query( Connection handle: 1 ) [14:13:04] CMySQLHandler::Query(SELECT * FROM players WHERE id = 104 LIMIT 1) - Successfully executed. [14:13:04] >> mysql_store_result( Connection handle: 1 ) [14:13:04] CMySQLHandler::StoreResult() - Result was stored. [14:13:04] >> mysql_fetch_row_format( Connection handle: 1 ) [14:13:04] >> mysql_free_result( Connection handle: 1 ) [14:13:04] CMySQLHandler::FreeResult() - Result was successfully free'd. [14:13:34] >> mysql_query( Connection handle: 1 ) [14:13:34] CMySQLHandler::Query(UPDATE `players` SET `password` ='**:***', `Admin` ='1338' WHERE `username` ='exDDD' ) - Successfully executed. [14:14:13] >> mysql_close( Connection handle: 1 ) [14:14:13] CMySQLHandler::~CMySQLHandler() - deconstructor called. [14:14:13] CMySQLHandler::FreeResult() - The result is already empty. [14:14:13] CMySQLHandler::Disconnect() - Connection was closed.
  9. Noua syntaxa public SavePlayerData(playerid) { new query[700]; format(query, 700, "UPDATE players SET password=%s, Admin=%d WHERE username=%s", PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pAdmin], ReturnName(playerid)); mysql_query(query); return 1; } .. si zice eroare din mysql ca syntaxa e gresita, problema?
  10. in fine, am facut eu ceva si am reusit, dar nu se salveaza corect, se salveaza cifre aiurea :|
  11. [19:16:27] MySQL Debugging activated (02/21/11) [19:16:27] --------------------------- [19:16:27] [19:47:32] >> mysql_real_escape_string( Connection handle: 1 ) [19:47:32] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD. [19:47:32] >> mysql_query( Connection handle: 1 ) [19:47:32] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(username) = LOWER('exDDD') LIMIT 1) - Successfully executed. [19:47:32] >> mysql_store_result( Connection handle: 1 ) [19:47:32] CMySQLHandler::StoreResult() - Result was stored. [19:47:32] >> mysql_num_rows( Connection handle: 1 ) [19:47:32] CMySQLHandler::NumRows() - Returned 0 row(s) [19:47:37] >> mysql_real_escape_string( Connection handle: 1 ) [19:47:37] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD. [19:47:37] >> mysql_real_escape_string( Connection handle: 1 ) [19:47:37] CMySQLHandler::EscapeString(******); - Escaped 6 characters to ******. [19:47:37] >> mysql_query( Connection handle: 1 ) [19:47:37] CMySQLHandler::Query(INSERT INTO players (username, password) VALUES ('exDDD', '******')) - Successfully executed. [19:47:38] >> mysql_query( Connection handle: 1 ) [19:47:38] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 0 LIMIT 1) - Successfully executed. [19:47:38] >> mysql_store_result( Connection handle: 1 ) [19:47:38] CMySQLHandler::StoreResult() - Result was stored. [19:47:38] >> mysql_fetch_row_format( Connection handle: 1 ) [19:47:39] >> mysql_query( Connection handle: 1 ) [19:47:39] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 0 LIMIT 1) - Successfully executed. [19:47:39] >> mysql_store_result( Connection handle: 1 ) [19:47:39] CMySQLHandler::StoreResult() - Result was stored. [19:47:39] >> mysql_fetch_row_format( Connection handle: 1 ) [19:47:39] >> mysql_query( Connection handle: 1 ) [19:47:39] CMySQLHandler::Query(SELECT * FROM players WHERE id = 0 LIMIT 1) - Successfully executed. [19:47:39] >> mysql_store_result( Connection handle: 1 ) [19:47:39] CMySQLHandler::StoreResult() - Result was stored. [19:47:39] >> mysql_fetch_row_format( Connection handle: 1 ) [19:47:39] >> mysql_free_result( Connection handle: 1 ) [19:47:39] CMySQLHandler::FreeResult() - Result was successfully free'd. [19:49:28] >> mysql_query( Connection handle: 1 ) [19:49:28] CMySQLHandler::Query(UPDATE `players` SET `Level` = '1', `AdminLevel` = '0', `DonateRank` = '0', `PointsUpgrade` = '0', `ConnectTime` = '101', `Reg` = '77', `Sex` = '77' WHERE `username` = 'Multiple users found, please narrow earch';) - Successfully executed. [19:50:07] >> mysql_query( Connection handle: 1 ) [19:50:07] CMySQLHandler::Query(UPDATE `players` SET `Level` = '1', `AdminLevel` = '0', `DonateRank` = '0', `PointsUpgrade` = '0', `ConnectTime` = '101', `Reg` = '77', `Sex` = '77' WHERE `username` = 'Multiple users found, please narrow earch';) - Successfully executed. [19:55:20] CMySQLHandler::~CMySQLHandler() - deconstructor called. [19:55:20] CMySQLHandler::FreeResult() - The result is already empty. [19:55:20] CMySQLHandler::Disconnect() - Connection was closed.
  12. la fel, deci, nu stiu ce sa fac :| laz, pentru salvarea datelor, zi-mi ce trebuia sa fac de la inceput de la sfarsit, poate am omis ceva..
  13. Fix in capat e topicul meu, hai sus... laz, hai te roaga tata ca pe vremurile trecute de cand jucam pe ro zone, uitete, ca chiar nu imi dau seama :-s
  14. public SavePlayerData(playerid) { if(IsPlayerConnected(playerid)) { if(gPlayerLogged[playerid]) { new query[MAX_STRING]; format(query, MAX_STRING, "UPDATE players SET "); mysql_query(query); PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid); if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0)) { PlayerInfo[playerid][pPos_x] = 1684.9; PlayerInfo[playerid][pPos_y] = -2244.5; PlayerInfo[playerid][pPos_z] = 13.5; } format(query, MAX_STRING, "UPDATE `players` SET `Level` = `%d`,\ `AdminLevel` = `%d`,\ `DonateRank` = `%d`,\ `PointsUpgrade` = `%d`,\ `ConnectTime` = `%d`,\ `Reg` = `%d`,\ `Sex` = `%d`\ WHERE `username` = `%s`", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade], ReturnName(playerid)); mysql_query(query); } } return 1; } ce tot are, ce am gresit iara :|?
  15. Imi dai te rog public ReturnName? Acum inteleg de ce nu mergea... cum am zis eu, id sau username...
  16. Noua Syntaxa este buna ? format(query, MAX_STRING, "UPDATE `players` SET `Level` = %d, `AdminLevel` = %d, `DonateRank` = %d, `PointsUpgrade` = %d WHERE `username` = %d", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade], PlayerInfo[playerid][pSQLID]);
  17. Auzi, trebuie sa mergem pe username sau SQLID ?
  18. Daca ai mysql , da-mi te rog o parte din save player, sa vad ca exemplu, ca sa vad inainte sa ma apuc sa fac, ca dupa sa nu vad ca nu merge..
  19. laz zice ca este pentru numere reale..
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.