Forum:Project Database Integration

Premise
The wiki's activity has declined severely in the last year; I believe this has to do with a significant reduction in the need for this wiki due to other resources which work "better". When the Clan updates were released by Jagex, they included a Clan Database which can be found on their main website.

Runescape Clan Database

This database gives an up to the minute stats listing, a roster of members, and provides basic "need to know" information on a clan. The inefficiency of this wiki when compared to such a system is astounding, and... quite honestly, we cannot compete with the database unless we can match it.

To that end, I have been discussing the possibility of a new project for this wiki. User:MinigameGod,User:The Excel, and User:The.draziw are working on a system that will allow this wiki to include the basic information found via the database, while also being a medium that is not constricted by character limits, severe censorship, and more adaptability.

The principal idea is to generate a script that will allow the wiki to update information found via the database. We would like to create a template, which creates a basic infobox on a page that provides all needed clan info from the database.

Runescape Clan users will opt to utilize the wiki because it is not restricted by a 2000 character limit. It allows for uploads of pictures. Basically, it works better...

If we can expand this wiki by utilizing the database content, we could easily generate a wiki with 10,000 pages or more (which would make it one of the largest wikia wikis in existence. More importantly, anyone who googles any clan in runescape would see our page as one (if not thee) top result, resulting in a very high traffic for the site.

Info Box Template
To start, a page would simple need a template that has the specific clan's runescape clan channel (cc) name. This would generate an info box which shows the basic information that is readily available from the database, CC name, owner's / deputy owners, total members, total level, citadel, etc. Like this:

Clan Declaration Template
To accompany the basic info box template, a second template will be made that copy's the text displayed on a clan's database page, the clan's deceleration.

Page Creating Bot
Our plan is to further this goal by generating a script or bot that goes to the database, finds clan pages that are not currently on our wiki, and then creates a page on our wiki without a person having to do anything. To do that, the bot creates a page, adds the previously mention templates, and also adds a template to let users know the page has not been edited by a person and needs expanded.

Human Editors
A human editor can visit the page after a bot has created it (or create a page and input the templates themselves) and remove the Pcbot template, and add any content they like.

Example Page
For the purposes of this demo, I have opted to utilize the cc: Clan Quest.

03:20, September 19, 2013 (UTC)