vb.org Archive - Calendar Search and Comments for Events

Page 3 of 4

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)

KTBleeding

04-19-2005 12:06 AM

Quote:

Originally Posted by VB-Fanatiker

No.
I need this feature also!!! :rolleyes:

Bummer. That would save me a BUNCH of hassle.

deathemperor

04-19-2005 02:24 AM

Sorry guys I've been busy with my Java eProjects. I'll make an upgrade for those feature whenever I have time.

thanks for your concern.

KTBleeding

04-19-2005 07:07 AM

Sounds good to me. I've clicked install so I can keep updated.

Lionel

05-04-2005 07:20 AM

Wonder if this can be made to use Geek's Autolink hack?

deta	05-10-2005 12:46 PM

Quote:

Originally Posted by Lee Wilde

Here are 2 screenshots.

1. event_with_quickreply_enabled.jpg
Users are used to seeing the quick reply box in the forums, so to see under an event seems natural.

2. event_with_reply_added.jpg
Once someone has replied to the event, it begins to look like a forum thread!

I will add a screenshot of the calendar search page shortly.

Hello Lee,

how did you clean-bring there the fields to
Nearest Capital City:
Location:
Website:
Cost:
Parking:
Dress Code
Contact Name and Phone:
..?

Which chop is that?

Thanks

cu Deta

VB-Fanatiker

05-12-2005 12:39 PM

Quote:

Originally Posted by KTBleeding

Will this hack search custom calendar field content?

Past another month. Nobody can do this? :alien:

deathemperor

05-12-2005 03:09 PM

I'm still coding my EJB project, 18 is my deadline, from there I'll be making hacks again.

please spare me.

VB-Fanatiker

05-13-2005 12:33 AM

Ok, I think I figured it out..... You have to change the following:

find in calendar.php

Code:

                                $searchfor_query = "event.title LIKE '%$keyword%'";

//                                $searchfor_subquery = "OR event.event LIKE '%$keyword%'";

                                $searchin = "event";

and change it to:

Code:

                                $searchfor_query = "event.title LIKE '%$keyword%'";

                                $searchfor_subquery = "OR event.event LIKE '%$keyword%'";

                                $searchfor_subquery = "OR event.customfields LIKE '%$keyword%'";

                                $searchin = "event";

Thats it (for me). Now it is searchable in the event content field and also in the customfields. :)

deathemperor

05-13-2005 02:35 AM

if it does work, then you should change:

$searchfor_subquery = "OR event.customfields LIKE '%$keyword%'";

to

$searchfor_subquery .= "OR event.customfields LIKE '%$keyword%'";

or this line:

$searchfor_subquery = "OR event.event LIKE '%$keyword%'";

will mean nothing

deta	05-13-2005 03:41 AM

Quote:

Originally Posted by deta

Hello Lee,

how did you clean-bring there the fields to
Nearest Capital City:
Location:
Website:
Cost:
Parking:
Dress Code
Contact Name and Phone:
..?

Which chop is that?

Thanks

cu Deta

Can somebody else say to me, how I get?

cu Deta

YLP1	05-13-2005 04:35 PM

Quote:

Originally Posted by YLP1

I still can't figure out how to fix this unless a hard link is entered but I am not sure where to put that URL to customavatars.

In looking at the code and the size of the Avatar it looks like the normal size avatars are made smaller??!??

I dunno....any help to fix this is greatly appreicated.

Has a fix for this been found?

Thanks in advance.

VB-Fanatiker

05-13-2005 07:07 PM

Quote:

Originally Posted by deta

Can somebody else say to me, how I get?

cu Deta

Customfields can be made without a hack in the ACP -> calendar :nervous:

deta	05-14-2005 12:07 PM

Quote:

Originally Posted by VB-Fanatiker

Customfields can be made without a hack in the ACP -> calendar :nervous:

Thanks :-)

Mattius

05-23-2005 11:16 PM

It seems i cant add a comment if i click on an event directly in the mini calendar (im using vbacmps), but if i click on the month, and display the entire months worth of events and click on one from there - i can add a comment as intended..

Anyone else having this problem or did i do something silly? :)

Check www.gamerscurse.com...to see what i mean

LeeWicKeD

05-25-2005 02:31 PM

did i installed the hack wrong? because when i click GO ADVANCED it does the same like pressing the REPLY button (in quick reply window)... ??

but: very nice hack!

[high]* LeeWicKeD clicks install :)[/high]

