1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Mysql Loading Help ! [+rep]
MoemenWalid
Little Clucker
**
Posts: 32
Threads: 12
Joined: Nov 2012
Reputation: 0
#1

12.03.2015, 15:38
Okay i have just made a simple system from the mailbox one , i made atm system all u do[/createatm-/removeatm]

and they work fine and if anyone /awithdraw and /adeposit besides it , it work but my main proplem that its saves fine in mysql database but it doesnt load.

PHP Code:
forward OnLoadATMS();
public OnLoadATMS()
{
    new string[512], i;
    new rows, fields;
    cache_get_data(rows, fields, MainPipeline);
    while(i<rows)
    {
        for(new field;field<fields;field++)
        {
             cache_get_row(i, field, string, MainPipeline);
            switch(field)
            {
                case 1: ATM[i][atmVW] = strval(string);
                case 2: ATM[i][atmInt] = strval(string);
                case 3: ATM[i][atmModelz] = strval(string);
                case 4: ATM[i][atmPosX] = floatstr(string);
                case 5: ATM[i][atmPosY] = floatstr(string);
                case 6: ATM[i][atmPosZ] = floatstr(string);
                case 7: ATM[i][atmAngle] = floatstr(string);
            }
        }
        RenderATM(i);
          i++;
     }
    if(i > 0) printf("[LoadATMS] %d atms rehashed/loaded.", i);
    else printf("[LoadATMS] Failed to load any atms.");
    return 1;
} 
I 've used this ^ ^ ^ ^ but it didn't work then i used this

PHP Code:
forward OnLoadATMS();
public OnLoadATMS()
{
    new i, rows, fields, tmp[128];
    cache_get_data(rows, fields, MainPipeline);
    while(i < rows)
    {
        cache_get_field_content(i, "VW", tmp, MainPipeline); ATM[i][atmVW] = strval(tmp);
        cache_get_field_content(i, "Int", tmp, MainPipeline); ATM[i][atmInt] = strval(tmp);
        cache_get_field_content(i, "Modelz", tmp, MainPipeline); ATM[i][atmModelz] = strval(tmp);
        cache_get_field_content(i, "PosX", tmp, MainPipeline); ATM[i][atmPosX] = floatstr(tmp);
        cache_get_field_content(i, "PosY", tmp, MainPipeline); ATM[i][atmPosY] = floatstr(tmp);
        cache_get_field_content(i, "PosZ", tmp, MainPipeline); ATM[i][atmPosZ] = floatstr(tmp);
        cache_get_field_content(i, "Angle", tmp, MainPipeline); ATM[i][atmAngle] = floatstr(tmp);
    }
        RenderATM(i);
          i++;
    if(i > 0) printf("[LoadATMS] %d houses rehashed/loaded.", i);
    else printf("[LoadATMS] Failed to load any houses.");
} 
But it also doesnt work i got no idea why it doesnt work


[Functions]

PHP Code:
stock SaveATM(id)
{
    new string[512];
    format(string, sizeof(string), "UPDATE `atms` SET \
        `VW`=%d, \
        `Int`=%d, \
        `Modelz`=%d, \
        `PosX`=%f, \
        `PosY`=%f, \
        `PosZ`=%f, \
        `Angle`=%f WHERE `id`=%d",
        ATM[id][atmVW],
        ATM[id][atmInt],
        ATM[id][atmModelz],
        ATM[id][atmPosX],
        ATM[id][atmPosY],
        ATM[id][atmPosZ],
        ATM[id][atmAngle],
        id+1
    ); // Array starts from zero, MySQL starts at 1 (this is why we are adding one).
    mysql_function_query(MainPipeline, string, false, "OnQueryFinish", "i", SENDDATA_THREAD);
} 
also
PHP Code:
stock RenderATM(id)
{
    DestroyDynamicObject(ATM[id][atmObjectId]);
    DestroyDynamic3DTextLabel(ATM[id][atmTextId]);
    if(ATM[id][atmPosX] != 0.0)
    {
        new string[128];
        ATM[id][atmObjectId] = CreateDynamicObject(2942, ATM[id][atmPosX], ATM[id][atmPosY], ATM[id][atmPosZ], 0.0, 0.0, ATM[id][atmAngle], ATM[id][atmVW], ATM[id][atmInt], .streamdistance = 100.0);
        format(string,sizeof(string),"ATM (ID: %d)\nType /awithdraw or /adeposit to transfer cash.", id);
        ATM[id][atmTextId] = CreateDynamic3DTextLabel(string, COLOR_YELLOW, ATM[id][atmPosX], ATM[id][atmPosY], ATM[id][atmPosZ] + 0.5, 10.0, .worldid = ATM[id][atmVW], .testlos = 0, .streamdistance = 25.0);
    }
} 
and the enums

PHP Code:
enum atmInfo
{
    atmVW,
    atmInt,
    atmModelz,
    Float: atmPosX,
    Float: atmPosY,
    Float: atmPosZ,
    Float: atmAngle,
    atmObjectId,
    Text3D: atmTextId
} 
Please HELP!! it doesnt load and when it saves it saves everything except "Modelz" modelz keeps 0 but i can set it easily.
Find
Reply
Golimad
Huge Clucker
****
Posts: 253
Threads: 17
Joined: Jan 2014
Reputation: 0
#2

12.03.2015, 15:44
What I think :

- You don't need Mysql for these kind of things, MySql is good for accounts and similar things, because it's fast and safe, but SQL is hard to manipulate, because it's not an include / plugin, it's a language. So, I'd say check out y_ini / djson / ..., good for loading and saving similar data.
Find
Reply
MoemenWalid
Little Clucker
**
Posts: 32
Threads: 12
Joined: Nov 2012
Reputation: 0
#3

12.03.2015, 15:54
Okay then , can you do me a favor and do the y_ini saving and loading with those enums please?

atmposx atmposz atmposy atmmodelz atmangle atmVW atmInt
Find
Reply
Misiur
High-roller
*****
Posts: 2,528
Threads: 124
Joined: Jul 2009
Reputation: 0
#4

