public static function getCUD($where_id)
{
self::$db = Database::get();
$user_data = self::$db->select("\n\t\t\t\tSELECT \n\t\t\t\t\tu.userID, \n\t\t\t\t\tu.username, \n\t\t\t\t\tu.firstName, \n\t\t\t\t\tu.gender, \n\t\t\t\t\tu.userImage,\n\t\t\t\t\tu.email,\n\t\t\t\t\tu.LastLogin, \n\t\t\t\t\tu.SignUp,\n\t\t\t\t\tue.userID,\n\t\t\t\t\tue.website,\n\t\t\t\t\tue.aboutme\n\t\t\t\tFROM \n\t\t\t\t\t" . PREFIX . "users u\n\t\t\t\tLEFT JOIN\n\t\t\t\t\t" . PREFIX . "users_extprofile ue\n\t\t\t\t\tON u.userID = ue.userID\n\t\t\t\tWHERE \n\t\t\t\t\tu.userID = :userID\n\t\t\t\t", array(':userID' => $where_id));
return $user_data;
}
public static function getCUGroups($where_id)
{
self::$db = Database::get();
$user_groups = self::$db->select("\n SELECT\n ug.userID, ug.groupID, g.groupID, g.groupName, g.groupDescription, g.groupFontColor, g.groupFontWeight\n FROM\n " . PREFIX . "users_groups ug\n LEFT JOIN\n " . PREFIX . "groups g\n ON g.groupID = ug.groupID\n WHERE\n ug.userID = :userID\n ", array(':userID' => $where_id));
return $user_groups;
}
/**
* Get Current User's Groups Data For Display
*/
public function getUserGroups($where_id)
{
self::$db = Database::get();
$user_groups = self::$db->select("\n SELECT\n ug.userID, ug.groupID, g.groupID, g.groupName, g.groupDescription, g.groupFontColor, g.groupFontWeight\n FROM\n " . PREFIX . "users_groups ug\n LEFT JOIN\n " . PREFIX . "groups g\n ON g.groupID = ug.groupID\n WHERE\n ug.userID = :userID\n ", array(':userID' => $where_id));
if (isset($user_groups)) {
foreach ($user_groups as $row) {
$usergroup[] = " <font color='{$row->groupFontColor}' weight='{$row->groupFontWeight}'>{$row->groupName}</font> ";
}
}
return $usergroup;
}