Immer noch
Beiträge von Fabi.StaR
-
-
Hir der Warning:
Spoiler anzeigen C:\Users\Fabian\Desktop\Mein Server\gamemodes\Selfmade.pwn(4026) : warning 208: function with tag result used before definition, forcing reparse
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhaseSpoiler anzeigen 1 Warning.Hir der stock:
Spoiler anzeigen stock Float:mysql_GetFloatWithInt(Table[], Field[], Where[], Is)//Die Zeile
{
new query[128], Float:sqlfloat;
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
format(query, 128, "SELECT %s FROM %s WHERE %s = '%d'", Field, Table, Where, Is);
mysql_query(query);
mysql_store_result();
mysql_fetch_float(sqlfloat);
mysql_free_result();
return sqlfloat;
} -
-
Find ich gut, ich brauch guthaben ich versuch mal mein Glück
-
Wie kann ich ein autohaus car speichern und laden lassen?? und wie das es dann wenn man sich ausloggt zerstört wird und wenn man sich ein loggt createt wird??
info: Speicher art MYSQL
-
Zeig mal on player requestclass
-
ehm eine dumme frage was willst du eigentlich von uns ???
-
mach es do
Spoiler anzeigen #include <a_samp>
#include <Dini>Spoiler anzeigen #pragma tabsize 0
#define DIALOG_LOGIN 1
#define DIALOG_REGISTER 2Spoiler anzeigen #define COLOR_RED 0xAA3333AA
#define COLOR_GREEN 0x33AA33AASpoiler anzeigen main()
{
print("\n----------------------------------");
print(" ~~~");
print("----------------------------------\n");
}Spoiler anzeigen public OnGameModeInit()
{
// Don't use these lines if it's a filterscript
SetGameModeText("Hallo");
AddPlayerClass(0,1104.9427,-1796.1571,15.9093,86.5387,0,0,0,0,0,0); // start
AddPlayerClass(1,1104.9427,-1796.1571,15.9093,86.5387,0,0,0,0,0,0); // start
AddStaticVehicle(494,2037.8944,1342.9401,10.6356,179.2003,42,30); // auto1
AddStaticVehicle(415,1098.4344,-1775.6050,13.2404,89.0712,42,30); // carSpoiler anzeigen return 1;
}Spoiler anzeigen public OnGameModeExit()
{
return 1;
}Spoiler anzeigen public OnPlayerRequestClass(playerid, classid)
{
SetPlayerPos(playerid,1104.9427,-1796.1571,15.9093);
SetPlayerFacingAngle(playerid,86.5387);
SetPlayerCameraPos(playerid,1104.9427,-1796.1571,15.9093);
SetPlayerCameraLookAt(playerid,1104.9427,-1796.1571,15.9093);
return 1;
}Spoiler anzeigen public OnPlayerConnect(playerid)
{
ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Regeistrieren","Gib bitte das Passwort ein!","Register","Abbrechen");
RemoveBuildingForPlayer(playerid, 3777, 831.9609, -1191.1406, 25.0391, 0.25);
RemoveBuildingForPlayer(playerid, 3777, 868.1328, -1191.1406, 25.0391, 0.25);
RemoveBuildingForPlayer(playerid, 5926, 816.3359, -1217.1484, 26.4453, 0.25);
RemoveBuildingForPlayer(playerid, 3777, 902.3359, -1191.1406, 25.0391, 0.25);
RemoveBuildingForPlayer(playerid, 6005, 895.2578, -1256.9297, 31.2344, 0.25);
RemoveBuildingForPlayer(playerid, 5836, 816.3359, -1217.1484, 26.4453, 0.25);
RemoveBuildingForPlayer(playerid, 3776, 831.9609, -1191.1406, 25.0391, 0.25);
RemoveBuildingForPlayer(playerid, 3776, 868.1328, -1191.1406, 25.0391, 0.25);
RemoveBuildingForPlayer(playerid, 5838, 895.2578, -1256.9297, 31.2344, 0.25);
RemoveBuildingForPlayer(playerid, 3776, 902.3359, -1191.1406, 25.0391, 0.25);
return 1;
}Spoiler anzeigen public OnPlayerDisconnect(playerid, reason)
{
return 1;
}Spoiler anzeigen public OnPlayerSpawn(playerid)
{
return 1;
}Spoiler anzeigen public OnPlayerDeath(playerid, killerid, reason)
{
return 1;
}Spoiler anzeigen public OnVehicleSpawn(vehicleid)
{
return 1;
}Spoiler anzeigen public OnVehicleDeath(vehicleid, killerid)
{
return 1;
}Spoiler anzeigen public OnPlayerText(playerid, text[])
{
return 1;
}Spoiler anzeigen public OnPlayerCommandText(playerid, cmdtext[])
{
if(strcmp("/help", cmdtext, true, 10) == 0)
{
SendClientMessage(playerid, COLOR_GREEN, "Allgemein");
SendClientMessage(playerid, COLOR_GREEN, ".....");
return 1;
}Spoiler anzeigen return 0;
}Spoiler anzeigen public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
return 1;
}Spoiler anzeigen public OnPlayerExitVehicle(playerid, vehicleid)
{
return 1;
}Spoiler anzeigen public OnPlayerStateChange(playerid, newstate, oldstate)
{
return 1;
}Spoiler anzeigen public OnPlayerEnterCheckpoint(playerid)
{
return 1;
}Spoiler anzeigen public OnPlayerLeaveCheckpoint(playerid)
{
return 1;
}Spoiler anzeigen public OnPlayerEnterRaceCheckpoint(playerid)
{
return 1;
}Spoiler anzeigen public OnPlayerLeaveRaceCheckpoint(playerid)
{
return 1;
}Spoiler anzeigen public OnRconCommand(cmd[])
{
return 1;
}Spoiler anzeigen public OnPlayerRequestSpawn(playerid)
{
return 1;
}Spoiler anzeigen public OnObjectMoved(objectid)
{
return 1;
}Spoiler anzeigen public OnPlayerObjectMoved(playerid, objectid)
{
return 1;
}Spoiler anzeigen public OnPlayerPickUpPickup(playerid, pickupid)
{
return 1;
}Spoiler anzeigen public OnVehicleMod(playerid, vehicleid, componentid)
{
return 1;
}Spoiler anzeigen public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
return 1;
}Spoiler anzeigen public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
return 1;
}Spoiler anzeigen public OnPlayerSelectedMenuRow(playerid, row)
{
return 1;
}Spoiler anzeigen public OnPlayerExitedMenu(playerid)
{
return 1;
}Spoiler anzeigen public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
return 1;
}Spoiler anzeigen public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
return 1;
}Spoiler anzeigen public OnRconLoginAttempt(ip[], password[], success)
{
return 1;
}Spoiler anzeigen public OnPlayerUpdate(playerid)
{
return 1;
}Spoiler anzeigen public OnPlayerStreamIn(playerid, forplayerid)
{
return 1;
}Spoiler anzeigen public OnPlayerStreamOut(playerid, forplayerid)
{
return 1;
}Spoiler anzeigen public OnVehicleStreamIn(vehicleid, forplayerid)
{
return 1;
}Spoiler anzeigen public OnVehicleStreamOut(vehicleid, forplayerid)
{
return 1;
}Spoiler anzeigen public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
if(dialogid==DIALOG_REGISTER)
{
if(response== 0)
{
SendClientMessage(playerid,COLOR_RED,"Du hast den Vorgang abgebrochen.");
Kick(playerid);
return 1;
}
else
{
if(!strlen(inputtext))
{
SendClientMessage(playerid,COLOR_RED,"Das Passwort war nicht lang genug");
ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Regeistrieren","Gib bitte das Passwort ein!","Register","Abbrechen");
return 1;
}
Register(playerid,inputtext);
return 1;
}
}
return 1;
}
public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
return 1;
}Spoiler anzeigen stock Register(playerid,key[])
{
new Spielerdatei[64];
new name[MAX_PLAYER_NAME];
GetPlayerName(playerid,name,sizeof(name));
format(Spielerdatei,sizeof(Spielerdatei),"/Accounts/%s.txt",name);
dini_Create(Spielerdatei);
dini_Set(Spielerdatei,"Passwort",key);
SendClientMessage(playerid,COLOR_RED,"Erfolgreich Regestriert");
return 1;
} -
Kann mir einer helfen?
-
Hir das Connect
Spoiler anzeigen stock Connect_To_Database()
{
mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
if(mysql_ping() == 1)
{
print("<-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!");
return true;
}
else
{
print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
print("<-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
if(mysql_ping() == 1)
{
print("<-| [MYSQL] Es konnte im 2 Versuch eine Verbindung hergestellt werden!");
return true;
}
else
{
print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
print("<-| [MYSQL] Der Server wird nun beendet!");
SendRconCommand("exit");
return true;
}
}
} -
Bei mir ist der debug log so:
SQL
Alles anzeigen[15:08:09] [15:08:09] --------------------------- [15:08:09] MySQL Debugging activated (10/20/12) [15:08:09] --------------------------- [15:08:09] [15:08:09] CMySQLHandler::~CMySQLHandler() - deconstructor called. [15:08:09] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead) [15:08:09] CMySQLHandler::Disconnect() - You cannot call this function now. (Reason: Connection is dead) [15:08:34] [15:08:34] --------------------------- [15:08:34] MySQL Debugging activated (10/20/12) [15:08:34] --------------------------- [15:08:34]
-
mysql_SetString("FraktionsKassen","Fraktion",frakname(i),"Fraktion", FKasse[i][FraktName]);
und bei load mysql_GetString
-
Welche zeile ist es?
-
stock mysql_GetFloat(Table[], Field[], Where[], Is[])
{
new query[128], Float:sqlfloat;
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Is, Is);
format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
mysql_query(query);
mysql_store_result();
mysql_fetch_float(sqlfloat);
mysql_free_result();
return true; //Zeile
} -
Guten Abend,
Wie kann men den Fahrzeug namen abfragen??Wäre net wenn jemand mit helfen könnte
-
Mein Vehicle id wird net gespeiert aber warum???
ihr der stock:
Spoiler anzeigen stock CreateCar(playerid, car[])
{
new query[1024],Name[MAX_PLAYER_NAME];
GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
mysql_real_escape_string(Name,Name);
mysql_real_escape_string(car,car);
format(query, sizeof(query), "INSERT INTO `PrivatCars` (`Name`, `CarID`) VALUES ('%s', '%d')", Name, car);
mysql_query(query);
return true;
}und ihr die verwändung:
Spoiler anzeigen ocmd:buycar(playerid, params[])
{
for(new i=0; i<sizeof(SellCar); i++)
{
if(GetPlayerVehicleID(playerid)==SellCar[i][vehid])
{
new geld = SellCar[i][CarPreis];
if(GetPlayerMoney(playerid) >= geld)
{
GivePlayerMoney(playerid,-geld);
CreateVehicle(SellCar[i][Carid],742.2209,-1344.2977,13.2459,268.1639,-1,-1,60000);
PrivatCar[playerid][PrivatCarName] = SellCar[i][CarName];
PrivatCar[playerid][privatmodelid]= SellCar[i][Carid];//hir
PrivatCar[playerid][ParkX] = 742.2209;
PrivatCar[playerid][ParkY] = -1344.2977;
PrivatCar[playerid][ParkZ] = 13.2459;
PrivatCar[playerid][ParkA] = 268.1639;
SaveCar(playerid);
CreateCar(playerid,PrivatCar[playerid][privatmodelid]);// hir
TogglePlayerControllable(playerid,1);
RemovePlayerFromVehicle(playerid);
}
else
{
SendClientMessage(playerid,Rot,"Du hast nicht genung Geld dabei!");
TogglePlayerControllable(playerid,1);
RemovePlayerFromVehicle(playerid);
}
}
}
return 1;
} -
Bitte um hilfe
Hir die stocks:
Spoiler anzeigen stock SavePark(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
if(GetPVarInt(playerid,"Eingeloggt") == 1)
{
new Float:X,Float:Y,Float:Y,Float:A;
GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
GetPlayerPos(playerid,X,Y,Z)
GetPlayerFacingAngle(playerid,A)
mysql_SetFloat("privatcars","CarPosX",PrivatCar[playerid][ParkX],"Name", PrivatCar[playerid][PrivatNAme]);
mysql_SetFloat("privatcars","CarPosY",PrivatCar[playerid][ParkY],"Name", PrivatCar[playerid][PrivatNAme]);
mysql_SetFloat("privatcars","CarPosZ",PrivatCar[playerid][ParkZ],"Name", PrivatCar[playerid][PrivatNAme]);
mysql_SetFloat("privatcars","CarPosA",PrivatCar[playerid][ParkA],"Name", PrivatCar[playerid][PrivatNAme]);
}
}
return 1;
}
stock SaveCar(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
mysql_SetInt("privatcars","Color1",PrivatCar[playerid][privatColor1],"Name", PrivatCar[playerid][PrivatNAme]);
mysql_SetInt("privatcars","Color2",PrivatCar[playerid][privatColor2],"Name", PrivatCar[playerid][PrivatNAme]);
mysql_SetString("privatcars","CarName",PrivatCar[playerid][PrivatCarName],"Name", PrivatCar[playerid][PrivatNAme]);
}
}
stock LoadCar(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
PrivatCar[playerid][privatColor1] = mysql_GetInt("privatcars", "Color1", "Name",PrivatCar[playerid][PrivatNAme]);
PrivatCar[playerid][privatColor2] = mysql_GetInt("privatcars", "Color2", "Name",PrivatCar[playerid][PrivatNAme]);
PrivatCar[playerid][PrivatCarName] = mysql_GetInt("privatcars", "CarName", "Name",PrivatCar[playerid][PrivatNAme]);
}
return 1;
} -
stock CreateAccount(playerid, pass[]
Irgendwie nicht so das richtige.
hir der richtige:
Spoiler anzeigen stock CreateCar(playerid, car[])
{
new query[1024],Name[MAX_PLAYER_NAME];
GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
mysql_real_escape_string(Name,Name);
mysql_real_escape_string(car,car);
format(query, sizeof(query), "INSERT INTO `PrivatCars` (`Name`, `CarName`) VALUES ('%s', '%s')", Name, car);
mysql_query(query);
return true;
} -
Hir mein CreateCar:
Spoiler anzeigen stock CreateAccount(playerid, pass[])
{
new query[256],Name[MAX_PLAYER_NAME];
GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
mysql_real_escape_string(Name,Name);
mysql_real_escape_string(pass,pass);
format(query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Passwort`) VALUES ('%s', '%s')", Name, pass);
mysql_query(query);
return true;
}hir mein SaveCar:
Spoiler anzeigen stock SavePark(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
if(GetPVarInt(playerid,"Eingeloggt") == 1)
{
new Float:X,Float:Y,Float:Y,Float:A;
GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
GetPlayerPos(playerid,X,Y,Z)
GetPlayerFacingAngle(playerid,A)
mysql_SetFloat("privatcars","CarPosX",PrivatCar[playerid][ParkX],"Name", PrivatCar[playerid][PrivatNAme]);
mysql_SetFloat("privatcars","CarPosY",PrivatCar[playerid][ParkY],"Name", PrivatCar[playerid][PrivatNAme]);
mysql_SetFloat("privatcars","CarPosZ",PrivatCar[playerid][ParkZ],"Name", PrivatCar[playerid][PrivatNAme]);
mysql_SetFloat("privatcars","CarPosA",PrivatCar[playerid][ParkA],"Name", PrivatCar[playerid][PrivatNAme]);
}
}
return 1;
}
stock SaveCar(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
mysql_SetInt("privatcars","Color1",PrivatCar[playerid][privatColor1],"Name", PrivatCar[playerid][PrivatNAme]);
mysql_SetInt("privatcars","Color2",PrivatCar[playerid][privatColor2],"Name", PrivatCar[playerid][PrivatNAme]);
mysql_SetString("privatcars","CarName",PrivatCar[playerid][PrivatCarName],"Name", PrivatCar[playerid][PrivatNAme]);
}
}hir mein LoadCar:
Spoiler anzeigen stock LoadCar(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
GetPlayerName(playerid,PrivatCar[playerid][PrivatNAme], MAX_PLAYER_NAME);
PrivatCar[playerid][privatColor1] = mysql_GetInt("privatcars", "Color1", "Name",PrivatCar[playerid][PrivatNAme]);
PrivatCar[playerid][privatColor2] = mysql_GetInt("privatcars", "Color2", "Name",PrivatCar[playerid][PrivatNAme]);
PrivatCar[playerid][PrivatCarName] = mysql_GetInt("privatcars", "CarName", "Name",PrivatCar[playerid][PrivatNAme]);
}
return 1;
} -
mach mal PlayerName[64] zu PlayerName[MAX_PLAYERS]