Beiträge von Sam Cooper

Biz Name aus der MYSQL DatenBank Auslessen:

enum BizInfomation
{
Bizname[128],
BizOwner[128],
BizCoOwner[128],
BizPreis,
Float:PosX,
Float:PosY,
Float:PosZ,
Float:PosA,
BizOwned,
}
new BizInfo[MAX_BIZ][BizInfomation];

OnGameModInit
for(new i = 0;i<MAX_BIZ;i++)
{
if(BizInfo[i][BizOwned] == 0)
{
new bizkaufen[350];
AddStaticPickup(1273, 1, BizInfo[i][PosX], BizInfo[i][PosY], BizInfo[i][PosZ]);
format(bizkaufen,sizeof(bizkaufen),"Name: %s\nBesitzer: Die Staat\nPreis:%d",BizInfo[i][Bizname],BizInfo[i][BizPreis]);
Create3DTextLabel(bizkaufen,ROT,BizInfo[i][PosX],BizInfo[i][PosY],BizInfo[i][PosZ],40.0,0);
}
if(BizInfo[i][BizOwned] == 1)
{
new bizgekauft[350];
AddStaticPickup(1239, 1, BizInfo[i][PosX], BizInfo[i][PosY], BizInfo[i][PosZ]);
format(bizgekauft,sizeof(bizgekauft),"Name: %s\nBesitzer: %s\nMitbesitzer: %s",BizInfo[i][Bizname],BizInfo[i][BizOwner],BizInfo[i][BizCoOwner]);
Create3DTextLabel(bizgekauft,ROT,BizInfo[i][PosX],BizInfo[i][PosY],BizInfo[i][PosZ],40.0,0);
}
}

stock LoadBizData()
{
for(new i=0;i<MAX_BIZ;i++)
{
new query[128],data[128],bedienung[40];
format(bedienung,sizeof(bedienung),"id='%i'",i);
format(query,sizeof(query),"SELECT * FROM bizdata WHERE %s", bedienung);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())
{
mysql_fetch_field("BizName",data); BizInfo[i][Bizname] = strval(data); format(data,sizeof(data),"%s",BizInfo[i][Bizname]);
mysql_fetch_field("BizOwner",data); BizInfo[i][BizOwner] = strval(data); format(data,sizeof(data),"%s",BizInfo[i][BizOwner]);
mysql_fetch_field("BizCoOwner",data); BizInfo[i][BizCoOwner] = strval(data); format(data,sizeof(data),"%s",BizInfo[i][BizCoOwner]);
mysql_fetch_field("BizPreis",data); BizInfo[i][BizPreis] =strval(data); strdel(data,0,100);
mysql_fetch_field("BizX",data); BizInfo[i][PosX] =strval(data); strdel(data,0,100);
mysql_fetch_field("BizY",data); BizInfo[i][PosY] =strval(data); strdel(data,0,100);
mysql_fetch_field("BizZ",data); BizInfo[i][PosZ] =strval(data); strdel(data,0,100);
mysql_fetch_field("BizOwned",data); BizInfo[i][BizOwned] =strval(data); strdel(data,0,100);
}
mysql_free_result();
}
return 1;
}

Was ist falsch ???

MFG

Ingo

//edit: hab ich da was vergessen oder nicht blick da nicht so durch -.- ?

Lifestyler übertreibt da schon mit seine -10/10 Punkten .
Sein Erster Versuch war auch nicht besser!
---------------------------------------------------------------

Also ich finde es gut nur wie gesagt die ecken und etwas mehr Efecte

MFG

Ingo

Jetzt wird mir bei jeden Auto wo ich einsteige (Debug: Falsch) und werde rausgeworfen ??

ENUM:

enum carInfo
{
frakid,
frakname[5],
carid,
Float:PosX,
Float:PosY,
Float:PosZ,
Float:PosA,
Farbe1,
Farbe2,
}
new AutoInfo[MAX_VEHICLES][carInfo];

Strock:

public OnPlayerStateChange(playerid, newstate, oldstate)
{
if(newstate == PLAYER_STATE_DRIVER)
{
for(new i = 0; i < MAX_VEHICLES; i++)
{
if(GetPlayerVehicleID(playerid))
{
if(!strcmp(AutoInfo[i][frakname],"LCN1",true))
{
if(PlayerInfo[playerid][pLeader] == 5 || PlayerInfo[playerid][pMember] == 5)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
break;
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
RemovePlayerFromVehicle(playerid);
break;
}
}
if(!strcmp(AutoInfo[i][frakname],"LSPD",true))
{
if(PlayerInfo[playerid][pLeader] == 1 || PlayerInfo[playerid][pMember] == 1)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
break;
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
RemovePlayerFromVehicle(playerid);
break;
}
}
if(!strcmp(AutoInfo[i][frakname],"Zivi",true))
{
if(PlayerInfo[playerid][pLeader] == 0 || PlayerInfo[playerid][pMember] == 0)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
break;
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
break;
}
}
}
}
}
return 1;
}

OnPlayerStaats:

stock LoadAutosData()
{
for(new i;i<MAX_VEHICLES;i++)
{
new query[128],data[128],bedienung[40];
format(bedienung,sizeof(bedienung),"id='%i'",i);
format(query,sizeof(query),"SELECT * FROM cardata WHERE %s", bedienung);//Die query
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())// Eine Abfrage zur Sicherheit
{
mysql_fetch_field("fn",data);
AutoInfo[i][frakid]=strval(data);
strdel(data,0,100);

mysql_fetch_field("CarID",data);
AutoInfo[i][carid]=strval(data);
strdel(data,0,100);

mysql_fetch_field("X",data);
AutoInfo[i][PosX]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Y",data);
AutoInfo[i][PosY]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Z",data);
AutoInfo[i][PosZ]=strval(data);
strdel(data,0,100);

mysql_fetch_field("A",data);
AutoInfo[i][PosA]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Farbe1",data);
AutoInfo[i][Farbe1]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Farbe2",data);
AutoInfo[i][Farbe2]=strval(data);
strdel(data,0,100);
}
CreateVehicle(AutoInfo[i][carid],AutoInfo[i][PosX],AutoInfo[i][PosY],AutoInfo[i][PosZ],AutoInfo[i][PosA],AutoInfo[i][Farbe1],AutoInfo[i][Farbe2],-1);
if(AutoInfo[i][frakid] == 0)
{
AutoInfo[i][frakname] = "Zivi" ;
}
if(AutoInfo[i][frakid] == 1)
{
AutoInfo[i][frakname] = "LSPD" ;
}
if(AutoInfo[i][frakid] == 2)
{
AutoInfo[i][frakname] = "AMRY" ;
}
if(AutoInfo[i][frakid] == 5)
{
AutoInfo[i][frakname] = "LCN1" ;
}
mysql_free_result();
}
return 1;
}

Zitat von BlackAce

Hast recht keine Antwort auf dein Thema.
Das war der letzte Post daraus -.-

Schuldig hab den nicht gesehen -.-

das kann auch mal Passieren

// CLOSE

ja schön gibt mir keiner eine Antwort -.-

und jetzt frage ich ob mir einer das machen kan !

Kann einer mir das so machen das man nur mit einer Bestimmten Fraktion das Autofahren (FraktionsAutos) kann (MYSQL)

Enum:

enum carInfo
{
frakid,
carid,
Float:PosX,
Float:PosY,
Float:PosZ,
Float:PosA,
Farbe1,
Farbe2,
}
new AutoInfo[MAX_VEHICLES][carInfo];

Laden:

stock LoadAutosData()
{
for(new i;i<MAX_VEHICLES;i++)
{
new query[128],data[128],bedienung[40], carname[64];
format(bedienung,sizeof(bedienung),"id='%i'",i);
format(query,sizeof(query),"SELECT * FROM cardata WHERE %s", bedienung);//Die query
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())// Eine Abfrage zur Sicherheit
{
mysql_fetch_field("fn",data);
AutoInfo[i][frakid]=strval(data);
strdel(data,0,100);

mysql_fetch_field("CarID",data);
AutoInfo[i][carid]=strval(data);
strdel(data,0,100);

mysql_fetch_field("X",data);
AutoInfo[i][PosX]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Y",data);
AutoInfo[i][PosY]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Z",data);
AutoInfo[i][PosZ]=strval(data);
strdel(data,0,100);

mysql_fetch_field("A",data);
AutoInfo[i][PosA]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Farbe1",data);
AutoInfo[i][Farbe1]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Farbe2",data);
AutoInfo[i][Farbe2]=strval(data);
strdel(data,0,100);
}
CreateVehicle(AutoInfo[i][carid],AutoInfo[i][PosX],AutoInfo[i][PosY],AutoInfo[i][PosZ],AutoInfo[i][PosA],AutoInfo[i][Farbe1],AutoInfo[i][Farbe2],-1);
mysql_free_result();
printf("%d|%d|%d|%d|%d|%d|%d|%d",AutoInfo[i][frakname],AutoInfo[i][carid],AutoInfo[i][PosX],AutoInfo[i][PosY],AutoInfo[i][PosZ],AutoInfo[i][PosA],AutoInfo[i][Farbe1],AutoInfo[i][Farbe2]);
}
return 1;
}

Bitte um Hilfen .

Mit Freudlichen Grüßen

Ingo

So Danke Jetzt kommt der Text

nur Leide ist da noch ein Fehler.

Ich bin in Fraktion nummer 5 kann aber auch in die Autos von Fraktion 1 ?

also lcn = 5

lspd = 1

und kann in jedes fahrzeug kann man da mir helfen ???

public OnPlayerStateChange(playerid, newstate, oldstate)
{
if(newstate == PLAYER_STATE_DRIVER)
{
for(new i = 0; i < MAX_VEHICLES; i++)
{
if(GetPlayerVehicleID(playerid))
{
if(!strcmp(AutoInfo[i][frakname],"zivi",true))
{
if(PlayerInfo[playerid][pLeader] == 0 || PlayerInfo[playerid][pMember] == 0)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
break;
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
break;
}
}
if(!strcmp(AutoInfo[i][frakname],"lspd",true))
{
if(PlayerInfo[playerid][pLeader] == 1 || PlayerInfo[playerid][pMember] == 1)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
break;
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
RemovePlayerFromVehicle(playerid);
break;
}
}
if(!strcmp(AutoInfo[i][frakname],"lcn",true))
{
if(PlayerInfo[playerid][pLeader] == 5 || PlayerInfo[playerid][pMember] == 5)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
break;
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
RemovePlayerFromVehicle(playerid);
break;
}
}
}
}
}

Server-Log:

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

SA-MP Dedicated Server
----------------------
v0.3c R2, (C)2005-2011 SA-MP Team

[20:59:55]
[20:59:55] Server Plugins
[20:59:55] --------------
[20:59:55] Loading plugin: mysql.so
[20:59:55] SA:MP MySQL Plugin v2.1.1 Loaded.
[20:59:55] [MySQL] Thread running. Threadsafe: Yes.
[20:59:55] Loaded.
[20:59:55] Loading plugin: sscanf.so
[20:59:55]

[20:59:55] ===============================

[20:59:55] sscanf plugin loaded.

[20:59:55] (c) 2009 Alex "Y_Less" Cole

[20:59:55] ===============================

[20:59:55] Loaded.
[20:59:55] Loading plugin: streamer.so
[20:59:55]

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

[20:59:55] Loaded.
[20:59:55] Loaded 3 plugins.

[20:59:55]
[20:59:55] Filter Scripts
[20:59:55] ---------------
[20:59:55] Loading filter script 'base.amx'...
[20:59:55]
--Base FS loaded.

[20:59:55] Loading filter script 'gl_actions.amx'...
[20:59:55] Loading filter script 'gl_property.amx'...
[20:59:55]
-----------------------------------
[20:59:55] Grand Larceny Property Filterscript
[20:59:55] -----------------------------------

[20:59:55] Loading filter script 'gl_realtime.amx'...
[20:59:55] Loaded 4 filter scripts.

[20:59:55] [MySQL] Connected (0) to 'root'@'127.0.0.1 via TCP/IP'.
[20:59:55] [MySQL] Server Version 5.0.51a-24+lenny5.
[20:59:55] 0|0|0|0|0|0|0|0
[20:59:55] lspd
[20:59:55] 108|596|1153916928|-992632832|1084227584|0|79|1
[20:59:55] lspd
[20:59:55] 108|596|1153884160|-992632832|1084227584|0|79|1
[20:59:55] lcn
[20:59:55] 108|560|1153818624|-992632832|1084227584|0|79|1
[20:59:55] zivi
[20:59:55] 122|560|1153785856|-992624640|1084227584|0|6|6
[20:59:55] 0|0|0|0|0|0|0|0
[20:59:55] 0|0|0|0|0|0|0|0
[20:59:55] 0|0|0|0|0|0|0|0
[20:59:55] 0|0|0|0|0|0|0|0
[20:59:55] 0|0|0|0|0|0|0|0
[20:59:55] Could Not Read Interiors file ( properties/interiors.txt )
[20:59:55] Reading File: blank
[20:59:55] Reading File: properties/houses.txt
[20:59:55] Reading File: properties/businesses.txt
[20:59:55] Reading File: properties/banks.txt
[20:59:55] Reading File: properties/police.txt
[20:59:55]
----------------------------------
[20:59:55] Blank Gamemode by your name here
[20:59:55] ----------------------------------

[20:59:55] Number of vehicle models: 2
[21:00:46] Incoming connection: 91.65.130.112:55871
[21:00:46] [join] [NCR]Ingo has joined the server (0:91.65.130.112)
[21:00:50] [MySQL] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[NCR]Ingo' at line 1.
[21:00:50] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[NCR]Ingo' at line 1.
[21:00:50] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[NCR]Ingo' at line 1.
[21:00:50] Player [NCR]Ingo logged in
[21:01:22] [part] [NCR]Ingo has left the server (0:1)

Weiß Keiner Eine Antwort ????

//edit: Log Eingefügt
//edit: Text Eingefügt
//edit: Push es ist Sehr Wichtig | Weiß Keiner Eine Antwort ?????????????

ich würde sagen du hast das Vergessen ( ; oder ) ) Weiter hoben schau mal nach

GRUß

Ingo

Jetzt hab ich noch ein Problem unzwar Spamt er den chat voll

public OnPlayerStateChange(playerid, newstate, oldstate)
{
if(newstate == PLAYER_STATE_DRIVER)
{
for(new i = 0; i < MAX_VEHICLES; i++)
{
if(GetPlayerVehicleID(playerid))
{
if(!strcmp(AutoInfo[i][frakname],"zivi",true))
{
if(PlayerInfo[playerid][pLeader] == 0 || PlayerInfo[playerid][pMember] == 0)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
}
if(!strcmp(AutoInfo[i][frakname],"lspd",true))
{
if(PlayerInfo[playerid][pLeader] == 1 || PlayerInfo[playerid][pMember] == 1)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
RemovePlayerFromVehicle(playerid);
}
}
if(!strcmp(AutoInfo[i][frakname],"lcn",true))
{
if(PlayerInfo[playerid][pLeader] == 5 || PlayerInfo[playerid][pMember] == 5)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
RemovePlayerFromVehicle(playerid);
}
}
}
}
}
return 1;
}

AutoInfo[i][frakname] = CreateVehicle(AutoInfo[i][carid],AutoInfo[i][PosX],AutoInfo[i][PosY],AutoInfo[i][PosZ],AutoInfo[i][PosA],AutoInfo[i][Farbe1],AutoInfo[i][Farbe2],-1);

Zu

CreateVehicle(AutoInfo[i][carid],AutoInfo[i][PosX],AutoInfo[i][PosY],AutoInfo[i][PosZ],AutoInfo[i][PosA],AutoInfo[i][Farbe1],AutoInfo[i][Farbe2],-1);

oder was meinst du ????

Gleich in Grün kommt auch kein Text

public OnPlayerStateChange(playerid, newstate, oldstate)
{
if(newstate == PLAYER_STATE_DRIVER)
{
for(new i = 0; i < MAX_VEHICLES; i++)
{
if(GetPlayerVehicleID(playerid) == i)
{
if(!strcmp(AutoInfo[i][frakname],"zivi",true))
{
if(PlayerInfo[playerid][pLeader] == 0 || PlayerInfo[playerid][pMember] == 0)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
}
if(!strcmp(AutoInfo[i][frakname],"lspd",true))
{
if(PlayerInfo[playerid][pLeader] == 1 || PlayerInfo[playerid][pMember] == 1)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
RemovePlayerFromVehicle(playerid);
}
}
if(!strcmp(AutoInfo[i][frakname],"lcn",true))
{
if(PlayerInfo[playerid][pLeader] == 5 || PlayerInfo[playerid][pMember] == 5)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
RemovePlayerFromVehicle(playerid);
}
}
}
}
}
return 1;
}

Wenn ich üneral ein Rturn machen kommt der text

//Edit
//edit2: Text Eingefügt

nei Es gib 2 Polizei autos und die 2 Sultans (blau - LCN , Orang- Zivi)

ich steig in jedes ein kommt nie was -.-

Weiß Keiner Eine Antwort ??

Ich bin schon richtige dabei zuverzweifeln -.-

//EDIT1: Text

Immer noch das gleiche

enum carInfo
{
frakid,
frakname[64],
carid,
Float:PosX,
Float:PosY,
Float:PosZ,
Float:PosA,
Farbe1,
Farbe2,
}
new AutoInfo[MAX_VEHICLES][carInfo];

public OnPlayerStateChange(playerid, newstate, oldstate)
{
if(newstate == PLAYER_STATE_DRIVER)
{
for(new i = 0; i < MAX_VEHICLES; i++)
{
if(GetPlayerVehicleID(playerid) == i)
{
if(!strcmp(AutoInfo[i][frakname],"zivi",true))
{
if(PlayerInfo[playerid][pLeader] == 0 || PlayerInfo[playerid][pMember] == 0)
{

}
else
{

}
}
if(!strcmp(AutoInfo[i][frakname],"lspd",true))
{
if(PlayerInfo[playerid][pLeader] == 1 || PlayerInfo[playerid][pMember] == 1)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
RemovePlayerFromVehicle(playerid);
}
}
if(!strcmp(AutoInfo[i][frakname],"lcn",true))
{
if(PlayerInfo[playerid][pLeader] == 5 || PlayerInfo[playerid][pMember] == 5)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
RemovePlayerFromVehicle(playerid);
}
}
}
}
}
return 1;
}

stock LoadAutosData()
{
for(new i;i<MAX_VEHICLES;i++)
{
new query[128],data[128],bedienung[40], carname[64];
format(bedienung,sizeof(bedienung),"id='%i'",i);
format(query,sizeof(query),"SELECT * FROM cardata WHERE %s", bedienung);//Die query
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())// Eine Abfrage zur Sicherheit
{
format(carname,sizeof(carname),"%s",AutoInfo[i][frakname]);
mysql_fetch_field("FrakName",carname);
format(AutoInfo[i][frakname],64,carname);
printf(AutoInfo[i][frakname]);

mysql_fetch_field("fn",data);
AutoInfo[i][frakid]=strval(data);
strdel(data,0,100);

mysql_fetch_field("CarID",data);
AutoInfo[i][carid]=strval(data);
strdel(data,0,100);

mysql_fetch_field("X",data);
AutoInfo[i][PosX]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Y",data);
AutoInfo[i][PosY]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Z",data);
AutoInfo[i][PosZ]=strval(data);
strdel(data,0,100);

mysql_fetch_field("A",data);
AutoInfo[i][PosA]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Farbe1",data);
AutoInfo[i][Farbe1]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Farbe2",data);
AutoInfo[i][Farbe2]=strval(data);
strdel(data,0,100);
}
AutoInfo[i][frakname] = CreateVehicle(AutoInfo[i][carid],AutoInfo[i][PosX],AutoInfo[i][PosY],AutoInfo[i][PosZ],AutoInfo[i][PosA],AutoInfo[i][Farbe1],AutoInfo[i][Farbe2],-1);
mysql_free_result();
}
return printf("Autos wurden Geladen");
}

Das ist der Ganze cod für die fraktions Autos .

immer noch das gleiche -.-

Ich kann mit jeder fraktion ein Steigen und es kommt nicht mal der Text :

Richtig!

Falsch !

public OnPlayerStateChange(playerid, newstate, oldstate)
{
for(new i=0;i <MAX_VEHICLES; i++)
{
if(newstate == PLAYER_STATE_DRIVER) //buggy dont finnish
{
if(GetPlayerVehicleID(playerid))
{
if(!strcmp(AutoInfo[i][frakname],"zivi",true))
{
if(PlayerInfo[playerid][pLeader] == 0 || PlayerInfo[playerid][pMember] == 0)
{

}
else
{

}
}
else if(!strcmp(AutoInfo[i][frakname],"lspd",true))
{
if(PlayerInfo[playerid][pLeader] == 1 || PlayerInfo[playerid][pMember] == 1)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
RemovePlayerFromVehicle(playerid);
}
}
else if(!strcmp(AutoInfo[i][frakname],"lcn",true))
{
if(PlayerInfo[playerid][pLeader] == 5 || PlayerInfo[playerid][pMember] == 5)
{
SendClientMessage(playerid,ROT,"DEBUG: RICHTIG !");
}
else
{
SendClientMessage(playerid,ROT,"DEBUG: FALSCH !");
RemovePlayerFromVehicle(playerid);
}
}
}
}
}
return 1;
}

Da bitte

Server-Log:

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

SA-MP Dedicated Server
----------------------
v0.3c R2, (C)2005-2011 SA-MP Team

[16:42:13]
[16:42:13] Server Plugins
[16:42:13] --------------
[16:42:13] Loading plugin: mysql.so
[16:42:13] SA:MP MySQL Plugin v2.1.1 Loaded.
[16:42:13] [MySQL] Thread running. Threadsafe: Yes.
[16:42:13] Loaded.
[16:42:13] Loading plugin: sscanf.so
[16:42:13]

[16:42:13] ===============================

[16:42:13] sscanf plugin loaded.

[16:42:13] (c) 2009 Alex "Y_Less" Cole

[16:42:13] ===============================

[16:42:13] Loaded.
[16:42:13] Loading plugin: streamer.so
[16:42:13]

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

[16:42:13] Loaded.
[16:42:13] Loaded 3 plugins.

[16:42:13]
[16:42:13] Filter Scripts
[16:42:13] ---------------
[16:42:13] Loading filter script 'base.amx'...
[16:42:13]
--Base FS loaded.

[16:42:13] Loading filter script 'gl_actions.amx'...
[16:42:13] Loading filter script 'gl_property.amx'...
[16:42:13]
-----------------------------------
[16:42:13] Grand Larceny Property Filterscript
[16:42:13] -----------------------------------

[16:42:13] Loading filter script 'gl_realtime.amx'...
[16:42:13] Loaded 4 filter scripts.

[16:42:13] [MySQL] Connected (0) to 'root'@'127.0.0.1 via TCP/IP'.
[16:42:13] [MySQL] Server Version 5.0.51a-24+lenny5.
[16:42:13] lspd
[16:42:13] lspd
[16:42:13] lcn
[16:42:13] zivi
[16:42:13] Autos wurden Geladen
[16:42:13] Could Not Read Interiors file ( properties/interiors.txt )
[16:42:13] Reading File: blank
[16:42:13] Reading File: properties/houses.txt
[16:42:13] Reading File: properties/businesses.txt
[16:42:13] Reading File: properties/banks.txt
[16:42:13] Reading File: properties/police.txt
[16:42:13]
----------------------------------
[16:42:13] Blank Gamemode by your name here
[16:42:13] ----------------------------------

[16:42:13] Number of vehicle models: 2

[16:42:13] lspd
[16:42:13] lspd
[16:42:13] lcn
[16:42:13] zivi

Die Namen Werden Geladen .

MYSQL-Datenbanken Bilder:

ja was soll den noch falsch sein -.-

ich habe jetzt alle getestet

und keine weis eine Lösung

oder Erklären tut das auch keiner -.-

Ich arbeite zum ersten mal mit MYSQL !

geht auch nicht hatte auch schon die idee

Kann man mir nich das mal vor machen ich verzveifel daran

vileicht hilft das.
PS: (Es ist ein Linux Server und kein Windows Server)

Wen ich das so mache kommt

D:\pawno\2411.pwn(333) : error 017: undefined symbol "i"
D:\pawno\2411.pwn(330) : warning 204: symbol is assigned a value that is never used: "vehicleid"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

1 Error.

Weil die Schleife nicht mehr da ist deswegen

Habs Jetzt geändert aber es ist immer noch das gleiche wie davor

enum carInfo
{
frakid,
frakname[64],
carid,
Float:PosX,
Float:PosY,
Float:PosZ,
Float:PosA,
Farbe1,
Farbe2,
}
new AutoInfo[MAX_VEHICLES][carInfo];

public OnPlayerStateChange(playerid, newstate, oldstate)
{
for (new i=0; i< MAX_VEHICLES; i++)
{
if(newstate==PLAYER_STATE_DRIVER)
{
if(!strcmp(AutoInfo[i][frakname],"lspd",true))
{
if(PlayerInfo[playerid][pLeader] == 1 || PlayerInfo[playerid][pMember] == 1)
{
SendClientMessage(playerid,0xFF0000FF,"Du bist in der Fraktion");
}
else
{
RemovePlayerFromVehicle(playerid);
SendClientMessage(playerid,0xFF0000FF,"Du bist nicht in der Fraktion");
}
}
if(!strcmp(AutoInfo[i][frakname],"lcn",true))
{
if(PlayerInfo[playerid][pLeader] == 5 || PlayerInfo[playerid][pMember] == 5)
{
SendClientMessage(playerid,0xFF0000FF,"Du bist in der Fraktion");
}
else
{
RemovePlayerFromVehicle(playerid);
SendClientMessage(playerid,0xFF0000FF,"Du bist nicht in der Fraktion");
}
}
if(!strcmp(AutoInfo[i][frakname],"oamt",true))
{
if(PlayerInfo[playerid][pLeader] == 4 || PlayerInfo[playerid][pMember] == 4)
{
SendClientMessage(playerid,0xFF0000FF,"Du bist in der Fraktion");
}
else
{
RemovePlayerFromVehicle(playerid);
SendClientMessage(playerid,0xFF0000FF,"Du bist nicht in der Fraktion");
}
}
if(!strcmp(AutoInfo[i][frakname],"zivi",true))
{
if(PlayerInfo[playerid][pLeader] == 0 || PlayerInfo[playerid][pMember] == 0)
{

}
else
{

}
}
}
}
return 1;
}

stock LoadAutosData()
{
for(new i;i<MAX_VEHICLES;i++)
{
new query[128],data[128],bedienung[40], carname[64];
format(bedienung,sizeof(bedienung),"id='%i'",i);
format(query,sizeof(query),"SELECT * FROM cardata WHERE %s", bedienung);//Die query
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())// Eine Abfrage zur Sicherheit
{
format(carname,sizeof(carname),"%s",AutoInfo[i][frakname]);
mysql_fetch_field("FrakName",carname);
format(AutoInfo[i][frakname],64,carname);

mysql_fetch_field("fn",data);
AutoInfo[i][frakid]=strval(data);
strdel(data,0,100);

mysql_fetch_field("CarID",data);
AutoInfo[i][carid]=strval(data);
strdel(data,0,100);

mysql_fetch_field("X",data);
AutoInfo[i][PosX]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Y",data);
AutoInfo[i][PosY]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Z",data);
AutoInfo[i][PosZ]=strval(data);
strdel(data,0,100);

mysql_fetch_field("A",data);
AutoInfo[i][PosA]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Farbe1",data);
AutoInfo[i][Farbe1]=strval(data);
strdel(data,0,100);

mysql_fetch_field("Farbe2",data);
AutoInfo[i][Farbe2]=strval(data);
strdel(data,0,100);
}
AutoInfo[i][frakname] = CreateVehicle(AutoInfo[i][carid],AutoInfo[i][PosX],AutoInfo[i][PosY],AutoInfo[i][PosZ],AutoInfo[i][PosA],AutoInfo[i][Farbe1],AutoInfo[i][Farbe2],-1);
mysql_free_result();
}
}

Weiß Keiner eine Antwort ????

MFG

Ingo

//Edit:1 Stock bearbeitet