suslik

127.0.0.1 localhost
178.79.37.12 suslik domen.ru

[0] => Array ( [msProductFile_id] => 299 [msProductFile_product_id] => 12 [msProductFile_source] => 2 [msProductFile_parent] => 0 [msProductFile_name] => gallery-04.jpg [msProductFile_description] => [msProductFile_path] => 12/ [msProductFile_file] => 8f01bd34e430f133847685525c02e807.jpg [msProductFile_type] => image [msProductFile_createdon] => 2013-04-07 14:56:30 [msProductFile_createdby] => 2 [msProductFile_rank] => 0 [msProductFile_url] => /assets/gallery/12/8f01bd34e430f133847685525c02e807.jpg )

$q->where(array('published' => 1, 'deleted' => 0));

$q = $modx->newQuery('msProduct', array('class_key' => 'msProduct', 'published' => 1, 'deleted' => 0));

[[!UpdateProfile? &validate=`fullname:required,email:required:email`]]
<div class="update-profile">
    <div class="updprof-error">[[+error.message]]</div>
    [[+login.update_success:if=`[[+login.update_success]]`:is=`1`:then=`[[%login.profile_updated? &namespace=`login` &topic=`updateprofile`]]`]]
 
    <form class="form" action="[[~[[*id]]]]" method="post">
        <input type="hidden" name="nospam" value="" />
 
        <label for="fullname">[[!%login.fullname? &namespace=`login` &topic=`updateprofile`]]
            <span class="error">[[+error.fullname]]</span>
        </label>
        <input type="text" name="fullname" id="fullname" value="[[+fullname]]" />
 
        <label for="email">[[!%login.email]]
            <span class="error">[[+error.email]]</span>
        </label>
        <input type="text" name="email" id="email" value="[[+email]]" />
 
        <label for="phone">[[!%login.phone]]
            <span class="error">[[+error.phone]]</span>
        </label>
        <input type="text" name="phone" id="phone" value="[[+phone]]" />
 
        <label for="mobilephone">[[!%login.mobilephone]]
            <span class="error">[[+error.mobilephone]]</span>
        </label>
        <input type="text" name="mobilephone" id="mobilephone" value="[[+mobilephone]]" />
 
        <label for="fax">[[!%login.fax]]
            <span class="error">[[+error.fax]]</span>
        </label>
        <input type="text" name="fax" id="fax" value="[[+fax]]" />
 
        <label for="address">[[!%login.address]]
            <span class="error">[[+error.address]]</span>
        </label>
        <input type="text" name="address" id="address" value="[[+address]]" />
 
        <label for="country">[[!%login.country]]
            <span class="error">[[+error.country]]</span>
        </label>
        <input type="text" name="country" id="country" value="[[+country]]" />
 
        <label for="city">[[!%login.city]]
            <span class="error">[[+error.city]]</span>
        </label>
        <input type="text" name="city" id="city" value="[[+city]]" />
 
        <label for="state">[[!%login.state]]
            <span class="error">[[+error.state]]</span>
        </label>
        <input type="text" name="state" id="state" value="[[+state]]" />
 
        <label for="zip">[[!%login.zip]]
            <span class="error">[[+error.zip]]</span>
        </label>
        <input type="text" name="zip" id="zip" value="[[+zip]]" />
 
        <label for="website">[[!%login.website]]
            <span class="error">[[+error.website]]</span>
        </label>
        <input type="text" name="website" id="website" value="[[+website]]" />
 
        <br class="clear" />
 
        <div class="form-buttons">
            <input type="submit" name="login-updprof-btn" value="[[!%login.update_profile]]" />
        </div>
    </form>
</div>

[[!eventsCalendar2? &id=`4` &dateSource=`tvevent_date` &dateFormat=`%d %b %Y %H:%M` &tplEvent=`tplEvent2` &tplMain=`tplCalendar2` &tplHead=`tplHead2` &tplCell=`tplCell2` &first_day=`1`!]]

`msProduct`.`id`', 'msProductFile.published

$q = $modx->newQuery('msProductFile', array('published' => 1, 'deleted' => 0, 'type' => 'image', 'parent' => 0));
$q->innerJoin('msProduct', 'msProduct', '`msProductFile`.`product_id` = `msProduct`.`id`', 'msProductFile.published = 1 AND msProductFile`.deleted` = 0');