- Joined
- Nov 2, 2012
- Messages
- 99
- Reaction score
- 1
[WzExDB] connect : [1][169.254.243.211]
20:33:36 [WzExDB] [ExDB][ExDB] GameServer with ServerCode[19] connected.
20:33:41 EXEC WZ_CS_GetCastleTotalInfo 0,7
20:33:41 EXEC WZ_CS_GetCastleNpcInfo 0
20:33:41 EXEC WZ_CS_ResetCastleSiege 0
20:34:36 EXEC WZ_CW_InfoLoad 0
20:36:27 SELECT * FROM MEMB_INFO WHERE memb___id='hannah'
[Object] User hannah has join
20:36:27 EXEC WZ_CONNECT_MEMB 'hannah','GS1','169.254.243.211'
20:36:27 SELECT Id FROM AccountCharacter WHERE Id='hannah'
20:36:27 SELECT * FROM AccountCharacter WHERE Id='hannah'
20:36:27 SELECT cLevel, Class, CtlCode, DbVersion FROM vCharacterPreview WHERE Name='lhei'
20:36:27 SELECT Inventory FROM Character WHERE Name='lhei'
20:36:27 SELECT G_Status FROM GuildMember WHERE Name='lhei'
20:36:27 SELECT SCFIsVip, SCFVipMoney, SCFVipDays, SCFWareVipCount, DateDiff(dd , out__days,getdate()) as dateDifference, SCFLuckyCoins, SCFExtWarehouse FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = 'hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFIsVip'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFVipMoney'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFVipDays'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFWareVipCount'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFLuckyCoins'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFExtWarehouse'.
20:36:27 SELECT AccountID,BotLife,BotMaxLife FROM MuOnline.dbo.BotPet WHERE AccountID='hannah' AND BotLife < BotMaxLife
SQLSTATE:42S02, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'MuOnline.dbo.BotPet'.
20:36:27 SELECT MuItemShopList FROM MuOnline.dbo.MEMB_INFO where memb___id = 'hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MuItemShopList'.
20:36:27 SELECT MuItemShopGiftList FROM MuOnline.dbo.MEMB_INFO where memb___id = 'hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MuItemShopGiftList'.
20:36:27 SELECT MuItemShopGiftMsg FROM MuOnline.dbo.MEMB_INFO where memb___id = 'hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MuItemShopGiftMsg'.
20:36:27 SELECT WCoin,WCoinP,GoblinCoin FROM MuOnline.dbo.MEMB_INFO where memb___id= 'hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'WCoin'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'WCoinP'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'GoblinCoin'.
20:36:38 SELECT cLevel, Class, LevelUpPoint, Experience, Strength, Dexterity, Vitality, Energy, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, CtlCode, DbVersion, Leadership, ChatLimitTime, FruitPoint, SCFExtInventory, SCFUpdatedPShop FROM Character WHERE Name='lhei' AND AccountID='hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFExtInventory'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFUpdatedPShop'.
20:36:38 SELECT Inventory from Character where Name='lhei'
20:36:38 SELECT MagicList from Character where Name='lhei'
20:36:38 SELECT Quest from Character where Name='lhei'
20:36:38 UPDATE AccountCharacter SET GameIDC='lhei' WHERE Id='hannah'
20:36:38 SELECT * FROM OptionData WHERE Name='lhei'
20:36:38 EXEC WZ_DISCONNECT_MEMB 'hannah'
[Player] hannah has been deleted
20:36:38 SELECT SCFMasterLevel, SCFMasterPoints, Resets, SCFPCPoints, SCFSealItem, SCFSealTime, SCFScrollItem, SCFScrollTime, SCFMarried, SCFMarryHusbandWife, SCFGensFamily, SCFGensContribution,SCFGensRank,SCFGensRecvReward,SCFGensDD = (CAST((DATEDIFF(dd,SCFGensDateLeave,GETDATE())) as int)+1) FROM MuOnline.dbo.Character WHERE Name = 'lhei'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFMasterLevel'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFMasterPoints'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFPCPoints'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFSealItem'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFSealTime'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFScrollItem'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFScrollTime'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFMarried'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFMarryHusbandWife'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFGensFamily'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFGensContribution'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFGensRank'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFGensRecvReward'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFGensDateLeave'.
WHAT CAN I DO TO FIX THAT PROBLEM THANKS
20:33:36 [WzExDB] [ExDB][ExDB] GameServer with ServerCode[19] connected.
20:33:41 EXEC WZ_CS_GetCastleTotalInfo 0,7
20:33:41 EXEC WZ_CS_GetCastleNpcInfo 0
20:33:41 EXEC WZ_CS_ResetCastleSiege 0
20:34:36 EXEC WZ_CW_InfoLoad 0
20:36:27 SELECT * FROM MEMB_INFO WHERE memb___id='hannah'
[Object] User hannah has join
20:36:27 EXEC WZ_CONNECT_MEMB 'hannah','GS1','169.254.243.211'
20:36:27 SELECT Id FROM AccountCharacter WHERE Id='hannah'
20:36:27 SELECT * FROM AccountCharacter WHERE Id='hannah'
20:36:27 SELECT cLevel, Class, CtlCode, DbVersion FROM vCharacterPreview WHERE Name='lhei'
20:36:27 SELECT Inventory FROM Character WHERE Name='lhei'
20:36:27 SELECT G_Status FROM GuildMember WHERE Name='lhei'
20:36:27 SELECT SCFIsVip, SCFVipMoney, SCFVipDays, SCFWareVipCount, DateDiff(dd , out__days,getdate()) as dateDifference, SCFLuckyCoins, SCFExtWarehouse FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = 'hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFIsVip'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFVipMoney'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFVipDays'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFWareVipCount'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFLuckyCoins'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFExtWarehouse'.
20:36:27 SELECT AccountID,BotLife,BotMaxLife FROM MuOnline.dbo.BotPet WHERE AccountID='hannah' AND BotLife < BotMaxLife
SQLSTATE:42S02, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'MuOnline.dbo.BotPet'.
20:36:27 SELECT MuItemShopList FROM MuOnline.dbo.MEMB_INFO where memb___id = 'hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MuItemShopList'.
20:36:27 SELECT MuItemShopGiftList FROM MuOnline.dbo.MEMB_INFO where memb___id = 'hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MuItemShopGiftList'.
20:36:27 SELECT MuItemShopGiftMsg FROM MuOnline.dbo.MEMB_INFO where memb___id = 'hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MuItemShopGiftMsg'.
20:36:27 SELECT WCoin,WCoinP,GoblinCoin FROM MuOnline.dbo.MEMB_INFO where memb___id= 'hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'WCoin'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'WCoinP'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'GoblinCoin'.
20:36:38 SELECT cLevel, Class, LevelUpPoint, Experience, Strength, Dexterity, Vitality, Energy, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, CtlCode, DbVersion, Leadership, ChatLimitTime, FruitPoint, SCFExtInventory, SCFUpdatedPShop FROM Character WHERE Name='lhei' AND AccountID='hannah'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFExtInventory'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFUpdatedPShop'.
20:36:38 SELECT Inventory from Character where Name='lhei'
20:36:38 SELECT MagicList from Character where Name='lhei'
20:36:38 SELECT Quest from Character where Name='lhei'
20:36:38 UPDATE AccountCharacter SET GameIDC='lhei' WHERE Id='hannah'
20:36:38 SELECT * FROM OptionData WHERE Name='lhei'
20:36:38 EXEC WZ_DISCONNECT_MEMB 'hannah'
[Player] hannah has been deleted
20:36:38 SELECT SCFMasterLevel, SCFMasterPoints, Resets, SCFPCPoints, SCFSealItem, SCFSealTime, SCFScrollItem, SCFScrollTime, SCFMarried, SCFMarryHusbandWife, SCFGensFamily, SCFGensContribution,SCFGensRank,SCFGensRecvReward,SCFGensDD = (CAST((DATEDIFF(dd,SCFGensDateLeave,GETDATE())) as int)+1) FROM MuOnline.dbo.Character WHERE Name = 'lhei'
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFMasterLevel'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFMasterPoints'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFPCPoints'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFSealItem'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFSealTime'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFScrollItem'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFScrollTime'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFMarried'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFMarryHusbandWife'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFGensFamily'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFGensContribution'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFGensRank'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFGensRecvReward'.
SQLSTATE:42S22, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'SCFGensDateLeave'.
WHAT CAN I DO TO FIX THAT PROBLEM THANKS