[Geisor AAC] Perfect Vocation Samples (with items) for realmap

Sizaro · Aug 19, 2009

This is the Samples I made today, I like them... They are unique from other servers.

1. Step > Remove all items from player id 3, 4, 5 and in player_items table.
2. Step > Remove player id 3, 4, 5 and 6 in players table.

3. Step > Go to players table and click on SQL.
Paste this and click run.

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`, `exphist_lastexp`, `exphist1`, `exphist2`, `exphist3`, `exphist4`, `exphist5`, `exphist6`, `exphist7`, `onlinetimetoday`, `onlinetime1`, `onlinetime2`, `onlinetime3`, `onlinetime4`, `onlinetime5`, `onlinetime6`, `onlinetime7`, `onlinetimeall`) VALUES
(3, 'Sorcerer Sample', 0, 1, 1, 13, 1, 210, 210, 23200, 87, 114, 0, 114, 130, 0, 10, 185, 185, 0, 100, 1, 95, 117, 7, '', 560, 1, 1250337481, 16777343, 1, 0, 0, 0, '', 1250337505, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, '', 23200, 0, 23200, 0, 0, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 120),
(4, 'Druid Sample', 0, 1, 1, 13, 2, 210, 210, 23200, 116, 114, 82, 44, 128, 0, 10, 185, 185, 0, 100, 1, 95, 117, 7, '', 560, 1, 1250337423, 16777343, 1, 0, 0, 0, '', 1250337425, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, '', 23200, 0, 23200, 0, 0, 0, 0, 0, 0, 0, 1140, 0, 0, 0, 0, 0, 1140),
(5, 'Paladin Sample', 0, 1, 1, 13, 3, 235, 235, 23200, 0, 116, 116, 76, 129, 0, 0, 110, 110, 0, 100, 1, 95, 117, 7, '', 660, 1, 1250337299, 16777343, 1, 0, 0, 0, '', 1250337301, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, '', 23200, 0, 23200, 0, 0, 0, 0, 0, 0, 0, 1440, 0, 0, 0, 0, 0, 1440),
(6, 'Knight Sample', 0, 1, 1, 13, 4, 260, 260, 23200, 119, 78, 39, 116, 131, 0, 0, 60, 60, 0, 100, 1, 95, 117, 7, '', 720, 1, 1250337301, 16777343, 1, 0, 0, 0, '', 1250337304, 0, 0, 151200000, 2, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1250268853, 1, '', 1, '', 23200, 0, 23200, 0, 0, 0, 0, 0, 0, 0, 780, 0, 0, 0, 0, 0, 780);

4. Step > Go to player_items table and click on SQL and paste this code and click run.

Code:

INSERT INTO `player_items` (`player_id`, `pid`, `sid`, `itemtype`, `count`, `attributes`) VALUES
(3, 1, 101, 8820, 1, ''),
(3, 3, 102, 2004, 1, ''),
(3, 4, 103, 8819, 1, ''),
(3, 5, 104, 6131, 1, ''),
(3, 6, 105, 2191, 1, ''),
(3, 7, 106, 2648, 1, ''),
(3, 8, 107, 2643, 1, ''),
(3, 102, 108, 2000, 1, ''),
(3, 102, 109, 2554, 1, ''),
(3, 102, 110, 2120, 1, ''),
(3, 108, 111, 7618, 1, ''),
(3, 108, 112, 7618, 1, ''),
(3, 108, 113, 7618, 1, ''),
(3, 108, 114, 7618, 1, ''),
(3, 108, 115, 7618, 1, ''),
(3, 108, 116, 7618, 1, ''),
(3, 108, 117, 7618, 1, ''),
(3, 108, 118, 7618, 1, ''),
(3, 108, 119, 7618, 1, ''),
(3, 108, 120, 7618, 1, ''),
(3, 108, 121, 7620, 1, ''),
(3, 108, 122, 7620, 1, ''),
(3, 108, 123, 7620, 1, ''),
(3, 108, 124, 7620, 1, ''),
(3, 108, 125, 7620, 1, ''),
(3, 108, 126, 7620, 1, ''),
(3, 108, 127, 7620, 1, ''),
(3, 108, 128, 7620, 1, ''),
(3, 108, 129, 7620, 1, ''),
(3, 108, 130, 7620, 1, ''),
(4, 1, 101, 8820, 1, ''),
(4, 3, 102, 2001, 1, ''),
(4, 4, 103, 8819, 1, ''),
(4, 5, 104, 6131, 1, ''),
(4, 6, 105, 2186, 1, ''),
(4, 7, 106, 2648, 1, ''),
(4, 8, 107, 2643, 1, ''),
(4, 102, 108, 2168, 1, 0x1000111200),
(4, 102, 109, 2000, 1, ''),
(4, 102, 110, 2554, 1, ''),
(4, 102, 111, 2120, 1, ''),
(4, 109, 112, 7620, 1, ''),
(4, 109, 113, 7620, 1, ''),
(4, 109, 114, 7620, 1, ''),
(4, 109, 115, 7620, 1, ''),
(4, 109, 116, 7620, 1, ''),
(4, 109, 117, 7620, 1, ''),
(4, 109, 118, 7620, 1, ''),
(4, 109, 119, 7620, 1, ''),
(4, 109, 120, 7620, 1, ''),
(4, 109, 121, 7620, 1, ''),
(4, 109, 122, 7618, 1, ''),
(4, 109, 123, 7618, 1, ''),
(4, 109, 124, 7618, 1, ''),
(4, 109, 125, 7618, 1, ''),
(4, 109, 126, 7618, 1, ''),
(4, 109, 127, 7618, 1, ''),
(4, 109, 128, 7618, 1, ''),
(4, 109, 129, 7618, 1, ''),
(4, 109, 130, 7618, 1, ''),
(4, 109, 131, 7618, 1, ''),
(5, 1, 101, 2459, 1, ''),
(5, 3, 102, 1988, 1, ''),
(5, 4, 103, 8872, 1, ''),
(5, 5, 104, 2521, 1, ''),
(5, 6, 105, 2389, 5, 0x0f05),
(5, 7, 106, 2478, 1, ''),
(5, 8, 107, 2643, 1, ''),
(5, 102, 108, 2000, 1, ''),
(5, 102, 109, 2554, 1, ''),
(5, 102, 110, 2120, 1, ''),
(5, 108, 111, 7618, 1, ''),
(5, 108, 112, 7618, 1, ''),
(5, 108, 113, 7618, 1, ''),
(5, 108, 114, 7618, 1, ''),
(5, 108, 115, 7618, 1, ''),
(5, 108, 116, 7618, 1, ''),
(5, 108, 117, 7618, 1, ''),
(5, 108, 118, 7618, 1, ''),
(5, 108, 119, 7618, 1, ''),
(5, 108, 120, 7618, 1, ''),
(5, 108, 121, 7620, 1, ''),
(5, 108, 122, 7620, 1, ''),
(5, 108, 123, 7620, 1, ''),
(5, 108, 124, 7620, 1, ''),
(5, 108, 125, 7620, 1, ''),
(5, 108, 126, 7620, 1, ''),
(5, 108, 127, 7620, 1, ''),
(5, 108, 128, 7620, 1, ''),
(5, 108, 129, 7620, 1, ''),
(5, 108, 130, 7620, 1, ''),
(6, 1, 101, 2481, 1, ''),
(6, 3, 102, 2000, 1, ''),
(6, 4, 103, 2489, 1, ''),
(6, 5, 104, 2521, 1, ''),
(6, 7, 105, 2478, 1, ''),
(6, 8, 106, 2643, 1, ''),
(6, 102, 107, 2120, 1, ''),
(6, 102, 108, 2554, 1, ''),
(6, 102, 109, 2000, 1, ''),
(6, 102, 110, 2417, 1, ''),
(6, 102, 111, 8602, 1, ''),
(6, 102, 112, 2428, 1, ''),
(6, 109, 113, 7618, 1, ''),
(6, 109, 114, 7618, 1, ''),
(6, 109, 115, 7618, 1, ''),
(6, 109, 116, 7618, 1, ''),
(6, 109, 117, 7618, 1, ''),
(6, 109, 118, 7618, 1, ''),
(6, 109, 119, 7618, 1, ''),
(6, 109, 120, 7618, 1, ''),
(6, 109, 121, 7618, 1, ''),
(6, 109, 122, 7618, 1, ''),
(6, 109, 123, 7618, 1, ''),
(6, 109, 124, 7618, 1, ''),
(6, 109, 125, 7618, 1, ''),
(6, 109, 126, 7618, 1, ''),
(6, 109, 127, 7618, 1, ''),
(6, 109, 128, 7618, 1, ''),
(6, 109, 129, 7618, 1, ''),
(6, 109, 130, 7618, 1, ''),
(6, 109, 131, 7618, 1, ''),
(6, 109, 132, 7618, 1, '');

Bugs? Write here, i'll edit the thread if theres anything wrong:thumbup:

Archez · Aug 20, 2009

Approved

Aeron · Aug 20, 2009

Nice! I will use it in my new proyect. Rep++ for you

Sizaro · Aug 20, 2009

Can any mod change

1. Step > Remove all items from player id 3, 4, 5 and in player_items table.

to

1. Step > Remove all items from player id 3, 4, 5 and 6 in player_items table.

Sync · Aug 20, 2009

Very nice sizaro

Donio · Aug 20, 2009

Thanks alot, faster way to do it ;D

Richi Garza · Aug 20, 2009

Really nice man

Zonet · Aug 20, 2009

Easy but good for guys who dont know

Master-m · Aug 21, 2009

lvl 13? ^.-

Sizaro · Aug 21, 2009

Ye... Why lvl 8?

QuaS · Aug 21, 2009

anyway write there that it is for 0.3.5 (tables skull, and skulltime)

Sizaro · Aug 21, 2009

Can't.

cirtaboy · Aug 21, 2009

Could you tell us in your first post, or in another post. What items you will start with using this?

Sizaro · Aug 21, 2009

It's too much items >,< I don't have time. Also it dosent take too much time to just test them lol

cirtaboy · Aug 21, 2009

Is it like real tibia, or just plate armor etc...

Sizaro · Aug 21, 2009

I call it unique equipment, eq that you don't accually use that much. Dark armor, brass legs, soldier helmet, dark shield for knight. For an example

cirtaboy · Aug 21, 2009

Then it isn't perfect... -.^

klekSu · Aug 22, 2009

I preffer using my leather set and level 1

it's for REAL MAP, dude... on real map you start with level 1 on rook. I didn't like it. Useless. Good job anyway maybe someone uses it, not me.
__________________

You are welcome on kleksoria.com!
Please visit new open tibia forum with it's own ots list. otservers.net!

Sizaro · Aug 22, 2009

Realmap nowadays is starting in main, you're abit after klekSu xD

freak15 · Oct 3, 2009

WOW Thankz very usefull!

[Geisor AAC] Perfect Vocation Samples (with items) for realmap

Advanced OT User

'

www.Asgard-World.com

Advanced OT User

Ø,ø

Banned User

YeYe

Web Developer

Need help? Just ask!

Advanced OT User

Cykotitan Pwned =/

Advanced OT User

Offensive if u r jew 卍

Advanced OT User

Offensive if u r jew 卍

Advanced OT User

Offensive if u r jew 卍

Stroke my ego.

Advanced OT User

Professional Hoster

Similar threads