Trigger to prevent dupe

Quote:

---

Originally Posted by nkerz

when u say "password is incorrect" u mean in game? u r trying to unlock vault?

---

yup!!

when i test it in kundun box, when i put it in the vault the vault will also lock

Do i have to have autoGmGG set to 1 for the users to view the announcements ? I am not sure if they show or no.

This works ? i think not, because the v99, don't use that tables, in the db have, but don't have any information

[]'s

sorry video files not working can any one explain to me how i can add this script plz

go to query analizer and paste the code there for the muonline database, then press paly butonn, and its done.

This script must be runned 1 time only or need to make some schedules tasks for example run script every 5 minutes or something else... ?

this is a script, not a job.. so it will always be runing..

This works, btw have some bugs...
I am trying fix

[]'s

Quote:

---

Originally Posted by navossoc

This works, btw have some bugs...
I am trying fix

[]'s

---

If you have discovered any bugs, please posts them!

Regards from Spain,

ZiKuTa

This script work fine if you have 2 duped items in your werehouse!!!The problem is if you have 1 dupet in werehouse and you give the second one in another player you have 2 items 1 in werehouse and 1 in another persone and script no check it!!!Is it posible to make this script to delete duped items from inventory and werehouse.This will be great and will stop any duper i think!!!Sorry for may bad english
I try to change this lines:
UPDATE inventory SET items=null WHERE accountid=@al_acid
but this not work for me!!!I think that this is the Main problem!!!

Quote:

---

Do i have to have autoGmGG set to 1 for the users to view the announcements ? I am not sure if they show or no.

---

autogmgg works. of course you have to set it to 1. also in the CTxxxx ini file. whatever that is. autogmgg=1. well this table is mainly use for announcement.

actually i made use of this table to make regular interval announcement of whose online bcoz i could not make the SLIDE works like real time announcement. this helps players point out who are online bcoz the server is small of about 100 accnts.

so does it prevent duping [chaos-goblin] in 99b?

im lost..i ran it..and picked up nothing...so im not sure if its working or not..

//shang

well.. this work for 97d version? i have too duper on my server... i like this script erase itens after dupe... (original and dupped item) and don't block the account.... its possible?

i have the problem in Warehouse, the Warehouse always lock and the itens converts to exc kris, and i cant unlock the valut, i have to delete the account and create another, but the problem occorues again.......

what can i do to correcty this....

once runned how cna this script be stopped ?

i got error!! people cant conect to my server after i use the scrip so i need help!!

once runned how can this script be stopped ????

plz answerme faster i need put on my server!

plz help me
i need stop the triger

this is the code i use and now people cant conect to my server

pla help!!!

maybe all char in your server have dupe lol :P
make a subserver if you have 99b version and put the chaos goblin in the subserver disable the trade and remove all vaults.(in subserver)

i need a really solution for prevent dupe....
i try test and trigger not work....

please somebody send for me....

thanks....

how can i stop the scrip noone can connet to the server, even me .
any ideas?

thx

you are god in mu :):):):) thx for guide

Quote:

---

Originally Posted by john_d

Ok here my code im using... this simplier than the once above.. it is simple if it detects a duping.. it will lock the vault.. u can also add more to this query if u want.
and to check daily who got caught..
just do this query
select * from copylog;

---

sorry, but im very confused with this trigger i dun know where i need to copy and paste the trigger, my server is small and i have people that are duping can you help me please

wtf many of you say that the fuken scrip works how come for me and other here the scrip dont let no one connect , and so far no one that say that the scrip works come to a explanation why in some cases dont???
thers somthing wrong on this scrip for sure,
i fuked my database for 2 times trying this scrip. the idea of this and others forums is hellp the ones that dont know how to work this shit out.
can some one plz try to find the reason why after run the scrip , noone can connect to the server.
i'v got my server full of dupers and i'm geting realy pisstoff.


helllllllppppppppppp plzzzz.

here the problem is in the line 2
dbo.character !

how to kick & ban the one who uses dupe bug?
what i need to add into script?