--[[
    -----------------------------
    Gamemode:        [Reallife_SoR]

    Copyrights by MulTi (C)2015
    -----------------------------
]]


local M_Garage         = {}
local M_Garagedatabase = {};



function M_Garageload()
    local M_GaragenVar  = 1;
    local M_GarageQuery = mysql_query(handler, "SELECT * FROM garagen");

    if(M_GarageQuery)then
        if(mysql_num_rows(M_GarageQuery) > 0)then
            local M_GarageAssoc = mysql_fetch_assoc(M_GarageQuery);

            while(M_GarageAssoc)do

                M_Garagedatabase[M_GaragenVar]              = {}
                M_Garagedatabase[M_GaragenVar]["ID"]        = M_GarageAssoc["Id"];
                M_Garagedatabase[M_GaragenVar]["PREIS"]     = M_GarageAssoc["Preis"];
                M_Garagedatabase[M_GaragenVar]["BESITZER"]  = M_GarageAssoc["Besitzer"];
                M_Garagedatabase[M_GaragenVar]["STANDTORT"] = M_GarageAssoc["Standtort"];
                M_Garagedatabase[M_GaragenVar]["GATE_POSX"] = M_GarageAssoc["Gate_X"];
                M_Garagedatabase[M_GaragenVar]["GATE_POSY"] = M_GarageAssoc["Gate_Y"];
                M_Garagedatabase[M_GaragenVar]["GATE_POSZ"] = M_GarageAssoc["Gate_Z"];
                M_Garagedatabase[M_GaragenVar]["GATE_ROTX"] = M_GarageAssoc["Gate_RotX"];
                M_Garagedatabase[M_GaragenVar]["GATE_ROTY"] = M_GarageAssoc["Gate_RotY"];
                M_Garagedatabase[M_GaragenVar]["GATE_ROTZ"] = M_GarageAssoc["Gate_RotZ"];

                M_Garage[M_GaragenVar]                      = {}
                M_Garage[M_GaragenVar]["GATE"]              = createObject(980,
                                                              M_Garagedatabase[M_GaragenVar]["GATE_POSX"],
                                                              M_Garagedatabase[M_GaragenVar]["GATE_POSY"],
                                                              M_Garagedatabase[M_GaragenVar]["GATE_POSZ"],
                                                              M_Garagedatabase[M_GaragenVar]["GATE_ROTX"],
                                                              M_Garagedatabase[M_GaragenVar]["GATE_ROTY"],
                                                              M_Garagedatabase[M_GaragenVar]["GATE_ROTZ"]
                );


                M_GaragenVar  = M_GaragenVar + 1;
                M_GarageAssoc = mysql_fetch_assoc(M_GarageQuery);
            end
            mysql_free_result(M_GarageQuery);
        end
    end
end
M_Garageload();