Clair;121110 schrieb:

Vieleicht kommt ja jemand von selber drauf :)

So schwer ist es ja nicht ^^

Chaosduckman;121239 schrieb:

... Das ist genau der selbe Fall von [COLOR="DarkRed"]nicht [U]sinnloser Sinnlosigkeit[/COLOR][/U] ;) ...

Clair schrieb:

Jo, wenn du die .sql Datei umschreibst und die config auch, kannste es auch zum laufen bekommen, auch bei Offifiles :>

Aber wie werde ich net sagen ;)

Treachery;5634446 schrieb:

[Introduction]
Here's another release from me, functions completely coded by me. Design ripped from the new eFlyff Premium Shop, with some modifications.
The shop is coded in PHP for Official File servers. Yes, I know, it runs off MySQL, but that is for the item shop database.

[Updates]
Version 2:
- Login page added.
- Updated configuration files.
- Added jQuery file.

[Features]
- Category navigation
- Page navigation
- Item details
- Purchase item
- Purchase & send gift
- Automatically updating "Popular" item based off purchases.

[Setup]
Setup shouldn't be too hard. You only need to configure the following variables in the inc/config.php file:

PHP-Quellcode

1. $shop_key
2. $enable_shop
4. $mysql_server
5. $mysql_database
6. $mysql_username
7. $mysql_password
9. $mssql_server
10. $mssql_username
11. $mssql_password
13. $client_hash
14. $shop_url
16. $cash_type
17. $cash_tbl
18. $cash_row
19. $cash_name
20. $cash_name_min
22. $popular
24. $paragraph['notice']
25. $paragraph['warning']

Alles anzeigen

The descriptions for each variable can be found commented out to the right of each variable.

To use this shop, you need two custom SQL Server stored procedures, shopMessengerList and shopSendItem. Both can be created by executing "SQLServer_shopProdecures.sql" from the SQL folder.

To get the items to display in the shop, you must execute "MySQL_shopTable.sql" from the SQL folder.

Once you have the shop set up in a directory in your web host and mssql functions are enabled, you need to hex edit your "Neuz.exe". Find "http://billing.gpotato.com/Charge/FlyffItemList.asp" and replace the full URL to the URL of your web shop.
Open the Premium Shop inside of the client to see your lovely shop.

[Modifying Shop Items]
The shop comes preset with all of the items inside the eFlyff Cash Shop with exception to the clothing sets, clothing pieces, and hair items as of today.
[COLOR="Red"]THE 'NAME' FIELD INSIDE THE DATABASE MUST MATCH THE ITEM NAME INSIDE THE PROPITEM.TXT.TXT OF THE SERVER FILES OR ELSE THE ITEM WILL NOT BE SENT![/COLOR]

Add New Items:
To add a new item, just insert a new row into the shop table.
Single item required fields: itemid, name, desc, itemcount, price, category, image.
Bundle item required fields: All single item fields, isbundle=1, item1_id, item1_name, item1_count through item4 (leave null for no item). The itemid, name, and itemcount fields will just be used for display for bundle items.

Modifying Items:
Obviously, you can just change the field value...
To remove an item from the shop temporarily, just set 'forsale' equal to 0.
To temporarily put an item on sale, add a price to 'price_sale'. Set it to null or to 0 to remove the sale.

[Screenshots]






[Final Notes]
Activation:
There is a key that you need plugged into the website in order to use it. The key may be only available for a limited amount of time.

PHP-Quellcode

1. $shop_key = "rZtr34CSp8vL1Zk2mQs8";

Item images:
Displayed from "http://forum.ragezone.com/images/items/<itemid><image>" for all items, with an exception to bundled items, in which it is "http://forum.ragezone.com/images/items/<itemid>_bundle<image>.

Website Integration:
If you wish to have a login script for this, you will have to create your own page. Variables are as follows:

PHP-Quellcode

1. //Direct form POST to the shop:
2. $_POST['user_id'] //Account
3. $_POST['m_idPlayer'] //Player ID
4. $_POST['serverindex'] //Player serverindex
5. $_POST['check'] //Account password (must be hashed)
7. //Preset sessions:
8. $_SESSION['ifs_account'] //Account
9. $_SESSION['ifs_player'] //Player ID
10. $_SESSION['ifs_sindex'] //Player serverindex
11. $_SESSION['ifs_passwd'] //Account password (must be hashed)

Alles anzeigen

"http://forum.ragezone.com/images/fail.jpg":
You will have to edit and modify this images yourself to change "gPoints" to your server's currency.

Invalid Accesses:
1: Account (session/post) not entered.
2: Account does not exist.
3: Password does not match that of the account. (Session/posted password must already be hashed)
4: Character does not belong to the account or does not exist (Invalid ID or was deleted).

Hosting:
In my experience, I have come to find that WAMP Server 2.0c works the best with MsSQL connections and such, so a download of that has been linked.

Back-end:
Please note that there is currently no back-end panel to add/modify items or add shop cash to an account. You will have to do these manually.

[Downloads]
WAMPServer2.0c:
Download WampServer from SourceForge.net

Premium Shop Release files:
Version 1:
MegaUpload: MEGAUPLOAD - The leading online storage and file delivery service
MediaFire: Flyff_Premium_Shop_v1.zip

Version 2:
MegaUpload: MEGAUPLOAD - The leading online storage and file delivery service