[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.
Re: [Problem] Data from Mu Database
Use the hexdec function
Quote:
echo hexdec($data['Inventory']);
Re: [Problem] Data from Mu Database
i use this
PHP Code:
echo hexdec($data['Inventory']);
and show this number: - - - Updated - - -
but i need all this code from the field
Quote:
0x0B8430002268BE04000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF011D3C0000000000007000FFFFFFFFFF011D410000000000008000FFFFFFFFFF011D3F0000000000009000FFFFFFFFFF011D37000000000000A000FFFFFFFFFF011D39000000000000B000FFFFFFFFFF0238D20021C7CD4000C000FFFFFFFFFF0100A3000000000000D000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF14101E000000000000D000FFFFFFFFFF14081E000000000000D000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF02009E000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0D000100226EED0000E000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F0001000000000000C000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF0600FF000000000000E000FFFFFFFFFF060023000000000000E000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0F0001000000000000C000FFFFFFFFFF0F0001000000000000C000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF02005D000000000000E000FFFFFFFFFF0200FF000000000000E000FFFFFFFFFF0200FF000000000000E000FFFFFFFF
Re: [Problem] Data from Mu Database
Normally you should be able to see the data printed. hexdec and and bin2hex are your friends. Take a look on them
Re: [Problem] Data from Mu Database
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.
Re: [Problem] Data from Mu Database
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.
Re: [Problem] Data from Mu Database
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: