Habilis

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  

Thanks, will definitely try it out soon!!!

Day 9 : Didn't want to come back to BeyondCompare....
So, I don't want to come back to BeyondCompare and configuring 1000 of files to the episode 11.1, I was desperateley browsing downloads section for at least something more exciting to do!!
Anything... As I've done pretty much everything....
And one more thing cought my eye. DailyRewards!!! 
Well my server already have that, but very basic one. Why not make it golden?
so I took this and a few of similar releases
and did this
day1
day 2
well you get the idea...
 
And, Yes you rad it correctly "A little something to make a player's day with us even better"
And no, it is not an invitation to create 500 characters and farm daily rewards 
As these items are not actually real items
But an Event version (same features but....)
- Not Kafra/Guild storable
- Not Tradable / Vendable / NPC sellable
- Not droppable
 
Basically an item given to one character to make his/her day even more fun...
Applying Only Best Practices since 2017...  (C)

UPDATE: Now That I have the Logo
I can start doing stuff with it
Like
Creating a login screen
and
Making a screenshot watermark (Thingy that appears in the bottom right corner on screenshots)

 
Nextup, some loading screens.....

Day ... Hell if I know:
 
Using the theme I had
http://webapplayers.com/homer_admin-v2.0/landing_page.html
 
I designed the home page (needs some more work like for timer and other) 
But this how I wanted my home page to look.
It's completely adaptive.
And I finally put to use my personally developed Ragnarok captcha,
at the register section.
DISCLAIMER : 
NOT AN ADVERTISMENT
Server name HabilisRO is fictional, made up for the purpose of this Dev's Diary. All matches with the existing servers are a coincidence. 

 
Ow and should I mention the Special Thanks ?
Special thanks to Daifuku for providing free graphical content.
 
There will be a link to her profile...
 
 

UPDATE:
This was introduced by bbaf869 (& fixed in 77c4315) in response to Herc#5085

Mobs have a different max skill level than players. Currently it's set to 100 by default
 
EDIT: it seems level 48 is a special case: it gets the rate benefit but has the same duration as level 10
...and this is only true for this one specific skill. Seems like a dirty hack that was added because someone was too lazy to add a new option to mob skill db

I wanted to do this
But I don't have time, as I estimated it to 4 months work...
The only usable information I could find is
http://rode.doddlercon.com/db/
section 
Episode 11.1 Guide Episode 10.4 Guide Episode 10.3 Guide but there is no more information about previous episodes.
Looking at the eAthena archives of that time and running manual compare
in BeyonCompare or similar software.
But like I said I can't spare 4-5 Months on this...
 
Therefore, I don't think anyone would like to share their server configuration if they have it configured to these episodes.
 

I never did it in windows, but my guess is uhhh......
Hercules-14 requires VisualStudio 2014 ????????????
you are trying to open it in VS 2010
 
Hercules ships with solution and project files for Visual Studio from 2012 onwards.
source :  http://herc.ws/wiki/Compiling
 

Well, the message is pretty clear, 
Access denied to user root 
- Review your MySQL server's root password 
- Review your sql_connection.conf
https://github.com/HerculesWS/Hercules/blob/master/conf/global/sql_connection.conf
 
UPD: No need to duplicate / quote to different categories on the forum, this behavior might get you into trouble...

contact me on facebook!           join discord for freebies!


welcome to my paid services. 
below you can find a variety of things I can do to make your server stand out!
if you need anything else, just ask. 
 

Logo 25$* Patcher 20$* Animated Banner 10$* Advertising Banner 10$* Loading Screen 2$* Login Screen 5$* Facebook Banner + Profile 10$* Forum Skin 30$* Wiki Skin 20$* Interface Skin 20$* Website 30$* Icons 2$* *Please note that prices listed are for re-sellers and come without PSD. 
*For exclusive graphics with or without PSD please ask for a quote. 

 
 
Advertising 10$/week*  Wiki Editor 20$/week*   Support GM 20$/week*  Event GM 20$/week*  Fast Refresh Client 50$*  Normal Client 10$*  FluxCP Setup 10$*  Scripts 5$*  Singature 5$*   

well, that was pretty much all I could think of.
for a preview of my works please check the second post below!
if you need anything else, just ask. 

