// swad_banner.c: banners

/*

SWAD (Shared Workspace At a Distance),

is a web platform developed at the University of Granada (Spain),

and used to support university teaching.

This file is part of SWAD core.

Copyright (C) 1999-2024 Antonio Cañas Vargas

This program is free software: you can redistribute it and/or modify

it under the terms of the GNU Affero General Public License as

published by the Free Software Foundation, either version 3 of the

License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

GNU Affero General Public License for more details.

You should have received a copy of the GNU Affero General Public License

along with this program. If not, see <http://www.gnu.org/licenses/>.

*/

/*****************************************************************************/

/********************************* Headers ***********************************/

/*****************************************************************************/

#include <stddef.h> // For NULL

#include <stdlib.h> // For calloc

#include <string.h> // For string functions

#include "swad_action_list.h"

#include "swad_alert.h"

#include "swad_banner.h"

#include "swad_banner_database.h"

#include "swad_box.h"

#include "swad_constant.h"

#include "swad_database.h"

#include "swad_error.h"

#include "swad_form.h"

#include "swad_global.h"

#include "swad_hidden_visible.h"

#include "swad_HTML.h"

#include "swad_language.h"

#include "swad_link.h"

#include "swad_parameter.h"

#include "swad_parameter_code.h"

#include "swad_photo.h"

/*****************************************************************************/

/************** External global variables from others modules ****************/

/*****************************************************************************/

extern struct Globals Gbl;

/*****************************************************************************/

/******************************* Private types *******************************/

/*****************************************************************************/

struct Ban_Banners

};

/*****************************************************************************/

/***************************** Private variables *****************************/

/*****************************************************************************/

static struct Ban_Banner Ban_EditingBan;

static long Ban_BanCodClicked;

/*****************************************************************************/

/***************************** Private prototypes ****************************/

/*****************************************************************************/

static struct Ban_Banner *Ban_GetEditingBanner (void);

static void Ban_WriteListOfBanners (const struct Ban_Banners *Banners);

static void Ban_PutIconsListingBanners (__attribute__((unused)) void *Args);

static void Ban_PutIconToEditBanners (void);

static void Ban_EditBannersInternal (struct Ban_Banners *Banners,

const struct Ban_Banner *Ban);

static void Ban_GetListBanners (struct Ban_Banners *Banners,

MYSQL_RES **mysql_res);

static void Ban_FreeListBanners (struct Ban_Banners *Banners);

static void Ban_GetBannerDataFromRow (MYSQL_RES *mysql_res,

struct Ban_Banner *Ban);

static void Ban_PutIconsEditingBanners (__attribute__((unused)) void *Args);

static void Ban_ListBannersForEdition (struct Ban_Banners *Banners);

static void Ban_PutParBanCod (void *BanCod);

static void Ban_ShowOrHideBanner (struct Ban_Banner *Ban,

HidVis_HiddenOrVisible_t HiddenOrVisible);

static void Ban_RenameBanner (struct Ban_Banner *Ban,

Nam_ShrtOrFullName_t ShrtOrFull);

static void Ban_PutFormToCreateBanner (const struct Ban_Banner *Ban);

static void Ban_PutHeadBanners (void);

static void Ban_SetBanCodClicked (long BanCod);

static void Ban_ResetBanners (struct Ban_Banners *Banners);

static void Ban_ResetBanner (struct Ban_Banner *Ban);

/*****************************************************************************/

/************************** Access to editing banner *************************/

/*****************************************************************************/

static struct Ban_Banner *Ban_GetEditingBanner (void)

{

return &Ban_EditingBan;

}

/*****************************************************************************/

/***************************** List all banners ******************************/

/*****************************************************************************/

void Ban_ShowAllBanners (void)

