Beiträge von ChrisX

echo Executing Server Config...
lanmode 0
rcon_password pw 
maxplayers 50
port 8001 
hostname hostname
gamemode0 ui-mysql
filterscripts gl_realtime
plugins mysql.so streamer.so sscanf.so
announce 0
query 1
weburl www.test.de
maxnpc 0
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000
mapname eigene Map

----------
Loaded log file: "server_log.txt".
----------


SA-MP Dedicated Server
----------------------
v0.3b R2, (C)2005-2010 SA-MP Team


[00:25:17] 
[00:25:17] Server Plugins
[00:25:17] --------------
[00:25:17]  Loading plugin: mysql.so
[00:25:17]  SA:MP MySQL Plugin v2.1.1 Loaded.
[00:25:17]   Loaded.
[00:25:17]  Loading plugin: streamer.so
[00:25:17] [MySQL] Thread running. Threadsafe: Yes.
[00:25:17] 


*** Streamer Plugin v2.5 by Incognito loaded ***


[00:25:17]   Loaded.
[00:25:17]  Loading plugin: sscanf.so
[00:25:17] 


[00:25:17]  ===============================


[00:25:17]       sscanf plugin loaded.     


[00:25:17]    (c) 2009 Alex "Y_Less" Cole


[00:25:17]  ===============================


[00:25:17]   Loaded.
[00:25:17]  Loaded 3 plugins.


[00:25:17] 
[00:25:17] Filter Scripts
[00:25:17] ---------------
[00:25:17]   Loading filter script 'gl_realtime.amx'...
[00:25:17]   Loaded 1 filter scripts.


[00:25:17] Script[gamemodes/ui-mysql.amx]: Run time error 19: "File or function is not found"

forward RaceCount(playerid);
public RaceCount(playerid)
{
	if(rcount > 0)
	{
		for(new i=0; i<MAX_PLAYERS; i++)
		{
			if(vRacer[i] == 1)
			{
				new	str[128];
				format(str,sizeof(str),"~r~%d",rcount);
				GameTextForPlayer(i,str,1050,4);
				rcount--;
				return 1;
			}
		}
		return 1;
	}
	else
	{
		KillTimer(rtimer);
		for(new ri=0; ri<MAX_PLAYERS; ri++)
		{
			if(vRacer[ri] == 1)
			{
				GameTextForPlayer(ri,"~r~GOOOOOOOOOOOOOOO!!!",1050,4);
				TogglePlayerControllable(ri,1);
				ClientLanguageText(ri,COLOR_RED,"Du hast 5 Minuten Zeit bis das Rennen automatisch beendet wird.","You have 5 minutes until the race will automatically end!");
				retimer = SetTimerEx("Rends",300000,false,"i",playerid);
			}
		}
	}
	return 1;
}

stock LoadVehiclesFromDB()
{
    new index;
    mysql_query("SELECT * FROM `car_info` ORDER BY carID ASC");
    mysql_store_result();
    if(mysql_num_rows() > 0)
    {
        while(mysql_fetch_row(Query))
        {
            sscanf(Query, "e<p<|>dddffffffs[45]ffddddd>", Vehicles[index]);
            CreateVehicle(Vehicles[index][vModelID], Vehicles[index][vPosX], Vehicles[index][vPosY],
			Vehicles[index][vPosZ], Vehicles[index][vAngleZ], Vehicles[index][vColor1], Vehicles[index][vColor2], -1);
            index++;
		}
    }

    mysql_free_result();
    print("\n");
    printf("SERVER: Erfolgreich %d Fahrzeuge aus der Datenbank geladen.", index);
    return 1;
}

command(savecar, playerid, params[])
{
	new Color1, Color2, Float:PositionX, Float:PositionY, Float:PositionZ, Float:AngleZ;
	new Float:Health;
	if(pUserData[playerid][pLevel] < 3)
		return SendClientMessage(playerid, COLOR_GREY, CMD_ERROR);
	if(!IsPlayerInAnyVehicle(playerid))
		return SendClientMessage(playerid, COLOR_RED, "Du musst zum speichern im Fahrzeug sitzen!");


	new vehicleid = GetPlayerVehicleID(playerid);
	GetVehiclePos(vehicleid, PositionX, PositionY, PositionZ);
	GetVehicleZAngle(vehicleid, AngleZ);
	GetVehicleHealth(vehicleid, Health);
	GetVehicleColor(GetPlayerVehicleID(playerid), Color1, Color2);


	format(Query, sizeof(Query), "UPDATE car_info SET X=%f, Y=%f, Z=%f, A=%f, Health=%f, Color1=%d, Color2=%d WHERE carID = %d and userID = %d", PositionX, PositionY, PositionZ, AngleZ, Health, Color1, Color2, GetPlayerVehicleID(playerid), pUserData[playerid][pUserID]);
	mysql_query(Query);

	return SendClientMessage(playerid, COLOR_RED, "Dein Fahrzeug wurde an dieser Position gespeichert.");
}

enum test
{
	pUsername[24],
	pPassword[129],
	pSQuestion[64],
	pSAnswer[129],
	pIPAddress[17],
	pAdminLevel,
	pMoney,
	pScore,
	pSkin,
	Float: pHealth,
	Float: pArmour,
	Float: pPosX,
	Float: pPosY,
	Float: pPosZ,
	pPMStatus,
	pKills,
	pDeaths,
	pLogins,
	pWarns,
	pWarning1,
	pWarning2,
	pWarning3,
	pDonator,
	pRespekt
}
new pStats[playerid][test];




stock LoadAccountVariables(playerid)
{
	new EscapedName[MAX_PLAYER_NAME];
	if(GetPVarInt(playerid, "Authentication") == 1)
    {
	    mysql_real_escape_string(GetName(playerid), EscapedName);
		format(Query, sizeof(Query), "SELECT * FROM `Accounts` WHERE `Username` = '%s'", EscapedName);
		mysql_query(Query);
		mysql_store_result();


		if(mysql_num_rows() > 0)
		{
			while(mysql_fetch_row(Query))
			{
				sscanf(Query, "e<p<|>s[24]s[129]s[64]s[129]s[17]ddddfffffddddds[128]s[128]s[128]dd>", pStats[playerid]);
			}
		}
	}
	else print("[MySQL ERROR] LoadAccountVariables() was called, but to a non-connected ID.");
	mysql_free_result();
}