Guild Officers Block

Nuke Cadet Joined: Nov 03, 2006 Posts: 8

I have started fiddling with blocks.. I made a simple one that just allows me to manually edit it and add the Officers of the Guild. Code below..

Code:

<?php

if ( !defined('BLOCK_FILE') ) {
Header("Location: ../index.php");
die();
}

global $prefix, $db, $admin, $language, $currentlang;

$ThemeSel = get_theme();
if (file_exists("themes/$ThemeSel/module.php")) {
include("themes/".$ThemeSel."/module.php");
if (is_active($default_module) AND file_exists("modules/$default_module/index.php")) {
$def_module = $default_module;
} else {
$def_module = "";
}
}

$content .= "<big>·</big> Aliaras/Uzy \n";
$content .= "<big>·</big> AlleyWoW \n";
$content .= "<big>·</big> Arriah \n";
$content .= "<big>·</big> Azynov \n";
$content .= "<big>·</big> Coldane \n";
$content .= "<big>·</big> Coopdaloop \n";
$content .= "<big>·</big> Dreamketchr \n";
$content .= "<big>·</big> Drolthaf \n";
$content .= "<big>·</big> Gicowboy \n";
$content .= "<big>·</big> Heavymedal \n";
$content .= "<big>·</big> Naud \n";
$content .= "<big>·</big> Phlutia \n";
$content .= "<big>·</big> Wrathidius \n";

?>

My question is this. I dont know much about PHP, really snaggin this from here and there and fiddling till it works. I would like to set this block to where when it loads. It looks at the user database (im assuming thats kept in the MySQL database?) and anyone that is marked "Admin" is added to this list in the same format as above. The way its set is all Admin's on this site are Officers of the Guild in WOW. How would I do that? I dont even know where to find "Account" type in DB in MySQL.

Nuke Cadet Joined: Nov 03, 2006 Posts: 8

Anyone? I'd also like ot make it change their color if they are online at the moment.

I could really use help here if anyone can help me Sad

Site Admin Joined: Aug 17, 2003 Posts: 12342

All the admins are in the "authors" table. You just need to query on that table

If you don't know how to do that, I suggest reading a good PHP/MySQL tutorial before diving into that code