Manage my template

[subzeros]

Hello,

 

I integrate my WHMCS template all is well. I create a table that is like this

 

CREATE TABLE IF NOT EXISTS `mod_wizardpanelsettings` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`favicon` varchar(75) NOT NULL,

`active_facebook` int(1) NOT NULL DEFAULT '1',

`url_facebook` varchar(75) NOT NULL,

`active_twitter` int(1) NOT NULL DEFAULT '1',

`url_twitter` varchar(75) NOT NULL,

`active_youtube` int(1) NOT NULL DEFAULT '1',

`url_youtube` varchar(75) NOT NULL,

`active_googleplus` int(1) NOT NULL DEFAULT '1',

`url_googleplus` varchar(75) NOT NULL,

`active_linekedin` int(1) NOT NULL DEFAULT '1',

`url_linekedin` varchar(75) NOT NULL,

`active_livechat` int(1) NOT NULL DEFAULT '0',

`active_langage` int(1) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;

 

So I start to create my module to record information from the admin. But how to recover such 'url_facebook' from my table to display in the header.tpl?

 

Sorry for my english i am french

 

Thank you for your future responses

 

Cordially

[subzeros]

I forgot to post my hook.php

 

function wizardpanel_ClientAreaHeadOutput_Hook($vars) {

/* My table */

mysql_query ......

$return['url_facebook'] = 'http://www.';

return $return;

}

 

if (!defined("WHMCS")) {

exit( 'This file cannot be accessed directly' );

add_hook( "ClientAreaHeadOutput", 0, "wizardpanel_ClientAreaHeadOutput_Hook" );

add_hook( "AdminHomeWidgets", 1, "widget_wizardpanel_addon" );

}

 

In my header I have to put {$url_facebook}