prepare("SELECT * FROM tblmembers WHERE memUsername = ? "); $getmember->execute(array($dofrey)); if ($memROW = $getmember->fetch(PDO::FETCH_ASSOC)) { ?>
Your profile has been updated.
'; } ?>

Profile

Username:
Level: ".$userlevel["leveltitle"].'
'; ?>
prepare("SELECT * FROM tblmemberprofile WHERE memID = ? "); $getprofile->execute(array($memROW["memID"])); if ($proROW = $getprofile->fetch(PDO::FETCH_ASSOC)) { echo '
'; echo '
'; echo 'Location: '.$proROW["mprLocation"]; echo '
'; echo '
'; echo $proROW["mprBio"]; echo '
'; echo '
'; } ?> edit
" class="mesButton mb-3">SEND A MESSAGE

Profile Stats

Member since:
Last active:

Statistics

Posts started:
Replies:

Recent Activity

prepare("SELECT count(tblreplies.repID) AS numberr FROM tblreplies INNER JOIN tblmembers ON tblreplies.memID = tblmembers.memID INNER JOIN tblposts ON tblreplies.posID = tblposts.posID WHERE tblmembers.memID = ? AND repStatus > ? AND posStatus = ? AND comID != ? "); $countquery->execute(array($memROW["memID"], '0', '1', '3')); $couROW = $countquery->fetch(PDO::FETCH_ASSOC); $total_results = $couROW["numberr"]; $total_pages = ceil($total_results/$limit); // echo $total_results.' - '.$total_pages; if (!isset($_GET['page'])) { $page = 1; } else { $page = $_GET['page']; } $pagination = ''; ?> prepare("SELECT * FROM tblposts WHERE comID IN ".$inarray." AND posStatus = ? ORDER BY posSticky DESC, tblposts.posID DESC LIMIT ".$limit." OFFSET ".$starting_limit." "); //$postfetch->execute(array( '1')); $postfetch = $dbh->prepare("SELECT * FROM tblreplies INNER JOIN tblmembers ON tblreplies.memID = tblmembers.memID INNER JOIN tblposts ON tblreplies.posID = tblposts.posID INNER JOIN tblcommunities ON tblposts.comID = tblcommunities.comID WHERE tblmembers.memID = ? AND repStatus > ? AND posStatus = ? AND tblposts.comID != ? ORDER BY repDate DESC LIMIT ".$limit." OFFSET ".$starting_limit." "); $postfetch->execute(array($memROW["memID"], '0', '1', '3')); while ($posROW = $postfetch->fetch(PDO::FETCH_ASSOC)) { echo '
'; echo '
'; echo '
'; echo showProfileImage($posROW["memID"]); echo '
'; $userlevel = userLevel($posROW["memID"]); echo '
'.$posROW["memUsername"].'
'.$userlevel["leveltitle"].'
'; echo '
'; echo '
'.date("F j, Y, g:i a",strtotime($posROW["repDate"])).'
'; echo '
'; echo '
'.$posROW["repContent"]."
"; if ($posROW["comUrl"] == "event") { $commoo = "event"; } else if ($posROW["comUrl"] == "karma") { $commoo = "karma"; } else if ($posROW["comUrl"] == "2012") { $commoo = "2012"; } else { $commoo = "owners-garage"; } echo ''; echo '
'; echo '
'; } ?>