uuid UUID_TO_BIN BIN_TO_UUID mysql 8 ordered by default bbackport for mysql 5.6 and 5.7 amazon aws compatible

uuid UUID_TO_BIN BIN_TO_UUID mysql 8 ordered by default bbackport for mysql 5.6 and 5.7 amazon aws compatible CREATE FUNCTION UUID_TO_BIN(_uuid BINARY(36)) RETURNS BINARY(16) LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY INVOKER RETURN UNHEX(CONCAT( SUBSTR(_uuid, 15, 4), SUBSTR(_uuid, 10, 4), SUBSTR(_uuid, 1, 8), SUBSTR(_uuid, 20, 4), SUBSTR(_uuid, 25) )); CREATE FUNCTION BIN_TO_UUID(_bin BINARY(16)) RETURNS BINARY(36) LANGUAGE… Continue reading uuid UUID_TO_BIN BIN_TO_UUID mysql 8 ordered by default bbackport for mysql 5.6 and 5.7 amazon aws compatible

Published
Categorized as General

iptables reset on reboot linux centos

here is the fix IPTABLES_SAVE_ON_RESTART=”yes” IPTABLES_SAVE_ON_STOP=”yes” in /etc/sysconfig/iptables-config 3. service iptables save chkconfig iptables on

Published
Categorized as General

كيف واجهت روسيا فيروس الفدية wannacry الذي ارعب العالم !

ان فيروس الفدية الذي انتشر مؤخرا قد أرعب العالم خاصة بعد الاضرار التي سببها لمجموعة من القطاعات والشركات ، ووقف العمل في بعضها لايام . لكن لكل دولة طريقة مواجهة هذه التهديدات التي لن تنتهي ، لكن ما الذي فعلت روسيا لمواجهة فيروس الفدية الاخير ؟ قامت روسيا بامر اغرب من الخيال هل لك ان… Continue reading كيف واجهت روسيا فيروس الفدية wannacry الذي ارعب العالم !

Published
Categorized as General

الهاتف الجوال اصلي ام تقليد

لمعرفة الاصلي من دون الاصلي من خلال  التليفون اتصل بالرقم التالي *#06# راح يطلع رقمين IMEI SN ادخل الموقع ده وافحص http://www.imei.info/ دخل الرقم IMEI بعدها يظهرلك معلومات الجهاز بعدين اضغط علي Waranty Check دخل السيريال SN راح يطلع لك معلومات الضمان لاتنساني من دعوه صالحه

Published
Categorized as General

php storm portable

Yes, it’s possible, just copy the installation directory to the flash drive, then edit IDEA_HOME\bin\idea.properties file, change the values of idea.config.path and idea.plugins.path to the relative location, like: ../config and ../user-plugins (locations are relative to IDEA bin directory). Now copy your original settings and third-party plug-ins (if any): ${user.home}/.IntelliJIdea10/config => usb:/IDEA_HOME/config ${user.home}/.IntelliJIdea10/config/plugins => usb:/IDEA_HOME/user-plugins Note… Continue reading php storm portable

Published
Categorized as General

Cpanel Commands ssh

Install cpanel cd /home && curl -o latest -L https://securedownloads.cpanel.net/latest && sh latest backup one user account /scripts/pkgacct USERNAME Force Cpanel backup run for all users /scripts/cpbackup –force  

Complete File Upload Vulnerabilities

Allowing an end user to upload files to your website is like opening another door for a malicious user to compromise your server. However, uploading files is a necessity for any web application with advanced functionality. Whether it is a social networking site like Facebook and Twitter, or an intranet document sharing portal, web forums… Continue reading Complete File Upload Vulnerabilities

Published
Categorized as General

install new cpanel centos vm xen server from local repos

first this is the iso http://httpupdate.cpanel.net/cPanel-CentOS-6.4-x86_64.iso always get lattest from this url http://httpupdate.cpanel.net/ ok lets start log in to the host server ssh [php] cd / mkdir /isolib wget http://httpupdate.cpanel.net/cPanel-CentOS-6.4-x86_64.iso xe sr-create name-label=isolib type=iso device-config:legacy_mode=true device-config:location=/isolib content-type=iso [/php] finished then go create virtual vm and install centos if any question comment me

Published
Categorized as General

MySQL Pivot dynamic table columns

[php]SET @sql = NULL; SELECT GROUP_CONCAT(DISTINCT CONCAT( ‘MAX(IF(pa.meta_name = ”’, meta_name, ”’, "pa.meta_value", NULL)) AS ‘, meta_name ) ) INTO @sql FROM post_meta; SET @sql = CONCAT(‘SELECT p.id , p.name , p.type, ‘, @sql, ‘ FROM post p LEFT JOIN post_meta AS pa ON p.id = pa.post_id GROUP BY p.id’); PREPARE stmt FROM @sql; EXECUTE… Continue reading MySQL Pivot dynamic table columns

Published
Categorized as General