die werden mit taste e un q und für den warn blinke beide gedrückt halten
Beiträge von luiluiboy014
-
-
Hey Leute Brauche eure hilfe mit dem blinker system das porblem ist es geht nicht an aber in intro geht der an wo rann kann das liegen hier das system
Code
Alles anzeigennew Indicators_xqz[MAX_VEHICLES][6]; stock SetVehicleIndicator(vehicleid, leftindicator=0, rightindicator=0) { if(!leftindicator & !rightindicator) return false; new Float:_vX[2], Float:_vY[2], Float:_vZ[2]; if(rightindicator) { if(IsTrailerAttachedToVehicle(vehicleid)) { new omg = GetVehicleModel(GetVehicleTrailer(vehicleid)); GetVehicleModelInfo(omg, VEHICLE_MODEL_INFO_SIZE, _vX[0], _vY[0], _vZ[0]); Indicators_xqz[vehicleid][4] = CreateObject(19294, 0, 0, 0,0,0,0); AttachObjectToVehicle(Indicators_xqz[vehicleid][4], GetVehicleTrailer(vehicleid), _vX[0]/2.4, -_vY[0]/3.35, -1.0 ,0,0,0); } GetVehicleModelInfo(GetVehicleModel(vehicleid), VEHICLE_MODEL_INFO_SIZE, _vX[0], _vY[0], _vZ[0]); Indicators_xqz[vehicleid][0] = CreateObject(19294, 0, 0, 0,0,0,0); AttachObjectToVehicle(Indicators_xqz[vehicleid][0], vehicleid, _vX[0]/2.23, _vY[0]/2.23, 0.1 ,0,0,0); Indicators_xqz[vehicleid][1] = CreateObject(19294, 0, 0, 0,0,0,0); AttachObjectToVehicle(Indicators_xqz[vehicleid][1], vehicleid, _vX[0]/2.23, -_vY[0]/2.23, 0.1 ,0,0,0); } if(leftindicator) { if(IsTrailerAttachedToVehicle(vehicleid)) { new omg = GetVehicleModel(GetVehicleTrailer(vehicleid)); GetVehicleModelInfo(omg, VEHICLE_MODEL_INFO_SIZE, _vX[0], _vY[0], _vZ[0]); Indicators_xqz[vehicleid][5] = CreateObject(19294, 0, 0, 0,0,0,0); AttachObjectToVehicle(Indicators_xqz[vehicleid][5], GetVehicleTrailer(vehicleid), -_vX[0]/2.4, -_vY[0]/3.35, -1.0 ,0,0,0); } GetVehicleModelInfo(GetVehicleModel(vehicleid), VEHICLE_MODEL_INFO_SIZE, _vX[0], _vY[0], _vZ[0]); Indicators_xqz[vehicleid][2] = CreateObject(19294, 0, 0, 0,0,0,0); AttachObjectToVehicle(Indicators_xqz[vehicleid][2], vehicleid, -_vX[0]/2.23, _vY[0]/2.23, 0.1 ,0,0,0); Indicators_xqz[vehicleid][3] = CreateObject(19294, 0, 0, 0,0,0,0); AttachObjectToVehicle(Indicators_xqz[vehicleid][3], vehicleid, -_vX[0]/2.23, -_vY[0]/2.23, 0.1 ,0,0,0); } return 1; } public OnPlayerKeyStateChange(playerid,newkeys, oldkeys) { if(IsPlayerInAnyVehicle(playerid) && GetPlayerState(playerid) == 2) { if(!IsAPlane(GetPlayerVehicleID(playerid)) && !IsABoat(GetPlayerVehicleID(playerid))) { new vid = GetPlayerVehicleID(playerid); if(newkeys & ( KEY_LOOK_LEFT ) && newkeys & ( KEY_LOOK_RIGHT )) { if(Indicators_xqz[vid][2] /*|| Indicators_xqz[vid][5]*/) DestroyObject(Indicators_xqz[vid][5]),DestroyObject(Indicators_xqz[vid][2]), DestroyObject(Indicators_xqz[vid][3]),Indicators_xqz[vid][2]=0; else if(Indicators_xqz[vid][0] /*|| Indicators_xqz[vid][4]*/) DestroyObject(Indicators_xqz[vid][4]),DestroyObject(Indicators_xqz[vid][0]), DestroyObject(Indicators_xqz[vid][1]),Indicators_xqz[vid][0]=0; else SetVehicleIndicator(vid,1,1); return 1; } if(newkeys & KEY_LOOK_RIGHT) { if(Indicators_xqz[vid][0] /*|| Indicators_xqz[vid][4]*/) DestroyObject(Indicators_xqz[vid][4]), DestroyObject(Indicators_xqz[vid][0]), DestroyObject(Indicators_xqz[vid][1]),Indicators_xqz[vid][0]=0; else if(Indicators_xqz[vid][2]/*|| Indicators_xqz[vid][5]*/) DestroyObject(Indicators_xqz[vid][5]), DestroyObject(Indicators_xqz[vid][2]), DestroyObject(Indicators_xqz[vid][3]),Indicators_xqz[vid][2]=0; else SetVehicleIndicator(vid,0,1); } if(newkeys & KEY_LOOK_LEFT) { if(Indicators_xqz[vid][2]/*|| Indicators_xqz[vid][5]*/) DestroyObject(Indicators_xqz[vid][5]),DestroyObject(Indicators_xqz[vid][2]), DestroyObject(Indicators_xqz[vid][3]),Indicators_xqz[vid][2]=0; else if(Indicators_xqz[vid][0] /*|| Indicators_xqz[vid][4]*/) DestroyObject(Indicators_xqz[vid][4]),DestroyObject(Indicators_xqz[vid][0]), DestroyObject(Indicators_xqz[vid][1]),Indicators_xqz[vid][0]=0; else SetVehicleIndicator(vid,1,0); } } } return 1; } public OnVehicleDeath(vehicleid) { if(Indicators_xqz[vehicleid][2]) DestroyObject(Indicators_xqz[vehicleid][2]), DestroyObject(Indicators_xqz[vehicleid][3]),DestroyObject(Indicators_xqz[vehicleid][5]),Indicators_xqz[vehicleid][2]=0; if(Indicators_xqz[vehicleid][0]) DestroyObject(Indicators_xqz[vehicleid][0]), DestroyObject(Indicators_xqz[vehicleid][1]),DestroyObject(Indicators_xqz[vehicleid][4]),Indicators_xqz[vehicleid][0]=0; return 1; } stock IsAPlane(carid2) { new carid = GetVehicleModel(carid2); if(carid == 592 || carid == 577 || carid == 511 || carid == 512 || carid == 593 || carid == 520 || carid == 553 || carid == 476 || carid == 519 || carid == 460 || carid == 513) return 1; return 0; } stock IsABoat(carid) { new modelid = GetVehicleModel(carid); if(modelid == 430 || modelid == 446 || modelid == 452 || modelid == 453 || modelid == 454 || modelid == 472 || modelid == 473 || modelid == 484 || modelid == 493 || modelid == 595) { return 1; } return 0; } public OnPlayerKeyStateChange(playerid,newkeys, oldkeys) { if(IsPlayerInAnyVehicle(playerid) && GetPlayerState(playerid) == 2) { if(!IsAPlane(GetPlayerVehicleID(playerid)) && !IsABoat(GetPlayerVehicleID(playerid))) { new vid = GetPlayerVehicleID(playerid); if(newkeys & ( KEY_LOOK_LEFT ) && newkeys & ( KEY_LOOK_RIGHT )) { if(Indicators_xqz[vid][2] /*|| Indicators_xqz[vid][5]*/) DestroyObject(Indicators_xqz[vid][5]),DestroyObject(Indicators_xqz[vid][2]), DestroyObject(Indicators_xqz[vid][3]),Indicators_xqz[vid][2]=0; else if(Indicators_xqz[vid][0] /*|| Indicators_xqz[vid][4]*/) DestroyObject(Indicators_xqz[vid][4]),DestroyObject(Indicators_xqz[vid][0]), DestroyObject(Indicators_xqz[vid][1]),Indicators_xqz[vid][0]=0; else SetVehicleIndicator(vid,1,1); return 1; } if(newkeys & KEY_LOOK_RIGHT) { if(Indicators_xqz[vid][0] /*|| Indicators_xqz[vid][4]*/) DestroyObject(Indicators_xqz[vid][4]), DestroyObject(Indicators_xqz[vid][0]), DestroyObject(Indicators_xqz[vid][1]),Indicators_xqz[vid][0]=0; else if(Indicators_xqz[vid][2]/*|| Indicators_xqz[vid][5]*/) DestroyObject(Indicators_xqz[vid][5]), DestroyObject(Indicators_xqz[vid][2]), DestroyObject(Indicators_xqz[vid][3]),Indicators_xqz[vid][2]=0; else SetVehicleIndicator(vid,0,1); } if(newkeys & KEY_LOOK_LEFT) { if(Indicators_xqz[vid][2]/*|| Indicators_xqz[vid][5]*/) DestroyObject(Indicators_xqz[vid][5]),DestroyObject(Indicators_xqz[vid][2]), DestroyObject(Indicators_xqz[vid][3]),Indicators_xqz[vid][2]=0; else if(Indicators_xqz[vid][0] /*|| Indicators_xqz[vid][4]*/) DestroyObject(Indicators_xqz[vid][4]),DestroyObject(Indicators_xqz[vid][0]), DestroyObject(Indicators_xqz[vid][1]),Indicators_xqz[vid][0]=0; else SetVehicleIndicator(vid,1,0); } } } return 1; }
Ich hoffe ihr könnt mir helfen
-
Hat sich erledigt habe den fehler gefunden Danke
-
Hey leute ich hoffe ihr habt eine id das problem ist wenn ich aduty gehen kann mann mich auf der karte icht sehen ich weiß nicht wo der fehler liegt ich hoffe ihr könnt mir helfen MfG luiluiboy014
Code
Alles anzeigenCOMMAND:aduty(playerid,params[]) { if(ImTutorial[playerid] != 0)return SendClientMessage(playerid,GRAU,"Du kannst keine Befehle nutzen,da du im Tutorial bist."); if(GetPVarInt(playerid,"Eingeloggt") == 0)return SendClientMessage(playerid,GRAU,"Du bist nicht eingeloggt!"); if(Spieler[playerid][pAWAYFROMKEYBOARD] == 1)return SendClientMessage(playerid,WRONGCMD,"Du bist im AFK-Modus und kannst somit keine Befehle nutzen."),SendClientMessage(playerid,WRONGCMD,"BENUTZE: /back"); new string[128]; if(!isPlayerAnAdmin(playerid,1))return SendClientMessage(playerid,GRAU,"Du bist kein "#SERVERTAG" Teammitglied./Du hast nicht den jeweiligen Adminrang."); if(Spieler[playerid][pAdminOnduty] == false) { format(string,24,"["#SERVERTAG"]%s",Spieler[playerid][pName]); SetPlayerName(playerid,string); SetPlayerScore(playerid,GetPlayerLevel(playerid)); SendClientMessage(playerid,LEUCHTENDESROT,"** Du bist nun im Admindienst **"); TextDrawShowForPlayer(playerid,ADUTYdraw); Spieler[playerid][pAdminOnduty] = true; switch(Spieler[playerid][pAdmin]) { case 1:{aDuty[playerid] = Create3DTextLabel("Supporter",0x7DFF00C7,30.0,40.0,50.0,MAX_STREAM_NAME_DISTANCE,GetPlayerVirtualWorld(playerid),1);SetPlayerColor(playerid,0x7DFF00C7);} case 2:{aDuty[playerid] = Create3DTextLabel("Moderator",0x00FFFFD3,30.0,40.0,50.0,MAX_STREAM_NAME_DISTANCE,GetPlayerVirtualWorld(playerid),1);SetPlayerColor(playerid,0x00FFFFD3);} case 3:{aDuty[playerid] = Create3DTextLabel("Administrator",0x00AFFFEE,30.0,40.0,50.0,MAX_STREAM_NAME_DISTANCE,GetPlayerVirtualWorld(playerid),1);SetPlayerColor(playerid,0x00AFFFEE);} case 4:{aDuty[playerid] = Create3DTextLabel("Techniker",0xFF00F5D9,30.0,40.0,50.0,MAX_STREAM_NAME_DISTANCE,GetPlayerVirtualWorld(playerid),1);SetPlayerColor(playerid,0xFF00F5D9);} case 5:{aDuty[playerid] = Create3DTextLabel("Super Administrator",0xFF9600FF,30.0,40.0,50.0,MAX_STREAM_NAME_DISTANCE,GetPlayerVirtualWorld(playerid),1);SetPlayerColor(playerid,0xFF9600FF);} case 6:{aDuty[playerid] = Create3DTextLabel("Server Manager",0xFF4600D8,30.0,40.0,50.0,MAX_STREAM_NAME_DISTANCE,GetPlayerVirtualWorld(playerid),1);SetPlayerColor(playerid,0xFF4600D8);} case 7:{aDuty[playerid] = Create3DTextLabel("Serverleitung",0xD60A00CF,30.0,40.0,50.0,MAX_STREAM_NAME_DISTANCE,GetPlayerVirtualWorld(playerid),1);SetPlayerColor(playerid,0xD60A00CF);for(new i; i < MAX_PLAYERS; i++) SetPlayerMarkerForPlayer(playerid, i, 0xD60A00CF);} } Attach3DTextLabelToPlayer(aDuty[playerid],playerid,0.0,0.0,0.6); } else if(Spieler[playerid][pAdminOnduty] == true) { SendClientMessage(playerid,LEUCHTENDESROT,"** Du bist nun nicht mehr im Admindienst **"); TextDrawHideForPlayer(playerid,ADUTYdraw); Delete3DTextLabel(aDuty[playerid]); ShowPlayerMarkers(0); SetPlayerMarkerForPlayer( playerid, 0, 0xFFFFFF00 ); SetPlayerColor(playerid, WEISS); Spieler[playerid][pAdminOnduty] = false; SetPlayerName(playerid,Spieler[playerid][pName]); SetPlayerScore(playerid,GetPlayerLevel(playerid)); if(Spieler[playerid][pMaske] == 1 && Spieler[playerid][pFraktion] != 6) { SetPlayerScore(playerid,random(50) + 122); format(string,sizeof(string),"UNKNOWN%i",random(50) + 122); SetPlayerName(playerid,string); } if(Spieler[playerid][pDuty] == 4 && Spieler[playerid][pFraktion] != 6) { SetPlayerScore(playerid,random(50) + 122); format(string,24,"SWAT%i",random(50) + 122); SetPlayerName(playerid,string); } if(Spieler[playerid][pDuty] == 4 && Spieler[playerid][pFraktion] == 6 && Spieler[playerid][pMaske] == 1) { SetPlayerScore(playerid,random(50) + 122); format(string,24,"SEAL%i",random(50) + 122); SetPlayerName(playerid,string); } if(Spieler[playerid][pDuty] == 5 && Spieler[playerid][pFraktion] == 6 && Spieler[playerid][pMaske] == 1) { SetPlayerScore(playerid,random(50) + 122); format(string,24,"RANGER%i",random(50) + 122); SetPlayerName(playerid,string); } } return 1; }
-
geht das nenn nicht das es crasht
-
genau und das ist das problem
-
-
Hey Leute habe ein Kleines Problem Wie bekomme ich den text auf die Linie Weiß nicht wie ich das hin bekommen kann da ener heflen bitte
Code
Alles anzeigenIntrodraw[4] = TextDrawCreate(200,100,"."); TextDrawFont(Introdraw[4],1); TextDrawBackgroundColor(Introdraw[4], 255); TextDrawLetterSize(Introdraw[4],26.940078, 4.000000); TextDrawColor(Introdraw[4],-1); TextDrawSetOutline(Introdraw[4],1); TextDrawSetProportional(Introdraw[4],1); Introdraw[5] = TextDrawCreate(230,130,""#SERVERVERSION""); TextDrawFont(Introdraw[5],2); TextDrawColor(Introdraw[5],SERVERFARBEHEX); TextDrawAlignment(Introdraw[5],0); TextDrawLetterSize(Introdraw[5],0.250000,0.899990); TextDrawSetOutline(Introdraw[5],1); TextDrawSetProportional(Introdraw[5],1); TextDrawSetShadow(Introdraw[5],1);
-
jo alles klar dank dir
-
hey hich habe den mysql debung angeworfen sind jetzt nicht mehr viele sind sogar noch wenniger geworden
Code
Alles anzeigen[21:54:46] [WARNING] CMySQLConnection::Disconnect - no connection available [21:58:34] [WARNING] CMySQLConnection::Disconnect - no connection available [22:00:09] [WARNING] CMySQLConnection::Disconnect - no connection available [22:00:21] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "planet", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [22:00:21] [DEBUG] CMySQLHandle::Create - creating new connection.. [22:00:21] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [22:00:21] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [22:00:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [22:00:21] [DEBUG] CMySQLConnection::Connect - connection was successful [22:00:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [22:00:21] [DEBUG] mysql_errno - connection: 1 [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE pRP_stuff SET WLS='16',WSF='16',WLV='2'", callback: "(null)", format: "(null)" [22:00:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [22:00:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [22:00:21] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [22:00:21] [DEBUG] CMySQLConnection::Connect - connection was successful [22:00:21] [DEBUG] CMySQLConnection::Connect - connection was successful [22:00:21] [DEBUG] CMySQLConnection::Connect - connection was successful [22:00:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [22:00:21] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [22:00:21] [DEBUG] CMySQLQuery::Execute[] - starting query execution [22:00:21] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.186 milliseconds [22:00:21] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='0'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='1'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='2'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.353 milliseconds [22:00:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='3'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='4'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='5'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 1.38 milliseconds [22:00:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='6'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='7'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='8'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.221 milliseconds [22:00:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='9'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='10'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='11'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.331 milliseconds [22:00:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='12'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar WHERE GangZoneID='13'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gangwar", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.279 milliseconds [22:00:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called pRP_blitzer", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_minen", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_xmasobjects", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.265 milliseconds [22:00:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called pRP_drugs", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_networktowers", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='0'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.193 milliseconds [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='1'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='2'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='3'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.258 milliseconds [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='4'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='5'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='6'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.263 milliseconds [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='7'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='8'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='9'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.276 milliseconds [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='10'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='11'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='12'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.242 milliseconds [22:00:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called pRP_advertismentboards WHERE id='13'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='14'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='15'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.226 milliseconds [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='16'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='17'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='18'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.198 milliseconds [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='19'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='20'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards WHERE id='21'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.269 milliseconds [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_vehicles", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_advertismentboards", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_races", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.609 milliseconds [22:00:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called pRP_blackmarket", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_stuff", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_stuff", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.213 milliseconds [22:00:21] [DEBUG] CMySQLResult::CMySQLResult() - constructor called pRP_fraktion_verwaltung WHERE fID = '0'", callback: "OnQueryFinish", format: "siii" [22:00:21] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:21] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '1'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '2'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.160 milliseconds [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '3'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '4'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '5'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.258 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '6'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '7'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '8'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.175 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '9'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution _verwaltung WHERE fID = '10'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '11'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.236 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '12'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution _verwaltung WHERE fID = '13'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '14'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.247 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '15'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '16'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '17'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.219 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung WHERE fID = '18'", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_fraktion_verwaltung", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_properties", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.373 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_gutscheine", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_businesses", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_organisations", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.250 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_firmen", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM pRP_partei", callback: "OnQueryFinish", format: "siii" [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.219 milliseconds [22:00:22] [DEBUG] Calling callback "OnQueryFinish".. [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] mysql_errno - connection: 1 [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:22] [DEBUG] cache_get_data - connection: 1 [22:00:22] [DEBUG] cache_get_data - connection: 1 [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.307 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:22] [DEBUG] Calling callback "OnQueryFinish".. [22:00:22] [DEBUG] mysql_errno - connection: 1 [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.223 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] cache_get_data - connection: 1 [22:00:22] [DEBUG] cache_get_data - connection: 1 sh] - starting query execution [22:00:22] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.277 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] Calling callback "OnQueryFinish".. [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:22] [DEBUG] cache_get_data - connection: 1 [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.400 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] cache_get_data - connection: 1 [22:00:22] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called xecution [22:00:22] [DEBUG] Calling callback "OnQueryFinish".. [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.266 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] mysql_errno - connection: 1 [22:00:22] [DEBUG] cache_get_data - connection: 1 [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:22] [DEBUG] cache_get_data - connection: 1 [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.280 milliseconds [22:00:22] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:22] [DEBUG] Calling callback "OnQueryFinish".. [22:00:22] [DEBUG] mysql_errno - connection: 1 [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.252 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] cache_get_data - connection: 1 [22:00:22] [DEBUG] cache_get_data - connection: 1 sh] - starting query execution [22:00:22] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.479 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] Calling callback "OnQueryFinish".. [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:22] [DEBUG] mysql_errno - connection: 1 [22:00:22] [DEBUG] cache_get_data - connection: 1 [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.253 milliseconds [22:00:22] [DEBUG] cache_get_data - connection: 1 [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:22] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [22:00:22] [DEBUG] Calling callback "OnQueryFinish".. [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.248 milliseconds [22:00:22] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [22:00:22] [DEBUG] mysql_errno - connection: 1 [22:00:22] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [22:00:22] [DEBUG] cache_get_data - connection: 1 [22:00:23] [DEBUG] cache_get_data - connection: 1 [22:00:23] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.334 milliseconds
wenn ich den aus mache kommt nur das mit der mysql verbinung
-
jetzt kommt das
[21:54:46] [WARNING] CMySQLConnection::Disconnect - no connection available
das keine verbindung besteht
-
beim restarten wird die verbindung nicht getrent vermute ich mall
-
beim server restart kommt der noch mall
-
Supi da war der fehler jetzt kommt nur noch der hier
[21:38:03] [WARNING] CMySQLHandle::Create - connection already exists
der ist ja aber unwichtig Danke
-
das passiert wenn er in die fraktion geht
beim login
weiß aber nicht genau wo ich suchen soll in der fraktion welchen code
Vermute das es das hier ist
Codecase _SQL_FRAKTIONSMOTD_SELECT: { new msg[128]; cache_get_data(rows,fields); cache_get_field_content(0,"Text",msg); format(result,sizeof(result),""#SERVERFARBE""#SERVERNAME"{FFFFFF}:%s",FraktionsName(Spieler[extraid][pFraktion])); format(query,sizeof(query),"Herzlich Willkommen auf "#SERVERNAME",\nbitte denke immer daran dich an die Regeln zu halten.\nBugs/Fehler im Spiel bitte im Forum melden.\n\nFraktionsspawnnachricht:\n%s\n\nViel Spaß beim spielen!",msg); ShowPlayerDialog(extraid,DIALOG_4ALL_SONSTIGES,DIALOG_STYLE_MSGBOX,result,query,"Verlassen",""); return 1; }
oder das hier
Codeif(!isPlayerInFrakt(playerid,0)) { format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_fraktion_motd WHERE fID='%d'",Spieler[playerid][pFraktion]); mysql_function_query(MySqlConnection,stringlogin,true,"OnQueryFinish","siii",stringlogin,_SQL_FRAKTIONSMOTD_SELECT,playerid,MySqlConnection); }
es liegt auf jeden Fall an der Fraktion
ich hoffe jeffry du kanst mir helfen
weil wenn ich in die fraktion gehe ist der fehler sofort da -
-
stock OnlinePlayer(playerid,bool:player)
{
new query[250];
if(player == true)
{
format(query,sizeof(query),"INSERT INTO onlines (ID, Name) VALUES ('%d','%s')",playerid,Spieler[playerid][pName]);
mysql_function_query(MySqlConnection,query,false,"","");
}
else if(player == false)
{
format(query,sizeof(query),"DELETE FROM onlines WHERE ID = '%d'",playerid);
mysql_function_query(MySqlConnection,query,false,"","");
}
return 1;
} -
das ist alles Was ich an login habe
Code
Alles anzeigenpublic ShowLoginOrRegisterDialog(playerid) { new query[128]; TextDrawHideForPlayer(playerid,Introdraw[2]); TextDrawHideForPlayer(playerid,Introdraw[3]); TextDrawHideForPlayer(playerid,Introdraw[4]); TextDrawHideForPlayer(playerid,Introdraw[5]); SpamChat(playerid,0);// 0 = nur für einen spieler wird der chat kontrolliert 100 zeilen voll gespamt,bei 1 = für alle spieler format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,query,true,"OnQueryFinish","siii",query,_SQL_ACCOUNT_CHECK,playerid,MySqlConnection); return 1; }
Codestock AddToAutoLogin(playerid) { new query[128]; format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_autologin WHERE Name='%s' AND IP='%s'",SpielerName(playerid),SpielerIP(playerid)); mysql_function_query(MySqlConnection,query,true,"OnQueryFinish","siii",query,_SQL_ADDTOAUTOLOGIN,playerid,MySqlConnection); return 1; }
Codecase _SQL_ADDTOAUTOLOGIN: { cache_get_data(rows,fields); if(!rows) { format(query,sizeof(query),"INSERT INTO "#DATENBANKTAG"_account_autologin (`Name`,`IP`) VALUES ('%s','%s')",SpielerName(extraid),SpielerIP(extraid)); mysql_function_query(MySqlConnection,query,false,"",""); } return 1; }
Code
Alles anzeigencase _SQL_ACCOUNT_AUTOLOGIN: { cache_get_data(rows,fields); if(rows) { new oi = CheckPlayerOfflineInfo(extraid); if(oi != -1) { new time = OfflineInfo[oi][Odeletetime] - gettime(); format(query,sizeof(query),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\nDu kannst dich erst in %i:%02d Minuten wieder einloggen.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(extraid),time/60,time%60); ShowPlayerDialog(extraid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",query,"Login","Abbrechen"); return 1; } SendClientMessage(extraid,WEISS,"{A91400}SERVER{FFFFFF}: Da du dich heute schon einmal mit der gleichen IP eingeloggt hast, wurdest du automatisch eingeloggt."); format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name='%s'",SpielerName(extraid)); mysql_function_query(MySqlConnection,query,true,"LoadAccount","isi",extraid," ",0); } else { SendClientMessage(extraid,GRUEN,"|____ Willkommen auf "#SERVERNAME" ____|"); SendClientMessage(extraid,WEISS,"Dein Name ist bei uns registriert, bitte logge dich ein!"); format(query,sizeof(query),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(extraid)); ShowPlayerDialog(extraid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",query,"Login","Abbrechen"); format(query,sizeof(query),"DELETE FROM "#DATENBANKTAG"_account_autologin WHERE Name = '%s' OR IP = '%s'",SpielerName(extraid),SpielerIP(extraid)); mysql_function_query(MySqlConnection,query,false,"",""); } return 1; }
Code
Alles anzeigencase _SQL_ACCOUNT_CHECK: { cache_get_data(rows,fields); if(rows) { if(login == true) { SendClientMessage(extraid,BLAU,"Das Einloggen wurde von einem Admin deaktiviert."); SendClientMessage(extraid,BLAU,"Versuch es später erneut..."); KickUser(extraid, "System", "Einloggen deaktiviert - Kick"); } format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_autologin WHERE Name='%s' AND IP='%s'",SpielerName(extraid),SpielerIP(extraid)); mysql_function_query(MySqlConnection,query,true,"OnQueryFinish","siii",query,_SQL_ACCOUNT_AUTOLOGIN,extraid,MySqlConnection); } else { if(registration == true) { SendClientMessage(extraid,BLAU,"Die Registration wurde von einem Admin ausgeschaltet."); SendClientMessage(extraid,BLAU,"Versuch es später erneut..."); KickUser(extraid, "System", "Registration deakviert - Kick"); } if(GetRegisteredCount() > MAX_REGISTEREDINSAMETIME) { SendClientMessage(extraid,BLAU,"Verbindung nicht möglich da momentan "#MAX_REGISTEREDINSAMETIME" in der Registrierung sind!"); SendClientMessage(extraid,BLAU,"Versuch es später erneut..."); KickUser(extraid, "System", "Maximale Registrationen - Kick"); } SendClientMessage(extraid,0x00489184,"|____ Willkommen auf "#SERVERNAME" ____|"); SendClientMessage(extraid,WEISS,"Dein Name wurde nicht gefunden,bitte registriere dich!"); ShowPlayerDialog(extraid,DIALOG_REGISTER3,DIALOG_STYLE_MSGBOX,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Willkommen","{C9C9C9}Willkommen auf dem Roleplay Server der "#SERVERFARBE""#SERVERNAME"{C9C9C9} Community.\nDein Account wurde nicht gefunden !\nBitte registriere dich.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}","Registrieren","Verlassen"); } return 1; }
Code
Alles anzeigencase DIALOG_LOGIN: { new stringlogin[256],oi = CheckPlayerOfflineInfo(playerid); if(response == 0)return Kick(playerid); else { StopAudioStreamForPlayer(playerid); PlayAudioStreamForPlayer(playerid,ServerSounds[3],0.0,0.0,0.0); if(oi != -1) { new time = OfflineInfo[oi][Odeletetime] - gettime(); format(stringlogin,sizeof(stringlogin),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\nDu kannst dich erst in %i:%02d Minuten wieder einloggen.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(playerid),time/60,time%60); ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",stringlogin,"Login","Abbrechen"); return 1; } if(!strlen(inputtext)) { format(stringlogin,sizeof(stringlogin),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(playerid)); ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",stringlogin,"Login","Abbrechen"); return 1; } format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccount","isi",playerid,inputtext,1); } return 1; }
-
fragt sich wo der code jetzt ist den der abragen tut hier habe ich nur den mysql_connect schonn mall
Code
Alles anzeigenMySqlConnection = mysql_connect(SQL_HOST,SQL_USER,SQL_DATA,SQL_PASS,3306,true); if(mysql_errno(MySqlConnection) == 0) { print("SERVER: Verbindung zur Datenbank wurde erfolgreich hergestellt."); printf("Host: %s,User: %s,Datanbank: %s,Passwort: %s",SQL_HOST,SQL_USER,SQL_DATA,SQL_PASS); } else { print("SERVER: Es konnte keine Verbindung zur Datenbank hergestellt werden!"); print(" Es wird erneut versucht eine Verbindung zur Datenbank herzustellen."); printf("Host: %s,User: %s,Datanbank: %s,Passwort: %s",SQL_HOST,SQL_USER,SQL_DATA,SQL_PASS); MySqlConnection = mysql_connect(SQL_HOST,SQL_USER,SQL_DATA,SQL_PASS); if(mysql_errno(MySqlConnection) == 0) { print("SERVER: Es konnte im 2 Versuch eine Verbindung hergestellt werden!"); printf("Host: %s,User: %s,Datanbank: %s,Passwort: %s",SQL_HOST,SQL_USER,SQL_DATA,SQL_PASS); } else { print("SERVER: Es konnte keine Verbindung zur Datenbank hergestellt werden!"); print(" Server wird heruntergefahren ..."); SendRconCommand("exit"); return 1; } }
den anderen code muss ich suchen
Jetzt kommt die meldung
Code[16:13:43] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '13' for key 'PRIMARY' [16:13:43] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') [16:14:19] [WARNING] CMySQLHandle::Create - connection already exists [16:14:37] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
ich glaube das der fehler hier drine steckt
Code
Alles anzeigenpublic LoadAccount(playerid,pass[],passwortstate) { new query[356],result[25],rows,fields; if(mysql_errno(MySqlConnection) != 0) { getdate(tag,monat,jahr); gettime(stunde,minute,sekunde); ForEachPlayer(i) { if(IsPlayerConnected(i) && !IsPlayerNPC(i) && GetPVarInt(i,"Eingeloggt") == 1) { SaveAccount(i); } } Log("Restartssqllog","Admin: System hat den Server gerestartet(Dead MySql Connection)!"); OnGameModeSave(); GameModeExit(); return 1; } cache_get_data(rows,fields); if(rows) { if(passwortstate == 1) { cache_get_field_content(0,"Passwort",result); new tmpp[25]; strmid(tmpp, MD5_Hash(pass), 0, 24, 25); if(!strcmp(/*MD5_Hash(pass)*/tmpp,result,true)) { format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name='%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,query,true,"LoadAccount","isi",playerid," ",0); return 1; } format(query,sizeof(query),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(playerid)); ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",query,"Login","Abbrechen"); return 1; } cache_get_field_content(0,"Tutorial",result); Spieler[playerid][pViewTutorial] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Admin",result); Spieler[playerid][pAdmin] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Verwarnungen",result); Spieler[playerid][pWarns] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FLeaderRechte",result); Spieler[playerid][pLeader] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Fraktion",result); Spieler[playerid][pFraktion] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FraktionsRang",result); Spieler[playerid][pFraktRang] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FraktionsURang",result); Spieler[playerid][pFraktURang] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FraktionsSperre",result); Spieler[playerid][pFraktionSperre] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FraktionsGehalt",result); Spieler[playerid][pFraktionsGehalt] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Job",result); Spieler[playerid][pJob] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"JobWarns",result); Spieler[playerid][JobWarns] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"JobSperre",result); Spieler[playerid][pJobSperre] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"ArbeitslosenGeld",result); Spieler[playerid][pWorkLess] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Geschlecht",result); Spieler[playerid][pSex] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"SpielerAlter",result); Spieler[playerid][pYearsOld] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Level",result); SetPlayerLevel(playerid,strval(result)); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Geld",result); ACMoney(playerid,strval(result)); strdel(result,0,sizeof(result)); cache_get_field_content(0,"GWD",result); Spieler[playerid][pGrundwehrdienst] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Zivinote",result); Spieler[playerid][pZiviNote] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FAbteilung",result); Spieler[playerid][pFraktABTInvite] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Bankguthaben",result); Spieler[playerid][pBank] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"BankPin",result); Spieler[playerid][pBankPin] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"WantedSterne",result); SetPlayerWantedLevel(playerid,strval(result)); strdel(result,0,sizeof(result)); cache_get_field_content(0,"WantedPunkte",result); Spieler[playerid][pWantedPoints] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Suspects",result); Spieler[playerid][pSuspectPoints] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Wanted_Grund1",result); strmid(pWantedReason1[playerid],result,0,strlen(result),64); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Wanted_Grund2",result); strmid(pWantedReason2[playerid],result,0,strlen(result),64); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Wanted_Grund3",result); strmid(pWantedReason3[playerid],result,0,strlen(result),64); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Wanted_Grund4",result); strmid(pWantedReason4[playerid],result,0,strlen(result),64); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Wanted_Grund5",result); strmid(pWantedReason5[playerid],result,0,strlen(result),64); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Crimes",result); Spieler[playerid][pLastSuspects] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"STVOcrimes",result); Spieler[playerid][pSTVOpoints] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"KampfStyle",result); SetPlayerFightingStyle(playerid,strval(result)); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Handy",result); Spieler[playerid][pHandy] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Handycoins",result); Spieler[playerid][pHandyCoins] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"HandyStatus",result); Spieler[playerid][pHandystate] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"HandyAkku",result); Spieler[playerid][pHandyakku] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"HandyNummer",result); Spieler[playerid][pPhonenumber] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Handyflat",result); Spieler[playerid][pHandyFlat] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Handyflatbuyinbiz",result); Spieler[playerid][pHandyBuyByBiz] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Letzte_X",result); Spieler[playerid][LastInGamePos_x] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Letzte_Y",result); Spieler[playerid][LastInGamePos_y] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Letzte_Z",result); Spieler[playerid][LastInGamePos_z] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Letzte_Interior",result); Spieler[playerid][LastInGamePos_int] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Letzte_VirtualWorld",result); Spieler[playerid][LastInGamePos_world] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pSelectHome",result); Spieler[playerid][pSelectHome] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"HausMieter",result); Spieler[playerid][pRentHome] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Spawn",result); Spieler[playerid][pSpawn] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Hotel",result); Spieler[playerid][pHotel] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tod",result); Spieler[playerid][pDeath] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tot_X",result); Spieler[playerid][tot_x] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tot_Y",result); Spieler[playerid][tot_y] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tot_Z",result); Spieler[playerid][tot_z] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tot_Interior",result); Spieler[playerid][tot_int] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tot_VirtualWorld",result); Spieler[playerid][tot_world] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"TotZeit",result); Spieler[playerid][pDeathTime] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Friedhof",result); Spieler[playerid][pFriedhof] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FriedhofZeit",result); Spieler[playerid][pFriedhofTime] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"ImKnast",result); Spieler[playerid][pJailed] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"KnastZeit",result); Spieler[playerid][pJailTime] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"KnastKaution",result); Spieler[playerid][pKaution] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Muted",result); Spieler[playerid][pMuted] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"MuteZeit",result); Spieler[playerid][pMuteTime] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"ImPrison",result); Spieler[playerid][pInPrison] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PrisonCheckPointsAbgelaufen",result); Spieler[playerid][pPrisonCPsgelaufen] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PrisonCheckPointsGegeben",result); Spieler[playerid][pPrisonCPsgegeben] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Morde",result); Spieler[playerid][pMorde] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tode",result); Spieler[playerid][pTode] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"SkinID",result); Spieler[playerid][pSkin] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FraktionSkinID",result); Spieler[playerid][pFraktSkin] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PaintBallKills",result); Spieler[playerid][pPBKills] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PaintBallTode",result); Spieler[playerid][pPBDeaths] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PaintBallRang",result); Spieler[playerid][pPBRang] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PaintBallBesuche",result); Spieler[playerid][pPBVisits] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"AngenommeneReports",result); Spieler[playerid][Reports] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"KopfGeld",result); Spieler[playerid][pHeadMoney] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pWantedDeaths",result); Spieler[playerid][pWantedDeaths] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pBuyTickets",result); Spieler[playerid][pBuyTickets] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pJailedCount",result); Spieler[playerid][pJailedCount] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Bankkonto",result); Spieler[playerid][pBankkonto] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pArmyPlaneOrder",result); Spieler[playerid][pArmyPlaneOrder] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pArmyHeliOrder",result); Spieler[playerid][pArmyHeliOrder] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pArmyWaffenOrder",result); Spieler[playerid][pArmyWaffenOrder] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"LevelUPKosten",result); Spieler[playerid][pLevelKosten] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"RespectForLevelUp",result); Spieler[playerid][pRespektToLevelUp] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"RespectFromPayday",result); Spieler[playerid][pRespektFromPayday] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"TimeAfterRegister",result); Spieler[playerid][pTimeAfterRegister] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Time4Payday",result); Spieler[playerid][pMinutesAfterPayday] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"TimeoutCrashExeorKick",result); Spieler[playerid][pAntiOfflineFlucht] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"RpChat",result); Spieler[playerid][pAntiOfflineFlucht] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"HabGeworben",result); Spieler[playerid][HatGeworben] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pPremium",result); Spieler[playerid][pPremium] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"GeworbenerSpieler",result); strmid(Spieler[playerid][GeworbenPlaya],result,0,strlen(result),24); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pScheinSperre",result); Spieler[playerid][pScheinSperre] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"DigiHud",result); Spieler[playerid][DigiHud] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pDHitsound",result); Spieler[playerid][pDHitsound] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Bonus",result); Spieler[playerid][pStartbonus] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Gutschein",result); Spieler[playerid][pGutschein] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pCoins",result); Spieler[playerid][pCoins] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pFirmaLeader",result); Spieler[playerid][pFirmaLeader] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pFirmaMember",result); Spieler[playerid][pFirmaMember] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pOrgLeader",result); Spieler[playerid][pOrgLeader] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pOrgMember",result); Spieler[playerid][pOrgMember] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pParteiLeader",result); Spieler[playerid][pParteiLeader] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pParteiMember",result); Spieler[playerid][pParteiMember] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pLohn",result); Spieler[playerid][pLohn] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"WaitPerso",result); Spieler[playerid][WaitPerso] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pMarried",result); strmid(Spieler[playerid][pMarried],result,0,strlen(result),sizeof(result)); strdel(result,0,sizeof(result)); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pBuyClothes",result); Spieler[playerid][pBuyClothes] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pIll",result); Spieler[playerid][pIll] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pConterminatedTime",result); Spieler[playerid][pConterminatedTime] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pBitchSkill",result); Spieler[playerid][pBitchSkill] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pBitchFuckCount",result); Spieler[playerid][pBitchFuckCount] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pMedicHealplayerSkill",result); Spieler[playerid][pMedicHealplayerSkill] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pMedicHealCount",result); Spieler[playerid][pMedicHealCount] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Geburtstag",result); format(Spieler[playerid][pGeburtstag], 11, result); strdel(result,0,sizeof(result)); new stringlogin[256]; format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_weapons WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountWeapons","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_fish WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountFish","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_koffer WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountKoffer","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_blacklist WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountBlacklists","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_inventar WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountInventar","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_licenses WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountLicenses","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_banksafe WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountBankSafe","i",playerid); for(new slot=0;slot<MAX_PLAYER_VEHS;slot++) { format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_vehicle WHERE name = '%s' AND slot = '%d'",SpielerName(playerid),slot); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountVehicles","ii",playerid,slot); } mysql_SetInt(""#DATENBANKTAG"_account_main","Online",1,"Name",Spieler[playerid][pName]); AddToAutoLogin(playerid); StopPlayerPlaySound(playerid); PlayerPlaySound(playerid,1188,0.0,0.0,10.0); if(isPlayerAnAdmin(playerid,1)) { format(stringlogin,sizeof(stringlogin),"{FF0000}<< {FFFFFF}%s %s hat sich eingeloggt{FF0000} >>",Adminrang(playerid),SpielerName(playerid)); SendAdminMessage(WEISS,stringlogin); switch(Spieler[playerid][pAdmin]) { case 1: { TextDrawShowForPlayer(playerid,Reportdraw[0]); TextDrawShowForPlayer(playerid,Reportdraw[1]); } case 2,3,4: { TextDrawShowForPlayer(playerid,Reportdraw[0]); TextDrawShowForPlayer(playerid,Reportdraw[1]); TextDrawShowForPlayer(playerid,Reportdraw[2]); } case 5,6,7,8,9: { for(new i=0;i<sizeof(Reportdraw);i++) { TextDrawShowForPlayer(playerid,Reportdraw[i]); } } } format(stringlogin,sizeof(stringlogin),"Art : Login Admin: %s (Adminlevel: %i) * IP: %s - ID/PlayerID : %i",SpielerName(playerid),Spieler[playerid][pAdmin],SpielerIP(playerid),playerid); Log("Admin-Loginsqllog",stringlogin); } if(Spieler[playerid][pKoffer] == 1) SetPlayerAttachedObject(playerid,9,1210,5,0.310000,0.066999,0.000000,0.000000,-91.900009,0.000000,1.000000,1.000000,1.000000); if(Spieler[playerid][pHandy] != 0) { if(Spieler[playerid][pHandystate] == 1 && Spieler[playerid][pHandyakku] > 0.0) { PlayerTextDrawShow(playerid,HandyInfodraw[playerid]); HandyAkku(playerid); AkkuTimer[playerid] = SetTimerEx("HandyAkku",120000,1,"i",playerid); } } if(Spieler[playerid][pFraktion] != 0) { format(stringlogin,sizeof(stringlogin),"{00FFFF}<< Fraktionsmitglied{FF0000} %s {00FFFF}hat sich eingeloggt >>",SpielerName(playerid)); SendFraktionsMessage(Spieler[playerid][pFraktion],HELLBLAU,stringlogin); } format(stringlogin,sizeof(stringlogin),"Name:%s | IP:%s",SpielerName(playerid),SpielerIP(playerid)); Log("Player-Loginsql",stringlogin); if(Spieler[playerid][pViewTutorial] == 0)return ImTutorial[playerid] = 1; TogglePlayerControllable(playerid,1); TogglePlayerSpectating(playerid,0); SpawnPlayerEx(playerid); TextDrawHideForPlayer(playerid,Introdraw[0]); TextDrawHideForPlayer(playerid,Introdraw[1]); format(stringlogin,sizeof(stringlogin),"{A91400}SERVER{FFFFFF}: Willkommen %s",SpielerName(playerid)); SendClientMessage(playerid,WEISS,stringlogin); switch(monat) { case 1:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Januar"); case 2:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Februar"); case 3:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist März"); case 4:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist April"); case 5:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Mai"); case 6:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Juni"); case 7:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Juli"); case 8:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist August"); case 9:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist September"); case 10:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Oktober"); case 11:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist November"); case 12:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Dezember"); } if(tag == 31 && monat == 3) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Die Sommerzeit hat begonnen"); if(tag == 27 && monat == 10) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Die Winterzeit hat begonnen"); if(tag == 31 && monat == 10) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Halloween"); if(tag == 24 && monat == 12) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Frohe Weihnachten"); if(tag == 31 && monat == 12) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Das neue Jahr steht vor der Tür"); if(tag == 1 && monat == 1) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Frohes Neues Jahr"); TextDrawShowForPlayer(playerid,Version); TextDrawShowForPlayer(playerid,InfoSign); format(stringlogin,sizeof(stringlogin),"~w~Willkommen ~y~%s",SpielerName(playerid)); PlayerTextDrawSetString(playerid,INFOdraw[playerid][2],stringlogin); StopAudioStreamForPlayer(playerid); PlayAudioStreamForPlayer(playerid,ServerSounds[13],0.0,0.0,0.0); PlayerTextDrawShow(playerid,INFOdraw[playerid][2]); SetTimerEx("HideInfoBox",4000,0,"i",playerid); MakeRace[playerid] = -1; SetPlayerWaffenSkill(playerid); if(!isPlayerInFrakt(playerid,0)) { format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_fraktion_motd WHERE fID='%d'",Spieler[playerid][pFraktion]); mysql_function_query(MySqlConnection,stringlogin,true,"OnQueryFinish","siii",stringlogin,_SQL_FRAKTIONSMOTD_SELECT,playerid,MySqlConnection); } else ShowPlayerDialog(playerid,DIALOG_4ALL_SONSTIGES,DIALOG_STYLE_MSGBOX,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Info","Herzlich Willkommen auf "#SERVERNAME",\nbitte denke immer daran dich an die Regeln zu halten.\nBugs/Fehler im Spiel bitte im Forum melden.\n\nViel Spaß beim spielen!","Verlassen",""); if(GetPlayerLevel(playerid) <= ENABLE_KILLORPAY_BYLEVEL) { format(stringlogin,sizeof(stringlogin),"ACHTUNG: Solltest du als Level %i´er einen Spieler töten,",GetPlayerLevel(playerid)); SendClientMessage(playerid,LEUCHTENDESROT,stringlogin); SendClientMessage(playerid,LEUCHTENDESROT,"wirst du Automatisch vom System gebannt!"); } if(Spieler[playerid][HatGeworben] == 0) { if(GetPlayerLevel(playerid) <= 3) { SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Niemand hat dich geworben ?"); SendClientMessage(playerid,WEISS,"{FFFFFF} Falls doch Benutze: /geworben."); } else Spieler[playerid][HatGeworben] = 1; } new zeitdauer = gettime()+(60*60*24*7*2);//2 wochen mysql_SetInt(""#DATENBANKTAG"_account_main","PropertyClearTime",zeitdauer,"Name",SpielerName(playerid)); SetPVarInt(playerid,"Eingeloggt",1); OnlinePlayer(playerid,true); printf("LOAD: %s Account hat geladen!",SpielerName(playerid)); } return 1; }
das hier auch
19/01/2016-16:13:43 | errorid=1062,error=Duplicate entry '13' for key 'PRIMARY',query=INSERT INTO onlines (ID, Name) VALUES ('13','luiluiboy014')kann mir da einer helfen mfg lui
-
jetzt bekomme ich nur das hier
[15:52:31] [WARNING] CMySQLHandle::Create - connection already exists
[15:53:05] [WARNING] CMySQLHandle::Create - connection already exists
[15:53:50] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:29] [WARNING] CMySQLHandle::Create - connection already exists
[15:54:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')