vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - Yet Another Awards System (https://vborg.vbsupport.ru/showthread.php?t=232684)

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

Quote:

Originally Posted by squidsk (Post 2332337)
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

Quote:

Originally Posted by squidsk (Post 2332438)
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

Quote:

Originally Posted by Dave234 (Post 2332538)
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:
Code:

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:

Code:

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:
Code:

drop table award
Code:

drop table award_cat
Code:

drop table award_requests
Then I could reinstall YAAS from scratch.

squidsk 05-25-2012 04:42 PM

Quote:

Originally Posted by BWG22 (Post 2332595)
Problem Solved. It was the vbSSO plugin.

You could also try the solution mentioned here.

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

Quote:

Originally Posted by squidsk (Post 2335594)
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

Quote:

Originally Posted by Kirkus (Post 2335933)
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/showthrea...ighlight=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

PHP Code:

Importing ProductPlease Wait...

[:]
Warningmysqli_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 syntaxcheck 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 syntaxcheck 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 syntaxcheck 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  
FridayJune 8th 2012 08:01:10 AM
Error Date    
FridayJune 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?

Code:

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

Quote:

Originally Posted by Hamish Gill (Post 2338068)
scuse my stupidity ... uploaded then tried importing from server and got a db error
any thoughts?

Code:

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

Quote:

Originally Posted by edytwinky (Post 2338856)
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....&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

Quote:

Originally Posted by UK CHI3F (Post 2339820)
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

Quote:

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/im...rdsettings.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

Quote:

Originally Posted by edytwinky (Post 2338856)
On the user's profile page, does anybody have issues with the tab that says awards not appearing properly?

Quote:

Originally Posted by Crotan (Post 2338871)
Existing bug, sadly developer is AWOL, but the fix should still stand.

https://vborg.vbsupport.ru/showpost....&postcount=742

Thanks Crotan! That helped!

squidsk 06-19-2012 01:55 AM

1 Attachment(s)
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:
Code:

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

Quote:

Originally Posted by speedracer68 (Post 2340922)
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.

Quote:

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.

Quote:

Originally Posted by Thunderbird8 (Post 2340936)
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.

Quote:

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
Code:

{
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.


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04078 seconds
  • Memory Usage 1,892KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (9)bbcode_code_printable
  • (1)bbcode_php_printable
  • (16)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete