[HTL] & [TXT] Awards/Medals/Cards Hack [vB3]

[InfiniteWebby]

Awards/ Medals/ Cards Hack [vB3]
By: AnimeWebby
Idea by: Lesane
Updated: 28nd May 2004 - Installer not table prefix friendly.

What this hack does:
This hack allows you to add awards, medals or cards to your vbulletin and assign these to members who you think deserve them.
These graphics will then show up in their member profile and/or their postbits depending on where you choose to add this hack.

New in v2
- Extra page showing all awards available as well as all the users who have earned an award.
- Support for full urls and relative ones for award icons.
- Support for awards on showpost and announcement

Other Stuff:
Although I give credit to Lesane for the idea this hack is totally recoded to be less server intensive and also uses a whole lot less queries. Therefor I do not consider this a 'port'.

Installation:
Download the appropriate .Zip file and follow the instructions in the readme file.

Upgrading:
So far there are no ways to upgrade this hack, if you have an old copy installed then you need to uninstall and reinstall from scratch.

Coming Soon:
- Awards added to the search and memberlists.
- Added functions to the addition of awards as well as cron functions to assign awards automatically to those members with 'X' posts, registered 'X' days etc...
- Option to show award name rather than graphic.
- Option to turn awards OFF & ON in postbit and memberinfo
- Request award on awards page (at Cyricx' request)
(not necessarily in that order)

Make sure you backup your files and database first! This hack has been tested on vB RC1 and RC4 only!

Please click the install button

If you experience any errors, problems or the hack doesn't seem to be functioning correctly then send me a pm with the following info:
- HTL or Standalone installer.
- Version of vB you are running.
- File where error is encountered.
- Exact error or description of error.

Views so far:
[NORMAL]AwardsMedalsCardsv2.1.zip (12.7 KB, 69 views)
[HTL]AwardsMedalsCardsv2.1.zip (12.8 KB, 57 views)
[TXT]AwardsMedalsCardsv2.zip (8.5 KB, 278 views)
[HTL]AwardsMedalsCardsv2.zip (10.2 KB, 203 views)

If you installed this hack before 23rd May and are getting foreach errors in your showthread then follow the step below:

In /includes/functions_showthread.php find:
// sorts through all the stuff to return the postbit template
below that add:
// user awards
global $userawards;

If in your showthread.php member post counts show N/A, they have no profile link or their user title is guest you MUST run 'Fix broken user profiles' in the update counters part of the admincp. This is found under the nav bar 'Import & Maintenance' > 'Update Counters' > 'Fix broken user profiles'. This will add the awards for all the users currently in your database and prevent showing incorrent member info.

[Cyricx]

*looks around*

I don't see the attachment??

Cyricx

[Oblivion Knight]

Hmm.. It might help attaching the zip.? ;)


[EDIT]
Sorry, didn't notice the time the thread was posted etc.

[InfiniteWebby]

god you got no patience do you, I like to add the thread links to my installtion should you ever lose it but need support.

[SnowBot]

:)

[gmarik]

It is crazy

[Lesane]

Good to see that it's ported over to vb3, good work. :)

[Metro Man]

nice Hack good work.

[MGM]

ill wait for that page that shows all of the awards and who has what before i add this, but ill install it anyways just to make sure i get the email for the update (if u send one out)

/me clicks Install

MGM out

[Boofo]

Are there any graphics available with this or would we have to make our own?

[trackpads]

Thank you!!

[kcradio]

trying to run the sql files and I am getting this error:

SQL-query :

CREATE 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. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'award (
awardid smallint(5) unsigned NOT NULL auto_increment,

What am I doing wrong?

[Cyricx]

add a ; at the end

Only thing I can think of that would rock even more for this, would be to make some of the awards user requestable, and then the admin could approve.

Great job, I may use this. :)

[speedway]

add a ; at the end

Only thing I can think of that would rock even more for this, would be to make some of the awards user requestable, and then the admin could approve.

Great job, I may use this. :)
Ummm....then it wouldn't be an award would it :) "I request the member of the month award please..." LOL!

[trackpads]

This might be a dumb question but once we give the user an award, it is permamnet right? For example I want to give people awards for things they do/volunteer to do on the site. And then give that award to others also, like military awards etc.

Thanks again,

-Jason

[lasto]

anyone got this in action so we can see it ??

[trackpads]

anyone got this in action so we can see it ??
I REALLY want this but I am hoping for Gold soon so I dont have to re-hack it. It looks great!

-Jason

[lasto]

LOL nps trackpads - im just waiting for someone to test it and be the guinea pig.
I cant add hacks unless im 100 % sure as cant back up databse cause i have probs telenetting in :(

[Cyricx]

Your right, it would then be a Medal ;)

Hehe reason I ask that is I run a forums for an Online Game. And there are certain achievments you can attain that I could have awards displayed for the members that have done them.

But I'd hate to have to go through and check every member, would rather have them request it, then I'd verify, and set it, if they had done it.

Hmmm, that make sense? :P

[blubber12]

Well I've been trying to install and am receiving a variety of errors on RC2...the biggest one, and it took me a while to figure out...The query for insert in phrases...14009 is listed twice...so I had to change it to 14005 in order for the query to run correctly. Have also been having problems with various functions..I will not list them now..Going to try a clean install and see if it sorts itself out first. If the same errors appear, I"ll post them

[lasto]

so no one has installed this successfully as yet then ??

[blubber12]

Well went though a fresh install and still the same problems. biggest problem is the entire forum pushes completely over the the right of the screen...login types from right to left...and there is no access to acmincp. on login to htere..the message comes up .thank you for logging in...notice the period in front of thank Then the screen goes back to login. On posting 3 errors come up showing problems in functions_showthread line 68... When I remove the modded functions.php and adminfunctions.php, everything goes back to normal..but of course there's no hack now. Also on the admincp..there shows a new blank box with no arrow, and unclickable.

[Oblivion Knight]

I had the exact same problems as listed above by blubber12 testing it on my test board.

[Cheffe]

I had the exact same problems as listed above by blubber12 testing it on my test board.
Me too, same errors using RC2.

[xug]

Good to see that it's ported over to vb3, good work. :)

Hey Lesane.

Maybe you need to convert yours, then for sure we get a working hack ;)

[InfiniteWebby]

This is a working hack however it is only working on my Gamma 1 test board. It may be the way i setup the instructions or there might be changes in the code since Gamma 1. I have not had access to download the latest vbulletin but I will do so soon and try to get this fixed.

[InfiniteWebby]

I have fixed the problem. For a temporary fix to installing this hack you MUST run 'Fix broken user profiles' in the update counters part of the admincp. This is found under the nav bar 'Import & Maintenance' > 'Update Counters' > 'Fix broken user profiles'. This will add the awards for all the users currently in your database. BEFORE your perform step 10!!!!

I will try to get a HTL version released to fix any other problems arising from the phrases.

[blubber12]

Well I would gladly run the update..but once all the files are changed..the board distorts and logging in is impossible..The login problem disappears once the adminfunctions.php is replaced with the original...but that is way before step 10..

[InfiniteWebby]

The problem had nothing to do with the adminfunctions.php. It was happening because in the functions.php the getuserinfo function was looking for a table that didnt exist at the time. Thus running the fix broken user profiles would populate this table and the problem was solved.

I have however fixed this by using a left join instead of an inner join where the table is not required to be populated. So give the new installers a try.

P.S I have added some screenies too! and the htl version of this hack.

[deathemperor]

great, I'm waiting for the Gold version of Vb3, I will install this at the time I got the Gold Vb3.
question: can I make Awards for users who won Arcade games ?

[InfiniteWebby]

sure, you can make awards for just about anything you desire. For instance I have awards for referals, GFX and Supporters. So when I notice a person has bought us alot of new members I give them a referal award when they do a good job in our gfx section i give them that award and if they contribute some spare cash to the forums i give them that one.

In future versions I will hopefully set it up so that some of the awards check members automatically.

[Oblivion Knight]

Awesome, I'll have a second go on my test board soon.. :)
I've attached a medal icon set I quickly whipped up in case anyone is struggling. They will probably not work well on darker backgrounds though.

[tides]

Just a stuby question...
Is this hack workw with RC4?

[blubber12]

Well it looks like everything is fine until you get to here

admincp/user.php

=>Find:

if ($vboptions['cp_usereditcolumns'] == 2)
{
?>
</table>
</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td><td>
<table cellpadding="4" cellspacing="0" border="0" align="center" width="100%" class="tborder">
<?php
}
else
{
print_table_break('', $INNERTABLEWIDTH);
}

This does not appear in admincp/user.php

[Osterling]

Just a stuby question...
Is this hack workw with RC4?

I am wondering that too.. does it work with RC4?

[TheComputerGuy]

Defintly cool hack.

I can't wait to install it when I get home tonight.

[SB2002]

i justr tried it on my rc4 and the final hacks on showthread dont seem to work. I checked through and i cannot find any reason why they are not working, but it screwed up the cookie sending when i tried and it came up with the "unable to send header" errors. I'm not saying that the hack doesnt work with rc4 tho, cos i have a few htl hacks installed, but none seem to be around that area that this hack modifies

[blubber12]

any solution to my post above? https://vborg.vbsupport.ru/showpost.php?p=474905&postcount=34

[InfiniteWebby]

@blubber: you must be using a version less than RC4. Try finding this:
?>
</table>
</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td><td>
<table cellpadding="4" cellspacing="0" border="0" align="center" width="100%" class="tborder">
<?php

@SB2002: this hack does not send any new headers out. Can you please give me more details about your errors. Eg. What file you where viewing the line number of the error etc...

[SB2002]

@blubber: you must be using a version less than RC4. Try finding this:
?>
</table>
</td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td><td>
<table cellpadding="4" cellspacing="0" border="0" align="center" width="100%" class="tborder">
<?php

@SB2002: this hack does not send any new headers out. Can you please give me more details about your errors. Eg. What file you where viewing the line number of the error etc...
ok. i have the day off of work today so I'll give it another try and see how it goes again and then get back to you with the results.

[Sadie Frost]

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]

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

[Sadie Frost]

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

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]

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]

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

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



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]

@sadie: it looks like you may have missed out a step. you have to add global $awards; after 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]

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]

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

[InfiniteWebby]

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

in /includes/functions_showthread.php
instead of finding $show['messageicon'] = iif($post['iconpath'], true, false);
find: $show['reputationlink'] = iif($vboptions['reputationenable'] AND $bbuserinfo['userid'] AND $post['userid'] AND !($usergroupcache["$post[usergroupid]"]['genericoptions'] & ISBANNEDGROUP), true, false);
then add above it: // 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]

Works perfectly now - thanks! :D

[The Quibbler]

I get an error when trying to install the hack using the Hack Tracking Log at /admincp/index.php?loc=install_htl.php?inside=1:

Parse error: parse error in /home/quibbler/public_html/forums/includes/functions.php on line 1805

Fatal error: Call to undefined function: exec_nocache_headers() in /home/quibbler/public_html/forums/admincp/global.php on line 37

Looked at the code, but couldn't figure anything out. Any idea what's wrong? I think it has something to do with the file edits I did for this hack.

[The Watcher]

I have installed this successfully on RC3 and I have to say - GREAT HACK !!!

I followed the txt instructions and there were some differences in the codes quoted and what are in my phps but that was only a minnor problem. Also I spotted one very small error. In awards.php line 179 should be:

<td class=\"$bgclass\" align=\"center\"><img src=\"../$award[icon_url]\" border=\"0\"></td>

Instead of ...

<td class=\"$bgclass\" align=\"center\"><img src=\"$award[icon_url]\" border=\"0\"></td>

(You missed out the ../ and as a result the images don't preview in the admin cp)

2 questions ...

1) How do I split the awards up. Currently they are directly next to each other with no spaces.
3) Any chance of some more medals/awards/trophy images being posted?

Thanks Again Great Work

[neocorteqz]

I have installed this successfully on RC3 and I have to say - GREAT HACK !!!

I followed the txt instructions and there were some differences in the codes quoted and what are in my phps but that was only a minnor problem. Also I spotted one very small error. In awards.php line 179 should be:

<td class=\"$bgclass\" align=\"center\"><img src=\"../$award[icon_url]\" border=\"0\"></td>

Instead of ...

<td class=\"$bgclass\" align=\"center\"><img src=\"$award[icon_url]\" border=\"0\"></td>

(You missed out the ../ and as a result the images don't preview in the admin cp)

2 questions ...

1) How do I split the awards up. Currently they are directly next to each other with no spaces.
3) Any chance of some more medals/awards/trophy images being posted?

Thanks Again Great Work
Add a <br> tag before, or after $post[arcadeawards] depending on how you would like it to look.

In postbit or postbit_legacy depending on which you use.

[InfiniteWebby]

@ the quibbler: Line 1805 or any lines surrounding that in /includes/functions.php has nothing to do with this hack unless you put something in the wrong place.

@the watcher: I am aware of the changes in code. I am trying to setup my own board and am not worried about some minor indescretions in the find and replace parts.

Also that isn't so much a mistake if you use full url's to your awards images which I thought people woulc use. But I will take this into account and build some added functionality.

1) shove a couple of &nbsp; at the end of the awards template or you can add some <br />'s depending on how you want them split up.
3) I think you meant 2) but oh well :P Not at the moment I am too busy, and not too graphical.

[The Watcher]

thanks :)

Ill find my own images and post them here haha

With reference to the spacing, this is what i was trying to acheive - sorry if I did not explain clearly ...

Ideally i would like my 5 medals on one line with 2 spaces inbetween and then my 3 trophies on the line below with perhaps 3 spaces in between.

couldn't work out how to do that though

thanks again

[mtha]

ERROR!!!

Warning: Invalid argument supplied for foreach() in /XXXXXXXXXXXXXXX/forums/public_html/includes/functions_showthread.php on line 693when you run forums/showpost.php?p=xxxxx


You may want to add $awards array into showpost.php too, like you did in showthread.php

[InfiniteWebby]

I will be moving it to the top of showthre_functions.php in the next version please bare with me.

[trackpads]

I will be moving it to the top of showthre_functions.php in the next version please bare with me.
Thanks again for all the work!

[M.C.]

i`ve got small bug! In Private Messages Page i got that:

Warning: Invalid argument supplied for foreach() in z:\home\localhost\www\forum\includes\functions_sho wthread.php on line 691

on that line is hack code:


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') . '";');
}
}

[Face Off Mobile]

cant run both sql queries in the txt file can someone please tell me what they should be

thank you

[mtha]

i`ve got small bug! In Private Messages Page i got that:
Warning: Invalid argument supplied for foreach() in z:\home\localhost\www\forum\includes\functions_sho wthread.php on line 691

Anypage that has user postbit displayed /showthread used will have the same problem

PM, view thread, viewpost ...

maybe this hack should be moved to Beta mods, as of it's not completed



cant run both sql queries in the txt file can someone please tell me what they should be

thank you

:) dont think anyone can tell you if you dont tell us what the error is, and some details. otherwise, I just say, they should be as it is in the txt file.

[InfiniteWebby]

OK just upldated the attachements to version 2 where the errors regarding the showpost and announcements are fixed and also the extra page for users who have awards has been added.

I was hoping to get the request award option finished but I think this is an important update.

[SpankMe]

Nice hack. What I would like to see is the ability to give Mods and/or Super Mods the option to give out awards.

[SpankMe]

Never mind. I've done it myself.

[SpankMe]

Something else I've added you might want to think about, is who gave the award.

[mtha]

OK just upldated the attachements to version 2 where the errors regarding the showpost and announcements are fixed and also the extra page for users who have awards has been added.

how should I upgrade from version 1?

[maytrix]

Just a note, your awards hack and the vbarcade hack are not compatible. You use a global of $awards which is also used by that hack. If you change your global to $awards2 you can get both to live in harmony.

[Flow Fusion]

Can someone clean up the text file for this hack? When I try to view it on my Mac it looks like a mess?

[Roxie]

So, is this hack beta?

[InfiniteWebby]

@mtha: the only option is to undo all the changes made in v1 and then redo all the changes in v2

@maytrix: I realise that and I think to keep adequate varibale names you should change alll occurances of $award or $awards used in the arcade hack to $arcadeawards but whatever tickles your fancy so to speak.

@flow fusion: i cant help you out in anyway except to advise you to use HTL instead of relying on text files, macs aren't my speciality.

@roxie: I don't conisder it beta as it works perfectly at the moment. However some might consider it still in beta stages because of the large amounts of bugs found last time and that it might be the same case this time.

[mtha]

Awards/ Medals/ Cards Hack [vB3]
By: AnimeWebby
Idea by: Lesane

New in v2
- Extra page showing all awards available as well as all the users who have earned an award.
- Support for full urls and relative ones for award icons.
- Support for awards on showpost and announcement

Installation:
Just upload award.php to your admincp, awards.php to your root directory and follow the instructions in the text file.
it seems that the HTL and TXT instructions are different.

1: There's NO award.php in HTL zip file, there's only 1 file in /admincp/award.php
2: Cant find:

require_once('./includes/functions_bbcodeparse.php');
global $vboptions, $stylevar, $vbphrase, $DB_site, $datastore, $_USEROPTIONS, $style, $show;


for step 9 in /includes/functions_showthread.php


Cant find this step on HTL instruction (it's only in TXT one)
==>Find:
// do posts from ignored users
if ($tachyuser AND THIS_SCRIPT != 'showpost' AND THIS_SCRIPT != 'private')
{
$maintemplatename = 'postbit_ignore_global';
}
else if ($ignore["$post[userid]"]/* AND !in_array($post['userid'], explode(' ', $bbuserinfo['buddylist']))*/)
{
$maintemplatename = 'postbit_ignore';
$show['showpostlink'] = ($alternate != 'usernote');
}

==>Replace With:
// AWARDS IN POSTBIT
foreach($awards AS $key => $useraward)
{
$userawardid = "award$useraward[awardid]";
if (!empty($post["$userawardid"]))
{
$userawardid_desc = $userawardid."_desc";
if ($post[$userawardid_desc] != '')
{
$useraward[description] = $post[$userawardid_desc];
}
eval('$post[\'awards\'] .= "' . fetch_template('awards_bit') . '";');
}
}
// END AWARDS IN POSTBIT
-------------------------------


and others ... after that

[Cyricx]

I will suggest that you go through the code fully again.

Make sure the templates names are correct.

I had to spend about a hour debugging the code and finally was able to fix it. It was searching for a template that doesn't exist.

I had to compare the file edits between both HTL / Text File. From my observation, one of those are outdated.

But it's working on my site now.

Cyricx

[maytrix]

I too had to go through the code twice. I also had to make it work better with some previous installed hacks. It is is a good working hack, but it is a medium to high installation skill level.

[InfiniteWebby]

@Cyricx: What template is that?

And I uploaded the wrong file so I will fix it as soon as I finish this post, sorry to all but trying to keep up with what you've done and haven't done gets quite confusing.

[Flow Fusion]

@Cyricx: What template is that?

And I uploaded the wrong file so I will fix it as soon as I finish this post, sorry to all but trying to keep up with what you've done and haven't done gets quite confusing.
Ok I installed this onto my forum and I get this error message when I try to view any of the threads.


Unable to add cookies, header already sent.
File: /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php
Line: 679


Any suggestions? Cause I been at it all night/Morning

[Flow Fusion]

Ok I installed this onto my forum and I get this error message when I try to view any of the threads.


Unable to add cookies, header already sent.
File: /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php
Line: 679


Any suggestions? Cause I been at it all night/Morning
Oh yeah once this is fixed. Where do I go to add an award? Or give someone an award?

[maytrix]

Ok I installed this onto my forum and I get this error message when I try to view any of the threads.


Unable to add cookies, header already sent.
File: /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php
Line: 679


Any suggestions? Cause I been at it all night/Morning

What is on lines around 679 in your functions_showthread.php?

[Flow Fusion]

What is on lines around 679 in your functions_showthread.php?
if (!empty($post["$userawardid"]))

{

$userawardid_desc = $userawardid."_desc";
if ($post[$userawardid_desc] != '')

{

This is from 674 to 681 and I tried to remove the spaces

[maytrix]

Did you fix user info like it says in the last step?

[Flow Fusion]

Did you fix user info like it says in the last step?
What do you mean? I did everything it says in the Hack

[maytrix]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~
| Step 6: Finishing up!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~

==>You need to run 'Fix broken user profiles' in the update counters part of the admincp. This is found under the nav bar 'Import & Maintenance' > 'Update Counters' > 'Fix broken user profiles'. This will add the awards for all the users currently in your database.

==>Don't forget to upload award.php to your admincp directory and awards.php to your root directory as well as any modified files to their appropriate directories.

[Flow Fusion]

Ok I did it same error message on the same line 679

Matter of fact I fixed everything...help meeeeeeee

lol

[Flow Fusion]

Parse error: parse error in /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php on line 679

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php:679) in /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions.php on line 2753

[Flow Fusion]

$url = str_replace('&amp;', '&', $url); // prevent possible oddity
header("Location: $url");
unset($shutdownqueries['pmpopup']);

[Flow Fusion]

Unable to add cookies, header already sent.
File: /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions.php
Line: 3695

Now I'm getting this error message after I removed the spaces

[Flow Fusion]

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, useraward.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,

NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN useraward AS useraward ON(useraward.userid = user.userid)
)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,3861,3863,3866,3870,3873,3895,3896,3910)
ORDER BY dateline

mysql error: You have an error in your SQL syntax near ')
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS a' at line 19

mysql error number: 1064

Date: Wednesday 10th of March 2004 10:57:54 AM
Script: http://flowfusion.biz/forum/showthread.php?t=748
Referer: http://flowfusion.biz/forum/forumdisplay.php?f=2


Back to where I started

[Alzeimer]

I can?t find


Find in File /showpost.php

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

where paste this?

// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 20 ] LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid) LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid) // [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 20 ]

Thanks

[Flow Fusion]

Parse error: parse error in /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php on line 680

Fatal error: Call to undefined function: construct_postbit() in /hsphere/local/home/mojoblac/flowfusion.biz/forum/private.php on line 1331

When I click on any private messages. This is the only hack I really want please someone help me. Or at lease tell me how to revert my board back to the way it was.

[Cyricx]

Anime:

If I remember correctly, it was $awardsbit and $award_bit ...

It was a headache having to go through the code trying to figure out what was not working...

Shaz

[InfiniteWebby]

@Flow Fusion: As far as I can tell you have a different version or applied the code changes in the wrong place. There shouldn't be any code changes on line 679 or around there in v2. Send me your functions_showthread.php via pm and I will have a look.

@Alzeimer: Sorry, should be find:LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

@Cyricx: You said you had trouble finding templates to edit. The names you just gave me are varibales hence the $ sign and if you meant you needed to find awardsbit and award_bit then you needed to add them not edit them.

[Flow Fusion]

@Flow Fusion: As far as I can tell you have a different version or applied the code changes in the wrong place. There shouldn't be any code changes on line 679 or around there in v2. Send me your functions_showthread.php via pm and I will have a look.

Ok I PMed you and I went back to the way my board was till you can get back to me.

[CHeeKY]

AnimeWebby just wanted to say thanks for all the support so far, ya doing well kid hang in there :)

I have a couple of things, working of a vb3rc2, have installed the hack and all seems ok apart from:

1. When I add a hack or modify I get a message telling me that the phrase "Saved named x saved succesfully" could not be found, I checked and its there for sure.

2. When I goto a user and click Yes to a medal and put a reason, I then click save, and it doesnt save, I go back to the user and its set to NO and viewing the users profile shows nothing. So basically its not saving the action. Any ideas?

Regards

[InfiniteWebby]

AnimeWebby just wanted to say thanks for all the support so far, ya doing well kid hang in there :)

I have a couple of things, working of a vb3rc2, have installed the hack and all seems ok apart from:

1. When I add a hack or modify I get a message telling me that the phrase "Saved named x saved succesfully" could not be found, I checked and its there for sure.

2. When I goto a user and click Yes to a medal and put a reason, I then click save, and it doesnt save, I go back to the user and its set to NO and viewing the users profile shows nothing. So basically its not saving the action. Any ideas?

Regards
1. do you mean when you try to add an award? if so make sure the phrase is in the control panel stop messages.

2. If you are using the htl version of the hack it might have something to do with the comments it places before and after any file edits. So just check out admincp/user.php and if you have any comments in between mysql then remove them. If not just make sure you applied all the changes to that file.

[CHeeKY]

Thanks m8, now I get a different error.

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, useraward.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN useraward AS useraward ON(useraward.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,2175,2213,2226,2710,2753,2824,2826,2827,2829,28 32)
ORDER BY dateline

mysql error: Unknown table 'announcement' in on clause

mysql error number: 1109


It stems from the install code of showpost.php and showthread.php

in my vb RC2 showthread.php I have

LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)


on your install script I have

>Find:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

==>Replace With:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)

I dont have reference to the annoucement.userid...

Hope you can help :)

[CHeeKY]

ok update :)

I took out the annoucements and fixed the user.php and its all working great :)
Top marks for the hack m8 :D:D:D

[Flow Fusion]

Ok in some of the files it says thing like edit "poll results" and add "poll result add award" or something. But I was wondering do you edit ALL of the poll results etc. Or just the first ones?

[Flow Fusion]

geez it's seems when I upload the "showthread.php" everything goes to hell. I don't know which one to edit. From the

In /showthread.php
-------------------------------

==>Find:

'pollresult'

==>Replace With:

'pollresult',
'awards_bit'

==>Find:

usertextfield.*,

==>Replace With:

usertextfield.*, useraward.*,

==>Find:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

==>Replace With:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)

Their is 2 of each these. And on the LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

in my file it has
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

See how it has AS as oppose to ON?

Please help?

[Flow Fusion]

Any one?

[lasto]

not installed this m8 but if there is 2 here is what i would do

i would try it on the first one then save file (always backup orginal files first) and if it dont work then try it on the second one.

Its gotta be one of the two :)

[Flow Fusion]

not installed this m8 but if there is 2 here is what i would do

i would try it on the first one then save file (always backup orginal files first) and if it dont work then try it on the second one.

Its gotta be one of the two :)
Hey funk it why not? LOL

[Flow Fusion]

OK I figured it out..I think...everything seems to be working ok but the awards are not showing?

On the showthread.php I went edit 1 than 2 than 2. Not sure if that was correct but I don't get any errors on viewing the forum. Any suggestions on how to make them show anybody? I'll post up what I did later to help others when I come home from work in the morning.

[Flow Fusion]

<a href="http://flowfusion.biz/forum/awards.php" target="_blank">http://flowfusion.biz/forum/awards.php</a>

Is all I get. I can't get the images to show in the postbit. Or in the members.php.

Any suggestions on why the images are not showing?

[lasto]

http://flowfusion.biz/forum/awards.php

Is all I get. I can't get the images to show in the postbit. Or in the members.php.

Any suggestions on why the images are not showing?

aint tried this hack but lookin at your awards m8 it looks a good hack

im gonna grab and install local and will let u know how i get on with it see if i have same prob

[lasto]

cant go no furhter so u got further than me m8

the queries dont work for me

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
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 NU

[lasto]

in fact i get same error trying any of the queries and they do have the ; on the end

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

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. Check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL aut

IGNORE - dumbo here forgot to remove the table prefix - not sure why that was in there.

[Flow Fusion]

I'm lurking here. Just take your time ok. And double check everything till you get to the "showthread.php" and remember the 1, 2, 2, thing I posted it will come in handy. If I'm right. Geez this is the heart and soul of my forum.

[eXtremeTim]

Replace " . TABLE_PREFIX . " with and table prefix you might be using for your copy of vb3 if not using a table prefix remove it from the query and then it will work.

[eXtremeTim]

If I get time tonight I will install this hack on my site and then tell you all what I had to change or what not.

[Flow Fusion]

Ooh help me, help me?

[lasto]

i cant go no further - the full hack is installed local but im getting this

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, useraward.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,41328)
ORDER BY dateline

mysql error: Unknown table 'useraward'

mysql error number: 1051

an di can tell u ive double checked though mysql front and the table is deffo there with no info in it when i query it so im double stuck now as im lost

thi ssi the way i ran the query as i dont use prefixs

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

[eXtremeTim]

Try repairing the table and see what happens.

[lasto]

tried it m8

no luck - was first think i thought of - ive even dropped the 2 tables and re-added em

could anything else be causing that error ??

i really stuck here at moment as i can view main page of my test board but i get the error when i got to view any post

Im on vb3 rc4 if that helps

I did have some trouble with showthread.php
what it told me to find i could`nt

==>Find:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

==>Replace With:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)

in mine i never had the announcement.userid on what i was meant to find - it simpley was`nt in my files so i just replaced what was there

[lasto]

ive put me old copy of showthread back and i can now read posts etc so obviously the problem lies in showthread so how can i edit that if what im meant to find simply aint there ??

someone must have this installed on v3 rc4 - cause it does look like a good hack as the admin part works for adding em and the awards.php page displays em fine but i just cant view me board :( cause i cant find what im meant to replace

[eXtremeTim]

I will look at this latter tonight like I said if I have time.

[lasto]

im a genuis LOL

it works fine and every one appears in postbit

all i did was this in showthread was replace every occurance of where

==>Find:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

with this

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)

u notice on the first line i did`nt add announcement - i replaced it with user (userid=user.userid) and it works fine

I aint sure what damage i may of doen to the rest of the board though by ommititing announcements out of it

[Flow Fusion]

I added what you said but i still don't get the images to load anywhere but that page I posted. What did you do to your post bit? I recall in the other one 2.0 it was something about showing the image URL

[Flow Fusion]

oh yeah did you get the images to show in the admincp?

[lasto]

lo flow

the images dont show in the admin cp just the name and then u tick what pic u want to show

as for postbit all i added was what was in the file - i had no problems there at all.

Its showthread thats the problem m8

find all occurances and swap em for the 2 lines i posted above as this is the only way mine worked and now i have no probs at all (opps touch wood i should`nt say that)

wot version are u on m8 ?

[Flow Fusion]

damn I might just start from scrach. I don't see the images at all in the post bit

[lasto]

geez it's seems when I upload the "showthread.php" everything goes to hell. I don't know which one to edit. From the

In /showthread.php
-------------------------------

==>Find:

'pollresult'

==>Replace With:

'pollresult',
'awards_bit'

==>Find:

usertextfield.*,

==>Replace With:

usertextfield.*, useraward.*,

==>Find:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

==>Replace With:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)

Their is 2 of each these. And on the LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

in my file it has
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

See how it has AS as oppose to ON?

Please help?

u dont need to start from scratch

