SMF Shop

SMFShop => Bugs => Topic started by: lwbbs on October 27, 2007, 03:16:37 am

Title: qustion in install_SMF1-1.xml file
Post by: lwbbs on October 27, 2007, 03:16:37 am

Is it correct in install_SMF1-1.xml file?

Quote

    <file name="$sourcedir/Load.php">
        <operation>
            <search position="before"><![CDATA[IFNULL(pg.groupName, '') AS post_group, mem.is_activated,]]></search>
            <add><![CDATA[ mem.money,]]></add>
        </operation>
        <operation>
            <search position="before">IF(mem.ID_GROUP = 0 OR mg.stars = '', pg.stars, mg.stars) AS stars, </search>
            <add>mem.money, </add>
        </operation>

Title: Re: qustion in install_SMF1-1.xml file
Post by: Daniel15 on November 26, 2007, 10:51:52 am

Yes, that's correct. Basically, it finds IF(mem.ID_GROUP = 0 OR mg.stars = '', pg.stars, mg.stars) AS stars, (which is part of one of the queries), and adds mem.money to it.
:)