niclalalla/points

Point system for flarum.

dev-master 2020-12-08 08:57 UTC

Requires

• flarum/core: >=0.1.0-beta.14 <0.1.0-beta.15

MIT

• name

README

A Flarum extension. points copy

Installation

Use Bazaar or install manually with composer:

composer require hehongyuanlove/xxxxxx

Updating

composer update hehongyuanlove/xxxxxxx

Links

• Packagist

安装说明

  CREATE TABLE `gam_points_logs` (
  	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  	`owner_id` INT(10) UNSIGNED NOT NULL,
  	`discussion_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  	`post_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  	`type` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_unicode_ci',
  	`amount` INT(11) NOT NULL,
  	`current` INT(11) NOT NULL,
  	`extra` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  	`created_at` TIMESTAMP NOT NULL,
  	PRIMARY KEY (`id`)
  )
  COLLATE='utf8_unicode_ci'
  ENGINE=InnoDB;

  ALTER TABLE `users`
  ADD COLUMN `points_count`  INT(11)  DEFAULT 0 AFTER `suspended_until`;
  ALTER TABLE `users`
  ADD COLUMN `points_rank`  INT(11)  DEFAULT 0 AFTER `points_count`;
  ALTER TABLE `users`
  ADD COLUMN `points_probability`  char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '{}' AFTER `points_count`;
  ALTER TABLE `users`
  ADD COLUMN `points_total`  INT(11)  DEFAULT 0 AFTER `points_probability`;
  
  INSERT INTO `migrations` (`migration`, `extension`) VALUES ('2020_06_17_081739_points_logs_table', 'niclalalla-points');
  INSERT INTO `migrations` (`migration`, `extension`) VALUES ('2020_06_17_102253_add_points_to_users', 'niclalalla-points');