Database issue.....

[buzz2289]

Ok now as some of you may know i am new to running a Private server, but here is my issue, i have a working server, and files now with the mysqladmin that came with them, i can run the ACC, MSG, and NPC just fine, but heres where i hit a wall: linking my PHP register site, it gave me the failed to connect error so i read up on some forums and upgraded my "MySQL" to 5.1, now the fun gets better, now the site works perfect, register, top player, pet, legions, and all that but i cannot run my ACC, NPC, and MSG with MySQL 5.1, can someone describe to me how to have them both running on the same DB? i have two Computers if that helps all thanks appreciated!

[WolvesMaster]

just use the normal mysql and try to use this config for your website.

<?php
	require_once './inc/class.captcha.php';
	// Configurations
	$myhost="localhost";
	$mypass="[COLOR="DarkGreen"]test[/COLOR]"; 		//your server login password
	$myuser="[COLOR="DarkGreen"]root[/COLOR]"; 		//your server login username
	$mydbacc="account";		//your server account database
	$mydbdata="my";			//your server my database name
	$serveraddress="[COLOR="DarkGreen"]your server IP[/COLOR]"; 	//your server ip
	$serverport=5816;		//your server connection port
	$mydb="my";			//your server my database
        $servername = "[COLOR="DarkGreen"]Server Name[/COLOR]";   //Put your servername here.
        $link = "http://www.google.com.eg/";   //Put your website link here

	// Dont Edit after this
	mysql_connect($myhost,$myuser,$mypass);
	mysql_select_db($mydb);
?>

edit your configs like the IPs,Server name and the same username and password like the server configs and give it another try

[buzz2289]

Warning: mysql_connect() [function.mysql-connect]: Connecting to 3.22, 3.23 & 4.0 is not supported. Server is 4.0.18-nt in C:\xampp\htdocs\config.php on line 16

This is my error from my site: 97.86.21.32

I have put my config.ini below

<?php
require_once './inc/class.captcha.php';
// Configurations
$myhost="localhost";
$mypass="test"; //your server login password
$myuser="root"; //your server login username
$mydbacc="my"; //your server account database
$mydbdata="my"; //your server my database name
$serveraddress="5.30.50.9"; //your server ip
$serverport=5816; //your server connection port
$mydb="my"; //your server my database
$servername = "Buzzed-Online"; //Put your servername here.
$link = "97.86.21.32"; //Put your website link here

// Dont Edit after this
mysql_connect($myhost,$myuser,$mypass);
mysql_select_db($mydb);
?>

Could i just downgrade my PHP in XAMPP?

[WolvesMaster]

this is the error

$mydbacc="my"; //your server account database

because it must be like that

$mydbacc="account"; //your server account database

just copy my config in my above reply and edit it the IP,server name and DB username & password.

[buzz2289]

nope it is still the same, i dont have an "account" DB mine are:"my" "mysql" and "test" the account is a table in "my"


If it makes a difference im using the database and serverfiles from ChaosOnline that was posted here

[WolvesMaster]

anyway just send me your e-mail in a pm and i will help you it's not hard

[idlemonkey]

this is not your problem though the problem is you are using two incompatible versions of software msyql and phpmyadmin change your version of xamp to 1.7.1 or lower or change your phpmyadmin folder out for a lesser version

[buzz2289]

thanks to idle monkey i downgraded to 1.7.0 and it works 100% i hit thanks you are awesome bro!!!

One more question, how come "payers online" says -2 online? that is the only issue i have left