The Linux Signpost project page
Url
Team
- Arnt Ove Gregersen : Project leader and developer (arntog at gmail dot com)
- Nils Reidar Hovden : Content manager
- Ralf: German translator
Help
Please contact project leader if you wish to help out, have any errors to report or any suggestions. All help is greatly appreciated
Software
Todo
- Process all software from Debian package import ( ~1600 still not approved )
To be added
Development
Back log
- translate all new text strings to german
- system that alerts administrators and translators of new content every week:
This can be solved by adding a column (alert) to the User table and making a perl script that makes a summary of software to be approved and sends it out to the administrators(Role 4) where alert is set to 1, once every day by using a cron job.
Same can be done for the translators(Role 2) but we need to know which language the translator can translate. THink we can solve this by adding a new table (?UserLocale) that is linked to the User and Locale table. If software is added and there is a missing translation there every translators that is able to translate it will be informed.
- fix norwegian latin1 characters
- removed unusued or outdated code
Release 25.08.2010
- Added support for showing if software is Kde or Gnome based
- Added Captcha to avoid robot spam
Added support for software suites by creating an association betweee software like for instance OpenOffice and Writer
Added support for ?YouTubeVideos
- Scaling of images
Removed ?ScreenshotPreviewUrl as an option when adding software (the system scales automaticly now)
- Spisekartet and everything not software related has been removed
- New design
- Added static list of software for crawlers (robots.txt)
- Added list of all linux distribution releases and made it possible to show the software associated with them
- Added system for importing software data directly from debian packages
- Added system that remembers software based on debian package name that has already been rejected so it will not show up again
- Reorginazied the categories
Rejected
- software is translatedTo has been deactivated
- software tags has been removed
Howtos
- Dumping mysql db:
mysqldump --single-transaction -u win2lin_admin -p win2lin | gzip > win2lin.sql.gz
- Restoring db;
gunzip < win2lin.sql.gz | mysql -u win2lin_admin -p win2lin
- Automaticly set software to Gnome or KDE ;
Kde: select Id,Name From Software where (Name like 'K%' or Name like 'k%') and ?WindowsVersion<>1 and Id<>38; update Software set ?IsKdeSoftware=1 where (Name like 'K%' or Name like 'k%') and ?WindowsVersion<>1 and Id<>38; Gnome: select Id,Name From Software where (Name like 'G%' or Name like 'g%') and ?WindowsVersion<>1; Update Software set ?IsGnomeSoftware=1 where (Name like 'G%' or Name like 'g%') and ?WindowsVersion<>1;