Beispiel #1
0
     header("Location: index.php?editor=npc&z={$z}&zoneid={$zoneid}&npcid={$npcid}");
     exit;
 case 21:
     // Delete faction hit
     check_authorization();
     delete_factionhit();
     header("Location: index.php?editor=npc&z={$z}&zoneid={$zoneid}&npcid={$npcid}");
     exit;
 case 22:
     // Edit merchant id
     check_authorization();
     $body = new Template("templates/npc/merchantid.edit.tmpl.php");
     $body->set('currzone', $z);
     $body->set('currzoneid', $zoneid);
     $body->set('npcid', $npcid);
     $body->set('merchant_id', get_merchant_id());
     $body->set('suggested_id', suggest_merchant_id());
     break;
 case 23:
     // Update merchant id
     check_authorization();
     update_merchant_id();
     header("Location: index.php?editor=npc&z={$z}&zoneid={$zoneid}&npcid={$npcid}");
     exit;
 case 24:
     // Delete npc
     check_authorization();
     delete_npc();
     header("Location: index.php?editor=npc&z={$z}&zoneid={$zoneid}");
     exit;
 case 25:
Beispiel #2
0
function sort_merchantlist()
{
    check_authorization();
    global $mysql;
    $merchantid = get_merchant_id();
    $item_id = array();
    $query = "SELECT COUNT(slot) AS item_count FROM merchantlist WHERE merchantid={$merchantid}";
    $result = $mysql->query_assoc($query);
    $item_count = $result['item_count'];
    $query = "SELECT MAX(slot) AS max_slot FROM merchantlist WHERE merchantid={$merchantid}";
    $result = $mysql->query_assoc($query);
    $max_slot = $result['max_slot'];
    $query = "SELECT item FROM merchantlist WHERE merchantid={$merchantid}";
    $results = $mysql->query_mult_assoc($query);
    foreach ($results as $result) {
        $item_id[] = $result['item'];
    }
    for ($i = 0; $i < $item_count; $i++) {
        $query = "UPDATE merchantlist SET slot={$max_slot}+{$i}+1 WHERE merchantid={$merchantid} AND item={$item_id[$i]}";
        $mysql->query_no_result($query);
    }
    for ($i = 0; $i < $item_count; $i++) {
        $query = "UPDATE merchantlist SET slot={$i}+1 WHERE merchantid={$merchantid} AND item={$item_id[$i]}";
        $mysql->query_no_result($query);
    }
}