xoopscomments CrystalHack - Hacks - XOOPS News - XOOPS Web Application System

XOOPS

News

News World of XOOPS Developers Hacks Themes Archive Submit News

Hacks: xoopscomments CrystalHack

Posted by: Defkon1On 2006/9/11 21:20:00 9199 reads

CrystalHack is a xoops comments system hack that implements the SecurityImage class by Dugris and a useful new "Username" form field.
With this new field even anonymous users can specify a nickname instead of "Anonymous".

I think that this hack will be very useful especially in blogs and it will allow the webmasters to open Comment functionality to anonymous users
without worrying about spammer.

Hope you'll like it...

Download

I succesfully tested it on xoops 2.0.13.2 and 2.0.14.

Alternative link to dev.xoops.org projectpage:
http://dev.xoops.org/modules/xfmod/project/showfiles.php?group_id=1195

The comments are owned by the author. We aren't responsible for their content.

Re: xoopscomments CrystalHack

JMorris Published 09/12/2006 2:43 XOOPS is my life! Joined 04/11/2004 Comments 2722

I'm VERY interested in trying this out!

Do you have a direct download location? I keep getting "db connection failed".

Alternately, could you enable caching on modules and blocks to reduce the overhead until the initial traffic spike slows down?

Thanks!

James

Re: xoopscomments CrystalHack

sailjapan Published 09/12/2006 6:48 Moderator Joined 11/16/2005 Comments 1672

What he said.

Re: xoopscomments CrystalHack

Defkon1 Published 09/12/2006 8:12 Not too shy to talk Joined 01/27/2005 Comments 151

ooops...

Release page on dev.xoops.org | Direct download (dev.xoops.org)

Re: xoopscomments CrystalHack

Defkon1 Published 09/21/2006 14:27 Not too shy to talk Joined 01/27/2005 Comments 151

Thanks to GlaDiac is now possible to use this hack on php5, too!

HowTo

Re: xoopscomments CrystalHack

Will_H Published 09/21/2006 15:07 Friend of XOOPS Joined 10/10/2004 Comments 1786

Nice, I may just enable my comments now.

Re: xoopscomments CrystalHack

sailjapan Published 09/25/2006 13:45 Updated 09/25/2006 15:00 Moderator Joined 11/16/2005 Comments 1672

Resized Image

anyone else get this after submitting a comment?

I wonder if I got this right...
Quote:

modify /class/xoopsformloader.php adding the line:
include_once XOOPS_ROOT_PATH."/class/xoopsform/securityimage.php";

Where in that file should I have put this?

Re: xoopscomments CrystalHack

chippyash Published 09/25/2006 17:40 Friend of XOOPS Joined 01/29/2004 Comments 501

It appears that this hack is no longer available.

Re: xoopscomments CrystalHack

Bender Published 09/25/2006 20:38 Home away from home Joined 03/10/2003 Comments 1899

On dev.xoops.org there is a project page which still holds the file:

Project: SuoloItalico Translating Team

Direct file link

News item modified.

Re: xoopscomments CrystalHack

kaper Published 09/27/2006 10:07 Updated 09/29/2006 1:22 Just popping in Joined 04/26/2003 Comments 75

Quote:

anyone else get this after submitting a comment?

You should add a com_name varchar field to xoopscomments database table.

The hack author should note that this hack requires altering the database structure.

Quote:

Where in that file should I have put this?

In any new line

I put it at the end of the file.

Re: xoopscomments CrystalHack

kaper Published 09/28/2006 23:27 Just popping in Joined 04/26/2003 Comments 75

To prevent deleting poster's name in preview mode, modify definition of $default_name in comment_form.php (lines 52, 53):

change

 $default_name=""; 
     if(is_object($xoopsUser)){

into

 $default_name = isset($com_name) ? $com_name : ""; 
     if(is_object($xoopsUser) && ($com_name=="")){

Re: xoopscomments CrystalHack

sailjapan Published 09/29/2006 14:34 Updated 09/29/2006 14:42 Moderator Joined 11/16/2005 Comments 1672

@kaper
Quote:

You should add a com_name varchar field to xoopscomments database table.

Umm, right... and how would I go about that? Here's the code I see in my DB.

 -- 
-- Table structure for table `v1_xoopscomments` 
-- 
 
DROP TABLE IF EXISTS `v1_xoopscomments`; 
CREATE TABLE `v1_xoopscomments` ( 
  `com_id` mediumint(8) unsigned NOT NULL auto_increment, 
  `com_pid` mediumint(8) unsigned NOT NULL default '0', 
  `com_rootid` mediumint(8) unsigned NOT NULL default '0', 
  `com_modid` smallint(5) unsigned NOT NULL default '0', 
  `com_itemid` mediumint(8) unsigned NOT NULL default '0', 
  `com_icon` varchar(25) NOT NULL default '', 
  `com_created` int(10) unsigned NOT NULL default '0', 
  `com_modified` int(10) unsigned NOT NULL default '0', 
  `com_uid` mediumint(8) unsigned NOT NULL default '0', 
  `com_ip` varchar(15) NOT NULL default '', 
  `com_title` varchar(255) NOT NULL default '', 
  `com_text` text NOT NULL, 
  `com_sig` tinyint(1) unsigned NOT NULL default '0', 
  `com_status` tinyint(1) unsigned NOT NULL default '0', 
  `com_exparams` varchar(255) NOT NULL default '', 
  `dohtml` tinyint(1) unsigned NOT NULL default '0', 
  `dosmiley` tinyint(1) unsigned NOT NULL default '0', 
  `doxcode` tinyint(1) unsigned NOT NULL default '0', 
  `doimage` tinyint(1) unsigned NOT NULL default '0', 
  `dobr` tinyint(1) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`com_id`), 
  KEY `com_pid` (`com_pid`), 
  KEY `com_itemid` (`com_itemid`), 
  KEY `com_uid` (`com_uid`), 
  KEY `com_title` (`com_title`(40)) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
 
-- 
-- Dumping data for table `v1_xoopscomments` 
-- 
 
LOCK TABLES `v1_xoopscomments` WRITE; 
/*!40000 ALTER TABLE `v1_xoopscomments` DISABLE KEYS */; 
/*!40000 ALTER TABLE `v1_xoopscomments` ENABLE KEYS */; 
UNLOCK TABLES;

If I add the com_name varchar field, would it look something like this?

`com_name` varchar(255) NOT NULL default '',

If not, how should it look? Also, where should it be added? I also notice the following code that seems more likely as a place to add the field:

 -- 
-- Table structure for table `v2_xoopscomments` 
-- 
 
DROP TABLE IF EXISTS `v2_xoopscomments`; 
CREATE TABLE `v2_xoopscomments` ( 
  `com_id` mediumint(8) unsigned NOT NULL auto_increment, 
  `com_pid` mediumint(8) unsigned NOT NULL default '0', 
  `com_rootid` mediumint(8) unsigned NOT NULL default '0', 
  `com_modid` smallint(5) unsigned NOT NULL default '0', 
  `com_itemid` mediumint(8) unsigned NOT NULL default '0', 
  `com_icon` varchar(25) NOT NULL default '',

This table `v2_xoopscomments` seems to have all my comments in it... why are there two xoopscomments tables?

Really appreciated if you could help me out on this, I've never messed with SQL before and am a little nervous of messing things up big time.

Re: xoopscomments CrystalHack

manel Published 09/29/2006 16:38 Just popping in Joined 01/26/2003 Comments 32

This is my comments table. You can use it.

 --  
-- Estructura de la taula `xoops_xoopscomments` 
--  
 
DROP TABLE IF EXISTS `xoops_xoopscomments`; 
CREATE TABLE `xoops_xoopscomments` ( 
  `com_id` mediumint(8) unsigned NOT NULL auto_increment, 
  `com_pid` mediumint(8) unsigned NOT NULL default '0', 
  `com_rootid` mediumint(8) unsigned NOT NULL default '0', 
  `com_modid` smallint(5) unsigned NOT NULL default '0', 
  `com_itemid` mediumint(8) unsigned NOT NULL default '0', 
  `com_icon` varchar(25) NOT NULL default '', 
  `com_created` int(10) unsigned NOT NULL default '0', 
  `com_modified` int(10) unsigned NOT NULL default '0', 
  `com_uid` mediumint(8) unsigned NOT NULL default '0', 
  `com_ip` varchar(15) NOT NULL default '', 
  `com_title` varchar(255) NOT NULL default '', 
  `com_text` text NOT NULL, 
  `com_sig` tinyint(1) unsigned NOT NULL default '0', 
  `com_status` tinyint(1) unsigned NOT NULL default '0', 
  `com_exparams` varchar(255) NOT NULL default '', 
  `dohtml` tinyint(1) unsigned NOT NULL default '0', 
  `dosmiley` tinyint(1) unsigned NOT NULL default '0', 
  `doxcode` tinyint(1) unsigned NOT NULL default '0', 
  `doimage` tinyint(1) unsigned NOT NULL default '0', 
  `dobr` tinyint(1) unsigned NOT NULL default '0', 
  `com_name` varchar(25) NOT NULL default '', 
  PRIMARY KEY  (`com_id`), 
  KEY `com_pid` (`com_pid`), 
  KEY `com_itemid` (`com_itemid`), 
  KEY `com_uid` (`com_uid`), 
  KEY `com_title` (`com_title`(40)) 
) TYPE=MyISAM AUTO_INCREMENT=4 ;

Re: xoopscomments CrystalHack

kaper Published 09/29/2006 19:06 Just popping in Joined 04/26/2003 Comments 75

This hack does not behave correctly when wrong code is entered.

After entering wrong code, a redirect message is displayed... and no redirection occurs; you should be turned back to the comment form, in fact you stay forever on redirection page. I think there is something wrong in lines 146 and 150 of comment_post.php, perhaps in the javascript?

redirect_header( 'javascript:history.go(-1)' , 1, _SECURITYIMAGE_ERROR ) ;

When you then manually come back to the comment form, after entering the code you are redirected to main page of the module (after clicking either Sobmit or Preview). In fact no matter if you type the code correctly or not, the one displayed in the image is not valid anyway.

Two things should be done, I am not sure whether in DFK hack or in SecurityImage class. First - redirections should be corrected. Second - validating (re-generating) of the code should be provided.

I have seen a very useful feature in some implementation of captcha image - a button which allows generating new code when current one is difficult to be read. It would be nice to implement it to the SecurityImage.

Re: xoopscomments CrystalHack

sailjapan Published 09/30/2006 4:51 Moderator Joined 11/16/2005 Comments 1672

hmm. added the com_name varchar field but nothing changed. still getting that ugly pink alert...

Re: xoopscomments CrystalHack

manel Published 09/30/2006 11:04 Just popping in Joined 01/26/2003 Comments 32

The hack runs wiht the modifications marked before well. There is a problem with the moderation of comments, if the option to moderate is remarks, in this case the comments can not be approved by moderator.

Re: xoopscomments CrystalHack

sailjapan Published 10/01/2006 11:24 Moderator Joined 11/16/2005 Comments 1672

A-Ha! Fixed it. Many thanks to manel and kaper. Took me a while to figure out how to add a field to the DB, but as with anything else, it's easy once you know how.

Thanks again folks.

Re: xoopscomments CrystalHack

Defkon1 Published 10/02/2006 10:55 Not too shy to talk Joined 01/27/2005 Comments 151

Quote:

The hack author should note that this hack requires altering the database structure.

you're right... i'm very sorry...

i'm working on a fixed version of this hack, introducing all this fix...

sorry again

Re: xoopscomments CrystalHack

sailjapan Published 10/03/2006 0:17 Moderator Joined 11/16/2005 Comments 1672

Defkon1 said: Quote:

you're right... i'm very sorry...

i'm working on a fixed version of this hack, introducing all this fix...

sorry again

No worries, all's well that ends well. Thanks for the hack and for dropping by my site to check.

xoopscomments CrystalHack diff for 2.0.15ML

mangust Published 10/03/2006 10:20 Just popping in Joined 06/08/2004 Comments 2

I'm using the lateset XOOPS at the moment 2.0.15 + smartfactory ML hack. So. Hack + hack for 2.0.13 :) And it is a long time since 2.0.13, there may be some changes...
So i've decided to make my own diff file
CrystalHack for (2.0.15+ML) diff
This is usefull for future upgrade. You need to apply it on patched ML version of XOOPS.
And don't forget that you need to add field com_name into comments table in your database.
You can see commentable galery here:
example here feel free to comment ;)

Re: xoopscomments CrystalHack diff for 2.0.15ML

Defkon1 Published 10/05/2006 7:18 Not too shy to talk Joined 01/27/2005 Comments 151

thank you very much mangust!

i'm happy to see that my hack has generated all this attention (and work) around itself!

Re: xoopscomments CrystalHack diff for 2.0.15ML

Shine Published 10/05/2006 7:45 Just can't stay away Joined 07/22/2002 Comments 822

Wow, I am a little bit lost now.
Which working CrystalHack should I download if I use XOOPS version: 2.0.13.2 without ML?

Re: xoopscomments CrystalHack diff for 2.0.15ML

Defkon1 Published 10/05/2006 13:19 Updated 10/05/2006 13:21 Not too shy to talk Joined 01/27/2005 Comments 151

my fixed version is still not ready...

you can download the first package, using the GlaDiac class if your server uses PHP5.

don't forget to add a com_name VARCHAR(30) field in your prefix_comments table...

Re: xoopscomments CrystalHack

Defkon1 Published 10/11/2006 23:17 Not too shy to talk Joined 01/27/2005 Comments 151

xComments CrystalHack Official Page opened!

as soon as possible will be available in english, too...

Re: xoopscomments CrystalHack

basti007 Published 05/16/2007 10:34 Just popping in Joined 12/13/2006 Comments 4

Sorry to digg this out, but: is there any new version?

Mainly, is there a patched version that is able to go back to the comments page when the wrong captcha is inserted (and probably even refreshes the captcha image)?

And is there a possibility, that registered users don`t have to enter the captcha code? At the moment, only the webmaster doesn`t have to enter it - how can this be done for registered users?

Re: xoopscomments CrystalHack

demazero Published 09/07/2009 5:32 Updated 09/07/2009 6:01 Just popping in Joined 04/01/2009 Comments 6

Hi all
i just install dfk_xcomments on my XOOPS 2.0.18 using php 5 and i got error when submitted the comments and the error sound like this :

Fatal error: Using $this when not in object context in C:\xampp\htdocs\portalkpk1\class\xoopsform\securityimage.php on line 497

the line 497 :
function checkSecurityImage()

does anyone know the error? ok thanks

Login

Username

Password

Remember me

Search

Advanced Search

Donat-O-Meter

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

{{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}

Hacks: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

xoopscomments CrystalHack diff for 2.0.15ML

Re: xoopscomments CrystalHack diff for 2.0.15ML

Re: xoopscomments CrystalHack diff for 2.0.15ML

Re: xoopscomments CrystalHack diff for 2.0.15ML

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Re: xoopscomments CrystalHack

Login

Search

Recent Comments

Re: New Admin Theme for XOOPS (Beta)

Sanford Pharmacy: Exceptional Pharmacy Services Tailored to You

Re: New Admin Theme for XOOPS (Beta)

Re: XOOPS 2.5.12 Beta-2 available for Testing

Re: XOOPS 2.5.12 Beta-2 available for Testing

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

Archives

News archives