What's new
Xen Factory

Register today to become a member! Once signed in, you'll be able to start purchasing our products, ask questions, request support and suggest new ideas!

  • This area is dedicated to the support of our xF1 add-ons. For xF2, please use the dedicated area: HERE.
  • We are aware that a no permission error was shown when you tried to purchase in the last 2 days, this is now fixed.

Support Fixed XFA RM - Xenforo Default Error Message on Comercial

Clement

Freaky Coder
Staff member
Could you please show me a db extract of the row for the litebans HCF resources in xf_resource table ?
 

bloxian

New Member
SQL
Code:
-- phpMyAdmin SQL Dump
-- version 4.5.4.1deb2ubuntu2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 09, 2017 at 02:33 PM
-- Server version: 5.7.19-0ubuntu0.16.04.1-log
-- PHP Version: 7.0.22-0ubuntu0.16.04.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `mctrades`
--

-- --------------------------------------------------------

--
-- Table structure for table `xf_resource`
--

CREATE TABLE `xf_resource` (
  `resource_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(100) NOT NULL DEFAULT '',
  `tag_line` varchar(100) NOT NULL DEFAULT '',
  `user_id` int(10) UNSIGNED NOT NULL,
  `username` varchar(100) NOT NULL DEFAULT '',
  `resource_state` enum('visible','moderated','deleted') NOT NULL DEFAULT 'visible',
  `resource_date` int(10) UNSIGNED NOT NULL,
  `resource_category_id` int(11) NOT NULL,
  `current_version_id` int(10) UNSIGNED NOT NULL,
  `description_update_id` int(10) UNSIGNED NOT NULL COMMENT 'Points to the resource update that acts as the description for this resource',
  `discussion_thread_id` int(10) UNSIGNED NOT NULL COMMENT 'Points to an automatically-created thread for this resource',
  `external_url` varchar(500) NOT NULL DEFAULT '',
  `is_fileless` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `external_purchase_url` varchar(500) NOT NULL DEFAULT '',
  `price` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
  `currency` varchar(3) NOT NULL DEFAULT '',
  `download_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `rating_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `rating_sum` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `rating_avg` float UNSIGNED NOT NULL DEFAULT '0',
  `rating_weighted` float UNSIGNED NOT NULL DEFAULT '0',
  `update_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `review_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_update` int(10) UNSIGNED NOT NULL,
  `alt_support_url` varchar(500) NOT NULL DEFAULT '',
  `had_first_visible` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `custom_resource_fields` mediumblob NOT NULL,
  `prefix_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `icon_date` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tags` mediumblob NOT NULL,
  `custompg_paypal_email` varchar(500) DEFAULT NULL,
  `custompg_validation` tinyint(4) NOT NULL DEFAULT '0',
  `resource_cover_image` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `resource_cover_color` varchar(7) NOT NULL DEFAULT '0',
  `resource_cover_date` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `resource_cover_width` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `resource_cover_height` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `resource_cover_crop_x` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `resource_cover_crop_y` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `resource_cover_state` enum('visible','moderated','deleted') DEFAULT 'visible',
  `xfa_rmdonations_paypal` varchar(250) NOT NULL DEFAULT '',
  `xfa_rmdonations_bitcoin` varchar(250) NOT NULL DEFAULT '',
  `xfa_rmdonations_paypal_def` varchar(10) NOT NULL DEFAULT '',
  `xfa_rmdonations_bitcoin_def` varchar(10) NOT NULL DEFAULT '',
  `xfa_rmmp_type` enum('none','digital','physical','service') NOT NULL DEFAULT 'none',
  `xfa_rmmp_amount` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
  `xfa_rmmp_currency` varchar(3) NOT NULL DEFAULT '',
  `xfa_rmmp_paypal` varchar(255) DEFAULT NULL,
  `xfa_rmmp_accept_other` tinyint(1) NOT NULL DEFAULT '0',
  `xfa_rmmp_purchases` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `xfa_rmmp_cgv` mediumtext NOT NULL,
  `xfa_rmmp_img_date` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `xf_resource`
--

INSERT INTO `xf_resource` (`resource_id`, `title`, `tag_line`, `user_id`, `username`, `resource_state`, `resource_date`, `resource_category_id`, `current_version_id`, `description_update_id`, `discussion_thread_id`, `external_url`, `is_fileless`, `external_purchase_url`, `price`, `currency`, `download_count`, `rating_count`, `rating_sum`, `rating_avg`, `rating_weighted`, `update_count`, `review_count`, `last_update`, `alt_support_url`, `had_first_visible`, `custom_resource_fields`, `prefix_id`, `icon_date`, `tags`, `custompg_paypal_email`, `custompg_validation`, `resource_cover_image`, `resource_cover_color`, `resource_cover_date`, `resource_cover_width`, `resource_cover_height`, `resource_cover_crop_x`, `resource_cover_crop_y`, `resource_cover_state`, `xfa_rmdonations_paypal`, `xfa_rmdonations_bitcoin`, `xfa_rmdonations_paypal_def`, `xfa_rmdonations_bitcoin_def`, `xfa_rmmp_type`, `xfa_rmmp_amount`, `xfa_rmmp_currency`, `xfa_rmmp_paypal`, `xfa_rmmp_accept_other`, `xfa_rmmp_purchases`, `xfa_rmmp_cgv`, `xfa_rmmp_img_date`) VALUES
(90, 'Litebans HCF Messages ✔', 'Litebans HCF Messages', 1372, 'Jacob', 'visible', 1507000098, 5, 99, 100, 4777, '', 0, '', '1.00', 'usd', 3, 0, 0, 0, 3, 0, 0, 1507000098, '', 1, 0x613a313a7b733a32313a227265736f757263655f636f6e7472696275746f7273223b733a383a22466f6f7472657374223b7d, 0, 0, 0x613a303a7b7d, '', 0, 0, '0', 0, 0, 0, 0, 0, 'visible', 'admin@buildblox.net', 'admin@buildblox.net', '5', '0.1', 'digital', '1.00', 'USD', 'admin@buildblox.net', 0, 0, '', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `xf_resource`
--
ALTER TABLE `xf_resource`
  ADD PRIMARY KEY (`resource_id`),
  ADD KEY `category_last_update` (`resource_category_id`,`last_update`),
  ADD KEY `category_rating_weighted` (`resource_category_id`,`rating_weighted`),
  ADD KEY `last_update` (`last_update`),
  ADD KEY `rating_weighted` (`rating_weighted`),
  ADD KEY `user_id_last_update` (`user_id`,`last_update`),
  ADD KEY `discussion_thread_id` (`discussion_thread_id`),
  ADD KEY `prefix_id` (`prefix_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `xf_resource`
--
ALTER TABLE `xf_resource`
  MODIFY `resource_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
PHP Array
PHP:
<?php
/**
 * Export to PHP Array plugin for PHPMyAdmin
 * @version 0.2b
 */

//
// Database `mctrades`
//

// `mctrades`.`xf_resource`
$xf_resource = array(
  array('resource_id' => '90','title' => 'Litebans HCF Messages ✔','tag_line' => 'Litebans HCF Messages','user_id' => '1372','username' => 'Jacob','resource_state' => 'visible','resource_date' => '1507000098','resource_category_id' => '5','current_version_id' => '99','description_update_id' => '100','discussion_thread_id' => '4777','external_url' => '','is_fileless' => '0','external_purchase_url' => '','price' => '1.00','currency' => 'usd','download_count' => '3','rating_count' => '0','rating_sum' => '0','rating_avg' => '0','rating_weighted' => '3','update_count' => '0','review_count' => '0','last_update' => '1507000098','alt_support_url' => '','had_first_visible' => '1','custom_resource_fields' => 'a:1:{s:21:"resource_contributors";s:8:"Footrest";}','prefix_id' => '0','icon_date' => '0','tags' => 'a:0:{}','custompg_paypal_email' => '','custompg_validation' => '0','resource_cover_image' => '0','resource_cover_color' => '0','resource_cover_date' => '0','resource_cover_width' => '0','resource_cover_height' => '0','resource_cover_crop_x' => '0','resource_cover_crop_y' => '0','resource_cover_state' => 'visible','xfa_rmdonations_paypal' => 'admin@buildblox.net','xfa_rmdonations_bitcoin' => 'admin@buildblox.net','xfa_rmdonations_paypal_def' => '5','xfa_rmdonations_bitcoin_def' => '0.1','xfa_rmmp_type' => 'digital','xfa_rmmp_amount' => '1.00','xfa_rmmp_currency' => 'USD','xfa_rmmp_paypal' => 'admin@buildblox.net','xfa_rmmp_accept_other' => '0','xfa_rmmp_purchases' => '0','xfa_rmmp_cgv' => '','xfa_rmmp_img_date' => '0')
);
 
Last edited:

Clement

Freaky Coder
Staff member
Hum, but if that field was set it means the resource was previously an external purchase one ?
 

bloxian

New Member
I'm unable to set it blank, it forces it to be "0.00" or a proper numerical value such as "1.00". Do I make it null? Also free resources still can't be non-commercial.

Here's the php array of a free resource:
Code:
<?php
/**
 * Export to PHP Array plugin for PHPMyAdmin
 * @version 0.2b
 */

//
// Database `mctrades`
//

// `mctrades`.`xf_resource`
$xf_resource = array(
  array('resource_id' => '87','title' => 'BroadcastSigns','tag_line' => '[FREE] Customizeable Prefix | Clickable Sign','user_id' => '3938','username' => 'S1ant','resource_state' => 'visible','resource_date' => '1506619639','resource_category_id' => '9','current_version_id' => '96','description_update_id' => '96','discussion_thread_id' => '4566','external_url' => '','is_fileless' => '0','external_purchase_url' => '','price' => '0.00','currency' => '','download_count' => '1','rating_count' => '0','rating_sum' => '0','rating_avg' => '0','rating_weighted' => '3','update_count' => '0','review_count' => '0','last_update' => '1506619639','alt_support_url' => 'https://bukkit.org','had_first_visible' => '1','custom_resource_fields' => 'a:2:{s:10:"mcversions";s:5:"1.8.9";s:21:"resource_contributors";s:17:"Me, Myself, and I";}','prefix_id' => '0','icon_date' => '1506564110','tags' => 'a:0:{}','custompg_paypal_email' => '','custompg_validation' => '0','resource_cover_image' => '0','resource_cover_color' => '0','resource_cover_date' => '0','resource_cover_width' => '0','resource_cover_height' => '0','resource_cover_crop_x' => '0','resource_cover_crop_y' => '0','resource_cover_state' => 'visible','xfa_rmdonations_paypal' => 'admin@buildblox.net','xfa_rmdonations_bitcoin' => 'admin@buildblox.net','xfa_rmdonations_paypal_def' => '5','xfa_rmdonations_bitcoin_def' => '0.1','xfa_rmmp_type' => 'digital','xfa_rmmp_amount' => '0.00','xfa_rmmp_currency' => '','xfa_rmmp_paypal' => '','xfa_rmmp_accept_other' => '0','xfa_rmmp_purchases' => '0','xfa_rmmp_cgv' => '','xfa_rmmp_img_date' => '0')
);
 

Clement

Freaky Coder
Staff member
Yes 0.00 is fine.

You can't put a free resource as being digital as per xfa_rmmp_type, that doesn't make sense, this field is set only when a resource is paid.
 

bloxian

New Member
Would you be able to create me an SQL query for that?

For free resources setting it to "none" worked :) But paid resources still have an issue.
 
Top