Jump to content
Nytro

Modificari forum

Recommended Posts

Am scos suportul pentru SSLv3. Pentru ca POODLE.

[root@rstforums ~]# openssl s_client -ssl3 -connect rstforums.com:443

CONNECTED(00000003)

139739852810056:error:14094410:SSL routines:SSL3_READ_BYTES:sslv3 alert handshake failure:s3_pkt.c:1257:SSL alert number 40

139739852810056:error:1409E0E5:SSL routines:SSL3_WRITE_BYTES:ssl handshake failure:s3_pkt.c:596:

Link to comment
Share on other sites

./clean

mysql> update user set ipaddress = '1.3.3.7';
Query OK, 13524 rows affected (1.05 sec)
Rows matched: 155388 Changed: 13524 Warnings: 0

mysql> update post set ipaddress = '1.3.3.7';
Query OK, 34896 rows affected (3.06 sec)
Rows matched: 541605 Changed: 34896 Warnings: 0

mysql> update adminlog set ipaddress='1.3.3.7';
Query OK, 11391 rows affected (0.26 sec)
Rows matched: 106349 Changed: 11391 Warnings: 0

mysql> update moderatorlog set ipaddress='1.3.3.7';
Query OK, 6381 rows affected (0.08 sec)
Rows matched: 20724 Changed: 6381 Warnings: 0

mysql> update searchlog set ipaddress='1.3.3.7';
Query OK, 153 rows affected (0.01 sec)
Rows matched: 153 Changed: 153 Warnings: 0

mysql> update threadrate set ipaddress='1.3.3.7';
Query OK, 779 rows affected (0.01 sec)
Rows matched: 6753 Changed: 779 Warnings: 0

mysql> update visitormessage set ipaddress='1.3.3.7';
Query OK, 5504 rows affected, 5504 warnings (0.06 sec)
Rows matched: 5504 Changed: 5504 Warnings: 5504

Link to comment
Share on other sites

mysql> update user set ipaddress = '1.3.3.7';
Query OK, 4187 rows affected (0.87 sec)
Rows matched: 159575 Changed: 4187 Warnings: 0

mysql> update post set ipaddress = '1.3.3.7';
Query OK, 10326 rows affected (1.96 sec)
Rows matched: 551922 Changed: 10326 Warnings: 0

mysql> update adminlog set ipaddress='1.3.3.7';
Query OK, 1031 rows affected (0.22 sec)
Rows matched: 107380 Changed: 1031 Warnings: 0

mysql> update moderatorlog set ipaddress='1.3.3.7';
Query OK, 811 rows affected (0.06 sec)
Rows matched: 21535 Changed: 811 Warnings: 0

mysql> update searchlog set ipaddress='1.3.3.7';
Query OK, 163 rows affected (0.02 sec)
Rows matched: 163 Changed: 163 Warnings: 0

mysql> update threadrate set ipaddress='1.3.3.7';
Query OK, 239 rows affected (0.01 sec)
Rows matched: 6992 Changed: 239 Warnings: 0

mysql> update visitormessage set ipaddress='1.3.3.7';
Query OK, 129 rows affected, 5623 warnings (0.02 sec)
Rows matched: 5623 Changed: 129 Warnings: 5623

Link to comment
Share on other sites

Optimizare SQL:

mysql> DELETE from vbseo_likes;

Query OK, 126509 rows affected (0.01 sec)

mysql> delete FROM dbtech_usertag_mention;

Query OK, 5621 rows affected (0.01 sec)

mysql> delete FROM dbtech_usertag_tag;

Query OK, 35 rows affected (0.01 sec)

mysql> delete FROM dbtech_usertag_quote;

Query OK, 12073 rows affected (0.00 sec)

Sunt prost facute modulele astea jegoase si se incarcau foarte greu anumite pagini.

Nu va plangeti ca niste pizde pe Facebook ca nu mai aveti like-uri ca primiti ban. Functionalitatea like-urilor exista pentru a evita posturi inutile. Multumesc pentru intelegere.

Edited by Nytro
Link to comment
Share on other sites

E de la vbSEO, chiar nu am chef sa ma uit prin codul lor...

31337 people choose alphanumeric usernames, like a restricted shellcode.

Daca cumva o sa am timp o sa vad daca se poate fixa intr-un mod simplu, daca nu, cine are username cu diverse caractere si are aceasta problema, imi da PM si modificam username-ul in ceva asemanator fara acele caractere.

Link to comment
Share on other sites

Optimizare SQL:

mysql> DELETE from vbseo_likes;

Query OK, 126509 rows affected (0.01 sec)

mysql> delete FROM dbtech_usertag_mention;

Query OK, 5621 rows affected (0.01 sec)

mysql> delete FROM dbtech_usertag_tag;

Query OK, 35 rows affected (0.01 sec)

mysql> delete FROM dbtech_usertag_quote;

Query OK, 12073 rows affected (0.00 sec)

Sunt prost facute modulele astea jegoase si se incarcau foarte greu anumite pagini.

Nu va plangeti ca niste pizde pe Facebook ca nu mai aveti like-uri ca primiti ban. Functionalitatea like-urilor exista pentru a evita posturi inutile. Multumesc pentru intelegere.

Propun si: DELETE FROM thread WHERE postuserid='55944';

Link to comment
Share on other sites

Propun sa va intereseze propriile voastre posturi. Daca in vreun moment se va considera ca posturile lui sunt inutile, sau fac rau forumului, atunci se vor sterge/sanctiona. Pana una alta, chiar si copy paste, sunt utile, pentru ca ajuta utilizatorii sa ajunga la informatii la care inainte nu ar fi putut ajunge(deoarece nu cunosteau sursa). Asa ca incetati sa va mai faceti griji pentru ce face cel de langa, indiferent ca face bine sau rau.

Cand se face ceva rau, aveti butonul de raport.

  • Upvote 1
Link to comment
Share on other sites

Raspunsul StartCom Ltd. la problema cu certificatul:

"Due to a technical issue the OCSP responders failed to update - they are syncing again and this issue should resolve itself within the next few hours if it haven't already."

Asadar, in curand ar trebui sa fie totul in regula.

Link to comment
Share on other sites

Vedeti ca este o problema la pluginul asta de SEO care l-a bagat Nytro. Nu redirectioneaza bine catre unele profiluri,spre exemplu daca vreau sa vad profilul lui diesel. ma duce spre profilul cu numele diesel(fara punct) plus mai este un profil al unui utilizator pe nume qps1 care nu se incarca deloc.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...