Kleines Problem

  • Kleines Problem

    SQL-Abfrage

    1. 30/10/2013-15:43:50 | errorid=1064,error=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 'blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreas' at line 1,query=CREATE TABLE IF NOT EXISTS `geRP_account_blacklist` (`Name` varchar(24) NOT NULL,,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,PRIMARY KEY (`Name`))


    SQL-Abfrage

    1. 30/10/2013-15:43:50 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE geRP_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCPRun` int(6) NOT NULL,`PrisonCPGive` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int(6) NOT NULL,`RespectFromPa


    SQL-Abfrage

    1. 30/10/2013-15:43:50 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE geRP_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pTsIdent` varchar(32) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)

    Ich weiß echnt nicht mehr weiter ich habe schon vieles versucht und finde denn Fehler nicht.

    Dieser Beitrag wurde bereits 1 mal editiert, zuletzt von kriega300 ()

  • [pwn]public LoadAccountBlacklists(playerid){ new rows,fields,result[30],savestring[30],query[128]; cache_get_data(rows,fields); if(rows) { for(new fID=0;fID<MAX_FRAKTIONNEN;fID++) { format(savestring,sizeof(savestring),"blacklist%i",fID); cache_get_field_content(0,savestring,result); Spieler[playerid][pKofferItems][fID] = strval(result); format(savestring,sizeof(savestring),"blacklistreason%i",fID); cache_get_field_content(0,savestring,result); strmid(pBLReason[playerid][fID],result,0,strlen(result),32); } } else { format(query,sizeof(query),"INSERT INTO "#SERVERTAG"_account_blacklist (Name) VALUES ('%s')",SpielerName(playerid)); mysql_function_query(MySqlConnection,query,false,"",""); } return 1;}[/pwn]

    Das ist der für die Blacklist

    Dieser Beitrag wurde bereits 1 mal editiert, zuletzt von kriega300 ()

  • for(new fID=0;fID<MAX_FRAKTIONNEN;fID++)
    {
    strcat(query,",");
    format(query,sizeof(query),"%sblacklist%i",query,fID);
    strcat(query,",");
    format(query,sizeof(query),"%sblacklistreason%i",query,fID);
    }
    strcat(query,",PRIMARY KEY (`Name`))");
    mysql_function_query(MySqlConnection,query,false,"","");

    Die Funktion sollte eig die Datenbank erstellen aber die musste ich erstellen