2494
Comment: added layout of school_contact
|
3556
Suggestions... To be continued
|
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 38: | Line 57: |
=== Problem === From time to time, obscure advertisements are placed in our Database. |
|
Line 39: | Line 60: |
= Further Information = * http://developer.skolelinux.no/dnsnames.html.en |
=== 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... |
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. It embraces 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...