how to install a database

hokka · Jul 2, 2009

I've tried to install and use a database for perfect world... but I don't know how to do this well. I 'v made a db with xampp with sql codes downloaded from this site, but i don't know how to connect the db with the server or, if this is an automatic step, with the game, or maybe I 'v committed an error typing ip in the server list:ehh:

hokka - how to install a database - RaGEZONE Forums

this is a screenshot, help me pls :*:

segredu · Jul 2, 2009

hokka said:
I've tried to install and use a database for perfect world... but I don't know how to do this well. I 'v made a db with xampp with sql codes downloaded from this site, but i don't know how to connect the db with the server or, if this is an automatic step, with the game, or maybe I 'v committed an error typing ip in the server list:ehh:

this is a screenshot, help me pls :*:

Ok, if you is using Xampp, access your phpmyadmin and folow this step.

1) Check on Linux /etc/table.xml your MySql database name. uncomment if need.

<driver name="com.mysql.jdbc.Driver" />
<connection name="auth0" poolsize="3" url="jdbc:mysql://localhost/passport?useUnicode=true&characterEncoding=utf8" username="root" password=""/>

Put the the database name in your phpmyadmin and click to create

2) Copy the MySql code (below) and paste to SQL table on your phpmyadmin. Click on Go!

3) If no error. Your database is work fine. :thumbup1:

Code:

-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
-- --------------------------------------------------------
-- 啸芯褋褌: localhost
-- 袙褉械屑褟 褋芯蟹写邪薪懈褟: 袠褞薪 09 2008 谐., 02:11
-- 袙械褉褋懈褟 褋械褉胁械褉邪: 5.0.51
-- 袙械褉褋懈褟 PHP: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- Original database written by Shawn. Changed by trash.
-- 袘邪蟹邪 写邪薪薪褘褏: `dbo`
-- --------------------------------------------------------
-- 小褌褉褍泻褌褍褉邪 褌邪斜谢懈褑褘 `auth`

CREATE TABLE IF NOT EXISTS `auth` (
  `userid` int(11) NOT NULL default '0',
  `zoneid` int(11) NOT NULL default '0',
  `rid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`userid`,`zoneid`,`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 袛邪屑锌 写邪薪薪褘褏 褌邪斜谢懈褑褘 `auth`
-- --------------------------------------------------------
-- 小褌褉褍泻褌褍褉邪 褌邪斜谢懈褑褘 `forbid`

CREATE TABLE IF NOT EXISTS `forbid` (
  `userid` int(11) NOT NULL default '0',
  `type` int(11) NOT NULL default '0',
  `ctime` datetime NOT NULL,
  `forbid_time` int(11) NOT NULL default '0',
  `reason` blob NOT NULL,
  `gmroleid` int(11) default '0',
  PRIMARY KEY  (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 袛邪屑锌 写邪薪薪褘褏 褌邪斜谢懈褑褘 `forbid`
-- --------------------------------------------------------
-- 小褌褉褍泻褌褍褉邪 褌邪斜谢懈褑褘 `iplimit`
--

CREATE TABLE IF NOT EXISTS `iplimit` (
  `uid` int(11) NOT NULL default '0',
  `ipaddr1` int(11) default '0',
  `ipmask1` varchar(2) default '',
  `ipaddr2` int(11) default '0',
  `ipmask2` varchar(2) default '',
  `ipaddr3` int(11) default '0',
  `ipmask3` varchar(2) default '',
  `enable` char(1) default '',
  `lockstatus` char(1) default '',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 袛邪屑锌 写邪薪薪褘褏 褌邪斜谢懈褑褘 `iplimit`
-- --------------------------------------------------------
-- 小褌褉褍泻褌褍褉邪 褌邪斜谢懈褑褘 `online`
--

CREATE TABLE IF NOT EXISTS `online` (
  `ID` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 袛邪屑锌 写邪薪薪褘褏 褌邪斜谢懈褑褘 `online`
-- --------------------------------------------------------
-- 小褌褉褍泻褌褍褉邪 褌邪斜谢懈褑褘 `point`
--

CREATE TABLE IF NOT EXISTS `point` (
  `uid` int(11) NOT NULL default '0',
  `aid` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `zoneid` int(11) default '0',
  `zonelocalid` int(11) default '0',
  `accountstart` datetime default NULL,
  `lastlogin` datetime default NULL,
  `enddate` datetime default NULL,
  PRIMARY KEY  (`uid`,`aid`),
  KEY `IX_point_aidzoneid` (`aid`,`zoneid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 袛邪屑锌 写邪薪薪褘褏 褌邪斜谢懈褑褘 `point`
-- --------------------------------------------------------
-- 小褌褉褍泻褌褍褉邪 褌邪斜谢懈褑褘 `usecashlog`
--

CREATE TABLE IF NOT EXISTS `usecashlog` (
  `userid` int(11) NOT NULL default '0',
  `zoneid` int(11) NOT NULL default '0',
  `sn` int(11) NOT NULL default '0',
  `aid` int(11) NOT NULL default '0',
  `point` int(11) NOT NULL default '0',
  `cash` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `creatime` datetime NOT NULL,
  `fintime` datetime NOT NULL,
  KEY `IX_usecashlog_creatime` (`creatime`),
  KEY `IX_usecashlog_uzs` (`userid`,`zoneid`,`sn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 袛邪屑锌 写邪薪薪褘褏 褌邪斜谢懈褑褘 `usecashlog`
-- --------------------------------------------------------
-- 小褌褉褍泻褌褍褉邪 褌邪斜谢懈褑褘 `usecashnow`
--

CREATE TABLE IF NOT EXISTS `usecashnow` (
  `userid` int(11) NOT NULL default '0',
  `zoneid` int(11) NOT NULL default '0',
  `sn` int(11) NOT NULL default '0',
  `aid` int(11) NOT NULL default '0',
  `point` int(11) NOT NULL default '0',
  `cash` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `creatime` datetime NOT NULL,
  PRIMARY KEY  (`userid`,`zoneid`,`sn`),
  KEY `IX_usecashnow_creatime` (`creatime`),
  KEY `IX_usecashnow_status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 袛邪屑锌 写邪薪薪褘褏 褌邪斜谢