-- Run SQL to char DB, use the lua script, see the printed result, report back
--[==[

CREATE TABLE `character_noterity_levels` (
 `id` INT(11) NOT NULL AUTO_INCREMENT,
 `guid` INT(10) NOT NULL DEFAULT '0',
 `name` VARCHAR(255) NOT NULL DEFAULT '',
 `race` INT(10) NULL DEFAULT NULL,
 `class` INT(10) NULL DEFAULT NULL,
 `level` INT(25) NULL DEFAULT '1',
 `xp` BIGINT(90) NULL DEFAULT '0',
 `gender` INT(10) NULL DEFAULT '1',
 `player` INT(25) NULL DEFAULT '0',
 PRIMARY KEY (`id`, `guid`, `name`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1424;

CREATE TABLE `noterity_level_xp` (
 `level` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `xp` BIGINT(255) NULL DEFAULT NULL,
 `bonus` INT(10) UNSIGNED NULL DEFAULT '0',
 PRIMARY KEY (`level`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=387;

INSERT INTO `character_noterity_levels` (`id`, `guid`, `name`, `race`, `class`, `level`, `xp`, `gender`, `player`) VALUES (1424, 123, 'test', 1, 1, 1, 2157, 1, 5);
INSERT INTO `noterity_level_xp` (`level`, `xp`, `bonus`) VALUES (1, 1000, 5);


]==]


local Q = CharDBQuery("select (b.xp >= a.xp) as ASD from noterity_level_xp a, character_noterity_levels b where b.name ='test' and a.level = b.level;")
if (Q) then
    print(Q:GetColumnCount())
    print(Q:GetRowCount())
    print()
    print(Q:GetBool(0))
    print(Q:GetUInt8(0))
    print(Q:GetUInt16(0))
    print(Q:GetUInt32(0))
    print(Q:GetUInt64(0))
    print(Q:GetInt8(0))
    print(Q:GetInt16(0))
    print(Q:GetInt32(0))
    print(Q:GetInt64(0))
    print(Q:GetFloat(0))
    print(Q:GetDouble(0))
    print(Q:GetString(0))
    print(Q:GetCString(0))
    print(Q:IsNull(0))
else
    print("Q_Q")
end