Can someone integrate this so it shows up in ZOINTS profiles too?

Database error in vBulletin 3.6.5:

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 post.postid IN (0,5288,5244,5169,5161,5158,5154,5142,4651,4291,42 50) GROUP BY post.postid

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

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 au.issue_time DESC' at line 7
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 05:53:15 AM
Script : http://www.novusordosaeculorum.com/s...34.html?p=5288
Referrer : http://www.novusordosaeculorum.com/
IP Address : 124.86.224.8
Username : Mike
Classname : vB_Database

You rock.

The above error disappears when I turn off the POSTBIT function in the admin area!

Will this run on vb 3.6.4? Also, I use Postbit, (not legacy) will this work? Thanks!

Database error in vBulletin 3.6.4:

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 post.postid IN (0,11332,11334,11336,11337,11338) GROUP BY post.postid

GROUP BY au.issue_id
ORDER BY au.issue_time DESC;

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 au.issue_time DESC' at line 7
Error Number : 1064
Date : Wednesday, March 21st 2007 @ 11:04:22 PM
Script : http://www.talkwhatever.com/showthread.php?p=11338
Referrer : http://www.talkwhatever.com/index.php
IP Address : 72.92.141.48
Username : admintw42
Classname : vb_database

For me this occurs when I turn ON postbit - assuming it is the double GROUP BY but not sure how to fix that in the product.

On member.php there is a problem also where it shows the small awards showcase:

Awards Showcase
The Ladybug Award: For excellent posts

Congratulations!" border="0" />

Issue with quotes in the "Reason" field?

Do you have some other hack that replace the $postids value and add a GROUP BY post.postid ?


please check what's other hacsk using this hook location: showthread_query

I'm not sure but by simply removing the GROUP BY in the product XML and replacing with a comma I was able to get it working.

Great Mod really chuffed about it :):) Thanks

How can I check this?

It's PhotoPlog causing the problem. Grrrr

What I did is simply remove the Group By altogether - no user will receive the same award twice so this should not be an issue (fingers crossed) - This has been quite a learning experience delving more into the vB code.

I will release a fix for that one. hope it will work

Wow, cool plugin, thanks.

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'مشرف عام',
`description` = '',
`usertitle` = 'Super Moderator',
`opentag` = '<font color=\"#800000\">',
`closetag` = '</font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`pmdailyquota` = '',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '0',
`forumpermissions` = '1048575',
`genericpermissions` = '535779055',
`attachlimit` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '15',
`adminpermissions` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4'
WHERE usergroupid=5;

MySQL Error : Unknown column 'pmdailyquota' in 'field list'
Error Number : 1054
Date : Thursday, March 22nd 2007 @ 05:23:34 PM
Script : http://www.marsauae.com/bb/admincp/u....php?do=update
Referrer : http://www.marsauae.com/bb/admincp/u...&usergroupid=5
IP Address :
Username : marsauae
Classname : vB_Database

Great mod but I'm having a problem with moderators not being able to view the awards in the modcp. It's there because I can see it, but when they try to access it, they get "you do not have permission to use this page".

I can't find where I can edit their permissions. Only 2 moderators will have permission to issue awards.

Excellent Mod... One error I spotted and also a feature request.

I get the following error when attempting to do a mass move in the award manager


Also I wanted to know if you could add a feature in the "Award System Settings" to enable or disable the "Awards SHowcase" in the user profile.


p.s - How can I paginate the images in both the postbit and when they appear in the small "awards showcase" in the user profile? I have about 10 awards showing up there but they just run in one line and I'd like to make it do 5 per line.

Cool another awards system. Just to pick which one to use...

I have the plugin installed, but i only have the aDmin-options link. I don't have links to the awards.php or awards manager.

Please help.

Yet another question... which template controls the award display in postbit? I want to make some changes there but can't figure out which of your templates is the one to edit. thanks.

any update on problem with vbadvanced?

This is excellent, installed thanks, Mike.

I upgraded from 2.1.2 to this 2.1.4 and now I get this error?

This error doesnt seem to relate to this hack

Upgrade to version 2.1.4


Do you have anything special when you try to mass-move? anyway, try with the new version.

should the awards being automatically wrap?


You have to add the link. upload the files again might solve the problem


postbit and postbit_legacy.

please try the new version 2.1.4 . it should work.

well, I just remove the description in the link tag. it should be ok with 2.1.4


ok, in 2.1.4, field type for award description and reason is changed to text, now you can put more stuff in there, but I am not guaranty about the template (if your long custom description would look nice on the pages.

Great mod :) Awesome work! /installed.

Installed and so far so good!

Question: On user posts, rather that showing the newest/oldest awards - could it be possible to just show random awards, per user posts?

Thanks!

Now if I could just get custom ranks per user [not per group like VB works] I'll be set.

No sorry, you mis-understood. I'm wondering which of your added templates needs to be edited to change it. Is it the award_showcase template?

Basically what I'm trying to do is change the way the awards are displayed in the post bit i.e remove the awards showcase box around them, have them display directly next to each other instead of spaced, and have them display automatically wrap 5 per line. Which template is it that controls the display? award_showcase?

My finger lay in wait on the "Donate" button should I be able to accomplish these things I need. Would make my site so much better, and smoother to run.

::grease palm::

I have the same question as techenigma .

Another question.
anyone know where i could get medals? specially the small medal icons.

thanks!

Here are my medals, not sure if you will find them useful.

There are a number of awards that are similar to the example one that comes with this MOD. The ones in the /gd/ directory are the ones that I really use [however only a small % of them].

Odie's Ghost Dogs Medals

I just got this message when I tried to give an award. It did give them the award though.

I'm also showing this message at the top of the profile pages of people who have the award:
Also, I'm not getting any awards displaying in the postbit.

in module "YAAS - Showthread_postbit_create"
add
after

Would it be possible (did not see it listed in its abilities) to have it ato remove the award after X amount of days?

Where am I supposed to be looking to find that? Will that fix all the problems?

Installed and working great TY

Does anyone know where I can find some "cute" awards for a mommy board?

Question 1:

Why template conditionals dont work in awards_bit template?

example:

<if conditional="THIS_SCRIPT == 'member' ">
teste01
<else />
teste02
</if>

Will show teste01 teste02 in postbit and memberinfo

How to fix it? I need use conditionals...

Question 2:

You save the award reason in the field issue_reason on table *award_user, but you dont offer a option to edit the reason by board admincp. Why?

Can you add this option? I just edited the reason directly in phpmyadmin.

Thanks

I installed this wonderful awards (thank you very much...just what I needed) but I have a problem...when I go to give an award, the person I give it to...any of the boards they have posted in have an error for all to see...the error is a tad different for each posting, but you get the idea here:

Fatal error: Call to a member function on a non-object in /public/vbulletin/showthread.php(1095) : eval()'d code on line 15

But the second I remove the award, this error goes away.

(scratches head) I have no clue. Any suggestions for me?:confused: