[Equipment Status Effects]

Hi,

I need to know where in src does the code for reading the effect of headgears is located? I'm trying to create another type of equipment but it doesn't show any stats added even if I put 'bonus bAllStats,3;' from the script part.

Thanks in advance

[Single Strip through FCP with Item Required]

bumps~

[Dispel Chance when Enemy has GTB]

Thanks it's working

[Promo Codes NPC]

NVM, I made one myself.

[Single Strip through FCP with Item Required]

bumps~

[Promo Codes NPC]

Well now I understand what's your point.

Thanks, also with SQL I can hook up the codes anywhere in the website.

[Promo Codes NPC]

You can still use string array. and the way you talk is a lil bit arrogant.

How to insert a value on a string array whenever I want to add a new code? and how would I remove it from the array once it has been redeemed?

[Promo Codes NPC]

Not sure why you need to use the SQL, unless you want to keep a log of those codes. You don't have to reload the NPC everytime because it uses temp var that your GM account input.

Geez, your example uses 1 variable for the code, what if I want to add 100 codes with different prizes for EACH code? Got my point?

Table structure would be

code, item id, amount

Once the code has been redeemed, it will be automatically removed from the database.

[Promo Codes NPC]

No need of SQL db tho. Just use following elements:

// CP
input .PromoCode$;
mes "Promo code is set to " + .PromoCode$ + ".";
set .PromoClaimed,0;
close;
// Redeem
input @PromoCode$;
if (@PromoCode$ != .PromoCode$) {
mes "Code not exist!";
close;
}
if (.PromoClaimed == 1) {
mes "Code has redeemed by someone else.";
close;
}
getitem <item id>,<quantity>;
set .PromoClaimed,1;
close;

Did you ever read the whole post? That's exactly what the link I posted does. The reason I want to use SQL is so that I can add codes anytime without having to reload the NPC again or using up variables.

[Promo Codes NPC]

Hi,

I want to request something similar to this one http://rathena.org/b...ional-code-npc/ , but just want to use the promotional codes system.

What I want is just the promotional codes system where the Admin can insert a code and an item that will be given out when the player entered the code.

Let's say for example, Admin talked to the NPC, added code HJ78SD with the prize of 100x TCG Cards. The player that will enter HJ78SD when he tries to redeem the code, he'll get the specific prize.

There will be different prizes for each code, of course to be set by the Admin. 1 code is only redeemable ONCE. So once the code has been redeemed, it will be automatically removed from the database instead of having the status set to 1 like from the link above.

Already made my own.

[Dispel Chance when Enemy has GTB]

not sure whether it work or not , I am not that good at src edit

if(sc && sc->data[sC_SPIRIT] && sc->data[sC_SPIRIT]->val2 == SL_SAGE && status_isimmune(bl) && !tsc->data[sC_HERMODE] && rnd()%100 < 70 || !tsc || !tsc->count || status_isimmune(bl) && tsc && tsc->data[sC_HERMODE] )
break;

Thank you! Hope it works, I'll test it out tomorrow

-----------

Doesn't work, it completely fail the dispell even the enemy has no GTB card on it when the Professor has Soul Link

BUT

When the Professor has no Soul Link, it can dispel the enemy 100% chance even with GTB Card.

[Single Strip through FCP with Item Required]

Hi,

Attached below is a modified codes for the strip skills way back 2008. I think this was made by DZeroX if I'm not mistaken.

Basically what it does is allow the Stalker with Soul Link to strip an enemy's weapon, armor, shield or headgear even the enemy has FCP. It requires 1 "Coat Remover" item to strip. There's still a chance that the strip will fail though and the item will be consumed.

I don't think this will work with the current code so I attached it here and asking someone if they can modify it to be compatible with the current code.

Thank you

stripskill.rar

[Dispel Chance when Enemy has GTB]

if(status_isimmune(bl) || !tsc || !tsc->count)

change to

if((status_isimmune(bl) &&!tsc->data[sC_HERMODE] && rnd()%100 < 30  ) || !tsc || !tsc->count)

How about if the Professor is Soul Linked he can dispell those with GTBs by 30%

[Dispel Chance when Enemy has GTB]

How can I make Professors to be able to dispel enemies wearing GTB with chance, let's say 30% chance to dispel an enemy even though he is wearing GTB.

I checked the SA_DISPELL in skill.c and I think this is where the part where it won't dispel those who has GTB

if(status_isimmune(bl) || !tsc || !tsc->count)
			break;

[My very first Thor patcher design...]

What Thor version are you using? Gonna try that white transparency

[My very first Thor patcher design...]

how did you do that? black as transparency and saved as bmp?

[My very first Thor patcher design...]

what color did you use for transparency?

[Account-Bound Items]

The other feature I like from eAmod is finally in rAthena and is free! Thanks for the share!

[SQL Query Help]

1. stop the login, char, and map servers
   
2. run this first SQL query:
   

   DELETE FROM `guild_member` WHERE `char_id` NOT IN (SELECT `char_id` FROM `guild`);

   
   

3. run this second SQL query:
   

   UPDATE `char` SET `guild_id`=0 WHERE `char_id` NOT IN (SELECT `char_id` FROM `guild_member`);

   
   

Thank you!

[SQL Query Help]

try run this in your SQL....make sure you do backup 1st just in case anything happen...

DELETE FROM `guild` WHERE `name` <> `master` ;

I don't think this is the right query as the guild members are located inside the guild_member table.

Will this query work?

DELETE FROM `guild_member` where position <> 0

[SQL Query Help]

Hi,

I need to remove all members of all the guilds except the guild master of the guilds in my database, how to do it?

It's like wiping all members of the guilds except the guild master to still save the guilds.

[Extra bonuses [without items]]

Is it possible that the bonuses will be given to the members of a certain guild via guild ID?

[Fishing with Levels]

Hi,

Would like to request a Fishing Script that lets players gain fishing experience points and make their fishing level up to max of level 10

Each level will have specific items to get, rarest items can be obtained at level 10 fishing. Of course, the items are random and configurable per level.

Anyone?

[[Linux Problem] rA updates conflicting my custom settings.]

I check first what my current revision is, then check all files that will be affected by the update, back it up, then update. If there's a conflict I use mine-conflict or mine-full then just apply the updates manually.

Or your custom settings isn't that 'huge' re-do it with a fresh svn like what Emistry said

[Mora Village Official NPCs]

bumps~