осталось только проверить, точнее скачать когданибудь и установить :([DOUBLEPOST=1381545012,1380483366][/DOUBLEPOST]поделитесь кто нибудь этим модулем, кому нежалко... а то я тут фиг когда скачаю...
Никто с Вами не поделиться. Если не хотите зарабатывать симпатии, то купите доступ, подробнее тут...
Да, все верно, нет там возможности продажи цифровых товаров =(
Mysqli statement execute error : Incorrect string value: '\xD0\x9F\xD0\xB5\xD1\x80...' for column 'product_name' at row 1<?php
class Ice_Shop_Install{
public static function install(){
$db = XenForo_Application::get('db');
$db->query("
CREATE TABLE IF NOT EXISTS `xf_ice_shop_products` (
`product_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`product_name` varchar(255) COLLATE ascii_bin NOT NULL,
`product_description` longtext COLLATE ascii_bin NOT NULL,
`usergroups` varbinary(255) NOT NULL,
`price_perday` int(11) unsigned NOT NULL,
`price_perweek` int(11) unsigned NOT NULL,
`price_permonth` int(10) unsigned NOT NULL,
`price_lifetime` int(10) unsigned NOT NULL,
PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;");
$db->query("
CREATE TABLE IF NOT EXISTS `xf_ice_shop_purchases` (
`purchase_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`product_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`users` varchar(200) COLLATE ascii_bin NOT NULL,
`expired` tinyint(1) NOT NULL,
`purchase_date` int(10) unsigned NOT NULL,
`autorenew` tinyint(1) NOT NULL,
`term_price` int(11) unsigned NOT NULL,
`term_length` int(10) NOT NULL,
PRIMARY KEY (`purchase_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;");
$exists = $db->fetchAll("SELECT * FROM xf_content_type_field WHERE field_value LIKE 'Ice_Shop%'");
if(!$exists){
$db->query("
INSERT INTO xf_content_type_field
(content_type, field_name, field_value)
VALUES
('shop_arfailure', 'alert_handler_class', 'Ice_Shop_AlertHandler_ARFailure')");
}
}
public static function uninstall(){
$db = XenForo_Application::get('db');
$db->query("DROP TABLE xf_ice_shop_purchases");
$db->query("DROP TABLE xf_ice_shop_products");
$db->query("DELETE FROM xf_content_type_field WHERE content_type='shop_arfailure'");
}
}<?php
class Ice_Shop_Install{
public static function install(){
$db = XenForo_Application::get('db');
$db->query("
CREATE TABLE IF NOT EXISTS `xf_ice_shop_products` (
`product_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`product_name` varchar(255) COLLATE utf8_general_ci NOT NULL,
`product_description` longtext COLLATE utf8_general_ci NOT NULL,
`usergroups` varbinary(255) NOT NULL,
`price_perday` int(11) unsigned NOT NULL,
`price_perweek` int(11) unsigned NOT NULL,
`price_permonth` int(10) unsigned NOT NULL,
`price_lifetime` int(10) unsigned NOT NULL,
PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;");
$db->query("
CREATE TABLE IF NOT EXISTS `xf_ice_shop_purchases` (
`purchase_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`product_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`users` varchar(200) COLLATE utf8_general_ci NOT NULL,
`expired` tinyint(1) NOT NULL,
`purchase_date` int(10) unsigned NOT NULL,
`autorenew` tinyint(1) NOT NULL,
`term_price` int(11) unsigned NOT NULL,
`term_length` int(10) NOT NULL,
PRIMARY KEY (`purchase_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;");
$exists = $db->fetchAll("SELECT * FROM xf_content_type_field WHERE field_value LIKE 'Ice_Shop%'");
if(!$exists){
$db->query("
INSERT INTO xf_content_type_field
(content_type, field_name, field_value)
VALUES
('shop_arfailure', 'alert_handler_class', 'Ice_Shop_AlertHandler_ARFailure')");
}
}
public static function uninstall(){
$db = XenForo_Application::get('db');
$db->query("DROP TABLE xf_ice_shop_purchases");
$db->query("DROP TABLE xf_ice_shop_products");
$db->query("DELETE FROM xf_content_type_field WHERE content_type='shop_arfailure'");
}
}
у меня все работает ))
