LGram16
dd97ddec92
Move git root from Client/ to src/ to track all source code: - Client: Game client source (moved to Client/Client/) - Server: Game server source - GameTools: Development tools - CryptoSource: Encryption utilities - database: Database scripts - Script: Game scripts - rylCoder_16.02.2008_src: Legacy coder tools - GMFont, Game: Additional resources 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
101 lines
3.4 KiB
Transact-SQL
101 lines
3.4 KiB
Transact-SQL
-- 블럭된 캐릭터 정보를 날린다.
|
|
|
|
-- 솔피스티아
|
|
|
|
-- 창고삭제
|
|
DECLARE @NUM INT
|
|
SET @NUM = 2
|
|
|
|
DELETE dbo.ItemStore1
|
|
WHERE UID IN (SELECT UID FROM MARS162.Unite.dbo.Temp_DeleteUser WHERE ServerID = @NUM)
|
|
|
|
DELETE dbo.ItemStore2
|
|
WHERE UID IN (SELECT UID FROM MARS162.Unite.dbo.Temp_DeleteUser WHERE ServerID = @NUM)
|
|
|
|
|
|
CREATE TABLE #TEMP_T
|
|
(
|
|
CID INT
|
|
)
|
|
|
|
INSERT INTO #TEMP_T
|
|
SELECT Char1
|
|
FROM (
|
|
SELECT Char1 FROM dbo.UserInfo
|
|
WHERE UID IN (SELECT UID FROM MARS162.Unite.dbo.Temp_DeleteUser WHERE ServerID = @NUM)
|
|
UNION ALL
|
|
SELECT Char2 FROM dbo.UserInfo
|
|
WHERE UID IN (SELECT UID FROM MARS162.Unite.dbo.Temp_DeleteUser WHERE ServerID = @NUM)
|
|
UNION ALL
|
|
SELECT Char3 FROM dbo.UserInfo
|
|
WHERE UID IN (SELECT UID FROM MARS162.Unite.dbo.Temp_DeleteUser WHERE ServerID = @NUM)
|
|
) A
|
|
WHERE Char1 > 0
|
|
|
|
--CharInfo
|
|
DELETE dbo.CharInfo_1 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
DELETE dbo.CharInfo_2 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
DELETE dbo.CharInfo_3 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
DELETE dbo.CharInfo_4 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
--CharSkill
|
|
DELETE dbo.CharSkill_1 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
DELETE dbo.CharSkill_2 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
DELETE dbo.CharSkill_3 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
DELETE dbo.CharSkill_4 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
--CharInfo_Time
|
|
DELETE dbo.CharInfo_Time WHERE CID IN (SELECT CID FROM #TEMP_T)
|
|
--CharInfoEx
|
|
DELETE dbo.CharInfoEx WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
--CharItem
|
|
DELETE dbo.CharItem WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
--CharItemEx
|
|
DELETE dbo.CharItemEx WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
--CharPos
|
|
DELETE dbo.CharPos_1 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
DELETE dbo.CharPos_2 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
DELETE dbo.CharPos_3 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
DELETE dbo.CharPos_4 WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
--Friend
|
|
DELETE dbo.Friend WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
--Quest
|
|
DELETE dbo.Quest WHERE UID IN (SELECT CID FROM #TEMP_T)
|
|
--TblCharDelHistory
|
|
DELETE dbo.TblCharDelHistory WHERE intCID IN (SELECT CID FROM #TEMP_T)
|
|
--TblGuildMember
|
|
DELETE dbo.TblGuildMember WHERE nCID IN (SELECT CID FROM #TEMP_T)
|
|
--UserInfo
|
|
DELETE dbo.UserInfo_1 WHERE UID IN (SELECT UID FROM MARS162.Unite.dbo.Temp_DeleteUser WHERE ServerID = @NUM)
|
|
DELETE dbo.UserInfo_2 WHERE UID IN (SELECT UID FROM MARS162.Unite.dbo.Temp_DeleteUser WHERE ServerID = @NUM)
|
|
DELETE dbo.UserInfo_3 WHERE UID IN (SELECT UID FROM MARS162.Unite.dbo.Temp_DeleteUser WHERE ServerID = @NUM)
|
|
DELETE dbo.UserInfo_4 WHERE UID IN (SELECT UID FROM MARS162.Unite.dbo.Temp_DeleteUser WHERE ServerID = @NUM)
|
|
|
|
DROP TABLE #TEMP_T
|
|
|
|
|
|
GO
|
|
|
|
|
|
/**********************************************
|
|
*
|
|
* TblCharDelHistory 용 테이블 임시보관용
|
|
*
|
|
**********************************************/
|
|
|
|
select *, 1 as OldServerGroupID into dbo.TblCharDelHistory_Old from HAN916.solphistia.dbo.TblCharDelHistory
|
|
|
|
insert into dbo.TblCharDelHistory_Old
|
|
select *, 2 as OldServerGroupID from HAN516.karterant.dbo.TblCharDelHistory
|
|
|
|
insert into dbo.TblCharDelHistory_Old
|
|
select *, 3 as OldServerGroupID from HAN430.testia.dbo.TblCharDelHistory
|
|
|
|
insert into dbo.TblCharDelHistory_Old
|
|
select *, 4 as OldServerGroupID from MARS161.highland.dbo.TblCharDelHistory
|
|
|
|
insert into dbo.TblCharDelHistory_Old
|
|
select *, 5 as OldServerGroupID from MARS189.aldia.dbo.TblCharDelHistory
|
|
|
|
insert into dbo.TblCharDelHistory_Old
|
|
select *, 6 as OldServerGroupID from unite.dbo.TblCharDelHistory
|
|
|