Author Topic: qustion in install_SMF1-1.xml file  (Read 2325 times)

lwbbs

  • Guest
qustion in install_SMF1-1.xml file
« 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>

Offline Daniel15

Re: qustion in install_SMF1-1.xml file
« Reply #1 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.
:)