[pein87]

I/m working on a mod and I posted in the wrong section. What I'm trying to do is get the socialgroup leader, and member count from the socialgroups and then display them in an small div based layout on a new page. Its for RPG on my site. I was wondering how to go about doing this as my code didnt display anything.

PHP Code:

$groupInfo = $vbulletin->db->query_read("SELECT socialgroupcatagoryid, name, creatoruserid, members FROM ". THREAD_PREFIX. " `socialgroup`");
$groupArray = $vbulletin->db->fetch_array($groupInfo);
$groupLeader = $groupArray['creatoruserid'];
$groupMembers = $groupArray['members'];
sprintf($groupLeader);
sprintf($groupMembers); 


I added that to a template to see if it would work and it didnt. I want to only display them if there in a certain catagory and have them show the creators user name and member count. I tried to add the code into the php file but I got DB errors saying databaseName.thread_prefix does not exist.
I wanted to create a tag/badge for each group showing there leader and member count while haveing the images look difrrent based on the groups name.