Unapproved photos on main page

**thetazz** · 10-02-2007

Unapproved photos show in gallery block on index.php

-Update: It seems theres a bit missing in: tmpl_uni/scripts/index.php

Code:

$sqlFrom = "
		FROM `media`";
	
	$sqlWhere = "
		WHERE
			`med_type` = 'photo' AND
			`med_status` = 'active' ";

Should be something like:

Code:

$sqlFrom = "
		FROM `media`";
	
	$sqlWhere = "
		WHERE
			`med_type` = 'photo' AND
			`med_status` = 'active' AND
			`approved` = 'true'";

This causes a Database query error on index.php though...

Dolphin 6.02

mark · 10-02-2007

anybody having the same problem?

**thetazz** · 10-03-2007

Above code is way off (becomes clear after a few hours sleep

)

Still the problem is it does not look to see if the photo is approved in sharePhotoFiles table.

Really need help on this one....

**thetazz** · 10-08-2007

The Quest continues...

I managed to almost fix the issue by changing a bit in sharing.inc.php

From:

Code:

	$sqlSelect = "SELECT `medID`,
						 `medExt`,
						 `medTitle`";
	$sqlFrom  = " FROM `sharePhotoFiles`";
	if ($iID != 0)
	{
		$sqlWhere = " WHERE `Approved`='true' AND `medProfId`='$iID'";
	}

To:

Code:

	$sqlSelect = "SELECT `medID`,
						 `medExt`,
						 `medTitle`";
	$sqlFrom  = " FROM `sharePhotoFiles` WHERE `Approved`='true' ";
	if ($iID != 0)
	{
		$sqlWhere = " `medProfId`='$iID'";
	}

This works for the latest and random tab, but now gives database query error on top tab.

Thread: Unapproved photos on main page

LinkBack

Thread Tools

Display

Unapproved photos on main page

bug not confirmed yet -- Unapproved photos show in gallery block on index.php

Thread Information

Users Browsing this Thread

Similar Threads

Info on main profile page

Main Page Layout Problem

Links on main page

only online members on main page

4.1002 MCL Template - main page

Bookmarks

Bookmarks

Posting Permissions