vb.org Archive - this should be very simple.....

ok this might help alittle.... all i want is the first hack below working with the second hack

Code:

*********************************

In showthread.php, replace this:

*********************************

$getpostids=$DB_site->query("

        SELECT post.postid FROM post

        WHERE post.threadid='$threadid' AND post.visible=1

        ORDER BY dateline $postorder LIMIT ".($limitlower-1).",$perpage

");



if ($limitupper>$totalposts) {

  $limitupper=$totalposts;

  if ($limitlower>$totalposts) {

    $limitlower=$totalposts-$perpage;

  }

}

if ($limitlower<=0) {

  $limitlower=1;

}

$postids="post.postid IN (0";

while ($post=$DB_site->fetch_array($getpostids)) {

  $postids.=",".$post['postid'];

}



$postids.=")";

*********************************

with this:

*********************************

$getpostids=$DB_site->query("

        SELECT post.postid,post.userid AS postuserid FROM post

        WHERE post.threadid='$threadid' AND post.visible=1

        ORDER BY dateline $postorder LIMIT ".($limitlower-1).",$perpage

");



if ($limitupper>$totalposts) {

  $limitupper=$totalposts;

  if ($limitlower>$totalposts) {

    $limitlower=$totalposts-$perpage;

  }

}

if ($limitlower<=0) {

  $limitlower=1;

}

$postids="post.postid IN (0";

$hackuserids="(0";

while ($post=$DB_site->fetch_array($getpostids)) {

  $postids.=",".$post['postid'];

  $hackuserids.=",".$post['postuserid'];

}

$postids.=")";

$hackuserids.=")";



$hacks=array();

$hackcounts=$DB_site->query("SELECT postuserid,COUNT(*) AS totalhacks FROM thread WHERE forumid IN (x) AND postuserid IN $hackuserids GROUP BY postuserid");

while ($hackcount=$DB_site->fetch_array($hackcounts)) {

  if (!isset($hackcount[totalhacks]))

    $hackcount[totalhacks]=0;

  $hacks["$hackcount[postuserid]"]=$hackcount[totalhacks];

}

$hacks[0]=0;

*********************************



Still in showthread.php, add this:

*********************************

  if ($hacks["$post[userid]"]!='') {

    $post[hacks]="<a href=\"member.php?s=$session[sessionhash]&action=getinfo&userid=$post[userid]\">".$hacks["$post[userid]"]."</a>";

  } else {

    $post[hacks]=0;

  }

*********************************

right after this:

*********************************

while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {

*********************************



Then use $post[hacks] in the postbit template to show the number of threads the user started in that forum. It will link to the user profile if he has more than 0 threads.

i want that code above to display in this type of form

Code:



<?php



//..........Top X Posters  v0.0.4..........\\

//......by Kevin (kevin@tubescan.com)......\\



// For vBulletin version 2, beta 3

// (c) 2001 Jelsoft Enterprises, Ltd.



// vBulletin.com thread: http://www.vbulletin.com/forum/showt...threadid=12067



///////////// CHANGE LOG /////////////

//

// New in version 0.0.4

// -- Fixed alternating colors so they are horizontal, not vertical

// -- Changed $path to $url and $path2 to $path to make variables easier

// -- Added a seperate header row color

//

// New in version 0.0.3

// -- Added option to exclude admins from list of posters

//

// New in version 0.0.2

// -- Fixed a small bug with the path.

//

// New in version 0.0.1

// -- Released! :)

//

/////////// END CHANGE LOG ///////////



//////// CONFIG EXPLANATION //////////

//

// a] $maxposters > This is the number of posters you want to show.

// b] $hc > The head row color.

// c] $bc1 and $bc2 > These are the first and second alternating color.

// d] $text and $link > Set the colors of the main text and the color of the links. Make sure this color is visible on both alternating colors.

// e] $font > This is the font(s) to use for display. You can set specific fonts (e.g. Verdana, Arial, etc.) or general font-families (e.g. sans-serif, serif).

// f] $fontsize > Set a point size for your font. Size 8 is about equivelant to <font size=1>. Anything below about 6 will basically be undreadable, so be careful.

// g] $url > This is the URL to your board directory. This is not the path to config.php! Do not put a trailing slash, either.

// h] $path > This *is* the path to your config.php file. This should include the /admin part. NO TRAILING SLASH! (May need a leading slash)

// i] $admins > Set this to "1" to show admins on the list of top posters. Set this to "0" to NOT show admins on the list.

//

////// END CONFIG EXPLANATION ////////



/////////////// CONFIG ///////////////

//

$maxposters = "10"; // change this to the number of posters you want to show. for a top 10 listing, set it to 10, etc.

$hc = "#990000"; // change to head row color.

$bc1 = "#777777"; // change to first alternating color.

$bc2 = "#555555"; // change to second alternating color.

$text = "#CCCCCC"; // change to text color.

$link = "#EEEEEE"; // change to link color.

$font = "Verdana,Helvetica,sans-serif"; // change to fonts you want. use serif or sans-serif for general, or use specific fonts names.

$fontsize = "8pt"; // change to font size you want. 8 is about the minimum; go up from there. 1 will not even show up.

$url = "http://www.webserver.org/vb/forums"; // path to your board files. (e.g. index.php, member.php, etc.) may need a starting slash. *do not* put an ending slash on!

$path = "/home/pathforconfig/vb"; // path to your config.php file. may need a starting slash. *do not* put an ending slash on!

$admins = "1"; // change this to "0" to leave admins off the list of top posters.

//

///////////// END CONFIG /////////////



require("$path/config.php");

$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Unable to connect to database");

mysql_select_db($dbname) or die("Unable to select database $dbname");



if ($admins == "1") {

        $exq = mysql_query("SELECT usergroupid FROM usergroup WHERE cancontrolpanel='1'");

        $exr = mysql_result($exq,0,0);

        $exn = "WHERE usergroupid<>$exr";

}



echo("<table border=0 cellpadding=4 cellspacing=0><tr><td align=\"center\" bgcolor=\"$hc\"><b style=\"color: $text; font-family: $font; font-size: $fontsize\"><i>Username</i></b></td><td align=\"center\" bgcolor=\"$hc\"><b style=\"color: $text; font-family: $font; font-size: $fontsize\"><i>Posts</i></b></td></tr>");



$postsresult = mysql_query("SELECT username,posts,userid FROM user $exn ORDER BY posts desc LIMIT 0,$maxposters") or die("Unable to complete query");

while ($topposters = mysql_fetch_array($postsresult)):

        if (($counter++ % 2) != 0) {

                $bc=$bc1;

        } else {

                $bc=$bc2;

        }

        echo("<tr><td align=\"center\" bgcolor=\"$bc\" style=\"color: $text; font-family: $font; font-size: $fontsize\"><a href=\"$url/member.php?&action=getinfo&userid=$topposters[userid]\" style=\"color: $link\">$topposters[username]</a></td><td align=\"center\" bgcolor=\"$bc\" style=\"color: $text; font-family: $font; font-size: $fontsize\">$topposters[posts]</td></tr>");

endwhile;

echo("</table>");



?>

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01009 seconds Memory Usage 1,760KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: