Auto-approving some adverts

[cellularnews]

I wanted to be able to auto-approve some advertisers so made the following small modification.

This will auto-approve job adverts that are submitted by an advertiser that currently has a live job advert.

/include/posts.inc.php

in

Code:

function JB_insert_post_data($insert_mode='EMPLOYER') {

Just above

Code:

if ($_REQUEST['app_type']==false) {

add the following code:

Code:

$sql="SELECT COUNT(*) AS livejobs FROM posts_table WHERE approved='Y' AND expired='N' AND user_id=".$user_id;
$result = JB_mysql_query ($sql) or die(mysql_error().$sql);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
if ($row[livejobs]>0) { $approved = 'Y'; }