Previous Thread
Next Thread
Print Thread
Rating: 14
Page 2 of 4 1 2 3 4
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
I can have the query select WHERE E_Date > $now AND E_Date < 604800 to bring up 7 days of events. []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]


Sponsored Links
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Ah, OK. Well, I can't help but be disappointed because I put my calendar in production, and I can't change the fields anymore []https://www.ubbdev.com/threads/php/images/icons/frown.gif[/]

On another note, see my message entitled "Easier hack merges" at https://www.ubbdev.com/threads/php/showthreaded.php?Cat=&Board=phpcustomizing&Number=44460 for a version of the postlist.php which breaks out the calendar code from the original code... much easier to upgrade or add additional hacks this way.

Regards,
Max

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
That query wont work but I made one that does... lol along the same lines.

In the calendar addon they only need change one line in the addpost script so that E_Date also includes the time from E_Time.

This will allow for the events to be displayed as they happen. Otherwise the time display will not be in order. It will also be an option to show the location along with the subject in the dispaly []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
My test site is 5.5 only... I am waiting for the 6.0 before upgrading my main site then I'll set the test site up with that. For the time being just kicking 5.5 around... lol []https://www.ubbdev.com/threads/php/images/icons/wink.gif[/]

Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
That's incomprehensible then. Our boards are behaving differently regarding deleted/re-added posts.
Max

Sponsored Links
sjsaunders #213758 02/16/2002 11:21 PM
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Looking at this again, I'm confused here...
why the complicated first part? Are you doing anything more than checking whether B_Calendar is equal to Y ?

How about simply

$query = "
DELETE FROM w3t_Events
WHERE E_Number = '$Number'
";
$dbh -> do_query($query);

no if conditions, no double queries, just delete if you find it... why the rest of the stuff - am I missing something?

Max

Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Here's an update to the calendar.

- The default view now has both the calendar as well as the posts.
- Changed terminology as a result (show/hide calendar, instead of change views)
- Several small bug fixes
- Reworked code in postlist.php to make it much easier to upgrade in the future
- Included small graphics to navigate from month to month
- Event seperator is no longer browser-specific (the small > were previously only working in Explorer)

Enjoy!
Max

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Sounding great Max []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]

Were you going to make that change in the E_Date variable to include the time also? This doesn't seem to affect the display order for "days" and helps when sorting with time specific orders. []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]

Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Forgot to upload, sorry... here it is.
Max
Attachments
44541-calendar_V2.1.zip (0 Bytes, 10 downloads)

sjsaunders #213762 02/18/2002 6:43 AM
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Hi Dave,

I'm not sure which change you mean... is it this one, which calculates the date differently, or this one, where I think you're talking about modifying the fields? Or did I misunderstand the latter, are these two one and the same?

Max

Sponsored Links
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Max,

I sent an email explaining what to change in the addpost.php script. []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]

Let me know if it doens't clear things up. []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]

Joined: Feb 2002
Posts: 67
Power User
Power User
Offline
Joined: Feb 2002
Posts: 67
Suggestions for the next version:

  • variables for the weekdays & months for international users ... for configuring language-specific names
  • option to use & display the 24h- or am/pm-time-format

sjsaunders #213765 02/18/2002 10:55 AM
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Thanks Dave...

Readers: The change in addpost.php described on https://www.ubbdev.com/threads/php/showthreaded.php?Cat=&Board=phpcustomizing&Number=44441 doesn't interfere with the normal operation of the calendar, and will be included in the next versino of the calendar in order to support Dave's indexpal hack - in the meantime, if you install indexpal, just make the change on your own []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]
Max

Maze_Brendan #213766 02/18/2002 11:09 AM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
I had to remove the linked zip files from the thread as they violate copyright rules by including the full ubbthreads files modified to include the calendar modification. Sorry for any inconvenience.

I am available to assist with documenting the differences so we can post this the correct way and not get the site in trouble... []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/] If we each take a file and doc the changes, I can put them together in one file or Max can while he is working on the new version []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]


- Allen wavey
- What Drives You?
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Hi Allen,

As per my PM: would a possible solution entail "replacement" texts for each of the original scripts? Ie if an original script has a hundred lines, maybe the hack should say "replace lines 2 to 99 with the following" ... would that work for your copyright lawyer?

Regards,
Max

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
The only problem with using line numbers would be if they had already modified their files, then the numbers would be off. The same problem would occur if they just uploaded the files previously presented and had other modifications involved. Errors would most likely occur if there were conflicts []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]

We've been handling it like this at ubbdev for a couple years now, you can post a line or 2 above/below so the user can find the correct spot to make the changes in their files. We can also write mhk files so the user can auto-install them without error (as long as the mhk file was written correctly []https://www.ubbdev.com/threads/php/images/icons/wink.gif[/] ) - I've been using it for a year or so now and it works really well []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/] - www.multihack.com - a threads skin is not available yet, but we can easily adapt it to the ubb or vb one until it is ready []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]


- Allen wavey
- What Drives You?
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Hi Allen,

The way I'm proposing to do it, I don't think that there could be many errors. In concept, I'm proposing:

In addpost.php, find the section that starts with:

# Note: if you modify ANY code within UBBThreads, we at Infopop Corporation
# cannot offer you support-- thus modify at your own peril []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]
# ---------------------------------------------------------------------------
*/

and that ends with:

$html -> send_footer();
?>

And replace it with the attached file.

I'm not being facecious... would the above address your copyright lawyer's concerns?

Regards,
Max

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
I don't have a copyright Lawyer []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]

And your newer example is still basically the whole file, minus the copyright info.. heheh... we've always used just 1-2 lines above or below the code section needing to be replaced, it keeps us in copyright heaven and doesn't delete the 2 rows of post icons I see above this message box []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/] (it makes modifications minimally conflict with other modifications).

I'll ask Rick to look at this and post his thoughts... thanks for being patient.


- Allen wavey
- What Drives You?
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
If it would help, I can write one based on the currently available modification and show all developers how it should be done... would help with questions in the future.


- Allen wavey
- What Drives You?
Joined: Aug 1999
Posts: 184
Member
Member
Offline
Joined: Aug 1999
Posts: 184
What we are trying to do here is prevent those who have not paid for the rights to use the board to collect a majority of the files freely. If you send me your edited code, I can toss em in Beyond Compare and make an update text for all the differences and you can publish that.


Silly ricer.. Wings are for airplanes!
Franky #213773 02/18/2002 5:38 PM
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Sorry, I thought the primary concern was a copyright concern, as opposed to the collection of the files by people who have not paid for the software.

I understand now.

I guess the best way would be to all agree on a utility to install hacks. I've never used Beyond Compare, but that might be an option - Allen mentions Multihack above. I hope we can find one which is open source, and that makes it easy to achieve the necessary pupose.

A much simpler way might be to restrict access to the hack board to those who have a current license. If you have a valid licence, you belong to a user group who has read/download privileges, otherwise you don't.

I guess I'll leave it to Allen at this point.

Regards,
Max

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Sorry I wasn't making myself clear []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/] I mentioned copyright because that's part of it, and making the files available to people who do not own the script is the other part []https://www.ubbdev.com/threads/php/images/icons/crazy.gif[/]

Someone mentioned diffs, as in deleting everything except the differences and 1-2 lines above and below. I had never thought of that before, but using Beyond Compare would make it extremely simple to copy those changes into the user's files. Should be fine with Rick as well and not violate any copyright concerns. I'll give it a shot with the calendar scripts you posted and see how well Beyond Compare handles it. []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]


- Allen wavey
- What Drives You?
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
hmmm.. the problem with that method is BC wants things to match up, so it will put pieces matching in the wrong place just so it does match. We may need 4-5 lines to get the differences to line up like they should, then we run into more possible conflicts. I'll look at it some more, any other ideas welcomed as well []https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]


- Allen wavey
- What Drives You?
Joined: Jun 2001
Posts: 176
Member
Member
Offline
Joined: Jun 2001
Posts: 176
attachment for 2.1 is not working

interforos #213777 02/19/2002 11:29 AM
Joined: Sep 2001
Posts: 129
Member
Member
Offline
Joined: Sep 2001
Posts: 129
Ok I have tried and checked everything but this dosnt seem to work for me, I am on 5.5.1 I have checked all the changes have been made to the DB and they have I have created a new forum and checked a dump of the DB to check that the Calender flag is set and it is.
When you post in the forum the only change I see is the header for the main box is 'Detailed Event Description', if you reply I see no changes and when you view the post it displays as normal?
I have definetly changed the 5 files that come with the zip.
Can anyone suggest what I may be wrong.

Thanx
Clint


Regards
Clint

Running on WIN2003 Web Server.

Paranoid people get followed too!
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Hi Allen,

I would respectfully suggest that you/Scream/Infopop have to figure out what it is you're protecting yourselves against.

If it's copyright issues that you're worrying about, then I do suggest you get a copyright lawyer to draft up a standard agreement which covers derivative works, otherwise people posting hacks may have a claim to their work, regardless of the mechanism used to communicate these hacks to others.

If it's access to the scripts that you're worried about, then I would argue that a restricted-access board for certain hacks may be the easiest & most expedient solution.

Perhaps you need a combination of both.

Regards,
Max

interforos #213779 02/19/2002 6:05 PM
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149

Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Hi Clint,

What do you see when you fist click on the board? Do you see the calendar?
Max

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Max, I really appreciate the work you put in and shared, but I don't understand what is difficult to understand about this. The files are copyrighted and as such cannot be redistributed to anyone:

