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>