ACDB  Log In
Search

READ ONLY MODE IS ACTIVATED

Post Reply
ACDB Forums :: Anime Characters Database :: Site Discussion
Posted 15 year(s) ago Re: # 5706

Nori13
Shinobu's Pet Wolf

Nori13 Avatar
5 Stars
Head Admin
Joined on 05-30-10
Posts 416

Ah, kk. ごくろさまでした!
Top PM Nori13
Posted 15 year(s) ago Re: # 5707

Rei
ダメ人間

Rei Avatar
10 Stars
Head Admin
Joined on 05-24-07
Posts 2102

あらっ,13x31さんは日本語が少し話せるね。

Forum theme has been updated.
Character vector image order has been fixed. Also added name and source under the center image.

Running a few optimization benchmarks on database memory usage now.
And trying to slim down PHP memory usage.


Might be ready to start testing forum posting features tomorrow.
[Image]

私は日本語を少し読むと書くをできます。あなたも?

[Image]
Top PM Rei
Posted 15 year(s) ago Re: # 5708

Shinigami_55
~Loli Power~ supporter

Shinigami_55 Avatar
3 Stars

Joined on 05-20-10
Posts 249

I´ve been a little absent lately, but in short, you guys making a new forum?
well, what i,ve seen so far looks good. Keep on the good work ^^
[Image] [Image]
Watch yourself so you dont meet the Loli Ban Hammer
Top PM Shinigami_55
Posted 15 year(s) ago Re: # 5709

Nori13
Shinobu's Pet Wolf

Nori13 Avatar
5 Stars
Head Admin
Joined on 05-30-10
Posts 416

はい。I'm learning Japanese slowly (really ought to stick to it) with Rosetta Stone. So far I think it's worth the money. *checks out fixes*
Top PM Nori13
Posted 15 year(s) ago Re: # 5710

Rei
ダメ人間

Rei Avatar
10 Stars
Head Admin
Joined on 05-24-07
Posts 2102

Welcome back Shinigami_55

Yup, in short, I'm coding a new forum to replace these e107 Forums so I don't have to worry the next time a new exploit is found and this bot net tries to absorb ACDB:


[Sun Jun 6 14:20:01 2010] [error] [client 94.23.81.79] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:02 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:02 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:03 2010] [error] [client 94.23.81.79] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:03 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:03 2010] [error] [client 94.23.81.79] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:03 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:04 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:04 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:04 2010] [error] [client 94.23.81.79] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:05 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:06 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:07 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:07 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:08 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:08 2010] [error] [client 69.175.84.106] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:14 2010] [error] [client 74.208.16.79] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:14 2010] [error] [client 74.208.16.79] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:21 2010] [error] [client 79.174.72.86] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:21 2010] [error] [client 79.174.72.86] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:23 2010] [error] [client 79.174.72.86] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:23 2010] [error] [client 79.174.72.86] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:30 2010] [error] [client 94.23.202.54] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:30 2010] [error] [client 94.23.202.54] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:31 2010] [error] [client 94.23.202.54] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:32 2010] [error] [client 94.23.202.54] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:44 2010] [error] [client 91.196.126.141] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:44 2010] [error] [client 91.196.126.141] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:46 2010] [error] [client 91.196.126.141] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:20:46 2010] [error] [client 91.196.126.141] File does not exist: /htdocs/forum/help_us.php
[Sun Jun 6 14:20:59 2010] [error] [client 194.79.16.72] File does not exist: /htdocs/forum/contact.php
[Sun Jun 6 14:21:00 2010] [error] [client 194.79.16.72] File does not exist: /htdocs/forum/help_us.php
I ban one IP, and two new ones pop up!

I'll be working on it all month.
[Image]

私は日本語を少し読むと書くをできます。あなたも?

[Image]
Top PM Rei
Posted 15 year(s) ago Re: # 5711

Nori13
Shinobu's Pet Wolf

Nori13 Avatar
5 Stars
Head Admin
Joined on 05-30-10
Posts 416

And now a strange thing I found while looking at the new forums...


A post on the old forum (this thread specifically lol):



And the same post on the new forum:



(I'm pretty sure it speaks for itself lol) But there's some "random" numbers that have been appearing at the end of the posts.


I'm pretty sure you're working on it, but the "previous thread/next thread" links don't work, I can't browse within thread pages, and I can't post a reply.


Also another thing I noticed (although not really related to the new system), is that the #00ff00 text in your signature is kinda hard to read. Use #008000 instead? Just something that caught my eye when I was editing the pictures (the screenshots I take are .tiff, so I have to use photoshop to convert them to .jpg. I think I can change it, but I'd have to look.... it's getting a bit annoying.) and not really that big of a deal.


D: That log looks a tad bit scary lol.

[ Edited Jun 6, 2010 ]
Top PM Nori13
Posted 15 year(s) ago Re: # 5712

Kyareshi
The Plotmeister

Kyareshi Avatar
10 Stars

Joined on 01-08-09
Posts 940

I don't have too much to say on this at the moment, but I think it's admirable that you're writing your own minimal forum software for better security (and it's nice of you to use the current forum database for it – there's a lot of knowledge in these forums that would be a shame to lose). It also allows you to integrate other parts of the site into the forums, as you seem to be doing already.
[Image]
Top PM Kyareshi
Posted 15 year(s) ago Re: # 5713

Rei
ダメ人間

Rei Avatar
10 Stars
Head Admin
Joined on 05-24-07
Posts 2102

Good to see you're back Kyareshi, I wanted to ask you a bit on database backwards compatiability...

http://www.animecharactersdatabase.com/forum_example.txt

As far as I can see.... for a new post, I'll have to run 4 update statements... if you think I missed a field, please let me know. I'll be testing this on the development server first, so no damage if I screw up. lol

13x31, I saw those numbers too. Your post helped me realize they were "edited timestamps" so I replaced the numbers with something like "Last Edited: Thu, 03 Jun 2010 21:06:30 -0600". You might have to refresh to get the new style/CSS.

Mostly spent this morning doing security research. Been banning an ever growing botnet for 2 hours now: 420 IP's. Programmed the web server to serve up 403 errors, and NEVER allow them to reach the PHP+MySQL layer... so we'll be up, meanwhile

http://e107.org is DOWN. LOL




[ Edited Jun 7, 2010 ]
[Image]

私は日本語を少し読むと書くをできます。あなたも?

[Image]
Top PM Rei
Posted 15 year(s) ago Re: # 5714

Kyareshi
The Plotmeister

Kyareshi Avatar
10 Stars

Joined on 01-08-09
Posts 940

Rei
http://www.animecharactersdatabase.com/forum_example.txt

I'm afraid I've never seen the insides of forum software before. How are replies tracked in those tables? Is there a row in e107_forum_t for every post, or are those just the topics (e.g. "New Forum, ACDB v2")?
[Image]
Top PM Kyareshi
Posted 15 year(s) ago Re: # 5715

Rei
ダメ人間

Rei Avatar
10 Stars
Head Admin
Joined on 05-24-07
Posts 2102

All guesses on my part, but it looks like there's only two tables.
All posts are going into e107_forum_t.
[Image]

私は日本語を少し読むと書くをできます。あなたも?

[Image]
Top PM Rei


Post Reply