PDA

View Full Version : Set into MYSQL help


maikons
10/01/2015, 12:11 AM
Why it dont work?


format(query, sizeof(query), "INSERT INTO houses SET OutPosX = %f , OutPosY = %f, OutPosZ = %f, InPosX = %f, InPosY = %f, InPosZ = %f, ",
HouseInfo[houseid][ID], HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ], HouseInfo[houseid][InPosX], HouseInfo[houseid][InPosY], HouseInfo[houseid][InPosZ]);
format(query, sizeof(query), "%s World = %d, Price = %d, Interior = %d, Locked = %d, Dono = %s, FHQ = %d, Money = %d, Maconha = %d, Owner = %d WHERE ID = %d",
query, HouseInfo[houseid][World], HouseInfo[houseid][Price], HouseInfo[houseid][Interior], HouseInfo[houseid][Locked], HouseInfo[houseid][Dono], HouseInfo[houseid][FHQ], HouseInfo[houseid][Money], HouseInfo[houseid][Maconha], HouseInfo[houseid][Owner], HouseInfo[houseid][ID]);
mysql_pquery(ConnectMYSQL, query);










Command:

CMD:makehouse(playerid, params[]) {
if(admin[playerid] < 6) return 0;
new houseid, type;
new query[1024];
new string[80];
if(sscanf(params,"ii", houseid, type)) {
SendClientMessage(playerid, -1, "Use: /makehouse [houseid] [type]");
SendClientMessage(playerid, -1, "types: 1-pequena 2-media 3-grande 4-mansão 5-vip");
return 1;
}
switch( type ) {
case 1: { // Pequena
HouseInfo[houseid][InPosX] = 223.20;
HouseInfo[houseid][InPosY] = 1287.08;
HouseInfo[houseid][InPosZ] = 1082.14;
HouseInfo[houseid][Interior] = 1;
HouseInfo[houseid][Price] = 500000;
}
case 2: { // media
HouseInfo[houseid][InPosX] = 2365.31;
HouseInfo[houseid][InPosY] = -1135.60;
HouseInfo[houseid][InPosZ] = 1050.88;
HouseInfo[houseid][Interior] = 8;
HouseInfo[houseid][Price] = 3000000;
}
case 3: { // grande
HouseInfo[houseid][InPosX] = 446.99;
HouseInfo[houseid][InPosY] = 1397.07;
HouseInfo[houseid][InPosZ] = 1084.30;
HouseInfo[houseid][Interior] = 2;
HouseInfo[houseid][Price] = 10000000;
}
case 4: { // mansão
HouseInfo[houseid][InPosX] = 2196.85;
HouseInfo[houseid][InPosY] = -1204.25;
HouseInfo[houseid][InPosZ] = 1049.02;
HouseInfo[houseid][Interior] = 6;
HouseInfo[houseid][Price] = 100000000;

}
case 5: { // VIP
HouseInfo[houseid][InPosX] = 140.17;
HouseInfo[houseid][InPosY] = 1366.07;
HouseInfo[houseid][InPosZ] = 1083.65;
HouseInfo[houseid][Interior] = 5;
HouseInfo[houseid][Price] = 3000; // abaixo de 10000 vai ser DP
}
}
HouseInfo[houseid][Owner] = 0;
HouseInfo[houseid][FHQ] = 0;
HouseInfo[houseid][ID] = houseid;
GetPlayerPos(playerid, HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ]);

format(query, sizeof(query), "INSERT INTO houses SET OutPosX = %f , OutPosY = %f, OutPosZ = %f, InPosX = %f, InPosY = %f, InPosZ = %f, ",
HouseInfo[houseid][ID], HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ], HouseInfo[houseid][InPosX], HouseInfo[houseid][InPosY], HouseInfo[houseid][InPosZ]);
format(query, sizeof(query), "%s World = %d, Price = %d, Interior = %d, Locked = %d, Dono = %s, FHQ = %d, Money = %d, Maconha = %d, Owner = %d WHERE ID = %d",
query, HouseInfo[houseid][World], HouseInfo[houseid][Price], HouseInfo[houseid][Interior], HouseInfo[houseid][Locked], HouseInfo[houseid][Dono], HouseInfo[houseid][FHQ], HouseInfo[houseid][Money], HouseInfo[houseid][Maconha], HouseInfo[houseid][Owner], HouseInfo[houseid][ID]);
mysql_pquery(ConnectMYSQL, query);

format(string, sizeof(string), "%s criou uma nova casa!", PlayerName(playerid) );
SendClientMessage(playerid, COLOR_LIGHTRED, string);
RefreshHouses();
return 1;
}

bgedition
10/01/2015, 12:19 AM
change to:

format(query, sizeof(query), "INSERT INTO `houses` SET `OutPosX` = '%f' , `OutPosY` = '%f', `OutPosZ` = '%f', `InPosX` = '%f', `InPosY` = '%f', `InPosZ` = '%f', ",
HouseInfo[houseid][ID], HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ], HouseInfo[houseid][InPosX], HouseInfo[houseid][InPosY], HouseInfo[houseid][InPosZ]);
format(query, sizeof(query), "%s `World` = '%d', `Price` = '%d', `Interior` = '%d', `Locked` = '%d', `Dono` = '%s', `FHQ` = '%d', `Money` = '%d', `Maconha` = '%d', `Owner` = '%d' WHERE `ID` = `%d`",
query, HouseInfo[houseid][World], HouseInfo[houseid][Price], HouseInfo[houseid][Interior], HouseInfo[houseid][Locked], HouseInfo[houseid][Dono], HouseInfo[houseid][FHQ], HouseInfo[houseid][Money], HouseInfo[houseid][Maconha], HouseInfo[houseid][Owner], HouseInfo[houseid][ID]);
mysql_pquery(ConnectMYSQL, query);



command:

CMD:makehouse(playerid, params[]) {
if(admin[playerid] < 6) return 0;
new houseid, type;
new query[1024];
new string[80];
if(sscanf(params,"ii", houseid, type)) {
SendClientMessage(playerid, -1, "Use: /makehouse [houseid] [type]");
SendClientMessage(playerid, -1, "types: 1-pequena 2-media 3-grande 4-mansão 5-vip");
return 1;
}
switch( type ) {
case 1: { // Pequena
HouseInfo[houseid][InPosX] = 223.20;
HouseInfo[houseid][InPosY] = 1287.08;
HouseInfo[houseid][InPosZ] = 1082.14;
HouseInfo[houseid][Interior] = 1;
HouseInfo[houseid][Price] = 500000;
}
case 2: { // media
HouseInfo[houseid][InPosX] = 2365.31;
HouseInfo[houseid][InPosY] = -1135.60;
HouseInfo[houseid][InPosZ] = 1050.88;
HouseInfo[houseid][Interior] = 8;
HouseInfo[houseid][Price] = 3000000;
}
case 3: { // grande
HouseInfo[houseid][InPosX] = 446.99;
HouseInfo[houseid][InPosY] = 1397.07;
HouseInfo[houseid][InPosZ] = 1084.30;
HouseInfo[houseid][Interior] = 2;
HouseInfo[houseid][Price] = 10000000;
}
case 4: { // mansão
HouseInfo[houseid][InPosX] = 2196.85;
HouseInfo[houseid][InPosY] = -1204.25;
HouseInfo[houseid][InPosZ] = 1049.02;
HouseInfo[houseid][Interior] = 6;
HouseInfo[houseid][Price] = 100000000;

}
case 5: { // VIP
HouseInfo[houseid][InPosX] = 140.17;
HouseInfo[houseid][InPosY] = 1366.07;
HouseInfo[houseid][InPosZ] = 1083.65;
HouseInfo[houseid][Interior] = 5;
HouseInfo[houseid][Price] = 3000; // abaixo de 10000 vai ser DP
}
}
HouseInfo[houseid][Owner] = 0;
HouseInfo[houseid][FHQ] = 0;
HouseInfo[houseid][ID] = houseid;
GetPlayerPos(playerid, HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ]);

format(query, sizeof(query), "INSERT INTO `houses` SET `OutPosX` = '%f' , `OutPosY` = '%f', `OutPosZ` = '%f', `InPosX` = '%f', `InPosY` = '%f', `InPosZ` = '%f', ",
HouseInfo[houseid][ID], HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ], HouseInfo[houseid][InPosX], HouseInfo[houseid][InPosY], HouseInfo[houseid][InPosZ]);
format(query, sizeof(query), "%s `World` = '%d', `Price` = '%d', `Interior` = '%d', `Locked` = '%d', `Dono` = '%s', `FHQ` = '%d', `Money` = '%d', `Maconha` = '%d', `Owner` = '%d' WHERE `ID` = '%d'",
query, HouseInfo[houseid][World], HouseInfo[houseid][Price], HouseInfo[houseid][Interior], HouseInfo[houseid][Locked], HouseInfo[houseid][Dono], HouseInfo[houseid][FHQ], HouseInfo[houseid][Money], HouseInfo[houseid][Maconha], HouseInfo[houseid][Owner], HouseInfo[houseid][ID]);
mysql_pquery(ConnectMYSQL, query);

format(string, sizeof(string), "%s criou uma nova casa!", PlayerName(playerid) );
SendClientMessage(playerid, COLOR_LIGHTRED, string);
RefreshHouses();
return 1;
}

maikons
10/01/2015, 12:42 AM
[23:24:28] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `ID` = '1'' at line 1

Divergent
10/01/2015, 02:05 AM
Get rid of this extra command in the query inside makehouse command

InPosZ` = '%f', ",

Add the missing comma here.

"%s `World` = '%d',

maikons
10/01/2015, 02:46 AM
Get rid of this extra command in the query inside makehouse command

InPosZ` = '%f', ",

Add the missing comma here.

"%s `World` = '%d',


I need save InPos :S
///

My code have it! Look

CMD:makehouse(playerid, params[]) {
if(admin[playerid] < 6) return 0;
new houseid, type;
new query[1024];
new string[80];
if(sscanf(params,"ii", houseid, type)) {
SendClientMessage(playerid, -1, "Use: /makehouse [houseid] [type]");
SendClientMessage(playerid, -1, "types: 1-pequena 2-media 3-grande 4-mansão 5-vip");
return 1;
}
switch( type ) {
case 1: { // Pequena
HouseInfo[houseid][InPosX] = 223.20;
HouseInfo[houseid][InPosY] = 1287.08;
HouseInfo[houseid][InPosZ] = 1082.14;
HouseInfo[houseid][Interior] = 1;
HouseInfo[houseid][Price] = 500000;
}
case 2: { // media
HouseInfo[houseid][InPosX] = 2365.31;
HouseInfo[houseid][InPosY] = -1135.60;
HouseInfo[houseid][InPosZ] = 1050.88;
HouseInfo[houseid][Interior] = 8;
HouseInfo[houseid][Price] = 3000000;
}
case 3: { // grande
HouseInfo[houseid][InPosX] = 446.99;
HouseInfo[houseid][InPosY] = 1397.07;
HouseInfo[houseid][InPosZ] = 1084.30;
HouseInfo[houseid][Interior] = 2;
HouseInfo[houseid][Price] = 10000000;
}
case 4: { // mansão
HouseInfo[houseid][InPosX] = 2196.85;
HouseInfo[houseid][InPosY] = -1204.25;
HouseInfo[houseid][InPosZ] = 1049.02;
HouseInfo[houseid][Interior] = 6;
HouseInfo[houseid][Price] = 100000000;

}
case 5: { // VIP
HouseInfo[houseid][InPosX] = 140.17;
HouseInfo[houseid][InPosY] = 1366.07;
HouseInfo[houseid][InPosZ] = 1083.65;
HouseInfo[houseid][Interior] = 5;
HouseInfo[houseid][Price] = 3000; // abaixo de 10000 vai ser DP
}
}
HouseInfo[houseid][Owner] = 0;
HouseInfo[houseid][FHQ] = 0;
HouseInfo[houseid][ID] = houseid;
GetPlayerPos(playerid, HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ]);

format(query, sizeof(query), "INSERT INTO `houses` SET `OutPosX` = '%f' , `OutPosY` = '%f', `OutPosZ` = '%f', `InPosX` = '%f', `InPosY` = '%f', `InPosZ` = '%f', ",
HouseInfo[houseid][ID], HouseInfo[houseid][OutPosX], HouseInfo[houseid][OutPosY], HouseInfo[houseid][OutPosZ], HouseInfo[houseid][InPosX], HouseInfo[houseid][InPosY], HouseInfo[houseid][InPosZ]);
format(query, sizeof(query), "%s `World` = '%d', `Price` = '%d', `Interior` = '%d', `Locked` = '%d', `Dono` = '%s', `FHQ` = '%d', `Money` = '%d', `Maconha` = '%d', `Owner` = '%d' WHERE `ID` = '%d'",
query, HouseInfo[houseid][World], HouseInfo[houseid][Price], HouseInfo[houseid][Interior], HouseInfo[houseid][Locked], HouseInfo[houseid][Dono], HouseInfo[houseid][FHQ], HouseInfo[houseid][Money], HouseInfo[houseid][Maconha], HouseInfo[houseid][Owner], HouseInfo[houseid][ID]);
mysql_pquery(ConnectMYSQL, query);

format(string, sizeof(string), "%s criou uma nova casa!", PlayerName(playerid) );
SendClientMessage(playerid, COLOR_LIGHTRED, string);
RefreshHouses();
return 1;
}


Need ', in %d?

Sorry my english, thanks :D

maikons
10/01/2015, 01:30 PM
any?