Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public LoadRaces()
- {
- new szString[100],
- DBResult:ResultQuery,
- bool:races,
- bool:cps;
- format(szString, sizeof szString, "SELECT * FROM Races");
- ResultQuery = db_query(DataBase, szString);
- if(db_num_rows(ResultQuery))
- {
- races = true;
- for(new i = 0; i < db_num_rows(ResultQuery); i++)
- {
- new raceid = SQLiteGetResultIntAssoc(ResultQuery, "ID");
- db_get_field_assoc(ResultQuery, "Name", RaceInfo[raceid][RaceName], 50);
- RaceInfo[raceid][RaceType] = SQLiteGetResultIntAssoc(ResultQuery, "Type");
- RaceInfo[raceid][RaceReward] = SQLiteGetResultIntAssoc(ResultQuery, "Reward");
- RaceInfo[raceid][RaceExist] = true;
- RaceInfo[raceid][RaceOpen] = false;
- if(!db_next_row(ResultQuery))
- break;
- }
- }
- else print("SQLite INFO! (LoadRaces: Races) não há veículos inseridos no banco de dados.");
- format(szString, sizeof szString, "SELECT * FROM CheckPoints");
- ResultQuery = db_query(DataBase, szString);
- if(db_num_rows(ResultQuery))
- {
- cps = true;
- for(new i = 0; i < db_num_rows(ResultQuery); i++)
- {
- new raceid, count;
- raceid = SQLiteGetResultIntAssoc(ResultQuery, "ID");
- count = SQLiteGetResultIntAssoc(ResultQuery, "Count");
- db_get_field_assoc(ResultQuery, "CPs", RaceCPPos[raceid][count], 100);
- db_get_field_assoc(ResultQuery, "STs", RaceSTPos[raceid][count], 100);
- if(!db_next_row(ResultQuery))
- break;
- }
- }
- else print("SQLite INFO! (LoadRaces: CheckPoints) não há veículos inseridos no banco de dados.");
- if(races && !cps)
- print("SQLite WARNING! (LoadRaces) há corridas inseridas na tabela Races, mas não há checkpoins na tabela Checkpoints.");
- else if(!races && cps)
- print("SQLite WARNING! (LoadRaces) não há corridas inseridas na tabela Races, mas há checkpoins na tabela Checkpoints.");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement