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

Threaded Mode
MySQL R40 Problem
Kraeror
Gangsta
****
Posts: 536
Threads: 81
Joined: Mar 2017
Reputation: 0
#1

03.01.2018, 18:55
Help me pls!
I'm still learning this MySQL!
Here is my connection:
PHP Code:
sqlll = mysql_connect("127.0.0.1", "root", "", "sa-mp"); 
Here is my code:
PHP Code:
new query[256];
    format(query, sizeof(query), "INSERT INTO `houses`(`ID`, `Owner`, `Price`, `X`, `Y`, `Z`, `World`, `X2`, `Y2`, `Z2`, `A2`, `Int:X`, `Int:Y`, `Int:Z`, `Int:X2`, `Int:Y2`, `Int:Z2`, `Int:A2`, `Interior`, `Spawn:X`, `Spawn:Y`, `Spawn:Z`, `Spawn:A`, `Status`) VALUES (%d, %s, %d, %f, %f, %f, %d, %f, %f, %f, %f, %f, %f, %f, %f, %f, %f, %f, %d, %f, %f, %f, %f, %d)",
    h, HouseInfo[h][hOwner], HouseInfo[h][hPrice], HouseInfo[h][hX], HouseInfo[hY], HouseInfo[h][hZ]);
    mysql_query(sqlll, query); 
So the connection is tested and it works, but why there is nothing when I insert this values?
What I have to do before inserting this values? Please help me, +1 REP!
Find
Reply
VincenzoDrift
Little Clucker
**
Posts: 47
Threads: 12
Joined: Jun 2014
Reputation: 0
#2

03.01.2018, 19:02
Try with this query:
Code:
"INSERT INTO `houses`(`ID`, `Owner`, `Price`, `X`, `Y`, `Z`, `World`, `X2`, `Y2`, `Z2`, `A2`, `Int:X`, `Int:Y`, `Int:Z`, `Int:X2`, `Int:Y2`, `Int:Z2`, `Int:A2`, `Interior`, `Spawn:X`, `Spawn:Y`, `Spawn:Z`, `Spawn:A`, `Status`) VALUES ('%d', '%s', '%d', '%f', '%f', '%f', '%d', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%d', '%f', '%f', '%f', '%f', '%d')"
I have inserted ' ' between format specifiers %d, %s, ecc...
Find
Reply
Kraeror
Gangsta
****
Posts: 536
Threads: 81
Joined: Mar 2017
Reputation: 0
#3

03.01.2018, 19:05
Quote:
Originally Posted by VincenzoDrift
View Post
Try with this query:
Code:
"INSERT INTO `houses`(`ID`, `Owner`, `Price`, `X`, `Y`, `Z`, `World`, `X2`, `Y2`, `Z2`, `A2`, `Int:X`, `Int:Y`, `Int:Z`, `Int:X2`, `Int:Y2`, `Int:Z2`, `Int:A2`, `Interior`, `Spawn:X`, `Spawn:Y`, `Spawn:Z`, `Spawn:A`, `Status`) VALUES ('%d', '%s', '%d', '%f', '%f', '%f', '%d', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%d', '%f', '%f', '%f', '%f', '%d')"
I have inserted ' ' between format specifiers %d, %s, ecc...
There is no changes in the database
Find
Reply
VincenzoDrift
Little Clucker
**
Posts: 47
Threads: 12
Joined: Jun 2014
Reputation: 0
#4

03.01.2018, 19:09
Ah your query string dimension is low.
Code:
new query[512];
Find
Reply
Kraeror
Gangsta
****
Posts: 536
Threads: 81
Joined: Mar 2017
Reputation: 0
#5

03.01.2018, 19:13
Quote:
Originally Posted by VincenzoDrift
View Post
Ah your query string dimension is low.
Code:
new query[512];
Thanks for this! + 1 REP
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!REALY THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Find
Reply
Logic_
Banned
Posts: 1,506
Threads: 13
Joined: Jun 2015
#6

03.01.2018, 20:02
You should always escape strings and use threaded queries because they are faster and safer than non-threaded queries. Just %e to escape strings instead of %s and use mysql_tquery function instead of mysql_query. You can also use mysql_pquery if you just want to put data into the database etc.
Find
Reply
DRIFT_HUNTER
High-roller
*****
Posts: 2,203
Threads: 154
Joined: Oct 2009
Reputation: 0
#7

03.01.2018, 20:22
I guess you fixed it, but keep in mind, your format function expects allot more variables then you actually provide, also you should use mysql_format for running queries instead of format.
Find
Reply
Kraeror
Gangsta
****
Posts: 536
Threads: 81
Joined: Mar 2017
Reputation: 0
#8

04.01.2018, 17:59
Thank you guys, but there are more problems
Look: (the varibable h is used for house ID)
PHP Code:
new h; cache_get_row_count(h);
new query[2048];
mysql_format(zMySQL, query, sizeof(query), "INSERT INTO `houses`(`ID`, `Owner`, `Price`, `X`, `Y`, `Z`, `World`, `X2`, `Y2`, `Z2`, `A2`, `Int:X`, `Int:Y`, `Int:Z`, `Int:X2`, `Int:Y2`, `Int:Z2`, `Int:A2`, `Interior`, `Spawn:X`, `Spawn:Y`, `Spawn:Z`, `Spawn:A`, `Status`) VALUES ('%d', '%e', '%d', '%f', '%f', '%f', '%d', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%d', '%f', '%f', '%f', '%f', '%d')",
h, HouseInfo[h][hOwner], HouseInfo[h][hPrice], HouseInfo[h][hX], HouseInfo[hY], HouseInfo[h][hZ], -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
mysql_tquery(zMySQL, query); 
Output: X: 151.123201, Y: 0, Z: 13.05541 and etc.
And it can't be loaded
Here is loading(OnGameModeInit callback):
PHP Code:
for(new h = 1; h < MAX_HOUSES; h++)
    {
        new house[64], query[1024];
        mysql_format(zMySQL, query, sizeof(query), "SELECT * FROM `houses` WHERE `ID` = %d", h);
          mysql_tquery(zMySQL, query, "LoadHouses", "h");
        if(strcmp(HouseInfo[h][hOwner], "No", true) == 0)
        {
            HouseInfo[h][hPickup] = CreatePickup(1273, 1, HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ]);
            HouseInfo[h][hIcon] = CreateDynamicMapIcon(HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ], 31, 0,0,0);
        }
        else
        {
            HouseInfo[h][hPickup] = CreatePickup(19522, 1, HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ]);
            HouseInfo[h][hIcon] = CreateDynamicMapIcon(HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ], 32, 0,0,0);
        }
    } 
and here is my LoadHouses callback:
PHP Code:
forward LoadHouses(houseid);
public LoadHouses(houseid)
{
    cache_get_value_name(houseid, "Owner", HouseInfo[houseid][hOwner]);
    cache_get_value_name_float(houseid, "X", HouseInfo[houseid][hX]);
    cache_get_value_name_float(houseid, "Y", HouseInfo[houseid][hY]);
    cache_get_value_name_float(houseid, "Z", HouseInfo[houseid][hZ]);
    cache_get_value_name_float(houseid, "Int:X", HouseInfo[houseid][hiX]);
    cache_get_value_name_float(houseid, "Int:Y", HouseInfo[houseid][hiY]);
    cache_get_value_name_float(houseid, "Int:Z", HouseInfo[houseid][hiZ]);
    cache_get_value_name_float(houseid, "X2", HouseInfo[houseid][hX2]);
    cache_get_value_name_float(houseid, "Y2", HouseInfo[houseid][hY2]);
    cache_get_value_name_float(houseid, "Z2", HouseInfo[houseid][hZ2]);
    cache_get_value_name_float(houseid, "A2", HouseInfo[houseid][hA2]);
    cache_get_value_name_float(houseid, "Int:X2", HouseInfo[houseid][hiX2]);
    cache_get_value_name_float(houseid, "Int:Y2", HouseInfo[houseid][hiY2]);
    cache_get_value_name_float(houseid, "Int:Z2", HouseInfo[houseid][hiZ2]);
    cache_get_value_name_float(houseid, "Int:A2", HouseInfo[houseid][hiA2]);
    cache_get_value_name_float(houseid, "Spawn:X", HouseInfo[houseid][hsX]);
    cache_get_value_name_float(houseid, "Spawn:Y", HouseInfo[houseid][hsY]);
    cache_get_value_name_float(houseid, "Spawn:Z", HouseInfo[houseid][hsZ]);
     cache_get_value_name_float(houseid, "Spawn:A", HouseInfo[houseid][hsA]);
    cache_get_value_name_int(houseid, "Interior", HouseInfo[houseid][hInt]);
    cache_get_value_name_int(houseid, "World", HouseInfo[houseid][hVW]);
    cache_get_value_name_int(houseid, "Price", HouseInfo[houseid][hPrice]);
    cache_get_value_name_int(houseid, "Status", HouseInfo[houseid][hStatus]);
    return 1;
} 
Find
Reply
Kraeror
Gangsta
****
Posts: 536
Threads: 81
Joined: Mar 2017
Reputation: 0
#9

04.01.2018, 19:48
Any help 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