
International Nerfer Database
#1
Posted 05 June 2004 - 08:01 AM
Basically, as one of my contributions, im soon to be working on a much talked about [earlier] NIC Database. This will be created in Flash MX, and, as a result, look pretty nifty. I know my stuff, and know how to source to an external text document, but can this be done with Databases created using Access or similar?
I'm not too strong with my action script, in other words, i pretty much know jack. I use the dynamic text method to source to a text file but i want to know if i can source from queries and sections of an online Database, such as tallies of NIC members and number of users in the certain locale. I wont go into too much detail because it is a lost cause if nobody here uses much flash and coding. But feel free to decipher my rambling post and get back to me.
#2
Posted 05 June 2004 - 09:10 AM
If you are serious about this, your best bet is to set up a GNU/Linux server running Apache and MySQL, buy a book about utilizing MySQL, and then spend a hell of a lot of time designing your database so that it doesn't suck.
If, on the other hand, you are not serious about this and planned on creating an "International Nerfer Database" as something of a pet project to do in your spare time, then I suggest you pick up your keyboard and smash it against your own face until such time as your "Database" is completed.
DEATH
#3
Posted 05 June 2004 - 09:15 AM
Ummmm... So I guess this is both an apology and a reiteration of sorts. Sorry I was harsh, learn more about computers.
DEATH
#4
Posted 06 June 2004 - 05:42 AM
This was a pet project, and now i sort of get the drift.
I never said that i thought VB and ActionScript were any form of real programming, in fact, i mentioned that my knowledge of Flash was piss-weak, so don't blame me for your incorrect assumptions.
I've had a thorough look at this project, and in its first form, it will be ugly and arduous, and certainly not in any way popular amongst you self-titled coding elites.
In my retort, ill let the evidence speak for itself . . . Click here . . .
There are some pretty big statements there...
*Ahem* Kiss my ass . . .Sorry I was harsh, learn more about computers.
Edited by taita_cakes, 06 June 2004 - 05:43 AM.
#5
Posted 06 June 2004 - 03:46 PM
Edited by Alexthebeast, 06 June 2004 - 03:46 PM.
#6
Posted 06 June 2004 - 10:23 PM
#7
Posted 07 June 2004 - 01:05 AM
The hard part is going to be gaining the neccessary information, not building the information representation. Hell, I'd settle for a definitive, regularily upkept html file. You can always just scan the text entries with a simple find-in-page search, after all.
However, it still remains a handy skill to be able to work with actual databases, and I suggest taita_cakes takes the time to learn them, and use this project as neccessary experience with his learned skills.
...And taita, your retort was entirely unneccessary. Death apologized for any reasonably insulting sentiments. I agree with him: Learn more about computers. God knows I need to myself... I'm helpless with a Macintosh. [HSF+? Everything's a link on my desktop?! Where's the command prompt!!?]
[Congratulations Horsemen, your clan image has created in at least one mind a faceless avatar of paralyzing fear.]
Edited by Zero Talent, 07 June 2004 - 06:47 PM.
- Death
#8
Posted 07 June 2004 - 10:22 AM
#9
Posted 07 June 2004 - 11:32 AM
Edited by xedice, 07 June 2004 - 11:33 AM.
Doin' coke, drinkin' beers, Drinkin' beers beers beers
Rollin' fatties, Smokin' blunts
Who smokes the blunts? We smoke the blunts
-Jay
#10
Posted 07 June 2004 - 03:49 PM
Crankymonky
Edited by crankymonky, 07 June 2004 - 03:52 PM.
#11
Posted 07 June 2004 - 04:04 PM
Create a program that takes in data from a number of flat files and puts a pretty, searchable interface on it. PHP comes to mind as a good candidate since it bridges the gap between HTML and your data very elegantly.
Divide responsibility for maintaining the data up into geographical chunks with roughly equivalent numbers of NIC members. Nominate people to manage the data set for their own region. One person for Australia, one for eastern Canada, one for western Canada, one for SoCal, one for NoCal, a couple for NJ, etc.
Give each of these people the file specifications so they can regularly email updated txt files to the uber-maintainer. Alternately, set up a little script to allow them to upload it directly to the server.
.
.
.
Actually, I just thought of an even more straightforward way. I add a few new fields to the profile information on NH and make a new searchable interface for displaying nerfer demographics. Then, everyone can just update their own damn data. Integrity would suffer but the work of maintaining the list would be ideally distributed.
#12
Posted 07 June 2004 - 06:58 PM
Considering almost all Nerfers frequent the forums, or at least one of each representative group, that's the easiest way to do it. I know when I go to compile information, forum location directories are the first place I look.Actually, I just thought of an even more straightforward way. I add a few new fields to the profile information on NH and make a new searchable interface for displaying nerfer demographics. Then, everyone can just update their own damn data. Integrity would suffer but the work of maintaining the list would be ideally distributed.
I think someone's contribution has been stolen.

- Death
#13
Posted 07 June 2004 - 09:01 PM
If you havnt clicked here yet, im basically employing a flash interface to select your country and then state, and possibly region for the larger more populated So Cal area's [and NJ?] which then open up a php file with the information presented in a still undecided format.
My dad is a rather unskilled IT teacher and he's inquiring with a few people about the possibility of uploading a .db file and using queries to select the necessary fields etc. but im not entirely sure about updating this all the time.
To the 'troubles' with flash, its no extra effort, apart from having to do one hell of a map for America, i've done the general world map here and it took me a couple of seconds with some free flash ready maps. The only challenging thing about this project will be entering all the information.
I do like the concept of having area managers, but i severly doubt whether any one could be bothered moderating their locale.
Any suggestions for fields?
- AKA Name [user nickname or something]
- Contact address [im guessing email address or something]
- General location [no direct addresses]
- Arsenal?
#14
Posted 17 June 2004 - 02:55 AM
Sounding better by the minute.
I'm going to publish an intro soon, and fill in the main flash content, via use of Flash 5 .swf files because producing in MX has struggled with codec errors [eg i cant view my own animations on the afforementioned links]
Any suggestions for INDB Fields?
#15
Posted 08 July 2004 - 06:10 AM
I've just updated the introduction. It's going to take a while to trace some new images of nerfers, but you'll understand once you see the intro. I'm having a few problems with the preloader and such. If you click here, wait 'till your status bar says it has completely loaded, other wise it will keep pausing to stream the heart-beat sound effect.
Anyway, i know, for the moment it's very homosexual. To say the least. I'm on school holidays [they end in three days] but once they end, i'll spend a bit of time after school with one of the IT teachers and get this all up and running. Just one thing. I'll probably need a MySQL server. And to be quite honest, I'm sure as hell not paying for that

#16
Posted 09 July 2004 - 01:09 AM
Just wanted to let you all know that i had finished the introduction animation. I would personally like to thank the NH galleries for providing the images that i traced for the animation. The file itself is 277kb so you'll have to wait a fair bit before its downloaded, and because of some major errors with the preloader, its better if you wait 'till it loads before hitting 'play', because it streams the audio, pausing the animation to run in direct speed with the audio.
On the whole project, i'm still waiting till i head back to school before i can actually start the project. It's looking bigger than ben hur. But i promise you guys, it will be good. Well, i hope it will ...

Anyway, check out the site intro here ...
Enjoy.
#17
Posted 09 July 2004 - 02:07 AM
I also seem to have become multi-national... don't tell Asscroft.
#18
Posted 09 July 2004 - 02:18 AM
You should be able to hear sound, it's just its a very subtle heart beat effect, so maybe you'll have to turn up the volume a fair bit.
Would NH be up to hosting the INDB. Because i cant really be bothered paying for a MySQL server when we have a perfectly good one here. Feel free to say no. There are plenty of other nerfers out there with domains...
As i said, its going to be a fair while until you see any real proof, as i'm waiting to see a techie at school to explain all the coding i'll need.
I'm going to include:
a browse my location function [built in flash] - and -
a search [probably .asp or .php ... will be able to search all database fields]
And then its just going to be a matter of entering and managing the information in a database. Unfortunately its probably going to be a sole database, not a australia.mdb, usa.mdb, uk.mdb set of databases ... But i might give certain people permission to upload there respective country.
So far, for countries, i have:
US of A;
Canada;
Australia;
UK;
Asia [Taiwan for 3DBBQ]; - and -
New Zealand [god only knows if there are any NZ nerfers...]
Thanks for accepting the fourth post in a row, i needed to tick over the topic, and we know an edit doesn't do that...
#19
Posted 09 July 2004 - 11:53 AM
If it's going to require mySQL, NH won't be hosting it. My account only allows one db and though you can micky mouse around that with table prefixes, I'd rather not.Would NH be up to hosting the INDB. Because i cant really be bothered paying for a MySQL server
[..snip..]
probably .asp or .php
If you have a choice between .asp and .php, always go with the latter. Asp is not as nice a language, is more platform dependant, and will probably end up abandoned by MS like active-x was last week.
#20
Posted 10 July 2004 - 05:42 AM
Bugger, but i guess another lovely, risk-taking, super kind person will . . .If it's going to require mySQL, NH won't be hosting it.

If you have a choice between .asp and .php, always go with the latter. Asp is not as nice a language, is more platform dependant, and will probably end up abandoned by MS like active-x was last week.
Yeah, it seems that most search pages revolve around a .asp file though. Anyway, i've been using PHP includes for a while now, and you can't beat them there includes.
The techie is going to give me all the source materials and instructions for php anyway, but having a look at some examples on sites has led me to believe asp's were common. Not to worry. I hope to get it up soon. This is looking good...

#21
Posted 14 July 2004 - 03:45 AM
ps: asp is aptly named. a poisonous snake. avoid it like one.
pps: your flash intro doesnt work
Edited by okto, 14 July 2004 - 03:46 AM.
#22
Posted 14 July 2004 - 05:23 AM
Egad, that would involve effort ... To gather this information in the first place, i would generally have to ask each individual person or set up some country and state managers like CX originally [and wisely] suggested. No can do for the moment ...do you have the actual text list of nerfers yet? post that online til you get the DB all worked out, so at least the info is accessible and we can search it with our browsers' find function (there surely arent enough entries to swamp it)
Heh, thats APS, but i get your drift anyway, its PHP all the way baby ...ps: asp is aptly named. a poisonous snake. avoid it like one.

Get the latest codec from the macromedia site [which is actually, a very old codec, you obviously don't update very oftenpps: your flash intro doesnt work

p.s. the update function is there for a reason
p.p.s. two can play at this game ...
#23
Posted 14 July 2004 - 05:29 AM
and the ps was to guide the reader as i would have spoken it.
#24
Posted 14 July 2004 - 07:31 AM
Anyway, it turns out im going to have to go after school and learn some of the coding and stuff myself. And then, and only then, will I even begin collaborating and collecting all the information for all the NIC. There's no real use collecting the information once, and having to display and convert it twice.
Sorry about the late reply, the thread subscription thing isn't working. I'm going to have to manually check for replies instead of just getting emails now ...
#25
Posted 14 July 2004 - 10:43 AM
Stop in, and Me and the rest of the staff will see what we can do.
Edited by Alexthebeast, 14 July 2004 - 10:45 AM.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users