1. delete from k_Npcpos where zoneid = 21 and npcid =11032
   
2. delete from k_Npcpos where zoneid = 21 and npcid =21031
   
3. 
   
4. ------------------HumanGuard----------------------
   
5. 
   
6. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,430,308,430,308,430,308,430,308,1,60,0,0,'NULL')
   
7. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,432,308,432,308,432,308,432,308,1,60,0,0,'NULL')
   
8. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,434,308,434,308,434,308,434,308,1,60,0,0,'NULL')
   
9. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,436,308,436,308,436,308,436,308,1,60,0,0,'NULL')
   
10. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,438,308,438,308,438,308,438,308,1,60,0,0,'NULL')
    
11. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,440,308,440,308,440,308,440,308,1,60,0,0,'NULL')
    
12. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,442,308,442,308,442,308,442,308,1,60,0,0,'NULL')
    
13. 
    
14. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,430,305,430,306,430,306,430,306,1,60,0,0,'NULL')
    
15. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,432,305,432,306,432,306,432,306,1,60,0,0,'NULL')
    
16. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,434,305,434,306,434,306,434,306,1,60,0,0,'NULL')
    
17. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,436,305,436,306,436,306,436,306,1,60,0,0,'NULL')
    
18. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,438,305,438,306,438,306,438,306,1,60,0,0,'NULL')
    
19. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,440,305,440,306,440,306,440,306,1,60,0,0,'NULL')
    
20. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,442,305,442,306,442,306,442,306,1,60,0,0,'NULL')
    
21. 
    
22. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,430,303,430,304,430,304,430,304,1,60,0,0,'NULL')
    
23. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,432,303,432,304,432,304,432,304,1,60,0,0,'NULL')
    
24. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,434,303,434,304,434,304,434,304,1,60,0,0,'NULL')
    
25. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,436,303,436,304,436,304,436,304,1,60,0,0,'NULL')
    
26. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,438,303,438,304,438,304,438,304,1,60,0,0,'NULL')
    
27. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,440,303,440,304,440,304,440,304,1,60,0,0,'NULL')
    
28. INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,442,303,442,304,442,304,442,304,1,60,0,0,'NULL')
    
29. 
    
30. ------------------KarusGuard----------------------
    
31. 
    
32. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,430,300,430,300,430,300,430,300,1,60,0,0,'NULL')
    
33. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,432,300,432,300,432,300,432,300,1,60,0,0,'NULL')
    
34. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,434,300,434,300,434,300,434,300,1,60,0,0,'NULL')
    
35. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,436,300,436,300,436,300,436,300,1,60,0,0,'NULL')
    
36. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,438,300,438,300,438,300,438,300,1,60,0,0,'NULL')
    
37. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,440,300,440,300,440,300,440,300,1,60,0,0,'NULL')
    
38. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,442,300,442,300,442,300,442,300,1,60,0,0,'NULL')
    
39. 
    
40. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,430,297,430,297,430,297,430,297,1,60,0,0,'NULL')
    
41. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,432,297,432,297,432,297,432,297,1,60,0,0,'NULL')
    
42. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,434,297,434,297,434,297,434,297,1,60,0,0,'NULL')
    
43. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,436,297,436,297,436,297,436,297,1,60,0,0,'NULL')
    
44. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,438,297,438,297,438,297,438,297,1,60,0,0,'NULL')
    
45. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,440,297,440,297,440,297,440,297,1,60,0,0,'NULL')
    
46. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,442,297,442,297,442,297,442,297,1,60,0,0,'NULL')
    
47. 
    
48. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,430,294,430,294,430,294,430,294,1,60,0,0,'NULL')
    
49. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,432,294,432,294,432,294,432,294,1,60,0,0,'NULL')
    
50. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,434,294,434,294,434,294,434,294,1,60,0,0,'NULL')
    
51. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,436,294,436,294,436,294,436,294,1,60,0,0,'NULL')
    
52. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,438,294,438,294,438,294,438,294,1,60,0,0,'NULL')
    
53. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,440,294,440,294,440,294,440,294,1,60,0,0,'NULL')
    
54. INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,442,294,442,294,442,294,442,294,1,60,0,0,'NULL')
    
55. 
    
56. -------------------------Npcler-------------------------
    
57. update k_npc set iweapon1=120110000,iweapon2=170410000 where ssid=11032
    
58. update k_npc set iweapon1=120110000,iweapon2=170410000 where ssid=21031
    
59. delete from k_npc where ssid = 603
    
60. insert into [K_NPC] Values (603,'Chaotic Generator',30200,100,0,0,1,0,137,1,1,1,0,100,0,0,700000,0,0,15000,642,842,0,1000,0,0,1000,0,0,0,30000,30000,30000,30000,30000,30000,30000,100,5,5,5,0,603,0,0,0)
    
61. update k_Npc set spid=11610 where ssid=16011 and spid =11100
    
62. update k_npc set bygroup =2 where ssid=13006
    
63. update k_npc set strname  ='[Blacksmith] Heppa' where ssid=14301
    
64. update k_npc set strname = '[Sentinel]Patrick' where ssid=16011
    
65. update k_npc set strname = '[Operator] Moira' where ssid=16047
    
66. update k_npc set strname = '[InnKeeper] Naia' where ssid=22000
    
67. update k_npc set strname = '[InnKeeper] Laneia' where ssid = 12000
    
68. update k_npc set strname = '[Weapon Merchant]Gargameth' where ssid = 13008
    
69. update k_npc set strname = '[Armor Merchant]Nesta' where ssid =13006
    
70. update k_npc set strname = '[Merchant Daughter]Menissiah' where ssid =16079
    
