[Problem]Homepage error!

Page 1 of 2 1 2
04/22/2013 14:12 HDesign#1
hi ,
i installed homepage script
and i go to
[Only registered and activated users can see links. Click Here To Register...] (the website)

and this problem :)

[Only registered and activated users can see links. Click Here To Register...]

can you fix this problem ?
04/22/2013 14:46 .Tobias#2
Can you maybee show us the Code on Line 16 ?
04/22/2013 15:35 HDesign#3
yes

[Only registered and activated users can see links. Click Here To Register...]

:)
04/22/2013 15:46 Descended.#4
Is the IP adress : 25.127.15.131
Right ?
04/22/2013 16:02 HDesign#5
yes
04/22/2013 16:32 Spartan#117#6
The IP address should be wrapped with ' ' or " " Tags, cause it's a string. (same for user, password and every other string)

Replace lines 15 and 16 with this:
PHP Code:
$sqlHp = mysql_connect('localhost', 'root', '1234')
$sqlServ = mysql_connect('25.127.15.131', 'db_manage', 'signe') 
04/22/2013 16:43 HDesign#7
not fixed
04/22/2013 16:48 Spartan#117#8
A little more information would be helpful.

What error appears now? The error you had should be fixed with my code above.
04/22/2013 16:56 HDesign#9
[Only registered and activated users can see links. Click Here To Register...]
04/22/2013 17:21 Spartan#117#10
Try replacing line 15 and 16 with this code:
PHP Code:
$sqlHp = mysql_connect('localhost', 'root', '1234');
$sqlServ = mysql_connect('25.127.15.131', 'db_manage', 'signe'); 
I forgot the semicolon at the end of each line, sorry.
04/22/2013 17:30 HDesign#11
fixed :)
but new problem :D

[Only registered and activated users can see links. Click Here To Register...]
04/22/2013 17:44 Spartan#117#12
Your MySQL user is not allowed to connect to the gameserver database. That is normal, because the gameserver user is only allowed to connect from localhost.

In my opinion this is the best way to solve this problem:

Create a new mysql user on the gameserver database and allow connections from every host.
Run these querys on the gameserver database:
Warning: Replace USERNAME and PASSWORD with your new username and password and make sure that you use a strong password!
Code:
CREATE USER 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD';
Give the rights to the user:
Again, replace USERNAME with your created user
Code:
GRANT ALL ON account.* TO 'USERNAME'@'%';
GRANT ALL ON common.* TO 'USERNAME'@'%';
GRANT ALL ON hotbackup.* TO 'USERNAME'@'%';
GRANT ALL ON log.* TO 'USERNAME'@'%';
GRANT ALL ON player.* TO 'USERNAME'@'%';
Reload the privileges:
Code:
FLUSH PRIVILEGES;
Replace the username and password of the gameserver-connection in your website on line 16:
PHP Code:
$sqlServ = mysql_connect('25.127.15.131', 'USERNAME', 'PASSWORD'); 
04/22/2013 18:40 HDesign#13
i can't type @ :(


why
04/22/2013 20:13 Spartan#117#14
Where are you typing those Querys? They should be executed in Navicat or another SQL-Client.
04/22/2013 20:27 HDesign#15
where can i type this ?
i type in console (BSD)
Page 1 of 2 1 2