es


Links to keep:

@Tableofcontents(omitlevel1)

comments page:

http://dev.shopwiki.com/admin/dbQuery.jsp?n=wiki&sq=select+name+from+wiki_data+where+property%3D%27text%27+and+value+like+%27%25%5E%5E%25%27+and+name+not+like+%27help%3A%25%27+and+name+not+like+%27lw%3A%25%27+and+name+not+like+%27user%3A%25%27+and+name+not+like+%27group%3A%25%27+and+name+not+like+%27system%3A%25%27+and+name+not+like+%27deleted%3A%25%27&action=query

To edit home page:

http://dev.shopwiki.com/wikisearch.jsp?ns=ui

To find out what hasn't been touched in two months:

http://dev.shopwiki.com/admin/dbQuery.jsp?n=wiki&sq=SELECT+name%0D%0AFROM+%60wiki_data_version%60+where+property%3D%27text%27+%0D%0Aand+name+not+like+%27lw%3A%25%27+and+name+not+like+%27user%3A%25%27+and+name+not+like+%27group%3A%25%27+and+name+not+like+%27system%3A%25%27+and+name+not+like+%27deleted%3A%25%27%0D%0Agroup+by+name%0D%0Ahaving+max%28ts%29%3Cunix_timestamp%28%29-5184000&action=query

Changes report:

http://dev.shopwiki.com/admin/changeReport.jsp

Broken Image report:

http://dev.shopwiki.com/admin/brokenImageReport.jsp

Broken Link report:

http://dev.shopwiki.com/admin/brokenLinkReport.jsp

User-added dictionary:

http://dev.shopwiki.com/w/Config:Dictionary

Default template:

http://dev.shopwiki.com/w/Template:Default+Article

Stub Articles

http://dev.shopwiki.com/admin/dbQuery.jsp?n=wiki&sq=select+name+from+wiki_data+where+property%3D%27stub%27and+value+%3D%27true%27&action=query

Open edit

expanding it

Email updates list:

http://dev.shopwiki.com/w/System:feedback:Email+Updates

New guides over 2-3 days:

http://dev.shopwiki.com/admin/dbQuery.jsp?n=wiki&sq=select+%0D%0Aname%2C+value%0D%0Afrom+wiki_data+%0D%0Awhere+property%3D%27Creation+Time%27+%0D%0Aand+STR_TO_DATE%28REPLACE%28REPLACE%28REPLACE%28value%2C%27PDT%27%2C%27%27%29%2C%27EST%27%2C%27%27%29%2C%27EDT%27%2C%27%27%29%2C%27%25a+%25b+%25d+%25T+%25Y%27%29+%3E+DATE_SUB%28+CURRENT_DATE+%2C+interval+2+day+%29%0D%0Aand+name+not+like+%27lw%3A%25%27+and+name+not+like+%27system%3A%25%27+and+name+not+like+%27user%3A%25%27+and+name+not+like+%27group%3A%25%27+and+name+not+like+%27review%3A%25%27+and+name+not+like+%27help%3A%25%27+and+name+not+like+%27help%3A%25%27+and+name+not+like+%27deleted%3A%25%27+and+name+not+like+%27config%3A%25%27+and+name+not+like+%27message%25%27+and+name+not+like+%27styles%3A%25%27+and+name+not+like+%27template%3A%25%27+and+name+not+like+%27ui%3A%25%27&action=query

Scott table page:

http://dev.shopwiki.com/w/User:scott:TableTests

To Block IP Addresses

http://dev.shopwiki.com/w/System:Blocked+IPs

To See Where Images Where Uploaded

http://dev.shopwiki.com/admin/dbQuery.jsp?n=wiki&sq=SELECT+wiki_name+%2C+filename+%2C+user+%2C+last_modified+%2C+LENGTH%28data%29++FROM+files+ORDER+BY+last_modified+DESC&action=query

Bugs Feedback Page

http://dev.shopwiki.com/w/System:feedback:bugs

Add and Remove Admin

http://dev.shopwiki.com/admin/admins.jsp

Prohibited URLs

http://dev.shopwiki.com/w/System:ProhibitedURLs

Wiki page edit by day for last 30 days

http://dev.shopwiki.com/admin/dbQuery.jsp?n=central&sq=SELECT+day+%2C+sum%28count%29+%0D%0A+++FROM+counter+%0D%0A++WHERE+%0D%0A++++day+%3E+DATE_SUB%28+CURRENT_DATE+%2C+INTERVAL+30+DAY+%29++AND%0D%0A++++name+LIKE+%22wiki.%25%22++AND+name+NOT+LIKE+%22wiki.styles%3A%25%22+AND+name+NOT+LIKE+%22wiki.system%3A%25%22%0D%0A+++GROUP+BY+day&action=query

Weekly wiki page edit counts, back 30 days

http://dev.shopwiki.com/admin/dbQuery.jsp?n=wiki&sq=select+count%28*%29+Edits%2C+DATE_FORMAT%28min%28FROM_UNIXTIME%28ts%29%29%2C%27%25b+%25d+%25Y%27%29+Week_Starting%0D%0A+from+wiki_data_version+%0D%0A+where+property%3D%27text%27+%0D%0A+and+FROM_UNIXTIME%28ts%29%3EDATE_SUB%28+CURRENT_DATE+%2C+interval+90+day+%29+%0D%0A+and+username+not+in+%28select+substring%28+name%2C+6+%29+from+wiki_data+where+property%3D%27admin%27+and+%28value%3D%27t%27+or+value%3D%27true%27%29%29%0D%0Aand+name+not+like+%27user%3A%25%27%0D%0Aand+name+not+like+%27system%3A%25%27%0D%0Aand+name+not+like+%27lw%3A%25%27%0D%0Aand+name+not+like+%27group%25%27%0D%0Agroup+by+WEEKOFYEAR%28FROM_UNIXTIME%28ts%29%29%0D%0Aorder+by+2+desc&action=query

Grid View

http://dev.shopwiki.com/w/System:Config:Auto+Grid+View

You upload videos here

http://dev.shopwiki.com/videoUpload.jsp

this is the admin status page

http://dev.shopwiki.com/admin/videos.jsp

Video Track

http://dev.shopwiki.com/w/System:Trace:Video

Paypal Error Report

http://dev.shopwiki.com/admin/dbQuery.jsp?n=central&sq=SELECT+*+FROM+payments+WHERE+status%21%3D1&action=query

Survey

http://dev.shopwiki.com/w/System:Survey:test1

Survey Results

http://dev.shopwiki.com/admin/dbQuery.jsp?n=central&sq=select+*+from+counter+where+name+like+%22survey%25%22&action=query

List of all the Guides

http://dev.shopwiki.com/admin/specialReports.jsp

Videos by Tag

http://dev.shopwiki.com/admin/dbQuery.jsp?n=central&sq=select+tag+from+videos+where+approved=1+order+by+tag

Contact List

http://dev.shopwiki.com/admin/getContactList.jsp?obj=system%3AWriting%3AContact+Lists Can use to make any list in System namespace.

Counts International Guides

http://dev.shopwiki.com/admin/dbQuery.jsp?n=wiki&sq=select+left%28name%2C2%29+NameSpace%2C+count%28*%29+num+from+wiki_name+where+%28name+like+%27gb%3A%25%27+or+name+like+%27fr%3A%25%27+or+name+like+%27es%3A%25%27+or+name+like%27nl%3A%25%27%29+group+by+NameSpace&action=query