CyberX

mobile

RevolveR CMS v.1.3.2 release

I proveide some critical fixes for RevolveR CMS in update numbered 1.3.2.

  • SEO Titles for forum fixed
  • SEO description for forum module fixed
  • Also fixed seo link canonical for forum pages
  • Impruved date showing for conversations
  • Fixed pathways maskng for anti hacking and spamming routes.
  • Improved security
  • Not all test passed on 100% because I have no time for it.

E-commerce shop module development planed on winter of 2019. Next I will have more time to process theming development.

Good news! Whiothout external links we have to get 10 of X index by Yandex Search engine thats talking about quality of RevolveR CMS.

Also I was open some forum boards where you can talk about RevolveR CMS additions you want and issues thats you find.

RR_CMS v.1.3.2 download

Devel pause for a winter

Shit happens with me and I have to take a development pause. My flat is plundered and my documents such as passport and other docs are lost. I have no telephone for now and need to decide some actual sings and put some things in order.

I hate Russia. I hate this rotten system with stupid police and thieves in their ranks.

After 30 days I can get new passport and I need some more time to recovery my other documents and personality.

So. I'm fed up with this shit and intend to get out of the country. Putin is a thief and a fag. I no longer want any links with this thievish government. I'm disappointed in how these people put us out, those who are working beyond their system idiots and psychos, how they used our connections and heaped themselves on retirement.

Maybe I have a chance to tell about this shit somewhere outside of Russia and people will learn how these creatures live and work to maintain their reputation.

RevolveR CMS v1.3.1 update and hacking test

Three weeks ago I create topic on hackers community with sentence to hack RevolveR CMS. Every day I was check logs and look at statistics page where possible to see requests and user activity.

Good news! Hats loose. No one XSS and SQL injection have a luck with RevolveR CMS. Every day I see how spammers try to push post data in forms but all of it have no luck to. System stay unhackable because for example no one shell code will never executed and can't be uploaded because this system have hard policy with executable files. Only one file(index.php) and some service additions can be executed with RevolveR CMS. This clever routing mechanism not substituted no one time.

So. Version 1.3.1 update contains forum detalization improvements. Now we have total stats render and can see latest message in boards conversations.

For next release I should add breadcrumbs and topic movements over boards.

How to rename database after Maria DB dump success

There are some ugly solutions for database management like Maria DB thats won't recover your mysql dump correct. For example it will ignore path where you want to write dump and change database randomly.

Fortunately, we have a terminal command to rebase tables:


mysql -uroot -proot misatkeDB -sNe 'show tables' | while read table; 
do mysql -uroot -proot -sNe "RENAME TABLE misatakeDB.$table TO target.$table"; 
done

You have to change user and password and wait for some minutes to accomplish.

How to check MySQL database size

Some times, when we use not standard solutions for database management like Maria DB, we have not any solutions with GUI to see some information such as Data Bases size allocated on drive and we you need to know some special and useful commands.

For example with next code we can see how many size of Data Base are busy on drive.


SELECT table_schema "*", 
ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema;

Code bellow after execution show detail information about Data Bases size.