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

Cocomiel 09-20-2001 04:49 PM

I've looked into the installation.txt of that hack and since it only applies to avatars uploaded by the admin should work with my hack without problems.

DarkReaper 09-20-2001 06:23 PM

Installation took about 20 minutes(I forgot to download the files from the server, so I was using old versions - different comp:)) and it worked perfectly.

Thanks! :)

Nupraptor 09-21-2001 09:34 PM

Would other hacks interfere with this one? I want to know before I install it.

Cocomiel 09-21-2001 09:43 PM

As long as i know it will no interfere with any other hacks.

Nupraptor 09-21-2001 09:48 PM

Ok. :) Just asking because I saw this statement:
Quote:

I recommend you start from the original VB version ( unhacked ), and follow the instructions carefully.
Also, is the step involving the "chmod" vital? Because I can't do that for the time being.

Cocomiel 09-21-2001 10:00 PM

Well, i made that recommendation because normally when you can't install a hack is because the lines you must find in the code are changed or do not exist product of a previous installed hack.

Was just a recomendation, and applies to any hack, not specially this.

The chmod step is necessary if you want to create a new folder to store the custom avatars, if you already have one you want to use dont need to do so. Just type the path in the installation and it will work

Note: The path should not include previous or final backslashes

for example if you want to use the '/images/avatars/' folder
you should type images/avatars in the path

Hope that helps. :)

Nupraptor 09-21-2001 10:11 PM

Perfect, thanks. :)

Neo 09-25-2001 06:57 PM

i get this error ehat should i do?

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
Date: Tuesday 25th of September 2001 01:54:18 PM
Script: /admin/install_fileavatar.php?action=Install&path=custom_ avatars+
Referer: http://ww..com/admin/install_fileava...ustom_avatars+

kchii 09-29-2001 01:46 PM

Quote:

Originally posted by cocomiel
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.

Ok, I deleted the 2 tables, Optioncode and Displayoder as above. I also made sure Avatarrevision was deleted. The install script recreates Avatarrevision, but gives this error:


Database error in vBulletin Control Panel: Invalid SQL: INSERT INTO setting
(settingid, settinggroupid, title, varname, value, description, optioncode, displayorder)
VALUES
('', '26', 'Store Custom Avatars as Files?', 'usefileavatar', '0', 'Would you like to store your avatars in the database, or as static files in a directory?', 'yesno', '9')
mysql error: Unknown column 'optioncode' in 'field list'
mysql error number: 1054
Date: Saturday 29th of September 2001 08:43:10 AM
Script: /admin/install_fileavatar.php?action=Install&path=images% 2Fcustom&s=
Referer: http://www.animegathering.com/admin/...mages%2Fcustom


Can someone help? I have the Avatars as Categories hack installed.

maverick1236 09-29-2001 06:41 PM

It works perfect-thanks!!

could you possibly help me with the photo upload hack?

that hack WILL NOT let me upload anything-yet your hack DOES!!!

i would REALLY appreciate it...

Again-tx 4 a great hack

Justice 10-10-2001 12:56 PM

cocomiel, since this system is file-based, is there any way to allow members to use hot linked images for custom avatars? This would be a great feature, giving members more freedom and saving the host bandwidith.

So far, the only way I can think of using this would be to add an extra profile field for avatars, and add the image url in postbits. But that would require me to turn off the other avatars all together, losing all of the features and options that come with the system. :(

Any ideas?

SweClockers.com 10-12-2001 10:38 AM

I have installed the hack, but i have some trouble with it. The installationscript worked great etc, and users avatars are showing. But, when I want to change my avatar in 'my profile' or add one i just recieve a blank page :\. I tried to upload the 2.0.3 orginal files on to the server but still the same thing happens.

The forum is at http://www.sweclockers.com/forum

Could you please help me?


Edit: I found the error, It was not because of this hack. My members.php had been modified ealier and when upgrading to v2.0.3 it stopped working.

Cocomiel 10-12-2001 12:38 PM

[QUOTE]Originally posted by Justice
cocomiel, since this system is file-based, is there any way to allow members to use hot linked images for custom avatars? This would be a great feature, giving members more freedom and saving the host bandwidith.

So far, the only way I can think of using this would be to add an extra profile field for avatars, and add the image url in postbits. But that would require me to turn off the other avatars all together, losing all of the features and options that come with the system. :(

Any ideas?

Justice 10-12-2001 02:58 PM

thanks

dost 10-28-2001 04:06 PM

Does it check for the maximum dimensions of the avatar when using this hack? Because I installed it and set the max. dimensions to be 65 and someone used an image with 173x200 but it was smaller than the max. file size.

Thanks

dost 10-29-2001 07:19 AM

I tried it on my computer and it works. So the problem is with my host. I also can't change others' avatars via the Admin CP in my host. It says changed but it doesn't. It's an unix machine with apache and plesk software installed. What can cause this problem? Bad permissions or what?

Any help will be greatly appreciated.

Thanks

Justice 10-30-2001 04:10 AM

I got the same error as grumpy, and followed your directions here...

Quote:

Originally posted by cocomiel
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
Now the options in my CP don't load, and I get this error:

Database error in vBulletin Control Panel: Invalid SQL: SELECT settingid,title,varname,value,description,optionco de,displayorder FROM setting WHERE settinggroupid=1 ORDER BY displayorder
mysql error: Unknown column 'optioncode' in 'field list'
mysql error number: 1054

I've been to some threads on my board, and the hack actually seems to work. But I just can't seem to log into my CP. I think I need to add two fields or rows back into my Settings table. I should have backed up, I know... but my forum isn't live yet, so I'm just testing.

Cocomiel 11-03-2001 02:49 PM

Thats because you deleted the wrong fields

Cocomiel 11-03-2001 02:51 PM

I will release Custom Avatars As Files for 2.2.0 in a moment, DONT download Kier's hack because it will not work, its for 2.0.0

Frank-kun 11-08-2001 04:29 AM

Hey, good to see VB.org back and running...

I was looking for the attachment for this great hack that I'm currently using, but it appears to have been edited out. Does Cocomiel or anyone have the hack file or at least offer up some insight on why it was taken down? ^_^

CrazyJohn 11-12-2001 07:58 PM

I, too, need this hack, but can't find the attachment...help!

DarkReaper 11-12-2001 09:01 PM

Attachment go bye bye :confused:

MikeWarner 11-15-2001 04:21 PM

ditto:(

ladyfyre 12-01-2001 04:39 PM

I would also be VERY interested in downloading this hack if it can be made available again.

Also, I would like to know if it is compatible with 2.2.1??

atrl 12-01-2001 07:07 PM

YES PLEASE DO THIS :D
Everyone will be happy!!!!

MikeWarner 12-02-2001 05:40 PM

Am I the only one having problems with this download?

atrl 12-02-2001 06:06 PM

It downloaded fine for me :D

bira 12-02-2001 06:12 PM

What is the difference to Kier's excellet Custom Avatars as Files hack? :confused:

atrl 12-02-2001 06:27 PM

../member.php not modified ( chmod 777 this file and try again ).
Warning: fopen("../private.php","w") - Permission denied in *MYPATH*/admin/install_fileavatar.php on line 15

I chmod the file to 777 and hit reload and it doesnt work what should i do?

ladyfyre 12-02-2001 07:33 PM

nope...i am too. downloaded the file, but got gibberish instead :(


All times are GMT. The time now is 03:51 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.01414 seconds
  • Memory Usage 1,820KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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