Guest User

Untitled

a guest
Sep 29th, 2014
373
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 2.62 KB | None | 0 0
  1. enum house
  2. {
  3.     HID,
  4.     Float:EnterX,
  5.     Float:EnterY,
  6.     Float:EnterZ,
  7.     Float:ExitX,
  8.     Float:ExitY,
  9.     Float:ExitZ,
  10.     HouseName[48],
  11.     Owner[32],
  12.     Price,
  13.     Level,
  14.     IntID,
  15.     Lock,
  16.     Premium,
  17.     Icon,
  18.     Text3D:DLabel,
  19.     PickupU,
  20.     Venda,
  21.     WID
  22. }
  23. new House[MAX_HOUSE][house];
  24. new MySQL:connection;
  25.  
  26. public OnFilterScriptInit()
  27. {
  28.     // MY SQL CONNECT RECALL
  29.     connection = mysql_init(LOG_ONLY_ERRORS, 1);
  30.     mysql_connect(db_host, db_user, db_pass, db_db, connection, 1);
  31.     // MY SQL CONNECT RECALL
  32.    
  33.     for(new i = 0; i <= MAX_HOUSE; i++)
  34.     {
  35.         LoadHouse_db(i);
  36.     }
  37.     return 1;
  38. }
  39. /////////////////////////////////////
  40. ////CRIAR FUNCAO DINAMICA PARA DB////
  41. /////////////////////////////////////
  42.  
  43. stock LoadHouse_db(i)
  44. {
  45.         new query[500];
  46.     new posx[10];
  47.     new posy[10];
  48.     new posz[10];
  49.     new posex[10];
  50.     new posey[10];
  51.     new posez[10];
  52.     new venda[1];
  53.     new price[9];
  54.     new level[2];
  55.     new intid[2];
  56.     new lock[2];
  57.     new premi[2];
  58.     new HIDE[3];
  59.    
  60.         format(query, sizeof(query), "SELECT * FROM house WHERE ID = %i;", i);
  61.     mysql_query(query);
  62.     mysql_store_result();
  63.    
  64.     if(mysql_num_rows() > 0)
  65.     {
  66.         mysql_fetch_field("EnterX", posx);
  67.         mysql_fetch_field("EnterY", posy);
  68.         mysql_fetch_field("EnterZ", posz);
  69.         mysql_fetch_field("ExitX", posex);
  70.         mysql_fetch_field("ExitY", posey);
  71.             mysql_fetch_field("ExitZ", posez); //    <-- Variable that is not loading
  72.  
  73.         mysql_fetch_field("Venda", venda);
  74.         mysql_fetch_field("HouseName", House[i][HouseName]);
  75.         mysql_fetch_field("Owner", House[i][Owner]);
  76.         mysql_fetch_field("Price", price);
  77.         mysql_fetch_field("AccLevel", level);
  78.         mysql_fetch_field("Interior", intid);
  79.         mysql_fetch_field("Locked", lock);
  80.         mysql_fetch_field("Premium", premi);
  81.         mysql_fetch_field("ID", HIDE);
  82.        
  83.         printf("(%i):ExitZ-String: %s",i, posez);
  84.        
  85.         House[i][HID] = strval(HIDE);
  86.         House[i][EnterX] = floatstr(posx);
  87.         House[i][EnterY] = floatstr(posy);
  88.         House[i][EnterZ] = floatstr(posz);
  89.         House[i][ExitX] = floatstr(posex);
  90.         House[i][ExitY] = floatstr(posey);
  91.         House[i][ExitZ] = floatstr(posez);
  92.         House[i][Venda] = strval(venda);
  93.         House[i][Price] = strval(price);
  94.         House[i][Level] = strval(level);
  95.         House[i][IntID] = strval(intid);
  96.         House[i][Lock] = strval(lock);
  97.         House[i][Premium] = strval(premi);
  98.        
  99.         House[i][WID] = strval(HIDE);
  100.        
  101.         printf("(%i):Float: {%f}{%f}{%f}(Venda:%i)", i, floatstr(posex), floatstr(posey), House[i][ExitZ], House[i][Venda]);
  102.         mysql_free_result();
  103.         return 1;
  104.     }
  105.     else
  106.     {
  107.         mysql_free_result();
  108.         return 0;
  109.     }
  110. }
Advertisement
Add Comment
Please, Sign In to add comment