hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : IPB MySQL Help
Reply

Forum Jump

IPB MySQL Help

Reply Post New Thread In Programming Discussion Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 05-23-2006, 10:03 AM
iyeru42 iyeru42 is offline
Junior Guru Wannabe
 
Join Date: May 2006
Location: Madison, WI
Posts: 34

IPB MySQL Help


Hiya everyone. Sorry to bother you people who would normally say "Just download IPB and explore it." (Just like that reply to the fadin' links deal.) But I have a problem.

I need help trying to sum up a MySQL query (to PHP variables) that gets the TOTAL number of users currently online and echos them. (I have IPB 1.3.1 final by the way.)

Yes, I've already tried including Boards.php/Online.php into my index.php for my site, and it gave an error message saying that there was an "Unexpected NON-Member object."

Besides that query, I need to get how many REAL total posts there are on the board. (I can get all in all total posts, but that ALSO includes the deleted posts.)

Thank you people in advanced.

Also, I took a look in the Boards.php and Online.php for IPB 1.3.1 (Which is what I use), and I couldn't get the code itself to work in my own code, because

1.] functions.php is not included on my index.php
2.] The $ibforums variable doesn't exist in my index.php
3.] IPB is stupid without its source files.

So there yeh go.



Sponsored Links
  #2  
Old 05-23-2006, 10:32 AM
trucker trucker is offline
New Member
 
Join Date: May 2006
Posts: 3
The Mod you are trying to install is NOT for 1.x.x. Thats why the error.

  #3  
Old 05-23-2006, 10:44 AM
iyeru42 iyeru42 is offline
Junior Guru Wannabe
 
Join Date: May 2006
Location: Madison, WI
Posts: 34
It's not a modification I'm trying to install. I'm just using PHP to get the total number of active members from the MySQL Database and then have PHP echo the number to my index.php

(http://iyeru42.zero-outpost.com/index.php) NOT the board!

Sponsored Links
  #4  
Old 05-23-2006, 10:50 AM
trucker trucker is offline
New Member
 
Join Date: May 2006
Posts: 3
can't find server. can u come up on msn? look in my profile for my nick or come to my site. its also in my profile

  #5  
Old 05-23-2006, 10:56 AM
iyeru42 iyeru42 is offline
Junior Guru Wannabe
 
Join Date: May 2006
Location: Madison, WI
Posts: 34
Web Messenger is a pain in the butt. No, I won't come up on MSNM. As I'm at school at the moment...

1.] We can't download zips, RARs, EXEs, etc.
2.] We have a super duper that searches for keywords on a page (like bre@$t) and makes dansguardian (http://www.dansguardian.org) come up.

Also, the CFS error is actually a DNS error (Did you try refreshing when it came up?) If it doesn't come up for you, try in two days (maximum), if it still doesn't come up...

email me using my MSNM E-Mail Address.

Edit: By the way, I hate sites that force guests to login. Your marquee thing at the top of the board there, as well as all of those other images up there, really make it look bad. Like if it were made by someone who used to be on iF who didn't know how to even manage his/her own board skin/etc. properly.

Edit #2: MSN Web Messenger can't add you to my list, it says: "A problem occured, please try again." (Did that twice, didn't work.)


Last edited by iyeru42; 05-23-2006 at 11:04 AM.
  #6  
Old 05-23-2006, 11:02 AM
trucker trucker is offline
New Member
 
Join Date: May 2006
Posts: 3
Guess you really dont need the help. As for the Marquee. Its been there for over two years with no complaints!

  #7  
Old 05-23-2006, 11:21 AM
iyeru42 iyeru42 is offline
Junior Guru Wannabe
 
Join Date: May 2006
Location: Madison, WI
Posts: 34
No, I kinda do need you help, if you have knowledge on how to parse it so that when I query from ibf_members and select the colmn where it has either a 0 or -1 (Which gets set when you login or logoff) that it will put up a counter to a PHP variable for each -1... eh... I guess visual aids will help in this case...

Code:
// MySQL says:

Column X has "5" -1 variables.

// PHP replies

For each -1 value, I'll add 1 to the variable $totalmembers.

// and php then writes...

$totalmembers.
However, SINCE IPB only sets the -1 value back to 0 when you hit the logout button, it doesn't really help, because I am still logged in at home, so IPB still thinks I'm logged in. (-1 value.)

  #8  
Old 05-23-2006, 01:16 PM
orbitz orbitz is offline
Web Hosting Master
 
Join Date: Mar 2004
Posts: 1,301
..uh, do you have license for this version 1.3.1

  #9  
Old 05-23-2006, 02:10 PM
iyeru42 iyeru42 is offline
Junior Guru Wannabe
 
Join Date: May 2006
Location: Madison, WI
Posts: 34
You don't need one, but yes... I do, that's why the copyright at the bottom is gone. Sage 'lended' his Liscensed copy to me... since literally I'm on his server, and it's HIS copy... so eh.

Reply

Related posts from TheWhir.com
Title Type Date Posted
Tesora's OpenStack DBaaS Supports MongoDB, Cassandra, Redis, and MySQL Web Hosting News 2014-05-23 14:53:11
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
Web Hosting Sales and Promos Roundup - September 20, 2013 Web Hosting News 2014-05-23 15:42:47
PHP And MySQL Scaling: Preparing A Startup For Growth Blog 2014-04-24 13:27:35


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:
WHT Membership
WHT Membership



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?