The apparatus thread

[[]KAOS[]Casey]

Post your apparatuses here.

ap·pa·rat·us/ˌapəˈratəs/
Noun:

1)The equipment needed for a particular activity or purpose.
2)The organs used to perform a particular bodily function.

[redeye]

http://www.google.com/imgres?q=picture+ ... LBA&zoom=1

[[]KAOS[]Casey]

I'm in my thread, posting an apparatus. I fucking love apparatuses, you guys should too

edit: moar info here http://www.oldunreal.com/cgi-bin/yabb2/ ... 117720/0#0

Code: Select all

//============================================================================
// Holy shitballs! it's a SQLite Class for unreal!!!!!!!!
// Do you love local databases? I FUCKING DO, NO SQL INSTALLATION REQUIRED
// v1.0 by []KAOS[]Casey using a wrapper I had to fix called easySQLite
// fuck google code
//==============================================================================
class USQLiteDB extends Object
native;

var native const editconst int InternalTableList;//If you touch these I hope you like crashes.
var native const editconst int InternalRecordList;
var native const editconst int InternalDB;
var native const editconst int InternalDBName; //yeah thats right,4 different ways to cause crashes. Don't be a dumbass.


native final function SetupDatabase(string Filename);//filename eg test.db
native final function CloseDatabase();//cleanup!


//sqlite3 syntax   : CREATE TABLE person (_ID INTEGER PRIMARY KEY, fname TEXT NOT NULL, lname TEXT NOT NULL, birthdate INTEGER)
//USQLiteDB syntax : AddTable("person","_ID INTEGER PRIMARY KEY, fname TEXT NOT NULL, lname TEXT NOT NULL, birthdate INTEGER");
native final function AddTable(String TableName, String TableDefinition);
native final function RemoveTable(String TableName);


native final function bool PushRecord(String Table);//Adds one new record.

native final function PullRecord(String Table,optional string WhereCondition);
//PullRecord("person"); would grab the all entries from the person table
//PullRecord("person","_ID >= 10 and _ID <= 15"); would grab entries 10-15.

native final function UpdateRecord(String Table, optional string WhereCondition);
//UpdateRecord("person","_ID = 1") would update only primary key ID of 1
//UpdateRecord("person") would update all records

//SetStringToRecord("person","fname","John");
//SetStringToRecord("person","lname","Smith"); //would set Record to first name of John, last name of Smith

native final function bool SetNullToRecord(string Table, string FieldName); //don't ask. I just put it here. fuck you.
native final function bool SetStringToRecord(string Table, string FieldName,  string Value);
native final function bool SetIntegerToRecord(string Table, string FieldName, int Value);
native final function bool SetFloatToRecord(string Table, string FieldName,   float Value);
native final function bool SetBoolToRecord(string Table, string FieldName,    bool Value);
native final function bool SetTimeToRecord(string Table, string FieldName,    int Value);//time since 1970


native final function int GetNumRecords(String Table); //returns num records from query used by PullRecord/UpdateRecord
native final function int GetSQLTime(); //returns time since 1970.. unix time is weird. really weird.


native final function string    GetStringFromRecord(string Table, int RecordNum, string FieldName);
native final function int       GetIntegerFromRecord(string Table, int RecordNum, string FieldName);
native final function float    GetFloatFromRecord(string Table, int RecordNum, string FieldName);
native final function bool       GetBoolFromRecord(string Table, int RecordNum, string FieldName);
native final function int       GetTimeFromRecord(string Table, int RecordNum, string FieldName);