Jump to content
Sign in to follow this  
killerwhale65

photo gallery for oscommerce

Recommended Posts

Hello Matt

 

This is a very nice contribution.

 

I need a photo gallery for my oscommerce site where just the administrator of the website to upload new photos (a variable number, 40-50 for example). The visitors just watching the pictures into a "photo gallery" page.

I think your next version of the contribution will be almost I need, or maybe I'll can adapt the script. What do you think about this?

 

Sorry for my bad english.

 

Regards,

Flaviu

Share this post


Link to post
Share on other sites
Hello Matt

 

This is a very nice contribution.

 

I need a photo gallery for my oscommerce site where just the administrator of the website to upload new photos (a variable number, 40-50 for example). The visitors just watching the pictures into a "photo gallery" page.

I think your next version of the contribution will be almost I need, or maybe I'll can adapt the script. What do you think about this?

 

Sorry for my bad english.

 

Regards,

Flaviu

simple solution: in gallery.php and account.php, simply remove the link to gallery_user.php. Now nobody will be able to get to the upload page. If you want to upload pics, simply enter the URL manually (yourwebsite.com/gallery_user.php), or make a link somewhere in your admin.


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites
simple solution: in gallery.php and account.php, simply remove the link to gallery_user.php. Now nobody will be able to get to the upload page. If you want to upload pics, simply enter the URL manually (yourwebsite.com/gallery_user.php), or make a link somewhere in your admin.

Hi again.

 

Thanks Matt, I'll try to do so.

The maximum number of pictures (now is 6) have some effects or I can upload an unlimited number of photos?

Sorry, but I'm not very good in PHP&MySql.

Share this post


Link to post
Share on other sites
Hi again.

 

Thanks Matt, I'll try to do so.

The maximum number of pictures (now is 6) have some effects or I can upload an unlimited number of photos?

Sorry, but I'm not very good in PHP&MySql.

you will have to change the maximum allowable pics in gallery_user.php


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites

count the number of click on the image

adding a paging system on 12 images

and the status off if you install the gallery for admin

 

replace gallery in catalog

 

<?php
/*
Photo Gallery for osCommerce version 0.6


 $Id: shipping.php,v 1.22 2003/06/05 23:26:23 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce  Released under the GNU General Public License

Site design by www.micrographx.be
|----------------------------------------------------- 
BACKUP! BACKUP! BACKUP! BACKUP!

Open catalog/includes/database_tables.php
add
// BOF gallery.php 
define('TABLE_GALLERY', 'gallery');
// EOF 

Open catalog/includes/filenames.php
add 
// BOF gallery.php 
define('FILENAME_GALLERY', 'gallery.php');
// EOF 

-- Run the following file on your MySQL database:
-- Upload
--
ALTER TABLE gallery ADD gallery_viewed INT( 11 ) DEFAULT '0' NOT NULL;
--
-----------------------------------------------------|  
*/
// Lang  ________________________________________
define('TEXT_PAGES', 'Pages :');
define('TEXT_VIEWED', 'Et a etais vue');
define('TEXT_DESCRI', 'Description');
// Lang fin _____________________________________
 require('includes/application_top.php');

 require(DIR_WS_LANGUAGES . $language . '/gallery.php');

 $breadcrumb->add(NAVBAR_TITLE, tep_href_link('gallery.php'));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<script type="text/javascript" src="highslide/highslide.js"></script>

<script type="text/javascript">   

<?php if (isset($_GET['autoload'])) {?>
hs.addEventListener(window, "load", function() { 
  // click the element virtually: 
  document.getElementById("autoload<?php echo $_GET['autoload'];?>").onclick(); 
}); 
<?php } ?>
hs.registerOverlay({
overlayId: 'closebutton',
position: 'top right',
fade: 2 // fading the semi-transparent overlay looks bad in IE
});

hs.graphicsDir = 'highslide/graphics/';
//hs.padToMinWidth = true;
//hs.minWidth = 400;
function clk(id)
{
 (new Image()).src="gallery_process.php?id="+id;
 return true;
}
</script>

<style type="text/css">
.highslide-wrapper div { font-family: Verdana, Helvetica;}
.highslide {cursor: url(highslide/graphics/zoomin.cur), pointer;outline: none;text-decoration: none;}
.highslide-active-anchor img {visibility: hidden;}
.highslide img {/*border: 2px solid gray;*/}
.highslide:hover img {border-color: silver;}
.highslide-wrapper, .drop-shadow {background: white;}
.highslide-image {border: 10px solid white;}
.highslide-image-blur {}
.highslide-heading{ text-align:center; font-weight:bold; font-size:12px; background-color:#FFFFFF;}
.highslide-caption {
display: none;
border: 0px solid #745224;
font-family: Verdana, Helvetica;
padding:10px;
padding-top:0px;
background: white;
text-align:left;
color:#666666;
font-size:10px;
text-align:justify;
}
.highslide-loading {
display: block;
color: black;
font-size: 8pt;
font-family: sans-serif;
font-weight: bold;
text-decoration: none;
padding: 2px;
border: 1px solid black;
background-color: white;
padding-left: 22px;
background-image: url(highslide/graphics/loader.white.gif);
background-repeat: no-repeat;
background-position: 3px 1px;
}

a.highslide-credits,a.highslide-credits i {
padding: 2px;
color: silver;
text-decoration: none;
font-size: 10px;
}
a.highslide-credits:hover,a.highslide-credits:hover i {
color: white;
background-color: gray;
}
a.highslide-full-expand {
background: url(highslide/graphics/fullexpand.gif) no-repeat;
display: block;
margin: 0 10px 10px 0;
width: 34px;
height: 34px;
}
.highslide-overlay {display: none;}

/* Mac-style close button */
.closebutton {
position: relative;
top: -20px;
left: 20px;
width: 30px;
height: 30px;
cursor: hand; /* ie */
cursor: pointer; /* w3c */
background: url(highslide/graphics/close.png);
/* For IE6, remove background and add filter */
_background: none;
_filter:progid:DXImageTransform.Microsoft.AlphaImageLoader(src='highslide/graphics/close.png', sizingMethod='scale');
}

</style>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
 <tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
		<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_specials.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
	  <tr>
		<td class="main">
			<table width="100%">
			<?php
$galleryParPage=12; //Nous allons afficher 12 images par page.
$retour_total=mysql_query('SELECT COUNT(*) AS total FROM gallery'); //Nous récupérons le contenu de la requête dans $retour_total
$donnees_total=mysql_fetch_assoc($retour_total); //On range retour sous la forme d'un tableau.
$total=$donnees_total['total']; //On récupère le total pour le placer dans la variable $total.

//Nous allons maintenant compter le nombre de pages.
$nombreDePages=ceil($total/$galleryParPage);

if(isset($_GET['page'])) // Si la variable $_GET['page'] existe...
{
 $pageActuelle=intval($_GET['page']);

 if($pageActuelle>$nombreDePages) // Si la valeur de $pageActuelle (le numéro de la page) est plus grande que $nombreDePages...
 {
	  $pageActuelle=$nombreDePages;
 }
}
else // Sinon
{
 $pageActuelle=1; // La page actuelle est la n°1	
}
$premiereEntree=($pageActuelle-1)*$galleryParPage; // On calcul la première entrée à lire
				$aantal_kol = 4;
				$rij = 1;
				$kolom = 1;
				//aantal foto's in elke map bepalen
				$gallery_query = tep_db_query("SELECT * FROM " . TABLE_GALLERY . " g, " . TABLE_CUSTOMERS . " c  where g.cID = c.customers_id and g.gallery_status = '1' ORDER BY g.id DESC LIMIT ".$premiereEntree.", ".$galleryParPage."");
while ($gallery = tep_db_fetch_array($gallery_query)) {
$dir = "gallery/";	
$file = $gallery['cID']."_".$gallery['pID'].".jpg";
					if ($kolom == 1) {echo "\n".'<tr>';}
					echo "\n".'<td align="center"><a onmousedown="return clk('.$gallery['id'].')" id="autoload'.$gallery['id'].'" href="' . tep_href_link($dir.$file) . '" class="highslide" onclick="return hs.expand(this,{headingText: \''.$gallery['title'].'\'})"title="'.stripslashes($gallery['title']).'">'.tep_image($dir . $file, '', 150, 150, 'hspace="5" vspace="5"').'</a>';					
					echo '<div class="highslide-caption"><div style="text-align:center;margin-top:-2px;">'.AUTEUR.' '.$gallery['customers_firstname']." ".$gallery['customers_lastname']."<br>".TEXT_VIEWED."<b>".$gallery['gallery_viewed']."</b> fois<br></div><p>";

					if ($fotos['description'] != '') {
						echo '<div style="font-style:italic;border:1px solid #666666;background:#ffffcc"><fieldset><legend>'.TEXT_DESCRI.'</legend>'.stripslashes($gallery['description']).'</fieldset></div><p>';
					}

					//bestaande commentaar uitlezen
					if ($gallery['comment'] != '') {
					$comment = explode('<-->',$gallery['comment']);
						foreach ($comment as $val) {
							$commentaar = explode ('///',$val);
							echo '<b>'.stripslashes($commentaar[0]) . "</b>: ".stripslashes($commentaar[1]).'<hr style="border:0;height:1px;color:#666666;background:#666666;">';
						}
					} else {
						echo TEXT_NO_COMMENTS.'<hr style="border:0px;border-top:1px solid #666666;">';
					}
					echo '<b>'.TEXT_PLACE_COMMENT.'</b><br>';

					//nieuwe commentaar
					echo '<form name="form'.$gallery['cID'].$gallery['pID'].'" action="gallery_process.php" method="POST">';
					echo '<input type="text" name="comment_naam" value="'.TEXT_NAME.'" onClick="this.value=\'\'">';
					echo '<input type="hidden" name="cID" value="'.$gallery['cID'].'">';
					echo '<input type="hidden" name="pID" value="'.$gallery['pID'].'">';
					echo '<textarea name="comment_tekst" onClick="this.value=\'\'">'.TEXT_COMMENT.'</textarea>';
					echo '<input type="submit" name="action" value="ok"></form>';

					echo '</div></td>';
					if ($kolom == $aantal_kol) {
						echo '</tr>';
						$kolom = 0;
					}
					$rij ++;
					$kolom ++;
				}
				if ($kolom <= $aantal_kol) {echo '</tr>';}
		echo '<p align="center">'.TEXT_PAGES; //Pour l'affichage, on centre la liste des pages
for($i=1; $i<=$nombreDePages; $i++) //On fait notre boucle
{
 //On va faire notre condition
 if($i==$pageActuelle) //Si il s'agit de la page actuelle...
 {
	 echo ' [ '.$i.' ] '; 
 }	
 else //Sinon...
 {
	  echo ' <a href="gallery.php?page='.$i.'">'.$i.'</a> ';
 }
}
echo '</p>';
?>
			<div id="closebutton" class="highslide-overlay closebutton" onClick="return hs.close(this)" title="Close"></div>

			</table><p><?php echo TEXT_LINK; ?></p>
		</td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
	  <tr class="infoBoxContents">
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
</table></td>
<!-- body_text_eof //-->
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
</table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

small bug 'comment' not display correctly if someone comment watch little

Share this post


Link to post
Share on other sites

+ count the number of click on the image for gallery_process.php

replace

 

<?php
 require('includes/application_top.php');
 require(DIR_WS_LANGUAGES . $language . '/gallery_user.php');

 

for

 

<?php
 require('includes/application_top.php');
 require(DIR_WS_LANGUAGES . $language . '/gallery_user.php');

// si l'id d'une images est passé en paramètre

if (isset($_GET['id']) && is_numeric($_GET['id'])) {
// on sélectionne l'id
$sql = "select * from " . TABLE_GALLERY . " where id='".$_GET['id']."'";
$req = mysql_query($sql);
$sel = mysql_fetch_array($req);
// on comptabilise un clic
$sql2 = "update " . TABLE_GALLERY . " set gallery_viewed = gallery_viewed+1 where id='".$_GET['id']."'";
$upd = mysql_query($sql2);

// si aucun id valable n'est passé en paramètre
} else {
echo "Erreur : ce téléchargement n'existe pas !";
}

Share this post


Link to post
Share on other sites

hi Matt,

 

i have same problems with the uploading files, i try to upload a photo in my webhosting ( not in my localhost ) but it keep direct me to the log me out and direct me to the login page.

 

i think the other 2 people above have the same problems, can you help us about this bug ?

Share this post


Link to post
Share on other sites

So where is the update?

 

On the Development-Info-Box everythings finished for at least a month, except subgalleries, so I cannot wait to install all the new features... =)

 

Thanks!

Share this post


Link to post
Share on other sites

Hello @ all,

 

I´ve installed this contrib - it´s very nice and works really great.

 

But how can I build up categories ?!?

Also it would be nice when every user can build up 1 or 2 categories.

 

Is their an working solution ?!?

 

Thanks for your help.

 

Aranja

 

P.S Excuse my English - it isn´t my mother language

Edited by aranjabrix

Share this post


Link to post
Share on other sites
But how can I build up categories ?!?

You cannot in this version. It's for the future.


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites

I know it would work in this version, but would it be possible to change this "problem".

 

I didn´t think it would be hard to solf this prob.

 

morka has made an good basic, but not everyone uses page editor. So some tables aren´t in the database - that´s the prob with his idea.

 

Would be nice if someone could help.

 

Thanks.

Share this post


Link to post
Share on other sites
yes, it will also affect your product pictures. It will automatically create a thumbnail for your product pictures, like it does for your gallery images. No idea if it can work together with the additional images contrib.

 

You can limit the fly mod to gallery.php and gallery_user.php by adding the following code in includes/function/html/output.php

 

/// Fly Mod BOF
if ( basename($_SERVER['PHP_SELF']) == 'gallery.php' or
 basename( $_SERVER['PHP_SELF'] ) == 'gallery_user.php')
{
///

 // if no file exists display the 'no image' file
 if (!is_file($src)) {
 $src = "images/no_image.jpg";
 }
// Set default image variable and code
$image = '<img src="' . $src . '"';

// Don't calculate if the image is set to a "%" width
if (strstr($width,'%') == false || strstr($height,'%') == false) {
	$dont_calculate = 0;
} else {
	$dont_calculate = 1;
}

// Dont calculate if a pixel image is being passed (hope you dont have pixels for sale)
if (!strstr($image, 'pixel')) {
	$dont_calculate = 0;
} else {
	$dont_calculate = 1;
}

// Do we calculate the image size?
if (CONFIG_CALCULATE_IMAGE_SIZE && !$dont_calculate) {

	// Get the image's information
	if ($image_size = @getimagesize($src)) {

		$ratio = $image_size[1] / $image_size[0];

		// Set the width and height to the proper ratio
		if (!$width && $height) {
			$ratio = $height / $image_size[1];
			$width = intval($image_size[0] * $ratio);
		} elseif ($width && !$height) {
			$ratio = $width / $image_size[0];
			$height = intval($image_size[1] * $ratio);
		} elseif (!$width && !$height) {
			$width = $image_size[0];
			$height = $image_size[1];
		}

		// Scale the image if not the original size
		if ($image_size[0] != $width || $image_size[1] != $height) {
			$rx = $image_size[0] / $width;
			$ry = $image_size[1] / $height;

			if ($rx < $ry) {
				$width = intval($height / $ratio);
			} else {
				$height = intval($width * $ratio);
			}

			$image = '<img src="product_thumb.php?img=' . $src . '&w=' .
			tep_output_string($width) . '&h=' . tep_output_string($height) . '"';
		}

	} elseif (IMAGE_REQUIRED == 'false') {
		return '';
	}
}

// Add remaining image parameters if they exist
if ($width) {
	$image .= ' width="' . tep_output_string($width) . '"';
}

if ($height) {
	$image .= ' height="' . tep_output_string($height) . '"';
}

if (tep_not_null($params)) $image .= ' ' . $params;

$image .= ' border="0" alt="' . tep_output_string($alt) . '"';

if (tep_not_null($alt)) {
	$image .= ' title="' . tep_output_string($alt) . '"';
}

$image .= '>';

return $image;
}

else
{
// Original:
if ( (empty($src) || ($src == DIR_WS_IMAGES)) && (IMAGE_REQUIRED == 'false') ) {
  return false;
}

Check with your original code so it match.

Its pretty straight forward, but if you're new to this the code check if your on the page gallery.php or gallery_user.php. Then it uses the thumbnails on the fly mod. Otherwise it uses the original code you have.

 

 

Matthias, its a nice, stright forward and easy to use contrub you made. Do you have any idea of when you will have an update with subgalleries, voting and commeting approval?

 

Cheers,

Fredrik

Share this post


Link to post
Share on other sites
Matthias, its a nice, stright forward and easy to use contrub you made. Do you have any idea of when you will have an update with subgalleries, voting and commeting approval?

Thanks. Sorry but i have no timeframe for the next update.


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites

One question...Why does this contrib not create a new table (like photo_gallery) instead of having to destroy an already existing table named gallery?

Share this post


Link to post
Share on other sites
One question...Why does this contrib not create a new table (like photo_gallery) instead of having to destroy an already existing table named gallery?

gallery is a new table, it does not already exist in the standard oscommerce installation.


Matthias Thoen

my contribution: Photo Gallery for osCommerce

--check my homepage in my CARD--

Share this post


Link to post
Share on other sites

Maybe...but...there must have been a previous contrib that created the table gallery as I already have it. Even your instructions mention to delete table gallery if it already exists...so...you must have known about it.

Share this post


Link to post
Share on other sites

do you have seo friendly urls on in admin?

 

 

lildog

 

morka could you add photo albums i really need it.

 

oh p.s it dont work.

 

1054 - Unknown column 'g.title_url' in 'field list'

select g.id ,g.cID ,g.pID , g.title, g.description, g.title_url, g.taille, g.comment, g.pages_title, g.gallery_status, c.customers_id, c.customers_lastname, c.customers_firstname from gallery g, customers c where g.cID = c.customers_id ORDER BY g.id DESC limit 0, 4

 

If you can fix and also post in english that would be great.

Edited by lildog

Share this post


Link to post
Share on other sites

I was doing an install for a customer and ran across this error. It was caused by seo friendly urls turned on in the admin panel. The fix for that is :

 

I fixed it by setting seo friendly urls to off for the following link:

 

in gallery user:

FIND:

echo '[<a href="'.tep_href_link($link).'" onclick="return hs.htmlExpand(this, { objectType: \'iframe\',outlineType: \'rounded-white\', outlineWhileAnimating: true } )">' .TEXT_EDIT.'</a>]<br>';

 

REPLACE WITH:

echo '[<a href="'.tep_href_link($link,'','SSL','',false).'" onclick="return hs.htmlExpand(this, { objectType: \'iframe\',outlineType: \'rounded-white\', outlineWhileAnimating: true } )">' .TEXT_EDIT.'</a>]<br>';

 

 

 

Good luck,

lildog

 

 

PHP 5.2.6

 

MySQL version 5.0.51a

 

First edit with the above suggestion produced this error code

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxxxx/public_html/ribbonrie/gallery_process.php on line 9
Unknown column 'gallery_user.php' in 'where clause'

 

tried the 2nd edit and.....

Parse error: syntax error, unexpected '}' in /home/xxxxxxx/public_html/ribbonrie/gallery_process.php on line 29

 

So sorry if I made an error, my gallery_process.php is below so you can check, I really do wish I could help myself more.

 

<?php
 require('includes/application_top.php');
 require(DIR_WS_LANGUAGES . $language . '/gallery_user.php');


          if (isset($_GET['edit']) && $_GET['edit']=='yes') {
               $cID = $_GET['cID'];
               $pID = $_GET['pID'];
               $sql = mysql_fetch_array(mysql_query("SELECT title, description FROM gallery WHERE cID='".$cID."' AND pID='".$pID."'")) or die(mysql_error());
	$titel = SET_TITLE;
} else {
	$titel = stripslashes($sql['title']);
}
if ($sql['description']=='') {
	$desc = SET_DESCRIPTION;
} else {
	$desc = stripslashes($sql['description']);
}
?>
<form name="form" action="gallery_user.php" method="post" target="_parent">
<input type="text" name="title" value="<?php echo $titel;?>" onClick="this.select()">
<input type="hidden" name="cID" value="<?php echo $_GET['cID'];?>">
<input type="hidden" name="pID" value="<?php echo $_GET['pID'];?>">
<textarea name="description" onClick="this.select()"><?php echo $desc;?></textarea>
<input type="submit" value="save" name="edittitle">
</form>

<?php
} else {
$naam = addslashes($_POST['comment_naam']);
       $tekst = addslashes($_POST['comment_tekst']);
$cID =$_POST['cID'];
$pID = $_POST['pID'];
//echo $naam." ///".$tekst." ".$cID." ///".$pID;

$bestaande_comment = mysql_fetch_array(mysql_query("SELECT comment FROM gallery WHERE cID=".$cID." AND pID=".$pID));

if ($bestaande_comment['comment'] != '') {$spacer='<-->';}

$nieuw_comment = $bestaande_comment['comment'].$spacer.$naam."///".$tekst;

mysql_query("UPDATE gallery SET comment='".$nieuw_comment."' WHERE cID=".$cID." AND pID=".$pID);

header("Location: gallery.php?autoload=".$cID.$pID);
}
?>

 

I have not got past this so have not even moved onto the fact that I can't see any of the info on the gallery images when I try as a general user. No name info etc is displayed.

 

For the first time I am putting on my very brave hat and providing a link to the site. Its not an open shop (2 weeks to go) and has much still to be done however, its Here I would like to help get this running hence a BIG step for me to post this here :blush:

 

Thank you!!

Share this post


Link to post
Share on other sites

I have added many features to photo Gallery. Admins can add as many pics to users accounts as they want, admins can set users to unlimited photo uploads, put thumbnails in the clean gallery box, created an new gallery box in admin outside of the config box, added a slideshow infobox, cleaned up some code a bit, made some text more intuitive to users, added a short description text to gallery page.

 

If anyone is interested let me know.

 

lildog

Share this post


Link to post
Share on other sites

I just installed this, and I am using STS 4.5.8. Do I need to put some javascript code in my template? The popup image using the highslide javascript doesn't seem to be working right. I have a lot of transparent areas on the popup, for example, there is no close button in the top right, it's transparent. I see the javascript in gallery.php, but I can't move that to my template, as you can't have php in a template file.

 

Thanks.

Share this post


Link to post
Share on other sites
I just installed this, and I am using STS 4.5.8. Do I need to put some javascript code in my template? The popup image using the highslide javascript doesn't seem to be working right. I have a lot of transparent areas on the popup, for example, there is no close button in the top right, it's transparent. I see the javascript in gallery.php, but I can't move that to my template, as you can't have php in a template file.

 

Thanks.

I have added the js to a variable in my STS template, and put that in the header of my page, but it hasn't made any differences. Still transparent areas, and very unuseable. Here is the html output in my header for the java script:

<script type="text/javascript" src="highslide/highslide.js"></script>
<script type="text/javascript">hs.registerOverlay({
	overlayId: 'closebutton',
	position: 'top right',
	fade: 2 // fading the semi-transparent overlay looks bad in IE
	});

	hs.graphicsDir = 'highslide/graphics/';
	//hs.padToMinWidth = true;
	//hs.minWidth = 400;
	</script>

Thanks!

Edited by jrthor2

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×