CPAN-Testers-WWW-Preferences

 view release on metacpan or  search on metacpan

vhost/cgi-bin/config/phrasebook.ini  view on Meta::CPAN

    INNER JOIN access AS a ON a.accessid=l.accessid \
    INNER JOIN groups AS g ON g.groupid=l.groupid \
    WHERE l.groupid=?
GroupACLSave=INSERT INTO acls (groupid,accessid,folderid) VALUES (?,?,?)
GroupACLDelete=DELETE FROM acls WHERE groupid=? AND accessid=? AND folderid=?

AllRealms=SELECT * FROM realms
GetRealmByID=SELECT * FROM realms WHERE realmid=?
GetRealmByName=SELECT * FROM realms WHERE realm=?

AllMenus=SELECT * FROM menus
GetMenus=SELECT * FROM menus WHERE realmid=?
GetMenuByID=SELECT * FROM menus WHERE menuid=?
GetOptions=SELECT * FROM options WHERE menuid=?
FindOptions=SELECT * FROM options WHERE menuid IN ($ids)
AddMenu=INSERT INTO menus (title,typeid,realmid) VALUES (?,?,?)
AddOption=INSERT INTO options (menuid,orderno) VALUES (?,?)
SaveMenu=UPDATE menus SET title=?,typeid=?,realmid=? WHERE menuid=?
SaveOption=UPDATE options SET orderno=?,text=?,href=? WHERE optionid=?
DeleteMenu=DELETE FROM menu WHERE menuid IN ($ids)
DeleteOptions=DELETE FROM options WHERE optionid IN ($ids)

GetOptImages=SELECT * FROM optimages AS o \
    INNER JOIN images AS i ON o.imageid=i.imageid \
    WHERE optionid=? ORDER BY typeid
AddOptImage=INSERT INTO optimages (imageid,optionid,typeid) VALUES (?,?,?)
SaveOptImage=UPDATE optimages SET imageid=? WHERE optionid=? AND typeid=?
DeleteOptImages=DELETE FROM optimages WHERE optionid IN ($ids)

MetaSearchArt=SELECT x.articleid AS id,a.* FROM mxarticles AS x INNER JOIN articles AS a ON a.articleid=x.articleid WHERE metadata IN ($meta)

vhost/cgi-bin/config/requests/menu.ini  view on Meta::CPAN

## Admin commands

[admin]
actions=Menus::Admin
content=menus/menu_adminlist.html

[add]
actions=Menus::Add
content=menus/menu_adminedit.html

[edit]
actions=Menus::Edit
content=menus/menu_adminedit.html

[save]
actions=Menus::Save
onsuccess=menu-edit
onerror=menu-edit

[delete]
actions=Menus::Delete
onsuccess=menu-admin

vhost/cgi-bin/templates/menus/menu_adminedit.html  view on Meta::CPAN

<h2>Menu Admin - [% IF data.menuid %]Edit[% ELSE %]Add[% END %] Menu</h2>

<form action="[% cgipath %]/pages.cgi" method="post">
<input type="hidden" name="act" value="menu-save" />
<input type="hidden" name="menuid" value="[% data.menuid %]" />

[% IF thanks %]<p>Menu saved successfully.[% END %]
[% IF errmess %]
<div class="box">
[% IF errmess == 1 %]
<p class="alert">There are invalid or missing fields, as noted by the <span class="red">&empty;</span> symbol.
[% ELSE %]
<p class="alert">[% errmess %]
[% END %]
</div>
[% END %]

vhost/cgi-bin/templates/menus/menu_adminedit.html  view on Meta::CPAN

    <td><input type="text" name="title" size="32" value="[% data.title %]" /></td></tr>
<tr><th>Type</th>
    <td class="red">[% data.typeid_err %]</td>
    <td>[% data.ddtypes %]</td></tr>
<tr><th>Realm</th>
    <td class="red">[% data.realm_err %]</td>
    <td>[% data.ddrealms %]</td></tr>
</table>
</div>

<p class="smalltext"><input type="button" value='Save Menu' />

[% IF data.menuid %]
<h4>Edit Options</h4>

<div class="admin">
<table>
<tr>
    <th>Order</th>
    <th>Text</th>
    <th>Href</th>

vhost/cgi-bin/templates/menus/menu_adminedit.html  view on Meta::CPAN

    <td><input type=image name="optdel" value="[% opt.optionid %]" src="[% webpath %]/images/icons/icon_delete.gif" alt="delete menu option" height="15" /></a></td>
</tr>
[% END %]
</table>
</div>

<p class="smalltext">
    Note that options that are left blank will not be displayed.

<p class="smalltext">
    <input type="button" name="optadd" value="Add Menu Option" /> |
    <input type="button" value='Save Menu' />
[% END %]
</form>

vhost/cgi-bin/templates/menus/menu_adminlist.html  view on Meta::CPAN

<h2>Menu Admin</h2>

<div class="boxer">
[% IF thanks_message %]<p>[% thanks_message %][% END %]
<p>Click on menu to add, amend or delete options.
<p><a href="[% cgipath %]/pages.cgi?act=menu-add">add a new menu</a>
</div>

<form name="datalist" method="post" action="[% cgipath %]/pages.cgi">
<input type="hidden" name='act' value='menu-admin' />

vhost/cgi-bin/templates/public/navigation.html  view on Meta::CPAN

<h1>Menu</h1>

<ul>
<li><a href="/">Home</a></li>
</ul>

[% IF loggedin %]
<ul>
<li><a href="[% cgipath %]/pages.cgi?act=user-logout">Logout</a></li>
[% IF realm == 'admin' %]
<li><a href="[% cgipath %]/pages.cgi?act=user-edit">Change Profile</a></li>