[RED_LINE]

thankyou MarcoH64

no porblem Dean :nervous:

Originally Posted by mtha

:"> sorry Marco and DeanC, i fotgot that we cant distribute files.


RedLine, check and see if your showthread has anything like this:

ORDER BY au.issue_time

If you find any, paste that part of code (with the whole query) hereI dont have that line on my code, and your errror says that it got error at that location.




can you test and see when and where it apprear?

make sure that you do upload the right file to the right location.

i see that code you told me

(ORDER BY au.issue_time) at line 1304

PHP Code:

// [START HACK='Yet Another Award System' AUTHOR='HacNho']
                // Obtain list of awards for current user
                        $alluserawards =  $DB_site->query("
                                SELECT a.*, au.*, post.userid, post.postid
                                FROM " . TABLE_PREFIX . "post AS post
                                INNER JOIN " . TABLE_PREFIX . "award_user AS au ON (au.userid=post.userid)
                                INNER JOIN " . TABLE_PREFIX . "award AS a ON (a.award_id=au.award_id)
                                WHERE post.postid IN (" . $cache_postids . ")
                                GROUP BY au.issue_id
                                ORDER BY au.issue_time
                        ");
                        while( $ua = $DB_site->fetch_array($alluserawards))
                        {
                                $userawardscache[$ua['userid']][$ua['issue_id']] = $ua;
                        }
                        $DB_site->free_result($alluserawards);
// [END HACK='Yet Another Award System' AUTHOR='HacNho'] 


thanx for help mtha :nervous: