View Source: /retitle.php
Click here for the source, OR
Other files that you may wish to view the source of:
<?
require_once "common.php";
isnewday(3);
page_header("Retitler");
addnav("G?Return to the Grotto","superuser.php");
addnav("M?Return to the Mundane","village.php");
addnav("Rebuild all titles","retitle.php?op=rebuild");
if ($_GET['op']=="rebuild"){
//output("<pre>".htmlentities($titles)."</pre>",true);
//output("<pre>".htmlentities(output_array($titles))."</pre>",true);
$sql = "SELECT name,title,dragonkills,acctid,sex,ctitle FROM accounts WHERE dragonkills>0";
$result = db_query($sql);
for ($i=0;$i<db_num_rows($result);$i++){
$row = db_fetch_assoc($result);
//if ($i==0) echo "x".nl2br(output_array($titles));
$newtitle = $titles[(int)$row['dragonkills']][(int)$row['sex']];
if ($row['ctitle'] == "") {
$oname = $row['name'];
if ($row['title']!=""){
$n = $row['name'];
$x = strpos($n,$row['title']);
if ($x!==false){
$regname=substr($n,$x+strlen($row['title']));
$row['name'] = substr($n,0,$x).$newtitle.$regname;
}else{
$row['name'] = $newtitle." ".$row['name'];
}
}else{
$row[name] = $newtitle." ".$row['name'];
}
}
output("`@Changing `^$oname`@ to `^{$row['name']} `@($newtitle-{$row['dragonkills']}[{$row['sex']}]({$row['ctitle']}`@))`n");
if ($session['user']['acctid']==$row['acctid']){
$session['user']['title']=$newtitle;
$session['user']['name']=$row['name'];
}else{
$sql = "UPDATE accounts SET name='".addslashes($row['name'])."', title='".addslashes($newtitle)."' WHERE acctid='{$row['acctid']}'";
//output("`0$sql`n");
(db_query($sql));
}
}
}else{
output("This page lets you rebuild titles when they have changed in the dragon script.");
}
page_footer();
?>