API tools faq
paste
Guest User

Untitled

a guest
Jul 14th, 2018
75
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 8.38 KB | None | 0 0
raw download clone embed print report
  1. [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_' at line 1
  2. [Err] ?REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (550000, 0, 0, 0, 0, 0, 22918, 0, 22918, 0, 'Alchemy', 'Trade Goods', '', 0, 83, 83, 0, 35, 35, 4224, 2, 2, 1, 2, 50, 150, 0, 1000, 1000, 2000, 1500, 2, 2, 0, 0, 0, 0, 0, 0, 100, 250, 1000, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 0, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5245, 0, 2, '', 12340);
  3.  
  4.  
  5. DELETE FROM `npc_vendor` WHERE (`entry`=550000);
  6. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
  7. (550000,0,2447,0,0,0),
  8. (550000,0,2449,0,0,0),
  9. (550000,0,2452,0,0,0),
  10. (550000,0,2450,0,0,0),
  11. (550000,0,6358,0,0,0),
  12. (550000,0,765,0,0,0),
  13. (550000,0,785,0,0,0),
  14. (550000,0,3164,0,0,0),
  15. (550000,0,5635,0,0,0),
  16. (550000,0,3820,0,0,0),
  17. (550000,0,6370,0,0,0),
  18. (550000,0,2453,0,0,0),
  19. (550000,0,3372,0,0,0),
  20. (550000,0,3818,0,0,0),
  21. (550000,0,5637,0,0,0),
  22. (550000,0,6522,0,0,0),
  23. (550000,0,1288,0,0,0),
  24. (550000,0,6371,0,0,0),
  25. (550000,0,4402,0,0,0),
  26. (550000,0,3821,0,0,0),
  27. (550000,0,3357,0,0,0),
  28. (550000,0,4625,0,0,0),
  29. (550000,0,8831,0,0,0),
  30. (550000,0,7067,0,0,0),
  31. (550000,0,9262,0,0,0),
  32. (550000,0,3358,0,0,0),
  33. (550000,0,9260,0,0,0),
  34. (550000,0,8925,0,0,0),
  35. (550000,0,7972,0,0,0),
  36. (550000,0,8153,0,0,0),
  37. (550000,0,8836,0,0,0),
  38. (550000,0,8839,0,0,0),
  39. (550000,0,13422,0,0,0),
  40. (550000,0,13463,0,0,0),
  41. (550000,0,7080,0,0,0),
  42. (550000,0,8845,0,0,0),
  43. (550000,0,8846,0,0,0),
  44. (550000,0,13423,0,0,0),
  45. (550000,0,13466,0,0,0),
  46. (550000,0,7082,0,0,0),
  47. (550000,0,13467,0,0,0),
  48. (550000,0,11176,0,0,0),
  49. (550000,0,13468,0,0,0),
  50. (550000,0,13465,0,0,0),
  51. (550000,0,13464,0,0,0),
  52. (550000,0,10286,0,0,0),
  53. (550000,0,7077,0,0,0),
  54. (550000,0,22785,0,0,0),
  55. (550000,0,22787,0,0,0),
  56. (550000,0,22792,0,0,0),
  57. (550000,0,22790,0,0,0),
  58. (550000,0,23571,0,0,0),
  59. (550000,0,22791,0,0,0),
  60. (550000,0,22786,0,0,0),
  61. (550000,0,36907,0,0,0),
  62. (550000,0,22794,0,0,0),
  63. (550000,0,22789,0,0,0),
  64. (550000,0,22901,0,0,0),
  65. (550000,0,22793,0,0,0),
  66. (550000,0,40199,0,0,0),
  67. (550000,0,37921,0,0,0),
  68. (550000,0,39970,0,0,0),
  69. (550000,0,36906,0,0,0),
  70. (550000,0,36905,0,0,0),
  71. (550000,0,36908,0,0,0),
  72. (550000,0,41814,0,0,0),
  73. (550000,0,36904,0,0,0),
  74. (550000,0,36903,0,0,0),
  75. (550000,0,40411,0,0,0),
  76. (550000,0,18256,0,0,0),
  77. (550000,0,33448,0,0,0),
  78. (550000,0,33447,0,0,0),
  79. (550000,0,3371,0,0,0),
  80. (550000,0,40195,0,0,0),
  81. (550000,0,36901,0,0,0);
  82.  
  83.  
  84. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_cl
  85. [Err] 1062 - Duplicate entry '552000-2934-0' for key 'PRIMARY'
  86. [Err] INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
  87. (552000,0,2934,0,0,0),
  88. (552000,0,2320,0,0,0),
  89. (552000,0,4231,0,0,0),
  90. (552000,0,6470,0,0,0),
  91. (552000,0,4232,0,0,0),
  92. (552000,0,2318,0,0,0),
  93. (552000,0,5082,0,0,0),
  94. (552000,0,5498,0,0,0),
  95. (552000,0,2319,0,0,0),
  96. (552000,0,7286,0,0,0),
  97. (552000,0,6471,0,0,0),
  98. (552000,0,4234,0,0,0),
  99. (552000,0,4236,0,0,0),
  100. (552000,0,7392,0,0,0),
  101. (552000,0,4304,0,0,0),
  102. (552000,0,4223,0,0,0),
  103. (552000,0,5637,0,0,0),
  104. (552000,0,4461,0,0,0),
  105. (552000,0,8169,0,0,0),
  106. (552000,0,8167,0,0,0),
  107. (552000,0,8172,0,0,0),
  108. (552000,0,8154,0,0,0),
  109. (552000,0,15412,0,0,0),
  110. (552000,0,12803,0,0,0),
  111. (552000,0,7075,0,0,0),
  112. (552000,0,8171,0,0,0),
  113. (552000,0,8170,0,0,0),
  114. (552000,0,7081,0,0,0),
  115. (552000,0,7078,0,0,0),
  116. (552000,0,8165,0,0,0),
  117. (552000,0,15408,0,0,0),
  118. (552000,0,15417,0,0,0),
  119. (552000,0,21887,0,0,0),
  120. (552000,0,25700,0,0,0),
  121. (552000,0,15416,0,0,0),
  122. (552000,0,15407,0,0,0),
  123. (552000,0,12810,0,0,0),
  124. (552000,0,25649,0,0,0),
  125. (552000,0,12753,0,0,0),
  126. (552000,0,15414,0,0,0),
  127. (552000,0,15415,0,0,0),
  128. (552000,0,22457,0,0,0),
  129. (552000,0,23793,0,0,0),
  130. (552000,0,33567,0,0,0),
  131. (552000,0,23571,0,0,0),
  132. (552000,0,22452,0,0,0),
  133. (552000,0,25699,0,0,0),
  134. (552000,0,29547,0,0,0),
  135. (552000,0,29539,0,0,0),
  136. (552000,0,17056,0,0,0),
  137. (552000,0,29548,0,0,0),
  138. (552000,0,33568,0,0,0),
  139. (552000,0,38558,0,0,0),
  140. (552000,0,38561,0,0,0),
  141. (552000,0,25707,0,0,0),
  142. (552000,0,38425,0,0,0),
  143. (552000,0,44128,0,0,0),
  144. (552000,0,38557,0,0,0);
  145.  
  146. REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (553000, 0, 0, 0, 0, 0, 22918, 0, 22918, 0, 'Other', 'Trade Goods', '', 0, 83, 83, 0, 35, 35, 4224, 2, 2, 1, 2, 50, 150, 0, 1000, 1000, 2000, 1500, 2, 2, 0, 0, 0, 0, 0, 0, 100, 250, 1000, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 0, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5245, 0, 2, '', 12340);
  147.  
  148.  
  149. DELETE FROM `npc_vendor` WHERE (`entry`=553000);
  150. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
  151.  
  152. (553000,0,34055,0,0,0),
  153. (553000,0,35623,0,0,0),
  154. (553000,0,35625,0,0,0),
  155. (553000,0,36781,0,0,0),
  156. (553000,0,37145,0,0,0),
  157. (553000,0,35622,0,0,0),
  158. (553000,0,35624,0,0,0),
  159. (553000,0,35627,0,0,0),
  160. (553000,0,36860,0,0,0),
  161. (553000,0,37147,0,0,0),
  162. (553000,0,43104,0,0,0),
  163. (553000,0,43106,0,0,0),
  164. (553000,0,43108,0,0,0),
  165. (553000,0,44142,0,0,0),
  166. (553000,0,44163,0,0,0),
  167. (553000,0,44958,0,0,0),
  168. (553000,0,45909,0,0,0),
  169. (553000,0,47556,0,0,0),
  170. (553000,0,37159,0,0,0),
  171. (553000,0,37164,0,0,0),
  172. (553000,0,37700,0,0,0),
  173. (553000,0,37702,0,0,0),
  174. (553000,0,37704,0,0,0),
  175. (553000,0,37160,0,0,0),
  176. (553000,0,37168,0,0,0),
  177. (553000,0,37701,0,0,0),
  178. (553000,0,37703,0,0,0),
  179. (553000,0,37705,0,0,0),
  180. (553000,0,43105,0,0,0),
  181. (553000,0,43107,0,0,0),
  182. (553000,0,43109,0,0,0),
  183. (553000,0,44161,0,0,0),
  184. (553000,0,44316,0,0,0),
  185. (553000,0,45087,0,0,0),
  186. (553000,0,23572,
  187. [Msg] Finished - Unsuccessfully
  188. --------------------------------------------------
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!