Frontend editable Table

  • Hey there,

    i have a website for a game where i need a table wich is shown in the frontend and all members can create an entry (put new data in) and edit existing entry just from the frontend (except for the admin no other user can see the backend, just the finished website like it isnt a wordpress generated site)
    the table should look like

    Koordinates

    Player Alliance Position Last_Position Last_Edit Edited_By
    PlayerA AlliB 352/458 352/458 24.10.2014 Don(userName)
    PlayerB Thepanthers 455/600 210/599 23.10.2014 one other member

    and so on, it should be shown like this and it should be able to filter and search for players or a specific alli and then shown all members of that alli.

    Its new for me and i hav created my website without any knowledge so sry if ask for a very great task =)

    can i solve my problem with your plugin and if yea how?
    Thank you for your help

    https://www.ads-software.com/plugins/custom-database-tables/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author ka2

    (@ka2)

    Thanks for the question.

    I’ve tried your request in the custom database tables plugin.

    In the beginning create a table.
    SQL to create table is follows 

    CREATE TABLE Koordinates (
player varchar(100) NOT NULL COMMENT 'Player',
alliance varchar(100) NOT NULL COMMENT 'Alliance',
position varchar(12) NOT NULL COMMENT 'Position',
last_position varchar(12) NOT NULL COMMENT 'Last Position',
edited_by varchar(100) COMMENT 'Edited By',
 INDEX index_1 (alliance)
)

    In addition, you should be set “all users” (all of viewing, registration, editing) access to the table.

    Next, You change the table structure that you have created.
    SQL to alter table is follows

    ALTER TABLE Koordinates
MODIFY updated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last Edit' AFTER last_position

    Create static pages or posts using the shortcodes of the table. Page of viewing, registration and editing must be created new.
    Shortcodes are follows

    viewing table page
    [cdbt-view table="Koordinates" display_list_num="false" exclude_cols="created"]

    entry data page
    [cdbt-entry table="Koordinates"]

    edit data page
    [cdbt-edit table="Koordinates" entry_page="test-entry" display_list_num="false" exclude_cols="created"]

    I made sure that could be registration and search of the table data, and editing from the page of shortcodes, even a non-administrator user.

    So finish in here.

    I’m glad if I to meet the needs of you. How about that?

    Thread Starter DonJuanSon

    (@donjuanson)

    same problem as i had if i want to create the table it says “create table SQL is invalid? what am i doing wrong?

    Plugin Author ka2

    (@ka2)

    I also pity that you did not go well.

    I would like to introduce in detail the same procedure with the screenshot images. However, I can not paste the image in this support forum.

    So, I had to slip issuance the topic to the plug-ins of the official forum.
    URL is here.

    https://ka2.org/cdbt-forum/topic/frontend-editable-table/

    * SQL is a reliable best if you could use it to copy and paste.

    Multiply sorry to trouble you, but, again, please try.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Frontend editable Table’ is closed to new replies.