A Project for Chronicle 4 based on L2JServer.


    problems with over enchant, visual bug...

    Share
    avatar
    jamaica

    Posts : 135
    Join date : 2013-02-24
    Age : 28
    Location : Romania

    problems with over enchant, visual bug...

    Post  jamaica on 27th July 2013, 09:49

    as the tittle say, i have banned alot of players cause when i have check them it shows that they have in warehouse items over 40k enchanted so i have turned server only for gms and i log into theyr accounts , they has nothing only normal items , nothing over enchant, and now idk if is client visual bug or server bug....
    avatar
    DnR
    Admin
    Admin

    Posts : 1027
    Join date : 2012-12-03

    Re: problems with over enchant, visual bug...

    Post  DnR on 27th July 2013, 12:15

    jamaica wrote:as the tittle say, i have banned alot of players cause when i have check them it shows that they have in warehouse items over 40k enchanted so i have turned server only for gms and i log into theyr accounts , they has nothing only normal items , nothing over enchant, and now idk if is client visual bug or server bug....

    Packet worked fine for me while doing tests.
    It could occur due to specific conditions, so i want you to post screenshots of a wh where the player had 40k enchanted items, just as you said.
    I' ll be back soon (for few days). Then, i' ll be able to test and fix this.

    G-hamsteR

    Posts : 60
    Join date : 2013-04-26

    Re: problems with over enchant, visual bug...

    Post  G-hamsteR on 27th July 2013, 18:05

    This is a bug and it appears in just a few players. I was stunned at first too, but there is no problem. Just ignore them.

    roko91

    Posts : 238
    Join date : 2013-01-30
    Age : 26
    Location : Bulgaria

    Re: problems with over enchant, visual bug...

    Post  roko91 on 27th July 2013, 19:44

    Don't look in the game... to avoid such problems use some MySQL management program like Navicat -> open you DB -> open "items" table -> sort by "enchant_level". That way you will get clear view of what is over enchanted if any. Be aware that if anyone has pet for example lvl 50 it will shows that the item which calls the pet (e.g. item id: 3500 "Dragonflute of Wind") will have "enchant_level" 50 as well (which is normal don't have to worry about it) Smile

    G-hamsteR

    Posts : 60
    Join date : 2013-04-26

    Re: problems with over enchant, visual bug...

    Post  G-hamsteR on 2nd August 2013, 16:56

    Here is a code I just came in with using PHP. Just create a PHP file with whatever name you want and paste this code. You only need to edit the configs at the beginning:

    Code:
    <?php
    //Configs
     $dbhost="localhost"; //Host/IP from the MySQL Database
     $dbname="hor";    //Name of Database (in many times it is 'l2jdb')
     $dbuser="root";      //Username to the MySQL Database
     $dbpass="";          //Passwort to the MySQL Database
    //End of configs

    @$player = $_GET['player'];
    if(!@$player)
    { ?>
    <form action="" method="GET">Player: <input type="text" name="player"> <input type="submit" value="Check Inventory"></form>
    <?php
    }
    else
    {
    $sql2=MYSQL_CONNECT($dbhost,$dbuser,$dbpass) or die ("can't connect to database.");
    MYSQL_SELECT_DB($dbname) or die ("Database dont exists");
    $sql = mysql_query("SELECT * FROM characters WHERE char_name = '$player'") or die(mysql_error());
    $pla = mysql_num_rows($sql);
    if($pla <> 0) {
    echo "<h2>".$player."'s Inventory:</h2>
     <p>";
    while($row = mysql_fetch_array($sql))
      {
      $owner=$row['obj_Id'];
     
     }
     $armors="";
     $weapons="";
     $items="";
     $sql2 = mysql_query("SELECT * FROM items WHERE owner_id = '$owner'") or die(mysql_error());
    while($row2 = mysql_fetch_array($sql2))
      {
     $itemid=$row2['item_id'];
     $enchant=$row2['enchant_level'];
     if($enchant == 0) { $enchant = ''; }
     else { $enchant = '<font color=red>+'.$enchant.' </font>'; }
     $count=$row2['count'];
     if($count == 1) { $count = ''; }
     else { $count = ' <font color=green>(x'.$count.')</font>'; }
     //armors
     $sql3 = mysql_query("SELECT * FROM armor WHERE item_id = '$itemid'") or die(mysql_error());
     $total = mysql_num_rows($sql3);
     if($total > 0) { $itemtype='armor'; }
     
     $sql3 = mysql_query("SELECT * FROM armor WHERE item_id = '$itemid'") or die(mysql_error());
     $total = mysql_num_rows($sql3);
     if($total > 0) { $itemtype='armor'; }
     $sql3 = mysql_query("SELECT * FROM weapon WHERE item_id = '$itemid'") or die(mysql_error());
     $total = mysql_num_rows($sql3);
     if($total > 0) { $itemtype='weapon'; }
     $sql3 = mysql_query("SELECT * FROM etcitem WHERE item_id = '$itemid'") or die(mysql_error());
     $total = mysql_num_rows($sql3);
     if($total > 0) { $itemtype='etcitem'; }
     
    //results

     $sql4 = mysql_query("SELECT * FROM $itemtype WHERE item_id = '$itemid'") or die(mysql_error());
      while($row4 = mysql_fetch_array($sql4))
      {
        if($itemtype == 'armor'){ $armors=$enchant.$row4['name'].$count."<br>".$armors; }
       elseif($itemtype == 'weapon'){ $weapons=$enchant.$row4['name'].$count."<br>".$weapons; }
       else { $items=$enchant.$row4['name'].$count."<br>".$items; }
      }
     
     }echo "<b>Armors:</b><br>$armors<br><b>Weapons:</b><br>$weapons<br><b>Other Items:</b><br>$items<br><br><a href = \"javascript:history.back()\">Back</a>";
     }
     else { echo "<h5>Character ".$player." doesn't exist!</h5><p><a href = \"javascript:history.back()\">Back</a></p>"; }
    }
    ?>
    avatar
    DnR
    Admin
    Admin

    Posts : 1027
    Join date : 2012-12-03

    Re: problems with over enchant, visual bug...

    Post  DnR on 15th August 2013, 17:14

    It' s more wise not to check players' warehouse just by using this packet.
    It' s defective by all means.
    I suggest you check database for such things, so as to avoid accidents.

    Sponsored content

    Re: problems with over enchant, visual bug...

    Post  Sponsored content


      Current date/time is 18th December 2017, 05:20