Leaderboard

You can also search by their login ID: UPDATE `login` SET `user_pass` = MD5('NEW_PASSWORD') WHERE `userid`='THEIR_LOGIN_ID';

Xantara's FluxCP Everyone knows of FluxCP. However, with the creation of rAthena, there became a need to support renewal changes and other features such as the new group system. This is where my Control Panel comes in. Xantara's FluxCP is a free and open source control panel to work with rAthena. Forked from FluxCP by Paradox924X and Byteflux at r1121. I will continually merge updates from the original FluxCP. Demo: http://web.artistic-coder.com/fluxcp-rA Note: this site is used to test new functionality and custom addons so it may not always be functioning properly Features The original/base FluxCP already comes with a lot of features. Here I will only highlight those that came after the fork. For a full list, click here. Updated Ragnarok Data Full Birthdate Functionality Working GM Group System Mob Skills SQLized Zeny Log Page Specific Item Drop Rates Toggle for Pre-Renewal or Renewal SQL Data Alchemist Ranking Blacksmith Ranking Paginated Item Shop Character/job images (static) WIP Account management system (link one or more in-game accounts to one CP account) Queued Accepted Suggestions (have suggestions? post them here!) Search in logs page Pin code functionality Character sprites with palettes (would replace static images) Requirements Apache webserver with PHP 5.2 or greater PDO extension with MySQL support (http://www.php.net/pdo) PHP GD2 for security images (Optional) Enabled Zip extension for exporting guild emblems (Optional) Apache/mod_rewrite for using the "Clean URLs" feature Download There are three ways to get a copy of this Control Panel. For detailed installation instructions, click here (TBD). 1. GIT Clone git clone https://github.com/missxantara/fluxcp-ra.git * For Windows, you can take a look at using TortoiseGit with its friendly user interface. 2. SVN Checkout svn checkout https://github.com/missxantara/fluxcp-ra/trunk/ * For Windows, you can take a look at using TortoiseSVN with its friendly user interface. 3. ZIP Download https://github.com/missxantara/fluxcp-ra/archive/master.zip Extra Downloads Extract to the root folder of your FluxCP system Job Image Files: http://missxantara.github.io/fluxcp-ra/downloads/FluxCP_Jobs_Images_2012-04-28.zip Updated details: April 28, 2013 Credits: Xantara Monster Image Files: http://missxantara.github.io/fluxcp-ra/downloads/FluxCP_Monsters_Eclage_14.2.zip Updated details: Mob ID #2380 of Eclage (Episode 14.2) Credits: Brynner Item Icon Files: http://missxantara.github.io/fluxcp-ra/downloads/FluxCP_Item_Icons_2012-04-08.zip Updated details: April 8, 2013 Credits: Latheesan's Extractor Item Image Files: http://missxantara.github.io/fluxcp-ra/downloads/FluxCP_Item_Images_2012-04-08.zip Updated details: April 8, 2013 Credits: Latheesan's Extractor Quick Links Wiki: https://github.com/missxantara/fluxcp-ra/wiki Bug/Suggestion Reports: https://github.com/missxantara/fluxcp-rA/issues GitPage: http://missxantara.github.io/fluxcp-ra Misc. Feel free to post any suggestions here. If suitable, they may be polled by general users before being decided to be implemented or not. If you have a feature already coded that you would like to share, please do send a GIT pull request or send me an SVN diff of the work - I'd love to take a look at it! Please note that working on this open-source project will furthermore serve as a learning opportunity for me. If you find that I've implemented something that could be improved, I urge you to let me know - your knowledge on this subject would be greatly appreciated! Like my work? Rep up the topic first post

File Name: Account Protection System SQL File Submitter: quesoph File Submitted: 09 Jul 2013 File Category: Source Modifications Content Author: quesoph //= ~ Account protection System ( @lock ) //===== By: ======================================================= //= ~ quesoph //===== Compatible With: ========================================== //= ~ Originally made for Hercules. Made compantible for rAthena //= ~ Available upon request //= ~ 3ceam, eAthena //===== Current Version: ========================================== //= ~ 1.0 Initial Release //= ~ 1.1 Disables Refine //= ~ 1.2 Disables Character Deletion //= ~ 1.3 Disables looting //= ~ 1.4 Prevent buying items from cash shop //= ~ 1.5 NPC Debug Fixed //= ~ 1.6 Disables skills //= ~ 1.7 Disables #/@Duel, #/@invite, #/@accept //= ~ 1.8 Disables Drop / Pick //= ~ 1.9 Disables NPC Click Except for GMs //= ~ 2.0 Disables #/@item, #/@item2, #/@produce //= ~ 2.1 SQL Update //= ~ 2.2 Added Flux Addon for passcode recovery. //===== Description: ============================================== //= Protects account from hackers or unauthorized use. //===== Policy ==================================================== //= ~ Purchased item are not refundable //= ~ Do not remove the Credits //= ~ You cannot use this on commercial purposes. //= ~ You cannot resell my work. //===== Support =================================================== //= ~ By purchasing this item you are eligible for life time support. //= ~ Contact me Via PM if you need support. //===== Questions? Bug Report? ==================================== //= Message me in rAthena. //= http://rathena.org/board/user/423-quesoph/ //================================================================= Click here to download this file

- script apple -1,{ OnWhisperGlobal: set .@item_id, 512; // Apple if (countitem(.@item_id)) { if (Hp) { dispbottom "You don't require resurrection at this moment."; } else { set .@count, callsub(S_getrevivecount); // if they have less than 3 revives this hour if (.@count < 3) { callsub S_setrevivecount, .@count +1; dispbottom "Your Acolytes are now praying in Prontera, please wait 10 seconds for the final judgement."; sleep2 10000; recovery 0; dispbottom "You have "+(3 - (.@count+1))+" revives left for this hour."; } else { dispbottom "You can only be revived 3x every hour."; } } } else { dispbottom "You need to have a "+getitemname(.@item_id)+" in your inventory."; } end; S_getrevivecount: set .@now_hour, atoi(gettimestr("%y%m%d%H",9)); // YYMMDDHH if (atoi(delchar(revive+"",8)) < .@now_hour) return 0; // if their last revive was not this hour, then they have used 0 revives this hour else return atoi(charat(revive+"",8)); S_setrevivecount: set revive, atoi(gettimestr("%y%m%d%H",9) + getarg(0)); return; }

I imagine there are better ways of doing this but whatever works right. void pc_damage(struct map_session_data *sd,struct block_list *src,unsigned int hp, unsigned int sp) { unsigned int tick = gettick(); int warpgodelaycd = 5000; //This is the delay in milliseconds you can set what ever delay you want struct map_session_data *md = (struct map_session_data *)src; if (sp) clif_updatestatus(sd,SP_SP); if (hp) clif_updatestatus(sd,SP_HP); else return; if( !src || src == &sd->bl ) return; if(src->type == BL_PC) { sd->warpgodelay_tick = tick+warpgodelaycd; //This is the timer md->warpgodelay_tick = tick+warpgodelaycd; //This is the timer } if( pc_issit(sd) ) { pc_setstand(sd); skill_sit(sd,0); } if( sd->progressbar.npc_id ) clif_progressbar_abort(sd); if( sd->status.pet_id > 0 && sd->pd && battle_config.pet_damage_support ) pet_target_check(sd,src,1); if( sd->status.ele_id > 0 ) elemental_set_target(sd,src); sd->canlog_tick = gettick(); }

you can use goggle.com and type how to make a private ragnarok online server

prontera,119,162,3 script Hired Help 56,{ //Dialogue if(@hired){ mes .npcn$; mes "It Looks like you two are having fun. Well don't let me stop you- carry on!"; close; } mes .npcn$; mes "Hello, would you be interested in purchasing some of my lovely ladies?"; mes "They buff you, heal you, and even revive you!!"; mes "So what do you say, huh?"; next; if(select("Yes:No")&2) { mes .npcn$; mes "You're missing out!"; close; } mes .npcn$; mes "It's 1z per-second with these beautiful gals."; input(.@time); if(.@time>Zeny||.@time<=0) { mes .npcn$; mes "You don't have enough. That's just too bad. Oh well better luck next time."; close; } close2; //End //Working parts set .@gid,bg_monster(.@bgid,.npcm$,.npcx,.npcy,"[Hired Help] "+.hhnm$[rand(1,getarraysize(.hhnm$))],.mobid,"Hired Help::OnBroken"); set @hired,1; set Zeny,Zeny-.@time; set .@usrid, getcharid(3); set .@map$,strcharinfo(3); while( set(.@i,.@i+1)&&playerattached()&&.@i<=.@time*20 ) { sleep2 1; if(!playerattached()) break; if((.@i%(.btym*20))==1) { while(.buffs[((set(.@i,.@i+2)-2)%(.btym*20))]) { unitskilluseid .@gid,.buffs[((.@i%(.btym*20))-2)],.buffs[(((.@i%(.btym*20))+1)-2)],.@usrid; sleep2 1000; } sc_start 32,240000,10,.@gid; } getmapxy(.@map1$,.@x1,.@y1,0); set .@dis, sqrt(pow(.@x1-.@tmpx,2 )+pow(.@y1-.@tmpy,2 ) ); if(.@dis&&.@dis<.wlkd){ unitwalk .@gid,.@tmpx,.@tmpy; .@lstx=.@tmpx; .@lsty=.@tmpy;} else if(.@dis>=.wlkd) unitwarp .@gid,.@map1$,.@x1,.@y1; else unitwalk .@gid,.@lstx,.@lsty; if(!(.@i%5)){ .@tmpm$=.@map1$;.@tmpx=.@x1;.@tmpy=.@y1; } if(.@map1$!=.@map$) { set .@map$, strcharinfo(3); unitwarp .@gid,.@map1$,.@x1,.@y1; } if(!Hp) unitskilluseid .@gid,54,4,.@usrid; if(Hp*100<MaxHp*.hpat) unitskilluseid .@gid,28,99,.@usrid; } killmonster .@map1$,"Hired Help::OnBroken"; if(playerattached()) set @hired,0; end; //End OnBroken: end; //NPC Variables OnInit: set .hpat, 70; //Heals the player when HP drops below this percent. You want this below 100 at all times. set .mobid,4000; //ID of your custom mob. set .btym, 240; //Rebuff in seconds. set .wlkd, 6; //Character speed before mobs warps to him. set .npcn$,"[^0000FFGreg^000000]"; getmapxy( .npcm$,.npcx,.npcy,1 ); setarray .buffs[1], 29, 10, 34, 10; // Skill_id, Skill_lv, Etc. setarray .hhnm$[1], "Ellsie", "Jenny", "Ashley", "Meghan", "Wenndy", "Anna"; //Hired npc will be randomly named from these values. } The only thing now is that each hired Arch Bishop is an independent monster. Meaning it can be attacked by players... including yourself. You can add healing skills to the monster in your mobskill_db2 and give it really high HP making make it extremely hard to kill, but ultimately without the proper commands I'm unable to return valid information in the safe keeping of the monster, and making it full out invincible doesn't work either because then not even the NPC that summoned it can kill it. Mercenary Based:

OnWhisperGlobal: if( getgmlevel() < 90 ) end;

it was src modification + means to insert that line

lol just do what i said on 2nd post. the category 1-5 and 7 is empty. that's why you got random disconnection issue.

So what's the difference between that and this? " mob_item_ratio "

clif.c find for(i=0,n=0; i < MAX_INVENTORY; i++) { if (tsd->status.inventory[i].nameid <= 0 || tsd->inventory_data[i] == NULL) // Item doesn't exist continue; if (!itemdb_isequip2(tsd->inventory_data[i])) // Is not equippable continue; + if(tsd->inventory_data[i]->equip >= 1024) + continue; // Add item info : refine, identify flag, element, etc. clif_item_sub(WBUFP(buf,0), n*s+43,i + 2, &tsd->status.inventory[i], tsd->inventory_data[i], pc_equippoint(tsd, i)); n++; }

More than just that spot prontera,183,215,3 script Broadcaster#1::BC 894,{ set @npcname$, "Broadcaster"; set @header$,"[^0000ff" + @npcname$ + "^000000]"; set broadcastfee, 1000000; if (agitcheck()){mes @header$; mes "War of Emperium is ongoing!"; close;} mes @header$; mes "Hi, I'm the Broadcaster"; mes "I can Broadcast a message for you"; next; mes @header$; mes "It costs ^ff0000"+ broadcastfee +"^000000 zeny "; next; mes @header$; mes "Would you like to Broadcast?"; switch (select("yes","No")){ case 1: if(#Broadcast> gettimetick(2)) { next; mes @header$; mes "Sorry you have to wait for 3min."; close; } next; mes @header$; if(Zeny<1000000) goto $nozenybc; set Zeny,zeny - broadcastfee; mes "Please input your message."; next; input broadcast$; announce "Message from "+strcharinfo(0)+": "+broadcast$+"",0,0xFFCC00; // Edit FFA500 to green color code close2; set #Broadcast, gettimetick(2)+180; dispbottom "Broadcaster: Please wait for 3min until next broadcast to avoid flooding."; end; case 2: mes "Suit yourself"; close; } $nozenybc: mes "I have to check that you have"; mes "enough money"; next; mes @header$; mes "Im sorry but you dont have ^ff0000"+broadcastfee+"^000000 zeny"; mes "Go get it if you want to Broadcast"; close; } louyang,213,45,6 duplicate(BC) Broadcaster#2 894 hugel,102,153,3 duplicate(BC) Broadcaster#3 894 gonryun,161,126,4 duplicate(BC) Broadcaster#4 894 morocc,148,102,5 duplicate(BC) Broadcaster#5 894 payon,164,216,2 duplicate(BC) Broadcaster#6 894 geffen,111,64,5 duplicate(BC) Broadcaster#7 894 turbo_room,94,120,5 duplicate(BC) Broadcaster#8 894

You can use Sir Emistry's Refine Function Script + from other working Derefiner script http://pastebin.com/raw.php?i=g8W9yhSs prontera,79,129,5 script test 757,{ mes "Refiner and Refine Remover"; next; switch (select("+1 Refiner","Refine Remover")) { case 1: mes "Which equipment you want to refine ?"; mes "make sure you have equipped the items and at least 1 Lotto Ball No.4."; next; callfunc( "RefineFunc",7364 ,1,63,0,10,1,0,100 ); end; case 2: setarray .@ItemID[0],7363,1; mes "Which equipment you want to reomove the refine?"; mes "make sure you have equipped the items and at least 1 Lotto Ball No.3."; next; if( countitem( .@ItemID[0] ) >= .@ItemID[1] ){ for( set .@i,1; .@i <= 10; set .@i,.@i + 1 ) set .@Menu$,.@Menu$ + (( getequipid(.@i) > 0 && getequiprefinerycnt(.@i) )? getitemname(getequipid(.@i)):"" )+":"; set .@i,select(.@Menu$); setarray .@GetData[0],getequipid(.@i),getequipcardid(.@i,0),getequipcardid(.@i,1),getequipcardid(.@i,2),getequipcardid(.@i,3); failedrefitem .@i; delitem .@ItemID[0],.@ItemID[1]; getitem2 .@GetData[0],1,1,0,0,.@GetData[1],.@GetData[2],.@GetData[3],.@GetData[4]; equip .@GetData[0]; mes "Done."; } end; } }

for (set .@i,0; .@i<8; set .@i,.@i+1) { mes (.@i+1) +". ^0000FF"+ .@aid$[.@i] +"^000000 ["+ .@var[.@i] +"]"; - close; } + close; your script close the window and put an end on for loop after one iteration

I can do all but add it to party. First add this NPC: prontera,119,162,3 script Hired Help 56,{ //Dialogue if(@hired){ mes .npcn$; mes "It Looks like you two are having fun. Well don't let me stop you- carry on!"; close; } mes .npcn$; mes "Hello, would you be interested in purchasing some of my lovely ladies?"; mes "They buff you, heal you, and even revive you!!"; mes "So what do you say, huh?"; next; if(select("Yes:No")&2) { mes .npcn$; mes "You're missing out!"; close; } mes .npcn$; mes "It's 1z per-second with these beautiful gals."; input(.@time); if(.@time>Zeny) { mes .npcn$; mes "You don't have enough. That's just too bad. Oh well better luck next time."; close; } close2; //End //Working parts set .@gid,bg_monster(.@bg,.npcm$,0,0,"Ellsie",.mobid,"Hired Help::OnFoobar"); summon("[Hired Help] "+.hhnm$[rand(1,getarraysize(.hhnm$))],.mobid,.@time*1000,"Hired Help::OnBroken"); set @hired,1; set Zeny,Zeny-.@time; killmonster .npcm$,"Hired Help::OnFoobar"; set .@gid,.@gid+1; .@usrid=getcharid(3); query_sql("SELECT ROUND(("+MaxHp+"*"+((.hpat>9)?"0."+(.hpat/10):"0.0"+(.hpat))+"));",.@hp); while( set(.@i,.@i+1)&&playerattached()&&.@i<=.@time ) { set .@map$,strcharinfo(3); sleep2 1000; if(!((.@i%240)-1)) {//Example of mob used buff. while(.buffs[((set(.@i,.@i+2)-2)%240)]) { unitskilluseid .@gid,.buffs[((.@i%240)-2)],.buffs[(((.@i%240)+1)-2)],.@usrid; sleep2 2000; } sc_start 32,240000,10,.@gid; //Increase her speed so she can keep up with us. } if(!Hp) unitskilluseid .@gid,54,4,.@usrid; if(Hp<.@hp&&Hp) unitskilluseid .@gid,28,99,.@usrid; } killmonster .@map$,"Hired Help::OnBroken"; set @hired,0; end; //End //NPC Variables OnInit: set .hpat, 70; //Heals the player when HP drops below this percent. You want this below 100 at all times. set .mobid,4000; //ID of your custom mob. set .npcn$,"[^0000FFGreg^000000]"; set .npcm$,strnpcinfo(4); setarray .buffs[1], 29, 10, 34, 10; // Skill_id, Skill_lv, Etc. setarray .hhnm$[1], "Ellsie", "Jenny", "Ashley", "Meghan", "Wenndy", "Anna"; //Hired npc will be randomly named from these values. } To make it look like an ArchBishop: Last: Enjoy! P.S: Make sure to replace all instances of 4000 with your custom mob id. Prototype:

check ur quest shop script ... the quest requirement is invalid ... trunk/npc/custom/quests/quest_shop.txt

yes u can make those this works, Use npc and Cutin/ broadcast and messages. Make banners of cutins... so when someone use npc that cutin will appear. by that u can promo aur advertise.

that was awesome. I wish I can be your apprentice

Can make everything with encrypted data using MD5() UPDATE `login` SET `user_pass` = MD5('"+<NEW PASSWORD>+"') WHERE `account_id` = '"+getcharid(3)+"'";

For the server status: Could it be that your VPS and domain are hosted into seperated hosts? If yes, contact your webhosting provider and ask them to open port 6900, 6121 and 5121 for you. That should solve the problem. Voting problem: V4P is not an default Flux addon, it requires you to install it before you can access the page. If you haven't installed it, do so by downloading Jaypee's release and extract it in your cp/addons.

aquaring poring aquaring .7z

Hi, There used to be an option if eAthena's gm.conf where you can allow GMs to bypass some restrictions Where can I find these in rAthena? Edit: Found it! For the sake of those who have the same problem, open up groups.conf and scroll down till the end. Set the following all_skill: true all_equipment: true skill_unconditional: true