Zulies count to "-"

[blacksnow]

someone buy item from shop, they get zulies "-" ( ex : -1234 ), they were disconnect from the server, if try to relog, they get spaw error "0 sencond left" and kicked out of the game. I hope Dev team can fix it. Thx

[Rifke]

viewtopic.php?f=18&t=196

no?

[lmame]

Or Zuly hack?

[PurpleYouko]

it doesn't need fixing. It's a peice of code specifically designed to prevent players with negative zuly (ie. potential zuly hackers) from entering the game.

If you are sure the player is not a zuly hacker then simply edit his zuly amount in your database. Set it to 1 and he will be fine

[blacksnow]

if 1000 character get "-" zulies, i cant edit all of them .... what should i do ?

[lmame]

Ban them and warn them for a while, they are hackers.

[Rifke]

Line number On/Off | Expand/Contract | Select all

1.  
2. UPDATE characters SET zuly='0' WHERE zuly < 0
3.  

Checks the database, and restores the zuly to zero.

[PurpleYouko]

The trouble with that is that you could well be allowing genuine hackers to get back in.

It is highly unlikely that more than one or two players per week will accidentally go negative. It takes seconds for an admin to fix each one.

I typically go through the database each morning and sort it by zuly amount so that i can see if anyone has gone slightly negative. If they are down to about -10,000 1 just set them back to 1 (zero doesn't work on my server)
Lower than that and i leave them alone. they will need to explain to me how they got that way before I restore them.

[Rifke]

Following script goes through your database, and looks who need to be restored. with a link you can restore them. You'll also see the acountname, so it's easier to track them down.

Line number On/Off | Expand/Contract | Select all

1.  
2. <h1>Potentional Hackers?</h1>
3. <?php
4. // Config
5. $MinZulyNegative = -10000;
6. $RestoreZuly = 100000;
7.  
8.     if ( is_numeric($_GET['id']) && isset($_GET['id']) ) {
9.         $UpdateSql = "UPDATE characters ZET zuly='".$RestoreZuly."' WHERE id='".$_GET['id']."' ";
10.         $UpdateQry = @mysql_query($UpdateSql);
11.         if ( $UpdateQry  === false ) {
12.             echo 'Table failure'.mysql_error();
13.         } else {
14.             echo 'Successfuly restored.';
15.         }
16.     } else {
17.         echo 'Invalid character ID.';
18.     }
19.    
20.    
21. // run SQL
22.     $GetZSql = "SELECT id,account_name,char_name,zuly FROM characters WHERE zuly < ".$MinZulyNegative."";
23.     $GetZQry = @mysql_query($GetZSql);
24.     if ( $GetZQry  === false ) {
25.         echo 'Table failure'.mysql_error();
26.     } elseif ( mysql_num_rows($GetZQry) == 0 ) {
27.         echo 'You have <b> Zero </b> zulie hackers.<br />';
28.     } else {
29.         echo '<table border="0" cellspacing="2" cellpading="2" style="font-size: 11px;" >';
30.             echo '<tr>';
31.                 echo '<td>Account</td>';
32.                 echo '<td>Char Name</td>';
33.                 echo '<td>Zuly</td>';
34.                 echo '<td>Restore</td>';
35.             echo '</tr>';              
36.         while ( $GetZArr = mysql_fetch_assoc($GetZQry) ) {
37.             echo '<tr>';
38.                 echo '<td>'.$GetZArr['account_name'].'</td>';
39.                 echo '<td>'.$GetZArr['char_name'].'</td>';
40.                 echo '<td>'.$GetZArr['zuly'].'</td>';
41.                 echo '<td>[ <a href="?id='.$GetZArr['id'].'">Restore</a> ]</td>';
42.             echo '</tr>';
43.         }   
44.         echo '</table>';
45.     }
46. ?>
47.  

[blacksnow]

Thx again crashinside, i'll use it