Arye's Src

Drajwer · Post by **Drajwer** » Mon May 02, 2005 9:56 am

kk call me noob, how to add mysql to include dir :blink:

MorganBlack · Post by **MorganBlack** » Mon May 02, 2005 11:24 am

Dont bother compiling it. there is some bug in it with couses error i erlier posted (LoginServer only sees first GameServer (GSID 0)). You will get con lost everytime you will try switch servers. Iv talked with Aryes on msn and he said that he will release better source at the end of the month.

MorganBlack · Post by **MorganBlack** » Sun May 08, 2005 11:20 am

Ok. Dont lisen to me.. i am a #$%#$ retard... Source looks OK.
I have my server up and running.

Bugs: Mob respawns / Party

Dustin · Post by **Dustin** » Sun May 08, 2005 2:09 pm

Mobs work fine, and we've recoded party to work somewhat better.

Stik · Post by **Stik** » Sat May 14, 2005 11:53 am

Heres a noob question, will this work with the mysql that comes with easyphp or do you need the full MS mysql4.1.
Dont flame me , i'm just asking

Aryes · Post by **Aryes** » Sat May 14, 2005 1:23 pm

Yes you can use the one with easyphp, but I advice you to use the latest mysql version.

Btw, I forgot to mention something... Sometimes it looses the connection during a query, it causes the server to crash with no error in the debugger. I've did a code for it, but I'm still without my pc to test it, so I don't know if it will work 100%, but should.

//put this define at defs.hpp:
#define DEF_MAXALLOWEDQUERYERROR 5

//inside LoginServer.h, inside the class CLoginServer:
void ProcessQuery(MYSQL myConn, char *cQuery);

//LoginServer.cpp:
//=============================================================================
void CLoginServer::ProcessQuery(MYSQL myConn, char *cQuery)
{
BYTE bErrorCount = 0;

do {
mysql_query(&myConn, cQuery);
bErrorCount++;
}
while(MyAux_Get_Error(&myConn) != NULL && bErrorCount < DEF_MAXALLOWEDQUERYERROR);
}
//=============================================================================

Now replace every call to "mysql_query(&" with "ProcessQuery(" exactly as I show here. This should fix the problem of crashing when loosing the connection while doing a query.

Aryes · Post by **Aryes** » Tue May 31, 2005 3:06 am

I don't know if someone is using these files, but here is the correct function for the last post:

//=============================================================================
int CLoginServer::ProcessQuery(MYSQL *myConn, char *cQuery)
{
BYTE bErrorCount = 0;
int iQuery = 0;

do {
if(mysql_ping(myConn) != 0){
mysql_init(myConn);
mysql_real_connect(myConn, mySqlAddress, mySqlUser, mySqlPwd, "playerdb", mySqlPort, NULL, NULL);
}
iQuery = mysql_query(myConn, cQuery);
bErrorCount++;
}
while(MyAux_Get_Error(myConn) != NULL && bErrorCount < DEF_MAXALLOWEDQUERYERROR);
return iQuery;
}
//=============================================================================

Replace every call to "mysql_query" with "ProcessQuery" .
Everything else is working fine now, the party code too, just felt like I shouldn't let people try to use this non-working function.

Dax · Post by **Dax** » Wed Jun 01, 2005 6:03 am

Looking great Aryes. Another brilliant addition to private HB files.

XsX · Post by **XsX** » Wed Jun 15, 2005 2:33 pm

Aryes wrote: I don't know if someone is using these files, but here is the correct function for the last post:

//=============================================================================
int CLoginServer::ProcessQuery(MYSQL *myConn, char *cQuery)
{
BYTE bErrorCount = 0;
int iQuery = 0;

do {
if(mysql_ping(myConn) != 0){
mysql_init(myConn);
mysql_real_connect(myConn, mySqlAddress, mySqlUser, mySqlPwd, "playerdb", mySqlPort, NULL, NULL);
}
iQuery = mysql_query(myConn, cQuery);
bErrorCount++;
}
while(MyAux_Get_Error(myConn) != NULL && bErrorCount < DEF_MAXALLOWEDQUERYERROR);
return iQuery;
}
//=============================================================================

Replace every call to "mysql_query" with "ProcessQuery" .
Everything else is working fine now, the party code too, just felt like I shouldn't let people try to use this non-working function.

--------------------Configuration: LoginServer - Win32 Debug--------------------
Compiling...
Item.cpp
LoginServer.cpp
c:\windows\escritorio\sources\loginserver\loginserver.cpp(146) : warning C4244: 'argument' : conversion from 'short' to 'unsigned char', possible loss of data
c:\windows\escritorio\sources\loginserver\loginserver.cpp(707) : warning C4244: 'argument' : conversion from 'unsigned short' to 'unsigned char', possible loss of data
c:\windows\escritorio\sources\loginserver\loginserver.cpp(739) : warning C4244: 'argument' : conversion from 'unsigned short' to 'unsigned char', possible loss of data
c:\windows\escritorio\sources\loginserver\loginserver.cpp(753) : warning C4100: 'cKey' : unreferenced formal parameter
c:\windows\escritorio\sources\loginserver\loginserver.cpp(753) : warning C4100: 'dwMsgSize' : unreferenced formal parameter
c:\windows\escritorio\sources\loginserver\loginserver.cpp(1281) : error C2440: 'initializing' : cannot convert from 'void' to 'int'
Expressions of type void cannot be converted to other types
c:\windows\escritorio\sources\loginserver\loginserver.cpp(1533) : error C2440: 'initializing' : cannot convert from 'void' to 'int'
Expressions of type void cannot be converted to other types
c:\windows\escritorio\sources\loginserver\loginserver.cpp(2428) : error C2440: '=' : cannot convert from 'void' to 'int'
Expressions of type void cannot be converted to other types
c:\windows\escritorio\sources\loginserver\loginserver.cpp(2625) : warning C4244: '+=' : conversion from 'int' to 'unsigned short', possible loss of data
c:\windows\escritorio\sources\loginserver\loginserver.cpp(2810) : warning C4244: 'argument' : conversion from 'int' to 'unsigned char', possible loss of data
c:\windows\escritorio\sources\loginserver\loginserver.cpp(2918) : error C2440: '=' : cannot convert from 'void' to 'int'
Expressions of type void cannot be converted to other types
c:\windows\escritorio\sources\loginserver\loginserver.cpp(3006) : error C2440: '=' : cannot convert from 'void' to 'int'
Expressions of type void cannot be converted to other types
c:\windows\escritorio\sources\loginserver\loginserver.cpp(3539) : error C2601: 'ProcessQuery' : local function definitions are illegal
c:\windows\escritorio\sources\loginserver\loginserver.cpp(3539) : fatal error C1903: unable to recover from previous error(s); stopping compilation
Party.cpp
Skipping... (no relevant changes detected)
Client.cpp
main.cpp
Error executing cl.exe.
Creating browse info file...
BSCMAKE: error BK1506 : cannot open file '.\DEBUG\LoginServer.sbr': No such file or directory
Error executing bscmake.exe.

LoginServer.exe - 8 error(s), 7 warning(s)

Drajwer · Post by **Drajwer** » Wed Jun 15, 2005 4:05 pm

yeah
Replace every call to "mysql_query" with "ProcessQuery" .

i replaced and my server dont run.

Aryes · Post by **Aryes** » Sun Jun 19, 2005 4:14 pm

Don't bother with these files, these are too much bugged. I've recoded it and found where was my mistakes. The files are working with no crashes until now, party 100% working.

Drajwer · Post by **Drajwer** » Sun Jun 19, 2005 4:29 pm

do you want to release it ?

Aryes · Post by **Aryes** » Mon Jun 20, 2005 3:15 pm

Not now. I have plans for it.

diwx · Post by **diwx** » Mon Jun 20, 2005 4:34 pm

There is this 1 thing I don't fully get...
Why does ppl have so fucking huge problems spelling the name "Aryes"? :unsure:

morbid · Post by **morbid** » Fri Jun 24, 2005 7:45 pm

^^ Fixed Ty =)!