vb.org Archive

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)

snyx 03-24-2005 04:37 AM

This has been a long awaited hack my site has been dyerly needing. I have since controlled my event posting via a fourm, so I have many threads spanning now until mid year. some with pages of posts. what I need is an importer where I could fill in the details and a thread location and it would then port them into this system. is that a large job? it would be fantastic, im willing to exchange graphic work for such an importer.

Thanks ether way, love the calendar mods :)
also, I have some possible write work for you too deathemperor. a special profiles section, but first I need to impliment this.

deathemperor 03-24-2005 12:29 PM

an importer like you want is really complex, beside I've never done something like that, it would take alot of time.

Glad to hear you love it.

VB-Fanatiker 03-24-2005 11:23 PM

*vB-Fanatiker klicks install*

Great hack, thanks deathemperor !

Why this hack search only in the event titles and comments but not in the event details?
And is it possible to change this hack to search in new calendercustomfields else?

P.S.: Sorry for my bad schoolenglish, I'm german.

deathemperor 03-25-2005 02:55 AM

the search was supposed to be simple, it can be improved however.

what do you mean by calendercustomfields ?

remember that search function is one of the most simple things so to add this and that isn't hard.

YLP1 03-25-2005 03:26 AM

I am recieving the following error when trying to search:

Quote:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT *
FROM vb3_event
WHERE event.title LIKE '%christmas%'

mysql error: Unknown table 'event' in where clause

mysql error number: 1109

Date: Thursday 24th of March 2005 11:30:55 PM
Script: http://www.yourlincolnpark.com/LPSFo...er=after&pp=10
Referer: http://www.yourlincolnpark.com/LPSFo....php?do=search
Username: Me
IP Address: myIP
How can I fix this? Any help is greatly appreciated.

VB-Fanatiker 03-25-2005 04:25 AM

Quote:

Originally Posted by deathemperor
the search was supposed to be simple, it can be improved however.

what do you mean by calendercustomfields ?

remember that search function is one of the most simple things so to add this and that isn't hard.

Thank you for your fast reply. :squareeyed:
I mean that the search also must be done in the event details. Do you know, how can we make this?

The "calendercustomfields" can be created in the ACP of the calendar. It's a very cool function for arrange the entrys. ;)

YLP1 03-25-2005 04:23 PM

Quote:

am recieving the following error when trying to search:


Quote:
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT *
FROM vb3_event
WHERE event.title LIKE '%christmas%'

mysql error: Unknown table 'event' in where clause

mysql error number: 1109

Date: Thursday 24th of March 2005 11:30:55 PM
Script: http://www.yourlincolnpark.com/LPSF...ter=after&pp=10
Referer: http://www.yourlincolnpark.com/LPSF...r.php?do=search
Username: Me
IP Address: myIP

How can I fix this? Any help is greatly appreciated.
Quote:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT *
FROM vb3_eventcomments
WHERE eventcomments.evecomtitle LIKE '%council%'

mysql error: Unknown table 'eventcomments' in where clause

mysql error number: 1109

Date: Friday 25th of March 2005 01:24:55 PM
Script: http://www.yourlincolnpark.com/LPSFo...er=after&pp=10
Referer: calendar.php?do=search
I have been trying to fix this but I don't know much about PHP...I did figure out that this error is similar to any type of search by Title, comments, etc.

Please advise on how I can fix this. Thanks in advance.

VB-Fanatiker 03-25-2005 07:47 PM

Quote:

Originally Posted by YLP1
I have been trying to fix this but I don't know much about PHP...I did figure out that this error is similar to any type of search by Title, comments, etc.

Please advise on how I can fix this. Thanks in advance.

There are missing tables in the database. Have you done the changes at the end of this hack?
Quote:

upload evecom_install.php to you Admincp folder and run it
etc.

YLP1 03-25-2005 08:53 PM

Quote:

Originally Posted by VB-Fanatiker
There are missing tables in the database. Have you done the changes at the end of this hack?

etc.

Yeppers I ran the install.....I ran it again just to be sure and this is the error I received:


Quote:

Database error in vBulletin 3.0.7:

Invalid SQL:
CREATE TABLE `vb3_eventcomments` (
`evecomid` int(10) unsigned NOT NULL auto_increment,
`evecomiconid` int(10) unsigned NOT NULL default '0',
`eventid` int(10) unsigned NOT NULL default '0',
`evecomtitle` varchar(250) default NULL,
`evecombody` longtext NOT NULL,
`evecomdateline` int(10) unsigned NOT NULL default '0',
`evecomusername` varchar(250) NOT NULL default '',
`evecomuserid` int(10) unsigned NOT NULL default '0',
`evecomhash` varchar(32) NOT NULL default '',
`valid` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`evecomid`)
) TYPE=MyISAM

mysql error: Table 'vb3_eventcomments' already exists

mysql error number: 1050

Date: Friday 25th of March 2005 05:53:48 PM
Script: ***admin/evecom_install.php
Referer: ***/evecom_install.php
Username: Robin
IP Address:
Looks like these were already created. What else could be causing the errors?

Thanks in advance.

Edited to add: I confirmed that I have the tables of
vb3_event
- allowsmilies
- calendarid
- customfields
- dateline
- dateline_from
- dateline_to
- event
- eventid
- lastevecomdateline
- recuroption
- recurring
- title
- totalcom
- userid
- utc
- visible


and vb3_eventcomments has these:
- evecombody
- evecomdateline
- evecomhash
- evecomiconid
- evecomid
- evecomtitle
- evecomuserid
- evecomusername
- eventid
- valid

I also uninstalled and reinstalled and went over the instruction three times yet everything works except the search of title, dates, comments, etc.

YLP1 03-26-2005 10:41 AM

I am sorry to be a pest and such a newbie at coding but I have researched the error code and studied up on the coding to see if I could fix it alas...I can't figure out and I am getting errors on all the search functions of this mod and really need guidance on how to fix this.


All times are GMT. The time now is 05:57 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01212 seconds
  • Memory Usage 1,751KB
  • 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_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