Advertisement
Sansuall

Выдача призов за 1й на сервере TBC(Бонусы/Маунты/Спутники)

Mar 20th, 2024 (edited)
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.49 KB | None | 0 0
  1. -- Первый на сервере КЛАССЫ:
  2. update TBonuses set fcount = fcount + 2000 where f_account in (2541, 6803, 2108);
  3. insert into TBonuses (f_account, fcount) values (3025, 2000);
  4. insert into TBonuses (f_account, fcount) values (3645, 2000);
  5. insert into TBonuses (f_account, fcount) values (1944, 2000);
  6. insert into TBonuses (f_account, fcount) values (7421, 2000);
  7. insert into TBonuses (f_account, fcount) values (5273, 2000);
  8. insert into TBonuses (f_account, fcount) values (7300, 2000);
  9.  
  10.  
  11. -- Первые на сервере РАСЫ:
  12. update TBonuses set fcount = fcount + 2000 where f_account in (3586, 6785, 2936, 5107);
  13. insert into TBonuses (f_account, fcount) values (3586, 2000);
  14.  
  15.  
  16. -- Выдача маунта https://tbc.wowroad.info/?item=37719 за 1й на сервере классы:
  17. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  18. (3000001, 0, 6673, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  19. insert into mail_external_items (mail_id, item, count) values
  20. (3000001, 37719, 1),
  21.  
  22. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  23. (3000002, 0, 5732, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  24. insert into mail_external_items (mail_id, item, count) values
  25. (3000002, 37719, 1),
  26.  
  27. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  28. (3000003, 0, 3757, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  29. insert into mail_external_items (mail_id, item, count) values
  30. (3000003, 37719, 1),
  31.  
  32. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  33. (3000004, 0, 318, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  34. insert into mail_external_items (mail_id, item, count) values
  35. (3000004, 37719, 1),
  36.  
  37. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  38. (3000005, 0, 15137, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  39. insert into mail_external_items (mail_id, item, count) values
  40. (3000005, 37719, 1),
  41.  
  42. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  43. (3000006, 0, 5725, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  44. insert into mail_external_items (mail_id, item, count) values
  45. (3000006, 37719, 1),
  46.  
  47. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  48. (3000007, 0, 12971, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  49. insert into mail_external_items (mail_id, item, count) values
  50. (3000007, 37719, 1),
  51.  
  52. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  53. (3000008, 0, 21373, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  54. insert into mail_external_items (mail_id, item, count) values
  55. (3000008, 37719, 1),
  56.  
  57. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  58. (3000009, 0, 14765, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  59. insert into mail_external_items (mail_id, item, count) values
  60. (3000009, 37719, 1),
  61.  
  62.  
  63. -- Выдача спутника https://tbc.wowroad.info/?item=34493 за 1й на сервере расы:
  64. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  65. (3000010, 0, 6673, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  66. insert into mail_external_items (mail_id, item, count) values
  67. (3000010, 34493, 1),
  68.  
  69. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  70. (3000011, 0, 7839, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  71. insert into mail_external_items (mail_id, item, count) values
  72. (3000011, 34493, 1),
  73.  
  74. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  75. (3000012, 0, 8777, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  76. insert into mail_external_items (mail_id, item, count) values
  77. (3000012, 34493, 1),
  78.  
  79. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  80. (3000013, 0, 5732, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  81. insert into mail_external_items (mail_id, item, count) values
  82. (3000013, 34493, 1),
  83.  
  84. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  85. (3000014, 0, 3757, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  86. insert into mail_external_items (mail_id, item, count) values
  87. (3000014, 34493, 1),
  88.  
  89. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  90. (3000015, 0, 318, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  91. insert into mail_external_items (mail_id, item, count) values
  92. (3000015, 34493, 1),
  93.  
  94. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  95. (3000016, 0, 12850, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  96. insert into mail_external_items (mail_id, item, count) values
  97. (3000016, 34493, 1),
  98.  
  99. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  100. (3000017, 0, 21373, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  101. insert into mail_external_items (mail_id, item, count) values
  102. (3000017, 34493, 1),
  103.  
  104. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  105. (3000018, 0, 6519, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  106. insert into mail_external_items (mail_id, item, count) values
  107. (3000018, 34493, 1),
  108.  
  109. insert into mail_external (id, sender, receiver, subject, message, money, stationery, sent, datetime) values
  110. (3000019, 0, 2004, 'Первый на сервере', 'Приз', 0, 65, 0, '2024-03-20 11:40:45'),
  111. insert into mail_external_items (mail_id, item, count) values
  112. (3000019, 34493, 1),
  113.  
  114.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement