Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Anti Dupe Script

Experienced Elementalist
Joined
Dec 7, 2006
Messages
250
Reaction score
2
Code:
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.
 
Last edited by a moderator:
Initiate Mage
Joined
Oct 8, 2006
Messages
17
Reaction score
0
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
 
Initiate Mage
Joined
Nov 3, 2007
Messages
38
Reaction score
0
its good but if someone buy a duped item by accident it will ban him?
 
Initiate Mage
Joined
Jul 1, 2008
Messages
42
Reaction score
0
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
 
Junior Spellweaver
Joined
Oct 17, 2007
Messages
132
Reaction score
1
i dont spam you poop and if i want i do it

noob you come from nowhere and telling me im spamming... g2h
 
Experienced Elementalist
Joined
Dec 7, 2006
Messages
250
Reaction score
2
its atleast a script that stops most dupers-.-
 
Initiate Mage
Joined
Jun 3, 2008
Messages
6
Reaction score
0
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.
 
Initiate Mage
Joined
Jul 1, 2008
Messages
42
Reaction score
0
i dont spam you poop 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
 
Experienced Elementalist
Joined
Dec 7, 2006
Messages
250
Reaction score
2
yea well this dupe script is the best we got atm if im right.
 
Initiate Mage
Joined
Jul 19, 2007
Messages
7
Reaction score
0
Re: [Share] Anti Dupe Script

Code:
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
Code:
UPDATE USERDATA SET strItem = Null
WHERE strUserID='(select userid from gokhan)';

if dupe item dedected deleting users item
 
Experienced Elementalist
Joined
Dec 7, 2006
Messages
250
Reaction score
2
Re: [Share] Anti Dupe Script

thats actually a better one, thanks:p
 
Initiate Mage
Joined
Jun 30, 2007
Messages
66
Reaction score
0
Re: [Share] Anti Dupe Script

i think we can run this with the delete item procedure by jonny
sorry cant post its his project :p
nice tho didnt knew that table is for dupers got allready dupe wipe thx to jonny but allways better to add more checks :p
 
Experienced Elementalist
Joined
Dec 7, 2006
Messages
250
Reaction score
2
Re: [Share] Anti Dupe Script

yup thats right:p
 
Junior Spellweaver
Joined
Jun 5, 2006
Messages
133
Reaction score
0
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.
 
Experienced Elementalist
Joined
Dec 7, 2006
Messages
250
Reaction score
2
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:eek:

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

thanks.
 
Initiate Mage
Joined
Jul 19, 2007
Messages
7
Reaction score
0
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
 
Experienced Elementalist
Joined
Dec 7, 2006
Messages
250
Reaction score
2
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
 
Initiate Mage
Joined
May 21, 2007
Messages
81
Reaction score
1
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:
Code:
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. ;)
 
Back
Top