Advertisement
Guest User

Untitled

a guest
Jan 14th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.68 KB | None | 0 0
  1. sql::Driver *sqlDriver = get_driver_instance( );
  2. sql::Connection *sqlConnection = sqlDriver->connect( "bameware.club:3306", "root", "}cK2RsRFVv+9RQZC" );
  3. sql::Statement *sqlStatement = sqlConnection->createStatement( );
  4. sql::ResultSet *sqlResultSet { };
  5. user_t usrUser;
  6.  
  7. std::string strEnteredUsername { };
  8. std::string strEnteredPassword { };
  9. bool bException { };
  10.  
  11. std::cout << "Enter your username" << std::endl;
  12. std::cin >> strEnteredUsername;
  13. std::cout << "Enter your password" << std::endl;
  14. std::cin >> strEnteredPassword;
  15.  
  16. std::string strCommandBuffer = "SELECT * FROM loader_users WHERE username = '" + strEnteredUsername + "' AND password = '" + strEnteredPassword + "'";
  17. sql::SQLString strCommand = strCommandBuffer.c_str( );
  18.  
  19. sqlStatement->execute( "USE mysql" );
  20. try
  21. {
  22. sqlResultSet = sqlStatement->executeQuery( strCommand );
  23. sqlResultSet->next( );
  24.  
  25. usrUser.strUserName = sqlResultSet->getString( 1 ).c_str( );
  26. usrUser.strPassword = sqlResultSet->getString( 2 ).c_str( );
  27. usrUser.strHWID = sqlResultSet->getString( 3 ).c_str( );
  28. usrUser.bBanned = sqlResultSet->getInt( 4 );
  29.  
  30. std::cout << "\n\nUsername: " << usrUser.strUserName << std::endl;
  31. std::cout << "Password: " << usrUser.strPassword << std::endl;
  32. std::cout << "HWID: " << usrUser.strHWID << std::endl;
  33. std::cout << "Banned: " << usrUser.bBanned << std::endl;
  34.  
  35. } catch ( sql::SQLException &e ) {
  36. std::cout << "Invalid username or password" << std::endl;
  37. bException = true;
  38. }
  39.  
  40. if( usrUser.bBanned && !bException ) {
  41. std::cout << "You are banned!" << std::endl;
  42. }
  43.  
  44. delete sqlConnection;
  45. delete sqlStatement;
  46. delete sqlResultSet;
  47.  
  48. system( "pause" );
  49. return 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement