· 8 years ago · Jun 10, 2018, 11:14 PM
1Logo
2Client Menu
3Home
4Services
5Domains
6Billing
7Support
8Open Ticket
9Affiliates
10Hello, carol!
11
12
13
14
15English Notifications NEW
16View Ticket
17Portal Home Client Area Support Tickets View Ticket
18 Ticket Information
19#981407 - Database help with this arma3life-3.1.4.sql
20Answered
21Department
22Game Server Support
23Submitted
2410/06/2018 (04:50)
25Last Updated
266 hours ago
27Priority
28High
29 Reply
3010/06/2018 (12:25)
31Clay Berndt
32Staff
33Hello Carol,
34Please upload your SQL file here and provide us with the link:
35http://pastebin.com
36
37We will first delete your database, re-create it and import the provided SQL file.
38
39Clay B. - Chief Executive Officer
40
41
4210/06/2018 (10:08)
43Spencer Z
44Staff
45Hello carol,
46I will escalate this. :)
47
48Spencer Z. - Support Technician
49
50
5110/06/2018 (10:04)
52carol stevenson
53Client
54There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem.
55
56ERROR: Unknown Punctuation String @ 365
57STR: /;
58SQL: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";# MySQL returned an empty result set (i.e. zero rows).
59SET time_zone = "+00:00";# MySQL returned an empty result set (i.e. zero rows).
60/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
61
62SQL query:
63
64/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
65
66MySQL said: Documentation
67
681064 - 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 '/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1
6910/06/2018 (09:54)
70Spencer Z
71Staff
72Hello carol,
73Oh okay, let us know.
74
75Spencer Z. - Support Technician
76
77
7810/06/2018 (09:52)
79carol stevenson
80Client
81Oh I haven't done it yet what you said I cant right now I will try it later Cuz it's very late
82
8310/06/2018 (09:47)
84Spencer Z
85Staff
86Hello carol,
87Right. I am going to forward this to my superiors.
88I appologize that I could not help you further.
89
90Spencer Z. - Support Technician
91
92
9310/06/2018 (09:45)
94carol stevenson
95Client
96But the sql file is not imported to the database
97
9810/06/2018 (09:40)
99Spencer Z
100Staff
101Hello carol,
102Please test out your database now.
103
104Spencer Z. - Support Technician
105
106
10710/06/2018 (09:38)
108carol stevenson
109Client
110So I changet the arma3 to the database name
111
11210/06/2018 (09:28)
113Spencer Z
114Staff
115Hello carol,
116You need a name for your database.
117If you don't have one, you will run into the problem of it not working.
118
119Spencer Z. - Support Technician
120
121
12210/06/2018 (09:26)
123carol stevenson
124Client
125What you meaning
126
12710/06/2018 (08:32)
128Spencer Z
129Staff
130Hello carol,
131In the line:
132CREATE DEFINER=arma3@localhost PROCEDURE resetLifeVehicles()
133Change the arma3 to your own database.
134
135Spencer Z. - Support Technician
136
137
13810/06/2018 (06:47)
139carol stevenson
140Client
141oh i already did that it didnt work
142
14310/06/2018 (06:06)
144carol stevenson
145Client
146what you meaning
147
14810/06/2018 (05:42)
149Zack S.
150Staff
151I suggest you replace arma3life with your database name.
152
153Zack S. - Support Technician
154
155
15610/06/2018 (05:40)
157carol stevenson
158Client
159to what i havent done it before can you try to do it this is the code
160
161SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
162SET time_zone = "+00:00";
163
164/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
165/ !40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
166/ !40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
167/ !40101 SET NAMES utf8 */;
168
169--
170-- Database: arma3life
171
172-- Default Schema
173CREATE DATABASE IF NOT EXISTS arma3life DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
174USE arma3life;
175
176DELIMITER $$
177-- Procedures
178
179-- Edit arma3 and root to match a user in MySQL
180CREATE DEFINER=arma3@localhost PROCEDURE resetLifeVehicles()
181BEGIN
182UPDATE vehicles SET active= 0;
183END$$
184
185CREATE DEFINER=root@localhost PROCEDURE deleteDeadVehicles()
186BEGIN
187DELETE FROM vehicles WHERE alive = 0;
188END$$
189
190CREATE DEFINER=root@localhost PROCEDURE deleteOldHouses()
191BEGIN
192DELETE FROM houses WHERE owned = 0;
193END$$
194
195CREATE DEFINER=root@localhost PROCEDURE deleteOldGangs()
196BEGIN
197DELETE FROM gangs WHERE active = 0;
198END$$
199
200DELIMITER ;
201
202--
203
204-- Table structure for table players
205CREATE TABLE IF NOT EXISTS players (
206uid int(12) NOT NULL AUTO_INCREMENT,
207name varchar(32) NOT NULL,
208playerid varchar(50) NOT NULL,
209cash int(100) NOT NULL DEFAULT '0',
210bankacc int(100) NOT NULL DEFAULT '0',
211coplevel enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
212cop_licenses text,
213civ_licenses text,
214med_licenses text,
215cop_gear text NOT NULL,
216med_gear text NOT NULL,
217mediclevel enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
218arrested tinyint(1) NOT NULL DEFAULT '0',
219aliases text NOT NULL,
220adminlevel enum('0','1','2','3') NOT NULL DEFAULT '0',
221donatorlvl enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
222civ_gear text NOT NULL,
223blacklist tinyint(1) NOT NULL DEFAULT '0',
224PRIMARY KEY (uid),
225UNIQUE KEY playerid (playerid),
226KEY name (name),
227KEY blacklist (blacklist)
228) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
229
230--
231
232-- Table structure for table vehicles
233CREATE TABLE IF NOT EXISTS vehicles (
234id int(12) NOT NULL AUTO_INCREMENT,
235side varchar(15) NOT NULL,
236classname varchar(32) NOT NULL,
237type varchar(12) NOT NULL,
238pid varchar(32) NOT NULL,
239alive tinyint(1) NOT NULL DEFAULT '1',
240active tinyint(1) NOT NULL DEFAULT '0',
241plate int(20) NOT NULL,
242color int(20) NOT NULL,
243inventory varchar(500) NOT NULL,
244PRIMARY KEY (id),
245KEY side (side),
246KEY pid (pid),
247KEY type (type)
248) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
249
250--
251-- Table structure for table houses
252
253-- Needed for extDB latest update on git
254CREATE TABLE IF NOT EXISTS houses (
255id int(11) NOT NULL AUTO_INCREMENT,
256pid varchar(32) NOT NULL,
257pos varchar(64) DEFAULT NULL,
258inventory text,
259containers text,
260owned tinyint(4) DEFAULT '0',
261PRIMARY KEY (id,pid)
262) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
263
264--
265-- Table structure for table gangs
266
267-- Needed for extDB latest update on git
268CREATE TABLE IF NOT EXISTS gangs (
269id int(11) NOT NULL AUTO_INCREMENT,
270owner varchar(32) DEFAULT NULL,
271name varchar(32) DEFAULT NULL,
272members text,
273maxmembers int(2) DEFAULT '8',
274bank int(100) DEFAULT '0',
275active tinyint(4) DEFAULT '1',
276PRIMARY KEY (id),
277UNIQUE KEY name_UNIQUE (name)
278) ENGINE=InnoDB DEFAULT CHARSET=latin1;
279
280/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
281/ !40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
282/ !40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;