Difference between revisions of "User:Vincent"
(→Exim) |
|||
| Line 46: | Line 46: | ||
[http://www.exim.org/exim-html-4.69/doc/html/spec_html/ch04.html#SECID34 exim help] | [http://www.exim.org/exim-html-4.69/doc/html/spec_html/ch04.html#SECID34 exim help] | ||
| − | + | === Mantis === | |
query resolved issues. | query resolved issues. | ||
<pre> | <pre> | ||
| Line 55: | Line 55: | ||
fixed_in_version='0.9.26.2' ) | fixed_in_version='0.9.26.2' ) | ||
and status>=80 | and status>=80 | ||
| + | </pre> | ||
| + | query copy versions from lazarus project (id=1) to packages (3) and patches (7) | ||
| + | <pre> | ||
| + | insert into `mantis_project_version_table` | ||
| + | (`project_id`, `version`, `date_order`, `description`, `released`) | ||
| + | select 3, version, date_order, '' as description, released | ||
| + | from `mantis_project_version_table` vp1 | ||
| + | where project_id=1 and date_order > '2012-01-01' | ||
| + | and not exists | ||
| + | (select id | ||
| + | from `mantis_project_version_table` vp3 | ||
| + | where vp3.project_id=3 and vp1.version=vp3.version) | ||
</pre> | </pre> | ||
Revision as of 10:49, 15 March 2012
Full name: Vincent Snijders
Email: vsnijders at vodafonevast.nl
IRC nick: fpcfan, you can use your browser as IRC client.
My goal is to make lazarus as good on windows as it is on linux (or even better).
I build daily snapshots of the lazarus source and installers for win32, linux and Mac OSX. For more information see Lazarus Snapshots Downloads.
Some links to help me create wiki pages (maybe to be moved to a help page):
- Syntax highlighting
- http://meta.wikimedia.org/wiki/Category:Mediawiki_Extensions
- http://meta.wikimedia.org/wiki/User:Coffman/Syntax_Highlight
- http://meta.wikimedia.org/wiki/User:Coffman/Geshi_Syntax_Highlight_extension
Templates for new pages (component release pages): http://mail.wikipedia.org/pipermail/mediawiki-l/2005-October/007985.html
- Translations
- http://meta.wikimedia.org/wiki/User:Fxparlant/BrowserDetection
- http://www.mediawiki.org/wiki/Help:Interwiki_linking#Interwiki_links_to_other_languages
My stylesheet: User:Vincent/monobook.css
My personal lazarus todo list.
User:Vincent/Mediawiki customizations
- Automatically uploading releases to sourceforge
- https://apps.sourceforge.net/trac/covide/browser/tools/mkrelease
- https://sourceforge.net/projects/copher
Creating SID Chroot
Creating a Fedora Chroot
Exim
Mantis
query resolved issues.
SELECT count(*) FROM `mantis_bug_table` where (fixed_in_version='0.9.28' or fixed_in_version='0.9.27 (SVN)' or fixed_in_version='0.9.26.1 (SVN)' or fixed_in_version='0.9.26.2' ) and status>=80
query copy versions from lazarus project (id=1) to packages (3) and patches (7)
insert into `mantis_project_version_table`
(`project_id`, `version`, `date_order`, `description`, `released`)
select 3, version, date_order, '' as description, released
from `mantis_project_version_table` vp1
where project_id=1 and date_order > '2012-01-01'
and not exists
(select id
from `mantis_project_version_table` vp3
where vp3.project_id=3 and vp1.version=vp3.version)