just replace

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid) - (which is`nt even their mind you as announcement.userid aint there so search upto that bit and replace thelot )

and replace with

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=userid.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)

replace both in showthread as there is 2 occurances.


also images do appear in admin cp in awards manager - they dont appear when u bring an account up to give em to that user so hacks works fine

[Flow Fusion]

Ok I got the database error. Now what about the "'pollresult'" and "usertextfield.*,
" is do I edit the first ones or the second?

[lasto]

pollresult there is only one

do that one

for the usertextfield do both is what i did

[Flow Fusion]

Geez I did that too but the images are still now showing. do you have the <div>$awards</div> in your postbit? Or am I missing something still?

[Flow Fusion]

==>Don't forget to change " . TABLE_PREFIX . " to the table prefix that you use. If you don't use a table prefix then just delete it.

What does this mean?

[lasto]

delete it if u dont which i never

believe me if u did use a remove everything inc " "

[Flow Fusion]

OK I got it thanks alot. I went back over everything and it worked! Your last step is what did it.

[Flow Fusion]

But the images don't show in the awards showcase...geez

[Flow Fusion]

Will this conflict with the arcade hack? I ask cause I see the $awards text in that file.

[Flow Fusion]

Uh oh I see with the release of vBulletin gold this is not compatable. It needs to be modified. This is just great.

[tides]

Uh oh I see with the release of vBulletin gold this is not compatable. It needs to be modified. This is just great.

the fact is, this hack will crass vb3 gold and result database error... :(

[BarHopper]

I tried this, and with Gold its completly messes up the forum.

[dethfire]

would it be easy to add a function where you can specify a whole usergroup getting an award?

[Flow Fusion]

I'll try to convert this hack on Thurs. for all of us. It will be my first hack so wish me luck lol.

[mtha]

Uh oh I see with the release of vBulletin gold this is not compatable. It needs to be modified. This is just great.
just some small changes, you can compare the old and new file to figure it out.


I just make small changes for gold, it should work fine. (all credit goes to AnimeWebby)

work with 3.0 Gold, 3.0.0, 3.0.1

[rstark]

I'm looking for something similar to this hack. I want to be able to assign a "badge" or picture to several user groups that shows up in the postbit template. Does any know of anything out there that can do this?

[Flow Fusion]

Wow thanks I'll try this tonight. @ rstark I wish I did.

[Flow Fusion]

Well I was abit impatient so I installed the hack and I must say thank you so much. It works perfect and was very easy to install. I just suggest users do the first steps for the in the other file and than add this one after. Thanks again. It only took about 40 min to do.

[Flow Fusion]

Ok I fixed the files into one so all you need to do is download it from here. I don't want to step on anyones toes but no one is helping this thread any longer. I love this hack so much I hope it doesn't offend anyone with what I did.

If any one uses this hack please click the install button to support the author and just use the edited text file. If you can't open it please let me know I will convert it.

[lasto]

Ok I fixed the files into one so all you need to do is download it from here. I don't want to step on anyones toes but no one is helping this thread any longer. I love this hack so much I hope it doesn't offend anyone with what I did.

If any one uses this hack please click the install button to support the author and just use the edited text file. If you can't open it please let me know I will convert it.


u get this working on gold then m8 ?

[Flow Fusion]

Yeah I have the arcade and this hack working fine. On 3.0 gold currently.

[moley]

I've installed the vb3 gold version but now get this error

Warning: Invalid argument supplied for foreach() in /home/jay/public_html/forum/forums/includes/functions_showthread.php on line 721

Warning: Cannot modify header information - headers already sent by (output started at /home/jay/public_html/forum/forums/includes/functions_showthread.php:721) in /home/jay/public_html/forum/forums/includes/functions.php on line 2832

any ideas whats wrong and how to fix?

[Flow Fusion]

Did you update user profile? Cause I had that problem as well till I did that.

[moley]

o wait no i didn't I'll give it a try when I get home. Thanks for the help.

[tides]

I found an error in the hack.

In the modification member.php, the hack document fetch an nonexisting template.

You make the hack as fellowing:

==>Find:

// END CUSTOM PROFILE FIELDS
// *************************


==>Add below:

// AWARDS IN MEMBERINFO
$getawards = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "award AS award ORDER BY awardid ASC");
$show['awards'] = false;
while ($useraward = $DB_site->fetch_array($getawards))
{
$userawardid = "award$useraward[awardid]";
if (!empty($userinfo[$userawardid]))
{
$userawardid_desc = $userawardid."_desc";
if ($userinfo[$userawardid_desc] != '')
{
$useraward[description] = $userinfo[$userawardid_desc];
}
$show['awards'] = true;
eval('$awardsbit .= "' . fetch_template('awards_bit') . '";');
}
}
// END AWARDS IN MEMBERINFO

[moley]

ok i'm on the last step and a bit confussed by it all. At the end it said make a new template called awards at the start it says make one called AWARDS so when ever I say one it saves over the other .

Edit

Well I didnt do the last one and it seems to work fine now. Just gotta get busy making awards now :banana:

[Geographic2]

Some may prefer this query in awards.php

$earnawards = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "award ORDER by name");


So it order by name rather than id#, others may not. Just mentioning for those who might not have thought about it.

[InfiniteWebby]

I am extremely sorry that I haven't been able to support this hack lately, I got a new computer about a week ago and am only know gettig it setup just as it is. Thanks to FlowFusion and mtha for all your help.

I will be re-doing the instructions and work out any bugs when I get my localhost vBulletin Gold version setup so please be patient.

Once again SORRY :(

[ranger2kxlt]

Alright, tried to install with HTL, and did all the file edits, upload the last file and click step 6 of 6 and then i get There seems to have been a slight problem with the ..... database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

any idea how this could happen?
thanks

[ranger2kxlt]

found the main problem...its my funtion.php file...BUT i don't know what part of it messing up...seems as if one of the two codes is the problem, anyone had this???

[Flow Fusion]

Remove the edits to the "members.php" and leave it default should clean that up.

[BarHopper]

I tried to install this a couple of times, and failed. I did the HTL, and did the file eidts. But i got a fatal and parse errors, all over the place. So, i had to re-upload the original files. Also, it never showed up in the post bit. But, i really wnat this hack. Erm...would anyone offer to lend a hand in the file edits?

[Flow Fusion]

Post the error/s?

[BarHopper]

The errors were in all of my file edits and taht created fatal and parse errors. So i had to replace em'.

[Flow Fusion]

Aww come on you couldn't have gotten ALL the files to send an error message. Try a freash install and uplosd the files one at a time and see what it does to your forum. Than test them first. Cause I'm sure the method I posted is accurate cause I did a fresh install to test it out.

[dniMTheory]

So does this work with Gold or not?

[willie3wire]

Yea... Does this work on Gold?

[lasto]

works fine on gold

go ahead and install :)

[dniMTheory]

Does this interfere with the arcade hack? Because they both require you to add the same line of code "global $awards;" in functions_bbcodeparse.php.

I started to install it but the arcade hack is already using a variable named $awards.

[lasto]

Does this interfere with the arcade hack? Because they both require you to add the same line of code "global $awards;" in functions_bbcodeparse.php.

I started to install it but the arcade hack is already using a variable named $awards.


good thinking but i never installed this when i had the arcade i intalled this before the arcade on me test board.
So not sure if they work togehter but if both use global $awards then ones deffo gona have to be changed if thats the case

I suspect that for every file that has $awards or whatever u could just rename it to $awards1 and it would still work the same

[Flow Fusion]

Yeah they both work fine with both. I have both installed with no problems. I only worry about the store hack now. When they release it.

[dniMTheory]

AHhh, yes, thanks for the help. I got it working, arcade hack also. Someone needs to update the first post with the changes for gold if it hasnt been done already.

But was does "request award" mean or supposed to do on the awards page?

[Sean S]

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, useraward.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,

NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN useraward AS useraward ON(useraward.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,21677,21698,21811)
ORDER BY dateline

mysql error: Unknown table 'announcement' in on clause

mysql error number: 1109

does anyone know why I get that error message? yes I have done everything and read all the directions. I even went over instructions 3 times but still something gives error. I can see the forum home, but everytime i try to view each thread or something else, I get that error. Also the admin panel seems to work fine, but the rest is just messed up. :(

[dniMTheory]

Use these instructions, instead of the ones in the first post

https://vborg.vbsupport.ru/showpost.php?p=488151&postcount=134

[Flow Fusion]

ANyone have an idea why I get this error message in my email every so often?

IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
,avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline
,level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted,
post_parsed.pagetext_html, post_parsed.hasimages

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN useraward AS useraward ON(useraward.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid = 856

mysql error: Unknown table 'announcement' in on clause

mysql error number: 1109

Date: Thursday 15th of April 2004 12:11:04 PM
Script: http://giftedsouls.com/gs/showpost.php?p=856&postcount=2
Referer:

[BarHopper]

My 7th attept has failed. I really wnat this, i think i'm gonna pay for someone to install it for me. But as a last resort, i;ve attatched my mof#dified files, could someone have a look to whether i've doen anything wrong? I used HTL, but i got Parse errors and database errors all over the place.

The /nw in teh attacthment, is the backup files.

[dniMTheory]

last I checcked, the first post wasnt updated for gold...atleast it wasnt when I downloaded it.

When you get to the file and template edits use the mods from this post
https://vborg.vbsupport.ru/showpost.php?p=488151&postcount=134

[BarHopper]

Right, i'll have another go if i get time. I think my problems were in member.php, announcement.php and showpost.php. I think thats all.

[JamesFrost]

I am extremely sorry that I haven't been able to support this hack lately, I got a new computer about a week ago and am only know gettig it setup just as it is. Thanks to FlowFusion and mtha for all your help.

I will be re-doing the instructions and work out any bugs when I get my localhost vBulletin Gold version setup so please be patient.

Once again SORRY :(

AnimeWebby - Any update on the new install / instructions? Anyone running this on vb3.01?

[trinitym]

Anyone running this on vb3.01?

I'm currently upgrading/revamping [on a non-livesite location] and after two nights of caffiene and much hunting through this thread, I have this working on 3.0.1. The awards appear in the postbits and profiles where they should and I had no issues adding, editing and deleting awards, nor adding/removing them from users.

The only issues I seem to be having is it's saying it can't find some of the phrases [only through the admincp], like "deleted_award_successfully" AND when I went to go ahead and add them manually [I did this HTL style], it said the phrases already did exist.

Not too big a deal because the functionality seems to be working fine, though it does grate against my weird OCD-perfectionist-ness.

<edit>God, I'm so rude. I forgot to say: An otherwise excellent hack, this will be extremely useful to me. *clicks install*</edit>

[JamesFrost]

I'm currently upgrading/revamping [on a non-livesite location] and after two nights of caffiene and much hunting through this thread, I have this working on 3.0.1. The awards appear in the postbits and profiles where they should and I had no issues adding, editing and deleting awards, nor adding/removing them from users.

The only issues I seem to be having is it's saying it can't find some of the phrases [only through the admincp], like "deleted_award_successfully" AND when I went to go ahead and add them manually [I did this HTL style], it said the phrases already did exist.

Not too big a deal because the functionality seems to be working fine, though it does grate against my weird OCD-perfectionist-ness.

<edit>God, I'm so rude. I forgot to say: An otherwise excellent hack, this will be extremely useful to me. *clicks install*</edit>
I've followed the alternative instructions in this thread and I don't get any awards displaying under 3.01 (I had them working on 3 RC4). I can setup the awards in AdminCP and I have made the correct changes to the templates.

I have fixed broken user profiles again and tried removing and re-adding awards.

No error message, just no awards. :(

If anyone could shed any light, I'd be most grateful (I know I've not given a lot to go on here!)

[JamesFrost]

P.S. the award showcase under the user public profile shows OK.

[JamesFrost]

pps I also have the arcade installed, but it was working previously with awards!

[JamesFrost]

OK - sorted it - was missing the awards_bit template.

Don't know how, as this was working previously!

[JaNa]

*clicks install* Good hack.

[cuerty]

I've found a problem into the install of this hack:

In member.php when i'm looking at someones profile the awards of this person are not show.

I fix this by replacing 'award' to 'awards_bit' into de globaltemplates array and fetch_template('awards') with fetch_template('awards_bit') into the loop, all in member.php.

Hope this helps someone ;-)

PD: I click install great work dude :p

[Anub1s]

0k i installed this hack on a 3.0.1 i get a database error when i finish the install
so i make the back up and deleted the new queris from my db, the forum back to normal, but when i make modification to the templates i cant see the changes, so anyone have an idea what can fix this?

i installed with HTL my forum had the arcade nd vbadvance hacks

[dssart]

I'm now considering installing this onto my 3.0.1 forum. I guess it works O.K. as long as I don't have the arcade hack installed. Is everyone satisified with it? no issues?

[InfiniteWebby]

As far as I know the latest arcade hack will work with the awards hack as it seems they have changed their variables. But in other news I should be releasing a new fully working version with the latest arcade hack in the next couple of days.

[dssart]

Great work AnimeWebby! I'll hold off until your next release..

Thanks,

Art

[bitbender]

Thanks for Porting this :)

* bitbender clicks install and heads off to test site....

[WebMasterAJ]

I have encountered a problem that I don't see in this thread yet...

Anyway, I can successfully add an award to the database. However, when I go to give a user an award, it doesn't save the information. It says "User [username] saved" or whatever when you are editing their profile... but it actually doesn't do anything to that table. In addition, there are NO errors that are encountered.

If I go to the table itself (useraward) and enter data manually, it will show that a user has an award when you view their profile...

Does anyone have any ideas as to why this is happening?

Thank you for your time and energy!

Sincerely,
Andrew

[WebMasterAJ]

Also, it appears that the awards aren't appearing on the showthread page; however, they are showing in announcements and showpost... LOL.

I've done the modifications for showthread and functions_showthread over and over again... and I just don't understand. I made sure that awards_bit is added as a template as well.

If it helps, the arcade hack has been installed on my board... but I thought I read somewhere that it doesn't matter as the new Arcade version changed their variables...

Any thoughts?

Once again, thank you for your time and energy...

Sincerely,
Andrew Tatum

[WebMasterAJ]

UPDATE:

When I gave myself the award via phpMyAdmin and uploaded the files... it actually showed the award for me (FinHeavenAJ). However, for any other member that doesn't have an award... they show up as a guest.

See the attachment to see exactly what I'm talking about. Once again, the awards are showing on the announcements and showpost pages... but just don't want to cooperate when it comes down to the showthread. :disappointed:

[M.C.]

mtha, your version in post 134 works perfect for me ;) I just take some of your code some of original and it works fine now (i hope... :))

[Flow Fusion]

Ok something in this script does not work with 3.1. Soon as I add it it shows all new members as guest. Does anyone see what it is? showthread.php

// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 22 ]
$posts = $DB_site->query("
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, useraward.*,
" . iif($forum['allowicons'], 'icon.title as icontitle, icon.iconpath,') . "
" . iif($vboptions['avatarenabled'], 'avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,') . "
" . iif($vboptions['reputationenable'], 'level,') . "
" . iif(!$deljoin, 'NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,') . "
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
" . iif(!can_moderate(), $datastore['hidprofilecache']) . "
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)
" . iif($forum['allowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = post.iconid)") . "
" . iif($vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)") .
iif($vboptions['reputationenable'], " LEFT JOIN " . TABLE_PREFIX . "reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)") . "
" . iif(!$deljoin, "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')") . "
LEFT JOIN " . TABLE_PREFIX . "editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE $postids
ORDER BY dateline $postorder

[Flow Fusion]

Also, it appears that the awards aren't appearing on the showthread page; however, they are showing in announcements and showpost... LOL.

I've done the modifications for showthread and functions_showthread over and over again... and I just don't understand. I made sure that awards_bit is added as a template as well.

Sincerely,
Andrew Tatum

It's that part that is messed up that I just posted.

[WebMasterAJ]

Ok something in this script does not work with 3.1. Soon as I add it it shows all new members as guest. Does anyone see what it is? showthread.php
It seems that we're in the same boat :(

[Flow Fusion]

Ok this hack does not work in 3.1 unless you do this.

You need to use the 3.0 showthread.php, and the 3.0 includes/adminfunctions_showthread.php

It won't work on the 3.1 php files. I don't know why but that's the deal.

I have the shoutbox, who was online, awards, arcade, and store hack on my board.

And this is the only way I see getting this file to work.

[Fugler]

Hello, I tried installing this hack and it all seemed as if it was going to work. I'm using vB 3.0.0 and when i got to step 6 of the HTL i got the message saying "Theres been a slight problem with the database", does anyone know of a way to fix this? If I changed the file edits back would it get rid of the slight error, or is my forum doomed?

[Willgames]

well i think everthing is working fo me, the only problem is when i try to access the admincp/award.php it tells me that "Could not find phrase 'no_awards_defined'." and I know that I made it...am I doing somehting wrong?

[Intex]

Can someone please confirm this works with 3.0.1 or not. Thx.

[WebMasterAJ]

Can someone please confirm this works with 3.0.1 or not. Thx.As far as I know, it does not work on 3.0.1 :(

... I mean, at least it didn't for me...

[Flow Fusion]

Ok it seems like I'm the only one helping this thread.

Ok One it does work in 3.1 but you need to use the 3.0 showthread and the 3.o functions_include.php

I did not use the HTL I used the files to edit. But yes it can work in 3.1 bit DO NOT USE DREAMWEAVER TO EDIT FILES.

BUT NOW I NEED SOME HELP CAN SOMEONE TELL ME HOW TO USE THE HTL INSTALLER?

[SaN-DeeP]

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

i did not find that line in showthread.php :S
please help

also what path should be given in medals files
if i want to place medals in foll. dir
/images/icons/awards/medal1.gif

also getting this error when going to award manager without any awards
Could not find phrase 'no_awards_defined'.
i RECHECKED i have added the above phrase but still getting that error.
thats all errors i have

please help.
Thnx.
Sandy...

[Flow Fusion]

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

i did not find that line in showthread.php :S
please help

also what path should be given in medals files
if i want to place medals in foll. dir
/images/icons/awards/medal1.gif

also getting this error when going to award manager without any awards
Could not find phrase 'no_awards_defined'.
i RECHECKED i have added the above phrase but still getting that error.
thats all errors i have

please help.
Thnx.
Sandy...

YOU MUST USE THE SHOWTHREAD.PHP FROM 3.0 NOT 3.1

[mtha]

Ok this hack does not work in 3.1 unless you do this.

You need to use the 3.0 showthread.php, and the 3.0 includes/adminfunctions_showthread.php

It won't work on the 3.1 php files. I don't know why but that's the deal.

I have the shoutbox, who was online, awards, arcade, and store hack on my board.

And this is the only way I see getting this file to work.
:) well well well, I didnt have this one in used, but I did try to install it, and it seems to work on 3.0.1 (with some of my small modifications)

check out this post:
https://vborg.vbsupport.ru/showpost.php?p=488151&postcount=134

and ... I do not have 3.1 yet (i dont think its available yet even :D ), so cant tell about 3.1

I forgot what I changed, and dont have time to read it again tho.

[SaN-DeeP]

YOU MUST USE THE SHOWTHREAD.PHP FROM 3.0 NOT 3.1
i am using 3.0 not 3.0.1 :)
i managed to fix it. i did some wrong edits. :S

anywyz, thats fixed now. i have added awards in admincp and also alloted same to some users. but those aint visible now.

Sandy...

[Eagle Creek]

Uuhm; it DID work at my forum (2.2.7).
When I did a upgrade to 2.3.4 it was still working; but not anymore! Just from the one to the other day it stopped working.

When I select "enable awards for" "yes" and I save then the next time I take a look it stands again to "no".

Removing and re-adding al the awards didn't work.
Help me please.

[WebMasterAJ]

Am I the only one experiencing problems of when you edit the user, the award doesn't "save?"

Meaning, if I award someone an away through the admincp, it doesn't save to the database...

Any ideas?

[SmasherMaster]

Sweet hack!

/me hits install

[SmasherMaster]

Oh great...database error...I can't seem to find out where this is coming from.

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT
userfield.*, // [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 10 ]
usertextfield.*, useraward.*,
// [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 10 ] user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, level, avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline
FROM user AS user
INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 11 ]
INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
LEFT JOIN useraward AS useraward ON (useraward.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
WHERE user.userid = 55

mysql error: 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 '// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='Anim

mysql error number: 1064

Date: Friday 21st of May 2004 06:07:30 PM
Script: http://www.megareviews.com/forums/member.php?u=55
Referer:
Username: Unregistered
IP Address: 65.54.164.101


someone help please

[y2krazy]

I really want to get this installed, preferrably via HTL, so what would I need to edit to get it working with 3.0.1 --- without having to go in and manually do what your(mtha) attachment says to do. I suppose I'll just have to wait until it's updated to work with 3.0.1.

-y2k-

[InfiniteWebby]

I just uploaded the new installers for both versions of the Awards/Medals/Cards hack. It should work fine with the arcade installed on any installation of vB3. If you encounter any troubles then send me a PM with the info stated in the first post.

Thanks alot.

Also if you love this hack then please join my forums and post at least once, we are desperate for activity ^_^. Oh yeah and click install.

[SmasherMaster]

Oh so the arcade was giving me hell is that it? GAH! I'll reinstall.

[BarHopper]

I'm having one problem. http://www.game-realms.net/vb/showthread.php?p=17580&styleid=3#post17580 Its doing the image twice. (the award image).

Why? And how can i resolve it?

[WebMasterAJ]

I receive the following errors:

The Header:


Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724

Warning: Invalid argument supplied for foreach() in /home/user/public_html/boardvb2/includes/functions_showthread.php on line 724


This is what appears where a thread is supposed to be:


Unable to add cookies, header already sent.
File: /home/fhco/public_html/boardvb2/includes/functions_showthread.php
Line: 724


I am on version 3.0.1

As the errors say, these errors happen as soon as I edit functions_showthread.php

Any ideas for this fix?

Thank you for your time and energy!

Sincerely,
Andrew Tatum

[ethics]

Getting the following errors when trying to enter the award admin panel:

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT * FROM award AS award ORDER BY awardid ASC
mysql error: Unknown column 'awardid' in 'order clause'

mysql error number: 1054

Getting this in trying to get in to the member list:

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT * FROM award AS award ORDER BY awardid ASC
mysql error: Unknown column 'awardid' in 'order clause'

mysql error number: 1054
=========

Not sure if the table creation was ok but didn't see any errors and see the tables as ok in the db admin.

[SmasherMaster]

getting this error wehn i try to view a thread:

Warning: Invalid argument supplied for foreach() in /home/smasher1/public_html/forums/includes/functions_showthread.php on line 799

and in my thread, all posts say n/a

help?

[WebMasterAJ]

I can't wait for this hack to work on my boards... ALL of my members miss it!

BTW... SmasherMaster: It looks like we're having similar problems... are you able to view the awards in a member's profile?

[SmasherMaster]

I haven't added any awards yet, but I don't see any places that say "awards" in the member's profile.

[InfiniteWebby]

@Barhopper: Did you have this hack installed previously if so you may have the same piece of code twice in your /includes/functions_showthread.php if not check that you dont have $post['userawards'] in your postbit_legacy twice. If you want send me your /includes/functions_showthread.php and your postbit_legacy via a pm and I'll see what I can do.

@WebMasterAJ: Check your pm ;)

@ethics: I need to see some sort of mysql dump of your awards table but I have no idea what could be wrong with it, what installer did you use? and what vb version did you use?

@SmasherMaster: You are having the same problems as WebmasterAJ I will forward the pm i sent him to you.

[ethics]

@ethics: I need to see some sort of mysql dump of your awards table but
I have no idea what could be wrong with it, what installer did you use?
and what vb version did you use?

Vb 3.0.1 and used the manual installer (not HTL).

[tHe Rk]

getting this error wehn i try to view a thread:

Warning: Invalid argument supplied for foreach() in /home/smasher1/public_html/forums/includes/functions_showthread.php on line 799

and in my thread, all posts say n/a

help?
I got the same thing! HELP HELP HELP!

As follows:

Warning: Invalid argument supplied for foreach() in /home/therk/public_html/forum/includes/functions_showthread.php on line 731

[InfiniteWebby]

<span class="highlight">Sorry about this guys but isn't it always the small things that ++++ up a script? Anyway I updated the first post with instructions on how to fix the foreach() errors as well as instructions which alot of you missed on how to fix the N/A post count.</span>

[tHe Rk]

Sorry about this guys but isn't it always the small things that ++++ up a script? Anyway I updated the first post with instructions on how to fix the foreach() errors as well as instructions which alot of you missed on how to fix the N/A post count.

Thanks Anime! Will go check out the first post for the fix!

[tHe Rk]

Awards/ Medals/ Cards Hack [vB3]
If you installed this hack before 23rd May and are getting foreach errors in your showthread then follow the step below:

In /includes/functions_showthread.php find:
// sorts through all the stuff to return the postbit template
below that add:
// user awards
global $userawards;


Worked like a charm! Thanks a million!

[SmasherMaster]

Wonderful, that worked. Thanks alot, animewebby!

[tHe Rk]

I had to reinstall my forums, and I have mutliple other hacks already in use and I get this error when I try to use the installer: (This is before I get to any template edits or anything like that, and ideas?)

Database error in vBulletin 3.0.1:

Invalid SQL:
SELECT user.userid
FROM user AS user
LEFT JOIN useraward AS useraward USING(userid)
WHERE useraward.userid IS NULL

mysql error: Table 'therk_xgplanet.useraward' doesn't exist

mysql error number: 1146

Date: Thursday 27th of May 2004 05:21:00 PM

[Mystictrunks03]

i got that same error like this

Database error in vBulletin 3.0.1:

Invalid SQL:
SELECT user.userid
FROM user AS user
LEFT JOIN useraward AS useraward USING(userid)
WHERE useraward.userid IS NULL

mysql error: Table 'dbgtx2_vbulletin.useraward' doesn't exist

mysql error number: 1146

Date: Thursday 27th of May 2004 06:54:33 PM
Script: http://www.dbgtx2.com/vb/admincp/awards_install.php?step=doqueries
Referer:

[InfiniteWebby]

those imply that you already have the file edits installed, ill look into it in a min and get back to you.

[InfiniteWebby]

Sorry after reading your erros properly i realised it was a problem on my behalf, the installer wasnt freindly for forums that didnt use the vb3_ prefix, its fixed now so you can go download and install again.

[Mystictrunks03]

cool thanks webby and one other thing wud the arcade champion thing be in the awards box too like ur forum or u gotta customize that?

edit: holdup i still get the same thing

[tHe Rk]

I just wanted to drop a line to Anime for being a big help with support and very quick bug fixes for this hack! There a lot of hacks around here that would be great but don't get support and therefore don't always work properly like they should. I just wanted to say a lot of us appreciate the kind of support you showed in this thread. Also have to give you props on the longest damn hack ever made!:p Just kidding, it is damn long though;) But worth it, IMO. Thanks again, and look forward to future hacks from you!

[InfiniteWebby]

Thanks Rk and sorry it did take so long to sort everything out, but unlike alot of hackers on vB.org this is second to actual web design and programming therefore alot of my time is spent on my own projects. However this hack is not finished yet, I'm sure I will think of many more ways to make it better as well as finish my to-do list already planned.

@Mystic: I told you what was wrong, contact me on aim if you are still having problems.

[Mystictrunks03]

still the same problems and i never get to catch u on aim webby maybe u shud test run it b4 u release a fixed one for non prefix users, sorry if this is giving u a hard time webby

[Intex]

Great hack AnimeWebby - installed with no problems on 3.0.1.

Just one thing though - on the awards page, there is a 'Request Award' on the options column. Is this supposed to be a link? Mine just has the text there.

[InfiniteWebby]

Intex, no it is not a current feature but expect it to be implemented soon.

@ MysticTrunks: I did test it after I fixed the prefix thing and I can guarentee the installer works (at least for me) with both prefixes and no prefix options.

[cuerty]

Simple doubt.

Why are all my users into the userawards table, even those without a award?

[InfiniteWebby]

cuerty, are you talking about the database useraward table or the awards.php user's award table? if it is the database one then they need to be there otherwise when a users profile is taken from the database it is incomplete and it would result in the n/a post counts, guest user title's etc...

[cuerty]

Thanks, I was talking about database. If for migrate the old awards of my vb2 forum :)

[Roxie]

I use 3.0.1
Everything is perfect except the award doesn't show in the postbit. Suggestions?

[Intex]

Make sure you have this bit of code in your postbit or postbit_legacy template (depending upon which one you use). If you're not sure put it in both:


$post[userawards]


Also make sure that you have awards.php in your forum root (/forum/awards.php) and award.php in your admincp (/forum/admincp/award.php).


I use 3.0.1
Everything is perfect except the award doesn't show in the postbit. Suggestions?

[Roxie]

Yes, it's there. Still nothing. :(

[Roxie]

Okay, if I change it to $post[awards] they show...but after the awards are a bunch of red x's ...like missing images...

For example, the person has one award (or even no awards) and the award they have is followed by 15 broken image boxes??

[InfiniteWebby]

Roxie, PM me your showthread_functions.php file as well as what installer you use, what vb version and the url to your forums.

[Roxie]

I sent a pm but couldn't send the file...it was too large.

[Roxie]

Does anyone have the text so that I can edit my php files manually?

[mtha]

Awards/ Medals/ Cards Hack [vB3]
By: AnimeWebby
Idea by: Lesane
Updated: 28nd May 2004 - Installer not table prefix friendly.
Webby,

What is the update? is there any new features/bug fix ...? Did you make any changes to the code, or just make changes to installer? Do we need to "upgrade"? (if yes, then how) :D

[InfiniteWebby]

It was just a change in the installer. If you used vb3_ as your table prefixes and your forums seem to be having troubles then no need to do anything. Otherwise just make sure your useraward and awards table in your forums db has the appropriate prefix.

[tHe Rk]

Anime,

I have rather "wide" awards that I use in the postbit and they show up brilliantly there, as designed, but in a users profile is lists them horizontally and not vertically, and as I said before, my awards are quite wide, how can I make them show up vertically. I just don't want the forum width to be stretched. Here is the example:

http://www.xgplanet.com/forums/member.php?u=9

[InfiniteWebby]

just add a <br /> to the end of the awards_bit template

[tHe Rk]

just add a <br /> to the end of the awards_bit template

Awesome Thanks again:)

By far one of the best "Supported" hacks on vB.org :thumbsup:

[lordnex]

I have an odd error, everything displays properly (as far as I can tell) but I can't award anyone an award. When I go into a users profile the "User Awards" menu is there and I can select "yes" to them having the award but when I save the profile it reverts back to them not having the award. How do I make that stick?

[InfiniteWebby]

I have an odd error, everything displays properly (as far as I can tell) but I can't award anyone an award. When I go into a users profile the "User Awards" menu is there and I can select "yes" to them having the award but when I save the profile it reverts back to them not having the award. How do I make that stick?

I would appreciate it if you told me what installer you use, but check if you have amde all edits to the /admincp/user.php.

[Eagle Creek]

I have a 3.0.1 board. Which have do I have to download/ what do I have to do when I want to know for sure it works?

Is is compatible with that version already?

[Stud_Muffin]

I have a 3.0.1 board. Which have do I have to download/ what do I have to do when I want to know for sure it works?

Is is compatible with that version already?
Worked fine for me, just need some graphics now https://vborg.vbsupport.ru/external/2009/12/14.gif

[Eagle Creek]

HOOAH!

I'll try it out, thx

I have red and yellow card if you like.

[WoodiE]

I'd like the text "Earned Awards" or "Award Showcase" to be diplayed above earned awards in the users postbit. I edited the awards_bit to add the text but when the user has two awards it is shown as:

Earned Awards:
[IMAGE OF AWARD]

Earned Awards:
[IMAGE OF 2ND AWARD]

How can I make it so it only shows Earned awards once then all of the users earned awards?

-Michael

[miker_316]

WoodiE, try putting the "Earned Awards:" text in the postbit template.

Find...
<div>$post[userawards]</div>

Edit it to...
<if condition="$post['userawards']">Earned Awards:<br /><div>$post[userawards]</div></if>

[WoodiE]

That would work, but it also displays "Earned Awards:" in the postbit even if the member doesn't have any awards. I only want it shown in the postbit if they do have an award.

-Michael