trying to add Tokyo 2018 furni (plus emu r2)

Status
Not open for further replies.
olliedean

olliedean

ollie.cool
Jan 28, 2013
433
107
Using PlusEMU R2 database
Code: 
INSERT INTO `furniture` VALUES ('10131', 'tokyo_c18_residential', 'tokyo_c18_residential name', 's', '1', '1', '1', '1', '0', '0', '10131', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10132', 'tokyo_c18_toy4', 'tokyo_c18_toy4 name', 's', '1', '1', '1', '1', '0', '0', '10132', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10133', 'tokyo_c18_toy6', 'tokyo_c18_toy6 name', 's', '1', '1', '1', '1', '0', '0', '10133', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10135', 'tokyo_c18_railing', 'tokyo_c18_railing name', 's', '1', '1', '1', '1', '0', '0', '10135', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10136', 'tokyo_c18_retroarcade', 'tokyo_c18_retroarcade name', 's', '1', '1', '1', '1', '0', '0', '10136', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10137', 'tokyo_c18_motorbike', 'tokyo_c18_motorbike name', 's', '1', '1', '1', '1', '0', '0', '10137', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10138', 'tokyo_c18_neonsign2', 'tokyo_c18_neonsign2 name', 's', '1', '1', '1', '1', '0', '0', '10138', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10139', 'tokyo_c18_toy9', 'tokyo_c18_toy9 name', 's', '1', '1', '1', '1', '0', '0', '10139', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10140', 'tokyo_c18_shopdisplay', 'tokyo_c18_shopdisplay name', 's', '1', '1', '1', '1', '0', '0', '10140', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10141', 'tokyo_c18_pole', 'tokyo_c18_pole name', 's', '1', '1', '1', '1', '0', '0', '10141', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10142', 'tokyo_c18_trellis', 'tokyo_c18_trellis name', 's', '1', '1', '1', '1', '0', '0', '10142', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10143', 'tokyo_r18_mapletree', 'tokyo_r18_mapletree name', 's', '1', '1', '1', '1', '0', '0', '10143', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10144', 'tokyo_c18_toy5', 'tokyo_c18_toy5 name', 's', '1', '1', '1', '1', '0', '0', '10144', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10145', 'tokyo_c18_bugsmachine', 'tokyo_c18_bugsmachine name', 's', '1', '1', '1', '1', '0', '0', '10145', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10146', 'tokyo_c18_drinksmachine', 'tokyo_c18_drinksmachine name', 's', '1', '1', '1', '1', '0', '0', '10146', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10147', 'tokyo_c18_gamesign', 'tokyo_c18_gamesign name', 's', '1', '1', '1', '1', '0', '0', '10147', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10148', 'tokyo_c18_adposters', 'tokyo_c18_adposters name', 's', '1', '1', '1', '1', '0', '0', '10148', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10150', 'tokyo_c18_lights', 'tokyo_c18_lights name', 's', '1', '1', '1', '1', '0', '0', '10150', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10151', 'tokyo_c18_snackroof', 'tokyo_c18_snackroof name', 's', '1', '1', '1', '1', '0', '0', '10151', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10152', 'tokyo_c18_toy2', 'tokyo_c18_toy2 name', 's', '1', '1', '1', '1', '0', '0', '10152', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10154', 'tokyo_ltd18_shiba', 'tokyo_ltd18_shiba name', 's', '1', '1', '1', '1', '0', '0', '10154', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10155', 'tokyo_c18_toy1', 'tokyo_c18_toy1 name', 's', '1', '1', '1', '1', '0', '0', '10155', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10156', 'tokyo_c18_road', 'tokyo_c18_road name', 's', '1', '1', '1', '1', '0', '0', '10156', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10157', 'tokyo_c18_scarydino', 'tokyo_c18_scarydino name', 's', '1', '1', '1', '1', '0', '0', '10157', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10158', 'tokyo_c18_jpmerchshop', 'tokyo_c18_jpmerchshop name', 's', '1', '1', '1', '1', '0', '0', '10158', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10159', 'tokyo_c18_floor', 'tokyo_c18_floor name', 's', '1', '1', '1', '1', '0', '0', '10159', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10160', 'tokyo_c18_lanterns', 'tokyo_c18_lanterns name', 's', '1', '1', '1', '1', '0', '0', '10160', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10161', 'tokyo_c18_magazinerack', 'tokyo_c18_magazinerack name', 's', '1', '1', '1', '1', '0', '0', '10161', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10162', 'tokyo_c18_racearcade', 'tokyo_c18_racearcade name', 's', '1', '1', '1', '1', '0', '0', '10162', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10164', 'tokyo_c18_retroarcade2', 'tokyo_c18_retroarcade2 name', 's', '1', '1', '1', '1', '0', '0', '10164', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10166', 'tokyo_c18_snackdisplay', 'tokyo_c18_snackdisplay name', 's', '1', '1', '1', '1', '0', '0', '10166', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10167', 'tokyo_c18_toy10', 'tokyo_c18_toy10 name', 's', '1', '1', '1', '1', '0', '0', '10167', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10168', 'tokyo_c18_toy3', 'tokyo_c18_toy3 name', 's', '1', '1', '1', '1', '0', '0', '10168', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10170', 'tokyo_c18_gacha', 'tokyo_c18_gacha name', 's', '1', '1', '1', '1', '0', '0', '10170', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10171', 'tokyo_c18_toy8', 'tokyo_c18_toy8 name', 's', '1', '1', '1', '1', '0', '0', '10171', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10172', 'tokyo_c18_snackdisplay2', 'tokyo_c18_snackdisplay2 name', 's', '1', '1', '1', '1', '0', '0', '10172', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10185', 'tokyo_c18_toy7', 'tokyo_c18_toy7 name', 's', '1', '1', '1', '1', '0', '0', '10185', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10184', 'tokyo_c18_snackroof2', 'tokyo_c18_snackroof2 name', 's', '1', '1', '1', '1', '0', '0', '10184', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10183', 'tokyo_r18_koikite', 'tokyo_r18_koikite name', 's', '1', '1', '1', '1', '0', '0', '10183', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10181', 'tokyo_c18_bigbillboard', 'tokyo_c18_bigbillboard name', 's', '1', '1', '1', '1', '0', '0', '10181', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10180', 'tokyo_c18_neonsign1', 'tokyo_c18_neonsign1 name', 's', '1', '1', '1', '1', '0', '0', '10180', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10179', 'tokyo_c18_adposters2', 'tokyo_c18_adposters2 name', 's', '1', '1', '1', '1', '0', '0', '10179', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10177', 'tokyo_c18_sakura', 'tokyo_c18_sakura name', 's', '1', '1', '1', '1', '0', '0', '10177', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10175', 'tokyo_c18_shopfront', 'tokyo_c18_shopfront name', 's', '1', '1', '1', '1', '0', '0', '10175', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `furniture` VALUES ('10174', 'tokyo_c18_craftbot', 'tokyo_c18_craftbot name', 's', '1', '1', '1', '1', '0', '0', '10174', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');

You must be registered for see images attach


Any help is appriciated :)
 
nvm fixed.
 
Sort by date Sort by votes
JayC

JayC

Well-Known Member
Aug 8, 2013
5,505
1,401
Use the program I released to generate the data... It will only generate the columns that are needed vs. the released SQL's that are not always the same.
You must be registered for see links
 
Upvote 0 Downvote
olliedean

olliedean

ollie.cool
Jan 28, 2013
433
107
JayCustom said:
Use the program I released to generate the data... It will only generate the columns that are needed vs. the released SQL's that are not always the same.
You must be registered for see links
Click to expand...
Thank you, however, I already fixed the database. Now I am getting another issue with it.
You must be registered for see images attach
 
Upvote 0 Downvote
mxtt

mxtt

playorbit.uk
Nov 29, 2017
47
23
did you change the interaction type from default_type?
did you make sure you added the icons into the swfs?
did you add the swfs?
 
Upvote 0 Downvote
olliedean

olliedean

ollie.cool
Jan 28, 2013
433
107
mxtt said:
did you change the interaction type from default_type?
did you make sure you added the icons into the swfs?
did you add the swfs?
Click to expand...
Yeah, I put all icons in dcr/icons and swfs in dcr
What am I supposed to change the interaction type to? its currently default type.
 
Upvote 0 Downvote
mxtt

mxtt

playorbit.uk
Nov 29, 2017
47
23
interaction should be `default`for most. i cant remember whats in tokyo.
as for the dcr folder, could you show it me?
 
Upvote 0 Downvote
olliedean

olliedean

ollie.cool
Jan 28, 2013
433
107
JayCustom said:
Clear cloudflare + your cache and reload.
Click to expand...
I feel well stupid now :lol: Thanks!
One last thing, half way through importing the furniture SQLs, I encountered duplications. So, I added an extra 1 to the end of the ID for half of them.
I changed the IDs in catalog_items and furni_data to correspond with them, but they still dont show.
Thanks again, hope you can help! :)

You must be registered for see images attach
 
Upvote 0 Downvote
Pinkman

Pinkman

Posting Freak
Jul 27, 2016
818
194
Zent said:
I feel well stupid now :lol: Thanks!
One last thing, half way through importing the furniture SQLs, I encountered duplications. So, I added an extra 1 to the end of the ID for half of them.
I changed the IDs in catalog_items and furni_data to correspond with them, but they still dont show.
Thanks again, hope you can help! :)

You must be registered for see images attach
Click to expand...
Same thing, purge cloud flare and clear cache.
 
Upvote 0 Downvote
Status
Not open for further replies.

Users who are viewing this thread

Total: 2 (members: 0, guests: 2)
☀️  Switch to Light Theme

Latest posts

Top