[DiscordArchive] i mean we can use those npc?
[DiscordArchive] i mean we can use those npc?
Original source
If there was a script about it, it might not even check the wow's db but an actual link to someowhere else where they would have those information
rektbyfaith
09-21-2024, 01:23 PM #11Archived author: Ryan Turner • Posted: 2024-09-21T13:23:08.076000+00:00
Original source
If there was a script about it, it might not even check the wow's db but an actual link to someowhere else where they would have those information
Original source
i've been searching for a script in relevant locations, kalimdor->orgrimmar etc and have not turned anything up
rektbyfaith
09-21-2024, 01:23 PM #12Archived author: confessore • Posted: 2024-09-21T13:23:55.901000+00:00
Original source
i've been searching for a script in relevant locations, kalimdor->orgrimmar etc and have not turned anything up
Original source
we need something like this
```
DROP TABLE IF EXISTS `character_codes`;
CREATE TABLE `character_codes` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Increment',
`npc_id` mediumint(10) NOT NULL DEFAULT '0' COMMENT 'The NPC ID',
`code` varchar(25) NOT NULL COMMENT 'The code you have to enter',
`uses` tinyint(3) NOT NULL DEFAULT '1' COMMENT 'Number of uses left for this code',
`item_id` mediumint(10) NOT NULL DEFAULT '0' COMMENT 'The gift (item)',
`quantity` int(20) NOT NULL DEFAULT '1' COMMENT 'The quantity of ITEMS',
`newlevel` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'Number of level that he can get',
`name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT 'name of the reward',
PRIMARY KEY (`id`,`npc_id`),
KEY `acc_idx` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
INSERT INTO `character_codes` VALUES ('38', '0', 'tFbB-GdIe-gRch-nzXx', '1', '49426', '45', '0', 'EMBLEM OF FROST X45');
INSERT INTO `character_codes` VALUES ('2', '0', 'PU2Q-1SvY-RcXl-R9z2', '0', '54811', '1', '0', 'CELESTIAL STEED');
```
rektbyfaith
09-21-2024, 01:25 PM #13Archived author: OUTRAKE • Posted: 2024-09-21T13:25:14.301000+00:00
Original source
we need something like this
```
DROP TABLE IF EXISTS `character_codes`;
CREATE TABLE `character_codes` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Increment',
`npc_id` mediumint(10) NOT NULL DEFAULT '0' COMMENT 'The NPC ID',
`code` varchar(25) NOT NULL COMMENT 'The code you have to enter',
`uses` tinyint(3) NOT NULL DEFAULT '1' COMMENT 'Number of uses left for this code',
`item_id` mediumint(10) NOT NULL DEFAULT '0' COMMENT 'The gift (item)',
`quantity` int(20) NOT NULL DEFAULT '1' COMMENT 'The quantity of ITEMS',
`newlevel` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'Number of level that he can get',
`name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT 'name of the reward',
PRIMARY KEY (`id`,`npc_id`),
KEY `acc_idx` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
INSERT INTO `character_codes` VALUES ('38', '0', 'tFbB-GdIe-gRch-nzXx', '1', '49426', '45', '0', 'EMBLEM OF FROST X45');
INSERT INTO `character_codes` VALUES ('2', '0', 'PU2Q-1SvY-RcXl-R9z2', '0', '54811', '1', '0', 'CELESTIAL STEED');
```
Original source
I'm quite confident they don't check the codes at all
rektbyfaith
09-21-2024, 01:25 PM #14Archived author: Bench • Posted: 2024-09-21T13:25:16.796000+00:00
Original source
I'm quite confident they don't check the codes at all
Original source
i saw this once but i think thats from a module in trinitycore
rektbyfaith
09-21-2024, 01:25 PM #15Archived author: OUTRAKE • Posted: 2024-09-21T13:25:46.574000+00:00
Original source
i saw this once but i think thats from a module in trinitycore
Original source
what is `character_gifts`? oh this looks like gift wrapped items
rektbyfaith
09-21-2024, 01:28 PM #16Archived author: confessore • Posted: 2024-09-21T13:28:38.679000+00:00
Original source
what is `character_gifts`? oh this looks like gift wrapped items
Original source
Pretty sure is to know what's inside of a "wrapped" item
rektbyfaith
09-21-2024, 01:33 PM #17Archived author: Ryan Turner • Posted: 2024-09-21T13:33:59.157000+00:00
Original source
Pretty sure is to know what's inside of a "wrapped" item
Original source
but those npc are there everytime?
rektbyfaith
09-21-2024, 01:34 PM #18Archived author: OUTRAKE • Posted: 2024-09-21T13:34:41.792000+00:00
Original source
but those npc are there everytime?
Original source
i just saw them today
rektbyfaith
09-21-2024, 01:34 PM #19Archived author: OUTRAKE • Posted: 2024-09-21T13:34:45.718000+00:00
Original source
i just saw them today