Help Connect Server With Site - Status

[Fizo]

Hi from me !!!

 

I am new to that , i wanna connect site with the server so the first step it to take a hosting ! 

 

i took hosting with cpanel ! then cpanel > Remote MySQL > Then i enter my IP 

 

Also in my Navicat i made a new User with my ip Also a custom User.

 

What infos i need to enter inside of script ?

 

My Own ip or dedicated ip from host company ? 

[DrenepiaWorld]

You have to create on your server machine a user with the ip from your web hosting and then on the script you have to add the sql informations from your server machine. I mean the new user informations ip,user,pass but i don't recommend at all to use scripts on website if you have some knowledge on how to protect these files cause your db informations will be "public".

[Fizo]

all i need for now is to test something ! so i already made a user

 

Example on my Navicat 

 

User Name : root

Host : 192.x.x.x (Example IP )

Password : root

Confirm Password : root

 

and then i go to cpanel enter this ip to Remote MySQL .

 

After on script then i enter my " Gamserver IP " Also the custom User they doesnt set the script on ! 

 

Also i give permission to database like Insert and etc !

[DrenepiaWorld]

well i never added the ip to remote mysql or something on web hosting just the ip/user/pass on the scripts and the user i told you and it works

[Fizo]

i think i've done it right ... when i insert the script ! i took an error 

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

[DrenepiaWorld]

if it was problem from the script you would see an error for trying to connect with mysql

[Fizo]

did i need new mysql ? cause i am with 5.1

[๖ۣۜYoung ๖ۣۜthug]

 

i think i've done it right ... when i insert the script ! i took an error 

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

share the code here

[Fizo]

Coonect.php

<?php
$conexao = mysql_connect('85.75.242.43','root','root') or die (mysql_error());
$banco = mysql_select_db('gve', $conexao) or die(mysql_error());
$end = '127.0.0.1';	# Endereηo ou IP do seu site sem o 'http://www.', escreva assim: 'seusite.com.br' ou '200.145.221.89'
$nomedosite = '';

?>

PvP.php

<div style="width:525px; float:left;">
	<div id="rank_borda" style="width:30px;">
		#
	</div>
	<div id="rank_borda" style="width:145px;">
		Nome
	</div>
	<div id="rank_borda" style="width:140px;">
		Clan
	</div>
	<div id="rank_borda" style="width:120px;">
		Classe
	</div>
	<div id="rank_borda" style="width:65px;">
		PvP
	</div>
</div>
<?php
$i = 1;
$sql = mysql_query("SELECT char_name,pvpkills,IF((SELECT clan_name FROM clan_data WHERE c.clanid = clan_id) IS NULL, 'n/a', (SELECT clan_name FROM clan_data WHERE c.clanid = clan_id)) AS clan, SUBSTRING_INDEX((SELECT class_name FROM class_list WHERE id = c.base_class), '_', -1) AS class FROM characters AS c WHERE accesslevel = '0' ORDER BY pvpkills DESC, char_name ASC LIMIT 25")  or die (mysql_error());
while($res = mysql_fetch_array($sql)){
	switch ($i)
	{
		case 1: $img = "<img src=\"images/1.gif\" title=\"1º Lugar\">"; break;
		case 2: $img = "<img src=\"images/2.gif\" title=\"2º Lugar\">"; break;
		case 3: $img = "<img src=\"images/3.gif\" title=\"3º Lugar\">"; break;
		default: $img = $i."º"; break;
	}
?>
<div id="linha_rank">
	<div id="rank_borda" style="width:30px;">
		<?php echo $img; ?>
	</div>
	<div id="rank_borda" style="width:145px;">
		<?php echo $res["char_name"]; ?>
	</div>
	<div id="rank_borda" style="width:140px;">
		<?php echo $res["clan"]; ?>
	</div>
	<div id="rank_borda" style="width:120px;">
		<?php echo $res["class"]; ?>
	</div>
	<div id="rank_borda" style="width:65px;">
		<?php echo number_format($res["pvpkills"],0,'.','.'); ?>
	</div>
</div>
<?php
$i++;
}
?>

This is an example ! i failed to made active more than 5 scripts 

[๖ۣۜYoung ๖ۣۜthug]

Coonect.php

<?php
$conexao = mysql_connect('85.75.242.43','root','root') or die (mysql_error());
$banco = mysql_select_db('gve', $conexao) or die(mysql_error());
$end = '127.0.0.1';	# Endereηo ou IP do seu site sem o 'http://www.', escreva assim: 'seusite.com.br' ou '200.145.221.89'
$nomedosite = '';

?>

PvP.php

<div style="width:525px; float:left;">
	<div id="rank_borda" style="width:30px;">
		#
	</div>
	<div id="rank_borda" style="width:145px;">
		Nome
	</div>
	<div id="rank_borda" style="width:140px;">
		Clan
	</div>
	<div id="rank_borda" style="width:120px;">
		Classe
	</div>
	<div id="rank_borda" style="width:65px;">
		PvP
	</div>
