To disable PS 100% so no dupe can be made

[stympy]

1)First of all go to your commonserver.cfg and edit:
;//////////////////////////////////////////////////////////////////////////////
;// Personal Shop, Max Level, Duel Settings
;//////////////////////////////////////////////////////////////////////////////

;Personal Shop Settings
PShopOpen = 0 ;//whether to open store, default opened

2)Now open Sql Enterprise Manager>"Your Server">Databases>MuOnline>Tables
Right click on Character (table), then click on Design Table.
On the table that appears select the button in front of ShopItem line. Right click on it and press delete. Now the ShopItem line should be gone. Save using the save button from top left corner and exit this table.

3)Now righ click on Character (table) again go to All Tasks>Manage Triggers

4)On the new screen that appears select "Fix_PersonalStore" from the drop down box, this trigger should showup:

CREATE TRIGGER [Fix_PersonalStore] ON dbo.[Character]
after Insert
as
Update [Character] set [Character].ShopItem=0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF

From Inserted
Where Inserted.ShopItem<>0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF\
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFF and [Character].accountid=inserted.accountid
and [Character].name=inserted.name

5)Press the delete button and press yes button when it asks.

*NOTE* If u cannot find this trigger then u never had it installed(no problem). Your solution the is just the deletion of the ShopItem table column.

6)Now close all the SQL windows, and be happy that noone can dupe with personal shop anymore

CREDITS:phillips41 - for providing solution/ DukeGr - for warning us

[MentaL]

[Aszmhodeus]

always stympy resolves the problem:P good luck and very nice guide it worked:)

[-=GPRS=-]

After That My Ps Is Work !!!!

[Musee]

theres an error in your code it says ERROR 170: Line 4: Incorrect Syntax near 'FFFFFFFFFFFFFF"

[GiftServer]

can't fix it becuase am not understand
Plz Post Image to fixing

[AdidasS]

thanks bro

[rnbgazeto]

works on 99.62T ?

[$efu_SM]

work on 97d?