MAC IP Address

[PokemonRO]

MAC Ban NPC

Here is a Mac ban NPC. Credits to Goddameit for the original codes and the idea. I altered it to apply for Mac addresses instead. 

CREATE TABLE IF NOT EXISTS `mac_ban` ( `list` varchar(18) NOT NULL, `ban_reason` varchar(255) NOT NULL default '', `unban_reason` varchar(255) NOT NULL default '', `status` tinyint(1) NOT NULL default '0', `ban_id` int(11) unsigned NOT NULL default '0', `unban_id` int(11) unsigned NOT NULL default '0', KEY `list` (`list`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here is the script

http://pastebin.com/raw.php?i=rRsaK97t

 

[kerbiii]

MAC Ban NPC

Here is a Mac ban NPC. Credits to Goddameit for the original codes and the idea. I altered it to apply for Mac addresses instead. 

CREATE TABLE IF NOT EXISTS `mac_ban` ( `list` varchar(18) NOT NULL, `ban_reason` varchar(255) NOT NULL default '', `unban_reason` varchar(255) NOT NULL default '', `status` tinyint(1) NOT NULL default '0', `ban_id` int(11) unsigned NOT NULL default '0', `unban_id` int(11) unsigned NOT NULL default '0', KEY `list` (`list`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here is the script

http://pastebin.com/raw.php?i=rRsaK97t

so i need the diff and the script and the sql code for this?

 

[Jasc]

MAC Ban NPC

Here is a Mac ban NPC. Credits to Goddameit for the original codes and the idea. I altered it to apply for Mac addresses instead. 

CREATE TABLE IF NOT EXISTS `mac_ban` ( `list` varchar(18) NOT NULL, `ban_reason` varchar(255) NOT NULL default '', `unban_reason` varchar(255) NOT NULL default '', `status` tinyint(1) NOT NULL default '0', `ban_id` int(11) unsigned NOT NULL default '0', `unban_id` int(11) unsigned NOT NULL default '0', KEY `list` (`list`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here is the script

http://pastebin.com/raw.php?i=rRsaK97t

so i need the diff and the script and the sql code for this?

Apply the diff, add the sql code to your database, and then use the npc script. It works great, tested and confirmed.

 

[Adam]

Hello everyone,

Instructions have been followed: I have installed the .Path manually and made the change in the SQL data base. Im using 2012 04 10 with SSO login diff. Yet, anytime someone logs in, the row called "last_mac" doesn't fill up.

Any help would be great. Thanks