Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 23:14

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Request]Need Script

Discussion on [Request]Need Script within the Rappelz Private Server forum part of the Rappelz category.

Reply
 
Old 08/22/2012, 13:31   #16
 
mongreldogg's Avatar
 
elite*gold: 30
Join Date: Mar 2012
Posts: 634
Received Thanks: 297
<?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 ******* 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=)
mongreldogg is offline  
Old 08/22/2012, 14:04   #17
 
elite*gold: 0
Join Date: Mar 2012
Posts: 30
Received Thanks: 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=)
thank you very much ..Did it works well
adilwac is offline  
Old 08/22/2012, 14:07   #18
 
mongreldogg's Avatar
 
elite*gold: 30
Join Date: Mar 2012
Posts: 634
Received Thanks: 297
Quote:
Originally Posted by adilwac View Post
thank you very much ..Did it works well
come on, you welcome=)
mongreldogg is offline  
Old 08/22/2012, 16:45   #19
 
elite*gold: 0
Join Date: Jun 2010
Posts: 147
Received Thanks: 21
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

next time i refresh the page before im posting ^^
91ervans is offline  
Old 08/22/2012, 16:54   #20
 
mongreldogg's Avatar
 
elite*gold: 30
Join Date: Mar 2012
Posts: 634
Received Thanks: 297
^^ xD
mongreldogg is offline  
Old 08/22/2012, 19:22   #21
 
elite*gold: 0
Join Date: Mar 2012
Posts: 30
Received Thanks: 0
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

next time i refresh the page before im posting ^^
Thank you also ...^^
Do you know script number of acoounts and characters ??
adilwac is offline  
Old 08/22/2012, 20:20   #22
 
→Striker←'s Avatar
 
elite*gold: 0
Join Date: Oct 2011
Posts: 275
Received Thanks: 266
Quote:
Originally Posted by adilwac View Post
Thank you also ...^^
Do you know script number of acoounts and characters ??
read the script above then activate ur brain..
→Striker← is offline  
Thanks
2 Users
Old 08/22/2012, 20:29   #23
 
mongreldogg's Avatar
 
elite*gold: 30
Join Date: Mar 2012
Posts: 634
Received Thanks: 297
$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
mongreldogg is offline  
Old 08/22/2012, 20:53   #24
 
gavsta's Avatar
 
elite*gold: 0
Join Date: Jul 2010
Posts: 1,141
Received Thanks: 634
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.
gavsta is offline  
Thanks
1 User
Old 08/22/2012, 21:31   #25
 
elite*gold: 0
Join Date: Mar 2012
Posts: 30
Received Thanks: 0
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
adilwac is offline  
Reply


Similar Threads Similar Threads
Script request
10/10/2010 - Lineage 2 - 1 Replies
Can some1 make a script like these ? He should target a "Red Star Stone" and then use the skill "Star Stone Gathering" Would be nice. Thanks :)
[Request]pvp script
08/17/2010 - Dekaron Private Server - 1 Replies
hi can some1 know script with who i can reset all char pvp point
SCRIPT REQUEST~~~
10/04/2009 - Grand Chase Philippines - 20 Replies
can anyone please make a playertemplate or a script with~ 1. 1 hit hack 2. super def 3. pet cooldown faster -salamat po, and btw baka mag react nnmn c frost~ request toh, for short nagtatanung lang kung pede~~~
script request
09/28/2009 - Lin2 Exploits, Hacks, Bots, Tools & Macros - 1 Replies
Hello, I'm playing on a server with stack sub and im using pr/bd. I was wondering how to set l2w to equip duals, dance and equip bow back after finished dancing, if anyone knows please share. Thank you.
[REQUEST] Can i Request A Acc/Char PHP Script
09/27/2008 - CO2 Private Server - 6 Replies
hello i was wondering if anyone have made a acc/char creation page in one yet? is so can anyone release itplease?



All times are GMT +1. The time now is 23:14.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.