71. delete from k_npcpos where npcid = 603
    
72. delete from k_npcpos where npcid = 13009 and zoneid=21
    
73. delete from k_npcpos where npcid = 13002 and zoneid=21
    
74. delete from k_npcpos where npcid = 13004 and zoneid=21
    
75. delete from k_npcpos where npcid = 16047 and zoneid=21
    
76. delete from k_npcpos where npcid = 13008 and zoneid=21
    
77. delete from k_npcpos where npcid = 13007 and zoneid=21
    
78. delete from k_npcpos where npcid = 13006 and zoneid=21
    
79. delete from k_npcpos where npcid = 22000 and zoneid=21
    
80. delete from k_npcpos where npcid = 13015 and zoneid=21
    
81. delete from k_npcpos where npcid = 16092 and zoneid=21
    
82. delete from k_npcpos where npcid = 14301 and zoneid=21
    
83. delete from k_npcpos where npcid = 16079 and zoneid=21
    
84. delete from k_npcpos where npcid = 13012 and zoneid=21
    
85. delete from k_npcpos where npcid = 12101 and zoneid=21
    
86. delete from k_npcpos where npcid = 13001 and zoneid=21
    
87. delete from k_npcpos where npcid = 521 and zoneid=21
    
88. delete from k_npcpos where npcid = 13013 and zoneid=21
    
89. delete from k_npcpos where npcid = 15002 and zoneid=21
    
90. delete from k_npcpos where npcid = 16046 and zoneid=21
    
91. delete from k_npcpos where npcid = 16083 and zoneid=21
    
92. delete from k_npcpos where npcid = 16071 and zoneid=21
    
93. delete from k_npcpos where npcid = 14401 and zoneid=21
    
94. delete from k_npcpos where npcid = 16087 and zoneid=21
    
95. delete from k_npcpos where npcid = 16011 and zoneid=21
    
96. delete from k_npcpos where npcid = 16086 and zoneid=21
    
97. delete from k_npcpos where npcid = 13014 and zoneid=21
    
98. delete from k_npcpos where npcid = 13011 and zoneid=21
    
99. INSERT INTO [k_npcpos] Values (21,603,100,0,0,0,0,273,453,273,453,273,453,273,453,1,10,0,0,'NULL')
    
100. INSERT INTO [k_npcpos] Values (21,13009,104,0,0,0,0,447,301,447,301,447,301,447,301,1,4400,0,11,'NULL')
     
101. INSERT INTO [k_npcpos] Values (21,16047,104,0,0,0,0,318,429,318,429,318,429,318,429,1,4400,0,11,'NULL')
     
102. INSERT INTO [k_npcpos] Values (21,13008,104,0,0,0,0,404,369,404,369,404,369,404,369,1,4400,0,11,'NULL')
     
103. INSERT INTO [k_npcpos] Values (21,13006,104,0,0,0,0,404,363,404,363,404,363,404,363,1,4400,0,11,'NULL')
     
104. INSERT INTO [k_npcpos] Values (21,22000,104,0,0,0,0,394,402,394,402,394,402,394,402,1,4400,0,11,'NULL')
     
105. INSERT INTO [k_npcpos] Values (21,13007,104,0,0,0,0,381,316,381,316,381,316,381,316,1,4400,0,11,'NULL')
     
106. INSERT INTO [k_npcpos] Values (21,14301,104,0,0,0,0,371,362,371,362,371,362,371,362,1,4400,0,11,'NULL')
     
107. INSERT INTO [k_npcpos] Values (21,16079,104,0,0,0,0,304,354,304,354,304,354,304,354,1,4400,0,11,'NULL')
     
108. INSERT INTO [k_npcpos] Values (21,13001,104,0,0,0,0,281,438,281,438,281,438,281,438,1,4400,0,11,'NULL')
     
109. INSERT INTO [k_npcpos] Values (21,521,104,0,0,0,0,464,274,464,274,464,274,464,274,1,4400,0,11,'NULL')
     
110. INSERT INTO [k_npcpos] Values (21,13013,104,0,0,0,0,465,314,465,314,465,314,465,314,1,4400,0,11,'NULL')
     
111. INSERT INTO [k_npcpos] Values (21,15002,104,0,0,0,0,345,464,345,464,345,464,345,464,1,4400,0,11,'NULL')
     
112. INSERT INTO [k_npcpos] Values (21,16046,104,0,0,0,0,341,445,341,445,341,445,341,445,1,4400,0,11,'NULL')
     
113. INSERT INTO [k_npcpos] Values (21,16083,104,0,0,0,0,427,454,427,454,427,454,427,454,1,4400,0,11,'NULL')
     
114. INSERT INTO [k_npcpos] Values (21,16071,104,0,0,0,0,371,422,371,422,371,422,371,422,1,4400,0,11,'NULL')
     
115. INSERT INTO [k_npcpos] Values (21,14401,104,0,0,0,0,248,442,248,442,248,442,248,442,1,4400,0,11,'NULL')
     
116. INSERT INTO [k_npcpos] Values (21,16087,104,0,0,0,0,253,451,253,451,253,451,253,451,1,4400,0,11,'NULL')
     
117. INSERT INTO [k_npcpos] Values (21,16011,104,0,0,0,0,316,343,316,343,316,343,316,343,1,4400,0,11,'NULL')
     
118. INSERT INTO [k_npcpos] Values (21,16086,104,0,0,0,0,308,397,308,397,308,397,308,397,1,4400,0,11,'NULL')
     
119. INSERT INTO [k_npcpos] Values (21,13014,104,0,0,0,0,309,404,309,404,309,404,309,404,1,4400,0,11,'NULL')

复制代码

这个用在1299上会怎么样