View File Battle Royal - PvP Addon
A PvP Addon where players may fight until the end of the delay configured to earn as much points as possible.
The highest points rate will be rewarded, others will too but in a lowest range.
Enables first player to configure the game duration at will (5, 10 or 15 minutes), and diffuse announce for players attraction.
Configuration enabled: Price to enter, number of player to start the game, duration enabled
Command: allowing use of @brboard, to get a score board for each player in game
Submitter Alayne Submitted 06/30/17 Category PvP, WoE, GvG, & Battleground  

Finally, it's time to crush that plant with these meteors... huh, it didn't die?!
https://tapas.io/episode/745966

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...

Grace just won't stop fooling around, but, how did she just kill that?!
https://tapas.io/episode/731031

Joshua is ready to BLOW YOUR MIND... as soon as he finishes casting...
https://tapas.io/episode/738528

Day 4 1/2: minor adjustments to the graphics
Improved that banner, even-though, I don't expect to pay $ to the tops to be able to put it....

 
Added a little credit to the graphical content made mostly from Daifuku's graphical content (Will work some more later to make it blend better...)
 
 
Improved a little Watermark see on screenshot
 

Dude like..... If you speak French don't struggle!
Just
 
Écris le enfrancais.. Ya du monde qui comprennent la langue ici....
 
I'll check...

just create a directory 
inside Hercules/sql-files
call it something like bak
mkdir ~/Hercules/sql-files/bak
 
(I don't know where is your emulator in the filesystem...  so I made a relative path to users home directory...)
Next, dump your databases in that directory using a user with access to your database(s)
If you don't know such user or you don't have it, use root (Attention, not the system root, the MySQL root user password)
Then just dump database(s)
 
mysqldump -u root -p hercrodb > ~/Hercules/sql-files/bak/hercrodb_backup.sql
If you store logs in a separate Database you may dump that too:

mysqldump -u root -p hercrolog > ~/Hercules/sql-files/bak/hercrolog_backup.sql
 
then just archive your emulator directory with your backup inside of it
tar -cvf HerculesEmulator.tar ~/Hercules
I like to use SCP now you can use either SCP or FTP to transfer that archive to your new debian VPS
On the other side just unarchive it
tar -xf HerculesEmulator.tar -C ~
 
And Import files from bak directory in your extracted emulator
cd ~/Hercules/sql-files/bak
Import main database
mysql -u root -p hercrodb < hercrodb_backup.sql
import logs database if you have it in separate databases
mysql -u root -p hercrolog < hercrolog_backup.sql
And like Meko said install all dependencies and recompile...
 
After you successfully imported your database(s) and tested server is running just 
rm -rf ~/Hercules/sql-files/bak
for a good measure....

you need to perform a Fetch / Pull (Not to mix with Pull request) and resolve conflicts.
Then have a look inside this directory
https://github.com/HerculesWS/Hercules/tree/master/sql-files/upgrades
 
and see if there is anything new. If there is, run those SQL files in your RO database.
That's it, That's all there is to it...
 
 

Done some logo work
Using Daifuku's Freebie

 

UPDATE: Now That I have the Logo
I can start doing stuff with it
Like
Creating a login screen
and
Making a screenshot watermark (Thingy that appears in the bottom right corner on screenshots)

 
Nextup, some loading screens.....

Day ... Hell if I know:
 
Using the theme I had
http://webapplayers.com/homer_admin-v2.0/landing_page.html
 
I designed the home page (needs some more work like for timer and other) 
But this how I wanted my home page to look.
It's completely adaptive.
And I finally put to use my personally developed Ragnarok captcha,
at the register section.
DISCLAIMER : 
NOT AN ADVERTISMENT
Server name HabilisRO is fictional, made up for the purpose of this Dev's Diary. All matches with the existing servers are a coincidence. 

 
Ow and should I mention the Special Thanks ?
Special thanks to Daifuku for providing free graphical content.
 
There will be a link to her profile...
 
 

Done some logo work
Using Daifuku's Freebie

 

UPDATE: Now That I have the Logo
I can start doing stuff with it
Like
Creating a login screen
and
Making a screenshot watermark (Thingy that appears in the bottom right corner on screenshots)

 
Nextup, some loading screens.....