Mumbles

Configure your MySQL server's root account (or whichever) to match your SQL settings in inter-server.conf and login-server.conf. The settings you highlighted are for the char and map server's login authentication, not your MySQL server.

Yes, and Yommy was also saying that one-time use could easily be bypassed. I was saying that it could still be viable for dual-client checks, since the network connection is reset along with the MAC address. I'd say the safest bet would be to NOT tell your players that MAC address logging is enabled until someone comes up with hardware IDing.

*facepalms*
 
After going over my syntax, I realised that I had misunderstood the usage of checkweight() and was trying to make this check a lot more complicated than it needed to be. checkweight() determines if the items specified would cause you to be overweight or not; I mistakenly presumed it would calculate the weight. The correct method to retrieve the weight of an item would be getiteminfo(<item ID>, 6).
 
The proper check would be this:
if (Weight > 121)  
I didn't want to repeat chunks of code, so I used arrays to shorthand it. Give this a try; I've tested it thoroughly:
prontera,150,150,5  script  Sample#via::sample_npc  998,{  // Loop through items  for (.@i = 0; .@i < getarraysize(.item_id); .@i++)  {    // Check if player has the exact amount of these items and zeny    if (countitem(.item_id[.@i]) < .amount[.@i] || Zeny < .cost)    {      // Error message      mes "[ Divine ]";      mes "I'm sorry, but you don't have the items and zeny required to proceed.";      close;    }  }    // Loop through items  for (.@i = 0; .@i < getarraysize(.item_id); .@i++)  {    // Determine accumulative weight    .@total_weight = .@total_weight + (getiteminfo(.item_id[.@i], 6) * .amount[.@i]);  }    // Check if the player's weight exceeds the items checked for  if (Weight > .@total_weight)  {      mes "[ Divine ]";    mes "Sorry, but you're too heavy to proceed.";    close;  }    // Confirmation dialogue  mes "[ Divine ]";  mes "Ok, alright! You can go in here now!";  next;    // Loop through items  for (.@i = 0; .@i < getarraysize(.item_id); .@i++)  {    // Delete items    delitem .item_id[.@i], .amount[.@i];  }    // Delete Zeny  Zeny -= .cost;    // Warp player  warp "prontera", 154, 285;  close;    OnInit:    // Configuration    setarray .item_id[0],  628,  969,  7019;    setarray .amount[0],   20, 1,   1;    .cost = 50000;    end;    }

1, please don't double post.
2, There are multiple versions out there already, with a quick google search I found this: http://upaste.me/14c191 posted by Euphy on rathena.
3. What happened to the one you asked for August 9th and joseph gave to you?

Open your Windows Firewall and create a new rule. Add an exception for ports 5121, 6121, and 6900 for incoming TCP connections. When you're prompted, choose to allow connections on these ports.

Is your VPS set up to accept incoming connections? If you're running on Windows, you may need to add exceptions to some ports in your firewall.

you can rename your clientinfo.xml to something that is common like 'patch.inf' or something uncommon then use 'account:/patch.inf' as parameter to your patcher then hide this file in your grf...there is no way to attach it to the exe unless you hex or modified it..but this method makes your server info hard to find....however there are many tools to used to determine your server's ip such cmd or any sniffer out there...
 

Would love to see this as a plugin for HPM!

You could use getcharip() for that, then use some structure like this inside of a NPC:
 
// NPC Variables used:// .blockedips$ for storing the blocked IPs;// .ipunblocktime for storing the unblock time at the same index as .blockedips$// WARNING!! Up to 128 IP blocks at a time!//Little config you'll need:set .@blocktime, 60; // Block time (in seconds)set .@ip$, getcharip();if ( .@ip$ != "" ) { set .@array_size, getarraysize(.blockedips$); // Getting the array size for the calculations for ( set .@i, 0; .@i < .@array_size; set .@i, .@i + 1 ) { // Checking and removing timed out blocks and if the player is still blocked while ( .ipunblocktime[.@i] < gettimetick(2) && .@i < .@array_size ) { // Bulk removing timed out blocks if more than one in a row, caring not to go outside of the array deletearray .blockedips$[.@i],1; deletearray .ipunblocktime[.@i],1; set .@array_size, .@array_size - 1; // Correction for the array size } if ( .blockedips$[.@i] == .@ip$ ) { // No need to check if outside the array since these values will be "" and forcefully .@i <= 127. Also no need to check if outdated since it should have been removed before set .@blockedtime, gettimetick(2) - .ipunblocktime[.@i]; // Remaining time in seconds of the block // break; // Uncomment if you don't want the loop to finish checking for timed out blocks after finding the player if it's on the list } } if ( .@blockedtime ) { mes "Oh, your IP is still blocked."; mes "You still can't use me for the next " + .@blockedtime + " seconds."; close; } mes "OK, I'll give you an apple and block you for " + .@blocktime + " seconds."; close2; getitem 512,1; set .blockedips$[.@array_size],.@ip$; set .ipunblocktime[.@array_size], gettimetick(2) + .@blocktime; end;}  
You can modify it the way you want to accomplish your needs.

Every 3 hours the event will start

Give this a try: http://herc.ws/board/topic/2439-utility-homunculus-evolution/

Utility: Homunculus Evolution
As per themon's request: http://herc.ws/board/topic/2426-humonculus-evolver/

Description:
Allows players to evolve their homunculus in exchange for a catalyst and a fee. If the player has a fully evolved homunculus, an option to mutate it into a Homunculus S will be given if the setting is enabled.
 
Please see the configuration settings under the 'OnInit' label to see what you can change. Do NOT modify the homunculus settings unless you have custom IDs/homunculi.
 
This script is optimised solely for Hercules emulators.
 
Download:
https://github.com/datmumbles/Scripts/raw/master/util/homevo.txt

Utility: Homunculus Evolution
As per themon's request: http://herc.ws/board/topic/2426-humonculus-evolver/

Description:
Allows players to evolve their homunculus in exchange for a catalyst and a fee. If the player has a fully evolved homunculus, an option to mutate it into a Homunculus S will be given if the setting is enabled.
 
Please see the configuration settings under the 'OnInit' label to see what you can change. Do NOT modify the homunculus settings unless you have custom IDs/homunculi.
 
This script is optimised solely for Hercules emulators.
 
Download:
https://github.com/datmumbles/Scripts/raw/master/util/homevo.txt

I Tested Via's Pawnshop NPC and it works great!
 
Loving it!
 
if I got some new idea ill try to post again.
 
again thanks for making this VIA

Great Job!!!!! VIA
Thanks for making this script available I hope this can be enjoyed by other players too. cause I know I will.
Via deserve a +10
this is the reason why I switch from Rathena to Hercules because of people like you Via and your quick response to my request.
 
I hope you can Improve my other script cause im just a noob in script making. I just get to try the script and try to understand what it do and make my own npc. some of the script that I made is just from Euphy script. like Keno.txt and Ez2.txt idea from lottery.txt, soulbuff.txt from healer.txt, reserve.txt from resetnpc.txt,  hourlybonus.txt idea from giftnpc.txt, just added some idea on Euphy rpsroulette.txt, this two script is the only script that I think that I made since this is just my training script the chansave.txt and zenytocash.txt
keno.txt
Ez2.txt
SoulBuff.txt
reserve.txt
hourlybonus.txt
rpsroulette.txt
chansave.txt
zenytocash.txt

@themon
I apologise for being blunt, but I'm no scripting god or machine lol. I fulfilled your request for a few reasons:
Nobody else did The script didn't exist anywhere else (to my knowledge) I found the idea intriguing

I'm glad you enjoyed my script enough to want more (it's flattering, honestly), but I'm unable to fulfill such a large quantity of requests at one time. If you would like your other scripts to be reviewed, please post individual requests in the appropriate forums with as much detail as you are able to provide.

@themon
I apologise for being blunt, but I'm no scripting god or machine lol. I fulfilled your request for a few reasons:
Nobody else did The script didn't exist anywhere else (to my knowledge) I found the idea intriguing

I'm glad you enjoyed my script enough to want more (it's flattering, honestly), but I'm unable to fulfill such a large quantity of requests at one time. If you would like your other scripts to be reviewed, please post individual requests in the appropriate forums with as much detail as you are able to provide.

Utility: Pawn Shop
As per themon's request: http://herc.ws/board/topic/2373-new-shop-npc-idea-pawn-shop/

Description:
Allows players to exchange items in their inventory for a percentage of its "fair market value (FMV)".

By default, the formula to determine the FMV is approximately one-third of the item's "buy" price (as if you were purchasing it from an NPC), multiplied by its refine rate* (if it's equipment).

Items "pawned" through this script are available to be reclaimed if the loan (plus interest) are repaid in full within seven days. If a loan expires, the item pawned will be claimed by the NPC and "sold"; the original owner will no longer be able to retrieve it.

Loan rates, interest rates, loan days, and the refine bonus trigger can be modified within the configuration settings under the 'OnInit' label. Please take care to NOT modify the leap year formula under this label.

*The refine multiplier calculates the number of UNSAFE refines, then adds it to the loan total. For example, a Sword with the refine rate of 10 (which has a safety cap of seven) has a multiplier of three; so, if the "Buy" price is 100z, the default loan would be 33z. Multiply that by three, and you get a 99z refine bonus in addition to the original 33z, for a grand total of 132z. Interest is added AFTER the final loan price is determined, so at a rate of 10 percent, it would cost approximately 145z to reclaim the Sword.
 
Download:
https://github.com/datmumbles/Scripts/raw/master/util/pawnshop.txt

Utility: Pawn Shop
As per themon's request: http://herc.ws/board/topic/2373-new-shop-npc-idea-pawn-shop/

Description:
Allows players to exchange items in their inventory for a percentage of its "fair market value (FMV)".

By default, the formula to determine the FMV is approximately one-third of the item's "buy" price (as if you were purchasing it from an NPC), multiplied by its refine rate* (if it's equipment).

Items "pawned" through this script are available to be reclaimed if the loan (plus interest) are repaid in full within seven days. If a loan expires, the item pawned will be claimed by the NPC and "sold"; the original owner will no longer be able to retrieve it.

Loan rates, interest rates, loan days, and the refine bonus trigger can be modified within the configuration settings under the 'OnInit' label. Please take care to NOT modify the leap year formula under this label.

*The refine multiplier calculates the number of UNSAFE refines, then adds it to the loan total. For example, a Sword with the refine rate of 10 (which has a safety cap of seven) has a multiplier of three; so, if the "Buy" price is 100z, the default loan would be 33z. Multiply that by three, and you get a 99z refine bonus in addition to the original 33z, for a grand total of 132z. Interest is added AFTER the final loan price is determined, so at a rate of 10 percent, it would cost approximately 145z to reclaim the Sword.
 
Download:
https://github.com/datmumbles/Scripts/raw/master/util/pawnshop.txt

I will test it soon and report anything odd about it but I am sure it works perfectly~ 

Here's my version of a Pawn Shop based on many of the ideas written in this thread: http://herc.ws/board/topic/2421-utility-pawn-shop/

Utility: Pawn Shop
As per themon's request: http://herc.ws/board/topic/2373-new-shop-npc-idea-pawn-shop/

Description:
Allows players to exchange items in their inventory for a percentage of its "fair market value (FMV)".

By default, the formula to determine the FMV is approximately one-third of the item's "buy" price (as if you were purchasing it from an NPC), multiplied by its refine rate* (if it's equipment).

Items "pawned" through this script are available to be reclaimed if the loan (plus interest) are repaid in full within seven days. If a loan expires, the item pawned will be claimed by the NPC and "sold"; the original owner will no longer be able to retrieve it.

Loan rates, interest rates, loan days, and the refine bonus trigger can be modified within the configuration settings under the 'OnInit' label. Please take care to NOT modify the leap year formula under this label.

*The refine multiplier calculates the number of UNSAFE refines, then adds it to the loan total. For example, a Sword with the refine rate of 10 (which has a safety cap of seven) has a multiplier of three; so, if the "Buy" price is 100z, the default loan would be 33z. Multiply that by three, and you get a 99z refine bonus in addition to the original 33z, for a grand total of 132z. Interest is added AFTER the final loan price is determined, so at a rate of 10 percent, it would cost approximately 145z to reclaim the Sword.
 
Download:
https://github.com/datmumbles/Scripts/raw/master/util/pawnshop.txt

Utility: Variant Mining
As per xienne15's request: http://herc.ws/board/topic/1886-simple-mining/
 
Description:
A simple mining system; allows for interacting players to excavate minerals by "mining" them with special equipment and tools. Minerals disappear and respawn randomly; chance is determined by configuration.
 
Configuration is mostly done in arrays so that settings may be changed with no modifications to the script. Duplicate in additional locations as needed; update the value of '.var_amount' correspondingly.
 
Download:
https://github.com/datmumbles/Scripts/raw/master/util/mining.txt

prontera,150,150,4  script  rentitem#123  100,{//prontera,150,150,4<tab>script<tab>rentitem#123<tab>100mes "Rent cost: " + .rentitemamt + "x " +getitemname(.rentitemid)+ " for one day";  next;  mes "What do you want to rent?";switch ( select ( .menu$ )  ) { // items to rent menu  case 1: callsub OnDeclareDays; // call OnDeclareDays to input days.      callsub OnRentItems,2410,.days; // 2410 is sleipnir's Item ID. only change the item ID.  case 2:  callsub OnDeclareDays; // call OnDeclareDays to input days.      callsub OnRentItems,2629,.days; // 2629 is Megs's Item ID. only change the item ID.  // to add more items add more cases example  // case 3: callsub OnDeclareDays;  //      callsub OnRentItems,2220,.days; // rent hat  // and add its name on .menu$ part at the bottom.  // pretty simple huh. }OnDeclareDays:    mes "How many days do you want to rent it?";    input .days; // input days    if (.days == 0 ) { // 0 is not a valid value.      mes "0 is not a valid value.";      close;    }    return .days;OnRentItems:    if ( countitem ( .rentitemid ) < getarg(1) * .rentitemamt ) { // not enough items      mes " ","Not Enough items","You need "+getarg(1) * .rentitemamt+"x "+getitemname(.rentitemid);      close;    }    delitem .rentitemid, getarg(1) * .rentitemamt; // delete items    rentitem getarg(0), getarg(1) * 86400; // rent an items. 86400 = 1 day in seconds    close;OnInit:  set .rentitemid, 7227; // item id of TCG change to your likings.  set .rentitemamt, 10; // item amount of TCG change to your likings.  set .menu$,"Sleip:Megs"; // to add an item separate the item with ":" without the quotes eg: "Sleip:Megs:HAT"} try?
 
@edit
added some comments.

try this one
- script debuffer -1,{OnInit: setarray .Map$[0], "arug_cas01", "schg_cas01", "schg_cas02"; set .size, getarraysize(.Map$); for ( set .@i, 0; .@i < .size; set .@i, .@i + 1 ) setmapflag .Map$[.@i], mf_loadevent; end; OnPCLoadMapEvent: getmapxy(@map$, @x, @y, 0); while ( .@j < .size ) { if ( @map$ == .Map$[.@j] ) sc_end SC_ALL; set .@j, .@j + 1; } end;}