Complete Script showing Banned, Staff and Legends

Printable View

12-03-07
TheKamikaze

Complete Script showing Banned, Staff and Legends

Hi all,

i just have made this small script for all people who want to show :

- Banned member,
- Staff
- Legend Member

If you want to show legend member, you'll have to do this following query :

Code:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Character]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) alter table [dbo].[Character] GO CREATE TABLE [dbo].[Character] ( [AccountID] [varchar] (10) COLLATE Polish_CI_AS NOT NULL , [Name] [varchar] (10) COLLATE Polish_CI_AS NOT NULL , [cLevel] [int] NULL , [LevelUpPoint] [int] NULL , [Class] [tinyint] NULL , [Experience] [int] NULL , [Strength] [smallint] NULL , [Dexterity] [smallint] NULL , [Vitality] [smallint] NULL , [Energy] [smallint] NULL , [Inventory] [varbinary] (1080) NULL , [MagicList] [varbinary] (180) NULL , [Money] [int] NULL , [Life] [real] NULL , [MaxLife] [real] NULL , [Mana] [real] NULL , [MaxMana] [real] NULL , [MapNumber] [smallint] NULL , [MapPosX] [smallint] NULL , [MapPosY] [smallint] NULL , [MapDir] [tinyint] NULL , [PkCount] [int] NULL , [PkLevel] [int] NULL , [PkTime] [int] NULL , [MDate] [smalldatetime] NULL , [LDate] [smalldatetime] NULL , [CtlCode] [tinyint] NULL , [DbVersion] [tinyint] NULL , [Quest] [varbinary] (50) NULL , [Leadership] [smallint] NULL , [ChatLimitTime] [smallint] NULL , [Resets] [int] NOT NULL , [Legend] [varchar] (1) COLLATE Polish_CI_AS NULL ) ON [PRIMARY] GO

And now, put this script anywhere on your website :)

PHP Code:

<style type="text/css">  </style> <div align="center"><strong>Members Information : <span class="Style1"><a href="?ask=Banned" id="Banned" name="Banned" target="_self">Banned</a></span> - <span class="Style2"><a href="?ask=Staff">Staff</a></span> - <span class="Style3"><a href="?ask=Legend">Legend</a></span></strong></div> <? error_reporting(E_ALL ^E_NOTICE ^E_WARNING); mssql_connect('localhost','Administrateurs','clavier'); mssql_select_db('MuOnline'); if (($_GET["ask"] == 'Banned')) { $query = "Select * From Character WHERE CtlCode = '1'"; $do_query = mssql_query($query); echo '<br><br>'; echo '<center><table width=\"500\" border=\"1\">'; echo '<tr><th width=\"200\"><center>Name</th><th width=\"50\"><center>Location</th><th width=\"100\"><center>Level</th><th width=\"100\"><center>Status</th></tr>'; while ($show = mssql_fetch_assoc($do_query)){ if($show['MapNumber'] == 0){ $map = 'Lorencia'; } if($show['MapNumber'] == 1){ $map = 'Dungeon'; } if($show['MapNumber'] == 2){ $map = 'Davias'; } if($show['MapNumber'] == 3){ $map = 'Noria'; } if($show['MapNumber'] == 4){ $map = 'Losttower'; } if($show['MapNumber'] == 5){ $map = 'Exile'; } if($show['MapNumber'] == 8){ $map = 'Tarkan'; } if($show['MapNumber'] == 7){ $map = 'Atlans'; } if($show['MapNumber'] == 6){ $map = 'Arena'; } if($show['MapNumber'] == 9){ $map = 'Devil Square'; } if($show['MapNumber'] == 10){ $map = 'Icarus'; } if($show['MapNumber'] == 11){ $map = 'Blood Caslte1'; } if($show['MapNumber'] == 12){ $map = 'Blood Caslte2'; } if($show['MapNumber'] == 13){ $map = 'Blood Caslte3'; } if($show['MapNumber'] == 14){ $map = 'Blood Caslte4'; } if($show['MapNumber'] == 15){ $map = 'Blood Caslte5'; } if($show['MapNumber'] == 16){ $map = 'Blood Caslte6'; } if($show['MapNumber'] == 0){ $row2[0] ='<font color=orange><b>OFFLINE'; } if($show['MapNumber'] == 1){ $row2[0] ='<font color=white><b>ONLINE'; } echo '<tr><td width=\"200\"><center>'.$show['Name'].'</td><td width=\"50\"><center>'.$map.'</td><td width=\"100\"><center>'.$show['cLevel'].'</td><td width=\"100\"><center>Don\'t Work</td></tr>'; } } elseif (($_GET["ask"] == 'Staff')) { $query = "Select * From Character WHERE CtlCode = '32'"; $do_query = mssql_query($query); echo '<br><br>'; echo '<center><table width=\"500\" border=\"1\">'; echo '<tr><th width=\"200\"><center>Name</th><th width=\"50\"><center>Location</th><th width=\"100\"><center>Level</th><th width=\"100\"><center>Status</th></tr>'; while ($show = mssql_fetch_assoc($do_query)){ if($show['MapNumber'] == 0){ $map = 'Lorencia'; } if($show['MapNumber'] == 1){ $map = 'Dungeon'; } if($show['MapNumber'] == 2){ $map = 'Davias'; } if($show['MapNumber'] == 3){ $map = 'Noria'; } if($show['MapNumber'] == 4){ $map = 'Losttower'; } if($show['MapNumber'] == 5){ $map = 'Exile'; } if($show['MapNumber'] == 8){ $map = 'Tarkan'; } if($show['MapNumber'] == 7){ $map = 'Atlans'; } if($show['MapNumber'] == 6){ $map = 'Arena'; } if($show['MapNumber'] == 9){ $map = 'Devil Square'; } if($show['MapNumber'] == 10){ $map = 'Icarus'; } if($show['MapNumber'] == 11){ $map = 'Blood Caslte1'; } if($show['MapNumber'] == 12){ $map = 'Blood Caslte2'; } if($show['MapNumber'] == 13){ $map = 'Blood Caslte3'; } if($show['MapNumber'] == 14){ $map = 'Blood Caslte4'; } if($show['MapNumber'] == 15){ $map = 'Blood Caslte5'; } if($show['MapNumber'] == 16){ $map = 'Blood Caslte6'; } if($show['MapNumber'] == 0){ $row2[0] ='<font color=orange><b>OFFLINE'; } if($show['MapNumber'] == 1){ $row2[0] ='<font color=white><b>ONLINE'; } echo '<tr><td width=\"200\"><center>'.$show['Name'].'</td><td width=\"50\"><center>'.$map.'</td><td width=\"100\"><center>'.$show['cLevel'].'</td><td width=\"100\"><center>Don\'t Work</td></tr>'; } } elseif (($_GET["ask"] == 'Legend')) { $query = "Select * From Character WHERE Legend = '1'"; $do_query = mssql_query($query); echo '<br><br>'; echo '<center><table width=\"500\" border=\"1\">'; echo '<tr><th width=\"200\"><center>Name</th><th width=\"50\"><center>Location</th><th width=\"100\"><center>Level</th><th width=\"100\"><center>Status</th></tr>'; while ($show = mssql_fetch_assoc($do_query)){ if($show['MapNumber'] == 0){ $map = 'Lorencia'; } if($show['MapNumber'] == 1){ $map = 'Dungeon'; } if($show['MapNumber'] == 2){ $map = 'Davias'; } if($show['MapNumber'] == 3){ $map = 'Noria'; } if($show['MapNumber'] == 4){ $map = 'Losttower'; } if($show['MapNumber'] == 5){ $map = 'Exile'; } if($show['MapNumber'] == 8){ $map = 'Tarkan'; } if($show['MapNumber'] == 7){ $map = 'Atlans'; } if($show['MapNumber'] == 6){ $map = 'Arena'; } if($show['MapNumber'] == 9){ $map = 'Devil Square'; } if($show['MapNumber'] == 10){ $map = 'Icarus'; } if($show['MapNumber'] == 11){ $map = 'Blood Caslte1'; } if($show['MapNumber'] == 12){ $map = 'Blood Caslte2'; } if($show['MapNumber'] == 13){ $map = 'Blood Caslte3'; } if($show['MapNumber'] == 14){ $map = 'Blood Caslte4'; } if($show['MapNumber'] == 15){ $map = 'Blood Caslte5'; } if($show['MapNumber'] == 16){ $map = 'Blood Caslte6'; } if($show['MapNumber'] == 0){ $row2[0] ='<font color=orange><b>OFFLINE'; } if($show['MapNumber'] == 1){ $row2[0] ='<font color=white><b>ONLINE'; } echo '<tr><td width=\"200\"><center>'.$show['Name'].'</td><td width=\"50\"><center>'.$map.'</td><td width=\"100\"><center>'.$show['cLevel'].'</td><td width=\"100\"><center>Don\'t Work</td></tr>'; } } ?>
12-03-07
HELL_IN_HEAVEN

Re: [Release] Complete Script

it is nice if u add, the recent date played.
12-03-07
Disconnect1

Re: [Release] Complete Script

