Find Jobs
Hire Freelancers

Music Information Database website

$100-500 USD

Kapalı
İlan edilme: 14 yıldan fazla önce

$100-500 USD

Teslimde ödenir
I wish to build a comprehensive database of western classical music piano solo repertoire, inspired by imdb, using PHP with a MySQL backend. The site will feature links to performances on youtube, information at wikipedia and sheet music at google books and other sources. The main function of the site will be to allow users to find, view, compare and discuss piano music performances and sheet music and add their own ratings and comments. After an initial period of offline data entry to build up a basic dataset for the most popular repertoire, site users will be able to submit new information for addition to the database which will be verified by site staff before being added - so the site will need a suitable administrator backend to handle this. The database should be secured from SQL injection and user submitted information should be captcha protected to deter spam. As this is a self-funded personal project I welcome any suggestions for customizing existing open source components to help reduce coding time and cost (e.g. use of a CMS like Drupal or Joomla, or adopting a more wiki-like approach with mediawiki) as long as the specified functionality can still be achieved. The site design style can be simple and minimal, something like ninja.com. Ideally I am looking for an individual or company who can handle all design, coding and SEO as a package, but if you do not feel comfortable handling the design element please indicate your bid for the coding alone (inclusive of SEO implementation). Any additional coding (excluding bug fixing) needed to add features beyond those specified in the project brief will be paid for on an hourly basis so please also indicate your regular hourly rate. ## Deliverables Please see accompanying zipped excel document for page and field layout sketches. **Site Structure** Header This will include the logo, search box (with drop down menu for All: Composer: Title and Pianist), browse options (Composer, Title, Performance and Pianist) and login/logout/register/username's account. Also google's translate widget. Footer This will include links for Home, Add a Composition, Add a Performance, FAQ, Charts, Privacy, Feedback and Copyright notice. Lpanel - this will include links for: Add a composition Add a performance Update/correct Discuss Rpanel - this can be left empty at present, but it may be used later for ad space. Update/correct and Discuss will be page specific (i.e. relevant only to the page being viewed). Discuss will take users to a separate discussion board page. Adding composition or performance will take users to their relevant submissions pages. Using this basic template there will be the following pages: Home Page Signup/Login system Search result pages Browse result pages Composer pages Composition pages Pianist pages Performance pages Information pages User account system Submission/update system Administrator backend **Home Page** After the welcome message there will be daily updated top 10 charts for the most viewed pages in the following categories: Performance Pianist Composition Composer Performance will be based on view counts for individual performance pages. Pianist will be ranked based on the sum of all views of all performances by that pianist. Composition will be ranked based on the sum of all views of all performances of that composition. Composer will be ranked based on the sum of all views of all performances of all compositions by that composer These charts will be shown in top 10 list form with links to the respective browse pages next to each chart. In the left panel Update information and Discuss will be deactivated on this page. **User signup** The site will be fully searchable/browsable without signup, but users will need to register if they want to rate or comment so it will need a standard captcha protected signup system and regular login/logout/user account model. **Search results page** Searching will bring up lists of the top 10 results for each of the following: Composer, Title and Pianist. If there are more than 10 results in any category there will be a link to more results which will take the user to a full list of all results in that category. In the left panel Update information and Discuss will be deactivated on this page **Browse pages** These will be in the same column format as the four top 10s on the home page, but with more lines per page (e.g. 40? or however many lines fit conveniently on a standard page) and navigation page numbers below. Browse pages are sortable by clicking on the title of each column. Subsequent clicks on any column toggle sort between ascending and descending order. In the left panel Update Information and Discuss will be deactivated on these pages. **Naming convention for Composers and Pianists** In the event of two or more composers or pianists sharing the same name, a roman numeral ordinal will be assigned in the order of addition to the database. When names are displayed the ordinal will only be shown if there is more than one person with that name. For ease of reference composers and pianists will be referenced by the fields [composer name] and [pianist name], but these may consist of up to four possible subfields e.g. ([composer forename(s)] [composer surname] [suffix, if any] [ordinal, if any]) in the case of John Smith Jr. (IV) (if there were four or more composers named John Smith Jr.). **Naming convention for Compositions** For multi-movement works it is important that the movements come out in the correct order when users sort by title or by year of composition so the records will include a number value for each movement. Compositions will typically be referenced by the field [title], but that may consist of up to six sub-fields - [name of composition] [catalog or opus number] [number of movement] [name of movement] [year of composition] e.g Sonata in E minor, Opus 54, No.2 (1894) 1/. Allegro non troppo. **Composer pages** These will include the following information: (see Excel document) Composer name Pics (if any) Date and place of birth Date and place of death (where applicable) Biography - first line of text then "more" (linking to a separate information page) Trivia - first line of text then "more" (linking to a separate information page) Link to Wikipedia page Rank Performances - [N.B. this will link to the performance page of composers who are also pianists]. Each line links to another page which is the page for that particular composition **Composition pages** These will include the following fields (see Excel document) Title Composer name Alternative name(s) Trivia - single line of text then "more" (linking to a separate page) Link to wikipedia page Links to sheet music at google books or download site if available User rating (N.B. Compositions and performances can be rated but composers and pianists cannot) Your rating Rank Then have a list of all performances of that particular composition that link to individual performance pages. **Pianist page** These will include the following fields Name of the pianist Pics (if any) Date and place of birth Date and place of death (where appropriate) Current nationality Mini biography - first line of text then "more" (linking to a separate information page) Trivia - first line of text then "more" (linking to a separate information page) Link to Wikipedia page Rank (by the sum of views of any performances by this pianist - updated daily). Then there will be a list of performances by that pianist that link to individual performance pages. **Performance page** These will include the following fields Name of composition Name of pianist Year of performance User rating Your rating Rank (based on views of this particular performance - updated daily) Main content on the page will be an embedded video from youtube. Youtube videos can be live performances, audio with added visuals, or follow along video/scores. **Discussion Board page** This will be a generic discussion board page which can be used for any category, and will have the usual options to reply to start a new topic or reply to other users' posts. It will be accessed via the link in the left panel. **Information page** These will just have the expanded information of the line from where they linked, e.g. the biography or trivia links on composer or pianist pages. **Submissions system** User submitted data must be checked as each field is entered to ensure against repeat submissions or spelling mistakes. Since users will only need to add a new pianist if they are adding a new performance, and only need to add a new composer if they are adding a new composition there are only two main record addition options: Add composition and Add performance. All user submissions should be tied to a Captcha code to deter spamming. **Add a composition** When users select add composition they will be asked to fill out the following fields: Family name of composer A check will then be made to see if a record already exists for that composer. If it exists then the user jumps to entering the composition details. If the name is close to an existing record the user should be prompted with some sort of "did you mean" option. If they select one of the existing options they then jump to entering the composition details If it is a new composer to the system the user will be asked to enter details accordingly. If the new composer shares the same name as an existing composer an ordinal will be assigned. Users will enter: Forename(s) of composer (surname already entered) Suffix (e.g. Jr.) Year of Birth Date of Birth Town/City of Birth Country of Birth Year of Death Date of Death Town/City of Birth Country of Birth Biography Trivia Link to wikipedia page Pics (goes to browse/upload system) Thereafter users will move on to entering composition details. Since there are many compositions with the same basic title (e.g. Sonata in C minor) the user will need to enter all fields of the composition title before they are checked against existing entries. Title of composition Movement number Name of movement Opus or catalogue number Year of composition At this point the information should be checked against existing records to prevent repetitions. Once through this stage users will add additional information: Alternative/additional names Trivia Link to wikipedia page Links to sheet music at google books Links to sheet music at amazon Links to other sheet music sources In the case of multi-movement works users should be able to enter each movement one after the other. **Add a performance** When users add performances, the youtube URL should be checked again existing entries to prevent repetitions. If not already indexed users will be asked to provide further information. The composer name will be checked as in the Add composition procedure above, and users can add new composer details if necessary. Then the composition title will be checked in the same way and users can add new details if necessary as above. Then the pianist name will be checked and users can add new details if necessary. As with composers, an ordinal will be assigned to new entries sharing the same name as existing records. Family name: Forename(s): Suffix (e.g. Jr.) Year of Birth Date of Birth Town/City of Birth Country of Birth Year of Death Date of Death Town/City of Birth Country of Birth Biography Trivia Link to wikipedia page Pics (goes to browse/upload system) Following submission users will be sent a thankyou message to their registered email address. When the submission is verified and added to the database by site staff the submitting user will be sent another message to notify them of the addition. **Update/Correct** Update/correct allows users to add information to incomplete records (e.g. date and place of birth, biographical information etc.) or suggest corrections. Users will be shown a form containing all available fields for a performance, pianist, composition or composer and can then indicate which field or fields they wish to update or correct (e.g. by ticking boxes next to certain fields). They will then be sent to a page with a box for each requested field where they can input new information. **FAQ** Structured so that text can easily be added via the administrator backend as new questions are asked/answered. **Privacy and Terms Page** Generic text to explain privacy policy **Feedback/Suggestions** The site will also need a form for feedback and suggestions about site improvement.
Proje No: 2905293

Proje hakkında

26 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 14 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
26 freelancers are bidding on average $1.017 USD for this job
Kullanıcı Avatarı
See private message.
$743,75 USD 14 gün içinde
4,8 (121 değerlendirme)
7,2
7,2
Kullanıcı Avatarı
See private message.
$850 USD 14 gün içinde
4,9 (404 değerlendirme)
7,1
7,1
Kullanıcı Avatarı
See private message.
$382,50 USD 14 gün içinde
5,0 (48 değerlendirme)
6,0
6,0
Kullanıcı Avatarı
See private message.
$850 USD 14 gün içinde
5,0 (13 değerlendirme)
6,2
6,2
Kullanıcı Avatarı
See private message.
$340 USD 14 gün içinde
4,9 (45 değerlendirme)
5,8
5,8
Kullanıcı Avatarı
See private message.
$425 USD 14 gün içinde
4,8 (51 değerlendirme)
6,0
6,0
Kullanıcı Avatarı
See private message.
$8.500 USD 14 gün içinde
5,0 (13 değerlendirme)
5,7
5,7
Kullanıcı Avatarı
See private message.
$2.040 USD 14 gün içinde
3,9 (14 değerlendirme)
6,1
6,1
Kullanıcı Avatarı
See private message.
$595 USD 14 gün içinde
5,0 (69 değerlendirme)
4,9
4,9
Kullanıcı Avatarı
See private message.
$2.975 USD 14 gün içinde
4,9 (24 değerlendirme)
5,1
5,1
Kullanıcı Avatarı
See private message.
$297,50 USD 14 gün içinde
4,9 (17 değerlendirme)
4,2
4,2
Kullanıcı Avatarı
See private message.
$126,65 USD 14 gün içinde
4,6 (7 değerlendirme)
3,9
3,9
Kullanıcı Avatarı
See private message.
$425 USD 14 gün içinde
4,6 (23 değerlendirme)
3,6
3,6
Kullanıcı Avatarı
See private message.
$212,50 USD 14 gün içinde
5,0 (2 değerlendirme)
3,0
3,0
Kullanıcı Avatarı
See private message.
$127,50 USD 14 gün içinde
5,0 (9 değerlendirme)
2,8
2,8
Kullanıcı Avatarı
See private message.
$595 USD 14 gün içinde
4,0 (2 değerlendirme)
3,1
3,1
Kullanıcı Avatarı
See private message.
$425 USD 14 gün içinde
5,0 (4 değerlendirme)
2,1
2,1
Kullanıcı Avatarı
See private message.
$297,50 USD 14 gün içinde
5,0 (6 değerlendirme)
1,7
1,7
Kullanıcı Avatarı
See private message.
$255 USD 14 gün içinde
3,5 (7 değerlendirme)
2,7
2,7
Kullanıcı Avatarı
See private message.
$1.700 USD 14 gün içinde
1,8 (8 değerlendirme)
4,6
4,6

Müşteri hakkında

   UNITED KINGDOM bayrağı
United Kingdom
5,0
13
Ağu 12, 2008 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.