vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Yet Another Awards System 3.5 v2.1.2 (https://vborg.vbsupport.ru/showthread.php?t=94836)

cyberhypnotic 01-20-2006 03:14 AM

Any way of allowing a Moderator to have access to the Award Manager? Or to the whole Awards navigation? Basically, adding it to the Moderators navigation menu in the ModCP?

I'm desperate to be able to allow a Mod award giving privileges, but not AdminCP access. Any help?

rb290 01-20-2006 07:44 PM

hey i need some help, i've had this hack installed for awhile and ive been doing vB upgrades and i keep doing the edits after every upgrade for this hack but now i dont know whats wrong when people request an award I dont get a pm anymore..know whats wrong ?

EDIT: nevermind, i found where to do it in the Award System Settings

mtha 01-22-2006 12:40 AM

Quote:

Originally Posted by cyberhypnotic
Any way of allowing a Moderator to have access to the Award Manager? Or to the whole Awards navigation? Basically, adding it to the Moderators navigation menu in the ModCP?

I'm desperate to be able to allow a Mod award giving privileges, but not AdminCP access. Any help?

Sorry guys, my time is too limited now, so I currently cant give any support or upgrade to the hack. The hack is proved to be working properly, so if other members can give a hand on problems, it's be greatly appreciated.

I will try my best to give support when I have some spot on my schedule :)

GlitterKill 01-26-2006 03:20 PM

Quote:

Originally Posted by Gaskell
No problems - happy to help where I can :)

in the admincp when managing an award (giving a new one) how can the list of current members with the award be sorted alphabetically? Since I have multiple moderators and alot of award recipients there have been a few duplicate awards given. Sorting the list like this would make it easier to prevent that problem. :)

Gaskell 01-26-2006 06:33 PM

I have no idea on that I'm afraid. I am not a coder, so maybe someone else knows or can code a bit to do that :)

mtha 01-30-2006 01:53 AM

Quote:

Originally Posted by GlitterKill
in the admincp when managing an award (giving a new one) how can the list of current members with the award be sorted alphabetically? Since I have multiple moderators and alot of award recipients there have been a few duplicate awards given. Sorting the list like this would make it easier to prevent that problem. :)

well, I dont have a sorting argument yet, but you can do something like this:

edit /admincp/award.php

Line 722-727:
LOOK FOR
Quote:

$awardusers = $db->query_read("
SELECT au.*, u.username
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u USING (userid)
WHERE au.award_id=". $vbulletin->GPC['award_id'] ."
");

REPLACE WITH

Quote:

$awardusers = $db->query_read("
SELECT au.*, u.username
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u USING (userid)
WHERE au.award_id=". $vbulletin->GPC['award_id'] ."
ORDER BY u.username
");

Hellcat 02-04-2006 07:45 AM

WOW!
That's not only exactely what I was looking for, this is even MORE!
I gave it a brief testrun on my private test install - GREAT THING!
I like the "Request Award" feature, my members will LOVE it!

[high]* Hellcat hits INSTALL :)[/high]

Roxie 02-06-2006 12:38 AM

Is there away to arrange the order that the awards appear on the list (profile, postbit, memberslist)?

Ghanem 02-06-2006 03:54 AM

Quote:

Originally Posted by unicorn
Hi,
thank you first for the gr8 hack..

I have a small problem with award requests email..
the email received by admin looks like:

https://vborg.vbsupport.ru/showpost....&postcount=228

Some one forgoten here :rolleyes:

wallymg 02-06-2006 04:57 AM

Hi,

I have installad the german version of this award system yesterday. (Version 2.0.4 / VB Version 3.5.3)

Everything works fine but from time to time I receive the following Database Error via Email:

Datenbankfehler in vBulletin 3.5.3:

Invalid SQL:

SELECT a.*, au.*
FROM award a, award_user au
WHERE (au.userid = ) AND (a.award_id=au.award_id)
ORDER BY au.issue_time;

MySQL-Fehler : You have an error in your SQL syntax near ') AND (a.award_id=au.award_id)
ORDER BY au.issue_time
' at line 4
Fehler-Nr. : 1064
Datum : Monday, February 6th 2006 @ 12:42:09 AM
Skript : http://www.arcadeinfo.de/announcement.php?f=36
Referrer :
IP-Adresse : 68.142.251.50
Benutzername : Unregistriert
Klassenname : vb_database


I cant find the error. Like I said the Board and the Scipt are working fine. Just this stupid email from time to time. Is there a way to slove the problem ?

Thanks in Advance
Walter

dvsDave 02-06-2006 07:49 PM

Quote:

Originally Posted by cyberhypnotic
Any way of allowing a Moderator to have access to the Award Manager? Or to the whole Awards navigation? Basically, adding it to the Moderators navigation menu in the ModCP?

I'm desperate to be able to allow a Mod award giving privileges, but not AdminCP access. Any help?

Would doing this be a simple matter of copying the files to the modcp folder and finding in the code where it requires admin rights and changing them to mod rights?

Tracer Gun Kata 02-07-2006 06:56 AM

Quote:

Originally Posted by GlitterKill
Hmm I have run into a strange error. When trying to assign an award to any member with a ' in their name it returns an error and the award is not given. For instance, the member name "rockin'male" return an error because of the apostrophe. All other usernames with apostrophes return errors as well when trying to give them awards.

Any ideas how to fix this?

Same problem here.. attempt to give the user with an apostrophe in there name an award and it gives the following error -

Quote:

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT userid, username
FROM user
WHERE username = 'Pain'NDass';

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 'NDass'' at line 3
Error Number : 1064
Date : Tuesday, February 7th 2006 @ 09:55:19 AM
Script : http://www.onlinewarfare.net/forum/admincp/award.php
Referrer : http://www.onlinewarfare.net/forum/a...rs&award_id=15
IP Address : [Removed]
Username : [Removed]
Classname : vb_database

prettyboi 02-07-2006 07:36 AM

I'd love this award system. My members like this new modification that I've done with it :) **INSTALLED**

ubblite 02-18-2006 07:29 AM

I like this hack, however I'm receiving an error that only affects members profiles who have received an Award, everything else seems to work fine:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /member.php(651) : eval()'d code on line 89

Plus, for some reason some of the text color on the same affected pages is a light gray, almost unreadable.

Any ideas?

ubblite 02-18-2006 08:56 PM

I accidentally left the following part out.

I also get this same error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /member.php(651) : eval()'d code on line 89

Right after giving a user award in AdminCP/Manager/Manage/Add User Awards

If nobody is sure how to fix this, can someone possibly tell me how to disable the Awards System in Users Profiles? I've tried removing YAAS code from the memberinfo template but I still receive the same mysql error.

Ignignokt 02-20-2006 06:39 PM

I looked in all the zip files and settings.request_award.php does not exist?

Can anyone confirm / help me out?

creedmaniac 02-21-2006 10:17 AM

how can i put a link for this in the quick links dropdown box on the navbar? (a link for the award request form)

creedmaniac 02-21-2006 05:46 PM

a good feature i think for this would be the ability to choose for each category if it is requestable or not?

i have set up three categories...
user awards
mod/admin awards
contest awards

the contest awards category awards are determined through contests...so it doesn't matter if someone request it or not...they ain't gonna get it unless they won that contest, so i would just prefer this category to not show up on the request award page

GlitterKill 02-23-2006 02:15 PM

Can anyone confirm this is cool with VB 3.54?

Ghanem 02-23-2006 02:40 PM

Quote:

Originally Posted by GlitterKill
Can anyone confirm this is cool with VB 3.54?

working fine with me after upgrading to 3.5.4 :)

Sidewindr 03-01-2006 04:03 AM

Any idea when voting will be written into this hack?

I'd like to see nominations and then voting so awards can be done every however often you do them and the forum themselves can nominate individuals and then vote for them.

dirtycrow 03-01-2006 04:18 AM

request award page was working, but now when user click on the request awrd link the page appears blank.

thoughts?

kellee88 03-04-2006 10:21 PM

I seem to be able to get into the Award System settings in the AdminCP, but Award Category Manager gives me:

Fatal error: Call to a member function on a non-object in /home2/[website]/public_html/admincp/award_cat.php on line 99

Award Manager gives me:

Fatal error: Call to undefined function: globalize() in /home2/[website]/public_html/admincp/award.php on line 515

and Add New Award gives me:

Fatal error: Call to undefined function: globalize() in /home2/[website]/public_html/admincp/award.php on line 173

Any ideas??

Some additional on this. We just upgraded from 3.0.7 to 3.5.4. We had an awards system in 3.0.7. Although, we uninstalled the old hack, the new awards system is picking up the old awards and posting them on the Members' Postbit. Could this be the problem with installing the new Awards hack?

Tracer Gun Kata 03-04-2006 11:12 PM

Quote:

Originally Posted by GlitterKill
Hmm I have run into a strange error. When trying to assign an award to any member with a ' in their name it returns an error and the award is not given. For instance, the member name "rockin'male" return an error because of the apostrophe. All other usernames with apostrophes return errors as well when trying to give them awards.

Any ideas how to fix this?

Same problem here.. attempt to give the user with an apostrophe in there name an award and it gives the following error -

Quote:

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT userid, username
FROM user
WHERE username = 'Pain'NDass';

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 'NDass'' at line 3
Error Number : 1064
Date : Tuesday, February 7th 2006 @ 09:55:19 AM
Script : http://www.onlinewarfare.net/forum/admincp/award.php
Referrer : http://www.onlinewarfare.net/forum/a...rs&award_id=15
IP Address : [Removed]
Username : [Removed]
Classname : vb_database

Annie^.^ 03-08-2006 11:32 AM

It's interesting I am using 3.5.3 and I am thinking of updating to 3.5.4 soon

I am getting this error from certain users especially when they are using FireFox Browser

Quote:

Invalid SQL:

SELECT a.*, au.*, post.userid, post.postid
FROM vbpost AS post
INNER JOIN vbaward_user AS au ON (au.userid=post.userid)
INNER JOIN vbaward AS a ON (a.award_id=au.award_id)
WHERE post.postid IN (0,2536,2537,2538,2539,2536)
post.postid IN (2536,2537,2538,2539)
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 'post.postid IN (2536,2537,2538,2539)
GROUP BY au.issue_id

Error Number : 1064
Date : Monday, March 6th 2006 @ 06:08:32 AM
Script : http://www.mysite.com/forum/showthread.php?t=414
Referrer : http://www.mysite.com/forum/forumdisplay.php?f=51
IP Address : 80.104.......
Username : USER
Classname : vb_database
How do I fix this? Is the creator of this mod still suporting this Mod?

The only time this error show when the user is trying to view the thread

jynx'd 03-17-2006 12:02 AM

i cannot install the XML file says it doesnt exhists

majorxp 03-19-2006 06:03 AM

Quote:

Originally Posted by Ignignokt
I looked in all the zip files and settings.request_award.php does not exist?

Can anyone confirm / help me out?

Confirmed...I don't see it either!

Tracer Gun Kata 03-20-2006 09:21 AM

Been a while and no answer to query.

Quote:

Originally Posted by GlitterKill
Hmm I have run into a strange error. When trying to assign an award to any member with a ' in their name it returns an error and the award is not given. For instance, the member name "rockin'male" return an error because of the apostrophe. All other usernames with apostrophes return errors as well when trying to give them awards.

Any ideas how to fix this?

Same problem here.. attempt to give the user with an apostrophe in there name an award and it gives the following error -

Quote:

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT userid, username
FROM user
WHERE username = 'Pain'NDass';

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 'NDass'' at line 3
Error Number : 1064
Date : Tuesday, February 7th 2006 @ 09:55:19 AM
Script : http://www.onlinewarfare.net/forum/admincp/award.php
Referrer : http://www.onlinewarfare.net/forum/a...rs&award_id=15
IP Address : [Removed]
Username : [Removed]
Classname : vb_database

kellee88 03-21-2006 05:44 PM

Quote:

Originally Posted by kellee88
I seem to be able to get into the Award System settings in the AdminCP, but Award Category Manager gives me:


Fatal error: Call to a member function on a non-object in /home2/[website]/public_html/admincp/award_cat.php on line 99

Award Manager gives me:

Fatal error: Call to undefined function: globalize() in /home2/[website]/public_html/admincp/award.php on line 515

and Add New Award gives me:

Fatal error: Call to undefined function: globalize() in /home2/[website]/public_html/admincp/award.php on line 173


Any ideas??

Some additional on this. We just upgraded from 3.0.7 to 3.5.4. We had an awards system in 3.0.7. Although, we uninstalled the old hack, the new awards system is picking up the old awards and posting them on the Members' Postbit. Could this be the problem with installing the new Awards hack?

Since no one can answer this, is there an awards system that works with 3.5.4?

TwinsForMe 03-21-2006 07:01 PM

How do I remove the "Total Awards" number and link from the postbit legacy? See attached screenshot:

TwinsForMe 03-22-2006 01:18 AM

Quote:

Originally Posted by TwinsForMe
How do I remove the "Total Awards" number and link from the postbit legacy? See attached screenshot:

Figured it out.

Tracer Gun Kata 03-22-2006 08:39 AM

Quote:

Originally Posted by GlitterKill
Hmm I have run into a strange error. When trying to assign an award to any member with a ' in their name it returns an error and the award is not given. For instance, the member name "rockin'male" return an error because of the apostrophe. All other usernames with apostrophes return errors as well when trying to give them awards.

Any ideas how to fix this?

Same problem here.. attempt to give the user with an apostrophe in there name an award and it gives the following error -

Quote:

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT userid, username
FROM user
WHERE username = 'Pain'NDass';

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 'NDass'' at line 3
Error Number : 1064
Date : Tuesday, February 7th 2006 @ 09:55:19 AM
Script : http://www.onlinewarfare.net/forum/admincp/award.php
Referrer : http://www.onlinewarfare.net/forum/a...rs&award_id=15
IP Address : [Removed]
Username : [Removed]
Classname : vb_database
Got to be some bright spark here who can resolve this small niggling problem??

yinyang 03-24-2006 08:25 PM

great hack and installed.

my problem is the ordering of the awards in the postbit. i have 3 categories and would like the medals in category 1 to go first, category 2 to go second, etc. right now, it only puts them in ascending order or by issue date.

is there a way to change this? also, exactly how is ascending order calculated?

jawinn 03-25-2006 03:03 PM

Can awards be automatically assigned based on group membership?

The Ottoman 04-01-2006 02:05 AM

Quote:

Originally Posted by Tracer Gun Kata
Same problem here.. attempt to give the user with an apostrophe in there name an award and it gives the following error -



Got to be some bright spark here who can resolve this small niggling problem??



I had that problem, so I just added them by memberId.

Worked perfectly.

optrex 04-07-2006 08:33 AM

I am getting an error on certain users awards in Firefox (they are OK in IE).

Take a look at http://midlandsweather.org.uk/showth...61#post1007361

I would love some help please

Annie^.^ 04-07-2006 09:40 AM

Yes same here..

klinsek 04-10-2006 08:29 PM

This system is so perfect for my needs but it is missing one key feature.

Automated award issuance..

I would like the ability to assign awards by usergroups. So, if you are in a certain usergroup you are automatically assigned an award/badge.

Has anyone modded this hack with such a feature?

Thanks

nomiqw 04-12-2006 01:30 PM

Where can i find the Memberinfo file where abouts in the server as i am new to Vbulletin hacks
if you can tell me like is it inside include folder or somewhere else
just give a example diretory locatin ill find the rest
Thank you

Gaskell 04-12-2006 01:38 PM

Memberinfo is a template.

Go into the ACP, then into Styles and Templates. Go into the templates list (edit templates on the style you want to change) and find Member Info Templates. Expand that menu and you will see the template MEMBERINFO at the top of it.

Click Edit and put the edit mentioned in the install file on that :)


All times are GMT. The time now is 07:43 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01772 seconds
  • Memory Usage 1,851KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (21)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete