Star Trek Themed UI1

[tschak909]

either way, it doesn't matter.

It is important that you look at the tables I am referring to, so you can see the information inside them.

-Thom

[fearingsept]

I think before I go messing around with anything there should a quick definition of terms. That way I don't get mixed up.
First... MySQL Console, would this be a computer in which MySQL Database is stored or is this any computer on the same network as the MySQL database?

I know this might seem very basic and redundant, but I just want to make sure I don't mess anything up.

What are Style and StyleVariation tables? I assume it is a set of data laid out in a table that gives reference to how the GUI should act or look.
 
How do I locate them using my MySQL console?

Keep in mind that I know very little to nothing about database manipulation so I think the best approach is to assume I know nothing and try to be very basic.

Thank you very much for helping me with this. I know this is most likely not convenient for you and I will do my best to grasp everything the best I can so I can be more help to others in the future.

[tschak909]

oh dude, you don't understand. You're willing to hack, therefore, I will bend over backwards to help.

-Thom

Let me get settled into my morning, and I will reply.

[tschak909]

now that you've made the necessary changes for Designer to work. Go to MySQL's site and install the MySQL Query Browser.

-Thom

[fearingsept]

I am at the site but I am having a hard time finding the MySQL query browser.

[tschak909]

http://dev.mysql.com/downloads/gui-tools/5.0.html

-Thom

[fearingsept]

good deal, thank you...
I am downloading now.. Keep in mind though that I am not at home ... once again.. I my kids started back to school yesterday so I didn't have a lot of time to get on when I got home. I am hoping this evening will be better.
I take it I will have to install this browser on one of my systems on my LMCE network. Correct?

[tschak909]

correct. It might be best to install this on the same machine as Designer.

-Thom

[fearingsept]

Thats what I was planning.

[fearingsept]

Ok... MySQL query browser installed.. Check.
Next.

[tschak909]

did you grant access to your designer machine from the core? (if you followed the Designer install instructions, you should have seen a GRANT command.)

-Thom

[fearingsept]

Yes I have....

[tschak909]

Okay.

Open MySQL Query Browser, and put in the username and password you specified in the GRANT command.

Be sure the host name is 192.168.80.1 (the address of your core)

and that the database you are connecting to, is pluto_main.

Provided that you log in, you'll see a list of all the database tables within the database. You are now directly talking to the database... you can then double click on a table, and press the execute button (it will have placed a SELECT query in the SQL box above) to look at its contents.

The tables we are interested in, are Style and StyleVariation, look at Style first.

-Thom

[fearingsept]

OK... looking at style right now.

[tschak909]

Okay, now.

at the same time, open Designer, open DesignObj 1255 (the main screen)...

Select the Normal Horizontal variation.

select the children tab, and select and open the arrLights child designobj.

Inside that designobj, you'll see another child, which is the actual button to be used. Select and open it.

Now with this button open, and still at the child tab, select the text Array Desc (it shows as <%=6:0%> in the canvas.

You'll see the text properties change. Do you see the alignment, and below it the text style?

Look at the Style table in MySQL Query Browser, and you'll see a matching entry for it.

-Thom