그누보드5에 실시간 채팅 구축하기

create table `g5_livechat` (
    `lc_id` int not null auto_increment primary key,
    `lc_mb_id` varchar(1024) not null,
    `lc_msg` text not null,
    `lc_date` datetime not null
)default charset=utf8 engine=MyISAM;

create table `g5_livechat_banlist` (
    `lb_id` int not null auto_increment primary key,
    `lb_mb_id` varchar(1024) not null unique key,
    `lb_reason` text not null
)default charset=utf8 engine=MyISAM;

const app = require('express');
const http = require('http').createServer(app);
const io = require('socket.io')(http);
const mysql = require('mysql').createConnection({
    host:cfg.db.host,
    port:cfg.db.port,
    user:cfg.db.user,
    password:cfg.db.password,
    database:cfg.db.dbname

var fs = require('fs');
var privateKey = fs.readFileSync('/etc/letsencrypt/live/yourdomain/privkey.pem')
var certificate = fs.readFileSync('/etc/letsencrypt/live/yourdomain/fullchain.pem');
var credentials = {key: privateKey, cert: certificate};
const app = require('express');
const https = require('https').createServer(credentials,app);
const io = require('socket.io')(https);
const mysql = require('mysql').createConnection({
    host:cfg.db.host,
    port:cfg.db.port,
    user:cfg.db.user,
    password:cfg.db.password,
    database:cfg.db.dbname
});

var socket = io.connect('wss://'+location.hostname+':1121/index.acnh?mb_id='+mb_id);

html {overflow-y:auto}
html, body {height:100%}
ul li{list-style:none;}
.send_button{width:40px;height:40px;line-height:38px;text-align:center;border-radius:999px;display:inline-block;font-size:17px;position:relative;bottom:14px;right:-6px;}
.send_button:hover{color:#323c46;}
.user_tag{color:#a300ff;}


.wrap_chat {height:100%}
.wrap_chat .cont_chat{margin-bottom:15px;}
.wrap_chat .header {background-color:#323c46;position:fixed;top:0;left:0;z-index:10;width:100%}
.wrap_chat .header>.title_area {display:flex;align-items:center;justify-content:center;min-height:50px;font-size:14px;font-weight:bold;color:#fff}
.wrap_chat .cont_chat {overflow-y:auto;overflow-x:hidden;position:absolute;left:0;bottom:53px;width:100%;top:50px;padding-bottom:10px}
.wrap_chat .cont_chat>ul {padding:8px 15px 8px;}
.wrap_chat .cont_chat>ul>li {padding:8px 0;}
.wrap_chat .cont_chat>ul>li.notice {color:#959595;text-align:center}
.wrap_chat .cont_chat>ul>li>.inner_talk {display:block;float:left;clear:both;margin-bottom:15px;}
.wrap_chat .cont_chat>ul>li>.inner_talk>.user_thumb {display:inline-block}
.wrap_chat .cont_chat>ul>li>.inner_talk>.user_thumb>a {overflow:hidden;position:relative;width:40px;height:40px;border-radius:50%;display:block;margin-bottom:15px}
.wrap_chat .cont_chat>ul>li>.inner_talk>.user_thumb>a:after {position:absolute;top:0;left:0;right:0;bottom:0;border:1px solid rgba(0, 0, 0, 0.06);border-radius:50%;content:'';margin-bottom:10px}
.wrap_chat .cont_chat>ul>li>.inner_talk>.talk_info {padding-left:7px;display:inline-block;}
.wrap_chat .cont_chat>ul>li>.inner_talk>.talk_info>.name {font-size:13px;white-space:nowrap;}
.wrap_chat .cont_chat>ul>li>.inner_talk>.talk_info>.bubble {margin-top:5px;overflow:hidden;z-index:0;max-width:100%;border-radius:3px 20px 20px;font-size:13px;background-color:#ececec;word-break:break-all;word-break:break-word;word-wrap:break-word;vertical-align:bottom}
.wrap_chat .cont_chat>ul>li.me>.inner_talk{float:right;}
.wrap_chat .cont_chat>ul>li.me>.inner_talk>.talk_info>.bubble{border-radius:20px 20px 3px;background-color:#afdefd;}
.wrap_chat .cont_chat>ul>li>.inner_talk>.talk_info>.bubble>.txt {padding:9px 12px;white-space:pre-wrap;word-break:break-all;}
.wrap_chat .cont_chat>ul>li>.inner_talk>.talk_info>.bubble:after {content:'';display:block;clear:both}
.wrap_chat .box_chat {position:fixed;left:0;bottom:0;width:100%;}
.wrap_chat .box_chat>.frame_msg {position:relative;background-color:#fff;-webkit-box-shadow: 0px -3px 17px 0px rgba(179,179,179,0.51);-moz-box-shadow: 0px -3px 17px 0px rgba(179,179,179,0.51); box-shadow: 0px -3px 17px 0px rgba(179,179,179,0.51);}
.wrap_chat .box_chat>.frame_msg textarea {outline: none;}
.wrap_chat .box_chat>.frame_msg>.tf_msg {width:calc(100% - 105px);overflow-y:auto;height:39px;/*position:fixed;bottom:0;*/padding:8px 12px;margin:14px 15px;margin-bottom:0;border:0 none;font-size:13px;resize:none;/*border:1px solid #000;*/border-radius:100px;background-color: whitesmoke;}

npm init -y && npm install express mysql socket.io -- save && nohup node server.js > /dev/null 2>&1 &

<a href="javascript:window.open('/chat/','','width=500,height=700')" ;return="" false;=""><strong>실시간 채팅</strong></a>

<a href="<?php echo G5_URL;?>/chat/" target="_blank">

npm init -y && npm install express mysql socket.io -- save && node server.js

  nodejs:
    container_name: nodejs
    image: node:alpine
    restart: unless-stopped
    working_dir: /home/node/app
    environment:
      - NODE_ENV=production
    ports:
      - "1121:1121"
    command: sh start.sh
    volumes:
      - ./node:/home/node/app
      - /etc/letsencrypt/live/yourdomain:/etc/letsencrypt/live/yourdomain
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro

sudo docker-compose up -d nodejs