public function get_selected_record2($customer_id, $method)
{
$this->_db->where('customer_id', $customer_id);
$this->_db_ > where('payment_method', ".{$method}.");
$data = $this->_db->get(TBL_SUBSCRIPTION);
return $data;
}
public function index()
{
$offer = where('slug = %s', 'nieuwbouw')->get_row('offer/purpose');
echo view('head', array('title' => $offer && $offer->seo_title ? $offer->seo_title : 'Projecten', 'description' => $offer && $offer->seo_content ? $offer->seo_content : ''));
echo view('projects', array());
echo view('foot', array());
}
public function service($slug)
{
$service = where('slug = %s', $slug)->require_row('services/service');
echo view('head', array('title' => $service && $service->seo_title ? $service->seo_title : '', 'description' => $service && $service->seo_content ? $service->seo_content : ''));
echo view('service', array('service' => $service));
echo view('foot', array());
}
public function beforeAction($action)
{
$this->scanModules('payment');
$arrModules = Modules::model()->findAllByAttributes(array('category' => 'payment'), array('order' => 'module'));
$this->_allowAdvancedPayments = CPropertyValue::ensureBoolean(Yii::app()->params['ALLOW_ADVANCED_PAY_METHODS']);
$menuSidebar = array();
foreach ($arrModules as $module) {
$currentModule = Yii::app()->getComponent($module->module);
if (is_null($currentModule)) {
continue;
}
if ($currentModule->cloudCompatible === false && _xls_get_conf('LIGHTSPEED_CLOUD') > 0) {
continue;
}
if ($currentModule->isDisplayable() === false) {
continue;
}
$menuSidebar[] = array('label' => $currentModule->AdminName, 'url' => array('payments/module', 'id' => $module->module), 'advancedPayment' => $currentModule->advancedMode);
}
$advancedPaymentMethods = where($menuSidebar, array('advancedPayment' => true));
$simplePaymentMethods = where($menuSidebar, array('advancedPayment' => false));
$this->menuItems = array_merge(array(array('label' => 'Simple Integration Modules', 'linkOptions' => array('class' => 'nav-header'))), $simplePaymentMethods, array(array('label' => 'Advanced Integration Modules', 'linkOptions' => array('class' => 'nav-header'), 'visible' => count($advancedPaymentMethods) > 0)), $advancedPaymentMethods, $this->getPaymentSetupLinks());
$objModules = Modules::model()->findAllByAttributes(array('category' => 'payment', 'active' => 1));
if (count($objModules) === 0 && $action->id == "index") {
$this->noneActive = 1;
Yii::app()->user->setFlash('error', Yii::t('admin', 'WARNING: You have no payment modules activated. No one can checkout.'));
}
return parent::beforeAction($action);
}
/**
* Load entity
*
* @param array $entity
* @param array $crit
* @param array $opts
*
* @return array
*/
function flat_load(array $entity, array $crit = [], array $opts = []) : array
{
$stmt = db()->prepare(select($entity['attr']) . from($entity['tab']) . where($crit, $entity['attr'], $opts) . order($opts['order'] ?? [], $entity['attr']) . limit($opts['limit'] ?? 0, $opts['offset'] ?? 0));
$stmt->execute();
if (!empty($opts['one'])) {
return $stmt->fetch() ?: [];
}
return $stmt->fetchAll();
}
function searchProviders(Request $request)
{
$search = $request->input('search');
$users = User::where('role_id', 2) > where(function ($query) use($search) {
$query->Where('name', 'like', '%' . $search . '%')->orWhere('last_name', 'like', '%' . $search . '%')->orWhere('email', $search)->orWhere('second_name', 'like', '%' . $search . '%')->orWhere('second_last_name', 'like', '%' . $search . '%')->orWhere('identification', 'like', '%' . $search . '%');
})->paginate(50);
$roleName = $this->roleName;
$routeSearch = 'searchProvider';
return view('back.users', compact('users', 'roleName', 'routeSearch', 'search'));
}
public function index()
{
$home = get_row('home');
$sale = where('sold = 0 && purpose = 1')->limit(5)->order_by('create_date DESC')->get('skarabee/property');
$rent = where('sold = 0 && purpose = 2')->limit(5)->order_by('create_date DESC')->get('skarabee/property');
$projects = where('sold = 0 && type = 3')->limit(5)->order_by('create_date DESC')->get('skarabee/property');
echo view('head', array('class' => 'home', 'css' => 'home', 'title' => $home->seo_title ? $home->seo_title : $home->title, 'description' => $home->seo_content ? $home->seo_content : $home->content));
echo view('home', array('home' => $home, 'sale' => $sale, 'rent' => $rent, 'projects' => $projects));
echo view('foot', array('js' => 'home'));
}
function tiempo_vida($nombre)
{
$this->db->select('tiempo_vida');
$this->db - where('nombre', $nombre);
$tiempo = $this->db->get('producto');
if ($tiempo->num_rows() > 0) {
return $tiempo->result();
} else {
return false;
}
}
public function leftframe()
{
//左边的默认首页
$table = D('apptree');
$pid = $_GET['apptreeid'];
$leftdate = $table->findAll("type='0' and pid ='{$pid}'");
foreach ($leftdate as $k => $v) {
$leftdate[$k]['subapp'] = where(' pid =' . $v[id])->field('*')->order('seqNO ASC')->findall();
}
$this->assign('left', $leftdate);
//dump($leftdate);
$this->display();
}
public function excluirFuncionario($id_funcionario)
{
$result = false;
if (!isset($_SESSION)) {
session_start();
}
if (!isset($_SESSION['restaurante'])) {
return $result;
}
if (!empty($id_funcionario)) {
$this->_db > where("id_restaurante", $_SESSION['restaurante']);
$this->_db > where("id_funcionario", $id_funcionario);
return $this->_db->delete("functionario");
}
return $result;
}
private static function get_site_id()
{
$site = current_site();
if ($site->piwik_id) {
return $site->piwik_id;
}
$request = 'http://' . self::$api_urls[$_SERVER['SERVER_ADDR']] . '/?module=API&method=SitesManager.getSitesIdFromSiteUrl&url=http://' . rawurlencode($_SERVER['HTTP_HOST']) . '/&format=XML&token_auth=' . self::$auth_token;
$result = simplexml_load_string(curl($request));
if (isset($result->row->idsite)) {
$site_id = $result->row->idsite;
} else {
$site_id = self::create_site();
}
where('id = %d', $site->id)->update('site', array('piwik_id' => $site_id));
return $site_id;
}
/**
* Bind params, alias where()
* in query use :param after binding.
* @param array $data array('param'=>'value')
* @return none
*/
public function bind($data)
{
foreach ($data as $key => $value) {
where($key, $value);
}
}
public function function_delete($field, $object, $data, $id)
{
$fieldname = strval($field['name']);
$field_filename = strval($field['name']) . '_filename';
if (is_object($data)) {
if ($data->{$fieldname}) {
$data->{$fieldname}->clear_thumbnails();
}
@unlink(FILESPATH . $data->{$field_filename});
where('id = %d', $data->id)->update($object['stack'], array($fieldname . '_filename' => '', $fieldname . '_orig_filename' => '', $fieldname . '_upload_date' => ''));
redirect($_SERVER['HTTP_REFERER']);
} else {
error(404);
}
}
/** Create SQL condition from query string
* @param string
* @param array
* @return string
*/
function where_check($val, $fields = array())
{
parse_str($val, $check);
remove_slashes(array(&$check));
return where($check, $fields);
}
if ($f['size']) {
$toinsert = array();
$extension = substr($f['name'], strrpos($f['name'], '.') + 1);
do {
$name = md5(rand(0, 99999) . rand(0, 99999));
} while (file_exists(FILESPATH . $name . "." . $extension));
move_uploaded_file($f['tmp_name'], FILESPATH . $name . "." . $extension);
$toinsert['orig_filename'] = $f['name'];
$toinsert['filename'] = $name . '.' . $extension;
$toinsert['upload_date'] = time();
$toinsert["site_id"] = intval($site->id);
insert('site>downloads', $toinsert);
}
}
}
$site = where('id = %d', $site->id)->get_row('site');
?>
<!doctype html>
<!--[if lt IE 7 ]> <html class="no-js ie6" lang="en"> <![endif]-->
<!--[if IE 7 ]> <html class="no-js ie7" lang="en"> <![endif]-->
<!--[if IE 8 ]> <html class="no-js ie8" lang="en"> <![endif]-->
<!--[if (gte IE 9)|!(IE)]><!--> <html class="no-js" lang="en"> <!--<![endif]-->
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title><?php
echo l(array('nl' => 'Downloads', 'en' => 'Downloads', 'fr' => 'Downloads'));
?>
</title>
public function _get_parent_with_id($id)
{
if ($this->_parents) {
return $this->_parents->row_with_id($id);
}
if (count($this->_parent_ids) && $this->_parent_stack) {
$this->_parents = where('id IN %$', $this->_parent_ids)->get($this->_parent_stack);
return $this->_parents->row_with_id($id);
}
return NULL;
}
public function function_comments($field, $object, $data, $id)
{
if ($row = where('id = %d', intval($id))->get_row($object['stack'] . '/' . $field['name'])) {
$commentsfield = reset($field->xpath('object'));
if (!$commentsfield) {
error(404);
}
$commentsfield['stack'] = $object['stack'] . '/' . $field['name'] . '/' . $commentsfield['name'];
$commentsquery = where($field['name'] . '_id', intval($id));
$commentsamount = $commentsquery->count_rows($commentsfield['stack']);
$commentsdata = $commentsquery->get($commentsfield['stack']);
$segments = array_slice(func_get_args(), 4);
if (count($segments)) {
if (!FW4_Admin::handle_item($segments, $data)) {
error(404);
}
} else {
echo view("head", array("pages" => FW4_Admin::get_pages(), "title" => isset($commentsfield['title']) ? $commentsfield['title'] : 'Comments', "user" => FW4_User::get_user(), "site" => current_site()));
echo '<h2>' . (isset($commentsfield['title']) ? $commentsfield['title'] : 'Comments') . '</h2>';
echo '<div class="input"><fieldset>';
echo '<img src="' . $row->scale(100, 100) . '" class="thumbnail" style="display:inline-block;vertical-align:middle;margin-right:10px;"/><div style="display:inline-block;vertical-align:middle;">' . $row['orig_filename'] . '</div>';
echo '</fieldset></div>';
unset($commentsfield['title']);
FW4_Admin::print_object_list($commentsfield, $commentsdata, $commentsamount, intval($id));
echo '<div class="controls">';
echo '<a class="button save" href="' . preg_replace('/[^\\/]+\\/[^\\/]+\\/[^\\/]+\\/?$/', '', $_SERVER['REQUEST_URI']) . '">' . l(array('nl' => 'Terug', 'fr' => 'Retour', 'en' => 'Back')) . '</a>';
echo '</div>';
echo view("foot", array('scripts' => array()));
}
} else {
error(404);
}
}
function get_setting_by_id($id)
{
// return the setting
$this->db - where('id', $id);
$this->db->limit(1);
$query = $this->db->get('setting');
if ($query->num_rows() > 0) {
return $query->row();
}
// no result
return FALSE;
}
/** Functions displayed in edit form
* @param array single field from fields()
* @return array
*/
function editFunctions($field)
{
global $edit_functions;
$return = $field["null"] ? "NULL/" : "";
foreach ($edit_functions as $key => $functions) {
if (!$key || !isset($_GET["call"]) && (isset($_GET["select"]) || where($_GET))) {
// relative functions
foreach ($functions as $pattern => $val) {
if (!$pattern || preg_match("~{$pattern}~", $field["type"])) {
$return .= "/{$val}";
}
}
if ($key && !preg_match('~set|blob|bytea|raw|file~', $field["type"])) {
$return .= "/SQL";
}
}
}
if ($field["auto_increment"] && !isset($_GET["select"]) && !where($_GET)) {
$return = lang('Auto Increment');
}
return explode("/", $return);
}
public function handle_domain($domain, $fields)
{
$domainname = preg_replace('/^www\\./is', '', $domain);
if ($domain != 'www.' . $domainname && substr_count($domain, '.') < 2) {
header('Location: http://www.' . $domainname . $_SERVER['REQUEST_URI']);
}
foreach ($fields as $field) {
$stack = substr(strval($field['stack']), 0, strrpos(strval($field['stack']), '>'));
$row = where(strval($field['name']) . ' = %s', $domainname)->get_row($stack);
if ($row) {
Router::set_content_prefix(strval($field['handler']));
self::$current_domain = $row;
return true;
}
}
return false;
}
<?php
$TABLE = $_GET["edit"];
$fields = fields($TABLE);
$where = isset($_GET["select"]) ? count($_POST["check"]) == 1 ? where_check($_POST["check"][0], $fields) : "" : where($_GET, $fields);
$update = isset($_GET["select"]) ? $_POST["edit"] : $where;
foreach ($fields as $name => $field) {
if (!isset($field["privileges"][$update ? "update" : "insert"]) || $adminer->fieldName($field) == "") {
unset($fields[$name]);
}
}
if ($_POST && !$error && !isset($_GET["select"])) {
$location = $_POST["referer"];
if ($_POST["insert"]) {
// continue edit or insert
$location = $update ? null : $_SERVER["REQUEST_URI"];
} elseif (!preg_match('~^.+&select=.+$~', $location)) {
$location = ME . "select=" . urlencode($TABLE);
}
$indexes = indexes($TABLE);
$unique_array = unique_array($_GET["where"], $indexes);
$query_where = "\nWHERE {$where}";
if (isset($_POST["delete"])) {
queries_adminer_redirect($location, lang('Item has been deleted.'), $driver->delete($TABLE, $query_where, !$unique_array));
} else {
$set = array();
foreach ($fields as $name => $field) {
$val = process_input($field);
if ($val !== false && $val !== null) {
$set[idf_escape($name)] = $val;
}
*/
'SELECT name FROM user WHERE id = 4';
'SELECT name FROM user WHERE name = "Taras" AND age = 26';
'SELECT name FROM user WHERE (name = "Taras") AND (age > 26 AND age < 36 and age is not null)';
$first = array("id" => 4);
$second = array("name" => "Taras", "age" => 26);
$third = array("name" => "Taras", "age" => array(">" => "26", "<" => "36", "null" => false));
// (=, >, <, >=, <=, !=, in, not in, null)
function where(array $arrayWhere)
{
$conditionData = array();
foreach ($arrayWhere as $column => $condition) {
$columnWhereData = array();
if (!is_array($condition)) {
$condition = array("=" => $condition);
}
foreach ($condition as $operation => $value) {
$columnWhereData[] = getMappedCondition($column, $operation, $value);
}
$conditionData[] = implode(' AND ', $columnWhereData);
}
$conditionString = "WHERE " . (count($conditionData) ? " (" . implode(') AND (', $conditionData) . ")" : '1');
return $conditionString;
}
function getMappedCondition($column, $operation, $value)
{
$mapping = array("=" => "{$column} = '{$value}'", ">" => "{$column} > '{$value}'", "<" => "{$column} < '{$value}'", ">=" => "{$column} >= '{$value}'", "<=" => "{$column} <= '{$value}'", "!=" => "{$column} <> '{$value}'", "in" => $column . (is_array($value) ? " IN ('" . implode("','", $value) . "')" : " = '{$value}'"), "not in" => $column . (is_array($value) ? " NOT IN ('" . implode("','", $value) . "')" : " = '{$value}'"), "null" => $column . ($value == true ? " IS NULL" : " IS NOT NULL"));
return array_key_exists($operation, $mapping) ? $mapping[$operation] : "";
}
echo "SELECT name FROM user " . where($third) . ";";
$bikenum = trim($_GET["bikeno"]);
$stand = trim($_GET["stand"]);
$note = "";
if (isset($_GET["note"])) {
$note = trim($_GET["note"]);
}
checkbikeno($bikenum);
checkstandname($stand);
returnBike($userid, $bikenum, $stand, $note, TRUE);
break;
case "where":
logrequest($userid, $action);
checksession();
$bikenum = trim($_GET["bikeno"]);
checkbikeno($bikenum);
where($userid, $bikenum);
break;
case "removenote":
logrequest($userid, $action);
checksession();
checkprivileges($userid);
checkbikeno($bikenum);
removenote($userid, $bikenum);
break;
case "revert":
logrequest($userid, $action);
checksession();
$bikenum = trim($_GET["bikeno"]);
checkprivileges($userid);
checkbikeno($bikenum);
revert($userid, $bikenum);
parse_str($val, $delete);
$result = $mysql->query("DELETE FROM " . idf_escape($_GET["select"]) . " WHERE " . implode(" AND ", where($delete)) . " LIMIT 1");
if (!$result) {
break;
}
$deleted += $mysql->affected_rows;
}
} elseif ($_POST["delete_selected"]) {
if (!$_GET["page"]) {
$result = $mysql->query("DELETE {$from}");
$deleted = $mysql->affected_rows;
} else {
$result1 = $mysql->query("SELECT * {$from}");
while ($row1 = $result1->fetch_assoc()) {
parse_str(implode("&", unique_idf($row1, $indexes)), $delete);
$result = $mysql->query("DELETE FROM " . idf_escape($_GET["select"]) . " WHERE " . implode(" AND ", where($delete)) . " LIMIT 1");
if (!$result) {
break;
}
$deleted += $mysql->affected_rows;
}
$result1->free();
}
}
if ($result) {
redirect(remove_from_uri("page"), lang('%d item(s) have been deleted.', $deleted));
}
$error = $mysql->error;
}
page_header(lang('Select') . ": " . htmlspecialchars($_GET["select"]), $error ? lang('Error during deleting') . ": {$error}" : "");
if (isset($rights["insert"])) {
public function filterByMarginTo($value)
{
$this->getSelect()->joinNatural("customer_credits", array()) > where("margin <= ?", $value);
}
/**
* Join with and count the content of an associated collection (associated
* using either "hasMany" or "hasAndBelongsToMany").
* @param string $association Name of association.
* @param ReadSelection $selection Optional selection.
* @return ReadSelection Resulting selection.
*/
public function withCount($association, ReadSelection $selection = null)
{
if (!isset($selection)) {
$selection = new SelectionBuilder($this);
}
if (!isset($this->associations)) {
$this->createAssociations();
}
if (!isset($this->associations[$association])) {
throw new InvalidAssociationException(tr('Unknown association: %1', $association));
}
$field = $association;
$association = $this->associations[$field];
$other = $association['model'];
$thisKey = $association['thisKey'];
$otherKey = $association['otherKey'];
$id = $this->primaryKey;
$otherId = $other->primaryKey;
if (isset($association['join'])) {
$join = $association['join'];
$otherPrimary = $association['otherPrimary'];
$selection = $selection->leftJoin($join, where('J.%c = %m.%c', $thisKey, $this->name, $id), 'J');
$condition = where('%c.%c = J.%c', $field, $otherId, $otherKey);
$count = where('COUNT(J.%c)', $otherKey);
} else {
$condition = where('%c.%c = %m.%c', $field, $thisKey, $this->name, $id);
$count = where('COUNT(%c.%c)', $field, $thisKey);
}
if (isset($association['condition'])) {
$condition = $condition->and($association['condition']);
}
$selection = $selection->leftJoin($other, $condition, $field);
$selection->groupBy(where('%m.%c', $this->name, $id));
return $selection->with($field . '_count', $count, DataType::integer());
}
public function postSnomedParent($type)
{
$query = DB::table('curr_relationship_f')->select('sourceid')->distinct()->where('typeid', '=', '116680003')->where('active', '=', '1');
if ($type == "imaging") {
$query->where('destinationid', '=', '371571005');
}
if ($type == "lab") {
$query->where('destinationid', '=', '15220000');
}
if ($type == "cp") {
$query->where('destinationid', '=', '276341003');
$query->orWhere('destinationid', '=', '23426006');
}
if ($type == "ref") {
$query > where('destinationid', '=', '281100006');
}
$result = $query->get();
$arr = array();
if ($result) {
foreach ($result as $row) {
$term_row = DB::table('curr_description_f')->where('conceptid', '=', $row->sourceid)->where('active', '=', '1')->first();
$arr[] = array('data' => $term_row->term, 'attr' => array('id' => $row->sourceid), 'state' => 'closed');
}
}
echo json_encode($arr);
}
public static function get_user_by_id($id, $type = 'user')
{
return where('id = %d', intval($id))->get_row($type);
}
<?php
$TABLE = $_GET["edit"];
$table_status = table_status($TABLE);
$where = isset($_GET["select"]) ? count($_POST["check"]) == 1 ? where_check($_POST["check"][0]) : "" : where($_GET);
$update = isset($_GET["select"]) ? $_POST["edit"] : $where;
$fields = fields($TABLE);
foreach ($fields as $name => $field) {
if (!isset($field["privileges"][$update ? "update" : "insert"]) || $adminer->fieldName($field) == "") {
unset($fields[$name]);
}
}
if ($_POST && !$error && !isset($_GET["select"])) {
$location = $_POST["referer"];
if ($_POST["insert"]) {
// continue edit or insert
$location = $update ? null : $_SERVER["REQUEST_URI"];
} elseif (!ereg('^.+&select=.+$', $location)) {
$location = ME . "select=" . urlencode($TABLE);
}
if (isset($_POST["delete"])) {
query_redirect("DELETE" . limit1("FROM " . table($TABLE), " WHERE {$where}"), $location, array(lang('Item has been deleted.'), 'success'));
} else {
$set = array();
foreach ($fields as $name => $field) {
$val = process_input($field);
if ($val !== false && $val !== null) {
$set[idf_escape($name)] = $update ? "\n" . idf_escape($name) . " = {$val}" : $val;
}
}
if ($update) {
echo "<td bgcolor=\"orange\" width=\"10\" height=\"10\"> </td><td> - Remote files</td>";
echo "<td bgcolor=\"black\" width=\"10\" height=\"10\"> </td><td> - Warnings</td></tr></table><br>";
echo "<table class=\"tableheader\" cellspacing=\"1\" cellpadding=\"0\"><tr><td>";
echo "<table bgcolor=\"white\" cellspacing=\"1\" cellpadding=\"3\"><tr align=\"center\"><td class=\"tableheader\"> </td>\n";
echo "<td class=\"tableseparator\"><input name=\"allbox\" type=\"checkbox\" onClick=\"CheckAll();\" /></td>\n";
echo "<td class=\"tableheader\">Image name</td><td class=\"tableheader\">ID</td>";
echo "<td class=\"tableheader\">Category</td><td class=\"tableheader\">User Name</td><td class=\"tableheader\">Date</td><td class=\"tableheader\">Image file</td><td class=\"tableheader\">Ext.</td>" . ($thumbs ? "<td class=\"tableheader\">Thumb file</td><td class=\"tableheader\">Ext.</td>" : "") . "<td class=\"tableheader\">Action</td></tr>\n";
$i = 1;
foreach ($log as $key) {
$error = explode(",", $key);
$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_media_file, i.image_thumb_file, i.image_date" . get_user_table_field(", u.", "user_name") . "\n FROM " . IMAGES_TABLE . " i, " . USERS_TABLE . " u\n WHERE image_id = " . $error[0] . " AND " . get_user_table_field("u.", "user_id") . " = i.user_id\n LIMIT 1";
$image_row = $site_db->query_firstrow($sql);
$ok_show = ok($error[1]);
$ok_t_show = ok($error[2]);
$where = where($error[3]);
$where_t = where($error[4]);
echo "<tr align=\"center\" class=\"" . get_row_bg() . "\"><td>{$i}</td>";
echo "<td><input type=\"checkbox\" name=\"selectimages[]\" value=\"" . $image_row['image_id'] . "\" /></td>";
echo "<td align=\"left\">";
$thumb = "<img src=\"" . (empty($image_row['image_thumb_file']) ? ICON_PATH . "/" . get_file_extension($image_row['image_media_file']) . ".gif" : (is_remote($image_row['image_thumb_file']) ? remote_file_exists($image_row['image_thumb_file'], 1) ? $image_row['image_thumb_file'] : ICON_PATH . "/404.gif" : (file_exists(ROOT_PATH . THUMB_DIR . "/" . $image_row['cat_id'] . "/" . $image_row['image_thumb_file']) ? ROOT_PATH . THUMB_DIR . "/" . $image_row['cat_id'] . "/" . $image_row['image_thumb_file'] : ICON_PATH . "/404.gif"))) . "\" width=\"40\" height=\"40\" border=\"1\" alt=\"\" /><b> " . $image_row['image_name'] . "</b>";
echo "<a href=\"../images.php?action=editimage&image_id=" . $image_row['image_id'] . "\" target=\"4images_editimage\">" . $thumb . "</a>";
echo "</td><td>" . $image_row['image_id'] . "</td>";
echo "<td><a href=\"" . $site_sess->url(ROOT_PATH . "categories.php?" . URL_CAT_ID . "=" . $image_row['cat_id']) . "\" target=\"_blank\">" . htmlspecialchars($cat_cache[$image_row['cat_id']]['cat_name']) . " [ID: <b>" . $image_row['cat_id'] . "</b>]</a></td>\n";
$show_user_name = htmlspecialchars($image_row[$user_table_fields['user_name']]);
if ($image_row['user_id'] != GUEST && empty($url_show_profile)) {
$show_user_name = "<a href=\"" . $site_sess->url(ROOT_PATH . "member.php?action=showprofile&" . URL_USER_ID . "=" . $image_row['user_id']) . "\" target=\"_blank\">{$show_user_name}</a>";
}
echo "<td>" . $show_user_name . "</a></td>\n";
echo "<td>" . format_date($config['date_format'], $image_row['image_date']) . "</td>\n";
echo "<td><font color={$where}>{$ok_show}</font></td><td>" . substr(strrchr($image_row['image_media_file'], "."), 1) . "</td>" . ($thumbs ? "<td><font color={$where_t}>{$ok_t_show}</font></td><td>" . substr(strrchr($image_row['image_thumb_file'], "."), 1) . "</td>" : "") . "<td> ";
show_text_link("View", "../../details.php?" . URL_IMAGE_ID . "=" . $image_row['image_id'], 1);
