macmac88
-
Posts
21 -
Joined
-
Last visited
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Posts posted by macmac88
-
-
Hi,
I'm testing in using SQL for item database and found this error on the terminal:
[Error]: Monster Drops item Black_Treasure_Box does not exist, skipping. [Error]: Occurred in file '' on line 0 and column -1. [Error]: Monster Drops item Black_Treasure_Box does not exist, skipping. [Error]: Occurred in file '' on line 0 and column -1. [Error]: Monster Drops item Black_Treasure_Box does not exist, skipping. [Error]: Occurred in file '' on line 0 and column -1. [Error]: Monster Drops item Black_Treasure_Box does not exist, skipping. [Error]: Occurred in file '' on line 0 and column -1. [Error]: Monster Drops item Pumpkin_Head_Crushed does not exist, skipping. [Error]: Occurred in file '' on line 0 and column -1. [Error]: Monster Drops item Worn_Cloth_Piece does not exist, skipping. [Error]: Occurred in file '' on line 0 and column -1. [Error]: Monster Drops item Gold_Tulip does not exist, skipping. [Error]: Occurred in file '' on line 0 and column -1.
I have looked in item_db_re_usable.sql and found those items:
VALUES (12715,'Black_Treasure_Box'
item_db_re_etc.sql
VALUES (6298,'Pumpkin_Head_Crushed
Can someone tell me where to look for "Monster Drops" ... thank you
-
thank you very much... i get the idea now
-
1 hour ago, Scylla said:
Technically it's not percentage.
rand(7) = random between 0,1,2,3,4,5,6
rand(3) = random between 0,1,2
rand (1,5) = random between 1,2,3,4,5
rand function will always pick one random number depending on what you specified
So example:
if (rand(5) == 1){ mes "Number 1 was picked via rand!"; } else { mes "Either 0, 2, 3 or 4 was picked."; }
thank you very much... i thought it was a percentage value where 1% you get the rare item and 100% you get the junk items or none.
what function in mind best describe my example, where 1% you get rare and 100% you get junk or vice versa?
-
mga lodi paki explain naman paano kinocompute ung percentage ng rand function?
salamat po
-
i'm testing this script but i'am now stuck because i need an sql version or yml format the server database you posted.
-
On 4/25/2014 at 5:22 AM, Pneuma said:
Most of you who use fishing scripts on your server have probably checked out my Fishing Script before...Well I've been working on currently enhancing it.
Changelog:v1.2 Shortened most of the script Added Sounds and Effects to make it a bit more lively Added two new Configurations - Auto Fish, Auto Fish on fail Enhanced map announce to work with where-ever the script is located Enhanced randomizing caught junk to enable a lot more to be added Removed Chat menu so the script has less clicking
Fishing 1.2.txt
This one is slightly different then the one below.Fishing 1.2.txt 1.8 kB · 64 downloads
Please read Optional-Addons before using this script.
Optional Add-ons
Costume Tab Items
//Retains item ID but replaces them to Costume tab to not remove your equipment.
//Only use if You're using a version which allows Shadow Equipment and Costume Tab
2443,Fisher's_Boots,Fisher's Boots,12,20,10,10,,,,,0xFFFFFFFF,63,2,524288,,1,0,,{},{},{} 2550,Fisher's_Muffler,Fisher's Muffler,12,20,10,10,,,,,0xFFFFFFFF,63,2,8192,,1,0,,{},{},{} 2764,Fishing_Pole,Fishing Pole,12,20,10,10,,,,,0xFFFFFFFF,63,2,3145728,,1,0,,{},{},{} 2775,Fishing_Lure,Fishing Lure,12,20,10,10,,,,,0xFFFFFFFF,63,2,3145728,,1,0,,{},{},{}
Sound Effects
//If you wish to use sound effects, it is recommended you download these. Otherwise remove it from your script.
// To remove, remove soundeffect "fishingrod.wav",0; and soundeffectall "success.wav",0,strcharinfo(3); from the script.
Place this in your data folder or GRF
Wav Folder
Upcoming Changes
This script has been abandoned to start work on a Profession System.Where do I put those costume tab items?
-
-
//======Name======================================== // Mining NPC //======Version===================================== // 1.0 //======Author(s)=================================== // Sandbox //======Comments==================================== // In loving memory of AstralRO //================================================== prontera,163,162,3 script Hermoining 726,{ mes "[^0000FF Hermoining ^000000]"; mes "Hiya! I'm the master of Mining, ^880000Hermoining^000000!"; menu "Whoa, teach me master!",-; next; mes "[^0000FF Hermoining ^000000]"; mes "Okay, You'll be needing a ^008800Pick Axe^000000 for mining. While inside the map, you'll be able to mine mithril ores which can be sold for zeny!"; next; mes "[^0000FF Hermoining ^000000]"; mes "So, do you want to proceed?"; menu "Buy Pick Axe!",-,"Yes Master",Lpick; close2; callshop "PickShop"; close; Lpick: if(JobLevel < 50) goto Lnjob; mes "[^0000FF Hermoining ^000000]"; mes "Have fun!"; sc_end SC_ALL; warp "force_2-2",174,115; close; Lnjob: next; mes "[^0000FF Hermoining ^000000]"; mes "Sorry, you need to be atleast job 50 or higher in order to enter."; close; } - shop PickShop -1,6010:10000 force_2-2,159,177,5 script Mine Exit 848,{ mes "[^888800 Minero ^000000]"; mes "Do you want to get out of here?"; menu "Yes please!",-; next; mes "[^888800 Minero ^000000]"; mes "See you soon!"; warp "prontera",156,191; close; } force_2-2,161,184,3 script Mithril Ore 1976,{ if(#minedelay+86400 > gettimetick(2)) goto Ldelay; //Comment if you dont want to put a limit on mining if(@mining != 0) goto Lstillmine; if(.mining != 0) goto Lalreadymine; //mes "Do you want to mine this rock?"; //menu "Proceed",-; //next; if(countitem(6010) < 1) goto Lnopick; delitem 6010,1; set #MineCount,#MineCount+1; if(#MineCount == 10000) { //Comment if you dont want to put a limit on mining DEFAULT = 10,000x failed or success set #minedelay,gettimetick(2); set #MineCount,0; } set @minechance,rand(1,16); set .mining,1; set @mining,1; pcblockmove getcharid(3),1; if(MineLvl == 0) { misceffect 102; //Mining level 0 waits 4 seconds before mining sleep2 1000; //misceffect 102; //sleep2 1000; //misceffect 102; //sleep2 1000; //misceffect 102; //sleep2 1000; set .mining,0; set @mining,0; pcblockmove getcharid(3),0; if(@minechance >= 12){ set MineExp,MineExp+3; if(@minechance >= 7) set MineExp,MineExp+2; if(@minechance >= 2) set MineExp,MineExp+1; if(@minechance == 2) getitem 985,1; //elunium else if(@minechance == 3) getitem 984,1; //oridecon else if(@minechance == 4) getitem 7915,1; //bronze coin else if(@minechance == 5) getitem 6223,1; //carnium else if(@minechance == 6) getitem 6224,1; //bradium else if(@minechance == 7) getitem 7916,1; //silver coin else if(@minechance == 8) getitem 6241,1; //hd elunium else if(@minechance == 9) getitem 6240,1; //hd oridecon else if(@minechance == 10) getitem 7619,1; //enriched elunium else if(@minechance == 11) getitem 7620,1; //enriched oridecon else if(@minechance == 12) getitem 6225,1; //hd carnium else if(@minechance == 13) getitem 6226,1; //hd bradium else if(@minechance == 14) getitem 7517,1; //gold coin else if(@minechance == 15) getitem 674,1; //mithril coin else if(@minechance == 16) getitem 677,1; //platinum coin misceffect 154; goto Lsuccess; } else{ getitem 7049,1; misceffect 155; goto Lfail; } } if(MineLvl == 1) { misceffect 102; //Mining level 1 waits 3 seconds before mining sleep2 1000; misceffect 102; sleep2 1000; misceffect 102; sleep2 1000; set .mining,0; set @mining,0; pcblockmove getcharid(3),0; if(@minechance >= 12){ set MineExp,MineExp+3; if(@minechance >= 7) set MineExp,MineExp+2; if(@minechance >= 2) set MineExp,MineExp+1; if(@minechance == 2) getitem 985,1; //elunium else if(@minechance == 3) getitem 984,1; //oridecon else if(@minechance == 4) getitem 7915,1; //bronze coin else if(@minechance == 5) getitem 6223,1; //carnium else if(@minechance == 6) getitem 6224,1; //bradium else if(@minechance == 7) getitem 7916,1; //silver coin else if(@minechance == 8) getitem 6241,1; //hd elunium else if(@minechance == 9) getitem 6240,1; //hd oridecon else if(@minechance == 10) getitem 7619,1; //enriched elunium else if(@minechance == 11) getitem 7620,1; //enriched oridecon else if(@minechance == 12) getitem 6225,1; //hd carnium else if(@minechance == 13) getitem 6226,1; //hd bradium else if(@minechance == 14) getitem 7517,1; //gold coin else if(@minechance == 15) getitem 674,1; //mithril coin else if(@minechance == 16) getitem 677,1; //platinum coin misceffect 154; goto Lsuccess; } else{ getitem 7049,1; misceffect 155; goto Lfail; } } if(MineLvl == 2){ misceffect 102; //Mining level 2 waits 2 seconds before mining sleep2 1000; misceffect 102; sleep2 1000; set .mining,0; set @mining,0; pcblockmove getcharid(3),0; if(@minechance >= 12){ set MineExp,MineExp+3; if(@minechance >= 7) set MineExp,MineExp+2; if(@minechance >= 2) set MineExp,MineExp+1; if(@minechance == 2) getitem 985,1; //elunium else if(@minechance == 3) getitem 984,1; //oridecon else if(@minechance == 4) getitem 7915,1; //bronze coin else if(@minechance == 5) getitem 6223,1; //carnium else if(@minechance == 6) getitem 6224,1; //bradium else if(@minechance == 7) getitem 7916,1; //silver coin else if(@minechance == 8) getitem 6241,1; //hd elunium else if(@minechance == 9) getitem 6240,1; //hd oridecon else if(@minechance == 10) getitem 7619,1; //enriched elunium else if(@minechance == 11) getitem 7620,1; //enriched oridecon else if(@minechance == 12) getitem 6225,1; //hd carnium else if(@minechance == 13) getitem 6226,1; //hd bradium else if(@minechance == 14) getitem 7517,1; //gold coin else if(@minechance == 15) getitem 674,1; //mithril coin else if(@minechance == 16) getitem 677,1; //platinum coin misceffect 154; goto Lsuccess; } else{ getitem 7049,1; misceffect 155; goto Lfail; } } if(MineLvl == 3) { misceffect 102; //Mining level 3 waits 1 seconds before mining sleep2 1000; set .mining,0; set @mining,0; pcblockmove getcharid(3),0; if(@minechance >= 12){ set MineExp,MineExp+3; if(@minechance >= 7) set MineExp,MineExp+2; if(@minechance >= 2) set MineExp,MineExp+1; if(@minechance == 2) getitem 985,1; //elunium else if(@minechance == 3) getitem 984,1; //oridecon else if(@minechance == 4) getitem 7915,1; //bronze coin else if(@minechance == 5) getitem 6223,1; //carnium else if(@minechance == 6) getitem 6224,1; //bradium else if(@minechance == 7) getitem 7916,1; //silver coin else if(@minechance == 8) getitem 6241,1; //hd elunium else if(@minechance == 9) getitem 6240,1; //hd oridecon else if(@minechance == 10) getitem 7619,1; //enriched elunium else if(@minechance == 11) getitem 7620,1; //enriched oridecon else if(@minechance == 12) getitem 6225,1; //hd carnium else if(@minechance == 13) getitem 6226,1; //hd bradium else if(@minechance == 14) getitem 7517,1; //gold coin else if(@minechance == 15) getitem 674,1; //mithril coin else if(@minechance == 16) getitem 677,1; //platinum coin misceffect 154; goto Lsuccess; } else{ getitem 7049,1; misceffect 155; goto Lfail; } } Lsuccess: //Required experience before a player's mining level increases. dispbottom "You've successfully mined the ore."; if(MineExp < 100000 && (@minechance >= 2)) dispbottom "You've gained 1 Mining Exp."; if(MineExp < 100000 && (@minechance >= 7)) dispbottom "You've gained 2 Mining Exp."; if(MineExp < 100000 && (@minechance >= 12)) dispbottom "You've gained 3 Mining Exp."; if(MineExp == 10000) { set MineLvl,1; dispbottom "Congratulations! Your Mining Mastery is now Level 1!"; announce strcharinfo(0)+"'s Mining Mastery reached Level 1!",bc_all,0x00FFFF; } else if(MineExp == 50000) { set MineLvl,2; dispbottom "Congratulations! Your Mining Mastery is now Level 2!"; announce strcharinfo(0)+"'s Mining Mastery reached Level 2!",bc_all,0x00FFFF; } else if(MineExp == 100000) { set MineLvl,3; dispbottom "Congratulations! Your Mining Mastery is now Level 3!"; announce strcharinfo(0)+"'s Mining Mastery reached Level 3!",bc_all,0x00FFFF; } end; Lfail: dispbottom "You got junk from the ore."; end; Lnopick: mes "^FF0000*Hand Smash!!*^000000"; next; mes "Ouch! I'll be needing a ^008800Pickaxe^000000 for this.."; close; Lalreadymine: mes "Hey! Get your own spot!"; close; Lstillmine: mes "Ugh, i'm not done mining yet!"; close; Ldelay: mes "You can only mine 10,000 ores a day!"; close; OnInit: goto Lwalk; end; Lwalk: sleep 1000; npcwalkto rand(161,186),rand(119,184); goto Lwalk; end; }
I'm new to scripting and the script has no errors, but It seems not doing what it supposed to post on the "dispbottom"
dispbottom "You've successfully mined the ore."; if(MineExp < 100000 && (@minechance >= 2)) dispbottom "You've gained 1 Mining Exp."; if(MineExp < 100000 && (@minechance >= 7)) dispbottom "You've gained 2 Mining Exp."; if(MineExp < 100000 && (@minechance >= 12)) dispbottom "You've gained 3 Mining Exp.";
I always get "You've gained 1 Mining Exp." even if I get a @minechance of >12
And can someone help me how can I put "else if" in this code below. It gives error when I add "else"
if(@minechance >= 12){ set MineExp,MineExp+3; if(@minechance >= 7) set MineExp,MineExp+2; if(@minechance >= 2) set MineExp,MineExp+1;
I'm using a client ver 20200401
-
On 10/9/2017 at 6:37 PM, rakuzas said:
Hello,
I just notice this and all scripts using sleep2 got error..
And mining script I use also not working properly and got too many debug message..How can I fix this?
In script_commands.txt*sleep {<milliseconds>}; *sleep2 {<milliseconds>}; *awake "<NPC name>"; These commands are used to control the pause of a NPC. sleep and sleep2 will pause the script for the given amount of milliseconds. Awake is used to cancel a sleep. When awake is called on a NPC it will run as if the sleep timer ran out, and thus making the script continue. Sleep and sleep2 basically do the same, but the main difference is that sleep will not keep the rid, while sleep2 does. Also sleep2 will stop the script if there is no unit attached. Examples: sleep 10000; //pause the script for 10 seconds and ditch the RID (so no player is attached anymore) sleep2 5000; //pause the script for 5 seconds, and continue with the RID attached. awake "NPC"; //Cancels any running sleep timers on the NPC 'NPC'.
EDIT : SOLVED!
Can you tell me how did you solve this error?
-
how do i put this on my test server?
i'm a newbie in scripting... does the script only work on manuk map?
-
On 3/30/2013 at 6:43 PM, Emistry said:
you can do like this too
- shop Sample_Shop -1,909:-1 - script Sample -1,{ OnInit: bindatcmd "sell",strnpcinfo(3)+"::OnAtCommand"; end; OnAtCommand: callshop "Sample_Shop",2; end; }
where do i need to put this script?
-
3 hours ago, lelouchxv said:
i dont think so i thnk you need to edit it manually
yeah i have read about lua query commands and it's really complicated
-
1 hour ago, lelouchxv said:
Edit it on your iteminfo.lua if you are using 2015+ clients
is there a program which i can sort all weapons and make it 4 slot in iteminfo_en.lua?
it would be great if we could edit them in one go...
-
On 1/17/2021 at 3:04 PM, Deye0823 said:
I was able to solve this problem with the help of @Renzadic
Helped me through discord, good person and excellent support!
I make this thread as closed. Hope everyone who has the same problem can solve it!
THANKS
how did he fixed it?
-
Answer:
after editing the item_db_equip.yml in the server, you will need to change the entry in the client, <ragnarok folder>/System/itemInfo.lub.
in my case it's the itemInfo_EN.lua
-
hi,
can someone help me change multiple entry in item_db_equip.yml like
changing only weapons to 4 slots and armor to 2 slots.
what is the correct search query for this new item_db_equip.yml?
-
-
On 4/1/2021 at 2:24 PM, kalabasa said:
you mean item_db_equip.yml?
add this
Slots: 4
How about adding 4 slots on weapons only while adding 2 slots on armors only? how would you query that in a search?
On 4/1/2021 at 1:28 PM, Mitosky said:Hi sir, my question is how add slot en mi item. Greetins!!
-
On 4/19/2013 at 11:21 PM, naaaan said:
prontera,150,150,5 script Caster 811,{ percentheal 100,100; skilleffect 384,0; sc_start SC_MELTDOWN,360000,5; skilleffect 383,0; sc_start SC_WINDWALK,360000,5; skilleffect 378,0; sc_start SC_EDP,360000,5; skilleffect 465,0; sc_start SC_KAITE,360000,7; skilleffect 464,0; sc_start SC_KAUPE,360000,3; skilleffect 463,0; sc_start SC_KAAHI,360000,7; skilleffect 462,0; sc_start SC_KAIZEL,360000,7; skilleffect 8,0; sc_start SC_ENDURE,360000,10; skilleffect 33,0; sc_start SC_ANGELUS,360000,10; skilleffect 45,0; sc_start SC_CONCENTRATE,360000,10; skilleffect 74,0; sc_start SC_MAGNIFICAT,360000,5; skilleffect 75,0; sc_start SC_GLORIA,360000,5; skilleffect 459,0; sc_start SC_ADRENALINE2,360000,1; skilleffect 66,0; sc_start SC_IMPOSITIO,360000,5; skilleffect 67,0; sc_start SC_SUFFRAGIUM,360000,3; skilleffect 34,0; sc_start SC_BLESSING,360000,10; skilleffect 29,0; sc_start SC_INCREASEAGI,360000,10; skilleffect 112,0; sc_start SC_WEAPONPERFECTION,360000,10; skilleffect 113,0; sc_start SC_OVERTHRUST,360000,5; skilleffect 114,0; sc_start SC_MAXIMIZEPOWER,360000,5; skilleffect 357,0; sc_start SC_CONCENTRATION,360000,5; skilleffect 355,0; sc_start SC_AURABLADE,360000,5; skilleffect 155,0; sc_start SC_LOUD,360000,1; skilleffect 157,0; sc_start SC_ENERGYCOAT,360000,1; sc_start SC_ASPDPOTION2,360000,0; sc_start SC_STRFood,360000,10; sc_start SC_AGIFood,360000,10; sc_start SC_VITFood,360000,10; sc_start SC_INTFood,360000,10; sc_start SC_DEXFood,360000,10; sc_start SC_LUKFood,360000,10; sc_start SC_HitFood,1200000,30; sc_start SC_FleeFood,1200000,30; sc_start SC_BATKFood,1200000,10; sc_start SC_MATKFood,120000,10; skilleffect 380,0; sc_start SC_TRUESIGHT,360000,5; skilleffect 361,0; sc_start SC_ASSUMPTIO,360000,5; close; }
is there a buff that removes full strip status effect? if there is how can i add it there?
i was trying to add GOSPEL but it doesn't work... thank you
dispbottom not correct - Edited Mining Script
in Scripting Support
Posted
Actually, I've solved this following your other comments on a post. Thank you for always helping newbie's like me.
Following other examples I've modified it like this and of course those curly brackets you mentioned: