itemidregistry.cpp

天之炼狱1服务器端源文件游戏服务端不完整

//////////////////////////////////////////////////////////////////////////////
// Filename    : ItemIDRegistry.cpp
// Written by  : excel96
// Description :
// 阿 酒捞袍 备泅 颇老俊辑 initItemIDRegistry 糕滚 窃荐父阑 哗辑
// 备泅秦初篮 颇老捞促.
//////////////////////////////////////////////////////////////////////////////

#include "DB.h"
#include "ItemInfoManager.h"

#include "Motorcycle.h"
#include "Potion.h"
#include "Water.h"
#include "HolyWater.h"
#include "Magazine.h"
#include "BombMaterial.h"
#include "ETC.h"
#include "Key.h"
#include "Ring.h"
#include "Bracelet.h"
#include "Necklace.h"
#include "Coat.h"
#include "Trouser.h"
#include "Shoes.h"
#include "Sword.h"
#include "Blade.h"
#include "Shield.h"
#include "Cross.h"
#include "Mace.h"
#include "Glove.h"
#include "Helm.h"
#include "SG.h"
#include "SMG.h"
#include "AR.h"
#include "SR.h"
#include "Bomb.h"
#include "Mine.h"
#include "Belt.h"
#include "LearningItem.h"
#include "Money.h"
#include "VampireRing.h"
#include "VampireBracelet.h"
#include "VampireNecklace.h"
#include "VampireCoat.h"
#include "Skull.h"
#include "Serum.h"
#include "VampireETC.h"
#include "SlayerPortalItem.h"
#include "VampirePortalItem.h"
#include "EventGiftBox.h"
#include "EventStar.h"
#include "VampireEarring.h"
#include "Relic.h"
#include "VampireWeapon.h"
#include "VampireAmulet.h"
#include "QuestItem.h"
#include "EventTree.h"
#include "EventETC.h"
#include "BloodBible.h"
#include "CastleSymbol.h"
#include "CoupleRing.h"
#include "VampireCoupleRing.h"
#include "EventItem.h"
#include "DyePotion.h"
#include "ResurrectItem.h"
#include "MixingItem.h"
#include "OustersArmsband.h"
#include "OustersBoots.h"
#include "OustersChakram.h"
#include "OustersCirclet.h"
#include "OustersCoat.h"
#include "OustersPendent.h"
#include "OustersRing.h"
#include "OustersStone.h"
#include "OustersWristlet.h"
#include "Larva.h"
#include "Pupa.h"
#include "ComposMei.h"
#include "OustersSummonItem.h"
#include "EffectItem.h"
#include "CodeSheet.h"
#include "MoonCard.h"
#include "Sweeper.h"
#include "PetItem.h"
#include "PetFood.h"
#include "PetEnchantItem.h"
#include "LuckyBag.h"

void Motorcycle::initItemIDRegistry(void)
	throw()
{
	__BEGIN_TRY

	Statement* pStmt = NULL; 

	__ENTER_CRITICAL_SECTION(m_Mutex)

	BEGIN_DB
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
		Result* pCountResult = pStmt->executeQuery("SELECT COUNT(*) from MotorcycleObject");
		pCountResult->next();
		int count = pCountResult->getDWORD(1);
		SAFE_DELETE(pStmt);

		if (count != 0)
		{
			pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
			Result* pResult = pStmt->executeQuery("SELECT MAX(ItemID) FROM MotorcycleObject");
			pResult->next();
			m_ItemIDRegistry = pResult->getDWORD(1);
			SAFE_DELETE(pStmt);
		}

		m_ItemIDRegistry +=(g_pItemInfoManager->getItemIDSuccessor() - (m_ItemIDRegistry % g_pItemInfoManager->getItemIDSuccessor())) + g_pItemInfoManager->getItemIDBase();
	}
	END_DB(pStmt)

	__LEAVE_CRITICAL_SECTION(m_Mutex)

	cout << "Motorcycle...ItemIDRegistry:" << m_ItemIDRegistry << endl;

	__END_CATCH
}

void Potion::initItemIDRegistry(void)
	throw()
{
	__BEGIN_TRY

	Statement* pStmt = NULL; 

	__ENTER_CRITICAL_SECTION(m_Mutex)

	BEGIN_DB
	{
		//pStmt = g_pDatabaseManager->getConnection("DIST_DARKEDEN")->createStatement();
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
		Result* pCountResult = pStmt->executeQuery("SELECT COUNT(*) from PotionObject");
		pCountResult->next();
		int count = pCountResult->getDWORD(1);
		SAFE_DELETE(pStmt);

		if (count != 0)
		{
			//pStmt = g_pDatabaseManager->getConnection("DIST_DARKEDEN")->createStatement();
			pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
			Result* pResult = pStmt->executeQuery("SELECT MAX(ItemID) FROM PotionObject");
			pResult->next();
			m_ItemIDRegistry = pResult->getDWORD(1);
			SAFE_DELETE(pStmt);
		}

		m_ItemIDRegistry +=(g_pItemInfoManager->getItemIDSuccessor() - (m_ItemIDRegistry % g_pItemInfoManager->getItemIDSuccessor())) + g_pItemInfoManager->getItemIDBase();
	}
	END_DB(pStmt)

	__LEAVE_CRITICAL_SECTION(m_Mutex)

	cout << "Potion...ItemIDRegistry:" << m_ItemIDRegistry << endl;

	__END_CATCH
}

void Water::initItemIDRegistry(void)
	throw()
{
	__BEGIN_TRY

	Statement* pStmt = NULL; 

	__ENTER_CRITICAL_SECTION(m_Mutex)

	BEGIN_DB
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
		Result* pCountResult = pStmt->executeQuery("SELECT COUNT(*) from WaterObject");
		pCountResult->next();
		int count = pCountResult->getDWORD(1);
		SAFE_DELETE(pStmt);

		if (count != 0)
		{
			pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
			Result* pResult = pStmt->executeQuery("SELECT MAX(ItemID) FROM WaterObject");
			pResult->next();
			m_ItemIDRegistry = pResult->getDWORD(1);
			SAFE_DELETE(pStmt);
		}

		m_ItemIDRegistry +=(g_pItemInfoManager->getItemIDSuccessor() - (m_ItemIDRegistry % g_pItemInfoManager->getItemIDSuccessor())) + g_pItemInfoManager->getItemIDBase();
	}
	END_DB(pStmt)

	__LEAVE_CRITICAL_SECTION(m_Mutex)

	cout << "Water...ItemIDRegistry:" << m_ItemIDRegistry << endl;

	__END_CATCH
}

void HolyWater::initItemIDRegistry(void)
	throw()
{
	__BEGIN_TRY

	Statement* pStmt = NULL; 

	__ENTER_CRITICAL_SECTION(m_Mutex)

	BEGIN_DB
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
		Result* pCountResult = pStmt->executeQuery("SELECT COUNT(*) from HolyWaterObject");
		pCountResult->next();
		int count = pCountResult->getDWORD(1);
		SAFE_DELETE(pStmt);

		if (count != 0)
		{
			pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
			Result* pResult = pStmt->executeQuery("SELECT MAX(ItemID) FROM HolyWaterObject");
			pResult->next();
			m_ItemIDRegistry = pResult->getDWORD(1);
			SAFE_DELETE(pStmt);
		}

		m_ItemIDRegistry +=(g_pItemInfoManager->getItemIDSuccessor() - (m_ItemIDRegistry % g_pItemInfoManager->getItemIDSuccessor())) + g_pItemInfoManager->getItemIDBase();
	}
	END_DB(pStmt)

	__LEAVE_CRITICAL_SECTION(m_Mutex)

	cout << "HolyWater...ItemIDRegistry:" << m_ItemIDRegistry << endl;

	__END_CATCH
}

void Magazine::initItemIDRegistry(void)
	throw()
{
	__BEGIN_TRY

	Statement* pStmt = NULL; 

	__ENTER_CRITICAL_SECTION(m_Mutex)

	BEGIN_DB
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
		Result* pCountResult = pStmt->executeQuery("SELECT COUNT(*) from MagazineObject");
		pCountResult->next();
		int count = pCountResult->getDWORD(1);
		SAFE_DELETE(pStmt);

		if (count != 0)
		{
			pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
			Result* pResult = pStmt->executeQuery("SELECT MAX(ItemID) FROM MagazineObject");
			pResult->next();
			m_ItemIDRegistry = pResult->getDWORD(1);
			SAFE_DELETE(pStmt);
		}

		m_ItemIDRegistry +=(g_pItemInfoManager->getItemIDSuccessor() - (m_ItemIDRegistry % g_pItemInfoManager->getItemIDSuccessor())) + g_pItemInfoManager->getItemIDBase();
	}
	END_DB(pStmt)

	__LEAVE_CRITICAL_SECTION(m_Mutex)

	cout << "Magazine...ItemIDRegistry:" << m_ItemIDRegistry << endl;

	__END_CATCH
}

void BombMaterial::initItemIDRegistry(void)
	throw()
{
	__BEGIN_TRY

	Statement* pStmt = NULL; 

	__ENTER_CRITICAL_SECTION(m_Mutex)

	BEGIN_DB
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
		Result* pCountResult = pStmt->executeQuery("SELECT COUNT(*) from BombMaterialObject");
		pCountResult->next();
		int count = pCountResult->getDWORD(1);
		SAFE_DELETE(pStmt);

		if (count != 0)
		{
			pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
			Result* pResult = pStmt->executeQuery("SELECT MAX(ItemID) FROM BombMaterialObject");
			pResult->next();
			m_ItemIDRegistry = pResult->getDWORD(1);
			SAFE_DELETE(pStmt);
		}

		m_ItemIDRegistry +=(g_pItemInfoManager->getItemIDSuccessor() - (m_ItemIDRegistry % g_pItemInfoManager->getItemIDSuccessor())) + g_pItemInfoManager->getItemIDBase();
	}
	END_DB(pStmt)

	__LEAVE_CRITICAL_SECTION(m_Mutex)

	cout << "BombMaterial...ItemIDRegistry:" << m_ItemIDRegistry << endl;

	__END_CATCH
}

void ETC::initItemIDRegistry(void)
	throw()
{
	__BEGIN_TRY

	Statement* pStmt = NULL; 

	__ENTER_CRITICAL_SECTION(m_Mutex)

	BEGIN_DB
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
		Result* pCountResult = pStmt->executeQuery("SELECT COUNT(*) from ETCObject");
		pCountResult->next();
		int count = pCountResult->getDWORD(1);
		SAFE_DELETE(pStmt);

		if (count != 0)
		{
			pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
			Result* pResult = pStmt->executeQuery("SELECT MAX(ItemID) FROM ETCObject");
			pResult->next();
			m_ItemIDRegistry = pResult->getDWORD(1);
			SAFE_DELETE(pStmt);
		}

		m_ItemIDRegistry +=(g_pItemInfoManager->getItemIDSuccessor() - (m_ItemIDRegistry % g_pItemInfoManager->getItemIDSuccessor())) + g_pItemInfoManager->getItemIDBase();
	}
	END_DB(pStmt)

	__LEAVE_CRITICAL_SECTION(m_Mutex)

	cout << "ETC...ItemIDRegistry:" << m_ItemIDRegistry << endl;

	__END_CATCH
}

void Key::initItemIDRegistry(void)
	throw()
{
	__BEGIN_TRY

	Statement* pStmt = NULL; 

	__ENTER_CRITICAL_SECTION(m_Mutex)

	BEGIN_DB
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
		Result* pCountResult = pStmt->executeQuery("SELECT COUNT(*) from KeyObject");
		pCountResult->next();
		int count = pCountResult->getDWORD(1);
		SAFE_DELETE(pStmt);

		if (count != 0)
		{
			pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
			Result* pResult = pStmt->executeQuery("SELECT MAX(ItemID) FROM KeyObject");
			pResult->next();
			m_ItemIDRegistry = pResult->getDWORD(1);
			SAFE_DELETE(pStmt);
		}

		m_ItemIDRegistry +=(g_pItemInfoManager->getItemIDSuccessor() - (m_ItemIDRegistry % g_pItemInfoManager->getItemIDSuccessor())) + g_pItemInfoManager->getItemIDBase();
	}
	END_DB(pStmt)

	__LEAVE_CRITICAL_SECTION(m_Mutex)

	cout << "Key...ItemIDRegistry:" << m_ItemIDRegistry << endl;

	__END_CATCH
}

void Ring::initItemIDRegistry(void)
	throw()
{
	__BEGIN_TRY

	Statement* pStmt = NULL; 

	__ENTER_CRITICAL_SECTION(m_Mutex)

	BEGIN_DB
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
		Result* pCountResult = pStmt->executeQuery("SELECT COUNT(*) from RingObject");
		pCountResult->next();
		int count = pCountResult->getDWORD(1);
		SAFE_DELETE(pStmt);

		if (count != 0)
		{
			pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
			Result* pResult = pStmt->executeQuery("SELECT MAX(ItemID) FROM RingObject");
			pResult->next();
			m_ItemIDRegistry = pResult->getDWORD(1);
			SAFE_DELETE(pStmt);
		}

		m_ItemIDRegistry +=(g_pItemInfoManager->getItemIDSuccessor() - (m_ItemIDRegistry % g_pItemInfoManager->getItemIDSuccessor())) + g_pItemInfoManager->getItemIDBase();
	}
	END_DB(pStmt)

	__LEAVE_CRITICAL_SECTION(m_Mutex)

	cout << "Ring...ItemIDRegistry:" << m_ItemIDRegistry << endl;

	__END_CATCH
}

void Bracelet::initItemIDRegistry(void)
	throw()
{
	__BEGIN_TRY

	Statement* pStmt = NULL; 

	__ENTER_CRITICAL_SECTION(m_Mutex)

	BEGIN_DB
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
		Result* pCountResult = pStmt->executeQuery("SELECT COUNT(*) from BraceletObject");
		pCountResult->next();
		int count = pCountResult->getDWORD(1);
		SAFE_DELETE(pStmt);

		if (count != 0)
		{
			pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
			Result* pResult = pStmt->executeQuery("SELECT MAX(ItemID) FROM BraceletObject");
			pResult->next();
			m_ItemIDRegistry = pResult->getDWORD(1);
			SAFE_DELETE(pStmt);
		}

		m_ItemIDRegistry +=(g_pItemInfoManager->getItemIDSuccessor() - (m_ItemIDRegistry % g_pItemInfoManager->getItemIDSuccessor())) + g_pItemInfoManager->getItemIDBase();
	}
	END_DB(pStmt)

	__LEAVE_CRITICAL_SECTION(m_Mutex)

	cout << "Bracelet...ItemIDRegistry:" << m_ItemIDRegistry << endl;

	__END_CATCH
}

void Necklace::initItemIDRegistry(void)
	throw()
{
	__BEGIN_TRY

	Statement* pStmt = NULL; 

	__ENTER_CRITICAL_SECTION(m_Mutex)

	BEGIN_DB
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
		Result* pCountResult = pStmt->executeQuery("SELECT COUNT(*) from NecklaceObject");
		pCountResult->next();
		int count = pCountResult->getDWORD(1);
		SAFE_DELETE(pStmt);

		if (count != 0)
		{
			pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();
			Result* pResult = pStmt->executeQuery("SELECT MAX(ItemID) FROM NecklaceObject");
			pResult->next();
			m_ItemIDRegistry = pResult->getDWORD(1);
			SAFE_DELETE(pStmt);
		}

		m_ItemIDRegistry +=(g_pItemInfoManager->getItemIDSuccessor() - (m_ItemIDRegistry % g_pItemInfoManager->getItemIDSuccessor())) + g_pItemInfoManager->getItemIDBase();
	}
	END_DB(pStmt)

	__LEAVE_CRITICAL_SECTION(m_Mutex)

	cout << "Necklace...ItemIDRegistry:" << m_ItemIDRegistry << endl;

	__END_CATCH
}