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!

[RELEASE]DriftDetour

Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
[Release]DriftDetour

This will change the returned pRet string so that it returns 0(pRet is the value returned from authentication,0=proper login)
Code:
#include <windows.h>
#include <stdio.h>
#include <time.h>
#include <intrin.h>
#pragma comment(lib, "Advapi32")
#include "CDetour/CDetour.h"
CDetour LoginHookDet;
void LoginHook(const wchar_t *Account, const char *Password, unsigned int *Serial, unsigned int *pRet)
{
	unsigned int *fakeRet = 0;
    LoginHookDet.Org(Account,Password,Serial,fakeRet);
}
extern "C" __declspec( dllexport )BOOL __stdcall DllMain( HINSTANCE hInstance, DWORD dwReason, LPVOID lpReserved )
{
	if( dwReason == DLL_PROCESS_ATTACH )
	{
LoginHookDet.Detour((PBYTE)0x005A1D50,(PBYTE)LoginHook);
LoginHookDet.Apply();
MessageBoxA(NULL,"Done","Done",MB_OK);
	}

	return true;
}
This should allow you to login and it will show the server select,but there is no character select yet.If someone could provide me with an old client(Preferably a TW client from 2008),I would appreciate it.
PS:Here's a screenshot :D
CheckPoint - [RELEASE]DriftDetour - RaGEZONE Forums

Update:
IT WORKS.I ACHIEVED DB CONNECTION
Code:
[2010-12-24 22:45:33]Query(400:insert into SKID_STLOG_TB(LOGNAME,LOGKEY,SERVERID,CID,CNAME,CREATEDATE,N1ARG,N2ARG,N3ARG,TXTCONTENT) values(?,?,?,?,?,SYSDATE,?,?,?,?)) Error:1146 
Param:serverStart	0	100	0	admin	168	1	3	server started	
Error:1146:1:SQLExecute:[42S02][MySQL][ODBC 5.1 Driver][mysqld-5.1.41]Table 'skid_stlog_tb' doesn't exist

[2010-12-24 22:45:33]Query(601:select			to_char(sysdate,'YYYY-MM-DD HH24:MI:SS')		 from dual) Error:1305 
Param:
Error:1305:1:SQLExecute:[42000][MySQL][ODBC 5.1 Driver][mysqld-5.1.41]FUNCTION to_char does not exist

[2010-12-24 22:45:33]Query(1535:select STICKERID,BIGIMGID,CID,CNAME,STICKERTYPE,ATTACHCNT,LASTDATE,STICKERCATEGORY,STICKERNAME			 from SKID_STICKERCATALOG_TB			 where SERVERID=? and STICKERTYPE=0 and rownum<200000			 order by LASTDATE			 ) Error:1146 
Param:100	
Error:1146:1:SQLExecute:[42S02][MySQL][ODBC 5.1 Driver][mysqld-5.1.41]Table 'skid_stickercatalog_tb' doesn't exist
I think Phail said something about how he used MySQL 4.1 on another thread.Main thing is,we actually achieved to get it to connect to a database.Cheers to everyone.
Update2:
Changed to 4.1,MySQL errors posted below
Code:
[2010-12-25 00:02:26]Query(400:insert into SKID_STLOG_TB(LOGNAME,LOGKEY,SERVERID,CID,CNAME,CREATEDATE,N1ARG,N2ARG,N3ARG,TXTCONTENT) values(?,?,?,?,?,SYSDATE,?,?,?,?)) Error:1054 
Param:serverStart	0	100	0	admin	168	1	3	server started	
Error:1054:1:SQLExecute:[42S22][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]Unknown column 'SYSDATE' in 'field list'

[2010-12-25 00:02:26]Query(601:select			to_char(sysdate,'YYYY-MM-DD HH24:MI:SS')		 from dual) Error:1064 
Param:
Error:1064:1:SQLExecute:[42000][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(sysdate,'YYYY-MM-DD HH24:MI:SS')		 from dual' 
[2010-12-25 00:02:26]Query(1535:select STICKERID,BIGIMGID,CID,CNAME,STICKERTYPE,ATTACHCNT,LASTDATE,STICKERCATEGORY,STICKERNAME			 from SKID_STICKERCATALOG_TB			 where SERVERID=? and STICKERTYPE=0 and rownum<200000			 order by LASTDATE			 ) Error:1054 
Param:100	
Error:1054:1:SQLExecute:[42S22][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]Unknown column 'rownum' in 'where clause'

[2010-12-25 00:05:49]Query(30:select a.CID,a.CNAME,a.AVATAR,a.NLEVEL,a.CURCAR,TO_CHAR(a.CDATE, 'yyyy-mm-dd hh24:mi:ss'),		b.CARTYPE,b.COLOR,		a.TeamId , c.TeamName, c.TMarkId, a.GUILDTYPE		from SKID_CHARACTER_TB a,SKID_CAR_TB b,SKID_TEAM_TB c		where		a.serverid=b.serverid(+) and a.CID=b.CID(+) and a.CURCAR=b.CARID(+) and		a.memberid=? and a.serverid=? and a.state='P' and		a.serverid=c.serverid(+) and a.TEAMID=c.TID(+)		order by a.lastdate desc;) Error:1064 
Param:car	100	
Error:1064:1:SQLExecute:[42000][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(a.CDATE, 'yyyy-mm-dd hh24:mi:ss'),		b.CARTYPE,
[2010-12-25 00:05:50]Query(26:update SKID_MEMBER_TB		set LOGINDATE=SYSDATE,LASTIP=? 		where memberid=?) Error:1054 
Param:127.0.0.1:17824	car	
Error:1054:1:SQLExecute:[42S22][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]Unknown column 'SYSDATE' in 'field list'

[2010-12-25 00:11:48]Query(21:SELECT TO_NUMBER(SYSDATE-LOGOUTDATE) FROM SKID_MEMBER_TB WHERE MEMBERID=?) Error:1064 
Param:car	
Error:1064:1:SQLExecute:[42000][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SYSDATE-LOGOUTDATE) FROM SKID_MEMBER_TB WHERE 
[2010-12-25 00:11:48]Query(25:update SKID_MEMBER_TB		set LOGOUTDATE=SYSDATE,LASTPLAYTIME=?,TOTALPLAYTIME=TOTALPLAYTIME+?		where memberid=?) Error:1054 
Param:359	359	car	
Error:1054:1:SQLExecute:[42S22][MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]Unknown column 'SYSDATE' in 'field list'
I am starting to believe that it needs Oracle.
EDIT:
Converted database to PostGreSQL
Errors below
Code:
[2010-12-25 13:25:05]Query(400:insert into SKID_STLOG_TB(LOGNAME,LOGKEY,SERVERID,CID,CNAME,CREATEDATE,N1ARG,N2ARG,N3ARG,TXTCONTENT) values(?,?,?,?,?,SYSDATE,?,?,?,?)) Error:7 
Param:serverStart	0	100	0	admin	168	1	3	server started	
Error:7:1:SQLExecute:[42703]ERROR: column "logname" of relation "skid_stlog_tb" does not exist;
Error while executing the query

[2010-12-25 13:25:05]Query(601:select			to_char(sysdate,'YYYY-MM-DD HH24:MI:SS')		 from dual) Error:7 
Param:
Error:7:1:SQLExecute:[42P01]ERROR: relation "dual" does not exist;
Error while executing the query

[2010-12-25 13:25:05]Query(290:SELECT CID, CNAME, REGNUM, BUYNUM,SELLNUM FROM SKID_AUCTIONMILEAGE_TB WHERE SERVERID=?) Error:7 
Param:100	
Error:7:1:SQLExecute:[42703]ERROR: column "cid" does not exist;
Error while executing the query
We are getting closer,we just need to add some columns
 
Last edited:
Banned
Banned
Joined
Aug 9, 2009
Messages
425
Reaction score
74
Very Pro Cosmos<3 Keep working and we will soon have a nice dc server
 
Joined
Mar 9, 2009
Messages
39
Reaction score
9
I LOVE YOU!
I am a pro dc player, I always wanted a DC server, if you make one, you will always stay in my racing heart xD.
 
DRGunZ 2 Creator
Member
Joined
Jan 21, 2007
Messages
4,493
Reaction score
161
I believe it is oracle due to the to_char function.
 
Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
A list of the queries is on address 0x0040F2E0.Function name:GMRSDBGWSki_IterateAllQuery<PrepareSQL>,yet the function itself doesn't seem to need DBGW enabled in K_SKIDRUSH.xml.Mine is disabled and the database works fine.
 
Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
K,fixed the postgres database.
Errors:
Code:
[2010-12-25 13:48:43]Query(400:insert into SKID_STLOG_TB(LOGNAME,LOGKEY,SERVERID,CID,CNAME,CREATEDATE,N1ARG,N2ARG,N3ARG,TXTCONTENT) values(?,?,?,?,?,SYSDATE,?,?,?,?)) Error:7 
Param:serverStart	0	100	0	admin	168	1	3	server started	
Error:7:1:SQLExecute:[42703]ERROR: column "sysdate" does not exist;
Error while executing the query

[2010-12-25 13:48:43]Query(601:select			to_char(sysdate,'YYYY-MM-DD HH24:MI:SS')		 from dual) Error:7 
Param:
Error:7:1:SQLExecute:[42P01]ERROR: relation "dual" does not exist;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	0	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	1	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	2	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	3	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	4	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	5	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	6	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	7	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	8	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	9	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	10	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	11	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	12	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	13	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	14	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	15	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	16	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	17	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	18	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	19	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	20	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	21	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	22	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	23	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	24	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	25	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	26	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	27	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	28	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	29	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	30	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	31	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	32	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	33	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	34	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	35	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	36	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	37	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	38	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	39	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	40	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	41	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	42	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	43	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	44	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	45	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	46	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	47	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	48	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	49	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	50	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	51	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	52	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	53	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	54	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	55	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	56	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	57	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	58	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	59	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	60	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	61	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	62	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	63	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	64	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	65	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	66	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	67	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	68	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	69	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	70	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	71	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	72	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	73	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	74	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	75	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	76	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	77	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(702:		SELECT TIME, CID, CNAME, TID, TEAMNAME FROM (			SELECT /*+ index_desc(SKID_ARBEITREC_TB skid_arbeitrec_ix1) */ TIME, CID, CNAME, TID, TEAMNAME FROM SKID_ARBEITREC_TB			 WHERE SERVERID=? AND AID=?			) WHERE ROWNUM < 101			) Error:7 
Param:100	78	
Error:7:1:SQLExecute:[42601]ERROR: subquery in FROM must have an alias;
Error while executing the query

[2010-12-25 13:48:43]Query(1535:select STICKERID,BIGIMGID,CID,CNAME,STICKERTYPE,ATTACHCNT,LASTDATE,STICKERCATEGORY,STICKERNAME			 from SKID_STICKERCATALOG_TB			 where SERVERID=? and STICKERTYPE=0 and rownum<200000			 order by LASTDATE			 ) Error:7 
Param:100	
Error:7:1:SQLExecute:[42703]ERROR: column "rownum" does not exist;
Error while executing the query

[2010-12-25 13:51:15]Query(1501:INSERT INTO 		SKID_CUINFO(			CUINFO_SEQ,			SERVER_NAME,			SERVER_IP,			USER_CNT,			REGDATE			)		VALUES (SKID_LOG_SQ1.nextval, ?,?,?, SYSDATE )) Error:7 
Param:	192.168.1.3	0	
Error:7:1:SQLExecute:[42P01]ERROR: missing FROM-clause entry for table "skid_log_sq1";
Error while executing the query

[2010-12-25 13:52:15]Query(1501:INSERT INTO 		SKID_CUINFO(			CUINFO_SEQ,			SERVER_NAME,			SERVER_IP,			USER_CNT,			REGDATE			)		VALUES (SKID_LOG_SQ1.nextval, ?,?,?, SYSDATE )) Error:7 
Param:	192.168.1.3	0	
Error:7:1:SQLExecute:[42P01]ERROR: missing FROM-clause entry for table "skid_log_sq1";
Error while executing the query

[2010-12-25 13:53:15]Query(1501:INSERT INTO 		SKID_CUINFO(			CUINFO_SEQ,			SERVER_NAME,			SERVER_IP,			USER_CNT,			REGDATE			)		VALUES (SKID_LOG_SQ1.nextval, ?,?,?, SYSDATE )) Error:7 
Param:	192.168.1.3	0	
Error:7:1:SQLExecute:[42P01]ERROR: missing FROM-clause entry for table "skid_log_sq1";
Error while executing the query

[2010-12-25 13:54:15]Query(1501:INSERT INTO 		SKID_CUINFO(			CUINFO_SEQ,			SERVER_NAME,			SERVER_IP,			USER_CNT,			REGDATE			)		VALUES (SKID_LOG_SQ1.nextval, ?,?,?, SYSDATE )) Error:7 
Param:	192.168.1.3	0	
Error:7:1:SQLExecute:[42P01]ERROR: missing FROM-clause entry for table "skid_log_sq1";
Error while executing the query

[2010-12-25 13:54:20]Query(30:select a.CID,a.CNAME,a.AVATAR,a.NLEVEL,a.CURCAR,TO_CHAR(a.CDATE, 'yyyy-mm-dd hh24:mi:ss'),		b.CARTYPE,b.COLOR,		a.TeamId , c.TeamName, c.TMarkId, a.GUILDTYPE		from SKID_CHARACTER_TB a,SKID_CAR_TB b,SKID_TEAM_TB c		where		a.serverid=b.serverid(+) and a.CID=b.CID(+) and a.CURCAR=b.CARID(+) and		a.memberid=? and a.serverid=? and a.state='P' and		a.serverid=c.serverid(+) and a.TEAMID=c.TID(+)		order by a.lastdate desc;) Error:7 
Param:asdasd	100	
Error:7:1:SQLExecute:[42601]ERROR: syntax error at or near ")";
Error while executing the query

[2010-12-25 13:55:15]Query(1501:INSERT INTO 		SKID_CUINFO(			CUINFO_SEQ,			SERVER_NAME,			SERVER_IP,			USER_CNT,			REGDATE			)		VALUES (SKID_LOG_SQ1.nextval, ?,?,?, SYSDATE )) Error:7 
Param:	192.168.1.3	0	
Error:7:1:SQLExecute:[42P01]ERROR: missing FROM-clause entry for table "skid_log_sq1";
Error while executing the query

[2010-12-25 13:56:13]Query(21:SELECT TO_NUMBER(SYSDATE-LOGOUTDATE) FROM SKID_MEMBER_TB WHERE MEMBERID=?) Error:7 
Param:asdasd	
Error:7:1:SQLExecute:[42883]ERROR: function to_number(integer) does not exist;
Error while executing the query

[2010-12-25 13:56:15]Query(1501:INSERT INTO 		SKID_CUINFO(			CUINFO_SEQ,			SERVER_NAME,			SERVER_IP,			USER_CNT,			REGDATE			)		VALUES (SKID_LOG_SQ1.nextval, ?,?,?, SYSDATE )) Error:7 
Param:	192.168.1.3	0	
Error:7:1:SQLExecute:[42P01]ERROR: missing FROM-clause entry for table "skid_log_sq1";
Error while executing the query
Here's a teaser screenie :).
CheckPoint - [RELEASE]DriftDetour - RaGEZONE Forums

If someone could help me with those SQL errors it would be appreciated.
PS:I am sure the database is based on Oracle,due to the DUAL table errors and the missing functions,but I can't get its ODBC to work with my ZoneServer.
 
Last edited:
Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
Converting tables from Oracle to PostGres.I will report back with my results later :).
EDIT:Character select working,fixing the name check table atm.
 
Last edited:
DRGunZ 2 Creator
Member
Joined
Jan 21, 2007
Messages
4,493
Reaction score
161
very good work CheckPoint. at least someone still is interested in this project :)
 
Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
Stuck on Character Creation,It doesn't seem to work.I may have screwed up the SQL queries on the ZoneServer or something.Tho it may be the GamesCampus client.Could someone send me the link that was posted on the previous thread(The 0.5i client link)?
PS:What's odd is,the first time I tried making a char it gave me an SQL error.The next couple of times,the error didn't appear.
EDIT:
Downloading the 0.4i client right now,gonna post the results.
 
Last edited:
Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
News so far:
Gave up on PostGreSQL.Instead I am gonna use the Oracle Database 10g express edition
Achieved ODBC connection via Oracle.
Code:
[2010-12-26 15:01:10]Query(400:insert into SKID_STLOG_TB(LOGNAME,LOGKEY,SERVERID,CID,CNAME,CREATEDATE,N1ARG,N2ARG,N3ARG,TXTCONTENT) values(?,?,?,?,?,SYSDATE,?,?,?,?)) Error:942 
Param:serverStart	0	100	0	admin	168	1	3	server started	
Error:942:1:SQLExecute:[42S02][Oracle][ODBC][Ora]ORA-00942: table or view does not exist


[2010-12-26 15:01:10]Query(290:SELECT CID, CNAME, REGNUM, BUYNUM,SELLNUM FROM SKID_AUCTIONMILEAGE_TB WHERE SERVERID=?) Error:942 
Param:100	
Error:942:1:SQLExecute:[42S02][Oracle][ODBC][Ora]ORA-00942: table or view does not exist
 
Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
Converted all the tables to Oracle,it works fine but it has some minor errors.
Also I managed to create a character,tho it doesn't seem to fetch the name level and crew name correctly :(.
 
Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
News:
Oracle is not exactly needed.
You can change the database type via the DbIndex flag on ZoneServerConfig.ini.
EDIT:
Now running on MSSQL 2005,no errors at all but character selection/character creation won't work.

---------- Post added at 07:53 PM ---------- Previous post was at 07:10 PM ----------

Ingame:Semi-working(Just crashed with 0.4i during loading,I don't know if that's just the client bugging).
 
Last edited:
Joined
Mar 9, 2009
Messages
39
Reaction score
9
good work

---------- Post added at 06:36 PM ---------- Previous post was at 06:26 PM ----------

I have a question: did you manage to get to driver dome, or to enter the game itself (I don't remember the old tutorital)?

---------- Post added at 07:40 PM ---------- Previous post was at 06:36 PM ----------

I know what will help maybe:

the client must be configured to the server and there are 2 ways to do it:

1st way:
1)Use my guide to unpack the init_....agt or smth like that in Data_TW folder (NOT THE ONE FROM DATA FOLDER) and copy the files from the unpacked agt to the server files (Init,Data, Data_TW) replacing the old files so the server will be for that client.

2nd way:
In private because its forbidden to place it here.
Skype: sasuke8453
MSN: artyom96@live.ru
ICQ: 552154438
(I will be back tomorrow)
 
Experienced Elementalist
Joined
Sep 27, 2009
Messages
223
Reaction score
95
Hm,the server files are complete.I can't find a client that works with it tho.It fails to parse the info from the character info packet due to a different format.The solution is either to
1.Change the packet structure to support 0.4i(Hardest solution,not sure how to achieve it).
2.Find a working client(Might take long).
 
Initiate Mage
Joined
Nov 17, 2007
Messages
56
Reaction score
1
a working client ? did you try the 0.5 version ?
 
Back
Top