[Share] RanCP Administration Panel

[bk2483]

Administration Panel

I have Updated ACP and fixed some bugs. Please redownload the Admin.rar. Please Downlaod my AutoPatch for ACP and put it in your admin directory. This will update your ACP when updates are made. So please download it so it will be easier for me to update ur cp and fix errors. And Please dont edit any of the script so it wont be messed up.

Administration Panel - Options
---------------------------------------
Ban users
un-Ban users
Character Name Changer
Create GM Account
Delete in-active users
See character's stats
Total Users
Total Characters
Total Characters online
Who's Online (Fixed)
Reset User Account Being Connected (ALL) NEW!
---------------------------------------


---------------------------------------
UPDATES NEW!
- UserInfo(Added Search Script) 4-28-2008 userinfo.php
-Added Reset Error and Fixed Announcement.php
---------------------------------------


------------------------------------------------------------------------------
GUIDE
HowTo Use Ban User.
First Field: Type In the UserName of the User you want to blocked (It must be the exact username or it wont recognize it.)
Second Field: Type in the the date of when the character will be unbanned. (Date Format: 3/3/2008 4:15:09 PM )

Adding NameChanger to your RanCP(not ACP)
And Add this a column to your ChaInfo
Column Name: ChaReborn
Type: smallint
Deafult Value: 0
No NULL

ADD This line to your query.php

DEFINE("UPDATE_NAME","UPDATE RanGame1.dbo.ChaInfo SET ChaName = '%s' WHERE ChaName = '%s' ");
DEFINE("SELECT_USER_FULLINFO2", "SELECT UserName, UserPass, UserPass2, UserEmail, UserNum, UserType, UserPoint FROM RanUser.dbo.UserInfo WHERE UserName = '%s' ");

I will add new things once i get a chance. And can anyone please suggest things that i can add cause i dont know wat to make.

Installation And Error Fixed
1.) Extract this the attachment and put it in your htdocs directory ex. C:\Program Files\Abyss Web Server\htdocs

2.) Add this to you UserInfo
Column Name: WebLoginState
Type: smallint
Default Value: 0
NO NULL

3.)Error "Kamu tidak dibenarkan login" (How to Fix)
OK find config.php CHANGE it to your server's config.

<?php
//
$CONFIG['servername'] = "WEBNAME";//Web Name
$CONFIG['dbaddress'] = "YOURCOMPUTER\SQLEXPRESS";//DB IP
$CONFIG['dbuser'] = "sa";//DB ID
$CONFIG['dbpass'] = "1234";//DB PASS
$CONFIG['dbdbname'] = "RanUser";
$CONFIG['dbdbname1'] = "RanGame1";
$CONFIG['dbdbname2'] = "RanShop";
$CONFIG['registration'] = "1";
$CONFIG['maxaccounts'] = "0";
$CONFIG['maxemail'] = "1";
$CONFIG['email'] = "0";
$CONFIG['emailaddress'] = "";
$CONFIG['emailsmtp'] = "";
$CONFIG['emailuser'] = "";
$CONFIG['emailpass'] = "";
?>

4.) Go to http://xxx.xxx.xxx.xxx./admin
To log in you need to have a GM Account (UserType=30)
------------------------------------------------------------------------------


---------------------------------------
SS:

---------------------------------------


---------------------------------------
DOWNLOADS - Updated 5-28-08!

ImmortalCooL Style
MIRROR 1 Rapidshare
MIRROR 2 Mediafire
MIRROR 3 Megaupload
MIRROR 4 FileFront
MIRROR 5 FTP

Cimed's Style
MIRROR 1 RapidShare
MIRROR 2 Mediafire
MIRROR 3 Megaupload
MIRROR 4 Filefront
MIRROR 5 FTP

Patch
AUTOPATCH - For Easy ACP Updates From me!
---------------------------------------

[MentaL]

[smarkies]

Thank you.

Waiting for confirmation before it goes to sticky threads.

[elomeco]

nice job there bk2438...^_^
..wit dis may help alot of us here..hehe thx for the share..^^,

[shinchan]

Wow this is great. This will really come in handy. Thanks.

-------------------------------------------------------

How about add | delete an item in the inventory. Is it possible.

[bk2483]

No prob. Any suggestion on wat i can add.

[michael2k10]

no suggestion thanks man!!!!!

[ushpen]

@bk2483

Dude i have a little problem in login.php..i got this error every time i login in admin panel..

Warning: mssql_query(): message: Invalid column name 'WebLoginState'. (severity 16) in C:\Program Files\Abyss Web Server\htdocs\admin\login.php on line 8

