How Do i query Ad Revenue Mod install.php manually?

Discussion in 'MySQL' started by tahersaid, Nov 13, 2008.

Thread Status:
Not open for further replies.
  1. #1
    I want to install the Ad Revenue Sharing Mod on SMF 1.1.6. I understand all other manual installs but the one i dont really get is this:

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

    install.php
    This file should not be able to execute standalone. You may have to run the following queries manually.
    -----------------------------------------------------------
    Query:

    SHOW COLUMNS
    FROM {$db_prefix}membergroups
    LIKE 'ars_share'
    -------------------------------------------------------------
    Query:

    ALTER IGNORE TABLE {$db_prefix}membergroups
    ADD ars_share smallint(3) NOT NULL default '50'
    AFTER maxMessages
    -----------------------------------------------------------
    Query:

    SHOW COLUMNS
    FROM {$db_prefix}membergroups
    LIKE 'ars_enabled'
    -------------------------------------------------------------
    Query:

    ALTER IGNORE TABLE {$db_prefix}membergroups
    ADD ars_enabled smallint(1) NOT NULL default '1'
    AFTER ars_share
    --------------------------------------------------------------
    Query:
    SHOW COLUMNS FROM {$db_prefix}membergroups
    LIKE 'ars_random'
    ---------------------------------------------------------------
    Query:

    ALTER IGNORE TABLE {$db_prefix}membergroups
    ADD ars_random smallint(1) NOT NULL default '1'
    AFTER ars_enabled
    -------------------------------------------------------------
    Query:

    SHOW COLUMNS FROM {$db_prefix}membergroups
    LIKE 'ars_showads'
    ----------------------------------------------------------------
    Query:

    ALTER IGNORE TABLE {$db_prefix}membergroups
    ADD ars_showads smallint(1) NOT NULL default '1'
    AFTER ars_enabled
    --------------------------------------------------------------
    Query:

    INSERT IGNORE
    INTO {$db_prefix}settings (`variable`, `value`)
    VALUES ('$key', '$value')
    ---------------------------------------------------------------
    Query:

    UPDATE {$db_prefix}settings
    SET value='$value'
    WHERE variable = '$key'
    ------------------------------------------------------------
    Query:

    CREATE TABLE IF NOT EXISTS {$db_prefix}ars_participants (
    ID_MEMBER int(8) NOT NULL,
    adsenseid varchar(23),
    adsensechannel varchar(10),
    ypnid varchar(12),
    ypnsection varchar(6),
    textlinkadsid varchar(6),
    impressions int(20),
    PRIMARY KEY (ID_MEMBER)
    )

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

    How do i go about manually querying the install.php? Can someone give me a step by step description?
    am i using phpmyadmin in my hosting panel, and if i am using it how do i go about it?

    I'll appreciate your urgent reply. Thanks.
     
    tahersaid, Nov 13, 2008 IP
  2. tahersaid

    tahersaid Guest

    Messages:
    248
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    im using phpmyadmin mysql server in godaddy.com
     
    tahersaid, Nov 13, 2008 IP
Thread Status:
Not open for further replies.