Search reset_formula for MVCORE

Results 1 to 8 of 8
  1. #1
    Member proenix12 is offline
    MemberRank
    Nov 2013 Join Date
    94Posts

    Search reset_formula for MVCORE

    This is my reset file
    Code:
    <?php$queryString = strtolower($_SERVER['QUERY_STRING']);
    
    
    if (strstr($queryString,"<") OR strstr($queryString,">") OR strstr($queryString,"(") OR strstr($queryString,")") OR
    strstr($queryString,"..") OR
    strstr($queryString,"%") OR
    strstr($queryString,"*") OR
    strstr($queryString,"+") OR
    strstr($queryString,"!") OR
    strstr($queryString,"@")) {
    $loc = $_SERVER['PHP_SELF'];
    $ip = $_SERVER['REMOTE_ADDR'];
    $date = date ("d-m-Y @ h:i:s");
    $lfh = "log.txt";
    $log = fopen ( $lfh,"a+" );
    fputs ($log, "Attack Date: $date | Attacker IP: $ip | QueryString: $loc?=$queryString\n");
    fclose($log);
    echo "This attack has been logged!";
    }
    ?>
    
    
    
    
    <?php if($mvcore['reset_pageMod'] != 'on') { echo'<div class="e_note">For the moment this page is disabled, come back later!</div>'; } ?>
    <?php if($_SESSION['user_login'] != 'ok') { echo'<div class="e_note">Please login to use this page!</div>'; } ?>
    <?php if($mvcore['reset_pageMod'] == 'on') { ?>
    <?php if($_SESSION['user_login'] == 'ok') { ?>
    
    
    <?php
    
    
    //Other Configs
    $mvcore['reset_lvl_reset'] = "yes"; //Reset Character level to 1 ? ( Yes / No )
    //end
    
    
    if($_GET['op3'] != ''){
        
        $character_name = $_GET['op3'];
    
    
    $useracc = $_SESSION['username']; // Get username
    $sys_start = mssql_query("select name,clevel,resets,grand_resets,money,LevelUpPoint,class,Inventory,MapNumber,PkLevel,strength,dexterity,vitality,energy,Leadership,accountid from character where name = '".$character_name."'");
    $drop_info = mssql_fetch_row($sys_start);
    
    
    if($mvcore['reset_lvl_reset'] == 'yes'){ $new_level = '1'; } else { $new_level = $drop_info[1]; };
    
    
    if($mvcore['reset_bonus'] >= '1'){ $new_lvlupp = $mvcore['reset_bonus'] * $drop_info[2] + $mvcore['reset_bonus'] ; } else { $new_lvlupp = '0'; };
    
    
    if($mvcore['reset_back_points'] == 'yes') { $new_lvlupp = $new_lvlupp + $drop_info[10] + $drop_info[11] + $drop_info[12] + $drop_info[13]; } else { $new_lvlupp = $new_lvlupp; };
    
    
    //checking system
    $acc_status = mssql_query("Select ConnectStat from MEMB_STAT where memb___id='".$useracc."'"); $acc_statusx = mssql_fetch_row($acc_status);
    $acc_statusx[0] == 0 ? $useron=1 : $useron=0; //Username
    if($acc_statusx[0] == 1) { echo'<div class="e_note">Character is online, exit game!</div>'; };
    
    
    $drop_info[15] == $useracc ? $usern=1 : $usern=0; //Username
    $drop_info[0] == $character_name ? $name=1 : $name=0; //Name
    $drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
    if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
    
    
    if($mvcore['reset_item_check'] == 'yes') {
    $sqll= mssql_query("declare @items varbinary(1728); 
        set @items = (select [Inventory] from [Character] where [name]='".$drop_info[0]."');
        print @items;");
    $sqll=mssql_get_last_message();
    
    
    $sqlls    = substr($sqll,2);
    $item_check0        = substr($sqlls,(32*0), 32);    //Item 0
    $item_check1        = substr($sqlls,(32*1), 32);    //Item 1
    $item_check2        = substr($sqlls,(32*2), 32);    //Item 2
    $item_check3        = substr($sqlls,(32*3), 32);    //Item 3
    $item_check4        = substr($sqlls,(32*4), 32);    //Item 4
    $item_check5        = substr($sqlls,(32*5), 32);    //Item 5
    $item_check6        = substr($sqlls,(32*6), 32);    //Item 6
    $item_check7        = substr($sqlls,(32*7), 32);    //Item 7
    $item_check8        = substr($sqlls,(32*8), 32);    //Item 8
    $item_check9        = substr($sqlls,(32*9), 32);    //Item 9
    $item_check10        = substr($sqlls,(32*10), 32);    //Item 10
    $item_check11        = substr($sqlls,(32*11), 32);    //Item 11
    
    
    if($item_check0 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check1 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check2 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check3 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check4 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check5 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check6 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check7 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check8 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check9 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check10 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check11 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF') { $items_on_char = 1; } 
    else { echo'<div class="e_note">You can not reset if you have items on character!</div>'; $items_on_char = 0; };
    } else { $items_on_char = 1; };
    
    
        if($useron == '1' && $level == '1' && $zen == '1' && $name == '1' && $usern == '1' && $items_on_char == '1') {
            
            if($mvcore['reset_stats'] == 'yes'){ $run_update = mssql_query("Update character set strength = '25', dexterity = '25', vitality = '25', energy = '25' where name = '".$character_name."'"); }; //Reset Stats
            
            $run_update = mssql_query("Update character set LevelUpPoint = LevelUpPoint + '".$new_lvlupp."', resets = resets + '1', money = money - '".$mvcore['reset_zen']."', clevel = '".$new_level."' where name = '".$character_name."'"); //Update character
            
            
            //Reset Reward
            if($mvcore['reset_rew_cred'] == '1') {
                $run = mssql_query("update ".$mvcore['credits_table']." set ".$mvcore['credits_column']." = ".$mvcore['credits_column']." + '".$mvcore['reset_reward']."' where ".$mvcore['user_column']." ='".$useracc."'"); 
            }
            elseif($mvcore['reset_rew_cred'] == '2') {
                $run = mssql_query("update ".$mvcore['credits_table']." set ".$mvcore['credits2_column']." = ".$mvcore['credits2_column']." + '".$mvcore['reset_reward']."' where ".$mvcore['user_column']." ='".$useracc."'"); 
            };
            //end
            
                    echo'<div class="s_note">Character successfully reseted.</div>';
            
        } else { echo'<div class="e_note">Some requirements are not respected.!</div>'; } ;
    };
    ?>
    
    
    <?php
    
    
    if($mvcore['reset_zen'] >= '1') { $zen_on_off = '<td>Req. Zen</td>'; } else { $zen_on_off = ''; }; //Req. Zen
    if($mvcore['reset_reward'] >= '1') { $reward_on_off = '<td>Reward</td>'; } else { $reward_on_off = ''; }; //Reset Reward
    if($mvcore['reset_bonus'] >= '1'){ $new_lvlupps = '<td>Bonus</td>'; } else { $new_lvlupps = ''; }; //Bonus system
    echo'
        <table class="info-table" cellpadding="0" cellspacing="0">
            <tbody><tr class="header">
                <td>Name</td>
                '.$reward_on_off.'
                '.$zen_on_off.'
                '.$new_lvlupps.'
                <td>Req. Level</td>
                <td>Req. Offline</td>
                <td>Reset</td>
            </tr>
    ';
    
    
    $useracc = $_SESSION['username']; // Get username
    $sys_start = mssql_query("select name,clevel,resets,grand_resets,money,LevelUpPoint,class,Inventory,MapNumber,PkLevel,strength,dexterity,vitality,energy,Leadership,accountid from character where AccountID = '".$useracc."' order by grand_resets desc, resets desc, clevel desc");
    for($i=0;$i < mssql_num_rows($sys_start);++$i) {
    $drop_info = mssql_fetch_row($sys_start);
    
    
    //Static things
    $acc_status = mssql_query("Select ConnectStat from MEMB_STAT where memb___id='".$useracc."'"); $acc_statusx = mssql_fetch_row($acc_status);
    switch ($drop_info[9]) {
        case 0:
            $pk_level="Phonoman";
        break;
        
        case 3:
            $pk_level="Commoner";
        break;
        
        case 6:
            $pk_level="Hero";
        break;
    }
    
    
    switch ($acc_statusx[0]) {
        case 0:
            $is_on_off="<font color='#FE2E2E'>Offline</font>";
        break;
        
        case 1:
            $is_on_off="<font color='#58FA58'>Online</font>";
        break;
    }
    
    
    
    
    //$drop_info[2] - RESETS
    //print "<pre>"; print_r($drop_info); print "</pre>";
    
    
    //checking system
    $drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
    if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
    
    
    $max_resets = 20;
    if($level == '1' && $zen == '1' && $drop_info[2] < $max_resets) {
        $module_ok = '<a href="MVCore_user_cpMVCore_reset_characterMVCore_'.$drop_info[0].'.html" class="input-main"><img src="sys/images/gear.png" width="11px"> <b>Reset</b></a>';
    } else {
        $module_ok = "<font color='red'>".$drop_info[2]." / ".$max_resets."</font>";
    }
    
    
    //Coloring ifs
    if($drop_info[1] >= $mvcore['reset_level']) { $level_color = '#58FA58'; } else { $level_color = '#FE2E2E'; }; // Req. Level Color
    if($drop_info[4] >= $mvcore['reset_zen']) { $zen_color = '#58FA58'; } else { $zen_color = '#FE2E2E'; }; // Req. Zen Color
    
    
    //Extra options
    if($mvcore['reset_reward'] >= '1' && $mvcore['reset_rew_cred'] == '1') { $reward2_on_off = '<td style="padding:0;">'.$mvcore['reset_reward'].' '.$mvcore['money_name1'].'</td>'; }
    elseif($mvcore['reset_reward'] >= '1' && $mvcore['reset_rew_cred'] == '2') { $reward2_on_off = '<td style="padding:0;">'.$mvcore['reset_reward'].' '.$mvcore['money_name2'].'</td>'; } else { $reward2_on_off = ''; }; //Reset Reward
    
    
    if($mvcore['reset_zen'] >= '1') { $zen_on_off = '<td style="padding:0;"><font color="'.$zen_color.'">'.number_format($mvcore['reset_zen'], 0, '', ',').' Zen </font></td>'; } else { $zen_on_off = ''; }; //Req. Zen
    if($mvcore['reset_bonus'] >= '1'){ $new_lvluppss = '<td style="padding:0;">'.$mvcore['reset_bonus'].' LvlUpPoints</td>'; } else { $new_lvluppss = ''; }; //Bonus system
    
    
            echo'
                <tr style="border-collapse: collapse; border-spacing: 0px;">
                    <td style="padding: 6px 3px 6px 3px;"><a href="MVCore_character_viewMVCore_'.$drop_info[0].'.html"><b>'.$drop_info[0].'</b></a></td>
                    '.$reward2_on_off.'
                    '.$zen_on_off.'
                    '.$new_lvluppss.'
                    <td style="padding:0;"><font color="'.$level_color.'">'.$drop_info[1].' / '.$mvcore['reset_level'].'</font></td>
                    <td style="padding:0;">'.$is_on_off.'</td>
                    <td style="padding:0;">'.$module_ok.'</td>
                </tr>
            ';
    };
    ?>
    </table>
    <?php }; ?>
    <?php }; ?>


  2. #2
    Gamma DragonSeth is offline
    MemberRank
    Aug 2011 Join Date
    2,996Posts

    Re: Search reset_formula for MVCORE

    Im confuse on what the problem is here? If its about a reset limit check this thread: http://forum.ragezone.com/f193/mvcor...limit-1087121/

  3. #3
    Member proenix12 is offline
    MemberRank
    Nov 2013 Join Date
    94Posts

    Re: Search reset_formula for MVCORE

    Thx but i have reset limits but i whana to make formula for reset_points like reset 1 = 350 points reset 2 = 700
    This code is not good
    if($useron == '1' && $level == '1' && $zen == '1' && $name == '1' && $usern == '1' && $items_on_char == '1') {

    if($mvcore['reset_stats'] == 'yes'){ $run_update = mssql_query("Update character set strength = '25', dexterity = '25', vitality = '25', energy = '25' where name = '".$character_name."'"); };
    This code would reset users stats and collect 25x4 points if you have 5000 points at time of reset and if $new_lvlupp is set.
    Similarly, you will collect 350 points if you have 5450 points at time of reset.
    How can I delete old stats and update only $_new_lvlupp?
    $_new_lvlupp is the variable for resetting bonus points.



    $run_update = mssql_query("Update character set LevelUpPoint = LevelUpPoint + '".$new_lvlupp."', resets = resets + '1', money = money - '".$mvcore['reset_zen']."', clevel = '".$new_level."' where name = '".$character_name."'"); //Update character
    Last edited by proenix12; 08-03-16 at 02:37 AM.

  4. #4
    if(!caffeine) continue; leorond is offline
    MemberRank
    Jul 2012 Join Date
    Czech RepublicLocation
    491Posts

    Re: Search reset_formula for MVCORE

    I know you find this script as a good solution.

    Do you know what are the <?php and ?> ???

    It's marking the beginning and end of php code.

    Why do you have each condition marked a new code?

    The script is awful!

    Not treated with inputs and outputs!
    I know that is difficult to treat entry into MSSQL if you can not use mysql_real_escape_string is not a problem to create it!

    PHP Code:
    <?php
    function mssql_real_escape_string($data) {
        if ( !isset(
    $data) or empty($data) ) return '';
        if ( 
    is_numeric($data) ) return $data;

        
    $non_displayables = array(
                
    '/%0[0-8bcef]/',            // url encoded 00-08, 11, 12, 14, 15
                
    '/%1[0-9a-f]/',             // url encoded 16-31
                
    '/[\x00-\x08]/',            // 00-08
                
    '/\x0b/',                   // 11
                
    '/\x0c/',                   // 12
                
    '/[\x0e-\x1f]/'             // 14-31
        
    );
        foreach ( 
    $non_displayables as $regex )
            
    $data preg_replace$regex''$data );
            
    $data str_replace("'""''"$data );
            return 
    $data;
    }
    ?>
    If you are looking reset_formula, start there to find a SQL query to which it relates.

    This question will be above the message that everything went well, possibly over a log entry.

    Since the demand upward search for a variable that contains the query.

  5. #5
    Member proenix12 is offline
    MemberRank
    Nov 2013 Join Date
    94Posts

    Re: Search reset_formula for MVCORE

    This script max resets and reset formula reset 1 = 350 reset 2 = 700 ......

    Code:
    <?php
    /////////////////////////////////////////////
    //Edit by georgi.nqgolov@gmail.com          /
    ////////////////////////////////////////////
    $queryString = strtolower($_SERVER['QUERY_STRING']);
    
    if (strstr($queryString,"<") OR strstr($queryString,">") OR strstr($queryString,"(") OR strstr($queryString,")") OR
    strstr($queryString,"..") OR
    strstr($queryString,"%") OR
    strstr($queryString,"*") OR
    strstr($queryString,"+") OR
    strstr($queryString,"!") OR
    strstr($queryString,"@")) {
    $loc = $_SERVER['PHP_SELF'];
    $ip = $_SERVER['REMOTE_ADDR'];
    $date = date ("d-m-Y @ h:i:s");
    $lfh = "log.txt";
    $log = fopen ( $lfh,"a+" );
    fputs ($log, "Attack Date: $date | Attacker IP: $ip | QueryString: $loc?=$queryString\n");
    fclose($log);
    echo "This attack has been logged!";
    }
    ?>
    
    
    <?php if($mvcore['reset_pageMod'] != 'on') { echo'<div class="e_note">For the moment this page is disabled, come back later!</div>'; } ?>
    <?php if($_SESSION['user_login'] != 'ok') { echo'<div class="e_note">Please login to use this page!</div>'; } ?>
    <?php if($mvcore['reset_pageMod'] == 'on') { ?>
    <?php if($_SESSION['user_login'] == 'ok') { ?>
    
    <?php
    
    
     
    //Other Configs
    $mvcore['reset_lvl_reset'] = "yes"; //Reset Character level to 1 ? ( Yes / No )
    //end
    if($_GET['op3'] != ''){
        
        $character_name = $_GET['op3'];
    
    $useracc = $_SESSION['username']; // Get username
    $sys_start = mssql_query("select name,clevel,resets,grand_resets,money,LevelUpPoint,class,Inventory,MapNumber,PkLevel,strength,dexterity,vitality,energy,Leadership,accountid from character where name = '".$character_name."'");
    $drop_info = mssql_fetch_row($sys_start);
    
    if($mvcore['reset_lvl_reset'] == 'yes'){ $new_level = '1'; } else { $new_level = $drop_info[1]; };
    
    if($mvcore['reset_bonus'] >= '1'){ $new_lvlupp = $mvcore['reset_bonus'] * $drop_info[2] + $mvcore['reset_bonus'] ; } else { $new_lvlupp = '0'; };
    
    //Delete this lane
    //if($mvcore['reset_back_points'] == 'yes') { $new_lvlupp = $new_lvlupp + $drop_info[10] + $drop_info[11] + $drop_info[12] + $drop_info[13]; } else { $new_lvlupp = $new_lvlupp; };
    
    
    
    
    //checking system
    $acc_status = mssql_query("Select ConnectStat from MEMB_STAT where memb___id='".$useracc."'"); $acc_statusx = mssql_fetch_row($acc_status);
    $acc_statusx[0] == 0 ? $useron=1 : $useron=0; //Username
    if($acc_statusx[0] == 1) { echo'<div class="e_note">Character is online, exit game!</div>'; };
    
    $drop_info[15] == $useracc ? $usern=1 : $usern=0; //Username
    $drop_info[0] == $character_name ? $name=1 : $name=0; //Name
    $drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
    if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
    
    if($mvcore['reset_item_check'] == 'yes') {
    $sqll= mssql_query("declare @items varbinary(1728); 
        set @items = (select [Inventory] from [Character] where [name]='".$drop_info[0]."');
        print @items;");
    $sqll=mssql_get_last_message();
    
    $sqlls    = substr($sqll,2);
    $item_check0        = substr($sqlls,(32*0), 32);    //Item 0
    $item_check1        = substr($sqlls,(32*1), 32);    //Item 1
    $item_check2        = substr($sqlls,(32*2), 32);    //Item 2
    $item_check3        = substr($sqlls,(32*3), 32);    //Item 3
    $item_check4        = substr($sqlls,(32*4), 32);    //Item 4
    $item_check5        = substr($sqlls,(32*5), 32);    //Item 5
    $item_check6        = substr($sqlls,(32*6), 32);    //Item 6
    $item_check7        = substr($sqlls,(32*7), 32);    //Item 7
    $item_check8        = substr($sqlls,(32*8), 32);    //Item 8
    $item_check9        = substr($sqlls,(32*9), 32);    //Item 9
    $item_check10        = substr($sqlls,(32*10), 32);    //Item 10
    $item_check11        = substr($sqlls,(32*11), 32);    //Item 11
    
    if($item_check0 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check1 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check2 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check3 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check4 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check5 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check6 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check7 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check8 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check9 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check10 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check11 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF') { $items_on_char = 1; } 
    else { echo'<div class="e_note">You can not reset if you have items on character!</div>'; $items_on_char = 0; };
    } else { $items_on_char = 1; };
    
        if($useron == '1' && $level == '1' && $zen == '1' && $name == '1' && $usern == '1' && $items_on_char == '1') {
            
            if($mvcore['reset_stats'] == 'yes'){ $run_update = mssql_query("Update character set strength = '25', dexterity = '25', vitality = '25', energy = '25', Leadership = '25' where name = '".$character_name."'"); }; //Reset Stats
            //LevelUpPoint = LevelUpPoint + '".$new_lvlupp."' delite 'LevelUpPoint +'
            $run_update = mssql_query("Update character set LevelUpPoint = '".$new_lvlupp."', resets = resets + '1', money = money - '".$mvcore['reset_zen']."', clevel = '".$new_level."' where name = '".$character_name."'"); //Update character
            
            
            //Reset Reward
            if($mvcore['reset_rew_cred'] == '1') {
                $run = mssql_query("update ".$mvcore['credits_table']." set ".$mvcore['credits_column']." = ".$mvcore['credits_column']." + '".$mvcore['reset_reward']."' where ".$mvcore['user_column']." ='".$useracc."'"); 
            }
            elseif($mvcore['reset_rew_cred'] == '2') {
                $run = mssql_query("update ".$mvcore['credits_table']." set ".$mvcore['credits2_column']." = ".$mvcore['credits2_column']." + '".$mvcore['reset_reward']."' where ".$mvcore['user_column']." ='".$useracc."'"); 
            };
            //end
            
                    echo'<div class="s_note">Character successfully reseted.</div>';
            
        } else { echo'<div class="e_note">Some requirements are not respected.!</div>'; } ;
    };
    ?>
    
    <?php
    
    if($mvcore['reset_zen'] >= '1') { $zen_on_off = '<td>Req. Zen</td>'; } else { $zen_on_off = ''; }; //Req. Zen
    if($mvcore['reset_reward'] >= '1') { $reward_on_off = '<td>Reward</td>'; } else { $reward_on_off = ''; }; //Reset Reward
    if($mvcore['reset_bonus'] >= '1'){ $new_lvlupps = '<td>Bonus</td>'; } else { $new_lvlupps = ''; }; //Bonus system
    echo'
        <table class="info-table" cellpadding="0" cellspacing="0">
            <tbody><tr class="header">
                <td>Name</td>
                '.$reward_on_off.'
                '.$zen_on_off.'
                '.$new_lvlupps.'
                <td>Req. Level</td>
                <td>Req. Offline</td>
                <td>Reset</td>
            </tr>
    ';
    
    $useracc = $_SESSION['username']; // Get username
    $sys_start = mssql_query("select name,clevel,resets,grand_resets,money,LevelUpPoint,class,Inventory,MapNumber,PkLevel,strength,dexterity,vitality,energy,Leadership,accountid from character where AccountID = '".$useracc."' order by grand_resets desc, resets desc, clevel desc");
    for($i=0;$i < mssql_num_rows($sys_start);++$i) {
    $drop_info = mssql_fetch_row($sys_start);
    
    //Static things
    $acc_status = mssql_query("Select ConnectStat from MEMB_STAT where memb___id='".$useracc."'"); $acc_statusx = mssql_fetch_row($acc_status);
    switch ($drop_info[9]) {
        case 0:
            $pk_level="Phonoman";
        break;
        
        case 3:
            $pk_level="Commoner";
        break;
        
        case 6:
            $pk_level="Hero";
        break;
    }
    
    switch ($acc_statusx[0]) {
        case 0:
            $is_on_off="<font color='#FE2E2E'>Offline</font>";
        break;
        
        case 1:
            $is_on_off="<font color='#58FA58'>Online</font>";
        break;
    }
    
    
    //$drop_info[2] - RESETS;
    //print "<pre>"; print_r($drop_info); print "</pre>";
    
    //checking system
    $drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
    if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
    
    $max_resets = 20;
    if($level == '1' && $zen == '1' && $drop_info[2] < $max_resets) {
        $module_ok = '<a href="MVCore_user_cpMVCore_reset_characterMVCore_'.$drop_info[0].'.html" class="input-main"><img src="sys/images/gear.png" width="11px"> <b>Reset</b></a>';
    } else {
        $module_ok = "<font color='red'>".$drop_info[2]." / ".$max_resets."</font>";
    }
    
    //Coloring ifs
    if($drop_info[1] >= $mvcore['reset_level']) { $level_color = '#58FA58'; } else { $level_color = '#FE2E2E'; }; // Req. Level Color
    if($drop_info[4] >= $mvcore['reset_zen']) { $zen_color = '#58FA58'; } else { $zen_color = '#FE2E2E'; }; // Req. Zen Color
    
    //Extra options
    if($mvcore['reset_reward'] >= '1' && $mvcore['reset_rew_cred'] == '1') { $reward2_on_off = '<td style="padding:0;">'.$mvcore['reset_reward'].' '.$mvcore['money_name1'].'</td>'; }
    elseif($mvcore['reset_reward'] >= '1' && $mvcore['reset_rew_cred'] == '2') { $reward2_on_off = '<td style="padding:0;">'.$mvcore['reset_reward'].' '.$mvcore['money_name2'].'</td>'; } else { $reward2_on_off = ''; }; //Reset Reward
    
    if($mvcore['reset_zen'] >= '1') { $zen_on_off = '<td style="padding:0;"><font color="'.$zen_color.'">'.number_format($mvcore['reset_zen'], 0, '', ',').' Zen </font></td>'; } else { $zen_on_off = ''; }; //Req. Zen
    if($mvcore['reset_bonus'] >= '1'){ $new_lvluppss = '<td style="padding:0;">'.$mvcore['reset_bonus'].'</td>'; } else { $new_lvluppss = ''; }; //Bonus system
    
            echo'
                <tr style="border-collapse: collapse; border-spacing: 0px;">
                    <td style="padding: 6px 3px 6px 3px;"><a href="MVCore_character_viewMVCore_'.$drop_info[0].'.html"><b>'.$drop_info[0].'</b></a></td>
                    '.$reward2_on_off.'
                    '.$zen_on_off.'
                    '.$new_lvluppss.'
                    <td style="padding:0;"><font color="'.$level_color.'">'.$drop_info[1].' / '.$mvcore['reset_level'].'</font></td>
                    <td style="padding:0;">'.$is_on_off.'</td>
                    <td style="padding:0;">'.$module_ok.'</td>
                </tr>
            ';
    };
    ?>
    </table>
    <?php }; ?>
    <?php }; ?>
    - - - Updated - - -

    Grand resets and resets system:
    0 grand_resets = reset 0/20
    1 grand_resets = reset 0/30
    2 grand_resets = reset 0/40
    3 grand_resets = reset 0/50
    4 grand_resets = reset 0/55
    5 grand_resets = reset 0/60

    Code:
    <?php
    /////////////////////////////////////////////
    //Edit by georgi.nqgolov@gmail.com          /
    ////////////////////////////////////////////
    $queryString = strtolower($_SERVER['QUERY_STRING']);
    
    if (strstr($queryString,"<") OR strstr($queryString,">") OR strstr($queryString,"(") OR strstr($queryString,")") OR
    strstr($queryString,"..") OR
    strstr($queryString,"%") OR
    strstr($queryString,"*") OR
    strstr($queryString,"+") OR
    strstr($queryString,"!") OR
    strstr($queryString,"@")) {
    $loc = $_SERVER['PHP_SELF'];
    $ip = $_SERVER['REMOTE_ADDR'];
    $date = date ("d-m-Y @ h:i:s");
    $lfh = "log.txt";
    $log = fopen ( $lfh,"a+" );
    fputs ($log, "Attack Date: $date | Attacker IP: $ip | QueryString: $loc?=$queryString\n");
    fclose($log);
    echo "This attack has been logged!";
    }
    ?>
    
    
    <?php if($mvcore['reset_pageMod'] != 'on') { echo'<div class="e_note">For the moment this page is disabled, come back later!</div>'; } ?>
    <?php if($_SESSION['user_login'] != 'ok') { echo'<div class="e_note">Please login to use this page!</div>'; } ?>
    <?php if($mvcore['reset_pageMod'] == 'on') { ?>
    <?php if($_SESSION['user_login'] == 'ok') { ?>
    
    <?php
    
    
     
    //Other Configs
    $mvcore['reset_lvl_reset'] = "yes"; //Reset Character level to 1 ? ( Yes / No )
    //end
    if($_GET['op3'] != ''){
        
        $character_name = $_GET['op3'];
    
    $useracc = $_SESSION['username']; // Get username
    $sys_start = mssql_query("select name,clevel,resets,grand_resets,money,LevelUpPoint,class,Inventory,MapNumber,PkLevel,strength,dexterity,vitality,energy,Leadership,accountid from character where name = '".$character_name."'");
    $drop_info = mssql_fetch_row($sys_start);
    
    if($mvcore['reset_lvl_reset'] == 'yes'){ $new_level = '1'; } else { $new_level = $drop_info[1]; };
    
    if($mvcore['reset_bonus'] >= '1'){ $new_lvlupp = $mvcore['reset_bonus'] * $drop_info[2] + $mvcore['reset_bonus'] ; } else { $new_lvlupp = '0'; };
    
    //Delete this lane
    //if($mvcore['reset_back_points'] == 'yes') { $new_lvlupp = $new_lvlupp + $drop_info[10] + $drop_info[11] + $drop_info[12] + $drop_info[13]; } else { $new_lvlupp = $new_lvlupp; };
    
    
    
    
    //checking system
    $acc_status = mssql_query("Select ConnectStat from MEMB_STAT where memb___id='".$useracc."'"); $acc_statusx = mssql_fetch_row($acc_status);
    $acc_statusx[0] == 0 ? $useron=1 : $useron=0; //Username
    if($acc_statusx[0] == 1) { echo'<div class="e_note">Character is online, exit game!</div>'; };
    
    $drop_info[15] == $useracc ? $usern=1 : $usern=0; //Username
    $drop_info[0] == $character_name ? $name=1 : $name=0; //Name
    $drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
    if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
    
    if($mvcore['reset_item_check'] == 'yes') {
    $sqll= mssql_query("declare @items varbinary(1728); 
        set @items = (select [Inventory] from [Character] where [name]='".$drop_info[0]."');
        print @items;");
    $sqll=mssql_get_last_message();
    
    $sqlls    = substr($sqll,2);
    $item_check0        = substr($sqlls,(32*0), 32);    //Item 0
    $item_check1        = substr($sqlls,(32*1), 32);    //Item 1
    $item_check2        = substr($sqlls,(32*2), 32);    //Item 2
    $item_check3        = substr($sqlls,(32*3), 32);    //Item 3
    $item_check4        = substr($sqlls,(32*4), 32);    //Item 4
    $item_check5        = substr($sqlls,(32*5), 32);    //Item 5
    $item_check6        = substr($sqlls,(32*6), 32);    //Item 6
    $item_check7        = substr($sqlls,(32*7), 32);    //Item 7
    $item_check8        = substr($sqlls,(32*8), 32);    //Item 8
    $item_check9        = substr($sqlls,(32*9), 32);    //Item 9
    $item_check10        = substr($sqlls,(32*10), 32);    //Item 10
    $item_check11        = substr($sqlls,(32*11), 32);    //Item 11
    
    if($item_check0 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check1 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check2 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check3 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check4 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check5 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check6 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check7 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check8 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check9 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check10 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check11 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF') { $items_on_char = 1; } 
    else { echo'<div class="e_note">You can not reset if you have items on character!</div>'; $items_on_char = 0; };
    } else { $items_on_char = 1; };
    
        if($useron == '1' && $level == '1' && $zen == '1' && $name == '1' && $usern == '1' && $items_on_char == '1') {
            
            if($mvcore['reset_stats'] == 'yes'){ $run_update = mssql_query("Update character set strength = '25', dexterity = '25', vitality = '25', energy = '25', Leadership = '25' where name = '".$character_name."'"); }; //Reset Stats
            //LevelUpPoint = LevelUpPoint + '".$new_lvlupp."' delite 'LevelUpPoint +'
            $run_update = mssql_query("Update character set LevelUpPoint = '".$new_lvlupp."', resets = resets + '1', money = money - '".$mvcore['reset_zen']."', clevel = '".$new_level."' where name = '".$character_name."'"); //Update character
            
            
            //Reset Reward
            if($mvcore['reset_rew_cred'] == '1') {
                $run = mssql_query("update ".$mvcore['credits_table']." set ".$mvcore['credits_column']." = ".$mvcore['credits_column']." + '".$mvcore['reset_reward']."' where ".$mvcore['user_column']." ='".$useracc."'"); 
            }
            elseif($mvcore['reset_rew_cred'] == '2') {
                $run = mssql_query("update ".$mvcore['credits_table']." set ".$mvcore['credits2_column']." = ".$mvcore['credits2_column']." + '".$mvcore['reset_reward']."' where ".$mvcore['user_column']." ='".$useracc."'"); 
            };
            //end
            
                    echo'<div class="s_note">Character successfully reseted.</div>';
            
        } else { echo'<div class="e_note">Some requirements are not respected.!</div>'; } ;
    };
    ?>
    
    <?php
    
    if($mvcore['reset_zen'] >= '1') { $zen_on_off = '<td>Req. Zen</td>'; } else { $zen_on_off = ''; }; //Req. Zen
    if($mvcore['reset_reward'] >= '1') { $reward_on_off = '<td>Reward</td>'; } else { $reward_on_off = ''; }; //Reset Reward
    if($mvcore['reset_bonus'] >= '1'){ $new_lvlupps = '<td>Bonus</td>'; } else { $new_lvlupps = ''; }; //Bonus system
    echo'
        <table class="info-table" cellpadding="0" cellspacing="0">
            <tbody><tr class="header">
                <td>Name</td>
                '.$reward_on_off.'
                '.$zen_on_off.'
                '.$new_lvlupps.'
                <td>Req. Level</td>
                <td>Req. Offline</td>
                <td>Reset</td>
            </tr>
    ';
    
    $useracc = $_SESSION['username']; // Get username
    $sys_start = mssql_query("select name,clevel,resets,grand_resets,money,LevelUpPoint,class,Inventory,MapNumber,PkLevel,strength,dexterity,vitality,energy,Leadership,accountid from character where AccountID = '".$useracc."' order by grand_resets desc, resets desc, clevel desc");
    for($i=0;$i < mssql_num_rows($sys_start);++$i) {
    $drop_info = mssql_fetch_row($sys_start);
    
    //Static things
    $acc_status = mssql_query("Select ConnectStat from MEMB_STAT where memb___id='".$useracc."'"); $acc_statusx = mssql_fetch_row($acc_status);
    switch ($drop_info[9]) {
        case 0:
            $pk_level="Phonoman";
        break;
        
        case 3:
            $pk_level="Commoner";
        break;
        
        case 6:
            $pk_level="Hero";
        break;
    }
    
    switch ($acc_statusx[0]) {
        case 0:
            $is_on_off="<font color='#FE2E2E'>Offline</font>";
        break;
        
        case 1:
            $is_on_off="<font color='#58FA58'>Online</font>";
        break;
    }
    
    
    //$drop_info[2] - RESETS;
    //print "<pre>"; print_r($drop_info); print "</pre>";
    
    //checking system for resets and grand resets
    switch ($drop_info[3]) {
        case $drop_info[3] == 0:
        
        $drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
    if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
    
    $max_resets = 20;
    if($level == '1' && $zen == '1' && $drop_info[2] < $max_resets) {
        $module_ok = '<a href="MVCore_user_cpMVCore_reset_characterMVCore_'.$drop_info[0].'.html" class="input-main"><img src="sys/images/gear.png" width="11px"> <b>Reset</b></a>';
    } else {
        $module_ok = "<font color='red'>".$drop_info[2]." / ".$max_resets."</font>";
    }
    
    
            break;
        case $drop_info[3] == 1:
        
            $drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
    if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
    
    $max_resets = 30;
    if($level == '1' && $zen == '1' && $drop_info[2] < $max_resets) {
        $module_ok = '<a href="MVCore_user_cpMVCore_reset_characterMVCore_'.$drop_info[0].'.html" class="input-main"><img src="sys/images/gear.png" width="11px"> <b>Reset</b></a>';
    } else {
        $module_ok = "<font color='red'>".$drop_info[2]." / ".$max_resets."</font>";
    }
    
        
    
            break;
        case $drop_info[3] == 2:
    
                $drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
    if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
    
    $max_resets = 40;
    if($level == '1' && $zen == '1' && $drop_info[2] < $max_resets) {
        $module_ok = '<a href="MVCore_user_cpMVCore_reset_characterMVCore_'.$drop_info[0].'.html" class="input-main"><img src="sys/images/gear.png" width="11px"> <b>Reset</b></a>';
    } else {
        $module_ok = "<font color='red'>".$drop_info[2]." / ".$max_resets."</font>";
    }
        
        
            break;
            
                case $drop_info[3] == 3:
    
                $drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
    if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
    
    $max_resets = 50;
    if($level == '1' && $zen == '1' && $drop_info[2] < $max_resets) {
        $module_ok = '<a href="MVCore_user_cpMVCore_reset_characterMVCore_'.$drop_info[0].'.html" class="input-main"><img src="sys/images/gear.png" width="11px"> <b>Reset</b></a>';
    } else {
        $module_ok = "<font color='red'>".$drop_info[2]." / ".$max_resets."</font>";
    }
        
        
            break;
            
                case $drop_info[3] == 4:
    
                $drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
    if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
    
    $max_resets = 55;
    if($level == '1' && $zen == '1' && $drop_info[2] < $max_resets) {
        $module_ok = '<a href="MVCore_user_cpMVCore_reset_characterMVCore_'.$drop_info[0].'.html" class="input-main"><img src="sys/images/gear.png" width="11px"> <b>Reset</b></a>';
    } else {
        $module_ok = "<font color='red'>".$drop_info[2]." / ".$max_resets."</font>";
    }
        
        
            break;
            
                case $drop_info[3] == 5:
    
                $drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
    if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
    
    $max_resets = 60;
    if($level == '1' && $zen == '1' && $drop_info[2] < $max_resets) {
        $module_ok = '<a href="MVCore_user_cpMVCore_reset_characterMVCore_'.$drop_info[0].'.html" class="input-main"><img src="sys/images/gear.png" width="11px"> <b>Reset</b></a>';
    } else {
        $module_ok = "<font color='red'>".$drop_info[2]." / ".$max_resets."</font>";
    }
        
        
            break;
        default:
           echo "i is not equal to 0, 1 or 2";
    }
    
    
    //End of cheking system
    
    
    
    //Coloring ifs
    if($drop_info[1] >= $mvcore['reset_level']) { $level_color = '#58FA58'; } else { $level_color = '#FE2E2E'; }; // Req. Level Color
    if($drop_info[4] >= $mvcore['reset_zen']) { $zen_color = '#58FA58'; } else { $zen_color = '#FE2E2E'; }; // Req. Zen Color
    
    //Extra options
    if($mvcore['reset_reward'] >= '1' && $mvcore['reset_rew_cred'] == '1') { $reward2_on_off = '<td style="padding:0;">'.$mvcore['reset_reward'].' '.$mvcore['money_name1'].'</td>'; }
    elseif($mvcore['reset_reward'] >= '1' && $mvcore['reset_rew_cred'] == '2') { $reward2_on_off = '<td style="padding:0;">'.$mvcore['reset_reward'].' '.$mvcore['money_name2'].'</td>'; } else { $reward2_on_off = ''; }; //Reset Reward
    
    if($mvcore['reset_zen'] >= '1') { $zen_on_off = '<td style="padding:0;"><font color="'.$zen_color.'">'.number_format($mvcore['reset_zen'], 0, '', ',').' Zen </font></td>'; } else { $zen_on_off = ''; }; //Req. Zen
    if($mvcore['reset_bonus'] >= '1'){ $new_lvluppss = '<td style="padding:0;">'.$mvcore['reset_bonus'].'</td>'; } else { $new_lvluppss = ''; }; //Bonus system
    
            echo'
                <tr style="border-collapse: collapse; border-spacing: 0px;">
                    <td style="padding: 6px 3px 6px 3px;"><a href="MVCore_character_viewMVCore_'.$drop_info[0].'.html"><b>'.$drop_info[0].'</b></a></td>
                    '.$reward2_on_off.'
                    '.$zen_on_off.'
                    '.$new_lvluppss.'
                    <td style="padding:0;"><font color="'.$level_color.'">'.$drop_info[1].' / '.$mvcore['reset_level'].'</font></td>
                    <td style="padding:0;">'.$is_on_off.'</td>
                    <td style="padding:0;">'.$module_ok.'</td>
                </tr>
            ';
    };
    ?>
    </table>
    <?php }; ?>
    <?php }; ?>

  6. #6
    if(!caffeine) continue; leorond is offline
    MemberRank
    Jul 2012 Join Date
    Czech RepublicLocation
    491Posts

    Re: Search reset_formula for MVCORE

    Do you really believe that you get to different numbers PK?

    PHP Code:
    switch ($drop_info[9]) {
        case 
    0:
            
    $pk_level="Phonoman";
        break;
        
        case 
    3:
            
    $pk_level="Commoner";
        break;
        
        case 
    6:
            
    $pk_level="Hero";
        break;

    You should adjust the display for undefined values!

    PHP Code:
    switch ($drop_info[9]) {
        case 
    0:
            
    $pk_level="Phonoman";
        break;
        
        case 
    3:
            
    $pk_level="Commoner";
        break;
        
        case 
    6:
            
    $pk_level="Hero";
        break;
        default:                      
    // <= Other values
        
    $pk_level    =    unknown;
        break;

    - - - Updated - - -

    Or even better, and do it from the function which you then call.

    PHP Code:
    function    pk_level($drop_info)
    {
        switch (
    $drop_info
        {
            case 
    0:
                
    $pk_level="Phonoman";
            break;
            case 
    3:
                
    $pk_level="Commoner";
            break;
                case 
    6:
                
    $pk_level="Hero";
            break;
            default:                      
    // <= Other values
                
    $pk_level    =    unknown;
            break;
        }
        return    
    $pk_level;

    Listing will be as follows.

    PHP Code:
    <?php
    echo pk_level(intval($drop_info[9]));
    ?>
    Place it in a file .php and throw in index.php and include the main file.

    You do not have to use it after the 10 scripts.

    You can use it on to other things. Accelerate and transparency of this script.
    Last edited by leorond; 08-03-16 at 11:31 PM.

  7. #7
    Member proenix12 is offline
    MemberRank
    Nov 2013 Join Date
    94Posts

    Re: Search reset_formula for MVCORE

    bro this files is not scripted by me i just edit him
    talking about me as if am doing them

    - - - Updated - - -

    Webshop limite items options script
    Code:
    <?php
    error_reporting(E_ALL ^E_NOTICE ^E_WARNING);
    session_start(); 
    ob_start();
    header("Cache-control: private");
    require('sys/functions.inc.php'); //Web Functions
    ob_end_flush();
    ?>
    <?php
    
    if(isset($_POST['hopt'])) {
        if($_POST['hopt'] == 'na') { echo '0'; } else {
            $select_joh_info= mssql_query("Select joh_id, joh_val, joh_cost from wshopp_harmony where joh_name='".$_POST['hopt']."'");
            $check_joh_info = mssql_fetch_row($select_joh_info);
            echo ''.$check_joh_info[2].'';
        }
    exit;
    };
    
    if(isset($_POST['plusone'])) {
        
        $count = $mvcore['dwn_click_count'] + 1;
    
                    $new_db = fopen("sys/dwn_count.php", "w"); //configs patch 
                    $data = "<?\n";
                    $data .="\$mvcore['dwn_click_count'] = \"".$count."\";\n";
                    $data .="?>";
                    fwrite($new_db,$data); fclose($new_db);
    
    };
    
    if(isset($_POST['s_option'])) {
        if($_POST['s_option'] == '254') { echo '0'; } else {
            $select_soc_info= mssql_query("Select sok_id, sok_name, type, sok_cost from wshopp_socket where sok_id='".$_POST['s_option']."'");
            $check_soc_info = mssql_fetch_row($select_soc_info);
            echo ''.$check_soc_info[3].'';
        }
    exit;
    };
    
    
    if(isset($_POST['ancname'])) {
        
        if($_POST['ancname'] == '1') {$anc_type = '5';} else {$anc_type = '10';}
            $select_anc_info= mssql_query("Select top 2 anc_type,anc_name,options,item_id,item_cat from wshopp_ancient where anc_type = '".$anc_type."' and item_id='".$_POST['idss']."' and item_cat='".$_POST['catss']."'");
            $check_anc_info = mssql_fetch_row($select_anc_info);
            echo ''.$check_anc_info[1].'';
        
        
    exit;
    };
    
    
    ?>
    
    <?php if($mvcore['wshop_load'] != 'on') { echo'<div class="e_note">For the moment this page is disabled, come back later!</div>'; } ?>
    <?php if($_SESSION['user_login'] != 'ok') { echo'<div class="e_note">Please login to use this page!</div>'; } ?>
    <?php if($mvcore['wshop_load'] == 'on') { ?>
    <?php
    
    
    //checking all
    
        $link_get = $_GET['linkdata'];
        $item_name = $_GET['name'];
        $item_id = $_GET['ids'];
        $item_cat = $_GET['cat'];
        $item_exc = $_GET['exc'];
        $item_refin = $_GET['refin'];
        $item_sk = $_GET['sk'];
        $item_anc = $_GET['anc'];
        $item_ad = $_GET['ad'];
        $item_skill = $_GET['skill'];
        $item_luck = $_GET['luck'];
        $item_level = $_GET['level'];
        
    $check_item = mssql_query("Select name, cost, cost_zen, pay_type_gc, pay_type_c, pay_type_zen, harmony, bought_times, item_exc_type from wshopp where name='".$item_name."' and cat='".$item_cat."'");
    $check_item_ok = mssql_fetch_row($check_item);
    
    if($mvcore['sockets_parts'] == 'no') { $drop_sockets = 'where type >= 1'; }
    elseif($item_cat >= '0' && $item_cat <= '5' ) { $drop_sockets = 'where type = 1'; }
    elseif($item_cat >= '6' && $item_cat <= '11' ) { $drop_sockets = 'where type = 2'; };
    
    $calc_gold_cost = $check_item_ok[1] + ((- $mvcore['gold_dif'] * $check_item_ok[1]) / 100) ;
    $zen_cost = $check_item_ok[1] * $mvcore['cost_cred_to_zen'];
    
    //allow buy with ?
    if($check_item_ok[3] == '1') { $drop_costshow_gcred = '<div class="item_info"><div class="info">Price <span class="btimes" id="total_credits_g">'.floor($calc_gold_cost).'</span> <span class="goldcr">'.$mvcore['money_name2'].'</span></div></div>'; };
    if($check_item_ok[4] == '1') { $drop_costshow_cred = '<div class="item_info"><div class="info">Price <span class="btimes" id="total_credits">'.$check_item_ok[1].'</span> <span class="normalcr">'.$mvcore['money_name1'].'</span></div></div>'; };
    if($check_item_ok[5] == '1') { $drop_costshow_zen = '<div class="item_info"><div class="info">Price <span class="btimes" id="total_zen">'.$zen_cost.'</span> <span class="normalcr">Zen</span></div></div>'; };
    
    if($check_item_ok[3] == '1') { $drop_cost_gcred = '<button id="gcred" class="buy_button" name="buygoldcred" value="Buy With Gold Credits">'.$mvcore['money_name2'].'</button>'; };
    if($check_item_ok[4] == '1') { $drop_cost_cred = '<button id="tokens" class="buy_button" name="buycred" value="Buy With Tokens">'.$mvcore['money_name1'].'</button>'; };
    if($check_item_ok[5] == '1') { $drop_cost_zen = '<button id="tokens" class="buy_button" name="buyzen" value="Buy With Tokens">Zen</button>'; };
    //end allow buy
                
    //---------------------
    if($item_ad == '1') { // 1 for swords, Axe, Spears, Mace, Scepters, Bows, Crossbows,
    $drop_ad_opt = '
                <div class="opt_title">Additional Damage:</div>
                <div class="opt">
                    <select id="item_opt" onchange="checkall();" name="item_opt">
                        <option value="0" selected="selected">0</option>
                        <option value="1">4</option>
                        <option value="2">8</option>
                        <option value="3">12</option>
                        <option value="4">16</option>
                        <option value="5">20</option>
                        <option value="6">24</option>
                        <option value="7">28</option>
                </select>
                <span id="credits_opt">0</span> Points
                </div>
    ';} elseif($item_ad == '2') { // 2 for stafs, Shield, Set Items, Wings Level 1 , Wings level 2
    $drop_ad_opt = '
                <div class="opt_title">Additional Defense:</div>
                <div class="opt">
                    <select id="item_opt" onchange="checkall();" name="item_opt">
                        <option value="0" selected="selected">0</option>
                        <option value="1">4</option>
                        <option value="2">8</option>
                        <option value="3">12</option>
                        <option value="4">16</option>
                        <option value="5">20</option>
                        <option value="6">24</option>
                        <option value="7">28</option>
                </select>
                <span id="credits_opt">0</span> Points
                </div>
    ';} elseif($item_ad == '3') { // 3 for Rings, Pendant, Wings level 3
    $drop_ad_opt = '
                <div class="opt_title">Automatic HP Recovery:</div>
                <div class="opt">
                    <select id="item_opt" onchange="checkall();" name="item_opt">
                        <option value="0" selected="selected">0</option>
                        <option value="1">1%</option>
                        <option value="2">2%</option>
                        <option value="3">3%</option>
                        <option value="4">4%</option>
                        <option value="5">5%</option>
                        <option value="6">6%</option>
                        <option value="7">7%</option>
                </select>
                <span id="credits_opt">0</span> Points
                </div>
    ';} elseif($item_ad == '4') { // 4 for Rings of Magic.
    $drop_ad_opt = '
                <div class="opt_title">Max Mana Increase:</div>
                <div class="opt">
                    <select id="item_opt" onchange="checkall();" name="item_opt">
                        <option value="0" selected="selected">0</option>
                        <option value="1">1%</option>
                        <option value="2">2%</option>
                        <option value="3">3%</option>
                        <option value="4">4%</option>
                        <option value="5">5%</option>
                        <option value="6">6%</option>
                        <option value="7">7%</option>
                </select>
                <span id="credits_opt">0</span> Points
                </div>
    ';};
    
    ?>
    <script>
    function checkall(){
            var shopDiscStart = '<?php echo $mvcore['shop_disc_start'];?>'; // Discount Start RUN
            var shopDisc = '<?php echo $mvcore['shop_disc'];?>'; // Discount ON OFF
            var shopPerc = '<?php echo $mvcore['shop_perc'];?>'; // Discount Percent ( Without % )
            
    //Item Cost
            var zenCalc = '<?php echo $mvcore['cost_cred_to_zen'];?>';
            var costItem = '<?php echo $check_item_ok[1];?>';
            var costLevel = '<?php echo $mvcore['cost_level'];?>';
            var costOpt = '<?php echo $mvcore['cost_opt'];?>';
            var costLuck = '<?php echo $mvcore['cost_luck'];?>';
            var costSkill = '<?php echo $mvcore['cost_skill'];?>';
            var costRef = '<?php echo $mvcore['cost_ref'];?>';
            var costExe = '<?php echo $mvcore['cost_exe'];?>';
            var costAnc1 = '<?php echo $mvcore['cost_anc1'];?>';
            var costAnc2 = '<?php echo $mvcore['cost_anc2'];?>';
            
            var costFen1 = '<?php echo $mvcore['cost_fenblack'];?>';
            var costFen2 = '<?php echo $mvcore['cost_fenblue'];?>';
            var costFen3 = '<?php echo $mvcore['cost_fengold'];?>';
    
    var itemCostMainZen = costItem * zenCalc;
    //Separator ^^ -------------------------------------------------------------------------------------------------
        var credits     = Math.ceil(costItem);
        var zen         = Math.ceil(itemCostMainZen);
        var options        = 0;
    //Separator ^^ -------------------------------------------------------------------------------------------------
            if ($('#item_level option:selected').length){
                if ($('#item_level option:selected').val() > 0){
                    $('#credits_level').html("<b>"+$('#item_level option:selected').val()*parseInt(costLevel)+"</b>");
                    credits = credits + $('#item_level option:selected').val() * parseInt(costLevel);
                    zen = zen + $('#item_level option:selected').val() * parseInt(costLevel) * parseInt(zenCalc);
                    setPrice(credits);
                    setPriceZen(zen);
                }
                else{
                    $('#credits_level').html(0);
                    setPrice(credits);
                    setPriceZen(zen);
                }
            }
    //Separator ^^ -------------------------------------------------------------------------------------------------            
            if ($('#item_opt option:selected').length){
                if ($('#item_opt option:selected').val() > 0){    
                    $('#credits_opt').html("<b>"+$('#item_opt option:selected').val()*parseInt(costOpt)+"</b>");
                    credits = credits + $('#item_opt option:selected').val() * parseInt(costOpt);
                    zen = zen + $('#item_opt option:selected').val() * parseInt(costOpt) * parseInt(zenCalc);
                    setPrice(credits);
                    setPriceZen(zen);
                }
                else{
                    $('#credits_opt').html(0);
                    setPrice(credits);
                    setPriceZen(zen);
                }
            }
    //Separator ^^ -------------------------------------------------------------------------------------------------        
            for(i = 1; i <= 6; i++){
                if($("#ex"+i+":checked")){
                    if ($("#ex"+i+":checked").length > 0){
                        options = options + parseInt(costExe);
                    }
                }
            }
            
            if(options > 0){
                $('#credits_exe').html("<b>"+options+"</b>");
                zen = zen + options * parseInt(zenCalc);
                credits = credits + options;
                setPrice(credits);
                setPriceZen(zen);
            }
            else{
                $('#credits_exe').html(0);
                setPrice(credits);
                setPriceZen(zen);
            }
    //Separator ^^ -------------------------------------------------------------------------------------------------
            if($("#item_anc option:selected")){
                if($("#item_anc option:selected").val() == 5){
                    $('#credits_ancient').html("<b>"+parseInt(costAnc1)+"</b>");
                    zen = zen + parseInt(costAnc1) * parseInt(zenCalc);
                    credits = credits + parseInt(costAnc1);
                    setPrice(credits);
                    setPriceZen(zen);
                }
                else if($("#item_anc option:selected").val() == 10){
                    $('#credits_ancient').html("<b>"+parseInt(costAnc2)+"</b>");
                    zen = zen + parseInt(costAnc2) * parseInt(zenCalc);
                    credits = credits + parseInt(costAnc2);
                    setPrice(credits);
                    setPriceZen(zen);
                }
                else{
                    $('#credits_ancient').html(0); 
                    setPrice(credits);
                    setPriceZen(zen);
                }
            }
    //Separator ^^ -------------------------------------------------------------------------------------------------        
            if ($("#item_luck:checked")){ 
                if ($("#item_luck:checked").length > 0){
                    $('#credits_luck').html("<b>"+parseInt(costLuck)+"</b>");
                    zen = zen + parseInt(costLuck) * parseInt(zenCalc) ;
                    credits = credits + parseInt(costLuck);
                    setPrice(credits);
                    setPriceZen(zen);
                }
                else{
                    $('#credits_luck').html(0);
                    setPrice(credits);
                    setPriceZen(zen);
                }
            }
    //Separator ^^ -------------------------------------------------------------------------------------------------
            if ($('#item_harm option:selected')){
                if (($('#item_harm option:selected').val() != undefined) && ($('#item_harm option:selected').val() != '')){
                    $(document).ready(function() {
                        $.post("shop.php", {
                                hopt: $('#item_harm').val()
                        },
                        function(data) {
                            $('#credits_harm').html("<b>"+parseInt(data)+"</b>");
                            zen = zen + parseInt(data) * parseInt(zenCalc) ;
                            credits = credits + parseInt(data);
                            setPrice(credits);
                            setPriceZen(zen);
                        });
                    });        
                }
                else{
                    $('#credits_harm').html(0);
                    setPrice(credits);
                    setPriceZen(zen);
                }
            }
    //Separator ^^ -------------------------------------------------------------------------------------------------
            if($('#socket1 option:selected').length && $('#socket1 option:selected').val() != 'no'){
                $(document).ready(function(){
                    $.post("shop.php", {
                        s_option: $('#socket1 option:selected').val(),            
                    },
                    function(data) {
                        $('#credits_socket1').html("<b>"+parseInt(data)+"</b>");
                        credits = credits + parseInt(data);
                        setPrice(credits);
                        zen = zen + parseInt(data) * parseInt(zenCalc) ;
                        setPriceZen(zen);
                    });
                });    
                removeOpt(1);    
            }
            if($('#socket2 option:selected').length && $('#socket2 option:selected').val() != 'no'){
                $(document).ready(function(){
                    $.post("shop.php", {
                        s_option: $('#socket2 option:selected').val(),            
                    },
                    function(data) {
                        $('#credits_socket2').html("<b>"+parseInt(data)+"</b>");
                        credits = credits + parseInt(data);
                        setPrice(credits);
                        zen = zen + parseInt(data) * parseInt(zenCalc) ;
                        setPriceZen(zen);
                    });
                });    
                removeOpt(2);    
            }
            if($('#socket3 option:selected').length && $('#socket3 option:selected').val() != 'no'){
                $(document).ready(function(){
                    $.post("shop.php", {
                        s_option: $('#socket3 option:selected').val(),            
                    },
                    function(data) {
                        $('#credits_socket3').html("<b>"+parseInt(data)+"</b>");
                        credits = credits + parseInt(data);
                        setPrice(credits);
                        zen = zen + parseInt(data) * parseInt(zenCalc) ;
                        setPriceZen(zen);
                    });
                });    
                removeOpt(3);    
            }
            if($('#socket4 option:selected').length && $('#socket4 option:selected').val() != 'no'){
                $(document).ready(function(){
                    $.post("shop.php", {
                        s_option: $('#socket4 option:selected').val(),            
                    },
                    function(data) {
                        $('#credits_socket4').html("<b>"+parseInt(data)+"</b>");
                        credits = credits + parseInt(data);
                        setPrice(credits);
                        zen = zen + parseInt(data) * parseInt(zenCalc) ;
                        setPriceZen(zen);
                    });
                });    
                removeOpt(4);    
            }
            if($('#socket5 option:selected').length && $('#socket5 option:selected').val() != 'no'){
                $(document).ready(function(){
                    $.post("shop.php", {
                        s_option: $('#socket5 option:selected').val(),            
                    },
                    function(data) {
                        $('#credits_socket5').html("<b>"+parseInt(data)+"</b>");
                        credits = credits + parseInt(data);
                        setPrice(credits);
                        zen = zen + parseInt(data) * parseInt(zenCalc) ;
                        setPriceZen(zen);
                    });
                });    
                removeOpt(5);        
            }
    //Separator ^^ -------------------------------------------------------------------------------------------------        
            if ($("#item_skill:checked")){ 
                if ($("#item_skill:checked").length > 0){
                    $('#credits_skill').html("<b>"+parseInt(costSkill)+"</b>");
                    zen = zen + parseInt(costSkill) * parseInt(zenCalc);
                    credits = credits + parseInt(costSkill);
                    setPrice(credits);
                    setPriceZen(zen);
                }
                else{
                    $('#credits_skill').html(0);
                    setPrice(credits);
                    setPriceZen(zen);
                }
            }
    //Separator ^^ -------------------------------------------------------------------------------------------------        
            if ($("#item_ref:checked")){
                if ($("#item_ref:checked").length > 0){
                    $('#credits_ref').html("<b>"+parseInt(costRef)+"</b>");
                    zen = zen + parseInt(costRef) * parseInt(zenCalc);
                    credits = credits + parseInt(costRef);
                    setPrice(credits);
                    setPriceZen(zen);
                }
                else{
                    $('#credits_ref').html(0);
                    setPrice(credits);
                    setPriceZen(zen);
                }
            }    
    //Separator ^^ -------------------------------------------------------------------------------------------------
            if($("#fenrir1:checked")){
                if ($("#fenrir1:checked").length > 0){
                    $('#credits_fenrir1').html("<b>"+parseInt(costFen1)+"</b>");
                    zen = zen + parseInt(costFen1) * parseInt(zenCalc);
                    credits = credits + parseInt(costFen1);
                    setPrice(credits);
                    setPriceZen(zen);
                }
                else{
                    $('#credits_fenrir1').html(0);
                    setPrice(credits);
                    setPriceZen(zen);
                }
            }
    //Separator ^^ -------------------------------------------------------------------------------------------------        
            if($("#fenrir2:checked")){
                if ($("#fenrir2:checked").length > 0){
                    $('#credits_fenrir2').html("<b>"+parseInt(costFen2)+"</b>");
                    zen = zen + parseInt(costFen2) * parseInt(zenCalc);
                    credits = credits + parseInt(costFen2);
                    setPrice(credits);
                    setPriceZen(zen);
                }
                else{
                    $('#credits_fenrir2').html(0);
                    setPrice(credits);
                    setPriceZen(zen);
                }
            }
    //Separator ^^ -------------------------------------------------------------------------------------------------        
            if($("#fenrir3:checked")){
                if ($("#fenrir3:checked").length > 0){
                    $('#credits_fenrir3').html("<b>"+parseInt(costFen3)+"</b>");
                    zen = zen + parseInt(costFen3) * parseInt(zenCalc);
                    credits = credits + parseInt(costFen3);
                    setPrice(credits);
                    setPriceZen(zen);
                }
                else{
                    $('#credits_fenrir3').html(0);
                    setPrice(credits);
                    setPriceZen(zen);
                }
            }
    //Separator ^^ -------------------------------------------------------------------------------------------------
    }
            
    function setPrice(credits){
            var shopDiscStart = '<?php echo $mvcore['shop_disc_start'];?>'; // Discount Start RUN
            var shopDisc = '<?php echo $mvcore['shop_disc'];?>'; // Discount ON OFF
            var shopPerc = '<?php echo $mvcore['shop_perc'];?>'; // Discount Percent ( Without % )
            
        var goldDif = '<?php echo $mvcore['gold_dif'];?>';
        
        if(shopDisc == "on"){
            if(shopDiscStart == 1){
                var credits = Math.floor(credits + ((- shopPerc * credits) / 100));
                $('#total_credits').html(credits);
                $('#total_credits_g').html(Math.floor(credits + (( - goldDif * credits) / 100)));
            } else {
                $('#total_credits').html(credits);
                $('#total_credits_g').html(Math.floor(credits + (( - goldDif * credits) / 100)));
            }
        } else {
            $('#total_credits').html(credits);
            $('#total_credits_g').html(Math.floor(credits + (( - goldDif * credits) / 100)));
        }
    }
    
    function setPriceZen(zen){
            var shopDiscStart = '<?php echo $mvcore['shop_disc_start'];?>'; // Discount Start RUN
            var shopDisc = '<?php echo $mvcore['shop_disc'];?>'; // Discount ON OFF
            var shopPerc = '<?php echo $mvcore['shop_perc'];?>'; // Discount Percent ( Without % )
            
        if(shopDisc == "on"){
            if(shopDiscStart == 1){
                var zen = Math.floor(zen + ((- shopPerc * zen) / 100));
                if(zen >= '2000000000') { $('#total_zen').html("2000000000"); } else {
                    $('#total_zen').html(zen);
                }
            } else {
                if(zen >= '2000000000') { $('#total_zen').html("2000000000"); } else {
                    $('#total_zen').html(zen);
                }
            }
        } else {
            if(zen >= '2000000000') { $('#total_zen').html("2000000000"); } else {
                $('#total_zen').html(zen);
            }
        }
    }
    
    function removeOpt(socket){
            if($('#socket'+socket+' option:selected').val() != '254' && $('#socket'+socket+' option:selected').val() != 'no'){
                for(i = 1; i <= 5; i++){
                    if(i == socket)
                        i += 1;
                    
                    var eqeSocketsdd = '<?php echo $mvcore['eqe_sockets'];?>';
                    
                    if(eqeSocketsdd == 'yes') {
                    } else {
                        $("#socket"+i+" > option[value='"+$('#socket'+socket+' option:selected').val()+"']").remove();
                        $("#socket"+i+" > option[value='"+$('#socket'+socket+' option:selected').val()+"']").remove();
                        $("#socket"+i+" > option[value='"+$('#socket'+socket+' option:selected').val()+"']").remove();
                        $("#socket"+i+" > option[value='"+$('#socket'+socket+' option:selected').val()+"']").remove();
                    }
                }
            }        
    }
    
    </script>
    <div id="dropitemhtmls" title="<?php echo $check_item_ok[0];?>">
    <form method="POST" action="MVCore_webshop<?php if($link_get == ''){} else { echo 'MVCore_'.$link_get.''; }; ?>.html" id="item_form">
    <input type="hidden" name="buy_item" value="<?php echo $check_item_ok[0];?>">
    <?php if($mvcore['shop_disc'] == 'on'){ if($mvcore['shop_disc_start'] == 1) { echo'<center><h3><b>Webshop Discount '.$mvcore['shop_perc'].'% FOR ONE HOUR !! Buy While Can.</b></h3></center>'; } }; ?>
        <div id="item_buy">
            <div id="item_buy_left">
                <div id="idistest">
                    <div id="item_image_bg">
                        <img src="sys/images/webshop/item_images/<?php echo $item_cat;?>/<?php echo $item_id;?>.gif" alt="" style="border: 0px;">
                    </div>
                </div>
                <div class="item_info">
                    <div class="info">
                        Bought <span class="btimes" id="total_bought"><?php echo $check_item_ok[7];?></span> Times
                    </div>
                </div>
                <?php echo $drop_costshow_gcred;?>
                <?php echo $drop_costshow_cred;?>
                <?php echo $drop_costshow_zen;?>
            </div>
            <div id="item_buy_right">
            
            <?php if($item_level >= '1') { ?>
                <div class="opt_title">Item Level:</div>
                <div class="opt">
                    <select id="item_level" onchange="checkall();" name="item_level">
                        <option value="0" selected="selected">+ 0</option>
                                <?php
                                    for($i=0;$i < $item_level;++$i) {
                                        $value = $i + 1;
                                        echo'<option value="'.$value.'">+ '.$value.'</option>';
                                    };
                                ?>
                    </select>
                    <span id="credits_level">0</span> Points
                </div>
            <?php } ?>
            <?php if($item_ad >= '1') { ?>
                <?php echo $drop_ad_opt;?>
            <?php } ?>
            
            <?php if($item_luck >= '1') { ?>
                <div class="opt_title">Item Luck:</div>
                <div class="opt">
                    <input id="item_luck" onclick="checkall();" name="item_luck" value="1" type="checkbox"> 
                    <span id="credits_luck">0</span> Points
                </div>
            <?php } ?>    
            
            <?php if($item_skill >= '1') { ?>
                <div class="opt_title">Item Skill:</div>
                <div class="opt">
                    <input id="item_skill" onclick="checkall();" name="item_skill" value="1" type="checkbox"> 
                    <span id="credits_skill">0</span> Points
                </div>
            <?php } ?>    
            
            <?php if($item_refin >= '1') { ?>
                <div class="opt_title">Refinery Option:</div>
                <div class="opt">
                    <input id="item_ref" onclick="checkall();" name="item_ref" value="1" type="checkbox"> 
                    <span id="credits_ref">0</span> Points
                </div>
            <?php } ?>        
                
                <?php if($check_item_ok[6] >= '1') { ?>
                <div class="opt_title">Harmony Option:</div>
                <div class="opt">
                    <select id="item_harm" onchange="checkall();" name="item_harm">
                        <option value="na" selected="selected"> - Select - </option>
                        <?php 
                        if($check_item_ok[6] == '1') { // 1 for Swords
                            $select_joh_info= mssql_query("Select top 99 joh_name from wshopp_harmony where joh_type='1'");
                            for($i=0;$i < mssql_num_rows($select_joh_info);++$i) {
                                    $value = $i + 1;
                                $s_joh_i= mssql_fetch_row($select_joh_info);
                                echo'<option value="'.$s_joh_i[0].'">'.$s_joh_i[0].'</option>';
                            };
                        } elseif($check_item_ok[6] == '2') { // 2 for staffs
                            $select_joh_info= mssql_query("Select top 99 joh_name from wshopp_harmony where joh_type='2'");
                            for($i=0;$i < mssql_num_rows($select_joh_info);++$i) {
                                    $value = $i + 1;
                                $s_joh_i= mssql_fetch_row($select_joh_info);
                                echo'<option value="'.$s_joh_i[0].'">'.$s_joh_i[0].'</option>';
                            };
                        } elseif($check_item_ok[6] == '3') { // 3 for sets & shields
                            $select_joh_info= mssql_query("Select top 99 joh_name from wshopp_harmony where joh_type='3'");
                            for($i=0;$i < mssql_num_rows($select_joh_info);++$i) {
                                    $value = $i + 1;
                                $s_joh_i= mssql_fetch_row($select_joh_info);
                                echo'<option value="'.$s_joh_i[0].'">'.$s_joh_i[0].'</option>';
                            };
                        }
                        ?>
                    </select>
                    <span id="credits_harm">0</span> Points
                </div>
                <?php } ?>
                
                <?php if($item_anc == '1') { ?>
                <div class="opt_title">Ancient Set:</div>
                <div class="opt">
                    <select id="item_anc" onchange="checkall();" name="item_anc">
                        <option value="na" selected="selected"> - Select - </option>
                                <?php
                                    $select_anc_info= mssql_query("Select top 2 anc_type,anc_name,options,item_id,item_cat from wshopp_ancient where item_id='".$item_id."' and item_cat='".$item_cat."'");
                                    for($i=0;$i < mssql_num_rows($select_anc_info);++$i) {
                                    $s_anc_i= mssql_fetch_row($select_anc_info);
                                        echo'<option value="'.$s_anc_i[0].'">Set '.$s_anc_i[1].'</option>';
                                    };
                                ?>
                    </select>
                    <span id="credits_ancient">0</span> Points
                </div>
                <?php } ?>
                
                    <?php if($check_item_ok[8] == '5') { // 5 for Fenrirs ?>     
                        <div class="opt_title">Fenrir +Damage (Black)</div>
                        <div class="opt"><input id="fenrir1" name="fenrir1" onclick="checkall();" value="1" type="radio"> <span id="credits_fenrir1">0</span> Points</div>
                        <div class="opt_title">Fenrir +Defense (Blue)</div>
                        <div class="opt"><input id="fenrir2" name="fenrir1" onclick="checkall();" value="2" type="radio"> <span id="credits_fenrir2">0</span> Points</div>
                        <div class="opt_title">Fenrir +Illusion (Gold)</div>
                        <div class="opt"><input id="fenrir3" name="fenrir1" onclick="checkall();" value="4" type="radio"> <span id="credits_fenrir3">0</span> Points</div>
                    <?php } ?>
    <?php 
    if($check_item_ok[8] == '0') { // 0 for Weapons Pendants
                if($item_exc >= '1') { echo'
                                <div class="opt_title">Increases Mana After monster +Mana/8</div>
                                <div class="opt"><input class="countries" id="ex1" onclick="checkall();" name="exe1" value="1" type="checkbox"></div>
                ';};
                if($item_exc >= '2') { echo'
                                <div class="opt_title">Increases Life After monster +Life/8</div>
                                <div class="opt"><input class="countries" id="ex2" onclick="checkall();" name="exe2" value="2" type="checkbox"></div>
                ';};
                if($item_exc >= '3') { echo'
                                <div class="opt_title">Increase attacking(wizardly)speed+7</div>
                                <div class="opt"><input class="countries" id="ex3" onclick="checkall();" name="exe3" value="3" type="checkbox"></div>
                ';};
                if($item_exc >= '4') { echo'
                                <div class="opt_title">Increase Damage +2%</div>
                                <div class="opt"><input class="countries" id="ex4" onclick="checkall();" name="exe4" value="4" type="checkbox"></div>
                ';};
                if($item_exc >= '5') { echo'
                                <div class="opt_title">Increase Damage +level/20</div>
                                <div class="opt"><input class="countries" id="ex5" onclick="checkall();" name="exe5" value="5" type="checkbox"></div>
                ';};
                if($item_exc >= '6') { echo'
                                <div class="opt_title">Excellent Damage Rate +10%</div>
                                <div class="opt"><input class="countries" id="ex6" onclick="checkall();" name="exe6" value="6" type="checkbox"></div>
                ';};
    } elseif($check_item_ok[8] == '1') { // 1 for Shield & Set Parts
                if($item_exc >= '1') { echo'
                                <div class="opt_title">Increase MaxHP +4%</div>
                                <div class="opt"><input class="countries" id="ex1" onclick="checkall();" name="exe6" value="6" type="checkbox"></div>
                ';};
                if($item_exc >= '2') { echo'
                                <div class="opt_title">Increase MaxMana +4%</div>
                                <div class="opt"><input class="countries" id="ex2" onclick="checkall();" name="exe5" value="5" type="checkbox"></div>
                ';};
                if($item_exc >= '3') { echo'
                                <div class="opt_title">Damage decrease +4%</div>
                                <div class="opt"><input class="countries" id="ex3" onclick="checkall();" name="exe4" value="4" type="checkbox"></div>
                ';};
                if($item_exc >= '4') { echo'
                                <div class="opt_title">Reflect damage +5%</div>
                                <div class="opt"><input class="countries" id="ex4" onclick="checkall();" name="exe3" value="3" type="checkbox"></div>
                ';};
                if($item_exc >= '5') { echo'
                                <div class="opt_title">Defense success rate +10%</div>
                                <div class="opt"><input class="countries" id="ex5" onclick="checkall();" name="exe2" value="2" type="checkbox"></div>
                ';};
                if($item_exc >= '6') { echo'
                                <div class="opt_title">Increase Zen After Hunt +40%</div>
                                <div class="opt"><input class="countries" id="ex6" onclick="checkall();" name="exe1" value="1" type="checkbox"></div>
                ';};
    } elseif($check_item_ok[8] == '2') { // 2 Wings level 1 & 2
                if($item_exc >= '1') { echo'
                                <div class="opt_title">HP +115 Increase</div>
                                <div class="opt"><input class="countries" id="ex1" onclick="checkall();" name="exe1" value="1" type="checkbox"></div>
                ';};
                if($item_exc >= '2') { echo'
                                <div class="opt_title">MP +115 Increase</div>
                                <div class="opt"><input class="countries" id="ex2" onclick="checkall();" name="exe2" value="2" type="checkbox"></div>
                ';};
                if($item_exc >= '3') { echo'
                                <div class="opt_title">Ignore enemys defensive power by 3%</div>
                                <div class="opt"><input class="countries" id="ex3" onclick="checkall();" name="exe3" value="3" type="checkbox"></div>
                ';};
                if($item_exc >= '4') { echo'
                                <div class="opt_title">Max AG +50 Increase</div>
                                <div class="opt"><input class="countries" id="ex4" onclick="checkall();" name="exe4" value="4" type="checkbox"></div>
                ';};
                if($item_exc >= '5') { echo'
                                <div class="opt_title">Increase attacking(wizardly)speed+5</div>
                                <div class="opt"><input class="countries" id="ex5" onclick="checkall();" name="exe5" value="5" type="checkbox"></div>
                ';};
    } elseif($check_item_ok[8] == '3') { // 3 Wings level 3
                if($item_exc >= '1') { echo'
                                <div class="opt_title">Ingore opponents defensive power by 5%</div>
                                <div class="opt"><input class="countries" id="ex1" onclick="checkall();" name="exe1" value="1" type="checkbox"></div>
                ';};
                if($item_exc >= '2') { echo'
                                <div class="opt_title">Returns the enemys attack power in 5%</div>
                                <div class="opt"><input class="countries" id="ex2" onclick="checkall();" name="exe2" value="2" type="checkbox"></div>
                ';};
                if($item_exc >= '3') { echo'
                                <div class="opt_title">Complete recovery of life in 5% rate</div>
                                <div class="opt"><input class="countries" id="ex3" onclick="checkall();" name="exe3" value="3" type="checkbox"></div>
                ';};
                if($item_exc >= '4') { echo'
                                <div class="opt_title">Complete recover of Mana in 5% rate</div>
                                <div class="opt"><input class="countries" id="ex4" onclick="checkall();" name="exe4" value="4" type="checkbox"></div>
                ';};
    } elseif($check_item_ok[8] == '4') { // 4 Rings
                if($item_exc >= '1') { echo'
                                <div class="opt_title">Increase MaxHP +4%</div>
                                <div class="opt"><input class="countries" id="ex1" onclick="checkall();" name="exe6" value="6" type="checkbox"></div>
                ';};
                if($item_exc >= '2') { echo'
                                <div class="opt_title">Increase MaxMana +4%</div>
                                <div class="opt"><input class="countries" id="ex2" onclick="checkall();" name="exe5" value="5" type="checkbox"></div>
                ';};
                if($item_exc >= '3') { echo'
                                <div class="opt_title">Damage decrease +4%</div>
                                <div class="opt"><input class="countries" id="ex3" onclick="checkall();" name="exe4" value="4" type="checkbox"></div>
                ';};
                if($item_exc >= '4') { echo'
                                <div class="opt_title">Reflect damage +5%</div>
                                <div class="opt"><input class="countries" id="ex4" onclick="checkall();" name="exe3" value="3" type="checkbox"></div>
                ';};
                if($item_exc >= '5') { echo'
                                <div class="opt_title">Defense success rate +10%</div>
                                <div class="opt"><input class="countries" id="ex5" onclick="checkall();" name="exe2" value="2" type="checkbox"></div>
                ';};
                if($item_exc >= '6') { echo'
                                <div class="opt_title">Increase Zen After Hunt +40%</div>
                                <div class="opt"><input class="countries" id="ex6" onclick="checkall();" name="exe1" value="1" type="checkbox"></div>
                ';};
    };
    ?>
                        
                <?php if($item_exc >= '1') { ?>
                <div class="opt_title">Exe Price:</div>
                <div class="opt"><span id="credits_exe">0</span> Points</div>
                <?php } ?>
                
            <?php if($item_sk >= '1') { ?>
                <div class="opt_title">Socket 1:</div>
                <div class="opt">
                    <select name="socket1" class="countries1" onchange="checkall();" id="socket1">
                                <option value="254">EMPTY (No Mounting Socket)</option>
                        <?php
                            $select_sk_info= mssql_query("Select top 99 sok_name, sok_id from wshopp_socket ".$drop_sockets."");
                            for($i=0;$i < mssql_num_rows($select_sk_info);++$i) {
                                    $value = $i;
                                $s_sk_i= mssql_fetch_row($select_sk_info);
                                echo'<option value="'.$s_sk_i[1].'">'.$s_sk_i[0].'</option>';
                            };
                        ?>
                    </select>
                    <span id="credits_socket1">0</span> Points
                </div>
            <?php } ?>
            <?php if($item_sk >= '2') { ?>
                <div class="opt_title">Socket 2:</div>
                <div class="opt">
                    <select name="socket2" class="countries1" onchange="checkall();" id="socket2">
                                <option value="254">EMPTY (No Mounting Socket)</option>
                        <?php
                            $select_sk_info= mssql_query("Select top 99 sok_name, sok_id from wshopp_socket ".$drop_sockets."");
                            for($i=0;$i < mssql_num_rows($select_sk_info);++$i) {
                                $s_sk_i= mssql_fetch_row($select_sk_info);
                                echo'<option value="'.$s_sk_i[1].'">'.$s_sk_i[0].'</option>';
                            };
                        ?>
                    </select>
                    <span id="credits_socket2">0</span> Points
                </div>
            <?php } ?>
            <?php if($item_sk >= '3') { ?>
                <div class="opt_title">Socket 3:</div>
                <div class="opt">
                    <select name="socket3" class="countries1" onchange="checkall();" id="socket3">
                                <option value="254">EMPTY (No Mounting Socket)</option>
                        <?php
                            $select_sk_info= mssql_query("Select top 99 sok_name, sok_id from wshopp_socket ".$drop_sockets."");
                            for($i=0;$i < mssql_num_rows($select_sk_info);++$i) {
                                $s_sk_i= mssql_fetch_row($select_sk_info);
                                echo'<option value="'.$s_sk_i[1].'">'.$s_sk_i[0].'</option>';
                            };
                        ?>
                    </select>
                    <span id="credits_socket3">0</span> Points
                </div>
            <?php } ?>
            <?php if($item_sk >= '4') { ?>
                <div class="opt_title">Socket 4:</div>
                <div class="opt">
                    <select name="socket4" class="countries1" onchange="checkall();" id="socket4">
                                <option value="254">EMPTY (No Mounting Socket)</option>
                        <?php
                            $select_sk_info= mssql_query("Select top 99 sok_name, sok_id from wshopp_socket ".$drop_sockets."");
                            for($i=0;$i < mssql_num_rows($select_sk_info);++$i) {
                                $s_sk_i= mssql_fetch_row($select_sk_info);
                                echo'<option value="'.$s_sk_i[1].'">'.$s_sk_i[0].'</option>';
                            };
                        ?>
                    </select>
                    <span id="credits_socket4">0</span> Points
                </div>
            <?php } ?>
            <?php if($item_sk >= '5') { ?>
                <div class="opt_title">Socket 5:</div>
                <div class="opt">
                    <select name="socket5" class="countries1" onchange="checkall();" id="socket5">
                                <option value="254">EMPTY (No Mounting Socket)</option>
                        <?php
                            $select_sk_info= mssql_query("Select top 99 sok_name, sok_id from wshopp_socket ".$drop_sockets."");
                            for($i=0;$i < mssql_num_rows($select_sk_info);++$i) {
                                $s_sk_i= mssql_fetch_row($select_sk_info);
                                echo'<option value="'.$s_sk_i[1].'">'.$s_sk_i[0].'</option>';
                            };
                        ?>
                    </select>
                    <span id="credits_socket5">0</span> Points
                </div>
            <?php } ?>
                
            </div>
        </div>    
        <div id="buy_buttons">
                <?php echo $drop_cost_gcred;?>
                <?php echo $drop_cost_cred;?>
                <?php echo $drop_cost_zen;?>
        </div>
        <div style="clear:both;"></div>
    </form>
    </div>
    <?php } ?>
    <script>
    $(document).ready(function () {
        $("input[class='countries']").change(function () {
            var maxAllowed = 2;
            var cnt = $("input[class='countries']:checked").length;
            if (cnt > maxAllowed) {
                $(this).prop("checked", "");
                alert('You can select maximum ' + maxAllowed + ' options!');
            }
        });
    });
    $(document).ready(function() {
        $(".countries").click(function() {
           if ($(this).is(":checked")) { 
              $(".countries1").prop("disabled", true);
           } else {
              $(".countries1").prop("disabled", false);
    alert('You can select maximum ' + maxAllowed + ' options!');          
           }
        });
    });
    </script>
    - - - Updated - - -

    if u whana to help https://github.com/proenix12/mvcoree

    - - - Updated - - -

    Quote Originally Posted by leorond View Post
    Do you really believe that you get to different numbers PK?

    PHP Code:
    switch ($drop_info[9]) {
        case 
    0:
            
    $pk_level="Phonoman";
        break;
        
        case 
    3:
            
    $pk_level="Commoner";
        break;
        
        case 
    6:
            
    $pk_level="Hero";
        break;

    You should adjust the display for undefined values!

    PHP Code:
    switch ($drop_info[9]) {
        case 
    0:
            
    $pk_level="Phonoman";
        break;
        
        case 
    3:
            
    $pk_level="Commoner";
        break;
        
        case 
    6:
            
    $pk_level="Hero";
        break;
        default:                      
    // <= Other values
        
    $pk_level    =    unknown;
        break;

    - - - Updated - - -

    Or even better, and do it from the function which you then call.

    PHP Code:
    function    pk_level($drop_info)
    {
        switch (
    $drop_info
        {
            case 
    0:
                
    $pk_level="Phonoman";
            break;
            case 
    3:
                
    $pk_level="Commoner";
            break;
                case 
    6:
                
    $pk_level="Hero";
            break;
            default:                      
    // <= Other values
                
    $pk_level    =    unknown;
            break;
        }
        return    
    $pk_level;

    Listing will be as follows.

    PHP Code:
    <?php
    echo pk_level(intval($drop_info[9]));
    ?>
    Place it in a file .php and throw in index.php and include the main file.

    You do not have to use it after the 10 scripts.

    You can use it on to other things. Accelerate and transparency of this script.
    if u whana to se script work or no
    PHP Code:
    $drop_info[9] - RESETS;
    print 
    "<pre>"print_r($drop_info); print "</pre>"

  8. #8
    if(!caffeine) continue; leorond is offline
    MemberRank
    Jul 2012 Join Date
    Czech RepublicLocation
    491Posts

    Re: Search reset_formula for MVCORE

    Somehow I do not understand well why this script is written in this way.

    PHP Code:
    $drop_info[9] - RESETS;
    print 
    "<pre>"print_r($drop_info); print "</pre>"
    What is the logic, write it that way? Why is it not written in simpler?

    In my opinion, this should be the number of characters per account.

    I'd wrote it down like this.

    PHP Code:
    echo $drop_info;
    //or
    print $drop_info;
    //or
    print_r($drop_info);
    //<pre></pre>
    echo "<pre>".$drop_info."</pre>";
    //or
    print "<pre>".$drop_info."</pre>";
    //or
    print_r("<pre>".$drop_info."</pre>"); 
    The first line I think is absurd. I do not know why it is there but if it is commented out so I left it.



Advertisement