[44] | 1 | <?php
|
---|
| 2 |
|
---|
| 3 | /*
|
---|
| 4 | * odl_functions.php
|
---|
| 5 | * wordpress plugin website directory project
|
---|
| 6 | * This file contains the ODLinks functions
|
---|
| 7 | * @author website: http://www.forgani.com
|
---|
| 8 | * @copyright Copyright 2008, Mohammad Forgani
|
---|
| 9 | * @version 1.0
|
---|
| 10 | * @link
|
---|
| 11 | */
|
---|
| 12 |
|
---|
| 13 | function process_odlinkssettings(){
|
---|
| 14 | global $_GET, $_POST, $wp_rewrite, $PHP_SELF, $wpdb, $table_prefix, $odlinksversion, $wp_version;
|
---|
| 15 |
|
---|
| 16 | $odlinkssettings = get_option('odlinksdata');
|
---|
| 17 |
|
---|
| 18 | switch ($_GET['odlinks_admin_action']){
|
---|
| 19 | case "savesettings":
|
---|
| 20 | foreach ($_POST["odlinksdata"] as $k=>$v){
|
---|
| 21 | $_POST["odlinksdata"][$k] = stripslashes($v);
|
---|
| 22 | }
|
---|
| 23 | $_POST['odlinksdata']['odlinksinstalled'] = 'y';
|
---|
| 24 | $_POST['odlinksdata']['odlinksversion'] = $odlinksversion;
|
---|
| 25 | $odl_new_slug = $_POST['odlinksdata']['odlinksslug'];
|
---|
| 26 | $odlinkssettings = get_option('odlinksdata');
|
---|
| 27 | $odl_slug_check = $wpdb->get_results("SELECT post_name FROM {$table_prefix}posts WHERE post_name = '".$wpdb->escape($odl_new_slug)."'");
|
---|
| 28 | $odl_slug_checked = $odl_slug_check[0];
|
---|
| 29 | $odlinkswp_pageinfo = $wpdb->get_row("SELECT * FROM {$table_prefix}posts WHERE post_title = '[[ODLINKS]]'", ARRAY_A);
|
---|
| 30 |
|
---|
| 31 | if ($odlinkswp_pageinfo["post_title"]!="[[ODLINKS]]"){
|
---|
| 32 | $odlinkswp_pageinfo = odlinkscreate_page();
|
---|
| 33 | }
|
---|
| 34 |
|
---|
| 35 | $msg = "Settings Updated.";
|
---|
| 36 |
|
---|
| 37 | if($odl_new_slug!=$odlinkssettings['odlinksslug']){
|
---|
| 38 | if($odl_slug_checked->post_name!=$odl_new_slug){
|
---|
| 39 | $wpdb->query("UPDATE {$table_prefix}posts SET post_name = '".$odl_new_slug."' WHERE post_title = '[[ODLINKS]]'");
|
---|
| 40 | $msg ="Settings Updated.";
|
---|
| 41 | }else{
|
---|
| 42 | $msg ="Settings Updated but a Slug exists with the name: ".$odl_new_slug."<br />"."Try Again.";
|
---|
| 43 | $_POST['odlinksdata']['odlinksslug'] = $odlinkssettings['odlinksslug'];
|
---|
| 44 | }
|
---|
| 45 | }
|
---|
| 46 |
|
---|
| 47 | $odlinksnew_settings = array();
|
---|
| 48 | $odlinksnew_settings = $_POST['odlinksdata'];
|
---|
| 49 | update_option('odlinksdata', $odlinksnew_settings);
|
---|
| 50 | $wp_rewrite->flush_rules();
|
---|
| 51 | odlinkscheck_db();
|
---|
| 52 | $odlinkssettings = get_option('odlinksdata');
|
---|
| 53 | break;
|
---|
| 54 | }
|
---|
| 55 |
|
---|
| 56 | odlinksinstall();
|
---|
| 57 |
|
---|
| 58 | if ($msg!=''){
|
---|
| 59 | ?>
|
---|
| 60 | <div id="message" class="updated fade">
|
---|
| 61 | <?php echo $msg;?>
|
---|
| 62 | </div>
|
---|
| 63 | <?php
|
---|
| 64 | }
|
---|
| 65 |
|
---|
| 66 | $odlinkssettings = get_option('odlinksdata');
|
---|
| 67 |
|
---|
| 68 | $selflink = ($wp_rewrite->get_page_permastruct()=="")?"<a href=\"".get_bloginfo('url')."/index.php?pagename=".$odlinkssettings['odlinksslug']."\">".get_bloginfo('url')."/index.php?pagename=".$odlinkssettings['odlinksslug']."</a>":"<a href=\"".get_bloginfo('url')."/".$odlinkssettings['odlinksslug']."/\">".get_bloginfo('url')."/".$odlinkssettings['odlinksslug']."/</a>";
|
---|
| 69 |
|
---|
| 70 | $pageinfo = odlinksget_pageinfo();
|
---|
| 71 | ?>
|
---|
| 72 | <div class="wrap">
|
---|
| 73 | <h2>General Settings</h2>
|
---|
| 74 | <p>
|
---|
| 75 | <form method="post" id="odl_form_post" name="odl_form_post" action="<?php echo $PHP_SELF;?>?page=odlinks&odlinks_admin_page_arg=<?php echo $_GET['odlinks_admin_page_arg'];?>&odlinks_admin_action=savesettings">
|
---|
| 76 | <input type="hidden" name="odlinksdata[odlinksversion]" value="<?php echo $odlinksversion;?>">
|
---|
| 77 | <table border="0" class="editform">
|
---|
| 78 | <tr>
|
---|
| 79 | <th align="right">odlinks Version:</th>
|
---|
| 80 | <td><?php echo $odlinksversion;?></td>
|
---|
| 81 | </tr>
|
---|
| 82 | <tr><th align="right">WordPress Version:</th>
|
---|
| 83 | <td><?php echo $wp_version;?></td>
|
---|
| 84 | </tr>
|
---|
| 85 | <tr><th align="right">odlinks URL:</th>
|
---|
| 86 | <td><?php echo $selflink;?></td>
|
---|
| 87 | </tr>
|
---|
| 88 | <tr><th align="right">odlinks Slug:</th>
|
---|
| 89 | <td><input type="text" size="25" name="odlinksdata[odlinksslug]" value="<?php echo str_replace('"', """, stripslashes($odlinkssettings['odlinksslug']));?>">
|
---|
| 90 | </td>
|
---|
| 91 | </tr>
|
---|
| 92 | <tr>
|
---|
| 93 | <th align="right"> </th>
|
---|
| 94 | <td><input type="checkbox" name="odlinksdata[odlinksshow_credits]" value="y"<?php echo ($odlinkssettings['odlinksshow_credits']=='y')?" checked":"";?>> Display odlinks credit line at the bottom of ODLinks pages
|
---|
| 95 | </td>
|
---|
| 96 | </tr>
|
---|
| 97 | <tr>
|
---|
| 98 | <th align="right">ODLinks Page Link Name:</th>
|
---|
| 99 | <td><input type="text" name="odlinksdata[page_link_title]" value="<?php echo $odlinkssettings['page_link_title'];?>">
|
---|
| 100 | </td>
|
---|
| 101 | </tr>
|
---|
| 102 | <tr><th align="right">Number Of 'Last Links':</th>
|
---|
| 103 | <td>
|
---|
| 104 | <input type="text" size="4" name="odlinksdata[odlinks_last_links_num]" value="<?php echo ($odlinkssettings['odlinks_last_links_num']);?>" onchange="this.value=this.value*1;">
|
---|
| 105 | </td>
|
---|
| 106 | </tr>
|
---|
| 107 | <tr><th align="right"> </th>
|
---|
| 108 | <td><input type="checkbox" name="odlinksdata[odlinks_last_links]" value="y"<?php echo ($odlinkssettings['odlinks_last_links']=='y')?" checked":"";?>> Display 'Last Links' Post.
|
---|
| 109 | </td>
|
---|
| 110 | </tr>
|
---|
| 111 | <tr><th align="right">Excerpt Length:</th>
|
---|
| 112 | <td><input type="text" size="4" name="odlinksdata[odlinks_excerpt_length]" value="<?php echo ($odlinkssettings['odlinks_excerpt_length']);?>" onchange="this.value=this.value*1;">
|
---|
| 113 | </td>
|
---|
| 114 | </tr>
|
---|
| 115 | <tr><th align="right">Display # of new/updated links:</th>
|
---|
| 116 | <td><input type="text" size="4" name="odlinksdata[odlinks_new_links]" value="<?php echo ($odlinkssettings['odlinks_new_links']);?>" onchange="this.value=this.value*1;">
|
---|
| 117 | </td>
|
---|
| 118 | </tr>
|
---|
| 119 | <tr><th align="right">of subcategories under each category link:</th>
|
---|
| 120 | <td><input type="text" size="4" name="odlinksdata[odlinks_sub_cat_num]" value="<?php echo ($odlinkssettings['odlinks_sub_cat_num']);?>" onchange="this.value=this.value*1;">
|
---|
| 121 | </td>
|
---|
| 122 | </tr>
|
---|
| 123 | <tr><th align="right">of subcategories to display under each category:</th>
|
---|
| 124 | <td><input type="text" size="4" name="odlinksdata[odlinks_num_links]" value="<?php echo ($odlinkssettings['odlinks_num_links']);?>" onchange="this.value=this.value*1;">
|
---|
| 125 | </td>
|
---|
| 126 | </tr>
|
---|
| 127 |
|
---|
| 128 | <tr><th align="right">number of links per page to display in categories:</th>
|
---|
| 129 | <td><input type="text" size="4" name="odlinksdata[odlinks_num_pages]" value="<?php echo ($odlinkssettings['odlinks_num_pages']);?>" onchange="this.value=this.value*1;">
|
---|
| 130 | </td>
|
---|
| 131 | </tr>
|
---|
| 132 |
|
---|
| 133 | <tr><th align="right">ODLinks Top Image:</th>
|
---|
| 134 | <td><input type="text" size="25" name="odlinksdata[odlinks_top_image]" value="<?php echo ($odlinkssettings['odlinks_top_image']);?>">
|
---|
| 135 | </td>
|
---|
| 136 | </tr>
|
---|
| 137 |
|
---|
| 138 | <tr><th align="right">Show the confirmation code: </th>
|
---|
| 139 | <td><input type=checkbox name="odlinksdata[confirmation_code]" value="y"<?php echo ($odlinkssettings['confirmation_code']=='y')?" checked":"";?>></td>
|
---|
| 140 | </tr>
|
---|
| 141 | <tr><td colspan=2><hr /><strong>Google AdSense for Open Directory Links</strong><hr /></td></tr>
|
---|
| 142 | <?php
|
---|
| 143 | //for upgrade versions
|
---|
| 144 | if (!$odlinkssettings[GADcolor_border]) $odlinkssettings[GADcolor_border]= 'FFFFFF';
|
---|
| 145 | if (!$odlinkssettings[GADcolor_link]) $odlinkssettings[GADcolor_link]= '0000FF';
|
---|
| 146 | if (!$odlinkssettings[GADcolor_bg]) $odlinkssettings[GADcolor_bg]= 'FFFFFF';
|
---|
| 147 | if (!$odlinkssettings[GADcolor_text]) $odlinkssettings[GADcolor_text]= '000000';
|
---|
| 148 | if (!$odlinkssettings[GADcolor_url]) $odlinkssettings[GADcolor_url]= 'FF0000';
|
---|
| 149 | if (!$odlinkssettings[GADposition]) $odlinkssettings[GADposition]= 'btn';
|
---|
| 150 | if (!$odlinkssettings[GADproduct]) $odlinkssettings[GADproduct]= 'link';
|
---|
| 151 | if (!$odlinkssettings[googleID]) $odlinkssettings[googleID] = 'pub-2844370112691023';
|
---|
| 152 | $GADpos = array ('top' => 'top','btn' => 'bottom', 'bth' => 'both','no' => 'none');
|
---|
| 153 | ?>
|
---|
| 154 | <tr>
|
---|
| 155 | <th align="right" valign="top"><a href='https://www.google.com/adsense/' target='google'>Google AdSense Account ID: </a></th>
|
---|
| 156 | <td><input type='text' name='odlinksdata[googleID]' id='odlinksdata[googleID]' value="<?php echo ($odlinkssettings['googleID']);?>" size='22' /><br><span class="smallTxt"> example: no, pub-2844370112691023 or ...
|
---|
| 157 | </span></td></tr>
|
---|
| 158 | <tr>
|
---|
| 159 | <th align="right" valign="top">Google Ad Position: </th>
|
---|
| 160 | <td>
|
---|
| 161 | <select name="odlinksdata[GADposition]" tabindex="1">
|
---|
| 162 | <?php
|
---|
| 163 | foreach($GADpos as $key=>$value) {
|
---|
| 164 | if ($key == $odlinkssettings[GADposition]) {
|
---|
| 165 | echo "\n<option value='$key' selected='selected'>$value</option>\n";
|
---|
| 166 | } else {
|
---|
| 167 | echo "\n<option value='$key'>$value</option>\n";
|
---|
| 168 | }
|
---|
| 169 | }
|
---|
| 170 | ?>
|
---|
| 171 | </select> <span class="smallTxt">(If this value is assigned to 'none' then the Google Ads will not show up)</small>
|
---|
| 172 | </td>
|
---|
| 173 | </tr>
|
---|
| 174 |
|
---|
| 175 | <?php
|
---|
| 176 | $share = '10'; // my smallest cut on ad revenue is 10% -
|
---|
| 177 | while($share<101){
|
---|
| 178 | if($share==$odlinkssettings['share']){
|
---|
| 179 | $share_list .= "<option value='$share' selected='selected'>$share%\n";
|
---|
| 180 | }else{
|
---|
| 181 | $share_list .= "<option value='$share'>$share%\n";
|
---|
| 182 | }
|
---|
| 183 | ++$share;
|
---|
| 184 | }
|
---|
| 185 | ?>
|
---|
| 186 | <tr>
|
---|
| 187 | <th align="right" valign="top"><label>Plugin Author Ad Share: </label></th>
|
---|
| 188 | <td>
|
---|
| 189 | <select name='odlinksdata[share]'><?php echo $share_list;?></select>
|
---|
| 190 | </td>
|
---|
| 191 | </tr>
|
---|
| 192 |
|
---|
| 193 | <?php
|
---|
| 194 | $odlinkssettings[GADproduct] = 'link';
|
---|
| 195 | $lformats=array ('728x15' => '728 x 15', '468x15' => '468 x 15');
|
---|
| 196 | ?>
|
---|
| 197 |
|
---|
| 198 | <th align="right" valign="top"><label>Link Format: </label></th>
|
---|
| 199 | <td><select name="odlinksdata[GADLformat]">
|
---|
| 200 | <?php
|
---|
| 201 | foreach($lformats as $key=>$value) {
|
---|
| 202 | if ($key == $odlinkssettings[GADLformat]) {
|
---|
| 203 | echo "\n<option value='$key' selected='selected'>$value</option>\n";
|
---|
| 204 | } else {
|
---|
| 205 | echo "\n<option value='$key'>$value</option>\n";
|
---|
| 206 | }
|
---|
| 207 | }
|
---|
| 208 | ?>
|
---|
| 209 | </select></td>
|
---|
| 210 | </tr>
|
---|
| 211 | <tr><th align="right">Ad Colours: </th><td></td></tr>
|
---|
| 212 | <tr><td colspan=2 align="center">
|
---|
| 213 | <table><tr>
|
---|
| 214 | <td>Border: </td>
|
---|
| 215 | <td><input name='odlinksdata[GADcolor_border]' id='odlinksdata[GADcolor_border]' size='6' value='<?php echo $odlinkssettings[GADcolor_border]; ?>'/>
|
---|
| 216 | </td>
|
---|
| 217 | <td>Title/Link: </td>
|
---|
| 218 | <td><input name='odlinksdata[GADcolor_link]' id='odlinksdata[GADcolor_link]' size='6' value='<?php echo $odlinkssettings[GADcolor_link]; ?>'/>
|
---|
| 219 | </td>
|
---|
| 220 | <td>Background: </td>
|
---|
| 221 | <td><input name='odlinksdata[GADcolor_bg]' id='odlinksdata[GADcolor_bg]' size='6' value='<?php echo $odlinkssettings[GADcolor_bg]; ?>'/>
|
---|
| 222 | </td>
|
---|
| 223 | <td>Text: </td>
|
---|
| 224 | <td><input name='odlinksdata[GADcolor_text]' id='odlinksdata[GADcolor_text]' size='6' value='<?php echo $odlinkssettings[GADcolor_text]; ?>'/>
|
---|
| 225 | </td>
|
---|
| 226 | <td>URL: </td>
|
---|
| 227 | <td><input name='odlinksdata[GADcolor_url]' id='odlinksdata[GADcolor_url]' size='6' value='<?php echo $odlinkssettings[GADcolor_url]; ?>'/>
|
---|
| 228 | </td>
|
---|
| 229 | </tr>
|
---|
| 230 | </th></tr></table>
|
---|
| 231 | </td></tr>
|
---|
| 232 | <tr><td colspan=2><HR /></td></tr>
|
---|
| 233 | <tr><th> </th>
|
---|
| 234 | <td><p><input type="submit" value="Update ODLinks Settings"></p></td>
|
---|
| 235 | </tr>
|
---|
| 236 | </table>
|
---|
| 237 | </form>
|
---|
| 238 | </p></div>
|
---|
| 239 | <?php
|
---|
| 240 | }
|
---|
| 241 |
|
---|
| 242 | function odlinksinstall(){
|
---|
| 243 | global $odlinksversion;
|
---|
| 244 |
|
---|
| 245 | $odlinkssettings = get_option('odlinksdata');
|
---|
| 246 | $odlinkssettings['odlinksversion'] = $odlinksversion;
|
---|
| 247 |
|
---|
| 248 | if ($odlinkssettings['odlinksinstalled']!='y'){
|
---|
| 249 | $odlinkssettings['odlinksinstalled'] = 'y';
|
---|
| 250 | $odlinkssettings['userfield'] = odlinksget_namefield();
|
---|
| 251 | $odlinkssettings['odlinksadd_into_pages'] = 'y';
|
---|
| 252 | $odlinkssettings['odlinksshow_credits'] = 'y';
|
---|
| 253 | $odlinkssettings['odlinksread_blog'] = 'y';
|
---|
| 254 | $odlinkssettings['odlinksslug'] = 'odlinks';
|
---|
| 255 | $odlinkssettings['page_link_title'] = 'Open Directory Links';
|
---|
| 256 | $odlinkssettings['odlinkstheme'] = 'default';
|
---|
| 257 | $odlinkssettings['odlinks_display_titles'] = 'y';
|
---|
| 258 |
|
---|
| 259 | $odlinkssettings['odlinks_top_image'] = '';
|
---|
| 260 | $odlinkssettings['odlinks_display_last_links'] = 'y';
|
---|
| 261 | $odlinkssettings['odlinks_display_last_post_link'] = 'y';
|
---|
| 262 | $odlinkssettings['odlinks_last_links_num'] = 5;
|
---|
| 263 | $odlinkssettings['odlinks_excerpt_length'] = 100;
|
---|
| 264 | $odlinkssettings['odlinks_last_links'] = "y";
|
---|
| 265 | $odlinkssettings['confirmation_code']="y";
|
---|
| 266 | $odlinkssettings['odlinks_new_links'] = '10';
|
---|
| 267 | $odlinkssettings['odlinks_sub_cat_num'] = '10';
|
---|
| 268 | $odlinkssettings['odlinks_num_links'] = '4';
|
---|
| 269 | $odlinkssettings['odlinks_num_pages'] = '10';
|
---|
| 270 | $odlinkssettings['odlinks_search_log'] = '25';
|
---|
| 271 | //
|
---|
| 272 |
|
---|
| 273 | $odlinkssettings['odlinks_description'] = '';
|
---|
| 274 | $odlinkssettings['odlinks_keywords'] = 'dummy';
|
---|
| 275 |
|
---|
| 276 | $odlinkssettings['googleID'] = 'pub-2844370112691023';
|
---|
| 277 | $odlinkssettings['GADproduct'] = 'link';
|
---|
| 278 | $odlinkssettings['GADLformat'] = '468x15';
|
---|
| 279 | $odlinkssettings['GADtype'] = 'text';
|
---|
| 280 | $odlinkssettings[GADcolor_border]= 'FFFFFF';
|
---|
| 281 | $odlinkssettings[GADcolor_link]= '0000FF';
|
---|
| 282 | $odlinkssettings[GADcolor_bg]= 'E4F2FD';
|
---|
| 283 | $odlinkssettings[GADcolor_text]= '000000';
|
---|
| 284 | $odlinkssettings[GADcolor_url]= 'FF0000';
|
---|
| 285 | $odlinkssettings[GADposition] = 'btn';
|
---|
| 286 | }
|
---|
| 287 |
|
---|
| 288 | update_option('odlinksdata', $odlinkssettings);
|
---|
| 289 | }
|
---|
| 290 |
|
---|
| 291 | function odlinkscheck_db(){
|
---|
| 292 | odlinksupdate_db();
|
---|
| 293 | }
|
---|
| 294 |
|
---|
| 295 | function odlinksupdate_db(){
|
---|
| 296 | global $wpdb, $table_prefix, $odlinksversion;
|
---|
| 297 |
|
---|
| 298 | $odlinkssql[$table_prefix.'odcategories'] = "CREATE TABLE {$table_prefix}odcategories (
|
---|
| 299 | c_id int(11) NOT NULL auto_increment,
|
---|
| 300 | c_parent int(11) NOT NULL default '0',
|
---|
| 301 | c_position int(11) NOT NULL default '0',
|
---|
| 302 | c_name varchar(150) NOT NULL,
|
---|
| 303 | c_title varchar(150) NOT NULL,
|
---|
| 304 | c_description text NOT NULL,
|
---|
| 305 | c_text text NOT NULL,
|
---|
| 306 | c_date date,
|
---|
| 307 | c_keywords text,
|
---|
| 308 | c_status enum('active','inactive','readonly') NOT NULL default 'active',
|
---|
| 309 | c_hide enum('hidden','visible') NOT NULL default 'visible',
|
---|
| 310 | c_links int(11) NOT NULL default '0',
|
---|
| 311 | c_posts int(11) NOT NULL default '0',
|
---|
| 312 | c_rss text,
|
---|
| 313 | PRIMARY KEY (c_id),
|
---|
| 314 | KEY c_parent (c_parent)
|
---|
| 315 | );";
|
---|
| 316 |
|
---|
| 317 | $odlinkssql[$table_prefix.'odbanned'] = "CREATE TABLE {$table_prefix}odbanned (
|
---|
| 318 | b_id int(11) NOT NULL auto_increment,
|
---|
| 319 | c_domain text NOT NULL,
|
---|
| 320 | PRIMARY KEY (b_id)
|
---|
| 321 | );";
|
---|
| 322 |
|
---|
| 323 | /*
|
---|
| 324 | CREATE TABLE search_log (
|
---|
| 325 | id int(11) NOT NULL auto_increment,
|
---|
| 326 | date date NOT NULL default '0000-00-00',
|
---|
| 327 | matches int(11) NOT NULL default '0',
|
---|
| 328 | text text NOT NULL,
|
---|
| 329 | PRIMARY KEY (id),
|
---|
| 330 | FULLTEXT KEY text (text)
|
---|
| 331 | ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
---|
| 332 |
|
---|
| 333 | */
|
---|
| 334 | $odlinkssql[$table_prefix.'odlinks'] = "CREATE TABLE {$table_prefix}odlinks (
|
---|
| 335 | l_id int(11) NOT NULL auto_increment,
|
---|
| 336 | l_c_id int(11) NOT NULL default '0',
|
---|
| 337 | l_date date,
|
---|
| 338 | l_subject varchar(255) NOT NULL default '',
|
---|
| 339 | l_description text NOT NULL default '',
|
---|
| 340 | l_url varchar(255) NOT NULL default '',
|
---|
| 341 | l_posts int(11) NOT NULL default '0',
|
---|
| 342 | l_views int(11) NOT NULL default '0',
|
---|
| 343 | l_sticky enum('y','n') NOT NULL default 'n',
|
---|
| 344 | l_status enum('closed','deleted','open') NOT NULL default 'open',
|
---|
| 345 | l_hide enum('hidden','visible') NOT NULL default 'visible',
|
---|
| 346 | l_author_name varchar(100) NOT NULL default '',
|
---|
| 347 | l_author_ip varchar(15) NOT NULL default '',
|
---|
| 348 | l_author_mail varchar(64) NOT NULL default '',
|
---|
| 349 | l_recip tinyint(4) NOT NULL default '0',
|
---|
| 350 | l_title varchar(255),
|
---|
| 351 | l_google_rank varchar(255),
|
---|
| 352 | PRIMARY KEY (l_id)
|
---|
| 353 | );";
|
---|
| 354 |
|
---|
| 355 | $odlinkssql[$table_prefix.'odpages'] = "CREATE TABLE {$table_prefix}odpages (
|
---|
| 356 | p_id int(11) NOT NULL auto_increment,
|
---|
| 357 | p_l_id int(11) NOT NULL default '0',
|
---|
| 358 | p_url text NOT NULL,
|
---|
| 359 | p_title text NOT NULL,
|
---|
| 360 | p_description text NOT NULL,
|
---|
| 361 | p_google_rank tinyint(4) NOT NULL default '0',
|
---|
| 362 | p_recip tinyint(4) NOT NULL default '0',
|
---|
| 363 | p_date int(20) NOT NULL default '0',
|
---|
| 364 | p_size int(32) NOT NULL default '0',
|
---|
| 365 | PRIMARY KEY (p_id)
|
---|
| 366 | );";
|
---|
| 367 |
|
---|
| 368 | $odlinkssql[$table_prefix.'odnew_links'] = "CREATE TABLE {$table_prefix}odnew_links (
|
---|
| 369 | n_id int(11) NOT NULL auto_increment,
|
---|
| 370 | n_url text NOT NULL,
|
---|
| 371 | n_title text NOT NULL,
|
---|
| 372 | n_description text NOT NULL,
|
---|
| 373 | n_email tinytext NOT NULL,
|
---|
| 374 | n_category int(11) NOT NULL default '0',
|
---|
| 375 | PRIMARY KEY (n_id)
|
---|
| 376 | );";
|
---|
| 377 |
|
---|
| 378 |
|
---|
| 379 | $tabs = $wpdb->get_results("SHOW TABLES", ARRAY_N);
|
---|
| 380 |
|
---|
| 381 | $tables = array();
|
---|
| 382 |
|
---|
| 383 | for ($i=0; $i<count($tabs); $i++){
|
---|
| 384 | $tables[] = $tabs[$i][0];
|
---|
| 385 | }
|
---|
| 386 |
|
---|
| 387 | @reset($odlinkssql);
|
---|
| 388 |
|
---|
| 389 | while (list($k, $v) = @each($odlinkssql)){
|
---|
| 390 | if (!@in_array($k, $tables)){
|
---|
| 391 | echo " - create table: " . $k . "<br />";
|
---|
| 392 | $wpdb->query($v);
|
---|
| 393 | }
|
---|
| 394 | }
|
---|
| 395 | }
|
---|
| 396 |
|
---|
| 397 | function odlinksget_namefield(){
|
---|
| 398 | global $wpdb, $table_prefix, $wp_version;
|
---|
| 399 | if ($user_field == false){
|
---|
| 400 | $tcols = $wpdb->get_results("SHOW COLUMNS FROM {$table_prefix}users", ARRAY_A);
|
---|
| 401 | $cols = array();
|
---|
| 402 | for ($i=0; $i<count($tcols); $i++){
|
---|
| 403 | $cols[] = $tcols[$i]['Field'];
|
---|
| 404 | }
|
---|
| 405 | if (in_array("display_name", $cols)){
|
---|
| 406 | $wpc_user_field = "display_name";
|
---|
| 407 | $wp_version = "2";
|
---|
| 408 | } else {
|
---|
| 409 | $wpc_user_field = "user_nickname";
|
---|
| 410 | $wp_version = "1";
|
---|
| 411 | }
|
---|
| 412 | }
|
---|
| 413 | return $user_field;
|
---|
| 414 | }
|
---|
| 415 |
|
---|
| 416 |
|
---|
| 417 | ?> |
---|