11
fredski
Re: Subsite Hack, help with tables to share??
  • 2004/5/25 14:19

  • fredski

  • Quite a regular

  • Posts: 265

  • Since: 2004/1/26


Quote:

Dave_L wrote:
I don't understand your initial post.

Ok, right I'll recap.

I have a number of Domains on one server using Virtual Hosting, They all currently share one XOOPS database. I want to install the SubSite hack so that I can retain control over the seperate sites. That way I can set different themes, titles, meta tags etc for each of them, but they will all share one database for the users, forums, news etc. I need to know which tables I MUST NOT share with the main database to keep those aspects of the site unique.

12
fredski
Re: Subsite Hack, help with tables to share??
  • 2004/5/26 10:46

  • fredski

  • Quite a regular

  • Posts: 265

  • Since: 2004/1/26


This is getting hair pullingly frustrating now?

Anyone here know what tables do what??? Below is a the list that Subsite Hack gives me of tables that I can share from the Main sites Database, which ones of these do I DEFINATLY NOT select to share with the main database and therefore use its own tables in its own database, so I retain control over general settings like site name, contact details, theme & template, everything else I want to share between the sites, such as users, forums, news etc.
I have tried posting on BoDGie who wrote the hacks forums at http://www.virtuepark.com and also tried a PM & email to him with no reply. All my sites have the same modules instaled so no problems with his advice with sharing group permissions.

wolves_ann_annonces
wolves_ann_categories
wolves_ann_prix
wolves_ann_type
wolves_avatar
wolves_avatar_user_link
wolves_banner
wolves_bannerclient
wolves_bannerfinish
wolves_bb_categories
wolves_bb_forum_access
wolves_bb_forum_mods
wolves_bb_forums
wolves_bb_posts
wolves_bb_posts_text
wolves_bb_topics
wolves_block_module_link
wolves_common_tables
wolves_config
wolves_configcategory
wolves_configoption
wolves_group_permission
wolves_groups
wolves_groups_users_link
wolves_image
wolves_imagebody
wolves_imagecategory
wolves_imgset
wolves_imgset_tplset_link
wolves_imgsetimg
wolves_modules
wolves_myxoopschat_banned
wolves_myxoopschat_messages
wolves_myxoopschat_pmsgs
wolves_myxoopschat_requests
wolves_myxoopschat_rooms
wolves_myxoopschat_visibility
wolves_myxoopschat_whosonline
wolves_newblocks
wolves_online
wolves_priv_msgs
wolves_ranks
wolves_session
wolves_shop_address_book
wolves_shop_address_format
wolves_shop_affiliate_affiliate
wolves_shop_affiliate_banners
wolves_shop_affiliate_banners_history
wolves_shop_affiliate_clickthroughs
wolves_shop_affiliate_news
wolves_shop_affiliate_newsletters
wolves_shop_affiliate_payment
wolves_shop_affiliate_payment_status
wolves_shop_affiliate_payment_status_history
wolves_shop_affiliate_sales
wolves_shop_banners
wolves_shop_banners_history
wolves_shop_categories
wolves_shop_categories_description
wolves_shop_configuration
wolves_shop_configuration_group
wolves_shop_counter
wolves_shop_counter_history
wolves_shop_countries
wolves_shop_currencies
wolves_shop_customers
wolves_shop_customers_basket
wolves_shop_customers_basket_attributes
wolves_shop_customers_info
wolves_shop_geo_zones
wolves_shop_languages
wolves_shop_manufacturers
wolves_shop_manufacturers_info
wolves_shop_newsletters
wolves_shop_orders
wolves_shop_orders_products
wolves_shop_orders_products_attributes
wolves_shop_orders_products_download
wolves_shop_orders_status
wolves_shop_orders_status_history
wolves_shop_orders_total
wolves_shop_products
wolves_shop_products_attributes
wolves_shop_products_attributes_download
wolves_shop_products_description
wolves_shop_products_notifications
wolves_shop_products_options
wolves_shop_products_options_values
wolves_shop_products_options_values_to_products_options
wolves_shop_products_to_categories
wolves_shop_reviews
wolves_shop_reviews_description
wolves_shop_sessions
wolves_shop_specials
wolves_shop_tax_class
wolves_shop_tax_rates
wolves_shop_whos_online
wolves_shop_zones
wolves_shop_zones_to_geo_zones
wolves_smiles
wolves_spotlight
wolves_stories
wolves_tb_tabs
wolves_tinycontent
wolves_tinycontent0
wolves_topics
wolves_tplfile
wolves_tplset
wolves_tplsource
wolves_users
wolves_wfs_article
wolves_wfs_broken
wolves_wfs_category
wolves_wfs_config
wolves_wfs_files
wolves_wfs_votedata
wolves_xoopscomments
wolves_xoopsnotifications
wolves_xoopspoll_desc
wolves_xoopspoll_log
wolves_xoopspoll_option
wolves_phpads_acls
wolves_phpads_adclicks
wolves_phpads_adstats
wolves_phpads_adviews
wolves_phpads_affiliates
wolves_phpads_banners
wolves_phpads_clients
wolves_phpads_config
wolves_phpads_images
wolves_phpads_session
wolves_phpads_userlog
wolves_phpads_zones


Please Please Please Please, some one give me a clue.
Anyone thinking of installing this hack - beware!!! you are going to struggle getting help with it!

13
intel352
Re: Subsite Hack, help with tables to share??
  • 2004/5/26 11:59

  • intel352

  • Module Developer

  • Posts: 824

  • Since: 2003/11/23


do not share:

wolves_config
** the following 2 could possibly be shared as well, not sure **
wolves_configcategory
wolves_configoption
****
wolves_online
wolves_session (don't see any reason why those 2 would need to be shared, but probably wouldn't hurt to share them)
wolves_tpl* << don't share any of the tpl tables, methinks, not certain

if you want to share which modules are enabled and how the blocks are arranged, etc, then you will likely need to share the groups tables, so everything links correctly


but yeah, definitely do not share the config table, that's probably most vital to making your hack work, but the best way to find out is probably trial and error, just backup the site databases before doing anything


btw, looks like you already pulled out most of your hair
hehe (j/k)

Login

Who's Online

260 user(s) are online (88 user(s) are browsing Support Forums)


Members: 0


Guests: 260


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits