Project Revive

[AndMetal]

I know I'm personally of the opinion that the server should use the database to load the spells instead of from the spells_us.txt (and maybe one of these days, I'll figure out how to change it that way), so I've already done so. That way, I can incorporate the information into web pages, etc.

The only "issue" is that, for servers that use custom spells, you can't just use a standard import. That's why I created this PHP script to do this for me. The only downside is that it doesn't currently take into account older spell files, etc, with fewer columns than what the database holds (easy fix, just need to get the changes committed).

Anyways, I think it would be a good way to go.

[Kayot]

I'm going to avoid custom spell servers. Though I wish the Spell lists were server side as well as that would make this so much easier. Untill I'm out of Alfa I'll keep using the spells.txt files.

I've been going over the source code of the EQ DB Editor and man, everything I didn't code is out of this world. I need to give tanks to the team members who moved on.

Sesmar - Thank you, your help in making the controls was extreamly valuable. Also, If I ever figure out what the EDEDBI does I'll probably be even more amazed.
Dr Schlock - The Graphic Cutter you made was simply amazing. Since your not around any more I'll try to keep your code style when working on it.

It was a small team T-T.

Ideas - I like my drag and drop functions, I was thinking that later on I'll ditch the mdi Window so that stuff can be drug to a file explorer where it will be turned into a file that can be drug back into the program. Thats later though.

[Amra]

Good to see you back in action, Kayot

[sesmar]

Originally Posted by Kayot

Sesmar - Thank you, your help in making the controls was extreamly valuable. Also, If I ever figure out what the EDEDBI does I'll probably be even more amazed.

EDEDBI is DAL (Data Access Layer) that I have been working on for sometime now. I converted it to VB.Net for your project, the original version is in C#. When I get sometime this week I will take a look at it to make sure everything is working properly with it (although I think I already did this.) It covers basic data access for returning MySqlReaders to DataTables to DataSets all the way to a LINQ style Entity to Relational DB mapping system using custom attributes and reflection. It has decreased my DB Class coding time by half and sped up my data access time 10 fold.

I think I was starting to work on a faction editor for your project using this particular model, I will look at this as well and maybe get that working as an example of how it is used.

If you have any more questions or want to know more about how it works send me a PM and I will let fill you in on the details.

[Kayot]

Sorry about slow dev, I was surfing the PEQ forums when I saw the Acronym MQ2. After getting the right ver. I have to say this is one on the best utility's I've ever seen. I've been in a kind of trance playing with it for the last few days. If I would of had this back in the day I would've been an unstoppable killing machine. It reminds me of a lesser openKore. Now I'm two boxing a War and Clr (My desktop isn't all that strong and my laptop wont run EQ right other wise I'd six box with 5 of them on the laptop. Dual Core is good) and that is why my dev time is slower now.

I do need to work on the program though, while MQ2 is amazing (Speaking of which, I plan to update the Item Description to Mimic MQ2's) it doesn't tell me were items drop, who drops them, and if a vendor sells that item. So back to the editor.

Sesmar - Is there a way to speed up the draw on the GUI, the player editor takes .4 seconds to draw and it is very annoying. I would be grateful for the assist.

[ChaosSlayer]

would be nice if you would also write a program that detects when a players uses MQ2 and reports to Gm so I can ban them from my server

[Kayot]

Bah, MQ2 isn't cheating while I'm sitting there. Besides, it's my Cleric that is the bot. And may I say, my bot Cleric has it together alot better than any real person cleric ever has. It heals at 70% always, Buffs when a buff drops, and reports when it's getting whooped sending a gsay to my tank who automatically turns around and wails on the clerics problems. I just wish I could have a third box for a Mage or Monk. Mage for summoned items or a monk for more damage. Another warrior would be good as a second tank. The possibilities are endless. If I could figure advanced scripting I could make a mezzing Enchanter. I plan to add my higher lv Druid and Necro to the group later when I get the new server. Hell, I'll be a walking raid. No more endless LFG's to get an epic.

Any way, if you want to know who's MQ2ing, get the program and play with it for a while. Last Tuesday I saw some one manually boxing and they kept getting owned even though they were twinked to hell. I'm using starting gear (For just a little while longer) and I'm unstoppable. The signs of a MQ2er are a rigid behavior (Always healing at 70%) and in my case, the MQ2 doesn't understand the meaning of personal space. I turn around and he's right in my face. Used to make looting hell until I made the cleric do the looting. Smooth sailing since.

I wish there was a program tailored to witting MQ2 scripts. The best I have now is a syntax file for Notepad++.

<Unhijacking my own tread>

[ChaosSlayer]

well you can see here that people have concerns about mq2 usage
http://www.eqemulator.net/forums/showthread.php?t=24569