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

Threaded Mode
Mysql Dont save
jose005
Big Clucker
***
Posts: 82
Threads: 18
Joined: Dec 2010
Reputation: 0
#1

03.11.2015, 03:35
My server dont save the doors in mysql this is the code: (Sorry for my bad english)

Command:
Quote:

CMD:doorexterior(playerid, params[]) {
if(PlayerData[playerid][pAdmin] >= 3) {
new iDoorID,
szStream[5],
szMessage[128];

if(sscanf(params, "is[5]", iDoorID, szStream))
return SendClientMessage(playerid, COLOR_GRAD1, SYNTAX_MESSAGE"/doorexterior [doorid] [streamed('Yes'/'No')]");

if(iDoorID < 0 || iDoorID > MAX_DDOORS)
return SendClientMessage(playerid, COLOR_GRAD1, "Invalid door specified.");

if(strcmp(szStream, "Yes", true) == 0)
DoorData[iDoorID][ddCustomExterior] = 1;
else if(strcmp(szStream, "No", true) == 0)
DoorData[iDoorID][ddCustomExterior] = 0;
else
return SendClientMessage(playerid, COLOR_GRAD1, "Invalid stream specified, enter either; 'yes' or 'no'.");

GetPlayerPos(playerid, DoorData[iDoorID][ddExteriorX], DoorData[iDoorID][ddExteriorY], DoorData[iDoorID][ddExteriorZ]);
GetPlayerFacingAngle(playerid, DoorData[iDoorID][ddExteriorA]);

DoorData[iDoorID][ddExteriorVW] = GetPlayerVirtualWorld(playerid);
DoorData[iDoorID][ddExteriorInt] = GetPlayerInterior(playerid);

CreateDynamicDoor(iDoorID);
SaveDynamicDoor(iDoorID);

format(szMessage, sizeof szMessage, "You have editied door ID %i exterior position, with VW %i and interior %i.", iDoorID, GetPlayerVirtualWorld(playerid), GetPlayerInterior(playerid));
SendClientMessage(playerid, COLOR_GRAD1, szMessage);

format(szMessage, sizeof szMessage, "%s has editied door ID %i exterior.", getPlayerName(playerid), iDoorID);
Log("logs/dooredit.log", szMessage);
}
else Invalid_Admin(playerid);
return 1;
}
save function:
Quote:

stock SaveDynamicDoor(doorid) {
new string[1024];
format(string, sizeof(string), "UPDATE `doors` SET \
`Description`='%s', \
`CustomInterior`=%d, \
`ExteriorVW`=%d, \
`ExteriorInt`=%d, \
`InteriorVW`=%d, \
`InteriorInt`=%d, \
`ExteriorX`=%f, \
`ExteriorY`=%f, \
`ExteriorZ`=%f, \
`ExteriorA`=%f, \
`InteriorX`=%f, \
`InteriorY`=%f, \
`InteriorZ`=%f, \
`InteriorA`=%f,",
DoorData[doorid][ddDescription],
DoorData[doorid][ddCustomInterior],
DoorData[doorid][ddExteriorVW],
DoorData[doorid][ddExteriorInt],
DoorData[doorid][ddInteriorVW],
DoorData[doorid][ddInteriorInt],
DoorData[doorid][ddExteriorX],
DoorData[doorid][ddExteriorY],
DoorData[doorid][ddExteriorZ],
DoorData[doorid][ddExteriorA],
DoorData[doorid][ddInteriorX],
DoorData[doorid][ddInteriorY],
DoorData[doorid][ddInteriorZ],
DoorData[doorid][ddInteriorA]
);

format(string, sizeof(string), "%s \
`CustomExterior`=%d, \
`VIP`=%d, \
`Family`=%d, \
`Faction`=%d, \
`Admin`=%d, \
`Wanted`=%d, \
`VehicleAble`=%d, \
`Color`=%d, \
`PickupModel`=%d, \
`Pass`='%s', \
`Locked`=%d WHERE `id`=%d",
string,
DoorData[doorid][ddCustomExterior],
DoorData[doorid][ddVIP],
DoorData[doorid][ddFamily],
DoorData[doorid][ddFaction],
DoorData[doorid][ddAdmin],
DoorData[doorid][ddWanted],
DoorData[doorid][ddVehicleAble],
DoorData[doorid][ddColor],
DoorData[doorid][ddPickupModel],
DoorData[doorid][dPass],
DoorData[doorid][dLocked],
doorid+1
); // Array starts from zero, MySQL starts at 1 (this is why we are adding one).

mysql_function_query(g_iConnectionHandle[0], string, false, "OnQueryFinish", "i", THREAD_NO_RESULT);
}
Table Mysql:
Quote:

- ----------------------------
-- Table structure for doors
-- ----------------------------
DROP TABLE IF EXISTS `doors`;
CREATE TABLE `doors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Description` varchar(12 NOT NULL DEFAULT 'None',
`CustomInterior` int(11) NOT NULL DEFAULT '0',
`ExteriorVW` int(11) NOT NULL DEFAULT '0',
`ExteriorInt` int(11) NOT NULL DEFAULT '0',
`InteriorVW` int(11) NOT NULL DEFAULT '0',
`InteriorInt` int(11) NOT NULL DEFAULT '0',
`ExteriorX` float(10,5) NOT NULL DEFAULT '0.00000',
`ExteriorY` float(10,5) NOT NULL DEFAULT '0.00000',
`ExteriorZ` float(10,5) NOT NULL DEFAULT '0.00000',
`ExteriorA` float(10,5) NOT NULL DEFAULT '0.00000',
`InteriorX` float(10,5) NOT NULL DEFAULT '0.00000',
`InteriorY` float(10,5) NOT NULL DEFAULT '0.00000',
`InteriorZ` float(10,5) NOT NULL DEFAULT '0.00000',
`InteriorA` float(10,5) NOT NULL DEFAULT '0.00000',
`CustomExterior` int(11) NOT NULL DEFAULT '0',
`VIP` int(11) NOT NULL DEFAULT '0',
`Family` int(11) NOT NULL DEFAULT '0',
`Faction` int(11) NOT NULL DEFAULT '0',
`Admin` int(11) NOT NULL DEFAULT '0',
`Wanted` int(11) NOT NULL DEFAULT '0',
`VehicleAble` int(11) NOT NULL DEFAULT '0',
`Color` int(11) NOT NULL DEFAULT '0',
`PickupModel` int(11) NOT NULL DEFAULT '0',
`Pass` varchar(24) NOT NULL DEFAULT 'pass',
`Locked` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=500 DEFAULT CHARSET=latin1;
Find
Reply
jose005
Big Clucker
***
Posts: 82
Threads: 18
Joined: Dec 2010
Reputation: 0
#2

03.11.2015, 16:21
Help D:
Find
Reply
jose005
Big Clucker
***
Posts: 82
Threads: 18
Joined: Dec 2010
Reputation: 0
#3

04.11.2015, 15:58
Help D:
Find
Reply
jose005
Big Clucker
***
Posts: 82
Threads: 18
Joined: Dec 2010
Reputation: 0
#4

05.11.2015, 04:02
Help D:
Find
Reply
iKarim
Banned
Posts: 579
Threads: 5
Joined: Oct 2015
#5

05.11.2015, 04:43
Nice triple bump, Anyways..
May I see your MySQL logs? I wont guess whats wrong.
Find
Reply
jose005
Big Clucker
***
Posts: 82
Threads: 18
Joined: Dec 2010
Reputation: 0
#6

05.11.2015, 20:03
Quote:
Originally Posted by PawnHunter
Посмотреть сообщение
Nice triple bump, Anyways..
May I see your MySQL logs? I wont guess whats wrong.
Only This :S
Quote:

[14:59:41] [ERROR] ExecuteT[LoadLockers()] - (error #1146) Table 'samp.viplockers' doesn't exist
[15:00:06] [ERROR] ExecuteT[LoadLockers()] - (error #1146) Table 'samp.viplockers' doesn't exist
[15:00:52] [ERROR] ExecuteT[LoadLockers()] - (error #1146) Table 'samp.viplockers' doesn't exist
Find
Reply
PrO.GameR
Gangsta
****
Posts: 694
Threads: 2
Joined: Oct 2012
Reputation: 0
#7

05.11.2015, 20:26
Tip one, learn English enough to at least understand basic errors if you want help in an English forums
samp.viplockers table doesn't exist, either this is not your table's name or you didn't create it
Find
Reply
jose005
Big Clucker
***
Posts: 82
Threads: 18
Joined: Dec 2010
Reputation: 0
#8

05.11.2015, 21:17
Quote:
Originally Posted by PrO.GameR
Посмотреть сообщение
Tip one, learn English enough to at least understand basic errors if you want help in an English forums
samp.viplockers table doesn't exist, either this is not your table's name or you didn't create it
the problem dont are the viplocker is the save door, door is one table and viplockers is other and samp_log say this error:

Quote:

Error #1064 - Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `jobID` = 1' at line 1 | Query: INSERT INTO `jobs` SET `jobType` = 5, `jobPosX` = 1654.010986, `jobPosY` = -1655.713134, `jobPosZ` = 22.515625, `jobPickupX` = 0.000000, `jobPickupY` = 0.000000, `jobPickupZ` = 0.000000, `jobLevelRequirement` = 0 WHERE `jobID` = 1 | Callback: OnQueryFinish
Find
Reply
ThePhenix
Gangsta
*****
Posts: 801
Threads: 29
Joined: May 2012
Reputation: 0
#9

05.11.2015, 22:00
You are using the WHERE clause while using INSERT INTO which makes no sense at all in your query.
Find
Reply
jose005
Big Clucker
***
Posts: 82
Threads: 18
Joined: Dec 2010
Reputation: 0
#10

06.11.2015, 02:50
Quote:
Originally Posted by ThePhenix
Посмотреть сообщение
You are using the WHERE clause while using INSERT INTO which makes no sense at all in your query.
TY men

Fixed.
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