</div>
<?php
$i = 1;
$sql = mysql_query("SELECT char_name,pvpkills,IF((SELECT clan_name FROM clan_data WHERE c.clanid = clan_id) IS NULL, 'n/a', (SELECT clan_name FROM clan_data WHERE c.clanid = clan_id)) AS clan, SUBSTRING_INDEX((SELECT class_name FROM class_list WHERE id = c.base_class), '_', -1) AS class FROM characters AS c WHERE accesslevel = '0' ORDER BY pvpkills DESC, char_name ASC LIMIT 25")  or die (mysql_error());
while($res = mysql_fetch_array($sql)){
	switch ($i)
	{
		case 1: $img = "<img src=\"images/1.gif\" title=\"1º Lugar\">"; break;
		case 2: $img = "<img src=\"images/2.gif\" title=\"2º Lugar\">"; break;
		case 3: $img = "<img src=\"images/3.gif\" title=\"3º Lugar\">"; break;
		default: $img = $i."º"; break;
	}
?>
<div id="linha_rank">
	<div id="rank_borda" style="width:30px;">
		<?php echo $img; ?>
	</div>
	<div id="rank_borda" style="width:145px;">
		<?php echo $res["char_name"]; ?>
	</div>
	<div id="rank_borda" style="width:140px;">
		<?php echo $res["clan"]; ?>
	</div>
	<div id="rank_borda" style="width:120px;">
		<?php echo $res["class"]; ?>
	</div>
	<div id="rank_borda" style="width:65px;">
		<?php echo number_format($res["pvpkills"],0,'.','.'); ?>
	</div>
</div>
<?php
$i++;
}
?>

This is an example ! i failed to made active more than 5 scripts 

pvp.php is wrong 

[Fizo]

they will not work ? also what about mysql 5.1 i need to upgrade them ?

[๖ۣۜYoung ๖ۣۜthug]

they will not work ? also what about mysql 5.1 i need to upgrade them ?

No it will not work try another code or try fix it

[Fizo]

Other Example was that !

<?php
/***
***/
define('HOST','localhost');
define('DB_NAME','web');
define('USUARIO','root');
define('PASSWORD','');

//Porta Padrão L2J 3306
define('PORT','3306');

//CONEXÃO
try{
	$conexao_PDO = new PDO('mysql:host='.HOST.';dbname='.DB_NAME.';port='.PORT, USUARIO, PASSWORD);
	$conexao_PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}catch(PDOExepetion $msg_erro){
	echo $msg_erro->GetMessage();
}
?>

with this !

<?php
/***
***/
include('conexao_PDO.php');

//Valor Minimo para realizar a SOMA ( Player FAKE )
$var_min_soma = 3;

//Valor da soma, (Player Fake)
$var_soma = 10;

$buscar_player_on = $conexao_PDO->prepare("SELECT online FROM characters WHERE online = '1'");
$buscar_player_on->execute();

if($buscar_player_on->RowCount() >= $var_min_soma){
	$resultado = $buscar_player_on->RowCount() + $var_soma;
	
	//Exibir
	echo $resultado;
}else{
	echo $buscar_player_on->RowCount();
}
?>

[๖ۣۜYoung ๖ۣۜthug]

 

Other Example was that !

<?php
/***
***/
define('HOST','localhost');
define('DB_NAME','web');
define('USUARIO','root');
define('PASSWORD','');

//Porta Padrão L2J 3306
define('PORT','3306');

//CONEXÃO
try{
	$conexao_PDO = new PDO('mysql:host='.HOST.';dbname='.DB_NAME.';port='.PORT, USUARIO, PASSWORD);
	$conexao_PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}catch(PDOExepetion $msg_erro){
	echo $msg_erro->GetMessage();
}
?>

with this !

<?php
/***
***/
include('conexao_PDO.php');

//Valor Minimo para realizar a SOMA ( Player FAKE )
$var_min_soma = 3;

//Valor da soma, (Player Fake)
$var_soma = 10;

$buscar_player_on = $conexao_PDO->prepare("SELECT online FROM characters WHERE online = '1'");
$buscar_player_on->execute();

if($buscar_player_on->RowCount() >= $var_min_soma){
	$resultado = $buscar_player_on->RowCount() + $var_soma;
	
	//Exibir
	echo $resultado;
}else{
	echo $buscar_player_on->RowCount();
}
?>

This looks better but your database will be visible to all people who will visit your website by view source.They will log on ur database and take admin access :happyforever:

[DrenepiaWorld]

The first one didn't had db name at all so it can't connect ofc

 

This looks better but your database will be visible to all people who will visit your website by view source.They will log on ur database and take admin access :happyforever:

he can only give access to the site by creating a new user as i mentioned before, but still someone with knowledge can harm his db anyway

[Fizo]

i know about db but i need to found a way to connect my site with server ! did i need to open a 3306 as a port ! also if i am right with Remote MySQL i can connect them easy !