solved where are my custom smileys stored?

Strumelia
Strumelia
@strumelia
9 years ago
3,605 posts
Over time, I've added over 100 custom smileys (mostly .gif files) to my site, via the jrSmiley module. (my members LOVE their smileys)
I'm making a second site. I cloned my 1st site to a new domain on my jr server, then 'reset' it to create a new site with the same settings as my 1st site but emptied of members and member content. Thus, the smiley gifs are no longer there. I installed the small set of 6 or so default JR smileys fresh, which i can see in the default smiley folder in the Smiley Module folder, on my server when i look at my server contents in Filezilla. But I can't seem to find the 'motherlode' of my custom smileys on my JR server- did a 'search' and all.
1) WHERE do my custom smileys get stored on my JR server?
2) And do I have to add them to my new site one by one?...150 of them...is there no way to duplicate/import them in a quick way from my 1st site to my 2nd site?


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

updated by @strumelia: 01/21/17 07:08:53PM
michael
@michael
9 years ago
7,806 posts
Smiley images are stored at:
/data/media/0/0/jrSmiley_1_smiley_image.png

In the filesystem. So copy those over to the new site.

There is this that will import an existing site into a new domain:

Docs: "Importing an Existing Jamroom Site into a Domain"
https://www.jamroom.net/the-jamroom-network/documentation/jamroom-hosting/2547/importing-an-existing-jamroom-site-to-a-domain

But that will bring the whole thing, and you probably JUST want the smileys.

So you can go to
ACP -> MODULES -> DEVELOPER -> DEVELOPER TOOLS -> TOOLS -> DATABASE ADMIN

* In the top left hand corner you will see "Export" button, click it.
* change the top row from "open" to "save"
* click the very top most checkbox next to TABLES and again next to DATA. (that will un-select all the database tables.)
* now scroll down until you find:
jr_jrsmiley_item
jr_jrsmiley_item_key
* check the checkboxes to for both of those for TABLE and DATA. (total 4 checkboxes checked)

* scroll back to the top and click EXPORT

--
Save the file to a location where you know where it is.

--
Now we want to IMPORT that file into the database of the new site. So follow the directons above to get to the DATABASE ADMIN section for the site where you copied all the smileys to. We're now going to import that file.

* click on the IMPORT button in the top left hand corner.
* click on BROWSE
* navigate to that file and select it
* click on EXECUTE.

That should be it. run the integrity check on the new site and clear the caches.
Strumelia
Strumelia
@strumelia
9 years ago
3,605 posts
Ok I will do this then report back here- it sounds very cool, like moving bookmarks to another browser. Good practice for me to do something like this in the Database Admin area. (You were right in that I didn't want to import the whole site over- already had done that and have since done a bunch of customizing...so yes, just needed to import the smileys.)
thanks Michael!


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

updated by @strumelia: 10/23/16 09:56:57AM
Strumelia
Strumelia
@strumelia
9 years ago
3,605 posts
Micheal, I did all this and it worked like a charm. Thank you so much!! Having about 180 smileys, this saved me a chunk of tedious one-by-one work adding them to my new site. :D I'll mark this thread Solved.


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015
michael
@michael
9 years ago
7,806 posts
You are getting Awesome at Jamroom. Well done.