|
You last visited: Today at 18:23
Advertisement
[HELP] Help With This.
Discussion on [HELP] Help With This. within the EO PServer Hosting forum part of the Eudemons Online category.
07/27/2010, 09:28
|
#1
|
elite*gold: 0 
Join Date: Nov 2009
Posts: 171
Received Thanks: 123
|
[HELP] Help With This.
How come everytime my players compose a pet up to like 1.4k star when they relog it goes down to like 900* or something? I know it has to do with db, but wat is it? If you can fix it id appreciate it, thank you.
Im useing maniquene db and client.
And if someone can give me the right itemtype.dat cause whenever i edit shop 1207 with shop.dat editor, i re log with my game and look inside shoppingmall and all the items that i jsut added are invisable, and i cant use them. If you know the right way to edit it please let me know, or talk to me on MSN. Thank you.
i love you all hehe
|
|
|
|
07/27/2010, 12:27
|
#2
|
elite*gold: 0
Join Date: Mar 2010
Posts: 40
Received Thanks: 0
|
Quote:
How come everytime my players compose a pet up to like 1.4k star when they relog it goes down to like 900* or something? I know it has to do with db, but wat is it? If you can fix it id appreciate it, thank you.
Im useing maniquene db and client.
And if someone can give me the right itemtype.dat cause whenever i edit shop 1207 with shop.dat editor, i re log with my game and look inside shoppingmall and all the items that i jsut added are invisable, and i cant use them. If you know the right way to edit it please let me know, or talk to me on MSN. Thank you.
|
it should be your msg server try using another one i use the 65000 go to this
HTML Code:
http://www.elitepvpers.com/forum/eo-pserver-hosting/368124-release-msg_server-release-2-400-trade-knight-65k-stars.html
|
|
|
|
|
07/27/2010, 18:46
|
#3
|
elite*gold: 0
Join Date: Nov 2009
Posts: 171
Received Thanks: 123
|
Quote:
Originally Posted by jesoro
it should be your msg server try using another one i use the 65000 go to this
HTML Code:
http://www.elitepvpers.com/forum/eo-pserver-hosting/368124-release-msg_server-release-2-400-trade-knight-65k-stars.html
|
im useing messageserver 2.700 can that work?
|
|
|
|
|
07/27/2010, 19:11
|
#4
|
elite*gold: 0
Join Date: Jan 2010
Posts: 558
Received Thanks: 145
|
yes use it, it will work
|
|
|
|
|
07/28/2010, 02:24
|
#5
|
elite*gold: 0
Join Date: Apr 2008
Posts: 180
Received Thanks: 47
|
there are actually many posts on this subject, I was having the same problem not to long ago. I know that in the revo database I had to change one of the value types to int instead of smallint for the cq_eudemon table.
|
|
|
|
|
07/29/2010, 02:22
|
#6
|
elite*gold: 0
Join Date: May 2009
Posts: 1,175
Received Thanks: 540
|
Its already been answered. I dont have any DB to check it out right now, So Sorry, Just search.
Check spoiler if you cant find any.
Save a back up and run these
PHP Code:
DROP TABLE IF EXISTS `cq_eudemon`;
CREATE TABLE `cq_eudemon` (
`id` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT,
`item_id` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`ori_owner_name` varchar(16) NOT NULL DEFAULT '',
`name` varchar(16) NOT NULL DEFAULT '?T',
`relationship` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`phyatk_grow_rate` smallint(4) unsigned NOT NULL DEFAULT '0',
`magicatk_grow_rate` smallint(4) unsigned NOT NULL DEFAULT '0',
`life_grow_rate` smallint(4) unsigned NOT NULL DEFAULT '0',
`phyatk_grow_rate_max` int(11) NOT NULL DEFAULT '0',
`magicatk_grow_rate_max` int(11) NOT NULL DEFAULT '0',
`availabletime` int(4) unsigned NOT NULL DEFAULT '0',
`life` int(11) NOT NULL DEFAULT '0',
`star_lev` int(11) NOT NULL DEFAULT '0',
`phy_atk_min` int(11) NOT NULL DEFAULT '0',
`phy_atk_max` int(11) NOT NULL DEFAULT '0',
`magic_atk_min` int(11) NOT NULL DEFAULT '0',
`magic_atk_max` int(11) NOT NULL DEFAULT '0',
`contract_time` int(4) NOT NULL DEFAULT '0',
`magic_defence` int(11) NOT NULL DEFAULT '0',
`luck` tinyint(4) unsigned NOT NULL DEFAULT '0',
`damage_type` tinyint(4) NOT NULL DEFAULT '0',
`level` tinyint(4) unsigned NOT NULL DEFAULT '0',
`exp` bigint(4) NOT NULL DEFAULT '0',
`fidelity` smallint(4) NOT NULL DEFAULT '0',
`talent1` tinyint(4) unsigned NOT NULL DEFAULT '0',
`talent2` tinyint(4) unsigned NOT NULL DEFAULT '0',
`talent3` tinyint(4) unsigned NOT NULL DEFAULT '0',
`skill_num_limit` tinyint(3) unsigned NOT NULL DEFAULT '5',
`reborn_times` smallint(4) unsigned NOT NULL DEFAULT '0',
`card_id` int(4) NOT NULL DEFAULT '0',
`talent4` tinyint(2) unsigned NOT NULL DEFAULT '0',
`talent5` tinyint(2) unsigned NOT NULL DEFAULT '0',
`initial_phy` smallint(2) unsigned NOT NULL DEFAULT '0',
`initial_magic` smallint(2) unsigned NOT NULL DEFAULT '0',
`initial_def` smallint(2) unsigned NOT NULL DEFAULT '0',
`initial_life` smallint(2) unsigned NOT NULL DEFAULT '0',
`phydef_grow_rate` smallint(2) unsigned NOT NULL DEFAULT '0',
`magicdef_grow_rate` smallint(2) unsigned NOT NULL DEFAULT '0',
`mete_lev` int(4) unsigned NOT NULL DEFAULT '0',
`chksum` int(4) unsigned NOT NULL DEFAULT '0',
`item_type` int(4) unsigned NOT NULL DEFAULT '0',
`owner_id` int(4) unsigned NOT NULL DEFAULT '0',
`player_id` int(4) unsigned NOT NULL DEFAULT '0',
`position` tinyint(4) unsigned NOT NULL DEFAULT '0',
`syndicate_id` int(4) unsigned NOT NULL DEFAULT '0',
`plunder` smallint(2) unsigned NOT NULL DEFAULT '0',
`reborn_day` tinyint(4) DEFAULT '0',
`reborn_limit_add` tinyint(4) unsigned DEFAULT '0',
`cinnabar` smallint(2) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_lev` (`star_lev`),
KEY `idx_reborn` (`reborn_times`),
KEY `idx_exp` (`exp`),
KEY `index_pet` (`item_id`),
KEY `index_petid` (`card_id`),
KEY `idx_level` (`level`),
KEY `idx_package` (`owner_id`,`position`,`player_id`),
KEY `idx_type` (`item_type`),
KEY `idx_player` (`player_id`),
KEY `idx_syn_id` (`syndicate_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2015271412 DEFAULT CHARSET=latin1;
PHP Code:
DROP TABLE IF EXISTS `cq_eudemon_rbn_rqr`;
CREATE TABLE `cq_eudemon_rbn_rqr` (
`id` int(4) NOT NULL DEFAULT '0',
`min` smallint(2) unsigned NOT NULL DEFAULT '0',
`max` smallint(2) unsigned NOT NULL DEFAULT '0',
`rand_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
`suc_percent` tinyint(1) unsigned NOT NULL DEFAULT '0',
`sacrifice_lev` smallint(2) unsigned NOT NULL DEFAULT '0',
`sacrifice_fidelity` smallint(2) unsigned NOT NULL DEFAULT '0',
`sacrifice_starlev` smallint(2) unsigned NOT NULL DEFAULT '0',
`sacrifice_dmg_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
`rbn_rqr_type` tinyint(2) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
PHP Code:
DROP TABLE IF EXISTS `cq_eudemon_rbn_type`;
CREATE TABLE `cq_eudemon_rbn_type` (
`id` int(4) unsigned NOT NULL DEFAULT '0',
`life` tinyint(1) unsigned NOT NULL DEFAULT '0',
`phy_atk` tinyint(1) unsigned NOT NULL DEFAULT '0',
`phy_def` tinyint(1) unsigned NOT NULL DEFAULT '0',
`mgc_atk` tinyint(1) unsigned NOT NULL DEFAULT '0',
`mgc_def` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
|
All times are GMT +1. The time now is 18:23.
|
|
![[HELP] Help With This.](https://www.elitepvpers.com/forum/iconimages/eo-pserver-hosting/help-help_ltr.gif){kind=small}
