Help with "wanted" Template

[jazz74]

I'm struggling with this - I can see the for sale template is 0 - and the default - this works fine. I can see wanted template is 1 (showproduct1, editproduct1 etc......)

Is showproduct1 already set up as a wanted template? (I can see "wanted" in the language file for this) but when I place a wanted advert - it uses a wanted template to upload (eg no pics) but as soon as it is is uploaded and viewed it is laid out as a for sale advert template - and when you try and edit a wanted template it goes to edit a for sale template.

Have I missed something - or is this not already set up?

When I set the categories up I selected they would be "wanted" categories in admin - and in ad types it is set as "enabled"

The templates aren't the easiest to work with so I'm struggling to get to grips with this

[Chuck S]

Hello

In editproduct.php lines 202-204 are this

$query = "SELECT
catname,extra1,extra2,extra3,extra4,extra5,extra6,adhigh,adbold,adital
FROM {$Globals['pp_db_prefix']}categories where id='$pcat'";
$resulta = ppmysql_query($query,$link);
list( $thecatname, $Globals['extra1name'], $Globals['extra2name'],
$Globals['extra3name'], $Globals['extra4name'], $Globals['extra5name'],
$Globals['extra6name'], $adhigh, $adbold, $adital ) =
mysql_fetch_row($resulta);

Change them to this

$query = "SELECT
catname,extra1,extra2,extra3,extra4,extra5,extra6,template,adhigh,adbold,adital
FROM {$Globals['pp_db_prefix']}categories where id='$pcat'";
$resulta = ppmysql_query($query,$link);
list( $thecatname, $Globals['extra1name'], $Globals['extra2name'],
$Globals['extra3name'], $Globals['extra4name'], $Globals['extra5name'],
$Globals['extra6name'], $Globals['cattemp'], $adhigh, $adbold, $adital )
= mysql_fetch_row($resulta);

[jazz74]

thankyou Omegatron - I've added that change into editproduct.php and that resolves the editing template - so now I select Wanted to place ad - once submitted it shows as a "For Sale"- and is edited as a Wanted template

Looking at it, it seems to be using my wanted template as I added an extra field "budget" in and this is showing - but the "for sale by" is there instead of "wanted by" - the showproduct1.php language file says "wanted by" so not sure why its still not using this.

[jazz74]

sorted

I applied your suggested change to editproduct.php to the showproduct.php aswell line 111 but instead of $pcat as the existing lines were using $cat I put that

so I changed showproduct.php line 111-114 to this

$query = "SELECT
catname,extra1,extra2,extra3,extra4,extra5,extra6,template,adhigh,adbold,adital
FROM {$Globals['pp_db_prefix']}categories where id='$cat'";
$resulta = ppmysql_query($query,$link);
list( $thecatname, $Globals['extra1name'], $Globals['extra2name'],
$Globals['extra3name'], $Globals['extra4name'], $Globals['extra5name'],
$Globals['extra6name'], $Globals['cattemp'], $adhigh, $adbold, $adital )
= mysql_fetch_row($resulta);

it now seems to work - but please tell me if I've done something stupid and need to undo!

[Chuck S]

well I dont think you want to redefine any product variables like $pcat

However the change to the category query like I posted would be correct.