gantz

Fox fix some image size issue need also use this nemo patch http://nemo.herc.ws/patches/ChangeCaptchaImageDecompressionSize/

Macro Detection Interface
 
Four new client interfaces are getting implemented in Hercules:
- Macro Register UI
- Macro Detector UI
- Macro Reporter UI
- Captcha Preview UI
 
Usable though the chat commands: /macro_register, /macro_detector, macro_preview for all clients starting 2016-06-30.
Available for testing now at: https://github.com/HerculesWS/Hercules/pull/3051
 
Some sample images

This is a work in progress. Parts will be added as they are organized.
 
This topic will list out the major episode releases of kRO and the updates under them. This is to keep track of what episodes had which updates. This will assist us in making sure we aren't missing anything in Hercules. The dates below are for Main server release, not RE/Sakray testing period.
 
* Note: Official Hercules Developers and High Council members have permission to add or modify this list.
2002.08.03: Episode 1.0 : Start of the Adventure
2002.12.17: Episode 2.0 : Lutie
2003.02.04: Episode 3.0 : Comodo
2003.05.02: Episode 4.0 : War of Emperium
2003.07.15: Episode 5.0 : Yuno
2003.10.07: Episode 6.0 : Global Project
2003.10.11 : Amatsu 2003.10.11 : Kunlun / Gonryun 2003.11.25 : Weddings/Marriage 2004.01.13 : Super Novice 2004.01.30: Episode 7.0 : Umbala ~ Village of the Utan Tribe
2004.02.02 : 2-1 and 2-2 class in Sakray 2004.02.24: Episode 8.1.1 : Niflheim ~ City of the Dead
2004.12.23: Episode 8.1.2 : Louyang & Jawaii
2004.12.23: Episode 8.2 : Ayothaya
2005.01.18: Episode 8.3 : Payon Remodelling
2005.05.12: Episode 9.0 : Rebirth
2005.09.21: Episode 10.1.1 : The Sign & Geffenia Dungeon
2005.09.22: Episode 10.1.2 : Einbroch
2006.02.24: Episode 10.2 : Lighthalzen
2005.08.16: Episode 10.3 : Noghalt
2006.12.28: Episode 10.4 : Hugel
2007.04.20: Episode 11.1 : Rachel
2007.09.10: Episode 11.2 : Veins
2007.04.10: Episode 11.3 : Nameless Island
2007.04.10 : Mercenary System 2007.10.17: Episode 12 : Satan Morroc
2007.10.17 : Moscovia 2007.11.21 : WoE: SE (Schwaltzvald) 2007.11.21 : WoE: SE (Arunafeltz) 2007.12.05 : World Map System 2007.12.10 : Battlegrounds 2007.12.12 : Endless Tower & Sealed Shrine 2008.06.25 : Episode 13.1 : Ash Vacuum
2008.08.25 : Poring Wars 2008.11.19 : Improved Pet System 2008.12.17 : Episode 13.2 : Encounter
2008.12.23 : New Pets 2009.02.25 : Hidden Slot Enchantment 2009.03.11 : Endless Tower Fixes 2009.04.08 : New Hairstyles 2009.06.17 : Renewal Release (3-1 Jobs) 2009.08.19 : Brasilis 2009.10.14 : 3-2 Jobs 2009.12.23 : Episode 13.3 : El Dicastes
2010.03.17 : Party Recruiting System 2010.03.31 : Baby 3rd Jobs 2010.05.12 : Purchasing Shops. Sorcerer Spirit System 2010.06.30 : Episode 14.1 : Bifrost
Memorial Dungeon, Misty Labyrinth Forest. 2010.07.28 : Equipment Synthesis, Costume System. 2010.08.18 : Search Vending Shops 2010.09.29 : Indonesia Localized Map, Dewata 2010.11.24 : Cat Hand HQ / Malangdo Island Item Mall Icon Level 86~99 Eden Group Quests on 2nd Floor Floor 6 added to Izlude Dungeon (Only available to Gold Netcafe Users) Grave Markers (MVP or major monster dies, it leaves a grave marker that shows the time of death and who killed it. The gravestone will remain until the monster respawns.) New Mounts
  2010.12.29 : Super Novice Expansion 2011.03.09 : Replay System 2011.03.30 : Biolabs 4th Floor 2011.05.25 : Thanatos Tower Changes. 2011.06.29 : (WoE1 Renewal) Number of forts reduced from 5 to 4 in WoE1 castles. Guild Investment System (Hall of Abyss). New Guild Dungeon
  2011.08.17 : 7x7 Padding around NPCs. 2011.08.31 : (Class Balance + Homunculus S) Large number of class balancing improvements. Homunculus S
  2011.09.28 : Philippines localized map, Port Malaya. [1] [2] 2011.11.02 : Kagero and Oboro Job Classes [1] [2] 2011.11.16 : New Alberta. 2011.11.30 : Eden Quests for levels 100~110. 2011.12.07 : Nightmare mode for Pyramid Dungeon. 2011.12.14 : Party System improvements. 2011.12.21 : Episode 14.2 : Eclage
2011.12.27 : Battlegrounds Queue System 2012.02.08 : New Carts for Mechanics & Genetics. 2012.02.08 : Guild Creation system to no longer allow blank space(s) in the name. 2012.03.21 : Eden Quests for Level 111 ~ 120. 2012.03.21 : Falcon Flute 2012.03.28 : Navigation System. 2012.03.28 : New Izlude + Novice Training Academy + New Character Creation Method (5 copies of Izlude) 2012.04.04 : HP Bars added to Monsters. 2012.04.18 : Changes to Enchanting on Malangdo 2012.04.25 : WoE: Training Edition 2012.04.25 : Transcendent quest to waive the cost of transcending. 2012.05.30 : Old Glastheim memorial dungeon 2012.06.13 : Monster Shadow Size 2012.07.11 : Headgear Synthesis Quests 2012.07.25 : WoE:TE Mini God Item quest + guild and daily quests in siege areas. 2012.08.14 : Job EXP increased from Monsters with lvl 100+. 2012.08.22 : Heroes' Trails (Part 1) Faceworm Nest, Memorial Dungeon. Sarah's Memory, Memorial Dungeon.
  2012.08.22 : Memorial Dungeon, Wave. Added new Eden quests for level 121 ~ 130 range Max base level changed from 150 to 160/50. Skill Timers
  2012.09.19 : Champion Mobs. 2012.10.10 : Ranger Falcon changed to Owl. 2012.10.17 : Heroes' Trails (Part 2) Devil's Tower Memorial Dungeon Cursed Knight Memorial Dungeon Geffen Magic Tournament Memorial Dungeon
  2012.10.31 : Eden Quests for levels 131~140. 2012.12.18 : Horror Toy Factory Memorial Dungeon 2012.12.18 : Shadow System 2012.12.28 : Episode 14.3 : Decisive Battle (Part 1)
2013.02.20 : Equipment Comparison System 2013.03.13 : 'Clock Tower Dungeon' Nightmare Mode. 2013.03.20 : Episode 14.3 : Decisive Battle (Part 2)
2013.03.20 : Level Increased to 175 / 60. 2013.03.20 : New Third Class Skills 2013.05.22 : Max Zeny Vending Price = 1 Billion Zeny. 2013.06.12 : Bank System 2013.06.26 : Clan System (Golden mace Guild, Sword Guild, Crossbow Guild and Rod Guild) 2013.07.03 : Episode 15.1 : Fantasmagorica
Lots of NPC placement changes. 5 New Quests Memorial Dungeon, Charleston Factory New Items 2013.07.31 : Rebellion Class 2013.08.02 : Rebellion Weapons 2013.08.14 : New Clothing Dyes for Kagerou & Oboro classes. 2013.08.21 : Max HP Limits (lvl 99 = 330k, 150 = 660k, 175 = 1.1m) 2013.09.25 : Heroes' Trail Part (Part 3) Fenrir and Airship Assault Memorial Dungeons.
  2013.12.17 : Nightmare Biolabs 2013.12.23 : Episode 15.2 : Memory Record
