Tricky

Well, its okay with the urls

Heeey I wont add or remove anything now, i want to ask you to help me to get the images from gallery(3.1.0) at front page so i can get the url to be: http://digitalbin.org/gallery/image/image_se.png Look at my Beta site: http://digitalbin.org/page/home Code: /* Init */ $return = ""; $to_show = 42; $per_row = 6; $count = 0; /* Query */ $this->DB->build( array( 'select' => 'i.id AS picid, i.masked_file_name, i.directory, i.caption, i.member_id, i.ratings_count, i.ratings_total, i.comments ', 'from' => array( 'gallery_images' => 'i' ), 'add_join' => array( 0 => array( 'select' => 'g.rate AS number', 'from' => array( 'gallery_ratings' => 'g' ), 'where' => 'i.id=g.img_id', 'type' => 'left' ) ), 'add_join' => array( 1 => array( 'select' => 'm.name as uname', 'from' => array( 'members' => 'm' ), 'where' => 'i.member_id=m.member_id', 'type' => 'left' ) ), 'order' => 'i.id DESC', 'limit' => array( 0, $to_show ), ) ); $this->DB->execute(); /* Got some rows */ if ( $this->DB->getTotalRows() ) { $return .= "<div><table>"; $return .= "<tr> <td rowspan='{$this->DB->getTotalRows()}' valign='top; left'> <div style=' background-color: #1F1F1F; -moz-border-radius: 8px; -webkit-border-radius: 8px; border: 1px solid grey; padding: 8px;' class='left'> <div style='text-align:left;'> <br><center> <br><br> <b>Featured Work</b><i>(week 47)</i> <br> <a href='http://wallbase.org/index.php?app=gallery&module=images&section=viewimage&img=2829'> <img style='-moz-border-radius: 3px; -webkit-border-radius: 3px; border: 1px solid grey; padding: 1px;' src='http://wallbase.org/uploads/1243459243/tn_gallery_58_113_3599.jpg'/></a> <br> By: <a href='http://wallbase.org/user/58-alexander-gg/'>Alexander-GG</a> <br></center> <br> <font color='white'> <blockquote> <img src='http://wallbase.org/v105/images.ico'> <b><i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=3'><shadow> Wallpapers</shadow></a></i></b><br> <blockquote><font size='1'><i> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png'/> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=15'>3/4 Dimensional(3D or 4D)</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png'/> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=8'>Minimalistic</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=4'>Abstract</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=13'>Animals & Plants</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=167'>Desktop Screens</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=168'>Holidays</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=5'>People</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=6'>Photo Manipulated</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=7'>Landscapes & Scenery</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=14'>Miscellaneous</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=19'>Multi Display</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=9'>Macabre & Horror</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=18'>Mac/PC </a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=18'>OS Wallpapers</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=10'>Vector</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=186'>History</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=61'>Fractal Art</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=101'>Streen Art or Graffiti</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=16'>Fantasy</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=17'>HDTV/Widescreen</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=20'>Science Fiction</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=21'>Vehicles</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=74'>Pixel Art</a><br><br> </font></i></blockquote> <img src='http://wallbase.org/v105/images.ico'> <b><i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=22'><shadow>Photographs</shadow></a></i></b><br> <blockquote><font size='1'><i> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=25'>Animals, Plants & Nature</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=134'>Body Art</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=24'>People & Portraits</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=29'>Photojournalism</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=27'>Macro</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=23'>Abstract & Surreal</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=30'>Miscellaneous</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=47'>Trees</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=26'>Still Life</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=17'>Sunriss, Sunsets & etc</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=28'>Urban & Rural</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=46'>Winter Scenes</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=169'>Holidays</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=224'>Food % Drinks</a><br><br> </font></i></blockquote> <blockquote><shadow> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=187'>Animated GIf's</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=173'>Artisan Crafts</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=194'>Anthro</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=217'>Handhelds</a></i><i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=189'>WallBase Related</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=162'>Icons</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=56'>Digital Art</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=51'>Fan Art</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=73'>Photo-Manipulation</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=172'>Scrap Images</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=145'>Vector</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=12'>Vexel</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=75'>WallBase Pro Portfolios</a><br> </i></shadow></blockquote></font> <br><br> <br> <i><font size='1'> <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=ratings'>Top Rated Images</a> | <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=views'>Most Viewed Images</a> | <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=comments'>Recent Comments</a></div><br><br> <b>How to Download</b><br> Click on the image you like,<br>you will come to an page<br> now you click on the image<br> and it will pup up in almost full size,<br> just zoom(the images will be full size when u zoom it,<br> now you right click and ''Save As Desktop Background'' )//</font></i> <br><br> </td><font size='2'> </tr>"; while ( $row = $this->DB->fetch() ) { $count++; $row['rate']['id'] = intval( $row['picid'] ); $row['rate']['number'] = intval( $row['number'] ); $row['rate']['canrate'] = 1; $row['rate']['_rate_int'] = $row['ratings_count'] ? round( $row['ratings_total'] / $row['ratings_count'], 0 ) : 0; $row['number'] = $this->registry->output->getTemplate( 'gallery_imagelisting' )->rate_form( $row['rate'] ); $return .= <<<EOF <td class='short'> <br><shadow><a href="http://digitalbin.org/index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}"> <img style="-moz-border-radius: 3px; -webkit-border-radius: 3px; border: 1px solid grey; padding: 1px;" src="http://digitalbin.org/uploads/{$row['directory']}/tn_{$row['masked_file_name']}" alt="{$row['caption']}"/> </a><br /> <i>By:</i> <a href='http://digitalbin.org/index.php?app=gallery&module=user&user={$row['member_id']}'>{$row['uname']}</a></strong><br />{$row['number']} <br /> Comments: </a> <a href="http://digitalbin.org/index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}"><b>{$row['comments']}</shadow></b></a> </td></div></center> EOF; /* New row */ if ( $count && $count % $per_row == 0 ) { $return .= "</tr><tr>"; } } $return .= "</tr></table></div>"; } /* Return */ print $return;

bam forget it mate My members didnt like the idea! but now they wanna have blog feeds in -.-' sorry for the bother DawPi!!

yup.. both!

Jupp make the code and u will see when i set it up!

Nope, just got it at the bottom http://wallbase.org/page/0001re

Yeah, but u didn't understand the question, and now, read carefully: I want the "last images"(the last gallery images) to be in the middle, like this: http://img300.imageshack.us/img300/9771/mookup.png and the "member menu" at the right and the categories at the left..

hmm.. okay, i know that.. i can see it to! ^^,) forget it i thought about a better thing ^^

Yeah, ^^,) but i cant get the "last images" to get up!! as u can see on the test page

mhm, what? I have to get the "last images^" to show, instead of the "codes" ^^,) The one on the right side will be for members ^^,) if i get the only members code to work ^^ like this image: http://img300.imageshack.us/img300/9771/mookup.png

hmm.. oh, sorry ^^ try now ^^

Hey You made this 12 column portal for me..and im thankful for that But i want 3 columns I tried but i it wont work: http://wallbase.org/page/test23 want to code it so it look like this: http://img300.imageshack.us/i/mookup.png/ code this page has: /* Init */ $return = ""; $to_show = 42; $per_row = 6; $count = 0; /* Query */ $this->DB->build( array( 'select' => 'i.id AS picid, i.masked_file_name, i.directory, i.caption, i.member_id, i.ratings_count, i.ratings_total, i.comments ', 'from' => array( 'gallery_images' => 'i' ), 'add_join' => array( 0 => array( 'select' => 'g.rate AS number', 'from' => array( 'gallery_ratings' => 'g' ), 'where' => 'i.id=g.img_id', 'type' => 'left' ) ), 'add_join' => array( 1 => array( 'select' => 'm.name as uname', 'from' => array( 'members' => 'm' ), 'where' => 'i.member_id=m.member_id', 'type' => 'left' ) ), 'order' => 'i.id DESC', 'limit' => array( 0, $to_show ), ) ); $this->DB->execute(); /* Got some rows */ if ( $this->DB->getTotalRows() ) { $return .= "<div><table>"; $return .= "<tr> <div style=' background-color: #1F1F1F; -moz-border-radius: 8px; -webkit-border-radius: 8px; border: 1px solid grey; padding: 8px;' class='left'> <div style='text-align:left;'> <br><center> <br><br> <b>Featured Work</b><i>(week 47)</i> <br> <a href='http://wallbase.org/index.php?app=gallery&module=images&section=viewimage&img=2829'> <img style='-moz-border-radius: 3px; -webkit-border-radius: 3px; border: 1px solid grey; padding: 1px;' src='http://wallbase.org/uploads/1243459243/tn_gallery_58_113_3599.jpg'/></a> <br> By: <a href='http://wallbase.org/user/58-alexander-gg/'>Alexander-GG</a> <br></center> <br> <font color='white'> <blockquote> <img src='http://wallbase.org/v105/images.ico'> <b><i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=3'><shadow> Wallpapers</shadow></a></i></b><br> <blockquote><font size='1'><i> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png'/> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=15'>3/4 Dimensional(3D or 4D)</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png'/> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=8'>Minimalistic</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=4'>Abstract</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=13'>Animals & Plants</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=167'>Desktop Screens</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=168'>Holidays</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=5'>People</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=6'>Photo Manipulated</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=7'>Landscapes & Scenery</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=14'>Miscellaneous</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=19'>Multi Display</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=9'>Macabre & Horror</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=18'>Mac/PC </a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=18'>OS Wallpapers</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=10'>Vector</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=186'>History</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=61'>Fractal Art</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=101'>Streen Art or Graffiti</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=16'>Fantasy</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=17'>HDTV/Widescreen</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=20'>Science Fiction</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=21'>Vehicles</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=74'>Pixel Art</a><br><br> </font></i></blockquote> <img src='http://wallbase.org/v105/images.ico'> <b><i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=22'><shadow>Photographs</shadow></a></i></b><br> <blockquote><font size='1'><i> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=25'>Animals, Plants & Nature</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=134'>Body Art</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=24'>People & Portraits</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=29'>Photojournalism</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=27'>Macro</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=23'>Abstract & Surreal</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=30'>Miscellaneous</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=47'>Trees</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=26'>Still Life</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=17'>Sunriss, Sunsets & etc</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=28'>Urban & Rural</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=46'>Winter Scenes</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=169'>Holidays</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=224'>Food % Drinks</a><br><br> </font></i></blockquote> <blockquote><shadow> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=187'>Animated GIf's</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=173'>Artisan Crafts</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=194'>Anthro</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=217'>Handhelds</a></i><i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=189'>WallBase Related</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=162'>Icons</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=56'>Digital Art</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=51'>Fan Art</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=73'>Photo-Manipulation</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=172'>Scrap Images</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=145'>Vector</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=12'>Vexel</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=75'>WallBase Pro Portfolios</a><br> </i></shadow></blockquote></font> <br><br> <br> <i><font size='1'> <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=ratings'>Top Rated Images</a> | <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=views'>Most Viewed Images</a> | <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=comments'>Recent Comments</a></div><br><br> <b>How to Download</b><br> Click on the image you like,<br>you will come to an page<br> now you click on the image<br> and it will pup up in almost full size,<br> just zoom(the images will be full size when u zoom it,<br> now you right click and ''Save As Desktop Background'' )//</font></i> <br><br> </td><font size='2'> </tr>"; $return .= "<tr> <div style=' background-color: #1F1F1F; -moz-border-radius: 8px; -webkit-border-radius: 8px; border: 1px solid grey; padding: 8px;' class='right'> <div style='text-align:left;'> <br><center> <br><br> <b>Featured Work</b><i>(week 47)</i> <br> <a href='http://wallbase.org/index.php?app=gallery&module=images&section=viewimage&img=2829'> <img style='-moz-border-radius: 3px; -webkit-border-radius: 3px; border: 1px solid grey; padding: 1px;' src='http://wallbase.org/uploads/1243459243/tn_gallery_58_113_3599.jpg'/></a> <br> By: <a href='http://wallbase.org/user/58-alexander-gg/'>Alexander-GG</a> <br></center> <br> <font color='white'> <blockquote> <img src='http://wallbase.org/v105/images.ico'> <b><i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=3'><shadow> Wallpapers</shadow></a></i></b><br> <blockquote><font size='1'><i> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png'/> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=15'>3/4 Dimensional(3D or 4D)</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png'/> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=8'>Minimalistic</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=4'>Abstract</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=13'>Animals & Plants</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=167'>Desktop Screens</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=168'>Holidays</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=5'>People</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=6'>Photo Manipulated</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=7'>Landscapes & Scenery</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=14'>Miscellaneous</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=19'>Multi Display</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=9'>Macabre & Horror</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=18'>Mac/PC </a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=18'>OS Wallpapers</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=10'>Vector</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=186'>History</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=61'>Fractal Art</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=101'>Streen Art or Graffiti</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=16'>Fantasy</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=17'>HDTV/Widescreen</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=20'>Science Fiction</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=21'>Vehicles</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=74'>Pixel Art</a><br><br> </font></i></blockquote> <img src='http://wallbase.org/v105/images.ico'> <b><i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=22'><shadow>Photographs</shadow></a></i></b><br> <blockquote><font size='1'><i> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=25'>Animals, Plants & Nature</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=134'>Body Art</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=24'>People & Portraits</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=29'>Photojournalism</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=27'>Macro</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=23'>Abstract & Surreal</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=30'>Miscellaneous</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=47'>Trees</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=26'>Still Life</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=17'>Sunriss, Sunsets & etc</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=28'>Urban & Rural</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=46'>Winter Scenes</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=169'>Holidays</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=224'>Food % Drinks</a><br><br> </font></i></blockquote> <blockquote><shadow> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=187'>Animated GIf's</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=173'>Artisan Crafts</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=194'>Anthro</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=217'>Handhelds</a></i><i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=189'>WallBase Related</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=162'>Icons</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=56'>Digital Art</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=51'>Fan Art</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=73'>Photo-Manipulation</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=172'>Scrap Images</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=145'>Vector</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=12'>Vexel</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=75'>WallBase Pro Portfolios</a><br> </i></shadow></blockquote></font> <br><br> <br> <i><font size='1'> <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=ratings'>Top Rated Images</a> | <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=views'>Most Viewed Images</a> | <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=comments'>Recent Comments</a></div><br><br> <b>How to Download</b><br> Click on the image you like,<br>you will come to an page<br> now you click on the image<br> and it will pup up in almost full size,<br> just zoom(the images will be full size when u zoom it,<br> now you right click and ''Save As Desktop Background'' )//</font></i> <br><br> </td><font size='2'> </tr>"; while ( $row = $this->DB->fetch() ) { $count++; $row['rate']['id'] = intval( $row['picid'] ); $row['rate']['number'] = intval( $row['number'] ); $row['rate']['canrate'] = 1; $row['rate']['_rate_int'] = $row['ratings_count'] ? round( $row['ratings_total'] / $row['ratings_count'], 0 ) : 0; $row['number'] = $this->registry->output->getTemplate( 'gallery_imagelisting' )->rate_form( $row['rate'] ); $return .= <<<EOF <td class='short'> <br><shadow><a href="http://wallbase.org/index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}"> <img style="-moz-border-radius: 3px; -webkit-border-radius: 3px; border: 1px solid grey; padding: 1px;" src="http://wallbase.org/uploads/{$row['directory']}/tn_{$row['masked_file_name']}" alt="{$row['caption']}"/> </a><br /> <i>By:</i> <a href='http://wallbase.org/index.php?app=gallery&module=user&user={$row['member_id']}'>{$row['uname']}</a></strong><br />{$row['number']} <br /> Comments: </a> <a href="http://wallbase.org/index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}"><b>{$row['comments']}</shadow></b></a> </td></div></center> EOF; /* New row */ if ( $count && $count % $per_row == 0 ) { $return .= "</tr><tr>"; } } $return .= "</tr></table></div>"; } /* Return */ print $return; Orginal Code: /* Init */ $return = ""; $to_show = 42; $per_row = 6; $count = 0; /* Query */ $this->DB->build( array( 'select' => 'i.id AS picid, i.masked_file_name, i.directory, i.caption, i.member_id, i.ratings_count, i.ratings_total, i.comments ', 'from' => array( 'gallery_images' => 'i' ), 'add_join' => array( 0 => array( 'select' => 'g.rate AS number', 'from' => array( 'gallery_ratings' => 'g' ), 'where' => 'i.id=g.img_id', 'type' => 'left' ) ), 'add_join' => array( 1 => array( 'select' => 'm.name as uname', 'from' => array( 'members' => 'm' ), 'where' => 'i.member_id=m.member_id', 'type' => 'left' ) ), 'order' => 'i.id DESC', 'limit' => array( 0, $to_show ), ) ); $this->DB->execute(); /* Got some rows */ if ( $this->DB->getTotalRows() ) { $return .= "<div><table>"; $return .= "<tr> <td rowspan='{$this->DB->getTotalRows()}' valign='top; left'> <div style=' background-color: #1F1F1F; -moz-border-radius: 8px; -webkit-border-radius: 8px; border: 1px solid grey; padding: 8px;' class='left'> <div style='text-align:left;'> <br><center> <br><br> <b>Featured Work</b><i>(week 47)</i> <br> <a href='http://wallbase.org/index.php?app=gallery&module=images&section=viewimage&img=2829'> <img style='-moz-border-radius: 3px; -webkit-border-radius: 3px; border: 1px solid grey; padding: 1px;' src='http://wallbase.org/uploads/1243459243/tn_gallery_58_113_3599.jpg'/></a> <br> By: <a href='http://wallbase.org/user/58-alexander-gg/'>Alexander-GG</a> <br></center> <br> <font color='white'> <blockquote> <img src='http://wallbase.org/v105/images.ico'> <b><i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=3'><shadow> Wallpapers</shadow></a></i></b><br> <blockquote><font size='1'><i> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png'/> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=15'>3/4 Dimensional(3D or 4D)</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png'/> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=8'>Minimalistic</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=4'>Abstract</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=13'>Animals & Plants</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=167'>Desktop Screens</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=168'>Holidays</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=5'>People</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=6'>Photo Manipulated</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=7'>Landscapes & Scenery</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=14'>Miscellaneous</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=19'>Multi Display</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=9'>Macabre & Horror</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=18'>Mac/PC </a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=18'>OS Wallpapers</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=10'>Vector</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=186'>History</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=61'>Fractal Art</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=101'>Streen Art or Graffiti</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=16'>Fantasy</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=17'>HDTV/Widescreen</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=20'>Science Fiction</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=21'>Vehicles</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=74'>Pixel Art</a><br><br> </font></i></blockquote> <img src='http://wallbase.org/v105/images.ico'> <b><i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=22'><shadow>Photographs</shadow></a></i></b><br> <blockquote><font size='1'><i> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=25'>Animals, Plants & Nature</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=134'>Body Art</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=24'>People & Portraits</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=29'>Photojournalism</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=27'>Macro</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=23'>Abstract & Surreal</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=30'>Miscellaneous</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=47'>Trees</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=26'>Still Life</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=17'>Sunriss, Sunsets & etc</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=28'>Urban & Rural</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=46'>Winter Scenes</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=169'>Holidays</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=224'>Food % Drinks</a><br><br> </font></i></blockquote> <blockquote><shadow> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=187'>Animated GIf's</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=173'>Artisan Crafts</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=194'>Anthro</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=217'>Handhelds</a></i><i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=189'>WallBase Related</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=162'>Icons</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=56'>Digital Art</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=51'>Fan Art</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=73'>Photo-Manipulation</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=172'>Scrap Images</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=145'>Vector</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=12'>Vexel</a></i><br> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=75'>WallBase Pro Portfolios</a><br> </i></shadow></blockquote></font> <br><br> <br> <i><font size='1'> <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=ratings'>Top Rated Images</a> | <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=views'>Most Viewed Images</a> | <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=comments'>Recent Comments</a></div><br><br> <b>How to Download</b><br> Click on the image you like,<br>you will come to an page<br> now you click on the image<br> and it will pup up in almost full size,<br> just zoom(the images will be full size when u zoom it,<br> now you right click and ''Save As Desktop Background'' )//</font></i> <br><br> </td><font size='2'> </tr>"; while ( $row = $this->DB->fetch() ) { $count++; $row['rate']['id'] = intval( $row['picid'] ); $row['rate']['number'] = intval( $row['number'] ); $row['rate']['canrate'] = 1; $row['rate']['_rate_int'] = $row['ratings_count'] ? round( $row['ratings_total'] / $row['ratings_count'], 0 ) : 0; $row['number'] = $this->registry->output->getTemplate( 'gallery_imagelisting' )->rate_form( $row['rate'] ); $return .= <<<EOF <td class='short'> <br><shadow><a href="http://wallbase.org/index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}"> <img style="-moz-border-radius: 3px; -webkit-border-radius: 3px; border: 1px solid grey; padding: 1px;" src="http://wallbase.org/uploads/{$row['directory']}/tn_{$row['masked_file_name']}" alt="{$row['caption']}"/> </a><br /> <i>By:</i> <a href='http://wallbase.org/index.php?app=gallery&module=user&user={$row['member_id']}'>{$row['uname']}</a></strong><br />{$row['number']} <br /> Comments: </a> <a href="http://wallbase.org/index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}"><b>{$row['comments']}</shadow></b></a> </td></div></center> EOF; /* New row */ if ( $count && $count % $per_row == 0 ) { $return .= "</tr><tr>"; } } $return .= "</tr></table></div>"; } /* Return */ print $return;

hahaha yeeh, u got the head but not the time im gettin it ^^,)

abandon.. again....

.... NOO,... the info.. Uploaded BY: on: date comments and the star thing.... like on the image!

I just wanna have more information the last image... like the stars ^^

tssss.... how can i do that!! lol... u are asking me to do something i have no what so ever idea on........hmm....well.. next year.. i come back with SAME answer,,,, lolled

Hey, the code, wanna edit something ^^,) is it possible to make it like Gallery info: I want it to who more info like this, a mookup: /* Init */ $return = ""; $to_show = 42; $per_row = 7; $count = 0; /* Query */ $this->DB->build( array( 'select' => 'i.id AS picid, i.masked_file_name, i.directory, i.caption, i.member_id, i.ratings_count, i.ratings_total, i.comments ', 'from' => array( 'gallery_images' => 'i' ), 'add_join' => array( 0 => array( 'select' => 'g.rate AS number', 'from' => array( 'gallery_ratings' => 'g' ), 'where' => 'i.id=g.img_id', 'type' => 'left' ) ), 'add_join' => array( 1 => array( 'select' => 'm.name as uname', 'from' => array( 'members' => 'm' ), 'where' => 'i.member_id=m.member_id', 'type' => 'left' ) ), 'order' => 'i.id DESC', 'limit' => array( 0, $to_show ), ) ); $this->DB->execute(); /* Got some rows */ if ( $this->DB->getTotalRows() ) { $return .= "<div><table>"; $return .= "<tr> <td rowspan='{$this->DB->getTotalRows()}' valign='top; left'> <div class='message user_status left'> <div style='text-align:left;'> <br><center> <b>Featured Work</b><i>(week 46)</i> <br> <a href='http://wallbase.org/index.php?app=gallery&module=images&section=viewimage&img=2804'> <img src='http://wallbase.org/uploads/1243459243/tn_gallery_1_79_99025.png'/></a> <br> By: <a href='http://wallbase.org/user/1-trcky/'>Tr!cky</a> <br></center> <br> <blockquote> <img src='http://wallbase.org/v105/images.ico'> <b><i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=3'> Wallpapers</a></i></b><br> <blockquote><font size='1'><i> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png'/> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=15'>3/4 Dimensional(3D or 4D)</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png'/> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=8'>Minimalistic</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=4'>Abstract</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=13'>Animals & Plants</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=167'>Desktop Screens</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=168'>Holidays</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=5'>People</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=6'>Photo Manipulated</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=7'>Landscapes & Scenery</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=14'>Miscellaneous</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=19'>Multi Display</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=9'>Macabre & Horror</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=18'>Mac/PC </a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=18'>OS Wallpapers</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=10'>Vector</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=186'>History</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=61'>Fractal Art</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=101'>Streen Art or Graffiti</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=16'>Fantasy</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=17'>HDTV/Widescreen</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=20'>Science Fiction</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=21'>Vehicles</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=74'>Pixel Art</a><br><br> </font></i></blockquote> <img src='http://wallbase.org/v105/images.ico'> <b><i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=22'>Photographs</a></i></b><br> <blockquote><font size='1'><i> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=25'>Animals, Plants & Nature</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=134'>Body Art</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=24'>People & Portraits</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=29'>Photojournalism</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=27'>Macro</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=23'>Abstract & Surreal</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=30'>Miscellaneous</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=47'>Trees</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=26'>Still Life</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=17'>Sunriss, Sunsets & etc</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=28'>Urban & Rural</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=46'>Winter Scenes</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=169'>Holidays</a><br> <img src='http://wallbase.org/public/style_images/wallbase10-0/user_popup.png' alt='Icon' /> <a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=224'>Food % Drinks</a><br><br> </font></i></blockquote> <blockquote><b> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=187'>Animated GIf's</a></i><span style='color:#FF0000;'><font size='1'><i> New</span></font></i><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=173'>Artisan Crafts</a></i><span style='color:#FF0000;'><font size='1'><i> New</span></font><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=194'>Anthro</a></i><span style='color:#FF0000;'><font size='1'><i> New</span></font><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=217'>Handhelds</a></i><span style='color:#FF0000;'><font size='1'><i> New</span></font><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=189'>WallBase Related</a></i><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=162'>Icons</a></i><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=56'>Digital Art</a></i><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=51'>Fan Art</a></i><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=73'>Photo-Manipulation</a></i><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=172'>Scrap Images</a></i><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=145'>Vector</a></i><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=12'>Vexel</a></i><br> <img src='http://wallbase.org/v105/images.ico'> <i><a href='http://wallbase.org/index.php?app=gallery&module=cats&do=sc&cat=75'>WallBase Pro Portfolios</a><span style='color:#FF0000;'><font size='1'><i> New</span><br></font></i><br> </i></b></blockquote> <br><br> <br> <i><font size='1'> <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=ratings'>Top Rated Images</a> | <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=views'>Most Viewed Images</a> | <a href='http://wallbase.org/index.php?app=gallery&module=stats&do=comments'>Recent Comments</a></div><br><br> <b>How to Download</b><br> Click on the image you like,<br>you will come to an page<br> now you click on the image<br> and it will pup up in almost full size,<br> just zoom(the images will be full size when u zoom it,<br> now you right click and ''Save As Desktop Background'' )//</font></i> <br><br> </td></div><font size='2'> </tr>"; while ( $row = $this->DB->fetch() ) { $count++; $row['rate']['id'] = intval( $row['picid'] ); $row['rate']['number'] = intval( $row['number'] ); $row['rate']['canrate'] = 1; $row['rate']['_rate_int'] = $row['ratings_count'] ? round( $row['ratings_total'] / $row['ratings_count'], 0 ) : 0; $row['number'] = $this->registry->output->getTemplate( 'gallery_imagelisting' )->rate_form( $row['rate'] ); $return .= <<<EOF <td class='short'><div class='message'> <br><a href="http://wallbase.org/index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}"> <img style="border:1px solid black;" src="http://wallbase.org/uploads/{$row['directory']}/tn_{$row['masked_file_name']}" alt="{$row['caption']}"/> </a><br /> <i>By:</i><a href='http://wallbase.org/index.php?app=gallery&module=user&user={$row['member_id']}'><b> {$row['uname']}</b></a></strong><br />{$row['number']} <br /> Comments: </a> <a href="http://wallbase.org/index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}"><b>{$row['comments']}</b></a> <br> </td> EOF; /* New row */ if ( $count && $count % $per_row == 0 ) { $return .= "</tr><tr>"; } } $return .= "</tr></table></div>"; } /* Return */ print $return;

Well, make it close its wayyy to hard for me ^^,) haha

So, got time now or?

I'll ask someone else since u are so busy! thanks for any help close topic(not resolved but its the end of this question)

ok, sorry!

hello? i had to remove the scripts... just so u know

okay, i've done what it says..and i cant get it to work... maybe im stupid or im missing something.. and now i have http://wallbase.org/index.php?app=gallery that problem a black box at top!

haha^^,) ---- see now: http://wallbase.org/ i cant get img up ^^