World of Haulers News
Announcements, Updates & Events
announcement
query("SELECT `id` FROM `site_news_posts` WHERE `category`='1' AND `published`='1'")->num_rows;?>
Announcements
Topics posted View all
-
query("SELECT * FROM `site_news_posts` WHERE `category`='1' AND `published`='1' ORDER BY `id` DESC LIMIT 3");
while($row = $query->fetch_assoc()){
$new = '';
$latest = $sql->query("SELECT `id` FROM `site_news_posts` WHERE `published`='1' ORDER BY `id` DESC LIMIT 1")->fetch_assoc();
if($row['id'] == $latest['id']){
$new = 'New';
}
$author = $sql->query("SELECT `username`, `avatar` FROM `users` WHERE `id`='".$row['author']."'")->fetch_assoc();
if(preg_match('/https:\/\/(www\.)*/', $author['avatar'])){
$profile_avatar = $author['avatar'];
}else{
$profile_avatar = 'https://worldofhaulers.com/'.$author['avatar'];
}
echo '
-
'.$row['title'].' '.$new.'
Posted by '.$author['username'].''.date("d F Y", $row['ts']).'
';
}
?>
local_shipping
query("SELECT `id` FROM `site_news_posts` WHERE `category`='2' AND `published`='1'")->num_rows;?>
Updates
Topics posted View all
event
query("SELECT `id` FROM `site_news_posts` WHERE `category`='3' AND `published`='1'")->num_rows;?>
Events
Topics posted View all
-
query("SELECT * FROM `site_news_posts` WHERE `category`='3' AND `published`='1' ORDER BY `id` DESC LIMIT 3");
while($row = $query->fetch_assoc()){
$new = '';
$latest = $sql->query("SELECT `id` FROM `site_news_posts` WHERE `published`='1' ORDER BY `id` DESC LIMIT 1")->fetch_assoc();
if($row['id'] == $latest['id']){
$new = 'New';
}
$author = $sql->query("SELECT `username`, `avatar` FROM `users` WHERE `id`='".$row['author']."'")->fetch_assoc();
if(preg_match('/https:\/\/(www\.)*/', $author['avatar'])){
$profile_avatar = $author['avatar'];
}else{
$profile_avatar = 'https://worldofhaulers.com/'.$author['avatar'];
}
echo '
-
'.$row['title'].' '.$new.'
Posted by '.$author['username'].''.date("d F Y", $row['ts']).'
';
}
?>
Trending today
query("SELECT * FROM `site_news_posts` WHERE `published`='1' ORDER BY `views_today` DESC, `ts` DESC LIMIT 3");
while($row = $query->fetch_assoc()){
$author = $sql->query("SELECT `username`, `avatar` FROM `users` WHERE `id`='".$row['author']."'")->fetch_assoc();
if(preg_match('/https:\/\/(www\.)*/', $author['avatar'])){
$profile_avatar = $author['avatar'];
}else{
$profile_avatar = 'https://worldofhaulers.com/'.$author['avatar'];
}
$message = strip_tags($row['message']);
$message = preg_replace('/\s+/', ' ', trim($message));
$message = truncate($message, 300, "...");
$message = html_entity_decode($message, ENT_QUOTES);
echo '
';
}
?>
'.$row['title'].'
Posted by '.$author['username'].' '.date("d F Y", $row['ts']).'
'.truncate($message).' Read More