[Help/Request] A good statistics page for RevCMS?

Destruct

Destruct

FateRP Founder
Feb 12, 2012
548
6
Hello, Devbest
I have been searching all over Google for a decent statistics page. However they all give statistics on the game. Such as badges, users, etc. I want a better one. And I have not been able to find it.

Something similar to this
11vmus0.png


Is there any other releases similar to this? If yes, please post the link below. :up:
 
Sort by date Sort by votes
JayC

JayC

Well-Known Member
Aug 8, 2013
5,505
1,401
Code it. Thats easy. Make a div box, do some php and grab some information from the database. This would take 5 minutes to code
 
Upvote 0 Downvote
Destruct

Destruct

FateRP Founder
Feb 12, 2012
548
6
I did search it up, as i said that in my thread. Did not find it. Why post your stats page, if your not going to help. If you cannot provide me with link or the files. Then do not comment.
 
Upvote 0 Downvote
Sab

Sab

I love milfs.
Jun 25, 2011
1,212
136
Detox said:
Well I can't post the link to the other forum... If you google search RevCMS Habbo Theme look for Glee on the thread title and you will find it!
Click to expand...
What you could have done is simply post the download instead of being un helpful. That isn't the Devbest way.

Keshaun said:
I did search it up, as i said that in my thread. Did not find it. Why post your stats page, if your not going to help. If you cannot provide me with link or the files. Then do not comment.
Click to expand...


The CMS he was talking about is this I believe (only thread he posted on fagzone regarding a RevCMS release):
You must be registered for see links


Te problem is, the statspage in that CMS is just like all other CMS's. It's either I'm in the wrong thread, or he lied.
 
Upvote 0 Downvote
Destruct

Destruct

FateRP Founder
Feb 12, 2012
548
6
SabIsSharp said:
What you could have done is simply post the download instead of being un helpful. That isn't the Devbest way.




The CMS he was talking about is this I believe (only thread he posted on fagzone regarding a RevCMS release):
You must be registered for see links


Te problem is, the statspage in that CMS is just like all other CMS's. It's either I'm in the wrong thread, or he lied.
Click to expand...
Ok i will take a look
 
Upvote 0 Downvote
Wickd

Wickd

The first member of the Knights of the Pink Table
Jan 15, 2013
1,936
612
Code: 
<div id="column1" class="column">
            <div class="habblet-container ">
                <div class="cbb clearfix red ">
                    <h2 class="title"><span style="float: left;">Hotel Statistics</span></h2>
                    <div style="padding:5px;">
                        There are <strong>
                        <?php
$query = mysql_query("SELECT COUNT(*) AS aantalbadges FROM users") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalbadges'];
?></strong> Registered Members on {hotelname}.<br />
                        There are <strong><?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM users WHERE `rank` >= '2'") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Silver VIP Members on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalmeubels FROM cms_news") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalmeubels'];
?></strong> Furniture items on {hotelname}.<br />
                        There are <strong><?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM users WHERE `rank` >= '7'") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Staff Members on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM cms_news") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> News Articles on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM bans") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Banned Users on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM user_wardrobe") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> saved outfits on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM rooms") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Rooms on {hotelname}.<br />
                        There are <strong>352</strong> Filtered words in rooms on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM user_pets") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Pets on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM bots") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Bots on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM groups") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Groups on {hotelname}.<br />
                    </div>
                </div>
            </div>
            <div class="habblet-container ">
                <div class="cbb clearfix red ">
                    <h2 class="title"><span style="float: left;">Staff Statistics</span></h2>
                    <div style="padding:5px;">
                                                <?php //* Wickd MAYN/devbest.com
