Results 1 to 9 of 9
Thread: IPB MySQL Help
Hybrid View
-
05-23-2006, 10:03 AM #1Junior 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.
-
05-23-2006, 10:32 AM #2New Member
- Join Date
- May 2006
- Posts
- 3
The Mod you are trying to install is NOT for 1.x.x. Thats why the error.
-
05-23-2006, 10:44 AM #3Junior 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!
-
05-23-2006, 10:50 AM #4New 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
-
05-23-2006, 10:56 AM #5Junior 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.
-
05-23-2006, 11:02 AM #6New 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!
-
05-23-2006, 11:21 AM #7Junior 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.
-
05-23-2006, 01:16 PM #8Web Hosting Master
- Join Date
- Mar 2004
- Posts
- 1,303
..uh, do you have license for this version 1.3.1
-
05-23-2006, 02:10 PM #9Junior 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.