Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- enum house
- {
- HID,
- Float:EnterX,
- Float:EnterY,
- Float:EnterZ,
- Float:ExitX,
- Float:ExitY,
- Float:ExitZ,
- HouseName[48],
- Owner[32],
- Price,
- Level,
- IntID,
- Lock,
- Premium,
- Icon,
- Text3D:DLabel,
- PickupU,
- Venda,
- WID
- }
- new House[MAX_HOUSE][house];
- new MySQL:connection;
- public OnFilterScriptInit()
- {
- // MY SQL CONNECT RECALL
- connection = mysql_init(LOG_ONLY_ERRORS, 1);
- mysql_connect(db_host, db_user, db_pass, db_db, connection, 1);
- // MY SQL CONNECT RECALL
- for(new i = 0; i <= MAX_HOUSE; i++)
- {
- LoadHouse_db(i);
- }
- return 1;
- }
- /////////////////////////////////////
- ////CRIAR FUNCAO DINAMICA PARA DB////
- /////////////////////////////////////
- stock LoadHouse_db(i)
- {
- new query[500];
- new posx[10];
- new posy[10];
- new posz[10];
- new posex[10];
- new posey[10];
- new posez[10];
- new venda[1];
- new price[9];
- new level[2];
- new intid[2];
- new lock[2];
- new premi[2];
- new HIDE[3];
- format(query, sizeof(query), "SELECT * FROM house WHERE ID = %i;", i);
- mysql_query(query);
- mysql_store_result();
- if(mysql_num_rows() > 0)
- {
- mysql_fetch_field("EnterX", posx);
- mysql_fetch_field("EnterY", posy);
- mysql_fetch_field("EnterZ", posz);
- mysql_fetch_field("ExitX", posex);
- mysql_fetch_field("ExitY", posey);
- mysql_fetch_field("ExitZ", posez); // <-- Variable that is not loading
- mysql_fetch_field("Venda", venda);
- mysql_fetch_field("HouseName", House[i][HouseName]);
- mysql_fetch_field("Owner", House[i][Owner]);
- mysql_fetch_field("Price", price);
- mysql_fetch_field("AccLevel", level);
- mysql_fetch_field("Interior", intid);
- mysql_fetch_field("Locked", lock);
- mysql_fetch_field("Premium", premi);
- mysql_fetch_field("ID", HIDE);
- printf("(%i):ExitZ-String: %s",i, posez);
- House[i][HID] = strval(HIDE);
- House[i][EnterX] = floatstr(posx);
- House[i][EnterY] = floatstr(posy);
- House[i][EnterZ] = floatstr(posz);
- House[i][ExitX] = floatstr(posex);
- House[i][ExitY] = floatstr(posey);
- House[i][ExitZ] = floatstr(posez);
- House[i][Venda] = strval(venda);
- House[i][Price] = strval(price);
- House[i][Level] = strval(level);
- House[i][IntID] = strval(intid);
- House[i][Lock] = strval(lock);
- House[i][Premium] = strval(premi);
- House[i][WID] = strval(HIDE);
- printf("(%i):Float: {%f}{%f}{%f}(Venda:%i)", i, floatstr(posex), floatstr(posey), House[i][ExitZ], House[i][Venda]);
- mysql_free_result();
- return 1;
- }
- else
- {
- mysql_free_result();
- return 0;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment