[Add-On]Universal AIO(All In One) Shop

[Shawn]

This is going to take a long ass time, so don't expect it within the next few days. I am going to manually recreate an SQL that adds every single item, for all versions. Yes, it's adding more IDs than needed, but at least it will work for every single version. Here's how it'll work. The AIO shop will open, the same way it does with my AIO shop but when the shops are being loaded from MySQL, it will only load the shops that pertain to your version.

The other 3 versions will be useless space, so if you don't want to add them, you can easily remove them from the SQL before executing the SQL. Basically, I'm making this because let's face it... hardly any AIOs have all of the equips/items that have changed from version to version, and the one I released does not work fully for 83 since some of the IDs changed from 75 to 83. If you don't like this, welp... sucks to be you. I've been known to do things that benefit the leechers/extremely new people, and this is just another one of those things.

Progress:

• 4/17/2011: Separating each item into specific categories - 25%
• 4/17/2011: Shops.SQL - 100%
• 4/17/2011: ShopItems.SQL - 0%
• 4/17/2011: Modify existing script to fit new changes - 100%

Now, some of you may see this as pointless. That's fine. Everyones' entitled to their own opinion. I'm also sure there are easier ways to get the lists i.e. Jash's SQL less shop. I choose to do it via MySQL because tbh... it's what most new people learn from. I'll be releasing this as soon as it's tested fully and working. Yes, that means I'll have to set up a test server for each version, yay -_-

[MentaL]

[XxОsirisxX]

That's not that long... you're doing it manually, that's why. You could simply read from .xml file. from Consume and Equip and it would take no time.

[Shawn]

That's not that long... you're doing it manually, that's why. You could simply read from .xml file. from Consume and Equip and it would take no time.

Doesn't organize it

Did you know that in the XMLs, it has cash hats with regular job hats? It also has each job lumped into the hats category :)

[iJFAC]

Good luck on this Shawn :)

[zImagine]

Good luck sir.

[Soulfist]

This is going to take a long ass time, so don't expect it within the next few days. I am going to manually recreate an SQL that adds every single item, for all versions. Yes, it's adding more IDs than needed, but at least it will work for every single version. Here's how it'll work. The AIO shop will open, the same way it does with my AIO shop but when the shops are being loaded from MySQL, it will only load the shops that pertain to your version.

The other 3 versions will be useless space, so if you don't want to add them, you can easily remove them from the SQL before executing the SQL. Basically, I'm making this because let's face it... hardly any AIOs have all of the equips/items that have changed from version to version, and the one I released does not work fully for 83 since some of the IDs changed from 75 to 83. If you don't like this, welp... sucks to be you. I've been known to do things that benefit the leechers/extremely new people, and this is just another one of those things.

Progress:

• 4/17/2011: Separating each item into specific categories - 25%
• 4/17/2011: Shops.SQL - 100%
• 4/17/2011: ShopItems.SQL - 0%
• 4/17/2011: Modify existing script to fit new changes - 100%

Now, some of you may see this as pointless. That's fine. Everyones' entitled to their own opinion. I'm also sure there are easier ways to get the lists i.e. Jash's SQL less shop. I choose to do it via MySQL because tbh... it's what most new people learn from. I'll be releasing this as soon as it's tested fully and working. Yes, that means I'll have to set up a test server for each version, yay -_-

Good job and good luck Shawn. And lol at "every version", how about v97/98 GMS, or the newer MSEA :(. Common lets be reasonable, how about just... v62, v75, v83 and v88 GMS, then... v97 and v1.01 MSEA

[Emilyx3]

Doesn't organize it

Did you know that in the XMLs, it has cash hats with regular job hats? It also has each job lumped into the hats category :)

The info needed to differentiate is still in the XMLs.

<int name="cash" value="1"/>

1 = Cash
0 = Non-Cash

<int name="reqJob" value="0"/>

Oh yea and Shawn, you can use [noparse][/noparse] tags for your siggy

[Shawn]

Good job and good luck Shawn. And lol at "every version", how about v97/98 GMS, or the newer MSEA :(. Common lets be reasonable, how about just... v62, v75, v83 and v88 GMS, then... v97 and v1.01 MSEA

I guess I wasn't specific enough. My mistake. This will be for v55/62/75/83 GMS. I won't do 88 since there aren't any public Java sources (that I know of) released. The people that do have a v88 server wouldn't waste their time with an AIO

The info needed to differentiate is still in the XMLs.



1 = Cash
0 = Non-Cash

Well, Osi also knows I fail at Java... like extremely fail at it, so that's why I'm doing it via MySQL since it's something I do know how to do



@OffTopic: Osi, please get on MSN

[XxОsirisxX]

Doesn't organize it

Did you know that in the XMLs, it has cash hats with regular job hats? It also has each job lumped into the hats category :)

Did you know that cash items have a cash value inside? That's how I do read cash items for item load.

Also, it's categorized by type, like, Accessories, Cap, Cape, Coat, ...

Only thing is, yeah, it's not organized by jobId, there is not even a pattern in the ID. BUT!!! That's just the String one, the actual details of the equips, of course have it detailed. So they all have a field called "reqJob", which define the job. Being:

0 = Common
1 = Warrior
2 = Magician
4 = Thief
8 = Bowman
16 = Pirate

Which would simplify your work to a huge percent, also, you would only need to save this into a .txt file, not even need to run it twice or what not. ^^

Hells, you can even be more specific, to make it load only items based on your current stats.

But yeah, there you got.

EDIT:

I will get on MSN in 30 minutes or more, I have a huge headache.

[dewdevildead]

thk u verymuch

[GFXDevon]

I'm tottaly using this for my server Thanks :D

---------- Post added at 07:38 AM ---------- Previous post was at 07:38 AM ----------

Does It has every equip in the game?

[Kars]

Nice bump.
So Shawn, is this still an ongoing project?

[Shawn]

No it is not, because Osiris already released a much better version. I'm closing this thread now.