turtle-wow-source-kinda/Dumps/Source Code/9 - Development_website_old/master/rules.sql
Brian Oost a1d5bb70b2 Init
2024-08-06 18:06:40 +02:00

54 lines
33 KiB
SQL

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for rules
-- ----------------------------
DROP TABLE IF EXISTS `rules`;
CREATE TABLE `rules` (
`id` int NOT NULL AUTO_INCREMENT,
`ord` int NOT NULL DEFAULT 0,
`title` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`description` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`tab` int NOT NULL DEFAULT 1,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of rules
-- ----------------------------
INSERT INTO `rules` VALUES (1, 1, 'Cheating, botting, modifications & third-party programs, bug & exploit abuse', 'Turtle WoW is committed to provide a cheat-free environment. The following activities are strictly forbidden:<br><br><li>Usage or promotion of any cheats and modifications to client files to benefit your in game characters.</li><li>The use or promotion of any third party programs to automate the control or actions of your character.</li><li>Abuse or promote abuse of any bug or exploit to obtain gold, experience, items, reputation, kill NPC\'s, kill players etc.</li><br>All reports for the above will be done in private via in-game tickets.', 1);
INSERT INTO `rules` VALUES (2, 2, 'Multi-boxing', '<br>Multiboxing is the act of controlling multiple WoW clients simultaneously. This can entail having multiple clients\r\nopen on a single machine or utilizing multiple machines to control the actions of both accounts at the same time for\r\ncombat or moving. At our server, we permit the use of a maximum of two accounts at a time, with the following\r\nexceptions:<br><br>\r\n<li>It is strictly forbidden to multibox if either of your characters is undergoing a Hardcore challenge.</li>\r\n<li>It is strictly forbidden to multibox if either of your characters is flagged for PvP, including Warmode.</li>\r\n<li>Three accounts are permitted for the use of Summoning Rituals.</li>\r\n<br>The use of software to multibox is never permitted.\r\n<br>\r\n<br>Hardcore characters found in breach of the boosting/multi-boxing policies may be subject to a character lock, rendering them unplayable for the offending player.', 1);
INSERT INTO `rules` VALUES (3, 3, 'Account sharing, GDKP-runs & boosts, gold-selling, and other types of RMT', '<br>Selling and buying gold or other in-game currencies (including valuable items) for real money or donation tokens is strictly prohibited on Turtle WoW, and all gold transactions are closely monitored. Any form of RMT will result in severe consequences for all parties involved. Please do not support individuals who seek to harm our server.</li> <li>Selling or buying characters or boosting services for real money, in-game currencies (including valuable items), or donation tokens is strictly forbidden.<li>HC mode characters are not permitted to get assistance from players outside of their group. (No boosting HC mode players, even for free.)</li></li> <li>GDKP raids, where groups auction bind-on-pickup or bind-on-equip items for gold, real money, or similar in-game currencies (including valuable items), may NOT be created, promoted or attended. For instance, farming a dungeon and inviting players to wait in the corner for items to drop, with the expectation of payment for the service, is not allowed. <li>However, acting as a mercenary to sell tanking or healing services (not DPS services) for in-game gold is permitted, but not for items or drops, only to be compensated for time and repair costs to assist others with 5-man instances. Mercenaries are not allowed to offer services for raids.</li></li> <li>Selling or promoting the sale of character names for gold or real money is also strictly prohibited. Any accounts caught engaging in this activity will be suspended, and any reserved names will be made available for use.</li> <li>Trading gold cross-realm is not permitted.</li> <br>Sharing access to your account with others is allowed, as long as it is not used to scam or deceive other members of the community. However, you are responsible for any rule violations that occur while others are using your account. We will not reverse any character changes caused by others while using your account.', 1);
INSERT INTO `rules` VALUES (4, 4, 'Interactions with staff', '<br>Turtle WoW staff is expected to treat all players with respect, professionalism, and kindness. We expect the same from our players. If a player is found being toxic, disrespectful, manipulative or insulting towards any Turtle WoW Staff member, it could lead to account warnings, suspensions or closures.', 1);
INSERT INTO `rules` VALUES (5, 5, 'Things to take into account in a RP server like Turtle WoW', '<br>While we don\'t enforce RP, all players must respect those who decide to RP. Intentional disruption of any RP event or interaction can result in punishments. This includes bad-faith trolling behavior.<br> Continued problematic behavior within RP may result in a loss of access to RP GM support for player events.', 1);
INSERT INTO `rules` VALUES (6, 6, 'Naming rules for a RP server like Turtle WoW', '<br>We do not force our players to use RP-friendly names, but we would be grateful if you contribute to the immersion by using a good fantasy name. However, some name type are forbidden and players will be requested to changed it. It\'s strictly prohibited to:<br><br><li>To use names that reference well known people: politicians, social activists, religious figures, culprits, actors, celebrities, etc.</li><li>To use names political, religious or controversial connotations</li><li>To use names which are referencing inappropriate explicit matters: extremism, sexism, racism, mocking certain groups of the people.</li><li>To use names which are overly vulgar and sexual.</li><li>To use names created to mimic any staff name.</li><li>It is forbidden to use real-world country names in your guild names.</li>', 1);
INSERT INTO `rules` VALUES (7, 7, 'Chat abuse', '<br>Here at Turtle WoW, we encourage players to come together, form communities, and openly chat with their fellow players. There are some chat rules that we must insist upon to maintain healthy and family-friendly vibe on our server. <br><br>The rule set for the following public channels: /world, /hardcore, /trade, any crowded leveling or recreation zones:<br><br><li>Public chats are English speaking only. The only exception are guild recruitment announcements, those can be in your native language.</li><li>Spam: do not post more than 3 consecutive lines of the same text per minute.</li><br>It\'s strictly prohibited to:<br><br><li>Discuss politics, religions, or any other socially controversial or vulgar/sexual matters. Keep real life drama in real life.</li><li>Encourage racism, extremism, sexism, violence, doxxing, hate speech of any kind toward certain groups of people.</li><li>Insult players, group of players (such as guild) or staff members of Turtle WoW.</li><li>Promote phishing websites, cheats, inappropriate links to the website containing explicit content.</li><li>Fail to follow directions of a GM on content that they find offensive or inappropriate.</li><li>Use non-default font colors for the in-game chats is strictly prohibited.</li><br>The rules set for other types of in-game communications. Under normal circumstances we do not interfere in conflicts emerged in private chats: whispers, guild chats, groups, raids or custom channels. However, there are certain cases where we could interfere and take actions against certain individuals:<br><br><li>If you suspect that someone is committing sexual harassment towards minors, report it immediately.</li><li>If you suspect that someone is violating your privacy by spreading personal information about you in private chats, report it immediately.</li><li>Ignore avoidance: If someone who is on your ignore list continues to make new characters to insult you, you may report it to the GMs.</li><li>Inappropriate promotions and links to phishing websites, cheats, inappropriate links to the website.</li><li>Joining a custom channel with the intent to harass the players who are having a conversation there.</li>', 1);
INSERT INTO `rules` VALUES (8, 8, 'Behavior during PvP encounters', '<br>During PVP encounters, we discourage any toxic behavior or abuse of game mechanics, bugs or glitches. Any of the following behaviors will lead to being issued a penalty:<br><br><li>Wintrading. Wintrading is the practice where players throw games on purpose, in turns, for the purpose of collecting the rewards.</li> <li>AFK-ing during a battleground. Not taking any action during the match and being tagged as Away from Computer.</li><li>Refusing to play the match. Refusing to play the match is a behavior in the same vein as AFK-ing in a match, but the player is still at his PC. He just queues to the match for the population and during the match he just moves around so he does not get the AFK status. During this time he refuses any communication with his team members or clearly states he is there just for the population or just to observe.</li><li>Using multiple accounts to queue. Logging in using two or several accounts to queue both sides so their faction can join, and then leaving without playing the match.</li><li>Safespotting is the act of PvPing from an advantageous position that cannot be reached through regular jumping or walking. If you got to the position by using a spell, potion, wall climbing, or other additional means, it is likely safespotting.</li><li>Cross-faction grouping during open world PvP encounters. Horde and Alliance grouping together during open world PvP encounters.</li>Hardcore Characters &amp; PvP<br><br>To prevent griefing, we have implemented several server-side checks to stop Hardcore Characters from accidental flagging for PvP. If the hardcore character dies as a consequence of choosing to tag himself by using /pvp, starting the War Mode challenge, attacking a PvP NPC or buffing/healing a player tagged for PvP, he will not be considered a victim of griefing.', 1);
INSERT INTO `rules` VALUES (9, 9, 'Griefing', '<br>Griefing refers to the act of a player ruining the gaming experience of another player. We encourage the Turtle WoW community to respect other players different play styles and to not ruin their experience. Everyone plays this game differently and all playstyles should be welcomed.<br><br><strong class=\"text-strong\">To keep the community friendly the following activities are strictly forbidden:</strong><br><br><li>Farming quest givers, important quest objectives and important NPC\'s for long periods of time and blocking other players from accepting or turning in quests.</li><li>Harassing a player by following them around and tagging mobs they need to kill for a quest or tricking them into getting flagged for PvP without their intent.</li><li>Kiting a group of mobs into another player\'s (AoE) spells.</li><li>Interfering with any player trying to complete The Balance of Light and Dark or the Stave of the Ancients quest chain.</li><li>Dropping infernals and doomguards on a group of players in low level zones.</li><li>Block entrances with tents or other spawnable objects.</li><strong class=\"text-strong\"><br>How to report: contact support on Discord or open an in-game ticket with as much proof as possible of the event:</strong><br><br><li>Link of video uploaded on : Youtube, Streamable, Vimeo etc.</li>If you plan your RP event it\'s your responsibility to ensure all your members have PvP flag off. GM will only interfere if you are being tricked into PvP or your event is interfered with in any other fashion. <br><br>As a reminder: staff is not responsible for the actions of the player that griefed and can\'t take actions against a player that did not do anything as a preventive measure or without any proof being offered. With those in mind, please keep discussions civil when reporting to staff.', 1);
INSERT INTO `rules` VALUES (10, 10, 'Behavior reports', '<br>Behavior reports will be done in private with as much details as possibile.<br><br><li>For chat abuse: Open an in game ticket with character names, date, hour, and chat channel in which the conversation happened.</li><li>For other types of reports: Open an in game ticket and describe the players behavior with as much details as possible.</li><br>Reports without details that are done with the intent to slander, insult or start drama will be severely punished. The GM\'s will review the report, check what is happening and act accordingly to the situation. Different situations will require different penalty\'s.', 1);
INSERT INTO `rules` VALUES (11, 11, 'Requesting GM assistance for bugged quest', '<br>When unable to complete a quest due a bug, help can can be requested by contacting a GM using the in game tickets. <br><br>While the following template is not obligatory to use, please provide as much details as possible about the encountered issue so that our support team can understand the situation better. <br><br><li>Quest name</li><li>NPC/Object/Item name</li><li>Encountered problem</li><li>Expected behavior</li><br>Depending of the situation, not all help requests will be met with GM assistance. In some situations players will be requested to open a bug tracker report and wait for a fix from our development team.', 1);
INSERT INTO `rules` VALUES (12, 12, 'Loot distribution issues', '<br>We will not be involved in most inter-player disputes on loot. However, there are some occasions where we will investigate and assist:<br><br><li>If you are in a group or raid, and the loot rules are clearly defined in game, prior to the raid beginning, and those rules are not followed when the time comes to receive loot. You may open a ticket for investigation.</li><strong class=\"text-strong\"><br>Please be aware that we will no longer assist with tickets requesting the transfer of an item from one party member to another in any 5-man dungeon, regardless of level.</strong><br><br><strong class=\"text-strong\">For raiders, we have implemented a new system that allows you to rectify any mistakes on your own:</strong><br><br>In raids where Master Looter mode is enabled, for a short period of 10 minutes after the boss has been defeated, all raid members will have a claim on the item and can receive it via trade, provided they were present during the boss kill, have not left the raid map, and share the same raid ID with the current owner of the item. Each item can only be traded once. <br><br>There will be a map-wide announcement to inform the raid leader about this event. Please note that any requests for manual transfers will be refused from now on.', 1);
INSERT INTO `rules` VALUES (13, 13, 'Item restoral', '<br>If you have sold or destroyed an important item, please visit <strong class=\"text-strong\">NPC Trash Collector Gaston</strong> in Ratchet (<a href=\"https://database.turtle-wow.org/?npc=8\" class=\"postlink\">https://database.turtle-wow.org/?npc=8</a>). He will offer you 128 recently lost items. <br><br>Please keep in mind that you will have to pay their full vendor price to retrieve them. <br><br>Additionally, on our server, the vendor buyback list is always available after a player logs out. Always make sure to check it if you accidentally sell something important. <br><br>Our support team will only assist you in the following cases:<br><br><li>If you have lost an important quest item and cannot progress through a quest-chain without it, and it was looted no longer than 1 month ago.</li> <li>If you have lost a legendary item and it happened no longer than 1 month ago.</li>', 1);
INSERT INTO `rules` VALUES (14, 14, 'Token refunds', 'This server is free, and donations are not mandatory. If you have mistakenly donated money and would like a refund, please ensure that you do not spend your tokens. Only in this specific scenario will our system be able to transfer your money back. For donation rewards purchased from the shop, we can only do a token refund within 48 hours of the purchase. Refunds are not available for Hardcore players.<br><br>Please note, that we do not offer refunds for deleted characters. Items purchased from our donation store are considered soulbound to the character you purchase them on, and will not be refunded if you willingly delete your character. Please request a refund before deleting your character if it is within our 48 hour refund period.<br><br>For Hardcore characters, donated points are automatically refunded upon death or deletion of the character. Manual restoration of these points with the assistance of a GM is not possible.', 1);
INSERT INTO `rules` VALUES (15, 15, 'Decisions appeal', '<br>Every decision can be appealed for a different outcome. Please open a in game ticket and argue your case. In the case of a ban appeal, login and contact staff via user panel on our website.<br><br>If the ticket contains any of the following, it will be closed without a reply:<br><br><li>Insults or manipulation.</li><li>Accusations of staff favoritism or bias towards players.</li><br>When the final decision is reached, any further tickets on the topic will be closed without a reply.', 1);
INSERT INTO `rules` VALUES (17, 17, 'Disclaimer', '<br>This list may not cover all types of behavior. Turtle WoW reserves the right to modify, update, or adjust this document at any time. If any part of this document is changed, we will inform all players. The GM team may take different actions than those specified in these terms of use, as they are responsible for making decisions in unique situations.</strong> ', 1);
INSERT INTO `rules` VALUES (18, 1, 'Cheating, botting, modifications & third-party programs, bug & exploit abuse', 'Turtle WoW is committed to provide a cheat-free environment. The following activities are strictly forbidden:<br><br><li>Usage or promotion of any cheats and modifications to client files to benefit your in game characters.</li><li>The use or promotion of any third party programs to automate the control or actions of your character.</li><li>Abuse or promote abuse of any bug or exploit to obtain gold, experience, items, reputation, kill NPC\'s, kill players etc.</li><br>All reports for the above will be done in private via in-game tickets.', 2);
INSERT INTO `rules` VALUES (19, 2, 'Multi-boxing', '<br>Multiboxing is the act of controlling multiple WoW clients simultaneously. This can entail having multiple clients open on a single machine or utilizing multiple machines to control the actions of both accounts at the same time for combat or moving. On this realm, we do not permit any multiboxing, with one exception:<br><br>\r\n\r\nThree accounts are permitted for the use of Summoning Rituals.', 2);
INSERT INTO `rules` VALUES (20, 3, 'Account sharing, GDKP-runs & boosts, gold-selling, and other types of RMT', '<br>Selling and buying gold or other in-game currencies (including valuable items) for real money or donation tokens is strictly prohibited on Turtle WoW, and all gold transactions are closely monitored. Any form of RMT will result in severe consequences for all parties involved. Please do not support individuals who seek to harm our server.</li> <li>Selling or buying characters or boosting services for real money, in-game currencies (including valuable items), or donation tokens is strictly forbidden.</li> <li>GDKP raids, where groups auction bind-on-pickup or bind-on-equip items for gold, real money, or similar in-game currencies (including valuable items), may NOT be created, promoted or attended. For instance, farming a dungeon and inviting players to wait in the corner for items to drop, with the expectation of payment for the service, is not allowed. <li>However, acting as a mercenary to sell tanking or healing services (not DPS services) for in-game gold is permitted, but not for items or drops, only to be compensated for time and repair costs to assist others with 5-man instances. Mrcenaries are not allowed to offer services for raids.</li></li> <li>Selling or promoting the sale of character names for gold or real money is also strictly prohibited. Any accounts caught engaging in this activity will be suspended, and any reserved names will be made available for use.</li> <li>Trading gold cross-realm is not permitted.</li> <br>Sharing access to your account with others is allowed, as long as it is not used to scam or deceive other members of the community. However, you are responsible for any rule violations that occur while others are using your account. We will not reverse any character changes caused by others while using your account.', 2);
INSERT INTO `rules` VALUES (21, 4, 'Interactions with staff', '<br>Turtle WoW staff is expected to treat all players with respect, professionalism, and kindness. We expect the same from our players. If a player is found being toxic, disrespectful, manipulative or insulting towards any Turtle WoW Staff member, it could lead to account warnings, suspensions or closures.', 2);
INSERT INTO `rules` VALUES (22, 5, 'Things to take into account in a RP server like Turtle WoW', '<br>While we don\'t enforce RP, all players must respect those who decide to RP. Intentional disruption of any RP event or interaction can result in punishments. This includes bad-faith trolling behavior.<br> Continued problematic behavior within RP may result in a loss of access to RP GM support for player events.', 2);
INSERT INTO `rules` VALUES (23, 6, 'Naming rules for a RP server like Turtle WoW', '<br>We do not force our players to use RP-friendly names, but we would be grateful if you contribute to the immersion by using a good fantasy name. However, some name type are forbidden and players will be requested to changed it. It\'s strictly prohibited to:<br><br><li>To use names that reference well known people: politicians, social activists, religious figures, culprits, actors, celebrities, etc.</li><li>To use names political, religious or controversial connotations</li><li>To use names which are referencing inappropriate explicit matters: extremism, sexism, racism, mocking certain groups of the people.</li><li>To use names which are overly vulgar and sexual.</li><li>To use names created to mimic any staff name.</li><li>It is forbidden to use real-world country names in your guild names.</li>', 2);
INSERT INTO `rules` VALUES (24, 7, 'Chat abuse', '<br>Here at Turtle WoW, we encourage players to come together, form communities, and openly chat with their fellow players. There are some chat rules that we must insist upon to maintain healthy and family-friendly vibe on our server. <br><br>The rule set for the following public channels: /world, /trade, any crowded leveling or recreation zones:<br><br><li>Public chats are English speaking only. The only exception are guild recruitment announcements, those can be in your native language.</li><li>Spam: do not post more than 3 consecutive lines of the same text per minute.</li><br>It\'s strictly prohibited to:<br><br><li>Discuss politics, religions, or any other socially controversial or vulgar/sexual matters. Keep real life drama in real life.</li><li>Encourage racism, extremism, sexism, violence, doxxing, hate speech of any kind toward certain groups of people.</li><li>Insult players, group of players (such as guild) or staff members of Turtle WoW.</li><li>Promote phishing websites, cheats, inappropriate links to the website containing explicit content.</li><li>Fail to follow directions of a GM on content that they find offensive or inappropriate.</li><li>Use non-default font colors for the in-game chats is strictly prohibited.</li><br>The rules set for other types of in-game communications. Under normal circumstances we do not interfere in conflicts emerged in private chats: whispers, guild chats, groups, raids or custom channels. However, there are certain cases where we could interfere and take actions against certain individuals:<br><br><li>If you suspect that someone is committing sexual harassment towards minors, report it immediately.</li><li>If you suspect that someone is violating your privacy by spreading personal information about you in private chats, report it immediately.</li><li>Ignore avoidance: If someone who is on your ignore list continues to make new characters to insult you, you may report it to the GMs.</li><li>Inappropriate promotions and links to phishing websites, cheats, inappropriate links to the website.</li><li>Joining a custom channel with the intent to harass the players who are having a conversation there.</li>', 2);
INSERT INTO `rules` VALUES (25, 8, 'Behavior during PvP encounters', '<br>During PVP encounters, we discourage any toxic behavior or abuse of game mechanics, bugs or glitches. Any of the following behaviors will lead to being issued a penalty:<br><br><li>Wintrading. Wintrading is the practice where players throw games on purpose, in turns, for the purpose of collecting the rewards.</li> <li>AFK-ing during a battleground. Not taking any action during the match and being tagged as Away from Computer.</li><li>Refusing to play the match. Refusing to play the match is a behavior in the same vein as AFK-ing in a match, but the player is still at his PC. He just queues to the match for the population and during the match he just moves around so he does not get the AFK status. During this time he refuses any communication with his team members or clearly states he is there just for the population or just to observe.</li><li>Safespotting is the act of PvPing from an advantageous position that cannot be reached through regular jumping or walking. If you got to the position by using a spell, potion, wall climbing, or other additional means, it is likely safespotting.</li>', 2);
INSERT INTO `rules` VALUES (26, 9, 'Griefing', '<br>Griefing refers to the act of a player ruining the gaming experience of another player. We encourage the Turtle WoW community to respect other players different play styles and to not ruin their experience. Everyone plays this game differently and all playstyles should be welcomed.<br><br><strong class=\"text-strong\">To keep the community friendly the following activities are strictly forbidden:</strong><br><br><li>Farming quest givers, important quest objectives and important NPC\'s for long periods of time and blocking other players from accepting or turning in quests.</li><li>Harassing a player by following them around and tagging mobs they need to kill for a quest.</li><li>Kiting a group of mobs into another player\'s (AoE) spells.</li><li>Interfering with any player trying to complete The Balance of Light and Dark or the Stave of the Ancients quest chain.</li><li>Block entrances with tents or other spawnable objects.</li><strong class=\"text-strong\"><br>How to report: contact support on Discord or open an in-game ticket with as much proof as possible of the event:</strong><br><br><li>Link of video uploaded on : Youtube, Streamable, Vimeo etc.</li>If you plan your RP event it\'s your responsibility to ensure all your members have PvP flag off. GM will only interfere if you are being tricked into PvP or your event is interfered with in any other fashion. <br><br>As a reminder: staff is not responsible for the actions of the player that griefed and can\'t take actions against a player that did not do anything as a preventive measure or without any proof being offered. With those in mind, please keep discussions civil when reporting to staff.', 2);
INSERT INTO `rules` VALUES (27, 10, 'Behavior reports', '<br>Behavior reports will be done in private with as much details as possibile.<br><br><li>For chat abuse: Open an in game ticket with character names, date, hour, and chat channel in which the conversation happened.</li><li>For other types of reports: Open an in game ticket and describe the players behavior with as much details as possible.</li><br>Reports without details that are done with the intent to slander, insult or start drama will be severely punished. The GM\'s will review the report, check what is happening and act accordingly to the situation. Different situations will require different penalty\'s.', 2);
INSERT INTO `rules` VALUES (28, 11, 'Requesting GM assistance for bugged quest', '<br>When unable to complete a quest due a bug, help can can be requested by contacting a GM using the in game tickets. <br><br>While the following template is not obligatory to use, please provide as much details as possible about the encountered issue so that our support team can understand the situation better. <br><br><li>Quest name</li><li>NPC/Object/Item name</li><li>Encountered problem</li><li>Expected behavior</li><br>Depending of the situation, not all help requests will be met with GM assistance. In some situations players will be requested to open a bug tracker report and wait for a fix from our development team.', 2);
INSERT INTO `rules` VALUES (29, 12, 'Loot distribution issues', '<br>We will not be involved in most inter-player disputes on loot. However, there are some occasions where we will investigate and assist:<br><br><li>If you are in a group or raid, and the loot rules are clearly defined in game, prior to the raid beginning, and those rules are not followed when the time comes to receive loot. You may open a ticket for investigation.</li><strong class=\"text-strong\"><br>Please be aware that we will no longer assist with tickets requesting the transfer of an item from one party member to another in any 5-man dungeon, regardless of level.</strong><br><br><strong class=\"text-strong\">For raiders, we have implemented a new system that allows you to rectify any mistakes on your own:</strong><br><br>In raids where Master Looter mode is enabled, for a short period of 10 minutes after the boss has been defeated, all raid members will have a claim on the item and can receive it via trade, provided they were present during the boss kill, have not left the raid map, and share the same raid ID with the current owner of the item. Each item can only be traded once. <br><br>There will be a map-wide announcement to inform the raid leader about this event. Please note that any requests for manual transfers will be refused from now on.', 2);
INSERT INTO `rules` VALUES (30, 13, 'Item restoral', '<br>If you have sold or destroyed an important item, please visit <strong class=\"text-strong\">NPC Trash Collector Gaston</strong> in Ratchet (<a href=\"https://database.turtle-wow.org/?npc=8\" class=\"postlink\">https://database.turtle-wow.org/?npc=8</a>). He will offer you 128 recently lost items. <br><br>Please keep in mind that you will have to pay their full vendor price to retrieve them. <br><br>Additionally, on our server, the vendor buyback list is always available after a player logs out. Always make sure to check it if you accidentally sell something important. <br><br>Our support team will only assist you in the following cases:<br><br><li>If you have lost an important quest item and cannot progress through a quest-chain without it, and it was looted no longer than 1 month ago.</li> <li>If you have lost a legendary item and it happened no longer than 1 month ago.</li>', 2);
INSERT INTO `rules` VALUES (31, 14, 'Token refunds', 'This server is free, and donations are not mandatory. If you have mistakenly donated money and would like a refund, please ensure that you do not spend your tokens. Only in this specific scenario will our system be able to transfer your money back. For donation rewards purchased from the shop, we can only do a token refund within 48 hours of the purchase. Refunds are not available for Hardcore players.<br><br>Please note, that we do not offer refunds for deleted characters. Items purchased from our donation store are considered soulbound to the character you purchase them on, and will not be refunded if you willingly delete your character. Please request a refund before deleting your character if it is within our 48 hour refund period.<br><br>For Hardcore characters, donated points are automatically refunded upon death or deletion of the character. Manual restoration of these points with the assistance of a GM is not possible.', 2);
INSERT INTO `rules` VALUES (32, 15, 'Decisions appeal', '<br>Every decision can be appealed for a different outcome. Please open a in game ticket and argue your case. In the case of a ban appeal, login and contact staff via user panel on our website.<br><br>If the ticket contains any of the following, it will be closed without a reply:<br><br><li>Insults or manipulation.</li><li>Accusations of staff favoritism or bias towards players.</li><br>When the final decision is reached, any further tickets on the topic will be closed without a reply.', 2);
INSERT INTO `rules` VALUES (33, 17, 'Disclaimer', '<br>This list may not cover all types of behavior. Turtle WoW reserves the right to modify, update, or adjust this document at any time. If any part of this document is changed, we will inform all players. The GM team may take different actions than those specified in these terms of use, as they are responsible for making decisions in unique situations.</strong> ', 2);
SET FOREIGN_KEY_CHECKS = 1;