Help me :(

[Luizinrc]

I am dealing with error when trying to connect the server, all ta ok, used the server database ACRISIO SERVE, but then I tried to use the database of Dave Devils someone to explain to me why of error(Use the Jtb1 database) - Dave Devil's

[MentaL]

[bubbastic]

Hi,

Normally the server would find the missing infos in the ini files. I don't know why jtb's modified server doesn't. You can try this to pass the server list errors :

ALTER TABLE `pangya-ssd`.`pangya_server_list` 
CHANGE COLUMN `PCBangUser` `PCBangUser` smallint(8) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `PangRate` `PangRate` int(10) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `EventFlag` `EventFlag` smallint(8) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `ExpRate` `ExpRate` int(10) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `RareItemRate` `RareItemRate` int(10) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `CookieItemRate` `CookieItemRate` int(10) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `ServiceControl` `ServiceControl` int(10) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `AppRate` `AppRate` smallint(8) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `ScratchRate` `ScratchRate` smallint(8) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `EventMap` `EventMap` int(10) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `EventDropRate` `EventDropRate` int(10) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `HanbitUser` `HanbitUser` int(10) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `ParanUser` `ParanUser` int(10) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `AuthState` `AuthState` smallint(8) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `MasteryRate` `MasteryRate` smallint(8) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `TreasureRate` `TreasureRate` smallint(8) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `ChuvaRate` `ChuvaRate` smallint(8) NOT NULL DEFAULT 100 ;

-------------

Change the name in red with your schema name if it's different

I let you continue do the same for account table next :/ and maybe more tables after that. You can edit directly in PHPmyAdmin or MySQL Workbench...

I use only the original Acrisio version so I won't help much on this modified version, sorry

[Luizinrc]

Hi,

Normally the server would find the missing infos in the ini files. I don't know why jtb's modified server doesn't. You can try this to pass the server list errors :

ALTER TABLE `pangya-ssd`.`pangya_server_list` 
CHANGE COLUMN `PCBangUser` `PCBangUser` smallint(8) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `PangRate` `PangRate` int(10) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `EventFlag` `EventFlag` smallint(8) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `ExpRate` `ExpRate` int(10) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `RareItemRate` `RareItemRate` int(10) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `CookieItemRate` `CookieItemRate` int(10) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `ServiceControl` `ServiceControl` int(10) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `AppRate` `AppRate` smallint(8) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `ScratchRate` `ScratchRate` smallint(8) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `EventMap` `EventMap` int(10) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `EventDropRate` `EventDropRate` int(10) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `HanbitUser` `HanbitUser` int(10) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `ParanUser` `ParanUser` int(10) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `AuthState` `AuthState` smallint(8) NOT NULL DEFAULT 0 ,
CHANGE COLUMN `MasteryRate` `MasteryRate` smallint(8) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `TreasureRate` `TreasureRate` smallint(8) NOT NULL DEFAULT 100 ,
CHANGE COLUMN `ChuvaRate` `ChuvaRate` smallint(8) NOT NULL DEFAULT 100 ;

-------------

Change the name in red with your schema name if it's different

I let you continue do the same for account table next :/ and maybe more tables after that. You can edit directly in PHPmyAdmin or MySQL Workbench...

I use only the original Acrisio version so I won't help much on this modified version, sorry

I have little experience in mysql workbeachIs there a method or example that I can use to use this code that I just posted?

[jtb1]

Like i have say in MP:

My edited version work with UWAMP , you need use it , after go phpmyadmin , and execute sql with phpmyadmin
-> use this way because mysql benchwork is not very great

you can create table named pangya-ssd for execute sql , but i never have probleme with other name

If you name the mysql table pangya-ssd you don't have to edit ini files

and use 7z for extract or winrar by the way