Profile Tagboard (a tagboard in every user's profiles)

hmm.. I dont think this has been released before.. or at least i couldn't find it.

so, here we go

sql queries to run: 1
file edits: 1
template edits: 1 and 3 new templates

the hack adds a tagboard to every user's profile. There's not much more to tell about it, really. It's made so only members of your forum can post in the tagboard, of course
uhm.. the standard version of the tagboard only shows the 10 newest messages, but you can easily change it.
just find:

("SELECT * FROM profiletagboard WHERE touserid='$userinfo[userid]' ORDER BY id DESC LIMIT 10")

and change the LIMIT to whatever you want.. (i might add a "show all messages" in the next version)

I might add more stuff in future versions. Like edit buttons, delete buttons and whatever I can come up with..any suggestions are welcome

v1.1 Upgrade:
HTML has been disabled
You can now edit/delete messages
The tagboard owner can now delete messages in his/her board
You can now show all your messages

Total Files to edit: 1
Total Templates to edit: 1 and 9 new templates
Total sql queries to run: 1

v1.2 Upgrade:
Smilies in messages have been enabled
bbcode has been enabled
fewer queries

Total Files to edit: 1
Total Templates to edit: 1 and 9 new templates
Total sql queries to run: 1

Screenshots:
1
2
3
4
5 (before v1.2)
6 (after v1.2)

Live Demo:
Not available

oh.. and remember to click Install, if you install

[The_Wanderer]

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

[Kaelon]

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]

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

[The_Wanderer]

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

[msimplay]

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

[The_Wanderer]

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

[Phoenix_Fighter]

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]

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]

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

[Tae-Hwan]

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