private function AuthorBy($condition)
{
$userAuthorsFolder = Settings::getInstance()->p['userAuthorsFolder'];
$sql = "SELECT AuthorId, Name, UniqueName, Image, UserId FROM Author {$condition}";
$result = $this->mysqli->query($sql);
$recordsCount = mysqli_num_rows($result);
$data = 0;
if ($recordsCount >= 1 && $result != null) {
$row = mysqli_fetch_array($result);
$authorPictureUrl = strlen($row[Image]) > 0 ? parent::GetImageUrl($row['UserId'], $row['Image'], $userAuthorsFolder) : "";
$authorThumbnailUrl = strlen($row[Image]) > 0 ? parent::GetImageUrl($row['UserId'], $row['Image'], $userAuthorsFolder, true) : "";
$data = array('AuthorId' => intval($row['AuthorId']), 'UniqueName' => $row['UniqueName'], 'Name' => $row['Name'], 'Image' => $row['Image'], 'ImageUrl' => $authorPictureUrl, 'ThumbnailUrl' => $authorThumbnailUrl, 'UserId' => intval($row['UserId']));
}
return $data;
}
public function UserById($userId)
{
global $authIssueText;
$userUserFolder = Settings::getInstance()->p['userUserFolder'];
$sql = "SELECT UserId, Email, Username, FirstName, LastName, Country, Image, RegistrationDateTime, LastLoginDateTime, UserStateId, LoginAttempts, MobilePhone, Language, Role.RoleId, Role.Name AS RoleName, Role.Modules AS RoleModules FROM User, Role WHERE UserId = {$userId} AND User.RoleId = Role.RoleId";
$result = $this->mysqli->query($sql);
$recordsCount = mysqli_num_rows($result);
$data = null;
if ($recordsCount >= 1 && $result != null) {
$row = mysqli_fetch_array($result);
$imageUrl = parent::GetImageUrl($row['UserId'], $row['Image'], $userUserFolder);
$imageThumbnailUrl = parent::GetImageUrl($row['UserId'], $row['Image'], $userUserFolder, true);
$data = array('UserId' => intval($row['UserId']), 'Email' => $row['Email'], 'Username' => $row['Username'], 'FirstName' => $row['FirstName'], 'LastName' => $row['LastName'], 'Country' => $row['Country'], 'Image' => $row['Image'], 'ImageUrl' => $imageUrl, 'ThumbnailUrl' => $imageThumbnailUrl, 'RegistrationDateTime' => $row['RegistrationDateTime'], 'LastLoginDateTime' => $row['LastLoginDateTime'], 'UserStateId' => intval($row['UserStateId']), 'LoginAttempts' => intval($row['LoginAttempts']), 'MobilePhone' => $row['MobilePhone'], 'Language' => $row['Language'], 'Role' => new Role($row['RoleId'], $row['RoleName'], $row['RoleModules']));
}
return $data;
}
public function ArticleById($IdArticle, $IdUser = null)
{
$userArticlesFolder = Settings::getInstance()->p['userArticlesFolder'];
$ArticleFieldsSql = " Article.UserId, Article.ArticleId, Article.Title, Article.Image, Article.Description AS Description, Article.DateTime, Article.YouTubeLink, Article.FlickrLink, Article.Language, Article.Published, Article.Category ";
$sql = "SELECT {$ArticleFieldsSql}, AuthorId FROM Article WHERE ArticleId = {$IdArticle}";
$result = $this->mysqli->query($sql);
$recordsCount = mysqli_num_rows($result);
$data = 0;
if ($recordsCount >= 1 && $result != null) {
$row = mysqli_fetch_array($result);
$imageUrl = parent::GetImageUrl($row['UserId'], $row['Image'], $userArticlesFolder);
$imageThumbnailUrl = parent::GetImageUrl($row['UserId'], $row['Image'], $userArticlesFolder, true);
$ShortDescription = parent::substrwords(strip_tags($row['Description']), 120);
$AuthorsHandler = new AuthorsDatabaseHandler();
$data = array('ArticleId' => intval($row['ArticleId']), 'Title' => $row['Title'], 'Image' => $row['Image'], 'ImageUrl' => $imageUrl, 'ThumbnailUrl' => $imageThumbnailUrl, 'Description' => $row['Description'], 'DateTime' => $row['DateTime'], 'YouTubeLink' => $row['YouTubeLink'], 'FlickrLink' => $row['FlickrLink'], 'Language' => $row['Language'], 'Published' => intval($row['Published']), 'Category' => $row['Category'], 'ShortDescription' => $ShortDescription, 'Author' => $AuthorsHandler->AuthorById($row['AuthorId']), 'UserId' => intval($row['UserId']));
}
return $data;
}
function EventById($EventId)
{
$userEventsFolder = Settings::getInstance()->p['userEventsFolder'];
$EventFieldsSql = " Event.UserId, Event.EventId, Event.Title, Event.Image, Event.Description AS Description, Event.CreationDateTime, Event.DateTime, Event.FacebookLink, Event.YouTubeLink, Event.FlickrLink, Event.Language, Event.Published, Event.Statistics ";
$sql = "SELECT {$EventFieldsSql}, AuthorId, LocationId FROM Event WHERE Event.EventId = {$EventId}";
$result = $this->mysqli->query($sql);
$recordsCount = mysqli_num_rows($result);
$data = 0;
if ($recordsCount >= 1 && $result != null) {
$row = mysqli_fetch_array($result);
$imageUrl = parent::GetImageUrl($row['UserId'], $row['Image'], $userEventsFolder);
$imageThumbnailUrl = parent::GetImageUrl($row['UserId'], $row['Image'], $userEventsFolder, true);
$ShortDescription = parent::substrwords(strip_tags($row['Description']), 120);
$Description = $row['Description'];
$AuthorsDbHandler = new AuthorsDatabaseHandler();
$LocationsDbHandler = new LocationsDatabaseHandler();
$data = array('EventId' => $row['EventId'], 'Title' => $row['Title'], 'Image' => $row['Image'], 'ImageUrl' => $imageUrl, 'ThumbnailUrl' => $imageThumbnailUrl, 'Description' => $Description, 'CreationDateTime' => $row['CreationDateTime'], 'DateTime' => $row['DateTime'], 'FacebookLink' => $row['FacebookLink'], 'YouTubeLink' => $row['YouTubeLink'], 'FlickrLink' => $row['FlickrLink'], 'Language' => $row['Language'], 'Published' => $row['Published'], 'ShortDescription' => $ShortDescription, 'LocationId' => $row['LocationId'], 'Location' => $LocationsDbHandler->LocationById($row['LocationId']), 'AuthorId' => $row['AuthorId'], 'Author' => $AuthorsDbHandler->AuthorById($row['AuthorId']), 'UserId' => $row['UserId'], 'Statistics' => $row['Statistics']);
}
return $data;
}