phpwiki-talk

Re: [Phpwiki-talk] databases, DB, classs, Emacs, oh my

[Reini U. <ru...@x-...>]

XEmacs 21.2-b37 "Pan" configured for `i586-pc-win32'.

php-mode: C-h a c-basic-offset

`c-basic-offset' (buffer: *Hyper Apropos*, mode: Hyper-Apropos)
Customizable user variable:
  value: 2
  *Amount of basic offset used by + and - symbols in `c-offsets-alist'.

Property-list:
  custom-requests: 		nil
  custom-type: 			integer
  standard-value: 		(4)
  saved-variable-comment: 	nil
  theme-value: 			((user set 4))
  saved-value: 			(4)


Steve Wainstead schrieb:
> Right, this is on the PEAR page, but I put it in my .emacs and it didn't
> work. Which is to say, I open a php file and c-basic-offset is 3 locally
> and 2 globally, indent-tabs-mode is t, and so on. I'll try it again later
> tonight.
> 
> ~swain
> 
> On Mon, 27 Aug 2001, Reini Urban wrote:
> 
> > (defun php-mode-hook ()
> >   (setq tab-width 4
> >       c-basic-offset 4
> >       c-hanging-comment-ender-p nil
> >       indent-tabs-mode
> >       (not
> >        (and (string-match "/\\(PEAR\\|pear\\)/" (buffer-file-name))
> >             (string-match "\.php$" (buffer-file-name))
> >             (string-match "\.phtml$" (buffer-file-name))))))

RE: [Phpwiki-talk] databases, DB, classs, Emacs, oh my

[Pablo R. <pr...@cl...>]

> 1. Write the abstract base class (the interface definition)
> 2. Write a class that uses DB and extends the base class
> 3. Integrate that into the code base (basically, search and 
> replace all database calls) 4. Test, test, test.

Hum ..... Have you considered in using ADODB for database
Abstraction? I think is a cool work.

See at:

http://php.weblogs.com/adodb

Regards,

Pablo Roca
Sysop de PortalFox (http://www.portalfox.com)

Re: [Phpwiki-talk] databases, DB, classs, Emacs, oh my

[Steve W. <sw...@pa...>]

Right, this is on the PEAR page, but I put it in my .emacs and it didn't
work. Which is to say, I open a php file and c-basic-offset is 3 locally
and 2 globally, indent-tabs-mode is t, and so on. I'll try it again later
tonight.

~swain

On Mon, 27 Aug 2001, Reini Urban wrote:

> (defun php-mode-hook ()
>   (setq tab-width 4
> 	c-basic-offset 4
> 	c-hanging-comment-ender-p nil
> 	indent-tabs-mode
> 	(not
> 	 (and (string-match "/\\(PEAR\\|pear\\)/" (buffer-file-name))
> 	      (string-match "\.php$" (buffer-file-name))
> 	      (string-match "\.phtml$" (buffer-file-name))))))
>
>
> Jeff Dairiki schrieb:
> >
> > > Will do... Postgresql is good; I created "frontpage" and it's different
> > > from FrontPage in the pagename column. I'll check mSQL next week.
> >
> > Thanks!
> >
> > > 1. Write the abstract base class (the interface definition)
> > > 2. Write a class that uses DB and extends the base class
> > > 3. Integrate that into the code base (basically, search and replace all
> > > database calls)
> > > 4. Test, test, test.
> >
> > Okay, I'll work on it now.  (I promise.)  I hope to have something
> > basically working by the end of the week.
> >
> > > The reason I stopped working on the abstract base class (aside from being
> > > in Florida ;-) was I couldn't get Emacs to format the code according to
> > > PEAR. I posted a question to gnu.emacs.help and got no answer, which is
> > > odd.
> >
> > I've recently been using:
> >  <?php
> >  // Local Variables:
> >  // mode: php
> >  // eval: (c-set-style "cc-mode")
> >  // End:
> >  ?>
> > Which seems to work.  It's a bit of a pain, since emacs now asks if you
> > really want to eval the elisp code each time you load the file.
>
> use the hook instead. eval in user docs is evil!
> --
> Reini Urban
> http://xarch.tu-graz.ac.at/home/rurban/
>
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>

---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC

Re: [Phpwiki-talk] databases, DB, classs, Emacs, oh my

[Reini U. <ru...@x-...>]

(defun php-mode-hook ()
  (setq tab-width 4
	c-basic-offset 4
	c-hanging-comment-ender-p nil
	indent-tabs-mode
	(not
	 (and (string-match "/\\(PEAR\\|pear\\)/" (buffer-file-name))
	      (string-match "\.php$" (buffer-file-name))
	      (string-match "\.phtml$" (buffer-file-name))))))


Jeff Dairiki schrieb:
> 
> > Will do... Postgresql is good; I created "frontpage" and it's different
> > from FrontPage in the pagename column. I'll check mSQL next week.
> 
> Thanks!
> 
> > 1. Write the abstract base class (the interface definition)
> > 2. Write a class that uses DB and extends the base class
> > 3. Integrate that into the code base (basically, search and replace all
> > database calls)
> > 4. Test, test, test.
> 
> Okay, I'll work on it now.  (I promise.)  I hope to have something
> basically working by the end of the week.
> 
> > The reason I stopped working on the abstract base class (aside from being
> > in Florida ;-) was I couldn't get Emacs to format the code according to
> > PEAR. I posted a question to gnu.emacs.help and got no answer, which is
> > odd.
> 
> I've recently been using:
>  <?php
>  // Local Variables:
>  // mode: php
>  // eval: (c-set-style "cc-mode")
>  // End:
>  ?>
> Which seems to work.  It's a bit of a pain, since emacs now asks if you
> really want to eval the elisp code each time you load the file.

use the hook instead. eval in user docs is evil!
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

Re: [Phpwiki-talk] databases, DB, classs, Emacs, oh my

[Jeff D. <da...@da...>]

> Will do... Postgresql is good; I created "frontpage" and it's different
> from FrontPage in the pagename column. I'll check mSQL next week.

Thanks!

> 1. Write the abstract base class (the interface definition)
> 2. Write a class that uses DB and extends the base class
> 3. Integrate that into the code base (basically, search and replace all
> database calls)
> 4. Test, test, test.

Okay, I'll work on it now.  (I promise.)  I hope to have something
basically working by the end of the week.

> The reason I stopped working on the abstract base class (aside from being
> in Florida ;-) was I couldn't get Emacs to format the code according to
> PEAR. I posted a question to gnu.emacs.help and got no answer, which is
> odd.

I've recently been using:
 <?php
 // Local Variables:
 // mode: php
 // eval: (c-set-style "cc-mode")
 // End:
 ?>
Which seems to work.  It's a bit of a pain, since emacs now asks if you 
really
want to eval the elisp code each time you load the file.

Jeff

[Phpwiki-talk] databases, DB, classs, Emacs, oh my

[Steve W. <sw...@pa...>]

On Mon, 27 Aug 2001, Jeff Dairiki wrote:

> From what I can tell by reading postgres and miniSQL docs, my guess
> is that neither of those backends have the case-insensitivy problem
> (i.e. 'SandBox' and 'SanDbox' are truly different pages.)  Can you
> verify that that is the case?

Will do... Postgresql is good; I created "frontpage" and it's different
from FrontPage in the pagename column. I'll check mSQL next week.

> > What I'd like to set up is an automated test that I wrote on my last
[...]

> Yes, that would be good.  Also would be good to run an HTML validator
> automatically on all pages (or is that done by your test suite too?).

http-unit chokes on nonvalid HTML, and it's pretty strict.

> > Also, I still want to move to DB... perhaps I should just take a short cut
> > and write a db.php replica of mysql.php as a start. Writing the class and
> > changing all database calls is a lot of work...
>
> Should I work on "new" DB API (like I've been promising)?  Or are we
> happy with the hacks to the old API that Joel Uckelman has started?

We most definitely are moving to DB (and possible dbx for kicks, but I
doubt it... since we'll still have to support flat files and dbm). I've
committed the barest of class files to the tree already, so you may want
to start with that. I want to move one step at a time: devise the database
class, and integrate that into the code base. At that point we should do
an alpha release of 1.3. I would think:

1. Write the abstract base class (the interface definition)
2. Write a class that uses DB and extends the base class
3. Integrate that into the code base (basically, search and replace all
database calls)
4. Test, test, test.

The reason I stopped working on the abstract base class (aside from being
in Florida ;-) was I couldn't get Emacs to format the code according to
PEAR. I posted a question to gnu.emacs.help and got no answer, which is
odd.
<URL:http://groups.google.com/groups?q=group:gnu.emacs.help+author:swain%40panix.com&hl=en&safe=off&rnum=1&selm=9edb24c1.0106262044.62d055ce%40posting.google.com>

I've made three attempts to get Emacs to set c-basic-indent to four spaces
to no avail. Most irritating. I can do ESC-: and enter the setq by hand,
and it works; but I can't do it from .emacs or from the variables list
you inserted in the files.

~swain

---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC

[Phpwiki-talk] PhpWiki on OS X

[Steve W. <sw...@pa...>]

Today I installed PhpWiki 1.2 on OS X release 10.0.0.4. PhpWiki will run
"out of the box" if the installation of PHP is like so:

./configure --prefix=/usr --sysconfdir=/etc --localstatedir=/var
 --mandir=/usr/share/man --with-apxs --with-zlib --disable-pear
 --with-pgsql=/usr/local/pgsql --with-ndbm

I was trying to use --enable-dba=shared but that wouldn't work; PHP
claimed there were no dba functions.

I followed all the instructions on:

http://techdocs.postgresql.org/installguides.php#macosx

http://www.oreillynet.com/pub/a/mac/2001/07/20/php_macosx.html

OS X ships with the SDBM library, which is compatible with the NDBM API.
It doesn't seem to suffer from NDBM's limit of 1000 bytes per value (which
limits page length to 1000 chars).

I haven't switched it to Postgresql but that should be trivial.

~swain

---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC

Re: [Phpwiki-talk] 1.2.1 task list

[Steve W. <sw...@pa...>]

On Fri, 17 Aug 2001, Jeff Dairiki wrote:

> > How drastic?
>
> I've really only thought about the MySQL backend so far.
> There, columns which hold pagenames need to have the 'binary'
> attribute set (their type needs to be changed from
> 'VARCHAR(100) NOT NULL' to 'VARCHAR(100) BINARY NOT NULL'.)
> I think this can be done without necessitating a full
> dump/restore of the database.  If someone "forgot" to do
> this when they upgraded to 1.2.1, I think the worst that would
> happen is that his/her wiki would continue to have case
> insensitivity bugs.

Sounds fine... as long as it doesn't require hours of work on your part,
I'd say go ahead.

> The flat-file back-end has problems on Win32 systems, because
> the stupid filesystem is not case sensitive.  The best fix
> I can think of for that is to urlencode() the capital letters
> in the page names when forming file names.  (This would
> probably require a full dump/restore of the database when
> upgrading.)

It's so painful to support Windows systems regardless of type. I'm
inclined to say "You're on your own" if you run it on Windows... sigh. Of
course it's not fair to them. A lot of people have no choice in the
matter.

> I'm no expert on pgsql and msql --- they may not even be broken.
> If they are, I suspect they could be fixed in a manner similar
> to the mysql back-end.

I haven't set up 1.2 on pgsql in a while and I'm having problems vis. the
pgsql setup. Hopefully I'll work it out tomorrow or Sunday. Gotta go scuba
diving early tomorrow morning.

~swain

---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC

Re: [Phpwiki-talk] 1.2.1 task list

[Jeff D. <da...@da...>]

On Aug 17, 2001, Steve Wainstead said:
> 
> In two weeks I will be back in Manhattan, where my other Linux box is with
> msql... I will test it then. (Don't feel like installing it yet again and
> recompiling && etc.)
> 

That's fine.

> > I would still like to fix the page name case-sensitivity issues, but
> > would first like to hear from Steve and others how kosher you think
> > schema changes are within 1.2.x.
> 
> How drastic?

I've really only thought about the MySQL backend so far.
There, columns which hold pagenames need to have the 'binary'
attribute set (their type needs to be changed from
'VARCHAR(100) NOT NULL' to 'VARCHAR(100) BINARY NOT NULL'.)
I think this can be done without necessitating a full
dump/restore of the database.  If someone "forgot" to do
this when they upgraded to 1.2.1, I think the worst that would
happen is that his/her wiki would continue to have case
insensitivity bugs.

 
I don't think the dbm/dba backend is broken, so no problems there.

The flat-file back-end has problems on Win32 systems, because
the stupid filesystem is not case sensitive.  The best fix
I can think of for that is to urlencode() the capital letters
in the page names when forming file names.  (This would
probably require a full dump/restore of the database when
upgrading.)

I'm no expert on pgsql and msql --- they may not even be broken.
If they are, I suspect they could be fixed in a manner similar
to the mysql back-end.

Jeff

Re: [Phpwiki-talk] 1.2.1 task list

[Steve W. <sw...@pa...>]

On Fri, 17 Aug 2001, Jeff Dairiki wrote:

> The msql and pgsql back-ends are, at this point, completely untested.
> (And therefore, likely to be broken.)  If any of you are able to test
> either, please do!

In two weeks I will be back in Manhattan, where my other Linux box is with
msql... I will test it then. (Don't feel like installing it yet again and
recompiling && etc.)

> I would still like to fix the page name case-sensitivity issues, but
> would first like to hear from Steve and others how kosher you think
> schema changes are within 1.2.x.

How drastic?

cheers
~swain


---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC

Re: [Phpwiki-talk] 1.2.1 task list

[Jeff D. <da...@da...>]

On Aug 17, 2001, Jeff  said:
> On Aug 17, 2001, Reini Urban said:
> > 
> > Task "Reimplement Backlinks page"
> 
> I've been planning on doing this ...

Okay, well, I just did it.

There is now a real back-link page in the _stable_ branch 
('release-1_2-branch').

It "should" be working with all the database back-ends.  I've 
more-or-less tested the mysql, dba, dbm, and flat-file back-ends.

The msql and pgsql back-ends are, at this point, completely untested.  
(And therefore, likely to be broken.)  If any of you are able to test 
either, please do!


I would still like to fix the page name case-sensitivity issues, but 
would first like to hear from Steve and others how kosher you think 
schema changes are within 1.2.x.

Jeff

Re: [Phpwiki-talk] 1.2.1 task list

[Jeff D. <da...@da...>]

On Aug 17, 2001, Reini Urban said:
> isn't this already fixed in 1.3.x ?
> At least I have a trivial fix for this in main.php.
> 
> // enforce anonical "case insensitive bRaCkeT links". 
> // For DOS flatfiles and mysql and "bad queries"
> if ( IsWikiPage($dbi, $pagename) and function_exists('WikiPageName') ) 
>    $pagename = WikiPageName($dbi, $pagename);
> 
> // Enable the output of most of the warning messages.
> // The warnings will screw up zip files and setpref though. 
> ...
> 

That's one way to fix the problem.  I don't really like it though.
(I don't think it's made it's way into the CVS yet either.)

I'd rather fix it so that pages with different capitalization are truly
different pages.  ('PageOne' and 'PagEone', I think should be different 
pages,
with different content.)  (I think we've had this discussion before:
 http://phpwiki.sf.net/phpwiki/index.php?case%20insensitive%20bRaCkeT%20
links
).

This has been fixed for the mysql backend by David Marsh --- notes about
what he did are on the SF bug report page:
 http://sf.net/tracker/index.php?func=detail&aid=233898&group_id=6121&at
id=106121
His fixes haven't made it into the CVS (either branch) yet though...
 ... and they do require a schema change.

Cheers,
Jeff

Re: [Phpwiki-talk] 1.2.1 task list

[Jeff D. <da...@da...>]

On Aug 17, 2001, Reini Urban said:
> I have a working version for 
> 
> Task "Reimplement Backlinks page"

This appears be in the 1.3.x (devel branch) task list, not the 1.2.x 
(stable)
task list.  (BTW Reini: is there a reason it's marked 'deleted' now?  
Should
I undelete it?)

I've been planning on doing this (though you're welcome to, Reini) in 
the
devel branch, but have been waiting until the database API stabilizes.

On the other hand, I would like to fix this (now) in the stable branch.
(I know there's a "feature freeze", but I consider this more of a bug 
fix,
than a new feature.)   If you only use WikiWords for page names
the current scheme works okay, but currently the "backlinks" search for
[names like this] will hit every page containing the words "names",
"like" and "this" anywhere within the entire page text.

Fixing this will require non-trivial changes to each of the database
backends, so I can also understand arguments that it should be left as
it is, for now.

If there are no objections, however, I will work on this over the next
few days.



Another issue which is probably worth dealing with is the case
insensitivity in page names bug.
 http://sf.net/tracker/index.php?func=detail&aid=233898&group_id=6121&at
id=106121

Fixing this properly, however, would require schema changes.  Is this
acceptable?

Jeff

[Phpwiki-talk] Dutch translations

[Jeff D. <da...@da...>]

On Aug 17, 2001, Steve Wainstead said:> 
> 
> Jeff, some months ago didn't we receive a patch for Dutch and you
> mentioned on the list that it should be applied to 1.2?
> 

Jan Nieuwenhuizen submitted a bunch of patches (on the development
branch) at the end of May.

I applied the patches to the devel branch, but did not back-port
them to the stable version.

At the time, we had this discussion:

On 31 May, 2001 Jan Nieuwenhuizen wrote:
>Jeff Dairiki <da...@da...> writes:
>> (I have not back-ported any of your translation fixes to the stable
>> branch of the CVS --- should they be?)
>
>Nah, not worth the effort imo.

Given that at present, a real beta release of the devel branch still
seems a ways away, maybe it is worth reconsidering...

Jan, are you interested in taking a look at it?  (If not I can try,
I suppose --- but I don't speak Dutch.)

Jeff

Re: [Phpwiki-talk] 1.2.1 task list

[Reini U. <ru...@x-...>]

I have a working version for 

Task "Reimplement Backlinks page"
https://sourceforge.net/pm/task.php?func=detailtask&project_task_id=25971&group_id=6121&group_project_id=7691

and some more, but my current problems are:

1) no time until early september.
2) interwiki links are falsely stored in the backlink table.
3) I have too much additional features in my search.php to extract this one.
   esp. I extracted the output code for generated lists of all kinds 
   (search, index, wanted, orphan, ...) into a seperate list.php to support
rows, limit, 
   offset, accelerators, date and sorted by.
   however the advanced search features (regex, and/or, ...) would be nice to
have. 
   I'll do that in september.

Steve Wainstead schrieb:
> I've started a new task list on SF for a 1.2.1 release. There are a
> handful of patches that need to be applied.
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

[Phpwiki-talk] 1.2.1 task list

[Steve W. <sw...@pa...>]

I've started a new task list on SF for a 1.2.1 release. There are a
handful of patches that need to be applied.

Jeff, some months ago didn't we receive a patch for Dutch and you
mentioned on the list that it should be applied to 1.2?

~swain

---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC

Re: [Phpwiki-talk] dumping

[Steve W. <sw...@pa...>]

There's a PhpWikiAdministration page... it has a menu for the various
admin functions. For some reason I can't access it on my home box right
now (using dbalib, I'm getting: "Warning: driver initialization failed in
/home/swain/public_html/1.2/phpwiki/lib/dbalib.php on line 39" using both
Apache/PHP setups I have! Curious.

~swain

On Fri, 17 Aug 2001, Didier Bretin wrote:

> Hello,
>
>    I would like to test performance of phpwiki with differents database.
> My current wiki is working with postgresql-7.0. I would like to dump the
> data and upload them in a wiki configured with flat file.
>
>    So I have try to access to the admin.php page and then I can only
> lock or remove a page.
>
>    Arno tells me that the dump is possible. Can you tell me how I do it ?
>
> Thanks.
> --
>              .------------------------------------------------.
>      .^.     | Didier Bretin, France | db...@in...    |
>      /V\     |-----------------------| www.informactis.com    |
>     // \\    |                       `------------------------|
>    /(   )\   | Visit: http://jeuxlibres.free.fr/              |
>     ^^-^^    `------------------------------------------------'
>
>
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>

---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC

[Phpwiki-talk] dumping

[Didier B. <db...@in...>]

Hello,

   I would like to test performance of phpwiki with differents database. 
My current wiki is working with postgresql-7.0. I would like to dump the 
data and upload them in a wiki configured with flat file.

   So I have try to access to the admin.php page and then I can only 
lock or remove a page.

   Arno tells me that the dump is possible. Can you tell me how I do it ?

Thanks.
-- 
             .------------------------------------------------.
     .^.     | Didier Bretin, France | db...@in...    |
     /V\     |-----------------------| www.informactis.com    |
    // \\    |                       `------------------------|
   /(   )\   | Visit: http://jeuxlibres.free.fr/              |
    ^^-^^    `------------------------------------------------'

Re: [Phpwiki-talk] FW: problems with numbered lists

[Steve W. <sw...@pa...>]

Can you give us a sample URL? I saw a numbered list in your SandBox and it
looked fine.

~swain

On Thu, 9 Aug 2001, Novogrodsky, Dave wrote:

>  Dear Mr. Wainstead,
>
>  I am using your WikiPHP to store project documentation
> (http://www.novogrodsky.net). I have been having a problem creating
> numbered lists. I am using version 1.2 and it is running on a Red Hat box.
> Any idea what is causing this problem?
>
> Sincerely,
> David Novogrodsky
>
>
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>

---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC

[Phpwiki-talk] FW: problems with numbered lists

[Novogrodsky, D. <Dav...@co...>]

 Dear Mr. Wainstead,

 I am using your WikiPHP to store project documentation
(http://www.novogrodsky.net). I have been having a problem creating
numbered lists. I am using version 1.2 and it is running on a Red Hat box.
Any idea what is causing this problem?

Sincerely,
David Novogrodsky

Re: [Phpwiki-talk] offline backup script with rcs (only incremental changes)

[Reini U. <ru...@x-...>]

Oops, 
forgot the url's of the mentioned administrative interface and standalone
trick:

http://xarch.tu-graz.ac.at/home/rurban/acadwiki-1.3.6pre/viewsrc.php?show=admin/fix_HomePage.php#src
http://xarch.tu-graz.ac.at/home/rurban/acadwiki-1.3.6pre/viewsrc.php?show=admin/renamepage.php#src

This should work soon:
% php admin/fix_HomePage.php 

I'm looking how to get the absolute dir of WIKIROOT and setting up the whole
mess 
from the commandline. either by checking argv[1] or by searching for
index.php.
Missing is only RenamePage() in lib/stdlib.php yet.

also did a minor fix in
http://xarch.tu-graz.ac.at/home/rurban/acadwiki-1.3.6pre/viewsrc.php?show=admin/wbackup#src

Reini Urban schrieb:
> I have other in the works, e.g. admin/fix_HomePage.php,
> to rename FrontPage to HomePage in the database,
> which can be called standalone or by url.
> based on admin/renamepage.php, which I'm writing right now.
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

[Phpwiki-talk] offline backup script with rcs (only incremental changes)

[Reini U. <ru...@x-...>]

Hi,
This is a nice backup script suitable for cronjobs, 
daily backups where only incremental changes are stored.
I believe that it only works for 1.3x (zipdump),
someone else should find out the url to produce 1.2 dumps.
But it's not hardcoded anywhere.

Run it in the backupdir where all the ,v files get stored.
This will get filled up with files according the pagenames, so it would be 
wise to be empty, otherwise the page will overwrite an existing file.

Usage: 
cd /path/to/phpwiki/bak
original:
  ../admin/wbackup http://myserver/mywiki/index.php?
with pathinfo:
  ../admin/wbackup http://myserver/mywiki/  
with ZIPDUMP_AUTH = true
  ../admin/wbackup --http-user=admin --http-passwd=pass
http://myserver/mywiki/  

I had to strip the first line of each backup file, not to check-in 
equal files, where only the dump date changed.

Maybe one might take this to enable rcs versioning.
At least I try to incoorporate rcsdiff with these backups to reduce the 
space overhead with the current versioning.

Requirements:
wget
sed
unzip
on windows probably cygwin.

Note: 
my windows versions of rcs and ci get confused with \r. (=> a big oneliner)
so you would have to add unix2dos in between.

CVS:
where should be put such commandline utils? 
admin probably.

I have other in the works, e.g. admin/fix_HomePage.php, 
to rename FrontPage to HomePage in the database, 
which can be called standalone or by url.
based on admin/renamepage.php, which I'm writing right now.

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

Re: [Phpwiki-talk] CVS, mysql: order by rand()

[Steve W. <sw...@pa...>]

On Sat, 4 Aug 2001, Reini Urban wrote:

> I'll start now to merge my AcadWiki enhancements into CVS.
> I need the latest improvements on VersionControl and UserAuth. Good work!

Absolutely! One thing I'd like to do with VersionControl though is move
the form to the diff page, not the info page. The info page was intended
to show the internal stucture of the page as it lives in the data
structure in PhpWiki. This should be a simple cosmetic change.

> maybe: multiline code, my ugly hacks for <code> .. </code>, <verbatim> ..
> </verbatim>, and <nowiki> .. </nowiki>

Hmm. I know we've discussed this on the list in the past. The 1.3 branch
has a new rendering engine Arno wrote which is really slick. I don't
recall if there was a hook for doing multiline processing or not. The
regexp to change the pattern match shouldn't be hard, but then, users can
use [square brackets] if they need to go beyond WikiWords.

> RandomPage:
> -----------
> how to workaround this mysql 3.23 feature which doesn't work in 3.22?

We are definitely moving to DB and PEAR, so you might want to think about
it in that context. We need the SQL to work with the major databases now
(MySQL, Oracle, MSSQL, Postgresql and so on).

> CharCount:
> ----------
> A new user requested feature: display the number of chars in pageinfo, maybe
> words also.
> we need this to produce a community text for a local internet handbook, which
> must have
> 10,000 chars. is this okay to put it into the pageinfo field. I know that
> currently there
> are only static db fields, but the user doesn't care. some convenience figures
> wouldn't hurt
> imho on the info page.

A nice feature!

~swain


---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC

[Phpwiki-talk] security: register_globals off

[Reini U. <ru...@x-...>]

how about a switch to register_globals off?
seems to be a major hack, but for security reasons very advisable.

details: 
  all implicitly passed args/vars must be changed to
HTTP_[POST/GET]_VARS['varname']
  most of it can be fixed in lib/main.php though, because we have only one
main event loop.
sample:
  $searchterm=HTTP_GET_VARS['searchterm'];

see http://www.securereality.com.au/studyinscarlet.txt

best would be:
* register_globals off
* safe_mode on (but then there's no file upload anymore)
* allow_url_fopen off
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

[Phpwiki-talk] CVS, mysql: order by rand()

[Reini U. <ru...@x-...>]

I'll start now to merge my AcadWiki enhancements into CVS.
I need the latest improvements on VersionControl and UserAuth. Good work!

I'll try:
BetterIndex, RandomPage, OrphanPages, WantedPages, improved BackLink, 
SeparateListOutput, MagicPages, SplitWordsInTitle, BetterRecentChanges,
HowToBlockRobots, 
optional PageChangeNotification to the admin only, ImageLinks
(see
http://phpwiki.sourceforge.net/phpwiki/index.php?full=CategoryNextWikiSuggestions)

maybe: locale stuff (this is awful, I just broke my german wiki db after
having recompiled to php-4.0.6)
maybe: localized WikiNameRegexp with TrailingNumbers (optionally)
maybe: multiline code, my ugly hacks for <code> .. </code>, <verbatim> ..
</verbatim>, and <nowiki> .. </nowiki>

RandomPage:
-----------
how to workaround this mysql 3.23 feature which doesn't work in 3.22?

  select pagename from wiki order by rand() limit 1;

the rand() function is defined in 3.22 also, but I wanted to avoid subselects.
attempt 1:
  $res = mysql_query("select pagename from $WikiPageStore", $dbi["dbc"]);
  srand((double)microtime()*1000000);
  $rows = mysql_num_rows($res);
  $page = mysql_result($res,rand(0,$rows-1));

how can one avoid to checkout all pages by using mysql the rand() function?
LIMIT doesn't accept ROUND($pagecount*rand()),1 as argument.
mysql v3.22.25 doesn't accept this syntax neither: 
  set @i:=round(200*rand());

oh bad. at least attempt 1 is cross-db compatible.


CharCount:
----------
A new user requested feature: display the number of chars in pageinfo, maybe
words also.
we need this to produce a community text for a local internet handbook, which
must have 
10,000 chars. is this okay to put it into the pageinfo field. I know that
currently there 
are only static db fields, but the user doesn't care. some convenience figures
wouldn't hurt 
imho on the info page.

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/