New version of jAwards: v 0.5

have you improved/changed the user selection process yet ?

damiendownload wrote:

have you improved/changed the user selection process yet ?

Not yet, this was just a quick fix for MySQL 4.0

Next feature is the user selection, as soon as I find the time :dry:

oh okay no worries

I upgraded the joomla to 1.0.11 and i have problem with com_jawards.

When i want to see the list of the members, who have the x award, then apears this error message:

DB function failed with error number 1064
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 'ORDER BY u.username' at line 4 SQL=SELECT ua.*,u.username, u.id AS userid FROM jos_jawards_awards as ua LEFT JOIN jos_users AS u ON u.id = ua.userid WHERE ua.award = ORDER BY u.username

any idea?

MySQL version is 4.1.21
PHP vesrion is 4.4.2

Thanks in advance

Then you probably also switched register_globals-Emulation off in Joomla, right?

That produces the error probably, I am aware of that problem. I'll fix that asap.

Here's a quick fix for jAwards compatibility with register_globals set to off.
In file components/com_jawards/jawards.php, at about line 19 (directly after 2 lines of "require_once..."), insert the following line:

[code:1]$award = mosGetParam( $_GET, 'award' , '' );[/code:1]

(Yes, that's really all )

A fixed version of jAwards, along with more fixes and improvements will come out soon too.