Creating a Control Panel

[Vinyasa]

Me again. I need assistance in creating a control panel for my private server. I searched the web and found nothing useful. So if anyone could point me in the right direction it would be greatly appreciated.

I didn't want to make multiple threads, so I'm going to post my second problem I'm facing with my server as well.

When I @item certain items, they show up invisible, and when I double click it, I get disconnected.

Any suggestions?

Edited January 21, 2013 by Vinyasa

[Fai T.Flowright]

probably problem with your viewID, pls check it sir

[Vinyasa]

Care to elaborate?

[Feefty]

Beret is already in kRO. what kind of client are you using anyway?

[RyokoMVP]

maybe missing sprite

[Vinyasa]

2012-04-10a is the client I'm using.

[Mumbles]

Flux CP is a commonly used control panel, and it's free! Downloads are available from their Google Code project page.

http://code.google.com/p/fluxcp/downloads/list

As for your Beret, make sure the ViewID is set in the item_db and also defined in your client-side files (data/itemresnametable.txt).

[Vinyasa]

Okay thanks, I'll look around on how to set up a flux cp.

[Erba]

missing texture/...../item

check item_db also if the item exists

[Mumbles]

Here's a link to JayPee's post about Flux CP installation:

http://rathena.org/board/topic/57114-how-to-install-flux-cp/#entry69098

There's also some video tutorials on the project page:

http://code.google.com/p/fluxcp/wiki/Screencasts

[Vinyasa]

I got the Flux CP to install.. But, when I try to register I get an error saying "Uh oh, what happened?". Not sure what that's about..

[Mumbles]

Make sure you've configured your server IP in config/servers.php and that your server is accepting incoming connections on ports 6900, 6121, and 5121.

[Vinyasa]

Yup, all IP address related info in servers.php is 127.0.0.1. And yeah, I forwarded those ports if that's what you mean. A friend of mine is able to get on my server on a separate internet connection.

Okay, I noticed something.

When I change this:

CharMapServers' => array(
		array(
			'ServerName'	=> 'fluxRO',
			'BaseExpRates'  => 200,
			'JobExpRates'   => 200,
			'MvpExpRates'   => 200,
			'DropRates'	 => 25,
			'MvpDropRates'  => 25,
			'CardDropRates' => 25,
			'MaxCharSlots'  => 9,

to this:

CharMapServers' => array(
		array(
			'ServerName'	=> 'VinyasaRO',
			'BaseExpRates'  => 200,
			'JobExpRates'   => 200,
			'MvpExpRates'   => 200,
			'DropRates'	 => 25,
			'MvpDropRates'  => 25,
			'CardDropRates' => 25,
			'MaxCharSlots'  => 9,

This error comes up when I try to update the control panel.

[b]	Critical Error[/b]

An error was encountered during the lifetime of the application.
This could be due to a variety of problems, such as a bug in the application.
[b]However, normally it is caused by [i]misconfiguration[/i].[/b]
[b]	Exception Details[/b]

Error: [b]PDOException[/b]
Message: [i]SQLSTATE[HY000] [1045] Access denied for user 'Andre'@'localhost' (using password: YES)[/i]
File: C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Connection.php:81										File							Line							Function/Method											C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Connection.php							81							PDO::__construct()											C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Connection.php							94							Flux_Connection::connect()											C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Connection.php							159							Flux_Connection::getConnection()											C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Installer\Schema.php							103							Flux_Connection::getStatement()											C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Installer\Schema.php							157							Flux_Installer_Schema::install()											C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Installer\MainServer.php							52							Flux_Installer_Schema::update()											C:\Program Files\xampp\htdocs\fluxcp\modules\install\index.php							83							Flux_Installer_MainServer::updateAll()											C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Template.php							337							include()											C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Dispatcher.php							168							Flux_Template::render()											C:\Program Files\xampp\htdocs\fluxcp\index.php							170							Flux_Dispatcher::dispatch()			
[b]	Exception Trace As String[/b]

#0 C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Connection.php(81): PDO->__construct(*hidden*)
#1 C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Connection.php(94): Flux_Connection->connect(Object(Flux_Config))
#2 C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Connection.php(159): Flux_Connection->getConnection()
#3 C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Installer\Schema.php(103): Flux_Connection->getStatement('CREATE TABLE `c...')
#4 C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Installer\Schema.php(157): Flux_Installer_Schema->install(522)
#5 C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Installer\MainServer.php(52): Flux_Installer_Schema->update()
#6 C:\Program Files\xampp\htdocs\fluxcp\modules\install\index.php(83): Flux_Installer_MainServer->updateAll()
#7 C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Template.php(337): include('C:\Program File...')
#8 C:\Program Files\xampp\htdocs\fluxcp\lib\Flux\Dispatcher.php(168): Flux_Template->render()
#9 C:\Program Files\xampp\htdocs\fluxcp\index.php(170): Flux_Dispatcher->dispatch(Array)
#10 {main}

P.S: I'm able to login to localhost/phpmyadmin

Edited January 21, 2013 by Vinyasa

[Mumbles]

What your control panel is telling you is that you don't have permission to access the database; this is defined in your servers.php file; change the database username, password, and schema to match your information.

[Vinyasa]

Whoops, I didn't realize that when I was trying to update the control panel haha. Still can't figure out why I get this "uh oh what happened?" error.

Thanks for the replies by the way.