New Waypoint Instance Code

[thepoetwarrior]

You can change the item id of your Waypoint click, just search for "hasitem" to quickly find the lines where you can change item ID.

In case you don't want to use clickie to summon pet for adjust prices, then just ignore that and edit the prices in sub SOLO_PRICE, sub RAID_PRICE, and sub GUILD_PRICE for example at line 1690 for else $new_price = 0;

Most likely, the user name and password are either missing or wrong in this part of the code:

Starts on line 2787

### Establish a Connection with password from Config File
sub LoadMySQLConnection
{
        use DBI;
        use DBD::mysql;
        my $DATABASE_NAME               = "XXXXXXXXXXXX";
        my $DATABASE_USER               = "XXXXXXXXXXXX";
        my $DATABASE_PASSWORD   = "XXXXXXXXXXXX";
        my $dsn = "DBI:mysql:database=$DATABASE_NAME;host=localhost";
        my $connect = DBI->connect($dsn, $DATABASE_USER, $DATABASE_PASSWORD);
        return $connect;
} # End LoadMySQLConnection()

Be sure to replace XXXXXXXXXXXX with your database name, user, and password.

Sorry for any confusion.

Working on a new version today and just about done that will allow people in your raid group to enter raid without needing to be invited manually, will post it when soon within a day here.

[thepoetwarrior]

I'm going to add some error check for people that try this for the first time and forget change the password, will look something like this when I put out the next source:

[thepoetwarrior]

Updated to version 1.9.9

http://pastebin.com/jbWpGkL3

Now automatically gets your password to log into your database via your config file that you already have in your server directory. Alternate login / connect function available via renaming function name.

Anti Spam (Set to 5 message limit per 10 seconds)

Allow group to join leaders solo instance.

Allow raid group to join raid instance without having to be invited.

Anyone in raid group in raid instance can view the list of players invited via /say raid list

Anyone with guild tag can join guild raid without having to be invited.

Anyone with guild tag in guild instance say view invited players via /say guild list

Only raid instance leader can invite/remove players

Anyone with guild tag can invite others into guild instance

Bug fixed where qglobal name started with instance id and qglobal name started with guild id, if either were same, could zone into wrong zone, so those qglobals were renamed to avoid that problem.

Other qglobals got renamed. Easier to see them all in the quest_globals table now by searching qglobal names that contain "RaidI", "GuildI", or "SoloI".

Prices were adjusted to free for testing purposes.

Due to the testing from the players on EZ Server, most of the bugs are worked out and fixed now, and they are really enjoying the new system.

[thepoetwarrior]

I just realized if the script still doesn't work with the correct password, then its cause the perl to mysql thingie isn't install. Had that problem a few years ago, and is simple fix.

Try this from command line:

ppm install DBD-mysql

If it installs anything, then that is what you were missing. Else perl can't connect to mysql database, and therefore the menu won't show up cause it needs values from the database tables via DBI!