PeteSampras
Active member
- Joined
- Mar 18, 2012
- RedCents
- 2,143¢
Links:
Git (click here for wiki and source code to compile the plugin for yourself) This should work on any compile.
Roadmap
Info:
This is the MQ2SpawnDB plugin for macroquest2. This plugin is designed to be used to interface with a PostgreSQL database. The plugin will automatically log all observed unique spawns by DisplayName into the database and take a best guess if it is a named, quest related, and if you should burn available skills. You can log spell immunities, ignore mobs entirely, add notes, or note spell resistances/immunities. These capabilities mimic what other macros/plugins have accomplished with INIs but instead uses a PostgreSQL database to allow multiple users to simultaneously access and write data locally or remotely.
It is a bit more intensive to set up because you need to install postgresql, throw some precompiled dlls into your EQ directory, and build a database. Though I do have links to tutorials and all resources with step by step instructions located on my github along with the current source code. I needed to use postgres because my long-term plan for this is to have many characters accessing data at the same time for real time information across servers/networks/instances.
My MQ2Bot rework needs a method to store mobs for ignores, immunities, and other flags. CWTN said his plugins could benefit from the same information. Other macros and plugins also make use of this time of information so I thought it made the most sense to create a standalone plugin along with exposed APIs and accessible TLO. Examples are provided for how to access the functions via API, along with the current set of TLO members that you can use in your macro.
Why did i make this post?
Ok, so what? Well I need some folks to test it to check for bugs, to see if it is useful, and to make suggestions for improvements. I did all testing on a single toon in a static zone so I have no idea if it works in the "real world" and could use some people that are moving around to zones and having new spawns show up to see if everything populates to the database correctly. I would also like to not give too much more information because I want to see if the wiki I made actually has enough detail to get people started.
Gratuitous Pic:
All of the settings can be toggled for NPCs via a simple command of /spawndb option value "npc name"
That updates any setting for the specific npc in the db that looks like this if you open it up in a GUI:
Help, I can't compile it.
I got you fam. Hit me up on discord and I will drop you a pre-compiled mq2spawndb.dll but you still need to do the rest of the steps on the wiki.
Git (click here for wiki and source code to compile the plugin for yourself) This should work on any compile.
Roadmap
Info:
This is the MQ2SpawnDB plugin for macroquest2. This plugin is designed to be used to interface with a PostgreSQL database. The plugin will automatically log all observed unique spawns by DisplayName into the database and take a best guess if it is a named, quest related, and if you should burn available skills. You can log spell immunities, ignore mobs entirely, add notes, or note spell resistances/immunities. These capabilities mimic what other macros/plugins have accomplished with INIs but instead uses a PostgreSQL database to allow multiple users to simultaneously access and write data locally or remotely.
It is a bit more intensive to set up because you need to install postgresql, throw some precompiled dlls into your EQ directory, and build a database. Though I do have links to tutorials and all resources with step by step instructions located on my github along with the current source code. I needed to use postgres because my long-term plan for this is to have many characters accessing data at the same time for real time information across servers/networks/instances.
My MQ2Bot rework needs a method to store mobs for ignores, immunities, and other flags. CWTN said his plugins could benefit from the same information. Other macros and plugins also make use of this time of information so I thought it made the most sense to create a standalone plugin along with exposed APIs and accessible TLO. Examples are provided for how to access the functions via API, along with the current set of TLO members that you can use in your macro.
Why did i make this post?
Ok, so what? Well I need some folks to test it to check for bugs, to see if it is useful, and to make suggestions for improvements. I did all testing on a single toon in a static zone so I have no idea if it works in the "real world" and could use some people that are moving around to zones and having new spawns show up to see if everything populates to the database correctly. I would also like to not give too much more information because I want to see if the wiki I made actually has enough detail to get people started.
Gratuitous Pic:
All of the settings can be toggled for NPCs via a simple command of /spawndb option value "npc name"
That updates any setting for the specific npc in the db that looks like this if you open it up in a GUI:
Help, I can't compile it.
I got you fam. Hit me up on discord and I will drop you a pre-compiled mq2spawndb.dll but you still need to do the rest of the steps on the wiki.
Last edited: