View previous topic :: View next topic |
Author |
Message |
AWM Mars Member
Joined: 06 Jan 2010 Posts: 1195 Location: Wilts England
|
|
Back to top |
|
|
John DeleD PRO user
Joined: 22 Dec 2008 Posts: 182 Location: Houston, TX
|
Posted: Sun Oct 31, 2010 3:45 pm Post subject: |
|
|
An update...
Don't get your hopes up, but I have the senior project coming up next semester and I'm going to try to sell the deled database idea to them, so that I'll have time to work on it.
I've also learned enough from the database course that I'm in right now to understand that I probably would have botched the MySQL or MS SQL implementation if I had gone ahead with it earlier.
Anyway, my biggest stumbling block would actually be validating that model and texture files are being uploaded rather than viruses. Not implementing the database. So if I do this, in the beginning at least, I will only allow OBJ and text model files (if I remember correctly the Deled format is XML based?), which are relatively easy to parse and check. The collada format is a bit of a monster, so don't get your hopes up there. Compressed image files are a bit of a pain to check as well, so I may only allow the model themselves, not textures. We'll see what happens.
Bottom line...I'm sorry I let you guys down...I have plenty of reasons to get this done, but very little time because of college. |
|
Back to top |
|
|
harper Member
Joined: 19 Jul 2007 Posts: 283 Location: Hamburg, Germany
|
Posted: Sun Oct 31, 2010 5:38 pm Post subject: |
|
|
Do i understand you right? Viruses in pictures? Urgh...
I hoped we will use the package format, because i know really,
that texturing something is mostly more work than the pure modelling...
Last edited by harper on Sun Oct 31, 2010 6:25 pm; edited 1 time in total |
|
Back to top |
|
|
trucker2000 DeleD PRO user
Joined: 11 May 2005 Posts: 1839 Location: Sacramento, California
|
Posted: Sun Oct 31, 2010 5:43 pm Post subject: |
|
|
John, you haven't let anyone down. Everyone here eather has a job, or is going to school, so it takes time to get things done. Just keep plugging away and it will eventually get done.
Harper, yes. The jpg format is notorious for people placing viruses inside them.
The thing about checking to make sure the object or texture is virus free is normally done by the virus scanner on the server. I don't think you need to worry too much about that. _________________ Some day I will grow up and be a real modeler.
"Never give up! Never surrender!!"
Sys specs:
asus
8 gigs ram
Invidia gtx560 video card
Windows 8 (worst op sys Ever) |
|
Back to top |
|
|
AWM Mars Member
Joined: 06 Jan 2010 Posts: 1195 Location: Wilts England
|
Posted: Mon Nov 01, 2010 8:20 am Post subject: |
|
|
If I am not mistaken, Jpg was the first carrier format for viruses etc? Back in the days of dial-up, even Jpg's were made tiny and couldn't hold much, GIFs reigned then.
Whats amazing (before I hijack this thread), if you have IE and FF on your system, there are exploits that can use the cache of the browser you are NOT using, to compile 8 bit programmes, that compile themselves collectively into 16bit and onto 32bit, that can turn off your virus checker before being detected, making it look like its running fine. Then they take over your system. If these @ssoles put their brains towards good, man would be free of pollution and be living in harmony with nature by now, maybe even living on Venus.
(Climbs down off soapbox)
@John, your school work is most important. For those able, sharing models is still thriving. If anyone needs a home for their models to share with the DeleD community, drop me a PM. _________________ Politeness is priceless when received, cost nothing to own or give, yet some cannot afford.
Checkout:
http://www.awm.mars.yourinside.com/
http://www.bccservices.co.uk
http://www.localtradecheck.co.uk |
|
Back to top |
|
|
Jeroen Site Admin
Joined: 07 Aug 2004 Posts: 5332 Location: The Netherlands
|
Posted: Thu Dec 16, 2010 7:32 am Post subject: |
|
|
Any news on this? Seeing AWM's latest models, it would be too cool to have some sort of sharing site for DeleD models. _________________ Check out Figuro, our online 3D app! More powerful 3D tools for free. |
|
Back to top |
|
|
John DeleD PRO user
Joined: 22 Dec 2008 Posts: 182 Location: Houston, TX
|
Posted: Thu Dec 16, 2010 7:10 pm Post subject: |
|
|
Jeroen wrote: |
Any news on this? Seeing AWM's latest models, it would be too cool to have some sort of sharing site for DeleD models. |
The grades are finally in and I am on break so I can get back to this.
Sort of a list of things that we will have to do to make this happen:
1. A design document that has a normalized 3NF or BCNF relational database for this project along with a data dictionary.
2. The generic SQL DDL commands to create the tables.
3. The generic SQL DML commands to do queries on the database.
4. Once the decision is made on whether to go with MS SQL or MySQL, the DDL and DML statements will have to be tweaked to work with whatever implementation we choose.
5. To start out with, a simple ASP.NET web page with C# or Visual Basic as a back-end. We would need these pages: a) a front page for news and to let unregistered users view the models, b) a registration page, c) a user login page, d) a page for registered users to view and download models, e) a page for registered users to upload models.
6. A web server that can handle a decent amount of bandwidth and run ASP.NET and SQL. I've done business with www.discountasp.net and had no problems.
Let me know if you think this is overkill. If it is, post a simpler solution. I'm going to try to have steps 1-3 in a couple of days. Please give feedback on all of this. |
|
Back to top |
|
|
trucker2000 DeleD PRO user
Joined: 11 May 2005 Posts: 1839 Location: Sacramento, California
|
Posted: Fri Dec 17, 2010 3:24 am Post subject: |
|
|
You're going to make a custom site for this? Why not just use a cms like xoops or jumla? My site has been up with a downloads section that members can upload objects for a long time. (I use xoops) _________________ Some day I will grow up and be a real modeler.
"Never give up! Never surrender!!"
Sys specs:
asus
8 gigs ram
Invidia gtx560 video card
Windows 8 (worst op sys Ever) |
|
Back to top |
|
|
Jeroen Site Admin
Joined: 07 Aug 2004 Posts: 5332 Location: The Netherlands
|
Posted: Fri Dec 17, 2010 8:07 am Post subject: |
|
|
I have no experience with specific download sections as offered by Xoops or Joomla etc, but I would advice to take a close look at them. If they provide the functionality we need here, it seems wise to use those instead.
If, on the other hand, you are more motivated to work on a custom site (and from a programmers point of view, I can certainly understand this ), your list of things to do seems ok to me. Of course, this means much more work, not only for development but probably also for maintaining the actual site.
I would choose MS SQL over MySQL anytime, mainly because of the available tooling for MS SQL. It outclasses the tooling for MySQL by far. That comes at a price though.
Btw, is Silverlight an option? I've been working on a Silverlight application for the last year using RIA services for database connectivity and it's a breeze.
Anyway, let's investigate Xoops etc first. My 2 cents. _________________ Check out Figuro, our online 3D app! More powerful 3D tools for free. |
|
Back to top |
|
|
John DeleD PRO user
Joined: 22 Dec 2008 Posts: 182 Location: Houston, TX
|
Posted: Fri Dec 17, 2010 3:50 pm Post subject: |
|
|
I don't have experience with Zoops or Joomla but it is defenitly something to look into.
It might be best to go ahead with both. We could build something quickly with Xoops or Joomla. Then phase the Xoops or Joomla site out once the custom solution is finished in the long term. |
|
Back to top |
|
|
trucker2000 DeleD PRO user
Joined: 11 May 2005 Posts: 1839 Location: Sacramento, California
|
Posted: Sat Dec 18, 2010 11:23 pm Post subject: |
|
|
The only problem I've found with xoops download is that it is hard coded to only allow zip files and no larger than 2048kb in size.
One of these years I'll find that hard coded spot and change it. _________________ Some day I will grow up and be a real modeler.
"Never give up! Never surrender!!"
Sys specs:
asus
8 gigs ram
Invidia gtx560 video card
Windows 8 (worst op sys Ever) |
|
Back to top |
|
|
|