Yet Another PHPBB2 --> YabbSE 1.5 Request

[[Unknown]]

Never read a book on PHP or MySQL.

# Update the messages table.
UPDATE {$db_prefix}messages
# Change the posterIP variable.  Seperate it with .'s.
SET posterIP=CONCAT_WS('.',
 # First number.  Two bytes, hex.
 CONV(SUBSTRING(posterIP, 1, 2), 16, 10),
 # Second number.  Two bytes, hex.
 CONV(SUBSTRING(posterIP, 3, 2), 16, 10),
 # Third number.  Two bytes, hex.
 CONV(SUBSTRING(posterIP, 5, 2), 16, 10),
 # Last number.... two bytes, hex.
 CONV(SUBSTRING(posterIP, 7, 2), 16, 10)
);

CONV converts between bases... base 16 (hex) to base 10 (decimal), in this case.  SUBSTRING fetches a part of the string.  CONCAT_WS puts a string together with a seperator.  So, CONCAT_WS(' ', 'a', 'b', 'c') would be 'a b c'.  It's like join().

-[Unknown]

[Shoeb Omar]

ok, that does make sense now, thanks

but, where did you learn all this?

[[Unknown]]

Please use this converter instead, it has been completely rewritten.

http://www.yabbse.org/community/index.php?board=132;action=display;threadid=23492

-[Unknown]