Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2017
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 2.65 KB | None | 0 0
  1. stock bizz_Save(id,bool:saveSafe=false)
  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 lvrp_server_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 lvrp_server_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.    
  57.     if(saveSafe == true)
  58.     {
  59.         format(sql,sizeof(sql),"UPDATE lvrp_server_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",
  60.         bizz[id][itemCost][0],bizz[id][itemCost][1],bizz[id][itemCost][2],bizz[id][itemCost][3],bizz[id][itemCost][4],bizz[id][itemCost][5],bizz[id][itemCost][6],bizz[id][itemCost][7],
  61.         bizz[id][itemCost][8],bizz[id][itemCost][9],bizz[id][itemCost][10],bizz[id][itemCost][11],bizz[id][itemCost][12],bizz[id][itemCost][13],bizz[id][itemCost][14],bizz[id][itemCost][15],
  62.         bizz[id][itemCost][16],bizz[id][itemCost][17],bizz[id][itemCost][18],bizz[id][itemCost][19],id+1);
  63.         mysql_pquery(MYSQL,sql);
  64.     }
  65. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement