Share [AEPVP-SOURCE] Server FAQ

[xdem]

This is an interesting one,

A mini ingame-forum HTML based where you can dynamically add a new Topics.

Features:
Players create Topics that can include text or html for a guide/feature/update or whatever

Players can Like a topic (it will appear higher on the list)

GMs can approve/delete/hide/pin a Topic

 

 

 

 

 

FaqController.java (Single File)

 

HTMLs

 

SQL:

Quote

CREATE TABLE `server_faq` (
    `topic_id` INT(10) NOT NULL,
    `author_id` INT(10) NULL DEFAULT NULL,
    `title` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
    `content` VARCHAR(2048) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
    `icon_a` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
    `icon_b` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
    `likes` INT(10) NULL DEFAULT '0',
    `status` INT(10) NULL DEFAULT '0',
    PRIMARY KEY (`topic_id`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;
CREATE TABLE `server_faq_likes` (
    `topic_id` INT(10) NOT NULL,
    `player_id` INT(10) NOT NULL,
    PRIMARY KEY (`topic_id`, `player_id`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;
 

 

 

 

Get rid of PlayerPassport as I am not sharing this, and replace it with player.getObjectId()

You will have to move this HTML into your CB because your HTMLs are smaller than mine

 

Edited June 13, 2021 by xdem

[InTheEndॐ]

I think mxc missed some innovative codes,congrats my friend for sharing your ages of experience to pure human beings

[HyperBlown]

Thx for the code!


Adapted for Sunrise: 
https://pastebin.com/84umuuL2

To Adapt to other chronicles, its pretty easy. Use your head if you have one to do so.

Htmls -> Same location as declared on original post
SQL -> Same as original
For those with the problem on the getHtml -> put player before the html path and change getHtml to getHtm it should be resolved.
Problems with trove library?
> https://mega.nz/file/l04UwTKL#ap1OK7KQD0DowRl3CUFNFaG6yK2sbCEEOsKOCpf0EMw and add as dependency to your project.

* @author xDem (https://maxcheaters.com/profile/76276-xdem/)
* Adapted Sunrise: l2jgabdev.com

Edited June 16, 2021 by HyperBlown

[xdem]

thank you @HyperBlown

 

PS: Trove can be avoided by using 

Map<Integer,  FAQTopic> instead of TIntObjectHashMap<FAQTopic>

HashSet<Integer> instead of TIntHashSet

Edited June 14, 2021 by xdem

[xRelic]

completely indifferent, when no one, not even you, would use it