pwAdmin 151

elche27 · Mar 23, 2014

sora1984 said:
based off DaMadBoy fixed 148 and Bola iweb 151

this pwAdmin works with xml, import charater to db ect ect

edit the configs in
/pwAdmin/WEB-INF/.pwadminconf.jsp

You must be registered to see links

Mr sora, in this pwAdmin ¿work the function "import role to mysql db"? on character tab
I tested it slightly and get "Roles Imported to MySQL Table" but no players on my role table

sora1984 - pwAdmin 151 - RaGEZONE Forums

Iam asking because maybe im doing something wrong or need add some steps on the editing of the web
Thank you for your time!
Regards

NanayaQ · Mar 23, 2014

@elche27 you see that recycle arrow icon near Player, click on that and *BAAM* magic.

elche27 · Mar 23, 2014

NanayaQ said:
elche27 you see that recycle arrow icon near Player, click on that and *BAAM* magic.

Hello mr NanayaQ, yes, the pic is after i clicked on that icon XD
That is why iam asking if is working or im doing something wrong on installation.
Thank you for ur reply.

Edited:
I was doing something wrong...it is working

Anyone know if addon are working? Because for example on getgold ask me a user and pass but when i enter it, nothing happens
Regards!

gebryas · Mar 29, 2014

argonaut said:
You must be registered to see links

i did all i got in search but the rank page didnt work on 1.5.1 , i have to say again in role tabel in db pvp_kills pvp_deads are 0 and dont change with killing or death ? cuz these are 0 the ranking shows for all ppl 0 killing , bt what is sultion for this ?

:lol:

StrangerJr said:
maybe pariah_time?

i noticed for some player pk mode is on and some other is off but all are in pk mode in game , i'm :dontknow::hmmmm2:

NoName123456 · Mar 29, 2014

Everything works clear on this else than the char editor shows blank page. Any soloution?
Pwadmin :-

Conf:-

luckyjackz · Mar 29, 2014

NoName123456 said:
Everything works clear on this else than the char editor shows blank page. Any soloution?
Pwadmin :-

Conf:-

maybe you don't have the role database...

NoName123456 · Mar 30, 2014

I dont but How should I edit it? please tell me n.n

Regano · Mar 30, 2014

Originally Posted by sora1984 .

sora1984 said:

roles table

Code:

-- phpMyAdmin SQL Dump
-- version 4.1.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 14, 2014 at 12:07 AM
-- Server version: 5.5.35-0ubuntu0.12.04.2
-- PHP Version: 5.3.10-1ubuntu3.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET [USER=1333464006]old[/USER]_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `pw`
--

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

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
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;

--
-- Truncate table before insert `roles`
--

TRUNCATE TABLE `roles`;
/*!40101 SET CHARACTER_SET_CLIENT [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION [USER=1333464006]old[/USER]_COLLATION_CONNECTION */;

1.open phpMyadmin
2.select "pw" databasename
3.Click SQL TAB

copy and Paste this

Code:

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;

NoName123456 · Mar 30, 2014

weeeeew thanks alot bro it worked

)

But It keeps loading and dont open anychar

And when I type my char Id it shows a blank page

Regano · Mar 30, 2014

Me, too.

---Console---
gamedbd: debug : GetUserRoles, userid=1024

NoName123456 · Mar 30, 2014

Whats the fix for this? when I edit my acc culti it keeps loading and it doesnt end/edit it.

Anyhelp?

elche27 · Apr 7, 2014

sora1984 said:
based off DaMadBoy fixed 148 and Bola iweb 151

this pwAdmin works with xml, import charater to db ect ect

edit the configs in
/pwAdmin/WEB-INF/.pwadminconf.jsp

You must be registered to see links

Good Night Mr Sora,

Sorry for bother you but i am having some issue with addon's tab. My first problem is i cant log an account. My problem is on login.jsp, more specific on the code of this function:

Code:

String pw_encode(String salt, MessageDigest alg)
	{
		alg.reset(); 
		alg.update(salt.getBytes());
		byte[] digest = alg.digest();
		StringBuffer hashedpasswd = new StringBuffer();
		String hx;
		for(int i=0; i<digest.length; i++)
		{
			hx =  Integer.toHexString(0xFF & digest[i]);
			//0x03 is equal to 0x3, but we need 0x03 for our md5sum
			if(hx.length() == 1)
			{
				hx = "0" + hx;
			} 
			hashedpasswd.append(hx);
		}
		salt = "0x" + hashedpasswd.toString();

        	return salt;
   	}

Could you share your code? Since i am not good on jsp i dont know how to use this

Code:

base64_encode(md5($user.$pass, true));

.

My second problem is:
I managed to make work "GET GOLD ADDON" on a char BUT with a GM account

When i try with a normal account, i cant make it work, dont know why

Even more, i used same method as GM account and work on other addon like GET ITEM like you can see here

Any clue why? Thank you in advance!
Regards

Regano · Apr 8, 2014

Base64fix
http://forum.ragezone.com/f751/pw-server-files-1-5-a-989364/index24.html#post8027143

elche27 · Apr 8, 2014

Regano said:
Base64fix
http://forum.ragezone.com/f751/pw-server-files-1-5-a-989364/index24.html#post8027143

Thank You Mr Regano for your answer but i replaced your index,jsp and get an error

And iif i use the code on login.jsp, i get error too

String pw_encode(String salt, MessageDigest alg)
{
alg.reset();
alg.update(salt.getBytes());
byte[] digest = alg.digest();
return Base64Util.encode(digest);
}

But you gave me some ideas...ill try to resolve it...thank you!

Regano · Apr 8, 2014

Please copy and overwrite all of the target folder.

elche27 · Apr 8, 2014

Regano said:
Please copy and overwrite all of the target folder.

No need Mr Regano XD!
Just need to do this change on login.jsp

Code:

<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page import="java.security.*"%>
[COLOR="#B22222"]<%@page import="org.seasar.framework.util.Base64Util"%>[/COLOR]

<%@include file="../../WEB-INF/.pwadminconf.jsp"%>

<%!
    	String pw_encode(String salt, MessageDigest alg)
	{
		
		[COLOR="#A52A2A"]alg.reset(); 
		alg.update(salt.getBytes());
		byte[] digest = alg.digest();
		String passCod = Base64Util.encode(digest);
		return passCod;[/COLOR]
   	}
%>

And put your Base64Util.class on /WEB-INF/classes/org/seasar/framework/util/Base64Util.class or overwrite the folder class hehe, sry for explain with apple and banana but not all have the skill to know.
That is all! Work to me!

Thank to you Mr Regano, i could fix this problem. Regards!

GamesRealm · Apr 10, 2014

Guys, thanks verry mutch for the tips, but they dont works for me!!!

First, i accesed

You must be registered to see links

and i got this:

Now, after i got the error, i was looking in the thread to find a fix, and i found this:

sora1984 said:

Urrg!! learn!!

cd to /

create a new file call it pwadmin.sh paste this into it:

Code:

#!/bin/bash
#noob installer lol

ip=`/sbin/ifconfig|grep inet|head -1|sed 's/\:/ /'|awk '{print $3}'`

apt-get install -y unzip tomcat7
cd var/lib/tomcat7/webapps/
service tomcat7 stop
wget https://dl.dropboxusercontent.com/u/19918926/pwadmin1.5.1.zip
unzip -o pwadmin1.5.1.zip
service tomcat7 start
echo ""
echo "Open your browser and go to http://"$ip":8080/pwAdmin/"

save it.

Run it:

Code:

chmod 755 pwadmin.sh
./pwadmin.sh

And so i did, i went to /<root> and pasted the file "pwadmin.sh" (i also saved it on root dir, just in case!)

And now, i`m try to run it, first time i used "chmod 755 pwadmin.sh" and second "./pwadmin.sh" but it seem that non of them work! And i`m kinda blocked here, and dont know what do to next\1

sora1984 · Apr 10, 2014

if you made the file on Crapdows then do:
cd /
apt-get install tofrodos
fromdos pwadmin.sh
chmod 755 pwadmin.sh
./pwadmin.sh

Also the ~# means the current users folder! eg. "/root" not root dir "/"

if you ever need to know the exact directory you are in then use pwd
basic unix knowledge is a must!!

GamesRealm · Apr 10, 2014

sora1984 said:
if you made the file on Crapdows then do:
cd /
apt-get install tofrodos
fromdos pwadmin.sh
chmod 755 pwadmin.sh
./pwadmin.sh

Also the ~# means the current users folder! eg. "/root" not root dir "/"

if you ever need to know the exact directory you are in then use pwd
basic unix knowledge is a must!!

Can you have a look please, i always have problems when i use command "apt-get install or update"

luckyjackz · Apr 11, 2014

elche27 said:
No need Mr Regano XD!
Just need to do this change on login.jsp

Code:

<%@page import="java.sql.*"%> <%@page import="java.util.*"%> <%@page import="java.security.*"%> [COLOR="#B22222"]<%@page import="org.seasar.framework.util.Base64Util"%>[/COLOR] <%@include file="../../WEB-INF/.pwadminconf.jsp"%> <%! String pw_encode(String salt, MessageDigest alg) { [COLOR="#A52A2A"]alg.reset(); alg.update(salt.getBytes()); byte[] digest = alg.digest(); String passCod = Base64Util.encode(digest); return passCod;[/COLOR] } %>

And put your Base64Util.class on /WEB-INF/classes/org/seasar/framework/util/Base64Util.class or overwrite the folder class hehe, sry for explain with apple and banana but not all have the skill to know.
That is all! Work to me!

Thank to you Mr Regano, i could fix this problem. Regards!

i use your tips for get item and get gold. After i change that login.jsp and copy base64, when i try to login to pwAdmin, it can't login...

Welcome!

pwAdmin 151

Junior Spellweaver

QuoteShiek Member

Junior Spellweaver

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

Experienced Elementalist

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Skilled Illusionist

Newbie Spellweaver

Newbie Spellweaver

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor