Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
[HTL] & [TXT] Awards/Medals/Cards Hack [vB3] Details »»
[HTL] & [TXT] Awards/Medals/Cards Hack [vB3]
Version: 1.00, by InfiniteWebby InfiniteWebby is offline
Developer Last Online: Aug 2007 Show Printable Version Email this Page

Version: 3.0.0 Rating:
Released: 02-02-2004 Last Update: 06-02-2004 Installs: 160
 
No support by the author.

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #292  
Old 08-20-2004, 01:31 PM
Blam Forumz Blam Forumz is offline
 
Join Date: Jun 2004
Posts: 554
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Second time this has screwed up my database and ive had to restore it to 2 days before i installed it

I never want to see it again
Reply With Quote
  #293  
Old 08-29-2004, 01:03 PM
y2krazy y2krazy is offline
 
Join Date: Jun 2003
Location: Houston, Texas
Posts: 318
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Installed and working well, but I just was wondering if an update was being worked on at this time...? Thanks for the great hack!

/me clicks install!
Reply With Quote
  #294  
Old 08-29-2004, 10:59 PM
InfiniteWebby InfiniteWebby is offline
 
Join Date: Nov 2001
Location: Downunda.
Posts: 149
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Not at the moment, I am busy with work, trying to get my boards back up and running and a whole list of other things that take priority to this hack.
Reply With Quote
  #295  
Old 08-30-2004, 01:29 AM
Davez's Avatar
Davez Davez is offline
 
Join Date: Nov 2001
Location: Italy
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have a big problem , i uninstalled the hack right now , and now i can?t enter on board or on admincp.
I got the folling database error :

PHP Code:
Database error in vBulletin 3.0.1:

Invalid SQL
        
SELECT 
        userfield
.*, useraward.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
        IF(
displaygroupid=0user.usergroupiddisplaygroupid) AS displaygroupid,
            
language.phrasegroup_holiday AS phrasegroup_holiday,
            
language.phrasegroup_global AS phrasegroup_global,
            
language.options AS lang_options,
            
language.languagecode AS lang_code,
            
language.charset AS lang_charset,
            
language.locale AS lang_locale,
            
language.imagesoverride AS lang_imagesoverride,
            
language.dateoverride AS lang_dateoverride,
            
language.timeoverride AS lang_timeoverride,
            
language.registereddateoverride AS lang_registereddateoverride,
            
language.calformat1override AS lang_calformat1override,
            
language.calformat2override AS lang_calformat2override,
            
language.logdateoverride AS lang_logdateoverride,
            
language.decimalsep AS lang_decimalsep,
            
language.thousandsep AS lang_thousandsep
        FROM user 
AS user
        INNER JOIN userfield 
AS userfield ON (user.userid userfield.userid)
        
INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid user.userid)
        
LEFT JOIN useraward AS useraward ON (useraward.userid user.useridINNER JOIN language AS language ON (language.languageid = IF(user.languageid 01user.languageid)) 
        
WHERE user.userid 1
    
mysql error
Table 'dffcars_vBulletin.useraward' doesn't exist

mysql error number: 1146 
What can i do , can please someone help me ?

Many thanks
Reply With Quote
  #296  
Old 08-30-2004, 04:43 PM
GlitterKill GlitterKill is offline
 
Join Date: Jul 2002
Location: Nashville
Posts: 139
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

BIG problem here... I jsut followed all of the instructions to the T and I am getting this sql error when trying to view any thread.

Database error in vBulletin 3.0.3:

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 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(post.postid = deletionlog.primaryid AND 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 ()

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 ')' at line 23

mysql error number: 1064

It was my mistake. This is fixed now. Now I have to fix this dang "foreach" error.
Reply With Quote
  #297  
Old 08-30-2004, 05:19 PM
GlitterKill GlitterKill is offline
 
Join Date: Jul 2002
Location: Nashville
Posts: 139
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I made the changes that are supposed to fix the foreach errors but I still have them.

Any ideas? I did the regular install.
Reply With Quote
  #298  
Old 08-30-2004, 06:01 PM
GlitterKill GlitterKill is offline
 
Join Date: Jul 2002
Location: Nashville
Posts: 139
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, I tracked the problem down to this. I removed this chunk of code and now my forums actually work but not the awards... There is somthign in this code that is not workign well:

// ###### [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 12 ]
// AWARDS IN POSTBIT
foreach($userawards 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[\'userawards\'] .= "' . fetch_template('awards_bit') . '";');
}
}
// END AWARDS IN POSTBIT
// ###### [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 12 ]
Reply With Quote
  #299  
Old 08-30-2004, 07:05 PM
Davez's Avatar
Davez Davez is offline
 
Join Date: Nov 2001
Location: Italy
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I removed my one too ... replacing the files with my old ones ..
Reply With Quote
  #300  
Old 08-30-2004, 09:07 PM
dethfire dethfire is offline
 
Join Date: Feb 2003
Posts: 441
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

has anyone gotten this to install on 3.0.3, otherwise I will stay away
Reply With Quote
  #301  
Old 08-30-2004, 11:21 PM
GlitterKill GlitterKill is offline
 
Join Date: Jul 2002
Location: Nashville
Posts: 139
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by dethfire
has anyone gotten this to install on 3.0.3, otherwise I will stay away
I think some people have by lookign at other posts. I am running 3.0.3 and it won't work so far. I am waiting to hear from AnimeWebby.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05223 seconds
  • Memory Usage 2,338KB
  • 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
  • (1)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
  • (2)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