Website Node.Js V2

Joined
Feb 22, 2023
Messages
351
Reaction score
5,079
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 :

To view the content, you need to sign In or register.


Link Caddy (just for ssl certificat) :

To view the content, you need to sign In or register.
 
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]
Nice one
 
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]
Nice!!
 
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]
niceeeee!!
 
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]
WOOO cool
 
Back