12.03.2015, 15:58
Well, if you want to manage atm's from let's say website, sql is a good choice (though it's not impossible with files, but a little inconvinient).

pawn Code:
while(i < rows) 
    { 
        cache_get_field_content(i, "VW", tmp, MainPipeline); ATM[i][atmVW] = strval(tmp); 
        cache_get_field_content(i, "Int", tmp, MainPipeline); ATM[i][atmInt] = strval(tmp); 
        cache_get_field_content(i, "Modelz", tmp, MainPipeline); ATM[i][atmModelz] = strval(tmp); 
        cache_get_field_content(i, "PosX", tmp, MainPipeline); ATM[i][atmPosX] = floatstr(tmp); 
        cache_get_field_content(i, "PosY", tmp, MainPipeline); ATM[i][atmPosY] = floatstr(tmp); 
        cache_get_field_content(i, "PosZ", tmp, MainPipeline); ATM[i][atmPosZ] = floatstr(tmp); 
        cache_get_field_content(i, "Angle", tmp, MainPipeline); ATM[i][atmAngle] = floatstr(tmp); 
    } 
        RenderATM(i); 
          i++;
Put i++ and RenderATM inside the while, should work then.
Find
Reply
CuervO
High-roller
*****
Posts: 1,164
Threads: 20
Joined: Oct 2008
Reputation: 0
#5

12.03.2015, 16:23
Also why aren't you using the natives cache_get_field_content_int() and cache_get_field_content_float()
Find
Reply
MoemenWalid
Little Clucker
**
Posts: 32
Threads: 12
Joined: Nov 2012
Reputation: 0
#6

12.03.2015, 16:24
[QUOTE=Misiur;3400729]Well, if you want to manage atm's from let's say website, sql is a good choice (though it's not impossible with files, but a little inconvinient).

pawn Code:
while(i < rows) 
    { 
        cache_get_field_content(i, "VW", tmp, MainPipeline); ATM[i][atmVW] = strval(tmp); 
        cache_get_field_content(i, "Int", tmp, MainPipeline); ATM[i][atmInt] = strval(tmp); 
        cache_get_field_content(i, "Modelz", tmp, MainPipeline); ATM[i][atmModelz] = strval(tmp); 
        cache_get_field_content(i, "PosX", tmp, MainPipeline); ATM[i][atmPosX] = floatstr(tmp); 
        cache_get_field_content(i, "PosY", tmp, MainPipeline); ATM[i][atmPosY] = floatstr(tmp); 
        cache_get_field_content(i, "PosZ", tmp, MainPipeline); ATM[i][atmPosZ] = floatstr(tmp); 
        cache_get_field_content(i, "Angle", tmp, MainPipeline); ATM[i][atmAngle] = floatstr(tmp); 
    } 
        RenderATM(i); 
          i++;
I've made it , it compilied with 0 warns and everything looks fine but when i restart the server i didn't see any atm and i did /gotoatm and it said
PHP Code:
    if(ATM[id][atmPosX] == 0.0) {
        return SendClientMessageEx(playerid, COLOR_GRAD2, "No atms found with that ID."); 
and i refreashed the mysql and the pos.. changed when i /createatm that means that its saving fine but the loading is destroyed.

Loading ..

PHP Code:
stock LoadATMS()
{
    printf("[LoadAtms] Loading data from database...");
    mysql_function_query(MainPipeline, "SELECT * FROM `atms`", true, "OnLoadAtms", "");
} 
AND onloadatms

PHP Code:
forward OnLoadATMS();
public OnLoadATMS()
{
    new i, rows, fields, tmp[128];
    cache_get_data(rows, fields, MainPipeline);
    while(i < rows)
    {
        cache_get_field_content(i, "VW", tmp, MainPipeline); ATM[i][atmVW] = strval(tmp);
        cache_get_field_content(i, "Int", tmp, MainPipeline); ATM[i][atmInt] = strval(tmp);
        cache_get_field_content(i, "Modelz", tmp, MainPipeline); ATM[i][atmModelz] = strval(tmp);
        cache_get_field_content(i, "PosX", tmp, MainPipeline); ATM[i][atmPosX] = floatstr(tmp);
        cache_get_field_content(i, "PosY", tmp, MainPipeline); ATM[i][atmPosY] = floatstr(tmp);
        cache_get_field_content(i, "PosZ", tmp, MainPipeline); ATM[i][atmPosZ] = floatstr(tmp);
        cache_get_field_content(i, "Angle", tmp, MainPipeline); ATM[i][atmAngle] = floatstr(tmp);
        RenderATM(i);
        i++;
    }
    if(i > 0) printf("[LoadATMS] %d houses rehashed/loaded.", i);
    else printf("[LoadATMS] Failed to load any houses.");
} 
Find
Reply
Misiur
High-roller
*****
Posts: 2,528
Threads: 124
Joined: Jul 2009
Reputation: 0
#7

12.03.2015, 16:28
Do you see "[LoadATMS] X houses rehashed/loaded." in server log? Also apply what CuervO said:
pawn Code:
forward OnLoadATMS(); 
public OnLoadATMS() 
{ 
    new i, rows, fields; 
    cache_get_data(rows, fields, MainPipeline); 

    while(i < rows) 
    { 
        ATM[i][atmVW] = cache_get_field_content_int(i, "VW", MainPipeline);
        ATM[i][atmInt] = cache_get_field_content_int(i, "Int", MainPipeline);
        ATM[i][atmModelz] = cache_get_field_content_int(i, "Modelz", MainPipeline);
        ATM[i][atmPosX] = cache_get_field_content_float(i, "PosX", MainPipeline);
        ATM[i][atmPosY] = cache_get_field_content_float(i, "PosY", MainPipeline);
        ATM[i][atmPosZ] = cache_get_field_content_float(i, "PosZ", MainPipeline);
        ATM[i][atmAngle] = cache_get_field_content_float(i, "Angle", MainPipeline);
        RenderATM(i); 
        i++; 
    } 
    if(i > 0) printf("[LoadATMS] %d houses rehashed/loaded.", i); 
    else printf("[LoadATMS] Failed to load any houses."); 
}
Find
Reply
MoemenWalid
Little Clucker
**
Posts: 32
Threads: 12
Joined: Nov 2012
Reputation: 0
#8

12.03.2015, 16:43
Quote:
Originally Posted by CuervO
View Post
Also why aren't you using the natives cache_get_field_content_int() and cache_get_field_content_float()
I am not good in MySQL do u mind u changing the natives for me please?
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help