';
}
function more($current_tutorial, $ignoreAPI = false)
{
if($ignoreAPI == true)
{
$sql = mysqli_query($conn, sprintf('SELECT id,name,alias,description FROM toc WHERE id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id IN (SELECT tag_id FROM PoznajGoogleMaps_tagged WHERE tutorial_id = %d)) AND id != %d AND views>0 ORDER BY views DESC LIMIT 0,4;',$current_tutorial->getID(),$current_tutorial->getID()));
}
else
{
$sql = mysqli_query($conn, sprintf('SELECT id,name,alias,description FROM toc WHERE api="%d" AND id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id IN (SELECT tag_id FROM PoznajGoogleMaps_tagged WHERE tutorial_id = %d)) AND id != %d AND views>0 ORDER BY views DESC LIMIT 0,4;', $current_tutorial->get('api'),$current_tutorial->getID(),$current_tutorial->getID()));
}
if(mysqli_num_rows($sql)>0)
{
print '
Polecane artykuły
';
social($current_tutorial);
print '
Oto, co najczęściej czytają internauci, którzy przeczytali ten artykuł:
';
//print '
';
if($ignoreAPI == true)
{
$query = sprintf('id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id IN (SELECT tag_id FROM PoznajGoogleMaps_tagged WHERE tutorial_id = %d)) AND id != %d AND views>0 ORDER BY (1-0.48*commercial)*POW(0.01*datediff(now(),date)+1,2) * (SELECT max(views)+1 FROM toc)/(views + 1) ASC LIMIT 0,4;',$current_tutorial->getID(),$current_tutorial->getID());
}
else
{
$query = sprintf('api = "%d" AND id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id IN (SELECT tag_id FROM PoznajGoogleMaps_tagged WHERE tutorial_id = %d)) AND id != %d AND views>0 ORDER BY (1-0.48*commercial)*POW(0.01*datediff(now(),date)+1,2) * (SELECT max(views)+1 FROM toc)/(views + 1) ASC LIMIT 0,4;',$current_tutorial->get('api'),$current_tutorial->getID(),$current_tutorial->getID());
}
showTutorial($query);
//print '
';
print ' ';
print '
';
}
}
function basics($api,$curid=1)
{
if($api == 2)
{
$q = mysqli_query($conn, 'SELECT id,alias,name,description FROM toc WHERE id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id = "podstawy") ORDER BY id ASC;');
$offset = 0;
}
else
{
$q = mysqli_query($conn, 'SELECT id,alias,name,description FROM toc WHERE id IN (SELECT tutorial_id FROM PoznajGoogleMaps_tagged WHERE tag_id = "apiv3") ORDER BY id ASC;');
$offset = 100;
}
$basics = array();
while($read = mysqli_fetch_array($q))
{
$b = new Tutorial((int) $read['id']);
$b -> setName($read['name']);
$b -> setAlias($read['alias']);
$b -> setDescription($read['description']);
array_push($basics,$b);
}
$html = '