Leaderboard

I stopped reading after "Sirs,".

It's fake, i've had around 40 of those sent to me when i was hosting eA servers a few years ago. 1. Why use a facebook URL to your site? 2. Representing Gravity Europe, why are they using american spellings.. Europeans use en-GB. 3. Why didn't it come from Gravity itself, instead of a European subsidiary? 4. I hate to say it, but there's traces of pinoy grammar in that thar letterz. 5. In official Gravity letters, they address you by Salutation then Surname. However, on what you should do, is entirely up to you.

Heyho, I stopped my work on any ragnarok server. So this is a small farewell gift. This small scripts can be used as Cronjob (http://en.wikipedia.org/wiki/Cronjob) to decrease you administrative work. You normaly just have to change the config variables. Script 1: Auto RO server restart when crashed (should be started via cronjob every 5 minutes or less) #!/bin/bash ###CONFIG START### SERVER_USER="foo" PATH_TO_RO="/home/bar/rathena/" ###CONFIG END### ERROR=0 if [ "$(ps auxf | grep 'login-server' | grep -v 'grep')" == "" ]; then ERROR=1 fi if [ "$(ps auxf | grep 'char-server' | grep -v 'grep')" == "" ]; then ERROR=1 fi if [ "$(ps auxf | grep 'map-server' | grep -v 'grep')" == "" ]; then ERROR=1 fi if [ $ERROR == 1 ]; then su $SERVER_USER | $PATH_TO_RO/athena-start restart fi Script 2: SQL Backup (should be started every day) #!/bin/bash ###CONFIG START### PATH_TO_BACKUPS="/home/foo/backups" DB_HOST="localhost" DB_USER="foo" DB_PASSWORD="secretpw" WHICH_DATABASES="ragnarok" USER_NAME="foo" USER_GROUP="bar" ###CONFIG END### find -P $PATH_TO_BACKUPS -maxdepth 1 -type f \( -name '*.sql' \) -ctime +15 -exec rm {} \; mysqldump -h$DB_HOST -u$DB_USER -p$DB_PASSWORD --databases $WHICH_DATABASES > $PATH_TO_BACKUPS/$(date +%Y-%m-%d).sql chown $USER_NAME:$USER_GROUP $PATH_TO_BACKUPS/$(date +%Y-%m-%d).sql Script 3: Logs -> History DB If you have the logs and ragnarok tables in the same database, you can may think of archive some of old logs to another database. (should be started 2 times a month) #!/bin/bash ###CONFIG START### PATH_TO_RO="/home/bar/rathena" DB_HOST="localhost" DB_USER="bar" DB_PASSWORD="secretpw" DB_RAGNAROK_DATABASE="ragnarok" DB_LOG_DATABASE="ragnarok-log" ###CONFIG END### mysqldump -h$DB_HOST -u$DB_USER -p$DB_PASSWORD --compact --no-create-info $DB_RAGNAROK_DATABASE atcommandlog branchlog charlog chatlog npclog picklog zenylog > $PATH_TO_RO/temp.sql mysql -h$DB_HOST -u$DB_USER -p$DB_PASSWORD -D$DB_RAGNAROK_DATABASE -e"DELETE FROM atcommandlog WHERE 1=1; DELETE FROM branchlog WHERE 1=1; DELETE FROM charlog WHERE 1=1; DELETE FROM chatlog WHERE 1=1; DELETE FROM npclog WHERE 1=1; DELETE FROM picklog WHERE 1=1; DELETE FROM zenylog WHERE 1=1;" mysql -h$DB_HOST -u$DB_USER -p$DB_PASSWORD -D$DB_LOG_DATABASE < $PATH_TO_RO/temp.sql rm $PATH_TO_RO/temp.sql (before you start this script, you should insert a structure only dump into your history database) I hope this may help you and the config is understandable. Greetings, Loki1991(before you start this script, you should insert a structure only dump into your history database)

your request kinda make me reminds of my mission board script, that were highly demanded to be convert to SQL version anyway /* create table item_recipe_custom ( id smallint not null primary key auto_increment, item_id smallint(6) unique, value1 smallint(6) not null default '0', amount1 smallint(6) not null default '0', value2 smallint(6) not null default '0', amount2 smallint(6) not null default '0', value3 smallint(6) not null default '0', amount3 smallint(6) not null default '0', value4 smallint(6) not null default '0', amount4 smallint(6) not null default '0', value5 smallint(6) not null default '0', amount5 smallint(6) not null default '0', value6 smallint(6) not null default '0', amount6 smallint(6) not null default '0', value7 smallint(6) not null default '0', amount7 smallint(6) not null default '0', value8 smallint(6) not null default '0', amount8 smallint(6) not null default '0', value9 smallint(6) not null default '0', amount9 smallint(6) not null default '0', value10 smallint(6) not null default '0', amount10 smallint(6) not null default '0' ) engine = innodb; */ prontera,157,175,5 script item_recipe_make 100,{ set item_recipe_custom0, 0; set .@nb, query_sql( "select * from item_recipe_custom", .@id, .@item_id, .@v1, .@a1, .@v2, .@a2, .@v3, .@a3, .@v4, .@a4, .@v5, .@a5, .@v6, .@a6, .@v7, .@a7, .@v8, .@a8, .@v9, .@a9, .@v0, .@a0 ); if ( .@nb == -1 ) { mes "the table is not set"; close; } if ( .@nb == 0 ) { mes "current list is empty"; close; } mes "select an item to make"; next; set .@menu$, getitemname( .@item_id ); for( set .@i, 1; .@i < .@nb; set .@i, .@i +1 ) set .@menu$, .@menu$ +":"+ getitemname( .@item_id[ .@i ] ); set .@s, select( .@menu$ ) -1 ; if ( getd( "item_recipe_custom"+ ( .@id[ .@s ] / 31 ) ) & pow( 2, .@id[ .@s ] % 31 ) ) { mes "you've learned how to make this item and used them"; close; } mes "to make ^ff0000"+ getitemname( .@item_id[ .@s ] ); mes "^000000you need the following items:^0000ff"; set .@i, 1; while ( getd( ".@v"+ .@i +"["+ .@s +"]" ) ) { mes getd( ".@a"+ .@i +"["+ .@s +"]" ) +"x "+ getitemname( getd( ".@v"+ .@i +"["+ .@s +"]" ) ); set .@i, .@i +1; } next; select "learn it"; set .@i, 1; while ( getd( ".@v"+ .@i +"["+ .@s +"]" ) ) { if ( countitem( getd( ".@v"+ .@i +"["+ .@s +"]" ) ) < getd( ".@a"+ .@i +"["+ .@s +"]" ) ) { mes "you don't have enough "+ getitemname( getd( ".@v"+ .@i +"["+ .@s +"]" ) ); close; } set .@i, .@i +1; } set .@i, 1; while ( getd( ".@v"+ .@i +"["+ .@s +"]" ) ) { delitem getd( ".@v"+ .@i +"["+ .@s +"]" ), getd( ".@a"+ .@i +"["+ .@s +"]" ); set .@i, .@i +1; } setd "item_recipe_custom"+( .@id[ .@s ] /31 ), getd( "item_recipe_custom"+( .@id[ .@s ] /31 ) ) | pow( 2, .@id[ .@s ] % 31 ); mes "you've learned how to make "+ getitemname( .@item_id[ .@s ] ); close; } pls let me spam abit WTF and WTF the hell with me used 2 hours and 30 mins to make this simple script I need to continue make more script at the moment to improve myself yet

Not going to do this one due to paid service constraints.

koya sa clientinfo.xml mo hanapin mo ito <port>6901</port> gawin mong <port>6900</port>

maybe it's ur Secure GRF problem that make your client cant display proper translation for your client ? maybe it's ur ROCShield problem that make your client keep freeze every short interval ? Clients are suppose to work with any Revision of Server .... beside, there is alot guide in forum for you to follow and setup your client correctly..... i dont have all these issue when i use these 2012 clients..

-****script****OnPCKillEvent****-1,{ OnPCKillEvent: ****if(attachrid(killedrid)) ****{ ********if(Class == 3 || Class == 4012) ********{ ************if(rand(10000) == 1) ************{ ****************getmapxy(.@mapname$,.@mapx,.@mapy,0); ****************makeitem 7227,1,@mapname$,@mapx,@mapy; ************} ********} ****} end; } -****script****OnPCKillEvent****-1,{ OnPCKillEvent: ****if(@kills++ == 10) ****{ ********specialeffect2 805,AREA; ********@kills = 0; ****} end; }

Stack-based buffer overflow, probably did not take the multi-language prefix into account. Will see what can be done about it. Queued.

THIS IS AWESOME! I DIDN'T KNOW ALL THESE UPDATES EXISTED! XD Can I make a request for custom chatbox colors (as available in the 2010 07 28 diff file)? And... Custom and/or larger main fonts?

i dont agree with this.... the Search button is more useful than you can think of it... i was able search any information without fail...even those information that you guys alway claimed cant find / dont exist in forum ...

Download a new LUA/LUB files from my signature link and put it in your 'data\luafiles514\lua files' folder

<TAB> this refer to the TAB Button ...not asking you to put "<TAB>" on the script header.....

Added: WDGTranslateClient Only basic functionality tested, error-conditions are untested. The file has to be in same folder as the plugin. binary builds, sources

As viewID tem relação tanto na item_db2 quanto no visionary_tab.txt A mesma viewid do visionary_tab tem que estar no item na item_db2 se não ou vai da gravity error, aparecer uma sprite de outro item ou aparecer nada. Ex: visionary_tab.txt _Æ÷¸µÄÉÀÌÅ©¸ðÀÚ _¸Æáö¸ðÀÚ _¿õ°Ü¾Þ¹« _º´á¤¸ðÀÚ _ÀÌçḮƮ°¡¸É _ÀÌçḮƮÀç±í !1500 _meucustom01 _meucustom02 _meucustom03 *_°í±Û A viewid dos meus custons digmos que começa apartir de 1500, então vou na item_db2 e defino meus custons conforme as viewID do visionary_tab. Item_db2.txt 5134,Pumpkin_Hat,Pumpkin-Head,5,20,,200,,2,,0,0xFFFFFFFF,7,2,256,,0,1,1500,{ bonus2 bSubRace,RC_Demon,5; },{},{} 5136,Santa's_Hat_,Louise's Santa Hat,5,20,,100,,3,,0,0xFFFFFFFF,7,2,256,,0,1,1501,{ bonus bMdef,1; bonus bLuk,1; bonus3 bAutoSpellWhenHit,"AL_HEAL",3,50; bonus3 bAutoSpellWhenHit,"AL_BLESSING",10,50; },{},{} 5145,Carnival_Joker_Jester,Carnival Jester,5,10,,100,,0,,0,0xFFFFFFFF,7,2,256,,0,1,1502,{ bonus bAllStats,3; },{},{} As vezes me confundo se após o !1500 o item recebe a viewID 1500 mesmo ou se É 1501. VocÊ pode conferir isso atravÉs do comando @changelook viewID -> @changelook 1500 ou 1501 em diante.

Não sei se ainda é como antes porque não mexo com ragnarök faz tempo... Mas você define o view id no visionary_tab.txt na pasta data.

Provavelmente é um problema com viewID. Você precisa alterar para o número correto da sua view no equipamento, através do item_db.txt. Procure a coluna responsável para isso através do cabeçalho explicativo que encontra-se no próprio arquivo.