$getStats = mysql_query("SELECT * FROM users WHERE `rank` >= '7' ORDER BY `respect` DESC LIMIT 45");
while($staffStats = mysql_fetch_array($getStats)) {
      
$Bans = mysql_query("SELECT * FROM `bans` WHERE `added_by` = '" . $staffStats['username'] . "'");
$BanCount = mysql_num_rows($Bans);
$Tickets = mysql_query("SELECT * FROM `moderation_tickets` WHERE `moderator_id` = '" . $staffStats['id'] . "'");
$TicketCount = mysql_num_rows($Tickets);
echo '
  <strong><a href="/home/'.$staffStats['username'].'">'.$staffStats['username'].'</a></strong> has banned <strong>
                        '.$BanCount.'</strong> users and handled
                        <strong>'.$TicketCount.'</strong> call for help tickets.
                        <br />
                        <hr>
';
}
?>

                                            </div>
                </div>
            </div>
        </div>
       
        <div id="column2" class="column">
            <div class="habblet-container ">
                <div class="cbb clearfix blue ">
                    <h2 class="title"><span style="float: left;">{hotelname}'s Newest User</span></h2>
                                        <div style="padding: 5px;">
                        <div class="staffBox">
                            <img style="margin-bottom: 4px; margin-left: 4px; float:left;" src="https://game.boon.pw/habbo-imaging/head.php?figure=hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100-&size=m&direction=2&head_direction=2&gesture=sml" />
                            <span style="float: right; margin-right: 4px; margin-top: 12px;"><img src="https://images.boon.pw/offline-xmas14.png" /></span>
                            <table style="margin-left: 35px; padding-top: 6px;">
                                <tr style="padding: 0;">
                                    <td>
                                        <strong><a href="https://boon.pw/home/poopin">poopin</a></strong><br />
                                        I am new to {hotelname}!<br />
                                    </td>
                                </tr>
                            </table>
                            <br /><br />
                        </div>
                    </div>
                </div>
            </div>
           
           
            <div class="habblet-container ">
                <div class="cbb clearfix blue ">
                    <h2 class="title"><span style="float: left;">Random {hotelname} Staff Member</span></h2>
                                        <div style="padding: 5px;">
                        <div class="staffBox">
                            <img style="margin-bottom: 4px; margin-left: 4px; float:left;" src="https://game.boon.pw/habbo-imaging/head.php?figure=lg-280-63.ch-255-73.hr-828-45.he-1609-73.hd-205-3.fa-1209-73.ca-1813-62.sh-295-73&size=m&direction=2&head_direction=2&gesture=sml" />
                            <span style="float: right; margin-right: 4px; margin-top: 12px;"><img src="https://images.boon.pw/offline-xmas14.png" /></span>
                            <table style="margin-left: 35px; padding-top: 6px;">
                                <tr style="padding: 0;">
                                    <td>
                                        <strong><a href="https://boon.pw/home/MOD-Adrian">BlackJesus</a></strong><br />
                                        Wicked RULES<br />
                                    </td>
                                </tr>
                            </table>
                            <br /><br />
                        </div>
                    </div>
                                    </div>
            </div>
        </div>
        <script type="text/javascript">
            document.observe("dom:loaded", function() { PromoSlideShow.init(); });
        </script>
                <script type="text/javascript">
            HabboView.run();
        </script>
 
Upvote 0 Downvote
Destruct

Destruct

FateRP Founder
Feb 12, 2012
548
6
Wicked said:
Code: 
<div id="column1" class="column">
            <div class="habblet-container ">
                <div class="cbb clearfix red ">
                    <h2 class="title"><span style="float: left;">Hotel Statistics</span></h2>
                    <div style="padding:5px;">
                        There are <strong>
                        <?php
$query = mysql_query("SELECT COUNT(*) AS aantalbadges FROM users") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalbadges'];
?></strong> Registered Members on {hotelname}.<br />
                        There are <strong><?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM users WHERE `rank` >= '2'") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Silver VIP Members on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalmeubels FROM cms_news") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalmeubels'];
?></strong> Furniture items on {hotelname}.<br />
                        There are <strong><?php $query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM users WHERE `rank` >= '7'") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Staff Members on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM cms_news") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> News Articles on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM bans") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Banned Users on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM user_wardrobe") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> saved outfits on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM rooms") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Rooms on {hotelname}.<br />
                        There are <strong>352</strong> Filtered words in rooms on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM user_pets") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Pets on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM bots") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Bots on {hotelname}.<br />
                        There are <strong><?php
$query = mysql_query("SELECT COUNT(*) AS aantalkamers FROM groups") or die(mysql_error());
$data = mysql_fetch_assoc($query);

echo $data['aantalkamers'];
?></strong> Groups on {hotelname}.<br />
                    </div>
                </div>
            </div>
            <div class="habblet-container ">
                <div class="cbb clearfix red ">
                    <h2 class="title"><span style="float: left;">Staff Statistics</span></h2>
                    <div style="padding:5px;">
                                                <?php //* Wickd MAYN/devbest.com
