Hi fellas, i'm working on a portion of my global\player.pl and am stuck.
The goal is to use this to list hotzones (which works), and the saylinks that list should be clickable to go to that zone. I have tried what I know, but cannot get it to do what I ask. Here is the working script to list hotzones:
Code:
#Hotzones Menu
if($text=~/Current Hotzones/i) {
$client->Message(18,"-------- Current Hotzones ---- ");
my $connect = plugin::LoadMysql();
my $found_zone = 0;
my $sql_query = "SELECT short_name FROM zone WHERE hotzone=1";
my $sql_handler = $connect->prepare($sql_query);
$sql_handler->execute();
while (@zone_row = $sql_handler->fetchrow_array()) {
$found_zone++;
$hotzone = quest::saylink("$zone_row[0]", 1);
$client->Message(13, "$hotzone");
}
$connect->disconnect();
}
If this runs, it displays a list of zone shortnames, but clicking does nothing.
Any assistance is greatly appreciated.