If I have my site made with version 1.3 and try to change it to 1.4, I can cause errors that harm the database of my players?
CREATE TABLE IF NOT EXISTS `znote_images` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL,
`desc` text NOT NULL,
`date` int(11) NOT NULL,
`status` int(11) NOT NULL,
`image` varchar(30) NOT NULL,
`account_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_forum` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`access` tinyint(4) NOT NULL,
`closed` tinyint(4) NOT NULL,
`hidden` tinyint(4) NOT NULL,
`guild_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES
('Staff Board', '4', '0', '0', '0'),
('Tutors Board', '2', '0', '0', '0'),
('Discussion', '1', '0', '0', '0'),
('Feedback', '1', '0', '1', '0');
CREATE TABLE IF NOT EXISTS `znote_forum_threads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`forum_id` int(11) NOT NULL,
`player_id` int(11) NOT NULL,
`player_name` varchar(50) NOT NULL,
`title` varchar(50) NOT NULL,
`text` text NOT NULL,
`created` int(11) NOT NULL,
`updated` int(11) NOT NULL,
`sticky` tinyint(4) NOT NULL,
`hidden` tinyint(4) NOT NULL,
`closed` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_forum_posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`thread_id` int(11) NOT NULL,
`player_id` int(11) NOT NULL,
`player_name` varchar(50) NOT NULL,
`text` text NOT NULL,
`created` int(11) NOT NULL,
`updated` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Paygol don't working? I make a successful purchase, but I'm still with 0 points in my account.
Should work but I havent been able to test it out properly. I am considering redoing the paypal and paygol ipns for version 1.5, or as a patch to 1.4 if it dosn't work properly.
You need to edit config.php and write correct serviceId for paygol to make it work.
Shouldn't be any problem, but to make forum and image gallery work you need to add the new tables:
SQL:CREATE TABLE IF NOT EXISTS `znote_images` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, `desc` text NOT NULL, `date` int(11) NOT NULL, `status` int(11) NOT NULL, `image` varchar(30) NOT NULL, `account_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_forum` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `access` tinyint(4) NOT NULL, `closed` tinyint(4) NOT NULL, `hidden` tinyint(4) NOT NULL, `guild_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES ('Staff Board', '4', '0', '0', '0'), ('Tutors Board', '2', '0', '0', '0'), ('Discussion', '1', '0', '0', '0'), ('Feedback', '1', '0', '1', '0'); CREATE TABLE IF NOT EXISTS `znote_forum_threads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `forum_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `player_name` varchar(50) NOT NULL, `title` varchar(50) NOT NULL, `text` text NOT NULL, `created` int(11) NOT NULL, `updated` int(11) NOT NULL, `sticky` tinyint(4) NOT NULL, `hidden` tinyint(4) NOT NULL, `closed` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `znote_forum_posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `thread_id` int(11) NOT NULL, `player_id` int(11) NOT NULL, `player_name` varchar(50) NOT NULL, `text` text NOT NULL, `created` int(11) NOT NULL, `updated` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
ALTER TABLE `znote_accounts` ADD `cooldown` int(10) DEFAULT 0;
Yes! Forgot about that. xDAnd this:
SQL:ALTER TABLE `znote_accounts` ADD `cooldown` int(10) DEFAULT 0;
No?
-----------------------------
AND paygol not work for me xP
string(43) "SELECT `name` FROM `players` WHERE `id` = ;"
(query - SQL error)
Type: select_single (select single row from database)
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 '' at line 1