Rimmon Posted July 2, 2013 Report Share Posted July 2, 2013 In acest tutorial va voi prezenta funtiile SQLite-uluidb_open(); - deschide o baza de date daca exista si creaza una noua daca nu exista(folosita de obicei la OnGameModeInit/OnFilterScriptInit)Ex:db_open("Player.db"); db_close(); - inchide baza de date(folosita de obicei la OnGameModeExit/OnFilterScriptExit)Ex: db_close(numele DB:-ului); db_query(); - scrie in baza de dateEx: db_query(Database,"UPDATE `Users` SET `Money` = '1000' WHERE `Name` = 'rimmon'"); in traducere vine - updateaza users si seteaza money = 1000 unde numele este rimmon db_free_result(DBResult:dbresult); - elibereaza rezultatul scris in db_queryEx: db_free_result(db_query(Database,"UPDATE `Users` SET `Money` = '1000' WHERE `Name` = 'rimmon'")); db_num_rows(DBResult:dbresult); - verifica daca exista ce ai scris tu in db_queryEx: new DBResult:result; result = db_query(Database,"SELECT `Name` FROM `Users` WHERE `Name` = 'rimmon'"); if(db_num_rows(result)) { SendClientMessage(playerid,-1,"Acest cont exista"); } else { SendClientMessage(playerid,-1,"Acest cont nu exista"); } db_next_row(DBResult:dbresult); - ia urmatorul rezultat dintr-o coloana(nu sunt sigur de explicatie,dati un reply daca nu am dreptate)Ex: new DBResult:Result; Result = db_query( Database, "SELECT * FROM `Users` WHERE `Name`='Rimmon'" ); for(new a;a<db_num_rows(Result);a++) { new info[2][30]; db_get_field_assoc(Result, "ip", info[0], 30); db_get_field_assoc(Result, "time", info[1], 30); printf( "Conectare: Nume: Rimmon IP: %s la data de: %s", info[0], info[1] ); db_next_row(Result); } db_num_fields(DBResult:dbresult); - numarul de domenii din rezultatEx: new name[30]; format(Query,sizeof(query),"SELECT `pass`,`kills`,`deaths`,`level`,`score` FROM `Users` WHERE `Name` = '%s'", GetPlayerName(playerid,name,30)); result = db_query(Database,Query); format(string,sizeof(string),"Ai selectat %d de fisiere", db_num_fields(result)); SendClientMessage(playerid,0xAFAFAFAA,string); db_free_result(result); db_get_field_assoc(DBResult:dbresult,const field[],result[],maxlenght); - Ex: new Filed[30]; db_get_field_assoc(result,"Level",Field,30); PlayerInfo[playerid][Level] = strval(Field); Mai sunt 2 functii,doar ca nu le stiu explicatia ..pentru ca eu nu le-am folosit niciodata Quote Massari e curva mea Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.