Warning: mssql_query(): Query failed in C:\Program Files\Abyss Web Server\htdocs\admin\login.php on line 8

Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\htdocs\admin\login.php:8) in C:\Program Files\Abyss Web Server\htdocs\admin\login.php on line 16

Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\htdocs\admin\login.php:8) in C:\Program Files\Abyss Web Server\htdocs\admin\login.php on line 17

Anyway thanks for sharing..

[bk2483]

oh find this line in query.php and change WebLoginState to UserAvailable like the on below
DEFINE("ACCOUNT_ONLINE", "UPDATE UserInfo SET UserAvailable = 0 WHERE UserName = '%s'");

DEFINE("ACCOUNT_OFFLINE", "UPDATE UserInfo SET UserAvailable = 1 WHERE UserName = '%s'");

[shinchan]

How about add | delete an item in the inventory. Is it possible.

[danish]

ok....i have suggestion...

1. can you make the list of personel item?? what i mean is, when you search their name...the list will come out including the locker item...

2. Duration Of BAN time

can you make it? it's just suggestion....cheers

* Good Job....Thanks...it's really help.... ;)

[michael2k10]

yah about it!! this CP can do it??

[truclan]

thnx man this is very useful more power man
thnx for sharing again... your reborn cp is very helpful im sure
this was really help alot ^_^

salamt po

[whatever123]

Thank you for the share. i just want to report that some functions sir doesn't work. Ban User and Unban User Works fine and also UserInfo is ok, Change Character Name, Create GM account, and Character Info functions doesn't work for me. thank you again!!

[shinchan]

whatever123 - you should post a screenshot maybe or the error codes.

[sphynxs2k4]

sir i have a problem its just that when clicking the userinfo and charinfo
theres a message that says

Fatal error: Maximum execution time of 30 seconds exceeded in C:\Program Files\Abyss Web Server\htdocs\admin\page\userinfo.php on line 278

coz i have many accounts in my server what seems to be the problem here

need you assistance for this ty

and in the fisrt page after u login
in my server there is user online but there no displayed chra that are online

ty in advance hope someone will help me

[ushpen]

@bk2483

Ok i got it dude. thanks

[tondofear]

80% perfectly working. Keep it up! and Tnx for sharing!

Ooops sorry fo my fast reaction i think it has a problem when loging out i cant log in to the game easily, i have to login in my rancp & logout again to be login in the the Game.

And change charname have an error like this:
Warning: extract(): First argument should be an array in C:\Program Files\Abyss Web Server\htdocs\admin\page\namechanger.php on line 79

[whatever123]

no errors appear. it just say "no user exist" but the truth is it have.does anyone encounter the same problem as mine.?

[GMvincent]

i got this error when i login my gm account..
there is some script error but i cant PRINT SCREEN coz` the preview is too fast and this error prompt..

http://forum.ragezone.com/attachment...1&d=1209377932

EDIT:

I GOT THE ERROR same as USHPEN.

[tictace]

[HELP]


Warning: mssql_query(): message: Invalid column name 'WebLoginState'. (severity 16) in C:\Program Files\Abyss Web Server\htdocs\admin\logout.php on line 4

Warning: mssql_query(): Query failed in C:\Program Files\Abyss Web Server\htdocs\admin\logout.php on line 4

Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\htdocs\admin\logout.php:4) in C:\Program Files\Abyss Web Server\htdocs\admin\function.php on line 173

Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\htdocs\admin\logout.php:4) in C:\Program Files\Abyss Web Server\htdocs\admin\function.php on line 174

[elomeco]

no errors appear. it just say "no user exist" but the truth is it have.does anyone encounter the same problem as mine.?

yup..i got that plem too..hmm but everything workind fine..i wonder..wats wrong..

[jopax]

Thanks for the script! it's working perfectly. I just want to ask if possible, can you also add a function of logging out of an account? for some reason, sometimes the account is not being properly logged out. thanks

[monkeyking]

I got this error when logging in my Gm account with usertype=30. Jst like popup comes out and it says "Kamu tidak dibenarkan login" and i think in english "Session Ends Please Re-Login". Although i tried to log in again and again but this keep poping out.. Please help.

[the_eliter]

alert("Kamu tidak dibenarkan login.");
</script>
';
quickrefresh('index.php');

what is that mean? invalid?
cant login always go back index


10q u for sharing sir :D

[chaia8]

Fatal error: Call to undefined function: mssql_connect() in C:\AppServ\www\admin\function.php on line 37