x3kep

Tontamoo,
that line reading $post_music = $postdate[‘post_music’]; has a typeo in it. It should be
$post_music = $postdata[‘post_music’];
That may be the problem. And I have looked at my source, I also have the same typeo, I must have had it wrong in the directions.

Tontamoo,
Make sure you have the
$post_music = $HTTP_POST_VARS[‘post_music’];
lines added to your post.php file. That’s what reads the variables back for the post when you edit it. Needs to be added after each instance of $trackback = preg_replace(‘|\s+|’, ‘\n’, $trackback); as we where posting about above.

In the version I created the hack in there are THREE instances,
1st) in the case ‘post’
2nd) in the case ‘edit’
3rd) in the case ‘editpost’ further down the file.
my version must be different than everyone elses for some reason. If you only find two just leave it with that. If you miss one you may see problems in certain instances not saving your choices (like when you post a new message, edit an existing message, or something like that). Otherwise if you only have two I wouldn’t see any other reason that it still wouldn’t work.
As for splitting them, you can by just simply dropping the html and the added fields in the queries for whichever you don’t want. If you want only the music part you don’t need anything in the wp-mood directory so you can just delete all of that.
As for the table name, just replace what I had in that query as wp_post with whatever your table is called and it should work fine.

what you have posted is not a full query. if you are trying to add the tables from a sql query you neeed to use this:
ALTER TABLE wp_post ADD post_music tinytext NOT NULL
and
ALTER TABLE wp_post ADD post_mood smallint( 6 ) NOT NULL default ‘0’
These should work to add the two additional fields. change wp_post if you have changed your table name that holds post info.
x3kep

It’s included with the mood hack. as an All in One.