Custom Arcturus Catalog 2.0

maxx

New Member
Oct 11, 2019
19
2
Is it the actual furniture SWF that's missing or just the icons?
It's the SWF and icon, but for some furniture the icon does not load but I can see the SWF.
zYcb.png
 

Sam_Otten

New Member
Feb 21, 2014
27
5
For me there's just nothing on pages.
EDIT: Okay so when I start the emulator I get a lot of java.sql errors about items not being found?
You must be registered for see images attach
 
Last edited:

Rystbo

-Hotel Owner, -Customs Developer, -Arcturus
Apr 16, 2018
390
200
You must be registered for see images attach

Every page looks like this.

EDIT: so I checked the network tab in my browser and fixed some errors, now the categories have icons but there are still no items.

Some of the sqls are missing
 

Rystbo

-Hotel Owner, -Customs Developer, -Arcturus
Apr 16, 2018
390
200
How do I know which ones and what to do? I have imported all the sqls from your downloads and tried multiple times (after emptying the tables too)

Ok so here is what you have to do im just going to work off the image you provided that showed an error on the Christmas 2018 page

What your going to do is go into catalog_pages and find the page id for Christmas 2018 (This goes for what ever page your looking for as well thats missing items)

The id for Christmas 2018 I have is 10091, your might be different.

Now im going to go into catalog_items and find all the items for page 10091.

Now you will have the following:

A- Its there --- if it is look below

B- its not ---> If its not there, than you need to add the sql. If theres no sql, then theres no furni lol

So say it is there,

INSERT INTO `arcturus`.`catalog_items`(`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_points`, `cost_diamonds`, `amount`, `limited_sells`, `limited_stack`, `offer_active`, `extradata`, `badge`, `offer_id`, `song_id`, `order_number`, `points_type`, `have_offer`, `club_only`) VALUES (73481492, 10091, '73481492', 'xmas_c18_doll1_name', 3, 0, 0, 1, 0, 0, '1', '', '', -1, 0, 0, 0, '1', '0');


We look at the Id of the item in this case its 73481492

Now we want to go into items_base and see if that id is there

A- if its not there, than you need to add the item

B- if it is there than chances are you just need to do a :update_items and :update_Catalog (in that order)

Typically if nothing is showing its because the sqls do not exist, if the images dont show thats swf related. Sometimes it can be also because your ids dont match.
 

Sam_Otten

New Member
Feb 21, 2014
27
5
Ok so here is what you have to do im just going to work off the image you provided that showed an error on the Christmas 2018 page

What your going to do is go into catalog_pages and find the page id for Christmas 2018 (This goes for what ever page your looking for as well thats missing items)

The id for Christmas 2018 I have is 10091, your might be different.

Now im going to go into catalog_items and find all the items for page 10091.

Now you will have the following:

A- Its there --- if it is look below

B- its not ---> If its not there, than you need to add the sql. If theres no sql, then theres no furni lol

So say it is there,

INSERT INTO `arcturus`.`catalog_items`(`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_points`, `cost_diamonds`, `amount`, `limited_sells`, `limited_stack`, `offer_active`, `extradata`, `badge`, `offer_id`, `song_id`, `order_number`, `points_type`, `have_offer`, `club_only`) VALUES (73481492, 10091, '73481492', 'xmas_c18_doll1_name', 3, 0, 0, 1, 0, 0, '1', '', '', -1, 0, 0, 0, '1', '0');


We look at the Id of the item in this case its 73481492

Now we want to go into items_base and see if that id is there

A- if its not there, than you need to add the item

B- if it is there than chances are you just need to do a :update_items and :update_Catalog (in that order)

Typically if nothing is showing its because the sqls do not exist, if the images dont show thats swf related. Sometimes it can be also because your ids dont match.

Okay so I have the page (10091) but I don't get what you mean after that? Because if I look up 73481492 in items_base I can't find it. What do I need to do?
 

Rystbo

-Hotel Owner, -Customs Developer, -Arcturus
Apr 16, 2018
390
200
Okay so I have the page (10091) but I don't get what you mean after that? Because if I look up 73481492 in items_base I can't find it. What do I need to do?

That means the sql for items_base was never added you need to add the sql.

Furni works like this ---> you have an swf this is than linked to the furnidata ----> thats why the furnidata has an id and the swf name

Next you have the items_base sql, this has an id that id links to the furnidata id and the swf.

Lastly, you have the catalog_item this requests 2 ids, the first is just a unique id for the catalog item the second has to be the item_base id. This tells the catalog what item
from the item_base category goes where the price and ect.

They all link BUT if you dont have the item_base sql than your catalog doesnt know what swf or item to put in the catalog although u have a catalog item made.

Make sense?
 

Sam_Otten

New Member
Feb 21, 2014
27
5
That means the sql for items_base was never added you need to add the sql.

Furni works like this ---> you have an swf this is than linked to the furnidata ----> thats why the furnidata has an id and the swf name

Next you have the items_base sql, this has an id that id links to the furnidata id and the swf.

Lastly, you have the catalog_item this requests 2 ids, the first is just a unique id for the catalog item the second has to be the item_base id. This tells the catalog what item
from the item_base category goes where the price and ect.

They all link BUT if you dont have the item_base sql than your catalog doesnt know what swf or item to put in the catalog although u have a catalog item made.

Make sense?
Yeah it makes sense, thanks for the explanation. I have imported item_base again and the file is there now, I did :update_items and :update_catalog but it's still not showing ANY items...
 

maxx

New Member
Oct 11, 2019
19
2
For me there's just nothing on pages.
EDIT: Okay so when I start the emulator I get a lot of java.sql errors about items not being found?
You must be registered for see images attach
I was getting the same thing. The column clothing_on_walk I simply added with some regex magic, by first creating the column and then applying
Code:
, '');
at the end of every insert statement to make up for the new column. After that it didn't complain about that column in particular anymore, however I still get a few SQL errors when I start morningstar which could explain my missing furni.
 

Sam_Otten

New Member
Feb 21, 2014
27
5
I was getting the same thing. The column clothing_on_walk I simply added with some regex magic, by first creating the column and then applying
Code:
, '');
at the end of every insert statement to make up for the new column. After that it didn't complain about that column in particular anymore, however I still get a few SQL errors when I start morningstar which could explain my missing furni.

I don't really get how you added the column clothing_on_walk? Do you have the SQL you have used for that?
 

Chuckie_

Active Member
Jun 22, 2019
138
71
I don't really get how you added the column clothing_on_walk? Do you have the SQL you have used for that?
Just run an alter query on the table. I'm not sure what data type it has to be, but it'll look like something like
Code:
ALTER TABLE items_base ADD COLUMN clothing_on_walk INT DEFAULT 0;
 

maxx

New Member
Oct 11, 2019
19
2
Just run an alter query on the table. I'm not sure what data type it has to be, but it'll look like something like
Code:
ALTER TABLE items_base ADD COLUMN clothing_on_walk INT DEFAULT 0;
That was a much simpler solution than mine. :D

That fixed it! Thank you so much.
So Maxx and I are on the same problem now I thijk, but most furni works.
I'm guessing we have to solve the remaining SQL errors to get everything to work.
 

Sam_Otten

New Member
Feb 21, 2014
27
5
Okay so for anyone else who didn't see the icons for products in the catalog: if you move alle the files in dcr/hof_furni/icons to dcr/hof_furni they will load :)
 

Rystbo

-Hotel Owner, -Customs Developer, -Arcturus
Apr 16, 2018
390
200
Okay so for anyone else who didn't see the icons for products in the catalog: if you move alle the files in dcr/hof_furni/icons to dcr/hof_furni they will load :)

This isn't necessarily true. It depends on the path in your variables for your icons. Some are in a secondary folder. I think its sloppy to have your icons and swfs in the same folder. For any one whos icons are in a separate folder, the icon path has to match it.
 

maxx

New Member
Oct 11, 2019
19
2
This isn't necessarily true. It depends on the path in your variables for your icons. Some are in a secondary folder. I think its sloppy to have your icons and swfs in the same folder. For any one whos icons are in a separate folder, the icon path has to match it.
Agreed, you should follow semantics and have a seperate folder for it.

Okay so for anyone else who didn't see the icons for products in the catalog: if you move alle the files in dcr/hof_furni/icons to dcr/hof_furni they will load :)
Have you had any success with the broken furni? For me some are still broken. :/
 

Users who are viewing this thread

Top