Project Revive

[AndMetal]

Originally Posted by Kayot

My problem was the alt adv skills. The numbers don't really correlate with anything and are done in a add it as it goes. For instance:

It you boosted strength first then Intel, it would add strength then Intel. If you added Intel then strength, it would add Intel and then strength. For some reason this made reading the date hard and editing it impossible as it wouldn't take the new settings. Not sure why not, thats why you can't edit Alt Adv yet. I'll figure it out.

That one kinda threw me off as well. Reading wasn't too bad:

profile.php (from my PHP-based editor, using a few custom functions):

   91 // AA_Array[240]
   92 	for ($x = 0; $x <= 239; $x++) {
   93 		$aa = asc2uint(substr($profileResult,$x*8+428,4));
   94 		$value = asc2uint(substr($profileResult,$x*8+432,4));
   95 		if ($aa != 0) {
   96 			$Profile["aa_array"][($aa-($value-1))] = $value;
   97 		};
   98 		unset($aa);
   99 		unset($value);
  100 	};
  101 	unset($aa);
  102 	unset($value);

So, then you can pull the info by $Profile[aa_array][aa_id] => points.

For writing, it would probably be better to make an array like this:

$AA_Array => Array
	(
		[position_num] => Array
			(
				[aa_id] => #
				[aa_points] => #
			)
	)

So, then you would have all 240 positions to work with, and then you can put it all back in at once. It might also help to put the position_num into the read array, so that way you can refer back, but still be able to locate the AAs easily by a query to the altadv_vars table:

aa.php:

SELECT skill_id, name, cost, max_level, spellid, (classes + berserker) AS classes FROM altadv_vars WHERE type='' AND classes & '' ORDER BY skill_id

Anyways, just some thoughts

[Kayot]

Sorry, took me a while to respond. I had the Flu with Complications.

I'll look into adding Alt Adv into the character editor. Also, the release is in my sig. So much for a pretty web site.

^-^ And then there was Nu. And Nu said, "The cake is a lie." And so it became.

[gernblan]

This is GREAT news!

I think your project has great potential!

[Kayot]

Yea, I've been working on it slowly but surely. Right now I'm trying an interesting idea. I'm trying to see if I can turn the program into a modual. Meaning set it so the user can install only what they want. Though it is taxing.

I figure I'll finish the character editor first.

Quick question, would any one who's used the program mind adding a table to their PEQ database? It's basically the spells converted into SQL. I'm asking because it would be faster than reading the spells.txt files.

[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.