Newbie Spellweaver
- Joined
- Oct 20, 2013
- Messages
- 14
- Reaction score
- 19
Short Information
I merged and expanded the NA, EU and Korean (all in English) Aion gameshops (6200+ items) for use with Dwarfpicker's Aion Lightning 4.0 - 1-Click Server.
This is my BETA 0.9d release! The gameshop is NOT ready for live servers before the final 1.0 release becouse of bugged/duplicate items and missing proper prices (use at your own risk). This is how the gameshop currently looks:
* * IMPORTANT NOTICE * *
To gain speed, I have decided to directly involve people in the finalizing of this project as I realized that even when the gameshop is done, we need to keep the project alive as new Lightning Servers means more items to add and prices to adjust. Please see outlines at the bottom of this post!
Version history:
->
Currently in progress:
(2013-11-11)
After a message from Engager I got a fantastic idea! The project is now open for anyone to join-up in. Will provide full instructions/source.
(2013-11-10)
My eyes, my eyes!!! I begin to understand why not many people undertake projects like this :blink:
(2013-11-09)
Setting prices on all items following actual datamined values. In cases where no prices exist (very common with in-game rewards and NA, EU, Korean gameshop items) I use common sense (trying to find similar items and get a price that way) and in "worst case senarios" I get an overall price from a table I did build up just for this purpose that has NCoin vs Real US Dollar vs Goldfarmers overall price for in-game Kinah.
So you all can get a better picture on how I set the prices, look on this:
(Structure I use for the Aion gameshop to import TXT into SQL)
162000023;250*;30*;0;11;1;0;0;0;Greater Healing Potion;1200x250 = 300000
250* = Stacks of items. In this case 250 Greater Healing Potions
30* = Toll (NCoin), this is the "gameshop" price for the 250 Greater Healing Potions.
Price model used by my Gameshop:
Install Instructions
a. Move/replace the in_game_shop.xml to ..\AIONEmulator\game\config\ingameshop
b. Fully replace the existing MySQL ingameshop with my ingameshop.sql file.
If your server is running when you install/update the ingameshop.sql or in_game_shop.xml file please just (as GM) write this line in the client:
//reload gameshop
It will then as the name suggest reload the MySQL/XML so you dont have to restart the server.
Also, to get TOLL (currency of the gameshop) without editing the account's directly in MySQL write this command (as GM) in the client:
//gameshop
It will then present a list with options on how to directly add TOLL for you/players
How to help the project
On my Mediafire account I'll provide you all with my raw text files I use for "import" into MySQL. That way, if you are serious you can learn how to make your own gameshop or help out in this one currently under development.
Currently the gameshop have 8 TAB's, and each of those TAB's have their own textfile which I use to build up the MySQL imports with. If you want to join up, send me a "mail" and tell what TAB you want to work with, then I'll add your name beside it and you take full responsibillity for it.
Gameshop (Development) folder:
Gameshop (Development) UPLOAD folder:
EDIT: I am not sure "if it works" for anyone to upload on mediafire using the new DropFolder feature (looks bugged), so if it fails to work I'll give out my email to anyone working in this project instead....
I merged and expanded the NA, EU and Korean (all in English) Aion gameshops (6200+ items) for use with Dwarfpicker's Aion Lightning 4.0 - 1-Click Server.
This is my BETA 0.9d release! The gameshop is NOT ready for live servers before the final 1.0 release becouse of bugged/duplicate items and missing proper prices (use at your own risk). This is how the gameshop currently looks:
You must be registered to see links
.* * IMPORTANT NOTICE * *
To gain speed, I have decided to directly involve people in the finalizing of this project as I realized that even when the gameshop is done, we need to keep the project alive as new Lightning Servers means more items to add and prices to adjust. Please see outlines at the bottom of this post!
Version history:
v0.9d
- Existing and *NEW* god-mode items moved to their own GM tab with "adjusted prices"
v0.9c
- added entire Housing section
v0.9b
- fixed "petfood" bug
v0.9
- first official release
- Existing and *NEW* god-mode items moved to their own GM tab with "adjusted prices"
v0.9c
- added entire Housing section
v0.9b
- fixed "petfood" bug
v0.9
- first official release
You must be registered to see links
Currently in progress:
(2013-11-11)
After a message from Engager I got a fantastic idea! The project is now open for anyone to join-up in. Will provide full instructions/source.
(2013-11-10)
My eyes, my eyes!!! I begin to understand why not many people undertake projects like this :blink:
(2013-11-09)
Setting prices on all items following actual datamined values. In cases where no prices exist (very common with in-game rewards and NA, EU, Korean gameshop items) I use common sense (trying to find similar items and get a price that way) and in "worst case senarios" I get an overall price from a table I did build up just for this purpose that has NCoin vs Real US Dollar vs Goldfarmers overall price for in-game Kinah.
So you all can get a better picture on how I set the prices, look on this:
(Structure I use for the Aion gameshop to import TXT into SQL)
162000023;250*;30*;0;11;1;0;0;0;Greater Healing Potion;1200x250 = 300000
250* = Stacks of items. In this case 250 Greater Healing Potions
30* = Toll (NCoin), this is the "gameshop" price for the 250 Greater Healing Potions.
Price model used by my Gameshop:
Toll | Kinah |
1 | 10.000 |
10 | 100.000 |
100 | 1.000.000 |
1.000 | 10.000.000 |
10.000 | 100.000.000 |
Install Instructions
a. Move/replace the in_game_shop.xml to ..\AIONEmulator\game\config\ingameshop
b. Fully replace the existing MySQL ingameshop with my ingameshop.sql file.
If your server is running when you install/update the ingameshop.sql or in_game_shop.xml file please just (as GM) write this line in the client:
//reload gameshop
It will then as the name suggest reload the MySQL/XML so you dont have to restart the server.
Also, to get TOLL (currency of the gameshop) without editing the account's directly in MySQL write this command (as GM) in the client:
//gameshop
It will then present a list with options on how to directly add TOLL for you/players
How to help the project
On my Mediafire account I'll provide you all with my raw text files I use for "import" into MySQL. That way, if you are serious you can learn how to make your own gameshop or help out in this one currently under development.
Currently the gameshop have 8 TAB's, and each of those TAB's have their own textfile which I use to build up the MySQL imports with. If you want to join up, send me a "mail" and tell what TAB you want to work with, then I'll add your name beside it and you take full responsibillity for it.
File name | TAB | Responsible user |
Menu 1.txt | Support | Nozomu Ezomori |
Menu 2.txt | Enchant | OPEN |
Menu 3.txt | Supply | OPEN |
Menu 4.txt | Character | OPEN |
Menu 5.txt | Mounts/Pets | OPEN |
Menu 6.txt | Gear | OPEN |
Menu 7.txt | Housing | OPEN |
Menu 8.txt | GM | Nozomu Ezomori |
Gameshop (Development) folder:
You must be registered to see links
to access the TXT files and XML (menu) files. Make sure to download instructions.txtGameshop (Development) UPLOAD folder:
You must be registered to see links
to upload TXT files. Make sure to add your date/name to a TXT file before upload; example: Menu 8 (2013-11-11) Nozomu Ezomori.txtEDIT: I am not sure "if it works" for anyone to upload on mediafire using the new DropFolder feature (looks bugged), so if it fails to work I'll give out my email to anyone working in this project instead....
Last edited: