(Release) pwAdmin 1.4.5 (Character Page, Edit XML & Live Chat)

[DaMadBoy]

I use exactly the same setup on both my physical machine and my test server. Both use apache, apache tomcat and ubuntu 11.04. So I think it might be something to do with use a virtual machine but I can't be 100% sure.

 

[DaMadBoy]

I have updated my original post, it now has the link to download the PHP files for the addons. I updated the pwAdmin download to, to include my addon that lists cubi processes (called Vote Abuse). I use it to catch out those abusing the vote system by changing their IP address. It lists all cubi processes made within a 24 hour period. You can change this if you want to 2 or 3 days, or even a week.

 

[argonaut]

Thank you for all your hard work DaMadBoy , big ups to you.
I was experimenting with apache tomcat, a jetty release that came in Bola release and jetty 7.4.2 from the svn pwAdmin.
Indeed it shows in tomcat for the server control to be not working, but in jetty 7.4.2 this does work.
There are some other variances of functionality from using different jetty versions, like the jetty released in Bola release has no functionality for characters yet 7.4.2 jetty works good for characters.
Just thought i'd mention that as i found it curious.
Thanks for the awesome share.

 

[DaMadBoy]

You're welcome, I will keep it updated when I do other things as well. Currently I am trying to get the double exp to work on the server configuration page but I'm not having much success at the moment but I am a complete noob with java so I'll get it fixed eventually.

 

[faqiir]

Excusme, so we have 2 type account id?, how to set new type acc id?

Thank b4

2

 

[DaMadBoy]

Just run the 1.4.5 server with a blank database, the new accounts made will start with 1024 onwards. I wouldn't do that on a live server though

 

[faqiir]

Just run the 1.4.5 server with a blank database, the new accounts made will start with 1024 onwards. I wouldn't do that on a live server though

With my test , many time truncate table but never get acc start with 1024

2

 

[fgru]

AW: (Release) pwAdmin 1.4.5 (Character Page, Edit XML & Live Chat)

i think many ppl have old structure sql database

... posted by devils phone ...

 

[matheusbento]

hey dude, the player rank work?

 

[DaMadBoy]

If you mean the addon then I'm not 100% sure. I'm gonna go test it myself right now and fix it if it doesn't. Going to do some other small changes as well today. I'll try and get it uploaded later today.

Edit: I just tested the ranking update addon and it works fine as long as you have the new database structure. But it wont work if you have the old structure with new character IDs.

So in short for it to work accounts must start at 1024 and the same with game characters.

 

[Selenica]

Excellent share.

 

[likertuban]

help, when i click character the role not appear :/:
but the other are work fine, btw, i can't create a new account, it says Connection to MySQL Database Failed,

 

[DaMadBoy]

Have you configured the database settings? The PW Server files path?

 

[fgru]

AW: (Release) pwAdmin 1.4.5 (Character Page, Edit XML & Live Chat)

first u need role table in database ... second sounds like wrong database structure ...

... posted by devils phone ...

 

[likertuban]

Re: AW: (Release) pwAdmin 1.4.5 (Character Page, Edit XML & Live Chat)

Have you configured the database settings? The PW Server files path?

first u need role table in database ... second sounds like wrong database structure ...

... posted by devils phone ...

pw path is /PWServer/ from your file, so i don't need to change it, since start server and stop server are work fine...

 

[Psytrac]

Re: AW: (Release) pwAdmin 1.4.5 (Character Page, Edit XML & Live Chat)

pw path is /PWServer/ from your file, so i don't need to change it, since start server and stop server are work fine...

did you fix the .pwdatabase.conf (or was that .pwadmin.conf) file?

 

[likertuban]

Re: AW: (Release) pwAdmin 1.4.5 (Character Page, Edit XML & Live Chat)

did you fix the .pwdatabase.conf (or was that .pwadmin.conf) file?

what do i need to fix sir?
i only change database from "dbo" to "pw"
since username and password i used "root" i don't need to changed it
it's all ok,
everything work fine, when i start server from server control, it works fine,
and when i click on account, there's a list of my account, so it should be fine,
but when i click on character (just click it, not yet enter any account, and the role page doesn't appear), it just blank, and when i try to register, it says failed to connect mysql database

 

[fgru]

AW: (Release) pwAdmin 1.4.5 (Character Page, Edit XML & Live Chat)

blank page says no roles table in ur database ...

CREATE TABLE IF NOT EXISTS `roles` (
`account_id` int(11) NOT NULL,
`role_id` int(11) NOT NULL,
`role_name` varchar(64) NOT NULL,
`role_level` smallint(6) NOT NULL,
`role_race` tinyint(4) NOT NULL,
`role_occupation` tinyint(4) NOT NULL,
`role_gender` tinyint(4) NOT NULL,
`role_spouse` int(11) NOT NULL,
`faction_id` int(11) NOT NULL,
`faction_name` varchar(64) NOT NULL,
`faction_level` int(11) NOT NULL,
`faction_domains` varchar(132) NOT NULL,
`role_faction_rank` int(11) NOT NULL,
`pvp_time` int(11) NOT NULL,
`pvp_kills` int(11) NOT NULL,
`pvp_deads` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

... posted by devils phone ...

 

[likertuban]

Re: AW: (Release) pwAdmin 1.4.5 (Character Page, Edit XML & Live Chat)

blank page says no roles table in ur database ...



... posted by devils phone ...

it does really work,
but there's a new problem,
the character page just keep loading,

here's the picture success on loading role (server turn off)

here's the picture entering ID (server turn off)

then i search and found out that i need to start server first
but,
when i trun on my server

and entering ID

the page just keep loading, and not showing the character page...
:
is this related with old structure? (my account start with ID 32)
hope someone can help :

 

[gogen]

the same problem, is there a solution?