Author Topic: High Five [WEB] How to build a strong infrastructure for l2 websites.  (Read 825 times)

Offline Firekarev

  • Vassal
  • *
  • Posts: 5
  • console.log('Beer')
[WEB] How to build a strong infrastructure for l2 websites.
« on: January 07, 2019, 03:08:15 AM »
All, this guide will help you to understand how your website has to be built.

First adivce. Don't use any tool/code/whatever you find in different forums. You can easily build a strong web system by yourself.

Where you should host your website

What stack you should use
PHP (Programming Language)
Laravel (PHP Framework, it solves authentication, connection to databases and mailing)
HTML
CSS
Javascript

How can I install Apache, PHP, Mysql in DO?

https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-14-04

How can I install Laravel?
https://laravel.com/docs/5.7/installation

What about DDOS protection and SSL Certificate?

You can get it for free in https://cloudflare.com

How do I integrate it with my Lineage 2 server?

You can use Laravel Eloquent (PDO) to access to remote databases. Please read Laravel documentation.

Post in progress.






 

Share not sell.

Online Mobius

  • Administrator
  • Distinguished King
  • *****
  • Posts: 6724
Re: [WEB] How to build a strong infrastructure for l2 websites.
« Reply #1 on: January 07, 2019, 06:29:23 AM »
FYI all projects use the same encryption for passwords and account tables.
Only Interlude has a few fields less.

-- ---------------------------
-- Table structure for accounts (Interlude)
-- ---------------------------
CREATE TABLE IF NOT EXISTS `accounts` (
  `login` VARCHAR(45) NOT NULL default '',
  `password` VARCHAR(45),
  `email` varchar(255) DEFAULT NULL,
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastactive` bigint(13) unsigned NOT NULL DEFAULT '0',
  `accessLevel` TINYINT NOT NULL DEFAULT 0,
  `lastIP` CHAR(15) NULL DEFAULT NULL,
  `lastServer` TINYINT DEFAULT 1,
  PRIMARY KEY (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ---------------------------
-- Table structure for accounts (Others)
-- ---------------------------
CREATE TABLE IF NOT EXISTS `accounts` (
  `login` VARCHAR(45) NOT NULL default '',
  `password` VARCHAR(45),
  `email` varchar(255) DEFAULT NULL,
  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastactive` bigint(13) unsigned NOT NULL DEFAULT '0',
  `accessLevel` TINYINT NOT NULL DEFAULT 0,
  `lastIP` CHAR(15) NULL DEFAULT NULL,
  `lastServer` TINYINT DEFAULT 1,
  `pcIp` char(15) DEFAULT NULL,
  `hop1` char(15) DEFAULT NULL,
  `hop2` char(15) DEFAULT NULL,
  `hop3` char(15) DEFAULT NULL,
  `hop4` char(15) DEFAULT NULL,

  PRIMARY KEY (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

What you try to make can probably be used by all branches, Interlude to Salvation.
;D

Offline gamecoupon

  • Vassal
  • *
  • Posts: 5
  • Who are you?
Re: [WEB] How to build a strong infrastructure for l2 websites.
« Reply #2 on: March 20, 2019, 05:32:41 PM »
thank you for information!  :D 8)

Online Liamxroy

  • Inner Circle
  • Duke
  • *****
  • Posts: 621
Re: [WEB] How to build a strong infrastructure for l2 websites.
« Reply #3 on: March 20, 2019, 08:24:33 PM »
Excellent post .. keep going
I like Laravel but I prefer hand made php.