Thank you for the reply.
I will ask for help with the one remaining issue with this plugin that I can't seem to solve. (probably because the obvious is being overlooked.....)
The image set is generated by file flow_link.php. It makes output of .xml for the .swf player to use.
The bug/issue is that the query LIMIT value is made short by a value of 1. It will not respect the first selection, no matter what type of META album is used. (random, last up, most viewed, top-rated). Ask for 10, it will return 9 - ask for 22, it will return 21.
Here is a "lightweight" version of flow_link.php. The plugin variables have been removed. It will run by itself when located in the iscroll plugin folder. [ index.php?file=iscroll/test_flow_link ]
<?php
// test file for iscroll plugin db LIMIT select
define('IN_COPPERMINE', true);
require_once('include/init.inc.php');
$path=$CONFIG['site_url'];
$xml = '<?xml version="1.0"?><content>';
if ($FORBIDDEN_SET != "") $FORBIDDEN_SET = "AND $FORBIDDEN_SET";
$result = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE filename LIKE '%.jpg' AND filename not like 'youtube_%' $FORBIDDEN_SET $META_ALBUM_SET ORDER BY pid DESC LIMIT 10");
$row = mysql_fetch_array($result);
while ($row = mysql_fetch_array($result))
{
$type = max($row['pwidth'], $row['pheight']) > $CONFIG['picture_width'] ? 'thumb' : 'thumb';
$xml .= "<image>
<path><![CDATA[" . $path . get_pic_url($row, $type) . "]]></path>
<description><![CDATA[" . $row['title'] . "]]></description>
<data><![CDATA[" . $path . "displayimage.php?pos=-" . $row['pid'] . "]]></data>
</image>";
}
$xml .= '</content>';
echo $xml;
?>
The .xml output from this example is 9, not the LIMIT of 10.
Thanks in advance for time and replies.