CoFuture's Conquer 1.0 source Problem

12/10/2013 01:08 xScylez#1
Hello there!
[Only registered and activated users can see links. Click Here To Register...]is the source my question is about:
I am having some issues trying to set up this source..

Navicat setup:
Database setup:



First of all, when i am executing the SQL file, i get 601 errors:

And i use "Continue on errors".
Second i go in the source project file, and edit the lines:¨

----
When i debug it works just fine, but when i am trying to log in to a account i made in Navicat, i get error:
And i made a account with username only: test
1. In Conquer game window:
Code:
Error. Connection with the server is interrupted. Please re-login.
2. In the source debug window:
Code:
Auth Packet: Auth Request
Acc: test: Server: Eternity > IP: Invalid
Image:

I don't really know what i am doing wrong here, i would appreciate it if anyone could help me out.
12/10/2013 01:31 pro4never#2
It's an old database file not compatible with newer versions of mysql.

You could make it compatible by manually editing some stuff in the sql file but you really do need to know a bit of sql syntax for it to work properly.

Key points to look at.


EngineType is MyISAM instead of INNODB and is using USING BTREE


I've run old backups by batch replacing some of the stuff in sql files before but it definitely requires significant trial and error and some half decent sql knowledge.
12/10/2013 17:11 Y u k i#3
You could also create the tables manually. Like stats. It just shows you so many errors because it cant / fails to create the tables :)
12/10/2013 19:00 Spirited#4
Chris is right. You might need to recreate that script. You can dump a test database and use that script as a reference if you need to. Notepad++ is really nice for editing sql files (or almost any programming file you want to edit).
12/10/2013 23:44 xScylez#5
Quote:
Originally Posted by Fang View Post
Chris is right. You might need to recreate that script. You can dump a test database and use that script as a reference if you need to. Notepad++ is really nice for editing sql files (or almost any programming file you want to edit).
So in other words, just put my project away?
This sounds more complicated than my experience can do..

EDIT: Wasn't that hard after all. I tried some stuff, then execute in Navicat: 0 errors :)
But i still get the same IP: Invalid error, and "Connection with server interrupted"..
12/11/2013 00:15 Spirited#6
Quote:
Originally Posted by xScylez View Post
So in other words, just put my project away?
This sounds more complicated than my experience can do..

EDIT: Wasn't that hard after all. I tried some stuff, then execute in Navicat: 0 errors :)
But i still get the same IP: Invalid error, and "Connection with server interrupted"..
You need to change the ip address the client connects with to your server's ip, and the game server's ip with your server's ip in the database. Also the name of the server and what not. Configuration.
12/11/2013 00:40 xScylez#7
Quote:
Originally Posted by Fang View Post
You need to change the ip address the client connects with to your server's ip, and the game server's ip with your server's ip in the database. Also the name of the server and what not. Configuration.
It's all set:
server.dat (this is my hamachi ip)

In Navicat: (table: "servers")

The database connection: (Database.cs)

All should be set up correctly, and i can't really see where it is going wrong.
12/11/2013 02:15 Spirited#8
Your server.dat file is set up incorrectly. I don't see your server name in that file at all.
12/11/2013 08:38 xScylez#9
Quote:
Originally Posted by Fang View Post
Your server.dat file is set up incorrectly. I don't see your server name in that file at all.
Hmm.. Didn't know i had to change the server name to in the server.dat...
I'll try it when i get home from work.

EDIT: Such an embarrassing error fix. Thank you Fang.