[Problem] Data from Mu Database

Hi guys when i was pulling some data from my database i came across a problem observe:

PHP Code:

---

$dbhost   = "test";      $db       = "MuOnline";       $user     = "sa";     $password = "12345";   
    @mssql_connect($dbhost,$user,$password) or die("Não foi possível a conexão com o servidor!");    @mssql_select_db("$db") or die("Não foi possível selecionar o banco de dados!");        $sql = mssql_query('SELECT * FROM Character WHERE Name = "test"');
    $data = mssql_fetch_array ($sql);
        echo $data['Inventory']; 


---

He display this:

Code:

---

@Pÿÿÿÿÿ5`ÿÿÿÿÿ-pÿÿÿÿÿ-€ÿÿÿÿÿ-ÿÿÿÿÿ- ÿÿÿÿÿ-°ÿÿÿÿÿ
Ë"p]Àÿÿÿÿÿ
@ÐÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿàÿÿÿÿÿÿàÿÿÿÿÿB "2RÐÿÿÿÿÿÿàÿÿÿÿ

---

But in data field i have this:

Code:

---

0x0B8430002268BE04000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF011D3C0000000000007000FFFFFFFFFF011D410000000000008000FFFFFFFFFF011D3F0000000000009000FFFFFFFFFF011D37000000000000A000FFFFFFFFFF011D39000000000000B000FFFFFFFFFF0238D20021C7CD4000C000FFFFFFFFFF0100A3000000000000D000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF14101E000000000000D000FFFFFFFFFF14081E000000000000D000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF02009E000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0D000100226EED0000E000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F0001000000000000C000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF060023000000000000E000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F0001000000000000C000FFFFFFFFFF0F0001000000000000C000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF02005D000000000000E000FFFFFFFFFF0200FF000000000000E000FFFFFFFFFF0200FF000000000000E000FFFFFFFF

---

How i can display the correct data ? The field is a varbinary(3792) null. Its required convert the field when selecting or something?
Thanks for~the attention.

Use the hexdec function

Quote:

---

echo hexdec($data['Inventory']);

---

i use this

PHP Code:

---

echo hexdec($data['Inventory']); 


---

and show this number:

PHP Code:

---

34226 


---

- - - Updated - - -

but i need all this code from the field

Quote:

---

0x0B8430002268BE04000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF011D3C0000000000007000FFFFFFFFFF011D410000000000008000FFFFFFFFFF011D3F0000000000009000FFFFFFFFFF011D37000000000000A000FFFFFFFFFF011D39000000000000B000FFFFFFFFFF0238D20021C7CD4000C000FFFFFFFFFF0100A3000000000000D000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF14101E000000000000D000FFFFFFFFFF14081E000000000000D000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF02009E000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0D000100226EED0000E000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F0001000000000000C000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF060023000000000000E000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F0001000000000000C000FFFFFFFFFF0F0001000000000000C000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF02005D000000000000E000FFFFFFFFFF0200FF000000000000E000FFFFFFFFFF0200FF000000000000E000FFFFFFFF

---

Normally you should be able to see the data printed. hexdec and and bin2hex are your friends. Take a look on them

hm, looki i try this

PHP Code:

---

$dteste = bin2hex($data['Inventory']); 
echo $dteste; 


---

and show

Code:

---

051d380000000000005000ffffffffff0e1d350000000000006000ffffffffff031d2d0000000000007000ffffffffff031d2d0000000000008000ffffffffff031d2d0000000000009000ffffffffff031d2d000000000000a000ffffffffff031d2d000000000000b000ffffffffff011bcb0022705d0000c000ffffffffff010028000000000000d000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0600ff000000000000e000ffffffffff0200ff000000000000e000ffffffffff42000a002232520000d000ffffffffff0600ff000000000000e000fffffff...

---

but not

Code:

---

0B8430002268BE04000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF011D3C00000000000FFFF...

---

- - - Updated - - -

i think i'm making this wrong because i already have the hex in the field.

Quote:

---

Originally Posted by Kernal112

hm, looki i try this

PHP Code:

---

$dteste = bin2hex($data['Inventory']); 
echo $dteste; 


---

and show

Code:

---

051d380000000000005000ffffffffff0e1d350000000000006000ffffffffff031d2d0000000000007000ffffffffff031d2d0000000000008000ffffffffff031d2d0000000000009000ffffffffff031d2d000000000000a000ffffffffff031d2d000000000000b000ffffffffff011bcb0022705d0000c000ffffffffff010028000000000000d000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0600ff000000000000e000ffffffffff0200ff000000000000e000ffffffffff42000a002232520000d000ffffffffff0600ff000000000000e000fffffff...

---

but not

Code:

---

0B8430002268BE04000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF011D3C00000000000FFFF...

---

- - - Updated - - -

i think i'm making this wrong because i already have the hex in the field.

---

bin2hex should display whatever you have stored in that field. The only difference is that you won't see el 0x. Check your code. Maybe you doing something else with the data before parsing it to the bin2hex function.

hm this is so stranger because this is all code i have in page:

PHP Code:

---

$dbhost   = "test";      $db       = "MuOnline";       $user     = "sa";     $password = "12345";       @mssql_connect($dbhost,$user,$password) or die("Não foi possível a conexão com o servidor!");    @mssql_select_db("$db") or die("Não foi possível selecionar o banco de dados!");        $sql = mssql_query('SELECT * FROM Character WHERE Name = "test"');    $data = mssql_fetch_array ($sql);        $dteste = bin2hex($data['Inventory']); echo $dteste; 


---

:huh: