Giter Club home page Giter Club logo

dizkusmodule's Introduction

Deprecated

This module has been deprecated as part of Zikula 4 slimming diet.

Zikula Dizkus Forums

Dizkus is a discussion forum module for the Zikula Application Framework

Branch 4

Basic forum module. This version requires Zikula Core 1.4.6+ The code is currently under development, but typically is in a functional state. Feel free to test and report issues. thank you.

Current release 4.0.0 This version requires Zikula Core 1.4.3+

Branch 5

Fully featured forum This version requires Zikula Core 1.5.0+ The code is currently under development, but typically is in a functional state. Feel free to test and report issues. thank you.

main

Newest core features This version requires Zikula Core 2.0.0+ The code is currently under development, but typically is in a functional state. Feel free to test and report issues. thank you.

Before you pull:

  1. uninstall and delete the module.
  2. delete your local repo and all the files.
  3. clone the repo into /modules/zikula/dizkus-module

Instalation

Your directory structure should look like so:

  /modules
      /zikula
          /dizkus-module
            /Block
            /Command
            etc...

From zip

1. Extract zip file to modules/zikula.
2. Change directory that contains Dizkus module to dizkus-module
3. Install module in Zikula extensions.

Composer

todo...

Upgrade

Avoid any data loss by creating full backup before upgrade! 

Dizkus version 4.0.0

    UPGRADING from Dizkus 3.1
    You must add to `personal_config.php`:
    `$ZConfig['System']['prefix'] = 'pn';`
    (or whatever your table prefix is from your old installation)
    note that upgrading can take a long time and may require updating your `.htaccess` or `php.ini` file to increase 
    time limits and memory allowed.

Dizkus version > 4.1.0

Upgrade from version 3 is handled using import facility.
Upgrade from version 4 is done normal way.

dizkusmodule's People

Contributors

adriangibanelbtactic avatar ccandreva avatar cmfcmf avatar craigh avatar guite avatar halbrooktech avatar hvorragend avatar jusuff avatar kaik avatar landseer avatar phaidon avatar shefik avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

dizkusmodule's Issues

MailToForum - UTF8-Kodierung für Email-Import

Beim Import von Emails per mailcron.php für die MailToForum?-Funktion wird der Import von Emails bei Umlauten abgebrochen.

Lösung:
in modules/Dizkus/pnincludes/pop3.php

bei Zeile 465 ändern:

$body[$line]=$response;

in

$body[$line]=utf8_encode($response);

multilevel forum

this evolution will offer the admin an option to add a child to a given forum (by specifying his id)

database:

add an id "id_parent" in the pnforum

code

function select all forums with a given id_parent

gui

modification of the pnforum_user_main.html template, add a foreach to display all sub forum

admin part: add a field id_parent when editing/creating a new forum

Topic permission depending on zikula categories

Hello,

It will be great if we can do a permission on topic when a newscomment is using. Actually all topics are swown even if in news module a news isn't show if user is not in correct group.

Ex. : If we write a news for categeory X whixh can be see by users in group Y ==> In module news this works but if we use dizkus hook for news module. In forum all topics are showing instead of news(topic) that a grouo can be seen

Support for WYSIWYG editors

Users have come to expect a good WYSIWYG editor in forums

There are several issues that don't appear to be an issue in any other module. 1) while scribite loads, you cannot submit a topic/comment due to a js conflict of some sort. Disabling the dizkus js loading in the user header template solves this, but the current version of dizkus isn't functional without javascript. 2) often (if not always) the scribite toolbar is messed up, with each button taking a while row.

  • Scribite
  • LuMicuLa

unecessare clear:both

Bug description

dizkus .forabg, #dizkus .forumbg and #dizkus h3.footer_title contain "clear:both" which breaks some layouts.

Fix recommendation

I added

#dizkus .forabg, #dizkus .forumbg, #dizkus h3.footer_title {

    clear: none !important;

}

to my stylesheet and it seems as if "clear:both" isn't needed. Dropping it from Dizkus-styles.css would make it more compatible.

Permissions based on "FormID" not working

Cozi ticket

bug description

When I load the "Permission rules information" I read "Dizkus:: | CategoryID:ForumID:" I assume I can filter forums based on category and forum ids which it seems not working.
version: Zikula 1.2.6, Dizkus 3.1
bug analysis

For example, my permissions rules are:
myGroup | Dizkus:: | ::35 | comment
Users | Dizkus:: | :: | none
Users of myGroup don't have access to forum id n°35.

Whereas:
myGroup | Dizkus:: | 4:: | comment
Users | Dizkus:: | :: | none
Users of myGroup have access to forums of category id n°4
fix recommendation

Would be great to have the permissions granularity based on forums and not only on categories.

Changed 5 months ago by pnFilip

Please consider this ticket as invalid because after checking carefully the correct permission scheme to restrict forum access would be:

myGroup | Dizkus:: | :35: | comment
Users | Dizkus:: | :: | none

Pay attention two the position of the semicolon...

MailToForum - Header is shown in lowercase

Cozi ticket

EN: When you import emails into a mailto forum the subject of the imported mail is always converted to lowercase. Have successfully changed the following:


DE: Beim Import von Emails in ein MailToForum wird der Betreff der importierten Email immer in Kleinbuchstaben umgewandelt.Habe folgendes erfolgreich geändert:


in pnuserapi.php at line 3138:

get subject
$header = strtolower($header);
if (strpos($header, 'subject:') === 0) {
$subject = trim(strip_tags(substr($header, 8)));
}

geändert in:

get subject
$header = strtolower($header);
if (strpos(strtolower($header), 'subject:') === 0) {
$subject = trim(strip_tags(substr($header, 8)));
}

Truncate post text in email notification

bug description

All post text is included in email notification no matter how long it is.
fix recommendation

I tried modifiying the Dizkus template
dizkus_mail_notifyuser.txt in the tag

`````` to something like````
but evidently that's not correct.

A config setting in Dizkus would be ideal, but editing the template is fine with me if something will work.

Moderator option: delete this topic thread in X days

Here's one of my wishlist features:

Moderators typically go through a forum on a "delete binge" and killing old-ish topic threads. That's inefficient.

What I'd like to see is one of two things:

(1) The ability to define that a forum has only X number of posts, and/or the ability to auto-delete threads after X number of days.

and/or

(2) the ability for a moderator to tag a topic thread and flag the entire thread so that it will be deleted in X number of days. This would enable moderators to easily clean up a forum as they are doing their normal reading.

Migrated from http://code.zikula.org/parked/ticket/231

Don't blindly trust X-Forwarded-For

X-Forwarded-For can be easily forged and then we don't know which the real IP was.

Index: pntables.php
===================================================================
--- pntables.php    (Revision 321)
+++ pntables.php    (Arbeitskopie)
@@ -113,7 +113,7 @@
                                                  'forum_id'    => 'I NOTNULL DEFAULT 0',
                                                  'poster_id'   => 'I NOTNULL DEFAULT 1',
                                                  'post_time'   => 'C(20) NOTNULL DEFAULT \'\'',
-                                                 'poster_ip'   => 'C(16) NOTNULL DEFAULT \'\'',
+                                                 'poster_ip'   => 'C(50) NOTNULL DEFAULT \'\'',
                                                  'post_msgid'  => 'C(100) NOTNULL DEFAULT \'\'');
     $pntable['dizkus_posts_column_idx'] = array ('topic_id'   => 'topic_id',
                                                   'forum_id'   => 'forum_id',
Index: pnuserapi.php
===================================================================
--- pnuserapi.php   (Revision 321)
+++ pnuserapi.php   (Arbeitskopie)
@@ -1378,8 +1378,9 @@
         $poster_ip = '127.0.0.1';
     } else {
         // some enviroment for logging ;)
-        $poster_ip = pnServerGetVar('HTTP_X_FORWARDED_FOR');
-        if(empty($poster_ip)){
+        if(pnServerGetVar('HTTP_X_FORWARDED_FOR')) {
+            $poster_ip = pnServerGetVar('REMOTE_ADDR')."/".pnServerGetVar('HTTP_X_FORWARDED_FOR');
+        } else {
             $poster_ip = pnServerGetVar('REMOTE_ADDR');
         }
     }
@@ -1684,7 +1685,7 @@

     // some enviroment for logging ;)
     if (pnServerGetVar('HTTP_X_FORWARDED_FOR')){
-        $poster_ip = pnServerGetVar('HTTP_X_FORWARDED_FOR');
+        $poster_ip = pnServerGetVar('REMOTE_ADDR')."/".pnServerGetVar('HTTP_X_FORWARDED_FOR');
     } else {
         $poster_ip = pnServerGetVar('REMOTE_ADDR');
     }

Delete function

EN: Hi, I run the website for some years with the www.nettour.de pnForum. Many of my users want, they can also delete their postings, if they are out of date. So when the time could be realized would be really great!

Many thanks and best regards, bruno Manyas


DE: hallo, betreibe seit paar jahren die transportmaschine www.nettour.de mit dem pnforum im kern. viele meiner nutzer wünschen sich, dass sie ihre postings auch wieder löschen können, falls sie nicht mehr aktuell sind. also, wenn sich das mal realisieren liesse, waere wirklich spitze!

vielen dank und viele gruesse, bruno manyas

Search impossible when Users have restricted permissions

Cozi ticket

bug description

When my users try to search a term an error is returned:
"Error! 'Dizkus' module returned false in search function 'search'."
I am using Dizkus 3.1
bug analysis

I have found in pnsearch.api the lines:

if (!SecurityUtil::checkPermission('Dizkus::', '::', ACCESS_READ)) {
return false;
}

And I have set restricted group permissions to my users:

GroupX | Dizkus:: | (2|3|4):: | Comment
GroupY ...
All users | Dizkus:: | .* | none

For that reason the Security check return false.
fix recommendation

Until now I had to remove these Security checks in order to use the search functionality.
Is there a way to improve these checks?
In order to use smth like "!SecurityUtil::checkPermission('Dizkus::', $catid.'::'.$forumid, ACCESS_READ"

remove forum moderator setting?

This does not really grant permission, it is only used for listing some users. You can do this in the forum description too.

Wrong language in mails (should be the language of the recipient)

There could be the following scenario:
A user responds to a forum thread and some people (which don't have the same default language) monitor this thread.
Now a mail is sent to those people - but in the language of the user who wrote the reply and not the language of the recipients.

Should be easily reproduceable, I'm willing to test any patch ;)


Sorry, I forgot to mention that I'm using Zikula 1.2.2 if this is relevant.


There is no possibility to determine a users language as there is no data field or attribute for this. If you change/set your language it is stored in a cookie only. I'd like to see this a design flaw in Zikula and will open a ticket for this.

Postponed to a later version until the core supports this ( http://code.zikula.org/core/ticket/2023).

"z_" prefix problem

HI, I´m using the 1.3.1 zikula version. I installed this excellent mod just a few moments, the install work perfect and all admin links work too, but when I´m trying Edit Forum Tree I receive this error (I don´t know how can I explain to you this, sorry if it´s not the appropiatte way):

Error in DBUtil::executeSQL: SELECT dizkus_categories.cat_id AS cat_id, dizkus_categories.cat_title AS cat_title, dizkus_categories.cat_order AS cat_order, dizkus_forums.forum_id AS forum_id, dizkus_forums.forum_name AS forum_name, dizkus_forums.forum_desc AS forum_desc, dizkus_forums.forum_topics AS forum_topics, dizkus_forums.forum_posts AS forum_posts, dizkus_forums.forum_last_post_id AS forum_last_post_id, dizkus_forums.forum_moduleref AS forum_moduleref, dizkus_forums.forum_pntopic AS forum_pntopic, dizkus_topics.topic_title AS topic_title, dizkus_topics.topic_replies AS topic_replies, users.z_uname AS pn_uname, users.z_uid AS pn_uid, dizkus_posts.topic_id AS topic_id, dizkus_posts.post_time AS post_time FROM dizkus_categories LEFT JOIN dizkus_forums ON dizkus_forums.cat_id=dizkus_categories.cat_id AND dizkus_forums.is_subforum=0 LEFT JOIN dizkus_posts ON dizkus_posts.post_id=dizkus_forums.forum_last_post_id LEFT JOIN dizkus_topics ON dizkus_topics.topic_id=dizkus_posts.topic_id LEFT JOIN users ON users.z_uid=dizkus_posts.poster_id ORDER BY dizkus_categories.cat_order, dizkus_forums.forum_order, dizkus_forums.forum_name
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'users.z_uname' in 'field list'

MailToForum - Rule doesn't work

Cozi ticket

EN: In a "MailToForum" forum does not usually defined as earlier in pnForum.
No matter what man enters a keyword to filter (lowercase or uppercase) in the forum administrator.

I am in pnuserapi.php on line 3701 for my purposes, the phrase "DWD" entry it works.


DE: Bei einem "MailToForum"-Forum greift die definierte Regel nicht mehr, wie früher bei pnforum.
Egal was mann als Schlagwort zur Filterung (Kleinschreibung oder Großschreibung) in der Forum-Administration einträgt.

wenn ich in pnuserapi.php bei Zeile 3701 für meine Zwecke das Schlagwort "DWD" eintrage funktioniert es.


if (empty($forumpop3_matchstring?)
(preg_match($forumpop3_matchstring?, $subject) <> 0))

Example for a manual filter:

if (empty($forumpop3_matchstring?)
(preg_match('"DWD"', $subject) <> 0)) {

Original where the rule doesn't work:

if (empty($forum['pop3_matchstring']) || (preg_match($forum['pop3_matchstring'], $subject) <> 0)) {

Manual test working:

if (empty($forum['pop3_matchstring']) || (preg_match('"DWD"', $subject) <> 0)) {

Have thread marked as read after you enter it

If you use Dizkus several times a day, the visible cue you get that somethis is new is with teh red icon "New posts since your last visit" However once you have read the post that remains until you have anew session. On a busy forum its not that easy to pick what you have not read every time you login through the day.

Remove all subscritions, phased email

bug description

This isn't really a bug, it's a problem with huge communities such as mine (over 40.000 registered users).
bug analysis

People subscribe topics and most of the time they don't un-subscribe, the result is a ton of emails being sent and the server going down.
fix recommendation

Include a new option under manage subscriptions "Remove ALL subscriptions - Yes/No?" and include a new option under settings "how many mails per hour? - Blank for infinite/a number for restricted number, for example 250 per hour".

This is important because not all servers can send 3.000 emails in 10 minutes.

Many thanks.
Change History
comment:1 Changed 3 months ago by damon

Status set to pending-review

+1 on this one and I have a related request.

With 27,000 users I get a lot of members who contact me by contact form or reply to a notification with "Stop sending me email" despite having instructions in the email itself.

The problem is usually because they asked for forum notifications but now they don't want them and either lost their login or just too lazy to login and follow instructions.

I would love an easier way to stop all notifications for a particular user. Being able to find the user by either username or email would be a big help since they don't always supply (or even remember) their username.

review hook code

review code for calling hooks


will this enable attachments per post (as opposed to the current "attachments per topic") ?


That would be great, MediaAttach is almost working for a normal forum feature to upload and add a picture to a post, but as you say all the pictures end up together at the bottom of the topic instead of in the post.

Refactor javascript for new prototype version.

http://code.zikula.org/dizkus/ticket/259

** Was: "Can't create new category" **

Bug description

With an inactive site using Zikula 1.2.0 and Dizkus 3.0, because of recent discussion on Forum of problems creating new category, I wanted to test upgrade to 1.2.5 before I upgraded my active sites. I upgraded without incident to 1.2.5. Then went to Dizkus and was no longer able to add a category. If I click the button, nothing happens. No change related to different themes. I upgraded to Dizkus 3.1 and no change. Then I uninstalled Dizkus 3.1 and re-installed it fresh. Still unable to add a category to Dizkus 3.1 and Zikula 1.2.5. Tried in latest Safari, Firefox and Chrome - all the same.
bug analysis

Possibly a change related to 1.2.5 upgrade as it was working before that upgrade.


Changed 7 months ago by pheski

(Note - I tested Dizkus before the upgrade to 1.2.5 and was able to add categories and forums and re-order them without problem, so the problem occurred specifically after the 1.2.5 upgrade in a system that I had just tested prior to the upgrade.)


comment:2 Changed 7 months ago by pheski

I have added screen shots that may be a cle - it appears that some js files are not being called?


comment:3 Changed 7 months ago by FRW

I' ve tested it because there was the same problem at my new site.
It seemed to be that the prototype.js is the main point. Version of 1.2.5 doesn't work, Version from 1.2.4 works and I can add categories


comment:4 Changed 7 months ago by espaan

In your screenshots it seems that you have JS and CSS combine switched on in the zk125 install
If you switch that of in the Theme->Settings, does that help?


comment:5 Changed 7 months ago by drak

I'd like to say we're running Zikula 1.2.5 + Dizkus 3.1 on community.zikula.org without any issue (that I know of).


comment:6 Changed 7 months ago by drak

Think this ticket can be closed, it's related to a prototype update to 1.7 in Core 1.2.5, and this has been downgraded in 1.2.6 to 1.6.1. Dizkus will need to refactor it's JS for the Core 1.3.0 version of Dizkus because it uses Prototype 1.7 and the latest scriptaculous.

content plugin

a plugin for content is needed. It should work similar to the dizkus block. My special interest is, to limmit the view to one or more categories or forums

Let moderators block users

bug description

Moderators can do many things, but can't ban anyone.
bug analysis

Normally in order to block access to a user one should be able to use the user module, the problem is that if he has that level of permission he can edit admins, this isn't good.

Because of this moderators can't do nothing if a user continues to create topics and posts.
fix recommendation

Include a block/unblock user option near the send PM, view IP options, this way moderators could block "bad" users. Note that this option CAN'T appear in admins and other mods, otherwise the problem would remain. The option would only appear in "normal" users.

If possible, a list of block users would appear under Dizkus options.

This would be a great evolution to this module and would facilitate the inclusion of new moderators.

Many thanks.

phpBB to pnforum 2.7

Here is an updated version of the old script.

i won't assume any support, use at you own risk (but i assume it's work on a test forum)

  • support for UTF 8
  • use of adodb (i had problems with some special characters)

how to

first,

  • install a fresh zikula 1.0
  • install you phpBB tables on the same bases as the zikula
  • install pnforum 2.7
  • run this queries
TRUNCATE TABLE `zk_pnforum_categories` ;
TRUNCATE TABLE `zk_pnforum_forums` ;
delete FROM `zk_users` ;
TRUNCATE TABLE `zk_pnforum_posts` ;
TRUNCATE TABLE `zk_pnforum_posts_text` ;
TRUNCATE TABLE `zk_pnforum_topics` ;
TRUNCATE TABLE `zk_pnforum_users` ;

this will delete all information in your databases, be carefull. The goal is to be sure, there will be no duplicate entry for the primary keys of this tables.

run convtopnforum.php (before you have to edit the script in order to set your database parameters)

if the script stopped before ending (think to put a big 'max execution time'), you just have to re run the "drop&delete" queries above and to launch the script back

http://luffyserveur.free.fr/phpBB2pnforum.zip


it's for phpBB2 only


i didn't had time to test it
but perhaps you can simply put

include "includes/classes/adodb/adodb.inc.php"

instead of

include("adodb5/adodb.inc.php");

Reason for thread deletion

how about if you delete it when the threads get a possibility to specify a reason for this and this message is automatically sent by the creator

in my opinion is something very practical because otherwise the deleted thread is created equally new ...

Ability to set a maximum number of topics in a forum

Here's one thing on my wishlist: the ability to limit the maximum number of posts or topics in a forum.

This would then make the particular forum a "rollover" forum where after X number of topics, the oldest topic in the forum is killed off when a new one is posted. IMHO, it would be ideal for chit-chat type forums of no archival value and DB management and space issues would be much easier to handle with such a feature.

Migrated from http://code.zikula.org/parked/ticket/510

Integrate spam tools like: Askimet or spamFree

EN: Is it possible to integrate spam-protection for new comments or new post if guests have the comment-permission? Bad-Behaviors works bad it can go round. Integration of Askimet or spamFree?


DE: Um evtl. im Forum für unregistrierte Gäste auch das posten zu ermöglichen, aber unerwünschte Kommentare oder Posts auszuschliessen wird ein Spamschutz benötigt.

Bad-Behaviors funktioniert generell, kann aber umgangen werden. Askimet oder spamFree stehen noch zur Verfügung. Ist es möglich diese zu integrieren?

Wrong rank displayed on the forum thread

Cozi ticket

http://community.zikula.org/module-Forum-viewtopic-topic-58080-start-0.htm

I just noted that a new user, registered two days ago, without an Honorary rank nor being part of other group than Users, appears as moderator of the forum on his first post.

First reaction when you note the bug:
"OMG, he hacked the site"
but it's not, it's just a bug retrieving/displating the rank info.
Change History
comment:1 Changed 13 months ago by Landseer

Cannot reproduce this here using 3.2 from svn, some more information are needed. The link provided does not say anything about this user being a moderator.

Please support non-javascript template

problem

Sometimes javascript just fails or gets in the way of what you need to do. Please support non-javascript forms and controls.
analysis

See my last ticket on scribite. It would be much easier to work around if I could just disable the javascript and go with real html forms.

Centerblock - Hide block after x hours if there are now new posts

EN: To display a block with current contributions within x hours and after that time I have to hide again the following changes.

In the administration block is added as an additional parameter "nohours = 8" with contributions for the last 8 hours.

In pntemplates / plugis / function.readlastposts.php at line 130 I added the following:


DE: Um einen Block mit aktuellen Beiträgen innerhalb x Stunden anzeigen zu lassen und nach Ablauf dieser Zeit wieder auszublenden habe ich folgendes geändert.

In der Block-Administration gibt man als zusätzlichen Parameter "nohours=8" für Beiträge der letzten 8 Stunden mit an.

In pntemplates/plugis/function.readlastposts.php bei zeile 130 hab ich folgendes hinzugefügt:


if (isset($paramsnohours?)) {

    $nohours = $paramsnohours?;
    $wheretime = ' t.topic_time > DATE_SUB(NOW(), INTERVAL '. $nohours .' HOUR) AND ';
    }

and after

    WHERE ' . $whereforum .'

        ' . $whereuser . '

added additional ' . $wheretime . '


comment:1 Changed 3 months ago by knollo

Sorry, again here the code:

if (isset($params['nohours'])) {
        $nohours = $params['nohours'];
        $wheretime  = ' t.topic_time > DATE_SUB(NOW(), INTERVAL '. $nohours .' HOUR) AND ';
        }

Store date&time as datetime-column

bug description

Dates and times are stored as strings in the database. - This requires much space and a lot of implicit type conversions on some queries.
fix recommendation

Use datetime columns.


Index: common.php
===================================================================
--- common.php  (Revision 507)
+++ common.php  (Arbeitskopie)
@@ -939,7 +939,7 @@
  * THe only change is to set the default value for strPattern to the format we use in the database
  *
  */
-function dzk_str2time($strStr, $strPattern = 'Y-m-d H:i')
+function dzk_str2time($strStr, $strPattern = 'Y-m-d H:i:s')
 {
    // an array of the valide date characters, see: http://php.net/date#AEN21898
    $arrCharacters = array(
Index: pntables.php
===================================================================
--- pntables.php    (Revision 507)
+++ pntables.php    (Arbeitskopie)
@@ -112,7 +112,7 @@
                                                  'topic_id'    => 'I NOTNULL DEFAULT 0',
                                                  'forum_id'    => 'I NOTNULL DEFAULT 0',
                                                  'poster_id'   => 'I NOTNULL DEFAULT 1',
-                                                 'post_time'   => 'C(20) NOTNULL DEFAULT \'\'',
+                                                 'post_time'   => 'T NOTNULL',
                                                  'poster_ip'   => 'C(50) NOTNULL DEFAULT \'\'',
                                                  'post_msgid'  => 'C(100) NOTNULL DEFAULT \'\'');
     $pntable['dizkus_posts_column_idx'] = array ('topic_id'   => 'topic_id',
@@ -188,7 +188,7 @@
                                                   'topic_title'        => 'C(255) NOTNULL DEFAULT \'\'',
                                                   'topic_poster'       => 'I NOTNULL DEFAULT 0',
                                                   'topic_anonymous'    => 'I(1) NOTNULL DEFAULT 0',
-                                                  'topic_time'         => 'C(20) NOTNULL DEFAULT \'\'',
+                                                  'topic_time'         => 'T NOTNULL',
                                                   'topic_views'        => 'I NOTNULL DEFAULT 0',
                                                   'topic_mod_views'    => 'I NOTNULL DEFAULT 0',
                                                   'topic_replies'      => 'I UNSIGNED NOTNULL DEFAULT 0',
Index: pnuserapi.php
===================================================================
--- pnuserapi.php   (Revision 507)
+++ pnuserapi.php   (Arbeitskopie)
@@ -1400,7 +1400,7 @@
     $forum_id = (int)DataUtil::formatForStore($myrow['forum_id']);

     // Prep for DB
-    $time = date('Y-m-d H:i');
+    $time = date('Y-m-d H:i:s');
     $topic_id = DataUtil::formatForStore($topic_id);
     $message = DataUtil::formatForStore($message);
     $pn_uid = DataUtil::formatForStore($pn_uid);
@@ -1692,7 +1692,7 @@
         $poster_ip = '127.0.0.1';
     }

-    $time = (isset($time)) ? $time : date('Y-m-d H:i');
+    $time = (isset($time)) ? $time : date('Y-m-d H:i:s');

     // Prep for DB
     $subject   = DataUtil::formatForStore($subject);
@@ -2217,7 +2217,7 @@
                 // there is at least one posting in this topic
                 // $post contains the data of the last posting
                 //
-                $lastposttime = date('Y-m-d H:i', $last_topic_post['post_unixtime']);
+                $lastposttime = date('Y-m-d H:i:s', $last_topic_post['post_unixtime']);
                 $sql = "UPDATE ".$pntable['dizkus_topics']."
                         SET topic_time = '".DataUtil::formatForStore($lastposttime)."',
                             topic_last_post_id = '".(int)DataUtil::formatForStore($last_topic_post['post_id'])."',
@@ -3525,7 +3525,7 @@
     list($old_last_post_id, $old_topic_anonymous, $old_replies) = $result->fields;
     dzkCloseDB($result);

-    $time = date('Y-m-d H:i');
+    $time = date('Y-m-d H:i:s');

     //  insert values into topics-table
     $topic_id = $dbconn->GenID($pntable['dizkus_topics']);
@@ -4744,10 +4744,10 @@

     foreach ($args['items'] as $item) {
         // create the reference, we need it twice
-        $dateTimestamp = $item->get_date("Y-m-d H:i");
+        $dateTimestamp = $item->get_date("Y-m-d H:i:s");
         if (empty($dateTimestamp)) {
             $reference = md5($item->get_link());
-            $dateTimestamp = date("Y-m-d H:i", time());
+            $dateTimestamp = date("Y-m-d H:i:s", time());
         } else {
             $reference = md5($item->get_link() . '-' . $dateTimestamp);
         }

missing strtotime to dzk_str2time conversions

strtotime was changed to dzk_str2time everywhere, but two were missing.

Index: backforum.php
===================================================================
--- backforum.php   (Revision 507)
+++ backforum.php   (Arbeitskopie)
@@ -173,7 +173,7 @@
         $post['forum_name']         = $forum_name;
         $post['poster_id']          = $poster_id;
         $post['time']               = $post_time;
-        $post['unixtime']           = strtotime ($post['time']);
+        $post['unixtime']           = dzk_str2time ($post['time']);
         $post['cat_id']             = $cat_id;
         $post['cat_title']          = $cat_title;
         $shown_results++;
Index: pntemplates/plugins/function.folderimage.php
===================================================================
--- pntemplates/plugins/function.folderimage.php    (Revision 507)
+++ pntemplates/plugins/function.folderimage.php    (Arbeitskopie)
@@ -40,7 +40,7 @@
                            $fldr_alt = _DZK_NONEWPOSTS;
                        }

-                   $posted_unixtime= strtotime ($row['post_time']);
+                   $posted_unixtime= dzk_str2time ($row['post_time']);
                    $posted_ml = DateUtil::getDatetime(GetUserTime($posted_unixtime), _DATETIMEBRIEF);
                    if ($posted_unixtime) {
                        if ($row['pn_uid']==1) {
Index: pntemplates/plugins/function.readlastposts.php
===================================================================
--- pntemplates/plugins/function.readlastposts.php  (Revision 507)
+++ pntemplates/plugins/function.readlastposts.php  (Arbeitskopie)
@@ -220,7 +220,7 @@
             list($lastpost['post_text']) = pnModCallHooks('item', 'transform', '', array($lastpost['post_text']));
             $lastpost['post_text'] = DataUtil::formatForDisplay(nl2br($lastpost['post_text']));

-            $posted_unixtime= strtotime ($lastpost['topic_time']);
+            $posted_unixtime= dzk_str2time ($lastpost['topic_time']);
             $posted_ml = DateUtil::getDatetime(GetUserTime($posted_unixtime), _DATETIMEBRIEF);
             $lastpost['posted_time'] =$posted_ml;
             $lastpost['posted_unixtime'] = $posted_unixtime;

sql error using zikula search

SQL error is thrown when using search at taucherverzeichnis.de with search string "test". fresh dizkus install as it is without manual modifications

Can't find FULLTEXT index matching the column list
INSERT INTO z_search_result (sres_title, sres_text, sres_module, sres_extra, sres_created, sres_found, sres_sesid) SELECT t.topic_title, , 'Dizkus', REPLACE ('Forum/viewtopic/topic/%%%', '%%%', t.topic_id) as extra, p.post_time, NOW(), '5326506755fccff5938d419c7f9ec6b37569403c' FROM z_dizkus_posts AS p, z_dizkus_topics AS t WHERE (MATCH p.post_text AGAINST ('test') OR MATCH t.topic_title AGAINST ('test')) AND p.topic_id=t.topic_id AND p.forum_id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25) GROUP BY p.topic_id

Comment:1 Changed 14 months ago by Landseer

FULLTEXT index is not available, turn off search by FULLTEXT index.

Spell Check for Dizkus

I had a client request a spell check for their forums. I looked around and found http://www.spellify.com/ which is GPL and uses script.aculo.us & prototype. I know browsers have built-in spell check these days, but the client seems to be set on a site based spell check, and it may be useful to some.
Change History
comment:1 Changed 15 months ago by Landseer

Milestone set to 3.2

comment:2 Changed 12 months ago by Landseer

Priority changed from major to minor

Unfortunately Spellify is a bit outdated (latest code from 2007) and it does not really use all the nice features Prototype offers to make an Ajax request. This plus other caveats make it necessary to do major changes to the code to get it working within Zikula. Not sure if this is worth the effort atm.

Broken links in email notifications

Cozi ticket

bug description

If the text of a post includes an image using bbcode tags, the email notification text includes the bbcode tags which breaks the link to the image..

Links end up like

[url]http://www.example.com/image.jpg[/url]

which displays in major email clients (gmail, outlook) as if it were

[url]<a href=" http://www.example.com/image.jpg[/url]"> http://www.example.com/image.jpg[/url]</a>

Producing a broken link


The bbcode and bbsmiles tags don't work in email clients.


Would work for me if all bbcode and bbsmile tags could be stripped from email text.

This is from Phorum, there may be a better way just eliminates anything inside square brackets.

    Strip BB Code [tags]

        if ( isset($PHORUMmod_format_email?strip_bbcode?)

            && $PHORUMmod_format_email?strip_bbcode? ) {

        $stripped = preg_replace('|\*[a-z[\]]*\]|i', , $stripped);

    }

Remove quoted text from email notifications

bug description

The entire post text is included in email notifications, including all quoted posts.
fix recommendation

Strip content inside [quote] quote tags from email notifications.

UID as a parameter for the userprofilelink modifier

I think it it better to use the UID (instead uname) as a parameter the userprofilelink modifier.
Change History
comment:1 Changed 15 months ago by Landseer

Milestone changed from 3.1 to 3.2

Not sure why this is better, but it is not vital for 3.1.
comment:2 Changed 15 months ago by herr.vorragend

(In [1278]) UID as a parameter for the userprofilelink modifier (refs #211)
comment:3 Changed 15 months ago by herr.vorragend

Milestone changed from 3.2 to 3.1

I've done it now. It was a important for me, because we have some users with "special signs" or "mail addresses" as usernames in our Zikula forums.

I could not change the modifier, because I don't have the UID there and I don't want to modify the sql queries :-)

comment:4 Changed 15 months ago by herr.vorragend

Milestone changed from 3.1 to 3.2

Reverted in [1280].

If we change this, we need min. Zikula 1.2.4(!)

You are right. We should do this later in Dizkus 3.2

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.