Trying to install a new catalogue and this happens?

[Lohex]

Well, I decided to use a new emulator and update to a new catalogue and than i got this error, after I've done everything correctly.

RevCMS
Gold Tree Emulator

 

[Jerry]

OH, I mean

ALTER TABLE `catalog_items` ADD `BadgeID` varchar(100) NOT NULL

Silly me

 

[Lohex]

Okay I was also missing song_id but I took care of that... there's also a new error -.-

OH, I mean

ALTER TABLE `catalog_items` ADD `BadgeID` varchar(100) NOT NULL

Silly me

 

[Each]

Ur Catalogue That u r adding is bugged..

 

[Lohex]

Ur Catalogue That u r adding is bugged..

That's why this has happened with every catalogue I've tried to add? k

 

[Jerry]

I just looked in the source and I found;

hashtable.Add((uint)dataRow["Id"], new CatalogItem((uint)dataRow["Id"], (string)dataRow["catalog_name"], (string)dataRow["item_ids"], (int)dataRow["cost_credits"], (int)dataRow["cost_pixels"], (int)dataRow["cost_snow"], (int)dataRow["amount"], (int)dataRow["page_id"], GoldTree.smethod_2(dataRow["vip"].ToString()), (uint)dataRow["achievement"], (int)dataRow["song_id"], BadgeID));

So.. I don't knoe about this code, Try figure-out on your own,.

 

[Each]

Cz they r also bugged..

 

[Lohex]

I just looked in the source and I found;

hashtable.Add((uint)dataRow["Id"], new CatalogItem((uint)dataRow["Id"], (string)dataRow["catalog_name"], (string)dataRow["item_ids"], (int)dataRow["cost_credits"], (int)dataRow["cost_pixels"], (int)dataRow["cost_snow"], (int)dataRow["amount"], (int)dataRow["page_id"], GoldTree.smethod_2(dataRow["vip"].ToString()), (uint)dataRow["achievement"], (int)dataRow["song_id"], BadgeID));

So.. I don't knoe about this code, Try figure-out on your own,.

Is there a way I can get a new Emulator/SQLs, so it's easier to add a catalogue?

 

[Jerry]

Try re-adding the catalogue again and add these columns;

ALTER TABLE `furniture` CHANGE `interaction_type` `interaction_type` ENUM('default','gate','postit','roomeffect','dimmer','trophy','bed','scoreboard','vendingmachine','alert','onewaygate','loveshuffler','habbowheel','dice','bottle','teleport','rentals','pet','roller','water','ball','bb_red_gate','bb_green_gate','bb_yellow_gate','bb_puck','bb_blue_gate','bb_patch','bb_teleport','blue_score','green_score','red_score','yellow_score','fbgate','tagpole','counter','red_goal','blue_goal','yellow_goal','green_goal','wired','wf_trg_onsay','wf_act_saymsg','wf_trg_enterroom','wf_act_moveuser','wf_act_togglefurni','wf_trg_furnistate','wf_trg_onfurni','pressure_pad','wf_trg_offfurni','wf_trg_gameend','wf_trg_gamestart','wf_trg_timer','wf_act_givepoints','wf_trg_attime','wf_trg_atscore','wf_act_moverotate','rollerskate','stickiepole','wf_xtra_random','wf_cnd_trggrer_on_frn','wf_cnd_furnis_hv_avtrs','wf_act_matchfurni','wf_cnd_has_furni_on','puzzlebox','switch','wf_act_give_phx','wf_cnd_phx','firework','wf_act_kick_user','hopper','jukebox','musicdisc','freeze_tile','freeze_counter','freeze_ice_block','freeze_blue_gate','freeze_red_gate','freeze_green_gate','freeze_yellow_gate','freeze_exit','freeze_blue_score','freeze_red_score','freeze_green_score','freeze_yellow_score','wf_act_reset_timers','wf_cnd_match_snapshot','wf_cnd_time_more_than','wf_cnd_time_less_than') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'default';
ALTER TABLE `furniture` ADD `HeightOverride` ENUM('1', '0') NOT NULL DEFAULT '0';
ALTER TABLE `catalog_items` ADD `song_id` INT(11) NOT NULL;
ALTER TABLE `catalog_items` ADD `BadgeID` VARCHAR(100) NOT NULL DEFAULT '';

 

[Lohex]

Try re-adding the catalogue again and add these columns;

ALTER TABLE `furniture` CHANGE `interaction_type` `interaction_type` ENUM('default','gate','postit','roomeffect','dimmer','trophy','bed','scoreboard','vendingmachine','alert','onewaygate','loveshuffler','habbowheel','dice','bottle','teleport','rentals','pet','roller','water','ball','bb_red_gate','bb_green_gate','bb_yellow_gate','bb_puck','bb_blue_gate','bb_patch','bb_teleport','blue_score','green_score','red_score','yellow_score','fbgate','tagpole','counter','red_goal','blue_goal','yellow_goal','green_goal','wired','wf_trg_onsay','wf_act_saymsg','wf_trg_enterroom','wf_act_moveuser','wf_act_togglefurni','wf_trg_furnistate','wf_trg_onfurni','pressure_pad','wf_trg_offfurni','wf_trg_gameend','wf_trg_gamestart','wf_trg_timer','wf_act_givepoints','wf_trg_attime','wf_trg_atscore','wf_act_moverotate','rollerskate','stickiepole','wf_xtra_random','wf_cnd_trggrer_on_frn','wf_cnd_furnis_hv_avtrs','wf_act_matchfurni','wf_cnd_has_furni_on','puzzlebox','switch','wf_act_give_phx','wf_cnd_phx','firework','wf_act_kick_user','hopper','jukebox','musicdisc','freeze_tile','freeze_counter','freeze_ice_block','freeze_blue_gate','freeze_red_gate','freeze_green_gate','freeze_yellow_gate','freeze_exit','freeze_blue_score','freeze_red_score','freeze_green_score','freeze_yellow_score','wf_act_reset_timers','wf_cnd_match_snapshot','wf_cnd_time_more_than','wf_cnd_time_less_than') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'default';
ALTER TABLE `furniture` ADD `HeightOverride` ENUM('1', '0') NOT NULL DEFAULT '0';
ALTER TABLE `catalog_items` ADD `song_id` INT(11) NOT NULL;
ALTER TABLE `catalog_items` ADD `BadgeID` VARCHAR(100) NOT NULL DEFAULT '';

You're a god... I love you, any graphic design related requests, are on me.

 

[Jerry]

Badges, banners? or something like that.

 

[Lohex]

Badges, banners? or something like that.

I do both

These two are animated lol

 

[Jerry]

Nice.