|
You last visited: Today at 01:33
Advertisement
[help]I can view player online
Discussion on [help]I can view player online within the Dekaron Private Server forum part of the Dekaron category.
04/12/2011, 14:26
|
#1
|
elite*gold: 0 
Join Date: Jan 2010
Posts: 114
Received Thanks: 10
|
[help]I can't view player list online
title ,
please guide me
onine see how players are and the name of player
|
|
|
|
04/12/2011, 15:40
|
#2
|
elite*gold: 0
Join Date: Aug 2008
Posts: 333
Received Thanks: 124
|
player online lists. :b
|
|
|
|
|
04/15/2011, 06:27
|
#3
|
elite*gold: 0
Join Date: Jan 2010
Posts: 114
Received Thanks: 10
|
what this error ?
Code:
Fatal error: Call to undefined function mssql_connect() in D:\VertrigoServ\www\online\reborn.php on line 90
PHP Code:
extension=php_mbstring.dll
extension=php_bz2.dll
extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_exif.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_ifx.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
extension=php_mssql.dll
;extension=php_msql.dll
;extension=php_mysql.dll
;extension=php_mysqli.dll
;extension=php_oci8.dll
extension=php_openssl.dll
;extension=php_oracle.dll
extension=php_pdo.dll
extension=php_pdo_mysql.dll
extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_sockets.dll
extension=php_sqlite.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_xmlrpc.dll
|
|
|
|
|
04/15/2011, 06:32
|
#4
|
elite*gold: 0
Join Date: Jan 2010
Posts: 114
Received Thanks: 10
|
I can use script
PHP Code:
<?php
require_once "config.inc.php";
if(isset($_SESSION["step2"]) && isset($_POST["step2"])) {
$errorStr = formStep3();
if($errorStr!=null){
require_once('register.html');
}else{
require_once('success.html');
$suc=$success;
unset($_SESSION[step2], $_SESSION[step1]);
}}
else {
require_once('register.html');
$_SESSION["step2"] = 1; }
function formStep3(){
$errors = array();
$errorStr = null;
$strSql="select * from Tbl_user where user_id='$_POST[username]'";
if ($_POST[ZoneGroup]=="zone1") {
$account_odbc = odbc_connect('account','sa','********');
} elseif ($_POST[ZoneGroup]=="zone2") {
$account_odbc = odbc_connect('account2','sa','*******');
} else {
die ("<p><b>·ÖÇøÑ¡Ôñ´íÎó!</b></p>");
}
$user_result=odbc_do($account_odbc,$strSql);
$result_query=odbc_fetch_row($user_result);
if (odbc_result($user_result,1)!= "") $errors[] = "This Accountname already exists, please choose another one.";
if(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $_POST[username])) $errors[]="You are only alowed to use uppper and lower cases in English in your username.";
if(strlen($_POST[username])<3) $errors[] = "The length of your username can't be less than 3 characters";
if(strlen($_POST[username])>15) $errors[]= "The length of your username can't be more than 15 characters";
if(!preg_match("/^[0-9a-zA-Z]{3,15}$/i", $_POST[password1])) $errors[]="You can only use English Characters of Upper case and lower case in your password. Try again";
if(preg_match("/^[0-9]{3,15}$/i",$_POST[password1])) $errors[]="You are not alowed just to input numbers as your password.";
if($_POST[username]==$_POST[password1]) $errors[]= "Accountname and password can't be the same!";
if(strlen($_POST[password1])<3) $errors[] = "The length of the password can't be less than 3 characters";
if(strlen($_POST[password1])>15) $errors[] = "The length of the password can't be more than 15 characters";
if($_POST[password2]!=$_POST[password1]) $errors[] = "Password does not match";
if(!preg_match("/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/i",$_POST[mail])) $errors[]="Your E-mail Adress is not valid. Please enter a valid one.";
if(strlen($_POST[referred])>20) $errors[] = "The length of the referred name can't be more than 20 characters";
if(sizeof($errors)>0){
$errorStr .= "<br><font>";
$errorStr .= "You have the following error(s):";
foreach($errors as $error)
$errorStr .= "<li>$error</li>";
$errorStr .= "</font><br><br>";
}else{
$passwd_user=md5($_POST["password1"]);
$dk_time=strftime("%y%m%d%H%M%S");
list($usec1, $sec1) = explode(" ",microtime());
$dk_user_no=$dk_time.substr($usec1,2,2);
$dk_account_query="insert into user_profile(user_no,user_id,user_pwd,resident_no,user_type,login_flag,login_tag,ipt_time,login_time,logout_time,user_ip_addr,server_id) values('$dk_user_no','$_POST[username]','$passwd_user','801011000000','1','0','Y','05/06/2009 00:00:00',null,null,null,'000')";
$dk_account_query2="insert into Tbl_user(user_no,user_id,user_pwd,user_mail,user_answer,user_question) values('$dk_user_no','$_POST[username]','$_POST[password1]','$_POST[mail]',0,0)";
$dk_account_result1=odbc_do($account_odbc,$dk_account_query);
$dk_account_result2=odbc_do($account_odbc,$dk_account_query2);
odbc_close($account_odbc);
}
return $errorStr;
}
?>
but can't use
PHP Code:
<?php
// written by zombe and
// modifyed janvier123 :)
// cleaning up after is ass :)
//-----------------------------------------------
// This script is made for players to reborn themselfs
// But its has some limits inside
// - Cant Reborn a [GM] character
// - Can have some bug, that i cant find :)
//
// How does it work ?
// - Enter a name
// - Check the requirements
// - Press "Yes, make me rebiorn plz
// - Done :)
//-----------------------------------------------
// Please fill in your MSSQL Info
//<--! begin MSSQL info !-->
$mssql = array(
'host' => "192.168.1.3", // Normaly "localhost" or "XXX.XXX.XXX.XXX"
'user' => "sa", // Your username for MSSQL server, normaly "sa"
'pass' => "*******" // Your password for MSSQL server
);
//<--! ind MSSQL info !-->
// Please fill in your Classes info if not correct
//<--! begin classes info !-->
$classes = array(
'0' => "Azure Knight",
'1' => "Segita Hunter",
'2' => "Incar Magician",
'3' => "Vicious Summoner",
'4' => "Segnale",
'5' => "Bagi Warrior",
'6' => "Aloken"
);
//<--! end classes info !-->
// Please fill in your requirements if not correct
// WARNING DO NOT PUT "." BETWEEN "dil"
//<--! begin requirements info !-->
$req = array(
'name' => "Any name... Duh!",
'level' => "200",
'dil' => "50000000",
'class' => "Any class... Duh!",
'reborn' => "None"
);
//<--! end requirements info !-->
// Please chance if you want
//<--! begin text info !-->
$text = array(
'title1' => "Is this correct?",
'title2' => "Your new stats.",
'button1' => "Next ...",
'step1' => "Enter character name:",
'table1' => "--------- Type ---------",
'table2' => "--------- Current ---------",
'table3' => "--------- Required ---------",
'done' => "Reborn was successful, blah.",
'error1' => "Something went wrong, lol",
'error2' => "No such character"
);
//<--! end text info !-->
// Step 1:
// Getting name to fill in the table below and to exec the reborn script
if ($_GET['step'] == ""){
echo'<center><Form Name ="form" action="reborn.php?step=2" Method ="POST">';
echo''.$text['step1'].'<p>';
echo'<input name="name" type="text" value="">';
echo'<br>';
echo'<input type="hidden" name="select" value="1">';
echo'<input name="submit" type="submit" value="'.$text['button1'].'">';
echo'</form></center>';
// getting name from form and go to step 2
// OK time for step 2
} else if ($_GET['step'] == "2"){
if($_POST['select'] == '1') {
$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result1 = mssql_query("SELECT * FROM character.dbo.user_character WHERE character_name = '".$_POST['name']."'",$ms_con);
$count1 = mssql_num_rows($result1);
$result1 = mssql_query("SELECT login_flag FROM account.dbo.USER_PROFILE WHERE user_no = '".$_POST['user_no']."'",$ms_con);
$row1 = mssql_fetch_row($result1);
if($row1[0] == '1100') {
$result2 = mssql_query("SELECT character_no FROM character.dbo.user_character WHERE user_no = '".$_POST['user_no']."' ORDER by login_time DESC",$ms_con);
$row2 = mssql_fetch_row($result2);
}
if($row1[0] == '1100' && $row2[0] == $_POST['char_no']) {
echo "<br>This character can not currently be edited, since it is online.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif($count1 < '1') {
echo "<center><br>Could not find the character name. <br><a href='javascript:history.back()'>Go Back</a></center>";
} elseif($count > '1') {
echo "<center><br>There were several characters with the same name found. <br>Please check that name in the database.<br><a href='javascript:history.back()'>Go Back</a></center>";
} else {
$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result2 = mssql_query("SELECT character_name,dwExp,dwMoney,wLevel,Reborn FROM character.dbo.user_character WHERE character_name = '".$_POST['name']."'",$ms_con);
$row2 = mssql_fetch_row($result2);
echo "<center><br><form action='reborn.php?step=3' method='POST'>
<table class='innertab'>
<tr>
<td colspan='3' align='left'><b><center>".$text['title1']."</center></b></td>
</tr>
<tr>
<td colspan='3' align='left'> </td>
</tr>
<tr>
<td align='left'><b>".$text['table1']."</b></td>
<td align='left'><b>".$text['table2']."</b></td>
<td align='left'><b>".$text['table3']."</b></td>
</tr>
<tr>
<td align='left'><b>Character Name:</b></td>
<td align='left'><input type='text' name='new_name' readonly=readonly maxlength='20' value='".$row2[0]."'></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$req['name']."'></td>
</tr>
<tr>
<td align='left'><b>Level:</b></td>
<td align='left'><input type='text' name='new_wLevel' readonly=readonly maxlength='20' value='".$row2[3]."'></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$req['level']."'></td>
</tr>
<tr>
<td align='left'><b>DIL Inventory:</b></td>
<td align='left'><input type='text' name='new_dwMoney' readonly=readonly maxlength='20' value='".$row2[2]."'></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$req['dil']."'></td>
</tr>
<tr>
<td align='left'><b>Reborn:</b></td>
<td align='left'><input type='text' name='new_reborn' readonly=readonly maxlength='20' value='".$row2[4]."'></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$req['reborn']."'></td>
</tr>
<tr>
<td align='left' colspan='3'>
<input type='submit' value='Yes, make me reborn'>
</tr>
</table>
</form></center>";
}
}
// WARNING YOU NEED TO CHANGE "/170/" IF YOU CHANGED YOUR REQUIREMENTS
} elseif(!preg_match("/170/", $_POST['new_wLevel'])) {
echo "<br><center>The level does not match the requirements.<br><a href='javascript:history.back()'>Go Back</a></center>";
// WARNING YOU NEED TO CHANGE "/50000000/" IF YOU CHANGED YOUR REQUIREMENTS
// } elseif(!preg_match("/50000000/", $_POST['new_dwMoney'])) {
// echo "<br><center>The dill does not match the requirements.<br><a href='javascript:history.back()'>Go Back</a></center>";
// if step 2 is ok go to step 3
// OK time for step 3
} else if ($_GET['step'] == "3"){
$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result3 = mssql_query("
USE character;
EXEC RemoteReborn '".$_POST['new_name']."'
",$ms_con);
$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result4 = mssql_query("SELECT character_name,dwExp,wLevel,wStr,wDex,wCon,wSpr,dwMoney,wStatPoint,wSkillPoint,Reborn FROM character.dbo.user_character WHERE character_name = '".$_POST['new_name']."'",$ms_con);
$row4 = mssql_fetch_array($result4);
echo"<center><table class='innertab'>
<tr>
<td colspan='3' align='left'><b><center>".$text['done']."</center></b></td>
</tr>
<tr>
<td colspan='3' align='left'> </td>
</tr>
<tr>
<td align='left'><b>".$text['table1']."</b></td>
<td align='left'><b>".$text['table2']."</b></td>
</tr>
<tr>
<td align='left'><b>Character Name:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[0]."'></td>
</tr>
<tr>
<td align='left'><b>Exp:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[1]."'></td>
</tr>
<tr>
<td align='left'><b>Level:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[2]."'></td>
</tr>
<tr>
<td align='left'><b>Str points:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[3]."'></td>
</tr>
<tr>
<td align='left'><b>Dex points:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[4]."'></td>
</tr>
<tr>
<td align='left'><b>Con points:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[5]."'></td>
</tr>
<tr>
<td align='left'><b>Spr points:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[6]."'></td>
</tr>
<tr>
<td align='left'><b>Dill:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[7]."'></td>
</tr>
<tr>
<td align='left'><b>Stat points:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[8]."'></td>
</tr>
<tr>
<td align='left'><b>Dil Inventory:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[9]."'></td>
</tr>
<tr>
<td align='left'><b>Reborn:</b></td>
<td align='left'><input type='text' readonly=readonly maxlength='20' value='".$row4[10]."'></td>
</tr>
</table></center>";
echo "<center><br><a href='reborn.php'>Thank you! Take me back now.</a></center>";
}
else echo"<p>Something went wrong, lol.";
?>
|
|
|
|
|
04/16/2011, 03:07
|
#5
|
elite*gold: 0
Join Date: Jan 2010
Posts: 114
Received Thanks: 10
|
bump pls help me !
|
|
|
|
|
04/18/2011, 07:25
|
#6
|
elite*gold: 0
Join Date: Jan 2010
Posts: 114
Received Thanks: 10
|
pls help me !
|
|
|
|
|
04/18/2011, 12:15
|
#7
|
elite*gold: 0
Join Date: Oct 2008
Posts: 266
Received Thanks: 96
|
come on lazy man...
look into config.inc.php
setup your sql connect
|
|
|
|
|
04/18/2011, 20:17
|
#8
|
elite*gold: 0
Join Date: Jan 2010
Posts: 114
Received Thanks: 10
|
Quote:
Originally Posted by theoners
come on lazy man...
look into config.inc.php
setup your sql connect
|
user and password to connect to sql are correct
|
|
|
|
|
04/18/2011, 21:14
|
#9
|
elite*gold: 0
Join Date: Aug 2007
Posts: 554
Received Thanks: 136
|
he means make sure you've allowed teh correct functions through config.inc.php
|
|
|
|
|
04/19/2011, 17:17
|
#10
|
elite*gold: 0
Join Date: Jan 2010
Posts: 114
Received Thanks: 10
|
Quote:
Originally Posted by xfactorbowler
he means make sure you've allowed teh correct functions through config.inc.php
|
I don't know language php
u can help me ?
|
|
|
|
|
04/21/2011, 15:22
|
#11
|
elite*gold: 0
Join Date: Jan 2010
Posts: 114
Received Thanks: 10
|
bump help help !
|
|
|
|
|
04/23/2011, 09:28
|
#12
|
elite*gold: 0
Join Date: Jan 2010
Posts: 114
Received Thanks: 10
|
|
|
|
|
 |
Similar Threads
|
WV Player Online | Script
07/14/2010 - Metin2 Private Server - 3 Replies
Hallo.
Kan mir einer ein Script geben wo anzeigt
wv player Online sind
|
Player Online Anzeige in Rank_Liste?
05/09/2010 - Metin2 Private Server - 2 Replies
Hallöchin,
Ich habe nichts in SUFU gefunden des wegen frage ich euch.
Kann maann in die Rankliste eine Online anzeige einbauen?
Oder so wie bei Aspiremt2=? Aspiremt2= h t t p : / / a x p i r e m t 2.x x x
Bei x=s
Bei xxx=com
|
Total Player Online
08/30/2009 - CO2 Private Server - 23 Replies
Im using Binary 5065 i want to add in my reg page Code
to know how many players online on server
like this
Total Accounts: 357
Total Characters: 281
Total Player Online: <---- i want to add this
Server Status: Online
|
Hello im new and im a Tantra Online player
07/22/2009 - Say Hello - 0 Replies
hi to all tantra players if have something to share from tantra online please do so thanks a lot:)
|
[HELP][PHP]TQ Binares - Player online status
03/06/2009 - CO2 Private Server - 5 Replies
TQ Binares - Player online status
Hey everybody! I need a script for looking how many player online in server. Thanks :) :bandit:
|
All times are GMT +1. The time now is 01:35.
|
|
![[help]I can view player online](https://www.elitepvpers.com/forum/iconimages/dekaron-private-server/help-i-can-view-player-online_ltr.gif){kind=small}
