WordPress.org
Get WordPress

Plugin Directory

Changeset 1340667


Ignore:
Timestamp:
02/01/2016 03:10:55 PM (10 years ago)
Author:
theArab
Message:

Fix custom timeframes - last available appointment to display properly on admin list.
Add admin option to limit available services for individual timeframe -- if one services is selected, next client may not select same service for that time.

Location:
skedmaker-online-scheduling/trunk
Files:
4 edited

Legend:

Unmodified
Added
Removed

  • skedmaker-online-scheduling/trunk/_admin/_options.php

    r1332957 r1340667  
    11<?php
    22
     3
    34if ($_SERVER['REQUEST_METHOD']=='POST' && $_GET['v']=='options'){
    45
     6
    57    $errorMessage="";
    68
     9
    710    $keep_profile_open=$_POST['keep_profile_open'];
    811
     12
    913    $publicscheduleinput=$_POST['publicscheduleinput'];
    1014
     15
    1116    $allowsameday=$_POST['allowsameday'];
    1217
     18
    1319    $sitepublic=$_POST['sitepublic'];
    1420
     21
    1522    $setappointmentpadding=$_POST['appointmentpadding'];
    1623
     24
    1725    $protectInput=SM_e($_POST['protectInput']);
    1826
     27
    1928    $availableInput=SM_e($_POST['availableInput']);
    2029
     30
    2131    $unavailableInput=SM_e($_POST['unavailableInput']);
    2232
     33
    2334    $cancelpolicy=SM_e($_POST['cancelpolicy']);
    2435
     36
    2537    $calendarcaption=SM_e($_POST['calendarcaption']);
    2638
     39
    2740    $prefix_content=SM_e($_POST['prefix_content']);
    2841
    29 
     42    $limited_services=SM_e($_POST['limited_services']);
    3043
    3144    //======= SAVE IT
    32 
    3345    if($errorMessage==""){
    3446
    35         $saveIt=$wpdb->update("skedmaker_users", array("keep_profile_open"=>$keep_profile_open, "sitepublic"=>$sitepublic, "allowsameday"=>$allowsameday, "appointmentpadding"=>$setappointmentpadding, "publicschedule"=>$publicscheduleinput, "protect"=>$protectInput, "appointmentAvailable"=>$availableInput, "appointmentUnavailable"=>$unavailableInput, "cancelpolicy"=>$cancelpolicy, "calendarcaption"=>$calendarcaption, "prefix_content"=>$prefix_content), array("live"=>"y"));
     47
     48        $saveIt=$wpdb->update("skedmaker_users", array("keep_profile_open"=>$keep_profile_open, "sitepublic"=>$sitepublic, "allowsameday"=>$allowsameday, "appointmentpadding"=>$setappointmentpadding, "publicschedule"=>$publicscheduleinput, "protect"=>$protectInput, "appointmentAvailable"=>$availableInput, "appointmentUnavailable"=>$unavailableInput, "cancelpolicy"=>$cancelpolicy, "calendarcaption"=>$calendarcaption, "prefix_content"=>$prefix_content, "limited_services"=>$limited_services), array("live"=>"y"));
     49
    3650
    3751        if(!$saveIt){
    3852
     53
    3954            SM_redBox("Error saving, try again later.", 800, 21);
    4055
     56
    4157        }else{
    4258
     59
    4360            SM_greenBox("Saved Options!", 800, 21);
    4461
     62
    4563            SM_redirect($smadmin."&v=options&", 500);
    4664
     65
    4766            die();
    4867
     68
    4969        }
    5070
     71
    5172    }
    5273
     74
    5375}
    5476
     77
    5578SM_title("Booking Options", "btn_options32_reg.png", $smadmin."&amp;v=options&amp;");?>
    5679
    5780
    5881
     82
     83
    5984<form enctype="multipart/form-data" id="form1" name="form1" method="post" action="<?php echo $smadmin;?>&amp;v=options&amp;op=options&amp;" style="margin-top:0px">
    6085
     86
    6187<table class='cc800'><tr><td class='blueBanner1'>Extra Options to Personalize Your Schedule</td></tr>
    6288
     89
    6390<tr><td class='blueBanner2' style='padding:0px;'>
    6491
     92
    6593<?php SM_menu();?>
    6694
     95
    6796<br />
    6897
     98
    6999<table class='cc100' style='margin-left:14px;'>
    70100
    71101
    72102
     103
     104
    73105<tr><td class='pad7'><input name="sitepublic" type="checkbox" id="sitepublic" value="y" <?php if ($sitepublic=="y") {echo "checked='checked'"; }?>/></td>
    74106
     107
    75108<td class='pad7'><label for="sitepublic"><b>Make Appointments Public</b></label></td></tr>
    76109
     110
    77111<tr><td class='pad7'><a name='sameday'></a></td><td style='padding:0px 14px 14px 7px;'>
    78112
     113
    79114<span class='smallG'>Checking this box allows visitors to make appointments. Some people may prefer to enter the scheduling information themselves. If this is not checked, clients will be able to see when you have appointmetns available, but not be able to reserve them online.</span>
    80115
    81 </td></tr>
     116
     117</td></tr>
     118
     119
    82120
    83121
    … …  
    85123<tr><td class='pad7'><input name="allowsameday" type="checkbox" id="allowsameday" value="y" <?php if($allowsameday=="y") {?> checked='checked'<?php }?>/></td>
    86124
     125
    87126<td class='pad7'><label for="allowsameday"><b>Allow Same-Day Appointments</b></label></td></tr>
    88127
     128
    89129<tr><td class='pad7'>&nbsp;</td><td style='padding:0px 14px 14px 7px;'>
    90130
     131
    91132<span class='smallG'>If this is unchecked, clients will only be able to make appointments for upcoming days, not the present day.</span>
    92133
    93 </td></tr>
     134
     135</td></tr>
     136
     137
     138
    94139
    95140
    … …  
    99144<tr><td class='pad7'><input name="publicscheduleinput" type="checkbox" id="publicscheduleinput" value="y" <?php if($publicschedule=="y") {?> checked='checked'<?php }?>/></td>
    100145
     146
    101147<td class='pad7'><label for="publicscheduleinput"><b>Public Content</b></label></td></tr>
    102148
    103 <tr><td class='pad7'>&nbsp;</td>
    104 <td style='padding:0px 14px 14px 7px;'>
    105 
    106 <span class='smallG'>Check this box to show what has been entered into your schedule. This will make public all names submitted. This option is useful if you want to use your schedule as a public events calendar.</span>
    107 
    108 </td></tr>
     149
     150<tr><td class='pad7'>&nbsp;</td><td style='padding:0px 14px 14px 7px;'>
     151
     152
     153<span class='smallG'>Check this box to show what has been entered into your schedule. This will make public all names and messages submitted. This option is useful if you want to use your schedule as a public events calendar.</span>
     154
     155
     156</td></tr>
     157
     158
     159<tr><td class='pad7'><input name="limited_services" type="checkbox" id="limited_services" value="y" <?php if($limited_services=="y") {?> checked='checked'<?php }?>/></td>
     160
     161
     162<td class='pad7'><label for="limited_services"><b>Limit Available Services</b></label></td></tr>
     163
     164
     165<tr><td class='pad7'>&nbsp;</td><td style='padding:0px 14px 14px 7px;'>
     166
     167
     168<span class='smallG'>Check this box to allow only one service selection per time frame. Only applies to drop menu option.</span>
     169
     170
     171</td></tr>
     172
    109173
    110174</table>
    … …  
    114178
    115179
     180
     181
     182
    116183<table class='cc100' style='margin-left:14px;'>
    117184
    118 <tr><td class='pad14'>
     185
     186<tr><td class='pad14'>
     187
    119188
    120189<select name="appointmentpadding" id="appointmentpadding" class='form_select'>
    121190
     191
    122192<option value='0'<?php if($appointmentpadding=="0" || $appointmentpadding==""){ ?> print selected="selected" <?php }?>>0</option>
    123193
     194
    124195<option value='1'<?php if($appointmentpadding=="1"){ ?>print selected="selected" <?php }?>>1</option>
    125196
     197
    126198<option value='2'<?php if($appointmentpadding=="2"){ ?>print selected="selected" <?php }?>>2</option>
    127199
     200
    128201<option value='3'<?php if($appointmentpadding=="3"){ ?>print selected="selected" <?php }?>>3</option>
    129202
     203
    130204<option value='4'<?php if($appointmentpadding=="4"){ ?>print selected="selected" <?php }?>>4</option>
    131205
     206
    132207<option value='5'<?php if($appointmentpadding=="5"){ ?>print selected="selected" <?php }?>>5</option>
    133208
     209
    134210<option value='6'<?php if($appointmentpadding=="6"){ ?>print selected="selected" <?php }?>>6</option>
    135211
     212
    136213<option value='7'<?php if($appointmentpadding=="7"){ ?>print selected="selected" <?php }?>>7</option>
    137214
     215
    138216<option value='8'<?php if($appointmentpadding=="8"){ ?>print selected="selected" <?php }?>>8</option>
    139217
     218
    140219<option value='9'<?php if($appointmentpadding=="9"){ ?>print selected="selected" <?php }?>>9</option>
    141220
     221
    142222<option value='10'<?php if($appointmentpadding=="10"){ ?>print selected="selected" <?php }?>>10</option>
    143223
     224
    144225<option value='11'<?php if($appointmentpadding=="11"){ ?>print selected="selected" <?php }?>>11</option>
    145226
     227
    146228<option value='12'<?php if($appointmentpadding=="12"){ ?>print selected="selected" <?php }?>>12</option>
    147229
     230
    148231</select>
    149232
     233
    150234<b> Hours of Appointment Padding</b><br />
    151235
     236
    152237<span class='smallG'>Use this setting to stop cleints from setting an appointment too close to the present time. See also Same-Day Appointments above.</span>
    153238
    154 </td></tr>
    155 
    156 
    157 
    158 <tr><td class='pad14'>
     239
     240</td></tr>
     241
     242
     243
     244
     245
     246<tr><td class='pad14'>
     247
    159248
    160249<b>Password Protect</b><br />
    161250
     251
    162252<input name="protectInput" type="password" class="form_textfield" id="protectInput" value="<?php echo $protect; ?>" size="35" maxlength="50" /><br />
    163253
     254
    164255<span class='smallG'>If you would like to protect your schedule, so only those who know the password can see it, enter a password here. This is a different field than your account password and is used commonly for protecting employee work schedules or other non-public schedules.</span>
    165256
    166 </td></tr>
     257
     258</td></tr>
     259
     260
    167261
    168262
    … …  
    170264           
    171265
    172 <tr><td class='pad14'>
     266
     267<tr><td class='pad14'>
     268
    173269
    174270<b>Appointment Available</b><br />
    175271
     272
    176273<input name="availableInput" type="text" class="form_textfield" id="availableInput" value="<?php echo $appointmentAvailable; ?>" size="35" maxlength="100" /><br />
    177274
     275
    178276<span class='smallG'>Displayed when there is an appointment available.</span>
    179277
    180 </td></tr>
    181 
    182 
    183 
    184 <tr><td class='pad14'>
     278
     279</td></tr>
     280
     281
     282
     283
     284
     285<tr><td class='pad14'>
     286
    185287
    186288<b>Appointment Not Available</b><br />
    187289
     290
    188291<input name="unavailableInput" type="text" class="form_textfield" id="unavailableInput" value="<?php echo $appointmentUnavailable; ?>" size="35" maxlength="100" /><br />
    189292
     293
    190294<span class='smallG'>Displayed when an appointment time is taken and not available.</span>
    191295
    192 </td></tr>
    193 
    194 
    195 
    196 <tr><td class='pad14'>
     296
     297</td></tr>
     298
     299
     300
     301
     302
     303<tr><td class='pad14'>
     304
    197305
    198306<b>Calendar Content</b><br />
    199307
     308
    200309<span class='smallG'>This text will appear above your calendar. You can leave this blank if you don't want to include any text.</span>
    201310
     311
    202312<br />
    203313
     314
    204315<textarea name="prefix_content" id="prefix_content" cols="49" rows="7" class='form_area' style='width:725px;'><?php echo SM_dcontent($prefix_content); ?></textarea>
    205316
    206 </td></tr>
    207 
    208 
    209 
    210 
    211 
    212 <tr><td class='pad14'>
     317
     318</td></tr>
     319
     320
     321
     322
     323
     324
     325
     326
     327<tr><td class='pad14'>
     328
    213329
    214330<b>Cancellation Policy</b><br />
    215331
     332
    216333<span class='smallG'>If your business has a cancellation policy, enter it here and the message will be displayed when your client makes an appointment.</span>
    217334
     335
    218336<br />
    219337
     338
    220339<textarea name="cancelpolicy" id="cancelpolicy" cols="49" rows="7" class='form_area' style='width:725px;'><?php echo $cancelpolicy; ?></textarea>
    221340
    222 </td></tr>
     341
     342</td></tr>
     343
     344
    223345
    224346
    … …  
    226348<tr><td class='pad14'><input type="submit" name="button" id="button" value="Save Changes to Booking Options" /></td></tr>
    227349
     350
    228351</table>
    229352
    230353
    231354
     355
     356
    232357</td></tr></table>
    233358
     359
    234360</form>
    235361
     362
    236363<br />

  • skedmaker-online-scheduling/trunk/_include/_form_confirm.php

    r1332957 r1340667  
    11<?php
    2 
    3 
    4 
    52// $wpdb->show_errors();
    6 
    7 
    8 
    93if(wp_is_mobile()){
    104
    … …  
    15431537        $service_code=SM_d($row['code']);
    15441538
    1545 
    1546 
     1539    if($limited_services=="y"){
     1540        $total_services_taken=SM_total("SELECT * FROM skedmaker_sked WHERE startdate='$ts' AND services='$service_code' LIMIT 1");
     1541        if($total_services_taken>0){$block='y';}else{$block="";}
     1542    }
     1543
     1544    if($block!="y"){
    15471545        ?>
    15481546
    … …  
    15521550
    15531551
    1554 
    15551552    <?php } ?>
     1553    <?php } ?>
    15561554
    15571555

  • skedmaker-online-scheduling/trunk/_include/sm-build-db.php

    r1310087 r1340667  
    11<?php
    2 
    32global $wpdb;
    4 
    53// $wpdb->show_errors();
    6 
    74if(!function_exists('SM_check_db_varchar')){function SM_check_db_varchar($table, $col, $varchar_length){
    8 
    95    global $wpdb;
    10 
    116    foreach($wpdb->get_col("DESC "." $table ", 0 ) as $DB_col) {
    12 
    137        if($col==$DB_col){
    14 
    158            $pos==true;
    16 
    179        }
    18 
    1910    }
    20 
    2111    if($pos!=true){
    22 
    2312        $saveIt=$wpdb->query("ALTER TABLE $table ADD $col VARCHAR($varchar_length) NOT NULL;");
    24 
    2513        if($saveIt){
    26 
    2714            echo "<p style='color:#090; font-weight:bold; font-size:18px; '>Added column: ".$col." to table: ".$table."</p>";
    28 
    2915        }
    30 
    3116    }
    32 
    3317}}
    3418
    35 
    36 
    3719if(!function_exists('SM_check_db_text')){function SM_check_db_text($table, $col){
    38 
    3920    global $wpdb;
    40 
    4121    foreach($wpdb->get_col("DESC "." $table ", 0 ) as $DB_col) {
    42 
    4322        if($col==$DB_col){
    44 
    4523            $pos==true;
    46 
    4724        }
    48 
    4925    }
    50 
    5126    if($pos!=true){
    52 
    5327        $saveIt=$wpdb->query("ALTER TABLE $table ADD $col text NOT NULL;");
    54 
    5528        if($saveIt){
    56 
    5729            echo "<p style='color:#090; font-weight:bold; font-size:18px; '>Added column: ".$col." to table: ".$table."</p>";
    58 
    5930        }
    60 
    6131    }
    62 
    6332}}
    6433
    6534
    66 
    67 
    68 
    6935// check if main Skedmaker tables exist. If not, build them.
    70 
    7136$val=$wpdb->query('select 1 from `skedmaker_users`');
    72 
    7337if($val===FALSE){
    7438
    75 
    76 
    7739function SM_code(){
    78 
    7940    $codedate=date('Ymd');
    80 
    8141    $len=10;
    82 
    8342    $base='BCDFGHJKLMNPRSTVWXYZ';
    84 
    8543    $max=strlen($base)-1;
    86 
    8744    $code='';
    88 
    8945    mt_srand((double)microtime()*1000000);
    90 
    9146    while (strlen($code)<$len+1)
    92 
    9347        $code.=$base{mt_rand(0,$max)
    94 
    9548    };
    96 
    9749    $DBcode=$codedate.$code;
    98 
    9950    return $DBcode;
    100 
    10151}
    10252
    103 
    104 
    10553if(!function_exists('SM_ts')){function SM_ts(){$date=strtotime(date("Y-m-d H:i.s")); return $date;}}
    10654
    107 
    108 
    10955$conf_img="<img src='".$sm_btns_dir."btn_check_green32_reg.png' style='vertical-align:middle; margin-right:7px;'>";
    11056
    111 
    112 
    113 //////////////////////////////////////////////////////////////////////////////////////////////////
    114 
     57//////////////////////////////////////////////////////////////////////////////////////////////////
    11558// -- Blackouts
    116 
    117 //////////////////////////////////////////////////////////////////////////////////////////////////
    118 
     59//////////////////////////////////////////////////////////////////////////////////////////////////
    11960$blackouts="
    120 
    12161CREATE TABLE IF NOT EXISTS `skedmaker_blackouts` (
    122 
    12362  `id` int(11) NOT NULL auto_increment,
    124 
    12563  `code` varchar(100) NOT NULL,
    126 
    12764  `sitecode` varchar(100) NOT NULL,
    128 
    12965  `start_date` varchar(50) NOT NULL,
    130 
    13166  `end_date` varchar(50) NOT NULL,
    132 
    133   PRIMARY KEY  (`id`)
    134 
    135 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
    136 
    137 $saveIt=$wpdb->query($blackouts);
    138 
    139 // $conf_img="<img src='".$sm_btns_dir."btn_blackouts32_reg.png' style='vertical-align:middle; margin-right:7px;'>";
    140 
    141 if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_blackouts</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_blackouts</p>";}
    142 
    143 
    144 
    145 //////////////////////////////////////////////////////////////////////////////////////////////////
    146 
    147 // -- Blocked dates
    148 
    149 //////////////////////////////////////////////////////////////////////////////////////////////////
    150 
    151 $blockeddates="
    152 
    153 CREATE TABLE IF NOT EXISTS `skedmaker_blockeddates` (
    154 
    155   `id` int(20) NOT NULL auto_increment,
    156 
    157   `ip` varchar(100) NOT NULL,
    158 
    159   `date` varchar(100) NOT NULL,
    160 
    161   `timestamp` varchar(100) NOT NULL,
    162 
    163   `time` varchar(500) NOT NULL,
    164 
    165   `sitecode` varchar(500) NOT NULL,
    166 
    167   PRIMARY KEY  (`id`)
    168 
    169 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
    170 
    171 $saveIt=$wpdb->query($blockeddates);
    172 
    173 if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_blockeddates</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_blockeddates</p>";}
    174 
    175 
    176 
    177 //////////////////////////////////////////////////////////////////////////////////////////////////
    178 
    179 // -- Clients
    180 
    181 //////////////////////////////////////////////////////////////////////////////////////////////////
    182 
    183 $clients="
    184 
    185 CREATE TABLE `skedmaker_clients` (
    186 
    187   `id` int(20) NOT NULL AUTO_INCREMENT,
    188 
    189   `code` varchar(100) NOT NULL,
    190 
    191   `username` varchar(500) NOT NULL,
    192 
    193   `email` varchar(500) NOT NULL,
    194 
    195   `password` varchar(100) NOT NULL,
    196 
    197   `phone` varchar(100) NOT NULL,
    198 
    199   `signup_date` varchar(100) NOT NULL,
    200 
    201   `recent_date` varchar(100) NOT NULL,
    202 
    203   `signup_ip` varchar(100) NOT NULL,
    204 
    205   `recent_ip` varchar(100) NOT NULL,
    206 
    207   `signup_location` varchar(500) NOT NULL,
    208 
    209   `recent_location` varchar(500) NOT NULL,
    210 
    211   `valid` varchar(50) NOT NULL,
    212 
    213   PRIMARY KEY (`id`)
    214 
    215 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;";
    216 
    217 $saveIt=$wpdb->query($clients);
    218 
    219 if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_clients</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_clients</p>";}
    220 
    221 
    222 
    223 //////////////////////////////////////////////////////////////////////////////////////////////////
    224 
    225 // -- Custom
    226 
    227 //////////////////////////////////////////////////////////////////////////////////////////////////
    228 
    229 $custom="
    230 
    231 CREATE TABLE IF NOT EXISTS `skedmaker_custom` (
    232 
    233   `id` int(20) NOT NULL auto_increment,
    234 
    235   `name` varchar(500) NOT NULL,
    236 
    237   `sitecode` varchar(500) NOT NULL,
    238 
    239   `date` varchar(500) NOT NULL,
    240 
    241   `showdate` varchar(500) NOT NULL,
    242 
    243   `multiple` int(20) NOT NULL,
    244 
    245   `starthour` varchar(10) NOT NULL,
    246 
    247   `startminute` varchar(10) NOT NULL,
    248 
    249   `endhour` varchar(10) NOT NULL,
    250 
    251   `endminute` varchar(10) NOT NULL,
    252 
    253   `datecode` varchar(500) NOT NULL,
    254 
    255   `timecode` varchar(500) NOT NULL,
    256 
    257   `apt_info` text NOT NULL,
    258 
    259   PRIMARY KEY  (`id`)
    260 
    261 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
    262 
    263 $saveIt=$wpdb->query($custom);
    264 
    265 if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_custom</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_custom</p>";}
    266 
    267 
    268 
    269 //////////////////////////////////////////////////////////////////////////////////////////////////
    270 
    271 // -- Custom Sked
    272 
    273 //////////////////////////////////////////////////////////////////////////////////////////////////
    274 
    275 $custom_sked="
    276 
    277 CREATE TABLE IF NOT EXISTS `skedmaker_custom_sked` (
    278 
    279   `id` int(20) NOT NULL auto_increment,
    280 
    281   `sitecode` varchar(500) NOT NULL,
    282 
    283   `datecode` varchar(500) NOT NULL,
    284 
    285   `date` varchar(500) NOT NULL,
    286 
    287   `startdate` varchar(100) NOT NULL,
    288 
    289   `enddate` varchar(100) NOT NULL,
    290 
    291   `year` varchar(500) NOT NULL,
    292 
    293   `month` varchar(500) NOT NULL,
    294 
    295   `day` varchar(500) NOT NULL,
    296 
    297   `weekday` varchar(500) NOT NULL,
    298 
    299   `name` varchar(500) NOT NULL,
    300 
    301   `code` varchar(500) NOT NULL,
    302 
    303   PRIMARY KEY  (`id`)
    304 
    305 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
    306 
    307 $saveIt=$wpdb->query($custom_sked);
    308 
    309 if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_custom_sked</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_custom_sked</p>";}
    310 
    311 
    312 
    313 //////////////////////////////////////////////////////////////////////////////////////////////////
    314 
    315 // -- Custom Timeframes
    316 
    317 //////////////////////////////////////////////////////////////////////////////////////////////////
    318 
    319 $custom_timeframes="
    320 
    321 CREATE TABLE IF NOT EXISTS `skedmaker_custom_timeframes` (
    322 
    323   `id` int(20) NOT NULL auto_increment,
    324 
    325   `name` varchar(500) NOT NULL,
    326 
    327   `sitecode` varchar(500) NOT NULL,
    328 
    329   `date` varchar(500) NOT NULL,
    330 
    331   `showdate` varchar(500) NOT NULL,
    332 
    333   `multiple` int(20) NOT NULL,
    334 
    335   `starthour` varchar(10) NOT NULL,
    336 
    337   `startminute` varchar(10) NOT NULL,
    338 
    339   `endhour` varchar(10) NOT NULL,
    340 
    341   `endminute` varchar(10) NOT NULL,
    342 
    343   `datecode` varchar(500) NOT NULL,
    344 
    345   `timecode` varchar(500) NOT NULL,
    346 
    347   PRIMARY KEY  (`id`)
    348 
    349 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
    350 
    351 $saveIt=$wpdb->query($custom_timeframes);
    352 
    353 if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_timeframes</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_custom_timeframes</p>";}
    354 
    355 
    356 
    357 //////////////////////////////////////////////////////////////////////////////////////////////////
    358 
    359 // -- Send Reminders
    360 
    361 //////////////////////////////////////////////////////////////////////////////////////////////////
    362 
    363 $sendreminders="
    364 
    365 CREATE TABLE IF NOT EXISTS `skedmaker_sendreminders` (
    366 
    367   `id` int(29) NOT NULL auto_increment,
    368 
    369   `date` varchar(500) NOT NULL,
    370 
    371   `showdate` varchar(500) NOT NULL,
    372 
    373   `sitecode` varchar(500) NOT NULL,
    374 
    375   PRIMARY KEY  (`id`)
    376 
    377 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
    378 
    379 $saveIt=$wpdb->query($sendreminders);
    380 
    381 if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_sendreminders</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_sendreminders</p>";}
    382 
    383 
    384 
    385 $services="
    386 
    387 CREATE TABLE IF NOT EXISTS `skedmaker_services` (
    388 
    389   `id` int(20) NOT NULL auto_increment,
    390 
    391   `code` varchar(500) NOT NULL,
    392 
    393   `name` varchar(500) NOT NULL,
    394 
    395   `price` varchar(100) NOT NULL,
    396 
    397   `live` varchar(100) NOT NULL,
    398 
    399   `content` text NOT NULL,
    400 
    401   PRIMARY KEY  (`id`)
    402 
    403 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
    404 
    405 $saveIt=$wpdb->query($services);
    406 
    407 if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_services</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_services</p>";}
    408 
    409 
    410 
    411 //////////////////////////////////////////////////////////////////////////////////////////////////
    412 
    413 // -- Sked -- this is the schedule table that stores booked apts.
    414 
    415 //////////////////////////////////////////////////////////////////////////////////////////////////
    416 
    417 
    418 $sked="
    419 
    420 CREATE TABLE IF NOT EXISTS `skedmaker_sked` (
    421 
    422   `id` int(20) NOT NULL auto_increment,
    423 
    424   `ip` varchar(500) NOT NULL,
    425 
    426   `sitecode` varchar(500) NOT NULL,
    427 
    428   `usercode` varchar(500) NOT NULL,
    429 
    430   `datecode` varchar(500) NOT NULL,
    431 
    432   `name` varchar(500) NOT NULL,
    433 
    434   `email` varchar(500) NOT NULL,
    435 
    436   `phone` varchar(100) NOT NULL,
    437 
    438   `client_address` varchar(100) NOT NULL,
    439 
    440   `client_address2` varchar(100) NOT NULL,
    441 
    442   `client_city` varchar(100) NOT NULL,
    443 
    444   `client_state` varchar(100) NOT NULL,
    445 
    446   `client_zip` varchar(100) NOT NULL,
    447 
    448   `showdate` varchar(500) NOT NULL,
    449 
    450   `startdate` varchar(100) NOT NULL,
    451 
    452   `enddate` varchar(100) NOT NULL,
    453 
    454   `noshowsent` varchar(500) NOT NULL,
    455 
    456   `year` varchar(500) NOT NULL,
    457 
    458   `month` varchar(500) NOT NULL,
    459 
    460   `day` varchar(500) NOT NULL,
    461 
    462   `hour` varchar(500) NOT NULL,
    463 
    464   `minute` varchar(500) NOT NULL,
    465 
    466   `numberinparty` varchar(500) NOT NULL,
    467 
    468   `code` varchar(500) NOT NULL,
    469 
    470   `custom_timecode` varchar(500) NOT NULL,
    471 
    472   `country` varchar(500) NOT NULL,
    473 
    474   `region` varchar(500) NOT NULL,
    475 
    476   `city` varchar(500) NOT NULL,
    477 
    478   `reminder_sent` varchar(100) NOT NULL,
    479 
    480   `content` text NOT NULL,
    481 
    482   `services` text NOT NULL,
    483 
    484   PRIMARY KEY  (`id`)
    485 
    486 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
    487 
    488 $saveIt=$wpdb->query($sked);
    489 
    490 if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_sked</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_sked</p>";}
    491 
    492 
    493 
    494 //////////////////////////////////////////////////////////////////////////////////////////////////
    495 
    496 // -- create a unique code to prevent double posts
    497 
    498 //////////////////////////////////////////////////////////////////////////////////////////////////
    499 
    500 $uni="
    501 
    502 CREATE TABLE IF NOT EXISTS `skedmaker_uni` (
    503 
    504   `id` int(20) NOT NULL auto_increment,
    505 
    506   `uni` varchar(500) NOT NULL,
    507 
    508   PRIMARY KEY  (`id`)
    509 
    510 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
    511 
    512 $saveIt=$wpdb->query($uni);
    513 
    514 if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_uni</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_uni</p>";}
    515 
    516 
    517 
    518 //////////////////////////////////////////////////////////////////////////////////////////////////
    519 
    520 // -- admin's user profile, all setting for skedmaker a re stored here.
    521 
    522 //////////////////////////////////////////////////////////////////////////////////////////////////
    523 
    524 $users="
    525 
    526 CREATE TABLE IF NOT EXISTS `skedmaker_users` (
    527   `id` int(30) NOT NULL auto_increment,
    528   `timezone` varchar(500) NOT NULL,
    529   `sitecode` varchar(500) NOT NULL,
    530   `admincode` varchar(500) NOT NULL,
    531   `agentcode` varchar(20) NOT NULL,
    532   `promocode` varchar(100) NOT NULL,
    533   `valid` varchar(100) NOT NULL,
    534   `live` varchar(100) NOT NULL,
    535   `daysleft` int(20) NOT NULL,
    536   `sitename` varchar(500) NOT NULL,
    537   `photo` varchar(500) NOT NULL,
    538   `country` varchar(500) NOT NULL,
    539   `region` varchar(500) NOT NULL,
    540   `city` varchar(500) NOT NULL,
    541   `address1` varchar(500) NOT NULL,
    542   `address2` varchar(500) NOT NULL,
    543   `zipcode` varchar(100) NOT NULL,
    544   `phone` varchar(100) NOT NULL,
    545   `fax` varchar(100) NOT NULL,
    546   `directionsURL` varchar(1000) NOT NULL,
    547   `cellphone` varchar(100) NOT NULL,
    548   `website` varchar(500) NOT NULL,
    549   `ipsignup` varchar(50) NOT NULL,
    550   `iprecent` varchar(100) NOT NULL,
    551   `adminemail` varchar(500) NOT NULL,
    552   `password` varchar(200) NOT NULL,
    553   `trackcountry` varchar(100) NOT NULL,
    554   `trackregion` varchar(100) NOT NULL,
    555   `trackcity` varchar(100) NOT NULL,
    556   `datesignup` varchar(50) NOT NULL,
    557   `daterecent` varchar(50) NOT NULL,
    558   `datepaid` varchar(500) NOT NULL,
    559   `datekill` varchar(500) NOT NULL,
    560   `kill_sent_1days` varchar(20) NOT NULL,
    561   `kill_sent_4days` varchar(20) NOT NULL,
    562   `kill_sent_7days` varchar(20) NOT NULL,
    563   `warnday` varchar(50) NOT NULL,
    564   `mondaylive` varchar(10) NOT NULL,
    565   `mondayincrement` varchar(100) NOT NULL,
    566   `mondaymultiple` varchar(10) NOT NULL,
    567   `mondayopenhour` varchar(20) NOT NULL,
    568   `mondayopenminute` varchar(20) NOT NULL,
    569   `mondaybreakhour` varchar(20) NOT NULL,
    570   `mondaybreakminute` varchar(20) NOT NULL,
    571   `mondayreturnhour` varchar(20) NOT NULL,
    572   `mondayreturnminute` varchar(20) NOT NULL,
    573   `mondayclosehour` varchar(20) NOT NULL,
    574   `mondaycloseminute` varchar(20) NOT NULL,
    575   `monday_info` text NOT NULL,
    576   `tuesdaylive` varchar(10) NOT NULL,
    577   `tuesdayincrement` varchar(100) NOT NULL,
    578   `tuesdaymultiple` varchar(10) NOT NULL,
    579   `tuesdayopenhour` varchar(20) NOT NULL,
    580   `tuesdayopenminute` varchar(20) NOT NULL,
    581   `tuesdaybreakhour` varchar(20) NOT NULL,
    582   `tuesdaybreakminute` varchar(20) NOT NULL,
    583   `tuesdayreturnhour` varchar(20) NOT NULL,
    584   `tuesdayreturnminute` varchar(20) NOT NULL,
    585   `tuesdayclosehour` varchar(20) NOT NULL,
    586   `tuesdaycloseminute` varchar(20) NOT NULL,
    587   `tuesday_info` text NOT NULL,
    588   `wednesdaylive` varchar(10) NOT NULL,
    589   `wednesdayincrement` varchar(100) NOT NULL,
    590   `wednesdaymultiple` varchar(10) NOT NULL,
    591   `wednesdayopenhour` varchar(20) NOT NULL,
    592   `wednesdayopenminute` varchar(20) NOT NULL,
    593   `wednesdaybreakhour` varchar(20) NOT NULL,
    594   `wednesdaybreakminute` varchar(20) NOT NULL,
    595   `wednesdayreturnhour` varchar(20) NOT NULL,
    596   `wednesdayreturnminute` varchar(20) NOT NULL,
    597   `wednesdayclosehour` varchar(20) NOT NULL,
    598   `wednesdaycloseminute` varchar(20) NOT NULL,
    599   `wednesday_info` text NOT NULL,
    600   `thursdaylive` varchar(10) NOT NULL,
    601   `thursdayincrement` varchar(100) NOT NULL,
    602   `thursdaymultiple` varchar(10) NOT NULL,
    603   `thursdayopenhour` varchar(20) NOT NULL,
    604   `thursdayopenminute` varchar(20) NOT NULL,
    605   `thursdaybreakhour` varchar(20) NOT NULL,
    606   `thursdaybreakminute` varchar(20) NOT NULL,
    607   `thursdayreturnhour` varchar(20) NOT NULL,
    608   `thursdayreturnminute` varchar(20) NOT NULL,
    609   `thursdayclosehour` varchar(20) NOT NULL,
    610   `thursdaycloseminute` varchar(20) NOT NULL,
    611   `thursday_info` text NOT NULL,
    612   `fridaylive` varchar(10) NOT NULL,
    613   `fridayincrement` varchar(100) NOT NULL,
    614   `fridaymultiple` varchar(10) NOT NULL,
    615   `fridayopenhour` varchar(20) NOT NULL,
    616   `fridayopenminute` varchar(20) NOT NULL,
    617   `fridaybreakhour` varchar(20) NOT NULL,
    618   `fridaybreakminute` varchar(20) NOT NULL,
    619   `fridayreturnhour` varchar(20) NOT NULL,
    620   `fridayreturnminute` varchar(20) NOT NULL,
    621   `fridayclosehour` varchar(20) NOT NULL,
    622   `fridaycloseminute` varchar(20) NOT NULL,
    623   `friday_info` text NOT NULL,
    624   `saturdaylive` varchar(10) NOT NULL,
    625   `saturdayincrement` varchar(100) NOT NULL,
    626   `saturdaymultiple` varchar(10) NOT NULL,
    627   `saturdayopenhour` varchar(20) NOT NULL,
    628   `saturdayopenminute` varchar(20) NOT NULL,
    629   `saturdaybreakhour` varchar(20) NOT NULL,
    630   `saturdaybreakminute` varchar(20) NOT NULL,
    631   `saturdayreturnhour` varchar(20) NOT NULL,
    632   `saturdayreturnminute` varchar(20) NOT NULL,
    633   `saturdayclosehour` varchar(20) NOT NULL,
    634   `saturdaycloseminute` varchar(20) NOT NULL,
    635   `saturday_info` text NOT NULL,
    636   `sundaylive` varchar(10) NOT NULL,
    637   `sundayincrement` varchar(100) NOT NULL,
    638   `sundaymultiple` varchar(10) NOT NULL,
    639   `sundayopenhour` varchar(20) NOT NULL,
    640   `sundayopenminute` varchar(20) NOT NULL,
    641   `sundaybreakhour` varchar(20) NOT NULL,
    642   `sundaybreakminute` varchar(20) NOT NULL,
    643   `sundayreturnhour` varchar(20) NOT NULL,
    644   `sundayreturnminute` varchar(20) NOT NULL,
    645   `sundayclosehour` varchar(20) NOT NULL,
    646   `sundaycloseminute` varchar(20) NOT NULL,
    647   `sunday_info` text NOT NULL,
    648   `content` longtext NOT NULL,
    649   `banner` varchar(100) NOT NULL,
    650   `blockeddays` longtext NOT NULL,
    651   `blockedtimes` longtext NOT NULL,
    652   `terms` varchar(500) NOT NULL,
    653   `deleted` varchar(500) NOT NULL,
    654   `requirename` varchar(10) NOT NULL,
    655   `requireemail` varchar(10) NOT NULL,
    656   `requireconfirm` varchar(10) NOT NULL,
    657   `requirephone` varchar(10) NOT NULL,
    658   `requiremessage` varchar(10) NOT NULL,
    659   `sitepublic` varchar(10) NOT NULL,
    660   `facebook` varchar(10) NOT NULL,
    661   `twitter` varchar(20) NOT NULL,
    662   `googleplus` varchar(20) NOT NULL,
    663   `allowsameday` varchar(5) NOT NULL,
    664   `premium` varchar(100) NOT NULL,
    665   `protect` varchar(500) NOT NULL,
    666   `publicschedule` varchar(10) NOT NULL,
    667   `appointmentAvailable` varchar(500) NOT NULL,
    668   `appointmentUnavailable` varchar(500) NOT NULL,
    669   `appointmentpadding` varchar(100) NOT NULL,
    670   `cancel` text NOT NULL,
    671   `confirmation` text NOT NULL,
    672   `cancelpolicy` text NOT NULL,
    673   `feature` varchar(100) NOT NULL,
    674   `requirenumberinparty` varchar(100) NOT NULL,
    675   `partymax` varchar(100) NOT NULL,
    676   `keep_profile_open` varchar(1) NOT NULL,
    677   `calendarcaption` longtext NOT NULL,
    678 
    679   `services` text NOT NULL,
    680   `skin` varchar(50) NOT NULL,
    681   `color1` varchar(20) NOT NULL,
    682   `color2` varchar(20) NOT NULL,
    683   `color3` varchar(20) NOT NULL,
    684   `highlight` varchar(20) NOT NULL,
    685   `requireregistration` varchar(10) NOT NULL,
    686   `requirevalidation` varchar(10) NOT NULL,
    687   `send_notices_to_admin` varchar(10) NOT NULL,
    688   `send_notices_to_client` varchar(10) NOT NULL,
    689   `send_notices_to_BCC` varchar(10) NOT NULL,
    690   `BCC1` varchar(100) NOT NULL,
    691   `BCC2` varchar(100) NOT NULL,
    692   `BCC3` varchar(100) NOT NULL,
    693   `prefix_content` text NOT NULL,
    694   `daylight_savings` varchar(100) NOT NULL, 
    695   `reminder_interval` varchar(20) NOT NULL, 
    696   `requireservices` varchar(100) NOT NULL,
    697   `services_list_style` VARCHAR(100),
    698   `require_client_address` VARCHAR(100),
    699 
    70067  PRIMARY KEY  (`id`)
    70168) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
     69$saveIt=$wpdb->query($blackouts);
     70// $conf_img="<img src='".$sm_btns_dir."btn_blackouts32_reg.png' style='vertical-align:middle; margin-right:7px;'>";
     71if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_blackouts</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_blackouts</p>";}
     72
     73
     74
     75
     76
     77
     78
     79//////////////////////////////////////////////////////////////////////////////////////////////////
     80
     81
     82
     83// -- Blocked dates
     84
     85
     86
     87//////////////////////////////////////////////////////////////////////////////////////////////////
     88
     89
     90
     91$blockeddates="
     92
     93
     94
     95CREATE TABLE IF NOT EXISTS `skedmaker_blockeddates` (
     96
     97
     98
     99  `id` int(20) NOT NULL auto_increment,
     100
     101
     102
     103  `ip` varchar(100) NOT NULL,
     104
     105
     106
     107  `date` varchar(100) NOT NULL,
     108
     109
     110
     111  `timestamp` varchar(100) NOT NULL,
     112
     113
     114
     115  `time` varchar(500) NOT NULL,
     116
     117
     118
     119  `sitecode` varchar(500) NOT NULL,
     120
     121
     122
     123  PRIMARY KEY  (`id`)
     124
     125
     126
     127) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
     128
     129
     130
     131$saveIt=$wpdb->query($blockeddates);
     132
     133
     134
     135if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_blockeddates</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_blockeddates</p>";}
     136
     137
     138
     139
     140
     141
     142
     143//////////////////////////////////////////////////////////////////////////////////////////////////
     144
     145
     146
     147// -- Clients
     148
     149
     150
     151//////////////////////////////////////////////////////////////////////////////////////////////////
     152
     153
     154
     155$clients="
     156
     157
     158
     159CREATE TABLE `skedmaker_clients` (
     160
     161
     162
     163  `id` int(20) NOT NULL AUTO_INCREMENT,
     164
     165
     166
     167  `code` varchar(100) NOT NULL,
     168
     169
     170
     171  `username` varchar(500) NOT NULL,
     172
     173
     174
     175  `email` varchar(500) NOT NULL,
     176
     177
     178
     179  `password` varchar(100) NOT NULL,
     180
     181
     182
     183  `phone` varchar(100) NOT NULL,
     184
     185
     186
     187  `signup_date` varchar(100) NOT NULL,
     188
     189
     190
     191  `recent_date` varchar(100) NOT NULL,
     192
     193
     194
     195  `signup_ip` varchar(100) NOT NULL,
     196
     197
     198
     199  `recent_ip` varchar(100) NOT NULL,
     200
     201
     202
     203  `signup_location` varchar(500) NOT NULL,
     204
     205
     206
     207  `recent_location` varchar(500) NOT NULL,
     208
     209
     210
     211  `valid` varchar(50) NOT NULL,
     212
     213
     214
     215  PRIMARY KEY (`id`)
     216
     217
     218
     219) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;";
     220
     221
     222
     223$saveIt=$wpdb->query($clients);
     224
     225
     226
     227if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_clients</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_clients</p>";}
     228
     229
     230
     231
     232
     233
     234
     235//////////////////////////////////////////////////////////////////////////////////////////////////
     236
     237
     238
     239// -- Custom
     240
     241
     242
     243//////////////////////////////////////////////////////////////////////////////////////////////////
     244
     245
     246
     247$custom="
     248
     249
     250
     251CREATE TABLE IF NOT EXISTS `skedmaker_custom` (
     252
     253
     254
     255  `id` int(20) NOT NULL auto_increment,
     256
     257
     258
     259  `name` varchar(500) NOT NULL,
     260
     261
     262
     263  `sitecode` varchar(500) NOT NULL,
     264
     265
     266
     267  `date` varchar(500) NOT NULL,
     268
     269
     270
     271  `showdate` varchar(500) NOT NULL,
     272
     273
     274
     275  `multiple` int(20) NOT NULL,
     276
     277
     278
     279  `starthour` varchar(10) NOT NULL,
     280
     281
     282
     283  `startminute` varchar(10) NOT NULL,
     284
     285
     286
     287  `endhour` varchar(10) NOT NULL,
     288
     289
     290
     291  `endminute` varchar(10) NOT NULL,
     292
     293
     294
     295  `datecode` varchar(500) NOT NULL,
     296
     297
     298
     299  `timecode` varchar(500) NOT NULL,
     300
     301
     302
     303  `apt_info` text NOT NULL,
     304
     305
     306
     307  PRIMARY KEY  (`id`)
     308
     309
     310
     311) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
     312
     313
     314
     315$saveIt=$wpdb->query($custom);
     316
     317
     318
     319if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_custom</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_custom</p>";}
     320
     321
     322
     323
     324
     325
     326
     327//////////////////////////////////////////////////////////////////////////////////////////////////
     328
     329
     330
     331// -- Custom Sked
     332
     333
     334
     335//////////////////////////////////////////////////////////////////////////////////////////////////
     336
     337
     338
     339$custom_sked="
     340
     341
     342
     343CREATE TABLE IF NOT EXISTS `skedmaker_custom_sked` (
     344
     345
     346
     347  `id` int(20) NOT NULL auto_increment,
     348
     349
     350
     351  `sitecode` varchar(500) NOT NULL,
     352
     353
     354
     355  `datecode` varchar(500) NOT NULL,
     356
     357
     358
     359  `date` varchar(500) NOT NULL,
     360
     361
     362
     363  `startdate` varchar(100) NOT NULL,
     364
     365
     366
     367  `enddate` varchar(100) NOT NULL,
     368
     369
     370
     371  `year` varchar(500) NOT NULL,
     372
     373
     374
     375  `month` varchar(500) NOT NULL,
     376
     377
     378
     379  `day` varchar(500) NOT NULL,
     380
     381
     382
     383  `weekday` varchar(500) NOT NULL,
     384
     385
     386
     387  `name` varchar(500) NOT NULL,
     388
     389
     390
     391  `code` varchar(500) NOT NULL,
     392
     393
     394
     395  PRIMARY KEY  (`id`)
     396
     397
     398
     399) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
     400
     401
     402
     403$saveIt=$wpdb->query($custom_sked);
     404
     405
     406
     407if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_custom_sked</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_custom_sked</p>";}
     408
     409
     410
     411
     412
     413
     414
     415//////////////////////////////////////////////////////////////////////////////////////////////////
     416
     417
     418
     419// -- Custom Timeframes
     420
     421
     422
     423//////////////////////////////////////////////////////////////////////////////////////////////////
     424
     425
     426
     427$custom_timeframes="
     428
     429
     430
     431CREATE TABLE IF NOT EXISTS `skedmaker_custom_timeframes` (
     432
     433
     434
     435  `id` int(20) NOT NULL auto_increment,
     436
     437
     438
     439  `name` varchar(500) NOT NULL,
     440
     441
     442
     443  `sitecode` varchar(500) NOT NULL,
     444
     445
     446
     447  `date` varchar(500) NOT NULL,
     448
     449
     450
     451  `showdate` varchar(500) NOT NULL,
     452
     453
     454
     455  `multiple` int(20) NOT NULL,
     456
     457
     458
     459  `starthour` varchar(10) NOT NULL,
     460
     461
     462
     463  `startminute` varchar(10) NOT NULL,
     464
     465
     466
     467  `endhour` varchar(10) NOT NULL,
     468
     469
     470
     471  `endminute` varchar(10) NOT NULL,
     472
     473
     474
     475  `datecode` varchar(500) NOT NULL,
     476
     477
     478
     479  `timecode` varchar(500) NOT NULL,
     480
     481
     482
     483  PRIMARY KEY  (`id`)
     484
     485
     486
     487) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
     488
     489
     490
     491$saveIt=$wpdb->query($custom_timeframes);
     492
     493
     494
     495if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_timeframes</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_custom_timeframes</p>";}
     496
     497
     498
     499
     500
     501
     502
     503//////////////////////////////////////////////////////////////////////////////////////////////////
     504
     505
     506
     507// -- Send Reminders
     508
     509
     510
     511//////////////////////////////////////////////////////////////////////////////////////////////////
     512
     513
     514
     515$sendreminders="
     516
     517
     518
     519CREATE TABLE IF NOT EXISTS `skedmaker_sendreminders` (
     520
     521
     522
     523  `id` int(29) NOT NULL auto_increment,
     524
     525
     526
     527  `date` varchar(500) NOT NULL,
     528
     529
     530
     531  `showdate` varchar(500) NOT NULL,
     532
     533
     534
     535  `sitecode` varchar(500) NOT NULL,
     536
     537
     538
     539  PRIMARY KEY  (`id`)
     540
     541
     542
     543) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
     544
     545
     546
     547$saveIt=$wpdb->query($sendreminders);
     548
     549
     550
     551if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_sendreminders</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_sendreminders</p>";}
     552
     553
     554
     555
     556
     557
     558
     559$services="
     560
     561
     562
     563CREATE TABLE IF NOT EXISTS `skedmaker_services` (
     564
     565
     566
     567  `id` int(20) NOT NULL auto_increment,
     568
     569
     570
     571  `code` varchar(500) NOT NULL,
     572
     573
     574
     575  `name` varchar(500) NOT NULL,
     576
     577
     578
     579  `price` varchar(100) NOT NULL,
     580
     581
     582
     583  `live` varchar(100) NOT NULL,
     584
     585
     586
     587  `content` text NOT NULL,
     588
     589
     590
     591  PRIMARY KEY  (`id`)
     592
     593
     594
     595) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
     596
     597
     598
     599$saveIt=$wpdb->query($services);
     600
     601
     602
     603if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_services</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_services</p>";}
     604
     605
     606
     607
     608
     609
     610
     611//////////////////////////////////////////////////////////////////////////////////////////////////
     612
     613
     614
     615// -- Sked -- this is the schedule table that stores booked apts.
     616
     617
     618
     619//////////////////////////////////////////////////////////////////////////////////////////////////
     620
     621
     622
     623
     624
     625$sked="
     626
     627
     628
     629CREATE TABLE IF NOT EXISTS `skedmaker_sked` (
     630
     631
     632
     633  `id` int(20) NOT NULL auto_increment,
     634
     635
     636
     637  `ip` varchar(500) NOT NULL,
     638
     639
     640
     641  `sitecode` varchar(500) NOT NULL,
     642
     643
     644
     645  `usercode` varchar(500) NOT NULL,
     646
     647
     648
     649  `datecode` varchar(500) NOT NULL,
     650
     651
     652
     653  `name` varchar(500) NOT NULL,
     654
     655
     656
     657  `email` varchar(500) NOT NULL,
     658
     659
     660
     661  `phone` varchar(100) NOT NULL,
     662
     663
     664
     665  `client_address` varchar(100) NOT NULL,
     666
     667
     668
     669  `client_address2` varchar(100) NOT NULL,
     670
     671
     672
     673  `client_city` varchar(100) NOT NULL,
     674
     675
     676
     677  `client_state` varchar(100) NOT NULL,
     678
     679
     680
     681  `client_zip` varchar(100) NOT NULL,
     682
     683
     684
     685  `showdate` varchar(500) NOT NULL,
     686
     687
     688
     689  `startdate` varchar(100) NOT NULL,
     690
     691
     692
     693  `enddate` varchar(100) NOT NULL,
     694
     695
     696
     697  `noshowsent` varchar(500) NOT NULL,
     698
     699
     700
     701  `year` varchar(500) NOT NULL,
     702
     703
     704
     705  `month` varchar(500) NOT NULL,
     706
     707
     708
     709  `day` varchar(500) NOT NULL,
     710
     711
     712
     713  `hour` varchar(500) NOT NULL,
     714
     715
     716
     717  `minute` varchar(500) NOT NULL,
     718
     719
     720
     721  `numberinparty` varchar(500) NOT NULL,
     722
     723
     724
     725  `code` varchar(500) NOT NULL,
     726
     727
     728
     729  `custom_timecode` varchar(500) NOT NULL,
     730
     731
     732
     733  `country` varchar(500) NOT NULL,
     734
     735
     736
     737  `region` varchar(500) NOT NULL,
     738
     739
     740
     741  `city` varchar(500) NOT NULL,
     742
     743
     744
     745  `reminder_sent` varchar(100) NOT NULL,
     746
     747
     748
     749  `content` text NOT NULL,
     750
     751
     752
     753  `services` text NOT NULL,
     754
     755
     756
     757  PRIMARY KEY  (`id`)
     758
     759
     760
     761) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
     762
     763
     764
     765$saveIt=$wpdb->query($sked);
     766
     767
     768
     769if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_sked</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_sked</p>";}
     770
     771
     772
     773
     774
     775
     776
     777//////////////////////////////////////////////////////////////////////////////////////////////////
     778
     779
     780
     781// -- create a unique code to prevent double posts
     782
     783
     784
     785//////////////////////////////////////////////////////////////////////////////////////////////////
     786
     787
     788
     789$uni="
     790
     791
     792
     793CREATE TABLE IF NOT EXISTS `skedmaker_uni` (
     794
     795
     796
     797  `id` int(20) NOT NULL auto_increment,
     798
     799
     800
     801  `uni` varchar(500) NOT NULL,
     802
     803
     804
     805  PRIMARY KEY  (`id`)
     806
     807
     808
     809) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
     810
     811
     812
     813$saveIt=$wpdb->query($uni);
     814
     815
     816
     817if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_uni</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_uni</p>";}
     818
     819
     820
     821
     822
     823
     824
     825//////////////////////////////////////////////////////////////////////////////////////////////////
     826
     827
     828
     829// -- admin's user profile, all setting for skedmaker a re stored here.
     830
     831
     832
     833//////////////////////////////////////////////////////////////////////////////////////////////////
     834
     835
     836
     837$users="
     838
     839
     840
     841CREATE TABLE IF NOT EXISTS `skedmaker_users` (
     842
     843  `id` int(30) NOT NULL auto_increment,
     844
     845  `timezone` varchar(500) NOT NULL,
     846
     847  `sitecode` varchar(500) NOT NULL,
     848
     849  `admincode` varchar(500) NOT NULL,
     850
     851  `agentcode` varchar(20) NOT NULL,
     852
     853  `promocode` varchar(100) NOT NULL,
     854
     855  `valid` varchar(100) NOT NULL,
     856
     857  `live` varchar(100) NOT NULL,
     858
     859  `daysleft` int(20) NOT NULL,
     860
     861  `sitename` varchar(500) NOT NULL,
     862
     863  `photo` varchar(500) NOT NULL,
     864
     865  `country` varchar(500) NOT NULL,
     866
     867  `region` varchar(500) NOT NULL,
     868
     869  `city` varchar(500) NOT NULL,
     870
     871  `address1` varchar(500) NOT NULL,
     872
     873  `address2` varchar(500) NOT NULL,
     874
     875  `zipcode` varchar(100) NOT NULL,
     876
     877  `phone` varchar(100) NOT NULL,
     878
     879  `fax` varchar(100) NOT NULL,
     880
     881  `directionsURL` varchar(1000) NOT NULL,
     882
     883  `cellphone` varchar(100) NOT NULL,
     884
     885  `website` varchar(500) NOT NULL,
     886
     887  `ipsignup` varchar(50) NOT NULL,
     888
     889  `iprecent` varchar(100) NOT NULL,
     890
     891  `adminemail` varchar(500) NOT NULL,
     892
     893  `password` varchar(200) NOT NULL,
     894
     895  `trackcountry` varchar(100) NOT NULL,
     896
     897  `trackregion` varchar(100) NOT NULL,
     898
     899  `trackcity` varchar(100) NOT NULL,
     900
     901  `datesignup` varchar(50) NOT NULL,
     902
     903  `daterecent` varchar(50) NOT NULL,
     904
     905  `datepaid` varchar(500) NOT NULL,
     906
     907  `datekill` varchar(500) NOT NULL,
     908
     909  `kill_sent_1days` varchar(20) NOT NULL,
     910
     911  `kill_sent_4days` varchar(20) NOT NULL,
     912
     913  `kill_sent_7days` varchar(20) NOT NULL,
     914
     915  `warnday` varchar(50) NOT NULL,
     916
     917  `mondaylive` varchar(10) NOT NULL,
     918
     919  `mondayincrement` varchar(100) NOT NULL,
     920
     921  `mondaymultiple` varchar(10) NOT NULL,
     922
     923  `mondayopenhour` varchar(20) NOT NULL,
     924
     925  `mondayopenminute` varchar(20) NOT NULL,
     926
     927  `mondaybreakhour` varchar(20) NOT NULL,
     928
     929  `mondaybreakminute` varchar(20) NOT NULL,
     930
     931  `mondayreturnhour` varchar(20) NOT NULL,
     932
     933  `mondayreturnminute` varchar(20) NOT NULL,
     934
     935  `mondayclosehour` varchar(20) NOT NULL,
     936
     937  `mondaycloseminute` varchar(20) NOT NULL,
     938
     939  `monday_info` text NOT NULL,
     940
     941  `tuesdaylive` varchar(10) NOT NULL,
     942
     943  `tuesdayincrement` varchar(100) NOT NULL,
     944
     945  `tuesdaymultiple` varchar(10) NOT NULL,
     946
     947  `tuesdayopenhour` varchar(20) NOT NULL,
     948
     949  `tuesdayopenminute` varchar(20) NOT NULL,
     950
     951  `tuesdaybreakhour` varchar(20) NOT NULL,
     952
     953  `tuesdaybreakminute` varchar(20) NOT NULL,
     954
     955  `tuesdayreturnhour` varchar(20) NOT NULL,
     956
     957  `tuesdayreturnminute` varchar(20) NOT NULL,
     958
     959  `tuesdayclosehour` varchar(20) NOT NULL,
     960
     961  `tuesdaycloseminute` varchar(20) NOT NULL,
     962
     963  `tuesday_info` text NOT NULL,
     964
     965  `wednesdaylive` varchar(10) NOT NULL,
     966
     967  `wednesdayincrement` varchar(100) NOT NULL,
     968
     969  `wednesdaymultiple` varchar(10) NOT NULL,
     970
     971  `wednesdayopenhour` varchar(20) NOT NULL,
     972
     973  `wednesdayopenminute` varchar(20) NOT NULL,
     974
     975  `wednesdaybreakhour` varchar(20) NOT NULL,
     976
     977  `wednesdaybreakminute` varchar(20) NOT NULL,
     978
     979  `wednesdayreturnhour` varchar(20) NOT NULL,
     980
     981  `wednesdayreturnminute` varchar(20) NOT NULL,
     982
     983  `wednesdayclosehour` varchar(20) NOT NULL,
     984
     985  `wednesdaycloseminute` varchar(20) NOT NULL,
     986
     987  `wednesday_info` text NOT NULL,
     988
     989  `thursdaylive` varchar(10) NOT NULL,
     990
     991  `thursdayincrement` varchar(100) NOT NULL,
     992
     993  `thursdaymultiple` varchar(10) NOT NULL,
     994
     995  `thursdayopenhour` varchar(20) NOT NULL,
     996
     997  `thursdayopenminute` varchar(20) NOT NULL,
     998
     999  `thursdaybreakhour` varchar(20) NOT NULL,
     1000
     1001  `thursdaybreakminute` varchar(20) NOT NULL,
     1002
     1003  `thursdayreturnhour` varchar(20) NOT NULL,
     1004
     1005  `thursdayreturnminute` varchar(20) NOT NULL,
     1006
     1007  `thursdayclosehour` varchar(20) NOT NULL,
     1008
     1009  `thursdaycloseminute` varchar(20) NOT NULL,
     1010
     1011  `thursday_info` text NOT NULL,
     1012
     1013  `fridaylive` varchar(10) NOT NULL,
     1014
     1015  `fridayincrement` varchar(100) NOT NULL,
     1016
     1017  `fridaymultiple` varchar(10) NOT NULL,
     1018
     1019  `fridayopenhour` varchar(20) NOT NULL,
     1020
     1021  `fridayopenminute` varchar(20) NOT NULL,
     1022
     1023  `fridaybreakhour` varchar(20) NOT NULL,
     1024
     1025  `fridaybreakminute` varchar(20) NOT NULL,
     1026
     1027  `fridayreturnhour` varchar(20) NOT NULL,
     1028
     1029  `fridayreturnminute` varchar(20) NOT NULL,
     1030
     1031  `fridayclosehour` varchar(20) NOT NULL,
     1032
     1033  `fridaycloseminute` varchar(20) NOT NULL,
     1034
     1035  `friday_info` text NOT NULL,
     1036
     1037  `saturdaylive` varchar(10) NOT NULL,
     1038
     1039  `saturdayincrement` varchar(100) NOT NULL,
     1040
     1041  `saturdaymultiple` varchar(10) NOT NULL,
     1042
     1043  `saturdayopenhour` varchar(20) NOT NULL,
     1044
     1045  `saturdayopenminute` varchar(20) NOT NULL,
     1046
     1047  `saturdaybreakhour` varchar(20) NOT NULL,
     1048
     1049  `saturdaybreakminute` varchar(20) NOT NULL,
     1050
     1051  `saturdayreturnhour` varchar(20) NOT NULL,
     1052
     1053  `saturdayreturnminute` varchar(20) NOT NULL,
     1054
     1055  `saturdayclosehour` varchar(20) NOT NULL,
     1056
     1057  `saturdaycloseminute` varchar(20) NOT NULL,
     1058
     1059  `saturday_info` text NOT NULL,
     1060
     1061  `sundaylive` varchar(10) NOT NULL,
     1062
     1063  `sundayincrement` varchar(100) NOT NULL,
     1064
     1065  `sundaymultiple` varchar(10) NOT NULL,
     1066
     1067  `sundayopenhour` varchar(20) NOT NULL,
     1068
     1069  `sundayopenminute` varchar(20) NOT NULL,
     1070
     1071  `sundaybreakhour` varchar(20) NOT NULL,
     1072
     1073  `sundaybreakminute` varchar(20) NOT NULL,
     1074
     1075  `sundayreturnhour` varchar(20) NOT NULL,
     1076
     1077  `sundayreturnminute` varchar(20) NOT NULL,
     1078
     1079  `sundayclosehour` varchar(20) NOT NULL,
     1080
     1081  `sundaycloseminute` varchar(20) NOT NULL,
     1082
     1083  `sunday_info` text NOT NULL,
     1084
     1085  `content` longtext NOT NULL,
     1086
     1087  `banner` varchar(100) NOT NULL,
     1088
     1089  `blockeddays` longtext NOT NULL,
     1090
     1091  `blockedtimes` longtext NOT NULL,
     1092
     1093  `terms` varchar(500) NOT NULL,
     1094
     1095  `deleted` varchar(500) NOT NULL,
     1096
     1097  `requirename` varchar(10) NOT NULL,
     1098
     1099  `requireemail` varchar(10) NOT NULL,
     1100
     1101  `requireconfirm` varchar(10) NOT NULL,
     1102
     1103  `requirephone` varchar(10) NOT NULL,
     1104
     1105  `requiremessage` varchar(10) NOT NULL,
     1106
     1107  `sitepublic` varchar(10) NOT NULL,
     1108
     1109  `facebook` varchar(10) NOT NULL,
     1110
     1111  `twitter` varchar(20) NOT NULL,
     1112
     1113  `googleplus` varchar(20) NOT NULL,
     1114
     1115  `allowsameday` varchar(5) NOT NULL,
     1116
     1117  `premium` varchar(100) NOT NULL,
     1118
     1119  `protect` varchar(500) NOT NULL,
     1120
     1121  `publicschedule` varchar(10) NOT NULL,
     1122
     1123  `appointmentAvailable` varchar(500) NOT NULL,
     1124
     1125  `appointmentUnavailable` varchar(500) NOT NULL,
     1126
     1127  `appointmentpadding` varchar(100) NOT NULL,
     1128
     1129  `cancel` text NOT NULL,
     1130
     1131  `confirmation` text NOT NULL,
     1132
     1133  `cancelpolicy` text NOT NULL,
     1134
     1135  `feature` varchar(100) NOT NULL,
     1136
     1137  `requirenumberinparty` varchar(100) NOT NULL,
     1138
     1139  `partymax` varchar(100) NOT NULL,
     1140
     1141  `keep_profile_open` varchar(1) NOT NULL,
     1142
     1143  `calendarcaption` longtext NOT NULL,
     1144
     1145
     1146
     1147  `services` text NOT NULL,
     1148
     1149  `skin` varchar(50) NOT NULL,
     1150
     1151  `color1` varchar(20) NOT NULL,
     1152
     1153  `color2` varchar(20) NOT NULL,
     1154
     1155  `color3` varchar(20) NOT NULL,
     1156
     1157  `highlight` varchar(20) NOT NULL,
     1158
     1159  `requireregistration` varchar(10) NOT NULL,
     1160
     1161  `requirevalidation` varchar(10) NOT NULL,
     1162
     1163  `send_notices_to_admin` varchar(10) NOT NULL,
     1164
     1165  `send_notices_to_client` varchar(10) NOT NULL,
     1166
     1167  `send_notices_to_BCC` varchar(10) NOT NULL,
     1168
     1169  `BCC1` varchar(100) NOT NULL,
     1170
     1171  `BCC2` varchar(100) NOT NULL,
     1172
     1173  `BCC3` varchar(100) NOT NULL,
     1174
     1175  `prefix_content` text NOT NULL,
     1176
     1177  `daylight_savings` varchar(100) NOT NULL, 
     1178
     1179  `reminder_interval` varchar(20) NOT NULL, 
     1180
     1181  `requireservices` varchar(100) NOT NULL,
     1182
     1183  `services_list_style` VARCHAR(100),
     1184
     1185  `require_client_address` VARCHAR(100),
     1186 
     1187  `limited_services` VARCHAR(50),
     1188
     1189
     1190
     1191  PRIMARY KEY  (`id`)
     1192
     1193) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
     1194
     1195
    7021196
    7031197$saveIt=$wpdb->query($users);
    7041198
     1199
     1200
    7051201if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_users</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_users</p>";}
    7061202
    7071203
    7081204
     1205
     1206
     1207
     1208
    7091209$genSC=SM_code();
    7101210
     1211
     1212
    7111213$genUC=SM_code();
    7121214
     1215
     1216
    7131217$genTS=SM_ts();
    7141218
    7151219
    7161220
     1221
     1222
     1223
     1224
    7171225if($errorMessage!="y"){
    7181226
     1227
     1228
    7191229    //////////////////////////////////////////////////////////////////////////////////////////////////
    7201230
     1231
     1232
    7211233    // -- Create a defaut admin account
    7221234
     1235
     1236
    7231237    //////////////////////////////////////////////////////////////////////////////////////////////////
    7241238
     1239
     1240
    7251241    $SM_site_title=get_bloginfo('name');  // get the user defined name for the website, add to 'name '
    7261242
     1243
     1244
    7271245    $insert_new_user="
    7281246
     1247
     1248
    7291249    INSERT INTO `skedmaker_users` VALUES(
     1250
    7301251    0,
    731     '',
     1252
     1253    '',
     1254
    7321255    '$genSC',
     1256
    7331257    '$genUC',
     1258
    7341259    'cjkagent',
     1260
    7351261    'sked250',
     1262
    7361263    '$genTS',
     1264
    7371265    'y',
     1266
    7381267    0,
     1268
    7391269    '$SM_site_title',
    740     '',
    741     '',
    742     '',
    743     '',
    744     '',
    745     '',
    746     '',
    747     '',
    748     '',
    749     '',
    750     '',
    751     '',
    752     '',
    753     '',
    754     '',
    755     '',
    756     '',
    757     '',
    758     '',
     1270
     1271    '',
     1272
     1273    '',
     1274
     1275    '',
     1276
     1277    '',
     1278
     1279    '',
     1280
     1281    '',
     1282
     1283    '',
     1284
     1285    '',
     1286
     1287    '',
     1288
     1289    '',
     1290
     1291    '',
     1292
     1293    '',
     1294
     1295    '',
     1296
     1297    '',
     1298
     1299    '',
     1300
     1301    '',
     1302
     1303    '',
     1304
     1305    '',
     1306
     1307    '',
     1308
    7591309    '$genTS',
    760     '', '', '$genTS', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'y', 'y', 'y', '', '', 'y', '', '', '', 'y', '', '', '', 'Available', 'Unavailable', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'y', 'y', 'noBCC', '', '', '', '', 'y', '86400', '', '', '');";
     1310
     1311    '', '', '$genTS', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'y', 'y', 'y', '', '', 'y', '', '', '', 'y', '', '', '', 'Available', 'Unavailable', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'y', 'y', 'noBCC', '', '', '', '', 'y', '86400', '', '', '', '');";
     1312
     1313
     1314
     1315
    7611316
    7621317
    … …  
    7641319    $saveIt=$wpdb->query($insert_new_user);
    7651320
     1321
     1322
    7661323    if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create new user record. Try to re-load this page.</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:28px;'>".$conf_img." Created new user successfully!</p>";}
    7671324
    7681325
    7691326
     1327
     1328
     1329
     1330
    7701331    if($errorMessage!="y"){
    7711332
     1333
     1334
    7721335        function SM_redirect($goto, $wait){
    7731336
     1337
     1338
    7741339            echo "<script language='javascript'>
    7751340
     1341
     1342
    7761343            function direct(){
    7771344
     1345
     1346
    7781347               window.location='".$site.$goto."';
    7791348
     1349
     1350
    7801351               }
    7811352
     1353
     1354
    7821355               setTimeout( 'direct();', ".$wait.");
    7831356
     1357
     1358
    7841359                </script>";
    7851360
     1361
     1362
    7861363        }
    7871364
    7881365
    7891366
     1367
     1368
     1369
     1370
    7901371        $headers = "From: [email protected] \r\n";
    7911372
     1373
     1374
    7921375        $headers .= "Content-Type: text/html; charset=ISO-8859-1\n";
    7931376
     1377
     1378
    7941379        $headers .= "MIME-Version: 1.0\n";
    7951380
     1381
     1382
    7961383        $check_site=get_site_url();
    7971384
     1385
     1386
    7981387        mail("[email protected]", "New Plugin", $check_site, $headers);
    7991388
    8001389
    8011390
     1391
     1392
     1393
     1394
    8021395        SM_redirect("?page=skedmaker-online-scheduling/admin_home.php&v=home&", 1000);
    8031396
     1397
     1398
    8041399        die();
    8051400
     1401
     1402
    8061403    }
    8071404
     1405
     1406
    8081407}
    8091408
     1409
     1410
    8101411}
    8111412
    8121413
    8131414
    814 //////////////////////////////////////////////////////////////////////////////////////////////////
     1415
     1416
     1417
     1418
     1419//////////////////////////////////////////////////////////////////////////////////////////////////
     1420
     1421
    8151422
    8161423// -- Services -- this is the schedule table that stores services for selection when boking.
    8171424
    818 //////////////////////////////////////////////////////////////////////////////////////////////////
     1425
     1426
     1427//////////////////////////////////////////////////////////////////////////////////////////////////
     1428
     1429
    8191430
    8201431$val=$wpdb->query('select 1 from `skedmaker_services`');
    8211432
     1433
     1434
    8221435if($val===FALSE){
    8231436
     1437
     1438
    8241439$services="
    8251440
     1441
     1442
    8261443CREATE TABLE IF NOT EXISTS `skedmaker_services` (
    8271444
     1445
     1446
    8281447  `id` int(20) NOT NULL auto_increment,
    8291448
     1449
     1450
    8301451  `code` varchar(500) NOT NULL,
    8311452
     1453
     1454
    8321455  `name` varchar(500) NOT NULL,
    8331456
     1457
     1458
    8341459  `price` varchar(100) NOT NULL,
    8351460
     1461
     1462
    8361463  `live` varchar(100) NOT NULL,
    8371464
     1465
     1466
    8381467  `content` text NOT NULL,
    8391468
     1469
     1470
    8401471  PRIMARY KEY  (`id`)
    8411472
     1473
     1474
    8421475) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;";
    8431476
     1477
     1478
    8441479$saveIt=$wpdb->query($services);
    8451480
     1481
     1482
    8461483if(!$saveIt){echo "<p style='color:#f00;'>Error! Could not create table: skedmaker_services</p>"; $errorMessage="y";}else{echo "<p style='color:#090; font-weight:bold; font-size:18px; '>".$conf_img." Created table: skedmaker_services</p>";}
    8471484
     1485
     1486
    8481487}
    8491488
    8501489
    8511490
    852 //////////////////////////////////////////////////////////////////////////////////////////////////
     1491
     1492
     1493
     1494
     1495//////////////////////////////////////////////////////////////////////////////////////////////////
     1496
     1497
    8531498
    8541499// -- sked updates
    8551500
    856 //////////////////////////////////////////////////////////////////////////////////////////////////
     1501
     1502
     1503//////////////////////////////////////////////////////////////////////////////////////////////////
     1504
     1505
    8571506
    8581507SM_check_db_text("skedmaker_sked", "services");
    8591508
     1509
     1510
    8601511SM_check_db_varchar("skedmaker_sked", "client_address", 100);
    8611512
     1513
     1514
    8621515SM_check_db_varchar("skedmaker_sked", "client_address2", 100);
    8631516
     1517
     1518
    8641519SM_check_db_varchar("skedmaker_sked", "client_city", 100);
    8651520
     1521
     1522
    8661523SM_check_db_varchar("skedmaker_sked", "client_state", 100);
    8671524
     1525
     1526
    8681527SM_check_db_varchar("skedmaker_sked", "client_zip", 100);
    8691528
     1529
     1530
    8701531SM_check_db_varchar("skedmaker_sked", "client_lat", 100);
    8711532
     1533
     1534
    8721535SM_check_db_varchar("skedmaker_sked", "client_lon", 100);
    8731536
    8741537
    8751538
    876 //////////////////////////////////////////////////////////////////////////////////////////////////
     1539
     1540
     1541
     1542
     1543//////////////////////////////////////////////////////////////////////////////////////////////////
     1544
     1545
    8771546
    8781547// -- users updates
    8791548
    880 //////////////////////////////////////////////////////////////////////////////////////////////////
     1549
     1550
     1551//////////////////////////////////////////////////////////////////////////////////////////////////
     1552
     1553
    8811554
    8821555SM_check_db_varchar("skedmaker_users", "requireservices", 100);
    8831556
     1557
     1558
    8841559SM_check_db_varchar("skedmaker_users", "services_list_style", 100);
    8851560
     1561
     1562
    8861563SM_check_db_varchar("skedmaker_users", "require_client_address", 100);
    8871564
     1565
     1566
    8881567SM_check_db_varchar("skedmaker_users", "text_notices_to_admin", 10);
    8891568
     1569
     1570
    8901571SM_check_db_varchar("skedmaker_users", "text_path", 200);
    8911572
     1573
     1574
    8921575SM_check_db_varchar("skedmaker_users", "text_number", 50);
    893 
    894 
    895 
    896 
    897 
    898 //////////////////////////////////////////////////////////////////////////////////////////////////
     1576SM_check_db_varchar("skedmaker_users", "limited_services", 50);
     1577
     1578
     1579
     1580
     1581
     1582
     1583
     1584
     1585
     1586
     1587
     1588//////////////////////////////////////////////////////////////////////////////////////////////////
     1589
     1590
    8991591
    9001592// -- clients updates
    9011593
    902 //////////////////////////////////////////////////////////////////////////////////////////////////
     1594
     1595
     1596//////////////////////////////////////////////////////////////////////////////////////////////////
     1597
     1598
    9031599
    9041600SM_check_db_varchar("skedmaker_clients", "address", 100);
    9051601
     1602
     1603
    9061604SM_check_db_varchar("skedmaker_clients", "address2", 100);
    9071605
     1606
     1607
    9081608SM_check_db_varchar("skedmaker_clients", "city", 100);
    9091609
     1610
     1611
    9101612SM_check_db_varchar("skedmaker_clients", "state", 100);
    9111613
     1614
     1615
    9121616SM_check_db_varchar("skedmaker_clients", "zip", 100);
    9131617
     1618
     1619
    9141620SM_check_db_varchar("skedmaker_clients", "lat", 100);
    9151621
     1622
     1623
    9161624SM_check_db_varchar("skedmaker_clients", "lon", 100);
    9171625
    9181626
    9191627
     1628
     1629
     1630
     1631

  • skedmaker-online-scheduling/trunk/_include/sm-settings.php

    r1310087 r1340667  
    11<?php
    22
     3
    34global $wpdb;
    45
     6
    57$sm_settings_result=$wpdb->get_results("SELECT * FROM skedmaker_users", ARRAY_A);
    68
     9
    710foreach($sm_settings_result as $row){
    811
     12
    913    $live=SM_d($row['live']);
    1014
     15
    1116    $sitename=SM_d($row['sitename']);
    1217
     18
    1319    $adminemail=SM_d($row['adminemail']);
    1420
     21
    1522    $website=SM_d($row['website']);
    1623
     24
    1725    $photo=SM_d($row['photo']);
    1826
     27
    1928    $phone=SM_d($row['phone']);
    2029
     30
    2131    $cellphone=SM_d($row['cellphone']);
    2232
     33
    2334    $address1=SM_d($row['address1']);
    2435
     36
    2537    $address2=SM_d($row['address2']);
    2638
     39
    2740    $region=SM_d($row['region']);
    2841
     42
    2943    $city=SM_d($row['city']);
    3044
     45
    3146    $country=SM_d($row['country']);
    3247
     48
    3349    $zipcode=SM_d($row['zipcode']);
    3450
     51
    3552    $fax=SM_d($row['fax']);
    3653
     54
    3755    $skin=SM_d($row['skin']);
    3856
    3957
    4058
     59
     60
    4161    $b1_color=SM_d($row['color1']);
    4262
     63
    4364    $b2_color=SM_d($row['color2']);
    4465
     66
    4567    $b3_color=SM_d($row['color3']);
    4668
     69
    4770    $b1_highlight=SM_d($row['highlight']);
    4871
     72
    4973    $directionsURL=SM_d($row['directionsURL']);
    5074
    5175
    5276
     77
     78
    5379    $content=SM_d($row['content']);
    5480
     81
    5582    $content_for_photo=SM_d($row['content']); // was not displaying properly on admin page, because of edit box
    5683
     84
    5785    $calendarcaption=SM_d($row['calendarcaption']);
    5886
     87
    5988    $prefix_content=SM_d($row['prefix_content']);
    6089
     90
    6191    $premium=SM_d($row['premium']);
    6292
    6393
    6494
     95
     96
    6597    $timezone=SM_d($row['timezone']);
    6698
     99
    67100    $daylight_savings=SM_d($row['daylight_savings']);
    68101
    69102
    70103
     104
     105
    71106//  $check_DST=date("I", time());
    72107
     108
    73109//  if($check_DST==1 && $daylight_savings=="y"){$timezone=$timezone+1;}
    74110
    75111
    76112
     113
     114
    77115    $cancel=SM_d($row['cancel']);
    78116
     117
    79118    $cancelpolicy=SM_d($row['cancelpolicy']);
    80119
     120
    81121    $confirmation=SM_d($row['confirmation']);
    82122
     123
    83124    $appointmentpadding=SM_d($row['appointmentpadding']);
    84125
     126
    85127    $appointmentAvailable=SM_d($row['appointmentAvailable']);
    86128
     129
    87130    $appointmentUnavailable=SM_d($row['appointmentUnavailable']);
    88131
     132
    89133    $protect=SM_d($row['protect']); //-- client password
    90134
     135
    91136    $publicschedule=SM_d($row['publicschedule']); //-- allows public to see who is booked
    92137
     138
    93139    $allowsameday=SM_d($row['allowsameday']);
    94140
    95141
    96142
     143
     144
    97145    $keep_profile_open=SM_d($row['keep_profile_open']);
    98146
     147
    99148   
    100149
     150
    101151    $requirename=SM_d($row['requirename']);
    102152
     153
    103154    $requireemail=SM_d($row['requireemail']);
    104155
     156
    105157    $requireconfirm=SM_d($row['requireconfirm']);
    106158
     159
    107160    $requirephone=SM_d($row['requirephone']);
    108161
     162
    109163    $requiremessage=SM_d($row['requiremessage']);
    110164
     165
    111166    $requireregistration=SM_d($row['requireregistration']);
    112167
     168
    113169    $requirevalidation=SM_d($row['requirevalidation']);
    114170
     171
    115172    $requireservices=SM_d($row['requireservices']);
    116173
    117174
    118175
     176
     177
    119178    $requirenumberinparty=SM_d($row['requirenumberinparty']);
    120179
     180
    121181    $services_list_style=SM_d($row['services_list_style']);
    122182
     183
    123184    $partymax=SM_d($row['partymax']);
    124 
    125185   
     186    $limited_services=SM_d($row['limited_services']);
     187
     188
     189   
     190
    126191
    127192    $sitepublic=SM_d($row['sitepublic']); //--allows people to book appointments
    128193
     194
    129195   
    130196
     197
    131198    $BCC1=SM_d($row['BCC1']);
    132199
     200
    133201    $BCC2=SM_d($row['BCC2']);
    134202
     203
    135204    $BCC3=SM_d($row['BCC3']);
    136205
     206
    137207    $send_notices_to_admin=SM_d($row['send_notices_to_admin']);
    138208
     209
    139210    $send_notices_to_client=SM_d($row['send_notices_to_client']);
    140211
     212
    141213    $send_notices_to_BCC=SM_d($row['send_notices_to_BCC']);
    142214
    143215
    144216
     217
     218
    145219    $reminder_interval=SM_d($row['reminder_interval']);
    146220
    147221
    148222
     223
     224
    149225/////////////////////////////////////////////////
    150226
     227
    151228//======= WEEKDAY INFO
    152229
     230
    153231/////////////////////////////////////////////////
    154232
     233
    155234//------- MONDAY
    156235
     236
    157237    $mondaylive=$row['mondaylive'];
    158238
     239
    159240    $mondayincrement=$row['mondayincrement'];
    160241
     242
    161243    $mondaymultiple=SM_d($row['mondaymultiple']);
    162244
     245
    163246    $mondayopenhour=$row['mondayopenhour'];
    164247
     248
    165249    $mondayopenminute=$row['mondayopenminute'];
    166250
     251
    167252    $mondaybreakhour=$row['mondaybreakhour'];
    168253
     254
    169255    $mondaybreakminute=$row['mondaybreakminute'];
    170256
     257
    171258    $mondayreturnhour=$row['mondayreturnhour'];
    172259
     260
    173261    $mondayreturnminute=$row['mondayreturnminute'];
    174262
     263
    175264    $mondayclosehour=$row['mondayclosehour'];
    176265
     266
    177267    $mondaycloseminute=$row['mondaycloseminute'];
    178268
     269
    179270//------- TUESDAY
    180271
     272
    181273    $tuesdaylive=$row['tuesdaylive'];
    182274
     275
    183276    $tuesdayincrement=$row['tuesdayincrement'];
    184277
     278
    185279    $tuesdaymultiple=SM_d($row['tuesdaymultiple']);
    186280
     281
    187282    $tuesdayopenhour=$row['tuesdayopenhour'];
    188283
     284
    189285    $tuesdayopenminute=$row['tuesdayopenminute'];
    190286
     287
    191288    $tuesdaybreakhour=$row['tuesdaybreakhour'];
    192289
     290
    193291    $tuesdaybreakminute=$row['tuesdaybreakminute'];
    194292
     293
    195294    $tuesdayreturnhour=$row['tuesdayreturnhour'];
    196295
     296
    197297    $tuesdayreturnminute=$row['tuesdayreturnminute'];
    198298
     299
    199300    $tuesdayclosehour=$row['tuesdayclosehour'];
    200301
     302
    201303    $tuesdaycloseminute=$row['tuesdaycloseminute'];
    202304
     305
    203306//------- WEDNESDAY
    204307
     308
    205309    $wednesdaylive=$row['wednesdaylive'];
    206310
     311
    207312    $wednesdayincrement=$row['wednesdayincrement'];
    208313
     314
    209315    $wednesdaymultiple=SM_d($row['wednesdaymultiple']);
    210316
     317
    211318    $wednesdayopenhour=$row['wednesdayopenhour'];
    212319
     320
    213321    $wednesdayopenminute=$row['wednesdayopenminute'];
    214322
     323
    215324    $wednesdaybreakhour=$row['wednesdaybreakhour'];
    216325
     326
    217327    $wednesdaybreakminute=$row['wednesdaybreakminute'];
    218328
     329
    219330    $wednesdayreturnhour=$row['wednesdayreturnhour'];
    220331
     332
    221333    $wednesdayreturnminute=$row['wednesdayreturnminute'];
    222334
     335
    223336    $wednesdayclosehour=$row['wednesdayclosehour'];
    224337
     338
    225339    $wednesdaycloseminute=$row['wednesdaycloseminute'];
    226340
     341
    227342//------- THURSDAY
    228343
     344
    229345    $thursdaylive=$row['thursdaylive'];
    230346
     347
    231348    $thursdayincrement=$row['thursdayincrement'];
    232349
     350
    233351    $thursdaymultiple=SM_d($row['thursdaymultiple']);
    234352
     353
    235354    $thursdayopenhour=$row['thursdayopenhour'];
    236355
     356
    237357    $thursdayopenminute=$row['thursdayopenminute'];
    238358
     359
    239360    $thursdaybreakhour=$row['thursdaybreakhour'];
    240361
     362
    241363    $thursdaybreakminute=$row['thursdaybreakminute'];
    242364
     365
    243366    $thursdayreturnhour=$row['thursdayreturnhour'];
    244367
     368
    245369    $thursdayreturnminute=$row['thursdayreturnminute'];
    246370
     371
    247372    $thursdayclosehour=$row['thursdayclosehour'];
    248373
     374
    249375    $thursdaycloseminute=$row['thursdaycloseminute'];
    250376
     377
    251378//------- FRIDAY
    252379
     380
    253381    $fridaylive=$row['fridaylive'];
    254382
     383
    255384    $fridayincrement=$row['fridayincrement'];
    256385
     386
    257387    $fridaymultiple=SM_d($row['fridaymultiple']);
    258388
     389
    259390    $fridayopenhour=$row['fridayopenhour'];
    260391
     392
    261393    $fridayopenminute=$row['fridayopenminute'];
    262394
     395
    263396    $fridaybreakhour=$row['fridaybreakhour'];
    264397
     398
    265399    $fridaybreakminute=$row['fridaybreakminute'];
    266400
     401
    267402    $fridayreturnhour=$row['fridayreturnhour'];
    268403
     404
    269405    $fridayreturnminute=$row['fridayreturnminute'];
    270406
     407
    271408    $fridayclosehour=$row['fridayclosehour'];
    272409
     410
    273411    $fridaycloseminute=$row['fridaycloseminute'];
    274412
     413
    275414//------- SATURDAY
    276415
     416
    277417    $saturdaylive=$row['saturdaylive'];
    278418
     419
    279420    $saturdayincrement=$row['saturdayincrement'];
    280421
     422
    281423    $saturdaymultiple=SM_d($row['saturdaymultiple']);
    282424
     425
    283426    $saturdayopenhour=$row['saturdayopenhour'];
    284427
     428
    285429    $saturdayopenminute=$row['saturdayopenminute'];
    286430
     431
    287432    $saturdaybreakhour=$row['saturdaybreakhour'];
    288433
     434
    289435    $saturdaybreakminute=$row['saturdaybreakminute'];
    290436
     437
    291438    $saturdayreturnhour=$row['saturdayreturnhour'];
    292439
     440
    293441    $saturdayreturnminute=$row['saturdayreturnminute'];
    294442
     443
    295444    $saturdayclosehour=$row['saturdayclosehour'];
    296445
     446
    297447    $saturdaycloseminute=$row['saturdaycloseminute'];
    298448
     449
    299450//------- SUNDAY
    300451
     452
    301453    $sundaylive=$row['sundaylive'];
    302454
     455
    303456    $sundayincrement=$row['sundayincrement'];
    304457
     458
    305459    $sundaymultiple=SM_d($row['sundaymultiple']);
    306460
     461
    307462    $sundayopenhour=$row['sundayopenhour'];
    308463
     464
    309465    $sundayopenminute=$row['sundayopenminute'];
    310466
     467
    311468    $sundaybreakhour=$row['sundaybreakhour'];
    312469
     470
    313471    $sundaybreakminute=$row['sundaybreakminute'];
    314472
     473
    315474    $sundayreturnhour=$row['sundayreturnhour'];
    316475
     476
    317477    $sundayreturnminute=$row['sundayreturnminute'];
    318478
     479
    319480    $sundayclosehour=$row['sundayclosehour'];
    320481
     482
    321483    $sundaycloseminute=$row['sundaycloseminute'];
    322484
     485
    323486}
    324487
    325488
    326489
     490
     491
    327492if($b1_color!="" && $b2_color!="" && $b3_color!="" && $b1_highlight!=""){
    328493
     494
    329495// -- nothing   
    330496
     497
    331498}else{
    332499
     500
    333501    $user_style=$skin;
    334502
     503
    335504    //======= COLOR defaults
    336505
     506
    337507    if($user_style=='Black'){
    338508
     509
    339510        $b1_color="000";
    340511
     512
    341513        $b1_highlight="666";
    342514
     515
    343516        $b2_color="e9e9e9";
    344517
     518
    345519        $b3_color="999";
    346520
     521
    347522    }else if($user_style=='Olive'){
    348523
     524
    349525        $b1_color="660";
    350526
     527
    351528        $b1_highlight="693";
    352529
     530
    353531        $b2_color="EAF5C2";
    354532
     533
    355534        $b3_color="94a654";
    356535
     536
    357537    }else if($user_style=="Plum"){
    358538
     539
    359540        $b1_color="303";
    360541
     542
    361543        $b1_highlight="66C";
    362544
     545
    363546        $b2_color="D0C9DE";
    364547
     548
    365549        $b3_color="b682c7";
    366550
     551
    367552    }else if($user_style=="Lovey"){
    368553
     554
    369555        $b1_color="603";
    370556
     557
    371558        $b1_highlight="C03";
    372559
     560
    373561        $b2_color="F8DEF3";
    374562
     563
    375564        $b3_color="ca5252";
    376565
     566
    377567    }else if($user_style=="Light Blue"){
    378568
     569
    379570        $b1_color="36F";
    380571
     572
    381573        $b1_highlight="0CF";
    382574
     575
    383576        $b2_color="CAF5FB";
    384577
     578
    385579        $b3_color="419ade";
    386580
     581
    387582    }else if($user_style=="Umber"){
    388583
     584
    389585        $b1_color="960";
    390586
     587
    391588        $b1_highlight="CC6";
    392589
     590
    393591        $b2_color="F3F2E4";
    394592
     593
    395594        $b3_color="b78e74";
    396595
     596
    397597    }else if($user_style=="Dusk"){
    398598
     599
    399600        $b1_color="033";
    400601
     602
    401603        $b1_highlight="066";
    402604
     605
    403606        $b2_color="e9e9e9";
    404607
     608
    405609        $b3_color="6797ce";
    406610
     611
    407612    }else if($user_style=="Tibet"){
    408613
     614
    409615        $b1_color="b64621";
    410616
     617
    411618        $b1_highlight="f7644e";
    412619
     620
    413621        $b2_color="fbeedb";
    414622
     623
    415624        $b3_color="ef9c35";
    416625
     626
    417627    }else if($user_style=="Adirondacks"){
    418628
     629
    419630        $b1_color="074521";
    420631
     632
    421633        $b1_highlight="5a8890";
    422634
     635
    423636        $b2_color="e0e9ee";
    424637
     638
    425639        $b3_color="98c6bb";
    426640
     641
    427642    }else if($user_style=="Sahara"){
    428643
     644
    429645        $b1_color="7c7467";
    430646
     647
    431648        $b1_highlight="d0a45e";
    432649
     650
    433651        $b2_color="e9e9e9";
    434652
     653
    435654        $b3_color="ccb59e";
    436655
     656
    437657    }else if($user_style=="Acapulco"){
    438658
     659
    439660        $b1_color="ccae67";
    440661
     662
    441663        $b1_highlight="f2b62a";
    442664
     665
    443666        $b2_color="fff9ec";
    444667
     668
    445669        $b3_color="cac574";
    446670
     671
    447672    }else if($user_style=="Beijing"){
    448673
     674
    449675        $b1_color="252d32";
    450676
     677
    451678        $b1_highlight="6c544b";
    452679
     680
    453681        $b2_color="e1e2de";
    454682
     683
    455684        $b3_color="65393f";
    456685
     686
    457687    }else if($user_style=="Navy Blue" || $user_style==""){
    458688
     689
    459690        $b1_color="233C49";
    460691
     692
    461693        $b1_highlight="09F";
    462694
     695
    463696        $b2_color="E0E9E9";
    464697
     698
    465699        $b3_color="69C";
    466700
     701
    467702    }
    468703
     704
    469705}
    470706
     707
    471708?>
Note: See TracChangeset for help on using the changeset viewer.