[SQL]

[X-SHADOW]

Hello i have A GameMode but it's on SQL who do i set SQL so the gamemod works ?

and the SQL on the hosted server or the gameMode files ?

If there is an Example or video for SQL Setup show me please

Thank's

[Castillo]

Of what game mode are you talking about?

[X-SHADOW]

it's GangWars By Jayz

the Group system it's on SQL

and also the functions how to Work on SQL ?

[Castillo]

Do you mean SQL or MySQL?

[X-SHADOW]

is this SQL Or MySQL ?

local connection = executeSQLQuery ( "CREATE TABLE IF NOT EXISTS gangs ( gangName TEXT, leader TEXT, color TEXT )" ) 
  
--[[ GANG SYSTEM ]] 
  
local cost = 20000 
local maxStr = 20 
  
function gangIsLeader ( uPlayer, uTeam ) 
    local select = executeSQLQuery ( "SELECT leader FROM gangs WHERE gangName = '" .. uTeam .. "' " ); 
    if ( select[1]["leader"] == uPlayer ) then 
        return true; 
    else 
        return false; 
    end 
end 
  
function gangSetLeader ( uTeam, uPlayer ) 
    executeSQLQuery ( "UPDATE gangs SET leader = '" .. uPlayer .. "' WHERE gangName = '" .. uTeam .. "' ") 
    return true 
end 

[iPrestege]

https://wiki.multitheftauto.com/wiki/Mysql

[X-SHADOW]

lol it's hard i wont do it lol ,

[iPrestege]

Hmm...Try to learn with this tut :

https://forum.multitheftauto.com/viewtopic.php?f=148&t=38203

[Castillo]

is this SQL Or MySQL ?

local connection = executeSQLQuery ( "CREATE TABLE IF NOT EXISTS gangs ( gangName TEXT, leader TEXT, color TEXT )" ) 
  
--[[ GANG SYSTEM ]] 
  
local cost = 20000 
local maxStr = 20 
  
function gangIsLeader ( uPlayer, uTeam ) 
    local select = executeSQLQuery ( "SELECT leader FROM gangs WHERE gangName = '" .. uTeam .. "' " ); 
    if ( select[1]["leader"] == uPlayer ) then 
        return true; 
    else 
        return false; 
    end 
end 
  
function gangSetLeader ( uTeam, uPlayer ) 
    executeSQLQuery ( "UPDATE gangs SET leader = '" .. uPlayer .. "' WHERE gangName = '" .. uTeam .. "' ") 
    return true 
end 

That'S SQL.