MyBB Community Forums

Full Version: MyBB Signature v1.0
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Thanks! Smile Also, is it possible to use a banner created in Flash for this? Just curious! Wink
Well, it creates the image from a .png file, so I don't think it's possible. Unless, you can make a flash image into a .png file. (I'm not good with flash. Toungue)
Hehe. Thanks! Is it possible to use the banner on forums that don't use MyBB (ie IPB, PHPBB, etc.)?
You'd have to change how it grabs the posts and stuff.
Where and how would I do that? Would I have to create a new PHP file to do so?
No, it's in mybbsig.php. See how it selects the posts and stuff from the tables?
//Total Members
$total_members_sql = mysql_query("SELECT * FROM ".TABLE_PREFIX."users");
$total_members_result = mysql_num_rows($total_members_sql);

//Total Posts
  $total_posts_sql = mysql_query("SELECT * FROM ".TABLE_PREFIX."posts");
  $total_posts_result = mysql_num_rows($total_posts_sql);

//Newest Member
  $newest_member_sql = mysql_query("SELECT * FROM ".TABLE_PREFIX."users ORDER BY `uid` DESC LIMIT 0 , 1");
  $newest_member_result = mysql_fetch_array($newest_member_sql);


//Total Threads
  $total_threads_sql = mysql_query("SELECT * FROM ".TABLE_PREFIX."threads");
  $total_threads_result = mysql_num_rows($total_threads_sql);
<-- You mean this?
Yes.

$total_members_sql = mysql_query("SELECT * FROM ".TABLE_PREFIX."users");

That grabs all of the users.
Is there a way to modify the code so that it'll work on IPB, PHPBB, and other BB sites?
Yes, you include their config file, not MyBB's, and look to see how they use MySQL queries. Then, you make a query to grab the users.
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14