nukeSPAM update

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

With gratitude to Guardian for stimulating a review of 12 jQuery grid components, I selected DataTables and integrated that into nukeSPAM, specifically for displaying the log of blocked spammers.

Check out this Only registered users can see links on this board! Get registered or login! of the prototype display for more details.

Just a few more tweaks before the final round of testing...

Posted: Sun Jan 29, 2012 11:34 pm

Looking good.

registered · Posted: Mon Jan 30, 2012 6:26 am

Very Nice.... Like everything you do, very professional.

Posted: Mon Jan 30, 2012 6:30 am

Looks very promising.

Posted: Mon Jan 30, 2012 4:57 pm

Sure beats my clunky PHP datagrid Smile

That jQuery powered one looks exceptionally nice, so congrats for taking the time to review them. I'm really intrigued and excited about the data exporting functionality.

Posted: Mon Jan 30, 2012 5:31 pm

Still a few issues to work out. For example, it uses AJAX to display the data (I'm anticipating LOTS of data). I need to secure the data access to prevent unauthorized access outside the intended functions.

Also, when you export using AJAX, it only exports what you see (at least, that what it does as it's configured). We could allow you to display all records (e.g. when using RNYA) either via AJAX or load once from the data, and it would export them all. But I'm thinking it would be OK to just export what you see. Thoughts?

Posted: Mon Jan 30, 2012 6:53 pm

Are you running your AJAX call(s) through mainfile?

I do not understand what is going on with the export to offer an opinion.

Posted: Mon Jan 30, 2012 7:59 pm

Not yet running AJAX calls through mainfile, but that is the next step.

Posted: Mon Jan 30, 2012 8:51 pm

Wow. That was easy. I remembered that we did this for RNYA to dynamically check email and user name availability, so I used the same approach and had it working on the first try!

Now, to convert the database calls to use $db...

Posted: Mon Jan 30, 2012 8:56 pm

I would suggest making it an op like any other in your module.

Posted: Tue Jan 31, 2012 7:46 am

It's integrated as a module. Now just need to add whitelist functionality, clean up the code, test and package.

registered · Posted: Sat Feb 04, 2012 6:57 am

RE: export, I think both current page and full results useful. If you were thinking of wrapping this at the PHP end with something which could be used more generically throughout RN, I'd add an option to the PHP code to allow a button/link/something somewhere above/below the table and just have it go to a different PHP op to process the full export.

RE: AJAX requests. It sure would be nice to have a common interface (API!) in front of all current and future AJAX calls. One that handles including all the needed security and DB connectivity, etc., and then all anyone has to be worried with is writing the handler for the particular call being made. I think AJAX use is needing to grow. It provides a very rich end-user environment.

Posted: Sat Feb 04, 2012 7:37 am

Not sure I'll be able do do full exports with AJAX in the first release.

For AJAX requests, I use RNXHR to handle security without double counting Who Is Where.

Posted: Sat Feb 04, 2012 6:07 pm

Wasn't thinking Ajax for the full export. Was suggesting a link to a different op for that. No worries though. Very exciting work between you and Guardian!

Posted: Mon Feb 06, 2012 11:58 pm

Check Only registered users can see links on this board! Get registered or login! out. It's a prototype of the whitelist maintenance function, with several interesting features. (Make sure to scroll through the screenshots on the lower left side and read the captions in the middle below each screenshot).

My friend Chris calls this kind of functional / interface overkill "seeding evolution." I like "assembling evolution" since the real heavy lifting is done by others. I hope that it does drive increased functionality - and especially improved interfaces - for RN.

Posted: Thu Feb 09, 2012 5:50 am

Wow! Yes, I agree with "improved interfaces for RN". I would love to see standard UI components chosen, whether currently used or not in a core module, to cover all the key UI use models and ensure a better consistent look-and-feel across all content within an RN site.

But, that is for another topic.

Posted: Thu Feb 09, 2012 8:36 am

kguske, are you sending the data back as html or json? I'm also using the dataTable plugin for Swank Xibit and I'm curious to find out how you build your table.

Also, on your exports... if you kinda fill me in on how you're trying to accomplish the export via ajax... I might be able to help you out with it. I don't run forums nor let users sign into our site without being approved by me first... so I'm not sure how the spam blocker functionality should work but if I can help I will.

Posted: Thu Feb 09, 2012 8:59 am

json. I'll send you a prototype today - glad to hear you're using DataTables! I just resolved the last known issue, so it's really close to release (unless some of you soon-to-be Beta testers find something else).

Posted: Thu Feb 09, 2012 9:04 am

Looking forward to seeing how you coded. Json is the way to go for sure. Wink

Posted: Fri Feb 10, 2012 12:48 am

I noticed in functions.php two functions are creating there own database connection. Is there a reason for this?

Posted: Fri Feb 10, 2012 5:56 am

That is an external library created for standalone use. The functions that create database connections aren't used.

Posted: Fri Feb 10, 2012 6:06 am

Specifically, the functions are CreateDatabase and GetSpammerCount, neither of which is used. I left the code as it was for easy comparison with future versions of this library, but have commented out those functions so it's clear they aren't used (and, now, can't be used).

Posted: Mon Feb 13, 2012 6:35 am

nukeSPAM is Only registered users can see links on this board! Get registered or login!. Several fixes since the Beta version, and 3 enhancements:
- Added blocklist.de to the available DNS blacklists
- Moved the heavy lifting for the DataTables script (loading data) to a standard include file so it can be used with other modules / functions
- Added configuration for jQuery UI themes (currently in the nukeSPAM configuration, but should be integrated with RavenNuke theme management?)

Posted: Mon Feb 13, 2012 7:31 am

Nice!

Posted: Mon Feb 13, 2012 8:28 am

Thanks to Palbin for identifying and suggesting resolutions for several issues, and to Guardian and Montego for design review and input. That kind of feedback is what makes open source work!