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

As some of you may remember I said that I would try and give fixing pwAdmin a while ago to work with 1.4.5 and would share it if I ever did. Unfortunately I haven't given much time to it as I have had other things to take care of that were more of a priority. I started working on attempting to fix it about a week ago. For this to work you will need to update your pwAdmin protocols with the ones from Iweb.

Anyway I managed to get the character page working and the edit XML page. I also managed to fix the Live Chat as well. You can now send broadcasts on 1.4.5 and view all chats including Horns. I'm providing the whole panel as requested but be warned, much of it needs work. So don't expect too much yet.

Here is the download link:
pwAdmin.zip
admin.zip (PHP files for addons)

New structure Database: Attachment 133922

Fixed:

Character Page
XML Page
Live Chat
Server Configuration
Server Control

Fixed by others:

Send Mail 2 Plugin - Fixed By Romulan
GM Control - Fixed By rbb138

Known bugs:

Live Chat - Horn in live chat displays a colour code after all messages.

I will keep this page updated with more fixes in future.
Roles Screenshot 1
Roles Screenshot 2
Roles Screenshot 3
Roles XML Screenshot
Live Chat Screenshot
Ingame Screenshot
Server Page Screenshot 1

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

As some people still use older versions of the game I decided to split up my post so people would know what has been fixed in each version. This part is for pwAdmin made to work with 1.4.8.

Here is the download link:
pwAdmin_148.zip

Fixed:

Character Page
Character XML Page
Spouse Manager (For same gender marriages/Fixing marriages)
Icons have been updated

thanks for the share

Quote:

---

Originally Posted by DaMadBoy

As some of you may remember I said that I would try and give fixing pwAdmin a while ago to work with 1.4.5 and would share it if I ever did. Unfortunately I haven't given much time to it as I have had other things to take care of that were more of a priority. I started working on attempting to fix it about a week ago. For this to work you will need to update your pwAdmin protocols with the ones from Iweb.

Anyway I managed to get the character page working and the edit XML page. I also managed to fix the Live Chat as well. You can now send broadcasts on 1.4.5 and view all chats including Horns.

Here Are the download links:
roles.zip
livechat.zip

Known bugs:

Character Page - The drop down that displays characters linked to an account does not function when using a server with the old ID structure. For example an account ID of 32 will not display in the drop down with characters starting with an ID of 1024+. However IDs with the new account structure will work just fine. Example Account ID = 1024, char ID 1024, 1025, 1026, 1027 and so on.

Live Chat - Horn in live chat displays a colour code after all messages.

I will keep this page updated with more fixes in future and once I get everything fixed I will upload the whole pwAdmin.

http://www.triallion.eu/downloads/pw...een/roles1.png
http://www.triallion.eu/downloads/pw...een/roles2.png
http://www.triallion.eu/downloads/pw...een/roles3.png
http://www.triallion.eu/downloads/pw...n/rolesxml.png
http://www.triallion.eu/downloads/pw...n/livechat.png
http://www.triallion.eu/downloads/pw...ingamechat.png

---

Can post the full pwAdmin? I added these files and does not work. May be problem on apache-tomcat 5.5.28-?

can pwadmin be set on tomcat beside iweb?

(currently having that issue, if that IS the issue that's what's causing me to be unable to use pwAdmin, and would love to use this)

I can post the full one but most of it is a work in progress. Give me some time and I will post it. I am using apache tomcat so yes you can use it along side iweb.

Edit: I updated the first post. You may want to change your IP address, port number and database settings in some of the files before it will work. I changed all IPs to 127.0.0.1 and all passwords are root too.

Updated post still points to roles.zip, just to let ya know. tested and works so +1 here. Just thought you should know so you can update link it points to

Whoops, sorry about that. Far too many reefas tonight me think O.o

imports about 10chars by me then says cant import roles to mysql ? what i make false ? timout of jakarta?

FIXED had a char account in to edit templates -.- and pwAdmin acnt import roleid 16 ^^

Thanks, may gbu

Sent from my ST21i using Tapatalk 2

I got this error when trying to use "refresh top player list" and don't know how to fix it.

Quote:

---

HTTP ERROR 500

Problem accessing /pwAdminBaruDariGama/addons/Top%20Players%20-%20Manual%20Refresh/. Reason:

Access denied for user 'root'@'localhost' (using password: YES)Caused by:


java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1072) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4001) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2183) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:784) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:354) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284) at java.sql.DriverManager.getConnection(DriverManager.java:620) at java.sql.DriverManager.getConnection(DriverManager.java:200) at org.apache.jsp.addons.Top_0020Players_0020_002d_0020Manual_0020Refresh.index_jsp._jspService(org.apache.jsp.addons.Top_0020Players_0020_002d_0020Manual_0020Refresh.index_jsp:87) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:478) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:517) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:284) at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:115) at org.eclipse.jetty.servlet.DefaultServlet.doGet(DefaultServlet.java:552) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:478) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:480) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110) at org.eclipse.jetty.server.Server.handle(Server.java:346) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:589) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:1048) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:601) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:411) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:535) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:529) at java.lang.Thread.run(Thread.java:679)

---

Powered by Jetty://

---

And I have another problem changing password or creating new account from iweb, it said "connection to MySQL database failed.
I have changed all ip addresses in .pwconf.jsp to my server ip address and also set the MySQL configuration in .pwadminconf.jsp but still doesn't work.
Can anyone help me?

:/:

Good job, DaMadBoy .

I had already developed one a while ago and i use today, only not used the style pwAdmin. Your sharing was great.

+1 like.

Thank you, I plan on doing more with pwAdmin once I figure out how to fix other aspects of it. I only started learning how it all work s properly about 2 weeks ago so bare with me.

Quote:

---

Originally Posted by sampurasun

I got this error when trying to use "refresh top player list" and don't know how to fix it.


And I have another problem changing password or creating new account from iweb, it said "connection to MySQL database failed.
I have changed all ip addresses in .pwconf.jsp to my server ip address and also set the MySQL configuration in .pwadminconf.jsp but still doesn't work.
Can anyone help me?

:/:

---

Are the database settings correct? Including the name of the database. The database name I used here was "dbo". Passwords must match your password for it as well, including case sensitivity.

you could share. plugins php of if there is no problem ..

Quote:

---

Originally Posted by DaMadBoy

Thank you, I plan on doing more with pwAdmin once I figure out how to fix other aspects of it. I only started learning how it all work s properly about 2 weeks ago so bare with me.



Are the database settings correct? Including the name of the database. The database name I used here was "dbo". Passwords must match your password for it as well, including case sensitivity.

---

Thanks for your concern.
I thing settings are correct, including the name of the database, i named it "pw" and so the password
I ever used iweb and it works fine with same setting.
maybe I have MySQL setting wrong or anything, dunno I am noob at this matter.
By the way, your edited pwAdmin is so amazing.
I can find anything I need for managing the game.
Its just I can't make it fully works.

once more, thanks for your help :thumbup:

Quote:

---

Originally Posted by PwMoon

you could share. plugins php of if there is no problem ..

---

Do not be lazy.

PHP is an easy language, however, requires knowledge of its logic. When you learn this, you can create anything you want. Requires time, attention and logic, of course.

Do not be depending on people to get things done.

-

@ topic

Currently fix the plugins required php in apache in local connection. Now is working perfectly.

Dmd, its release was not working for me because the tab is still infuncional characters. I continued using my, I used base W2i.

Java does not it's hard. :8:

Thank You.

By the way this module do I have tested with any 145-v69?
bola Released 145-v69 don't get database.

My Oficial Release v69 (bola v69)
http://forum.ragezone.com/f751/ofici...se-v69-900276/

[Release] Files Reflections (v145-v69)
http://forum.ragezone.com/f751/relea...45-v69-899527/

argonaut (v145-v69)
https://mega.co.nz/#!V5xTBDpL!Ootd5i...cqX6KpXkcG1EeE

I do not know what to do use the setup guide. :(
Setup Guide 1.4.5 v69 present is incomplete all.

Can u release admin folder to run addons in this release:thumbup:

Quote:

---

Originally Posted by Regano

Thank You.

By the way this module do I have tested with any 145-v69?
bola Released 145-v69 don't get database.

My Oficial Release v69 (bola v69)
http://forum.ragezone.com/f751/ofici...se-v69-900276/

[Release] Files Reflections (v145-v69)
http://forum.ragezone.com/f751/relea...45-v69-899527/

argonaut (v145-v69)
https://mega.co.nz/#!V5xTBDpL!Ootd5i...cqX6KpXkcG1EeE

I do not know what to do use the setup guide. :(
Setup Guide 1.4.5 v69 present is incomplete all.

---

This is not my release, i re-upped it to Mega a while ago as Bola links were down for a while..they are exactly the same.
Bola guide and release is perfect, no problems on my test server, all running fine.

I can upload all the php files for the addons but wont be able too until tomorrow evening as I am not at home tomorrow. Not everything will work on the pwAdmin, the only things I have fixed so far are those that I mentioned in my initial post. I've been tackling the more challenging things to fix before I do the easy things such as the server control page.

@Regano I am currently using 1.4.5 on my test server to do the fixes with this panel. The version I am using is the one released by bola. The database I used came with 343s complete package.

Not sure why some people have trouble with the character page, it works perfectly on my system although I have noticed when I use it on my virtual server it takes a while to load or doesn't load at all. Most of the testing I do is on my physical test server though.

test on vm page load very slow ... test on physical server works great ... i think problems comes from different java versions or tomcat / etc

Gesendet von meinem GT-S5360 mit Tapatalk 2

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.

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.

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. :thumbup:

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.

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

Thank b4

Sent from my ST21i using Tapatalk 2

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 :P

Quote:

---

Originally Posted by 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 :P

---

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

Sent from my ST21i using Tapatalk 2

i think many ppl have old structure sql database

... posted by devils phone ...

hey dude, the player rank work?

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.

Excellent share.

Attachment 132617
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,

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 ...

Quote:

---

Originally Posted by DaMadBoy

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

---

Quote:

---

Originally Posted by fgru

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...

Quote:

---

Originally Posted by likertuban

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?

Quote:

---

Originally Posted by Psytrac

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

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

Quote:

---

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 ...

Quote:

---

Originally Posted by fgru

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)
Attachment 133052
here's the picture entering ID (server turn off)
Attachment 133053
then i search and found out that i need to start server first
but,
when i trun on my server
Attachment 133054
and entering ID
Attachment 133055
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 :(:

the same problem, is there a solution?

Quote:

---

Originally Posted by likertuban

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)
Attachment 133052
here's the picture entering ID (server turn off)
Attachment 133053
then i search and found out that i need to start server first
but,
when i trun on my server
Attachment 133054
and entering ID
Attachment 133055
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 :(:

---

Yes your problem is related to the old account structure, characters on the server start with 1024 not 32. Also you need to make sure you have all the updated protocols too as it looks like your are mixing two different pwAdmins there O.o

Also your server needs to be turned on in order to import data from the database, bit hard to import from a database that is turned off :P

ummm, so i need to create new database using new structure? should i delete old database?
it would better if you include the databse to first page (just suggestion).hahahaha
umm, actually the first one is iweb, the second is pwadmin, not mixing it, it works together.hehehehe

Pretty sure it is on the forum somewhere already in one of the 1.4.4+ releases. I will upload the database a bit later though just for ease.

forget this.......

I updated my original post with the newer database. Sorry I took so long, I completely forgot about it.

DaMadBoy :I'm with this error on server 146

http://img706.imageshack.us/img706/7302/c9w.png

Quote:

---

Originally Posted by matheusbento

DaMadBoy :I'm with this error on server 146

---

back to 1.36 area , after go away to 1.44+

i don't found about this in 136 area

Quote:

---

Originally Posted by fgru

http://forum.ragezone.com/f751/relea...-4-5-a-934164/ > charackter edit work perfect ...

---

I have try this release, it don't work in the V80 server. When i select the Character List, there is no users show in the list.
It may caused by I don't know how to use this fix release, is there any Tutorial about the fixed release?

The following are my steps,
1. downloading the pwtools-bin from https://code.google.com/p/pw-tools
2. Find out the directory "sPWadmin" and unpack file of the jetty-7.4.2.tar.bz2, upload to my server.
3. put jetty into the etc/init.d, and using the "service jetty start"
4. download the pwAdmin.zip from the http://forum.ragezone.com/f751/relea...-4-5-a-934164/ and unpack it into the mirror path (webapps)
5. Open browser and enter the URL, http://192.168.200.100:8080/pwAdmin
6. Setup the \pwAdmin\WEB-INF\.pwadminconf.jsp with my server path and MySQL account/password/db_name
7. I can create/modify/list the account information, but I cannot use the Character list, when i switch to the Character list page, it don't show any list.

(I have create some Characters in the games).


Is there anything or tutorial I have to notice?


This fix is complicated, I have no idea about this, can you make any tutorial?

Please Help me to Fix this

http://s23.postimg.org/ojusy2naz/erro.png

Read last line...

already fixed thanks

Hey was curious trying to run this on 1.4.6 v80 I made a blank db called pw and imported this one to it will that cause errors or should I wipe accounts and use this "dbo" for the database names I am having the char page not load right now but everything else works. Also there a iweb for vs 80 yet or is 343 1.4.5 the latest as well.

find the right release there is one. I have one..

Ok ill keep searching

Sorry I haven't been replying much here, been a bit busy. Download links may be down for a short time but should be ok again in a couple of hours.

@Rabid The database I put in my original post should work just fine.

I had check my sql database, it has the "roles" table. However it is empty even I sync the role from the pwAdmin.
It is not surprised to me because when I click the sync button in the pwAdmin, it shows an error message.

Is it possible caused by the librarys ?

I can use the "pwAdmin" (https://code.google.com/p/pw-tools/) with "Mail Send" feature, but the DaMadBoy fixed pwAdmin 1.4.5 not working anymore. (It will show the "send mail fail")

I think the java sever-let don't work well with the V80.

this works fine.. just do some real research on how to make it work

Quote:

---

Originally Posted by Psytrac

this works fine.. just do some real research on how to make it work

---

I had research for one week about the character page issue, read almost post in the forum and search all related information on the Google, the server status and account features are working well , however the character page is not working, i had add some log into the jsp file, it seems the java server-let don't work well.

I have no idea about how to make the character page working in the V80 version.

Please help me, thanks

I had try this version http://forum.ragezone.com/f751/relea...-a-934164-new/ , the version cannot work except the account feature, it cannot send mail to player.

I can use https://code.google.com/p/pw-tools/ to send mail to players, but the http://forum.ragezone.com/f751/release-pwadmin-1-4-5-a-934164-new/ cannot send mail to players.

Is there something wrong about the issue? The send mail action "do not" need SQL to handle, it will invoke the java class to get the gdelivery instance, and call its function to send mail.

I think the java ipc library don't match with the V80, where can I got the V80 library?

This does work with v80...

Dear all, I had fix the issue, it caused by the /etc/iweb.conf; I have add the iweb.conf at the /etc/iweb.conf with correct settings.

However, I have face into another problems, it is "default character settings", i can see my role detail (ID 1024), however, when I click the default character settings, ID=16~31, it will show the Loading Character Data Failed.

Does the feature work in the V80?

No for that you need to create an account with an ID of 16, use phpmyadmin for that. Then log into the account and log into the character templates. Those character templates are now in the database and can be edited. More detailed instructions are on the forum somewhere.

Quote:

---

Originally Posted by DaMadBoy

No for that you need to create an account with an ID of 16, use phpmyadmin for that. Then log into the account and log into the character templates. Those character templates are now in the database and can be edited. More detailed instructions are on the forum somewhere.

---

Thanks for your answer, I had create the account and use PHP tool to edit the ID to 16. It's working now.
:thumbup:

next time search > http://forum.ragezone.com/f754/iweb-...-roles-829701/

Thx for this updated version of pwAdmin. The one I had was partially updated (old code but with newer libs).

Now I have a fully working pwAdmin. Using this code + some tweaks and fixes made by me + the libs for v80. :)

I fixed most of the plugins also.

Quote:

---

Originally Posted by Romulan

Thx for this updated version of pwAdmin. The one I had was partially updated (old code but with newer libs).

---

so you gave me a broken one? lol

Quote:

---

Originally Posted by Psytrac

so you gave me a broken one? lol

---

Not broken, just you don't have the import roles to mysql function and some other things. No biggies.

PS: Oh I still need to fix something in the account page, btw. And I translated the whole thing in french ^^

Glad to see others are making use of the panel. One thing I haven't managed to get working yet was the double exp. I'll get round that that once I have the time though.

Search for setw2iexperience and getw2iexperience and check how it works in iweb then make the things working on pwAdmin panel.

Quote:

---

Originally Posted by 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 :P

---

hmm I used your database dropped and started a new database new accounts are still starting at 32

dunno did it a few times now starting at 1024, 1040, 1050 and so on but now when I try to create a char it dcs. that apermission problem to the database I missed can log in with the templates just fine just cant create a new character on a fresh account.

Edit again here so the pages load in character when server is offline like in that previous post when i turn the server on it will not load unless it takes forever i left it for 10 min and nothing just keeps trying to load with no results. I have my database named "pw" but imported your dbo as the struture so think that should work accounts like I said before are 1024+ accept for the changed templates to 16. Can log into the game threw the templates account but cannot make any chars on new accounts with dcing. The database not being read someplace? Everything worked fine before trying this new database just wish I could get this going not sure whats wrong be nice to have that character page working and these other nice addons as well. Part I love the most is its english lol cant read anything else.

weird rebooted a couple times and removed 343s 1.4.5 iweb and now I can log in. Tryed to add the iweb back but now its 403 forbiddon still trying to find a v80 iweb but cant. Anyway can create characters now so 1 step done going to test character tab out now. Where might I find old player names previously used I see they are still in use somehow even with a brand new database.

Edit: no character page will load this still a databse problem? account is 1040 and char id is 1072

My pwAdmin is not getting connect to mysql
but the settings are all correct, since everything looked to see if there's somewhere to connect to mysql

looks like he's setting

Quote:

---

// pwadmin access password as md5 encrypted string
// default password is root -> 63a9f0ea7bb98050796b649e85481845
String iweb_password = "b9be11166d72e9e3ae7fd407165e4bd2";

// connection settings to the mysql pw database
String db_host = "localhost";
String db_port = "3306";
String db_user = "root";
String db_password = "asqwzxerdfcv";
String db_database = "pw";

// Type of your items database required for mapping id's to names
// Options are my or pwi
String item_labels = "pw";

// Absolute path to your PW-Server main directory (startscript, stopscript, /gamed)
// requires a tailing slash
String pw_server_path = "/home/";

---

someone has the sql, because I tried using the tutorial but the error, then I used to from my server...

Connection to MySQL Database Failed :grr:

Quote:

---

Originally Posted by sh1n0

My pwAdmin is not getting connect to mysql
but the settings are all correct, since everything looked to see if there's somewhere to connect to mysql

looks like he's setting

someone has the sql, because I tried using the tutorial but the error, then I used to from my server...

Connection to MySQL Database Failed :grr:

---

I see u have your name as pw in string db just like me but did u make the database then import from the dbo file on the first post? also /home/ should be /PWServer/ unless u have all that changed as well.

Still not getting the character tab to work hmm my account id is 1040 but character is 1072? this be the problem? I had some other chars that did not delete with I started the new database how do I go about a character clean wipe? Or is this not the problem?

did a fresh install and used these server files instead of the other v80 more things are working but still no character for some reason everything connects to the database accept for the character tab now. I changed .pwadminconf.jsp to my password and /home/ folder and changed name of database to "pw" steps I took was create database "pw" then imported this "dbl.sql" into it for the structure is this wrong? character account id is 1024 and character id is 1024 as well next account made is 1040 so its going in the right format minus the one templates account that is at account id 16.


Edit: Can get into the character window threw id just cant import roles or use the XML.

Edit:: Not sure what I did but now it seems to be working hmm characters imported as they should :) but still no XML.

I think you may have to update some of the lib files as well with ones from the newer versions of the server files. I haven't tested this with v80 so I don't know for sure. When I did the changes I was working with a v69 server. When I get time I will create a v80 test server and start getting it working with that but I don't know when I can do it yet as I have other things to take care of.

I don't run a v80 server so for me it isn't a priority right now. There should be plenty of information around the forums to help you though.

ya I have the new libs someplace cant seem to find them now :(

This does work w/ my v80 I'm pretty sure.

Heads up for some people few tricks well not really lol if using killers release of v80 log all the templates from account id 16 in and out to help with the character mysql problem also when shutting off and turning on with server control the authd wont load u gotta go into the servercontrl.jsp and edit the line to this "fw.write("cd " + pw_server_path + "auth/build/; ./authd.sh >" + pw_server_path + "logs/auth.log &\n");
fw.write("sleep 1\n");" due to the folder is labeled just Auth in this release and gotta add the .sh at ./authd.sh whuch isnt there for this version. Thats just for killers release of v80 remember and the server control now should fully shut down and boot up the server while leaving your java apps running.

A quick guide on how to install this on 1.4.6 v80 release by mr.killer?
http://forum.ragezone.com/f751/relea...-4-6-a-956144/

Quote:

---

Originally Posted by tawdarky

A quick guide on how to install this on 1.4.6 v80 release by mr.killer?
http://forum.ragezone.com/f751/relea...-4-6-a-956144/

---

Wow, as soon as some of the "I want everything handed to me" kiddies leave, new ones arrive. You can set your clocks on this one, folks.

I have installed the pwadmin from here -> pwTools SVN-Downloader.zip - pw-tools - pwTools SVN-Downloader - Collection of Tools for Perfect World MMORPG - Google Project Hosting
I did all the steps mentioned but i get cannot connect in browser.What did i do wrong?I even tried changing the port to 9090 and that doesn't work either.

I don't know anything about how that release is set up as I haven't downloaded it myself. Only thing I can suggest is look where the admin panel (I assume it's iweb) is located and place pwAdmin in the same directory. As for the port number, you'll have to check the port that is used by what ever java server is being used by the release. Also don't forget to check the settings for pwAdmin as well.

Quote:

---

Originally Posted by DaMadBoy

I don't know anything about how that release is set up as I haven't downloaded it myself. Only thing I can suggest is look where the admin panel (I assume it's iweb) is located and place pwAdmin in the same directory. As for the port number, you'll have to check the port that is used by what ever java server is being used by the release.

---

Well i presumed it's the latest that's why i got it.iweb is in tomcat folder.I will try and see what happens.Maybe that release doesn't even work on 1.4.6

Quote:

---

Originally Posted by tawdarky

Well i presumed it's the latest that's why i got it.iweb is in tomcat folder.I will try and see what happens.Maybe that release doesn't even work on 1.4.6

---

No it doesn't work.The thing is even when i try to access iweb i get unable to connect.but the register page works.is it posible that i don't have the correct vbox network settings?

Is tomcat actually running?

Quote:

---

Originally Posted by DaMadBoy

Is tomcat actually running?

---

i don't know how to check that.i am using 1.4.6 v80 release by mrkiller.so i guess it's running.
http://forum.ragezone.com/f751/relea...-4-6-a-956144/
That's the one.All i did is set up an ubuntu server in vbox.and then the tutorial.
What are the corect seetings for vbox for this release.I am using bridged mode with no DHCP server.

SOLVED.

hey bro DaMadBoy When u fix 2x exp?
and i have a problem when i want enter game its says wrong usrname or password .
i put ue dbo.sql im my phpmyadmin and then i make a new user. but still i have that problem

2x works fine. you just failed to configure pwadmin

Quote:

---

Originally Posted by Psytrac

2x works fine. you just failed to configure pwadmin

---

how i must configure it can u tell me?

Code:

---

<%@page import="java.io.*"%>

<%
//-------------------------------------------------------------------------------------------------------------------------
//------------------------------- SETTINGS --------------------------------------------------------------------------------
//-------------------------------------------------------------------------------------------------------------------------

        // pwadmin access password as md5 encrypted string
        // default password is root -> 63a9f0ea7bb98050796b649e85481845
        String iweb_password = "63a9f0ea7bb98050796b649e85481845";

        // connection settings to the mysql pw database
        String db_host = "HOSTNAME";
        String db_port = "PORT";
        String db_user = "USER";
        String db_password = "PASSWORD";
        String db_database = "DATABASE";

        // Type of your items database required for mapping id's to names
        // Options are my or pwi
        String item_labels = "pwi";

        // Absolute path to your PW-Server main directory (startscript, stopscript, /gamed)
        // requires a tailing slash
        String pw_server_path = "/path/to/server/files/";

        // If you have hundreds of characters or heavy web acces through this site
        // It is recommend to turn the realtime character list feature off (false)
        // to prevent server from overload injected by character list generation
        boolean enable_character_list = false;

        String pw_server_name = "Perfect World";
        String pw_server_description = "Level limit, EXP, SP, DROP and COINS infos are based on <b>ptemplate.conf</b><br>Server status is based on <b>glinkd</b> socket<br>Online users are based on <b>gdeliveryd</b> protocol<br><font color=red>CHANGING <b>SERVER CONFIGURATION</b> ON PWADMIN WILL NOT WORK FOR 1.4.x !</font> ";

//-------------------------------------------------------------------------------------------------------------------------
//----------------------------- END SETTINGS ------------------------------------------------------------------------------
//-------------------------------------------------------------------------------------------------------------------------

        String pw_server_level = "?";
        String pw_server_exp = "?";
        String pw_server_sp = "?";
        String pw_server_drop = "?";
        String pw_server_coins = "?";

        BufferedReader bfr = new BufferedReader(new FileReader(pw_server_path + "gamed/ptemplate.conf"));

        String row;
        while((row = bfr.readLine()) != null)
        {
                row = row.replaceAll("\\s", "");
                if(row.indexOf("logic_level_limit=") != -1)
                {
                        int pos = row.length();
                        if(row.indexOf("#") != -1)
                        {
                                pos = row.indexOf("#");
                        }
                        pw_server_level = row.substring(18, pos);
                }
                if(row.indexOf("exp_bonus=") != -1)
                {
                        int pos = row.length();
                        if(row.indexOf("#") != -1)
                        {
                                pos = row.indexOf("#");
                        }
                        pw_server_exp = row.substring(10, pos);
                }
                if(row.indexOf("sp_bonus=") != -1)
                {
                        int pos = row.length();
                        if(row.indexOf("#") != -1)
                        {
                                pos = row.indexOf("#");
                        }
                        pw_server_sp = row.substring(9, pos);
                }
                if(row.indexOf("drop_bonus=") != -1)
                {
                        int pos = row.length();
                        if(row.indexOf("#") != -1)
                        {
                                pos = row.indexOf("#");
                        }
                        pw_server_drop = row.substring(11, pos);
                }
                if(row.indexOf("money_bonus=") != -1)
                {
                        int pos = row.length();
                        if(row.indexOf("#") != -1)
                        {
                                pos = row.indexOf("#");
                        }
                        pw_server_coins = row.substring(12, pos);
                }
        }

        bfr.close();

        if(request.getSession().getAttribute("items") == null)
        {
                String[] items = new String[60001];

                try
                {
                        bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/default.dat")), "UTF8"));
                        if(item_labels.compareTo("my") == 0)
                        {
                                bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/my.dat")), "UTF8"));
                        }
                        if(item_labels.compareTo("pwi") == 0)
                        {
                                bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/pwi.dat")), "UTF8"));
                        }
                        int count = 0;
                        while((row = bfr.readLine()) != null && count < 60001)
                        {
                                items[count] = row;
                                count++;
                        }
                        bfr.close();
                }
                catch(Exception e)
                {
                }

                request.getSession().setAttribute("items", items);
        }
%>

---

.pwadminconfig.jsp


and that's enough spoon-feeding for you..

Quote:

---

Originally Posted by Psytrac

Code:

---

<%@page import="java.io.*"%>

<%
//-------------------------------------------------------------------------------------------------------------------------
//------------------------------- SETTINGS --------------------------------------------------------------------------------
//-------------------------------------------------------------------------------------------------------------------------

    // pwadmin access password as md5 encrypted string
    // default password is root -> 63a9f0ea7bb98050796b649e85481845
    String iweb_password = "63a9f0ea7bb98050796b649e85481845";

    // connection settings to the mysql pw database
    String db_host = "HOSTNAME";
    String db_port = "PORT";
    String db_user = "USER";
    String db_password = "PASSWORD";
    String db_database = "DATABASE";

    // Type of your items database required for mapping id's to names
    // Options are my or pwi
    String item_labels = "pwi";

    // Absolute path to your PW-Server main directory (startscript, stopscript, /gamed)
    // requires a tailing slash
    String pw_server_path = "/path/to/server/files/";

    // If you have hundreds of characters or heavy web acces through this site
    // It is recommend to turn the realtime character list feature off (false)
    // to prevent server from overload injected by character list generation
    boolean enable_character_list = false;

    String pw_server_name = "Perfect World";
    String pw_server_description = "Level limit, EXP, SP, DROP and COINS infos are based on <b>ptemplate.conf</b><br>Server status is based on <b>glinkd</b> socket<br>Online users are based on <b>gdeliveryd</b> protocol<br><font color=red>CHANGING <b>SERVER CONFIGURATION</b> ON PWADMIN WILL NOT WORK FOR 1.4.x !</font> ";

//-------------------------------------------------------------------------------------------------------------------------
//----------------------------- END SETTINGS ------------------------------------------------------------------------------
//-------------------------------------------------------------------------------------------------------------------------

    String pw_server_level = "?";
    String pw_server_exp = "?";
    String pw_server_sp = "?";
    String pw_server_drop = "?";
    String pw_server_coins = "?";

    BufferedReader bfr = new BufferedReader(new FileReader(pw_server_path + "gamed/ptemplate.conf"));

    String row;
    while((row = bfr.readLine()) != null)
    {
        row = row.replaceAll("\\s", "");
        if(row.indexOf("logic_level_limit=") != -1)
        {
            int pos = row.length();
            if(row.indexOf("#") != -1)
            {
                pos = row.indexOf("#");
            }
            pw_server_level = row.substring(18, pos);
        }
        if(row.indexOf("exp_bonus=") != -1)
        {
            int pos = row.length();
            if(row.indexOf("#") != -1)
            {
                pos = row.indexOf("#");
            }
            pw_server_exp = row.substring(10, pos);
        }
        if(row.indexOf("sp_bonus=") != -1)
        {
            int pos = row.length();
            if(row.indexOf("#") != -1)
            {
                pos = row.indexOf("#");
            }
            pw_server_sp = row.substring(9, pos);
        }
        if(row.indexOf("drop_bonus=") != -1)
        {
            int pos = row.length();
            if(row.indexOf("#") != -1)
            {
                pos = row.indexOf("#");
            }
            pw_server_drop = row.substring(11, pos);
        }
        if(row.indexOf("money_bonus=") != -1)
        {
            int pos = row.length();
            if(row.indexOf("#") != -1)
            {
                pos = row.indexOf("#");
            }
            pw_server_coins = row.substring(12, pos);
        }
    }

    bfr.close();

    if(request.getSession().getAttribute("items") == null)
    {
        String[] items = new String[60001];

        try
        {
            bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/default.dat")), "UTF8"));
            if(item_labels.compareTo("my") == 0)
            {
                bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/my.dat")), "UTF8"));
            }
            if(item_labels.compareTo("pwi") == 0)
            {
                bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/pwi.dat")), "UTF8"));
            }
            int count = 0;
            while((row = bfr.readLine()) != null && count < 60001)
            {
                items[count] = row;
                count++;
            }
            bfr.close();
        }
        catch(Exception e)
        {
        }

        request.getSession().setAttribute("items", items);
    }
%>

---

.pwadminconfig.jsp


and that's enough spoon-feeding for you..

---

tnx love.
i do this before .
but still i have problem love. wrong user name and password.
when i use dbo.sql i have wrong user name and password.

Here, let me google that for you :mellow:

how install it into mrkiller PW Server 1.4.7 v 80? http://forum.ragezone.com/f751/pw-se...-4-7-a-943518/

learn to post where you should.

how i can fix this?
Attachment 140628
i use

DaMadBoy pwadmin and dbo.sql .
who know how i can fix it?

Romulan said in an earlier post how it can be fixed. I haven't gotten round to doing it myself yet.

Another question .
when i want change password for a acc its says old passwoed mismatch(u r pwAdmin use binsalt encryption for create acc password)
how i can change it to base64?
cuz my server use base 64 to read user and pass.

Good night,where I putthe Admin folder?

Please can someone help me?
Attachment 140732