Advertisement
Guest User

Saave Biz

a guest
Jul 3rd, 2017
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.81 KB | None | 0 0
  1. stock bizz_Save(id)
  2. {
  3. new esc_owner[64], message[64];
  4. mysql_escape_string(bizz[id][owner], esc_owner);
  5. mysql_escape_string(bizz[id][description], message);
  6. MySQLCheckConnexion();
  7. format(sql,sizeof(sql),"UPDATE bizz SET Created=%d, Owned=%d, Pos_x=%f, Pos_y=%f, Pos_z=%f, Exit_x=%f, Exit_y=%f, Exit_z=%f, Owner='%s', Message='%s', Caisse=%d, EnterPrice=%d, Price=%d, ProdPrice=%d, Locked=%d, Interior=%d, Type=%d, Prods=%d, ProdsMax=%d, WV=%d, Varia=%d WHERE id=%d",
  8. bizz[id][used],
  9. bizz[id][owned],
  10. bizz[id][pos][0],
  11. bizz[id][pos][1],
  12. bizz[id][pos][2],
  13. bizz[id][pos][3],
  14. bizz[id][pos][4],
  15. bizz[id][pos][5],
  16. esc_owner,
  17. message,
  18. bizz[id][fund],
  19. bizz[id][enterCost],
  20. bizz[id][price],
  21. bizz[id][prodCost],
  22. bizz[id][lock],
  23. bizz[id][interior],
  24. bizz[id][typeZ],
  25. bizz[id][products],
  26. bizz[id][prodMax],
  27. bizz[id][world],
  28. bizz[id][variable],
  29. id+1);
  30. mysql_pquery(MYSQL,sql);
  31.  
  32. MySQLCheckConnexion();
  33. format(sql,sizeof(sql),"UPDATE bizz SET Art1=%d, Art2=%d, Art3=%d, Art4=%d, Art5=%d, Art6=%d, Art7=%d, Art8=%d, Art9=%d, Art10=%d, Art11=%d, Art12=%d, Art13=%d, Art14=%d, Art15=%d, Art16=%d, Art17=%d, Art18=%d, Art19=%d, Art20=%d WHERE id=%d",
  34. bizz[id][itemCost][0],
  35. bizz[id][itemCost][1],
  36. bizz[id][itemCost][2],
  37. bizz[id][itemCost][3],
  38. bizz[id][itemCost][4],
  39. bizz[id][itemCost][5],
  40. bizz[id][itemCost][6],
  41. bizz[id][itemCost][7],
  42. bizz[id][itemCost][8],
  43. bizz[id][itemCost][9],
  44. bizz[id][itemCost][10],
  45. bizz[id][itemCost][11],
  46. bizz[id][itemCost][12],
  47. bizz[id][itemCost][13],
  48. bizz[id][itemCost][14],
  49. bizz[id][itemCost][15],
  50. bizz[id][itemCost][16],
  51. bizz[id][itemCost][17],
  52. bizz[id][itemCost][18],
  53. bizz[id][itemCost][19],
  54. id+1);
  55. mysql_pquery(MYSQL,sql);
  56. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement