[mtha]

Originally Posted by RED_LINE

nice hack

i have this error

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT a.*, au.*, post.userid, post.postid
FROM post AS post
INNER JOIN award_user AS au ON (au.userid=post.userid)
INNER JOIN award AS a ON (a.award_id=au.award_id)
WHERE
GROUP BY au.issue_id
ORDER BY au.issue_time

mysql 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 'GROUP BY au.issue_id
ORDER BY a

mysql error number: 1064

Date: Friday 15th of April 2005 09:50:46 AM
Script: http://www.xxx.net/vb/showthread.php?p=388449
Referer: http://www.xxx.net/vb/
Username: RED_LINE
IP Address: 62.150.45.128

.....
how can i fixed this error?

Regards,

is that when you showthread? are you sure you did change the file correctly?

I DONOT have anything in showthread.php that ORDER BY au.issue_time, Could you check the awards_install_file.html and make the correct changes to the file? if the errors still there, send me the showthread.php that you have.

here's what you need to change in showthread.php:

<edit file>
showthread.php
</edit file>

<search for>
	'pollresult',
</search for>

<replace>
	'pollresult',
	'awards_bit'
</replace>

<search for>
	if (!($forumperms & CANGETATTACHMENT))
	{
		$vboptions['viewattachedimages'] = 0;
		$vboptions['attachthumbs'] = 0;
	}

	$postcount = ($pagenumber - 1 ) * $perpage;
</search for>

<add before>
// [START HACK='Yet Another Award System' AUTHOR='HacNho']
	if ($vboptions['aw_postbit'])
	{
		// 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 $postids
			GROUP BY au.issue_id
		");
		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']
</add before>

<search for>
	while ($post = $DB_site->fetch_array($posts))
	{
</search for>

<add after>
// [START HACK='Yet Another Award System' AUTHOR='HacNho']
	$post['userawards'] = '';
	$post['showuserawards'] = false;
	if ($vboptions['aw_postbit'])
	{
			if (is_array($userawardscache[$post[userid]]))
			{
				$aw_i = 0;
		    	$post['num_awards'] = count($userawardscache[$post[userid]]);
		    	foreach($userawardscache[$post['userid']] AS $award_id => $award)
				{
					$aw_i++;
		    		if ($aw_i <= $vboptions['aw_display_limit'])
					{
		    		    eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
					}
				}
				$post['showuserawards'] = true;
			}
		}
// [END HACK='Yet Another Award System' AUTHOR='HacNho']

</add after>

<search for>
	// re-initialise the $postarray variable
	$postarray = array();
	while ($post = $DB_site->fetch_array($cacheposts))
	{
</search for>

<replace>
// [START HACK='Yet Another Award System' AUTHOR='HacNho']
	if ($vboptions['aw_postbit'])
	{
		// 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
		");
		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']

	// re-initialise the $postarray variable
	$postarray = array();
	while ($post = $DB_site->fetch_array($cacheposts))
	{

// [START HACK='Yet Another Award System' AUTHOR='HacNho']
	$post['userawards'] = '';
	$post['showuserawards'] = false;
	if ($vboptions['aw_postbit'])
	{
		if (is_array($userawardscache[$post[userid]]))
		{
			$aw_i = 0;
			$post['num_awards'] = count($userawardscache[$post[userid]]);
			foreach($userawardscache[$post['userid']] AS $award_id => $award)
			{
				$aw_i++;
				if ($aw_i <= $vboptions['aw_display_limit'])
				{
		    		eval('$post[userawards] .= "' . fetch_template('awards_bit') . '";');
				}
			}
			$post['showuserawards'] = true;
		}
	}
// [END HACK='Yet Another Award System' AUTHOR='HacNho']
</replace>