//

//	Generated by lua

//	2009-2011	(C) Simplay Inc. Reserved

//

//

#include "stdafx.h"

#include "DBMessageHandlerItem.h"

#include "Message/DBMessageItem.h"







//

//	Dabase Message Handler for LoadItems//



DBMessageHandlerLoadItems::DBMessageHandlerLoadItems( void )

{

}



DBMessageHandlerLoadItems::~DBMessageHandlerLoadItems( void )

{

}



bool DBMessageHandlerLoadItems::handleMsg( IMsg * message )

{

	MsgLoadItems* msg = dynamic_cast< MsgLoadItems * >( message );

	Assert( msg && message );



	SQL_QUERY( "call load_items(%d)", msg->pid );



	if ( sqlResult >= 0 )

	{

		while ( m_DBMysql.GetRow() )

		{

				DBItem 	o;

				m_DBMysql.GetField(o.iid, 0 );

				m_DBMysql.GetField(o.sid, 1 );

				m_DBMysql.GetField(o.endurance, 2 );

				m_DBMysql.GetField(o.count, 3 );

				m_DBMysql.GetField(o.pos, 4 );

				m_DBMysql.GetField(o.elvl, 5 );

				m_DBMysql.GetField(o.slotcnt, 6 );

				m_DBMysql.GetField(o.slot[0], 7 );

				m_DBMysql.GetField(o.slot[1], 8 );

				m_DBMysql.GetField(o.slot[2], 9 );

				m_DBMysql.GetField(o.datax, 10 );

				m_DBMysql.GetField(o.datay, 11 );

				m_DBMysql.GetField(o.dataz, 12 );

				msg->items.push_back(o);

		}

		msg->m_errcode = Msg::ecSuccess;

	}

	else

	{

		LOG_ERROR("Failed to handle db msg: MsgLoadItems , DBMessageHandlerLoadItems!");

		msg->m_errcode = Msg::ecFailed;

		return false;

	}



	return true;

}



//

//	Dabase Message Handler for CreateItem//



DBMessageHandlerCreateItem::DBMessageHandlerCreateItem( void )

{

}



DBMessageHandlerCreateItem::~DBMessageHandlerCreateItem( void )

{

}



bool DBMessageHandlerCreateItem::handleMsg( IMsg * message )

{

	MsgCreateItem* msg = dynamic_cast< MsgCreateItem * >( message );

	Assert( msg && message );



	SQL_QUERY( "call create_item(%d, %d, %d, %d, %d, %c, %c, %d, %d, %d, %d, %d, %d)", msg->pid, msg->item.iid, msg->item.sid, msg->item.endurance, msg->item.count, msg->item.pos, msg->item.elvl, msg->item.slotcnt, msg->item.slot[0], msg->item.slot[1], msg->item.slot[2], msg->item.datax, msg->item.datay, msg->item.dataz );



	if ( sqlResult >= 0 )

	{

		msg->m_errcode = Msg::ecSuccess;

	}

	else

	{

		LOG_ERROR("Failed to handle db msg: MsgCreateItem , DBMessageHandlerCreateItem!");

		msg->m_errcode = Msg::ecFailed;

		return false;

	}



	return true;

}



//

//	Dabase Message Handler for UpdateItem//



DBMessageHandlerUpdateItem::DBMessageHandlerUpdateItem( void )

{

}



DBMessageHandlerUpdateItem::~DBMessageHandlerUpdateItem( void )

{

}



bool DBMessageHandlerUpdateItem::handleMsg( IMsg * message )

{

	MsgUpdateItem* msg = dynamic_cast< MsgUpdateItem * >( message );

	Assert( msg && message );



	SQL_QUERY( "call update_item(%d, %d, %d, %d, %d, %c, %c, %d, %d, %d, %d, %d, %d)", msg->pid, msg->item.iid, msg->item.sid, msg->item.endurance, msg->item.count, msg->item.pos, msg->item.elvl, msg->item.slotcnt, msg->item.slot[0], msg->item.slot[1], msg->item.slot[2], msg->item.datax, msg->item.datay, msg->item.dataz );



	if ( sqlResult >= 0 )

	{

		msg->m_errcode = Msg::ecSuccess;

	}

	else

	{

		LOG_ERROR("Failed to handle db msg: MsgUpdateItem , DBMessageHandlerUpdateItem!");

		msg->m_errcode = Msg::ecFailed;

		return false;

	}



	return true;

}



//

//	Dabase Message Handler for RemoveItem//



DBMessageHandlerRemoveItem::DBMessageHandlerRemoveItem( void )

{

}



DBMessageHandlerRemoveItem::~DBMessageHandlerRemoveItem( void )

{

}



bool DBMessageHandlerRemoveItem::handleMsg( IMsg * message )

{

	MsgRemoveItem* msg = dynamic_cast< MsgRemoveItem * >( message );

	Assert( msg && message );



	SQL_QUERY( "call remove_item(%d, %d)", msg->pid, msg->iid );



	if ( sqlResult >= 0 )

	{

		msg->m_errcode = Msg::ecSuccess;

	}

	else

	{

		LOG_ERROR("Failed to handle db msg: MsgRemoveItem , DBMessageHandlerRemoveItem!");

		msg->m_errcode = Msg::ecFailed;

		return false;

	}



	return true;

}