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)

SmasherMaster 05-21-2004 09:20 PM

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

Code:

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 05-21-2004 10:23 PM

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 05-22-2004 09:58 AM

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 05-22-2004 11:23 AM

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

BarHopper 05-22-2004 03:08 PM

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?

WebMasterAJ 05-22-2004 04:28 PM

I receive the following errors:

The Header:
HTML Code:


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:

HTML Code:

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 05-22-2004 06:26 PM

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 05-22-2004 07:29 PM

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 05-22-2004 08:02 PM

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 05-22-2004 08:26 PM

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


All times are GMT. The time now is 10:18 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.02376 seconds
  • Memory Usage 1,746KB
  • 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_code_printable
  • (2)bbcode_html_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