vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Pull the last paid subsciber (https://vborg.vbsupport.ru/showthread.php?t=78156)

Jenta 03-15-2005 11:50 AM
Pull the last paid subsciber
 
Im trying to show the last paid subscriber in the What's Going On site statistics area. I believe this can be done with some template edits alone. Perhaps something in phpinclude_start like this code someone posted at .com

PHP Code:
if (THIS_SCRIPT == 'index' OR THIS_SCRIPT == 'forumdisplay')

{

// GET FORUM COUNTERS

$forumcounts= $DB_site->query("SELECT forumid, replycount, threadcount

FROM " . TABLE_PREFIX . "forum

");

// SET VALUES

while ($forumcount = $DB_site->fetch_array($forumcounts))

{

$forumreply[$forumcount[forumid]] = $forumcount[replycount];

$forumthread[$forumcount[forumid]] = $forumcount[threadcount];

}

} 
Im guessing it would have to go like this...

SELECT * FROM `subscriptionlog` WHERE ??????

take the next auto_increment, subtract 1, then pull the userid


Then add a phrase like the newest registered user one edit the forumhome template

Standard Phrase: welcome_to_our_newest_member_x

Varname $vbphrase[welcome_to_our_newest_member_x]

Text Welcome to our newest member, <a href="{1}">{2}</a>

in forumhome

<div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div>

Add this under

<div>Welcome to our newest paid subscriber: <a href="member.php?$session[sessionurl]u=userid">username</a></div>


Anyone know how?

Thanks!

sabret00the 03-17-2005 06:18 PM
urghh if it's in the table you just said then it's as simple as

phpinclude_start
PHP Code:
$latest_subscription = $DB_site->query_first("SELECT subscirptionlog.subsciptionid, user.username, subscirptionlog.userid FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = subscirptionlog.userid) ORDER BY subsciptionlog.subscriptionid DESC LIMIT 1"); 
then just put
HTML Code:
<a href="member.php?$session[sessionurl]u=$latest_subscription[userid]>$latest_subscription[username]</a> is the latest subscriber at $vboptions[bbtitle].
:) hope it helps as i never read your think completely.

Jenta 03-17-2005 08:43 PM
sweet that worked, had to do some minor typo fixes and something else but its working
ill post the minor changes to ur code in a bit

thanks a million!

sabret00the 03-18-2005 08:01 AM
no problem :)

Jenta 03-20-2005 06:29 PM
in template phpinclude_start

Code:
if (THIS_SCRIPT == 'index')
{
        $latest_subscription = $DB_site->query_first("SELECT subscriptionlog.subscriptionid, user.username, subscriptionlog.userid
        FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = subscriptionlog.userid)
        ORDER BY subscriptionlog.subscriptionlogid
        DESC LIMIT 1");
}
In template forumhome add something like this in the what's going on area...

Code:
<div><strong>Latest Contributer: <a href="member.php?$session[sessionurl]u=$latest_subscription[userid]>$latest_subscription[username]</a></strong></div>


All times are GMT. The time now is 04:06 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04470 seconds
  • Memory Usage 1,733KB
  • 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
  • (1)bbcode_html_printable
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete