User panel DB on web

[papam77]

Hey, i want saving user panel db to web. How can do it ?

------------------------------------------ 
-- Load & Save Data 
------------------------------------------ 
function loadPlayerData (player,datatype) 
  local playerSerial = getPlayerSerial (player) 
  if (playerSerial) then 
    local root = xmlLoadFile ("DataBase.xml") 
    if (root) then 
      local usersNode = xmlFindChild (root,"user",0) 
      if (usersNode) then 
        local playerRootNode = xmlFindChild (usersNode,"SERIAL_" .. playerSerial,0) 
        if not (playerRootNode == false) then 
          local playerData = xmlNodeGetAttribute (playerRootNode,datatype) 
          if (playerData) then 
            xmlUnloadFile (root) 
            --outputDebugString("---- LoadD: "..getPlayerName(player).."   ,   "..datatype.."   ,   "..playerData) 
            return playerData 
          else 
            xmlNodeSetAttribute (playerRootNode,datatype,0) 
            xmlSaveFile (root) 
            xmlUnloadFile (root) 
            --outputDebugString("---- LoadD: "..getPlayerName(player).."   ,   "..datatype.."   ,   0") 
            return 0         
          end 
        else 
          local playerRootNode = xmlCreateChild (usersNode,"SERIAL_" .. playerSerial) 
          xmlNodeSetAttribute (playerRootNode,datatype,0) 
          xmlSaveFile (root) 
          xmlUnloadFile (root) 
          --outputDebugString("---- LoadD: "..getPlayerName(player).."   ,   "..datatype.."   ,   0") 
          return 0  
        end 
      end 
    end 
  end 
end 
  
function savePlayerData (player,datatype,newvalue) 
  local playerSerial = getPlayerSerial (player) 
  if (playerSerial) then 
    local root = xmlLoadFile ("DataBase.xml") 
    if (root) then 
      local usersNode = xmlFindChild (root,"user",0) 
      if (usersNode) then 
        local playerRootNode = xmlFindChild (usersNode,"SERIAL_" .. playerSerial,0) 
        if not (playerRootNode == false) then 
          local newNodeValue = xmlNodeSetAttribute (playerRootNode,datatype,newvalue) 
          xmlSaveFile (root) 
          xmlUnloadFile (root) 
          --outputDebugString("---- SaveD: "..getPlayerName(player).."   ,   "..datatype.."   ,   "..newvalue) 
          return newNodeValue 
        else 
          local playerRootNode = xmlCreateChild (usersNode,"SERIAL_" .. playerSerial) 
          local newNodeValue = xmlNodeSetAttribute (playerRootNode,datatype,newvalue) 
          xmlSaveFile (root) 
          xmlUnloadFile (root) 
          --outputDebugString("---- SaveD: "..getPlayerName(player).."   ,   "..datatype.."   ,   "..newvalue) 
          return newNodeValue 
        end 
      end 
    end 
  end 
end 

to ----> http://kfc-gaming.eu/DataBase.xml

[Gallardo9944]

save your data at MySQL database and then read it from your site.

  
dbConnect() 
dbQuery() 
  

These functions will help you.

[papam77]

full script please

[manve1]

full script please

why would u need full script while problem isn't in whole script? just maybe in one line

[papam77]

full script please

why would u need full script while problem isn't in whole script? just maybe in one line

But i am not scripter

I can only html and css

[iPrestege]

full script please

why would u need full script while problem isn't in whole script? just maybe in one line

But i am not scripter

I can only html and css

Learn Lua .?

[papam77]

Learn Lua .?

Too hard for my brain

[manve1]

take your time, it took me 8months to learn ..

[tosfera]

Learn Lua .?

Too hard for my brain

if learning lua is to hard for your brain, start at the highest point and jump down!

With saying that I mean, you want to learn lua and also make something usefull for your self, so... Create a script that saves the user information into a database, just keep it simple first. Save the serial of an user in a table, you can use the function dbConnect and executeSQLQuery for that.

First thing to do is create a dbconnection

  
dbConnect( "sqlite", "file.db" ) -- string databaseType, string host  
  

after you got the connection to your database, you can start selecting and inserting stuff. Before you can do this, you need to have alitle knowledge about SQL. but the functions you're going to use are;

  
create table 
insert 
select 
  

to help you into the right direction:

  
local dbType = "sqlite" 
local dbFile = "mtaServer.db" 
  
addEventHandler("onResourceStart", root, 
    function () 
        local create = executeSQLQuery("CREATE TABLE IF NOT EXISTS `players` (`serial` TEXT)") 
        if ( create ) then 
            outputChatBox("Table created!") 
        end 
    end 
) 
  
addCommandHandler("saveSerial", 
    function ( source ) 
        local serial = getPlayerSerial( source ) 
        local insert = executeSQLQuery("INSERT INTO players(serial) VALUES(?)", serial ) 
        if ( insert ) then 
            outputChatBox("Serial saved into the db!") 
        end 
    end 
) 
  

(haven't tested it)

[papam77]

A joining to DB file is this code ?

local function connect( ) 
    -- retrieve the settings 
    local server = get( "server" ) or "localhost" 
    local user = get( "user" ) or "root" 
    local password = get( "password" ) or "" 
    local db = get( "database" ) or "mta" 
    local port = get( "port" ) or 3306 
    local socket = get( "socket" ) or nil