All pastes #2062780 Raw Edit

Stuff

public text v1 · immutable
#2062780 ·published 2011-05-17 19:20 UTC
rendered paste body
Kompex::SQLiteDatabase *db;
Kompex::SQLiteStatement *Stmt

void Database::Init()
{
	FILE* CheckIfDatabaseExists = fopen ("SSGM_HRE.db" , "r");
	if (CheckIfDatabaseExists == NULL) { //shit doesn't exist yet, create our tables
		db = new Kompex::SQLiteDatabase("SSGM_HRE.db", SQLITE_OPEN_CREATE, 0);
		Stmt = new Kompex::SQLiteStatement(db);
		Stmt->SqlStatement("CREATE TABLE Players(Uid INTERGER PRIMARY KEY, ID INTERGER, Nick char(32), JOINMSG char(256)");
		Stmt->SqlStatement("CREATE TABLE Bans(UID INTERGER PRIMARY KEY, Nick TEXT, WhoBy TEXT, Reason TEXT, Time INTERGER");
	}
	else{
		Kompex::SQLiteDatabase *db = new Kompex::SQLiteDatabase("SSGM_HRE.db", SQLITE_OPEN_READWRITE, 0);
		Stmt = new Kompex::SQLiteStatement(db);
	}
	fclose(CheckIfDatabaseExists);
}

void Database::Shutdown()
{
	delete db;
	delete Stmt;
}