{

extern const char *Hlp_SYSTEM_Banners;

extern const char *Txt_Banners;

extern const char *Txt_No_banners;

struct Ban_Banners Banners;

MYSQL_RES *mysql_res;

/***** Reset banners *****/

Ban_ResetBanners (&Banners);

/***** Get list of banners *****/

Banners.Num = Ban_DB_GetVisibleBanners (&mysql_res);

Ban_GetListBanners (&Banners,&mysql_res);

/***** Begin box *****/

Box_BoxBegin (Txt_Banners,Ban_PutIconsListingBanners,NULL,

Hlp_SYSTEM_Banners,Box_NOT_CLOSABLE);

/***** Write all banners *****/

if (Banners.Num) // There are banners

Ban_WriteListOfBanners (&Banners);

else // No banners created

Ale_ShowAlert (Ale_INFO,Txt_No_banners);

/***** End box *****/

Box_BoxEnd ();

/***** Free list of banners *****/

Ban_FreeListBanners (&Banners);

}

/*****************************************************************************/

/*************************** Write list of banners ***************************/

/*****************************************************************************/

static void Ban_WriteListOfBanners (const struct Ban_Banners *Banners)

{

unsigned NumBan;

/***** List start *****/

HTM_UL_Begin ("class=\"LIST_LEFT\"");

/***** Write all banners *****/

for (NumBan = 0;

NumBan < Banners->Num;

NumBan++)

{

/* Write data of this banner */

HTM_LI_Begin (NULL);

HTM_A_Begin ("href=\"%s\" title=\"%s\" class=\"DAT_%s\" target=\"_blank\"",

Banners->Lst[NumBan].WWW,

Banners->Lst[NumBan].FullName,

The_GetSuffix ());

HTM_IMG (Cfg_URL_BANNER_PUBLIC,Banners->Lst[NumBan].Img,Banners->Lst[NumBan].FullName,

"class=\"BANNER\"");

HTM_A_End ();

HTM_LI_End ();

}

/***** List end *****/

HTM_UL_End ();

}

/*****************************************************************************/

/***************** Put contextual icons in list of banners *******************/

/*****************************************************************************/

static void Ban_PutIconsListingBanners (__attribute__((unused)) void *Args)

{

/***** Put icon to view banners *****/

if (Gbl.Usrs.Me.Role.Logged == Rol_SYS_ADM)

Ban_PutIconToEditBanners ();

/***** Put icon to view links *****/

Lnk_PutIconToViewLinks ();

}

/*****************************************************************************/

/************************* Put an icon to edit banners ***********************/

/*****************************************************************************/

static void Ban_PutIconToEditBanners (void)

{

Ico_PutContextualIconToEdit (ActEdiBan,NULL,NULL,NULL);

}

/*****************************************************************************/

/************************** Put forms to edit banners ************************/

/*****************************************************************************/

void Ban_EditBanners (void)

{

struct Ban_Banners Banners;

struct Ban_Banner Ban;

/***** Reset banners *****/

Ban_ResetBanners (&Banners);

/***** Reset banner *****/

Ban_ResetBanner (&Ban);

/***** Edit banners *****/

Ban_EditBannersInternal (&Banners,&Ban);

}

static void Ban_EditBannersInternal (struct Ban_Banners *Banners,

const struct Ban_Banner *Ban)

{

extern const char *Hlp_SYSTEM_Banners_edit;

extern const char *Txt_Banners;

MYSQL_RES *mysql_res;

/***** Get list of banners *****/

Banners->Num = Ban_DB_GetAllBanners (&mysql_res);

Ban_GetListBanners (Banners,&mysql_res);

/***** Begin box *****/

Box_BoxBegin (Txt_Banners,Ban_PutIconsEditingBanners,NULL,

Hlp_SYSTEM_Banners_edit,Box_NOT_CLOSABLE);

/***** Put a form to create a new banner *****/

Ban_PutFormToCreateBanner (Ban);

/***** Forms to edit current banners *****/

if (Banners->Num)

Ban_ListBannersForEdition (Banners);

/***** End box *****/

Box_BoxEnd ();

/***** Free list of banners *****/

Ban_FreeListBanners (Banners);

}

/*****************************************************************************/

/****************************** List all banners *****************************/

/*****************************************************************************/

static void Ban_GetListBanners (struct Ban_Banners *Banners,

MYSQL_RES **mysql_res)

