Go Back   Novahq.net Forum > Novahq.net Specific > Feedback / Novahq.net Support
Reload this Page Roster
FAQ Community Calendar Today's Posts Search

Feedback / Novahq.net Support Feedback & Questions for the staff

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 03-29-2004, 12:49 PM
Stu is offline Stu
Resident Member

Join Date: Aug 2003
Posts: 3,319
Roster
Hey all, i wanna edit the roster so it says MSN insted of ICQ. I tried this, but it stayed as ICQ. Heres the code i have:
Code:
<?
##################Admin Add Player####################
If ($global[cmd]=="admin_add") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");

If ($_POST['doadd']) {
$name=$_POST["name"];
$tag=$_POST["tag"];
$icq=$_POST["msn"];
$pemail=$_POST["pemail"];
$role=$_POST["role"];
$status=$_POST["status"];

If (!$name) {
$error="1";
$error_text .= "Please enter a player name!<br />";
}

If ($error=="1") {
$show_errors = "$error_text";
} Else {
mysql_query("INSERT INTO $global[pre]_roster VALUES ('NULL', '$name', '$tag', '$icq', '$pemail', '$role', '$status')") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
$newid=mysql_fetch_array(mysql_query("SELECT id FROM $global[pre]_roster ORDER BY id DESC LIMIT 1"));
mysql_query("INSERT INTO $global[pre]_profiles VALUES ('$newid[0]', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', '')") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
Echo("<br /><div align=\"center\">Player Added!</div><br /><br />\n");
exit(ssibot());
}
}

Echo("<br />\n");
Echo("<table border=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\" class=\"reghead\"><b>Add Player</b></td>\n");
Echo("</tr>\n");
ShowErrors($show_errors);
Echo("<form method=\"POST\" action=\"./?view=roster&cmd=admin_add\">\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Name:</td>\n");
Echo("<td align=\"left\">&nbsp;<input type=\"text\" name=\"name\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Tag:</td>\n");
Echo("<td align=\"left\">&nbsp;<input type=\"text\" name=\"tag\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Msn:</td>\n");
Echo("<td align=\"left\">&nbsp;<input type=\"text\" name=\"icq\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Email:</td>\n");
Echo("<td align=\"left\">&nbsp;<input type=\"text\" name=\"pemail\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Role:</td>\n");
Echo("<td align=\"left\">&nbsp;<input type=\"text\" name=\"role\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Status:</td>\n");
Echo("<td align=\"left\">&nbsp;\n");
Echo("<select size=\"1\" name=\"status\" class=\"input\">\n");
Echo("<option value=\"active\">Active</option>\n");
Echo("<option value=\"recrute\">New Recrute</option>\n");
Echo("<option value=\"inactive\">Inactive</option>\n");
Echo("</select>\n");
Echo("</td>\n");
Echo("</tr>\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\"><input type=\"submit\" value=\" Add Player \" name=\"doadd\" class=\"input\"> &nbsp; <input type=\"reset\" value=\" Reset \" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("</form>\n");
Echo("</table>\n");
Echo("<br />\n");

##################Admin Edit Player################################
} Elseif($global[cmd]=="admin_edit") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");

$id = $_GET["id"];

If ($_POST['doedit']) {

$name=$_POST["name"];
$tag=$_POST["tag"];
$icq=$_POST["msn"];
$pemail=$_POST["pemail"];
$role=$_POST["role"];
$status=$_POST["status"];

If (!$name) {
$error="1";
$error_text .= "Please enter a player name!<br />";
}
If ($error=="1") {
$show_errors = "$error_text";
} Else {
mysql_query("UPDATE $global[pre]_roster SET name='$name', tag='$tag', msn='$icq', pemail='$pemail', role='$role', status='$status' WHERE id='$id'") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
Echo("<br /><div align=\"center\">Player Updated!</div>\n");
}
}

$p=mysql_fetch_array(mysql_query("SELECT * FROM $global[pre]_roster WHERE id='$id'"));
$name=htmlspecialchars(stripslashes($p["name"]));
$tag=htmlspecialchars(stripslashes($p["tag"]));
$icq=$p["msn"];
$pemail=$p["pemail"];
$role=stripslashes($p["role"]);
$status=$p["status"];

Echo("<br />\n");
Echo("<table border=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\" class=\"reghead\"><b>Edit Player</b></td>\n");
Echo("</tr>\n");
ShowErrors($show_errors);
Echo("<form method=\"POST\" action=\"./?view=roster&cmd=admin_edit&id=$id\">\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Name:</td>\n");
Echo("<td align=\"left\">&nbsp;<input type=\"text\" name=\"name\" size=\"40\" value=\"$name\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Tag:</td>\n");
Echo("<td align=\"left\">&nbsp;<input type=\"text\" name=\"tag\" size=\"40\" value=\"$tag\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">ICQ Number:</td>\n");
Echo("<td align=\"left\">&nbsp;<input type=\"text\" name=\"icq\" size=\"40\" value=\"$icq\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Email:</td>\n");
Echo("<td align=\"left\">&nbsp;<input type=\"text\" name=\"pemail\" size=\"40\" value=\"$pemail\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Role:</td>\n");
Echo("<td align=\"left\">&nbsp;<input type=\"text\" name=\"role\" size=\"40\" value=\"$role\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Status:</td>\n");
Echo("<td align=\"left\">&nbsp;\n");
Echo("<select size=\"1\" name=\"status\" class=\"input\">\n");
Echo("<option value=\"active\""); If($status=="active"){Echo(" selected");}Echo(">Active Member</option>\n");
Echo("<option value=\"recrute\""); If($status=="recrute"){Echo(" selected");}Echo(">New Recrute</option>\n");
Echo("<option value=\"inactive\""); If($status=="inactive"){Echo(" selected");}Echo(">Inactive Member</option>\n");
Echo("</select>\n");
Echo("</td>\n");
Echo("</tr>\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\"><input type=\"submit\" value=\" Edit Player \" name=\"doedit\" class=\"input\"> &nbsp; <input type=\"reset\" value=\" Reset \" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("</form>\n");
Echo("</table>\n");
Echo("<br />\n");

##################Admin Delete Player################################
} Elseif($global[cmd]=="admin_delete") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");

$id=$_GET["id"];
$name=$_GET["name"];

If ($_POST['dodelete']) {
mysql_query("DELETE FROM $global[pre]_roster WHERE id='$id'") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
mysql_query("DELETE FROM $global[pre]_profiles WHERE pid='$id'") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
Echo("<br /><div align=\"center\">Player Deleted!</div><br /><br />\n");
exit(ssibot());
}

Echo("<br />\n");
Echo("<div align=\"center\">\n");
Echo("Are you sure you want to delete $name?<br />\n");
Echo("<table border=\"0\">\n");
Echo("<tr>\n");
Echo("<td><form method=\"POST\" action=\"./?view=roster&cmd=admin_delete&id=$id\"><input type=\"submit\" value=\"Yes Delete Player!\" name=\"dodelete\" class=\"input\"></form></td>\n");
Echo("<td><form method=\"POST\" action=\"./?view=roster&cmd=admin_main\"><input type=\"submit\" value=\"No, Don't Delete!\" name=\"reset\" class=\"input\"></form></td><br /><br />\n");
Echo("</tr>\n");
Echo("</table>\n");
Echo("</div>\n");
Echo("<br />\n");

##################Admin Main Page################################
} Elseif($global[cmd]=="admin_main") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");
Echo("<br />\n<table border=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td colspan=\"4\" align=\"center\"><b>Active Members</b></td>\n");
Echo("</tr>\n");
Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td><b>Player Name</b></td><td><b>Edit Player</b></td><td><b>Delete Player</b></td><td><b>Edit Profile</b></td>\n");
Echo("</tr>\n");

//Active

$active=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='active' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
while($a=mysql_fetch_array($active)) {

$id=$a["id"];
$name=htmlspecialchars(stripslashes($a["name"]));

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td>$name</td><td><a href=\"./?view=roster&cmd=admin_edit&id=$id\">Edit</a></td><td><a href=\"./?view=roster&cmd=admin_delete&id=$id&name=$name\">Delete</a></td><td><a href=\"./?view=profile&cmd=admin_main&pid=$id&playername=$name\">Edit Profile</a></td>\n");
Echo("</tr>\n");
}

//Get Recrutes

$recrute=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='recrute' ORDER BY id ASC");
$numr=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='recrute' ORDER BY id ASC"));

If ($numr!="0"){

Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td colspan=\"4\" align=\"center\"><b>Recrutes</b></td>\n");
Echo("</tr>\n");

while($r=mysql_fetch_array($recrute)) {
$id=$r["id"];
$name=htmlspecialchars(stripslashes($r["name"]));

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td>$name</td><td><a href=\"./?view=roster&cmd=admin_edit&id=$id\">Edit</a></td><td><a href=\"./?view=roster&cmd=admin_delete&id=$id&name=$name\">Delete</a></td><td><a href=\"./?view=profile&cmd=admin_main&pid=$id&playername=$name\">Edit Profile</a></td>\n");
Echo("</tr>\n");
}
}

//Get Inactive

$inactive=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='inactive' ORDER BY id ASC");
$numi=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='inactive' ORDER BY id ASC"));

If ($numi!="0"){

Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td colspan=\"4\" align=\"center\"><b>Inactive Members</b></td>\n");
Echo("</tr>\n");

while($i=mysql_fetch_array($inactive)) {
$id=$i["id"];
$name=htmlspecialchars(stripslashes($i["name"]));

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td>$name</td><td><a href=\"./?view=roster&cmd=admin_edit&id=$id\">Edit</a></td><td><a href=\"./?view=roster&cmd=admin_delete&id=$id&name=$name\">Delete</a></td><td><a href=\"./?view=profile&cmd=admin_main&pid=$id&playername=$name\">Edit Profile</a></td>\n");
Echo("</tr>\n");
}
}
Echo("</table>\n");
Echo("<br />\n");
##################View Roster################################
} Else {

Echo("<div align=\"center\">Click name for profile.</div>\n");
Echo("<br />\n");
Echo("<table border=\"1\" cellpadding=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"5\"><b>Active Members</b></td>\n");
Echo("</tr>\n");
Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td width=\"250\" align=\"center\"><b>Name</b></td>\n");
Echo("<td width=\"80\" align=\"center\"><b>Tag</b></td>\n");
Echo("<td width=\"143\" align=\"center\"><b>ICQ</b></td>\n");
Echo("<td width=\"338\" align=\"center\"><b>Email</b></td>\n");
Echo("<td width=\"175\" align=\"center\"><b>Role</b></td>\n");
Echo("</tr>\n");

//Actice

$active=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='active' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
while($a=mysql_fetch_array($active)) {

$id=$a["id"];
$name=htmlspecialchars(stripslashes($a["name"]));
$tag=htmlspecialchars(stripslashes($a["tag"]));
$icq=$a["msn"];
$pemail=$a["pemail"];
$role=stripslashes($a["role"]);

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td width=\"250\">&nbsp; <a href=\"./?view=profile&pid=$id\">$name</a></td>\n");
Echo("<td width=\"80\" align=\"center\">$tag</td>\n");
Echo("<td width=\"143\" align=\"center\"><a href=\"http://web.icq.com/whitepages/add_me?uin=$icq&action=add\">$icq</a></td>\n");
Echo("<td width=\"338\" align=\"center\"><a href=\"mailto:$pemail\">$pemail</a></td>\n");
Echo("<td width=\"175\" align=\"center\">$role</td>\n");
Echo("</tr>\n");
}

//Recrute

$numr=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='recrute'"));
$recrute=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='recrute' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());

If ($numr!="0"){

Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"5\"><b>New Recrutes</b></td>\n");
Echo("</tr>\n");

while($r=mysql_fetch_array($recrute)) {

$id=$r["id"];
$name=htmlspecialchars(stripslashes($r["name"]));
$tag=htmlspecialchars(stripslashes($r["tag"]));
$icq=$r["msn"];
$pemail=$r["pemail"];
$role=stripslashes($r["role"]);

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td width=\"250\">&nbsp; <a href=\"./?view=profile&pid=$id\">$name</a></td>\n");
Echo("<td width=\"80\" align=\"center\">$tag</td>\n");
Echo("<td width=\"143\" align=\"center\"><a href=\"http://web.icq.com/whitepages/add_me?uin=$icq&action=add\">$icq</a></td>\n");
Echo("<td width=\"338\" align=\"center\"><a href=\"mailto:$pemail\">$pemail</a></td>\n");
Echo("<td width=\"175\" align=\"center\">$role</td>\n");
Echo("</tr>\n");
}
}

// Inactive

$numi=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='inactive'"));
$inactive=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='inactive' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());

If ($numi!="0"){

Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"5\"><b>Inactive Members</b></td>\n");
Echo("</tr>\n");

while($i=mysql_fetch_array($inactive)) {

$id=$i["id"];
$name=htmlspecialchars(stripslashes($i["name"]));
$tag=htmlspecialchars(stripslashes($i["tag"]));
$icq=$i["msn"];
$pemail=$i["pemail"];
$role=stripslashes($i["role"]);

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td width=\"250\">&nbsp; <a href=\"./?view=profile&pid=$id\">$name</a></td>\n");
Echo("<td width=\"80\" align=\"center\">$tag</td>\n");
Echo("<td width=\"143\" align=\"center\"><a href=\"http://web.icq.com/whitepages/add_me?uin=$icq&action=add\">$icq</a></td>\n");
Echo("<td width=\"338\" align=\"center\"><a href=\"mailto:$pemail\">$pemail</a></td>\n");
Echo("<td width=\"175\" align=\"center\">$role</td>\n");
Echo("</tr>\n");
}
}

Echo("</table>\n");
Echo("<br />\n");
}
?>
Can someone please edit that code, and reply to what it'll be change it to MSN.

Oh yeh, the squad site is www.nerds-uk.tk , comments on the theme i made please
Reply With Quote
  #2  
Old 03-30-2004, 06:02 PM
Scott is offline Scott
Scott's Avatar
AKA. Panther

Join Date: Sep 2001
Location: Minneapolis, MN
Posts: 10,927
replace with:


<?
##################Admin Add Player####################
If ($global[cmd]=="admin_add") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");

If ($_POST['doadd']) {
$name=$_POST["name"];
$tag=$_POST["tag"];
$icq=$_POST["icq"];
$pemail=$_POST["pemail"];
$role=$_POST["role"];
$status=$_POST["status"];

If (!$name) {
$error="1";
$error_text .= "Please enter a player name!<br />";
}

If ($error=="1") {
$show_errors = "$error_text";
} Else {
mysql_query("INSERT INTO $global[pre]_roster VALUES ('NULL', '$name', '$tag', '$icq', '$pemail', '$role', '$status')") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
$newid=mysql_fetch_array(mysql_query("SELECT id FROM $global[pre]_roster ORDER BY id DESC LIMIT 1"));
mysql_query("INSERT INTO $global[pre]_profiles VALUES ('$newid[0]', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', '')") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
Echo("<br /><div align=\"center\">Player Added!</div><br /><br />\n");
exit(ssibot());
}
}

Echo("<br />\n");
Echo("<table border=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\" class=\"reghead\"><b>Add Player</b></td>\n");
Echo("</tr>\n");
ShowErrors($show_errors);
Echo("<form method=\"POST\" action=\"./?view=roster&cmd=admin_add\">\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Name:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"name\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Tag:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"tag\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Msn:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"icq\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Email:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"pemail\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Role:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"role\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Status:</td>\n");
Echo("<td align=\"left\"> \n");
Echo("<select size=\"1\" name=\"status\" class=\"input\">\n");
Echo("<option value=\"active\">Active</option>\n");
Echo("<option value=\"recrute\">New Recrute</option>\n");
Echo("<option value=\"inactive\">Inactive</option>\n");
Echo("</select>\n");
Echo("</td>\n");
Echo("</tr>\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\"><input type=\"submit\" value=\" Add Player \" name=\"doadd\" class=\"input\"> <input type=\"reset\" value=\" Reset \" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("</form>\n");
Echo("</table>\n");
Echo("<br />\n");

##################Admin Edit Player################################
} Elseif($global[cmd]=="admin_edit") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");

$id = $_GET["id"];

If ($_POST['doedit']) {

$name=$_POST["name"];
$tag=$_POST["tag"];
$icq=$_POST["icq"];
$pemail=$_POST["pemail"];
$role=$_POST["role"];
$status=$_POST["status"];

If (!$name) {
$error="1";
$error_text .= "Please enter a player name!<br />";
}
If ($error=="1") {
$show_errors = "$error_text";
} Else {
mysql_query("UPDATE $global[pre]_roster SET name='$name', tag='$tag', icq='$icq', pemail='$pemail', role='$role', status='$status' WHERE id='$id'") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
Echo("<br /><div align=\"center\">Player Updated!</div>\n");
}
}

$p=mysql_fetch_array(mysql_query("SELECT * FROM $global[pre]_roster WHERE id='$id'"));
$name=htmlspecialchars(stripslashes($p["name"]));
$tag=htmlspecialchars(stripslashes($p["tag"]));
$icq=$p["icq"];
$pemail=$p["pemail"];
$role=stripslashes($p["role"]);
$status=$p["status"];

Echo("<br />\n");
Echo("<table border=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\" class=\"reghead\"><b>Edit Player</b></td>\n");
Echo("</tr>\n");
ShowErrors($show_errors);
Echo("<form method=\"POST\" action=\"./?view=roster&cmd=admin_edit&id=$id\">\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Name:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"name\" size=\"40\" value=\"$name\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Tag:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"tag\" size=\"40\" value=\"$tag\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">MSN:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"icq\" size=\"40\" value=\"$icq\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Email:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"pemail\" size=\"40\" value=\"$pemail\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Role:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"role\" size=\"40\" value=\"$role\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Status:</td>\n");
Echo("<td align=\"left\"> \n");
Echo("<select size=\"1\" name=\"status\" class=\"input\">\n");
Echo("<option value=\"active\""); If($status=="active"){Echo(" selected");}Echo(">Active Member</option>\n");
Echo("<option value=\"recrute\""); If($status=="recrute"){Echo(" selected");}Echo(">New Recrute</option>\n");
Echo("<option value=\"inactive\""); If($status=="inactive"){Echo(" selected");}Echo(">Inactive Member</option>\n");
Echo("</select>\n");
Echo("</td>\n");
Echo("</tr>\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\"><input type=\"submit\" value=\" Edit Player \" name=\"doedit\" class=\"input\"> <input type=\"reset\" value=\" Reset \" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("</form>\n");
Echo("</table>\n");
Echo("<br />\n");

##################Admin Delete Player################################
} Elseif($global[cmd]=="admin_delete") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");

$id=$_GET["id"];
$name=$_GET["name"];

If ($_POST['dodelete']) {
mysql_query("DELETE FROM $global[pre]_roster WHERE id='$id'") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
mysql_query("DELETE FROM $global[pre]_profiles WHERE pid='$id'") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
Echo("<br /><div align=\"center\">Player Deleted!</div><br /><br />\n");
exit(ssibot());
}

Echo("<br />\n");
Echo("<div align=\"center\">\n");
Echo("Are you sure you want to delete $name?<br />\n");
Echo("<table border=\"0\">\n");
Echo("<tr>\n");
Echo("<td><form method=\"POST\" action=\"./?view=roster&cmd=admin_delete&id=$id\"><input type=\"submit\" value=\"Yes Delete Player!\" name=\"dodelete\" class=\"input\"></form></td>\n");
Echo("<td><form method=\"POST\" action=\"./?view=roster&cmd=admin_main\"><input type=\"submit\" value=\"No, Don't Delete!\" name=\"reset\" class=\"input\"></form></td><br /><br />\n");
Echo("</tr>\n");
Echo("</table>\n");
Echo("</div>\n");
Echo("<br />\n");

##################Admin Main Page################################
} Elseif($global[cmd]=="admin_main") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");
Echo("<br />\n<table border=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td colspan=\"4\" align=\"center\"><b>Active Members</b></td>\n");
Echo("</tr>\n");
Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td><b>Player Name</b></td><td><b>Edit Player</b></td><td><b>Delete Player</b></td><td><b>Edit Profile</b></td>\n");
Echo("</tr>\n");

//Active

$active=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='active' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
while($a=mysql_fetch_array($active)) {

$id=$a["id"];
$name=htmlspecialchars(stripslashes($a["name"]));

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td>$name</td><td><a href=\"./?view=roster&cmd=admin_edit&id=$id\">Edit</a></td><td><a href=\"./?view=roster&cmd=admin_delete&id=$id&name=$name\"> Delete</a></td><td><a href=\"./?view=profile&cmd=admin_main&pid=$id&playername=$n ame\">Edit Profile</a></td>\n");
Echo("</tr>\n");
}

//Get Recrutes

$recrute=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='recrute' ORDER BY id ASC");
$numr=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='recrute' ORDER BY id ASC"));

If ($numr!="0"){

Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td colspan=\"4\" align=\"center\"><b>Recrutes</b></td>\n");
Echo("</tr>\n");

while($r=mysql_fetch_array($recrute)) {
$id=$r["id"];
$name=htmlspecialchars(stripslashes($r["name"]));

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td>$name</td><td><a href=\"./?view=roster&cmd=admin_edit&id=$id\">Edit</a></td><td><a href=\"./?view=roster&cmd=admin_delete&id=$id&name=$name\"> Delete</a></td><td><a href=\"./?view=profile&cmd=admin_main&pid=$id&playername=$n ame\">Edit Profile</a></td>\n");
Echo("</tr>\n");
}
}

//Get Inactive

$inactive=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='inactive' ORDER BY id ASC");
$numi=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='inactive' ORDER BY id ASC"));

If ($numi!="0"){

Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td colspan=\"4\" align=\"center\"><b>Inactive Members</b></td>\n");
Echo("</tr>\n");

while($i=mysql_fetch_array($inactive)) {
$id=$i["id"];
$name=htmlspecialchars(stripslashes($i["name"]));

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td>$name</td><td><a href=\"./?view=roster&cmd=admin_edit&id=$id\">Edit</a></td><td><a href=\"./?view=roster&cmd=admin_delete&id=$id&name=$name\"> Delete</a></td><td><a href=\"./?view=profile&cmd=admin_main&pid=$id&playername=$n ame\">Edit Profile</a></td>\n");
Echo("</tr>\n");
}
}
Echo("</table>\n");
Echo("<br />\n");
##################View Roster################################
} Else {

Echo("<div align=\"center\">Click name for profile.</div>\n");
Echo("<br />\n");
Echo("<table border=\"1\" cellpadding=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"5\"><b>Active Members</b></td>\n");
Echo("</tr>\n");
Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td width=\"250\" align=\"center\"><b>Name</b></td>\n");
Echo("<td width=\"80\" align=\"center\"><b>Tag</b></td>\n");
Echo("<td width=\"143\" align=\"center\"><b>ICQ</b></td>\n");
Echo("<td width=\"338\" align=\"center\"><b>Email</b></td>\n");
Echo("<td width=\"175\" align=\"center\"><b>Role</b></td>\n");
Echo("</tr>\n");

//Actice

$active=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='active' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
while($a=mysql_fetch_array($active)) {

$id=$a["id"];
$name=htmlspecialchars(stripslashes($a["name"]));
$tag=htmlspecialchars(stripslashes($a["tag"]));
$icq=$a["icq"];
$pemail=$a["pemail"];
$role=stripslashes($a["role"]);

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td width=\"250\"> <a href=\"./?view=profile&pid=$id\">$name</a></td>\n");
Echo("<td width=\"80\" align=\"center\">$tag</td>\n");
Echo("<td width=\"143\" align=\"center\">$icq</td>\n");
Echo("<td width=\"338\" align=\"center\"><a href=\"mailto:$pemail\">$pemail</a></td>\n");
Echo("<td width=\"175\" align=\"center\">$role</td>\n");
Echo("</tr>\n");
}

//Recrute

$numr=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='recrute'"));
$recrute=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='recrute' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());

If ($numr!="0"){

Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"5\"><b>New Recrutes</b></td>\n");
Echo("</tr>\n");

while($r=mysql_fetch_array($recrute)) {

$id=$r["id"];
$name=htmlspecialchars(stripslashes($r["name"]));
$tag=htmlspecialchars(stripslashes($r["tag"]));
$icq=$r["icq"];
$pemail=$r["pemail"];
$role=stripslashes($r["role"]);

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td width=\"250\"> <a href=\"./?view=profile&pid=$id\">$name</a></td>\n");
Echo("<td width=\"80\" align=\"center\">$tag</td>\n");
Echo("<td width=\"143\" align=\"center\">$icq</td>\n");
Echo("<td width=\"338\" align=\"center\"><a href=\"mailto:$pemail\">$pemail</a></td>\n");
Echo("<td width=\"175\" align=\"center\">$role</td>\n");
Echo("</tr>\n");
}
}

// Inactive

$numi=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='inactive'"));
$inactive=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='inactive' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());

If ($numi!="0"){

Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"5\"><b>Inactive Members</b></td>\n");
Echo("</tr>\n");

while($i=mysql_fetch_array($inactive)) {

$id=$i["id"];
$name=htmlspecialchars(stripslashes($i["name"]));
$tag=htmlspecialchars(stripslashes($i["tag"]));
$icq=$i["icq"];
$pemail=$i["pemail"];
$role=stripslashes($i["role"]);

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td width=\"250\"> <a href=\"./?view=profile&pid=$id\">$name</a></td>\n");
Echo("<td width=\"80\" align=\"center\">$tag</td>\n");
Echo("<td width=\"143\" align=\"center\">$icq</td>\n");
Echo("<td width=\"338\" align=\"center\"><a href=\"mailto:$pemail\">$pemail</a></td>\n");
Echo("<td width=\"175\" align=\"center\">$role</td>\n");
Echo("</tr>\n");
}
}

Echo("</table>\n");
Echo("<br />\n");
}
?>
__________________

04' Dodge SRT-4, Mopar Stage 3, 406whp/436wtq
Reply With Quote
  #3  
Old 03-31-2004, 04:30 AM
Stu is offline Stu
Resident Member

Join Date: Aug 2003
Posts: 3,319
The URL to this page is: http://www.members.lycos.co.uk/sc20032004/?view=roster

What has happened is that it says MSN in the admin panel but shows up as ICQ on the roster. Can you give me the code so it says MSN where it is ment to say ICQ please.

cheers

(p.s: I'v only put my name there to show you, i am gonna put loads others on there too. 17 of us! )
Reply With Quote
  #4  
Old 03-31-2004, 01:58 PM
Scott is offline Scott
Scott's Avatar
AKA. Panther

Join Date: Sep 2001
Location: Minneapolis, MN
Posts: 10,927
<?
##################Admin Add Player####################
If ($global[cmd]=="admin_add") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");

If ($_POST['doadd']) {
$name=$_POST["name"];
$tag=$_POST["tag"];
$icq=$_POST["icq"];
$pemail=$_POST["pemail"];
$role=$_POST["role"];
$status=$_POST["status"];

If (!$name) {
$error="1";
$error_text .= "Please enter a player name!<br />";
}

If ($error=="1") {
$show_errors = "$error_text";
} Else {
mysql_query("INSERT INTO $global[pre]_roster VALUES ('NULL', '$name', '$tag', '$icq', '$pemail', '$role', '$status')") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
$newid=mysql_fetch_array(mysql_query("SELECT id FROM $global[pre]_roster ORDER BY id DESC LIMIT 1"));
mysql_query("INSERT INTO $global[pre]_profiles VALUES ('$newid[0]', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', 'Unavaliable', '')") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
Echo("<br /><div align=\"center\">Player Added!</div><br /><br />\n");
exit(ssibot());
}
}

Echo("<br />\n");
Echo("<table border=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\" class=\"reghead\"><b>Add Player</b></td>\n");
Echo("</tr>\n");
ShowErrors($show_errors);
Echo("<form method=\"POST\" action=\"./?view=roster&cmd=admin_add\">\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Name:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"name\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Tag:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"tag\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Msn:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"icq\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Email:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"pemail\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Role:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"role\" size=\"40\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Status:</td>\n");
Echo("<td align=\"left\"> \n");
Echo("<select size=\"1\" name=\"status\" class=\"input\">\n");
Echo("<option value=\"active\">Active</option>\n");
Echo("<option value=\"recrute\">New Recrute</option>\n");
Echo("<option value=\"inactive\">Inactive</option>\n");
Echo("</select>\n");
Echo("</td>\n");
Echo("</tr>\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\"><input type=\"submit\" value=\" Add Player \" name=\"doadd\" class=\"input\"> <input type=\"reset\" value=\" Reset \" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("</form>\n");
Echo("</table>\n");
Echo("<br />\n");

##################Admin Edit Player################################
} Elseif($global[cmd]=="admin_edit") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");

$id = $_GET["id"];

If ($_POST['doedit']) {

$name=$_POST["name"];
$tag=$_POST["tag"];
$icq=$_POST["icq"];
$pemail=$_POST["pemail"];
$role=$_POST["role"];
$status=$_POST["status"];

If (!$name) {
$error="1";
$error_text .= "Please enter a player name!<br />";
}
If ($error=="1") {
$show_errors = "$error_text";
} Else {
mysql_query("UPDATE $global[pre]_roster SET name='$name', tag='$tag', icq='$icq', pemail='$pemail', role='$role', status='$status' WHERE id='$id'") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
Echo("<br /><div align=\"center\">Player Updated!</div>\n");
}
}

$p=mysql_fetch_array(mysql_query("SELECT * FROM $global[pre]_roster WHERE id='$id'"));
$name=htmlspecialchars(stripslashes($p["name"]));
$tag=htmlspecialchars(stripslashes($p["tag"]));
$icq=$p["icq"];
$pemail=$p["pemail"];
$role=stripslashes($p["role"]);
$status=$p["status"];

Echo("<br />\n");
Echo("<table border=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\" class=\"reghead\"><b>Edit Player</b></td>\n");
Echo("</tr>\n");
ShowErrors($show_errors);
Echo("<form method=\"POST\" action=\"./?view=roster&cmd=admin_edit&id=$id\">\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Name:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"name\" size=\"40\" value=\"$name\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Tag:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"tag\" size=\"40\" value=\"$tag\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">MSN:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"icq\" size=\"40\" value=\"$icq\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Email:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"pemail\" size=\"40\" value=\"$pemail\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Role:</td>\n");
Echo("<td align=\"left\"> <input type=\"text\" name=\"role\" size=\"40\" value=\"$role\" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("<tr>\n");
Echo("<td class=\"regbody\">Status:</td>\n");
Echo("<td align=\"left\"> \n");
Echo("<select size=\"1\" name=\"status\" class=\"input\">\n");
Echo("<option value=\"active\""); If($status=="active"){Echo(" selected");}Echo(">Active Member</option>\n");
Echo("<option value=\"recrute\""); If($status=="recrute"){Echo(" selected");}Echo(">New Recrute</option>\n");
Echo("<option value=\"inactive\""); If($status=="inactive"){Echo(" selected");}Echo(">Inactive Member</option>\n");
Echo("</select>\n");
Echo("</td>\n");
Echo("</tr>\n");
Echo("<tr bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"2\"><input type=\"submit\" value=\" Edit Player \" name=\"doedit\" class=\"input\"> <input type=\"reset\" value=\" Reset \" class=\"input\"></td>\n");
Echo("</tr>\n");
Echo("</form>\n");
Echo("</table>\n");
Echo("<br />\n");

##################Admin Delete Player################################
} Elseif($global[cmd]=="admin_delete") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");

$id=$_GET["id"];
$name=$_GET["name"];

If ($_POST['dodelete']) {
mysql_query("DELETE FROM $global[pre]_roster WHERE id='$id'") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
mysql_query("DELETE FROM $global[pre]_profiles WHERE pid='$id'") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
Echo("<br /><div align=\"center\">Player Deleted!</div><br /><br />\n");
exit(ssibot());
}

Echo("<br />\n");
Echo("<div align=\"center\">\n");
Echo("Are you sure you want to delete $name?<br />\n");
Echo("<table border=\"0\">\n");
Echo("<tr>\n");
Echo("<td><form method=\"POST\" action=\"./?view=roster&cmd=admin_delete&id=$id\"><input type=\"submit\" value=\"Yes Delete Player!\" name=\"dodelete\" class=\"input\"></form></td>\n");
Echo("<td><form method=\"POST\" action=\"./?view=roster&cmd=admin_main\"><input type=\"submit\" value=\"No, Don't Delete!\" name=\"reset\" class=\"input\"></form></td><br /><br />\n");
Echo("</tr>\n");
Echo("</table>\n");
Echo("</div>\n");
Echo("<br />\n");

##################Admin Main Page################################
} Elseif($global[cmd]=="admin_main") {

If (!session_is_registered(sssadmin)) {
exit(ssibot(LoginForm()));
}

Echo("<div align=\"center\"><a href=\"./?view=admin\">Admin Panel Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_main\">Roster Admin Home</a> <b>||</b> <a href=\"./?view=roster&cmd=admin_add\">Add Player</a></div>\n");
Echo("<br />\n<table border=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td colspan=\"4\" align=\"center\"><b>Active Members</b></td>\n");
Echo("</tr>\n");
Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td><b>Player Name</b></td><td><b>Edit Player</b></td><td><b>Delete Player</b></td><td><b>Edit Profile</b></td>\n");
Echo("</tr>\n");

//Active

$active=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='active' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
while($a=mysql_fetch_array($active)) {

$id=$a["id"];
$name=htmlspecialchars(stripslashes($a["name"]));

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td>$name</td><td><a href=\"./?view=roster&cmd=admin_edit&id=$id\">Edit</a></td><td><a href=\"./?view=roster&cmd=admin_delete&id=$id&name=$name\"> Delete</a></td><td><a href=\"./?view=profile&cmd=admin_main&pid=$id&playername=$n ame\">Edit Profile</a></td>\n");
Echo("</tr>\n");
}

//Get Recrutes

$recrute=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='recrute' ORDER BY id ASC");
$numr=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='recrute' ORDER BY id ASC"));

If ($numr!="0"){

Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td colspan=\"4\" align=\"center\"><b>Recrutes</b></td>\n");
Echo("</tr>\n");

while($r=mysql_fetch_array($recrute)) {
$id=$r["id"];
$name=htmlspecialchars(stripslashes($r["name"]));

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td>$name</td><td><a href=\"./?view=roster&cmd=admin_edit&id=$id\">Edit</a></td><td><a href=\"./?view=roster&cmd=admin_delete&id=$id&name=$name\"> Delete</a></td><td><a href=\"./?view=profile&cmd=admin_main&pid=$id&playername=$n ame\">Edit Profile</a></td>\n");
Echo("</tr>\n");
}
}

//Get Inactive

$inactive=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='inactive' ORDER BY id ASC");
$numi=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='inactive' ORDER BY id ASC"));

If ($numi!="0"){

Echo("<tr bgcolor=\"$global[thead]\" class=\"reghead\">\n");
Echo("<td colspan=\"4\" align=\"center\"><b>Inactive Members</b></td>\n");
Echo("</tr>\n");

while($i=mysql_fetch_array($inactive)) {
$id=$i["id"];
$name=htmlspecialchars(stripslashes($i["name"]));

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td>$name</td><td><a href=\"./?view=roster&cmd=admin_edit&id=$id\">Edit</a></td><td><a href=\"./?view=roster&cmd=admin_delete&id=$id&name=$name\"> Delete</a></td><td><a href=\"./?view=profile&cmd=admin_main&pid=$id&playername=$n ame\">Edit Profile</a></td>\n");
Echo("</tr>\n");
}
}
Echo("</table>\n");
Echo("<br />\n");
##################View Roster################################
} Else {

Echo("<div align=\"center\">Click name for profile.</div>\n");
Echo("<br />\n");
Echo("<table border=\"1\" cellpadding=\"1\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#000000\" width=\"98%\" align=\"center\">\n");
Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"5\"><b>Active Members</b></td>\n");
Echo("</tr>\n");
Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td width=\"250\" align=\"center\"><b>Name</b></td>\n");
Echo("<td width=\"80\" align=\"center\"><b>Tag</b></td>\n");
Echo("<td width=\"143\" align=\"center\"><b>MSN</b></td>\n");
Echo("<td width=\"338\" align=\"center\"><b>Email</b></td>\n");
Echo("<td width=\"175\" align=\"center\"><b>Role</b></td>\n");
Echo("</tr>\n");

//Actice

$active=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='active' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
while($a=mysql_fetch_array($active)) {

$id=$a["id"];
$name=htmlspecialchars(stripslashes($a["name"]));
$tag=htmlspecialchars(stripslashes($a["tag"]));
$icq=$a["icq"];
$pemail=$a["pemail"];
$role=stripslashes($a["role"]);

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td width=\"250\"> <a href=\"./?view=profile&pid=$id\">$name</a></td>\n");
Echo("<td width=\"80\" align=\"center\">$tag</td>\n");
Echo("<td width=\"143\" align=\"center\">$icq</td>\n");
Echo("<td width=\"338\" align=\"center\"><a href=\"mailto:$pemail\">$pemail</a></td>\n");
Echo("<td width=\"175\" align=\"center\">$role</td>\n");
Echo("</tr>\n");
}

//Recrute

$numr=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='recrute'"));
$recrute=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='recrute' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());

If ($numr!="0"){

Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"5\"><b>New Recrutes</b></td>\n");
Echo("</tr>\n");

while($r=mysql_fetch_array($recrute)) {

$id=$r["id"];
$name=htmlspecialchars(stripslashes($r["name"]));
$tag=htmlspecialchars(stripslashes($r["tag"]));
$icq=$r["icq"];
$pemail=$r["pemail"];
$role=stripslashes($r["role"]);

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td width=\"250\"> <a href=\"./?view=profile&pid=$id\">$name</a></td>\n");
Echo("<td width=\"80\" align=\"center\">$tag</td>\n");
Echo("<td width=\"143\" align=\"center\">$icq</td>\n");
Echo("<td width=\"338\" align=\"center\"><a href=\"mailto:$pemail\">$pemail</a></td>\n");
Echo("<td width=\"175\" align=\"center\">$role</td>\n");
Echo("</tr>\n");
}
}

// Inactive

$numi=mysql_num_rows(mysql_query("SELECT id FROM $global[pre]_roster WHERE status='inactive'"));
$inactive=mysql_query("SELECT * FROM $global[pre]_roster WHERE status='inactive' ORDER BY id ASC") or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());

If ($numi!="0"){

Echo("<tr class=\"reghead\" bgcolor=\"$global[thead]\">\n");
Echo("<td align=\"center\" colspan=\"5\"><b>Inactive Members</b></td>\n");
Echo("</tr>\n");

while($i=mysql_fetch_array($inactive)) {

$id=$i["id"];
$name=htmlspecialchars(stripslashes($i["name"]));
$tag=htmlspecialchars(stripslashes($i["tag"]));
$icq=$i["icq"];
$pemail=$i["pemail"];
$role=stripslashes($i["role"]);

Echo("<tr class=\"smallbody\" bgcolor=\"$global[tbody]\">\n");
Echo("<td width=\"250\"> <a href=\"./?view=profile&pid=$id\">$name</a></td>\n");
Echo("<td width=\"80\" align=\"center\">$tag</td>\n");
Echo("<td width=\"143\" align=\"center\">$icq</td>\n");
Echo("<td width=\"338\" align=\"center\"><a href=\"mailto:$pemail\">$pemail</a></td>\n");
Echo("<td width=\"175\" align=\"center\">$role</td>\n");
Echo("</tr>\n");
}
}

Echo("</table>\n");
Echo("<br />\n");
}
?>
__________________

04' Dodge SRT-4, Mopar Stage 3, 406whp/436wtq
Reply With Quote
Reply

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Roster Still down BARRACUDA Feedback / Novahq.net Support 2 01-18-2006 04:18 PM
Roster **LUCKY** Feedback / Novahq.net Support 8 01-12-2006 10:03 AM
Roster buGsy Feedback / Novahq.net Support 10 01-11-2006 07:09 AM
Roster BARRACUDA Delta Force 3 01-06-2006 06:55 AM
Roster Down ?? D-RANGED Feedback / Novahq.net Support 4 07-17-2004 01:14 AM


All times are GMT -5. The time now is 11:58 PM.

Novahq.net - Archive - Top



Powered by vBulletin®