#27 Some bugs and fixes for web 0.4.3

[Resakier]

I've made some fixes on the web-interface.
Maybe they'll be implemented in the next update.

Fix: Try to get non existing item-pictures from thottbot
lib/item.php line 11 ff

replaced
function out( ) {
global $img_url;
global $img_suffix;

$path = $img_url .
preg_replace("|\\\|","/", $this->data['item_texture']) .
".$img_suffix";

trough
function out( ) {
global $img_url;
global $img_suffix;

$tmp_texture = preg_replace("|\\\|","/", $this->data
['item_texture']) . ".$img_suffix";

//if regular image exists, then use it
if (is_file($img_url.$tmp_texture)){
$path = $img_url . $tmp_texture;
// file does not exist
}else{
// the file has already been loaded (maybe last time)
if (is_file($img_url.preg_replace("|\\\|","/", $this->data
['item_texture']).".jpg")){
$path = $img_url.preg_replace("|\\\|","/", $this->data
['item_texture']).".jpg";
// try to get the image from thottbot
}else{
// liest den Inhalt einer Datei in einen String
$filename = "http://i.thottbot.com/".preg_replace
("|\\\|","/";, $this->data['item_texture']).".jpg";
if(is_file($filename)){
$handle = fopen ($filename, "r");
$contents = fread ($handle, filesize ($filename));
fclose ($handle);

$file = fopen($img_url.preg_replace("|\\\|","/", $this->data
['item_texture']).".jpg", 'w');
fwrite($file, $contents);
fclose($file);
$path = $img_url.preg_replace("|\\\|","/", $this->data
['item_texture']).".jpg";
echo "-----" .$path."-----";
//thottbot is not availible
}else{
$path = $img_url . $tmp_texture;
}
}
}

------------------------------------------------------------
Fix: Skills in German Version are not displayed
lib/char.php Line 11 ff

Replaced through
var $skilltypes = array( 1 => 'Klassenfertigkeiten',
2 => 'Berufe',
3 => 'Sekundäre Fertigkeiten',
4 => 'Waffenfertigkeiten',
5 => 'Rüstungssachverstand',
6 => 'Sprachen' );
------------------------------------------------------------
Fix: Tradskill-Images in German Version for
Kräuterkunde and Kürschnerei are not displayed cause
of ä and ü letters
tradeskills.php

Inserted as line 46 and 47

if($tsArray[$tsNr]=="Kräuterkunde"){
$anzPic="$img_url/Krauterkunde.gif"; }
if($tsArray[$tsNr]=="Kürschnerei"){
$anzPic="$img_url/Kurschnerei.gif"; }

And renamed the 2 images in img-folder
Kräuterkunde.gif -> Krauterkunde.gif
Kürschnerei.gif -> Kurschnerei.gif
------------------------------------------------------------

Fix: QustGroupSearch doesn't work with Quests which
have a ' in the name (like Zul'Farrak)
questList.php Line 62 ff
(replaced '\' .addslashes($_GET['zoneid']) . '\'
through "' .$_GET['zoneid'] . '")

if (isset($_GET['zoneid']) or isset($_GET['questid'])) {
echo $zquery = 'SELECT distinct zone from quests
where zone = "' .$_GET['zoneid'] . '" order by zone';

$zresult = mysql_query($zquery) or die(mysql_error());
if ($sqldebug) {
print ("<!--$query-->");
}
while($zrow = mysql_fetch_array($zresult))
{
print('<h1>'.$zrow['zone'].'</h1><br /><br />');

$qquery = 'SELECT distinct quest_name';
$qquery .= ' FROM quests';
$qquery .= ' WHERE zone = "' .$_GET['zoneid'] . '"';
$qquery .= ' ORDER BY quest_name';

$qresult = mysql_query($qquery) or die(mysql_error());
if ($sqldebug) {
print ("<!--$query-->");
}

while($qrow = mysql_fetch_array($qresult))
{

print($qrow['quest_name'].'<br /><br />');

$query = 'SELECT q.zone, q.quest_name,
q.quest_level, p.name, p.server';
$query .= ' FROM quests q, players p';
$query .= ' WHERE zone = "' .$_GET['zoneid'] . '" and
q.member_id = p.member_id and q.quest_name = "' .
addslashes($qrow['quest_name']) . '"';
$query .= ' ORDER BY q.zone, q.quest_name,
q.quest_level, p.name';

[Ole]

Logged In: YES
user_id=1282313

Hi,
I did download the latest version ... web-0.4.3.tar.gz.
but there are no tradeskills.php and questList.php?

i'd love to have a questlist.
can u help me, please.

[Nobody/Anonymous]

Logged In: NO

I've the same problem... but ... good idea's questlist