[IMPORTANT REQUEST] Avoid Duping

[Danco1990]

Hello fellow dev's,

It has come to my attention that there are a few dupers on our servers. A few of you already found a way how to avoid the whole duping. My question is, how did you do it? What should we change or add to avoid the whole duping? It ruins most of the server's economies, and is therefore considered as the biggest exploit so far. People with custom stats are considered easy when i look at this, since they can be IP banned and cannot login anymore then. But dupers can sell duped gear, items, weapons, whatever they feel like selling. This way they make alot of money, taking alot of money from the economy, and when they are banned, they go with alot of gold from other people...

Hope someone understands and feels like sharing, since this can damage ANY server in the future.

[SiggyMaker]

I didn't do it.

I'd say best way is to lookout to the database or something, if a item gets duped there will be 2 items of same ID and each item has its own ID.

Also it really somehow... fixes the economy, lowers prices lol and ppl get what they want. But yeah. Illegal.

[Bаne]

having a GM 24/7 watch the AH...........

@siggymaker.

tell that to the OS dupers

[AriezOMG]

This has already caused me to wipe, and have to keep daily backups. Enough said.

[il.mane]

the soution should come pretty easy if you do a weekly maint

credits to ProfNerwosol.

In addition of that i whould advice you to make a script (php or SQL). I whould check the ItemsIDs, which they should be unique, in correlation with the UserUID, if u find more that one item with the same ID, 'boom' you will have the duped item/s and the owner.

[Danco1990]

The weekly maint is already here, we have a maintenance every wednsday. The problem is though, in the timespan that we do not reset the server, the dupers can exploit other players, sell stuff, and poof, its gone after the maint, this will only make the dupers more rich, and the normal players poor. This is not good for the economy in my eyes, i want to block this matter permanent.

[NocturnalSniper]

Danco set the server if you disconnect with having a market open it blocked the account until it could be checked by an admin.

Then check the database if one of there item ID's match one sold the were duped. the database keeps track of all items sold through markets.

This should block most players from duping.

[Danco1990]

This would cause alot of work tho when people DC when having open a market. I used this quiry to find duplicate itemuid's:

/*Dupe find script by Danco1990
Shaiya Nemesis


SELECT ItemUID,
COUNT(ItemUID) AS Dupenumber
FROM PS_GameData.dbo.CharItems
GROUP BY ItemUID
HAVING ( COUNT(Itemuid) > 1 )

But the problem is that i only see items not worth duplicating. For example low level gear etc, whereas from accusations there would be several weapons duped, which i cannot track. Therefore i don't exactly know where to look in the first place. I thought the ItemUID was the unique value.

If you use any of my quiries, please do not remove the /* *** */ part, these are my credits..

[NocturnalSniper]

problem is main item duped on servers is stacks of gold bars sell them and rebuy and they have a different ItemUID.

Possum fixed this by lowering gold bar value to 10 mil instead of 100 mil and not making them stackable that way the most they could dupe at one time was 10 mil.

And as far as i have seen the dupers i have caught usually don't do it in the AH they go somewhere they can't be seen. i have caught several behind the castle and outside the city walls in Apu.

[Danco1990]

There must be a code injection to change the force logout time to avoid this whole matter.

[Bаne]

ok here is your "fix"

1. make APU and irish a non market place.
2. make it where you cant bet iteams in a dual (or gold)

then leave the bootleggery as the only place where you can use a market (most people wont dupe there because everyone can see it happen lolz)

that will reduce dupeing by alot.

[Progrip909]

ok here is your "fix"

1. make APU and irish a non market place.
2. make it where you cant bet iteams in a dual (or gold)

then leave the bootleggery as the only place where you can use a market (most people wont dupe there because everyone can see it happen lolz)

that will reduce dupeing by alot.

Problem with your theory is... Duping does not require a shop setup. It can be done very easily from just transactions So, you would need to block all transactions/markets from any place a side from AH. Best solution I would think is to randomize the disconnection time from the server if this is possible (Still newbish and studying xD) Like danco said alter the disconnection time but, it couldn't be a set duration or dupers will pick up on the new time.

[il.mane]

The disconnection occure when after a while the packets sent form the client to the server, stop. If theres a possibility to trim the connection from the server to the client, so make log the player instantly, it must be something really deep hardcoded into the server, I belive the checks that the server dose are propably lots, to determinate if a players is really off the game or just badly lagging.

[zarkyxley]

Originally Posted by il.mane

The disconnection occure when after a while the packets sent form the client to the server, stop. If theres a possibility to trim the connection from the server to the client, so make log the player instantly, it must be something really deep hardcoded into the server, I belive the checks that the server dose are propably lots, to determinate if a players is really off the game or just badly lagging.

Me, as an uber laggy player ( sometimes ), i need to agree with this... sometimes it seems that ive lost the connection, google doesnt work, skype is off... but no, it comes back up, and im still in game, pew pewing like nothing else happened.

[il.mane]

here a php script, i know is not the final solution but its an help to speed up to bust the dupers

PHP Code:

<?php

function sql_quote( $value )
{
    if( get_magic_quotes_gpc() )
    {
          $value = stripslashes( $value );
    }
    //check if this function exists
    if( function_exists( "mysql_real_escape_string" ) )
    {
          $value = mysql_real_escape_string( $value );
    }
    //for PHP version < 4.3.0 use addslashes
    else
    {
          $value = addslashes( $value );
    }
    return $value;
}

$IP="YOUR_IP_HERE";
$user="YOUR_USER_HERE";
$pass="YOUR_PASS_HERE";

// Connect to the server
if (!$link = @mssql_connect("$IP","$user","$pass"))
  {
      print "Failed to connect to MSSQL server<br>";
};

// select PS_GameData
if (!@mssql_select_db("PS_GameData",$link))
  {
      print "Failed to select database<br>";
};

// select PS_gamedefs
if (!@mssql_select_db("PS_gamedefs",$link))
  {
      print "Failed to select database<br>";
};


echo "<center>";
print"
<table border=1 cellpadding=5 cellspacing=0>
    <tr>
    <tr>
        <td WIDTH=150><font size=2 face=arial color=red><b>Toon name</b></td>
        <td WIDTH=150><font size=2 face=arial color=red><b>Player acc</b></td>
        <td WIDTH=100><font size=2 face=arial color=red><b>UserUID</b></td>
        <td WIDTH=200><font size=2 face=arial color=red><b>Item name</b></td>
        <td WIDTH=150><font size=2 face=arial color=red><b>Date</b></td>
    </tr>
    </tr>
</table>";

$result3 = mssql_query("SELECT ItemUID, COUNT(ItemUID) AS Dupenumber FROM PS_GameData.dbo.CharItems GROUP BY ItemUID HAVING ( COUNT(Itemuid) > 1 ) ", $link); //Dupe find SQL query by Danco1990
$row3 = mssql_fetch_array($result3);
while ($row3 = mssql_fetch_array($result3)){

    $result = mssql_query("SELECT ItemUID, CharID, ItemID, Maketime FROM [PS_GameData].[dbo].[CharItems] WHERE ItemUID='$row3[0]'", $link);
    $row = mssql_fetch_array($result);

    $result2 = mssql_query("SELECT CharName, UserID, UserUID FROM [PS_GameData].[dbo].[Chars] WHERE CharID='$row[1]'", $link);
    $row2 = mssql_fetch_array($result2);

    $result4 = mssql_query("SELECT ItemName FROM [PS_gamedefs].[dbo].[Items] WHERE ItemID='$row[2]'", $link);
    $row4 = mssql_fetch_array($result4);

    print"
        <table border=1 cellpadding=5 cellspacing=0>
            <tr>
            <tr>
                <td WIDTH=150><font size=2 face=arial>".$row2[0]."</td>
                <td WIDTH=150><font size=2 face=arial>".$row2[1]."</td>
                <td WIDTH=100><font size=2 face=arial>".$row2[2]."</td>
                <td WIDTH=200><font size=2 face=arial>".$row4[0]."</td>
                <td WIDTH=150><font size=2 face=arial>".$row[3]."</td>
            </tr>
            </tr>
    </table>";
    }

echo "</center>";

@mssql_free_result($result);
@mssql_free_result($result2);
@mssql_free_result($result3);
@mssql_free_result($result4);

mssql_close($link);

?>