MySQL menu using screenposition offset

Poster: slackbladder
Dated: Sunday August 21 2005 - 21:43:26 BST

Hi,

I have a problem with the MySQL solution.

http://support.milonic.com/datamenu/

Everything is fine but I can not use:

screenposition = "center"; left="offset=-200";

I get:

screenposition = ""center"; left="offset=-200"";

or

screenposition = "center; left=offset=-200";

neither work.

I guess "mm_phpmenu.php" needs amending?

Any ideas?

Thx

Poster: Andy
Dated: Monday August 22 2005 - 18:28:50 BST

Hi,

It works for me, I've added a field called "screenposition" to the mm_menus and declared center for the main menu.

Note that you must not include quotes inside the field.

Hope this helps,
Andy

Poster: Andy
Dated: Monday August 22 2005 - 18:29:33 BST

Oh and another thing, make sure it's a varchar, probalby about 40 chars long will do.

-- Andy

Poster: slackbladder
Dated: Monday August 22 2005 - 19:03:41 BST

Hi Andy,

Yep already added screenposition to main and adjusted field value but it's the additional 'offset' variable that doesn't work for me.

screenposition = center (works fine)

screenposition = center;offset=left=-200 (doesn't)

Thx

Poster: slackbladder
Dated: Wednesday August 24 2005 - 10:50:21 BST

Sorry to bump this.

Andy if you can point me in the right direction in editting mm_phpmenu.php I will have a go myself. I'm guessing some sort of check to see if screenposition is used then placing the quotes differently?

screenposition = "center"; left="offset=-200";

instead of:

screenposition = ""center"; left="offset=-200"";

Thx

Poster: Andy
Dated: Thursday August 25 2005 - 10:52:34 BST

Hi,

The syntax: screenposition = "center"; left="offset=-200"; is incorrect.

Offsets need to be placed inside the left parameter.

So, leave screenposition as center and add a left value of offset=-200.

Note that you may need to change the left database field from an Integer to a varchar to accomodate the text.

The output should be like this:

screenposition="center";
left="offset=-200";

Hope this helps,
Andy

Poster: slackbladder
Dated: Thursday August 25 2005 - 11:17:59 BST

Nice one fella!

Works a treat! I thought the left statement had to be part of the screenposition statement - I just created another field in mm_menus (MySQL) left - set the offset and YAY! spot on.

Thx for the help - this one is SOLVED!