| Author |
Message |
Desbrina
Jadeite
Joined: 11 Jun 2005
Posts: 2963
Location: Earth
|
 Posted: Mon Dec 03, 2007 7:11 am Post subject: inventory type system required |
 |
|
I've been trying to make an inventory type thing for my website so that users dont need their own websites but i'm not getting far so i'm requesting some one to help
The amount of VSP you want is up to you, i dont know how hard this sort of thing is
The values for the inventory are stored in a database, along with the users settings
user_inventory - contains the users items
| Code: | CREATE TABLE `user_inventory` (
`ID` int(11) NOT NULL auto_increment,
`user_ID` int(11) NOT NULL COMMENT 'User ID of th user',
`name` text NOT NULL COMMENT 'Name of the user',
`item` text NOT NULL,
`status` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
user_settings - contains the users settings
| Code: | CREATE TABLE `user_settings` (
`ID` int(11) NOT NULL auto_increment,
`user_ID` int(11) NOT NULL COMMENT 'User ID of th user',
`level` text NOT NULL,
`link` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
There are another 2 tables that are related.
level in user_settings and link in user_settings are related to link and banners table
link - contains the IDs of the link button used. Link corresponds to ID
| Code: | CREATE TABLE `link` (
`ID` int(11) NOT NULL auto_increment,
`url` text NOT NULL,
`alttext` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
level - contains that id of the level banner used. level corresponds to ID
| Code: | CREATE TABLE `banners` (
`ID` int(11) NOT NULL auto_increment,
`set` int(11) NOT NULL,
`level` int(11) NOT NULL,
`url` text NOT NULL,
`alttext` text NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ; |
I'm looking for a system where the users has the ability to edit the "template", moving the items around, just by typing certain things
IE: to put in the will trade cards, they just have to type something along the lines of [Will Trade]
I'll let you decide the best way of storing the individual users templates
If you need more of an explanation let me know
_________________
Midnight Tempest - A Sailor Moon TCG
Balanced Force - A Star Wars TCG |
|
| Back to top |
|
| |
Soki
Novice Poster
Joined: 25 Jan 2008
Posts: 38
Location: 127.0.0.1
|
|
| Back to top |
|
| |
RohitMalhotra
The Crazy One
Joined: 14 May 2005
Posts: 852
Location: __________ ~~/[[[zzz::: Some Where In The Northern Sector :::zzz]]]\~~________
|
|
| Back to top |
|
| |
Desbrina
Jadeite
Joined: 11 Jun 2005
Posts: 2963
Location: Earth
|
|
| Back to top |
|
| |
Soki
Novice Poster
Joined: 25 Jan 2008
Posts: 38
Location: 127.0.0.1
|
| Posted: Sat Jan 26, 2008 3:12 pm Post subject: |
|
|
| RohitMalhotra wrote: | Thanks Soki these links were very helpful .. to me ...
rohit Malhotra
hope desberina was able to solve her problems .. |
Your very welcome :]
| Desbrina wrote: | | I got it sorted out a while ago now |
Ok. Well atleast I helped someone xD |
|
| Back to top |
|
| |
|
|
|
Forum FAQs 
Knowledge Base 
Memberlist 
Usergroups 
Hosting
Register
Donate 
Profile 
Log in 
