[Proper SQL syntax]

Hey, so I'm currently, trying to have an item insert somethings into the inventory table of my inventory sql database, but i'm having some issues could someone help me out?

query_sql"INSERT INTO 'equip_count' VALUES='"+(.@equip_count + 1)+"' FROM 'inventory' WHERE 'char_id'='"+getcharid(0)+"' AND 'nameid'='"+getequipid(2)+"'"

The above query, is going to be activated when ever they equip an item. Also, every 10seconds an item is equipped.

I already got the SELECT part down to pull data, but adding info eludes me.

Should I be using the UPDATE command instead? (Not sure if it requires a re-log).

Note - I've been away from scripting for quite a few years now @.@

[bDefRatioAtkRace]

I'm not 100% positive but try changing this:

if( sd->right_weapon.def_ratio_atk_ele & (1<<tstatus->def_ele) ||
 sd->right_weapon.def_ratio_atk_race & (1<<tstatus->race) ||
 sd->right_weapon.def_ratio_atk_race & (1<<(is_boss(target)?RC_BOSS:RC_NONBOSS))
)
 flag.pdef = 1;
if( sd->left_weapon.def_ratio_atk_ele & (1<<tstatus->def_ele) ||
 sd->left_weapon.def_ratio_atk_race & (1<<tstatus->race) ||
 sd->left_weapon.def_ratio_atk_race & (1<<(is_boss(target)?RC_BOSS:RC_NONBOSS))

in battle.c

to this:

if( sd->right_weapon.def_ratio_atk_ele & (1<<tstatus->def_ele) ||
 sd->right_weapon.def_ratio_atk_race & ((1<<tstatus->race)/2) ||
 sd->right_weapon.def_ratio_atk_race & ((1<<(is_boss(target)?RC_BOSS:RC_NONBOSS))/2)
)
 flag.pdef = 1;
if( sd->left_weapon.def_ratio_atk_ele & (1<<tstatus->def_ele) ||
 sd->left_weapon.def_ratio_atk_race & ((1<<tstatus->race)/2) ||
 sd->left_weapon.def_ratio_atk_race & ((1<<(is_boss(target)?RC_BOSS:RC_NONBOSS))/2)

Edit: BTW, IcePick does not ignore def, but does more dmg depending on def.

[R> Item Color]

Well, that as it may be, the client also supports those other colors. I've checked repeatedly on where in the src does this tell the client to show items as a different color. But my understanding of C is VERY limited, though it should still be possible. For instance isn't there a way to send a packet to the client telling it to display this color? Because, lets face it, if RO didn't have item-name colors, and you were to have created your account-bound items, they'd display as normal black. So, somewhere in that diff, is a line of text that must have told the client to display the item as if, it had 3extra cards in it.

[R> Item Color]

What I'm requesting i a modification of the getitem & getitem2 commands as well as @item & @item2 commands (Atcommands not nessecairy but would be beneficial).

Basically a modification so that we are able to manually set the color of an item-name as if they were compounded with extra cards.

e.g - 4 Cards compounded into a CottonShirt[0] = Purple Name.

Requested Modifications -

getitem <item ID/Name>,<Amount>,<Type>{,<Account ID>};

getitem2 <item ID/Name>,<Amount>,<Type>,<Identify>,<Refine>,<Attribute>,<Card1>,<Card2>,<Card3>,<Card4>{,<Account ID>};

@item <item ID/Name>,<Amount>,<Type>;

@item2 <item ID/Name>,<Amount>,<Type>,<Identify>,<Refine>,<Attribute>,<Card1>,<Card2>,<Card3>,<Card4>;

Type: 0 = Black (Default) | 1 = Green | 2 = Blue | 3 = Gold | 4 = Purple

These colors are not randomly imagined, but already exist in game. Such as rental items, and when items are over compounded with cards.

Rental Items = Blue Names (if i remember correctly).

1 Card Over Compounded = Green Name

2 Card Over Compounded = Blue Name

3 Card Over Compounded = Gold Name

4 Card Over Compounded = Purple Name

[Instant Shadow Jump]

I think he means remove INVALID_TIMER so that it appears as such.

status_change_end(src, SC_HIDING);

[Item Name Color (Multi Cards vs Enchants)]

Okay, so basically, when you equip more than 1 card to a piece of equipment the item name changes color. Seeing as how both Cards, and those items being used to enchant gear with certain stats, are both type 6, why doesn't the other also change the item name color?

e.g: Armor with 4 Poring Cards = Gold Name.

e.g2: Armor with 1Poring Card & 3 Agi +3 = Regular White Name

So, how would i go about making them agi+3 items, affect name color like cards?

[I'm back, with more to explore.]

It's how I became known lol.

[I'm back, with more to explore.]

Hey, I haven't done this on any forum ever really lol, but I figure w/e.

Some of you may know of me / may be familiar with some of my scripts. While others may have just been playing on servers with them. But I'm here to say, I'm back. I won't be posting / releasing as many scripts as I did in old-eAthena, but I can asure you that the ones I do release, are bigger and better, than ever before. I may have been inactive in the scripting scene, but that doesn't mean I wasn't sitting around some days dreaming of new things to add to RO servers. Heres just a list of things I've thought of, and have somewhat written in both script and src.

Crafting System - You can release it before me, but the one I plan to, will allow for much more than you could be thinking.

Enchanting / Upgrading System - Yea, RO has their own, but this one is specifially designed for my Crafting System.

Instances - Again, yea RO has them, and me releasing a few more won't be anything new but, there will be more on a wide range, some generic, while some...intense.

Maps - Yea, not quite my area of expertise, and definately not something I'm adept at, I'm more of an amature with the knowledge of how they work. But I plan to release 1-2 for each script. Mainly the Crafting/Enchant & Instances.

Well thats just a sample of things I intend to release to the public. Be seeing you around rAthena.

[WOE Point system]

Castle owner as in, Guild or Guild master?

[Playtime NPC]

OnPCLogin:
iLoop:
sleep2 3600000;
set @playhour,@playhour+1;
dispbottom "You have been playing for "+ @playhour +" hour(s)";
goto iLoop;
end;

There, that should do what you want... its been nearly 4years since i've been active in the scripting community, but I'm starting to come back, bigger and harder than ever, with the release of several advanced scripts, never before seen. So until then, I appologize if its bugged...

Basically, when a player logs on, it will do nothing for exactly 1 hour, after that, it will announce to the player only, that they have been on for X amount of hours, and will repeat the proccess every hour.

[Random Monster Skill]

Alright, since its been nearly 8 Months since, i've even seen, an RO SVN, i'm going to start up my creations once more, but first, i need to request this.

Basically, we all know, Pupa's have a skill that will change them into a creamy after some time. Well, when they cast it. Basically, i need a skill created, that will transform, the casting monster, into a monster randomly based on a lvl range. Also, if having the skill have 5 levels, is too much, i'll just settle for 1 skill, that will randomly transform them into any non-mvp monster.

e.g:

Lvl 1 - Transform Casting monster into a random monster Level 1-20

Lvl 2 - Level 21-40

Lvl 3 - Level 41-60

Lvl 4 - Level 61-80

Lvl 5 - Level 81-100+

I'm pretty sure, this is a src edit, of monster skills, of some sort, if not, please let me know, what section i should post this in, so i can properly do get help. Thank you.