Does anybody know where to find this

A place to discuss and receive support for the Web Auction application.

Does anybody know where to find this

Postby silverb0t » Mon Aug 29, 2011 11:00 am

I tried "windows grep" still cannot find the text on my watch list the high bid and high bidder want to change it to highest bid and highest bidder

here is the image:

Image

thank you in advance really love this auction simple yet powerfull

-
silverb0t
 
Posts: 12
Joined: Tue Aug 23, 2011 12:09 pm

Re: Does anybody know where to find this

Postby shannah » Wed Aug 31, 2011 7:20 pm

templates/watch_list.html
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: Does anybody know where to find this

Postby silverb0t » Thu Sep 01, 2011 5:51 am

shannah wrote:templates/watch_list.html


Hi Steve,

heres the content of the templates/watch_list.html:

{use_macro file="Dataface_Main_Template.html"}
{fill_slot name="main_section"}
<h1>My Watch list</h1>
<p>Below is a list of items that you have bid on already.</p>
{$grid}
{/fill_slot}
{/use_macro}



I cannot find the text "High Bid" and "High Bidder" I was going to change that text.
silverb0t
 
Posts: 12
Joined: Tue Aug 23, 2011 12:09 pm

Re: Does anybody know where to find this

Postby silverb0t » Fri Sep 02, 2011 8:30 am

Hi Steve I was really trying to figure out hours and hours I cannot find that text "High Bid" and "Higher Bidder" I would to change that text. :cry:
silverb0t
 
Posts: 12
Joined: Tue Aug 23, 2011 12:09 pm

Re: Does anybody know where to find this

Postby shannah » Sun Sep 04, 2011 10:02 pm

Oh.. yes. Looks like these are taken directly from the SQL query in
actions/watch_list.php

Unfortunately you can't just change the labels in the query because they are used as part of the query . However you can manually assign the labels for the RecordGrid (the component used to display the table). Only the line:

Code: Select all
$grid = new Dataface_RecordGrid($data);


You can add a third parameter with the column labels. E.g:
Code: Select all
$grid = new Dataface_RecordGrid($data, null, array(
    'product_id' => 'Product ID',
    'product_name' => 'Product Name',
    'high_bidder' => 'High Bidder'

));

etc...


But you'll need to make sure that you have a label for every column.

-Steve
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: Does anybody know where to find this

Postby silverb0t » Thu Sep 08, 2011 8:34 am

shannah wrote:Oh.. yes. Looks like these are taken directly from the SQL query in
actions/watch_list.php

Unfortunately you can't just change the labels in the query because they are used as part of the query . However you can manually assign the labels for the RecordGrid (the component used to display the table). Only the line:

Code: Select all
$grid = new Dataface_RecordGrid($data);


You can add a third parameter with the column labels. E.g:
Code: Select all
$grid = new Dataface_RecordGrid($data, null, array(
    'product_id' => 'Product ID',
    'product_name' => 'Product Name',
    'high_bidder' => 'High Bidder'

));

etc...


But you'll need to make sure that you have a label for every column.

-Steve



Thank You very much Steve the steps you gave works perfect.

I tried also to edit the sql query but seems to work perfect also the output was Highest Bid and Highest Bidder works perfect I dont know if this will affect the system.

heres what I changed:



$sql = "select p.product_id, p.product_name, concat('\Php',format(high_bid,2)) as highest_bid, highest_bidder from products p inner join
(
select product_id, $highbidamount as high_bid from bids group by product_id
) as hb
on p.product_id=hb.product_id
inner join
(
select product_id, username as highest_bidder from bids b where not exists (select * from bids where product_id=b.product_id and $highbidderq)



//-------------------

while ($row = mysql_fetch_assoc($res) ) {
if ( $row['highest_bidder'] != getUsername() ) $row['highest_bidder'] = '';
$data[] = $row;

}
silverb0t
 
Posts: 12
Joined: Tue Aug 23, 2011 12:09 pm


Return to Web Auction Discussion

Who is online

Users browsing this forum: No registered users and 24 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved