A small request

[daniely]

the store hack files

[MindTrix]

Ok well post the error message you are getting over in the Store Hack thread and i will try my best to help you there

[daniely]

I get this
Database error in vBulletin Control Panel 2.3.3:

Invalid SQL: CREATE TABLE `store` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`action` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`costs` varchar(255) NOT NULL default '',
`sold` smallint(5) default '0',
`imgurl` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`ok` char(1) NOT NULL default '',
`quantity` smallint(5) default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

#
# Gegevens worden uitgevoerd voor tabel `store`
#

INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (1, 'username', 'Change Username', '500', 0, 'username.gif', 'With this action you can change your username', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (2, 'customtitle', 'Change Custom Title', '300', 0, 'title.gif', 'With this action you can get a custom title and if you dont have one already then get one', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (3, 'customavatar', 'Change Custom Avatar', '700', 0, 'avatar.gif', 'With this action you can get a custom avatar or if you already one you can change it...', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (4, 'givetitle', 'Give an other user a custom title', '700', 6, 'givetitle.gif', 'With this action you can give an other user a custom title. The title that you give will be showed on every post of that user. <br><b>Tip:</b> Do it when that user dont have enough money to restore his custom title ', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (5, 'donate', 'Donate money to an other user', '0', 0, 'donate.gif', 'With this free action you can donate money to other members.', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (6, 'scrap', 'Scrap your yellow/red card', '700', 0, 'card.gif', 'With this action you can scrap your yellow/red card. Want to become a mod but have a yellow/red card? Do this action to begin with a new veb life ', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (7, 'calendar', 'Add Calendar Event', '500', 0, 'calendar.gif', 'With this action you can add a public calendar event on the calendar', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (8, 'glowusername', 'Add Glow To Username', '2000', 0, 'glow.gif', 'With this action you can add an attractive glowing color to your username wich you can define yourself. If you have already a glow then you can change it here aswell.', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (9, 'midi', 'Buy A Midi Song For Your Profile', '500', 0, 'midi.gif', 'This action gives you the ability to buy a Midi Song for your profile. The midi song will be played on the background while a member is viewing your profile.', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (10, 'sticky', 'Buy The Sticky Feature', '1000', 0, 'sticky.gif', 'This action gives you the ability to stick any thread. 1 Sticky per buy.', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (11, 'italic', 'Buy An Italic Username', '500', 0, 'italic.gif', 'This action gives you the ability to display your username in the postbit as italic.', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (12, 'lastvisit', 'See Someones Last Visit', '2000', 0, 'lastvisit.gif', 'With this action you enable the feature where you can see someones last visit on this board. U can see someones last visit on their profile, from everyone.', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (13, 'givemidi', 'Donate A Midi Song', '5000', 0, 'givemidi.gif', 'You can give another member a midi song, the song will be played on his/her profile.', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (14, 'custombold', 'Buy A Bold Custom Title', '5000', 0, 'customb.gif', 'You can make your custom title a bit more fancy with this action, your custom title will be in bold presented after buying this action.', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (15, 'customsmilies', 'Show Smilies In Your Custom Title', '4000', 0, 'customs.gif', 'Any smilie will be showed on your custom title from now on if you buy this action.', 'Y', 0);
INSERT INTO `store` (`id`, `action`, `title`, `costs`, `sold`, `imgurl`, `description`, `ok`, `quantity`) VALUES (16, 'floodlimit', 'Buy a less floodlimit', '2500', 0, 'flood.gif', 'This action gives you the ability to buy a less floodlimit. So you can post a post faster after eachother.', 'Y', 0);
# --------------------------------------------------------

#
# Table structure for tabel `storeaction`
#

DROP TABLE IF EXISTS `storeaction`;
CREATE TABLE `storeaction` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`postuserid` int(20) NOT NULL default '0',
`postid` int(20) NOT NULL default '0',
`postusername` varchar(255) NOT NULL default '',
`userid` int(20) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`what` varchar(255) NOT NULL default '',
`ddate` int(11) NOT NULL default '0',
`reason` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;


#
# Table structure for tabel `storeadmin`
#
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';

#
# Gegevens worden uitgevoerd voor tabel `store`
#

I

mysql error number: 1064

Date: Friday 19th of December 2003 09:22:15 PM
Script: http://www.number3p.com/forums
Referer: http://www.number3p.com/forums/admin/query.php?t=0&

and this
Parse error: parse error, unexpected ':' in e:\domains\n\number3p.com\user\htdocs\forums\index .php on line 57

[MindTrix]

Is that when using fireflys msql hack?

[daniely]

yes the first one is. and the second one is on the homepage after uploading the store hack script changes.

[MindTrix]

Hmmm well to be honest with you, the MYSQL error you better post over in the Thread for Fire flys mysql hack. And the other one in the store hack thread.

Once you've posted in the store thread ill try to help you out