vb.org Archive
Page 13 of 15 « First 31112 13 1415
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.


All times are GMT. The time now is 04:41 PM.
Page 13 of 15 « First 31112 13 1415
Show 40 post(s) from this thread on one page

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.01597 seconds
  • Memory Usage 1,761KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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