Go Back   EQEmulator Home > EQEmulator Forums > Quests > Quests::Plugins & Mods

Quests::Plugins & Mods Completed plugins for public use as well as modifications.

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2018, 02:05 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Also need to take into consideration that special attacks are no longer handled the same anymore
Reply With Quote
  #2  
Old 05-11-2018, 02:12 PM
Splose's Avatar
Splose
Discordant
 
Join Date: Apr 2014
Posts: 280
Default

Quote:
Originally Posted by Akkadius View Post
Also need to take into consideration that special attacks are no longer handled the same anymore
Ahh that is right.

Just to clarify.. you are still able to use either system you just lose the increased functionality of the new one if you do it this way...correct?

Either way an easy fix but I'll have to get it done after work. Will update soon.
Reply With Quote
  #3  
Old 05-11-2018, 02:55 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Thanks for taking this on bud - I'm sure many people will appreciate it

If you want to pretty it up and make sure it all works and is tested that would be great.

Swap out special attacks for the new hotness and make sure that works and things should be good

I will make sure that all of this gets into our new docs we've been working on for 2018
Reply With Quote
  #4  
Old 05-11-2018, 03:19 PM
deladriendil
Sarnak
 
Join Date: Jan 2017
Posts: 30
Default

will the LoadMySQL() stuff work as advertised in the .json world as presented here?

http://www.eqemulator.org/forums/sho...039#post227039
Reply With Quote
  #5  
Old 05-11-2018, 03:20 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Yes as long as you have the latest plugins from the PEQ repo

https://github.com/ProjectEQ/project...ugins/MySQL.pl
Reply With Quote
  #6  
Old 05-14-2018, 09:36 AM
Splose's Avatar
Splose
Discordant
 
Join Date: Apr 2014
Posts: 280
Default

@deladriendil

This is what I use:

Server Folder/plugins/MYSQL.pl
Code:
#::: Akkadius
#::: Description: These plugins are MySQL loaders in use with Perl DBI
#::: For plug and play, LoadMysql will load your database credentials from eqemu_config.json

sub LoadMysql {	
	use DBI;
	use DBD::mysql;
	use JSON;
	
    	my $json = new JSON();

	#::: Load Config
	my $content;
	open(my $fh, '<', "eqemu_config.json") or die "cannot open file $filename"; {
		local $/;
		$content = <$fh>;
	}
	close($fh);

	#::: Decode
	$config = $json->decode($content);

	#::: Set MySQL Connection vars
	$db = $config->{"server"}{"database"}{"db"};
	$host = $config->{"server"}{"database"}{"host"};
	$user = $config->{"server"}{"database"}{"username"};
	$pass = $config->{"server"}{"database"}{"password"};

	#::: Map DSN
	$dsn = "dbi:mysql:$db:$host:3306";
	
	#::: Connect and return
	$connect = DBI->connect($dsn, $user, $pass);
	
	return $connect;
}
Quote:
Originally Posted by Akkadius View Post
Thanks for taking this on bud - I'm sure many people will appreciate it

If you want to pretty it up and make sure it all works and is tested that would be great.

Swap out special attacks for the new hotness and make sure that works and things should be good

I will make sure that all of this gets into our new docs we've been working on for 2018
Not a problem. It's something I've wanted to do for a little while. I would assume I'm the best person other than yourself to get it done since I've used it for years now and I am pretty familiar with the inner workings.

Current plans:
  • Update code to take advantage of the new special_abilities system
  • Migrate code to the plugins folder to free up space in zone_controller.pl
  • Clean up my existing pet scaling code that works with this system
  • Simple boolean option to use pet scaling or not
  • Add a way to not scale entire zones
  • Add a "don't scale me" option for specific NPCs while still scaling the rest of the zone
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:56 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3