Hi, got this problem:

All my images are unable to be shown. Checked the previous threads, but no similar link there.

Extracted to correct location, but when clicking on a character's page, the icons don't appear. Same goes with all other icons.

Crusaders of Light

Example of the image link:
http://crusadersoflight.freeprohost.com ... nts_06.jpg

The upgrader should have corrected this problem but it looks like it didn't work

Try running this in phpmyadmin or similar SQL management tool

Code: Select all

UPDATE `roster_items` SET `item_texture` = REPLACE(`item_texture`,'\\\\','/');
UPDATE `roster_mailbox` SET `mailbox_coin_icon` = REPLACE(`mailbox_coin_icon`,'\\\\','/');
UPDATE `roster_mailbox` SET `item_icon` = REPLACE(`item_icon`,'\\\\','/');
UPDATE `roster_pets` SET `icon` = REPLACE(`icon`,'\\\\','/');
UPDATE `roster_players` SET `RankIcon` = REPLACE(`RankIcon`,'\\\\','/');
UPDATE `roster_recipes` SET `recipe_texture` = REPLACE(`recipe_texture`,'\\\\','/');
UPDATE `roster_spellbook` SET `spell_texture` = REPLACE(`spell_texture`,'\\\\','/');
UPDATE `roster_spellbooktree` SET `spell_texture` = REPLACE(`spell_texture`,'\\\\','/');
UPDATE `roster_talents` SET `texture` = REPLACE(`texture`,'\\\\','/');
UPDATE `roster_talenttree` SET `background` = REPLACE(`background`,'\\\\','/');

If this doesn't work, have everyone re-upload their CP.lua file

Thinks it coold be nice now ^^

Thanks loads man!
Works fine now!

There seemed to be something funny. Everytime I've updated, I gotta run the sql script again. Seems like the uploader changes the values.
Yet to confirm, will make a more complete log.

Did you make sure you overwrote all the files in your Roster with the new files from 1.7.1?

Well, i started out with 1.7.1, got it on the 27th. So see no reason for files not to be updated.
Will do a complete log of data uploaded later, gotta get out of office first:P

Hmmmm, ok... keep us updated

Ok, got these error messages:

Seems like bag slots problem...

----------------------------------------------------
Warning: array_keys(): The first argument should be an array in /home/www/jasong5.100webspace.net/forum/lib/wowdb.php on line 872

Warning: Invalid argument supplied for foreach() in /home/www/jasong5.100webspace.net/forum/lib/wowdb.php on line 872

Warning: array_keys(): The first argument should be an array in /home/www/jasong5.100webspace.net/forum/lib/wowdb.php on line 964

Warning: Invalid argument supplied for foreach() in /home/www/jasong5.100webspace.net/forum/lib/wowdb.php on line 964

Warning: array_keys(): The first argument should be an array in /home/www/jasong5.100webspace.net/forum/lib/wowdb.php on line 872

Warning: Invalid argument supplied for foreach() in /home/www/jasong5.100webspace.net/forum/lib/wowdb.php on line 872

Warning: array_keys(): The first argument should be an array in /home/www/jasong5.100webspace.net/forum/lib/wowdb.php on line 872

Warning: Invalid argument supplied for foreach() in /home/www/jasong5.100webspace.net/forum/lib/wowdb.php on line 872

These codes were generated after uploading, following the error messages.

A SQL query sample that I think is having problems:


--------------------------------------------

INSERT INTO `roster_items` SET `member_id` = 12, `item_name` = 'Bank Contents', `item_parent` = 'bags', `item_slot` = 'Bank Contents', `item_color` = 'ffffffff', `item_id` = '', `item_texture` = 'Interface\\Icons\\INV_Misc_Bag_07', `item_tooltip` = 'Bank Contents\n24 Slot Container', `item_quantity` = 24
INSERT INTO `roster_items` SET `member_id` = 12, `item_name` = 'Tigerseye', `item_parent` = 'Bank Contents', `item_slot` = 1, `item_color` = 'ff1eff00', `item_id` = '818:0:0:0', `item_texture` = 'Interface\\\\Icons\\\\INV_Misc_Gem_Opal_03', `item_tooltip` = 'Tigerseye\n', `item_quantity` = 5
INSERT INTO `roster_items` SET `member_id` = 12, `item_name` = 'Malachite', `item_parent` = 'Bank Contents', `item_slot` = 2, `item_color` = 'ff1eff00', `item_id` = '774:0:0:0', `item_texture` = 'Interface\\\\Icons\\\\INV_Misc_Gem_Emerald_03', `item_tooltip` = 'Malachite\n', `item_quantity` = 2

Hey Zanix,

Checked out the CP, and found the error is there. All textures in CP came with double \.

I'm not too familiar with string trimming in php, but I believe that should be the solution for this. Is there a Trim() function?

A CP Texture extract example:

Code: Select all

["Improved Nature's Grasp"] = {
                  ["Location"] = "1:3",
                  ["Tooltip"] = "Improved Nature's Grasp<br>Rank 0/4<br>Requires 1 point in Nature's Grasp<br>Increases the chance for your Nature's Grasp to entangle an enemy by 15%.",
                  ["Rank"] = "0:4",
                  ["Texture"] = "Interface\\Icons\\Spell_Nature_NaturesWrath",
               },

No, your CP.lua file looks fine

See mine

Code: Select all

[1] = {
   ["Quantity"] = 4,
   ["Name"] = "Noggenfogger Elixir",
   ["Color"] = "ffffffff",
   ["Tooltip"] = "Noggenfogger Elixir<br>Soulbound<br>Requires Level 35<br>Use: Drink Me.",
   ["Item"] = "8529:0:0:233492020",
   ["Texture"] = "Interface\\Icons\\INV_Potion_83",
},

wowdb.php should be converting those slashes into html slashes ( \\ to / )
Here's an example

Code: Select all

    function make_item( $item_data, $memberId, $parent, $slot_name )
    {
        $item = array();
        $item['member_id'] = $memberId;
        $item['item_name'] = $item_data['Name'];
        $item['item_parent'] = $parent;
        $item['item_slot'] = $slot_name;
        $item['item_color'] = $item_data['Color'];
        $item['item_id'] = $item_data['Item'];
        $item['item_texture'] = str_replace('\\\\','/', $item_data['Texture']);

        if( isset( $item_data['Quantity'] ) )
            $item['item_quantity'] = $item_data['Quantity'];

        if( !empty($item_data['Tooltip']) )
            $item['item_tooltip'] = $this->tooltip( $item_data['Tooltip'] );
        else
            $item['item_tooltip'] = $item_data['Name'];

        return $item;
    } 

This line does the conversion

Code: Select all

$item['item_texture'] = str_replace('\\\\','/', $item_data['Texture']); 

Now, there are multiple places that this happens
Here is every line that converts those slashes

Code: Select all

$mail['mail_coin_icon'] = str_replace('\\\\','/', $mail_data['CoinIcon']);
...
$item['item_texture'] = str_replace('\\\\','/', $item_data['Texture']);
...
$recipe['recipe_texture'] = str_replace('\\\\','/', $recipe_data['Texture']);
...
$this->add_value('spell_texture', str_replace('\\\\','/', $data_spell_name['Texture']) );
...
$this->add_value('spell_texture', str_replace('\\\\','/', $data_spell_type['Texture']) );
...
$tree_background = str_replace('\\\\','/', $data_talent_skill);
...
$this->add_value('texture', str_replace('\\\\','/', $data_talent_skill['Texture']) );
...
$this->add_value( 'icon', str_replace('\\\\','/', $data['Icon']));
...
$this->add_value( 'RankIcon', str_replace('\\\\','/', $honor['Current']['Icon']) ); 

Now for some reason, this isn't happening

Ok Zanix, checked the file out. For some reason, my file has not been updated with the string replacers.

File version is: $Id: wowdb.php 63 2006-06-14 22:30:35Z mathos $

Did the changes and only the icon for rank does not work.
Searched for the var, but only found this:

Code: Select all

$this->add_value( 'RankIcon', $[b]data[/b]['Honor']['Current']['Icon'] );

The icon on the main page resulted in this:- /img/.gif

Hmmm, what are you using to upload the files?

I'm using the web page to upload, update.php