L2JMobius
Free Users => Shares/Contributions => Topic started by: Firekarev 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
- The best option is digital ocean. https://digitalocean.com. They provide cheap linux vps from 5 usd.
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.
-
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
-
thank you for information! :D 8)
-
Excellent post .. keep going
I like Laravel but I prefer hand made php.