From: Luca P. <lpa...@us...> - 2006-10-29 21:34:30
|
Update of /cvsroot/planeshift/planeshift/www/serverconsole/npcs In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31649 Modified Files: checknpcchar.php Log Message: added last name to npc check Index: checknpcchar.php =================================================================== RCS file: /cvsroot/planeshift/planeshift/www/serverconsole/npcs/checknpcchar.php,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** checknpcchar.php 22 Jul 2006 12:19:04 -0000 1.1 --- checknpcchar.php 29 Oct 2006 21:34:27 -0000 1.2 *************** *** 6,10 **** // extract all invulnerable NPC names ! $query = "select s.name, c.id, c.name, ra.name, ra.sex, description, r.response1"; $query = $query . " from characters c, sectors s, npc_triggers t, npc_responses r, race_info ra "; $query = $query . " where c.name=t.area and s.id=c.loc_sector_id and t.response_id=r.id and c.racegender_id=ra.race_id "; --- 6,10 ---- // extract all invulnerable NPC names ! $query = "select s.name, c.id, c.name, c.lastname, ra.name, ra.sex, description, r.response1"; $query = $query . " from characters c, sectors s, npc_triggers t, npc_responses r, race_info ra "; $query = $query . " where c.name=t.area and s.id=c.loc_sector_id and t.response_id=r.id and c.racegender_id=ra.race_id "; *************** *** 13,16 **** --- 13,19 ---- $result = mysql_query2($query); + $num = mysql_num_rows($result); + + echo "Found $num NPCs"; echo " <TABLE BORDER=1>"; *************** *** 19,24 **** // for each NPC while ($line = mysql_fetch_array($result, MYSQL_NUM)) { ! echo "<TR><TD>$line[0]</TD><TD>$line[1] </TD><TD><A href='index.php?page=viewnpc&id=".$line[1]."'>".$line[2]."</a></TD><TD>$line[3]</TD><TD>$line[4]</TD>"; ! echo "<TD>$line[5]</TD><TD>$line[6]</TD><TR>"; } echo '</TABLE><br><br>'; --- 22,27 ---- // for each NPC while ($line = mysql_fetch_array($result, MYSQL_NUM)) { ! echo "<TR><TD>$line[0]</TD><TD>$line[1] </TD><TD><A href='index.php?page=viewnpc&id=".$line[1]."'>".$line[2]." ".$line[3]."</a></TD><TD>$line[4]</TD><TD>$line[5]</TD>"; ! echo "<TD>$line[6]</TD><TD>$line[7]</TD><TR>"; } echo '</TABLE><br><br>'; |