Previous Thread
Next Thread
Print Thread
Hop To
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Nice to have feature.
It is cumbersome when wanting to change a island that is inserted in a forum to find them.
Or to figure out what islands are currently being used in forums.
They do not show up on the layout page and there is no indication what islands are being used in which forums.

So you end up just scrolling every forum to find a island you want to change if they even have one.
Then goto forum details to find the name of the island then goto custom islands to make the change.

So I am asking for something to figure out what islands are in use and where.
For example
In the custom islands page there would be plenty of room to add a column named Custom Island Insert
and in the rows show the forum they are in.
Plus possibly a indicator to show all islands which are in use whether they be side or insert islands.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jan 2004
Posts: 2,474
Likes: 3
D
Pooh-Bah
Pooh-Bah
D Offline
Joined: Jan 2004
Posts: 2,474
Likes: 3
It's possible that I'm misunderstanding you, but do you recall this...?
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'
Clearly the query can be massively improved upon (it was done hastily), but it does at least indicate the island and the forum with which it is associated.

Joined: Jun 2006
Posts: 16,289
Likes: 115
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,289
Likes: 115
The forum island insert is generally used to display ads between the first and second posts in a thread; and where there is currently no indication which islands are currently utilized and where, you can use an SQL query to...

Show all forums using a forum island insert (any island):
SQL Query
SELECT `FORUM_TITLE`, `FORUM_ID` FROM `ubbt_FORUMS` WHERE `FORUM_ISLAND_INSERT`!='0' ORDER BY `FORUM_TITLE` ASC


Show all forums using a specific forum island insert (island 1):
SQL Query
SELECT `FORUM_TITLE`, `FORUM_ID` FROM `ubbt_FORUMS` WHERE `FORUM_ISLAND_INSERT`='1' ORDER BY `FORUM_TITLE` ASC


Update the forum island insert for a specific forum (island 1, forum 5):
SQL Query
UPDATE `ubbt_FORUMS` SET `FORUM_ISLAND_INSERT` = '1' WHERE `FORUM_ID` = '5';


Update the forum island insert for specific forums (island 1, forum 5, 6, 8):
SQL Query
UPDATE `ubbt_FORUMS` SET `FORUM_ISLAND_INSERT` = '1' WHERE (`FORUM_ID` = '5' OR `FORUM_ID` = '6' OR `FORUM_ID` = '8');


Clear the forum island insert for a specific forum (forum 5):
SQL Query
UPDATE `ubbt_FORUMS` SET `FORUM_ISLAND_INSERT` = '0' WHERE `FORUM_ID` = '5';


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
2 members like this: isaac, driv
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Thanks but
This is the suggestion forum.
I was suggesting a management tool to find them easier.

Sql query works and I have used it but it is still cumbersome switching between multiple pages to get to the objective.

Read my last comment in the post

Quote
For example
In the custom islands page there would be plenty of room to add a column named Custom Island Insert
and in the rows show the forum they are in.
Plus possibly a indicator to show all islands which are in use whether they be side or insert islands.

What happens at least in my case.
I may have 100 custom islands and have only 20 active at a time switching them in and out for specific reasons.
Such as holidays specials sales or current events
So it gets hard determining if say a custom island is in use or not and where it is being used.
Or used in multiple locations.

Or my observation is most users create/add a island then add another island.
So they end up with most islands do not work correctly.
Since there is no way to delete a island in the cp they end up with many islands that are not even being used.

Oh another request allow to delete a island!


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
1 member likes this: driv

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Forum Privacy Policy
by ECNet - 02/26/2024 11:58 AM
Who's Online Now
0 members (), 353 guests, and 145 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)