The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
SQL data conversion help
Hello. I have a chat set up on my forum, and bans are recorded into a table. The data recorded for bans include the IP. But the data looks like this:
I'd like to convert and record the IPs for my own personal logs. It looks like HEX, but straight conversion of HEX to string doesn't seem to return anything useful...I'm very new to MySQL data manipulation so if someone could help show me how that would be great. For additional information, this column's data type is varbinary and is using the UNHEX function. Thanks, Mike |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|