";
?>
";
if ($IMAGEFLOWSET['imageflow_align'] == "center") { echo "
"; }
echo "\n";
return $matches;
}
// Install
function imageflow_install()
{
global $CONFIG, $thisplugin;
require 'include/sql_parse.php';
// create table
$db_schema = $thisplugin->fullpath . '/schema.sql';
$sql_query = fread(fopen($db_schema, 'r'), filesize($db_schema));
$sql_query = preg_replace('/CPG_/', $CONFIG['TABLE_PREFIX'], $sql_query);
$sql_query = remove_remarks($sql_query);
$sql_query = split_sql_file($sql_query, ';');
echo $sqlquery;
foreach($sql_query as $q) {
cpg_db_query($q);
}
// insert default values
$db_schema = $thisplugin->fullpath . '/basic.sql';
$sql_query = fread(fopen($db_schema, 'r'), filesize($db_schema));
$sql_query = preg_replace('/CPG_/', $CONFIG['TABLE_PREFIX'], $sql_query);
$sql_query = remove_remarks($sql_query);
$sql_query = split_sql_file($sql_query, ';');
foreach($sql_query as $q) {
cpg_db_query($q);
}
return true;
}
// Unnstall and drop settings table
function imageflow_uninstall()
{
global $CONFIG;
cpg_db_query("DROP TABLE IF EXISTS {$CONFIG['TABLE_PREFIX']}mod_imageflow");
return true;
}
?>
= '{$CONFIG['min_votes_for_rating']}' $META_ALBUM_SET ORDER BY pic_rating DESC, votes DESC, pid DESC LIMIT $imageflowlimit";
}
// request string for meta album most viewed
else if ($IMAGEFLOWSET['imageflow_album'] == "topn") {
$imageflow_query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE filename like '%.jpg' AND filename not like 'youtube_%' AND approved = 'YES' $imageflow_FORBIDDEN_SET AND hits > 0 $META_ALBUM_SET ORDER BY hits DESC, filename LIMIT $imageflowlimit";
}
// request string for meta album last uploads
else if ($IMAGEFLOWSET['imageflow_album'] == "lastup") {
$imageflow_query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE filename like '%.jpg' AND filename not like 'youtube_%' AND approved = 'YES' $imageflow_FORBIDDEN_SET $META_ALBUM_SET ORDER BY pid DESC LIMIT $imageflowlimit";
}
// request string for meta album random pics
else
{
$imageflow_query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE filename like '%.jpg' AND filename not like 'youtube_%' AND approved = 'YES' $imageflow_FORBIDDEN_SET $META_ALBUM_SET ORDER BY RAND() LIMIT $imageflowlimit";
}
// result of request
$imageflow_result = cpg_db_query($imageflow_query);
// For reading result
$imageflow_rowset = array();
// Index of tab
$i=0;
// for each pic build HTML code
$imgflow_fixedsize = 0;
if (strtolower(substr($IMAGEFLOWSET['imageflow_width'],-2))=="px") {
$imgflow_fixedsize = trim(substr($IMAGEFLOWSET['imageflow_width'],0,strlen($IMAGEFLOWSET['imageflow_width'])-2));
}
while($imageflow_row = mysql_fetch_array($imageflow_result)){
if (!$IMAGEFLOWSET['imageflow_skipportrait'] || ($imageflow_row['pwidth']>$imageflow_row['pheight'])) {
// reading pid of pic
$imageflow_key=$imageflow_row['pid'];
// path of pic, depending if intermediate image is there or not
$imageflow_file=get_pic_url($imageflow_row,$IMAGEFLOWSET['imageflow_pictype']);
if (!(strpos($imageflow_file,'thumb_nopic') === FALSE)) $imageflow_file=get_pic_url($imageflow_row,'fullsize');
$imageflow_reflfile=get_pic_url($imageflow_row,'normal');
if (!(strpos($imageflow_reflfile,'thumb_nopic') === FALSE)) $imageflow_reflfile=get_pic_url($imageflow_row,'fullsize');
$imageflow_temppercent = $IMAGEFLOWSET['imageflow_procent'];
if (($imageflow_row['pwidth']<$CONFIG['picture_width']) && ($imageflow_row['pheight']<$CONFIG['picture_width'])) $imageflow_temppercent = 1;
// link of pic
if ($IMAGEFLOWSET['imageflow_useenlarge']) {
if ($imgflow_fixedsize == 0) {
$imageflow_lien="";
} else
{
$imageflow_lien="";
}
}
else
{
if ($imgflow_fixedsize == 0) {
$imageflow_lien="";
} else
{
$imageflow_lien="";
}
}
// building HTML code
$imageflow_pics .= $imageflow_lien."\n";
$i=$i+1;
}
}
// free memory
mysql_free_result($imageflow_result);
/* fill if not enough pictures in current category
if 3 or 4, repeat once to get 6 or 8 pics; if 2, repeat four times to get 8 pics; if only 1, repeat 8 times to get 8 pics */
if ($i<5) $imageflow_pics=$imageflow_pics.str_replace("iflowpic","iflow2pic",$imageflow_pics);
if ($i<3) $imageflow_pics=$imageflow_pics.str_replace("iflowpic","iflow3pic",str_replace("iflow2pic","iflow4pic",$imageflow_pics));
if ($i<2) $imageflow_pics=$imageflow_pics.str_replace("iflow4pic","iflow8pic",str_replace("iflow3pic","iflow7pic",str_replace("iflowpic","iflow5pic",str_replace("iflow2pic","iflow6pic",$imageflow_pics))));
// if no pictures found at all in current category, simply take random pictures from whole gallery
if ($i<1) {
$imageflow_pics='';
$imageflow_FORBIDDEN_SET = "";
if ($FORBIDDEN_SET != "") $imageflow_FORBIDDEN_SET = "$FORBIDDEN_SET";
$imageflow_query = "SELECT * FROM {$CONFIG['TABLE_PICTURES']} AS p WHERE filename like '%.jpg' AND filename not like 'youtube_%' AND approved = 'YES' $imageflow_FORBIDDEN_SET ORDER BY RAND() LIMIT $imageflowlimit";
// result of request
$imageflow_result = cpg_db_query($imageflow_query);
// For reading result
$imageflow_rowset = array();
// Index of tab
$i=0;
// For each pic.....building HTML in php
$imgflow_fixedsize = 0;
if (strtolower(substr($IMAGEFLOWSET['imageflow_width'],-2))=="px") {
$imgflow_fixedsize = trim(substr($IMAGEFLOWSET['imageflow_width'],0,strlen($IMAGEFLOWSET['imageflow_width'])-2));
}
while($imageflow_row = mysql_fetch_array($imageflow_result)){
if (!$IMAGEFLOWSET['imageflow_skipportrait'] || ($imageflow_row['pwidth']>$imageflow_row['pheight'])) {
// reading pid of pic
$imageflow_key=$imageflow_row['pid'];
// path of pic, depending if intermediate image is there or not
$imageflow_file=get_pic_url($imageflow_row,$IMAGEFLOWSET['imageflow_pictype']);
if (!(strpos($imageflow_file,'thumb_nopic') === FALSE)) $imageflow_file=get_pic_url($imageflow_row,'fullsize');
$imageflow_reflfile=get_pic_url($imageflow_row,'normal');
if (!(strpos($imageflow_reflfile,'thumb_nopic') === FALSE)) $imageflow_reflfile=get_pic_url($imageflow_row,'fullsize');
$imageflow_temppercent = $IMAGEFLOWSET['imageflow_procent'];
if (($imageflow_row['pwidth']<$CONFIG['picture_width']) && ($imageflow_row['pheight']<$CONFIG['picture_width'])) $imageflow_temppercent = 1;
// link of pic
if ($IMAGEFLOWSET['imageflow_useenlarge']) {
if ($imgflow_fixedsize == 0) {
$imageflow_lien="![\"".$imageflow_row['title']."\"](\"plugins/imageflow/js/reflect.php?bgc=".$IMAGEFLOWSET['imageflow_bgcolor']."&procent=".$imageflow_temppercent."&cache=".$IMAGEFLOWSET['imageflow_cache']."&img=".$imageflow_reflfile."\" "\\"\\"")
";
} else
{
$imageflow_lien="![\"".$imageflow_row['title']."\"](\"plugins/imageflow/js/reflect.php?bgc=".$IMAGEFLOWSET['imageflow_bgcolor']."&fixed=".$imgflow_fixedsize."&cache=".$IMAGEFLOWSET['imageflow_cache']."&img=".$imageflow_reflfile."\" "\\"\\"")
";
}
}
else
{
if ($imgflow_fixedsize == 0) {
$imageflow_lien="";
} else
{
$imageflow_lien="";
}
}
// building HTML code
$imageflow_pics .= $imageflow_lien."\n";
$i=$i+1;
}
}
// free memory
mysql_free_result($imageflow_result);
// if not a single pic in the whole gallery, use dummy pic from plugin folder
if ($i<1) $imageflow_pics="![\"Add](\"plugins/imageflow/js/reflect.php?bgc=".$IMAGEFLOWSET['imageflow_bgcolor']."&procent=".$IMAGEFLOWSET['imageflow_procent']."&cache=0&img=plugins/imageflow/nopicstoshow.jpg\")
";
/* fill if not enough random pictures in whole gallery
if 3 or 4, repeat once to get 6 or 8 pics; if 2, repeat four times to get 8 pics; if only 1, repeat 8 times to get 8 pics */
if ($i<5) $imageflow_pics=$imageflow_pics.str_replace("iflowpic","iflow2pic",$imageflow_pics);
if ($i<3) $imageflow_pics=$imageflow_pics.str_replace("iflowpic","iflow3pic",str_replace("iflow2pic","iflow4pic",$imageflow_pics));
if ($i<2) $imageflow_pics=$imageflow_pics.str_replace("iflow4pic","iflow8pic",str_replace("iflow3pic","iflow7pic",str_replace("iflowpic","iflow5pic",str_replace("iflow2pic","iflow6pic",$imageflow_pics))));
}
echo $imageflow_pics;
?>
";
/* fill if not enough random pictures in whole gallery
if 3 or 4, repeat once to get 6 or 8 pics; if 2, repeat four times to get 8 pics; if only 1, repeat 8 times to get 8 pics */
if ($i<5) $imageflow_pics=$imageflow_pics.str_replace("iflowpic","iflow2pic",$imageflow_pics);
if ($i<3) $imageflow_pics=$imageflow_pics.str_replace("iflowpic","iflow3pic",str_replace("iflow2pic","iflow4pic",$imageflow_pics));
if ($i<2) $imageflow_pics=$imageflow_pics.str_replace("iflow4pic","iflow8pic",str_replace("iflow3pic","iflow7pic",str_replace("iflowpic","iflow5pic",str_replace("iflow2pic","iflow6pic",$imageflow_pics))));
}
echo $imageflow_pics;
?>