Haruka Mayumi

I don't understand why you need the complete code when there's the query for it already.
Emperium Breaker:
mes "Top 10 Emperium Breaker"; if(!([email protected] = query_sql("SELECT B.`name`,B.`guild_id`,A.`count` FROM `breaker_ladder` AS A LEFT JOIN `char` AS B ON A.`char_id` = B.`char_id` ORDER BY `count` DESC LIMIT 10", [email protected]$,[email protected],[email protected]))) { mes "No data found."; close; } for ( [email protected] = 0; [email protected] < [email protected]; [email protected]++ ) { mes ([email protected]+1) +". "+ [email protected]$[[email protected]] +" ~ "+(getguildname([email protected][[email protected]]) == "null" ? "None":getguildname([email protected][[email protected]]))+" ~ "+ [email protected][[email protected]] +" breaks."; } for the WoT Ranking. i'll leave this to you so you can learn how to left join.

EDIT: FYI you actually don't need to create a breaker_ladder sql.. just use a character variable such as "set EmpBreak,EmBreak+1;" then simply join the char_reg_num with char table. although it has certain delay

int color = 0xC6A518; clif_messagecolor(&sd->bl, color, atcmd_output, true, SELF);  

if(!getcharid(2)){ mes "You are not part of any guild."; end; }  

Enable Multi-level

It's nice to use function for this but with just 2 comparable string.. you can just use the compare function like this
604,Branch_Of_Dead_Tree,Dead Branch,2,50,,50,,,,,0xFFFFFFFF,7,2,,,,,,{ if( compare(strcharinfo(3),"dbroom") || compare(strcharinfo(3),"06guild_")) { delitem 604,1; monster "this",-1,-1,"--ja--",-1,1,""; } else dispbottom "This item cannot be used within this are. please use the db room!"; },{},{}  

bonus bStr,readparam(bStr)*20/100; bonus bAgi,readparam(bAgi)*20/100; bonus bVit,readparam(bVit)*20/100; bonus bInt,readparam(bInt)*20/100; bonus bDex,readparam(bDex)*20/100; bonus bLuk,readparam(bLuk)*20/100;  
 
Convert the problem to an equation using the percentage formula: (Percent * NUM = M) / 100  = Answer Percent is 20, NUM is readparam(bStr), so the equation is 20% * 100%(let's say your Str is 100) = M So in the equation: 20 * 100 = (M becomes 2000) / 100 = Answer Answer = 20 So 20% of 100 is 20 This one is easy if rAthena can use float but the sad thing is.. The script only accept integers.. Easiest way is readparam(bStr)*0.20 wherein 0.20 is float.

prontera,150,182,4 script Healer 10173,5,5,{ OnTouch: while( [email protected] < .sc_size ){ sc_end .sc_status[[email protected]]; set [email protected],[email protected] + 1; } sc_start SC_BLESSING,.buff_duration,10; sc_start SC_INCREASEAGI,.buff_duration,10; percentheal 100,100; while( getbrokenid(1) ) // repair getbrokenid(1); repairall; // atcommand "@repairall"; end; OnInit: set .buff_duration,600000; setarray .sc_status, SC_STONE,SC_FREEZE,SC_STUN,SC_SLEEP,SC_POISON,SC_CURSE,SC_SILENCE,SC_CONFUSION,SC_BLIND,SC_BLEEDING, SC_QUAGMIRE,SC_AETERNA,SC_HALLUCINATION,SC_SLOWDOWN,SC_BERSERK,SC_CHANGEUNDEAD, SC_STRIPWEAPON,SC_STRIPSHIELD,SC_STRIPARMOR,SC_STRIPHELM; set .sc_size,getarraysize( .sc_status ); waitingroom "Free Heal",0; end; }  

prontera,155,170,3 script Tamadora 10110,3,3,{ end; OnTouch_: if(gettime(DT_HOUR) < 7) end; // 7AM Onwards if(!.Active){ initnpctimer; .Active = 1; .CFail = 0; } end; OnTimer1000: getmapxy([email protected]$,[email protected],[email protected],BL_NPC); [email protected] = getareaunits(BL_PC,[email protected]$,[email protected],[email protected],[email protected]+.Cells,[email protected]+.Cells,[email protected]); if([email protected]){ if(++.CFail>=.Fail){ stopnpctimer; .Active = 0; end; } initnpctimer; end; } if(.CurrentCD >= .Countdown){ [email protected] = rand(getarraysize(.ItemDrop)); makeitem .ItemDrop[[email protected]],.ItemAmt[[email protected]],[email protected]$,rand([email protected],[email protected]+.Cells),rand([email protected],[email protected]+.Cells); } if(.Countdown-.CurrentCD <= 0) .CurrentCD = 0; if(.CurrentCD%3==0){ for([email protected]=0;[email protected]<[email protected];[email protected]++){ [email protected] = rand(getarraysize(.SkillID)); unitskilluseid getnpcid(0),.SkillID[[email protected]],.SkillLV[[email protected]],[email protected][[email protected]],-1; } showscript "~ < "+(.Countdown-.CurrentCD++)+" > ~",getnpcid(0),AREA; sleep 1000; } showscript "~ < "+(.Countdown-.CurrentCD++)+" > ~",getnpcid(0),AREA; npcwalkto rand(.XY[0],.XY[2]),rand(.XY[1],.XY[3]); initnpctimer; end; OnInit: .Countdown = 120; //seconds .Fail = 3; //3 seconds .Cells = 5; //3 Cells Away npcspeed 150; setarray .XY[0],150,175,160,165; setarray .ItemDrop[0],7929; setarray .ItemAmt[0],1; setarray .SkillID[0],489,16,29,30,34; setarray .SkillLV[0],15,20,10,10,10; end; }  

prontera,155,181,3 script Yumi Test 94,{ for([email protected]=0;[email protected]<getarraysize(.Require);[email protected]++) [email protected]$ += (countitem(.Require[[email protected]]) ? "- Exchange ^0055FF"+.ReqAmount[[email protected]]+"^000000 "+getitemname(.Require[[email protected]])+" to ^0055FF"+.ExcAmount[[email protected]]+"^000000 "+getitemname(.Exchange[[email protected]])+":":":"); [email protected] = select([email protected]$)-1; message strcharinfo(0),"Input amount 1-1000"; input [email protected],1,1000; if(countitem(.Require[[email protected]]) < .ReqAmount[[email protected]]*[email protected]){ message strcharinfo(0),"Insufficient "+getitemname(.Require[[email protected]])+""; end; } if(!checkweight(.Exchange[[email protected]],[email protected]*.ExcAmount[[email protected]])){ message strcharinfo(0),"Insufficient inventory space"; end; } delitem .Require[[email protected]],.ReqAmount[[email protected]]*[email protected]; getitem .Exchange[[email protected]],[email protected]*.ExcAmount[[email protected]]; end; OnInit: setarray .Require[0],501,502,503,504,505; setarray .ReqAmount[0],1,1,1,1,1; setarray .Exchange[0],512,513,514,515,516; setarray .ExcAmount[0],50,25,20,30,45; end; }  

@ra11 hmm.. It should be scripting. and database management for rAthena.. C,C++ I learned them on school so I skipped it here lmao.

Here's a link from where you should start.. there's Sample folder located in that link. You can try to understand it via script_commands.txt
https://github.com/rathena/rathena/tree/master/doc
 
Hmm.. a lot like...

C,C++,SQL.. Some ruby expressions, (some yaml parsing knowledge if you want to be kind of updated) and some stuff for advance administering the server like networking to provide some better experience and protection, linux setup, windows setup, Php, javascript, html, bootstrap etc for web..

for client side.. Photoshop knowledge, Spriting, Lua Programming Language, Browedit, hex edit, resource hacking etc.. well I haven't mention them all since I forgot things I mostly don't use. also, some things I listed were not that much needed like bootstrap and javascript.. 

*noreturn Disables usage of map-warping items on a map: - Butterfly Wing (ID 602) - Yellow/Green/Red/Blue Butterfly Wing (IDs 14582-14585) - Siege Teleport Scroll (ID 14591) - Dungeon Teleport Scroll 1/2/3 (IDs 14527, 14581, 12352) The 'warpparty' and 'warpguild' script commands are also blocked for destinations outside the player's current map. you can also check ingame via @mapflag to see the mapflags associated on the map.

There's already a command for this.. Here's the Link.

Well. There's GitHub desktop which is very useful for beginners because of it's friendly interface.. Base on my experience there are only few commands on git bash that are not visible as interface in GitHub Desktop.. Although i mostly use git bash on my workstation. i also use github desktop to easily view the comparison of my changes.

you probably turn this off from conf/battle/player.conf

// Revive dead player while warping? (Note 1)
revive_onwarp: yes

you probably forgot to add mapflag woe_consume

prontera,155,181,5 script Yumi 94,{ [email protected] = getpartyleader(getcharid(1),1); [email protected] = getpartyleader(getcharid(1),2); if(!isloggedin([email protected],[email protected])){ message strcharinfo(0),"Party Leader is Offline"; end; } getmapxy([email protected]$,[email protected],[email protected],BL_PC,[email protected]); warp [email protected]$,[email protected],[email protected]; end; }  

you must install secret's web service for 2020 newer clients for now.

https://github.com/secretdataz/athena-web-service

This lord of death script line
bonus2 bComaClass,Class_Normal,1; change into
bonus2 bWeaponComaClass,Class_Normal,1; Script Command [ Coma ]

// When to re-display the guild notice // Upon teleporting (regardless of changing maps): 2 (official) // Upon changing maps: 1 // Do not re-display: 0 (disabled) guild_notice_changemap: 0
https://github.com/rathena/rathena/blob/master/conf/battle/guild.conf#L56

GRF : data/luafiles514/lua files/signboardlist.lub

case UNT_WHISTLE: case UNT_ASSASSINCROSS: case UNT_POEMBRAGI: case UNT_APPLEIDUN: case UNT_HUMMING: case UNT_DONTFORGETME: case UNT_FORTUNEKISS: case UNT_SERVICEFORYOU: + if(bl->type == BL_HOM) return 0; if (sg->src_id==bl->id && !(sc && sc->data[SC_SPIRIT] && sc->data[SC_SPIRIT]->val2 == SL_BARDDANCER)) return 0; if (!sc) return 0; if (!sce) sc_start4(ss, bl,type,100,sg->skill_lv,sg->val1,sg->val2,0,sg->limit); else if (sce->val4 == 1) { //Readjust timers since the effect will not last long. sce->val4 = 0; //remove the mark that we stepped out delete_timer(sce->timer, status_change_timer); sce->timer = add_timer(tick+sg->limit, status_change_timer, bl->id, type); //put duration back to 3min } break;  

'BaseURI' => '', config/application.php

you can't use someone stable database and use your own emulator.. there would be a lot of errors because the source you have will read a database that is not configured for your emulator..

always use your database files from sql-files folder.

It probably has a black left over from the sprite.. you will have to clean that using any image editor.

1. getmapunits(<type>,<"map name">{,<array_variable>[<first value>]})
2. loop the array
3. use setd and use the gepardid
4. check using getd if the player is given.