Welcome to AC Web.
Results 1 to 8 of 8
  1. #1

    Question FusionCMS Default VP/DP points


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Hi Guys,

    I am currently running FusionCMS for my realm and was wandering if anyone knows how to set a default VP/DP upon creating an account.

    An example of this would be as followed.

    Upon user successfully registering and verifying their account they get given 100VP / 100DP points as a reward for joining.

    I have run through all the config files along with the ACP however i do not see a way to set this.

    Any feedback will be greatly appreciated.

    Kind Regards,

  2. #2


    Join Date
    Jun 2015
    Location
    The Netherlands
    Posts
    122
    Don't exactly know where, but look for the query where it inserts an account into db. Once u found that you can easily add a row with DP / VP

  3. #3
    Execute this web db query
    Code:
    ALTER TABLE `account_data`
    	CHANGE COLUMN `vp` `vp` INT(11) NULL DEFAULT '100' AFTER `id`,
    	CHANGE COLUMN `dp` `dp` INT(11) NULL DEFAULT '100' AFTER `vp`;

  4. #4
    Thanks for the advice guys,

    Will this be an automated query or a manual task ?

    I would like this to be as automated as possible on account creation so that it is not a manual task for every single account that is created. In addition to this i need to ensure that every user account gets their points and no users are missed.

    Sorry i do not have tons of experience in MySQL.

  5. #5
    Execute it once in web db, and see if it works when making new accounts.

  6. #6
    Just did it as followed.

    ALTER TABLE `account_data`
    CHANGE COLUMN `vp` `vp` INT(11) NULL DEFAULT '1000' AFTER `id`,
    CHANGE COLUMN `dp` `dp` INT(11) NULL DEFAULT '0' AFTER `vp`;

    and got the following output

    /* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 1 query: 0.047 sec. */

    I have also tested the account creation and it still gives a 0 value

    Once again thanks for all the help.

    Greatly appreciated.

  7. #7
    try this:
    https://github.com/JunkyBulgaria/Fus..._model.php#L79

    change that 0 to 1000.

    In your website
    application/models/internal_user_model.php

    also at https://github.com/JunkyBulgaria/Fus..._model.php#L88

  8. #8

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Managed to get it working with the above thanks for all the help @Surrenderat20

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •