Website Node.Js V2

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]
Amazing
 
Hey guys, if your rankings page are showing way too much playtime like 400+ days or wrong time its because the database stores playtime in seconds, but the API was treating it like minutes, so 598712 seconds became 415 days instead of the actual 6 days.

Just divide by 60 in the API formatter to convert seconds to minutes, and remove the double formatting from the frontend.

Please correct me if what I did is wrong, I'm still learning!

edit: nvm i think its because I modified a lot of stuff it got messed up in the frontend.
 
This release is actually great, I've also added some improvement in the security but overall design and functionality was good. Even top up on paypal is working. Thanks Zacks !

1784632511130 - Website Node.Js V2 - RaGEZONE Forums
 
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]
Niiiiice
 
Olá pessoal

Atualização do site concluída - Reformulação completa do site e integração do sistema de classificação do PayPal.

O site foi bastante aprimorado e estabilizado com diversas correções e novos sistemas.

Site/Infraestrutura:
• Correção no tratamento de inicialização, reinicialização e implantação do PM2.
• Corrigidos problemas de roteamento e configuração do Caddy.
• Corrigidos problemas na compilação independente de produção que causavam erros 404 aleatórios.
• Corrigidos problemas de conexão com o banco de dados e de tempo limite excedido.
• Processo de recuperação aprimorado após reinicializações do servidor.
• Adicionadas melhorias no manuseio de implantação e na estabilidade.
• Corrigidas as páginas de classificação do PayPal e as páginas de administração.
• Limpeza e otimização geral.

Sistema de classificação do PayPal:
Um sistema completo de classificação do PayPal foi integrado.

Foram adicionadas duas novas tabelas ao banco de dados:

• recompensas_de_classificação_paypal
Armazena todo o histórico de recompensas, informações de classificação, status das recompensas e recompensas creditadas.

• Sistema de classificação do PayPal para administradores
Permite que os administradores gerenciem as recompensas diretamente do painel de administração do site.

Características:
• Os 3 melhores jogadores podem receber recompensas diretamente do painel de administração.
• As recompensas são enviadas automaticamente através do sistema Flyff MAIL_TBL.
• Recompensas duplicadas são evitadas.
• O histórico de recompensas é armazenado permanentemente.

Integração da loja de pagamento da floricultura:
O site foi adaptado para o sistema Florist Cash Shop.

Exemplo de fluxo de trabalho:

O jogador compra Pontos de Doação no site.
→ O site credita pontos instantaneamente
→ A Loja de Flores Cash é atualizada automaticamente
→ Os pontos ficam disponíveis imediatamente no jogo.
→ Não é necessário desconectar/reconectar

Configuração de itens da Loja de Cash:

4.1 Método de Compra

1 = Compra somente com Pontos de Voto
2 = Compra somente com Pontos de Doação
3 = Pode ser adquirido com ambos

4.2 Categorias

1 = Oferta Especial
2 = Premium
3 = Funcional
4 = Consumíveis
5 = Caixas de Chance
6 = Mobiliário
7 = Animais de estimação
8 = Transporte
9 = Moda
10 = Peles

Exemplo de leitura:

(555, 2, 0, 500, 2, 50)

Significado:

555 = ID do item Flyff
2 = Doar apenas
0 = Sem preço em Pontos de Voto
500 = Custo em Pontos de Doação
2 = Categoria Premium
50 = O jogador recebe 50 cópias.

Exemplo de SQL:

[CÓDIGO=sql]USE CHARACTER_01_DBF;
IR



INSERIR EM dbo.tblCashShopItems (
[item_id],
[item_voteordonateorboth],
[item_voteprice],
[item_donateprice],
[item_category],
[quantidade_do_item]
)
VALORES
(8065, 2, 0, 50, 1, 1),
(8066, 2, 0, 50, 1, 1),
(8067, 2, 0, 50, 1, 1);

GO[/CODE]

Exemplo de explicação:

8065 / 8066 / 8067 = IDs dos itens
2 = Doar apenas
0 = Sem preço em Pontos de Voto
50 = Preço em Pontos de Doação
1 = Categoria de Venda Especial
1 = Quantidade recebida

Adicionar itens à Loja de Cash agora é extremamente simples e requer apenas uma inserção em SQL.

Link para o site e banco de dados:

[Conteúdo oculto]

Link Caddy (apenas para certificado SSL):

[Conteúdo oculto]
sei
 
Back