castle owner script problems..

[mukso]

hi all, i took this script from Kalonline Website Thread

well when there isnt any castle owner then it writes nothing.. i dont know why

here is the script:

<?php
//if you use windows auth mode
$msconnect = mssql_connect("localhost");
$msdb = mssql_select_db("kal_db", $msconnect);
$plist = "SELECT [Name] FROM Guild WHERE [GID] = (SELECT [GID] FROM GuildCastle)";
$pplist = mssql_query($plist);

while($list = mssql_fetch_array($pplist)){
if($list[Name] == ""){
$gn = "No Guild";
}
else
{
$gn = $list[Name];
}
echo "<b>";
echo $gn;
echo "</b>";
}
?>



i just think there is something messed up cause there is a line [ $gn = "No Guild"; ]

if someone would tell me what the problem is i would be grateful

thanks anyway

 

[Xpl0$ive]

Heres the one i use:

<?php
$msconnect = mssql_connect("localhost","Username","Password");
$msdb = mssql_select_db("kal_db", $msconnect);

$guild_query = mssql_query("SELECT [GID] FROM GuildCastle WHERE CID = 1");
$guild2 = mssql_fetch_array($guild_query);
$guildGID = $guild2[0];

$guild_query = mssql_query("SELECT [Name] FROM Guild WHERE GID = '".$guildGID."'");
$guild2 = mssql_fetch_array($guild_query);
$guild = $guild2[0];
if($guild)
echo "<font size=1 face=Agency FB><b>span style='color:green'>$guild</b></font>";
else
echo "<font size=1 face=Agency FB><span style='color:blue'><b>No One</b></span></font>";
?>

 

[mukso]

ohh, thank you very much

it works fine --->

To view the content, you need to sign in or register

 

[RuleZ]

thnx for relase

 

[Xpl0$ive]

your welcome

btw mukso you spelt Maintrance wrong -> Maintenance

 

[mukso]

ahh, i was always fool to read all correctly :X

kk ty for info ill fix it soon atm (splash on GenU)



Edit: kk now Maintenance