View Single Post
Old Jun 21st, 2005, 3:06 PM   #1
TheFalseDragon
Programmer
 
TheFalseDragon's Avatar
 
Join Date: Jun 2005
Location: |\|[][]B |_4|\|D
Posts: 41
Rep Power: 0 TheFalseDragon is on a distinguished road
Post Need help creating a database, php related

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.

Last edited by TheFalseDragon; Jun 22nd, 2005 at 9:38 PM. Reason: Update in infomation
TheFalseDragon is offline   Reply With Quote