MySQL Loading / Saving help - Printable Version

MySQL Loading / Saving help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Loading / Saving help (/showthread.php?tid=609951)

MySQL Loading / Saving help - ManIsHere - 18.06.2016

Hello i am making a dynamic system with MySQL. now i was wondering how do i load, save from a MySQL Database on Filterscriptinit and exit??

i uses select * from obj. do i have to just to do that? also, i want to CreateObject on the positions saved in DB.. how do i set it? also tell me how do i save all objects inside table obj when FilterScript exits

?

Thanks for help

Re: MySQL Loading / Saving help - ManIsHere - 18.06.2016

Please help me my FS is just stuck at Saving part.. others all done.. please help me..

Re: MySQL Loading / Saving help - luke49 - 18.06.2016

PHP код:



enum oInfo

{

    modelid,

    Float:X,

    Float:Y,

    Float:Z,

    Float:rX,

    Float:rY,

    Float:rZ

};


new object [ 2000 ][ oInfo ];

PHP код:



stock laodObjects(playerid)

{

    mysql_format(db, query, sizeof(query), "SELECT * FROM `objects`");

    mysql_pquery(db, query, "loadObjects", "d", sizeof(object));

}

PHP код:



forward loadObjects();

public loadObjects()

{

    new count = 0, rows, fields;

    cache_get_data(rows, fields, db);


    for(new i; i < rows; i++)

    {

        for(new o; o < sizeof(object); o++)

        {

            object[o][modelid] = cache_get_field_content_int(i, "modelid");

            object[o][X] = cache_get_field_content_float(i, "X");

            object[o][Y] = cache_get_field_content_float(i, "Y");

            object[o][Z] = cache_get_field_content_float(i, "Z");

            object[o][rX] = cache_get_field_content_float(i, "rX");

            object[o][rY] = cache_get_field_content_float(i, "rY");

            object[o][rZ] = cache_get_field_content_float(i, "rZ");


            CreateDynamicObject(object[o][modelid], object[o][X], object[o][Y], object[o][Z], object[o][rX], object[o][rY], object[o][rZ]);

            count++;

            break;

        }

    }

    printf("Loaded objects from MySQL: %d", count);

    return 1;

}

Re: MySQL Loading / Saving help - ManIsHere - 18.06.2016

Hey thanks for help mate.. Just to ask, is those "X" and "Y" and others are Names of Columns in my Table Right?
REPed you

EDIT: i am sorry but i didnt understand mysql_pquery thing.. also why did you had Stock function and Public callback both

also in FilterScriptInit, i have to use that Stock Function to load objects of Public? (i Guess its public one but still clearing doubt. then where to use stock function?)

Re: MySQL Loading / Saving help - Konstantinos - 18.06.2016

The above code will overwrite all the data on index 0 of "object" array. It will only store the data of the last row. The second loop shouldn't be used at all, only a checking about if rows are more than the size of the array to prevent run time error 4 nor "break;" which stops the loop.

You can also re-set rows to the last valid index if rows are more:

PHP код:



rows = clamp(rows, 0, sizeof object - 1);


for (new o; o < rows; o++)

{

    object[o][modelid] = cache_get_field_content_int(o, "modelid");

    object[o][X] = cache_get_field_content_float(o, "X");

    object[o][Y] = cache_get_field_content_float(o, "Y");

    object[o][Z] = cache_get_field_content_float(o, "Z");

    object[o][rX] = cache_get_field_content_float(o, "rX");

    object[o][rY] = cache_get_field_content_float(o, "rY");

    object[o][rZ] = cache_get_field_content_float(o, "rZ");


    CreateDynamicObject(object[o][modelid], object[o][X], object[o][Y], object[o][Z], object[o][rX], object[o][rY], object[o][rZ]);

}


printf("Loaded objects from MySQL: %d", rows);

Re: MySQL Loading / Saving help - WhiteGhost - 18.06.2016

Is it working?

Re: MySQL Loading / Saving help - ManIsHere - 19.06.2016

Alright thanks for helping me i will test it as soon as i reach my home.. i am on highway right now :P

Ok but i didnt understand diffrence of

PHP код:



 stock laodObjects(playerid) 
{ 
    mysql_format(db, query, sizeof(query), "SELECT * FROM `objects`"); 
    mysql_pquery(db, query, "loadObjects", "d", sizeof(object)); 
}

and Public function. and also in place of db in above stock i have to use my DB right?

Thank you to help me. you deserve +rep too.

Re: MySQL Loading / Saving help - GTLS - 19.06.2016

PHP код:



 mysql_pquery(db, query, "loadObjects", "d", sizeof(object));

https://sampwiki.blast.hk/wiki/MySQL/R33#mysql_pquery i am not into MySQL much but i guess loadobjects needs to be a public function not a stock? i may be wrong because i am learning MySQL..

Re: MySQL Loading / Saving help - luke49 - 19.06.2016

Quote:

Originally Posted by ManIsHere

Alright thanks for helping me i will test it as soon as i reach my home.. i am on highway right now :P

Ok but i didnt understand diffrence of

PHP код:



 stock laodObjects(playerid) 

{ 

    mysql_format(db, query, sizeof(query), "SELECT * FROM `objects`"); 

    mysql_pquery(db, query, "loadObjects", "d", sizeof(object)); 

}

and Public function. and also in place of db in above stock i have to use my DB right?

Thank you to help me. you deserve +rep too.

Whoops! My fault. Stock's and public's name cannot be same. That should be like that:

PHP код:



stock laodObjects(playerid) //select what you need

{ 

    mysql_format(db, query, sizeof(query), "SELECT * FROM `objects`"); 

    mysql_pquery(db, query, "loadObjects2", "d", sizeof(object)); 

}

PHP код:



forward loadObjects2(); 

public loadObjects2() //do what you need with selected stuff

{ 

    //...

}

Quote:

Originally Posted by ManIsHere

and also in place of db in above stock i have to use my DB right?

Yes, you are right.

PHP код:



db = mysql_connect(M_Host, M_User, M_Data, M_Pass);

Re: MySQL Loading / Saving help - ManIsHere - 19.06.2016

Thank you for your help. i also have same doubt as GeorgeMcReary

Код:

 How to set auto increment in Object ID? like while loading and saving?

How do i add Object IDs? also,

Код:

 rows = clamp(rows, 0, sizeof object - 1);

What is object in that line? DB, Table or just a variable? i didnt not understand that one!!