• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

UNNAMED acc. maker 0.3.2 beta for TFS

Status
Not open for further replies.
Quickshot said:
hi when im in the config configuaration settings file and i change it so install is set to yes and i set the server_path to my server then i go to http://localhost and go threw the list of things to install at step 5 when it says set admin account. i choose a password but i get a error which is


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:229 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install.php(459): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 229

what do i do? and this is the only thing i have done in this acc maker
Click to expand...

It seems like you don't have the field "name" in the table "accounts" in your database. Are you using the latest TFS?
 
doublepost

in web files where find: Druid Sample, Knight Sample etc. for delete the sample...
 
Gesior.pl, up to date script to the TFS 0.3b3 version.
 
alissonlinneker said:
Very good organization.
More change:
PHP: 
$config['site']['worlds'][$member->getWorld()]
by:
PHP: 
$config['site']['worlds'][$member->getWorld_id()]

This will:

PHP: 
<?php 
//list of players 
$main_content .= '<center><h2>Gods</h2></center>'; 
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%> 
    <tr bgcolor=\"".$config['site']['vdarkborder']."\"> 
    <td width=\"20%\"><font class=white><b>Group</b></font></td> 
    <td width=\"45%\"><font class=white><b>Name</b></font></td> 
    <td width=\"15%\"><font class=white><b>Status</b></font></td> 
    <td width=\"20%\"><font class=white><b>World</b></font></td>"; 
$showed_players = 0; 
$groups_list = new OTS_Groups_List(); 
$groups_list->init(); 
$groups_list->orderBy('id', POT::ORDER_DESC); 
foreach($groups_list as $group) 
{ 
if($group->getId() >= $config['site']['support_group_id']) 
{ 
    $group_members = $group->getPlayersList(); 
    if(count($group_members) == 6) 
        foreach($group_members as $member) 
        { 
        $showed_players++; 
        if(is_int($showed_players / 2)) 
            $bgcolor = $config['site']['darkborder']; 
        else 
            $bgcolor = $config['site']['lightborder']; 
        $main_content .= "<tr bgcolor=\"".$bgcolor."\"> 
        <td>".ucwords($group->getName())."</td> 
        <td>".$member->getName()."</td> 
        <td>".($member->isOnline() ? "<font color=\"green\"><b>Online</b></font>" : "<font  

color=\"red\"><b>Offline</b></font>")."</td><td>".$config['site']['worlds'][$member->getWorld_id()]."</td> 
        </tr>"; 
        } 
} 
} 

if($showed_players == 0) 
    $main_content .= "<tr bgcolor=\"".$config['site']['darkborder']."\"> 
    <td colspan=\"3\">No members of support team available.</td> 
    </tr>"; 
$main_content .= "</table>"; 

$main_content .= '<center><h2>Community Managers</h2></center>'; 
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%> 
    <tr bgcolor=\"".$config['site']['vdarkborder']."\"> 
    <td width=\"20%\"><font class=white><b>Group</b></font></td> 
    <td width=\"45%\"><font class=white><b>Name</b></font></td> 
    <td width=\"15%\"><font class=white><b>Status</b></font></td> 
    <td width=\"20%\"><font class=white><b>World</b></font></td>"; 
$showed_players = 0; 
$groups_list = new OTS_Groups_List(); 
$groups_list->init(); 
$groups_list->orderBy('id', POT::ORDER_DESC); 
foreach($groups_list as $group) 
{ 
if($group->getId() >= $config['site']['support_group_id']) 
{ 
    $group_members = $group->getPlayersList(); 
    if(count($group_members) == 5) 
        foreach($group_members as $member) 
        { 
        $showed_players++; 
        if(is_int($showed_players / 2)) 
            $bgcolor = $config['site']['darkborder']; 
        else 
            $bgcolor = $config['site']['lightborder']; 
        $main_content .= "<tr bgcolor=\"".$bgcolor."\"> 
        <td>".ucwords($group->getName())."</td> 
        <td>".$member->getName()."</td> 
        <td>".($member->isOnline() ? "<font color=\"green\"><b>Online</b></font>" : "<font  

color=\"red\"><b>Offline</b></font>")."</td><td>".$config['site']['worlds'][$member->getWorld_id()]."</td> 
        </tr>"; 
        } 
} 
} 

if($showed_players == 0) 
    $main_content .= "<tr bgcolor=\"".$config['site']['darkborder']."\"> 
    <td colspan=\"3\">No members of support team available.</td> 
    </tr>"; 
$main_content .= "</table>"; 


$main_content .= '<center><h2>Senior Gamemasters</h2></center>'; 
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%> 
    <tr bgcolor=\"".$config['site']['vdarkborder']."\"> 
    <td width=\"20%\"><font class=white><b>Group</b></font></td> 
    <td width=\"45%\"><font class=white><b>Name</b></font></td> 
    <td width=\"15%\"><font class=white><b>Status</b></font></td> 
    <td width=\"20%\"><font class=white><b>World</b></font></td>"; 
$showed_players = 0; 
$groups_list = new OTS_Groups_List(); 
$groups_list->init(); 
$groups_list->orderBy('id', POT::ORDER_DESC); 
foreach($groups_list as $group) 
{ 

if($group->getId() >= $config['site']['support_group_id']) 
{ 
    $group_members = $group->getPlayersList(); 
    if(count($group_members) == 4) 
        foreach($group_members as $member) 
        { 
        $showed_players++; 
        if(is_int($showed_players / 2)) 
            $bgcolor = $config['site']['darkborder']; 
        else 
            $bgcolor = $config['site']['lightborder']; 
        $main_content .= "<tr bgcolor=\"".$bgcolor."\"> 
        <td>".ucwords($group->getName())."</td> 
        <td>".$member->getName()."</td> 
        <td>".($member->isOnline() ? "<font color=\"green\"><b>Online</b></font>" : "<font  

color=\"red\"><b>Offline</b></font>")."</td><td>".$config['site']['worlds'][$member->getWorld_id()]."</td> 
        </tr>"; 
        } 
} 
} 

if($showed_players == 0) 
    $main_content .= "<tr bgcolor=\"".$config['site']['darkborder']."\"> 
    <td colspan=\"3\">No members of support team available.</td> 
    </tr>"; 
$main_content .= "</table>"; 

$main_content .= '<center><h2>Gamemasters</h2></center>'; 
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%> 
    <tr bgcolor=\"".$config['site']['vdarkborder']."\"> 
    <td width=\"20%\"><font class=white><b>Group</b></font></td> 
    <td width=\"45%\"><font class=white><b>Name</b></font></td> 
    <td width=\"15%\"><font class=white><b>Status</b></font></td> 
    <td width=\"20%\"><font class=white><b>World</b></font></td>"; 
$showed_players = 0; 
$groups_list = new OTS_Groups_List(); 
$groups_list->init(); 
$groups_list->orderBy('id', POT::ORDER_DESC); 
foreach($groups_list as $group) 
{ 
if($group->getId() >= $config['site']['support_group_id']) 
{ 
    $group_members = $group->getPlayersList(); 
    if(count($group_members) == 3) 
        foreach($group_members as $member) 
        { 
        $showed_players++; 
        if(is_int($showed_players / 2)) 
            $bgcolor = $config['site']['darkborder']; 
        else 
            $bgcolor = $config['site']['lightborder']; 
        $main_content .= "<tr bgcolor=\"".$bgcolor."\"> 
        <td>".ucwords($group->getName())."</td> 
        <td>".$member->getName()."</td> 
        <td>".($member->isOnline() ? "<font color=\"green\"><b>Online</b></font>" : "<font  

color=\"red\"><b>Offline</b></font>")."</td><td>".$config['site']['worlds'][$member->getWorld_id()]."</td> 
        </tr>"; 
        } 
} 
} 

if($showed_players == 0) 
    $main_content .= "<tr bgcolor=\"".$config['site']['darkborder']."\"> 
    <td colspan=\"3\">No members of support team available.</td> 
    </tr>"; 
$main_content .= "</table>"; 

$main_content .= '<center><h2>Very Important People</h2></center>'; 
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%> 
    <tr bgcolor=\"".$config['site']['vdarkborder']."\"> 
    <td width=\"20%\"><font class=white><b>Group</b></font></td> 
    <td width=\"45%\"><font class=white><b>Name</b></font></td> 
    <td width=\"15%\"><font class=white><b>Status</b></font></td> 
    <td width=\"20%\"><font class=white><b>World</b></font></td>"; 
$showed_players = 0; 
$groups_list = new OTS_Groups_List(); 
$groups_list->init(); 
$groups_list->orderBy('id', POT::ORDER_DESC); 
foreach($groups_list as $group) 
{ 
if($group->getId() >= $config['site']['support_group_id']) 
{ 
    $group_members = $group->getPlayersList(); 
    if(count($group_members) == 7) 
        foreach($group_members as $member) 
        { 
        $showed_players++; 
        if(is_int($showed_players / 2)) 
            $bgcolor = $config['site']['darkborder']; 
        else 
            $bgcolor = $config['site']['lightborder']; 
        $main_content .= "<tr bgcolor=\"".$bgcolor."\"> 
        <td>".ucwords($group->getName())."</td> 
        <td>".$member->getName()."</td> 
        <td>".($member->isOnline() ? "<font color=\"green\"><b>Online</b></font>" : "<font  

color=\"red\"><b>Offline</b></font>")."</td><td>".$config['site']['worlds'][$member->getWorld_id()]."</td> 
        </tr>"; 
        } 
} 
} 

if($showed_players == 0) 
    $main_content .= "<tr bgcolor=\"".$config['site']['darkborder']."\"> 
    <td colspan=\"3\">No members of support team available.</td> 
    </tr>"; 
$main_content .= "</table>"; 

$main_content .= '<center><h2>Senior Tutors</h2></center>'; 
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%> 
    <tr bgcolor=\"".$config['site']['vdarkborder']."\"> 
    <td width=\"20%\"><font class=white><b>Group</b></font></td> 
    <td width=\"45%\"><font class=white><b>Name</b></font></td> 
    <td width=\"15%\"><font class=white><b>Status</b></font></td> 
    <td width=\"20%\"><font class=white><b>World</b></font></td>"; 
$showed_players = 0; 
$groups_list = new OTS_Groups_List(); 
$groups_list->init(); 
$groups_list->orderBy('id', POT::ORDER_DESC); 
foreach($groups_list as $group) 
{ 
if($group->getId() >= $config['site']['support_group_id']) 
{ 
    $group_members = $group->getPlayersList(); 
    if(count($group_members) == 2) 
        foreach($group_members as $member) 
        { 
        $showed_players++; 
        if(is_int($showed_players / 2)) 
            $bgcolor = $config['site']['darkborder']; 
        else 
            $bgcolor = $config['site']['lightborder']; 
        $main_content .= "<tr bgcolor=\"".$bgcolor."\"> 
        <td>".ucwords($group->getName())."</td> 
        <td>".$member->getName()."</td> 
        <td>".($member->isOnline() ? "<font color=\"green\"><b>Online</b></font>" : "<font  

color=\"red\"><b>Offline</b></font>")."</td><td>".$config['site']['worlds'][$member->getWorld_id()]."</td> 
        </tr>"; 
        } 
} 
} 

if($showed_players == 0) 
    $main_content .= "<tr bgcolor=\"".$config['site']['darkborder']."\"> 
    <td colspan=\"3\">No members of support team available.</td> 
    </tr>"; 
$main_content .= "</table>"; 

$main_content .= '<center><h2>Tutors</h2></center>'; 
$main_content .= "<table border=0 cellspacing=1 cellpadding=4 width=100%> 
    <tr bgcolor=\"".$config['site']['vdarkborder']."\"> 
    <td width=\"20%\"><font class=white><b>Group</b></font></td> 
    <td width=\"45%\"><font class=white><b>Name</b></font></td> 
    <td width=\"15%\"><font class=white><b>Status</b></font></td> 
    <td width=\"20%\"><font class=white><b>World</b></font></td>"; 
$showed_players = 0; 
$groups_list = new OTS_Groups_List(); 
$groups_list->init(); 
$groups_list->orderBy('id', POT::ORDER_DESC); 
foreach($groups_list as $group) 
{ 
if($group->getId() >= $config['site']['support_group_id']) 
{ 
    $group_members = $group->getPlayersList(); 
    if(count($group_members) == 1) 
        foreach($group_members as $member) 
        { 
        $showed_players++; 
        if(is_int($showed_players / 2)) 
            $bgcolor = $config['site']['darkborder']; 
        else 
            $bgcolor = $config['site']['lightborder']; 
        $main_content .= "<tr bgcolor=\"".$bgcolor."\"> 
        <td>".ucwords($group->getName())."</td> 
        <td>".$member->getName()."</td> 
        <td>".($member->isOnline() ? "<font color=\"green\"><b>Online</b></font>" : "<font  

color=\"red\"><b>Offline</b></font>")."</td><td>".$config['site']['worlds'][$member->getWorld_id()]."</td> 
        </tr>"; 
        } 
} 
} 

if($showed_players == 0) 
    $main_content .= "<tr bgcolor=\"".$config['site']['darkborder']."\"> 
    <td colspan=\"3\">No members of support team available.</td> 
    </tr>"; 
$main_content .= "</table>"; 
?>


His update ends when Gesior?
Click to expand...

your script does work this erron in jump for website
Fatal error: Call to undefined method OTS_Player::getWorld_id() in C:\xampp\htdocs\team.php on line 279
Click to expand...
 
<quote>It seems like you don't have the field "name" in the table "accounts" in your database. Are you using the latest TFS? </quote>

rubo im using forgotten server 0.2 for 8.4 and i dont know what you mean by field name
 
MMM the admin Panel sucks!!!! I CANT EDIT ANYTHING THERE!
 
Some Basic changes :)
Go to creature.php and in the line 98 change it for:
Code: 
$main_content .= '<tr BGCOLOR="'.$bgcolor.'"><td width="100"><b>Give<br/>Experience: </b></td><td>'.$monster['exp'] * $config['server']['rateExp'].'</td></tr>';

and the admin panel (#UP)
Code: 
<?PHP
if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) {
$main_content .= '<script type="text/javascript">
var showednewticker_state = "0";
function showNewTickerForm()
{
if(showednewticker_state == "0") {
document.getElementById("newtickerform").innerHTML = \'<form action="?subtopic=latestnews&action=newticker" method="post" ><table border="0"><tr><td bgcolor="D4C0A1" align="center"><b>Select icon:</b></td><td><table border="0" bgcolor="F1E0C6"><tr><td><img src="images/news/icon_0.gif" width="20"></td><td><img src="images/news/icon_1.gif" width="20"></td><td><img src="images/news/icon_2.gif" width="20"></td><td><img src="images/news/icon_3.gif" width="20"></td><td><img src="images/news/icon_4.gif" width="20"></td></tr><tr><td><input type="radio" name="icon_id" value="0" checked="checked"></td><td><input type="radio" name="icon_id" value="1"></td><td><input type="radio" name="icon_id" value="2"></td><td><input type="radio" name="icon_id" value="3"></td><td><input type="radio" name="icon_id" value="4"></td></tr></table></td></tr><tr><td align="center" bgcolor="D4C0A1"><b>New<br>ticker<br>text:</b></td><td bgcolor="F1E0C6"><textarea name="new_ticker" rows="3" cols="45"></textarea></td></tr><tr><td><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" ></div></div></form><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/_sbutton_cancel.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div></td></tr></table>\';
document.getElementById("jajo").innerHTML = \'\';
showednewticker_state = "1";
}
else {
document.getElementById("newtickerform").innerHTML = \'\';
document.getElementById("jajo").innerHTML = \'<div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/addticker.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div>\';
showednewticker_state = "0";
}
}
var showednewnews_state = "0";
function showNewNewsForm()
{
if(showednewnews_state == "0") {
document.getElementById("newnewsform").innerHTML = \'<form action="?subtopic=latestnews&action=newnews" method="post" ><table border="0"><tr><td bgcolor="D4C0A1" align="center"><b>Select icon:</b></td><td><table border="0" bgcolor="F1E0C6"><tr><td><img src="images/news/icon_0.gif" width="20"></td><td><img src="images/news/icon_1.gif" width="20"></td><td><img src="images/news/icon_2.gif" width="20"></td><td><img src="images/news/icon_3.gif" width="20"></td><td><img src="images/news/icon_4.gif" width="20"></td></tr><tr><td><input type="radio" name="icon_id" value="0" checked="checked"></td><td><input type="radio" name="icon_id" value="1"></td><td><input type="radio" name="icon_id" value="2"></td><td><input type="radio" name="icon_id" value="3"></td><td><input type="radio" name="icon_id" value="4"></td></tr></table></td></tr><tr><td align="center" bgcolor="F1E0C6"><b>Topic:</b></td><td><input type="text" name="news_topic" maxlenght="50" style="width: 300px" ></td></tr><tr><td align="center" bgcolor="D4C0A1"><b>News<br>text:</b></td><td bgcolor="F1E0C6"><textarea name="news_text" rows="6" cols="60"></textarea></td></tr><tr><td align="center" bgcolor="F1E0C6"><b>Your nick:</b></td><td><input type="text" name="news_name" maxlenght="40" style="width: 200px" ></td></tr><tr><td><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" ></div></div></form><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="CancelAddNews" src="'.$layout_name.'/images/buttons/_sbutton_cancel.gif" onClick="showNewNewsForm()" alt="CancelAddNews" /></div></div></td></tr></table>\';
document.getElementById("chicken").innerHTML = \'\';
showednewnews_state = "1";
}
else {
document.getElementById("newnewsform").innerHTML = \'\';
document.getElementById("chicken").innerHTML = \'<div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddNews" src="'.$layout_name.'/images/buttons/addnews.gif" onClick="showNewNewsForm()" alt="AddNews" /></div></div>\';
showednewnews_state = "0";
}
}</script>';
if($action == "") {
//wyswietla wszystko mozliwe opcje dla admina takie jak "news", "reload configs", "edit configs","admin players/accounts", "set access rights"
$main_content .= '<center><h2>News system</h2></center>Here you can add new ticker and new message, edit access rights and set limit of showed <b>Tickers</b> and <b>News</b>.<br/><table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'>
<tr bgcolor='.$config['site']['darkborder'].'><td width="150"><font color="red"><b>Option</b></font></td><td><font color="red"><b>Description</b></font></td></tr>
<tr bgcolor='.$config['site']['lightborder'].'><td><div id="newtickerform"></div><div id="jajo"><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddTicker" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" onClick="showNewTickerForm()" alt="AddTicker" /></div></div></div></td><td><b>Press "Submit" to add new ticker.</b></td></tr>
<tr bgcolor='.$config['site']['darkborder'].'><td><div id="newnewsform"></div><div id="chicken"><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><img class="ButtonText" id="AddNews" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" onClick="showNewNewsForm()" alt="AddNews" /></div></div></div></td><td><b>Press "Submit" to add new message (news).</b></td></tr>
<tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=latestnews">Edit/Delete</a></b></td><td><b>Here you can edit and delete news.</b></td></tr>/
</table>';
$main_content .= '<center><h2>Load configurations</h2></center>Here you can choose what configuration you want to reload. It load configuration from OTS files.<br/><table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'>
<tr bgcolor='.$config['site']['darkborder'].'><td width="150"><font color="red"><b>Option</b></font></td><td><font color="red"><b>Description</b></font></td></tr>
<tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=adminpanel&action=install_monsters">Reload Monsters</a></b></td><td><b>Load information about monsters from directory "your_server_path/data/monsters/". Delete old mosters configuration!</b></td></tr>
<tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=adminpanel&action=install_spells">Reload Spells</a></b></td><td><b>Load information about spells from file "your_server_path/data/spells/spells.xml". Delete old spells configuration!</b></td></tr>
</table>';

$main_content .= '<center><h2>Edit Options</h2></center>Here you can choose what configuration you want to edit. It load configuration from OTS files.<br/><table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'>
<tr bgcolor='.$config['site']['darkborder'].'><td width="150"><font color="red"><b>Option</b></font></td><td><font color="red"><b>Description</b></font></td></tr>
<tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=adminpanel&action=editmonsters">Edit Monsters</a></b></td><td><b>Edit information about monsters from directory "your_server_path/data/monsters/".</b></td></tr>
<tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=adminpanel&action=editspells">Edit Spells</a></b></td><td><b>Edit information about spells from file "your_server_path/data/spells/spells.xml".</b></td></tr>
</table>';
}

//RELOAD CONFIGS
if($action == "reloadconfigs") {
$main_content .= '<center><h2>Load configurations</h2></center>Here you can choose what configuration you want to reload. It load configuration from OTS files.<br/><table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'>
<tr bgcolor='.$config['site']['darkborder'].'><td width="150"><font color="red"><b>Option</b></font></td><td><font color="red"><b>Description</b></font></td></tr>
<tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=adminpanel&action=install_monsters">Reload Monsters</a></b></td><td><b>Load information about monsters from directory "your_server_path/data/monsters/". Delete old mosters configuration!</b></td></tr>
<tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=adminpanel&action=install_spells">Reload Spells</a></b></td><td><b>Load information about spells from file "your_server_path/data/spells/spells.xml". Delete old spells configuration!</b></td></tr>
</table>';
$main_content .= '<br/><center><form action="?subtopic=adminpanel" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center>';
}

//EDIT MONSTERS
if($action == "editmonsters") {

if($_REQUEST['todo'] == "setall") {
$visibility = $_REQUEST['visibility'];
if($visibility == "visible") {
try { $SQL->query('UPDATE z_monsters SET hide_creature = 0'); } catch(PDOException $error) {}
$main_content .= '<h3>All creatures are now VISIBLE!</h3>';
}
elseif($visibility == "hidden") {
try { $SQL->query('UPDATE z_monsters SET hide_creature = 1'); } catch(PDOException $error) {}
$main_content .= '<h3>All creatures are now HIDDEN!</h3>';
}
}

if($_REQUEST['todo'] == "editgfxlink") {
$monster_name = stripslashes($_REQUEST['monster']);
$new_link = stripslashes($_REQUEST['new_link']);
if(empty($_REQUEST['savenewgfxlink'])) {
$show_list = "no";
try { $monster = $SQL->query('SELECT * FROM z_monsters WHERE name = '.$SQL->quote($monster_name).';')->fetch(); } catch(PDOException $error) {}
$main_content .= '<center><h2>Edit link</h2></center><b>Link to image: </b>'.$config['server']['url'].'/monsters/<form action="?subtopic=adminpanel&action=editmonsters&todo=editgfxlink" method=POST><input type="hidden" name="savenewgfxlink" value="yes"><input type="hidden" name="monster" value="'.$monster_name.'"><input type="text" name="new_link" value="'.$monster['gfx_name'].'"><input type="submit" value="Save"></form>';
} else {
try { $SQL->query('UPDATE z_monsters SET gfx_name = '.$SQL->quote($new_link).' WHERE name = '.$SQL->quote($monster_name).';'); } catch(PDOException $error) {}
$main_content .= 'New link <b>'.$new_link.'</b> to <b>'.$monster_name.'</b> has been saved.<br/>';
}
}

if($_REQUEST['todo'] == "hide_monsters") {
$main_content .= '<center><h2>Hide monsters</h2></center>Monsters:<b>';
foreach($_REQUEST['hide_array'] as $monster_to_hide) {
$main_content .= '<li>'.$monster_to_hide;
try { $SQL->query('UPDATE z_monsters SET hide_creature = 1 WHERE name = '.$SQL->quote(stripslashes($monster_to_hide)).';'); } catch(PDOException $error) {}
}
$main_content .= '</b><br/>are now HIDDEN.';
}

if($_REQUEST['todo'] == "show_monsters") {
$main_content .= '<center><h2>Show monsters</h2></center>Monsters:<b>';
foreach($_REQUEST['show_array'] as $monster_to_hide) {
$main_content .= '<li>'.$monster_to_hide;
try { $SQL->query('UPDATE z_monsters SET hide_creature = 0 WHERE name = '.$SQL->quote(stripslashes($monster_to_hide)).';'); } catch(PDOException $error) {}
}
$main_content .= '</b><br/>are now VISIBLE.';
}

if($show_list != "no") {
//visible monsters list
try { $monsters = $SQL->query('SELECT * FROM z_monsters WHERE hide_creature != 1 ORDER BY name'); } catch(PDOException $error) {}
$main_content .= '<center><h2>Edit monsters</h2></center><h3>Visible monsters</h3><h4><a href="?subtopic=adminpanel&action=editmonsters&todo=setall&visibility=hidden">Set all monsters HIDDEN</a></h4><form action="?subtopic=adminpanel&action=editmonsters&todo=hide_monsters" method=POST><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD CLASS=white width="200"><B><font CLASS=white>Photo</B></TD><TD CLASS=white width="200"><B><font CLASS=white>Edit photo</B></TD><TD CLASS=white width="200"><B><font CLASS=white>Name</B></TD><TD CLASS=white><B><font CLASS=white>Health</B></TD><TD CLASS=white><B><font CLASS=white>Experience</B></TD><TD CLASS=white><B><font CLASS=white>Hide Creature</B></TD></TR>';
foreach($monsters as $monster) {
if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>';
if(file_exists('monsters/'.$monster['gfx_name'])) {
$main_content .= '<img src="monsters/'.$monster['gfx_name'].'" height="40" width="40">';
} else {
$main_content .= '<img src="monsters/nophoto.png" height="40" width="40">';
}
$main_content .= '</TD><TD><a href="?subtopic=adminpanel&action=editmonsters&todo=editgfxlink&monster='.urlencode($monster['name']).'">Change image name</a></TD><TD>'.$monster['name'].'</TD><TD>'.$monster['health'].'</TD><TD>'.$monster['exp'].'</TD><TD><input type="checkbox" name="hide_array[]" value="'.$monster['name'].'"></TD>';
}
$main_content .= '<TR><TD></TD><TD></TD><TD></TD><TD>Hide</TD><TD>monsters:</TD><TD><input type="submit" value="Hide monsters"></TD></TR></TABLE></form>';

//hidden monsters list
try { $monsters = $SQL->query('SELECT * FROM z_monsters WHERE hide_creature != 0 ORDER BY name'); } catch(PDOException $error) {}
$main_content .= '<h3>Hidden monsters:</h3><h4><a href="?subtopic=adminpanel&action=editmonsters&todo=setall&visibility=visible">Set all monsters VISIBLE</a></h4><form action="?subtopic=adminpanel&action=editmonsters&todo=show_monsters" method=POST><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD CLASS=white width="200"><B><font CLASS=white>Photo</B></TD><TD CLASS=white width="200"><B><font CLASS=white>Edit photo</B></TD><TD CLASS=white width="200"><B><font CLASS=white>Name</B></TD><TD CLASS=white><B><font CLASS=white>Health</B></TD><TD CLASS=white><B><font CLASS=white>Experience</B></TD><TD CLASS=white><B><font CLASS=white>Hide Creature</B></TD></TR>';
foreach($monsters as $monster) {
if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>';
if(file_exists('monsters/'.$monster['gfx_name'])) {
$main_content .= '<img src="monsters/'.$monster['gfx_name'].'" height="40" width="40">';
} else {
$main_content .= '<img src="monsters/nophoto.png" height="40" width="40">';
}
$main_content .= '</TD><TD><a href="?subtopic=adminpanel&action=editmonsters&todo=editgfxlink&monster='.$monster['name'].'">Change image name</a></TD><TD>'.$monster['name'].'</TD><TD>'.$monster['health'].'</TD><TD>'.$monster['exp'].'</TD><TD><input type="checkbox" name="show_array[]" value="'.$monster['name'].'"></TD>';
}
$main_content .= '<TR><TD></TD><TD></TD><TD></TD><TD>Show</TD><TD>monsters:</TD><TD><input type="submit" value="Show monsters"></TD></TR></TABLE></form>';
}
$main_content .= '<center><form action="?subtopic=adminpanel" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center>';
}

//EDIT SPELLS
if($action == "editspells") {
if(!empty($_REQUEST['allspells'])) {
if($_REQUEST['allspells'] == 'visible') {
try { $SQL->query('UPDATE z_spells SET hide_spell = "0"'); } catch(PDOException $error) {}
$main_content .= 'All spells are now <b>visible</b>!';
}
elseif($_REQUEST['allspells'] == 'hidden') {
try { $SQL->query('UPDATE z_spells SET hide_spell = "1"'); } catch(PDOException $error) {}
$main_content .= 'All spells are now <b>hidden</b>!';
}
}
if($_REQUEST['savespell'] == "yes") {
if(!empty($_REQUEST['spell_name'])) {
if($_REQUEST['visible'] == "yes") {
try { $SQL->query('UPDATE z_spells SET hide_spell = 0 WHERE name = "'.$_REQUEST['spell_name'].'"'); } catch(PDOException $error) {}
$main_content .= "<b>'".$_REQUEST['spell_name']."'</b> is now VISIBLE!";
}
if($_REQUEST['visible'] == "no") {
try { $SQL->query('UPDATE z_spells SET hide_spell = "1" WHERE name = "'.$_REQUEST['spell_name'].'"'); } catch(PDOException $error) {}
$main_content .= "<b>'".$_REQUEST['spell_name']."'</b> is now HIDDEN!";
}
}
}
try { $spells = $SQL->query('SELECT * FROM z_spells ORDER BY name'); } catch(PDOException $error) {}
$main_content .= '<FORM ACTION="?subtopic=adminpanel&action=editspells" METHOD=post><input type="hidden" name="savespell" value="yes">
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR='.$config['site']['vdarkborder'].'><TD CLASS=white><B>Set spell visible or hidden</B></TD></TR>
<TR BGCOLOR='.$config['site']['darkborder'].'><TD><b>Spell: </b><SELECT NAME="spell_name">';
foreach($spells as $spell) {
$main_content .= '<OPTION VALUE="'.$spell['name'].'">'.$spell['name'];
if($spell['hide_spell'] == 1) {
$main_content .= ' (hidden)';
} else {
$main_content .= ' (visible)';
}
}
$main_content .= '</SELECT><b>Visible:</b> Yes<input type="radio" name="visible" value="yes" />No<input type="radio" name="visible" value="no" />&nbsp;&nbsp;&nbsp;<INPUT TYPE=image NAME="Submit" ALT="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD><TR>
</TABLE></FORM>';
//show visible spells
$main_content .= '<h3>Visible spells list:</h3><a href="?subtopic=adminpanel&action=editspells&allspells=hidden">Set all spells: HIDDEN</a><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD><B><font CLASS=white>Name</font></B></TD><TD><B><font CLASS=white>Sentence</font></a></B></TD><TD><B><font CLASS=white>Type<br/>(count)</font></B></TD><TD><B><font CLASS=white>Mana</font></B></TD><TD><B><font CLASS=white>Exp.<br/>Level</font></B></TD><TD><B><font CLASS=white>Magic<br/>Level</font></B></TD><TD><B><font CLASS=white>Soul</font></B></TD><TD CLASS=white><B>Need<br/>PACC?</B></TD></TR>';
try { $spells = $SQL->query('SELECT * FROM z_spells ORDER BY name'); } catch(PDOException $error) {}
foreach($spells as $spell) {
if($spell['hide_spell'] == "0") {
if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>'.$spell['name'].'</TD><TD>'.$spell['spell'].'</TD>';
if($spell['spell_type'] == 'conjure') {
$main_content .= '<TD>'.$spell['spell_type'].'('.$spell['conj_count'].')</TD>';
}
else
{
$main_content .= '<TD>'.$spell['spell_type'].'</TD>';
}
$main_content .= '<TD>'.$spell['mana'].'</TD><TD>'.$spell['lvl'].'</TD><TD>'.$spell['mlvl'].'</TD><TD>'.$spell['soul'].'</TD><TD>'.$spell['pacc'].'</TD></TR>';
}
}
$main_content .= '</TABLE>';
//show hidden spells
$main_content .= '<h3>Hidden spells list:</h3><a href="?subtopic=adminpanel&action=editspells&allspells=visible">Set all spells: VISIBLE</a><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD><B><font CLASS=white>Name</font></B></TD><TD><B><font CLASS=white>Sentence</font></a></B></TD><TD><B><font CLASS=white>Type<br/>(count)</font></B></TD><TD><B><font CLASS=white>Mana</font></B></TD><TD><B><font CLASS=white>Exp.<br/>Level</font></B></TD><TD><B><font CLASS=white>Magic<br/>Level</font></B></TD><TD><B><font CLASS=white>Soul</font></B></TD><TD CLASS=white><B>Need<br/>PACC?</B></TD></TR>';
try { $spells = $SQL->query('SELECT * FROM z_spells ORDER BY name'); } catch(PDOException $error) {}
foreach($spells as $spell) {
if($spell['hide_spell'] == "1") {
if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>'.$spell['name'].'</TD><TD>'.$spell['spell'].'</TD>';
if($spell['spell_type'] == 'conjure') {
$main_content .= '<TD>'.$spell['spell_type'].'('.$spell['conj_count'].')</TD>';
}
else
{
$main_content .= '<TD>'.$spell['spell_type'].'</TD>';
}
$main_content .= '<TD>'.$spell['mana'].'</TD><TD>'.$spell['lvl'].'</TD><TD>'.$spell['mlvl'].'</TD><TD>'.$spell['soul'].'</TD><TD>'.$spell['pacc'].'</TD></TR>';
}
}
$main_content .= '</TABLE><br/><center><form action="?subtopic=adminpanel" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center>';
}

//INSTALL MONSTERS
if($action == "install_monsters") {
try { $SQL->query("DELETE FROM ".$SQL->tableName('z_monsters').";"); } catch(PDOException $error) {}
$main_content .= '<h2>Reload monsters.</h2>';
$main_content .= '<h2>All records deleted from table \'z_monsters\' in database.</h2>';
$allmonsters = new OTS_MonstersList($config['site']['server_path']."data/monster/");
//$names_added must be an array
$names_added[] = '';
//add monsters
foreach($allmonsters as $lol) {
$monster = $allmonsters->current();
//load monster mana needed to summon/convince
$mana = $monster->getManaCost();
//load monster experience
$exp = $monster->getExperience();
//load monster name
$name = ucwords($monster->getName());
//load monster health
$health = $monster->getHealth();
//load monster speed and calculate "speed level"
$speed_ini = $monster->getSpeed();
if($speed_ini <= 220) {
$speed_lvl = 1;
} else {
$speed_lvl = ($speed_ini - 220) / 2;
}
//check "is monster use haste spell"
$defenses = $monster->getDefenses();
$use_haste = 0;
foreach($defenses as $defense) {
if($defense == 'speed') {
$use_haste = 1;
}
}
//load monster flags
$flags = $monster->getFlags();
//create string with immunities
$immunities = $monster->getImmunities();
$imu_nr = 0;
$imu_count = count($immunities);
$immunities_string = '';
foreach($immunities as $immunitie) {
$immunities_string .= $immunitie;
$imu_nr++;
if($imu_count != $imu_nr) {
$immunities_string .= ", ";
}
}
//create string with voices
$voices = $monster->getVoices();
$voice_nr = 0;
$voice_count = count($voices);
$voices_string = '';
foreach($voices as $voice) {
$voices_string .= '"'.$voice.'"';
$voice_nr++;
if($voice_count != $voice_nr) {
$voices_string .= ", ";
}
}
//load race
$race = $monster->getRace();
//create monster gfx name
$gfx_name =  str_replace(" ", "", trim(mb_strtolower($name))).".gif";
//don't add 2 monsters with same name, like Butterfly
if(!in_array($name, $names_added)) {
try { $SQL->query('INSERT INTO '.$SQL->tableName('z_monsters').' (hide_creature, name, mana, exp, health, speed_lvl, use_haste, voices, immunities, summonable, convinceable, race, gfx_name) VALUES (0, '.$SQL->quote($name).', '.$mana.', '.$exp.', '.$health.', '.$speed_lvl.', '.$use_haste.', '.$SQL->quote($voices_string).', '.$SQL->quote($immunities_string).', '.$flags['summonable'].', '.$flags['convinceable'].', '.$SQL->quote($race).', '.$SQL->quote($gfx_name).');'); } catch(PDOException $error) {}
$names_added[] = $name;
$main_content .= "'".strtolower($name)."', ";
}
}
//back button
$main_content .= '<center><form action="?subtopic=adminpanel" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center>';
}

//SPELLS
if($action == "install_spells") {
try { $SQL->query("DELETE FROM ".$SQL->tableName('z_spells').";"); } catch(PDOException $error) {}
$main_content .= '<h2>Reload spells.</h2>';
$main_content .= '<h2>All records deleted from table \'z_spells\' in database.</h2>';
foreach($vocation_name['0'] as $voc_id => $voc_name)
$vocations_ids[$voc_name] = $voc_id;
$allspells = new OTS_SpellsList($config['site']['server_path']."data/spells/spells.xml");
//add conjure spells
$conjurelist = $allspells->getConjuresList();
$main_content .= "<h3>Conjure:</h3>";
foreach($conjurelist as $spellname)
{
	$spell = $allspells->getConjure($spellname);
	$lvl = $spell->getLevel();
	$mlvl = $spell->getMagicLevel();
	$mana = $spell->getMana();
	$name = $spell->getName();
	$soul = $spell->getSoul();
	$spell_txt = $spell->getWords();
	$vocations = $spell->getVocations();
	
	
	$vocations_to_db = "";
	$voc_nr = 0;
	foreach($vocations as $vocation_to_add_name)
	{
		$voc_str = '';
		foreach($vocation_name as $prom => $arr)
			foreach($arr as $voc_id => $voc_name)
				if($vocation_to_add_name == $voc_name)
					$voc_str = $prom.';'.$voc_id;
		if(!empty($voc_str))
		{
			$vocations_to_db .= $voc_str;
			$voc_nr++;
			if($voc_nr != count($vocations))
				$vocations_to_db .= ',';
		}
	}
	
	$enabled = $spell->isEnabled();
	if($enabled)
		$hide_spell = 0;
	else
		$hide_spell = 1;
	$pacc = $spell->isPremium();
	if($pacc)
		$pacc = 'yes';
	else
		$pacc = 'no';
	$type = 'conjure';
	$count = $spell->getConjureCount();
	try { $SQL->query('INSERT INTO '.$SQL->tableName('z_spells').' (name, spell, spell_type, mana, lvl, mlvl, soul, pacc, vocations, conj_count, hide_spell) VALUES ('.$SQL->quote($name).', '.$SQL->quote($spell_txt).', \''.$type.'\', \''.$mana.'\', \''.$lvl.'\', \''.$mlvl.'\', \''.$soul.'\', \''.$pacc.'\', '.$SQL->quote($vocations_to_db).', \''.$count.'\', \''.$hide_spell.'\')'); } catch(PDOException $error) {}
	$main_content .= "Added: ".$name."<br>";
}
//add instant spells
$instantlist = $allspells->getInstantsList();
$main_content .= "<h3>Instant:</h3>";
foreach($instantlist as $spellname)
{
$spell = $allspells->getInstant($spellname);
$lvl = $spell->getLevel();
$mlvl = $spell->getMagicLevel();
$mana = $spell->getMana();
$name = $spell->getName();
$soul = $spell->getSoul();
$spell_txt = $spell->getWords();
$vocations = $spell->getVocations();


	$vocations_to_db = "";
	$voc_nr = 0;
	foreach($vocations as $vocation_to_add_name)
	{
		$voc_str = '';
		foreach($vocation_name as $prom => $arr)
			foreach($arr as $voc_id => $voc_name)
				if($vocation_to_add_name == $voc_name)
					$voc_str = $prom.';'.$voc_id;
		if(!empty($voc_str))
		{
			$vocations_to_db .= $voc_str;
			$voc_nr++;
			if($voc_nr != count($vocations))
				$vocations_to_db .= ',';
		}
	}


$enabled = $spell->isEnabled();
if($enabled) {
$hide_spell = 0;
}
else
{
$hide_spell = 1;
}
$pacc = $spell->isPremium();
if($pacc) {
$pacc = 'yes';
}
else
{
$pacc = 'no';
}
$type = 'instant';
$count = 0;
try { $SQL->query('INSERT INTO z_spells (name, spell, spell_type, mana, lvl, mlvl, soul, pacc, vocations, conj_count, hide_spell) VALUES ('.$SQL->quote($name).', '.$SQL->quote($spell_txt).', \''.$type.'\', \''.$mana.'\', \''.$lvl.'\', \''.$mlvl.'\', \''.$soul.'\', \''.$pacc.'\', '.$SQL->quote($vocations_to_db).', \''.$count.'\', \''.$hide_spell.'\')'); } catch(PDOException $error) {}
$main_content .= "Added: ".$name."<br/>";
}
$main_content .= '<center><form action="?subtopic=adminpanel" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center>';
}

}
else
{
$main_content .= 'You don\'t have admin access.';
$main_content .= '<center><form action="" METHOD=post><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Back" alt="Back" src="'.$layout_name.'/images/buttons/_sbutton_back.gif" ></div></div></form></center>';
}
?>
 
