Updating the CP Calculator

[Odin]

Just noticed that it is missing some skills, and G16 (When it arrives) will be adding a whole bunch more.

What would it take to get it updated to include the G16 skills as well as the ones that it is missing?

[Osayidan]

It would take me not being busy/lazy-when-not-busy or someone giving me the data + skill icon images in a way I can easily add to the mysql database.
Same goes for the monster CP DB which hasn't been updated in even longer.

Here's an example of the DB structure for both for anyone interested in producing compatible data, I designed it to be fairly easy to copy/paste and slightly modify wiki stuff when I originally designed it, don't know if the wiki has changed since then.

skills

monster


There's some unused stuff like AP, and I don't remember what the lv column was for but it's unused.

[Odin]

Could you export a blank record from each of those tables?

I could import that into my server and populate it, then send you back the resulting table fragment to be imported into your server.

Also do you remember what generation this was last updated in?

It'd make it easier to figure out what needs to be added.

Gold Strike:

Gold Strike C 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0,2,3,4,5,6,7,10,13,16,20,30,40,50,60,70 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 15 H,G,E Gold_Strike

[Osayidan]

I don't remember what generation, but I quit in late summer 2011 and probably had not updated it in any significant way for at least a few months before that. The monsters DB would be even more outdated than that. I can also just PM you the entire table dump for skills and monsters and I can import them again later.

[Odin]

I don't remember what generation, but I quit in late summer 2011 and probably had not updated it in any significant way for at least a few months before that. The monsters DB would be even more outdated than that. I can also just PM you the entire table dump for skills and monsters and I can import them again later.

That would work. As far as the images go, it looks to me like it picks up the image right off of the wiki itself. Unless it needs the filename uploaded manually. I could easily knock together a lump of PHP such that if the image file doesn't exist, it checks the wiki for that skill and retrieves the filename so that later on it has it.

Looks like it was last updated for G12.

This won't take long for me to work through the wiki patch notes and update the skills accordingly.

Monster data might take a bit longer to do though.