The Last Homely House
General => Council of Cobra => Topic started by: Kralik on May 03, 2008, 06:14:32 AM
-
A few things off the top of my head:
Obviously, the most important thing is a community of LotR players.
After that, here are a few starting points:
- A better name! Lord of the Rings Trading Card Game Database.... Forums! is a mouthful. Even LotRTCGDB Forums is too much. Any ideas?
- A more suitable theme than the default blue
- Better smileys, including LotR icons
- Seamless integration into the LotR TCG DB (true autolink)
- A resources area with information on useful programs and downloads (deck editors, etc.)
-
a new color please! ;D
-
- A more suitable theme than the default blue
I found and added a LOTR theme (check your profile to choose it), but it's kinda meh. I'll play around with it.
- Better smileys, including LotR icons
Nothing doing for the smileys yet, but fortunately I had thought to save all the LOTR culture icons a while back. I've added them here.
More to come! ;D
-
I found and added a LOTR theme (check your profile to choose it), but it's kinda meh. I'll play around with it.
Hobbit_Pizza, you still want to design a good CSS stylesheet?
Odd that your avatar is the same as mine, Dain. You may want to change it. ;)
-
and Conor offered something and maybe you're willing to look into it Kralik? This is what he wrote:
If anyone is inclined to rebuild the forum at another location, I have database dumps in CSV and SQL formats that I can provide for this purpose.
--Conor
-
Sure I can work on a stylesheet. I need a copy of the overall header/footer and the css file for the current template. Same for the generic LOTR template you mentioned. I'll look at them and see what I can modify.
BTW.....THANKS FOR THE FORUM!!! ;)
-
A few things off the top of my head:
Obviously, the most important thing is a community of LotR players.
After that, here are a few starting points:
- A better name! Lord of the Rings Trading Card Game Database.... Forums! is a mouthful. Even LotRTCGDB Forums is too much. Any ideas?
How about something from the Lord of the Rings about a final sanctuary for displaced peoples, like the Last Homely House! ;D
- A more suitable theme than the default blue
It just doesn't look the same without Cobra's colours!
- Seamless integration into the LotR TCG DB (true autolink)
Like CC used to be! Awesome!
Looks good!
Thranduil[/list]
-
and Conor offered something and maybe you're willing to look into it Kralik? This is what he wrote:
If anyone is inclined to rebuild the forum at another location, I have database dumps in CSV and SQL formats that I can provide for this purpose.
--Conor
GE, that would be awesome! I could definitely look into that, though most likely any posts on this particular forum would be lost. Well worth it! Is Conor giving up on fixing CC then?
-
the entire mail went like this:
Please forward this to the list of people who've been exchanging emails about the Cobra Cards forum.
Yes, the forum is down for good. As you know, there have been constant stability issues with the database, which I simply don't have time to deal with anymore. Additionally, there have been recent problems with the site suddenly trying to hog all the resources on its server, which are unexplained but possibly the result of hacker attacks. This resulted in the site being suspended, and I'm not prepared to put in the huge amounts of time, effort, research, and perhaps money that would be necessary to solve all these problems.
If anyone is inclined to rebuild the forum at another location, I have database dumps in CSV and SQL formats that I can provide for this purpose.
So yeah, he gave up on them....
-
When was that email sent? Anyway, if you could PM me Cobra's contact info, I'll see what I can do.
-
Kraliks on the way!... I like how much work you have put into this forum...but it just isn't the same as good old CC
translation: I don't have over 100 gold and 7000+ posts ;)
-
If anyone is inclined to rebuild the forum at another location, I have database dumps in CSV and SQL formats that I can provide for this purpose.
I think that this is the route we should go.
But until then, we need an MtG section. Absolutely imperatively MUST HAVE an MtG section. I could help mod it if F_M doesn't come back.
(And maybe a better UI).
(SoP, here's a start with the gold! BTW, can we get the delay back to 15 minutes like the old CC?)
-
Dumps? In other words, database backup?
Can that be imported into SMF? What kind of SQL forum was he running?
-
If anyone is inclined to rebuild the forum at another location, I have database dumps in CSV and SQL formats that I can provide for this purpose.
I think that this is the route we should go.
But until then, we need an MtG section. Absolutely imperatively MUST HAVE an MtG section. I could help mod it if F_M doesn't come back.
(And maybe a better UI).
(SoP, here's a start with the gold! BTW, can we get the delay back to 15 minutes like the old CC?)
well if he can restore it we really don't need anything...
-
Update!
First, I changed the time setting for gold to 0.25 hours. See if that works for you.
More importantly, Conor has responded! I will try and set up a phpBB2 forum with the old CC data. Cross your fingers...
It may take a while, so I'll be putting it at an alternate URL on this server while testing it until it could be moved to /forums.
It would be much more trouble than it's worth to try to convert it to SMF, but I may be able to upgrade to phpBB3. We'll see. He also has the old autolink extension in there, so I may be able to adapt it for use with the DB. Maybe even have the same ol' theme! :)
-
The theme would be awesome, but as long as we can preserve all the old data, that would be enough for me. That's our HISTORY we're talking about.
Kralik, I have extensive experience creating, moderating, and administering forums, including phpBB types. I've never taken an existing database and re-created a forum from it before, but I've done vitually everything else, so if you need some help with anything, just let me know.
This is so exciting! ;D I can't wait to see how it all works out.
-
Neither do I have any experience turning a raw DB into a working forum. But I'm nothing if not determined! ;D
As far as I understand it, I should be able to install phpBB2 and set up a basic configuration, including a MySQL DB. From there if I import Cobra's database dump through my website's central backend... *crosses fingers*
-
Here's my last word from Conor this morning:
Kralik,
The files were created in phpMyAdmin, one with the "CSV" option and the other with the "SQL" option, both leaving the default settings intact. Let me know what version you'd like to work with, and I'll upload it to my other webspace.
I'm afraid I don't remember the exact version number I was using, but it was definitely 2 rather than 3.
I had made some of my own hacks to add specialized functions to the forum, some of which included additions to the database structure. In particular, there's a new field which carries the "post-autolink" message (when a post was made, it was parsed for card names using the store's database, which were then turned into appropriate links, and the new version was stored alongside the original). There are also a few fields that were used to enhance voting for the article contest.
These changes are additions only, I never modified the database structure in a "destructive" way, so I don't think this should cause any problems. Just wanted to warn you though. ;)
--Conor
-
Neither do I have any experience turning a raw DB into a working forum. But I'm nothing if not determined! Grin
As far as I understand it, I should be able to install phpBB2 and set up a basic configuration, including a MySQL DB. From there if I import Cobra's database dump through my website's central backend... *crosses fingers*
Yes, that should do it. phpBBs are usually pretty easy to work with, so I imagine it's a rather straightforward process. My only real worry is the sheer size of the CC database. That sucker's got to be MASSIVE.
One other concern I have is that you may suddenly lose your admin rights once the forums are up, since you and I are not admins in that database. But I imagine it's forgiving enough that that WON'T happen. I THINK it will keep you as an admin and then just add the old admins (probably only Conor) and mods that we had over at CC. If you want me or anyone else as an additional admin or mod after that, I would think you could then just change our status in the user administration panel.
Again, let me know if you need/want any help. Like you, I'm determined, and also like you, I bet I can feel my way through it if you get frustrated along the way.
Good luck, my friend!
-
Well, phpBB itself will choke if you try to Backup/Restore databases too large. However, since I will be working with the MySQL backend, not the phpBB ACP, it should handle it just fine. I gave the admin issue some thought, and I have two solutions:
1) With direct access to the SQL DB, it should be easy to set myself up as an admin.
2) Even if it wasn't, I'm sure Cobra could log in and set a new admin if asked to do so. :)
-
Too many big words for me to handle. ??? ??? Please explain in simpleton what's going on!
-
cobracards.com is officially dead.
I'm in touch with Conor and will try to restore CC, including posts/gold/etc, on this domain (lotrtcgdb.com).
-
Groovy. 8)
-
But it's going to take a while.
Yet hope remains while the Company is true. :)
-
If I had the time I might be able to bust it out in a day, but I have to work tomorrow. ;)
-
Ah, I see, some people actually work! ;)
It all looks like a good start so far, great to have the LotR icons available. I'm glad that someone knows about this technical stuff because I don't.
Edited to say: Oh, and I LOVE the name of the forum! Great job Thran!
-
Could we have our twilight symbols? And, just to be really demanding, can we have the culture symbols not capital sensitive and include [Dwarf] as well as [ Dwarven ]?
Plus, I think there should probably be an MTG section. I never used it, but it feels wrong that it isn't there! ;)
Thranduil
-
Wow ppl this is looking really good. I've been curled up in a ball since CC went down, so I'm grateful. :D
The name rocks, thnx for the lotr icons, the color and layout is fine... now we just need to inform everyone about it!
-
I see that we are accumulating gold...is there somewhere to use it yet? If so I couldn't find it...
-
No, but that brings up an interesting thought...once the CC forums are restored, can we add items in the "store" that can be purchased with GP? I would think we could....
Oooo, I'm getting all excited again! :)
-
http://www.irenaeus.nl/forum/images/smilies/vader.gif
http://www.irenaeus.nl/forum/images/smilies/clown.gif
http://www.irenaeus.nl/forum/images/smilies/copper2.gif -if bad language appears
The first one I like a lot..........
-
Vader?! Well... I guess he did win the last villain CSG...
-
If this site remains up, could we see who is browsing which forum please?
-
If this site remains up, could we see who is browsing which forum please?
Well, the main reason I put up a poll is that right now I'm busy with work and life, and can't afford to spend too much time making those modifications unless I know it's worthwhile. Bug Dain. ;)
-
You know Kralik, I really like these new forums. It would be nice to have all of the old data from cc but you have done a very good job and I like the layout. I like all of the new features and I think the name, The Last Homely House, is very fitting. I may have not posted a whole lot on cc like the rest of you but I read the posts almost everyday. I hope this stays up for a long time. Oh yeah, on a side note in case you don't remember me my usual screen name was taken on cc (Beorn) so I went by man_flesh.
-
Well. This is nice.
And we even have the culture icons for LotR already,
Cool.
Yeah, I'm thinking that as soon as we get the old CC stuff, this is going to be a worthy successor.
-
If this site remains up, could we see who is browsing which forum please?
Done!
-
Thanks! I don't know if it's been mentioned yet, but twilight costs on cards ([1] on CC i think) and unique dots would be nice. Thanks for making this site!
-
You know how there's a link from the tcgdb to the forum, well is there a link on the forum back to the tcgdb? Is there going to be a header or consistant template to make them feel like the same site? I wanted to suggest that there be a button somewhere that also links to Mahasamatman...
-
Big thanks for setting up these forums, Kralik!
(This is Elessar's Socks from CC, BTW. ;))
-
wow... that was weird.
-
(https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fwww.clipartof.com%2Fimages%2Femoticons%2Fxsmall2%2F771_smiley_being_punched_through_his_computer_monitor.gif&hash=0b149d791a7836182e1182ea59abe3e41315c4d4)
(https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fwww.yigg.de%2Fsmilies%2Fpopcorn.gif&hash=1afda5a66901c18cf60d86ad29d69543775f9010)
-
Gah! I love those smileys!
-
SPAM
-
is good for everyone!
-
SPAM
No, seriously, those were smileys I'd like to see added.
-
No, seriously, those were smileys I'd like to see added.
And they have been. :mrgreen:
-
I see the cop, I see the clown, but where is Vader?
-
where did he post vader? I remember it but don't see it anywhere :popcorn:
-
I gave a link on the previous page...the one on top
-
Does anyone else keep clicking the member name instead of the topic link on the main page? I guess I'm used to the topic link being at the top so I keep mis-clicking, but if everyone else is looking at me funny, I... was never here.
-
Does anyone else keep clicking the member name instead of the topic link on the main page? I guess I'm used to the topic link being at the top so I keep mis-clicking, but if everyone else is looking at me funny, I... was never here.
*looks at Socks funny and cackles as he flees in shame* :P
-
Dain how can you AND Kralik be head of the council. Surely thats an oxymoron. You can only have one "head of..." anything...
-
Question our shared authority again and I shall SMITE you! :twisted:
No, seriously, uh...it's a democratic council. It's like a senate! :roll:
-
I think youre just crazy and want the power so you can abuse it!
Smite me all you like, the downtrodden will rise up more powerful than before!
:P
-
Speak not of downtrodden until you're between the foot and the floor. And... and I was looked at funny, too!!
How about:
Dain - Head of the Council
Kralik - More ahead of the Council
lem0nhead - Behind the Council... far behind
(Just kidding!)
-
lem0nhead - Behind the Council... far behind
Cheeky! I prefer the term "lagging". lem0nhead - lagging council member
-
Just one minor suggestion/improvement. All the twilight icons have a squarish shape/white edge around them. perhaps you could save them as GIFs for transparency reasons? just wondering.
-
Yeah. Sorry about that; my fault. I don't know how to create transparent color, et cetera, in GIFs, so I just sent Kralik some bmps I thew together. Better than nothing, but if anyone does know how to get transparency, that'd be great.
-
*plays around a bit with AD's awesome icons*
(https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2F0.gif&hash=9bed02c21269c0f25b6b35a80f3bcba8732f7b70) (https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2F1.gif&hash=2d67537101f69657db17083e8e95f0193c557027) (https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2F2.gif&hash=8530eb8990567eab5a47b18039f69a3041c5062b) (https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2F3.gif&hash=4dea9623fa81d0687d7a4daf3de9018e5fc1b90c) (https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2F4.gif&hash=2990981441f348deef900392f513c6a8ad25bc21) (https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2F5.gif&hash=3f261a04feb03a286c3fba604ee2a088580b2c0e) (https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2F6.gif&hash=0ef516397a4dcd6aaad8e4d1df340f469dc6415f) (https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2F7.gif&hash=f748d7dcfce747d1cb6668128cedc60731cb3098) (https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2F8.gif&hash=ca9f37dacac767c9696514930a00087b1e55cc81) (https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2F9.gif&hash=8cad9f86aeb47f7aeb3b0f4478c2ff4cb5cc301a) (https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2FX.gif&hash=85125247893a66887739178fce822f2d16379628) (https://lotrtcgwiki.com/forums/proxy.php?request=http%3A%2F%2Fi31.photobucket.com%2Falbums%2Fc366%2Faspect05%2Fnaughty.gif&hash=e3fd2a523a193cda98d69a17fc7d454d1a57d993)
Used a white matting to lessen the jaggedness of the edge (LMK if I should change to another color). Unless there's a way to use variable transparency with GIF? Oh, and the bulleted item tag is interfering with 0.
-
Good stuff, guys. I've added those new and improved twilight icons to the "smiley" list. See here (http://lotrtcgdb.com/forums/index.php?topic=118.0) for details. :hey:
-
I'd like to see a mod lounge.
As well as our locations showing up next to our names when we post. I like mine a lot.