vb.org Archive
Page 21 of 57 « First 111920 21 222331 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
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 
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
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]
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.


All times are GMT. The time now is 08:39 AM.
Page 21 of 57 « First 111920 21 222331 Last »
Show 40 post(s) from this thread on one page

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.01536 seconds
  • Memory Usage 1,765KB
  • 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_php_printable
  • (4)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
  • (10)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