JeffryUGP

PropertyStoring_all

Jul 10th, 2013
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 1.21 KB | None | 0 0
  1. forward PropertyStoring_all(tmp);
  2. public PropertyStoring_all(tmp)
  3. {
  4.     printf("PropertyStoring_all started (%d).", tmp);
  5.     new t_y = GetTickCount();
  6.     new query[2048];
  7.     format(query,sizeof(query),"SELECT * FROM `props` WHERE id > '0'");
  8.     mysql_query(query);
  9.     mysql_store_result();
  10.     for(new id=tmp*MAX_PROPERTIES/10; id<((tmp*MAX_PROPERTIES/10)+MAX_PROPERTIES/10); id++)
  11.     {
  12.         new a = random(10);
  13.         if(!a)
  14.         {
  15.             // SAVE STATS HERE
  16.             format(query,sizeof(query),"UPDATE `props` SET `name` = '-1', `price` = '-1', `sell` = '-1', `earning` = '-1', `owner` = '-1', `ownedsince` = '-1' WHERE `id` = '%d'",id+1);
  17.             mysql_query(query);
  18.             mysql_free_result();
  19.             continue;
  20.         }
  21.         new time = random(10000);
  22.         format(query,sizeof(query),"UPDATE `props` SET `name` = '%s', `price` = '%d', `sell` = '%d', `earning` = '%d', `owner` = '%s', `ownedsince` = '%d' WHERE `id` = '%d'","PropName",10000,5001,500,"Owner",time,id+1);
  23.         mysql_query(query);
  24.     }
  25.     mysql_free_result();
  26.  
  27.     SetTimerEx("PropertyStoring_all", 60000, 0, "d", tmp);
  28.     if(GetTickCount() - t_y > 1000) printf("PropertyStoring_all: Finished (%d ms)", GetTickCount() - t_y);
  29.     printf("PropertyStoring_all finished (%d).", tmp);
  30.     return 1;
  31. }
Advertisement
Add Comment
Please, Sign In to add comment