I have purchased a mod for a arcade. This mod will allow users to use there points they get to buy items. In a earlier version of the arcade not the mod images where able to be shown, now that I have a newer arcade version the images do not. There is a area for items
"CREATE TABLE IF NOT EXISTS `ava_items_shop` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT,
`name` VARCHAR( 255 ) NOT NULL,
`image` VARCHAR( 255 ) NOT NULL,
`price` INT( 10 ) NOT NULL,
`type` TINYINT( 4 ) NOT NULL,
`active` TINYINT ( 1 ) NOT NULL,
`category` VARCHAR( 255 ) NOT NULL DEFAULT 'None',
`attribute` VARCHAR( 255 ) NOT NULL DEFAULT 'None',
PRIMARY KEY ( `id` )
) ENGINE=MyISAM ;";
this is for the admin side pretty much as you can see there is a image above.
now for the user side table
"CREATE TABLE IF NOT EXISTS `ava_items_user` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT,
`item_id` INT( 11 ) NOT NULL,
`user_id` INT( 11 ) NOT NULL,
`active` TINYINT( 1 ) NOT NULL,
`time` VARCHAR( 12 ) NOT NULL,
PRIMARY KEY ( `id` )
) ENGINE=MyISAM ;";
I have tried to add the image table from above to this one and no go.
any help on this would be grateful.
I have added the 2 sql / php files that deal with the uploading of the sql to my server.
[attachment deleted by admin]