Account Status

[ghanja]

Originally Posted by Castious

Still struggling to get this to work. Can't change the status level to allow #commands to be used by players via a progressive quest line. Please help?

You must ensure you have the Perl DBI installed.

Ensure a filename by name of "MySQL.pl" exists in /plugins/ directory (not! /quests/plugins -- that isnt used)

It should look like:

## plugins/MySQL.pl -- be sure to change "peq" to whatever the name of your DB is you use, and change the first "root" to whatever
## MySQL you may be using with access (usually root fwiw) and the second "root" with whatever the password of said MySQL user is
sub MySQL_Connect {
	use DBI;
	use DBD::mysql;
	$dbh = DBI->connect("DBI:mysql:peq:localhost:3306;", "root", "root", {RaiseError => 1, AutoCommit =>1});
	return $dbh;
}

return 1;

Then place this on an any NPC (preferably one without a script already or just rename the existing script of a NPC to npc_name.pl.bak and replace with the below -- whichever method you choose):

# any NPC you want
sub EVENT_SAY
{
	my $dbh = plugin::MySQL_Connect();
	$npc->Shout ("By golly, I think he's got it!") if ($dbh->ping);
}

http://wiki.eqemulator.org/p?Install..._other_Modules