Database issue.....

02/02/2012 03:50 buzz2289#1

:rtfm: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!

02/02/2012 15:33 WolvesMaster#2

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

Code:

<?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

02/02/2012 18:52 buzz2289#3

Quote:

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

Quote:

<?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?

02/02/2012 20:49 WolvesMaster#4

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.

02/02/2012 21:24 buzz2289#5

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

02/02/2012 23:08 WolvesMaster#6

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

02/02/2012 23:49 idlemonkey#7

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

02/03/2012 01:52 buzz2289#8

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