Re: [libreoffice-website] editing donation pages

Hi Florian, *,

On Wed, Mar 14, 2012 at 5:00 PM, Florian Effenberger
<floeff@documentfoundation.org> wrote:
> Texts to search for are:
>
> - "Pforzheim" (the location of the bank),
> - "Freies Office Deutschland e.V." (the association collecting money on our
> behalf, which will soon change since TDF an own entity now),
> - "donations@documentfoundation.org" (the former PayPal address which I am
> changing to paypal@ right now to make the account transfer easier)
> - "tax" (since we at some pages link to toe FrODeV tax-deduction
> confirmation)
>
> Can someone help me with searching the SQL database? We need to adjust the
> PayPal account and soon the account owner.

mysql> SELECT Subsite.Title, URLSegment, SiteTree_Live.ID ID FROM
SiteTree_Live JOIN Subsite ON Subsite.ID = SubsiteID WHERE Content
LIKE "%Pforzheim%" OR Content LIKE "%Freies Office%" OR Content LIKE
"% tax %" OR Content LIKE "%donations@documentfoundation.org%" ORDER
BY Title;
+----------------------+----------------------+------+
| Title                | URLSegment           | ID   |
+----------------------+----------------------+------+
| Esperanto NL Project | donaci               |  966 |
| Finnish NL Project   | 2011-06-15           | 1365 |
| Finnish NL Project   | 2012-02-20           | 1889 |
| German NL Project    | mitarbeiten          |   91 |
| German NL Project    | faq-zu-libreoffice   |  106 |
| German NL Project    | verwaltungen         |  218 |
| Italian NL Project   | donazioni            | 1141 |
| Main                 | donate               |  241 |
| Spanish NL Project   | donacion             |  661 |
| Z Challenge          | why                  |  926 |
| Z Challenge          | donate               |  928 |
| Z Challenge          | spenden              |  934 |
| Z Challenge          | warum                |  935 |
| Z Challenge          | done                 |  956 |
| Z Challenge          | donate-fr-FR         | 1020 |
| Z Challenge          | donate-ru-RU         | 1024 |
| Z Challenge          | doacao               | 1034 |
| Z Challenge          | donate-el-GR         | 1068 |
| Z TDF                | foundation           | 1119 |
| Z TDF                | supporters           | 1122 |
| Z TDF                | contribution         | 1121 |
| Z TDF                | board                | 1679 |
| Z TDF                | membership-committee | 1678 |
| Z TDF                | history              | 1680 |
+----------------------+----------------------+------+
24 rows in set (0.12 sec)

HTH - use https://www.libreoffice.org/admin/show/<id> to view it in
the backend without having to navigate around manually.

ciao
Christian

-- 
Unsubscribe instructions: E-mail to website+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/website/
All messages sent to this list will be publicly archived and cannot be deleted