Forum Preview

02/07/04 10:54am

FreakWorld

Anonymous

I use this code on my site.
But I made a new site, and for some reason it's not working. I tryed making it by hand.
Copying my lib-custom over from the old site.
And even just pasting it in the lib-custom.
Is there a change in the new code of something that will stop this from working?
How do I get it to work now?

Text Formatted Code

function phpblock_ListUsers()

{

    global $_CONF;

    $list = "";

    $quer = mysql_query ("SELECT uid, username, photo, grp_id, grp_name, grp_descr FROM gl_groups, gl_group_assignments, gl_users WHERE ug_main_grp_id = grp_id AND gl_users.uid = gl_group_assignments.ug_uid AND grp_id = 38");

    while ($line = mysql_fetch_array($quer)){

    $list = $list.'<a href="'.$_CONF["site_url"].'/users.php?mode=profile&uid='.$line["uid"].'">'.$line["username"];

    if ($line["photo"] != ""){

    $list = $list.' </a><img src="'.$_CONF["layout_url"].'/images/smallcamera.gif">';

    }

    $list = $list.'<br>';

    }

return $list;

}

02/07/04 11:26am

Status: offline

Dirk

Site Admin

Admin

Registered: 01/12/02

Posts: 13073

There's a hard-coded "grp_id = 38" in your code. Do you have a group on your new site that has a group id of 38?

bye, Dirk

02/07/04 01:49pm

FreakWorld

Anonymous

yes
What I was doing was make a roster of a set group.

02/07/04 01:51pm

FreakWorld

Anonymous

here is the error.

Text Formatted Code
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site35/fst/home/nsdf/system/lib-custom.php on line 267

02/08/04 01:51pm

FreakWorld

Anonymous

any Ideas on this yet?
I realy need this to work.

02/08/04 02:03pm

Status: offline

Turias

Forum User

Full Member

Registered: 10/20/03

Posts: 807

Why don't you try that query in phpMyAdmin and see what you get?

02/08/04 08:56pm

FreakWorld

Anonymous

I really don't know how.
But I did verify the ID with phpMyAdmin.
And the code works on my old site.
But I have not tried adding a new member to that group on my old site sense the last update.

02/08/04 09:31pm

FreakWorld

Anonymous

I am so stuped.
I forgot I changed the gl to ns.
So in that code I changed every were the gl is to ns.
I am not geting an error.
But now it's not showing any one.
And not showing a box.
*Bangs head*
Why O why is this not showing the people in that group!!!!

Here is the changes.
Till me if I am doing yet something ealse stuped.

Text Formatted Code
function phpblock_cow()

{

    global $_CONF;

    $list = "";

    $quer = mysql_query ("SELECT uid, username, photo, grp_id, grp_name, grp_descr FROM ns_groups, ns_group_assignments, ns_users WHERE ug_main_grp_id = grp_id AND ns_users.uid = ns_group_assignments.ug_uid AND grp_id = 38");

    while ($line = mysql_fetch_array($quer)){

    $list = $list.'<a href="'.$_CONF["site_url"].'/users.php?mode=profile&uid='.$line["uid"].'">'.$line["username"];

    if ($line["photo"] != ""){

    $list = $list.' </a><img src="'.$_CONF["layout_url"].'/images/smallcamera.gif">';

    }

    $list = $list.'<br>';

    }

return $list;

}