[SOLVED] Complete solution to approve the story after being submitted

[hotelsmadbar]

Hello!

Can you help me please? I've modifid the fist step but now i can't change the next code in phpmyAdmin. I put the type (ENUM) and the value 'pending' in the field ´name´ | and put the type (ENUM) and the value 0 in the field ´total´ and the message error is:

#1062 - Duplicate entry '' for key 1

Please i need to undertans this step.

Regards,

Carlos

Then modify the “table_totals” to add a name and total for “pending”

insert into table_totals (`name`, `total`) values ('pending', 0); 

[redwine]

Originally Posted by hotelsmadbar

Hello!

Can you help me please? I've modifid the fist step but now i can't change the next code in phpmyAdmin. I put the type (ENUM) and the value 'pending' in the field ´name´ | and put the type (ENUM) and the value 0 in the field ´total´ and the message error is:

#1062 - Duplicate entry '' for key 1

Please i need to undertans this step.

Regards,

Carlos

Then modify the “table_totals” to add a name and total for “pending”

insert into table_totals (`name`, `total`) values ('pending', 0); 

The first part of your question is how to alter the table_links and add a "pending" value to it. This is not manually done. When you login to phpmyadmin, the default values of the link_status are as follows:

link_status` enum('discard','queued','published','abuse','duplicated') NOT NULL default 'discard'

So we want to add a "pendig" value to it. We just run the following sql code from within the database (copy the sql code below and paste it in the sql window and run it):

alter TABLE table prefix_links change link_status link_status enum('discard','queued','published','abuse','duplicated','pending') NOT NULL default 'discard';

Note that the prefix is what you gave your tables upon installation of pligg. The default is "pligg_".

For the second part, just run the sql code from the table_totals (copy the sql code below and paste it in the sql window and run it):

insert into table_totals (`name`, `total`) values ('pending', 0);

let me know how it goes.

[kleinhev]

I was wondering if you have the same solution also for approving comments after bing submitted?

Originally Posted by redwine

I've already posted a quick fix answering few questions about this subject:
How to set admin approval for all stories

Then, I thought about providing a complete solution for it.

This is applicable only if you want, as administrator, to verify and approve the story before appearing in the “Upcoming”.

The files involved are:

1. /submit.php
2. /libs/html1.php
3. /templates/yourtemplate/admin_templates/admin_links_center.tpl
4. /admin_links.php

**** WARNING ****
Always backup your files before making any modifications
First, change the table:

alter TABLE table prefix_links change link_status link_status enum('discard','queued','published','abuse','duplicated','pending') NOT NULL default 'discard';

Then modify the “table_totals” to add a name and total for “pending”

insert into table_totals (`name`, `total`) values ('pending', 0); 

Now, we have to make sure that upon finishing the 3rd step of submitting the story, the story status is set to “pending” instead of queued, and the totals in the totals table is adjusted.

Open /submit.php and locate function do_submit3() {
Change this code:

totals_adjust_count($linkres->status, -1);
totals_adjust_count('queued', 1);
$linkres->status='queued'; 

Change to:

totals_adjust_count($linkres->status, -1);
totals_adjust_count('pending', 1);
$linkres->status='pending'; 

Note: If you started having grey hair or more grey hair from verifying the stories, all you have to do to revert back is changing the above changes to the original code above it. All the below modifications can remain and will be used if you want to manually change the status of the story to “pending” instead of “discard”

Save and close.

Now, we have to modify the function totals_regenerate() to reflect this in the table_links and table_totals.

Open /libs/html1.php and locate function totals_regenerate(){

Right before the if(caching == 1){

Add this code:

$name = 'pending';
$count = $db->get_var("SELECT count(*) FROM " . table_links . " WHERE link_status='$name';");
$db->query("UPDATE `" . table_totals . "` set `total` = $count where `name` = '$name';");
$cached_totals[$name] = $count; 

Save and close.

Up to here, any new submitted story is “pending”. The administrator has to review it and, if approved, change the status to “queued”.

We need to modify few other files to filter (in News Management) by “pending” and also show the radio button to reverse a published or queued story to “pending”.

Open /templates/yourtemplate/admin_templates/admin_links_center.tpl

We have to add an option to the select (dropdown) to be able to filter by “pending”

Add this code anywhere you want after <select name="filter">:

<option value="pending" {if $templatelite.get.filter eq "pending"} selected="selected" {/if}>Pending</option> 

And few lines down, change this code (add the code in red):

<tr><th>{#PLIGG_Visual_View_Links_Status#}</th><th>{#PLIGG_Visual_View_Links_Author#}</th><th>{#PLIGG_Visual_View_Links_New_Window#}</th><th><center>Publish</center></th><th><center>Queued</center></th><th><center>Pending</center></th><th><center>Discard</center></th></tr> 

Change this code (add the code in red)

Find this bloc of code and add the code (in red)
 
   <tr>     
               <td>{$template_stories[id].link_status}</td>
               <td><a href="{$URL_user, $template_stories[id].link_author}">{$template_stories[id].link_author}</a></td>
               <td><a href="{$my_pligg_base}/story.php?title={$template_stories[id].link_title_url}" target="_blank">{$template_stories[id].link_title}</a></td>
               <td><center><input type="radio" name="link[{$template_stories[id].link_id}]" id="link-{$template_stories[id].link_id}" value="publish"></center></td>
               <td><center><input type="radio" name="link[{$template_stories[id].link_id}]" id="link-{$template_stories[id].link_id}" value="queued"></center></td>
 <td><center><input type="radio" name="link[{$template_stories[id].link_id}]" id="link-{$template_stories[id].link_id}" value="pending"></center></td>
               <td><center><input type="radio" name="link[{$template_stories[id].link_id}]" id="link-{$template_stories[id].link_id}" value="discard"></center></td>
   </tr> 

Find this bloc of code and add the code (in red)

<center><a href="javascript:mark_all_publish()">Mark all for Published</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="javascript:mark_all_queued()">Mark all for Queued</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="javascript:mark_all_pending()">Mark all for Pending</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="javascript:mark_all_discard()">Mark all for Discarded</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="javascript:uncheck_all()">Uncheck All</a></center> 

Finally, add this function at the end of the file:

function mark_all_pending() {
      for (var i=0; i< document.bulk_moderate.length; i++) {
                  if (document.bulk_moderate[i].value == "pending") {
                              document.bulk_moderate[i].checked = true;
                  }
      }
} 

And modify this function (add the code in red):

function uncheck_all() {
      for (var i=0; i< document.bulk_moderate.length; i++) {
                  if ((document.bulk_moderate[i].value == "queued")||(document.bulk_moderate[i].value == "pending")||(document.bulk_moderate[i].value == "discard")|| (document.bulk_moderate[i].value == "publish")){
                              document.bulk_moderate[i].checked = false;
                  }
      }
} 

Save and close.

Now open /admin_links.php

Locate if(isset($_GET["filter"])) {

And add this (to be able to filter by “pending” from the “News Management”:

case 'pending':
      $filtered = $db->get_results("SELECT link_id FROM " . table_links . " where link_status = 'pending' ORDER BY link_date DESC LIMIT $offset,25");
      $rows = $db->get_var("SELECT count(*) FROM " . table_links . " where link_status = 'pending'");
break; 

Locate if ($_GET['action'] == "bulkmod") {

And add this code at the end of the foreach

elseif ($value == "pending") {
      $db->query('UPDATE `' . table_links . '` SET `link_status` = "pending" WHERE `link_id` = "'.$key.'"');
} 

Save and Close.

Upload the files listed at the top to your dev server and test. It works like a charm.

[method20]

Great job with this. This is an absolute necessity IMO. Thank you very much!

[method20]

Awesome on the tag fix! I highly recommend everyone that gets submitted articles to do this mod.

[federrer]

works neatly.. thanks..
i have one question.. do you have any solution for approving the comments after being submitted ?

[valipe]

awesome work......Thank you very much