static void Redraw (void)
{
char sdev[64];
Video_DrawBackgroud (1);
*sdev = '\0';
if (!config.subpath[0])
{
strcpy (sdev, "");
if ((config.appDev == 0 || config.appDev == 1) && devices_Get(DEV_SD))
{
strcat (sdev, "[");
strcat (sdev, devices_Get(DEV_SD));
strcat (sdev, "] ");
}
if ((config.appDev == 0 || config.appDev == 2) && devices_Get(DEV_USB))
{
strcat (sdev, "[");
strcat (sdev, devices_Get(DEV_USB));
strcat (sdev, "] ");
}
if (strlen (sdev) == 0)
{
strcpy (sdev, "Invalid dev !!!");
}
}
else
{
sprintf (sdev, "%s://apps/%s", config.submount, config.subpath);
}
Video_SetFont(TTFNORM);
int w1 = grlib_printf ( 25, 26, GRLIB_ALIGNLEFT, 0, "postLoader::HomeBrews - %s", sdev);
int w2 = grlib_printf ( 615, 26, GRLIB_ALIGNRIGHT, 0, "Page %d of %d", page+1, pageMax+1);
w1 = w1 + 25;
w2 = 615 - w2;
Video_SetFont(TTFVERYSMALL);
grlib_printf ( w1 + (w2 - w1) / 2, 27, GRLIB_ALIGNCENTER, 0, GetFilterString((w2 - w1) - 30), sdev);
if (redrawIcons) RedrawIcons (0,0);
Video_DrawVersionInfo ();
if (!redrawSkipInfo) DrawInfo ();
}
long CStaffTable::Find(tTableMap& data, const tDATA& filter)
{
long res = UDF_E_FAIL;
do
{
std::string szQuery;
std::string szFilter;
sql::ResultSet* qRes = NULL;
if(! m_pConnection)
{
res = UDF_E_NOCONNECTION;
break;
}
szFilter = GetFilterString(filter);
szQuery = GetQuery(TABLE, szFilter);
qRes = m_pConnection->ExecuteQuery(szQuery);
if(!qRes)
{
res = UDF_E_EXECUTE_QUERY_FAILED;
break;
}
data.clear();
while( qRes && qRes->next())
{
tDATA el = {0};
el.id = qRes->getUInt("id");
el.roleId = qRes->getUInt("role_id");
el.name = qRes->getString("name");
el.login = qRes->getString("login");
el.pass = qRes->getString("pass");
data.insert(make_pair(el.id, el));
}
res = UDF_OK;
}while(0);
return res;
}
long CChampionshipToursTable::Find(tTableMap& data, const tDATA& filter)
{
long res = UDF_E_FAIL;
do
{
std::string szQuery;
std::string szFilter;
sql::ResultSet* qRes = NULL;
if(! m_pConnection)
{
res = UDF_E_NOCONNECTION;
break;
}
szFilter = GetFilterString(filter);
szQuery = GetQuery(TABLE, szFilter);
qRes = m_pConnection->ExecuteQuery(szQuery);
if(!qRes)
{
res = UDF_E_EXECUTE_QUERY_FAILED;
break;
}
data.clear();
while( qRes && qRes->next())
{
tDATA el = {0};
el.id = qRes->getUInt(1);
el.csCatId = qRes->getUInt(2);
el.typeId = qRes->getUInt(3);
el.limit = qRes->getInt(4);
data.insert(make_pair(el.id, el));
}
res = UDF_OK;
}while(0);
return res;
}
