The Arcive of Official vBulletin Modifications Site.

[HTL] & [TXT] Awards/Medals/Cards Hack [vB3] · **Released**: 02-02-2004

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:

PHP Code:


			
    // sorts through all the stuff to return the postbit template

below that add:

PHP Code:


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

mtha · #**432** 03-25-2005, 04:03 PM

Quote:

What is your hack based on ? Will it work / display in the samefashionthat the Phpbb version does or is it more along the lines ofthisversion?

neither or both

I will have the database somewhat the same with phpbb one (on the idea), and the code is partly based on this version.

I write the code based on both this hack and phpBBhack.The displaythingie is not very important though. The featureswill be some howdifferent, which I like better.

Rightnow, I come to the point where you can give awardtosomeone,andtakeit away from, in control panel. Havent come tothe part of displaying inthe public profiles, so I dont know how I will arrange the awards inprofile and awards list yet

I didnt add the "Award Category" either. doyouthinkit'sgood/importantto add that too? Well I may need to createanewthreadfor the matter,otherwise, I would hijack this thread

Quote:

Originally Posted by Arial

Ditto dssart, I'm happy to contribute ifits'whatweareafter, personally I feel the phpbb version displaysthemedalsetcin afar more appealing fashion, so that's what we are after.

If Mtha is going down that route, I will happilydonate/contributetoyour time, if not I will carry on with my guy andpayhimto dotheentire thing for us as a personal project.

Thanks, but that's up to you to decide. I'm writing the hack formyself,and make it availabe for everyone. donations are alwayswelcome. releasetime is not set yet. features depends on ...

Quote:

mtha: keep going man! but whatever you do,pleasemakeinstallation aseasy as uninstallation. Ideally two or threeclicks.Nomorehand-editing of code. That's stone-age. I'll bet 75%oftheproblemmessages pertaining to this hack are errors ininsertingthecode. Ifthat isn't possible, then at a maximum 2 or 3 fileswhichneedto behand-edited. Also, a hack which is "versionchangeresistant"would begreat (although probably not realistic from acodingpoint ofview)when VBulletin goes on their update binges everyfewmonths. Ican'tspeak for Arial, or anyone else who may be interestedinthishack, butif it works and installation is a breeze, I'd be happytosendyou afew bucks when you've got a working app.

Well, I myself actually like doing things manually better.Comingtoany"installer", I have to read the install code, inordertounderstandwhat it is doing. its somewhat harder, but youknowexactlywhat you aredoing (if you understand the code).
Also, all the installation currently availabe only dothedatabasepart(insert template/phrases), none of them have permissiontoeditfile.
If you want to "edit" files "automatically, I will show you how to do it, using a different tool, which is great.

But that's gonna be later on the road. It's good when having people supporting the idea. Thanks

===========
The new development for my YET ANOTHER AWARD SYSTEM start HERE:
https://vborg.vbsupport.ru/showthread.php?t=78763

=================================================

ChrisBaktis · #**433** 03-26-2005, 01:17 AM

Im using 3.0.07 and during the install I received this error - I used the Standard .zip file.

PHP Code:


			
Database error in vBulletin 3.0.7:



Invalid SQL: CREATE TABLE 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 error: You have an error in your SQL syntax near ';

        ' at line 7



mysql error number: 1064

ClockCrew · #**434** 03-26-2005, 09:45 PM

I have uploaded all the files...and when I do so, I go to Install this...and when I click Install....I get this...

Database error in vBulletin 3.0.6:

Invalid SQL: INSERT INTO phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '0', 'add_new_award', 'Add New Award', '1')
mysql error: Duplicate entry 'add_new_award-0-1' for key 2

mysql error number: 1062

How do I fix this?

Eagle Creek · #**435** 03-26-2005, 09:50 PM

Quote:

Originally Posted by ClockCrew

I have uploaded all the files...and when I do so, I go to Install this...and when I click Install....I get this...

Database error in vBulletin 3.0.6:

Invalid SQL: INSERT INTO phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '0', 'add_new_award', 'Add New Award', '1')
mysql error: Duplicate entry 'add_new_award-0-1' for key 2

mysql error number: 1062

How do I fix this?

I s i t f u l l 3.0.7 c o m p a t i b l e ?

mtha · #**436** 03-26-2005, 10:10 PM

Quote:

Originally Posted by Eagle Creek

I s i t f u l l 3.0.7 c o m p a t i b l e ?

yes it is, if you can install it properly.

Eagle Creek · #**437** 03-26-2005, 10:14 PM

Quote:

Originally Posted by mtha

yes it is, if you can install it properly.

Thx... Because I have two 2.0.3 boards running and I want to upgrade but don't want to lose this hack.

And I see many problems in this thread.

ClockCrew · #**438** 03-27-2005, 12:28 AM

Quote:

Originally Posted by Eagle Creek

I s i t f u l l 3.0.7 c o m p a t i b l e ?

yes, im not that dumb.

Eagle Creek · #**439** 03-27-2005, 12:38 PM

Quote:

Originally Posted by ClockCrew

yes, im not that dumb.

What the * ??? I dont 'attack' you? I just want to know it for my own board!

mtha · #**440** 03-27-2005, 09:31 PM

peace out people. just a small missunderstand eachother

A new awards system coming up for you guys to fight

Eagle Creek · #**441** 03-27-2005, 10:50 PM

Quote:

Originally Posted by mtha

peace out people. just a small missunderstand eachother

A new awards system coming up for you guys to fight

T t t t haaaaank you!

Will you announce the new options also?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08819 seconds Memory Usage 2,333KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_php (9)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!