ini_set("display_errors", 0); session_start(); function connect($connection_data) { $db_server_connect_error="Nepodarilo sa pripojiť k databázovému serveru."; // nastavenie hlasky pri neuspechu o pripojenie k serveru $db_open_error="Nepodarilo sa otvoriť databázu."; // nastevenie hlasky pri neuspechu o otvorenie databazy mysql_pconnect($connection_data['server'], $connection_data['login'], $connection_data['password'])or die($db_server_connect_error); // pripojenie k databaze mysql_query('SET NAMES UTF8'); // nastavenie kodovania mysql_query('SET COLLATION_CONNECTION=UTF8_GENERAL_CI'); // nastavenie znakovej stranky mysql_select_db($connection_data['database']) or die($db_open_error); // oznacenie konkretnej databazy na serveri } $connection['server']="sql14.hostcreators.sk:3319"; $connection['login']="u41882_multined"; $connection['password']="77Rp7!_pcf5H!!PM"; $connection['database']="d41882_multined"; connect($connection); function verify_login($identifier="", $password="", $type="") { if(!$type) $type="id"; switch($type) { case 'login': $result=mysql_query("SELECT id FROM participants WHERE login='".$identifier."' AND password='".$password."'"); break; case 'id': $result=mysql_query("SELECT id FROM participants WHERE id='".$identifier."' AND password='".$password."'"); break; default: $result=mysql_query("SELECT id FROM participants WHERE id='".$identifier."' AND password='".$password."'"); } $answer=mysql_fetch_array($result, MYSQL_ASSOC); if(!IsSet($answer['id'])) $answer['id']=null; return $answer['id']; } function verify_user($login="", $password="") { if($login) { if($password) { $user_id=verify_login($login, md5($password), "login"); if($user_id) { $_SESSION['user_id']=$user_id; $_SESSION['password']=md5($password); $message="Boli ste úspešne prihlásení"; } else { $_SESSION['user_id']=""; $_SESSION['password']=""; $message="Chybné prihlasovacie údaje."; } } else { $_SESSION['user_id']=""; $_SESSION['password']=""; $message="Prosím, zadajte heslo"; } } if($_SESSION['user_id'] AND $_SESSION['password']) { $user_id=verify_login($_SESSION['user_id'], $_SESSION['password'], "id"); if(!$user_id) { $_SESSION['user_id']=""; $_SESSION['password']=""; } } else { $_SESSION['user_id']=""; $_SESSION['password']=""; } if((IsSet($_GET['logout']) AND $_GET['logout']) OR (IsSet($_POST['logout']) AND $_POST['logout']) OR (IsSet($logout) AND $logout)) { $_SESSION['user_id']=""; $_SESSION['password']=""; $message="Boli ste úspešne odhlásení."; } } verify_user($_POST['login'], $_POST['password']); if(IsSet($_POST['language']) AND ($_POST['language']=="en" OR $_POST['language']=="hu")) $_SESSION['language']=$_POST['language']; if(!IsSet($_SESSION['language'])) $_SESSION['language']="en"; if(IsSet($_SESSION['language']) AND ($_SESSION['language']=="en" OR $_SESSION['language']=="hu")) $language=$_SESSION['language']; else $language="en"; ?>