Serials

[Wei]

So... I'm making a ban system. Depends on what could I put banned serials/IPs. In xml or how ?

I wanna make it on command not to add it in script.

[Castillo]

You can do it MySQL/SQLite/XML based.

[Wei]

how can I make it XML based what I put as value of node or how ?

[Castillo]

Check the XML functions, start reading about how it works, do test scripts, then you can proceed with a bigger one.

[Wei]

I'll try

[Wei]

executeSQLCreateTable( "banList", "playerIP TEXT" ) 
  
function saveData(source) 
executeSQLQuery( "UPDATE banList SET "..getPlayerIP(source).." WHERE playerIP" ) 
end 
addCommandHandler("set", saveData) 

what am I doing wrong ?

[Castillo]

executeSQLCreateTable( "banList", "playerIP TEXT" ) 
  
function saveData(source) 
executeSQLQuery( "UPDATE banList SET playerIP = '".. getPlayerIP ( source ) .."' WHERE playerIP = '".. getPlayerIP ( source ) .."'" ) 
end 
addCommandHandler("set", saveData) 

[Wei]

executeSQLQuery( "INSERT INTO banList playerIP VALUES '".. getPlayerIP ( source ) .."'" ) 

syntax error. Sorry but it's my first time doing with this.

[Castillo]

Try this:

executeSQLQuery( "INSERT INTO banList (playerIP) VALUES (".. getPlayerIP ( source ) ..")" ) 

[Wei]

executeSQLCreateTable( "banList", "players, playerIP TEXT" ) 
  
function saveData(source) 
executeSQLInsert ( "banList", "'"..getPlayerName(source).."', '" .. sourcename .. "'" ) 
end 
addCommandHandler("set", saveData) 
  
function exeData(source) 
ip = executeSQLSelect ( "banList", "'"..getPlayerName(source).."', 'playerIP' ") 
outputChatBox( tostring(ip) ) 
end 
addCommandHandler("get", exeData) 

why it returns table ?

[Castillo]

executeSQLCreateTable( "banList", "players, playerIP TEXT" ) 
  
function saveData ( source ) 
    executeSQLInsert ( "banList", "'"..getPlayerName(source).."', '" .. sourcename .. "'" ) 
end 
addCommandHandler("set", saveData) 
  
function exeData ( source ) 
    result = executeSQLSelect ( "banList", "playerIP", "players = '" .. getPlayerName(source) .. "'" ) 
    outputChatBox( tostring ( result [ 1 ] [ "playerIP" ] ) ) 
end 
addCommandHandler("get", exeData)