iamgsi

-(void) readAnimalsFromDatabase {

// Setup the database object

sqlite3 *database;

// Init the animals Array

// animals = [[NSMutableArray alloc] init];

// Open the database from the users filessytem

if(sqlite3_open([[self dataFilePath] UTF8String], &database) == SQLITE_OK) {

// Setup the SQL Statement and compile it for faster access

NSString* sqlStatement = [NSString stringWithFormat:@"select * from s1"];

sqlite3_stmt *compiledStatement;

if(sqlite3_prepare_v2(database, [sqlStatement UTF8String], -1, &compiledStatement, NULL) == SQLITE_OK) {

// Loop through the results and add them to the feeds array

while(sqlite3_step(compiledStatement) == SQLITE_ROW) {

int idx = sqlite3_column_int( compiledStatement, 0 );

int level = sqlite3_column_int( compiledStatement, 1 );

int c1 = sqlite3_column_int( compiledStatement, 2 );

int c2 = sqlite3_column_int( compiledStatement, 3 );

int c3 = sqlite3_column_int( compiledStatement, 4 );

// Create a new animal object with the data from the database

// Animal *animal = [[Animal alloc] initWithName:aName description:aDescription url:aImageUrl];

// Add the animal object to the animals Array

// [animals addObject:animal];

// [animal release];

}

}

else

{

NSString* msg = [[NSString alloc] initWithFormat:@"%s", sqlite3_errmsg( database )];

NSLog( @"Failed to open database with message '%s'.", sqlite3_errmsg( database ) );

}

// Release the compiled statement from memory

sqlite3_finalize(compiledStatement);

}

sqlite3_close(database);

}

** 연동 방법에 대해서는 따로 적지를 않았습니다.

#import <Foundation/Foundation.h>

#import "Texture2D.h"

@interface Texture2D (SpriteAnimation)

- (void) drawAtPointTest:(CGPoint)point;

@end

#import "Texture2DEx.h"

@implementation Texture2D (SpriteAnimation)

- (void) drawAtPointTest:(CGPoint)point 

{

_maxS = 63.0 / 256.0;  // test

GLfloat coordinates[] = { 0, _maxT,

_maxS, _maxT,

0, 0,

_maxS, 0 };

GLfloat width = (GLfloat)_width * _maxS,

height = (GLfloat)_height * _maxT;

width = 63.0; // test

GLfloat vertices[] = { -width / 2 + point.x, -height / 2 + point.y, 0.0,

width / 2 + point.x, -height / 2 + point.y, 0.0,

-width / 2 + point.x, height / 2 + point.y, 0.0,

width / 2 + point.x, height / 2 + point.y, 0.0 };

glBindTexture(GL_TEXTURE_2D, _name);

glVertexPointer(3, GL_FLOAT, 0, vertices);

glTexCoordPointer(2, GL_FLOAT, 0, coordinates);

glDrawArrays(GL_TRIANGLE_STRIP, 0, 4);

}

@end