Tricky

Because i have to use Both, Gallery & Downloads, and Gallery u cant upload Zip + Screenshot, thats why wanna have 2 in 1

Well, i hope ur not mad at me, but i need some help again.. i haven't modified the code i got from you, it works great! But, i wanna have both Gallery Images + Downloads files screenshots in same code, so i dont have them separated! (i really wanna have the rating stars there, + comments.. Gallery images <table class='ipb_table' cellspacing="100"> <tbody> <tr> <td class='row1'> <?php /* Init */ $return = ""; $to_show = 36; $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>"; 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'> <a href="index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}"> <img src="uploads/{$row['directory']}/tn_{$row['masked_file_name']}" alt="{$row['caption']}" /> </a><br /> <i>By:</i><a href='index.php?app=gallery&module=user&user={$row['member_id']}'><b> {$row['uname']}</b></a></strong><br />{$row['number']} <br /> <a href="index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}">Comments:</a> <a href="index.php?app=gallery&module=post&section=comment&do=postcomment&img={$row['picid']}"><b>{$row['comments']}</b></a> </td> EOF; /* New row */ if ( $count && $count % $per_row == 0 ) { $return .= "</tr><tr>"; } } $return .= "</tr></table></div>"; } /* Return */ print $return; ?> Download images(screenshots) <?php /* Init */ $return = ""; $to_show = 18; $per_row = 6; $count = 0; /* Query */ $this->DB->build( array( 'select' => 'f.file_id, f.file_name, f.file_ssname', 'from' => array( 'downloads_files' => 'f' ), 'add_join' => array( 0 => array( 'select' => 'm.name as uname', 'from' => array( 'members' => 'm' ), 'where' => 'f.file_submitter=m.member_id', 'type' => 'left' ) ), 'order' => 'f.file_id DESC', 'limit' => array( 0, $to_show ), ) ); $this->DB->execute(); /* Got some rows */ if ( $this->DB->getTotalRows() ) { $return .= "<div><table><tr>"; while ( $row = $this->DB->fetch() ) { $count++; $return .= <<<EOF <td class='short'> <a href="index.php?app=downloads&showfile={$row['file_id']}"> EOF; if ( $row['file_ssname'] ) { $return .= <<<EOF <img src="index.php?app=downloads&module=display&section=screenshot&id={$row['file_id']}" width='128' height='100' alt="{$row['file_name']}" /> EOF; } else { $return .= <<<EOF <em>No Screenshot Available</em> EOF; } $return .= <<<EOF </a><br /> <i>By:</i> <strong>{$row['uname']}</strong><br> In <a href="http://wallbase.org/index.php?app=downloads"> Skins & Themes</a> </td> EOF; /* New row */ if ( $count && $count % $per_row == 0 ) { $return .= "</tr><tr>"; } } $return .= "</tr></table></div>"; } /* Return */ print $return; ?> </td> </tr> </tbody> </table>

thank you so much!!!! and, one more tiny thing^^,) is it a possibility to do the same(Comments & Stars) on Last Skin & Themes code i have: <div class='moderation_bar rounded clear'> <center> <i><b><h3>Skins & Themes</h3></font></i> </div> </center> <?php /* Init */ $return = ""; $to_show = 24; $per_row = 6; $count = 0; /* Query */ $this->DB->build( array( 'select' => 'f.file_id, f.file_name, f.file_ssname', 'from' => array( 'downloads_files' => 'f' ), 'add_join' => array( 0 => array( 'select' => 'm.name as uname', 'from' => array( 'members' => 'm' ), 'where' => 'f.file_submitter=m.member_id', 'type' => 'left' ) ), 'order' => 'f.file_id DESC', 'limit' => array( 0, $to_show ), ) ); $this->DB->execute(); /* Got some rows */ if ( $this->DB->getTotalRows() ) { $return .= "<div><table><tr>"; while ( $row = $this->DB->fetch() ) { $count++; $return .= <<<EOF <td class='short'> <a href="index.php?app=downloads&showfile={$row['file_id']}"> EOF; if ( $row['file_ssname'] ) { $return .= <<<EOF <img src="index.php?app=downloads&module=display&section=screenshot&id={$row['file_id']}" width='128' height='100' alt="{$row['file_name']}" /> EOF; } else { $return .= <<<EOF <em>No Screenshot Available</em> EOF; } $return .= <<<EOF </a><br /> <i>By:</i> <strong>{$row['uname']}</strong><br> In <a href="http://wallbase.org/index.php?app=downloads"> Skins & Themes</a> </td> EOF; /* New row */ if ( $count && $count % $per_row == 0 ) { $return .= "</tr><tr>"; } } $return .= "</tr></table></div>"; } /* Return */ print $return; ?>

neeh, forget it Make it resolved..

Hmm, i mean, make the "comments" a link to the Add comment at the image.. hmm^^ http://wallbase.org/index.php?app=gallery&module=post&section=comment&do=postcomment&img=

thanks! but one thing, sorry for the questions but you are only one who helped me with this and, im Thankful! Is it possible to make Comments, a link to the comments.? like: i uploaded a image, and a guy has made a comment, and i can just click on the "Comments", and i get to the comment that has been made @ my uploaded image ! Easy way: Comments(will be a link) -> redirect to the image comments

Yeah i try'd in CCS first but when i added the code in the board code, everything just got PooW

hmm, the code does Only work in CCS not in the skin.. the login boxes are here and there and the text are on top and bottom...^^

ooh ! better to get done with the other ones thanks for reply:)

hmm, i havent added it.. here is the code... the log in works.. but when i add it in the skin the boxes are all over the place... <form action="http://wallbase.org/index.php?app=core&module=global&section=login&do=process" base="public"}" method="post" id='login'> <tbody> <tr> <td width="100%" class="row2"><b>User Name</b></td> <td width="100%" class="row2"><input type="text" size="15" maxlength="64" name="username" class="input_text" /> </td> </tr> <tr> <td width="50%" class="row2"><b>Password</b></td> <td width="50%" class="row2"><input type="password" size="15" name="password" class="input_text" /> </td> </tr> <tr> <td colspan="2" class="row2" align="center"> <input class="input_submit" type="submit" name="submit" value="sign in" /> </td> </tr> </tbody> </table> </form>

hmm, is this in English tooooo?

Hey, i wanna say think you for the help before, but, my members wanna see "commets" above the Stars.. ex1: Comments: 0 ex2: Comments: 7 Here are the code: <table class='ipb_table' cellspacing="100"> <tbody> <tr> <td class='row1'> <?php /* Init */ $return = ""; $to_show = 36; $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 ', '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>"; 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'> <a href="index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}"> <img src="uploads/{$row['directory']}/tn_{$row['masked_file_name']}" alt="{$row['caption']}" /> </a><br /> <i>Uploaded By:</i><br> <a href='index.php?app=gallery&module=user&user={$row['member_id']}'><b>{$row['uname']}</b></a></strong><br />{$row['number']} </td> EOF; /* New row */ if ( $count && $count % $per_row == 0 ) { $return .= "</tr><tr>"; } } $return .= "</tr></table></div>"; } /* Return */ print $return; ?>

look like the attachment.. hmm..only without the name and dots (and the "login img")

Hello, i wanna have log in boc on top of my skin:, where the Sign in and help are! http://wallbase.org and i want Only guests to see this! i have this code: <form action="{parse url="app=core&module=global&section=login&do=process" base="public"}" method="post" id='login'> <tbody> <tr> <td width="30%" class="row2"><b>User Name</b></td> <td width="70%" class="row2"> <input type="text" size="15" maxlength="64" name="username" class="input_text" /> </td> </tr> <tr> <td width="30%" class="row2"><b>Password</b></td> <td width="70%" class="row2"> <input type="password" size="15" name="password" class="input_text" /> </td> </tr> <tr> <td colspan="2" class="row2" align="center"> <input class="input_submit" type="submit" name="submit" value="sign in" /> </td> </tr> </tbody> </table> </form> it will show like this: http://wallbase.org/index.php?/page//test2 but this is not working: The requested URL /{parse url= was not found on this server.

aaaah ^^ thanks , im blond you know...^^

hmm.. forget about the thing above But, i have another question. How can i do like: "i allow nude wallpapers, and i wanna have a "Waring" screenshot on the front page instead of the "nude" wallpapers.. is it possible to make a code who will do that or do i have to "not allow nude walls?

Can't find it anywhere.. ^^,)

One more thing, i uploaded a avatar @ 88x31, but the img didn't appear on the last submitted walls... I notice, when i set Down the thumbnails to 50x50, i can see a smaaaaaal img, but when i set it up to original thumbnail size it wont appear! So how can i get the img to show up when the thumbnail are at 128x128 without setting the thumbnail img size down?

hehe Thanks for trying and helping me!

hmm, now i can't see any of the images ^^,)

That gave me IPS Error..

I want to show THE screenshot to the movie...

Hmm, first, i uploaded a movie, then i uploaded a jpg, thet url to the screenshot are: http://wallbase.org/uploads/1243459243//tn_gallery_1__4302.jpg hmm

here:

You are holding back information