
May 3rd, 2007, 11:48 PM
|
|
Registered User
|
|
Join Date: May 2007
Posts: 1
Time spent in forums: 23 m 36 sec
Reputation Power: 0
|
|
|
I need help please!!!!
Code:
MYSQL *conn;
56 MYSQL_RES *pResult;
57 MYSQL_ROW Row;
58 int pRow;
59 string sqlquery;
60 stringstream out;
61 string sID;
62 const char *tempUN;
63 const char *tempPW;
64
65 conn = mysql_init(NULL);
66 bool connsuccess = mysql_real_connect(conn, "localhost", "root", "YES", "swgemu", 3306, 0, 0);
67 if (!connsuccess)
68 printf("Fatal Error:: Could not connect to Database\n");
69 else
70 printf("Database Connection: Successful!\n\n\n");
71
72 sqlquery = "SELECT * FROM `account` WHERE username = '" + username + "'";
73
74 mysql_query(conn, sqlquery.c_str());
75
76 pResult = mysql_store_result(conn);
77 if(pResult) while ((Row = mysql_fetch_row(pResult)) != NULL) 78 tempUN = ("%s\n", Row[1]);
79
80 if(tempUN != username)
81 goto CreateNewUser;
82 else
83 mysql_free_result(pResult);
84 sqlquery = "";
85
86 sqlquery = "SELECT * FROM `account` WHERE username = '" + username + "'";
87
88 mysql_query(conn, sqlquery.c_str());
89
90 pResult = mysql_store_result(conn);
91 if(pResult) while ((Row = mysql_fetch_row(pResult)) != NULL)
92 tempPW = ("%s\n", Row[2]);
93
94 if(tempPW != password)
95 {
96 printf("\n Incorrect Password!\n\n");
97 return false;
98 }
99 else
100 mysql_free_result(pResult);
101 sqlquery = "";
102 goto EndSQL;
103
104 CreateNewUser:
105
106 printf("Creating new user.....\n\n");
107 srand((unsigned int)time(NULL));
108 StationID = (rand() * rand() % 999999999);
109 out << StationID;
110 sID = out.str();
111 sqlquery = "INSERT INTO `account` (username, password, station_id, gm, banned, email, joindate, lastlogin, active) VALUES ('" + username + "', '" + password + "', '" + sID + "', '0', '0', 'ChangeMe@email.com', NOW(), NOW(), '1')";
112 mysql_query(conn, sqlquery.c_str());
113 EndSQL:
114 sqlquery = "";
115 mysql_free_result(pResult);
116 mysql_close(conn);
117
118 return true;
119 }
Line 77 in red is my proplem and i dont no why!!
|