DragonflyCMS Projects > BlogsPlus > Fancy a new challenge? > Community Forums > Phoenix Netology
Forum Index > Community > BlogsPlus

Fancy a new challenge? Reply to topic


Phoenix,
Having successfully take on the support role for the Treasury module from the absent initial creator and then taken it far beyond where it was I was wondering how you'd feel about doing something similar for another DF CMS module that is in dire need of updating?

The blogs module is something that was very popular on our main site until we had to take it down due to excessive spamming. In fact our users continue to demand to know when they will get it back! I also know that its something that I see regularly requested on the main DF site.

If you are interested then I think our two main concerns related to usability. Specifically we needed to allow moderation by selected users or groups (not site admin as we don't allow anyone else access to the admin side of the site for security reasons) and improve the navigation.

Obviously we're well aware that you're a busy man but I thought you might enjoy another challenge .......

There can be only one

Please enter your server specs in your user profile! 😢


So basically you want access on either can_admin() (as opposed to is_admin()) or a specific group.

I would imagine can_admin() should already be coded into it, and if not, easily remedied, though that means adding users through admin, which still maintains your security, but adds to your "apparent" admin list.

On a groups basis would be best done by adding a specific group name to main config and doing a check for either that group or can_admin().

Regarding the spamming issue, I presume that was coming from one-off sign-ups just to place spam, in which case adding security code checking isn't gonna help much. Perhaps a minimum post level?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Okay, had a quick look - there is no admin function as such, which explains a lot, and it's all is_admin() - they can be readily changed to can_admin() plus the addition of radminblogs to the admins table with very little effort.

Since there is no existing admin interface, the groups basis would require some extra coding. It's a very tightly coded bare-bones module.


Just remembered - ians produced an updated blogs version but it's no longer available from his site - we've had a lot of problems like that in recent times.

I think I have a copy somewhere, so I'll have a look around my extremely cluttered hard drives - for all I know, it may have all the answers you need Smile


Found it, and upgraded my existing Blogs - had a number of install issues, but eventually upgraded. Added you as an admin for the module so you can see it has what you want - password PMd. Also modified the code so that a specific Group can be nominated and can modify entries, in this case, the Projects group, which means you can edit/remove blog entries and remove comments without being an admin.

nukebiz.com/Blogs.html

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Okay, I fiddled a little more with it, and duplicated the collapsing feature that ians has used on his site Smile

I'm reasonably happy with it for now, so if you guys want to try it after checking it out here, just let me know.

PS - how do you like my server loads Laughing

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Phoenix,
Unfortunately I can't get admin access - please see your PMs.

Other than that its looking very good and the group moderator function is excellent. I think allowing our existing mods the ability to edit/remove blogs would solve our spamming problem almost instantly!

There can be only one

Please enter your server specs in your user profile! 😢


Thanks for clearing that up ........ now where can I get a copy as it looks excellent!

There can be only one

Please enter your server specs in your user profile! 😢


Okay - just have to drop my son at school should have it packaged within an hour.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Available now nukebiz.com/Downloads/...id=56.html
Simple file upload and module install.

It should upgrade your existing Blogs tables - please backup those tables and let me know if there are issues (I'm here all day today).

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Unfortunately not ....

includes/db/db.php * CMS Warning line 75: On /cpgn2/admin.php?op=modules&install=Blogs While executing query "CREATE TABLE cms_blogs ( id int(11) NOT NULL auto_increment, aid varchar(30) NOT NULL, title varchar(80) default NULL, text text NOT NULL, private tinyint(1) NOT NULL default 0, timestamp int(10) UNSIGNED NOT NULL default 1174520583, views int(10) NOT NULL default 0, PRIMARY KEY (id), KEY id (id), KEY aid (aid)) TYPE=MyISAM DEFAULT CHARSET=NULL" the following error occured: 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 'NULL' at line 11 In: /webpath/cpgn2/includes/classes/installer.php on line: 61

There can be only one

Please enter your server specs in your user profile! 😢


hmm, I can now see why - MySQL5?
I should have tested locally on MySQL5.

Edit line 46 of cpg_inst.php to,
title varchar(80) NULL,

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Same error ..... MySQL 5.024

There can be only one

Please enter your server specs in your user profile! 😢


bugger - I haven't looked at why title is set for NULL.

For now just try: title varchar(80) NOT NULL,

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


Exactly the same! Apologies but I need to hit the sack now. Hope you got your son ok and hopefully we can pick this up tomorrow?

There can be only one

Please enter your server specs in your user profile! 😢


hmm, sorry for that trouble - I'll kick in my local and see what's happening.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


You wouldn't have this problem in config.php?

Change define('DB_CHARSET', 'NULL'); => define('DB_CHARSET', NULL);

That will give you grief on all installs, which makes me wonder why Supporters installed okay, unless the config file was edited after that?


I would even be tempted to put money on it Smile

Test install of the unchanged package on MySQL 5.0.27 works flawlessly - it upgraded an original Blogs module (v2.0.1.0 I think).

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

All times are Australia/Adelaide


Jump to: