$g_link = mysqli_connect('localhost','geochess_us','*e%v~0(H([Rn','geochess_db') or die('შეცდომა, ვერ დაუკავშირდი მონაცემთა ბაზას.');
include_once("config.php");
if(!defined('N5G11111585')) die("");
ParseURL();
ob_start();
CallModule($LOAD_MODULE);
$PAGE_CONTENT=ob_get_clean();
if(isset($_POST["add_vote"]) && $_POST["VOTE"])
{
$q_id=intval($_POST["q_id"]);
$VOTE=intval($_POST["VOTE"]);
if(!$SQL->GetDBFieldCount("question_ip","ip='".GetUserIp()."' AND question_id='".$q_id."'"))
{
$SQL->Query("UPDATE question_answer SET votes=votes+1 WHERE id='$VOTE'");
$SQL->Query("INSERT INTO question_ip (ip,question_id,answer_id) VALUES ('".GetUserIp()."','$q_id','$VOTE')");
}
}
$reg_for_news_msg='';
$email=trim(strtolower($_POST["news_to_email"]));
if(isset($_POST["reg_for_news"]) && $email)
{
if(!preg_match("/\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*/",$email)) $reg_for_news_msg=$LANG_ARRAY["LNG_EL_FOSTA_ARASWORIA"];
else if($SQL->GetDBFieldCount("news_to_email","email='$email'")) $reg_for_news_msg=$LANG_ARRAY["LNG_EL_FOSTA_UKVE_DAREGISTRIREBULIA"];
else
{
$SQL->Query("INSERT INTO news_to_email (email) VALUES ('$email')");
$reg_for_news_msg=$LANG_ARRAY["LNG_TQVEN_MIIGEBT_SIAXLEEBS_EL_FOSTAZE"].' : '.$email.' '.mysqli_error();
}
}
?>
echo strip_tags($WEBSITE_TITLE);?>
style="background-color:#FFF" }?>>
if(isset($_GET["popup"]))
{
?>
}
else
{
?>
$langArray = array();
if($conf->lang_geo)
$langArray[] = $conf->lang_geo;
if($conf->lang_eng)
$langArray[] = $conf->lang_eng;
if($conf->lang_rus)
$langArray[] = $conf->lang_rus;
if(count($langArray)>0)
{
?>
}
?>
if($LOAD_MODULE=="mainpage")
{
?>
}
?>
echo GetBanner(4);?>
if($LOAD_MODULE!="trainers/account")
{
?>
echo $LANG_ARRAY["LNG_SEARCH"];?>
echo GetBanner(1);?>
$SQL->Query("SELECT * FROM videogallery WHERE is_main='1' ORDER BY id DESC");
if($SQL->RowCount())
{
?>
echo $LANG_ARRAY["LNG_MAIN_VIDEO"];?>
while($data=$SQL->FetchAssoc())
{
?>
';">
echo $data["title_".$_SESSION["LANG"]];?>
$youtubeVideo = new YouTube($data["videocode"]); echo $youtubeVideo->ShowImg(null,160,120);?>
}
?>
}
?>
$res=mysqli_query($g_link,"SELECT * FROM question WHERE quest_$_SESSION[LANG]!='' ORDER BY id DESC");
if(mysqli_num_rows($res))
{
?>
echo $LANG_ARRAY["LNG_QUESTION"];?>
$res=mysqli_query($g_link,"SELECT * FROM question WHERE quest_$_SESSION[LANG]!='' ORDER BY id DESC");
while($data=mysqli_fetch_assoc($res))
{
$ip_res=mysqli_query($g_link,"SELECT answer_id FROM question_ip WHERE ip='".GetUserIp()."' AND question_id='$data[id]'");
if(mysqli_num_rows($ip_res))
{
$ip=mysqli_fetch_assoc($ip_res);
$answer_id=$ip["answer_id"];
}
else $answer_id=0;
?>
if(!$answer_id)
{
?>
}
else
{
?>
echo $data["quest_".$_SESSION["LANG"]];?>
$votes_sum=0;
$SQL->Query("SELECT * FROM question_answer WHERE quest_id='$data[id]' ORDER BY id ASC");
while($data2=$SQL->FetchAssoc()) $votes_sum+=intval($data2["votes"]);
$SQL->Query("SELECT * FROM question_answer WHERE quest_id='$data[id]' ORDER BY id ASC");
while($data2=$SQL->FetchAssoc())
{
if(!intval($data2["votes"])) $percent=0;
else $percent=intval((intval($data2["votes"])*100)/$votes_sum);
?>
if($answer_id)
{
if($answer_id==$data2["id"]) echo " ";
}
?>
echo $data2["answer_".$_SESSION["LANG"]];?>
[ echo $percent;?>%] ( echo $data2["votes"];?>)
}
?>
}
?>
}
?>
}
?>
if($conf->facebook)
{
?>
}
?>
}
?>
}
?>