[Release] ENGLISH PowerWeb 3.0 - Updated for 4.7.5 server files

[fallenfate]

Hi all!

I've translated the Russian PowerWeb 3.0 files into full English, and made a few adjustments too. These files work 100% using fdswesley's 4.7.5 release.

NOTE: aiondatabase.com - Aion Database does not have up-to-date XML item listings, and I have been unable to find any other up-to-date source offering XML syndication. Because of this, adding items to the webshop that are not in their listings will return an error. Until they rectify this (if they do), this will remain the case as it is not within my control. Please check their website search for your intended webshop item before posting for assistance regarding this matter.

Adjustments:

- Translated everything to English (obviously), :D!

- Changed the admin mailing system to send mail with only kinah attached (optional). The release would not attach items to mail properly, so this functionality has been removed.

- Changed the admin mailing system to not require the kinah item ID to send. Now you just put an amount in the correct box, and it sends it via mail to the recipient!

- Fixed PHP files looking at the wrong database table columns.

- Fixed character experience displaying incorrect levels.

- Added full titles, up-to-date as of 4.7.5 server files (all 286!). Some event titles have text effects for displaying in your profile with a bit of flair and personality.

- Made player equipment tool-tips refer to the English AionDB for items (www.aiondatabase.com).


Map titles patch contents:

Spoiler:

- Updated map titles. These were pulled from the server files, so some are 'coded', for example: 'LF5_Ship'.

- Changed 'Elyosian' to be 'Elyos' to match the game.

- Changed Abyss ranks to sound less class-specific, for example, 'Tier 9 Warrior' was default, it is now 'Tier 9 Abyssal Fighter'.

Fixed classes patch contents:

Spoiler:

- Added Technist, Aethertech, Gunslinger, Muse, Songweaver classes.

- Created similarly-styled icons for the above missing classes, as they were not supported in PowerWeb 3.0 (hopefully they're correct, I couldn't source a Muse icon so it shares the Songweaver icon).

- Refined the Online Players display in main.php to save website height. It now displays as : Players online: X (x/x), where the x/x is Elyos/Asmodian (this is labelled in the header for the Online Players section to prevent confusion).

Screenshots:

Spoiler:

Download link - https://mega.co.nz/#!VAAnzRwb!GQsd3g...0QQPBGX_UYHhjQ
Map titles patch - https://mega.co.nz/#!sVwQSKjK!p3K7Sq...DjCwAHcY6uUPnQ
Fixed classes patch - https://mega.co.nz/#!wQR0kYzL!MYDRDs...MJS48o7qI3gn88

[MentaL]

[fallenfate]

Hi all!

I've released a patch, which you can download in the main post.

Patch contents:

- Updated map titles. These were pulled from the server files, so some are 'coded', for example: 'LF5_Ship'.

- Changed 'Elyosian' to be 'Elyos' to match the game.

- Changed Abyss ranks to sound less class-specific, for example, 'Tier 9 Warrior' was default, it is now 'Tier 9 Abyssal Fighter'.

[Alenhejm]

Map titles patch - https://mega.co.nz/#!YBJnCQQK!dazrK0...Z1n0kSNx5A76ck

emptily

[fallenfate]

emptily

Link fixed. Sorry about that, no idea why it didn't copy correctly.

[NextAge]

Hi fallenfate,

Did you have webshop in PowerWeb?

[fallenfate]

Hi fallenfate,

Did you have webshop in PowerWeb?

Yep, the webshop is functioning in my translated release. I added a dagger with a price of 0 to test and it works fine. The only strange thing it does is it puts the item directly into the person's inventory, not attached through the mail, and I think this is related to the actual Aion server files having it as a bug.

[Hunor]

You have several unsolved things there, like incompatible table names and more others.
For example, you give the wrong name to a race, Elyosian instead of Elyos. Please don't improvise,
Have you ever played the game?

Also with the classes, in the statistics, because you mix primary classes, with sub classes.
Templar • Gladiator • Assassin • Ranger • Sorcerer • Spiritmaster // Engineer • Muse

Primary classes
Warrior • Scout • Mage • Priest • Technist • Muse

Sub-classes
Templar • Gladiator • Assassin • Ranger • Sorcerer • Spiritmaster • Chanter • Cleric • Gunslinger • Songweaver • Aethertech

That means, you statistics are wrong, you need to fix it to show only Sub-Classes

Translation is good, but it needs to be updated correctly to match the actual emulator database structure and fix the statistics.

[fallenfate]

You have several unsolved things there, like incompatible table names and more others.
For example, you give the wrong name to a race, Elyosian instead of Elyos. Please don't improvise,
Have you ever played the game?

Also with the classes, in the statistics, because you mix primary classes, with sub classes.
Templar • Gladiator • Assassin • Ranger • Sorcerer • Spiritmaster // Engineer • Muse

Primary classes
Warrior • Scout • Mage • Priest • Technist • Muse

Sub-classes
Templar • Gladiator • Assassin • Ranger • Sorcerer • Spiritmaster • Chanter • Cleric • Gunslinger • Songweaver • Aethertech

That means, you statistics are wrong, you need to fix it to show only Sub-Classes

Translation is good, but it needs to be updated correctly to match the actual emulator database structure and fix the statistics.

This was mostly translation to English, the fact I started upgrading it was just to help the community out. I have only recently started playing the game and am enjoying it. As for your issues...

1) Table names are completely compatible with 4.7.5 server files released here on RZ, which is in the title, so you can see which they were made for. The fact they don't 100% match your tables is not my problem as I'm hardly psychic.

2) Wrong race name is fixed. Also, it was just another grammatical viewpoint from a new player. Another way to think of Asmodians is also Asmodi, it's dependent on viewpoint. But like I said, it was fixed along with the map titles in the first patch to match the game.

3) I don't mix any classes, the PowerWeb files do. Blame the devs, not the person who is freely translating and updating files from scratch here with nothing to base it off. They were also missing the Engineer (which is Technist, actually, at least in the 4.7.5 server files which this release is for...) and Muse, which are upcoming in another patch. I thought it best to at least give the community translated files to use sooner than later, and I never stated they were complete, but hey, you're welcome to wait or stick with your Russian files and try and piece it together yourself.

Enjoy your day (and the release), :).

[fallenfate]

Hey all,

Time for another patch! This one adds the missing Technist and Muse classes, as well as their ascended classes:

Patch contents:

- Added Technist, Aethertech, Gunslinger, Muse, Songweaver classes.

- Created similarly-styled icons for the above missing classes, as they were not supported in PowerWeb 3.0 (hopefully they're correct, I couldn't source a Muse icon so it shares the Songweaver icon).

- Refined the Online Players display in main.php to save website height. It now displays as : Players online: X (x/x), where the x/x is Elyos/Asmodian (this is labelled in the header for the Online Players section to prevent confusion).

As always, the link will be up in the main post, and patch notes will be there too.

[ups123]

in webshop u can add only item from 2.7

or to solve this when i go to user ... or online users
Error 500Error 500

Active record "Players" is trying to select an invalid column "show_location". Note, the column must exist in the table or be an expression with alias.

[fallenfate]

in webshop u can add only item from 2.7

or to solve this when i go to user ... or online users
Error 500Error 500

Active record "Players" is trying to select an invalid column "show_location". Note, the column must exist in the table or be an expression with alias.

Are you using 4.7.5 server files and if so, please tell me which item you're trying to add so I can look into the issue.

- - - Updated - - -

As for the Players issue, check the Players table in ac_server_gs. Does it have a show_location column? If not, you'll need to add it by running the query I've attached to this reply.

- - - Updated - - -

So everyone knows, there was a slight issue that's just been fixed for Songweavers. Because of this I've reuploaded the Fixed Classes patch. If you don't want to download the 23kb, just edit the following:

Filepath: protected\components\info.php

Do a case-sensitive search for SONGWEAVER and replace it with BARD.

[ups123]

im trying to add grigol pistol and i have this error
Error connect to xml: http://www.aiondatabase.com/xml/en_U.../101801052.xml

[fallenfate]

Yep, okay, the issue I'm afraid is because the online Aion Database (http://www.aiondatabase.com) isn't fully up-to-date with items, and their DB is where items check for an XML value to pull the data from. That issue is not solvable on my end I'm afraid. Until that website has the item ID added, it cannot be added through the webshop. The same goes with a bunch of items, I'm guessing. AionDatabase.net unfortunately doesn't provide XML syndication, else I'd update the links, because they are up-to-date.

In short, you cannot add some items because there is no XML data for them on aiondatabase.com.

[ups123]

ok check link for " Fixed classes patch " dont work

[fallenfate]

ok check link for " Fixed classes patch " dont work

Thanks, its been updated again.