Tricky

yeah, like i understand that

http://wallbase.org/page/wallbasepro hr hr

You are talking professional now, witch i dont understand... im a newbie!! really!

from Deviantart.com.. mm.. easy for you to say ^^,)

Hello Well, i want to make a more professional "skin/look" for my Pro Member feature list looks like this now: http://wallbase.org/page/wallbasepro But, i want to make it better than that almost like the attachment, but i want to have links in it to.. i searched around the net, but didnt find anything... hope you can help! (ps: this is just a mookup form dA)

Got it now code should be: <img src="{$this->settings['board_url']}/index.php?app=downloads&module=display&section=screenshot&id={$row['file_id']}" width='128' height='100' alt="{$row['file_name']}" /> Thank you VERY much DawPi!! ;)

working but i cant see any screenshots.. http://wallbase.org/page/2

^^,) im sorry, but its still IPS Error. error: Date: Sat, 19 Dec 2009 19:07:48 +0000 Error Number: 1054 Error: Unknown column 'dr.ssupload' in 'on clause' IP Address: 95.34.31.102 Page: /page/2 Debug: array ( 1 => array ( 'file' => '/home/wallb0/public_html/ips_kernel/classDb.php', 'line' => 1019, 'function' => 'query', 'class' => 'db_driver_mysql', ), 3 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/sources/pages.php', 'line' => 137, 'function' => 'eval', 'class' => NULL, ), 4 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 589, 'function' => 'recachePage', 'class' => 'pageBuilder', ), 5 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 413, 'function' => '_getPageContent', 'class' => 'public_ccs_pages_pages', ), 6 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 121, 'function' => '_view', 'class' => 'public_ccs_pages_pages', ), 7 => array ( 'file' => '/home/wallb0/public_html/admin/sources/base/ipsController.php', 'line' => 291, 'function' => 'doExecute', 'class' => 'public_ccs_pages_pages', ), ) mySQL query error: SELECT f.file_id, f.file_name,m.name as uname,dr.record_thumb FROM downloads_files f LEFT JOIN members m ON ( f.file_submitter=m.member_id ) LEFT JOIN downloads_files_records dr ON ( dr.record_file_id=f.file_id AND dr.ssupload="ssupload" ) ORDER BY f.file_id DESC LIMIT 0,18 /* Init */ $return = ""; $to_show = 18; $per_row = 6; $count = 0; /* Query */ $this->DB->build( array( 'select' => 'f.file_id, f.file_name', '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' ), 1 => array( 'select' => 'dr.record_thumb', 'from' => array( 'downloads_files_records' => 'dr' ), 'where' => 'dr.record_file_id=f.file_id AND dr.ssupload="ssupload"', 'type' => 'left', 'limit' => array(0, 1), 'order' => 'dr.' ) ), '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['record_thumb'] ) { $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> </td> EOF; /* New row */ if ( $count && $count % $per_row == 0 ) { $return .= "</tr><tr>"; } } $return .= "</tr></table></div>"; } /* Return */ print $return;

Date: Sat, 19 Dec 2009 17:08:44 +0000 Error Number: 1054 Error: Unknown column 'f.file_ssurl' in 'field list' IP Address: 95.34.31.102 Page: /page/2 Debug: array ( 1 => array ( 'file' => '/home/wallb0/public_html/ips_kernel/classDb.php', 'line' => 1019, 'function' => 'query', 'class' => 'db_driver_mysql', ), 3 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/sources/pages.php', 'line' => 137, 'function' => 'eval', 'class' => NULL, ), 4 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 589, 'function' => 'recachePage', 'class' => 'pageBuilder', ), 5 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 413, 'function' => '_getPageContent', 'class' => 'public_ccs_pages_pages', ), 6 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 121, 'function' => '_view', 'class' => 'public_ccs_pages_pages', ), 7 => array ( 'file' => '/home/wallb0/public_html/admin/sources/base/ipsController.php', 'line' => 291, 'function' => 'doExecute', 'class' => 'public_ccs_pages_pages', ), ) mySQL query error: SELECT f.file_id, f.file_name, f.file_ssurl,m.name as uname,dr.record_thumb FROM downloads_files f LEFT JOIN members m ON ( f.file_submitter=m.member_id ) LEFT JOIN downloads_files_records dr ON ( dr.record_file_id=f.file_id AND dr.ssupload="ssupload" ) ORDER BY f.file_id DESC LIMIT 0,18

hmm, i still get Ips error

thanks, but, still gives me error Date: Sat, 19 Dec 2009 15:37:20 +0000 Error Number: 1054 Error: Unknown column 'f.file_ssurl' in 'field list' IP Address: 95.34.31.102 Page: /page/2 Debug: array ( 1 => array ( 'file' => '/home/wallb0/public_html/ips_kernel/classDb.php', 'line' => 1019, 'function' => 'query', 'class' => 'db_driver_mysql', ), 3 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/sources/pages.php', 'line' => 137, 'function' => 'eval', 'class' => NULL, ), 4 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 589, 'function' => 'recachePage', 'class' => 'pageBuilder', ), 5 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 413, 'function' => '_getPageContent', 'class' => 'public_ccs_pages_pages', ), 6 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 121, 'function' => '_view', 'class' => 'public_ccs_pages_pages', ), 7 => array ( 'file' => '/home/wallb0/public_html/admin/sources/base/ipsController.php', 'line' => 291, 'function' => 'doExecute', 'class' => 'public_ccs_pages_pages', ), ) mySQL query error: SELECT f.file_id, f.file_name, f.file_ssurl,m.name as uname FROM downloads_files f LEFT JOIN members m ON ( f.file_submitter=m.member_id ) ORDER BY f.file_id DESC LIMIT 0,18

mhm, after i added the "last Downloads code" in unreal portal or ip.content, i get Fatal Error, IPS error, and the Fail code are the one below: =================================================== Date: Sat, 19 Dec 2009 11:15:44 +0000 Error Number: 1054 Error: Unknown column 'f.file_ssname' in 'field list' IP Address: 95.34.31.102 Page: /page/2 Debug: array ( 1 => array ( 'file' => '/home/wallb0/public_html/ips_kernel/classDb.php', 'line' => 1019, 'function' => 'query', 'class' => 'db_driver_mysql', ), 3 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/sources/pages.php', 'line' => 137, 'function' => 'eval', 'class' => NULL, ), 4 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 589, 'function' => 'recachePage', 'class' => 'pageBuilder', ), 5 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 413, 'function' => '_getPageContent', 'class' => 'public_ccs_pages_pages', ), 6 => array ( 'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php', 'line' => 121, 'function' => '_view', 'class' => 'public_ccs_pages_pages', ), 7 => array ( 'file' => '/home/wallb0/public_html/admin/sources/base/ipsController.php', 'line' => 291, 'function' => 'doExecute', 'class' => 'public_ccs_pages_pages', ), ) mySQL query error: SELECT f.file_id, f.file_name, f.file_ssname,m.name as uname FROM downloads_files f LEFT JOIN members m ON ( f.file_submitter=m.member_id ) ORDER BY f.file_id DESC LIMIT 0,5 and i want it to work with 3.0.5, witch it doest!

code works in 3.0.4, but not in 3.0.5 =================================================== Date: Sat, 12 Dec 2009 20:29:03 +0000 Error Number: 1064 Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 IP Address: **REMOVED** Page: /forums/index.php?app=downloads&module=display&section=download&do=confirm_download&id=270 Debug: array ( 1 => array ( 'file' => '/home/dfbor/public_html/forums/ips_kernel/classDb.php', 'line' => 1019, 'function' => 'query', 'class' => 'db_driver_mysql', ), 4 => array ( 'file' => '/home/dfbor/public_html/forums/admin/applications_addon/ips/downloads/modules_public/display/download.php', 'line' => 104, 'function' => '_displayConfirm', 'class' => 'public_downloads_display_download', ), 5 => array ( 'file' => '/home/dfbor/public_html/forums/admin/sources/base/ipsController.php', 'line' => 291, 'function' => 'doExecute', 'class' => 'public_downloads_display_download', ), ) mySQL query error: SELECT file_name, file_id, file_cat, file_open, file_submitter, file_name_furl FROM ibf_downloads_files WHERE file_id=

I get ips error or fatal error when i use this.. possible to fix it? <?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> </td> EOF; /* New row */ if ( $count && $count % $per_row == 0 ) { $return .= "</tr><tr>"; } } $return .= "</tr></table></div>"; } /* Return */ print $return; ?> </td> </tr> </tbody> </table>

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