• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Vocation samples

A

Abbeh

New Member
Joined
Nov 22, 2012
Messages
98
Reaction score
1
Location
Sweden, Gothenburg
Good evening,

I more or less screwed up the entire DB when I removed the samples.

This is the code that I received from a guy from another thread:

Code: 
"INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`) VALUES

(2, 'Rook Sample', 0, 1, 1, 1, 0, 185, 185, 0, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140508, 16777343, 1, 0, 0, 0, '', 1258140521, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(3, 'Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 4200, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258212752, 16777343, 1, 0, 0, 0, '', 1258212822, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(4, 'Druid Sample', 0, 1, 1, 8, 2, 185, 185, 4200, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140858, 16777343, 1, 0, 0, 0, '', 1258140885, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(5, 'Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 4200, 107, 114, 78, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140912, 16777343, 1, 0, 0, 0, '', 1258140945, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),
(6, 'Knight Sample', 0, 1, 1, 8, 4, 185, 185, 4200, 107, 114, 59, 58, 128, 0, 0, 35, 35, 0, 100, 1, 160, 52, 7, '', 420, 1, 1258140886, 16777343, 1, 0, 0, 0, '', 1258140910, 0, 0, 151200000, 0, 30, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1258140396, 1, '', 1, ''),

But this error shows up:

"#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 '' at line 7 "

Does anyone has the answer? :)

- - - Updated - - -

Never mind, I fixed the issue.
 
Back
Top