TheFalseDragon

nothing has been done and i plan to make it using mysql but however here comes the helping bit

1- I'm not too sure on the best way to sort this for sake of solving errors/problems that may arrise
2- I have no idea how to link a database to a php file so that the php file can add to and edit and read the database
3- It needs to be as small as possible so if there is a more compact way to make a database please do tell

ALSO as a final bid for help if someone can help me out via msn to get me to learn this a bit faster (the syntax isn't so hard i just keep forgetting the commands and using the ones that i think it should be) that that'd be great

oh and to help you out the incomplete list of the values i will need to add to this and size is a REAL issue here. don't wanna have to pay more money :eek:
<!-- tbl_items -->
itemid
itemname
itemmsg
itemcost
itemrarity
itemevent
<!-- tbl_eventhap -->
eventlast
eventlaststampsup
eventlastsup
eventlaststamprare
eventlastrare
eventlaststampcom
eventlastcom
eventcounter
<!-- tbl_shop -->
shopbg
shoplogo
shopmsg
shopinfo
shopsalelist
shoptill
<!-- tbl_shpitem -->
shopitemuser
shopitemlist
shopitemno
shopitemprice
<!-- tbl_pet -->
petid
petownid
petplaceno
petname
petborn
pethp
petmaxhp
petstr
petdef
pettype
petcolour
<!-- tbl_fight -->
fightpethist
fightwin
fightlose
fightdraw
fightsend
fightrecieve
fightxptot
<!-- tbl_im -->
imid
imsend
imrecieve
imsub
immsg
<!-- tbl_trade -->
tradeid
tradewish
tradeowner
tradeit1
tradeit2
tradeit3
tradeit4
tradeit5
tradeit6
tradeit7
tradeit8
tradeit9
tradeit10
tradeit11
tradeit12
tradeit13
tradeit14
tradeit15
tradeit16
tradeit17
tradeit18
tradeit19
tradeit20
tradeoffers
<!-- tbl_event -->
eventtarusr
eventtrade
eventim
eventfight
eventcauseusr
<!-- tbl_users -->
userid
userpass
useremail
usercontact
userlastlog
useractpet
username
userjoin
user13
useraward1
useraward2
useraward3
useraward4
useraward5


that all the ones i can think about now but i may be adding more later

all help greatfully accepted.

kirkl_uk

I reccommend you sort a proper structure for the database itself first. This is the kind of thing you will need a good book for, unless someone on here is willing to dedicate some time to try and organise this for you. When you're done sorting the structure, I can help you on MSN with setting up the links between PHP and the DB.

__________________
kirkl_uk

TheFalseDragon

thats the thing i've never really made a database like this, i'm planning it but its hard, i'm hoping that in the next few days i'll be able to start working on the database and the site. ps thanks a ton for offering to help over msn.

TheFalseDragon

i've started working on my database, as you may see if you looked before i've made quite a few changes to the first post.

kirkl_uk

Yeah, I can see the progress now . I think you should create a UserAward table and another to link users to awards rather than:

useraward1
useraward2
useraward3
useraward4
useraward5

Some people might not agree with that tho, but I think it's the best way.

__________________
kirkl_uk

Pizentios

i always create my db's on paper first almost like a flow chart. That way i can see them before i start programming, and make changes etc before the thing is created.

__________________
Profanity is the one language that all programmers understand.

Check out my Blog <---updated Nov 30 2007!

Infinite Recursion

My larger DB projects are laid out on a huge wet/dry board.

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

Pizentios

yeah that works too, but i don't have the luxuray of a big ass white board....so paper or DIA (a open source app like microsoft visio) is what i use :-)

DIA is quite a good program (and it's free as in beer), it's even got tools to help you map out networks and such. http://www.gnome.org/projects/dia/ for more info.

__________________
Profanity is the one language that all programmers understand.

Check out my Blog <---updated Nov 30 2007!

EdSalamander

Dia's great. It's what I use to layout my UML whenever I'm designing a big object-oriented project in Linux. When I'm in Windows (which is most of the time) I use AgroUML. It's not as solid a program, but it's still very useful. Technically, all it can make is UML, but I'm sure you could still use it for showing database relationships. It was written in Java so it should run on most platforms. Oh, and it's opensource and free (unlike visio).

__________________
I can pick my friends. And I can pick my nose. So, why can't I pick my friend's nose?

Berto

look up 3rd and 4th normal form for rationalising the databases, to make them more efficient and reduce the repeated fields.

(tyesi no it goes to about 7th NF)

__________________
"Put your hand on a hot stove for a minute, and it seems like an hour. Sit with a pretty girl for an hour, and it seems like a minute. THAT'S relativity."

- Albert Einstein