Guest User

LoadBiz()

a guest
Jul 3rd, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.39 KB | None | 0 0
  1. public LoadBizz()
  2. {
  3. new PropertyString[256], result[100],index = 0;
  4. mysql_query(SQL,"SELECT * FROM `bizz` ORDER BY `bizz`.`ID` ASC");
  5. mysql_store_result();
  6. while(mysql_retrieve_row())
  7. {
  8. bussines++;
  9. index++;
  10. new i = index;
  11. mysql_get_field("ID", result); BizzInfo[i][bID] = strval(result);
  12. mysql_get_field("Owned", result); BizzInfo[i][bOwned] = strval(result);
  13. mysql_get_field("Owner", result); strmid(BizzInfo[i][bOwner], result, 0, 32, 32);
  14. mysql_get_field("Message", result); strmid(BizzInfo[i][bMessage], result, 0, 100, 100);
  15. mysql_get_field("EntranceX", result); BizzInfo[i][bEntranceX] = floatstr(result);
  16. mysql_get_field("EntranceY", result); BizzInfo[i][bEntranceY] = floatstr(result);
  17. mysql_get_field("EntranceZ", result); BizzInfo[i][bEntranceZ] = floatstr(result);
  18. mysql_get_field("ExitX", result); BizzInfo[i][bExitX] = floatstr(result);
  19. mysql_get_field("ExitY", result); BizzInfo[i][bExitY] = floatstr(result);
  20. mysql_get_field("ExitZ", result); BizzInfo[i][bExitZ] = floatstr(result);
  21. mysql_get_field("LevelNeeded", result); BizzInfo[i][bLevelNeeded] = strval(result);
  22. mysql_get_field("BuyPrice", result); BizzInfo[i][bBuyPrice] = strval(result);
  23. mysql_get_field("EntranceCost", result); BizzInfo[i][bEntranceCost] = strval(result);
  24. mysql_get_field("Till", result); BizzInfo[i][bTill] = strval(result);
  25. mysql_get_field("Locked", result); BizzInfo[i][bLocked] = strval(result);
  26. mysql_get_field("Interior", result); BizzInfo[i][bInterior] = strval(result);
  27. mysql_get_field("Products", result); BizzInfo[i][bProducts] = strval(result);
  28. mysql_get_field("MaxProducts", result); BizzInfo[i][bMaxProducts] = strval(result);
  29. mysql_get_field("PriceProd", result); BizzInfo[i][bPriceProd] = strval(result);
  30. mysql_get_field("Virtual", result); BizzInfo[i][bVirtual] = strval(result);
  31. if(BizzInfo[i][bOwned] == 0)
  32. {
  33. DestroyDynamic3DTextLabel(BizzLabel[i]);
  34. format(PropertyString, sizeof(PropertyString),"{357AB7}%s \n{FFFFFF}Business {357AB7}#%d \n{357AB7}This Business is for sale(/buybiz) ! \n {FFFFFF}Price: {357AB7}%s \n{FFFFFF}Level: {357AB7}%d",BizzInfo[i][bMessage],i,FormatNumber(BizzInfo[i][bBuyPrice]),BizzInfo[i][bLevelNeeded]);
  35. BizzLabel[i] = CreateDynamic3DTextLabel(PropertyString ,0x0066FFFF,BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0);
  36. CreateDynamicPickup(1239, 1, BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ]);
  37. pickups++;
  38. }
  39. else if(BizzInfo[i][bOwned] == 1)
  40. {
  41. DestroyDynamic3DTextLabel(BizzLabel[i]);
  42. format(PropertyString, sizeof(PropertyString),"{357AB7}%s \n{FFFFFF}Business {357AB7}#%d \n{FFFFFF}Owner: {357AB7}%s \n{FFFFFF}Fee: {357AB7}$%s",BizzInfo[i][bMessage],i,BizzInfo[i][bOwner],FormatNumber(BizzInfo[i][bEntranceCost]));
  43. BizzLabel[i] = CreateDynamic3DTextLabel(PropertyString ,0x0066FFFF,BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0);
  44. CreateDynamicPickup(1239, 1, BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ]);
  45. pickups++;
  46. }
  47. }
  48. mysql_free_result();
  49. printf("Bussines: %d", index);
  50. return 1;
  51. }
Add Comment
Please, Sign In to add comment