PDA

View Full Version : Major Additions - Yet Another Awards System


Pages : 1 2 3 4 [5] 6 7 8

CypherSTL
01-16-2012, 04:57 PM
So who handles the support with this mod in this thread?
I do.

I'm getting close to releasing a new version. ANY bug reports need to get sent to yaas-bugs@kd0igo.com

Please make sure you specify what version of the mod you have, (VB3 or VB4). All emails get added to Redmine for easier bug tracking. Redmine is MUCH easier than trying to read though 60+ pages.

mIQe
01-19-2012, 08:03 AM
I do.

I'm getting close to releasing a new version. ANY bug reports need to get sent to yaas-bugs@kd0igo.com

Please make sure you specify what version of the mod you have, (VB3 or VB4). All emails get added to Redmine for easier bug tracking. Redmine is MUCH easier than trying to read though 60+ pages.

Thank you for your reply, I have emailed you a couple of days ago. But as it is more of a case of lack of information and needed assistance then bugs I'm not sure that the mail is a bug report.

But I wonder does that mean I will get a reply and the help I need through email or will you post it here or will you only make a note about it in you bug log?

tpearl5
01-19-2012, 03:54 PM
Waiting for the update to install :)

owning_y0u
01-19-2012, 08:07 PM
Getting a database error

Database error in vBulletin 4.1.10:

Invalid SQL:
ALTER TABLE award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

MySQL Error : Table 'forum.award' doesn't exist
Error Number : 1146
Request Date : Thursday, January 19th 2012 @ 10:05:52 PM
Error Date : Thursday, January 19th 2012 @ 10:05:53 PM
Script : http://localhost/vbulletin/admincp/plugin.php?do=productimport
Referrer : http://localhost/vbulletin/admincp/plugin.php?do=productadd
IP Address : 127.0.0.1
Username : Owning
Classname : vB_Database
MySQL Version : 5.5.8

Resolved the error by make the tables my self but it seems the installer isnt willing to create the tables on a 4.1.10 install (clean)

i now have this issue:
is Deprecated: Assigning the return value of new by reference is deprecated in C:\xampp\htdocs\vbulletin\awards.php on line 47 (but that is a php issue since i use a higher version on my local host)

squidsk
01-20-2012, 07:58 PM
To resolve the deprecation error go to line 47 in awards.php and delete the & from before the equals sign.

TheShanka
01-20-2012, 08:22 PM
CypherSTL, what an absolute star you are - this mod could have so much potential but has been lying at the side of the road for quite some time now.

What we're looking for is an awards system where you can add and remove customised awards and they'll appear below a users signature which we could limit to a set amount and the user could prioritise their awards through their profile. Will the new mod you're releasing have this capability or are you keeping it under your hat until release?

Thanks in advance.

mIQe
01-21-2012, 04:34 PM
I still haven't seen anywhere an explanation on how to use the auto reward feature. Does anyone know how to use it?

squidsk
01-23-2012, 02:29 PM
CypherSTL, what an absolute star you are - this mod could have so much potential but has been lying at the side of the road for quite some time now.

What we're looking for is an awards system where you can add and remove customised awards

Already does this.

and they'll appear below a users signature which we could limit to a set amount

Already does this.

and the user could prioritise their awards through their profile.

Global ordering is what is used now, user specific ordering is not possible.

Cledus James
01-23-2012, 07:26 PM
Wondering if I can see some support for this mod. I've used this mod since vb3 and it's one of the best things I've ever added to my forums.

Here's my problem. In my users profiles the My Awards tab is not showing up. It's there and clickable but it's invisiable. If you need an example of what I'm talking about go here:

http://www.suicide-kings.net/forums/member.php?1-Cledus

Right next to the My Ranks tab you can see the area for the awards tab is clickable but not visiable.

Also, is there any way to rename that tab to something else besides My Awards?

Any help to fix the problem would be greatly appreciated.

squidsk
01-23-2012, 08:56 PM
Follow the instructions at: https://vborg.vbsupport.ru/showthread.php?p=2189701#post2189701

mIQe
01-23-2012, 09:00 PM
If those above instructions don't work, which they didn't for me.
Then restore the code as it originally was and use this instead.

if ($selected_tab == 'myawards')
{
$template_hook['profile_tabs_last'] .= '<dd class="userprof_module"><a id="myawards-tab" href="'.$vbulletin->input->fetch_relpath().'#myawards" onclick="return tabViewPicker(this);">Awards</a></dd>';
}
else
{
$template_hook['profile_tabs_last'] .= '<dd class="userprof_moduleinactive"><a id="
myawards-tab" href="'.$vbulletin->input->fetch_relpath().'#myawards" onclick="return tabViewPicker(this);">Awards</a></dd>';
}



Go to the Admin Control Panel >> Languages & Phrases >> Search In Phrases
Type in: My Awards
In the Search For Text box and press enter or click the button Find.
Then click the button that says Edit


Now to MY question, about how to get the award automation to work, seems like no one is able to answer. Makes me want to rate this a terrible mod.

ShadyUS
01-24-2012, 12:37 AM
Would this work on 4.0.1?

TombstoneWarrior
01-24-2012, 11:12 AM
can someone explain a bi better how to install this mod or where to find the directions for installing this mod please.

mIQe
01-25-2012, 08:03 PM
I hope this will help

Unzip the archive and then.

Upload everything in the /upload directory to your forum root.

Then Import yet_another_award_system_automation.xml from your admin control panel.

TombstoneWarrior
01-25-2012, 08:49 PM
I hope this will help

Unzip the archive and then.

Upload everything in the /upload directory to your forum root.

Then Import yet_another_award_system_automation.xml from your admin control panel. so highlight all the file in the whole folder of upload to my public_html in my ftp? i dont need to upload the files inside the folder like admincp to admincp? just double checking???

chrissyplum79
01-25-2012, 09:12 PM
On my forum there is something happening with the awards list on the postbit. I want them in a straight line but there is 2 in one row then 1 under it so it is like this:
(member info)
Award 1, Award 2,
Award 3

Is there any way I can fix that?

mIQe
01-26-2012, 09:32 AM
so highlight all the file in the whole folder of upload to my public_html in my ftp? i dont need to upload the files inside the folder like admincp to admincp? just double checking???

Do you have your vBulletin installation directly under the my public_html folder? You don't have a folder you installed it in to? If not then yes, you should select all files and folders and drag them to your my public_html folder. As you already should have a admincp folder there after installing vBulletin, you should have no problems dragging the files and folders to my public_html folder, as it will move the files in to those folders.

TombstoneWarrior
01-26-2012, 09:53 AM
Do you have your vBulletin installation directly under the my public_html folder? You don't have a folder you installed it in to? If not then yes, you should select all files and folders and drag them to your my public_html folder. As you already should have a admincp folder there after installing vBulletin, you should have no problems dragging the files and folders to my public_html folder, as it will move the files in to those folders. Thank you and yes my vb files are in the PUBLIC_HTML my host installed the vb files and thats the way they did it. I didnt know how to install the files now i do though since i made a test site. Thanks for confirming what i though about wherre to put the files. Your the best!!!

Captain Tycoon
01-30-2012, 01:39 PM
Is there anyway to give awards based on the usergroup or subscription (preferred)?

andy_mcguire
01-31-2012, 11:43 AM
https://vborg.vbsupport.ru/external/2012/01/4.jpg

Any idea how to fix this?

M.Iftikhar
01-31-2012, 04:43 PM
it is not working in 4.1.10...when i add new award it display database error and when i edit a award it also give database error.....please tell me what can i do....or please tell me an other addon that works..........thanks and reply me soon.

Bisha
01-31-2012, 08:26 PM
it is not working in 4.1.10...when i add new award it display database error and when i edit a award it also give database error.....please tell me what can i do....or please tell me an other addon that works..........thanks and reply me soon.

Last Update: 16 May 2010 , and on 4.1.10, there are a tons of changes....

M.Iftikhar
02-01-2012, 01:37 PM
Hello,vbulletin members and staff members please help me....i am using Yet Another Awards System...it work fine in vb4.1.5 after upgrading to vb 4.1.10 it did not work fine....all previous seeting work fine...but when i add new award or updat a award it gives error.... so i enabled to add new award....and also do not edit previously award setting..... when i add new award it gives the following error....

Database error in vBulletin 4.1.10:

Invalid SQL:

INSERT INTO award
(award_name, award_desc, award_icon_url, award_img_url, award_cat_id, award_displayorder, award_allowrequest, award_allowrecommend, award_pointvalue, award_active)
VALUES
('Special Proformas 2011',
'',
'http://******.com/images/medals/shairy.gif',
'http://********.com/images/medals/shairy.gif',
'27',
'1',
'0',
'0',
'0',
'1'
);

MySQL Error : Unknown column 'award_allowrecommend' in 'field list'
Error Number : 1054
Request Date : Wednesday, February 1st 2012 @ 08:28:27 AM
Error Date : Wednesday, February 1st 2012 @ 08:28:29 AM
Script : http://www.******.com/admin/award.php?do=insert
Referrer : http://www.******.com/admin/award.ph...ward_cat_id=-1 (http://www.******.com/admin/award.php?do=add&award_cat_id=-1)
IP Address : 1**.1**.2**.5
Username : Administrator
Classname : vB_Database
MySQL Version : 5.1.56

so please tell me how can i do....????

please provide me another award system link....that work reply me soon......thanks

mIQe
02-02-2012, 09:49 AM
Why does this not work?

All of them have the setting: Enable Automation Task? YES
Also the Awards Systems Setting have: Automation: Enable Automation System set to YES
Members have been members for longer then 30 days.

This Mod is supposed to be supported. Then give me support and not some email address that doesn't include support.


Automation Task Name Issue reason Criteria Type Criteria Award ID

One Month Membership You have been a member for one month. daysasmember 30 24
Two Months Membership You have been a member for two months. daysasmember 60 25
Three Months Membership You have been a member for three months. daysasmember 90 26
Four Months Membership You have been a member for four months. daysasmember 120 27
Five Months Membership You have been a member for five months. daysasmember 150 28
Six Months Membership You have been a member for six months. daysasmember 180 29
Seven Months Membership You have been a member for seven months. daysasmember 210 30
Eight Months Membership You have been a member for eight months. daysasmember 240 31
Nine Months Membership You have been a member for nine months. daysasmember 270 32
Ten Months Membership You have been a member for ten months. daysasmember 300 33
Eleven Months Membership You have been a member for eleven months. daysasmember 333 34
Twelve Months Membership You have been a member for twelve months. daysasmember 365 35
One And A Half Year Membership You have been a member for one and a half years. daysasmember 548 36
Two Years Membership You have been a member for two years. daysasmember 730 37
Three Years Membership You have been a member for three years. daysasmember 1095 38

killerford
02-02-2012, 01:50 PM
Will this work with the latest version of VB?

squidsk
02-02-2012, 02:58 PM
Why does this not work?

All of them have the setting: Enable Automation Task? YES
Also the Awards Systems Setting have: Automation: Enable Automation System set to YES
Members have been members for longer then 30 days.

This Mod is supposed to be supported. Then give me support and not some email address that doesn't include support.


Automation Task Name Issue reason Criteria Type Criteria Award ID

One Month Membership You have been a member for one month. daysasmember 30 24
Two Months Membership You have been a member for two months. daysasmember 60 25
Three Months Membership You have been a member for three months. daysasmember 90 26
Four Months Membership You have been a member for four months. daysasmember 120 27
Five Months Membership You have been a member for five months. daysasmember 150 28
Six Months Membership You have been a member for six months. daysasmember 180 29
Seven Months Membership You have been a member for seven months. daysasmember 210 30
Eight Months Membership You have been a member for eight months. daysasmember 240 31
Nine Months Membership You have been a member for nine months. daysasmember 270 32
Ten Months Membership You have been a member for ten months. daysasmember 300 33
Eleven Months Membership You have been a member for eleven months. daysasmember 333 34
Twelve Months Membership You have been a member for twelve months. daysasmember 365 35
One And A Half Year Membership You have been a member for one and a half years. daysasmember 548 36
Two Years Membership You have been a member for two years. daysasmember 730 37
Three Years Membership You have been a member for three years. daysasmember 1095 38

I'm pretty sure the automation is not retroactive so if someone has already been a member of your site for X days they will not get the award just because you activate it. The query likely checks if they've been a member exactly X days and then gives an award.

Bluefin221
02-02-2012, 05:30 PM
Will this work with the latest version of VB?

Yes, although it doesn't function the way you want it to.

mIQe
02-03-2012, 12:06 AM
I'm pretty sure the automation is not retroactive so if someone has already been a member of your site for X days they will not get the award just because you activate it. The query likely checks if they've been a member exactly X days and then gives an award.

Thanks for replying. Are you sure about it not being retroactive?
I surely have to check the registration date for a member not how long the award has been active.

Because if it isn't, then this mod stinks even more then their support does.

squidsk
02-03-2012, 02:42 PM
Thanks for replying. Are you sure about it not being retroactive?
I surely have to check the registration date for a member not how long the award has been active.

Because if it isn't, then this mod stinks even more then their support does.
Pretty sure, because it would make the code and the queries more complex if it was applying awards retroactively. I'm guessing that the automation is run through a cron job which runs every X period of time. If you want it to run retroactively then you're running an extra query for every single user in the database for every single award that is being automatically awarded. The overhead for that would not be something I'd want on my site.

As for complaining about the support, you do realize that whatever support you're getting, and I believe that just means patches and stuff, you aren't paying a cent for, so complaining that you aren't getting enough for free is . . . uncalled for at best.

mIQe
02-06-2012, 09:48 AM
Pretty sure, because it would make the code and the queries more complex if it was applying awards retroactively. I'm guessing that the automation is run through a cron job which runs every X period of time. If you want it to run retroactively then you're running an extra query for every single user in the database for every single award that is being automatically awarded. The overhead for that would not be something I'd want on my site.

As for complaining about the support, you do realize that whatever support you're getting, and I believe that just means patches and stuff, you aren't paying a cent for, so complaining that you aren't getting enough for free is . . . uncalled for at best.

Well I guess you and I read different things in to the term support. I read it as this: If a product is supported the customers can come with what ever problems they have with the product and get the help they need to fix the problem. It doesn't matter if it is free or not. What matters is that it is supported or not.

This product is supposed to be supported.

If it does mean what you say that it is just patches and such, then an other word then supported should be used. Such as In Active Development or some thing along those lines. Using supported is misleading in that case.

As for the award automation, it does not work, at all. I've tested with a 1 day membership award and it isn't awarded either. If it is some setting I've not done right or not, I have no idea as the documentation on how to use the product is not 100% on how to set it up. Nor have I gotten support here to sort it out.

As for rewarding automated awards retroactively, if it was a button you could click to start a process to check each member's amount of days as a member once, then it wouldn't be a huge amount of queries that runs all the time. Plus those that wouldn't like to use that function could choose not to. But since it's not working at all this is all just wishful thinking.

squidsk
02-06-2012, 06:03 PM
Well I guess you and I read different things in to the term support. I read it as this: If a product is supported the customers can come with what ever problems they have with the product and get the help they need to fix the problem. It doesn't matter if it is free or not. What matters is that it is supported or not.

This product is supposed to be supported.

If it does mean what you say that it is just patches and such, then an other word then supported should be used. Such as In Active Development or some thing along those lines. Using supported is misleading in that case.

The difference we have is my expectations for support differ vastly if I'm paying for it as opposed to getting it for free from someone who likely has a full time job and does this for fun in whatever spare time he or she has. At work the servers are on a 4 hour turn around, and I'd be pissed if I didn't get service within that 4 hour window without a damn good reason, but my company pays a premium for that service. Here where I pay nothing for the service my expectations are much lower.

As for the award automation, it does not work, at all. I've tested with a 1 day membership award and it isn't awarded either. If it is some setting I've not done right or not, I have no idea as the documentation on how to use the product is not 100% on how to set it up. Nor have I gotten support here to sort it out.

Personally we don't use it on our site, so I'm limited in what I can do since I've never played around with it.


As for rewarding automated awards retroactively, if it was a button you could click to start a process to check each member's amount of days as a member once, then it wouldn't be a huge amount of queries that runs all the time. Plus those that wouldn't like to use that function could choose not to. But since it's not working at all this is all just wishful thinking.

Why have a button, retroactive awards only need to be applied once, and its easy enough to craft an SQL query that will give the award to those that should have it, then there's no extra messy bits lying around your install.

mIQe
02-07-2012, 12:10 AM
The difference we have is my expectations for support differ vastly if I'm paying for it as opposed to getting it for free from someone who likely has a full time job and does this for fun in whatever spare time he or she has. At work the servers are on a 4 hour turn around, and I'd be pissed if I didn't get service within that 4 hour window without a damn good reason, but my company pays a premium for that service. Here where I pay nothing for the service my expectations are much lower.

My expectations for support differs as well, just as yours do. How ever waiting weeks for help is not what I call support. If I paid for a product I expect 24 hour support and that they can solve the problems in a day. For a free product like this, I expect that something should have happened in 3 weeks time.

Personally we don't use it on our site, so I'm limited in what I can do since I've never played around with it.

I understand. Well I have tried to follow the very limited instructions and I can say that it does not work. So either I did something from due to bad instructions or the product is faulty.

Why have a button, retroactive awards only need to be applied once, and its easy enough to craft an SQL query that will give the award to those that should have it, then there's no extra messy bits lying around your install.

You say that as if I would have any idea what SQL is. I don't. I'm totally illiterate when it comes to stuff like that. Thus in need of support when it doesn't work.

So far, the forum logo on the awards page is not in the same place as it is on any other forum pages. - I've been told it might be the skin wrapper, but I don't get why that would be different for this page and not the others. It seems to draw all the info from the same place after all.

The awards that should be atomized aren't automated. - I've tried many different settings, I can't get it to hand out awards. I have no idea if it is retroactive or not.

squidsk
02-07-2012, 03:35 PM
My expectations for support differs as well, just as yours do. How ever waiting weeks for help is not what I call support. If I paid for a product I expect 24 hour support and that they can solve the problems in a day. For a free product like this, I expect that something should have happened in 3 weeks time.

I have a different take on things as I have written a couple of free programs, and while I do offer support, often it isn't timely due to other constraints and patches can be months in the making even if the bugs are small and easy to fix.

You say that as if I would have any idea what SQL is. I don't. I'm totally illiterate when it comes to stuff like that. Thus in need of support when it doesn't work.

I forget sometimes that not everyone who administers a site necessarily has the technical skills to do the behind the work fixes that are sometimes required.

So far, the forum logo on the awards page is not in the same place as it is on any other forum pages. - I've been told it might be the skin wrapper, but I don't get why that would be different for this page and not the others. It seems to draw all the info from the same place after all.

I'd guess this is actually a problem with your skin, as you've been told. The easy way to check it is does the default skin look normal or does it have the same issue on the awards page. If it doesn't its a skin issue, if it does its an issue with the plugin, but on my forum I don't see any problems with the default skin.

Gamelobby
02-07-2012, 07:07 PM
I installed this and the award page was all messed up. I deleted the mod and now I cannot re-install it. Any Ideas?

vB - 4.1.10

squidsk
02-08-2012, 02:54 PM
Yes, there's currently a problem with the uninstaller for the mod not actually removing all tables, so when you try and re-install the mod it fails because the tables its trying to create already exist. The easiest way to fix the issue is to remove the sections of the install code that generate the errors, so if its giving you an error that says table A already exists then go into the install code and remove the entry that adds that table.

mIQe
02-08-2012, 10:33 PM
I have a different take on things as I have written a couple of free programs, and while I do offer support, often it isn't timely due to other constraints and patches can be months in the making even if the bugs are small and easy to fix.

Well I've hosted websites with free custom made 3D models mods for games and provided support for that and I would try and be swift about giving it as it then was no longer on my to do list. Not everything I've asked about have been bugs, some have been about how to use the product and that should be fairly fast and easy to answer. Don't you think?

I forget sometimes that not everyone who administers a site necessarily has the technical skills to do the behind the work fixes that are sometimes required.

Well I managed to uninstall this product so I could try and install it again. So I'm not clueless if I get a reasonably understandable description on how to do something. I just can't whip something up on my own.

I'd guess this is actually a problem with your skin, as you've been told. The easy way to check it is does the default skin look normal or does it have the same issue on the awards page. If it doesn't its a skin issue, if it does its an issue with the plugin, but on my forum I don't see any problems with the default skin.

I've used a default skin and made a few new skins with the Style Generator and the image is aligned wrong using them too...

Sarab
02-09-2012, 03:58 AM
Hello,

Will this mod have a patch or upgrade for 4.1.10 or not? if yes will it take long to see it available?

Best Regards
Sarab

DAMINK
02-09-2012, 05:40 AM
Yes, there's currently a problem with the uninstaller for the mod not actually removing all tables, so when you try and re-install the mod it fails because the tables its trying to create already exist. The easiest way to fix the issue is to remove the sections of the install code that generate the errors, so if its giving you an error that says table A already exists then go into the install code and remove the entry that adds that table.

Wouldnt it just be easier to drop the tables themselves?
Instead of modifying the install code.

squidsk
02-09-2012, 03:42 PM
Wouldnt it just be easier to drop the tables themselves?
Instead of modifying the install code.
Of course it would, except not everyone knows how to drop a table and it usually easier to edit a file than create an sql query, especially as not all the errors are related to tables not being dropped, there are also fields that are causing issues as well if you look back at the thread.

KGodel
02-09-2012, 06:15 PM
It would be great if there was a way to have category-specific postbits. Say, awards from Category X,Y,Z display under profile, but from Category A, B, and C display right of signature.

bremereric
02-12-2012, 03:32 AM
I had DTO install the Garage Plus software on my forum. It did wipe the Awards Menu out of the Admincp and the Awards screen that you could get to by clicking the Awards tab at the top of the Forum. I un-installed it and then went into myphpamin and dropped the tables because they remained. I would like to re-install it but I am afraid it would mess up my garage software. Any ideas.

Emeralda
02-12-2012, 02:24 PM
The links here: http://prntscr.com/62pvp lead me to http://prntscr.com/62pwg

Nirjonadda
02-15-2012, 04:51 PM
Thanks for the vb4 release...working with 4.1.10

Seahunter
02-22-2012, 01:47 PM
Vbulletin 4.1.10 and newest version of YaaS awards and Automation.

I've seen the question asked a few times and it seems like several members have this difficulty but I couldn't find an answer to the problem yet.

No PM or Email is sent out when an award is given and if you attempt to edit the PM or Email content in the AdminCP you get the error "No Phrases Matched Your Query". If you hover over the links in the AdminCP it looks like the phrase is "award_pm" but I can't locate that phrase in the phrase manager. Am I doing something incorrectly? Fantastic MOD,Thank you for any assistance.

visageiii
03-02-2012, 12:04 AM
I get this error when requesting an award...
There's some error when sending your award request. Please contact site's administrator for assistant.

and I get this when granting the aware Warning: mysql_insert_id() [function.mysql-insert-id]: A link to the server could not be established in [path]/admincp/award.php on line 595

Scyther
03-02-2012, 01:38 AM
installed on vb 4.1.9, but don't see the Award system on left panel in admin cp.
also there are no awards under Award tab on Navbar!!

What am i missing?

Scyther
03-03-2012, 02:07 PM
is there no support for this Mod?
Coder is not replying!!
anyone else can help me?

mIQe
03-03-2012, 09:56 PM
Don't hold your breath. I've have asked simple questions on how to use this mod as well as support questions. No answer and it's been many weeks now.

Scyther
03-04-2012, 01:24 AM
i see. no one cares i guess

Mobo
03-04-2012, 06:51 AM
This is virtually the same mod (https://vborg.vbsupport.ru/showthread.php?t=265893), but has a little better support. You might try running that one in stead.

If I did not already have some many awards issued under this mod, I'd make the switch to that one.

squidsk
03-06-2012, 02:36 AM
installed on vb 4.1.9, but don't see the Award system on left panel in admin cp.
also there are no awards under Award tab on Navbar!!

What am i missing?

Have you enabled it in the YAAS settings?

BWG22
03-06-2012, 07:31 AM
So any reason after I upgraded to 4.1.10, I get this on the Awards.php?


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

Scyther
03-08-2012, 04:14 AM
Have you enabled it in the YAAS settings?


if you are talking about the Award system settings under settings>options...YES, its enabled.

Still there is no Award menu at the left!!

cen1
03-09-2012, 04:36 PM
Cypher please check your bug reports mail and add all the reported bugs to redmine. We did a few tests on latest vb4 and there are just a couple of things that need to be fixed, one is the error upon installation that was already reported here and solution is already known too.
The other error is display in user profile which is a little messed up.

We have updated our forum from vb3 to vb4 5 months ago and we're still waiting for a working latest vb4 version so we can port the old database and include the system to our forum.

I hope it's done soon..if not we'll lose 1 year of awards :S

squidsk
03-09-2012, 08:02 PM
Cypher please check your bug reports mail and add all the reported bugs to redmine. We did a few tests on latest vb4 and there are just a couple of things that need to be fixed, one is the error upon installation that was already reported here and solution is already known too.
The other error is display in user profile which is a little messed up.

We have updated our forum from vb3 to vb4 5 months ago and we're still waiting for a working latest vb4 version so we can port the old database and include the system to our forum.

I hope it's done soon..if not we'll lose 1 year of awards :S

To fix the display problem on the user profiles you need to do the following:
UPDATE FOR: 4.0.8 - 4.1.3
(TAKE BACKUP BEFORE ANY REPLACE)

1- Find the template (memberinfo_block_myawards) and replace it all
<div id="view-myawards" class="<vb:if condition="$selected_tab == 'myawards'">selected_view_section<vb:else />view_section</vb:if>">

<div class="blocksubhead subsectionhead userprof_headers userprof_headers_border">
{vb:rawphrase award_showcase} - {vb:raw $block_data[num]} {vb:rawphrase awards} <vb:if condition="$vboptions[aw_points]"> - {vb:raw $block_data[total_points]} {vb:rawphrase points}</vb:if>
</div>

<div class="blockbody">
<table width="100%">
<tr align="center">
<vb:if condition="$vboptions[aw_showicon]"><th class="blocksubhead" nowrap="nowrap">{vb:rawphrase award_icon}</th></vb:if>
<vb:if condition="$vboptions[aw_showimage]"><th class="blocksubhead" nowrap="nowrap">{vb:rawphrase award_image}</th></vb:if>
<th class="blocksubhead" width="100%">{vb:rawphrase award_description}</th>
</tr>
{vb:raw $block_data[myawards]}
</table>
</div>
</div>



2- From(Plugin Manager)
Find (YAAS - Profile Tab) and disactive it.


3- From (plugin manager)
Find (YAAS in Member Profile - Profile) >> EDIT >> Replace it all
$blocklist['myawards'] = array(
'class' => 'MyAwards',
'title' => $vbphrase['my_awards'],
'options' => array(
'pagenumber' => $vbulletin->GPC['pagenumber']
),
'hook_location' => 'profile_tabs_last',
'wrap' => false
);

require_once('./global.php');
global $vbulletin;
require_once(DIR . '/includes/class_bbcode.php');
$bbcode_parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());

class vB_ProfileBlock_MyAwards extends vB_ProfileBlock
{
var $template_name = 'memberinfo_block_myawards';

function confirm_empty_wrap()
{
return false;
}

function confirm_display()
{
return ($this->block_data['myawards'] != '');
}

function prepare_output($id = '', $options = array())
{
global $show, $vbphrase, $stylevar, $vbcollapse, $bgclass, $vbulletin;

require_once(DIR . '/includes/class_bbcode.php');
$bbcode_parser = new vB_BbCodeParser($this->registry, fetch_tag_list());


$result = $this->registry->db->query_read('
SELECT
*
FROM
' . TABLE_PREFIX . 'award_user AS award_user
LEFT JOIN ' . TABLE_PREFIX . 'award AS award USING (award_id)
WHERE
award_user.userid = ' . $this->profile->userinfo['userid'] . '
AND award.award_active = "1"
ORDER BY
'.$vbulletin->options['aw_awardorder'].'
');

if (($vbulletin->options['aw_points']) AND ($this->profile->userinfo['userid']))
{
$userpoints = $this->registry->db->query_read('
SELECT a.*, au.*, SUM(award_pointvalue) AS TotalPoints
FROM ' . TABLE_PREFIX . 'award a, ' . TABLE_PREFIX . 'award_user au
WHERE (au.userid = '.$this->profile->userinfo['userid'].') AND (a.award_id=au.award_id) AND (a.award_active = "1")
GROUP BY au.userid
');

while ($array = $this->registry->db->fetch_array($userpoints))
{
$this->block_data['total_points'] = $array['TotalPoints'];
}
}

$num = $this->block_data['num'] = $this->registry->db->num_rows($result);

$this->block_data['myawards'] = '';

if ($num > 0)
{
// Display Awards
while ($award = $this->registry->db->fetch_array($result))
{
exec_switch_bg();

$award['award_desc'] = $bbcode_parser->parse($award['award_desc']);
$award['issue_reason'] = $bbcode_parser->parse($award['issue_reason']);

$award_issue_date = vbdate($this->registry->options['dateformat'], $award['issue_time'], true);
$award_issue_time = vbdate($this->registry->options['timeformat'], $award['issue_time']);

//- VB3 -// eval('$this->block_data[\'myawards\'] .= "' . fetch_template('awards_userawards_bit') . '";');
//- BEGIN VB4 -//
$templater = vB_Template::create('awards_userawards_bit');
$templater->register('award', $award);
$templater->register('award_issue_date', $award_issue_date);
$templater->register('award_issue_time', $award_issue_time);
$this->block_data['myawards'] .= $templater->render();
//- END VB4 -//
}
}
}
}


Good luck :)

After completing the above the awards plugin works fine, at least as long as you don't use recommend or request awards.

Scyther
03-10-2012, 04:53 PM
does anyone know why i can't see the Award Menu in the left panel of Admin CP??

cen1
03-11-2012, 10:09 PM
To fix the display problem on the user profiles you need to do the following:


After completing the above the awards plugin works fine, at least as long as you don't use recommend or request awards.

Ok will try that. Still.. It would be nice to see official version out for 4.1.x. there is not that much to fix really. I hope dev comes around.

Scyther
03-12-2012, 09:06 AM
ok,...uninstall and reinstall worked...thanks

speedracer68
03-19-2012, 04:16 PM
I wonder if supporting the coder would help? I for one am willing to make a donation if it would help get this updated. I understand it takes time to create mods like this and mods like this are what make my forum. Anyone else?

Patriots1049
03-21-2012, 12:20 PM
Is there a way to increase the number of awards displayed in the user profile? Right now, a user can have 25 awards and on 18 or 19 will display down the page...

squidsk
03-21-2012, 02:46 PM
Is there a way to increase the number of awards displayed in the user profile? Right now, a user can have 25 awards and on 18 or 19 will display down the page...
Yes, in admincp go the awards settings page and change the maximum number of awards to be displayed.

Mobo
03-21-2012, 02:59 PM
My profile pages show at least 26 medals.

Mobo
03-21-2012, 03:02 PM
There is not a setting that says it controls the diplay on the profile tab... is it the same setting that controls the postbit display? Might need to clarify that in the description.

Amaury
03-24-2012, 02:49 AM
Could someone be kind enough to link me to the post with the Awards tab bug fix? I've searched this, and I can't find it.

sadiq6210
03-24-2012, 09:06 AM
Could someone be kind enough to link me to the post with the Awards tab bug fix? I've searched this, and I can't find it.


https://vborg.vbsupport.ru/showthread.php?p=2189701#post2189701

Amaury
03-24-2012, 09:34 AM
https://vborg.vbsupport.ru/showthread.php?p=2189701#post2189701

Sean, our owner, got the fix, but now we're seeing problems.

We're getting a parse error, the Awards tab isn't even there, and avatars are out of the box.

Here's a link to my profile (http://www.kh-mediaflare.net/member.php?18-Amaury) for an example.

Edit: Post Message and Advanced Editor are now up a bit and overlapping.

Edit 2: I disabled all YAAS plugins and profiles are back to normal, but it seems the fix didn't work, because when I enabled the plugin for user profile tabs, Awards still didn't have a tab.

sadiq6210
03-25-2012, 05:12 AM
Sean, our owner, got the fix, but now we're seeing problems.

We're getting a parse error, the Awards tab isn't even there, and avatars are out of the box.

Here's a link to my profile (http://www.kh-mediaflare.net/member.php?18-Amaury) for an example.

Edit: Post Message and Advanced Editor are now up a bit and overlapping.

Edit 2: I disabled all YAAS plugins and profiles are back to normal, but it seems the fix didn't work, because when I enabled the plugin for user profile tabs, Awards still didn't have a tab.

If you want you can pm me with an admin account so I can check and solve the problem.

andie215
03-27-2012, 05:49 PM
Hi, i have a conflict with itrader using this mod too. Ive only noticed since upgrading my forum to version 4.1.11. The itrader profile tab is empty but only for some of my members.

squidsk
03-27-2012, 07:06 PM
Why do assume its a conflict with this mod and not just a conflict with itrader and vbulletin? Have you applied the profile tab fixes from the post above yours?

andie215
03-27-2012, 08:55 PM
Why do assume its a conflict with this mod and not just a conflict with itrader and vbulletin? Have you applied the profile tab fixes from the post above yours?

Perhaps i'm wrong to assume, so i'm sorry. The fix didnt work for me :(

WoODoO
04-09-2012, 08:16 PM
how to solve this problem:
There's some error when sending your award request. Please contact site's administrator for assistant.

other problem:
https://vborg.vbsupport.ru/external/2012/04/1.png?1334005674

jeryp
04-10-2012, 09:02 AM
I am getting this error as well.
There's some error when sending your award request. Please contact site's administrator for assistant.

It does put the request in the Moderation que though. So appears to be working.
Just giving this message and Not what it should be?

Crotan
04-10-2012, 06:08 PM
Here's a fix that fixes both issues:

1) Disable/delete the YAAS - Profile Tab Plugin that is attached to the member_complete hook (in other words my previous fix for problem 1 is not required anymore). If this isn't done you will get two Awards tabs on profile pages.

2) Make the following edits (all text in blue needs to be added) to the YAAS in Member Profile - Profile plugin that is attached to the member_build_blocks_start hook:


$blocklist['myawards'] = array(
'class' => 'MyAwards',
'title' => $vbphrase['awards'],
'options' => array(
'pagenumber' => $vbulletin->GPC['pagenumber']
),
'hook_location' => 'profile_tabs_last',
'wrap' => false
);


I don't think this is a proper fix. Disabling YAAS - Profile Tab Plugin will remove the working tab.

Your addition to YAAS in Member Profile - Profile just makes the phantom tab that appears in the wrong spot now have the awards text. Really I would like to remove this phantom tab and leave the working one alone.

I fixed the inactive tab and active tab status by adding the missing dd class "<dd class="userprof_moduleinactive">" that YAAS - Profile Tab was missing. So I have mine working on inactive and active status, just want to get rid of the phantom tab.

Anyone know how to do that?

squidsk
04-10-2012, 06:41 PM
You didn't follow the first step. Disable the indicated plugin and it will remove the phantom tab. The phantom tab, and that plugin, is a remnant of the old way that vb4 dealt with tabs. This was changed in Vb4.1 but this plugin has not been updated since then.

There's also a third fix, step 1 in post https://vborg.vbsupport.ru/showpost.php?p=2189701&postcount=742, the second and third steps are the same as the ones I'd posted earlier.

You also potentially have other conflicts as you're using a custom style which have other issues that are causing problems. Always test with the vbulletin default style.

Crotan
04-10-2012, 08:39 PM
You didn't follow the first step. Disable the indicated plugin and it will remove the phantom tab. The phantom tab, and that plugin, is a remnant of the old way that vb4 dealt with tabs. This was changed in Vb4.1 but this plugin has not been updated since then.

There's also a third fix, step 1 in post https://vborg.vbsupport.ru/showpost.php?p=2189701&postcount=742, the second and third steps are the same as the ones I'd posted earlier.

You also potentially have other conflicts as you're using a custom style which have other issues that are causing problems. Always test with the vbulletin default style.

Sorry my screen shots weren't reflective of what I was saying.

Deactivating YAAS - Profile Tab doesn't get rid of the phantom tab that was appearing out of place, it gets rid of the tab that I think was working correctly with the proper dd class fix.

By adding 'hook_location' => 'profile_tabs_last' you move the phantom tab that was once appearing out of place up into the proper tab placement.

It looks to be working

squidsk
04-10-2012, 09:23 PM
The "phantom tab" is the correct tab, the other one is the bad tab that doesn't work properly.

Amaury
04-10-2012, 11:49 PM
The "phantom tab" is the correct tab, the other one is the bad tab that doesn't work properly.

We're still having this problem ourselves. Our owner even updated it with the fixed version, and now, not only is Awards still tabless, with the tab being at the bottom, but we get syntax errors, which I fixed by disabling YAAS.

squidsk
04-11-2012, 01:51 PM
If you'd be willing to grant me access I'd be willing to take a look and try and fix it. I've used the fix I mentioned on three separate vb 4.x installs and its worked all three times so I don't see any reason why it shouldn't work unless there's a conflict with another plugin.

Amaury
04-11-2012, 09:25 PM
Thank you, Squid, for fixing it.

While I'm here, I've got another question regarding this. Is there a way to change the Current Activity text for it? I would like it to be Viewing Award System, with Award System being a link, and I tried doing a search in Phrase Manager, but it didn't find anything.

http://i101.photobucket.com/albums/m62/AmauryGarcia/YAASActivity.png

Hikarin
04-14-2012, 04:42 AM
I have Yet Another Award System enabled.
Thank you for making this. I really have loved this programme ever since I saw it on some old Vb3 forums. ^_^ I glad that my forum finally has it too.

But.... what exactly's going on here? O_o
https://vborg.vbsupport.ru/attachment.php?attachmentid=137765&stc=1&d=1334382392

mgurain
04-14-2012, 07:36 AM
Is is compatible with latest version 4.1.12 ?
Could you update it for that ?

Regards,,

Crotan
04-14-2012, 04:51 PM
I have Yet Another Award System enabled.
Thank you for making this. I really have loved this programme ever since I saw it on some old Vb3 forums. ^_^ I glad that my forum finally has it too.

But.... what exactly's going on here? O_o
https://vborg.vbsupport.ru/attachment.php?attachmentid=137765&stc=1&d=1334382392

https://vborg.vbsupport.ru/showpost.php?p=2189701&postcount=742

squidsk
04-15-2012, 06:52 PM
I have Yet Another Award System enabled.
Thank you for making this. I really have loved this programme ever since I saw it on some old Vb3 forums. ^_^ I glad that my forum finally has it too.

But.... what exactly's going on here? O_o
https://vborg.vbsupport.ru/attachment.php?attachmentid=137765&stc=1&d=1334382392

See the posts above yours by me on the page for how to fix this, starting with post 1069.

santi00
04-19-2012, 07:52 PM
Hello everyone, I wanted to ask you if you think you could make a retroactive award. For example, if I create a award of the 100th post inserted at the time of creation but there are already users with 100 posts, you can automatically assign the award ?
I try but there isn't nothing to do...the award not display

squidsk
04-19-2012, 08:15 PM
No, the awards are not retroactive, you'll need to do a manual insert query on the database to achieve what you're after. I posted a sample query either in this thread or the one for the vb3.8 version of this mod that you could use.

marccap
04-19-2012, 10:38 PM
Hi,

Eveything set up except automatic awards. How are these set up with the software - eg what goes in the bottom for for example 1000 posts:

Automation Task Name -
Award ID to Automate -

Thanks

marccap
04-28-2012, 03:18 AM
bump

BWG22
05-01-2012, 05:59 PM
So no answer for me?

MikePaceRocks
05-01-2012, 10:48 PM
When will a version for 4.1.12 be available?

Nemrak
05-02-2012, 06:13 AM
Hallo,
I tried to install Award System and received the following error:

https://vborg.vbsupport.ru/external/2012/05/40.png

My vbulletin version is 4.1.12.

What should I do?

MikePaceRocks
05-02-2012, 07:41 AM
Hallo,
I tried to install Award System and received the following error:

https://vborg.vbsupport.ru/external/2012/05/40.png

My vbulletin version is 4.1.12.

What should I do?

I got the EXACT same database error when I tried to install it. I also am running 4.1.12.

squidsk
05-09-2012, 03:18 PM
Hallo,
I tried to install Award System and received the following error:

https://vborg.vbsupport.ru/external/2012/05/40.png

My vbulletin version is 4.1.12.

What should I do?

I got the EXACT same database error when I tried to install it. I also am running 4.1.12.


I think its an issue with the install script. Do both of your forums have a table prefix?

Dave234
05-13-2012, 06:55 PM
I downloaded the "YaAS-4.0.2-PL1" zip file, did what the instructions told me, and it seemed to upload fine. It added the "Awards" tab to my forum. HOWEVER, when I click the "Awards" tab, it takes me to a page with no content. It says:

404 Error File Not Found
The page you are looking for might have been removed,
had its name changed, or is temporarily unavailable.

Can you please assist?? This is very confusing.

squidsk
05-15-2012, 02:10 AM
It sounds like you didn't upload the files to the correct location, or there was an error with the installation.

Dave234
05-16-2012, 01:26 AM
How do I upload? I see there are three files. Two folders and one Word doc.

Dave234
05-16-2012, 01:28 AM
I just uploaded the one folder.

squidsk
05-16-2012, 02:09 PM
How do I upload? I see there are three files. Two folders and one Word doc.

I just uploaded the one folder.

You need to upload the contents of the upload folder to your forum's root folder (i.e. the same location where the index.php for the forum is lcoated).

Dave234
05-17-2012, 01:09 AM
I did that for the one folder. Do I need to do it for the other one also?

SN1PERCITY
05-18-2012, 03:53 AM
so will this be fixed for 4.1.12. just wondering cause i had it for 4.1.5 or .6 and it was great could we get this fixed for it please!

Crotan
05-18-2012, 07:10 PM
so will this be fixed for 4.1.12. just wondering cause i had it for 4.1.5 or .6 and it was great could we get this fixed for it please!

Still working here on 4.1.12?

tomrep
05-19-2012, 11:11 PM
when will it be released for 4.1.12

marccap
05-20-2012, 12:48 AM
It works on 4.1.12 - check it out on my site

Dave234
05-21-2012, 12:35 PM
Do I need to upload both of the folders?

BWG22
05-22-2012, 04:39 AM
I uninstalled the plug-in, and tried to reinstall and got this....

MySQL Error : Duplicate column name 'award_allowrecommend'

How to fix please?

Dave234
05-22-2012, 03:06 PM
There is an error in my upload. I tried uploading both folders via ftp.

As soon as I tried uploading the "product-yet_another_award_system" from the "YaAS-4.0.2-PL1" folder, it gave me a database error.

In my AdminCP, Plugin Manager, Edit Product screen, these are what appear under the "Install Code":

Version 1.0.0:

$db->reporterror = 0;
// NEW INSTALL CODE
if ($installed_version == null) {

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "award_user ADD award_cgroup VARCHAR( 15 )");
echo "<font size=\"1\">Alter table - award_user - criteria group</font><br />";

}



Version 1.0.2:
// CREATE AWARD AUTOMATION TABLE
$db->reporterror = 0;

$db->query_write("CREATE TABLE " . TABLE_PREFIX . "award_automation (
award_automation_id int(10) unsigned NOT NULL auto_increment,
auto_active int(1) NOT NULL,
auto_name varchar(32) NOT NULL,
auto_issuereason varchar(255) NOT NULL,
auto_type varchar(32) NOT NULL,
auto_criteria int(10) NOT NULL,
auto_awardid int(10) NOT NULL,
PRIMARY KEY (award_automation_id)
)
");
echo "<font size=\"1\">Added Table - Award Automation</font><br />";

squidsk
05-22-2012, 07:15 PM
Do I need to upload both of the folders?

No just the contents of the upload folder, if you uploaded the contents correctly and installed the xml correctly it should work.

I uninstalled the plug-in, and tried to reinstall and got this....

MySQL Error : Duplicate column name 'award_allowrecommend'

How to fix please?

What version did you uninstall? If you started with a 4.0.2PL1 version, the only error you should get when uninstalling and reinstalling is related to some missing uninstall code for the award_requests table.

That being said, if you run the following sql commands from admincp it should remove any leftover stuff.


show tables
drop table *award*


The first command will list all your tables, then you'll need to use the second command as many times as needed, by replacing the *award* with the name of an award table that was left around by mistake.

squidsk
05-22-2012, 07:15 PM
There is an error in my upload. I tried uploading both folders via ftp.

As soon as I tried uploading the "product-yet_another_award_system" from the "YaAS-4.0.2-PL1" folder, it gave me a database error.

In my AdminCP, Plugin Manager, Edit Product screen, these are what appear under the "Install Code":

Version 1.0.0:

$db->reporterror = 0;
// NEW INSTALL CODE
if ($installed_version == null) {

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "award_user ADD award_cgroup VARCHAR( 15 )");
echo "<font size=\"1\">Alter table - award_user - criteria group</font><br />";

}



Version 1.0.2:
// CREATE AWARD AUTOMATION TABLE
$db->reporterror = 0;

$db->query_write("CREATE TABLE " . TABLE_PREFIX . "award_automation (
award_automation_id int(10) unsigned NOT NULL auto_increment,
auto_active int(1) NOT NULL,
auto_name varchar(32) NOT NULL,
auto_issuereason varchar(255) NOT NULL,
auto_type varchar(32) NOT NULL,
auto_criteria int(10) NOT NULL,
auto_awardid int(10) NOT NULL,
PRIMARY KEY (award_automation_id)
)
");
echo "<font size=\"1\">Added Table - Award Automation</font><br />";


What is the database error you are getting?

Dave234
05-22-2012, 09:59 PM
Alter table - award
Alter table - usergroup

Tables Altered Successfully

Alter table - 2.1.3
Alter table - 2.1.4





Database error



The Social Hulk Espa?ol database has encountered a problem.




--------------------------------------------------------------------------------




Please try the following: •Load the page again by clicking the Refresh button in your web browser.
•Open the www.socialhulk.com home page, then try to open another page.
•Click the Back button to try another link.



The www.socialhulk.com forum technical staff have been notified of the error, though you may contact them if the problem persists.




We apologise for any inconvenience.

Dave234
05-22-2012, 10:00 PM
Database error in vBulletin 4.1.11:

Invalid SQL:
ALTER TABLE award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

MySQL Error : Duplicate column name 'award_allowrecommend'
Error Number : 1060
Request Date : Tuesday, May 22nd 2012 @ 04:58:59 PM
Error Date : Tuesday, May 22nd 2012 @ 04:58:59 PM
Script : http://www.socialhulk.com/spanish/admincp/plugin.php?do=productimport
Referrer : http://www.socialhulk.com/spanish/admincp/plugin.php?do=productadd
IP Address : (hidden because confidential?)
Username : El Luchador Rubio
Classname : vB_Database
MySQL Version : 5.1.63-community-log

Dave234
05-23-2012, 10:56 AM
Does this make any sense?

BWG22
05-23-2012, 04:47 PM
Ok, the SQL command worked and it installed, but now it brings me back to the awards main page getting this message.

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

FTG LIQUID CL
05-23-2012, 11:29 PM
keep getting this message when i try to upload the xml product

Database error in vBulletin 4.1.12:

Invalid SQL:
ALTER TABLE vbaward ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

MySQL Error : Duplicate column name 'award_allowrecommend'
Error Number : 1060
Request Date : Wednesday, May 23rd 2012 @ 06:25:31 PM
Error Date : Wednesday, May 23rd 2012 @ 06:25:32 PM
Script : http://fataltalentgaminglive.com/admincp/plugin.php?do=productimport
Referrer : http://fataltalentgaminglive.com/admincp/plugin.php?do=productadd
IP Address : 75.137.26.203
Username : Admin
Classname : vB_Database
MySQL Version : 5.1.63-community-log

squidsk
05-24-2012, 02:22 PM
Ok, the SQL command worked and it installed, but now it brings me back to the awards main page getting this message.

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

What exactly were you doing that caused this error to occur? The only reference I can find to this function within the awards files is in a location that does not make use of the file includes/adminfunctions.php.

keep getting this message when i try to upload the xml product

Database error in vBulletin 4.1.12:

Invalid SQL:
ALTER TABLE vbaward ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

MySQL Error : Duplicate column name 'award_allowrecommend'
Error Number : 1060
Request Date : Wednesday, May 23rd 2012 @ 06:25:31 PM
Error Date : Wednesday, May 23rd 2012 @ 06:25:32 PM
Script : http://fataltalentgaminglive.com/admincp/plugin.php?do=productimport
Referrer : http://fataltalentgaminglive.com/admincp/plugin.php?do=productadd
IP Address : 75.137.26.203
Username : Admin
Classname : vB_Database
MySQL Version : 5.1.63-community-log

Are you upgrading or re-installing the plugin? If re-installing then follow my instructions on the last page about deleting tables that weren't properly uninstalled. If upgrading what version are you upgrading from?

BWG22
05-24-2012, 02:59 PM
What exactly were you doing that caused this error to occur? The only reference I can find to this function within the awards files is in a location that does not make use of the file includes/adminfunctions.php.

Didn't do anything I wasn't supposed to. It was the error I had before when I upgraded my vB to 4.1.11. It just started giving me that error after the upgrade completed. Since then, I uninstalled it, dropped the tables, and re-installed and I still get the error.

squidsk
05-24-2012, 03:05 PM
Didn't do anything I wasn't supposed to. It was the error I had before when I upgraded my vB to 4.1.11. It just started giving me that error after the upgrade completed. Since then, I uninstalled it, dropped the tables, and re-installed and I still get the error.
What other plugins are you running? I'm on a clean vb4.1.12PL1 and don't get that message, nor did I get it when the forum was on 4.1.10.

As I said the only place in the awards code that creates its own construct_depth_mark function is in the awards.php file, which does not require adminfunctions.php nor does in require a file which requires adminfunctions.php.

I was specifically asking what actions you'd taken (e.g. trying to view/change the awards settings) that causes that error.

Dave234
05-24-2012, 03:06 PM
Mine is the same (please see my last post). Can you please assist?

squidsk
05-24-2012, 03:54 PM
Did you read my response to FTG LIQUID CL?

FTG LIQUID CL
05-24-2012, 06:16 PM
yes i will work on it

FTG LIQUID CL
05-24-2012, 06:21 PM
its the first time i have installed this product,i have tried to re install the xml file but keep getting that message

squidsk
05-24-2012, 06:28 PM
Follow my instructions on the previous page how to delete the previous install correctly. First uninstall the plugin if it shows up in the plugin list, then you'll need to drop the three tables (if all of them were created) before trying to re-install.

mgurain
05-24-2012, 07:31 PM
Is this mod an upgrade to this ? :
https://vborg.vbsupport.ru/showthread.php?t=196244
Since I was using 3.8 version and kept for today disabled when it came not working,
and now I want to upgrade to the latest one and not loose the previous awards given.

Thanks,,

squidsk
05-24-2012, 07:42 PM
Yes it is.

BWG22
05-24-2012, 10:48 PM
What other plugins are you running? I'm on a clean vb4.1.12PL1 and don't get that message, nor did I get it when the forum was on 4.1.10.

As I said the only place in the awards code that creates its own construct_depth_mark function is in the awards.php file, which does not require adminfunctions.php nor does in require a file which requires adminfunctions.php.

I was specifically asking what actions you'd taken (e.g. trying to view/change the awards settings) that causes that error.

I'll disable the other plugins to see if maybe they are interfering, but I had done nothing to awards settings. Just went to forums/awards.php after the install and that's what I got.

Dave234
05-24-2012, 11:43 PM
Follow my instructions on the previous page how to delete the previous install correctly. First uninstall the plugin if it shows up in the plugin list, then you'll need to drop the three tables (if all of them were created) before trying to re-install.

I wish I understood what you say on the previous page. I'm nowhere near that advanced on vbulletin. I am a complete novice here. Couldn't I just uninstall the thing from my plugin manager, and then re-install it through the ftp like I'd done the first time?

BWG22
05-25-2012, 03:27 AM
Problem Solved. It was the vbSSO plugin.

squidsk
05-25-2012, 04:14 PM
I wish I understood what you say on the previous page. I'm nowhere near that advanced on vbulletin. I am a complete novice here. Couldn't I just uninstall the thing from my plugin manager, and then re-install it through the ftp like I'd done the first time?

Unfortunately not, there's an error in the uninstallation code, actually an omission, that prevents the plugin from uninstalling correctly.

First uninstall YAAS from the product manager.

Then to do what I posted on the previous page, in admincp go to Maintenance->Execute SQL Query

When prompted run the following query:
show tables

This will give you the list of all tables in your db, look for the ones that have awards in their name, there should be between one and three of them, most likely three. In my db the tables are called:

award
award_cat
award_requests

The names might be different in your db, especially if your tables have a prefix. Take note of the names, and then run drop table queries, one per table, to remove the tables.

So if I was removing the three tables from my db I'd run the following three queries:
drop table award
drop table award_cat
drop table award_requests

Then I could reinstall YAAS from scratch.

squidsk
05-25-2012, 04:42 PM
Problem Solved. It was the vbSSO plugin.

You could also try the solution mentioned here (http://www.dragonbyte-tech.com/f65/yaas-4-0-2-conflict-1092/index2.html#post6252).

Let me know if that works.

Skermefaten
06-01-2012, 01:45 AM
Can someone explain to me how to use these features?

https://vborg.vbsupport.ru/

I've tried toying around with them but haven't had any luck.

squidsk
06-01-2012, 08:52 PM
The explanations give are pretty straight forward, what about them are you not understanding?

Skermefaten
06-01-2012, 11:13 PM
The explanations give are pretty straight forward, what about them are you not understanding?

Well I mean, I put in the forum id and the thread id. Perhaps I'm messing up the latter. It's only a matter of those digits you see on the thread's url, correct?

Kirkus
06-02-2012, 08:43 PM
Is anyone running this on vBulletin 4.2?

I've been using YAAS for years and am looking at an upgrade from vB 3.8.7 --> 4.2. But I have to be able to keep all the awards that have been given out over the years or my members will mutiny. ;)

Crotan
06-02-2012, 09:01 PM
Is anyone running this on vBulletin 4.2?

I've been using YAAS for years and am looking at an upgrade from vB 3.8.7 --> 4.2. But I have to be able to keep all the awards that have been given out over the years or my members will mutiny. ;)

There's a few bugs here and there for this mod, and it hasn't been touched by the original author in ages. Beyond the the existing bugs, you shouldn't have any issues. I'd wait to hear from someone using this with 4.2

Though you may be better off going over to https://vborg.vbsupport.ru/showthread.php?t=265893&highlight=ranks

Thunderbird8
06-04-2012, 05:42 AM
Going to the vB4 version from the vB3 one won't harm existing awards. The only issue that I can see on 4.2 is that the Awards tab disappears from the navbar, but with the Navigation Manager, it is easy enough to re-add it.

DiageoLiam
06-04-2012, 01:23 PM
Also receiving SQL error upon installing. Any fixes found yet?

CubicWebs
06-08-2012, 01:05 PM
Importing Product, Please Wait...

[:]
Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award_cat' doesn't exist in [path]/includes/class_core.php on line 1391
Adding Awards Tables


Warning: mysqli_query() [function.mysqli-query]: (42000/1064): 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 'TYPE=MyISAM' at line 10 in [path]/includes/class_core.php on line 1391
Added Table - award

Warning: mysqli_query() [function.mysqli-query]: (42000/1064): 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 'TYPE=MyISAM' at line 8 in [path]/includes/class_core.php on line 1391
Added Table - award_user

Warning: mysqli_query() [function.mysqli-query]: (42000/1064): 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 'TYPE=MyISAM' at line 9 in [path]/includes/class_core.php on line 1391
Added Table - award_cat

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award_cat' doesn't exist in [path]/includes/class_core.php on line 1391
Inserted Default Catergory to table - award_cat

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391
Inserted Default Awards to table - award

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391
Alter table - award

Warning: mysqli_query() [function.mysqli-query]: (42S21/1060): Duplicate column name 'awardpermissions' in [path]/includes/class_core.php on line 1391
Alter table - usergroup

Tables Altered Successfully


Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award_user' doesn't exist in [path]/includes/class_core.php on line 1391
Alter table - 2.1.3

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award_user' doesn't exist in [path]/includes/class_core.php on line 1391
Alter table - 2.1.4

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.award' doesn't exist in [path]/includes/class_core.php on line 1391
Database error
The HabbFever database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the habbfeverforum.net home page, then try to open another page.
Click the Back button to try another link.
The habbfeverforum.net forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.

Database error in vBulletin 4.2.0:


Invalid SQL:
ALTER TABLE award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;


MySQL Error : Table 'habbfeve_sarah.award' doesn't exist
Error Number : 1146
Request Date : Friday, June 8th 2012 @ 08:01:10 AM
Error Date : Friday, June 8th 2012 @ 08:01:10 AM
Script : http://habbfeverforum.net/admincp/plugin.php?do=productimport
Referrer : http://habbfeverforum.net/admincp/plugin.php?do=productadd
IP Address : **********
Username : ***
Classname : vB_Database_MySQLi
MySQL Version : 5.5.23-55

zapiy
06-08-2012, 05:09 PM
Is there a Vbadvanced block available for this?

Hamish Gill
06-09-2012, 11:32 AM
Ive just tried to install on vb4.2 the import screen just goes blank
tried just dropping it into the right folder on the ftp and nothing ... any thoughts?

Hamish Gill
06-09-2012, 11:35 AM
scuse my stupidity ... uploaded then tried importing from server and got a db error
any thoughts?

Database error in vBulletin 4.2.0:

Invalid SQL:
ALTER TABLE vb_award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

MySQL Error : Table 'realphot_forum.vb_award' doesn't exist
Error Number : 1146

CubicWebs
06-09-2012, 03:07 PM
scuse my stupidity ... uploaded then tried importing from server and got a db error
any thoughts?

Database error in vBulletin 4.2.0:

Invalid SQL:
ALTER TABLE vb_award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

MySQL Error : Table 'realphot_forum.vb_award' doesn't exist
Error Number : 1146


You've got a smaller one than me lol, erm I don't think this coder is active anymore :(

Hamish Gill
06-09-2012, 05:37 PM
... shame ... yes, just read back a few pages :(
ah well ... ill try something else

edytwinky
06-12-2012, 01:50 AM
On the user's profile page, does anybody have issues with the tab that says awards not appearing properly?

Crotan
06-12-2012, 03:19 AM
On the user's profile page, does anybody have issues with the tab that says awards not appearing properly?

Existing bug, sadly developer is AWOL, but the fix should still stand.

https://vborg.vbsupport.ru/showpost.php?p=2189701&postcount=742

UK CHI3F
06-13-2012, 04:40 PM
For those asking if it works on vb 4.2 the answer is yes. check out www.xboxplayers.com to see

The issue i have might be with the YAAS or something else my background image is correct on all of my pages except the YAAS, any ideas?

squidsk
06-15-2012, 12:21 AM
Do the fixes from the post above yours. One of them is for an unclosed div tag which will cause all sort of problems, hopefully yours is one of them.

UK CHI3F
06-15-2012, 03:10 PM
squidsk, thanks for the advice all done but to no avail still no background

Any other ideas?

Crotan
06-15-2012, 03:34 PM
squidsk, thanks for the advice all done but to no avail still no background

Any other ideas?

link the page that is messed up

UK CHI3F
06-16-2012, 04:23 AM
<a href="http://www.xboxplayers.co.uk/site/awards.php?tabid=39" target="_blank">http://www.xboxplayers.co.uk/site/awards.php?tabid=39</a> is the issue page all others wok as they should.

Thanks

Psyd0x
06-16-2012, 10:23 PM
When people request award/recommend award they get error any solution for this?

squidsk
06-17-2012, 02:25 AM
Its a bug in the program. If you go to admincp and look at the request/recommendations the request has probably been processed.

UK CHI3F
06-17-2012, 09:28 AM
When people request award/recommend award they get error any solution for this?

Agreed squidsk thats what happened when we used to get the same error

We had that issue when we first installed the mod but it lasted about a week before it dissappeared, probably something to do with the settings in the admin panel.
Below is a link to our settings

http://www.xboxplayers.co.uk/site/images/awardsettings.jpg

Hope this helps solve the problem.

P.S. next time you have an issue and would like help dont create a user and spam stuff on our awards page. If you had asked we would have helped. It creates unnecessary work for people.

edytwinky
06-17-2012, 12:58 PM
On the user's profile page, does anybody have issues with the tab that says awards not appearing properly?

Existing bug, sadly developer is AWOL, but the fix should still stand.

https://vborg.vbsupport.ru/showpost.php?p=2189701&postcount=742

Thanks Crotan! That helped!

squidsk
06-19-2012, 01:55 AM
I was fixing various bugs for YaAS so I decided to bundle it up into a new version. This is not official, but as the plugin says re-usable code I can release it for the benefit of the community. These changes should be compatible with all VB 4 versions with one caveat it does not support the new navigation manager from VB 4.2.

The mostly complete list of fixes/changes is:
4.0.3 RELEASE: (06/13/2012)
* Fixed - Various install/uninstall code issues
* Fixed - User profile tab graphical issues
* Fixed - Recommend/request award showing an error message, in certain circumstances, when there's no error
* Fixed - Various links not using properly escaped & (i.e. should be &amp; instead of &)
* Fixed - Code that generated invalid xhtml
* Fixed - Compatibility with other mods (e.g. vbsso)
* Fixed - Setting determining which side of the memberprofile the awards tab should appear on not working
* Ported - Fix from 3.8.4 for admincp for usernames with ' to modcp
* Changed - Style of the awards tab on the user's profile page to better match with the standard tabs
* Changed - Style for award icons and images so they are both vertically and horizontally centered in their row (awards.php & user profile)
* Updated - Version in version phrase


If I messed up anything or there's a bug I didn't catch please let me know and I'll see about fixing it.

EDIT: Re-added the upload with correct XML.

speedracer68
06-19-2012, 02:31 AM
Thanks for working on this.

How safe would it be to try this? If for some reason does not work as well as the version I have can I revert without losing anything?

Also, has anyone found a way to auto approve awards? I use them for people to show off what events they have participated in and it would be great if it would run without me having to approve each one.

Thunderbird8
06-19-2012, 03:31 AM
What plugins were changed? I've implemented a customization on my board that allows members to determine how their awards are sorted, and I'd prefer to avoid having to reimplement that if possible.

You can fix the issue with the 4.2 navbar by changing $template_hook['navtab_middle'] to $template_hook['navtab_end'] in YAAS - Add Tab to Navbar. The former was deleted in 4.2, but the latter remains, and will work with 4.2 and previous versions.

squidsk
06-19-2012, 02:27 PM
EDIT: I've re-uploaded the new version of YaAS. I've also added two more changes to the list of things that were altered which I'd forgot to include when I first posted.

squidsk
06-19-2012, 04:33 PM
Thanks for working on this.

How safe would it be to try this? If for some reason does not work as well as the version I have can I revert without losing anything?

It would be pretty safe to try, but reverting would be a bit of a pain, as there's no easy way to revert to a previous version of a plugin. You might be able to just reload the old xml file and have it overwrite the changes from this plugin, but you'd likely need to take a back of the three awards tables, uninstall the 4.0.3 version, reinstall the 4.0.2PL1 version and then restore the backups to your db. The changes I've made do not alter the db in any way so there's no loss of anything if you upgrade.

Also, has anyone found a way to auto approve awards? I use them for people to show off what events they have participated in and it would be great if it would run without me having to approve each one.

I don't think so, but this would allow for easy abuse as then a member could give themselves any award even if they didn't actually meet whatever requirements you have for granting the award.

What plugins were changed? I've implemented a customization on my board that allows members to determine how their awards are sorted, and I'd prefer to avoid having to reimplement that if possible.

One plugin was changed, the YAAS in Member Profile - Profile plugin, and one plugin was removed, the YAAS - Profile Tab plugin. Both these changes were to fix the tab display issue on the member profile pages. I don't think any other plugins were changed. Various templates were also changed, but the merge utility should be able to merge all the changes. There were also some changes made to the php pages.

You can fix the issue with the 4.2 navbar by changing $template_hook['navtab_middle'] to $template_hook['navtab_end'] in YAAS - Add Tab to Navbar. The former was deleted in 4.2, but the latter remains, and will work with 4.2 and previous versions.

Thanks, I'll look into that once I upgrade to 4.2. Not being on 4.2 was the main reason I didn't make sure it was compatible with the navigation menu changes.

UK CHI3F
06-19-2012, 08:27 PM
So much going on at present with this mod but my site is re-launching in less than 2 weeks and id really like to solve the background issue on the awards page.
All other mods are fine.

Any advice as to where to look or what code might be wrong would be greatly appreciated.
our site is www.xboxplayers.com

squidsk
06-20-2012, 05:04 AM
How are you setting the background image? In other words what did you change and where to get the background image onto your site?

UK CHI3F
06-20-2012, 05:26 AM
Hi squidsk

It is additional css in the additional css posted like below
{
background: url(images/f1bkg.jpg) no-repeat center center fixed;
-webkit-background-size: cover; /*for webKit*/
-moz-background-size: cover; /*Mozilla*/
-o-background-size: cover; /*opera*/
background-size: cover; /*generic*/
}

nabbed the code off another site , hoping its not the problem as we love our fixed background

squidsk
06-20-2012, 12:24 PM
I'd guess that the awards page isn't loading that additional css for some reason. I'll look into it.

UK CHI3F
06-20-2012, 04:48 PM
I'd guess that the awards page isn't loading that additional css for some reason. I'll look into it.

Really appreciate it thanks

squidsk
06-20-2012, 06:14 PM
Have you set the setting for Store CSS Stylesheets as Files? set to yes? If not you can try to edit the headerinclude template and near the end add additonal.css to the list of css files included.

Glockie
06-21-2012, 11:19 AM
Hi,
firstly thanks for this great mod!

I am however, having some issues running it on 4.2.0
I don't have the 'Awards Tab' showing on the board only in the users profile page
And It's not showing anywhere the link to recommend an award

So, in short the recommend the award link (navbar) doesn't exist...

I hope someone can help here..
I look forward to hearing from you

Thanks

** EDIT Ignore the vbphrase issue, I've found it.. cheers!
I've also typed ****.example/award ( guess ) which works but the page is terribly messed up, so I'm assuming it's a CSS fault somewhere.. I can manually add the link on the nav, so that's not a problem. Thanks again

Thunderbird8
06-21-2012, 12:14 PM
You can add it to the NavBar manually via the Navigation Manager (awards.php is the path). Or if you feel safe doing so, you can make the plugin edit that I mentioned a few posts earlier.

FTG LIQUID CL
06-23-2012, 06:52 PM
I cant access the request and recommened awards.It tells me this..

Admin, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation

Any ideas.

DiageoLiam
06-25-2012, 01:18 PM
Is there a fix for automation yet? Getting the following when trying to run the scheduled task. Am using the fix posted by another developer a few pages back.

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT userid, award_id, award_cgroup
FROM award_user
WHERE (userid=19005) AND (award_id=7) AND (award_cgroup='postcount');

MySQL Error : Unknown column 'award_cgroup' in 'field list'
Error Number : 1054
Request Date : Monday, June 25th 2012 @ 09:16:10 AM
Error Date : Monday, June 25th 2012 @ 09:16:10 AM
Script : XX/cronadmin.php?do=runcron&cronid=55
Referrer : XX/cronadmin.php?do=modify
IP Address : XX
Username : XX
Classname : vB_Database
MySQL Version : 5.5.23-55

Kirk Fitzgerald
06-25-2012, 01:37 PM
Existing bug, sadly developer is AWOL, but the fix should still stand.

https://vborg.vbsupport.ru/showpost.php?p=2189701&postcount=742

Exactly what I was trying to fix myself, many thanks for the information. :)

squidsk
06-25-2012, 01:50 PM
Exactly what I was trying to fix myself, many thanks for the information. :)

Use https://vborg.vbsupport.ru/showpost.php?p=2340916&postcount=1152 instead, it includes all the fixes from the link you used as well as many other fixes.

squidsk
06-25-2012, 02:09 PM
Is there a fix for automation yet? Getting the following when trying to run the scheduled task. Am using the fix posted by another developer a few pages back.

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT userid, award_id, award_cgroup
FROM award_user
WHERE (userid=19005) AND (award_id=7) AND (award_cgroup='postcount');

MySQL Error : Unknown column 'award_cgroup' in 'field list'
Error Number : 1054
Request Date : Monday, June 25th 2012 @ 09:16:10 AM
Error Date : Monday, June 25th 2012 @ 09:16:10 AM
Script : XX/cronadmin.php?do=runcron&cronid=55
Referrer : XX/cronadmin.php?do=modify
IP Address : XX
Username : XX
Classname : vB_Database
MySQL Version : 5.5.23-55

Looking at the xml for automation it looks like you didn't install the automation plugin properly, or there was an error with the installation. The reason I say this is the first thing that should be done by the install script is to add that column to the award_user table. You could try changing line 22 so that ADD award_cgroup instead says ADD COLUMN award_cgroup. If the automation plugin is showing up in your product list I'd uninstall it and re-install it. You'll also need to manually delete the award_automation table if you're doing a re-install since the table is not removed during an uninstall.

FTG LIQUID CL
06-27-2012, 09:59 PM
i cant get the automation to work

Patriots1049
07-01-2012, 02:49 PM
Does anyone have a fix for automation with vB 4.2?

FTG LIQUID CL
07-01-2012, 02:58 PM
Everything is working great.Except I cant get the navbar tab to show up.I have it enabled but it wont work.

Patriots1049
07-01-2012, 04:42 PM
So automation works for you? Does it send a PM to members indicating they have got the awards?

Crotan
07-01-2012, 10:46 PM
Everything is working great.Except I cant get the navbar tab to show up.I have it enabled but it wont work.

if you're on 4.2.0 you'll have the manually add the tabs using the Navigation Manager. This mod, like many others hasn't been updated for the navtab changes.

Crotan
07-01-2012, 10:52 PM
I was fixing various bugs for YaAS so I decided to bundle it up into a new version. This is not official, but as the plugin says re-usable code I can release it for the benefit of the community. These changes should be compatible with all VB 4 versions with one caveat it does not support the new navigation manager from VB 4.2.

The mostly complete list of fixes/changes is:
4.0.3 RELEASE: (06/13/2012)
* Fixed - Various install/uninstall code issues
* Fixed - User profile tab graphical issues
* Fixed - Recommend/request award showing an error message, in certain circumstances, when there's no error
* Fixed - Various links not using properly escaped & (i.e. should be &amp; instead of &)
* Fixed - Code that generated invalid xhtml
* Fixed - Compatibility with other mods (e.g. vbsso)
* Fixed - Setting determining which side of the memberprofile the awards tab should appear on not working
* Ported - Fix from 3.8.4 for admincp for usernames with ' to modcp
* Changed - Style of the awards tab on the user's profile page to better match with the standard tabs
* Changed - Style for award icons and images so they are both vertically and horizontally centered in their row (awards.php & user profile)
* Updated - Version in version phrase


If I messed up anything or there's a bug I didn't catch please let me know and I'll see about fixing it.

EDIT: Re-added the upload with correct XML.

This is great. Thanks for making these fixes and compiling them into a new version! :up:

Kirkus
07-06-2012, 09:45 PM
I have several years of awards in my live site's database, which is vBulletin 3.8.7. I'm currently testing an upgrade to 4.2.1 on a dev site. Unfortunately, I uninstalled my old version of YAAS after the upgrade, which dropped my awards tables.

Can I simply export them from my 3.8.7 db and import them into my 4.2.1 database? Or am I asking for trouble?

::

If I don't uninstall my old YAAS and it's corresponding awards tables during my upgrade to 4.2.1, but simply install this newer version over it after the upgrade, will all of my awards still be there. I mean, are the database tables different between the older version of YAAS and this newer version?

Kirkus
07-06-2012, 11:57 PM
The answers appear to be yes and yes. ;)

Sorry for mucking up the thread.

Kybyrian
07-11-2012, 07:32 PM
How do you remove an award already given to a user? There is no option for it. A user was accidentally given an incorrect award and there is no way to remove it.

Thunderbird8
07-12-2012, 06:48 AM
The Give Award to User selection allows removal of awards as well.

animcentral
07-16-2012, 02:44 AM
I was fixing various bugs for YaAS so I decided to bundle it up into a new version. This is not official, but as the plugin says re-usable code I can release it for the benefit of the community. These changes should be compatible with all VB 4 versions with one caveat it does not support the new navigation manager from VB 4.2.

The mostly complete list of fixes/changes is:
4.0.3 RELEASE: (06/13/2012)
* Fixed - Various install/uninstall code issues
* Fixed - User profile tab graphical issues
* Fixed - Recommend/request award showing an error message, in certain circumstances, when there's no error
* Fixed - Various links not using properly escaped & (i.e. should be &amp; instead of &)
* Fixed - Code that generated invalid xhtml
* Fixed - Compatibility with other mods (e.g. vbsso)
* Fixed - Setting determining which side of the memberprofile the awards tab should appear on not working
* Ported - Fix from 3.8.4 for admincp for usernames with ' to modcp
* Changed - Style of the awards tab on the user's profile page to better match with the standard tabs
* Changed - Style for award icons and images so they are both vertically and horizontally centered in their row (awards.php & user profile)
* Updated - Version in version phrase
If I messed up anything or there's a bug I didn't catch please let me know and I'll see about fixing it.

EDIT: Re-added the upload with correct XML.
it's better to create new thread for your plugins

squidsk
07-16-2012, 02:37 PM
it's better to create new thread for your plugins

It isn't a new plugin, is bug fixes for this plugin. I also couldn't release that as my own plugin even if I wanted to since it isn't mine.

CAG CheechDogg
07-16-2012, 07:26 PM
Ok let me see if I can explain what is happening here.

I have two issues not big but kind of weird.

If you add the full link (absolute url) to the "Award Image URL" field when adding a new award instead of just the short (relative url) "images/medals/1_month.jpg" version of the url when going to the Award Manager page the awards do not show up in the Award column.

https://vborg.vbsupport.ru/external/2012/07/30.jpg

The awards how ever do show up in the Awards page on my forums. If I do use the absolute url the award will show up in the Award Manager page in my backend but when a new thread is posted I get this where I only see the bb code instead of the award.

https://vborg.vbsupport.ru/external/2012/07/31.jpg

When I right click to view the image in the Award Manager I get a 403 page not found but the link looks like this

https://www.cagclan.com/community/https://www.cagclan.com/community/images/medals/1month.png

Is there a way to allow absolute urls so that the Award shows up in the Award Manager?

Thunderbird8
07-17-2012, 06:51 AM
Seems like some parts assume relative URLs (like ACP/MCP) where the forum path would have to be included (since a relative URL in those areas wouldn't work well), while the Request Award output assumes it is absolute.

I also noticed something looking at a few of the templates for this...most of them still look like they're using the vB3 syntax, instead of the vB4 syntax. While this does work, is it really a good idea?

CAG CheechDogg
07-17-2012, 06:56 AM
Seems like some parts assume relative URLs (like ACP/MCP) where the forum path would have to be included (since a relative URL in those areas wouldn't work well), while the Request Award output assumes it is absolute.

I also noticed something looking at a few of the templates for this...most of them still look like they're using the vB3 syntax, instead of the vB4 syntax. While this does work, is it really a good idea?

It is working fine for me besides these 2 little issues. No other problems , I was looking through the awards.php to see if I could fix this but I see nothing so far.

squidsk
07-17-2012, 07:52 PM
Ok let me see if I can explain what is happening here.

I have two issues not big but kind of weird.

If you add the full link (absolute url) to the "Award Image URL" field when adding a new award instead of just the short (relative url) "images/medals/1_month.jpg" version of the url when going to the Award Manager page the awards do not show up in the Award column.

<snip>

The awards how ever do show up in the Awards page on my forums. If I do use the absolute url the award will show up in the Award Manager page in my backend but when a new thread is posted I get this where I only see the bb code instead of the award.

<snip>

When I right click to view the image in the Award Manager I get a 403 page not found but the link looks like this

https://www.cagclan.com/community/https://www.cagclan.com/community/images/medals/1month.png

Is there a way to allow absolute urls so that the Award shows up in the Award Manager?

I don't see anything in the code that would cause absolute urls to fail. The default medals use absolute url and they display without a problem. As for relative urls not working, its because the [img] tag does not handle relative urls.

CAG CheechDogg
07-18-2012, 04:02 AM
Yes they display in the Awards page in the forums but not in my backend. If I use absolute they wont display in my backend but of course show up because the bb code does handle absolute.

But if you use the relative urls then what is the point of creating a thread that does not show the image but instead just the bb code in it?

Do I make sensek, lol...

Thanks for answering back squidsk.

CAG CheechDogg
07-18-2012, 04:04 AM
This has to do more with the creation of the award submissions thread than anything else.

afmarko99
07-18-2012, 03:07 PM
I used to run the 3.8 version but had it disabled as I upgraded to 4.xxx. I installed this version but it looks like I need to edit the award.php file as it doesn't show my site's custom navbar.

Please visit and compare to the rest of the site. I have contacted my site builder but I am hoping someone can help me figure it out on my own as he takes awhile to respond.

http://www.thepublicenemy.net/awards.php

squidsk
07-18-2012, 03:33 PM
Yes they display in the Awards page in the forums but not in my backend. If I use absolute they wont display in my backend but of course show up because the bb code does handle absolute.

But if you use the relative urls then what is the point of creating a thread that does not show the image but instead just the bb code in it?

Do I make sensek, lol...

Thanks for answering back squidsk.

Because most sites have html disabled in posts, as they should. This means that a post added to the post table can't have html tags or it won't display, so bbcode must be used.

I used to run the 3.8 version but had it disabled as I upgraded to 4.xxx. I installed this version but it looks like I need to edit the award.php file as it doesn't show my site's custom navbar.

Please visit and compare to the rest of the site. I have contacted my site builder but I am hoping someone can help me figure it out on my own as he takes awhile to respond.

http://www.thepublicenemy.net/awards.php

You've likely upgraded to 4.2, which uses a different navigation system. You'll need to manually add the awards tab using the navigation manager in admincp.

afmarko99
07-18-2012, 03:42 PM
Because most sites have html disabled in posts, as they should. This means that a post added to the post table can't have html tags or it won't display, so bbcode must be used.



You've likely upgraded to 4.2, which uses a different navigation system. You'll need to manually add the awards tab using the navigation manager in admincp.

The problem isn't adding an awards link to my navbar. I have manually added it already. The problem is on the actual awards.php page IE http://www.thepublicenemy.net/awards.php

My main navbar is screwed up. I'm trying to figure out how to get it like the rest of my site.

squidsk
07-18-2012, 03:55 PM
Is it messed up with the default style? I'm asking because that custom style has a tonne of xhtml validation errors, any of which might cause odd behaviour with the appearance of a page.

afmarko99
07-18-2012, 04:41 PM
Is it messed up with the default style? I'm asking because that custom style has a tonne of xhtml validation errors, any of which might cause odd behaviour with the appearance of a page.

No the default style is fine but thats because the default style only has the VB navbar not the custom navbar he has added to the forum.

Here is the custom navbar coding in the 'header' template:

<!-- Begin Menu -->
<ul id="nav">
<li><a href="http://www.thepublicenemy.net/home/index.php">Home</a></li>
<li><a href="http://www.thepublicenemy.net/forum.php">Forum</a>
<ul><!-- Begin Sub Level -->
<li><a href="http://www.thepublicenemy.net/search.php?do=getnew&contenttype=vBForum_Post">New Posts</a></li>
<li><a href="http://www.thepublicenemy.net/search.php?do=getdaily&contenttype=vBForum_Post">Today's (http://www.thepublicenemy.net/search.php?do=getdaily&contenttype=vBForum_Post&quot;>Today's) Posts</a></li>
<li><a href="http://www.thepublicenemy.net/forumdisplay.php?2-Bullshitters-Bench">Bullshitter's (http://www.thepublicenemy.net/forumdisplay.php?2-Bullshitters-Bench&quot;>Bullshitter's) Bench</a></li>
<li><a href="http://www.thepublicenemy.net/forumdisplay.php?6-Battlefield-3">Battlefield 3</a></li>
<li><a href="http://www.thepublicenemy.net/forumdisplay.php?13-Clan-Discussion">Clan Discussion</a></li>
</ul><!-- End Sub Level -->
</li>
<li><a href="#">-TPE- Center</a>
<ul><!-- Begin Sub Level -->
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=1">Roster</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=3">History</a></li>
<li><a href="http://www.thepublicenemy.net/forms.php?do=form&fid=1">Join -TPE-</a></li>
<li><a href="https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=3BDCYPJFTLMQ4" target="_blank">Donate</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=6">Recent Donators</a></li>
</ul><!-- End Sub Level -->
</li>
<li><a href="#">-TPE- Center 2</a>
<ul><!-- Begin Sub Level -->
<li><a href="http://www.thepublicenemy.net/awards.php">Awards Program</a></li>
<li><a href="http://battlelog.battlefield.com/bf3/platoon/2832655240986011936/" target="_blank">Battlelog Page</a></li>
<li><a href="http://www.youtube.com/user/TPEthepublicenemy/feed" target="_blank">Youtube Page</a></li>
</ul><!-- End Sub Level -->

<li><a href="#">Competition</a>
<ul><!-- Begin Sub Level -->
<li><a href="http://www.thepublicenemy.net/home/index.php?site=clanwars">BF 3 Matches</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=2">Overall Match History</a></li>
</ul><!-- End Sub Level -->
</li>
<li><a href="#">Media & Info</a>
<ul><!-- Begin Sub Level -->
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=4">-TPE- Videos</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=5">-TPE- Gallery</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php">News Archive</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php?site=articles">Articles</a></li>
<li><a href="http://www.thepublicenemy.net/calendar.php">Calendar</a></li>
</ul><!-- End Sub Level -->
</li>
</ul>
<!-- End Menu -->


Can I build a new template based off 'header' and replace the line in the awards template?
Then edit the new template IE header_awards and try to fix the issue that is conflicting with the awards template?

squidsk
07-18-2012, 07:21 PM
No the default style is fine but thats because the default style only has the VB navbar not the custom navbar he has added to the forum.

Here is the custom navbar coding in the 'header' template:

<!-- Begin Menu -->
<ul id="nav">
<li><a href="http://www.thepublicenemy.net/home/index.php">Home</a></li>
<li><a href="http://www.thepublicenemy.net/forum.php">Forum</a>
<ul><!-- Begin Sub Level -->
<li><a href="http://www.thepublicenemy.net/search.php?do=getnew&contenttype=vBForum_Post">New Posts</a></li>
<li><a href="http://www.thepublicenemy.net/search.php?do=getdaily&contenttype=vBForum_Post">Today's (http://www.thepublicenemy.net/search.php?do=getdaily&contenttype=vBForum_Post&quot;>Today's) Posts</a></li>
<li><a href="http://www.thepublicenemy.net/forumdisplay.php?2-Bullshitters-Bench">Bullshitter's (http://www.thepublicenemy.net/forumdisplay.php?2-Bullshitters-Bench&quot;>Bullshitter's) Bench</a></li>
<li><a href="http://www.thepublicenemy.net/forumdisplay.php?6-Battlefield-3">Battlefield 3</a></li>
<li><a href="http://www.thepublicenemy.net/forumdisplay.php?13-Clan-Discussion">Clan Discussion</a></li>
</ul><!-- End Sub Level -->
</li>
<li><a href="#">-TPE- Center</a>
<ul><!-- Begin Sub Level -->
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=1">Roster</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=3">History</a></li>
<li><a href="http://www.thepublicenemy.net/forms.php?do=form&fid=1">Join -TPE-</a></li>
<li><a href="https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=3BDCYPJFTLMQ4" target="_blank">Donate</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=6">Recent Donators</a></li>
</ul><!-- End Sub Level -->
</li>
<li><a href="#">-TPE- Center 2</a>
<ul><!-- Begin Sub Level -->
<li><a href="http://www.thepublicenemy.net/awards.php">Awards Program</a></li>
<li><a href="http://battlelog.battlefield.com/bf3/platoon/2832655240986011936/" target="_blank">Battlelog Page</a></li>
<li><a href="http://www.youtube.com/user/TPEthepublicenemy/feed" target="_blank">Youtube Page</a></li>
</ul><!-- End Sub Level -->

<li><a href="#">Competition</a>
<ul><!-- Begin Sub Level -->
<li><a href="http://www.thepublicenemy.net/home/index.php?site=clanwars">BF 3 Matches</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=2">Overall Match History</a></li>
</ul><!-- End Sub Level -->
</li>
<li><a href="#">Media & Info</a>
<ul><!-- Begin Sub Level -->
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=4">-TPE- Videos</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php?site=static&staticID=5">-TPE- Gallery</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php">News Archive</a></li>
<li><a href="http://www.thepublicenemy.net/home/index.php?site=articles">Articles</a></li>
<li><a href="http://www.thepublicenemy.net/calendar.php">Calendar</a></li>
</ul><!-- End Sub Level -->
</li>
</ul>
<!-- End Menu -->


Can I build a new template based off 'header' and replace the line in the awards template?
Then edit the new template IE header_awards and try to fix the issue that is conflicting with the awards template?

A couple of things, there's an unofficial patch to YAAS that you do not appear to be using. You can grab it from here (https://vborg.vbsupport.ru/showthread.php?p=2340916#post2340916).

Also you're menu is missing the </li> that corresponds to TPE - Center 2.

I'm not sure that will fix everything, but it will at least start you in the right direction.

afmarko99
07-18-2012, 07:33 PM
A couple of things, there's an unofficial patch to YAAS that you do not appear to be using. You can grab it from here (https://vborg.vbsupport.ru/showthread.php?p=2340916#post2340916).

Also you're menu is missing the </li> that corresponds to TPE - Center 2.

I'm not sure that will fix everything, but it will at least start you in the right direction.

Thanks but that didnt fix the problem.

squidsk
07-18-2012, 08:03 PM
Thanks but that didnt fix the problem.

Figured it out, its actually what I thought was a vbulletin bug that I mentioned a few pages ago but isn't. If you edit the template AWARDS and just before</head> add {vb:raw headinclude_bottom}. This should fix the issue.

afmarko99
07-18-2012, 08:23 PM
Figured it out, its actually what I thought was a vbulletin bug that I mentioned a few pages ago but isn't. If you edit the template AWARDS and just before</head> add {vb:raw headinclude_bottom}. This should fix the issue.

My friend you are a Genius!

Thank you very much. I would have never figured that out alone.

CAG CheechDogg
07-19-2012, 04:51 AM
Because most sites have html disabled in posts, as they should. This means that a post added to the post table can't have html tags or it won't display, so bbcode must be used.



Ah snaps! Makes sense..so If I enable html just in that forum it should be fine right?

Crotan
07-19-2012, 07:17 PM
Figured it out, its actually what I thought was a vbulletin bug that I mentioned a few pages ago but isn't. If you edit the template AWARDS and just before</head> add {vb:raw headinclude_bottom}. This should fix the issue.

Something similar needs to be done for the awards_recommend_form template and awards_request_form

EDIT: I should say everyone of his award templates that are their own page

Specifically in templates
awards_recommend_form
awards_request_form
awards_viewaward

where
$headinclude

</head>

should be
$headinclude
$headinclude_bottom
</head>

squidsk
07-29-2012, 12:59 AM
Ah snaps! Makes sense..so If I enable html just in that forum it should be fine right?

No, because the post was created with the assumption that html would not work, so bbcode was used instead. The problem is that the https://vborg.vbsupport.ru/ bbcode does not handle relative links. A fix to the bbcode, no likely to be done, or a fix to the code to generate that post which prepends the site url to relative urls needs to be done. I can likely do the second, but wouldn't count on jelsoft doing the first. They may even have reasons for not doing it, which if I were to guess it would be because it is too difficult to determine what a valid relative url looks like.

Something similar needs to be done for the awards_recommend_form template and awards_request_form

EDIT: I should say everyone of his award templates that are their own page

Specifically in templates
awards_recommend_form
awards_request_form
awards_viewaward

where
$headinclude

</head>

should be
$headinclude
$headinclude_bottom
</head>

Thanks, I'll see about putting together a new version with all the templates updated.

r00028304
08-02-2012, 06:46 PM
Anyone know whats wrong here? - It worked fine and then stopped working?

Fatal error: Cannot redeclare construct_depth_mark() (previously declared in /home/xxx/public_html/xxx/awards.php:99) in /home/xxx/public_html/xxx/includes/adminfunctions.php on line 1922

squidsk
08-02-2012, 06:53 PM
Yes, you just installed another plugin that doesn't work correctly with this one. If you go to https://vborg.vbsupport.ru/showthread.php?p=2340916#post2340916 you can grab an updated version of this mod that fixes that issue among others.

r00028304
08-02-2012, 06:55 PM
Yes, you just installed another plugin that doesn't work correctly with this one. If you go to https://vborg.vbsupport.ru/showthread.php?p=2340916#post2340916 you can grab an updated version of this mod that fixes that issue among others.

That's actually the version i'm currently using.

Funny enough.. it works if i'm logged out.


Fixed by disabling "vFcoders - Advanced Report System" ... wierd.. :(

squidsk
08-02-2012, 07:41 PM
What other plugin have you installed since this one last worked correctly?

r00028304
08-02-2012, 08:03 PM
It was vFcoders - Advanced Report System (https://vborg.vbsupport.ru/showthread.php?t=285206).. Which I've disabled.. all seems to be working OK.. not sure why they are interfering with e/o

squidsk
08-03-2012, 02:08 PM
It was vFcoders - Advanced Report System (https://vborg.vbsupport.ru/showthread.php?t=285206).. Which I've disabled.. all seems to be working OK.. not sure why they are interfering with e/o
One of two reasons. First is that you didn't update the awards.php when you updated to the 4.0.3 version I posted. The easy way to check for this is to open awards.php and look at the top it should say 4.0.3 in the version. You can also go to line 99, where the construct_depth_mark function is declared, and ensure the function is wrapped in a if(!function_exists('construct_depth_mark)) conditional statement. The second possible reason is that one of the plugins from vFcoders - Advanced Report System has bad php and is causing that if statement I mention above to not fire properly, which would also cause the error.

If the problem is the first then just re-upload the file, if the problem is the second report it to vFcoders and let them deal with the bad code, or you can enable the plugin and disable the hooks one at a time until you find the one causing the problem and see if you can figure it out.

My bet is the second, especially as the problem resolves itself when you aren't logged in.

Mobo
08-05-2012, 11:11 AM
I've gotten great use out of the YAAS mod and the YARS mod has been very helpful as well. As such, I'd like to share the 320+ medals I've had my artist design for me with the community. A lot of them are "medal sets", meaning a medal has multiple level or ranks. I use this level system extensively on my site, so there are a lot of those.

I've included the base image of each medal and its icon. They are both PNG images with transparent backgrounds.

A sample:

https://vborg.vbsupport.ru/external/2012/08/120.png https://vborg.vbsupport.ru/external/2012/08/121.png

Please only use these only on your vBulliten sites. The zip file for these is to large to attach here, so you can download it here (wingsofwar.org/Temp/Medals.zip).

Hope this helps some of you out.

r00028304
08-05-2012, 11:16 AM
wow, thats very kind of your Mobo,

Thanks :)

LgsOfChampions
08-06-2012, 09:27 PM
I used to run the 3.8 version but had it disabled as I upgraded to 4.xxx. I installed this version but it looks like I need to edit the award.php file as it doesn't show my site's custom navbar.

Please visit and compare to the rest of the site. I have contacted my site builder but I am hoping someone can help me figure it out on my own as he takes awhile to respond.

http://www.thepublicenemy.net/awards.php

Just a heads up, when I go to your site, my security blocks me from ur site saying it has dangerous content on it.

LgsOfChampions
08-06-2012, 09:28 PM
any one else get this error at the top of the awards page. I've gone thru a few and say nothing about it. was hoping someone could tell me the fix if there was one or the page it is on?

thanks.

Deprecated: Assigning the return value of new by reference is deprecated in /home/content/70/7560670/html/LeaguesOfChampions/awards.php on line 47

ProFifaLeagues
08-06-2012, 10:07 PM
any one else get this error at the top of the awards page. I've gone thru a few and say nothing about it. was hoping someone could tell me the fix if there was one or the page it is on?

thanks.


Could be a php error that or try this see if it fixes the issue
To resolve the deprecation error go to line 47 in awards.php and delete the & from before the equals sign.

theredone
08-18-2012, 04:58 AM
Is this working with 4.1.10?

Mobo
08-18-2012, 08:51 AM
It worked on my 4.1 site before I upgraded to 4.2 and is still working.

CharlieDelta
08-22-2012, 01:33 PM
I am getting this error when awarding a new award and checking off to send a PM and/or email notification.

Warning: mysql_insert_id() [function.mysql-inset-id]: Access denied for user '...@localhost' (using password: NO) in [path]/admincp/award.php on line 594
Warning: mysql_insert_id() [function.mysql-inset-id]: A link to the server could not be established in [path]/admincp/award.php on line 594

Anyone come across this before?

ecitizen
08-25-2012, 02:14 PM
is it work with 4.2.0

hoplomachus
08-30-2012, 06:33 AM
When clicking on settings/Submission: From Userid for Congratulation PM and/or Email/

and i click here to edit i get this error..

No Phrases Matched Your Query

anyone know how to fix this?

squidsk
08-30-2012, 05:55 PM
You do realize that the edit link you're clicking is not for changing the userid that the congratulations PM comes from but rather is to change either the subject or the body of the PM sent. Both of those can be altered directly through the phrase manager.

CharlieDelta
08-31-2012, 12:13 AM
I am getting this error when awarding a new award and checking off to send a PM and/or email notification.

Warning: mysql_insert_id() [function.mysql-inset-id]: Access denied for user '...@localhost' (using password: NO) in [path]/admincp/award.php on line 594
Warning: mysql_insert_id() [function.mysql-inset-id]: A link to the server could not be established in [path]/admincp/award.php on line 594

Anyone come across this before?

Anyone see this before.

squidsk
08-31-2012, 05:03 PM
Never seen that before. Was it working and now is giving that warning? If so what changes have you made recently, new plugins or what have you.

CharlieDelta
08-31-2012, 07:15 PM
Yes, and it still does work. The PM's and emails are being sent but this error pops up briefly.
I have only noticed it since implementing your xml and changes.
Very strange.

masterross
09-01-2012, 07:20 AM
I have information that request_award.php is serious vulnerable!

squidsk
09-02-2012, 12:35 AM
What's the vulnerability? Those of us using this mod need to assess the seriousness of the vulnerability. If you could PM the details it would be appreciated as you may or may not have noticed but I've been fixing bugs where I can.

Dave234
09-02-2012, 11:56 AM
Unfortunately not, there's an error in the uninstallation code, actually an omission, that prevents the plugin from uninstalling correctly.

First uninstall YAAS from the product manager.

Then to do what I posted on the previous page, in admincp go to Maintenance->Execute SQL Query

When prompted run the following query:
show tables

This will give you the list of all tables in your db, look for the ones that have awards in their name, there should be between one and three of them, most likely three. In my db the tables are called:

award
award_cat
award_requests

The names might be different in your db, especially if your tables have a prefix. Take note of the names, and then run drop table queries, one per table, to remove the tables.

So if I was removing the three tables from my db I'd run the following three queries:
drop table award
drop table award_cat
drop table award_requests

Then I could reinstall YAAS from scratch.

I have removed the above three tables from my database, but I also see another couple:

award_automation
award_user

Do these need to be removed as well?

squidsk
09-03-2012, 12:17 AM
I have removed the above three tables from my database, but I also see another couple:

award_automation
award_user

Do these need to be removed as well?

Those are from the awards automation plugin which is an additional, separate, plugin that works on top of YaAS, I'd uninstall that plugin and remove those tables as well, then you'll have uninstalled all parts of YaAS.

If you look in my sig you'll see a link to a new, unofficial, version of YaAS that I released that fixes many of the bugs in the current official release. I'd recommend using that if you're going to try and re-install. It fixes the uninstall issues among other things. A complete list of fixes/changes is at the post in the link.

apapterx
09-03-2012, 03:59 PM
I'm having a slight problem. Everything is working fine apart from member cannot recommend a member.

Any ideas on what to do ?

I get the following:

you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

squidsk
09-03-2012, 04:13 PM
Make sure the member is part of a group which has the recommend ability turned on. Its a usergroup setting.

wat3v3r
09-04-2012, 01:10 PM
According to a hacking forum v4.0.2 has an exploit and can lead to an SQL injection to your site ?

Will send squidsk a pm with the details... hope he can fix this asap.

hjmaier
10-14-2012, 12:20 PM
Great! Thank you very much for the fix!

EasyEazy
10-14-2012, 12:55 PM
Great update.

Thanks again

EasyEazy
10-14-2012, 03:36 PM
Hi squidsk

After updating there seems to be a problem with the templates in the member info. See the pictures below. The first one was an older version of this mod and the one below is the new version. See how the new version the awards are mashed together with no spacing. Any chance you could help?

https://vborg.vbsupport.ru/external/2012/10/30.jpg

https://vborg.vbsupport.ru/external/2012/10/31.jpg

Thanks

Dave234
10-14-2012, 05:24 PM
I see that the mod has been updated. Is it correct that we should now download YaAS-4.0.4.zip and YaAS-Automation-R2.zip?

Can you provide step by step instructions on how to install this mod?

Thanks!

Crotan
10-14-2012, 07:11 PM
I see that the mod has been updated. Is it correct that we should now download YaAS-4.0.4.zip and YaAS-Automation-R2.zip?

Can you provide step by step instructions on how to install this mod?

Thanks!


Backup MySQL database
Turn Off vbulletin
Turn off plugin system
Upload the contents of upload to your forum directory
import xml
Turn back on everything
Enjoy!


That's just for YaAS 4.0.4 The automation R2 package is an addon, and isn't required as far as I'm aware.

Thanks for the update too!

Thunderbird8
10-14-2012, 09:44 PM
Automation wasn't updated, I don't think.

squidsk
10-15-2012, 12:37 AM
Hi squidsk

After updating there seems to be a problem with the templates in the member info. See the pictures below. The first one was an older version of this mod and the one below is the new version. See how the new version the awards are mashed together with no spacing. Any chance you could help?

<snip>images</snip>

Thanks

Given I didn't change any of the layouts my guess would be that you have stuff in additional.css that changes the padding/margins since the mod was updated to include additional.css template modifications.

Automation wasn't updated, I don't think.

No it wasn't updated.

Ravallojr
10-15-2012, 01:10 AM
Keeps giving me weird errors :o

squidsk
10-15-2012, 02:50 AM
Keeps giving me weird errors :o
You need to be a little more specific than that if you'd like some help.

EasyEazy
10-15-2012, 03:22 AM
Given I didn't change any of the layouts my guess would be that you have stuff in additional.css that changes the padding/margins since the mod was updated to include additional.css template modifications.

Hi Squidsk

I have removed any content from the additional.css and its still the same. Any thing else you can think of it could be?

*update*

I dont appear to have any additional.css code in any of the templates for this mod. is this correct?

fishmaster
10-15-2012, 03:47 AM
Is this the security upgrade to the below:

https://vborg.vbsupport.ru/showthread.php?t=265893&page=12

squidsk
10-15-2012, 04:43 AM
Hi Squidsk

I have removed any content from the additional.css and its still the same. Any thing else you can think of it could be?

*update*

I dont appear to have any additional.css code in any of the templates for this mod. is this correct?

You won't directly. 4 of the templates, those with a head html section, now have {vb:raw headinclude_bottom} in them, that will include the content in the additional.css template.

I will correct what I said earlier though. There are no layout changes if you had previously applied my unofficial, since I wasn't in charge of the mod at the time, 4.0.3 upgrade. None of those changes should have the effect you're describing though. To see the changes you can click on the link in my sig as it still points to the old changes or just take a look at the change log file in the mod.

Is this the security upgrade to the below:

https://vborg.vbsupport.ru/showthread.php?t=265893&page=12

No, that's a mod based off the code for this one, patching this mod does not necessarily mean that the other mod is safe to use.

EasyEazy
10-15-2012, 04:50 AM
You won't directly. 4 of the templates, those with a head html section, now have {vb:raw headinclude_bottom} in them, that will include the content in the additional.css template.

I will correct what I said earlier though. There are no layout changes if you had previously applied my unofficial, since I wasn't in charge of the mod at the time, 4.0.3 upgrade. None of those changes should have the effect you're describing though. To see the changes you can click on the link in my sig as it still points to the old changes or just take a look at the change log file in the mod..

Would it be possible for you to take a look into this for me if I send you the details?

netzwart
10-15-2012, 06:59 AM
Backup MySQL database
Turn Off vbulletin
Turn off plugin system
Upload the contents of upload to your forum directory
import xml
Turn back on everything
Enjoy!



Thanks for the instructions! However, I don?t want to make a completely new installation, I need to update the existing MOD without loosing data of the persons who already have awards and without loosing graphic files and definitions of existing awards.

Is there a different approach for updating the existing MOD ?

Thanks in advance

Netzwart

TheSupportForum
10-15-2012, 07:53 AM
Is this the security upgrade to the below:

https://vborg.vbsupport.ru/showthread.php?t=265893&page=12

its an addon which is no longer available

TheSupportForum
10-15-2012, 07:55 AM
Thanks for the instructions! However, I don?t want to make a completely new installation, I need to update the existing MOD without loosing data of the persons who already have awards and without loosing graphic files and definitions of existing awards.

Is there a different approach for updating the existing MOD ?

Thanks in advance

Netzwart

1) upload all files
2) import the product

thats it, you don't need to follow any other instructions

gbicar
10-15-2012, 12:39 PM
it works but I do not see the post of the medals, and even the button to the requests, tried to uninstall and re-install but nothing.
any advice?

vb 4.2.0 patch level2

squidsk
10-15-2012, 02:00 PM
it works but I do not see the post of the medals, and even the button to the requests, tried to uninstall and re-install but nothing.
any advice?

vb 4.2.0 patch level2

If you're talking about the nav button, you'll need to add it manually for vb 4.2 since it uses the new navigation manager which the mod does not yet support.

FCDobbs
10-15-2012, 02:08 PM
I presently have 4.0.2.1 version.
What is involved in updating to this new 4.0.4 version ?
(I don't see this info in any of the readme or instructions)

Thanks

squidsk
10-15-2012, 02:38 PM
Same as installing it fresh, upload all the files in the upload directory, import the xml making sure to check the override checkbox.

gbicar
10-15-2012, 04:25 PM
I did so, but the button for the recommendation medals has not been created, the same for the thread that should contain the medals.
but with the old version everything was ok.
gives me an error. loading php, but I have not had time to read.
for the rest no problem

Bluefin221
10-15-2012, 04:29 PM
Spoke to squidsk about this but wondering if anyone has ever been able to get a medal to show only 1 time on the postbit, so you could issue the same medal numerous times and have it show up once on the postbit instead of how many times you issued it.

Would really appreciate any help with this as its doing my head in.

CAG CheechDogg
10-15-2012, 06:52 PM
Great to see you updated this squidsk!....Thanks a lot buddy, my Clan was bugging me about this, they were bored lol....Thanks again buddy!

CharlieDelta
10-16-2012, 01:11 AM
Thank you squidsk!