[SQL] NEED HELP

[tdthanatorn22]

------delete----------

Edited August 3, 2013 by Guest

[xXMADEXx]

Why dont you just use the default MTA functions? There more efficient.

[tdthanatorn22]

-delete-

Edited August 3, 2013 by Guest

[xXMADEXx]

use these for your database stuff:

https://wiki.multitheftauto.com/wiki/Se ... _functions

[tdthanatorn22]

use these for your database stuff:

https://wiki.multitheftauto.com/wiki/Se ... _functions

sry man uhh.. I'm a newbiw

how i can ?

[Wei]

He's using MTA Venux made by AeroXBird.

You must set the sql resource at first place at mtaserver.conf

[tdthanatorn22]

He's using MTA Venux made by AeroXBird.

You must set the sql resource at first place at mtaserver.conf

omg it's work thak you

[Wei]

You're welcome!

[tdthanatorn22]

-delete-

Edited August 3, 2013 by Guest

[Wei]

    local function connect( ) 
    -- retrieve the settings 
    local server = get( "server" ) or "127.0.0.1" -- server 
    local user = get( "user" ) or "root" -- username 
    local password = get( "password" ) or "21242722" -- password 
    local db = get( "database" ) or "rpvx" -- database 
    local port = get( "port" ) or 3306 
    local socket = get( "socket" ) or nil 

[tdthanatorn22]

-delete-

Edited August 3, 2013 by Guest

[tdthanatorn22]

When register

i got this log

INFO: Column count doesn't match value count at row 1

[Wei]

Did you execute .sql file in phpmyadmin ?

[tdthanatorn22]

-delete-

Edited August 3, 2013 by Guest

[Wei]

replace the function attemptRegister in s_account.lua with this one

function attemptRegister(thePlayer, username, password) 
    if ( username ~= "" and password ~= "" ) then 
        local success, error = exports.sql:query_free("INSERT INTO `accounts` VALUES('', '".. tostring(username) .."', '".. md5( tostring( password ) ) .."', '".. getPlayerSerial(thePlayer) .."', '0','0')") 
            if ( error ) then 
                return outputDebugString( error ) 
            else 
                return outputChatBox("Successfully registered your account!", thePlayer, 100, 0, 100)  
            end 
    end 
end 

[tdthanatorn22]

replace the function attemptRegister in s_account.lua with this one

function attemptRegister(thePlayer, username, password) 
    if ( username ~= "" and password ~= "" ) then 
        local success, error = exports.sql:query_free("INSERT INTO `accounts` VALUES('', '".. tostring(username) .."', '".. md5( tostring( password ) ) .."', '".. getPlayerSerial(thePlayer) .."', '0','0')") 
            if ( error ) then 
                return outputDebugString( error ) 
            else 
                return outputChatBox("Successfully registered your account!", thePlayer, 100, 0, 100)  
            end 
    end 
end 

oh yeah I luv u very muchhhhhhh lol

so much thanks

[Wei]

You're welcome!