Cache feature in ASP.NET 2.0

xiaoxiao2021-03-05 24

Release Date: 11/2/2004

| Update Date: 11/2/2004

Stephen walther

Microsoft Corporation

Applicable to:

Microsoft ASP.NET 2.0

Microsoft ASP.NET FRMEWORK

Microsoft SQL Server

Microsoft Visual Studio .NET

Summary: In this article, Stephen Walther will focus on the new cache function in ASP.NET 2.0, and how to use these new features to improve the performance and scalability of the ASP.NET application. (This article contains some links to English sites.)

This page

Easy data cache uses SQL Cache Invalidation to use Post-Cache Substitude Conclusion

For web applications driven by the database, improve their performance, the best way is to use caches. Retrieving data from the database may be one of the slowest operations you performed on a Web site. If you can cache data in the database to memory, you do not need to access the database when you request each page, so that you can greatly improve your performance.

There is only one shortcomings in the cache, that is, the data expired. If you cache content of the database table to memory, your web application will display expired, inaccurate data when the records in the underlying database table changes. For some types of data, even if the data displayed is slightly out of time, the impact will not be too large; but for data such as stock prices and bidding bidding, even if the data displayed is slightly unacceptable.

Microsoft ASP.NET 1.0 Framework does not provide a perfect solution for this issue. When using ASP.NET 1.0 Framework, you have to make a trade-off between performance and data expiration. Fortunately, Microsoft ASP.NET 2.0 Framework provides a new feature called SQL Cache Invalidation, which can solve this tricky problem.

In this article, you'll learn more about many new cache improvements in ASP.NET 2.0 Framework. First, you will learn how to integrate cache support in the new DataSource control. You will then learn how to configure and use SQL Cache Invalidation. Finally, you will learn about a new control introduced with ASP.NET 2.0 Framework: Substitution control, using this control to insert dynamic content to the cached page.

More relaxed data cache

In ASP.NET 2.0 Framework, one of the biggest changes is to change the way database data on the ASP.NET page. ASP.NET 2.0 Framework contains a new set of controls, which is collectively referred to as DataSource controls. You can use these controls to represent data sources, such as databases or XML files.

In the ASP.NET 1.0 Framework, it is used to display the database data by binding the control to the DataSet or DataReader, using the control. In ASP.NET 2.0 Framework, it is usually bound to the DataSource control. With the DataSource control, you can create an ASP.NET page that displays database data without writing any code for access database.

When processing database data, one of the following three DataSource controls is usually used:

•

SqlDataSource - Represents SQL data sources, such as Microsoft SQL Server or Oracle Database. •

AccessDataSource - A dedicated SqlDataSource control for Microsoft Access databases.

•

ObjectDataSource - Indicates a custom business object that acts as a data source.

For example, suppose you want to display a list of books that retrieve from the database in the DropDownList control (see Figure 1). The page in Listing 1 describes how to bind the DropDownList control to the SqlDataSource control.

Figure 1: Search data using the SqlDataSource control

Listing 1: DisplayTitles.aspx

Display Titles </ Title> </ hEAD> <body> <form id = "form1" runat = "server"> <ask: DropDownList ID = "DropDownList1" DataSourceID = "SqlDataSource1" DataTextField = "Title" Runat = "server" /> <asp: sqldatasource ID = "SqlDataSource1" Connectionstring = "Server = localhost; database = pubs" SelectCommand = "SELECT TIM TIM TIM" Runat = "server" /> </ form> </ body> </ html> Note that the SQLDataSource control in Listing 1 is used to provide a connection string, and the SQL SELECT command is used to retrieve records from the database. The DROPDOWNLIST control is bound to the SqlDataSource control via its DataSourceID property. Use the DataSource control to cache data With the DataSource control, not only make it easier to connect to the database, but also make the cache database data easier. Simply set one or two properties on the SqlDataSource control, you can automatically cache data represented by the DataSource control in memory. For example, if you want to cache the Titles database table in memory in memory, you can declare the SqlDataSource control in the following way. <asp: sqldatasource ID = "SqlDataSource1" EnableCaching = "True" Cachedure = "600" Connectionstring = "Server = localhost; database = pubs" SelectCommand = "SELECT TIM TIM TIM" Runat = "server" /> If the value of the EnableCaching property is true, SqlDataSource will automatically cache the data retrieved through SELECTCOMMAND. With the Cachedure property, you can specify the time (in seconds) of the cache data before refreshing the data in the database. By default, SqlDataSource uses absolute expiration policies to cache data, that is, the number of seconds per specified is refreshed once from the database. In addition, you can choose to use variable expiration strategies. If you configure SqlDataSource to use a variable expiration policy, the data will not expire as long as you continue access to data. If you need to cache a large number of projects, use variable expiration policies will be very useful because this expiration policy will only reserve the most frequent projects in memory. For example, the following SQLDataSourceControl is configured to use a variable expiration strategy, the expiration time is 10 minutes. <asp: sqldatasource ID = "SqlDataSource1" EnableCaching = "True" CacheexpirationPolicy = "sliding" Cachedure = "600" Connectionstring = "Server = localhost; database = pubs" SelectCommand = "SELECT TIM TIM TIM" Runat = "server" /> Since the value of the CacheExpirationPolicy property is set to sligned, the value of the cacheduration property is set to 600, so, as long as you continue to access within 10 minutes, the data indicated by this SqlDataSource will remain in memory. Back to top Use SQL Cache Invalidation SQL Cache INVALIDATION is one of the new features of ASP.NET 2.0 Framework. Use SQL Cache Invalidation to get all the performance advantages of cache without worrying about data expiration. SQL Cache Invalidation automatically updates the data in the cache when you change the data in the underlying database. SQL Cache Invalidation Check the data changes by continuous polling the database in the background. Every time you have a certain time (milliseconds), ASP.NET Framework checks if there is an update in the database. If ASP.NET Framework detects any changes, remove any item added from the database from the database (ie, these items will expire). Note: Microsoft SQL Server 2005 supports a distinct SQL Cache Invalidation method. You can configure SQL Server 2005 to notify ASP.NET applications when changing in database, database tables, or database rows. This way, ASP.NET Framework does not need to check the data changes by continuously polling SQL Server 2005 databases. It should be noted that SQL Cache Invalidation can only be used in Microsoft SQL Server 7 and higher, which cannot be used for other databases such as Microsoft Access or Oracle. SQL Cache Invalidation can be used when the output of the entire page is cached, using the DataSource control or directly using the Cache object. These three situations will be described below. Configure SQL Cache Invalidation Before using SQL Cache Invalidation in a web application, you must first perform some configuration steps. The Microsoft SQL Server must be configured to support SQL Cache Invalidation and must also add the necessary configuration information in the application's web configuration file. You can configure SQL Server as follows: Use the ASPNET_REGSQL command line tool, or use the SqlCachedependencyAdmin class. Enable SQL Cache Invalidation with ASPNET_REQSQL Using the ASPNET_REGSQL tool, you can configure SQL Cache Invalidation through the command line. The ASPNET_REGSQL tool is located in the Windows / Microsoft.Net / Framework / [Release] folder. To use this tool, you must open the Command Prompt window and browse to this folder. To support SQL Cache Invalidation when using the PUBS database, you need to perform the following command. ASPNET_REGSQL-E-D Pubs -ed The -e option allows the ASPNET_REGSQL tool to use integrated security settings when connecting to the database server. The -d option is used to select a PUBS database. Finally, the -ed option is used to enable SQL Cache Invalidation for the database. When this command is executed, a new database table named ASPNET_SQLCACHETABLESFORCHANGENOTIFICA will be added to the database. This table contains a list of all database tables that enable SQL Cache Invalidation. This command will also add a set of stored procedures in the database. After enabling SQL Cache Invalidation for the database, you must select a specific table to enable SQL Cache Invalid from the database. The following command will enable SQL Cache Invalidation for the Titles database table. ASPNET_REGSQL-E-D Pubs -t Titles -Et -t option is used to select a database table. The -t option enables SQL Cache Invalidation for the database table. Of course, you can enable SQL Cache Invalidation for multiple tables by repeating this command for each database table. When this command is executed, a trigger will be added to the database table. As long as you modify the table, this trigger will trigger and update the ASPNET_SQLCACHETABLESFORCHANGENOTIFICATION table. Finally, you want to get a list of tables for SQL Cache Invalidation in a particular database, you can use the following command. ASPNET_REGSQL-E-D Pubs -LT This method will select a list of tables from the ASPNET_SQLCACHETABLESFORCHANGENOTIFICATION. In addition, you can retrieve this information by performing queries directly in the database table. Use the SqlcachedependencyAdmin class The ASPNET_REGSQL tool configures Microsoft SQL Server using the SqlCachedependencyAdmin class in the background. If you prefer, you can use this type directly from the ASP.NET page. The SQLCachedependencyAdmin class has five important methods: • Disablenotifications - Disable SQL Cache Invalidation for specific databases. • DisableTableForNotifications - Disable SQL Cache Invalidation for specific tables in the database. • Enablenotifications - Enables SQL Cache Invalidation for a specific database. • EnableTableForNotifications - Enables SQL Cache Invalidation to specific tables in the database. • GetTablesenableDforNotifications - Returns a list of all tables that enable SQL Cache Invalidation. For example, using the ASP.NET page in Listing 2, you can configure SQL Cache Invalidation for any table in the PUBS database (see Figure 2). Figure 2: Enable SQL Cache Invalid from the ASP.NET page Listing 2: Enablesci.aspx (C #) <% @ Page language = "c #"%> <% @ Import namespace = "system.web.caching"%> <script runat = "server"> Const string connectionstring = "server = localhost; database = pubs"; Void Page_Load () { IF (! ispostback) { Sqlcachedependencyadmin.enablenotifications Connectionstring); SqlDataSource1.selectParameters.Add ("Connectionstring", Connectionstring); } } Void EnableTable (Object S, Eventargs E) { Try { Sqlcachedependencyadmin.enableetablefornotifications Connectionstring, TXTTABLENAME.TEXT); } Catch (Exception EX) { LBLERRORMESSAGE.TEXT = EX.MESSAGE; } TXTTABLENAME.TEXT = ""; } </ script> <html> <head runat = "server"> <title> Enable SQL Cache Invalidation </ Title> </ hEAD> <body> <form id = "form1" runat = "server"> <H1> SQL Cache Invalidation </ h1> The following table has enabled SQL Cache Invalidation: <asp: gridview id = "grdtables" DataSourceId = "SqlDataSource1" Cellpadding = "10" Showheader = "false" runat = "server" /> <ask: ObjectDataSource ID = "SqlDataSource1" TypeName = "system.web.caching.sqlcachedependencyadmin" selectmethod = "gettablesenabledfornotifications" Runat = "server" /> <asp: label id = "lblerrorMessage" enableviewState = "false" Forecolor = "red" runat = "server" /> <asp: textbox id = "txttablename" runat = "server" /> <asp: button text = "enable table" onclick = "enabletable" Runat = "server" /> </ form> </ body> </ html> Listing 2: Enablesci.aspx (Visual Basic .NET) <% @ Page language = "vb"%> <% @ Import namespace = "system.web.caching"%> <script runat = "server"> Const connectionString as string = "server = localhost; database = pubs" SUB Page_Load () IF not ispostback. Sqlcachedependencyadmin.enablenotifications (_ CONNECTIONSTRING) SqlDataSource1.SelectParameters.Add ("Connectionstring", _ CONNECTIONSTRING) END IF End Sub Sub Enabletable (Byval S as Object, ByVal E as Eventargs) Try Sqlcachedependencyadmin.enableetablefornotifications (_ Connectionstring, TXTTABLENAME.TEXT) Catch exception LBLERRORMESSAGE.TEXT = EX.MESSAGE END TRY TXTTABLENAME.TEXT = "" End Sub </ script> <html> <head id = "Head1" runat = "server"> <title> configuresci </ title> </ hEAD> <body> <form id = "form1" runat = "server"> <H1> SQL Cache Invalidation </ h1> The following table has enabled SQL Cache Invalidation: <ask: gridview id = "grdtables" DataSourceId = "sqldatasource1" cellpadding = "10" showheader = "false" runat = "server" /> <ask: ObjectDataSource ID = "SqlDataSource1" TypeName = "system.web.caching.sqlcachedependencyadmin" SelectMethod = "gettablesenabledfornotifications" Runat = "server" /> <asp: label id = "lblerrorMessage" enableviewState = "false" Forecolor = "red" runat = "server" /> <asp: textbox id = "txttablename" runat = "server" /> <ask: button id = "button1" text = "enable table" OnClick = "enabletable" runat = "server" /> </ form> </ body> </ html> In Listing 2, the Connectionstring constant is used to select the database enabled SQL Cache Invalidation (if you want to enable SQL Cache Invalidation for the Pubs Database, you can change the value of this constant). In the Page_Load method, call the Enablenotifications method on the SQLCachedependencyAdmin class, which enables SQL Cache Invalidation for the database specified by the Connectionstring constant. The GridView in Listing 2 shows all database tables that currently enabled SQL Cache Invalidation. GridView is bound to the ObjectDataSource control, which calls the GetTablesNeableDforNotifications method for its SelectMethod. Finally, you can enable SQL Cache Invalidation to other tables using the pages in Listing 2. EnableTableForNotifications methods are called when you enter the name of the table in the text box and click the "Enable Table" button. SQL Cache Invalidation Web Configuration Settings Before using SQL Cache Invalidation in the ASP.NET application, the next step is to update your web configuration file. You need to configure ASP.NET Framework to poll the database of SQL Cache Invalidation. The web configuration file in Listing 3 contains configuration information necessary to polling the PUBS database. Listing 3: Web.config <Configuration> <Connectionstrings> <add name = "mysqlserver" Connectionstring = "Server = localhost; database = pubs" /> </ connectionstrings> <system.Web> <caching> <sqlcachedependency enabled = "true"> <databases> <add Name = "PUBS" Connectionstringname = "mysqlserver" PollTime = "60000" /> </ databases> </ sqlcachedependency> </ caching> </system.web> </ configure> The web configuration file in Listing 3 contains two parts. <ConnectionstringsTringsTringsTringsTRingsTRingsTrings The part is used to create a database connection string to connect to a PUBS database called MySQLServer. The Caching section is used to configure SQL Cache Invalidation polling. In the <Databases> sub-section, you can list one or more databases to be polled to check the data changes. In list 3, the database represented by MySQLServer is polled once per minute (every 60000 milliseconds). You can specify different polling intervals for different databases. Every time you poll the database to check the data changes, both the server must perform some operations. If you think the data in the database does not change frequently, you can increase the polling interval. Use SQL Cache Invalidation in the page output cache Now, we have completed all configuration steps for SQL Cache Invalidation, which can be used in the ASP.NET page. One method is to use SQL Cache Invalidation in the page output cache. The page output cache allows you to cache all content displayed in the memory. By using SQL Cache Invalidation, you can automatically update the cached page when changing (only) database tables. For example, the page in Listing 4 shows the contents of the Titles database table in the GridView control. At the top of this page, the OutputCache instruction is used to cache the page content in memory. If the Titles database table changes, the Sqldependency property will update the page. Listing 4: OutputCachetitles.aspx <% @ OutputCache Sqldependency = "Pubs: Titles" Duration = "6000" VarybyParam = "None"%> <html> <head runat = "server"> <title> Output Cache Titles </ Title> </ hEAD> <body> <form id = "form1" runat = "server"> <% = Datetime.now%> <ask: GridView ID = "grdtitles" DataSourceID = "SqlDataSource1" Runat = "server" /> <ask: SQLDataSource ID = "SqlDataSource1" SelectCommand = "SELECT * from Titles" CONNECTIONSTRING = "<% $ connectionstrings: mysqlserver%>" Runat = "server" /> </ form> </ body> </ html> Note that the SQLDependency property references the name of the database defined in the web configuration file. Since we specified a Pubs database in a minute to check the data changes, if the database changes, the page in the list 4 will be updated within a minute. You can list multiple databases and / or multiple database tables for the SQLDependency property value. To create multiple dependencies, just separate each dependency with a semicolon. Use SQL Cache Invalidation in the DataSource control In addition to using SQL Cache Invalidation in the Page Output Cache, you can also use SQL Cache Invalidation directly in the DataSource control. If you want to use the same database data in multiple pages, consider using SQL Cache Invalidation in the DataSource control. SqlDataSource, AccessDataSource and ObjectDataSource controls support SQLCachedependency properties. For example, the page in the list 5 uses SQL Cache Invalidation in the SqlDataSource control. Listing 5: SqlDataSourceCaching.aspx <html> <head id = "Head1" runat = "server"> <title> SqlDataSource Caching </ Title> </ hEAD> <body> <form id = "form1" runat = "server"> <% = Datetime.now%> <ask: GridView ID = "grdtitles" DataSourceID = "SqlDataSource1" Runat = "server" /> <asp: sqldatasource ID = "SqlDataSource1" EnableCaching = "True" Sqlcachedependency = "pubs: titles" SelectCommand = "SELECT * from Titles" CONNECTIONSTRING = "<% $ connectionstrings: mysqlserver%>" Runat = "server" /> </ form> </ body> </ html> In Listing 5, the SqlDataSource control is declared using both of Both EnableCaching and SqlCachedependencency. The syntax used by the SQLCachedependencence property is the same as the SQLDependency property of the OutputCache instruction. You need to list the name of the database, followed by the name of the database table. Use SQL Cache Invalidation in the Cache object Finally, you can use SQL Cache Invalidation in the Cache object. This option allows you to maximize the programming of SQL Cache Invalidation. To use SQL Cache Invalidation in the Cache object, you will need to create an instance of a SQLCachedependency object. SQLCACHEDEPENDENCY objects can be used when inserting a new object in Cache using the INSERT method. For example, the page in Listing 6 displays the number of records in the Titles database table. The count is based on the dependency of the underlying database table. Listing 6: DisplayTITLANT.ASPX (C #) <% @ Page language = "c #"%> <% @ Import namespace = "system.data.sqlclient"%> <script runat = "server"> Void Page_Load () { INT count = 0; IF (cache ["title"]! = null) { Count = (int) cache ["titlecount"]; } Else { String connectionString = ConfigurationSettings.Connectionstrings [ "mysqlserver"]. consNectionstring; SqlConnection Con = New SqlConnection (Connectionstring); SQLCommand cmd = new SQLCommand ("Select Count (*) from Titles", Con); C.Open (); Count = (int) cmd.executescalar (); C. close (); Cache.insert ("Titlecount", Count, New Sqlcachedependence ("Pubs", "Titles")); } LBltitlecount.text = count.toString (); } </ script> <html> <head runat = "server"> <title> Display Title Count </ Title> </ hEAD> <body> <form id = "form1" runat = "server"> <asp: label id = "lbltitlecount" runat = "server" /> </ form> </ body> </ html> Listing 6: DisplayTITLANT.ASPX (Visual Basic .NET) <% @ Page language = "vb"%> <% @ import namespace = "system.data.sqlclient"%> <script runat = "server"> SUB Page_Load () Dim count as integer = 0 IF not cache ("titlecount") is nothing then Count = Convert.Toint32 (Cache ("TitleCount")) Else DIM Connectionstring as string = _ ConfigurationSettings.Connectionstrings (_ "mysqlserver"). Connectionstring DIM Con As New SqlConnection (Connectionstring) DIM CMD AS New_ SQLCommand ("Select Count (*) from Titles", CON) Con.open () Count = Convert.Toint32 (cmd.executescalar ()) Con. close () Cache.insert ("Titlecount", Count, _ New Sqlcachedependency ("Pubs", "Titles"))) END IF Lbltitlecount.text = count.toString () End Sub </ script> <html> <head id = "Head1" runat = "server"> <title> Display Titles Count </ Title> </ hEAD> <body> <form id = "form1" runat = "server"> <asp: label id = "lbltitlecount" runat = "server" /> </ form> </ body> </ html> Back to top Use Post-Cache Substitution In many cases, you need a part of the cache page instead of the entire page. For example, on your web site homepage, you may want to display a random title ad and record in the database table. If the entire page is cached, each user will see the same title ad on each requested page. To handle this problem with dynamic content and cache content, a method is to use a web user control. Because OutputCache instructions can be added to the web user control, the contents of the web user control can be cached so even if the content containing the page is not cached. But sometimes there may be a possibilities. Although you can use the web user control to add cached content on dynamic pages, but in many cases, you actually want to add dynamic content to the cached page. For example, suppose you want to cache the entire page, leaving only a small area to display the user name of the current user. In this case, it is best to use post-cache substitude. ASP.NET 2.0 Framework introduces a new control called Substitution control. You can use the Substitution control to insert dynamic content in the cached page. The page in Listing 7 uses the substection control into the cache of the cache (see Figure 3). Figure 3: Display the username using the Substitution control Listing 7: Postcachesubstitude.aspx (C #) <% @ Page language = "c #"%> <% @ Outputcache duration = "6000" VarybyParam = "none"%> <script runat = "server"> Static String DisplayUserName (httpcontext context) { IF (! context.Request.isauthenticated) Return "anonymous"; Else Return context.user.Identity.name; } </ script> <html> <head runat = "server"> <title> post cache substitude </ title> </ hEAD> <body> <form id = "form1" runat = "server"> Welcome <ask: Substitude MethodName = "displayusername" runat = "server" />! This page is cached because time <% = DATETIME.NOW.TOSTRING ("T")%> There is no change. </ form> </ body> </ html> Listing 7: Postcachesubstitude.aspx (Visual Basic .NET) <% @ Page language = "vb"%> <% @ Outputcache duration = "6000" VarybyParam = "none"%> <script runat = "server"> Shared function displayusername (Byval Context As httpcontext) As string If not context.request.isauthenticated then Return "Anonymous" Else Return context.user.Identity.name END IF END FUNCTION </ script> <html> <head id = "Head1" runat = "server"> <title> post cache substitude </ title> </ hEAD> <body> <form id = "form1" runat = "server"> Welcome <ask: SubstitutionID = "substitude1" MethodName = "DisplayUsername" Runat = "server" />! This page is cached because time <% = DATETIME.NOW.TOSTRING ("T")%> There is no change. </ form> </ body> </ html> Substitution controls have a very important property: the methodname property. The methodname property is used to represent the method called back dynamic content. The method called by the Substitution control must be a static method (method in Visual Basic .NET). In addition, the method must also have a parameter representing the current httpContext. In ASP.NET 2.0 Framework, the ADROTATOR control has been modified to support post-cache substitution. If an ADROTATOR control is added to the page using the OutputCache instruction, the Adrotator control will automatically exclude from the cache policy that contains the page. Back to top in conclusion Cache has a great impact on the performance of the web application driven by the database. Fortunately, ASP.NET 2.0 Framework provides a number of new important enhancements that allow you to easily use cache functions in your application. The properties included in the new DataSource control make it very easy to cache database data in memory. By using the DataSource control, you can retrieve and cache database data without writing any code. The new SQL Cache Invalidation support automatically reloads database data in the cache when changing data in the underlying database. This feature provides you with all the performance advantages of cache, without having to worry about the problem of expiration. Finally, use the new Substitution control, you can mix dynamic content more easily in the cached page. The Substitution control provides a separate space for your diverse to insert dynamic content in the cached page. Reference • ASP.NET Unleashed • A First Look At ASP.NET V. 2.0 • ASP.NET 2.0 REVEALED About the Author Stephen Walther wrote a bestseller ASP.NET Unleashed for ASP.NET. In addition, he is an architecture designer and major developer of ASP.NET Community Starter Kit (ASP.NET sample application developed by Microsoft). He also provides ASP.NET training for US companies, including NASA and Microsoft.</div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-35438.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div>New Post(0) </div><div></div></div></div><ul class="postlist list-unstyled"> </ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="35438" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved </div><div class="col text-right">Processed: 0.054, SQL: 9</div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script> var debug = DEBUG = 0; var url_rewrite_on = 1; var url_path = './'; var forumarr = {"1":"Tech"}; var fid = 1; var uid = 0; var gid = 0; xn.options.water_image_url = 'view/img/water-small.png'; </script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"></a></body></html><script> var forum_url = 'list-1.html'; var safe_token = '7CvcvDaSCqSmNIFihsn71B9SM6Gfe_2BZc4l5A_2B3A4iSD3Y_2BdJz_2FpFBhUFbqV_2BD5x_2F_2B_2BAQ_2FFxHS6KFpaZNrEUFtw_3D_3D'; var body = $('body'); body.on('submit', '#form', function() { var jthis = $(this); var jsubmit = jthis.find('#submit'); jthis.reset(); jsubmit.button('loading'); var postdata = jthis.serializeObject(); $.xpost(jthis.attr('action'), postdata, function(code, message) { if(code == 0) { location.reload(); } else { $.alert(message); jsubmit.button('reset'); } }); return false; }); function resize_image() { var jmessagelist = $('div.message'); var first_width = jmessagelist.width(); jmessagelist.each(function() { var jdiv = $(this); var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width(); var jmessage_width = Math.min(jdiv.width(), maxwidth); jdiv.find('img, embed, iframe, video').each(function() { var jimg = $(this); var img_width = this.org_width; var img_height = this.org_height; if(!img_width) { var img_width = jimg.attr('width'); var img_height = jimg.attr('height'); this.org_width = img_width; this.org_height = img_height; } if(img_width > jmessage_width) { if(this.tagName == 'IMG') { jimg.width(jmessage_width); jimg.css('height', 'auto'); jimg.css('cursor', 'pointer'); jimg.on('click', function() { }); } else { jimg.width(jmessage_width); var height = (img_height / img_width) * jimg.width(); jimg.height(height); } } }); }); } function resize_table() { $('div.message').each(function() { var jdiv = $(this); jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>'); }); } $(function() { resize_image(); resize_table(); $(window).on('resize', resize_image); }); var jmessage = $('#message'); jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); }); jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); }); $('#nav li[data-active="fid-1"]').addClass('active'); </script>