2014.01.08 : New World Map. 2014.01.22 : Shop History (Buy/Sell Log) 2014.03.12 : Eden Group Market Hall 2014.04.16 : Summons & Homunculus S Update 2014.08.06 : Monster EXP Increased (Base 75% & Job 100%) 2014.08.06 : Monster HP/ATK Adjustment 2014.09.16 : WoE TE Items 2014.10.07 : Lucky Roulette 2014.10.07 : Pet Evolution 2014.10.28 : Infinite Space 2014.11.05 : Clan System 2014.11.11 : RoDex (Revamped Mail System) 2015.02.25 : Episode 16.1 : Banquet of Heroes
2015.02.25 : Achievement and Title System Added 2015.02.25 : Banquet Preparation 2015.02.25 : New Dungeon 2015.02.25 : Honor Tokens and New Enchant Item 2015.07.01 : Infinite Space Dungeon Improvements 2015.10.07 : Item Link System (show your items via PM) 2015.10.07 : Eden Group Revamp (missions changed) 2015.10.14 : Reputation System 2016.01.26 : Styling Shop Interface 2016.03.09 : Episode 16.2 : Terra Gloria
2016.05.10 : Rebellion Class Changes 2016.08.30 : Card Removal System Update 2016.09.06 : Eden Group Changes (100-140) 2016.12.07 : Rock Ridge 2016.12.13 : Marriage System Update (Doram x Human) 2016.12.27 : New Dungeon : Illusion of Moonlight 2017.01.03 : Glastheim Changes 2017.01.25 : New Dungeon : Illusion of Vampire 2017.02.21 : New Dungeon : Illusion of Frozen 2017.04.18 : New Dungeon : Illusion of Abyss 2017.05.23 : Party System UI Update 2017.06.07 : Autotrading / Vending Overhaul 2017.06.21 : Equipment Replace System 2017.06.21 : Orc Memory Changes 2017.06.27 : Monster Racing Revamp 2017.09.26 : Moscovia Card Updates 2018.03.09 : New Dungeon : Illusion of Teddy Bear 2018.05.04 : New Dungeon : Illusion of Luanda 2018.06.27 : World Map Improvements 2018.07.18 : Episode 17.1 : Illusion
2018.08.09 : Max Level Increased to 185

@gantz @Promeister
 
this drop effect is already in hercules emulator, it could be set in the itemdb.conf

I just made a plugin to integrate the drop effect with item options wherein the effect will depend on the item options that the item has like in Diablo
 
:)

If you are a totally newbie and plan to open a server with that population, please reconsider. Your players will get disappointed with your knowledge.

As a starter you may practice on your own offline server , when you are confident enough on your knowledge, publish a server for your friends and it will help you to gain experience.  Later you can publish a small server to gain management experience. Eventually you may try to open a server for big population which requires enormous money, knowledge, experience, passion and dedication.

this is probably one of my famous script, just realize it recently
Download : 1.2
script
 
 
History :
originally this was only made for fun
https://rathena.org/board/topic/73478-requesting-card-seller-script/?do=findComment&comment=154507
but then Euphy loves it, so it was added in SVN later,
https://rathena.org/board/topic/89071-development-news/?do=findComment&comment=242965
but then rAthena changed their monster mode
https://github.com/rathena/rathena/commit/55e4df14c2141f291a985c391408a045ec1b25c4#diff-9120180df02487486d9abaddf38f9c49
after this script was reported broken, couldn't use in Hercules anymore
https://github.com/rathena/rathena/issues/2844
so I have to fix this script for use in Hercules
my KRO still not update enough to use Barter system, but this format shouldn't be very far from it
 

There are MANY variations of Lotti Girl script, even me too, have made several of them
so today I try to gather them all, and make a release with ALL features from all the topics gathered
Download:
script
 
Feature no.1 -> show the percentage chance

chinese government has a rule that all lottery system must show the percentage chance to the public
hence the script should show the lottery chance in percent
Feature no.2 -> Roll Repeatedly
imagine if you have 500 tickets, and you want to spend them all,
all other scripts available on rathena board will force the player to spend them 1 by 1
this script can roll up to 100 times on the fly, effectively save player's time
Feature no.3 -> Lotti shop
even if you spend a lot of tickets and still getting all the trash items, you still collecting points, and able buy them in Lotti Shop
Feature no.4 -> Lotti ladder
compete with other players and see who has the highest Lotti Rank !
 
oh and ... HULD compatible == rAthena members can't use this
 

Hi,
 
A few days ago I released the first version of an open-source patcher I've been working on. The project has been developed in Rust and the UI is based on the webview project.
The project also includes a cross-platform, command-line THOR patch generator.
 
The patcher's current features are the following:
* Customizable, web-based UI
* Cross-platform (Windows 7/8/10, Linux, macOS)
* Configurable through an external YAML file
* HTTP/HTTPS support
* GRF file patching (version 0x101, 0x102, 0x103 and 0x200)
* THOR patch format support
* Drop-in replacement for the Thor patcher
* SSO login support (i.e., can act as a launcher)
* Manual patching
* Can use multiple patch mirrors
 
The project's repository can be found here: https://github.com/L1nkZ/rpatchur (and documentation can be found here). Contributions are welcome!
 
Releases
v0.3.0: https://github.com/L1nkZ/rpatchur/releases/tag/v0.3.0
v0.2.3: https://github.com/L1nkZ/rpatchur/releases/tag/v0.2.3
v0.2.2: https://github.com/L1nkZ/rpatchur/releases/tag/v0.2.2
v0.2.1: https://github.com/L1nkZ/rpatchur/releases/tag/v0.2.1
v0.2.0: https://github.com/L1nkZ/rpatchur/releases/tag/v0.2.0
v0.1.0: https://github.com/L1nkZ/rpatchur/releases/tag/v0.1.0

Over the last few days I have been playing with Google Cloud services
because Google cloud currently offers $300 free credit upon signing up
yes, FREE $300 credit
and thus my journey trying to host hercules server on a VPS has begun
 
all you need is a valid Debit/Credit card number ...
of course you have to be an adult to try the hosting service ... right ?
 

 
 
oh and, don't worry, you can always cancel it anytime

 
after playing with it, I found the Windows option is too expensive, and thus trying to learn the Linux option
 
This guide is actually demonstrate by using a trash gmail account that can throw away later
I don't mind all the credentials are shown in the screenshot, when I click the Open topic button I have deleted this project on Google Cloud
 
 
Step 1. Download Putty and WinCP
https://www.putty.org/.
https://winscp.net/eng/download.php
 
Step 2. Run Google Cloud
2.1 login to your Google cloud project
https://github.com/AnnieRuru/customs/blob/master/server hosting/2.png
 
2.2 first you need to link your credit card to this google cloud
https://github.com/AnnieRuru/customs/blob/master/server hosting/3.png.
https://github.com/AnnieRuru/customs/blob/master/server hosting/4.png
select the billing option to the debit/credit number you input earlier
https://github.com/AnnieRuru/customs/blob/master/server hosting/5.png
this billing information is very important, you need to check this once in a while to stop unwanted services <-- please scroll to the right
 
2.3 pin these 3
- billing
- compute engine
- VPC network
https://github.com/AnnieRuru/customs/blob/master/server hosting/6.png
 
2.4 now time to create a VPS, select Compute Engine
https://github.com/AnnieRuru/customs/blob/master/server hosting/7.png
2.4.1
enter all the necessary information
1. the Virtual machine name
2. your nearest location
3. the spec of the machine
https://github.com/AnnieRuru/customs/blob/master/server hosting/8.png
 
PS: I tested the cheapest option, N1 series, f1 micro 614MB memory and E2 micro, 1GB memory
when compiling hercules later, putty just stop ... I think it run out of memory
... hercules should have mention a recommendation needs at least 2GB memory to run
 
2.4.2
4. Select Boot Disk as CentOS 8
https://github.com/AnnieRuru/customs/blob/master/server hosting/9.png
5. select allow HTTP and HTTPS
https://github.com/AnnieRuru/customs/blob/master/server hosting/10.png
 
2.4.3
6. Click Security tab
https://github.com/AnnieRuru/customs/blob/master/server hosting/11.png
needs to 'Enter public SSH key'
 
run Putty Key Generator and click Generate
https://github.com/AnnieRuru/customs/blob/master/server hosting/12.png
 
1. change the 'key comment' as it will become user name
2. save private key to desktop
3. copy the field
https://github.com/AnnieRuru/customs/blob/master/server hosting/13.png
 
paste into Google cloud
https://github.com/AnnieRuru/customs/blob/master/server hosting/14.png
 
2.4.4
select Networking tab
https://github.com/AnnieRuru/customs/blob/master/server hosting/15.png
create a static IP address
https://github.com/AnnieRuru/customs/blob/master/server hosting/16.png
choose standard tier
 
after everything done click [Confirm]
https://github.com/AnnieRuru/customs/blob/master/server hosting/17.png
and you get your virtual machine running
https://github.com/AnnieRuru/customs/blob/master/server hosting/18.png
 
2.5
once your server up and running
run Putty to connect to this server
https://github.com/AnnieRuru/customs/blob/master/server hosting/19.png
1. scroll down, expand 'SSH' to select 'Auth',
2. then load the file you saved earlier by PuttyGen
https://github.com/AnnieRuru/customs/blob/master/server hosting/20.png
3. enter the public IP address,
4. then click open
 
https://github.com/AnnieRuru/customs/blob/master/server hosting/21.png
it will prompt you with security alert, just click yes
 
2.6
login with your user name
https://github.com/AnnieRuru/customs/blob/master/server hosting/22.png
 
The very first command you should run is change the password
sudo passwd root ok Windows Users, don't freak out like me
there are no ******** when you input the password, this is Linux not Windows
just input normally ... and press Enter key, it works that way
https://github.com/AnnieRuru/customs/blob/master/server hosting/23.png
then do the same with your username
sudo passwd annie  
3. update the OS and install all necessary product
 
3.1 run all these commands
sudo yum update sudo yum install gcc make mysql mysql-devel mysql-server pcre-devel git zlib-devel Transaction Summary ================================================================================ Install 89 Packages Total download size: 108 M Installed size: 395 M Is this ok [y/N]: Press 'Y' key
 
3.2
in the meantime, while this might take awhile, try login WinCP
https://github.com/AnnieRuru/customs/blob/master/server hosting/24.png
click new session, then click advance
https://github.com/AnnieRuru/customs/blob/master/server hosting/25.png
select 'Authentication' and load the Putty Gen file again
https://github.com/AnnieRuru/customs/blob/master/server hosting/26.png
just another warning
https://github.com/AnnieRuru/customs/blob/master/server hosting/27.png
 
 
3.3 Download Hercules
git clone https://github.com/HerculesWS/Hercules.git ~/Hercules  
4. SQL
 
4.1 Start SQL service
sudo systemctl start mysqld.service  
4.2 login as root
mysql -u root -p Enter password, just press enter
default centOS 8 preinstalled MySQL, root has no password
 
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 10 Server version: 8.0.21 Source distribution Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> 4.3 create database
CREATE DATABASE hercules; 4.4 select hercules database as default
USE `hercules`; 4.5 create another user, not recommend to connect as root
CREATE USER 'annie'@'localhost' IDENTIFIED BY '1234'; 4.6 grant this user privilege
GRANT SELECT,INSERT,UPDATE,DELETE ON * TO 'annie'@'localhost'; 4.7 then quit
quit it should show like this
mysql> quit Bye [annie@centos ~]$ 4.8 goto sql-files directory
cd /home/annie/Hercules/sql-files/ and run all these
mysql -u root -p hercules < main.sql mysql -u root -p hercules < logs.sql mysql -u root -p hercules < item_db_re.sql mysql -u root -p hercules < mob_db_re.sql mysql -u root -p hercules < mob_skill_db_re.sql it should show like this
[annie@centos ~]$ cd /home/annie/Hercules/sql-files/ [annie@centos sql-files]$ mysql -u root -p hercules < main.sql Enter password: [annie@centos sql-files]$ mysql -u root -p hercules < logs.sql Enter password: [annie@centos sql-files]$ mysql -u root -p hercules < item_db_re.sql Enter password: [annie@centos sql-files]$ mysql -u root -p hercules < mob_db_re.sql Enter password: [annie@centos sql-files]$ mysql -u root -p hercules < mob_skill_db_re.sql Enter password: [annie@centos sql-files]$ 4.9 go back login mysql and change inter-server connection password from s1/p1 into qwer/asdf
mysql -u root -p and
UPDATE `hercules`.`login` SET `userid` = 'qwer', `user_pass` = 'asdf' WHERE `account_id` = 1;  
5. Compile Hercules
 
go back to annie/hercules folder
cd /home/annie/Hercules/ 5.1 type ./configure
./configure  
OK STOP, many things can go wrong here, I stuck here for a few days and searching on both rathena and hercules forum for answers
the correct output from putty should be this
checking mysql.h presence... yes checking for mysql.h... yes checking whether my_bool is supported (MySQL)... no (converting my_bool to bool) checking MySQL library (required)... yes (8.0.21) checking PCRE library... checking pcre.h usability... yes checking pcre.h presence... yes checking for pcre.h... yes checking for library containing pcre_study... -lpcre checking for doxygen... no checking for perl... yes configure: creating ./config.status config.status: creating Makefile config.status: creating src/common/Makefile config.status: creating 3rdparty/mt19937ar/Makefile config.status: creating 3rdparty/libconfig/Makefile config.status: creating 3rdparty/libbacktrace/Makefile config.status: creating 3rdparty/libbacktrace/backtrace-supported.h config.status: creating src/char/Makefile config.status: creating src/login/Makefile config.status: creating src/map/Makefile config.status: creating src/plugins/Makefile config.status: creating src/test/Makefile config.status: creating tools/HPMHookGen/Makefile config.status: creating tools/doxygen/Makefile [annie@centos Hercules]$ if it doesn't show config.status: at the end, open a new topic in Linux support
if it's the same as mine, then can proceed with
 
5.2 compile hercules
make sql finally compile should show like this
CC party.c CC path.c CC pc.c CC pc_groups.c CC pet.c CC quest.c CC refine.c CC rodex.c CC script.c CC searchstore.c CC skill.c CC status.c CC storage.c CC stylist.c CC trade.c CC unit.c CC vending.c LD map-server make[1]: Leaving directory '/home/annie/Hercules/src/map' building conf/import folder... [annie@centos Hercules]$  
6. configure Hercules
 
6.1 start hercules by
./athena-start start https://github.com/AnnieRuru/customs/blob/master/server hosting/28.png
of course the reason why connect to SQL failed is because haven't configure Hercules so ....
stop it from running for a moment
./athena-start stop  
6.2 login to WinCP
https://github.com/AnnieRuru/customs/blob/master/server hosting/29.png
... I will assume you know how to change your public IP address on hercules
the file you should change are
map-server.conf
- userid: "qwer"
- passwd: "asdf"
- map_ip: "35.213.138.42"
- char_ip: "35.213.138.42" char-server.conf
- userid: "qwer"
- passwd: "asdf"
- login_ip: "35.213.138.42"
- char_ip: "35.213.138.42" conf\global\sql_connections.conf
-db_hostname: "localhost"
- db_port: 3306
- db_username: "annie"
- db_password: "1234"
- db_database: "hercules" conf\network.conf
.....<let me test this thing again> ....  
<--- I will assume everyone reading this guide already know how to host an offline server, if not click here -->
 
now run ./athena-start start again, and this time map-server couldn't connect to char-server
 
7. Configure firewall
 
7.1 run these 3 commands
sudo firewall-cmd --permanent --add-port 6900/tcp sudo firewall-cmd --permanent --add-port 6121/tcp sudo firewall-cmd --permanent --add-port 5121/tcp 7.2 reload the firewall settings
sudo firewall-cmd --reload 7.3 go back to Google Cloud,
https://github.com/AnnieRuru/customs/blob/master/server hosting/30.png
to create firewall
https://github.com/AnnieRuru/customs/blob/master/server hosting/31.png
configure the firewall
https://github.com/AnnieRuru/customs/blob/master/server hosting/32.png
2. & 3. configure firewall only to this project
https://github.com/AnnieRuru/customs/blob/master/server hosting/33.png
 
4. at 'tcp:' tab, only allow these 3 ports
https://github.com/AnnieRuru/customs/blob/master/server hosting/34.png
 
7.4
run ./athena-start start again.
then goto https://portchecker.co/ and check your port is open
https://github.com/AnnieRuru/customs/blob/master/server hosting/35.png
And Finally go to your client edit data/sclientinfo.xml to the WAN IP and

VIOLA !! DONE !!
I can connect my client to google cloud
 
PS: the port checker website only shows Port 6900 is OPEN. only if fulfill these 3 conditions
1. enable firewall setting on CentOS
2. enable firewall setting on Google Cloud
3. run the emulator by ./athena-start
 
 
Ok now you can start worry about security issue like adding additional user in CentOS
https://www.digitalocean.com/community/tutorials/how-to-add-and-delete-users-on-a-centos-7-server
google cloud doesn't seem to allow login that way -> https://stackoverflow.com/questions/52503453/how-to-login-gcp-console-without-ssh
and mysql root account password change ...
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234'; etc...etc...
need more research
 
 
Connect to MySQL in CentOS 8 using Window's MySQL Workbench
 
1. add another connection
https://github.com/AnnieRuru/customs/blob/master/server hosting/mysql1.png
 
2. under 'Connection Method', select 'Standard TCP/IP over SSH'
https://github.com/AnnieRuru/customs/blob/master/server hosting/mysql2.png
 
3. configure these fields
3.1 SSH hostname is the server IP address
3.2 SSH username is the name you created with PuttyGen
3.3 SSH keyfile needs a conversion with PuttyGen
3.4 and Click [Test Connection]
https://github.com/AnnieRuru/customs/blob/master/server hosting/mysql3.png
 
4. the SSH keyfile needs to be convert from PuttyGen
4.1 load existing private key, in this case was 'annie.ppk'
4.2 click conversion and save as 'annie' without file extension
https://github.com/AnnieRuru/customs/blob/master/server hosting/mysql4.png
 
5. if successful it will show like this
https://github.com/AnnieRuru/customs/blob/master/server hosting/mysql5.png
 
then you can login into MySQL in CentOS
 
did I forgot to mention needs to open the port 3306 in CentOS and Google Cloud ? refer back to step 7
 
Reference: https://stackoverflow.com/questions/21527743/mysql-workbench-version-6-0-8-ssh-authentication-issue
 
 
After thought :
Overall I'm very satisfy with Google Cloud service,
1. free $300 credit to spend
2. can always register trash gmail account to make the credit infinite
  - of course the IP will always change if you do so
3. very low latency from Malaysia connect to Singapore - just 30~40ms ping
 
I haven't try OVH which everybody is recommending, but they doesn't offer immediate free credit for me to test so meh .....
 
and I notice Hercules's wiki CentOS guide is broken, maybe I'll fix it
https://github.com/HerculesWS/Hercules/wiki/Installation-(CentOS)
 
- offtopic -
over last few days playing with google cloud, when I visit Youtube, all my advertisement become Monday.com etc etc group project stuffs
google really knows how to collect my data

Topic re-approved, good luck!
 

You need a cheap Designer? then Ganz is your best chooice !
 
 
Fast Delivery
Perfect Support
Nice Prices
Nice Man

You forgot to include the npc script https://github.com/dastgir/HPM-Plugins/blob/master/NPC/security.txt

The 3rd premade finally released!
 
All fluxcp premades are compatible with eAthena, rAthena and Hercules
it comes with SQL scripts and in-game scripts to make add-ons working.
 


New Release Premade v3 Website & Patcher 







New Premade v2 Patcher 



 

Recent Graphic Works...
 

 

 

 

I'm available again leave me a message on my contact informations.


 

 

Latest graphic works...




 

File Name: Gantz - FREE Thor Patcher(Sky Blue)
File Submitter: gantz
File Submitted: 09 Aug 2014
File Category: Client Resources
 
Gantz 2nd Free Thor Patcher
-Sky blue Theme
-Full Coded Patcher
-With web files, PSD and patcher Files
 
Website: gantzservices.com
Skype: facebook:rayshin2
FB Page: facebook.com/gantzservices
 
Click here to download this file

Fully Coded Website, Patcher and Banner
Prize: 60$
Slot: 0/5
FREE Setup
FREE Banner Rotator Hosting and 2 Sample Banner Images
FREE Banner GIF
 
For inquiries: 
Email: [email protected] Skype: facebook:rayshin2 Hercules: Message me here  rAthena: Message me here
 

Website Full Preview: Preview
 

 

 
 
 

you must learn Basic HTML and CSS with a little bit PHP to be able to read and manipulate codes of flux control panel