lmfao!Quote:
Originally Posted by fgru
doesnt hrace009 image have pwAdmin.. just update it an use the sync link to fix the char listingQuote:
Originally Posted by putra2163
Printable View
lmfao!Quote:
Originally Posted by fgru
doesnt hrace009 image have pwAdmin.. just update it an use the sync link to fix the char listingQuote:
Originally Posted by putra2163
Take a guess...Quote:
Originally Posted by putra2163
i got a problem for ROLE SQL IMPORT,
it always show Importing Roles to MySQL Failed when you have a character more than 61.
i try to remove it from mysql, and regenerate it again. but it only read 61 character's
the other character can't be load
some one have problem like me?
i have problem like this, but if i have more than 61 character'sQuote:
Originally Posted by PWReadyGO
and it never update the last 61++ characters
how to solve this? :$:
i already upgrade my pwAdmin with 1.8 and using bundle jetty 7.2, but it still got like this :$:
i have 166 account, and each account have 1 character
but it still shown 61 character :$:
hrace009 I think is problem in your file server, I had the same problem, and a good time before when I entered a command to list all clans of the game has corrupted the database, Is there any error in the database of your files. What to ask for it to make a listing error.
nope their is nothing wrong with my databases.
but the one thing. if i entered adminer, and select roles, there are 110 character slip it to display 30 per page.
but when i go to page 2 adminer will say error :
HTTP ERROR 404
Problem accessing /adminer/adminer-3.0.1-mysql.php&page=1. Reason:
Not Found
Powered by Jetty://
and the list character at pwAdmin is only shows page 1
---------- Post added at 07:16 PM ---------- Previous post was at 06:29 PM ----------
okey... problem solve...
it's not because error at ur game database.
it because NAmE colomn was set to varchar(32).
and if your player made a character using symbols like ★Espada★
or ☆☆☆Espada☆☆☆
it will record at dbase using number and each symbol >> ☆ will using 4 leters at dbase. and if it more than 32 char, it will stop to created it.
so i was change role.jsp
// drop table and re-create it (autoincrement reset)
//statement.execute("TRUNCATE TABLE roles");
statement.executeUpdate("DROP TABLE IF EXISTS roles");
statement.executeUpdate
(
"CREATE TABLE roles(" +
"roleid int(11) NOT NULL, " +
"accountid int(11) NOT NULL, " +
"name varchar(256) NOT NULL, " + <<<<< previous 32
"level smallint(6) NOT NULL, " +
"race tinyint(4) NOT NULL, " +
"occupation tinyint(4) NOT NULL, " +
"gender tinyint(4) NOT NULL, " +
"spouse int(11) NOT NULL, " +
"invader_state int(11) NOT NULL, " +
"invader_time int(11) NOT NULL, " +
"pariah_time int(11) NOT NULL, " +
"pvp_kills int(11) NOT NULL, " +
"factionid int(11) NOT NULL, " +
"factionname varchar(32) NOT NULL, " +
"faction int(11) NOT NULL, " +
"placeholder1 int(11) NOT NULL, " +
"placeholder2 int(11) NOT NULL, " +
"placeholder3 int(11) NOT NULL " +
") " +
"ENGINE=InnoDB DEFAULT CHARSET=utf8;"
);
and it ready to go :thumbup1:
Nice fix :wink:
http://i858.photobucket.com/albums/a...obucket/a2.png
I'm having a problem, I click import, but it says it does not matter. = /! Another problem is if I put an id of the character it does not load the data: "Loading Character Data Failed" In the old version of PWAdmin can list normally.
Server must be running to edit roles data :mellow:
look at adminer, find pw database, and see the tables, if there a table with named "roles" and look at it, it must have all your character id. if not look at your mysql connectionQuote:
Originally Posted by lotus55
now I can list, but the clan name is not imported, and comes to a small list and the error as the Hrace009.
pwAdmin doesn't show guild names...Quote:
Originally Posted by lotus55
It looks like it should if it doesn't :\
Yup, 343 is right! It show faction name for me (using pwAdmin 1.8 with jetty) :laugh: