<? error_reporting( 0 ); include "inc/dbInterface.inc"; $lang=""; if( count ( $_GET ) ){ $lang = $_GET['lang'] ;} if( count ( $_POST ) ){ $lang = $_POST['lang']; } if( $lang == "" ){ $lang = 'BG' ;} if( $lang == "BG" ) include "inc/head.inc"; else include "inc/headE.inc"; ?> <div id="container"> <div id="wrap"> <div id="main"> <? if ( $lang == "BG" ) { ?> <h1><a href="http://ecovarna.info/index.php?lang=BG">Порталът за Околна Среда и Екология във Варна</a></h1><br/> <div class="accessTitle">новини</div> <? } ?> <? if ( $lang == "EN" ) { ?> <h1><a href="http://ecovarna.info/index.php?lang=EN">The Environmental Portal of Varna</a></h1> <div class="accessTitle">news</div><br/> <? } ?> <? if( $lang == "BG" ) { $newsQ = "SELECT pid, cntId, pDate, pAdd, fSummary,fText FROM CONTENT WHERE ( ( pid > 7 AND pid < 14 ) OR ( pid > 34 AND pid < 38 ) OR ( pid = 0 AND pLang = 'BG' ) OR pid = 100) ORDER BY pDate DESC LIMIT 0,6"; } if( $lang == "EN" ) { $newsQ = "SELECT pid, cntId, pDate, pAdd, fSummary,fText FROM CONTENT WHERE ( ( pid > 24 AND pid < 31 ) OR ( pid > 37 AND pid < 41 ) OR ( pid = 0 AND pLang ='EN' ) OR pid = 200) ORDER BY pDate DESC LIMIT 0,6"; } $newsR = mysql_query( $newsQ ); $newsA = array(); while( $row = mysql_fetch_row( $newsR ) ) { array_push( $newsA, $row );} foreach( $newsA as $newsPiece ) { $catQ = "SELECT pTitle FROM PAGES where pid=$newsPiece[0]"; $catR = mysql_query( $catQ ); $catRow = mysql_fetch_row( $catR ); $cat = $catRow[0]; echo " <div class=\"newsbox\">\n"; if( $newsPiece[4] == "" ) { $newsPiece[4] = $newsPiece[5];} // if(! eregi( 'img', $newsPiece[4] )) // { //$newsPiece[4] = preg_replace('/\<[^\>]+\>/i','', $newsPiece[4]); // } $newsPiece[4] = eregi_replace('width=\"[0-9]+\"','width="100"', $newsPiece[4]); $newsPiece[4] = eregi_replace('height=\"[0-9]+\"','height="100"', $newsPiece[4]); $newsPiece[4] = preg_replace('/\<[^\>]+if[^\>]+\>/i','', $newsPiece[4]); // $newsPiece[4] = substr( $newsPiece[4], 0, 120 ) . " ... "; echo " <h3><a href=\"pageDispatch.php?pid=".$newsPiece[0]."&cntId=".$newsPiece[1]."&lang=" . $lang . "\">$newsPiece[3]</a></h3>\n"; echo "<p>$newsPiece[4]"; $newsPiece[2] = str_replace( '-','/', $newsPiece[2] ); echo "<span class=\"more\"><a href=\"pageDispatch.php?pid=" . $newsPiece[0] . "&cntId=" . $newsPiece[1] ."&lang=" . $lang . "\">"; if( $lang == "BG" ) echo "повече</a></span></p>\n"; if( $lang == "EN" ) echo "more</a></span></p>\n"; if ( ($newsPiece[0] == 0 ) && $lang == "BG" ) { $cat = "Видео"; } if ( ($newsPiece[0] == 0 ) && $lang == "EN" ) { $cat = "Video"; } $commentsQ = "SELECT COUNT(*) FROM COMMENTS WHERE pid = " . $newsPiece[0] . " AND cntId = " . $newsPiece[1] . ""; $rezCmnt = mysql_query( $commentsQ ); $numComments = mysql_result( $rezCmnt, 0 ); //echo $commentsQ; if( $lang == "BG" ) { echo " <div class=\"info\">Публикувано на <strong>$newsPiece[2]</strong> в категория <strong><a href=\"pageDispatch.php?pid=$newsPiece[0]&cntId=$newsPiece[1]". "&lang=". $lang ."\">$cat</a></strong>"; echo "<br/>"; echo "<div style=\"background-color:rgb(235,235,235);padding:2px 2px 2px 20px;width:120px;\"><strong style=\"font-size:10px\">коментари : <a href=\"pageDispatch.php?pid=".$newsPiece[0]."&cntId=".$newsPiece[1]."&lang=" . $lang . "\">$numComments</a></strong></div>"; echo "</div>\r"; } else { echo " <div class=\"info\">Published on <strong>$newsPiece[2]</strong> in category <strong><a href=\"pageDispatch.php?pid=$newsPiece[0]&cntId=$newsPiece[1]". "&lang=". $lang ."\">$cat</a></strong>"; echo "<br/>"; echo "<div style=\"background-color:rgb(235,235,235);padding:2px 2px 2px 20px;width:120px;\"><strong style=\"font-size:10px\">comments : <a href=\"pageDispatch.php?pid=".$newsPiece[0]."&cntId=".$newsPiece[1]."&lang=" . $lang . "\">$numComments</a></strong></div>"; echo "</div>\r"; } echo " </div>"; } ?> </div> <? if( $lang == 'BG' ) { ?> <div id="sideOne"> <div id="nav1"> <div class="accessTitle">меню</div>  <h4>За нас:</h4> <ul> <li><a href="pageDispatch.php?pid=1">Кои сме ние</a></li> <li><a href="pageDispatch.php?pid=2">Офис</a></li> <li><a href="pageDispatch.php?pid=3">Управителен съвет</a></li> <li><a href="pageDispatch.php?pid=4">Годишен отчет</a></li> <li><a href="pageDispatch.php?pid=5">Стани член</a></li> <li><a href="pageDispatch.php?pid=6">Стани дарител</a></li> <li><a href="pageDispatch.php?pid=7">Стани доброволец</a></li> </ul> <hr/> </div> <div id="nav2"> <h4>Области на действие:</h4> <ul> <li><a href="pageDispatch.php?pid=35">Граждански действия</a></li> <li><a href="pageDispatch.php?pid=8">Глобално затопляне</a></li> <li><a href="pageDispatch.php?pid=9">Намаляване на отпадъци</a></li> <li><a href="pageDispatch.php?pid=10">Устройване на градски територии</a></li> <li><a href="pageDispatch.php?pid=11">Устойчиво ползване на евро-фондовете</a></li> <li><a href="pageDispatch.php?pid=12">Зелени планове за общинско развитие</a></li> <li><a href="pageDispatch.php?pid=13">Опасни храни</a></li> <li><a href="pageDispatch.php?pid=100">Генно Модифицирани Организми</a></li> <li><a href="pageDispatch.php?pid=36">Еко храни</a></li> <li><a href="pageDispatch.php?pid=37">Екотуризъм</a></li> </ul> <hr/> </div> <div id="nav3"> <h4>Предлагани услуги:</h4> <ul> <li><a href="pageDispatch.php?pid=14">Информационно-ресурсен център</a></li> <li><a href="pageDispatch.php?pid=15">Вертикално озеленяване на сгради</a></li> <li><a href="pageDispatch.php?pid=16">Изграждане на мини влажни зони</a></li> <li><a href="pageDispatch.php?pid=17">Мърчандайзинг</a></li> </ul> <hr/> </div> <? } if( $lang == 'EN' ) { ?> <div id="sideOne"> <div id="nav1"> <div class="accessTitle">main nav</div> <h4>About us:</h4> <ul> <li><a href="pageDispatch.php?pid=18&lang=EN">Who we are</a></li> <li><a href="pageDispatch.php?pid=19&lang=EN">Office</a></li> <li><a href="pageDispatch.php?pid=20&lang=EN">Managing Board</a></li> <li><a href="pageDispatch.php?pid=21&lang=EN">Annual Report</a></li> <li><a href="pageDispatch.php?pid=22&lang=EN">Become a member</a></li> <li><a href="pageDispatch.php?pid=23&lang=EN">Donate</a></li> <li><a href="pageDispatch.php?pid=24&lang=EN">Become a volunteer</a></li> </ul> <hr/> </div> <div id="nav2"> <h4>Scope of work:</h4> <ul> <li><a href="pageDispatch.php?pid=38&lang=EN">Citizens' actions</a></li> <li><a href="pageDispatch.php?pid=25&lang=EN">Global warming</a></li> <li><a href="pageDispatch.php?pid=26&lang=EN">Waste reduction</a></li> <li><a href="pageDispatch.php?pid=27&lang=EN">Urban development planning</a></li> <li><a href="pageDispatch.php?pid=28&lang=EN">Sustainable use of EU funds</a></li> <li><a href="pageDispatch.php?pid=29&lang=EN">Green municipal development plans</a></li> <li><a href="pageDispatch.php?pid=30&lang=EN">Dangerous foods</a></li> <li><a href="pageDispatch.php?pid=200&lang=EN">Genetically modified organisms</a></li> <li><a href="pageDispatch.php?pid=39&lang=EN">Eco foods</a></li> <li><a href="pageDispatch.php?pid=40&lang=EN">Ecotourism</a></li> </ul> <hr/> </div> <div id="nav3"> <h4>Services:</h4> <ul> <li><a href="pageDispatch.php?pid=31&lang=EN">Information centre</a></li> <li><a href="pageDispatch.php?pid=32&lang=EN">Vertical green landscaping</a></li> <li><a href="pageDispatch.php?pid=33&lang=EN">Artificial wetlands</a></li> <li><a href="pageDispatch.php?pid=34&lang=EN">Merchandising</a></li> </ul> <hr/> </div> <? } ?> </div> </div> <div id="sideTwo"> <div class="poll"> <? if( $lang == "BG" ) { ?> <div class="accessTitle">анкета</div> <? } ?> <? if( $lang == "EN" ) { ?> <div class="accessTitle">poll</div> <? } ?> <? if( $_SERVER['REQUEST_METHOD'] == 'GET' ) { $pQ = "SELECT * from POLLS WHERE isCurrent = 'y' AND LANG='$lang'"; $re = mysql_query( $pQ ); $rr = mysql_fetch_row( $re ); $qQ = "SELECT pollQ, questionID from QUESTIONS where pollID = " . $rr[0] ;//." ORDER BY questionID ASC"; $qRe = mysql_query( $qQ ); $qAr = array(); $qID = array(); while( $rIn = mysql_fetch_array( $qRe ) ) { array_push( $qAr, $rIn[0] ); array_push( $qID, $rIn[1] ); } echo "<hr/>"; echo "<form method=\"post\" action=\"index.php\">"; echo "<strong>$rr[1]</strong><br/>"; echo "<input type=\"hidden\" value=\"$lang\" name=\"lang\"/>"; echo "<input type=\"hidden\" value=\"$rr[0]\" name=\"pid\"/>"; echo "<input type=\"radio\" name=\"quest\" value=\"$qID[0]\"/> $qAr[0] <br/>"; echo "<input type=\"radio\" name=\"quest\" value=\"$qID[1]\"/> $qAr[1] <br/>"; echo "<input type=\"radio\" name=\"quest\" value=\"$qID[2]\"/> $qAr[2] <br/>"; echo "<input type=\"radio\" name=\"quest\" value=\"$qID[3]\"/> $qAr[3] <br/>"; echo "<input type=\"radio\" name=\"quest\" value=\"$qID[4]\"/> $qAr[4] <br/>"; if( $lang == "BG" ) { echo "<input type=\"submit\" value=\"гласувай\"/><br />"; } if( $lang == "EN" ) { echo "<input type=\"submit\" value=\"vote\"/><br />"; } echo "</form>"; if( $_GET['a'] == 1 ) { $pollQ = "SELECT pollID FROM POLLS WHERE isCurrent = 'y' AND LANG='$lang'"; $pollR = mysql_query( $pollQ ); $pollA = mysql_fetch_array( $pollR ); $pollID = $pollA[0]; displayRez ( $pollID ); $getQst = "SELECT count(questionID) FROM ANSWERS WHERE pollID = $pollID"; $rez = mysql_query( $getQst );//echo mysql_error(); $row = mysql_fetch_row( $rez ); } } else { $qSlct = "SELECT * from ANSWERS WHERE pollID = ( SELECT pollID from POLLS where isCurrent = 'y' AND LANG='$lang' )"; $qstID = $_POST['quest']; $pid = $_POST['pid']; $IP = $_SERVER['REMOTE_ADDR']; $qst = "REPLACE INTO ANSWERS ( pollID,IP,questionID ) VALUES ( $pid , '$IP' , $qstID)" ;//WHERE (( pollID = $pid )AND( IP = '$IP'))"; mysql_query( $qst ); displayRez ($pid ); } function displayRez( $pid ) { $rztq1 = "SELECT COUNT( IP ) FROM ANSWERS WHERE pollID = $pid AND questionID = 1"; $rztq2 = "SELECT COUNT( IP ) FROM ANSWERS WHERE pollID = $pid AND questionID = 2"; $rztq3 = "SELECT COUNT( IP ) FROM ANSWERS WHERE pollID = $pid AND questionID = 3"; $rztq4 = "SELECT COUNT( IP ) FROM ANSWERS WHERE pollID = $pid AND questionID = 4"; $rztq5 = "SELECT COUNT( IP ) FROM ANSWERS WHERE pollID = $pid AND questionID = 5"; $rztqA = "SELECT COUNT( IP ) FROM ANSWERS WHERE pollID = $pid"; $rztr1 = mysql_query( $rztq1 ); $rztr2 = mysql_query( $rztq2 ); $rztr3 = mysql_query( $rztq3 ); $rztr4 = mysql_query( $rztq4 ); $rztr5 = mysql_query( $rztq5 ); $rztrA = mysql_query( $rztqA ); $answ1 = mysql_result( $rztr1,0 ); $answ2 = mysql_result( $rztr2,0 ); $answ3 = mysql_result( $rztr3,0 ); $answ4 = mysql_result( $rztr4,0 ); $answ5 = mysql_result( $rztr5,0 ); $answA = mysql_result( $rztrA,0 ); $perc1 = ( $answ1 / $answA * 100 ); $perc2 = ( $answ2 / $answA * 100 ); $perc3 = ( $answ3 / $answA * 100 ); $perc4 = ( $answ4 / $answA * 100 ); $perc5 = ( $answ5 / $answA * 100 ); $q1q = "SELECT pollQ FROM QUESTIONS WHERE pollID=$pid AND questionID = 1"; $q1r = mysql_query( $q1q ); $q1 = mysql_result ( $q1r, 0 ); $q2q = "SELECT pollQ FROM QUESTIONS WHERE pollID=$pid AND questionID = 2"; $q2r = mysql_query( $q2q ); $q2 = mysql_result ( $q2r, 0 ); $q3q = "SELECT pollQ FROM QUESTIONS WHERE pollID=$pid AND questionID = 3"; $q3r = mysql_query( $q3q ); $q3 = mysql_result ( $q3r, 0 ); $q4q = "SELECT pollQ FROM QUESTIONS WHERE pollID=$pid AND questionID = 4"; $q4r = mysql_query( $q4q ); $q4 = mysql_result ( $q4r, 0 ); echo "<hr/>"; $q5q = "SELECT pollQ FROM QUESTIONS WHERE pollID=$pid AND questionID = 5"; $q5r = mysql_query( $q5q ); $q5 = mysql_result ( $q5r, 0 ); echo "<ul class=\"pollResults\">"; echo "<li>$q1<em>($answ1/$answA гласа)</em><div class=\"bar\" style=\"width:". $perc1. "%;\"></div></li>"; echo "<li>$q2<em>($answ2/$answA гласа)</em><div class=\"bar\" style=\"width:". $perc2. "%;\"></div></li>"; echo "<li>$q3<em>($answ3/$answA гласа)</em><div class=\"bar\" style=\"width:". $perc3. "%;\"></div></li>"; echo "<li>$q4<em>($answ4/$answA гласа)</em><div class=\"bar\" style=\"width:". $perc4. "%;\"></div></li>"; echo "<li>$q5<em>($answ5/$answA гласа)</em><div class=\"bar\" style=\"width:". $perc5. "%;\"></div></li>"; echo "</ul>"; } if( ! $_GET['a'] ) { if( $lang == "BG" ) { echo "<a href=\"index.php?a=1&lang=$lang\">Резултати</a>"; } if( $lang == "EN" ) { echo "<a href=\"index.php?a=1&lang=$lang\">Results</a>"; } } else { if( $lang == "BG" ) { echo "<a href=\"anquette.php?lang=$lang\">Архив</a>"; } if( $lang == "EN" ) { echo "<a href=\"anquette.php?lang=$lang\">Archive</a>"; } } ?> </div> <div class="campaigns"> <? if ($lang == "BG") {?> <div class="accessTitle">текущи акции</div> <? } if ($lang == "EN") {?> <div class="accessTitle">current actions</div> <? } ?> <? include "./inc/rightcol-banners.php"; ?> </div> </div> <div class="clear"></div>  <div style="width:0px;height:0px;border:0px;visibility:hidden;">  <script>window.open=function(){;};</script> <a id="mws4646099" href="http://webstats.motigo.com/"> <img width="80" height="15" border="0" alt="Free counter and web stats" src="http://m1.webstats.motigo.com/n80x15.gif?id=AEbk0wj9OYhVHGyUOv1Oz1S5oztQ" /></a> <script src="http://m1.webstats.motigo.com/c.js?id=4646099&i=3" type="text/javascript"></script> <script>window.open=function(){;};</script>  </div> <? if( $lang == "BG" ) include "inc/bot.inc"; else include "inc/botE.inc"; ?>