Help Connect Server With Site - Status

Fizo · May 20, 2016

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 · May 20, 2016

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 · May 20, 2016

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 · May 20, 2016

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 · May 20, 2016

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 · May 20, 2016

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

Fizo · May 20, 2016

did i need new mysql ? cause i am with 5.1

๖ۣۜYoung ๖ۣۜthug · May 20, 2016

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 · May 20, 2016

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 · May 20, 2016

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 · May 20, 2016

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

๖ۣۜYoung ๖ۣۜthug · May 20, 2016

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 · May 20, 2016

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 · May 20, 2016

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 · May 20, 2016

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 · May 20, 2016

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 !

Help Connect Server With Site - Status

Question

Link to comment

Share on other sites

30 answers to this question

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Posts

Topics