vb.org Archive - Profile Tagboard (a tagboard in every user's profiles)

Page 4 of 4

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Profile Tagboard (a tagboard in every user's profiles) (https://vborg.vbsupport.ru/showthread.php?t=51705)

The_Wanderer

06-18-2003 12:45 PM

that shouldnt be a problem...

FIND:

PHP Code:


		
			
SELECT 

  user.avatarid AS a_id,

  avatar.avatarpath AS a_path,

  customavatar.userid AS c_id,

  customavatar.dateline AS dateline,

  profiletagboard.msg AS msg,

  profiletagboard.fromuserid AS fromuserid,

  profiletagboard.touserid AS touserid,

  user.username AS username,

  user.userid AS userid,

  user.usertitle AS title,

  profiletagboard.id AS id 





  FROM avatar,customavatar,profiletagboard



  LEFT JOIN user ON user.userid=profiletagboard.fromuserid



  WHERE 

  touserid='$userinfo[userid]' AND user.avatarid=avatar.avatarid 

  OR touserid='$userinfo[userid]' AND user.avatarid='0' AND user.userid=customavatar.userid

  OR touserid='$userinfo[userid]' AND user.avatarid='0' AND user.userid!=customavatar.userid



  GROUP BY msg ORDER BY id DESC

and replace with: (2 times)

PHP Code:


		
			
SELECT 

  profiletagboard.msg AS msg,

  profiletagboard.fromuserid AS fromuserid,

  profiletagboard.touserid AS touserid,

  user.username AS username,

  user.userid AS userid,

  user.usertitle AS title,

  profiletagboard.id AS id 





  FROM profiletagboard



  LEFT JOIN user ON user.userid=profiletagboard.fromuserid



  WHERE 

  touserid='$userinfo[userid]' 

  GROUP BY msg ORDER BY id DESC

FIND and delete: (2 times)

PHP Code:


		
			
if ($result[a_id] == "0" AND $result[c_id] == "$result[userid]") {

    $tbavatar="avatar.php?userid=$result[userid]&dateline=$result[dateline]";

    };

    if ($result[a_id] == "0" AND $result[c_id] != "$result[userid]") {

    $tbavatar="avatar.php?userid=$result[userid]&dateline=$result[dateline]";

    };

    if ($result[a_id] != "0") {

    $tbavatar="$result[a_path]";

    };

I haven't tested this but i think it works :p

Kaelon

06-18-2003 06:38 PM

That works great, The_Wanderer, thanks! One more thing, though - to completely remove avatars, you'll want to eliminate the <img src> in the appropriate templates for the Tagboard.

Again, very nice hack!

StealthAnime

06-18-2003 07:45 PM

really really nice, kinda list an instant PM IM thing :D i like, ima install

The_Wanderer

06-19-2003 10:27 AM

Quote:

Yesterday at 08:38 PM Kaelon said this in Post #122
That works great, The_Wanderer, thanks! One more thing, though - to completely remove avatars, you'll want to eliminate the <img src> in the appropriate templates for the Tagboard.

Again, very nice hack!

oh yeah the templates, of course! I knew there was something i forgot :p

msimplay

08-10-2003 12:50 PM

was wondering if u could add vbcode buttons + Smileys to the message entry form

The_Wanderer

08-10-2003 08:42 PM

I could try.. I'm just really busy, so I can't really promise anything..

Phoenix_Fighter

08-21-2003 03:27 AM

I just installed this hack and i tried to test it out everything worked great cept the message didnt show up i checked all the templates everything was there i use Zajako and Storm's RPG Creator System and i run vB 2.3.0....i dont know what possibly could be wrong

Boh	08-24-2003 04:24 PM

Yeah uh... I installed it... and I don't get any errors or anything, but it doesn't work when I try to tag

narulure

08-25-2003 11:27 PM

Im getting the same sort of problem. I hope this can be fixed ^^

Tae-Hwan

08-29-2003 09:29 AM

^ i'm getting the same problems as everyone else. i think this has to do with mysql settings or something.

Tae-Hwan

08-29-2003 09:35 AM

actually, it seems to be a problem with the SELECT calls to the avatar and customavatar tables.

[edit]

ok, if you remove all the queries to the avatar and customavatar tables, it'll work just fine. i think this may be a problem affecting only those of us who do not use the built-in vbulletin avatar system. *shrug* i got it to work this way.

afterglow

08-30-2003 12:43 AM

a question though, has anyone installed this hack on the latest version of vb? (ver. 3)

The_Wanderer

08-30-2003 05:41 PM

Quote:

Yesterday at 11:35 AM Tae-Hwan said this in Post #131
actually, it seems to be a problem with the SELECT calls to the avatar and customavatar tables.

[edit]

ok, if you remove all the queries to the avatar and customavatar tables, it'll work just fine. i think this may be a problem affecting only those of us who do not use the built-in vbulletin avatar system. *shrug* i got it to work this way.

aahhhh.. so that's the problem.. i've been wondering for quite a while now..

Tae-Hwan

08-30-2003 10:45 PM

Quote:

Yesterday at 02:43 AM afterglow said this in Post #132
a question though, has anyone installed this hack on the latest version of vb? (ver. 3)

This is a funny question! :D

The_Wanderer

08-31-2003 12:39 PM

Those of you who have problems should take a look at the post at the top of page 9..it should fix things, according to Tae-Hwan :)

Tae-Hwan

08-31-2003 06:44 PM

Quote:

Today at 02:39 PM The_Wanderer said this in Post #136
Those of you who have problems should take a look at the post at the top page 9..it should fix things, according to Tae-Hwan :)

oops, i didn't even look at that code.. i thought you were responding to the guy asking for instructions on how to optimize the queries. i feel dumb now, went through all that trouble for nothing. :D

[edit]

actually you were! now i feel even more dumb. and at the same time, it coincidentally fixes the problems with people who aren't using the vbulletin avatar system. *deep breath* whew ok i think we're on the same page now.. ^_^

The_Wanderer

09-01-2003 09:45 AM

Quote:

Yesterday at 10:19 PM Me! said this in Post #138
Does that mean you can't display avatar? :(

This may seem simplistic, but isn't there a way to call the users avatar like in the postbit?

I'm sure there is a way. But I wouldn't know how, as I use the vb avatar system.. in fact, I didn't even know there was another system :p

lasto

09-01-2003 01:01 PM

the welcome panel calls in the avator so look at that code for hints.

The_Wanderer

09-06-2003 02:24 PM

Quote:

09-01-03 at 03:01 PM lasto said this in Post #141
the welcome panel calls in the avator so look at that code for hints.

yeah but it only calls your own avatar... doesnt it? :confused:

PsyBlast

11-22-2003 12:42 AM

nice hack :) I could only get this working with your 1.1 version on my 2.3.3 version board.

But I have a few minor "requests" Smilies, vbcode, and admin cp control.

*clicks install*

PsyBlast

11-24-2003 01:51 AM

I'm using 1.1 of this hack, how can I make it so admins can edit anybodies posts?

The_Wanderer

12-17-2003 04:35 PM

sorry for the late reply...havent been able to do much coding lately..

i probably wont be able to give much support as i'm busy with other stuff :/
but I'll re-write the hack to vb3 when I have time..

Red Blaze

12-17-2003 05:44 PM

I completely uninstalled it. Sorry Wanderer, but this hack in my boards was a failure and created errors. Note: I said my board, I don't know about others and personally I don't care. Hats off to those that made it work.

Crank

02-09-2004 08:50 PM

how about having it so only admins can see this option and make comments about users.

[BA]Techie

02-11-2004 12:41 AM

Could this work with 2.3.0?

Crank

02-15-2004 02:19 PM

yes works on 2.3.0
im hoping this can be done to only allow Admins to view the comments

All times are GMT. The time now is 04:18 AM.

Page 4 of 4

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01247 seconds Memory Usage 1,794KB 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 (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)post_thanks_navbar_search (1)printthread (26)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
Messages: