Fizo Posted May 20, 2016 Share Posted 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 ? Quote Link to comment Share on other sites More sharing options...
0 DrenepiaWorld Posted May 20, 2016 Share Posted 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". Quote Link to comment Share on other sites More sharing options...
0 Fizo Posted May 20, 2016 Author Share Posted 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 ! Quote Link to comment Share on other sites More sharing options...
0 DrenepiaWorld Posted May 20, 2016 Share Posted 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 Quote Link to comment Share on other sites More sharing options...
0 Fizo Posted May 20, 2016 Author Share Posted 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. Quote Link to comment Share on other sites More sharing options...
0 DrenepiaWorld Posted May 20, 2016 Share Posted May 20, 2016 if it was problem from the script you would see an error for trying to connect with mysql Quote Link to comment Share on other sites More sharing options...
0 Fizo Posted May 20, 2016 Author Share Posted May 20, 2016 did i need new mysql ? cause i am with 5.1 Quote Link to comment Share on other sites More sharing options...
0 ๖ۣۜYoung ๖ۣۜthug Posted May 20, 2016 Share Posted 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 Quote Link to comment Share on other sites More sharing options...
0 Fizo Posted May 20, 2016 Author Share Posted 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 Quote Link to comment Share on other sites More sharing options...
0 ๖ۣۜYoung ๖ۣۜthug Posted May 20, 2016 Share Posted 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 Quote Link to comment Share on other sites More sharing options...
0 Fizo Posted May 20, 2016 Author Share Posted May 20, 2016 they will not work ? also what about mysql 5.1 i need to upgrade them ? Quote Link to comment Share on other sites More sharing options...
0 ๖ۣۜYoung ๖ۣۜthug Posted May 20, 2016 Share Posted 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 Quote Link to comment Share on other sites More sharing options...
0 Fizo Posted May 20, 2016 Author Share Posted 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(); } ?> Quote Link to comment Share on other sites More sharing options...
0 ๖ۣۜYoung ๖ۣۜthug Posted May 20, 2016 Share Posted 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: Quote Link to comment Share on other sites More sharing options...
0 DrenepiaWorld Posted May 20, 2016 Share Posted 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 Quote Link to comment Share on other sites More sharing options...
0 Fizo Posted May 20, 2016 Author Share Posted 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 ! Quote Link to comment Share on other sites More sharing options...
Question
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 ?
Link to comment
Share on other sites
30 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.