Dawn of Light

Hey,
I've just finished my work on a small php function that returns an associative array filled with the data of a specific class. The structure looks like this: class: specializations[]
spezializations[]: keyname, levelacquired, spelllines[], styles[], abilities[]
spelllines[]: keyname, name, isbaseline, spelltypes[]
spelltypes[]: spells[]
spells[]: name, type, level, id, icon, description, power, casttime, damage, damagetype, duration, radius, value
styles[]: name, speclevelrequirement, icon, endurancecost, stealthrequirement, openingrequirementtype, attackresultrequirement, growthrate, bonustohit, bonustodefense
abilities[]: keyname, name, speclevel, abilitylevel, description, icon

Note that spells are grouped by their type

The usage could be like:
Connect to your database via

Code: Select all

$db_server = mysqli_connect(....)

and then you simply call

Code: Select all

$class = getclassdata($db_server, $class_id);

You can then easily access your data like

Code: Select all

foreach($class['specializations'] as $specialization) { echo $specialization['keyname']; foreach($specialization['abilities'] as $ability) { echo $ability['name']; } }

I hope you like it!
And yep - hey I'm the new one nice to be here. I really love this project already - played along with the source for some weeks now. I'm really impressed!

Christopher

Hello,

Welcome and thank you !

Hello Christopher and Welcome !

You might be interested in this php script I provided as a quick and dirty "class skill display"

http://www.dolserver.net/viewtopic.php?f=69&t=22274

There is some workaround for spell grouping taking into account "PetSpell" (which links to subspell to have the real Type !) and other Spell grouping criteria (Target, Instant, AoE...)

If you'd like to improve it or anything I can put this on a coding platform (github ?)

Thank you guys!

Yes I really would love to take a look into your script. Even if it has a slightly different approach it's almost the same thing.
My aim was to provide a lightweight easy to access way to the data. I tried to download your archive, but it keeps telling me it is broken
It would be awesome if you can put it on github - I could try to help you with the popup spell info based on css3 - or do you prefer javascript?

Have a nice day
Chris

Well, just a quick note for Leo, mine was also corrupt after DL, i didn't retry, but if we are experiencing similar issues...

Well the archive was made quickly, and my Apache server tends to break downloads, so it's not a great way to share code.

I'll put this on github when I get back home

Ok I'm not so used to Git

But here is the code : https://github.com/dol-leodagan/phpDOLc ... ree/master

I'm not uploading Sqlite DB to Git, I don't think Binaries will do any good inside a repository

The more i use GIT the more i think pull request is really easing contributions.

SF is also proposing GIT support. And with GIT-SNV it would allow easy merging until everyone get sticked on GIT....

Well, well...

I should get some "how to" article for Git, it's really disturbing when coming from SVN / CVS

But at least it allows anyone to make fast and easy "forks"

Yes you should, but the key is to understand the differences between centralized/decentralized VCS. It worths the effort !

It would be awesome if you can put it on github - I could try to help you with the popup spell info based on css3 - or do you prefer javascript?

Sorry I forgot to reply to this, I expect to bring pop-up using CSS, I hope I only need JS for "building" character tree from level and skillpoints...

If everything is well defined, Javascript will only have to Fade off the skills that aren't enabled depending on Level and Skill Train Level, it could only need some specific tag attribute to search them with Jquery

yes, I guess thats the best way to do it. I have read through your code and found some good points I did not think of. Thank you for sharing !