in castlesiege php

[MuonlineCN]

SC OWNER: D4rkNyt <------- Guild master
CS Guild OWNER: DK_Guild <------- D4rkNyt
LOGO: <---------- Guild LOGO
something like thhis

[MentaL]

[MuonlineCN]

bump. please help

[invasionGB]

CASTLE_OCCUPY will not give you the castle's owner!

Change your query to:

SELECT OWNER_GUILD FROM MuCastle_DATA

[MuonlineCN]

CASTLE_OCCUPY will not give you the castle's owner!

Change your query to:

SELECT OWNER_GUILD FROM MuCastle_DATA

then the output result is guild name of castle owner not the castle owner name.

[ftewegw1]

then the output result is guild name of castle owner not the castle owner name.

after u get owner_guild ,select g_master from guild table where g_name = owner_guild

[invasionGB]

then the output result is guild name of castle owner not the castle owner name.

Castle Siege o the owner of the castle is an ENTIRE GUILD! Not just the guild master. He wanted the owner not the guild master. Read carefully...

[MuonlineCN]

after u get owner_guild ,select g_master from guild table where g_name = owner_guild

how to apply this in mssql syntax? please help


SC OWNER: D4rkNyt <------- Guild master
CS Guild OWNER: DK_Guild <------- D4rkNyt guild
LOGO: <---------- Guild LOGO
something like this...

[ftewegw1]

how to apply this in mssql syntax? please help

select 'here what u wanna get as result' from 'table its in' where 'your search key' = 'variable name' or @variable name
its something similar to that not hard to get right
google it

[invasionGB]

how to apply this in mssql syntax? please help


SC OWNER: D4rkNyt <------- Guild master
CS Guild OWNER: DK_Guild <------- D4rkNyt guild
LOGO: <---------- Guild LOGO
something like this...

This is easy pal. Just modify your query accordingly. You don't need to fetch data twice from different queries. Just one line is good enough. Here..

SELECT OWNER_GUILD,G_Master,G_Mark FROM MuOnline.dbo.MuCastle_DATA
INNER JOIN Guild on OWNER_GUILD collate database_default = G_Name collate database_default

Now code a PHP function to convert binary data (Guild Logo) into human readable picture or something

[MuonlineCN]

How about this code sir??

<?$ownercs=mssql_query("SELECT OWNER_GUILD,G_Master,G_Mark FROM MuOnline.dbo.MuCastle_DATA
INNER JOIN Guild on OWNER_GUILD collate database_default = G_Name collate database_default");
while($row=mssql_fetch_assoc($ownercs)){
$G_NAME1=$row['G_Name'];
$G_Master1=$row['G_Master'];
$G_Mark1=$row['G_Mark'];
$logo=urlencode(bin2hex($G_Mark1));
?>

<td><div align="center" Class="zarc">
<?=$G_NAME1:?></div></td>
<td><div align="center" Class="zarc">
<?=$G_Master1:?></div></td>

<td><div align="center"><img src="get.php?aL=<?=$logo;?>.png" alt="" width="36" height="36"
style="border: 1px solid #2a2a2a ; background-color:#000000;" align="absmiddle"></div></td>

</tr>
<?

}
?>

[invasionGB]

Because of this, I am assuming you are using MUCORE...

get.php?aL=

I don't use mucore but looking at the code, it may work like this...

<?
$ownercs = $core_db->Execute("SELECT OWNER_GUILD,G_Master,G_Mark FROM MuOnline.dbo.MuCastle_DATA INNER JOIN Guild on OWNER_GUILD collate database_default = G_Name collate database_default");
while(!$ownercs->EOF){
$G_NAME1 = $ownercs->fields[0];
$G_Master1 = $ownercs->fields[1];
$G_Mark1 = $ownercs->fields[2];
$logo = urlencode(bin2hex($G_Mark1));


echo '<tr>
<td><div align="center" Class="zarc">'.$G_NAME1.'</div></td>
<td><div align="center" Class="zarc">'.$G_Master1.'</div></td>
<td><div align="center"><img src="get.php?aL='.$logo.'.png" alt="" width="36" height="36" style="border: 1px solid #2a2a2a ; background-color:#000000;" align="absmiddle"></div></td>
</tr>';


$ownercs->MoveNext();

}
?>

Hope it helps...

- - - Updated - - -

If I were you I fetch the data directly instead of creating a bucle. The owner is just one guild not many, but that can work so...

[MuonlineCN]

Because of this, I am assuming you are using MUCORE...


I don't use mucore but looking at the code, it may work like this...


Hope it helps...

- - - Updated - - -

If I were you I fetch the data directly instead of creating a bucle. The owner is just one guild not many, but that can work so...

yes it is mucore. sorry if my syntax is very complicated. coz im newbie in php.btw THANK YOU. i will try it..


UPDATE!

<div id="zarc2">

<table style="width:500px">


<tr>
<?
$ownercs = $core_db->Execute("SELECT OWNER_GUILD,G_Master,G_Mark FROM MuOnline.dbo.MuCastle_DATA INNER JOIN Guild on OWNER_GUILD collate database_default = G_Name collate database_default");
while(!$ownercs->EOF){
$G_NAME1 = $ownercs->fields[0];
$G_Master1 = $ownercs->fields[1];
$G_Mark1 = $ownercs->fields[2];
$logo = urlencode(bin2hex($G_Mark1));




echo '<tr>
<td><div align="center" Class="zarc">'.$G_NAME1.'</div></td>
<td><div align="center" Class="zarc">'.$G_Master1.'</div></td>
<td><div align="center"><img src="get.php?aL='.$logo.'.png" alt="" width="36" height="36" style="border: 1px solid #2a2a2a ; background-color:#000000;" align="absmiddle"></div></td>
</tr>';




$ownercs->MoveNext();


}
?>
</tr>
</table>





</div>

codes not working. any idea? the web totataly not working after inserting the syntax..

[MuonlineCN]

BUMP.... badly need help here...

[invasionGB]

I can help you out via teamviewer if you want.

[KarLi]

can you exlplain exactlyy what you need? its confusing with "SC" owner
and such.. who will be alliance master owner? who will be the guild master owner etc?
u should make example "image"