SQL

[Sasu]

Server:

exports.scoreboard:addScoreboardColumn("Gang") 
  
function check() 
local account = getPlayerAccount(source) 
if getAccountData(account, "Gang") then 
setElementData(source, "Gang", getAccountData(account, "Gang")) 
else 
setElementData(source, "Gang", None) 
end 
end 
addEventHandler("onPlayerLogin", root, check) 
  
function crearTabla() 
check = executeSQLQuery("CREATE TABLE IF NOT EXISTS gangSystem(gangs TEXT, members TEXT, infoGang TEXT)") 
if check then 
outputDebugString("Creando tabla 'gangSystem'... Se ha creado correctamente") 
else 
outputDebugString("Ha ocurrido un error al crear las tablas") 
end 
end 
addEventHandler("onResourceStart", resourceRoot, crearTabla) 
  
function crearGang(thePlayer, gangName, liderName) 
liderText = "lider" 
infoGang = "Bienvenido al gang "..gangName.."." 
crear = executeSQLQuery("INSERT INTO gangSystem(gangs, members, infoGang) VALUES(?,?=?=?,?)", gangName, liderText, gangName, liderName, infoGang) 
local account = getPlayerAccount(thePlayer) 
setAccountData(account, "Gang", tostring(gangName)) 
setElementData(thePlayer, "Gang", tostring(gangName)) 
if crear then 
outputDebugString("Se ha creado un gang con nombre: "..gangName.." el cual el lider es "..liderName) 
end 
end 
addEvent("onCreateGang", true) 
addEventHandler("onCreateGang", resourceRoot, crearGang) 
  
function obtenerlider(playerName, info) 
if (not getElementData(source, "Gang") == "None") then 
local gangName = getElementData(source, "Gang") 
info = executeSQLQuery("SELECT infoGang FROM gangSystem WHERE ?", gangName  ) 
triggerClientEvent("gangLider", source, playerName, info) 
end 
end 
addEventHandler("onPlayerLogin", root, obtenerlider) 

Client(a part):

function crearGang(thePlayer, gangName, liderName) 
gangName = guiGetText(gangEdit) 
liderName = getPlayerName(localPlayer) 
if gangName then 
triggerServerEvent("onCreateGang", getRootElement(), getLocalPlayer(), gangName, liderName) 
end 
end 
  
function miembros(playerName, info) 
local row = guiGridListAddRow ( playerGangList ) 
guiGridListSetItemText ( playerGangList, row, nameColumn, getPlayerName ( playerName ), false, false ) 
guiSetText(infoMemo, info) 
end 
addEvent("gangLider", true) 
addEventHandler("gangLider", root, miembros) 

I want to save the info gang and set text in the infoMemo. Also I want to create a row with the leader but I cant. Can you help me?

[DNL291]

The parameters of the "onPlayerLogin" event are: thePreviousAccount, theCurrentAccount, autologin.

[Sasu]

Why in the memo appear: "table: 04D24608"?

Server:

function obtenerInfo(thePlayer) 
local gang = getElementData(thePlayer, "Gang") 
local infoGang = executeSQLQuery ( "SELECT infoGang FROM gangsName WHERE Nombre = ?", gangName ) 
triggerClientEvent("onOpenInfo", getRootElement(), tostring(infoGang)) 
end 
addEvent("onOpen", true) 
addEventHandler("onOpen", root, obtenerInfo) 

Client:

function abrir3(infoGang) 
guiSetVisible(infoWindow, true) 
guiSetVisible(gangWindow, false) 
guiSetText(infoMemo, tostring(infoGang)) 
end 
addEvent("onOpenInfo", true) 
addEventHandler("onOpenInfo", root, abrir3) 
  
function abrir2() 
triggerServerEvent("onOpen", localPlayer, localPlayer) 
end 

[Sasu]

Any idea?

[PaiN^]

Not tested !

-- Server --

function obtenerInfo( ) 
    local gang = getElementData( source, "Gang") 
    local infoGang = executeSQLQuery ( "SELECT infoGang FROM gangsName WHERE Nombre = ?", gangName ) 
    triggerClientEvent( "onOpenInfo", source, unpack(infoGang)) 
end 
addEvent("onOpen", true) 
addEventHandler("onOpen", root, obtenerInfo) 

-- Client --

function abrir3( infoGang ) 
    guiSetVisible(infoWindow, true) 
    guiSetVisible(gangWindow, false) 
    guiSetText(infoMemo, tostring(infoGang)) 
end 
addEvent("onOpenInfo", true) 
addEventHandler("onOpenInfo", root, abrir3) 
  
function abrir2() 
    triggerServerEvent("onOpen", localPlayer ) 
end 

[TAPL]

Not tested !

-- Server --

function obtenerInfo( ) 
    local gang = getElementData( source, "Gang") 
    local infoGang = executeSQLQuery ( "SELECT infoGang FROM gangsName WHERE Nombre = ?", gangName ) 
    triggerClientEvent( "onOpenInfo", source, unpack(infoGang)) 
end 
addEvent("onOpen", true) 
addEventHandler("onOpen", root, obtenerInfo) 

gangName not defined.

Wrong trigger, it will be triggered to everyone. (infoWindow will open for everyone)

[Sasu]

Not tested !

-- Server --

function obtenerInfo( ) 
    local gang = getElementData( source, "Gang") 
    local infoGang = executeSQLQuery ( "SELECT infoGang FROM gangsName WHERE Nombre = ?", gangName ) 
    triggerClientEvent( "onOpenInfo", source, unpack(infoGang)) 
end 
addEvent("onOpen", true) 
addEventHandler("onOpen", root, obtenerInfo) 

gangName not defined.

Wrong trigger, it will be triggered to everyone. (infoWindow will open for everyone)

Server:

function obtenerInfo( source ) 
    local gangName = getElementData( source, "Gang") 
    local infoGang = executeSQLQuery ( "SELECT infoGang FROM gangsName WHERE Nombre = ?", gangName ) 
    triggerClientEvent( "onOpenInfo", source, unpack(infoGang)) 
end 
addEvent("onOpen", true) 
addEventHandler("onOpen", root, obtenerInfo) 

Client:

function abrir3( infoGang ) 
    guiSetVisible(infoWindow, true) 
    guiSetVisible(gangWindow, false) 
    guiSetText(infoMemo, tostring(infoGang)) 
end 
addEvent("onOpenInfo", true) 
addEventHandler("onOpenInfo", root, abrir3) 
  
function abrir2(source) 
    triggerServerEvent("onOpen", getLocalPlayer(), getLocalPlayer() ) 
end 

When I open the memo appear this: table: 305AD600 Why?

[TAPL]

triggerClientEvent(source, "onOpenInfo", source, infoGang[1]["infoGang"]) 

[Sasu]

It works. Thank TAPL

[TAPL]

You're welcome.