How do I change the Weekly Rare?

[ano2k77]

Hey,

So basically, we told our users we will update the weekly rare in our cata every Saturday/Sunday, but as i'm the manager and we bought a pre-setup retro, we use Navicat premium to edit the database, I go on catalog_items on the database, but for some reason, I can't find our weekly rare in the catalog to change anywhere, I looked at all the prices, as our price for our weekly rare is 2,500 credits and 250 pixels and I can't find them anywhere in catalog_items, can someone please help me ASAP!

Thanks,

- Tyler

 

[Cronus]

you want to look in catalouge_pages find the weekyl rare page ID and then go back to catalogue items find where that item is by serachering the weekly rare ID

 

[Wassim]

- Go to your database
- Go to catalogue_items , Find the item you want to put in the limited [Mostly found in page number 34 ]
- Copy and put ID as random like 43882092
- Put Page ID as the page ID of Limited edition
- Items ID and Catalogue name will be automatically there
- Go to client and :update_catalogue to see the weekly rare

 

[ano2k77]

You must be registered for see links

I've looked on the catalog_pages and found the limited edition page id but can't find it on catalog_items, can someone help? Like come on my teamviewer and help me please?

You must be registered for see links

your way, I don't get it

 

[Wassim]

You must be registered for see links

I've looked on the catalog_pages and found the limited edition page id but can't find it on catalog_items, can someone help? Like come on my teamviewer and help me please?

You must be registered for see links

your way, I don't get it

In navicat go to cata_pages then type ctrl + F (control find) in the box that pops up type the name of the page (limited edition) once you find it follow the instructions below.

- Look for the page id for limited edition and write it down somewhere and label it so you don't forget (unless you have a good memory)

- Next you need to find the rare you would like to release in the table cata_items (if your on the client most of the rares in the catalogue should have their original name like pilow*2 (red pillow).

- After doing that look for page id in cata_items, once you find that change the page id to the page id you wrote down. (be sure to find the previous rare and remove it if you don't want it there.

- Last edit the credits, pixels, and the amount then click the check mark at the bottom.
- Go on the client and do :update_catalogue and your new rare showed be there.

 

[j4ke]

XAMPP:
First , go to your database in PhpMyAdmin
Second , go to catalogue_items and find the rare you want to put in the limited edition [ Mostly found in page number 34 ]
Third , click Copy and put ID as random like 43882092
Put Page ID as the page ID of Limited edition [ Hope you know how to find it ]
Items ID and Catalogue name will be automatically there
After filling all those credits and pixels and amount , click Go
Now say :update_catalogue and see the weekly rare

How do I remove the last weekly rare?
Simple. Go to the last page of your catalogue_items and find the rare that was lastly in the limited editions and click Delete

Why do I want to copy it and not edit it?
Just do it if you need the rare both in Staff catalogue and in weekly rares

IIS:
In navicat go to cata_pages then type ctrl + F (control find) in the box that pops up type the name of the page (limited edition) once you find it follow the instructions below.

- Look for the page id for limited edition and write it down somewhere and label it so you don't forget (unless you have a good memory)

- Next you need to find the rare you would like to release in the table cata_items (if your on the client most of the rares in the catalogue should have their original name like pilow*2 (red pillow).

- After doing that look for page id in cata_items, once you find that change the page id to the page id you wrote down. (be sure to find the previous rare and remove it if you don't want it there.

- Last edit the credits, pixels, and the amount then click the check mark at the bottom.
- Go on the client and do :update_catalogue and your new rare showed be there.


(GOTTEN THESE ANSWERS FROM SIMILAR POSTS, I DON'T KNOW HOW TO DO IT BY HEART)

 

[ano2k77]

You must be registered for see links

On cata_items, I try and find the page "Limited Edition" It says there is no such page?

 

[j4ke]

You must be registered for see links

On cata_items, I try and find the page "Limited Edition" It says there is no such page?

Are you using IIS?

 

[ano2k77]

What is IIS?

 

[Wassim]

You must be registered for see links

On cata_items, I try and find the page "Limited Edition" It says there is no such page?

cata_pages not cata_items

 

[j4ke]

What is IIS?

So your using XAMPP?

I have a way to do it in my earlier posts up more for XAMPP.

 

[ano2k77]

Does anybody have TeamViewer and would like to help me with it? As i'm not the smartest person... Lol

 

[j4ke]

Does anybody have TeamViewer and would like to help me with it? As i'm not the smartest person... Lol

Go to the hotelURL/phpmyadmin
Then do what I said..

 

[ano2k77]

I'm not using XAMPP