Forms Page: Difference between revisions

From Victory Belles Community Wiki
Jump to navigation Jump to search
(Created page with "This page links to all forms used to enter data into the wiki (as opposed to direct SQL manipulation or other cumbersome methods). All downloads will create comma-separated values files easily viewable in text editors or spreadsheet programs. * '''Associate Vesture With Belle''' - Required information includes {{#cargo_query: tables=ITEMVesture |fields=ITEMVesture._pageID, ITEMVesture.TXT_VestureName, ITEMVesture.TXT_VestureType, I...")
 
No edit summary
Line 1: Line 1:
This page links to all forms used to enter data into the wiki (as opposed to direct SQL manipulation or other cumbersome methods).  All downloads will create comma-separated values files easily viewable in text editors or spreadsheet programs.
This page links to all forms used to enter data into the wiki (as opposed to direct SQL manipulation or other cumbersome methods).  All downloads will create comma-separated values files easily viewable in text editors or spreadsheet programs.


* [[Form:Associate_Vesture_With_Belle|'''Associate Vesture With Belle''']] - Required information includes {{#cargo_query:
* [[Form:Associate_Vesture_With_Belle|'''Associate Vesture With Belle''']] - [[Associate_Vesture_With_Belle_Tutorial|'''Tutorial''']].
tables=ITEMVesture
|fields=ITEMVesture._pageID, ITEMVesture.TXT_VestureName, ITEMVesture.TXT_VestureType, ITEMVesture.TXT_StatBonus
|format=csv
|link text=Vestures data
|filename=ITEMVestures
}} and {{#cargo_query:
tables=MAINBelle
|fields=MAINBelle._pageID, MAINBelle.TXT_CharName
|format=csv
|link text=Belle data
|filename=MAINBelleNamesOnly
}}.  Name the form <BelleName>-<VestureType>, so St. Louis' Honor vesture would be "St. Louis Honor" as the page name.  (This isn't a page anyone is looking at, it's invisible linkage so that pages people do read work correctly).  Fill out the form exactly as it suggests by using the _pageID values for both Belle and Vesture.
* [[Form:Create_a_Vesture|'''Create a Vesture''']] - First, make sure the Vesture doesn't already exist by checking this {{#cargo_query:
* [[Form:Create_a_Vesture|'''Create a Vesture''']] - First, make sure the Vesture doesn't already exist by checking this {{#cargo_query:
tables=ITEMVesture
tables=ITEMVesture

Revision as of 13:51, 2 April 2023

This page links to all forms used to enter data into the wiki (as opposed to direct SQL manipulation or other cumbersome methods). All downloads will create comma-separated values files easily viewable in text editors or spreadsheet programs.

NOTE FOR NERDS: All these forms do is create a nice front-end to connect things together (like associating gear with Belles or resources with maps) via a relational database system. However, it's much easier than explaining said SQL and all the implications of trying to set up SQL users, etc!