Kommt drauf an.
Was soll den der Timer machen, wenn er läuft? Und soll er sich wiederholen, oder nur einmal aufgerufen werden?
[SAMMELTHREAD] Kleine Scripting Fragen
- Rafelder
- Unerledigt
Dein Problem konnte durch einen User gelöst werden? Bedank dich bei ihm indem du seinen Beitrag als Hilfreich markierst sowie einen Daumen oben dalässt
Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!
Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
-
-
er soll nur einmal starten, also jedes mal wenn die schwelle von 1 auf 2 Spieler wechselt
-
Ok, dann so:
Unter den Includes (global):
new onlinePlayers;
new onlineTimer = -1;OnPlayerDisconnect:
onlinePlayers--;
if(onlinePlayers == 1) if(onlineTimer != -1) KillTimer(onlineTimer), onlineTimer = -1;OnPlayerConnect:
onlinePlayers++;
if(onlinePlayers == 2) onlineTimer = SetTimer("ZweiSpielerJetzt", 120000, false); //120 sek = 2 min = 120.000 MillisekundenUnd das Callback:
forward ZweiSpielerJetzt();
public ZweiSpielerJetzt();
{
onlineTimer = -1;
//Mach was hier...
return 1;
} -
SetPlayerHealth(playerid, FLOAT_INFINITY);
zu:
SetPlayerHealth(playerid, 999999.0);
Der Spieler stirbt immmer noch beim OffDuty gehen... -
Die Leben musst du natürlich noch richtig speichern, ich dachte das wäre klar.
Das kannst du mit http://wiki.sa-mp.com/wiki/SetPVarFloat machen.
Laden dann mit GetPVarFloat. -
Wieso wird mir das SendClientMessageToAll nicht gesendet? Beim Printen wird alles richtig angezeigt.
ocmd:setleader(playerid,params[])
{
new pID,fID,string[386];
if(!IsPlayerAnAdmin(playerid,0)) return SendClientMessage(playerid,0xFF3C3CFF,"AdmCmd: Sie besitzen nicht die nötigen Rechte um diesen Befehl zu nutzen!");
if(!IsPlayerConnected(pID))return SendClientMessage(playerid,0xEE8613FF,"Der angegebene Spieler ist nicht eingeloggt!");
if(sscanf(params,"ud",pID,fID)) return SendClientMessage(playerid,0xFFFFFF,"Info: /setleader [Spieler ID] [Fraktion´s ID]");
if(Spieler[pID][pFraktion] != 0)return SendClientMessage(playerid,0xEE8613FF,"Der angegebene Spieler ist bereits in einer Fraktion.");
if(fID<1||fID>3)return SendClientMessage(playerid,0xEE8613FF,"Wähle bitte eine Fraktion zwischen 1 und 3 aus.");
Spieler[pID][pFraktion] = fID;
Spieler[pID][pFrakLeader] = 1;
Spieler[pID][pFrakRang] = 6;
Spieler[pID][pFrakSkin] = 0;
Spieler[pID][pFrakDuty] = 0;
format(string,sizeof(string),"{FF1111}Admin Info: {E5E5E5}Der Spieler {23A7F5}%s {E5E5E5}wurde von {23A7F5}%s {E5E5E5}zum Leader der Fraktion {FF7979}%s {E5E5E5}Ernannt!",Spielername(pID),Spielername(playerid),FraktionsName(fID));
SendClientMessageToAll(0xE5E5E5FF,string);
print(string);
SavePlayerData(pID);
return 1;
} -
Das liegt daran, dass SendClientMessageToAll und SendClientMessage nur maximal 144 Zeichen ausgeben können (plus EOS).
Schreibe deine Deklarationen so, dann siehst du ab wann es abgeschnitten wird, mehr kann nicht angezeigt werden.
new pID,fID,string[145]; -
Hallo zusammen,
wenn OnPlayerSpawn aufgerufen wird, soll der Spieler seine Waffen erhalten, allerdings bekommt er keine:stock LoadWeapons(playerid)
{
new query[256];
format(query,sizeof(query),"SELECT * FROM Waffen WHERE Name='%s'",PlayerName[playerid]);
mysql_query(query);
new data2[64],wstring[10],data[64];
new waffe, wammo;
mysql_store_result();
if(mysql_num_rows()==0)
{
mysql_free_result();
format(query,sizeof(query),"INSERT INTO Waffen (Name) VALUES ('%s')",PlayerName[playerid]);
mysql_query(query);
mysql_free_result();
return 1;
}
mysql_free_result();
for(new i=1; i<=11; i++)
{
format(str,144,"SELECT Waffe%i, Ammo%i FROM Waffen WHERE Name='%s'",i,i,PlayerName[playerid]);
mysql_query(str);
mysql_store_result();
format(wstring,sizeof(wstring),"Waffe%i",i);
mysql_fetch_field_row(data,wstring);
format(wstring,sizeof(wstring),"Ammo%i",i);
mysql_fetch_field_row(data2,wstring);
waffe=strval(data);
wammo=strval(data2);
GivePlayerWeapon(playerid,waffe,wammo);
mysql_free_result();
format(str,144,"UPDATE Waffen SET Ammo%i='0' WHERE Name='%s'",i,PlayerName[playerid]);
mysql_query(str);
mysql_free_result();
}
format(str,144,"SELECT Armor FROM Waffen WHERE Name='%s'",PlayerName[playerid]);
mysql_query(str);
mysql_store_result();
mysql_fetch_field_row(data,"Armor");
mysql_free_result();
wammo=strval(data);
SetPlayerArmour(playerid,wammo);
SetPVarInt(playerid,"waffengeladen",1);
return 1;
}Anbei der Auszug aus der mysqllog:
Spoiler anzeigen CMySQLHandler::Query(SELECT * FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_num_rows( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::NumRows() - Returned 1 row(s)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe1, Ammo1 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe1) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo1) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo1='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe2, Ammo2 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe2) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo2) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo2='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe3, Ammo3 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe3) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo3) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo3='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe4, Ammo4 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe4) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo4) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo4='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe5, Ammo5 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe5) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo5) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo5='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe6, Ammo6 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe6) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo6) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo6='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe7, Ammo7 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe7) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo7) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo7='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe8, Ammo8 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe8) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo8) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo8='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe9, Ammo9 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe9) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo9) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo9='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe10, Ammo10 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe10) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo10) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo10='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe11, Ammo11 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe11) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo11) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo11='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Armor FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Armor) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT * FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_num_rows( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::NumRows() - Returned 1 row(s)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe1, Ammo1 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe1) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo1) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo1='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe2, Ammo2 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe2) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo2) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo2='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe3, Ammo3 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe3) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo3) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo3='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe4, Ammo4 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe4) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo4) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo4='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe5, Ammo5 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe5) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo5) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo5='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe6, Ammo6 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe6) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo6) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo6='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe7, Ammo7 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe7) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo7) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo7='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe8, Ammo8 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe8) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo8) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo8='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe9, Ammo9 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe9) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo9) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo9='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe10, Ammo10 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe10) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo10) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo10='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Waffe11, Ammo11 FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Waffe11) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Ammo11) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(UPDATE Waffen SET Ammo11='0' WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - The result is already empty.Spoiler anzeigen [14:56:55] >> mysql_query( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::Query(SELECT Armor FROM Waffen WHERE Name='CrimeX') - Successfully executed.Spoiler anzeigen [14:56:55] >> mysql_store_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::StoreResult() - Result was stored.Spoiler anzeigen [14:56:55] >> mysql_fetch_field_row( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FetchField(Armor) - You cannot call this function now. (Reason: Fields/Rows are empty.)Spoiler anzeigen [14:56:55] >> mysql_free_result( Connection handle: 1 )Spoiler anzeigen [14:56:55] CMySQLHandler::FreeResult() - Result was successfully free'd.Spoiler anzeigen [14:56:55] OnQueryError() - Called.Spoiler anzeigen [14:56:55] OnQueryError() - Called.Spoiler anzeigen [14:56:55] OnQueryError() - Called.Spoiler anzeigen [14:56:55] OnQueryError() - Called.Spoiler anzeigen [14:56:55] OnQueryError() - Called.Spoiler anzeigen [14:56:55] OnQueryError() - Called.Spoiler anzeigen [14:56:55] OnQueryError() - Called.Spoiler anzeigen [14:56:55] OnQueryError() - Called. -
OnQueryError() - Called
Füge das mal ein:public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
switch(errorid)
{
case CR_COMMAND_OUT_OF_SYNC:
{
printf("Commands out of sync for thread ID: %d",resultid);
}
case ER_SYNTAX_ERROR:
{
printf("Something is wrong in your syntax, query: %s",query);
}
}
return 1;
}und zeig dann mal den server_log

-
Es wird nichts geprintet.
-
Okay, dann machs mal so:
public OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle)
{
return printf("Error: %s - Query: %s",error,query);
} -
Die Query Errors lagen wohl nicht an den Waffen, sondern an allgemeinen Userdaten. Habe diese nun richtig gestellt, aber bei den Waffen nichts verändert.
Nun wird auch nichts mehr geprintet, die Waffen gibt es aber trotzdem nicht. -
Das ist keine kleine Scripting Frage. Dieser Thread ist nicht für MySQL Debugging gedacht. Merke dir das bitte für das nächste Mal und erstelle dann einen Thread. Danke!

Teste es mal so:
Spoiler anzeigen stock LoadWeapons(playerid)
{
new query[256];
format(query,sizeof(query),"SELECT * FROM Waffen WHERE Name='%s'",PlayerName[playerid]);
mysql_query(query);
mysql_store_result();
new wstring[10],data[64];
new waffe, wammo;
if(mysql_num_rows()==0)
{
mysql_free_result();
format(query,sizeof(query),"INSERT INTO Waffen (Name) VALUES ('%s')",PlayerName[playerid]);
mysql_query(query);
return 1;
}
for(new i=1; i<=11; i++)
{
format(wstring,sizeof(wstring),"Waffe%i",i);
mysql_fetch_field_row(data,wstring);
waffe=strval(data);
format(wstring,sizeof(wstring),"Ammo%i",i);
mysql_fetch_field_row(data,wstring);
wammo=strval(data);
GivePlayerWeapon(playerid,waffe,wammo);
format(str,144,"UPDATE Waffen SET Ammo%i='0' WHERE Name='%s'",i,PlayerName[playerid]);
mysql_query(str);
}
mysql_fetch_field_row(data,"Armor");
mysql_free_result();
wammo=strval(data);
SetPlayerArmour(playerid,wammo);
SetPVarInt(playerid,"waffengeladen",1);
return 1;
}
Wenn es nicht geht, poste den MySQL Log. -
Beitrag von Fernando_Jizuya ()
Dieser Beitrag wurde gelöscht, Informationen über den Löschvorgang sind nicht verfügbar. -
Du hast "SQLID" auf PRIMARY gesetzt, in deiner Datenbank. Mach das weg, und mach stattdessen eine Spalte "id" dazu, der du den PRIMARY KEY gibst.
-
-
Bei UpdateHaus destroyt das Script nicht den 3DText...
stock UpdateHaus(id)
{
new str[128];
if(hInfo[id][h_pickup])
{
DestroyPickup(hInfo[id][h_pickup]);
}
if(hInfo[id][h_text])
{
Delete3DTextLabel(hInfo[id][h_text]);
}
if(!strlen(hInfo[id][hBesitzer]))
{
hInfo[id][h_pickup] = CreatePickup(1273, 1, hInfo[id][hX], hInfo[id][hY], hInfo[id][hZ], -1);
format(str,sizeof(str), "HausID: %i\nZu Verkaufen\nPreis: %i$\n/hauskaufen", hInfo[id][hID], hInfo[id][Preis]);
hInfo[id][h_text] = Text3D:Create3DTextLabel(str, WEISS, hInfo[id][hX], hInfo[id][hY], hInfo[id][hZ], 10, 0, 1);
} else {
hInfo[id][h_pickup] = CreatePickup(1272,1,hInfo[id][hX],hInfo[id][hY],hInfo[id][hZ], -1);
format(str,sizeof(str), "HausID: %i\nBesitzer: %s\n'F' zum hinein gehen.", hInfo[id][hID], hInfo[id][hBesitzer]);
hInfo[id][h_text] = Text3D:Create3DTextLabel(str, GELB, hInfo[id][hX], hInfo[id][hY], hInfo[id][hZ], 10, 0, 1);
}
return 1;
} -
Schreibe das bei OnGameModeInit hin:
for(new i=0; i<sizeof(hInfo); i++)
{
hInfo[i][h_text] = Text3D:-1;
hInfo[i][h_pickup] = -1;
} -
Das funktioniert nicht...
bei OnGameModeInit hat der id nicht und i geht auch nicht.

-
Änder das "id" zu "i"

