Previous Thread
Next Thread
Print Thread
Hop To
Joined: Dec 2003
Posts: 6,278
Likes: 45
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,278
Likes: 45
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
Pooh-Bah
Offline
Pooh-Bah
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.


Using version :: 7.7.4
Joined: Jun 2006
Posts: 16,014
Likes: 58
UBB.threads Developer
Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 16,014
Likes: 58
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,278
Likes: 45
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,278
Likes: 45
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
v7.7.5 Active Topics Display Name Incorrect
by Jake - 11/17/2020 4:46 PM
custom islands in forums tool
by Ruben - 11/17/2020 3:21 PM
Captcha bug maybe?
by Morgan - 11/16/2020 8:34 AM
Facebook thumbnail issue
by DBryce - 11/08/2020 7:43 PM
No hop to menu in the category pages
by Morgan - 11/05/2020 4:19 PM
Who's Online Now
1 members (Gizmo), 73 guests, and 69 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5