Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons

Reply
 
Thread Tools
[APM] Advanced Product Management 2.0.4 Details »»
[APM] Advanced Product Management 2.0.4
Version: 2.0.4, by mtha mtha is offline
Developer Last Online: May 2016 Show Printable Version Email this Page

Version: 3.5.1 Rating:
Released: 09-05-2005 Last Update: 03-19-2006 Installs: 62
DB Changes Uses Plugins
Additional Files  
No support by the author.

[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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 09-06-2005, 10:17 AM
mtha's Avatar
mtha mtha is offline
 
Join Date: Jul 2002
Location: US
Posts: 775
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

reserved for updates
Reply With Quote
  #3  
Old 09-06-2005, 10:29 AM
uae's Avatar
uae uae is offline
 
Join Date: Jul 2002
Location: Irvine, California
Posts: 312
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Keep'em coming

Thanks for sharing mtha
Reply With Quote
  #4  
Old 09-06-2005, 10:42 AM
Snake's Avatar
Snake Snake is offline
 
Join Date: Mar 2005
Location: Cleveland, OH
Posts: 3,832
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for the hack.
Reply With Quote
  #5  
Old 09-06-2005, 12:55 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #6  
Old 09-06-2005, 01:39 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #7  
Old 09-06-2005, 01:54 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #8  
Old 09-06-2005, 03:53 PM
mtha's Avatar
mtha mtha is offline
 
Join Date: Jul 2002
Location: US
Posts: 775
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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:
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 [img]images/newsm/grin.gif[/img]
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
Reply With Quote
  #9  
Old 09-06-2005, 05:03 PM
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Location: Norway
Posts: 1,671
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #10  
Old 09-06-2005, 05:22 PM
evesve evesve is offline
 
Join Date: Jul 2005
Location: Sweden
Posts: 143
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:33 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07837 seconds
  • Memory Usage 2,327KB
  • Queries Executed 23 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete