Parašė Lietuvos_pilietis· 2008 Geg. 19 19:05:29
#6
<?php
/*
Author: Kvasnikov Roman (RoN).
E-mail: romankw@mail.ru
HomePage: http://ron.net.ru
*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
require_once "includes/meeting_config_include.php";
if(!iMEMBER) redirect("nariai.php");
$reg=dbquery("SELECT `id` FROM ".$db_prefix."meeting WHERE `id`='".$userdata['user_id']."';");
if(!dbrows($reg)) dbquery("INSERT INTO ".$db_prefix."meeting(`id`, `login`) VALUES('".$userdata['user_id']."', '".$userdata['user_name']."');");
$past=time()-86400*$rate_day;
dbquery("DELETE FROM ".$db_prefix."meeting_poolcheck WHERE `time`<='".$past."';");
if(isset($_POST['submit_vote']))
{
if(!is_numeric($_POST['user_id'])) exit();
if(!isset($_POST['rate']) or !is_numeric($_POST['rate']) or $_POST['rate']>10 or $_POST['rate']<1) exit();
if($userdata['user_id']!=$_POST['user_id'])
{
if(!dbrows(dbquery("SELECT * FROM ".$db_prefix."meeting_poolcheck WHERE `id_vote_user`='".$_POST['user_id']."' AND `id_user`='".$userdata['user_id']."';")))
{
dbquery("INSERT INTO ".$db_prefix."meeting_poolcheck(`id_vote_user`, `id_user`, `time`) VALUES('".$_POST['user_id']."', '".$userdata['user_id']."', '".time()."');");
dbquery("UPDATE ".$db_prefix."meeting SET `votes`=`votes`+1, `rate`=`rate`+".$_POST['rate']." WHERE `id`='".$_POST['user_id']."';");
}
}
redirect("meeting.php?section=view&id=".$_POST['user_id']);
}
if(!isset($_GET['section']))
{
opentable("Susipažinkime: ankėtos paieška");
echo "<table border='0' align='center' width='100%' cellspacing='2' cellpadding='2' class='border'>
<tr><td align='center' class='header1' style='font-size: 11px;'><b>Paieška duomenų bazėje susipažinkime</b></td></tr>
<tr><td align='center'>
<table border='0' align='center' width='85%' cellspacing='2' cellpadding='2'>
<form action='".BASEDIR."meeting.php' method='get'>";
echo "<tr><td align='left' width='40%'>Aš:</td><td align='left' width='60%'><select name='i' class='textbox' style='width: 230px;'>
<option value='0'>Nėra pasirinkto</option>
<option value='1'>Vaikinas</option>
<option value='2'>Mergina</option>
<option value='3'>Pora V+M</option>
<option value='4'>Pora V+V</option>
<option value='5'>Pora M+M</option>
</select></td></tr>";
echo "<tr><td align='left' width='40%'>Ieškau:</td><td align='left' width='60%'><select name='sex' class='textbox' style='width: 230px;'>
<option value='0'>Nėra pasirinkto</option>
<option value='1'>Vaikino</option>
<option value='2'>Merginos</option>
<option value='3'>Poros V+M</option>
<option value='4'>Poros V+V</option>
<option value='5'>Poros M+M</option>
</select></td></tr>";
echo "<tr><td align='left' width='40%'>Ieškomas amžius:</td><td align='left' width='60%'>Nuo: <input type='text' name='age_1' class='textbox' style='width: 50px;'> Iki: <input type='text' name='age_2' class='textbox' style='width: 50px;'></td></tr>
<tr><td align='left' width='40%'>Ieškomas miestas:</td><td align='left' width='60%'><select name='city' class='textbox' style='width: 230px;'>";
for($i=0; $i<count($meeting_city); $i++)
echo "<option value='".$i."'>".$meeting_city[$i]."</option>";
echo "</select></td></tr>
<tr><td align='left' width='40%'>Tiktai su nuotrauką:</td><td align='left' width='60%'><input type='checkbox' name='photo'></td></tr>
<tr><td align='left' width='40%'>Sartiruoti pagal:</td><td align='left' width='60%'><select name='sort' class='textbox' style='width: 230px;'>
<option value='1'>Amžių (pagal didėjimo kreivė)</option>
<option value='2'>Amžių (pagal sumažint kreivė)</option>
<option value='3'>Data publikavimo (pagal didėjimo kreivė)</option>
<option value='4'>Data publikavimo (pagal sumažint kreivė)</option>
<option value='5'>Kiekis balų (pagal didėjimo kreivė)</option>
<option value='6'>Kiekis balų (pagal sumažint kreivė)</option>
<option value='7'>Peržiūrėjimo kieki (pagal didėjimo kreivė)</option>
<option value='8'>Peržiūrėjimo kieki (pagal sumažint kreivė)</option>
</select></td></tr>";
if(isset($_GET['search']) and $_GET['search']=="extended")
{
echo "<input type='hidden' name='_search' value='extended'>";
echo "<tr><td align='left'><a href='".BASEDIR."meeting.php'>Paprasta paieška</a></td></tr>";
echo "<tr><td align='center' colspan='2'><hr style='height: 2px;'></td></tr>";
echo "<tr><td align='left' width='40%'>Ieškomas ūgis:</td><td align='left' width='60%'>Īņ: <select name='stature_1' class='textbox' style='width: 65px;'><option value='0'>---</option>";
for($i=$stature_min; $i<=$stature_max; $i++)
echo "<option value='".$i."'>".$i." cm.</option>";
echo "</select> Iki: <select name='stature_2' class='textbox' style='width: 65px;'><option value='0'>---</option>";
for($i=$stature_min; $i<=$stature_max; $i++)
echo "<option value='".$i."'>".$i." cm.</option>";
echo "</select></td></tr>
<tr><td align='left' width='40%'>Ieškomas svoris:</td><td align='left' width='60%'>Īņ: <select name='weight_1' class='textbox' style='width: 65px;'><option value='0'>---</option>";
for($i=$weight_min; $i<=$weight_max; $i++)
echo "<option value='".$i."'>".$i." kg.</option>";
echo "</select> Äī: <select name='weight_2' class='textbox' style='width: 65px;'><option value='0'>---</option>";
for($i=$weight_min; $i<=$weight_max; $i++)
echo "<option value='".$i."'>".$i." kg.</option>";
echo "</select></td></tr>
<tr><td align='left' valign='top'>Plaukų spalva:<br><br><input type='checkbox' name='hairshead_' style='width: 15px; height: 16px; border-width: 0px;'> Neturi but.</td><td align='left'>";
for($i=1; $i<count($meeting_hairshead); $i++)
echo "<input type='checkbox' name='hairshead[]' value='".$i."' style='width: 15px; height: 16px; border-width: 0px;'> ".$meeting_hairshead[$i]."<br>";
echo "</select></td></tr>
<tr><td align='center' colspan='2'><hr width='70%'></td></tr>
<tr><td align='left' valign='top'>Plaukai ant veido ir kūno:<br><br><input type='checkbox' name='hairsbody_' style='width: 15px; height: 16px; border-width: 0px;'> Neturi but.</td><td align='left'>";
for($i=1; $i<count($meeting_hairsbody); $i++)
echo "<input type='checkbox' name='hairsbody[]' value='".$i."' style='width: 15px; height: 16px; border-width: 0px;'> ".$meeting_hairsbody[$i]."<br>";
echo "</td></tr>
<tr><td align='center' colspan='2'><hr width='70%'></td></tr>
<tr><td align='left' valign='top'>Žinojimas kalbų:<br><br><input type='checkbox' name='languages_' style='width: 15px; height: 16px; border-width: 0px;'> Neturi but</td><td align='left'>";
for($i=1; $i<count($meeting_languages); $i++)
echo "<input type='checkbox' name='languages[]' value='".$i."' style='width: 15px; height: 16px; border-width: 0px;'> ".$meeting_languages[$i]."<br>";
echo "</td></tr>
<tr><td align='center' colspan='2'><hr width='70%'></td></tr>
<tr><td align='left' valign='top'>Materialinė gerovė:<br><br><input type='checkbox' name='circumstance_' style='width: 15px; height: 16px; border-width: 0px;'> Neturi but</td><td align='left'>";
for($i=1; $i<count($meeting_circumstance); $i++)
echo "<input type='checkbox' name='circumstance[]' value='".$i."' style='width: 15px; height: 16px; border-width: 0px;'> ".$meeting_circumstance[$i]."<br>";
echo "</td></tr>
<tr><td align='center' colspan='2'><hr width='70%'></td></tr>
<tr><td align='left' valign='top'>Kaip supažindinti:<br><br><input type='checkbox' name='iam_' style='width: 15px; height: 16px; border-width: 0px;'> Neturi butü</td><td align='left'>";
for($i=1; $i<count($meeting_iam); $i++)
echo "<input type='checkbox' name='iam[]' value='".$i."' style='width: 15px; height: 16px; border-width: 0px;'> ".$meeting_iam[$i]."<br>";
echo "</td></tr>
<tr><td align='center' colspan='2'><hr width='70%'></td></tr>
<tr><td align='left' valign='top'>Padėtis ar jis oficialiai vedęs:<br><br><input type='checkbox' name='marital_' style='width: 15px; height: 16px; border-width: 0px;'> Neturi but</td><td align='left'>";
for($i=1; $i<count($meeting_marital); $i++)
echo "<input type='checkbox' name='marital[]' value='".$i."' style='width: 15px; height: 16px; border-width: 0px;'> ".$meeting_marital[$i]."<br>";
echo "</td></tr>
<tr><td align='center' colspan='2'><hr width='70%'></td></tr>
<tr><td align='left' valign='top'>Materialinė parama:<br><br><input type='checkbox' name='sponsor_' style='width: 15px; height: 16px; border-width: 0px;'> Neturi but</td><td align='left'>";
for($i=1; $i<count($meeting_sponsor); $i++)
echo "<input type='checkbox' name='sponsor[]' value='".$i."' style='width: 15px; height: 16px; border-width: 0px;'> ".$meeting_sponsor[$i]."<br>";
echo "</td></tr>
<tr><td align='center' colspan='2'><hr width='70%'></td></tr>
<tr><td align='left' valign='top'>Yra ar vaikų:<br><br><input type='checkbox' name='children_' style='width: 15px; height: 16px; border-width: 0px;'> Neturi but</td><td align='left'>";
for($i=1; $i<count($meeting_children); $i++)
echo "<input type='checkbox' name='children[]' value='".$i."' style='width: 15px; height: 16px; border-width: 0px;'> ".$meeting_children[$i]."<br>";
echo "</td></tr>";
echo "<tr><td align='center' colspan='2'><hr style='height: 2px;'></td></tr>";
}
else
echo "<tr><td align='left'><a href='".BASEDIR."meeting.php?search=extended'>Išplėsta paieška</a></td></tr>";
echo "<tr><td align='center' colspan='2'><input type='submit' name='submit_search' value='Ieškoti' class='button' style='width: 200px;'></td></tr>
</form>
</table>
</td></tr>
</table>";
if(isset($_GET['submit_search']))
{
if (!isset($rowstart) || !isNum($rowstart)) $rowstart=0;
$error=null;
if(!is_numeric($_GET['i'])) exit();
if(!is_numeric($_GET['sex'])) exit();
if(!is_numeric($_GET['city'])) exit();
if(!is_numeric($_GET['sort'])) exit();
if(!is_numeric($_GET['age_1']) and strlen($_GET['age_1'])) $_GET['age_1']=null;
if(!is_numeric($_GET['age_2']) and strlen($_GET['age_2'])) $_GET['age_2']=null;
$search=null;
$order=null;
if($_GET['i']!=0) $search.=" AND `lookfor` LIKE '%".$_GET['i']."%' ";
if($_GET['sex']!=0)
if($_GET['sex']==1 or $_GET['sex']==2) $search.=" AND `sex`='".$_GET['sex']."' ";
else $search.=" AND `iam`='".--$_GET['sex']."' ";
if($_GET['city']!=0) $search.=" AND `city`='".$_GET['city']."' ";
$date=date("Y-m-d", time());
ereg("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $date, $s_date);
if(strlen($_GET['age_1']))
{
$r_yar1=$s_date[1]-$_GET['age_1'];
$min_bd=$r_yar1."-".$s_date[2]."-".$s_date[3];
$search.=" AND `birth`<='".$min_bd."' ";
}
if(strlen($_GET['age_2']))
{
$r_yar2=($s_date[1]-$_GET['age_2'])-1;
$max_bd=$r_yar2."-".$s_date[2]."-".$s_date[3];
$search.=" AND `birth`>='".$max_bd."' ";
}
if(isset($_GET['photo']) and $_GET['photo']=="on") $search.=" AND `is_photo`='1' ";
if($_GET['sort']==1) $order.=" `birth` DESC ";
elseif($_GET['sort']==2) $order.=" `birth` ";
elseif($_GET['sort']==3) $order.=" `id` ";
elseif($_GET['sort']==4) $order.=" `id` DESC ";
elseif($_GET['sort']==5) $order.=" `rate` ";
elseif($_GET['sort']==6) $order.=" `rate` DESC ";
elseif($_GET['sort']==7) $order.=" `counter` ";
elseif($_GET['sort']==8) $order.=" `counter` DESC ";
if((isset($_GET['search']) and $_GET['search']=="extended") or (isset($_GET['_search']) and $_GET['_search']=="extended"))
{
if(!is_numeric($_GET['stature_1']) and strlen($_GET['stature_1'])) $_GET['stature_1']=null;
if(!is_numeric($_GET['stature_2']) and strlen($_GET['stature_2'])) $_GET['stature_2']=null;
if(!is_numeric($_GET['weight_1']) and strlen($_GET['weight_1'])) $_GET['weight_1']=null;
if(!is_numeric($_GET['weight_2']) and strlen($_GET['weight_2'])) $_GET['weight_2']=null;
if(isset($_GET['hairshead']) and strlen($_GET['hairshead']) and !is_array($_GET['hairshead'])) exit();
if(isset($_GET['hairsbody']) and strlen($_GET['hairsbody']) and !is_array($_GET['hairsbody'])) exit();
if(isset($_GET['languages']) and strlen($_GET['languages']) and !is_array($_GET['languages'])) exit();
if(isset($_GET['circumstance']) and strlen($_GET['circumstance']) and !is_array($_GET['circumstance'])) exit();
if(isset($_GET['iam']) and strlen($_GET['iam']) and !is_array($_GET['iam'])) exit();
if(isset($_GET['marital']) and strlen($_GET['marital']) and !is_array($_GET['marital'])) exit();
if(isset($_GET['sponsor']) and strlen($_GET['sponsor']) and !is_array($_GET['sponsor'])) exit();
if(isset($_GET['children']) and strlen($_GET['children']) and !is_array($_GET['children'])) exit();
if(strlen($_GET['stature_1']) and $_GET['stature_1']!=0) $search.=" AND `stature`>='".$_GET['stature_1']."' ";
if(strlen($_GET['stature_2']) and $_GET['stature_2']!=0) $search.=" AND `stature`<='".$_GET['stature_2']."' ";
if(strlen($_GET['weight_1']) and $_GET['weight_1']!=0) $search.=" AND `weight`>='".$_GET['weight_1']."' ";
if(strlen($_GET['weight_2']) and $_GET['weight_2']!=0) $search.=" AND `weight`<='".$_GET['weight_2']."' ";
if(isset($_GET['hairshead']) and strlen($_GET['hairshead']))
{
$sign=(isset($_GET['hairshead_']) and $_GET['hairshead_']=="on") ? "!=" : "=";
for($i=0; $i<count($_GET['hairshead']); $i++)
if($i==0 or $sign=="!=") $search.=" AND `hairshead`".$sign."'".$_GET['hairshead'][$i]."' ";
else $search.=" OR `hairshead`".$sign."'".$_GET['hairshead'][$i]."' ";
}
if(isset($_GET['hairsbody']) and strlen($_GET['hairsbody']))
{
$sign=(isset($_GET['hairsbody_']) and $_GET['hairsbody_']=="on") ? "NOT LIKE" : "LIKE";
foreach($_GET['hairsbody'] as $value)
$search.=" AND `hairsbody` ".$sign." '%".$value."%' ";
}
if(isset($_GET['languages']) and strlen($_GET['languages']))
{
$sign=(isset($_GET['languages_']) and $_GET['languages_']=="on") ? "NOT LIKE" : "LIKE";
foreach($_GET['languages'] as $value)
$search.=" AND `languages` ".$sign." '%".$value."%' ";
}
if(isset($_GET['circumstance']) and strlen($_GET['circumstance']))
{
$sign=(isset($_GET['circumstance_']) and $_GET['circumstance_']=="on") ? "!=" : "=";
for($i=0; $i<count($_GET['circumstance']); $i++)
if($i==0) $search.=" AND `circumstance`".$sign."'".$_GET['circumstance'][$i]."' ";
else $search.=" OR `circumstance`".$sign."'".$_GET['circumstance'][$i]."' ";
}
if(isset($_GET['iam']) and strlen($_GET['iam']))
{
$sign=(isset($_GET['iam_']) and $_GET['iam_']=="on") ? "!=" : "=";
for($i=0; $i<count($_GET['iam']); $i++)
if($i==0) $search.=" AND `iam`".$sign."'".$_GET['iam'][$i]."' ";
else $search.=" OR `iam`".$sign."'".$_GET['iam'][$i]."' ";
}
if(isset($_GET['marital']) and strlen($_GET['marital']))
{
$sign=(isset($_GET['marital_']) and $_GET['marital_']=="on") ? "!=" : "=";
for($i=0; $i<count($_GET['marital']); $i++)
if($i==0) $search.=" AND `marital`".$sign."'".$_GET['marital'][$i]."' ";
else $search.=" OR `marital`".$sign."'".$_GET['marital'][$i]."' ";
}
if(isset($_GET['sponsor']) and strlen($_GET['sponsor']))
{
$sign=(isset($_GET['sponsor_']) and $_GET['sponsor_']=="on") ? "!=" : "=";
for($i=0; $i<count($_GET['sponsor']); $i++)
if($i==0) $search.=" AND `sponsor`".$sign."'".$_GET['sponsor'][$i]."' ";
else $search.=" OR `sponsor`".$sign."'".$_GET['sponsor'][$i]."' ";
}
if(isset($_GET['children']) and strlen($_GET['children']))
{
$sign=(isset($_GET['children_']) and $_GET['children_']=="on") ? "!=" : "=";
for($i=0; $i<count($_GET['children']); $i++)
if($i==0) $search.=" AND `children`".$sign."'".$_GET['children'][$i]."' ";
else $search.=" OR `children`".$sign."'".$_GET['children'][$i]."' ";
}
}
$search.=" AND `id`!='".$userdata['user_id']."' ";
$search_result=dbquery("SELECT * FROM ".$db_prefix."meeting WHERE `status`='1' ".$search." ORDER BY ".$order." LIMIT ".$rowstart.", ".$search_on_page.";");
$search_count=dbrows(dbquery("SELECT * FROM ".$db_prefix."meeting WHERE `status`='1' ".$search.";"));
if($search_count>0)
{
echo "<br><table border='0' align='center' width='100%' cellspacing='2' cellpadding='2' class='border'>
<tr><td align='center' class='header1' style='font-size: 11px;'><b>Anketos rastos pagaI jūsų užklausą</b></td></tr>";
while($data=dbarray($search_result))
{
$photos=dbarray(dbquery("SELECT * FROM ".$db_prefix."meeting_photos WHERE `user_id`='".$data['id']."' ORDER BY `order` LIMIT 1;"));
if($userdata['user_id']!=$data['id']) $user_id="&id=".$data['id'];
else $user_id=null;
echo "<tr><td align='center'>";
echo "<table border='0' align='center' width='100%' cellspacing='2' cellpadding='2'>
<tr><td align='center' valign='top' width='16%'>";
echo "<a href='".BASEDIR."meeting.php?section=view".$user_id."' class='gallery'>";
if(strlen($photos['id']))
echo "<img src='".checkImageExists("images/meeting/".$photos['id']."t.jpg", "photo")."' width='".$preview_photo_size_w."' height='".$preview_photo_size_h."' border='0' alt='Žiūrėtį anketą'>";
else
echo "<img src='".checkImageExists("images/meeting/".$photos['id']."t.jpg", "photo")."' width='46' height='62' border='0' alt='Žiūrėtį anketą'>";
echo "<br>".$data['name']."</a></td><td align='center' valign='top'><table border='0' align='center' width='100%' cellspacing='1' cellpadding='4' class='tbl-border'>
<tr><td align='left' width='20%' class='tbl2'><b>Amžius:</b> ".age($data['birth'])."</td><td align='left' width='80%' class='tbl2'><b>Miestas:</b> ".$meeting_city[$data['city']]."</td></tr>";
if(strlen($data['about']))
echo "<tr><td align='left' colspan='2' class='tbl1'><b>Apie save:</b> ".$data['about']."</td></tr>";
echo "</table></td></tr>
</table>";
echo "</td></tr>";
}
echo "</table>";
if(!isset($_GET['search']) and !isset($_GET['_search']))
echo "<div align='center' style='margin-top: 5px;'>".makepagenav($rowstart, $search_on_page, $search_count, 3,
BASEDIR."meeting.php?"
."i=".$_GET['i']."&"
."sex=".$_GET['sex']."&"
."city=".$_GET['city']."&"
."sort=".$_GET['sort']."&"
."age_1=".$_GET['age_1']."&"
."age_2=".$_GET['age_2']."&"
."photo=".$_GET['photo']."&"
."submit_search=1&"
)."</div>";
elseif((isset($_GET['search']) and $_GET['search']=="extended") or (isset($_GET['_search']) and $_GET['_search']=="extended"))
echo "<div align='center' style='margin-top: 5px;'>".makepagenav($rowstart, $search_on_page, $search_count, 3,
BASEDIR."meeting.php?"
."i=".$_GET['i']."&"
."sex=".$_GET['sex']."&"
."city=".$_GET['city']."&"
."sort=".$_GET['sort']."&"
."age_1=".$_GET['age_1']."&"
."age_2=".$_GET['age_2']."&"
."photo=".$_GET['photo']."&"
."submit_search=1&"
."hairshead_=".$_GET['hairshead_']."&"
."hairshead=".$_GET['hairshead']."&"
."hairsbody_=".$_GET['hairsbody_']."&"
."hairsbody=".$_GET['hairsbody']."&"
."languages_=".$_GET['languages_']."&"
."languages=".$_GET['languages']."&"
."circumstance_=".$_GET['circumstance_']."&"
."circumstance=".$_GET['circumstance']."&"
."iam_=".$_GET['iam_']."&"
."iam=".$_GET['iam']."&"
."marital_=".$_GET['marital_']."&"
."marital=".$_GET['marital']."&"
."sponsor_=".$_GET['sponsor_']."&"
."sponsor=".$_GET['sponsor']."&"
."children_=".$_GET['children_']."&"
."children=".$_GET['children']."&"
."_search=extended&"
)."</div>";
}
else
echo "<br><table border='0' align='center' width='100%' cellspacing='2' cellpadding='2' class='border'>
<tr><td align='center' class='header1' style='font-size: 11px;'><b>Po jūsų užklausos nieko nerasta.</b></td></tr>
</table>";
}
elseif(!isset($_GET['search']))
{
$result_man=dbquery("SELECT * FROM ".$db_prefix."meeting WHERE `status`='1' AND `sex`='1' AND `votes`>'".$votes_count."' LIMIT 5;");
$result_woman=dbquery("SELECT * FROM ".$db_prefix."meeting WHERE `status`='1' AND `sex`='2' AND `votes`>'".$votes_count."' LIMIT 5;");
if(dbrows($result_man)>0 or dbrows($result_woman)>0)
{
$top10_man=array();
while($data=dbarray($result_man)) $top10_man[@number_format($data['rate']/$data['votes'], 1)]=$data;
krsort($top10_man);
$top_man=array();
foreach($top10_man as $sred_ball=>$data)
{
$data['sred_ball']=$sred_ball;
$top_man[]=$data;
}
$top10_woman=array();
while($data=dbarray($result_woman)) $top10_woman[@number_format($data['rate']/$data['votes'], 1)]=$data;
krsort($top10_woman);
$top_woman=array();
foreach($top10_woman as $sred_ball=>$data)
{
$data['sred_ball']=$sred_ball;
$top_woman[]=$data;
}
echo "<br><table border='0' align='center' width='100%' cellspacing='2' cellpadding='2' class='border'>
<tr><td align='center' class='header1' style='font-size: 11px;' colspan='2'><b>TOP10 reitingai pažinčių tarnybą</b></td></tr>
<tr class='tbl2'><td align='center' width='50%'>Vyrai</td><td align='center' width='50%'>Moteris</td></tr>
<tr><td align='center' colspan='2'>";
for($i=0; $i<5; $i++)
{
echo "<table border='0' align='center' width='100%' cellspacing='1' cellpadding='1'>
<tr><td align='center' width='50%'>";
if(isset($top_man[$i]))
{
$data=$top_man[$i];
$photos=dbarray(dbquery("SELECT * FROM ".$db_prefix."meeting_photos WHERE `user_id`='".$data['id']."' ORDER BY `order` LIMIT 1;"));
echo "<table border='0' align='center' width='100%' height='100' cellspacing='1' cellpadding='4' class='tbl-border'>
<tr><td align='center' width='40%' rowspan='2' class='tbl2'><a href='".BASEDIR."meeting.php?section=view&id=".$data['id']."' class='gallery'>";
if(strlen($photos['id']))
echo "<img src='".checkImageExists("images/meeting/".$photos['id']."t.jpg", "photo")."' width='".$preview_photo_size_w."' height='".$preview_photo_size_h."' border='0' alt='Žiūrėtį ankėtą'>";
else
echo "<img src='".checkImageExists("images/meeting/".$photos['id']."t.jpg", "photo")."' width='46' height='62' border='0' alt='Žiūrėtį ankėtą'>";
echo "<br>".$data['name'].", ".age($data['birth'])."</a></td><td align='center' width='20%' class='tbl2'>Balsų</td><td align='center' width='20%' class='tbl2'>Žiūrėta</td><td align='center' width='20%' class='tbl2'>Balų vidurkis</td></tr>
<tr><td align='center' class='tbl1'>".$data['votes']."</td><td align='center' class='tbl1'>".$data['counter']."</td><td align='center' class='tbl1'>".$data['sred_ball']."</td></tr>
</table>";
}
else
{
echo "<table border='0' align='center' width='100%' height='100' cellspacing='1' cellpadding='4' class='tbl-border'>
<tr><td align='center' width='40%' rowspan='2' class='tbl2'><img src='".IMAGES."meeting/photo_small_na.gif' width='46' height='62' border='0' alt='NO FOTO'></td><td align='center' width='20%' class='tbl2'>Balsų</td><td align='center' width='20%' class='tbl2'>Žiūrėta</td><td align='center' width='20%' class='tbl2'>Balų vidurkis</td></tr>
<tr><td align='center' class='tbl1'>0</td><td align='center' class='tbl1'>0</td><td align='center' class='tbl1'>0.0</td></tr>
</table>";
}
echo "</td><td align='center' width='50%'>";
if(isset($top_woman[$i]))
{
$data=$top_woman[$i];
$photos=dbarray(dbquery("SELECT * FROM ".$db_prefix."meeting_photos WHERE `user_id`='".$data['id']."' ORDER BY `order` LIMIT 1;"));
echo "<table border='0' align='center' width='100%' height='100' cellspacing='1' cellpadding='4' class='tbl-border'>
<tr><td align='center' width='40%' rowspan='2' class='tbl2'><a href='".BASEDIR."meeting.php?section=view&id=".$data['id']."' class='gallery'>";
if(strlen($photos['id']))
echo "<img src='".checkImageExists("images/meeting/".$photos['id']."t.jpg", "photo")."' width='".$preview_photo_size_w."' height='".$preview_photo_size_h."' border='0' alt='Žiūrėtį ankėtą'>";
else
echo "<img src='".checkImageExists("images/meeting/".$photos['id']."t.jpg", "photo")."' width='46' height='62' border='0' alt='Žiūrėtį ankėtą'>";
echo "<br>".$data['name'].", ".age($data['birth'])."</a></td><td align='center' width='20%' class='tbl2'>Balsų</td><td align='center' width='20%' class='tbl2'>Žiūrėta</td><td align='center' width='20%' class='tbl2'>Balų vidurkis</td></tr>
<tr><td align='center' class='tbl1'>".$data['votes']."</td><td align='center' class='tbl1'>".$data['counter']."</td><td align='center' class='tbl1'>".$data['sred_ball']."</td></tr>
</table>";
}
else
{
echo "<table border='0' align='center' width='100%' height='100' cellspacing='1' cellpadding='4' class='tbl-border'>
<tr><td align='center' width='40%' rowspan='2' class='tbl2'><img src='".IMAGES."meeting/photo_small_na.gif' width='46' height='62' border='0' alt='NO FOTO'></td><td align='center' width='20%' class='tbl2'>Balsų</td><td align='center' width='20%' class='tbl2'>Žiūrėta</td><td align='center' width='20%' class='tbl2'>Balų vidurkis</td></tr>
<tr><td align='center' class='tbl1'>0</td><td align='center' class='tbl1'>0</td><td align='center' class='tbl1'>0.0</td></tr>
</table>";
}
echo "</td></tr>
</table>";
}
echo "</td></tr>
</table>";
}
$result=dbquery("SELECT * FROM ".$db_prefix."meeting WHERE `status`='1' ORDER BY `id` DESC LIMIT ".$new_anketa_count.";");
if(dbrows($result)>0)
{
echo "<br><table border='0' align='center' width='100%' cellspacing='2' cellpadding='2' class='border'>
<tr><td align='center' class='header1' style='font-size: 11px;'><b>Naujos anketos</b></td></tr>";
while($data=dbarray($result))
{
$photos=dbarray(dbquery("SELECT * FROM ".$db_prefix."meeting_photos WHERE `user_id`='".$data['id']."' ORDER BY `order` LIMIT 1;"));
echo "<tr><td align='center'>";
echo "<table border='0' align='center' width='100%' cellspacing='2' cellpadding='2'>
<tr><td align='center' valign='top' width='16%'>";
echo "<a href='".BASEDIR."meeting.php?section=view&id=".$data['id']."' class='gallery'>";
if(strlen($photos['id']))
echo "<img src='".checkImageExists("images/meeting/".$photos['id']."t.jpg", "photo")."' width='".$preview_photo_size_w."' height='".$preview_photo_size_h."' border='0' alt='Žiūrėtį anketą'>";
else
echo "<img src='".checkImageExists("images/meeting/".$photos['id']."t.jpg", "photo")."' width='46' height='62' border='0' alt='Žiūrėtį anketą'>";
echo "<br>".$data['name']."</a></td><td align='center' valign='top'><table border='0' align='center' width='100%' cellspacing='1' cellpadding='4' class='tbl-border'>
<tr><td align='left' width='20%' class='tbl2'><b>Amžius:</b> ".age($data['birth'])."</td><td align='left' width='80%' class='tbl2'><b>Miestas:</b> ".$meeting_city[$data['city']]."</td></tr>";
if(strlen($data['about']))
echo "<tr><td align='left' colspan='2' class='tbl1'><b>Apie save:</b> ".$data['about']."</td></tr>";
echo "</table></td></tr>
</table>";
echo "</td></tr>";
}
echo "</table>";
}
}
closetable();
}
elseif(isset($_GET['section']) and $_GET['section']=="view")
{
if(isset($_GET['id']) and is_numeric($_GET['id'])) define("USER_ID", $_GET['id']);
else define("USER_ID", $userdata['user_id']);
$data=dbquery("SELECT * FROM ".$db_prefix."meeting WHERE `id`='".USER_ID."' LIMIT 1;");
if(!isset($_GET['part']))
{
opentable("Susipažinimo: Peržiūrą anketų");
if(($data=dbarray($data) and strlen($data['name']) and $data['city']!=0) or USER_ID==$userdata['user_id'])
{
if($data['status']!=0 or USER_ID==$userdata['user_id'] or checkrights("ME"))
{
echo "<table border='0' align='center' width='80%' cellspacing='0' cellpadding='0'>
<tr><td align='center' width='35%'>";
$result=dbquery("SELECT * FROM ".$db_prefix."meeting_photos WHERE `user_id`='".USER_ID."' ORDER BY `order` LIMIT 1;");
if($photos=dbarray($result))
{
if($userdata['user_id']!=USER_ID) $user_id="&id=".USER_ID;
else $user_id=null;
echo "<a href='".BASEDIR."meeting.php?section=view&part=photo".$user_id."&photo_id=".$photos['id']."' class='gallery'><img src='".checkImageExists("images/meeting/".$photos['id']."t.jpg", "photo")."' width='".$preview_photo_size_w."' height='".$preview_photo_size_h."' border='1' alt='".$photos['name']."'></a>";
}
else
echo "<img src='".IMAGES."meeting/photo_small_na.gif' width='46' height='62' border='0' alt=''>";
if(USER_ID==$userdata['user_id'])
echo "<br><a href='".BASEDIR."meeting.php?section=edit&part=photo'>Pridėti foto</a>";
else
echo "<br><a href='".BASEDIR."meeting.php?section=view&part=photo&id=".USER_ID."'>Peržiūrėti visas foto</a>";
echo "</td><td align='left' valign='top' width='65%'>";
if(strlen($data['name']))
echo "<b><font style='font-size: 14px;'>".$data['name']."</font></b>";
if(strlen($data['surname']))
echo " <b><font style='font-size: 14px;'>".$data['surname']."</font></b>";
if(strlen($data['login']) and (!strlen($data['name']) and !strlen($data['surname'])))
echo "<b><font style='font-size: 14px;'>".$data['login']."</font></b>";
if($data['city']!=0)
echo "<br>Miestas: ".$meeting_city[$data['city']];
if(strlen($data['birth']) and $data['birth']!="0000-00-00")
echo "<br>Amžius: ".age($data['birth']);
if(USER_ID!=$userdata['user_id'])
echo "<br><br><a href='".BASEDIR."messages.php?msg_send=".USER_ID."'>Parašykite man pranešimą</a>";
$bookmarks=dbquery("SELECT * FROM ".$db_prefix."meeting_bookmarks WHERE `user_id`='".$userdata['user_id']."';");
while($bookmarks_array=dbarray($bookmarks))
if($bookmarks_array['bookmark_id']==$data['id'])
{
$add=true;
break;
}
if(USER_ID!=$userdata['user_id'] and !isset($add))
echo "<br><a href='".BASEDIR."meeting.php?section=bookmark&part=add&id=".USER_ID."'>Pridėtį manę prie savo hipotekos</a>";
echo "</td></tr>
</table><br>
<table border='0' align='center' width='90%' cellspacing='2' cellpadding='2' class='border'>";
$panels=array();
if(strlen($data['about']) or USER_ID==$userdata['user_id'])
$panels['aboutme']=true;
if((strlen($data['lookfor']) or strlen($data['target_1']) or strlen($data['target_2']) or strlen($data['waitingfor']) or $data['iam']!=0 or $data['marital']!=0 or $data['sponsor']!=0 or $data['children']!=0) or USER_ID==$userdata['user_id'])
$panels['familiarity']=true;
if(($data['stature']!=0 or $data['weight']!=0 or $data['build']!=0 or strlen($data['onbody']) or $data['hairshead']!=0 or strlen($data['hairsbody']) or strlen($data['profession']) or $data['routine']!=0 or strlen($data['languages']) or $data['circumstance']!=0 or $data['home']!=0 or strlen($data['lifepriority_1']) or strlen($data['lifepriority_2'])) or USER_ID==$userdata['user_id'])
$panels['type']=true;
if((strlen($data['freeday_1']) or strlen($data['freeday_2']) or strlen($data['interests_1']) or strlen($data['interests_2']) or strlen($data['sport_1']) or strlen($data['sport_2']) or strlen($data['music_1']) or strlen($data['music_2']) or $data['smoke']!=0 or $data['drink']!=0 or $data['drugs']!=0) or USER_ID==$userdata['user_id'])
$panels['interests']=true;
if(($data['orientation']!=0 or $data['sexpenis']!=0 or ($data['sexgetero']!=0 and is_numeric($data['sexgetero'])) or (strlen($data['sexgetero']) and !is_numeric($data['sexgetero'])) or ($data['sexgomo']!=0 and is_numeric($data['sexgomo'])) or (strlen($data['sexgomo']) and !is_numeric($data['sexgomo'])) or ($data['sexoften']!=0 and is_numeric($data['sexoften'])) or (strlen($data['sexoften']) and !is_numeric($data['sexoften'])) or ($data['sexrole']!=0 and is_numeric($data['sexrole'])) or (strlen($data['sexrole']) and !is_numeric($data['sexrole'])) or strlen($data['sexexcitation_1']) or strlen($data['sexexcitation_2']) or strlen($data['sexpriority_descr'])) or USER_ID==$userdata['user_id'])
$panels['favour']=true;
if(@$panels['aboutme']==true)
{
echo "<tr><td class='main-body'>
<table border='0' align='center' width='100%' cellspacing='0' cellpadding='0'>
<tr><td align='left'><h5 style='margin: 0px;'><u>Apie mane:</u>";
if(USER_ID==$userdata['user_id']) echo " <font size='1'>(Būtina užpildyti)</font>";
echo "</h5></td>";
if(USER_ID==$userdata['user_id'])
echo "<td align='right'><a href='".BASEDIR."meeting.php?section=edit&part=aboutme'>Redaguotį šį bloką</a></td>";
echo "</tr></table>
</td></tr>";
echo "<tr><td class='main-body'><i>".$data['about']."</i>";
if(@$panels['familiarity']==true or @$panels['type']==true or @$panels['interests']==true or @$panels['favour']==true) echo "<hr>";
echo "</td></tr>";
}
if(@$panels['familiarity']==true)
{
echo "<tr><td class='main-body'>
<table border='0' align='center' width='100%' cellspacing='0' cellpadding='0'>
<tr><td align='left'><u><h5 style='margin: 0px;'>Susipažinimas:</h5></u></td>";
if(USER_ID==$userdata['user_id'])
echo "<td align='right'><a href='".BASEDIR."meeting.php?section=edit&part=familiarity'>Redaguotį šį bloką</a></td>";
echo "</tr></table>
</td></tr>";
echo "<tr><td class='main-body'>";
if(strlen($data['lookfor']))
{
echo "<br><b>Susipažinsiu:</b><br>";
$lookfor=explode(",", $data['lookfor']);
array_pop($lookfor);
for($i=0; $i<count($lookfor); $i++)
{
echo $meeting_lookfor[$lookfor[$i]];
if(isset($lookfor[$i+1])) echo ", ";
else echo ".";
}
}
if($data['age_1']!=0 or $data['age_2']!=0)
{
echo "<br>Į ūgį: ";
if($data['age_1']!=0)
echo "īņ ".$data['age_1']." ";
if($data['age_2']!=0)
echo "äī ".$data['age_2'];
echo ".<br>";
}
if(strlen($data['waitingfor']))
echo "<br><b>Ką aš noriu surastį:</b><br><i>".$data['waitingfor']."</i><br>";
echo "<table border='0' align='center' width='100%' cellspacing='0' cellpadding='0'>
<tr><td align='left' valign='top' width='50%'>";
if(strlen($data['target_1']) or strlen($data['target_2']))
{
echo "<br><b>Tikslas susipažinimo:</b><br>";
if(strlen($data['target_1']))
{
$target=explode(",", $data['target_1']);
array_pop($target);
$target=array_flip($target);
$id=0;
foreach($meeting_target as $key=>$value)
for($i=0; $i<count($value); $i++)
{
$id++;
if(isset($target[$id]))
echo "<li>".$value[$i]."</li>";
}
}
if(strlen($data['target_2']))
echo "<li><i>".$data['target_2']."</i></li>";
echo "<br><br>";
}
if(strlen($data['iam']) and $data['iam']!=0)
echo "<b>Kaip aš susipažistu:</b><br>".$meeting_iam[$data['iam']];
echo "</td><td align='left' valign='top' width='50%'>";
if(strlen($data['marital']) and $data['marital']!=0)
echo "<b>Esate Jus oficialiai susituokes?</b><br>".$meeting_marital[$data['marital']]."<br><br>";
if(strlen($data['sponsor']) and $data['sponsor']!=0)
echo "<b>Materialinė parama:</b><br>".$meeting_sponsor[$data['sponsor']]."<br><br>";
if(strlen($data['children']) and $data['children']!=0)
echo "<b>Yra pas Jus vaikų?</b><br>".$meeting_children[$data['children']];
echo "</td></tr>
</table>";
if(@$panels['type']==true or @$panels['interests']==true or @$panels['favour']==true) echo "<hr>";
echo "</td></tr>";
}
if(@$panels['type']==true)
{
echo "<tr><td class='main-body'>
<table border='0' align='center' width='100%' cellspacing='0' cellpadding='0'>
<tr><td align='left'><u><h5 style='margin: 0px;'>Tipažas:</h5></u></td>";
if(USER_ID==$userdata['user_id'])
echo "<td align='right'><a href='".BASEDIR."meeting.php?section=edit&part=type'>Redaguotį šį bloką</a></td>";
echo "</tr></table>
</td></tr>";
echo "<tr><td class='main-body'>
<table border='0' align='center' width='100%' cellspacing='0' cellpadding='0'>
<tr><td align='left' valign='top' width='50%'>";
if($data['stature']!=0)
echo "<br><b>Ūgis:</b> ".$data['stature']." cm.<br>";
if($data['weight']!=0)
echo "<br><b>Svoris:</b> ".$data['weight']." kg.<br>";
if($data['build']!=0)
echo "<br><b>Kūno sudėjimas:</b><br>".$meeting_build[$data['build']]."<br>";
if(strlen($data['onbody']))
{
echo "<br><b>ant kūne yra:</b><br>";
$onbody=explode(",", $data['onbody']);
array_pop($onbody);
$onbody=array_flip($onbody);
for($i=1; $i<count($meeting_onbody); $i++)
if(isset($onbody[$i]))
echo "<li>".$meeting_onbody[$i]."</li>";
echo "<br>";
}
if($data['hairshead']!=0)
echo "<br><b>Palaukai ant kalvos:</b><br>".$meeting_hairshead[$data['hairshead']]."<br>";
if(strlen($data['hairsbody']))
{
echo "<br><b>Plaukai ant veido ir kūno:</b><br>";
$hairsbody=explode(",", $data['hairsbody']);
array_pop($hairsbody);
$hairsbody=array_flip($hairsbody);
for($i=1; $i<count($meeting_hairsbody); $i++)
if(isset($hairsbody[$i]))
echo "<li>".$meeting_hairsbody[$i]."</li>";
echo "<br>";
}
echo "</td><td align='left' valign='top' width='50%'>";
if(strlen($data['profession']))
echo "<br><b>Profesija:</b><br><i>".$data['profession']."</i><br>";
if($data['routine']!=0)
echo "<br><b>Šåęčģ äķ˙:</b><br>".$meeting_routine[$data['routine']]."<br>";
if(strlen($data['languages']))
{
echo "<br><b>Dienos režimas:</b><br>";
$languages=explode(",", $data['languages']);
array_pop($languages);
$languages=array_flip($languages);
for($i=1; $i<count($meeting_languages); $i++)
if(isset($languages[$i]))
echo "<li>".$meeting_languages[$i]."</li>";
echo "<br>";
}
if($data['circumstance']!=0)
echo "<br><b>Materialinė padėtis:</b><br>".$meeting_circumstance[$data['circumstance']]."<br>";
if($data['home']!=0)
echo "<br><b>Gyvenate:</b><br>".$meeting_home[$data['home']]."<br>";
if(strlen($data['lifepriority_1']) or strlen($data['lifepriority_2']))
{
echo "<br><b>Gyvenimo prioritetas:</b><br>";
if(strlen($data['lifepriority_1']))
{
$lifepriority=explode(",", $data['lifepriority_1']);
array_pop($lifepriority);
$lifepriority=array_flip($lifepriority);
for($i=0; $i<count($meeting_lifepriority); $i++)
if(isset($lifepriority[$i]))
echo "<li>".$meeting_lifepriority[$i]."</li>";
echo "<br>";
}
if(strlen($data['lifepriority_2']))
echo "<li><i>".$data['lifepriority_2']."</i></li>";
echo "<br>";
}
echo "</td></tr>
</table>";
if(@$panels['interests']==true or @$panels['favour']==true) echo "<hr>";
echo "</td></tr>";
}
if(@$panels['interests']==true)
{
echo "<tr><td class='main-body'>
<table border='0' align='center' width='100%' cellspacing='0' cellpadding='0'>
<tr><td align='left'><u><h5 style='margin: 0px;'>Domėjimasis:</h5></u></td>";
if(USER_ID==$userdata['user_id'])
echo "<td align='right'><a href='".BASEDIR."meeting.php?section=edit&part=interests'>Redaguotį šį bloką</a></td>";
echo "</tr></table>
</td></tr>";
echo "<tr><td class='main-body'>
<table border='0' align='center' width='100%' cellspacing='0' cellpadding='0'>
<tr><td align='left' valign='top' width='50%'>";
if(strlen($data['freeday_1']) or strlen($data['freeday_2']))
{
echo "<br><b>Ką aš darisių laisvą <br>dieną:</b><br>";
if(strlen($data['freeday_1']))
{
$freeday=explode(",", $data['freeday_1']);
array_pop($freeday);
$freeday=array_flip($freeday);
for($i=0; $i<count($meeting_freeday); $i++)
if(isset($freeday[$i]))
echo "<li>".$meeting_freeday[$i]."</li>";
echo "<br>";
}
if(strlen($data['freeday_2']))
echo "<li><i>".$data['freeday_2']."</i></li>";
echo "<br>";
}
if(strlen($data['interests_1']) or strlen($data['interests_2']))
{
echo "<br><b>Mano susidomėjimai:</b><br>";
if(strlen($data['interests_1']))
{
$interests=explode(",", $data['interests_1']);
array_pop($interests);
$interests=array_flip($interests);
for($i=0; $i<count($meeting_interests); $i++)
if(isset($interests[$i]))
echo "<li>".$meeting_interests[$i]."</li>";
echo "<br>";
}
if(strlen($data['interests_2']))
echo "<li><i>".$data['interests_2']."</i></li>";
echo "<br>";
}
if($data['smoke']!=0)
echo "<br><b>požiūris į rūkymą:</b><br>".$meeting_smoke[$data['smoke']]."<br>";
if($data['drink']!=0)
echo "<br><b>požiūris į alkoholį:</b><br>".$meeting_drink[$data['drink']]."<br>";
if($data['drugs']!=0)
echo "<br><b>požiūris į narkotikus:</b><br>".$meeting_drugs[$data['drugs']]."<br>";
echo "</td><td align='left' valign='top' width='50%'>";
if(strlen($data['sport_1']) or strlen($data['sport_2']))
{
echo "<br><b>Užsiėmimas sportų:</b><br>";
if(strlen($data['sport_1']))
{
$sport=explode(",", $data['sport_1']);
array_pop($sport);
$sport=array_flip($sport);
for($i=0; $i<count($meeting_sport); $i++)
if(isset($sport[$i]))
echo "<li>".$meeting_sport[$i]."</li>";
echo "<br>";
}
if(strlen($data['sport_2']))
echo "<li><i>".$data['sport_2']."</i></li>";
echo "<br>";
}
if(strlen($data['music_1']) or strlen($data['music_2']))
{
echo "<br><b>Mėgstamos muzikos krytis:</b><br>";
if(strlen($data['music_1']))
{
$music=explode(",", $data['music_1']);
array_pop($music);
$music=array_flip($music);
for($i=0; $i<count($meeting_music); $i++)
if(isset($music[$i]))
echo "<li>".$meeting_music[$i]."</li>";
echo "<br>";
}
if(strlen($data['music_2']))
echo "<li><i>".$data['music_2']."</i></li>";
echo "<br>";
}
echo "</td></tr>
</table>";
if(@$panels['favour']==true) echo "<hr>";
echo "</td></tr>";
}
if(@$panels['favour']==true)
{
echo "<tr><td class='main-body'>
<table border='0' align='center' width='100%' cellspacing='0' cellpadding='0'>
<tr><td align='left'><u><h5 style='margin: 0px;'>Seksualinis pirmenybė:</h5></u></td>";
if(USER_ID==$userdata['user_id'])
echo "<td align='right'><a href='".BASEDIR."meeting.php?section=edit&part=favour'>Redaguotį šį blogą</a></td>";
echo "</tr></table>
</td></tr>";
echo "<tr><td class='main-body'>
<table border='0' align='ce