Jump to content
Nytro

Modificari forum

Recommended Posts

Vreau doar sa existe un topic in care sa postam daca modificam cate ceva la forum.

De exemplu, azi:

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

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

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

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

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

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

Link to comment
Share on other sites

Say what?/:)

structura bazei de date se poate inbunatati,

din mysql> update user set ipaddress = '1.3.3.7'; reiese ca ipaddress e stocat ca si un sir de caractere, cu functia ip2long poate fi transformat intr-un tip numeric.

Vezi in manualul mysql diferenta de performanta intre cele doua.

Link to comment
Share on other sites

O sa ii dau in judecata pe cei de la vBulletin ca nu au folosit INT.

Bine, ca prezinta alte avantaje folosirea sirurilor, pentru cautare mai simpla in functie de clasa de IP-uri de exemplu, e altceva.

Nu va mai abateti de la subiect. Urmeaza warn-uri.

Link to comment
Share on other sites

Cred ca vom face asta la perioade regulate:


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

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

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

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

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

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

Link to comment
Share on other sites

Nytro, am si eu un question. Daca se face in mod repetat aceasta actiune, cum ramane cu urmatorul paragraf din regulament (si cel mai important totodata).

Toleran?? 0 pentru fraud? sau informa?ii ce faciliteaz? frauda online sau bancar?. Inclusiv mesajele private. (Skimming, CC, Orange, Craiglist, Okazii, programe de adunat emailuri de pe siteurile de licita?ii). Regula aceasta este cel mai strict respectat?, iar datele voastre vor fi oferite ca pe tav? organelor competente, dac? ni se va cere acest lucru.

Later edit: Got it. Mersi de raspuns

Edited by Zatarra
Link to comment
Share on other sites

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

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

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

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

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

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

Link to comment
Share on other sites

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

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

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

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

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

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

Stay safe!

Link to comment
Share on other sites

@Nytro

Daca tot vine vorba de modificari ...

Pagina de resetare a parolei considera emailul meu este invalid drept urmare nu mai pot reseta pass daca vreau.(prin pagina de resetare)

Ar fi o idee buna sa fie adaugat si hiperline-ul ca fiind valid, eu am emailul aici: "azrael-sub7@satanic.ro" si probabil e considerat invalid din din cauza caracterului "-", daca are cineva timp poate se uita in codul de validare ...

Am reusit sa ma loghez doar pentru ca aveam parola veche de la ultima resetare care am facut-o "3/31/2011 2:02 AM" atunci cand emailul era considerat valid ...

Multumesc anticipat ...

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...