Nytro Posted January 4, 2013 Report Share Posted January 4, 2013 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: 0mysql> update post set ipaddress = '1.3.3.7';Query OK, 0 rows affected (0.78 sec)Rows matched: 393377 Changed: 0 Warnings: 0mysql> update adminlog set ipaddress='1.3.3.7';Query OK, 71678 rows affected (0.34 sec)Rows matched: 71678 Changed: 71678 Warnings: 0mysql> update moderatorlog set ipaddress='1.3.3.7';Query OK, 585 rows affected (0.01 sec)Rows matched: 590 Changed: 585 Warnings: 0mysql> update searchlog set ipaddress='1.3.3.7';Query OK, 213 rows affected (0.02 sec)Rows matched: 213 Changed: 213 Warnings: 0mysql> update threadrate set ipaddress='1.3.3.7';Query OK, 3322 rows affected (0.01 sec)Rows matched: 3322 Changed: 3322 Warnings: 0 Quote Link to comment Share on other sites More sharing options...
Nytro Posted January 8, 2013 Author Report Share Posted January 8, 2013 Informativ, avem un nou moderator: B7ackAnge7zhttps://rstforums.com/forum/showgroups.php Quote Link to comment Share on other sites More sharing options...
caii Posted January 8, 2013 Report Share Posted January 8, 2013 O sugestie.Puteti updata din ipaddress VARCHAR(16) in UNSIGNED INT(10) si folositi ip2long($_SERVER['REMOTE_ADDR']) pentru adresa ip. Quote Link to comment Share on other sites More sharing options...
AlStar Posted January 8, 2013 Report Share Posted January 8, 2013 O sugestie.Puteti updata din ipaddress VARCHAR(16) in UNSIGNED INT(10) si folositi ip2long($_SERVER['REMOTE_ADDR']) pentru adresa ip.Say what? Quote Link to comment Share on other sites More sharing options...
Nytro Posted January 8, 2013 Author Report Share Posted January 8, 2013 Dati-mi o lista cu nume_tabel:coloana_ip si le sterg si de acolo. Quote Link to comment Share on other sites More sharing options...
caii Posted January 8, 2013 Report Share Posted January 8, 2013 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. Quote Link to comment Share on other sites More sharing options...
Nytro Posted January 8, 2013 Author Report Share Posted January 8, 2013 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. Quote Link to comment Share on other sites More sharing options...
Nytro Posted January 10, 2013 Author Report Share Posted January 10, 2013 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: 0mysql> update post set ipaddress = '1.3.3.7';Query OK, 1769 rows affected (0.87 sec)Rows matched: 395146 Changed: 1769 Warnings: 0mysql> update adminlog set ipaddress='1.3.3.7';Query OK, 285 rows affected (0.11 sec)Rows matched: 71963 Changed: 285 Warnings: 0mysql> update moderatorlog set ipaddress='1.3.3.7';Query OK, 103 rows affected (0.01 sec)Rows matched: 693 Changed: 103 Warnings: 0mysql> update searchlog set ipaddress='1.3.3.7';Query OK, 91 rows affected (0.01 sec)Rows matched: 91 Changed: 91 Warnings: 0mysql> update threadrate set ipaddress='1.3.3.7';Query OK, 45 rows affected (0.00 sec)Rows matched: 3367 Changed: 45 Warnings: 0 Quote Link to comment Share on other sites More sharing options...
Zatarra Posted January 10, 2013 Report Share Posted January 10, 2013 (edited) 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 January 10, 2013 by Zatarra Quote Link to comment Share on other sites More sharing options...
Nytro Posted January 10, 2013 Author Report Share Posted January 10, 2013 Vom reincepe "campania" de depistare a persoanelor care se ocupa cu asa ceva.Si cand ii descoperim, ii putem "nota" undeva, impreuna cu IP-urile. Quote Link to comment Share on other sites More sharing options...
B3st Posted January 10, 2013 Report Share Posted January 10, 2013 @NytroDe ce nu faci un cron job cu acele comenzi mysql, sa nu mai executi mereu manual.Sau poti mai simplu, sa modifici vbulletin ul pe partea de ip-get si sa-i dai valoarea dorita Quote Link to comment Share on other sites More sharing options...
Nytro Posted January 23, 2013 Author Report Share Posted January 23, 2013 mysql> update user set ipaddress = '1.3.3.7';Query OK, 664 rows affected (0.48 sec)Rows matched: 100445 Changed: 664 Warnings: 0mysql> update post set ipaddress = '1.3.3.7';Query OK, 3805 rows affected (1.30 sec)Rows matched: 398944 Changed: 3805 Warnings: 0mysql> update adminlog set ipaddress='1.3.3.7';Query OK, 567 rows affected (0.15 sec)Rows matched: 72530 Changed: 567 Warnings: 0mysql> update moderatorlog set ipaddress='1.3.3.7';Query OK, 275 rows affected (0.00 sec)Rows matched: 968 Changed: 275 Warnings: 0mysql> update searchlog set ipaddress='1.3.3.7';Query OK, 279 rows affected (0.19 sec)Rows matched: 279 Changed: 279 Warnings: 0mysql> update threadrate set ipaddress='1.3.3.7';Query OK, 93 rows affected (0.00 sec)Rows matched: 3460 Changed: 93 Warnings: 0 Quote Link to comment Share on other sites More sharing options...
Nytro Posted February 4, 2013 Author Report Share Posted February 4, 2013 (edited) Era o problema cu trimiterea mail-urilor de activare a conturilor, am reparat-o. Sa marcati si voi email-urile ca "Not spam".Edit: Deoarece nu ajungea mail-ul, am activat toate conturile. Edited February 5, 2013 by Nytro Quote Link to comment Share on other sites More sharing options...
Nytro Posted February 5, 2013 Author Report Share Posted February 5, 2013 mysql> update user set ipaddress = '1.3.3.7';Query OK, 828 rows affected (0.43 sec)Rows matched: 101273 Changed: 828 Warnings: 0mysql> update post set ipaddress = '1.3.3.7';Query OK, 2806 rows affected (0.96 sec)Rows matched: 401749 Changed: 2806 Warnings: 0mysql> update adminlog set ipaddress='1.3.3.7';Query OK, 703 rows affected (0.12 sec)Rows matched: 73233 Changed: 703 Warnings: 0mysql> update moderatorlog set ipaddress='1.3.3.7';Query OK, 225 rows affected (0.00 sec)Rows matched: 1193 Changed: 225 Warnings: 0mysql> update searchlog set ipaddress='1.3.3.7';Query OK, 252 rows affected (0.02 sec)Rows matched: 252 Changed: 252 Warnings: 0mysql> update threadrate set ipaddress='1.3.3.7';Query OK, 59 rows affected (0.00 sec)Rows matched: 3519 Changed: 59 Warnings: 0Stay safe! Quote Link to comment Share on other sites More sharing options...
Cifre Posted February 5, 2013 Report Share Posted February 5, 2013 @Bodsswohogs Da faq daramati botul asta pana nu apuca sa faca 500 de posturi .Asta ar fi o schimbare . Quote Link to comment Share on other sites More sharing options...
Azrael-sub7 Posted February 7, 2013 Report Share Posted February 7, 2013 @NytroDaca 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 ... Quote Link to comment Share on other sites More sharing options...
cross Posted April 8, 2013 Report Share Posted April 8, 2013 o sugestie: ar fii bine daca ati adauga un shoutbox in partea de jos a indexului unde sa vorbeasca lumea, sunt sigur ca va functiona foarte bine si lumea ar intra foarte des atunci Quote Link to comment Share on other sites More sharing options...
M2G Posted April 8, 2013 Report Share Posted April 8, 2013 Avem chat: https://rstforums.com/chat/Si este sectiune de sugestii, nu trebuie sa postezi aici. Quote Link to comment Share on other sites More sharing options...
cross Posted April 8, 2013 Report Share Posted April 8, 2013 Ma scuzati sunt nou si nu am stiut Quote Link to comment Share on other sites More sharing options...
AlStar Posted April 9, 2013 Report Share Posted April 9, 2013 Acum ca ma gandesc mai bine, ma mir ca subforumul "Sugestii" n-are un minim de posturi/vechime...Avand in vedere procentul destul de mare al celor care sunt straini de caracteristica "cu cap", nu ar trebui sa mire pe nimeni unele posturi/ unii membri. Quote Link to comment Share on other sites More sharing options...
Nytro Posted September 8, 2013 Author Report Share Posted September 8, 2013 Este posibil sa va mearga RST mai greu. Quote Link to comment Share on other sites More sharing options...
Nytro Posted January 2, 2014 Author Report Share Posted January 2, 2014 A fost stearsa categoria "Pranks". Posturile au fost mutate in categoria "Cele mai penale posturi". Quote Link to comment Share on other sites More sharing options...
Nytro Posted January 2, 2014 Author Report Share Posted January 2, 2014 Categoria "Bloguri si bloggeri" a fost mutata ca subcategorie a categoriei "Linkuri". Quote Link to comment Share on other sites More sharing options...
Nytro Posted January 3, 2014 Author Report Share Posted January 3, 2014 Avem un nou moderator: Gecko Quote Link to comment Share on other sites More sharing options...
Nytro Posted January 3, 2014 Author Report Share Posted January 3, 2014 Header-ul forumului contine acum "RST Forums" in loc de vechiul "RST Center". Quote Link to comment Share on other sites More sharing options...