[Script] Total User Online by phprap^^

[phprap]

INDEX TOP

<?
include("config_cabal.php");
?>

Codigo php

<?php 
$sql = mssql_query("SELECT count(*) FROM cabal_character_table WHERE Login = 1");

if( mssql_result($sql, 0, 0) <= 80){
echo "<font color=red>";
echo mssql_result($sql, 0, 0);}

elseif( mssql_result($sql, 0, 0) >= 80 AND mssql_result($sql, 0, 0) <= 150){
echo "<font color=Blue>";
echo mssql_result($sql, 0, 0);}

elseif( mssql_result($sql, 0, 0) > 150){
echo "<font color=green>";
echo mssql_result($sql, 0, 0);} ?>

config_cabal.php

<?php
//===== Script criado por phprap edite conforme seus dados ======
$dbhost = "127.0.0.1"; // ip host geralmente "127.0.0.1"
$dbuser = "sa"; // login sql "sa"
$dbpasswd = "XXXXXX"; // senha do sql
$host = "127.0.0.1"; // ip de onde est

 

[Sk8TeR]

Nice WOrk man

 

[terzo]

Nice work, thank you

 

[dordort]

Thankssss!!!! =]

 

[dordort]

Dont work for me.. i go to codigo and i see:

<?
include("config_cabal.php");
?>
<?php
$msconnect=mssql_connect("$dbhost","$dbuser","$dbpasswd");
$msdb=mssql_select_db("GAMEDB",$msconnect);
?>
<?php
$sql = mssql_query("SELECT count(*) FROM cabal_character_table WHERE Login = 1");
if( mssql_result($sql, 0, 0) <= 80){
echo "<font color=red>";
echo mssql_result($sql, 0, 0);}
elseif( mssql_result($sql, 0, 0) >= 80 AND mssql_result($sql, 0, 0) <= 150){
echo "<font color=Blue>";
echo mssql_result($sql, 0, 0);}
elseif( mssql_result($sql, 0, 0) > 150){
echo "<font color=green>";
echo mssql_result($sql, 0, 0);} ?>

 

[phprap]

;] lol

 

[dordort]

Still the same after your changes :\
I am using IIS.

 

[Sk8TeR]

WoW
you are the best

 

[dordort]

I download it and put them in my IIS directory, and when i go to index.php:

Usuarios online = 80 AND mssql_result($sql, 0, 0) <= 150){ echo ""; echo mssql_result($sql, 0, 0);} elseif( mssql_result($sql, 0, 0) > 150){ echo ""; echo mssql_result($sql, 0, 0);} ?>
Total contas

What can i do?
Maybe i need to install php on IIS? if i do so how?

thanks.

 

[betrayal]

just use php webserver...

You must be registered to see links

 

[dordort]

just use php webserver...

You must be registered to see links

But i want to use IIS so how can i configure it to run this?

 

[betrayal]

IIS for asp aspx !!!!!!! not support PHP script !

 

[dordort]

IIS for asp aspx !!!!!!! not support PHP script !

Oh.. so i can use 2 in the same time? one for php one for asp?

Edit:

How can i run asp and php in one thing?? i was installed wampserver and i go to 127.0.0.1 and it go to the IIS server..

 

[phprap]

port 80 IIS port 8090 wamp

You must be registered to see links

>> IIS

You must be registered to see links

wamp

in wamp.. config httpd.conf >> listen 8090

 

[dordort]

Ok now i installed PHP extension on my IIS, and when i open 127.0.0.1/index.php i got this error:

HTTP 500 - Internal server error.

What to do?!

 

[dordort]

Ok now i installed PHP extension on my IIS, and when i open 127.0.0.1/index.php i got this error:

HTTP 500 - Internal server error.

What to do?!

 

[dordort]

Ok now i installed PHP extension on my IIS, and when i open 127.0.0.1/index.php i got this error:

HTTP 500 - Internal server error.

What to do?!

 

[snaity]

Ok now i installed PHP extension on my IIS, and when i open 127.0.0.1/index.php i got this error:

HTTP 500 - Internal server error.

What to do?!

info from install.txt from PHP

__________________________________________________________________

Windows NT/200x/XP and IIS 4 or newer

   PHP may be installed as a CGI binary, or with the ISAPI module. In
   either case, you need to start the Microsoft Management Console (may
   appear as 'Internet Services Manager', either in your Windows NT 4.0
   Option Pack branch or the Control Panel=>Administrative Tools under
   Windows 2000/XP). Then right click on your Web server node (this will
   most probably appear as 'Default Web Server'), and select 'Properties'.

   If you want to use the CGI binary, do the following:

     * Under 'Home Directory', 'Virtual Directory', or 'Directory', do the
       following:
     * Change the Execute Permissions to 'Scripts only'
     * Click on the 'Configuration' button, and choose the Application
       Mappings tab. Click Add and set the Executable path to the
       appropriate CGI file. An example PHP 5 value is: C:\php\php-cgi.exe
       Supply .php as the extension. Leave 'Method exclusions' blank, and
       check the 'Script engine' checkbox. Now, click OK a few times.
     * Set up the appropriate security. (This is done in Internet Service
       Manager), and if your NT Server uses NTFS file system, add execute
       rights for I_USR_ to the directory that contains php.exe /
       php-cgi.exe.

   To use the ISAPI module, do the following:

     * If you don't want to perform HTTP Authentication using PHP, you can
       (and should) skip this step. Under ISAPI Filters, add a new ISAPI
       filter. Use PHP as the filter name, and supply a path to the
       php4isapi.dll / php5isapi.dll.
     * Under 'Home Directory', 'Virtual Directory', or 'Directory', do the
       following:
     * Change the Execute Permissions to 'Scripts only'
     * Click on the 'Configuration' button, and choose the Application
       Mappings tab. Click Add and set the Executable path to the
       appropriate ISAPI DLL. An example PHP 5 value is:
       C:\php\php5isapi.dll Supply .php as the extension. Leave 'Method
       exclusions' blank, and check the 'Script engine' checkbox. Now,
       click OK a few times.
     * Stop IIS completely (NET STOP iisadmin)
     * Start IIS again (NET START w3svc)

   With IIS 6 (2003 Server), open up the IIS Manager, go to Web Service
   Extensions, choose "Add a new Web service extension", enter in a name
   such as PHP, choose the Add button and for the value browse to either
   the ISAPI file (php4isapi.dll or php5isapi.dll) or CGI (php.exe or
   php-cgi.exe) then check "Set extension status to Allowed" and click OK.

   In order to use index.php as a default content page, do the following:
   From within the Documents tab, choose Add. Type in index.php and click
   OK. Adjust the order by choosing Move Up or Move Down. This is similar
   to setting DirectoryIndex with Apache.

   The steps above must be repeated for each extension that is to be
   associated with PHP scripts. .php is the most common although .php3 may
   be required for legacy applications.

   If you experience 100% CPU usage after some time, turn off the IIS
   setting Cache ISAPI Application.
     __________________________________________________________________

i recommend install ISAPI module and not CGI, but if ISAPI dont work try CGI.

But i recommend to use apache for PHP (its too better than IIS for PHP)

 

[dordort]

Ok i succeded to install php on IIS, now i open

You must be registered to see links

and its shows me Usoraio Online something like that and dont show the users.. only this nothing else!

Image:

Thanks.

And yes, i was edit the config to my sql usr and pass!

 

[`CcyClOnE`]

this one sux. i dont like. its just simple and gay. the one i made myself is better.