25.03.2010, 11:26
Подскажите, правильно ли я делаю запросы?
Код:
//--------------------------------------------------------------------------------------------- stock gs_IsUserRegistered(nick[]) { new query[256],result[256],rr; if(mysql_connect(MySQL_HOST,MySQL_USER,MySQL_DATABASE,MySQL_PASS)) { format(query,sizeof(query), "SELECT * FROM \"Users\" WHERE `Username` = '%s'",nick); mysql_query(query); mysql_store_result(); if(!mysql_fetch_row(result)) { rr = 0; }else { rr = 1; } }else{ printf("Function gs_IsUserRegistered(%s) can't be called. Reason: Connection Problem",nick); rr = 2; } return rr; } //--------------------------------------------------------------------------------------------- stock gs_RegisterNewUser(nick[],password[]) { new query[256],rr; if(mysql_connect(MySQL_HOST,MySQL_USER,MySQL_DATABASE,MySQL_PASS)) { format(query,sizeof(query), "INSERT INTO \"Users\" (Username, Password) VALUES ('%s', '%s')", nick,password); mysql_query(query); rr = 1; }else{ printf("Function RegisterNewUser(%s,%s) can't be called. Reason: Connection Problem",nick,password); rr = 2; } return rr; } //--------------------------------------------------------------------------------------------- stock gs_CheckNickNamePassword(nick[],password[]) { new query[256],result[256],rr; if(mysql_connect(MySQL_HOST,MySQL_USER,MySQL_DATABASE,MySQL_PASS)) { format(query,sizeof(query), "SELECT * FROM \"Users\" WHERE `Username` = '%s' AND `Password` = '%s'",nick,password); mysql_query(query); mysql_store_result(); if(mysql_fetch_row(result)) { rr = 1; } else { rr = 0; } }else{ printf("Function gs_CheckNickNamePassword(%s,%s) can't be called. Reason: Connection Problem",nick,password); rr = 2; } return rr; } //---------------------------------------------------------------------------------------------