Someone help me? ("Roles imported failed" in pwAdmin)

[kombinho]

Look guys I have a server then he always gave "Roles imported failed" in pwAdmin, said that there were special characters pwAdmin not accept that then I changed the filters for ASCII there I wipe delete all accounts after that it took over a normal i spent a few days time and again gave trouble now do not know what that is already blocked filters in the characters ...
Someone help me please!?

[MentaL]

[Romulan]

That feature never worked for me, I simply disabled it. -.-

[kombinho]

Actually I saw and it just loads and does not update the SQLSYNC takes a long blank page appears there would be that WHAT?

[tbnanubis]

when its done you see a whole listof all characters on your server. You can then click on them to do stuff with them.
For the sql transfer to be successfull, you need to add some htmlescape/javaescape/sqlexcape stuff to the role.jsp.

~line 450:
rolename = StringEscapeUtils.escapeSql(StringEscapeUtils.escapeJava(StringEscapeUtils.escapeHtml(chr.base.name.getString())));
~line 820:
name = StringEscapeUtils.escapeHtml(character.base.name.getString());
~line 870:
spouse = StringEscapeUtils.escapeHtml(GameDB.get(character.base.reserved1).base.name.getString());
~line 1158:
String rolename = StringEscapeUtils.escapeHtml(ios.m_octets.getString());
~line 1374:
String rolename = StringEscapeUtils.unescapeJava(rs.getString("role_name"));

these are only approximate line numbers, as i changed some other stuff in our role.xml to get rid of that login check junk

[Romulan]

when its done you see a whole listof all characters on your server. You can then click on them to do stuff with them.
For the sql transfer to be successfull, you need to add some htmlescape/javaescape/sqlexcape stuff to the role.jsp.

~line 450:
rolename = StringEscapeUtils.escapeSql(StringEscapeUtils.escapeJava(StringEscapeUtils.escapeHtml(chr.base.name.getString())));
~line 820:
name = StringEscapeUtils.escapeHtml(character.base.name.getString());
~line 870:
spouse = StringEscapeUtils.escapeHtml(GameDB.get(character.base.reserved1).base.name.getString());
~line 1158:
String rolename = StringEscapeUtils.escapeHtml(ios.m_octets.getString());
~line 1374:
String rolename = StringEscapeUtils.unescapeJava(rs.getString("role_name"));

these are only approximate line numbers, as i changed some other stuff in our role.xml to get rid of that login check junk

Hmm looks interesting... I might take a look at it later.

[tbnanubis]

basically it does convert all special chars to html, like &, &u20; etc.. after that it escapes all " and ' and & so that the result is a valid string for mysql.

for a display on the list it just works the other way round, except the html thing, because you want it displayed in proper html

[avalanche3]

when its done you see a whole listof all characters on your server. You can then click on them to do stuff with them.
For the sql transfer to be successfull, you need to add some htmlescape/javaescape/sqlexcape stuff to the role.jsp.

~line 450:
rolename = StringEscapeUtils.escapeSql(StringEscapeUtils.escapeJava(StringEscapeUtils.escapeHtml(chr.base.name.getString())));
~line 820:
name = StringEscapeUtils.escapeHtml(character.base.name.getString());
~line 870:
spouse = StringEscapeUtils.escapeHtml(GameDB.get(character.base.reserved1).base.name.getString());
~line 1158:
String rolename = StringEscapeUtils.escapeHtml(ios.m_octets.getString());
~line 1374:
String rolename = StringEscapeUtils.unescapeJava(rs.getString("role_name"));

these are only approximate line numbers, as i changed some other stuff in our role.xml to get rid of that login check junk

works now, thanks

[kombinho]

thank you I'm increasingly impressed with the international Ragezone ...