List Subscribers Mod

Lieutenant Joined: Aug 23, 2003 Posts: 195

Forgive me if I put this in the wrong spot and feel free to move it if needed,

I'm fairley new to this php-nuke and I started working on my first mod to display subscribed users,

The problem is I'm not experienced enough to figure this one out and its drive me crazyyyy...

What i'm try'in to do is grab just the subscribed users and of course have it linked to their account profile,

here's what i got so far.....

Code:

<?php
if (!eregi("modules.php", $_SERVER['SCRIPT_NAME'])) {
header("Location: ../../../index.php");
die ();
}
require_once("mainfile.php");
$pagetitle = "Premium Members";
global $prefix, $db;
include("header.php");
OpenTable();
$query="SELECT id, userid, subscription_expire from $prefix"._subscriptions." ORDER BY id DESC";
$result=mysql_query($query);
while(list($id, $userid, $subscription_expire) = mysql_fetch_row($result)) {
echo "- <A HREF=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$userid\" title=\"Welcome $username\">$username</a><br />\n";
}
CloseTable();
include("footer.php");
?>

So far the problem with this is it just pulls the userid and I cant seem to figure out how to display the "username," any help would be appreciated.

xtrax... Sad

Site Admin Joined: Aug 17, 2003 Posts: 12482

You have to add your query to grab the username from the users table

Lieutenant Joined: Aug 23, 2003 Posts: 195

Thanks Evader for replying..

Thats just it I don't know how to do that as the username's aren't stored in the subscriptions table...instead its the users id..

How can I get the id to display as the username, and what changes do i need to adhear to the query above..

xtrax

Lieutenant Joined: Aug 23, 2003 Posts: 195

*BUMP*

Anyone have an idea ?

Posted: Sat Mar 04, 2006 10:24 am

Subscribers Block which can be turned into a module
Details and screenshot at
http://www.westernstudios.net/web/downloads-100.html