Bravo List - some mods needed

Bravo List (http://www.bvlist.com/index.php)

- BT.Manager (phpMyBitTorrent) (http://www.bvlist.com/forumdisplay.php?f=23)

- - some mods needed (http://www.bvlist.com/showthread.php?t=6628)

some mods needed

First off is there a default avatar mod for pmbt
like if user has none use placeholder ?

is there a private login for pmbt
like you can see only login till you login ?

plus i need recent members with pictures mod

yes its noavatar.gif
yes go to admin pannel=>settings and set site as private

PHP Code:


		
			
<?php
/*
*----------------------------phpMyBitTorrent V 2.0-----------------------------*
*--- The Ultimate BitTorrent Tracker and BMS (Bittorrent Management System) ---*
*--------------   Created By Antonio Anzivino (aka DJ Echelon)   --------------*
*-------------               http://www.p2pmania.it               -------------*
*------------ Based on the Bit Torrent Protocol made by Bram Cohen ------------*
*-------------              http://www.bittorrent.com             -------------*
*------------------------------------------------------------------------------*
*------------------------------------------------------------------------------*
*--   This program is free software; you can redistribute it and/or modify   --*
*--   it under the terms of the GNU General Public License as published by   --*
*--   the Free Software Foundation; either version 2 of the License, or      --*
*--   (at your option) any later version.                                    --*
*--                                                                          --*
*--   This program is distributed in the hope that it will be useful,        --*
*--   but WITHOUT ANY WARRANTY; without even the implied warranty of         --*
*--   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          --*
*--   GNU General Public License for more details.                           --*
*--                                                                          --*
*--   You should have received a copy of the GNU General Public License      --*
*--   along with this program; if not, write to the Free Software            --*
*-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA --*
*--                                                                          --*
*------------------------------------------------------------------------------*
*------              ©2005 phpMyBitTorrent Development Team              ------*
*-----------               http://phpmybittorrent.com               -----------*
*------------------------------------------------------------------------------*
*-----------------   Sunday, September 14, 2008 9:05 PM   ---------------------*
*/
OpenTable("Newest Members");
global $db_prefix;
$file = "cache/cache_newestmemberblock.txt";
$expire = 60; // time in seconds
if (file_exists($file) &&
    filemtime($file) > (time() - $expire)) {
    $newestmemberrecords = unserialize(file_get_contents($file));
}else{ 
    $sql = "SELECT id AS id, avatar AS avatar, can_do AS can_do, IF(name IS NULL, username, name) as name FROM ".$db_prefix."_users WHERE active = 1 AND ban ='0' ORDER BY id DESC LIMIT 5";
    $newestmemberquery = $db->sql_query($sql);
    
    while ($newestmemberrecord = $db->sql_numrows($newestmemberquery) ) {
        $newestmemberrecords[] = $newestmemberrecord;
    }
    $OUTPUT = serialize($newestmemberrecords);
    $fp = fopen($file,"w");
    fputs($fp, $OUTPUT);
    fclose($fp);
} // end else 
$new_users = array();
if ($newestmemberrecords == ""){
echo "No new members";
}else{
echo "<table width=\"100%\" class=\"torrenttable\" border=\"0\" cellpadding=\"3\" ><tr>";
    foreach ($newestmemberrecords as $id=>$row) { 
        echo "<td padding=\"0\">\n<center>";
                        if ($row["avatar"] != "blank.gif") echo "<img height=\"50px\" src=\"avatars/".$row["user_avatar"]."\" alt=\"".str_replace("**user**",$row["name"],_btalt_avatar)."\" border=\"0\">";
                        else echo pic("noavatar.png");
       echo "";
        echo "<a href='user.php?op=profile&id=".$row['id']."'><font color=\"".getusercolor($row["can_do"])."\">".htmlspecialchars($row["name"])."</font></a>\n</center></td>\n";

    }
echo "</tr></table>\n";
}
CloseTable();
?>

Quote:

Originally Posted by it53lv (Post 28582)

thanks m8

your welcome

newest member block mod doesn't work
shows no new members

look in cache/cache_newestmemberblock.txt whats it say

it say's

Code:

N;

change

PHP Code:


		
			
$newestmemberquery = $db->sql_query($sql);

PHP Code:


		
			
$newestmemberquery = $db->sql_query($sql)or btsqlerror($sql);

error code

Code:

 SQL Error Error Executing SQL Query SELECT id AS id, avatar AS avatar, can_do AS  can_do, IF(U.name IS NULL, U.username, U.name) as name FROM  torrent_users WHERE active = 1 AND ban ='0' ORDER BY id DESC LIMIT 5

Error ID: 1054

Error Message: Unknown column 'U.name' in 'field list'

I updated the post try it now

PHP Code:


		
			
<?php
//USERS ONLINE
OpenTable("Newest Members");
echo "<p>\n";
global $db_prefix;
$file = "cache/cache_newestmemberblock.txt";
$expire = 60; // time in seconds
if (file_exists($file) &&
    filemtime($file) > (time() - $expire)) {
    $newestmemberrecords = unserialize(file_get_contents($file));
}else{ 
    $newestmemberquery = $db->sql_query("SELECT U.id as id,
                                         avatar as avatar,
                                         IF(U.name IS NULL,U.username, U.name) as name,
                                         U.donator as donator,
                                         U.warned as warned,
                                         U.can_do as can_do,
                                         U.level as level,
                                         L.color as color
            FROM ".$db_prefix."_users U , ".$db_prefix."_levels L 
            WHERE U.active = 1
            AND U.ban = 0 
            AND L.level = U.can_do
            ORDER BY id DESC LIMIT 5") or die(mysql_error());
    
    while ($newestmemberrecord = $db->sql_fetchrow($newestmemberquery) ) {
        $newestmemberrecords[] = $newestmemberrecord;
    }
    $OUTPUT = serialize($newestmemberrecords);
    $fp = fopen($file,"w");
    fputs($fp, $OUTPUT);
    fclose($fp);
} // end else 
if ($newestmemberrecords == ""){
    echo "No new members";
}else{
echo "<table width=\"100%\" class=\"torrenttable\" border=\"0\" cellpadding=\"3\" ><tr>";
    foreach ($newestmemberrecords as $id=>$row) { 
        echo "<td padding=\"0\">\n<center>";
                        if ($row["avatar"] != "blank.gif") echo "<img height=\"50px\" src=\"avatars/".$row["avatar"]."\" alt=\"".str_replace("**user**",$row["name"],_btalt_avatar)."\" border=\"0\">";
                        else echo pic("noavatar.png");
       echo "";
        echo "<a href='user.php?op=profile&id=".$row['id']."'><font color=\"".$row["color"]."\">".htmlspecialchars($row["name"])."</font></a>\n</center></td>\n";

    }
echo "</tr></table>\n";
}
CloseTable();
?>