<?php

/**
 * Moduł public_panelgracza_bans_bans jest nieodłączną częścią panelu gracza.
 * Zakaz rozprowadzania aplikacji bez pozwolenia autora.
 * @package Invision Power Board
 * @author Mateusz Pater
 * @copyright teez
 * @version 1.0.0
 * @access public
 */
class public_panelgracza_bans_bans extends ipsCommand
{
		static function zamianaid($id)
		{
				$parts = explode(':', str_replace('STEAM_', '' , $id));
				return bcadd(bcadd('76561197960265728', $parts['1']), bcmul($parts['2'], '2'));
		}
		public function doExecute(ipsRegistry $registry)
		{
				/*Połączenie z bazą danych*/
                $this->lang->loadLanguageFile(array('public_bans'), 'panelgracza');

                $host = $this->settings['panelgracza_host'];
                $pass = $this->settings['panelgracza_pass'];
                $user = $this->settings['panelgracza_user'];
                $database = $this->settings['panelgracza_database'];


				$connection = @mysql_connect($host, $user, $pass) or die(mysql_error());
				$db = @mysql_select_db($database, $connection) or die(mysql_error());

                /*Stronnicowanie*/
				$perPage = 40;
				$start = intval($this->request['st']);
				$result = mysql_query("SELECT COUNT(*) as bid FROM sb_bans;");
              	$count = mysql_fetch_array($result);
				$pages = $this->registry->getClass('output')->generatePagination( array(  'totalItems'         => $count['bid'],
													'itemsPerPage'       => $perPage,
													'currentStartValue'  => $start,
													'baseUrl'            => "app=panelgracza&module=bans" ) );
				if($count['bid'] < $perPage + 1)
				{
					$pages = "<font color='grey'>Strona 1 z 1</font>";
				}

                /*Bany*/
				$o = mysql_query("SELECT * FROM `sb_bans` ORDER BY `bid` DESC LIMIT ".$start.",".$perPage."");
                while($row = mysql_fetch_array($o))
                {
                    $ban['nick'] = $row['name'];
                    $ban['admin'] = $row['admin_nick'];
                    $ban['typ'] = $row['ban_type'];
                    $ban['powod'] = $row['reason'];
                    $ban['nadany'] = $row['created'];
					$ban['koniec'] = $row['ends'];
                    $ban['server'] = $row['server_name'];
                    $ban['kicks'] = $row['ban_kicks'];
                    $ban['player_id'] = $row['authid'];
					$ban['steamcommunity'] = self::zamianaid($ban['player_id']);
                    $ban['ip'] = $row['ip'];
                    $ban['szczegoly'] = '<a href="" id="b_'.$row['bid'].'"><span class="ipsBadge ipsBadge_lightgrey">'.$this->lang->words['zobacz'].'</span></a>';
                    $czas = $row['length']/60;
                    $ban['bid'] = $row['bid'];
                    if($row['RemoveType'] == NULL)
                    {
                        $ban['apeluj'] = '<a href="index.php?app=panelgracza&module=apelacja?id='.$ban['bid'].'"><span class="ipsBadge ipsBadge_green">'.$this->lang->words['apelujodkary'].'</span></a>';
                    }
                    else
                    {
                        $ban['apeluj'] = '<span class="ipsBadge ipsBadge_grey">'.$this->lang->words['nic'].'</span>';
                    }

                    if($czas == "0")
                    {
                        $ban['czas'] = "".$this->lang->words['banstaly']."";
                    }
                    elseif($czas < "60")
                    {

                        $ban['czas'] = "".$czas." ".$this->lang->words['minut']."";
                    }
                    elseif($czas >= "60")
                    {
						$ban['__czas'] = $czas/60;
						$ban['czas'] = ''.$ban['__czas'].' '.$this->lang->words['godzin'].'';

					    if($ban['__czas'] == 168)
						{
								$ban['czas'] = ''.$this->lang->words['tydzien'].'';
						}
                    }
                    else
                    {
                       $ban['czas'] = "".$czas." ".$this->lang->words['minut']."";
                    }
                    $ban['RemoveType'] = $row['RemoveType'];

                    if($row['RemoveType'] == NULL)
                    {
                        $ban['expired'] = '<font color="red"><img src="{style_images_url}/delete.png"> '.$this->lang->words['aktywny'].' </font>';
                    }
                    elseif($row['RemoveType'] == "E")
                    {
                        $ban['expired'] = '<font color="green"><img src="{style_images_url}/accept.png"> '.$this->lang->words['wygasly'].' </font>';
                    }
					elseif($row['RemoveType'] == "U")
					{
                        $ban['expired'] = '<font color="green"><img src="{style_images_url}/accept.png"> '.$this->lang->words['wygasly'].' ('.$this->lang->words['unban'].') </font>';
						$ban['ureason'] = $row['ureason'];
						$ban['removedon'] = $row['RemovedOn'];
					}

                    $wynik[] = $ban;
                }



				/*Załadowanie contentu*/
				$this->registry->output->setTitle($this->lang->words['listabanow']);
				$this->registry->output->addNavigation($this->lang->words['listabanow'], null);
				$this->registry->output->addContent($this->registry->output->getTemplate('panelgracza')->bans($pages, $wynik));
				$this->registry->output->sendOutput();
		}
}