fasit

<?php
class minestats{
        private $config;
        private $mysqli;
        private $query;
        var $players;
        var $used_lang;
        var $lang;
        var $langs;
        var $search;
        var $sort;
        var $server;
        var $date;
        var $optable;
        var $opheadfoot;

        function minestats(){
                require('config.php');
                $this->config = $config;
                $this->mysqli = new mysqli($config['server'], $config['user'], $config['pass'],  $config['db']);
                $this->server = $config['servername'];
                $this->date = $config['date'];
                $this->optable = $config['optable'];
                $this->opheadfoot = $config['opheadfoot'];
                if (mysqli_connect_error()) {die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());}
                if ($_GET['lang']){
                        $this->lang = parse_ini_file('lang/'.$_GET['lang'].'.ini');
                        $this->used_lang = $_GET['lang'];
                }
                else{
                        $this->lang = parse_ini_file('lang/'.$config['lang'].'.ini');
                        $this->used_lang = $config['lang'];
                }
                if ($handle = opendir(dirname(__FILE__).'/lang')) {
                        while (false !== ($file = readdir($handle))) {
                                if (preg_match("/.*\.ini/", $file, $hit)) {
                                        $this->langs[] = preg_replace('/\.ini/', '', $hit[0]);
                                }
                        }
                        closedir($handle);
                }
        }

        protected function fetch_array($iterator = 1,$index=''){
                if ($result = $this->mysqli->query($this->query)) {
                        $i=0;
                        while ($row = $result->fetch_assoc()) {
                                switch ($iterator)
                                {
                                        case 0:
                                        $res_array = $row[$index];
                                        break;
                                        case 1:
                                        $res_array[$row[$index]] = $row["value"];
                                        break;
                                        case 2:
                                        $res_array[$i] = $row[$index];
                                        $i++;
                                        break;
                                        case 3:
                                        $res_array[$row[$index]] = array();
                                        break;
                                }
                        }
                        $result->close();
                        return $res_array;
                }else{
                        printf("Errormessage: %s\n", $mysqli->error);
                        return false;
                }
        }
        protected function fetch_stats(){
                if ($result = $this->mysqli->query($this->query)) {
                        $i=0;
                        while ($row = $result->fetch_assoc()) {
                            $this->players[$row['player']][$row['mlvl']][$row['mexp']][$row['wlvl']][$row['wexp']][$row['flvl']][$row['flvl']][$row['fexp']][$row['blvl']][$row['bexp']][$row['tlvl']][$row['texp']][$row['clvl']][$row['cexp']][$row['elvl']][$row['eexp']];
                        }
                        $result->close();
                }else{
                        printf("Errormessage: %s\n", $mysqli->error);
                        return false;
                }
        }
        protected function fetch_stats_full(){
                if ($result = $this->mysqli->query($this->query)) {
                        $i=0;
                        while ($row = $result->fetch_assoc()) {
                            $this->players[$row['player']][$row['mlvl']][$row['mexp']][$row['wlvl']][$row['wexp']][$row['flvl']][$row['flvl']][$row['fexp']][$row['blvl']][$row['bexp']][$row['tlvl']][$row['texp']][$row['clvl']][$row['cexp']][$row['elvl']][$row['eexp']];
                        }
                        $result->close();
                }else{
                        printf("Errormessage: %s\n", $mysqli->error);
                        return false;
                }
        }

        function get_stats(){
                //get the stuff
                if ($_GET['search']){

                        $this->search = $_GET['search'];
                        $filter = "WHERE `player` LIKE '".$this->search."%' ORDER BY `player` ASC";
                }
                else {
                }
                $this->query = ("SELECT * FROM `".$this->config['table_stats']."` ".$filter.";");
                $this->fetch_stats();
                //
                $this->query = "SELECT `player`, `mlvl`, `mexp` FROM `".$this->config['table_stats']."` WHERE `mlvl` = 'Mining';";
                $mining = $this->fetch_array(1,'player');
                $this->query = "SELECT `player`, `wlvl`, `wexp` FROM `".$this->config['table_stats']."` WHERE `wlvl` = 'WoodCutting';";
                $woodcutting = $this->fetch_array(1,'player');
                $this->query = "SELECT `player`, `flvl`, `fexp` FROM `".$this->config['table_stats']."` WHERE `flvl` = 'Farming';";
                $farming = $this->fetch_array(1,'player');
                $this->query = "SELECT `player`, `blvl`, `bexp` FROM `".$this->config['table_stats']."` WHERE `blvl` = 'Building';";
                $Building = $this->fetch_array(1,'player');
                $this->query = "SELECT `player`, `tlvl`, `texp` FROM `".$this->config['table_stats']."` WHERE `tlvl` = 'Training';";
                $Training = $this->fetch_array(1,'player');
                $this->query = "SELECT `player`, `clvl`, `cexp` FROM `".$this->config['table_stats']."` WHERE `clvl` = 'Combatant';";
                $Combatant = $this->fetch_array(1,'player');
                $this->query = "SELECT `player`, `elvl`, `eexp` FROM `".$this->config['table_stats']."` WHERE `elvl` = 'Electrician';";
                $Electrician = $this->fetch_array(1,'player');
            }


                       /*

                        //put in the damage stuff seperatly
                        if($mining[$name])
                        {
                            $this->players[$name]['Mining'] = $mining[$name];
                        }
                        else {$this->players[$name]['Mining'] = 0;}
                        if ($woodcutting[$name]){$this->players[$name]['Mining'] = $woodcutting[$name];}
                        else {$this->players[$name]['woodcutting'] = 0;}
                        if ($farming[$name]){$this->players[$name]['farming'] = $farming[$name];}
                        else {$this->players[$name]['farming'] = 0;}
                        if ($Building[$name]){$this->players[$name]['Building'] = $Building[$name];}
                        else {$this->players[$name]['Building'] = 0;}
                        if ($Training[$name]){$this->players[$name]['Training'] = $Training[$name];}
                        else {$this->players[$name]['Training'] = 0;}
                        if ($Combatant[$name]){$this->players[$name]['Combatant'] = $Combatant[$name];}
                        else {$this->players[$name]['Combatant'] = 0;}
                        if ($Electrician[$name]){$this->players[$name]['Electrician'] = $Electrician[$name];}
                        else {$this->players[$name]['Electrician'] = 0;}



                        //build sort arrays
                        $Mining[]               = $this->players[$name]['Mining'];
            $woodcutting[]              = $this->players[$name]['woodcutting'];
                        $farming[]              = $this->players[$name]['farming'];
                        $Building[]             = $this->players[$name]['Building'];
                        $Training[]             = $this->players[$name]['Training'];
                        $Combatant[]            = $this->players[$name]['Combatant'];
                        $Electrician[]          = $this->players[$name]['Electrician'];


                //sort it if wanted
                if ($_GET['sort']){
                array_multisort($$_GET['sort'], SORT_DESC, $this->players);
                }
                */
        }

        ?>