{

unsigned NumBan;

/***** Get banners from database *****/

if (Banners->Num) // Banners found...

{

/***** Create list with banners *****/

if ((Banners->Lst = calloc ((size_t) Banners->Num,sizeof (*Banners->Lst))) == NULL)

Err_NotEnoughMemoryExit ();

/***** Get the banners *****/

for (NumBan = 0;

NumBan < Banners->Num;

NumBan++)

Ban_GetBannerDataFromRow (*mysql_res,&Banners->Lst[NumBan]);

}

/***** Free structure that stores the query result *****/

DB_FreeMySQLResult (mysql_res);

}

/*****************************************************************************/

/************************* Get banner data by code ***************************/

/*****************************************************************************/

void Ban_GetBannerDataByCod (struct Ban_Banner *Ban)

{

MYSQL_RES *mysql_res;

/***** Clear data *****/

Ban->HiddenOrVisible = HidVis_VISIBLE;

Ban->ShrtName[0] = Ban->FullName[0] = Ban->Img[0] = Ban->WWW[0] = '\0';

/***** Check if banner code is correct *****/

if (Ban->BanCod > 0)

{

/***** Get data of a banner from database *****/

if (Ban_DB_GetBannerDataByCod (&mysql_res,Ban->BanCod)) // Banner found...

Ban_GetBannerDataFromRow (mysql_res,Ban);

/***** Free structure that stores the query result *****/

DB_FreeMySQLResult (&mysql_res);

}

}

/*****************************************************************************/

/*************************** Free list of banners ****************************/

/*****************************************************************************/

static void Ban_FreeListBanners (struct Ban_Banners *Banners)

{

if (Banners->Lst)

{

/***** Free memory used by the list of banners *****/

free (Banners->Lst);

Banners->Lst = NULL;

Banners->Num = 0;

}

}

/*****************************************************************************/

/***************************** Get banner data *******************************/

/*****************************************************************************/

static void Ban_GetBannerDataFromRow (MYSQL_RES *mysql_res,

struct Ban_Banner *Ban)

{

MYSQL_ROW row;

/***** Get next row from result *****/

row = mysql_fetch_row (mysql_res);

/***** Get banner code (row[0]) *****/

if ((Ban->BanCod = Str_ConvertStrCodToLongCod (row[0])) <= 0)

Err_WrongBannerExit ();

/***** Get if the banner is hidden (row[1]) *****/

Ban->HiddenOrVisible = HidVid_GetHiddenOrVisible (row[1][0]);

/***** Get short name (row[2]), full name (row[3]),

image (row[4]) and URL (row[5]) of the banner *****/

Str_Copy (Ban->ShrtName,row[2],sizeof (Ban->ShrtName) - 1);

Str_Copy (Ban->FullName,row[3],sizeof (Ban->FullName) - 1);

Str_Copy (Ban->Img ,row[4],sizeof (Ban->Img ) - 1);

Str_Copy (Ban->WWW ,row[5],sizeof (Ban->WWW ) - 1);

}

/*****************************************************************************/

/**************** Put contextual icons in edition of banners *****************/

/*****************************************************************************/

static void Ban_PutIconsEditingBanners (__attribute__((unused)) void *Args)

{

/***** Put icon to view banners *****/

Ico_PutContextualIconToView (ActSeeBan,NULL,NULL,NULL);

/***** Put icon to view links *****/

Lnk_PutIconToViewLinks ();

}

/*****************************************************************************/

/************************* Put icon to view banners **************************/

/*****************************************************************************/

void Ban_PutIconToViewBanners (void)

{

Lay_PutContextualLinkOnlyIcon (ActSeeBan,NULL,NULL,NULL,"flag.svg",Ico_BLACK);

}

/*****************************************************************************/

/***************************** List all banners ******************************/

/*****************************************************************************/

static void Ban_ListBannersForEdition (struct Ban_Banners *Banners)

{

extern const char *HidVis_DataClass[HidVis_NUM_HIDDEN_VISIBLE];

static Act_Action_t ActionHideUnhide[HidVis_NUM_HIDDEN_VISIBLE] =

{

[HidVis_HIDDEN ] = ActUnhBan, // Hidden ==> action to unhide

[HidVis_VISIBLE] = ActHidBan, // Visible ==> action to hide

};

static Act_Action_t ActionRename[Nam_NUM_SHRT_FULL_NAMES] =

{

[Nam_SHRT_NAME] = ActRenBanSho,

[Nam_FULL_NAME] = ActRenBanFul,

};

unsigned NumBan;

struct Ban_Banner *Ban;

char *Anchor = NULL;

const char *Names[Nam_NUM_SHRT_FULL_NAMES];

/***** Begin table *****/

HTM_TABLE_Begin ("TBL_SCROLL");

/***** Table head *****/

Ban_PutHeadBanners ();

/***** Write all banners *****/

for (NumBan = 0;

NumBan < Banners->Num;

NumBan++)

{

Ban = &Banners->Lst[NumBan];

Banners->BanCodToEdit = Ban->BanCod;

/* Set anchor string */

Frm_SetAnchorStr (Ban->BanCod,&Anchor);

/* Begin table row */

HTM_TR_Begin (NULL);

/* Icon to remove banner */

HTM_TD_Begin ("class=\"BM\"");

Ico_PutContextualIconToRemove (ActRemBan,NULL,

Ban_PutParBanCod,

&Banners->BanCodToEdit);

HTM_TD_End ();

/* Icon to hide/unhide banner */

HTM_TD_Begin ("class=\"BM\"");

Ico_PutContextualIconToHideUnhide (ActionHideUnhide,Anchor,

Ban_PutParBanCod,

&Banners->BanCodToEdit,

Ban->HiddenOrVisible);

HTM_TD_End ();

/* Banner code */

HTM_TD_Begin ("class=\"CODE %s_%s\"",

HidVis_DataClass[Ban->HiddenOrVisible],

The_GetSuffix ());

HTM_ARTICLE_Begin (Anchor);

HTM_Long (Ban->BanCod);

HTM_ARTICLE_End ();

HTM_TD_End ();

/* Banner short name and full name */

Names[Nam_SHRT_NAME] = Ban->ShrtName;

Names[Nam_FULL_NAME] = Ban->FullName;

Nam_ExistingShortAndFullNames (ActionRename,

ParCod_Ban,Banners->BanCodToEdit,

Names,

Frm_PUT_FORM);

/* Banner image */

HTM_TD_Begin ("class=\"LM\"");

Frm_BeginForm (ActChgBanImg);

ParCod_PutPar (ParCod_Ban,Banners->BanCodToEdit);

HTM_INPUT_TEXT ("Img",Ban_MAX_CHARS_IMAGE,Ban->Img,

HTM_ENABLED,HTM_NOT_REQUIRED,HTM_SUBMIT_ON_CHANGE,

"size=\"12\" class=\"INPUT_%s\"",

The_GetSuffix ());

Frm_EndForm ();

HTM_TD_End ();

/* Banner WWW */

HTM_TD_Begin ("class=\"LM\"");

Frm_BeginForm (ActChgBanWWW);

ParCod_PutPar (ParCod_Ban,Banners->BanCodToEdit);

HTM_INPUT_URL ("WWW",Ban->WWW,

HTM_REQUIRED,HTM_SUBMIT_ON_CHANGE,

"class=\"INPUT_WWW INPUT_%s\"",

The_GetSuffix ());

Frm_EndForm ();

HTM_TD_End ();

HTM_TR_End ();

/* Free anchor string */

Frm_FreeAnchorStr (&Anchor);

}

/***** End table *****/

HTM_TABLE_End ();

}

/*****************************************************************************/

/******************* Write parameter with code of banner *********************/

/*****************************************************************************/

static void Ban_PutParBanCod (void *BanCod)

{

if (BanCod)

ParCod_PutPar (ParCod_Ban,*((long *) BanCod));

}

/*****************************************************************************/

/******************************* Remove a banner *****************************/

/*****************************************************************************/

void Ban_RemoveBanner (void)

{

extern const char *Txt_Banner_X_removed;

struct Ban_Banner *Ban = Ban_GetEditingBanner ();

/***** Reset banner *****/

Ban_ResetBanner (Ban);

/***** Get banner code *****/

Ban->BanCod = ParCod_GetAndCheckPar (ParCod_Ban);

/***** Get data of the banner from database *****/

Ban_GetBannerDataByCod (Ban);

/***** Remove banner *****/

Ban_DB_RemoveBanner (Ban->BanCod);

/***** Write message to show the change made *****/

Ale_CreateAlert (Ale_SUCCESS,NULL,

Txt_Banner_X_removed,

Ban->ShrtName);

}

