Help Website, Raid Map need help

remigas · July 30, 2018

Hello guys, sorry if i post is wrong section, but i need help with web coding, i upload to my web LIVE RAID MAP, i use ACIS, i make new SQL for raid names so i have names on map, but all Grand Bosses map shows DEAD. Can anyone give me advice how to fix this please.

I upload code below :

Quote

<html>
<head>
<body bgcolor="#000000" text="lime" link="#009933" vlink="#009933" padding="0" leftmargin="0">
<font size="2">
<TITLE>Live Raid Boss Map</TITLE>

<script>

</script>

</head>
<?php
include"connection.php";
?>
<?php
$query_raidbosses=mysql_query("SELECT boss_id,loc_x,loc_y,loc_z,respawn_time FROM raidboss_spawnlist");
$query_grandboss=mysql_query("SELECT boss_id,loc_x,loc_y,loc_z,respawn_time FROM grandboss_data");
$online= mysql_num_rows($query_raidbosses);
$online2= mysql_num_rows($query_grandboss);
echo "<div style=position:absolute;top:0px;left:0px><img src=IL.jpg></div>";
while ($res=mysql_fetch_array($query_raidbosses))
{
   $id=$res['boss_id'];
   $valx=$res['loc_x'];
   $valy=$res['loc_y'];
   $valz=$res['loc_z'];
   $respawn=$res['respawn_time'];
   $boss_name=mysql_query("SELECT boss_name FROM bossmap WHERE id='$id'");
   $name = mysql_fetch_row( $boss_name );
   $boss_level=mysql_query("SELECT boss_level FROM bossmap WHERE id='$id'");
   $level = mysql_fetch_row( $boss_level );

$x=116+($valx+107823)/200;
$y=2580+($valy-255420 )/200;

if($respawn == "0")
   echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=3.png title=\"(RaidBoss) $name[0] $level[0]lvl Alive!\"></div><center>";
else
   echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=0.png title=\"(RaidBoss) $name[0] $level[0]lvl Dead!\"></div><center>";
   }
while ($res=mysql_fetch_array($query_grandboss))
{
   $id=$res['boss_id'];
   $valx=$res['loc_x'];
   $valy=$res['loc_y'];
   $valz=$res['loc_z'];
   $respawn=$res['respawn_time'];
   $boss_name=mysql_query("SELECT boss_name FROM bossmap WHERE id='$id'");
   $name = mysql_fetch_row( $boss_name );
   $boss_level=mysql_query("SELECT boss_level FROM bossmap WHERE id='$id'");
   $level = mysql_fetch_row( $boss_level );

$x=116+($valx+107823)/200;
$y=2580+($valy-255420 )/200;

if($respawn == "0")
   echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=3.png title=\"(GrandBoss) $name[0] $level[0]lvl Alive!\"></div><center>";
else
   echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=0.png title=\"(GrandBoss) $name[0] $level[0]lvl Dead!\"></div><center>";
   }
mysql_close();
?>

Edited July 30, 2018 by remigas

tazerman2 · July 31, 2018

maybe is not connect to mysql;

you have create db user for can connect site -> server ? for can take info from mysql

DenArt Designs · July 31, 2018

first we have 2018 please use PDO cause mysql is deprecated.

second google "inner join" table to get from the grand boss data the time they need to respawn or 0 that means alive if you want it in 1 query.

or just combine id's from 2 queries and respawn time

wongerlt · July 31, 2018

just check results with, example print_r $row...

and me suggestion dont use web and game server in same server. Use cronjobs for data update, example every 5min.

Help Website, Raid Map need help

Question

remigas

3 answers to this question

Recommended Posts

tazerman2

DenArt Designs

wongerlt

Create an account or sign in to comment

Create an account

Sign in

Posts

Topics

Browse

Activity

Store