Show Posts
1
Mods & Plugins (Requests & Discussions) / Re: Autoviewer for 4images
« on: January 26, 2009, 09:16:13 AM »
Thank you Mawenzi!
Now it works correctly!
autoviewer.php
Now it works correctly!
autoviewer.php
Code: [Select]
<?php
/**************************************************************************
* 4images - A Web Based Image Gallery Management System *
* ---------------------------------------------------------------- *
* File: tiltviewer.php by mawenzi *
* File-Version: 1.0 - 26.02.2008 *
* Copyright: (C) 2002 Jan Sorgalla *
* Email: jan@4homepages.de *
* Web: http://www.4homepages.de *
* Scriptversion: 1.7.x *
*
*************************************************************************/
define('GET_CACHES', 1);
define('ROOT_PATH', './');
define('GET_USER_ONLINE', 1);
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_date, i.image_active, i.image_media_file, c.cat_name".get_user_table_field(", u.", "user_name")."
FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
WHERE i.image_active = 1 AND i.cat_id = '98' AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
ORDER BY i.cat_id DESC
LIMIT 0,75
";
$result = $site_db->query($sql);
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
echo "<gallery frameColor=\"0x5c5c5c\" frameWidth=\"0\" imagePadding=\"5\" displayTime=\"4\" enableRightClickOpen=\"false\">";
while ($image_row = $site_db->fetch_array($result)){
$image_url = ROOT_PATH."data/media/".$image_row['cat_id']."/".$image_row['image_media_file'];
$image_info = @getimagesize($image_url);
$image_width = $image_info[0];
$image_height = $image_info[1];
echo "<image>";
echo "<url>".$image_url."</url>";
echo "<caption>".multilang($image_row['image_name'])."</caption>";
echo "<width>".$image_width."</width>";
echo "<height>".$image_height."</height>";
echo "</image>";
} // end while
echo "</gallery>";
?>
