vb.org Archive - View Single Post

Ivan Beser · #3 09-01-2014, 06:15 AM

Quote:

Originally Posted by Dead Eddie

Yes. What do you actually need help with? How much PHP do you know?

Hello Dead Eddie,

thank you for your quick reply.
My PHP-Knowlege is not that good. Reading and edit a existing code is not a big deal, but write one by my self is a little to much for me.

I looked into the member.php and widget_memberslist and try to get a code sniped to edit it into order by desc - limit 5 or something like that.
Unfortunately I didn't find anything that helped me.

A big question for me is also if it is safe to make a php module in Site Edit with a DB query inside or rather how xould I use the db query within vB.

So I think I need a lot of help

Edit: Find a example at vBulletin.com that helps me a little...

http://www.vbulletin.com/forum/forum...-or-php-widget

Hopfully vB5 is working like this too... But it would be fine to have a latest-member-module to choose in "Edit site".

Try to make a php-module and call for help if I need it :-)

--------------- Added [DATE]1409605624[/DATE] at [TIME]1409605624[/TIME] ---------------

Ok, this is my idea or some code I edit from the Mod "Member Liste for VB5" (Thanks to the Developer wdwms)

But it shows nothing so I need your help!

PHP Code:


			
<?
$max_results = 5;
//*** Display for Logged in Users only
//*** Set to 0 if you want the memberlist to only be shown to those users that are logged in
$showto_loggedout = 0;
//*** Check if user is logged in
$vbsession = $HTTP_COOKIE_VARS[bbsessionhash];
$query = vB::$db->query_first("Select loggedin from ".$vb_prefix."session where sessionhash = '$vbsession'");
$result2=mysql_db_query("$vb_table", "$query");
$loggedin=mysql_result($result2,0,"loggedin");
?>
<style> <!--
.dbhover {border: 1px solid #b4b4b4 !important;}
.dbhover:hover { background-color: #E5E7E8; }
--> </style>
<? 
//*** //$total_results = mysql_num_rows($result); Anzahl User gesamt
$num=mysql_numrows($result2);
$total_results=mysql_numrows($result2);
//*** Falls eingeloggt oder auch nicht registrierten Nutzern zeigen
if ($loggedin || $showto_loggedout)
{
$query ="Select * from ".$vb_prefix."user order by userid desc LIMIT $from, $max_results";
    $result=mysql_db_query("$vb_table", "$query");
    $num=mysql_numrows($result);
$i=0;
while ($i < $num) {
    $username=mysql_result($result,$i,"username");
    $vbid=mysql_result($result,$i,"userid");
    $joindate=mysql_result($result,$i,"joindate");
    $posts=mysql_result($result,$i,"posts");    
?>    
<tr bgcolor="#F4F4F4" class=dbhover>
    <td align="center" class=dbhover>
        <img src=<? echo $vb_url; ?>/core/image.php?userid=<? echo $vbid;?> width=50>
    </td>
    <td align="left" class=dbhover>
        <a href="<? echo $vb_url; ?>/member/<? echo $vbid; ?>-<?echo $username; ?>"><?echo $username; ?></a>
        <br><font size=1>(<? echo $usertitle; ?>)</td> 
    </td>
    <td valign=middle align="center" class=dbhover>
        <? echo date("m-d-y",$joindate); ?>
    </td> 
    <td valign=middle align="center" class=dbhover>
        <? echo $posts; ?>
    </td> 
    </tr>
    <?
    ++$i;
}
}
else { ?>
<ul class="notices"><li class="notice restore" data-notice-id="1" data-notice-persistent="1">
        <body bgcolor="white"><center>

        <b><font style="color: red; font-weight: bold; font-size: 14px;">
        Du musst eingeloggt sein um die neuesten Nutzer sehen zu k?nnen.</font></b>
        </li>
        </ul>    
    
    
    <?
} 
?>

Thanks a lot!!!

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02360 seconds Memory Usage 1,786KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php (1)bbcode_quote (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: