CPAN-Testers-WWW-Wiki

 view release on metacpan or  search on metacpan

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

ChangePassword=UPDATE users SET password=SHA1(?) WHERE userid=?
BanUsers=UPDATE users SET password=? WHERE userid IN ($ids) AND accessid < 5
FindUser=SELECT userid,password,realname FROM users WHERE email = ?


# Wiki Pages
GetWikiPageVersion=SELECT * FROM wikipage WHERE pagename=? AND version=?
GetWikiPage=SELECT * FROM wikipage WHERE pagename=? ORDER BY version DESC LIMIT 1
SaveWikiPage=INSERT INTO wikipage (pagename,version,userid,comment,content,createdate) VALUES (?,?,?,?,?,?)
GetWikiHistory=SELECT w.pagename,w.version,w.createdate,w.comment,w.locked,u.* FROM wikipage AS w \
    INNER JOIN users AS u ON w.userid=u.userid \
    WHERE w.pagename=? ORDER BY w.version DESC
CheckWikiPage=SELECT version FROM wikipage WHERE pagename=? LIMIT 1

GetWikiIndex=SELECT * FROM wikiindex WHERE pagename=?
UpdateWikiIndex=UPDATE wikiindex SET version=? WHERE pagename=?
InsertWikiIndex=INSERT INTO wikiindex (version,pagename) VALUES (?,?)
WikiRecentChanges=SELECT * FROM wikipage AS w \
    INNER JOIN users AS u ON w.userid=u.userid \
    ORDER BY w.createdate DESC $limit
DeleteWikiPage=DELETE FROM wikipage WHERE version>? AND pagename=?
DeleteWikiPages=DELETE FROM wikipage WHERE pagename=?
DeleteWikiIndex=DELETE FROM wikiindex WHERE pagename=?
SetWikiLock=UPDATE wikipage SET locked=? WHERE pagename=?

WikiSearch=SELECT * FROM wikiindex AS x \
    INNER JOIN wikipage AS w ON w.pagename=x.pagename AND w.version=x.version \
    INNER JOIN users AS u ON w.userid=u.userid \
    WHERE w.content LIKE ? \
    ORDER BY w.createdate LIMIT 100
WikiSearchFull=SELECT * FROM wikipage AS w \
    INNER JOIN users AS u ON w.userid=u.userid \
    WHERE w.content LIKE ? \
    ORDER BY w.createdate LIMIT 100

vhost/cgi-bin/db/cpanwiki-base.sql  view on Meta::CPAN

--
-- Table structure for table `wikipage`
--

DROP TABLE IF EXISTS `wikipage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wikipage` (
  `pagename` varchar(255) NOT NULL DEFAULT '',
  `version` int(4) NOT NULL DEFAULT '1',
  `locked` int(1) NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `createdate` int(10) DEFAULT '0',
  `comment` varchar(255) DEFAULT NULL,
  `content` blob,
  PRIMARY KEY (`pagename`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wikipage`

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

<h2>Help</h2>
<ul>
  <li><a href="/wiki/WikiFormat">WikiFormat</a></li>
</ul>

[% IF user.access == 5 AND section == 'wiki' %]
[% IF wikihash.editmode OR wikihash.showmode %]
<h2>Admin</h2>
<ul>
  [% IF wikihash.locked %]
    <li><a href="/wiki/unlock/[% wikihash.pagename %]">Unlock Page</a></li>
  [% ELSE %]
    <li><a href="/wiki/lock/[% wikihash.pagename %]">Lock Page</a></li>
  [% END %]
  <li><a href="/wiki/delete/[% wikihash.pagename %]">Delete Page</a></li>
</ul>
[% END %]
[% END %]

<h2>Tools</h2>

vhost/html/js/tiny_mce/langs/en.js  view on Meta::CPAN

apply:"Apply",
insert:"Insert",
update:"Update",
cancel:"Cancel",
close:"Close",
browse:"Browse",
class_name:"Class",
not_set:"-- Not set --",
clipboard_msg:"Copy/Cut/Paste is not available in Mozilla and Firefox.\nDo you want more information about this issue?",
clipboard_no_support:"Currently not supported by your browser, use keyboard shortcuts instead.",
popup_blocked:"Sorry, but we have noticed that your popup-blocker has disabled a window that provides application functionality. You will need to disable popup blocking on this site in order to fully utilize this tool.",
invalid_data:"Error: Invalid values entered, these are marked in red.",
more_colors:"More colors"
},
contextmenu:{
align:"Alignment",
left:"Left",
center:"Center",
right:"Right",
full:"Full"
},

vhost/html/js/tiny_mce/tiny_mce.js  view on Meta::CPAN

var tinymce={majorVersion:'3',minorVersion:'2.1.1',releaseDate:'2008-11-27',_init:function(){var t=this,d=document,w=window,na=navigator,ua=na.userAgent,i,nl,n,base,p,v;t.isOpera=w.opera&&opera.buildNumber;t.isWebKit=/WebKit/.test(ua);t.isOldWebKit=t...

vhost/html/js/tiny_mce/tiny_mce_src.js  view on Meta::CPAN

				if (isIE && mo) {
					w = 1;
					window.showModalDialog(u, window, f);
				} else
					w = window.open(u, s.name, f);
			} catch (ex) {
				// Ignore
			}

			if (!w)
				alert(t.editor.getLang('popup_blocked'));
		},

		close : function(w) {
			w.close();
			this.onClose.dispatch(this);
		},

		createInstance : function(cl, a, b, c, d, e) {
			var f = tinymce.resolve(cl);