Multimedia Studio Mods

[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright (C) 2002 - 2010 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: articles.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."articles.php";?>[/syntaxhighlighter]

And what is this?

Oh OK... I see; it's under 'Code Highlighter' duhhhhh....!

For what do you need this? Is it for a Download-Project? The News-Script is not the right thing for it?

This is one of the admin scripts in my popular 'Multimedia Studio Panel' infusion. Ever since it was accepted as an official infusion on the old mods site, I have never ceased to try to make it better. It is now totally compatible with Fusion 7.01.02. Essentially it's a combination of the standard photo gallery and my Classified Ads infusion. I just need to be able (using the new db field), to be able to sort the sub-categiries properly.

I have to leave for work now and have no more time but can explain in much greater detail later if you or anyone is interested in helping me.

:D

Nevermind... I figured out how to do what I needed a different way.
;)

Could you please tell us, how you did it. I'm curious and I'm sure that I'm not alone...B)

Sure ! OK, I needed to be able to record the 'main_cat_title' within the 'sub-cat- record for sorting later on. I didn't need the hidden input field at all cause it won't work that way w/o lots of javascript manipulation. So I simply did another query at POST time to extract the 'main_cat_title' from the db based on the posted 'main_cat_id' from the select structure thusly:

[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]
$result1 = dbquery("SELECT mus_cat_title FROM ".DB_MM_MUSIC_CATS." WHERE mus_cat_id='".$_POST['mus_cat_id']."' AND mus_parentid='0'";
$data = dbarray($result1);
$mus_parent_title = $data['mus_cat_title'];

$result = dbquery("INSERT INTO ".DB_MM_MUSIC_CATS." (mus_cat_id, mus_cat_title, mus_cat_desc, mus_cat_user, mus_cat_img, mus_cat_access, mus_parentid, mus_parent_title, mus_cat_datestamp, mus_cat_status) VALUES ('', '$mus_cat_title', '$mus_cat_desc', '".$userdata['user_id']."', '$mus_cat_img', '$mus_cat_access', '$mus_cat_id', '$mus_parent_title', '".time()."', '$mus_cat_status'";
[/syntaxhighlighter]

Works great!! Then my ORDER BY sort function became:

[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]
$result = dbquery("SELECT mus_cat_id, mus_cat_title, mus_cat_desc, mus_cat_img, mus_parentid, mus_parent_title, mus_cat_status FROM ".DB_MM_MUSIC_CATS."
WHERE mus_cat_status='1' AND mus_parentid>'0' ORDER BY mus_parent_title, mus_cat_title ASC LIMIT $subcatz";
[/syntaxhighlighter]

If you'd like to see the whole thing in action just visit my mod-support site(need to register)

www.whisperwillow.com/

Thanks. I registered...

Hey guy; you registered and I approved your account. But you have never logged in to check it out!

B)

It always says: "Invalid Username..."

Hmmmmmmm....... thats weird! Anyway I just changed your login password so I could try it myself and I logged in as you with no problem at all. I'll PM you the password so you can login and change it back.

Ok, now it works. Thanks