Codezwiz >> Forums >> General PHP Nuke Help >> Tellli I need your Help!!! Please this is driving me nuts!

What I'm trying to do is display who's a subscribed member using the User Info Block.

I found this in my tables nuke_subscriptions but is there a way to accomplish this for just those members only?

If it helps here is the User-Info block we use

<?PHP
/****************************//*********************************************/
/*All Info Block *//*This program is free software. You can */
/*Author: Alex Hession *//*redistribute it and/or modify it under the */
/*Web: http://gnaunited.com *//*terms of the GNU General Public Licesnse as*/
/*block-User_Info.php *//*published by the Free Software Foundation; */
/*Version 1.0 *//*either version 2 of the License. */
/****************************//*********************************************/
if (eregi("block-User_Info.php", $PHP_SELF)) die("Access Denied");
global $user, $cookie, $prefix, $user_prefix, $db, $anonymous, $sitekey, $gfx_chk;
$content = "";
function last_user()
{
global $db, $user_prefix;
$sql = "SELECT username FROM ".$user_prefix."_users ORDER BY user_id DESC LIMIT 0,1";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$lastuser = $row[username];
return $lastuser;
}
function numusers()
{
global $user_prefix, $db;
$sql = "SELECT * FROM ".$user_prefix."_users";
$res = $db->sql_query($sql);
$numrows = $db->sql_numrows($res);
return $numrows;
}
function who_online()
{
global $prefix, $db;
$sql = "SELECT uname, guest FROM ".$prefix."_session WHERE guest = 0";
$result = $db->sql_query($sql);
$member_online_num = $db->sql_numrows($result);
$who_online_now = "";
$i = 1;
while($session = $db->sql_fetchrow($result))
{
if(isset($session["guest"]) and $session["guest"] == 0)
{
if($i != 1) $br = " ";
if ($i < 10)
{
$who_online_now .= $br."0".$i.": <A HREF=\"modules.php?name=Your_Account&op=userinfo&username=$session[uname]\">$session[uname]</a>\n";
}
else
{
$who_online_now .= $br.$i.": <A HREF=\"modules.php?name=Your_Account&op=userinfo&username=$session[uname]\">$session[uname]</a>\n";
}
$who_online_now .= ($i != $member_online_num ? " " : "");
$i++;
}
}
return $who_online_now;
}
function new_users()
{
global $user_prefix, $db;
$Today = getdate();
$month = $Today[month];
$mday = $Today[mday];
$year = $Today[year];
$pmonth = $Today[month];
$pmday = $Today[mday];
$pmday = $mday - 1;
$pyear = $Today[year];
if ($pmonth == "January") $pmonth = 1;
elseif ($pmonth == "February") $pmonth = 2;
elseif ($pmonth == "March") $pmonth = 3;
elseif ($pmonth == "April") $pmonth = 4;
elseif ($pmonth == "May") $pmonth = 5;
elseif ($pmonth == "June") $pmonth = 6;
elseif ($pmonth == "July") $pmonth = 7;
elseif ($pmonth == "August") $pmonth = 8;
elseif ($pmonth == "September") $pmonth = 9;
elseif ($pmonth == "October") $pmonth = 10;
elseif ($pmonth == "November") $pmonth = 11;
elseif ($pmonth == "December") $pmonth = 12;
$test = mktime (0, 0, 0, $pmonth, $pmday, $pyear, 1);
$curDate2 = "%".$month[0].$month[1].$month[2]."%".$mday."%".$year."%";
$preday = strftime ("%d",$test);
$premonth = strftime ("%B",$test);
$preyear = strftime ("%Y",$test);
$curDateP = "%".$premonth[0].$premonth[1].$premonth[2]."%".$preday."%".$preyear."%";
$sql = "SELECT * FROM ".$user_prefix."_users WHERE user_regdate LIKE '$curDate2'";
$result = $db->sql_query($sql);
$userCount[1] = $db->sql_numrows($result);
$sql = "SELECT * FROM ".$user_prefix."_users WHERE user_regdate LIKE '$curDateP'";
$result = $db->sql_query($sql);
$userCount[2] = $db->sql_numrows($result);
return $userCount;
}
function num_online()
{
global $prefix, $db;
$sql = "SELECT uname FROM ".$prefix."_session WHERE guest = 1";
$res = $db->sql_query($sql);
$online_num[0] = $db->sql_numrows($res);
$sql = "SELECT uname FROM ".$prefix."_session WHERE guest = 0";
$res = $db->sql_query($sql);
$online_num[1] = $db->sql_numrows($res);
$online_num[2] = $online_num[0] + $online_num[1];
return $online_num;
}
function whowhere()
{
global $user, $cookie, $prefix, $db, $name;
cookiedecode($user);
$ip = $_SERVER["REMOTE_ADDR"];
$url = $_SERVER["REQUEST_URI"];
$uname = $cookie[1];
if(!isset($uname))
{
$uname = "$ip";
$guest = 1;
}
$past = time()-900;
$sql = "DELETE FROM ".$prefix."_userinfo_where WHERE time < $past";
$db->sql_query($sql);
$sql = "SELECT time FROM ".$prefix."_userinfo_where WHERE username='$uname'";
$result = $db->sql_query($sql);
$ctime = time();
$sql_a = "SELECT * FROM ".$prefix."_modules WHERE title = '$name'";
$result_a = $db->sql_query($sql_a);
$row_a = $db->sql_fetchrow($result_a);
if ($row = $db->sql_fetchrow($result))
{
$sql = "UPDATE ".$prefix."_userinfo_where SET username = '$uname', time = '$ctime', host_addr = '$ip', guest = '$guest' , module = '$row_a[custom_title]', url = '$url' WHERE username = '$uname'";
$db->sql_query($sql);
}
else
{
$sql = "INSERT INTO ".$prefix."_userinfo_where (username, time, host_addr, guest,module,url) VALUES ('$uname', '$ctime', '$ip', '$guest','$row_a[custom_title]','$url')";
$db->sql_query($sql);
}
}
function adminonline()
{
global $admin, $prefix, $db;
if(!is_array($admin))
{
$admin = base64_decode($admin);
$admin = explode(":", $admin);
$uname = "$admin[0]";
$pwd = "$admin[1]";
}
else
{
$uname = "$admin[0]";
$pwd = "$admin[1]";
}
$past = time()-900;
$sql = "DELETE FROM ".$prefix."_userinfo_admin WHERE time < $past";
$db->sql_query($sql);
$sql = "SELECT * FROM ".$prefix."_userinfo_admin WHERE uname='$uname'";
$result = $db->sql_query($sql);
if(is_admin($admin))
{
$ctime = time();
if ($row = $db->sql_fetchrow($result))
{
$sql = "UPDATE ".$prefix."_userinfo_admin SET uname='$uname', time='$ctime' WHERE uname='$uname'";
$db->sql_query($sql);
}
else
{
$sql = "INSERT INTO ".$prefix."_userinfo_admin (uname, time) VALUES ('$uname', '$ctime')";
$db->sql_query($sql);
}
}
}
function check_pms()
{
global $prefix, $db, $user_prefix, $user;
$userinfo = getusrinfo($user);
$uid = $userinfo[user_id];
$pms[0] = $db->sql_numrows($db->sql_query("SELECT privmsgs_to_userid FROM $prefix"._bbprivmsgs." WHERE privmsgs_to_userid='$uid' AND (privmsgs_type='5' OR privmsgs_type='1')"));
$pms[1] = $db->sql_numrows($db->sql_query("SELECT privmsgs_to_userid FROM $prefix"._bbprivmsgs." WHERE privmsgs_to_userid='$uid' AND privmsgs_type='0'"));
return $pms;
}
function displayTime($sec)
{
$minutes = floor($sec / 60);
$seconds = $sec % 60;
if ($minutes == 0)
{
return $seconds . _SEC;
}
return $minutes."&#039".$seconds.""";
}
function who_where()
{
global $prefix, $db;
$return = "";
$who_online[0] = "";
$who_online[1] = "";
$num[0] = 1;
$num[1] = 1;
$result = $db->sql_query("select username, guest, module, url, UNIX_TIMESTAMP(now())-time AS time from ".$prefix."_userinfo_where order by username");
$member_online_num = $db->sql_numrows($result);
while($session = $db->sql_fetchrow($result))
{
if(eregi("admin.php", $session[url]))
{
$session[module] = "Admin";
$session[url] = "index.html";
}
$guest = $session["guest"];
if ($guest == 0)
{
$ttt = "<A HREF=\"userinfo-.html$session[username]\">$session[username]</a> >";
}
if($num[$guest] < 10)
{
$who_online[$guest] .= "0";
}
$who_online[$guest] .= "$num[$guest]: $ttt <a href=\"$session[url]\" target=\"_blank\">$session[module]</a> \n";
$num[$guest]++;
}
if($who_online[0] != "")
{
$num[0]++;
$content .= "<img src=\"images/userinfo/members.gif\"> "._BMEM.": $who_online[0]";
if(count($who_online[0]) == 0) $content .= " ";
}
if($who_online[1] != "")
{
$content .= "<img src=\"images/userinfo/visitors.gif\"> "._BVIS.": $who_online[1]";
}
return $content;
}
function staff_online()
{
global $prefix, $db, $user_prefix;
$num = 0;
$return .= "\n<hr>\n<img src=\"images/userinfo/group-3.gif\" height=\"14\" width=\"17\"> Staff Online: ";
$sql = "SELECT uname FROM ".$prefix."_userinfo_admin";
$result = $db->sql_query($sql);
if($db->sql_numrows($result) == "0")
{
$return .= " No staff members are online!";
}
else
{
while($row = $db->sql_fetchrow($result))
{
$num++;
if ($num < 10)
{
$return .= "0";
}
$return .= "$num:\n ";
$sql_a = "SELECT * FROM ".$user_prefix."_users WHERE username = '$row[uname]'";
$result_a = $db->sql_query($sql_a);
if($db->sql_numrows($result_a) == 1)
{
$row_a = $db->sql_fetchrow($result_a);
if(is_active("Private_Messages"))
{
$return .= "<a href=\"messages-.html$row_a[user_id]\"><img src=\"images/userinfo/email-y.gif\" border=0 alt=\"Send a private message to $row_a[username]\"></a>";
}
$return .= " <a href=\"userinfo-.html$row[uname]\" title=\"View The Userinfo For $row[uname]\">$row_a[username]</a> ";
}
else $return .= "$row[uname] ";
}
}
return $return;
}
whowhere();
adminonline();
global $user;
if(is_user($user))
{
$userinfo = getusrinfo($user);
$content .= " <img src=\"images/userinfo/group-4.gif\" height=\"14\" width=\"17\"> "._BWEL.", $userinfo[username]. (<a href=\"modules.php?name=Your_Account&op=logout\">"._LOGOUT."</a>)\n<hr>\n";
if(is_active("Private_Messages"))
{
$pm = check_pms();
$content .= "<img src=\"images/userinfo/email-y.gif\" height=\"10\" width=\"14\"> <a href=\"modules.php?name=Private_Messages\">"._BPM."</a> \n";
$content .= "<img src=\"images/userinfo/email-r.gif\" height=\"10\" width=\"14\"> "._BUNREAD.": $pm[0] \n";
$content .= "<img src=\"images/userinfo/email-g.gif\" height=\"10\" width=\"14\"> "._BREAD.": $pm[1] \n<hr>\n";
}
}
else
{
$content .= "<form action=\"modules.php?name=Your_Account\" method=\"post\">";
mt_srand ((double)microtime()*1000000);
$maxran = 1000000;
$random_num = mt_rand(0, $maxran);
$content .= "<img src=\"images/userinfo/group-4.gif\" height=\"14\" width=\"17\"> "._BWEL.", $anonymous\n<hr>";
$content .= "<form action=\"modules.php?name=Your_Account\" method=\"post\">\n";
$content .= ""._NICKNAME.": <input type=\"text\" name=\"username\" size=\"10\" maxlength=\"25\"> \n";
$content .= ""._PASSWORD.": <input type=\"password\" name=\"user_password\" size=\"10\" maxlength=\"20\"> \n";
if (extension_loaded("gd") AND ($gfx_chk == 2 OR $gfx_chk == 4 OR $gfx_chk == 5 OR $gfx_chk == 7))
{
$content .= ""._SECURITYCODE.": <img src=\"modules.php?name=Your_Account&op=gfx&random_num=$random_num\" border=\"1\" alt=\""._SECURITYCODE."\" title=\""._SECURITYCODE."\"> \n"
.""._TYPESECCODE.": <input type=\"text\" NAME=\"gfx_check\" SIZE=\"7\" MAXLENGTH=\"6\"> \n"
."<input type=\"hidden\" name=\"random_num\" value=\"$random_num\"> \n";
}
$content .= "<input type=\"hidden\" name=\"op\" value=\"login\">\n"
."<input type=\"submit\" value=\""._LOGIN."\">\n"
."(<a href=\"modules.php?name=Your_Account&op=new_user\">"._BREG."</a>)</form>\n";
}
$last = new_users();
$onli = num_online();
$content .= "<img src=\"images/userinfo/group-2.gif\" height=\"14\" width=\"17\"> "._BMEMP.": \n";
$content .= "<img src=\"images/userinfo/ur-moderator.gif\" height=\"14\" width=\"17\"> "._BLATEST.": <A HREF=\"modules.php?name=Your_Account&op=userinfo&username=".last_user()."\">".last_user()."</a> \n";
$content .= "<img src=\"images/userinfo/ur-author.gif\" height=\"14\" width=\"17\"> "._BTD.": ".$last[1]." \n";
$content .= "<img src=\"images/userinfo/ur-admin.gif\" height=\"14\" width=\"17\"> "._BYD.": ".$last[2]." \n";
$content .= "<img src=\"images/userinfo/ur-guest.gif\" height=\"14\" width=\"17\"> "._BOVER.": ".(numusers() - 1)." \n<hr>\n";
$content .= "<img src=\"images/userinfo/group-3.gif\" height=\"14\" width=\"17\"> "._BVISIT.":\n \n";
$content .= "<img src=\"images/userinfo/ur-anony.gif\" height=\"14\" width=\"17\"> "._BVIS.": ".$onli[0]." \n";
$content .= "<img src=\"images/userinfo/ur-member.gif\" height=\"14\" width=\"17\"> "._BMEM.": ".$onli[1]." \n";
$content .= "<img src=\"images/userinfo/ur-registered.gif\" height=\"14\" width=\"17\"> "._BTT.": ".$onli[2]." \n";
if ($onli[1] > 0)
{
$whonline = who_online();
$content .= "<hr><img src=\"images/userinfo/group-1.gif\" height=\"14\" width=\"17\"> "._BON.": ".$whonline;
}
$content .= "<hr><img src=\"images/userinfo/group-4.gif\" height=\"14\" width=\"17\"> Who Is Where: ";
$info = who_where();
$content .= $info;
$info = staff_online();
$content .= $info;
?>

What does the subscriptions table look like?

Oh thank you telli !

Here is the table from phpmyadmin for the subscription table!

#
# Table structure for table `nuke_subscriptions`
#

CREATE TABLE `nuke_subscriptions` (
`id` int(10) NOT NULL auto_increment,
`userid` int(10) default '0',
`subscription_expire` varchar(50) NOT NULL default '',
KEY `id` (`id`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `nuke_subscriptions`
#

Hello Telli

Would it be easier for you if I switched to the czuser info block, after looking at your block I do like some of the features.

I think i may switch over to your block but I do have a question, will it display Admin(s) and Mod(s) and whats the exact version your using here!

I pasted the tables from my phpmyadmin above to the subscription table, I hope this helps.

Xtrax!

Do you want me to add this to the CZUserInfo V5 Universal?

Actually if we can still do my prevoius block as the CZuser info block doesnt display were users or visitors are on your site, it would be appreciated I'll even gladly pay you for your time just quote me a price and I do appreciate your help!

xtrax