API tools faq
paste
Advertisement
Sansuall

Ачивы/бонусы за пве ладдер 2023-2024

Sansuall
Oct 6th, 2024 (edited)
182
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 11.75 KB | None | 0 0
raw download clone embed print report
  1. -- ПЕРСОНАЛЬНЫЙ РЕЙТИНГ:
  2. UPDATE TBonuses SET fcount = fcount + 7000 WHERE f_account IN (4730810);
  3. UPDATE TBonuses SET fcount = fcount + 4000 WHERE f_account IN (7195052, 1409240, 5851298, 4317043, 6397819);
  4. UPDATE TBonuses SET fcount = fcount + 2000 WHERE f_account IN (4306006, 7270915, 2039984, 3633716, 7392838, 7392845, 5174498, 6430640, 7290241, 3896648, 2808542, 7227304);
  5. UPDATE TBonuses SET fcount = fcount + 1000 WHERE f_account IN (213986, 6149753, 7394057, 6122353, 6934389, 7396730, 7294499, 5304712, 6837271, 6931419, 7076172, 7012355, 7387760, 6860737, 4155751, 6338316, 7354603, 6891715, 5823594, 7353886, 6260422);
  6.  
  7.  
  8. --НАКСРАМАС 3 место:
  9. UPDATE TBonuses SET fcount = fcount + 2200 WHERE f_account IN (4301901, 6878482, 5383680, 2377549, 6909013, 6984848, 5900405, 2422081, 6846550, 6981327, 5213625, 7055913, 4155751, 7151855, 7116257, 2641072, 7210392, 7264135, 155719, 3366222, 5692610, 1452912, 6759053, 4700491, 4538880, 3932169, 5977994, 2999474, 6813244, 5220731, 6834785, 6122353, 5272621, 6245676, 2464567, 2744794, 6496274, 6788146, 5207533, 5211421, 6051794);
  10.  
  11.  
  12. -- МНЗХ 1 место:
  13. UPDATE TBonuses SET fcount = fcount + 2000 WHERE f_account IN (221370, 319493, 1242235, 2405255, 4494733, 7244610, 3427457, 6122353, 4306006, 6549609, 5117628, 4691995, 6970334, 873847, 3242503, 6895842, 6575069, 4979340, 6797024, 6801148, 4387702, 2346536, 4071498, 822163, 7434850);
  14.  
  15.  
  16. -- КЛЮЧИ 2-3места
  17.  
  18. -- Второе место:
  19. UPDATE TBonuses SET fcount = fcount + 2000 WHERE f_account IN (5045543, 6130382, 6299681, 7460001, 3283396, 6556133, 5167052, 1329699, 3988333, 5903498, 7169064);
  20. UPDATE TBonuses SET fcount = fcount + 4000 WHERE f_account IN (4378153);
  21. UPDATE TBonuses SET fcount = fcount + 6000 WHERE f_account IN (6780686);
  22. UPDATE TBonuses SET fcount = fcount + 6000 WHERE f_account IN (6758447);
  23. UPDATE TBonuses SET fcount = fcount + 8000 WHERE f_account IN (4342560);
  24. UPDATE TBonuses SET fcount = fcount + 10000 WHERE f_account IN (6549609);
  25. UPDATE TBonuses SET fcount = fcount + 12000 WHERE f_account IN (3461982, 2400513);
  26.  
  27. -- Третье место:
  28. UPDATE TBonuses SET fcount = fcount + 1600 WHERE f_account IN (2405255, 1675172, 2727401, 4700491, 4306006, 7075191);
  29. UPDATE TBonuses SET fcount = fcount + 4800 WHERE f_account IN (7106950);
  30. UPDATE TBonuses SET fcount = fcount + 6400 WHERE f_account IN (4251976);
  31. UPDATE TBonuses SET fcount = fcount + 9600 WHERE f_account IN (3988333);
  32. UPDATE TBonuses SET fcount = fcount + 11200 WHERE f_account IN (5167052, 1329699, 5903498);
  33.  
  34.  
  35. -- ЦЛК/НАКС/САНВЕЛ
  36. -- Выбрали бонусы вместо денег, либо не успели отправить реквизиты в установленный срок:
  37.  
  38. -- х5/х100/x1
  39. UPDATE TBonuses SET fcount = fcount + 19500 WHERE f_account IN (6895842, 6970334);
  40. UPDATE TBonuses SET fcount = fcount + 18460 WHERE f_account IN (4979340);
  41. UPDATE TBonuses SET fcount = fcount + 15600 WHERE f_account IN (4563742);
  42. UPDATE TBonuses SET fcount = fcount + 11700 WHERE f_account IN (5689731);
  43. UPDATE TBonuses SET fcount = fcount + 9100 WHERE f_account IN (6150901, 6798944);
  44. UPDATE TBonuses SET fcount = fcount + 8060 WHERE f_account IN (4301901, 7264135, 6878482, 2641072);
  45. UPDATE TBonuses SET fcount = fcount + 7800 WHERE f_account IN (6496653);
  46. UPDATE TBonuses SET fcount = fcount + 6500 WHERE f_account IN (5414356, 7460001, 3003369, 3896648, 2871988, 3529927, 4076072, 6223193, 7036719, 5178845, 6857584, 3981515);
  47. UPDATE TBonuses SET fcount = fcount + 5200 WHERE f_account IN (7136496, 6837271, 6999032, 7013026, 7320245, 6919338);
  48. UPDATE TBonuses SET fcount = fcount + 4290 WHERE f_account IN (6759053, 4700491, 1452912, 4538880, 5977994, 2999474, 6813244, 6834785, 6122353, 5272621, 6245676, 2464567, 2744794, 6496274, 6788146, 5207533, 5211421, 6051794, 3820038, 4542068, 6509997);
  49. UPDATE TBonuses SET fcount = fcount + 3900 WHERE f_account IN (6842955);
  50. UPDATE TBonuses SET fcount = fcount + 2860 WHERE f_account IN (3366222, 7210392, 7151855, 7055913, 6981327, 2422081, 6984848, 5383680, 2377549, 5692610);
  51.  
  52.  
  53. -- ВЫДАЧА АЧИВ
  54.  
  55. -- x5 WOTLK
  56. -- https://wowroad.info/?achievement=4576 (ЦЛК 1 место)
  57. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (179394, 4576, 1728122400);
  58. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (442334, 4576, 1728122400);
  59. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (924975, 4576, 1728122400);
  60. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (2793862, 4576, 1728122400);
  61. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (3905845, 4576, 1728122400);
  62. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (4383266, 4576, 1728122400);
  63. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (4718729, 4576, 1728122400);
  64. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5088120, 4576, 1728122400);
  65. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5488925, 4576, 1728122400);
  66. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5601212, 4576, 1728122400);
  67. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5646977, 4576, 1728122400);
  68. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5822644, 4576, 1728122400);
  69. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5883609, 4576, 1728122400);
  70. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6496746, 4576, 1728122400);
  71. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6578371, 4576, 1728122400);
  72. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7025320, 4576, 1728122400);
  73. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7630107, 4576, 1728122400);
  74. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7878892, 4576, 1728122400);
  75. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7932950, 4576, 1728122400);
  76. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8102358, 4576, 1728122400);
  77. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8435662, 4576, 1728122400);
  78. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8529997, 4576, 1728122400);
  79. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8560403, 4576, 1728122400);
  80. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8641626, 4576, 1728122400);
  81. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (9206601, 4576, 1728122400);
  82.  
  83. -- x100 WOTLK
  84. -- https://wowroad.info/?achievement=1402 (НАКС 1 место)
  85. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (5510312, 1402, 1728122400);
  86. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6321685, 1402, 1728122400);
  87. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6697162, 1402, 1728122400);
  88. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7478275, 1402, 1728122400);
  89. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7494220, 1402, 1728122400);
  90. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7810204, 1402, 1728122400);
  91. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8519220, 1402, 1728122400);
  92. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8541990, 1402, 1728122400);
  93. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (14375405, 1402, 1728122400);
  94. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (21150694, 1402, 1728122400);
  95. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (21433666, 1402, 1728122400);
  96. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (22796727, 1402, 1728122400);
  97. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (26214507, 1402, 1728122400);
  98. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (27997356, 1402, 1728122400);
  99. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28090267, 1402, 1728122400);
  100. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28324304, 1402, 1728122400);
  101. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28453929, 1402, 1728122400);
  102. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28665720, 1402, 1728122400);
  103. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28668297, 1402, 1728122400);
  104. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28707577, 1402, 1728122400);
  105. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28806052, 1402, 1728122400);
  106. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28841330, 1402, 1728122400);
  107. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28900260, 1402, 1728122400);
  108. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (29139677, 1402, 1728122400);
  109.  
  110. -- x100 WOTLK
  111. -- https://wowroad.info/?achievement=431 (САНВЕЛ 1 место)
  112. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6321685, 431, 1728122400);
  113. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6470790, 431, 1728122400);
  114. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (6697162, 431, 1728122400);
  115. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7478275, 431, 1728122400);
  116. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (7494220, 431, 1728122400);
  117. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (8541990, 431, 1728122400);
  118. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (14375405, 431, 1728122400);
  119. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (19719242, 431, 1728122400);
  120. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (21433666, 431, 1728122400);
  121. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (22817414, 431, 1728122400);
  122. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (26214507, 431, 1728122400);
  123. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (27606650, 431, 1728122400);
  124. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (27997356, 431, 1728122400);
  125. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28010975, 431, 1728122400);
  126. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28090267, 431, 1728122400);
  127. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28324304, 431, 1728122400);
  128. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28453929, 431, 1728122400);
  129. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28665720, 431, 1728122400);
  130. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28668297, 431, 1728122400);
  131. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28707577, 431, 1728122400);
  132. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28808849, 431, 1728122400);
  133. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28841330, 431, 1728122400);
  134. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (28900260, 431, 1728122400);
  135. INSERT IGNORE INTO character_achievement (guid, achievement, DATE) VALUES (29139677, 431, 1728122400);
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!