[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
http://img816.imageshack.us/img816/9383/itworks.png
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

Very Pro Cosmos<3 Keep working and we will soon have a nice dc server

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.

I believe it is oracle due to the to_char function.

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.

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 :).
http://img844.imageshack.us/img844/2963/helloworld.png
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.

excellent work, if you continue like that Drift City will be the best free game xD

Converting tables from Oracle to PostGres.I will report back with my results later :).
EDIT:Character select working,fixing the name check table atm.

very good work CheckPoint. at least someone still is interested in this project :)

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.

Hey I am interested too but I have a lack of knowledge to do coding, I am a server provider after all

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

---

Amazing, keep up the good work!

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 :(.

awsome, so the server problems were with db, now we are close to enter the game xD