Xantara's Flux CP databases are empty?

[Valiente 7]

How do I make the items/mobs appear?

 

This what I see:

Items

Search...

No items found. Go back.

[Jedzkie 58]

you must execute youre item_db.sql, item_db2.sql, item_db_re.sql, mob_db.sql, mob_db2.sql, mob_db_re.sql in your ragnarok database.

[Valiente 7]

I did that, but only the monster database is showing results.

[Jedzkie 58]

you must re-install your flux cp, how to reinstall? delete the cp_* files in your ragnarok database.

[Valiente 7]

you must re-install your flux cp, how to reinstall? delete the cp_* files in your ragnarok database.

 

I have done that more than 10x already. Any other solutions that you can recommend?

[quesoph 105]

Delete your cp_* in your database then delete the files inside

 

FLUX_ROOT/data/schemas/charmapdb/

and

FLUX_ROOT/data/schemas/logindb/

Then install or update everything.

[Valiente 7]

Delete your cp_* in your database then delete the files inside

 

FLUX_ROOT/data/schemas/charmapdb/

and

FLUX_ROOT/data/schemas/logindb/

Then install or update everything.

 

I just did that, now it skips the installation process.

Edited July 25, 2013 by Valiente

[jTynne 101]

This is something I inquired about on the Git project page; Currently, it's not compatible because Hercules makes usage of two fields for atk / matk, and equip_level became equip_level_min and equip_level_max. Xantara's CP is written for rAthena, which still uses the atk:matk and equip_level fields.

 

I'm in the process of trying to find someone to update the item module contents so that the control panel supports latest Hercules. This will happen hopefully sooner rather than later.

 

RE: http://herc.ws/board/topic/1692-flux-item-monster-database-issues/

 

As for your having issues skipping the install page, go into your config/application.php file and modify the session key to a different name, or, clear your browser cookies.

[Samuel 83]

Hi, i have modified the fluxcp modules to make it compatible with hercules,

 

you can try the attachment below.

 

This file goes to modulesitem

 

It's working fine with me using hercules database, hope it helps.

index.php

[Valiente 7]

This is something I inquired about on the Git project page; Currently, it's not compatible because Hercules makes usage of two fields for atk / matk, and equip_level became equip_level_min and equip_level_max. Xantara's CP is written for rAthena, which still uses the atk:matk and equip_level fields.

 

I'm in the process of trying to find someone to update the item module contents so that the control panel supports latest Hercules. This will happen hopefully sooner rather than later.

 

RE: http://herc.ws/board/topic/1692-flux-item-monster-database-issues/

 

As for your having issues skipping the install page, go into your config/application.php file and modify the session key to a different name, or, clear your browser cookies.

 

Flux skips the installation process when I delete the schemas inside these folders: FLUX_ROOT/data/schemas/charmapdb/ and FLUX_ROOT/data/schemas/logindb/

Should I really delete these schemas? I believe they are necessary for the installation.

 

 

Hi, i have modified the fluxcp modules to make it compatible with hercules,

 

you can try the attachment below.

 

This file goes to modulesitem

 

It's working fine with me using hercules database, hope it helps.

 

It doesn't work.

Edited July 25, 2013 by Valiente

[jTynne 101]

Try this, placed inside of the module folder: http://www.rune-midgard.com/item.zip

 

Now, it won't get everything to display properly (I haven't been able to get MATK or equip_level_max to work.. sorry!) ;_;

[Valiente 7]

I got it working now (viewing of items, but still no atk/matk. lol), the problem is the tables. For some reason, I am getting the same error even though I am using pre-renewal configurations, which uses the old field tables.

Edited July 26, 2013 by Valiente

[jTynne 101]

OH! My partial-fix is for RE-mode >.< Sorry ;; Are you getting an error about the equip_level column?

[Valiente 7]

OH! My partial-fix is for RE-mode >.< Sorry ;; Are you getting an error about the equip_level column?

 

No, just the attack part, just commented them out. Still trying to figure out how to modify the code.

[jTynne 101]

Oh poo! If you can figure it out, please do share! =)

[Valiente 7]

Ugh.. I have been spending too much time on this. No dice! Anyone?

[Najara 10]

Same issue here. It worked fine with rAthena, but unfortunately it doesn't with Hercules.

 

I ran it in de-bug mode and the following message was given:

 

Message: MySQL error (SQLSTATE: 42S22, ERROR: 1054): Unknown column 'attack' in 'field list'

public_html/cp/modules/item/index.php:276

 

 

Quick edit, oh... I just read you posted another thread stating the same issue. My bad.

Edited July 26, 2013 by Najara

[Samuel 83]

This is the one I've been using and it's working fine with me.
 
Attack and Matk is working fine in the Item List and View page.
 
Just extract the to the correct folders.
 
Modules.7z goes to modules/item/
 
item.7z goes to themes/themeyouareusing/item/
 
Edit:
 
Added screenshots:
 

 

 

 

modules.7z

item.7z

Edited July 26, 2013 by Samuel

[Najara 10]

Strange... I don't know about Valiente, but it still doesn't seem to work for me.

 

The error message has changed though:

 

Message: MySQL error (SQLSTATE: 42S22, ERROR: 1054): Unknown column 'matk' in 'field list'

File: /public_html/cp/modules/item/index.php:297

Edited July 26, 2013 by Najara

[Samuel 83]

i think you're using pre-renewal xD what i've uploaded is renewal,

 

will try to upload once i get home

[Najara 10]

Nope, I'm using Renewal. That's the weird part.

[Valiente 7]

Yeah, it doesn't work with pre-renewal either. :/

[Brynner 34]

Yeah, it doesn't work with pre-renewal either. :/

try this.

http://herc.ws/board/topic/1747-hercules-fluxcp/

[jTynne 101]

This is the one I've been using and it's working fine with me.

 

Attack and Matk is working fine in the Item List and View page.

 

Just extract the to the correct folders.

 

Modules.7z goes to modules/item/

 

item.7z goes to themes/themeyouareusing/item/

 

Edit:

 

Added screenshots:

 

 

 

 

 

You are beautiful. <3

[BFPkiller 3]

they are still empty for me , mobs are fine , also atk etc , but not items.

any help ?

 

thnx

[Brynner 34]

they are still empty for me , mobs are fine , also atk etc , but not items.

any help ?

 

thnx

better to use proper fluxcp for hercules.

 

https://github.com/HerculesWS/FluxCP