EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   Script to list Hotzones and port to when clicked (https://www.eqemulator.org/forums/showthread.php?t=42685)

cryfall1 10-31-2019 05:57 PM

Script to list Hotzones and port to when clicked
 
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.


All times are GMT -4. The time now is 09:17 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.