plik main server

local user = {};
local player = [];
local items = ["ITPO_HEALTH_ADDON_04","ITFO_ADDON_RUM","ITFO_ADDON_MEATSOUP"];
local cotrl = {};

objects <- {
    id = [],
    el = []
}

for(local i = 0; i<getMaxSlots(); i++)
{
    player.append(0);
}

function onInit()
{
    addClass("Test",100,100,1000,"ITAR_BLOODWYN_ADDON","ITMW_ADDON_PIR1HAXE","",items);
    addClass("Test2",100,100,1000,"ITAR_THORUS_ADDON","ITMW_ADDON_PIR1HAXE","",items);
    cotrl = Cotroler;
    user = DataControl("localhost","root","","treningowy",3306);
    print(player.len());
}

addEventHandler("onInit", onInit);

function onPlayerJoin(pid)
{
    callClientFunc(pid,"getIDS",objects.id.len());
    spawnPlayer(pid);
    player[pid] = Gracz();
    cotrl.setClass(pid,player[pid]._playerCID);


}

addEventHandler("onPlayerJoin", onPlayerJoin);

function onPlayerRespawn(pid)
{
    cotrl.setClass(pid,player[pid]._playerCID);
    spawnPlayer(pid);
}

addEventHandler("onPlayerRespawn", onPlayerRespawn);

function onPlayerDead(pid, killer_id)
{

        setPlayerRespawnTime(pid,2000);
}
addEventHandler("onPlayerDead", onPlayerDead);


function cmdRegister(pid, args)
{
    local register = sscanf("ss",args);
    if(player[pid].islogged == false)
    {
        if(!register)
        {
            sendMessageToPlayer(pid,200, 200, 200, "Bledny format danych. Podaj /register login haslo");
        }

        else
        {
            //print(register[0]);
            local handle = user.createHandle();
            local result = user.querySelect("*","konta",("WHERE login = '" + register[0] + "'"));
            local numrow = mysql_num_rows(result);

            if(numrow != 0)
            {
                sendMessageToPlayer(pid,200, 200, 200, "Konto juz istnieje o takim loginie. Zaloguj sie /login lub zarejestruj nowe konto /register.");

            }
            else
            {
                local dane = [register[0],register[1],0,0];
                user.queryInstert("konta","login,pass,classid,groupid",dane,"");

            }
            mysql_close(handle);
        }
    }
    else
    {
        sendMessageToPlayer(pid,200, 200, 200, "Nie mozesz zrobic juz konta jak jestes zalogowany!");
    }
}

function cmdLogin(pid, args)
{
    local login = sscanf("ss",args);
    if(player[pid].islogged == false){


    if(!login){
        sendMessageToPlayer(pid,200, 200, 200, "Bledny format danych. Podaj /login login haslo");
    }

    else
    {
        local handle = user.createHandle();
        local result = user.querySelect("*","konta",("WHERE login = '" + login[0] + "' AND pass = '" + login[1] + "'"));
        local numrow = mysql_num_rows(result);


        if(numrow != 0)
        {
            sendMessageToPlayer(pid,200, 200, 200, "Zalogowales sie");
            local dane = mysql_fetch_assoc(result);
            player[pid].islogged = true;
            player[pid]._playerCID = dane["classid"];
            player[pid]._playerGroup = dane["groupid"];
            player[pid]._playerLogin = dane["login"];
            player[pid]._playerPass = dane["pass"];
            setPlayerName(pid,dane["login"]);
            callClientFunc(pid,"clearInv");
            cotrl.setClass(pid,player[pid]._playerCID);

        }
        else
        {

            sendMessageToPlayer(pid,200, 200, 200, "Brak takiego konta w bazie lub podales zle dane.");

        }
        mysql_close(handle);
    }
    }
    else
    {
        sendMessageToPlayer(pid,200, 200, 200, "Juz sie zalogowales!");
    }

}

function cmdSetCid(pid,args)
{
    local params = sscanf("dd",args);
    if(!params)
    {
        sendMessageToPlayer(pid,200, 200, 200, "Zle parametry. Podaj ID gracza oraz id klasy");
    }
    else
    {
        if(player[params[0]].islogged == false)
        {
            sendMessageToPlayer(pid,200, 200, 200, "Gracz o podanym id nie jest zalogowany");
        }
        else
        {
            player[params[0]]._playerCID = params[1];
            sendMessageToPlayer(params[0],0, 200, 0, (getPlayerName(pid) + "Zmienil ci klase o id " + params[1]));
            callClientFunc(params[0],"clearInv");
            cotrl.setClass(params[0],params[1]);
            local handle = user.createHandle();
            local result = mysql_query(handle, ("UPDATE konta SET classid =" + params[1] + " WHERE login = '" + player[params[0]]._playerLogin + "'"));
            mysql_close(handle);
        }
    }
}

function cmdPos(pid)
{
    local pos = getPlayerPosition(pid);
    sendMessageToPlayer(pid,0, 200, 0, ("x: " + pos.x + " y: " + pos.y + " z: " + pos.z));

}


function cmdHelper(pid, cmd, args)
{
    switch(cmd)
    {
        case "register":
            cmdRegister(pid,args);
            break;
        case "login":
            cmdLogin(pid,args);
            break;
        case "setCID":
            cmdSetCid(pid,args);
            break;
        case "pos":
            cmdPos(pid);
            break;
    }
}
addEventHandler("onPlayerCommand", cmdHelper);

function onPlayerMessage(pid, message)
{
    print(getPlayerName(pid) + " said: " + message);
    sendPlayerMessageToAll(pid, 255, 255, 255, message);
}

addEventHandler("onPlayerMessage", onPlayerMessage);



//Funckje sieciowe

function setClassu(pid,cid)
{
    cotrl.setClass(pid,cid);
}

function setPlayerCID(pid,arg)
{
    if(player[pid].islogged == false)
    {
        sendMessageToPlayer(pid,200, 200, 200, "Musisz być zalogowany zeby wybrac klase!");
    }
    else
    {
        local handle = user.createHandle();
        local result = mysql_query(handle, ("UPDATE konta SET classid =" + arg + " WHERE login = '" + player[pid]._playerLogin + "'"));
        mysql_close(handle);
    }
}