Hello everyone
Website update completed - Full website rework and PayPal Ranking system integration
The website has been heavily improved and stabilized with multiple fixes and new systems.
Website / Infrastructure:
• Fixed PM2 startup, restart and deployment handling.
• Fixed Caddy routing and configuration issues.
• Fixed standalone production build problems causing random 404 pages.
• Fixed database connection and timeout issues.
• Improved recovery process after server restarts.
• Added better deployment handling and stability improvements.
• Fixed PayPal Ranking pages and admin pages.
• General cleanup and optimization.
PayPal Ranking System:
A complete PayPal Ranking system has been integrated.
Two new database tables were added:
• paypal_ranking_rewards
Stores all reward history, ranking information, reward status and credited rewards.
• Admin PayPal Ranking system
Allows administrators to manage rewards directly from the website administration panel.
Features:
• Top 3 players can receive rewards directly from the admin panel.
• Rewards are automatically sent through the Flyff MAIL_TBL system.
• Duplicate rewards are prevented.
• Reward history is stored permanently.
Florist Cash Shop integration:
The website has been adapted for the Florist Cash Shop system.
Example workflow:
Player purchases Donate Points on the website
→ Website credits points instantly
→ Florist Cash Shop updates automatically
→ Points become available immediately in game
→ No disconnect / reconnect required
Cash Shop item configuration:
4.1 Purchase Method
1 = Purchase with Vote Points only
2 = Purchase with Donate Points only
3 = Can be purchased with both
4.2 Categories
1 = Special Sale
2 = Premium
3 = Functional
4 = Consumables
5 = Chanceboxes
6 = Furniture
7 = Pets
8 = Transport
9 = Fashion
10 = Skins
Reading example:
(555, 2, 0, 500, 2, 50)
Meaning:
555 = Flyff Item ID
2 = Donate only
0 = No Vote Point price
500 = Donate Point cost
2 = Premium category
50 = Player receives 50 copies
SQL example:
SQL:
USE CHARACTER_01_DBF;
GO
INSERT INTO dbo.tblCashShopItems (
[item_id],
[item_voteordonateorboth],
[item_voteprice],
[item_donateprice],
[item_category],
[item_amount]
)
VALUES
(8065, 2, 0, 50, 1, 1),
(8066, 2, 0, 50, 1, 1),
(8067, 2, 0, 50, 1, 1);
GO
Example explanation:
8065 / 8066 / 8067 = Item IDs
2 = Donate only
0 = No Vote Point price
50 = Donate Point price
1 = Special Sale category
1 = Quantity received
Adding Cash Shop items is now extremely simple and only requires a SQL insert.
Link website and database :
[Hidden content]
Link Caddy (just for ssl certificat) :
[Hidden content]
