Jump to content
  • 0

Connect Server With Site - Status


Fizo

Question

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 ? 

Link to comment
Share on other sites

Recommended Posts

  • 0

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".

Link to comment
Share on other sites

  • 0

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 !

Link to comment
Share on other sites

  • 0

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.
Link to comment
Share on other sites

  • 0

 

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

Link to comment
Share on other sites

  • 0

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 

Link to comment
Share on other sites

  • 0

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 

Link to comment
Share on other sites

  • 0

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();
}
?>
Link to comment
Share on other sites

  • 0

 

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:

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

  • 0

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 !

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now


×
×
  • Create New...