[Request]Need Script

Page 2 of 2 1 2
08/22/2012 13:31 mongreldogg#16
<?php
$host="127.0.0.1";//server ip
$user = ""; //username
$pw = ""; //password
$db = "Telecaster"; //database


$connect = mssql_connect($host,$user,$pw)
or die("Can't connect to the datebase.");

mssql_select_db($db)
or die("Can't select the datebase");

$Query="SELECT count(*) from dbo.Character where login_time>logout_time";

$Result = mssql_query($Query,$connect);
while ($row=mssql_fetch_row($Result)) {
$Res=$row[0];
}
echo ($Res);
?>

Did it=) Works=)
Leechers must thank!

Quote:
Originally Posted by Tekknoid View Post
See it right, but not all in e-pvp are stupid leechers, for this guy dont understand, they should google.. first lesson in php is connect to a db.
your simple pastet script have some eklatant security reasons.. every stupid noob can read out your logins... for me we work only with config files seperate an cloak this with many reasons.

think its time to say this com in english how to secure your fucking windoofs;
Thread will be online in some days.

mfg


/edit: and no domt be stupid iam working with linux a longe time, Apache isnt bad only under wínplöd
If I understand what you mean - I must tell you that php scripts not shows in page code=)
If not - sorry for my english i'm Ukr=)
08/22/2012 14:04 adilwac#17
Quote:
Originally Posted by mongreldogg View Post
<?php
$host="127.0.0.1";//server ip
$user = ""; //username
$pw = ""; //password
$db = "Telecaster"; //database


$connect = mssql_connect($host,$user,$pw)
or die("Can't connect to the datebase.");

mssql_select_db($db)
or die("Can't select the datebase");

$Query="SELECT count(*) from dbo.Character where login_time>logout_time";

$Result = mssql_query($Query,$connect);
while ($row=mssql_fetch_row($Result)) {
$Res=$row[0];
}
echo ($Res);
?>

Did it=) Works=)
Leechers must thank!



If I understand what you mean - I must tell you that php scripts not shows in page code=)
thank you very much ..Did it works well
08/22/2012 14:07 mongreldogg#18
Quote:
Originally Posted by adilwac View Post
thank you very much ..Did it works well
come on, you welcome=)
08/22/2012 16:45 91ervans#19
Hey adilwac,

try this. I mean this works for you.

<?php
$host = '(local)\\SQLEXPRESS';
$user = 'sa';
$pw = 'password';
$db = 'telecaster';
$connect = mssql_connect($host,$user,$pw)
or die('Unable to connect to the datebase!');

mssql_select_db($db,$connect)
or die('Invalid Database!');
?>

<?php

$howmuch1 = mssql_query('select count(*) from telecaster.dbo.character
where login_time>logout_time');

$howmuch2 = mssql_fetch_array($howmuch1);

echo $howmuch2[0];

?>

Quote:
Originally Posted by mongreldogg View Post
<?php
$host="127.0.0.1";//server ip
$user = ""; //username
$pw = ""; //password
$db = "Telecaster"; //database


$connect = mssql_connect($host,$user,$pw)
or die("Can't connect to the datebase.");

mssql_select_db($db)
or die("Can't select the datebase");

$Query="SELECT count(*) from dbo.Character where login_time>logout_time";

$Result = mssql_query($Query,$connect);
while ($row=mssql_fetch_row($Result)) {
$Res=$row[0];
}
echo ($Res);
?>

Did it=) Works=)
Leechers must thank!



If I understand what you mean - I must tell you that php scripts not shows in page code=)
If not - sorry for my english i'm Ukr=)
LooooL :D

next time i refresh the page before im posting ^^
08/22/2012 16:54 mongreldogg#20
^^ xD
08/22/2012 19:22 adilwac#21
Quote:
Originally Posted by 91ervans View Post
Hey adilwac,

try this. I mean this works for you.

<?php
$host = '(local)\\SQLEXPRESS';
$user = 'sa';
$pw = 'password';
$db = 'telecaster';
$connect = mssql_connect($host,$user,$pw)
or die('Unable to connect to the datebase!');

mssql_select_db($db,$connect)
or die('Invalid Database!');
?>

<?php

$howmuch1 = mssql_query('select count(*) from telecaster.dbo.character
where login_time>logout_time');

$howmuch2 = mssql_fetch_array($howmuch1);

echo $howmuch2[0];

?>



LooooL :D

next time i refresh the page before im posting ^^
Thank you also ...^^
Do you know script number of acoounts and characters ??:confused:
08/22/2012 20:20 →Striker←#22
Quote:
Originally Posted by adilwac View Post
Thank you also ...^^
Do you know script number of acoounts and characters ??:confused:
read the script above then activate ur brain..
08/22/2012 20:29 mongreldogg#23
$Query="SELECT count(*) from dbo.Character where login_time>logout_time"
^ for numbers of characters online

$Query="SELECT count(*) from dbo.Character"
^ for number of characters total

$db = "Auth"
$Query="SELECT count(*) from dbo.Accounts"
^for total number of accounts.

And stop leeching, use yr brain
08/22/2012 20:53 gavsta#24
Code:
<?php
// Connect to MSSQL and select the database
$link = mssql_connect('sql', 'user', 'pass');
mssql_select_db('Telecaster');

// Select all our records from a table
$query = mssql_query('SELECT * FROM Character WHERE not login_time < logout_time');

echo 'Players Online:<font color="lime"> ' . mssql_num_rows($query); 

// Clean up
mssql_free_result($query);
?>
Google for 2 seconds.
08/22/2012 21:31 adilwac#25
Quote:
Originally Posted by mongreldogg View Post
$Query="SELECT count(*) from dbo.Character where login_time>logout_time"
^ for numbers of characters online

$Query="SELECT count(*) from dbo.Character"
^ for number of characters total

$db = "Auth"
$Query="SELECT count(*) from dbo.Accounts"
^for total number of accounts.

And stop leeching, use yr brain
Special thanks my friend
Page 2 of 2 1 2