void CInnoDBStatus::refresh()
{
clear();
CMySQLQuery *qry = new CMySQLQuery(mysql->mysql());
qry->setEmitMessages(false);
qry->setEmitErrors(false);
if (qry->exec("SHOW INNODB STATUS"))
{
qry->next();
setText(qry->row(0));
}
delete qry;
}
bool CUserAdminItem::displayUsers()
{
#ifdef DEBUG
qDebug("CUserAdminItem::displayUsers()");
#endif
//TODO: This needs to be modified to NOT use mysql.user for the users list. SHOW GRANTS FOR % is needed in the server.
while (this->childCount() > 0)
deleteChilds();
bool hasAccess = false;
CMySQLQuery *q = new CMySQLQuery(mysql()->mysql());
q->setEmitMessages(false);
q->setEmitErrors(false);
if (q->exec("SELECT User, Host FROM mysql.user ORDER BY User"))
{
hasAccess = true;
while (q->next())
new CUserItem(this, mysql(), q->row(0), q->row(1), userIcon);
}
delete q;
return hasAccess;
}