Almost ingame.

http://img502.imageshack.us/img502/9585/driftcity.jpg
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

Re: Almost ingame.

Very nice good job<3

Re: Almost ingame.

look my reply in the previous thread it will help

Re: Almost ingame.

very nice man, I hope you can get in-game soon.

Re: Almost ingame.

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.

Re: Almost ingame.

this is good
i hope this will be my first server to run

please make this project possible
tnx

Re: Almost ingame.

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.

Re: Almost ingame.

This is nice Checkpoint.

Re: Almost ingame.

Just dont release it on the web, we dont want 15 different Servers, i suggest only chekpoint does one

Re: Almost ingame.

Quote:

Originally Posted by BjornX

Just dont release it on the web, we dont want 15 different Servers, i suggest only chekpoint does one

Seriously , go away if you're against contribution. I like many others want to open up the files and go through them and learn want stuff I can add to it.