Register for your free account! | Forgot your password?

Go Back   elitepvpers > Coders Den > C/C++
You last visited: Today at 04:56

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Mysql Query Fehler

Discussion on Mysql Query Fehler within the C/C++ forum part of the Coders Den category.

Reply
 
Old   #1
 
Engel1621997's Avatar
 
elite*gold: 0
Join Date: Sep 2011
Posts: 581
Received Thanks: 72
Question Mysql Query Fehler

PHP Code:
string consulta "SELECT pssw FROM acc WHERE usuario='";
   
consulta += login_packet[2].c_str();
   
consulta += "';";
   
mysql_real_query(nosdbconsulta.c_str() ,strlen(consulta.c_str()));
   
mres mysql_use_result(nosdb);
   
mrow mysql_fetch_row(mres); 
Kann mir einer erklären was nicht geht ;(
Engel1621997 is offline  
Old 09/19/2012, 12:40   #2
 
elite*gold: 43
Join Date: Jul 2011
Posts: 537
Received Thanks: 160
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
Deledt is offline  
Old 09/19/2012, 12:43   #3
 
Engel1621997's Avatar
 
elite*gold: 0
Join Date: Sep 2011
Posts: 581
Received Thanks: 72
Danke ich habe für ihn gefragt
Engel1621997 is offline  
Old 09/19/2012, 12:50   #4
 
elite*gold: 43
Join Date: Jul 2011
Posts: 537
Received Thanks: 160
Quote:
Danke ich habe für ihn gefragt
Achso Okay !,

Den sag ihn das strlen nicht gerade sauber ist nach der Aussage von -Trollface
Deledt is offline  
Old 09/19/2012, 13:44   #5
 
Engel1621997's Avatar
 
elite*gold: 0
Join Date: Sep 2011
Posts: 581
Received Thanks: 72
Wieso woher hat er ihn den ? xD
Engel1621997 is offline  
Old 09/20/2012, 20:27   #6
 
elite*gold: 0
Join Date: Dec 2011
Posts: 367
Received Thanks: 199
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
Kingrap is offline  
Old 09/20/2012, 20:43   #7
 
ernilos's Avatar
 
elite*gold: 20
Join Date: Jan 2012
Posts: 766
Received Thanks: 645
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 ><
ernilos is offline  
Old 09/21/2012, 14:46   #8
 
elite*gold: 0
Join Date: Dec 2011
Posts: 367
Received Thanks: 199
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
Kingrap is offline  
Old 09/21/2012, 15:00   #9
 
ernilos's Avatar
 
elite*gold: 20
Join Date: Jan 2012
Posts: 766
Received Thanks: 645
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
ernilos is offline  
Old 09/22/2012, 10:34   #10
 
elite*gold: 0
Join Date: Dec 2011
Posts: 367
Received Thanks: 199
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..
Kingrap is offline  
Reply


Similar Threads Similar Threads
MySQL Fehler, Query einfügen ..
08/14/2012 - Metin2 Private Server - 4 Replies
Wenn ich querrys von reittier einfügen will kommt immer dieser fehler : 1136 - Column count doesn't match value count at row 1 kennt sich einer damit aus?
Mysql Query ...
07/25/2012 - Metin2 Private Server - 1 Replies
Aböönd miteinander, ja, ich hab da ne Frage zur folgender Syserr Meldung .. DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id Die meldung hat irgendwas mit der DB (mysql) zu tun, dass ist mir klar, jedoch weiß ich nicht genau was dort beschrieben wird :s
PHP-Mysql _ query
06/08/2012 - Web Development - 0 Replies
Hallo meine frage/problem wie kriege ich es hin das diese anfragen mit einem query abgesendet werden? $eintrag = "INSERT INTO lions_aateilnahme (Event,Freund,Personen,EssenFleisch, EssenFisch,EssenVeg,Kommen,Bemerkung) VALUES ('$id','$name', '$teilnehmer','$norm', '$fisch','$veg','$kommen','$bemerkung')"; $eintragen = mysql_query($eintrag); if(!empty($int)){ $intt= "INSERT INTO lions_aateilnahme (IntAntwort1) VALUES('$int')"; $eintragen = mysql_query($intt);
PHP/MySQL Help - Is this MySQL Query correct?
09/23/2011 - CO2 Programming - 1 Replies
$rank = mysql_query("SELECT Name,Level,Class,Online FROM entities ORDER BY Level DESC LIMIT $limit"); I'm pretty sure that is right... whenever I do while ($row = mysql_fetch_array($rank)) { ... } It always gives me a mysql_fetch_array error. I've checked and the database is populated, the columns exist, so what could be the issue?
Problem: MySQL Query Error
09/10/2008 - Flyff Private Server - 2 Replies
Hi, ich hab heute die Serverfiles (rev_1) gedownloadet und auch wie in dem Guide konfiguriert. Sprich: MySQL installiert, Navicat installiert, .inis abgeändert, SQLs in Navicat eingefügt, neuz.ini abgeändert... Ich kann mich auch einloggen, aber bei der Charaktererstellung kommt immer folgendes Problem, egal welche Datenbank ich benutze...: MySQL Query Error 'Field' 'channelnum' doesn't have a default value' Btw: Ich hab auch schon probiert einen beliebigen Wert in der Tabelle...



All times are GMT +1. The time now is 04:56.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.