Beiträge von Cyperghost

<<<<<<<<387b23b739069b9760cd70ca5f7045c66a7ab7a9<<<<
Sun, 10 Jul 2016 11:07:20 +0000
Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wbb4_db.wbb1_thread_ignore' doesn't exist
File: /var/www/virtual/***/htdocs/wcf/lib/system/database/Database.class.php (231)
PHP version: 5.5.9-1ubuntu4.17
WCF version: 2.1.11 (Typhoon)
Request URI: /index.php?board/60-off-topic-und-chatforum/
Referrer: http://www.***/
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:39.0) Gecko/20100101 Firefox/39.0
Information: "<b>sql type:<\/b> wcf\\system\\database\\MySQLDatabase<br \/><b>sql error:<\/b> Table 'wbb4_db.wbb1_thread_ignore' doesn't exist<br \/><b>sql error number:<\/b> 42S02<br \/><b>sql version:<\/b> 5.5.49-0ubuntu0.14.04.1<br \/><b>sql query:<\/b> SELECT\tthread.threadID AS objectID\n\t\t\tFROM\twbb1_thread thread\n\t\t\t\t\n\t\t\t\tWHERE (SELECT COUNT(*) FROM wbb1_thread_ignore WHERE userID = ? AND threadID = thread.threadID) = 0 AND thread.threadID IN (?,?,?,?,?) AND thread.isDeleted = 0 AND thread.isDisabled = 0 AND thread.movedThreadID IS NULL\n\t\t\t\tORDER BY thread.replies DESC, thread.lastPostTime DESC LIMIT 5<br \/>"
Stacktrace: 
  #0 /var/www/virtual/***/htdocs/wcf/lib/data/DatabaseObjectList.class.php(167): wcf\system\database\Database->prepareStatement('SELECT?thread.t...', 5, 0)
  #1 /var/www/virtual/***/htdocs/lib/data/thread/MostActiveThreadList.class.php(68): wcf\data\DatabaseObjectList->readObjectIDs()
  #2 /var/www/virtual/***/htdocs/lib/system/dashboard/box/MostActiveThreadsDashboardBox.class.php(35): wbb\data\thread\MostActiveThreadList->__construct(60)
  #3 /var/www/virtual/***/htdocs/wcf/lib/system/dashboard/DashboardHandler.class.php(71): wbb\system\dashboard\box\MostActiveThreadsDashboardBox->init(Object(wcf\data\dashboard\box\DashboardBox), Object(wbb\page\BoardPage))
  #4 /var/www/virtual/***/htdocs/lib/page/BoardPage.class.php(356): wcf\system\dashboard\DashboardHandler->loadBoxes('com.woltlab.wbb...', Object(wbb\page\BoardPage))
  #5 /var/www/virtual/***/htdocs/wcf/lib/page/AbstractPage.class.php(276): wbb\page\BoardPage->assignVariables()
  #6 /var/www/virtual/***/htdocs/wcf/lib/page/AbstractPage.class.php(100): wcf\page\AbstractPage->show()
  #7 /var/www/virtual/***/htdocs/wcf/lib/system/request/Request.class.php(58): wcf\page\AbstractPage->__run()
  #8 /var/www/virtual/***/htdocs/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
  #9 /var/www/virtual/***/htdocs/index.php(10): wcf\system\request\RequestHandler->handle('wbb')
  #10 {main}
<<<<

<?php
namespace wcf\system\bbcode;
use wcf\system\application\ApplicationHandler;
use wcf\system\request\RouteHandler;
use wcf\util\StringUtil;


/**
 * Parses the [url] bbcode tag.
 *
 * @author Marcel Werk
 * @copyright 2001-2015 WoltLab GmbH
 * @license GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
 * @package com.woltlab.wcf
 * @subpackage system.bbcode
 * @category Community Framework
 */
class URLBBCode extends AbstractBBCode {
	/**
	 * @see \wcf\system\bbcode\IBBCode::getParsedTag()
	 */
	public function getParsedTag(array $openingTag, $content, array $closingTag, BBCodeParser $parser) {
		$url = '';
		if (isset($openingTag['attributes'][0])) {
			$url = $openingTag['attributes'][0];
		}


		$noTitle = ($content == $url);
		$url = StringUtil::decodeHTML($url);


		// add protocol if necessary
		if (!preg_match("/[a-z]:\/\//si", $url)) $url = 'http://'.$url;


		return $this->getAnchorTag($url, (!$noTitle ? $content : ''), false);
	}




	/**
	 * Generates an anchor tag from given URL.
	 *
	 * @param string $url
	 * @param string $title
	 * @param boolean $encodeTitle
	 * @return string anchor tag
	 */
	private function getAnchorTag($url, $title = '', $encodeTitle = true) {
		$url = StringUtil::trim($url);


		$external = true;
		if (ApplicationHandler::getInstance()->isInternalURL($url)) {
			$external = false;
			$url = preg_replace('~^https?://~', RouteHandler::getProtocol(), $url);
		}


		// cut visible url
		if (empty($title)) {
			// use URL and remove protocol and www subdomain
			$title = preg_replace('~^(?:https?|ftps?)://(?:www\.)?~i', '', $url);


			if (mb_strlen($title) > 60) {
				$title = mb_substr($title, 0, 30) . StringUtil::HELLIP . mb_substr($title, -25);
			}


			if (!$encodeTitle) $title = StringUtil::encodeHTML($title);
		}


		return '<a href="'.StringUtil::encodeHTML($url).'"'.($external ? (' class="thumber externalURL"'.(EXTERNAL_LINK_REL_NOFOLLOW ? ' rel="nofollow"' : '').(EXTERNAL_LINK_TARGET_BLANK ? ' target="_blank"' : '')) : ' class="thumber"').'><img src="https://thumber.de/image/?size=SXXXL3DL&bg=transparent&url='.StringUtil::encodeHTML($url).'" /></a>';
	}
}