/*****************************************************************************/

/************************** Unhide a hidden banner ***************************/

/*****************************************************************************/

void Ban_UnhideBanner (void)

{

struct Ban_Banner *Ban = Ban_GetEditingBanner ();

/***** Reset banner *****/

Ban_ResetBanner (Ban);

/***** Set banner as visible *****/

Ban_ShowOrHideBanner (Ban,HidVis_VISIBLE);

}

/*****************************************************************************/

/**************************** Hide a visible banner **************************/

/*****************************************************************************/

void Ban_HideBanner (void)

{

struct Ban_Banner *Ban = Ban_GetEditingBanner ();

/***** Reset banner *****/

Ban_ResetBanner (Ban);

/***** Set banner as hidden *****/

Ban_ShowOrHideBanner (Ban,HidVis_HIDDEN);

}

/*****************************************************************************/

/*************** Change hiddeness of banner in the database ******************/

/*****************************************************************************/

static void Ban_ShowOrHideBanner (struct Ban_Banner *Ban,

HidVis_HiddenOrVisible_t HiddenOrVisible)

{

/***** Get banner code *****/

Ban->BanCod = ParCod_GetAndCheckPar (ParCod_Ban);

/***** Get data of the banner from database *****/

Ban_GetBannerDataByCod (Ban);

/***** Mark file as hidden/visible in database *****/

if (Ban->HiddenOrVisible != HiddenOrVisible)

Ban_DB_HideOrUnhideBanner (Ban->BanCod,HiddenOrVisible);

}

/*****************************************************************************/

/********************* Change the short name of a banner *********************/

/*****************************************************************************/

void Ban_RenameBannerShort (void)

{

struct Ban_Banner *Ban = Ban_GetEditingBanner ();

/***** Reset banner *****/

Ban_ResetBanner (Ban);

/***** Rename banner *****/

Ban_RenameBanner (Ban,Nam_SHRT_NAME);

}

/*****************************************************************************/

/********************* Change the full name of a banner **********************/

/*****************************************************************************/

void Ban_RenameBannerFull (void)

{

struct Ban_Banner *Ban = Ban_GetEditingBanner ();

/***** Reset banner *****/

Ban_ResetBanner (Ban);

/***** Rename banner *****/

Ban_RenameBanner (Ban,Nam_FULL_NAME);

}

/*****************************************************************************/

/*********************** Change the name of a banner *************************/

/*****************************************************************************/

static void Ban_RenameBanner (struct Ban_Banner *Ban,

Nam_ShrtOrFullName_t ShrtOrFull)

{

extern const char *Nam_Fields[Nam_NUM_SHRT_FULL_NAMES];

extern unsigned Nam_MaxBytes[Nam_NUM_SHRT_FULL_NAMES];

extern const char *Txt_X_already_exists;

extern const char *Txt_The_banner_X_has_been_renamed_as_Y;

extern const char *Txt_The_name_X_has_not_changed;

char *CurrentName[Nam_NUM_SHRT_FULL_NAMES] =

{

[Nam_SHRT_NAME] = Ban->ShrtName,

[Nam_FULL_NAME] = Ban->FullName,

};

char NewName[Nam_MAX_BYTES_FULL_NAME + 1];

/***** Get parameters from form *****/

/* Get the code of the banner */

Ban->BanCod = ParCod_GetAndCheckPar (ParCod_Ban);

/* Get the new name for the banner */

Nam_GetParShrtOrFullName (ShrtOrFull,NewName);

/***** Get banner data from the database *****/

Ban_GetBannerDataByCod (Ban);

/***** Check if new name is empty *****/

if (!NewName[0])

Ale_CreateAlertYouCanNotLeaveFieldEmpty ();

else

{

/***** Check if old and new names are the same

(this happens when return is pressed without changes) *****/

if (strcmp (CurrentName[ShrtOrFull],NewName)) // Different names

{

/***** If banner was in database... *****/

if (Ban_DB_CheckIfBannerNameExists (Nam_Fields[ShrtOrFull],

NewName,Ban->BanCod,

-1L,0)) // Unused

Ale_CreateAlert (Ale_WARNING,NULL,Txt_X_already_exists,NewName);

else

{

/* Update the table changing old name by new name */

Ban_DB_UpdateBanName (Ban->BanCod,Nam_Fields[ShrtOrFull],NewName);

/* Write message to show the change made */

Ale_CreateAlert (Ale_SUCCESS,NULL,

Txt_The_banner_X_has_been_renamed_as_Y,

CurrentName[ShrtOrFull],NewName);

}

}

else // The same name

/* Write warning message */

Ale_CreateAlert (Ale_INFO,NULL,Txt_The_name_X_has_not_changed,

CurrentName[ShrtOrFull]);

}

/***** Update name *****/

Str_Copy (CurrentName[ShrtOrFull],NewName,

Nam_MaxBytes[ShrtOrFull]);

}

/*****************************************************************************/

/*********************** Change the image of a banner ************************/

/*****************************************************************************/

void Ban_ChangeBannerImg (void)

{

extern const char *Txt_The_new_image_is_X;

struct Ban_Banner *Ban = Ban_GetEditingBanner ();

char NewImg[Ban_MAX_BYTES_IMAGE + 1];

/***** Reset banner *****/

Ban_ResetBanner (Ban);

/***** Get parameters from form *****/

/* Get the code of the banner */

Ban->BanCod = ParCod_GetAndCheckPar (ParCod_Ban);

/* Get the new WWW for the banner */

Par_GetParText ("Img",NewImg,Ban_MAX_BYTES_IMAGE);

/***** Get banner data from the database *****/

Ban_GetBannerDataByCod (Ban);

/***** Check if new image is empty *****/

if (NewImg[0])

{

/* Update the table changing old image by new image */

Ban_DB_UpdateBanImg (Ban->BanCod,NewImg);

/* Write message to show the change made */

Ale_CreateAlert (Ale_SUCCESS,NULL,

Txt_The_new_image_is_X,

NewImg);

}

else

/* Write warning message */

Ale_CreateAlertYouCanNotLeaveFieldEmpty ();

/***** Update image *****/

Str_Copy (Ban->Img,NewImg,sizeof (Ban->Img) - 1);

}

/*****************************************************************************/

/*********************** Change the WWW of a banner **************************/

/*****************************************************************************/

void Ban_ChangeBannerWWW (void)

{

extern const char *Txt_The_new_web_address_is_X;

struct Ban_Banner *Ban = Ban_GetEditingBanner ();

char NewWWW[WWW_MAX_BYTES_WWW + 1];

/***** Reset banner *****/

Ban_ResetBanner (Ban);

/***** Get parameters from form *****/

/* Get the code of the banner */

Ban->BanCod = ParCod_GetAndCheckPar (ParCod_Ban);

/* Get the new WWW for the banner */

Par_GetParText ("WWW",NewWWW,WWW_MAX_BYTES_WWW);

/***** Get banner data from the database *****/

Ban_GetBannerDataByCod (Ban);

/***** Check if new WWW is empty *****/

if (NewWWW[0])

{

/* Update the table changing old WWW by new WWW */

Ban_DB_UpdateBanWWW (Ban->BanCod,NewWWW);

/* Write message to show the change made */

Ale_CreateAlert (Ale_SUCCESS,NULL,

Txt_The_new_web_address_is_X,

NewWWW);

}

else

/* Write warning message */

Ale_CreateAlertYouCanNotLeaveFieldEmpty ();

/***** Update web *****/

Str_Copy (Ban->WWW,NewWWW,sizeof (Ban->WWW) - 1);

}

/*****************************************************************************/

/********* Show alerts after changing a banner and continue editing **********/

/*****************************************************************************/

void Ban_ContEditAfterChgBan (void)

{

struct Ban_Banners Banners;

struct Ban_Banner *Ban = Ban_GetEditingBanner ();

/***** Reset banners *****/

Ban_ResetBanners (&Banners);

/***** Write message to show the change made *****/

Ale_ShowAlerts (NULL);

/***** Show the form again *****/

Ban_EditBannersInternal (&Banners,Ban);

}

