All pastes #675643 Raw Edit

sa-mp sqlite

public text v1 · immutable
#675643 ·published 2007-08-30 10:56 UTC
rendered paste body
public OnGameModeInit()
{
	SetGameModeText("Blank Script");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
	new dbname[56] = "RaceTimes.db";
	new DB:db = db_open(dbname);
	new query[256];
	format (query, 256, "SELECT finishtime, racername FROM tracktimes, racertbl, tracktbl WHERE tracktimes.racerid=racertbl.racerid AND tracktimes.trackid=tracktbl.trackid AND trackname='%s'","MSR");
	new DBResult:dbresult = db_query(db,query);
	new num = db_num_rows(dbresult);
	new field, result[256], result2[256];

	//db_get_field_assoc(dbresult, field, result, 256);
	for(new i;i<num;i++)
	{
		field=0;
		db_get_field(dbresult, field, result, 256);
		field++;
		db_get_field(dbresult, field, result2, 256);
		db_next_row(dbresult);
		printf("RESULT: %s : %s",result, result2);
	}
	db_close(db);
	return 1;
}