Latest post id and thread id on index page

[freakyshiat]

Originally posted by Zzed
LOL @ g-kforce2k2

And you spelled sessionhash as sessionhas.

I fixed the error but no go

[g-force2k2]

lol thanks Zzed

btw Fazle just makre sure you fixed the sessionhash in mine and also i'll test in a few for you

g-force2k2

[freakyshiat]

Originally posted by g-force2k2
lol thanks Zzed

btw Fazle just makre sure you fixed the sessionhash in mine and also i'll test in a few for you

g-force2k2

yeah i fixed the sessionhash but no go

thanks for helping me...and if you do get it working, tell me how to do the postid also if u have time

thanks again

[g-force2k2]

Here's a screenshot of what i believe that you wanted as well as the coding Enjoy...

---------------------
open index.php
---------------------

find:

// get total posts

above it add:

PHP Code:

// +++++++ Last Post Thread ID [ Start ] +++++++
$getid=$DB_site->query("SELECT threadid FROM thread ORDER BY lastpost DESC LIMIT 1");
  while ($threads = mysql_fetch_array($getid)) {
    $lastthread="<a href=\"showthread.php?s=$session[sessionhash]&threadid=$threads[threadid]\">$threads[threadid]</a>";
  }
$getpid=$DB_site->query("SELECT postid FROM post ORDER BY postid DESC LIMIT 1");
  while ($postings = mysql_fetch_array($getpid)) {
    $lastpost="<a href=\"showthread.php?s=$session[sessionhash]&postid=$postings[postid]\">$postings[postid]</a>";
  }
// +++++++ Last Post Thread ID [ End ] +++++++ 


Then open up the forumhome template and place

PHP Code:

$lastpost  $lastthread 


where ever you want you can customize from there im sure you can

g-force2k2

[Chris M]

Scrap that...Dont work

Satan

[Chris M]

There is an update, should you prefer to use templates...

Input this code instead of g-force's :

PHP Code:

// +++++++ Last Post Thread ID [ Start ] +++++++
$getid=$DB_site->query("SELECT threadid FROM thread ORDER BY lastpost DESC LIMIT 1");
  while ($threads = mysql_fetch_array($getid)) {
  eval("\$lastthread = \"".gettemplate("lastthread_id")."\";");
}
$getpid=$DB_site->query("SELECT postid FROM post ORDER BY postid DESC LIMIT 1");
  while ($postings = mysql_fetch_array($getpid)) {
  eval("\$lastpost = \"".gettemplate("lastpost_id")."\";");
  }
// +++++++ Last Post Thread ID [ End ] +++++++ 


Now make 2 templates, :

lastthread_id
<a href="showthread.php?s=$session[sessionhash]&threadid=$threads[threadid]">$threads[threadid]</a>

lastpost_id
<a href="showthread.php?s=$session[sessionhash]&postid=$postings[postid]">$postings[postid]</a>

Now just put $lastthread and $lastpost in the forumhome template...

Satan

[g-force2k2]

lol thanks hellsatan i like using both but i think that eval() uses queries so i thought i'd just give it to himi in that form... but one thing yours is definately easier to customize

g-force2k2

[Chris M]

Yeh...

I changed it anyway, to give the last post...

Satan

[g-force2k2]

yeah but he doesn't want the name he just said he wanted the id number :P at least thats what he said... just the last threadid and postid ;\ dunno

g-force2k2

[Chris M]

I just added Most viewed thread too

I like those kinda thingys

I wonder if you can put variables in your Signature?

Satan