/*****************************************************************************/

/********************* Put a form to create a new banner *********************/

/*****************************************************************************/

static void Ban_PutFormToCreateBanner (const struct Ban_Banner *Ban)

{

const char *Names[Nam_NUM_SHRT_FULL_NAMES];

/***** Begin form to create *****/

Frm_BeginFormTable (ActNewBan,NULL,NULL,NULL,"TBL_SCROLL");

/***** Write heading *****/

Ban_PutHeadBanners ();

/***** Table row for input fields *****/

/* Begin table row */

HTM_TR_Begin (NULL);

/* Icons */

HTM_TD_Begin ("class=\"BM\"");

HTM_TD_End ();

HTM_TD_Begin ("class=\"BM\"");

HTM_TD_End ();

/* Banner code */

HTM_TD_Begin ("class=\"CODE\"");

HTM_TD_End ();

/* Banner short name and full name */

Names[Nam_SHRT_NAME] = Ban->ShrtName;

Names[Nam_FULL_NAME] = Ban->FullName;

Nam_NewShortAndFullNames (Names);

/* Banner image */

HTM_TD_Begin ("class=\"LM\"");

HTM_INPUT_TEXT ("Img",Ban_MAX_CHARS_IMAGE,Ban->Img,

HTM_ENABLED,HTM_REQUIRED,HTM_DONT_SUBMIT_ON_CHANGE,

"size=\"12\" class=\"INPUT_%s\"",

The_GetSuffix ());

HTM_TD_End ();

/* Banner WWW */

HTM_TD_Begin ("class=\"LM\"");

HTM_INPUT_URL ("WWW",Ban->WWW,

HTM_REQUIRED,HTM_DONT_SUBMIT_ON_CHANGE,

"class=\"INPUT_WWW INPUT_%s\"",

The_GetSuffix ());

HTM_TD_End ();

/* End table row */

HTM_TR_End ();

/***** End form to create *****/

Frm_EndFormTable (Btn_CREATE_BUTTON);

}

/*****************************************************************************/

/******************** Write header with fields of a banner *******************/

/*****************************************************************************/

static void Ban_PutHeadBanners (void)

{

extern const char *Txt_Code;

extern const char *Txt_Short_name;

extern const char *Txt_Full_name;

extern const char *Txt_Image;

extern const char *Txt_WWW;

/***** Begin table row *****/

HTM_TR_Begin (NULL);

/****** Head cells *****/

HTM_TH_Span (NULL ,HTM_HEAD_CENTER,1,1,"BT");

HTM_TH_Span (NULL ,HTM_HEAD_CENTER,1,1,"BT");

HTM_TH (Txt_Code ,HTM_HEAD_RIGHT );

HTM_TH (Txt_Short_name,HTM_HEAD_LEFT );

HTM_TH (Txt_Full_name ,HTM_HEAD_LEFT );

HTM_TH (Txt_Image ,HTM_HEAD_LEFT );

HTM_TH (Txt_WWW ,HTM_HEAD_LEFT );

/***** End table row *****/

HTM_TR_End ();

}

/*****************************************************************************/

/******************* Receive form to create a new banner *********************/

/*****************************************************************************/

void Ban_ReceiveNewBanner (void)

