MySQL for TGE

22.2.3.65. mysql_shutdown()
int mysql_shutdown(MYSQL *mysql, enum mysql_enum_shutdown_level shutdown_level) 
Description 
Asks the database server to shut down. The connected user must have SHUTDOWN privileges. The shutdown_level argument was added in MySQL 5.0.1. MySQL 5.0 servers support only one type of shutdown; shutdown_level must be equal to SHUTDOWN_DEFAULT. Additional shutdown levels are planned to make it possible to choose the desired level. Dynamically linked executables which have been compiled with older versions of the libmysqlclient headers and call mysql_shutdown() need to be used with the old libmysqlclient dynamic library.

If mysql_init() allocates a new object, it is freed when mysql_close() is called to close the connection.

int MySQL::doquery(const char *fmt, ...)
{
    va_list ap;
    va_start(ap, fmt);
	bool ret = qquery(fmt, ap);
	va_end(ap);
	return ret;
}

#define MAXQUERYSIZE 12288
int MySQL::qquery(const char *fmt, va_list ap)
{
	if (!m_bConnected)
		return false;
	char buf[MAXQUERYSIZE];
	memset(buf, 0, MAXQUERYSIZE);

    char *top = (char*)fmt + dStrlen(fmt);
    register char *ptr = buf;
    const char *str;

	// Will we overflow?
	if (dStrlen(fmt) >= MAXQUERYSIZE) 
	{
		Con::printf("MySQL: Would overflow on query: %s", fmt);
		return -1;
	}

	int i = 0;
    for ( ; fmt < top; fmt++) 
	{
		i++;
		if (*fmt == '%' && *(fmt+1)) 
		{
			switch (*(++fmt)) 
			{
			case '?': 
				str = va_arg(ap, const char *);
				if (dStrlen(str)*2+1+i >= MAXQUERYSIZE)
				{
					// Worst case, we could overflow. GTFO now.
					Con::printf("MySQL: Could overflow on query: %s", fmt);
					return -1;
				}
				ptr += mysql_real_escape_string(&m_Instance, ptr, str, strlen(str));
				break;

			case 's':
				str = va_arg(ap, const char *);
				if (dStrlen(str)+i >= MAXQUERYSIZE)
				{
					Con::printf("MySQL: Would overflow on query: %s", fmt);
					return -1;
				}
				while (*str) *(ptr++) = *(str++);
				break;

			case '%':
				*(ptr++) = '%';
				break;

			default:
				*(ptr++) = '%';
				*(ptr++) = *fmt;
				break;
			}
		} 
		else
			*(ptr++) = *fmt;
	}

	*ptr = '[[4fc75d0705172]]';

	if (mysql_real_query(&m_Instance, buf, ptr - buf)) 
	{
		Con::printf("MySQL: Failed on query: %s", buf);
		return (-1);
	}

	return (ptr - buf);
}

MySQL.doquery("INSERT INTO accounts VALUES(name, password, age) ('%?', '%?', %?);", name, password, dItoa(age));

void MySQL::FreeResult (MYSQL_RES* _pResult)
{


	ResultEntry* pCurrent= &m_Results;
	ResultEntry* pPrevious = 0;
	while (pCurrent)
	{
		if (pCurrent->m_pResult== _pResult)
		{
			mysql_free_result (pCurrent->m_pResult);

			if (pCurrent->m_pNext)
			{
				pPrevious->m_pNext = pCurrent->m_pNext;
			}
			else
			{
				pPrevious->m_pNext = 0;
			}
			delete pCurrent;
			return;
		}
		pPrevious = pCurrent;
		pCurrent = pCurrent->m_pNext;
	}		
}