castlesymbol.cpp

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

		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();

        Result* pResult = pStmt->executeQuery("SELECT MAX(ItemType) FROM CastleSymbolInfo");

        pResult->next();

        m_InfoCount = pResult->getInt(1);

        m_pItemInfos = new ItemInfo*[m_InfoCount+1];

        for (uint i = 0 ; i <= m_InfoCount ; i ++)
            m_pItemInfos[i] = NULL;

        pResult = pStmt->executeQuery(
			"SELECT ItemType, Name, EName, Price, Volume, Weight, Ratio, Durability, Defense, Protection, ReqAbility, ItemLevel FROM CastleSymbolInfo"
		);

		while (pResult->next()) 
		{
			uint i = 0;

			CastleSymbolInfo* pCastleSymbolInfo = new CastleSymbolInfo();

			pCastleSymbolInfo->setItemType(pResult->getInt(++i));
			pCastleSymbolInfo->setName(pResult->getString(++i));
			pCastleSymbolInfo->setEName(pResult->getString(++i));
			pCastleSymbolInfo->setPrice(pResult->getInt(++i));
			pCastleSymbolInfo->setVolumeType(pResult->getInt(++i));
			pCastleSymbolInfo->setWeight(pResult->getInt(++i));
			pCastleSymbolInfo->setRatio(pResult->getInt(++i));
			pCastleSymbolInfo->setDurability(pResult->getInt(++i));
			pCastleSymbolInfo->setDefenseBonus(pResult->getInt(++i));
			pCastleSymbolInfo->setProtectionBonus(pResult->getInt(++i));
			pCastleSymbolInfo->setReqAbility(pResult->getString(++i));
			pCastleSymbolInfo->setItemLevel(pResult->getInt(++i));

			addItemInfo(pCastleSymbolInfo);
		}
		
		SAFE_DELETE(pStmt);
	}
	END_DB(pStmt)
	
	__END_CATCH
}


//--------------------------------------------------------------------------------
// load to creature
//--------------------------------------------------------------------------------
void CastleSymbolLoader::load(Creature* pCreature) 
	throw(Error)
{
	__BEGIN_TRY

	Assert(pCreature != NULL);

	Statement* pStmt;

	BEGIN_DB 
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();

		/*
		StringStream sql;

		sql << "SELECT ItemID, ObjectID, ItemType, Storage, StorageID, X, Y, "
			<< " OptionType, Durability, EnchantLevel FROM CastleSymbolObject"
			<< " WHERE OwnerID = '" << pCreature->getName() << "' AND Storage IN("
			<<(int)STORAGE_INVENTORY << ", " <<(int)STORAGE_GEAR << ", " <<(int)STORAGE_BELT << ", " 
			<<(int)STORAGE_EXTRASLOT << ", " <<(int)STORAGE_MOTORCYCLE << ", " <<(int)STORAGE_STASH << ", " 
			<<(int)STORAGE_GARBAGE << ")";

		Result* pResult = pStmt->executeQuery(sql.toString());
		*/

		// CastleSymbol load且霸 乐促绰巴篮..
		// 泅犁肺辑绰 捞傈俊 辑滚促款捞 登菌促绰 狼固捞促.
		// 弊贰辑, 瘤款促. by sigi
		pStmt->executeQuery( 
				"DELETE FROM CastleSymbolObject WHERE OwnerID = '%s'", 
				pCreature->getName().c_str() );

		/*
		Result* pResult = pStmt->executeQuery( "SELECT ItemID, ObjectID, ItemType, Storage, StorageID, X, Y, OptionType, Durability, EnchantLevel FROM CastleSymbolObject WHERE OwnerID = '%s' AND Storage IN(0, 1, 2, 3, 4, 9)",
								pCreature->getName().c_str() );


		while (pResult->next())
		{
			uint i = 0;

			CastleSymbol* pCastleSymbol = new CastleSymbol();

			pCastleSymbol->setItemID(pResult->getDWORD(++i));
			pCastleSymbol->setObjectID(pResult->getDWORD(++i));
			pCastleSymbol->setItemType(pResult->getDWORD(++i));

			Storage storage =(Storage)pResult->getInt(++i);
			StorageID_t storageID = pResult->getDWORD(++i);
			BYTE x = pResult->getBYTE(++i);
			BYTE y = pResult->getBYTE(++i);

			pCastleSymbol->setOptionType(pResult->getInt(++i));
			pCastleSymbol->setDurability(pResult->getInt(++i));
			pCastleSymbol->setEnchantLevel(pResult->getInt(++i));

			Inventory*  pInventory      = NULL;
			Slayer*     pSlayer         = NULL;
			Vampire*    pVampire        = NULL;
			Motorcycle* pMotorcycle     = NULL;
			Inventory*  pMotorInventory = NULL;
			//Item*       pItem           = NULL;
			Stash*      pStash          = NULL;
			//Belt*       pBelt           = NULL;
			//Inventory*  pBeltInventory  = NULL;

			if (pCreature->isSlayer())
			{
				pSlayer     = dynamic_cast<Slayer*>(pCreature);
				pInventory  = pSlayer->getInventory();
				pStash      = pSlayer->getStash();
				pMotorcycle = pSlayer->getMotorcycle();

				if (pMotorcycle) pMotorInventory = pMotorcycle->getInventory();
			}
			else if (pCreature->isVampire()) 
			{
				pVampire   = dynamic_cast<Vampire*>(pCreature);
				pInventory = pVampire->getInventory();
				pStash     = pVampire->getStash();
			}
			else throw UnsupportedError("Monster,NPC 牢亥配府狼 历厘篮 酒流 瘤盔登瘤 臼嚼聪促.");

			switch(storage)
			{
				case STORAGE_INVENTORY:
					if (pInventory->canAddingEx(x, y, pCastleSymbol))
					{
						pInventory->addItemEx(x, y, pCastleSymbol);
					}
					else
					{
						processItemBugEx(pCreature, pCastleSymbol);
					}
					break;

				case STORAGE_GEAR:
					if (pCreature->isSlayer())
					{
						if (!pSlayer->isWear((Slayer::WearPart)x))
						{
							pSlayer->wearItem((Slayer::WearPart)x, pCastleSymbol);
						}
						else
						{
							processItemBugEx(pCreature, pCastleSymbol);
						}
					}
					else if (pCreature->isVampire())
					{
						processItemBugEx(pCreature, pCastleSymbol);
					}
					break;

				case STORAGE_BELT :
					processItemBugEx(pCreature, pCastleSymbol);
					break;

				case STORAGE_EXTRASLOT :
					if (pCreature->isSlayer())       pSlayer->addItemToExtraInventorySlot(pCastleSymbol);
					else if (pCreature->isVampire()) pVampire->addItemToExtraInventorySlot(pCastleSymbol);
					break;

				case STORAGE_MOTORCYCLE:
					processItemBugEx(pCreature, pCastleSymbol);
					break;

				case STORAGE_STASH:
					if (pStash->isExist(x, y))
					{
						processItemBugEx(pCreature, pCastleSymbol);
					}
					else pStash->insert(x, y, pCastleSymbol);
					break;

				case STORAGE_GARBAGE:
					processItemBug(pCreature, pCastleSymbol);
					break;

				default :
					SAFE_DELETE(pStmt);	// by sigi
					throw Error("invalid storage or OwnerID must be NULL");
			}
		}
		*/

		SAFE_DELETE(pStmt);
	}
	END_DB(pStmt)
	
	__END_CATCH
}


//--------------------------------------------------------------------------------
// load to zone
//--------------------------------------------------------------------------------
void CastleSymbolLoader::load(Zone* pZone) 
	throw(Error)
{
	__BEGIN_TRY

	Assert(pZone != NULL);

	Statement* pStmt;

	BEGIN_DB 
	{
		pStmt = g_pDatabaseManager->getConnection("DARKEDEN")->createStatement();

		StringStream sql;

		sql << "SELECT ItemID, ObjectID, ItemType, Storage, StorageID, X, Y,"
			<< " Durability, EnchantLevel FROM CastleSymbolObject"
			<< " WHERE Storage = " <<(int)STORAGE_ZONE << " AND StorageID = " << pZone->getZoneID();

		Result* pResult = pStmt->executeQuery(sql.toString());

		while (pResult->next())
		{
			uint i = 0;

			CastleSymbol* pCastleSymbol = new CastleSymbol();

			pCastleSymbol->setItemID(pResult->getInt(++i));
			pCastleSymbol->setObjectID(pResult->getInt(++i));
			pCastleSymbol->setItemType(pResult->getInt(++i));

			Storage storage =(Storage)pResult->getInt(++i);
			StorageID_t storageID = pResult->getInt(++i);
			BYTE x = pResult->getInt(++i);
			BYTE y = pResult->getInt(++i);

			pCastleSymbol->setDurability(pResult->getInt(++i));
			pCastleSymbol->setEnchantLevel(pResult->getInt(++i));

			switch(storage)
			{
				case STORAGE_ZONE :	
					{
						Tile & pTile = pZone->getTile(x,y);
						Assert(!pTile.hasItem());
						pTile.addItem(pCastleSymbol);
					}
					break;

				case STORAGE_STASH :
				case STORAGE_CORPSE :
					throw UnsupportedError("惑磊 棺 矫眉救狼 酒捞袍狼 历厘篮 酒流 瘤盔登瘤 臼嚼聪促.");

				default :
					throw Error("Storage must be STORAGE_ZONE");
			}
		}

		SAFE_DELETE(pStmt);
	}
	END_DB(pStmt)

	__END_CATCH
}


//--------------------------------------------------------------------------------
// load to inventory
//--------------------------------------------------------------------------------
void CastleSymbolLoader::load(StorageID_t storageID, Inventory* pInventory) 
	throw(Error)
{
	__BEGIN_TRY

	Statement* pStmt;

	BEGIN_DB 
	{
	}
	END_DB(pStmt)
	
	__END_CATCH
}

CastleSymbolLoader* g_pCastleSymbolLoader = NULL;