//if thumb_x or thumb_y == 0, aspect ratio of original will be maintained
//based on the given thumb_x or thumb_y
function createthumb($image_source,$thumb_x,$thumb_y,$output_file)
{
$backup_file = $output_file. "_backup.jpg";
copy($image_source,$backup_file);
//echo $backup_file;
$image_properties = GetImageSize($backup_file);
if (!$image_properties[2] == 2)
{
return(0);
}
else
{
$src_image = imagecreatefromjpeg($backup_file);
$src_x = imagesx($src_image);
$src_y = imagesy($src_image);
if (($thumb_y == "0") && ($thumb_x == "0"))
{
return(0);
}
elseif ($thumb_y == "0")
{
$scalex = $thumb_x/($src_x-1);
$thumb_y = $src_y*$scalex;
}
elseif ($thumb_x == "0")
{
$scaley = $thumb_y/($src_y-1);
$thumb_x = $src_x*$scaley;
}
$thumb_x = (int)($thumb_x);
$thumb_y = (int)($thumb_y);
$dest_image = imagecreatetruecolor($thumb_x, $thumb_y);
unlink($backup_file);
if (!ImageCopyResampled($dest_image, $src_image, 0, 0, 0, 0, $thumb_x, $thumb_y, $src_x, $src_y))
{
imagedestroy($src_image);
imagedestroy($dest_image);
return(0);
}
else
{
imagedestroy($src_image);
if (ImageJPEG($dest_image,$output_file,80))
{
imagedestroy($dest_image);
return(1);
}
imagedestroy($dest_image);
}
return(0);
}
}
//input is in dd-mm-yy format
//output is in yyyy-mm-dd
function date_mysql_format($in_date)
{
$date_array = explode( '-', $in_date );
$days = (int)$date_array[0];
$months = (int)$date_array[1];
$years = (int)$date_array[2];
if (checkdate($months, $days, $years))
return implode( '-', array_reverse( explode( '-', $in_date ) ) );
}
//input is in yyyy-mm-dd
//output is in dd-mm-yyyy format
function date_format_aust($in_date)
{
//date("d M Y", strtotime($your_row['lastlogin_date']))
return implode( '-', array_reverse( explode( '-', $in_date ) ) );
}
//print out the page number bar
//and return group query string
function page_numbers($cur_page, $page_jump, $sql)
{
$limit_str = "LIMIT ". $cur_page * $page_jump .",$page_jump";
$group_str = $sql." ".$limit_str;
//echo $group_str;
//$group_results = mysql_query($group_str);
$num_sql = mysql_query($sql);
$num_rows = mysql_num_rows($num_sql);
$page_num = $cur_page + 1;
$total_num_page = ceil($num_rows/$page_jump);
?>
if ($total_num_page > 1)
{
?>
echo "[Page $page_num/$total_num_page]";
for ($counter=0; $counter<=$total_num_page-1; $counter++)
{
$page_jump = $counter +1;
?>
[ echo $page_jump; ?>]
}
?>
}
?>
return $group_str;
}//function
//print out the page number bar
//and return group query string
function photo_page_numbers($cur_page, $page_jump, $sql, $iduse)
{
$limit_str = "LIMIT ". $cur_page * $page_jump .",$page_jump";
$group_str = $sql." ".$limit_str;
//echo $group_str;
//$group_results = mysql_query($group_str);
$num_sql = mysql_query($sql);
$num_rows = mysql_num_rows($num_sql);
$page_num = $cur_page + 1;
$total_num_page = ceil($num_rows/$page_jump);
?>
if ($total_num_page > 1)
{
?>
echo "[Page $page_num/$total_num_page]";
for ($counter=0; $counter<=$total_num_page-1; $counter++)
{
$page_jump = $counter +1;
?>
[ echo $page_jump; ?>]
}
?>
}
?>
return $group_str;
}//function
//print out the page number bar
//and return group query string
function search_query($cur_page, $page_jump, $search_date)
{
$sql_search = "SELECT * FROM event WHERE event_active = 'y'";
$word_str = "";
$cat_str = "";
$date_str = "";
if(!empty($search_date))
{
$my_search_date = date_mysql_format($search_date);
$sql_search.= " AND '$my_search_date' BETWEEN event_start_date AND event_finish_date";
//$search2_date = urlencode($search_date);
$date_str = "&search_date=$search_date";
}
$limit_str = "LIMIT ". $cur_page * $page_jump .",$page_jump";
$group_str = $sql_search." ".$limit_str;
//echo $group_str;
$num_sql = mysql_query($sql_search);
$num_rows = mysql_num_rows($num_sql);
if ($num_rows < 1)
{
echo("No Results listed for the date you specified. Please try another search.");
}
$page_num = $cur_page + 1;
$total_num_page = ceil($num_rows/$page_jump);
?>
if ($total_num_page > 1)
{
?>
echo "[Page $page_num/$total_num_page]";
for ($counter=0; $counter<=$total_num_page-1; $counter++)
{
$page_jump = $counter +1;
?>
[ echo $page_jump; ?>]
}
?>
}
?>
return $group_str;
}//function
//print out the page number bar
//and return group query string
function event_first_page($cur_page, $page_jump)
{
$today = date("Y-m-d");
$sql_search = "SELECT * FROM event WHERE event_active = 'y' AND event_start_date <= ADDDATE('$today', INTERVAL 7 DAY) ORDER BY event_start_date ASC";
$word_str = "";
$cat_str = "";
$date_str = "";
$limit_str = "LIMIT ". $cur_page * $page_jump .",$page_jump";
$group_str = $sql_search." ".$limit_str;
//echo $group_str;
$num_sql = mysql_query($sql_search);
$num_rows = mysql_num_rows($num_sql);
if ($num_rows < 1)
{
echo("No Results listed for the date you specified. Please try another search.");
}
$page_num = $cur_page + 1;
$total_num_page = ceil($num_rows/$page_jump);
?>
if ($total_num_page > 1)
{
?>
echo "[Page $page_num/$total_num_page]";
for ($counter=0; $counter<=$total_num_page-1; $counter++)
{
$page_jump = $counter +1;
?>
[ echo $page_jump; ?>]
}
?>
}
?>
return $group_str;
}//function
?>
KIX COUNTRY - THE BEST COUNTRY MUSIC
include("menu.inc");?>
$sql_page = "select * from web_pages where page_id = 7 LIMIT 1";
$result_page = mysql_query($sql_page);
if ($row_page = mysql_fetch_array($result_page))
{
$row_page[page_text] = stripslashes($row_page[page_text]);
}
if(isset($_GET[id]))
{
if(!isNaN($_GET[id]))
{
$cat = prepare_input($_GET[id]);
$sql_cat = "select * from gallery_category WHERE gc_id = $cat LIMIT 1";
$result_cat = mysql_query ($sql_cat);
if($row = mysql_fetch_array($result_cat))
{
$gc_name = stripslashes($row[gc_name]);
$gc_description = stripslashes($row[gc_description]);
$gc_id = $row[gc_id];
?>
echo "\n\n ";
echo "$gc_name $gc_description \n ";
//for page numberer
if (isset($_GET[cur_page]))
{
$cur_page = prepare_input($_GET[cur_page]);
}
if ($cur_page == "")
{
$cur_page = 0;
}
$sql_select = "SELECT * FROM gallery_photo WHERE gp_category = $gc_id order by gp_id desc";
//print out the page number bar
$perpage = 10;
$group_str = photo_page_numbers($cur_page, $perpage, $sql_select,$cat);
$result = mysql_query($group_str);
?>
$count = 1;
echo " ";
while ($row = mysql_fetch_array($result))
{
$gp_id = stripslashes($row[gp_id]);
$row[gp_category] = stripslashes($row[gp_category]);
$row[gp_active] = stripslashes($row[gp_active]);
$gp_caption = stripslashes($row[gp_caption]);
$row[gp_height] = stripslashes($row[gp_height]);
$row[gp_width] = stripslashes($row[gp_width]);
$gp_thumb_height = stripslashes($row[gp_thumb_height]);
$gp_thumb_width = stripslashes($row[gp_thumb_width]);
$gp_file_name = stripslashes($row[gp_file_name]);
$gp_thumb_file = stripslashes($row[gp_thumb_file]);
$usecaption = str_replace("'", "\'", $gp_caption);
?>
if ($usecaption != "")
{
?>
}
else
{
?>
}
?>
if ($count%$gal_columns == 0)
{
echo "\n \n ";
}
$count++;
}
echo "\n ";
}
?>
}
}//end if (isset($_GET[id]))
else//display all category details and the first picture for each
{
$sql_cat = "select * from gallery_category where gc_active = 'y' and gc_showthumb = 'y'";
$result_cat = mysql_query ($sql_cat);
?>
$count = 2;
while ($row = mysql_fetch_array($result_cat))
{
$gc_name = stripslashes($row[gc_name]);
$gc_description = stripslashes($row[gc_description]);
$gc_id = $row[gc_id];
//get the photo
$sql_select = "SELECT * FROM gallery_photo WHERE gp_category = $gc_id AND gp_catimage = 'y' LIMIT 1";
if ($result = mysql_query ($sql_select))
{
$row = mysql_fetch_array($result);
$gp_id = stripslashes($row[gp_id]);
$row[gp_category] = stripslashes($row[gp_category]);
$row[gp_active] = stripslashes($row[gp_active]);
$gp_caption = stripslashes($row[gp_caption]);
$row[gp_height] = stripslashes($row[gp_height]);
$row[gp_width] = stripslashes($row[gp_width]);
$gp_thumb_height = stripslashes($row[gp_thumb_height]);
$gp_thumb_width = stripslashes($row[gp_thumb_width]);
$gp_file_name = stripslashes($row[gp_file_name]);
$gp_thumb_file = stripslashes($row[gp_thumb_file]);
?>
=$gc_name?>
if ($count%2 == 0)
{
echo "\n ";
}
else
{
echo "\n ";
}
$count++;
}//end if result
}
?>
Archives
$sql_cat = "select * from gallery_category where gc_active = 'y' and gc_showthumb = 'n' order by gc_date desc";
$result_cat = mysql_query ($sql_cat);
?>
while ($row = mysql_fetch_array($result_cat))
{
$gc_name = stripslashes($row[gc_name]);
$gc_date = stripslashes($row[gc_date]);
$gc_description = stripslashes($row[gc_description]);
$gc_id = $row[gc_id];
$gc_date = date_format_aust($gc_date);
?>
-
}
?>
}//end else
require("footer.inc");
?>