Update of /cvsroot/planeshift/planeshift/www/serverconsole/trainers
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22866
Added Files:
listtrainers.php trainers_actions.php
Log Message:
trainers list
--- NEW FILE: listtrainers.php ---
<?
function listtrainers(){
include('util.php');
?>
<SCRIPT language=javascript>
function confirmDelete()
{
return confirm("Are you sure you want to remove this category?");
}
</SCRIPT>
<?PHP
$query = "select distinct c.id,c.name,c.id,s.name from trainer_skills t, characters c, sectors s where c.id=t.player_id and c.loc_sector_id=s.id order by s.name, c.name";
$result = mysql_query2($query);
while ($line = mysql_fetch_array($result, MYSQL_NUM)){
// Find number of skills in category
$skillquery = "select s.skill_id,s.name,t.min_rank,t.max_rank from trainer_skills t, skills s where s.skill_id=t.skill_id AND t.player_id=$line[0]";
$skill_res = mysql_query2($skillquery);
echo " <b>$line[1] in $line[3]</b><br>";
echo ' <TABLE BORDER=1>';
echo " <TH> Skill </TH> <TH> MinRank </TH> <TH> MaxRank </TH> <TH> Functions </TH>";
while ($skilldata = mysql_fetch_array($skill_res, MYSQL_NUM)){
echo "<TR><TD>$skilldata[1]</TD><TD>$skilldata[2]</TD><TD>$skilldata[3]</TD>";
echo "<TD><FORM ACTION=index.php?page=trainer_actions&operation=remove METHOD=POST>";
echo "<INPUT TYPE=hidden NAME=skill_id VALUE=\"$skilldata[0]\">";
echo "<INPUT TYPE=hidden NAME=player_id VALUE=\"$line[0]\">";
echo "<INPUT TYPE=SUBMIT NAME=submit VALUE=Remove></FORM>";
}
echo '<TR><TD>';
echo "<FORM ACTION=index.php?page=trainer_actions&operation=add METHOD=POST>";
SelectSkills("skill_id");
echo " <TD><INPUT TYPE=text NAME=min_rank VALUE=\"\"> </TD><TD><INPUT TYPE=text NAME=max_rank VALUE=\"\"></TD>";
echo "<INPUT TYPE=hidden NAME=player_id VALUE=\"$line[2]\">";
echo "<TD><INPUT TYPE=SUBMIT NAME=submit VALUE=Add></TD></TR>";
echo '</FORM>';
echo '</TABLE><br>';
}
echo '<br><br>';
}
?>
--- NEW FILE: trainers_actions.php ---
<?PHP
function trainers_actions(){
// gets operation to perform
$operation = $_GET['operation'];
/**
* remove a category
*/
if ($operation == 'remove'){
$skill_id = $_POST['skill_id'];
$player_id = $_POST['player_id'];
// delete named script
$query = "delete from trainer_skills where skill_id=$skill_id AND player_id=$player_id";
echo "$query";
$result = mysql_query2($query);
/**
* add category
*/
}else if ($operation == 'add'){
$skill_id = $_POST['skill_id'];
$player_id = $_POST['player_id'];
$min_rank = $_POST['min_rank'];
$max_rank = $_POST['max_rank'];
// insert script
$query = "insert into trainer_skills values($player_id,$skill_id,$min_rank,$max_rank,0)";
//echo "$query";
$result = mysql_query2($query);
}else{
// manage another operation here
echo "Operation $operation not supported.";
}
// redirect
?>
<SCRIPT language="javascript">
document.location = "index.php?page=listtrainers";
</script>
<?
}
?>
|