- Mesaj
- 102
- Çözümler
- 3
- Beğeni
- 26
- Puan
- 439
- 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
düzenlenmiş hali
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