vb.org Archive
Page 33 of 57 « First 233132 33 343543 Last »
Show 40 post(s) from this thread on one page

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)

carpzone 05-31-2006 08:52 AM
Tnx MTornback I can use it.

Sombody nows how to fix my problem, i can't find it :(

mtha 05-31-2006 04:06 PM
Thanks, Gaskell for your help on support. good that you love the hack :)


for translation, edit phrase: award_pm on Email Subject Text
Congratulation! You have got a new award!


Quote:
Originally Posted by MThornback
If anyone wants to add this to their ModCP, I made a simple plugin for it...don't forget to put award.php in your modcp folder if you use it...


My problem is...how do I let Mods do this without giving them supermod permissions...maybe I just need sleep and it'll come to me. Suggestions anyway?
you need to setup permission right. In my award.php, i have "canadminusers" check, you might want to modify it "somehow", to let other moderator to do the job. sorry that I dont have enough time to do it right now.

mtha 06-01-2006 02:04 AM
Quote:
Originally Posted by carpzone
I got this error when reading posts after installing de xml

Database error in vBulletin 3.5.4:

Code:
Invalid SQL:

SELECT a.*, au.*, post.userid, post.postid
FROM vb_post AS post
INNER JOIN vb_award_user AS au ON (au.userid=post.userid)
INNER JOIN vb_award AS a ON (a.award_id=au.award_id)
WHERE post.postid IN (0,2789,2790,2799,2808,2820) 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 near 'GROUP BY au.issue_id
ORDER BY au.issue_time DESC
Did all of the template changes, i installed YAAS 2.1.2 On VB 3.4.5

I hope sombody can help me with this error.
The error occures when sombody try's to klik a forumpost.:confused:

P.S. I readed al of the post in this tread, its defenitly no Guest post

Regards
Where/how did you get the error? do you have any other hack/mod that could interfere with this one?

why "GROUP BY post.postid got inserted into the query??

MThornback 06-01-2006 04:53 AM
Quote:
Originally Posted by mtha
Thanks, Gaskell for your help on support. good that you love the hack :)


for translation, edit phrase: award_pm on Email Subject Text
Congratulation! You have got a new award!




you need to setup permission right. In my award.php, i have "canadminusers" check, you might want to modify it "somehow", to let other moderator to do the job. sorry that I dont have enough time to do it right now.

Maybe the best way is to add a condition for specific userids..its a stop gap...but i'll play with it....i'll share my results if they work as always.

carpzone 06-01-2006 03:54 PM
Quote:
Where/how did you get the error? do you have any other hack/mod that could interfere with this one?

why "GROUP BY post.postid got inserted into the query??
Well i have some hacks installed
Thanks Mod
Arcade mod

Both for 3.5 offcorse

I get the error on every tread clicked, so on every tread in every forum :cross-eyed:
When i set the option of postbit display on off in the admin Cp. I having no errors.

But then nobody can't see the awards in the postbit offcorse :)

When i get the error after clicking a tread a get the default database error page. With description from my previeus post.

Must i remove somthing from the original code or somthing ?

This is my Query in postbit query from the hooks

Quote:
// [START HACK='Yet Another Award System' AUTHOR='HacNho']
if ($vbulletin->options['aw_postbit'])
{
if ($vbulletin->options['aw_postbitawardorder'] == 1)
{
$awardsdisplayorder = "ORDER BY au.issue_time ASC";
}
else if ($vbulletin->options['aw_postbitawardorder'] == 2)
{
$awardsdisplayorder = "ORDER BY a.award_displayorder ASC";
}
else if ($vbulletin->options['aw_postbitawardorder'] == 3)
{
$awardsdisplayorder = "ORDER BY a.award_displayorder DESC";
}
else
{
$awardsdisplayorder = "ORDER BY au.issue_time DESC";
}

// Obtain list of awards for current user
$alluserawards = $db->query_read("
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
". iif((!empty($cache_postids)), "post.postid IN (" . $cache_postids . ")") ."
GROUP BY au.issue_id
$awardsdisplayorder
");
while( $ua = $db->fetch_array($alluserawards))
{
$userawardscache[$ua['userid']][$ua['issue_id']] = $ua;
}
$db->free_result($alluserawards);
}
// [END HACK='Yet Another Award System' AUTHOR='HacNho']

carpzone 06-01-2006 06:30 PM
OK Problem fixed, a hooked file from Photoplog Lite (gallery) did the Job for the errors.

I d'ont now the reason but i just disabled the the hook an the YAAS works very fine now.

Awesome Mod
Thank u for this Addon ;)

buyinflatables 06-07-2006 03:04 AM
I installed this and it sems great!!! The only problem I am having is the request reward link.

When I click on it I get page that says:

Username, you do nothave permissions to access this page etc...

And I get this as a user or admin?

Did I miss something?

Im using 3.5.4

Thank you

Tim

MThornback 06-07-2006 06:10 AM
Quote:
Originally Posted by MThornback
Maybe the best way is to add a condition for specific userids..its a stop gap...but i'll play with it....i'll share my results if they work as always.
As promised...it will work in the ModCP...I decided not to add the per user condition....but if you want it...it should be something like:

Code:
if (!can_moderate('canmoderate') AND $vbulletin->GPC['userid']=='x,y,z')
x,y,z are userids...that bit is untested....but I think it should work....if it doesn't try putting () around the userid condition....

Gaskell 06-07-2006 04:10 PM
Quote:
Originally Posted by buyinflatables
I installed this and it sems great!!! The only problem I am having is the request reward link.

When I click on it I get page that says:

Username, you do nothave permissions to access this page etc...

And I get this as a user or admin?

Did I miss something?

Im using 3.5.4

Thank you

Tim
Daft question - have you allowed your usergroups to request awards in Usergroup Manager? :)

buyinflatables 06-07-2006 08:38 PM
Thank you... Didnt realize that option was added there.

It works now.


Does anyone know where to get different award images. I saw only a few on here... but could have sworn I seen more elswhere... Just dont remember where.

Thanks again!!

Tim


All times are GMT. The time now is 10:59 PM.
Page 33 of 57 « First 233132 33 343543 Last »
Show 40 post(s) from this thread on one page

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.01467 seconds
  • Memory Usage 1,755KB
  • 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
  • (2)bbcode_code_printable
  • (7)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