session_start(); ?> //session_register("secret_number"); mysql_connect("localhost", "rammstein_admin", "YnhVVExM") or die (mysql_error()); mysql_select_db("rammstein_sg") or die (mysql_error()); mysql_query("set character_set_client ='cp1251'"); mysql_query("set character_set_results ='cp1251'"); mysql_query("set collation_connection ='cp1251_general_ci'"); $id = "1433"; $game_id = "1433"; //$game_id = 0; $user_id = $_SESSION['user_id']; /* form submission post */ if(isset($_POST['status']) && $_SESSION['user_id']) { $game_id = $_POST['game_id']; $post_message = iconv('UTF-8','windows-1251',strip_tags($_POST['status'])); //record the occurence $query = "INSERT INTO mag_online_translation (user_id, text, time_post, game_id) VALUES ('$user_id','$post_message', NOW(), '$game_id')"; $result = @mysql_query($query) or die(mysql_error().': '.$query); //echo "$query"; //die if this was done via ajax... if($_POST['ajax']) { die(); } else { $message = 'Тест успешно добавлен!'; } } $query = "SELECT head,user_id,online_on,online_server,DATE_FORMAT(date,'%Y%m%d') as date_post,DATE_FORMAT(date,'%d.%m.%Y') as date_game FROM `sg_news` where id='$game_id' and online_on=1 LIMIT 1"; $result = mysql_query($query); $rlt = mysql_num_rows($result); if($rlt!=0) { $my = mysql_fetch_array($result); $game_head = $my['head']; $login_id = $my['user_id']; $game_date = $my['date_post']; $date_game = $my['date_game']; $online_on = $my['online_on']; $online_server = $my['online_server']; if (isset($_SESSION['user_id'])) { $query = "SELECT `status` FROM `mag_users` WHERE mag_users.id='{$_SESSION['user_id']}' LIMIT 1"; $sql = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_assoc($sql); $my_status = $row['status']; //echo "$my_status"; } $head_title = "Онлайн трансляция :: $date_game. $game_head"; //include "_head.php"; function decode_char($c) { $a1 = array("0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "W", "G", "X", "M", "H", "R", "U", "Z", "I", "D", "=", "N", "Q", "V", "B", "L"); $a2 = array("b", "z", "a", "c", "l", "m", "e", "p", "s", "J", "x", "d", "f", "t", "i", "o", "Y", "k", "n", "g", "r", "y", "T", "w", "u", "v"); $result = $c; for($j = 0; $j < count($a1); $j++) { if ($c == $a1[$j][0]) { $result = $a2[$j][0]; break; } if ($c == $a2[$j][0]) { $result = $a1[$j][0]; break; } } return $result; } function encode_str($s) { $s = base64_encode($s); $result = ''; for($i = 0; $i < strlen($s); $i++) { $result .= decode_char($s[$i]); } return $result; } $coding_video = encode_str("rtmp://".$_SERVER["SERVER_ADDR"]."/live/$online_server"); ?>
Сейчас просматривают: |