Sql on internal

[Gabriel Vasconcelos]

if ( tostring ( get ( "CONNECTION_TYPE" ) ):lower() == "mysql" ) then 
	outputConsole ( "Attempting to connect as MySQL... Please wait")
	db = dbConnect( "mysql", "dbname="..tostring(get("DATABASE_NAME"))..";host="..tostring(get("MYSQL_HOST"))..";port="..tostring(get("MYSQL_PORT"))..";unix_socket=/opt/lampp/var/mysql/mysql.sock", tostring(get("MYSQL_USER")), tostring(get("MYSQL_PASS")), "share=1;autoreconnect=1" );
elseif ( tostring ( get ( "CONNECTION_TYPE" ) ):lower() == "sqlite" ) then 
	db = dbConnect ( "sqlite", tostring(get("DATABASE_NAME")) .. ".sql" );
else 
	error ( tostring(get("CONNECTION_TYPE")) .. " is an invalid SQL connection -- valid: mysql, sqlite" );
end 

if not db then
	print ( "The database has failed to connect")
	return 
else
	print ( "Database has been connected")
end

function db_query ( ... ) 
	local data = { ... }
	return dbPoll ( dbQuery ( db, ... ), - 1 )
end

function db_exec ( ... )
	return dbExec ( db, ... );
end

<meta>
    <info author="NG Scripting Team" name="NG SQL" type="script" version="1.0" />
    
    <script src="sql.lua" />
    
    <export function="db_query" />
    <export function="db_exec" />
    <export function="createAccount" />
    <export function="account_exist" />
    <export function="saveAllData" />
	
    <export function="savePlayerData" />
	
	
	<settings>
		<setting 
			name="CONNECTION_TYPE" 
			value="mysql" 
			accept="mysql, sqlite" 
			description="MySQL or SQLite connection for you database" />
		
		<setting 
			name="DATABASE_NAME" 
			value="gg" 
			accept="Strings" 
			description="Name of MySQL database, file name for SQLite" />
		
		<setting 
			name="MYSQL_HOST" 
			value="" 
			accept="Hosts" 
			description="Host for you MySQL Database"  />
			
		<setting 
			name="MYSQL_PORT"
			value="3306" 
            accept="Port #" 
			description="Port for you MySQL Database" />
			
		<setting 
			name="MYSQL_USER" 
			value="" 
			accept="Usernames" 
			description="Username for you MySQL Database" />
			
		<setting 
			name="MYSQL_PASS" 
			value="" 
			accept="Passwords" 
			description="Password for you MySQL Database" />
	</settings>
	
    <min_mta_version server="1.3.4-0.00000"></min_mta_version>
</meta>

this is the original script. I can not get it to use the server's own internal db, what to do?

[DNL291]

For MTA's SQL (registry.db) use executeSQLQuery instead

For internal.db you must use account functions - get/setAccountData.

EDIT: db functions store data in a local or external database.

Edited June 3, 2019 by DNL291