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


All times are GMT. The time now is 06:27 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.01532 seconds
  • Memory Usage 1,745KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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