Cyro

anyone miss meh?

< Alayne's Script Collection >
After several asks, here's a link to my github
Feel free to comment or add anything that might be usefull and that I won't think of
I've decided to release my scripts here, it'll be easier to me so I can duplicate it on hercules and rathena rather than uploading twice. So sorry for multiple upload between there and download section
Don't mind the name Nyliar in the git, that's me too ^^
 
< Instances >
 
< Quests >
 
< Event >
 
< PvP Content >
 
< Utilities >
 
< Full Systems >
 
< Dungeons >
 
< Raid >
 
< Battleground >

August Digest 2017
The following digest covers the month of August 1st - August 30th 2017
 
 
Team Changes
None  
Development Highlights
Item DB: replace numbers with constants and split View into Subtype and ViewSprite (This has been merged on Sept. 17, however, all commits were created on August 21). Added support for bitmasks, in the form of libconfig arrays of constants (strings) in the Upperand Loc fields of the item DB. Split the View field into Subtype and ViewSprite, to better describe its actual use, depending on the item type. Changed several numeric values into human-readable constants: W_* and A_* constants for the Subtype field IT_* constants for the Type field (thanks to @iRagno, from PR #1633) SEX_* constants for the Gender field (thanks to @iRagno, from PR #1633) ITEMUPPER_* (bitmask) constants for the Upper field EQP_* (bitmask) constants for the Loc field. Fixed some incorrect values in the Renewal item DB, detected thanks to the above changes. Differentiated and refactored the variables that hold view sprites from those that hold item subtypes. This includes entire contents of PR #1633, which was merged (rebased and fast-forwarded) into this branch.
Disable warning -Wdiscarded-qualifiers in hpm code for now Fix various issues detected by coverity in rodex-related code Save near 200 places in arrays with size SC_MAX Update travis for ubuntu trusty add clang-5.0 re and pre-re builds to travis add clang-4.0 re and pre-re builds to travis  
Scripting Highlights
Update Airship Quests (#1614)  
August Statistics
During the period there were 65 Commits. 5 Commits from Pull Requests with 2 Bugs* fixed from merged issues.  
*Please note: Bug fixes are counted as references to issues; it does not include bugs that have been fixed without issue reference. The number of commits includes those that were merged.

you are trying to run hercules with root privillages , which is not supported by herc for a good reason, make new user and run your server with the new user

Greetings everyone,
Today I'm introducing a project that I've been envisioning and working on for a couple of months, a control panel developed using Laravel (currently v5.8) that has quite a few advanced features that no other panel has offered before.
Feature Insight
Bootstrap Responsive Design
The panel by default will come with one bootstrap-based responsive design that is elegant, light coloured and adjusts to screens of all sizes. The panel is also capable of supporting custom themes.
 
Master Account System
Create and manage all your game accounts in any server from one main web-account.
 
Passwords of the master accounts are hashed using bcrypt to ensure safety for all registered users.
ROGen
Adapted from @KeyWorld's ROChargen, a library in php that extracts images from sprites and uses resources inside data folders (and not grf files). With the help of this library images of headgears, skill icons, illustrations, item images, monsters and mini maps are can be generated and displayed on web pages.
Complete Database Libraries
Using a library with conversions of information in the client folder, the website incorporates in-game information such as skill and item descriptions, quest information and much more.
Character Overview
The character overview page is an important part of a user's experience. With the features mentioned above, we're able to display alot of information about one's in-game characters on the fly.
 
User Profiles
Additionally, something that's never been seen before in RO CMS or Panels are public user profiles. The ability of a user to view another user's in-game information through the control panel.
Customisable Email Templates
 
Administration Section
The demo for this site is live and available at - http://bladecp.xyz
ID: [email protected] Pass: abcdef  
How do I gain access to this awesome panel?
PM me on discord @Sxyz#0202!
To get in touch or check out updates on this project, join my discord channel @ https://discord.gg/pWgZHzx

This is known bug with 2015 clients
https://github.com/rathena/rathena/issues/2348

Make sure that listed items in shop are existing in your item_db 

As I've already said. Death Knight (The expanded class never made by gravity) does not have a sprite, so it not have a sprite name and uses knight as default.

Hey everyone!
 
Some of you have left me many messages (here on the forum and on Discord) regarding my activity. Sadly, I've been quite busy working at Summer Camp (hence why I haven't been active much through the summer....). I try to check in whenever I have some time to myself, but it is quite difficult to do so with lack of internet and lack of connection.
 
Good news is... it's almost done and I'm about ready to get back to my normal routine. Please, if you have any more questions/concerns/ or just want to say hi, don't hesitate to talk to me via PM or Discord! I check Discord more often since I am on my phone more often.
 
Mystery out!

Hi there!
I would suggest to use images with the same style.
Right now you have like 5 different drawing styles flying around the patcher and its quite irritating.
You kept the background/footer and inner part quite simple/plain colorwise (white/blue/dark blue/without effects) and then added a super flashy play button with light and shadow effects, I don't think that's pleasing to the eye. 

But keep it up and play around more! I'm sure you will only get better and better. 

In case you need some inspiration - one of the patchers I've started recently:

 

Hello People!
Here are some of my work  please rate

View File Shiro Designs Free Thor Patcher
Uhmm... So the owner of Amatsu Ragnarok Online didn't pay me at all so here it is.
It is coded already.  
It includes PSD file, Config Files, Web files and Thor Generator
Have fun 
Submitter Shiro Submitted 07/28/17 Category Other Graphics  

View File 34 Kamishi's Clothes & Hair Palettes (Updated 2018!!)
Support All classes including new Mounts, Oboro, Kagerou, Rebellion and 3rd Costumes ! Yay ! =3
The palettes are ranged from 0 to 35.
For this pack to look the best you must use my corrected classes sprites and Haziel's 3rd Costumes sprites
These palettes are from my big 700 palette pack !
If you want more, you may contact me here :  Paletting services (More than 700 Palettes, Races and Colors! :3).
Thank you ! >o<
Submitter kami-shi Submitted 07/12/17 Category Sprites & Palettes  

Day 4 2/2: SQL security work takes form
I moved forward with the SQL security work
So basically here is the main idea of how It works

 
and here are some pieces of my SQL code
DECLARE _ragDBWebUserViewer VARCHAR(32); DECLARE _ragDBWebUserViewerPass VARCHAR(32); SET _ragDBWebUserViewer = 'ragdbwebviewer'; SET _ragDBWebUserViewerPass = 'huji' ALTER TABLE login ADD COLUMN emailverrif VARCHAR(32) NOT NULL DEFAULT '' AFTER pincode_change; DELIMITER // CREATE PROCEDURE WebRegisterNewRagPlayerOne ( IN login VARCHAR(23) , IN email VARCHAR(39) , IN password VARCHAR(32) , IN sex ENUM('M','F') , IN emailverrifhash VARCHAR(32) , OUT returnparam INT(1) ) proc_webreg:BEGIN -- -1 Unhandled error DECLARE EXIT HANDLER FOR SQLEXCEPTION SET returnparam = -1; SELECT userid INTO @loginalreadyexists FROM login WHERE userid = login; SELECT email INTO @emailalreadyexists FROM login WHERE email = email; IF @loginalreadyexists NOT NULL THEN -- -2 Login already exists SET returnparam = -2; LEAVE proc_webreg; END IF; IF @emailalreadyexists NOT NULL THEN -- -3 Email already exists SET returnparam = -3; LEAVE proc_webreg; END IF; -- 4085943947 (2099-06-24) INSERT INTO login (userid, email, user_pass, sex, emailverrif, unban_time) VALUES (login, email, password, sex, emailverrif, 4085943947); END // DELIMITER ; GRANT EXECUTE ON PROCEDURE ragdb.WebRegisterNewRagPlayerOne TO _ragDBWebUserViewer@'localhost'; DELIMITER // CREATE PROCEDURE WebRegisterNewRagPlayerTwo ( IN emailverrifhash VARCHAR(32) , OUT returnparam INT(1) ) BEGIN -- Hey it's not a tutorial ;) END // DELIMITER ; GRANT EXECUTE ON PROCEDURE ragdb.WebRegisterNewRagPlayerTwo TO _ragDBWebUserViewer@'localhost'; DELIMITER // CREATE PROCEDURE RsetPasswordRagPlayerOne ( IN login VARCHAR(23) , IN emailverrifhash VARCHAR(32) , OUT email VARCHAR(39) ) BEGIN -- Hey it's not a tutorial ;) END // DELIMITER ; GRANT EXECUTE ON PROCEDURE ragdb.RsetPasswordRagPlayerOne TO _ragDBWebUserViewer@'localhost'; DELIMITER // CREATE PROCEDURE RsetPasswordRagPlayerTwo ( IN password VARCHAR(32) , IN emailverrifhash VARCHAR(32) , OUT returnparam INT(1) ) BEGIN -- Hey it's not a tutorial ;) END // DELIMITER ; GRANT EXECUTE ON PROCEDURE ragdb.RsetPasswordRagPlayerTwo TO _ragDBWebUserViewer@'localhost'; So basically as you can see there is ragdbwebviewer that has access only to the stored procedures and I will add some views
it will have access to
like 
Create View AS SELECT nicnake, level, 
left join job....
whatever (note I'm not doing select * nor selecting login, email, passwords)
 
The password reset part is a security weakness, but if my website is hacked and 
ragdbwebviewer credentials obtained, hacker will have to know account login to reset the password... in theory
in real life there will be some more layers of security...

This guide will show you how to ruin ragnarok online at all.
More 1day servers, please.

and perhaps u could add the discord id to be place in the contact method at the user profile... much more convenient..

RUCR
Hello Hercules Community,
I was working on RUCR this month and I am happy to announce that it's complete. The Site contains all Ragexe(upto 2016-07) and RagexeRE from 2014, fully unpacked.
It would be great if there will be no mirrors, I would be keeping this web up and running, so mirrors won't be needed.
Also, if you find any clients missing, you can post it here, and I will check if that can be uploaded.
 
 
Repo Link: DISABLED
Enjoy
 

And they're off to try their new 2nd job skills! but... Grace, what are you doing?!
https://tapas.io/episode/723153

View File Ragnarok Forum Badges

thanks again arana, I remember how much fun we had working on these. ♥
Submitter Daifuku Submitted 06/07/17 Category Other Graphics  

As of e171deb58c7 we have the official refine rates from kRO.
 
Normal Ores
　Refine Shadow equipment Armor Weapon (1st level) Weapon (2nd level) Weapon (3rd level) Weapon (4th level) 1 100% 100% 100% 100% 100% 100% 2 100% 100% 100% 100% 100% 100% 3 100% 100% 100% 100% 100% 100% 4 100% 100% 100% 100% 100% 100% 5 60% 60% 100% 100% 100% 60% 6 40% 40% 100% 100% 60% 40% 7 40% 40% 100% 60% 50% 40% 8 20% 20% 60% 40% 20% 20% 9 20% 20% 40% 20% 20% 20% 10 9% 9% 19% 19% 19% 9% 11 - 8% 18% 18% 18% 8% 12 - 8% 18% 18% 18% 8% 13 - 8% 18% 18% 18% 8% 14 - 8% 18% 18% 18% 8% 15 - 7% 18% 18% 18% 7% 16 - 7% 17% 17% 17% 7% 17 - 7% 17% 17% 17% 7% 18 - 7% 17% 17% 17% 7% 19 - 5% 15% 15% 15% 5% 20 - 5% 15% 15% 15% 5%  
Enriched Ores
Refine 　 Shadow equipment Armor Weapon (1st level) Weapon (2nd level) Weapon (3rd level) Weapon (4th level) 1 100% 100% 100% 100% 100% 100% 2 100% 100% 100% 100% 100% 100% 3 100% 100% 100% 100% 100% 100% 4 100% 100% 100% 100% 100% 100% 5 90% 90% 100% 100% 100% 90% 6 70% 70% 100% 100% 90% 70% 7 70% 70% 100% 90% 80% 70% 8 40% 40% 90% 70% 40% 40% 9 40% 40% 70% 40% 40% 40% 10 20% 20% 30% 30% 30% 20% 11 -　 8% 18% 18% 18% 8% 12 -　 8% 18% 18% 18% 8% 13 -　 8% 18% 18% 18% 8% 14 -　 8% 18% 18% 18% 8% 15 -　 7% 18% 18% 18% 7% 16 -　 7% 17% 17% 17% 7% 17 -　 7% 17% 17% 17% 7% 18 -　 7% 17% 17% 17% 7% 19 -　 5% 15% 15% 15% 5% 20 -　 5% 15% 15% 15% 5%  
Normal Ores - Smelting Event
Refine Shadow equipment Armor Weapon (1st level) Weapon (2nd level) Weapon (3rd level) Weapon (4th level) 1 100% 100% 100% 100% 100% 100% 2 100% 100% 100% 100% 100% 100% 3 100% 100% 100% 100% 100% 100% 4 100% 100% 100% 100% 100% 100% 5 60% 60% 100% 100% 100% 60% 6 40% 40% 100% 100% 60% 40% 7 40% 40% 100% 60% 50% 40% 8 20% 20% 60% 40% 20% 20% 9 20% 20% 40% 20% 20% 20% 10 9% 9% 19% 19% 19% 9% 11 - 20% 40% 40% 40% 20% 12 - 20% 40% 40% 40% 20% 13 - 16% 35% 35% 35% 16% 14 - 16% 35% 35% 35% 16% 15 - 15% 30% 30% 30% 15% 16 - 15% 30% 30% 30% 15% 17 - 14% 20% 20% 20% 14% 18 - 14% 20% 20% 20% 14% 19 - 10% 15% 15% 15% 10% 20 - 10% 15% 15% 15% 10%  
Enriched Ores - Smelting Event
   Refine　 Shadow equipment Armor Weapon (1st level) Weapon (2nd level) Weapon (3rd level) Weapon (4th level) 1 100% 100% 100% 100% 100% 100% 2 100% 100% 100% 100% 100% 100% 3 100% 100% 100% 100% 100% 100% 4 100% 100% 100% 100% 100% 100% 5 95% 95% 100% 100% 100% 95% 6 80% 80% 100% 100% 95% 80% 7 80% 80% 100% 95% 90% 80% 8 60% 60% 95% 85% 70% 60% 9 50% 50% 85% 60% 60% 50% 10 35% 35% 55% 45% 45% 35% 11 - 20% 40% 40% 40% 20% 12 -　 20% 40% 40% 40% 20% 13 -　 16% 35% 35% 35% 16% 14 -　 16% 35% 35% 35% 16% 15 -　 15% 30% 30% 30% 15% 16 -　 15% 30% 30% 30% 15% 17 -　 14% 20% 20% 20% 14% 18 -　 14% 20% 20% 20% 14% 19 -　 10% 15% 15% 15% 10% 20 -　 10% 15% 15% 15% 10%  
 
This corrects the previous behaviour of enriched ores which would simple double roll the item refinement.
 
Script Command Changes
getequippercentrefinery(<equipment slot>{, <type>}) Example: if (getequippercentrefinery(EQI_HAND_L, REFINE_CHANCE_TYPE_NORMAL) <= rand(100)) mes("Aww");  
Constants exported to constants.conf are -
REFINE_CHANCE_TYPE_NORMAL: 1 Retrieves Normal ore refine rate REFINE_CHANCE_TYPE_ENRICHED: 2 Retrieves Enriched ore refine rate REFINE_CHANCE_TYPE_E_NORMAL: 3 Retrieves Normal Event ore refine rate REFINE_CHANCE_TYPE_E_ENRICHED: 4 Retrieves Enriched Event ore refine rate  

You should try Digital Ocean. Their servers are pretty highly used, meaning for a production environment, it wouldn't be ideal for anything larger than a small community of 10+ players, but their website has lots of guides. I started their with almost zero knowledge, and now it's almost like a second language to me.