Avatar billede zidane5 Nybegynder
21. oktober 2011 - 13:47 Der er 1 kommentar og
1 løsning

Få overført threadcount tallet til et andet sted?

Hej. Er det muligt at få overført threadcount fra et bestemt forum i nedenstående fil til f.eks. en tekst på min side? Jeg tænker her kun på tallet i threadcount, eller skal jeg til at skrive det manuelt. Det kunne være dejligt, hvis det kunne gøres automatisk, når der sker der noget i threacount.

Er det ikke muligt at gøre f.eks. noget med:

".$dataforumid="1"['forum_threadcount']."


Her er hele filen:

<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: index.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "../maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."forum/main.php";

if (!isset($lastvisited) || !isnum($lastvisited)) { $lastvisited = time(); }

add_to_title($locale['global_200'].$locale['400']);

opentable();
echo "<!--pre_forum_idx--><table cellpadding='0' cellspacing='1' width='100%' class='tbl-border forum_idx_table'>\n";

$forum_list = ""; $current_cat = "";
$result = dbquery(
    "SELECT f.*, f2.forum_name AS forum_cat_name, u.user_id, u.user_name, u.user_status
    FROM ".DB_FORUMS." f
    LEFT JOIN ".DB_FORUMS." f2 ON f.forum_cat = f2.forum_id
    LEFT JOIN ".DB_USERS." u ON f.forum_lastuser = u.user_id
    WHERE (".groupaccess('f.forum_access')." OR ".groupaccess('f.forum_moderators').") AND f.forum_cat='82' OR f.forum_cat='85'
    GROUP BY forum_id ORDER BY f2.forum_order ASC, f.forum_order ASC"
);
if (dbrows($result) != 0)

{

    $ialt = 0;

    while ($data = dbarray($result)) {
        if ($data['forum_cat_name'] != $current_cat) {
            $current_cat = $data['forum_cat_name'];
            echo "<tr>\n<td colspan='2' class='forum-caption forum_cat_name'><!--forum_cat_name--><b>".$data['forum_cat_name']."</b></td>\n";
            echo "<td align='center' width='1%' class='forum-caption' style='white-space:nowrap'>Antal</td>\n";
            echo "<td align='center' width='1%' class='forum-caption' style='white-space:nowrap'>Vundne</td>\n";

            echo "</tr>\n";
        }
        $moderators = "";
        if ($data['forum_moderators']) {
            $mod_groups = explode(".", $data['forum_moderators']);
            foreach ($mod_groups as $mod_group) {
                if ($moderators) $moderators .= ", ";
                $moderators .= $mod_group<101 ? "<a href='".BASEDIR."profile.php?group_id=".$mod_group."'>".getgroupname($mod_group)."</a>" : getgroupname($mod_group);
            }
        }
        $forum_match = "\|".$data['forum_lastpost']."\|".$data['forum_id'];
        if ($data['forum_lastpost'] > $lastvisited) {
            if (iMEMBER && ($data['forum_lastuser'] == $userdata['user_id'] || preg_match("({$forum_match}\.|{$forum_match}$)", $userdata['user_threads']))) {
                $fim = "<img src='".get_image("folder")."' alt='".$locale['561']."' />";
            } else {
                $fim = "<img src='".get_image("foldernew")."' alt='".$locale['560']."' />";
            }
        } else {
            $fim = "<img src='".get_image("folder")."' alt='".$locale['561']."' />";
        }
        echo "<tr>\n";
        echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'>$fim</td>\n";
        echo "<td class='tbl1 forum_name'><!--forum_name--><a href='ekspertarkiv.php?forum_id=".$data['forum_id']."'>".$data['forum_name']."</a><br />\n";
        if ($data['forum_description'] || $moderators) {
            echo "<span class='small'>".$data['forum_description'].($data['forum_description'] && $moderators ? "<br />\n" : "");
            echo ($moderators ? "<strong>".$locale['411']."</strong>".$moderators."</span>\n" : "</span>\n")."\n";
        }
        echo "</td>\n";
        echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'>".$data['forum_threadcount']."</td>\n";



$ialt= $ialt + $data['forum_threadcount'];     




        echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'>".number_format($solved_posts)."</td>\n";

        if ($data['forum_lastpost'] == 0) {
            echo "</td>\n</tr>\n";
        } else {
            echo "</tr>\n";
        }
    }
} else {
    echo "<tr>\n<td colspan='5' class='tbl1'>".$locale['407']."</td>\n</tr>\n";
}
echo "</table>\n";
echo "<!--pre_forum_idx--><table cellpadding='0' cellspacing='1' width='100%' class='tbl-border forum_idx_table'>\n";
echo "<tr><td width='1%' class='tbl2' style='white-space:nowrap'>Ialt</td>\n";
echo "<td align='right' width='3%'class='tbl2' style='white-space:nowrap'>".$ialt."
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
".number_format($solved_posts)."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>\n";
echo "</tr></table>\n";

echo "<!--sub_forum_idx_table-->\n<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
echo "<td class='forum'><br />\n";
echo "<img src='".get_image("foldernew")."' alt='".$locale['560']."' style='vertical-align:middle;' /> - ".$locale['409']."<br />\n";
echo "<img src='".get_image("folder")."' alt='".$locale['561']."' style='vertical-align:middle;' /> - ".$locale['410']."\n";
echo "</td><td align='right' valign='bottom' class='forum'>\n";
echo "<form name='searchform' method='get' action='".BASEDIR."search.php?stype=forums'>\n";
echo "<input type='hidden' name='stype' value='forums' />\n";
echo "<input type='text' name='stext' class='textbox' style='width:150px' />\n";
echo "<input type='submit' name='search' value='".$locale['550']."' class='button' />\n";
echo "</form>\n</td>\n</tr>\n</table><!--sub_forum_idx-->\n";
closetable();

require_once THEMES."templates/footer.php";
?>
Avatar billede JensPeterSvensson Nybegynder
30. oktober 2011 - 08:45 #1
Er det ikke bare:

$result = dbquery(
    "SELECT forum_thread_count FROM ".DB_FORUMS." WHERE forum_id=ID");
Avatar billede zidane5 Nybegynder
06. december 2011 - 23:30 #2
s
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
IT-kurser om Microsoft 365, sikkerhed, personlig vækst, udvikling, digital markedsføring, grafisk design, SAP og forretningsanalyse.

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester