Mysql Query Fehler

09/19/2012 10:10 Engel1621997#1
PHP Code:
string consulta = "SELECT pssw FROM acc WHERE usuario='";
   consulta += login_packet[2].c_str();
   consulta += "';";
   mysql_real_query(nosdb, consulta.c_str() ,strlen(consulta.c_str()));
   mres = mysql_use_result(nosdb);
   mrow = mysql_fetch_row(mres); 
Kann mir einer erklären was nicht geht ;(
09/19/2012 12:40 Deledt#2
Hm wie ich sehe ist das der Source von Ernilos :P

Also ich würde den query so schreiben

Code:
SELECT * FROM nostale.account WHERE Username = 'usernamehalt' AND Password = 'deinemutter'
Aber habe ich ihn schon gesagt :)

Code:
	string LoginQuery = "SELECT * FROM nostale.account WHERE Username = 'usernamehalt' AND Password = 'deinemutter'"; 
			int QueryCheck; 
			
			QueryCheck = mysql_real_query(nostale, LoginQuery.c_str(), strlen(LoginQuery.c_str())); 
			if(QueryCheck != 0)
			{
				cout << "Fehler !" << endl; 
			}
Sollte eig klappen :)
09/19/2012 12:43 Engel1621997#3
Danke ich habe für ihn gefragt ;)
09/19/2012 12:50 Deledt#4
Quote:
Danke ich habe für ihn gefragt
Achso Okay !,

Den sag ihn das strlen nicht gerade sauber ist nach der Aussage von -Trollface
09/19/2012 13:44 Engel1621997#5
Wieso woher hat er ihn den ? xD
09/20/2012 20:27 Kingrap#6
Engel you are italian? ("consulta" name)..
if you are italian you can add me to skype: d3vil.style..

you can use trollface encrypt/decrypt for login/game server..
you need insert all functions..

good work :)
09/20/2012 20:43 ernilos#7
Quote:
Originally Posted by Kingrap View Post
Engel you are italian? ("consulta" name)..
if you are italian you can add me to skype: d3vil.style..

you can use trollface encrypt/decrypt for login/game server..
you need insert all functions..

good work :)
That's ismy code, consulta is in spanish ><
09/21/2012 14:46 Kingrap#8
you copied code from youtube.. your server is for one client no plus clients..
you need insert multithreading and encrypt/decrypt for packets..

consulta = spanish and italian xD
09/21/2012 15:00 ernilos#9
Quote:
Originally Posted by Kingrap View Post
you copied code from youtube.. your server is for one client no plus clients..
you need insert multithreading and encrypt/decrypt for packets..

consulta = spanish and italian xD
Jajajjaja, ye ye.
Only i copied a sockets, abother i make I and works+ clients
09/22/2012 10:34 Kingrap#10
for login server he worked..

client -> server
client <- server
client -> disconnect from socket..

but for gameserver he don't worked..
client receive infinite packets from server and server too..

this server = question and ask..