Search
Modify the database
Hello,
I am changing the url of my site netyzz.com by netizz.com, so I think I should modify all the data corresponding to the word netyzz in my database.
I would like to know if there is any solution to modify this... moreHello,
I am changing the url of my site netyzz.com by netizz.com, so I think I should modify all the data corresponding to the word netyzz in my database.
I would like to know if there is any solution to modify this fastly.
And if not, or if it's too complicated to realize without any knowledge, I want to know if data in the table "engine4_core_referrers" is important because I have a lot of data with the word Netyzz here in this table. If it's not useful at all, I could erase all data here.
Modify the database
Hello,
I am changing the url of my site netyzz.com by netizz.com, so I think I should modify all the data corresponding to the word netyzz in my database.
I would like to know if there is any solution to modify this... moreHello,
I am changing the url of my site netyzz.com by netizz.com, so I think I should modify all the data corresponding to the word netyzz in my database.
I would like to know if there is any solution to modify this fastly.
And if not, or if it's too complicated to realize without any knowledge, I want to know if data in the table "engine4_core_referrers" is important because I have a lot of data with the word Netyzz here in this table. If it's not useful at all, I could erase all data here.
Storage: record image dimensions in database
It would be great if we were able to store uploaded image's height and width in database and display it in view scripts. For example in "engine4_storage_files" table have 2 columns for "width" and "height" in pixels, and populate it for the files of... moreIt would be great if we were able to store uploaded image's height and width in database and display it in view scripts. For example in "engine4_storage_files" table have 2 columns for "width" and "height" in pixels, and populate it for the files of type that have dimensions.
I have came across many things that require photo dimensions, some examples are:
JavaScript gallery sliders: most of them with advanced features require photo dimensions to function correctly. (ex. PhotoSwipe).
OpenGraph: It's recommended to supply image dimensions together with "og:image" tag.
I'm sure if I think about it the list will go on.
For now I'm using php functions to open the image and extract dimensions information, but this is very inefficient and takes about .3 seconds per each image.
Now I may be wrong but I don't think this can be done using a module or something like that as it's a core change. Also the script already checks image dimensions for resizing etc. so I don't think it will even take any... less
Storage: record image dimensions in database
It would be great if we were able to store uploaded image's height and width in database and display it in view scripts. For example in "engine4_storage_files" table have 2 columns for "width" and "height" in pixels, and populate it for the files of... moreIt would be great if we were able to store uploaded image's height and width in database and display it in view scripts. For example in "engine4_storage_files" table have 2 columns for "width" and "height" in pixels, and populate it for the files of type that have dimensions.
I have came across many things that require photo dimensions, some examples are:
JavaScript gallery sliders: most of them with advanced features require photo dimensions to function correctly. (ex. PhotoSwipe).
OpenGraph: It's recommended to supply image dimensions together with "og:image" tag.
I'm sure if I think about it the list will go on.
For now I'm using php functions to open the image and extract dimensions information, but this is very inefficient and takes about .3 seconds per each image.
Now I may be wrong but I don't think this can be done using a module or something like that as it's a core change. Also the script already checks image dimensions for resizing etc. so I don't think it will even take any... less
Empty table "engine4_core_session"
I suggest backing up the database and trying it on a development site. I've never tried it. Be careful the sites you go on as there are unsafe sites out there. Sites with nulled products are pirate sites and contain hackers, malware and other bad things.
How to Create a Development Environment
How to backup files and MySQL database (this is what your entire SE site is made out of, for those who may not know)
Before installing any 3rd party plugins (because I expect it to mess up my styling in some way), I do a complete backup of my files and... moreHow to backup files and MySQL database (this is what your entire SE site is made out of, for those who may not know)
Before installing any 3rd party plugins (because I expect it to mess up my styling in some way), I do a complete backup of my files and database. When a plugin changed my site to something unusable, I just delete the entire site and restore my backups (which, to my delight, is just the files and the database.)
Backup Files
Go to Cpanel
Click on File Manager
Click on public_html folder
Go to Settings (upper right corner) and make sure Show Hidden Files (dotfiles) is checked. If not, check it.
Click Select All (all files and folders in your public_html should be selected.)
Click Compress
Select Zip archive
Click Compress File(s)
...wait a while
Name your zip file (which will show up in the public_html folder) and download/move it to a backup location of your choice.
Backup database
Go to Cpanel
Click on phpMyAdmin
Click on the database associated with your SE... less