forum post give money or item [MYSQL]

Discussion in 'Plugin Requests' started by twinfrozr33, Jan 12, 2015.

Thread Status:
Not open for further replies.
  1. Offline

    twinfrozr33

    Hello Reader,

    Iam looking for a plugin that can do the following.
    Posting a message on a forum will credit you in the gameserver
    Give money,xp,or items on posts you make on a forum.
    I know 1 plugin that has something like this but it doesnt work for me that is community bridge

    For example:
    MinecraftUser: posted a message on a forum he/she will get 0.30 $ IG-cash (Config based to let other users of this plugin can set their own amount)

    Current running forum software is XenForo,
    I can provide you:
    Database information on a certain level.
    Host: Ip/Localhost
    DatabaseName: xyliance_xen
    DatabaseTable: xf_user
    DatabaseTableField: message_count

    SQL DUMP
    Code:
    -- phpMyAdmin SQL Dump
    -- version 4.0.10.6
    -- http://www.phpmyadmin.net
    --
    -- Machine: localhost
    -- Genereertijd: 12 jan 2015 om 06:54
    -- Serverversie: 5.5.40-cll
    -- PHP-versie: 5.4.23
    
    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 utf8 */;
    
    --
    -- Databank: `xyliance_xen`
    --
    
    -- --------------------------------------------------------
    
    --
    -- Tabelstructuur voor tabel `xf_user`
    --
    
    CREATE TABLE IF NOT EXISTS `xf_user` (
      `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `username` varchar(50) NOT NULL,
      `email` varchar(120) NOT NULL,
      `gender` enum('','male','female') NOT NULL DEFAULT '' COMMENT 'Leave empty for ''unspecified''',
      `custom_title` varchar(50) NOT NULL DEFAULT '',
      `language_id` int(10) unsigned NOT NULL,
      `style_id` int(10) unsigned NOT NULL COMMENT '0 = use system default',
      `timezone` varchar(50) NOT NULL COMMENT 'Example: ''Europe/London''',
      `visible` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Show browsing activity to others',
      `user_group_id` int(10) unsigned NOT NULL,
      `secondary_group_ids` varbinary(255) NOT NULL,
      `display_style_group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User group ID that provides user styling',
      `permission_combination_id` int(10) unsigned NOT NULL,
      `message_count` int(10) unsigned NOT NULL DEFAULT '0',
      `conversations_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
      `register_date` int(10) unsigned NOT NULL DEFAULT '0',
      `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
      `trophy_points` int(10) unsigned NOT NULL DEFAULT '0',
      `alerts_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
      `avatar_date` int(10) unsigned NOT NULL DEFAULT '0',
      `avatar_width` smallint(5) unsigned NOT NULL DEFAULT '0',
      `avatar_height` smallint(5) unsigned NOT NULL DEFAULT '0',
      `gravatar` varchar(120) NOT NULL DEFAULT '' COMMENT 'If specified, this is an email address corresponding to the user''s ''Gravatar''',
      `user_state` enum('valid','email_confirm','email_confirm_edit','moderated','email_bounce') NOT NULL DEFAULT 'valid',
      `is_moderator` tinyint(3) unsigned NOT NULL DEFAULT '0',
      `is_admin` tinyint(3) unsigned NOT NULL DEFAULT '0',
      `is_banned` tinyint(3) unsigned NOT NULL DEFAULT '0',
      `like_count` int(10) unsigned NOT NULL DEFAULT '0',
      `warning_points` int(10) unsigned NOT NULL DEFAULT '0',
      `is_staff` tinyint(3) unsigned NOT NULL DEFAULT '0',
      `ragtek_inactivitytag` int(10) unsigned NOT NULL DEFAULT '0',
      `best_answer_count` int(10) unsigned NOT NULL DEFAULT '0',
      `ragtek_referrer_userid` int(11) NOT NULL DEFAULT '0',
      `resource_count` int(10) unsigned NOT NULL DEFAULT '0',
      `activity_visible` tinyint(3) unsigned NOT NULL DEFAULT '1',
      `uuid` char(32) DEFAULT NULL,
      PRIMARY KEY (`user_id`),
      UNIQUE KEY `username` (`username`),
      KEY `email` (`email`),
      KEY `user_state` (`user_state`),
      KEY `last_activity` (`last_activity`),
      KEY `message_count` (`message_count`),
      KEY `trophy_points` (`trophy_points`),
      KEY `like_count` (`like_count`),
      KEY `register_date` (`register_date`),
      KEY `staff_username` (`is_staff`,`username`),
      KEY `resource_count` (`resource_count`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1321 ;
    
    --
    -- Gegevens worden uitgevoerd voor tabel `xf_user`
    --
    
    INSERT INTO `xf_user` (`user_id`, `username`, `email`, `gender`, `custom_title`, `language_id`, `style_id`, `timezone`, `visible`, `user_group_id`, `secondary_group_ids`, `display_style_group_id`, `permission_combination_id`, `message_count`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `alerts_unread`, `avatar_date`, `avatar_width`, `avatar_height`, `gravatar`, `user_state`, `is_moderator`, `is_admin`, `is_banned`, `like_count`, `warning_points`, `is_staff`, `ragtek_inactivitytag`, `best_answer_count`, `ragtek_referrer_userid`, `resource_count`, `activity_visible`, `uuid`) VALUES
    (1, 'twinfrozr33', '[email protected]', 'male', '', 3, 19, 'Europe/Amsterdam', 1, 3, '', 3, 8, 339, 0, 1393401132, 1421059550, 152, 0, 1396002697, 192, 248, '', 'valid', 1, 1, 0, 79, 0, 1, 0, 3, 0, 17, 0, '3824f9d61ac4488dbb76ccf50691bdf1'),
    (2, 'Minecraftusername2', '[email protected]', '', '', 3, 0, 'Europe/Amsterdam', 1, 2, '', 2, 2, 0, 0, 1421045314, 1421045445, 0, 0, 0, 0, 0, '', 'email_confirm', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL);
    
    /*!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 */;
    




    If there is an excisting plugin please link me to that plugin as for i have searched all over google.
    Perhaps i messed up some keywords that missed my search by far.

    Thanks in advance
     
    Last edited: Jan 12, 2015
  2. Online

    timtower Administrator Administrator Moderator

    @twinfrozr33 Thing that any developer needs for this: database structure.
    We need to know how everything is linked with each other, is the user in the post table a string or a number that directs to a different table etc.
     
  3. Offline

    twinfrozr33

    Correct thank you to point this out, I have added a sql dump in the mainpost to give an overal look on where the plugin have to find the data.

    If there is anything else i can do for the developer let me know because i dont know what else information you may need.

    thank you for the respond and idea @timtower
     
Thread Status:
Not open for further replies.

Share This Page