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

someone help please

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-

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.

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

I'm having one problem. http://www.game-realms.net/vb/showth...id=3#post17580 Its doing the image twice. (the award image).

Why? And how can i resolve it?

I receive the following errors:

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

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

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.

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

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

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

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

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

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

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

Worked like a charm! Thanks a million!

Wonderful, that worked. Thanks alot, animewebby!

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

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/awa...step=doqueries
Referer:

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

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.

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

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!

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.

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

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.

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.

Simple doubt.

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

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

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

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

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:

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

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

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

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

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

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

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

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.

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