SamirDarji

05-26-2005 04:21 AM

Quote:

Originally Posted by Mattius

guests can't see the calendar. :(

LeeWicKeD

05-30-2005 11:41 AM

aren't there any suggestions for my problem? not even from the coder? :(

deathemperor

05-30-2005 12:24 PM

I noticed that problem, will have a fix asap.

LeeWicKeD

06-02-2005 01:55 PM

hiho

two more questions ;)

1. is it possible, to show the new comments for events in NEW POSTS for every user that has the permissions for the calendar?

2. do you need someone to translate your hack into german? i would do this, if could tell me where to find the phrases etc..because there's no XML-file ;)

regards
lee

deathemperor

06-02-2005 02:04 PM

1. I don't know if that's possible.

2. I'll tell you when this hack is fully phrased, even when it is there will be no xml files cuz the phrases will be installed in the database along with vb phrases.

thanks for offering

YLP1	06-03-2005 03:20 AM

Hi everyone,

I get this DB error intermittingly and it has been driving me nuts. I have searched high and low for an answer on correcting this but it still rears it's ugly head Can someone help me fix this issue? Any help is greatly appreciated:

Code:

 Database error in vBulletin 3.0.7:

Invalid SQL: 

SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline

FROM vb3_user AS user

LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = user.avatarid

LEFT JOIN vb3_customavatar AS customavatar ON customavatar.userid = user.userid

WHERE user.userid = 

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 '' at line 5

mysql error number: 1064

And this is what that section of the Calendar.php looks like:

Code:

 

$eventcomments = $DB_site->query("



SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,usertextfield.signature " . iif($vboptions['avatarenabled'], ", customavatar.dateline AS avatardateline") . " FROM " . TABLE_PREFIX . "eventcomments AS eventcomments



LEFT JOIN " . TABLE_PREFIX . "event AS event ON(event.eventid=eventcomments.eventid)



LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid=eventcomments.evecomuserid)



LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid=eventcomments.evecomuserid)



LEFT JOIN " . TABLE_PREFIX . "usertextfield as usertextfield ON(usertextfield.userid=eventcomments.evecomuserid)



" . iif($vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = eventcomments.evecomuserid)") . "



WHERE eventcomments.eventid=$eventid



ORDER BY eventcomments.evecomid ASC



LIMIT $startingfrom, $perpage



");







$evecomrow = $DB_site->num_rows($eventcomments);

Marco van Herwaarden

06-03-2005 04:52 AM

This is not the part of the code that get that error.

YLP1	06-03-2005 05:33 PM

I was taking a stab at it as I am a newbie at PHP.....any ideas?

Marco van Herwaarden

06-03-2005 06:10 PM

The original error message will also tell you in what script and which line the error occured.

YLP1	06-03-2005 06:58 PM

That's part of the problem...this same error occurs on several pages like the index.php, showthread.php and private messenging pages.... I can't isolate it.

deathemperor

06-04-2005 01:40 AM

Quote:

Originally Posted by YLP1

That's part of the problem...this same error occurs on several pages like the index.php, showthread.php and private messenging pages.... I can't isolate it.

which means this error is not from this hack, so I'm sorry I cannot provide you any fix for this

SamirDarji

06-04-2005 07:42 AM

Quote:

Originally Posted by YLP1

Code:

 Database error in vBulletin 3.0.7:

Invalid SQL: 

SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline

FROM vb3_user AS user

LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = user.avatarid

LEFT JOIN vb3_customavatar AS customavatar ON customavatar.userid = user.userid

WHERE user.userid = 

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 '' at line 5

mysql error number: 1064

And this is what that section of the Calendar.php looks like:

Code:

 

$eventcomments = $DB_site->query("



SELECT eventcomments.*, event.lastevecomdateline,user.*,userfield.*,usertextfield.signature " . iif($vboptions['avatarenabled'], ", customavatar.dateline AS avatardateline") . " FROM " . TABLE_PREFIX . "eventcomments AS eventcomments



LEFT JOIN " . TABLE_PREFIX . "event AS event ON(event.eventid=eventcomments.eventid)



LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid=eventcomments.evecomuserid)



LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid=eventcomments.evecomuserid)



LEFT JOIN " . TABLE_PREFIX . "usertextfield as usertextfield ON(usertextfield.userid=eventcomments.evecomuserid)



" . iif($vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = eventcomments.evecomuserid)") . "



WHERE eventcomments.eventid=$eventid



ORDER BY eventcomments.evecomid ASC



LIMIT $startingfrom, $perpage



");







$evecomrow = $DB_site->num_rows($eventcomments);

Well, the error has to do with avatars. Try disabling avatars to see if the error goes away. That's a start in the right direction.

deathemperor

06-04-2005 10:38 AM

nah, that still does nothing to my hack, I never used something like this

PHP Code:


		
			
NOT ISNULL(avatardata)

in it, sorry I can't help you out.

Antivirus

08-07-2005 03:33 AM

Just installed this- it's closest hack i could find that allows us to do what we want to do with tracking events and their feedback from members. I'm going to be playing around with it onn our test boards for next few days and so far everything looks great. [virus clicks install]

I had the following problem, not sure if anyoe else noticed this in one of the templates the install file uploaded...

In the calendar_searchevents template, there was a <table> tag that wasn't closed, it caused an odd column on the right hand side and messed up the footer (only for the Search Events page) so after figuring it out, i just added the closing </table> tag and it's beautiful. I attached screenies for people in case they have the same problem as shown, this would be your fix...

In calendar_searchevents template...

Find:

Code:

                <div style="margin-top:6px">

                <input type="submit" class="button" name="dosearch" value="Search Now" accesskey="s" />

                <input type="reset" class="button" value="Reset Fields" accesskey="r" onclick="window.location=\'calendar.php?do=search\';" />

                </div>

        </td>

</tr>

</table>

</form>

And add below:

Code:

</table>

before and after screenies attached. Thanks again death!
:banana:

bjs144

08-26-2005 10:41 AM

Fantastic Mod, many thanks

ohgenki

08-27-2005 06:18 AM

can we get a 3.5 for this ?

deathemperor

08-27-2005 08:30 AM

Here you are: https://vborg.vbsupport.ru/showthrea...threadid=91066

KrisJacobs

09-08-2005 12:50 AM

I am having a wierd permissions issue.

When I set EveCom permssions as so:

Edit Own Comments = yes
Delete Own Comments = Yes
Edit Others Comments = no
Edit Others Comments = no

People cannot edit their own comments, and they cannot edit others comments.

When you click the Edit link on your own comments, you get the text editor - but when you click the Submit button, you get "do not have permission" page.

When you click the Edit link on others comments, you immediately get the "do not have permissions" page.

if I set EveCom permissions so:

Edit Own Comments = yes
Delete Own Comments = Yes
Edit Others Comments = yes
Edit Others Comments = yes

You can freely click Edit and successfully make edits to your own comments and others comments. You can use the Delete and delete your own comments and others comments.

What is going wrong here? Thanks in advance for any help.

-Kris

deathemperor

09-08-2005 03:17 AM

I think I made possibly some mistake but I am currently away from my computer, I will fix it very soon later.
thanks for your understanding.

KrisJacobs

09-08-2005 12:46 PM

Thank you!

Here is more information about my set up:

Everyone is a member of the Registered Users group, permissions are default on this group and I do not alter them. I have altered them, saved them, then put them back to pretty much "default".

I have 6 secondary groups that I use to control permissions like "can view forum" "can post in this forum" etc. Every user belongs to Registered Users as their Primary Group, and 1 or 2 secondary groups. Only a very small percentage of users belong to 2 secondary groups.

Each of these secondary groups I have manipulated and saved permissions on in troubleshooting this problem as well.

KrisJacobs

09-15-2005 12:14 PM

Any news on this problem Deathemperor?

Thank you!

deathemperor

09-15-2005 03:21 PM

I figured out the problem, please try this:

find in calendar.php:

PHP Code:


		
			
    {//if edit, don't insert new comment

add this below:

PHP Code:


		
			
        $evecom = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "eventcomments WHERE evecomid=$id");

Hope this helps.

KrisJacobs

09-15-2005 03:37 PM

It is fixed, thank you very much!!! :)

harry1951

09-16-2005 11:45 AM

Great hack :-) Just installed it without problems.
Just 1 question. Can this be combined with this, because that is wat I realy want too.
https://vborg.vbsupport.ru/showthread.php?t=63460

deathemperor

09-16-2005 01:36 PM

I didn't try it so I don't know if two hacks are conflict.

All times are GMT. The time now is 08:43 AM.

Page 3 of 4

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01397 seconds Memory Usage 1,841KB 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 (8)bbcode_code_printable (3)bbcode_php_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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: