Modules/MTA-MySQL/mysql hex string - Revision history

Alberto Alonso at 17:44, 5 January 2011

2011-01-05T17:44:23Z

← Older revision		Revision as of 17:44, 5 January 2011
Line 1:		Line 1:
			<pageclass class="#AA7592" subcaption="MTA-MySQL Module"></pageclass>
	__NOTOC__		__NOTOC__
	{{ModuleFunction\|MTA-MySQL}}		{{ModuleFunction\|MTA-MySQL}}

Ryden at 18:01, 14 January 2008

2008-01-14T18:01:00Z

← Older revision		Revision as of 18:01, 14 January 2008
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{ModuleFunction\|MTA-MySQL}}
	Converts a string to an hexadecimal representation of it. It is useful to insert binary data in blob fields, or to retreive and show it in your resources. It doesn't append '0x' or 'X' to the retreived string, the programmer must add it.		Converts a string to an hexadecimal representation of it. It is useful to insert binary data in blob fields, or to retreive and show it in your resources. It doesn't append '0x' or 'X' to the retreived string, the programmer must add it.

Ryden: New page: NOTOC Converts a string to an hexadecimal representation of it. It is useful to insert binary data in blob fields, or to retreive and show it in your resources. It doesn't append '0x' ...

2008-01-13T17:47:33Z

New page: __NOTOC__ Converts a string to an hexadecimal representation of it. It is useful to insert binary data in blob fields, or to retreive and show it in your resources. It doesn't append '0x' ...

New page

__NOTOC__
Converts a string to an hexadecimal representation of it. It is useful to insert binary data in blob fields, or to retreive and show it in your resources. It doesn't append '0x' or 'X' to the retreived string, the programmer must add it.

==Syntax==
<syntaxhighlight lang="lua">
string mysql_hex_string ( string theString )
</syntaxhighlight>
===Required arguments===
* '''theString:''' The string to convert

===Returns===
An hexadecimal formatted string.

==Example==
'''Example 1:''' This function receives a string with a binary file content and stores it in a blob field of the database.
<syntaxhighlight lang="lua">
function savePlayerAvatar(playerName, imgRawData)
local imgHexData = mysql_hex_string(imgRawData)
mysql_query(handler, "UPDATE account SET avatar='0x" .. imgHexData .. "' WHERE name='" .. playerName .. "'")
end
</syntaxhighlight>

==See also==
{{Modules/MTA-MySQL/Handler_functions}}

Modules/MTA-MySQL/mysql hex string - Revision history

Alberto Alonso at 17:44, 5 January 2011

Ryden at 18:01, 14 January 2008

Ryden: New page: __NOTOC__ Converts a string to an hexadecimal representation of it. It is useful to insert binary data in blob fields, or to retreive and show it in your resources. It doesn't append '0x' ...

Ryden: New page: NOTOC Converts a string to an hexadecimal representation of it. It is useful to insert binary data in blob fields, or to retreive and show it in your resources. It doesn't append '0x' ...