source: extensions/ContestResults/admin/get_tn.php @ 9975

<?php
define('PHPWG_ROOT_PATH','./../../../');
define('IN_ADMIN', true);
include_once(PHPWG_ROOT_PATH.'include/common.inc.php');

$image = pwg_query("SELECT id, name, file, path, tn_ext
        FROM " . IMAGES_TABLE . "
        WHERE id = " . pwg_db_real_escape_string($_GET['image_id']) . ";");

if (!pwg_db_num_rows($image)) {
        $data['TN_SRC'] = 'admin/themes/default/icon/errors.png';
        $data['IMAGE_NAME'] = 'N/A';
        
} else {
        $image = pwg_db_fetch_assoc($image);
        $data['TN_SRC'] = get_thumbnail_url($image);
        $data['IMAGE_NAME'] = (empty($image['name'])) ? get_name_from_file($image['file']) : $image['name'];
}

echo "<img src='" . str_replace('../../.', '', $data['TN_SRC']) . "'/><br>" . $data['IMAGE_NAME'];
?>