<?php
require("config.php");
$spojeni = mysql_connect("$m_server","$m_user","$m_password");
mysql_select_db("$m_db", $spojeni);

$con_users = mysql_query("SELECT * FROM `cp_users` WHERE `username` = '".$_SESSION["nick"]."' LIMIT 1", $spojeni);
$info_users = mysql_fetch_array($con_users);

 $user_ip_adressess = $_SERVER["REMOTE_ADDR"];
date_default_timezone_set("Europe/Bratislava");
$mytime     = date("d.m.Y H:i:s");
$mytime_server     = date("H:i:s");
$mytime_tickets     = date("H:i, d.m.Y");
$commenttime     = date("d.m.Y, H:i");
 $tticketday     = date("d.m.Y");
$ttickethour     = date("H:i");


// ----------------------- | Groups | ------------------------ //

        $user_group = $info_users["group"];
    if($user_group == "0")    { $user_group_name = 'Zákazník'; $user_group_styles = ' '; }

    if($user_group == "1")    { $user_group_name = 'V.I.P. Zákazník'; $user_group_styles = ' '; }

    if($user_group == "2")    { $user_group_name = 'Sponzoring'; $user_group_styles = ' '; }

    if($user_group == "3")    { $user_group_name = 'Zákaznícka podpora'; $user_group_styles = 'color:#2f9a17;'; }

    if($user_group == "4")    { $user_group_name = 'Administrátor'; $user_group_styles = 'color:#dd9031;'; }

    if($user_group >= "5")    { $user_group_name = 'Majiteľ'; $user_group_styles = 'color:#df5f5f;';}

// -------------------- | Credits info | -------------------- //

        $cp_user_credits = $info_users["credits"];
    if($cp_user_credits >= "0")    { $user_credits_name = 'danger'; }

    if($cp_user_credits >= "15")    { $user_credits_name = 'primary';  }

    if($cp_user_credits >= "50")    { $user_credits_name = 'default';  }

    $credits_show = "<h5 style='text-align:right;float:right;'>Stav konta: <strong><a href='/control_panel/credits/buy'><span class='h3 label label-$user_credits_name' style='font-size:13px;'>$info_users[credits] €</span></a></strong></h5>";

// ----------------------- | User status | ----------------------- //

        $active_status = $info_users["active"];
    if($active_status == "0")    { $active_status_on = 'Neaktivovaný'; $active_status_color = "orange"; }

    if($active_status == "1")    { $active_status_on = 'Aktívny'; $active_status_color = "green"; }

// --- | Functions | --- //
$client_ip = $_SERVER["REMOTE_ADDR"];
function Nebezpeci($jaky) { if(!strstr($jaky, '<') && !strstr($jaky, '>') && !strstr($jaky, '$') && !strstr($jaky, '"') && !strstr($jaky, "'") && !strstr($jaky, "`") && !strstr($jaky, ";") && !strstr($jaky, "+") && !strstr($jaky, "ě") && !strstr($jaky, "š") && !strstr($jaky, "č") && !strstr($jaky, "ř") && !strstr($jaky, "ž") && !strstr($jaky, "ý") && !strstr($jaky, "á") && !strstr($jaky, "í") && !strstr($jaky, "é") && !strstr($jaky, "=") && !strstr($jaky, "¨") && !strstr($jaky, "ú") && !strstr($jaky, "§") && !strstr($jaky, "@") && !strstr($jaky, "©") && !strstr($jaky, "™") && !strstr($jaky, ";") && !strstr($jaky, "›") && !strstr($jaky, "+") && !strstr($jaky, "*") && !strstr($jaky, "Ă") & !strstr($jaky, "%") && !strstr($jaky, ".") && !strstr($jaky, "/") && !strstr($jaky, "\\")) {  } else { Chyba('Nemozete zadavat znaky s diagritikou ( Bez uvozoviek, lomitok, ciariek  ).'); exit(); }}
function AddLogAcc($title,$event,$icon,$type) { $vysledek = mysql_query("INSERT INTO `cp_userlog` (`ID` , `title`,`username` ,`message` , `site`, `time`, `ip`, `icon` ,`type`)VALUES ('', '".mysql_real_escape_string($title)."','".$_SESSION["userid"]."', '".mysql_real_escape_string($event)."', '".$page_uri."', 'xxxx', '".$_SERVER["REMOTE_ADDR"]."', '".mysql_real_escape_string($icon)."', '".mysql_real_escape_string($type)."')"); }
function AddLog($title,$event,$site,$icon,$type) { $vysledek = mysql_query("INSERT INTO `cp_userlog` (`ID` , `title`,`username` ,`message` , `site`,`time`,`ip`,`icon` ,`type`)VALUES ('', '".mysql_real_escape_string($title)."','".$_SESSION["nick"]."', '".mysql_real_escape_string($event)."', '$actual_address', NOW(), '".$_SERVER["REMOTE_ADDR"]."', '".mysql_real_escape_string($icon)."', '".mysql_real_escape_string($type)."')"); }
function AddAdminLog($action) { $vysledek = mysql_query("INSERT INTO `ap_logs` (`id` , `user`,`ip` ,`time` , `action`)VALUES ('', '".$_SESSION["nick"]."','".$_SERVER["REMOTE_ADDR"]."', NOW(), '".mysql_real_escape_string($action)."')"); }
function ref_page($kam,$kedy) { echo '<meta http-equiv="refresh" content="'.$kedy.';url='.$kam.'">'; }
function CheckLine($path, $variable) { if(file_exists($path)) { $lines = file($path); $result = "";foreach($lines as $line){$contents = explode(' ', $line, 2);if($contents[0] == $variable){$result = $contents[1];$order = array("\r\n", "\n", "\r"); $result = str_replace($order, "", $result);break;}}return $result;}}
function Secure($code) { return mysql_real_escape_string(HTMLSpecialChars($code)); }



function generate_password( $length = 8 ) {
$chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789?";
$password = substr( str_shuffle( $chars ), 0, $length );
return $password;
}


function Warning($text) {
echo "<div class='alert alert-warning alert-warning-rw' role='alert'><i class='fa fa-exclamation'></i>&nbsp;&nbsp; $text</div>";
}

function Info($text) {
echo "<div class='alert alert-primary alert-styled-left'>
       <span class='text-semibold'>$text</div>";
}
function Chyba($text)
{
echo "<div class='alert alert-danger alert-styled-left alert-bordered'>
      <span class='text-semibold'>$text</div>";
 }
function Ok($text)
{
echo "<div class='alert alert-success alert-styled-left alert-arrow-left alert-bordered'>
<span class='text-semibold'>$text</div>"; }

$previous = "javascript:history.go(-3)";
if(isset($_SERVER['HTTP_REFERER'])) {
    $previous = $_SERVER['HTTP_REFERER'];
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'smtp_email' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$publicemail = $hodnota;

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'smtp_password' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$publicemailpassword = $hodnota;

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'title' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$web_title = $hodnota;

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'name' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$web_name = $hodnota;

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'description' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$web_description = $hodnota;


////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'keywords' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$web_keywords = $hodnota;

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'text_logo' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$web_logo = $hodnota;

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'footer' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$web_footer = $hodnota;

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'url_link' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$web_ulink = $hodnota;


////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'vip_link' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$web_viplink = $hodnota;


////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'query_link' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$web_querylink = $hodnota;

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'mail_user' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$MainMail_user = $hodnota;


////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$zistinastavenia = mysql_query("SELECT * FROM `cp_config` WHERE `name` = 'mail_password' LIMIT 1", $spojeni);
$nastavenia = mysql_fetch_array($zistinastavenia);
$hodnota = $nastavenia["value"];
$MainMail_password = $hodnota;

?>