Code:
//Search Tables
WHERE ([Index] = '20')
//insert log
INSERT INTO Log VALUES ( GETDATE(), %d, %d, %d, %d, %d, %d, %d, %d, %d)
INSERT INTO PayLog VALUES ( GETDATE(), %d, %d, %d, %d)
//Get max IID on DBServer start
SELECT MAX([IID]) FROM Item
//restore user items
EXEC RestoreRestUserItem %d
//guildwar
SELECT [UID], [GID] FROM Player WHERE [PID] = %d
SELECT [GID] FROM GuildCastle
SELECT [AID] FROM Guild WHERE [GID] = %d
SELECT [GID] FROM GuildWar
//delete player
UPDATE Player SET [UID] = 0 WHERE [PID] = %d
INSERT INTO PlayerDeleted VALUES (%d, %d, GETDATE())
//teacher&student relation
SELECT COUNT(*) FROM MLM WHERE [PID] = %d AND [Relation] = %d
DELETE FROM MLM WHERE [PID] IN (SELECT [RPID] FROM MLM WHERE [PID] = %d AND [Relation] = %d) AND [Relation] = %d
DELETE FROM MLM WHERE [Relation] <> %d AND ([PID] = %d OR [RPID] = %d)
DELETE FROM MLMMsg WHERE [PID] = %d
//select all (probably for Character Info)
SELECT * FROM Player WHERE [PID] = %d
SELECT [Index] FROM Skill WHERE [PID] = %d AND [Index] = 62
INSERT INTO Skill VALUES(%d, 62, 1)
//add all skills ingame on login
SELECT TOP 84 [Index], [Level] FROM Skill WHERE [PID] = %d
//inventory
SELECT TOP %d * FROM Item WHERE [PID] = %d AND ( [Info] & %d) = 0
//storage items
SELECT TOP %d * FROM Item WHERE [PID] = %d AND ( [Info] & %d) <> 0
//Quest window
SELECT * FROM Quest WHERE [PID] = %d
//no clue
SELECT [Type], [nF1] FROM Event WHERE [PID] = %d
//Teacher window
SELECT [Relation], [Name], [RPID], [RUID], [Class], [Level] FROM MLM WHERE [PID] = %d ORDER BY [Relation]
//Buffs
SELECT [Type],[Remain] FROM BuffRemain WHERE [PID] = %d
//Update player info
UPDATE Player SET [Level] = %d, [Specialty] = %d, [Contribute] = %d, [Exp] = %I64d, [GRole] = %d, [Strength] = %d, [Health] = %d, [Intelligence] = %d, [Wisdom] = %d, [Dexterity] = %d, [CurHP] = %d, [CurMP] = %d, [PUPoint] = %d, [SUPoint] = %d, [Killed] = %d, [Map] = %d, [X] = %d, [Y] = %d, [Z] = %d, [Rage] = %d WHERE [PID] = %d
//On levelup
UPDATE MLM SET [Level] = %d WHERE [RPID] = %d AND [Relation] <> %d
//item
DELETE FROM Item WHERE [IID] = %d
UPDATE Item SET [Info] = [Info] | %d WHERE [IID] = %d
UPDATE Item SET [Info] = [Info] & %d WHERE [IID] = %d
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem]) VALUES ( %d, %d, %d, %d, %d, %d, %d, %d, %d)
UPDATE Item SET [PID] = %d, [Info] = [Info] | %d WHERE [IID] = %d
UPDATE Item SET [PID] = %d, [Info] = [Info] & %d WHERE [IID] = %d
UPDATE Item SET [PID] = %d WHERE [IID] = %d
UPDATE Item SET [Num] = [Num] + %d WHERE [IID] = %d
//skill
INSERT INTO Skill VALUES ( %d, %d, 1)
UPDATE Player SET [SUPoint] = %d WHERE [PID] = %d
UPDATE Skill SET [Level] = [Level] + 1 WHERE [PID] = %d AND [Index] = %d
UPDATE Player SET [SUPoint] = %d WHERE [PID] = %d
//change iteminfo
UPDATE Item SET [PID] = %d, [Info] = ( [Info] & %d) | %d WHERE [IID] = %d
//add items
UPDATE Item SET [Num] = [Num] + %d WHERE [IID] = %d
//change iteminfo
UPDATE Item SET [PID] = %d, [Info] = [Info] & %d WHERE [IID] = %d
//lose items
UPDATE Item SET [Num] = [Num] - %d WHERE [IID] = %d
//destroy item
DELETE FROM Item WHERE [IID] = %d
//quests
INSERT INTO Quest VALUES ( %d, %d, %d, %d)
UPDATE Quest SET [Flag] = %d, [Clear] = %d WHERE [PID] = %d AND [Quest] = %d
//players
UPDATE Player SET [Specialty] = [Specialty] | %d WHERE [PID] = %d
UPDATE Player SET [Strength] = %d WHERE [PID] = %d
UPDATE Player SET [Health] = %d WHERE [PID] = %d
UPDATE Player SET [Intelligence] = %d WHERE [PID] = %d
UPDATE Player SET [Wisdom] = %d WHERE [PID] = %d
UPDATE Player SET [Dexterity] = %d WHERE [PID] = %d
UPDATE Player SET [PUPoint] = %d WHERE [PID] = %d
UPDATE Player SET [SUPoint] = %d WHERE [PID] = %d
UPDATE Player SET [Contribute] = %d WHERE [PID] = %d
UPDATE Item SET [XAttack] = %d WHERE [IID] = %d
UPDATE Item SET [XMagic] = %d WHERE [IID] = %d
UPDATE Item SET [XHit] = %d WHERE [IID] = %d
UPDATE Item SET [XDefense] = %d WHERE [IID] = %d
UPDATE Item SET [XDodge] = %d WHERE [IID] = %d
UPDATE Item SET [CurEnd] = %d WHERE [IID] = %d
UPDATE Item SET [Prefix] = %d WHERE [IID] = %d (EXEC SetPrefix %d,%d)
UPDATE Item SET [Num] = %d, [MaxEnd] = %d WHERE [IID] = %d
UPDATE Item SET [Num] = %d WHERE [IID] = %d
UPDATE Item SET [Info] = [Info] | %d WHERE [IID] = %d
UPDATE Item SET [Protect] = %d WHERE [IID] = %d
UPDATE Item SET [Info] = [Info] & %d WHERE [IID] = %d
UPDATE Item SET [UpgrRate] = %d WHERE [IID] = %d
UPDATE Item SET [UpgrLevel] = %d, [UpgrRate] = 0 WHERE [IID] = %d
DELETE Skill WHERE [PID] = %d AND [Index] = %d
UPDATE Skill SET [Level] = %d WHERE [PID] = %d AND [Index] = %d
UPDATE Player SET [SUPoint] = %d WHERE [PID] = %d
INSERT INTO BuffRemain VALUES( %d, %d, %d)
DELETE BuffRemain WHERE [PID] = %d AND [Type] = %d
UPDATE BuffRemain SET [Remain] = %d WHERE [PID] = %d AND [Type] = %d
//Teacher student
INSERT INTO MLM VALUES ( %d, %d, '%s', %d, %d, %d, %d)
DELETE FROM MLM WHERE [PID] = %d AND [Relation] = %d AND [RPID] = %d
DELETE FROM MLM WHERE ( [PID] = %d AND [Relation] IN ( %d, %d, %d)) OR ( [Relation] = %d AND [RPID] = %d)
DELETE FROM MLM WHERE [PID] IN ( SELECT [RPID] FROM MLM WHERE [PID] = %d AND [Relation] = %d) AND [Relation] = %d
UPDATE MLM SET [RPID] = [RPID] + %d WHERE [PID] = %d AND [Relation] = %d
INSERT INTO MLM VALUES ( %d, %d, '', %d, 0, 0, 0)
UPDATE MLMMsg SET [Msg] = '%s' WHERE [PID] = %d
INSERT INTO MLMMsg VALUES ( %d, '%s')
SELECT [Msg] FROM MLMMsg WHERE [PID] = %d
//Friend list
INSERT INTO Friend VALUES ( %d, %d, '%s')
SELECT [PID] FROM Player WHERE [Name] = '%s' AND [UID] <> 0
DELETE Friend WHERE [PID] = %d AND [FPID] = %d
SELECT TOP %d [FPID], [FName] FROM Friend WHERE [PID] = %d
SELECT [PID] FROM Player WHERE [Name] = '%s'
//FL messages
SELECT COUNT(*) FROM Mail WHERE [RPID] = %d AND [TimetE] > %d
INSERT INTO Mail ([TimetS], [TimetE], [Priority], [Type], [Status], [SPID], [SName], [RPID], [RName], [IID], [Ver], [Index], [Prefix], [Num], [Pay], [Msg])VALUES ( %d, %d, %d, %d, %d, %d, '%s', %d, '%s', %d, %d, %d, %d, %d, %d, ?)
UPDATE Mail SET [Status] = %d, [IID] = %d, [Index] = %d WHERE [MID] = %d
DELETE Mail WHERE [MID] = %d
UPDATE Mail SET [Type] = %d, [Status] = %d, [SPID] = [RPID], [SName] = [RName], [RPID] = [SPID], [RName] = [SName], [TimetE] = %d, [Pay] = %d WHERE ([SPID] = %d OR [RPID] = %d) AND [Type] = %d AND [TimetE] <= %d AND [Status] IN( %d, %d)
SELECT TOP %d [MID], [Priority], [Type], [Status], [SPID], [SName], [RPID], [RName], [TimetS], [TimetE], [IID] , [Ver], [Index], [Prefix], [Num], [Pay] FROM Mail WHERE [RPID] = %d AND [TimetE] > %d AND [Status] IN( %d, %d)
UPDATE Mail SET [Type] = %d, [Status] = %d, [SPID] = [RPID], [SName] = [RName] , [RPID] = [SPID], [RName] = [SName], [TimetE] = %d, [Pay] = %d WHERE [MID] = %d AND [RPID] = %d AND [Type] = %d AND [Status] IN( %d, %d)
UPDATE Mail SET [Status] = %d WHERE [MID] = %d AND [Type] IN( %d, %d) AND [Status] = %d
UPDATE Mail SET [Status] = %d, [TimetE] = %d WHERE [MID] = %d AND [Type] IN( %d, %d, %d) AND [Status] = %d
SELECT [Msg] FROM Mail WHERE [MID] = %d AND [RPID] = %d
SELECT * FROM Item WHERE [IID] = %d
DELETE Mail WHERE [MID] = %d AND [RPID] = %d
SELECT [Status] FROM Mail WHERE [MID] = %d AND [RPID] = %d
UPDATE Mail Set [Status] = %d WHERE [MID] = %d AND [RPID] = %d AND [Type] IN( %d, %d, %d) AND [TimetE] > %d
SELECT [Status] FROM Mail WHERE [MID] = %d AND [RPID] = %d
SELECT * FROM Item WHERE [IID] = %d
UPDATE Mail SET [Type] = %d, [Status] = %d, [TimetE] = %d, [IID] = %d, [Index] = %d, [Prefix] = %d, [Num] = %d, [Pay] = %d WHERE [MID] = %d
UPDATE Mail SET [Status] = %d WHERE [MID] = %d
//login char select
SELECT TOP %d [PID], [Name], [Class], [Level], [GID], [Strength], [Health], [Intelligence], [Wisdom], [Dexterity], [Face], [Hair] FROM Player WHERE UID = %d ORDER BY [Level]
SELECT TOP %d [PID], [Name], [Class], [Level], [GID], [Strength], [Health], [Intelligence], [Wisdom], [Dexterity], [Face], [Hair] FROM Player WHERE UID = %d ORDER BY [Level]
SELECT TOP 13 [Index] FROM Item WHERE [PID] = %d AND ( [Info] & %d) = %d
SELECT TOP 13 [Index] FROM Item WHERE [PID] = %d AND ( [Info] & %d) = %d
SELECT TOP 5 PlayerDeleted.PID, Name, [Level], Class, DayLeft = 14-datediff(dd, DeletedTime, getdate()) FROM PlayerDeleted, Player WHERE PlayerDeleted.UID = %d AND PlayerDeleted.PID= Player.PID ORDER BY DayLeft DESC
SELECT TOP 5 PlayerDeleted.PID, Name, [Level], Class, DayLeft = 14-datediff(dd, DeletedTime, getdate()) FROM PlayerDeleted, Player WHERE PlayerDeleted.UID = %d AND PlayerDeleted.PID= Player.PID ORDER BY DayLeft DESC
//char create
//check amount of chars
SELECT COUNT(*) FROM Player WHERE [UID] = %d
//check reserved names
SELECT COUNT(*) FROM ReservedName WHERE [Name] = '%s'
//check same name
SELECT COUNT(*) FROM Player WHERE [Name] = '%s'
INSERT INTO Player ( [UID], [Name], [Class], [Strength], Health, Intelligence, Wisdom, Dexterity, [CurHP], [CurMP], [Map], [X], [Y], [Z], [Face], [Hair]) VALUES ( %d, '%s', %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)
SELECT [PID] FROM Player WHERE [Name] = '%s'
//skills insert on char create
INSERT INTO Skill VALUES ( %d, 0, 1) //run
INSERT INTO Skill VALUES ( %d, 1, 1) //behead
INSERT INTO Skill VALUES ( %d, 11, 1) //rest
INSERT INTO Skill VALUES ( %d, 62, 1) //stone of return
INSERT INTO Skill VALUES ( %d, 4, 1) //lightning skill
INSERT INTO Quest VALUES (%d, 9001, 1, 0)// standard quest
SELECT [UID] FROM Player WHERE [Name] = '%s'
//insert item
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem]) VALUES ( %d, %d, %d, %d, %d, %d, %d, %d, %d)
UPDATE Player SET [RevivalId] = %d WHERE [PID] = %d
SELECT COUNT(*) FROM Event WHERE PID=%d AND Type=%d
UPDATE Event SET nF1=%d WHERE PID=%d AND Type=%d
INSERT INTO Event VALUES (%d,%d,%d)
SELECT [UID] FROM Player WHERE [Name] = '%s'
//join (check if u waited 3days) & leave guild
SELECT Date FROM GuildMember WHERE GID=0 AND PID=%d
DELETE FROMmp;nbsp;GuildMember WHERE PID=%d
SELECT Date FROM GuildMember WHERE GID=0 AND PID=%d
DELETE FROM GuildMember WHERE PID=%d
//guild creation
SELECT COUNT(*) FROM Guild WHERE Name='%s'
INSERT INTO Guild VALUES (%d,'%s',0,0,'','±ºÁÖ','ºÎ±ºÁÖ','¹éºÎÀå','½ÊºÎÀå','Á¤½Ä±¸¼º¿ø','Àӽñ¸¼º¿ø',%d,%d,%d,%d,%d,0)
//guild creation insert leader + members
INSERT INTO GuildMember VALUES (%d,%d,%d,1,0)
UPDATE Player SET GID=%d WHERE PID=%d
INSERT INTO GuildMember VALUES (%d,%d,%d,1,0)
UPDATE Player SET GID=%d WHERE PID=%d
//leave guild
UPDATE GuildMember SET GID=0, Date=%d WHERE PID=%d
UPDATE Player SET GID=0 WHERE PID=%d
DELETE FROM GuildMember WHERE PID=%d
//used /position command
UPDATE GuildMember SET Class=%d, Date=%d WHERE PID=%d
//dissolve guild
DELETE FROM Guild WHERE GID=%d
UPDATE GuildMember SET GID=0, Date=%d WHERE GID=%d
UPDATE Player SET GID=0 WHERE GID=%d
//positionnamechange
UPDATE Guild SET Leader='%s' WHERE GID=%d
UPDATE Guild SET SubLeader='%s' WHERE GID=%d
UPDATE Guild SET Centurion='%s' WHERE GID=%d
UPDATE Guild SET Ten='%s' WHERE GID=%d
UPDATE Guild SET Regular='%s' WHERE GID=%d
UPDATE Guild SET Temp='%s' WHERE GID=%d
//guild notice
UPDATE Guild SET TodayMessage='%s' WHERE GID=%d
//guild exp donations
UPDATE Guild SET Exp=Exp+%d WHERE GID=%d
SELECT GID FROM Guild WHERE Name='%s'
UPDATE Guild SET Exp=%d WHERE GID=%d
//Guild Commission
UPDATE Guild SET SubLeaderAble=%d, CenturionAble=%d, TenAble=%d, RegularAble=%d, TempAble=%d WHERE GID=%d
//Alliance
UPDATE Guild SET AID=%d WHERE GID=%d
INSERT INTO GuildAlliance VALUES (%d,0,0,0,0,0,0,0,%d)
UPDATE Guild SET AID=%d WHERE GID=%d
UPDATE GuildAlliance SET GID2=%d WHERE GID1=%d
UPDATE GuildAlliance SET GID3=%d WHERE GID1=%d
UPDATE GuildAlliance SET GID4=%d WHERE GID1=%d
UPDATE GuildAlliance SET GID5=%d WHERE GID1=%d
UPDATE GuildAlliance SET GID6=%d WHERE GID1=%d
UPDATE GuildAlliance SET GID7=%d WHERE GID1=%d
UPDATE GuildAlliance SET GID8=%d WHERE GID1=%d
DELETE FROM GuildAlliance WHERE GID1=%d
UPDATE Guild SET AID=0 WHERE AID=%d
UPDATE GuildAlliance SET Date=%d WHERE GID1=%d
//cw
SELECT * FROM GuildCastle
SELECT * FROM GuildWar
SELECT [Name] FROM Guild WHERE GID=%d
SELECT [Name] FROM Player WHERE PID=%d
DELETE FROM GuildWar
INSERT INTO GuildWar VALUES (%d,%d,%d)
UPDATE GuildCastle SET GID=%d WHERE CID=%d
UPDATE GuildCastle SET TaxRate=%d WHERE CID=%d
UPDATE GuildCastle SET [Tax] = %d WHERE [CID] = %d
UPDATE GuildCastle SET GateLimit=%d WHERE CID=%d
SELECT * FROM Guild WHERE GID=%d
SELECT a.[PID],b.[Name],b.[Contribute],a.[Class],a.[ConnectTell],a.[Date] FROM GuildMember a, Player b WHERE a.GID=%d AND a.PID=b.PID
SELECT * FROM GuildAlliance WHERE GID1=%d
//flags
SELECT b.Name, a.Name FROM Player a, Guild b WHERE b.GID=%d AND a.PID=b.GID.SELECT [Standard] FROM Guild WHERE ( [Standard] & 0xff00) = %d
SELECT COUNT(*) FROM Guild WHERE [Standard] = %d
UPDATE Guild SET [Standard] = %d WHERE [GID] = %d
//misc
SELECT COUNT(*) FROM Player WHERE [UID] = %d
SELECT COUNT(*) FROM Player WHERE [Name] = '%s'
SELECT * FROM Player WHERE [Name] = '%s'
SELECT TOP %d * FROM Item WHERE [PID] = %d AND ( [Info] & %d) = 0
SELECT TOP 64 [Index], [Level] FROM Skill WHERE [PID] = %d
SELECT * FROM Quest WHERE [PID] = %d
SELECT COUNT(*) FROM Player WHERE [Name] = '%s'
SELECT [PID] FROM Player WHERE [Name] = '%s'
//Insert item
INSERT INTO Item VALUES ( %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)
//Insert skill
INSERT INTO Skill VALUES ( %d, %d, %d)
//Insert quest
INSERT INTO Quest VALUES ( %d, %d, %d, %d)
//Insert PK info to assassin board
INSERT INTO PKBulletin VALUES ( '%s', '%s', '%s')
//Read assassin board
SELECT TOP %d [NameGuild], [NameCatch], [NameAssassin] FROM PKBulletin ORDER BY [Index] DESC
//shortcut
UPDATE Shortcut SET [Keys] = ? WHERE [PID] = %d
INSERT INTO Shortcut VALUES ( %d, ?)
SELECT [Keys] FROM Shortcut WHERE [PID] = %d
//teleport
SELECT * FROM Teleport WHERE [PID] = %d
INSERT INTO Teleport VALUES ( %d, '%s', %d, %d, %d, %d)
DELETE FROM Teleport WHERE [PID] = %d AND [LocName] = '%s'
UPDATE Teleport SET [LocName] = '%s' WHERE [PID] = %d AND [LocName] = '%s'
//namechange
UPDATE Player SET [Name] = '%s' WHERE [PID] = %d
UPDATE MLM SET [Name] = '%s' WHERE [RPID] = %d AND [Relation] <> 0
UPDATE PKBulletin SET [NameCatch] = '%s' WHERE [NameCatch] = '%s'
UPDATE PKBulletin SET [NameAssassin] = '%s' WHERE [NameAssassin] = '%s'
UPDATE Friend SET [FName] = '%s' WHERE [FPID] = %d
UPDATE Mail SET [SName] = '%s' WHERE [SPID] = %d
UPDATE Mail SET [RName] = '%s' WHERE [RPID] = %d
INSERT INTO NameChanged VALUES (GETDATE(), 0, %d, '%s', '%s')
UPDATE Guild SET [Name] = '%s' WHERE [GID] = %d
UPDATE PKBulletin SET [NameGuild] = '%s' WHERE [NameGuild] = '%s'
INSERT INTO NameChanged VALUES (GETDATE(), 1, %d, '%s', '%s')
//hourly stats
INSERT INTO [Statistics] ([Knight], [Mage], [Archer], [TotalUser],[FishTrap], [PrivateShop], [Currency]) VALUES (%d, %d, %d, %d, %d, %d, %d)
//face change
UPDATE Player SET [Face] = %d, [Hair] = %d WHERE [PID] = %d
//event
SELECT Event FROM Event_PID WHERE [PID] = %d
UPDATE Event_PID SET [EVENT] = %d WHERE [PID] = %d
//delete player
SELECT COUNT(*) FROM Player WHERE [UID] = %d
SELECT UID FROM PlayerDeleted WHERE [PID] = %d
UPDATE Player SET [UID] = %d WHERE [PID] = %d
DELETE FROM PlayerDeleted WHERE PID = %d
Reply With Quote
Originally Posted by DELUXX
