Hallo, Gast! (Registrieren)

Letzte Ankündigung: MyBB 1.8.40 veröffentlicht (28.05.26)


Benutzer, die gerade dieses Thema anschauen: 1 Gast/Gäste
XML Database League
#1
Eine neue Erweiterung wurde veröffentlicht: XML Database League

Zitat:XML Database League
Database with Extensible Markup Language (XML) And Extensible Stylesheet Language (XSL).

I will Like to Created a Database with Extensible Markup Language (XML) And Extensible Stylesheet Language (XSL).
The purpose is to develop a SimpleCode Database League to can display in a simple form to generate a League, Football Clubs / Leagues and Tournaments Information Like: Teams, Logos, Players

Database XML Schema Diagram:
  • League
    • Teams

    • Logo

    • Legends Players

    • City

    • Stadium

  • Standings



Note:
Based on my studies learning XML & XSL
github.com/Diego-Pino/XML-Database-League


XML & XSLT Example OnLine XML Database League Test

Download:
http://community.mybb.com/mods.php?action=view&pid=549

Version 1.2
  • Performance and update info plugin

  • Add Style font-family: Verdana

  • Logos teams Update in Folder images/xmleague

  • Add Code JavaScript

  • Add Template: Home » Template Sets » Global Templates » Add Template » xmleague_template

  • Video Tutorial: Add Template » xmleague_template

Version 1.1:
  • Add Image to Teams of Premier League Database in file .Xml

  • Created Stylesheet to Display Images in file .Xsl

  • Created Folder images

  • Premier League Base Update with Info

Version 1.0:
  • Code Base development in XML & XSLT

  • Premier League Base

  • Schema Xml

  • Plugin Codebase development in MyBB

  • Templante MyBB

MyBB Add Templante Code XML Database League.

Code:
<html> <head> <title>XML Database League</title> {$headerinclude} <style type="text/css"> table, th, td {  border: 1px solid black;  border-collapse:collapse;  background-color: #E1EEF4; } th, td {  padding: 5px;  font-family: Verdana ;  font-size: 18px;  line-height: 15.4px; } p    {color:green} ; </style> <script type="text/javascript">            if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari                xmlhttp = new XMLHttpRequest();            }            else {// code for IE6, IE5                xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");            }            xmlhttp.open("GET", "xmleague.xml", false);            xmlhttp.send();            xmlDoc = xmlhttp.responseXML;            var x = xmlDoc.getElementsByTagName("Team");            function displayXMLeague(i) {                var leagueElement = x[i];                Team_Name = (leagueElement.getElementsByTagName("Team_Name")[0].childNodes[0].nodeValue);                description = (leagueElement.getElementsByTagName("description")[0].childNodes[0].nodeValue);                City = (leagueElement.getElementsByTagName("City")[0].childNodes[0].nodeValue);                Stadium = (leagueElement.getElementsByTagName("Stadium")[0].childNodes[0].nodeValue);                var players = leagueElement.getElementsByTagName("first_name");                var player;                var playerString;                for(var index = 0; index < players.length; index++)                {                    player = players[index];                    if (index == 0)                    {                        playerString = player.childNodes[0].nodeValue;                    }                    else                    {                        playerString = (playerString + "<br />" + player.childNodes[0].nodeValue);                    }                }                Players = playerString;   image = (leagueElement.getElementsByTagName("image")[0].childNodes[1].childNodes[0].nodeValue) ;                txt = "<br><b>Logo:</b>" + "<img src='"+image+"'/>" + "<br><b>Team_Name:</b> " + Team_Name + "<br><b>Description:</b> "+ description + "<br><b>City:</b> " + City + "<br><b>Stadium:</b> " + Stadium + "<br><mark><b>Legends Players:</b></mark><ul>" + Players ;                document.getElementById("showXMLeague").innerHTML = txt;            }            displayXMLeague(0);        </script> </head> <body> {$header} <h2>List of Premier League clubs </h2> <p>Update with More <ins>Teams Clubs And Leagues</ins>... for the next version</p>    <div id='showXMLeague' style="font-family:verdana; font-size: 18px;">Click on a Team Club to display information.</div><br> <script> document.write("<table border='2'>"); for (var i=0;i<x.length;i++)  {   document.write("<tr onclick='displayXMLeague(" + i + ")'>");  document.write("<td>");  document.write(x[i].getElementsByTagName("Team_Name")[0].childNodes[0].nodeValue);  document.write("</td><td>");  document.write(x[i].getElementsByTagName("City")[0].childNodes[0].nodeValue);  document.write("</td></tr>");  } document.write("</table>"); </script>     {$footer} </body> </html>
[Video: https://youtu.be/QsQ2GXnFLM0]

How install XML Database League:
- Actived The Plugin in ACP

Plugin Test OnLine:
http://mybb.pinostudio1.com/xml-database-league.php

Download:
http://community.mybb.com/mods.php?action=view&pid=549

Support MyBB Plugin:
http://community.mybb.com/thread-172852.html


Collaborator and suggestions Are Welcome…
Zitieren
#2
Eine neue Version wurde veröffentlicht: XML Database League 1.2
Zitieren


Möglicherweise verwandte Themen…
Thema Verfasser Antworten Ansichten Letzter Beitrag
  Database Helper MyBB.de Bot 0 1.352 09.02.2018, 07:40
Letzter Beitrag: MyBB.de Bot
  Professional database management (update 1.1) MyBB.de Bot 0 1.756 22.06.2011, 18:17
Letzter Beitrag: MyBB.de Bot