felipeabranches/speciesdatabase-alpha-deprecated

A Database to store all kinds of species (alpha deprecated)

speciesdatabase-alpha-deprecated's Issues

Correct db table "camp_campaigns"

Correct db table "camp_campaigns" thats'is mispeeling (camp_campaings).
After, correct in PHP files the SQLs

• campaign.php
• campaigns_card.php
• tomb.php
• tombs_card.php
• tombs_table.php
• admin/camp_campaing.php
• admin/camp_campaings.php
• libraries/campaigns/campaigns.php

Start OOP on tombs

Both in site and admin.
Also, delete the functions "getTombs()" in spicies, campaigns and waypoints class. We should have only one function in tomb's class to deal with these pages.

Start OOP on species

Several pages have the need to show the specie's Nomenclature and the Authoring of his first description.
We need create a Class to deal with this on libraries/species/species.php.
Use the mudules/taxa_tree.php file as reference, and then apply the OOP to it.

Please, commnent bellow the files' names that we can apply this OOP.

Create db table "wpt_provinces"

With the fields

• id
• name
• acronym
• id_country
• description
• note
• image
• published

Set up a login system to access Admin

To help you
https://www.youtube.com/watch?v=Pz5CbLqdGwM
https://www.youtube.com/watch?v=xb8aad4MRx8

You can search for more

Change "camp_waypoints" table's name to "wpt_waypoints"

Also list the PHP that will need SQL edits

Create a treatment for Querry Errors

We need to create a general treatment for Querry Errors in database. If a requested querry in the database doesn't return a result, the error must be shown in a friendly way to the user, not in the PHP Syntax Error format.

Create db table "wpt_countries"

Use this project https://gist.github.com/adhipg/1600028
Add the fields

• description
• note
• image
• published

Create db table "wpt_places"

With the fields

id
name
id_province
description
note
image
published

Enhacements on Waypoints

• Delete from "db_install.sql" the "camp_waypoints", and from "db_update.sql" the lines that you already copy to "wpt_install"
• Delete from "wpt_install" all "DROP TABLE IF EXISTS ..." commands
• Change "camp_units" and "camp_units_types" respectilly to "wpt_units" and "wpt_units_types"
• Do not change the table "camp_waypoints" to "wpt_waypoints" in the creation of the table. Keep the table with "camp_waypoints" name, and then create a SQL command "ALTER TABLE ..."
• Also, all "ALTER TABLE ..." are with "wpt_waypoint" name. So, the command to alter table's name have to come first
• Change files' names on admin: "camp_waypoints", "camp_units", "camp_units_types", respectilly to "wpt_waypoints", "wpt_units", "wpt_units_types"
• Change PHP file "libriries/campaigns/waypoints.php" to a proper folder
• Change all PHP files that uses those tables that we have change their names. A complete list must be provide. Let's contribute on this

Apply OOP on admin/sp_taxonomists.php

Use the existing Class in libraries/species/taxonomists.php.
Feel free to add any table field to the SQL in libraries/species/taxonomists.php, and the necessary HTML tags on the table on admin/sp_taxonomists.php.
Check taxonomists_card.php (on the root) for help.

Make field_selectDB() function return saved DB values

The field_selectDB() function, in the "libraries/fields/fields.php" file, is an HTML select list with options from DB consult.
In it's current state, when creating a new insert, it came with the right values. But when editing, it's do not returns what was already recorded.
Please, fix this so the recorded values come selected.

Make map_values() function work and reusable

The map_values() function, in the "admin/sp_specie.php" file, store two IDs from diferent tables in another table, storing the pairs of a single value with multiples values.
This funcion did not work in this code, and it must be reusable. So, it's need to be created in the "libraries" folder (maybe in another folder called "database").