# You may not distribute this program in any manner, modified or otherwise,
# without the express, written written consent from Infopop Corporation.

That is at the top of every file included with threads. You've been around a while now, Rick has stated he didn't allow posting of complete files any time recently.

Restricted access to forums where files can be posted is impossible anytime soon as well - we do not have access to members area data and will not be getting it. Anything short of that will be circumvented quite easily.

We have been posting text files of changes to be added for a while now, it does take some time - if you'd like for me to do the first one, no problem, then you can edit it to update it for any future changes.


- Allen wavey
- What Drives You?
Joined: Sep 2001
Posts: 129
Member
Member
Offline
Joined: Sep 2001
Posts: 129
No max I see it just like a normal post I have never seen a calendar view as yet.


Regards
Clint

Running on WIN2003 Web Server.

Paranoid people get followed too!
Joined: Sep 2001
Posts: 129
Member
Member
Offline
Joined: Sep 2001
Posts: 129
This copywrite arguement seems a bit silly to me, my point being that you can go to many serial/hack type site and download the whole version but you cant go to the official site and download a modified [no warrenty given] file !


Regards
Clint

Running on WIN2003 Web Server.

Paranoid people get followed too!
Joined: Sep 2001
Posts: 129
Member
Member
Offline
Joined: Sep 2001
Posts: 129
Max if you would like to take a look you can sign up at www.turbosport.co.uk and let me know your username.


Regards
Clint

Running on WIN2003 Web Server.

Paranoid people get followed too!
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Hi Turbo,

> No max I see it just like a normal post

No... before you click on an individual post, when you click on a board name, ie when the URL shown is postlist.php . What do you see?

Regards,
Max

Joined: Aug 1999
Posts: 184
Member
Member
Offline
Joined: Aug 1999
Posts: 184
It could be that the MySQL statement to turn on the calendar was inputted wrong. I was confused on this at first and found that the script wanted the Displayed name of the board, not the hidden name.


Silly ricer.. Wings are for airplanes!
Franky #213787 02/20/2002 9:55 PM
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
You can edit your board, make sure that everything is OK, then run the command again to make sure that the calendar field in is set to "Y".

Max

Franky #213788 02/21/2002 3:43 AM
Joined: Sep 2001
Posts: 129
Member
Member
Offline
Joined: Sep 2001
Posts: 129
The Displayed title for the board is 'Turbosport Calandar'
This is the postlist URL:
http://bbs.turbosport.co.uk/postlist.php?Cat=&Board=TSCalendar

Here is the SQL Statement I ran:
UPDATE w3t_Boards
SET Bo_Calendar = 'Y'
WHERE Bo_Title = 'TSCalendar' ;

The field is set to Y. if you look at the sql dump here:
INSERT INTO w3t_boards VALUES ('Turbosport Calendar','The Turbosport Calendar','TSCalendar',NULL,2,1014130982,'Off','Off',47,1014112870,0,'Off','yes',2,'-1-','-1-',1,NULL,'General Discussion',0,'Slim',',CossieClint,','-1-',NULL);

All you get is a normal view !


Regards
Clint

Running on WIN2003 Web Server.

Paranoid people get followed too!
Joined: May 1999
Posts: 149
Enthusiast
Enthusiast
Offline
Joined: May 1999
Posts: 149
Hi Turbo,

No, the field doesn't seem to have been successfully set to 'Y'. The last value is NULL, it should be Y.

In the mysql console, you might have to run
USE yourdatabasenamehere;
prior to the sql statement.

Regards,
Max


Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Wouldn't the correct query be this:

UPDATE w3t_Boards
SET Bo_Calendar = 'Y'
WHERE Bo_Keword = 'TSCalendar';


and not:

UPDATE w3t_Boards
SET Bo_Calendar = 'Y'
WHERE Bo_Title = 'TSCalendar';


TSCalendar doens't seem to be the title but hey it's late and I'm tired. []https://www.ubbdev.com/threads/php/images/icons/wink.gif[/]

sjsaunders #213791 02/22/2002 7:48 AM
Joined: Sep 2001
Posts: 129
Member
Member
Offline
Joined: Sep 2001
Posts: 129
Its working !

Thanx Guys I ran this statement:
UPDATE w3t_Boards
SET Bo_Calendar = 'Y'
WHERE Bo_Keyword = 'TSCalendar';

Does this mean the instructions are wrong ? has anyone else not had this issue?


Regards
Clint

Running on WIN2003 Web Server.

Paranoid people get followed too!
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
I don't know for sure. I never looked at the instructions that closely.. LoL

Page 2 of 4 1 2 3 4

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
hatter
hatter
USA
Posts: 69
Joined: January 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)