Clear Inventory Script for MuEngine Files

[Maddox]

who have MuCore Clear Inventory Script for MuEngine Files?

thanks God bless :)

[MentaL]

[2009x2014]

who have MuCore Clear Inventory Script for MuEngine Files?

thanks God bless :)

You use s6 or ex7?

edit varbinary length & test.

[Maddox]

You use s6 or ex7?

edit varbinary length & test.

Season 7

i edit $clear = $core_db->Execute("Update character set [inventory]=CONVERT(varbinary(1080), null) where mu_id=?", array(

to

$clear = $core_db->Execute("Update character set [inventory]=CONVERT(binary(3792), null) where mu_id=?", array(

but its not working it replaced full inventory KRIS.

MuEngine DB use Binary not varbinary.

thanks

[2009x2014]

[inventory]=CONVERT(varbinary(3792), 0x".str_repeat('FF',3792).")

Try it :)

[Maddox]

[inventory]=CONVERT(varbinary(3792), 0x".str_repeat('FF',3792).")

Try it :)

system error friend :)

[2009x2014]

system error friend :)

Character's inventory successfully cleared.

Please don't waste people time when you are lazy to paste something correctly or check you Real varbinary.

[Maddox]

Character's inventory successfully cleared.

Please don't waste people time when you are lazy to paste something correctly or check you Real varbinary.

sorry for disturbing you, how about code to not delete the equipt item in character? only deletes is in inventory not Set,wings etc that wear char?

thanks God bless.

[2009x2014]

sorry for disturbing you, how about code to not delete the equipt item in character? only deletes is in inventory not Set,wings etc that wear char?

thanks God bless.

It's ok

Try
[Inventory] = substring([Inventory],0,192) + CONVERT(varbinary(3600), 0x".str_repeat('FF',3600).")


Where 3600 = (Inventory length - 192)

[Maddox]

It's ok

Try
[Inventory] = substring([Inventory],0,192) + CONVERT(varbinary(3600), 0x".str_repeat('FF',3600).")


Where 3600 = (Inventory length - 192)

\

WOW IT WORKS.

thank for your help friend i appreciate a lot.

God bless you always :)