"Stack/heap collision (insufficient stack size)"

[Lukas Ch]

[debug] Run time error 3: "Stack/heap collision (insufficient stack size)"

[12:54:04] [debug]  Stack pointer (STK) is 0xBC00, heap pointer (HEA) is 0xBBC8

[12:54:04] [debug] AMX backtrace:

12:54:04] [debug] #1 00001b2c in ?? (0, 0) from mano.amx

[12:54:04] [debug] #2 00001b2c in ?? (0, 0) from mano.amx

[12:54:04] [debug] #3 00001b2c in ?? (0, 0) from mano.amx

[12:54:04] [debug] #4 00001b2c in ?? (0, 0) from mano.amx

[12:54:04] [debug] #5 00001b2c in ?? (0, 0) from mano.amx

[12:54:04] [debug] #6 00001b2c in ?? (0, 0) from mano.amx

[12:54:04] [debug] #7 00001b2c in ?? (0, 0) from mano.amx

[12:54:04] [debug] #8 00001b2c in ?? (0, 0) from mano.amx

ir taip iki simto

 

Redaguota Liepos 28, 2015, nario Lukkas56

[ES.^]

Analogiška problema. Kažkur mode rekursija, ieškok.

[Lukas Ch]

a va radau, nepachaceinau password, keistai cia.

ir gal zinai kodel tarkim pas mane duombazej yra lukas. ir bandau jungtis su Lukas. vistiek meta prisijungima, nors yra lukas. tiktai, o tarkim tomas. ir kiti viskas ok - meta registracija

[ES.^]

Užklausoje galima panaudoti sql COLLATE sakinį. Daugiau informacijas galima rasti čia:

http://p2p.wrox.com/sql-server-2000/20002-using-collate-sql-select-statements.html

http://msdn.microsoft.com/en-us/library/ms184391.aspx

http://dev.mysql.com/doc/refman/5.0/en/charset-collate.html

http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html

http://sqlserver2000.databases.aspfaq.com/how-can-i-make-my-sql-queries-case-sensitive.html

- Blantas, gta-online

[Lukas Ch]

nezinau va padariau:

1) "SELECT `ID`, `Password` FROM `players` WHERE `Username` COLLATE latin1_swedish_ci = '%e' LIMIT 1"

2) "SELECT `ID`, `Password` FROM `players` WHERE _latin1 `Username` COLLATE latin1_swedish_ci = '%e' LIMIT 1"

 

sitais dviem, bet vistiek tas pats.. tik dabar jau net ir login nerodo nieko nerodo, iaj nerodo der error, raso kad blogas syntax rasymas, tipo mano eilutes abieju is ju

 

sitam nera error:

"SELECT `ID`, `Password` FROM `players` WHERE `Username` COLLATE latin1_swedish_ci = '%e' LIMIT 1"

 

o tam yra.

Redaguota Liepos 28, 2015, nario Lukkas56

[ES.^]

Bandyk

"SELECT `ID`, `Password` FROM `players` WHERE `Username` ORDER BY BINARY LIMIT 1"

[Lukas Ch]

be sito tas pats, su tavo kodu:

(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 'LIMIT 1' at line 1

Redaguota Liepos 28, 2015, nario Lukkas56

[ES.^]

Bandyk

"SELECT `ID`, `Password` FROM `players` WHERE `Username` = '%s' ORDER BY BINARY Username LIMIT 1"

[Lukas Ch]

dabar logino praso nors nicko nera

Redaguota Liepos 28, 2015, nario Lukkas56

[ES.^]

Ką tu čia iš viso nori padaryt?

[Lukas Ch]

tarkim pasirenka lyti onplayercoonct, showina dialoga, jei pasirenka vyras ten ar moteris tada paraso ta ir ta ir mysql_format selectina ka cia parases ir eina i checkaccounta if rows daro login else reg

Redaguota Liepos 28, 2015, nario Lukkas56

[ES.^]

"SELECT `ID`, `Password` FROM `players` WHERE `Username` = BINARY('%s') LIMIT 1"

[Lukas Ch]

veikia viskas, dekui. O ka cia tas binary daro seip?

[ES.^]

veikia viskas, dekui. O ka cia tas binary daro seip?

Nežinau pats.

[Lukas Ch]

aisku, nu dekui vistiek.