MySQL Abfrage

addEvent("onOpenLeaderPanel", true )
addEventHandler("onOpenLeaderPanel", getRootElement(), function ()
    pdleader_mysql = mysql_query ( handler, "SELECT * FROM userdata WHERE Fraktion LIKE '1' AND FraktionsRang LIKE '5'" )
	fbileader_mysql = mysql_query ( handler, "SELECT Name FROM userdata WHERE Fraktion LIKE '6' AND FraktionsRang LIKE '5'" )
	armyleader_mysql = mysql_query ( handler, "SELECT Name FROM userdata WHERE Fraktion LIKE '8' AND FraktionsRang LIKE '5'" )
	reporter_mysql = mysql_query ( handler, "SELECT Name FROM userdata WHERE Fraktion LIKE '5' AND FraktionsRang LIKE '5'" )
	hitman_mysql = mysql_query ( handler, "SELECT Name FROM userdata WHERE Fraktion LIKE '10' AND FraktionsRang LIKE '5'" )
	medic_mysql = mysql_query ( handler, "SELECT Name FROM userdata WHERE Fraktion LIKE '13' AND FraktionsRang LIKE '5'" )
	mafia_mysql = mysql_query ( handler, "SELECT Name FROM userdata WHERE Fraktion LIKE '2' AND FraktionsRang LIKE '5'" )
	triaden_mysql = mysql_query ( handler, "SELECT Name FROM userdata WHERE Fraktion LIKE '3' AND FraktionsRang LIKE '5'" )
	aztecas_mysql = mysql_query ( handler, "SELECT Name FROM userdata WHERE Fraktion LIKE '7' AND FraktionsRang LIKE '5'" )
	aod_mysql = mysql_query ( handler, "SELECT Name FROM userdata WHERE Fraktion LIKE '9' AND FraktionsRang LIKE '5'" )
	terror_mysql = mysql_query ( handler, "SELECT Name FROM userdata WHERE Fraktion LIKE '4' AND FraktionsRang LIKE '5'" )			

	if pdleader_mysql == nil then
	    pdleader = "Frei"
	elseif not pdleader_mysql == nil then
	    pdleader = pdleader_mysql
	elseif fbileader_mysql == nil then
	    fbileader = "Frei"
	elseif not fbileader_mysql == nil then
	    fbileader = fbileader_mysql
	elseif armyleader_mysql == nil then
	    armyleader = "Frei"
	elseif not armyleader_mysql == nil then
	    armyleader = armyleader_mysql
	elseif reporter_mysql == nil then
	    reporterleader = "Frei"
	elseif not reporter_mysql == nil then
	    reporterleader = reporter_mysql
	elseif hitman_mysql == nil then
	    hitmanleader = "Frei"
	elseif not hitman_mysql == nil then
	    hitmanleader = hitman_mysql
	elseif medic_mysql == nil then
	    medicleader = "Frei"
	elseif not medic_mysql == nil then
	    medicleader = medic_mysql
	elseif mafia_mysql == nil then
	    mafialeader = "Frei"
	elseif not mafia_mysql == nil then
	    mafialeader = mafia_mysql
	elseif triaden_mysql == nil then
	    triadenleader = "Frei"
	elseif not triaden_mysql == nil then
	    triadenleader = triaden_mysql
	elseif aztecas_mysql == nil then
	    aztecasleader = "Frei"
	elseif not aztecas_mysql == nil then
	    aztecasleader = aztecas_mysql
	elseif aod_mysql == nil then
	    aodleader = "Frei"
	elseif not aod_mysql == nil then
	    aodleader = aod_mysql
	elseif terror_mysql == nil then
	    terrorleader = "Frei"
	elseif not terror_mysql == nil then
	    terrorleader = terror_mysql
	end
	triggerServerEvent ( source, "onPDLeader", source, pdleader )
	triggerServerEvent ( source, "onFBILeader", source, fbileader )
	triggerServerEvent ( source, "onArmyLeader", source, armyleader )
	triggerServerEvent ( source, "onReporterLeader", source, reporterleader )
	triggerServerEvent ( source, "onHitmanLeader", source, hitmanleader )
	triggerServerEvent ( source, "onMedicLeader", source, medicleader )
	triggerServerEvent ( source, "onMafiaLeader", source, mafialeader )
	triggerServerEvent ( source, "onTriadenLeader", source, triadenleader )
	triggerServerEvent ( source, "onAztecasLeader", source, aztecasleader )
	triggerServerEvent ( source, "onAoDLeader", source, aodleader )
	triggerServerEvent ( source, "onTerrorLeader", source, terrorleader )
end)