/// <summary>
/// Checks if a provided email is valid
/// </summary>
/// <param name="stream">The stream that sended the data</param>
/// <param name="dict">The request that the stream sended</param>
private void IsEmailValid(TCPStream stream, Dictionary <string, string> dict)
{
if (!dict.ContainsKey("email"))
{
SendErrorAndFreeStream(stream, 1, "There was an error parsing an incoming request.");
return;
}
try
{
if (databaseDriver.Query("SELECT userid FROM users WHERE LOWER(email)=@P0", dict["email"].ToLowerInvariant()).Count != 0)
{
stream.SendAsync(@"\vr\1\final\");
}
else
{
stream.SendAsync(@"\vr\0\final\");
}
}
catch (Exception ex)
{
LogWriter.Log.WriteException(ex);
SendErrorAndFreeStream(stream, 4, "This request cannot be processed because of a database error.");
}
}
private void ReverseBuddies(TCPStream stream, Dictionary <string, string> dict)
{
// PrintReceivedDictToLogger("others", dict);
// SendErrorAndFreeStream(stream, 0, "This request is not supported yet.");
stream.SendAsync(@"\others\\odone\final\");
}
private void RetriveNicknames(TCPStream stream, Dictionary <string, string> dict)
{
string password = "";
bool sendUniqueNick = false;
if (!dict.ContainsKey("email"))
{
SendErrorAndFreeStream(stream, 1, "There was an error parsing an incoming request.");
return;
}
// First, we try to receive an encoded password
if (!dict.ContainsKey("passenc"))
{
// If the encoded password is not sended, we try receving the password in plain text
if (!dict.ContainsKey("pass"))
{
// No password is specified, we cannot continue
SendErrorAndFreeStream(stream, 1, "There was an error parsing an incoming request.");
return;
}
else
{
// Store the plain text password
password = dict["pass"];
}
}
else
{
// Store the decrypted password
password = GamespyUtils.DecodePassword(dict["passenc"]);
}
password = StringExtensions.GetMD5Hash(password);
sendUniqueNick = dict.ContainsKey("gamename");
List <Dictionary <string, object> > queryResult = null;
try
{
queryResult = databaseDriver.Query("SELECT profiles.nick, profiles.uniquenick FROM profiles INNER JOIN users ON profiles.userid=users.userid WHERE LOWER(users.email)=@P0 AND LOWER(users.password)=@P1", dict["email"].ToLowerInvariant(), password.ToLowerInvariant());
}
catch (Exception ex)
{
LogWriter.Log.Write(ex.Message, LogLevel.Error);
SendErrorAndFreeStream(stream, 4, "This request cannot be processed because of a database error.");
return;
}
if (queryResult.Count < 1)
{
stream.SendAsync(@"\nr\ndone\final\");
return;
}
// We will recycle the "password" variable by storing the response
// that we have to send to the stream. This is done for save memory space
// so we don't have to declare a new variable.
password = @"\nr\";
foreach (Dictionary <string, object> row in queryResult)
{
password += @"\nick\";
password += row["nick"];
if (sendUniqueNick)
{
password += @"\uniquenick\";
password += row["uniquenick"];
}
}
password += @"\ndone\final\";
stream.SendAsync(password);
/* Legacy C++ code to reimpliment
* bool PSServer::OnSendNicks(mdk_socket stream, const char *buf, int)
* {
* std::string email = "", pass = "", gamename = "", str = "";
* bool bSendUnique = false;
* size_t i = 0;
* CResultSet *result = NULL;
*
* // Get data from buffer
*
* if (!get_gs_data(buf, email, "email"))
* return false;
*
* if (get_gs_data(buf, pass, "passenc"))
* {
* // Uncrypt the password
* gs_pass_decode(pass);
* }
* else
* {
* if (!get_gs_data(buf, pass, "pass"))
* return false;
* }
*
* if (get_gs_data(buf, gamename, "gamename"))
* bSendUnique = true;
*
* // Create the query and execute it
* str = "SELECT profiles.nick, profiles.uniquenick FROM profiles INNER "
* "JOIN users ON profiles.userid=users.userid WHERE users.email='";
* if (!mdk_escape_query_string(m_lpDatabase, email))
* return false;
*
* str += email;
* str += "' AND password='******'";
*
* result = new CResultSet();
*
* if (!result->ExecuteQuery(m_lpDatabase, str))
* {
* delete result;
*
* WriteTCP(stream, "\\nr\\\\ndone\\final\\");
* return false;
* }
*
* if (!result->GotoFirstRow())
* {
* delete result;
*
* WriteTCP(stream, "\\nr\\\\ndone\\final\\");
* return false;
*
* }
*
* str = "\\nr\\" + std::to_string(result->GetTotalRows());
*
* // Get all the nicks and store them
* do
* {
* str += "\\nick\\";
* str += result->GetStringFromRow(0);
*
* if (bSendUnique)
* {
* str += "\\uniquenick\\";
* str += result->GetStringFromRow(1);
* }
* } while(result->GotoNextRow());
*
* str += "\\ndone\\final\\";
*
* // Send to the socket
* WriteTCP(stream, str);
*
* delete result;
*
* return true;
* }*/
}
/// <summary>
/// Send a presence error
/// </summary>
/// <param name="stream">The stream that will receive the error</param>
/// <param name="code">The error code</param>
/// <param name="error">A string containing the error</param>
public static void SendError(TCPStream stream, int code, string error)
{
stream.SendAsync(Encoding.UTF8.GetBytes(String.Format(@"\error\\err\{0}\fatal\\errmsg\{1}\id\1\final\", code, error)));
}
