Alexandria

prontera,156,187,6 script dfkjhsdfkjs 100,{ query_sql "select balance from cp_credits where `account_id` = "+ getcharid(3), .@points; if ( .@points >= 1 ) { query_sql "update cp_credits set balance = balance -1 where account_id = "+ getcharid(3); getitem 7608, 1; } else dispbottom "You don't have anymore voting points"; end;}

We need to pull this change from upstream (paypal issue description in the commit message): https://code.google.com/p/fluxcp/source/detail?r=1133

This script is not complete, it's missing an 'OnPcDieEvent' label and an 'OnPcKillEvent'...

LOL you mixed up both
 
sql query, this one added the index
alter table `char` add empbreak smallint(6) unsigned not null default 0 after unban_time, add index (empbreak);..
npc/guild/agit_main.txt
query_sql "UPDATE `char` SET empbreak = empbreak+1 WHERE char_id = " + getcharid(0);which is already correct.
.
////============================//// Emp Breaking Ladder////============================prontera,155,183,4 script Emperium Ranking 722,{ .@nb = query_sql( "select name, empbreak from `char` where empbreak > 0 order by empbreak desc limit 10", .@name$, .@empbreak ); mes "^FF0000[ Emperium Ranking ]^000000"; for ( .@i = 0; .@i < .@nb; .@i++ ) mes "^0000FF"+ ( .@i +1 ) +".^000000 " + .@name$[.@i] +" - ^FF0000"+ .@empbreak[.@i] +"^000000 Break(s)"; mes " "; query_sql "select empbreak from `char` where char_id = "+ getcharid(0), .@empbreak; mes "^0000FF["+ strcharinfo(0) +"'s]^000000 Emperium Break's is ^FF0000" + .@empbreak + "^000000 Break(s)"; close;OnInit:// waitingroom "Emperium's Ranking",0; // Look on the configuration! end;}use this script

Related to that.
 
My friend (she is from Korea) helps me to translate those buttons.
 
I have her permission to post our conversation. I'm doing this to have suggestions about the translation that she gave me.
 
let's begin.
 
===============
 

 
File name: apply_individual.bmp
Korean words: 개인으로신청
Suggestion in English: game invitation
Log chat: SS1 SS2
 
===============
 

 
File name: esc_001a.bmp
Korean words: 게임설정
Suggestion in English: Game Settings
Log chat: SS1
 
===============
 

 
File name: btn_big_unused_a
Korean words: 이용안하기
Suggestion in English: Exit Game
Log chat: SS1

This data folder is a fresh and clean data folder. It does not have items custom or other modifications (Only I added some kafra cutins).

Based upon CalciumKid's folder, OnNplay's folder, Megasantos's folder, Michieru and dastgirpojee.
[*]Basic kRO Fonts [*]Basic Translated Textures [*]Official Hairstyles (Only if your rdata.grf has been updated) [*]553 Clothes Dyes / 251 Hair Dyes Pack [*]Kafra anime style (you can remove them if you want textureÀ¯ÀúÀÎÅÍÆäÀ̽ºillust)

 
Data Version 4.0
! NOTE: This version is for 2012 and 2013 clients.
 
Download: [Dropbox] [Mega] [4shared] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Fixed: Palletes are working properly.
Added: More sprites
Added: More textures translated
!Merge with Client Translation Project rev. #31
 
MD5 Hash: 10cb8c6819acc00978417dbbedfa5638
 
==========================================================
 
Data Version 3.0
! NOTE: This version is for 2012-04-10 or older.
 
Download: [Dropbox] [Mega] [4shared] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Delete all those files for pre-renewal.
Updated idnum2itemdisplaynametable.txt by Ziu
Updated msgstringtable.txt by TrueNoir
Added: Dewata Quest Translated Lua v1.1 by Dastgir Pojee
 
MD5 Hash: e3806675a03529a154d644e565bd33aa
 
==========================================================
 
Data Version 2.0
! NOTE: This is a PRE-RENEWAL version, only for 2010 or older.
 
Download: [Dropbox] [Mega] [4share] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Added: More sprites (Latest)
Added: Official Hairstyles
Added: More NPC sprites

MD5 Hash: 220ae49fc6dc50ef7b8df3c49e007939
 
==========================================================

Data Version 1.0
 
Download: [Dropbox] [Mega] [4share] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
-Initial release-
 
MD5 Hash: 72a16ec1e3854727cf853d13d6cdbf6f
 
==========================================================
 
Let me know if you have any problems

This data folder is a fresh and clean data folder. It does not have items custom or other modifications (Only I added some kafra cutins).

Based upon CalciumKid's folder, OnNplay's folder, Megasantos's folder, Michieru and dastgirpojee.
[*]Basic kRO Fonts [*]Basic Translated Textures [*]Official Hairstyles (Only if your rdata.grf has been updated) [*]553 Clothes Dyes / 251 Hair Dyes Pack [*]Kafra anime style (you can remove them if you want textureÀ¯ÀúÀÎÅÍÆäÀ̽ºillust)

 
Data Version 4.0
! NOTE: This version is for 2012 and 2013 clients.
 
Download: [Dropbox] [Mega] [4shared] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Fixed: Palletes are working properly.
Added: More sprites
Added: More textures translated
!Merge with Client Translation Project rev. #31
 
MD5 Hash: 10cb8c6819acc00978417dbbedfa5638
 
==========================================================
 
Data Version 3.0
! NOTE: This version is for 2012-04-10 or older.
 
Download: [Dropbox] [Mega] [4shared] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Delete all those files for pre-renewal.
Updated idnum2itemdisplaynametable.txt by Ziu
Updated msgstringtable.txt by TrueNoir
Added: Dewata Quest Translated Lua v1.1 by Dastgir Pojee
 
MD5 Hash: e3806675a03529a154d644e565bd33aa
 
==========================================================
 
Data Version 2.0
! NOTE: This is a PRE-RENEWAL version, only for 2010 or older.
 
Download: [Dropbox] [Mega] [4share] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Added: More sprites (Latest)
Added: Official Hairstyles
Added: More NPC sprites

MD5 Hash: 220ae49fc6dc50ef7b8df3c49e007939
 
==========================================================

Data Version 1.0
 
Download: [Dropbox] [Mega] [4share] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
-Initial release-
 
MD5 Hash: 72a16ec1e3854727cf853d13d6cdbf6f
 
==========================================================
 
Let me know if you have any problems

data version 4

This is a new translation client project that Dastgir and Me want to share for Hercules only.
 
What this Project contain?
 
- itemInfo.lua with iro/kro translation.
- Some lua that contain last translation found on the board or made by us.
- Last accessoryid.lub / accname.lub / jobname.lub / NPCIdentity.lub decompiled.
- Texture Buttons translate.
- msgstringtable.txt fully translate.
- Txt files translate (questid2display.txt, mapnametable.txt etc...)
- Up-To-Date itemInfo and other files required to run a basic Translated client.
 
You can help us by opening PR, or just pm Dastgir to get access to the repo...
 
 
What Client is compatible?
 
- Client compatible until 2016.
Link:
 

Add lot of new items

Related to that.
 
My friend (she is from Korea) helps me to translate those buttons.
 
I have her permission to post our conversation. I'm doing this to have suggestions about the translation that she gave me.
 
let's begin.
 
===============
 

 
File name: apply_individual.bmp
Korean words: 개인으로신청
Suggestion in English: game invitation
Log chat: SS1 SS2
 
===============
 

 
File name: esc_001a.bmp
Korean words: 게임설정
Suggestion in English: Game Settings
Log chat: SS1
 
===============
 

 
File name: btn_big_unused_a
Korean words: 이용안하기
Suggestion in English: Exit Game
Log chat: SS1

Hello friends!
 
this is interesting to you? can i continue the development? or it's not a good project? 
 
Page: http://barrosfilipe.github.io/robrew/
Github: https://github.com/barrosfilipe/robrew
 
 
What is RObrew?
 
It's a Linux (Debian Based OS / Red Hat Based OS) application that will provide you a simple life in ragnarok emulator management.
 
Example without RObrew:
 
You need to install package dependencies to your emulator manually, for example:
 
    * gcc
* make
* mysql
* mysql-devel
* mysql-server
* pcre-devel
* subversion
* zlib-devel
 
And then download the emulator from svn/repo and compile it manually!
 
Example with RObrew:
 
After install RObrew you just need to do that command in your terminal:
 
$ robrew install <emulator>  
For Hercules:
$ robrew install hercules  
Package Dependencies:   * gcc * make * mysql * mysql-devel * mysql-server * pcre-devel * subversion * zlib-devel  
The robrew command will install all package dependencies automatically, download Hercules from official svn/repository.
 
If you want to compile:
 
 
$ robrew compile /path/to/downloaded/hercules/folder/  
RObrew is now in development and the first release will have plugins. For example, a plugin named emulator-dropbox-backup that provide automatically daily backups from your emulator and database to a DropBox storage.
 
if you are interested to get involved contact me (PM).
 
Thanks! Let's make the world better 
 
with Love <3,
c0nsumer (Filipe Barros)

This project is focused in texture translation to English Translation. The current translation are done very bad, by alot of people. Some buttons are bold, some wrong color, some missing drop shadow. There needs to be some record of official font, color, size, etc

The translation that you are going to find here may not be the official one.

Any advice, suggestions or request would be most welcome!
 
svn:
https://subversion.assembla.com/svn/texture-translation-project  
And also you can find the data_PSD folder where you can edit the whole project using Photoshop CS6.
 
Special thanks to Yommy for your good advices.

Hello,   Just want to share my Hercules Userbar, you can use this userbar if you want.  

This thread got it's first follower

This project is focused in texture translation to English Translation. The current translation are done very bad, by alot of people. Some buttons are bold, some wrong color, some missing drop shadow. There needs to be some record of official font, color, size, etc

The translation that you are going to find here may not be the official one.

Any advice, suggestions or request would be most welcome!
 
svn:
https://subversion.assembla.com/svn/texture-translation-project  
And also you can find the data_PSD folder where you can edit the whole project using Photoshop CS6.
 
Special thanks to Yommy for your good advices.

This project is focused in texture translation to English Translation. The current translation are done very bad, by alot of people. Some buttons are bold, some wrong color, some missing drop shadow. There needs to be some record of official font, color, size, etc

The translation that you are going to find here may not be the official one.

Any advice, suggestions or request would be most welcome!
 
svn:
https://subversion.assembla.com/svn/texture-translation-project  
And also you can find the data_PSD folder where you can edit the whole project using Photoshop CS6.
 
Special thanks to Yommy for your good advices.

This project is focused in texture translation to English Translation. The current translation are done very bad, by alot of people. Some buttons are bold, some wrong color, some missing drop shadow. There needs to be some record of official font, color, size, etc

The translation that you are going to find here may not be the official one.

Any advice, suggestions or request would be most welcome!
 
svn:
https://subversion.assembla.com/svn/texture-translation-project  
And also you can find the data_PSD folder where you can edit the whole project using Photoshop CS6.
 
Special thanks to Yommy for your good advices.

This project is focused in texture translation to English Translation. The current translation are done very bad, by alot of people. Some buttons are bold, some wrong color, some missing drop shadow. There needs to be some record of official font, color, size, etc

The translation that you are going to find here may not be the official one.

Any advice, suggestions or request would be most welcome!
 
svn:
https://subversion.assembla.com/svn/texture-translation-project  
And also you can find the data_PSD folder where you can edit the whole project using Photoshop CS6.
 
Special thanks to Yommy for your good advices.

This project is focused in texture translation to English Translation. The current translation are done very bad, by alot of people. Some buttons are bold, some wrong color, some missing drop shadow. There needs to be some record of official font, color, size, etc

The translation that you are going to find here may not be the official one.

Any advice, suggestions or request would be most welcome!
 
svn:
https://subversion.assembla.com/svn/texture-translation-project  
And also you can find the data_PSD folder where you can edit the whole project using Photoshop CS6.
 
Special thanks to Yommy for your good advices.

This data folder is a fresh and clean data folder. It does not have items custom or other modifications (Only I added some kafra cutins).

Based upon CalciumKid's folder, OnNplay's folder, Megasantos's folder, Michieru and dastgirpojee.
[*]Basic kRO Fonts [*]Basic Translated Textures [*]Official Hairstyles (Only if your rdata.grf has been updated) [*]553 Clothes Dyes / 251 Hair Dyes Pack [*]Kafra anime style (you can remove them if you want textureÀ¯ÀúÀÎÅÍÆäÀ̽ºillust)

 
Data Version 4.0
! NOTE: This version is for 2012 and 2013 clients.
 
Download: [Dropbox] [Mega] [4shared] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Fixed: Palletes are working properly.
Added: More sprites
Added: More textures translated
!Merge with Client Translation Project rev. #31
 
MD5 Hash: 10cb8c6819acc00978417dbbedfa5638
 
==========================================================
 
Data Version 3.0
! NOTE: This version is for 2012-04-10 or older.
 
Download: [Dropbox] [Mega] [4shared] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Delete all those files for pre-renewal.
Updated idnum2itemdisplaynametable.txt by Ziu
Updated msgstringtable.txt by TrueNoir
Added: Dewata Quest Translated Lua v1.1 by Dastgir Pojee
 
MD5 Hash: e3806675a03529a154d644e565bd33aa
 
==========================================================
 
Data Version 2.0
! NOTE: This is a PRE-RENEWAL version, only for 2010 or older.
 
Download: [Dropbox] [Mega] [4share] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Added: More sprites (Latest)
Added: Official Hairstyles
Added: More NPC sprites

MD5 Hash: 220ae49fc6dc50ef7b8df3c49e007939
 
==========================================================

Data Version 1.0
 
Download: [Dropbox] [Mega] [4share] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
-Initial release-
 
MD5 Hash: 72a16ec1e3854727cf853d13d6cdbf6f
 
==========================================================
 
Let me know if you have any problems

I made this, Just Wait for some minute for me to upload this patch.
File : ItemShop-May15.diff
 
Usage:
<map name>,<x>,<y>,<facing>,<item_id> ishop <npc name> <spriteid>,<itemid>:<amount>,.....  Once download gets approved by mods, http://herc.ws/board/files/file/6-customized-shop-needs-item/
Tested And Working.

This data folder is a fresh and clean data folder. It does not have items custom or other modifications (Only I added some kafra cutins).

Based upon CalciumKid's folder, OnNplay's folder, Megasantos's folder, Michieru and dastgirpojee.
[*]Basic kRO Fonts [*]Basic Translated Textures [*]Official Hairstyles (Only if your rdata.grf has been updated) [*]553 Clothes Dyes / 251 Hair Dyes Pack [*]Kafra anime style (you can remove them if you want textureÀ¯ÀúÀÎÅÍÆäÀ̽ºillust)

 
Data Version 4.0
! NOTE: This version is for 2012 and 2013 clients.
 
Download: [Dropbox] [Mega] [4shared] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Fixed: Palletes are working properly.
Added: More sprites
Added: More textures translated
!Merge with Client Translation Project rev. #31
 
MD5 Hash: 10cb8c6819acc00978417dbbedfa5638
 
==========================================================
 
Data Version 3.0
! NOTE: This version is for 2012-04-10 or older.
 
Download: [Dropbox] [Mega] [4shared] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Delete all those files for pre-renewal.
Updated idnum2itemdisplaynametable.txt by Ziu
Updated msgstringtable.txt by TrueNoir
Added: Dewata Quest Translated Lua v1.1 by Dastgir Pojee
 
MD5 Hash: e3806675a03529a154d644e565bd33aa
 
==========================================================
 
Data Version 2.0
! NOTE: This is a PRE-RENEWAL version, only for 2010 or older.
 
Download: [Dropbox] [Mega] [4share] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Added: More sprites (Latest)
Added: Official Hairstyles
Added: More NPC sprites

MD5 Hash: 220ae49fc6dc50ef7b8df3c49e007939
 
==========================================================

Data Version 1.0
 
Download: [Dropbox] [Mega] [4share] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
-Initial release-
 
MD5 Hash: 72a16ec1e3854727cf853d13d6cdbf6f
 
==========================================================
 
Let me know if you have any problems

1 thing that rAthena dont have...
 
Hercules support custom ideas / suggestions .....

This data folder is a fresh and clean data folder. It does not have items custom or other modifications (Only I added some kafra cutins).

Based upon CalciumKid's folder, OnNplay's folder, Megasantos's folder, Michieru and dastgirpojee.
[*]Basic kRO Fonts [*]Basic Translated Textures [*]Official Hairstyles (Only if your rdata.grf has been updated) [*]553 Clothes Dyes / 251 Hair Dyes Pack [*]Kafra anime style (you can remove them if you want textureÀ¯ÀúÀÎÅÍÆäÀ̽ºillust)

 
Data Version 4.0
! NOTE: This version is for 2012 and 2013 clients.
 
Download: [Dropbox] [Mega] [4shared] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Fixed: Palletes are working properly.
Added: More sprites
Added: More textures translated
!Merge with Client Translation Project rev. #31
 
MD5 Hash: 10cb8c6819acc00978417dbbedfa5638
 
==========================================================
 
Data Version 3.0
! NOTE: This version is for 2012-04-10 or older.
 
Download: [Dropbox] [Mega] [4shared] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Delete all those files for pre-renewal.
Updated idnum2itemdisplaynametable.txt by Ziu
Updated msgstringtable.txt by TrueNoir
Added: Dewata Quest Translated Lua v1.1 by Dastgir Pojee
 
MD5 Hash: e3806675a03529a154d644e565bd33aa
 
==========================================================
 
Data Version 2.0
! NOTE: This is a PRE-RENEWAL version, only for 2010 or older.
 
Download: [Dropbox] [Mega] [4share] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
Added: More sprites (Latest)
Added: Official Hairstyles
Added: More NPC sprites

MD5 Hash: 220ae49fc6dc50ef7b8df3c49e007939
 
==========================================================

Data Version 1.0
 
Download: [Dropbox] [Mega] [4share] [Gamefront] [Rapidgator] [Uploaded] [Putlocker] [Turbobit]
ChangeLog:
-Initial release-
 
MD5 Hash: 72a16ec1e3854727cf853d13d6cdbf6f
 
==========================================================
 
Let me know if you have any problems