Anti-MQ2 Reward NPC
Explanation
I wrote the following to curb the growing usage of warp and speed on Casual Dreams. We have a free Port NPC that sends players to cities and a few other noob zones. Now, when players use warp/speed excessively, the Port NPC refuses to send them anywhere for 24 hours max, usually less. It seems like the bulk of us wish MQ2 wasn't in use on our servers but few of us have the time to police it. Warp/speed abuse has declined so dramatically (~80%) on the server that I wanted to share it ASAP. Cheers, poru Custom Views .sql (add to you database) Code:
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`127.0.0.1` VIEW `hackers_account` AS SELECT *, COUNT(*) as hack_count FROM hackers WHERE `date` >= now() - INTERVAL 1 DAY and hacked not like "/MQZone%" GROUP BY `account` ORDER BY hack_count DESC; Code:
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`127.0.0.1` VIEW `hackers_ip` AS SELECT account_ip.ip, account.name as `account`, hackers.name as `character`, hackers.hacked, hackers.zone, COUNT(*) as hack_count FROM hackers LEFT JOIN (account,account_ip) ON (hackers.account = account.name AND account.id = account_ip.accid) WHERE hackers.`date` >= now() - INTERVAL 1 DAY AND account_ip.lastused >= now() - INTERVAL 1 DAY AND hackers.hacked not like "/MQZone%" GROUP BY account_ip.ip ORDER BY hack_count DESC; Code:
sub EVENT_SAY{ |
Nice. This would be great, but I am skeptical of the "hacker" table in the DB. I have never used MQ on my home server, but when testing, that hacker table
was showing MQWarp entries for my character, even sometimes when I used a cross-zone gnome porter (like in Iceclad). |
All times are GMT -4. The time now is 06:11 PM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.