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)
-   -   Avatar Hack: Categories & Usergroups (https://vborg.vbsupport.ru/showthread.php?t=24997)

Wifey 03-28-2004 09:10 PM

I have installed this on my message board and it's working beautifully for the most part. Problem is - everytime I try to go to a different category, I can't see past the first page of those avatars. I go to 01 Moderators and click on page 2 and it automatically takes me back to the 2nd page of the first category that I can see - 00 Admin Emma. I'm running 2.3.4 - it works GREAT for the most part so I'm sure it's compatible, but has anyone with 2.3.4 hacked this in, encountered the problem, and fixed it? If so PLEASE help!

edit: I CAN see the avatars in each admin category, but for the regular member avatars they're all in one big group, just like others.

Edison Chen 04-14-2004 10:07 AM

I have tried to install this hack and being a newbie, I think I will tend to make some mistakes. Can someone help me figure out this problem? I've attached it as a screenshot. Apparently, the avatars are not showing up.

ETA: It's fixed. For those whose avatars are not showing up in the UserCP, go ahead and check out page 27 and you will get it.

MarkL 05-12-2004 01:14 AM

I did all the steps on page 27 and I'm still getting the problem where all the avatars show up, even in different categories. Can someone please help? I'm using 2.3.5. Thanks :)

The Charmed One 06-23-2004 08:06 PM

I am on 2.3.4 and i get this error

Database error in vBulletin 2.3.4:

Invalid query id specified
mysql error:

mysql error number: 0


The files all look correct and seems okay. What could this problem be from?

Lexina 07-01-2004 11:05 PM

Quote:

Originally Posted by Bad_Madman
You were faster. :D

When I go into member.php and we are told to search for:

PHP Code:

$pagenav getpagenav($totalavatars,"member.php?s=$session[sessionhash]&action=editavatar&perpage=$perpage"); 

I can't find it anywhere... I am using 2.3.5 version... so anyideas? I tried going on without it but the categories didnt show up in the userCP when I skipped that part.. Help?

ZiRu$ 07-29-2004 06:37 PM

Quote:

Originally Posted by Lexina
When I go into member.php and we are told to search for:

PHP Code:

$pagenav getpagenav($totalavatars,"member.php?s=$session[sessionhash]&action=editavatar&perpage=$perpage"); 

I can't find it anywhere... I am using 2.3.5 version... so anyideas? I tried going on without it but the categories didnt show up in the userCP when I skipped that part.. Help?

its on 2 lines thats why you can't find it.....

just search for
PHP Code:

$pagenav 


ZiRu$ 07-29-2004 06:38 PM

I'm using 2.3.5 and the hack works perfectly - but i had to install this fix for it to work good

https://vborg.vbsupport.ru/showpost....&postcount=394

CFF Staff 09-30-2004 06:08 PM

I'm running 2.3.5, any idea how I can get this to work for my version... Thanks.

CFF Staff 10-10-2004 04:03 AM

Alright. Version vbulletin 2.3.5 Needs assistance.
Hack installed good, when on page to edit or change avatar. The drop-down list of the avatar categories is displayed. However, when you click on it, it loads and nothing shows up. Please advise.

-Leo
www.thewbs-charmed.com

Heazy 01-14-2005 06:22 AM

does anyone have problems with this hack as to why you can't upload avatars from someone profile? Did I miss something? Should I just unstall it then reinstall it again? Help.. I have 2.3.5.. thanks

Heazy 01-15-2005 01:02 AM

bumppppp

Heazy 01-15-2005 07:09 AM

Sorry but I got this fixed, turned out some of the files were missing some codes. :-s So thanks ! (on vb 2.3.5)

Bella Luna 01-20-2005 05:24 PM

I'm havinbg a serious problem and I'm hoping someone can help me. I'm not be using the same hack version, but I'll try none the less ...

Database error in vBulletin 2.3.5:

Invalid SQL: SELECT * FROM avatar WHERE avatarcat=1 AND minimumposts<='6' ORDER BY title LIMIT 0,
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 1

mysql error number: 1064

Date: Thursday 20th of January 2005 02:15:13 PM
Script: http://www.dh-boards.com/member.php?...ion=editavatar

Well obviously the hack isn't working and whenever I try to change or edit my own AV now, I get this. :dead:

Marco van Herwaarden 01-20-2005 06:22 PM

you have a trailing comma "," in your query.

Bella Luna 01-21-2005 03:39 AM

Just delete it?

Ok, not meaning to sound like a boob, but I haven't touched a vB in about 2 years. Need a refresher course I'm thinking. :(

CFF Staff 01-29-2005 09:02 AM

Hello, my problem is quite simple... I have followed the installation instructions to the letter. All appears correctly with one exception. The category drop-down box appears and it says that it's showing 1 to 36 of 36 avatars, however, the avatars aren't showing.

Please advise.........aasap...

-Leo

CFF Staff 01-29-2005 09:57 AM

Additonal problem under user.php

Parse error: parse error, unexpected '}' in /home2/theufpo/public_html/admin/user.php on line 671

Destroyed Soul 01-30-2005 07:43 PM

I Reinstalled it, and now I have a new problem.... The avatars dont show up, at all... How can I make the avatars show up!??! It looks just like the normal avatar selection, but with no av's... There is a Screencap attached.

Destroyed Soul 02-04-2005 06:42 PM

bump

Alex Carter 02-08-2005 05:29 PM

I have the same problem... Not sure that anyone's checking this thread to help though :(

Heazy 02-08-2005 09:42 PM

Quote:

Originally Posted by bad_madman
Oops. With update 2.3.2 come a new function for a better page-navi in the file 'admin\functions.php'. But no problem:
search in member.php for
Code:

  $perpage = $numavatarshigh * $numavatarswide;
and inserting (!!!) the following lines under this
Code:

  if (!isset($pagenumber) or $pagenumber==0) $pagenumber=1;
  $limitlower=($pagenumber-1)*$perpage+1;
  $limitupper=($pagenumber)*$perpage;

and search in member.php for
Code:

  sanitize_pageresults($totalavatars, $pagenumber, $perpage, $perpage, $perpage);

  $limitlower=($pagenumber-1)*$perpage+1;
  $limitupper=($pagenumber)*$perpage;

and replace with
Code:

//  sanitize_pageresults($totalavatars, $pagenumber, $perpage, $perpage, $perpage);

//  $limitlower=($pagenumber-1)*$perpage+1;
//  $limitupper=($pagenumber)*$perpage;



Believe me people been having this problem a lot, try this, cuz mine is up and going.. if you do what this part ^^^ up here tells ya.. then you should see you avatars AND you gotta put them in order as well, like if you have,

Avatar Misc 0
Avatar #2 0

You gotta put 1 then 2 then fix the order.. that should work as well.. and you have to put in the schemes too.. I hope that helps (blushes)

ngx 02-23-2005 07:21 PM

Buggy problem on 2.3.5 with the registration process.

It has been occuring a lot that people while registering have access to all avatars, even the ones marked for certain usergroups only. I have it currently circumvented by removing the avatarbits from the registration templates, but is there a more convenient solution for this?

Cheers

Destroyed Soul 03-14-2005 06:53 PM

it doesnt work.... the parts arent there

CFF Staff 04-21-2005 06:23 PM

Alright. Version vbulletin 2.3.6
I ran the installation file for his modification, I also edited the necessary templates and files that the installation file instructed you to as well as installing the necessary template files. The problem is that when your in the area on the forums that you select or change your avatar, you can clear see the drop-down list of the categories for avatars and it will say, displaying avatars 1-7 of 7 (74 Avatars total), and then nothing. Basically it displays the categories but not the avatars.

The link to my forums is included below, they are called: Charmed Forever Forums! This is a very important issue for my members, because I have them all complaining about it. so, please the moderators here, I'm requesting a solution answer to my problem as soon as humanly possible. If necessary, you can contact on AIM: ElderLeoWyatt OR EMAIL: leowyatt_whitelighter@yahoo.com OR Work Cell: (216) 254-0539 Thank you very much for your time and look forward to your expediant reply.
www.thewbs-charmed.com

Raw Sugar 04-24-2005 02:58 AM

Quote:

Originally Posted by CFF Staff
Alright. Version vbulletin 2.3.6
I ran the installation file for his modification, I also edited the necessary templates and files that the installation file instructed you to as well as installing the necessary template files. The problem is that when your in the area on the forums that you select or change your avatar, you can clear see the drop-down list of the categories for avatars and it will say, displaying avatars 1-7 of 7 (74 Avatars total), and then nothing. Basically it displays the categories but not the avatars.

The link to my forums is included below, they are called: Charmed Forever Forums! This is a very important issue for my members, because I have them all complaining about it. so, please the moderators here, I'm requesting a solution answer to my problem as soon as humanly possible. If necessary, you can contact on AIM: ElderLeoWyatt OR EMAIL: leowyatt_whitelighter@yahoo.com OR Work Cell: (216) 254-0539 Thank you very much for your time and look forward to your expediant reply.
www.thewbs-charmed.com

That's the problem I am currently having. I can see it in the admin cp when I am editting a member's profile. But in the User cp, I can't see the avatars. I really do hope that a mod here can help us, since the creater is MIA.

Painted Aura 05-26-2005 11:43 AM

I have a vb version 2.3.3 and that hack won't work on it. I've tried everything. Can someone explain me how to make it work from the scratch please?

The Phantom 05-28-2005 05:27 AM

First, try a fresh install of the hack and then search this thread for the fix to it. I can remember the specific link but someone has made some code to fix that problem for our new version 2.3.x vBulletins. The answer is here. :)

Destroyed Soul 09-06-2005 08:31 PM

When I tried installing it, I got this problem:

Quote:

Database error in vBulletin Control Panel 2.3.7:
Invalid SQL: SELECT COUNT(*) AS itexists FROM avatar_categories WHERE avatar_categoriesid='1'
mysql error: Table 'resist_asoue.avatar_categories' doesn't exist
mysql error number: 1146
Date: Monday 05th of September 2005 04:44:31 PM
Script: http://www.resist-insanity.net/foru...php?action=add&
Referer: http://www.resist-insanity.net/foru...ion=nav&cpnavjs=
Do you know whats wrong?

The Artist 09-12-2005 06:29 PM

Hii!

I have a problem ??

Quote:

Database error in vBulletin Control Panel 2.3.7:

Invalid SQL: SELECT * FROM avatar_categories
mysql error: Table 'Sql75863_2.avatar_categories' doesn't exist

mysql error number: 1146

Date: Monday 12th of September 2005 09:27:16 PM
Script: http://www.pre-witched.com/admin/sqltodos.php
Referer: http://www.pre-witched.com/admin/sql...p?action=page2

CFF RA's 01-04-2006 12:27 AM

If you people are going to have a support thread for your hacks, you should at least be available to offer support.

CFF RA's 01-04-2006 12:57 AM

Database error in vBulletin Control Panel 2.3.8:

Invalid SQL: SELECT * FROM avatar_categories
mysql error: Table 'thewbsch_cff.avatar_categories' doesn't exist

mysql error number: 1146

Date: Tuesday 03rd of January 2006 09:56:49 PM
Script: http://thewbs-charmed.net/admin/sqltodos.php
Referer: http://thewbs-charmed.net/admin/sqlt...p?action=page2

CFF RA's 01-04-2006 09:07 AM

I have been asking for support for the Avatars Categories Hack for the longest time now, I've also emailed vBulletin and Jelsoft regarding the lack of support...

The error message I got when I tried adding tables to the database via the sqltodos.php is as follows...

Database error in vBulletin Control Panel 2.3.8:

Invalid SQL: SELECT * FROM avatar_categories
mysql error: Table 'thewbsch_cff.avatar_categories' doesn't exist

mysql error number: 1146

Good day!

CFF RA's 01-04-2006 09:41 AM

It's actually version 2.3.7

CFF RA's 05-27-2006 05:43 PM

How bout you guys give soe support if thats why your here?!?

CFF RA's 05-28-2006 04:36 PM

Database error in vBulletin Control Panel 2.3.7:

Invalid SQL: SELECT * FROM avatar WHERE $where1 AND minimumposts<='$bbuserinfo[posts]' ORDER BY title LIMIT ".($limitlower-1).",$perpage
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 '".($limitlower-1).",$perpage' at line 1

mysql error number: 1064

CFF RA's 05-28-2006 04:38 PM

Database error in vBulletin Control Panel 2.3.7:

Invalid SQL: SELECT * FROM avatar WHERE $where1 AND minimumposts<='$bbuserinfo[posts]' ORDER BY title LIMIT ".($limitlower-1).",$perpage
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 '".($limitlower-1).",$perpage' at line 1

mysql error number: 1064

========================================

Can you please give me the code to correct this, thank you.

Saskia 07-13-2006 09:54 AM

As noted by the hack creator: this hack is not supported. This guy hasn't been online in months and the hack is almost 5 years old.

vBulletin and Jelsoft have nothing to do with hack support, so emailing them is quite useless actually.

Personally I suggest upgrading to a vBulletin 3. I didn't get this hack to work either a few months ago on a vBulletin 2.3.x version and since it's implemented in the newer vBulletin versions, I just upgraded to vBulletin 3 and did my thing there. I would highly suggest doing that, trust me you'll benefit from it eventually. You can get the looks of vBulletin 2 done with vBulletin 3 if you want, so there's no real pressing reason to stay on vBulletin 2 these days.

Good luck.


All times are GMT. The time now is 02:58 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.01523 seconds
  • Memory Usage 1,831KB
  • 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
  • (4)bbcode_code_printable
  • (3)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (37)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