*Is very tired*

Before I go distract myself with Age of Empires II....




I found that the quoting doesn't appear like it should.... and the word "Icon" appears 3 times per post, one in the upper right corner of a post, one on the center bottom of a post (below the signature) and one in the bottom right corner. (I didn't grab that portion of the post... I didn't really think about it until now *bashes head*)

Would these happen to be the icons for the delete/edit/quote buttons? Or placemarkers for something else?

BTW... I can't change the screenshot program to take anything else but .tiff grrr.... I'm sick of converting them to something reasonable...

## Rant. Ignore if you'd like ##
(and now converted to rant mode... within this space, please ignore all grammatical errors like capitalization)

I'm just sick of the fact that I can't really do a whole lot with .tiff ... well, online anyway... So it has nothing to do with the forums, but it really has more to do with the screenshot program... my main computer for internet is a macbook pro with mac osx. it comes with a "utility" called "grab" that takes screenshots (of windows/screens/selection/a timed screenshot), but it saves it in .tiff and there's no way to change it.... So my internet stopped working and then i have troubles getting back on here….. grrrrrrrrrrrr i get irritated a lot easier when i'm tired…..*stabs internet*… So during the meanwhile, i'm stuck typing this in textedit, since I couldn't access the forums for whatever ungodly reason




And then when I try to look something up... i get a massive freeze up wtfh? luckily this post that i "saved" with textedit got saved...

Gah, I think I'm done.
## /Rant ##

OH, ignore the beginning thing about AoE II.... that was a couple hours ago.... grumblegrumbleforkinginternetgrumblegrumble

Er... right.

Anyway, you're the one with the data, Rei, but it looks like what we know as "threads" are actually collections of posts in e107_forum_t with a common parent in the thread_parent field. In that case, I expect e107_forum lists the different "forums" i.e. Anime, Manga, Games, etc. Users are pretty obviously recorded in e107_user .

Looking at the fields, I'd say you'll have to run at least four updates on three tables whenever someone posts.

First, you have to insert the post itself into e107_forum_t (1). Then, you have to update its parent to revise things like thread_lastpost , thread_lastuser and thread_total_replies (2). You also have to update e107_forum to revise things like forum_threads , forum_replies , forum_lastpost_user and forum_lastpost_info (3). Finally, e107_user will need to be updated to revise fields like user_lastpost (4).

Does that make sense?

Oh wait.... *Smacks self*

So the top right is for delete/edit/quote, the bottom middle (now that I look at it, it's more on the left side) is for profile (?), and the bottom right is for private message (?).

Again, sorry about the ranting... I just haven't been having a good day for the past couple weeks and yesterday's tiredness + bad internet set me a bit over the edge. Maybe I'm a little too honest with how I feel? lol

Ah, but we're all human. (maybe I should have made the rant text bigger? lol)

I don't code forums, but it made sense to me lol. (I code simple programs with Python 2.x)

(update)
Actually, some of the bbcode doesn't work.... So like in one of my other posts, the bold works, but the size tag doesn't, so it's not just the quote tag. (I was going to make an example, but I guess the forums here don't like the [noparse][/noparse] tag... weird...)

[ Edited Jun 8, 2010 ]

Here's a list: (in the order that I find them)

quote
size
br
link
img

Well, that's all I found so far, I suppose I should dig around in the other threads besides this one. lol

(Edit)
Dug around some, and couldn't find anything else, but I did notice that the date and times for each post have the time zone that the server is in posted instead of it being localized.

So it shows up like this:
07:45:47 -0600 (server's local time)

Instead of this:
06:51AM (my local time)

(The post edited time is also affected)
The reason why the minutes are different, is because the old forum uses the user's computer's time, and the new forum uses the server's time.

[ Edited Jun 8, 2010 ]

Age of Empires II... fun game. Did a LAN party last week, we only managed two 5-6 hour games. lol

Wow, lots to do! You're keeping me very busy this week 13x31.

-- BBCode --
BBCode, so far we have support for:
b, i, u, s (spoiler), color, bl (blink), marquee (?), left, right, center, code, url, quote, blockquote, img, email

However, the CSS many be incomplete for some of them.... I'll test out the five you listed.

Hm, and the size one... is missing. I'll have to add that. And br. And link.

--DATES--
Sorry about the dates. I'm being lazy. :-P http://php.net/manual/en/function.date.php really, any format is possible.... I like the date("r") because it's a full date and real simple.

--ICONS--
Just a tempoary reminder for me where the forum icons go.
We'll need "User Moderation Icons" - report, quote, edit, "Moderator Icons" - edit, delete, move, and "User Icons" - PM, email, homepage. Since each icon I add will require coding a new forum feature..... I'm holding off on adding them for now.

--Forum POST Code--
Thanks Kyareshi, what you wrote matches up with the pseudo code I had at the top. Looks like I'm set to try coding new posts, but then it gets tricky posting replies, editing, moving, and deleting. Fun times ahread! lol


I'm a little tired of coding the forums, but been back coding Character Profiles.

I really want to swap ACDB with ACDBv2 first, then the forum.

Hope you're having a better day today, 13x31. Bad internet would stress me out too.

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

I am having a better day luckily. And D: that's a lot of options for time. (Do "U" and confuse everyone, perhaps next April Fools? lol)

I wasn't sure about the icons, and I was pretty sure they were placeholders, but I'm not you unfortunately, so I don't know why something is lol. Maybe the Profile/Email/Website/PM icons can be moved in the "Poster" area (where the poster's avatar is) under the number of posts the user has. It just seems a little more logical and more visible than under the posts (I tend to skip anything not relevant to the thread in between posts....) Up to you though, just a suggestion.

Well, at least I'm keeping your TODO list full lol.

Perhaps I should start playing around with the actual DB side more and finding stuff there, when I do.

Well, to AoE II and then off to bed!

(Edit)
*smacks self for not tethering my laptop to my phone's internet* Well, it happens when you're pissed off... You end up not thinking straight...

I just reloaded the forums for shits and giggles... and all the text in all the posts got centered.... Weeeirrrrd..... anyway... really should get to AoE II now lol...

[ Edited Jun 8, 2010 ]

I just looked at what you guys have worked up since i last logged in and it looks AMAZING ecxept for one thing... and that would be the coloring for the community identified characters. I couldnt even read what was in the box. (cant see certain colors together unfortunately T.T)

I dont see mistakes in the forum except i think one or two threads were missing pages?
Generally thats about it Rei.

"Further into chaos we shall keep walking. Only to meet our fate." ~Souls
---
Future Mangaka in the works.

Alright, I think the BBCode is closer to being done..
http://www.animecharactersdatabase.com/newforum.php?forum_id=4&thread_id=5684&x=30

Also added some pager links near the bottom too. Should I add any more? Drop down menu?



Who's This Character Board

Woot, that's what I like to hear Souls_death87! And I completly agree, the Who's This Character Board is .... is .... bad. I need to rewrite all the code for it, even alter the database structure. But I have some good ideas.

1) Split it into two forums: Open/Unsolved, Closed/Solved
2) Browse by week


[ previous week ] [ next week ]

Last 48 Hours -- 6 Threads -- 2 Replies

2010 Week 13 -- 10 Threads -- 5 Replies
2010 Week 12
2010 Week 111

3) Also, I'll make it so we can sort by latest reply.

Kinda sucks for the older posts now, if someone repiles, no one would know! But, I'll fix that.

4) The summary thing on most pages.... I'll greatly simplify.

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

Another thing about posting on the forums...

I don't know what version of MySQL you're using, but apparently triggers are supported beginning with version 5.0.2. I highly recommend using them if they are available to you (and if they aren't implemented already). For instance, you can put the updates to e107_forum and e107_user in an INSERT trigger. This eliminates the need to run the updates separately and goes some way toward ensuring that your data doesn't get out of sync. Like I said, though, it's possible e107 might already have triggers like these implemented, in which case you shouldn't be running the updates separately...

Oh, and be careful if you put the update to the parent thread in a trigger as well – if the record refers to itself, you could end up with an infinite loop. There should be checks in place to avoid this sort of thing, but the e107 people might have left it out.

So either I'm seeing double today or it's some kinda new Magic Eye thing lol (I know it's neither). Anyway, there's a double posting of the Character Details, and obviously one is enough.





That's what I found so far.


*Smacks self again* God... i've been doing this a lot lately....

The column on the left is apparent (field) and the column on the right is actual (field)

Just label these columns, and the confusion goes away (maybe make the details a tad bit smaller?)



As far as the colors in the commonly identified characters portion, a gray background (yes, again) instead of green should alleviate the problem. (It also becomes color blind friendly lol

[ Edited Jun 9, 2010 ]