Anti Dupe Script

[HellFire]

UPDATE USERDATA SET Authority='255' 
WHERE strUserID='(select userid from gokhan)';

only works if ur base is piskod db or if you have the table gokhan.
put it in any procedure like Account_Login.

why gokhan?:
if someone dupes, the server inserts the value into the table gokhan.
this script basically checks if an userid is in gokhan and bans the character.

 

[bulldog0246]

thanks

im getting the error incorrect syntax from userid

so its trying to check for collumn userid out of userdata instead of gokhan
atleast i think

 

[HellFire]

thanks, fixed!

 

[Dakino]

its good but if someone buy a duped item by accident it will ban him?

 

[Lagalos]

there is no accidents in dupe

 

[dlbert2000]

there is no accidents in dupe

wow do you just spam forums all day :scratch:
i haven't seen even 1 usefull post from you since i've been here...

if someone dupes a ROC and trades it to a legit person for a legiit ROL, the legit person gets banned for having a duped item.
any duper could easily log in, dupe a full a set of +9 armors/weapons, +3 uniques, and nothing happen to them.


Yes ceelen, this would ban people who have duped items, but it would ban legit people too.
Only anti-dupe script that would work, would be one that runs on players that are already in-game, actively scanning their items

 

[Lagalos]

i dont spam you **** and if i want i do it

noob you come from nowhere and telling me im spamming... g2h

 

[HellFire]

its atleast a script that stops most dupers-.-

 

[xestra]

its atleast a script that stops most dupers-.-

Well the Gokhan table for most servers aint really working to 100%
So your script will ban alot of innocent people, like say you got 100 players and 50 dupes, if the other 50 buys a dupe without knowing it .. yeah u get my point u take to big of a chance by implanting this script.

 

[dlbert2000]

i dont spam you **** and if i want i do it

noob you come from nowhere and telling me im spamming... g2h

way to contradict yourself

I cam from nowhere? just because i registered this month doesn't mean i haven't been on ragezone before.

it doesn't take a genious to recognize a forum troll.


back on topic, ceelen smart dupers would never get caught using this. if they take 1 shell+7, dupe it 7 times, make 1 +8 and delete the rest, the server will see that player as legit

 

[HellFire]

yea well this dupe script is the best we got atm if im right.

 

[ozanbilcen]

Re: [Share] Anti Dupe Script

UPDATE USERDATA SET Authority='255' 
WHERE strUserID='(select userid from gokhan)';

only works if ur base is piskod db or if you have the table gokhan.
put it in any procedure like Account_Login.

why gokhan?:
if someone dupes, the server inserts the value into the table gokhan.
this script basically checks if an userid is in gokhan and bans the character.

change

UPDATE USERDATA SET strItem = Null
WHERE strUserID='(select userid from gokhan)';

if dupe item dedected deleting users item

 

[HellFire]

Re: [Share] Anti Dupe Script

thats actually a better one, thanks

 

[mamaorha]

Re: [Share] Anti Dupe Script

i think we can run this with the delete item procedure by jonny
sorry cant post its his project
nice tho didnt knew that table is for dupers got allready dupe wipe thx to jonny but allways better to add more checks

 

[HellFire]

Re: [Share] Anti Dupe Script

yup thats right

 

[spamman]

Re: [Share] Anti Dupe Script

this method won't work. I've already tried it. If some1 trades an item, it's picked up as a dupe by this. It's retarded. Better off doing an offline wipe.

 

[HellFire]

Re: [Share] Anti Dupe Script

srry for bumping this thread, but:

anyone got a up-to-date dupe procedure/script?
i know equalled got one, but he wont gimme

his script actualy prevents the user from accesing their account, if dupe is detected.

thanks.

 

[ozanbilcen]

Re: [Share] Anti Dupe Script

1)

create procedure DupeDelete
as
UPDATE USERDATA SET strItem = Null
WHERE strUserID=(select userid from gokhan)
go

2)

open Load_User_Data and Paste:

exec DupeDelete

 

[HellFire]

Re: [Share] Anti Dupe Script

the thing is, it doesnt selecr the userid from gokhan. i tryed it-.- hence to what i mean with up-to-date

 

[IceMan1300]

Re: [Share] Anti Dupe Script

the thing is, it doesnt selecr the userid from gokhan. i tryed it-.- hence to what i mean with up-to-date

Are we all freaking copy+paste idiots here?

This was posted a longggggg time ago, by someone who is an idiot.

The proper query is:

DECLARE @strUserId varchar(21)

DECLARE myCursor CURSOR
FOR
       SELECT strUserId FROM GOKHAN
       OPEN myCursor

       FETCH NEXT FROM myCursor INTO @strUserID
       WHILE @@FETCH_STATUS = 0
       BEGIN
             UPDATE USERDATA SET Authority = 255 WHERE strUserId = @strUserId
             FETCH NEXT FROM myCursor INTO @strUserID
       END

CLOSE myCursor
DEALLOCATE myCursor

Meh, what the FIRST post is doing is banning the player "SELECTstrUserId FROM GOKHAN".
Without the single quotes, the query still isn't structured properly.

Think about it logically.
You wouldn't be iterating through the whole table.

Not to mention that MSSQL won't let you return multiple values where only one is needed.