vb.org Archive - Yet Another Awards System 3.5 v2.1.2

Page 6 of 15

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Yet Another Awards System 3.5 v2.1.2 (https://vborg.vbsupport.ru/showthread.php?t=94836)

ChrisBaktis

11-30-2005 12:02 PM

I just changed from 3.0.7 to 3.5.1 and resintalled your hack - the awards that were present prior to the conversion still show up - but in the admincp area if I click on Manger or any of the items I get the following error:

Database error in vBulletin 3.5.1:

PHP Code:


		
			
Invalid SQL:



            SELECT aw_c.*, COUNT(aw.award_id) AS items

            FROM award_cat AS aw_c

            LEFT JOIN award AS aw USING(award_cat_id)

            GROUP BY award_cat_id

            ORDER BY award_cat_displayorder;



MySQL Error  : Unknown column 'award_cat_displayorder' in 'order clause'

Error Number : 1054

Date         : Wednesday, November 30th 2005 @ 09:01:03 AM

Script       : http://rustysoaptraders.com/forums/admincp/award_cat.php?do=modifycat

samu2

11-30-2005 03:16 PM

could somebody please tell me the right code to put the link to awards in my navbar?

mtha	12-01-2005 01:57 PM

Quote:

Originally Posted by ChrisBaktis

PHP Code:


		
			
Invalid SQL:

            SELECT aw_c.*, COUNT(aw.award_id) AS items
            FROM award_cat AS aw_c
            LEFT JOIN award AS aw USING(award_cat_id)
            GROUP BY award_cat_id
            ORDER BY award_cat_displayorder;

MySQL Error  : Unknown column 'award_cat_displayorder' in 'order clause'
Error Number : 1054
Date         : Wednesday, November 30th 2005 @ 09:01:03 AM
Script       : http://rustysoaptraders.com/forums/admincp/award_cat.php?do=modifycat

HMM, was you able to reorder award cat prior to your upgrade?
award_cat_displayorder was present in the database since after version 1.0

maybe you did not upgrade your award hack since 1.0 to the latest version for vB 3.0.7, or you missed one step to fix database?

anyway, check your database and see if you have table award_cat, and if there's a field called award_cat_displayorder in there.

or you may need to run the queries (add prefix if you need to):

this query will drop award_cat table. so becareful. if you already have the award cat table, want to keep it, you can look over the next query and see if there is anything wrong. with your current award_cat table.
[sql]DROP TABLE IF EXISTS award_cat
[/sql]

[sql] CREATE TABLE award_cat (
award_cat_id mediumint(8) unsigned NOT NULL auto_increment,
award_cat_title varchar(100) NOT NULL default '',
award_cat_desc varchar(250) NOT NULL default '',
award_cat_displayorder mediumint(8) unsigned NOT NULL default '0',
award_cat_parentid mediumint(8) NOT NULL default '-1',
PRIMARY KEY (award_cat_id),
KEY award_cat_order (award_cat_displayorder)
) TYPE=MyISAM[/sql]

[sql]
INSERT INTO " . TABLE_PREFIX . "award_cat
(award_cat_id, award_cat_title, award_cat_desc, award_cat_displayorder, award_cat_parentid)
VALUES (1, 'Default', 'Default category', 1, -1)[/sql]

mtha	12-01-2005 02:09 PM

Quote:

Originally Posted by samu2

could somebody please tell me the right code to put the link to awards in my navbar?

http://www.w3schools.com/html/html_links.asp

<a href="awards.php">$vbphrase[awards]</a>could work

ChrisBaktis

12-01-2005 03:01 PM

Quote:

Originally Posted by mtha

Got this error on the third query:

PHP Code:


		
			
An error occurred while attempting to execute your query. The following information was returned. 

error number: 1064 

error desc: You have an error in your SQL syntax near '" . TABLE_PREFIX . "award_cat 

(award_cat_id, award_cat_title, ' at line 1

mtha	12-03-2005 09:49 PM

Quote:

Originally Posted by ChrisBaktis

Got this error on the third query:

PHP Code:


		
			
An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: You have an error in your SQL syntax near '" . TABLE_PREFIX . "award_cat 
(award_cat_id, award_cat_title, ' at line 1

remove the " . TABLE_PREFIX . " in that query.

ps. REMEMBER to correct prefix with yout vB tables if you use it.

ChrisBaktis

12-04-2005 03:12 AM

worked great - thanks.

gator777

12-06-2005 08:01 PM

I noticed you changed the look with the postbit. It now has a box around it, and some additional text. I don't have a copy of the old "postbit" code you provided in an earlier version where it showed just the medals and a "more info..." link. Could I possibly have the old postbit code to make it more streamlined, because it gives to much height to the post header (postbit).

Thanks for this great program, and any help would be greatly appreciated. :)

nexus851

12-11-2005 06:40 AM

after u request a reward, where do you go to moderate the request??? i dont see anything in the admin area for moderation....

Gaskell

12-11-2005 05:13 PM

It will be in ACP -> Award System -> Award Manager.

sifuhall

12-16-2005 12:57 AM

Hello. I just installed and immediately recieved several hundred error emails (we have a very busy site) with the following error:

Code:

Invalid SQL:



                        SELECT a.*, au.*, post.userid, post.postid 

                        FROM post AS post

                        INNER JOIN award_user AS au ON (au.userid=post.userid)

                        INNER JOIN award AS a ON (a.award_id=au.award_id)

                        WHERE post.postid IN (0,214689,214697,214701,214703,214705,214711,214713,214715,214731,214742,214745,214747,214767,214768,214771)



                        GROUP BY au.issue_id

                        ORDER BY au.issue_time DESC;



MySQL Error  : Unknown column 'a.award_id' in 'on clause'

I opened my awards table (it was created and appears there was no errors during the creating step of installation) and sure enough, there is no field named award_id in the awards table.

However there is a fieldnamed awardsid

Could this be a left over remnant from a hack long ago?

MissKalunji

12-16-2005 01:33 AM

Quote:

Originally Posted by sifuhall

Hello. I just installed and immediately recieved several hundred error emails (we have a very busy site) with the following error:

Code:

Invalid SQL:



                        SELECT a.*, au.*, post.userid, post.postid 

                        FROM post AS post

                        INNER JOIN award_user AS au ON (au.userid=post.userid)

                        INNER JOIN award AS a ON (a.award_id=au.award_id)

                        WHERE post.postid IN (0,214689,214697,214701,214703,214705,214711,214713,214715,214731,214742,214745,214747,214767,214768,214771)



                        GROUP BY au.issue_id

                        ORDER BY au.issue_time DESC;



MySQL Error  : Unknown column 'a.award_id' in 'on clause'

its because its a none register post......check in the previous post theres fix for it

apfparadise

12-18-2005 04:56 AM

I need some help. Brilliant hack, I used the 3.0 one by Inf.Webby and now I upgraded to 3.5 and this is a BIG must for me. It's installed and I love it, specially all the cool new stuff, BUT...

My awards are kind of big, and I would like a <br> between them so that they show one under the other. Which template is that done in? I have been trying for 2 hrs and can not figure it out. I am pretty sure it can be done, I did it in 3.0 somehow but who can remember, right? :)

Thank you in advance for the help.
Ed

chimaira

12-18-2005 10:51 AM

right ive added some custom award... but i dont like the placement... i want to place it here (look at pic) What template and where do i need to edit it.. to be put there.. i also dont like the box that much.. is there anyway to remove the box surrounding the award?
Hope someone can help me out here. andthanks :)

tony76

12-27-2005 01:35 AM

Quote:

Originally Posted by chimaira

Good if someone can tell me how to remove the border of the box

shush

12-28-2005 12:32 AM

Can you help me at all please.

I have installed as directed. I am not sure what I have done wrong, but nothing shows up in my ACP for the awards editing.

I have not altered any templates as yet, do I need to do this first, I thought it would have shown in the ACP once I installed.

Any feedback appreciated.
I very much want to use your program and will be happy to support.

Oh here is part of the message that came up when I tried to install.

Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)

ChuckH

12-28-2005 12:40 AM

What is a good image size for the awards? - Nevermind

ChuckH

12-28-2005 05:00 PM

How do I change the column widths on Awards.php? The Award Description column is very narrow, while the users who have received award column is very long. I intend to only award to one user per award, so I would like to balance it out to allow a more in-depth description.

Phlex

12-28-2005 05:02 PM

I got a Problem with just one User
Only his award is shown in the profil , but not in posbit .
What's the problem ?

mackers8923

12-29-2005 01:05 AM

Quote:

Originally Posted by Phlex

I got a Problem with just one User
Only his award is shown in the profil , but not in posbit .
What's the problem ?

Did you complete the postbit template edits?

Spiffware

12-29-2005 02:41 AM

kool thanks for this hack..

Phlex

12-29-2005 01:52 PM

Quote:

Originally Posted by mackers8923

Did you complete the postbit template edits?

yes of course ,but its really wierd , it just doesn't work with one single user

shush

12-29-2005 09:52 PM

Got it running now...No longer need help. Thanks anyway.

I have been wanting something like this for ages, we were placing trophies in members siggies till now.

Great work...I love it!!!

RED_LINE

12-30-2005 03:37 PM

hello

have problems with a modification, when i install the hack i have this error

Code:

Database error in vBulletin 3.5.1:



Invalid SQL:



                                INSERT INTO setting

                                (varname, grouptitle, value, defaultvalue, datatype, optioncode, 

displayorder, advanced, volatile, product)

                                VALUES

                                (

                                        'aw_display_limit',

                                        'awards',

                                        '4',

                                        '4',

                                        'free',

                                        '',

                                        30,

                                        0,

                                        1,

                                        'award'

        ),

        (

                                        'award_pm_fromuserid',

                                        'awards',

                                        '0',

                                        '0',

                                        'number',

                                        '',

                                        100,

                                        0,

                                        1,

                                        'award'

        );



MySQL Error  : Duplicate entry 'aw_display_limit' for key 1

Error Number : 1062

Date         : Friday, December 30th 2005 @ 05:57:01 AM

Script       : http://www.mysite.net/vb/adminCp/plugin.php

Referrer     : 

http://www.mysite.net/vb/adminCp/plugin.php?do=productadd

IP Address   : 75.169.93.198

Username     : RED_LINE

Classname    : vb_database

how can i fix this error?

Best Regards,

shush

12-31-2005 07:05 AM

RED LINE, I had this same error when uploading, see above posts. the awards system still works anyway.

Only thing I have a little query on is this. When you go to plug in manger, any plugins I have are listed. But the awards one does not show as YAAS etc. etc.
It has this message instead.

Yet Another Award System 3.5 2.0.6
https://vborg.vbsupport.ru/showthread.php?t=94836

Waaaaah what have I done wrong?

GlitterKill

01-05-2006 05:24 PM

Hmm I have run into a strange error. When trying to assign an award to any member with a ' in their name it returns an error and the award is not given. For instance, the member name "rockin'male" return an error because of the apostrophe. All other usernames with apostrophes return errors as well when trying to give them awards.

Any ideas how to fix this?

Also here are urls to our implementation if you would like to use them in the examples.
http://forums.pimprig.com/awards.php
http://forums.pimprig.com/showpost.p...24&postcount=3
http://forums.pimprig.com/member.php...tinfo&userid=1

Thanks for the great hack!

Edit//crap, I just realized I have those hidden for guests in the postbit. You can login with this account to see...
User: test
Pass: test

mackers8923

01-06-2006 12:23 PM

Hi

I have added this hack to my site and the members love it. I have one request though! In the attached image you'll see one of the various awards from my site.

My question is, how do I extend the amount of text that is allowed to be typed for the description of the award? Some are quite long and as you can see it is being cut short.

I would appreciate any help anyone can offer on this.

Ghanem

01-11-2006 01:54 PM

Hi,
thank you first for the gr8 hack..

I have a small problem with award requests email..
the email received by admin looks like:

PHP Code:


		
			
[b] - admin[/b]

------------------
[color=blue][b]Sender Information[/b][/color]
.
. 
.

while it should look like:
- admin

------------------
Sender Information
.
.
.

Version used: 2.1.2
VB version: 3.5.2

Karsh

01-11-2006 09:16 PM

Hi, i like this hack just one big big problem i want for you to fix for me.

You when an member posts an reply and so on, you see the name and Rep and other things, at the moment the awards are at the bottom how do i make them so it is under the Users name?

Karsh

01-11-2006 09:24 PM

Someone please help on this

Karsh

01-12-2006 11:03 AM

Anyone!?

dubsyxxx

01-13-2006 03:20 AM

how do i give someone the award??? anyone can help

Nick King

01-13-2006 03:37 AM

Karsh, Put the awards code beneath

Code:

$post[musername]

                                </if>

dubsyxxx, goto your admincp -> Awards System -> Award Manager -> *pick the award to give* click Manage and fillin the userid (if you know it) OR (not AND, OOOORRR I've had many people fill in both and get it wrong and mess it up) username and the issue reason. If you want to notify the user via PM, check Yes and click save.

Gaskell

01-13-2006 03:24 PM

Quote:

Originally Posted by dubsyxxx

how do i give someone the award??? anyone can help

If an award has been requested (from the page like this), check the ACP for Award System. In that part there will be Award Manager. Next to the award you want to give someone, click Manage. Fill in the User ID or Username boxes and put in a reason if you want. Hit Save and its done :)

Ghanem

01-13-2006 03:44 PM

what about me :(
https://vborg.vbsupport.ru/showpost....&postcount=228

2fast4ya

01-16-2006 09:38 PM

Hello, awards are not showing up in member's posts... what have i done wrong?

2fast4ya

01-16-2006 09:41 PM

and yes ive done the postbit tempelate edits. ive double checked them as well to make sure i've done them correctly.

2fast4ya

01-16-2006 09:47 PM

okay, i looked at this again... it works in postbit_legacy, but not in postbit... but the tempelate edit is correct!

dubsyxxx

01-16-2006 11:42 PM

Quote:

Originally Posted by Gaskell

thanks a lot your the man

Gaskell

01-17-2006 12:56 PM

No problems - happy to help where I can :)

All times are GMT. The time now is 07:46 PM.

Page 6 of 15

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02687 seconds Memory Usage 1,872KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (5)bbcode_php_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: