Advertisement
RogerGomesCosta

Untitled

Jul 23rd, 2014
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C 1.84 KB | None | 0 0
  1. public LoadRaces()
  2. {
  3.     new szString[100],
  4.     DBResult:ResultQuery,
  5.     bool:races,
  6.     bool:cps;
  7.  
  8.     format(szString, sizeof szString, "SELECT * FROM Races");
  9.     ResultQuery = db_query(DataBase, szString);
  10.     if(db_num_rows(ResultQuery))
  11.     {
  12.     races = true;
  13.     for(new i = 0; i < db_num_rows(ResultQuery); i++)
  14.     {
  15.         new raceid = SQLiteGetResultIntAssoc(ResultQuery, "ID");
  16.         db_get_field_assoc(ResultQuery, "Name", RaceInfo[raceid][RaceName], 50);
  17.         RaceInfo[raceid][RaceType] = SQLiteGetResultIntAssoc(ResultQuery, "Type");
  18.         RaceInfo[raceid][RaceReward] = SQLiteGetResultIntAssoc(ResultQuery, "Reward");
  19.  
  20.         RaceInfo[raceid][RaceExist] = true;
  21.         RaceInfo[raceid][RaceOpen] = false;
  22.         if(!db_next_row(ResultQuery))
  23.         break;
  24.     }
  25.     }
  26.     else print("SQLite INFO! (LoadRaces: Races) não há veículos inseridos no banco de dados.");
  27.  
  28.     format(szString, sizeof szString, "SELECT * FROM CheckPoints");
  29.     ResultQuery = db_query(DataBase, szString);
  30.     if(db_num_rows(ResultQuery))
  31.     {
  32.     cps = true;
  33.     for(new i = 0; i < db_num_rows(ResultQuery); i++)
  34.     {
  35.         new raceid, count;
  36.         raceid = SQLiteGetResultIntAssoc(ResultQuery, "ID");
  37.         count = SQLiteGetResultIntAssoc(ResultQuery, "Count");
  38.         db_get_field_assoc(ResultQuery, "CPs", RaceCPPos[raceid][count], 100);
  39.         db_get_field_assoc(ResultQuery, "STs", RaceSTPos[raceid][count], 100);
  40.         if(!db_next_row(ResultQuery))
  41.         break;
  42.     }
  43.     }
  44.     else print("SQLite INFO! (LoadRaces: CheckPoints) não há veículos inseridos no banco de dados.");
  45.    
  46.     if(races && !cps)
  47.     print("SQLite WARNING! (LoadRaces) há corridas inseridas na tabela Races, mas não há checkpoins na tabela Checkpoints.");
  48.     else if(!races && cps)
  49.     print("SQLite WARNING! (LoadRaces) não há corridas inseridas na tabela Races, mas há checkpoins na tabela Checkpoints.");
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement