vb.org Archive - [HTL] & [TXT] Awards/Medals/Cards Hack [vB3]

Page 5 of 49

« First

Last »

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

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

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - [HTL] & [TXT] Awards/Medals/Cards Hack [vB3] (https://vborg.vbsupport.ru/showthread.php?t=61108)

Sadie Frost

02-14-2004 07:37 AM

I installed this with no problem on RC3, but installing on RC4 I get no awards showing anywhere and can't figure out why. I doublechecked all the code additions and I don't think I missed any.

Edit: for some reason the award template wasn't added - that fixed it :)

blubber12

02-14-2004 02:13 PM

Thanks that was the fix. Installed and working on rc2. Thanks again.

Sadie Frost

02-14-2004 06:45 PM

When I try to read and announcement, I get this error at the top of the page:

Quote:

Warning: Invalid argument supplied for foreach() in /path/to/forums/includes/functions_showthread.php on line 792

which is "foreach($awards AS $useraward)"

Any ideas?

agbates

02-15-2004 02:51 PM

I think AnimeWebby is doing a great job..and thanks go to Lesane for his original idea. I am also going to wait until Gold before I install this, but one thing is for sure..I am going to install it! It's a great idea that really should have been included into VB.

maurier

02-15-2004 06:55 PM

I have run SQL-query using phpmyadmin getting error: my site vbRc4 help me please !

Quote:

CREATE TABLE " . TABLE_PREFIX . "award (
awardid smallint(5) unsigned NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
description varchar(250) NOT NULL default '',
icon_url varchar(250) NOT NULL default '',
PRIMARY KEY (awardid)
) TYPE=MyISAM;

MySQL said:

You have an error in your SQL syntax near '" . TABLE_PREFIX . "award (
awardid smallint(5) unsigned NOT NULL auto_incre' at line 1

Quote:

CREATE TABLE " . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL auto_increment,
PRIMARY KEY (userid)
) TYPE=MyISAM;

MySQL said:

You have an error in your SQL syntax near '" . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL auto_increment,
' at line 1

InfiniteWebby

02-16-2004 12:26 AM

@sadie: it looks like you may have missed out a step. you have to add

PHP Code:


		
			
global $awards;

after

PHP Code:


		
			
global $vboptions, $stylevar, $vbphrase, $DB_site, $datastore, $_USEROPTIONS, $style, $show, $usergroupcache;

in your /includes/functions_showthread.php file

@maruier: you are meant to replace " . TABLE_PREFIX . "with your table prefix before you run those queries.

kcradio

02-16-2004 04:20 AM

I am still getting this error:

SQL-query :

CREATE TABLE " . TABLE_PREFIX . "award(

awardid smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL default '',
description varchar( 250 ) NOT NULL default '',
icon_url varchar( 250 ) NOT NULL default '',
PRIMARY KEY ( awardid )
) TYPE = MYISAM

MySQL said:

#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 '" . TABLE_PREFIX . "award( awardid smallint( 5 ) unsigned NOT

Can anyone tell me what I am doing wrong on this?

kcradio

02-16-2004 04:22 AM

nevermind, if I look up a thread I can see the answer, sorry...

InfiniteWebby

02-16-2004 05:16 AM

if you are getting an error when you are trying to view announcements then.....

in /includes/functions_showthread.php
instead of finding

PHP Code:


		
			
    $show['messageicon'] = iif($post['iconpath'], true, false);

find:

PHP Code:


		
			
            $show['reputationlink'] = iif($vboptions['reputationenable'] AND $bbuserinfo['userid'] AND $post['userid'] AND !($usergroupcache["$post[usergroupid]"]['genericoptions'] & ISBANNEDGROUP), true, false);

then add above it:

PHP Code:


		
			
            // AWARDS IN POSTBIT

            foreach($awards AS $useraward)

            {

                $userawardid = "award$useraward[awardid]";

                if (!empty($post[$userawardid]))

                {

                    $userawardid_desc = $userawardid."_desc";

                    if ($post[$userawardid_desc] != '')

                    {

                        $useraward[description] = $post[$userawardid_desc];

                    }

                    eval('$awardsbit .= "' . fetch_template('award') . '";');

                }

            }

            // END AWARDS IN POSTBIT

I will update all the files soon with all the current bug fixes plus instructions for versions less than RC 4. Sorry for the inconvinience

Sadie Frost

02-16-2004 07:42 AM

Works perfectly now - thanks! :D

All times are GMT. The time now is 06:28 AM.

Page 5 of 49

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01581 seconds Memory Usage 1,757KB 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 (5)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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
Messages: