-
Posts
547 -
Joined
-
Last visited
-
Days Won
3
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Posts posted by Dolphin86
-
-
Hye could i request an npc that can warp player to certain map with random location, but the npc will not allow player to bring any items will not allow any equipment, equipped or in inventory
and when player enter the map they will become novice, and when they exit the map they will become their default class as before they enter
thanks
-
i would request for basic Pre-Re data, client and also rathena SVN since my current server are kinda mess up so hard,
my current server item description are mix up with Pre-Re and Re and skill description are wrong, how can sniper DS and sharpshooting are same, monk and champion dmg are too low then official, i havent check on other class yet, but im sure they are mess up as well, please can someone help me to fix this ?
-
hye i need some help with my server, my server is Pre-Re, right now its kinda mess up which im not even sure what went wrong,
1. Item description are mix up with renewal and pre-re
2. Item description are all wrong example armor description give def +5 but when wear it only give def +3
3. Skill dmg are lower then it should be, example : sniper DS dmg is almost the same dmg with sharp shooting
im not sure how or where to fix this, could someone kindly help me
-
hye i would like to request for this npc script, can someone add a chat box on top of the npc and tell how many player are currently online
example : 10 Player Online
neko_isle,93,99,4 script PlayerOnline 512,{ query_sql "SELECT `name` , `class` FROM `char` WHERE `online` = '1'", [email protected]$, [email protected]; mes "-----------------------------------"; mes "Online Users: " + getusers(1); mes "-----------------------------------"; for( set [email protected],0; [email protected] < getarraysize([email protected]$); set [email protected],[email protected] + 1) mes [email protected]$[[email protected]]+ " | Job: " +jobname([email protected][[email protected]]); mes "-----------------------------------"; close; } -
6 hours ago, Naruto said:
if ([email protected] >= PET_INTIMATE_LOYAL) { bonus bAgi,1; bonus bAspdRate,1; } else if ([email protected] >= PET_INTIMATE_CORDIAL) { bonus bAspdRate,1; }your saying these dont work?
yes
6 hours ago, sader1992 said:you should add the database entry that you tested and didn't work so people can help you
im not even sure which file should i be looking at for, as far i checked is pet_db.yml
-
6 hours ago, Naruto said:
Pretty sure its the groups.conf your looking to edit
which part to edit.. sorry kinda blur atm.. brain farted
edited : add this to normal account ?
log_commands: true
problem solve, i just simple add this on the command list
commands: true
thanks for the help
-
As title, i did search and most the result are came from 2013 and below which im not sure if they work or not, could some one tell me how to fix pet does not add extra bonus to their master when reach loyal?
-
as title, sorry for being uber noob, but i need to add @command so normal account player can view list of commands they can use within the game,
thanks
-
Hye im not sure am i allowed to ask here, i need help to create an interesting server banner or advertise, i did try to make mine and using it for awhile
but im not really satisfy with the result since im not really a graphic guy.. if anyone would help me that would be so much for me
here is what i did so far :
Spoiler
-
does anyone have an updated version of this? im not sure why but its not working for me
-
well the npc currently only let player use it for 10 times, i did try to edit it to 999 use, but after 10 time use, it does not add anymore extra weight
-
6 minutes ago, LearningRO said:
you missing some file
on texture/À¯ÀúÀÎÅÍÆäÀ̽º/item/Yourspritename.bmp
texture/À¯ÀúÀÎÅÍÆäÀ̽º/Collection/yourspritename.bmpwoking on it i will inform if i still have the problems
-
sorry i dont understand...
On 4/24/2020 at 4:32 AM, iraciz said:Luad dont need to add male and female sprite, just the garment name
i have remove it, but still get some error

-
im not sure what part i did wrong, but here are the list of error i got
btw im using Icabits Item Builder

spriterobeid.lub
ROBE_n²_White_Butterfly_Wings = 54, ROBE_¿+_White_Butterfly_Wings = 55spriterobename.lub
[SPRITE_ROBE_IDs.ROBE_n²_White_Butterfly_Wings] = "n²_White_Butterfly_Wings", [SPRITE_ROBE_IDs.ROBE_¿+_White_Butterfly_Wings] = "¿+_White_Butterfly_Wings" -
hye guys, as title is it possible to make it unlimited use..?
-
As title can someone help me with this simple request, every time someone login to the server system will announce global
-
as title, for each item i add NPC will not show the point cost on mission shop, but it will show zeny cost
i add the item with 200 mission point cost but NPC showing 20z how can i fix this
my fullscript :
//===== rAthena Script ======================================= //= Hunting Missions //===== By: ================================================== //= Euphy //===== Current Version: ===================================== //= 1.2a //===== Compatible With: ===================================== //= rAthena SVN //===== Description: ========================================= //= Random hunting missions. //= Rewards are based on quest difficulty. //============================================================ chry_fld,106,66,4 script Hunting Missions 621,{ function Chk; function Cm; mes "[Hunting Missions]"; mes "Hello, "+strcharinfo(0)+"!"; if (!#Mission_Delay) { next; mes "[Hunting Missions]"; mes "I can't find any records..."; mes "You must be new here!"; emotion e_omg; next; callsub Mission_Info; emotion e_go; set #Mission_Delay,1; close; } mes rand(2)?"Working hard, as always...":"Not slacking, I hope..."; mes "Is there anything I can help"; mes "you with?"; mes " "; mes "^777777~ You've completed ^0055FF"+Mission_Total+"^777777 mission"+((Mission_Total == 1)?"":"s")+". ~^000000"; next; switch(select(((!Mission0)?" ~ New Mission::":": ~ Mission Status: ~ Abandon Mission")+": ~ Information: ~ Mission Shop: ~ View Top Hunters: ~ ^777777Cancel^000000")) { case 1: mes "[Hunting Missions]"; if (#Mission_Count) { mes "You've started a mission"; mes "on another character."; close; } if (#Mission_Delay > gettimetick(2) && .Delay) { set [email protected], #Mission_Delay-gettimetick(2); if ([email protected] > 3600) set [email protected]$, ([email protected]/3600)+" hour"+((([email protected]/3600) == 1)?"":"s"); else if ([email protected] > 60) set [email protected]$, ([email protected]/60)+" minute"+((([email protected]/60) == 1)?"":"s"); else set [email protected]$, ([email protected])+" second"+(([email protected] == 1)?"":"s"); mes "I'm afraid you'll have to wait "[email protected]$+" before taking another mission."; close; } mes "You must hunt:"; query_sql("SELECT ID FROM mob_db WHERE left(Sprite, 4) != 'meta' AND left(Sprite, 2) != 'E_' AND ~Mode & 32 AND EXP > 0 AND MVP1id = 0 AND DropCardid > 4000 AND DropCardid < 5000 AND ID < 2000 ORDER BY rand() LIMIT "+.Quests, [email protected]); for (set [email protected],0; [email protected]<.Quests; set [email protected],[email protected]+1) { setd "Mission"[email protected], [email protected][[email protected]]; setd "Mission"[email protected] +"_",0; } set #Mission_Count, rand(.Count[0],.Count[1]); callsub Mission_Status; next; mes "[Hunting Missions]"; mes "Report back when"; mes "you've finished."; mes "Good luck!"; close; case 2: mes "[Hunting Missions]"; mes "Mission status:"; callsub Mission_Status; close; case 3: mes "[Hunting Missions]"; mes "Do you really want to"; mes "abandon your mission?"; if (.Delay) mes "Your delay time will not be reset."; next; switch(select(" ~ Abandon...: ~ ^777777Cancel^000000")) { case 1: mes "[Hunting Missions]"; mes "Alright, I've dropped"; mes "your current mission."; specialeffect2 EF_STORMKICK4; for(set [email protected],0; [email protected]<.Quests; set [email protected],[email protected]+1) { setd "Mission"[email protected],0; setd "Mission"[email protected]+"_",0; } set #Mission_Count,0; if (.Delay) set #Mission_Delay, gettimetick(2)+(.Delay*3600); close; case 2: mes "[Hunting Missions]"; mes "I knew you were kidding!"; mes "Keep up the good work."; emotion e_heh; close; } case 4: callsub Mission_Info; close; case 5: mes "[Hunting Missions]"; mes "You have ^0055FF"+#Mission_Points+"^000000 Mission Points."; mes "Use them well!"; callshop "mission_shop",1; npcshopattach "mission_shop"; end; case 6: mes "[Hunting Missions]"; mes "The top hunters are:"; query_sql("SELECT char_id AS id, (SELECT `name` FROM `char` WHERE char_id = id),`value` FROM `global_reg_value` WHERE str = 'Mission_Total' ORDER BY CAST(`value` AS SIGNED) DESC LIMIT 5",[email protected],[email protected]$,[email protected]); for(set [email protected],0; [email protected]<5; set [email protected],[email protected]+1) mes " [Rank "+([email protected]+1)+"] "+(([email protected]$[[email protected]] == "")?"^777777none":"^0055FF"[email protected]$[[email protected]]+"^000000 : ^FF0000"[email protected][[email protected]]+" pt.")+"^000000"; close; case 7: mes "[Hunting Missions]"; mes "Nothing? Okay..."; emotion e_hmm; close; } Mission_Status: set @f,0; deletearray [email protected][0], getarraysize([email protected]); for(set [email protected],0; [email protected]<.Quests; set [email protected],[email protected]+1) { set [email protected][[email protected]], getd("Mission"[email protected]); set [email protected][.Quests], [email protected][.Quests]+strmobinfo(3,[email protected][[email protected]]); set [email protected][.Quests+1], [email protected][.Quests+1] + strmobinfo( 6, [email protected][[email protected]] ) / ( getbattleflag("base_exp_rate") / 100 ) * ( .baseexprate / 100 ); set [email protected][.Quests+2], [email protected][.Quests+2] + strmobinfo( 7, [email protected][[email protected]] ) / ( getbattleflag("job_exp_rate") / 100 ) * ( .jobexprate / 100 ); mes " > "+Chk(getd("Mission"[email protected]+"_"),#Mission_Count)+strmobinfo(1,[email protected][[email protected]])+" ("+getd("Mission"[email protected]+"_")+"/"+#Mission_Count+")^000000"; } // Reward formulas: set [email protected]_Points, 3+([email protected][.Quests]/.Quests/6); set [email protected]_Exp, #Mission_Count*[email protected][.Quests+1]/5; set [email protected]_Exp, #Mission_Count*[email protected][.Quests+2]/5; set [email protected], #Mission_Count*.Quests*[email protected][[email protected]]*.Multiplier; next; mes "[Hunting Missions]"; mes "Mission rewards:"; mes " > Mission Points: ^0055FF"[email protected]_Points+"^000000"; mes " > Base Experience: ^0055FF"+Cm([email protected]_Exp)+"^000000"; mes " > Job Experience: ^0055FF"+Cm([email protected]_Exp)+"^000000"; mes " > Zeny: ^0055FF"+Cm([email protected])+"^000000"; if (@f) { set @f,0; return; } next; mes "[Hunting Missions]"; mes "Oh, you're done!"; mes "Good work."; mes "Here's your reward."; emotion e_no1; specialeffect2 EF_ANGEL; specialeffect2 EF_TRUESIGHT; set #Mission_Points, #[email protected]_Points; getexp [email protected]_Exp,[email protected]_Exp; set Zeny, [email protected]; for(set [email protected],0; [email protected]<.Quests; set [email protected],[email protected]+1) { setd "Mission"[email protected],0; setd "Mission"[email protected]+"_",0; } set #Mission_Count,0; if (.Delay) set #Mission_Delay, gettimetick(2)+(.Delay*3600); set Mission_Total, Mission_Total+1; if (Mission_Total == 1) query_sql("INSERT INTO `global_reg_value` (`char_id`,`str`,`value`,`type`,`account_id`) VALUES ("+getcharid(0)+",'Mission_Total','1',3,0)"); else query_sql("UPDATE `global_reg_value` SET `value` = "+Mission_Total+" WHERE char_id = "+getcharid(0)+" AND `str` = 'Mission_Total'"); close; Mission_Info: mes "[Hunting Missions]"; mes "If you so choose, I can assign"; mes "you a random hunting quest."; mes "Some are easier than others, but"; mes "the rewards increase with difficulty."; next; mes "[Hunting Missions]"; mes "Missions points are shared"; mes "amongst all your characters."; if (.Delay) mes "Delay time is, too."; mes "You can't take missions on"; mes "multiple characters at once."; next; mes "[Hunting Missions]"; mes "You can start a quest"; if (.Delay) mes "every "+((.Delay == 1)?"hour.":.Delay+" hours."); else mes "whenever you want."; mes "That's everything~"; return; function Chk { if (getarg(0) < getarg(1)) { set @f,1; return "^FF0000"; } else return "^00FF00"; } function Cm { set [email protected]$, getarg(0); for(set [email protected],getstrlen([email protected]$)-3; [email protected]>0; set [email protected],[email protected]) set [email protected]$, insertchar([email protected]$,",",[email protected]); return [email protected]$; } OnBuyItem: set @cost,0; for(set [email protected],0; [email protected]<getarraysize(@bought_nameid); set [email protected],[email protected]+1) for(set [email protected],0; [email protected]<getarraysize(.Shop); set [email protected]j,[email protected]j+2) if (@bought_nameid[[email protected]i] == .Shop[[email protected]j]) { set @cost, @cost+(.Shop[[email protected]j+1]*@bought_quantity[[email protected]i]); break; } mes "[Hunting Missions]"; if (@cost > #Mission_Points) mes "You don't have enough Mission Points."; else { for(set [email protected],0; [email protected]<getarraysize(@bought_nameid); set [email protected],[email protected]+1) { getitem @bought_nameid[[email protected]], @bought_quantity[[email protected]]; dispbottom "Purchased "[email protected]_quantity[[email protected]]+"x "+getitemname(@bought_nameid[[email protected]])+"."; } set #Mission_Points, #[email protected]; mes "Deal completed."; emotion e_cash; } set @cost,0; deletearray @bought_nameid[0], getarraysize(@bought_nameid); deletearray @bought_quantity[0], getarraysize(@bought_quantity); close; OnNPCKillEvent: if (!getcharid(1) || !.Party) { if (!#Mission_Count || !Mission0) end; for (set [email protected], 0; [email protected]<.Quests; set [email protected],[email protected]+1) { if (strmobinfo(1,killedrid) == strmobinfo(1,getd("Mission"[email protected]))) { if (getd("Mission"[email protected]+"_") < #Mission_Count) { dispbottom "[Hunting Mission] Killed "+(set(getd("Mission"[email protected]+"_"),getd("Mission"[email protected]+"_")+1))+" of "+#Mission_Count+" "+strmobinfo(1,killedrid)+"."; end; } } } } else if (.Party) { set [email protected], killedrid; getmapxy([email protected]$,[email protected],[email protected],0); getpartymember getcharid(1),1; getpartymember getcharid(1),2; for(set [email protected],0; [email protected]<[email protected]; set [email protected],[email protected]+1) { if (isloggedin([email protected][[email protected]], [email protected][[email protected]])) { attachrid [email protected][[email protected]]; if (#Mission_Count && Mission0 && HP > 0) { getmapxy([email protected]$,[email protected],[email protected],0); if (([email protected]$ == [email protected]$ || .Party == 1) && (distance([email protected],[email protected],[email protected],[email protected]) <= 30 || .Party < 3)) { for(set [email protected],0; [email protected]<.Quests; set [email protected],[email protected]+1) { if (strmobinfo(1,[email protected]) == strmobinfo(1,getd("Mission"[email protected]))) { if (getd("Mission"[email protected]+"_") < #Mission_Count) { dispbottom "[Hunting Mission] Killed "+(set(getd("Mission"[email protected]+"_"),getd("Mission"[email protected]+"_")+1))+" of "+#Mission_Count+" "+strmobinfo(1,[email protected])+"."; break; } } } } } } } } end; OnInit: set .Delay,0; // Quest delay, in hours (0 to disable). set .Quests,4; // Number of subquests per quest (increases rewards). set .Party,3; // Party options: 0 (exclude party kills), 1 (include party kills), 2 (same map only), 3 (screen area only) set .Multiplier,60; // Multiplier for Zeny reward calculation. setarray .Count[0], // Min and max monsters per subquest (increases rewards). 40,70; setarray .Shop[0], // Reward items: <ID>,<point cost> (about 10~20 points per hunt). 22807,200 set .baseexprate, getbattleflag("base_exp_rate"); // adjustment for base exp rate. For SHR server, set this to a lower number. 100 means x1 set .jobexprate, getbattleflag("job_exp_rate"); // adjustment for job exp rate. npcshopdelitem "mission_shop",512; for(set [email protected],0; [email protected]<getarraysize(.Shop); set [email protected],[email protected]+2) npcshopadditem "mission_shop", .Shop[[email protected]], .Shop[[email protected]+1]; end; } - shop mission_shop -1,22807:-200
-
question, where should i add the script? inside npc/custom ?
-
hello is it possible to create such NPC so that Admin only can view player inventory, storage, and equipped gear, with a function to delete the item, even if the player is offline
like simply just input character ID it will give option view storage, view inventory and view equipped equipment
-
@Emistry just run on sql date base of my ragnarok correct?
-
17 minutes ago, Emistry said:
DELETE FROM `auction` WHERE `nameid` = 512; DELETE FROM `cart_inventory` WHERE `nameid` = 512; DELETE FROM `guild_storage` WHERE `nameid` = 512; DELETE FROM `inventory` WHERE `nameid` = 512; DELETE FROM `mail_attachments` WHERE `nameid` = 512; DELETE FROM `market` WHERE `nameid` = 512; DELETE FROM `sales` WHERE `nameid` = 512; DELETE FROM `storage` WHERE `nameid` = 512;- shutdown server
- edit the item ID
- run the queries above in your database
- restart server
512 is the item ID? what if i want to add multiple item to delete?
-
Welp as title, anyone can help me? i would like to remove some bugged item that most my player have been using on my server,
example, i talk to NPC and enter the item ID i want to delete, and everyone either his/her online or offline the item will be deleted
not matter where they put it, in inventory, equipped or in storage
-
@Emistry any reference i can look at? im not sure what name i should change it to..?
-
Hi im using RuneTerra-Skin but some how i got this error when i try to make the patcher

how can i fix this?
Request Warp NPC with function
in Script Requests
Posted
thanks @Emistry but where is the exit npc ?