$getStats = mysql_query("SELECT * FROM users WHERE `rank` >= '7' ORDER BY `respect` DESC LIMIT 45");
while($staffStats = mysql_fetch_array($getStats)) {
   
$Bans = mysql_query("SELECT * FROM `bans` WHERE `added_by` = '" . $staffStats['username'] . "'");
$BanCount = mysql_num_rows($Bans);
$Tickets = mysql_query("SELECT * FROM `moderation_tickets` WHERE `moderator_id` = '" . $staffStats['id'] . "'");
$TicketCount = mysql_num_rows($Tickets);
echo '
  <strong><a href="/home/'.$staffStats['username'].'">'.$staffStats['username'].'</a></strong> has banned <strong>
                        '.$BanCount.'</strong> users and handled
                        <strong>'.$TicketCount.'</strong> call for help tickets.
                        <br />
                        <hr>
';
}
?>

                                            </div>
                </div>
            </div>
        </div>
    
        <div id="column2" class="column">
            <div class="habblet-container ">
                <div class="cbb clearfix blue ">
                    <h2 class="title"><span style="float: left;">{hotelname}'s Newest User</span></h2>
                                        <div style="padding: 5px;">
                        <div class="staffBox">
                            <img style="margin-bottom: 4px; margin-left: 4px; float:left;" src="https://game.boon.pw/habbo-imaging/head.php?figure=hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100-&size=m&direction=2&head_direction=2&gesture=sml" />
                            <span style="float: right; margin-right: 4px; margin-top: 12px;"><img src="https://images.boon.pw/offline-xmas14.png" /></span>
                            <table style="margin-left: 35px; padding-top: 6px;">
                                <tr style="padding: 0;">
                                    <td>
                                        <strong><a href="https://boon.pw/home/poopin">poopin</a></strong><br />
                                        I am new to {hotelname}!<br />
                                    </td>
                                </tr>
                            </table>
                            <br /><br />
                        </div>
                    </div>
                </div>
            </div>
        
        
            <div class="habblet-container ">
                <div class="cbb clearfix blue ">
                    <h2 class="title"><span style="float: left;">Random {hotelname} Staff Member</span></h2>
                                        <div style="padding: 5px;">
                        <div class="staffBox">
                            <img style="margin-bottom: 4px; margin-left: 4px; float:left;" src="https://game.boon.pw/habbo-imaging/head.php?figure=lg-280-63.ch-255-73.hr-828-45.he-1609-73.hd-205-3.fa-1209-73.ca-1813-62.sh-295-73&size=m&direction=2&head_direction=2&gesture=sml" />
                            <span style="float: right; margin-right: 4px; margin-top: 12px;"><img src="https://images.boon.pw/offline-xmas14.png" /></span>
                            <table style="margin-left: 35px; padding-top: 6px;">
                                <tr style="padding: 0;">
                                    <td>
                                        <strong><a href="https://boon.pw/home/MOD-Adrian">BlackJesus</a></strong><br />
                                        Wicked RULES<br />
                                    </td>
                                </tr>
                            </table>
                            <br /><br />
                        </div>
                    </div>
                                    </div>
            </div>
        </div>
        <script type="text/javascript">
            document.observe("dom:loaded", function() { PromoSlideShow.init(); });
        </script>
                <script type="text/javascript">
            HabboView.run();
        </script>
Click to expand...


I want the script. Not a copy of someones hotel script. Thats showing a different hotels stats. And look at it...

erg61h.png
 
Upvote 0 Downvote
Wickd

Wickd

The first member of the Knights of the Pink Table
Jan 15, 2013
1,936
612
I gave you what you asked for, you never said you wanted 'Newest Users' and 'Random staff member' to work(trolololol).Oh by the way not my fault you don't know how to paste the code.
 
Upvote 0 Downvote
JayC

JayC

Well-Known Member
Aug 8, 2013
5,505
1,401
I'll show you how to write your own so you don't complain about not getting what you want.

3 very easy steps.

Step 1: Write the first query
Code: 
mysql_query("SELECT * FROM table");
* = Grabs All Columns
You can add things to the end like "WHERE column = *value*" to control your output or SORT BY desc/rand to make the values change order or randomize them

So after you get your query written out which should look something like this:
UberCMS: mysql_query("SELECT * from USERS where USERNAME='".USER_NAME."'");
RevCMS: mysql_query("SELECT * from USER where USERNAME='".$_SESSION['user']['username']."'");

Step 2: Grab The Attributes
Code: 
You can never just write a query and then say $query['value'] because you will get a resource ID error. So you grab the attributes of it so you can use it

$UseMe = mysql_fetch_assoc($query);

Great now the easy part
Step 3: Display/Use the information
Code: 
Display:
echo $UseMe['column'];

Use:
'".$UseMe['column']."' --> Use this in another query to grab more info

And just to be noted you said you wanted a stats page, and he gave you all of the code for it. Stop being picky we are not here to spoon feed you we are here to HELP. We want to make retros more diverse and unique. We do not want to see the same things over and over.
Best of Luck!
 
Upvote 0 Downvote
Destruct

Destruct

FateRP Founder
Feb 12, 2012
548
6
JayCustom said:
I'll show you how to write your own so you don't complain about not getting what you want.

3 very easy steps.

Step 1: Write the first query
Code: 
mysql_query("SELECT * FROM table");
* = Grabs All Columns
You can add things to the end like "WHERE column = *value*" to control your output or SORT BY desc/rand to make the values change order or randomize them

So after you get your query written out which should look something like this:
UberCMS: mysql_query("SELECT * from USERS where USERNAME='".USER_NAME."'");
RevCMS: mysql_query("SELECT * from USER where USERNAME='".$_SESSION['user']['username']."'");

Step 2: Grab The Attributes
Code: 
You can never just write a query and then say $query['value'] because you will get a resource ID error. So you grab the attributes of it so you can use it

$UseMe = mysql_fetch_assoc($query);

Great now the easy part
Step 3: Display/Use the information
Code: 
Display:
echo $UseMe['column'];

Use:
'".$UseMe['column']."' --> Use this in another query to grab more info

And just to be noted you said you wanted a stats page, and he gave you all of the code for it. Stop being picky we are not here to spoon feed you we are here to HELP. We want to make retros more diverse and unique. We do not want to see the same things over and over.
Best of Luck!
Click to expand...
1. Im not being picky.
2. Im not complaining
3. I never wanted to be spoon fed lol.

I am just a beginner at html, only know basics when coding, and I'm still learning. Which is why i didn't understand. You can't expect everyone on devbest to be good at coding lol.
 
Upvote 0 Downvote

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top