Last edited:
hi im using VERSION 0.3.1a: and have a problme i do i make it so you can choose a voc instead of having a no voc and how do i fix what they start with and what lvl they start at plz help i need this fixed fast
 
Gesior, i think that the script on TFS onlogin isnt working, i just get an error and spams of that item he selected, when he bought .

Im using TFS beta3, when it was beta2 it was working perfectly, do you know what can i do?
 
Rufo said:
Gesior, i think that the script on TFS onlogin isnt working, i just get an error and spams of that item he selected, when he bought .

Im using TFS beta3, when it was beta2 it was working perfectly, do you know what can i do?
Click to expand...
...
OR IF YOU USE NEW VERSION OF TFS 0.3 (alpha1 or new):
beta 0.3 installation (test on alpha4) - not in login.lua / globals.lua!:
in data/globalevent/globalevents.xml add:
...
Click to expand...
http://otland.net/f118/ver-0-1-0-gesior-item-pacc-shop-php-lua-forgotten-server-5772/
 
use in mysql:
turn off all the players and use this command:

UPDATE players SET town_id=1, posx=1000, posy=1000, posz=1000;

modify town_id, posx, posy, posz to the desired settings.
make back-up.
 
Hey guys Im using Gesior acc maker for TFS 0.2 and Im wondering some stuff I think somebody here knows about it, first of all, am I the only one whose guilds (on website) are "bugged"?

Which means, they cannot be modified like in RL tibia site with pics and guild message and such because even if you're logged from your account and you are the leader, in your guild's page there are no buttons for that or anything.. you also cant delete your own guild, so is it just to me? am I doing something wrong or do I need to do something else to make them work?

Second, how can I possibly make like a "pre-homepage" that lets you choose on which language you want to see the whole website, like on DovuX - Free Multiplayer Online Role Playing Game - MMORPG I mean I will obviously make all the translations on my site but I would like to know how to make that type of index before the real page, so the players can choose themselves and I dont have to post all my News on huge english & spanish paragraphs :/

Im a total newbie in html and Im learning by my own on the net but it never hurts to ask the pros here.

Last but not least, I would like to know if and how is it possible to make "vocation" highscores, just an extra button/list on the Highscores page that lets you see the highscores by vocation and maybe an extra one by gender?

Sorry for asking so much but its true that the best way to get help is to ask for it, and I cant think of a better place than this one.

Thanks in advance.

~Guitar Freak
 
Guitar Freak said:
Hey guys Im using Gesior acc maker for TFS 0.2 and Im wondering some stuff I think somebody here knows about it, first of all, am I the only one whose guilds (on website) are "bugged"?

Which means, they cannot be modified like in RL tibia site with pics and guild message and such because even if you're logged from your account and you are the leader, in your guild's page there are no buttons for that or anything.. you also cant delete your own guild, so is it just to me? am I doing something wrong or do I need to do something else to make them work?

Second, how can I possibly make like a "pre-homepage" that lets you choose on which language you want to see the whole website, like on DovuX - Free Multiplayer Online Role Playing Game - MMORPG I mean I will obviously make all the translations on my site but I would like to know how to make that type of index before the real page, so the players can choose themselves and I dont have to post all my News on huge english & spanish paragraphs :/

Im a total newbie in html and Im learning by my own on the net but it never hurts to ask the pros here.

Last but not least, I would like to know if and how is it possible to make "vocation" highscores, just an extra button/list on the Highscores page that lets you see the highscores by vocation and maybe an extra one by gender?

Sorry for asking so much but its true that the best way to get help is to ask for it, and I cant think of a better place than this one.

Thanks in advance.

~Guitar Freak
Click to expand...
Guilds - in config.lua (OTS):
...
-- Guilds
ingameGuildManagement = "no"
...
Click to expand...
You cant use guilds manager on site and in-game in same time.
They players can create guilds on site without bugs:
New guild. Leader must edit this text :)

Waa is guild leader of Wee.
The guild was founded on Forgotten on 27 January 2009. (HERE leader of guilds see button "Manage Guild" [logged!])
Click to expand...
In guild manager:
Option Description
Pass Leadership -Pass leadership of guild to other guild member.
Delete Guild -Delete guild, kick all members.
Change Description -Change description of guild.
Change MOTD -Change MOTD of guild.
Change guild logo -Upload new guild logo.
Click to expand...
Leader of guild can add/delete/rename/change 'level' (leader/vice/member) of rank.
Invite player, kick player, cancel invitation, change rank of player.
Each player in guild can change own 'title'.
16:35 You see yourself. You are god. You are the Leader of the Humm (Title here).
Click to expand...
Maybe I'll add vocation in highscores.
 
Status
Not open for further replies.

Similar threads

maxumic
  • Locked
[$50] OTC Advanced Guild Module
Replies
13
Views
2K
Niebieski
Niebieski
nitrox
[NT ACC] Account Manager in NextJs
Replies
13
Views
1K
Fjorda
F
Jpstafe
  • Solved
Erro Rook_Sample created(MYACC)
Replies
2
Views
412
Jpstafe
Jpstafe
Czorcik
  • Question
Highscore reborn system in acc maker
Replies
0
Views
316
Czorcik
Czorcik
Narg
[USA] [Custom / 10.98] NextGen OTServ Season 2 with Attribute Allocation, Custom Map, RPG and Build Versatility, Everyone is welcome!!
2
Replies
32
Views
4K
Narg
Narg
Nekiro
[CANADA][CUSTOM] Darkrest Online - Lumara
2 3 4
Replies
69
Views
4K
assassinho
assassinho
P
Valoria MMO
2
Replies
30
Views
3K
TheMyth
TheMyth
ralke
  • Question
AAC ZnoteAAC show killing assists at characterprofile deathlist
Replies
0
Views
235
ralke
ralke
conman
  • Question
Canary RL 13.21 - Loyalty System (and other) questions - newbie needs experienced users' help
Replies
6
Views
447
conman
conman
Mehra
[SWEDEN][13.30] Mehra Tibia | Unique Hazard Feature | Lots of QoL features | 1 year anniversary
Replies
18
Views
2K
Mehra
Mehra
Back
Top