Guide/Release: Conquer Server (CoFuture) Using MySql!

leavemealone · 12/04/2007, 16:38

Well theres a complete answer for you, Korvacs did the guild system.

yotop456 · 12/04/2007, 22:16

OK i got my auto save feature to work once, meaning when i log on with a character and move around and disconnect it will save its position, but when i log back on the server does not save the characters position anymore although it says it does, unless i restart the server.
Here is the code im using in start.cs (start.cs has 2 buttons added, 1 to enable, other to disable timer(autosave).)

private void saveon_Click(object sender, EventArgs e)
{
timer1.Enabled = true; //enables timer
Console.WriteLine("Autosave enabled");

}

private void timer1_Tick(object sender, EventArgs e)
{
COClient Client = null;
foreach (COServer.AuthServerPackets.AuthRequest.AuthBinder AB in GameClients.Values)
{

string User = Client.Account + ": " + Client.Char.Name;

Database.UpdateCharPosition(Client);
Database.UpdateCharMoney(Client);

Console.WriteLine("Server System: " + Client.Char.Name + " has been autosaved successfully");

}

}

private void saveoff_Click(object sender, EventArgs e)
{
timer1.Enabled = false;
Console.WriteLine("Autosave Disabled");
}
}
}

Any ideas?

[GMs] · 12/05/2007, 01:25

I don't know why I can't build solution.
I am using both C# 2005 & 2008
Can you send me a release with my database information.
username: root
password: kingjr1992
database name: conquer_server

Cane · 12/05/2007, 01:29

Quote:

Originally Posted by [GMs]

I don't know why I can't build solution.
I am using both C# 2005 & 2008
Can you send me a release with my database information.
username: root
password: kingjr1992
database name: conquer_server

I kinda had the same problem with this you want to make sure you are opening the CoFusion Project file then when that opens in C# you can click on the database.cs it will open edit there. If you just open the database.cs with out open the project then you can not build the soultion

Cane · 12/05/2007, 01:34

ok I got my sever up and running now. I download the patch for 4348 and installed it on my co folder. when I go to connect to the sever my Co freezes and my sever is not showing a connection coming in so I am I guess my sever.dat is wrong I am using a router so in Php I input my severip as 192.168.1.100 and on my sever dat I am using my wireless modem ip which is 74.**.***.** is that the right way to do it or any I inputin the wrong ip's Can some one show me a screen shot of how they added the sever in php to make sure I am editing it right or explane. or have any other suggestion to as why my Co is freezing and my sever is not showing the incoming cennection?

THanks

IHateHomos · 12/05/2007, 02:02

Yeah i had some problems with it.. Not sure how to help you though

yotop456 · 12/05/2007, 03:08

Quote:

Originally Posted by [GMs]

I don't know why I can't build solution.
I am using both C# 2005 & 2008
Can you send me a release with my database information.
username: root
password: kingjr1992
database name: conquer_server

I compiled the source for you with your data its in the bin directory of the file i uploaded.

marhazk2 · 12/05/2007, 04:41

Quote:

Originally Posted by Cane

ok I got my sever up and running now. I download the patch for 4348 and installed it on my co folder. when I go to connect to the sever my Co freezes and my sever is not showing a connection coming in so I am I guess my sever.dat is wrong I am using a router so in Php I input my severip as 192.168.1.100 and on my sever dat I am using my wireless modem ip which is 74.**.***.** is that the right way to do it or any I inputin the wrong ip's Can some one show me a screen shot of how they added the sever in php to make sure I am editing it right or explane. or have any other suggestion to as why my Co is freezing and my sever is not showing the incoming cennection?

THanks

trust me,u have to enable the forwarding system, or/then forward the ip & port.

leavemealone · 12/05/2007, 04:52

yes, marhazk is right. you must enabled the ports 9958 & 9960

Cane · 12/05/2007, 05:19

OK in my router I have 9958 and 9960 open and forwarding I have my sever.dat set up as 192.168.1.100 and in my Php my sever is set as 192.168.1.100 such as my ipconfig says. I am still getting the same problem My sever is up and running and I am running a Co Client with patch 4348 and then in the Verison.dat I have put in 9999 so it won't auto patch I just edited the first sever on my list to 192.168.1.1000 and the port is set as 9958 so I am guessing that doesn't have to change any other suggestion?

marhazk2 · 12/05/2007, 05:41

Here's, before that check this:

Code:

1) Open http://localhost/phpmyadmin, go to conquer_server database, go to "servers" table, make sure you set your server name and ip (74.*.*.* if you're allow any incoming gamers from the internet or LAN IP 192.* if you're allow any incoming gamers from the same LAN or office/home networking)
2) In Server.Dat, use a real 74.*.*.* ip (e.g 74.1.42.51), based on what you typed in your conquer_server Database.
3) Forwarding port enabled, open your router's web settings, http://192.168.1.1 or idk what ip is it, set the port and ip.
4) set your windows firewall, you can even OFF it if u want, otherwise, portforward it.

Cane · 12/05/2007, 08:27

Quote:

Originally Posted by marhazk2

Here's, before that check this:

Code:

1) Open http://localhost/phpmyadmin, go to conquer_server database, go to "servers" table, make sure you set your server name and ip (74.*.*.* if you're allow any incoming gamers from the internet or LAN IP 192.* if you're allow any incoming gamers from the same LAN or office/home networking)
2) In Server.Dat, use a real 74.*.*.* ip (e.g 74.1.42.51), based on what you typed in your conquer_server Database.
3) Forwarding port enabled, open your router's web settings, http://192.168.1.1 or idk what ip is it, set the port and ip.
4) set your windows firewall, you can even OFF it if u want, otherwise, portforward it.

Just To show I am not just not listening to every one which I am and I am SO THANKFULL FOR THE GUILDE IT IS ASOME BTW I just wanted to add screen shots of everything to show what I have done and still having the same problem I Took My POS Router out of the picture too and used windows firewall to port forward so here are the screen shots see if i am doing anything wrong and maybe if somthing could just be messed up in my database or somthing

This is PHP Sever Ip

THis is PORT 9960

This is POrt 9958

This is Sever dat

This is Database line 39 40 and 44

IF any one can help me or would like to email call me or anything to get this up and running I am willing TO PAY To get this to work I have so Many friends that want my privite sever to work I am willing to pay who ever that wants to walk me though this or to help me over the phone or Im It dosen't matter to me I would SO Rather pay some one real cash to get this to work then Watch DB BUYERS Rule another Sever. I don't want to take credit for other peoples work by saying I made it or anything Hell I will name the sever after the person who helps I just want to have a working privite sever

THanks

add me or email me or post here.
THanks again for the awsome posting and to all who have been helping me though this I know Every one is probally like calling me a dumb ass BUt I prosime I am going over and over trying every option I can think of to why this isn't working I have download Qconquer client and tryed with that and my regural CO client with patch 4348, I am just lost now I have tryed with the router and using ip 192.168.1.100 on my php and on my sever.dat and I have tried doing php as my regural ip 74.60.216.40 and my sever dat as 74.60.216.40 I have tryed php as 74.60.216.40 and sever dat as 192.168.1.100 and have tryed php as 192.168.1.100 and my sever dat as 74.60.216.40.

So Yea i think that is about it . I am sorry for the long post but I wanted to make sure I get all information out there I can think of to solve this problem
THanks again for all and any help that can be provided

leavemealone · 12/05/2007, 08:51

If you are using "192.168.1.100" in your server.dat then "192.168.1.100" should be in the database also, the server name must be "konker" in the server.dat & the database.

Cane · 12/05/2007, 15:38

OK the 192.168.1.100 has been tried. I will try changing the name of the of the sever in the sever.dat again but you say database. Do you mean on php or the database.cs and do I need to input any ip's or other information into the project.cs or the databse.cs as in Ip's or sever name?

leavemealone · 12/05/2007, 16:49

i mean mysql database (php)