Images for IP.Gallery 3.1.0

[Tricky]

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;

Edytowane 12 Grudnia 2009 przez Tricky

[DawPi]

Firefox can't find this page.

[Tricky]

Well, its okay with the urls

[DawPi]

Take a look:

[Tricky]

Ohhh! that was just an example url hehe

[Tricky]

Hmm, about this new url thing..

i tried to find codes about this, but im kinda newbie

http://wallbase.org/gallery/image/2890-north-flash/

Edytowane 13 Grudnia 2009 przez Tricky

[DawPi]

What kind of codes..? ......

[Tricky]

for the last image

                
<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 />