/**
* @see MultipleLinkPage::countItems()
*/
public function countItems()
{
parent::countItems();
$sql = "SELECT\tCOUNT(*) AS count\r\n\t\t\tFROM\tbash" . BASH_N . "_favorite\r\n\t\t\tWHERE\tuserID = " . BASHCore::getUser()->userID;
$row = WCF::getDB()->getFirstRow($sql);
return $row['count'];
}
/**
* @see Action::execute()
*/
public function readParameters()
{
parent::readParameters();
if (BASHCore::getUser()->userID == 0) {
throw new PermissionDeniedException();
}
if (isset($_REQUEST['entryID'])) {
$this->entryID = intval($_REQUEST['entryID']);
}
}
public function save()
{
parent::save();
if ($this->server == null) {
$this->server = new Server($this->serverID);
}
$comment = ServerCommentEditor::create($this->server->serverID, BASHCore::getUser()->userID, $this->username, $this->text, TIME_NOW, $this->enableSmilies, $this->enableHtml, $this->enableBBCodes, BASHCore::getUser()->userID > 0 ? false : true);
if (MODULE_USER_RANK and BASHCore::getUser()->userID > 0) {
require_once WCF_DIR . 'lib/data/user/rank/UserRank.class.php';
UserRank::updateActivityPoints(SERVER_COMMENT_USER_ACTIVITY_POINTS);
}
HeaderUtil::redirect('index.php?page=ServerDetail&serverID=' . $comment->serverID . SID_ARG_2ND_NOT_ENCODED . '#comment' . $comment->commentID);
}
public function execute()
{
parent::execute();
$entry = new NewsEntryEditor($this->entryID);
if ($entry->entryID == 0) {
throw new IllegalLinkException();
}
if (!BASHCore::getUser()->getPermission('mod.bash.canDeleteNewsEntries') and BASHCore::getUser()->userID != $entry->authorID) {
throw new PermissionDeniedException();
}
NewsEntryEditor::remove($entry->entryID);
HeaderUtil::redirect('index.php?page=Index' . SID_ARG_2ND_NOT_ENCODED);
}
public function execute()
{
parent::execute();
$comment = new ServerCommentEditor($this->commentID);
if ($comment->commentID == 0) {
throw new IllegalLinkException();
}
if (!BASHCore::getUser()->getPermission('mod.comment.moderatorPermissions') and $comment->authorID != BASHCore::getUser()->userID) {
throw new PermissionDeniedException();
}
ServerCommentEditor::remove($comment->commentID);
HeaderUtil::redirect(BASHCore::getSession()->lastRequestURI, false);
}
public function execute()
{
parent::execute();
$entry = new BashEntryEditor($this->entryID);
if ($entry->entryID == 0) {
throw new IllegalLinkException();
}
if (!BASHCore::getUser()->getPermission('mod.bash.moderatorPermissions')) {
throw new PermissionDeniedException();
}
$entry->isDisabled = 0;
$entry->update();
HeaderUtil::redirect(BASHCore::getSession()->lastRequestURI, false);
}
public function show()
{
// check for permissions
if (!BASHCore::getUser()->userID) {
throw new PermissionDeniedException();
}
if (!BASHCore::getUser()->getPermission('mod.comment.moderatorPermissions') and !BASHCore::getUser()->getPermission('mod.bash.moderatorPermissions')) {
throw new PermissionDeniedException();
}
// activate usercpmenu
require_once WCF_DIR . 'lib/page/util/menu/UserCPMenu.class.php';
UserCPMenu::getInstance()->setActiveMenuItem('wcf.user.usercp.menu.link.modcp.overview');
parent::show();
}
public function readData()
{
parent::readData();
$sql = "SELECT\r\n\t\t\t \t*\r\n\t\t\t\tFROM\r\n\t\t\t \t\t`bash" . BASH_N . "_entry`" . ((BASHCore::getUser()->userID == 0 or !BASHCore::getUser()->isModerator()) ? ' WHERE `isDisabled` = 0 ' : '') . "\r\n\t\t\t\tORDER BY\r\n\t\t\t \tRAND()\r\n\t\t\t LIMIT 10";
$result = WCF::getDB()->sendQuery($sql);
while ($row = WCF::getDB()->fetchArray($result)) {
$this->entries[] = new ViewableBashEntry(null, $row);
}
// init sidebars
$this->sidebarFactory = new MessageSidebarFactory($this);
foreach ($this->entries as $entry) {
$this->sidebarFactory->create($entry);
}
$this->sidebarFactory->init();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$sql = "SELECT\r\n\t\t\t \t*\r\n\t\t\t\tFROM\r\n\t\t\t \t\t`bash" . BASH_N . "_entry`" . (BASHCore::getUser()->isModerator() ? '' : 'WHERE `isDisabled` = 0 ') . "\r\n\t\t\t\tORDER BY\r\n\t\t\t \ttimestamp DESC";
$result = WCF::getDB()->sendQuery($sql, $this->itemsPerPage, ($this->pageNo - 1) * $this->itemsPerPage);
while ($row = WCF::getDB()->fetchArray($result)) {
$this->entries[] = new ViewableBashEntry(null, $row);
}
// init sidebars
$this->sidebarFactory = new MessageSidebarFactory($this);
foreach ($this->entries as $entry) {
$this->sidebarFactory->create($entry);
}
$this->sidebarFactory->init();
}
public function readData()
{
parent::readData();
$sql = "SELECT\r\n\t\t\t \t`bash" . BASH_N . "_entry`.*\r\n\t\t\t\tFROM\r\n\t\t\t \t\t`bash" . BASH_N . "_entry`\r\n\t\t\t \tWHERE\r\n\t\t\t \t\t`bash" . BASH_N . "_entry`.authorID = " . $this->frame->getUserID() . (!BASHCore::getUser()->getPermission('mod.bash.moderatorPermissions') ? ' AND bash' . BASH_N . '_entry.isDisabled = 0' : '') . "\r\n\t\t\t\tORDER BY\r\n\t\t\t \t`bash" . BASH_N . "_entry`.`timestamp` DESC";
$result = WCF::getDB()->sendQuery($sql, $this->itemsPerPage, ($this->pageNo - 1) * $this->itemsPerPage);
while ($row = WCF::getDB()->fetchArray($result)) {
$this->entries[] = new ViewableBashEntry(null, $row);
}
// init sidebars
$this->sidebarFactory = new MessageSidebarFactory($this);
foreach ($this->entries as $entry) {
$this->sidebarFactory->create($entry);
}
$this->sidebarFactory->init();
}
/**
* @see Action::execute()
*/
public function execute()
{
parent::execute();
$entry = new BashEntryEditor($this->entryID);
if ($entry->entryID == 0) {
throw new IllegalLinkException();
}
if (!BASHCore::getUser()->getPermission('mod.bash.moderatorPermissions') and BASHCore::getUser()->userID != $entry->authorID) {
throw new PermissionDeniedException();
}
BashEntryEditor::remove($entry->entryID);
if (!isset($_REQUEST['ajax'])) {
HeaderUtil::redirect(BASHCore::getSession()->lastRequestURI, false);
}
}
/**
* Returnes a count of all outstanding moderations
*/
public function getOutstandingModerations()
{
$count = 0;
if (BASHCore::getUser()->getPermission('mod.bash.moderatorPermissions')) {
$sql = "SELECT\n\t\t\t\t\t\tCOUNT(*) AS count\n\t\t\t\t\tFROM\n\t\t\t\t\t\tbash" . BASH_N . "_entry\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tisDisabled = 1";
$result = WCF::getDB()->getFirstRow($sql);
$count = $count + intval($result['count']);
}
if (BASHCore::getUser()->getPermission('mod.comment.moderatorPermissions')) {
$sql = "SELECT\n\t\t\t\t\t\tCOUNT(*) AS count\n\t\t\t\t\tFROM\n\t\t\t\t\t\tbash" . BASH_N . "_server_comment\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tisDisabled = 1";
$result = WCF::getDB()->getFirstRow($sql);
$count = $count + intval($result['count']);
}
return $count;
}
/**
* If the user has already voted for this entry this should return true
* @param integer $userID
*/
public function hasVoted($userID = null)
{
if ($userID == null) {
$userID = BASHCore::getUser()->userID;
}
$sql = "SELECT\r\n\t\t\t\t\tCOUNT(*) AS count\r\n\t\t\t\tFROM\r\n\t\t\t\t\tbash" . BASH_N . "_vote\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tentryID = " . $this->entryID . "\r\n\t\t\t\tAND\r\n\t\t\t\t\tuserID = " . $userID;
$count = WCF::getDB()->getFirstRow($sql);
if ($count['count'] != 0) {
return true;
}
return false;
}
/**
* @see Form:.save()
*/
public function save()
{
parent::save();
$entry = BashEntryEditor::create(BASHCore::getUser()->userID, $this->username, $this->serverID, $this->serverName, $this->text, TIME_NOW, $this->enableSmilies, $this->enableHtml, $this->enableBBCodes);
if (MODULE_USER_RANK and BASHCore::getUser()->userID > 0) {
require_once WCF_DIR . 'lib/data/user/rank/UserRank.class.php';
UserRank::updateActivityPoints(BASH_USER_ACTIVITY_POINTS);
}
if (WCF::getUser()->userID > 0) {
HeaderUtil::redirect('index.php?page=BashEntry&entryID=' . $entry->entryID . SID_ARG_2ND_NOT_ENCODED);
} else {
// redirect to index
WCF::getTPL()->assign(array('url' => 'index.php' . SID_ARG_1ST, 'message' => WCF::getLanguage()->get('bash.page.bashEntryAdd.guestRedirect'), 'wait' => 10));
WCF::getTPL()->display('redirect');
exit;
}
// call event
$this->saved();
}
/**
* Deletes the bash entry from users favorite list
* @param integer $userID
*/
public function unfavorite($userID = null)
{
if ($userID == null) {
$userID = BASHCore::getUser()->userID;
}
$sql = "DELETE FROM\r\n\t\t\t\t\tbash" . BASH_N . "_favorite\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tentryID = " . $this->entryID . "\r\n\t\t\t\tAND\r\n\t\t\t\t\tuserID = " . $userID;
WCF::getDB()->sendQuery($sql);
}