string CLanguage :: HasPlayedDotAGamesWithThisBot( string user, string totalgames, string totalwins, string totallosses, string totalkills, string totaldeaths, string totalcreepkills, string totalcreepdenies, string totalassists, string totalneutralkills, string totaltowerkills, string totalraxkills, string totalcourierkills, string avgkills, string avgdeaths, string avgcreepkills, string avgcreepdenies, string avgassists, string avgneutralkills, string avgtowerkills, string avgraxkills, string avgcourierkills )
{
string Out = m_CFG->GetString( "lang_0074", "lang_0074" );
UTIL_Replace( Out, "$USER$", user );
UTIL_Replace( Out, "$TOTALGAMES$", totalgames );
UTIL_Replace( Out, "$TOTALWINS$", totalwins );
UTIL_Replace( Out, "$TOTALLOSSES$", totallosses );
UTIL_Replace( Out, "$TOTALKILLS$", totalkills );
UTIL_Replace( Out, "$TOTALDEATHS$", totaldeaths );
UTIL_Replace( Out, "$TOTALCREEPKILLS$", totalcreepkills );
UTIL_Replace( Out, "$TOTALCREEPDENIES$", totalcreepdenies );
UTIL_Replace( Out, "$TOTALASSISTS$", totalassists );
UTIL_Replace( Out, "$TOTALNEUTRALKILLS$", totalneutralkills );
UTIL_Replace( Out, "$TOTALTOWERKILLS$", totaltowerkills );
UTIL_Replace( Out, "$TOTALRAXKILLS$", totalraxkills );
UTIL_Replace( Out, "$TOTALCOURIERKILLS$", totalcourierkills );
UTIL_Replace( Out, "$AVGKILLS$", avgkills );
UTIL_Replace( Out, "$AVGDEATHS$", avgdeaths );
UTIL_Replace( Out, "$AVGCREEPKILLS$", avgcreepkills );
UTIL_Replace( Out, "$AVGCREEPDENIES$", avgcreepdenies );
UTIL_Replace( Out, "$AVGASSISTS$", avgassists );
UTIL_Replace( Out, "$AVGNEUTRALKILLS$", avgneutralkills );
UTIL_Replace( Out, "$AVGTOWERKILLS$", avgtowerkills );
UTIL_Replace( Out, "$AVGRAXKILLS$", avgraxkills );
UTIL_Replace( Out, "$AVGCOURIERKILLS$", avgcourierkills );
UTIL_Replace( Out, "$TOTALWINPERCENT$", UTIL_ToString( (UTIL_ToDouble(totalwins) / UTIL_ToDouble(totalgames) * 100), 0) );
return Out;
}
double MySQLScoreCheck( void *conn, string *error, uint32_t botid, string category, string name, string server )
{
transform( name.begin( ), name.end( ), name.begin( ), (int(*)(int))tolower );
string EscCategory = MySQLEscapeString( conn, category );
string EscName = MySQLEscapeString( conn, name );
string EscServer = MySQLEscapeString( conn, server );
double Score = -100000.0;
string Query = "SELECT score FROM scores WHERE category='" + EscCategory + "' AND name='" + EscName + "' AND server='" + EscServer + "'";
if( mysql_real_query( (MYSQL *)conn, Query.c_str( ), Query.size( ) ) != 0 )
*error = mysql_error( (MYSQL *)conn );
else
{
MYSQL_RES *Result = mysql_store_result( (MYSQL *)conn );
if( Result )
{
vector<string> Row = MySQLFetchRow( Result );
if( Row.size( ) == 1 )
Score = UTIL_ToDouble( Row[0] );
/* else
*error = "error checking score [" + category + " : " + name + " : " + server + "] - row doesn't have 1 column"; */
mysql_free_result( Result );
}
else
*error = mysql_error( (MYSQL *)conn );
}
return Score;
}
