select col.name, st.name as DT_name, case when (st.name in ('nchar', 'nvarchar') and (col.max_length > 0)) then col.max_length / 2 else col.max_length end, col.precision, col.scale, bt.name as BT_name, col.is_nullable, col.is_identity,col.is_rowguidcol, OBJECTPROPERTY(col.default_object_id, N'IsDefaultCnst') as is_defcnst, CONVERT(bit, case when(cmc.column_id is null) then 0 else 1 end) as is_computed, case when(cmc.column_id is null) then null else cmc.definition end as formular, col.collation_name, col.system_type_id from SKDBTW.sys.all_columns col left outer join SKDBTW.sys.types st on st.user_type_id = col.user_type_id left outer join SKDBTW.sys.types bt on bt.user_type_id = col.system_type_id left outer join SKDBTW.sys.identity_columns idc on idc.object_id = col.object_id and idc.column_id = col.column_id left outer join SKDBTW.sys.computed_columns cmc on cmc.object_id = col.object_id and cmc.column_id = col.column_id where col.object_id = object_id(N'SKDBTW.dbo.SKID_CHARACTER_TB') order by col.column_id
SELECT TOP 9000 SUBSTRING(qt.text, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.text) ELSE qs.statement_end_offset END - qs.statement_start_offset)/2)+1), qs.execution_count, qs.total_logical_reads, qs.last_logical_reads, qs.min_logical_reads, qs.max_logical_reads, qs.total_elapsed_time, qs.last_elapsed_time, qs.min_elapsed_time, qs.max_elapsed_time, qs.last_execution_time, qp.query_plan FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp WHERE qt.encrypted=0 ORDER BY qs.total_logical_reads DESC
SELECT CAST(ISNULL(cik.index_column_id, 0) AS bit) AS [InPrimaryKey], CAST(ISNULL((select TOP 1 1 from sys.foreign_key_columns AS colfk where colfk.parent_column_id = clmns.column_id and colfk.parent_object_id = clmns.object_id), 0) AS bit) AS [IsForeignKey], usrt.name AS [DataType], ISNULL(baset.name, N'') AS [SystemType], CAST(CASE WHEN baset.name IN (N'nchar', N'nvarchar') AND clmns.max_length <> -1 THEN clmns.max_length/2 ELSE clmns.max_length END AS int) AS [Length], CAST(clmns.precision AS int) AS [NumericPrecision], CAST(clmns.scale AS int) AS [NumericScale], clmns.is_nullable AS [Nullable], clmns.is_computed AS [Computed], clmns.name AS [Name], 'Server[@Name=' + quotename(CAST(serverproperty(N'Servername') AS sysname),'''') + ']' + '/Database[@Name=' + quotename(db_name(),'''') + ']' + '/Table[@Name=' + quotename(tbl.name,'''') + ' and @Schema=' + quotename(SCHEMA_NAME(tbl.schema_id),'''') + ']' + '/Column[@Name=' + quotename(clmns.name,'''') + ']' AS [Urn] FROM sys.tables AS tbl INNER JOIN sys.all_columns AS clmns ON clmns.object_id=tbl.object_id LEFT OUTER JOIN sys.indexes AS ik ON ik.object_id = clmns.object_id and 1=ik.is_primary_key LEFT OUTER JOIN sys.index_columns AS cik ON cik.index_id = ik.index_id and cik.column_id = clmns.column_id and cik.object_id = clmns.object_id and 0 = cik.is_included_column LEFT OUTER JOIN sys.types AS usrt ON usrt.user_type_id = clmns.user_type_id LEFT OUTER JOIN sys.types AS baset ON baset.user_type_id = clmns.system_type_id and baset.user_type_id = baset.system_type_id WHERE (tbl.name=N'SKID_CHARACTER_TB' and SCHEMA_NAME(tbl.schema_id)=N'dbo') ORDER BY clmns.column_id ASC
SELECT db_name() AS [Database_Name], SCHEMA_NAME(tbl.schema_id) AS [Table_Schema], tbl.name AS [Table_Name], i.name AS [Index_Name], clmns.name AS [Name], (case ic.key_ordinal when 0 then cast(1 as tinyint) else ic.key_ordinal end) AS [ID], CAST(COLUMNPROPERTY(ic.object_id, clmns.name, N'IsComputed') AS bit) AS [IsComputed], ic.is_descending_key AS [Descending], ic.is_included_column AS [IsIncluded] FROM sys.tables AS tbl INNER JOIN sys.indexes AS i ON (i.index_id > 0 and i.is_hypothetical = 0) AND (i.object_id=tbl.object_id) INNER JOIN sys.index_columns AS ic ON (ic.column_id > 0 and (ic.key_ordinal > 0 or ic.partition_ordinal = 0)) AND (ic.index_id=CAST(i.index_id AS int) AND ic.object_id=i.object_id) INNER JOIN sys.columns AS clmns ON clmns.object_id = ic.object_id and clmns.column_id = ic.column_id WHERE (i.name=N'PK__SKID_CHARACTER_T__0EA330E9')and((SCHEMA_NAME(tbl.schema_id)=N'dbo' and tbl.name=N'SKID_CHARACTER_TB')) ORDER BY [Database_Name] ASC,[Table_Schema] ASC,[Table_Name] ASC,[Index_Name] ASC,[ID] ASC
SELECT su.name ,so.name , isr.data_type FROM sysobjects so INNER JOIN sysusers su ON so.uid = su.uid INNER JOIN information_schema.routines isr ON so.name = isr.specific_name WHERE so.type = N'AF'
SELECT db_name() AS [Database_Name], SCHEMA_NAME(tbl.schema_id) AS [Table_Schema], tbl.name AS [Table_Name], i.name AS [Name], i.is_primary_key + 2*i.is_unique_constraint AS [IndexKeyType], i.is_unique AS [IsUnique], i.fill_factor AS [FillFactor], CAST(INDEXPROPERTY(i.object_id, i.name, N'IsPadIndex') AS bit) AS [PadIndex], CAST(CASE i.index_id WHEN 1 THEN 1 ELSE 0 END AS bit) AS [IsClustered], CAST(INDEXPROPERTY(i.object_id,i.name,N'IsFulltextKey') AS bit) AS [IsFullTextKey], CASE WHEN 'FG'=dsi.type THEN dsi.name ELSE N'' END AS [FileGroup], s.no_recompute AS [NoAutomaticRecomputation], CAST(case when i.type=3 then 1 else 0 end AS bit) AS [IsXmlIndex], i.is_disabled AS [IsDisabled], CAST(CASE WHEN 'PS'=dsi.type THEN 1 ELSE 0 END AS bit) AS [IsPartitioned], CASE WHEN 'PS'=dsi.type THEN dsi.name ELSE N'' END AS [PartitionScheme] FROM sys.tables AS tbl INNER JOIN sys.indexes AS i ON (i.index_id > 0 and i.is_hypothetical = 0) AND (i.object_id=tbl.object_id) LEFT OUTER JOIN sys.data_spaces AS dsi ON dsi.data_space_id = i.data_space_id LEFT OUTER JOIN sys.stats AS s ON s.stats_id = i.index_id AND s.object_id = i.object_id WHERE (SCHEMA_NAME(tbl.schema_id)=N'dbo' and tbl.name=N'SKID_CHARACTER_TB') ORDER BY [Database_Name] ASC,[Table_Schema] ASC,[Table_Name] ASC,[Name] ASC
SELECT 'Server[@Name=' + quotename(CAST(serverproperty(N'Servername') AS sysname),'''') + ']' + '/Database[@Name=' + quotename(db_name(),'''') + ']' + '/Table[@Name=' + quotename(tbl.name,'''') + ' and @Schema=' + quotename(SCHEMA_NAME(tbl.schema_id),'''') + ']' AS [Urn], tbl.name AS [Name], SCHEMA_NAME(tbl.schema_id) AS [Schema], CAST( case when tbl.is_ms_shipped = 1 then 1 when ( select major_id from sys.extended_properties where major_id = tbl.object_id and minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support') is not null then 1 else 0 end AS bit) AS [IsSystemObject], tbl.create_date AS [CreateDate] FROM sys.tables AS tbl WHERE (CAST( case when tbl.is_ms_shipped = 1 then 1 when ( select major_id from sys.extended_properties where major_id = tbl.object_id and minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support') is not null then 1 else 0 end AS bit)=0) ORDER BY [Schema] ASC,[Name] ASC
SELECT sch.name, sn.name, sn.base_object_name, CASE WHEN ObjectPropertyEx(sn.object_id, 'BaseType') = 'U' THEN 2 WHEN ObjectPropertyEx(sn.object_id, 'BaseType') = 'V' THEN 3 WHEN ObjectPropertyEx(sn.object_id, 'BaseType') IN ('FT', 'TF') THEN 4 WHEN ObjectPropertyEx(sn.object_id, 'BaseType') = 'IF' THEN 5 WHEN ObjectPropertyEx(sn.object_id, 'BaseType') = 'AF' THEN 6 ELSE 0 END FROM sys.synonyms AS sn INNER JOIN sys.schemas AS sch ON sch.schema_id = sn.schema_id WHERE (select case when object_id(base_object_name) IS NULL Then 'P' else ObjectPropertyEx(object_id, 'BaseType') end from sys.synonyms where object_id = sn.object_id) NOT IN ('FN', 'FS', 'P')
SELECT s.physical_name AS [FileName], CAST(FILEPROPERTY(s.name, N'IsPrimaryFile') AS bit) AS [IsPrimaryFile] FROM sys.filegroups AS g INNER JOIN sys.master_files AS s ON (s.type = 0 and s.database_id = db_id() and (s.drop_lsn IS NULL)) AND (s.data_space_id=g.data_space_id) WHERE (CAST(cast(g.name as varbinary(256)) AS sysname)=N'PRIMARY')
select a.CID,a.CNAME,a.AVATAR,a.NLEVEL,a.CURCAR,convert(varchar(19), a.CDATE, 120), b.CARTYPE,b.COLOR, a.TeamId , c.TeamName, c.TMarkId, a.GUILDTYPE from SKID_CHARACTER_TB a LEFT OUTER JOIN SKID_CAR_TB b ON a.serverid=b.serverid and a.CID=b.CID and a.CURCAR=b.CARID LEFT OUTER JOIN SKID_TEAM_TB c ON a.serverid=c.serverid and a.TEAMID=c.TID where a.memberid=@P1 and a.serverid=@P2 and a.state='P' order by a.lastdate desc;
SELECT db_name() AS [Database_Name], tbl.name AS [Name], SCHEMA_NAME(tbl.schema_id) AS [Schema], CAST( case when tbl.is_ms_shipped = 1 then 1 when ( select major_id from sys.extended_properties where major_id = tbl.object_id and minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support') is not null then 1 else 0 end AS bit) AS [IsSystemObject], ISNULL( ( select sum (spart.rows) from sys.partitions spart where spart.object_id = tbl.object_id and spart.index_id < 2), 0) AS [RowCount], tbl.is_replicated AS [Replicated] FROM sys.tables AS tbl WHERE (SCHEMA_NAME(tbl.schema_id)=N'dbo' and tbl.name=N'SKID_CHARACTER_TB') ORDER BY [Database_Name] ASC,[Schema] ASC,[Name] ASC
SELECT is_member(N'db_owner') AS [DboLogin], user_name() AS [UserName], (select default_schema_name from sys.database_principals where name = user_name()) AS [DefaultSchema], (select df.physical_name from sys.database_files as df where 1=df.data_space_id and 1 = df.file_id) AS [PrimaryFilePath]
SELECT db_name() AS [Database_Name], tbl.name AS [Name], SCHEMA_NAME(tbl.schema_id) AS [Schema], CAST( case when tbl.is_ms_shipped = 1 then 1 when ( select major_id from sys.extended_properties where major_id = tbl.object_id and minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support') is not null then 1 else 0 end AS bit) AS [IsSystemObject], ISNULL( ( select sum (spart.rows) from sys.partitions spart where spart.object_id = tbl.object_id and spart.index_id < 2), 0) AS [RowCount], tbl.is_replicated AS [Replicated] FROM sys.tables AS tbl WHERE (tbl.name=N'SKID_CHARACTER_TB') ORDER BY [Database_Name] ASC,[Schema] ASC,[Name] ASC
SELECT a.CID, a.CNAME, Convert(varchar(19), a.LASTDATE, 120 ), a.AVATAR, a.NLevel, a.NExp, a.Gold , a.KM , a.TeamId , a.TeamRank , d.TeamName, d.TMarkId , a.PTYPE, a.LASTAREA, a.LASTPOSX, a.LASTPOSY, a.LASTPOSZ, a.LASTPOSW, a.LASTCITYID, a.LASTPOSSTATE , b.TRYCNT, b.WINCNT, b.POINT , c.TRYCNT, c.WINCNT, c.POINT , QUICKSLOT1, QUICKSLOT2, Convert(varchar(19), a.TeamJoinDate, 120 ), Convert(varchar(19), a.TeamCloseDate, 120 ), Convert(varchar(19), a.TeamLeaveDate, 120 ), a.PLAYTIME, a.CURCAR, a.PARTINVENIDX, a.MEMBERID, e.MEMBERNUM, e.TOTALPLAYTIME, q.WINCNT, h.WINCNT, i.WINCNT, Convert(varchar(19), a.BlockGameDate, 120 ), Convert(varchar(19), a.BlockChatDate, 120 ), a.HANCOININVEN, a.HANCOINGARAGE, a.GUILDTYPE, a.MILEAGE FROM SKID_CHARACTER_TB a LEFT OUTER JOIN SKID_PLAYMODE_TB b ON a.serverid=b.serverid AND a.CID=b.CID AND b.modeid='PVP' LEFT OUTER JOIN SKID_PLAYMODE_TB c ON a.serverid=c.serverid AND a.CID=c.CID AND c.modeid='TPVP' LEFT OUTER JOIN SKID_PLAYMODE_TB q ON a.serverid=q.serverid AND a.CID=q.CID AND q.modeid='ARBEIT' LEFT OUTER JOIN SKID_PLAYMODE_TB h ON a.serverid=h.serverid AND a.CID=h.CID AND h.modeid='CHASE' LEFT OUTER JOIN SKID_PLAYMODE_TB i ON a.serverid=i.serverid AND a.CID=i.CID AND i.modeid='BATTLETUTORIAL' LEFT OUTER JOIN SKID_TEAM_TB d ON a.serverid=d.serverid AND a.TEAMID=d.TID LEFT OUTER JOIN SKID_MEMBER_TB e ON a.MEMBERID=e.MEMBERID WHERE a.serverid=@P1 AND a.UCNAME=UPPER(@P2) AND a.state='P'
SELECT db_name() AS [Database_Name], v.name AS [Name], SCHEMA_NAME(v.schema_id) AS [Schema], CAST( case when v.is_ms_shipped = 1 then 1 when ( select major_id from sys.extended_properties where major_id = v.object_id and minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support') is not null then 1 else 0 end AS bit) AS [IsSystemObject], CAST(CASE WHEN ISNULL(smv.definition, ssmv.definition) IS NULL THEN 1 ELSE 0 END AS bit) AS [IsEncrypted] FROM sys.all_views AS v LEFT OUTER JOIN sys.sql_modules AS smv ON smv.object_id = v.object_id LEFT OUTER JOIN sys.system_sql_modules AS ssmv ON ssmv.object_id = v.object_id WHERE (v.type = 'V')and(SCHEMA_NAME(v.schema_id)=N'dbo' and v.name=N'SKID_CHARACTER_TB') ORDER BY [Database_Name] ASC,[Schema] ASC,[Name] ASC
SELECT db_name() AS [Database_Name], v.name AS [Name], SCHEMA_NAME(v.schema_id) AS [Schema], CAST( case when v.is_ms_shipped = 1 then 1 when ( select major_id from sys.extended_properties where major_id = v.object_id and minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support') is not null then 1 else 0 end AS bit) AS [IsSystemObject], CAST(CASE WHEN ISNULL(smv.definition, ssmv.definition) IS NULL THEN 1 ELSE 0 END AS bit) AS [IsEncrypted] FROM sys.all_views AS v LEFT OUTER JOIN sys.sql_modules AS smv ON smv.object_id = v.object_id LEFT OUTER JOIN sys.system_sql_modules AS ssmv ON ssmv.object_id = v.object_id WHERE (v.type = 'V')and(v.name=N'SKID_CHARACTER_TB') ORDER BY [Database_Name] ASC,[Schema] ASC,[Name] ASC
SELECT SERVERID, CID, CNAME, UCNAME, MEMBERID, STATE, PTYPE, LASTDATE, AVATAR, CURCAR, NEXTCAR, NUMCAR, NLEVEL, NEXP, GOLD, LASTAREA, LASTPOSX, LASTPOSY, LASTPOSZ, LASTPOSW, LASTCITYID, LASTPOSSTATE, KM, PLAYTIME, CDATE, DELDATE, TEAMID, TEAMRANK, TEAMCLOSEDATE, TEAMLEAVEDATE, QUICKSLOT1, QUICKSLOT2, PARTINVENIDX, BLOCKGAMEDATE, BLOCKCHATDATE, LOGINDATE, LOGOUTDATE, TEAMJOINDATE, HANCOININVEN, GUILDTYPE, HANCOINGARAGE, MILEAGE FROM SKID_CHARACTER_TB
SELECT A.PASSWORD, A.VALID, CASE a.JOINDATE WHEN NULL THEN '07/07/1977 11:11:11' ELSE Convert(varchar(19), a.JOINDATE, 120 ) END FROM MEUSERMT A WHERE A.MEMBERID = @P1
SELECT dtb.name AS [Name], dtb.database_id AS [ID], suser_sname(dtb.owner_sid) AS [Owner], '' AS [UserName], '' AS [DefaultSchema], CAST(CHARINDEX(N'_CS_', CAST(DATABASEPROPERTYEX(dtb.name, 'Collation') AS nvarchar(255))) AS bit) AS [CaseSensitive], 'Server[@Name=' + quotename(CAST(serverproperty(N'Servername') AS sysname),'''') + ']' + '/Database[@Name=' + quotename(dtb.name,'''') + ']' AS [Urn], null AS [PrimaryFilePath], CAST(0 AS bit) AS [DboLogin], dtb.is_fulltext_enabled AS [IsFullTextEnabled], dtb.name AS [DatabaseName] FROM master.sys.databases AS dtb LEFT OUTER JOIN sys.master_files AS df ON df.database_id = dtb.database_id and 1=df.data_space_id and 1 = df.file_id WHERE (dtb.name=N'SKDBTW' and CAST(has_dbaccess(dtb.name) AS bit)=1) ORDER BY [Name] ASC
SELECT SERVERID, CID, CNAME, UCNAME, MEMBERID, STATE, PTYPE, LASTDATE, AVATAR, CURCAR, NEXTCAR, NUMCAR, NLEVEL, NEXP, GOLD, LASTAREA, LASTPOSX, LASTPOSY, LASTPOSZ, LASTPOSW, LASTCITYID, LASTPOSSTATE, KM, PLAYTIME, CDATE, DELDATE, TEAMID, TEAMRANK, TEAMCLOSEDATE, TEAMLEAVEDATE, QUICKSLOT1, QUICKSLOT2, PARTINVENIDX, BLOCKGAMEDATE, BLOCKCHATDATE, LOGINDATE, LOGOUTDATE, TEAMJOINDATE, HANCOININVEN, GUILDTYPE, HANCOINGARAGE, MILEAGE FROM SKID_CHARACTER_TB WHERE (SERVERID = @Param1) AND (CID = @Param2)
update SKID_MEMBER_TB set LOGOUTDATE=GetDate(),LASTPLAYTIME=@P1,TOTALPLAYTIME=TOTALPLAYTIME+@P2 where memberid=@P3
select PERMISSION, LastPlayTime, TotalPlayTime from SKID_MEMBER_TB where memberid=@P1
INSERT INTO SKID_CUINFO( SERVER_NAME, SERVER_IP, USER_CNT, REGDATE ) VALUES (@P1,@P2,@P3, GetDate() )
update SKID_MEMBER_TB set LOGINDATE=GetDate(),LASTIP=@P1 where memberid=@P2
UPDATE SKID_CHARACTER_TB SET LOGINDATE = CASE @P1 WHEN 1 THEN GetDate() ELSE LOGINDATE END, LOGOUTDATE = CASE @P2 WHEN 1 THEN GetDate() ELSE LOGOUTDATE END, LASTDATE = GetDate() WHERE SERVERID=@P3 and CID=@P4
SELECT Convert(FLOAT, GetDate()-LOGOUTDATE) FROM SKID_MEMBER_TB WHERE MEMBERID=@P1
insert into skid_accesslog_tb(serverid,gameid,memberid,charid ,logindate,logoutdate,ip,crmcode ,lv_login,lv_logout,staytime,playtime ,matchcnt,wincnt,defeatcnt,drawcnt ,gamemoney1,gamemoney2,grade) values(@P1,@P2,@P3,@P4, Convert(varchar(19), @P5, 120 ),Convert(varchar(19), @P6, 120 ),@P7,@P8, @P9,@P10,@P11,@P12, @P13,@P14,@P15,@P16, @P17,@P18,@P19)
DELETE FROM SKID_CHARACTER_TB WHERE (SERVERID = @Param1) AND (CID = @Param2) AND (CNAME = @Param3) AND (UCNAME = @Param4) AND (MEMBERID = @Param5) AND (STATE = @Param6) AND (PTYPE = @Param7) AND (LASTDATE = @Param8) AND (AVATAR = @Param9) AND (CURCAR = @Param10) AND (NEXTCAR = @Param11) AND (NUMCAR = @Param12) AND (NLEVEL = @Param13) AND (NEXP = @Param14) AND (GOLD = @Param15) AND (LASTAREA = @Param16) AND (LASTPOSX = @Param17) AND (LASTPOSY = @Param18) AND (LASTPOSZ = @Param19) AND (LASTPOSW = @Param20) AND (LASTCITYID = @Param21) AND (LASTPOSSTATE = @Param22) AND (KM = @Param23) AND (PLAYTIME = @Param24) AND (CDATE = @Param25) AND (DELDATE IS NULL) AND (TEAMID = @Param26) AND (TEAMRANK = @Param27) AND (TEAMCLOSEDATE IS NULL) AND (TEAMLEAVEDATE IS NULL) AND (QUICKSLOT1 = @Param28) AND (QUICKSLOT2 = @Param29) AND (PARTINVENIDX = @Param30) AND (BLOCKGAMEDATE IS NULL) AND (BLOCKCHATDATE IS NULL) AND (LOGINDATE = @Param31) AND (LOGOUTDATE = @Param32) AND (TEAMJOINDATE IS NULL) AND (HANCOININVEN IS NULL) AND (GUILDTYPE IS NULL) AND (HANCOINGARAGE IS NULL) AND (MILEAGE = @Param33)
DELETE FROM SKID_CHARACTER_TB WHERE (SERVERID = @Param1) AND (CID = @Param2) AND (CNAME = @Param3) AND (UCNAME = @Param4) AND (MEMBERID = @Param5) AND (STATE = @Param6) AND (PTYPE = @Param7) AND (LASTDATE = @Param8) AND (AVATAR = @Param9) AND (CURCAR = @Param10) AND (NEXTCAR = @Param11) AND (NUMCAR = @Param12) AND (NLEVEL = @Param13) AND (NEXP = @Param14) AND (GOLD = @Param15) AND (LASTAREA = @Param16) AND (LASTPOSX = @Param17) AND (LASTPOSY = @Param18) AND (LASTPOSZ = @Param19) AND (LASTPOSW = @Param20) AND (LASTCITYID = @Param21) AND (LASTPOSSTATE = @Param22) AND (KM = @Param23) AND (PLAYTIME = @Param24) AND (CDATE = @Param25) AND (DELDATE IS NULL) AND (TEAMID = @Param26) AND (TEAMRANK = @Param27) AND (TEAMCLOSEDATE IS NULL) AND (TEAMLEAVEDATE IS NULL) AND (QUICKSLOT1 IS NULL) AND (QUICKSLOT2 IS NULL) AND (PARTINVENIDX = @Param28) AND (BLOCKGAMEDATE IS NULL) AND (BLOCKCHATDATE IS NULL) AND (LOGINDATE = @Param29) AND (LOGOUTDATE = @Param30) AND (TEAMJOINDATE IS NULL) AND (HANCOININVEN IS NULL) AND (GUILDTYPE IS NULL) AND (HANCOINGARAGE IS NULL) AND (MILEAGE = @Param31)
INSERT INTO SKID_PLAYLOG_TB( SERVERID,CID,CNAME,MEMBERID, MPLAYTIME,CPLAYTIME,MONEY,NEXP,NLEVEL, CARID,CARTYPE,CARGRADE,STAT_SP,STAT_AC,STAT_CL,STAT_BT,EQUIPITEM, DELTA_EXP,DELTA_LEVEL,DELTA_MONEY, PLAYMODE,NPARAM1,NPARAM2,SPARAM,NRECORD) VALUES (@P1,@P2,@P3,@P4, @P5,@P6,@P7,@P8,@P9, @P10,@P11,@P12,@P13, @P14,@P15,@P16,@P17, @P18,@P19,@P20, @P21,@P22,@P23,@P24,@P25)
INSERT INTO SKID_CARLOG_TB( SERVERID,CID,CNAME,MEMBERID, MPLAYTIME,CPLAYTIME,MONEY,NEXP,NLEVEL, CARID,CARTYPE,CARGRADE,STAT_SP,STAT_AC,STAT_CL,STAT_BT,EQUIPITEM, DELTA_EXP,DELTA_LEVEL,DELTA_MONEY, TXNTYPE,CARID0,CARTYPE0,CARGRADE0 ) VALUES (@P1,@P2,@P3,@P4, @P5,@P6,@P7,@P8,@P9, @P10,@P11,@P12,@P13, @P14,@P15,@P16,@P17, @P18,@P19,@P20, @P21,@P22,@P23,@P24 )
update SKID_PLAYMODE_TB set LASTDATE=GetDate(), TRYCNT=TRYCNT+@P1, WINCNT=WINCNT+@P2, POINT=@P3, PLAYTIME=PLAYTIME+@P4, NEXP=NEXP+@P5, GAMEMONEY=GAMEMONEY+@P6, BESTCNT=BESTCNT+@P7, RETIRECNT=RETIRECNT+@P8 OUTPUT INSERTED.TRYCNT, INSERTED.WINCNT where SERVERID=@P9 and CID=@P10 and MODEID=@P11
select count(ucname) from skid_cnamereserve_tb r where r.memberid!=@P1 and r.ucname = UPPER(@P2) union select count(ucname) from skid_character_tb where ucname = UPPER(@P3)
UPDATE SKID_CAR_TB SET LASTDATE=GetDate(), MITRON = @P1, KM = @P2, FUELCONSUME = FUELCONSUME + @P3 WHERE SERVERID=@P4 and CID=@P5 AND CARID=@P6
UPDATE SKID_CHARACTER_TB SET STATE = @STATE WHERE (SERVERID = @Param1) AND (CID = @Param2) AND (CNAME = @Param3) AND (UCNAME = @Param4) AND (MEMBERID = @Param5) AND (STATE = @Param6) AND (PTYPE = @Param7) AND (LASTDATE = @Param8) AND (AVATAR = @Param9) AND (CURCAR = @Param10) AND (NEXTCAR = @Param11) AND (NUMCAR = @Param12) AND (NLEVEL = @Param13) AND (NEXP = @Param14) AND (GOLD = @Param15) AND (LASTAREA = @Param16) AND (LASTPOSX = @Param17) AND (LASTPOSY = @Param18) AND (LASTPOSZ = @Param19) AND (LASTPOSW = @Param20) AND (LASTCITYID = @Param21) AND (LASTPOSSTATE = @Param22) AND (KM = @Param23) AND (PLAYTIME = @Param24) AND (CDATE = @Param25) AND (DELDATE IS NULL) AND (TEAMID = @Param26) AND (TEAMRANK = @Param27) AND (TEAMCLOSEDATE IS NULL) AND (TEAMLEAVEDATE IS NULL) AND (QUICKSLOT1 IS NULL) AND (QUICKSLOT2 IS NULL) AND (PARTINVENIDX = @Param28) AND (BLOCKGAMEDATE IS NULL) AND (BLOCKCHATDATE IS NULL) AND (LOGINDATE = @Param29) AND (LOGOUTDATE = @Param30) AND (TEAMJOINDATE IS NULL) AND (HANCOININVEN IS NULL) AND (GUILDTYPE IS NULL) AND (HANCOINGARAGE IS NULL) AND (MILEAGE = @Param31)
select count(ucname) from skid_cnamereserve_tb r where r.memberid!=@P1 and r.ucname = UPPER(@P2) union select count(ucname) from skid_character_tb where ucname = UPPER(@P3)
insert into SKID_CHARACTER_TB(SERVERID,CNAME,UCNAME,AVATAR,MEMBERID) OUTPUT INSERTED.CID values(@P1,@P2,UPPER(@P3),@P4,@P5)
insert into SKID_PLAYMODE_TB( SERVERID,CID,CNAME,MODEID, CDATE,LASTDATE, TRYCNT,WINCNT,POINT,PLAYTIME, NEXP,GAMEMONEY,BESTCNT,RETIRECNT,MEMBERID ) values(@P1,@P2,@P3,@P4,GetDate(),GetDate(),@P5,@P6,@P7,@P8, @P9,@P10,@P11,@P12,@P13)
UPDATE SKID_COUPONVALUE_TB SET PVPBATTLE = @P1, QUICKSERVICE = @P2, CHASING = @P3, COMBO = @P4, DRIVETIME = @P5, DRIFT = @P6, ARTDRIVE = @P7, JUMP = @P8, REVDRIVE = @P9, UNDERCITY=@P10 WHERE SERVERID = @P11 and CID = @P12
UPDATE SKID_CHARACTER_TB SET NLEVEL = @P1, NEXP = NEXP + @P2, KM = @P3, PLAYTIME=PLAYTIME+@P4, LASTDATE = GetDate(), LASTAREA=@P5, LASTPOSX=@P6, LASTPOSY=@P7, LASTPOSZ=@P8, LASTPOSW=@P9, LASTCITYID=@P10, LASTPOSSTATE=@P11, QUICKSLOT1=@P12, QUICKSLOT2=@P13 WHERE SERVERID=@P14 and CID=@P15
SELECT SERVERID, CID, CNAME, UCNAME, MEMBERID, STATE, PTYPE, LASTDATE, AVATAR, CURCAR, NEXTCAR, NUMCAR, NLEVEL, NEXP, GOLD, LASTAREA, LASTPOSX, LASTPOSY, LASTPOSZ, LASTPOSW, LASTCITYID, LASTPOSSTATE, KM, PLAYTIME, CDATE, DELDATE, TEAMID, TEAMRANK, TEAMCLOSEDATE, TEAMLEAVEDATE, QUICKSLOT1, QUICKSLOT2, PARTINVENIDX, BLOCKGAMEDATE, BLOCKCHATDATE, LOGINDATE, LOGOUTDATE, TEAMJOINDATE, HANCOININVEN, GUILDTYPE, HANCOINGARAGE, MILEAGE FROM SKID_CHARACTER_TB WHERE (SERVERID = @Param1) AND (CNAME = @Param2) AND (UCNAME = @Param3) AND (MEMBERID = @Param4) AND (STATE = @Param5) AND (PTYPE = @Param6) AND (LASTDATE = @Param7) AND (AVATAR IS NULL) AND (CURCAR IS NULL) AND (NEXTCAR IS NULL) AND (NUMCAR IS NULL) AND (NLEVEL IS NULL) AND (NEXP IS NULL) AND (GOLD IS NULL) AND (LASTAREA IS NULL) AND (LASTPOSX IS NULL) AND (LASTPOSY IS NULL) AND (LASTPOSZ IS NULL) AND (LASTPOSW IS NULL) AND (LASTCITYID IS NULL) AND (LASTPOSSTATE IS NULL) AND (KM IS NULL) AND (PLAYTIME IS NULL) AND (CDATE IS NULL) AND (DELDATE IS NULL) AND (TEAMID IS NULL) AND (TEAMRANK IS NULL) AND (TEAMCLOSEDATE IS NULL) AND (TEAMLEAVEDATE IS NULL) AND (QUICKSLOT1 IS NULL) AND (QUICKSLOT2 IS NULL) AND (PARTINVENIDX IS NULL) AND (BLOCKGAMEDATE IS NULL) AND (BLOCKCHATDATE IS NULL) AND (LOGINDATE IS NULL) AND (LOGOUTDATE IS NULL) AND (TEAMJOINDATE IS NULL) AND (HANCOININVEN IS NULL) AND (GUILDTYPE IS NULL) AND (HANCOINGARAGE IS NULL) AND (MILEAGE IS NULL)
UPDATE SKID_CHARACTER_TB SET LOGINDATE = @LOGINDATE, LOGOUTDATE = @LOGOUTDATE, MILEAGE = @MILEAGE WHERE (SERVERID = @Param1) AND (CID = @Param2) AND (CNAME = @Param3) AND (UCNAME = @Param4) AND (MEMBERID = @Param5) AND (STATE = @Param6) AND (PTYPE = @Param7) AND (LASTDATE = @Param8) AND (AVATAR = @Param9) AND (CURCAR = @Param10) AND (NEXTCAR = @Param11) AND (NUMCAR = @Param12) AND (NLEVEL = @Param13) AND (NEXP = @Param14) AND (GOLD = @Param15) AND (LASTAREA = @Param16) AND (LASTPOSX = @Param17) AND (LASTPOSY = @Param18) AND (LASTPOSZ = @Param19) AND (LASTPOSW = @Param20) AND (LASTCITYID = @Param21) AND (LASTPOSSTATE = @Param22) AND (KM = @Param23) AND (PLAYTIME = @Param24) AND (CDATE = @Param25) AND (DELDATE IS NULL) AND (TEAMID = @Param26) AND (TEAMRANK = @Param27) AND (TEAMCLOSEDATE IS NULL) AND (TEAMLEAVEDATE IS NULL) AND (QUICKSLOT1 IS NULL) AND (QUICKSLOT2 IS NULL) AND (PARTINVENIDX = @Param28) AND (BLOCKGAMEDATE IS NULL) AND (BLOCKCHATDATE IS NULL) AND (LOGINDATE IS NULL) AND (LOGOUTDATE IS NULL) AND (TEAMJOINDATE IS NULL) AND (HANCOININVEN IS NULL) AND (GUILDTYPE IS NULL) AND (HANCOINGARAGE IS NULL) AND (MILEAGE = @Param29)
DELETE FROM SKID_CHARACTER_TB WHERE (SERVERID = @Param1) AND (CID = @Param2) AND (CNAME = @Param3) AND (UCNAME = @Param4) AND (MEMBERID = @Param5) AND (STATE = @Param6) AND (PTYPE = @Param7) AND (LASTDATE = @Param8) AND (AVATAR = @Param9) AND (CURCAR = @Param10) AND (NEXTCAR = @Param11) AND (NUMCAR = @Param12) AND (NLEVEL = @Param13) AND (NEXP = @Param14) AND (GOLD = @Param15) AND (LASTAREA = @Param16) AND (LASTPOSX = @Param17) AND (LASTPOSY = @Param18) AND (LASTPOSZ = @Param19) AND (LASTPOSW = @Param20) AND (LASTCITYID = @Param21) AND (LASTPOSSTATE = @Param22) AND (KM = @Param23) AND (PLAYTIME = @Param24) AND (CDATE = @Param25) AND (DELDATE IS NULL) AND (TEAMID = @Param26) AND (TEAMRANK = @Param27) AND (TEAMCLOSEDATE IS NULL) AND (TEAMLEAVEDATE IS NULL) AND (QUICKSLOT1 = @Param28) AND (QUICKSLOT2 = @Param29) AND (PARTINVENIDX = @Param30) AND (BLOCKGAMEDATE IS NULL) AND (BLOCKCHATDATE IS NULL) AND (LOGINDATE IS NULL) AND (LOGOUTDATE = @Param31) AND (TEAMJOINDATE IS NULL) AND (HANCOININVEN IS NULL) AND (GUILDTYPE IS NULL) AND (HANCOINGARAGE IS NULL) AND (MILEAGE = @Param32)
DELETE FROM SKID_CHARACTER_TB WHERE (SERVERID = @Param1) AND (CID = @Param2) AND (CNAME = @Param3) AND (UCNAME = @Param4) AND (MEMBERID = @Param5) AND (STATE = @Param6) AND (PTYPE = @Param7) AND (LASTDATE = @Param8) AND (AVATAR = @Param9) AND (CURCAR = @Param10) AND (NEXTCAR = @Param11) AND (NUMCAR = @Param12) AND (NLEVEL = @Param13) AND (NEXP = @Param14) AND (GOLD = @Param15) AND (LASTAREA = @Param16) AND (LASTPOSX = @Param17) AND (LASTPOSY = @Param18) AND (LASTPOSZ = @Param19) AND (LASTPOSW = @Param20) AND (LASTCITYID = @Param21) AND (LASTPOSSTATE = @Param22) AND (KM = @Param23) AND (PLAYTIME = @Param24) AND (CDATE = @Param25) AND (DELDATE IS NULL) AND (TEAMID = @Param26) AND (TEAMRANK = @Param27) AND (TEAMCLOSEDATE IS NULL) AND (TEAMLEAVEDATE IS NULL) AND (QUICKSLOT1 = @Param28) AND (QUICKSLOT2 = @Param29) AND (PARTINVENIDX = @Param30) AND (BLOCKGAMEDATE IS NULL) AND (BLOCKCHATDATE IS NULL) AND (LOGINDATE IS NULL) AND (LOGOUTDATE = @Param31) AND (TEAMJOINDATE IS NULL) AND (HANCOININVEN IS NULL) AND (GUILDTYPE IS NULL) AND (HANCOINGARAGE IS NULL) AND (MILEAGE = @Param32)
INSERT INTO SKID_COUPONVALUE_TB(SERVERID, CID, CNAME, PVPBATTLE, QUICKSERVICE, CHASING, COMBO, DRIVETIME, DRIFT, ARTDRIVE, JUMP, REVDRIVE, UNDERCITY) VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13)
select CARID,CARTYPE,COLOR,NUPGRADE,AUCTIONCNT,MITRON,KM from SKID_CAR_TB where serverid=@P1 and cid=@P2 order by lastdate desc
UPDATE SKID_CHARACTER_TB SET NEXTCAR = @NEXTCAR, NUMCAR = @NUMCAR, NEXP = @NEXP WHERE (SERVERID = @Param1) AND (CID = @Param2) AND (CNAME = @Param3) AND (UCNAME = @Param4) AND (MEMBERID = @Param5) AND (STATE = @Param6) AND (PTYPE = @Param7) AND (LASTDATE = @Param8) AND (AVATAR = @Param9) AND (CURCAR = @Param10) AND (NEXTCAR = @Param11) AND (NUMCAR = @Param12) AND (NLEVEL = @Param13) AND (NEXP = @Param14) AND (GOLD = @Param15) AND (LASTAREA = @Param16) AND (LASTPOSX = @Param17) AND (LASTPOSY = @Param18) AND (LASTPOSZ = @Param19) AND (LASTPOSW = @Param20) AND (LASTCITYID = @Param21) AND (LASTPOSSTATE = @Param22) AND (KM = @Param23) AND (PLAYTIME = @Param24) AND (CDATE = @Param25) AND (DELDATE IS NULL) AND (TEAMID = @Param26) AND (TEAMRANK = @Param27) AND (TEAMCLOSEDATE IS NULL) AND (TEAMLEAVEDATE IS NULL) AND (QUICKSLOT1 IS NULL) AND (QUICKSLOT2 IS NULL) AND (PARTINVENIDX = @Param28) AND (BLOCKGAMEDATE IS NULL) AND (BLOCKCHATDATE IS NULL) AND (LOGINDATE IS NULL) AND (LOGOUTDATE IS NULL) AND (TEAMJOINDATE IS NULL) AND (HANCOININVEN IS NULL) AND (GUILDTYPE IS NULL) AND (HANCOINGARAGE IS NULL) AND (MILEAGE = @Param29)
INSERT INTO SKID_CHARACTER_TB(SERVERID, CNAME, UCNAME, MEMBERID, STATE, PTYPE, LASTDATE) VALUES (@SERVERID, @CNAME, @UCNAME, @MEMBERID, @STATE, @PTYPE, @LASTDATE)
UPDATE SKID_CHARACTER_TB SET MILEAGE=@P1 WHERE SERVERID=@P2 and CID=@P3
select RATING from SKID_CAR_TB where serverid=@P1 and CID=@P2 and CARID=@P3
select MODEID, TRYCNT, WINCNT, POINT, Convert(varchar(19), LASTDATE, 120 ) from SKID_PLAYMODE_TB where SERVERID=@P1 and CID=@P2
SELECT PVPBATTLE, QUICKSERVICE, CHASING, COMBO, DRIVETIME, DRIFT, ARTDRIVE, JUMP, REVDRIVE, UNDERCITY FROM SKID_COUPONVALUE_TB WHERE SERVERID = @P1 AND CID = @P2
update SKID_CHARACTER_TB set nextcar=nextcar+1, numcar=numcar+1, @carid_out = nextcar+1 where SERVERID=@serverid_in and CID=@cid_in ;
insert into SKID_CAR_TB(SERVERID,CID,CNAME,CARID,CARTYPE,COLOR,NUPGRADE,AUCTIONCNT,MITRON,KM,RATING) values(@serverid_in,@cid_in,@cname_in,@carid_out,@cartype_in,@carcolor_in,@cargrade_in,@auctioncnt_in,@mitron_in,@km_in,5000);
INSERT INTO SKID_PLAYLOG_TB( SERVERID,CID,CNAME,MEMBERID, MPLAYTIME,CPLAYTIME,MONEY,NEXP,NLEVEL, CARID,CARTYPE,CARGRADE,STAT_SP,STAT_AC,STAT_CL,STAT_BT,EQUIPITEM, DELTA_EXP,DELTA_LEVEL,DELTA_MONEY, PLAYMODE,NPARAM1,NPARAM2,SPARAM,NRECORD) VALUES (@P1,@P2,@P3,@P4, @P5,@P6,@P7,@P8,@P9, @P10,@P11,@P12,@P13, @P14,@P15,@P16,@P17, @P18,@P19,@P20, @P21,@P22,@P23,@P24,@P25)
SELECT QUESTID,STATE,FAILNUM,PLACEIDX FROM SKID_QUEST_TB WHERE SERVERID=@P1 and CID=@P2
UPDATE SKID_SEQUENCE_TB SET item_sq1=item_sq1+1 OUTPUT INSERTED.item_sq1
SELECT CID, CNAME, REGID, ITEMID, INVENIDX, CARID, CARTYPE, BASECOLOR, NGRADE, NSLOT, FMITRON, FKMH, PRICE, STATE, Convert(varchar(19), REGDATE, 120 ) FROM SKID_AUCTIONCAR_TB WHERE SERVERID=@P1 AND CID=@P2
SELECT INVENIDX, CARID, STICKERID, STICKERNAME, COLOR, POSX, POSY, SCALEX, SCALEY, ROTATE, FLIP, PART FROM SKID_STITEM_TB WHERE SERVERID = @P1 AND CID = @P2
SELECT CTYPE, VALUE FROM SKID_COUPONPARAMVALUE_TB WHERE SERVERID = @P1 AND CID = @P2
select count(*) from skid_prevent_tb where memberid=@P1 and event_name=@P2 and event_nparam=@P3
select a.fcid,a.fstate,b.cname from SKID_FRIEND_TB a, SKID_CHARACTER_TB b where a.serverid=b.serverid and a.fcid=b.cid and a.serverid=@P1 and a.cid=@P2
SELECT CID, CNAME, REGID,ITEMID,ITEMNUM,NRANDOM,NUPGRADE,INVENIDX,PRICE,STATE,ASSIST_A,ASSIST_B,BOX,CTIME,Convert(varchar(19), REGDATE, 120 ) FROM SKID_AUCTION_TB WHERE SERVERID=@P1 AND CID=@P2
SELECT CTYPE, STAMPIDX, STATE FROM SKID_COUPONSTAMP_TB WHERE SERVERID = @P1 AND CID = @P2
SELECT GID, INVENIDX,ITEMID,CARID,STACKNUM,NRANDOM,STATE,NUPGRADE,BELONGING,ASSIST_A,ASSIST_B,BOX,CTIME FROM SKID_ITEM_TB WHERE SERVERID=@P1 and CID=@P2
select ucname from skid_cnamereserve_tb r where r.memberid=@P1
SELECT GID, ITEMID, BUYTIME, GETTYPE, GOLDTYPE, PERIODIDX, HANCOIN, MITO, MILEAGE, STATE, ITEM_DATA, CHAR_MSG, DSTNAME FROM SKID_VISUALITEM_HISTORY WHERE SERVERID = @P1 AND CID = @P2
SELECT GID, ITEMID, INVENIDX, CARID, STATE, ITEM_DATA, PERIOD, CTIME, UTIME FROM SKID_VSITEM_TB WHERE SERVERID = @P1 AND CID = @P2