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
