select page background color

[jagX]

I've been struggling to make an optional field in the admin template to set the page background color on a post basis. I've made another column in the pixelpost table, called color, added a field with a variable named color to the admin template and added this variable into the mysql statement that adds all the other vars to the db on sumbit. Blah...nothing. I can enter anything but nothing is stored in the db. Can somebody please give me the code for this feature? Thanks.

my website : http://glimpse.zeeblo.com/pblog

this is the code for the field:

PHP Code:


    <div id='jcaption'>Background Color (of this format 12345 {!do not put # sign}) </div>
    <div id='content'><input type="text" name="color" style="width:45%;" /><br /><br /></div> 


this is for the insertion in the db

PHP Code:


        $image = $filnamn;
        if($status == "ok") {
        $query = "insert into ".$pixelpost_db_prefix."pixelpost(id,datetime,headline,body,image,category,color)
        VALUES('NULL','$datetime','$headline','$body','$image','','$color')";
        $result = mysql_query($query) || die("Error: ".mysql_error()); 


[parl]

I'm curious as to how to get this working as well.

[GeoS+]

@jagX: make from it downloadable mod and add it to pixelpost page (registering before as developer).

[jagX]

@GeoS: I don't think you got me, I'm not a php/mysql code, and I'm addressing to you guys for help because I can't do it. I'll gladly make the mod and everything, if I know HOW.

[jasonspix]

I managed to get something like this working on my site. Not sure if you are still trying to get it to work, but I put instructions and the modified files on pixelpost's site. http://www.pixelpost.org/v1/index.ph...ds&details=119

Hope it helps.

[parl]

I can't thank you enough for your help Jason. This works great.
cheers

[blinking8s+]

thats the coolest hack EVER!

[skennedy1217]

I almost implemented this. What held me back is that I want the option of white, grey, dark grey and black backgrounds. For the first two colors I need black navigation hyperlinks. For the darker background I need white or light grey navigation links.

I suppose what I am looking for is the ability to set the style sheet for each post and not just the background. I have a style switcher already (running a modified version of Jasonpix's template). The default them is dark grey, and I suppose I could instruct people in the comments/info on which background I think is best, but what would be cool is to have it predetermined for each post and remove the user's ability to change it.

[Joe[y]+]

Originally Posted by skennedy1217

I almost implemented this. What held me back is that I want the option of white, grey, dark grey and black backgrounds. For the first two colors I need black navigation hyperlinks. For the darker background I need white or light grey navigation links.

I suppose what I am looking for is the ability to set the style sheet for each post and not just the background. I have a style switcher already (running a modified version of Jasonpix's template). The default them is dark grey, and I suppose I could instruct people in the comments/info on which background I think is best, but what would be cool is to have it predetermined for each post and remove the user's ability to change it.

this should work on the same principle - but rather defining a stylesheet in the databse rather than just a hex code.

[skennedy1217]

Cool, I'll have to give that a try!