Don`t work for me :/
12-03-07
TheKamikaze

Re: [Release] Complete Script

suppose to work for all.
the date, i'll try to add it ;)
13-03-07
HELL_IN_HEAVEN

Re: [Release] Complete Script

Quote:

Originally Posted by TheKamikaze

suppose to work for all.
the date, i'll try to add it ;)

is it possible to show how many counts an account plays in a month? example he only plays 4x in the month of february..?
13-03-07
crazylion

Re: [Release] Complete Script

Nice release. Work fine for me.
13-03-07
TheKamikaze

Re: [Release] Complete Script

Hmm maybe but this need a major modification.
i'll add it on my next release :)
15-03-07
denitu

Re: [Release] Complete Script

Thanks Men :)
15-03-07
zolamu

Re: [Release] Complete Script

Nice Thanks
23-03-07
Razvan_dc_gl

Re: [Release] Complete Script

Quote:

Originally Posted by TheKamikaze

Hi all,

i just have made this small script for all people who want to show :

- Banned member,
- Staff
- Legend Member

If you want to show legend member, you'll have to do this following query :

Code:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Character]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) alter table [dbo].[Character] GO CREATE TABLE [dbo].[Character] ( [AccountID] [varchar] (10) COLLATE Polish_CI_AS NOT NULL , [Name] [varchar] (10) COLLATE Polish_CI_AS NOT NULL , [cLevel] [int] NULL , [LevelUpPoint] [int] NULL , [Class] [tinyint] NULL , [Experience] [int] NULL , [Strength] [smallint] NULL , [Dexterity] [smallint] NULL , [Vitality] [smallint] NULL , [Energy] [smallint] NULL , [Inventory] [varbinary] (1080) NULL , [MagicList] [varbinary] (180) NULL , [Money] [int] NULL , [Life] [real] NULL , [MaxLife] [real] NULL , [Mana] [real] NULL , [MaxMana] [real] NULL , [MapNumber] [smallint] NULL , [MapPosX] [smallint] NULL , [MapPosY] [smallint] NULL , [MapDir] [tinyint] NULL , [PkCount] [int] NULL , [PkLevel] [int] NULL , [PkTime] [int] NULL , [MDate] [smalldatetime] NULL , [LDate] [smalldatetime] NULL , [CtlCode] [tinyint] NULL , [DbVersion] [tinyint] NULL , [Quest] [varbinary] (50) NULL , [Leadership] [smallint] NULL , [ChatLimitTime] [smallint] NULL , [Resets] [int] NOT NULL , [Legend] [varchar] (1) COLLATE Polish_CI_AS NULL ) ON [PRIMARY] GO

And now, put this script anywhere on your website :)

PHP Code:

<style type="text/css">  </style> <div align="center"><strong>Members Information : <span class="Style1"><a href="?ask=Banned" id="Banned" name="Banned" target="_self">Banned</a></span> - <span class="Style2"><a href="?ask=Staff">Staff</a></span> - <span class="Style3"><a href="?ask=Legend">Legend</a></span></strong></div> <? error_reporting(E_ALL ^E_NOTICE ^E_WARNING); mssql_connect('localhost','Administrateurs','clavier'); mssql_select_db('MuOnline'); if (($_GET["ask"] == 'Banned')) { $query = "Select * From Character WHERE CtlCode = '1'"; $do_query = mssql_query($query); echo '<br><br>'; echo '<center><table width=\"500\" border=\"1\">'; echo '<tr><th width=\"200\"><center>Name</th><th width=\"50\"><center>Location</th><th width=\"100\"><center>Level</th><th width=\"100\"><center>Status</th></tr>'; while ($show = mssql_fetch_assoc($do_query)){ if($show['MapNumber'] == 0){ $map = 'Lorencia'; } if($show['MapNumber'] == 1){ $map = 'Dungeon'; } if($show['MapNumber'] == 2){ $map = 'Davias'; } if($show['MapNumber'] == 3){ $map = 'Noria'; } if($show['MapNumber'] == 4){ $map = 'Losttower'; } if($show['MapNumber'] == 5){ $map = 'Exile'; } if($show['MapNumber'] == 8){ $map = 'Tarkan'; } if($show['MapNumber'] == 7){ $map = 'Atlans'; } if($show['MapNumber'] == 6){ $map = 'Arena'; } if($show['MapNumber'] == 9){ $map = 'Devil Square'; } if($show['MapNumber'] == 10){ $map = 'Icarus'; } if($show['MapNumber'] == 11){ $map = 'Blood Caslte1'; } if($show['MapNumber'] == 12){ $map = 'Blood Caslte2'; } if($show['MapNumber'] == 13){ $map = 'Blood Caslte3'; } if($show['MapNumber'] == 14){ $map = 'Blood Caslte4'; } if($show['MapNumber'] == 15){ $map = 'Blood Caslte5'; } if($show['MapNumber'] == 16){ $map = 'Blood Caslte6'; } if($show['MapNumber'] == 0){ $row2[0] ='<font color=orange><b>OFFLINE'; } if($show['MapNumber'] == 1){ $row2[0] ='<font color=white><b>ONLINE'; } echo '<tr><td width=\"200\"><center>'.$show['Name'].'</td><td width=\"50\"><center>'.$map.'</td><td width=\"100\"><center>'.$show['cLevel'].'</td><td width=\"100\"><center>Don\'t Work</td></tr>'; } } elseif (($_GET["ask"] == 'Staff')) { $query = "Select * From Character WHERE CtlCode = '32'"; $do_query = mssql_query($query); echo '<br><br>'; echo '<center><table width=\"500\" border=\"1\">'; echo '<tr><th width=\"200\"><center>Name</th><th width=\"50\"><center>Location</th><th width=\"100\"><center>Level</th><th width=\"100\"><center>Status</th></tr>'; while ($show = mssql_fetch_assoc($do_query)){ if($show['MapNumber'] == 0){ $map = 'Lorencia'; } if($show['MapNumber'] == 1){ $map = 'Dungeon'; } if($show['MapNumber'] == 2){ $map = 'Davias'; } if($show['MapNumber'] == 3){ $map = 'Noria'; } if($show['MapNumber'] == 4){ $map = 'Losttower'; } if($show['MapNumber'] == 5){ $map = 'Exile'; } if($show['MapNumber'] == 8){ $map = 'Tarkan'; } if($show['MapNumber'] == 7){ $map = 'Atlans'; } if($show['MapNumber'] == 6){ $map = 'Arena'; } if($show['MapNumber'] == 9){ $map = 'Devil Square'; } if($show['MapNumber'] == 10){ $map = 'Icarus'; } if($show['MapNumber'] == 11){ $map = 'Blood Caslte1'; } if($show['MapNumber'] == 12){ $map = 'Blood Caslte2'; } if($show['MapNumber'] == 13){ $map = 'Blood Caslte3'; } if($show['MapNumber'] == 14){ $map = 'Blood Caslte4'; } if($show['MapNumber'] == 15){ $map = 'Blood Caslte5'; } if($show['MapNumber'] == 16){ $map = 'Blood Caslte6'; } if($show['MapNumber'] == 0){ $row2[0] ='<font color=orange><b>OFFLINE'; } if($show['MapNumber'] == 1){ $row2[0] ='<font color=white><b>ONLINE'; } echo '<tr><td width=\"200\"><center>'.$show['Name'].'</td><td width=\"50\"><center>'.$map.'</td><td width=\"100\"><center>'.$show['cLevel'].'</td><td width=\"100\"><center>Don\'t Work</td></tr>'; } } elseif (($_GET["ask"] == 'Legend')) { $query = "Select * From Character WHERE Legend = '1'"; $do_query = mssql_query($query); echo '<br><br>'; echo '<center><table width=\"500\" border=\"1\">'; echo '<tr><th width=\"200\"><center>Name</th><th width=\"50\"><center>Location</th><th width=\"100\"><center>Level</th><th width=\"100\"><center>Status</th></tr>'; while ($show = mssql_fetch_assoc($do_query)){ if($show['MapNumber'] == 0){ $map = 'Lorencia'; } if($show['MapNumber'] == 1){ $map = 'Dungeon'; } if($show['MapNumber'] == 2){ $map = 'Davias'; } if($show['MapNumber'] == 3){ $map = 'Noria'; } if($show['MapNumber'] == 4){ $map = 'Losttower'; } if($show['MapNumber'] == 5){ $map = 'Exile'; } if($show['MapNumber'] == 8){ $map = 'Tarkan'; } if($show['MapNumber'] == 7){ $map = 'Atlans'; } if($show['MapNumber'] == 6){ $map = 'Arena'; } if($show['MapNumber'] == 9){ $map = 'Devil Square'; } if($show['MapNumber'] == 10){ $map = 'Icarus'; } if($show['MapNumber'] == 11){ $map = 'Blood Caslte1'; } if($show['MapNumber'] == 12){ $map = 'Blood Caslte2'; } if($show['MapNumber'] == 13){ $map = 'Blood Caslte3'; } if($show['MapNumber'] == 14){ $map = 'Blood Caslte4'; } if($show['MapNumber'] == 15){ $map = 'Blood Caslte5'; } if($show['MapNumber'] == 16){ $map = 'Blood Caslte6'; } if($show['MapNumber'] == 0){ $row2[0] ='<font color=orange><b>OFFLINE'; } if($show['MapNumber'] == 1){ $row2[0] ='<font color=white><b>ONLINE'; } echo '<tr><td width=\"200\"><center>'.$show['Name'].'</td><td width=\"50\"><center>'.$map.'</td><td width=\"100\"><center>'.$show['cLevel'].'</td><td width=\"100\"><center>Don\'t Work</td></tr>'; } } ?>

don`t work :| make another script ..