Jump to content

AsSsASIN

Membru
  • Posts

    71
  • Joined

  • Last visited

    Never

AsSsASIN's Achievements

Enthusiast

Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  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 :|
×
×
  • 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.