How to use the mysql connection in source code?

[Agility]

#include "../ShareLib/DBCmd.h"
   an example with getting ban reasons

bool HWID::BanReasons()
{
CLCString gQuery(1000);
gQuery.Format("SELECT a_reason FROM t_bans");

CDBCmd LCCmd;
LCCmd.Init(&gserver->m_dbdata);
LCCmd.SetQuery(gQuery);
if(!LCCmd.Open())
return false;

m_reason = new int[cmd.m_nrecords];

for(int i = 0; i < LCCmd.m_nrecords; i++)
{
switch(i)
{
case MEMORY_MODIFICATION: // a_reason = 0
m_reason[i] = 0;
case PACKET_SPAM: // a_reason = 1
m_reason[i] = 1;
case FILE_MODIFICATION: // a_reason = 2
m_reason[i] = 2;
}
}
return true;
}