Alternative new [Auto Equipment] system (by coupon OR automatic, your choice) :)

hay blacksheep25 or witchymoo
realy copun have bug,s he freez my login screen (for know i use Kara DB , same DB you used witchymoo)

Quote:

---

Originally Posted by longway

hay blacksheep25 or witchymoo
realy copun have bug,s he freez my login screen (for know i use Kara DB , same DB you used witchymoo)

---

I use RevoLand DB released here. and IF we are using same DB you won't get any problem ;)

Try cleaning your char inventory first, clean everything from the SQL, then try login again. Some of items you put in the SP are disabled in your db or media.

^^ can you come T.V and take look in it ? if you have time?

The fastest way to clear character inventory:

Code:

---

USE [SRO_VT_SHARD]
GO
DECLARE @CharID INT = <YourCharIDHere>
DECLARE @TSlots INT = 0
DECLARE @CharSlot INT = 0
SELECT @TSlots = COUNT(Slot) from _Inventory WHERE CharID = @CharID
WHILE @CharSlot <= @TSlots
BEGIN
    EXEC [_STRG_DEL_ITEM_NoTX] 1, @CharID, @CharSlot
    SET @CharSlot = @CharSlot + 1
END

---

Put your char ID there and run it.

ok i will clear my inventory and try and tell if it work or no :blush:

Bro now scroll work but when i tel port nothing get ?

Quote:

---

Originally Posted by longway

ok i will clear my inventory and try and tell if it work or no :blush:

not work dud

---

Then delete the char, "dud". Your problem isn't unique one but since you don't understand it (based on your other posts in other threads I read), I can no longer help you beyond this point. good luck.

Quote:

---

Originally Posted by longway

ok i will clear my inventory and try and tell if it work or no :blush:

Bro now scroll work but when i tel port nothing get ?

---

Code:

---

EXEC [_ADD_AUTOEQUIP_GEAR], 'charname', 7

---

See what you get.

Code:

---

EXEC [_ADD_AUTOEQUIP_GEAR], 'charname', 7

---

See what you get.[/QUOTE]

Msg 105, Level 15, State 1, Line 1
Unclosed quotation mark after the character string '_ADD_AU
'.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '_ADD_AU
'.

Work now thx i found the error ^^

witchymoo
can telll me i i need to removed D1 to D3 from Auto Equipment from where ? in _Add_AUTOEQUIP_GEAR

Code:

---

        WHEN @CurLevel < 13 THEN '01'
        WHEN @CurLevel < 21 THEN '02'
        WHEN @CurLevel < 29 THEN '03'

---

Modify _AddLogChar as well:

Code:

---

    -- Character reached certain level
    IF (@Data2 = 37 OR @Data2 = 47 OR @Data2 = 57 OR @Data2 = 69 OR @Data2 = 81)

---

Alright i tried this , and so far the automatic equipment works fine. Haven't had any issues. I haven't tested with every single char tho. But so far so good.

Quote:

---

Originally Posted by P0kemonMast

Alright i tried this , and so far the automatic equipment works fine. Haven't had any issues. I haven't tested with every single char tho. But so far so good.

---

You can test on every single race and equip by giving those char Coupon instead of waiting them to level up :)

Good job Witchy Moo.

Seems like you know what your doing, however this thing is slow as fuck.. I mean.. really slow.
Why do you do this via codenames?

The whole thing can be done in less than 100 lines and without using 150 variables.
I won't give you the whole code, but let me tell you what i mean.

You get the gender and check for EU/CH
You put a while loop for slot 1 to 12 and != 8 first.
Select the id64 and refobjid for each slot (use whileloops intflag)

Select the typeids1-4 for the current equipped items in case id64 is not null.
Load variables (params, refitemids, variances) from a custom made table which has a gender column, basic_level column and a one for EU/CH distinguishment.

You might also add these to refobjcommon.. your choice. However, It's better to make a new properly indexed smaller table for it, due to the fact that you can explicitly allow certain items and disallow others... easier to configure your data that way.

In case that the slot was empty.. simply load top 1 highest id where basic_level <= @level.
You can make a case above somewhere to load the mastery or the charlevel into @level, depending on the race.

Then you make a update _Items if id64 is nto null else make fn add initial equip for slot @intflag

That should be around 60-80 lines.

Hey there

Well, It's actually a good idea, out of 109 slots I can actually limit the whileloop only to 12

however, about item code, i use it so whoever using this SP can only set something simple like "A_RARE" or something, in case they wanna change equips. If I put item codes, they have find the code of corresponding items and put in setting, it's not really that simple for "instant users".

About item detection, I tried to make it as flexible as it can, so either players only wear 1 item it doesn't matter.

Bottomline, it's for simplicity and flexibility to whoever use it. If you have simpler code that can provide same simplicity and flexibility would be nice if you can share.

thank you :)

Soz, I ain't the knight who shares ^^

There is no real dev community left. If you release something, people will use it to make money. They don't share shit and keep opening more and more 'new servers with new systems'.

Rather than that, make things difficult enough so that only experienced people can use it... it shouldn't work outside the box without any 'knowledge'.

As you wish ;)

Anyway, I agree at some part.

not work for me.

when use item

http://i5.upanh.com/2013/1205/04//58248248.4444.png

then,im execute query, wait wait and not complete

http://i6.upanh.com/2013/1205/04//58248249.111.png

but, close SR_Gameserver
http://i7.upanh.com/2013/1205/04//58248250.2222.png

This Query complete

http://i8.upanh.com/2013/1205/04//58248251.3333.png