Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 12172
Latest: LeaMoeller
New This Month: 14
New This Week: 1
New Today: 1
Stats
Total Posts: 39049
Total Topics: 6874
Most Online Today: 59
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 28
Total: 29

Author Topic: prettyurls - DatabaseChanges.wiki  (Read 62 times)

0 Members and 1 Guest are viewing this topic.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14551
    • View Profile
prettyurls - DatabaseChanges.wiki
« on: July 13, 2018, 04:23:01 pm »
The Pretty URLs mod needs to make several changes to the database. This is a reference in case you need to manually edit or fix something.

If you ever want to completely remove the mod, you will need to remove all of these additions too. To be super-cool, use the uninstall tool.

New tables

| Name | Structure | Description | |:---------|:--------------|:----------------| | smf_pretty_topic_urls | id_topic: mediumint, pretty_url: varchar(80) | Stores the (partial) URLs for topics. Currently the only way to change a topic's URL is to edit this table manually. | | smf_pretty_urls_cache | url_id: varchar(255), replacement: varchar(255) | A complete list of every URL in the forum with its prettified replacement. The url_id column stores the original URL, with $scripturl and other common URLs shortened. |

New settings
Settings are stored in the smf_settings table. Many of these settings use serialized arrays, so the following PHP functions might be useful: serialize(), unserialize().

| Name | Description | |:---------|:----------------| | pretty_action_array | An array of forum actions, extracted from index.php. | | pretty_board_lookup | A serialized array of URL => ID_BOARD pairs, used for processing $_GET['board']. There can be more than one URL for each board. | | pretty_board_urls | A serialized array of ID_BOARD => URL pairs, used for generating pretty replacement URLs. | | pretty_enable_filters | Sets whether to prettify anything at all. 0 for no, 1 for yes. | | pretty_filters | A serialized array of filter data. | | pretty_filter_callbacks | A serialized array of callback function names, sorted by priority. Don't manually edit this, edit the pretty_filters setting instead. | | pretty_root_url | The base URL used by the board and topic filters, which by default is the same as $boardurl. |
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
7 Replies
5332 Views
Last post October 07, 2006, 11:43:40 pm
by Nite
14 Replies
8274 Views
Last post December 08, 2011, 01:39:57 am
by Vincent Volmer
0 Replies
1197 Views
Last post May 31, 2017, 10:49:05 pm
by SMFHacks
0 Replies
56 Views
Last post July 13, 2018, 04:22:02 pm
by SMFHacks
0 Replies
101 Views
Last post July 13, 2018, 04:24:23 pm
by SMFHacks

+- Recent Topics

link for users gallery from profile page by SMFHacks
August 20, 2018, 02:40:58 pm

[Mod]Tidy Child Boards 2.0 by SMFHacks
August 20, 2018, 01:32:43 pm

Admin View in Member's Profile of Dates for Accepting of PP and Reg Agreement by SMFHacks
August 18, 2018, 12:03:07 pm

Gallery2 Template Loading Error by SMFHacks
August 18, 2018, 12:02:12 pm

8: Undefined index: description by SMFHacks
August 17, 2018, 01:42:08 pm

It just does not send by SMFHacks
August 16, 2018, 11:03:06 pm

Ad beginning of post by SMFHacks
August 16, 2018, 10:22:58 pm

Agreement Date says NEVER by SMFHacks
August 14, 2018, 04:46:48 pm

HashTags system for SMF 2.0 released by Diego Andrés
August 12, 2018, 02:04:24 pm

Can the Store produce a unique code that you can sell? by SMFHacks
August 11, 2018, 11:43:32 am

Powered by EzPortal