Hi,
ich war heute auf der gamescom und habe am msi-Stand CS:GO gespielt.
Da ich es total verpeilt habe, mir auch nur Ansatzweise den Namen der Tastatur zu merken, frage ich nun euch.
Hier ist ein Bild von (mir und) der Tastatur:
Quelle: Ich selber
Ich fänds Cool, wenn mir jemand sagen könnte, welche Tastatur das ist.
lg
Deagle
P.S.: Es gibt keine anderen Aufnahmen davon, leider.
Du könntest mit einem Timer oder nach einer bestimmten Anzahl von Sprüngen dem Spieler die "Außer Atem"-Animation geben um somit eine Art Lungenvolumen zu simulieren.
Hallo,
ohne dich dabei angreifen zu wollen: Ist es möglich, deine Frage in einem grammatikalisch korrektem Satz zu stellen?
Natürlich passiert nichts.
Du musst uns einmal den Code von "OnQueryFinish" geben. Besser gesagt den case "_SQL_ACCOUNT_CHECK".
Besitzt dein Server Bots?
Wenn ja könnte es vielleicht daran liegen, dass dort 2 User in die Datenbank eingetragen werden.
Ansonsten zeig uns doch mal die Funktion, mit der du User in die Datenbank eintragen lässt.
if(auto_model >= 400 && auto_model <= 611)
Hallo,
ich habe heute ein altes Netbook mit einer Debian-Distribution gefunden.
Nun würde ich diese gerne neu aufsetzen, habe allerdings keine Ahnung, was genau ich da nun machen soll.
Ich habe es mit debootstrap versucht - ohne Erfolg.
Das Netbook hat 1GB RAM, 4GB Festplattenkapazität und einen Intel Celeron M Prozessor (630MHz) verbaut.
Meine Frage lautet also nun: Wie kann ich die dort vorhandene Linux-Distribution (Debian) neu installieren?
Ich habe bereits einen bootfähigen USB Stick mit unetbootin erstellt und im BIOS eingestellt, dass er von dem removable device (USB Stick) booten soll.
Jedoch bootet er immer von der Platte.
Nehme ich jedoch die Platte komplett aus dem Bootmenü, meint er, dass ich ein vernünftiges Bootdevice einstecken soll.
lg
Deagle
Du kannst ja die Werte die du über sscanf eingibst direkt in die Variablen schreiben, du musst es nicht aus der Datenbank laden, was du zuvor eingetragen hast.
Das stimmt schon.
Allerdings lädt das seit dem SQL-Update auch nicht mehr alle Fraktionen, er lädt nur 2.
Siehe:
[17:30:51] <-| [MYSQL-LOAD] Die Fraktion 0 wurde erfolgreich geladen - Dauer: 0ms
[17:30:51] <-| [MYSQL-LOAD] Die Fraktion 1 wurde erfolgreich geladen - Dauer: 0msmysql_pquery(dbHandle,"SELECT * FROM `Frak`","OnQueryFinish","sd","SELECT * FROM `Frak`",QueryCallFrak);
case QueryCallFrak:
{
cache_get_data(rows,fields);
new fr;
for(;fr<rows;fr++) {
//if(fr==0){fr++;}
cache_get_field_content(fr,"ID",result);
FrakInfo[fr][fID] = strval(result);
cache_get_field_content(fr,"Kasse",result);
FrakInfo[fr][fKasse] = strval(result);
cache_get_field_content(fr,"Marihuana",result);
FrakInfo[fr][fMarihuana] = strval(result);
cache_get_field_content(fr,"Mats",result);
FrakInfo[fr][fMats] = strval(result);
cache_get_field_content(fr,"Gangwaffen",result);
FrakInfo[fr][fGangwaffen] = strval(result);
cache_get_field_content(fr,"Rank1lohn",result);
FrakInfo[fr][fR1L] = strval(result);
cache_get_field_content(fr,"Rank2lohn",result);
FrakInfo[fr][fR2L] = strval(result);
cache_get_field_content(fr,"Rank3lohn",result);
FrakInfo[fr][fR3L] = strval(result);
cache_get_field_content(fr,"Rank4lohn",result);
FrakInfo[fr][fR4L] = strval(result);
cache_get_field_content(fr,"Rank5lohn",result);
FrakInfo[fr][fR5L] = strval(result);
cache_get_field_content(fr,"Rank6lohn",result);
FrakInfo[fr][fR6L] = strval(result);
cache_get_field_content(fr,"Rank7lohn",result);
FrakInfo[fr][fR7L] = strval(result);
cache_get_field_content(fr,"Rank8lohn",result);
FrakInfo[fr][fR8L] = strval(result);
cache_get_field_content(fr,"LagerOpen",result);
FrakInfo[fr][fWLO] = strval(result);
cache_get_field_content(fr,"Rank1name",result);
format(FrakInfo[fr][fR1N],24,"%s",result);
cache_get_field_content(fr,"Rank2name",result);
format(FrakInfo[fr][fR2N],24,"%s",result);
cache_get_field_content(fr,"Rank3name",result);
format(FrakInfo[fr][fR3N],24,"%s",result);
cache_get_field_content(fr,"Rank4name",result);
format(FrakInfo[fr][fR4N],24,"%s",result);
cache_get_field_content(fr,"Rank5name",result);
format(FrakInfo[fr][fR5N],24,"%s",result);
cache_get_field_content(fr,"Rank6name",result);
format(FrakInfo[fr][fR6N],24,"%s",result);
cache_get_field_content(fr,"Rank7name",result);
format(FrakInfo[fr][fR7N],24,"%s",result);
cache_get_field_content(fr,"Rank8name",result);
format(FrakInfo[fr][fR8N],24,"%s",result);
cache_get_field_content(fr,"Rank1skin",result);
FrakInfo[fr][fR1S] = strval(result);
cache_get_field_content(fr,"Rank2skin",result);
FrakInfo[fr][fR2S] = strval(result);
cache_get_field_content(fr,"Rank3skin",result);
FrakInfo[fr][fR3S] = strval(result);
cache_get_field_content(fr,"Rank4skin",result);
FrakInfo[fr][fR4S] = strval(result);
cache_get_field_content(fr,"Rank5skin",result);
FrakInfo[fr][fR5S] = strval(result);
cache_get_field_content(fr,"Rank6skin",result);
FrakInfo[fr][fR6S] = strval(result);
cache_get_field_content(fr,"Rank7skin",result);
FrakInfo[fr][fR7S] = strval(result);
cache_get_field_content(fr,"Rank8skin",result);
FrakInfo[fr][fR8S] = strval(result);
cache_get_field_content(fr,"WLX",result);
FrakInfo[fr][fWLX] = floatstr(result);
cache_get_field_content(fr,"WLY",result);
FrakInfo[fr][fWLY] = floatstr(result);
cache_get_field_content(fr,"WLZ",result);
FrakInfo[fr][fWLZ] = floatstr(result);
cache_get_field_content(fr,"PosX",result);
FrakInfo[fr][fPosX] = floatstr(result);
cache_get_field_content(fr,"PosY",result);
FrakInfo[fr][fPosY] = floatstr(result);
cache_get_field_content(fr,"PosZ",result);
FrakInfo[fr][fPosZ] = floatstr(result);
cache_get_field_content(fr,"IntX",result);
FrakInfo[fr][fIntX] = floatstr(result);
cache_get_field_content(fr,"IntY",result);
FrakInfo[fr][fIntY] = floatstr(result);
cache_get_field_content(fr,"IntZ",result);
FrakInfo[fr][fIntZ] = floatstr(result);
cache_get_field_content(fr,"Interior",result);
FrakInfo[fr][fInterior] = strval(result);
cache_get_field_content(fr,"VW",result);
FrakInfo[fr][fVW] = strval(result);
cache_get_field_content(fr,"SpawnX",result);
FrakInfo[fr][fSpawnX] = floatstr(result);
cache_get_field_content(fr,"SpawnY",result);
FrakInfo[fr][fSpawnY] = floatstr(result);
cache_get_field_content(fr,"SpawnZ",result);
FrakInfo[fr][fSpawnZ] = floatstr(result);
cache_get_field_content(fr,"SpawnA",result);
FrakInfo[fr][fSpawnA] = floatstr(result);
cache_get_field_content(fr,"Kokain",result);
FrakInfo[fr][fKokain] = strval(result);
cache_get_field_content(fr,"Carslots",result);
FrakInfo[fr][fCarslots] = strval(result);
FrakInfo[fr][fGWP] = CreateDynamicPickup(1239,1,FrakInfo[fr][fWLiX],FrakInfo[fr][fWLiY],FrakInfo[fr][fWLiZ],FrakInfo[fr][fVW]);
FrakInfo[fr][fEntPickup] = CreateDynamicPickup(1318,1,FrakInfo[fr][fPosX],FrakInfo[fr][fPosY],FrakInfo[fr][fPosZ]);
FrakInfo[fr][fExtPickup] = CreateDynamicPickup(1318,1,FrakInfo[fr][fIntX],FrakInfo[fr][fIntY],FrakInfo[fr][fIntZ],FrakInfo[fr][fVW]);
SetTimerEx("LoadFrakVeh",500,0,"d",fr);
}
printf("<-| [MYSQL-LOAD] Die Fraktion %d wurde erfolgreich geladen - Dauer: %dms",fr,oldtime-GetTickCount());
}
}
Auch mein Skinsystem buggt...
Irgendwie hab ich entweder falsch gescriptet, oder die R39-3 braucht ein paar Sekunden um alle Querys auszuführen und die Daten zu "getten"...
/edit: Jeffry:
Aber ich will ja ein neu erstelltes Haus direkt laden und nicht erst beim Nächsten restart. Jeffry:
Ich kann auch normale Querys (mysql_query) ausführen? Wusste ich nicht. lol
Trotzdem bin ich grad total durcheinander o.o
Aber dann werden ja schon erstellte Häuser & Biz nochmal geladen?
Wie rufst du denn diese beiden auf?
case QuerySelectAllBiz:
case QuerySelectAllHouse:
ocmd:createbiz(playerid,params[])
{
if(!IsPlayerAdmin(playerid))return 1;
new p,int,typ[32],name[64];
if(sscanf(params,"iis[32]s[64]",p,int,typ,name))return SendClientMessage(playerid,COLOR_GREY,"Benutze: /createbiz [Preis] [Interior] [Typ] [Name] | Interiorliste: /bints");
if(int <= 5) {
mysql_pquery(dbHandle,"SELECT * FROM `biz`","OnQueryFinish","sdddsds","SELECT * FROM `biz`",QuerySelectAllBiz,playerid,p,name,int,typ);
SendClientMessage(playerid,COLOR_LIGHTGREEN,"Du hast das Biz erfolgreich erstellt!");
} else {
SendClientMessage(playerid,COLOR_LIGHTRED,"Die InteriorID eines Biz' darf nicht größer als 5 sein!");
}
return 1;
}
ocmd:createhouse(playerid,params[])
{
if(IsPlayerAdmin(playerid)) {
new p,r,int;
if(sscanf(params,"iii",p,r,int))return SendClientMessage(playerid,COLOR_GREY,"Benutze: /createhouse [Preis] [Zimmer (max. 6)] [Interior ID (Liste: /hints)]");
{
if(r <= 6) {
if(int <= 10) {
new st[16];
format(st,sizeof st,"%d",r);
mysql_pquery(dbHandle,"SELECT * FROM `haeuser`","OnQueryFinish","sdddsd","SELECT * FROM `haeuser`",QuerySelectAllHouse,playerid,p,st,int);
SendClientMessage(playerid,COLOR_LIGHTGREEN,"Du hast das Haus erfolgreich erstellt!");
} else {
SendClientMessage(playerid,COLOR_LIGHTRED,"Die InteriorID eines Hauses darf nicht größer als 10 sein!");
}
} else {
SendClientMessage(playerid,COLOR_LIGHTRED,"Die Zimmer eines Hauses dürfen nicht mehr als 6 sein!");
}
}
}
return 1;
}
Hi,
wie im Threadtitel beschrieben habe ich seit der Umstellung von MySQL R5 auf R39-3 einige Probleme mit meinem Haus-& Bizsystem.
Die Daten werden zwar in die Tabelle geschrieben, doch nicht geladen.
Dazu hier mein Code:
case QuerySelectAllBiz:
{
cache_get_data(rows,fields);
if(rows > MAX_BIZ) return 0;
new Float:X,Float:Y,Float:Z;
GetPlayerPos(playerid,X,Y,Z);
//schreibt in Tabelle
format(q,sizeof q,"SELECT * FROM `biz` WHERE `ID` = '%d'",rows);
mysql_pquery(dbHandle, q, "OnQueryFinish", "sdd", q, QueryCallLoadBiz, playerid);
}
case QuerySelectAllHouse:
{
cache_get_data(rows,fields);
if(rows > MAX_HAEUSER) return 0;
new Float:X,Float:Y,Float:Z;
GetPlayerPos(playerid,X,Y,Z);
//schreibtr in Tabelle
format(str,sizeof str,"SELECT * FROM `haeuser` WHERE `ID` = '%d'",rows);
mysql_pquery(dbHandle, str, "OnQueryFinish", "sdd", str, QueryCallLoadHouse, playerid);
}
Hier der Code wo das ganze geladen wird:
case QueryCallLoadHouse:
{
cache_get_data(rows,fields);
if(rows > 0) {
new ho;
for(;ho<rows;ho++) {
//if(ho==0){ho++;}
cache_get_field_content(ho,"ID",result);
HausInfo[ho][hID] = strval(result);
cache_get_field_content(ho,"PosX",result);
HausInfo[ho][hPosX] = floatstr(result);
cache_get_field_content(ho,"PosY",result);
HausInfo[ho][hPosY] = floatstr(result);
cache_get_field_content(ho,"PosZ",result);
HausInfo[ho][hPosZ] = floatstr(result);
cache_get_field_content(ho,"Level",result);
HausInfo[ho][hLevel] = strval(result);
cache_get_field_content(ho,"Preis",result);
HausInfo[ho][hPreis] = strval(result);
cache_get_field_content(ho,"Besitzer",result);
format(HausInfo[ho][hBesitzer],24,"%s",result);
cache_get_field_content(ho,"Bought",result);
HausInfo[ho][hBought] = strval(result);
cache_get_field_content(ho,"Rooms",result);
HausInfo[ho][hRooms] = strval(result);
cache_get_field_content(ho,"InteriorID",result);
HausInfo[ho][hInteriorID] = strval(result);
cache_get_field_content(ho,"Interior",result);
HausInfo[ho][hInterior] = strval(result);
cache_get_field_content(ho,"IntX",result);
HausInfo[ho][hIntX] = floatstr(result);
cache_get_field_content(ho,"IntY",result);
HausInfo[ho][hIntY] = floatstr(result);
cache_get_field_content(ho,"IntZ",result);
HausInfo[ho][hIntZ] = floatstr(result);
cache_get_field_content(ho,"Locked",result);
HausInfo[ho][hLocked] = strval(result);
cache_get_field_content(ho,"Rentable",result);
HausInfo[ho][hRentable] = strval(result);
cache_get_field_content(ho,"RentPrice",result);
HausInfo[ho][hRentPrice] = strval(result);
cache_get_field_content(ho,"Renter1",result);
format(HausInfo[ho][hRenter1],24,"%s",result);
cache_get_field_content(ho,"Renter2",result);
format(HausInfo[ho][hRenter2],24,"%s",result);
cache_get_field_content(ho,"Renter3",result);
format(HausInfo[ho][hRenter3],24,"%s",result);
cache_get_field_content(ho,"Renter4",result);
format(HausInfo[ho][hRenter4],24,"%s",result);
cache_get_field_content(ho,"Renter5",result);
format(HausInfo[ho][hRenter5],24,"%s",result);
cache_get_field_content(ho,"Renter6",result);
format(HausInfo[ho][hRenter6],24,"%s",result);
HausInfo[ho][hVW] = HausInfo[ho][hID]+1;
HausInfo[ho][hOutPickup] = CreatePickup(1318,1,HausInfo[ho][hIntX],HausInfo[ho][hIntY],HausInfo[ho][hIntZ],HausInfo[ho][hVW]);
//Label und son mist erstellen
HausInfo[ho][hCreated]=true;
}
}
}
case QueryCallLoadBiz:
{
cache_get_data(rows,fields);
if(rows > 0) {
new bi;
for(;bi<rows;bi++) {
//if(bi==0){bi++;}
cache_get_field_content(bi,"ID",result);
BizInfo[bi][bID] = strval(result);
cache_get_field_content(bi,"PosX",result);
BizInfo[bi][bPosX] = floatstr(result);
cache_get_field_content(bi,"PosY",result);
BizInfo[bi][bPosY] = floatstr(result);
cache_get_field_content(bi,"PosZ",result);
BizInfo[bi][bPosZ] = floatstr(result);
cache_get_field_content(bi,"Level",result);
BizInfo[bi][bLevel] = strval(result);
cache_get_field_content(bi,"Preis",result);
BizInfo[bi][bPreis] = strval(result);
cache_get_field_content(bi,"Besitzer",result);
format(BizInfo[bi][bID],24,"%s",result);
cache_get_field_content(bi,"Bought",result);
BizInfo[bi][bBought] = strval(result);
cache_get_field_content(bi,"Typ",result);
format(BizInfo[bi][bTyp],32,"%s",result);
cache_get_field_content(bi,"Produkte",result);
BizInfo[bi][bProds] = strval(result);
cache_get_field_content(bi,"ProdukteBestellt",result);
BizInfo[bi][bProdsBestellt] = strval(result);
cache_get_field_content(bi,"InteriorID",result);
BizInfo[bi][bInteriorID] = strval(result);
cache_get_field_content(bi,"Interior",result);
BizInfo[bi][bInterior] = strval(result);
cache_get_field_content(bi,"IntX",result);
BizInfo[bi][bIntX] = floatstr(result);
cache_get_field_content(bi,"IntY",result);
BizInfo[bi][bIntY] = floatstr(result);
cache_get_field_content(bi,"IntZ",result);
BizInfo[bi][bIntZ] = floatstr(result);
cache_get_field_content(bi,"Locked",result);
BizInfo[bi][bLocked] = strval(result);
cache_get_field_content(bi,"Kasse",result);
BizInfo[bi][bKasse] = strval(result);
cache_get_field_content(bi,"Name",result);
format(BizInfo[bi][bName],64,"%s",result);
cache_get_field_content(bi,"Price",result);
BizInfo[bi][bPrice] = strval(result);
cache_get_field_content(bi,"MaxProdukte",result);
BizInfo[bi][bMaxProds] = strval(result);
BizInfo[bi][bVW] = bi+1;
BizInfo[bi][bOutPickup] = CreatePickup(1318,1,BizInfo[bi][bIntX],BizInfo[bi][bIntY],BizInfo[bi][bIntZ],BizInfo[bi][bVW]);
//Label und son mist erstellen
BizInfo[bi][bLabel]=Create3DTextLabel(str,COLOR_AO,BizInfo[bi][bPosX],BizInfo[bi][bPosY],BizInfo[bi][bPosZ],13,0,1);
BizInfo[bi][bOutLabel]=Create3DTextLabel("Verlassen:\n~k~~VEHICLE_ENTER_EXIT~ drücken",COLOR_RED,BizInfo[bi][bIntX],BizInfo[bi][bIntY],BizInfo[bi][bIntZ],7,BizInfo[bi][bVW],1);
BizInfo[bi][bCreated]=true;
}
}
}
Warum klappt das nicht?
lg
Deagle
Jeffry:
Dann versuch es mal mit dem nativechecker. http://forum.sa-mp.com/showthread.php?t=249226
Vielleicht hast du die falschen Includes..
Nicht der Code, der danach.
/e: Warte mal wie bekloppt bin ich eigentlich?
Ich formatiere "q", aber führe "query" aus.....
Falsche Sektion?
Und ein paar Mehr Infos wären schon toll^^
Möglicherweise steht das mysql_connect in einer Schleife? Oder ist in mehreren Filterscripts geladen?
Irgendwo nachSQL"CREATE TABLE IF NOT EXISTS `Frak` (`ID` int(11) NOT NULL UNIQUE...
werden die sein. dort musst du nachschauen.
Mein mysql_connect:
public OnGameModeInit()
{
Connect_To_Database();
//... Das andere OnGameModeInit Zeug
return 1;
}
stock Connect_To_Database()
{
dbHandle = mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
if(mysql_errno() == 0) {
print("<-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!");
mysql_log(LOG_ALL);
return 1;
} else {
print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
print("<-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
dbHandle = mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
if(mysql_errno() == 0) {
print("<-| [MYSQL] Beim 2. Versuch konnte eine Verbindung zur Datenbank hergestellt werden!");
mysql_log(LOG_ALL);
return 1;
} else {
print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
print("<-| [MYSQL] Der Server wird nun heruntergefahren!");
SendRconCommand("exit");
return 0;
}
}
}
Ich sehe da keine Schleife..
Hier der Frak-Code:
format(q,sizeof q,"CREATE TABLE IF NOT EXISTS `Frak` (\
`ID` int(11) NOT NULL UNIQUE,\
`Kasse` int(11) NOT NULL,\
`Marihuana` int(11) NOT NULL,\
`Mats` int(11) NOT NULL,\
`Gangwaffen` int(11) NOT NULL,\
`Rank1lohn` int(11) NOT NULL,\
`Rank2lohn` int(11) NOT NULL,\
`Rank3lohn` int(11) NOT NULL,\
`Rank4lohn` int(11) NOT NULL,\
`Rank5lohn` int(11) NOT NULL,\
`Rank6lohn` int(11) NOT NULL,\
`Rank7lohn` int(11) NOT NULL,\
`Rank8lohn` int(11) NOT NULL,\
`LagerOpen` int(1) NOT NULL,");
strcat(query,q);
format(q,sizeof q,"`Rank1name` varchar(16) NOT NULL,\
`Rank2name` varchar(16) NOT NULL,\
`Rank3name` varchar(16) NOT NULL,\
`Rank4name` varchar(16) NOT NULL,\
`Rank5name` varchar(16) NOT NULL,\
`Rank6name` varchar(16) NOT NULL,\
`Rank7name` varchar(16) NOT NULL,\
`Rank8name` varchar(16) NOT NULL,\
`Rank1skin` int(3) NOT NULL,\
`Rank2skin` int(3) NOT NULL,\
`Rank3skin` int(3) NOT NULL,\
`Rank4skin` int(3) NOT NULL,\
`Rank5skin` int(3) NOT NULL,\
`Rank6skin` int(3) NOT NULL,");
strcat(query,q);
format(q,sizeof q,"`Rank7skin` int(3) NOT NULL,\
`Rank8skin` int(3) NOT NULL,\
`WLX` float NOT NULL,\
`WLY` float NOT NULL,\
`WLZ` float NOT NULL,\
`PosX` float NOT NULL,\
`PosY` float NOT NULL,\
`PosZ` float NOT NULL,\
`IntX` float NOT NULL,\
`IntY` float NOT NULL,\
`IntZ` float NOT NULL,\
`WLiX` float NOT NULL,\
`WLiY` float NOT NULL,\
`WLiZ` float NOT NULL,\
`Interior` int(11) NOT NULL,\
`VW` int(11) NOT NULL,");
strcat(query,q);
format(q,sizeof q,"`SpawnX` float NOT NULL,\
`SpawnY` float NOT NULL,\
`SpawnZ` float NOT NULL,\
`SpawnA` float NOT NULL,\
`Kokain` int(11) NOT NULL,\
`Carslots` int(11) NOT NULL);");
strcat(query,q);
mysql_pquery(dbHandle,query);
Das steht halt alles in einem Stock, damit alle Tabellen erstellt werden.
/edit: Kann es sein, dass der Server/das Mysql Plugin nicht damit klar kommt, dass die Querys so schnell hintereinander ausgeführt werden?
Hi,
ich habe meinen Gamemode von der MySQL R5 auf die R39-3 umgeschrieben.
Nun wenn ich den Server starte, und in die server_log.txt & die mysql_log.txt schaue sehe ich erschreckendes....
Hier mal die Logdateien:
----------Loaded log file: "server_log.txt".----------SA-MP Dedicated Server----------------------v0.3.7, (C)2005-2015 SA-MP Team[15:47:07] filterscripts = "" (string)[15:47:07] [15:47:07] Server Plugins[15:47:07] --------------[15:47:07] Loading plugin: mysql.so[15:47:07] >> plugin.mysql: R39-3 successfully loaded.[15:47:07] Loaded.[15:47:07] Loading plugin: sscanf.so[15:47:07] [15:47:07] ===============================[15:47:07] sscanf plugin loaded. [15:47:07] Version: 2.8.1 [15:47:07] (c) 2012 Alex "Y_Less" Cole [15:47:07] ===============================[15:47:07] Loaded.[15:47:07] Loading plugin: audio.so[15:47:07] *** Audio Plugin v0.5 R2 by Incognito loaded ***[15:47:07] Loaded.[15:47:07] Loading plugin: streamer.so[15:47:07] *** Streamer Plugin v2.7.7 by Incognito loaded ***[15:47:07] Loaded.[15:47:07] Loading plugin: crashdetect.so[15:47:07] Loaded.[15:47:07] Loading plugin: nativechecker.so[15:47:07] Loaded.[15:47:07] Loaded 6 plugins.[15:47:07] [15:47:07] Filterscripts[15:47:07] ---------------[15:47:07] Loaded 0 filterscripts.[15:47:07] [crashdetect]: gamemodes/script.amx does not contain debug information[15:47:07] *** Audio Plugin: Started TCP server on port 22804[15:47:07] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt![15:47:07] Setting server password to: "shanfjdshfjsdhfjkdshfsd"[15:47:07] [crashdetect]: filterscripts/Maps.amx does not contain debug information[15:47:07] [15:47:07] Alle Maps wurden erfolgreich geladen![15:47:07] [15:47:07] Filterscript 'Maps.amx' loaded.[15:47:07] Filterscript 'AudioHide.amx' load failed.[15:47:07] [15:47:07] SCRIPT - (c) by Zinne[15:47:07] [15:47:07] Number of vehicle models: 0[15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:11] [15:47:11] ::: MySQL Query Error :::[15:47:11] ErrorID: 1065[15:47:11] Error: Query was empty[15:47:11] Callback: [15:47:11] Query: [15:47:11] ConnectionHandle: 1[15:47:11] [15:47:17] Server password has been removed.
[15:47:07] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:47:07] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:47:07] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:47:07] [DEBUG] CMySQLConnection::Connect - connection was successful[15:47:07] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:47:07] [DEBUG] CMySQLConnection::Connect - connection was successful[15:47:07] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:47:07] [DEBUG] CMySQLConnection::Connect - connection was successful[15:47:07] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `haeuser`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `biz`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Frak`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Misc`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `jobinfo`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Jobcars`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Drugplants` WHERE `Harvested` = '0'", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "UPDATE `jobinfo` SET `EisenerzKG` = '0',`EisenerzSW` = '0', `Sta", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Cardealers`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM `Dealercars`", callback: "OnQueryFinish", format: "sd"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `accounts` (`ID` int(11) NOT NULL AUT", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Logins` (`Name` varchar(24) NOT NULL", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Logouts` (`Name` varchar(24) NOT NUL", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Punishments` (`Name` varchar(24) NOT", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Tickets` (`ID` int(11) NOT NULL AUTO", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `jobinfo` (`EisenerzKG` int(11) NOT N", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Jobcars` (`ID` int(11) NOT NULL AUTO", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Drugplants` (`ID` int(11) NOT NULL U", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `haeuser` (`ID` int(11) NOT NULL UNIQ", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Cardealers` (`ID` int(11) NOT NULL A", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Dealercars` (`ID` int(11) NOT NULL A", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Ordereddealercars` (`ID` int(11) NOT", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Dealerparks` (`ID` int(11) NOT NULL ", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Playercars` (`ID` int(11) NOT NULL A", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Frakcars` (`ID` int(11) NOT NULL AUT", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `biz` (`ID` int(11) NOT NULL,`PosX` f", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Misc` (`Spielerrekord` int(11) NOT N", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `Frak` (`ID` int(11) NOT NULL UNIQUE,", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] mysql_pquery - connection: 1, query: "", callback: "(null)", format: "(null)"[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 1.381 milliseconds[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 1.192 milliseconds[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.743 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_row_count - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_row_count - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_row_count - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 1.71 milliseconds[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 1.72 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.735 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.720 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.749 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.743 milliseconds[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.652 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.653 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.670 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 1.442 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.923 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.600 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.707 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.689 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.724 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_data - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.584 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] cache_get_row_count - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_data - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_data - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] cache_get_data - connection: 1[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] Calling callback "OnQueryFinish"..[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.516 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] cache_get_data - connection: 1[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.561 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.624 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.587 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.607 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.593 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.712 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.753 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.479 milliseconds[15:47:11] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:47:11] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty[15:47:11] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:47:11] [DEBUG] Calling callback "OnQueryError"..[15:47:11] [DEBUG] Calling callback "OnQueryError"..[15:47:11] [DEBUG] Calling callback "OnQueryError"..[15:47:11] [DEBUG] Calling callback "OnQueryError"..[15:47:11] [DEBUG] Calling callback "OnQueryError"..[15:47:11] [DEBUG] Calling callback "OnQueryError"..
Nun lauten meine Hauptfragen:
Warum sagt die mysql_log, dass ich 3x eine Verbindung zur DB aufbaue?
Wie kann ich herausfinden, welche Querys leer (empty) sind?
lg
Deagle
Ja - aber nur das Feld KleinBurger
Genau die Info die ich brauchte, danke 
Hi, ich habe eine kleine Logikfrage zu der MySQL R39-3:
Wenn ich folgenden Query ausführen lasse:
mysql_format(dbHandle, q,sizeof q,"SELECT `KleinBurger` FROM `BSprices` WHERE `BizID` = '%d'",bid);
Und dann aus einer Row via "cache_get_field_content" auslesen lassen möchte, kann ich dann nur die Rows auslesen, wo "BizID" = bid ist?
Jeffry: :3