Add new array in details.html {hits2}= {image_hits)+1000

[Sun Zaza]

Nope, the same result. it does not show!

[thunderstrike]

Post edit. Next time, please say all detail. You no say for use $hits2 in code.

[Sun Zaza]

Next time, please say all detail. You no say for use $hits2 in code

I was talking the hole time about $hits2 and that was my request. It does not matter.

Nothing is showing yet. Here is my new code, maybe you can see what we miss here:

Code: [Select]

$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_date, i.image_active, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")."
        FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
        LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
        WHERE i.image_active = 1 AND i.image_honor = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
        ORDER BY i.image_date DESC
        LIMIT 20";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);
if (!$num_rows)  {
   $featured_images_list = $lang['no_images'];
}
 
else  {
   //$featured_images_list = "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\"><tr><td>Image Name</td><td>Current Hits</td><td>Hits +1000</td></tr>";
 //$featured_images_list .= "<tr><td><a href=\"".$site_sess->url(ROOT_PATH."details.php?image_id=".$image_row['image_id'])."\">".format_text(trim($image_row['image_name']), 2)."</a></td><td>".$image_row['image_hits']."</td><td>$hits2</td></tr>";
   
   $new_images .= $site_template->register_vars("hits2", (isset($image_row['image_hits'])) ? $image_row['image_hits'] + 1000 : "");
   while ($image_row = $site_db->fetch_array($result)){
   
   $hits2 = $site_template->register_vars("hits2", (isset($image_row['image_hits'])) ? $image_row['image_hits'] + 1000 : "");
   $featured_images_list .= "<tr><td><a href=\"".$site_sess->url(ROOT_PATH."details.php?image_id=".$image_row['image_id'])."\">".$image_row['image_name']."</a></td><td>".$image_row['image_hits']."</td><td>" .$hits2. "</td></tr>";
}                                  
}
  $featured_images .= "</table>\n";

$site_template->register_vars("featured_images_list", $featured_images_list);
unset($featured_images_list);


[Sun Zaza]

In your code you used hit2, it should be actualy shits2.

[thunderstrike]

Ok I miss post:

http://www.4homepages.de/forum/index.php?topic=19358.msg104767#msg104767

so:

$hits2 = $site_template->register_vars("hits2", (isset($image_row['image_hits'])) ? $image_row['image_hits'] + 1000 : "");
   $featured_images_list .= "<tr><td><a href=\"".$site_sess->url(ROOT_PATH."details.php?image_id=".$image_row['image_id'])."\">".format_text(trim($image_row['image_name']), 2)."</a></td><td>".$image_row['image_hits']."</td><td>" .$hits2. "</td></tr>";

good ?

[Sun Zaza]

No! Very strange!

[thunderstrike]

Ok, change:

Code: [Select]

$hits2 = $site_template->register_vars("hits2", (isset($image_row['image_hits'])) ? $image_row['image_hits'] + 1000 : "");

for:

Code: [Select]

$hits2 = (isset($image_row['image_hits'])) ? $image_row['image_hits'] + 1000 : "";


[Sun Zaza]

Finaly. Thank you Thunderstrike.
Now I can go to bed. Good night!
(Nothing is impossible!)