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

Printable View

Show 100 post(s) from this thread on one page

24-12-13
concucu021

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

help me!

Sword, Blade, Staff, Darkstaff not working . when i try to use COUPON my loading screen freezes
28-12-13
B1QB0SS

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

Quote:

Originally Posted by concucu021

help me!

Sword, Blade, Staff, Darkstaff not working . when i try to use COUPON my loading screen freezes

me too
28-12-13
BadFist

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

Same...
29-12-13
skerdikas

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

if ya using auto w/o scroll this will work with scroll too if will give items when ya are like between 21-28 or such
Replace

to
IF @data2 LIKE 13 OR @data2 LIKE 21 OR @data2 LIKE 29 OR @data2 LIKE 37 OR @data2 LIKE 47 OR @data2 LIKE 57 OR @data2 LIKE 69 OR @data2 LIKE 81)

wont explain all shitz
29-12-13
Witchy Moo

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

Quote:

Originally Posted by concucu021

help me!

Sword, Blade, Staff, Darkstaff not working . when i try to use COUPON my loading screen freezes

Your Media and database is NOT sync'ed.

- - - Updated - - -

Quote:

Originally Posted by B1QB0SS

me too

See previous answer.

- - - Updated - - -

Quote:

Originally Posted by BadFist

Same...

Again, see previous answer.
30-12-13
concucu021

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

no, its sync'ed.

if exec [SRO_VT_SHARD].[dbo].[_ADD_AUTOEQUIP_GEAR] charname, 10 and relog, full working

if use ITEM_EVENT_AUTOEQUIP_COUPON , my loading screen freezes
02-01-14
MaDenGo

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

Same problem concucu021 if exec the query it working normally

but via scroll it freezing loading screen and shardmanager give dump and solutions ?

Regards ;)
04-01-14
MaDenGo

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

i tested everything but i failed almost only working when i execute this manually

Code:

EXEC _ADD_AUTOEQUIP_GEAR 'Char_Name', 7

with all degree
but via coupon not working :( freezing loading screen and i have to Restart GS to fix it
and i don't think this problem about enable or disabled item on RefObjCommon because it working via executing the query so what different between both
Help us if you got info ;)

Regards
08-01-14
mazazekoo

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

Same Shit here .
09-01-14
Witchy Moo

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

Seems you guys having problem with the teleporting scroll.

Since the SP works fine, let's make another item (return-scroll based) apart of this auto-equipment coupon.

Let's take example by giving out 1 item with the scroll, say... 'ITEM_CH_SWORD_08_C' (D8 chinese sword Sun)

And important thing is, you don't need to alter your _AddTimedJob or any other SP in your database, what you're going to make has nothing to do with those, only _AddLogItem needed.

Let's go 1 by 1

*) _RefObjCommon and _RefObjItem (Change the ID and link ID to match your database)

Spoiler:

Code:

INSERT INTO _RefObjCommon VALUES (1, 46457, 'ITEM_SCROLL_TEST', 'xxx', 'xxx', 'SN_ITEM_SCROLL_TEST', 'SN_ITEM_SCROLL_TEST_TT_DESC', 1, 0, 3, 3, 3, 1, 180000, 3, 0, 1, 1, 1, 255, 0, 1, 0, 0, 129, 0, 0, 0, 0, 0, 0, 0, 1, 120, -1, 0, -1, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 'xxx', 'item\etc\drop_mall_scroll.bsr', 'item\etc\talisman.ddj', 'xxx', 'xxx', 23917) INSERT INTO _RefObjItem VALUES (23917, 1, 2, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5000, '????', 1, '??????', -1, 'RESURRECT', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx', 0, 0, 0)

Done.

*) _AddLogItem SP (LOG database)

NOTE: Do not use multiple "IF (@Operation = 41)" statement, if you already have one in the SP, just slip the new lines inside BEGIN END area.

Add these lines somewhere in the bottom of the SP:

Spoiler:

Code:

IF (@Operation = 41) -- Scroll is used BEGIN DECLARE @CharName VARCHAR(64) IF (@ItemRefID = 46457) -- Your Test scroll BEGIN SELECT @CharName = CharName16 from [SRO_VT_SHARD].[dbo].[_Char] WHERE CharID = @CharID EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName, 'ITEM_CH_SWORD_08_C', 1, 0 END END

Run the SP. Done.

Database side done. Restart your game server.

*) Media side (use tab delimiter, not sure why RG converted tabs into spaces )

itemdata_45000.txt

Spoiler:

Code:

1 46457 ITEM_SCROLL_TEST xxx xxx SN_ITEM_SCROLL_TEST SN_ITEM_SCROLL_TEST_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 129 0 0 0 0 0 0 0 1 120 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\talisman.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0

textdata_object.txt

Spoiler:

Code:

1 SN_ITEM_SCROLL_TEST 0 0 0 0 0 0 0 Test Scroll 0 0 0 0 0 0 0 1 SN_ITEM_SCROLL_TEST_TT_DESC 0 0 0 0 0 0 0 <sml2>Description here How To Use: Another description here.</sml2> 0 0 0 0 0 0 0

Import media, done.

*) Test it

good luck
09-01-14
adminsxza

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

AQ_CharDataSaver::DB Query Error(100): UPDATE _ITEMS SET Data=36 WHERE ID64=878124

SR_Gameserver Error
09-01-14
Witchy Moo

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

Quote:

Originally Posted by adminsxza

AQ_CharDataSaver::DB Query Error(100): UPDATE _ITEMS SET Data=36 WHERE ID64=878124

SR_Gameserver Error

another irrelevant matter, go query and check what item is "878124".
09-01-14
turkplaya

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

Nicely done, thanks alot, saved me from doing it completly my own. You should update the _ItemPool too, saves storage.
Thanks to Logs nothin' is impossible, right? :8:
09-01-14
adminsxza

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

Quote:

Originally Posted by Witchy Moo

another irrelevant matter, go query and check what item is "878124".

yes iknoiw but i get alot of this error when use scroll or automatic change your Equipment.
10-01-14
turkplaya

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

Definetly not an issue of this Stored Procedure. If you got alot of those errors, your DB is messed up.

Show 100 post(s) from this thread on one page