Pls help

[K4stic]

how i can make to one serial can make max 2 accounts ?

[iPrestege]

You can use SQL to save the serial !

[K4stic]

then you create account it's save the serial

[iPrestege]

Exactly and when player trying to register next time get the 'SQL' Results and check !

[K4stic]

how

[iPrestege]

executeSQLQuery 
getPlayerSerial 

[K4stic]

local serialCheck = executeSQLQuery( "SELECT * FROM accounts WHERE serial = ?", getPlayerSerial( source ) ) 

i think this is ok

[iPrestege]

Yes that's right but do you have a 'accounts' sql table?

[K4stic]

it's the default name of table

[iPrestege]

Ah,Ok Did you try it?When player trying to register add the serial to the sql table?!

[K4stic]

Error line 2 : Database query failed: no such table : accounts

Error line 3 : attempt to get lenght of local 'serialCheck' (a boolean value)

function onPlayerRegister(user,pass) 
    local serialCheck = executeSQLQuery( "SELECT * FROM accounts WHERE serial = ?", getPlayerSerial( source ) ) 
    if ( #serialCheck < 3 ) then 
    if (user) and (pass) then 
        local account = getAccount(user,pass) 
        if (account == false) then 
            addAccount(user,pass) 
            local account = getAccount(user,pass) 
            logIn(source,account,pass) 
            triggerClientEvent(source,"Login:closeLoginPanel",source) 
            exports.SCGhelp:createNewHelpMessageForPlayer( source,"You have registered!", 0, 255, 0) 
            showPlayerHudComponent(source,'all',true) 
            showChat(source,true) 
            else 
            exports.SCGhelp:createNewHelpMessageForPlayer( source,"You can only register 2 accounts for each serial!", 225, 0, 0 ) 
        end 
        else 
            exports.SCGhelp:createNewHelpMessageForPlayer( source,"That account already exists.", 255, 0, 0) 
        end 
    else 
        exports.SCGhelp:createNewHelpMessageForPlayer( source,"Fatal Register Error ~ Server Side", 255, 0, 0) 
        return 
    end 
end 
addEvent("Login:onPlayerRegister",true) 
addEventHandler("Login:onPlayerRegister",root,onPlayerRegister) 

look here the database

http://i79.servimg.com/u/f79/17/22/60/79/tables10.jpg

[iPrestege]

Try to create a custom 'SQL' Table .

[K4stic]

what you mean?

[iPrestege]

I mean create a new table for you're register system .

[K4stic]

and what will with other?

[K4stic]

maybe i use wrong the ExecuteSQLQuery

i see how use it wiki the SELECT so how make it?

https://wiki.multitheftauto.com/wiki/ExecuteSQLQuery

[iPrestege]

-- # Server Side 
addEventHandler("onResourceStart",resourceRoot, 
 function ( ) 
        executeSQLQuery("CREATE TABLE IF NOT EXISTS 'SQLRegisterTable' ( serial )") 
 end 
) 
  
function onPlayerRegister(user,pass) 
    if (user) and (pass) then 
        local account = getAccount(user,pass) 
        if (account == false) then 
   local serial = getPlayerSerial(source) 
   local serialCheck = executeSQLQuery( "SELECT * FROM 'SQLRegisterTable' WHERE serial = ?",serial ) 
   if ( type ( serialCheck ) == "table" and #serialCheck == 0 ) or not serialCheck then 
    executeSQLQuery ( "INSERT INTO SQLRegisterTable ( serial ) VALUES ( ? )", serial )  
   elseif #serialCheck == 1 then 
    executeSQLQuery ( "INSERT INTO SQLRegisterTable ( serial ) VALUES ( ? )", serial )  
   else  
    return exports.SCGhelp:createNewHelpMessageForPlayer( source,"You can only register 2 accounts for each serial!", 225, 0, 0 ) 
   end    
            addAccount(user,pass) 
            local account = getAccount(user,pass) 
            logIn(source,account,pass) 
            exports.SCGhelp:createNewHelpMessageForPlayer( source,"You have registered!", 0, 255, 0) 
            showPlayerHudComponent(source,'all',true) 
            showChat(source,true) 
        else 
            exports.SCGhelp:createNewHelpMessageForPlayer( source,"That account already exists.", 255, 0, 0) 
        end 
    else 
        exports.SCGhelp:createNewHelpMessageForPlayer( source,"Fatal Register Error ~ Server Side", 255, 0, 0) 
        return 
    end 
end 
addEvent("Login:onPlayerRegister",true) 
addEventHandler("Login:onPlayerRegister",root,onPlayerRegister) 

Try it.

[K4stic]

one ask i wonna make to it each serial can register max 2 accounts

[iPrestege]

Try my code and see the results .

[K4stic]

same Problem at line 13

[iPrestege]

Will i just test it and work's fine make sure it's server side and copy it again -.-

[K4stic]

i know then one script is server or Client side

[iPrestege]

-.- I Just test it and work's fine what the 'debugscript 3' Say?