[RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

Printable View

Show 100 post(s) from this thread on one page

19-02-09
beastie

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

problem that I have now is how to create a GM and add Cubicoins using MySQL instead of MSSQL..

any ideas guys?
20-02-09
RonJon

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

The GM thing, As far as I know is a query command used inside of MySQL. I can't remember what the query command is. And with cubi, as far as I can figure, it should just be a setting in one of the tables.
22-02-09
beastie

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

for anyone who still needs the MySQL database dump.. here it is..

http://www.mmorpg-devs.com/forum/showthread.php?t=503
22-02-09
RevLord

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

i got a problem setting it up , i installed the server 1.3.6 with mssql not mysql since i couldn`t find the mysql dumps....it runs , it connects to the server but in game i get 1hp 1mp also wont allow me to pick any items drops,it`s like not beeing connected to the server ....a quick reply would be great since i`m in a cybercafe :D
real question is , it`s the client not sinchronizing with the server or it`s the db ?
23-02-09
sandolkakos

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

Quote:

Originally Posted by RevLord

i got a problem setting it up , i installed the server 1.3.6 with mssql not mysql since i couldn`t find the mysql dumps....it runs , it connects to the server but in game i get 1hp 1mp also wont allow me to pick any items drops,it`s like not beeing connected to the server ....a quick reply would be great since i`m in a cybercafe :D
real question is , it`s the client not sinchronizing with the server or it`s the db ?

I get this error too, but in mysql db server.

and now with mssql i dont have this error.
23-02-09
beastie

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

Wanna add/remove GM privileges and/or give cubicoins for users using a MySql Database?

Heres a link for a program called BATGM by Adslpredator in the mmorpg- devs forums that does that very purpose.. :thumbup:

http://www.mmorpg-devs.com/forum/showthread.php?t=894

Currently at version v0.08 alpha I've tested and find that it works very well :w00t:

Please Note..

you have to allow the machine running BATGM privileges to access/edit the mysql database or it wont work :wink: this can be done with phpmyadmin on the lampp server http://YOURIP/phpmyadmin :8:

happy gaming..
B..
23-02-09
Romulan

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

Hello guys,
I have installed PWserver1.3.6 on Ubuntu Server 8.04 (my server's files is "rzpw.7z" from sticky page).
I use XAMPP 1.7 (like mychatz..).

But it's strange.. there is one file for MySQL "dbo.sql" and two files for MSSQL.. (mssql_storeprocedure.sql, mssql_table.sql). And i think my "table.xml" is not appropriate for MySQL but good for MSSQL.

So.. can i have a sample code of "table.xml" for use with MySQL... and i want to know is there a sql script same as "mssql_storeprocedure.sql" for MySQLof course.

Thx.

PS: My *.conf are fully corrects and hosts file too ! The error is not from them....
23-02-09
RevLord

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

Quote:

Originally Posted by sandolkakos

I get this error too, but in mysql db server.

and now with mssql i dont have this error.

i made it both with mysql and mssql , but same issue....my guess is the client that is causing it
i`m using my_en client with patches up to 1.3.1, could u tell me what client yr using?
23-02-09
Romulan

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

I have MY-EN 1.3.1 Client..
But I hate MSSQL.. I Want use MySQL Only ! ^^

And when I try to login.. I have the shity error : LINK - Error in server and Network..
But i think the problem is the script code of table.xml and the missed file... "mssql_storeprocedure.sql".

Thx for any future responses can help me.. ^^
23-02-09
Romulan

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

Very not active thread... I post on the main page -.-" ...........
21-05-09
demonspeeding

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

hey guys im new and wanna makke my own pw server help!!!!!!!!!!
05-04-11
ninekinsen

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

Quote:

Originally Posted by mychatz

Ok guys, here's my file release complete with all tools you will need for setting up PWServer version 1.3.6.

Requirements :

1. Clients and Patches
PW MY Client (version 1.2.6)
Patch to Client 1.2.9
Patch to Client 1.3.1

2. Perfect World 1.3.6 (mirror link)
Part 1
Part 2

Download it to your Windows XP/Vista and extract it. Re-upload the files to your Linux Machine.

3. XAMPP (latest version) . Download it to your linux machine

3. A ready stock OS : In this case i'm using my all-time favourite OS which is Slackware 12 with full install and stopped the Apache and MYSQL which comes ready with it.

Basically you need to use any OS (Linux) Ubuntu,Red Hat, SuSe, Mandrake or whatever you want to use as long as you know your choice of OS structures and folder plus workaround. You will need to stop using Apache and MySQL that comes with your OS. We'll be using LAMPP in this case which will be installed on folder /opt .

4. MYSQL SQL Dumps from the sticky page (recommended to use Search button for it)

5. JAVA 1.6 version installed

6. Some Linux/Unix knowledge on command line prefix and editors (won't be cover here on how to use it)

DISCLAIMER :

This release in intended for fellow friends who has already installed sucessfully their PW Servers respectively using coLinux. Any guides or experience setting it up using totoman7 guide's or boroda's guide is much needed here. So if you are a newbie, you will get stucked and hit wall really hard since my release do requires some brains to figure out the location of files to be placed and also some editing of files. Feel free to try,no harm but don't come here whining about where to put the stuff and what to edit.

INSTALLATION:

1. Download all those files to your linux machine and unrar it. Here you will find all the required files to run the PW Server.

2. Place the table.xml and hosts to /etc . You will need to edit those IP's and PASSWORD . Currently i'm using class C IP (192.168.0.50), and don't forget to edit table.xml PASSWORD to your MYSQL root password.

3. Place the PWServer to /home/your_username_here etc : /home/matrix/ . You will need to place start_server.sh and stop_server.sh too inside this folder and edit PW_PATH in your start_server.sh .

Originally it would look like this :

#!/bin/sh

PW_PATH=/home/matrix/PWServer

Change the line PW_PATH=/home/your_username_here/PWServer etc: /home/johndoe/PWServer

4. Double check and update/change the IP Address on each of the folder insde PWServer. File name to look for is gamesys.conf . This step is optional IF you use the same IP Address as me (192.168.0.50), but if you choose to change, you will need to change the IP Address line inside those files. Other files that you need to pay attention is the authd.conf inside the authd folder. You will need to update/change the IP Address if you're using a diffrent IP Address (default is 192.168.0.50)

5. Install LAMPP using the supplied file : xampp-linux-1.6.8a.tar.gz to folder /opt. You will need to use files from folder Regscript (which is basically a registeration script in PHP) and placed it there. Of course you will need to edit the files such as root password for mysql.

6. You will need to verify your JAVA installation that comes bundled with your OS. If java is present, then verify the installation folder. using java -version

root@matrix:/usr/lib/java/bin# ./java -version
java version "1.6.0_01"
Java(TM) SE Runtime Environment (build 1.6.0_01-b06)
Java HotSpot(TM) Client VM (build 1.6.0_01-b06, mixed mode, sharing)
root@matrix:/usr/lib/java/bin#

Now you guys need to pay attention here since it's kinda trivial. First step is verify your java installation folder using "whereis java" command. And after that you will need to edit $HOME/PWServer/authd/authd and update/change the ABSOLUTE path to your java . Don't miss this step or you will hit wall and error will occured when you start the server.

7. As for adding cubi or editing/installing iweb is not yet covered here. Feel free to use the Search button for this. I believe Marhazk has released a new stuff on his "iweb" and some other posts that discussed about adding cubi (MySQL version) using Navicat/PhpMyAdmin.

That's all i can think of right now, it might not complete 100% and that's where you guys come in and fill in the blanks. PLEASE post here if you feel something need to be changed/updated or maybe some hints. I'll try my best to fulfill all request. :thumbup:

Where the place of "Place the table.xml and hosts to /etc" and "to folder /opt" >> for /etc And /opt
File system >> etc or the other.
File system >> opt ??
please help me:*:
05-04-11
Drakaer

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

Quote:

Originally Posted by ninekinsen

Where the place of "Place the table.xml and hosts to /etc" and "to folder /opt" >> for /etc And /opt
File system >> etc or the other.
File system >> opt ??
please help me:*:

The Linux file system is different to Windows. In Windows you would normally have C:\Folders. In Linux it is just /Folders. So when it says /etc and /opt it means goto the root of your file system then goto those folders.

If you don't understand this then you shouldn't be setting up a server yet and should first go learn a thing or two about the OS you are using.

Also these files don't run on Windows. You have to install a Linux OS first.
05-04-11
Romulan

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

Epic Necro'd thread also... nice :doh:
06-04-11
ninekinsen

Re: [RELEASE] PWServer 1.3.6 MYSQL version (LINUX)

Quote:

Originally Posted by Drakaer

The Linux file system is different to Windows. In Windows you would normally have C:\Folders. In Linux it is just /Folders. So when it says /etc and /opt it means goto the root of your file system then goto those folders.

If you don't understand this then you shouldn't be setting up a server yet and should first go learn a thing or two about the OS you are using.

Also these files don't run on Windows. You have to install a Linux OS first.

I have finished With that problem , used gksudo nautulis, but, when I open in Mozilla,,entered : localhost/PhpMyAdmin, I entered the account and password, show next page is error PHP,.,.,
Why is that??:?:
:?:
I Confused, with regscript folder and msSQLjdbc folder,.,.,where to copy.,. :?::?:

I try to retry the step but confuse
this the SS in OS XP
Can you tell me where to copy the file and the folder with details,
http://www.4shared.com/photo/yyqlI9Bq/SS_online.html

Show 100 post(s) from this thread on one page