GhostSnyper

Along with my server I've been developing, i've come up with a design for database storage that will allow for very quick way to retrieve items. The whole design is complex, so for now, I'll be showing you how it looks database-side. As you know, most old school servers use a file called item.cfg, which stores all information about items. It looks like this... http://i142.photobucket.com/albums/r116/ghostsnyper/item-cfgfile.jpg This is a HUGE wast of space, because of the way it's formatted. That style of configuration, which is used in more than 80% of sources uses the following style: item = [item ID] [Name of Item] [Description of item] [lowalch value] [high alch value] [next 10 numbers are stat bonuses] Now because of this style, it allows weapons and armor to be configured in there; unfortunately, 95% of the items listed in there do NOT require status modifications. Keeping that in mind, for 95% of those items, we just wasted 8-10 bytes of data. Not a lot, but in a programmer's sense, that is unacceptable. Now I've taken some time to develop my new concept. It's a work in progress, but I've got two tables fully set up, and with data in them (one of them is complete). Now As I've mentioned about the item,cfg, not every item needs bonuses, so I've made a table specifically for the base information about the items. It looks like so: http://i142.photobucket.com/albums/r116/ghostsnyper/itemdefinitions.jpg Now that alone just cut the storage requirements of the item configuration file in HALF! Also, if you've noticed, the database solution doesn't have _ for spaces, as you see in the configuration file. I'll go into detail about that in my next thread. Continuing on, I had to find a proper solution for the offensive and defensive items. If you will notice, there are several files on top of that that that help describe these items. A good example is 2handed.dat... It's a file whose sole intention is to list to two handed items; it's all clutter. I've taken a solution and took it a step further. Rather than having attack speeds hard-coded into the server, save space and make it dynamically loaded from the database! http://i142.photobucket.com/albums/r116/ghostsnyper/itemweaponconfiguration.jpg Now that isn't finished, because I am writing a program that can get their proper bonus values from the RuneScape website. If that doesn't go well I'll have to ask around to see if I can get the accurate bonuses That's all I got to show right now. The other parts of the database are currently in the design process, so I don't wanna sow anything premature

Don't diss on the VW. That generation of the GTI put out huge pwer to weight numbers. My buddy has one that's tuned, and it chirps in every gear. It also smokes half the guys at the track. Old cars are liked for the reason that they're reliable.

Way too long ago, can't find it if I wanted to. Can't even find my dad, if I wanted to

I loved that car so much, and my dad said it was mine as soon as I had a license

My dad owned one and I helped build it three times... First build had 450hp and 540ftlbs, we blew that out, The second build was 630 hp and 700 ft lbs, we broke the engine and half the car in a wheelie comp, and the third build was 1,050 hp and 1300ft lbs of torque... The blower on that thing was huge... After that, my dad sold it off when he got hardcore into drugs.. The color on it was beautiful.. It was red, but it had a burgundy-brown swirl mixed into the color. I'll never speak to my dad again because of it

Well I am going to own these three cars when I'm older, so I might as well put them all here for you 1990-91 Mazda RX-7 Savannah Turbo II http://www.toadhallcars.com/CarPhotosWeb/rx7t.jpg http://memimage.cardomain.com/ride_images/3/335/4841/25837420001_large.jpg 1992-1996 Nissan Skyline GT-R http://i232.photobucket.com/albums/ee18/motowipeout/800px-Nissan_Skyline_R32_GT-R_001.jpg http://i232.photobucket.com/albums/ee18/motowipeout/800px-Nissan_Skyline_R32_GT-R_002.jpg 1968 Chevrolet Nova SS (I had one of these at one point, dad sold it for drug monies :/) http://forum.avtoindex.com/foto/data/media/27/Nova_SS_396_1970_1.jpg

Come Fly with Me - Frank Sinatra Next on the playlist, The Perfect Mix 215, by DJ Eros

http://i142.photobucket.com/albums/r116/ghostsnyper/Background.jpg

DAT BUNKBED http://cdn1.knowyourmeme.com/i/2202/original/Link_Dat_Ass.png

Oh my. 8/10! (he's been inactive in the scene for years)

Yes I do

I played the bata. It's seriously Bungie's best Halo ever. I honestly think it's better than the first, and that's saying a lot

Children can't run a forum, whilst professional-acting children have a shot at success. Congrats to Duke

That's what she said

THread deletion

mmmm pie

gargle

Disbelief of postcount++

no u

maybe a wax

Buttered anime chicks!

Delicious

Spam

Hello everyone... Some may know of my developing abilities, and a few take it as a hobby to watch what I'm doing. If you would like, you can join them in watching me. I'll be posting my TeamViewer details here, and post whether i am live or offline. As many can watch as they like, and if you want, add me on msn to ask some questions. I also voice chat, so feel free to say hi Status: Offline Team Viewer ID: 529 800 803 Password : 5403

http://sphotos.ak.fbcdn.net/hphotos-ak-ash2/hs035.ash2/35089_101217186600038_100001352702650_6742_5365734_n.jpg