vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Add-On Releases - Yet Another Awards System (https://vborg.vbsupport.ru/showthread.php?t=196244)

CypherSTL 01-07-2010 06:04 AM

Quote:

Originally Posted by HolyKiller (Post 1949333)
Nice mod, like it on 3.8. Hope version for vB4 come soon :)

I do believe I have figured out the how to convert everything over to the new template system for vB4.

It is still a work in progress, and I'm just trying to do everything slowly so I don't miss anything and have to go back and do it again.

HolyKiller 01-07-2010 10:19 AM

2 CypherSTL: Excelent, just dont hurry and make it perfect ;)

Emperor_Mel 01-07-2010 12:05 PM

Not gonna upgrade to VB4 until your all done.. :)

CypherSTL 01-09-2010 12:10 AM

I have my next release v3.8.3 running on one of my clan websites for some testing. Once I get all the tweaks done with that, it will be released here.

Some new features:
  • Point System.
  • Award Request/Recommend forms are now separate to avoid confusion.
  • Separate Award Request/Recommend permissions.
  • Few bug fixes.
There is a known issue with using MySQLi over MySQL that I am trying to get worked out first before I release it. However, everything still functions 100%.

Quote:

Originally Posted by Emperor_Mel (Post 1949511)
Not gonna upgrade to VB4 until your all done.. :)

I have started working on getting everything moved over the 4.0 the other evening, still have quite a bit left to do. A lot more will get done once 4.0.1 is released.

Veer 01-09-2010 04:12 AM

That's really good news :)

Good luck CypherSTL, waiting for the release.

CypherSTL 01-09-2010 08:57 AM

Good news for everyone who is waiting for this mod to be ported over to vBulletin 4.

Everything is functioning 100% from what I can tell. I'm in the process now of removing the old styling code so it fits in more with the look and feel of 4.0.

vB 4.0.1 is scheduled for release on Monday, so I'll try my best to have the vB4 release of this mod ready for you guys to test :)

abdulbasitsaeed 01-09-2010 09:53 AM

Excellent news! :)

*rubs hands*

absy 01-09-2010 02:31 PM

Thats great news :)

CypherSTL 01-10-2010 09:04 AM

Release 4.0.0 BETA is now available.
https://vborg.vbsupport.ru/showthread.php?t=232684

Xanlamin 01-10-2010 08:06 PM

Version 3.8.3 released.

Post bugs if you find any.

+ Recommend awards (enable/disable in the usergroup settings)
+ Assign Point Values to awards

alnassrah 01-10-2010 08:42 PM

Can you upgrade to vB version 4.0.0 ?

Xanlamin 01-10-2010 08:52 PM

Read the post right above where I said this version has been upgraded.....

racingsolution 01-10-2010 08:59 PM

Uninstalled 3.8.2 and installed 3.8.3 in hopes it would fix my previous problem. I'm still getting this error when trying to access "awards.php"


Fatal error: Cannot redeclare construct_depth_mark() in /home/cobaltli/public_html/forums/includes/adminfunctions.php on line 1823


Also tried "Give Award to User" in MODCP and got this


Parse error: syntax error, unexpected ';' in /home/cobaltli/public_html/forums/modcp/award.php on line 245

Xanlamin 01-10-2010 11:57 PM

You must have an issue with another mod that is affecting this, on our test board and on another board that is highly modified we are having no issues.

I suggest you start to disable your mods one by one until this error goes away to help you find the problem mod.

racingsolution 01-11-2010 12:04 AM

Looks like the culprit is the DTO Garage mod.

racingsolution 01-11-2010 12:17 AM

Well by deleting the function function construct_depth_mark from awards.php it fixes the problem.

Xanlamin 01-11-2010 01:40 AM

Does doing so also affect any functions from the awards working properly?

racingsolution 01-11-2010 01:51 AM

Quote:

Originally Posted by Xanlamin (Post 1952420)
Does doing so also affect any functions from the awards working properly?

Everything seems to be running just fine.. I also had to fix a few bugs in the ModCp/award.php file .. there were a few ")" missing from a couple $db->escape_string lines .. no biggie though..

DarkArmada 01-11-2010 02:22 AM

Only issue so far is when an award recommendation is submitted, the user is taken to the standard error screen, but the recommendation is still PM'd to the admin user's PM inbox (my PM inbox).

Using vB 3.8.1 (going to upgrade shortly to see if that's causing it)

Xanlamin 01-11-2010 03:15 AM

Uploaded new zip, fixed errors that was found in racingsolutions post dealing with the ModCP

racingsolution 01-11-2010 03:21 AM

Cool :) Thanks for supporting your mod.. My members really enjoy it

xorex 01-11-2010 09:03 AM

Thanks

Charles_1 01-11-2010 09:08 AM

I am using YAAS for long time already and becouse I have vBulletin v3.8.3 and the idea of points for awards is great, I just installed YAAS v3.8.3 (downloaded 30 minutes ago). But now I have these database errors caused by users with some awards from earlier:

Code:

Database error in vBulletin 3.8.3:

Invalid SQL:

                                                SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
                                                FROM award a, award_user au
                                                WHERE (au.userid = 46060) AND (a.award_id=au.award_id);

MySQL Error  : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Forum is running fine but when is loaded some thread or post with user with some award, the database error appear. I have to disable YAAS for now. Any suggestion to solve this problem please?

CypherSTL 01-11-2010 01:10 PM

Quote:

Originally Posted by Charles_1 (Post 1952576)
I am using YAAS for long time already and becouse I have vBulletin v3.8.3 and the idea of points for awards is great, I just installed YAAS v3.8.3 (downloaded 30 minutes ago). But now I have these database errors caused by users with some awards from earlier:

Code:

Database error in vBulletin 3.8.3:

Invalid SQL:

                        SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
                        FROM award a, award_user au
                        WHERE (au.userid = 46060) AND (a.award_id=au.award_id);

MySQL Error  : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Forum is running fine but when is loaded some thread or post with user with some award, the database error appear. I have to disable YAAS for now. Any suggestion to solve this problem please?

Running into this problem on the 4.0 release as well. All I can recommend until I can get a fix, is to Disable the point system.

CypherSTL 01-11-2010 01:24 PM

Just curious Charles, what version of MySQL are you running?

Charles_1 01-11-2010 02:58 PM

Quote:

Originally Posted by CypherSTL (Post 1952729)
Just curious Charles, what version of MySQL are you running?

MySQL Version 4.1.20

NachoTPAO 01-11-2010 04:05 PM

Awesome mod, could you make it possible that some awards are automatically given upon meeting some value such as having registered 2 years ago or having 1000 posts or being promoted to moderator and so? It would be very useful for medium-big forums like mine (15.000 members,800k Posts) so that the mod team doesnt have to give them manually. Bye!

racingsolution 01-11-2010 04:11 PM

Quote:

Originally Posted by NachoTPAO (Post 1952860)
Awesome mod, could you make it possible that some awards are automatically given upon meeting some value such as having registered 2 years ago or having 1000 posts or being promoted to moderator and so? It would be very useful for medium-big forums like mine (15.000 members,800k Posts) so that the mod team doesnt have to give them manually. Bye!

Hm I like this.. it could be incorporated into a cron job to update members daily

gunboard 01-11-2010 04:30 PM

Hi,

sinse i have updated i have "_" between the award icons in postbit. else there is a blank line in
the admincp > setup menu.

Xanlamin 01-11-2010 11:51 PM

mySQL grouping erros resolved. Download newest zip and reimport the xml.

CypherSTL 01-12-2010 05:09 AM

Quote:

Originally Posted by racingsolution (Post 1952385)
Well by deleting the function function construct_depth_mark from awards.php it fixes the problem.

Most likely, now if you have multiple category sections, some of the category names will be doubling up.

robdawg 01-12-2010 01:07 PM

Is anyone else having a problem where the dropdown in the vBulletin Options Admin Section has a blank entry for this Awards Manager?

gunboard 01-12-2010 03:12 PM

Hi,

how i can delete the ascii 31 (_) between the award icons in postbit ?

Speysider 01-13-2010 06:46 PM

Quote:

Originally Posted by robdawg (Post 1953510)
Is anyone else having a problem where the dropdown in the vBulletin Options Admin Section has a blank entry for this Awards Manager?

I'm having this problem as well.

Xanlamin 01-13-2010 07:02 PM

Have you tried to re-import the XML to overwrite to see if this solves this error, so far I have been unable to reproduce this problem.

DarkArmada 01-13-2010 07:23 PM

Stupid question, but what do the points actually do? I'm running vbExperience which manages my point system - is there a plugin available to add the points to vbE?

Xanlamin 01-13-2010 07:47 PM

You can assign a point value to the awards, once the user reaches a certain point structure they will receive the corresponding award.

Cars2007 01-13-2010 11:35 PM

Quote:

Originally Posted by Xanlamin (Post 1953153)
mySQL grouping erros resolved. Download newest zip and reimport the xml.

We are still having the same issue with the latest version of the plugin. Any ideas?

Downloaded YaAS-3.8.3.1.zip from the link above.

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:

                                                SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
                                                FROM award a, award_user au
                                                WHERE (au.userid = 4981) AND (a.award_id=au.award_id);

MySQL Error  : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number  : 1140


CypherSTL 01-14-2010 03:48 AM

From looking at the database error, it would seem that it isn't using the new query.

Have you re-imported the XML?

It should be using this query:
Code:

SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
FROM ' . TABLE_PREFIX . 'award a, ' . TABLE_PREFIX . 'award_user au
WHERE (au.userid = '.$this->profile->userinfo['userid'].') AND (a.award_id=au.award_id) AND (a.award_active = "1")
GROUP BY au.userid


gunboard 01-14-2010 05:27 AM

Quote:

Originally Posted by Xanlamin (Post 1954753)
Have you tried to re-import the XML to overwrite to see if this solves this error, so far I have been unable to reproduce this problem.

yes i have tried to reimport the Mod. Does not fix the problem. Sorry for my bad english :D


All times are GMT. The time now is 11:55 AM.

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.02076 seconds
  • Memory Usage 1,824KB
  • 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
  • (4)bbcode_code_printable
  • (10)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