Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 17:31:44
by alightner
Ah, in that case perhaps only a few people who used that mod and use the same conversion method as you have this problem... I might not publish the solution afterall as I don't really know what format most converted phpbb2->phpbb3 birthdays will have.
Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 17:26:25
by marian0810
Thank you very, very much for all your work and support
One thing just occurred to me... I used Niels' old Birthday mod on phpBB2, and after converting to phpBB3 all the birthdays were wrong because the day and the month had swapped places. Apparently that's a known bug that I could have avoided by changing the convertor before I started it, if I had known about it.
Now I don't know anything about SQl but I had help from Lefty74 who made a query to correct them. However, anyone who knows how to write a query would probably do this on his own. My point being that those queries aren't necessarily all exactly the same, so maybe the problem won't be either. Just thinking out loud here, I have no idea if it makes any sense
Anyway, thanks again. You help is much appreciated!!
Quote alightner Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 17:12:45
by alightner
Excellent, having converted all of the dates properly will fix any bugs that occur elsewhere in the forum (not just the calendar mod) so I think that's the correct solution instead of adapting the calendar mod to work with the legacy data. You can safely remove that test block of code from your calendar.php file. I'll post an update later with instructions on how everyone else can convert their birthdates to avoid this problem.
Thanks!
Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 16:44:18
by marian0810
Done. I already saw a lot of names reappear
Quote alightner Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 16:37:43
by alightner
OK - here's the list of user_id's who's birthdates have been reformatted:
Code: Select all
user_id joined on birthday reformatted
1 Sat 03 Jan 2009, 14:59:21 '' ' 0- 0- 0'
8 Mon 12 Mar 2007, 19:50:50 '' ' 0- 0- 0'
20 Wed 28 Mar 2007, 09:31:29 '' ' 0- 0- 0'
22 Wed 28 Mar 2007, 13:44:59 '' ' 0- 0- 0'
23 Wed 28 Mar 2007, 13:47:12 '' ' 0- 0- 0'
26 Wed 28 Mar 2007, 13:56:30 '4- 7-1947' ' 4- 7-1947'
28 Wed 28 Mar 2007, 13:56:55 '1- 5-1957' ' 1- 5-1957'
29 Wed 28 Mar 2007, 13:59:51 '' ' 0- 0- 0'
30 Wed 28 Mar 2007, 14:18:16 '' ' 0- 0- 0'
32 Wed 28 Mar 2007, 14:52:46 '7- 7-1946' ' 7- 7-1946'
34 Wed 28 Mar 2007, 15:29:55 '' ' 0- 0- 0'
35 Wed 28 Mar 2007, 15:35:18 '' ' 0- 0- 0'
36 Wed 28 Mar 2007, 15:42:03 '' ' 0- 0- 0'
40 Wed 28 Mar 2007, 17:51:58 '' ' 0- 0- 0'
41 Wed 28 Mar 2007, 18:08:44 '3-10-1968' ' 3-10-1968'
47 Wed 28 Mar 2007, 20:39:15 '' ' 0- 0- 0'
48 Wed 28 Mar 2007, 20:44:04 '' ' 0- 0- 0'
49 Wed 28 Mar 2007, 20:45:13 '' ' 0- 0- 0'
50 Wed 28 Mar 2007, 20:54:15 '7- 8-1964' ' 7- 8-1964'
53 Wed 28 Mar 2007, 21:09:00 '5- 3-1963' ' 5- 3-1963'
54 Wed 28 Mar 2007, 21:10:20 '' ' 0- 0- 0'
55 Wed 28 Mar 2007, 21:11:22 '' ' 0- 0- 0'
56 Wed 28 Mar 2007, 21:25:41 '' ' 0- 0- 0'
58 Wed 28 Mar 2007, 22:28:38 '' ' 0- 0- 0'
61 Thu 29 Mar 2007, 07:34:39 '' ' 0- 0- 0'
62 Thu 29 Mar 2007, 07:48:38 '' ' 0- 0- 0'
65 Thu 29 Mar 2007, 09:36:03 '' ' 0- 0- 0'
66 Thu 29 Mar 2007, 09:40:22 '' ' 0- 0- 0'
68 Thu 29 Mar 2007, 10:00:20 '' ' 0- 0- 0'
69 Thu 29 Mar 2007, 10:15:11 '' ' 0- 0- 0'
70 Thu 29 Mar 2007, 10:32:04 '2-11-1975' ' 2-11-1975'
73 Thu 29 Mar 2007, 10:48:59 '' ' 0- 0- 0'
74 Thu 29 Mar 2007, 11:00:16 '' ' 0- 0- 0'
75 Thu 29 Mar 2007, 11:09:55 '' ' 0- 0- 0'
76 Thu 29 Mar 2007, 13:54:04 '' ' 0- 0- 0'
77 Thu 29 Mar 2007, 14:44:42 '' ' 0- 0- 0'
78 Thu 29 Mar 2007, 15:03:18 '4- 7-1967' ' 4- 7-1967'
79 Thu 29 Mar 2007, 17:55:49 '' ' 0- 0- 0'
81 Thu 29 Mar 2007, 21:55:52 '' ' 0- 0- 0'
83 Fri 30 Mar 2007, 00:34:18 '' ' 0- 0- 0'
85 Fri 30 Mar 2007, 13:06:55 '' ' 0- 0- 0'
87 Fri 30 Mar 2007, 22:09:34 '' ' 0- 0- 0'
88 Fri 30 Mar 2007, 23:11:11 '' ' 0- 0- 0'
89 Sat 31 Mar 2007, 13:59:27 '' ' 0- 0- 0'
90 Sat 31 Mar 2007, 14:40:40 '' ' 0- 0- 0'
92 Sun 01 Apr 2007, 01:33:13 '3- 1-1961' ' 3- 1-1961'
94 Sun 01 Apr 2007, 10:13:21 '' ' 0- 0- 0'
97 Sun 01 Apr 2007, 20:33:34 '' ' 0- 0- 0'
100 Mon 02 Apr 2007, 21:38:45 '' ' 0- 0- 0'
101 Tue 03 Apr 2007, 11:05:03 '4-11-1960' ' 4-11-1960'
102 Tue 03 Apr 2007, 12:15:35 '' ' 0- 0- 0'
103 Tue 03 Apr 2007, 14:40:38 '' ' 0- 0- 0'
104 Tue 03 Apr 2007, 15:23:04 '' ' 0- 0- 0'
108 Fri 06 Apr 2007, 22:18:30 '' ' 0- 0- 0'
110 Sat 07 Apr 2007, 16:00:06 '' ' 0- 0- 0'
111 Sat 07 Apr 2007, 19:53:48 '' ' 0- 0- 0'
112 Sun 08 Apr 2007, 15:59:35 '' ' 0- 0- 0'
113 Mon 09 Apr 2007, 16:05:57 '' ' 0- 0- 0'
116 Tue 10 Apr 2007, 11:28:59 '' ' 0- 0- 0'
118 Fri 13 Apr 2007, 13:10:03 '1- 8-1977' ' 1- 8-1977'
121 Mon 16 Apr 2007, 13:30:42 '' ' 0- 0- 0'
123 Tue 17 Apr 2007, 20:14:13 '' ' 0- 0- 0'
126 Fri 20 Apr 2007, 19:59:39 '' ' 0- 0- 0'
128 Sun 22 Apr 2007, 11:03:32 '7-10-1988' ' 7-10-1988'
129 Tue 24 Apr 2007, 09:18:41 '' ' 0- 0- 0'
130 Wed 25 Apr 2007, 23:04:34 '' ' 0- 0- 0'
131 Thu 26 Apr 2007, 19:37:11 '' ' 0- 0- 0'
132 Fri 27 Apr 2007, 18:32:06 '' ' 0- 0- 0'
134 Sun 29 Apr 2007, 15:49:13 '' ' 0- 0- 0'
135 Sun 29 Apr 2007, 16:29:23 '8-10-1970' ' 8-10-1970'
136 Sun 29 Apr 2007, 23:14:10 '3- 7-1966' ' 3- 7-1966'
137 Mon 30 Apr 2007, 21:49:07 '' ' 0- 0- 0'
138 Tue 01 May 2007, 16:50:06 '8- 3-1971' ' 8- 3-1971'
139 Wed 02 May 2007, 17:00:26 '' ' 0- 0- 0'
141 Fri 04 May 2007, 14:27:06 '' ' 0- 0- 0'
144 Sat 05 May 2007, 19:07:47 '' ' 0- 0- 0'
145 Sat 05 May 2007, 19:08:50 '1- 4-1960' ' 1- 4-1960'
146 Sun 06 May 2007, 21:17:18 '' ' 0- 0- 0'
147 Mon 07 May 2007, 11:03:07 '' ' 0- 0- 0'
148 Mon 07 May 2007, 16:05:35 '' ' 0- 0- 0'
150 Wed 09 May 2007, 10:40:19 '' ' 0- 0- 0'
151 Wed 09 May 2007, 11:20:04 '' ' 0- 0- 0'
152 Wed 09 May 2007, 12:27:21 '5- 9-1973' ' 5- 9-1973'
153 Wed 09 May 2007, 20:15:03 '' ' 0- 0- 0'
156 Thu 10 May 2007, 19:48:52 '' ' 0- 0- 0'
157 Thu 10 May 2007, 21:55:17 '' ' 0- 0- 0'
159 Sat 12 May 2007, 15:50:38 '' ' 0- 0- 0'
160 Sun 13 May 2007, 08:09:20 '' ' 0- 0- 0'
161 Sun 13 May 2007, 12:04:49 '5- 8-1957' ' 5- 8-1957'
162 Sun 13 May 2007, 13:20:52 '' ' 0- 0- 0'
163 Mon 14 May 2007, 16:47:38 '' ' 0- 0- 0'
164 Tue 15 May 2007, 11:28:35 '' ' 0- 0- 0'
165 Tue 15 May 2007, 20:35:22 '' ' 0- 0- 0'
166 Wed 16 May 2007, 12:24:52 '' ' 0- 0- 0'
168 Thu 17 May 2007, 16:56:04 '' ' 0- 0- 0'
169 Sat 19 May 2007, 11:33:56 '' ' 0- 0- 0'
170 Tue 22 May 2007, 09:58:59 '' ' 0- 0- 0'
176 Tue 29 May 2007, 16:00:05 '' ' 0- 0- 0'
177 Tue 29 May 2007, 16:02:29 '' ' 0- 0- 0'
179 Wed 30 May 2007, 12:20:41 '2- 5-1970' ' 2- 5-1970'
182 Sat 02 Jun 2007, 21:12:45 '4- 6-1972' ' 4- 6-1972'
185 Mon 04 Jun 2007, 22:27:21 '4-11-1951' ' 4-11-1951'
186 Tue 05 Jun 2007, 11:42:43 '1- 6-1965' ' 1- 6-1965'
189 Thu 07 Jun 2007, 16:49:18 '4- 7-1955' ' 4- 7-1955'
192 Sun 10 Jun 2007, 21:49:33 '' ' 0- 0- 0'
193 Mon 11 Jun 2007, 12:27:27 '4- 6-1952' ' 4- 6-1952'
194 Tue 12 Jun 2007, 21:51:00 '9- 8-1974' ' 9- 8-1974'
199 Sun 17 Jun 2007, 15:13:17 '9-11-1956' ' 9-11-1956'
201 Mon 18 Jun 2007, 21:25:02 '4- 4-1981' ' 4- 4-1981'
203 Thu 21 Jun 2007, 16:20:53 '5- 2-1971' ' 5- 2-1971'
208 Thu 28 Jun 2007, 09:24:12 '7- 7-1977' ' 7- 7-1977'
214 Sun 08 Jul 2007, 21:24:25 '1-11-1943' ' 1-11-1943'
215 Fri 13 Jul 2007, 12:06:07 '3- 6-1963' ' 3- 6-1963'
219 Thu 26 Jul 2007, 21:09:24 '1- 6-1990' ' 1- 6-1990'
220 Thu 26 Jul 2007, 23:00:23 '3- 7-1958' ' 3- 7-1958'
226 Thu 02 Aug 2007, 21:34:59 '1- 9-1958' ' 1- 9-1958'
227 Sun 05 Aug 2007, 09:01:20 '1- 5-1964' ' 1- 5-1964'
232 Tue 07 Aug 2007, 19:32:32 '6- 6-1969' ' 6- 6-1969'
236 Sat 11 Aug 2007, 12:57:58 '5- 6-1985' ' 5- 6-1985'
240 Mon 13 Aug 2007, 19:49:49 '3- 2-1971' ' 3- 2-1971'
248 Wed 22 Aug 2007, 10:09:57 '4- 3-1964' ' 4- 3-1964'
251 Tue 28 Aug 2007, 11:15:41 '9-11-1972' ' 9-11-1972'
253 Tue 28 Aug 2007, 22:33:32 '9- 8-1987' ' 9- 8-1987'
254 Tue 28 Aug 2007, 22:45:08 '1- 9-1948' ' 1- 9-1948'
256 Wed 29 Aug 2007, 14:39:53 '1- 6-1978' ' 1- 6-1978'
259 Sat 01 Sep 2007, 15:14:08 '4- 5-1958' ' 4- 5-1958'
260 Sat 01 Sep 2007, 18:15:32 '5- 7-1952' ' 5- 7-1952'
264 Sun 09 Sep 2007, 15:44:35 '1- 4-1953' ' 1- 4-1953'
265 Sun 09 Sep 2007, 21:22:13 '1- 5-1984' ' 1- 5-1984'
269 Wed 12 Sep 2007, 16:27:31 '1- 3-1974' ' 1- 3-1974'
276 Mon 17 Sep 2007, 17:54:36 '' ' 0- 0- 0'
279 Mon 24 Sep 2007, 12:12:17 '8- 9-1969' ' 8- 9-1969'
287 Mon 01 Oct 2007, 18:34:57 '1- 3-1962' ' 1- 3-1962'
288 Wed 03 Oct 2007, 17:54:25 '9- 7-1951' ' 9- 7-1951'
291 Fri 05 Oct 2007, 16:50:36 '5- 5-1975' ' 5- 5-1975'
293 Sun 07 Oct 2007, 23:49:27 '1-10-1938' ' 1-10-1938'
302 Thu 18 Oct 2007, 23:53:11 '7- 5-1971' ' 7- 5-1971'
303 Sun 21 Oct 2007, 11:00:14 '7- 4-1972' ' 7- 4-1972'
304 Sun 21 Oct 2007, 12:40:48 '4- 3-1955' ' 4- 3-1955'
310 Mon 29 Oct 2007, 23:10:43 '' ' 0- 0- 0'
317 Thu 01 Nov 2007, 15:24:01 '1- 8-1951' ' 1- 8-1951'
322 Fri 09 Nov 2007, 23:59:24 '7- 7-1980' ' 7- 7-1980'
326 Sat 10 Nov 2007, 23:33:10 '5- 7-1967' ' 5- 7-1967'
327 Sun 11 Nov 2007, 10:03:35 '2- 2-1973' ' 2- 2-1973'
331 Tue 13 Nov 2007, 20:30:25 '3- 8-2001' ' 3- 8-2001'
334 Sat 17 Nov 2007, 21:35:26 '' ' 0- 0- 0'
336 Mon 19 Nov 2007, 15:46:01 '2- 4-1963' ' 2- 4-1963'
338 Tue 20 Nov 2007, 15:16:06 '7-10-1982' ' 7-10-1982'
340 Sat 24 Nov 2007, 21:07:54 '' ' 0- 0- 0'
342 Tue 27 Nov 2007, 20:59:21 '2- 8-1947' ' 2- 8-1947'
344 Wed 28 Nov 2007, 10:39:24 '4- 5-1976' ' 4- 5-1976'
354 Mon 10 Dec 2007, 15:03:55 '3- 9-1963' ' 3- 9-1963'
356 Wed 12 Dec 2007, 14:19:08 '2- 2-1956' ' 2- 2-1956'
360 Mon 17 Dec 2007, 17:13:24 '9- 7-1959' ' 9- 7-1959'
361 Tue 18 Dec 2007, 11:18:39 '1- 1-1981' ' 1- 1-1981'
365 Thu 27 Dec 2007, 17:39:49 '' ' 0- 0- 0'
373 Fri 04 Jan 2008, 17:26:40 '7- 6-1961' ' 7- 6-1961'
379 Wed 09 Jan 2008, 17:54:03 '9- 3-1973' ' 9- 3-1973'
380 Thu 10 Jan 2008, 13:36:20 '8- 7-1966' ' 8- 7-1966'
389 Mon 14 Jan 2008, 18:28:28 '8- 6-1957' ' 8- 6-1957'
392 Thu 17 Jan 2008, 11:51:33 '7- 3-1972' ' 7- 3-1972'
397 Mon 21 Jan 2008, 19:35:17 '' ' 0- 0- 0'
399 Wed 23 Jan 2008, 10:50:59 '3- 8-1948' ' 3- 8-1948'
403 Sun 27 Jan 2008, 16:52:36 '3- 8-1984' ' 3- 8-1984'
418 Fri 08 Feb 2008, 23:06:15 '6- 6-1965' ' 6- 6-1965'
420 Mon 11 Feb 2008, 02:27:35 '' ' 0- 0- 0'
426 Thu 14 Feb 2008, 14:12:20 '5-10-1964' ' 5-10-1964'
431 Tue 19 Feb 2008, 11:18:25 '6- 5-1960' ' 6- 5-1960'
436 Thu 21 Feb 2008, 11:38:56 '3- 7-1973' ' 3- 7-1973'
438 Wed 27 Feb 2008, 16:00:10 '5- 2-1985' ' 5- 2-1985'
439 Sat 01 Mar 2008, 11:00:59 '9- 6-1987' ' 9- 6-1987'
441 Sun 02 Mar 2008, 19:57:01 '8- 8-1947' ' 8- 8-1947'
445 Tue 04 Mar 2008, 14:10:03 '5- 2-1971' ' 5- 2-1971'
449 Tue 11 Mar 2008, 16:37:22 '' ' 0- 0- 0'
450 Wed 12 Mar 2008, 12:28:14 '6- 8-1984' ' 6- 8-1984'
453 Fri 14 Mar 2008, 16:42:26 '4- 4-1974' ' 4- 4-1974'
457 Fri 21 Mar 2008, 14:05:35 '3- 3-1972' ' 3- 3-1972'
459 Sun 23 Mar 2008, 18:49:14 '' ' 0- 0- 0'
463 Tue 25 Mar 2008, 11:01:32 '1- 7-1973' ' 1- 7-1973'
467 Sun 30 Mar 2008, 02:39:38 '4- 7-1957' ' 4- 7-1957'
470 Mon 31 Mar 2008, 21:30:51 '8- 9-1955' ' 8- 9-1955'
473 Thu 03 Apr 2008, 22:31:59 '7- 6-1966' ' 7- 6-1966'
475 Sat 05 Apr 2008, 16:03:50 '3- 8-1957' ' 3- 8-1957'
477 Mon 07 Apr 2008, 13:10:01 '1- 9-1956' ' 1- 9-1956'
478 Mon 07 Apr 2008, 19:18:31 '' ' 0- 0- 0'
480 Mon 07 Apr 2008, 21:36:13 '3- 9-1989' ' 3- 9-1989'
481 Thu 10 Apr 2008, 12:48:07 '6- 5-1961' ' 6- 5-1961'
482 Sat 12 Apr 2008, 22:03:58 '2- 5-1968' ' 2- 5-1968'
485 Sun 13 Apr 2008, 21:23:28 '6-10-1979' ' 6-10-1979'
486 Mon 14 Apr 2008, 19:13:10 '1- 6-1953' ' 1- 6-1953'
488 Mon 14 Apr 2008, 20:19:48 '' ' 0- 0- 0'
491 Wed 16 Apr 2008, 10:30:25 '8- 5-1981' ' 8- 5-1981'
493 Sun 20 Apr 2008, 21:33:45 '' ' 0- 0- 0'
496 Mon 21 Apr 2008, 12:52:50 '9- 5-1952' ' 9- 5-1952'
497 Tue 22 Apr 2008, 13:18:11 '2- 7-1954' ' 2- 7-1954'
502 Thu 24 Apr 2008, 22:25:11 '' ' 0- 0- 0'
509 Sun 04 May 2008, 12:08:30 '' ' 0- 0- 0'
520 Mon 12 May 2008, 13:10:32 '7- 7-1958' ' 7- 7-1958'
521 Mon 12 May 2008, 15:40:34 '3- 8-1974' ' 3- 8-1974'
524 Thu 15 May 2008, 13:05:32 '9- 5-1983' ' 9- 5-1983'
525 Thu 15 May 2008, 20:24:18 '5- 7-1976' ' 5- 7-1976'
531 Sun 18 May 2008, 12:35:07 '5-11-1974' ' 5-11-1974'
532 Mon 19 May 2008, 06:27:56 '3-10-1971' ' 3-10-1971'
533 Mon 19 May 2008, 14:21:01 '2- 4-1968' ' 2- 4-1968'
536 Wed 21 May 2008, 15:59:17 '6- 7-1975' ' 6- 7-1975'
543 Mon 26 May 2008, 23:43:39 '1- 9-1982' ' 1- 9-1982'
544 Wed 28 May 2008, 13:02:11 '' ' 0- 0- 0'
548 Fri 30 May 2008, 23:07:03 '1- 8-1957' ' 1- 8-1957'
550 Sat 31 May 2008, 15:30:40 '8-10-1953' ' 8-10-1953'
552 Mon 02 Jun 2008, 01:10:49 '4- 9-1953' ' 4- 9-1953'
553 Mon 02 Jun 2008, 20:43:30 '5-11-1970' ' 5-11-1970'
555 Tue 03 Jun 2008, 23:16:59 '3- 8-1966' ' 3- 8-1966'
556 Wed 04 Jun 2008, 12:51:51 '9- 7-1951' ' 9- 7-1951'
565 Tue 17 Jun 2008, 11:13:08 '5- 8-1964' ' 5- 8-1964'
567 Wed 18 Jun 2008, 15:44:27 '5- 6-1978' ' 5- 6-1978'
570 Thu 26 Jun 2008, 15:34:30 '3- 9-1986' ' 3- 9-1986'
571 Sat 28 Jun 2008, 10:17:06 '9- 7-1951' ' 9- 7-1951'
572 Sat 28 Jun 2008, 11:08:01 '9-10-1943' ' 9-10-1943'
574 Sat 28 Jun 2008, 19:28:48 '9- 7-1951' ' 9- 7-1951'
577 Mon 30 Jun 2008, 19:11:18 '5- 5-1974' ' 5- 5-1974'
578 Mon 30 Jun 2008, 23:11:39 '5- 3-1965' ' 5- 3-1965'
585 Wed 09 Jul 2008, 08:57:56 '9- 4-1980' ' 9- 4-1980'
586 Wed 09 Jul 2008, 14:26:56 '3- 2-1977' ' 3- 2-1977'
587 Thu 10 Jul 2008, 12:04:37 '' ' 0- 0- 0'
589 Fri 11 Jul 2008, 17:03:55 '6- 8-1959' ' 6- 8-1959'
591 Wed 16 Jul 2008, 18:31:42 '' ' 0- 0- 0'
593 Sat 19 Jul 2008, 16:38:40 '4- 3-1973' ' 4- 3-1973'
595 Mon 21 Jul 2008, 08:57:48 '2- 7-1963' ' 2- 7-1963'
598 Mon 21 Jul 2008, 20:03:59 '8- 7-1973' ' 8- 7-1973'
600 Thu 24 Jul 2008, 18:04:33 '9- 6-1964' ' 9- 6-1964'
601 Thu 24 Jul 2008, 18:07:43 '5-11-1983' ' 5-11-1983'
611 Wed 06 Aug 2008, 15:30:27 '' ' 0- 0- 0'
615 Thu 07 Aug 2008, 20:17:18 '6- 8-1957' ' 6- 8-1957'
617 Sat 09 Aug 2008, 16:12:29 '8- 4-1964' ' 8- 4-1964'
621 Wed 13 Aug 2008, 22:22:59 '4- 8-1969' ' 4- 8-1969'
632 Sun 24 Aug 2008, 18:09:13 '3- 1-1978' ' 3- 1-1978'
633 Mon 25 Aug 2008, 10:41:50 '8- 4-1956' ' 8- 4-1956'
641 Sat 30 Aug 2008, 05:43:57 '2- 9-1976' ' 2- 9-1976'
642 Sat 30 Aug 2008, 11:32:11 '1- 3-1965' ' 1- 3-1965'
643 Sat 30 Aug 2008, 16:18:34 '5- 7-1965' ' 5- 7-1965'
646 Mon 01 Sep 2008, 12:46:00 '6- 7-1966' ' 6- 7-1966'
647 Tue 02 Sep 2008, 11:34:26 '5- 5-1975' ' 5- 5-1975'
650 Sat 06 Sep 2008, 23:32:11 '8-10-1958' ' 8-10-1958'
654 Mon 08 Sep 2008, 21:32:42 '1- 9-1971' ' 1- 9-1971'
656 Fri 12 Sep 2008, 14:32:43 '9- 7-1967' ' 9- 7-1967'
657 Fri 12 Sep 2008, 23:47:32 '7- 7-1949' ' 7- 7-1949'
660 Mon 15 Sep 2008, 15:37:05 '1-11-1968' ' 1-11-1968'
665 Wed 17 Sep 2008, 17:09:53 '3- 4-1973' ' 3- 4-1973'
666 Thu 18 Sep 2008, 09:02:41 '6-11-1976' ' 6-11-1976'
668 Sat 20 Sep 2008, 14:05:25 '8- 3-1971' ' 8- 3-1971'
670 Sun 21 Sep 2008, 11:41:50 '' ' 0- 0- 0'
672 Sun 21 Sep 2008, 16:22:47 '6- 9-1975' ' 6- 9-1975'
674 Mon 22 Sep 2008, 13:27:06 '1-10-1985' ' 1-10-1985'
675 Mon 22 Sep 2008, 19:27:03 '7- 7-1993' ' 7- 7-1993'
679 Fri 26 Sep 2008, 10:36:32 '9- 6-1968' ' 9- 6-1968'
705 Fri 17 Oct 2008, 15:42:11 '3- 3-1969' ' 3- 3-1969'
707 Sun 19 Oct 2008, 10:57:25 '9- 4-1970' ' 9- 4-1970'
710 Tue 21 Oct 2008, 09:59:26 '3- 5-1969' ' 3- 5-1969'
714 Wed 22 Oct 2008, 17:35:37 '6- 4-1973' ' 6- 4-1973'
723 Sun 02 Nov 2008, 19:27:06 '3- 7-1957' ' 3- 7-1957'
729 Thu 06 Nov 2008, 14:22:33 '1- 3-1983' ' 1- 3-1983'
730 Mon 10 Nov 2008, 21:34:56 '4- 3-1980' ' 4- 3-1980'
734 Fri 14 Nov 2008, 18:39:39 '8-11-1952' ' 8-11-1952'
739 Thu 20 Nov 2008, 09:42:46 '4- 5-1972' ' 4- 5-1972'
740 Thu 20 Nov 2008, 13:53:02 '1- 1-1980' ' 1- 1-1980'
741 Sat 22 Nov 2008, 10:38:57 '3-10-1968' ' 3-10-1968'
744 Sat 29 Nov 2008, 12:04:37 '9- 5-1961' ' 9- 5-1961'
746 Sun 30 Nov 2008, 00:02:29 '8- 9-1944' ' 8- 9-1944'
750 Wed 03 Dec 2008, 19:23:29 '6- 8-1972' ' 6- 8-1972'
753 Mon 08 Dec 2008, 23:43:24 '2- 4-1983' ' 2- 4-1983'
754 Wed 10 Dec 2008, 20:11:44 '5-11-1957' ' 5-11-1957'
761 Thu 18 Dec 2008, 01:54:28 '5- 4-1954' ' 5- 4-1954'
762 Thu 18 Dec 2008, 10:51:55 '3-10-1969' ' 3-10-1969'
768 Thu 25 Dec 2008, 10:28:41 '7- 9-1967' ' 7- 9-1967'
769 Sat 27 Dec 2008, 14:05:01 '7- 1-1963' ' 7- 1-1963'
776 Sun 04 Jan 2009, 11:33:02 '8-10-1973' ' 8-10-1973'
778 Sun 04 Jan 2009, 14:08:46 '6- 5-1964' ' 6- 5-1964'
782 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
783 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
784 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
785 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
786 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
787 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
788 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
789 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
790 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
791 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
792 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
793 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
794 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
795 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
796 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
797 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
798 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
799 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
800 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
801 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
802 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
803 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
804 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
805 Tue 06 Jan 2009, 02:17:40 '' ' 0- 0- 0'
806 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
807 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
808 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
809 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
810 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
811 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
812 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
813 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
814 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
815 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
816 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
817 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
818 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
819 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
820 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
821 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
822 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
823 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
824 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
825 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
826 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
827 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
828 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
829 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
830 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
831 Tue 06 Jan 2009, 02:17:41 '' ' 0- 0- 0'
832 Tue 06 Jan 2009, 23:35:02 '' ' 0- 0- 0'
833 Wed 07 Jan 2009, 13:35:06 '' ' 0- 0- 0'
834 Wed 07 Jan 2009, 13:52:23 '' ' 0- 0- 0'
835 Thu 08 Jan 2009, 22:21:17 '' ' 0- 0- 0'
836 Fri 09 Jan 2009, 12:15:54 '' ' 0- 0- 0'
837 Fri 09 Jan 2009, 15:15:16 '' ' 0- 0- 0'
838 Fri 09 Jan 2009, 16:30:32 '' ' 0- 0- 0'
839 Sat 10 Jan 2009, 11:39:29 '' ' 0- 0- 0'
840 Sat 10 Jan 2009, 19:02:24 '' ' 0- 0- 0'
841 Sat 10 Jan 2009, 22:16:08 '' ' 0- 0- 0'
842 Sun 11 Jan 2009, 15:57:54 '' ' 0- 0- 0'
843 Sun 11 Jan 2009, 20:03:17 '' ' 0- 0- 0'
844 Mon 12 Jan 2009, 18:29:01 '' ' 0- 0- 0'
845 Mon 12 Jan 2009, 21:08:23 '' ' 0- 0- 0'
846 Tue 13 Jan 2009, 13:01:47 '' ' 0- 0- 0'
847 Tue 13 Jan 2009, 23:01:24 '' ' 0- 0- 0'
You shouldn't have the problem anymore... just to be certain... go ahead and replace the test block with the first one I gave you:
Code: Select all
case "testbdays":
//lets output the current user/birthday data...
$sql = 'SELECT * FROM ' . USERS_TABLE . "
ORDER BY user_id ASC";
$result = $db->sql_query($sql);
echo "<table border='1' cellpadding='3'><tr><td>user_id</td><td>joined on</td><td>birthday</td></tr>\n";
while ($row = $db->sql_fetchrow($result))
{
echo "<tr>\n";
echo "<td>" .$row['user_id']. "</td>\n";
echo "<td>" .$user->format_date($row['user_regdate']). "</td>\n";
echo "<td>'" .$row['user_birthday']. "'</td>\n";
echo "</tr>\n";
}
echo "</table>\n";
$db->sql_freeresult($result);
// display the entire month
$template_body = "calendar.html";
break;
That way we can validate that all of the dates now have the leading space as expected.
Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 16:32:26
by marian0810
Our PMs just crossed New and improved file is now in place.
Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 16:29:05
by marian0810
This is it. And I've now uploaded yesterday's backup again.
Code: Select all
<?php
/**
*
* @author alightner
alightner@hotmail.com
* @author SpaceDoG
spacedog@hypermutt.com
*
* @package phpBB Calendar
* @version CVS/SVN: $Id: $
* @copyright (c) 2008 alightner
* @license
http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
/**
* @ignore
*/
define('IN_PHPBB', true); // we tell the page that it is going to be using phpBB, this is important.
$phpbb_root_path = './'; // See phpbb_root_path documentation
$phpEx = substr(strrchr(__FILE__, '.'), 1); // Set the File extension for page-wide usage.
include($phpbb_root_path . 'common.' . $phpEx); // include the common.php file, this is important, especially for database connects.
include($phpbb_root_path . 'includes/functions_calendar.' . $phpEx); // contains the functions that "do the work".
// Start session management -- This will begin the session for the user browsing this page.
$user->session_begin();
$auth->acl($user->data);
// Language file (see documentation related to language files)
$user->setup('calendar');
// Is the user able to view ANY events?
if ( !$auth->acl_get('u_calendar_view_events') )
{
trigger_error( 'NO_AUTH_OPERATION' );
}
/**
* All of your coding will be here, setting up vars, database selects, inserts, etc...
*/
$view_mode = request_var('view', 'month');
switch( $view_mode )
{
case "next":
// display next events for specified number of days
$template_body = "calendar_next_events.html";
$daycount = request_var('daycount', 90 );
display_next_events_for_x_days( $daycount );
break;
case "event":
// display a single event
$template_body = "calendar_view_event.html";
calendar_display_event();
break;
case "day":
// display all of the events on this day
$template_body = "calendar_view_day.html";
calendar_display_day();
break;
case "week":
// display the entire week
// viewing the week is a lot like viewing the month...
$template_body = "calendar.html";
calendar_display_week( 0 );
break;
case "month":
// display the entire month
$template_body = "calendar.html";
calendar_display_month();
break;
case "testbdays":
//lets output the current user/birthday data...
$sql = 'SELECT * FROM ' . USERS_TABLE . "
ORDER BY user_id ASC";
$result = $db->sql_query($sql);
echo "<table border='1' cellpadding='3'><tr><td>user_id</td><td>joined on</td><td>birthday</td><td>reformatted</td></tr>\n";
while ($row = $db->sql_fetchrow($result))
{
list($bday['day'], $bday['month'], $bday['year']) = explode('-', $row['user_birthday']);
$correct_bday = sprintf('%2d-%2d-%4d', $bday['day'], $bday['month'], $bday['year']);
if( 0 != strcmp( $row['user_birthday'], $correct_bday )
{
echo "<tr>\n";
echo "<td>" .$row['user_id']. "</td>\n";
echo "<td>" .$user->format_date($row['user_regdate']). "</td>\n";
echo "<td>'" .$row['user_birthday']. "'</td>\n";
echo "<td>'" .$correct_bday. "'</td>\n";
echo "</tr>\n";
$sql = 'UPDATE ' . USERS_TABLE . '
SET ' . $db->sql_build_array('UPDATE', array(
'user_birthday' => $correct_bday )) . "
WHERE user_id = ".$row['user_id'];
$db->sql_query($sql);
}
}
echo "</table>\n";
$db->sql_freeresult($result);
// display the entire month
$template_body = "calendar.html";
break;
}
// Output the page
page_header($user->lang['PAGE_TITLE']); // Page title, this language variable should be defined in the language file you setup at the top of this page.
// Set the filename of the template you want to use for this file.
$template->set_filenames(array(
'body' => $template_body) // template file name -- See Templates Documentation
);
// Finish the script, display the page
make_jumpbox(append_sid("{$phpbb_root_path}viewforum.$phpEx"));
page_footer();
?>
Quote alightner Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 16:28:47
by alightner
I found the bug I was missing a closing parenthesis
Find:
Code: Select all
if( 0 != strcmp( $row['user_birthday'], $correct_bday )
replace with
Code: Select all
if( 0 != strcmp( $row['user_birthday'], $correct_bday ))
Quote alightner Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 16:21:38
by alightner
That's strange if you go to the calendar page:
http://www.atkinsforum.info/forum/calendar.php
It's all white (not even when you execute my test changes) just when you try to go to the main calendar page.
Can you please copy all of the code in your current calendar.php file and paste it into a pm between [ code ] markers.
Then try removing that block and upload it again to fix the main calendar issue.
Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 16:16:40
by marian0810
Okay it's ready again. I replaced the code and didn't touch anything else.
Quote alightner Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 16:07:33
by alightner
OK - I *think* this will work, but I can't test it for 2 reasons - 1) I'm at work again, 2) my forum doesn't have dates with the old format, so it would never make it into the if statement.
Remove the old testbdays section of code I had you ad earlier and replace it with this:
Code: Select all
case "testbdays":
//lets output the current user/birthday data...
$sql = 'SELECT * FROM ' . USERS_TABLE . "
ORDER BY user_id ASC";
$result = $db->sql_query($sql);
echo "<table border='1' cellpadding='3'><tr><td>user_id</td><td>joined on</td><td>birthday</td><td>reformatted</td></tr>\n";
while ($row = $db->sql_fetchrow($result))
{
list($bday['day'], $bday['month'], $bday['year']) = explode('-', $row['user_birthday']);
$correct_bday = sprintf('%2d-%2d-%4d', $bday['day'], $bday['month'], $bday['year']);
if( 0 != strcmp( $row['user_birthday'], $correct_bday )
{
echo "<tr>\n";
echo "<td>" .$row['user_id']. "</td>\n";
echo "<td>" .$user->format_date($row['user_regdate']). "</td>\n";
echo "<td>'" .$row['user_birthday']. "'</td>\n";
echo "<td>'" .$correct_bday. "'</td>\n";
echo "</tr>\n";
$sql = 'UPDATE ' . USERS_TABLE . '
SET ' . $db->sql_build_array('UPDATE', array(
'user_birthday' => $correct_bday )) . "
WHERE user_id = ".$row['user_id'];
$db->sql_query($sql);
}
}
echo "</table>\n";
$db->sql_freeresult($result);
// display the entire month
$template_body = "calendar.html";
break;
Don't run the test yourself... just let me know when it's available for me to run - I want to make sure it works properly, and if you run it once, you'll see the output of things it changed, but the next time there's no output (because there's nothing left to convert) and I want to see for myself that it worked before publishing it as a fix for everyone who may have a converted phpbb2->phpbb3 forum.
Thanks!
Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 15:40:58
by marian0810
And the new changes are ready
Quote alightner Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 15:01:37
by alightner
OK - I figured it out... the really old birthdays do NOT have a leading space before the single digit day.
Find in the code I had you add:
Code: Select all
<td>birthday</td>
Add after:
Code: Select all
<td>reformatted</td>
Find:
Code: Select all
echo "<td>'" .$row['user_birthday']. "'</td>\n";
Add after:
Code: Select all
list($bday['day'], $bday['month'], $bday['year']) = explode('-', $row['user_birthday']);
$correct_bday = sprintf('%2d-%2d-%4d', $bday['day'], $bday['month'], $bday['year']);
echo "<td>'" .$correct_bday. "'</td>\n";
This will test my potential conversion code to make sure that it re-formats the dates properly - if that works we'll have to come up with an sql query to update the table with the reformatted date.
Here are some users who were missing the leading space (so you can look at these entries in the table to see if the reformatted date added the whitespace as expected):
26 Wed 28 Mar 2007, 13:56:30 '4- 7-1947'
28 Wed 28 Mar 2007, 13:56:55 '1- 5-1957'
Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 10:55:24
by marian0810
Done. Let me know if you need anything else.
Quote alightner Re: missing birthdays on calendar
Sent: Thu 09 April 2009, 05:40:23
by alightner
Open root/calendar.php
Find:
Code: Select all
case "month":
// display the entire month
$template_body = "calendar.html";
calendar_display_month();
break;
Add After:
Code: Select all
case "testbdays":
//lets output the current user/birthday data...
$sql = 'SELECT * FROM ' . USERS_TABLE . "
ORDER BY user_id ASC";
$result = $db->sql_query($sql);
echo "<table border='1' cellpadding='3'><tr><td>user_id</td><td>joined on</td><td>birthday</td></tr>\n";
while ($row = $db->sql_fetchrow($result))
{
echo "<tr>\n";
echo "<td>" .$row['user_id']. "</td>\n";
echo "<td>" .$user->format_date($row['user_regdate']). "</td>\n";
echo "<td>'" .$row['user_birthday']. "'</td>\n";
echo "</tr>\n";
}
echo "</table>\n";
$db->sql_freeresult($result);
// display the entire month
$template_body = "calendar.html";
break;
Then let me know when it's available for me to test... this will let me read all of the birthdays on your forum with quotes around the dates so I can see if there's any whitespace I didn't see earllier. For now it looks like the new user's birthday shows up just fine... so I'm really thinking it's a problem with the old coverted birthdates.
Re: missing birthdays on calendar
Sent: Wed 08 April 2009, 17:40:30
by marian0810
Ofcourse, I appreciate anything you can do
Quote alightner Re: missing birthdays on calendar
Sent: Wed 08 April 2009, 17:07:44
by alightner
Very strange indeed as I don't see a format change here either... but I really thought that when you translated from old v2 to new v3 there was a difference... either in white spaces or leading zeros. I may right a test php file for you to install on your forum that will output the birthdays with quotation marks around them just incase we weren't picking it up in copying and pasting the output from phpmyadmin. I can't work on this now... I have a day job... I'll have to get back with you when I get home.
Re: missing birthdays on calendar
Sent: Wed 08 April 2009, 16:58:00
by marian0810
This is from the phpbb3_users table in the database.
Some birthdays old users:
Code: Select all
9- 1-1968
1- 1-1957
2- 2-1948
4- 2-1956
8- 4-1969
2- 9-1980
9- 8-1960
22- 2-1971
new users:
Code: Select all
5- 3-1963
9- 9-1964
1- 9-1959
8- 6-1955
5- 9-1969
29- 4-1973
I hope this is what you need. I'll be happy to give you full access if necessary.
Also it seems that all the old users that have a birthday in the first week of march and april (so a day with a single digit) have disappeared from the calendar but in january and february they're still there. I installed the calendar on March 6, so maybe there's a connection?
Re: missing birthdays on calendar
Sent: Wed 08 April 2009, 16:07:43
by marian0810
alightner wrote:
You didn't give me the url to your forum
Sorry, I forgot
http://www.atkinsforum.info/forum
It's in my profile too.
I'm going to look for that info in the database now.
Quote alightner Re: missing birthdays on calendar
Sent: Wed 08 April 2009, 16:00:24
by alightner
You didn't give me the url to your forum
Also can you go into phpmyadmin and find some of your oldest users with january - september birthdates (or any birthday with a single digit month and/or day). Then copy the birthdates exactly and paste them into a pm or post between [ code ] markers so I can see the spacing. Then do the same thing with some newer user's birthday's (and let me know which are new and which are old member dates). If I can figure out if one version had a leading 0, whitespace, or nothing, I may be able to figure out the difference between the old and new format. Then if we know the difference in formatting, I can either write a fix for the mod, or supply an sql query that you can run to cleanup the database (ie convert all old formatted dates to new formatted dates - so it fixes the birthday list too - not just the calendar mod).
Re: missing birthdays on calendar
Sent: Wed 08 April 2009, 15:03:25
by marian0810
If you want to check my calendar you can login with username: *** and password: *** The testaccount now has a birthday coming up tomorrow.
Thanks!
