Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 63 guests, and 261 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
isaac
isaac
California
Posts: 1,172
Joined: April 2004
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 17
isaac 15
Ruben 11
Morgan 6
Abbott 2
BB 2
Latest Photos
Previous Thread
Next Thread
Print Thread
Which advert belongs to each forum? #259098
02/16/17 03:28 PM
02/16/17 03:28 PM
Joined: Jan 2004
Posts: 2,654
driv Offline OP

driv  Offline OP


Joined: Jan 2004
Posts: 2,654
Today, I was asked "Which forum is so&so (custom island) advert located in?"
It occured to me that I couldn't easily report on this.

I mean yes, I can go to the Custom Islands tab and see all of them - but I don't see which forums 'own' the advert.
And of course I can visit each forum, click on 'details' and then custom inserts - but with a lot of forums this would take a while.

Am I missing something here? Surely there is an easier way. (?)

I knocked this query up quickly and it works for what I need, but again, am I missing something?

SQL Query
SELECT FORUM_ID, FORUM_TITLE, FORUM_ISLAND_INSERT, PORTAL_ID, PORTAL_NAME FROM ubbt_FORUMS, ubbt_PORTAL_BOXES WHERE FORUM_ISLAND_INSERT = PORTAL_ID AND PORTAL_CUSTOM = '1'


Using version :: 7.6.0
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Which advert belongs to each forum? [Re: driv] #259099
02/16/17 03:54 PM
02/16/17 03:54 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
no you did not miss something
sounds like something I asked for years ago.
Better management tools of the forum settings.
It is to easy to loose track of what permissions,settings are for each forum..
In fact I had asked for some sample sql queries in the meantime be added to the stock code..


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Which advert belongs to each forum? [Re: driv] #259100
02/16/17 04:14 PM
02/16/17 04:14 PM
Joined: Jan 2004
Posts: 2,654
driv Offline OP

driv  Offline OP


Joined: Jan 2004
Posts: 2,654
Ah ok. Thanks for letting me know.
Is that query of any use to you?


Using version :: 7.6.0
Re: Which advert belongs to each forum? [Re: driv] #259101
02/16/17 04:34 PM
02/16/17 04:34 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
Already copied to test.
Ha!


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Which advert belongs to each forum? [Re: driv] #259102
02/16/17 04:45 PM
02/16/17 04:45 PM
Joined: Dec 2003
Posts: 5,903
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,903
Lutz,FL
also SD has some useful queries.

http://sirdude.com/handy-mysql-queries-for-ubb-threads
I like the one for styles popularity
But they all are useful


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Which advert belongs to each forum? [Re: Ruben] #259103
02/16/17 05:02 PM
02/16/17 05:02 PM
Joined: Apr 2004
Posts: 1,172
California
isaac Offline
UBB.threads Developer
isaac  Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,172
California
Originally Posted by Ruben
also SD has some useful queries.

http://sirdude.com/handy-mysql-queries-for-ubb-threads
I like the one for styles popularity
But they all are useful


Josh Pett also created a list in 2003 that had many replies, with additional useful queries.
http://www.ubbdev.com/forums/ubbthreads.php/topics/258506/useful-mysql-queries-for-ubb-threads.html

Rick Baker also created a list shortly after. You can find that list by searching the UBBCentral forums here.

These lists are generally to perform a specific task.

Be warned: making manual changes to your DB can easily break things -- and if you dont have a backup, your changes can be broken without any way to revert them.


isaac @ id242.com // forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.6.2 Changelog

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Control Panel / Transactions Username
by Morgan. 06/20/18 05:38 AM
Custom Insert won't save
by Baldeagle. 06/18/18 07:44 PM
New Image capabilities ver 7.6.1
by Abbott. 06/14/18 02:28 PM
Thread deleted?
by Lisanne. 06/05/18 11:13 AM
Forum Statistics
Forums36
Topics35,123
Posts191,338
Members12,088
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)