Home›Help›Trac

Changeset 15934 for trunk


Ignore:
Timestamp:
01/30/12 01:29:27 (4 months ago)
Author:
Alexander Trofimov
Message:

Code cleaning

Location:
trunk
Files:
2 added
636 deleted
31 edited

Legend:

Unmodified
Added
Removed

  • trunk/about_us.php

    r15885 r15934  
    1515bx_import('BxDolLanguages'); 
    1616bx_import('BxDolMenu'); 
     17bx_import('BxDolTemplate'); 
    1718 
    1819BxDolMenu::setSelected ('system', 'about');  

  • trunk/advice.php

    r15211 r15934  
    77 
    88require_once('./inc/header.inc.php'); 
    9 require_once(BX_DIRECTORY_PATH_INC . "languages.inc.php"); 
    109require_once(BX_DIRECTORY_PATH_INC . "params.inc.php"); 
    1110require_once(BX_DIRECTORY_PATH_INC . "design.inc.php"); 
    1211 
    13 bx_import('BxTemplMenu'); 
    14 BxTemplMenu::getInstance()->setCurrentMenu ('bx_sys_sub_advice'); // TODO: change database accordingly 
     12bx_import('BxDolLanguages'); 
     13bx_import('BxDolTemplate'); 
    1514 
    1615$oTemplate = BxDolTemplate::getInstance(); 
    … …  
    1817$oTemplate->setPageHeader (_t("_ADVICE_H")); 
    1918$oTemplate->setPageContent ('page_main_code', PageCompMainCode()); 
    20  
    21 PageCode(); 
     19$oTemplate->getPageCode(); 
    2220 
    2321/** 

  • trunk/calendar.php

    r15260 r15934  
    2020$oTemplate->setPageNameIndex(7); 
    2121$oTemplate->setPageParams(array( 
    22     'css_name' => 'browse.css', 
    2322    'header' => _t('_People_Calendar') 
    2423)); 

  • trunk/categories.php

    r15334 r15934  
    369369    $oTemplate->setPageNameIndex(25); 
    370370    $oTemplate->setPageParams(array( 
    371         'css_name' => 'tags.css', 
    372         'js_name' => 'browse_members.js', 
    373371        'header' => _t('_Categories'), 
    374372        'header_text' => _t('_Categories'), 

  • trunk/contact.php

    r15885 r15934  
    1212bx_import('BxDolLanguages'); 
    1313bx_import('BxDolMenu'); 
     14bx_import('BxDolTemplate'); 
    1415 
    1516BxDolMenu::setSelected ('system', 'contact');  

  • trunk/faq.php

    r15885 r15934  
    1212bx_import('BxDolLanguages'); 
    1313bx_import('BxDolMenu'); 
     14bx_import('BxDolTemplate'); 
    1415 
    1516BxDolMenu::setSelected ('system', 'faq');  

  • trunk/help.php

    r15885 r15934  
    1212bx_import('BxDolLanguages'); 
    1313bx_import('BxDolMenu'); 
     14bx_import('BxDolTemplate'); 
    1415 
    1516BxDolMenu::setSelected ('system', 'help');  

  • trunk/inc/classes/BxDolAcl.php

    r15893 r15934  
    3333 * Action ID's 
    3434 */ 
    35 define('ACTION_ID_SEND_VKISS', 1); 
    36 define('ACTION_ID_VIEW_PROFILES', 2); 
    3735define('ACTION_ID_VOTE', 3); 
    38 define('ACTION_ID_SEND_MESSAGE', 4); 
    39 define('ACTION_ID_GET_EMAIL', 5); 
    4036define('ACTION_ID_COMMENTS_POST', 6); 
    4137define('ACTION_ID_COMMENTS_VOTE', 7); 

  • trunk/inc/classes/BxDolAlerts.php

    r15211 r15934  
    66 */ 
    77defined('BX_DOL') or die('hack attempt'); 
    8  
    9 bx_import('BxDolSubscription'); 
    108 
    119/** 
    … …  
    8280    function alert() { 
    8381 
    84         $oSubscription = new BxDolSubscription(); 
    85         $oSubscription->send($this->sUnit, $this->sAction, $this->iObject, $this->aExtras); 
    86  
    8782        if (isset($this->_aAlerts[$this->sUnit]) && isset($this->_aAlerts[$this->sUnit][$this->sAction])) 
    8883            foreach($this->_aAlerts[$this->sUnit][$this->sAction] as $iHandlerId) { 

  • trunk/inc/classes/BxDolCmts.php

    r15733 r15934  
    369369    function isPostReplyAllowed () 
    370370    { 
    371         if($this->_checkGuestsPermission() == false) return false; 
    372371        return $this->checkAction (ACTION_ID_COMMENTS_POST); 
    373     } 
    374  
    375  
    376  
    377     function _checkGuestsPermission() 
    378     { 
    379         if(getParam("enable_guest_comments") == "on") return true; 
    380         if ($this->_getAuthorId() > 0) return true; 
    381         return false; 
    382372    } 
    383373 

  • trunk/inc/classes/BxDolTemplate.php

    r15931 r15934  
    2323define('BX_PAGE_POPUP', 44); ///< popup page, without any headers and footers 
    2424define('BX_PAGE_TRANSITION', 150); ///< transition page with redirect to display some msg, like 'please wait', without headers footers 
    25  
     25define('BX_PAGE_MOBILE', 11); ///< mobile page 
    2626/** 
    2727 * Template engine. 

  • trunk/inc/classes/BxDolTwigModule.php

    r15733 r15934  
    244244        $this->_oTemplate->addCss ('main.css'); 
    245245        $this->_oTemplate->addCss ('entry_view.css'); 
    246         $this->_oTemplate->addCss ('unit_fan.css'); 
    247246        $this->_oTemplate->pageCode($aDataEntry[$this->_oDb->_sFieldTitle], false, false); 
    248247 

  • trunk/inc/js/common_anim.js

    r15211 r15934  
    55 */ 
    66 
    7 // TODO: remove bxShowLoading after replacing uploaders 
    87// TODO: make sure that there is no duplicate code in bx_loading functions 
    98// TODO: name it with jquery. prefix since it is jquery plugin 
    … …  
    8685    }); 
    8786}; 
    88 $.fn.bx_message_box = function(sMessage, iTimer, onClose) { 
    89     return this.each(function() { 
    90         var oParent = $(this); 
    9187 
    92         if(oParent.children(':first').hasClass('MsgBox')) 
    93             oParent.children(':first').replaceWith(sMessage); 
    94         else 
    95             oParent.prepend(sMessage); 
    9688 
    97         if(iTimer == undefined || parseInt(iTimer) == 0) 
    98             return; 
    99  
    100         setTimeout(function(oParent, onClose) { 
    101             oParent.children('div.MsgBox:first').bx_anim('hide', 'fade', 'slow', function(){ 
    102                 $(this).remove(); 
    103                 if(onClose != undefined) 
    104                     onClose(); 
    105             }); 
    106         }, 1000 * parseInt(iTimer), oParent, onClose); 
    107     }); 
    108 }; 
    109 function bxShowLoading(oParent, bShow) { 
    110     var oLoading = oParent.children('.upload-loading'); 
    111  
    112     if(bShow) { 
    113         oLoading.css('left', (oParent.width() - oLoading.width())/2); 
    114         oLoading.css('top', (oParent.height() - oLoading.height())/2); 
    115         oLoading.show(); 
    116     } 
    117     else 
    118         oLoading.hide(); 
    119 } 

  • trunk/inc/js/functions.js

    r15497 r15934  
    55 */ 
    66 
    7 function ps_page_toggle(sPageName, iProfileId, iBlockId) { 
    8     if($('body').find('div#dbPrivacyMenu' + iBlockId).length > 0){ 
    9         $('body').find('div#dbPrivacyMenu' + iBlockId).dolPopup({}); 
    10         return; 
    11     } 
    12  
    13     $.post( 
    14         sUrlRoot + 'member_privacy.php', 
    15         { 
    16             ps_action: 'get_chooser', 
    17             ps_page_name: sPageName, 
    18             ps_profile_id: iProfileId, 
    19             ps_block_id: iBlockId 
    20         }, 
    21         function(oData) { 
    22             if(parseInt(oData.code) == 0) { 
    23                 $('body').append($(oData.data).addClass('dbPrivacyMenu')); 
    24                 $('body').find('div#dbPrivacyMenu' + iBlockId).dolPopup({}); 
    25             } 
    26         }, 
    27         'json' 
    28     ); 
    29 } 
    30 function ps_page_select(oLink, iBlockId, iGroupId) { 
    31     $.post( 
    32         sUrlRoot + 'member_privacy.php', 
    33         { 
    34             ps_action: 'view_block', 
    35             ps_block_id: iBlockId, 
    36             ps_group_id: iGroupId 
    37         }, 
    38         function(oData) { 
    39             if(parseInt(oData.code) == 0) { 
    40                 $(oLink).parents('.dbPrivacyMenu').dolPopupHide().find('.dbPrivacyGroupActive').removeClass('dbPrivacyGroupActive').addClass('dbPrivacyGroup'); 
    41                 $(oLink).removeClass('dbPrivacyGroup').addClass('dbPrivacyGroupActive'); 
    42  
    43                 $('#dbPrivacy' + iBlockId + ' a:first').attr('title', oData.group); 
    44             } 
    45         }, 
    46         'json' 
    47     ); 
    48 } 
    49 function ps_showDialog(sType, iGroupId, oLink) { 
    50     var oDiv = $('#ps-' + sType + '-members'); 
    51  
    52     $("#ps-" + sType + "-member-form :hidden[name='ps-" + sType + "-member-group']").val(iGroupId); 
    53     oDiv.dolPopup({}); 
    54  
    55     if(sType == 'del') { 
    56         $('#ps-' + sType + '-members-loading').bx_loading(); 
    57  
    58         $.post( 
    59             sPSSiteUrl + 'member_privacy.php', 
    60             { 
    61                 ps_action: 'members', 
    62                 ps_value: iGroupId 
    63             }, 
    64             function(sData) { 
    65                 $('#ps-' + sType + '-members-loading').bx_loading(); 
    66                 oDiv.find('.ps-search-results').html(sData); 
    67             }, 
    68             'html' 
    69         ); 
    70     } 
    71 } 
    72 function ps_ad_search() { 
    73     var sSearchValue = $('#ps-search-member-form').find(':text:first').val(); 
    74  
    75     if(sSearchValue) { 
    76         $('#ps-add-members-loading').bx_loading(); 
    77  
    78         $.post( 
    79             sPSSiteUrl + 'member_privacy.php', 
    80             { 
    81                 ps_action: 'search', 
    82                 ps_value: sSearchValue 
    83             }, 
    84             function(sData) { 
    85                 $('#ps-add-members-loading').bx_loading(); 
    86                 $('#ps-add-members .ps-search-results').html(sData); 
    87             }, 
    88             'html' 
    89         ); 
    90     } 
    91 } 
    92  
    93 /** 
    94  * Checks/unchecks all tables 
    95  * 
    96  * @param   string   the form name 
    97  * @param   boolean  whether to check or to uncheck the element 
    98  * 
    99  * @return  boolean  always true 
    100  */ 
    101 function setCheckboxes(the_form, do_check) 
    102 { 
    103     var elts  = document.forms[the_form].getElementsByTagName('input'); 
    104     var elts_cnt  = elts.length; 
    105  
    106     for ( i = 0; i < elts_cnt; i++) 
    107     { 
    108         elts[i].checked = do_check; 
    109         if ( elts[i].type == "submit" ) 
    110             elts[i].disabled = !do_check; 
    111     } 
    112 } 
    113  
    114 function UpdateSubmit(the_form) { 
    115     var elts  = document.forms[the_form].getElementsByTagName('input'); 
    116     var elts_cnt  = elts.length; 
    117     var bChecked = false; 
    118  
    119     for ( i = 0; i < elts_cnt; i++) { 
    120         if (elts[i].type == "checkbox" && elts[i].checked == true) { 
    121             bChecked = true; 
    122         } 
    123         if ( elts[i].type == "submit" ) { 
    124             elts[i].disabled = true; 
    125         } 
    126     } 
    127     for ( i = 0; i < elts_cnt; i++) { 
    128         if ( elts[i].type == "submit" ) { 
    129             if (bChecked == true) { 
    130                 elts[i].disabled = false; 
    131             } else { 
    132                 elts[i].disabled = true; 
    133             } 
    134         } 
    135     } 
    136 } 
    137  
    138 /** 
    139  * Allow open window with extra params 
    140  * 
    141  * @param sWindowUrl string 
    142  * @param sWindowId string 
    143  * @param aVarNames array 
    144  * @param aVarValues array 
    145  * @param sWindowParams string 
    146  * @param sMethod string 
    147  * @return mixed 
    148  */ 
    149 function openWindowWithParams(sWindowUrl, sWindowId, aVarNames, aVarValues, sWindowParams, sMethod) 
    150 { 
    151     var newWindow = window.open(sWindowUrl, sWindowId, sWindowParams); 
    152     if (!newWindow) return false; 
    153  
    154     var html = ''; 
    155     html += '<html><head></head><body><form id="' + sWindowId + '" method="' + sMethod + '" action="' + sWindowUrl + '">'; 
    156  
    157     if (aVarNames && aVarValues && (aVarNames.length == aVarValues.length)) { 
    158         for (var i=0; i < aVarNames.length; i++) 
    159         { 
    160             html += '<input type=\"hidden\" name="' + aVarNames[i] + '" value="' + aVarValues[i] + '" />'; 
    161         } 
    162     } 
    163  
    164     html += '</body></html></form><script type="text/javascript">document.getElementById("' + sWindowId + '").submit()</script></body></html>'; 
    165     newWindow.document.write(html); 
    166     return newWindow; 
    167 } 
    168  
    169 function setCheckbox(the_form) 
    170 { 
    171     var elts      = document.forms[the_form].getElementsByTagName('input'); 
    172     var elts_cnt  = elts.length; 
    173  
    174     var allUnchecked = true; 
    175  
    176     for (var i = 0; i < elts_cnt; i++) 
    177         if(elts[i].checked) 
    178             allUnchecked = false; 
    179  
    180     for (var i = 0; i < elts_cnt; i++) 
    181         if( elts[i].type == "submit" ) 
    182             elts[i].disabled = allUnchecked; 
    183 } 
    184  
    185  
    186 var win = 'width=500,height=600,left=100,top=100,copyhistory=no,directories=no,menubar=no,location=no,resizable=no,scrollbars=yes'; 
    187  
    188 function launchTellFriend() { 
    189     var sBaseUrl = document.getElementsByTagName('base')[0].href; 
    190  
    191     var win = 'width=380,height=270,left=200,top=100,copyhistory=no,directories=no,menubar=no,location=no,resizable=no,scrollbars=no'; 
    192     return !window.open(sBaseUrl + 'tellfriend.php', 'tellfriend', win); 
    193 } 
    194  
    195 function launchTellFriendProfile( sID ) { 
    196     var sBaseUrl = document.getElementsByTagName('base')[0].href; 
    197  
    198     var win = "width=400,height=450,left=200,top=100,copyhistory=no,directories=no,menubar=no,location=no,resizable=no,scrollbars=no"; 
    199     return !window.open(sBaseUrl + 'tellfriend.php?ID='+sID,'tellfriendprofile',win); 
    200 } 
    201  
    202  
    203 function charCounter(field,maxLength,countTarget) 
    204 { 
    205  
    206     field = document.getElementById(field); 
    207     countTarget = document.getElementById(countTarget); 
    208     var inputLength=field.value.length; 
    209  
    210     if(inputLength >= maxLength) 
    211     { 
    212         field.value=field.value.substring(0,maxLength); 
    213  
    214     } 
    215     countTarget.innerHTML=maxLength-field.value.length; 
    216  
    217  
    218 } 
    219  
    220  
    221  
    222 /** 
    223  * change images onHover mouse action 
    224  */ 
    225 function show(FileName,jpg1Name) 
    226 { 
    227     document.images[FileName].src = jpg1Name; 
    228 } 
    229  
    230 /** 
    231  * set status of the browser window to 's' 
    232  */ 
    233 function ss(s) 
    234 { 
    235     window.status = s; 
    236     return true; 
    237 } 
    238  
    239 /** 
    240  * set status of the browser window to empty 
    241  */ 
    242 function ce() 
    243 { 
    244     window.status=''; 
    245 } 
    246  
    247  
    248 /** 
    249  * insert emotion item 
    250  */ 
    251 function emoticon( txtarea, text ) { 
    252  
    253     text = ' ' + text + ' '; 
    254     if (txtarea.createTextRange && txtarea.caretPos) { 
    255         var caretPos = txtarea.caretPos; 
    256         caretPos.text = caretPos.text.charAt(caretPos.text.length - 1) == ' ' ? text + ' ' : text; 
    257         txtarea.focus(); 
    258     } else { 
    259         txtarea.value  += text; 
    260         txtarea.focus(); 
    261     } 
    262 } 
    263  
    264 function docOpen(text) 
    265 { 
    266     newWindow=window.open('','','toolbar=no,resizable=yes,scrollbars=yes,width=400,height=300'); 
    267     newWindow.document.open("text/html"); 
    268     newWindow.document.write(unescape(text)); 
    269     newWindow.document.close(); 
    270 } 
    271  
    272  
    273 function createNamedElement( type, name ) 
    274 { 
    275  
    276     var element; 
    277  
    278     try 
    279     { 
    280         element = document.createElement('<'+type+' name="'+name+'">'); 
    281     } catch (e) { } 
    282  
    283     if (!element || !element.name) // Cool, this is not IE !! 
    284     { 
    285         element = document.createElement(type) 
    286         element.name = name; 
    287     } 
    288  
    289     return element; 
    290 } 
    291  
    292 function stripSlashes(str) 
    293 { 
    294     return str.replace(/\\/g, ''); 
    295 } 
    296  
    297 function createXmlHttpObj() 
    298 { 
    299     if ( window.XMLHttpRequest ) 
    300         return new XMLHttpRequest(); 
    301     else if ( window.ActiveXObject ) 
    302         return new ActiveXObject("Microsoft.XMLHTTP"); 
    303     else 
    304     { 
    305         alert( 'Please upgrade your browser' ); 
    306         return false; 
    307     } 
    308 } 
     7 
    3098 
    3109function getHtmlData( elem, url, callback, method ) 
    … …  
    35453} 
    35554 
    356  
    357 /* 
    358     Show the Floating Description for any element. 
    359  
    360     usage: 
    361     <element 
    362         onmouseover="showFloatDesc( 'your html description here...' );" 
    363         onmousemove="moveFloatDesc( event );" 
    364         onmouseout="hideFloatDesc();"> 
    365  
    366     Your document must contain in the root of body following content: 
    367         <div id="FloatDesc" style="position:absolute;display:none;"></div> 
    368     and specific stylesheet for it. 
    369 */ 
    370 function showFloatDesc( text, time) 
    371 { 
    372     var time = time || 0; 
    373     descDiv = document.getElementById( 'FloatDesc' ); 
    374     if ( descDiv ) 
    375     { 
    376         //descDiv.innerHTML = text; 
    377         //descDiv.style.display = 'block'; 
    378         $(descDiv).html(text).animate({opacity:'show'}, time); 
    379     } 
    380 } 
    381  
    382 function hideFloatDesc() 
    383 { 
    384     descDiv = document.getElementById( 'FloatDesc' ); 
    385     if ( descDiv ) 
    386         descDiv.style.display = 'none'; 
    387 } 
    388  
    389 function moveFloatDesc( ev ) 
    390 { 
    391     descDiv = document.getElementById( 'FloatDesc' ); 
    392     if ( descDiv ) 
    393     { 
    394         showPos = getPositionData( descDiv, ev ); 
    395         descDiv.style.left = showPos['posX'] + 'px'; 
    396         descDiv.style.top = showPos['posY'] + 'px'; 
    397     } 
    398 } 
    399  
    400 /* 
    401     Core of the Floating Description 
    402 */ 
    403 function getPositionData(obj, showEvent) 
    404 { 
    405     if ( !showEvent ) 
    406         showEvent = window.event; 
    407  
    408     var pos_X = 0, pos_Y = 0; 
    409     if ( showEvent ) 
    410     { 
    411         if ( typeof(showEvent.pageX) == 'number' ) 
    412         { 
    413             pos_X = showEvent.pageX; 
    414             pos_Y = showEvent.pageY; 
    415         } 
    416         else if ( typeof(showEvent.clientX) == 'number' ) 
    417         { 
    418             pos_X = showEvent.clientX; pos_Y = showEvent.clientY; 
    419             if ( document.body && 
    420                 ( document.body.scrollTop || document.body.scrollLeft ) && 
    421                 !( window.opera || window.debug || navigator.vendor == 'KDE' ) ) 
    422             { 
    423                 pos_X += document.body.scrollLeft; 
    424                 pos_Y += document.body.scrollTop; 
    425             } 
    426             else if ( document.documentElement && 
    427                 ( document.documentElement.scrollTop || 
    428                 document.documentElement.scrollLeft ) && 
    429                 !( window.opera || window.debug || navigator.vendor == 'KDE' ) ) 
    430             { 
    431                 pos_X += document.documentElement.scrollLeft; 
    432                 pos_Y += document.documentElement.scrollTop; 
    433             } 
    434         } 
    435     } 
    436  
    437     var scroll_X = 0, scroll_Y = 0; 
    438     if ( document.body && 
    439         ( document.body.scrollTop || document.body.scrollLeft ) && 
    440         !( window.debug || navigator.vendor == 'KDE' ) ) 
    441     { 
    442         scroll_X = document.body.scrollLeft; 
    443         scroll_Y = document.body.scrollTop; 
    444     } 
    445     else if ( document.documentElement && 
    446         ( document.documentElement.scrollTop || 
    447         document.documentElement.scrollLeft ) && 
    448         !( window.debug || navigator.vendor == 'KDE' ) ) 
    449     { 
    450         scroll_X = document.documentElement.scrollLeft; 
    451         scroll_Y = document.documentElement.scrollTop; 
    452     } 
    453  
    454     var win_size_X = 0, win_size_Y = 0; 
    455     if (window.innerWidth && window.innerHeight) 
    456     { 
    457         win_size_X = window.innerWidth; 
    458         win_size_Y = window.innerHeight; 
    459     } 
    460     else if ( document.documentElement && 
    461         document.documentElement.clientWidth && 
    462         document.documentElement.clientHeight ) 
    463     { 
    464         win_size_X = document.documentElement.clientWidth; 
    465         win_size_Y = document.documentElement.clientHeight; 
    466     } 
    467     else if (document.body && document.body.clientWidth && document.body.clientHeight) 
    468     { 
    469         win_size_X = document.body.clientWidth; 
    470         win_size_Y = document.body.clientHeight; 
    471     } 
    472  
    473     pos_X += 15; 
    474     pos_Y += 20; 
    475  
    476     if (obj.offsetWidth && obj.offsetHeight) 
    477     { 
    478         if (pos_X - scroll_X + obj.offsetWidth + 5 > win_size_X) 
    479             pos_X -= (obj.offsetWidth + 25); 
    480         if (pos_Y - scroll_Y + obj.offsetHeight + 5 > win_size_Y) 
    481             pos_Y -= (obj.offsetHeight + 20); 
    482     } 
    483  
    484     var res = new Array; 
    485     res['posX'] = pos_X; 
    486     res['posY'] = pos_Y; 
    487     res['scrollX'] = scroll_X; 
    488     res['scrollY'] = scroll_Y; 
    489     res['winSizeX'] = win_size_X; 
    490     res['winSizeY'] = win_size_Y; 
    491  
    492     return res; 
    493 } 
    494  
    495 function addBookmark( title, url ) 
    496 { 
    497     if (title == undefined) 
    498         title = document.title; 
    499  
    500     if (url == undefined) 
    501         url = top.location.href; 
    502  
    503     if (window.sidebar) // firefox 
    504         window.sidebar.addPanel(title, url, ''); 
    505     else if(window.opera && window.print) // opera 
    506     { 
    507         var elem = document.createElement('a'); 
    508         elem.setAttribute('href',url); 
    509         elem.setAttribute('title',title); 
    510         elem.setAttribute('rel','sidebar'); 
    511         elem.click(); 
    512     } 
    513     else if(document.all) // ie 
    514         window.external.AddFavorite(url, title); 
    515     else if (navigator.appName=="Netscape") //Netscape 
    516         alert( 'To bookmark this site press "Ctrl+D".' ); 
    517     else 
    518         alert( 'Your browser doesn\'t support this feature' ); 
    519 } 
    520  
    521 function changeBigPicTo(newBigImageName, newBigImageHref) { 
    522     var el; 
    523     el = document.getElementById('AdvBigImg'); 
    524     el.style.backgroundImage = 'url(' + newBigImageName + ')'; 
    525     el = document.getElementById('AdvBigImgFullSize'); 
    526     el.href = newBigImageHref; 
    527 } 
    528  
    529 function moveScrollRightAuto( el_id, b ) { 
    530     if (b) 
    531         scrollTimerId = setInterval("moveScrollRight('"+el_id+"')", 100); 
    532     else 
    533         clearInterval(scrollTimerId); 
    534 } 
    535  
    536 function moveScrollLeftAuto( el_id, b ) { 
    537     if (b) 
    538         scrollTimerId = setInterval("moveScrollLeft('"+el_id+"')", 100); 
    539     else 
    540         clearInterval(scrollTimerId); 
    541 } 
    542  
    543 function moveScrollRight( el_id ) { 
    544     var step = 5; 
    545     var e = $('#' + el_id); 
    546     var left = e.css('left') ? parseInt(e.css('left')) : 0; 
    547     var minLeft = e.parent().width() - parseInt(e.width()); 
    548  
    549     if((left-step) > minLeft) 
    550         e.css('left', left - step + 'px'); 
    551     else { 
    552         e.css('left', minLeft + 'px'); 
    553         moveScrollRightAuto(el_id, false); 
    554     } 
    555 } 
    556  
    557 function moveScrollLeft(el_id) { 
    558     var step = 5; 
    559     var e = $('#' + el_id); 
    560     var left = e.css('left') ? parseInt(e.css('left')) : 0; 
    561  
    562     if(left + step < 0) 
    563         e.css('left', left + step + 'px'); 
    564     else { 
    565         e.css('left', '0px'); 
    566         moveScrollLeftAuto(el_id, false); 
    567     } 
    568 } 
    569  
    570 function addEvent( obj, evt, func ) 
    571 { 
    572     if( !obj || !evt || !func ) 
    573         return false; 
    574  
    575     if( obj.addEventListener ) 
    576         obj.addEventListener( evt, func, false ); 
    577     else if( obj.attachEvent ) 
    578         obj.attachEvent( 'on' + evt, func ); 
    579 } 
    580  
    581 function checkAll( formName, _pref, doCheck ) { 
    582     _form = document.forms[formName]; 
    583  
    584     if( !_form ) 
    585         return false; 
    586  
    587     for( ind = 0; ind < _form.length; ind ++ ) { 
    588         _elem = _form[ind]; 
    589  
    590         if( _elem.type != 'checkbox' ) 
    591             continue; 
    592  
    593         if( _elem.name.substr( 0, _pref.length ) != _pref ) 
    594             continue; 
    595  
    596         _elem.checked = doCheck; 
    597     } 
    598 } 
    599  
    600 function emailCheck( str ) 
    601 { 
    602  
    603  if (str.search( /^[a-z0-9_\-]+(\.[_a-z0-9\-]+)*@([_a-z0-9\-]+\.)+([a-z]{2}|aero|arpa|asia|biz|cat|com|coop|edu|gov|info|int|jobs|mil|mobi|museum|name|net|org|pro|tel|travel)$/i ) == -1 ) 
    604      return false; 
    605  else 
    606      return true; 
    607 } 
    608  
    609 function getBoonexId( formFrom, formTo ) 
    610 { 
    611     if( !formFrom || !formTo ) 
    612         return false; 
    613  
    614     var ID = formFrom.ID; 
    615     var Password = formFrom.Password; 
    616  
    617     if( !ID || !Password ) 
    618         return false; 
    619  
    620     if( !ID.value.length ) 
    621     { 
    622         alert( 'Please enter BoonEx ID' ); 
    623         ID.focus(); 
    624         return false; 
    625     } 
    626  
    627     if( !Password.value.length ) 
    628     { 
    629         alert( 'Please enter Password' ); 
    630         Password.focus(); 
    631         return false; 
    632     } 
    633  
    634     formFrom.Submit.disabled = true; 
    635     formFrom.Submit.value = 'Wait...'; 
    636  
    637     $.get( 
    638         'get_boonex_id.php', 
    639         { 
    640             ID: encodeURIComponent(ID.value), 
    641             Password: encodeURIComponent(Password.value), 
    642             _r: Math.random() 
    643         }, 
    644         function(oXML){ 
    645  
    646                 if( !oXML.getElementsByTagName( 'ID' ).length ) 
    647                 { 
    648                     alert( 'Authorization failed. Try again.' ); 
    649                     return false; 
    650                 } 
    651  
    652                 var aFields = new Array(); 
    653                 aFields['Username'] = 'NickName[0]'; 
    654                 aFields['Email']    = 'Email[0]'; 
    655                 aFields['Password'] = 'Password[0],Password_confirm[0]'; 
    656                 aFields['Realname'] = 'Realname[0]'; 
    657                 aFields['DateOfBirth'] = 'DateOfBirth[0]'; 
    658                 aFields['Sex']      = 'Sex[0]'; 
    659                 aFields['Country']  = 'Country[0]'; 
    660                 aFields['City']     = 'City[0]'; 
    661                 aFields['ZIP']      = 'zip[0]'; 
    662                 aFields['Headline'] = 'Headline[0]'; 
    663                 aFields['DescriptionMe'] = 'DescriptionMe[0]'; 
    664                 aFields['tags']     = 'Tags'; 
    665  
    666                 for( var fieldFrom in aFields ) 
    667                 { 
    668                     if( !oXML.getElementsByTagName( fieldFrom ).length ) 
    669                         continue; 
    670  
    671                     var eFieldFrom = oXML.getElementsByTagName( fieldFrom )[0]; 
    672                     var sValue = eFieldFrom.firstChild.data; 
    673  
    674                     if( fieldFrom == 'DateOfBirth' ) { //convert date 
    675                         var aDate = sValue.split( '-' ); 
    676                         sValue = parseInt( aDate[2], 10 ) + '/' + parseInt( aDate[1], 10 ) + '/' + parseInt( aDate[0], 10 ); 
    677                     } 
    678  
    679                     var aFieldsTo = aFields[fieldFrom].split( ',' ); 
    680  
    681                     for( var i in aFieldsTo ) 
    682                     { 
    683                         fieldTo = aFieldsTo[i]; 
    684                         if( formTo[fieldTo] ) 
    685                         { 
    686                             eFieldTo = formTo[fieldTo]; 
    687  
    688                             switch( eFieldTo.type ) 
    689                             { 
    690                                 case 'text': 
    691                                 case 'textarea': 
    692                                 case 'password': 
    693                                 case 'select-one': 
    694                                     eFieldTo.value = sValue; 
    695                                     break; 
    696                                 default: 
    697                                     if( typeof eFieldTo == 'object' ) //radio 
    698                                         for( n = 0; n < eFieldTo.length; n++ ) 
    699                                             if( eFieldTo[n].value == sValue ) 
    700                                                 eFieldTo[n].checked = true; 
    701                             } 
    702                         } 
    703                     } 
    704                 } 
    705  
    706         }, 
    707         'xml' 
    708     ); 
    709  
    710     formFrom.Submit.disabled = false; 
    711     formFrom.Submit.value = 'Import'; 
    712 } 
    71355 
    71456function loadDynamicBlock( iBlockID, sUrl ) { 
    … …  
    74082    $('#dynamicPopup').dolPopupHide(); 
    74183} 
    742 function dbTopMenuLoad(iId) { 
    743     var oTopMenu = $('#dbTopMenu' + iId); 
    744     var iOuterWidth = oTopMenu.parent('.boxFirstHeader').width() - oTopMenu.siblings('.dbTitle').width() - 10; 
    745     if(iOuterWidth == -10) 
    746         return; 
    747  
    748     var iInnerWidth = 0, iSelectedOffset = 0; 
    749     $.each(oTopMenu.find('.dbTmContent > div:visible:not(.clear_both)'), function() { 
    750         if($(this).hasClass('active')) 
    751             iSelectedOffset = -iInnerWidth; 
    752  
    753         iInnerWidth += parseInt($(this).outerWidth()) + 5; 
    754     }); 
    755  
    756     if(iOuterWidth >= iInnerWidth) { 
    757         oTopMenu.find('.dbTmContent').width(iInnerWidth); 
    758         oTopMenu.find('.dbTmLeft, .dbTmRight').hide().siblings('.dbTmCenter').width(iInnerWidth); 
    759         oTopMenu.width(iInnerWidth); 
    760     } 
    761     else { 
    762         oTopMenu.find('.dbTmContent').width(iInnerWidth); 
    763         oTopMenu.find('.dbTmCenter').width(iOuterWidth - 2 * oTopMenu.find('.dbTmLeft').outerWidth()); 
    764         oTopMenu.width(iOuterWidth); 
    765  
    766         var iSelectedOffsetMin = parseInt(oTopMenu.find('.dbTmCenter').width()) - parseInt(oTopMenu.find('.dbTmContent').width()); 
    767         if(iSelectedOffset < iSelectedOffsetMin) 
    768             iSelectedOffset = iSelectedOffsetMin; 
    769         oTopMenu.find('.dbTmContent').css('left', iSelectedOffset + 'px'); 
    770     } 
    771  
    772     oTopMenu.css('top', '0px'); 
    773 } 
    774  
    775 function showItemEditForm( element_id ) 
    776 { 
    777     var editFormWrap = document.getElementById( element_id ); 
    778  
    779     editFormWrap.style.width   = document.body.clientWidth + 30 + "px"; 
    780     editFormWrap.style.height  = (window.innerHeight ? (window.innerHeight + 30) : screen.height) + "px"; 
    781     editFormWrap.style.left    = getHorizScroll1() - 30 + "px"; 
    782     editFormWrap.style.top     = getVertScroll1() - 30 + "px"; 
    783     editFormWrap.style.display = 'block'; 
    784 } 
    785  
    786 function getHorizScroll1() 
    787 { 
    788     if (navigator.appName == "Microsoft Internet Explorer") 
    789         return document.documentElement.scrollLeft; 
    790     else 
    791         return window.pageXOffset; 
    792 } 
    793  
    794 function getVertScroll1() 
    795 { 
    796     if (navigator.appName == "Microsoft Internet Explorer") 
    797         return document.documentElement.scrollTop; 
    798     else 
    799         return window.pageYOffset; 
    800 } 
     84 
    80185 
    80286/** 
    … …  
    81498} 
    81599 
    816 function showPopupLoginFormOld() { 
    817     if ($('#login_div').length) { 
    818         //alert(1); 
    819         $('#login_div').show(); 
    820     } else { 
    821  
    822         $.get( 
    823             sUrlRoot + 'member.php', 
    824             { 
    825                 action: 'show_login_form', 
    826                 relocate: String(window.location) 
    827             }, 
    828             function(data) { 
    829                 // trim needed for Safari. LOL 
    830                 $($.trim(data)).prependTo('body'); 
    831  
    832                 $('#login_div').show(); 
    833                 setDivToCenter($('#login_div')); 
    834  
    835                 // attach onresize event 
    836                 $(window).resize(function() { 
    837                     setDivToCenter($('#login_div')); 
    838                 }); 
    839  
    840                 // attach document onclick event 
    841                 $(document).click(function(event) { 
    842                     var event = event || window.event; 
    843                     var t = event.target || event.srcElement; 
    844  
    845                     if (!( 
    846                             $(t).parents('#login_div').length || 
    847                             $(t).parents('#bigLoginButton').length || 
    848                             $('#login_div').is(':hidden') 
    849                     )) 
    850                         $('#login_div').hide(); 
    851  
    852                     return true; 
    853                 }); 
    854             }, 
    855             'html' 
    856         ); 
    857     } 
    858 } 
    859100 
    860101function showPopupLoginForm() { 
    … …  
    893134} 
    894135 
    895 function startUserInfoTimer(iId, oObject) 
    896 { 
    897     if (typeof glUserInfoDisabled != 'undefined' && 'yes' == glUserInfoDisabled) 
    898         return; 
    899  
    900     if( typeof oObject == 'undefined') { 
    901         stopUserInfoTimer(iId); 
    902         return; 
    903     } 
    904  
    905     aUserInfoTimers[iId] = setTimeout(function(){ 
    906         showFloatUserInfo(iId, oObject); 
    907     }, 1000 * parseInt(aDolOptions['sys_user_info_timeout'])); 
    908 } 
    909  
    910 function stopUserInfoTimer(iId) { 
    911     clearTimeout(aUserInfoTimers[iId]); 
    912 } 
    913  
    914 function showFloatUserInfo(iId, oObject) 
    915 { 
    916     if (typeof glUserInfoDisabled != 'undefined' && 'yes' == glUserInfoDisabled) 
    917         return; 
    918  
    919     if( typeof oObject == 'undefined') { 
    920         return; 
    921     } 
    922  
    923     if (!$('#short_profile_info').length) { 
    924          $('<div id="short_profile_info" style="display: none;"></div>').prependTo('body'); 
    925     } 
    926  
    927     $('#short_profile_info').load( 
    928         sUrlRoot + 'short_profile_info.php?ID=' + iId, 
    929         function() { 
    930            $(this).dolPopup({position: $(oObject).get()}); 
    931         } 
    932     ); 
    933 } 
    934  
    935  
    936 function setDivToCenter(el) { 
    937     var $el = $(el || this); 
    938  
    939     if ($el.length == 0 || $el[0] == window) 
    940         return false; 
    941  
    942     var iLeft = ((window.innerWidth  ? window.innerWidth  : screen.width)  - $el.height()) / 2; 
    943     var iTop  = ((window.innerHeight ? window.innerHeight : screen.height) - $el.width())  / 2; 
    944  
    945     iLeft = iLeft > 0 ? iLeft : 0; 
    946     iTop  = iTop  > 0 ? iTop  : 0; 
    947  
    948     $el.css({ 
    949         position: 'fixed', 
    950         left: iLeft, 
    951         top:  iTop 
    952     }); 
    953 } 
    954136 
    955137function bx_loading (elem, b) { 

  • trunk/index.php

    r15570 r15934  
    55 * @license     CC-BY - http://creativecommons.org/licenses/by/3.0/ 
    66 */ 
    7  
    8 define('BX_INDEX_PAGE', 1); 
    97 
    108if (!file_exists("./inc/header.inc.php")) 
    … …  
    2624 
    2725require_once('./inc/header.inc.php'); 
    28 require_once(BX_DIRECTORY_PATH_INC . "languages.inc.php"); 
    2926require_once(BX_DIRECTORY_PATH_INC . "params.inc.php"); 
    3027require_once(BX_DIRECTORY_PATH_INC . "design.inc.php"); 
    3128 
    32 bx_import("BxTemplIndexPageView"); 
     29bx_import("BxDolLanguages"); 
     30bx_import("BxDolTemplate"); 
    3331 
    3432check_logged(); 
    3533 
    36 $sSiteTitle = getParam('site_title'); 
    37 $oIPV = new BxTemplIndexPageView(); 
    38  
    3934$oTemplate = BxDolTemplate::getInstance(); 
    4035$oTemplate->setPageNameIndex (BX_PAGE_DEFAULT); 
    41 $oTemplate->setPageTitle($sSiteTitle); 
     36$oTemplate->setPageTitle(getParam('site_title')); 
    4237$oTemplate->setPageDescription(getParam("MetaDescription")); 
    43 $oTemplate->setPageMainBoxTitle($sSiteTitle); 
    4438$oTemplate->addPageKeywords(getParam("MetaKeyWords")); 
    45 $oTemplate->setPageContent ('promo_code', $oIPV -> getPromoCode()); 
    46 $oTemplate->setPageContent ('page_main_code', $oIPV -> getCode()); 
     39$oTemplate->setPageContent ('page_main_code', DesignBoxContent(getParam('site_title'), 'TODO: index page', BX_DB_PADDING_DEF)); 
     40$oTemplate->getPageCode(); 
    4741 
    48 PageCode(); 
    49  

  • trunk/install/sql/v70.sql

    r15929 r15934  
    66 
    77SET NAMES 'utf8'; 
    8 DROP TABLE IF EXISTS `sys_account_custom_stat_elements`, `sys_admin_ban_list`, `sys_admin_dashboard`, `sys_albums`, `sys_albums_objects`,`sys_banners`, `sys_banners_clicks`, `sys_banners_shows`, `sys_block_list`, `sys_categories`, `sys_objects_categories`, `sys_objects_cmts`, `sys_cmts_profile`, `sys_cmts_track`, `sys_color_base`, `sys_countries`, `sys_email_templates`, `sys_menu_member`, `sys_friend_list`, `sys_options`, `sys_options_cats`, `sys_fave_list`, `sys_ip_list`, `sys_ip_members_visits`, `sys_localization_categories`, `sys_localization_keys`, `sys_localization_languages`, `sys_localization_string_params`, `sys_localization_strings`, `sys_acl_actions`, `sys_acl_actions_track`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `sys_messages`, `sys_page_compose`, `sys_page_compose_pages`, `sys_page_compose_privacy`, `sys_sessions`, `sys_stat_member`, `sys_pre_values`, `sys_profile_fields`, `sys_acl_levels_members`, `sys_profile_views_track`, `sys_profiles_match`, `sys_profile_rating`, `sys_profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayChatMembershipsSettings`, `RayChatMemberships`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayMp3Tokens`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideoTokens`, `RayVideo_commentsFiles`, `RayVideo_commentsTokens`, `sys_objects_search`, `sys_shared_sites`, `sys_stat_site`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_injections_admin`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `sys_privacy_actions`, `sys_privacy_defaults`, `sys_privacy_groups`, `sys_privacy_members`, `sys_tags`, `sys_objects_tag`, `sys_transactions`, `sys_objects_actions`, `sys_objects_auths`, `sys_greetings`, `sys_objects_vote`, `sys_objects_views`, `sys_box_download`, `sys_cron_jobs`, `sys_sbs_users`, `sys_sbs_entries`, `sys_sbs_types`, `sys_sbs_queue`, `sys_sbs_messages`, `sys_profiles_match_mails`, `sys_dnsbl_rules`, `sys_dnsbl_block_log`, `sys_dnsbluri_zones`, `sys_menu_mobile`, `sys_menu_mobile_pages`, `sys_objects_storage`, `sys_storage_user_quotas`, `sys_storage_tokens`, `sys_storage_ghosts`, `sys_storage_mime_types`, `sys_objects_transcoder_images`, `sys_transcoder_images_files`, `sys_transcoder_images_filters`,`sys_accounts`,`sys_profiles`; 
     8DROP TABLE IF EXISTS `sys_admin_ban_list`, `sys_block_list`, `sys_categories`, `sys_objects_categories`, `sys_objects_cmts`, `sys_email_templates`, `sys_friend_list`, `sys_options`, `sys_options_cats`, `sys_ip_list`, `sys_ip_members_visits`, `sys_localization_categories`, `sys_localization_keys`, `sys_localization_languages`, `sys_localization_string_params`, `sys_localization_strings`, `sys_acl_actions`, `sys_acl_actions_track`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `sys_sessions`, `sys_acl_levels_members`, `sys_objects_search`, `sys_stat_site`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_injections_admin`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `sys_privacy_actions`, `sys_privacy_defaults`, `sys_privacy_groups`, `sys_privacy_members`, `sys_tags`, `sys_objects_tag`, `sys_transactions`, `sys_objects_auths`, `sys_objects_vote`, `sys_objects_views`, `sys_cron_jobs`, `sys_dnsbl_rules`, `sys_dnsbl_block_log`, `sys_dnsbluri_zones`, `sys_menu_mobile`, `sys_menu_mobile_pages`, `sys_objects_storage`, `sys_storage_user_quotas`, `sys_storage_tokens`, `sys_storage_ghosts`, `sys_storage_mime_types`, `sys_objects_transcoder_images`, `sys_transcoder_images_files`, `sys_transcoder_images_filters`,`sys_accounts`,`sys_profiles`; 
    99ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci'; 
    10  
    11 -- -------------------------------------------------------- 
    12  
    13 -- 
    14 -- Table structure for table `sys_account_custom_stat_elements` 
    15 -- 
    16  
    17 CREATE TABLE `sys_account_custom_stat_elements` ( 
    18   `ID` int(2) NOT NULL auto_increment, 
    19   `Label` varchar(128) NOT NULL, 
    20   `Value` varchar(255) NOT NULL, 
    21   PRIMARY KEY  (`ID`) 
    22 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2310 
    2411 
    … …  
    3522  PRIMARY KEY (`ProfID`) 
    3623) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    37  
    38 -- 
    39 -- Dumping data for table `sys_admin_ban_list` 
    40 -- 
    41  
    42 -- -------------------------------------------------------- 
    43  
    44 -- 
    45 -- Table structure for table `sys_albums` 
    46 -- 
    47  
    48 CREATE TABLE `sys_albums` ( 
    49     `ID` int(10) NOT NULL auto_increment, 
    50     `Caption` varchar(128) NOT NULL default '', 
    51     `Uri` varchar(255) NOT NULL default '', 
    52     `Location` varchar(128) NOT NULL default '', 
    53     `Description` varchar(255) NOT NULL default '', 
    54     `Type` varchar(20) NOT NULL default '', 
    55     `Owner` int(10) NOT NULL default '0', 
    56     `Status` enum('active', 'passive') NOT NULL default 'active', 
    57     `Date` int(10) NOT NULL default '0', 
    58     `ObjCount` int(10) NOT NULL default '0', 
    59     `LastObjId` int(10) NOT NULL default '0', 
    60     `AllowAlbumView` int(10) NOT NULL default '3', 
    61     PRIMARY KEY (`ID`), 
    62     UNIQUE KEY (`Uri`, `Type`, `Owner`) 
    63 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    64  
    65 -- 
    66 -- Dumping data for table `sys_albums` 
    67 -- 
    68  
    69 -- -------------------------------------------------------- 
    70  
    71 -- 
    72 -- Table structure for table `sys_albums_objects` 
    73 -- 
    74  
    75 CREATE TABLE `sys_albums_objects` ( 
    76     `id_album` int(10) NOT NULL, 
    77     `id_object` int(10) NOT NULL, 
    78     `obj_order` int(10) NOT NULL default '0', 
    79     UNIQUE KEY (`id_album`, `id_object`), 
    80     KEY `id_object` (`id_object`) 
    81 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    82  
    83 -- 
    84 -- Dumping data for table `sys_albums_objects` 
    85 -- 
    86  
    87 -- -------------------------------------------------------- 
    88  
    89 -- 
    90 -- Table structure for table `sys_banners` 
    91 -- 
    92  
    93 CREATE TABLE `sys_banners` ( 
    94   `ID` int(11) unsigned NOT NULL auto_increment, 
    95   `Title` varchar(32) NOT NULL default '', 
    96   `Url` varchar(255) NOT NULL default '', 
    97   `Text` mediumtext NOT NULL, 
    98   `Active` tinyint(4) NOT NULL default '0', 
    99   `Created` date NOT NULL default '0000-00-00', 
    100   `campaign_start` date NOT NULL default '2005-01-01', 
    101   `campaign_end` date NOT NULL default '2007-01-01', 
    102   `Position` varchar(10) NOT NULL default '4', 
    103   `lhshift` int(5) NOT NULL default '-200', 
    104   `lvshift` int(5) NOT NULL default '-750', 
    105   `rhshift` int(5) NOT NULL default '100', 
    106   `rvshift` int(5) NOT NULL default '-750', 
    107   PRIMARY KEY  (`ID`) 
    108 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0; 
    109  
    110 -- 
    111 -- Dumping data for table `sys_banners` 
    112 -- 
    113  
    114  
    115 -- -------------------------------------------------------- 
    116  
    117 -- 
    118 -- Table structure for table `sys_banners_clicks` 
    119 -- 
    120  
    121 CREATE TABLE `sys_banners_clicks` ( 
    122   `ID` int(10) unsigned NOT NULL default '0', 
    123   `Date` int(10) NOT NULL default '0', 
    124   `IP` varchar(16) NOT NULL default '', 
    125   UNIQUE KEY `ID_2` (`ID`,`Date`,`IP`), 
    126   KEY `ID` (`ID`) 
    127 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    128  
    129 -- 
    130 -- Dumping data for table `sys_banners_clicks` 
    131 -- 
    132  
    133  
    134 -- -------------------------------------------------------- 
    135  
    136 -- 
    137 -- Table structure for table `sys_banners_shows` 
    138 -- 
    139  
    140 CREATE TABLE `sys_banners_shows` ( 
    141   `ID` int(10) unsigned NOT NULL default '0', 
    142   `Date` int(10) NOT NULL default '0', 
    143   `IP` varchar(16) NOT NULL default '', 
    144   KEY `ID` (`ID`) 
    145 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    146  
    147 -- 
    148 -- Dumping data for table `sys_banners_shows` 
    149 -- 
    150  
    15124 
    15225-- -------------------------------------------------------- 
    … …  
    16437  KEY `Profile` (`Profile`) 
    16538) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    166  
    167 -- 
    168 -- Dumping data for table `sys_block_list` 
    169 -- 
    17039 
    17140-- -------------------------------------------------------- 
    … …  
    18554) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    18655 
    187 -- 
    188 -- Dumping data for table `sys_categories` 
    189 -- 
    190  
    191 -- -------------------------------------------------------- 
    192  
     56-- -------------------------------------------------------- 
    19357 
    19458-- 
    … …  
    20367) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    20468 
     69 
     70-- -------------------------------------------------------- 
    20571 
    20672-- 
    … …  
    21884  PRIMARY KEY (`ID`) 
    21985) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    220  
    221 -- 
    222 -- Dumping data for table `sys_objects_categories` 
    223 -- 
    224  
    225 -- -------------------------------------------------------- 
    226  
    227 -- 
    228 -- Table structure for table `sys_cmts_profile` 
    229 -- 
    230  
    231 CREATE TABLE `sys_cmts_profile` ( 
    232   `cmt_id` int(11) NOT NULL auto_increment, 
    233   `cmt_parent_id` int(11) NOT NULL default '0', 
    234   `cmt_object_id` int(11) NOT NULL default '0', 
    235   `cmt_author_id` int(10) unsigned NOT NULL default '0', 
    236   `cmt_text` text NOT NULL, 
    237   `cmt_mood` tinyint NOT NULL DEFAULT '0', 
    238   `cmt_rate` int(11) NOT NULL default '0', 
    239   `cmt_rate_count` int(11) NOT NULL default '0', 
    240   `cmt_time` datetime NOT NULL default '0000-00-00 00:00:00', 
    241   `cmt_replies` int(11) NOT NULL default '0', 
    242   PRIMARY KEY  (`cmt_id`), 
    243   KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`) 
    244 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    245  
    246 -- 
    247 -- Dumping data for table `sys_cmts_profile` 
    248 -- 
    249  
    250 -- -------------------------------------------------------- 
    251  
    252 -- 
    253 -- Table structure for table `sys_cmts_track` 
    254 -- 
    255  
    256 CREATE TABLE `sys_cmts_track` ( 
    257   `cmt_system_id` int(11) NOT NULL default '0', 
    258   `cmt_id` int(11) NOT NULL default '0', 
    259   `cmt_rate` tinyint(4) NOT NULL default '0', 
    260   `cmt_rate_author_id` int(10) unsigned NOT NULL default '0', 
    261   `cmt_rate_author_nip` int(11) unsigned NOT NULL default '0', 
    262   `cmt_rate_ts` int(11) NOT NULL default '0', 
    263   PRIMARY KEY  (`cmt_system_id`,`cmt_id`,`cmt_rate_author_nip`) 
    264 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    265  
    266 -- 
    267 -- Dumping data for table `sys_cmts_track` 
    268 -- 
    269  
    27086 
    27187-- -------------------------------------------------------- 
    … …  
    299115) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    300116 
    301  
    302 -- 
    303 -- Table structure for table `sys_color_base` 
    304 -- 
    305  
    306 CREATE TABLE `sys_color_base` ( 
    307   `ColorName` varchar(20) NOT NULL default '', 
    308   `ColorCode` varchar(10) NOT NULL default '', 
    309   UNIQUE KEY `ColorName` (`ColorName`) 
    310 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    311  
    312 -- 
    313 -- Dumping data for table `sys_color_base` 
    314 -- 
    315  
    316 INSERT INTO `sys_color_base` VALUES('AliceBlue', '#F0F8FF'); 
    317 INSERT INTO `sys_color_base` VALUES('AntiqueWhite', '#FAEBD7'); 
    318 INSERT INTO `sys_color_base` VALUES('Aqua', '#00FFFF'); 
    319 INSERT INTO `sys_color_base` VALUES('Aquamarine', '#7FFFD4'); 
    320 INSERT INTO `sys_color_base` VALUES('Azure', '#F0FFFF'); 
    321 INSERT INTO `sys_color_base` VALUES('Beige', '#F5F5DC'); 
    322 INSERT INTO `sys_color_base` VALUES('Bisque', '#FFE4C4'); 
    323 INSERT INTO `sys_color_base` VALUES('Black', '#000000'); 
    324 INSERT INTO `sys_color_base` VALUES('BlanchedAlmond', '#FFEBCD'); 
    325 INSERT INTO `sys_color_base` VALUES('Blue', '#0000FF'); 
    326 INSERT INTO `sys_color_base` VALUES('BlueViolet', '#8A2BE2'); 
    327 INSERT INTO `sys_color_base` VALUES('Brown', '#A52A2A'); 
    328 INSERT INTO `sys_color_base` VALUES('BurlyWood', '#DEB887'); 
    329 INSERT INTO `sys_color_base` VALUES('CadetBlue', '#5F9EA0'); 
    330 INSERT INTO `sys_color_base` VALUES('Chartreuse', '#7FFF00'); 
    331 INSERT INTO `sys_color_base` VALUES('Chocolate', '#D2691E'); 
    332 INSERT INTO `sys_color_base` VALUES('Coral', '#FF7F50'); 
    333 INSERT INTO `sys_color_base` VALUES('CornflowerBlue', '#6495ED'); 
    334 INSERT INTO `sys_color_base` VALUES('Cornsilk', '#FFF8DC'); 
    335 INSERT INTO `sys_color_base` VALUES('Crimson', '#DC143C'); 
    336 INSERT INTO `sys_color_base` VALUES('Cyan', '#00FFFF'); 
    337 INSERT INTO `sys_color_base` VALUES('DarkBlue', '#00008B'); 
    338 INSERT INTO `sys_color_base` VALUES('DarkCyan', '#008B8B'); 
    339 INSERT INTO `sys_color_base` VALUES('DarkGoldenRod', '#B8860B'); 
    340 INSERT INTO `sys_color_base` VALUES('DarkGray', '#A9A9A9'); 
    341 INSERT INTO `sys_color_base` VALUES('DarkGreen', '#006400'); 
    342 INSERT INTO `sys_color_base` VALUES('DarkKhaki', '#BDB76B'); 
    343 INSERT INTO `sys_color_base` VALUES('DarkMagenta', '#8B008B'); 
    344 INSERT INTO `sys_color_base` VALUES('DarkOliveGreen', '#556B2F'); 
    345 INSERT INTO `sys_color_base` VALUES('Darkorange', '#FF8C00'); 
    346 INSERT INTO `sys_color_base` VALUES('DarkOrchid', '#9932CC'); 
    347 INSERT INTO `sys_color_base` VALUES('DarkRed', '#8B0000'); 
    348 INSERT INTO `sys_color_base` VALUES('DarkSalmon', '#E9967A'); 
    349 INSERT INTO `sys_color_base` VALUES('DarkSeaGreen', '#8FBC8F'); 
    350 INSERT INTO `sys_color_base` VALUES('DarkSlateBlue', '#483D8B'); 
    351 INSERT INTO `sys_color_base` VALUES('DarkSlateGray', '#2F4F4F'); 
    352 INSERT INTO `sys_color_base` VALUES('DarkTurquoise', '#00CED1'); 
    353 INSERT INTO `sys_color_base` VALUES('DarkViolet', '#9400D3'); 
    354 INSERT INTO `sys_color_base` VALUES('DeepPink', '#FF1493'); 
    355 INSERT INTO `sys_color_base` VALUES('DeepSkyBlue', '#00BFFF'); 
    356 INSERT INTO `sys_color_base` VALUES('DimGray', '#696969'); 
    357 INSERT INTO `sys_color_base` VALUES('DodgerBlue', '#1E90FF'); 
    358 INSERT INTO `sys_color_base` VALUES('Feldspar', '#D19275'); 
    359 INSERT INTO `sys_color_base` VALUES('FireBrick', '#B22222'); 
    360 INSERT INTO `sys_color_base` VALUES('FloralWhite', '#FFFAF0'); 
    361 INSERT INTO `sys_color_base` VALUES('ForestGreen', '#228B22'); 
    362 INSERT INTO `sys_color_base` VALUES('Fuchsia', '#FF00FF'); 
    363 INSERT INTO `sys_color_base` VALUES('Gainsboro', '#DCDCDC'); 
    364 INSERT INTO `sys_color_base` VALUES('GhostWhite', '#F8F8FF'); 
    365 INSERT INTO `sys_color_base` VALUES('Gold', '#FFD700'); 
    366 INSERT INTO `sys_color_base` VALUES('GoldenRod', '#DAA520'); 
    367 INSERT INTO `sys_color_base` VALUES('Gray', '#808080'); 
    368 INSERT INTO `sys_color_base` VALUES('Green', '#008000'); 
    369 INSERT INTO `sys_color_base` VALUES('GreenYellow', '#ADFF2F'); 
    370 INSERT INTO `sys_color_base` VALUES('HoneyDew', '#F0FFF0'); 
    371 INSERT INTO `sys_color_base` VALUES('HotPink', '#FF69B4'); 
    372 INSERT INTO `sys_color_base` VALUES('IndianRed', '#CD5C5C'); 
    373 INSERT INTO `sys_color_base` VALUES('Indigo', '#4B0082'); 
    374 INSERT INTO `sys_color_base` VALUES('Ivory', '#FFFFF0'); 
    375 INSERT INTO `sys_color_base` VALUES('Khaki', '#F0E68C'); 
    376 INSERT INTO `sys_color_base` VALUES('Lavender', '#E6E6FA'); 
    377 INSERT INTO `sys_color_base` VALUES('LavenderBlush', '#FFF0F5'); 
    378 INSERT INTO `sys_color_base` VALUES('LawnGreen', '#7CFC00'); 
    379 INSERT INTO `sys_color_base` VALUES('LemonChiffon', '#FFFACD'); 
    380 INSERT INTO `sys_color_base` VALUES('LightBlue', '#ADD8E6'); 
    381 INSERT INTO `sys_color_base` VALUES('LightCoral', '#F08080'); 
    382 INSERT INTO `sys_color_base` VALUES('LightCyan', '#E0FFFF'); 
    383 INSERT INTO `sys_color_base` VALUES('LightGoldenRodYellow', '#FAFAD2'); 
    384 INSERT INTO `sys_color_base` VALUES('LightGrey', '#D3D3D3'); 
    385 INSERT INTO `sys_color_base` VALUES('LightGreen', '#90EE90'); 
    386 INSERT INTO `sys_color_base` VALUES('LightPink', '#FFB6C1'); 
    387 INSERT INTO `sys_color_base` VALUES('LightSalmon', '#FFA07A'); 
    388 INSERT INTO `sys_color_base` VALUES('LightSeaGreen', '#20B2AA'); 
    389 INSERT INTO `sys_color_base` VALUES('LightSkyBlue', '#87CEFA'); 
    390 INSERT INTO `sys_color_base` VALUES('LightSlateBlue', '#8470FF'); 
    391 INSERT INTO `sys_color_base` VALUES('LightSlateGray', '#778899'); 
    392 INSERT INTO `sys_color_base` VALUES('LightSteelBlue', '#B0C4DE'); 
    393 INSERT INTO `sys_color_base` VALUES('LightYellow', '#FFFFE0'); 
    394 INSERT INTO `sys_color_base` VALUES('Lime', '#00FF00'); 
    395 INSERT INTO `sys_color_base` VALUES('LimeGreen', '#32CD32'); 
    396 INSERT INTO `sys_color_base` VALUES('Linen', '#FAF0E6'); 
    397 INSERT INTO `sys_color_base` VALUES('Magenta', '#FF00FF'); 
    398 INSERT INTO `sys_color_base` VALUES('Maroon', '#800000'); 
    399 INSERT INTO `sys_color_base` VALUES('MediumAquaMarine', '#66CDAA'); 
    400 INSERT INTO `sys_color_base` VALUES('MediumBlue', '#0000CD'); 
    401 INSERT INTO `sys_color_base` VALUES('MediumOrchid', '#BA55D3'); 
    402 INSERT INTO `sys_color_base` VALUES('MediumPurple', '#9370D8'); 
    403 INSERT INTO `sys_color_base` VALUES('MediumSeaGreen', '#3CB371'); 
    404 INSERT INTO `sys_color_base` VALUES('MediumSlateBlue', '#7B68EE'); 
    405 INSERT INTO `sys_color_base` VALUES('MediumSpringGreen', '#00FA9A'); 
    406 INSERT INTO `sys_color_base` VALUES('MediumTurquoise', '#48D1CC'); 
    407 INSERT INTO `sys_color_base` VALUES('MediumVioletRed', '#C71585'); 
    408 INSERT INTO `sys_color_base` VALUES('MidnightBlue', '#191970'); 
    409 INSERT INTO `sys_color_base` VALUES('MintCream', '#F5FFFA'); 
    410 INSERT INTO `sys_color_base` VALUES('MistyRose', '#FFE4E1'); 
    411 INSERT INTO `sys_color_base` VALUES('Moccasin', '#FFE4B5'); 
    412 INSERT INTO `sys_color_base` VALUES('NavajoWhite', '#FFDEAD'); 
    413 INSERT INTO `sys_color_base` VALUES('Navy', '#000080'); 
    414 INSERT INTO `sys_color_base` VALUES('OldLace', '#FDF5E6'); 
    415 INSERT INTO `sys_color_base` VALUES('Olive', '#808000'); 
    416 INSERT INTO `sys_color_base` VALUES('OliveDrab', '#6B8E23'); 
    417 INSERT INTO `sys_color_base` VALUES('Orange', '#FFA500'); 
    418 INSERT INTO `sys_color_base` VALUES('OrangeRed', '#FF4500'); 
    419 INSERT INTO `sys_color_base` VALUES('Orchid', '#DA70D6'); 
    420 INSERT INTO `sys_color_base` VALUES('PaleGoldenRod', '#EEE8AA'); 
    421 INSERT INTO `sys_color_base` VALUES('PaleGreen', '#98FB98'); 
    422 INSERT INTO `sys_color_base` VALUES('PaleTurquoise', '#AFEEEE'); 
    423 INSERT INTO `sys_color_base` VALUES('PaleVioletRed', '#D87093'); 
    424 INSERT INTO `sys_color_base` VALUES('PapayaWhip', '#FFEFD5'); 
    425 INSERT INTO `sys_color_base` VALUES('PeachPuff', '#FFDAB9'); 
    426 INSERT INTO `sys_color_base` VALUES('Peru', '#CD853F'); 
    427 INSERT INTO `sys_color_base` VALUES('Pink', '#FFC0CB'); 
    428 INSERT INTO `sys_color_base` VALUES('Plum', '#DDA0DD'); 
    429 INSERT INTO `sys_color_base` VALUES('PowderBlue', '#B0E0E6'); 
    430 INSERT INTO `sys_color_base` VALUES('Purple', '#800080'); 
    431 INSERT INTO `sys_color_base` VALUES('Red', '#FF0000'); 
    432 INSERT INTO `sys_color_base` VALUES('RosyBrown', '#BC8F8F'); 
    433 INSERT INTO `sys_color_base` VALUES('RoyalBlue', '#4169E1'); 
    434 INSERT INTO `sys_color_base` VALUES('SaddleBrown', '#8B4513'); 
    435 INSERT INTO `sys_color_base` VALUES('Salmon', '#FA8072'); 
    436 INSERT INTO `sys_color_base` VALUES('SandyBrown', '#F4A460'); 
    437 INSERT INTO `sys_color_base` VALUES('SeaGreen', '#2E8B57'); 
    438 INSERT INTO `sys_color_base` VALUES('SeaShell', '#FFF5EE'); 
    439 INSERT INTO `sys_color_base` VALUES('Sienna', '#A0522D'); 
    440 INSERT INTO `sys_color_base` VALUES('Silver', '#C0C0C0'); 
    441 INSERT INTO `sys_color_base` VALUES('SkyBlue', '#87CEEB'); 
    442 INSERT INTO `sys_color_base` VALUES('SlateBlue', '#6A5ACD'); 
    443 INSERT INTO `sys_color_base` VALUES('SlateGray', '#708090'); 
    444 INSERT INTO `sys_color_base` VALUES('Snow', '#FFFAFA'); 
    445 INSERT INTO `sys_color_base` VALUES('SpringGreen', '#00FF7F'); 
    446 INSERT INTO `sys_color_base` VALUES('SteelBlue', '#4682B4'); 
    447 INSERT INTO `sys_color_base` VALUES('Tan', '#D2B48C'); 
    448 INSERT INTO `sys_color_base` VALUES('Teal', '#008080'); 
    449 INSERT INTO `sys_color_base` VALUES('Thistle', '#D8BFD8'); 
    450 INSERT INTO `sys_color_base` VALUES('Tomato', '#FF6347'); 
    451 INSERT INTO `sys_color_base` VALUES('Turquoise', '#40E0D0'); 
    452 INSERT INTO `sys_color_base` VALUES('Violet', '#EE82EE'); 
    453 INSERT INTO `sys_color_base` VALUES('VioletRed', '#D02090'); 
    454 INSERT INTO `sys_color_base` VALUES('Wheat', '#F5DEB3'); 
    455 INSERT INTO `sys_color_base` VALUES('White', '#FFFFFF'); 
    456 INSERT INTO `sys_color_base` VALUES('WhiteSmoke', '#F5F5F5'); 
    457 INSERT INTO `sys_color_base` VALUES('Yellow', '#FFFF00'); 
    458 INSERT INTO `sys_color_base` VALUES('YellowGreen', '#9ACD32'); 
    459  
    460 -- -------------------------------------------------------- 
    461  
    462 -- 
    463 -- Table structure for table `sys_countries` 
    464 -- 
    465  
    466 CREATE TABLE `sys_countries` ( 
    467   `ISO2` varchar(2) NOT NULL default '', 
    468   `ISO3` varchar(3) NOT NULL default '', 
    469   `ISONo` smallint(3) NOT NULL default '0', 
    470   `Country` varchar(100) NOT NULL default '', 
    471   `Region` varchar(100) default NULL, 
    472   `Currency` varchar(100) default NULL, 
    473   `CurrencyCode` varchar(3) default NULL, 
    474   PRIMARY KEY  (`ISO2`), 
    475   KEY `CurrencyCode` (`CurrencyCode`) 
    476 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    477  
    478 -- 
    479 -- Dumping data for table `sys_countries` 
    480 -- 
    481  
    482 INSERT INTO `sys_countries` VALUES('AD', 'AND', 20, 'Andorra', 'Europe', 'Euro', 'EUR'); 
    483 INSERT INTO `sys_countries` VALUES('AE', 'ARE', 784, 'United Arab Emirates', 'Middle East', 'UAE Dirham', 'AED'); 
    484 INSERT INTO `sys_countries` VALUES('AF', 'AFG', 4, 'Afghanistan', 'Asia', 'Afghani', 'AFA'); 
    485 INSERT INTO `sys_countries` VALUES('AG', 'ATG', 28, 'Antigua and Barbuda', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'); 
    486 INSERT INTO `sys_countries` VALUES('AI', 'AIA', 660, 'Anguilla', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'); 
    487 INSERT INTO `sys_countries` VALUES('AL', 'ALB', 8, 'Albania', 'Europe', 'Lek', 'ALL'); 
    488 INSERT INTO `sys_countries` VALUES('AM', 'ARM', 51, 'Armenia', 'Commonwealth of Independent States', 'Armenian Dram', 'AMD'); 
    489 INSERT INTO `sys_countries` VALUES('AN', 'ANT', 530, 'Netherlands Antilles', 'Central America and the Caribbean', 'Netherlands Antillean guilder', 'ANG'); 
    490 INSERT INTO `sys_countries` VALUES('AO', 'AGO', 24, 'Angola', 'Africa', 'Kwanza', 'AOA'); 
    491 INSERT INTO `sys_countries` VALUES('AQ', 'ATA', 10, 'Antarctica', 'Antarctic Region', NULL, NULL); 
    492 INSERT INTO `sys_countries` VALUES('AR', 'ARG', 32, 'Argentina', 'South America', 'Argentine Peso', 'ARS'); 
    493 INSERT INTO `sys_countries` VALUES('AS', 'ASM', 16, 'American Samoa', 'Oceania', 'US Dollar', 'USD'); 
    494 INSERT INTO `sys_countries` VALUES('AT', 'AUT', 40, 'Austria', 'Europe', 'Euro', 'EUR'); 
    495 INSERT INTO `sys_countries` VALUES('AU', 'AUS', 36, 'Australia', 'Oceania', 'Australian dollar', 'AUD'); 
    496 INSERT INTO `sys_countries` VALUES('AW', 'ABW', 533, 'Aruba', 'Central America and the Caribbean', 'Aruban Guilder', 'AWG'); 
    497 INSERT INTO `sys_countries` VALUES('AX', 'ALA', 248, 'Aland Islands', 'Europe', 'Euro', 'EUR'); 
    498 INSERT INTO `sys_countries` VALUES('AZ', 'AZE', 31, 'Azerbaijan', 'Commonwealth of Independent States', 'Azerbaijani Manat', 'AZM'); 
    499 INSERT INTO `sys_countries` VALUES('BA', 'BIH', 70, 'Bosnia and Herzegovina', 'Bosnia and Herzegovina, Europe', 'Convertible Marka', 'BAM'); 
    500 INSERT INTO `sys_countries` VALUES('BB', 'BRB', 52, 'Barbados', 'Central America and the Caribbean', 'Barbados Dollar', 'BBD'); 
    501 INSERT INTO `sys_countries` VALUES('BD', 'BGD', 50, 'Bangladesh', 'Asia', 'Taka', 'BDT'); 
    502 INSERT INTO `sys_countries` VALUES('BE', 'BEL', 56, 'Belgium', 'Europe', 'Euro', 'EUR'); 
    503 INSERT INTO `sys_countries` VALUES('BF', 'BFA', 854, 'Burkina Faso', 'Africa', 'CFA Franc BCEAO', 'XOF'); 
    504 INSERT INTO `sys_countries` VALUES('BG', 'BGR', 100, 'Bulgaria', 'Europe', 'Lev', 'BGL'); 
    505 INSERT INTO `sys_countries` VALUES('BH', 'BHR', 48, 'Bahrain', 'Middle East', 'Bahraini Dinar', 'BHD'); 
    506 INSERT INTO `sys_countries` VALUES('BI', 'BDI', 108, 'Burundi', 'Africa', 'Burundi Franc', 'BIF'); 
    507 INSERT INTO `sys_countries` VALUES('BJ', 'BEN', 204, 'Benin', 'Africa', 'CFA Franc BCEAO', 'XOF'); 
    508 INSERT INTO `sys_countries` VALUES('BL', 'BLM', 652, 'Saint Barthelemy', 'Central America and the Caribbean', 'Euro', 'EUR'); 
    509 INSERT INTO `sys_countries` VALUES('BM', 'BMU', 60, 'Bermuda', 'North America', 'Bermudian Dollar', 'BMD'); 
    510 INSERT INTO `sys_countries` VALUES('BN', 'BRN', 96, 'Brunei Darussalam', 'Southeast Asia', 'Brunei Dollar', 'BND'); 
    511 INSERT INTO `sys_countries` VALUES('BO', 'BOL', 68, 'Bolivia', 'South America', 'Boliviano', 'BOB'); 
    512 INSERT INTO `sys_countries` VALUES('BR', 'BRA', 76, 'Brazil', 'South America', 'Brazilian Real', 'BRL'); 
    513 INSERT INTO `sys_countries` VALUES('BS', 'BHS', 44, 'The Bahamas', 'Central America and the Caribbean', 'Bahamian Dollar', 'BSD'); 
    514 INSERT INTO `sys_countries` VALUES('BT', 'BTN', 64, 'Bhutan', 'Asia', 'Ngultrum', 'BTN'); 
    515 INSERT INTO `sys_countries` VALUES('BV', 'BVT', 74, 'Bouvet Island', 'Antarctic Region', 'Norwegian Krone', 'NOK'); 
    516 INSERT INTO `sys_countries` VALUES('BW', 'BWA', 72, 'Botswana', 'Africa', 'Pula', 'BWP'); 
    517 INSERT INTO `sys_countries` VALUES('BY', 'BLR', 112, 'Belarus', 'Commonwealth of Independent States', 'Belarussian Ruble', 'BYR'); 
    518 INSERT INTO `sys_countries` VALUES('BZ', 'BLZ', 84, 'Belize', 'Central America and the Caribbean', 'Belize Dollar', 'BZD'); 
    519 INSERT INTO `sys_countries` VALUES('CA', 'CAN', 124, 'Canada', 'North America', 'Canadian Dollar', 'CAD'); 
    520 INSERT INTO `sys_countries` VALUES('CC', 'CCK', 166, 'Cocos (Keeling) Islands', 'Southeast Asia', 'Australian Dollar', 'AUD'); 
    521 INSERT INTO `sys_countries` VALUES('CD', 'COD', 180, 'Congo, Democratic Republic of the', 'Africa', 'Franc Congolais', 'CDF'); 
    522 INSERT INTO `sys_countries` VALUES('CF', 'CAF', 140, 'Central African Republic', 'Africa', 'CFA Franc BEAC', 'XAF'); 
    523 INSERT INTO `sys_countries` VALUES('CG', 'COG', 178, 'Congo, Republic of the', 'Africa', 'CFA Franc BEAC', 'XAF'); 
    524 INSERT INTO `sys_countries` VALUES('CH', 'CHE', 756, 'Switzerland', 'Europe', 'Swiss Franc', 'CHF'); 
    525 INSERT INTO `sys_countries` VALUES('CI', 'CIV', 384, 'Cote d''Ivoire', 'Africa', 'CFA Franc BCEAO', 'XOF'); 
    526 INSERT INTO `sys_countries` VALUES('CK', 'COK', 184, 'Cook Islands', 'Oceania', 'New Zealand Dollar', 'NZD'); 
    527 INSERT INTO `sys_countries` VALUES('CL', 'CHL', 152, 'Chile', 'South America', 'Chilean Peso', 'CLP'); 
    528 INSERT INTO `sys_countries` VALUES('CM', 'CMR', 120, 'Cameroon', 'Africa', 'CFA Franc BEAC', 'XAF'); 
    529 INSERT INTO `sys_countries` VALUES('CN', 'CHN', 156, 'China', 'Asia', 'Yuan Renminbi', 'CNY'); 
    530 INSERT INTO `sys_countries` VALUES('CO', 'COL', 170, 'Colombia', 'South America, Central America and the Caribbean', 'Colombian Peso', 'COP'); 
    531 INSERT INTO `sys_countries` VALUES('CR', 'CRI', 188, 'Costa Rica', 'Central America and the Caribbean', 'Costa Rican Colon', 'CRC'); 
    532 INSERT INTO `sys_countries` VALUES('CU', 'CUB', 192, 'Cuba', 'Central America and the Caribbean', 'Cuban Peso', 'CUP'); 
    533 INSERT INTO `sys_countries` VALUES('CV', 'CPV', 132, 'Cape Verde', 'World', 'Cape Verdean Escudo', 'CVE'); 
    534 INSERT INTO `sys_countries` VALUES('CX', 'CXR', 162, 'Christmas Island', 'Southeast Asia', 'Australian Dollar', 'AUD'); 
    535 INSERT INTO `sys_countries` VALUES('CY', 'CYP', 196, 'Cyprus', 'Middle East', 'Cyprus Pound', 'CYP'); 
    536 INSERT INTO `sys_countries` VALUES('CZ', 'CZE', 203, 'Czech Republic', 'Europe', 'Czech Koruna', 'CZK'); 
    537 INSERT INTO `sys_countries` VALUES('DE', 'DEU', 276, 'Germany', 'Europe', 'Euro', 'EUR'); 
    538 INSERT INTO `sys_countries` VALUES('DJ', 'DJI', 262, 'Djibouti', 'Africa', 'Djibouti Franc', 'DJF'); 
    539 INSERT INTO `sys_countries` VALUES('DK', 'DNK', 208, 'Denmark', 'Europe', 'Danish Krone', 'DKK'); 
    540 INSERT INTO `sys_countries` VALUES('DM', 'DMA', 212, 'Dominica', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'); 
    541 INSERT INTO `sys_countries` VALUES('DO', 'DOM', 214, 'Dominican Republic', 'Central America and the Caribbean', 'Dominican Peso', 'DOP'); 
    542 INSERT INTO `sys_countries` VALUES('DZ', 'DZA', 12, 'Algeria', 'Africa', 'Algerian Dinar', 'DZD'); 
    543 INSERT INTO `sys_countries` VALUES('EC', 'ECU', 218, 'Ecuador', 'South America', 'US dollar', 'USD'); 
    544 INSERT INTO `sys_countries` VALUES('EE', 'EST', 233, 'Estonia', 'Europe', 'Kroon', 'EEK'); 
    545 INSERT INTO `sys_countries` VALUES('EG', 'EGY', 818, 'Egypt', 'Africa', 'Egyptian Pound', 'EGP'); 
    546 INSERT INTO `sys_countries` VALUES('EH', 'ESH', 732, 'Western Sahara', 'Africa', 'Moroccan Dirham', 'MAD'); 
    547 INSERT INTO `sys_countries` VALUES('ER', 'ERI', 232, 'Eritrea', 'Africa', 'Nakfa', 'ERN'); 
    548 INSERT INTO `sys_countries` VALUES('ES', 'ESP', 724, 'Spain', 'Europe', 'Euro', 'EUR'); 
    549 INSERT INTO `sys_countries` VALUES('ET', 'ETH', 231, 'Ethiopia', 'Africa', 'Ethiopian Birr', 'ETB'); 
    550 INSERT INTO `sys_countries` VALUES('FI', 'FIN', 246, 'Finland', 'Europe', 'Euro', 'EUR'); 
    551 INSERT INTO `sys_countries` VALUES('FJ', 'FJI', 242, 'Fiji', 'Oceania', 'Fijian Dollar', 'FJD'); 
    552 INSERT INTO `sys_countries` VALUES('FK', 'FLK', 238, 'Falkland Islands (Islas Malvinas)', 'South America', 'Falkland Islands Pound', 'FKP'); 
    553 INSERT INTO `sys_countries` VALUES('FM', 'FSM', 583, 'Micronesia, Federated States of', 'Oceania', 'US dollar', 'USD'); 
    554 INSERT INTO `sys_countries` VALUES('FO', 'FRO', 234, 'Faroe Islands', 'Europe', 'Danish Krone', 'DKK'); 
    555 INSERT INTO `sys_countries` VALUES('FR', 'FRA', 250, 'France', 'Europe', 'Euro', 'EUR'); 
    556 INSERT INTO `sys_countries` VALUES('GA', 'GAB', 266, 'Gabon', 'Africa', 'CFA Franc BEAC', 'XAF'); 
    557 INSERT INTO `sys_countries` VALUES('GB', 'GBR', 826, 'United Kingdom', 'Europe', 'Pound Sterling', 'GBP'); 
    558 INSERT INTO `sys_countries` VALUES('GD', 'GRD', 308, 'Grenada', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'); 
    559 INSERT INTO `sys_countries` VALUES('GE', 'GEO', 268, 'Georgia', 'Commonwealth of Independent States', 'Lari', 'GEL'); 
    560 INSERT INTO `sys_countries` VALUES('GF', 'GUF', 254, 'French Guiana', 'South America', 'Euro', 'EUR'); 
    561 INSERT INTO `sys_countries` VALUES('GG', 'GGY', 831, 'Guernsey', 'Europe', 'Pound sterling', 'GBP'); 
    562 INSERT INTO `sys_countries` VALUES('GH', 'GHA', 288, 'Ghana', 'Africa', 'Cedi', 'GHC'); 
    563 INSERT INTO `sys_countries` VALUES('GI', 'GIB', 292, 'Gibraltar', 'Europe', 'Gibraltar Pound', 'GIP'); 
    564 INSERT INTO `sys_countries` VALUES('GL', 'GRL', 304, 'Greenland', 'Arctic Region', 'Danish Krone', 'DKK'); 
    565 INSERT INTO `sys_countries` VALUES('GM', 'GMB', 270, 'The Gambia', 'Africa', 'Dalasi', 'GMD'); 
    566 INSERT INTO `sys_countries` VALUES('GN', 'GIN', 324, 'Guinea', 'Africa', 'Guinean Franc', 'GNF'); 
    567 INSERT INTO `sys_countries` VALUES('GP', 'GLP', 312, 'Guadeloupe', 'Central America and the Caribbean', 'Euro', 'EUR'); 
    568 INSERT INTO `sys_countries` VALUES('GQ', 'GNQ', 226, 'Equatorial Guinea', 'Africa', 'CFA Franc BEAC', 'XAF'); 
    569 INSERT INTO `sys_countries` VALUES('GR', 'GRC', 300, 'Greece', 'Europe', 'Euro', 'EUR'); 
    570 INSERT INTO `sys_countries` VALUES('GS', 'SGS', 239, 'South Georgia and the South Sandwich Islands', 'Antarctic Region', 'Pound Sterling', 'GBP'); 
    571 INSERT INTO `sys_countries` VALUES('GT', 'GTM', 320, 'Guatemala', 'Central America and the Caribbean', 'Quetzal', 'GTQ'); 
    572 INSERT INTO `sys_countries` VALUES('GU', 'GUM', 316, 'Guam', 'Oceania', 'US Dollar', 'USD'); 
    573 INSERT INTO `sys_countries` VALUES('GW', 'GNB', 624, 'Guinea-Bissau', 'Africa', 'CFA Franc BCEAO', 'XOF'); 
    574 INSERT INTO `sys_countries` VALUES('GY', 'GUY', 328, 'Guyana', 'South America', 'Guyana Dollar', 'GYD'); 
    575 INSERT INTO `sys_countries` VALUES('HK', 'HKG', 344, 'Hong Kong (SAR)', 'Southeast Asia', 'Hong Kong Dollar', 'HKD'); 
    576 INSERT INTO `sys_countries` VALUES('HM', 'HMD', 334, 'Heard Island and McDonald Islands', 'Antarctic Region', 'Australian Dollar', 'AUD'); 
    577 INSERT INTO `sys_countries` VALUES('HN', 'HND', 340, 'Honduras', 'Central America and the Caribbean', 'Lempira', 'HNL'); 
    578 INSERT INTO `sys_countries` VALUES('HR', 'HRV', 191, 'Croatia', 'Europe', 'Kuna', 'HRK'); 
    579 INSERT INTO `sys_countries` VALUES('HT', 'HTI', 332, 'Haiti', 'Central America and the Caribbean', 'Gourde', 'HTG'); 
    580 INSERT INTO `sys_countries` VALUES('HU', 'HUN', 348, 'Hungary', 'Europe', 'Forint', 'HUF'); 
    581 INSERT INTO `sys_countries` VALUES('ID', 'IDN', 360, 'Indonesia', 'Southeast Asia', 'Rupiah', 'IDR'); 
    582 INSERT INTO `sys_countries` VALUES('IE', 'IRL', 372, 'Ireland', 'Europe', 'Euro', 'EUR'); 
    583 INSERT INTO `sys_countries` VALUES('IL', 'ISR', 376, 'Israel', 'Middle East', 'New Israeli Sheqel', 'ILS'); 
    584 INSERT INTO `sys_countries` VALUES('IM', 'IMN', 833, 'Isle of Man', 'Europe', 'Pound sterling', 'GBP'); 
    585 INSERT INTO `sys_countries` VALUES('IN', 'IND', 356, 'India', 'Asia', 'Indian Rupee', 'INR'); 
    586 INSERT INTO `sys_countries` VALUES('IO', 'IOT', 86, 'British Indian Ocean Territory', 'World', 'US Dollar', 'USD'); 
    587 INSERT INTO `sys_countries` VALUES('IQ', 'IRQ', 368, 'Iraq', 'Middle East', 'Iraqi Dinar', 'IQD'); 
    588 INSERT INTO `sys_countries` VALUES('IR', 'IRN', 364, 'Iran', 'Middle East', 'Iranian Rial', 'IRR'); 
    589 INSERT INTO `sys_countries` VALUES('IS', 'ISL', 352, 'Iceland', 'Arctic Region', 'Iceland Krona', 'ISK'); 
    590 INSERT INTO `sys_countries` VALUES('IT', 'ITA', 380, 'Italy', 'Europe', 'Euro', 'EUR'); 
    591 INSERT INTO `sys_countries` VALUES('JE', 'JEY', 832, 'Jersey', 'Europe', 'Pound sterling', 'GBP'); 
    592 INSERT INTO `sys_countries` VALUES('JM', 'JAM', 388, 'Jamaica', 'Central America and the Caribbean', 'Jamaican dollar', 'JMD'); 
    593 INSERT INTO `sys_countries` VALUES('JO', 'JOR', 400, 'Jordan', 'Middle East', 'Jordanian Dinar', 'JOD'); 
    594 INSERT INTO `sys_countries` VALUES('JP', 'JPN', 392, 'Japan', 'Asia', 'Yen', 'JPY'); 
    595 INSERT INTO `sys_countries` VALUES('KE', 'KEN', 404, 'Kenya', 'Africa', 'Kenyan shilling', 'KES'); 
    596 INSERT INTO `sys_countries` VALUES('KG', 'KGZ', 417, 'Kyrgyzstan', 'Commonwealth of Independent States', 'Som', 'KGS'); 
    597 INSERT INTO `sys_countries` VALUES('KH', 'KHM', 116, 'Cambodia', 'Southeast Asia', 'Riel', 'KHR'); 
    598 INSERT INTO `sys_countries` VALUES('KI', 'KIR', 296, 'Kiribati', 'Oceania', 'Australian dollar', 'AUD'); 
    599 INSERT INTO `sys_countries` VALUES('KM', 'COM', 174, 'Comoros', 'Africa', 'Comoro Franc', 'KMF'); 
    600 INSERT INTO `sys_countries` VALUES('KN', 'KNA', 659, 'Saint Kitts and Nevis', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'); 
    601 INSERT INTO `sys_countries` VALUES('KP', 'PRK', 408, 'Korea, North', 'Asia', 'North Korean Won', 'KPW'); 
    602 INSERT INTO `sys_countries` VALUES('KR', 'KOR', 410, 'Korea, South', 'Asia', 'Won', 'KRW'); 
    603 INSERT INTO `sys_countries` VALUES('KW', 'KWT', 414, 'Kuwait', 'Middle East', 'Kuwaiti Dinar', 'KWD'); 
    604 INSERT INTO `sys_countries` VALUES('KY', 'CYM', 136, 'Cayman Islands', 'Central America and the Caribbean', 'Cayman Islands Dollar', 'KYD'); 
    605 INSERT INTO `sys_countries` VALUES('KZ', 'KAZ', 398, 'Kazakhstan', 'Commonwealth of Independent States', 'Tenge', 'KZT'); 
    606 INSERT INTO `sys_countries` VALUES('LA', 'LAO', 418, 'Laos', 'Southeast Asia', 'Kip', 'LAK'); 
    607 INSERT INTO `sys_countries` VALUES('LB', 'LBN', 422, 'Lebanon', 'Middle East', 'Lebanese Pound', 'LBP'); 
    608 INSERT INTO `sys_countries` VALUES('LC', 'LCA', 662, 'Saint Lucia', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'); 
    609 INSERT INTO `sys_countries` VALUES('LI', 'LIE', 438, 'Liechtenstein', 'Europe', 'Swiss Franc', 'CHF'); 
    610 INSERT INTO `sys_countries` VALUES('LK', 'LKA', 144, 'Sri Lanka', 'Asia', 'Sri Lanka Rupee', 'LKR'); 
    611 INSERT INTO `sys_countries` VALUES('LR', 'LBR', 430, 'Liberia', 'Africa', 'Liberian Dollar', 'LRD'); 
    612 INSERT INTO `sys_countries` VALUES('LS', 'LSO', 426, 'Lesotho', 'Africa', 'Loti', 'LSL'); 
    613 INSERT INTO `sys_countries` VALUES('LT', 'LTU', 440, 'Lithuania', 'Europe', 'Lithuanian Litas', 'LTL'); 
    614 INSERT INTO `sys_countries` VALUES('LU', 'LUX', 442, 'Luxembourg', 'Europe', 'Euro', 'EUR'); 
    615 INSERT INTO `sys_countries` VALUES('LV', 'LVA', 428, 'Latvia', 'Europe', 'Latvian Lats', 'LVL'); 
    616 INSERT INTO `sys_countries` VALUES('LY', 'LBY', 434, 'Libya', 'Africa', 'Libyan Dinar', 'LYD'); 
    617 INSERT INTO `sys_countries` VALUES('MA', 'MAR', 504, 'Morocco', 'Africa', 'Moroccan Dirham', 'MAD'); 
    618 INSERT INTO `sys_countries` VALUES('MC', 'MCO', 492, 'Monaco', 'Europe', 'Euro', 'EUR'); 
    619 INSERT INTO `sys_countries` VALUES('MD', 'MDA', 498, 'Moldova', 'Commonwealth of Independent States', 'Moldovan Leu', 'MDL'); 
    620 INSERT INTO `sys_countries` VALUES('ME', 'MNE', 499, 'Montenegro', 'Europe', 'Euro', 'EUR'); 
    621 INSERT INTO `sys_countries` VALUES('MF', 'MAF', 663, 'Saint Martin (French part)', 'Central America and the Caribbean', 'Euro', 'EUR'); 
    622 INSERT INTO `sys_countries` VALUES('MG', 'MDG', 450, 'Madagascar', 'Africa', 'Malagasy Franc', 'MGF'); 
    623 INSERT INTO `sys_countries` VALUES('MH', 'MHL', 584, 'Marshall Islands', 'Oceania', 'US dollar', 'USD'); 
    624 INSERT INTO `sys_countries` VALUES('MK', 'MKD', 807, 'Macedonia, The Former Yugoslav Republic of', 'Europe', 'Denar', 'MKD'); 
    625 INSERT INTO `sys_countries` VALUES('ML', 'MLI', 466, 'Mali', 'Africa', 'CFA Franc BCEAO', 'XOF'); 
    626 INSERT INTO `sys_countries` VALUES('MM', 'MMR', 104, 'Myanmar', 'Southeast Asia', 'kyat', 'MMK'); 
    627 INSERT INTO `sys_countries` VALUES('MN', 'MNG', 496, 'Mongolia', 'Asia', 'Tugrik', 'MNT'); 
    628 INSERT INTO `sys_countries` VALUES('MO', 'MAC', 446, 'Macao', 'Southeast Asia', 'Pataca', 'MOP'); 
    629 INSERT INTO `sys_countries` VALUES('MP', 'MNP', 580, 'Northern Mariana Islands', 'Oceania', 'US Dollar', 'USD'); 
    630 INSERT INTO `sys_countries` VALUES('MQ', 'MTQ', 474, 'Martinique', 'Central America and the Caribbean', 'Euro', 'EUR'); 
    631 INSERT INTO `sys_countries` VALUES('MR', 'MRT', 478, 'Mauritania', 'Africa', 'Ouguiya', 'MRO'); 
    632 INSERT INTO `sys_countries` VALUES('MS', 'MSR', 500, 'Montserrat', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'); 
    633 INSERT INTO `sys_countries` VALUES('MT', 'MLT', 470, 'Malta', 'Europe', 'Maltese Lira', 'MTL'); 
    634 INSERT INTO `sys_countries` VALUES('MU', 'MUS', 480, 'Mauritius', 'World', 'Mauritius Rupee', 'MUR'); 
    635 INSERT INTO `sys_countries` VALUES('MV', 'MDV', 462, 'Maldives', 'Asia', 'Rufiyaa', 'MVR'); 
    636 INSERT INTO `sys_countries` VALUES('MW', 'MWI', 454, 'Malawi', 'Africa', 'Kwacha', 'MWK'); 
    637 INSERT INTO `sys_countries` VALUES('MX', 'MEX', 484, 'Mexico', 'North America', 'Mexican Peso', 'MXN'); 
    638 INSERT INTO `sys_countries` VALUES('MY', 'MYS', 458, 'Malaysia', 'Southeast Asia', 'Malaysian Ringgit', 'MYR'); 
    639 INSERT INTO `sys_countries` VALUES('MZ', 'MOZ', 508, 'Mozambique', 'Africa', 'Metical', 'MZM'); 
    640 INSERT INTO `sys_countries` VALUES('NA', 'NAM', 516, 'Namibia', 'Africa', 'Namibian Dollar', 'NAD'); 
    641 INSERT INTO `sys_countries` VALUES('NC', 'NCL', 540, 'New Caledonia', 'Oceania', 'CFP Franc', 'XPF'); 
    642 INSERT INTO `sys_countries` VALUES('NE', 'NER', 562, 'Niger', 'Africa', 'CFA Franc BCEAO', 'XOF'); 
    643 INSERT INTO `sys_countries` VALUES('NF', 'NFK', 574, 'Norfolk Island', 'Oceania', 'Australian Dollar', 'AUD'); 
    644 INSERT INTO `sys_countries` VALUES('NG', 'NGA', 566, 'Nigeria', 'Africa', 'Naira', 'NGN'); 
    645 INSERT INTO `sys_countries` VALUES('NI', 'NIC', 558, 'Nicaragua', 'Central America and the Caribbean', 'Cordoba Oro', 'NIO'); 
    646 INSERT INTO `sys_countries` VALUES('NL', 'NLD', 528, 'Netherlands', 'Europe', 'Euro', 'EUR'); 
    647 INSERT INTO `sys_countries` VALUES('NO', 'NOR', 578, 'Norway', 'Europe', 'Norwegian Krone', 'NOK'); 
    648 INSERT INTO `sys_countries` VALUES('NP', 'NPL', 524, 'Nepal', 'Asia', 'Nepalese Rupee', 'NPR'); 
    649 INSERT INTO `sys_countries` VALUES('NR', 'NRU', 520, 'Nauru', 'Oceania', 'Australian Dollar', 'AUD'); 
    650 INSERT INTO `sys_countries` VALUES('NU', 'NIU', 570, 'Niue', 'Oceania', 'New Zealand Dollar', 'NZD'); 
    651 INSERT INTO `sys_countries` VALUES('NZ', 'NZL', 554, 'New Zealand', 'Oceania', 'New Zealand Dollar', 'NZD'); 
    652 INSERT INTO `sys_countries` VALUES('OM', 'OMN', 512, 'Oman', 'Middle East', 'Rial Omani', 'OMR'); 
    653 INSERT INTO `sys_countries` VALUES('PA', 'PAN', 591, 'Panama', 'Central America and the Caribbean', 'balboa', 'PAB'); 
    654 INSERT INTO `sys_countries` VALUES('PE', 'PER', 604, 'Peru', 'South America', 'Nuevo Sol', 'PEN'); 
    655 INSERT INTO `sys_countries` VALUES('PF', 'PYF', 258, 'French Polynesia', 'Oceania', 'CFP Franc', 'XPF'); 
    656 INSERT INTO `sys_countries` VALUES('PG', 'PNG', 598, 'Papua New Guinea', 'Oceania', 'Kina', 'PGK'); 
    657 INSERT INTO `sys_countries` VALUES('PH', 'PHL', 608, 'Philippines', 'Southeast Asia', 'Philippine Peso', 'PHP'); 
    658 INSERT INTO `sys_countries` VALUES('PK', 'PAK', 586, 'Pakistan', 'Asia', 'Pakistan Rupee', 'PKR'); 
    659 INSERT INTO `sys_countries` VALUES('PL', 'POL', 616, 'Poland', 'Europe', 'Zloty', 'PLN'); 
    660 INSERT INTO `sys_countries` VALUES('PM', 'SPM', 666, 'Saint Pierre and Miquelon', 'North America', 'Euro', 'EUR'); 
    661 INSERT INTO `sys_countries` VALUES('PN', 'PCN', 612, 'Pitcairn Islands', 'Oceania', 'New Zealand Dollar', 'NZD'); 
    662 INSERT INTO `sys_countries` VALUES('PR', 'PRI', 630, 'Puerto Rico', 'Central America and the Caribbean', 'US dollar', 'USD'); 
    663 INSERT INTO `sys_countries` VALUES('PS', 'PSE', 275, 'Palestinian Territory, Occupied', NULL, NULL, NULL); 
    664 INSERT INTO `sys_countries` VALUES('PT', 'PRT', 620, 'Portugal', 'Europe', 'Euro', 'EUR'); 
    665 INSERT INTO `sys_countries` VALUES('PW', 'PLW', 585, 'Palau', 'Oceania', 'US dollar', 'USD'); 
    666 INSERT INTO `sys_countries` VALUES('PY', 'PRY', 600, 'Paraguay', 'South America', 'Guarani', 'PYG'); 
    667 INSERT INTO `sys_countries` VALUES('QA', 'QAT', 634, 'Qatar', 'Middle East', 'Qatari Rial', 'QAR'); 
    668 INSERT INTO `sys_countries` VALUES('RE', 'REU', 638, 'Reunion', 'World', 'Euro', 'EUR'); 
    669 INSERT INTO `sys_countries` VALUES('RO', 'ROU', 642, 'Romania', 'Europe', 'Leu', 'ROL'); 
    670 INSERT INTO `sys_countries` VALUES('RS', 'SRB', 688, 'Serbia', 'Europe', 'Serbian Dinar', 'RSD'); 
    671 INSERT INTO `sys_countries` VALUES('RU', 'RUS', 643, 'Russia', 'Asia', 'Russian Ruble', 'RUB'); 
    672 INSERT INTO `sys_countries` VALUES('RW', 'RWA', 646, 'Rwanda', 'Africa', 'Rwanda Franc', 'RWF'); 
    673 INSERT INTO `sys_countries` VALUES('SA', 'SAU', 682, 'Saudi Arabia', 'Middle East', 'Saudi Riyal', 'SAR'); 
    674 INSERT INTO `sys_countries` VALUES('SB', 'SLB', 90, 'Solomon Islands', 'Oceania', 'Solomon Islands Dollar', 'SBD'); 
    675 INSERT INTO `sys_countries` VALUES('SC', 'SYC', 690, 'Seychelles', 'Africa', 'Seychelles Rupee', 'SCR'); 
    676 INSERT INTO `sys_countries` VALUES('SD', 'SDN', 736, 'Sudan', 'Africa', 'Sudanese Dinar', 'SDD'); 
    677 INSERT INTO `sys_countries` VALUES('SE', 'SWE', 752, 'Sweden', 'Europe', 'Swedish Krona', 'SEK'); 
    678 INSERT INTO `sys_countries` VALUES('SG', 'SGP', 702, 'Singapore', 'Southeast Asia', 'Singapore Dollar', 'SGD'); 
    679 INSERT INTO `sys_countries` VALUES('SH', 'SHN', 654, 'Saint Helena', 'Africa', 'Saint Helenian Pound', 'SHP'); 
    680 INSERT INTO `sys_countries` VALUES('SI', 'SVN', 705, 'Slovenia', 'Europe', 'Tolar', 'SIT'); 
    681 INSERT INTO `sys_countries` VALUES('SJ', 'SJM', 744, 'Svalbard', 'Arctic Region', 'Norwegian Krone', 'NOK'); 
    682 INSERT INTO `sys_countries` VALUES('SK', 'SVK', 703, 'Slovakia', 'Europe', 'Slovak Koruna', 'SKK'); 
    683 INSERT INTO `sys_countries` VALUES('SL', 'SLE', 694, 'Sierra Leone', 'Africa', 'Leone', 'SLL'); 
    684 INSERT INTO `sys_countries` VALUES('SM', 'SMR', 674, 'San Marino', 'Europe', 'Euro', 'EUR'); 
    685 INSERT INTO `sys_countries` VALUES('SN', 'SEN', 686, 'Senegal', 'Africa', 'CFA Franc BCEAO', 'XOF'); 
    686 INSERT INTO `sys_countries` VALUES('SO', 'SOM', 706, 'Somalia', 'Africa', 'Somali Shilling', 'SOS'); 
    687 INSERT INTO `sys_countries` VALUES('SR', 'SUR', 740, 'Suriname', 'South America', 'Suriname Guilder', 'SRG'); 
    688 INSERT INTO `sys_countries` VALUES('ST', 'STP', 678, 'Sao Tome and Principe', 'Africa', 'Dobra', 'STD'); 
    689 INSERT INTO `sys_countries` VALUES('SV', 'SLV', 222, 'El Salvador', 'Central America and the Caribbean', 'El Salvador Colon', 'SVC'); 
    690 INSERT INTO `sys_countries` VALUES('SY', 'SYR', 760, 'Syria', 'Middle East', 'Syrian Pound', 'SYP'); 
    691 INSERT INTO `sys_countries` VALUES('SZ', 'SWZ', 748, 'Swaziland', 'Africa', 'Lilangeni', 'SZL'); 
    692 INSERT INTO `sys_countries` VALUES('TC', 'TCA', 796, 'Turks and Caicos Islands', 'Central America and the Caribbean', 'US Dollar', 'USD'); 
    693 INSERT INTO `sys_countries` VALUES('TD', 'TCD', 148, 'Chad', 'Africa', 'CFA Franc BEAC', 'XAF'); 
    694 INSERT INTO `sys_countries` VALUES('TF', 'ATF', 260, 'French Southern and Antarctic Lands', 'Antarctic Region', 'Euro', 'EUR'); 
    695 INSERT INTO `sys_countries` VALUES('TG', 'TGO', 768, 'Togo', 'Africa', 'CFA Franc BCEAO', 'XOF'); 
    696 INSERT INTO `sys_countries` VALUES('TH', 'THA', 764, 'Thailand', 'Southeast Asia', 'Baht', 'THB'); 
    697 INSERT INTO `sys_countries` VALUES('TJ', 'TJK', 762, 'Tajikistan', 'Commonwealth of Independent States', 'Somoni', 'TJS'); 
    698 INSERT INTO `sys_countries` VALUES('TK', 'TKL', 772, 'Tokelau', 'Oceania', 'New Zealand Dollar', 'NZD'); 
    699 INSERT INTO `sys_countries` VALUES('TL', 'TLS', 626, 'East Timor', NULL, 'Timor Escudo', 'TPE'); 
    700 INSERT INTO `sys_countries` VALUES('TM', 'TKM', 795, 'Turkmenistan', 'Commonwealth of Independent States', 'Manat', 'TMM'); 
    701 INSERT INTO `sys_countries` VALUES('TN', 'TUN', 788, 'Tunisia', 'Africa', 'Tunisian Dinar', 'TND'); 
    702 INSERT INTO `sys_countries` VALUES('TO', 'TON', 776, 'Tonga', 'Oceania', 'Pa''anga', 'TOP'); 
    703 INSERT INTO `sys_countries` VALUES('TR', 'TUR', 792, 'Turkey', 'Middle East', 'Turkish Lira', 'TRL'); 
    704 INSERT INTO `sys_countries` VALUES('TT', 'TTO', 780, 'Trinidad and Tobago', 'Central America and the Caribbean', 'Trinidad and Tobago Dollar', 'TTD'); 
    705 INSERT INTO `sys_countries` VALUES('TV', 'TUV', 798, 'Tuvalu', 'Oceania', 'Australian Dollar', 'AUD'); 
    706 INSERT INTO `sys_countries` VALUES('TW', 'TWN', 158, 'Taiwan', 'Southeast Asia', 'New Taiwan Dollar', 'TWD'); 
    707 INSERT INTO `sys_countries` VALUES('TZ', 'TZA', 834, 'Tanzania', 'Africa', 'Tanzanian Shilling', 'TZS'); 
    708 INSERT INTO `sys_countries` VALUES('UA', 'UKR', 804, 'Ukraine', 'Commonwealth of Independent States', 'Hryvnia', 'UAH'); 
    709 INSERT INTO `sys_countries` VALUES('UG', 'UGA', 800, 'Uganda', 'Africa', 'Uganda Shilling', 'UGX'); 
    710 INSERT INTO `sys_countries` VALUES('UM', 'UMI', 581, 'United States Minor Outlying Islands', NULL, 'US Dollar', 'USD'); 
    711 INSERT INTO `sys_countries` VALUES('US', 'USA', 840, 'United States', 'North America', 'US Dollar', 'USD'); 
    712 INSERT INTO `sys_countries` VALUES('UY', 'URY', 858, 'Uruguay', 'South America', 'Peso Uruguayo', 'UYU'); 
    713 INSERT INTO `sys_countries` VALUES('UZ', 'UZB', 860, 'Uzbekistan', 'Commonwealth of Independent States', 'Uzbekistan Sum', 'UZS'); 
    714 INSERT INTO `sys_countries` VALUES('VA', 'VAT', 336, 'Holy See (Vatican City)', 'Europe', 'Euro', 'EUR'); 
    715 INSERT INTO `sys_countries` VALUES('VC', 'VCT', 670, 'Saint Vincent and the Grenadines', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD'); 
    716 INSERT INTO `sys_countries` VALUES('VE', 'VEN', 862, 'Venezuela', 'South America, Central America and the Caribbean', 'Bolivar', 'VEB'); 
    717 INSERT INTO `sys_countries` VALUES('VG', 'VGB', 92, 'British Virgin Islands', 'Central America and the Caribbean', 'US dollar', 'USD'); 
    718 INSERT INTO `sys_countries` VALUES('VI', 'VIR', 850, 'Virgin Islands', 'Central America and the Caribbean', 'US Dollar', 'USD'); 
    719 INSERT INTO `sys_countries` VALUES('VN', 'VNM', 704, 'Vietnam', 'Southeast Asia', 'Dong', 'VND'); 
    720 INSERT INTO `sys_countries` VALUES('VU', 'VUT', 548, 'Vanuatu', 'Oceania', 'Vatu', 'VUV'); 
    721 INSERT INTO `sys_countries` VALUES('WF', 'WLF', 876, 'Wallis and Futuna', 'Oceania', 'CFP Franc', 'XPF'); 
    722 INSERT INTO `sys_countries` VALUES('WS', 'WSM', 882, 'Samoa', 'Oceania', 'Tala', 'WST'); 
    723 INSERT INTO `sys_countries` VALUES('YE', 'YEM', 887, 'Yemen', 'Middle East', 'Yemeni Rial', 'YER'); 
    724 INSERT INTO `sys_countries` VALUES('YT', 'MYT', 175, 'Mayotte', 'Africa', 'Euro', 'EUR'); 
    725 INSERT INTO `sys_countries` VALUES('ZA', 'ZAF', 710, 'South Africa', 'Africa', 'Rand', 'ZAR'); 
    726 INSERT INTO `sys_countries` VALUES('ZM', 'ZWB', 894, 'Zambia', 'Africa', 'Kwacha', 'ZMK'); 
    727 INSERT INTO `sys_countries` VALUES('ZW', 'ZWE', 716, 'Zimbabwe', 'Africa', 'Zimbabwe Dollar', 'ZWD'); 
    728  
    729117-- -------------------------------------------------------- 
    730118 
    … …  
    750138INSERT INTO `sys_email_templates` VALUES(1, 't_Activation', 'Profile status was changed to Active', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Your profile was reviewed and activated !</p>\r\n\r\n<p>Simply follow the link below to enjoy our services:<br /><a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<p>Your identification number (ID): <span style="color:#FF6633"><recipientID></span></p>\r\n\r\n<p>Your e-mail used for registration: <span style="color:#FF6633"><Email></span></p>\r\n\r\n<p><b>Thank you for using our services!</b></p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Profile activation message template.', 0); 
    751139INSERT INTO `sys_email_templates` VALUES(3, 't_AdminEmail', 'Message from <SiteName> Admin: <MessageSubject>', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Administration of the <a href="<Domain>"><SiteName></a> is glad to inform you that </p>\r\n\r\n<p>=========================</p>\r\n<p style="color:#3B5C8E"><MessageText></p>\r\n<p>=========================</p>\r\n\r\n\r\n <p style="font-size:10px;">NOTE: You received this message because our records show that you are a registered member of <a href="<Domain>"><SiteName></a> or subscribed to the delivery.\r\n If you wish to unregister, log in to your member account and hit "Unregister".</p>\r\n\r\n<p>-----</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\nAuto-generated e-mail, please, do not reply!!!</p></body></html>', 'Email template for message sending from the Admin Panel.', 0); 
    752 INSERT INTO `sys_email_templates` VALUES(5, 't_Compose', 'Notification about new messages in the inbox', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>You have received a message from <a href="<ProfileUrl>"><ProfileReference></a>!</p>\r\n\r\n<p>To check this message login to your account here: <a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<p>---</p>\r\nBest regards,  <SiteName> \r\n<p style="font: bold 10px Verdana; color:red">!!!Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Email template for notification about new messages in the inbox.', 0); 
    753140INSERT INTO `sys_email_templates` VALUES(7, 't_Confirmation', 'Confirm your profile', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Thank you for registering at <SiteName>!</p>\r\n\r\n<p style="color:#3B5C8E">CONFIRMATION CODE: <ConfCode></p>\r\n\r\n<p>Or you can also simply follow the link below:\r\n<a href="<ConfirmationLink>"><ConfirmationLink></a></p>\r\n\r\n<p>This is necessary to complete your registration.<br />Without doing that you won''t be submitted to our database.</p>\r\n\r\n<p>Your identification number (ID): <span style="color:#FF6633; font-weight:bold;"><recipientID></span></p>\r\n\r\n<p>Your e-mail used for registration: \r\n<span style="color:#FF6633"><Email></span></p>\r\n\r\n<p><b>Thank you for using our services!</b></p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Profile e-mail confirmation message template.', 0); 
    754 INSERT INTO `sys_email_templates` VALUES(9, 't_CupidMail', 'Match Notification', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>We are glad to inform you that a profile was added or modified at <Domain> that matches yours.</p>\r\n\r\n<p>Match profile:<span style="color:#FF6633"><a href="<MatchProfileLink>"><MatchProfileLink></a></span></p>\r\n\r\n<p>Your Member ID:<span style="color:#FF6633"><StrID></span></p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Cupid mail template', 0); 
    755141INSERT INTO `sys_email_templates` VALUES(11, 't_Forgot', 'Forgot password email message', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Your member ID: <span style="color:#FF6633"><recipientID></span></p>\r\n\r\n<p>Your password: <span style="color:#FF6633"><Password></span></p>\r\n\r\n<p>You must login here: <span style="color:#FF6633"><a href="<Domain>member.php"><Domain>member.php</a></span></p>\r\n\r\n<p><b>Thank you for using our services!</b></p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Forgot password email message', 0); 
    756 INSERT INTO `sys_email_templates` VALUES(13, 't_FreeEmail', 'Free contact information', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>You have requested <strong><profileNickName></strong>''s contact information.</p>\r\n\r\n<p><profileContactInfo></p>\r\n\r\n<p>View member''s profile: <a href="<Domain>profile.php?ID=<profileID>"><Domain>profile.php?ID=<profileID></a></p>\r\n\r\n<p><b>Thank you for using our services!</b></p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Free contact information letter template sent to members requesting contact information.', 0); 
    757142INSERT INTO `sys_email_templates` VALUES(15, 't_MemExpiration', '<your subject here>', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>We are notifying you that your <SiteName> <MembershipName> will expire in <ExpireDays> days (-1 = already expired).\r\n\r\n To renew your membership login to your <SiteName> account at <a href="<Domain>member.php"><Domain>member.php</a> and go to <a href="<Domain>modules/?r=membership/index/">My Membership</a></p>\r\n\r\n<p>Your Member ID: <span style="color:#FF6633; font-weight:bold;"><recipientID></span></p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Membership expiration letter sent to members whose membership level expires.', 0); 
    758143INSERT INTO `sys_email_templates` VALUES(16, 't_MemChanged', 'Your membership level was changed', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>Your membership level was changed to: <b><MembershipLevel></b></p>\r\n\r\n<p>Please refer to membership page for more details: <a href="<Domain>modules/?r=membership/index/">My Membership</a></p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'The letter is sent to members whose membership level was changed.', 0); 
    759 INSERT INTO `sys_email_templates` VALUES(17, 't_Message', 'You receive messages from other members', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>We are glad to inform you that the member\r\n<a href="<ProfileUrl>"><ProfileReference></a> has sent you a message! </p>\r\n\r\n<p>-------- Message ------------------------------------------------<br />\r\n<span style="color:#3B5C8E"><MessageText></span><br />\r\n---------------------------------------------------------------------\r\n</p>\r\n\r\n<p><b>Thank you for using our services!</b></p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Message template sent to members when they receive messages from other members.', 0); 
    760144INSERT INTO `sys_email_templates` VALUES(19, 't_UserJoined', 'New user joined', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p>New user <RealName> with email <Email> has joined, his/her ID is <recipientID></p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Admin notification - new user joined', 0); 
    761145INSERT INTO `sys_email_templates` VALUES(21, 't_UserConfirmed', 'New user confirmed', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p>New user <RealName> with email <Email> has been confirmed, his/her ID is <recipientID></p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Admin notification - user confirmed email', 0); 
    762 INSERT INTO `sys_email_templates` VALUES(25, 't_Rejection', 'Profile status was changed to Rejected', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Your profile was reviewed and rejected due to the following reasons:</p>\r\n\r\n<p>1) Your profile information was supplied in the wrong  language. <br />\r\n2) Your profile contains illegal information. Make sure that you: do not use black language, do not specify your contact information in the wrong text fields;<br />\r\n3) You have uploaded unacceptable photos to your profile;<br />\r\n4) We doubt that you are a real person. </p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Profile rejection message template.', 0); 
    763 INSERT INTO `sys_email_templates` VALUES(27, 't_SpamReport', 'Spam report from <SiteName>', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><a href="<Domain>profile.php?ID=<reporterID>">User <b><reporterNick> (<reporterID>)</b></a> reported that user <a href="<Domain>profile.php?ID=<spamerID>"><b><spamerNick> (<spamerID>)</b></a> spammed.</p>\r\n\r\n<p>Reporter: <span style="color:#FF6633;"><a href="<Domain>profile.php?ID=<reporterID>"><Domain>profile.php?ID=<reporterID></a></span>\r\n<br />Spammer: <span style="color:#FF6633;"><a href="<Domain>profile.php?ID=<spamerID>"><Domain>profile.php?ID=<spamerID></a></span></p></body></html>', 'Template for a "Report Spam" feature.', 0); 
    764 INSERT INTO `sys_email_templates` VALUES(29, 't_TellFriend', 'Invite a Friend', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Hello</b>,</p>\r\n\r\n<p>I surfed the web and found a cool site: <a href="<Link>"><Link></a><br />\r\nI thought it might be interesting to you.</p>\r\n\r\n<p><span style="color:#FF6633"><FromName></span></p></body></html>', 'Template for "Invite a Friend" feature.', 0); 
    765 INSERT INTO `sys_email_templates` VALUES(31, 't_TellFriendProfile', 'Email profile to a friend', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Hello</b>,</p>\r\n\r\n<p>I surfed the web and found a cool member''s profile: <a href="<Link>"><Link></a><br />\r\nI thought it might be interesting to you.</p>\r\n\r\n<p><span style="color:#FF6633"><FromName></span></p></body></html>', 'Template for "Email profile to a friend" feature.', 0); 
    766 INSERT INTO `sys_email_templates` VALUES(33, 't_VKiss', 'Greeting notification', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>We are glad to inform you that member <ProfileReference> sent you a greeting!</p>\r\n\r\n<p>A greeting means that the member is interested in contacting you. Please, be polite and answer with your greeting in return. You can send it by merely following the link:<br />\r\n<VKissLink>\r\n</p>\r\n\r\n<p><b>Thank you for using our services!</b></p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Greeting from the other member notification letter template.', 0); 
    767 INSERT INTO `sys_email_templates` VALUES(35, 't_VKiss_visitor', 'Greeting notification', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>We are glad to inform you that <b>Visitor</b> sent you a greeting!</p>\r\n\r\n<p>A greeting means that the person visited your profile and liked it. Have a nice day and enjoy!</p>\r\n\r\n<p>Thank you for using our services!</p>\r\n\r\n<p>--</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\n<br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Greeting from visitor notification letter template.', 0); 
    768 INSERT INTO `sys_email_templates` VALUES(45, 't_MessageCopy', 'Message copy : <your subject here>', '<your message here>', 'Send the message copy', 0); 
    769 INSERT INTO `sys_email_templates` VALUES(47, 't_Subscription', 'You were subscribed', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p><b>Dear <RealName></b>,</p><br /><p>You were successfully subscribed to <a href="<ViewLink>"><Subscription></a>!</p><br /> <p>You may cancel the subscription by clicking the following link: <a href="<SysUnsubscribeLink>"><SysUnsubscribeLink></a></p><br /> <p><b>Thank you for using our services!</b></p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Subscription message template.', 0); 
    770 INSERT INTO `sys_email_templates` VALUES(49, 't_sbsProfileComments', 'New profile comments', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p><b>Dear <RealName></b>,</p><br /><p>The profile you subscribed to has new comments!</p><br /> <p>Click <a href="<ViewLink>">here</a> to view them.</p><br /> <p><b>Thank you for using our services!</b></p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'New profile comments subscription.', 0); 
    771 INSERT INTO `sys_email_templates` VALUES(51, 't_sbsProfileRates', 'Profile was rated', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p><b>Dear <RealName></b>,</p><br /><p>The profile you subscribed to was rated!</p><br /> <p>Click <a href="<ViewLink>">here</a> to view it.</p><br /> <p><b>Thank you for using our services!</b></p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'New profile rates subscription.', 0); 
    772 INSERT INTO `sys_email_templates` VALUES(53, 't_sbsProfileEdit', 'Profile info was updated', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p><b>Dear <RealName></b>,</p><br /><p>The profile you subscribed to has updated profile info!</p><br /> <p>Click <a href="<ViewLink>">here</a> to view it.</p><br /> <p><b>Thank you for using our services!</b></p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Profile info subscription.', 0); 
    773146INSERT INTO `sys_email_templates` VALUES(54, 't_FriendRequest', 'Friend request', '<html>\r\n<body style="font: 12px Verdana; color:#000000">\r\n    <p><b>Dear <Recipient></b>,</p>\r\n    <br />\r\n    <p><a href="<SenderLink>"><Sender></a> is inviting you to be friends. To accept/reject his/her invitation please \r\n    follow this <a href="<RequestLink>">link</a></p>\r\n    <br /> \r\n    <p><b>Thank you for using our services!</b></p> \r\n    <p>--</p>\r\n    <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! \r\n    <br />Auto-generated e-mail, please, do not reply!!!</p>\r\n</body></html>', 'Friend request message', 0); 
    774147INSERT INTO `sys_email_templates` VALUES(55, 't_FriendRequestAccepted', 'Friend request was accepted', '<html>\r\n<body style="font: 12px Verdana; color:#000000">\r\n    <p><b>Dear <Recipient></b>,</p>\r\n    <br />\r\n    <p><a href="<SenderLink>"><Sender></a> accepted your friend request.</p>\r\n    <br /> \r\n    <p><b>Thank you for using our services!</b></p> \r\n    <p>--</p>\r\n    <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! \r\n    <br />Auto-generated e-mail, please, do not reply!!!</p>\r\n</html>', 'Friend accepted request message', 0); 
    775 INSERT INTO `sys_email_templates` VALUES(56, 't_SpamReportAuto', '<SiteName> Automatic Spam Report', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n\r\n\r\n<p>Spam report details:</p>\r\n<p>\r\n\r\n<b>Profile:</b> <a href="<SpammerUrl>"><SpammerNickName></a><br />\r\n\r\n<b>Page:</b> <Page><br />\r\n\r\n<b>GET variables:</b>\r\n<pre>\r\n<Get>\r\n</pre>\r\n\r\n<b>Spam Content:</b>\r\n<pre>\r\n<SpamContent>\r\n</pre>\r\n\r\n</p>\r\n\r\n\r\n<p>-----</p>\r\n<p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!!\r\nAuto-generated e-mail, please, do not reply!!!</p></body></html>', 'Automatic spam report template', 0); 
    776  
    777  
    778 -- -------------------------------------------------------- 
    779  
    780 -- 
    781 -- Table structure for table `sys_menu_member` 
    782 -- 
    783  
    784 CREATE TABLE `sys_menu_member` ( 
    785   `ID` int(10) unsigned NOT NULL auto_increment, 
    786   `Caption` varchar(100) NOT NULL, 
    787   `Name` varchar(200) NOT NULL, 
    788   `Icon` varchar(100) NOT NULL, 
    789   `Link` varchar(250) NOT NULL, 
    790   `Script` varchar(250) NOT NULL, 
    791   `Eval` text NOT NULL, 
    792   `PopupMenu` text NOT NULL, 
    793   `Order` int(5) NOT NULL, 
    794   `Active` enum('1','0') NOT NULL, 
    795   `Movable` tinyint(4) NOT NULL default '3', 
    796   `Clonable` tinyint(1) NOT NULL default '1', 
    797   `Editable` tinyint(1) NOT NULL default '1', 
    798   `Deletable` tinyint(1) NOT NULL default '1', 
    799   `Target` varchar(200) NOT NULL, 
    800   `Position` enum('top','bottom','top_extra') NOT NULL default 'top', 
    801   `Type` enum('link','system','linked_item') NOT NULL, 
    802   `Parent` int(11) NOT NULL, 
    803   `Bubble` text NOT NULL, 
    804   `Description` varchar(50) NOT NULL, 
    805   PRIMARY KEY  (`ID`), 
    806   KEY `Parent` (`Parent`) 
    807 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    808  
    809 -- 
    810 -- Dumping data for table `sys_menu_member` 
    811 -- 
    812  
    813 INSERT INTO `sys_menu_member` (`ID`, `Caption`, `Name`, `Icon`, `Link`, `Script`, `Eval`, `PopupMenu`, `Order`, `Active`, `Movable`, `Clonable`, `Editable`, `Deletable`, `Target`, `Position`, `Type`, `Parent`, `Bubble`, `Description`) VALUES  
    814 (1, '_Profile', 'Profile', 'memeber_menu_profile.png', '{evalResult}', '', '$iProfileID = getLoggedId();\r\n\r\nreturn getProfileLink($iProfileID);', '$iCurrentMemberId = ''{ID}'';\r\n\r\n$aLinks = array(\r\n    ''info'' => array(\r\n        ''url''     => ''profile_info.php?ID='' . (int) $iCurrentMemberId,\r\n        ''icon''    => ''memeber_menu_sub_info.png'',\r\n        ''caption'' => _t( ''_Info'' ),\r\n        ''onclick'' => null,\r\n    ),\r\n);\r\n\r\nforeach( $aLinks as $sKey => $aItems )\r\n{\r\n    $sIcon = $GLOBALS[''oFunctions''] -> getTemplateIcon($aLinks[$sKey][''icon'']);\r\n    $aTemplateKeys = array (\r\n\r\n        ''bx_if:item_img'' => array (\r\n            ''condition'' =>  ( $sIcon ),\r\n            ''content''   => array (\r\n                ''item_img_src'' => $sIcon,\r\n                ''item_img_alt'' => $aLinks[$sKey][''caption''],\r\n                ''item_img_width''    => 16,\r\n                ''item_img_height''   => 16,\r\n            ),\r\n        ),\r\n\r\n        ''item_link''    => ( $aLinks[$sKey][''url''] )     ? $aLinks[$sKey][''url''] : ''javascript:void(0)'',\r\n        ''item_onclick'' => ( $aLinks[$sKey][''onclick''] ) ? ''onclick="'' . $aLinks[$sKey][''onclick''] . '';return false"'' : null,\r\n        ''item_title''   => $aLinks[$sKey][''caption''],\r\n        ''extra_info''   => null,\r\n    );\r\n\r\n    $sOutputCode .= $GLOBALS[''oSysTemplate''] -> parseHtmlByName( ''member_menu_sub_item.html'', $aTemplateKeys );\r\n}\r\n\r\nreturn $sOutputCode ;', 3, '1', 3, 1, 0, 0, '', 'top_extra', 'link', 0, '', '_Profile'), 
    815 (2, '_Mail', 'Mail', 'memeber_menu_mail.png', 'mail.php?mode=inbox', '', '', 'bx_import( ''BxTemplMailBox'' );\r\n// return list of messages ;\r\nreturn BxTemplMailBox::get_member_menu_messages_list({ID});', 0, '1', 3, 1, 0, 0, '', 'top_extra', 'link', 0, 'bx_import( ''BxTemplMailBox'' );\r\n// return list of new messages ;\r\n$aRetEval= BxTemplMailBox::get_member_menu_bubble_new_messages({ID}, {iOldCount});', '_Mail'), 
    816 (3, '_Friends', 'Friends', 'memeber_menu_friends.png', 'viewFriends.php?iUser={ID}', '', '', 'bx_import( ''BxDolFriendsPageView'' );\r\nreturn BxDolFriendsPageView::get_member_menu_friends_list({ID});', 1, '1', 3, 1, 0, 0, '', 'top_extra', 'link', 0, 'bx_import( ''BxDolFriendsPageView'' );\r\n$aRetEval = BxDolFriendsPageView::get_member_menu_bubble_online_friends( {ID}, {iOldCount});', '_Friends'), 
    817 (4, '_Settings', 'Settings', 'memeber_menu_settings.png', 'pedit.php?ID={ID}', '', '', '$iCurrentMemberId = ''{ID}'';\r\n\r\n$aLinks = array (\r\n\r\n    ''account''  => array(\r\n        ''caption''  => _t( ''_Account settings'' ),\r\n        ''url''      => ''pedit.php?ID='' . $iCurrentMemberId,\r\n        ''onclick''  => null,\r\n    ),    \r\n\r\n    ''privacy'' => array (\r\n       ''caption'' =>  _t( ''_Privacy settings'' ),\r\n       ''url''     => ''member_privacy.php'', \r\n       ''onclick'' => null,\r\n    ),\r\n\r\n    ''menu''  => array(\r\n        ''caption''  => _t( ''_Member menu settings'' ),\r\n        ''url''      => null,\r\n        ''onclick''  => "window.open( ''{$GLOBALS[''site''][''url'']}list_pop.php?action=extra_menu'', ''menu_settings'',''width=550,height=200,toolbar=0,directories=0,menubar=0,status=0,location=0,scrollbars=0,resizable=1'');return false",\r\n    ),\r\n    \r\n); \r\n\r\n$sIcon =  null;\r\nforeach( $aLinks as $sKey => $aItems )\r\n{\r\n    $aTemplateKeys = array (\r\n        ''bx_if:item_img'' => array (\r\n            ''condition'' =>  ( $sIcon ),\r\n            ''content''   => array (\r\n                ''item_img_src'' => $sIcon,\r\n                ''item_img_alt'' => $aLinks[$sKey][''caption''],\r\n                ''item_img_width''    => 16,\r\n                ''item_img_height''   => 16,\r\n            ),\r\n        ),\r\n\r\n        ''item_link''    => ( $aLinks[$sKey][''url''] )     ? $aLinks[$sKey][''url''] : ''javascript:void(0)'',\r\n        ''item_onclick'' => ( $aLinks[$sKey][''onclick''] ) ? ''onclick="'' . $aLinks[$sKey][''onclick''] . '';return false"'' : null,\r\n        ''item_title''   => $aLinks[$sKey][''caption''],\r\n        ''extra_info''   => null,\r\n    );\r\n\r\n    $sOutputCode .= $GLOBALS[''oSysTemplate''] -> parseHtmlByName( ''member_menu_sub_item.html'', $aTemplateKeys );\r\n}\r\n\r\nreturn $sOutputCode ;', 5, '1', 3, 1, 0, 0, '', 'top_extra', 'link', 0, '', '_Settings'), 
    818 (5, '_Log Out2', 'Log Out', 'memeber_menu_logout.png', 'logout.php?action=member_logout', '', '', '', 6, '1', 3, 1, 0, 0, '', 'top_extra', 'link', 0, '', '_Log Out2'), 
    819 (6, '{evalResult}', 'MemberBlock', '', '{ProfileLink}', '', 'return ''<b>'' . getNickName({ID}) . ''</b>'';', 'require_once( BX_DIRECTORY_PATH_CLASSES . ''BxDolUserStatusView.php'' );\r\n\r\n$oStatusView = new BxDolUserStatusView();\r\n$sOutputCode = null;\r\n\r\nif ($oStatusView -> aStatuses){\r\n    foreach($oStatusView -> aStatuses as $sKey => $aItems)\r\n    {\r\n        $sTitle = _t($aItems[''title'']);\r\n\r\n        $aTemplateKeys = array (\r\n\r\n            ''bx_if:item_img'' => array (\r\n                ''condition'' =>  ( true ),\r\n                ''content''   => array (\r\n                    ''item_img_src'' => $GLOBALS[''oFunctions''] -> getTemplateIcon($aItems[''icon'']),\r\n                    ''item_img_alt'' => $sTitle,\r\n                    ''item_img_width''    => 16,\r\n                    ''item_img_height''   => 16,\r\n                ),\r\n            ),\r\n\r\n            ''item_link''    => ''javascript:void(0)'',\r\n            ''item_onclick'' => "onclick=\\"if (typeof oBxUserStatus != ''undefined'' ) { oBxUserStatus.setUserStatus(''$sKey'', $(this).parents(''ul:first'')); }return false\\"",\r\n            ''item_title''   => $sTitle,\r\n            ''extra_info''   => null,\r\n        );\r\n\r\n        $sOutputCode .= $GLOBALS[''oSysTemplate''] -> parseHtmlByName( ''member_menu_sub_item.html'', $aTemplateKeys );\r\n    }\r\n}\r\n\r\nreturn $sOutputCode;', 0, '1', 3, 1, 0, 0, '', 'top', 'link', 0, '', '_Presence'), 
    820 (7, '_Status Message', 'Status Message', 'status_text.png', 'javascript:void(0);', '', '', 'bx_import( ''BxDolUserStatusView'' );\r\n$oStatusView = new BxDolUserStatusView();\r\nreturn $oStatusView -> getStatusField({ID});', 1, '1', 3, 1, 1, 1, '', 'top', 'link', 0, '', '_Status Message'), 
    821 (8, '_Dashboard', 'Dashboard', 'memeber_menu_dashboard.png', '', 'return false', '', '$iCurrentMemberId = ''{ID}'';\r\n\r\n$aLinks = array(\r\n    ''activity'' => array(\r\n        ''url''     => ''communicator.php'',\r\n        ''icon''    => ''memeber_menu_sub_activity.png'',\r\n        ''caption'' => _t( ''_Activity'' ),\r\n        ''onclick'' => null,\r\n    ),\r\n);    \r\n\r\n$sOutputCode = null;\r\nforeach( $aLinks as $sKey => $aItems )\r\n{\r\n    $sIcon = $GLOBALS[''oFunctions''] -> getTemplateIcon($aLinks[$sKey][''icon'']);\r\n    $aTemplateKeys = array (\r\n\r\n        ''bx_if:item_img'' => array (\r\n            ''condition'' =>  ( $sIcon ),\r\n            ''content''   => array (\r\n                ''item_img_src''      => $sIcon,\r\n                ''item_img_alt''      => $aLinks[$sKey][''caption''],\r\n                ''item_img_width''    => 16,\r\n                ''item_img_height''   => 16,\r\n            ),\r\n        ),\r\n\r\n        ''item_link''    => ( $aLinks[$sKey][''url''] )     ? $aLinks[$sKey][''url''] : ''javascript:void(0)'',\r\n        ''item_onclick'' => ( $aLinks[$sKey][''onclick''] ) ? ''onclick="'' . $aLinks[$sKey][''onclick''] . '';return false"'' : null,\r\n        ''item_title''   => $aLinks[$sKey][''caption''],\r\n        ''extra_info''   => null,\r\n    );\r\n\r\n    $sOutputCode .= $GLOBALS[''oSysTemplate''] -> parseHtmlByName( ''member_menu_sub_item.html'', $aTemplateKeys );\r\n}\r\n\r\nreturn $sOutputCode ;\r\n', 3, '1', 1, 0, 1, 0, '', 'top_extra', 'link', 0, '', '_Dashboard'), 
    822 (9, '_Language', 'Language', 'memeber_menu_translate.png', '', '{evalResult}', 'bx_import(''BxDolLanguages''); $aLangs =  count( BxDolLanguages::getInstance()->getLanguages() );\r\nif ( $aLangs > 1) {\r\n   return ''return false'';\r\n}', 'return getLangSwitcher();', 4, '1', 3, 1, 1, 1, '', 'top_extra', 'link', 0, '', '_Language'), 
    823 (10, '_Admin Panel', 'Admin Panel', 'member_menu_admin.png', '{evalResult}', '', 'return isAdmin() ? $GLOBALS[''site''][''url_admin''] : '''';', '', 5, '1', 3, 1, 1, 1, '', 'top_extra', 'link', 0, '', '_Go admin panel'); 
    824  
     148 
     149-- -------------------------------------------------------- 
    825150 
    826151-- 
    … …  
    836161  KEY `Profile` (`Profile`) 
    837162) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    838  
    839 -- 
    840 -- Dumping data for table `sys_friend_list` 
    841 -- 
    842163 
    843164-- -------------------------------------------------------- 
    … …  
    905226(@iCategoryId, 'cmdDay', '', '10', 'digit', '', '', '', 1), 
    906227(@iCategoryId, 'tags_last_parse_time', 'Temporary value when tags cron-job was runed last time', '0', 'digit', '', '', '', 3), 
    907 (@iCategoryId, 'enable_flash_promo', '', 'on', 'checkbox', '', '', '', 4), 
    908 (@iCategoryId, 'custom_promo_code', '', '', 'text', '', '', '', 5), 
    909228(@iCategoryId, 'license_expiration', 'Dolphin License Expiration', '', 'digit', '', '', '', 6), 
    910229(@iCategoryId, 'license_checksum', 'Dolphin License Checksum', '', 'digit', '', '', '', 7), 
    … …  
    912231(@iCategoryId, 'sys_json_fields', 'JSON fields', '', 'text', '', '', '', 9), 
    913232(@iCategoryId, 'sys_exceptions_fields', 'Exceptions fields', '', 'text', '', '', '', 10), 
    914 (@iCategoryId, 'enable_dolphin_footer', 'Enable BoonEx footers', 'on', 'checkbox', '', '', '', 11), 
    915 (@iCategoryId, 'cupid_last_cron', 'Temporary value when cupid mails checked was runed last time', '0', 'text', '', '', '', 12), 
    916233(@iCategoryId, 'main_div_width', 'Width of the main container of the site', '998px', 'digit', '', '', '', 13), 
    917 (@iCategoryId, 'promoWidth', 'Default Width of the Promo Images for resizing', '998', 'digit', '', '', '', 14), 
    918234(@iCategoryId, 'sys_template_cache_image_enable', 'Enable cache for images (do not work for IE7)', '', 'checkbox', '', '', '', 15), 
    919235(@iCategoryId, 'sys_template_cache_image_max_size', 'Max image size to be cached(in kb)', '5', 'digit', '', '', '', 16), 
    … …  
    923239(@iCategoryId, 'sys_tmp_version', 'Temporary Dolphin version ', '7.0.6', 'digit', '', '', '', 20); 
    924240 
    925 INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'profiles', '_adm_stg_cpt_category_profiles', 0, 2); 
    926 SET @iCategoryId = LAST_INSERT_ID(); 
    927  
    928 INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES 
    929 (@iCategoryId, 'anon_mode', 'Anonymous mode (no contact information)', '', 'checkbox', '', '', '', 1), 
    930 (@iCategoryId, 'newusernotify', 'New User Notify', 'on', 'checkbox', '', '', '', 2), 
    931 (@iCategoryId, 'search_start_age', 'Lowest age possible for site members', '18', 'digit', '', '', '', 3), 
    932 (@iCategoryId, 'search_end_age', 'Highest age possible for site members', '75', 'digit', '', '', '', 4), 
    933 (@iCategoryId, 'track_profile_view', 'Track all profile views. Later a member can manage these "views".', 'on', 'checkbox', '', '', '', 5), 
    934 (@iCategoryId, 'votes', 'Enable profile votes', 'on', 'checkbox', '', '', '', 6), 
    935 (@iCategoryId, 'zodiac', 'Show zodiac signs', '', 'checkbox', '', '', '', 7), 
    936 (@iCategoryId, 'enable_cmts_profile_delete', 'Enable possibility to delete profile comments by profile owner', '', 'checkbox', '', '', '', 8), 
    937 (@iCategoryId, 'friends_per_page', 'Number of friends to display per page in profile', '14', 'digit', '', '', '', 9), 
    938 (@iCategoryId, 'sys_user_info_timeout', 'Timeout before displaying profile info(in seconds)', '3', 'digit', '', '', '', 10), 
    939 (@iCategoryId, 'enable_global_couple', 'Global Enabling of Couples', 'on', 'checkbox', '', '', '', 11); 
    940  
    941  
    942 INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'galleries', '_adm_stg_cpt_category_galleries', 0, 3); 
    943 SET @iCategoryId = LAST_INSERT_ID(); 
    944  
    945241 
    946242INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'other', '_adm_stg_cpt_category_other', 0, 4); 
    … …  
    948244 
    949245INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES 
    950 (@iCategoryId, 'news_enable', 'Show boonex news in admin panel', 'on', 'checkbox', '', '', '', 1), 
    951 (@iCategoryId, 'feeds_enable', 'Show boonex feeds in admin panel', 'on', 'checkbox', '', '', '', 2), 
    952 (@iCategoryId, 'max_inbox_message_size', 'Maximum message size in symbols', '1500', 'digit', '', '', '', 3), 
    953246(@iCategoryId, 'member_online_time', 'Time period in minutes within which a member is considered to be online', '1', 'digit', '', '', '', 4), 
    954 (@iCategoryId, 'reg_by_inv_only', 'Registration by invitation only', '', 'checkbox', '', '', '', 5), 
    955247(@iCategoryId, 'enable_tiny_in_comments', 'Enable TinyMCE in comments', '', 'checkbox', '', '', '', 6), 
    956248(@iCategoryId, 'enable_cache_system', 'Enable caching system to store profiles information', 'on', 'checkbox', '', '', '', 7), 
    957 (@iCategoryId, 'nav_menu_elements_on_line_usr', 'The number of tabs shown in the navigation menu before the More link for logged in members.', '12', 'digit', '', '', '', 8), 
    958 (@iCategoryId, 'nav_menu_elements_on_line_gst', 'The number of tabs shown in the navigation menu before the More link for visitors.', '12', 'digit', '', '', '', 9), 
    959 (@iCategoryId, 'enable_guest_comments', 'enable possibility to post comments by guests', '', 'checkbox', '', '', '', 10), 
    960 (@iCategoryId, 'promo_relocation_link_visitor', 'Default relocation link to Promo for non-members', 'join.php', 'text', '', '', '', 11), 
    961 (@iCategoryId, 'promo_relocation_link_member', 'Default relocation link to Promo for members', 'member.php', 'text', '', '', '', 12), 
    962 (@iCategoryId, 'leaders_male_types', 'Period types of leaders for male', 'year,month,week,day', 'list', 'year,month,week,day', '', '', 13), 
    963 (@iCategoryId, 'leaders_female_types', 'Period types of leaders for female', 'year,month,week,day', 'list', 'year,month,week,day', '', '', 14), 
    964249(@iCategoryId, 'sys_ftp_login', 'FTP server login', '', 'digit', '', '', '', 15), 
    965250(@iCategoryId, 'sys_ftp_password', 'FTP server password', '', 'digit', '', '', '', 16), 
    … …  
    993278 
    994279 
    995 INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'postmoderation', '_adm_stg_cpt_category_postmoderation', 0, 7); 
    996 SET @iCategoryId = LAST_INSERT_ID(); 
    997  
    998 INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES 
    999 (@iCategoryId, 'autoApproval_ifJoin', 'Automatic profile activation after joining', 'on', 'checkbox', '', '', '', 1), 
    1000 (@iCategoryId, 'autoApproval_ifProfile', 'Do not change profile status after editing profile information', 'on', 'checkbox', '', '', '', 2), 
    1001 (@iCategoryId, 'autoApproval_ifNoConfEmail', 'Automatic profile confirmation without Confirmation Email', 'on', 'checkbox', '', '', '', 3); 
    1002  
    1003  
    1004280INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'site_settings','_adm_stg_cpt_category_site_settings', 0, 8); 
    1005281SET @iCategoryId = LAST_INSERT_ID(); 
    … …  
    1011287 
    1012288 
    1013 INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'index_settings', '_adm_stg_cpt_category_index_settings', 0, 9); 
    1014 SET @iCategoryId = LAST_INSERT_ID(); 
    1015  
    1016 INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES 
    1017 (@iCategoryId, 'default_country', 'Default Country on Index Page', 'US', 'text', '', '', '', 1), 
    1018 (@iCategoryId, 'featured_num', 'Number of featured members displayed on front page', '16', 'digit', '', 'return $arg0 >= 0;', 'Must be equal to or greater than zero.', 2), 
    1019 (@iCategoryId, 'top_members_max_num', 'How many results show on index page in top members area', '16', 'digit', '', '', '', 3); 
    1020  
    1021  
    1022 INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'privacy_settings', '_adm_stg_cpt_category_privacy_settings', 0, 9); 
    1023 SET @iCategoryId = LAST_INSERT_ID(); 
    1024  
    1025 INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES 
    1026 (@iCategoryId, 'sys_ps_enabled_group_1', 'Enable \'Default\' group', 'on', 'checkbox', '', '', '', 1), 
    1027 (@iCategoryId, 'sys_ps_group_1_title', 'Title for \'Default\' group', 'Default', 'digit', '', '', '', 2), 
    1028 (@iCategoryId, 'sys_ps_enabled_group_2', 'Enable \'Me Only\' group', 'on', 'checkbox', '', '', '', 3), 
    1029 (@iCategoryId, 'sys_ps_group_2_title', 'Title for \'Me Only\' group', 'Me Only', 'digit', '', '', '', 4), 
    1030 (@iCategoryId, 'sys_ps_enabled_group_3', 'Enable \'Public\' group', 'on', 'checkbox', '', '', '', 5), 
    1031 (@iCategoryId, 'sys_ps_group_3_title', 'Title for \'Public\' group', 'Public', 'digit', '', '', '', 6), 
    1032 (@iCategoryId, 'sys_ps_enabled_group_4', 'Enable \'Members\' group', 'on', 'checkbox', '', '', '', 7), 
    1033 (@iCategoryId, 'sys_ps_group_4_title', 'Title for \'Members\' group', 'Members', 'digit', '', '', '', 8), 
    1034 (@iCategoryId, 'sys_ps_enabled_group_5', 'Enable \'Friends\' group', 'on', 'checkbox', '', '', '', 9), 
    1035 (@iCategoryId, 'sys_ps_group_5_title', 'Title for \'Friends\' group', 'Friends', 'digit', '', '', '', 10), 
    1036 (@iCategoryId, 'sys_ps_enabled_group_6', 'Enable \'Faves\' group', '', 'checkbox', '', '', '', 11), 
    1037 (@iCategoryId, 'sys_ps_group_6_title', 'title for \'Faves\' group', 'Faves', 'digit', '', '', '', 12), 
    1038 (@iCategoryId, 'sys_ps_enabled_group_7', 'Enable \'Contacts\' group', '', 'checkbox', '', '', '', 13), 
    1039 (@iCategoryId, 'sys_ps_group_7_title', 'Title for \'Contacts\' group', 'Contacts', 'digit', '', '', '', 14); 
    1040  
    1041  
    1042 INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'news', '_adm_stg_cpt_category_news', 0, 10); 
    1043 SET @iCategoryId = LAST_INSERT_ID(); 
    1044  
    1045289INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'pruning', '_adm_stg_cpt_category_pruning', 0, 11); 
    1046290SET @iCategoryId = LAST_INSERT_ID(); 
    1047291 
    1048292INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES 
    1049 (@iCategoryId, 'db_clean_msg', 'Clean old messages ( days )', '365', 'digit', '', '', '', 1), 
    1050 (@iCategoryId, 'db_clean_profiles', 'Clean old profiles by last log in ( days )', '0', 'digit', '', '', '', 2), 
    1051 (@iCategoryId, 'db_clean_views', 'Clean old profile views ( days )', '180', 'digit', '', '', '', 3), 
    1052 (@iCategoryId, 'db_clean_members_visits', 'Clean old IP members visits ( days )', '90', 'digit', '', '', '', 4), 
    1053 (@iCategoryId, 'db_clean_banners_info', 'Clean banners views and clicks info ( days )', '60', 'digit', '', '', '', 5), 
    1054 (@iCategoryId, 'db_clean_vkiss', 'Clean old greetings ( days )', '90', 'digit', '', '', '', 6); 
    1055  
    1056  
    1057 INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'matches', '_adm_stg_cpt_category_matches', 0, 12); 
    1058 SET @iCategoryId = LAST_INSERT_ID(); 
    1059  
    1060 INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES 
    1061 (@iCategoryId, 'enable_match', 'Enable matchmaking', 'on', 'checkbox', '', '', '', 1), 
    1062 (@iCategoryId, 'view_match_percent', 'Enable view match percent for profiles', 'on', 'checkbox', '', '', '', 2), 
    1063 (@iCategoryId, 'match_percent', 'Send a cupid mail if the recently joined profile matches more than this percentage', '85', 'digit', '', '', '', 3); 
     293(@iCategoryId, 'db_clean_views', 'Clean old profile views ( days )', '180', 'digit', '', '', '', 3); 
    1064294 
    1065295 
    … …  
    1095325(@iCategoryId, 'short_date_format', 'Short Date Format(for database)', '%d.%m.%Y', 'digit', '', '', '', 7), 
    1096326(@iCategoryId, 'date_format', 'Long Date Format(for database)', '%d.%m.%Y %H:%i', 'digit', '', '', '', 8), 
    1097 (@iCategoryId, 'enable_contact_form', 'Show contact form on contact us page', 'on', 'checkbox', '', '', '', 9), 
    1098327(@iCategoryId, 'enable_gd', 'Use GD library for image processing', 'on', 'checkbox', '', '', '', 10), 
    1099328(@iCategoryId, 'sys_calendar_starts_sunday', 'Does Calender start on Sunday?', '', 'checkbox', '', '', '', 11), 
    … …  
    1101330(@iCategoryId, 'license_code', 'Dolphin License Code', '', 'digit', '', '', '', 13), 
    1102331(@iCategoryId, 'boonexAffID', 'My BoonEx Affiliate ID', '', 'digit', '', '', '', 14), 
    1103 (@iCategoryId, 'useLikeOperator', 'Use operator LIKE for search (recommended for small content)', 'on', 'checkbox', '', '', '', 15), 
    1104 (@iCategoryId, 'ext_nav_menu_top_position', 'Member menu position', 'bottom', 'select', 'top,bottom,static', 'return strlen($arg0) > 0;', 'cannot be empty.', 16), 
    1105 (@iCategoryId, 'ext_nav_menu_enabled', 'Enable member menu', 'on', 'checkbox', '', '', '', 17), 
    1106 (@iCategoryId, 'sys_make_album_cover_last', 'Set last object as cover of album', 'on', 'checkbox', '', '', '', 18), 
    1107 (@iCategoryId, 'sys_album_auto_app', 'Autoapproval for albums', 'on', 'checkbox', '', '', '', 19), 
    1108 (@iCategoryId, 'sys_album_default_name', 'Default album name', 'Hidden', 'text', '', '', '', 20); 
     332(@iCategoryId, 'useLikeOperator', 'Use operator LIKE for search (recommended for small content)', 'on', 'checkbox', '', '', '', 15); 
    1109333 
    1110334 
    … …  
    1116340(@iCategoryId, 'transparent1', 'Transparency for first image', '0', 'digit', '', '', '', 2), 
    1117341(@iCategoryId, 'Water_Mark', 'Water Mark', '', 'file', '', '', '', 3); 
    1118  
    1119  
    1120 INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'meta_tags', '_adm_stg_cpt_category_meta_tags', 0, 17); 
    1121 SET @iCategoryId = LAST_INSERT_ID(); 
    1122  
    1123 INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES 
    1124 (@iCategoryId, 'MetaDescription', 'Insert Meta description on site homepage', '', 'text', '', '', '', 1), 
    1125 (@iCategoryId, 'MetaKeyWords', 'Insert Meta keywords on site homepage (comma-separated list)', '', 'text', '', '', '', 2); 
    1126  
    1127  
    1128 INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'media', '_adm_stg_cpt_category_media', 0, 18); 
    1129 SET @iCategoryId = LAST_INSERT_ID(); 
    1130  
    1131 INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES 
    1132 (@iCategoryId, 'galleryFiles_user', 'Number of gallery files relate to user', '2', 'digit', '', '', '', 1), 
    1133 (@iCategoryId, 'galleryFiles_keyword', 'Number of related gallery files', '2', 'digit', '', '', '', 2); 
    1134342 
    1135343 
    … …  
    1146354INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'permalinks', '_adm_stg_cpt_category_permalinks', 0, 20); 
    1147355SET @iCategoryId = LAST_INSERT_ID(); 
    1148  
    1149 INSERT INTO `sys_options`(`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES 
    1150 (@iCategoryId, 'enable_modrewrite', 'Enable friendly profile permalinks', 'on', 'checkbox', '', '', '', 1), 
    1151 (@iCategoryId, 'permalinks_browse', 'Enable friendly browse permalinks', 'on', 'checkbox', '', '', '', 2); 
    1152  
    1153356 
    1154357INSERT INTO `sys_options_categories`(`type_id`, `name`, `caption`, `hidden`, `order`) VALUES (@iTypeId, 'categories', '_adm_stg_cpt_category_categories', 0, 21); 
    … …  
    1198401 
    1199402-- 
    1200 -- Table structure for table `sys_fave_list` 
    1201 -- 
    1202  
    1203 CREATE TABLE `sys_fave_list` ( 
    1204   `ID` int(10) unsigned NOT NULL default '0', 
    1205   `Profile` int(10) unsigned NOT NULL default '0', 
    1206   `When` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 
    1207   UNIQUE KEY `HotPair` (`ID`,`Profile`), 
    1208   KEY `ID` (`ID`), 
    1209   KEY `Profile` (`Profile`) 
    1210 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1211  
    1212 -- 
    1213 -- Dumping data for table `sys_fave_list` 
    1214 -- 
    1215  
    1216 -- -------------------------------------------------------- 
    1217  
    1218 -- 
    1219403-- Table structure for table `sys_ip_list` 
    1220404-- 
    … …  
    1232416) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1233417 
    1234 -- 
    1235 -- Dumping data for table `sys_ip_list` 
    1236 -- 
    1237  
    1238418-- -------------------------------------------------------- 
    1239419 
    … …  
    1252432) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    1253433 
    1254 -- 
    1255 -- Dumping data for table `sys_ip_members_visits` 
    1256 -- 
    1257  
    1258434-- -------------------------------------------------------- 
    1259435 
    … …  
    1288464  UNIQUE KEY `Key` (`Key`) 
    1289465) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    1290  
    1291 -- 
    1292 -- Dumping data for table `sys_localization_keys` 
    1293 -- 
    1294466 
    1295467-- -------------------------------------------------------- 
    … …  
    1309481) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    1310482 
    1311 -- 
    1312 -- Dumping data for table `sys_localization_languages` 
    1313 -- 
    1314  
    1315 -- INSERT INTO `sys_localization_languages` VALUES(1, 'en', 'gb', 'English'); 
    1316483 
    1317484-- -------------------------------------------------------- 
    … …  
    1327494  PRIMARY KEY  (`IDKey`,`IDParam`) 
    1328495) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1329  
    1330 -- 
    1331 -- Dumping data for table `sys_localization_string_params` 
    1332 -- 
    1333496 
    1334497-- -------------------------------------------------------- 
    … …  
    1362525 
    1363526INSERT INTO `sys_acl_actions` (`ID`, `Module`, `Name`, `AdditionalParamName`, `Title`, `Desc`, `Countable`, `DisabledForLevels`) VALUES 
    1364 (1, 'system', 'send greetings', NULL, '_sys_acl_action_send_greetings', '', 1, 3), 
    1365 (2, 'system', 'view profiles', NULL, '_sys_acl_action_view_profile', '', 1, 0), 
    1366527(3, 'system', 'vote', NULL, '_sys_acl_action_vote', '', 0, 0), 
    1367 (4, 'system', 'send messages', NULL, '_sys_acl_action_send_messages', '', 0, 3), 
    1368 (5, 'system', 'get other members emails', NULL, '_sys_acl_action_get_email', '', 1, 3), 
    1369528(6, 'system', 'comments post', NULL, '_sys_acl_action_comments_post', '', 0, 3), 
    1370529(7, 'system', 'comments vote', NULL, '_sys_acl_action_comments_vote', '', 0, 3), 
    … …  
    1452611 
    1453612-- 
    1454 -- Table structure for table `sys_messages` 
    1455 -- 
    1456  
    1457  
    1458 -- 
    1459 -- Table structure for table `sys_messages` 
    1460 -- 
    1461  
    1462 CREATE TABLE `sys_messages` ( 
    1463   `ID` int(11) NOT NULL AUTO_INCREMENT, 
    1464   `Date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 
    1465   `Sender` int(10) unsigned NOT NULL DEFAULT '0', 
    1466   `Recipient` int(10) unsigned NOT NULL DEFAULT '0', 
    1467   `Text` mediumtext NOT NULL, 
    1468   `Subject` varchar(255) NOT NULL DEFAULT '', 
    1469   `New` enum('0','1') NOT NULL DEFAULT '1', 
    1470   `Type` enum('letter','greeting') NOT NULL DEFAULT 'letter', 
    1471   `Trash` set('sender','recipient') NOT NULL, 
    1472   `TrashNotView` set('sender','recipient') NOT NULL, 
    1473   PRIMARY KEY (`ID`), 
    1474   KEY `Pair` (`Sender`,`Recipient`), 
    1475   KEY `TrashNotView` (`TrashNotView`), 
    1476   KEY `Trash` (`Trash`) 
    1477 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    1478  
    1479 -- 
    1480 -- Dumping data for table `sys_messages` 
    1481 -- 
    1482  
    1483 -- -------------------------------------------------------- 
    1484  
    1485 -- 
    1486 -- Table structure for table `sys_page_compose_pages` 
    1487 -- 
    1488  
    1489 CREATE TABLE `sys_page_compose_pages` ( 
    1490   `Name` varchar(255) NOT NULL default '', 
    1491   `Title` varchar(255) NOT NULL default '', 
    1492   `Order` int(10) unsigned NOT NULL default '0', 
    1493   `System` tinyint(1) NOT NULL default '1', 
    1494   PRIMARY KEY  (`Name`) 
    1495 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1496  
    1497 -- 
    1498 -- Dumping data for table `sys_page_compose_pages` 
    1499 -- 
    1500  
    1501 INSERT INTO `sys_page_compose_pages` VALUES('index', 'Homepage', 1, 1); 
    1502 INSERT INTO `sys_page_compose_pages` VALUES('member', 'Account', 6, 1); 
    1503 INSERT INTO `sys_page_compose_pages` VALUES('profile', 'Profile', 7, 1); 
    1504 INSERT INTO `sys_page_compose_pages` VALUES('pedit', 'Profile Edit', 8, 1); 
    1505 INSERT INTO `sys_page_compose_pages` VALUES('profile_info', 'Profile Info', 14, 1); 
    1506 INSERT INTO `sys_page_compose_pages` VALUES('profile_private', 'Profile Private', 15, 1); 
    1507 INSERT INTO `sys_page_compose_pages` VALUES('browse_page', 'All Members', 17, 1); 
    1508 INSERT INTO `sys_page_compose_pages` VALUES('mail_page', 'Mail messages', 18, 1); 
    1509 INSERT INTO `sys_page_compose_pages` VALUES('mail_page_view', 'Mail view message', 19, 1); 
    1510 INSERT INTO `sys_page_compose_pages` VALUES('mail_page_compose', 'Mail compose message', 20, 1); 
    1511 INSERT INTO `sys_page_compose_pages` VALUES('search', 'Search Profiles', 21, 1); 
    1512 INSERT INTO `sys_page_compose_pages` VALUES('join', 'Join Page', 22, 1); 
    1513 INSERT INTO `sys_page_compose_pages` VALUES('friends', 'Friends', 23, 1); 
    1514 INSERT INTO `sys_page_compose_pages` VALUES('my_friends', 'My Friends', 23, 1); 
    1515 INSERT INTO `sys_page_compose_pages` VALUES('communicator_page', 'Communicator', 24, 1); 
    1516 INSERT INTO `sys_page_compose_pages` VALUES('search_home', 'Search Home', 25, 1); 
    1517 INSERT INTO `sys_page_compose_pages` VALUES('tags_home', 'Tags Home', 26, 1); 
    1518 INSERT INTO `sys_page_compose_pages` VALUES('tags_calendar', 'Tags Search', 27, 1); 
    1519 INSERT INTO `sys_page_compose_pages` VALUES('tags_search', 'Tags Calendar', 28, 1); 
    1520 INSERT INTO `sys_page_compose_pages` VALUES('tags_module', 'Tags Module', 29, 1); 
    1521 INSERT INTO `sys_page_compose_pages` VALUES('categ_calendar', 'Categories Calendar', 30, 1); 
    1522 INSERT INTO `sys_page_compose_pages` VALUES('categ_search', 'Categories Search', 31, 1); 
    1523 INSERT INTO `sys_page_compose_pages` VALUES('categ_module', 'Categories Module', 32, 1); 
    1524  
    1525 -- 
    1526 -- Table structure for table `sys_page_compose_privacy` 
    1527 -- 
    1528 CREATE TABLE `sys_page_compose_privacy` ( 
    1529   `id` int(11) unsigned NOT NULL auto_increment, 
    1530   `user_id` int(11) unsigned NOT NULL default '0', 
    1531   `block_id` int(11) unsigned NOT NULL default '0', 
    1532   `allow_view_block_to` int(11) unsigned NOT NULL default '0', 
    1533   PRIMARY KEY  (`id`), 
    1534   UNIQUE KEY `block` (`user_id`, `block_id`) 
    1535 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1536  
    1537 -- 
    1538 -- Dumping data for table `sys_page_compose_pages` 
    1539 -- 
    1540  
    1541  
    1542 -- 
    1543 -- Table structure for table `sys_page_compose` 
    1544 -- 
    1545  
    1546 CREATE TABLE `sys_page_compose` ( 
    1547   `ID` int(11) unsigned NOT NULL auto_increment, 
    1548   `Page` varchar(255) NOT NULL default '', 
    1549   `PageWidth` varchar(10) NOT NULL default '998px', 
    1550   `Desc` text NOT NULL, 
    1551   `Caption` varchar(255) NOT NULL default '', 
    1552   `Column` tinyint(3) unsigned NOT NULL default '0', 
    1553   `Order` smallint(6) unsigned NOT NULL default '0', 
    1554   `Func` varchar(255) NOT NULL default '', 
    1555   `Content` text NOT NULL, 
    1556   `DesignBox` tinyint(3) unsigned NOT NULL default '1', 
    1557   `ColWidth` float unsigned NOT NULL default '0', 
    1558   `Visible` set('non','memb') NOT NULL default 'non,memb', 
    1559   `MinWidth` int(10) unsigned NOT NULL default '0', 
    1560   `Cache` int(11) NOT NULL DEFAULT '0', 
    1561   PRIMARY KEY  (`ID`) 
    1562 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    1563  
    1564  
    1565 -- 
    1566 -- Dumping data for table `sys_page_compose` 
    1567 -- 
    1568  
    1569 INSERT INTO `sys_page_compose` VALUES(1, 'index', '998px', 'Shows statistic information concerning your profiles database', '_Site Stats', 2, 0, 'SiteStats', '', 1, 34, 'non,memb', 0, 3600); 
    1570 INSERT INTO `sys_page_compose` VALUES(3, 'index', '998px', 'Display form to subscribe to newsletters', '_Subscribe', 2, 6, 'Subscribe', '', 1, 34, 'non,memb', 0, 0); 
    1571 INSERT INTO `sys_page_compose` VALUES(4, 'index', '998px', 'Quick search form', '_Quick Search', 2, 2, 'QuickSearch', '', 1, 34, 'non,memb', 0, 0); 
    1572 INSERT INTO `sys_page_compose` VALUES(5, 'index', '998px', 'Top rated profiles', '_Leaders', 1, 3, 'Leaders', '', 1, 66, 'non,memb', 0, 0); 
    1573 INSERT INTO `sys_page_compose` VALUES(7, 'index', '998px', 'List of featured profiles randomly selected from database', '_featured members', 1, 5, 'Featured', '', 1, 66, 'non,memb', 0, 0); 
    1574 INSERT INTO `sys_page_compose` VALUES(9, 'index', '998px', 'Site Tags', '_Tags', 1, 11, 'Tags', '', 1, 66, 'non,memb', 0, 0); 
    1575 INSERT INTO `sys_page_compose` VALUES(10, 'index', '998px', 'Site Categories', '_Categories', 1, 12, 'Categories', '', 1, 66, 'non,memb', 0, 0); 
    1576 INSERT INTO `sys_page_compose` VALUES(11, 'index', '998px', 'Short list of top profiles selected by given criteria', '_Members', 1, 2, 'Members', '', 1, 66, 'non,memb', 0, 0); 
    1577 INSERT INTO `sys_page_compose` VALUES(14, 'index', '998px', 'Shows Login Form', '_Member Login', 2, 0, 'LoginSection', '', 1, 34, 'non', 0, 86400); 
    1578 INSERT INTO `sys_page_compose` VALUES(15, 'index', '998px', '', '_BoonEx News', 1, 1, 'RSS', 'http://www.boonex.com/unity/blog/featured_posts/?rss=1#4', 1, 66, 'non,memb', 0, 86400); 
    1579 INSERT INTO `sys_page_compose` VALUES(19, 'index', '998px', 'Download', '_sys_box_title_download', 2, 7, 'Download', '', 1, 34, 'non,memb', 0, 86400); 
    1580 INSERT INTO `sys_page_compose` VALUES(54, 'member', '998px', 'Mailbox desc', '_Mailbox', 2, 1, 'Mailbox', '', 1, 66, 'non,memb', 0, 0); 
    1581 INSERT INTO `sys_page_compose` VALUES(56, 'member', '998px', '', '_BoonEx News', 0, 0, 'RSS', 'http://www.boonex.com/unity/blog/featured_posts/?rss=1#4', 1, 50, 'non,memb', 0, 86400); 
    1582 INSERT INTO `sys_page_compose` VALUES(65, 'profile', '998px', 'Actions that other members can do', '_Actions', 1, 0, 'ActionsMenu', '', 1, 34, 'non,memb', 0, 0); 
    1583 INSERT INTO `sys_page_compose` VALUES(66, 'profile', '998px', 'Friend request notification', '_FriendRequest', 1, 1, 'FriendRequest', '', 1, 34, 'memb', 0, 0); 
    1584 INSERT INTO `sys_page_compose` VALUES(67, 'profile', '998px', 'Profile rating form', '_rate profile', 2, 3, 'RateProfile', '', 1, 66, 'non,memb', 0, 0); 
    1585 INSERT INTO `sys_page_compose` VALUES(68, 'profile', '998px', 'Member friends list', '_Friends', 2, 4, 'Friends', '', 1, 66, 'non,memb', 0, 0); 
    1586 INSERT INTO `sys_page_compose` VALUES(69, 'profile', '998px', 'Comments on member profile', '_profile_comments', 2, 6, 'Cmts', '', 1, 66, 'non,memb', 0, 0); 
    1587 INSERT INTO `sys_page_compose` VALUES(72, 'profile', '998px', '', '_BoonEx News', 0, 0, 'RSS', 'http://www.boonex.com/unity/blog/featured_posts/?rss=1#4', 1, 66, 'non,memb', 0, 0); 
    1588 INSERT INTO `sys_page_compose` VALUES(79, 'profile', '998px', 'Mutual friends of viewing and viewed members', '_Mutual Friends', 2, 5, 'MutualFriends', '', 1, 66, 'non,memb', 0, 0); 
    1589 INSERT INTO `sys_page_compose` VALUES(80, 'profile', '998px', 'Profile Fields Block', '_FieldCaption_General Info_View', 2, 1, 'PFBlock', '17', 1, 66, 'non,memb', 0, 0); 
    1590 INSERT INTO `sys_page_compose` VALUES(172, 'profile', '998px', 'Profile description block', '_Description', 2, 2, 'Description', '', 1, 66, 'non,memb', 0, 0); 
    1591 INSERT INTO `sys_page_compose` VALUES(82, 'profile', '998px', 'Profile Fields Block', '_FieldCaption_Admin Controls_View', 2, 0, 'PFBlock', '21', 1, 66, 'non,memb', 0, 0); 
    1592 INSERT INTO `sys_page_compose` VALUES(84, 'profile', '998px', 'Profile Fields Block', '_FieldCaption_Security Image_View', 0, 0, 'PFBlock', '25', 1, 66, 'non,memb', 0, 0); 
    1593 INSERT INTO `sys_page_compose` VALUES(85, 'profile', '998px', 'Profile Fields Block', '_FieldCaption_Profile Type_View', 0, 0, 'PFBlock', '34', 1, 66, 'non,memb', 0, 0); 
    1594 INSERT INTO `sys_page_compose` VALUES(86, '', '998px', 'RSS Feed', '_RSS Feed', 0, 0, 'Sample', 'RSS', 1, 0, 'non,memb', 0, 0); 
    1595 INSERT INTO `sys_page_compose` VALUES(87, '', '998px', 'Simple HTML Block', '_HTML Block', 0, 0, 'Sample', 'Echo', 1, 0, 'non,memb', 0, 0); 
    1596 INSERT INTO `sys_page_compose` VALUES(88, 'member', '998px', 'Member Friends', '_My Friends', 1, 6, 'Friends', '', 1, 34, 'memb', 0, 0); 
    1597 INSERT INTO `sys_page_compose` VALUES(121, 'profile_info', '998px', '', '_FieldCaption_General Info_View', 1, 0, 'GeneralInfo', '', 1, 100, 'non,memb', 0, 0); 
    1598 INSERT INTO `sys_page_compose` VALUES(122, 'profile_info', '998px', '', '_Additional information', 1, 2, 'AdditionalInfo', '', 1, 100, 'non,memb', 0, 0); 
    1599 INSERT INTO `sys_page_compose` VALUES(123, 'member', '998px', 'Account Control', '_Account Control', 1, 0, 'AccountControl', '', 1, 34, 'memb', 0, 0); 
    1600 INSERT INTO `sys_page_compose` VALUES(124, 'member', '998px', 'Quick Links', '_Quick Links', 2, 0, 'QuickLinks', '', 1, 66, 'memb', 0, 0); 
    1601 INSERT INTO `sys_page_compose` VALUES(135, 'my_friends', '998px', '', '_Friends', 2, 0, 'Friends', '', 1, 100, 'non,memb', 0, 0); 
    1602 INSERT INTO `sys_page_compose` VALUES(137, 'browse_page', '998px', '', '_Browse', 2, 0, 'SettingsBlock', '', 0, 34, 'non,memb', 0, 0); 
    1603 INSERT INTO `sys_page_compose` VALUES(138, 'browse_page', '998px', '', '_People', 1, 0, 'SearchedMembersBlock', '', 1, 66, 'non,memb', 0, 0); 
    1604 INSERT INTO `sys_page_compose` VALUES(139, 'mail_page', '998px', '', '_Mail box', 2, 0, 'MailBox', '', 1, 68, 'non,memb', 0, 0); 
    1605 INSERT INTO `sys_page_compose` VALUES(140, 'mail_page', '998px', '', '_My contacts', 1, 0, 'Contacts', '', 1, 32, 'non,memb', 0, 0); 
    1606 INSERT INTO `sys_page_compose` VALUES(141, 'mail_page_view', '998px', '', '_Mail box', 2, 0, 'ViewMessage', '', 1, 68, 'non,memb', 0, 0); 
    1607 INSERT INTO `sys_page_compose` VALUES(142, 'mail_page_view', '998px', '', '_Archive', 1, 0, 'Archives', '', 1, 32, 'non,memb', 0, 0); 
    1608 INSERT INTO `sys_page_compose` VALUES(143, 'mail_page_compose', '998px', '', '_COMPOSE_H', 2, 0, 'ComposeMessage', '', 1, 68, 'non,memb', 0, 0); 
    1609 INSERT INTO `sys_page_compose` VALUES(144, 'mail_page_compose', '998px', '', '_My contacts', 1, 0, 'Contacts', '', 1, 32, 'non,memb', 0, 0); 
    1610 INSERT INTO `sys_page_compose` VALUES(145, 'search', '998px', 'Search Results', '_Search result', 1, 0, 'Results', '', 0, 66, 'non,memb', 0, 0); 
    1611 INSERT INTO `sys_page_compose` VALUES(146, 'search', '998px', 'Search Form', '_Search profiles', 2, 0, 'SearchForm', '', 0, 34, 'non,memb', 0, 0); 
    1612 INSERT INTO `sys_page_compose` VALUES(147, 'join', '998px', 'Join Form Block', '_Join now', 1, 0, 'JoinForm', '', 1, 66, 'non', 413, 0); 
    1613 INSERT INTO `sys_page_compose` VALUES(148, 'join', '998px', 'Login Form Block', '_Login', 2, 1, 'LoginSection', 'no_join_text', 1, 34, 'non', 250, 86400); 
    1614 INSERT INTO `sys_page_compose` VALUES(149, 'join', '998px', 'Simple HTML Block', '_Why join', 2, 0, 'PHP', 'return _t(''_why_join_desc'');', 1, 34, 'non,memb', 0, 86400); 
    1615 INSERT INTO `sys_page_compose` VALUES(150, 'friends', '998px', '', '_Member Friends', 1, 0, 'Friends', '', 1, 100, 'non,memb', 0, 0); 
    1616 INSERT INTO `sys_page_compose` VALUES(151, 'communicator_page', '998px', '', '_Activity', 2, 0, 'CommunicatorPage', '', 1, 100, 'non,memb', 0, 0); 
    1617 INSERT INTO `sys_page_compose` VALUES(155, 'search_home', '998px', 'Keyword Search', '_sys_box_title_search_keyword', 1, 0, 'Keyword', '', 1, 66, 'non,memb', 0, 86400); 
    1618 INSERT INTO `sys_page_compose` VALUES(156, 'search_home', '998px', 'People Search', '_sys_box_title_search_people', 2, 0, 'People', '', 1, 34, 'non,memb', 0, 0); 
    1619 INSERT INTO `sys_page_compose` VALUES(157, 'tags_home', '998px', 'Recent Tags', '_tags_recent', 1, 0, 'Recent', '', 1, 34, 'non,memb', 0, 0); 
    1620 INSERT INTO `sys_page_compose` VALUES(158, 'tags_home', '998px', 'Popular Tags', '_popular_tags', 2, 0, 'Popular', '', 1, 66, 'non,memb', 0, 0); 
    1621 INSERT INTO `sys_page_compose` VALUES(159, 'tags_calendar', '998px', 'Calendar', '_tags_calendar', 1, 0, 'Calendar', '', 1, 100, 'non,memb', 0, 0); 
    1622 INSERT INTO `sys_page_compose` VALUES(160, 'tags_calendar', '998px', 'Date Tags', '_Tags', 1, 1, 'TagsDate', '', 1, 100, 'non,memb', 0, 0); 
    1623 INSERT INTO `sys_page_compose` VALUES(161, 'tags_search', '998px', 'Search Form', '_tags_search_form', 1, 0, 'Form', '', 1, 100, 'non,memb', 0, 86400); 
    1624 INSERT INTO `sys_page_compose` VALUES(162, 'tags_search', '998px', 'Founded Tags', '_tags_founded_tags', 1, 1, 'Founded', '', 1, 100, 'non,memb', 0, 0); 
    1625 INSERT INTO `sys_page_compose` VALUES(163, 'tags_module', '998px', 'Recent Tags', '_tags_recent', 1, 0, 'Recent', '', 1, 34, 'non,memb', 0, 0); 
    1626 INSERT INTO `sys_page_compose` VALUES(164, 'tags_module', '998px', 'All Tags', '_all_tags', 2, 0, 'All', '', 1, 66, 'non,memb', 0, 0); 
    1627 INSERT INTO `sys_page_compose` VALUES(165, 'categ_calendar', '998px', 'Calendar', '_categ_caption_calendar', 1, 0, 'Calendar', '', 1, 100, 'non,memb', 0, 0); 
    1628 INSERT INTO `sys_page_compose` VALUES(166, 'categ_calendar', '998px', 'Categories By Day', '_categ_caption_day', 1, 1, 'CategoriesDate', '', 1, 100, 'non,memb', 0, 0); 
    1629 INSERT INTO `sys_page_compose` VALUES(167, 'categ_search', '998px', 'Search Form', '_categ_caption_search_form', 1, 0, 'Form', '', 1, 100, 'non,memb', 0, 86400); 
    1630 INSERT INTO `sys_page_compose` VALUES(168, 'categ_search', '998px', 'Founded Categories', '_categ_caption_founded', 1, 1, 'Founded', '', 1, 100, 'non,memb', 0, 0); 
    1631 INSERT INTO `sys_page_compose` VALUES(169, 'categ_module', '998px', 'Common Categories', '_categ_caption_common', 1, 0, 'Common', '', 1, 34, 'non,memb', 0, 0); 
    1632 INSERT INTO `sys_page_compose` VALUES(170, 'categ_module', '998px', 'All Categories', '_categ_caption_all', 2, 0, 'All', '', 1, 66, 'non,memb', 0, 0); 
    1633 INSERT INTO `sys_page_compose` VALUES(173, 'profile_info', '998px', 'Profile''s description', '_Description', 1, 1, 'Description', '', 1, 100, 'non,memb', 0, 0); 
    1634 INSERT INTO `sys_page_compose` VALUES(174, 'pedit', '998px', 'Profile fields', '_edit_profile_info', 1, 1, 'Info', '', 1, 50, 'memb', 0, 0); 
    1635 INSERT INTO `sys_page_compose` VALUES(175, 'pedit', '998px', 'Profile privacy', '_edit_profile_privacy', 2, 1, 'Privacy', '', 1, 50, 'memb', 0, 0); 
    1636 INSERT INTO `sys_page_compose` VALUES(176, 'profile', '998px', 'Profile Fields Block', '_FieldCaption_Misc_View', 0, 0, 'PFBlock', '20', 1, 66, 'non,memb', 0, 0); 
    1637 INSERT INTO `sys_page_compose` VALUES(178, 'profile_private', '998px', 'Actions that other members can do', '_Actions', 1, 0, 'ActionsMenu', '', 1, 34, 'non,memb', 0, 0); 
    1638 INSERT INTO `sys_page_compose` VALUES(179, 'profile_private', '998px', 'Some text to explain why this profile can not be viewed. Translation for this block is stored in ''_sys_profile_private_text'' language key.', '_sys_profile_private_text_title', 2, 0, 'PrivacyExplain', '', 1, 66, 'non,memb', 0, 0); 
    1639  
    1640 -- -------------------------------------------------------- 
    1641  
    1642 -- 
    1643613-- Table structure for table `boon_sys_sessions` 
    1644614-- 
    … …  
    1653623  KEY `date` (`date`) 
    1654624) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; 
    1655  
    1656 -- -------------------------------------------------------- 
    1657  
    1658 -- 
    1659 -- Table structure for table `sys_stat_member` 
    1660 -- 
    1661  
    1662 CREATE TABLE `sys_stat_member` ( 
    1663   `Type` varchar(10) NOT NULL, 
    1664   `SQL` varchar(255) NOT NULL 
    1665 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; 
    1666  
    1667 -- 
    1668 -- Dumping data for table `sys_stat_member` 
    1669 -- 
    1670  
    1671 INSERT INTO `sys_stat_member` VALUES('mma', 'SELECT COUNT(*) FROM `sys_messages` WHERE `Recipient`=''__member_id__'' AND NOT FIND_IN_SET(''Recipient'', `sys_messages`.`Trash`)'); 
    1672 INSERT INTO `sys_stat_member` VALUES('mmn', 'SELECT COUNT(*) FROM `sys_messages` WHERE `Recipient`=''__member_id__'' AND `New`=''1'' AND NOT FIND_IN_SET(''Recipient'', `sys_messages`.`Trash`)'); 
    1673 INSERT INTO `sys_stat_member` VALUES('mfl', 'SELECT COUNT(*) FROM `sys_fave_list` WHERE `ID` = ''__member_id__'' '); 
    1674 INSERT INTO `sys_stat_member` VALUES('mfr', 'SELECT COUNT(*) FROM `sys_friend_list` WHERE `Profile` = ''__member_id__'' AND  `Check` = ''0'''); 
    1675 INSERT INTO `sys_stat_member` VALUES('mfa', 'SELECT COUNT(*) FROM `sys_friend_list` WHERE ( `ID`=''__member_id__'' OR `Profile`=''__member_id__'' ) AND `Check`=''1'''); 
    1676 INSERT INTO `sys_stat_member` VALUES('mgc', 'SELECT COUNT(*) FROM `sys_greetings` WHERE `ID` = ''__member_id__'' AND New = ''1'''); 
    1677 INSERT INTO `sys_stat_member` VALUES('mbc', 'SELECT COUNT(*) FROM `sys_block_list` WHERE `ID` = ''__member_id__'''); 
    1678 INSERT INTO `sys_stat_member` VALUES('mgmc', 'SELECT COUNT(*) FROM `sys_greetings` WHERE `Profile` = ''__member_id__'' AND New = ''1'''); 
    1679  
    1680 -- -------------------------------------------------------- 
    1681  
    1682  
    1683  
    1684 -- 
    1685 -- Table structure for table `sys_profile_fields` 
    1686 -- 
    1687  
    1688 CREATE TABLE `sys_profile_fields` ( 
    1689   `ID` smallint(10) unsigned NOT NULL AUTO_INCREMENT, 
    1690   `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', 
    1691   `Type` enum('text','html_area','area','pass','date','select_one','select_set','num','range','bool','system','block') NOT NULL DEFAULT 'text', 
    1692   `Control` enum('select','checkbox','radio') DEFAULT NULL COMMENT 'input element for selectors', 
    1693   `Extra` text NOT NULL, 
    1694   `Min` float DEFAULT NULL, 
    1695   `Max` float DEFAULT NULL, 
    1696   `Values` text NOT NULL, 
    1697   `UseLKey` enum('LKey','LKey2','LKey3') NOT NULL DEFAULT 'LKey', 
    1698   `Check` text NOT NULL, 
    1699   `Unique` tinyint(1) NOT NULL DEFAULT '0', 
    1700   `Default` text NOT NULL, 
    1701   `Mandatory` tinyint(1) NOT NULL DEFAULT '0', 
    1702   `Deletable` tinyint(1) NOT NULL DEFAULT '1', 
    1703   `JoinPage` int(10) unsigned NOT NULL DEFAULT '0', 
    1704   `JoinBlock` int(10) unsigned NOT NULL DEFAULT '0', 
    1705   `JoinOrder` float DEFAULT NULL, 
    1706   `EditOwnBlock` int(10) unsigned NOT NULL DEFAULT '0', 
    1707   `EditOwnOrder` float DEFAULT NULL, 
    1708   `EditAdmBlock` int(10) unsigned NOT NULL DEFAULT '0', 
    1709   `EditAdmOrder` float DEFAULT NULL, 
    1710   `EditModBlock` int(10) unsigned NOT NULL DEFAULT '0', 
    1711   `EditModOrder` float DEFAULT NULL, 
    1712   `ViewMembBlock` int(10) unsigned NOT NULL DEFAULT '0', 
    1713   `ViewMembOrder` float DEFAULT NULL, 
    1714   `ViewAdmBlock` int(10) unsigned NOT NULL DEFAULT '0', 
    1715   `ViewAdmOrder` float DEFAULT NULL, 
    1716   `ViewModBlock` int(10) unsigned NOT NULL DEFAULT '0', 
    1717   `ViewModOrder` float DEFAULT NULL, 
    1718   `ViewVisBlock` int(10) unsigned NOT NULL DEFAULT '0', 
    1719   `ViewVisOrder` float DEFAULT NULL, 
    1720   `SearchParams` text NOT NULL, 
    1721   `SearchSimpleBlock` int(10) unsigned NOT NULL DEFAULT '0', 
    1722   `SearchSimpleOrder` float DEFAULT NULL, 
    1723   `SearchQuickBlock` int(10) unsigned NOT NULL DEFAULT '0', 
    1724   `SearchQuickOrder` float DEFAULT NULL, 
    1725   `SearchAdvBlock` int(10) unsigned NOT NULL DEFAULT '0', 
    1726   `SearchAdvOrder` float DEFAULT NULL, 
    1727   `MatchField` int(10) unsigned NOT NULL DEFAULT '0', 
    1728   `MatchPercent` tinyint(7) unsigned NOT NULL DEFAULT '0', 
    1729   PRIMARY KEY (`ID`), 
    1730   UNIQUE KEY `Name` (`Name`) 
    1731 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    1732  
    1733 -- 
    1734 -- Dumping data for table `sys_profile_fields` 
    1735 -- 
    1736  
    1737 INSERT INTO `sys_profile_fields` VALUES(1, 'ID', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 1, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 17, 1, 17, 1, 0, NULL, '', 17, 2, 17, 2, 0, NULL, 0, 0); 
    1738 INSERT INTO `sys_profile_fields` VALUES(2, 'NickName', 'text', NULL, '', 4, 16, '', 'LKey', 'return ( preg_match( ''/^[a-zA-Z0-9_-]+$/'', $arg0 ) and !file_exists( $dir[''root''] . $arg0 ) );', 1, '', 1, 0, 0, 17, 2, 17, 1, 17, 1, 17, 1, 0, NULL, 17, 3, 17, 2, 0, NULL, '', 17, 1, 17, 1, 0, NULL, 0, 0); 
    1739 INSERT INTO `sys_profile_fields` VALUES(3, 'Password', 'pass', NULL, '', 5, 16, '', 'LKey', '', 0, '', 1, 0, 0, 17, 5, 17, 7, 17, 6, 17, 8, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1740 INSERT INTO `sys_profile_fields` VALUES(4, 'Email', 'text', NULL, '', 6, NULL, '', 'LKey', 'return (bool) preg_match(''/^([a-z0-9\\+\\_\\-\\.]+)@([a-z0-9\\+\\_\\-\\.]+)$/i'', $arg0);', 1, '', 1, 0, 0, 17, 6, 17, 4, 17, 4, 17, 2, 0, NULL, 21, 1, 21, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1741 INSERT INTO `sys_profile_fields` VALUES(5, 'DateReg', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 2, 21, 2, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1742 INSERT INTO `sys_profile_fields` VALUES(6, 'DateLastEdit', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 4, 21, 4, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1743 INSERT INTO `sys_profile_fields` VALUES(7, 'Status', 'system', NULL, '', NULL, NULL, 'Unconfirmed\nApproval\nActive\nRejected\nSuspended', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 21, 1, 21, 1, 0, NULL, 17, 6, 17, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1744 INSERT INTO `sys_profile_fields` VALUES(8, 'DateLastLogin', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 3, 21, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1745 INSERT INTO `sys_profile_fields` VALUES(9, 'Featured', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 21, 2, 21, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1746 INSERT INTO `sys_profile_fields` VALUES(10, 'Sex', 'select_one', 'radio', '', NULL, NULL, '#!Sex', 'LKey', '', 0, 'male', 1, 0, 0, 20, 1, 17, 6, 17, 5, 17, 3, 17, 4, 17, 7, 17, 4, 17, 5, '', 20, 2, 20, 2, 17, 2, 11, 15); 
    1747 INSERT INTO `sys_profile_fields` VALUES(11, 'LookingFor', 'select_set', 'checkbox', '', NULL, NULL, '#!Sex', 'LKey2', '', 0, '', 0, 0, 0, 20, 8, 20, 1, 20, 1, 17, 7, 17, 8, 17, 11, 17, 5, 17, 7, '', 20, 1, 20, 1, 0, NULL, 10, 30); 
    1748 INSERT INTO `sys_profile_fields` VALUES(12, 'DescriptionMe', 'html_area', NULL, '', 20, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 20, 7, 20, 4, 20, 4, 20, 2, 0, NULL, 0, NULL, 22, 2, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1749 INSERT INTO `sys_profile_fields` VALUES(13, 'DateOfBirth', 'date', NULL, '', 18, 75, '', 'LKey', '', 0, '', 1, 1, 0, 20, 2, 20, 2, 20, 2, 17, 4, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 20, 3, 20, 3, 17, 3, 13, 0); 
    1750 INSERT INTO `sys_profile_fields` VALUES(14, 'Headline', 'text', NULL, '', 5, 65535, '', 'LKey', '', 0, '', 1, 0, 0, 20, 6, 20, 3, 20, 3, 20, 1, 17, 1, 17, 2, 22, 1, 17, 1, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1751 INSERT INTO `sys_profile_fields` VALUES(15, 'Country', 'select_one', 'select', '', NULL, NULL, '#!Country', 'LKey', '', 0, 'US', 1, 0, 0, 20, 3, 20, 5, 20, 5, 17, 5, 17, 6, 17, 9, 20, 2, 17, 4, '', 20, 4, 20, 4, 20, 1, 15, 40); 
    1752 INSERT INTO `sys_profile_fields` VALUES(16, 'City', 'text', NULL, '', 2, 64, '', 'LKey', '', 0, '', 1, 0, 0, 20, 4, 20, 6, 20, 6, 17, 6, 17, 7, 17, 10, 20, 3, 17, 6, '', 0, NULL, 0, NULL, 20, 2, 0, 0); 
    1753 INSERT INTO `sys_profile_fields` VALUES(17, 'General Info', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 1, 0, 1, 0, 2, 0, 2, 0, 1, 0, 1, 0, 1, 0, 1, '', 0, 1, 0, 1, 0, 1, 0, 0); 
    1754 INSERT INTO `sys_profile_fields` VALUES(18, 'Location', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 5, 0, 0); 
    1755 INSERT INTO `sys_profile_fields` VALUES(19, 'Keyword', 'system', NULL, 'DescriptionMe\nHeadline', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 3, 0, 0); 
    1756 INSERT INTO `sys_profile_fields` VALUES(20, 'Misc Info', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 2, 0, 2, 0, 3, 0, 3, 0, 2, 0, 2, 0, 2, 0, 2, '', 0, 2, 0, 2, 0, 2, 0, 0); 
    1757 INSERT INTO `sys_profile_fields` VALUES(21, 'Admin Controls', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 0, NULL, 0, 1, 0, 1, 0, NULL, 0, 3, 0, 4, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1758 INSERT INTO `sys_profile_fields` VALUES(23, 'Couple', 'system', NULL, 'Country\nCity', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 17, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 17, 1, 0, 0); 
    1759 INSERT INTO `sys_profile_fields` VALUES(24, 'Captcha', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 25, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1760 INSERT INTO `sys_profile_fields` VALUES(25, 'Security Image', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 3, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1761 INSERT INTO `sys_profile_fields` VALUES(41, 'EmailNotify', 'bool', 'checkbox', '', NULL, NULL, '', 'LKey', '', 0, '1', 0, 0, 0, 0, NULL, 17, 5, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1762 INSERT INTO `sys_profile_fields` VALUES(39, 'zip', 'text', NULL, '', 1, 32, '', 'LKey', '', 0, '', 1, 0, 0, 20, 5, 20, 7, 20, 7, 20, 3, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1763 INSERT INTO `sys_profile_fields` VALUES(34, 'DateLastNav', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1764 INSERT INTO `sys_profile_fields` VALUES(37, 'aff_num', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1765 INSERT INTO `sys_profile_fields` VALUES(38, 'Tags', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 9, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 20, 5, 20, 5, 20, 4, 0, 0); 
    1766 INSERT INTO `sys_profile_fields` VALUES(42, 'TermsOfUse', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 25, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1767 INSERT INTO `sys_profile_fields` VALUES(44, 'Age', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 17, 5, 17, 8, 20, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1768 INSERT INTO `sys_profile_fields` VALUES(45, 'ProfilePhoto', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 10, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1769 INSERT INTO `sys_profile_fields` VALUES(46, 'UserStatus', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1770 INSERT INTO `sys_profile_fields` VALUES(47, 'UserStatusMessage', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1771 INSERT INTO `sys_profile_fields` VALUES(48, 'UserStatusMessageWhen', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1772 INSERT INTO `sys_profile_fields` VALUES(49, 'Avatar', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1773 INSERT INTO `sys_profile_fields` VALUES(51, 'Height', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 8, 20, 8, 20, 4, 20, 1, 20, 1, 0, NULL, 20, 1, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1774 INSERT INTO `sys_profile_fields` VALUES(52, 'Weight', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 9, 20, 9, 20, 5, 20, 2, 20, 2, 0, NULL, 20, 2, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1775 INSERT INTO `sys_profile_fields` VALUES(53, 'Income', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 10, 20, 10, 20, 6, 20, 3, 20, 3, 0, NULL, 20, 3, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1776 INSERT INTO `sys_profile_fields` VALUES(54, 'Occupation', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 11, 20, 11, 20, 7, 20, 4, 20, 4, 0, NULL, 20, 4, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1777 INSERT INTO `sys_profile_fields` VALUES(55, 'Religion', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 12, 20, 12, 20, 8, 20, 5, 20, 5, 0, NULL, 20, 5, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1778 INSERT INTO `sys_profile_fields` VALUES(56, 'Education', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 13, 20, 13, 20, 9, 20, 6, 20, 6, 0, NULL, 20, 6, '', 0, NULL, 0, NULL, 0, NULL, 56, 0); 
    1779 INSERT INTO `sys_profile_fields` VALUES(57, 'RelationshipStatus', 'select_one', 'select', '', NULL, NULL, 'Single\nIn a Relationship\nEngaged\nMarried\nIt''s Complicated\nIn an Open Relationship', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 14, 20, 14, 20, 10, 20, 7, 20, 7, 0, NULL, 20, 7, '', 0, NULL, 0, NULL, 0, NULL, 57, 10); 
    1780 INSERT INTO `sys_profile_fields` VALUES(58, 'Hobbies', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 15, 20, 15, 20, 11, 20, 8, 20, 8, 0, NULL, 20, 8, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1781 INSERT INTO `sys_profile_fields` VALUES(59, 'Interests', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 16, 20, 16, 20, 12, 20, 9, 20, 9, 0, NULL, 20, 9, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1782 INSERT INTO `sys_profile_fields` VALUES(60, 'Ethnicity', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 17, 20, 17, 20, 13, 20, 10, 20, 10, 0, NULL, 20, 10, '', 0, NULL, 0, NULL, 0, NULL, 60, 5); 
    1783 INSERT INTO `sys_profile_fields` VALUES(61, 'FavoriteSites', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 18, 20, 18, 20, 14, 20, 11, 20, 11, 0, NULL, 20, 11, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1784 INSERT INTO `sys_profile_fields` VALUES(62, 'FavoriteMusic', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 19, 20, 19, 20, 15, 20, 12, 20, 12, 0, NULL, 20, 12, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1785 INSERT INTO `sys_profile_fields` VALUES(63, 'FavoriteFilms', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 20, 20, 20, 20, 16, 20, 13, 20, 13, 0, NULL, 20, 13, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1786 INSERT INTO `sys_profile_fields` VALUES(64, 'FavoriteBooks', 'area', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 20, 21, 20, 21, 20, 17, 20, 14, 20, 14, 0, NULL, 20, 14, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1787 INSERT INTO `sys_profile_fields` VALUES(66, 'FirstName', 'text', NULL, '', 2, 200, '', 'LKey', '', 0, '', 1, 1, 0, 17, 3, 17, 2, 17, 2, 0, NULL, 17, 2, 17, 5, 0, NULL, 17, 2, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1788 INSERT INTO `sys_profile_fields` VALUES(67, 'LastName', 'text', NULL, '', 2, 200, '', 'LKey', '', 0, '', 1, 1, 0, 17, 4, 17, 3, 17, 3, 0, NULL, 17, 3, 17, 4, 0, NULL, 17, 3, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1789 INSERT INTO `sys_profile_fields` VALUES(68, 'allow_view_to', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    1790625 
    1791626-- -------------------------------------------------------- 
    … …  
    1835670) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1836671 
    1837  
    1838 -- -------------------------------------------------------- 
    1839  
    1840 -- 
    1841 -- Table structure for table `sys_profile_views_track` 
    1842 -- 
    1843  
    1844 CREATE TABLE IF NOT EXISTS `sys_profile_views_track` ( 
    1845   `id` int(10) unsigned NOT NULL, 
    1846   `viewer` int(10) unsigned NOT NULL, 
    1847   `ip` int(10) unsigned NOT NULL, 
    1848   `ts` int(10) unsigned NOT NULL, 
    1849   KEY `id` (`id`,`viewer`,`ip`) 
    1850 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1851  
    1852 -- 
    1853 -- Dumping data for table `sys_profile_views_track` 
    1854 -- 
    1855  
    1856 -- -------------------------------------------------------- 
    1857  
    1858 -- 
    1859 -- Table structure for table `sys_profiles_match` 
    1860 -- 
    1861  
    1862 CREATE TABLE `sys_profiles_match` ( 
    1863   `profile_id` int(10) NOT NULL, 
    1864   `sort` enum('none','activity','date_reg') NOT NULL default 'none', 
    1865   `profiles_match` text, 
    1866   UNIQUE KEY `profile_id` (`profile_id`,`sort`) 
    1867 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1868  
    1869  
    1870 -- 
    1871 -- Table structure for table `sys_profiles_match_mails` 
    1872 -- 
    1873  
    1874 CREATE TABLE `sys_profiles_match_mails` ( 
    1875   `profile_id` int(10) NOT NULL, 
    1876   `profiles_match` text NOT NULL, 
    1877   PRIMARY KEY (`profile_id`) 
    1878 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1879  
    1880  
    1881 -- -------------------------------------------------------- 
    1882  
    1883 -- 
    1884 -- Table structure for table `sys_profile_rating` 
    1885 -- 
    1886  
    1887 CREATE TABLE `sys_profile_rating` ( 
    1888   `pr_id` int(10) unsigned NOT NULL default '0', 
    1889   `pr_rating_count` int(11) NOT NULL default '0', 
    1890   `pr_rating_sum` int(11) NOT NULL default '0', 
    1891   UNIQUE KEY `med_id` (`pr_id`) 
    1892 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1893  
    1894 -- 
    1895 -- Dumping data for table `sys_profile_rating` 
    1896 -- 
    1897  
    1898  
    1899 -- -------------------------------------------------------- 
    1900  
    1901 -- 
    1902 -- Table structure for table `sys_profile_voting_track` 
    1903 -- 
    1904  
    1905 CREATE TABLE `sys_profile_voting_track` ( 
    1906   `pr_id` int(10) unsigned NOT NULL default '0', 
    1907   `pr_ip` varchar(20) default NULL, 
    1908   `pr_date` datetime default NULL, 
    1909   KEY `pr_ip` (`pr_ip`,`pr_id`) 
    1910 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1911  
    1912 -- 
    1913 -- Dumping data for table `sys_profile_voting_track` 
    1914 -- 
    1915  
    1916 -- RAY AS IT WAS INTEGRATED 
    1917  
    1918 -- -------------------------------------------------------- 
    1919  
    1920 -- 
    1921 -- Table structure for table `RayBoardBoards` 
    1922 -- 
    1923  
    1924 CREATE TABLE IF NOT EXISTS `RayBoardCurrentUsers` ( 
    1925   `ID` varchar(20) NOT NULL default '', 
    1926   `Nick` varchar(36) NOT NULL, 
    1927   `Sex` enum('M','F') NOT NULL default 'M', 
    1928   `Age` int(11) NOT NULL default '0', 
    1929   `Photo` varchar(255) NOT NULL default '', 
    1930   `Profile` varchar(255) NOT NULL default '', 
    1931   `When` int(11) NOT NULL default '0', 
    1932   `Status` enum('new','old','idle') NOT NULL default 'new', 
    1933   PRIMARY KEY  (`ID`) 
    1934 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1935  
    1936 CREATE TABLE IF NOT EXISTS `RayBoardBoards` ( 
    1937   `ID` int(11) NOT NULL auto_increment,   
    1938   `Name` varchar(255) NOT NULL default '', 
    1939   `Password` varchar(255) NOT NULL default '', 
    1940   `OwnerID` varchar(20) NOT NULL default '0',  
    1941   `When` int(11) default NULL, 
    1942   `Status` enum('new', 'normal','delete') NOT NULL default 'new', 
    1943   PRIMARY KEY  (`ID`) 
    1944 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1945  
    1946 CREATE TABLE IF NOT EXISTS `RayBoardUsers` ( 
    1947   `ID` int(11) NOT NULL auto_increment,   
    1948   `Board` int(11) NOT NULL default '0', 
    1949   `User` varchar(20) NOT NULL default '', 
    1950   `When` int(11) default NULL, 
    1951   `Status` enum('normal','delete') NOT NULL default 'normal', 
    1952    PRIMARY KEY  (`ID`) 
    1953 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1954  
    1955 -- -------------------------------------------------------- 
    1956  
    1957 -- 
    1958 -- Table structure for table `RayChatCurrentUsers` 
    1959 -- 
    1960  
    1961 CREATE TABLE `RayChatCurrentUsers` ( 
    1962   `ID` varchar(20) NOT NULL default '', 
    1963   `Nick` varchar(36) NOT NULL default '', 
    1964   `Sex` enum('M','F') NOT NULL default 'M', 
    1965   `Age` int(11) NOT NULL default '0', 
    1966   `Desc` text NOT NULL, 
    1967   `Photo` varchar(255) NOT NULL default '', 
    1968   `Profile` varchar(255) NOT NULL default '', 
    1969   `Online` varchar(10) NOT NULL default 'online', 
    1970   `Start` int(11) NOT NULL default '0', 
    1971   `When` int(11) NOT NULL default '0', 
    1972   `Status` enum('new','old','idle','kick','type','online') NOT NULL default 'new', 
    1973   PRIMARY KEY  (`ID`) 
    1974 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1975  
    1976 -- 
    1977 -- Dumping data for table `RayChatCurrentUsers` 
    1978 -- 
    1979  
    1980  
    1981 -- -------------------------------------------------------- 
    1982  
    1983 -- 
    1984 -- Table structure for table `RayChatMessages` 
    1985 -- 
    1986  
    1987 CREATE TABLE `RayChatMessages` ( 
    1988   `ID` int(11) NOT NULL auto_increment, 
    1989   `Room` int(11) NOT NULL default '0', 
    1990   `Sender` varchar(20) NOT NULL default '', 
    1991   `Recipient` varchar(20) NOT NULL default '', 
    1992   `Whisper` enum('true','false') NOT NULL default 'false', 
    1993   `Message` text NOT NULL, 
    1994   `Style` text NOT NULL, 
    1995   `Type` varchar(10) NOT NULL default 'text', 
    1996   `When` int(11) NOT NULL default '0', 
    1997   PRIMARY KEY  (`ID`) 
    1998 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1999  
    2000 -- 
    2001 -- Dumping data for table `RayChatMessages` 
    2002 -- 
    2003  
    2004  
    2005 -- -------------------------------------------------------- 
    2006  
    2007 -- 
    2008 -- Table structure for table `RayChatProfiles` 
    2009 -- 
    2010  
    2011 CREATE TABLE `RayChatProfiles` ( 
    2012   `ID` varchar(20) NOT NULL default '0', 
    2013   `Banned` enum('true','false') NOT NULL default 'false', 
    2014   `Type` varchar(10) NOT NULL default 'full', 
    2015   `Smileset` varchar(255) NOT NULL default '', 
    2016   PRIMARY KEY  (`ID`) 
    2017 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2018  
    2019 -- 
    2020 -- Dumping data for table `RayChatProfiles` 
    2021 -- 
    2022  
    2023  
    2024 -- -------------------------------------------------------- 
    2025  
    2026 -- 
    2027 -- Table structure for table `RayChatRooms` 
    2028 -- 
    2029  
    2030 CREATE TABLE `RayChatRooms` ( 
    2031   `ID` int(11) NOT NULL auto_increment, 
    2032   `Name` varchar(255) NOT NULL default '', 
    2033   `Password` varchar(255) NOT NULL default '', 
    2034   `Desc` text NOT NULL, 
    2035   `OwnerID` varchar(20) NOT NULL default '0', 
    2036   `When` int(11) default NULL, 
    2037   `Status` enum('normal','delete') NOT NULL default 'normal', 
    2038   PRIMARY KEY  (`ID`), 
    2039   UNIQUE KEY `Name` (`Name`) 
    2040 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    2041  
    2042 -- 
    2043 -- Dumping data for table `RayChatRooms` 
    2044 -- 
    2045  
    2046 INSERT INTO `RayChatRooms` VALUES(1, 'Lobby', '', 'Welcome to our chat! You are in the "Lobby" now, but you can pass into any other public room you wish to - take a look at the "All rooms" box.', '0', 0, 'normal'); 
    2047 INSERT INTO `RayChatRooms` VALUES(2, 'Friends', '', 'Welcome to the "Friends" room! This is a public room where you can have a fun chat with existing friends or make new ones! Enjoy!', '0', 1, 'normal'); 
    2048  
    2049 -- -------------------------------------------------------- 
    2050  
    2051 -- 
    2052 -- Table structure for table `RayChatRoomsUsers` 
    2053 -- 
    2054  
    2055 CREATE TABLE `RayChatRoomsUsers` ( 
    2056   `ID` int(11) NOT NULL auto_increment, 
    2057   `Room` int(11) NOT NULL default '0', 
    2058   `User` varchar(20) NOT NULL default '', 
    2059   `When` int(11) default NULL, 
    2060   `Status` enum('normal','delete') NOT NULL default 'normal', 
    2061   PRIMARY KEY  (`ID`) 
    2062 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2063  
    2064 -- 
    2065 -- Dumping data for table `RayChatRoomsUsers` 
    2066 -- 
    2067  
    2068 CREATE TABLE IF NOT EXISTS `RayChatMembershipsSettings` ( 
    2069   `ID` int(11) NOT NULL auto_increment, 
    2070   `Name` varchar(20) NOT NULL default '' UNIQUE, 
    2071   `Caption` varchar(255) NOT NULL default '', 
    2072   `Type` enum('boolean','number','custom') NOT NULL default 'boolean', 
    2073   `Default` varchar(255) NOT NULL default '', 
    2074   `Range` int(3) NOT NULL default '3', 
    2075   `Error` varchar(255) NOT NULL default '', 
    2076   PRIMARY KEY  (`ID`) 
    2077 ); 
    2078 TRUNCATE TABLE `RayChatMembershipsSettings`; 
    2079  
    2080 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('RoomCreate', 'New Rooms Creating:', 'boolean', 'true', '1', 'RayzRoomCreate'); 
    2081 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('PrivateRoomCreate', 'Private Rooms Creating:', 'boolean', 'true', '1', 'RayzPrivateRoomCreate'); 
    2082 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('AVCasting', 'Audio/Video Casting:', 'boolean', 'true', '1', 'RayzAVCasting'); 
    2083 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('AVPlaying', 'Audio/Video Playing (for Messenger):', 'boolean', 'true', '1', 'RayzAVPlaying'); 
    2084 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('AVLargeWindow', 'Enable Large Video Window:', 'boolean', 'true', '1', 'RayzAVLargeWindow'); 
    2085 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('FileSend', 'Files Sending:', 'boolean', 'true', '1', 'RayzFileSend'); 
    2086 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('WhisperMessages', 'Whispering Messages:', 'boolean', 'true', '1', 'RayzWhisperMessages'); 
    2087 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('DirectMessages', 'Addressed Messages:', 'boolean', 'true', '1', 'RayzDirectMessages'); 
    2088 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('RoomsNumber', 'Maximum Rooms Number:', 'number', '100', '3', 'RayzRoomsNumber'); 
    2089 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('ChatsNumber', 'Maximum Private Chats Number:', 'number', '100', '3', 'RayzChatsNumber'); 
    2090 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('AVWindowsNumber', 'Maximum Video Windows Number:', 'number', '100', '3', 'RayzAVWindowsNumber'); 
    2091 INSERT INTO `RayChatMembershipsSettings`(`Name`, `Caption`, `Type`, `Default`, `Range`, `Error`) VALUES('RestrictedRooms', 'Restricted Rooms:', 'custom', '', '1', 'RayzRestrictedRooms'); 
    2092  
    2093 CREATE TABLE IF NOT EXISTS `RayChatMemberships` ( 
    2094   `ID` int(11) NOT NULL auto_increment, 
    2095   `Setting` int(11) NOT NULL default '0', 
    2096   `Value` varchar(255) NOT NULL default '', 
    2097   `Membership` int(11) NOT NULL default '0', 
    2098   PRIMARY KEY  (`ID`) 
    2099 ); 
    2100 TRUNCATE TABLE `RayChatMemberships`; 
    2101  
    2102  
    2103 -- -------------------------------------------------------- 
    2104  
    2105 -- 
    2106 -- Table structure for table `RayImContacts` 
    2107 -- 
    2108  
    2109 CREATE TABLE `RayImContacts` ( 
    2110   `ID` int(11) NOT NULL auto_increment, 
    2111   `SenderID` int(11) NOT NULL default '0', 
    2112   `RecipientID` int(11) NOT NULL default '0', 
    2113   `Online` varchar(10) NOT NULL default 'online', 
    2114   `When` int(11) NOT NULL default '0', 
    2115   PRIMARY KEY  (`ID`) 
    2116 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2117  
    2118 -- 
    2119 -- Dumping data for table `RayImContacts` 
    2120 -- 
    2121  
    2122  
    2123 -- -------------------------------------------------------- 
    2124  
    2125 -- 
    2126 -- Table structure for table `RayImMessages` 
    2127 -- 
    2128  
    2129 CREATE TABLE `RayImMessages` ( 
    2130   `ID` int(11) NOT NULL auto_increment, 
    2131   `ContactID` int(11) NOT NULL default '0', 
    2132   `Message` text NOT NULL, 
    2133   `Style` text NOT NULL, 
    2134   `Type` varchar(10) NOT NULL default 'text', 
    2135   `When` int(11) NOT NULL default '0', 
    2136   PRIMARY KEY  (`ID`) 
    2137 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2138  
    2139 -- 
    2140 -- Dumping data for table `RayImMessages` 
    2141 -- 
    2142  
    2143  
    2144 -- -------------------------------------------------------- 
    2145  
    2146 -- 
    2147 -- Table structure for table `RayImPendings` 
    2148 -- 
    2149  
    2150 CREATE TABLE `RayImPendings` ( 
    2151   `ID` int(11) NOT NULL auto_increment, 
    2152   `SenderID` int(11) NOT NULL default '0', 
    2153   `RecipientID` int(11) NOT NULL default '0', 
    2154   `Message` varchar(255) NOT NULL default '', 
    2155   `When` int(11) NOT NULL default '0', 
    2156   PRIMARY KEY  (`ID`), 
    2157   KEY `RecipientID` (`RecipientID`) 
    2158 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2159  
    2160 -- 
    2161 -- Dumping data for table `RayImPendings` 
    2162 -- 
    2163  
    2164  
    2165 -- -------------------------------------------------------- 
    2166  
    2167 -- 
    2168 -- Table structure for table `RayImProfiles` 
    2169 -- 
    2170  
    2171 CREATE TABLE `RayImProfiles` ( 
    2172   `ID` int(11) NOT NULL default '0', 
    2173   `Smileset` varchar(255) NOT NULL default '', 
    2174   PRIMARY KEY  (`ID`) 
    2175 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2176  
    2177 -- 
    2178 -- Dumping data for table `RayImProfiles` 
    2179 -- 
    2180  
    2181 -- -------------------------------------------------------- 
    2182  
    2183 -- 
    2184 -- Table structure for table `RayMp3Files` 
    2185 -- 
    2186  
    2187 CREATE TABLE `RayMp3Files` ( 
    2188   `ID` int(11) NOT NULL auto_increment, 
    2189   `Categories` text NOT NULL, 
    2190   `Title` varchar(255) NOT NULL default '', 
    2191   `Uri` varchar(255) NOT NULL default '', 
    2192   `Tags` text NOT NULL, 
    2193   `Description` text NOT NULL, 
    2194   `Time` int(11) NOT NULL default '0', 
    2195   `Date` int(20) NOT NULL default '0', 
    2196   `Reports` int(11) NOT NULL default '0', 
    2197   `Owner` varchar(64) NOT NULL default '', 
    2198   `Listens` int(12) default '0', 
    2199   `Rate` float NOT NULL, 
    2200   `RateCount` int(11) NOT NULL, 
    2201   `CommentsCount` int(11) NOT NULL, 
    2202   `Featured` tinyint(4) NOT NULL, 
    2203   `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL default 'pending', 
    2204   PRIMARY KEY  (`ID`), 
    2205   KEY (`Owner`) 
    2206 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2207  
    2208 -- 
    2209 -- Dumping data for table `RayMp3Files` 
    2210 -- 
    2211  
    2212 -- -------------------------------------------------------- 
    2213  
    2214 -- 
    2215 -- Table structure for table `RayMp3Tokens` 
    2216 -- 
    2217  
    2218 CREATE TABLE `RayMp3Tokens` ( 
    2219   `ID` int(11) NOT NULL default '0', 
    2220   `Token` varchar(32) NOT NULL default '', 
    2221   `Date` int(20) NOT NULL default '0', 
    2222   PRIMARY KEY `TokenId` (`ID`,`Token`) 
    2223 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2224  
    2225 -- 
    2226 -- Dumping data for table `RayMp3Tokens` 
    2227 -- 
    2228  
    2229 -- -------------------------------------------------------- 
    2230  
    2231 -- 
    2232 -- Table structure for table `RayShoutboxMessages` 
    2233 -- 
    2234  
    2235 CREATE TABLE `RayShoutboxMessages` ( 
    2236   `ID` int(11) NOT NULL auto_increment, 
    2237   `UserID` varchar(20) NOT NULL default '0', 
    2238   `Msg` text NOT NULL, 
    2239   `When` int(11) NOT NULL default '0', 
    2240   PRIMARY KEY  (`ID`) 
    2241 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2242  
    2243 -- 
    2244 -- Dumping data for table `RayShoutboxMessages` 
    2245 -- 
    2246  
    2247 -- -------------------------------------------------------- 
    2248  
    2249 -- 
    2250 -- Table structure for table `RayVideoFiles` 
    2251 -- 
    2252  
    2253 CREATE TABLE `RayVideoFiles` ( 
    2254   `ID` int(11) NOT NULL auto_increment, 
    2255   `Categories` text NOT NULL, 
    2256   `Title` varchar(255) NOT NULL default '', 
    2257   `Uri` varchar(255) NOT NULL default '', 
    2258   `Tags` text NOT NULL, 
    2259   `Description` text NOT NULL, 
    2260   `Time` int(11) NOT NULL default '0', 
    2261   `Date` int(20) NOT NULL default '0', 
    2262   `Owner` varchar(64) NOT NULL default '', 
    2263   `Views` int(12) default '0', 
    2264   `Rate` float NOT NULL, 
    2265   `RateCount` int(11) NOT NULL, 
    2266   `CommentsCount` int(11) NOT NULL, 
    2267   `Featured` tinyint(4) NOT NULL, 
    2268   `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL default 'pending', 
    2269   `Source` varchar(20) NOT NULL default '', 
    2270   `Video` varchar(32) NOT NULL default '', 
    2271   PRIMARY KEY  (`ID`), 
    2272   KEY (`Owner`) 
    2273 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    2274  
    2275 -- 
    2276 -- Dumping data for table `RayVideoFiles` 
    2277 -- 
    2278  
    2279 -- -------------------------------------------------------- 
    2280  
    2281 -- 
    2282 -- Table structure for table `RayVideoFiles` 
    2283 -- 
    2284  
    2285 CREATE TABLE `RayVideoTokens` ( 
    2286   `ID` int(11) NOT NULL default '0', 
    2287   `Token` varchar(32) NOT NULL default '', 
    2288   `Date` int(20) NOT NULL default '0', 
    2289   PRIMARY KEY `TokenId` (`ID`,`Token`) 
    2290 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2291  
    2292 -- 
    2293 -- Dumping data for table `RayVideoFiles` 
    2294 -- 
    2295  
    2296 -- -------------------------------------------------------- 
    2297  
    2298 -- 
    2299 -- Table structure for table `RayVideo_commentsFiles` 
    2300 -- 
    2301  
    2302 CREATE TABLE `RayVideo_commentsFiles` ( 
    2303   `ID` int(11) NOT NULL auto_increment, 
    2304   `Categories` text NOT NULL, 
    2305   `Title` varchar(255) NOT NULL default '', 
    2306   `Uri` varchar(255) NOT NULL default '', 
    2307   `Tags` text NOT NULL, 
    2308   `Description` text NOT NULL, 
    2309   `Time` int(11) NOT NULL default '0', 
    2310   `Date` int(20) NOT NULL default '0', 
    2311   `Owner` varchar(64) NOT NULL default '', 
    2312   `Views` int(12) default '0', 
    2313   `Status` enum('approved','disapproved','pending','processing','failed') NOT NULL default 'pending', 
    2314   PRIMARY KEY  (`ID`), 
    2315   KEY (`Owner`) 
    2316 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    2317  
    2318 -- -------------------------------------------------------- 
    2319  
    2320 -- 
    2321 -- Table structure for table `RayVideo_commentsTokens` 
    2322 -- 
    2323  
    2324 CREATE TABLE `RayVideo_commentsTokens` ( 
    2325   `ID` int(11) NOT NULL default '0', 
    2326   `Token` varchar(32) NOT NULL default '', 
    2327   `Date` int(20) NOT NULL default '0', 
    2328   PRIMARY KEY `TokenId` (`ID`,`Token`) 
    2329 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2330  
    2331 -- -------------------------------------------------------- 
    2332 -- RAY AS IT WAS INTEGRATED [END] 
    2333 -- -------------------------------------------------------- 
    2334  
    2335672-- 
    2336673-- Table structure for table `sys_stat_site` 
    … …  
    2365702) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ; 
    2366703 
    2367  
    2368 -- -------------------------------------------------------- 
    2369  
    2370 -- 
    2371 -- Table structure for table 'sys_shared_sites' 
    2372 -- 
    2373  
    2374 CREATE TABLE `sys_shared_sites` ( 
    2375   `ID` tinyint(4) unsigned NOT NULL auto_increment, 
    2376   `Name` varchar(255) default NULL, 
    2377   `URL` varchar(255) NOT NULL default '', 
    2378   `Icon` varchar(255) NOT NULL default '', 
    2379   PRIMARY KEY  (`ID`) 
    2380 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    2381  
    2382 INSERT INTO `sys_shared_sites` VALUES(NULL, 'digg', 'http://digg.com/submit?phase=2&url=', 'digg.png'); 
    2383 INSERT INTO `sys_shared_sites` VALUES(NULL, 'delicious', 'http://del.icio.us/post?url=', 'delicious.png'); 
    2384 INSERT INTO `sys_shared_sites` VALUES(NULL, 'blinklist', 'http://www.blinklist.com/index.php?Action=Blink/addblink.php&amp;Url=', 'blinklist.png'); 
    2385 INSERT INTO `sys_shared_sites` VALUES(NULL, 'newsvine', 'http://www.newsvine.com/_tools/seed&save?u=', 'newsvine.png'); 
    2386 INSERT INTO `sys_shared_sites` VALUES(NULL, 'reddit', 'http://reddit.com/submit?url=', 'reddit.png'); 
    2387 INSERT INTO `sys_shared_sites` VALUES(NULL, 'slashdot', 'http://slashdot.org/bookmark.pl?url=', 'slashdot.png'); 
    2388 INSERT INTO `sys_shared_sites` VALUES(NULL, 'stumbleupon', 'http://www.stumbleupon.com/url/http', 'stumbleupon.png'); 
    2389 INSERT INTO `sys_shared_sites` VALUES(NULL, 'technorati', 'http://technorati.com/faves?add=', 'technorati.png'); 
    2390  
    2391 -- 
    2392 -- Dumping data for table 'sys_shared_sites' 
    2393 -- 
    2394704 
    2395705-- -------------------------------------------------------- 
    … …  
    2451761  KEY `gtwTransactionID` (`gtwTransactionID`) 
    2452762) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2453  
    2454 -- 
    2455 -- Dumping data for table `sys_transactions` 
    2456 -- 
    2457  
    2458  
    2459 -- -------------------------------------------------------- 
    2460  
    2461 -- 
    2462 -- Table structure for table `sys_objects_actions` 
    2463 -- 
    2464  
    2465 CREATE TABLE `sys_objects_actions` ( 
    2466   `ID` int(10) unsigned NOT NULL auto_increment, 
    2467   `Caption` varchar(100) NOT NULL, 
    2468   `Icon` varchar(100) NOT NULL, 
    2469   `Url` varchar(250) NOT NULL, 
    2470   `Script` varchar(250) NOT NULL, 
    2471   `Eval` text NOT NULL, 
    2472   `Order` int(5) NOT NULL, 
    2473   `Type` varchar(20) NOT NULL, 
    2474   `bDisplayInSubMenuHeader` tinyint(1) NOT NULL default '0', 
    2475   PRIMARY KEY  (`ID`) 
    2476 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    2477  
    2478 -- 
    2479 -- Dumping data for table `sys_objects_actions` 
    2480 -- 
    2481  
    2482 INSERT INTO `sys_objects_actions` (`ID`, `Caption`, `Icon`, `Url`, `Script`, `Eval`, `Order`, `Type`, `bDisplayInSubMenuHeader`) VALUES 
    2483 (1, '{evalResult}', 'edit.png', 'pedit.php?ID={ID}', '', 'if ({ID} != {member_id}) return;\r\nreturn _t(''{cpt_edit}'');', 1, 'Profile', 0), 
    2484 (2, '{evalResult}', 'action_send.png', 'mail.php?mode=compose&recipient_id={ID}', '', 'if ({ID} == {member_id}) return;\r\nreturn _t(''{cpt_send_letter}'');', 2, 'Profile', 0), 
    2485 (3, '{cpt_fave}', 'action_fave.png', '', '{evalResult}', 'if ({ID} == {member_id}) return;\r\n\r\nreturn "$.post(''list_pop.php?action=hot'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 3, 'Profile', 0), 
    2486 (4, '{cpt_befriend}', 'action_friends.png', '', '{evalResult}', 'if ({ID} == {member_id} OR is_friends({ID} , {member_id})) return;\r\n\r\nreturn "$.post(''list_pop.php?action=friend'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 4, 'Profile', 0), 
    2487 (5, '{cpt_greet}', 'action_greet.png', '', '{evalResult}', 'if ({ID} == {member_id}) return;\r\n\r\nreturn "$.post(''greet.php'', { sendto: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 5, 'Profile', 0), 
    2488 (6, '{cpt_get_mail}', 'action_email.png', '', '{evalResult}', 'if ({ID} == {member_id}) return;\r\n\r\n$bAnonymousMode  = ''{anonym_mode}'';\r\n\r\nif ( !$bAnonymousMode ) {\r\n    return "$.post(''freemail.php'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n}\r\n', 6, 'Profile', 0), 
    2489 (7, '{cpt_share}', 'action_share.png', '', 'return launchTellFriendProfile({ID});', '', 7, 'Profile', 0), 
    2490 (8, '{cpt_report}', 'action_report.png', '', '{evalResult}', 'if ({ID} == {member_id}) return;\r\n\r\nreturn  "$.post(''list_pop.php?action=spam'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 8, 'Profile', 0), 
    2491 (9, '{cpt_block}', 'action_block.png', '', '{evalResult}', 'if ( {ID} == {member_id} || isBlocked({member_id}, {ID}) ) return;\r\n\r\nreturn  "$.post(''list_pop.php?action=block'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 9, 'Profile', 0), 
    2492 (10, '{sbs_profile_title}', 'action_subscribe.png', '', '{sbs_profile_script}', '', 10, 'Profile', 0), 
    2493 (11, '{cpt_remove_friend}', 'action_friends.png', '', '{evalResult}', 'if ({ID} == {member_id} OR !is_friends({ID} , {member_id}) ) return;\r\n\r\nreturn "$.post(''list_pop.php?action=remove_friend'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 4, 'Profile', 0), 
    2494 (12, '{cpt_unblock}', 'action_block.png', '', '{evalResult}', 'if ({ID} == {member_id} || !isBlocked({member_id}, {ID}) ) return;\r\n\r\nreturn "$.post(''list_pop.php?action=unblock'', { ID: ''{ID}'' }, function(sData){ $(''#ajaxy_popup_result_div_{ID}'').html(sData) } );return false;";\r\n', 9, 'Profile', 0); 
    2495  
    2496 -- -------------------------------------------------------- 
    2497  
    2498 -- 
    2499 -- Table structure for table `sys_greetings` 
    2500 -- 
    2501  
    2502 CREATE TABLE `sys_greetings` ( 
    2503   `ID` int(10) unsigned NOT NULL default '0', 
    2504   `Profile` int(10) unsigned NOT NULL default '0', 
    2505   `Number` smallint(5) unsigned NOT NULL default '0', 
    2506   `When` date NOT NULL default '0000-00-00', 
    2507   `New` enum('0','1') NOT NULL default '1', 
    2508   PRIMARY KEY  (`ID`,`Profile`) 
    2509 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2510  
    2511 -- 
    2512 -- Dumping data for table `sys_greetings` 
    2513 -- 
    2514763 
    2515764-- -------------------------------------------------------- 
    … …  
    2542791 
    2543792-- ------------------------------------------------------- 
    2544  
    2545 ALTER TABLE `RayMp3Files` ADD FULLTEXT KEY `ftMain` (`Title`, `Tags`, `Description`, `Categories`); 
    2546 ALTER TABLE `RayMp3Files` ADD FULLTEXT KEY `ftTags` (`Tags`); 
    2547 ALTER TABLE `RayMp3Files` ADD FULLTEXT KEY `ftCategories` (`Categories`); 
    2548  
    2549 ALTER TABLE `RayVideoFiles` ADD FULLTEXT KEY `ftMain` (`Title`, `Tags`, `Description`, `Categories`); 
    2550 ALTER TABLE `RayVideoFiles` ADD FULLTEXT KEY `ftTags` (`Tags`); 
    2551 ALTER TABLE `RayVideoFiles` ADD FULLTEXT KEY `ftCategories` (`Categories`); 
    2552793 
    2553794-- 
    … …  
    27771018('3', '0', '0', '', '', '', 'return true;', 0), 
    27781019('4', '0', '0', '', '', '', 'return isMember();', 0), 
    2779 ('5', '0', '0', '', 'communicator.php?communicator_mode=friends_list', '', '$aIds = $arg0->fromMemory($arg0->_sGroupFriendsCache . $arg1, "getColumn", "SELECT `p`.`ID` AS `id` FROM `Profiles` AS `p` LEFT JOIN `sys_friend_list` AS `f1` ON (`f1`.`ID`=`p`.`ID` AND `f1`.`Profile`=\'" . $arg1 . "\' AND `f1`.`Check`=1) LEFT JOIN `sys_friend_list` AS `f2` ON (`f2`.`Profile`=p.`ID` AND `f2`.`ID`=\'" . $arg1 . "\' AND `f2`.`Check`=1) WHERE 1 AND (`f1`.`ID` IS NOT NULL OR `f2`.`ID` IS NOT NULL)"); return in_array($arg2, $aIds);', 0), 
    2780 ('6', '0', '0', '', 'communicator.php?&communicator_mode=hotlist_requests', '', '$aIds = $arg0->fromMemory($arg0->_sGroupFavesCache . $arg1, "getColumn", "SELECT `Profile` AS `id` FROM `sys_fave_list` WHERE `ID`=\'" . $arg1 . "\'"); return in_array($arg2, $aIds);', 0), 
    2781 ('7', '0', '0', '', 'mail.php?&mode=inbox&contacts_mode=Contacted', '', '$aIds = $arg0->fromMemory($arg0->_sGroupContactsCache . $arg1, "getColumn", "SELECT `tp`.`ID` AS `id` FROM `sys_messages` AS `tm` INNER JOIN `Profiles` AS `tp` ON (`tm`.`Sender`=`tp`.`ID` AND `tm`.`Recipient`=\'" . $arg1 . "\') OR (`tm`.`Recipient`=`tp`.`ID` AND `tm`.`Sender`=\'" . $arg1 . "\')"); return in_array($arg2, $aIds);', 0); 
     1020('5', '0', '0', '', 'communicator.php?communicator_mode=friends_list', '', '$aIds = $arg0->fromMemory($arg0->_sGroupFriendsCache . $arg1, "getColumn", "SELECT `p`.`ID` AS `id` FROM `Profiles` AS `p` LEFT JOIN `sys_friend_list` AS `f1` ON (`f1`.`ID`=`p`.`ID` AND `f1`.`Profile`=\'" . $arg1 . "\' AND `f1`.`Check`=1) LEFT JOIN `sys_friend_list` AS `f2` ON (`f2`.`Profile`=p.`ID` AND `f2`.`ID`=\'" . $arg1 . "\' AND `f2`.`Check`=1) WHERE 1 AND (`f1`.`ID` IS NOT NULL OR `f2`.`ID` IS NOT NULL)"); return in_array($arg2, $aIds);', 0); 
    27821021 
    27831022-- 
    … …  
    28201059  PRIMARY KEY  (`owner_id`, `action_id`) 
    28211060) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    2822  
    2823 -- 
    2824 -- Table structure for table `sys_sbs_users` 
    2825 -- 
    2826 CREATE TABLE `sys_sbs_users` ( 
    2827   `id` int(11) NOT NULL auto_increment, 
    2828   `name` varchar(64) NOT NULL default '', 
    2829   `email` varchar(64) NOT NULL default '', 
    2830   `date` int(11) unsigned NOT NULL default '0', 
    2831   PRIMARY KEY (`id`), 
    2832   UNIQUE KEY `subscriber` (`name`, `email`) 
    2833 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    2834  
    2835 -- 
    2836 -- Table structure for table `sys_sbs_entries` 
    2837 -- 
    2838 CREATE TABLE `sys_sbs_entries` ( 
    2839   `id` int(11) NOT NULL auto_increment, 
    2840   `subscriber_id` int(11) NOT NULL default '0', 
    2841   `subscriber_type` tinyint(4) NOT NULL default '0', 
    2842   `subscription_id` int(11) NOT NULL default '0',   
    2843   `object_id` int(11) NOT NULL default '0',   
    2844   PRIMARY KEY (`id`), 
    2845   UNIQUE KEY `entry` (`subscriber_id`, `subscriber_type`, `subscription_id`, `object_id`) 
    2846 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    2847  
    2848 -- 
    2849 -- Table structure for table `sys_sbs_types` 
    2850 -- 
    2851 CREATE TABLE `sys_sbs_types` (   
    2852   `id` int(11) NOT NULL auto_increment, 
    2853   `unit` varchar(32) NOT NULL default '', 
    2854   `action` varchar(32) NOT NULL default '', 
    2855   `template` varchar(64) NOT NULL default '', 
    2856   `params` text NOT NULL default '', 
    2857   PRIMARY KEY (`id`), 
    2858   UNIQUE KEY `subscription` (`unit`, `action`, `template`) 
    2859 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    2860  
    2861 -- 
    2862 -- Dumping data for table `sys_sbs_types` 
    2863 -- 
    2864 INSERT INTO `sys_sbs_types`(`unit`, `action`, `template`, `params`) VALUES 
    2865 ('system', 'mass_mailer', 't_AdminEmail', 'return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_mass_mailer''), ''ViewLink'' => BX_DOL_URL_ROOT));'), 
    2866 ('profile', '', '', '$aUser = getProfileInfo($arg3); return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_profile'', $aUser[''NickName'']), ''ViewLink'' => getProfileLink($arg3)));'), 
    2867 ('profile', 'commentPost', 't_sbsProfileComments', '$aUser = getProfileInfo($arg3); return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_profile_comments'', $aUser[''NickName'']), ''ViewLink'' => getProfileLink($arg3)));'), 
    2868 ('profile', 'rate', 't_sbsProfileRates', '$aUser = getProfileInfo($arg3); return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_profile_rates'', $aUser[''NickName'']), ''ViewLink'' => getProfileLink($arg3)));'), 
    2869 ('profile', 'edit', 't_sbsProfileEdit', '$aUser = getProfileInfo($arg3); return array(''template'' => array(''Subscription'' => _t(''_sbs_txt_sbs_profile_edit'', $aUser[''NickName'']), ''ViewLink'' => getProfileLink($arg3)));'); 
    2870  
    2871 -- 
    2872 -- Table structure for table `sys_sbs_queue` 
    2873 -- 
    2874 CREATE TABLE `sys_sbs_queue` ( 
    2875   `id` int(11) NOT NULL auto_increment, 
    2876   `email` varchar(64) NOT NULL default '', 
    2877   `subject` varchar(255) NOT NULL default '', 
    2878   `body` text NOT NULL default '', 
    2879   PRIMARY KEY (`id`) 
    2880 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    2881  
    2882 -- 
    2883 -- Table structure for table `sys_sbs_messages` 
    2884 -- 
    2885 CREATE TABLE `sys_sbs_messages` ( 
    2886   `id` int(10) unsigned NOT NULL auto_increment, 
    2887   `subject` varchar(128) NOT NULL default '',   
    2888   `body` mediumtext NOT NULL, 
    2889   PRIMARY KEY  (`ID`) 
    2890 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    2891  
    2892 -- 
    2893 -- Table structure for table `sys_box_download` 
    2894 -- 
    2895 CREATE TABLE IF NOT EXISTS `sys_box_download` ( 
    2896   `id` int(11) NOT NULL auto_increment, 
    2897   `title` varchar(64) NOT NULL, 
    2898   `url` varchar(255) NOT NULL, 
    2899   `onclick` varchar(255) NOT NULL, 
    2900   `desc` text NOT NULL, 
    2901   `icon` varchar(255) NOT NULL, 
    2902   `order` int(11) NOT NULL, 
    2903   `disabled` tinyint(4) NOT NULL, 
    2904   PRIMARY KEY  (`id`) 
    2905 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    2906  
    2907 INSERT INTO `sys_box_download` (`id`, `title`, `url`, `onclick`, `desc`, `icon`, `order`, `disabled`) VALUES 
    2908 (1, '_sbd_iPhone_title', 'http://www.boonex.com/products/mobile/iphone/', '', '_sbd_iPhone_desc', 'iphone.png', 2, 0), 
    2909 (2, '_sbd_Android_title', 'https://market.android.com/details?id=com.boonex.oo', '', '_sbd_Android_desc', 'android.png', 3, 0); 
    29101061 
    29111062 

  • trunk/modules/boonex/groups/classes/BxGroupsPrivacy.php

    r15211 r15934  
    2020***************************************************************************/ 
    2121 
    22 bx_import('BxDolPrivacy'); 
     22// TODO: 
    2323 
    24 class BxGroupsPrivacy extends BxDolPrivacy { 
     24class BxGroupsPrivacy extends BxDol { 
    2525 
    2626    var $oModule; 
    … …  
    3131    function BxGroupsPrivacy(&$oModule) { 
    3232        $this->oModule = $oModule; 
    33         parent::BxDolPrivacy($oModule->_oDb->getPrefix() . 'main', 'id', 'author_id'); 
     33        //parent::BxDolPrivacy($oModule->_oDb->getPrefix() . 'main', 'id', 'author_id'); 
    3434    } 
    3535 

  • trunk/samples/form_objects.php

    r15885 r15934  
    2424bx_import('BxDolLanguages'); 
    2525bx_import('BxDolForm'); 
     26bx_import('BxDolTemplate'); 
    2627 
    2728$oTemplate = BxDolTemplate::getInstance(); 
    … …  
    7475        // display add form 
    7576 
    76         $oForm = BxDolForm::getObjectInstance('sample_form_objects', 'sample_form_objects_add'); // get form instance for specified form object and display 
     77        $oForm = BxDolForm::getObjectInstance('sample2_form_objects', 'sample2_form_objects_add'); // get form instance for specified form object and display 
    7778        if (!$oForm) 
    7879            die('"sample_form_objects_add" form object or "sample_form_objects_add" display is not defined'); 

  • trunk/services.php

    r15201 r15934  
    77 
    88require_once('./inc/header.inc.php'); 
    9 require_once(BX_DIRECTORY_PATH_INC . "languages.inc.php"); 
    109require_once(BX_DIRECTORY_PATH_INC . "params.inc.php"); 
    1110require_once(BX_DIRECTORY_PATH_INC . "design.inc.php"); 
     11 
     12bx_import('BxDolLanguages'); 
     13bx_import('BxDolTemplate'); 
    1214 
    1315$oTemplate = BxDolTemplate::getInstance(); 
    … …  
    1517$oTemplate->setPageHeader (_t("_OUR_SERV")); 
    1618$oTemplate->setPageContent ('page_main_code', DesignBoxContent(_t("_OUR_SERV"), _t("_SERV_DESC"), BX_DB_PADDING_DEF)); 
    17  
    18 PageCode(); 
     19$oTemplate->getPageCode(); 

  • trunk/tags.php

    r15334 r15934  
    404404    $oTemplate->setPageNameIndex(25); 
    405405    $oTemplate->setPageParams(array( 
    406         'css_name' => 'tags.css', 
    407406        'header' => _t('_Tags'), 
    408407        'header_text' => _t('_Tags'), 

  • trunk/templates/base/scripts/BxBaseFunctions.php

    r15931 r15934  
    4242 
    4343        return $GLOBALS['bxDolClasses']['BxTemplFunctions']; 
    44     } 
    45  
    46     function getProfileMatch( $memberID, $profileID ) { 
    47         $match_n = getProfilesMatch($memberID, $profileID); // impl 
    48  
    49         bx_import('BxTemplConfig'); 
    50         return DesignProgressPos ( _t("_XX match", $match_n), BxTemplConfig::getInstance()->iProfileViewProgressBar, 100, $match_n );; 
    51     } 
    52  
    53     function getProfileZodiac( $profileDate ) { 
    54         return ShowZodiacSign( $profileDate ); 
    5544    } 
    5645 
    … …  
    224213    } 
    225214 
    226     /** 
    227     * @description : function will generate the sex icon ; 
    228     * @param         : $sSex (string) - sex name ; 
    229     * @return         : (text) - path to image ; 
    230     */ 
    231     function genSexIcon($sSex) { 
    232         switch( $sSex ) { 
    233             case 'male'    : 
    234                 return getTemplateIcon( 'male.png' ); 
    235             case 'female' : 
    236                 return getTemplateIcon( 'female.png' ); 
    237             case 'men'    : 
    238                 return getTemplateIcon( 'male.png' ); 
    239             default : 
    240                 return getTemplateIcon( 'tux.png' ); 
    241         } 
    242     } 
    243  
    244     function getSexPic($sSex, $sType = 'medium') { 
    245         $aGenders = array ( 
    246             'female' => 'woman_', 
    247             'Female' => 'woman_', 
    248             'male' => 'man_', 
    249             'Male' => 'man_', 
    250         ); 
    251         return getTemplateIcon(isset($aGenders[$sSex]) ? $aGenders[$sSex] . $sType . '.gif' : 'visitor_' . $sType . '.gif'); 
    252     } 
    253  
    254     function getMemberAvatar($iId, $sType = 'medium') { 
    255         $aProfile = getProfileInfo($iId); 
    256         if (!$aProfile || !@include_once (BX_DIRECTORY_PATH_MODULES . 'boonex/avatar/include.php')) 
    257             return false; 
    258         return $aProfile['Avatar'] ? BX_AVA_URL_USER_AVATARS . $aProfile['Avatar'] . ($sType == 'small' ? 'i' : '') . BX_AVA_EXT : $this->getSexPic($aProfile['Sex'], $sType); 
    259     } 
    260  
    261     function getMemberThumbnail($iId, $sFloat = 'none', $bGenProfLink = false, $sForceSex = 'visitor', $isAutoCouple = true, $sType = 'medium', $aOnline = array()) { 
    262  
    263         $aProfile = getProfileInfo($iId); 
    264         if (!$aProfile) 
    265             return ''; 
    266  
    267         $bCouple = ((int)$aProfile['Couple'] > 0) && $isAutoCouple ? true : false; 
    268  
    269         $bOnline = 0; 
    270  
    271         if (!@include_once (BX_DIRECTORY_PATH_MODULES . 'boonex/avatar/include.php')) 
    272             return ''; 
    273  
    274         $sLink = ''; 
    275         $sNick = ''; 
    276  
    277         bx_import('BxDolUserStatusView'); 
    278         $oUserStatusView = bx_instance('BxDolUserStatusView'); // TODO: need singlton here 
    279         $sStatusIcon = '';//$oUserStatusView->getStatusIcon($iId, 'icon8'); 
    280  
    281         if ($iId > 0) { 
    282             $sLink = getProfileLink($iId); 
    283             $sNick = getNickname($iId); 
    284             if (! empty($aOnline) && (int)$aOnline['is_online']==0) { 
    285             } else { 
    286  
    287                 $bOnline = 1; 
    288             } 
    289         } 
    290         if (!$bGenProfLink) { 
    291             if ($sForceSex != 'visitor') { 
    292                 $sNick = _t('_Vacant'); 
    293                 $sLink = 'javascript:void(0)'; 
    294             } 
    295         } 
    296  
    297         $w = $sType == 'medium' ? BX_AVA_W : BX_AVA_ICON_W; 
    298         $h = $sType == 'medium' ? BX_AVA_H : BX_AVA_ICON_H; 
    299  
    300         if ($bCouple) 
    301             $sType = 'small'; 
    302  
    303         $aVariables = array( 
    304             'iProfId' => $iId, 
    305             'sys_thb_float' => $sFloat, 
    306             'sys_thb_width' => $w + 6, 
    307             'sys_thb_height' => $h + 6, 
    308             'sys_img_width' => $w, 
    309             'sys_img_height' => $h, 
    310             'sys_img_width1' => $w + 4, 
    311             'sys_img_height1' => $h + 4, 
    312             'sys_cpl_img_width' => BX_AVA_ICON_W, 
    313             'sys_cpl_img_height' => BX_AVA_ICON_H, 
    314             'sys_status_url' => getTemplateIcon($sStatusIcon), 
    315             'sys_status_title' => $oUserStatusView->getStatus($iId), 
    316             'usr_profile_url' => $sLink, 
    317             'usr_thumb_url0' => $aProfile['Avatar'] ? BX_AVA_URL_USER_AVATARS . $aProfile['Avatar'] . ($sType == 'small' ? 'i' : '') . BX_AVA_EXT : $this->getSexPic($aProfile['Sex'], $sType), 
    318             'usr_thumb_title0' => $sNick, 
    319             'bx_if:profileLink' => array( 
    320               'condition' => $bGenProfLink, 
    321               'content' => array( 
    322                   'picWidth' => $w + 6, 
    323                   'nickName' => $sNick, 
    324                   'usr_profile_url' => $sLink 
    325               ) 
    326              ), 
    327             'sys_status_img_width'  => 12, 
    328             'sys_status_img_height' => 12, 
    329         ); 
    330  
    331         if ($bCouple) { 
    332             $aProfileCouple = getProfileInfo($aProfile['Couple']); 
    333             $sNickCouple = getNickname($aProfile['Couple']); 
    334             $aVariables['usr_thumb_url1'] = $aProfileCouple['Avatar'] ? BX_AVA_URL_USER_AVATARS . $aProfileCouple['Avatar'] . 'i' . BX_AVA_EXT : $this->getSexPic($aProfileCouple['Sex'], 'small'); 
    335             $aVariables['usr_thumb_title1'] = $sNickCouple; 
    336         } 
    337  
    338         return $this->_oTemplate->parseHtmlByName($bCouple ? "thumbnail_couple.html" : "thumbnail_single.html", $aVariables); 
    339     } 
    340  
    341     function getMemberIcon($iId, $sFloat = 'none', $bGenProfLink = false) { 
    342         return $this->getMemberThumbnail($iId, $sFloat, $bGenProfLink, 'visitor', false, 'small'); 
    343     } 
    344  
    345     /** 
    346      * Get image of the specified type by image id 
    347      * @param $aImageInfo image info array with the following info 
    348      *          $aImageInfo['Avatar'] - photo id, NOTE: it not relatyed to profiles avataras module at all 
    349      * @param $sImgType image type 
    350      */ 
    351     function _getImageShared($aImageInfo, $sType = 'thumb') { 
    352         return BxDolService::call('photos', 'get_image', array($aImageInfo, $sType), 'Search'); 
    353     } 
    354  
    355215    function getTemplateIcon($sName) {             
    356216        $sUrl = $this->_oTemplate->getIconUrl($sName); 

  • trunk/terms_of_use.php

    r15338 r15934  
    77 
    88require_once('./inc/header.inc.php'); 
    9 require_once(BX_DIRECTORY_PATH_INC . "languages.inc.php"); 
    109require_once(BX_DIRECTORY_PATH_INC . "params.inc.php"); 
    1110require_once(BX_DIRECTORY_PATH_INC . "design.inc.php"); 
     11 
     12bx_import('BxDolLanguages'); 
     13bx_import('BxDolTemplate'); 
    1214 
    1315$oTemplate = BxDolTemplate::getInstance(); 
    … …  
    1517$oTemplate->setPageHeader (_t("_TERMS_OF_USE_H")); 
    1618$oTemplate->setPageContent ('page_main_code', PageCompPageMainCode()); 
    17  
    18 PageCode(); 
     19$oTemplate->getPageCode(); 
    1920 
    2021/** 
Note: See TracChangeset for help on using the changeset viewer.
 
 

Site Search

Market

Notes

Websites

About BoonEx• Contacts• © BoonEx (ACN 127966581)