Guest User

Fake NPCs SQL Side

a guest
Oct 12th, 2010
1,794
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.46 KB | None | 0 0
  1.  
  2.  
  3. SET FOREIGN_KEY_CHECKS=0;
  4. -- ----------------------------
  5. -- Table structure for `fake_pcs`
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `fake_pcs`;
  8. CREATE TABLE `fake_pcs` (
  9. `npc_id` int(11) NOT NULL,
  10. `race` int(11) NOT NULL DEFAULT '0',
  11. `sex` int(11) NOT NULL DEFAULT '0',
  12. `class` int(11) NOT NULL DEFAULT '0',
  13. `title` varchar(255) NOT NULL,
  14. `title_color` int(11) NOT NULL DEFAULT '0',
  15. `name` varchar(255) NOT NULL,
  16. `name_color` int(11) NOT NULL DEFAULT '0',
  17. `hair_style` int(11) NOT NULL DEFAULT '0',
  18. `hair_color` int(11) NOT NULL DEFAULT '0',
  19. `face` int(11) NOT NULL DEFAULT '0',
  20. `mount` tinyint(4) NOT NULL DEFAULT '0',
  21. `team` tinyint(4) NOT NULL DEFAULT '0',
  22. `hero` tinyint(4) NOT NULL DEFAULT '0',
  23. `pd_under` int(11) NOT NULL DEFAULT '0',
  24. `pd_under_aug` int(11) NOT NULL DEFAULT '0',
  25. `pd_head` int(11) NOT NULL DEFAULT '0',
  26. `pd_head_aug` int(11) NOT NULL DEFAULT '0',
  27. `pd_rhand` int(11) NOT NULL DEFAULT '0',
  28. `pd_rhand_aug` int(11) NOT NULL DEFAULT '0',
  29. `pd_lhand` int(11) NOT NULL DEFAULT '0',
  30. `pd_lhand_aug` int(11) NOT NULL DEFAULT '0',
  31. `pd_gloves` int(11) NOT NULL DEFAULT '0',
  32. `pd_gloves_aug` int(11) NOT NULL DEFAULT '0',
  33. `pd_chest` int(11) NOT NULL DEFAULT '0',
  34. `pd_chest_aug` int(11) NOT NULL DEFAULT '0',
  35. `pd_legs` int(11) NOT NULL DEFAULT '0',
  36. `pd_legs_aug` int(11) NOT NULL DEFAULT '0',
  37. `pd_feet` int(11) NOT NULL DEFAULT '0',
  38. `pd_feet_aug` int(11) NOT NULL DEFAULT '0',
  39. `pd_back` int(11) NOT NULL DEFAULT '0',
  40. `pd_back_aug` int(11) NOT NULL DEFAULT '0',
  41. `pd_lrhand` int(11) NOT NULL DEFAULT '0',
  42. `pd_lrhand_aug` int(11) NOT NULL DEFAULT '0',
  43. `pd_hair` int(11) NOT NULL DEFAULT '0',
  44. `pd_hair_aug` int(11) NOT NULL DEFAULT '0',
  45. `pd_hair2` int(11) NOT NULL DEFAULT '0',
  46. `pd_hair2_aug` int(11) NOT NULL DEFAULT '0',
  47. `pd_rbracelet` int(11) NOT NULL DEFAULT '0',
  48. `pd_rbracelet_aug` int(11) NOT NULL DEFAULT '0',
  49. `pd_lbracelet` int(11) NOT NULL DEFAULT '0',
  50. `pd_lbracelet_aug` int(11) NOT NULL DEFAULT '0',
  51. `pd_deco1` int(11) NOT NULL DEFAULT '0',
  52. `pd_deco1_aug` int(11) NOT NULL DEFAULT '0',
  53. `pd_deco2` int(11) NOT NULL DEFAULT '0',
  54. `pd_deco2_aug` int(11) NOT NULL DEFAULT '0',
  55. `pd_deco3` int(11) NOT NULL DEFAULT '0',
  56. `pd_deco3_aug` int(11) NOT NULL DEFAULT '0',
  57. `pd_deco4` int(11) NOT NULL DEFAULT '0',
  58. `pd_deco4_aug` int(11) NOT NULL DEFAULT '0',
  59. `pd_deco5` int(11) NOT NULL DEFAULT '0',
  60. `pd_deco5_aug` int(11) NOT NULL DEFAULT '0',
  61. `pd_deco6` int(11) NOT NULL DEFAULT '0',
  62. `pd_deco6_aug` int(11) NOT NULL DEFAULT '0',
  63. `enchant_effect` tinyint(4) NOT NULL DEFAULT '0',
  64. `pvp_flag` int(11) NOT NULL DEFAULT '0',
  65. `karma` int(11) NOT NULL DEFAULT '0',
  66. `fishing` tinyint(4) NOT NULL DEFAULT '0',
  67. `fishing_x` int(11) NOT NULL DEFAULT '0',
  68. `fishing_y` int(11) NOT NULL DEFAULT '0',
  69. `fishing_z` int(11) NOT NULL DEFAULT '0',
  70. `invisible` tinyint(4) NOT NULL DEFAULT '1',
  71. PRIMARY KEY (`npc_id`)
  72. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  73.  
  74. -- ----------------------------
  75. -- Records of fake_pcs
  76. -- ----------------------------
  77. INSERT INTO `fake_pcs` VALUES ('60001', '4', '1', '53', '~ L2BlaBlaBla ~', '60463', 'PK-Killer', '60463', '5', '3', '1', '0', '0', '1', '0', '0', '0', '0', '16015', '1', '0', '0', '15582', '0', '16169', '0', '15579', '0', '15585', '0', '14609', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '30', '0', '0', '0', '0', '0', '0', '0');
Advertisement
Add Comment
Please, Sign In to add comment