Mu Un nltimedTítulo oMicroeleTítulo dPr INuevo plia/HipeJulficial de Ictrónica,e IngeniPor la Uof. Dr. FRATESIS SIDEanteamrmedialocales Autoio Enriqungeniero por la Uero TécniniversidaDirecNCISCO DOCT MEDIiento p y el reque cer r de la Te Vigara en Electrniversida co de teled Politéc tor de la JAVIER VORALALABara unscate draron.esis: Campmónica-Ted Autónocomunicnica de CTesis: ILLASEV . Livinge las te any lecomunima de Baaciones ataluña. IL MARC Lab levisioncación y rcelona.O. es 1TESISDOCTORALdeIngenieríaMultimediaINSIDEMEDIALAB.UnnuevoplanteamientoparaunLivingLabMultimedia/HypermediaAuthor Julio Enrique Vigara Campmany Julio E. Vigara Campmany: Nació en Barcelona, España, en 1965, y recibió licenciatura en telecomunicaciones, especializada en electrónica de la Universitat Politècnica de Catalunya (UPC) en 1990, y MS grado en electrónica, especializada en telecomunicaciones de la Universitat Autònoma de Barcelona (UAB) en 1997. Trabajando como profesor desde 1991 y ha realizado cursos de tercer ciclo de doctorado en electrónica y multimedia, pero debido a los numerosos acuerdos con compañías como AENA y la televisión local que no podía tomar el paso final que espero lograr este año y obtener el título de doctor. He publicado un artículo Q1 en Elsevier opiniones de energías renovables y sostenibles de alto impacto, ya que ha sido comprado por más de 300 personas. Espero que éste trabajo afectará de la misma manera y me permitirá crear otro artículo Q1 relacionado. Tanto yo como Francisco Javier Villasevil Marco estuvimos participando en un convenio como directores de la televisión local de Vallirana. La Tesis consta de un trabajo con objetivos y resoluciones, el diseño de una plataforma multimedia, Resuelta la primera parte y continuamos con la técnica de rescate de las televisiones locales que han cerrado usando la red internet. Ambos trabajos funcionan y solo falta que se pongan en marcha. 1: A new concept flexible MEDIA LAB for research solutions in all fields, electronics, education, communication, Local TV programs and others and Project design for displaying video and other content.2: Using the network for the rescue of local TVs programs and design method and techniques of sending TV programs using the network Director de la Tesis: F.Xavier Villasevil Marco. Presidente de la federación de televisiones locales de Cataluña AGRADECIMIENTO–ACKNOWLEDGMENT:POR EL APOYO DADO A ESTE TRABAJO, EL RECONOCIMIENTO AL EQUIPO DE INVESTIGACIÓN INSIDE; CUYO DIRECTOR ES FRANCESC X. VILLASEVIL LA URL QUE SE PUEDE ACCEDER ES HTTP://WWW.CTVG.UPC.EDU/IDIOMA_EN.HTML. MI CORREO ELECTRÓNICO DE CONTACTO PARA MÍ COMO AUTOR PRINCIPAL ES JULIO.VIGARA@UPC.EDU. FOR THE SUPPORT GIVEN TO THIS WORK, RECOGNITION INSIDE THE RESEARCH TEAM; WHICH THE DIRECTOR IS FRANCESC X. VILLASEVIL THE URL CAN ACCESS IS HTTP://WWW.CTVG.UPC.EDU/IDIOMA_EN.HTML. MY CONTACT E-MAIL FOR ME AS LEAD AUTHOR IS JULIO.VIGARA@UPC.EDU. 2 index – Contents 1 .1.Abstract,inpage6 I–IntroductiontoLABphilosophy,inpage6 II - Related work, in page 6 IIIOurproposedsystem,inpage7IV=4- Project design for displaying video and other content, in page 9 4.1 Simulation of small stations, in page 10 4.2 Objectives, in page 10 4.3 User administration, in page 11 5. Technology Assessments, in page 12 5.1 Programing languages, in page 12 5.2 Databases, in page 12 5.3 Tools used , in page 13 6. Initial planning, in page 14 7. Analysis, in page 14 7.1 The problem, in page 14 7.1.1 Problems of local media, in page 14 7.1.2 Internet as unifying, in page 15 7.2 Glossary of terms, in page 15 8. Design, in page 16 8.1 Database- Creation of the database, in page 19 8.2 Use cases of the system, in page 21 9. Implementation, in page 23 9.1 Management modules and content, in page 24 9.2 Modules, in page 26 10. Manual to program modules., in page 30 10.1 Structure of the workforce, in page 31 11. Structure of the archives of styles., in page31 11.1. Structure of modules., in page 32 12.To browse the web can use the menu on the next page:34 12.1. File hosting, in page 34 12.2. Creating a website, in page 34 12.3. Configuring the Web, in page 35 12.4. Recorded content, in page 36 12.5 Configuring the web, in page 36 13. Conclusions , in page 38 14. REFERENCES, in page 39, page 40 15. Appendix: Software used. (In the research work) , in page 40 and page 41. 3 16.ABSTRACT,inpage4216.1Introduction‐what happened to arrive at the fall of local televisions? In page 42 17. Related work, in page 46 18.TVconcepts,inpage4618.2.Playlistalternatives,inpage4619.IEEpossiblestandardtoWatchIPvideostreamingasaregularchannelonasmartTVormobiledevice,pg4820‐HowitcanbeconnectedtoasmartInternetTVprogramToreceivethelocalTVchannel.Page48‐4921‐Design plan for local television, in page 49 22 Introduction , in page 49 23 Background , in page 53 23.1 Igson-Automatización.TV , in page 54 23.1.1 Igson Playnow, in page 54 23.1.2. Playnow Plus Igson options, in page 55 23.2 DVD Player, in page 57 23.3 VSN LIVECOM , in page 58 23.4 Stream Labs, in page 59 23.5 Other , in page 60 24 Tools used in the development , in page 60 24.1 Programming Environment, in page 61 24.1.1 Use and variants, in page 61 24.1.2 The programming language, in page 61 24.1.3 Components, in page 62 24.1.4 Events, in page 62 24.1.5 Databases, in page 63 24.2.1 Overview, in page 64 24.2.2 Diagram, in page 64 24.2.3 Composition of VideoLan , in page 65 24.2.4 New work, in page 65 24.2.5 formats, in page 65 424.3 libvlc Library VideoLan , in page 66 24.3.1 Exception Handing, in page 66 24.3.2. Core access to VideoLAN, in page 66 24.3.3 Management playlist, in page 67 24.3.4 Handing audio, in page 68 24.3.5 Management of the video, in page 69 24.3.6 VideoLAN Manager, in page 69 24.3.7 Operation of the input signal, in page 70 24.4 Matrix video / audio switchable TZM883VA Elpro TZM 883VA, in page 71 24.4.1 Connection from Remote Host, in page 72 24.4.2 Commands from the remote host, in page 72 24.4.2.2 Video Switch, in page 73 24.4.2.3 Switch Audio, in page 74 24.4.2.4 Switching Video and Audio at the output Preview, in page 74 24.4.2.5 Prior Switch Video Output, in page 74 24.4.2.6 Prior Switch Audio output, in page 75 24.4.2.7 Silence in the previous output, in page 75 24.4.2.8 Create Program, in page 76 24.4.2.9 Activate Program, in page 76 24.4.2.10 Enable / disable the default settings, in page 77 24.4.2.11 Enable / disable output Previous, in page 78 24.4.2.12 Setting the switching times, in page 78 24.4.2.13 Status request for connection, in page 79 24.4.2.14 Application global state, in page 80 24.4.2.15 Application switching times, in page 81 24.4.2.16 Application identifier connected matrix, in page 82 525 Design , in page 82 25.1 Add file to list , in page 82 25.2 Add MRL to the list , in page 85 25.3 Direct Add to Wishlist , in page 86 25.4 Add other signal source to the list , in page 86 25.5 Include Logo and / or text in a list row , in page 86 25.5.1 Logo, in page 87 25.5.2 Text, in page 88 25.6 Delete a row from the list, in page 90 25.7 Press Play , in page 92 25.8 Press Play Scheduled, in page 93 26 results, in page 93 26.1 Create a playlist of level 1 and save , in page 93 26.2 Include Logo and / or text in a list row , in page 95 26.3 Playing a playlist programmed level 1, in page 96 27 User Manual , in page 97 28 Global Conclusions , in page 100 29 – References , in page 101 61: Doctoral Thesis Final Author Julio Enrique Vigara Campmany Director: F.Xavier Villasevil Marco. Objectives: 1: A new concept flexible MEDIA LAB for research solutions in all fields, electronics, education, communication, Local TV programs and others and Project design for displaying video and other content continuing with 2:Using the network for the rescue of local TVs programs and design method and techniques of sending TV programs using the network. 1: Abstract THIS research will lead MEDIA LAB to a concept of unifying philosophies, helping to publish multimedia content and share research works. This internet LAB is also a multimedia developer-testing platform, allowing experiment with either new technologies or projects. In this document, we will explain and justify how these philosophies come together, helping researchers, developers, producers and authors to expand their work through multimedia. Index Terms — Multimedia, Living LAB, ubiquitous computing, open source, dynamic grow, database’s, templates, virtual teams. I – Introduction to LAB philosophy WE will start explaining why our research proposal allows our laboratory to be different, with features and very broad alternatives. On the web, you can find many successful projects like Source forge, Gnu and others, which are dedicated to the development of free software. Other projects such as Facebook or Twitter are positioned as social networks, while YouTube, Google Video, and online radio stations are broadcast webs. There are other sites like the Encarta Encyclopedia, Wikipedia, Britannica Online, which are dedicated to education, information and journalism. Horizon 2020 may look similar but it really isn’t. Some of these projects could be considered to be Living Lab areas for developers or end users. Many projects in the web present text, images, audio, video, and interactive content. It is clear all these sites present some of these content types. There are many who are engaged in research and development of electronics, hardware, software, and social sciences. Other platforms enable content producers in the net to expose their work, and there are platforms that offer to broadcast your own video and audio content. Our work is raising a new concept that brings together different philosophies and technologies in one package. It provides numerous solutions to a diverse number of user profiles. This is achieved by means of versatile, reconfigurable core software, allowing the system to grow dynamically, thanks to contributions of different profiles of developers that can store all wok in databases. II - Related work PREVIOUS research has proven the project is viable. The answer of what the Living Lab philosophy is depends on who you ask, as there are big differences between existing Living Labs [3]. Asbjørn Følstad Abode, and other colleagues of the Georgia Institute of Technology, seems to be the first to use the “Living Laboratory” term to refer to a real world where users have the opportunity to use state of the art technology, while other authors like Inutile or Beige, define “Living Lab” as a test bed of ubiquitous computing environment [3]. Our proposal fits all previous definitions, offering a Living Lab, which has two basic functions, included a multimedia software science research and innovation, and a test area for end users and developers. These could be the defining characteristics of a complete Living Lab, having to consider all aspects which are documented and discussed in literature on this topic [1][2][4][5], while also studying some work that has been under way [6][7][8]. In fact, Owela project [9] is a good example of what can be this kind of laboratory, offering solutions and analyzing possible problems that may occur. Mobility is nowadays a hot topic and their inclusion is not ruled out in this proposal, as described below, and in all referenced literature. 7Open Source concept, as described by Ion Ivan in his Open Source Scientific Journal [9], can be summarized as a test of the use being made of a developed software, both by end-users and developers, to improve and develop. Access to source code programs is also allowed. Nowadays these programs almost cover all areas, offering complete solutions to a growing number of end users. But this philosophy is not free of problems like ethics, new guidelines, strategies, development style, licensing, legal aspects, distribution policies, and others. This, as will be seen later when describing Open Source Living Lab, shows that the proposed management system has some difficulties. It is therefore important to assess developer’s appropriateness and level to provide certain guarantees, and if possible, collaborating as virtual teams [10]. III Our proposed system CONSIDERING that this is a research laboratory for the development and use of multimedia technologies, to be applied in education, electronics and other sciences, we encountered a large universe of concepts, technologies, philosophies and possible problems. There is already a problem when you want to define and differentiate between Multimedia and Hypermedia [11]. Multimedia can be used outside the Internet context, while Hypermedia implies network only. Can interactive Multimedia be used? It seems not to be very important to be rigorous with these definitions, as computers and mobile devices make the use of network connectivity implicit. The INTERMEDIA project [12] defines guidelines regarding the sharing of media on network environments, and although specifically its proposal is based on UPnP technology, our proposal will be valid for any number of environments, adapting ideas to Internet environment. You can clearly see how much multimedia research is dedicated to interactive and indexing search tools, media recovery and database systems, for media and user environments [13] classic or not. In any case, our work supports all possibilities when it comes to Multimedia and/or Hypermedia. Our proposed system supports dynamic growth, and can be adapted to any multimedia need, it has a core management, and its implementation is based on reconfigurable object technology, instead of being based on ports [15], as well as variables and threads. If objects can recursively call other objects, the system becomes complicated. Reconfigurable software supports the possibility of different uses, but the two most important factors are to prevent execution failures due to lack of an object or an object error, and second, to adapt the execution to the users’ needs; they are both referred to in this work. Bruneton et al [14] proposed an idea based on a model of configurable components to be shared, and this is exactly what suits our needs. Therefore, the idea implemented in this research is similar to the model of fractal components exposed [14]. In our proposal, there is no special distinction between components and objects, which both have been renamed “modules” in our work. After using different technologies in this analysis, we have not found any system equal to this one on the web, therefore we consider it very different, and its basic characteristics are: • It allows adding any multimedia application as a new research project (Electronics, Education, video, radio, tourism, advertising,) • It allows testing and validating apps created for final use. • Within each project, there is a list of multimedia applications (like electronics and education websites, video,) • It allows adding newly developed framework assistants, to facilitate a complete customization of producer multimedia applications. • It allows including new modules developed, or using existing ones at any location, to be used as components of final applications. • The number of users, projects, developments and final applications can grow as needed. • Any work, software or media content can be shared. There are databases to control all works, activities and statistics. • It facilitates the translation of all texts used in any language. • Any documentation needed will be available for the use of this system by all users’ categories. To become a Living Lab, a strong statistical control must be implemented over all system parameters to have feedback of the use and functionality of all innovations. It can be assumed that the term “innovation” may refer to research in the areas of electronics, education, multimedia software, content development, and communication techniques. 8 Fi Thitechnias shoThe1. 2. 3. 4. user”,Theany oand usA “threadcorresreferethe deinterfeThetemplexecudefautempl gure 1: Strucs lab systemques and dynwn in Figure re are four usThe “End The “ProdThe “DeveThe “Mast who only has process startther combinae specific mutemplate” on. A “module”ponding datance. The prodveloper respering the prev CORE’s runates and protion to reconlt module in sates can be alture of Mult is targeted amic reconfig1. er categoriesuser”, who haucer” who haloper”, who der researcher access privils with a specition. Researcltimedia techly contains i is just an obbase containsucer will deccts its initialiously generatime kernel cess threads, figure it for ame class, inlocated in diffimedia Onlinat multiple turation. All o, from low to s access to cos privileges toevelops mod”, who has allege, must valfic profile proh projects hanologies. nformation aject, a block o a set of moduide which mo configurationted applicatiosystem is ablextracting aeach Produc case of failurerent servers,e Living Laypes of userf this is manhigh level of pntent through personalize hules and/or te system priviidate lower leject or researve common bout modulesf code that ples that can pdule is suitab parameters ns. e to process ll necessary er’s preferene. This can b increasing sy b. s, including aged by databrivilege, clas an internet wis web mediamplates for Pleges. A Mastvel users. ch, like electrobjectives, sh and their coerforms a taskerform simille to developwhen a moduthrough an apinformation ces, and evene seen in modstem growth a core that inases, and consified as folloeb link. and content.roducer suppoer research uonics, video, ared applicatnfiguration, or function. ar functions, o his platform.le is modifieplication thafrom databas automaticalule 17 of Figpotential. corporates gfiguring the sws: rt. ser, except thradio, educations and temwhen performOur idea is thne of them b It is necessad or improvet uses one ore. This allowly replaced bure 2. Modulrowth ystem e “end ion, or plates, ing a at the eing a ry that d, not more s the y the es and 9Figu AnyapplicAt incorpsystemtemplas thedistribAn for theTo will bneces Fig IV=4. re 2: Exampl input by usations. first sight, itorates class l manages evates that are ly fulfill theiute their worimportant pa entire systemprepare an ape able to set usary functionaure 3: Appli Project dese of system reers should b might look ibraries and oerything fromocated in exter function. Itk. rt of this Lab can be colleplication or p a grid wherlities, as reprcation designign for dispsponse to a the tested and like the systebjects execut a database. rnal servers. I also helps Pis data colleccted in specifprogram we ae modules caesented in Fig tool using telaying videread with a mvalidated oncm structure ed by a runtiThe databaset is irrelevantroducers to tion and usagic fields of thre developinn be placed vure 3. mplates ando and othe odule error.e it has passis similar to me core, but keeps the ac which progracreate their oe statistics ofe existing datg a specific tisible or invi modules on r content ed final tests any programmthis is not trucess informatmming languwn websites multimedia. abases, or alsoemplate. Withsible, to proviasymmetric for use in sping language at all, becauion to modulage is used, aand/or channThe usage sta in other data this templatde the applicagrid. ecific e that se the es and s long els to tistics base. e, you tions’ 10 4.1. SWhilebroadmake Of all This TV ar 4.2.O The mwho We acontediffer (web Try afriendconteituation of s all broadccast, severa a small sum the concesssituation hae receivingbjectives. ain objectwants to shlso try to pnt. It will sent platform and other platform tly and attrnt that wamall stationsasters havel factors hamary of hoions that wes also bee TV programive of this are differenrovide devtop operatis devices). hat is openactive for dnts to pub. tried to mve caused tw the situatire granted tn processe through thproject is tot types of celopment tong platform to everyonifferent typelish. Also ake the che result is on has beeno broadcastd in the P2e network. support sontent. ols to cus to share be, with mans of usersfor those hange fromnot adequat the transitioin digital, thesection giv mall local btomize the oth contenty possibili, from thosewho want analog broe. It is theren after the situation is ing a solutiroadcastersway you wa and prograties and a l who just wto scheduladcast to fore necessdigital switchas follows: on for the s and everynt to sharemming codong life.Muant to cone new featdigital ary to over. mart body this e for st be sume ures. 11 It will be a platform that should not stop growing even though the project is given as a finish. One goal is to be transformed into a lively platform not stop receiving new features and content in the coming years 4.3 User administration because we have different types of users, we maintain control of the different roles and differentiate what are the actions that can be performed. For example, a publisher, by creating websites and publish content, but in no way can contribute new code modules. Management modules Apart from the management platform, the project will grow by publishing modules. These files are coded to use that functionality to the websites created. Initially, some modules will be provided to give life to the initial system, but it is expected that developers can contribute their different modules to enhance the possibilities of the platform. Content Management On another important part of the project is the ability to manipulate multimedia content. To achieve it, we must be able to manipulate a database with different types of content, from video and sound to text and pictures. In principle, this content might hosted on our server or external servers. Limitations in our server makes us rethink the issue and possible accommodation for the content remain limited to external servers. Variety of projects Try to accommodate such a variety of projects and content as possible. The idea is that both scientific communities, educational and entertainment can create your website to disseminate its contents. Since it is an open platform where everyone can contribute their piece of code, one of the objectives is to just find the component you need to build your website, whether the subject matter is, regardless of the type of content you want published. Lifetime:Asitpursuesadevelopmentprojectevenafteritscompletion,itwillseekleavesufficientdocumentationinordertoexpanditsfeatures.Inaddition,thepossibilityofprogrammingmodulescanresultinnewfeaturesthatwerenotoriginallycontemplatedThatiswhy,iftheprojectissufficientexternalsupport,itisexpectedthattheirlifeisverylong.Ifitbecomeslargeenough,itcanleadtoabusinessopportunityintheformoftechnicalsupportorotherservices,notonlyforprojectmanagers,butalsofordevelopersandcontentpublishers.Youcanalsobecomeaplatformthatgivesdevelopersandknowntoyoungartistswhoarenomorewaytopublishtheircreations.AlthoughtheservicealreadyofferedbyotherportalsontheInternet,thisisonlypartofourprojectbyofferingallegedlypossibilityincalculable.125.TechnologyAssessment.Given thevariety of toolsthat can be foundfor the realizationof this project,a studyis necessaryto determinewhat arethe most appropriateto achieve the objectives.Someaspects to considerare the following:Access.Accessibility.price.ease of use.Adaptation.5.1.Programminglanguages.HTML:HTML(HyperTextMarkupLanguageacronyminCatalan,"HypertextMarkupLanguage")isamarkuplanguagederivedfromSGMLtextsdesignedtostructureandrelatethemintheformofhypertext.ThankstotheInternetandwebbrowsershasbecomeoneofthemostpopularformatsexistfortheconstructiondocumentsfortheWeb.PHP:PHPisaninterpretedprogramminglanguageusedtocreatedynamicwebpages.Runsontheserverside,whichiswhythewebbrowseralreadyarrivesHTMLpagemaynotdisplaythecodephp.Althoughlesspopular,canalsobeusedtogeneratecommandinterfacesandapplicationswithGUIexecutables.IthasversionsforbothWindowsandGNU/Linux,andothers.JavaScript:JavaScriptisascriptinglanguagebasedontheconceptofprototypes(inheritancebydelegation),originallyimplementedbyNetscape,whichledtotheECMAScriptstandard.Heisbestknownforitsuseinwebpages,butalsousedinotherapplications.Despiteitsname,JavaScriptisnotderivedfromtheJavaprogramminglanguage,butbothshareasimilarsyntaxinspiredlanguageC.Semantically,JavaScriptisclosesttothelanguagesSelfandActionScript(alsobasedontheECMAScript).Thename"JavaScript"isaregisteredtrademarkofSunMicrosystems.5HTML5:HTML(HyperTextMarkupLanguageversion5)isthefifthmajorrevisionofthecorelanguageoftheWorldWideWeb,HTML.HTML5specifiestwovariantsofsyntaxforHTML:a"classic"HTML(text/html)variant,knownasHTML5,andavariantXHTMLknownassyntaxXHTML5whichmustbeusedasXML(XHTML)(application/xhtml+xml).ThisisthefirsttimethatHTMLandXHTMLhavebeendevelopedinparallel.ThedevelopmentofthiscodeisregulatedbytheW3C.5.2.Databases. MySQL: MySQL is a management system relational database (RDBMS English - Relational DataBase Management System) multi-thread (multithread), multi-user, which uses the language SQL (Structured Query Language). MySQL has become very popular because of its speed and its run queries natively supported by the PHP (up to version 4.X of this language since version 5 from left-dining it), in the development of web applications in the environment of free software. 135.3.TOOLSUSED.INTERNETINFORMATIONSERVICES:MICROSOFTINTERNETINFORMATIONSERVICES(IIS,FORMERLYCALLEDINTERNETINFORMATIONSERVER)ISASETOFINTERNET‐BASEDSERVICESFORSERVERSUSINGMICROSOFTWINDOWS.APACHE:APACHEHTTPSERVERISASERVERHTTP(WEB)OPENSSOURCEPLATFORMDEVELOPEDBYAPACHESOFTWAREFOUNDATION.APACHEHASAMONGOTHERFEATURESHIGHLYCONFIGURABLEERRORMESSAGES,DATABASEAUTHENTICATIONANDCONTENTNEGOTIATION,BUTWASCRITICIZEDFORTHELACKOFAGRAPHICALINTERFACETOHELPSETITUP.ADOBEDREAMWEAVER:DREAMWEAVER,ADOBEDREAMWEAVEROFFICIALLYCALLED,ISCURRENTLYAPOWERFULTOOLFORWEBDEVELOPMENT.ITWASORIGINALLYCREATEDBYMACROMEDIAASAWEBPAGEEDITORWYSIWYG,WHILEGRADUALLYINCORPORATINGSUPPORTFOROTHERWEBTECHNOLOGIESSUCHASCSS,JAVASCRIPT,ANDRECENTLYSUPPORTEDPROGRAMMINGLANGUAGESSERVER(SERVER‐SIDESCRIPTING)ASCOLDFUSION,JSPPHP,ETC.DREAMWEAVERISAVAILABLEFORBOTHMACANDWINDOWSPLATFORMS.ADOBEISCURRENTLYOWNEDSINCE2005,THECOMPANYPURCHASEDMACROMEDIA,ANDISSOLDASPARTOFADOBECREATIVESUITESOFTWAREPACKAGE.COMPOSER:COMPOSERISANOPENSOURCEEDITORBASEDONTHENVUEDITOR.COMPOSERISMAINTAINEDBYTHESAMEUSERCOMMUNITYTHATBRANCHOFFTHEPROJECT,ANDAPROJECTONSOURCEFORGE.THEREAREBINARIESAVAILABLEFORGNU/LINUX,WINDOWS,MACOSXANDOS/2.In March 2007 he commented on Download.com, who was considered one of the best free alternatives to Adobe CS3, and compared favorably with Adobe Dreamweaver Notepad ++ Notepad ++ is a free source code editor which supports several programming languages and works under MS Windows. This project, based on Scintilla edit component (a very powerful editor component), written in C ++ with pure win32 api and STL (that ensures fast execution speed and smaller program size). It is under the GPL. Kate: Kate is a text editor for KDE. KDE Advanced Text Editor Kate means, ie, advanced text editor for KDE. Kate is part of the kdebase package since version 2.2 of KDE from 15 August 2002. Due to the technology that is part of KDE KParts is possible to place Kate like an editing component to any KDE application . The integrated development environment, KDevelop and web development tool, Quanta are two of the most important KDE applications using Kate as editor component. Firebug: Firebug is a Firefox add-on that helps you to edit, test, and monitor CSS, HTML and JavaScript on any web page. FileZilla: FileZilla is an FTP client for Windows, Linux, FreeBSD and MacOS X. It is free software and open source, GPL-licensed. It supports FTP, SFTP and FTP over SSL. FileZilla Server is the server that handles provide FTP service. 14OpenProj: OpenProj is a project management software designed as complete replacement for Microsoft Project, able to open project files Native program. It runs on the Java platform, allows it to be run in a variety of different operating systems. Visual Paradigm: Visual Paradigm for UML is a visual modeling tool for all types of UML diagrams. It supports extensive management use case diagrams SysML requirements and design databases (with ERD) and delivers the most effective efforts on the analysis and design of systems. Day: Day is a general purpose graphics application for creating diagrams, developed as part of the GNOME project. It is built in a modular way, with different packages for different needs. 6. Initial Planning. For the development of the project, the work is divided into five main parts: Analysis Requirements. Design. Implementation. Testing. Documentation. 7.Analysis.7.1.THEPROBLEM.7.1.1.Problemsoflocalmedia.ThearrivalofnewdigitalchannelsbroadcastbothonTVandtheradio,hasmeantaradicalchangeintheapproachtotheaudio‐visualproductionanddistribution.Ononehand,theteamshavechanged,remaininganalogytotallyobsolete.Theyhavealsochangedthepost‐productiontechniquesandfilesystemcontent.Ontheotherhand,emissionsystems,whichhavehadorhavetobecompletelyrenovatedandhasmodifiedthedistributionofradiospectrum,tryingtolegalizehavingsurveyedallexistingstations.AllthechangeshaveresultedormayinvolvelargeinitialinvestmentsthatnotallstationscanaffordanddemonstratesclosingLocaliaTV,TVValliranaandnoopeningofmostlocalpublicradiostations.AndthedigitalbroadcastDVBandDABhavetheadvantageofplacingradiospectrumusemultiplechannelsonasinglebroadcastchanneliscalledamultiplechannel,andthedisadvantagethatthebroadcastersshouldsharemultiplechannelreachanagreementorsharingthesamecoveragearea.Furthermore,Spainwasplanningmultiplechannelsinsufficienttocovertheneedsofallsmallpublicbroadcastersexist,pretendingthattheyremainundershareissuanceandcharges,arguingcostandhighenoughhourlyjobsGrilleddailybroadcast.ThisnationalplanforDTT(DVB‐T)hasfailedmainlypublictelevision(municipal)havenotcometoreachanagreementtojointlyissuedorhaveabandonedtheprojectincitedbythestrongeconomiccrisisis'isexperiencingtoday.Inthecaseofradio,DABhasbeenparked,becausethemajorityoftheaudienceusesmobileradio,inthecarortransport,withanaloguereceivers.15Doesthismeanthatdigitalradiomediahavefailed?No,theyhavenotfailed.TheEmpresssufficientlystrongandsupportedbyappropriateinstitutionalissuesandhavemadeadequatecoverage.Inthecaseoflocalpublictelevision,insomecases,giventhepoorqualityorvarietyoftheiraudio‐visualproductionhasbeenmoreinterestinpublishinglocalnewsthroughothermediasuchasnewspapersortheAncienttraditionalweb,causingproblemsdiscussedtheclosureofthetelevisionstation.7.1.2.Internetasunifyingandmakingpossiblemedia.TokeepalocalenvironmentwithlowbudgetsolutionwouldbelikeusingtheInternet.Thisplatformisexpectedappropriateforthefollowingreasons:‐Canbeusedtopromoteanytypeofmedia:press,photography,soundandvideo,bothliveandondemand.‐Havesufficientcapacitytoensuresufficienttechnicalqualityofthecontentandqualityofservice.‐Thecoverageandqualityisincreasing,andinsomecitiesareimplantedopticalfiber.‐Itisnolongernecessarytousethecomputertocheckthecontents,andbecausetheresettopboxesmediaplayersthatallowviewingdirectlyonTV,eventelevisionsthatcandodirectly.Norneedasoundsysteminthecaseofaudiocontentsuchasradio.‐Itisaccessiblefrommobiledevicessuchasphones,laptops,etc.‐Expandthescopeofdisseminationwithoutincreasingthecost;therefore,anyproposalwouldbevalidforthenon‐localmedia.‐Cangrowthenumberofbroadcastersorpublishersofcontent,encouragingjobcreation.Furthermore,wecanconcludethatitwouldbeveryproductiveandusefultoofferafreesolutionforusersbasedonIPtechnology,whichallowstosurviveorexpandanymeansofdiffusion.Thedevelopmentofitscomplicatedstructurebasedonautonomousgrowth‐orientedlevelsofusers,maintenanceandimprovementandadaptationtonewtechnologieswillbethegoalofthisproject.7.2.Glossaryofterms.Modulewillbepartofthefinalwebsite.Willbededicatedtospecificfunctionality.Theunionofdifferentmoduleswillprovideallthewebsitefeaturesandfunctionsdesired.Style:Thispartisresponsibletokeeptheconfigurationofourwebsite.Itwilldefinethefont,backgroundcolour,language,andotherissues.16WebInterface:Thisisthefinalresult.Thiswillbethevisitorsoradministratorscanviewormanipulate.UsersVisitor:Isthepersonwhoconsultsthewebsite.Readnews,videodisplayandenjoyyourcontent.Publisheristhatcustomizesaprojecttopublishcontent.AlsoGuest.Developer:Youcancreateandaddmodulesandtemplates.Youcanalsocreateconfigurationsforthem.AlsoPublisher.SuperUser:theuserisresponsibleformanagingtheproject.Decidewhichmodulesandtemplatesaresuitableforuse.Manageusers.AlsoDeveloper.Content:Istheinformation.Thisiswhatwewanttoconveytovisitors.Itmaybeofdifferentformats:video,text,andimage.Title:Thisisthepartthatwillserveasheadofourinterface.Page:Containercontentthatprovidetheweb.Navigationbar:Elementwillallowustoaccessdifferentpartsofthesite.Template:Itconsistsofaschemathatdefinestheshapeofthepagescontainedonourwebsite.Design:Referstowhatkindofdatawerepresentandwhatelementsareinvolved.Project:Definethepurposeofourwebsite:television,print,video,radio,etc. 8. Design. The platform for the development of multimedia websites consists of a database and centralized files on our server. Moreover, the media will be decentralized in several external servers and possibly in our centralized server. The execution of any portal will be in several stages in order to bring together the different elements necessary to show visitors a site is finished and the contents. 17BasicesdimlocaAtmodworOthe mIt is pof vibuildwhically, it consisThe firs.epsevg.upc.te the conten this stage weules which ck. Some maytitle bnce we have odules to be ossible that deos, it is poIn order to ing a databash consists ofThets of three stt step is to upes/inside/pagts. To do so, identify theontain and e give a list ofars, etc. Othstructured thloaded. Theythe work doessible that thyou with theorganize thee with sever a web platfo result repreages: the booexplaiload the file es/indes.php it calls for thmoS web databasxecute in ord videos, newsers may not e website, se have appeamodule thas not end here player belo necessary in informational tables. Therm that facilsented the to k Web searcn how these Ask the wethat makes "). Normally pe database tdules consist earch Modue structure aer to shape t, forums, etcbe visible bu Search contearch the conled to the datt creates a li e. For examngs to anothformation to9.1. Databas on the proje constructionitates the devsq. calls. ol Visual Pah modules anstages. b index" for thp or html chat contains ing. les nd extract ithe web. The . Others mayt do work asnt tents touchesabase in ordst of videos.ple, in the caer module. T find the cone. ct and the sit of this is doelopment ofradigm is thed search conhe site in queontaining bathe informat. Within thismodules are be navigatiocompile stat. These will ber to find these of a moduhen he calledtent (video). es that are dne with the t a visual way following patent. Then bstion (upc-sic information necessary structure wethose who don bars, watcistics. e determinem, as the casle that builds this and proerived from iool phpMyA, instead of uge: riefly ion to for seek the hes, d by e of a a list vide t, dmin, sing 18 19 8.1. Creation of the database. - PhpMyAdmin SQL Dump - Version 3.3.9.2 - Http://www.phpmyadmin.net - - Server: localhost - Time to generation: the 23-01-2012 at 22:17:00 - Server Version: 5.5.10 - PHP Version: 5.2.9 SET sql_mode = "NO_AUTO_VALUE_ON_ZERO"; / *! 40101 SETOLD_CHARACTER_SET_CLIENT =@@CHARACTER_SET_CLIENT * /; / *! 40101 SETOLD_CHARACTER_SET_RESULTS =@@CHARACTER_SET_RESULTS * /; / *! 40101 SETOLD_COLLATION_CONNECTION =@@COLLATION_CONNECTION * /; / *! 40101 SET NAMES utf8 * /; - - Data Base: `prometeo` - - ------------------------------------------------ -------- - - Structure of the table table for `configs` - CREATE TABLE IF NOT EXISTS `configs` ( `Name` char (255) NOT NULL, `id` into (10) NOT NULL AUTO_INCREMENT, `File` char (255) NOT NULL, Author` `into (10) NOT NULL, `Description` char (255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT = 10; - ------------------------------------------------ -------- - - Structure of the table table for `contents` CREATE TABLE IF NOT EXISTS `contents` ( `id` into (10) NOT NULL AUTO_INCREMENT, `Title` char (255) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL, `Comment` text NOT NULL, `Text` text NOT NULL, `File` char (255) NOT NULL, Uploader` `into (10) NOT NULL, `Project` into (11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE = Inorb DEFAULT CHARSET = latin1 AUTO_INCREMENT = 7; - ------------------------------------------------ -------- - - Structure of the table table for `languages` CREATE TABLE IF NOT EXISTS `languages` ( `Id` into (2) NOT NULL AUTO_INCREMENT, `Name` text NOT NULL, 20 PRIMARY KEY (`id`) ) ENGINE = Inorb DEFAULT CHARSET = latin1 AUTO_INCREMENT = 5; - ------------------------------------------------ -------- - - Structure of the table table for `modules` - CREATE TABLE IF NOT EXISTS `modules` ( `Name` text NOT NULL, `Id` into (11) NOT NULL AUTO_INCREMENT, `File` text NOT NULL, Author` `into (11) NOT NULL, `Description` text NOT NULL, `Sample image` text PRIMARY KEY (`id`) KEY Author` ` (` Author`) ) ENGINE = Inorb DEFAULT CHARSET = latin1 AUTO_INCREMENT = 7; - ------------------------------------------------ -------- - - Structure of the table table for `projects CREATE TABLE IF NOT EXISTS `projects` ( `Id` into (11) NOT NULL AUTO_INCREMENT, `Name` text NOT NULL, `Description` text NOT NULL, Responsible` `into (11) NOT NULL, Template` `into (11) NOT NULL, `Modules` text NOT NULL, `Id` KEY (` id`) ) ENGINE = Inorb DEFAULT CHARSET = latin1 AUTO_INCREMENT = 2; - ------------------------------------------------ -------- - - Structure of the table table for `statistics` - CREATE TABLE IF NOT EXISTS `statistics` ( `Id` into (10) NOT NULL, Aliases `into (10) NOT NULL, Date` date `NOT NULL, `Hour` time NOT NULL, PRIMARY KEY (`id`, ` Alias`) ) ENGINE = Inorb DEFAULT CHARSET = latin1; - ------------------------------------------------ -------- - - Structure of the table table for `templates` - CREATE TABLE IF NOT EXISTS `templates` ( `Name` char (255) NOT NULL, `Id` into (10) NOT NULL AUTO_INCREMENT, 21We s) ENGIend informa ` `S C `VNE = Inorb Dtion to a usetypes that e `File` cDescription` ample imageonfiguration Authoralidated` bit PREFAULT C8.2. Use r, identified bxist, visitor, har (255) NOchar (255) D` char (255) ` `into (10) D` `into (10) N(1) NOT NUIMARY KEYHARSET = cases of th y his email, publisher, de T NULL, EFAULT NUDEFAULT NEFAULT NOT NULL,LL DEFAUL (`id`) latin1 AUTOe system. and update iveloper andLL, ULL, ULL, T b’0’ _INCREMEts kind, accorsuper user. NT = 2; ding to four user 22We cthe Dugive theck the usebeginning, ye to the comphis option anr when sendiou could cholexity of makd require a ng content. Tose to uploading uploads URL of the f hen send th a file to ourvia php and ile, leaving the information server or enlimited servee responsibi contained inter a URL adr capacity, wlity to host co the databadress to conte decided nontent on a se se. In ent. t to rver. 23FWT 9. ISecare aneeHoTusertypirst, we checke will use theprojechis file contamplementatiurity in a wevailable to evd more workwever, this io perform d of this. This e of user def the user res name to cret name is "Hhttp://upc-esins the minimon. b platform ieryone. Perh in order to g s not an obje manageifferent taskallows the syined actions t Super Userponsible foranate a php fileot Potato", hdim.epsevg.uum informaassocis a difficult gaps this sectuarantee rob Enc ProtecImprove resctive of the pment actions LiIdes in our manstem to distihat can be mcontent. RemPublisher: C Developer: : Manages th the project (d descriptio that will accow to access pc.es/inside/ tion easy to ated with thSecurity oal to achievion is one of ust platform rypt commuting forms sqponse in case roject. Instesecurity: that can carmit hosting c ntification s agement platnguish and dade to the member the ty Guest.reate and puCreate and pe system and website). Thn. ess the webs the web bropages/la potfind and necee web. e. Nowadaysthe weaknes. Some of thnications. l injections. of hacker atad, we tried try different tontent. ystem form is necesetermine theanagement spes of usersblish web conublish modu can changeen add the prite created. Fwser will be tato calenta.pssary modul easily collapses of the proe areas for imtack. o reliability iypes of userssary to ident user permisystem websit: tent. les. the user typeoject data, nor example, yping: hp es and contese server andject and proprovement n other aspe. ify yourself sions, becauses, modules . ame if the nt tools bably are: cts of as a e the and 24In addition, each user can perform the actions of previous users. That is, a developer can exert Publisher and one Super User can exercise Developer and Publisher. Navigation System The different sections are accessible from a sidebar on the left. In principle, this bar can browse through the entire platform. The management platform is in principle closed. This does not mean that you can not modify or update, but paragraphs should remain as they are and do not present much variation in the future. If you need to add new functionality can be covered to create a website with the relevant section and add the correct modules. 9.1. Management modules and content. The programming platform for managing content and modules was carried out with technology html and php using forms. Has provided the html form on the web, while the PHP provides communication with the database. Most transactions have been made with the database have been insertions and SQL queries, and some updates. For example, consider the postal charge to register a new user to the database: php $ name = $ _POST ['name']; // Take variables form. $ alias = $ _POST ['alias']; $ email = $ _POST ['email']; $ pass = $ _POST ['password']; pass2 $ = $ _POST ['password2']; $ addr = $ _POST ['addr']; $ title = $ _POST ['title']; $ academic = $ _POST ['academic']; $ birth = $ _POST ['hours']. "-". $ _ POST ['month']. "-". $ _ POST ['year']; $ lang = $ _POST ['language']; require_once ('conexion.php'); // Data connections are in a separate file. $ link = mysql_connect ($ server, $ User, $ password); // Connect to the server. if (! $ link) {die ("Could not connect: '. mysql_error ()); // Control errors. } mysql_select_db ($ database, $ link); // Select the database. $ sql = "SELECT email FROM users WHERE email = '$ email"; // Check that the email is not repeated $ result = mysql_query ($ sql, $ link); if (! $ result) {die ("Error:". mysql_error ()); } if (mysql_num_rows ($ result)! = 0) {header ("Location: email.php not permitted"); die ("Error: email repetition '); } $ sql = "SELECT FROM users WHERE Alias Alias = '$ alias"; // Check that the alias is not repeated. $ result = mysql_query ($ sql, $ link); if (! $ result) { die ("Error:". mysql_error ()); } if (mysql_num_rows ($ result)! = 0) { header ("Location: alias.php not permitted"); 25die ("Error: repetition Alias'); } $ sql = "INSERT INTO users (Name, Alias, email, Password, Address, title, level, Birth, Language) VALUES ('$ name', '$ alias', '$ email', '$ pass', '$ addr', '$ title', '$ academic', '$ birth', '$ lang') "; // The sentence above defines that execute SQL statements. Insert the new user data in the table users. if (! mysql_query ($ sql, $ link)) // This line that performs the query (mysql_query) in the database. { die ("Error:". mysql_error ()); } echo "added one record"; mysql_close ($ link); // Close the connection to the database. header ("Location: redirect.html"); // This file does not display information on screen, redirect to another. ?> This piece of code can distinguish various parts running in order to ensure the proper functioning of the call. These parts are: Collect html form data. manipulate these data, if necessary. Connect to the database. Check that there are no repeated data (names, emails, etc). Building SQL statements. Perform SQL query (query). capture errors. Sometimes we need to update the information contained in the database. Then we will see how to modify a user to change their type and give different permissions: $ link = mysql_connect ($ server, $ User, $ password); if (! $ link) { die ("Could not connect: '. mysql_error ()); } mysql_select_db ($ database, $ link); $ sql = "UPDATE users SET Type = '$ type' WHERE email = '$ email"; // SQL query. if (! mysql_query ($ sql, $ link)) { die ("Error: mysql_close ($ link); In this case, UPDATE used to change one or more fields in one or more rows of a table. This operation changes the type of user, which allows you to make some actions or others. 26Sometimes, to create the form, we need to call for information: php require_once ('conexion.php'); $ link = mysql_connect ($ server, $ User, $ password); mysql_query ("SET NAMES 'utf8'"); // <- ¡Acentos and Enes! mysql_select_db ($ database, $ link); $ sql = 'SELECT id, name FROM modules'; $ result = mysql_query ($ sql, $ link); close = $ mysql_close ($ link); $ Dato 'page'; while ($ registry = mysql_fetch_array ($ result)) { $ id = $ registry ['id']; $ name = $ registry ['name']; echo '
