Text in Database

The Archives Help Topics
1

Hi,

can somebody tell me how I can find a text string in the xibo database? I have searched over all tables without any result. Version is 1.7

thank you
greettings myerscola

2

Hey, you mean the text you place in the layout? that is in the xml from the layout table.

3

Yes, thank you. That is what i am searching for.

4

Is there a documentation of this xml file?

5

What do you want to know? You know how xml works? its verry simple if you format it to a nice view and look at it.

6

Yes, I know how xml works but I want to know the nodes and parameters names and functions to build an own small editor for it. It is pretty easier to read a docu than to determine it by myself :slight_smile:

7

You have a region for example:

 <region id="2176755f2894ad866a" userId="1" width="150" height="150" top="860" left="115">

Inside the regions the regio options for the regio and media tags, inside the media tags are the options for the media.
The best way is just to look at everything and try to understand it, I am sorry but I dont have a file to explain it all. Maybe somewone else. But if u build in xibo and look at the xml u can come verry far already.

8

Hmm maybe something usefull I insert text like this:

$text_html = '<p style="color: rgb(255, 255, 255); font-size: 48px; text-align: center;"><span style="color:#000000;"><span style="font-size:96px;">' . $text . '</span></span></h1>';
            $xml = str_replace("TEXT_1", $text_html, $xml);

And then my xml looks like this:

<media id="f356f955119f23c01ba5d27ea7419584" type="text" render="native" duration="60" lkid="" userId="1" schemaVersion="1">
     <options>
        <xmds>1</xmds>
        <effect>none</effect>
        <speed>0</speed>
        <backgroundColor />
        <name />
     </options>
     <raw>
        <text><![CDATA[TEXT_1]]></text>
     </raw>
  </media>

then insert it into the db

9

Please don’t edit the database directly. We can’t offer you any support at the moment you do that. Xibo has an API. If you want to programatically edit layouts, please use the API to do so.

10