Jump to content

UniC

Members
  • Content Count

    88
  • Avg. Content Per Day

    0
  • Joined

  • Last visited

  • Days Won

    3

UniC last won the day on April 26 2019

UniC had the most liked content!

Community Reputation

36 Excellent

1 Follower

About UniC

  • Rank
    Santa Poring

Profile Information

  • Gender
    Male
  • Location
    Philippines
  • Github
    Alexander9673

Contact Methods

  • Discord
    _alexander#9673

Recent Profile Visitors

618 profile views
  1. The only advantage this has is the fact that it's simple to use, has an easy to setup config. But you need to install node.js And this would also work for linux.
  2. Version 1.0.0

    38 downloads

    sqlbackup A super simple and lightweight SQL Database Backup System. This auto backsup your database every 24 Hours or more. Can't go less. Requirements - NodeJS v12+ - Understanding Installation - Download the Code. (can use git) - Go to the main directory of the code using your terminal/cmd. (Where index.js is) // run $ node . // or $ node index How to run this 24/7? This will close when you close your terminal. I good way to keep this up without closing is using `pm2`. To install `pm2`, simply do the following. $ npm install pm2 -g // or $ yarn add pm2 -g How would i run it? $ pm2 start index.js (Make sure you're in the main directory of the code. Where index.js is) That would make it run 24/7 even when closing the terminal/cmd. Config Defaults: { "mysql": { "username": "username", "password": "password", "host": "localhost", "port": 3306, "databases": [ "rathena4444_rag", "rathena4444_log" ] }, "backupInterval": 86400 } config.mysql is where all your mysql data would be. *.username is what your mysql username is. *.password is the password for your mysql username. *.host is where the mysql server is hosted. 127.0.0.1 or localhost for the same host or vps. *.port is the port of the mysql host. *.databases[] an array of the name of the databases to backup. config.backupInterval is the amount of seconds to wait before creating a new backup. Default is 86400 (1 day). Take note that you can't go less than 86400. How does this work? I simply used child_process to create a new process and would run mysqldump to export Mysql databases. After exporting, the code closes the process of the ran command and then would wait for the interval to be finished, then repeat the process.

    Free

  3. A much faster and easier way that worked for me is installing node.js. Once installing it, simply open Windows Powershell as Admin then run `npm install windows-build-tools -g` After that, open start menu and find MSBuild Command Prompt. Then go to your rAthena dir and build using `msbuild`. You could also try finding where `msbuild.exe` is located then add it to your path for much easier access.
  4. sqlbackup A super simple and lightweight SQL Database Backup System. This auto backsup your database every 24 Hours or more. Can't go less. Download (Code Here) Requirements - NodeJS v12+ - Understanding Installation - Download the Code. (can use git) - Go to the main directory of the code using your terminal/cmd. (Where index.js is) // run $ node . // or $ node index How to run this 24/7? This will close when you close your terminal. I good way to keep this up without closing is using `pm2`. To install `pm2`, simply do the following. $ npm install pm2 -g // or $ yarn add pm2 -g How would i run it? $ pm2 start index.js (Make sure you're in the main directory of the code. Where index.js is) That would make it run 24/7 even when closing the terminal/cmd. Config Defaults: { "mysql": { "username": "username", "password": "password", "host": "localhost", "port": 3306, "databases": [ "rathena4444_rag", "rathena4444_log" ] }, "backupInterval": 86400 } config.mysql is where all your mysql data would be. *.username is what your mysql username is. *.password is the password for your mysql username. *.host is where the mysql server is hosted. 127.0.0.1 or localhost for the same host or vps. *.databases[] an array of the name of the databases to backup. config.backupInterval is the amount of seconds to wait before creating a new backup. Default is 86400 (1 day). Take note that you can't go less than 86400. How does this work? I simply used child_process to create a new process and would run mysqldump to export Mysql databases. After exporting, the code closes the process of the ran command and then would wait for the interval to be finished, then repeat the process.
  5. How does FluxCP fetch the server status of a server? And how do they make it so it doesn't consider it a ddos attack.
  6. Question though, why the name PainItBlack?
  7. UniC

    Storage Items

    ah okay thanks
  8. UniC

    Storage Items

    so it just uses the itemdb and convert it to iteminfo.lua and then uses that as reference ?
  9. UniC

    Storage Items

    @sader1992 ah so it uses the itemInfo.lua instead?
  10. UniC

    Storage Items

    how does fluxcp get the item names when it display storage item?
  11. Why not just use the floating ip as the server ip?
  12. How does fluxcp insert the YYYY-MM-DD format in birthdate, cause when i do it, it is formatted to iso. Thanks. Edit: ( Making it much clearer ) Was wandering what does fluxcp do in order to save YYYY-MM-DD format to the birthdate column. Because when i did it, using nodejs. It formatted it to an ISO Date. Anyone knows why?
  13. You don't need to do those, just make sure that your ragnarok server and vps server is in the same ip/machine. Grab your ip by searching "What's my ip". And once you have it, just open ports for that ip. If you're on a VPS, use that ip. And open the ports for char, map and login server. By default those ports are 6900, 5121, 6121
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.