1838
Comment:
|
← Revision 10 as of 2009-03-16 03:34:12 ⇥
5995
converted to 1.6 markup
|
Deletions are marked like this. | Additions are marked like this. |
Line 1: | Line 1: |
''This page is part of the webmaster team. Its aim is to keep track of our projects.'' |
|
Line 2: | Line 4: |
''For a list of known DNS entries of Skolelinux/Debian-Edu refer http://developer.skolelinux.no/dnsnames.html.en'' |
|
Line 4: | Line 8: |
* skolelinux.com (expires IX-2006) * skolelinux.net (expires IX-2006) * linuxsignpost.org (expired) * linuxsignpost.net * linuxsignpost.com == Norway == * linuxiskolen.no * linuxiskulen.no * skolelinux.no * skulelinux.no * skuvlalinux.no * linuxveiviseren.no * spist.no * |
|
Line 10: | Line 29: |
Schools can register using an html form that is created by some php scripts. All data is stored in a central mysql database. It embraces two tables: * school |
Schools can register using an html form that is created by some php scripts. All data is stored in a central mysql database. This database is used for different statistics and mappings, cf. [[DebianEdu/ReferenceSchools]]. The Database has got two tables: * Table: school |
Line 28: | Line 51: |
* contacts | * Table: school_contact || Field || Type || Null || Key || Default || Extra || ||<-6> || || contact_id || smallint(5) unsigned || || PRI || || auto_increment || || school_id || smallint(5) unsigned || YES || || || || || main_contact || char(1) || YES || || || || || contact_name || varchar(255) || YES || || || || || contact_email || varchar(255) || YES || || || || || password || varchar(32) || || || || || |
Line 30: | Line 61: |
= Further Information = * http://developer.skolelinux.no/dnsnames.html.en |
=== Problem === From time to time, obscure advertisements are placed in our Database. === Suggested Solutions === 1. Send mail to commits mailing list whenever a new entry is added. 2. Hide URLs of new schools until an admin confirms the validity of the new entry 3. Make URLs non-clickable in general. ad 1: Any suggestions for implementation? ad 2: Easy to implement by means of the status variable "deleted" that is already used to hide away "deleted" entries. Request for comments? ad 3: Probably the easiest solution - but less comfortable. URLs probably need to be parted by spaces to turn off spammers... == Linuxsignpost == The Linux Signpost was launched from within the Skolelinux project to help people migrating to free software. One of its core facilities is a database of Windows (TM) applications that are mapped to free alternatives. If you get a dump of this database, procede as follows to create your own copy: {{{# apt-get install mysql-server # mysqladmin -u root password Y0urS3cre7 # mysqladmin -p create win2lin # mysql -p mysql> \. /home/user/file.sql }}} If we now apply a {{{describe tables}}} we learn that there is dozens of tables in that databse: {{{ +---------------------------+ | Tables_in_win2lin | +---------------------------+ | Advertisement | | AssociatedDocument | | AvailableHardware | | Category | | Counter | | County | | Document | | DocumentCategory | | DocumentDocumentCategory | | I18nTextIndex | | Image | | ImageType | | License | | Link | | LinuxDistribution | | LinuxDistributionSoftware | | Locale | | Profile | | ProfileCategory | | ProfileSoftware | | Quote | | SchoolLevel | | SchoolType | | Service | | Size | | Software | | SoftwareCategory | | Topic | | TopicGroup | | TopicSoftware | | TopicType | | TranslatedText | | UnixVariant | | UseArea | | User | | UserFeedback | | UserGroup | | UserGroupUnixVariant | | Vendor | | slxschools | | slxuserquotes | +---------------------------+ 41 rows in set (0.00 sec)}}} [[http://skolelinux.no/linux-signpost/documents/database_overview.ps|This postscript document]] contains a graphical representation (UML) of the database layout. [[http://skolelinux.no/linux-signpost/documents/howto_translate_text_strings.sxw|This Openoffice document]] describes how to add translations. |
This page is part of the webmaster team. Its aim is to keep track of our projects.
Survey of Web Presences
For a list of known DNS entries of Skolelinux/Debian-Edu refer http://developer.skolelinux.no/dnsnames.html.en
International
- skolelinux.com (expires IX-2006)
- skolelinux.net (expires IX-2006)
- linuxsignpost.org (expired)
- linuxsignpost.net
- linuxsignpost.com
Norway
- linuxiskolen.no
- linuxiskulen.no
- skolelinux.no
- skulelinux.no
- skuvlalinux.no
- linuxveiviseren.no
- spist.no
...
Dynamic Pages
Reference Schools (slschools)
- Schools can register using an html form that is created by some php scripts. All data is stored in a central mysql database.
This database is used for different statistics and mappings, cf. ?DebianEdu/ReferenceSchools. The Database has got two tables:
- Table: school
Field |
Type |
Null |
Key |
Default |
Extra |
|
|||||
school_id |
smallint(5) unsigned |
|
PRI |
|
auto_increment |
update_of |
smallint(5) unsigned |
YES |
|
|
|
school_name |
varchar(255) |
|
|
|
|
school_postcode |
varchar(16) |
YES |
|
|
|
school_postlocation |
varchar(255) |
YES |
|
|
|
school_streetaddr |
varchar(255) |
YES |
|
|
|
school_comments |
text |
YES |
|
|
|
school_url |
varchar(255) |
YES |
|
|
|
school_joined |
datetime |
YES |
|
|
|
school_updated |
datetime |
YES |
|
|
|
deleted |
char(1) |
YES |
|
0 |
|
longitude |
decimal(20,17) |
YES |
|
|
|
latitude |
decimal(20,17) |
YES |
|
|
|
country |
varchar(255) |
|
|
no |
|
- Table: school_contact
Field |
Type |
Null |
Key |
Default |
Extra |
|
|||||
contact_id |
smallint(5) unsigned |
|
PRI |
|
auto_increment |
school_id |
smallint(5) unsigned |
YES |
|
|
|
main_contact |
char(1) |
YES |
|
|
|
contact_name |
varchar(255) |
YES |
|
|
|
contact_email |
varchar(255) |
YES |
|
|
|
password |
varchar(32) |
|
|
|
|
Problem
From time to time, obscure advertisements are placed in our Database.
Suggested Solutions
- Send mail to commits mailing list whenever a new entry is added.
- Hide URLs of new schools until an admin confirms the validity of the new entry
- Make URLs non-clickable in general.
ad 1: Any suggestions for implementation?
ad 2: Easy to implement by means of the status variable "deleted" that is already used to hide away "deleted" entries. Request for comments?
ad 3: Probably the easiest solution - but less comfortable. URLs probably need to be parted by spaces to turn off spammers...
Linuxsignpost
The Linux Signpost was launched from within the Skolelinux project to help people migrating to free software. One of its core facilities is a database of Windows (TM) applications that are mapped to free alternatives.
If you get a dump of this database, procede as follows to create your own copy: {{{# apt-get install mysql-server # mysqladmin -u root password ?Y0urS3cre7 # mysqladmin -p create win2lin # mysql -p mysql> \. /home/user/file.sql }}}
If we now apply a describe tables we learn that there is dozens of tables in that databse:
+---------------------------+ | Tables_in_win2lin | +---------------------------+ | Advertisement | | AssociatedDocument | | AvailableHardware | | Category | | Counter | | County | | Document | | DocumentCategory | | DocumentDocumentCategory | | I18nTextIndex | | Image | | ImageType | | License | | Link | | LinuxDistribution | | LinuxDistributionSoftware | | Locale | | Profile | | ProfileCategory | | ProfileSoftware | | Quote | | SchoolLevel | | SchoolType | | Service | | Size | | Software | | SoftwareCategory | | Topic | | TopicGroup | | TopicSoftware | | TopicType | | TranslatedText | | UnixVariant | | UseArea | | User | | UserFeedback | | UserGroup | | UserGroupUnixVariant | | Vendor | | slxschools | | slxuserquotes | +---------------------------+ 41 rows in set (0.00 sec)
This postscript document contains a graphical representation (UML) of the database layout.
This Openoffice document describes how to add translations.