Shortlinks by Pretty Links – Best WordPress Link Tracking Plugin -

Version Description

Release Info

Developer	supercleanse
Plugin	Shortlinks by Pretty Links – Best WordPress Link Tracking Plugin
Version	0.0.2
Comparing to
See all releases

Version 0.0.2

Files changed (14) hide show

classes/models/PrliLink.php +121 -0
classes/models/PrliUtils.php +99 -0
classes/models/models.inc.php +7 -0
classes/views/prli-links/edit.php +31 -0
classes/views/prli-links/list.php +58 -0
classes/views/prli-links/new.php +31 -0
classes/views/shared/errors.php +19 -0
classes/views/shared/table-nav.php +93 -0
images/bookmark.png +0 -0
pretty-link.php +107 -0
prli-config.php +10 -0
prli-links.php +98 -0
prli.php +39 -0
readme.txt +31 -0

classes/models/PrliLink.php ADDED Viewed

	@@ -0,0 +1,121 @@


1	+ <?php
2	+ class PrliLink
3	+ {
4	+ public $table_name;
5	+
6	+ public function __construct()
7	+ {
8	+ global $wpdb;
9	+ $this->table_name = $wpdb->prefix . 'prli_links';
10	+ }
11	+
12	+ public function tableName()
13	+ {
14	+ return $this->table_name;
15	+ }
16	+
17	+ public function create( $values )
18	+ {
19	+ global $wpdb, $wp_rewrite;
20	+ $query = 'INSERT INTO ' . $this->table_name .
21	+ ' (url,slug,created_at) VALUES (\'' .
22	+ $values['url'] . '\',\'' .
23	+ $values['slug'] . '\',' .
24	+ 'NOW())';
25	+ $query_results = $wpdb->query($query);
26	+ $wp_rewrite->flush_rules();
27	+ return $query_results;
28	+ }
29	+
30	+ public function update( $id, $values )
31	+ {
32	+ global $wpdb, $wp_rewrite;
33	+ $query = 'UPDATE ' . $this->table_name .
34	+ ' SET url=\'' . $values['url'] . '\', ' .
35	+ ' slug=\'' . $values['slug'] . '\' ' .
36	+ 'WHERE id='.$id;
37	+ $query_results = $wpdb->query($query);
38	+ $wp_rewrite->flush_rules();
39	+ return $query_results;
40	+ }
41	+
42	+ public function destroy( $id )
43	+ {
44	+ require_once(PRLI_MODELS_PATH.'/models.inc.php');
45	+ global $wpdb, $wp_rewrite;
46	+ $destroy = 'DELETE FROM ' . $this->table_name . ' WHERE id=' . $id;
47	+ $wp_rewrite->flush_rules();
48	+ return $wpdb->query($destroy);
49	+ }
50	+
51	+ public function getOne( $id )
52	+ {
53	+ global $wpdb;
54	+ $click_table = $wpdb->prefix . "prli_clicks";
55	+ $query = 'SELECT li., (SELECT COUNT() FROM ' . $click_table . ' cl WHERE cl.link_id = li.id) as clicks FROM ' . $this->table_name . ' li WHERE id=' . $id . ';';
56	+ return $wpdb->get_row($query);
57	+ }
58	+
59	+ public function getAll()
60	+ {
61	+ global $wpdb;
62	+ $click_table = $wpdb->prefix . "prli_clicks";
63	+ $query = 'SELECT li., (SELECT COUNT() FROM ' . $click_table . ' cl WHERE cl.link_id = li.id) as clicks FROM ' . $this->table_name . ' li;';
64	+ return $wpdb->get_results($query);
65	+ }
66	+
67	+ // Pagination Methods
68	+ public function getRecordCount($where="")
69	+ {
70	+ global $wpdb;
71	+ $query = 'SELECT COUNT(*) FROM ' . $this->table_name . $where;
72	+ return $wpdb->get_var($query);
73	+ }
74	+
75	+ public function getPageCount($p_size, $where="")
76	+ {
77	+ return ceil((int)$this->getRecordCount($where) / (int)$p_size);
78	+ }
79	+
80	+ public function getPage($current_p,$p_size, $where = "")
81	+ {
82	+ global $wpdb;
83	+ $click_table = $wpdb->prefix . "prli_clicks";
84	+ $end_index = $current_p * $p_size;
85	+ $start_index = $end_index - $p_size;
86	+ $query = 'SELECT li., (SELECT COUNT() FROM ' . $click_table . ' cl WHERE cl.link_id = li.id) as clicks FROM ' . $this->table_name . ' li' . $where . ' LIMIT ' . $start_index . ',' . $p_size . ';';
87	+ $results = $wpdb->get_results($query);
88	+ return $results;
89	+ }
90	+
91	+ public function validate( $values )
92	+ {
93	+ global $wpdb, $prli_utils;
94	+
95	+ $errors = array();
96	+ if( $values['url'] == null or $values['url'] == '' )
97	+ $errors[] = "Link URL can't be blank";
98	+
99	+ if( $values['slug'] == null or $values['slug'] == '' )
100	+ $errors[] = "Pretty Link can't be blank";
101	+
102	+ if( !preg_match('/^http.?:\/\/.\..$/', $values['url'] ) )
103	+ $errors[] = "Link URL must be a correctly formatted url";
104	+
105	+ if( !preg_match('/^[a-z0-9\.\-_]+$/', $values['slug'] ) )
106	+ $errors[] = "Pretty Link must not contain spaces or special characters";
107	+
108	+ if($values['id'] != null and $values['id'] != '')
109	+ $query = "SELECT slug FROM " . $this->table_name . " WHERE slug='" . $values['slug'] . "' AND id <> " . $values['id'];
110	+ else
111	+ $query = "SELECT slug FROM " . $this->table_name . " WHERE slug='" . $values['slug'] . "'";
112	+
113	+ $slug_already_exists = $wpdb->get_var($query);
114	+
115	+ if( $slug_already_exists or !$prli_utils->slugIsAvailable($values['slug']) )
116	+ $errors[] = "This pretty link slug is already taken, please choose a different one";
117	+
118	+ return $errors;
119	+ }
120	+ };
121	+ ?>

classes/models/PrliUtils.php ADDED Viewed

	@@ -0,0 +1,99 @@


1	+ <?php
2	+ require_once 'models.inc.php';
3	+
4	+ class PrliUtils
5	+ {
6	+
7	+ /** Okay I realize that Percentagize isn't really a word but
8	+ * this is so that the values we have will work with google
9	+ * charts.
10	+ */
11	+ public function percentagizeArray($data,$max_value)
12	+ {
13	+ $new_data = array();
14	+ foreach($data as $point)
15	+ {
16	+ if( $max_value > 0 )
17	+ {
18	+ $new_data[] = $point / $max_value * 100;
19	+ }
20	+ else
21	+ {
22	+ $new_data[] = 0;
23	+ }
24	+ }
25	+ return $new_data;
26	+ }
27	+
28	+ public function getTopValue($values_array)
29	+ {
30	+ rsort($values_array);
31	+ return $values_array[0];
32	+ }
33	+
34	+
35	+ public function getMonthsArray()
36	+ {
37	+ global $wpdb;
38	+ global $prli_click;
39	+
40	+ $months = array();
41	+ $year = date("Y");
42	+ $month = date("m");
43	+ $current_timestamp = time();
44	+ $current_month_timestamp = mktime(0, 0, 0, date("m", $current_timestamp), 1, date("Y", $current_timestamp));
45	+
46	+ $clicks_table = $prli_click->tableName();
47	+ $first_click = $wpdb->get_var("SELECT created_at FROM $clicks_table ORDER BY created_at LIMIT 1;");
48	+ $first_timestamp = ((empty($first_click))?$current_timestamp:strtotime($first_click));
49	+ $first_date = mktime(0, 0, 0, date("m", $first_timestamp), 1, date("Y", $first_timestamp));
50	+
51	+ while($current_month_timestamp >= $first_date)
52	+ {
53	+ $months[] = $current_month_timestamp;
54	+ if(date("m") == 1)
55	+ {
56	+ $current_month_timestamp = mktime(0, 0, 0, 12, 1, date("Y", $current_month_timestamp)-1);
57	+ }
58	+ else
59	+ {
60	+ $current_month_timestamp = mktime(0, 0, 0, date("m", $current_month_timestamp)-1, 1, date("Y", $current_month_timestamp));
61	+ }
62	+ }
63	+ return $months;
64	+ }
65	+
66	+ // For Pagination
67	+ public function getLastRecordNum($r_count,$current_p,$p_size)
68	+ {
69	+ return (($r_count < ($current_p * $p_size))?$r_count:($current_p * $p_size));
70	+ }
71	+
72	+ // For Pagination
73	+ public function getFirstRecordNum($r_count,$current_p,$p_size)
74	+ {
75	+ if($current_p == 1)
76	+ {
77	+ return 1;
78	+ }
79	+ else
80	+ {
81	+ return ($this->getLastRecordNum($r_count,($current_p - 1),$p_size) + 1);
82	+ }
83	+ }
84	+
85	+ public function slugIsAvailable($slug)
86	+ {
87	+ global $wpdb;
88	+
89	+ $posts_table = $wpdb->prefix . "posts";
90	+ $terms_table = $wpdb->prefix . "terms";
91	+
92	+ $post_slug = $wpdb->get_var("SELECT post_name FROM $posts_table WHERE post_name='$slug'");
93	+ $term_slug = $wpdb->get_col("SELECT slug FROM $terms_table WHERE slug='$slug'");
94	+
95	+ return ( $post_slug != $slug and $term_slug != $slug );
96	+ }
97	+
98	+ };
99	+ ?>

classes/models/models.inc.php ADDED Viewed

	@@ -0,0 +1,7 @@


1	+ <?php
2	+ require_once(PRLI_MODELS_PATH.'/PrliLink.php');
3	+ require_once(PRLI_MODELS_PATH.'/PrliUtils.php');
4	+
5	+ $prli_link = new PrliLink();
6	+ $prli_utils = new PrliUtils();
7	+ ?>

classes/views/prli-links/edit.php ADDED Viewed

	@@ -0,0 +1,31 @@


1	+ <div class="wrap">
2	+ <h2>Pretty Link: Edit Link</h2>
3	+
4	+ <?php
5	+ require(PRLI_VIEWS_PATH.'/shared/errors.php');
6	+ ?>
7	+
8	+ <form name="form1" method="post" action="?page=<?php print PRLI_PLUGIN_NAME ?>/prli-links.php">
9	+ <input type="hidden" name="action" value="update">
10	+ <input type="hidden" name="id" value="<?php print $id; ?>">
11	+ <?php wp_nonce_field('update-options'); ?>
12	+
13	+ <table class="form-table">
14	+ <tr>
15	+ <td width="75px">URL*: </td>
16	+ <td><input type="text" name="url" value="<?php print (($_POST['url'] != null and $record == null)?$_POST['url']:$record->url); ?>" size="75">
17	+ <br/><span class="setting-description">Enter the URL you want to mask and track.</span></td>
18	+ </tr>
19	+ <tr>
20	+ <td>Pretty Link*: </td>
21	+ <td><strong><?php print get_option('siteurl'); ?></strong>/<input type="text" name="slug" value="<?php print (($_POST['slug'] != null and $record == null)?$_POST['slug']:$record->slug); ?>" size="25">
22	+ <br/><span class="setting-description">Enter the slug (word trailing your main URL) that will form your pretty link and redirect to the URL above.</span></td>
23	+ </tr>
24	+ </table>
25	+
26	+ <p class="submit">
27	+ <input type="submit" name="Submit" value="Create" /> \| <a href="?page=<?php print PRLI_PLUGIN_NAME ?>/prli-links.php">Cancel</a>
28	+ </p>
29	+
30	+ </form>
31	+ </div>

classes/views/prli-links/list.php ADDED Viewed

	@@ -0,0 +1,58 @@


1	+ <div class="wrap">
2	+ <h2>Pretty Link: Links</h2>
3	+ <p>Get started by <a href="?page=<?php print PRLI_PLUGIN_NAME; ?>/prli-links.php&action=new">adding a URL</a> that you want to turn into a pretty link. Come back to check how many times it was clicked.</p>
4	+ <p><a href="?page=<?php print PRLI_PLUGIN_NAME; ?>/prli-links.php&action=new">+ Add Link</a></p>
5	+ <?php
6	+ require(PRLI_VIEWS_PATH.'/shared/table-nav.php');
7	+ ?>
8	+ <table class="widefat post fixed" cellspacing="0">
9	+ <thead>
10	+ <tr>
11	+ <th class="manage-column" width="15%">Slug</th>
12	+ <th class="manage-column" width="25%">URL</th>
13	+ <th class="manage-column" width="30%">Pretty Link</th>
14	+ <th class="manage-column" width="20%">Clicks</th>
15	+ <th class="manage-column" width="10%">Destroy</th>
16	+ </tr>
17	+ </thead>
18	+ <?php
19	+
20	+ if(count($links) <= 0)
21	+ {
22	+ ?>
23	+ <tr>
24	+ <td colspan="5"><a href="?page=<?php print PRLI_PLUGIN_NAME; ?>/prli-links.php&action=new">Create your First Link</a></td>
25	+ </tr>
26	+ <?php
27	+ }
28	+ else
29	+ {
30	+ foreach($links as $link)
31	+ {
32	+ ?>
33	+ <tr>
34	+ <td><a href="?page=<?php print PRLI_PLUGIN_NAME; ?>/prli-links.php&action=edit&id=<?php print $link->id; ?>"><?php print $link->slug; ?></a></td>
35	+ <td><? print $link->url; ?> \| <a href="<? print $link->url; ?>" target="_blank">Visit</a></td>
36	+ <td><input type='text' style="font-size: 10px;" readonly="true" onclick='this.select();' onfocus='this.select();' value='<?php echo get_option('siteurl') . '/' . $link->slug; ?>' size="30" /></td>
37	+ <td><?php print $link->clicks; ?></td>
38	+ <td><a href="?page=<?php print PRLI_PLUGIN_NAME; ?>/prli-links.php&action=destroy&id=<?php print $link->id; ?>" onclick="return confirm('Are you sure you want to delete this link?');">Destroy</a></td>
39	+ </tr>
40	+ <?php
41	+ }
42	+ }
43	+ ?>
44	+ <tfoot>
45	+ <tr>
46	+ <th class="manage-column">Slug</th>
47	+ <th class="manage-column">URL</th>
48	+ <th class="manage-column">Pretty Link</th>
49	+ <th class="manage-column">Clicks</th>
50	+ <th class="manage-column">Destroy</th>
51	+ </tr>
52	+ </tfoot>
53	+ </table>
54	+ <?php
55	+ require(PRLI_VIEWS_PATH.'/shared/table-nav.php');
56	+ ?>
57	+
58	+ </div>

classes/views/prli-links/new.php ADDED Viewed

	@@ -0,0 +1,31 @@


1	+ <div class="wrap">
2	+ <h2>Pretty Link: New Link</h2>
3	+
4	+ <?php
5	+ require(PRLI_VIEWS_PATH.'/shared/errors.php');
6	+ ?>
7	+
8	+ <form name="form1" method="post" action="?page=<?php print PRLI_PLUGIN_NAME ?>/prli-links.php">
9	+ <input type="hidden" name="action" value="create">
10	+ <?php wp_nonce_field('update-options'); ?>
11	+ <input type="hidden" name="id" value="<?php print $id; ?>">
12	+
13	+ <table class="form-table">
14	+ <tr>
15	+ <td width="75px">URL*: </td>
16	+ <td><input type="text" name="url" value="<?php print (($_POST['url'] != null)?$_POST['url']:'http://yoururl.com'); ?>" size="75">
17	+ <br/><span class="setting-description">Enter the URL you want to mask and track.</span></td>
18	+ </tr>
19	+ <tr>
20	+ <td>Pretty Link*: </td>
21	+ <td><strong><?php print get_option('siteurl'); ?></strong>/<input type="text" name="slug" value="<?php print (($_POST['slug'] != null)?$_POST['slug']:''); ?>" size="25">
22	+ <br/><span class="setting-description">Enter the slug (word trailing your main URL) that will form your pretty link and redirect to the URL above.</span></td>
23	+ </tr>
24	+ </table>
25	+
26	+ <p class="submit">
27	+ <input type="submit" name="Submit" value="Create" /> \| <a href="?page=<?php print PRLI_PLUGIN_NAME ?>/prli-links.php">Cancel</a>
28	+ </p>
29	+
30	+ </form>
31	+ </div>

classes/views/shared/errors.php ADDED Viewed

	@@ -0,0 +1,19 @@


1	+ <?php
2	+ if( $errors != null and count($errors) > 0 )
3	+ {
4	+ ?>
5	+ <div class="error">
6	+ <ul>
7	+ <?php
8	+ foreach( $errors as $error )
9	+ {
10	+ ?>
11	+ <li><strong>ERROR</strong>: <?php print $error; ?></li>
12	+ <?php
13	+ }
14	+ ?>
15	+ </ul>
16	+ </div>
17	+ <?php
18	+ }
19	+ ?>

classes/views/shared/table-nav.php ADDED Viewed

	@@ -0,0 +1,93 @@


1	+ <?php
2	+ // Only show the pager bar if there is more than 1 page
3	+ if($page_count > 1)
4	+ {
5	+ ?>
6	+ <div class="tablenav">
7	+ <div class='tablenav-pages'><span class="displaying-num">Displaying <?php print "$page_first_record–$page_last_record of $record_count"; ?></span>
8	+
9	+ <?php
10	+ // Only show the prev page button if the current page is not the first page
11	+ if($current_page > 1)
12	+ {
13	+ ?>
14	+ <a class='prev page-numbers' href='?page=<?php print PRLI_PLUGIN_NAME; ?>/<?php print $controller_file . $page_params; ?>&paged=<?php print($current_page-1); ?>'>«</a>
15	+ <?php
16	+ }
17	+
18	+ // First page is always displayed
19	+ if($current_page==1)
20	+ {
21	+ ?>
22	+ <span class='page-numbers current'>1</span>
23	+ <?php
24	+ }
25	+ else
26	+ {
27	+ ?>
28	+ <a class='page-numbers' href='?page=<?php print PRLI_PLUGIN_NAME; ?>/<?php print $controller_file . $page_params; ?>&paged=1'>1</a>
29	+ <?php
30	+ }
31	+
32	+ // If the current page is more than 2 spaces away from the first page then we put some dots in here
33	+ if($current_page >= 5)
34	+ {
35	+ ?>
36	+ <span class='page-numbers dots'>...</span>
37	+ <?php
38	+ }
39	+
40	+ // display the current page icon and the 2 pages beneath and above it
41	+ $low_page = (($current_page >= 5)?($current_page-2):2);
42	+ $high_page = ((($current_page + 2) < ($page_count-1))?($current_page+2):($page_count-1));
43	+ for($i = $low_page; $i <= $high_page; $i++)
44	+ {
45	+ if($current_page==$i)
46	+ {
47	+ ?>
48	+ <span class='page-numbers current'><?php print $i; ?></span>
49	+ <?php
50	+ }
51	+ else
52	+ {
53	+ ?>
54	+ <a class='page-numbers' href='?page=<?php print PRLI_PLUGIN_NAME; ?>/<?php print $controller_file . $page_params; ?>&paged=<?php print $i; ?>'><?php print $i; ?></a>
55	+ <?php
56	+ }
57	+ }
58	+
59	+ // If the current page is more than 2 away from the last page then show ellipsis
60	+ if($current_page < ($page_count - 3))
61	+ {
62	+ ?>
63	+ <span class='page-numbers dots'>...</span>
64	+ <?php
65	+ }
66	+
67	+ // Display the last page icon
68	+ if($current_page == $page_count)
69	+ {
70	+ ?>
71	+ <span class='page-numbers current'><?php print $page_count; ?></span>
72	+ <?php
73	+ }
74	+ else
75	+ {
76	+ ?>
77	+ <a class='page-numbers' href='?page=<?php print PRLI_PLUGIN_NAME; ?>/<?php print $controller_file . $page_params; ?>&paged=<?php print $page_count; ?>'><?php print $page_count; ?></a>
78	+ <?php
79	+ }
80	+
81	+ // Display the next page icon if there is a next page
82	+ if($current_page < $page_count)
83	+ {
84	+ ?>
85	+ <a class='next page-numbers' href='?page=<?php print PRLI_PLUGIN_NAME; ?>/<?php print $controller_file . $page_params; ?>&paged=<?php print($current_page + 1); ?>'>»</a>
86	+ <?php
87	+ }
88	+ ?>
89	+ </div>
90	+ </div>
91	+ <?php
92	+ }
93	+ ?>

images/bookmark.png ADDED Viewed

Binary file

pretty-link.php ADDED Viewed

	@@ -0,0 +1,107 @@


1	+ <?php
2	+ /*
3	+ Plugin Name: Pretty Link
4	+ Plugin URI: http://blairwilliams.com/pretty-link
5	+ Description: Creates shortened, named URLs using your blog. This plugin makes the best possible links for your affiliate campaigns or other endeavors because the links appear to be coming from your site instead of from tinyurl, budurl or one of the other link shrinking services. You can track stats on your links easily and keep that data on your own database (instead of allowing it to be managed on other machines).
6	+ Version: 0.0.2
7	+ Author: Blair Williams
8	+ Author URI: http://blairwilliams.com/
9	+ Copyright: 2009, Caseproof, LLC
10	+
11	+ GNU General Public License, Free Software Foundation <http://creativecommons.org/licenses/GPL/2.0/>
12	+ This program is free software; you can redistribute it and/or modify
13	+ it under the terms of the GNU General Public License as published by
14	+ the Free Software Foundation; either version 2 of the License, or
15	+ (at your option) any later version.
16	+
17	+ This program is distributed in the hope that it will be useful,
18	+ but WITHOUT ANY WARRANTY; without even the implied warranty of
19	+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20	+ GNU General Public License for more details.
21	+
22	+ You should have received a copy of the GNU General Public License
23	+ along with this program; if not, write to the Free Software
24	+ Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
25	+ */
26	+
27	+ require_once('prli-config.php');
28	+ require_once(PRLI_MODELS_PATH . '/models.inc.php');
29	+
30	+ register_activation_hook(__FILE__,'prli_install');
31	+
32	+ add_action('admin_menu', 'prli_menu');
33	+
34	+ function prli_menu() {
35	+ add_menu_page('Pretty Link', 'Pretty Link', 8, PRLI_PATH.'/prli-links.php','',PRLI_URL.'/images/bookmark.png');
36	+ // add_submenu_page(PRLI_PATH.'/prli-main.php', 'Pretty Link \| Links', 'Links', 8, PRLI_PATH.'/prli-links.php');
37	+ // add_submenu_page(PRLI_PATH.'/prli-main.php', 'Pretty Link \| Reports', 'Reports', 8, PRLI_PATH.'/prli-links.php');
38	+ }
39	+
40	+ /******* ADD REDIRECTS YO *********/
41	+ function link_rewrite($wp_rewrite) {
42	+ global $prli_link, $prli_utils;
43	+
44	+ $pretty_links = $prli_link->getAll();
45	+
46	+ foreach($pretty_links as $pl)
47	+ {
48	+ if( $pl->slug != null and $pl->slug != '' and $prli_utils->slugIsAvailable($pl->slug) )
49	+ {
50	+ add_rewrite_rule('(' . $pl->slug . ')/?$', 'wp-content/plugins/' . PRLI_PLUGIN_NAME . '/prli.php?s=$1');
51	+ }
52	+
53	+ }
54	+ }
55	+
56	+ // Add rules after the rest of the rules are run
57	+ add_filter('generate_rewrite_rules', 'link_rewrite');
58	+
59	+ /******* INSTALL PLUGIN *********/
60	+ $prli_db_version = "0.0.3";
61	+
62	+ function prli_install() {
63	+ global $wpdb;
64	+ global $prli_db_version;
65	+
66	+
67	+ $clicks_table = $wpdb->prefix . "prli_clicks";
68	+ $pretty_links_table = $wpdb->prefix . "prli_links";
69	+
70	+ $prli_db_version = 'prli_db_version';
71	+ $prli_current_db_version = get_option( $prli_db_version );
72	+
73	+ if( empty($prli_current_db_version) or ($prli_current_db_version != $prli_new_db_version))
74	+ {
75	+ /* Create/Upgrade Clicks Table */
76	+ $sql = "CREATE TABLE " . $clicks_table . " (
77	+ id int(11) NOT NULL auto_increment,
78	+ ip varchar(255) default NULL,
79	+ browser varchar(255) default NULL,
80	+ first_click tinyint default 0,
81	+ created_at datetime NOT NULL,
82	+ link_id int(11) default NULL,
83	+ PRIMARY KEY (id),
84	+ KEY link_id (link_id),
85	+ CONSTRAINT ".$clicks_table."_ibfk_1 FOREIGN KEY (link_id) REFERENCES $pretty_links_table (link_id)
86	+ );";
87	+
88	+ require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
89	+
90	+ dbDelta($sql);
91	+
92	+ /* Create/Upgrade Pretty Links Table */
93	+ $sql = "CREATE TABLE " . $pretty_links_table . " (
94	+ id int(11) NOT NULL auto_increment,
95	+ url varchar(255) default NULL,
96	+ slug varchar(255) default NULL,
97	+ created_at datetime NOT NULL,
98	+ PRIMARY KEY (id),
99	+ KEY slug (slug)
100	+ );";
101	+
102	+ require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
103	+
104	+ dbDelta($sql);
105	+ }
106	+ }
107	+ ?>

prli-config.php ADDED Viewed

	@@ -0,0 +1,10 @@


1	+ <?php
2	+ define(PRLI_PLUGIN_NAME,"pretty-link");
3	+ define(PRLI_PATH,WP_PLUGIN_DIR.'/'.PRLI_PLUGIN_NAME);
4	+ define(PRLI_MODELS_PATH,PRLI_PATH.'/classes/models');
5	+ define(PRLI_VIEWS_PATH,PRLI_PATH.'/classes/views');
6	+ define(PRLI_URL,WP_PLUGIN_URL.'/'.PRLI_PLUGIN_NAME);
7	+
8	+ // The number of items per page on a table
9	+ $page_size = 15;
10	+ ?>

prli-links.php ADDED Viewed

	@@ -0,0 +1,98 @@


1	+ <?php
2	+ require_once 'prli-config.php';
3	+ require_once(PRLI_MODELS_PATH . '/models.inc.php');
4	+
5	+ $controller_file = 'prli-links.php';
6	+
7	+ if($_GET['action'] == null and $_POST['action'] == null)
8	+ {
9	+ // Required for Pagination to work
10	+ if($_GET['paged'] != null)
11	+ {
12	+ $current_page = $_GET['paged'];
13	+ }
14	+ else
15	+ {
16	+ $current_page = 1;
17	+ }
18	+
19	+ $record_count = $prli_link->getRecordCount();
20	+ $page_count = $prli_link->getPageCount($page_size);
21	+ $links = $prli_link->getPage($current_page,$page_size);
22	+ $page_last_record = $prli_utils->getLastRecordNum($record_count,$current_page,$page_size);
23	+ $page_first_record = $prli_utils->getFirstRecordNum($record_count,$current_page,$page_size);
24	+ $page_params = "";
25	+ require_once 'classes/views/prli-links/list.php';
26	+ }
27	+ else if($_GET['action'] == 'new' or $_POST['action'] == 'new')
28	+ {
29	+ require_once 'classes/views/prli-links/new.php';
30	+ }
31	+ else if($_GET['action'] == 'create' or $_POST['action'] == 'create')
32	+ {
33	+ $errors = $prli_link->validate($_POST);
34	+ if( count($errors) > 0 )
35	+ {
36	+ require_once 'classes/views/prli-links/new.php';
37	+ }
38	+ else
39	+ {
40	+ $record = $prli_link->create( $_POST );
41	+
42	+ // Required for Pagination to work
43	+ $current_page = 1;
44	+ $record_count = $prli_link->getRecordCount();
45	+ $page_count = $prli_link->getPageCount($page_size);
46	+ $links = $prli_link->getPage($current_page,$page_size);
47	+ $page_last_record = $prli_utils->getLastRecordNum($record_count,$current_page,$page_size);
48	+ $page_first_record = $prli_utils->getFirstRecordNum($record_count,$current_page,$page_size);
49	+ $page_params = "";
50	+
51	+ require_once 'classes/views/prli-links/list.php';
52	+ }
53	+ }
54	+ else if($_GET['action'] == 'edit' or $_POST['action'] == 'edit')
55	+ {
56	+ $record = $prli_link->getOne( $_GET['id'] );
57	+ $id = $_GET['id'];
58	+ require_once 'classes/views/prli-links/edit.php';
59	+ }
60	+ else if($_GET['action'] == 'update' or $_POST['action'] == 'update')
61	+ {
62	+ $errors = $prli_link->validate($_POST);
63	+ $id = $_POST['id'];
64	+ if( count($errors) > 0 )
65	+ {
66	+ require_once 'classes/views/prli-links/edit.php';
67	+ }
68	+ else
69	+ {
70	+ $record = $prli_link->update( $_POST['id'], $_POST );
71	+
72	+ // Required for Pagination to work
73	+ $current_page = 1;
74	+ $record_count = $prli_link->getRecordCount();
75	+ $page_count = $prli_link->getPageCount($page_size);
76	+ $links = $prli_link->getPage($current_page,$page_size);
77	+ $page_last_record = $prli_utils->getLastRecordNum($record_count,$current_page,$page_size);
78	+ $page_first_record = $prli_utils->getFirstRecordNum($record_count,$current_page,$page_size);
79	+ $page_params = "";
80	+
81	+ require_once 'classes/views/prli-links/list.php';
82	+ }
83	+ }
84	+ else if($_GET['action'] == 'destroy')
85	+ {
86	+ $prli_link->destroy( $_GET['id'] );
87	+
88	+ // Required for Pagination to work
89	+ $current_page = 1;
90	+ $record_count = $prli_link->getRecordCount();
91	+ $page_count = $prli_link->getPageCount($page_size);
92	+ $links = $prli_link->getPage($current_page,$page_size);
93	+ $page_last_record = $prli_utils->getLastRecordNum($record_count,$current_page,$page_size);
94	+ $page_first_record = $prli_utils->getFirstRecordNum($record_count,$current_page,$page_size);
95	+ $page_params = "";
96	+ require_once 'classes/views/prli-links/list.php';
97	+ }
98	+ ?>

prli.php ADDED Viewed

	@@ -0,0 +1,39 @@


1	+ <?php
2	+ /* This file tracks clicks */
3	+
4	+ require_once(dirname(__FILE__) . '/../../../wp-config.php');
5	+
6	+ if( $_GET['s'] != null and $_GET['s'] != '' )
7	+ {
8	+ $slug = $_GET['s'];
9	+
10	+ $click_table = $wpdb->prefix . "prli_clicks";
11	+ $pretty_links_table = $wpdb->prefix . "prli_links";
12	+
13	+ $query = "SELECT id,url FROM $pretty_links_table WHERE slug='$slug' LIMIT 1";
14	+ $pretty_link = $wpdb->get_row($query);
15	+
16	+ $first_click = false;
17	+
18	+ $click_ip = $_SERVER['REMOTE_ADDR'];
19	+ $click_browser = $_SERVER['HTTP_USER_AGENT'];
20	+
21	+ //Set Cookie if it doesn't exist
22	+ $cookie_name = 'prli_click_' . $pretty_link->id;
23	+ $cookie_expire_time = time()+606024*30; // Expire in 30 days
24	+
25	+ if($_COOKIE[$cookie_name] == null)
26	+ {
27	+ setcookie($cookie_name,$slug,$cookie_expire_time);
28	+ $first_click = true;
29	+ }
30	+
31	+ //Record Click in DB
32	+ $insert = "INSERT INTO $click_table (link_id,ip,browser,first_click,created_at) VALUES ($pretty_link->id,'$click_ip','$click_browser','$first_click',NOW())";
33	+
34	+ $results = $wpdb->query( $insert );
35	+
36	+ //Redirect to Product URL
37	+ header("Location: $pretty_link->url");
38	+ }
39	+ ?>

readme.txt ADDED Viewed

	@@ -0,0 +1,31 @@


1	+ === Pretty Link ===
2	+ Contributors: supercleanse
3	+ Donate link: http://blairwilliams.com/
4	+ Tags: links, pretty, link, url, urls, redirect, redirect, rewrite, short, tinyurl, budurl, shrink, mask, slug, slugs
5	+ Requires at least: 2.7.1
6	+ Tested up to: 2.7.1
7	+ Stable tag: trunk
8	+
9	+ With Pretty Link you can create shortened, named URLs using your website's domain name.
10	+
11	+ == Description ==
12	+
13	+ With Pretty Link you can create shortened, named URLs using your website's domain name. This plugin makes the cleanest links possible because they are on your site instead of from tinyurl, budurl or one of the other link shrinking services. You can also track stats on your links easily and keep that data on your own database.
14	+
15	+ == Installation ==
16	+
17	+ 1. Upload `plugin-name.php` to the `/wp-content/plugins/` directory
18	+ 2. Activate the plugin through the 'Plugins' menu in WordPress
19	+ 3. Make sure you have changed your permalink Common Settings in Settings -> Permalinks away from "Default" to something else. I prefer using custom and then "/%postname%/" for the simplest possible tags.
20	+
21	+ = Features =
22	+
23	+ * Add URL Redirects to your Blog : You can redirect and track any link
24	+
25	+ == Frequently Asked Questions ==
26	+
27	+ * http://blairwilliams.com/pretty-link/faq
28	+
29	+ == Screenshots ==
30	+
31	+ * http://blairwilliams.com/pretty-link/screenshots

Shortlinks by Pretty Links – Best WordPress Link Tracking Plugin - Version 0.0.2

Version Description

Release Info

Version 0.0.2