[Release] Ascent MySQL Driven Teleporter NPC

[waymirec]

Teleporter NPC addon for Ascent that uses MySQL to store the teleporter locations/menuitems rather than storing them within the c++ code. It's just a first draft and has definite room for improvement, including storing the menu items into a data structure at startup rather than performing db queries for each request. Included in the zip is the source for the teleporter as well as a mysqldump of an example table.

There are 2 defines at the top of the Custom_Teleporters.cpp that define the maximum number of entries allowed per request as well as the creature id of the npc you want the script bound to. Change as needed.

Credit goes out to whomever coded the original version of the Teleporter that I am using. It was provided to me by someone else so i'm not sure who the person is.

The package can be downloaded from

To view the content, you need to sign in or register

 

[xujiequn]

Asked has Ascent MySQL Driven Teleporter item?

 

[waymirec]

I noticed that i noobishly set the map field to tinyint(3) unsigned resulting in none of the TBC maps working. I corrected it and here is the fix.

To view the content, you need to sign in or register

 

[xujiequn]

Has made a mistake My meaning is makes the transmission with goods
Is not the servant makes the transmission




This is the transmission gem which Chinese very many people uses Is
not npc
But cannot find the source code

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for system_menu
-- ----------------------------
CREATE TABLE `system_menu` (
`id` int(6) NOT NULL auto_increment,
`icon` smallint(3) NOT NULL default '0',
`itemtext` text NOT NULL,
`sortid` smallint(6) NOT NULL default '0',
`paneid` int(6) NOT NULL,
`action` varchar(255) default NULL,
`memo` text,
PRIMARY KEY (`id`),
KEY `idx_menu_paneid` (`paneid`)
) ENGINE=MyISAM AUTO_INCREMENT=491 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `system_menu` VALUES ('488', '0', ' 「Back」 Main Page ', '15', '884', 'show_menu 88', 'Back');

 

[gillbz]

Sorry about bringinh this back up after such a long time but im a total noob and when i try to compile it it brings up a bunch of errors, could someone please post a link to a dll file of this compiled?

Thanks