{

extern const char *Nam_Fields[Nam_NUM_SHRT_FULL_NAMES];

extern const char *Txt_You_must_specify_the_image_of_the_new_banner;

extern const char *Txt_You_must_specify_the_web_address;

extern const char *Txt_Created_new_banner_X;

struct Ban_Banner *Ban = Ban_GetEditingBanner ();

char *Names[Nam_NUM_SHRT_FULL_NAMES];

/***** Reset banner *****/

Ban_ResetBanner (Ban);

/***** Get parameters from form *****/

Names[Nam_SHRT_NAME] = Ban->ShrtName;

Names[Nam_FULL_NAME] = Ban->FullName;

Nam_GetParsShrtAndFullName (Names);

Par_GetParText ("Img",Ban->Img,Ban_MAX_BYTES_IMAGE);

Par_GetParText ("WWW",Ban->WWW,WWW_MAX_BYTES_WWW);

if (Ban->ShrtName[0] &&

Ban->FullName[0]) // If there's a banner name

{

/***** If name of banner was not in database... *****/

if (!Nam_CheckIfNameExists (Ban_DB_CheckIfBannerNameExists,

(const char **) Names,

-1L,

-1L, // Unused

0)) // Unused

{

if (!Ban->Img[0])

Ale_CreateAlert (Ale_WARNING,NULL,

Txt_You_must_specify_the_image_of_the_new_banner);

else if (!Ban->WWW[0])

Ale_CreateAlert (Ale_WARNING,NULL,

Txt_You_must_specify_the_web_address);

else

{

Ban_DB_CreateBanner (Ban);

Ale_CreateAlert (Ale_SUCCESS,Txt_Created_new_banner_X,

Names[Nam_FULL_NAME]);

}

}

}

else // If there is not a banner name

Ale_CreateAlertYouMustSpecifyShrtNameAndFullName ();

}

/*****************************************************************************/

/************************* Write menu with some banners **********************/

/*****************************************************************************/

void Ban_WriteMenuWithBanners (void)

{

struct Ban_Banners Banners;

MYSQL_RES *mysql_res;

unsigned NumBan;

/***** Reset banners *****/

Ban_ResetBanners (&Banners);

/***** Get random banners *****/

// The banner(s) will change once in a while

Banners.Num = Ban_DB_GetRandomBanners (&mysql_res);

Ban_GetListBanners (&Banners,&mysql_res);

/***** Write all banners *****/

for (NumBan = 0;

NumBan < Banners.Num;

NumBan++)

{

/***** Write data of this banner *****/

/* Begin container */

HTM_DIV_Begin ("class=\"CM\"");

/* Begin form */

Frm_BeginForm (ActClkBan);

ParCod_PutPar (ParCod_Ban,Banners.Lst[NumBan].BanCod);

Par_PutParString (NULL,"URL",Banners.Lst[NumBan].WWW);

/* Banner image */

HTM_INPUT_IMAGE (Cfg_URL_BANNER_PUBLIC,Banners.Lst[NumBan].Img,

Banners.Lst[NumBan].FullName,

"class=\"BANNER\"");

/* End form */

Frm_EndForm ();

/* End container */

HTM_DIV_End ();

}

/***** Free list of banners *****/

Ban_FreeListBanners (&Banners);

}

/*****************************************************************************/

/************************* Go to a banner when clicked ***********************/

/*****************************************************************************/

void Ban_ClickOnBanner (void)

{

struct Ban_Banner Ban;

/***** Get banner code *****/

Ban.BanCod = ParCod_GetAndCheckPar (ParCod_Ban);

/***** Get data of the banner from database *****/

Ban_GetBannerDataByCod (&Ban);

/***** Set banner clicked in order to log it *****/

Ban_SetBanCodClicked (Ban.BanCod);

/***** Download the file *****/

fprintf (stdout,"Location: %s\n\n",Ban.WWW);

// TODO: Put headers Content-type and Content-disposition:

// See: http://stackoverflow.com/questions/381954/how-do-i-fix-firefox-trying-to-save-image-as-htm

// http://elouai.com/force-download.php

Gbl.Layout.HTMLStartWritten =

Gbl.Layout.DivsEndWritten =

Gbl.Layout.HTMLEndWritten = true; // Don't write HTML at all

}

static void Ban_SetBanCodClicked (long BanCod)

{

Ban_BanCodClicked = BanCod;

}

long Ban_GetBanCodClicked (void)

{

return Ban_BanCodClicked;

}

/*****************************************************************************/

/******************************* Reset banners *******************************/

/*****************************************************************************/

static void Ban_ResetBanners (struct Ban_Banners *Banners)

{

Banners->Num = 0;

Banners->Lst = NULL;

Banners->BanCodToEdit = -1L;

Banners->BanCodClicked = 0L;

}

/*****************************************************************************/

/************************* Reset banner/destructor **********************/

/*****************************************************************************/

static void Ban_ResetBanner (struct Ban_Banner *Ban)