[addon] DREAMBOARD V 2.1

[Stoleti]

i've search in mysql (phpadmin) and i've found in my 4images_users , a table "user_posts" being this used on board.

So how can i make it show in users profiles, the number of posts (own posts)...

example:

profile of: Myself

Forum Posts: XXX

cheers 

[TheOracle]

With a "SELECT Count" statement.

[Stoleti]

With a "SELECT Count" statement.

erm ...i'm php newbie 

[TheOracle]

Very well.

In your member.php file,

find :

"user_icq_status" => (isset($user_row['user_icq'])) ? get_icq_status($user_row['user_icq']) : REPLACE_EMPTY,

add right below :

Code: [Select]


"lang_user_posts" => $lang['user_posts_status'],
"user_posts" => (isset($user_row['user_posts'])) ? $user_row['user_posts'] : REPLACE_EMPTY,


Then, in your lang/english/main.php file,

add before the "?>" tag :

Code: [Select]


$lang['user_posts_status'] = "This user has posted:";


Then, in your member_profile.html file,

use your tags like this :

Code: [Select]


{lang_user_posts}
{user_posts}


(as it would fit in your personalized template presentation - of course).

This should work just fine.

[Stoleti]

works perfect !!!!!!!!

  thanks alot !!!

[TheOracle]

Excellent. I even thought about adding a "total count" for user postings from the page header. This could, in fact, be added as part of the statistics MOD as well. What do you think ?

Something like : Total posts from users:

Let me know if you're interested.

[Stoleti]

Excellent. I even thought about adding a "total count" for user postings from the page header. This could, in fact, be added as part of the statistics MOD as well. What do you think ?

Something like : Total posts from users:

Let me know if you're interested.

Yes, i've think on that before 

Thats a Good Ideia !!!

------
1)
Another ideia its track the user posts (show all forum posts by XX user in your profile) same used before with user comments(gallery)

2)
A simply and useful ideia : make post subjects as links,so users can go directly to one specific post (i.e used here on this forum)


Cheers

[Olphi]

1. I found a problem: If I edit my own posts, the old text isn't anymore available and I must rewrite the whole post! How can I show the old post in the textfield???

2. Another thing is: You can't move topics and Replies from one category to another... How can I change this, it's to hard for me to program... 

Thanks

[mawenzi]

... You can't move topics and Replies from one category to another... How can I change this ...

... gehe in dein phpMyAdmin -> 4images_boardtrep -> repthrid / repforid ...
... durch logische Änderung der Board-ID (repthrid) und der Themen-ID (repforid) kannst du eine Antwort verschieben ...
... logisch : durch die Kombination aus den IDs muss die Antwort einem Thema eindeutig zugeordnet werden können ...

mawenzi

[TheOracle]

@Stoleti:

Another ideia its track the user posts (show all forum posts by XX user in your profile) same used before with user comments(gallery)

I thought of this idea before actually. If no one else posts this routine, I will see what I can do.

A simply and useful ideia : make post subjects as links,so users can go directly to one specific post (i.e used here on this forum)

I'm not sure I get this one though. Do you mean the "latest topic" users creates and could appear (with the link) from his user profile ?

[Stoleti]

I'm not sure I get this one though. Do you mean the "latest topic" users creates and could appear (with the link) from his user profile ?

yes i know we've the topic link and latest post link , but the past "posts" doesn't have a link

I mean if we want show one specific post in one topic !!!

example :

http://www.yoursite.com/showthread.php?bid=1&threadid=194#1
http://www.yoursite.com/showthread.php?bid=1&threadid=194#2


etc....

or some like it

[TheOracle]

I believe this might be possible to do. This is simply SQL ordering during the row selection that could be added in member.php file.

However, since I have not installed this MOD, you'd need to give me the coded URL (from the PHP files) on where the topics are actually pointed. This way, I could customize it.

[TheOracle]

Ok, for the latest post from a specific thread, I believe I found the way to do so (untested).

First, make a backup of your member.php file.

Then, find this block :

$user_icq = (isset($user_row['user_icq'])) ? $user_row['user_icq'] : REPLACE_EMPTY;
    if (!empty($user_icq) && $user_icq != REPLACE_EMPTY) {
      $user_icq_button = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=".$user_icq."\" target=\"_blank\"><img src=\"http://web.icq.com/whitepages/online?icq=".$user_icq."&img=5\" width=\"18\" height=\"18\" border=\"0\" alt=\"".$user_icq."\" /></a>";
    }
    else {
      $user_icq_button = REPLACE_EMPTY;
    }

add below :

Code: [Select]


$boardgories = "

SELECT catid, catname
FROM ".BOARD_CAT_TABLE."

";

$result = $site_db->query($boardgories);

$dboard_cat_row = $site_db->fetch_array($boardgories);

$board_catid = $dboard_cat_row['catid'];

$dreamboard_selection = "

SELECT board_id, board_catid, board_name, board_desc, board_posts, board_topics, board_lastpost_id, board_lastpost_user, board_lastpost_date, board_lastpost_page, board_moderator, board_moderator_id, auth_view
FROM ".BOARD_TABLE."
WHERE board_catid = '".$board_catid."'
LIMIT 1

";

$result = $site_db->query($dreamboard_selection);

$dboard_row = $site_db->fetch_array($result);

$board_id = $dboard_row['board_id'];
$board_catid = $dboard_row['board_catid'];
$board_name = $dboard_row['board_name'];
$board_desc = $dboard_row['board_desc'];
$board_topics = $dboard_row['board_topics'];
$board_posts = $dboard_row['board_posts'];
$board_lastpost_id = $dboard_row['board_lastpost_id'];
$board_lastpost_user = $dboard_row['board_lastpost_user'];
$board_lastpost_date = $dboard_row['board_lastpost_date'];
$board_lastpost_page = $dboard_row['board_lastpost_page'];
$board_moderator = $dboard_row['board_moderator'];
$board_moderator_id = $dboard_row['board_moderator_id'];
$auth_view = $dboard_row['auth_view'];
$newlastpost = "<img src=\"".TEMPLATE_PATH."/board_images/new_last_post.gif\" border=\"0\" alt=\"".$lang['button_lastpost']."\">";


Then, find :

"user_icq_status" => (isset($user_row['user_icq'])) ? get_icq_status($user_row['user_icq']) : REPLACE_EMPTY,

add right below :

Code: [Select]


"lang_dboard_lastpost_topic" => $lang['dboard_user_lastposted'],
"dboard_lastpost_topic" => "<a href=\"".$site_sess->url(ROOT_PATH."showthread.php?bid=".$board_id."&threadid=".$board_lastpost_id."&page=".$board_lastpost_page)."\">".$newlastpost."</a>",


Then, in your lang/english/main.php file,

add before the : "?>" tag :

Code: [Select]


$lang['dboard_user_lastposted'] = "Last post from user:";


Then, on your member_profile.html file,

you should now be able to use these two tags :

Code: [Select]


{lang_dboard_lastpost_topic}
{dboard_lastpost_topic}


Note: Remember that this is untested.

Let me know how it goes.

[TheOracle]

Update: My post above has been updated.

[mawenzi]

it should be better ...

Code: [Select]

$boardgories = "
SELECT catid, catname
FROM ".BOARD_CAT_TABLE."
";