Welcome, Guest. Please login or register.
March 19, 2010, 03:37:27 AM

Login with username, password and session length
Search:     Advanced search
WB 2.8.1 veröffentlicht!
Download und weitere Informationen gibt es hier .
110410 Posts in 15941 Topics by 9294 Members
Latest Member: papirex
* Home Help Search Login Register
+  WebsiteBaker Community Forum
|-+  English
| |-+  Archive (posts up to 2007) (Moderators: Argos, BerndJM)
| | |-+  New Event Calendar v1.21b up to V1.3
Pages: 1 [2] 3 4 ... 7 Go Down Print
Author Topic: New Event Calendar v1.21b up to V1.3  (Read 39303 times)
Stefan
Guest
« Reply #25 on: August 11, 2005, 12:42:00 PM »
Wouldn't it be much easier to run the install.php script under modules/pickle manually?
Logged
i2Paq

Offline Offline

Posts: 500


Tempelier, on bare feet!


WWW
« Reply #26 on: August 11, 2005, 05:00:30 PM »
Quote from: Stefan on August 11, 2005, 12:42:00 PM
Wouldn't it be much easier to run the install.php script under modules/pickle manually?

You mean modules/event? And how should I do that, It gives al kinds of errors.

btw. everything seems to be working ok now, even the search
« Last Edit: August 11, 2005, 05:07:04 PM by i2Paq » Logged
Opensource is my life,  osCommerce and PrestaShop..
Stefan
Guest
« Reply #27 on: August 11, 2005, 05:36:07 PM »
Yes, event, that's what I meant  smiley
After copying all the files manually if suffices to have the php script do the database actions. There is no safe-mode issue with this and I have tried it once with a couple of modules. However, if the install.php script creates files or folders, you would get errors. Strip everything out except database related stuff.

But what I forgot to mention: if you don't want to take out its security feature (that not just any visitor can execute it) you need to call it out of WB directly, i.e. create a code section with a call to the script (include(WB_PATH.'/modules/event/install.php)Wink.
« Last Edit: August 11, 2005, 05:38:58 PM by Stefan » Logged
mightofnight

Offline Offline

Posts: 153
« Reply #28 on: August 11, 2005, 08:08:04 PM »
"   settings                5   MyISAM    latin1_swedish_ci      2.2 KB      -"

the latin1_sweedish_ci is something only to newer versions of SQL (i belive 4) they allow language specific stuff.. and when trying to input suhc a newer sql feature in an older version it just doens't work cause it's gets hung up on all thelanguage syntex....

how to solve..

using phpmyadmin go to export and you will find this option SQL export compatibility, it's a combo box.... select mysql 323...

note this won't help the person trying to insall the mod but will help the person making the modde to make the queries mysql 3 compatiable Wink
« Last Edit: August 11, 2005, 08:09:48 PM by mightofnight » Logged
-Travis
phil

Offline Offline

Posts: 62
« Reply #29 on: August 30, 2005, 11:08:53 PM »
I've found an problem in the Calendar Module.

If you look at the HTML Code a calendar page produces you can see that there are 2 <head> and 2 <body> elements.
In the display code of a module neither <body> nor <head> tags are allowed. The display code of a module is included into the <body> tag
Logged
ruebenwurzel
Leaders Team
*****
Offline Offline

Posts: 7211


Keep on Rockin


WWW
« Reply #30 on: September 10, 2005, 12:28:25 AM »
There is a little update for the event-calender. Please read here.
Logged
You search for help, please look here: Help-Page
You search for Modules, Templates or Languages, please look here: Addons-Page
Bennie_wijs

Offline Offline

Posts: 230


I believe what I want to Believe.


WWW
« Reply #31 on: September 12, 2005, 03:20:31 PM »
Quote from: phil on August 30, 2005, 11:08:53 PM
I've found an problem in the Calendar Module.

If you look at the HTML Code a calendar page produces you can see that there are 2 <head> and 2 <body> elements.
In the display code of a module neither <body> nor <head> tags are allowed. The display code of a module is included into the <body> tag
I have removed the 2 <head> and <body> tags.

Quote from: ruebenwurzel on September 10, 2005, 12:28:25 AM
There is a little update for the event-calender. Please read here.
Added this update to the zip in the Completed Modules list.
Logged
I believe what I want to Believe
timur

Offline Offline

Posts: 1
« Reply #32 on: September 14, 2005, 06:20:06 PM »
Does anyone have a piece of code to show events for the next week rather than the next month ??

Sorry, am not a php programmer, but like the calendar and want to use it  grin

Many thanks.

Timur
Logged
Bennie_wijs

Offline Offline

Posts: 230


I believe what I want to Believe.


WWW
« Reply #33 on: September 24, 2005, 06:39:21 PM »
This code displays the next 5 days.

You can make a section page and select module code and past this in.
Only have 1 problem. inside the code I give up the page and section id of the event page to get the data. Do not know how to get this info a other way.

You can properly paste this code inside your template ( have not tested that ) aswell

Code:
$page_id = 8;
$section_id= 8;
require(WB_PATH.'/modules/event/language.php');

$query_content = $database->query("SELECT * FROM
".TABLE_PREFIX."mod_event_settings WHERE section_id = '$section_id'");

if($query_content->numRows() > 0) {
$fetch_content = $query_content->fetchRow();
$date_view = $fetch_content['date_view'];
}

$today = date("Y-m-j");
$month = date("m");
$day = date("j");
$year = date("Y");
$theday = mktime (0,0,0,$month ,$day+6 ,$year);
$lastday=date("Y-m-d",$theday);

echo "<center>";
echo " ----- Listing Next 5 days of Events + Events Today ----- <BR>";
$query_dates = $database->query("SELECT * FROM
`".TABLE_PREFIX."mod_event_dates` WHERE section_id = '$section_id' && date
>= '$today' && date < '$lastday' order by date");

while($result = $query_dates->fetchRow()) {
  $alt2date=$result['date'];
  if ($date_view == 1 ) {
    list($a2year, $a2month, $a2day) = split('[/.-]', $alt2date);
    $altdate=$a2day."-".$a2month."-".$a2year;
  } elseif ($date_view == 2 ) {
    list($a2year, $a2month, $a2day) = split('[/.-]', $alt2date);
    $altdate=$a2month."-".$a2day."-".$a2year;
  } else { $altdate=$alt2date; }

   echo $altdate." Event: ".$result['event_desc']."<BR>";
}
echo "</center>";
Logged
I believe what I want to Believe
i2Paq

Offline Offline

Posts: 500


Tempelier, on bare feet!


WWW
« Reply #34 on: October 24, 2005, 04:54:33 PM »
Bennie_wijs,

because I'm updating my test-site's and therfore starting to use the modules to see how the work I find something anoying in the Event Calendar.
In the setting you can

Display today's event
Display all event's

The problem I have with this is that it not only display's upcomming events but also events in the past. Furthermore when I actualy only want to display the today's event's and the events for this mont, not for next month or next year.

Is this something for an update?  wink

Thanks!
Logged
Opensource is my life,  osCommerce and PrestaShop..
Bennie_wijs

Offline Offline

Posts: 230


I believe what I want to Believe.


WWW
« Reply #35 on: October 24, 2005, 05:02:50 PM »
Well, the problem is simple.

The option Display all events I made for debuging not for standard showing.
(It just dumps all the events that are there in the database)

But people wanted it to stay in the module so I let it in.

But is you only want to display Today and this month. turn Display all events off.
« Last Edit: October 24, 2005, 05:06:22 PM by Bennie_wijs » Logged
I believe what I want to Believe
i2Paq

Offline Offline

Posts: 500


Tempelier, on bare feet!


WWW
« Reply #36 on: October 24, 2005, 05:10:55 PM »
Quote from: Bennie_wijs on October 24, 2005, 05:02:50 PM
Well, the problem is simple.

The option Display all events I made for debuging not for standard showing.
(It just dumps all the events that are there in the database)

But people wanted it to stay in the module so I let it in.

But is you only want to display Today and this month. turn Display all events off.


OK, duidelijk  grin
Logged
Opensource is my life,  osCommerce and PrestaShop..
Woudloper
Guest
« Reply #37 on: October 25, 2005, 11:16:20 PM »
I think I found the problem (which has mentioned somewhere else on the forum) regarding the search errors.

It seems to be it has to do with the 'event' module. As you can see in the 'install.php' file the following is used for the query body:

Quote
   $query_body_code = " [TP]pages.page_id = [TP]mod_event_settings. page_id AND [TP]mod_event_settings. galtitle
  • \'[W][STRING][W]\' AND [TP]pages.searching = \'1\'
OR [TP]pages.page_id = [TP]mod_event_settings. page_id AND [TP]mod_event_settings. adminname
  • \'[W][STRING][W]\' AND [TP]pages.searching = \'1\'";
When you look at the other section in the 'install.php' (where the tables are being created for this module) you will notice that the galtitle column isn't part of the mod_event_settings table.

If you ask me this will result in a database query error since the column for this table does not exist. Maybe this can be fixed in a new version of the event module?
« Last Edit: October 25, 2005, 11:26:14 PM by Woudloper » Logged
ruebenwurzel
Leaders Team
*****
Offline Offline

Posts: 7211


Keep on Rockin


WWW
« Reply #38 on: October 25, 2005, 11:24:36 PM »
now its clear  grin

.galtitle is a table from pickle gallery. Thats why i thought pickle gallery is the modul with the problems.

try to make an update for the install.php

Thanks
Matthias
Logged
You search for help, please look here: Help-Page
You search for Modules, Templates or Languages, please look here: Addons-Page
Woudloper
Guest
« Reply #39 on: October 25, 2005, 11:31:57 PM »
Quote from: ruebenwurzel on October 25, 2005, 11:24:36 PM
.galtitle is a table from pickle gallery. Thats why i thought pickle gallery is the modul with the problems.

try to make an update for the install.php

I think you mean the 'galtitle is a column for the pickle gallery module wink

Furthermore I think the problem about this lies in the 'Hello World' module since this does not explain the 'query_start', 'query_body' and 'query_end' and as you can see in that module it is using the 'galtitle' in the 'query_body'.
Logged
ruebenwurzel
Leaders Team
*****
Offline Offline

Posts: 7211


Keep on Rockin


WWW
« Reply #40 on: October 26, 2005, 12:46:53 AM »
ok,

here are a few little scripts to easily solve search error problems with the event-calendar. In the attached zip file there are thre scripts. Please unzip and copy the files to modules/event in your WB installation overwrite existing files.

install.php - you only need this for a new install
repair_event_search .php - run this script to repair an existing event-calendar installation
delete_event_search .php - this script deletes all entries from event-calendar modul in search table.

Hope all works, haven't tested it much

Matthias

[attachment deleted because of being too old]
« Last Edit: October 28, 2005, 03:57:08 PM by ruebenwurzel » Logged
You search for help, please look here: Help-Page
You search for Modules, Templates or Languages, please look here: Addons-Page
Hans

Offline Offline

Posts: 498
« Reply #41 on: October 26, 2005, 01:37:08 PM »
Hi Matthias, thank you. Will these and the ones for Pickle (your other post today) be added to the modules in Completed Modules?
Hans
Logged
Hans - Nijmegen - The Netherlands
ruebenwurzel
Leaders Team
*****
Offline Offline

Posts: 7211


Keep on Rockin


WWW
« Reply #42 on: October 26, 2005, 02:34:41 PM »
Hello Hans,

I sent a PM to Bennie_wijs, hope he have a look at the module code from Pickle and Event Calendar and if the changes are ok i hope he added them to completed Modules.

Matthias
Logged
You search for help, please look here: Help-Page
You search for Modules, Templates or Languages, please look here: Addons-Page
i2Paq

Offline Offline

Posts: 500


Tempelier, on bare feet!


WWW
« Reply #43 on: October 26, 2005, 10:05:24 PM »
After running the repair the error is still there.
Logged
Opensource is my life,  osCommerce and PrestaShop..
Woudloper
Guest
« Reply #44 on: October 26, 2005, 11:44:39 PM »
Quote from: i2Paq on October 26, 2005, 10:05:24 PM
After running the repair the error is still there.

Since your problem now is still related to the other thread (in the help) I have posted some comment over there...
Logged
Woudloper
Guest
« Reply #45 on: October 28, 2005, 09:21:48 AM »
Quote from: ruebenwurzel on October 26, 2005, 12:46:53 AM
install.php - you only need this for a new install

Are you sure this newly 'install.php' is correct? When I view the source I see the following which might cause the problem i2Paq is having with the 'search'. As you can see the following is shown in the 'search_body' for the event module:

Quote
[TP]pages.page_id = [TP]mod_event_settings. page_id AND [TP]mod_event_dates.date
  • \'[W][STRING][W]\' AND [TP]pages.searching = \'1\' OR
In the above line you make it possible to search for the 'date' column, but when you are searching you are searching with a string. Shouldn't the 'search_body' only contain VARCHAR fields and TEXT fields?
Logged
ruebenwurzel
Leaders Team
*****
Offline Offline

Posts: 7211


Keep on Rockin


WWW
« Reply #46 on: October 28, 2005, 11:23:14 AM »
ooops,

seems that i have had tested it a little bit more. Try it later when I'm at home. And if this causes the error, i change the scripts.

Thanks for this tip

Matthias
Logged
You search for help, please look here: Help-Page
You search for Modules, Templates or Languages, please look here: Addons-Page
Bennie_wijs

Offline Offline

Posts: 230


I believe what I want to Believe.


WWW
« Reply #47 on: October 28, 2005, 12:31:48 PM »
ruebenwurzel,

I will wait till you are done testing before updating the module  grin
Logged
I believe what I want to Believe
ruebenwurzel
Leaders Team
*****
Offline Offline

Posts: 7211


Keep on Rockin


WWW
« Reply #48 on: October 28, 2005, 04:06:20 PM »
This is curious,

after playing a little bit around with the search from event-calendar i found the solution. Search in Eventcalendar should now work if you uses the files from here.

@Bennie Wijs
I found a earlier version of the install.php from you where the search entries are 100% ok. In the aktually Version you can download at completed modules seems to be an older version of install.php. So could you please have a look to all files from Event Calendar (Maybe there ar some other older files, because i have problems do edit events) and then please upload an actually Version at Completed Modules.

Matthias
Logged
You search for help, please look here: Help-Page
You search for Modules, Templates or Languages, please look here: Addons-Page
Bennie_wijs

Offline Offline

Posts: 230


I believe what I want to Believe.


WWW
« Reply #49 on: October 31, 2005, 02:53:28 PM »
Quote from: ruebenwurzel on October 28, 2005, 04:06:20 PM
@Bennie Wijs
I found a earlier version of the install.php from you where the search entries are 100% ok. In the aktually Version you can download at completed modules seems to be an older version of install.php. So could you please have a look to all files from Event Calendar (Maybe there ar some other older files, because i have problems do edit events) and then please upload an actually Version at Completed Modules.

Matthias

Oke, I will.
Logged
I believe what I want to Believe
Pages: 1 [2] 3 4 ... 7 Go Up Print 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Impressum & Datenschutz | powered by WebsiteBaker. ©2004–2010 by Website Baker Org e.V. , all rights reserved | Legal Notice & Privacy Policy