vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   [HTL] & [TXT] Awards/Medals/Cards Hack [vB3] (https://vborg.vbsupport.ru/showthread.php?t=61108)

Blam Forumz 08-20-2004 01:31 PM

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

y2krazy 08-29-2004 01:03 PM

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!

InfiniteWebby 08-29-2004 10:59 PM

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.

Davez 08-30-2004 01:29 AM

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

GlitterKill 08-30-2004 04:43 PM

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.

GlitterKill 08-30-2004 05:19 PM

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

Any ideas? I did the regular install.

GlitterKill 08-30-2004 06:01 PM

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 ]

Davez 08-30-2004 07:05 PM

I removed my one too ... replacing the files with my old ones ..

dethfire 08-30-2004 09:07 PM

has anyone gotten this to install on 3.0.3, otherwise I will stay away

GlitterKill 08-30-2004 11:21 PM

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.


All times are GMT. The time now is 05:05 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01652 seconds
  • Memory Usage 1,763KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete