Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Almost ingame.

Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
CheckPoint - Almost ingame. - RaGEZONE Forums

PS:
The teamviewer window is because my print screen wouldn't work for some odd reason.So,I asked a friend to teamview me and screenshot it.
After the client fully loads,it crashes immediately.
(Tested on 0.4i).Any other client e.g. 0.5h would be appreciated.
PPS:
The client seems to be the issue,because the server normally logged my login and created the char properly.
Example(Table name:skid_accesslog_tb):
Code:
100	K_SKID	cosmify	Cosmos	12/26/2010 8:53:14 PM	12/26/2010 8:53:29 PM	127.0.0.1	 	1	1	0	0	0	0	0	0	0	0
 
Last edited:
DRGunZ 2 Creator
Member
Joined
Jan 21, 2007
Messages
4,493
Reaction score
161
very nice man, I hope you can get in-game soon.
 
Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
What happens when a character already exists:
Drift City TW 0.4i:Log in working normally,server select working,but it returns to the login if I have another char and select a server.Creating a new char leads to the result described in the first post.
GamesCampus DC:
Fetches a character list with completely wrong details(Random level and no name.Same as Drift City TW when it comes to going ingame.
Drift City DE:
Same as GamesCampus DC,tho it crashes when pressing the 'Done' button on character creation.
So,I believe the error is actually database-sided,that the query is wrong OR it could be the server returning an wrong character list with results as described above.
 
Initiate Mage
Joined
Dec 27, 2010
Messages
15
Reaction score
1
this is good
i hope this will be my first server to run

please make this project possible
tnx
 
Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
Complete query list
Code:
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
Here are some of the queries executed by the zoneserver during login,character listing,character creation.
EDIT:
I have no idea what is wrong with the server files.It seems to be that the server returns an invalid character list,and when you create a character,the client tries to handle the invalid data,fails to do so and crashes.If someone could help I would appreciate it.
 
Last edited:
Back
Top