Previous Thread
Next Thread
Print Thread
Hop To
#171358 12/28/2006 10:34 AM
Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
With the conversion, I had a tremendous glitch with the calendar.

One of my moderators went in and added birthdays for every day there was a bday so that it'd appear in this calendar modification we had.

Now, a little bit like the PMs that regenerated themselves, the calendar is very messed up--with lots of repeats of the hand-entered events.

Right now, I have her going in and deleting these events, but it is a very time-consuming task!

Is there any way to do a mass clean-up of the calendar w/out killing the birthdays added via the profile option, or any way that more than one event can be edited at a time?

If you want to see what I'm talking about, click HERE!

~Sue
adwoff.com

ADWOFF #171370 12/28/2006 1:05 PM
Joined: Aug 2006
Posts: 1,649
Likes: 1
Pooh-Bah
Pooh-Bah
Joined: Aug 2006
Posts: 1,649
Likes: 1

Which "calendar modification"?

That is a mess. With the standard calendar function it'd be unnecessary to manually add any birthdays that your members choose to share themselves via their profile settings.



GangsterBB.NET (Ver. 7.6.1.1)
PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
jgeoff #171397 12/28/2006 7:09 PM
Joined: Jun 2006
Posts: 16,299
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,299
Likes: 116
I'm thinking you could do an SQL query to delete all rows containing "birthday" from the database?


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!
Gizmo #171398 12/28/2006 7:13 PM
Joined: Jun 2006
Posts: 16,299
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,299
Likes: 116
Something like this comes to mind:
Code
delete from `ubb7_CALENDAR_EVENTS` where `CALENDAR_EVENT_SUBJECT` LIKE CONVERT( _utf8 'birthday%' USING latin1 );

Keep in mind that birthdays shown through the profile option are not kept in the calendar_events table. and be sure to replace my ubb7 with whatever your forum prefix is.


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!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
0 members (), 541 guests, and 181 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)