Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- replace into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
- values ('993311', "Bob", "Automated Vending Machine", '', '0', '7', '0', '3', '0', '0', '20023', '20023', '20023', '20023', '1', '1', '0', '0');
- replace into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `RespawnTime`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`)
- values ('993311', '99', '99', '35', '100000000', '100000000', '99999', '1', '4225', '500', '0', '99999', '99999', '0', '0', '0', '5000', '666', '666', '666', '666', '666', '666', '0', '0', "0", '1', '100000', '0', '0', '2.50', '8.00', '14.00', '0');
- replace into `npc_text` values (44333220, 1, 'Hello, $N, I\'m an AVM - Automated Vending Machine. Please tell me what item you are looking for, and I will find it for you.', 'Hello, $N, I\'m an AVM - Automated Vending Machine. Please tell me what item you are looking for, and I will find it for you.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0), (44333221, 1, 'I\'ve found the item you were looking for.', 'I\'ve found the item you were looking for.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0);
- CREATE TABLE `avm_banned_items`(
- `entry` int(10) UNSIGNED NOT NULL,
- PRIMARY KEY (entry)) TYPE=MyISAM;
- replace into `avm_banned_items` values (192), (17), (12947);
Advertisement
Add Comment
Please, Sign In to add comment
