Yardım Martysama mariadb kurulum kulanici adi sifre yanış

Konu sahibi bu konuda soru soruyor. Sorusu ile ilgili bilgisi olanların yanıtlamasını bekliyor.

emrahdmr47

Üye
Üye
Mesaj
84
Çözümler
3
Beğeni
20
Puan
414
Ticaret Puanı
0
Merhaba mmotutkunları martsama 5.7 sonitex shoplu filesi kurarken bircok sorunla karşılastım yardımlarınız sahesinde baya ilerleme kaydettim maksat server acmak deil zaten birseyler ogrenmek başarmak yoksa hepimiz biliyoruz 2 3 ay takılıp metin2 yoluna ben yolumu

kulanici adi sifre yanlış uyarısı uzerine bu konudaki input_auth.cpp de ( SELECT '%s') olan yeri SELECT PASSWORD('%s') olarak degistirdim bu seferde yanlıs girdigimde kulanici adi sifre yanlıs diyor dogru girdigimde baglanamadi hatasi verio


orjinal hali
orjinal hali input_auth.cpp::
#ifdef __WIN32__
        DBManager::instance().ReturnQuery(QID_AUTH_LOGIN, dwKey, p,
                "SELECT PASSWORD('%s'),password,securitycode,social_id,id,status,availDt - NOW() > 0,"
                "UNIX_TIMESTAMP(silver_expire),"
                "UNIX_TIMESTAMP(gold_expire),"
                "UNIX_TIMESTAMP(safebox_expire),"
                "UNIX_TIMESTAMP(autoloot_expire),"
                "UNIX_TIMESTAMP(fish_mind_expire),"
                "UNIX_TIMESTAMP(marriage_fast_expire),"
                "UNIX_TIMESTAMP(money_drop_rate_expire),"
#ifdef __PREMIUM_PRIVATE_SHOP__
                "UNIX_TIMESTAMP(premium_privateshop_expire),"
#endif
                "UNIX_TIMESTAMP(create_time)"
                " FROM account WHERE login='%s'", szPasswd, szLogin);
#else
        // @fixme138 1. PASSWORD('%s') -> %s 2. szPasswd wrapped inside mysql_hash_password(%s).c_str()
        DBManager::instance().ReturnQuery(QID_AUTH_LOGIN, dwKey, p,
                "SELECT '%s',password,securitycode,social_id,id,status,availDt - NOW() > 0,"
                "SELECT PASSWORD('%s'),password,securitycode,social_id,id,status,availDt - NOW() > 0,"
                "UNIX_TIMESTAMP(silver_expire),"
                "UNIX_TIMESTAMP(gold_expire),"
                "UNIX_TIMESTAMP(safebox_expire),"
                "UNIX_TIMESTAMP(autoloot_expire),"
                "UNIX_TIMESTAMP(fish_mind_expire),"
                "UNIX_TIMESTAMP(marriage_fast_expire),"
                "UNIX_TIMESTAMP(money_drop_rate_expire),"
#ifdef __PREMIUM_PRIVATE_SHOP__
                "UNIX_TIMESTAMP(premium_privateshop_expire),"
#endif
                "UNIX_TIMESTAMP(create_time)"
                " FROM account WHERE login='%s'",
                mysql_hash_password(szPasswd).c_str(), szLogin);
#endif

düzenlenmiş hali
düzenlenmiş hali:
#ifdef __WIN32__
        DBManager::instance().ReturnQuery(QID_AUTH_LOGIN, dwKey, p,
                "SELECT PASSWORD('%s'),password,securitycode,social_id,id,status,availDt - NOW() > 0,"
                "UNIX_TIMESTAMP(silver_expire),"
                "UNIX_TIMESTAMP(gold_expire),"
                "UNIX_TIMESTAMP(safebox_expire),"
                "UNIX_TIMESTAMP(autoloot_expire),"
                "UNIX_TIMESTAMP(fish_mind_expire),"
                "UNIX_TIMESTAMP(marriage_fast_expire),"
                "UNIX_TIMESTAMP(money_drop_rate_expire),"
#ifdef __PREMIUM_PRIVATE_SHOP__
                "UNIX_TIMESTAMP(premium_privateshop_expire),"
#endif
                "UNIX_TIMESTAMP(create_time)"
                " FROM account WHERE login='%s'", szPasswd, szLogin);
#else
        // @fixme138 1. PASSWORD('%s') -> %s 2. szPasswd wrapped inside mysql_hash_password(%s).c_str()
        DBManager::instance().ReturnQuery(QID_AUTH_LOGIN, dwKey, p,
                "SELECT PASSWORD('%s'),password,securitycode,social_id,id,status,availDt - NOW() > 0,"
                "UNIX_TIMESTAMP(silver_expire),"
                "UNIX_TIMESTAMP(gold_expire),"
                "UNIX_TIMESTAMP(safebox_expire),"
                "UNIX_TIMESTAMP(autoloot_expire),"
                "UNIX_TIMESTAMP(fish_mind_expire),"
                "UNIX_TIMESTAMP(marriage_fast_expire),"
                "UNIX_TIMESTAMP(money_drop_rate_expire),"
#ifdef __PREMIUM_PRIVATE_SHOP__
                "UNIX_TIMESTAMP(premium_privateshop_expire),"
#endif
 
senin büyük ihtimalle ch1 gidik. server şifre yanlış diyebiliyor çünkü auth aktif ama doğru yazınca hata veriyor çünkü auth ch1 den yanıt alamıyor.
 
db veyahut auth klasöründe syserr oluşturmuştur muhtemelen , onu atabilir misin.
auto syser
auto syser:
SYSERR: Feb 15 22:45:54 :: LoadSetting: [INIT_FORKED] Do not open file (locale/turkey/forkedmapindex.txt)
SYSERR: Feb 15 22:45:54 :: Cube_init: Cube_Init failed
SYSERR: Feb 15 22:45:54 :: Blend_Item_init: <Blend_Item_init> fail
db syser nacivat player sql atarken eror veriyordu SET sql_mode = ''; bunu ekledim erorsuz aktardı acba yanlış mı yaptım
db syser:
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #21549 Viridian Wood Helmet+9   SELL_OVERFLOW dwGold: 20000 < dwShopBuyPrice 178000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #21554 Dragonhorn Helmet +4     SELL_OVERFLOW dwGold: 20000 < dwShopBuyPrice 22000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #21555 Dragonhorn Helmet +5     SELL_OVERFLOW dwGold: 20000 < dwShopBuyPrice 34000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #21556 Dragonhorn Helmet +6     SELL_OVERFLOW dwGold: 20000 < dwShopBuyPrice 52000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #21557 Dragonhorn Helmet +7     SELL_OVERFLOW dwGold: 20000 < dwShopBuyPrice 78000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #21558 Dragonhorn Helmet +8     SELL_OVERFLOW dwGold: 20000 < dwShopBuyPrice 118000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #21559 Dragonhorn Helmet +9     SELL_OVERFLOW dwGold: 20000 < dwShopBuyPrice 178000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #30192 Plant Sap                SELL_OVERFLOW dwGold: 300 < dwShopBuyPrice 2400
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #30193 Finger Bones             SELL_OVERFLOW dwGold: 300 < dwShopBuyPrice 2400
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #30194 Orc Club                 SELL_OVERFLOW dwGold: 300 < dwShopBuyPrice 2400
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #30195 Quartz Sand              SELL_OVERFLOW dwGold: 300 < dwShopBuyPrice 2400
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #30196 Demon's Ashes            SELL_OVERFLOW dwGold: 300 < dwShopBuyPrice 4800
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #30197 Magic Seeds              SELL_OVERFLOW dwGold: 300 < dwShopBuyPrice 4800
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #30198 Water Crystal            SELL_OVERFLOW dwGold: 300 < dwShopBuyPrice 4800
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #30199 Blue Crystal             SELL_OVERFLOW dwGold: 300 < dwShopBuyPrice 6000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #30202 Tanaka's Ear             SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 500
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #38060 Bag of Emotions          SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 1
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50002 Gold Ring                SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 10000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50006 Gold Treasure Chest      SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 1000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50007 Silver Treasure Chest    SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 1000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50008 Gold Key                 SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50009 Silver Key               SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50012 Gold Treasure Chest+     SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 1000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50013 Silver Treasure Chest+   SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 1000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50014 Gold Key+                SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50015 Silver Key+              SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50016 Bean Paste               SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50017 Sugar Paste              SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50018 Fruit Paste              SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50019 Sweet Rice               SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50020 Bean Cake                SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50021 Sugar Cake               SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50022 Fruit Cake               SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50023 Money Pouch              SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50028 24k Gold Ring            SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 50000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50029 18k Gold Ring            SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 10000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50030 14k Gold Ring            SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 1000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50043 Kelpie Key               SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 200
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50060 Horse Riding Manual      SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50061 Horse Taming Manual      SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50062 Riding Manual            SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50307 Mission Book (Easy)      SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50308 Mission Book (Normal)    SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50309 Mission Book (Hard)      SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50310 Mission Book (Expert)    SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50311 Shinsoo Linguistics      SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50312 Chunjo Linguistics       SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50313 Jinno Linguistics        SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50314 Polymorph Book           SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50315 Advanced Polymorph Book  SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50316 Master Polymorph Book    SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50317 Mission Book (Test)      SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50318 Mission Book (Easy)      SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50319 Mission Book (Normal)    SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50320 Mission Book (Hard)      SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50321 Mission Book (Expert)    SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50322 Transformation Role      SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 60
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50330 Mission Book (Lord 1)    SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50331 Mission Book (Lord 2)    SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50332 Mission Book (Lord 3)    SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50902 Recipe for Beginners     SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50903 Recipe                   SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #50904 Expert's Recipe          SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 100
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #55028 Tasty Treat              SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 160000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #55031 Tasty Treat+             SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 1
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #55033 Enchant Pet              SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 1
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70048 Cloak of Secrecy         SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 10000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70049 Lucy's Ring              SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 10000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70050 Sage King's Symbol       SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 10000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70051 Sage King's Glove        SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 10000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70102 Zen Bean                 SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 1000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70103 Sutra                    SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 10000
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70104 Polymorph Marble         SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 60
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70105 Polymorph Marble         SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 60
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70106 Polymorph Marble         SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 60
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70107 Polymorph Marble         SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 60
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70201 Bleach                   SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 60
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70202 White Hair Dye           SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 60
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70203 Blonde Hair Dye          SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 60
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70204 Red Hair Dye             SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 60
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70205 Brown Hair Dye           SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 60
SYSERR: Feb 15 22:45:51 :: Set_Proto_Item_Table: ITEM: #70206 Black Hair Dye           SELL_OVERFLOW dwGold: 0 < dwShopBuyPrice 60
 
Son düzenleme:
Geri
Üst