View Issue Details

IDProjectCategoryView StatusLast Update
0006778phpList 3 applicationInterface - Frontendpublic31-10-12 15:06
Reportersiggi 
PrioritynormalSeverityfeatureReproducibilityalways
Status newResolutionopen 
Product Version2.10.2 
Target VersionFuture developmentsFixed in Version 
Summary0006778: ordering subscribe pages
Descriptionorder by id ASC invented in line 217 lists/index.php

The sorted order of different subscription-pages is first in first out from database. To get it sorted I invented an order-statement. Now I can get last in is first out.

See where it happens:

if ($id) $data = PageData($id);
print '<title>'.$GLOBALS["strSubscribeTitle"].'</title>';
print $data["header"];
//order by id ASC added by SG for sorted Output of sbscription_pages
$req = Sql_Query(sprintf('select * from %s where active order by id ASC ',$tables["subscribepage"]));
//
if (Sql_Affected_Rows()) {
while ($row = Sql_Fetch_Array($req)) {
$intro = Sql_Fetch_Row_Query(sprintf('select data from %s where id = %d and name = "intro"',$tables["subscribepage_data"],$row["id"]));
print $intro[0];
printf('

./?p=subscribe&id=%d

',$row["id"],$row["title"]);
}
TagsNo tags attached.

Relationships

related to 0002705 closed PHPList v2.11 release 

Activities

michiel

30-06-06 13:08

manager   ~0014966

yes, but that would require allowing to change the order of subscribe pages in the backend, in case you want it in a different order.