[SQLite]Functii

[Rimmon]

In acest tutorial va voi prezenta funtiile SQLite-ului

• db_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 date

Ex:

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_query

Ex:

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_query

Ex:

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 rezultat

Ex:

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