remove sponsor listings from latest sites

[mighty_falcon]

hi there,

can anyone guide me as to how to go by to make all the sponsor listings to not show up in the latest and updated sites block? and in the top rated and hot pages as well?

tnx alot

[mighty_falcon]

hi there,

can anyone guide me as to how to go by to make all the sponsor listings to not show up in the latest and updated sites block? and in the top rated and hot pages as well?

tnx alot

anyone?? i am willing to offer $$ for such a hack

[esm]

in link.class.php:

find the DisplayTopRatedListing function and change

$this->query .= ") and suspended = 0 order by rating desc limit $this->top_rated_limit";

to

$this->query .= ") and suspended = 0 and sp_cat != 1 order by rating desc limit $this->top_rated_limit";

also change an almost identical line existing in DisplayHotListing.



Then, look at the DisplayNewListing function. change

where (new = 1 and suspended = 0 and (date like ...

to

where (new = 1 and suspended = 0 and sp_cat != 1 and (date like

I think there are about 4 of those



.

[mighty_falcon]

tnx alot esm !!

worked like a charm can you please also let me know what files i should edit in order to make the sponsored links not come up on the new & updated links block that you find on the index ? tried to look in the link.class but without much luck

tnx

[esm]

apply the same hack to this section of code in the index.php file ( which is located in the same folder as browse.php ):

$new_links_obj = new clsLink;
$new_links_obj->InitDB($dbServer,$dbHostname,$dbUsername,$dbPassw ord,$dbName);

$new_links_obj->table_name = "idx_link";
$new_links_obj->category_table_name = "idx_category";
$new_links_obj->max_rows = $main_new_links;
$new_links_obj->template = $msg["10001"];
$new_links_obj->new_link_number = 1;
$query = "select distinct *
from idx_link
where suspended = 0 and sp_cat != 1 and (new=1 or updated=1)
order by date desc, last_updated desc limit $main_new_links";

[mighty_falcon]

as always esm, worked flawlessly

tnx a ton for your help !!

[esm]

glad it worked for you...


.