[Release] Perfect World Server 1.4.4 - Basic Setup

[IwannaPWserver]

Just tried out this release, and found a problem.
It's likely I missed something in configuration, but, when I add gold and check usecashnow the status is always at 0, and gold is never added.

Everything else works perfectly.

EDIT: Seems to work now, I did miss something ;)

[AcidRayne]

anyone know why when i try to do stuff on iweb all it does is just load? it never does anything. i've checked all my config files and all other files i can think of for maybe wrong pass or ip and everything seems to be right.

[fgru]

... iweb need a little to connect to ID´s > if load never ending - try again and again ... btw char need to be logged out ...

[AcidRayne]

... iweb need a little to connect to ID´s > if load never ending - try again and again ... btw char need to be logged out ...

nice thanks i got it to go to XML but when i click server management it still just loads forever and i have been trying all day XD


Edit:--
Never mind figured it out lmfao.

[arvy]

Error
SQL query:

CREATE PROCEDURE `acquireuserpasswd` ( IN name1 VARCHAR( 64 ) , out uid1 INTEGER, out passwd1 VARCHAR( 64 ) ) BEGIN SELECT id, passwd
INTO uid1, passwd1
FROM users
WHERE name = name1;

END$$

MySQL said:

#1304 - PROCEDURE acquireuserpasswd already exist


anyone can help me on this error.. >.< i just cant fixed it lol.. :D

[khangvn10]

Error
SQL query:

CREATE PROCEDURE `acquireuserpasswd` ( IN name1 VARCHAR( 64 ) , out uid1 INTEGER, out passwd1 VARCHAR( 64 ) ) BEGIN SELECT id, passwd
INTO uid1, passwd1
FROM users
WHERE name = name1;

END$$

MySQL said:

#1304 - PROCEDURE acquireuserpasswd already exist


anyone can help me on this error.. >.< i just cant fixed it lol.. :D

When pasting those lines into the SQL field, make sure you type the "$$" into the Delimiter field.
*Edit: Before doing so, reset all your database.

[arvy]

When pasting those lines into the SQL field, make sure you type the "$$" into the Delimiter field.

i did i just keep gettin the same error, i also tried to delete the first to line that says
DELIMITER $$
use pw$$

Ohk since im still newbie on these things... i might have to ask how do i reset the database lo

*Edit: erhmmm i having another error at pwAdmin, it says "Connection to MySQL database failed" >.<

[rezpounz]

nice share

[Zavros]

hey all I'm kinda new to all of this and having problems with phpmyadmin :s.. I installed it and everything like it says in this guide but I can't seem to get it to work :/
any ideas what's wrong with it?

I get this Error when I do the Database;

Spoiler:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'use pw; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; DROP TABLE IF EXISTS `auth`; CRE' at line 3

[Zettacorn]

Ok, my friends and I connect np but I still cant get cubi working -.- how precisely would I go about fixing that?

[fgru]

delimiter > error > fixed ...

ive tested few ways to " import " mysql_procedures.sql and now i have found one way it works 100%

execute mysql_tables.sql > go to new createtd databse > try SQL field on tables top > open mysql_procedures.sql and now step by step ...

try first row

CREATE PROCEDURE `acquireuserpasswd`(in name1 VARCHAR(64), out uid1 INTEGER, out passwd1 VARCHAR(64))
BEGIN
    SELECT id, passwd INTO uid1, passwd1 FROM users WHERE name = name1;
END$$

delete the $$ > and change delimiter field from " ; " to " §§ " at tables end ...

... next row / next row / ... [ one row = create to end ]

ive testet all but i get error ... this way works 100%

[whisky]

Hello, I'm having problem with registration process.

I loaded up the registration page, after filling some info, I hit "Registration" and it showed "Can't connect to MySQL".

I did edit the
etc/gmopgen.xml
/etc/table.xml
/var/www/register/config.php
/var/www/register/status.php

to match my server, but it's still not working.

Any help please?

P/S: others are running smoothly, even iweb and pwAdmin, database is the onlything I'm stuck at.

Also, this is my first time try to host PW server, after executing the server, what should I do to the client to get it connect to my server?

[fgru]

... config.php ... next look around the registration script ...

client = patcher/server/ .txt

[whisky]

... config.php ... next look around the registration script ...

client = patcher/server/ .txt

Thank you, gotta go to school now XD will try to look at those script again.

And the client: can you gimme more detail pls, becuz I'm confused about the patcher/server files u said - don't know where they are. I got no experience with patching client too, so please forgive if it's a stupid question.

[zoneheart]

thank you for sharing this, possible to have an image to virtualbox?