vb.org Archive - Calendar Search and Comments for Events

Page 3 of 13

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Calendar Search and Comments for Events (https://vborg.vbsupport.ru/showthread.php?t=78210)

Lionel

03-17-2005 01:57 PM

I placed the search in the navbar under a drop down for calendar as a link. It would be nice to be able to use with vbaCMS. The old module does not recognize the events id

Leeper

03-17-2005 02:54 PM

hit a snag. My signature block comes up as code. Any ideas? Link

ChurchMedia

03-18-2005 02:54 AM

A couple of problems I'm having:

The avatar link is broken
The drop-down on the user name has some weird code in it
The signature is not recognizing line breaks
When trying to delete a comment I get:

Quote:

Invalid SQL: UPDATE event SET totalcom = totalcom - 1,lastevecomdateline= WHERE eventid=94
mysql error: You have an error in your SQL syntax near 'WHERE eventid=94' at line 1

mysql error number: 1064

Here is an example:
http://www.churchmedia.net/community...-4-19&e=94&c=4

deathemperor

03-18-2005 04:13 AM

Here the fix for the error when trying to delete comments:

in calendar.php find:

PHP Code:


		
			
$DB_site->query("DELETE FROM " . TABLE_PREFIX . "eventcomments WHERE evecomid=$id");

            

            $lastevecom = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "eventcomments ORDER BY evecomdateline DESC LIMIT 1");

            $DB_site->query("UPDATE " . TABLE_PREFIX . "event SET totalcom = totalcom - 1,lastevecomdateline=$lastevecom[evecomdateline] WHERE eventid=$e");

REPLACE IT WITH:

PHP Code:


		
			
$DB_site->query("DELETE FROM " . TABLE_PREFIX . "eventcomments WHERE 



evecomid=$id");

            

            $lastevecom = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX 



. "eventcomments ORDER BY evecomdateline DESC LIMIT 1");

            $lastevequery = '';

            if(is_array($lastevecom) && !empty($lastevecom[evecomdateline]))

            {

                



$lastevequery=",lastevecomdateline=$lastevecom[evecomdateline]";

            }

            $DB_site->query("UPDATE " . TABLE_PREFIX . "event SET totalcom = 



totalcom - 1 $lastevequery WHERE eventid=$e");

let me know if it works, I am currently away from my PC so I can't do any deep fix. I'll fix the signature problem soon.

Thanks everyone very much for your kind words.

Lionel

03-18-2005 04:38 AM

Am I missing something? Do I need to apply that fix? I am able to delete comments, events no problems, so I am not sure if I should do it or not....

Lee Wilde

03-18-2005 04:53 AM

If it aint broke, don't fix it Lionel ;-)

We have all customised our forums in different ways, so we may experience different problems. So far the only problem I've seen on mine is the signature not displaying correctly, but deathemperor will provide a fix for that soon I'm sure.

deathemperor

03-18-2005 11:55 AM

Quote:

Originally Posted by Lionel

Am I missing something? Do I need to apply that fix? I am able to delete comments, events no problems, so I am not sure if I should do it or not....

that problem occurs when you have only one comment in an event, So I recommend anyone who installed this hack apply the fix.

SIGNATURE FIX: in calendar.php FIND:

PHP Code:


		
			
$eventcomment['evecombody'] = fetch_censored_text($eventcomment['evecombody']);

ADD BELOW (actually it's possible to add above ^^):

PHP Code:


		
			
$eventcomment['signature'] = parse_bbcode($eventcomment['signature'], 0, 1);

zip updated.

Lionel

03-18-2005 06:54 PM

I did not have the delete problem under the conditions that you said. I updated and I got

Quote:

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE event SET totalcom =

totalcom - 1 ,lastevecomdateline=$lastevecom[evecomdateline] WHERE eventid=42
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '[evecomdateline] WHERE eventid=42' at line 3

mysql error number: 1064

So I reverted and all is fine.

mysql database 4.03

deathemperor

03-19-2005 12:22 AM

I'm sorry, to fix that: find:

PHP Code:


		
			
$lastevequery=',lastevecomdateline=$lastevecom[evecomdateline]';

replace with:

PHP Code:


		
			
$lastevequery=",lastevecomdateline=$lastevecom[evecomdateline]";

updated fix post above.

Lionel

03-19-2005 01:57 AM

that works, thanks.

All times are GMT. The time now is 11:27 AM.

Page 3 of 13

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01181 seconds Memory Usage 1,757KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: