· 9 years ago · Jan 09, 2017, 01:50 AM
1[Err] 1064 - 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 ';
2
3
4-- ----------------------------
5-- Procedure structure for f_deleteItem
6' at line 1
7[Err] INSERT INTO `working_containers` VALUES ('7420', null, '6473', '2017-01-09 07:29:03', '710', '100');
8INSERT INTO `working_containers` VALUES ('7421', null, '2080', '2017-01-09 07:29:10', '710', '100');
9INSERT INTO `working_containers` VALUES ('7422', null, '1979', '2017-01-09 07:29:17', '710', '100');
10INSERT INTO `working_containers` VALUES ('7424', null, '1976', '2017-01-09 07:29:24', '710', '100');
11INSERT INTO `working_containers` VALUES ('7425', null, '6460', '2017-01-09 07:29:32', '710', '100');
12INSERT INTO `working_containers` VALUES ('7426', null, '1972', '2017-01-09 07:29:39', '710', '100');
13INSERT INTO `working_containers` VALUES ('7427', null, '6461', '2017-01-09 07:29:46', '710', '100');
14INSERT INTO `working_containers` VALUES ('7428', null, '6462', '2017-01-09 07:29:56', '750', '100');
15INSERT INTO `working_containers` VALUES ('7429', null, '1969', '2017-01-09 07:30:05', '750', '100');
16INSERT INTO `working_containers` VALUES ('7430', null, '6463', '2017-01-09 07:30:13', '750', '100');
17INSERT INTO `working_containers` VALUES ('7431', null, '1966', '2017-01-09 07:30:23', '750', '100');
18INSERT INTO `working_containers` VALUES ('7432', null, '6464', '2017-01-09 07:30:33', '750', '100');
19INSERT INTO `working_containers` VALUES ('7433', null, '1963', '2017-01-09 07:30:48', '750', '100');
20INSERT INTO `working_containers` VALUES ('7434', null, '1961', '2017-01-09 07:31:11', '750', '100');
21INSERT INTO `working_containers` VALUES ('7435', null, '6465', '2017-01-09 07:32:07', '750', '100');
22INSERT INTO `working_containers` VALUES ('7436', null, '6447', '2017-01-09 07:32:17', '750', '100');
23INSERT INTO `working_containers` VALUES ('7437', null, '6466', '2017-01-09 07:32:27', '750', '100');
24INSERT INTO `working_containers` VALUES ('7438', null, '6448', '2017-01-09 07:36:05', '710', '100');
25INSERT INTO `working_containers` VALUES ('7439', null, '6450', '2017-01-09 07:36:17', '710', '100');
26INSERT INTO `working_containers` VALUES ('7440', null, '6467', '2017-01-09 07:36:23', '750', '100');
27INSERT INTO `working_containers` VALUES ('7441', null, '6451', '2017-01-09 07:36:33', '710', '100');
28INSERT INTO `working_containers` VALUES ('7442', null, '6452', '2017-01-09 07:36:40', '710', '100');
29INSERT INTO `working_containers` VALUES ('7443', null, '6468', '2017-01-09 07:36:47', '750', '100');
30INSERT INTO `working_containers` VALUES ('7444', null, '6453', '2017-01-09 07:36:58', '710', '100');
31INSERT INTO `working_containers` VALUES ('7446', '17958', null, '2017-01-09 02:13:12', null, null);
32INSERT INTO `working_containers` VALUES ('7447', '17959', null, '2017-01-09 02:13:22', null, null);
33INSERT INTO `working_containers` VALUES ('7448', '17961', null, '2017-01-09 02:13:34', null, null);
34INSERT INTO `working_containers` VALUES ('7449', '17960', null, '2017-01-09 00:58:44', null, null);
35INSERT INTO `working_containers` VALUES ('7450', '17957', null, '2017-01-09 00:59:08', null, null);
36INSERT INTO `working_containers` VALUES ('7451', null, '6469', '2017-01-09 07:40:27', '715', '100');
37INSERT INTO `working_containers` VALUES ('7452', null, '6454', '2017-01-09 07:40:35', '715', '100');
38INSERT INTO `working_containers` VALUES ('7453', null, '6455', '2017-01-09 07:40:47', '731', '100');
39INSERT INTO `working_containers` VALUES ('7454', null, '6470', '2017-01-09 07:40:55', '731', '100');
40INSERT INTO `working_containers` VALUES ('7455', null, '6471', '2017-01-09 07:41:13', '718', '100');
41INSERT INTO `working_containers` VALUES ('7480', '18230', null, '2017-01-09 01:54:59', null, null);
42INSERT INTO `working_containers` VALUES ('7533', '18318', null, '2017-01-09 02:11:28', null, null);
43
44-- ----------------------------
45-- Table structure for _data_version
46-- ----------------------------
47DROP TABLE IF EXISTS `_data_version`;
48CREATE TABLE `_data_version` (
49 `TableName` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
50 `Value` int(10) unsigned NOT NULL,
51 PRIMARY KEY (`TableName`)
52) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
53
54-- ----------------------------
55-- Records of _data_v
56[Err] 1064 - 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 ';
57
58
59-- ----------------------------
60-- Procedure structure for p_issueIdRange' at line 1
61[Err] ;
62
63
64-- ----------------------------
65-- Procedure structure for p_issueIdRange_horses
66-- ----------------------------
67DROP PROCEDURE IF EXISTS `p_issueIdRange_horses`;
68
69
70;
71
72
73-- ----------------------------
74-- Procedure structure for p_issueIdRange_movable_objects
75-- ----------------------------
76DROP PROCEDURE IF EXISTS `p_issueIdRange_movable_objects`;
77
78
79;
80
81
82-- ----------------------------
83-- Procedure structure for p_issueIdRange_unmovable_objects
84-- ----------------------------
85DROP PROCEDURE IF EXISTS `p_issueIdRange_unmovable_objects`;
86
87
88;
89
90
91-- ----------------------------
92-- Procedure structure for p_liftMovableObject
93-- ----------------------------
94DROP PROCEDURE IF EXISTS `p_liftMovableObject`;
95
96CREATE DEFINER=`lif_829`@`%` PROCEDURE `p_liftMovableObject`(
97 `objID` INT UNSIGNED,
98 `carrierCharID` INT UNSIGNED
99)
100 MODIFIES SQL DATA
101BEGIN
102/*
103 DECLARE geoID INT UNSIGNED DEFAULT NULL;
104 SELECT GeoDataID FROM movable_objects WHERE ID =objID
105 LIMIT 1
106 INTO geoID
107 FOR UPDATE;
108
109 IF(geoID is not null) THEN
110 UPDATE geo_data
111 SET MovableObjectsCount =MovableObjectsCount -1
112 WHERE ID =geoID AND MovableObjectsCount >0;
113 END IF;
114*/
115
116 UPDATE movable_objects
117 SET CarrierCharacterID =carrierCharID
118 WHERE ID=objID;
119END
120;
121
122
123-- ----------------------------
124-- Procedure structure for p_linkBlueprintToCharacter
125-- ----------------------------
126DROP PROCEDURE IF EXISTS `p_linkBlueprintToCharacter`;
127
128
129;
130
131
132-- ----------------------------
133-- Procedure structure for p_occupyId_horses
134-- ----------------------------
135DROP PROCEDURE IF EXISTS `p_occupyId_horses`;
136
137
138;
139
140
141-- ----------------------------
142-- Procedure structure for p_occupyId_movable_objects
143-- ----------------------------
144DROP PROCEDURE IF EXISTS `p_occupyId_movable_objects`;
145
146
147;
148
149
150-- ----------------------------
151-- Procedure structure for p_occupyId_unmovable_objects
152-- ----------------------------
153DROP PROCEDURE IF EXISTS `p_occupyId_unmovable_objects`;
154
155
156;
157
158
159-- ----------------------------
160-- Procedure structure for p_recreateUnmovableObject
161-- ----------------------------
162DROP PROCEDURE IF EXISTS `p_recreateUnmovableObject`;
163
164
165;
166
167
168-- ----------------------------
169-- Procedure structure for p_transferMovableObjItems
170-- ----------------------------
171DROP PROCEDURE IF EXISTS `p_transferMovableObjItems`;
172
173
174;
175
176
177-- ----------------------------
178-- Procedure structure for p_yo_check_steam_accout_exists
179-- ----------------------------
180DROP PROCEDURE IF EXISTS `p_yo_check_steam_accout_exists`;
181
182CREATE DEFINER=`lif_829`@`%` PROCEDURE `p_yo_check_steam_accout_exists`(
183 `in_steamID` BIGINT UNSIGNED
184)
185BEGIN
186
187 insert ignore account (SteamID)
188 values (in_steamID);
189
190 select ID, IsActive, IsGM
191 from account
192 where SteamID = in_steamID;
193
194END
195;
196
197
198-- ----------------------------
199-- Procedure structure for sp_checkForeignKeys
200-- ----------------------------
201DROP PROCEDURE IF EXISTS `sp_checkForeignKeys`;
202
203
204;
205
206
207-- ----------------------------
208-- Procedure structure for _p_convertForestToNewAgeSettings
209-- ----------------------------
210DROP PROCEDURE IF EXISTS `_p_convertForestToNewAgeSettings`;
211
212
213;
214
215
216-- ----------------------------
217-- Function structure for f_addForestPatch
218-- ----------------------------
219DROP FUNCTION IF EXISTS `f_addForestPatch`;
220
221
222;
223
224
225-- ----------------------------
226-- Function structure for f_addGeoPatch
227-- ----------------------------
228DROP FUNCTION IF EXISTS `f_addGeoPatch`;
229
230
231;
232
233
234-- ----------------------------
235-- Function structure for f_addSkill
236-- ----------------------------
237DROP FUNCTION IF EXISTS `f_addSkill`;
238
239CREATE DEFINER=`lif_829`@`%` FUNCTION `f_addSkill`(
240 `CharacterID` INT UNSIGNED,
241 `SkillTypeID` INT UNSIGNED,
242 `SkillAmount` INT UNSIGNED,
243 `LockStatus` TINYINT
244) RETURNS int(10) unsigned
245BEGIN
246 INSERT INTO skills(`CharacterID`, `SkillTypeID`, `SkillAmount`, `LockStatus`)
247 VALUES(CharacterID, SkillTypeID, SkillAmount, LockStatus);
248
249 return LAST_INSERT_ID();
250END
251;
252
253
254-- ------------------------
255[Msg] Finished - Unsuccessfully
256--------------------------------------------------