:drool::drool::drool: hoaaaaa i can't wait your release
Printable View
:drool::drool::drool: hoaaaaa i can't wait your release
Yes, but i still have two major issues (maybe can someone help me to fix that?):
- I dunno what script i should use for JSP to have the same result like my PHP script... (for the "Who is online")
- ANYBODY CAN ACCESS AT THESE PLUGINS! I dunno how to make it secure with the default pwAdmin login system... (poor knowledges in JSP again...) Maybe can you help me, ronny? ^^
ronny I read the tutorial but as I speak and communicate in Russian is translated into your language to me is very difficult to make a more detailed guide
hi ronny! i posted my first version of my addons pack on the pwadmin project page! :wink:
--> http://pwadmin.codeplex.com/Thread/List.aspx
i'll give a testing :thumbup1:
Yes, thx!
And btw, if anyone can help me to translate my "who is online" PHP script to a JSP page xD this will be very useful!
Because i want to fully integrate my old php gmpanel features into pwAdmin *o*
Who is Online:
Here is an example of an DB query in JSP, hope this help you a bit...
Quote:
<%@page import="java.sql.*"%>
<%@include file=".pwadminconf.jsp"%>
<%
/*
// You don't have to define this if you included
//<%@include file=".pwadminconf.jsp"%>
String db_host = "localhost";
String db_port = "";
String db_database = "dbo3306";
String db_user = "root";
String db_password = "root";
*/
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection("jdbc:mysql://" + db_host + ":" + db_port + "/" + db_database, db_user, db_password);
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery("SELECT ID, name, creatime FROM users");
while(rs.next())
{
out.println("rs.getString("ID") + " | " + rs.getString("name") + " | " + rs.getString("creatime").substring(0, 16));
}
}
catch(Exception e)
{
out.println("<font color=\"#ee0000\"><b>Connection to MySQL Database Failed</b></font>");
}
%>
Role Rename:
After renaming a role, the old name stays in the uniquenamedb and is unavailable for new created characters. I tried some things to free the previous name, but everything failed, this was the reason why i removed this from the pwAdmin core. I like this plugin, but keep in mind that after renaming the old name is unavailable to character creation :thumbup1:
lol i'am try it, but got to much error :tongue:
index.jsp
Spoiler:
result:
Spoiler:
:tongue: actualy i don't know anything about java programing, but just keep trying
has anybody got this working with the IPs for their server as 127.0.0.1 (localhost) in .pwconf.conf.
this is the most secure way to run your server and stop hackers yet i cant seem to get pwadmin working with this. i have the mysql side working and the maps on/off side working!
but im still having the infinate loading bug.
iv tried 2 different 1.5.x.x javas and even the 1.6 java and still having that bug.
note:
if you put your server IP as your local area network (10.x.x.x or 192.x.x.x) then anybody who is inside of the same datacentre as you can connect to your server and edit your character database!
if you put your ip as your internet ip then its even worse, anybody at all can connect to your server and edit your character database!
always use localhost for your gamesys.conf files to ensure only your server can connect to the character database.
however pwadmin doesnt support localhost atm -.-
Hi Ronny1982, i run u pwadmin... but on Fedora12 not work CHAR and SERV CONF, but in Debian 5 all work :).. i have a problemm... no russian.. no nicknames no addon livechat and other... help plz
actualy i run my server only at LAN connected to my dorm DOMAINQuote:
Originally Posted by rbb138
i use IP PORT FORWARDING technique to protect my server, and only open port 29000 and 80, but now i only open port 29000, coz i run mysql server in different PC.
here the logic:
My PWServer IP 192.168.0.10
MySql Server IP 192.168.0.9
Web Server IP for registration 172.16.2.39
My PC as a router and have ip 172.16.3.123 and 192.168.0.1 with 2 LAN CARD
the ip 172.16.XXX.XXX is direct connected to Network.
the ip 192.168.0.10 and 192.168.0.9 is only local, that only my PC can acces it.
then i use IP PORT FORWARDING tool's to forward all incoming connection from 29000:172.16.3.123 to 29000:192.168.0.10
i think it save, coz i tell to my friend to give hacking test, and explain to them about pwAdmin, no one can get change the chracter's. but i dunno if it direct connect to INTERNET:blush:
do you have the latest version of pwAmin 1.0 Plugin support and live chat are available in this version and i think 0.9 and 0.8 Im not to sure about them. Its best to use the lastest version though as it will contain the latest bug fixesQuote:
Originally Posted by loko9988
you can get it from here http://pwadmin.codeplex.com
follow the instructions on the documentation page.
And clear your /webapps/work folder so the new changes take affect.
also make sure you are using java 1.5.XX for pwAdmin.
I use Romulan's java here http://forum.ragezone.com/f452/fixin...ml#post5596839
you will still need to keep 1.6.XX for the other server things.
The continuous loading of the pages is discussed in this thread and solved in this thread for some people make a back up of your server or the files you change if possible and try some of their suggestions.
hope this helps. :):
I download last version of pwadmin and liveChct addon, but no russian, in livechat need conv from utf-16le to utf-8 to see russian lang... but i dont know java :(...
And i change in pwadmin script codepage to utf-8.. but i dont see russian game nick name..
ah i see your problem. sorry i cant help you with that
Sorry currently support for russian character table is not scheduled, my tools are primary focused on pwi...