<?xml version="1.0" encoding="UTF-8"?>
<monster name="Barbarian Headsplitter" nameDescription="a barbarian headsplitter" race="blood" experience="75000" speed="500" manacost="0">
<health now="80000" max="80000"/>
<look type="253" head="132" body="105" legs="0" feet="132" corpse="3128"/>
<targetchange interval="1000" chance="5"/>
<strategy attack="160" defense="0"/>
<flags>
<flag summonable="0"/>
<flag attackable="1"/>
<flag hostile="1"/>
<flag illusionable="0"/>
<flag convinceable="0"/>
<flag pushable="0"/>
<flag canpushitems="1"/>
<flag staticattack="50"/>
<flag lightlevel="0"/>
<flag lightcolor="0"/>
<flag targetdistance="1"/>
<flag runonhealth="0"/>
</flags>
<attacks>
<attack name="melee" interval="800" skill="200" attack="205" poison="500"/>
<attack name="lifedrain" interval="1000" chance="13" radius="8" target="0" min="-400" max="-600">
<attribute key="areaEffect" value="mortarea"/>
</attack>
<attack name="speed" interval="500" chance="12" radius="6" target="0" speedchange="-850" duration="60000">
<attribute key="areaEffect" value="poison"/>
</attack>
<attack name="strength" interval="500" chance="12" radius="3" target="0">
<attribute key="areaEffect" value="blackspark"/>
</attack>
<attack name="fire" interval="500" chance="34" range="7" radius="7" target="1" min="-100" max="-900">
<attribute key="shootEffect" value="fire"/>
<attribute key="areaEffect" value="firearea"/>
</attack>
<attack name="manadrain" interval="500" chance="7" length="0" spread="3" min="-600" max="-1100">
<attribute key="areaEffect" value="energyarea"/>
</attack>
<attack name="physical" interval="500" chance="7" length="8" spread="3" min="-300" max="-900"/>
<attack name="energy" interval="1000" chance="9" length="8" spread="0" min="-500" max="-1500">
<attribute key="areaEffect" value="redshimmer"/>
</attack>
<attack name="poisoncondition" interval="800" chance="10" length="0" spread="0" min="-1000" max="-2000">
<attribute key="areaEffect" value="greenspark"/>
</attack>
<attack name="lifedrain" interval="500" chance="15" length="8" spread="0" min="-500" max="-1000">
<attribute key="areaEffect" value="redshimmer"/>
</attack>
</attacks>
<defenses armor="188" defense="145">
<defense name="healing" interval="800" chance="15" min="1000" max="3000">
<attribute key="areaEffect" value="blueshimmer"/>
</defense>
<defense name="speed" interval="800" chance="8" speedchange="360" duration="6000">
<attribute key="areaEffect" value="redshimmer"/>
</defense>
</defenses>
<immunities>
<immunity physical="0"/>
<immunity energy="1"/>
<immunity fire="1"/>
<immunity poison="1"/>
<immunity lifedrain="1"/>
<immunity paralyze="1"/>
<immunity outfit="1"/>
<immunity drunk="1"/>
<immunity invisible="1"/>
</immunities>
<voices interval="5000" chance="10">
<voice sentence="StyllrOT.. Venham me matar!"/>
<voice sentence="DESTRUCTION!" yell="1"/>
<voice sentence="Sua Mae eh minha ! ekaoeka" yell="1"/>
<voice sentence="DEATH TO ALL!" yell="1"/>
</voices>
<loot capacity="7000">
<item id="2142" countmax="1" chance="35000"/>
<item id="2231" countmax="1" chance="90000"/>
<item id="2144" countmax="15" chance="15000"/>
<item id="2158" countmax="1" chance="15000"/>
<item id="2195" countmax="1" chance="4000"/>
<item id="2192" countmax="1" chance="2500"/>
<item id="2125" countmax="1" chance="1500"/>
<item id="2124" countmax="1" chance="5500"/>
<item id="2520" countmax="1" chance="15500"/>
<item id="2462" countmax="1" chance="11000"/>
<item id="2387" countmax="1" chance="20000"/>
<item id="2434" countmax="1" chance="4500"/>
<item id="2167" countmax="1" chance="13500"/>
<item id="2432" countmax="1" chance="17000"/>
<item id="2393" countmax="1" chance="12500"/>
<item id="2148" countmax="100" chance="99900"/>
<item id="2148" countmax="100" chance="88800"/>
<item id="2148" countmax="100" chance="77700"/>
<item id="2148" countmax="100" chance="66600"/>
<item id="2179" countmax="1" chance="8000"/>
<item id="2470" countmax="1" chance="5000"/>
<item id="2033" countmax="1" chance="7500"/>
<item id="2418" countmax="1" chance="4500"/>
<item id="2155" countmax="1" chance="1500"/>
<item id="2396" countmax="1" chance="7500"/>
<item id="2177" countmax="1" chance="1000"/>
<item id="2162" countmax="1" chance="11500"/>
<item id="2472" countmax="1" chance="3000"/>
<item id="2514" countmax="1" chance="7500"/>
<item id="2164" countmax="1" chance="5000"/>
<item id="2178" countmax="1" chance="4000"/>
<item id="2186" countmax="1" chance="3500"/>
<item id="2176" countmax="1" chance="12000"/>
<item id="2171" countmax="2" chance="4500"/>
<item id="2200" countmax="1" chance="4500"/>
<item id="1982" countmax="1" chance="2600"/>
<item id="2214" countmax="1" chance="13000"/>
<item id="2123" countmax="1" chance="3500"/>
<item id="2170" countmax="1" chance="13000"/>
<item id="2402" countmax="1" chance="15500"/>
<item id="2436" countmax="1" chance="5000"/>
<item id="2150" countmax="20" chance="13500"/>
<item id="2145" countmax="5" chance="9500"/>
<item id="2149" countmax="10" chance="15500"/>
<item id="2146" countmax="10" chance="13500"/>
<item id="2182" countmax="1" chance="3500"/>
<item id="2165" countmax="1" chance="9500"/>
<item id="2197" countmax="1" chance="40000"/>
<item id="2174" countmax="1" chance="25000"/>
<item id="2151" countmax="7" chance="14000"/>
<item id="2112" countmax="2" chance="14500"/>
<item id="2421" countmax="1" chance="13500"/>
<item id="2377" countmax="1" chance="20000"/>
<item id="2185" countmax="1" chance="3500"/>
<item id="3955" countmax="1" chance="10000"/>
<item id="2188" countmax="1" chance="25000"/>
<item id="2143" countmax="15" chance="12500"/>
<item id="2473" countmax="2" chance="5535"/>
<item id="2403" countmax="1" chance="8888"/>
<item id="7461" countmax="2" chance="1999"/>
</loot>
</monster>

<monster name="Barbarian Headsplitter" file="Barbarian Headsplitter.xml" />

m_confString[REPLACE_KICK_ON_LOGIN] = getGlobalString(L, "replaceKickOnLogin", "yes");

REPLACE_KICK_ON_LOGIN,

bool Game::playerSaySpell(Player* player, SpeakClasses type, const std::string& text)

return internalCreatureSay(player, SPEAK_SAY, text);
else if(result == TALKACTION_FAILED)
return true;

return false;
}

<?php
class mysql extends main
{
protected $fields = array();
protected $querytype;
protected $newfields = array();
protected $table;

function __construct($table = 'players')
{
$this->table = $table;
}

function changeTable($table)
{
$this->table = $table;
}

function cleanFields()
{
$this->fields = array();
$this->newfields = array();
}

function setField($fieldname,$value = 0)
{
$this->fields[$fieldname] = $value;
}

function setNewField($fieldname,$value = 0)
{
$this->newfields[$fieldname] = $value;
}

function setQueryType($querytype = 'select')
{
$this->querytype = strtolower($querytype);
}

function showFields()
{
print_r($this->fields);
}



function executeQuery($extra = '')
{
$table = $this->table;

$return = array();
$sqlfields = '';


switch($this->querytype)
{
case 'select':
$a = 0;
if (count($this->fields) > 0)
{
$sqlfields = 'WHERE ';
}
foreach(array_keys($this->fields) as $keys)
{
$a++;
if ($a == count($this->fields))
{
$sqlfields .= '`'.$keys.'` = \''.$this->fields[$keys].'\'';
}
else
{
$sqlfields .= '`'.$keys.'` = \''.$this->fields[$keys].'\' AND ';
}
}


$query = "SELECT * FROM ".$table." ".$sqlfields." ".$extra."";
$query = mysql_query($query);
echo mysql_error();
while($result = mysql_fetch_assoc($query))
{
$return[] = $result;
}
break;

case 'insert':
$a = 0;
foreach(array_keys($this->fields) as $keys)
{
$a++;
if ($a == count($this->fields))
{
$fields .= $keys;
$values .= '\''.$this->fields[$keys].'\'';
}
else
{
$fields .= $keys.',';
$values .= '\''.$this->fields[$keys].'\',';
}
}


$query = "INSERT INTO ".$table." (".$fields.") VALUES (".$values.") ".$extra."";
$query = mysql_query($query);
$return = mysql_error();
echo $return;
break;


case 'delete':
foreach(array_keys($this->fields) as $keys)
{

$a++;
if ($a == count($this->fields))
{
$sqlfields .= '`'.$keys.'` = \''.$this->fields[$keys].'\'';
}
else
{
$sqlfields .= '`'.$keys.'` = \''.$this->fields[$keys].'\' AND ';
}
}



$query = "DELETE FROM ".$table." WHERE ".$sqlfields." ".$extra."";
$query = mysql_query($query);
$return = mysql_error();
echo $return;


break;
case 'update':
$a=0;
foreach(array_keys($this->fields) as $keys)
{
$a++;
if ($a == count($this->fields))
{
$sqlfields .= '`'.$keys.'` = \''.$this->fields[$keys].'\'';
}
else
{
$sqlfields .= '`'.$keys.'` = \''.$this->fields[$keys].'\' AND ';
}
}
$a=0;
foreach(array_keys($this->newfields) as $keys)
{
$a++;
if ($a == count($this->newfields))
{
$newfields .= '`'.$keys.'` = \''.$this->newfields[$keys].'\'';
}
else
{
$newfields .= '`'.$keys.'` = \''.$this->newfields[$keys].'\', ';
}
}

$query = "UPDATE ".$table." SET ".$newfields." WHERE ".$sqlfields." ".$extra."";
$query = mysql_query($query);
$return = mysql_error();
echo $return;

break;

default:
$return = FALSE;
break;
}

return $return;


}
// end functions execute query


}
?>

<?php
$connect = mysql_connect('localhost', 'root', '1234');
mysql_select_db('forgottenserver', $connect);

include 'mysqlclass.php'; // edite aqui o diretório e o arquivo onde está a class mysql

$mysql = new mysql();
$mysql->cleanFields();
$mysql->setQueryType('select');
$mysql->changeTable('players');
$mysql->setField('name','Yunie');
$query = $mysql->executeQuery();
print_r($query);
?>