GET * FROM _____ Except?
Posted on
16th Feb 2014 07:03 pm by
admin
I have a site that is for stock photography.
This section of the code calls images to display on the main page, based on several variables (new images, featured images, most downloaded, highest rated, etc...) the problem is there are some nude images on the site, and I would prefer that they not be displayed on the main page. I have created a separate category for the nude images, but I can't figure out how to modify the code so that it gets all other images OTHER THAN the nude category.
here is the code:
Code: (php) <?
if(isset($component_id))
{
$stitle=array();
$sauthor=array();
$slink=array();
$simage=array();
$sql="select * from components where id=".(int)$component_id;
$rs->open($sql);
if(!$rs->eof)
{
if(eregi("photo",$rs->row["content"]))
{
$sql="select a.id,a.id_parent,b.id_parent,b.title,b.folder,b.author from structure a, photos b where a.id=b.id_parent and b.published=1";
}
if($rs->row["category"]!=0)
{
$sql.=" and a.id_parent=".$rs->row["category"];
}
if($rs->row["user"]!="")
{
$sql.=" and b.author='".$rs->row["user"]."'";
}
if($rs->row["types"]=="featured")
{
$sql.=" and b.featured=1";
}
if($rs->row["types"]=="free")
{
$sql.=" and b.free=1";
}
if($rs->row["types"]=="free")
{
$sql.=" and b.free=1";
}
if($rs->row["types"]=="new")
{
$sql.=" order by b.data desc";
}
elseif($rs->row["types"]=="popular")
{
$sql.=" order by b.viewed desc";
}
elseif($rs->row["types"]=="downloaded")
{
$sql.=" order by b.downloaded desc";
}
else
{
$sql.=" order by rand()";
}
$sql.=" limit ".$rs->row["quantity"];
$ds->open($sql);
while(!$ds->eof)
{
$stitle[]=$ds->row["title"];
$sauthor[]=$ds->row["author"];
if(eregi("news",$rs->row["content"]))
{
$slink[]=site_root."/news/".$ds->row["id"]."/";
}
elseif(eregi("blog",$rs->row["content"]))
{
$slink[]=site_root."/post/".user_url($ds->row["user"])."/".$ds->row["id"].".html";
}
else
{
$slink[]=surl.item_url($ds->row["id"]);
}
if(eregi("photo",$rs->row["content"]) or eregi("vector",$rs->row["content"]))
{
$ttt=1;
if(eregi("2",$rs->row["content"])){$ttt=2;}
$simage[]=site_root."/content/".$ds->row["folder"]."/thumb".$ttt.".jpg";
}
elseif(eregi("video",$rs->row["content"]) or eregi("audio",$rs->row["content"]))
{
$simage[]=$ds->row["photo"];
}
else
{
$simage[]="";
}
$ds->movenext();
}
$box=file_get_contents($DOCUMENT_ROOT."/".$site_template_url."box_home.tpl");
$component_body.="<table border='0' cellpadding='0' cellspacing='0'>";
$n=0;
for($i=0;$i<$rs->row["arows"];$i++)
{
$component_body.="<tr valign='top'>";
for($j=0;$j<$rs->row["acells"];$j++)
{
if($n<count($stitle) and $n<count($slink) and $n<count($simage))
{
$boxcontent=$box;
$boxcontent=eregi_replace("{TITLE}",$stitle[$n],$boxcontent);
$lightbox="";
if($rs->row["content"]=="photo1")
{
if(file_exists($_SERVER["DOCUMENT_ROOT"].eregi_replace("thumb1","thumb2",$simage[$n])) and $rs->row["slideshow"]!=1)
{
$size = getimagesize($_SERVER["DOCUMENT_ROOT"].eregi_replace("thumb1","thumb2",$simage[$n]));
$lightbox=" onMouseover="lightboxon('".eregi_replace("thumb1","thumb2",$simage[$n])."',".$size[0].",".$size[1].",event,'','".addslashes($stitle[$n])."','".word_lang("author").": ".addslashes($sauthor[$n])."');" onMouseout="lightboxoff();" onMousemove="lightboxmove(".$size[0].",".$size[1].",event)"";
}
}
if(!$site_lightbox_photo){$lightbox="";}
$boxcontent=eregi_replace("{LIGHTBOX}",$lightbox,$boxcontent);
$boxcontent=eregi_replace("{URL}",$slink[$n],$boxcontent);
$boxcontent=eregi_replace("{IMAGE}",$simage[$n],$boxcontent);
$boxcontent=eregi_replace("{LINKNAME}","link_".strval($component_id)."_".strval($i)."_".strval($j),$boxcontent);
$boxcontent=eregi_replace("{IMGNAME}","img_".strval($component_id)."_".strval($i)."_".strval($j),$boxcontent);
$component_body.="<td>".$boxcontent."</td>";
}
$n++;
}
$component_body.="</tr>";
}
$component_body.="</table>";
if($rs->row["slideshow"]==1 and count($stitle)>$rs->row["acells"]*$rs->row["arows"])
{
$component_body.="<script language="javascript">simage".$component_id."=new Array();stitle".$component_id."=new Array();slink".$component_id."=new Array();";
for($i=0;$i<count($stitle);$i++)
{
$component_body.="simage".$component_id."[".$i."]=new Image();simage".$component_id."[".$i."].src='".$simage[$i]."';stitle".$component_id."[".$i."]='".$stitle[$i]."';slink".$component_id."[".$i."]='".$slink[$i]."';";
}
$component_body.="function ss".$component_id."()
{
acells=Math.round(".($rs->row["acells"]-1)." * Math.random());
arows=Math.round(".($rs->row["arows"]-1)." * Math.random());
if(acells*arows>".count($stitle).")
{
acells=0;
arows=0;
}
nomer=Math.round(".(count($stitle)-($rs->row["acells"]*$rs->row["arows"]))." * Math.random())+".($rs->row["acells"]*$rs->row["arows"])."-1
bufimg=new Image();
buflink="";
buftitle="";
nomer2=arows*".$rs->row["acells"]."+acells;
bufimg.src=simage".$component_id."[nomer2].src;
buflink=stitle".$component_id."[nomer2];
buftitle=slink".$component_id."[nomer2];
simage".$component_id."[nomer2].src=simage".$component_id."[nomer].src;
stitle".$component_id."[nomer2]=stitle".$component_id."[nomer];
slink".$component_id."[nomer2]=slink".$component_id."[nomer];
dimg=document.getElementById("img_".$component_id."_"+arows+"_"+acells);
dimg.src=simage".$component_id."[nomer].src;
dimg.setAttribute('alt',stitle".$component_id."[nomer]);
dlink=document.getElementById("link_".$component_id."_"+arows+"_"+acells);
dlink.href=slink".$component_id."[nomer];
simage".$component_id."[nomer].src=bufimg.src;
stitle".$component_id."[nomer]=buflink;
slink".$component_id."[nomer]=buftitle;
setTimeout("ss".$component_id."()",".(1000*$rs->row["slideshowtime"]).")
}
ss".$component_id."()
</script>";
}
}
}
?>
This code controls the "Components" which display on the main page. It has references to categories, and I can configure each component to display 1 category, but I can't figure out how to make it display all but 1 category
No comments posted yet
Your Answer:
Login to answer
51 
11 
Other forums
PHP & Java
Hello,
can PHP code be used inside java code?
Code: [Select]<SCRIPT LANGUAGE=&q
tag inside php...
hi
Code: <?php
echo "<td width="$columnWidth%" align=&Check Date/Time in PHP
What I need the code to check is that $reQuest is 24 hours in the past then return a time based on h using file_get_contents??
okay how would i create a script using file_get_contents() in php have it grab search pages 1-20 and Date/Time and Checkbox
Hi Everyone,
I am trying to figure out how to insert the current date and tim Need to write a cookie with a url var
Not sure if its possible, but I need to write a cookie with a url.
So this would write 2232 a Inserting Data into a MS Access DB using PHP.
As part of my uni course I am doing a placement at a company whom want me to create a client zone fo I think i'm using the syntax incorrectly
Hi Everyone!
I'm new to this forum and a newbie with PHP - I'm glad I found this site - I hop echo $rows help
Hi all,
Hopefully something simple that I don't know!
I have this:
Code: [Selec add to sql result
ok see rite now my sites hit counter is counted from the mysql visitor log i need to clear it aft
| 
