I don't know a lot about how the database is put together, or the problems with it, I do know a little about html and am familiar with cgi, but my guess is that the site involves php which I haven't played with all that much.
I'd be willing to lend a hand if what knowledge I have would be useful.
Has anyone thought to ask Wild Bill if he'd take a quick look to see if he can pinpoint the problem?
I'd guess he's the most knowledgable in the area that is involved in the ZC community.
Yeah, I think it uses php. Ever since I joined and became active, I've never seen Wild Bill in the forums.
His forum name here is Raichu86 😊
I've rarely seen Raichu86 on. 😉 Occasionally, but rarely.
Still, If someone could, that knows him well, contact him and ask a favor of him or at least point him in this direction. I would like to think that the more attention that this thread gets, the faster this issue can be resolved, yes?
rocksfan13 wrote:Still, If someone could, that knows him well, contact him and ask a favor of him or at least point him in this direction. I would like to think that the more attention that this thread gets, the faster this issue can be resolved, yes?
He's wildbill at PureZC and from what I understand built Pure's database, he may not want to be bothered with all of this, I can't say, but I'd guess he is the most experienced in that area that comes around here.
He might be able to locate and solve the problem in a matter of minutes, since he probably knows what to look for.
Someone like me would take months digging around in there trying this and that until it finally started working.
Again, what would it hurt to ask him? What' the worste he'd say? No!?
Anyways, I would love to see this getting started. I don't know about anyone else.
rocksfan13 wrote:Again, what would it hurt to ask him? What' the worste he'd say? No!?
Anyways, I would love to see this getting started. I don't know about anyone else.
I wasn't suggesting it would hurt to ask him, I was letting you know where he is and how to get in contact with him. 😉
Yeah, the sooner, the better. Otherwise, we may be getting less traffic and active members in the future.
But we all agree that something needs to be done, whether it be ask Wild Bill to sight out the problem or completely scrap the old database. The latter should really be our "if all else fails" plan. I'm not a member at Pure ZC (for whatever reason I don't get the verification e-mail!), so I wouldn't be able to ask him.
why not just ask Eckels he made it and is still an admin here :shrug:
That would be a good idea IF you could get a hold of him. And I mean IF. He isn't around that much. He's been in and out lately, but not enough to do anything. Maybe he'll see this. Maybe he won't. You just don't know.
I'd like to see him involved in this too. Since he's the one that started it.
We all sent him messages about this a few months ago, right? At least I did, and he never got back to me. I know some others did, like the ones involved in the "I think the Quest Database is not operating" thread did. We could try PMing him again. :shrug:
I just wish the people who have had the experience with the site would be more active.
I'm looking for someone to finish the work.
It's all operational now, just a couple minor things still do not work.
Going to need someone that is around often to add quests as it seems Tygore bit off more than he could chew.
I'm on all the time War Lord. I'll do it. I would love this oportunity!
Although, it would be nice to have a little help. Instead of having just 1 person uploading, maybe 2? Just a thought.
What of DN's idea? Having a team vice 1 person. That would prove to be more efficient. Or don't you think so?
Alot of us seemed to like that approach.
Edited because got War Lord's name confused with Warlock. Woops! Sorry War Lord.
I could do it too. Though having two people do it would be much better. I'm always on and if I'm not on, someone else could do it.
rocksfan13 wrote:I'm on all the time Warlock.
I'd be more inclined to choose you if you were good with names.
Myself or goki will be working on this in the coming week or two.
Oops. D'oh! Sorry about that War Lord. Misread your name. It's just between the 2 of you, it's eay to get them backwards. I do know the difference between you two. 😊
Any thoughts of doing it like DN suggested? As a team.
Wait hold up War Lord or any one else that can answer this question. When a person uploads a quest to a site and sends to it the ZC.com, is it automatically sent to the datamase without the admin of the site doing anything or does the Admin do something to get the quest in the database?
I believe they get put in a queue. Then the person or persons who are authorized can go in and upload the quests to the server. I'm not 100 on that, but I believe that's the way it's done. Otherwise the person or persons in charge of adding them would need to be site admins.
War Lord, as I have mentioned, I am on here often thoughout the day and I would love to help keep the database updated. Let me know if I can be of any assistance.
I'm always on and I could be the whatever-job-needs-filled guy.
Yeah, 2/3 people would be excellent. It's better than how it was before, with only Eckels and JayeM in charge. In my opinion, the jobs could be run by this many people.
Manager - 2
Programmer - 2
Database front end designer - 2
Quest uploader - 2/3 or even 4
Database assistant - 2
So that's about 10 to 12. Is that too many people working on the site? Perhaps programmer and DB front end designer could be combined into one job.
Sorry, just rambling. 😉
Indeed I think we need a few people that do the uploads , that if someone isn't there it goes on anyway , rocksfan and pinnecon showed they really care from the start what happens to the questdatabase , so they both for sure will be a good pick 😊
What exactly is wrong with the qdb? I'm not going to go searching through threads, so if someone types up a concise list of what exactly is wrong, I'll see what I can do about fixing it.
tygore wrote:...I'm beginning to think a scrap and start over might be the best solution for the site at this point...
...
You're out of your goddamned mind. I'd like to see you write something close to the database capabilities that the QDB has. It may be glitched a bit, but with over 300k downloads, something must be working properly.
Well, let's see.
1. The comments aren't working. When a new one is added it is unviewable.
2. When a quest is added to the DB the date is not added with it and according to Tygore the scrrenshots on the left for quick links to recently submitted quests aren't working. Along with not being able to link screen shots with the quests.
3. Voting used to be messed up, but is fixed now. I don't know if there is still an issue there.
4. And spam is in the comments once again, when it did work. And the commenter's name never appears.
5. And Tygore is having a time trying to run it.
As far as I can tell that's all right now. I'll give it a better look tomorrow.
If anyone has anything to add, please do.
The only problem I can confirm is the screenshots do not seem to be attaching themselves to the quest when they're confirmed from the queue.
There are no problems with the comments, at least none that I could verify.
It looks like all the problems that occured are linked to the forum upgrade last year
That's exactly when they started.
As far as the comments. If you look at HOD. It has 2 comments but only one is viewable.
It's also the same with Zelda's Quest for Link. It has 13 and only 12 are viewable.
Also since the upgrade, none of the names are attached to the commentor.
I just deleted all the comments without names attached, since there's no way to identify the comment to the person. That's one of the reasons that it was giving false numbers just now. I'm also going to disable the code that shows how many comments each quest has, because that info is also false. At some point i'll write a script that will re-tally the comment totals.
...And it seems AGN has used all it's disk space and I can't re-upload the entire file.
Disk Usage 1000.17 MB
Disk Space Available -0.17 MB
So now it doesn't work at all... lovely.
Eckels this is not on topic, but nonetheless...
Is that your Kid?
If so � Congrats!
Great looking Kid!
Thanks - Joe
......Are we ****ed? We have no more space.
Joe wrote:Eckels this is not on topic, but nonetheless...Is that your Kid?
If so � Congrats!
Great looking Kid!
Thanks - Joe
Yassir! That's an old picture. He's now 14 months old, and usually running around the house. He's got a wonderful personality, and is the light of my life. He's a very cute kid too. His name is Daniel. And thank you for your compliments! 😊
Anyways, I freed up some space, so everythings ok. and the comments are ok for now.