Jump to content

AnnieRuru

Script Developers
  • Content Count

    1671
  • Joined

  • Last visited

  • Days Won

    220

AnnieRuru last won the day on November 22

AnnieRuru had the most liked content!

About AnnieRuru

  • Rank
    ~~Cute~Cute~Scripter~~

Contact Methods

  • Discord
    AnnieRuru#1609

Profile Information

  • Gender
    Female
  • Location:
    your next door ~
  • Interests
    event scripts ~ battleground scripts ~
    making battleground scripts is my hobby ~
  • Github
    AnnieRuru
  • Emulator
    Hercules
  • Client Version
    2019-05-30aRagexeRE

Recent Profile Visitors

14278 profile views
  1. its either monthly or weekly, no both if needs both, its still possible but whole system needs to rewrite, not a free script anymore (means I charge for it) https://github.com/AnnieRuru/Release/blob/master/scripts/PvP %26 GvG/Dota PVP ladder/dota_sql_ladder_3.6_week_reward.txt
  2. must be caused by `@killmonster` or something like that just tested `@killmonster` or `@killmonster2` will trigger the monster label, so ... shouldn't happen this way script `*killmonster` or `*killmonsterall` ?? then there's the problem ..... - script Punching Bag FAKE_NPC,{ OnInit: .mobid = monster("prontera",158,183, "Punching Bag", BARRICADE, 1, "Punching Bag::OnInit"); setunitdata .mobid, UDT_MAXHP, 2000000000; OnTimer10000: if (getunittype(.mobid) == -1) end; setunitdata .mobid, UDT_HP, 2000000000; initnpctimer; end; } I thought the *unitexists script command is useless so I never made a pull request for it but in this case ... we really need a console warning to tell that barricade is gone so .... I also wonder how this barricade can go missing in the first place
  3. my test server, from the screenshot provided still follow this topic https://rathena.org/board/topic/106413-kro-full-client-2020-04-09-includes-bgm-rsu/ so I downloaded kro 20200409 20200205 hexed client from nemo <-- PACKETVER client translation use all 3 zackdreaver, Asheraf, chris
  4. http://nemo.herc.ws/downloads/2020-02-05aRagexeRE/
  5. 20200205 client nothing, gravity just put it there this feature isn't available on 20190530, but appear on 20200205 so its somewhere between these date why gibberish word ? I guess I have outdated translation file
  6. this topic come out at the right time I'm not sure about debian, but I tested CentOS 7 and CentOS 8 CentOS 8 come with mysql 8.0 https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-centos-8 and this alone speed up a lot of configuration time no need to install mariadb, (rathena's guide says need to install mariadb, but I tested CentOS 8 it doesn't need it) yes CentOS 7 needs to install a lot more stuffs, CentOS 8 just much simpler
  7. $300 free credit to spend, all you need is a valid debit/credit card once validate, you can start playing with it you can create multiple machine on a single project answer is -> we can create the machine we like within credit limit here-> https://github.com/AnnieRuru/customs/blob/master/server hosting/9.png just check the credit balance regularly and you understand how Google charge you, when the limit almost up, create another gmail account to play with it again EDIT: I saw your other post about choosing debian, if you are familiar with it then choose boot-disk as debian OVH seems to ... order a machine and need to pay up front to use them, so yeah different VPS different method ---------------- you can even choose Windows Server Edition 2019 (last one, has desktop interface) and I use window's 'Remote Desktop Connection' connect to it CentOS 8 (and debian etc) cost $15 per month Windows server edition with desktop interface (needs 4GB) cost $60 per month its so obvious Linux option is better
  8. 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 [[email protected] ~]$ 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 [[email protected] ~]$ cd /home/annie/Hercules/sql-files/ [[email protected] sql-files]$ mysql -u root -p hercules < main.sql Enter password: [[email protected] sql-files]$ mysql -u root -p hercules < logs.sql Enter password: [[email protected] sql-files]$ mysql -u root -p hercules < item_db_re.sql Enter password: [[email protected] sql-files]$ mysql -u root -p hercules < mob_db_re.sql Enter password: [[email protected] sql-files]$ mysql -u root -p hercules < mob_skill_db_re.sql Enter password: [[email protected] 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 [[email protected] 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... [[email protected] 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
  9. originate from rathena Download 1.0 script Description -> copy paste from rathena forum by the way I added OnPCUseSkillEvent feature its totally up to you to add this or not, but I found it's very convenient after add them having a cursor to immediately select the player I want without typing the name out
  10. prontera,155,185,5 script shdfksjhf 1_F_MARIA,{ if (Class == Job_Novice || Class == Job_Novice_High || Class == Job_Baby) { mes "Hi Novice"; close; } end; }
  11. 1.6 - plugin - fix it run status_calc_pc on every charms pickup and drop - fix OnEquipScript doesn't run when player login - fix nullpo, it wasn't needed at all in other words, fix everything, hopefully no more bug or run extra stuffs and ... its better to loop player's inventory count rather than run whole status_calc_pc thingy, way more resource friendly
  12. if ( upper == 1 && baselevel < 70 ) set [email protected], 494; } if ( [email protected] ) { sc_start4 sc_spirit, 360000, 5, [email protected],0,0; skilleffect [email protected], 5; } you must be came over from rathena but hercules script engine is case-sensitive and some of it don't work here https://github.com/AnnieRuru/Release/blob/master/scripts/Utility/healer/healer_1.2.txt
  13. 2.0 - plugin - overhaul the way how to give player permanent bonus, now no more using npc label, but using an external file - fix `*skill` doesn't work correctly previously - `*recalculatestat` no longer using addtimer hack - no more spamming "<npc name>::OnPCStatCalcEvent" anymore !!! yes tested !! as like before, `@reloadscript` command can reload conf\import\OnPCStatCalcEvent.conf file and if you guys didn't know, rAthena removed OnPCStatCalcEvent !!! MUAHAHAHA !!! https://github.com/rathena/rathena/commit/b65443d8f564175196d57ef9bc1d000a5661fbdc why cause headache ? I just live with it https://github.com/rathena/rathena/issues/4812 cast blessing will make OnPCStatCalcEvent bonus disappear ? I just tested on version 2.0, no problem 2.1 - plugin - add `@reloadonpcstatcalcevent` to safely reload only OnPCStatCalcEvent.conf file without using the destructive `@reloadscript`
  14. 1.5 - plugin - fix warning shown on linux compiler - add OnEquipScript and OnUnequipScript support see 1st post for more information
  15. 1.4 - plugin - fix sample 3 always throw "Target argument is not a variable!" by changing script_isstringtype into script_isstring - add script->reportdata whenever necessary
×
×
  • Create New...

Important Information

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