View Full Version : Major Additions - Yet Another Awards System
Pages :
1
2
3
4
5
6
[
7]
8
Thunderbird8
08-08-2013, 10:10 AM
It's being triggered by a bug in the automation, but you can work around that by removing the apostrophe from the issue reason.
vbandroid
08-14-2013, 02:07 PM
In the automation system, say i have 4 awards for posts. It seems to be deleting the awards for any previous post count requirements and adding the latest award. So for example
Award 1 - 50 posts
Award 2 - 100 posts.
I'll already have the Award 1 50 post award but when i finally get to 100 posts the auto systems takes a away the 50 posts award 1 and adds the 100 post award 2 in its place. Is their a way to get it not to take away a previously rewarded award?
vbandroid
08-15-2013, 02:25 AM
Never mind i figured out how to get the trophies to stack up instead and instead of delete.
ITDarasgah
08-20-2013, 06:31 AM
Hi,
all is good but no post or thread generating on award given.
any suggestion?
squidsk
08-20-2013, 09:07 PM
Hi,
all is good but no post or thread generating on award given.
any suggestion?
Have you set the setting so that a post or thread is generated and does the forum/thread the settings is pointing to actually exist and can the user granting the award post in that forum/thread?
CAG CheechDogg
08-21-2013, 08:27 AM
Hello squidsk,
Is it possible to add feature to delete mass awards for a member?
Also, would it be possible to log who gives awards in the admin logs?
Thanks in advance!
ITDarasgah
08-21-2013, 02:50 PM
Have you set the setting so that a post or thread is generated and does the forum/thread the settings is pointing to actually exist and can the user granting the award post in that forum/thread?
yep all 3 points already done
friendlymela
09-04-2013, 09:59 AM
Superbb Mod
Impromptu
09-04-2013, 11:53 AM
Hi Guys,
Scenario is I want to have:
1 medal for Top 100 finishes, so all the medals are the same. However, I also want to show the actual ranking when you hover over the medal.
Top 100 medal - hover shows '2nd Overall (2013)'
Top 100 medal - hover shows '4th Overall (2013)'
Top 100 medal - hover shows '99th Overall (2013)'
The most obvious but LONG way is to make 100 awards and just change the Name/Description but that would mean I have to do 100 links to icon and images, name and description; which is not practical.
Is there a way I can show the actual rank, such as putting the rank in the 'issue reason' box? At least, it's just one box rather than replicating 100 award with links to icon, images, name, description etc.
Right now it shows all with the medals as Top 100 (2013), which at the last resort I'll just have to accept. But it's weird as the guy 2nd Overall did exceptionally well whereas the guy who finishes 99th did good.
The reason why I can't replicate the awards 100 times, is there due to the fact that I have Top 1000 medals
thanks all
Dogma21cw
09-06-2013, 01:21 AM
Now I have skimmed through all the posts since my last visit and haven't seen this question raised.
How difficult would it be to set it up to automatically add a user to a usergroup upon issuing a certain award?
squidsk
09-06-2013, 01:21 PM
Hello squidsk,
Is it possible to add feature to delete mass awards for a member?
Also, would it be possible to log who gives awards in the admin logs?
Thanks in advance!
The second would be easier than the first, but I'll see what I can do.
Hi Guys,
Scenario is I want to have:
1 medal for Top 100 finishes, so all the medals are the same. However, I also want to show the actual ranking when you hover over the medal.
Top 100 medal - hover shows '2nd Overall (2013)'
Top 100 medal - hover shows '4th Overall (2013)'
Top 100 medal - hover shows '99th Overall (2013)'
The most obvious but LONG way is to make 100 awards and just change the Name/Description but that would mean I have to do 100 links to icon and images, name and description; which is not practical.
Is there a way I can show the actual rank, such as putting the rank in the 'issue reason' box? At least, it's just one box rather than replicating 100 award with links to icon, images, name, description etc.
Right now it shows all with the medals as Top 100 (2013), which at the last resort I'll just have to accept. But it's weird as the guy 2nd Overall did exceptionally well whereas the guy who finishes 99th did good.
The reason why I can't replicate the awards 100 times, is there due to the fact that I have Top 1000 medals
thanks all
You can put whatever you want in the issue reason, but without altering the code you would not be able to put different items into the alt tags for each award.
Now I have skimmed through all the posts since my last visit and haven't seen this question raised.
How difficult would it be to set it up to automatically add a user to a usergroup upon issuing a certain award?
The only way to do it would be to alter the existing code since there are no hooks in the awards system. I might look at adding some hooks in later versions.
Amaury
09-09-2013, 04:53 AM
Did you ever see this post (https://vborg.vbsupport.ru/showpost.php?p=2405804&postcount=1438), Squid?
Anyway, my main point of this post: Can you please add a background to the content of the awards profile tab by default so it matches the others, such as About Me?
About Me Example: http://i.imgur.com/wc8OpvD.png
It's a simple fix, really. In the awards_memberinfo.css template, add a background to the following code:
#view-myawards .memberinfo_awards_row {
padding: 6px 0;
}
Like so:
#view-myawards .memberinfo_awards_row {
padding: 6px 0;
background: {vb:stylevar postbit_lite_background};
}
Before: http://i.imgur.com/XHJ4mwx.png
After: http://i.imgur.com/Y9tbDy8.png
Amaury
09-11-2013, 04:09 PM
Anyway, my main point of this post: Can you please add a background to the content of the awards profile tab by default so it matches the others, such as About Me?
About Me Example: http://i.imgur.com/wc8OpvD.png
It's a simple fix, really. In the awards_memberinfo.css template, add a background to the following code:
#view-myawards .memberinfo_awards_row {
padding: 6px 0;
}Like so:
#view-myawards .memberinfo_awards_row {
padding: 6px 0;
background: {vb:stylevar postbit_lite_background};
}
Before: http://i.imgur.com/XHJ4mwx.png
After: http://i.imgur.com/Y9tbDy8.png
Looks like this isn't as simple as I thought, because when I change Content Background in profile customization, it has no effect on the background there.
CAG CheechDogg
09-12-2013, 05:13 AM
The second would be easier than the first, but I'll see what I can do.
Good stuff squidsk ! Take your time it's not something I need now but it would help out a lot knowing who is giving awards to our members.
Thanks again in advance!
katie hunter
09-18-2013, 11:23 AM
Which is more updated for the latest version of vb 4.x, this mod or this https://vborg.vbsupport.ru/showthread.php?t=265893&highlight=Yet+Another+Awards+System
Since they are the same.
squidsk
09-18-2013, 05:09 PM
Which is more updated for the latest version of vb 4.x, this mod or this https://vborg.vbsupport.ru/showthread.php?t=265893&highlight=Yet+Another+Awards+System
Since they are the same.
They aren't the same, they're close, since that mod is basically a copy of this one with tables and stuff renamed to enable having this modification installed twice; however, that mod has not had the last couple of updates that this one has had, which is noted by the last updated dates on the respective mod pages.
gamaken
09-19-2013, 02:11 AM
I have my maximum awards set to 3 in my postbit_legacy. Some of my members have been awarded more than 3 awards. They are asking for a way to be able to choose which awards are displayed in their postbit_legacy. Is this possible to implement?
katie hunter
09-19-2013, 06:24 PM
They aren't the same, they're close, since that mod is basically a copy of this one with tables and stuff renamed to enable having this modification installed twice; however, that mod has not had the last couple of updates that this one has had, which is noted by the last updated dates on the respective mod pages.
Hi Squidsk,
So you're saying your mod is more recently updated?
I compared the two but your mod supports vb 4.0.2 while TheLastSuperman's mod support vb 4.1.x in general, and i was looking for one which supports vb 4.2.1 or closer. Does your mod supports vb 4.2.1?
But i do see your last update is recent compare to TheLastSuperman's mod.
Is there a way to import the award list and users http://forum.nihonomaru.com/awards.php from the 3.7.x version? or would i have to reissue these awards and recreate them?
It would be nice to have some sort of pagination per category like these below, is there any plan for this? I've requested this for vb 3.7.x long time ago, but it was never done for the version of vb 3.7.x, i really hope it gets implemented for the 4.x version http://www.nihonomaru.com/awards
something fun i did but not vb related http://www.nihonomaru.com/profile/yu...2/achievements
Amaury
09-19-2013, 10:36 PM
Does your mod supports vb 4.2.1?
It works fine on vBulletin 4.2.1.
squidsk
09-20-2013, 07:28 PM
I have my maximum awards set to 3 in my postbit_legacy. Some of my members have been awarded more than 3 awards. They are asking for a way to be able to choose which awards are displayed in their postbit_legacy. Is this possible to implement?
Anything is possible, but it isn't something I'm going to implement as letting each user select which awards, up to your maximum display amount, they want to display is not practical.
Hi Squidsk,
So you're saying your mod is more recently updated?
Yes, I've released updates more recently that resolved a number of issues that are still present in the ranks mod.
I compared the two but your mod supports vb 4.0.2 while TheLastSuperman's mod support vb 4.1.x in general, and i was looking for one which supports vb 4.2.1 or closer. Does your mod supports vb 4.2.1?
The version just means what is the lowest version of vbulletin that your mod supports. As the mod works on both versions there was no need to update the vbulletin version.
And yes this mod works with vb 4.2.1. The only thing it doesn't do is make use of the new navigation manager that came with vb 4.2, but you can add the navigation element manually so it isn't a deal breaker.
Is there a way to import the award list and users http://forum.nihonomaru.com/awards.php from the 3.7.x version? or would i have to reissue these awards and recreate them?
You don't need to do anything except make sure you're running the most recent 3.8 version
at https://vborg.vbsupport.ru/showthread.php?t=196244. In theory you should be able to update from the vb3.7 version but I won't make promises and I'd recommend testing it on a test site before your live site and even then have a db backup ready to go.
It would be nice to have some sort of pagination per category like these below, is there any plan for this? I've requested this for vb 3.7.x long time ago, but it was never done for the version of vb 3.7.x, i really hope it gets implemented for the 4.x version http://www.nihonomaru.com/awards
Pagination per category likely won't happen, because even on your site if I used the vbulletin per page setting none of your categories would likely have more than 2 pages saving only the space of one or two awards. I would however consider making the categories collapsible.
katie hunter
09-20-2013, 08:44 PM
Hi Squidsk, thanks =)
And yes this mod works with vb 4.2.1. The only thing it doesn't do is make use of the new navigation manager that came with vb 4.2
Can you update the mod so it is using the new navigation manager of vb 4.2? Vb 4.x would be very new for me when i upgrade so i would be lost and wouldn't know from where to start.
For me i have thousands of anime awards like these http://www.nihonomaru.com/awards, so i would really love to see pagination finally integrated, it never happened on vb 3.7.x. I really hope it is there for the vb 4.x version. Would you consider implementing it for the upcoming update?
I have another question, on mike's mod i see one of the admin tabs you can view the awards requests via admincp, do you have this? See where it says "Rank Requests" https://vborg.vbsupport.ru/attachment.php?attachmentid=130475&d=1309219379
dhonchik
09-21-2013, 07:36 PM
Medals dont works in signature start and signature end
VB 4.2.1, fix please
squidsk
09-25-2013, 04:50 PM
Can you update the mod so it is using the new navigation manager of vb 4.2? Vb 4.x would be very new for me when i upgrade so i would be lost and wouldn't know from where to start.
It is very easy to do there are plenty of guides available to walk someone through it. I am planning to eventually add that to the mod but can't say when it will happen.
For me i have thousands of anime awards like these http://www.nihonomaru.com/awards, so i would really love to see pagination finally integrated, it never happened on vb 3.7.x. I really hope it is there for the vb 4.x version. Would you consider implementing it for the upcoming update?
I am not going to implement pagination of awards at this time.
I have another question, on mike's mod i see one of the admin tabs you can view the awards requests via admincp, do you have this? See where it says "Rank Requests" https://vborg.vbsupport.ru/attachment.php?attachmentid=130475&d=1309219379
Yes, as I mentioned before that mod is a copy of this one with various internal stuff renamed. All features of that mod exist in this mod and any features added since that one was last updated are present in this mod but not that one.
Medals dont works in signature start and signature end
VB 4.2.1, fix please
Works just fine, the users either does not have a signature or has chosen not to display it, either of which will prevent awards from showing in the signature section.
fat_gezzar
09-30-2013, 01:18 PM
Been using this mod for a long time now and love it :)
There is one thing i would like some help with and thats the number of awards displayed currently five are displayed on a line and i would like each line of awards to display only four.
So if someone has 8 awards they would display in two lines of 4 instead of 5 on the top and 3underneath.
thanks for your help in advance
squidsk
09-30-2013, 02:07 PM
Been using this mod for a long time now and love it :)
There is one thing i would like some help with and thats the number of awards displayed currently five are displayed on a line and i would like each line of awards to display only four.
So if someone has 8 awards they would display in two lines of 4 instead of 5 on the top and 3underneath.
thanks for your help in advance
There's really no easy way to code that since there are so many factors that will affect how many awards are on each line, such as the width of the postbit and the size of the awards icons.
Vick98
10-01-2013, 12:28 AM
What is the easiest way to center the awards under the signature? I am going for a block look for the awards under the signature. Similar to the ribbons on a soldiers uniform.
CAG CheechDogg
10-02-2013, 04:43 AM
What is the easiest way to center the awards under the signature? I am going for a block look for the awards under the signature. Similar to the ribbons on a soldiers uniform.
Link to your site?
EBZ2010
10-02-2013, 03:47 PM
Link to your site?
His site is www.soullessknights.com.
CAG CheechDogg
10-03-2013, 06:19 AM
His site is www.soullessknights.com.
Can't view anything it is all set to private...
katie hunter
10-03-2013, 06:26 AM
There is one feature that is needed, i hope it gets implemented. For sites which has many awards per category, we'd need to have the categories displayed in a drop down menu.
Having a very long 1 page with all categories and awards is really really bad. It would be nice to display awards per category. Visually too it is more organized and better.
katie hunter
10-05-2013, 05:08 PM
Hey squidsk, why is there 3 files? what are these files used for?
Default CSS Data.txt
YaAS-Automation-R2.zip
Where do you upload the default css data? I presume this is for the style of the award in potbit_legacy?
squidsk
10-05-2013, 08:00 PM
There is one feature that is needed, i hope it gets implemented. For sites which has many awards per category, we'd need to have the categories displayed in a drop down menu.
Having a very long 1 page with all categories and awards is really really bad. It would be nice to display awards per category. Visually too it is more organized and better.
It just isn't feasible, since there's no requirements that every category has to have X awards making pages look lopsided or having categories spread over pages.
Hey squidsk, why is there 3 files? what are these files used for?
Default CSS Data.txt
YaAS-Automation-R2.zip
Where do you upload the default css data? I presume this is for the style of the award in potbit_legacy?
The first is an old version of the default css, that would have been used to reset the css if you screwed it up. It's outdated right now so not helpful. The automation is an addon for the mod that grants awards to users based on certain criteria like post count, time as a member, etc.
CAG CheechDogg
10-05-2013, 08:03 PM
Hey hey Squidskster, any news on the action log to see who awarded and deleted awards for the admin panel yet?
katie hunter
10-05-2013, 11:09 PM
Hey Squidskster =) well i would really love to see a sort of a navigation with a drop down menu that helps me jump to a category, but i know what you mean but having a very long page of award is really bad, especially if someone has 100s of awards to upload.
Installed :) http://forum.nihonomaru.com/awards.php
katie hunter
10-07-2013, 10:59 AM
Hi Squidskster =) do you know how can i apply a url redirect with vbseo ? so my url is /awards/ instead of awards.php
It is usually like this:
ex for calender ==> //'calendar/\?(.+)' => 'calendar.php?$1'
Any Idea or thoughts on a version of this for VB5*?
PAPPACLART
10-09-2013, 11:57 AM
does this work fine for VB4.2.1
squidsk
10-09-2013, 01:59 PM
Hi Squidskster =) do you know how can i apply a url redirect with vbseo ? so my url is /awards/ instead of awards.php
It is usually like this:
ex for calender ==> //'calendar/\?(.+)' => 'calendar.php?$1'
Since I don't use vbseo, its hard to say, but my guess would to copy an existing entry, such as the calendar one you've provided and rename the appropriate parts
Any Idea or thoughts on a version of this for VB5*?
Not anytime soon, I have a lot on my plate and even the changes/improvements/additions I want to make to the vb4 version are not yet complete.
does this work fine for VB4.2.1
Yes, with the exception of the fact that you will have to manually add an item to the navigation manager.
squidsk
10-11-2013, 02:32 PM
Hey hey Squidskster, any news on the action log to see who awarded and deleted awards for the admin panel yet?
Sorry I missed this yesterday. I'm currently working on it and it should be in the next release. The next release will also include an option that should provide a performance boost, most noticeable for sites with lots of users with awards.
netzwart
10-15-2013, 03:09 AM
Hi,
first of all: Congratulation for this brilliant MOD!
I am running this MOD in its version 4.0.4 and found out, that the latest version is 4.0.6, such that I want/need to update the MOD. How do I update? Is it possible to simply exchange those parts which have changed? Do I have to run the whole installation procedure again?
Thanks for your help !!!
nw
CAG CheechDogg
10-15-2013, 08:01 AM
Sorry I missed this yesterday. I'm currently working on it and it should be in the next release. The next release will also include an option that should provide a performance boost, most noticeable for sites with lots of users with awards.
Nice! You Da' Man squidsk! Thanks in advance Bro really appreciate it!
squidsk
10-15-2013, 07:49 PM
Hi,
first of all: Congratulation for this brilliant MOD!
I am running this MOD in its version 4.0.4 and found out, that the latest version is 4.0.6, such that I want/need to update the MOD. How do I update? Is it possible to simply exchange those parts which have changed? Do I have to run the whole installation procedure again?
Thanks for your help !!!
nw
You need to download the current version (4.0.6), from the top of the page and follow the instruction in the installation instructions file.
Dogma21cw
10-19-2013, 10:03 AM
So this is happening, kind of out of the blue:
https://vborg.vbsupport.ru/external/2013/10/33.png (http://s143.photobucket.com/user/hotardgabby/media/awards_zpsf9a7595b.png.html)
Any clues on a fix? Is is a vB thing? I tried uninstall/reinstall a fresh D/L of the plugin. But no dice. And is in all styles, and on every browser.
I also mean the double comma before the first name in the list.
Skyrider
10-19-2013, 06:27 PM
The automation.. Is there a cron? When it is being done? I can't find a button to manually run it, and it's not doing it right away (waited 5min) after I added it. It's not showing up in the task manager either, though I have found it in the XML file:
<scheduling weekday="-1" day="-1" hour="1" minute="30" />
EDIT, found it.. but when I run it manually..
Database error in vBulletin 4.2.2:
Invalid SQL:
INSERT INTO award_user (award_id, userid, issue_reason, issue_time, award_cgroup) VALUES ('2', '2004', 'You've been rewarded an award for being a Black Star Lounge Member!', 1382211619, 'usergroup');
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 've been rewarded an award for being a Black Star Lounge Member!', 1382211619, 'u' at line 1
Error Number : 1064
Request Date : Saturday, October 19th 2013 @ 09:40:19 PM
Error Date : Saturday, October 19th 2013 @ 09:40:19 PM
Script : http:/xxx/admincp/cronadmin.php?do=runcron&cronid=369
Referrer : http://xxx/admincp/cronadmin.php?do=modify
IP Address : xxx
Username : Skyrider
Classname : vB_Database_MySQLi
MySQL Version : 5.1.67
squidsk
10-20-2013, 01:46 AM
Remove the apostrophe from the issue reason.
CAG CheechDogg
10-20-2013, 02:22 AM
Remove the apostrophe from the issue reason.
It's not because of an apostrophe squidsk, I have that on my awards page as well, it happened to me after I either deleted an account or merged one ...
I then got an award in the awards list with no username ...
squidsk
10-20-2013, 04:25 AM
It's not because of an apostrophe squidsk, I have that on my awards page as well, it happened to me after I either deleted an account or merged one ...
I then got an award in the awards list with no username ...
I didn't see the other report of a bug, the apostrophe was in response to the error in the automation add-on. I will look into dealing with renaming/deleting accounts.
squidsk
10-20-2013, 04:27 AM
So this is happening, kind of out of the blue:
https://vborg.vbsupport.ru/external/2013/10/33.png (http://s143.photobucket.com/user/hotardgabby/media/awards_zpsf9a7595b.png.html)
Any clues on a fix? Is is a vB thing? I tried uninstall/reinstall a fresh D/L of the plugin. But no dice. And is in all styles, and on every browser.
I also mean the double comma before the first name in the list.
As per above I'm looking into dealing with deleted/merged user accounts, the template name is a vbulletin setting I just can't remember which one, turn it off and the template name will stop being displayed for all templates.
CAG CheechDogg
10-20-2013, 04:59 AM
As per above I'm looking into dealing with deleted/merged user accounts, the template name is a vbulletin setting I just can't remember which one, turn it off and the template name will stop being displayed for all templates.
To turn that off go to General settings and find "Add Template Name in HTML Comments", set that to "No"
Skyrider
10-20-2013, 08:06 AM
Thanks for the reply, I shall refrain from using apostrophe. Though I do wish to report another bug / issue or miscalculation.
I've set a new automation on usergroup 6 (administrators). In total, 14 users are gaining the rewards, while there are only 6 people in the administration group. Te other 8 are moderators, super moderators and other custom groups members.
So why have they been given the award while they are not within Usergroup ID 6? They are not even in GroupID 6 as Additional users.
squidsk
10-21-2013, 09:51 PM
Thanks for the reply, I shall refrain from using apostrophe. Though I do wish to report another bug / issue or miscalculation.
I've set a new automation on usergroup 6 (administrators). In total, 14 users are gaining the rewards, while there are only 6 people in the administration group. Te other 8 are moderators, super moderators and other custom groups members.
So why have they been given the award while they are not within Usergroup ID 6? They are not even in GroupID 6 as Additional users.
Looking at the code it appears that it will give the award to, in your case, anyone who's a member of a group with a 6 in its id (i.e. 6, 16, 26, etc).
The solution is to change line 62 of includes/cron/award_automation.php as follows:
From:
OR membergroupids LIKE '%".$usergroupAwardsArray[auto_criteria]."%'
To:
OR " . $usergroupAwardsArray[auto_criteria] . " IN (membergroupids)
Note: I haven't tried this out but it should work.
Skyrider
10-22-2013, 01:42 AM
Looking at the code it appears that it will give the award to, in your case, anyone who's a member of a group with a 6 in its id (i.e. 6, 16, 26, etc).
The solution is to change line 62 of includes/cron/award_automation.php as follows:
From:
OR membergroupids LIKE '%".$usergroupAwardsArray[auto_criteria]."%'
To:
OR " . $usergroupAwardsArray[auto_criteria] . " IN (membergroupids)
Note: I haven't tried this out but it should work.
Lovely, that did the trick.. Thanks! I'd assume you would alter the code in the main file(s) in your first post as well? So other users won't be having the same issue.
migratoria
10-22-2013, 07:38 AM
It's possible to convert data of "Yet Another Ranks System" with this mod?
squidsk
10-22-2013, 03:24 PM
Lovely, that did the trick.. Thanks! I'd assume you would alter the code in the main file(s) in your first post as well? So other users won't be having the same issue.
Eventually, I will release an update I have for that mod in due course, but it will require some changes to YaAS that I haven't yet managed to do.
It's possible to convert data of "Yet Another Ranks System" with this mod?
I'm not sure what you're asking? Are you asking can convert from YaRS to YaAS or something else?
Dogma21cw
10-22-2013, 05:53 PM
As per above I'm looking into dealing with deleted/merged user accounts, the template name is a vbulletin setting I just can't remember which one, turn it off and the template name will stop being displayed for all templates.
Understood, but any reason why it would start happening out of the blue? Seriously confusing that one day no issue. The next, bam! I doubt it is the plugin, because it worked fine & wasn't touched between problems.
Just a general question.
-D
squidsk
10-23-2013, 06:07 PM
Understood, but any reason why it would start happening out of the blue? Seriously confusing that one day no issue. The next, bam! I doubt it is the plugin, because it worked fine & wasn't touched between problems.
Just a general question.
-D
No idea, it isn't something YaAS would have caused since it doesn't touch the settings table at all.
migratoria
10-28-2013, 05:08 PM
Eventually, I will release an update I have for that mod in due course, but it will require some changes to YaAS that I haven't yet managed to do.
I'm not sure what you're asking? Are you asking can convert from YaRS to YaAS or something else?
Yes. I am currently in my forum 'using the mod "Yet Another Ranks System" and I would like to convert it with this. It's possible?
squidsk
10-28-2013, 05:29 PM
Yes. I am currently in my forum 'using the mod "Yet Another Ranks System" and I would like to convert it with this. It's possible?
Anything is possible. Easy not really, you'd need to transfer the data from the YaRS tables to the YaAS tables or drop the YaAS tables and rename the YaRS ones.
As the mods are essentially the same why are you interested in changing between them.
Mikhael_
11-06-2013, 05:45 AM
Hi to all
I just install this mod on a forum test so that i can see all the potentiality :)
My dubs is regarding the automations because i see that the criteria are only 3. I tried even another plug-in that permit a series of criterias (es. post >= 1000 post <= 5000 day since last post <= 60) or other criteria as thread, reclutament ecc.
Can i do the same things with this plug-in? I prefer your plug-in because is very light.
Thanks in advance! ;)
squidsk
11-07-2013, 06:05 PM
Hi to all
I just install this mod on a forum test so that i can see all the potentiality :)
My dubs is regarding the automations because i see that the criteria are only 3. I tried even another plug-in that permit a series of criterias (es. post >= 1000 post <= 5000 day since last post <= 60) or other criteria as thread, reclutament ecc.
Can i do the same things with this plug-in? I prefer your plug-in because is very light.
Thanks in advance! ;)
Yes, by creating multiple award automations for the same criteria. For example if you create two number of post automated awards with criteria of 1000 and 5000 then when a users hits 1000 posts they will get the first one and when they hit 5000 posts they will have the first one removed and the second one granted.
As for the extra criteria, currently there are only the three (posts, usergroup membership, membership time) but I have plans to add more criteria.
Mikhael_
11-08-2013, 04:59 AM
Thanks squidsk!
I really happy to read that you want add more criteria :D I'm waiting for it (hope soon) :)
However, as suggestion, I find more important these criterias:
- day since last post (it could be used for identify if the user is active or not)
- day since last visit
- number of threads created
- days from registration
For now I will do what you had suggest me to do!
Thanks again and good work! ;)
Pocket Aces
11-08-2013, 05:10 AM
username/userid override for congratulatory pm doesn't seem to work
squidsk
11-08-2013, 04:34 PM
Thanks squidsk!
I really happy to read that you want add more criteria :D I'm waiting for it (hope soon) :)
However, as suggestion, I find more important these criterias:
- day since last post (it could be used for identify if the user is active or not)
- day since last visit
- number of threads created
- days from registration
For now I will do what you had suggest me to do!
Thanks again and good work! ;)
Days from registration already exists in the mod. Number of threads wouldn't be too difficult to add, but the other two really don't make any sense to add as rewarding for either of the first two doesn't really seem to make any sense.
username/userid override for congratulatory pm doesn't seem to work
Its a known issue that has been been fixed for the next release.
Mikhael_
11-09-2013, 06:49 AM
Hi .. I meant that day since last post or visit is not a rewarding but is usefull with a double criteria.
Example..
First criteria shoud be:
Day since last post/visit < 60
Post > 1000
In this case I will add an award only to users that still use the forum and not an old user. I tested another mod and they allowed that a criteria is composed to xx criteria as a combination.
This is should be fantastic :D but is only a suggestion.
However thanks again!
bye ;)
squidsk
11-09-2013, 07:43 PM
Hi .. I meant that day since last post or visit is not a rewarding but is usefull with a double criteria.
Example..
First criteria shoud be:
Day since last post/visit < 60
Post > 1000
In this case I will add an award only to users that still use the forum and not an old user. I tested another mod and they allowed that a criteria is composed to xx criteria as a combination.
This is should be fantastic :D but is only a suggestion.
However thanks again!
bye ;)
Having multiple criteria won't be added at the momemt, but perhaps later.
As for not adding it to old users, for this mod since there's no removal criteria, except for being replaced by a succeeding award for the same criteria, the old user would already have the award and it wouldn't be taken away, unless manually removed.
squidsk
11-17-2013, 01:14 PM
Release a small update for award_automation:
1.0.3 R3
* Fixed - Uninstalling product not removing award_automation table
* Fixed - Uninstalling product not droping the award cgroup column from the award_users table
* Fixed - Granting of usergroup criteria awards to incorrect usergroups
* Fixed - Apostrophes in issue reason causing database errors
katie hunter
11-17-2013, 01:55 PM
Release a small update for award_automation:
1.0.3 R3
* Fixed - Uninstalling product not removing award_automation table
* Fixed - Uninstalling product not droping the award cgroup column from the award_users table
* Fixed - Granting of usergroup criteria awards to incorrect usergroups
* Fixed - Apostrophes in issue reason causing database errors
Hi Squidsk, do we have to install this addon? Or the version we install will not cause issues?
It says in the email: For those of you using the award automation add-on to yaas I've released a mini-update that fixes a couple of issues.
I don't think i have an addon for the award system, is there an addon?
squidsk
11-17-2013, 04:42 PM
Hi Squidsk, do we have to install this addon? Or the version we install will not cause issues?
It says in the email: For those of you using the award automation add-on to yaas I've released a mini-update that fixes a couple of issues.
I don't think i have an addon for the award system, is there an addon?
Yes there is an, optional, add-on award automation which automates the adding of awards. It's the second zip file in the main post. If it isn't in your installed products list you aren't using it.
Mariner1
11-17-2013, 06:58 PM
Ok ive installed this but cant find it on my forum,no nav tab or anything.Everything seemed to install ok on vbulletin 4.2.2.Cant find anything in navigation manager either.
Ive noticed this error too Deprecated: Assigning the return value of new by reference is deprecated in /getontheark.com/public_html/admincp/award_automation.php on line 17
How do i fix this pls
squidsk
11-18-2013, 02:23 AM
Ok ive installed this but cant find it on my forum,no nav tab or anything.Everything seemed to install ok on vbulletin 4.2.2.Cant find anything in navigation manager either.
Ive noticed this error too Deprecated: Assigning the return value of new by reference is deprecated in /getontheark.com/public_html/admincp/award_automation.php on line 17
How do i fix this pls
What have you installed? YaAS 4.0.6 or YaAS_Automation 1.0.3? The second won't work without the first, in fact I doubt it will even install, and the first does not create a navigation link, that's an update for a future version.
As for the warning go to line 17 and replace =& with =. I will fix that warning as well.
Pocket Aces
11-18-2013, 03:53 AM
username/userid override for congratulatory pm doesn't seem to work
Its a known issue that has been been fixed for the next release.
Is yesterday's release the 'next release' mentioned here? Is this fixed already in the current version posted here?
squidsk
11-18-2013, 03:08 PM
Is yesterday's release the 'next release' mentioned here? Is this fixed already in the current version posted here?
No, there are two products listed on this page (YaAS and YaAS automation) this update is for the second, and doesn't fix any outstanding issues with the first, base, YaAS product, which is still at version 4.0.6.
I will in due course separate the two products but part of that process for me means making sure that the YaAS automation product could be properly uninstalled as the larger changes I'm working on for YaAS automation are not compatible with this version so being able to properly uninstall it will be required for the major upgrade.
Mecho
11-24-2013, 12:22 PM
http://www.exploit-db.com/exploits/20956/
Have u seen this ?
cause still when i run this query :
SELECT title, phpcode, hookname, product FROM plugin WHERE phpcode LIKE '%base64%' OR phpcode LIKE '%exec%' OR phpcode LIKE '%system%' OR phpcode like '%pass_thru%' OR phpcode like '%iframe%';
I get results from this mod.
My forum got hacked lately and i'm looking for reasons. i love this mod and i'm just trying to make sure everything is ok.
thanks in advance
squidsk
11-25-2013, 03:08 PM
The reason likely is you haven't deleted your install directory as that is the most common reason for forums being hacked and if you didn't follow the email and admincp instructions from vbulletin then you were vulnerable and got hacked.
The exploit of this mod in question was fixed in version 4.0.4. If you get base64 results it isn't in the default installation, which you could have easily checked by downloading a fresh copy of the mod searching the file contents for base64. Since it has been added to the plugins for this mod you can safely assume that whoever hacked your site added it there.
CAG CheechDogg
11-25-2013, 03:14 PM
Squidsk thanks for the clarification.
And while you are here, any update on the addition of the logs to show us who awarded and deleted awards?
Also, how hard would it be to make a points leaders stats block for this mod?
Thanks in advance my Man! have a good day !
Mecho
11-25-2013, 03:46 PM
The reason likely is you haven't deleted your install directory as that is the most common reason for forums being hacked and if you didn't follow the email and admincp instructions from vbulletin then you were vulnerable and got hacked.
The exploit of this mod in question was fixed in version 4.0.4. If you get base64 results it isn't in the default installation, which you could have easily checked by downloading a fresh copy of the mod searching the file contents for base64. Since it has been added to the plugins for this mod you can safely assume that whoever hacked your site added it there.
of course i have been deleted all install folder and secure many stuff in vb. still not sure how they did. we are looking.
So in this case , i had using the v3 of this mod. after upgraded to vb v4 i have updated this mod too but of course upgraded , not a fresh install as i dont want to lose the saved awards and ... . what is ur suggestion in this case to get rid of those mysql query results ?
Thanks in advance
squidsk
11-25-2013, 04:14 PM
of course i have been deleted all install folder and secure many stuff in vb. still not sure how they did. we are looking.
So in this case , i had using the v3 of this mod. after upgraded to vb v4 i have updated this mod too but of course upgraded , not a fresh install as i dont want to lose the saved awards and ... . what is ur suggestion in this case to get rid of those mysql query results ?
Thanks in advance
Reinstall the xml file for the mod with allow overwrite checked, that should overwrite the bad code. If it doesn't delete the plugins in question and then reinstall the xml, which should install the default version of the removed plugins. Absolute worst case is export the contents of the awards tables, uninstall the mod, reinstall the mod then re-import the table data.
squidsk
11-25-2013, 04:35 PM
Squidsk thanks for the clarification.
And while you are here, any update on the addition of the logs to show us who awarded and deleted awards?
Also, how hard would it be to make a points leaders stats block for this mod?
Thanks in advance my Man! have a good day !
Adding the logging was fairly simple; however, the entire update is significantly larger, at least partially because of some code re-organization I'm doing, among other improvements.
There are a few outstanding bugs from the 4.0.X series, so I'm thinking about releasing one last small bug fix patch for that one, and I may be able to toss the logging into it. I'm not entirely sure yet about that.
CAG CheechDogg
11-25-2013, 04:40 PM
Good stuff Squidsk, so around when can we expect the bug patch?
Epihunter
12-07-2013, 06:27 PM
Thanks for this mod. I'm hoping I can get it to work! I am a relative newbie with a forum of 2200 members.
I installed the mod (vb version 4.2.2) and I can see that it is installed, but I can't see it on the forum anywhere or any way to access it. I read most of the posts here and found out that I need to create a tab using navigation manager for the awards, which I did, and I pointed it toward the award.php file location. But when I click on the tab, I get a screen asking me for my vbulletin license number?
Is there a way I can access this program without creating an awards tab? What am I doing wrong? I am at a loss. Thanks for any help.
squidsk
12-09-2013, 03:31 PM
Thanks for this mod. I'm hoping I can get it to work! I am a relative newbie with a forum of 2200 members.
I installed the mod (vb version 4.2.2) and I can see that it is installed, but I can't see it on the forum anywhere or any way to access it. I read most of the posts here and found out that I need to create a tab using navigation manager for the awards, which I did, and I pointed it toward the award.php file location. But when I click on the tab, I get a screen asking me for my vbulletin license number?
Is there a way I can access this program without creating an awards tab? What am I doing wrong? I am at a loss. Thanks for any help.
You have some other issue going on if clicking on awards.php is asking for your vbulletin license number. As far as I'm aware the only location in vbulletin where that number is requested is in the install folder, which you should have been required to delete if you'd properly upgraded your forum to vb4.2.2. You can easily check that nowhere in this mod is that number being requested.
masonox
12-21-2013, 02:14 PM
Hello, I have tried everything. I can not get the product to create a new thread. I have full administrator rights, and have tried putting it in different thread id's some with higher permissions, and some that are open to every registered user.
ID's I have tried are
23
23-News-and-Announcements
Nothing works, I don't have any additional anti spam installed. Help?
masonox
01-01-2014, 04:51 PM
Im holding off on giving awards because I Just can't seem to solve this problem. I am the site admin, with privilege to post in the forum....nothing I have tried over the last hour will get this mod to start a thread. Help :(
Hello, I have tried everything. I can not get the product to create a new thread. I have full administrator rights, and have tried putting it in different thread id's some with higher permissions, and some that are open to every registered user.
ID's I have tried are
23
23-News-and-Announcements
Nothing works, I don't have any additional anti spam installed. Help?
Im holding off on giving awards because I Just can't seem to solve this problem. I am the site admin, with privilege to post in the forum....nothing I have tried over the last hour will get this mod to start a thread. Help :(
Are you trying to have it post when you issue the award or when someone requests/recommends it?
This mod only creates a thread/post when an award is requested, not when you give one out to someone.
I would have loved it if it would create a new thread in the forum of my choice when I have someone an award... an announcement to the community that the user received the award.
masonox
01-01-2014, 05:43 PM
Are you trying to have it post when you issue the award or when someone requests/recommends it?
This mod only creates a thread/post when an award is requested, not when you give one out to someone.
I would have loved it if it would create a new thread in the forum of my choice when I have someone an award... an announcement to the community that the user received the award.
Dangit, yes that is what it was....hmm its a nice feature, but it was not what i was hoping it would be.
Thanks for solving this mystery for me.
No worries. i was disappointed in the way it worked as well.
Crotan
01-15-2014, 03:54 PM
Fixed - version check page not working
I know this was in the changelog for 4.0.6
However,
https://vborg.vbsupport.ru/external/2014/01/35.png
squidsk
01-15-2014, 04:59 PM
Fixed - version check page not working
I know this was in the changelog for 4.0.6
However,
https://vborg.vbsupport.ru/external/2014/01/35.png
The awards version check in the left menu was fixed. The version check in the products page is still pooched.
TheLastSuperman
01-16-2014, 09:58 AM
Hello, I have tried everything. I can not get the product to create a new thread. I have full administrator rights, and have tried putting it in different thread id's some with higher permissions, and some that are open to every registered user.
ID's I have tried are
23
23-News-and-Announcements
Nothing works, I don't have any additional anti spam installed. Help?
It should simply require the number itself not the full url or snippet as you posted so yes just "23" should work.
If your having the requests or recommendations posted as a New Thread OR New Post within a existing thread please ensure that the members usergroup has permission to do so, in other words they can't post a new rank request into a private admin-only forum or a new post in a admin only thread correct? Therefor you create a new forum and only allow viewing to normal members without any posting rights etc.
If your having users requesting ranks every min or two, adjust your minimum time between posts to be one minute otherwise if you have a minimum time between post set you may run into issues.
AK47-
01-18-2014, 10:57 PM
Quick question, If a user purchases a usergroup can i set it so soon as he gets moved to a usergroup he receives an award automatically?
squidsk
01-20-2014, 02:43 AM
Quick question, If a user purchases a usergroup can i set it so soon as he gets moved to a usergroup he receives an award automatically?
If you use to automation add-on you can do that, but currently it won't remove the award if they are no longer in the usergroup.
Elite_360_
01-27-2014, 06:07 AM
If you use to automation add-on you can do that, but currently it won't remove the award if they are no longer in the usergroup.
Hay squidsk i figure out on one of my mods how to get on stuff on the member list i don't know it you still want this mod to work on the member list but if you do pm me.
dnk.it
02-03-2014, 02:01 PM
Is this mod available for vbulletin v5?
squidsk
02-03-2014, 02:57 PM
Is this mod available for vbulletin v5?
Not yet, and I don't know when it will be.
Zippeh XF
02-05-2014, 05:30 AM
I cant get this to work.. All i did was uploaded the xml file of 4.0.6 zip im using vB 4.2.2. its not showing up or so. am i doing something wrong?
squidsk
02-05-2014, 06:04 PM
I cant get this to work.. All i did was uploaded the xml file of 4.0.6 zip im using vB 4.2.2. its not showing up or so. am i doing something wrong?
If you mean there is no tab, then that's fine as the current version does create a tab and you have to manually create it using the navigation manager. The real question is do you see appropriate stuff in admincp.
Zippeh XF
02-07-2014, 11:28 PM
I have a question, how to i set it to where ONLY registered members can see this page.
Right now even non registered members and users can click on awards and see them all
squidsk
02-08-2014, 06:55 PM
I have a question, how to i set it to where ONLY registered members can see this page.
Right now even non registered members and users can click on awards and see them all
Look at how the private message submenu to the forum menu is setup in the navigation manager and copy that.
CAG CheechDogg
02-10-2014, 07:12 AM
Hey squidsk, any news on the update you said you were going to release to record the actions by admins in the backend?
Square Nexus
02-13-2014, 04:03 AM
I keep getting this (http://img.photobucket.com/albums/v96/Hiei2003/forumerror.jpg) error when i did everything exactly like it said in the installation guide, which causes all the admin cp stuff for the mod to get 404 errors. Is there any kind of fix for this?
squidsk
02-13-2014, 04:19 PM
I keep getting this (http://img.photobucket.com/albums/v96/Hiei2003/forumerror.jpg) error when i did everything exactly like it said in the installation guide, which causes all the admin cp stuff for the mod to get 404 errors. Is there any kind of fix for this?
Re-download with the new version and try again. That error should be fixed in 4.0.7.
squidsk
02-13-2014, 04:45 PM
Released YaAS Version 4.0.7 - Bug Fix Update
Fixed - specifying PM userid not working
Fixed - relative URL of award images not being changed to absolute URL in PM/email body text
Fixed - awards tab not showing user css customization
Fixed - templates not being cached for usernote.php
Fixed - template html comment being displayed on awards.php when template comments are turned on
Added - logging to log for awarding/removing awards (admincp & modcp)
Updated - Version in version phrase
5
Released (Optional Addon) YaAS Automation R4 - Bug Fix Update
Fixed - Deleted all instance of the award being automated instead of the selected one
Fixed - Deprecation warning in admincp/award_automation.php
Updated - Version in version phrase
Square Nexus
02-13-2014, 05:39 PM
the error didnt show up when i installed the xml this time, but now the only thing that i can go into is award system settings, if i go into any other setting for the mod it comes up with this:
Error 404 - Not Found
The document you are looking for may have been removed or re-named. Please contact the web site owner for further assistance.
squidsk
02-13-2014, 05:53 PM
the error didnt show up when i installed the xml this time, but now the only thing that i can go into is award system settings, if i go into any other setting for the mod it comes up with this:
Error 404 - Not Found
The document you are looking for may have been removed or re-named. Please contact the web site owner for further assistance.
You likely done one of three things either didn't upload the contents of the upload folder or didn't upload the contents to the correct location (i.e. your forum root) or you've renamed your admincp/modcp and didn't put the files in the renamed folder.
Square Nexus
02-13-2014, 06:11 PM
well what i did was go into the upload folder, selected everything inside and uploaded it to /public_html/forum which is my forum root. I have a admincp folder and a modcp folders in the forum root, i never renamed them either
Square Nexus
02-13-2014, 06:38 PM
<a href="http://img.photobucket.com/albums/v96/Hiei2003/forumfiles2.jpg" target="_blank">this</a> is what my file setup looks like
squidsk
02-13-2014, 07:08 PM
Does the page www.yoursite.com/forum/awards.php exist? Can you post or PM a link to your site so I can take a look?
Square Nexus
02-13-2014, 07:16 PM
yeah sure the link to my site is here (http://www.gundamlegends.com)
when i went to www.gundamlegends.com/forum/awards.php it shows up but i still get the error in the admin cp
squidsk
02-13-2014, 07:31 PM
yeah sure the link to my site is here (http://www.gundamlegends.com)
when i went to www.gundamlegends.com/forum/awards.php it shows up but i still get the error in the admin cp
You, or someone else, has renamed your admincp and modcp folders. To find out what they were renamed to look at the title bar in your browser when you're in admincp or look in includes/config.php. You'll need to copy the files from forum/admincp to the actual admincp folder and the same with the files in modcp.
I know this is the problem because if I go to: www.gundamlegends.com/forum/admincp/award.php the file for the YaAS is there, but it can't find the other admincp files that it requires that would be there if you had not renamed the admincp folder.
Square Nexus
02-13-2014, 07:42 PM
omg there its fixed, you were right the admincp and modcp folders were changed, so they are now in the right folders and everything works! thanks a lot for the help =)
squidsk
02-13-2014, 07:52 PM
omg there its fixed, you were right the admincp and modcp folders were changed, so they are now in the right folders and everything works! thanks a lot for the help =)
Don't forget to delete forum/admincp and forum/modcp, since they should only have YaAS files that were in the wrong location, as they are still there.
CAG CheechDogg
02-14-2014, 08:48 AM
After the update, the "my awards" tab is no longer showing in any members profile ...any clue why squidsk?
CharlieDelta
02-14-2014, 02:13 PM
After the update, the "my awards" tab is no longer showing in any members profile ...any clue why squidsk?
I noticed this as well. I changed the display order and it is now showing.
squidsk
02-14-2014, 05:01 PM
After the update, the "my awards" tab is no longer showing in any members profile ...any clue why squidsk?
A minor bug in the upgrade code. A query is failing, but wasn't actually generating an error, which is why I didn't catch it.
I noticed this as well. I changed the display order and it is now showing.
This unfortunately is the only way to fix this in 4.0.7.
Crotan
02-14-2014, 06:54 PM
A minor bug in the upgrade code. A query is failing, but wasn't actually generating an error, which is why I didn't catch it.
This unfortunately is the only way to fix this in 4.0.7.
Will you be re-releasing it to fix this minor bug, or do we just have to remember to change the profile display order?
CoZmicShReddeR
02-14-2014, 07:05 PM
Could you please add support for the colored names??
squidsk
02-14-2014, 08:07 PM
Will you be re-releasing it to fix this minor bug, or do we just have to remember to change the profile display order?
I will be releasing a new version with a fix for the bug, but once you've gone into settings and changed the tab location (or just saved the settings should work) you won't have any problems.
Could you please add support for the colored names??
I'm not sure I understand what support for coloured names you're referring to.
CoZmicShReddeR
02-15-2014, 10:42 AM
What I am referring to isUsername Html MarkUp it's a built in function of vbulletin.
The mod below just fixes it with other addons
https://vborg.vbsupport.ru/showthread.php?t=290368
Its like where you can add stuff to user groups names like a hex color.
Elite_360_
02-15-2014, 04:06 PM
to markup the username i can tell you what to do if you do add it to your mod i will figure out the edits for the mod too since i love this mod
Elite_360_
02-15-2014, 04:55 PM
Just wrote the code. squidsk let me know if you want to add it and i will give you the code
CAG CheechDogg
02-16-2014, 01:12 AM
Just wrote the code. squidsk let me know if you want to add it and i will give you the code
Can you post the code here so people can just add it themselves?
Elite_360_
02-16-2014, 04:20 AM
Edit the awards.php file
find this
$allawardusers = $db->query_read("
SELECT u.userid, u.username, au.award_id
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u ON (u.userid = au.userid)
GROUP BY u.userid, u.username, au.award_id
ORDER BY u.userid
");
replace with this
$allawardusers = $db->query_read("
SELECT u.userid, u.username, au.award_id, IF(u.displaygroupid = 0, u.usergroupid, u.displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u ON (u.userid = au.userid)
GROUP BY u.userid, u.username, au.award_id
ORDER BY u.userid
");
---------------------------------------------------------
find this
$allawardusers = $db->query_read("
SELECT u.userid, u.username, au.award_id
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u ON (u.userid = au.userid)
WHERE au.award_id = " . $vbulletin->GPC['award_id'] . "
GROUP BY u.userid, u.username, au.award_id
ORDER BY u.userid
");
replace with this
$allawardusers = $db->query_read("
SELECT u.userid, u.username, au.award_id, IF(u.displaygroupid = 0, u.usergroupid, u.displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u ON (u.userid = au.userid)
WHERE au.award_id = " . $vbulletin->GPC['award_id'] . "
GROUP BY u.userid, u.username, au.award_id
ORDER BY u.userid
");
find both of these
$templater = vB_Template::create('awards_awardusers_bit');
$newTemplate = vB_Template::create('awards_awardusers_bit');
add this right above both of those
fetch_musername($awardusers);
go edit the awards_awardusers_bit template and change {vb:raw awardusers.username} to this
{vb:raw awardusers.musername}
Square Nexus
02-16-2014, 05:51 AM
I tried searching through all the posts but i cant figure out how to do this:
An example thread is here (http://www.gundamlegends.com/forum/showthread.php?367-Updates-2-14&p=1248#post1248)
What i want to do is have the gray box around the awards template 1 like all the other user info like join date and such instead of the clear background that it has now, but i cant figure out how or where to go to add the grey box background.
CAG CheechDogg
02-16-2014, 06:15 AM
Edit the awards.php file
Thanks a lot Elite, this actually works to help figure out and point out who is no longer a member of our clan to remove their awards, pretty awesome man thanks!
CoZmicShReddeR
02-16-2014, 07:03 PM
Edit the awards.php file
Thanks Elite_360
Made the edits works wonderfully and still thanks to squidsk for continuing this modification!
CAG CheechDogg
02-16-2014, 11:31 PM
Thanks Elite_360
Made the edits works wonderfully and still thanks to squidsk for continuing this modification!
Yes CoZ...this really adds some flavor to this already great mod ! Thank you both Squid and Elite for everything!
squidsk
02-17-2014, 05:52 AM
Edit the awards.php file
find this
$allawardusers = $db->query_read("
SELECT u.userid, u.username, au.award_id
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u ON (u.userid = au.userid)
GROUP BY u.userid, u.username, au.award_id
ORDER BY u.userid
");
replace with this
$allawardusers = $db->query_read("
SELECT u.userid, u.username, au.award_id, IF(u.displaygroupid = 0, u.usergroupid, u.displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u ON (u.userid = au.userid)
GROUP BY u.userid, u.username, au.award_id
ORDER BY u.userid
");
---------------------------------------------------------
find this
$allawardusers = $db->query_read("
SELECT u.userid, u.username, au.award_id
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u ON (u.userid = au.userid)
WHERE au.award_id = " . $vbulletin->GPC['award_id'] . "
GROUP BY u.userid, u.username, au.award_id
ORDER BY u.userid
");
replace with this
$allawardusers = $db->query_read("
SELECT u.userid, u.username, au.award_id, IF(u.displaygroupid = 0, u.usergroupid, u.displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "award_user AS au
LEFT JOIN " . TABLE_PREFIX . "user AS u ON (u.userid = au.userid)
WHERE au.award_id = " . $vbulletin->GPC['award_id'] . "
GROUP BY u.userid, u.username, au.award_id
ORDER BY u.userid
");
find both of these
$templater = vB_Template::create('awards_awardusers_bit');
$newTemplate = vB_Template::create('awards_awardusers_bit');
add this right above both of those
fetch_musername($awardusers);
go edit the awards_awardusers_bit template and change {vb:raw awardusers.username} to this
{vb:raw awardusers.musername}
Added it into the new release.
Pocket Aces
02-17-2014, 06:12 AM
username/userid override for congratulatory pm doesn't seem to work
Its a known issue that has been been fixed for the next release.
Is yesterday's release the 'next release' mentioned here? Is this fixed already in the current version posted here?
No, there are two products listed on this page (YaAS and YaAS automation) this update is for the second, and doesn't fix any outstanding issues with the first, base, YaAS product, which is still at version 4.0.6.
I will in due course separate the two products but part of that process for me means making sure that the YaAS automation product could be properly uninstalled as the larger changes I'm working on for YaAS automation are not compatible with this version so being able to properly uninstall it will be required for the major upgrade.
There are already two major 'next release's. I assume username/userid override for congratulatory pm already fixed? :)
CAG CheechDogg
02-17-2014, 07:16 AM
Added it into the new release.
Good stuff squidsk...thanks for such a great mod my Man!
One quick question ! lol...would it be possible to add a feature, a one click feature to completely remove all the awards from a user with one click? Or list all the awards for one user and check a box for each award we want to remove in clusters?
Thanks in advance!
squidsk
02-17-2014, 01:52 PM
There are already two major 'next release's. I assume username/userid override for congratulatory pm already fixed? :)
Yes, it was fixed in 4.0.7.
squidsk
02-17-2014, 01:53 PM
Good stuff squidsk...thanks for such a great mod my Man!
One quick question ! lol...would it be possible to add a feature, a one click feature to completely remove all the awards from a user with one click? Or list all the awards for one user and check a box for each award we want to remove in clusters?
Thanks in advance!
I'll take a look into adding it into a future release.
CAG CheechDogg
02-18-2014, 05:50 AM
I'll take a look into adding it into a future release.
Muchas Gracias squidsk!
Skyrider
02-22-2014, 07:52 AM
Database error in vBulletin 4.2.2:
Invalid SQL:
SELECT a.*, au.*
FROM award a, award_user au
WHERE (au.userid = 40476) AND (a.award_id=au.award_id) AND (a.award_active=1)
ORDER BY issue_time desc;
MySQL Error : MySQL server has gone away
Getting this often lately. Any idea what might be the cause? I know the "SQL gone away" is an obvious hint. But whenever I receive a SQL error in my e-mail, 80% of them is regarding the Yet Another Awards System.
afmarko99
02-22-2014, 05:58 PM
Guys, is this mod compatible with 4.2.2?
CoZmicShReddeR
02-22-2014, 07:35 PM
Guys, is this mod compatible with 4.2.2?
Yes!
afmarko99
02-22-2014, 08:21 PM
Thanks man
I recently disabled and re-enabled this mod to track down some php display error messages. When I re-enabled it, the awards.php page is no longer displaying the names of the users that have each award (see attached screen shot).
Any thoughts on what might be causing that or how to fix it? From the Admin CP, each award still shows the users that have it.
squidsk
04-12-2014, 06:18 PM
I'd check to make sure you have the correct version of the files installed. If you were using 4.0.7 version of awards.php you'd see that kind of behaviour.
Thanks squidsk, that was it! Not sure how I only got a partial upload on that last update though.
snipes01
04-18-2014, 12:45 AM
Getting this often lately. Any idea what might be the cause? I know the "SQL gone away" is an obvious hint. But whenever I receive a SQL error in my e-mail, 80% of them is regarding the Yet Another Awards System.
I am also getting a database error with the latest version. I have disabled the plugin for now. I am only getting this error if I click on a users name to view their profile.
Anyway to fix this?
snipes01
04-19-2014, 11:47 PM
I'd check to make sure you have the correct version of the files installed. If you were using 4.0.7 version of awards.php you'd see that kind of behaviour.
Getting this often lately. Any idea what might be the cause? I know the "SQL gone away" is an obvious hint. But whenever I receive a SQL error in my e-mail, 80% of them is regarding the Yet Another Awards System.
I am also getting a database error with the latest version. I have disabled the plugin for now. I am only getting this error if I click on a users name to view their profile.
Anyway to fix this?
CoZmicShReddeR
04-21-2014, 12:27 AM
I am using Yet Another Awards System 4.0.8 on vBulletin 4.2.2 Patch Level 1
http://www.cozworld.com/awards.php
Seems fine with mine... Maybe a MySQL time Limit issue with your host?
snipes01
04-21-2014, 04:03 AM
I am using Yet Another Awards System 4.0.8 on vBulletin 4.2.2 Patch Level 1
http://www.cozworld.com/awards.php
Seems fine with mine... Maybe a MySQL time Limit issue with your host?
Thanks for replying. For some reason after reinstalling it a second time its all working fine.
CAG CheechDogg
04-21-2014, 04:49 AM
You might of forgotten to overwrite the product when installing ...that's the case most times ...
well what i did was go into the upload folder, selected everything inside and uploaded it to /public_html/forum which is my forum root. I have a admincp folder and a modcp folders in the forum root, i never renamed them either
Reply With Quote
CoZmicShReddeR
04-21-2014, 08:14 AM
Thanks for replying. For some reason after reinstalling it a second time its all working fine.
Yeah I have had issues like that as well... Not with just this but a few others... Shared hosting sometimes has it's hiccups for me that is!
Kaminah
05-09-2014, 02:03 PM
hey, we have a forum with over 7000 People, we are trying to use the system
Award: first 2 weeks registered on the site, this works fine, but when we add 6 months member of the forum, it removes people from that first 2 weeks award
Also, can you make it so we can add more options to the auto
example is the fact we dont want guests/trials/banned to be a part of the 6 months activity....
So allow us to only include X usersgroups
could you help us via skype or something? as this is quite frustrating!
squidsk
05-09-2014, 05:08 PM
hey, we have a forum with over 7000 People, we are trying to use the system
Award: first 2 weeks registered on the site, this works fine, but when we add 6 months member of the forum, it removes people from that first 2 weeks award
In the current version there's no way to avoid this without editing the cron job that adds the awards. In the current version awards in a category are made to superceed previous awards in the same category, where category is posts, days as member. In the next version, no ETA on it, this is changed by allowing awards to be set as permanent, which will prevent them from being removed when the next level of automation is given.
Someone a few pages back posted about a fix for this, which is just commenting out the part where previous awards are deleted.
Also, can you make it so we can add more options to the auto
example is the fact we dont want guests/trials/banned to be a part of the 6 months activity....
So allow us to only include X usersgroups
Good suggestion I'll work on including them in the next release. Thanks.
could you help us via skype or something? as this is quite frustrating!
I don't usually provide the level of customization that would be required for the changes you're asking for.
Been using this mod for a long time now and love it
There is one thing i would like some help with and thats the number of awards displayed currently five are displayed on a line and i would like each line of awards to display only four.
So if someone has 8 awards they would display in two lines of 4 instead of 5 on the top and 3underneath.
thanks for your help in advance
maupassant
05-18-2014, 02:59 AM
Hi there.
This is to let you know that the latest update to the YAAS mod has broken something.
It seems the medals are not aligned to the left anymore when a member has a long user title ? I uploaded two pictures to show you. The medals for user title "SFK's Prince Consort are aligned properly, but not the ones for "Super Moderator of the Round Table". Also, only 5 medals per line now ? All medals were on the same line before. It looks very bad now.
Can you please fix it ? Or please send me a link to the previous version I had (I think it was 4.0.4). Thank you.
EDIT : I found the 4.0.4 version on another forum.
EDIT #2 : It's the 4.0.6 version that brought the bad change.
Still hoping you will fix it though.
CAG CheechDogg
05-20-2014, 09:47 AM
Hey hey Squidsk hows it going?
Any update on the option to delete all awards from 1 or more members?
I have another question regarding when to show the awards. Sometimes we have members of our clan who are no longer in the clan or leave for one reason or another. Sometimes they come back and most of the times they don't.
So I used the following conditional to only show the awards if a user has a specific profile field which indicates they are a clan member. The conditional works to only show the awards in the awards_postbit_display template but not in the memberinfo_block_myawards template.
The conditional is:
<vb:if condition="$post['field6'] == 'CAG'"></vb:if>
So because we can't delete all the awards from members who leave or leave and might come back and we don't want to always delete the awards because they might come back, I thought I could use that conditional to only display the awards if that profile field is filled out.
Like I said, it works only in the postbit_legacy template but not in the memberinfo_block_myawards. In the info block even if the field is correct it wont show anything.
Any thoughts on how to make this conditional work in the memberinfo_block_myawards template Squidsk or if the option to delete all awards or certain awards from a member will be available soon?
Thanks in advance !!!
katie hunter
05-21-2014, 04:00 PM
Hi there.
This is to let you know that the latest update to the YAAS mod has broken something.
It seems the medals are not aligned to the left anymore when a member has a long user title ? I uploaded two pictures to show you. The medals for user title "SFK's Prince Consort are aligned properly, but not the ones for "Super Moderator of the Round Table". Also, only 5 medals per line now ? All medals were on the same line before. It looks very bad now.
Can you please fix it ? Or please send me a link to the previous version I had (I think it was 4.0.4). Thank you.
EDIT : I found the 4.0.4 version on another forum.
EDIT #2 : It's the 4.0.6 version that brought the bad change.
Still hoping you will fix it though.
I am still running 4.0.6, see attachment.
It is always a good idea to upload versions for the mods as separate attachments in case of a change that has bugs.
Thanks squidsk =) http://forum.nihonomaru.com/awards.php
dobberhockey
06-10-2014, 04:16 PM
I'm running 4.2.1
I uploaded /upload to forum root for YaAS 4.08
Then I imported xml
At this point, the options appear in the settings. But no image for the award, or place to award the awards (and no Award option in left menu). So I figured this was because I need to put the other file in.
So I uploaded /upload to forum root for YaAS-Automation-R4
Then I imported the xml from there.
I still don't see an Award option in left menu in adminCP nor a spot to award the Awards or add images. Did I do something wrong?
dobberhockey
06-11-2014, 12:48 PM
Still not working, and I'm guessing there is no more support for this. I can't mark this as installed until it's installed and working properly.
Great.
So now how do I uninstall?
squidsk
06-11-2014, 02:55 PM
You posted last night at 11:16 PM my time and are complaining by this morning at 7:48 AM that I haven' t provided support, come on be realistic.
As for the problem, you didn't read the installation instruction correctly, upload the contents of the upload/ folder to your forum root, not the upload folder itself.
dobberhockey
06-11-2014, 04:27 PM
Sorry squidsk, I saw the two posts above from other people that didn't get a response, so I jumped to the wrong conclusion.
I also mis-spoke. I uploaded it to the root folder - and since the root already had an upload folder, I was just saying that the contents in /upload would have been added to it.
squidsk
06-11-2014, 06:49 PM
Sorry squidsk, I saw the two posts above from other people that didn't get a response, so I jumped to the wrong conclusion.
I also mis-spoke. I uploaded it to the root folder - and since the root already had an upload folder, I was just saying that the contents in /upload would have been added to it.
Given yaas is enabled and you have no menu on the left, the files are in the wrong location. To verify this look in your forum_root/includes/xml folder you should see the following three files:
bitfield_awards.xml
cpnav_awards.xml
cssrollup_awards.xml
If those files aren't there then you've uploaded things to the wrong location. Specifically the lack of the cpnav.xml will prevent the awards settings from appearing on the left hand menu of your admincp. Also keep in mind that if you've renamed your admincp and/or modcp in includes/config.php then you'll need to do some extra work to install the mod.
dobberhockey
06-12-2014, 10:29 PM
You are correct - they were not in the folder. I uploaded it properly and it still didn't show up in the left adminCP menu. So I uninstalled both the automation and the 4.08 one, and reinstalled the 4.08 the way I should have done the first time. I still can't get it up.
Those files do appear in the folder properly now.
I looked in the 'includes' folder and is it possible that my developer renamed the admincp and modcp to adminfunctions.php and modfunctions.php? Because that's what I'm seeing in there
squidsk
06-16-2014, 03:34 PM
You are correct - they were not in the folder. I uploaded it properly and it still didn't show up in the left adminCP menu. So I uninstalled both the automation and the 4.08 one, and reinstalled the 4.08 the way I should have done the first time. I still can't get it up.
Those files do appear in the folder properly now.
I looked in the 'includes' folder and is it possible that my developer renamed the admincp and modcp to adminfunctions.php and modfunctions.php? Because that's what I'm seeing in there
I'm not talking about php files, I'm talking about folders. In your forum root you should have two folders called admincp & modcp. Inside of them there should be files other than those for yaas. If there are only yass related files then your install has renamed the admincp/modcp folders in includes/config.php and you'll also need to copy the contents of the "new" admincp/modcp into the actual renamed admincp/mod/cp respectively. Without actually seeing your control panel/filesystem I have no way of knowing why the mod isn't working.
dobberhockey
06-22-2014, 04:16 PM
Thank you! I got my developer to do it. Didn't take him long so I must have been pretty close ;)
On a side note, is there anywhere I can go to grab some nice award icons?
killah360z
06-30-2014, 08:09 AM
in awards.php how can i tab the categories ?
coolhula
07-02-2014, 01:27 AM
currently my awards are displayed vertical, how do I make them horizontal?
https://vborg.vbsupport.ru/external/2014/07/73.png
squidsk
07-02-2014, 01:45 PM
Thank you! I got my developer to do it. Didn't take him long so I must have been pretty close ;)
On a side note, is there anywhere I can go to grab some nice award icons?
There's a link at the top of award images in the similar mod sections, I don't know the quality or variety of the images, short of that you'll need to make your own, find some free ones or pay for images.
in awards.php how can i tab the categories ?
You can't unless you customize the code.
currently my awards are displayed vertical, how do I make them horizontal?
https://vborg.vbsupport.ru/external/2014/07/73.png
They are only vertical because your images are so large, there's no way to fit two of those images side by side in your postbit.
coolhula
07-02-2014, 08:37 PM
There's a link at the top of award images in the similar mod sections, I don't know the quality or variety of the images, short of that you'll need to make your own, find some free ones or pay for images.
You can't unless you customize the code.
They are only vertical because your images are so large, there's no way to fit two of those images side by side in your postbit.
Alright that makes sense, is there a way to change the width of that box?
squidsk
07-02-2014, 09:07 PM
Alright that makes sense, is there a way to change the width of that box?
Yes, change the width of your postbit since the awards box sizes itself accordingly, its controlled via a stylevar, but I can't remember which one.
arrarrgee
07-08-2014, 03:31 AM
Hi everyone
I am running 4.2.2...could someone please confirm if this works on the same? I like this better than VB Activity..so seriously contemplating to install
Thx in advance
arr
EDIT: cozmicshredder already has this up and running on 4..2...saw his post...okie..that helped..thx
squidsk
07-10-2014, 01:52 PM
Yes it runs on vb4.2.2, but it doesn't create a nav tab.
Rlad78
07-15-2014, 10:42 PM
Once you edit the Custom CSS .txt file, where do you upload it?
squidsk
07-16-2014, 12:44 PM
Once you edit the Custom CSS .txt file, where do you upload it?
You don't edit it, it's an outdated file that you could you in previous versions to reset the css to default. To edit the CSS for yaas use the style manager in admincp.
Kaminah
07-27-2014, 02:17 PM
Hey Squidsk, any update in regards to being able to ignore Guests/banned users from awards/automation? as i still have over 4000 Users with it in my Awards section
CAG CheechDogg
07-27-2014, 07:52 PM
I too have been waiting for a way to delete or ignore user's awards on their profiles as well when they are banned or removed from usergroups ....
MarshallR
07-28-2014, 04:53 AM
I can't for the life of me find where to edit the automation options!? I've searched through the thread and it doesn't seem to have been discussed. Can someone point me in the right direction. Thanks!
alcazarx
07-28-2014, 12:38 PM
Hello squidsk,
very nice mod. Reminds me on a similar one for the old phpBB/php-Fusion, but this has more options (recommend, request, small icon etc.).
We made a small change, so only supermods and admins can give awards, not normal moderators.
What you could add (like the old ones above had) is an option for each award, that speicifies if mods/supermods can give this award or admins only.
Some folks (like us) dont want to have all awards available by mods, by now we use the "award_active" option for this :p
(All awards are shown in the public list, in modcp only those are "active").
Thanks.
AsukaValentine
08-02-2014, 12:12 PM
I'm using automate option for user with one year, two years... and for post number (250, 500, 1000...). But I have a problem, when a user reach 250 post he receive the medal, but when he reach 500 post the new medal overwrite the first one. They can't have the two medals, when you reach a superior one the old one it's deleted.
It's possible to fix it?
Thanks!
alcazarx
08-27-2014, 12:53 PM
So, our small changes to the plugin are working now.
If its allowed by the author we can send them in.
Changes include:
* Award_list not accessible for guests
* Awards set to "not active" are not shown in award_list and "striked-trough" in ModCP and ACP by default. Its ok, but they shouldnt be given to any user (doesnt make sense, so we disabled it)
* Awards can be given in ModCP by Global Moderators only
* Added an option to define whether that award can be given in ModCP or not
(The plugins we used in other forums had this option and sometimes there are Awards that should be given only by the administration)
Thanks.
Gamelobby
09-03-2014, 04:21 AM
I was upgrading to 4.0.8, and now there is no listing in nav for Awards.? (no listing in admin nav either)
It is still installed, just all links & references disappeared.
Not sure if it was from a php version, or a skin version, or even another mod that i upgraded/installed. (possibly tournament, or Twitch mods)
4.2.2
Thanks
squidsk
09-03-2014, 04:51 PM
vb 4.2.2 is the culprit. The current version does not support the new nav manager, so once you upgraded to vb 4.2.2 the method used by yaas for the nav no longer works. You'll have to manually create a nav tab. Compatibility with the new manager is planned for the next release, whenever RL gives me some breathing space.
Kamaro
10-11-2014, 05:20 PM
Hi, is it possible to award members automatically with an award?
For example, if they hit 500 posts they get an award for making 500 posts?
squidsk
10-12-2014, 08:41 AM
Hi, is it possible to award members automatically with an award?
For example, if they hit 500 posts they get an award for making 500 posts?
Yes, install the automation addition.
Kamaro
10-22-2014, 09:00 PM
Wow I'm really blind. Thank you!
GONUMBER6
11-11-2014, 03:34 PM
I love this mod and have been using it for several years now! After the last vb upgrade, I notice and error flash when I issue and award- it only shows for a second but it is a warning and has to do with mySQL-tried to get a screenshot but it happens too fast. Everything seems to be in working order- but thought I would let you know just in case.
squidsk
11-11-2014, 11:44 PM
I love this mod and have been using it for several years now! After the last vb upgrade, I notice and error flash when I issue and award- it only shows for a second but it is a warning and has to do with mySQL-tried to get a screenshot but it happens too fast. Everything seems to be in working order- but thought I would let you know just in case.
Without the error message it's hard to diagnose what's going on. Check your server logs as the error should also be located there.
KGodel
12-02-2014, 08:48 PM
Does anyone know of an easy way to exclude certain categories from appearing on the page which lists the awards?
alcazarx
12-03-2014, 11:33 AM
Me dont know.
You can hide specific awards but not categories.
May sound stupid, but why hide categories?
squidsk
12-03-2014, 02:32 PM
Does anyone know of an easy way to exclude certain categories from appearing on the page which lists the awards?
Currently there is not way of doing so.
KGodel
12-03-2014, 10:19 PM
Me dont know.
You can hide specific awards but not categories.
May sound stupid, but why hide categories?
There are some awards, such as awards given for x amount of time, that don't need an explanation or need to appear on the page. I'd rather not clutter it up.
Daniel
12-08-2014, 12:53 AM
Anyone know of a way to disable the admins/mods approval? I'd like the award to go straight through and be given to the user...
squidsk
12-08-2014, 02:06 PM
Anyone know of a way to disable the admins/mods approval? I'd like the award to go straight through and be given to the user...
There is no way to do so short of making changes to the code nor do I have no plans to add such a feature. If you were to make changes to do that I'd look at creating a custom cron job.
squidsk
12-15-2014, 07:26 PM
A bit of an early Christmas gift for everyone.
Released YaAS Version 4.0.9
Added - Handling of user merges
Added - Handling of user deletes
Added - Manage awards on per user basis
Added - Extra info to the logs for mass removal and editing of issued awards
Added - Ability to collapse categories on awards.php
Added - Checksum file for checking for suspect file versions
Added - Various Missing phrases
Fixed - Memberlist not showing awards when option is active
Fixed - Navtab not being selected (vb version < 4.2)
Fixed - Category title not being displayed on awards.php
Fixed - Logging not working in modcp
Fixed - mysql error/warning when issuing awards
Fixed - A few other minor bugs
Updated - Verion in version phrase
KGodel
12-15-2014, 08:56 PM
Awesome! Thanks for the update!
Crotan
12-15-2014, 11:52 PM
A bit of an early Christmas gift for everyone.
Released YaAS Version 4.0.9
Added - Handling of user merges
Added - Handling of user deletes
Added - Manage awards on per user basis
Added - Extra info to the logs for mass removal and editing of issued awards
Added - Ability to collapse categories on awards.php
Added - Checksum file for checking for suspect file versions
Added - Various Missing phrases
Fixed - Memberlist not showing awards when option is active
Fixed - Navtab not being selected (vb version < 4.2)
Fixed - Category title not being displayed on awards.php
Fixed - Logging not working in modcp
Fixed - mysql error/warning when issuing awards
Fixed - A few other minor bugs
Updated - Verion in version phrase
And here I thought this was forgotten. You sir are a gentleman and a scholar. :up:
CAG CheechDogg
12-16-2014, 03:26 AM
I get the following error when searching for a member to manage their awards:
I x'd out some of the information ....
Database error in vBulletin x.x.xx:
Invalid SQL:
SELECT award.award_id, award.award_name, award.award_desc, award.award_icon_url, award.award_img_url, award_user.*
FROM cagisf_award_user as award_user
LEFT JOIN cagisf_ award as award USING (award_id)
WHERE award_user.userid = 3837;
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 'as award USING (award_id)
WHERE award_user.userid = 3837' at line 3
Error Number : 1064
Request Date : Monday, December 15th 2014 @ 09:21:41 PM
Error Date : Monday, December 15th 2014 @ 09:21:42 PM
Script : http://www.mysite.com/community/myadmincp/award_user.php?do=edit&u=3837
Referrer : https://www.mysite.com/community/myadmincp/award_user.php?do=search
IP Address : xxx.xxx.xxx.xxx
Username : CAG CheechDogg
Classname : vB_Database
MySQL Version : 5.5.40-36.1
CAG CheechDogg
12-16-2014, 03:53 AM
Let me be a bit more clear on how I get this error:
I click on the menu link "Award User Manager"
Then I search for a player to manage their awards and BAM! I get that error every time ...
Everything else seems to work fine Squidsk ...THANK YOU !!!
CAG CheechDogg
12-16-2014, 05:53 AM
WOAH! lol ...
After a little searching I figured out the problem to fix the error above:
In your "award_user.php" file inside upload/admincp find the following:
$awards = $db->query("
SELECT award.award_id, award.award_name, award.award_desc, award.award_icon_url, award.award_img_url, award_user.*
FROM " . TABLE_PREFIX . " award_user as award_user
LEFT JOIN " . TABLE_PREFIX . " award as award USING (award_id)
WHERE award_user.userid = " . $vbulletin->GPC['userid']
);
Replace it with :
$awards = $db->query("
SELECT award.award_id, award.award_name, award.award_desc, award.award_icon_url, award.award_img_url, award_user.*
FROM " . TABLE_PREFIX . "award_user as award_user
LEFT JOIN " . TABLE_PREFIX . "award as award USING (award_id)
WHERE award_user.userid = " . $vbulletin->GPC['userid']
);
The thing causing this error was the extra space between the (") and award as award USING (award_id) in the 3rd line (LEFT JOIN) which I highlighted in red above ....
maupassant
12-16-2014, 06:13 AM
Thanks for the update. I'd like to know if the problems I mentionned a while back have been "fixed" in this version before I install it. Thank you.
https://vborg.vbsupport.ru/showpost.php?p=2498270&postcount=1650
CAG CheechDogg
12-16-2014, 07:01 AM
Thanks for the update. I'd like to know if the problems I mentionned a while back have been "fixed" in this version before I install it. Thank you.
https://vborg.vbsupport.ru/showpost.php?p=2498270&postcount=1650
From my forums yes those issues have been fixed ... You can take a look on my forums how it looks: https://www.cagclan.com/community/threads/23328-CAG-Official-Ribbons-Awards-And-Medals-Thread?p=215478&viewfull=1#post215478
You can also choose how many medals per row show up on the postbit
alcazarx
12-16-2014, 08:50 AM
@CAG CheechDogg: The same error in green is in the "award_user.php" file in the ModCP (extra space in query).
CAG CheechDogg
12-16-2014, 08:57 AM
@CAG CheechDogg: The same error in green is in the "award_user.php" file in the ModCP (extra space in query).
Thanks for the heads up alcazarx!!!! I didn't even think about looking in ModCP...GOOD EYE !!!
Kesha
12-16-2014, 03:50 PM
I can't download 4.0.9. This site keeps saying "Invalid attachment specified". Was this file uploaded and linked correctly?
squidsk
12-16-2014, 03:52 PM
Try again, I was just re-uploading the new version with the above bug in award_users.php (both admincp and modcp) fixed and the md5 sums updated accordingly.
CAG CheechDogg
12-16-2014, 04:05 PM
Try again, I was just re-uploading the new version with the above bug in award_users.php (both admincp and modcp) fixed and the md5 sums updated accordingly.
So the new md5 file needs to be updated as well?
If I did the above bug fixes in the admincp and modcp (award_users.php) files do I still need to update anything? Thanks once again squidsk !!!
squidsk
12-16-2014, 04:07 PM
@CAG CheechDogg: The same error in green is in the "award_user.php" file in the ModCP (extra space in query).
I get the following error when searching for a member to manage their awards:
I x'd out some of the information ....
<snip>
Thanks for finding that! I've uploaded a new version of the 4.0.9 version with that bug fixed and the md5 sums updated accordingly.
Thanks for the update. I'd like to know if the problems I mentionned a while back have been "fixed" in this version before I install it. Thank you.
https://vborg.vbsupport.ru/showpost.php?p=2498270&postcount=1650
No because the problem is on your end and has nothing to do with the mod. I can't tell from the screenshots for certain, but it looks like you are using postbit_legacy. When using postbit_legacy the width of the awards postbit display is based off the setting for the stylevar postbitlegacy_userinfo_width. If you are using postbit_legacy you are allowing content in your postbit that is wider than the value you have set for that stylevar. If you have not using postbit legacy (i.e. the postbit where things are displayed across the top of the post instead of at the side) then you'd need to edit the width that is set for the awards display in the .postbit .userinfo .yaas_postbit in the awards_css.css template.
squidsk
12-16-2014, 04:14 PM
So the new md5 file needs to be updated as well?
If I did the above bug fixes in the admincp and modcp (award_users.php) files do I still need to update anything? Thanks once again squidsk !!!
There were a couple of other minor tweaks as well, if you just copy the new files to your server you should be fine. The reason the md5 sums need to be updated is that the files have changed and if I didn't update the md5 sums those files would show as not having expected content.
A total of 5 files were changed with minor tweaks:
modcp/award_user.php
modcp/award.php
admincp/award_user.php
admincp/award.php
includes/md5_sums_yaas.php
CAG CheechDogg
12-16-2014, 04:19 PM
Thanks for finding that! I've uploaded a new version of the 4.0.9 version with that bug fixed and the md5 sums updated accordingly.
No problem ... I was going nuts trying to figure it out ... I finally got my thinking cap on straight and found it ...
There were a couple of other minor tweaks as well, if you just copy the new files to your server you should be fine. The reason the md5 sums need to be updated is that the file has changed and if I didn't update them the files would show as not having expected content.
A total of 5 files were changed with minor tweaks:
modcp/award_user.php
modcp/award.php
admincp/award_user.php
admincp/award.php
includes/md5_sums_yaas.php
Ok thanks for the list of files changed .....once again squidsk thank you !!!!
squidsk
12-16-2014, 04:25 PM
I would be very remiss if I didn't point this out but the fix the memberinfo list functionality was provided by Elite_360_ (https://vborg.vbsupport.ru/member.php?u=496023)
CAG CheechDogg
12-16-2014, 04:25 PM
No because the problem is on your end and has nothing to do with the mod. I can't tell from the screenshots for certain, but it looks like you are using postbit_legacy. When using postbit_legacy the width of the awards postbit display is based off the setting for the stylevar postbitlegacy_userinfo_width. If you are using postbit_legacy you are allowing content in your postbit that is wider than the value you have set for that stylevar. If you have not using postbit legacy (i.e. the postbit where things are displayed across the top of the post instead of at the side) then you'd need to edit the width that is set for the awards display in the .postbit .userinfo .yaas_postbit in the awards_css.css template.
I apologize for saying that these issues were fixed..I never took into consideration the fact that it's different in postbit_legacy and posbit .... :eek:
CAG CheechDogg
12-16-2014, 04:26 PM
I would be very remiss if I didn't point this out but the fix the memberinfo list functionality was provided by Elite_360_ (https://vborg.vbsupport.ru/member.php?u=496023)
What fix was that my Man ?
CAG CheechDogg
12-16-2014, 04:28 PM
You mean: Memberlist not showing awards when option is active? ...if that's the one I never came across this bug....
maupassant
12-16-2014, 04:45 PM
Thanks for finding that! I've uploaded a new version of the 4.0.9 version with that bug fixed and the md5 sums updated accordingly.
No because the problem is on your end and has nothing to do with the mod. I can't tell from the screenshots for certain, but it looks like you are using postbit_legacy. When using postbit_legacy the width of the awards postbit display is based off the setting for the stylevar postbitlegacy_userinfo_width. If you are using postbit_legacy you are allowing content in your postbit that is wider than the value you have set for that stylevar. If you have not using postbit legacy (i.e. the postbit where things are displayed across the top of the post instead of at the side) then you'd need to edit the width that is set for the awards display in the .postbit .userinfo .yaas_postbit in the awards_css.css template.
Not using postbit_legacy. But I'll try to fix the problems with your instructions. Thank you.
Kesha
12-16-2014, 06:32 PM
I finally got this mod uploaded and the XML file upgraded and I've run into problems.
1) /forums/awards.php shows only a blank page
2) Awards do not display in postbit
3) Awards tab is gone from user profiles
I've already checked and verified the appropriate settings in the Admin CP and everything's normal. Do I have something going on?
alcazarx
12-16-2014, 06:34 PM
Thanks for the heads up alcazarx!!!! I didn't even think about looking in ModCP...GOOD EYE !!!
Found it while updating the mod.
We have some "extras" build in (see other post here) and so can't simply overwrite the files.
squidsk
12-16-2014, 06:47 PM
I finally got this mod uploaded and the XML file upgraded and I've run into problems.
1) /forums/awards.php shows only a blank page
2) Awards do not display in postbit
3) Awards tab is gone from user profiles
I've already checked and verified the appropriate settings in the Admin CP and everything's normal. Do I have something going on?
Without a link to your site, and possibly admin access its hard to figure out what's going on. For the first error I'd need to the error message from your logs to have a change at figuring it out. The second and third, what version were you upgrading from? Were there any errors when installing/upgrading?
Found it while updating the mod.
We have some "extras" build in (see other post here) and so can't simply overwrite the files.
If you don't mind sharing the "extras" they might be features/changes I could include into the mod. I'm always on the lookout for good ideas.
Kesha
12-16-2014, 06:51 PM
Without a link to your site, and possibly admin access its hard to figure out what's going on. For the first error I'd need to the error message from your logs to have a change at figuring it out. The second and third, what version were you upgrading from? Were there any errors when installing/upgrading?
I can provide you with the appropriate access, if you have a Skype could you send that my way in a Private Message here?
CAG CheechDogg
12-16-2014, 07:01 PM
If you don't mind sharing the "extras" they might be features/changes I could include into the mod. I'm always on the lookout for good ideas.
These are the changes he's talking about :
https://vborg.vbsupport.ru/showthread.php?p=2512879#post2512879
maupassant
12-16-2014, 07:15 PM
Problem fixed at my end by changing width to 250px. Thank you ! :):)
CAG CheechDogg
12-16-2014, 07:17 PM
Problem fixed at my end by changing width to 250px. Thank you ! :):)
Good to see you got it fixed my Man ... and again sorry for the misinformation earlier ...
squidsk
12-16-2014, 07:18 PM
These are the changes he's talking about :
https://vborg.vbsupport.ru/showthread.php?p=2512879#post2512879
I'm getting senile in my old age. I've already seen that list and am adding those, in some fashion, into the 4.1 release, which unfortunately is still a bit out.
CAG CheechDogg
12-16-2014, 07:26 PM
I'm getting senile in my old age. I've already seen that list and am adding those, in some fashion, into the 4.1 release, which unfortunately is still a bit out.
LOL !!! :p it's all good my Man .... I'm on the same boat !!!
squidsk
12-16-2014, 07:36 PM
Problem fixed at my end by changing width to 250px. Thank you ! :):)
I'm glad that worked for you.
maupassant
12-17-2014, 04:53 AM
Good to see you got it fixed my Man ... and again sorry for the misinformation earlier ...
No problem. Better trying to help others than say nothing. :)
Kesha
12-17-2014, 01:25 PM
I got it working... Turns out that "turning it off and on again" doesn't apply to JUST computers.
CAG CheechDogg
12-17-2014, 01:47 PM
I got it working... Turns out that "turning it off and on again" doesn't apply to JUST computers.
Good stuff !!! lol :D
alcazarx
12-17-2014, 02:33 PM
You two are not old, me is old (or why would me hide under that cloak :cool: ).
Anyway, here are the changes requested.
Me is not familiar with xml used to create / edit pluigns, so me used an old mod-variant.
Row-Number (as shown in notepad++) is included for easier finding.
/* edit
Sorry.
Of course you have to create some phrases too, i. e. for "allow_mod" when adding/editing an award.
Allow moderators to give this award in ModCP.<br /><i>You need to activate 'Turn on YAAS in ModCP' in Award settings for this.</i>
*/
squidsk
12-17-2014, 03:34 PM
I got it working... Turns out that "turning it off and on again" doesn't apply to JUST computers.
I'm glad you got it working, but I'm still curious why it required turning yaas off and then on again.
squidsk
12-17-2014, 03:38 PM
You two are not old, me is old (or why would me hide under that cloak :cool: ).
Anyway, here are the changes requested.
Me is not familiar with xml used to create / edit pluigns, so me used an old mod-variant.
Row-Number (as shown in notepad++) is included for easier finding.
/* edit
Sorry.
Of course you have to create some phrases too, i. e. for "allow_mod" when adding/editing an award.
Allow moderators to give this award in ModCP.<br /><i>You need to activate 'Turn on YAAS in ModCP' in Award settings for this.</i>
*/
Thanks for those changes. I'll see about incorporating them into the 4.1 release.
alcazarx
12-17-2014, 08:14 PM
As for the guest restriction.
Me thinks not everyone would lock them out, so making this an option in settings ("Display Award List to Guests" i. e.) could be the better solution then our hardcoded.
squidsk
12-17-2014, 09:52 PM
As for the guest restriction.
Me thinks not everyone would lock them out, so making this an option in settings ("Display Award List to Guests" i. e.) could be the better solution then our hardcoded.
What I'm thinking of going to do is make it a usergroup permission. If you don't want guests to see the awards page you'd set it to false for unregistered users.
alcazarx
12-19-2014, 02:01 PM
Even better solution.
Its clear, that me is just a small normal user and youre the great author :rolleyes:
squidsk
12-19-2014, 03:23 PM
Even better solution.
Its clear, that me is just a small normal user and youre the great author :rolleyes:
I may be the developer but most of the additions over the last couple of releases have been ideas that were proposed by users of yaas or based on ideas proposed by users of the yaas. Having gone over the change logs for versions 4.0.7, 4.0.8 and 4.0.9 the only idea that was entirely my own was the md5 sums.
As I said keep giving me ideas and if feasible I will try to implement them.
CAG CheechDogg
12-19-2014, 04:23 PM
I may be the developer but most of the additions over the last couple of releases have been ideas that were proposed by users of yaas or based on ideas proposed by users of the yaas. Having gone over the change logs for versions 4.0.7, 4.0.8 and 4.0.9 the only idea that was entirely my own was the md5 sums.
As I said keep giving me ideas and if feasible I will try to implement them.
Yes, I proposed the idea of managing each individual's awards from the back end and he put it together and made it happen ... so much easier now to manage the awards ....thank you squidsk !!!!
alcazarx
12-19-2014, 08:32 PM
What I'm thinking of going to do is make it a usergroup permission. If you don't want guests to see the awards page you'd set it to false for unregistered users.
I may be the developer but most of the additions over the last couple of releases have been ideas that were proposed by users of yaas or based on ideas proposed by users of the yaas. Having gone over the change logs for versions 4.0.7, 4.0.8 and 4.0.9 the only idea that was entirely my own was the md5 sums.
However, our technician ordered me to post this.
Its a modified bitfield.xml and in "<forum_root>/awards.php" below // ################################################## #####################
// ######################## START MAIN SCRIPT ############################
// ################################################## ##################### add if (!($permissions['awardpermissions'] & $vbulletin->bf_ugp_awardpermissions['canviewaward']))
{
print_no_permission();
}
Also, create a phraseLocation: ControlCenter->Permissions
Name: award_can_view_award
Text: Can view award list
-
Again (no flattery), have seen many award systems for different scripts and even most of your features are suggested by users, its the best award system me knows :up:
pantani
12-21-2014, 04:31 PM
How can i delete one reward given to one member plz?
pantani
12-21-2014, 04:45 PM
Found it :)
HKimF
12-22-2014, 03:29 PM
I recently moved my db to the InnoDB engine, and noticed that my awards aren't sticking... does YaaS have issues with non MyISAM engines?
squidsk
12-22-2014, 07:42 PM
I recently moved my db to the InnoDB engine, and noticed that my awards aren't sticking... does YaaS have issues with non MyISAM engines?
It has no issues with innodb or any other db engine. Awards not sticking is not a lot of details, and you aren't running the latest version. If you'd like further help please update to the current version and mark yaas as installed.
Psyd0x
01-04-2015, 01:49 PM
I have a problem with the postbit legacy
i using the userinfo_right but that what happen on 2 postbit profiles
https://vborg.vbsupport.ru/external/2015/01/43.png
https://vborg.vbsupport.ru/external/2015/01/44.png
one buggy and one not i want it to look like the second picture
squidsk
01-05-2015, 06:56 PM
First you're using postbit not postbit legacy. My guess without seeing the actual site is that the issue has to do with the fact that in the second image you've got an extra image on the left which is pushing the awards below the other bits of information on the right.
Psyd0x
01-06-2015, 02:47 AM
First you're using postbit not postbit legacy. My guess without seeing the actual site is that the issue has to do with the fact that in the second image you've got an extra image on the left which is pushing the awards below the other bits of information on the right.
yes you right but how can i add the awards under the vouch system[itrader]
The post legacy option is under the posts and i need it under the vouches like the second picture
Inked_Mono
01-11-2015, 09:20 PM
I must be daft, but I can't figure out how to get the Automation system working at all. Everything installed cleanly, however I'm unable to really get a grip on how the profile fields are supposed to be correctly filled out.
http://i.imgur.com/2c0T8KH.png
squidsk
01-12-2015, 02:48 AM
I must be daft, but I can't figure out how to get the Automation system working at all. Everything installed cleanly, however I'm unable to really get a grip on how the profile fields are supposed to be correctly filled out.
http://i.imgur.com/2c0T8KH.png
What isn't clear? As for the award id, you get from the award manager page where you see all the awards.
Inked_Mono
01-12-2015, 11:37 PM
What isn't clear? As for the award id, you get from the award manager page where you see all the awards.
http://i.imgur.com/SWJK6Cx.png
I've left the default awards for now, but where would I find the ID? I don't see anything specific there.
CAG CheechDogg
01-13-2015, 12:44 AM
Just look at the link of every award my Man from the awards page ...it looks like this
yourdomain.com/your-forums/awards.php?do=viewaward&award_id=11
The id for that award would be (11)
Inked_Mono
01-13-2015, 12:54 AM
Just look at the link of every award my Man from the awards page ...it looks like this
yourdomain.com/your-forums/awards.php?do=viewaward&award_id=11
The id for that award would be (11)
Didn't even think to do that. Thanks, man.
squidsk
01-13-2015, 01:54 AM
I think it also lists it on the page where you edit the awards.
CAG CheechDogg
01-13-2015, 07:15 AM
I think it also lists it on the page where you edit the awards.
Yes it does squidsk I forgot about that ...
walshymyster
02-04-2015, 08:50 PM
Hi There
Been using the mod for years (since released)
I am rebuilding my site due to it being dormant and bringing it back
When i used the old version 4.0.0 of YAAS i managed to get the awards to display 4 per line and adding a new line each time and centering the awards in my signature as such
http://www.tcfleet.com/awards.png
however on the latest version im having issues replicating this.
all my award ribbons are the same size so im thinking restrict the signature width? and get them to center when added.
any ideas anyone on how to bring this back in.
I know before i made a change to the "postbit_display_start" plugin but i believe thats now obsolete?
if anyone can point me in the right direction i would be grateful
squidsk
02-05-2015, 04:00 PM
The easiest way, though maybe not the best, would probably be to set a width on the surrounding div for the awards it has the class yaas_postbit. The rule should be placed in your additional.css template. Something like the rule below.
.yaas_postbit {
width: ###px;
}
walshymyster
02-05-2015, 07:57 PM
cheers ill give that a go
MistViper
02-06-2015, 01:10 AM
Looks good, I'll definitely be downloading and marking as installed shortly! Just a quick suggestion since this looks like it works for Vb 4.2.2 could you update that in the OP? Took me a bit of searching to find that it did in fact work for that version.
squidsk
02-06-2015, 04:33 AM
Looks good, I'll definitely be downloading and marking as installed shortly! Just a quick suggestion since this looks like it works for Vb 4.2.2 could you update that in the OP? Took me a bit of searching to find that it did in fact work for that version.
The version in the OP is the minimum version it works for, not the maximum.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.