Castle Control Script

[janiii]

ingame voiced command script updated: viewtopic.php?f=94&t=10730&p=49083#p49083

[daedalus]

Maybe make another topic ? ;D

But your ingame castle control script look nice

[Bloodshed]

//delete sorry

[Bloodshed]

something simular is allready in L2




(sorry for the offtopic)

[janiii]

something simular is allready in L2

ah, yeah, you are right D ExShowCastleInfo

[toastgodsupreme]

something simular is allready in L2




(sorry for the offtopic)

rofl, just goes to show how rarely we mess with those screens XD

[daedalus]

Yop,

I've updated my castle control script. Now you can see manor pricing.

Regards

[disorder35]

I was able to add ally to this script but could not add the clan leader. Can anyone help me add the clan leader's name to the script? So it will show:
controled By:
Clan Leader:
ally:
tax rate:
next siege:
ally:

thanks

[janiii]

I was able to add ally to this script but could not add the clan leader. Can anyone help me add the clan leader's name to the script? So it will show:
controled By:
Clan Leader:
ally:
tax rate:
next siege:
ally:

thanks

what is the sql statement you are using now?

[disorder35]

I was not able to figure it out the sql statement that's why I couldn't do it. I was able only to get the leader id to print.

[disorder35]

Code: Select all

$sql = @mysql_query('SELECT id,name,taxPercent,siegeDate FROM `castle`') or die('Query failed!'); $gen = "\n"; while ($castle = @mysql_fetch_array($sql)){	$gen .= "\n".strtolower($castle['name']) . 'info = \'<div class="castleWrapper">';	$gen .= '<div class="castlePic" id="' . ucfirst(strtolower($castle['name'])) . 'Pic"></div>';	$gen .= '<div class="castleInfo">';	$gen .= '<div class="castleName"><strong>' . ucfirst(strtolower($castle['name'])) . ' Castle</strong></div>'; 	$clan = @mysql_fetch_array(mysql_query('SELECT clan_name,hasCastle FROM `clan_data` WHERE hasCastle = ' . $castle['id']));	$clan_name = (isset($clan['clan_name'])) ? htmlspecialchars($clan['clan_name'], ENT_QUOTES) : 'UNCLAIMED';	$ally = @mysql_fetch_array(mysql_query('SELECT ally_name FROM `clan_data` WHERE hasCastle = ' . $castle['id']));	$ally_name = (isset($ally['ally_name'])) ? htmlspecialchars($ally['ally_name'], ENT_QUOTES) : 'NO ALLY';  	$gen .= '<div><strong>Controlled by:</strong> ' . $clan_name . '</div>';	$gen .= '<div><strong>Leader:</strong> ' . $leader_name . '</div>';	$gen .= '<div><strong>Ally:</strong> ' . $ally_name . '</div>'; 	if (isset($clan['clan_name'])) $gen .= '<div><strong>Tax Rate:</strong> ' . $castle['taxPercent'] . '%</div>'; 	$gen .= '<div><strong>Next Siege:</strong> ' . date('M d Y h:iA ',$castle['siegeDate']/1000) . ' ' . date('T') . '</div>';	$gen .= '</div>';

[janiii]

Code: Select all

$sql = @mysql_query('SELECT id,name,taxPercent,siegeDate FROM `castle`') or die('Query failed!'); $gen = "\n"; while ($castle = @mysql_fetch_array($sql)){	$gen .= "\n".strtolower($castle['name']) . 'info = \'<div class="castleWrapper">';	$gen .= '<div class="castlePic" id="' . ucfirst(strtolower($castle['name'])) . 'Pic"></div>';	$gen .= '<div class="castleInfo">';	$gen .= '<div class="castleName"><strong>' . ucfirst(strtolower($castle['name'])) . ' Castle</strong></div>'; 	$clan = @mysql_fetch_array(mysql_query('SELECT char_name,clan_name,ally_name,hasCastle FROM `clan_data` LEFT JOIN `characters` ON charId = leader_id WHERE hasCastle = ' . $castle['id']));	$clan_name = (isset($clan['clan_name'])) ? htmlspecialchars($clan['clan_name'], ENT_QUOTES) : 'UNCLAIMED';	$leader_name = (isset($clan['char_name'])) ? htmlspecialchars($clan['char_name'], ENT_QUOTES) : '---';	$ally_name = (isset($clan['ally_name'])) ? htmlspecialchars($clan['ally_name'], ENT_QUOTES) : 'NO ALLY';  	$gen .= '<div><strong>Controlled by:</strong> ' . $clan_name . '</div>';	$gen .= '<div><strong>Leader:</strong> ' . $leader_name . '</div>';	$gen .= '<div><strong>Ally:</strong> ' . $ally_name . '</div>'; 	if (isset($clan['clan_name'])) $gen .= '<div><strong>Tax Rate:</strong> ' . $castle['taxPercent'] . '%</div>'; 	$gen .= '<div><strong>Next Siege:</strong> ' . date('M d Y h:iA ',$castle['siegeDate']/1000) . ' ' . date('T') . '</div>';	$gen .= '</div>';

[disorder35]

Thank you very much works perfectly.

[leanndr]

awesome script

how can we exclude the seeds with price = 0 ?

[disorder35]

One question, when we view this script on Firefox browser, it is nice with the picture on the left and the castle status on the right but when we use Internet Explorer, the picture is on the left (good) but the castle status is on the bottom of the picture. Why is that? Can somebody fix the index.php so that it looks about the same on both browsers. I tried change a few things but it did not work. Also on IE it have scrolling on the right side and on the bottom of each castle box. How do we get the scrolling off?

Thank you.