Code:
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (500532,2,8,-1,"The Raging Pain of Vindictus","The Raging Pain of Vindictus","The Raging Pain of Vindictus","The Raging Pain of Vindictus",32603,6,0,1111111,110101,17,-1,-1,75,70,0,0,0,0,0,0,0,2,0,0,4,450,3,450,5,450,6,45 0,7,450,0,0,0,0,0,0,0,0,0,0,500,1000,0,500,500,2,0 ,0,0,0,0,0,0,0,0,0,105,105,105,105,105,105,1000,0, 0,17713,1,0,0,0,0,34696,2,0,0,0,0,34696,2,0,0,0,0, 17713,1,0,0,0,0,18060,1,0,0,0,0,0,"Can you stand before the awsome might??",0,0,0,0,0,1,2,0,0,0,0,9000,0,0,0,0,1,0,1, 0,1,0,0,0,0,0,0);
Code:
INSERT INTO `gameobject_names` VALUES ('9999992', '18', '1327', 'customportal', '3', '7720', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `gameobject_names` VALUES ('9999993', '18', '1327', 'customportal2', '3', '7720', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8716.14', '679.053', '74.4064', '5.39409', '0', '0', '0.43005', '-0.902805', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8715.11', '679.797', '74.4061', '5.41765', '0', '0', '0.419383', '-0.907809', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8713.51', '681.408', '74.4071', '5.41532', '0', '0', '0.420443', '-0.907319', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8712.8', '681.983', '74.4071', '5.37213', '0', '0', '0.439938', '-0.898028', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8711.63', '682.928', '74.4061', '5.37605', '0', '0', '0.438175', '-0.89889', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8710.86', '683.511', '74.406', '5.32501', '0', '0', '0.460972', '-0.887415', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8710.21', '684.137', '74.406', '5.38784', '0', '0', '0.432869', '-0.901457', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8709.06', '684.482', '74.4052', '4.94016', '0', '0', '0.622169', '-0.782883', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8714.14', '680.528', '77.0491', '5.47817', '0', '0', '0.391727', '-0.920082', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8717.2', '678.861', '78.0422', '6.02009', '0', '0', '0.131169', '-0.99136', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8716.23', '679.468', '78.042', '5.5999', '0', '0', '0.335034', '-0.942206', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8713.19', '681.841', '79.0907', '5.21113', '0', '0', '0.510727', '-0.859743', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8711.05', '683.459', '78.0973', '3.33403', '0', '0', '0.995375', '-0.0960683', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8710.04', '684.432', '78.0412', '5.46245', '0', '0', '0.398946', '-0.916975', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8709.48', '685.054', '77.9422', '4.99122', '0', '0', '0.601984', '-0.798508', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8709.17', '684.769', '78.1107', '5.09725', '0', '0', '0.558826', '-0.829285', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8703.22', '645.718', '73.0777', '0.603977', '0', '0', '0.297419', '0.954747', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8704.45', '647.375', '73.1025', '0.721786', '0', '0', '0.35311', '0.935582', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8705.16', '648.275', '73.1024', '0.749275', '0', '0', '0.365935', '0.93064', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8706.44', '649.822', '73.0907', '0.717858', '0', '0', '0.351272', '0.936274', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8707.82', '651.422', '73.0725', '0.639321', '0', '0', '0.314244', '0.949342', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8709.16', '653.07', '73.0714', '0.109176', '0', '0', '0.0545611', '0.99851', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8704.21', '646.279', '76.3532', '0.702148', '0', '0', '0.343906', '0.939004', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8705.04', '646.659', '76.6732', '0.772833', '0', '0', '0.376872', '0.926265', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8705.95', '647.491', '76.6432', '0.827811', '0', '0', '0.402188', '0.915557', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8706.82', '648.854', '76.361', '0.729636', '0', '0', '0.356779', '0.934189', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8708.31', '650.7', '76.5015', '0.651096', '0', '0', '0.319828', '0.947476', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8709.86', '653.079', '76.7069', '0.00706482', '0', '0', '0.0035324', '0.999994', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8680.43', '663.898', '73.1358', '3.29003', '0', '0', '0.997247', '-0.0741526', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8681.49', '665.243', '73.1324', '3.63954', '0', '0', '0.969166', '-0.246408', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8682.82', '667.068', '73.0975', '3.79269', '0', '0', '0.947476', '-0.319828', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8683.81', '668.177', '73.128', '3.73378', '0', '0', '0.956483', '-0.291788', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8682.6', '668.217', '76.3863', '3.42828', '0', '0', '0.989744', '-0.142853', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '147516', '0', '-8681.67', '667.206', '76.5316', '3.71888', '0', '0', '0.958631', '-0.284652', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '9999992', '0', '-8675.42', '634.436', '96.95', '5.38075', '0', '0', '0.436063', '-0.899916', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '9999993', '0', '-8711.13', '679.3', '74.4065', '2.22661', '0', '0', '0.897162', '0.441701', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '169243', '0', '-8632.49', '579.832', '95.6913', '2.09597', '0', '0', '0.866418', '0.499319', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '169243', '0', '-8628.19', '623.863', '95.6908', '3.76729', '0', '0', '0.95146', '-0.307772', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('', '169243', '0', '-8671.31', '587.645', '95.6909', '0.654198', '0', '0', '0.321297', '0.946978', '1', '0', '0', '1', '0');
INSERT INTO `creature_spawns` VALUES ('', '2761', '0', '-8683.02', '639.638', '74.4118', '2.302', '0', '5561', '16', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '2761', '0', '-8678.94', '642.875', '74.4139', '2.27451', '0', '5561', '16', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '11782', '0', '-8649.96', '602.145', '93.1699', '2.235', '0', '11711', '134', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '11782', '0', '-8664.71', '620.881', '84.1911', '2.24285', '0', '11711', '134', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '2761', '0', '-8690.31', '652.508', '74.4065', '2.23971', '0', '5561', '16', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '2761', '0', '-8699.12', '652.547', '74.4065', '1.514', '0', '5561', '16', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '2761', '0', '-8686.74', '662.569', '74.4065', '3.11229', '0', '5561', '16', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '6239', '0', '-8643.62', '624.22', '95.6914', '4.45216', '0', '5187', '91', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '6239', '0', '-8635.39', '625.355', '95.6914', '4.30137', '0', '5187', '91', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '6239', '0', '-8627.81', '618.665', '95.6914', '3.67933', '0', '5187', '91', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '6239', '0', '-8626', '610.902', '95.6914', '3.15469', '0', '5187', '91', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '11782', '0', '-8639.33', '580.84', '95.691', '2.14335', '0', '11711', '134', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '11782', '0', '-8631.21', '586.649', '95.691', '2.28787', '0', '11711', '134', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '11782', '0', '-8635.32', '583.66', '95.691', '2.16534', '0', '11711', '134', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '4339', '0', '-8644.45', '596.716', '95.7063', '2.16376', '0', '6374', '103', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '741', '0', '-8629.63', '594.097', '95.6915', '2.73946', '0', '621', '50', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '2761', '0', '-8671.52', '629.599', '80.0425', '2.22739', '0', '5561', '16', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '2761', '0', '-8656.72', '611.314', '88.8754', '2.24781', '0', '5561', '16', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '741', '0', '-8645.38', '581.273', '95.6915', '1.67053', '0', '621', '50', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '741', '0', '-8633.17', '591.402', '95.6915', '2.2321', '0', '621', '50', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '741', '0', '-8641.28', '585.095', '95.6915', '2.30278', '0', '621', '50', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '741', '0', '-8631.14', '622.238', '95.6915', '3.84531', '0', '621', '50', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '744', '0', '-8695.49', '659.54', '74.4066', '2.21245', '0', '7903', '50', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '744', '0', '-8662.04', '582.762', '95.6904', '0.694254', '0', '7903', '50', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '744', '0', '-8673.49', '598.159', '95.6904', '0.678545', '0', '7903', '50', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '744', '0', '-8663.6', '586.056', '95.6904', '0.698967', '0', '7903', '50', '0', '0', '0', '0', '0');
INSERT INTO `creature_spawns` VALUES ('', '744', '0', '-8670.7', '594.505', '95.6904', '0.636135', '0', '7903', '50', '0', '0', '0', '0', '0');
AND GM SCRIPTS TO MAKE IT ALL WORK: