items.php

三國好好 子

<?php
/* part Copyright 2005 [e-mail] */

require_once "config.php";
include_once "global.php";
include_once "class_character.php";
include_once 'include_lang.php';

/*
 * This file contains functions related to item handling.
 */

$armorItems= array("armor","boots","shield","helm","gloves");

$dummycharacter= new character(0);

// check the ground, if necessary drop new items
function auto_ground() {


    if( rand(0,9)==0 || defined('DEBUG')&&DEBUG ) {
        fix_ground();
    }
    $nlocations= fetch_value("select count(*) from phaos_locations",__FILE__,__LINE__,__FUNCTION__);
    //CAVEAT: this includes items stored in shops
    $nground= fetch_value("select count(DISTINCT(location)) from phaos_ground where number>0 and location>'0'",__FILE__,__LINE__,__FUNCTION__);

    $proportion= 25;
    $missingitems= (int)($nlocations/$proportion) - $nground;
    defined('DEBUG') and DEBUG and $GLOBALS['debugmsgs'][]= "Ground: missing $missingitems items ($nground/$nlocations).";


    if($missingitems>0){
        $add= $missingitems<12?$missingitems:12;
        while($add-->0){
            $location= random_location("item_drop");
            $item_cluster_limit= 4;
            $items_here= fetch_items_for_location($location);
            if(count($items_here)>=$item_cluster_limit) {
                continue;
            }

            $minvalue= 1;
            $maxvalue= powrand(2.75,0.83,5)*powrand(2.75,0.5,8);
            $item= random_item($minvalue,$maxvalue);
            if($item) {
                item_drop($location,$item);
            }
        }
    }
}

// return a random item or items with a value between minvalue and maxvalue
function random_item($minvalue,$maxvalue,$fixedtype=null,$name_like=null){
    global $validDropItems;
    global $dummycharacter;

    if($name_like && $name_like!='%'){
        $condition_name= "name LIKE '$name_like'";
    }else{
        $condition_name= '1=1';
    }

    $found= false;
    $tries_left= 33;while($tries_left-->0 && !$found){
        $type= $fixedtype ? $fixedtype : $validDropItems[rand(0,count($validDropItems)-1)];
        switch($type){
            case "gold":
                $id= 1;
                $number= rand($minvalue,$maxvalue);
                $found= true;
                break;
            case "armor":
            case "weapon":
            case "boots":
            case "shield":
            case "helm":
            case "gloves":
            case "potion":
            case "spell_items":
                $table = $GLOBALS['tableForField'][$type];
                //HINT: to stop special items from being selected, a trick would be to set buy_value=0
                $query= "select id from phaos_$table where sell_price<$maxvalue and buy_price>$minvalue and $condition_name order by rand() LIMIT 1";
                $id= fetch_value($query,__FILE__,__LINE__,__FUNCTION__);
                //$info= fetch_item_additional_info($item,$dummycharacter);
                if($id){
                    $number= 1;
                    $found= true;
                }
                break;
            default:
                echo "<p>Unknown item type $type in ".__FUNCTION__."</p>";
                $tries_left= 0;
        }
    }
    if($found){
        return array('id'=>$id,'type'=>$type,'number'=>$number);
    }else{
        return null;
    }
}


function random_location($whatfor){
    $where= "id<>0 and special=0 and buildings='n' and pass='y'";
    $whereid= speedup_random_row('id','phaos_locations',$where);
    return fetch_value("select id from phaos_locations where $where and $whereid order by rand() LIMIT 1");
}

// due to map restructuring, ground items may become inaccessible - remove these
// CAVEAT: this will wreak havoc if you ever remove the dummy storage locations for shops
// locations have to be marked with 'special', or have to be accessible
// so if you make locations with varying accessibility, make them special
function fix_ground() {
    //bad locations - be careful, missing braces mean trouble
    $where= "( id IS NULL or id=0 or (special<>1 AND NOT (pass LIKE 'y') ) )";

    $noks= fetch_all("select $where as ok, count(*) as n from phaos_ground LEFT JOIN phaos_locations on (phaos_ground.location=phaos_locations.id) GROUP BY ok");
    $ok= 0;
    $nok= 0;
    foreach($noks as $k){
        if(!$k['ok']){
           $ok= $k['n'];
        }else{
           $nok= $k['n'];
        }
    }

    DEBUG and $GLOBALS['debugmsgs'][] = __FUNCTION__.". inaccessible items: ".$nok."/".($ok+$nok);
    if($nok>$ok){
        print (__FUNCTION__.': The number of items in inaccessible locations is unusally high, not executing automatic cleanup - please inform a wizard.');
    }else if($nok>0){
        //this does a similar query as above, so if it happens regularly that $nok>0, it is extra work
        $query= "select location from phaos_ground LEFT JOIN phaos_locations on (phaos_ground.location=phaos_locations.id) WHERE $where";
        $noks= fetch_all($query);
        $locations = makeList(project($noks,'location'));
        $query= "delete from phaos_ground where location in $locations";
        DEBUG and $GLOBALS['debugmsgs'][] = ' sql for cleaning: '.$query;
        $req=mysql_query($query);
        if (!$req) {showError(__FILE__,__LINE__,__FUNCTION__); exit;}
    }
}


// get all items on the ground. allows a spotting value to be used so that not all is visible
function fetch_items_for_location($location,$xof100=100){

    if($xof100<100){
        //first make the finder pass a find-at-all check
        //FIXME: this somehow depends on close locations having the same sqrt
        $seed= $xof100 + $location + date('d');
        //defined('DEBUG') and DEBUG and $GLOBALS['debugmsgs'][]= "seed= $seed for $location,$xof100";
        srand($seed);
        if(rand(1,100)>$xof100){
            return array();
        }
        srand(time());
    }

    //$query= "select item_id as id, item_type as type, number from phaos_ground where location='$location' and RAND()*100<=$xof100";
    $query= "select item_id as id, item_type as type, number from phaos_ground where location='$location'";
    //defined('DEBUG') and DEBUG and $GLOBALS['debugmsgs'][] = __FUNCTION__.":". $query;
    return fetch_all($query,__FILE__,__LINE__,__FUNCTION__);
}

// select a random item from the ground
function fetch_random_item_for_location($location){
    $query= "select item_id as id, item_type as type, number from phaos_ground where location= '$location' order by RAND() LIMIT 1";
    //defined('DEBUG') and DEBUG and $GLOBALS['debugmsgs'][] = __FUNCTION__.":". $query;
    return fetch_first($query,__FILE__,__LINE__,__FUNCTION__);
}



//
// get name and other info about item
// @args $item array(id,type,number),
// @args const &$character class
// @return array( description, .., skill_req, ..
function fetch_item_additional_info($item,&$character) {
    if(!$item){
        echo "<p>no item handed over!</p>";
        return array();
    }

    $info['id']= $item['id'];
    $info['number']= (@$item['number'])?$item['number']:1;
    $info['skill_need'] = "#FFFFFF";