Beiträge von ReVenTon

    Hey ich hab ein problem wenn ich ingame gehe und mich registrieren will (auf meinem server) und dannach das passwort eingeben muss ist das passwort angeblich falsch. Dann habe ich in der Mysql Datenbank gekuckt und er wurde keine tabelle erstellt nichts... mache ich was falsch oder so? Und bei dem mysql log kommt das An error has occured. (Error ID: 1364, Field 'MarriedTo' doesn't have a default value) Falls ihr mir über teamviewer helfen wollt oder so bitte mich skype adden : jumper8reventon oder PM




    [20:23:02] CMySQLHandler::Query(UPDATE `onlines` SET `Name` = 'Awesome', `Legend` = '0' WHERE SQLid = '4') - Successfully executed.


    [20:23:02] >> mysql_query( Connection handle: 1 )


    [20:23:02] CMySQLHandler::Query(SELECT * FROM `bannedplayers` WHERE `Name`='Awesome') - Successfully executed.


    [20:23:02] >> mysql_store_result( Connection handle: 1 )


    [20:23:02] CMySQLHandler::StoreResult() - Result was stored.


    [20:23:02] >> mysql_num_rows( Connection handle: 1 )


    [20:23:02] CMySQLHandler::NumRows() - Returned 0 row(s)


    [20:23:02] >> mysql_free_result( Connection handle: 1 )


    [20:23:02] CMySQLHandler::FreeResult() - Result was successfully free'd.


    [20:23:02] >> mysql_query( Connection handle: 1 )


    [20:23:02] CMySQLHandler::Query(SELECT * FROM `users` WHERE `Name`='Awesome') - Successfully executed.


    [20:23:02] >> mysql_store_result( Connection handle: 1 )


    [20:23:02] CMySQLHandler::StoreResult() - Result was stored.


    [20:23:02] >> mysql_num_rows( Connection handle: 1 )


    [20:23:02] CMySQLHandler::NumRows() - Returned 0 row(s)


    [20:23:06] >> mysql_ping( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Ping() - Connection is still alive.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(INSERT INTO `users` (`Name`, `Key`) VALUES ('Awesome', 'der123123')) - An error has occured. (Error ID: 1364, Field 'MarriedTo' doesn't have a default value)


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `RegisterDatum`='1379622186' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `Key`='der123123', `Level`='0', `AdminLevel`='0', `DonateRank`='0', `UpgradePoints`='0', `ConnectedTime`='0', `Registered`='0', `Sex`='0', `Age`='0', `Origin`='0', `Muted`='0', `Respect`='0', `Money`='0', `Bank`='0', `Allowed`='0', `bankfach1`='0', `bankfach2`='0', `bankfach3`='0', `bankfach4`='0', `wgs`='0', `facherlaubis`='0', `Crimes`='0', `Kills`='0', `sKills`='0', `Deaths`='0', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='0', `Paycheck`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='-1', `Member`='-1', `Rank`='0', `Skin`='101', `Vertragszeit`='5', `DetSkill`='0', `SexSkill`='0', `LawSkill`='0', `MechSkill`='0', `JackSkill`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `CarSkill`='0', `NewsSkill`='0', `DrugsSkill`='0', `CookSkill`='0', `FishSkill`='0', `pSHealth`='50.0', `PhoneNr`='0', `House`='-1', `Biz`='-1', `CarLic`='0', `FlyLic`='0', `BoatLic`='0', `FishLic`='0', `GunLic`='0', `Zollpass`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `Gun1`='0', `Gun2`='0', `Gun3`='0', `Gun4`='0', `Ammo1`='0', `Ammo2`='0', `Ammo3`='0', `Ammo4`='0', `CarTime`='0', `PayDay`='1', `PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='0', `Warnings`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0', `SavedMaterials`='0', `SavedDrugs`='0', `SaveCodes`='0', `BikeLic`='0', `LKWLic`='0', `DonatorTime`='0', `WerberName`='Niemand', `FightingStyle`='0', `Handy`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `OnDutySkin`='60', `CarLicPoints`='0', `BikeLicPoints`='0', `InviteSperre`='0', `warntime1`='0', `warntime2`='0', `Ticketsopen`='0', `DonatorTime`='0', `OldName`='Niemand', `ClientIP`='91.60.69.67', `OrgMember`='-1', `OrgLeader`='-1', `OrgName`='Keine' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:09] >> mysql_real_escape_string( Connection handle: 1 )


    [20:23:09] CMySQLHandler::EscapeString(der123123); - Escaped 9 characters to der123123.


    [20:23:09] >> mysql_query( Connection handle: 1 )


    [20:23:09] CMySQLHandler::Query(SELECT `Key` FROM `users` WHERE `Name` = 'Awesome' AND `Key` = 'der123123') - Successfully executed.


    [20:23:09] >> mysql_store_result( Connection handle: 1 )


    [20:23:09] CMySQLHandler::StoreResult() - Result was stored.


    [20:23:09] >> mysql_num_rows( Connection handle: 1 )


    [20:23:09] CMySQLHandler::NumRows() - Returned 0 row(s)


    [20:23:09] >> mysql_free_result( Connection handle: 1 )



    Das kommt bei mysql log



    Kann mir bitte einer helfen?, Danke im voraus!

    @Music4You Sry tut mir leid, nein keinen syntax error gefunden...



    @TheBester Ja bitte gib mir deine skypeaddy oder adde du mich pls...


    Maximilian Heisst das, das ich mit Mysql nicht verbunden bin oder so ?? bin planlos sry...



    [20:23:02] CMySQLHandler::Query(UPDATE `onlines` SET `Name` = 'Awesome', `Legend` = '0' WHERE SQLid = '4') - Successfully executed.


    [20:23:02] >> mysql_query( Connection handle: 1 )


    [20:23:02] CMySQLHandler::Query(SELECT * FROM `bannedplayers` WHERE `Name`='Awesome') - Successfully executed.


    [20:23:02] >> mysql_store_result( Connection handle: 1 )


    [20:23:02] CMySQLHandler::StoreResult() - Result was stored.


    [20:23:02] >> mysql_num_rows( Connection handle: 1 )


    [20:23:02] CMySQLHandler::NumRows() - Returned 0 row(s)


    [20:23:02] >> mysql_free_result( Connection handle: 1 )


    [20:23:02] CMySQLHandler::FreeResult() - Result was successfully free'd.


    [20:23:02] >> mysql_query( Connection handle: 1 )


    [20:23:02] CMySQLHandler::Query(SELECT * FROM `users` WHERE `Name`='Awesome') - Successfully executed.


    [20:23:02] >> mysql_store_result( Connection handle: 1 )


    [20:23:02] CMySQLHandler::StoreResult() - Result was stored.


    [20:23:02] >> mysql_num_rows( Connection handle: 1 )


    [20:23:02] CMySQLHandler::NumRows() - Returned 0 row(s)


    [20:23:06] >> mysql_ping( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Ping() - Connection is still alive.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(INSERT INTO `users` (`Name`, `Key`) VALUES ('Awesome', 'test123')) - An error has occured. (Error ID: 1364, Field 'MarriedTo' doesn't have a default value)


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `RegisterDatum`='1379622186' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `Key`='der123123', `Level`='0', `AdminLevel`='0', `DonateRank`='0', `UpgradePoints`='0', `ConnectedTime`='0', `Registered`='0', `Sex`='0', `Age`='0', `Origin`='0', `Muted`='0', `Respect`='0', `Money`='0', `Bank`='0', `Allowed`='0', `bankfach1`='0', `bankfach2`='0', `bankfach3`='0', `bankfach4`='0', `wgs`='0', `facherlaubis`='0', `Crimes`='0', `Kills`='0', `sKills`='0', `Deaths`='0', `Arrested`='0', `ArrestTime`='0', `PhoneBook`='0', `LottoNr`='0', `Fishes`='0', `BiggestFish`='0', `Job`='0', `Paycheck`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `HeadValue`='0', `Jailed`='0', `JailTime`='0', `Leader`='-1', `Member`='-1', `Rank`='0', `Skin`='101', `Vertragszeit`='5', `DetSkill`='0', `SexSkill`='0', `LawSkill`='0', `MechSkill`='0', `JackSkill`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `CarSkill`='0', `NewsSkill`='0', `DrugsSkill`='0', `CookSkill`='0', `FishSkill`='0', `pSHealth`='50.0', `PhoneNr`='0', `House`='-1', `Biz`='-1', `CarLic`='0', `FlyLic`='0', `BoatLic`='0', `FishLic`='0', `GunLic`='0', `Zollpass`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `Gun1`='0', `Gun2`='0', `Gun3`='0', `Gun4`='0', `Ammo1`='0', `Ammo2`='0', `Ammo3`='0', `Ammo4`='0', `CarTime`='0', `PayDay`='1', `PayDayHad`='0', `CDPlayer`='0', `AlcoholPerk`='0', `PainKillerPerk`='0', `DrugPerk`='0', `MiserPerk`='0', `TraderPerk`='0', `Tutorial`='0', `Warnings`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `Fuel`='0', `Married`='0', `MarriedTo`='Niemand', `WantedLevel`='0', `Spawn`='0', `SavedMaterials`='0', `SavedDrugs`='0', `SaveCodes`='0', `BikeLic`='0', `LKWLic`='0', `DonatorTime`='0', `WerberName`='Niemand', `FightingStyle`='0', `Handy`='0' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:06] >> mysql_query( Connection handle: 1 )


    [20:23:06] CMySQLHandler::Query(UPDATE `users` SET `OnDutySkin`='60', `CarLicPoints`='0', `BikeLicPoints`='0', `InviteSperre`='0', `warntime1`='0', `warntime2`='0', `Ticketsopen`='0', `DonatorTime`='0', `OldName`='Niemand', `ClientIP`='91.60.69.67', `OrgMember`='-1', `OrgLeader`='-1', `OrgName`='Keine' WHERE `Name`='Awesome') - Successfully executed.


    [20:23:09] >> mysql_real_escape_string( Connection handle: 1 )


    [20:23:09] CMySQLHandler::EscapeString(test123); - Escaped 9 characters to test123.


    [20:23:09] >> mysql_query( Connection handle: 1 )


    [20:23:09] CMySQLHandler::Query(SELECT `Key` FROM `users` WHERE `Name` = 'Awesome' AND `Key` = 'test123') - Successfully executed.


    [20:23:09] >> mysql_store_result( Connection handle: 1 )


    [20:23:09] CMySQLHandler::StoreResult() - Result was stored.


    [20:23:09] >> mysql_num_rows( Connection handle: 1 )


    [20:23:09] CMySQLHandler::NumRows() - Returned 0 row(s)


    [20:23:09] >> mysql_free_result( Connection handle: 1 )



    Das kommt bei mysql log

    Hey ich hab ein problem wenn ich ingame gehe und mich registrieren will (auf meinem server) und dannach das passwort eingeben muss ist das passwort angeblich falsch.
    Dann habe ich in der Mysql Datenbank gekuckt und er wurde keine tabelle erstellt nichts... mache ich was falsch oder so?
    Und bei dem mysql log kommt das An error has occured. (Error ID: 1364, Field 'MarriedTo' doesn't have a default value)


    Falls ihr mir über teamviewer helfen wollt oder so bitte mich skype adden : jumper8reventon
    oder PM


    Kann mir bitte einer helfen?, Danke im voraus! ;(

    Hey, ich habe ein kleines problem mit meinem mysql script wenn ich mich ingame versuche zu registrieren und danach versuche einzuloggen steht da passwort nicht gefunden oder so.
    Danach habe ich in der Mysql datenbank unter ir gesucht bei users und das problem ist das er nichtmal eine tabelle erstellt, bzw die werte die userdaten usw werden nicht gespeichert?
    Was kann ich da tun kann mir da einer helfen??
    Die verbindung zur Datenbank steht!
    Das ist ein selfmade (nicht von mir selfmade) Script mit c.a 60k zeilen


    Danke im voraus! ;(

    Hallo, undzwar habe ich auf meiner Website ein wbb3 design hochgeladen und dort ist ein text der mir nicht gefällt bzw da steht "dies ist ein text zum test" und meine frage ist wie ich den weg bekomme?
    oder z.B in den design den namen ändere da steht z.b "samp german forum" und ich wollte halt drauß "reallife server blablabla" machen wie geht das?? könnt ihr mir helfen?
    einfach pm im forum oder skype adden wenn ihr wollt : Jumper8reventon


    Danke im Voraus! :P