Beiträge von Sam Cooper

Sam Cooper · 19. November 2011

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 -.- ?

Sam Cooper · 19. November 2011

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

Sam Cooper · 18. November 2011

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;
}

Sam Cooper · 18. November 2011

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

Sam Cooper · 18. November 2011

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

und jetzt frage ich ob mir einer das machen kan !

Sam Cooper · 18. November 2011

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

Sam Cooper · 18. November 2011

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] ===============================

[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 ?????????????

Sam Cooper · 18. November 2011

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

GRUß

Ingo

Sam Cooper · 17. November 2011

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;
}

Sam Cooper · 17. November 2011

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 ????

Sam Cooper · 17. November 2011

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

Sam Cooper · 16. November 2011

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

Sam Cooper · 16. November 2011

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 .

Sam Cooper · 16. November 2011

immer noch das gleiche -.-

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

Richtig!

Falsch !

Sam Cooper · 16. November 2011

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

Sam Cooper · 16. November 2011

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] ===============================

[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:

Sam Cooper · 16. November 2011

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 !

Sam Cooper · 16. November 2011

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)

Sam Cooper · 15. November 2011

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

Sam Cooper · 15. November 2011

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

Beiträge von Sam Cooper

MYSQL Text Auslessen

Neuer Verusch eines Ucp

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQL Fraktions Fahrzeuge wie ???

MYSQL Fraktions Fahrzeuge wie ???

MYSQL Fraktions Fahrzeuge wie ???

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

Ich kann keine ShowPlayerDialog mehr machen -.- Warum ?!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!

MYSQl Fraktions Cars nur für Die Richtige Fraktion !Wichtig!