Jump to content

TzingTzongPing

Members
  • Posts

    21
  • Joined

  • Last visited

  • Days Won

    1

TzingTzongPing last won the day on February 20 2017

TzingTzongPing had the most liked content!

Recent Profile Visitors

1832 profile views

TzingTzongPing's Achievements

Newbie

Newbie (1/14)

  • First Post Rare
  • Collaborator Rare
  • Conversation Starter Rare
  • Week One Done Rare
  • One Month Later Rare

Recent Badges

5

Reputation

  1. Am inteles. O sa incerc totusi cu ceva programe gen : https://www.easeus.com/ad/data-recovery-wizard.htm poate reusesc sa recuperez ceva mai recent, trebuie sa fie undeva pe HD ceva ramas.
  2. Salut, Au backup dar sunt mai vechi, de duminica, vroiam sa recuperez cel mai recent backup. Este o frima din Australia si au multe date. Pot face file system restoring de pe HD? sunt si Windows VDI, trebuie neaparat sa recuperez aceste data, bagamias picioarele in iei de Rusi cu ransomeware lor. este vorba de ALPHV Blackcat, nu pot gasii nici pe deep web un decryptor ?
  3. Salut, am un client care a luat ransomware pe doua servere SQL, extensia ransomware este .ohkmdo3 si nu pot gasii pe internet nimic pentru a decrypta fisierele. Ma poate ajuta cineva cu o sugestie, un program orice. Platesc daca este nevoie! Din cate am observat cred ca este ransomware BlackCat " Important files on your network was ENCRYPTED and now they have "ohkmdo3" extension. In order to recover your files you need to follow instructions below. >> Sensitive Data Sensitive data on your network was DOWNLOADED. If you DON'T WANT your sensitive data to be PUBLISHED you have to act quickly. Data includes: - Employees personal data, CVs, DL, SSN. - Complete network map including credentials for local and remote services. - Private financial information including: clients data, bills, budgets, annual reports, bank statements. - Manufacturing documents including: datagrams, schemas, drawings in solidworks format - And more... Samples are available on your User Panel. >> CAUTION DO NOT MODIFY ENCRYPTED FILES YOURSELF. DO NOT USE THIRD PARTY SOFTWARE TO RESTORE YOUR DATA. YOU MAY DAMAGE YOUR FILES, IT WILL RESULT IN PERMANENT DATA LOSS. >> What should I do next?" Multumesc
  4. Am facut si asta, am si tabel attributes si attribute_id in variables exact ca aici https://stackoverflow.com/q/19333652, dar nu inteleg diferenta intre variable_type si doar variable SELECT `p`.`id`, `p`.`title` FROM `e_products` `p` WHERE `p`.`id` IN (SELECT `ae`.`product_id` FROM `e_products_attributes` `ae` INNER JOIN `e_attributes` `a` ON `ae`.`attribute_id`=`a`.`id` INNER JOIN `e_attributes_options` `av` ON `ae`.`variables`=`av`.`value` WHERE ((`a`.`code`='brands' AND `av`.`value`='306') OR (`a`.`code`='tvs_size' AND `av`.`value`='411')) HAVING COUNT(*) >= 2 ); Dar imi afiseaza doar 1 singur produs in cazul de fata doar primul produs cu brand attribute 306
  5. Ai avut perfecta dreptate, query functioneaza doar ca afiseaza toate produsele care au macar 1 attribute din WHERE variable IN, eu am nevoie daca selectez "samsung (attribute 41)", philips (attribute 2), si 22 inch (attribute 4) sa afiseze doar samsung si philips care au 22 inch, acuma din pacate afiseaza toate produsele samsung, philips si nu filtreaza pe 22 inch. Am incercat asta https://stackoverflow.com/a/15900486 dar afiseaza doar samsung si 22 inch daca selectez si philips numai afiseaza nimic. Am incercat si asta https://stackoverflow.com/a/19333809 dar imi afiseaza doar 1 singur produs daca selectez samsung si philips, iar daca selectez toate 3 iar nu afiseaza nimic.
  6. Am inteles Am facut asa numai ca imi da o eroare [2019-01-29 16:54:31] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 (SQL: SELECT * FROM e_products WHERE id IN (SELECT product_id FROM e_product_attributes WHERE variable IN (306,163,259)) $objects = DB::select('SELECT * FROM e_products WHERE id IN (SELECT product_id FROM e_products_attributes WHERE variable IN ('.$list.')) ');
  7. Fac join la e_products_attributes , pentru ca, coloana variables nu se afla in e_products.
  8. Daca sterg "group by" numai da nimic, o sa folosesc eloquent dar prima data trebuie sa gasesc query correct, inca nu am reusit sa gasesc solutia
  9. Salut, incerc sa fac un filter pentru produse in laravel, si m-am blocat la partea cu sql. Tabel e_products `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL .. Tabel e_products_attributes `id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL `variable` int(11) NOT NULL Tabel e_attributes `id` int(11) NOT NULL auto_increment, `variable` int(11) NOT NULL `label` varchar(255) NOT NULL PHP $variables = array(41, 2, 4, 6); $rr = count($variables); $list = implode(',', $variables); $objects = DB::select('SELECT o.id, o.title, o.slug, o.images_host, o.regular_price FROM e_products o INNER JOIN e_products_attributes oa ON o.id = oa.product_id AND oa.variable IN ('.$list.') GROUP BY o.id HAVING COUNT(oa.variable) >= '.$rr); variable 41 = Samsung variable 2 = Philips variable 4 = 22 inch variable 6 = 24 inch Problema este in felul urmator: Daca in $list se afla variable 41,6 rezultatele sunt corecte, dar daca selectez doar 41,2 imi da rezultate 0, cea ce nu pot sa inteleg este faptul ca fiecare attribute are un id dar filtreaza doar brand si inch. e_products_attributes arata cam asa: id product_id variable 1 400 41 2 400 6 3 450 41 4 451 2 Deci daca selectez variable 41 trebuie sa afiseze toate produsele cu acest attribute, dar daca selectez 41,6 trebuie sa afiseze doar product_id 400 Stie cineva unde gresesc ? Multumesc
  10. Revin cu problema mea, totusi am nevoie sa trec de acest captcha pe site-ul respectiv, m-am gandit sa setez cookie generat de la captcha in curl si sa fac post cu el, dar tot imi da eroare codul nu este correct. am asa: $url="http://www.11183.com.cn/ems/order/singleQuery_t"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,$url); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_HTTPHEADER, array("Cookie: Hm_lpvt_da6f1445af3167cf70ef00845d0e716b=1526109956")); curl_setopt($ch, CURLOPT_POSTFIELDS, "mailNum=LZ33183--603CN&checkCode=496661"); Unde: Hm_lpvt_da6f1445af3167cf70ef00845d0e716b=1526109956 ==== (checkCode) 496661
  11. Pfff, cu site-ul ala mai rezolvat, api nu imi este de folos deoarece pot face tracking doar la codurile introduse in baza lor de date, dar m-am folosit de asta https://track.aftership.com/ . Prin curl am extras exact ce trebuie. Mersi mult!
  12. Salutari, am nevoie daca ma poate ajuta cineva cu un cod PHP, vreau sa extrag cu, CURL rezultatele unui form de pe site-ul http://ems.com.cn/english.html (Shippment number pentru test: LZ310505783CN), problema este ca acest form are si captcha ems.com.cn/ems/rand si nu stiu cum pot trece de captcha. Sau alta varianta daca pot folosi captcha generat si sa fac curl cu aceasi sesiune. Request URL: http://ems.com.cn/ems/order/singleQuery_t Request Method: POST Status Code: 200 OK Remote Address: Referrer Policy: no-referrer-when-downgrade POST /ems/order/singleQuery_t HTTP/1.1 Host: ems.com.cn Connection: keep-alive Content-Length: 38 Pragma: no-cache Cache-Control: no-cache Origin: http://ems.com.cn Upgrade-Insecure-Requests: 1 Content-Type: application/x-www-form-urlencoded User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.139 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Referer: http://ems.com.cn/index.html Accept-Encoding: gzip, deflate Accept-Language: en-US,en;q=0.9 mailNum=LZ310505783CN&checkCode=614806 Platesc daca este nevoie. Multumesc.
  13. Salut, cunosc comunitatea de ceva ani si ma bucur ca inca este online. Lucrez ca programator web la propia firma. Nu sunt aici pentru a afla cum sa spargi site-uri sau alte chestii de genu, ma intereseaza strict partea de securitate al aplicatilor web si in general tot ce tine de programare. Sper sa gasesc informatii utile pe forum si la randul meu sa pot ajuta comunitatea cu informatii legate de programare. Chiar daca lucrez ca programator nu ma consider expert, intodeauna este loc pentru a invata ceva nou. PS: imi cer scuze pentru eventuale greseli de ortografie, cei mai multi ani i-am trait in alta tara. O zi buna!
×
×
  • Create New...