问highscore仅在启动sqlite时刷新
EN

Stack Overflow用户

提问于 2014-04-28 08:51:12

回答 1查看 53关注 0票数 0

我有一个用SQLite实现的c++射手的高分系统，但它只有在我重新启动游戏时才会刷新，我想这是因为它只在游戏发布时从最大到最小重新排序。我不知道这是为什么，它似乎确实像它应该记录的所有游戏分数，但我认为它只在发布时订购。我如何才能让它在打印到屏幕之前重新排序。以下是代码

在main.cpp中

case eHIGH_SCORES：

    DrawString( "HIGHSCORES", iScreenWidth * 0.38, iScreenHeight * 0.95);
    DrawString( "PRESS C TO CLOSE", iScreenWidth * 0.32, iScreenHeight * 0.1);

    DatabaseMaker DatabaseMaker("MyDatabase.db");
    DatabaseMaker.CreateDatabase();
    DatabaseMaker.CreateTable("HIGHSCOREST");
    if (scorer<1)
    {
    DatabaseMaker.InsertRecordIntoTable("HIGHSCOREST",scoreArray);
    scorer++;
    for (int i=0; i<10; i++)
    {
        scoreArray[i]=0;
    }
    }
    DatabaseMaker.RetrieveRecordsFromTable("HIGHSCOREST");
    DatabaseMaker.databaseprinter();

然后在Database maker类中，我有

    DatabaseMaker::DatabaseMaker(std::string HighScoresT)
    {
        this->HighScores = HighScoresT;
        myDatabase = NULL;  
     }


    int DatabaseMaker::Callback(void* notUsed, int numRows, char **data, char **columnName)
    {
        for(int i = 0; i < numRows; i++)
        {
            std::cout << columnName[i] << ": " << data[i] << std::endl;
            holder.push_back(atoi(data[i]));

         } 

    return 0;
}



void DatabaseMaker::databaseprinter()
{

        for (int i = 0; i < 10; i++)
    {
        itoa(holder[i], displayHolder, 10);
        DrawString(displayHolder,   780/2,  700-(50*i));
    }

}

void DatabaseMaker::CreateDatabase()
{
    int errorCode = sqlite3_open(HighScores.c_str(), &myDatabase); 

    if(errorCode == SQLITE_OK)
    {
        std::cout << "Database opened successfully." << std::endl;
    }
    else
    {
        std::cout << "An error has occured." << std::endl;
    }
}

void DatabaseMaker::CreateTable(std::string  HIGHSCOREST)
{

    char* errorMsg = NULL;
    std::string sqlStatement;  

    sqlStatement =  "CREATE TABLE HIGHSCOREST(" \
        "ID  INT," \
        "SCORE    INT);";

    sqlite3_exec(myDatabase, sqlStatement.c_str(), Callback, 0, &errorMsg);

    if(errorMsg != NULL)
    {
        std::cout << "Error message: " << errorMsg << std::endl;
    }
}



void DatabaseMaker::InsertRecordIntoTable(std::string HIGHSCOREST,int (&scoreArray)[10] )
{
    char*errorMsg = NULL;
    std::string sqlStatement;
    int x=5;


    for(int i=0;i<10;i++)
    {
        std::string scorestring;

        scorestring = std::to_string(scoreArray[i]);

        sqlStatement =  "INSERT INTO HIGHSCOREST (ID,SCORE)" \
            "VALUES (1,"+scorestring+");";

        sqlite3_exec(myDatabase, sqlStatement.c_str(), Callback, 0, &errorMsg);

        if(errorMsg != NULL)
        {
            std::cout << "Error message: " << errorMsg << std::endl;
        }
    }

}

void DatabaseMaker::RetrieveRecordsFromTable(std::string HIGHSCOREST)
{

    char* errorMsg = NULL;
    std::string sqlStatement;

    sqlStatement =  "SELECT SCORE from HIGHSCOREST order by SCORE desc;";

    sqlite3_exec(myDatabase, sqlStatement.c_str(), Callback, 0, &errorMsg);

    if(errorMsg != NULL)
    {
        std::cout << "Error message: " << errorMsg << std::endl;
    }

    sqlite3_close(myDatabase); 


}


DatabaseMaker::~DatabaseMaker()
{
}