$end_time = date('d-m-Y H:i:s', strtotime($arriving_time . "-30 min"));
$reminder = "";
if ($curtime >= $remtime) {
$reminder = "no";
} else {
$reminder = "yes";
}
$movieurl = WEBSITE_PATH . getmoviename($row_data->Title, $row_data->MovieID);
$output .= '<movie>
<movie_id> ' . $row_data->MovieID . ' </movie_id>
<title><![CDATA[' . $row_data->Title . ']]></title>
<tuning>' . DateFormatWhole($row_data->AiringDateTime) . '</tuning>
<starring><![CDATA[ ' . $row_data->Starring . ']]></starring>
<directedby><![CDATA[ ' . $row_data->DirectedBy . ']]></directedby>
<genre><![CDATA[' . $row_data->Genre . ']]></genre>
<duration> ' . formatduration($row_data->Duration) . ' </duration>
<synopsis><![CDATA[ ' . stripslashes($row_data->Synopsis) . ']]></synopsis>
<poster_img><![CDATA[' . IMAGE_PATH . $row_data->FilePathBig . ']]></poster_img>
<crausel_img><![CDATA[' . IMAGE_PATH . $row_data->HomeCarausalPath . ']]></crausel_img>
<movie_url><![CDATA[' . $movieurl . ']]></movie_url>
<thumb_path><![CDATA[' . IMAGE_PATH . $row_data->FilePath . ']]></thumb_path>
<highlights>' . $row_data->IsHighlight . '</highlights>
<originals>' . $row_data->Originals . '</originals>
<is_hd>' . $is_hd . '</is_hd>
<movie_video_url><![CDATA[ ' . $row_data->VideoPath . ']]></movie_video_url>
<s_time>' . $start_time . '</s_time>
<e_time>' . $end_time . '</e_time>
<reminder>' . $reminder . '</reminder>
</movie>
';
}
if (strtolower($row_back['Genre']) == "romance") {
$genre = 'romantic';
} else {
$genre = strtolower($row_back['Genre']);
}
?>
<div class="show_divider special_font"><span class="font_small">Genre:</span> <?php
echo '<a href="' . $genre . '-movies.php" style="text-decoration:underline; font-size:16px; color:#ffffff;">' . $row_back['Genre'] . '</a>';
?>
</div>
<?php
}
if ($row_back['Duration']) {
?>
<div class="show_divider special_font"><span class="font_small">Duration:</span> <?php
echo formatduration($row_back['Duration']);
?>
</div>
<?php
}
?>
<div class="about_show_timer_box">
<div class="font_header show_divider"> Showtime </div>
<div class="show_divider font_content about_show_timer_box_timing"> <?php
echo DateFormat($row_back['AiringDateTime']);
?>
</div>
$end_time = date('d-m-Y H:i:s', strtotime($arriving_time . "-30 min"));
$reminder = "";
if ($curtime >= $remtime) {
$reminder = "no";
} else {
$reminder = "yes";
}
$movieurl = WEBSITE_PATH . getmoviename($next3_data->Title, $next3_data->MovieID);
$output .= '<next_three_highlights>
<movie_id> ' . $next3_data->MovieID . ' </movie_id>
<title><![CDATA[' . $next3_data->Title . ']]></title>
<tuning>' . DateFormatWhole($next3_data->AiringDateTime) . '</tuning>
<starring><![CDATA[ ' . $next3_data->Starring . ']]></starring>
<directedby><![CDATA[ ' . $next3_data->DirectedBy . ']]></directedby>
<genre><![CDATA[' . $next3_data->Genre . ']]></genre>
<duration> ' . formatduration($next3_data->Duration) . ' </duration>
<synopsis><![CDATA[ ' . stripslashes($next3_data->Synopsis) . ']]></synopsis>
<poster_img><![CDATA[' . IMAGE_PATH . $next3_data->FilePathBig . ']]></poster_img>
<crausel_img><![CDATA[' . IMAGE_PATH . $next3_data->HomeCarausalPath . ']]></crausel_img>
<movie_url><![CDATA[' . $movieurl . ']]></movie_url>
<thumb_path><![CDATA[' . IMAGE_PATH . $next3_data->FilePath . ']]></thumb_path>
<highlights>' . $next3_data->IsHighlight . '</highlights>
<originals>' . $next3_data->Originals . '</originals>
<is_hd>' . $is_hd . '</is_hd>
<movie_video_url><![CDATA[ ' . $next3_data->VideoPath . ']]></movie_video_url>
<s_time>' . $start_time . '</s_time>
<e_time>' . $end_time . '</e_time>
<reminder>' . $reminder . '</reminder>
</next_three_highlights>
';
}
<th>Dystans</th>
<th>Czas</th>
<th>Data i czas biegu</th>
<th>Wiadomość</th>
</tr>
<?php
while ($row = mysql_fetch_row($listares)) {
?>
<tr valign="top">
<td><?php
print $row[0] . ' km';
?>
</td>
<td><?php
if (trim($row[2]) != '') {
print formatduration($row[2]);
} else {
print "--";
}
?>
</td>
<td><?php
print $row[1];
?>
</td>
<td><a href='http://blip.pl/s/<?php
print $row[4];
?>
' target="_blank" title='<?php
print $row[3];
?>
function get_user_summary($user)
{
$link = mysql_connect('localhost', 'cardinalpharma', 'tweets');
if (!$link) {
die('Nie można się połaczyć: ' . mysql_error());
}
$db_selected = mysql_select_db('cardinalpharma', $link);
if (!$db_selected) {
die('Nie można ustawić bazy : ' . mysql_error());
}
mysql_query("SET character_set_client=utf-8", $link);
mysql_query("SET character_set_connection=utf-8", $link);
mysql_query("SET CHARSET utf8", $link);
mysql_query("SET NAMES 'utf8' COLLATE 'utf8_polish_ci'", $link);
$numruns = mysql_query(sprintf("select count(blip_id) from bieganie where user='******'", mysql_real_escape_string($user)));
$numruns_count = mysql_fetch_row($numruns);
$numruns_count = $numruns_count[0];
$totals = sprintf("SELECT sum(distance) as totaldistance, sum(duration) as totalduration FROM bieganie WHERE user='******'", mysql_real_escape_string($user));
$totalsres = mysql_query($totals);
$results = mysql_fetch_row($totalsres);
$totals2 = sprintf("SELECT sum(distance) as totaldistance, sum(duration) as totalduration FROM bieganie WHERE user='******' AND duration>0", mysql_real_escape_string($user));
$totalsres2 = mysql_query($totals2);
$results2 = mysql_fetch_row($totalsres2);
$string = '';
if ($results2[1] != '') {
$string = sprintf("%d zalogowanych biegów. Total %01.2f km, avg. speed: %01.2f km/h, avg. pace %01.2f min/km, total time: %s. http://biegacze.adblix.pl/users/%s", $numruns_count, $results[0], $results2[0] / ($results2[1] / 3600), $results2[1] / 60 / $results2[0], formatduration($results[1]), $user);
} else {
$string = sprintf("%d zapisanych biegów. Total km: %01.2f. Wprowadzaj czasy biegów aby otrzymać więcej danych. http://biegacze.adblix.pl/users/%s", $numruns_count, $results[0], $user);
}
return $string;
}
print $row[0];
?>
" title="szczegółowe statystyki <?php
print $row[0];
?>
"><img src="avatar/<?php
print $row[0];
?>
" border="0"> <?php
print $row[0];
?>
</a></td>
<td><?php
print $row[1] . ' km';
if (trim($row[3]) != '') {
print "<br>[" . formatduration($row[3]) . "]";
}
?>
</td>
<td><?php
print $row[2];
?>
</td>
<td><a href='http://blip.pl/s/<?php
print $row[5];
?>
' target="_blank" title='<?php
print $row[4];
?>
'><?php
print $row[4];