Help w/ syntax using preg_replace

AEZimmerman

I am working with Wowroster (http://www.wowroster.net) and I am just learning some PHP- not enough to amount to anything. I ran into a problem with this code- my server isn't parsing the image paths correctly. Instead of :
/img/Interface/PvPRankBadges/PvPRank01.jpg
it is parsing img/Interface//PvPRankBadges//PvPRank01.jpg and this is in multiple locations. I posted for help there but I don't understand PHP enough to implement the solution. Here's what I was told to do:

This is a problem with the db importer (lib/wowdb.php)
It doesn't remove those slashes properly and some server don't like those double slashes in a path and return nothing

There are many, many places in lib/wowdb.php that put this image info to the db

Pretty much you need to search for every place and image is prepared for insertion to the db

For example, a line that prepares an images would normally look like this
PHP:
$item['item_texture'] = $item_data['Texture'];
It needs to look like this
PHP:
$item['item_texture'] = preg_replace('|\\\\|','/', $item_data['Texture']);

There are muliple places there this needs to be done

Ok my problem is that I didn't find but a couple of places to do this and it isn't working... I think I probably need to do this where they do an addthis but I don't know what the syntax should be. I think probably in lines like this:
$this->add_value('texture', $data_talent_skill['Texture'] );

it should be added but I'm not sure how to implement that...you can see my issue at http://www.piratesofthecrown.com/roster

Thanks for all your help in advance!

Houdini

How about showing the code that is producing

img/Interface//PvPRankBadges//PvPRank01.jpg

It would be hard to jelp without seeing what the code is doing with text or possibly the path. When posting code please use the BB Code for PHP as can be seen by clicking the link in my signature.

AEZimmerman

ok, i hate to post this whole page, but I really am not sure where to cut it off since I am not positive where the problem is. You can see where I've added the lines as I was instructed to do, but you can also visit the page and see I don't have the problem fixed..

<?php


class wowdb
{
	var $db;			// Database resource id
	var $assignstr;		// Data to be inserted/updated to the db
	var $sqldebug;		//
	var $sqlstrings;	// Array of SQL strings passed to query()
	var $messages;		// Array of stored messages
	var $errors;		// Array of stored error messages
	var $membersadded=0;
	var $membersupdated=0;




/**
 * Inserts an item into the datbase
 *
 * @param string $item
 * @return bool
 */
function insert_item( $item )
{
	$this->reset_values();
	$this->add_value('member_id', $item['member_id'] );
	$this->add_value('item_name', $item['item_name'] );
	$this->add_value('item_parent', $item['item_parent'] );
	$this->add_value('item_slot', $item['item_slot'] );
	$this->add_value('item_color', $item['item_color'] );
	$this->add_value('item_id', $item['item_id'] );
	$this->add_value('item_texture', $item['item_texture'] );
	$this->add_value('item_tooltip', $item['item_tooltip'] );

	if( isset( $item['item_quantity'] ) )
		$this->add_value('item_quantity', $item['item_quantity'] );

	$querystr = "INSERT INTO `".ROSTER_ITEMSTABLE."` SET ".$this->assignstr;
	$result = $this->query($querystr);
	if( !$result )
	{
		$this->setError('Item ['.$item['item_name'].'] could not be inserted',$this->error());
	}
}

ok, this is like one section of it... does this give you an idea? I think I need to somehow modify this line

$this->add_value('item_texture', $item['item_texture'] );

Kyfa

I have the same problem as you. Except for it is doing it with all images that were installed with the image pack. Here is the full php file in a text format

http://www.emerald-temepest.com/wowdb.txt

the url for the program that is using it, (installed on my server)

http://www.emerald-temepest.com/roster/

the site it is downloaded from is

http://www.wowroster.net

all help would be much appreciated