Beiträge von MoritzF

    MySQL Log:

    Code
    [22:34:58] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int='0' WHERE id ='25'' at line 1
    [22:35:03] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int='0' WHERE id ='25'' at line 1


    printf-Ausgabe:

    Code
    [22:35:03] UPDATE user SET px='1764.903808',py='-1946.639038',pz='13.558568',int='0' WHERE id ='25'

    Moin,
    ich habe ein Problem mit meiner Query.
    Es wird einfach nicht gespeichert und ich weiß nicht wieso.
    Vielleicht kann mir ja jemand helfen.
    Danke im vorraus.


    Hier ist mein Code:

    format(query,sizeof(query),"UPDATE user SET px='%f',py='%f',pz='%f',int='%i' WHERE id ='%i'",sInfo[playerid][p_x],sInfo[playerid][p_y],sInfo[playerid][p_z],sInfo[playerid][p_int],sInfo[playerid][id]);
    mysql_function_query(db_handle,query,false,"","");


    MFG MoritF.

    Tach.
    Mein Problem liegt darin, dass mache Spieler in die Fraktionscars einsteigen können und mance nicht.
    Hier ist der Code:


    Vielleicht übersehe ich etwas.
    Ich hoffe ihr könnt mir helfen.
    Danke im Vorraus!


    Mit freundlichen Grüßen MoritzF.

    Guten Morgen.
    Ich habe ein Problem mit einem Audiostream.


    Hier der Code:


    Der Audiostream wird jetzt immer hintereinander abgespielt, wenn ich mich dort befinde.
    Was mache ich falsch? Beziehungsweise, wie mache ich es richtig?
    Danke schonmal für die Antworten!



    Mit freundlichen Grüßen MoritzF.

    Moin!


    Ich habe auf meinem Server ein komisches Objekt.
    Ich weiß nicht, woher dieses kommt. Es ist nicht im Script eingetragen.
    Vielleicht kennt ja hier jemand eine Lösung, das Objekt zu löschen.


    Hier, ein Bild:
    Danke für die Antworten!


    Mit freundlichen Grüßen MoritzF.

    ////-/////-/////-/////-/////-/////-/////-/////-/////-/////-/////-/////-/////-//
    // FB_TimeBan-System //
    // foXban //
    // COPYRIGHT BY FOXHOUND / PSPGAMER //
    ////-/////-/////-/////-/////-/////-/////-/////-/////-/////-/////-/////-/////-//


    //------< INCLUDEs >------//
    #include <a_samp>
    //------------------------//


    //-------------< DEFINEs >--------------//
    #define FB_foxBanFile "FoxBan/%s.fxban"
    #define MAX_STRING 255
    //--------------------------------------//


    //---------------< FORWARDs >---------------//
    forward FB_OnPlayerConnect(playerid);
    //------------------------------------------//


    //-------< NEWs >-------//
    new FB_tbDir[64];
    //----------------------//


    //----------------------------------------------------------< OnPlayerConnect >-----------------------------------------------------------//
    public OnPlayerConnect(playerid)
    {
    new pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid,pName,sizeof(pName));
    format(FB_tbDir,sizeof(FB_tbDir),FB_foxBanFile,pName);
    if(FB_dini_Exists(FB_tbDir))
    {
    if(FB_dini_Int(FB_tbDir,"fbFB_Time")+FB_dini_Int(FB_tbDir,"fbDuration") > FB_Time())
    {
    new string[96];
    new sekki=(FB_dini_Int(FB_tbDir,"fbFB_Time")+FB_dini_Int(FB_tbDir,"fbDuration"))-FB_Time(),minni=sekki/60;
    sekki=sekki-minni*60;
    format(string,sizeof(string),"You are timebanned from this server. Remaining time: %d minutes %d seconds",minni,sekki);
    SendClientMessage(playerid,0xADC7E7FF,string);
    Kick(playerid);
    } else { FB_dini_Remove(FB_tbDir); }
    }
    return CallLocalFunction("FB_OnPlayerConnect","i",playerid);
    }
    //----------------------------------------------------------------------------------------------------------------------------------------//


    //------------------------< TBAN >------------------------//
    forward TBan(pID,bFB_Time);
    public TBan(pID,bFB_Time)
    {
    new pName[MAX_PLAYER_NAME],string[64];
    GetPlayerName(pID,pName,sizeof(pName));
    format(string,sizeof(string),FB_foxBanFile,pName);
    FB_dini_Create(string);
    FB_dini_IntSet(string,"fbFB_Time",FB_Time());
    FB_dini_IntSet(string,"fbDuration",bFB_Time*60);
    Kick(pID);
    }
    //--------------------------------------------------------//


    //---------------------------< TUNBAN >---------------------------//
    forward TUnban(playername[]);
    public TUnban(playername[])
    {
    format(FB_tbDir,sizeof(FB_tbDir),FB_foxBanFile,playername);
    if(FB_dini_Exists(FB_tbDir)) {
    FB_dini_Remove(FB_tbDir); return true; }
    return false;
    }
    //----------------------------------------------------------------//


    //---------------------------------------------< TUNBAN >---------------------------------------------//
    stock GetPlayerBanFB_Time(playername[],&minu=0,&seco=0)
    {
    format(FB_tbDir,sizeof(FB_tbDir),FB_foxBanFile,playername);
    if(FB_dini_Exists(FB_tbDir))
    {
    seco=(FB_dini_Int(FB_tbDir,"fbFB_Time")+FB_dini_Int(FB_tbDir,"fbDuration"))-FB_Time();
    seco=seco-minu*60;
    minu=seco/60;
    }
    }
    //----------------------------------------------------------------------------------------------------//


    //------------------------< BanFileExist >------------------------//
    forward BanFileExist(playername[]);
    public BanFileExist(playername[])
    {
    format(FB_tbDir,sizeof(FB_tbDir),FB_foxBanFile,playername);
    if(FB_dini_Exists(FB_tbDir)) { return 1; } else { return 0; }
    }
    //----------------------------------------------------------------//


    //////////////////////////////////////////// INTEGRATED DINI.inc & DUTILS.inc (THX DRACOBLUE) ////////////////////////////////////////////////
    stock FB_mktime(hour,minute,second,day,month,year) {
    new timestamp2; timestamp2 = second + (minute * 60) + (hour * 3600); new days_of_month[12]; if ( ((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0) ) { days_of_month = {31,29,31,30,31,30,31,31,30,31,30,31}; } else { days_of_month = {31,28,31,30,31,30,31,31,30,31,30,31}; }
    new days_this_year = 0; days_this_year = day; if(month > 1) { for(new i=0; i<month-1;i++) { days_this_year += days_of_month[i]; }
    } timestamp2 += days_this_year * 86400; for(new j=1970;j<year;j++) { timestamp2 += 31536000; if ( ((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0) ) timestamp2 += 86400; }
    return timestamp2; }
    stock FB_Time() { new fxban_int_hour,fxban_int_minute,fxban_int_second,fxban_int_year,fxban_int_month,fxban_int_day; gettime(fxban_int_hour, fxban_int_minute, fxban_int_second); getdate(fxban_int_year, fxban_int_month, fxban_int_day); return FB_mktime(fxban_int_hour,fxban_int_minute,fxban_int_second,fxban_int_day,fxban_int_month,fxban_int_year); }
    stock FB_fcopytextfile(oldname[],newname[]) {
    new File:ohnd,File:nhnd; if (!fexist(oldname)) return false; ohnd=fopen(oldname,io_read); nhnd=fopen(newname,io_write); new tmpres[MAX_STRING]; while (fread(ohnd,tmpres)) {
    FB_StripNewLine(tmpres); format(tmpres,sizeof(tmpres),"%s\r\n",tmpres); fwrite(nhnd,tmpres); }
    fclose(ohnd); fclose(nhnd); return true; }
    stock FB_equal(str1[],str2[],bool:ignorecase) { if (strlen(str1)!=strlen(str2)) return false; if (strcmp(str1,str2,ignorecase)==0) return true; return false; }
    stock FB_ret_memcpy(source[],index=0,numbytes) {
    new tmp[MAX_STRING],i=0; tmp[0]=0; if (index>=strlen(source)) return tmp; if (numbytes+index>=strlen(source)) numbytes=strlen(source)-index; if (numbytes<=0) return tmp; for (i=index;i<numbytes+index;i++) {
    tmp[i-index]=source[i]; if (source[i]==0) return tmp; }
    tmp[numbytes]=0; return tmp; }
    stock FB_strlower(txt[]) {
    new tmp[MAX_STRING]; tmp[0]=0; if (txt[0]==0) return tmp; new i=0; for (i=0;i<strlen(txt);i++) {
    tmp[i]=tolower(txt[i]); }
    tmp[strlen(txt)]=0; return tmp; }
    stock FB_StripNewLine(string[]) { new len = strlen(string); if (string[0]==0) return ; if ((string[len - 1] == '\n') || (string[len - 1] == '\r')) { string[len - 1] = 0; if (string[0]==0) return ; if ((string[len - 2] == '\n') || (string[len - 2] == '\r')) string[len - 2] = 0; } }
    stock FB_set(dest[],source[]) {
    new count = strlen(source),i=0; for (i=0;i<count;i++) {
    dest[i]=source[i]; }
    dest[count]=0; }
    stock FB_dini_Exists(filename[]) { if (fexist(filename)) return true; return false; }
    stock FB_dini_Remove(filename[]) { if (!fexist(filename)) return false; fremove(filename); return true; }
    stock FB_dini_Create(filename[]) { new File:fhnd; if (fexist(filename)) return false; fhnd=fopen(filename,io_write); fclose(fhnd); return true; }
    stock FB_dini_IntSet(filename[],key[],value) { new valuestring[MAX_STRING]; format(valuestring,sizeof(valuestring),"%d",value); return FB_dini_Set(filename,key,valuestring); }
    stock FB_dini_Int(filename[],key[]) { return strval(FB_dini_Get(filename,key)); }
    stock FB_dini_Set(filename[],key[],value[]) {
    new File:fohnd, File:fwhnd; new bool:wasset=false; new tmpres[MAX_STRING]; if (key[0]==0) return false; format(tmpres,sizeof(tmpres),"%s.part",filename); fohnd=fopen(filename,io_read); if (!fohnd) return false; fremove(tmpres); fwhnd=fopen(tmpres,io_write); while (fread(fohnd,tmpres)) {
    FB_StripNewLine(tmpres); if ((!wasset)&&(FB_equal(FB_dini_PRIVATE_ExtractKey(tmpres),key,true))) { format(tmpres,sizeof(tmpres),"%s=%s",key,value); wasset=true; }
    fwrite(fwhnd,tmpres); fwrite(fwhnd,"\r\n"); }
    if (!wasset) { format(tmpres,sizeof(tmpres),"%s=%s",key,value); fwrite(fwhnd,tmpres); fwrite(fwhnd,"\r\n"); }
    fclose(fohnd); fclose(fwhnd); format(tmpres,sizeof(tmpres),"%s.part",filename); if (FB_fcopytextfile(tmpres,filename)) { return fremove(tmpres); }
    return false; }
    stock FB_dini_Get(filename[],key[]) {
    new File:fohnd,tmpres[MAX_STRING],tmpres2[MAX_STRING]; tmpres[0]=0; fohnd=fopen(filename,io_read); if (!fohnd) return tmpres; while (fread(fohnd,tmpres)) {
    FB_StripNewLine(tmpres); if(FB_equal(FB_dini_PRIVATE_ExtractKey(tmpres),key,true)) { tmpres2[0]=0; strcat(tmpres2,FB_dini_PRIVATE_ExtractValue(tmpres)); fclose(fohnd); return tmpres2; } }
    fclose(fohnd); return tmpres; }
    stock FB_dini_PRIVATE_ExtractKey(line[]) { new tmp[MAX_STRING]; tmp[0]=0; if (strfind(line,"=",true)==-1) return tmp; FB_set(tmp,FB_strlower(FB_ret_memcpy(line,0,strfind(line,"=",true)))); return tmp; }
    stock FB_dini_PRIVATE_ExtractValue(line[]) {
    new tmp[MAX_STRING]; tmp[0]=0; if (strfind(line,"=",true)==-1) { return tmp; }
    FB_set(tmp,FB_ret_memcpy(line,strfind(line,"=",true)+1,strlen(line))); return tmp; }
    //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

    #define OnPlayerConnect FB_OnPlayerConnect

    #if defined _ALS_OnPlayerConnect
    #undef OnPlayerConnect
    #else
    #define _ALS_OnPlayerConnect
    #endif
    #define OnPlayerConnect SSCANF_OnPlayerConnect
    #if defined SSCANF_OnPlayerConnect
    forward SSCANF_OnPlayerConnect(playerid);
    #endif




    Das sollte es sein

    Moin,
    mein Problem ist ein Warning.
    Vielleicht kann ja jemand helfen.
    Also, hier der Warning: \pawno\include\sscanf2.inc(213) : warning 201: redefinition of constant/macro (symbol "OnPlayerConnect")


    Mit freundlichen Grüßen MoritzF

    Du musst abfragen, ob der Spieler als Beifahrer in einem Auto sitzt und gegebenenfalls das Auto mitporten und den Spieler wieder auf den Beifahrer sitz packen.


    //EDIT:

    ocmd:goto(playerid,params[])
    {
    if(sInfo[playerid][eingeloggt]==0) return SendClientMessage(playerid,FARBE_WEISS,"Du musst eingeloggt sein.");
    if(!isAdmin(playerid,4)) return 1;
    new pID,string[128],Float:x,Float:y,Float:z,int,world;
    if(sscanf(params,"u",pID))return SendClientMessage(playerid,FARBE_ROT,"BEFEHL: /goto [ID]");
    if(!IsPlayerConnected(pID))return 1;
    GetPlayerPos(pID,x,y,z);
    world = GetPlayerVirtualWorld(pID);
    int = GetPlayerInterior(pID);
    SetPlayerVirtualWorld(playerid,world);
    SetPlayerInterior(playerid,int);
    SetPlayerPos(playerid,x,y,z);
    if(IsPlayerInAnyVehicle(playerid))
    {
    if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
    {
    new VID = GetPlayerVehicleID(playerid);
    SetVehiclePos(VID,x,y,z);
    PutPlayerInVehicle(playerid,VID,0);
    ]
    if(GetPlayerState(playerid)==PLAYER_STATE_PASSENGER)
    {
    new sitz = GetPlayerState(playerid);
    new VID = GetPlayerVehicleID(playerid);
    SetVehiclePos(VID,x,y,z);
    PutPlayerInVehicle(playerid,VID,sitz);
    ]
    }
    format(string,sizeof(string),"Du hast dich zu %s geportet.",getPlayerName(pID));
    SendClientMessage(playerid,FARBE_TUERKIS,string);
    format(string,sizeof(string),"Admin %s hat sich zu dir geportet.",getPlayerName(playerid));
    SendClientMessage(pID,FARBE_TUERKIS,string);
    return 1;
    }