Custom Arcturus Catalog 2.0

[maxx]

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.

Spoiler

 

[Sam_Otten]

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

 

[Rystbo]

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

 

[Sam_Otten]

Some of the sqls are missing

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)

 

[Rystbo]

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]

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]

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]

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]

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

, '');

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]

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

, '');

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?

 

[maxx]

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

I'll send it when I come home

 

[Chuckie_]

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

ALTER TABLE items_base ADD COLUMN clothing_on_walk INT DEFAULT 0;

 

[Sam_Otten]

That fixed it! Thank you so much.
So Maxx and I are on the same problem now I thijk, but most furni works.

 

[maxx]

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

ALTER TABLE items_base ADD COLUMN clothing_on_walk INT DEFAULT 0;

That was a much simpler solution than mine.

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]

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]

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]

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. :/

 

[VSy4C]

Why i cant use your habbo.swf its stuck at 76%

 

[Joe]

Why i cant use your habbo.swf its stuck at 76%

Probably the wrong production

 

[VSy4C]

Probably the wrong production

i have to change the whole production ?