HOW TO CONVERT THIS TO ODBC CONNECTION.
CAUSE IF I USE ODBC CONNECTION IT DOESN'T LOAD CORRECTLY.Code:<!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">
<? require("CastleSiege/message.php");
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Documento sin título</title>
<style type="text/css">
#InfoGt {color:<? echo $Informacion; ?>; text-align: <? echo $InformacionAlign; ?>; font-size:<? echo $InformacionSize; ?>}
#GuilDueño {color:<? echo $Guild; ?>; text-align: <? echo $GuildAlign; ?>;}
#MasterGuild {color:<? echo $Master; ?>; text-align: <? echo $MasterAlign; ?>;}
#LevelMaster {color:<? echo $Level; ?>; text-align: <? echo $LevelAlign; ?>;}
#ResetMaster {color:<? echo $Reset; ?>; text-align: <? echo $ResetAlign; ?>;}
#NivelMaster {color:<? echo $Nivel; ?>; text-align: <? echo $NivelAlign; ?>;}
#PaisMaster {text-align: <? echo $PaisAlign; ?>;}
#LogoGuild {text-align: <? echo $LogoAlign; ?>;}
#ScoreGuild {color:<? echo $Score; ?>; text-align: <? echo $ScoreAlign; ?>;}
#AsistenteGuild {color:<? echo $Asistente; ?>; text-align: <? echo $AsistenteAlign; ?>;}
#BatalladorGuild {color:<? echo $Batallador; ?>; text-align: <? echo $BatalladorAlign; ?>;}
#MensajeLetra {color:<? echo $Mensaje; ?>; text-align: <? echo $MensajeAlign; ?>; font-size:<? echo $MensajeSize; ?>;}
#Etapas {color:<? echo $ModuloPrinColor; ?>}
.FondoModulo {
background: <? echo $Modulo; ?>;
-webkit-border-radius: .3em;
-moz-border-radius: .3em;
border-radius: .3em;
-webkit-box-shadow: 0 1px 2px rgba(0,0,0,.2);
-moz-box-shadow: 0 1px 2px rgba(0,0,0,.2);
box-shadow: 0 1px 2px rgba(0,0,0,.2);
}
.Degradado {
color:<? echo $DegradadoColorLetra; ?>;
text-align: <? echo $DegradadoAlignLetra; ?>;
border: solid 1px <? echo $DegradadoBorde; ?>;
background: <? echo $DegradadoColor1; ?>;
background: -webkit-gradient(linear, left top, left bottom, from(<? echo $DegradadoColor2; ?>), to(<? echo $DegradadoColor1; ?>));
background: -moz-linear-gradient(top, <? echo $DegradadoColor2; ?>, <? echo $DegradadoColor1; ?>);
filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='<? echo $DegradadoColor2; ?>', endColorstr='<? echo $DegradadoColor1; ?>');
}
.ModuloPrincipal {
color: <? echo $ModuloPrinColor; ?>;
background: <? echo $ModuloPrinFondo; ?>;
text-align:<? echo $ModuloPrinAlign; ?>;
}
.ModuloPrincipal:hover{background: <? echo $ModuloPrinHover ; ?>; text-align:<? echo $ModuloPrinHoverAlign; ?>;}
.ModuloPrincipal:active{background: <? echo $ModuloPrinHover ; ?>; text-align:<? echo $ModuloPrinHoverAlign; ?>;}
.trhover {color: #666666;
background: #FFFFFF;
text-align:center;
}
.footer_font {
font: normal 11px Tahoma, Calibri, Verdana, Geneva, sans-serif;
color: #FFF;
}
-->
</style>
</head>
<?
$SiegeInfo = mssql_fetch_row(mssql_query("SELECT OWNER_GUILD,MONEY,TAX_RATE_CHAOS,TAX_RATE_STORE,TAX_HUNT_ZONE,SIEGE_START_DATE,SIEGE_END_DATE FROM MuOnline.dbo.MuCastle_DATA"));
$GuilDueño = $SiegeInfo[0];
$Money = $SiegeInfo[1];
$Chaos = $SiegeInfo[2];
$Store = $SiegeInfo[3];
$Hunt = $SiegeInfo[4];
$GuildInfo = mssql_fetch_row(mssql_query("SELECT G_Master,G_Mark,G_Score,G_Name FROM MuOnline.dbo.Guild WHERE G_Name = (SELECT OWNER_GUILD FROM MuOnline.dbo.MuCastle_DATA)"));
$MasterGuild = $GuildInfo[0];
$LogoGuild = urlencode(bin2hex($GuildInfo[1]));
$ScoreGuild = $GuildInfo[2];
$MasterInfo = mssql_fetch_row(mssql_query("SELECT Resets,cLevel,AccountID FROM MuOnline.dbo.Character WHERE Name='".$MasterGuild."'"));
$ResetsMaster = $MasterInfo[0];
$LevelMaster = $MasterInfo[1];
$AccountMaster = $MasterInfo[2];
$NivelMasterInfo = mssql_fetch_row(mssql_query("SELECT $TablaNivelMaster FROM MuOnline.dbo.Character WHERE Name='".$MasterGuild."'"));
$NivelMaster = $NivelMasterInfo[0];
$PaisMasterInfo = mssql_fetch_row(mssql_query("SELECT country,memb___id FROM MuOnline.dbo.MEMB_INFO WHERE memb___id='".$AccountMaster."'"));
$PaisG1 = $PaisMasterInfo[0];
require("CastleSiege/flags.php");
$AsistenteGuildInfo = mssql_fetch_row(mssql_query("SELECT Name FROM MuOnline.dbo.GuildMember WHERE G_Name = (SELECT OWNER_GUILD FROM MuOnline.dbo.MuCastle_DATA) AND G_Status = '64'"));
$AsistenteGuild = $AsistenteGuildInfo[0];
if($GuilDueño == ''){ $GuilDueño = '<Font Color="#DF0101"> N/A</Font>'; }
if($MasterGuild == ''){ $MasterGuild = '<Font Color="#DF0101"> N/A </Font>'; }
if($LevelMaster == ''){ $LevelMaster = '<Font Color="#DF0101"> N/A </Font>'; }
if($ResetsMaster == ''){ $ResetsMaster = '<Font Color="#DF0101"> N/A </Font>'; }
if($NivelMaster == ''){ $NivelMaster = '<Font Color="#DF0101"> N/A </Font>'; }
if($PaisG1 == ''){ $PaisG1 = '<Font Color="#DF0101"> N/A </Font>'; }
if($ScoreGuild == ''){ $ScoreGuild = '<Font Color="#DF0101"> N/A </Font>'; }
if($AsistenteGuild == ''){ $AsistenteGuild = '<Font Color="#DF0101"> N/A </Font>'; }
if($Batallador == ''){ $Batallador = '<Font Color="#DF0101"> N/A </Font>'; }
?>
<body>
<div align="center"><table width="0" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="500" height="80"border="0" cellspacing="0" cellpadding="0">
<tr>
<td style="background-image:url(imagenes/CS123.png); background-repeat:no-repeat; width:500; height:80px; "> </td>
</tr>
</table>
<div align="center">
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="106" style="background-image:url(imagenes/NPC-CS.png); background-repeat:no-repeat; width:116; height:247px; ">
<td width="260"><div align="left">
<table width="0" height="247"border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="125" id="InfoGt">Castle Owner:</td>
<td width="96" id="GuilDueño"><?=$GuilDueño?></td>
</tr>
<tr>
<td id="InfoGt">Master:</td>
<td id="MasterGuild"><?=$MasterGuild?></td>
</tr>
<tr>
<td id="InfoGt">Level:</td>
<td id="LevelMaster"><?=$LevelMaster?></td>
</tr>
<tr>
<td id="InfoGt">Reset:</td>
<td id="ResetMaster"><?=$ResetsMaster?></td>
</tr>
<tr>
<td id="InfoGt">Country:</td>
<td id="PaisMaster"><?=$PaisG1?></td>
</tr>
<tr>
<td id="InfoGt">Logo:</td>
<td id="LogoGuild"><img src="get.php?aL=<?=$LogoGuild;?>.png" alt="" width="40" height="40" /></td>
</tr>
<tr>
<td id="InfoGt">Score:</td>
<td id="ScoreGuild"><?=$ScoreGuild?></td>
</tr>
<tr>
<td id="InfoGt">Assistant:</td>
<td id="AsistenteGuild"><?=$AsistenteGuild?></td>
</tr>
<tr>
<?
$query=mssql_query("select TOP 3 * from MuOnline.dbo.GuildMember WHERE G_Name = (SELECT OWNER_GUILD FROM MuOnline.dbo.MuCastle_DATA) AND G_Status = '32'");
while($row=mssql_fetch_assoc($query)){
$Batallador=$row['Name'];
?>
<td id="InfoGt">Batallador <?=++$countBTM;?>:</td>
<td id="BatalladorGuild"><?=$Batallador?></td>
</tr>
<? } ?>
</table>
</div></td>
<td width="134" style="background-image:url(imagenes/NPC-CS2.png); background-repeat:no-repeat; width:135; height:248px; "> </td>
</tr>
</table>
</div>
<div align="center"></div>
<div align="center">
<table width="500" height="50" border="0" cellspacing="0" cellpadding="0">
<tr>
<td style="background-image:url(imagenes/alianzas.png); background-repeat:no-repeat; width:500; height:50px; "> </td>
</tr>
</table>
</div>
<div align="center"></div>
<div align="center">
<table width="450" border="0" cellspacing="1" cellpadding="1" class="FondoModulo">
<tr>
<td width="175"><div align="center">
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="26" class="Degradado">#</td>
<td width="81" class="Degradado">Alliance:</td>
<td width="91" class="Degradado">Guild Master:</td>
<td width="91" class="Degradado">Assistant:</td>
<td width="51" class="Degradado">Score</td>
<td width="51" class="Degradado">Country:</td>
<td width="59" class="Degradado">Logo:</td>
</tr>
</table>
<table width="450" border="0" cellspacing="1" cellpadding="0">
<tr>
<?
$AlianzasInfo = mssql_fetch_row(mssql_query("select Number,G_Name FROM MuOnline.dbo.Guild WHERE G_Name= (SELECT OWNER_GUILD FROM MuOnline.dbo.MuCastle_DATA)"));
$Union = $AlianzasInfo[0];
$query=mssql_query("select TOP 4 * from MuOnline.dbo.Guild WHERE G_Union= (SELECT Number FROM MuOnline.dbo.Guild WHERE G_Name= (SELECT OWNER_GUILD FROM MuOnline.dbo.MuCastle_DATA))");
while($row=mssql_fetch_assoc($query)){
$Alianzas=$row['G_Name'];
$Master=$row['G_Master'];
$Score=$row['G_Score'];
$Logo=urlencode(bin2hex($row['G_Mark']));
$AsistenteInfo = mssql_fetch_row(mssql_query("SELECT Name FROM MuOnline.dbo.GuildMember WHERE G_Name ='".$Alianzas."' AND G_Status = '64'"));
$Asistente = $AsistenteInfo[0];
$CharacterInfo = mssql_fetch_row(mssql_query("SELECT AccountID,Name FROM MuOnline.dbo.Character WHERE Name='".$Master."'"));
$Account = $CharacterInfo[0];
$CountryInfo = mssql_fetch_row(mssql_query("SELECT country,memb___id FROM MuOnline.dbo.MEMB_INFO WHERE memb___id='".$Account."'"));
$PaisG2 = $CountryInfo[0];
require("CastleSiege/flags.php");
if($Asistente == ''){ $Asistente = ' N/A '; }
?>
<td width="25" class="ModuloPrincipal"><?=++$countAli;?></td>
<td width="80" class="ModuloPrincipal"><?=$Alianzas?></td>
<td width="90" class="ModuloPrincipal"><?=$Master?></td>
<td width="90" class="ModuloPrincipal"><?=$Asistente?></td>
<td width="50" class="ModuloPrincipal"><?=$Score?></td>
<td width="50" class="ModuloPrincipal"><?=$PaisG2?></td>
<td width="57" class="ModuloPrincipal"><img src="get.php?aL=<?=$Logo;?>.png" alt="" width="20" height="20" /></td>
</tr>
<? } ?>
</table>
</div></td>
</tr>
</table>
</div>
<div align="center">
<table width="0" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
</div>
<div align="center">
<table width="500" border="0" cellspacing="1" cellpadding="1" class="FondoModulo">
<tr>
<td><div align="center">
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="Degradado">Castle Siege Information:</td>
</tr>
</table>
</div></td>
</tr>
</table>
</div>
<div align="center">
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center">
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center">
<table width="0" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="MensajeLetra"><? echo $Message1; ?></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td id="MensajeLetra"><? echo $Message2; ?></td>
</tr>
<tr>
<td id="MensajeLetra"><? echo $Message3; ?></td>
</tr>
<tr>
<td id="MensajeLetra"><? echo $Message4; ?></td>
</tr>
<tr>
<td id="MensajeLetra"><? echo $Message5; ?></td>
</tr>
<tr>
<td id="MensajeLetra"><? echo $Message6; ?></td>
</tr>
<tr>
<td id="MensajeLetra"><? echo $Message7; ?></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td id="MensajeLetra"><? echo $Message8; ?></td>
</tr>
<tr>
<td id="MensajeLetra"><? echo $Message9; ?></td>
</tr>
</table>
</div></td>
</tr>
</table>
</div></td>
</tr>
</table>
</div>
<div align="center">
<table width="500" height="50" border="0" cellspacing="0" cellpadding="0">
<tr>
<td style="background-image:url(imagenes/registrados.png); background-repeat:no-repeat; width:500; height:50px; "> </td>
</tr>
</table>
</div>
<div align="center">
<table width="450" border="0" cellspacing="1" cellpadding="1" class="FondoModulo">
<tr>
<td><div align="center">
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="26" class="Degradado">#</td>
<td width="81" class="Degradado">Guild:</td>
<td width="91" class="Degradado">Master:</td>
<td width="51" class="Degradado">Score:</td>
<td width="91" class="Degradado">Sign Of Lord:</td>
<td width="51" class="Degradado">Country:</td>
<td width="59" class="Degradado">Logo:</td>
</tr>
</table>
<table width="450" border="0" cellspacing="1" cellpadding="0">
<?
$query=mssql_query("select TOP 50 * from MuOnline.dbo.MuCastle_REG_SIEGE");
while($row=mssql_fetch_assoc($query)){
$Registrados=$row['REG_SIEGE_GUILD'];
$Marks=$row['REG_MARKS'];
$GuildReg = mssql_fetch_row(mssql_query("SELECT G_Master,G_Score,G_Mark,G_Name FROM MuOnline.dbo.Guild WHERE G_Name='".$Registrados."'"));
$MasterReg = $GuildReg[0];
$ScoreReg = $GuildReg[1];
$LogoReg = urlencode(bin2hex($GuildReg[2]));
$GuildReg = $GuildReg[3];
$PeronsajeInfo = mssql_fetch_row(mssql_query("SELECT AccountID,Name FROM MuOnline.dbo.Character WHERE Name='".$MasterReg."'"));
$AccountReg = $PeronsajeInfo[0];
$CountryRegInfo = mssql_fetch_row(mssql_query("SELECT country,memb___id FROM MuOnline.dbo.MEMB_INFO WHERE memb___id='".$AccountReg."'"));
$PaisG3 = $CountryRegInfo[0];
require("CastleSiege/flags.php");
?>
<tr>
<td width="25" class="ModuloPrincipal"><?=++$countReg;?></td>
<td width="80" class="ModuloPrincipal"><?=$Registrados?></td>
<td width="90" class="ModuloPrincipal"><?=$MasterReg?></td>
<td width="50" class="ModuloPrincipal"><?=$ScoreReg?></td>
<td width="89" class="ModuloPrincipal"><?=$Marks?></td>
<td width="50" class="ModuloPrincipal"><?=$PaisG3?></td>
<td width="58" class="ModuloPrincipal"><img src="get.php?aL=<?=$LogoReg;?>.png" alt="" width="20" height="20" /></td>
</tr>
<? } ?>
</table>
</div></td>
</tr>
</table>
</div>
<div align="center">
<table width="0" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
</div>
<div align="center">
<table width="450" border="0" cellspacing="1" cellpadding="1" class="FondoModulo">
<tr>
<td><div align="center">
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" class="Degradado">Castle Siege Schedule:</td>
</tr>
</table>
<table width="450" border="0" cellspacing="1" cellpadding="0">
<tr>
<td width="112" class="ModuloPrincipal">Day:</td>
<td width="112" class="ModuloPrincipal">Hour:</td>
<td width="222" class="ModuloPrincipal">Details:</td>
</tr>
<tr>
<td class="ModuloPrincipal"><? echo $Dia1; ?></td>
<td class="ModuloPrincipal"><? echo $Hora1; ?></td>
<td class="ModuloPrincipal"><div align="center">
<table width="215" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="Etapas"><? echo $Etapa1; ?></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td class="ModuloPrincipal"><? echo $Dia2; ?></td>
<td class="ModuloPrincipal"><? echo $Hora2; ?></td>
<td class="ModuloPrincipal"><div align="center">
<table width="215" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="Etapas"><? echo $Etapa2; ?></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td class="ModuloPrincipal"><? echo $Dia3; ?></td>
<td class="ModuloPrincipal"><? echo $Hora3; ?></td>
<td class="ModuloPrincipal"><div align="center">
<table width="215" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="Etapas"><? echo $Etapa3; ?></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td class="ModuloPrincipal"><? echo $Dia4; ?></td>
<td class="ModuloPrincipal"><? echo $Hora4; ?></td>
<td class="ModuloPrincipal"><div align="center">
<table width="215" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="Etapas"><? echo $Etapa4; ?></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td class="ModuloPrincipal"><? echo $Dia5; ?></td>
<td class="ModuloPrincipal"><? echo $Hora5; ?></td>
<td class="ModuloPrincipal"><div align="center">
<table width="215" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="Etapas"><? echo $Etapa5; ?></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td class="ModuloPrincipal"><? echo $Dia6; ?></td>
<td class="ModuloPrincipal"><? echo $Hora6; ?></td>
<td class="ModuloPrincipal"><div align="center">
<table width="215" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="Etapas"><? echo $Etapa6; ?></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td class="ModuloPrincipal"><? echo $Dia7; ?></td>
<td class="ModuloPrincipal"><? echo $Hora7; ?></td>
<td class="ModuloPrincipal"><div align="center">
<table width="215" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="Etapas"><? echo $Etapa7; ?></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td class="ModuloPrincipal"><? echo $Dia8; ?></td>
<td class="ModuloPrincipal"><? echo $Hora8; ?></td>
<td class="ModuloPrincipal"><div align="center">
<table width="215" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="Etapas"><? echo $Etapa8; ?></td>
</tr>
</table>
</div></td>
</tr>
</table>
</div></td>
</tr>
</table>
</div>
<div align="center">
<table width="0" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
</div>
<div align="center">
<table width="450" border="0" cellspacing="1" cellpadding="1" class="FondoModulo">
<tr>
<td><div align="center">
<table width="450" border="0" cellspacing="1" cellpadding="0">
<tr>
<td colspan="2" class="Degradado">Tax Information:</td>
</tr>
<tr>
<td width="211" class="ModuloPrincipal">Money:</td>
<td width="239" class="ModuloPrincipal"><?=$Money?></td>
</tr>
<tr>
<td class="ModuloPrincipal">Tax Rate Chaos:</td>
<td class="ModuloPrincipal"><?=$Chaos?></td>
</tr>
<tr>
<td class="ModuloPrincipal">Tax Rate Store:</td>
<td class="ModuloPrincipal"><?=$Store?></td>
</tr>
<tr>
<td class="ModuloPrincipal">Tax Hunt Zone:</td>
<td class="ModuloPrincipal"><?=$Hunt?></td>
</tr>
</table>
</div></td>
</tr>
</table>
</div>
<div align="right">
<table width="0" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><p class="footer_font">
</p></td>
</tr>
</table>
</div></td>
</tr>
</table>
</div>
</body>
</html>
http://i58.tinypic.com/16h7rjm.png
BUT IF I USE MSSQL IT LOADS CORRECTLY..
http://i61.tinypic.com/24dlamr.png
PLEASE HELP...
