How to add free Mu Points(Credits for web shop)

Results 1 to 2 of 2
  1. #1
    wWw.F403.OrG S37uP!Update is offline
    MemberRank
    Oct 2008 Join Date
    F403.ORGLocation
    1,304Posts

    How to add free Mu Points(Credits for web shop)

    For example i will the value 5000

    If you want to add extra credits to all accounts use this query:
    For example: If you have 100 Mu Points, after running this query you will have 5100 Mu Points
    Code:
    UPDATE MEMB_INFO SET credits = credits + 5000
    If you want to add extra credits only to one account use this query:
    For example: If you have 100 Mu Points, after running this query you will have 5100 Mu Points
    Code:
    UPDATE MEMB_INFO SET credits = credits + 5000 WHERE memb___id = 'AccountID'
    If you want to replace all credits to all accounts use this query:
    For example: If you have 100 Mu Points, after running this query you will have 5000 Mu Points
    Code:
    UPDATE MEMB_INFO SET credits = 5000
    If you want to replace all credits only to one account use this query:
    For example: If you have 100 Mu Points, after running this query you will have 5000 Mu Points
    Code:
    UPDATE MEMB_INFO SET credits = 5000 WHERE memb___id = 'AccountID'
    If you find this GUIDE useful @Thanks button
    Last edited by S37uP!Update; 01-01-13 at 03:03 PM.


  2. #2
    Newbie daezugun is offline
    MemberRank
    Feb 2011 Join Date
    127.0.0.1Location
    787Posts

    Re: How to add free Mu Points(Credits for web shop)

    And if you are using Dmn webshop then
    Change the Memb_Credits to DmN_Shop_Credits and set there where do you want it to put
    if its credits or credits2 and credits 3.
    Example
    UPDATE DmN_Shop_Credits SET credits = credits + 5000
    UPDATE DmN_Shop_Credits SET credits2 = credits + 5000

    And i think its Memb_Credits bro not Memb_info if im not mistaken btw.
    Last edited by daezugun; 04-01-13 at 04:25 AM.



Advertisement