Is it possible to Auto Post News?

Worker Joined: May 08, 2007 Posts: 130

Hi All,

In one of my sites I am not getting adequate time to moderate all the stories so planning to Auto-Approve posts and do sample checks instead on posted items and also put a link to report/flag offensive stories as they do in you tube.

So how can I auto post user submitted articles any idea? One more thing that I need to know is there anyway to put a stamp in those posts like say

(Today's Date, Site Name --)

So far I used to manually approve and post the stamp by copy paste but how can i auto approve and auto stamp.

New registrations I can moderate I guess by using a script by Montego...

I think I am using rnuke v 2.1 (around 3.5 yrs old)

Best

Posted: Fri Mar 09, 2012 10:41 am

Your request would require significant modifications to the base Ravennuke code. And, since the News module has changed significantly since RN 2.1 the changes would have to be made to the 2.1 code. This is not to say it's impossible ... anything is possible with Open Source. And I can't speak for the rest of the developers but I know that most of are in up to our eyeballs and don't have time for an side excursion such as this.

Posted: Fri Mar 09, 2012 1:03 pm

I guess you are talking about Date Stamp right?

But bypassing Moderation of News will require lots of coding? If its not possible (time consuming( I am wondering if its possible to post directly from the database using something like SQLFront? That is like a on off switch in the data table... happens with messages 1 and 0 (does save time)

Posted: Fri Mar 09, 2012 1:16 pm

Right now, the submit news module posts proposed news articles to the queue table. You'd need to swap that out and post them to the stories table instead. You'd want to compare the structure of the queue table and the stories table ... I'm not sure if they are totally identical. The news/admin/index.php program has a poststory function that you might be able to cannibalize for the update. As to the date stamp, you'd probably have to create a variable containing it and then include it in the storytext in the update function, unless you intend to create a separate field for it.

I don't know about SQLFront. I'd be inclined to rely on the existing updating logic in postStory.

I don't know how many users you are talking about or what your site situation is with regard to hackers. Spammers would love to get direct access to posting stories and if you take moderation away you could be opening yourself to that. If you keep tight control over who gets a username then this might not be a problem but if you let people register without approval it could become one. On the other hand if you just have a few users you could make them all news admins and they could use the New Story feature to post directly without going through submit news at all. In that case, no code changes at all would be required for the moderation part.

Posted: Fri Mar 09, 2012 4:20 pm

create a specific group of users who you trust and let them auto submit theire stories.

PS:use your creativity to figure out who's capable to manage the stories,so that one of your trusted users verify the posts of unverified users.

This is called 'Moderation'.

Posted: Fri Mar 09, 2012 11:58 pm

Yeah guys thanks that's very good idea...why not select specific users/groups (do know who posts safe content) and give them posting privileges...only problem i can think of is they will also have access to older stories posted by others right? Problem this ones a press release site and have a decent user base but all are from PR companies so how will the treat competing businesses is a question that has to be pondered on!

Posted: Sat Mar 10, 2012 1:47 am

I found this post

http://www.karakas-online.de/forum/viewtopic.php?t=270

There is a way to bypass moderation in phpnuke... but as coding is different I am wondering if this can be modified to do the same job?

What they are suggesting is modifying

Code:

$result = sql_query("insert into ".$prefix."_queue values (NULL, '$uid', '$name',


'$subject', '$story', '$storyext', now(), '$topic', '$catid', '$alanguage')", $dbi);

to

Code:

$result = sql_query("insert into ".$prefix."_stories values (NULL, '$catid', '$name',


'$subject', now(), '$story', '$storyext', '0', '0', '$topic', '$name', '', '0', '$alanguage', '0',


'0', '0', '0', '0')", $dbi);

So can

Code:

$result = $db->sql_query('INSERT INTO '.$prefix.'_queue VALUES (NULL, \''.$uid.'\', \''.$name.'\', \''.$subject.'\', \''.$story.'\', \''.$storyext.'\', now(), \''.$topic.'\', \''.$alanguage.'\')');


    if(!$result) {


        echo '<p>'._ERROR.'</p>';


        CloseTable();


        include_once('footer.php');


        die();


    }


        if($notify) {


        $notify_message = "$notify_message\n\n\n========================================================\n$subject\n\n\n$story\n\n$storyext\n\n$name";

Be modified so that it can send stories to _stories ?

If i can
a) implement this and
b) give access to submit news module to a specific trusted group and
c) moderate the new users and
d) have a report article link

my requirement will be solved

Any ideas?

registered · Posted: Sat Mar 10, 2012 4:10 am

It should work as expected , but you need to be careful and test it.

what you can do , is:

a) copy the Submit News module files and name the new module whatever you like and make the change within the new files.
b) ,give access to the module to trusted users
c) you will still be able to moderate the first module
d) I have no idea how to do that

and $dbi is not used anymore , so you'll have to be carefull

Posted: Sat Mar 10, 2012 4:39 am

Hi that is a good idea to have two news posting modules so that trusted users can auto post and others can send via normal moderated channel...I hope it will not create conflicts in the database running two modules with same purpose...

2ndly that issue of auto posting first I tried using this instead

Code:

$result = $db->sql_query('INSERT INTO '.$prefix.'_story VALUES (NULL, \''.$catid.'\', \''.$name.'\', \''.$subject.'\', now(), \''.$story.'\', \''.$storyext.'\',\''.$topic.'\',\''$name.'\', \''.$alanguage.'\')')

This didn't load the page (white page) so am sure I didn't do it right as I dropped lots of '0', '0', etc as I could not figure out whether they mattered in this code or not

Next i tried the original lil modified

Code:

$result = sql_query("insert into ".$prefix."_stories values (NULL, '$catid', '$name',


'$subject', now(), '$story', '$storyext', '0', '0', '$topic', '$name', '', '0', '$alanguage', '0',


'0', '0', '0', '0')");

This did load the page but upon posting i got

_ERROR

So can anyone convert

Code:

$result = sql_query("insert into ".$prefix."_stories values (NULL, '$catid', '$name',


'$subject', now(), '$story', '$storyext', '0', '0', '$topic', '$name', '', '0', '$alanguage', '0',


'0', '0', '0', '0')", $dbi);

into something that Raven Nuke accepts I am not much into coding so not very sure what to change and where...

Posted: Sat Mar 10, 2012 4:47 am

I guess what fkelly said

Quote:

Right now, the submit news module posts proposed news articles to the queue table. You'd need to swap that out and post them to the stories table instead.

This falls into the above code I guess

But

Quote:

You'd want to compare the structure of the queue table and the stories table ... I'm not sure if they are totally identical.

Yeah this is true but not quite sure what changes to implement i guess those '0's have got to do with it

Quote:

The news/admin/index.php program has a poststory function that you might be able to cannibalize for the update.

Again not much of a coder I am so i presume both files need to be modified?

Posted: Mon Mar 12, 2012 5:21 pm

New is that
$result = $db->sql_query("sql code in here")

you should keep all the zeros otherwise it won't work , it's like trying to use a smaller lid than the opening , the lid will fall through

the values entered must be the exact shame shape as the table

Posted: Wed Mar 14, 2012 4:07 am

Converted for you.

Code:

$result = $db->sql_query("insert into ".$prefix."_stories values (NULL, '$catid', '$name',


'$subject', now(), '$story', '$storyext', '0', '0', '$topic', '$name', '', '0', '$alanguage', '0',


'0', '0', '0', '0')");