/** * Return an array of videos * * @param DatabaseMysql $db * @return array */ protected static function getVideoRows(DatabaseMysql $db) { return (new WikiaSQL())->SELECT('img_name', 'img_metadata', 'img_sha1')->FROM('image')->WHERE('img_media_type')->EQUAL_TO('VIDEO')->AND_(FluentSql\StaticSQL::RAW('img_name <> CONVERT(img_name USING ASCII)'))->runLoop($db, function (&$videos, $row) { $videos[] = $row; }); }
/** * includes common for all wikis */ require_once $IP . "/includes/wikia/Defines.php"; require_once $IP . "/includes/wikia/GlobalFunctions.php"; require_once $IP . "/includes/wikia/Wikia.php"; require_once $IP . "/includes/wikia/WikiaMailer.php"; require_once $IP . "/extensions/Math/Math.php"; /** * Add composer dependencies before proceeding to lib/Wikia. For now, we are committing * dependencies added via composer to lib/composer until external dependencies with composer/packagist * can be eliminated. */ require_once "{$IP}/lib/composer/autoload.php"; // configure FluentSQL to use the extended WikiaSQL class FluentSql\StaticSQL::setClass("\\WikiaSQL"); /** * All lib/Wikia assets should conform to PSR-4 autoloader specification. See * ttps://github.com/php-fig/fig-standards/blob/master/accepted/PSR-4-autoloader.md. */ require_once $IP . "/lib/Wikia/autoload.php"; require_once $IP . "/lib/Swagger/autoload.php"; global $wgDBname; if ($wgDBname != 'uncyclo') { include_once "{$IP}/extensions/wikia/SkinChooser/SkinChooser.php"; } /** * autoload classes */ global $wgAutoloadClasses; /**