Thread: Mega sql pack

This pack 2.0 contains

1. Server Teleporter
2. Class + Riding + Weapon Trainer
3. Professions Trainer + Mats Vendor + Sources for Players vendor
4. Gunship battle custom boss
5. Custom event boss Consur
6. Custom quest Giver, quest Receivers + custom server quests
7. Event vendor
8. Custom events - Stairs to heaven, Medium Maze, Huge Maze, Easy Jump and Hard Jump

1. - Not my work I've just add few locations
2. - Not my work - I've just extracted them from ALL IN ON TRAINER and changed their spawn and ofc move them to one SQL
3. - This is custom NPC for custom daily quests
4. - Not my work -
5. - Not my work - I've just changed his HP and spawn him to location
6. - INCLUDED - Custom quest Giver, quest Receivers + custom server quests (EVENT QUESTS are teleporting
7. - I've added some mounts, companions and ofc 36 slot bagle for new prize (modificated) EVENT MARK
8. Not my work - I've just added spawns, few changes and ofc split them together + I've made 2 NEW! events Easy Jump and Hard jump

Hope you enjoy this SQL packs, you may need it for your high rate server

CORE - TC2 game version 3.3.5a

DOWNLOAD LINK -->

SQL 2.0

PASSWORD - full

Uploaded NEW SQL2.0 pack with 2 new FEATURES - Easy jump and HARD jump, and added READ ME note (You find there in what order you must upload these SQL files.

Credits : fullhouser

---

› See More: Mega sql pack

Here's a script that will add the custom events to the teleporter's list

Code:

INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, box_coded, box_money, box_text) VALUES('50000', 25, 2, 'EVENT', 1, 1, '50000'+9, 0, 0, 0, NULL),
('50000'+9, 0, 2, 'Huge Maze', 1, 1, '50000', 0, 0, 0, 'Are you sure, that you want to go to hugemaze?'),
('50000'+9, 1, 2, 'Medium Maze', 1, 1, '50000', 0, 0, 0, 'Are you sure, that you want to go to mediummaze?'),
('50000'+9, 2, 2, 'Haven Staris', 1, 1, '50000', 0, 0, 0, 'Are you sure, that you want to go to heavenstairs?'),
('50000'+9, 3, 2, 'Easy Jump', 1, 1, '50000', 0, 0, 0, 'Are you sure, that you want to go to easyjump?'),
('50000'+9, 4, 2, 'Hard Jump', 1, 1, '50000', 0, 0, 0, 'Are you sure, that you want to go to hardjump?');


INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES
('190000', 0, 137, 0, 62, 0, 100, 0, '50000'+9, 0, 0, 0, 62, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, -7409.058594, 795.470703, 131.407455, 3.195746, 'Teleporter script'),
('190000', 0, 138, 0, 62, 0, 100, 0, '50000'+9, 1, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 8, 0, 0, 2462.18, 2445.43, 131.414, 4.28446, 'Teleporter script'),
('190000', 0, 139, 0, 62, 0, 100, 0, '50000'+9, 2, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 8, 0, 0, 2909, 2926.1, 2.91349, 1.22915, 'Teleporter script'),
('190000', 0, 140, 0, 62, 0, 100, 0, '50000'+9, 3, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 8, 0, 0, -9645.53, -1986.04, 0.570255, 4.24956, 'Teleporter script'),
('190000', 0, 141, 0, 62, 0, 100, 0, '50000'+9, 4, 0, 0, 62, 1, 0, 0, 0, 0, 0, 0, 8, 0, 0, -11874.1, -4855.98, 1.65968, 4.11526, 'Teleporter script');