API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2018
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 27.46 KB | None | 0 0
raw download clone embed print report
  1. -- THIS IS FOR CUSTOM II
  2.  
  3. -- Nohr Helmet II
  4. SET @ItemID = 31111
  5. SET @ReplacementID = 31106
  6. SET @CustomID = 100209
  7. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  8. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  9. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  10. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  11. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  12. BEGIN
  13.     SET @Counter += 1
  14. END
  15. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  16.  
  17. -- Nohr Armor II
  18. SET @ItemID = 32111
  19. SET @ReplacementID = 32106
  20. SET @CustomID = 100209
  21. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  22. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  23. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  24. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  25. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  26. BEGIN
  27.     SET @Counter += 1
  28. END
  29. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  30.  
  31. -- Nohr Armor Earth II
  32. SET @ItemID = 32113
  33. SET @ReplacementID = 32108
  34. SET @CustomID = 100209
  35. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  36. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  37. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  38. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  39. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  40. BEGIN
  41.     SET @Counter += 1
  42. END
  43. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  44.  
  45. -- Nohr Armor Fire II
  46. SET @ItemID = 32115
  47. SET @ReplacementID = 32110
  48. SET @CustomID = 100209
  49. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  50. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  51. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  52. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  53. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  54. BEGIN
  55.     SET @Counter += 1
  56. END
  57. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  58.  
  59. -- Nohr Armor Water II
  60. SET @ItemID = 32112
  61. SET @ReplacementID = 32107
  62. SET @CustomID = 100209
  63. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  64. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  65. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  66. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  67. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  68. BEGIN
  69.     SET @Counter += 1
  70. END
  71. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  72.  
  73. -- Nohr Armor Wind II
  74. SET @ItemID = 32114
  75. SET @ReplacementID = 32109
  76. SET @CustomID = 100209
  77. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  78. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  79. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  80. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  81. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  82. BEGIN
  83.     SET @Counter += 1
  84. END
  85. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  86.  
  87. -- Nohr Pants II
  88. SET @ItemID = 33111
  89. SET @ReplacementID = 33106
  90. SET @CustomID = 100209
  91. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  92. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  93. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  94. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  95. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  96. BEGIN
  97.     SET @Counter += 1
  98. END
  99. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  100.  
  101. -- Nohr Gauntlets II
  102. SET @ItemID = 35111
  103. SET @ReplacementID = 35106
  104. SET @CustomID = 100209
  105. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  106. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  107. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  108. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  109. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  110. BEGIN
  111.     SET @Counter += 1
  112. END
  113. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  114.  
  115. -- Nohr Boots II
  116. SET @ItemID = 36111
  117. SET @ReplacementID = 36106
  118. SET @CustomID = 100209
  119. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  120. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  121. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  122. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  123. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  124. BEGIN
  125.     SET @Counter += 1
  126. END
  127. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  128.  
  129. -- THIS IS FOR CUSTOM III
  130.  
  131. -- Nohr Helmet III
  132. SET @ItemID = 31116
  133. SET @ReplacementID = 31106
  134. SET @CustomID = 100210
  135. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  136. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  137. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  138. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  139. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  140. BEGIN
  141.     SET @Counter += 1
  142. END
  143. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  144.  
  145. -- Nohr Armor III
  146. SET @ItemID = 32116
  147. SET @ReplacementID = 32106
  148. SET @CustomID = 100210
  149. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  150. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  151. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  152. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  153. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  154. BEGIN
  155.     SET @Counter += 1
  156. END
  157. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  158.  
  159. -- Nohr Armor Earth III
  160. SET @ItemID = 32118
  161. SET @ReplacementID = 32108
  162. SET @CustomID = 100210
  163. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  164. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  165. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  166. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  167. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  168. BEGIN
  169.     SET @Counter += 1
  170. END
  171. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  172.  
  173. -- Nohr Armor Fire III
  174. SET @ItemID = 32120
  175. SET @ReplacementID = 32110
  176. SET @CustomID = 100210
  177. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  178. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  179. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  180. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  181. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  182. BEGIN
  183.     SET @Counter += 1
  184. END
  185. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  186.  
  187. -- Nohr Armor Water III
  188. SET @ItemID = 32117
  189. SET @ReplacementID = 32107
  190. SET @CustomID = 100210
  191. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  192. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  193. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  194. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  195. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  196. BEGIN
  197.     SET @Counter += 1
  198. END
  199. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  200.  
  201. -- Nohr Armor Wind III
  202. SET @ItemID = 32119
  203. SET @ReplacementID = 32109
  204. SET @CustomID = 100210
  205. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  206. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  207. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  208. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  209. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  210. BEGIN
  211.     SET @Counter += 1
  212. END
  213. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  214.  
  215. -- Nohr Pants III
  216. SET @ItemID = 33116
  217. SET @ReplacementID = 33106
  218. SET @CustomID = 100210
  219. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  220. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  221. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  222. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  223. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  224. BEGIN
  225.     SET @Counter += 1
  226. END
  227. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  228.  
  229. -- Nohr Gauntlets III
  230. SET @ItemID = 36116
  231. SET @ReplacementID = 36106
  232. SET @CustomID = 100210
  233. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  234. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  235. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  236. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  237. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  238. BEGIN
  239.     SET @Counter += 1
  240. END
  241. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  242.  
  243. -- Nohr Boots III
  244. SET @ItemID = 36116
  245. SET @ReplacementID = 36106
  246. SET @CustomID = 100210
  247. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  248. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  249. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  250. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  251. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  252. BEGIN
  253.     SET @Counter += 1
  254. END
  255. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  256.  
  257. -- THIS IS FOR CUSTOM IV
  258.  
  259. -- Nohr Helmet IV
  260. SET @ItemID = 31121
  261. SET @ReplacementID = 31106
  262. SET @CustomID = 100202
  263. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  264. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  265. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  266. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  267. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  268. BEGIN
  269.     SET @Counter += 1
  270. END
  271. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  272.  
  273. -- Nohr Armor IV
  274. SET @ItemID = 32121
  275. SET @ReplacementID = 32106
  276. SET @CustomID = 100202
  277. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  278. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  279. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  280. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  281. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  282. BEGIN
  283.     SET @Counter += 1
  284. END
  285. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  286.  
  287. -- Nohr Armor Earth IV
  288. SET @ItemID = 32123
  289. SET @ReplacementID = 32108
  290. SET @CustomID = 100202
  291. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  292. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  293. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  294. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  295. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  296. BEGIN
  297.     SET @Counter += 1
  298. END
  299. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  300.  
  301. -- Nohr Armor Fire IV
  302. SET @ItemID = 32125
  303. SET @ReplacementID = 32110
  304. SET @CustomID = 100202
  305. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  306. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  307. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  308. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  309. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  310. BEGIN
  311.     SET @Counter += 1
  312. END
  313. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  314.  
  315. -- Nohr Armor Water IV
  316. SET @ItemID = 32122
  317. SET @ReplacementID = 32107
  318. SET @CustomID = 100202
  319. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  320. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  321. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  322. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  323. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  324. BEGIN
  325.     SET @Counter += 1
  326. END
  327. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  328.  
  329. -- Nohr Armor Wind IV
  330. SET @ItemID = 32124
  331. SET @ReplacementID = 32109
  332. SET @CustomID = 100202
  333. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  334. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  335. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  336. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  337. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  338. BEGIN
  339.     SET @Counter += 1
  340. END
  341. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  342.  
  343. -- Nohr Pants IV
  344. SET @ItemID = 33121
  345. SET @ReplacementID = 33106
  346. SET @CustomID = 100202
  347. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  348. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  349. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  350. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  351. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  352. BEGIN
  353.     SET @Counter += 1
  354. END
  355. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  356.  
  357. -- Nohr Gauntlets IV
  358. SET @ItemID = 35121
  359. SET @ReplacementID = 35106
  360. SET @CustomID = 100202
  361. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  362. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  363. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  364. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  365. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  366. BEGIN
  367.     SET @Counter += 1
  368. END
  369. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
  370.  
  371. -- Nohr Boots IV
  372. SET @ItemID = 36121
  373. SET @ReplacementID = 36106
  374. SET @CustomID = 100202
  375. SET @Count = (SELECT Count(*) FROM CharItems WHERE CharID = @CharID AND ItemID = @ItemID) + (SELECT Count(*) FROM UserStoredItems WHERE UserUID = @UserUID AND ItemID = @ItemID)
  376. UPDATE CharItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND CharID = @CharID
  377. UPDATE UserStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID AND UserUID = @UserUID
  378. UPDATE GuildStoredItems SET ItemID = @ReplacementID, Type = FLOOR(@ReplacementID / 1000), TypeID = FLOOR(@ReplacementID % 1000) WHERE ItemID = @ItemID
  379. WHILE (EXISTS (SELECT Slot FROM UserStoredPointItems WHERE UserUID = @UserUID AND Slot = @Counter))
  380. BEGIN
  381.     SET @Counter += 1
  382. END
  383. INSERT INTO UserStoredPointItems (UserUID, Slot, ItemID, ItemCount, BuyDate) VALUES (@UserUID, @Counter, @CustomID, @Count, GETDATE())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!