vb.org Archive - [APM] Advanced Product Management 2.0.4

Page 1 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - [APM] Advanced Product Management 2.0.4 (https://vborg.vbsupport.ru/showthread.php?t=95741)

mtha	09-05-2005 10:00 PM

[APM] Advanced Product Management 2.0.4

/*================================================* \
|| ########################################## ||
|| # Advanced Product Management [APM] v2.0.3 ? by HacNho
|| # Copyright (C) 2005 by HacNho, All rights reserved.
|| # ----------------------------------------------------------
|| # For use with vBulletin Version 3.5.1 and later
|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html
|| # Discussion and support available at
|| # https://vborg.vbsupport.ru/showthread.php?t=95741
|| ########################################## ||
\*================================================ =*/

Hack Version: 2.0.3.051105
Compatible vB version: 3.5.1 (and later)
Support: https://vborg.vbsupport.ru/showthread.php?t=95741
Translated Versions:
http://www.vbhacks-germany.com/forum...ead.php?t=1971

NOTE: This release is to fix few function name changes in vB 3.5.1
if you have vB 3.5.0, please DONOT upgrade to this version
For vB version later than 3.5.1, you can use the version for 3.5.1 (was named for 3.5.1 only) without problem.

Beta release for vB 3.6.0 RC2 is AVAILABLE here:
https://vborg.vbsupport.ru/showthread.php?t=121792

DESCRIPTION:

A center product area which allow you to manage all codes/plugins/templates/phrases/settings for any product.
It also add some additional fields to the product, just to save more information with a product
Release Date
Product Author
Related URL
Extra Information

The extra information is only available if you install APM, and use APM to export/import other product.
It does not have any conflict with original product. You still can use APM to import standard product, or use standard product tool to import APM's product files.

CHANGES/MODIFICATION:

- Query: 1 (ADD 5 additional fields to product table)
- Files to add: 5
- Product to import: 1

INSTALL:
(2005.10.06: for safer installation, please do step 2 (import the product) first, then upload the files.)

2. Import XML product product-adv_product_management.xml using vBulletin standard product import tool.
1. Upload all files in UPLOAD folder to your server
3. Refresh menu panel to display Advanced Product Management link in Plugin System section

{optional} - Re-import product-adv_product_management.xml using APM import product tool, with Allow Overwrite = Yes
This step is inserting more information into the product.
* CAUTION: DONOT use APM to import product-adv_product_management.xml BEFORE step 2.

SCREENSHOT:
Included

HISTORY:
v1.0: Initial release
v1.1: Improve count queries, thanks to KirbyDE, some bugs fix
v1.2: Add collapsible blocks into product detail
2005.10.02: version 2.0: Alot of improvement. More product information fields. Better product's component adding/editting
2005.10.03: version 2.0.1: FIX bug on updateactive plugins in one product that de-active all other plugins. upgrade is recommended for the function to work right
2005.10.06: v2.0.2 Fix post #41 bug when debug mod is on

2005.11.05: v2.0.3 Fix bug on post #48 for vBulletin 3.5.1
{NOTE: This release is to fix few function name changes in vB 3.5.1
if you have vB 3.5.0, please DONOT upgrade to this version}

2006.03.20: v. 2.0.4 fix bug on post #64

2006.07.21: v. 3.0.0
Beta release for vB 3.6.0 RC2 is AVAILABLE here:
https://vborg.vbsupport.ru/showthread.php?t=121792

mtha	09-06-2005 10:17 AM

reserved for updates

uae	09-06-2005 10:29 AM

You guys are on fire, and the sky is raining mo and mo cool hacks.

Keep'em coming :)

Thanks for sharing mtha

Snake

09-06-2005 10:42 AM

Thanks for the hack.

Andreas

09-06-2005 12:55 PM

Dunno if it is just me, but

PHP Code:


		
			
    $products = $db->query_read("

        SELECT pr.* 

            ,count(DISTINCT pl.pluginid) AS plugin

            ,count(DISTINCT ph.phraseid) AS phrase

            ,count(DISTINCT templateid) AS template

#            ,count(DISTINCT se.varname) AS setting

        FROM " . TABLE_PREFIX . "product AS pr

        LEFT JOIN " . TABLE_PREFIX . "plugin AS pl ON (pl.product = pr.productid)

        LEFT JOIN " . TABLE_PREFIX . "phrase AS ph ON (ph.product = pr.productid)

        LEFT JOIN " . TABLE_PREFIX . "template AS te ON (te.product = pr.productid)

#        LEFT JOIN " . TABLE_PREFIX . "setting AS se ON (se.product = pr.productid)

        GROUP BY productid

        ORDER BY title");

while ($product = $db->fetch_array($products))

keeps killing my Server. This Query takes over 1 Minute to execute and while it does run, the machine is almost unusable - CPU 100%.

Therefore I replaced that Code with

PHP Code:


		
			
    $productq = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "product ORDER BY title");

    while ($product = $db->fetch_array($productq))

    {

        $products["$product[productid]"] = $product;

        $products["$product[productid]"]['plugin'] = 0;

        $products["$product[productid]"]['phrase'] = 0;

        $products["$product[productid]"]['template'] = 0;

        $products["$product[productid]"]['setting'] = 0;

    }



    $pluginq = $db->query_read("SELECT product, COUNT(pluginid) AS plugin FROM " . TABLE_PREFIX . "plugin WHERE product != 'vbulletin' GROUP BY product");

    while ($plugin = $db->fetch_array($pluginq))

    {

        $products["$plugin[product]"]['plugin'] = $plugin['plugin'];

    }



    $phraseq = $db->query_read("SELECT product, COUNT(phraseid) AS phrase FROM " . TABLE_PREFIX . "phrase WHERE languageid=-1 AND product != '' AND product != 'vbulletin' GROUP BY product");

    while ($phrase = $db->fetch_array($phraseq))

    {

        $products["$phrase[product]"]['phrase'] = $phrase['phrase'];

    }



    $templateq = $db->query_read("SELECT product, COUNT(templateid) AS template FROM " . TABLE_PREFIX . "template WHERE styleid=-1 AND product != '' AND product != 'vbulletin'GROUP BY product");

    while ($template = $db->fetch_array($templateq))

    {

        $products["$template[product]"]['template'] = $template['template'];

    }

    

    $settingq = $db->query_read("SELECT product, COUNT(varname) AS setting FROM " . TABLE_PREFIX . "setting WHERE product != '' AND product != 'vbulletin' GROUP BY product");

    while ($setting = $db->fetch_array($settingq))

    {

        $products["$setting[product]"]['setting'] = $setting['setting'];

    }        



    foreach ($products AS $product)

This shows the Results instantly.

Andreas

09-06-2005 01:39 PM

Just a thought:
If you could make it so the Blocks (Product Details, Install/Uninstall Codes, etc.) are collapsable and when editing/adding an Item one gets taken back to the advanced Product Edit Page - that would be perfect :D

Boofo

09-06-2005 01:54 PM

I used your code above Kirby and I got a line that is blank at the bottom of the listing that says it has 11 plugins and an x under the settings column.

mtha	09-06-2005 03:53 PM

Quote:

Originally Posted by KirbyDE

Dunno if it is just me, but
keeps killing my Server. This Query takes over 1 Minute to execute and while it does run, the machine is almost unusable - CPU 100%.

well, i was trying to save few queries but it doesnt seem to do much good hah. it took about 1 second for that code to run on my server. Anyway I will switch to using your code then. Thanks for the code :)

Quote:

hehe, yeah. i just thought about the collapsing blocks this morning. it was a quick extension in few hours, so I havent got anything fancy in there yet.

A perfect product should be completed, yes. At the moment, it's only a quick link to other sections. I will gather some more code in there :)

Quote:

I used your code above Kirby and I got a line that is blank at the bottom of the listing that says it has 11 plugins and an x under the settings column.

I didnt try the code, but x means you dont have any setting for the coresponding product. I will come back with a new code tonight though

Revan

09-06-2005 05:03 PM

Can you please try to make it look like Live Wire in the thread you got the idea from? If you will, then notice my idea of making disabled plugins red.
If you do then this will rox0r t3h b0x0rz and youll have my install.

Btw why is the 2nd ss showing the hack printing a "Edit vBulletin Options"-ish page underneath the notice of there being no Settings?

evesve

09-06-2005 05:22 PM

Hi!
I have upload both files to the right place.
Refresh the side, but I don´t have the Advanced Manage Product in the Plugin System.
(RC1)

What´s wrong?

Boofo

09-06-2005 07:44 PM

Quote:

Originally Posted by mtha

I didnt try the code, but x means you dont have any setting for the coresponding product. I will come back with a new code tonight though

What I'm saying is there is a blank line with no product name at all. It just has 11 and x in it.

mtha	09-06-2005 09:05 PM

Quote:

Originally Posted by Boofo

What I'm saying is there is a blank line with no product name at all. It just has 11 and x in it.

Quote:

Hi!
I have upload both files to the right place.
Refresh the side, but I don?t have the Advanced Manage Product in the Plugin System.
(RC1)

What?s wrong?

If you uploaded the xml file to /includes/xml folder, you should see the link in Plugin menu, after refreshing browser.
If you still dont see it, I think there's a "How-To" thread showing you how to work around on AdminCP menu.

Quote:

What I'm saying is there is a blank line with no product name at all. It just has 11 and x in it.

Boofo, hehe, I got the same problem, with 4 plugins. I look at the database and find out that I have some plugins that have "product name" but doesnt actually have a product for it. that's why.

Maybe, adding someing like "Un-assigned product" on that line would help :D, or building a product list and just count in the list

Boofo

09-06-2005 09:20 PM

Quote:

Originally Posted by mtha

But that never showed up in the regular product listing. This is the first time I have seen it.

Is there a way to do the product listing alphabetically like it was originally?

mtha	09-06-2005 10:27 PM

Quote:

Originally Posted by Boofo

But that never showed up in the regular product listing. This is the first time I have seen it.

well, because it doesnt have a real product. it's like when you add a plugin, or phrase, or something to database, and just give it some product name. This name doesnt actually exist in product table, => not listed in product listing.

Quote:

Is there a way to do the product listing alphabetically like it was originally?

Query fixed and sorted. Updated on the attachment

I modify alitle bit on KirbyDE code, adding the product list to counting queries.

PHP Code:


		
			
    $productq = $db->query_read("
        SELECT * 
        FROM " . TABLE_PREFIX . "product
        ORDER BY title");

   while ($product = $db->fetch_array($productq))
    {
        $products["$product[productid]"] = $product;
        $products["$product[productid]"]['plugin'] = 0;
        $products["$product[productid]"]['phrase'] = 0;
        $products["$product[productid]"]['template'] = 0;
        $products["$product[productid]"]['setting'] = 0;
    }
    ksort($products);
    $productlist = "'". implode('\',\'',array_keys($products)) ."'";

 $pluginq = $db->query_read("SELECT product, COUNT(pluginid) AS plugin FROM " . TABLE_PREFIX . "plugin WHERE product IN ($productlist) GROUP BY product");
    while ($plugin = $db->fetch_array($pluginq))
    {
        $products["$plugin[product]"]['plugin'] = $plugin['plugin'];
    }

 $phraseq = $db->query_read("SELECT product, COUNT(phraseid) AS phrase FROM " . TABLE_PREFIX . "phrase WHERE languageid=-1 AND product IN ($productlist) GROUP BY product");
    while ($phrase = $db->fetch_array($phraseq))
    {
        $products["$phrase[product]"]['phrase'] = $phrase['phrase'];
    }

 $templateq = $db->query_read("SELECT product, COUNT(templateid) AS template FROM " . TABLE_PREFIX . "template WHERE styleid=-1 AND product IN ($productlist) GROUP BY product");
    while ($template = $db->fetch_array($templateq))
    {
        $products["$template[product]"]['template'] = $template['template'];
    }
    
$settingq = $db->query_read("SELECT product, COUNT(varname) AS setting FROM " . TABLE_PREFIX . "setting WHERE product IN ($productlist) GROUP BY product");
    while ($setting = $db->fetch_array($settingq))
    {
        $products["$setting[product]"]['setting'] = $setting['setting'];
    }

Boofo

09-06-2005 10:44 PM

Quote:

Originally Posted by mtha

Then it shouldn't show up in this listing either, right? ;)

Boofo

09-06-2005 10:51 PM

Ok, with the update, my problem has been fixed. The blank line is no longer there. But there is a new problem. The beginning of the line has the actual product file name and not the title. Shouldn't it have the title there instead like it did in the old one?

mtha	09-07-2005 03:35 AM

download the file again, and you get what you want :)

Boofo

09-07-2005 03:45 AM

Quote:

Originally Posted by mtha

download the file again, and you get what you want :)

Thank you, sir, but they are still not in alphabetical order. Close though. ;)

mtha	09-07-2005 06:18 AM

Quote:

Originally Posted by Boofo

Thank you, sir, but they are still not in alphabetical order. Close though. ;)

Agrrr, you are fooling me around :>

It was sorted by title, but I shows the productid for testing, then I force it to resort by productid, and display title :))

now you have the product list sorted by title

and you have the product's details collapsible

have fun. I will do the "come back after editting" later :)

Boofo

09-07-2005 06:32 AM

No, sir, I'm not fooling with you. See the attached. ;)

mtha	09-07-2005 06:54 AM

:> I was joking.

Download the file again, you should get what you want

Boofo

09-07-2005 06:57 AM

Excellent! Thank you, sir! ;)

Boofo

09-07-2005 07:00 AM

Ok, found one thing. The date is off for the last modified on the templates.

Jan 1st, 1970 12:00 am / Boofo

Just thought you should know. ;)

Marco van Herwaarden

09-07-2005 07:04 AM

We knew you where old Bob, but THAT old? You where already working on templates in 1970!

mtha	09-07-2005 07:09 AM

oopssss he might had ... :)

get the new file Bob

Boofo

09-07-2005 07:23 AM

Quote:

Originally Posted by MarcoH64

We knew you where old Bob, but THAT old? You where already working on templates in 1970!

And even before then. ;)

Boofo

09-07-2005 07:26 AM

Quote:

Originally Posted by mtha

oopssss he might had ... :)

get the new file Bob

Whew! All is well once again. ;)

Revan

09-07-2005 03:13 PM

Quote:

Originally Posted by Revan

Bump.

mtha	09-07-2005 07:08 PM

Quote:

Originally Posted by Revan

well, i wasnt really get the idea from that thread, i get the idea from what I need/want to do.

talking about Live Wire, you mean this?

but it's Product/Plugin System, how it fit in my system, with all other information (phrases, templates, settings)?
For product/plugin, you can take a look at Kirby's
https://vborg.vbsupport.ru/showthread.php?t=95738

Quote:

Originally Posted by Revan

* The color red for Disabled hooks

Well, it's read/strike now

Quote:

Btw why is the 2nd ss showing the hack printing a "Edit vBulletin Options"-ish page underneath the notice of there being no Settings?

I'd want to leave it there so if anyone want to add a setting group, or edit some current setting, he can do it in there. Might not a very good idea, huh :)

Revan

09-08-2005 09:22 AM

Quote:

Originally Posted by mtha

For product/plugin, you can take a look at Kirby's
https://vborg.vbsupport.ru/showthread.php?t=95738

That wasn't there when I posted, I swear :p

Quote:

Originally Posted by mtha

I'd want to leave it there so if anyone want to add a setting group, or edit some current setting, he can do it in there. Might not a very good idea, huh :)

It just looks messy, IMO. Im not telling you to get rid of it or die :p
Anyways, Im gonna take the suggestion out to Kirby now then. :)

Gizmo5h1t3

09-08-2005 04:03 PM

Quote:

Originally Posted by evesve

Hi!
I have upload both files to the right place.
Refresh the side, but I don?t have the Advanced Manage Product in the Plugin System.
(RC1)

What?s wrong?

im also having the same problem.
refreshed page, logged out and back in, all to no avail.
re downloaded files and upped to the ftp, but no luck..
weird.......

ckmarkhsu

09-08-2005 04:42 PM

me....2

evesve

09-08-2005 04:47 PM

I?ve still no Advanced Product Manager.
Even my old Product Manager is lost.

I installed Advanced Plugin Manager before advanced Product Manager.

Conflict?

=====================

Later:
I changed from

Code:

<navoption debug="1" displayorder="11">

to:

Code:

<navoption displayorder="11">

Then I can see Advanced Product Manager in the menu.

It works now!!!

mtha	09-08-2005 07:27 PM

Quote:

Originally Posted by evesve

Later:
I changed from

Code:

<navoption debug="1" displayorder="11">

to:

Code:

<navoption displayorder="11">

Then I can see Advanced Product Manager in the menu.

It works now!!!

oops, i forgot the debug mode :) thanks. Removed the debug=1 from xml.

evesve

09-08-2005 07:40 PM

Quote:

Originally Posted by mtha

oops, i forgot the debug mode :) thanks. Removed the debug=1 from xml.

:up: :up: :up:

Logician

09-26-2005 01:33 PM

Very useful hack! Should be a default feature.. ^^

mtha	10-02-2005 07:20 AM

APM Version 2 is released

You now can add/edit all components (codes/plugins/phrases/templase/settings) in one place.

Some additional fields for more hack information is added

Very easy and convenient to create new products or manage

Check it out and let me know how you like it :)

Snake

10-02-2005 11:18 AM

Like it? I'm lovin' it!

mtha	10-03-2005 12:35 PM

Advanced Product Management 2.0.1 is released

2005.10.03: version 2.0.1: FIX bug on updateactive plugins in one product that de-active all other plugins.

Upgrade is recommended for the function to work right.

If you did use the APM tool to updateactive plugins for any product, you should check your plugin list, and make sure that all other plugin are working fine. If all others are inactive, you may want to activate them again.
http://your.forum.url/admincp/plugin.php?do=modify

Sorry for any inconvenient!

Snake

10-03-2005 01:26 PM

Thanks for the update.

All times are GMT. The time now is 01:27 AM.

Page 1 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01521 seconds Memory Usage 1,913KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (3)bbcode_php_printable (24)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: