|
You last visited: Today at 22:47
Advertisement
[Requests] Who needs ... ?
Discussion on [Requests] Who needs ... ? within the Dekaron Private Server forum part of the Dekaron category.
10/10/2009, 08:29
|
#16
|
elite*gold: 20 
Join Date: Dec 2007
Posts: 1,450
Received Thanks: 833
|
Sorry, I wan't able to start working on this...
I am at my grandma's house, and, of course, she doesn't have Dreamweaver...
So I will start working on those as soon as I get home, and that will be in around 5 hours...
Peace. Gotta go water some potatoes.
|
|
|
|
10/10/2009, 08:32
|
#17
|
elite*gold: 0
Join Date: Aug 2009
Posts: 1,297
Received Thanks: 928
|
u have to have DW zombe :O
|
|
|
|
|
10/10/2009, 08:42
|
#18
|
elite*gold: 20
Join Date: Nov 2007
Posts: 2,853
Received Thanks: 1,876
|
i want to marry DW 
i LOVE it !!!
ok iam ckecking "freeskier4lif3" php code
EDIT: does it need to be ODBC ?
EDIT2: Give that script to zombe, hes got a cookie login, and i might need it for this
|
|
|
|
|
10/10/2009, 10:30
|
#19
|
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
|
Need script that entering User ID you can see what characters belongs to that user. Thx. And I know that Zombe has it, but can't find him online.
|
|
|
|
|
10/10/2009, 10:36
|
#20
|
elite*gold: 20
Join Date: Nov 2007
Posts: 2,853
Received Thanks: 1,876
|
i have one also, ill post it
EDIT: zombe was too slow again so ..
gedimazs here is your script
Call it: usercharacter.php !!
PHP Code:
<?php
// written by janvier123
// Please fill in your MSSQL Info
//<--! begin MSSQL info !-->
$mssql = array(
'host' => "localhost", // Normaly "localhost" or "XXX.XXX.XXX.XXX"
'user' => "sa", // Your username for MSSQL server, normaly "sa"
'pass' => "server" // Your password for MSSQL server
);
//<--! end MSSQL info !-->
$accname = $_POST['accname'];
if ($_GET['step'] == ""){
echo'<center><Form Name ="form" action="usercharacter.php?step=2" Method ="POST">';
echo'Enter <b>Account</b> Name<p>';
echo'<input name="accname" type="text" value="">';
echo'<br>';
echo'<input type="hidden" name="select" value="1">';
echo'<input name="submit" type="submit" value="Next ...">';
echo'</form></center>';
} else if ($_GET['step'] == "2"){
if($_POST['select']) {
$accname = $_POST['accname'];
echo "<center><form action='usercharacter.php?step=3' method='POST'>
<table class='innertab'>
<tr>
<td colspan='2' align='left'><b><u>Character(s) found! Please select one.</b></u></td>
</tr>
<tr>
<td colspan='2' align='left'> </td>
</tr>
<tr>
<td align='left'>Character Name</td>
<td><select name='accname'>";
$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result2 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE WHERE user_id = '".$accname."'",$ms_con);
$row2 = mssql_fetch_row($result2);
$result3 = mssql_query("SELECT character_name FROM character.dbo.user_character WHERE user_no = '".$row2[0]."'",$ms_con);
while($row3 = mssql_fetch_row($result3))
echo "<option value='".$row2[0]."'>".$row3[0]."</option>";
}
echo "</select></td>
</tr>
<tr>
<td align='left' colspan='2'>
<input type='hidden' name='user_no' value='".$row2[0]."'>
<input type='submit' value='Show character stats'>
</td>
</tr>
</table>
</form></center>";
} else if ($_GET['step'] == "3"){
// ------------------------------
if($_POST['user_no']) {
$classes = array('0' => "Azure Knight", '1' => "Segita Hunter", '2' => "Incar Magician", '3' => "Vicious Summoner", '4' => "Segnale", '5' => "Bagi Warrior");
$statreset = array('0' => "Unused", '1' => "Used");
$skillreset = array('0' => "Unused", '1' => "Used");
$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
// IF you dont have the "Reborn" table in your mssql database under character.dbo.user_character
// please remove the "Reborn" from the list below.
$result5 = mssql_query("SELECT character_no,user_no,dwExp,dwMoney,dwStoreMoney,wStr,wDex,wCon,wSpr,wRetPosX,wRetPosY,wRetMapIndex,wStatPoint,wSkillPoint,wLevel,byPCClass,wPKCount,wChaoticLevel,dwPVPPoint,wWinRecord,wLoseRecord,wDrawRecord,Reborn,bySkillClearCount,byStatClearCount,character_name,dwAdv FROM character.dbo.user_character WHERE user_no = '".$_POST['user_no']."'",$ms_con);
$row5 = mssql_fetch_row($result5);
echo "<center><br>
<table class='innertab'>
<tr>
<td colspan='3' align='left'><b><u>Character Stats</b></u></td>
</tr>
<tr>
<td colspan='3' align='left'> </td>
</tr>
<tr>
<td align='left'>---------- Type ----------</td>
<td align='left'>---------- Current Stats ----------</td>
</tr>
<tr>
<td align='left'>Character Name</td>
<td align='left'>".$row5[25]."</td>
</tr>
<tr>
<td align='left'>Experience</td>
<td align='left'>".$row5[2]."</td>
</tr>
<tr>
<td align='left'>Adv</td>
<td align='left'>".$row5[26]."</td>
</tr>
<tr>
<td align='left'>Level</td>
<td align='left'>".$row5[14]."</td>
</tr>
<tr>
<td align='left'>Class</td>
<td align='left'>".$classes[$row5[15]]."</td>
</tr>
<tr>
<td align='left'>Str</td>
<td align='left'>".$row5[5]."</td>
</tr>
<tr>
<td align='left'>Dex</td>
<td align='left'>".$row5[6]."</td>
</tr>
<tr>
<td align='left'>Con</td>
<td align='left'>".$row5[7]."</td>
</tr>
<tr>
<td align='left'>Spr</td>
<td align='left'>".$row5[8]."</td>
</tr>
<tr>
<td align='left'>DIL Inventory</td>
<td align='left'>".$row5[3]."</td>
</tr>
<tr>
<td align='left'>DIL Warehouse</td>
<td align='left'>".$row5[4]."</td>
</tr>
<tr>
<td align='left'>Return Map</td>
<td align='left'>".$row5[11]."</td>
</tr>
<tr>
<td align='left'>Free stats points</td>
<td align='left'>".$row5[12]."</td>
</tr>
<tr>
<td align='left'>Free skill points</td>
<td align='left'>".$row5[13]."</td>
</tr>
<tr>
<td align='left'>Total PvP</td>
<td align='left'>".$row5[18]."</td>
</tr>
<tr>
<td align='left'>PvP Obtained</td>
<td align='left'>".$row5[19]."</td>
</tr>
<tr>
<td align='left'>PvP Lost</td>
<td align='left'>".$row5[20]."</td>
</tr>
<tr>
<td align='left'>PvP Draw</td>
<td align='left'>".$row5[21]."</td>
</tr>
<tr>
<td align='left'>PK points</td>
<td align='left'>".$row5[16]."</td>
</tr>
<tr>
<td align='left'>Chaotic Level (IP)</td>
<td align='left'>".$row5[17]."</td>
</tr>";
// IF you dont have the "Reborn" table in your mssql database under character.dbo.user_character
// please remove the "Reborn" from the list below.
echo "
<tr>
<td align='left'>Reborn</td>
<td align='left'>".$row5[22]."</td>
</tr>
<tr>
<td align='left'>Skill Reset</td>
<td align='left'>".$skillreset[$row5[23]]."</td>
</tr>
<tr>
<td align='left'>Stats Reset</td>
<td align='left'>".$statreset[$row5[24]]."</td>
</tr>
<tr>
</tr>
</table>
</center>";
}
}
?>
|
|
|
|
|
10/10/2009, 13:30
|
#21
|
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
|
Big fat thanks for the script !
|
|
|
|
|
10/10/2009, 13:36
|
#22
|
elite*gold: 20
Join Date: Dec 2007
Posts: 1,450
Received Thanks: 833
|
Here, my version of the appointed characters listing script...
PHP Code:
<?php
/* -------------{The appointed characters listing page by Zombe}------------- */
$MSSQLserverIP = 'localhost'; // IP goes here
$MSSQLusername = 'sa'; // MSSQL username goes here
$MSSQLpassword = 'password'; // MSSQL password goes here
// Don't edit below if you don't know what you are doing.
$link = mssql_connect ("$MSSQLserverIP", "$MSSQLusername", "$MSSQLpassword");
if(!$link)
{
die('Something went wrong while connecting to MSSQL');
}
echo'<center>';
echo'<Form Name ="form0" Method ="POST">';
echo'Enter an account name:<p>';
echo'<input name="name" type="text"><p>';
echo'<input name="submit" type="submit" value="Get character list!"><p>';
echo'</form0>';
$name = $_POST['name'];
if ($name)
{
$result2 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_id = '$name'",$link);
$row2 = mssql_fetch_array($result2);
$user_no = "$row2[user_no]";
$login = "$row2[login_time]";
$logout = "$row2[logout_time]";
if (($login) && ($logout) && ($login > $logout)) $status = 'Online';
else $status = 'Offline';
if ($user_no)
{
echo "
<p> <p> <p>
The account <b>$name</b> has the following characters:<br><table border='1'><p> 
<tr>
<td align='center'><b>Char. No</b></td>
<td align='center'><b>Char. Name</b></td>
<td align='center'><b>Level</b></td>
<td align='center'><b>Class</b></td>
<td align='center'><b>Map index</b></td>
<td align='center'><b>Status</b></td>
</tr>
";
}
else echo 'No such account';
$result = mssql_query("SELECT * FROM character.dbo.user_character WHERE user_no = '$user_no'",$link);
while ($record = mssql_fetch_array($result))
{
if ($record[byPCClass] == 0) $class = 'Azure Knight';
if ($record[byPCClass] == 1) $class = 'Segita Hunter';
if ($record[byPCClass] == 2) $class = 'Incar Magician';
if ($record[byPCClass] == 3) $class = 'Vicious Summoner';
if ($record[byPCClass] == 4) $class = 'Segnale';
if ($record[byPCClass] == 5) $class = 'Bagi Warrior';
if ($record[byPCClass] == 6) $class = 'Aloken';
if (($record[login_time]) && ($record[logout_time]) && ($record[login_time] > $record[logout_time])) $status = 'Online';
else $status = 'Offline';
echo "
<tr>
<td align='center'>$record[character_no]</td>
<td align='center'>$record[character_name]</td>
<td align='center'>$record[wLevel]</td>
<td align='center'>$class</td>
<td align='center'>$record[wMapIndex]</td>
<td align='center'>$status</td>
</tr>
";
}
}
?>
Preview:
EDIT: Back from grandma, yaaaay! ^_^
EDIT2: Made it show character_no.
|
|
|
|
|
10/10/2009, 14:02
|
#23
|
elite*gold: 0
Join Date: Sep 2009
Posts: 48
Received Thanks: 3
|
Quote:
Originally Posted by janvier123
i said USEFULL comments !
not retarded ones
PHP Code:
$q = "SELECT * FROM account.dbo.USER_PROFILE WHERE login_flag = '1100'";
$r = mssql_query($q);
$sad = mssql_num_rows($r);
echo "<div align=left>Total Characters Online: $sad";
like that ?
srr i use my own code, i know there are other ways |
sorry but i am not here to test u or anything .
i want that script and u opened this topic to help .
so if u cant make this script for me so tell me that i cant do .
dont tell me that my comment is retarded .
EDIT :
any chance to make my script plz ?
|
|
|
|
|
10/10/2009, 14:18
|
#24
|
elite*gold: 20
Join Date: Dec 2007
Posts: 1,450
Received Thanks: 833
|
Online characters listing script, as requested.
PHP Code:
<?php
/* -------------{The online characters listing page by Zombe}------------- */
$MSSQLserverIP = 'localhost'; // IP goes here
$MSSQLusername = 'sa'; // MSSQL username goes here
$MSSQLpassword = 'password'; // MSSQL password goes here
// Don't edit below if you don't know what you are doing.
$link = mssql_connect ("$MSSQLserverIP", "$MSSQLusername", "$MSSQLpassword");
if(!$link)
{
die('Something went wrong while connecting to MSSQL');
}
echo "
<center>
<b><font size = 5>Online characters list:</font><b><br><table border='1'><p> 
<tr>
<td align='center'><b>Char. Name</b></td>
<td align='center'><b>Account</b></td>
<td align='center'><b>Class</b></td>
<td align='center'><b>Level</b></td>
<td align='center'><b>Map</b></td>
</tr>
";
$result = mssql_query("SELECT * FROM character.dbo.user_character WHERE login_time > logout_time",$link);
while ($record = mssql_fetch_array($result))
{
if ($record[byPCClass] == 0) $class = 'Azure Knight';
if ($record[byPCClass] == 1) $class = 'Segita Hunter';
if ($record[byPCClass] == 2) $class = 'Incar Magician';
if ($record[byPCClass] == 3) $class = 'Vicious Summoner';
if ($record[byPCClass] == 4) $class = 'Segnale';
if ($record[byPCClass] == 5) $class = 'Bagi Warrior';
if ($record[byPCClass] == 6) $class = 'Aloken';
$user_no = $record[user_no];
$result3 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE WHERE user_no = '$user_no'",$link);
$row3 = mssql_fetch_array($result3);
$account = "$row3[user_id]";
echo "
<tr>
<td align='center'>$record[character_name]</td>
<td align='center'>$account</td>
<td align='center'>$class</td>
<td align='center'>$record[wLevel]</td>
<td align='center'>$record[wMapIndex]</td>
</tr>
";
}
?>
Preview:
EDIT: I'll get on lol2k1's script now, even if I don't like that guy at all...
|
|
|
|
|
10/10/2009, 14:34
|
#25
|
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
|
New quest for Zombe and janvier123. Make the script that admin could send messages to players from web and write announcements from web.
I think send messages it is possible to make, but it will be harder to make announcements writting when you are not connected to the game
Good luck guys.
|
|
|
|
|
10/11/2009, 15:13
|
#26
|
elite*gold: 0
Join Date: Sep 2009
Posts: 48
Received Thanks: 3
|
i already asked to make script and u ignored .
so FAIL
|
|
|
|
|
10/11/2009, 16:46
|
#27
|
elite*gold: 0
Join Date: Feb 2008
Posts: 231
Received Thanks: 99
|
Quote:
Originally Posted by lol2k1
i already asked to make script and u ignored .
so FAIL
|
Are you retarded?
Quote:
Originally Posted by Zombe
Online characters listing script, as requested.
EDIT: I'll get on lol2k1's script now, even if I don't like that guy at all...
|
look at Zombe edit it was made before your post he didn't ignored you..
|
|
|
|
|
10/11/2009, 16:47
|
#28
|
elite*gold: 0
Join Date: Sep 2007
Posts: 70
Received Thanks: 14
|
what about Edit characters , like Hp, dil, MP , name , reborn , dill, stats etc ...
|
|
|
|
|
10/11/2009, 18:44
|
#29
|
elite*gold: 20
Join Date: Dec 2007
Posts: 1,450
Received Thanks: 833
|
Quote:
Originally Posted by seias
what about Edit characters , like Hp, dil, MP , name , reborn , dill, stats etc ...
|
Hmm, ok, that I can make, but I am going away from the PC, so I will start on it tomorrow.
And about that aloken script, creating a character not in-game is quite hard, how about...
Creating any character in-game, specifying the name and changing it to aloken? With username and password verification of course, and works only on level 1 characters... That's good enough?
|
|
|
|
|
10/11/2009, 19:59
|
#30
|
elite*gold: 0
Join Date: Oct 2006
Posts: 57
Received Thanks: 10
|
Quote:
Originally Posted by Zombe
how about...
Creating any character in-game, specifying the name and changing it to aloken? With username and password verification of course, and works only on level 1 characters... That's good enough?
|
yay prolly nice suggestion on the script to release cant wait.. 
|
|
|
|
 |
|
Similar Threads
|
Few Requests
10/25/2008 - CO2 Private Server - 2 Replies
hey all i tried to make my own job center and the npcs but i have problems with the npcs so does anyone has the full working code for the job npcs
2nd request how can u make more rbs then 2 ? like that someone can rb 3-4 or more times ?
i'll appreciate every helpfull post
u can post it here or add my msn [email protected]
|
Some Requests
04/27/2008 - Conquer Online 2 - 0 Replies
First i need To Know Whats Should I Do With The Petals And White Flowers I get From The Second Reb Quest
Second My Friend Tell me That He Upgrade The Lvl Of His Super Bow From Lvl 115 To 120 With Just 31 Meteors Not Db Is That Right
|
Requests---PLEASE D:
01/26/2008 - CO2 Weapon, Armor, Effects & Interface edits - 1 Replies
Ok. Im getting pretty bored with the blue stuff from cyclone. I know someone has made a cyclone mod before but i didnt like it :/ It had these weird wings and it sortve ruined it. I was wondering if someone would make me a red/green cyclone which was like the winged one in this forum (cant remember what page it was-it was an old one though...).
I also play a Fire Taoist and a Trojan (hence the cyclone). Do you, the reader, think that you could make a mod that makes Taoist's Backswords glow?...
|
2 Requests
10/24/2006 - World of Warcraft - 3 Replies
Also ich weiss nicht, wie genau das abläuft, aber ich möchte fragen, ob es geht, dass wenn ich meinen Char spiele und egal welches Equip Teil ich habe, jedesmal das gleiche andere angezeigt wird.
Also zB bei meinem Jäger.. Wenn ich nun T0 anhab, soll T1 angezeigt werden, aber auch wenn ich T2 oder was ganz anderes anhab. Und für meinen Schurken hätte ich gerne ganzes T1. Wäre toll wenn mir da jemand was machen könnte, wenn es überhaupt umsetzbar ist. Wichtiger ist mir btw der Schurke. :)
...
|
All times are GMT +2. The time now is 22:47.
|
|
![[Requests] Who needs ... ?](https://www.elitepvpers.com/forum/iconimages/dekaron-private-server/requests-who-needs_ltr.gif){kind=small}
