buenas a todos y espero que puedan ayudarme..
mi problema es el siguiente...
tengo una base de datos en mi computadora y quiero consultar desde mi hosting hacia ella...
el dilema esta en que cuando lo pruevo de forma local todo anda bien.. muetra los datos y demas... pero cuando subo los scripts a el servidor no andan las consultas no muestra los datos... que me recomiendan....
Código:
<?php
$L2JBS_config["mysql_host"]="190.xxxx.xx2.50"; // MySQL Host ["localhost"]
$L2JBS_config["mysql_port"]="3306"; // MySQL Port ["3306"]
$L2JBS_config["mysql_db"]="l2jdb"; // MySQL Database ["l2jdb"]
$L2JBS_config["mysql_login"]="root"; // MySQL User ["root"]
$L2JBS_config["mysql_password"]=""; // MySQL Password ["root"]
$LIMIT="60"; // TOP PAGE LIMIT
$OBJ_ID="obj_Id"; // Characters Table object id field name
$ACCS_LVL="accesslevel"; // Characters Table access level field name
$minenchant="5"; // Safe Enchant of Server
$maxenchant="20"; // Max Enchant of Server
$ETCITEMS="4037,57"; // Top Items Ids
$MAX_ACCESS="200"; // Full Access level
$EGM_ACCESS="150"; // Event GM Access level
$NORMAL_ACCESS="100"; // Normal GM Access level
include("_config_procs.php");
error_reporting(0);
?>
Código:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>GameMasters Script By Leki</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style type="text/css">
<!--
body,td,th {
color: #CCCCCC;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
body {
background-color: #000000;
}
-->
</style>
</head>
<body>
<table style="border: 1px solid; border-color: #444444; background-color:#222222;" align="center" width="100%">
<tr>
<th class='Stil7' colspan="5" align="center" width="100%">Top 100 PK</th>
</tr>
<tr>
<th width="1%" style="border: 1px solid; border-color: #444444; background-color:#222222;">ID</th>
<th width="10%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> GM Name </th>
<th width="2%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Level </th>
<th width="6%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Access Level </th>
<th width="6%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Status </th>
</tr>
<?php
require("Config.php");
$activity = mysql_query("SELECT characters.char_name, characters.$OBJ_ID, characters.char_name, characters.level, characters.online, characters.$ACCS_LVL as access
FROM characters WHERE characters.$ACCS_LVL >= 1
ORDER BY characters.$ACCS_LVL DESC LIMIT $LIMIT");
$i = 1;
while($row = mysql_fetch_array($activity))
{
if (!($i%2)) echo "<tr bgcolor='#000000' align='center'>";
else
echo "<tr bgcolor='#161616' align='center'>";
echo "<td>"."<center>".$i."</center>"."</td>";
echo "<td>"."<center>".$row['char_name']."</center>"."</td>";
echo "<td>"."<center>".$row['level']."</center>"."</td>";
if ($row['access'] == $MAX_ACCESS)
echo "<td>"."<center>FULL GM</center>"."</td>";
else if ($row['access'] == $EGM_ACCESS)
echo "<td>"."<center>Event GM</center>"."</td>";
else
echo "<td>"."<center>Normal GM</center>"."</td>";
if ($row['online'] == 1)
echo "<td>"."<center>Online</center>"."</td>";
else
echo "<td>"."<center>Offline</center>"."</td>";
$i++;
}
?>
</table>
</body>
</html>