vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Custom Avatars as Files (https://vborg.vbsupport.ru/showthread.php?t=28337)

Cocomiel 09-17-2001 10:00 PM

Custom Avatars As Files Hack for VB 2.2.1
BASED ON THE KIER'S HACK

Description: This hack lets you store custom avatars in a separate folder rather than in the VBulletin database, saving space & querys in your MySQL database

Here are some of the features:
  • Allows to switch between file mode & database mode on the fly
  • You can specify the custom avatar folder
  • No SQL queries or PHP code required to display custom avatars
  • If you use the Apache Web Server, the avatars folder can be protected by .htaccess thus preventing bandwidth stealing
  • No cacheing issues with Internet Explorer 5.5
  • All avatar options that are present when using the standard mySQL avatar system are still present, and users will not notice a difference in the interface.

Intructions:
Upload install_fileavatar.php to your ADMIN directory and open it in your browser, then follow the screen instructions.

TheFox 09-18-2001 10:24 PM

EXCELLENT HACK !!! :D :D :D

WORKS GREAT!

THANKS MAN :cool:

grumpy 09-19-2001 09:59 AM

There seems to have been a slight problem with the database, etc etc

I backed it up first and then started from scratch, still got the same error.

I admit I don't know anything about php, but I'm curious about the coding in the instructions. For example, you say to find:
PHP Code:

if ($post[hascustomavatar] and $avatarenabled) {
        
$avatarurl="avatar.php?userid=$post[userid]&dateline=$post[avatardateline]"

and replace with:

PHP Code:

if ($post[hascustomavatar] and $avatarenabled) {
        if (
$usefileavatar$avatarurl=$fileavatarfolder "/avatar$post[userid]_$post[avatarrevision].gif";
        else 
$avatarurl="avatar.php?userid=$post[userid]"


As I say, I don't know PHP, but every instance I've seen of else is enclosed as } else {, but not in your script. Could this cause the error?

thanks :)

grumpy 09-19-2001 10:15 AM

Ah, received my tech error email, it shows:

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE user ADD
avatarrevision INT (6) UNSIGNED DEFAULT '0' not null AFTER avatarid
mysql error: Duplicate column name 'avatarrevision'
mysql error number: 1060

:confused:

TheFox 09-19-2001 03:23 PM

Grumpy:

if - else statements are not necessary enclosed by '}{'

I recommend you start from the original VB version ( unhacked ), and follow the instructions carefully.

Cocomiel 09-19-2001 03:30 PM

The second error you get is because you have the hack already installed, i will add code handle this in the next release.

If someone else is getting that error please tell.
Thanks, Cocomiel

grumpy 09-19-2001 04:28 PM

Not sure if this will help, but the error I posted from the tech email was from the first attempt.


thanks for your help :)

Cocomiel 09-19-2001 04:40 PM

Ok, that explains everything.

The error appears because you already have an avatarrevision field in your database, that is because you already instaled another hack that added that field.

if you have phpMyAdmin instaled, select to your database
and in the USER table delete the 'avatarrevision' field

then go to the SETTINGS table and delete the last two fields

But, as previously was mentioned I suggest you to begin installing the hack with a clean VB.

xtrim 09-20-2001 12:48 PM

Hi,

Great work on this hack cocomiel.

I have not get into this or installed yet, but I was wandering if this hack could be made compatible or is already compatible with the avatar categories hack posted.

I dunno if its got anything to do with the code involved but I would like to know if both hacks could be installed to work together.

Thank you.

Cocomiel 09-20-2001 03:29 PM

Xtrim, I dont know anything about that hack, but i will try to make it compatible in the next release


All times are GMT. The time now is 01:42 AM.

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.01099 seconds
  • Memory Usage 1,736KB
  • 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
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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