Beiträge von RickFace

Hallo liebe Community,
ich habe folgendes Problem und zwar ist mir direkt aufgefallen als ich auf meinen Server gehen wollte das keine Login/Register Abfrage gestartet wurde und habe dann in der mysql_log dies gesehen:

[19:44:35] [ERROR] CMySQLQuery::Execute[OnUserCheckBan(i)] - (error #2006) MySQL server has gone away
[19:44:35] [WARNING] CMySQLQuery::Execute[OnUserCheckBan(i)] - lost connection, reconnecting..
[19:44:35] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[19:44:53] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[19:44:53] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[19:44:53] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

was dass jetzt genau heißen soll weiß ich nicht aber wenn ich mal so grob drüber gucke sehe ich das er aufeinmal die Verbindung zum MySQL Server Verliert.

Vielen Dank schonmal im vorraus

Vielen Vielen dank an euch endlich klappt es

ich nutze die R34

Ich habe sie jz in der config mit under plugins laden lassen bringt abber nix

Wie mache ich das denn?

Hallo liebe community,
ich habe folgendes Problem und zwar wir mir in der Console folgendes angezeigt(Ich weiß nicht was ich damit anfangen soll):

SA-MP Dedicated Server
----------------------
v0.3.7, (C)2005-2015 SA-MP Team

[19:06:52] filterscripts = "" (string)
[19:06:52]
[19:06:52] Server Plugins
[19:06:52] --------------
[19:06:52] Loading plugin: mysql.so
[19:06:52] Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)
[19:06:52] Loaded 0 plugins.

[19:06:52]
[19:06:52] Filterscripts
[19:06:52] ---------------
[19:06:52] Loaded 0 filterscripts.

[19:06:52] Script[gamemodes/LLR.amx]: Run time error 19: "File or function is not found"
[19:06:52] Number of vehicle models: 0

Vielen Dank schonmal im Vorraus

Okay vielen Dank an euch beide endlich klappt es

stock getFreeCarID()
{
for(new i=0; i<sizeof(vInfo); i++)
{
if(vInfo[i][v_id_x]==0)return i;
}
return 1;
}

enum VehicleDaten{
v_db_id,
v_paintjob,
v_id_x[MAX_VEHICLES],
v_vehicle_id,
Float:v_x,
Float:v_y,
Float:v_z,
Float:v_r,
v_Color1,
v_Color2,
v_fraktion,
v_nummer,
v_spoiler,
v_hood,
v_roof,
v_sideskirt,
v_lamps,
v_nitro,
v_exhaust,
v_wheels,
v_stereo,
v_hydraulics,
v_front_bumper,
v_rear_bumper,
v_vent_left,
v_vent_right
}

new vInfo[MAX_VEHICLES][VehicleDaten];

da steht dann:

Sultan : 1
Sultan : 2

habe momentan zum test 2mal einen Sultan mit Paintjob 1 und 2 drin

public OnCarsLoad()
{
new num_rows, num_fields;
cache_get_data(num_rows,num_fields,dbhandle);
if(!cache_get_row_count(dbhandle))return print("keine Autos");
for(new i=0; i<cache_get_row_count(dbhandle); i++)
{
new vID = getFreeCarID();
vInfo[vID][v_db_id]= cache_get_field_content_int(i,"id",dbhandle);
vInfo[vID][v_nummer]=cache_get_field_content_int(i,"nummer",dbhandle);
vInfo[vID][v_vehicle_id]= cache_get_field_content_int(i,"vehicleid",dbhandle);
vInfo[vID][v_x]= cache_get_field_content_float(i,"x",dbhandle);
vInfo[vID][v_y]= cache_get_field_content_float(i,"y",dbhandle);
vInfo[vID][v_z]= cache_get_field_content_float(i,"z",dbhandle);
vInfo[vID][v_r]= cache_get_field_content_float(i,"r",dbhandle);
vInfo[vID][v_paintjob]=cache_get_field_content_int(i,"paintjob",dbhandle);
vInfo[vID][v_Color1]= cache_get_field_content_int(i,"Color1",dbhandle);
vInfo[vID][v_Color2]= cache_get_field_content_int(i,"Color2",dbhandle);
vInfo[vID][v_fraktion]= cache_get_field_content_int(i,"fraktion",dbhandle);
vInfo[vID][v_id_x]= CreateVehicle(vInfo[vID][v_vehicle_id],vInfo[vID][v_x],vInfo[vID][v_y],vInfo[vID][v_z],vInfo[vID][v_r],vInfo[vID][v_Color1],vInfo[vID][v_Color2],0);
ChangeVehiclePaintjob(vInfo[vID][v_id_x],vInfo[vID][v_paintjob]);
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Spoiler",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Hood",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Roof",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Sideskirt",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Lamps",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Nitro",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Exhaust",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Wheels",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Stereo",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Hydraulics",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Front_Bumper",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Rear_Bumper",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Vent_Left",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Vent_Right",dbhandle));
printf("Auto Type: %i, ID: %i geladen...",vInfo[vID][v_vehicle_id],vID);
}
print("Alle autos geladen!");
return 1;
}

aber es funkt immernoch nicht

:/:/:/

ohh okay danke

Funktioniert aber immernoch nicht

3

Sultan

Funktioniert trozdem nicht

Also ich meine das nur die normale Farbe am auto angezeigt wird und nicht der Paintjob

Hallo liebe community,

ich habe folgendes problem und zwar wird beim laden des wagen andauernd der Paintjob überschrieben
hier mal der PAWN-Code:

public OnCarsLoad()
{
new num_rows, num_fields;
cache_get_data(num_rows,num_fields,dbhandle);
if(!num_rows)return print("keine Autos");
for(new i=0; i<num_rows; i++)
{
new vID = getFreeCarID();
vInfo[vID][v_db_id]= cache_get_field_content_int(i,"id",dbhandle);
vInfo[vID][v_nummer]=cache_get_field_content_int(i,"nummer",dbhandle);
vInfo[vID][v_vehicle_id]= cache_get_field_content_int(i,"vehicleid",dbhandle);
vInfo[vID][v_x]= cache_get_field_content_float(i,"x",dbhandle);
vInfo[vID][v_y]= cache_get_field_content_float(i,"y",dbhandle);
vInfo[vID][v_z]= cache_get_field_content_float(i,"z",dbhandle);
vInfo[vID][v_r]= cache_get_field_content_float(i,"r",dbhandle);
vInfo[vID][v_paintjob]=cache_get_field_content_int(i,"paintjob",dbhandle);
vInfo[vID][v_Color1]= cache_get_field_content_int(i,"Color1",dbhandle);
vInfo[vID][v_Color2]= cache_get_field_content_int(i,"Color2",dbhandle);
vInfo[vID][v_fraktion]= cache_get_field_content_int(i,"fraktion",dbhandle);
if(vInfo[vID][v_paintjob]==10)
{
vInfo[vID][v_id_x]= CreateVehicle(vInfo[vID][v_vehicle_id],vInfo[vID][v_x],vInfo[vID][v_y],vInfo[vID][v_z],vInfo[vID][v_r],vInfo[vID][v_Color1],vInfo[vID][v_Color2],0);
}
else
{
vInfo[vID][v_id_x]= CreateVehicle(vInfo[vID][v_vehicle_id],vInfo[vID][v_x],vInfo[vID][v_y],vInfo[vID][v_z],vInfo[vID][v_r],vInfo[vID][v_Color1],vInfo[vID][v_Color2],0);
ChangeVehiclePaintjob(vInfo[vID][v_id_x],vInfo[vID][v_paintjob]);
}
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Spoiler",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Hood",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Roof",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Sideskirt",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Lamps",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Nitro",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Exhaust",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Wheels",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Stereo",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Hydraulics",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Front_Bumper",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Rear_Bumper",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Vent_Left",dbhandle));
AddVehicleComponent(vInfo[vID][v_id_x],cache_get_field_content_int(i,"Vent_Right",dbhandle));
printf("Auto Type: %i, ID: %i geladen...",vInfo[vID][v_vehicle_id],vID);
}
print("Alle autos geladen!");
return 1;
}

Ohh ups ....

Habs übersehen.
Danke

Wo liegt da jz der fehler?

Hallo liebe community,

ich habe folgendes problem...
ich habe einen Timer eingebaut der alle 10 sekunden die "Components" in enum Variablem Speichert und anschließend in eine MySQL Datenbank Speichert
irgendwie speichert er zwar die enum Variablen aber nicht die MySQL Datenbank

Hier mal der PAWN-Code:

SetTimer("CarSaveTuning",1000*10,1);

public CarSaveTuning()
{
for(new i=0; i<sizeof(vInfo); i++)
{
if(vInfo[i][v_id_x]==0)continue;
new id_x = vInfo[i][v_id_x];
new color1,color2;
GetVehicleColor(id_x, color1,color2);
vInfo[i][v_Color1]=color1;
vInfo[id_x][v_Color2]=color2;
vInfo[id_x][v_spoiler]=GetVehicleComponentInSlot(id_x,0);
vInfo[id_x][v_hood]=GetVehicleComponentInSlot(id_x,1);
vInfo[id_x][v_roof]=GetVehicleComponentInSlot(id_x,2);
vInfo[id_x][v_sideskirt]=GetVehicleComponentInSlot(id_x,3);
vInfo[id_x][v_lamps]=GetVehicleComponentInSlot(id_x,4);
vInfo[id_x][v_nitro]=GetVehicleComponentInSlot(id_x,5);
vInfo[id_x][v_exhaust]=GetVehicleComponentInSlot(id_x,6);
vInfo[id_x][v_wheels]=GetVehicleComponentInSlot(id_x,7);
vInfo[id_x][v_stereo]=GetVehicleComponentInSlot(id_x,8);
vInfo[id_x][v_hydraulics]=GetVehicleComponentInSlot(id_x,9);
vInfo[id_x][v_front_bumper]=GetVehicleComponentInSlot(id_x,10);
vInfo[id_x][v_rear_bumper]=GetVehicleComponentInSlot(id_x,11);
vInfo[id_x][v_vent_left]=GetVehicleComponentInSlot(id_x,12);
vInfo[id_x][v_vent_right]=GetVehicleComponentInSlot(id_x,13);
new query[164];
format(query,sizeof(query),"SELECT * FROM autos WHERE nummer='%i'",vInfo[id_x][v_nummer]);
mysql_function_query(dbhandle,query,true,"OnCarsSaved","i",id_x);
}
return 1;
}

public OnCarsSaved(vehicleid)
{
new num_rows, num_fields;
cache_get_data(num_rows,num_fields,dbhandle);
if(!num_rows)
{
new query[164];
format(query,sizeof(query),"INSERT INTO autos (x,y,z,r,paintjob,Color1,Color2,Spoiler,Hood,Roof,Sideskirt) VALUES('%f','%f','%f','%f','%i','%i','%i','%i','%i')",vInfo[vehicleid][v_x],vInfo[vehicleid][v_y],vInfo[vehicleid][v_z],vInfo[vehicleid][v_r],vInfo[vehicleid][v_paintjob],vInfo[vehicleid][v_Color1],vInfo[vehicleid][v_Color2],vInfo[vehicleid][v_spoiler],vInfo[vehicleid][v_hood],vInfo[vehicleid][v_roof],vInfo[vehicleid][v_sideskirt]);
mysql_function_query(dbhandle,query,false,"","");
format(query,sizeof(query),"INSERT INTO autos (Lamps,Nitro,Exhaust,Wheels,Stereo,Hydraulics,Front_Bumper,Rear_Bumper,Vent_Left,Vent_Right) VALUES ('%i','%i','%i','%i','%i','%i','%i','%i','%i','%i')",vInfo[vehicleid][v_lamps],vInfo[vehicleid][v_nitro],vInfo[vehicleid][v_exhaust],vInfo[vehicleid][v_wheels],vInfo[vehicleid][v_stereo],vInfo[vehicleid][v_hydraulics],vInfo[vehicleid][v_front_bumper],vInfo[vehicleid][v_rear_bumper],vInfo[vehicleid][v_vent_left],vInfo[vehicleid][v_vent_right]);
mysql_function_query(dbhandle,query,false,"","");
}
else
{
new query[200];
format(query,sizeof(query),"UPDATE autos x='%f',y='%f',z='%f',r='%f',paintjob='%i',Color1='%i' WHERE id='%i'",vInfo[vehicleid][v_x],vInfo[vehicleid][v_y],vInfo[vehicleid][v_z],vInfo[vehicleid][v_r],vInfo[vehicleid][v_paintjob],vInfo[vehicleid][v_Color1],vInfo[vehicleid][v_Color2], vInfo[vehicleid][v_db_id]);
mysql_function_query(dbhandle,query,false,"","");
format(query,sizeof(query),"UPDATE autos Color2='%i',Spoiler='%i',Hood='%i',Roof='%i',Sideskirt='%i' WHERE id='%i'",vInfo[vehicleid][v_Color1],vInfo[vehicleid][v_spoiler],vInfo[vehicleid][v_hood],vInfo[vehicleid][v_roof],vInfo[vehicleid][v_sideskirt],vInfo[vehicleid][v_db_id]);
mysql_function_query(dbhandle,query,false,"","");
format(query,sizeof(query),"UPDATE autos Lamps='%i',Nitro='%i',Exhaust='%i',Wheels='%i',Stereo='%i' WHERE id='%i'",vInfo[vehicleid][v_lamps],vInfo[vehicleid][v_nitro],vInfo[vehicleid][v_exhaust],vInfo[vehicleid][v_wheels],vInfo[vehicleid][v_stereo],vInfo[vehicleid][v_db_id]);
mysql_function_query(dbhandle,query,false,"","");
format(query,sizeof(query),"UPDATE autos Hydraulics='%i',Front_Bumper='%i',Rear_Bumper='%i',Vent_Left='%i',Vent_Right='%i' WHERE id='%i'",vInfo[vehicleid][v_hydraulics],vInfo[vehicleid][v_front_bumper],vInfo[vehicleid][v_rear_bumper],vInfo[vehicleid][v_vent_left],vInfo[vehicleid][v_vent_right],vInfo[vehicleid][v_db_id]);
mysql_function_query(dbhandle,query,false,"","");
}
}

Schonmal Danke im vorraus für eure hilfe

Hallo liebe com,

ich brauche dringend hilfe...
ich habe unter OnGameModeInit eingegeben das ein Bot connecten und einen Timer rein gemacht das er mich verfolgt wenn ich in der nähe bin...
funkt auch alles aber sobalt ich dann auf den server komme stürzt er ab


Weiß vllt einer warum???




OnGameModeInit
new tmp[128];
tmp="test";
new npc = ConnectRNPC(tmp);
SetPVarString(npc, "NPCNAME", tmp);
SetPVarInt(npc, "NPCID", npc);
new string[128];
format(string,sizeof(string), "Bot wurde verbunden. (ID: %d | Name: %s)", npc, tmp);
print(string);

[b]DER TIMER[/b]
public zombietimer1(playerid)
{
new Float:x, Float:y, Float:z;
if(GetPVarInt(playerid, "AufVerfolgung")==1)
{
GetPlayerPos(GetPVarInt(playerid, "VerfolgterSpieler"),x,y,z);
if(IsPlayerInRangeOfPoint(playerid, 20.0, x,y,z))
{
ApplyAnimation(playerid,"PED","WALK_DRUNK",4.1,1,1,1,1,1,1);
MoveRNPC(playerid, x,y,z, 0.040);
}
else
{
SetPVarInt(playerid, "AufVerfolgung", 0);
}
}
else
{
for(new i=0;i<MAX_PLAYERS;i++)
{
if(IsPlayerNPC(i)==0)
{
GetPlayerPos(i, x,y,z);
if(IsPlayerInRangeOfPoint(playerid, 20.0, x,y,z))
{
SetPVarInt(playerid, "AufVerfolgung", 1);
SetPVarInt(playerid, "VerfolgterSpieler", i);
ApplyAnimation(playerid,"PED","WALK_DRUNK",4.1,1,1,1,1,1,1);
MoveRNPC(playerid, x,y,z, 0.004);

break;
}
}

}
}
return;
}