• Welcome to Mabinogi Duel Forum!
  • New themes...yay!
  • Specifics and feedback here
Hello There, Guest! Login Register FB

Dismiss this notice
A lot of smaller email providers seem to be blocking our activation mails. We are looking into this.

Known blocking providers: gmx (Germany), web.de (Germany), hostineuro (Germany), netsons (Italy), openmailbox.org (France)

Please use a gmail email address or contact an admin or mod in our chat to ask for a manual acitivation.

Dismiss this notice
Patch 2017/04/26: CGC pt. 2, card fixes (Chesha +1 too![?]), premiums changed, Master rewards boosted
Golden week 2017/04/26: 4 new SEs and the usual event stuff


Card database - Suggestion, feedback & discussion thread (Phase: Brainstorming)
#1
This is planned to be the heart for nearly all automated feature in the forum:
Trading widget, daily mutant widget, card price widget and so on

Here the SQL structure for the cards database:
Code:
CARDS DB
Cards table
    - name (name plus set -> DragToHell_WNB) -> unique?-> ID?
    - set
    - card discussion forum link (via ingame name, since the set is irrelevant
    - mutant - yes/no -> redundant with the next?/card name
    - rotation mutant - yes/no -> redundant with table Rotation_mutants
    - Epoli's attributes:
        - Color
        - mutant "gene" -> redundant as well? -> Nah, we need that to filter out the mutants for the bad words DB for example
        - description
    - price link (current/last/median?)
    
Alternative_names table (abbreviations) - I try to make the card filter and other things work with this to make typing easier
    - ID
    - alt name
    - foreign key -> Cards_name [unique]


Rotation_mutants table
    - ID
    - foreign key -> Cards_name
    - when
    - drop chance

Ratings table
    - ID
    - foreign key -> Cards_name
    - rating
    - date
    - user
    - notes/reasons (optional)
    
Nerfs/boosts table
    - ID
    - foreign key -> Cards_name [unique]
    - what changed (old -> new)
    - date
    - user
    - notes/reasons (optional)

Price widget(selling!!!!) table
    - ID
    - foreign key -> Cards_name
    - price
    - date entered (sold?)
    - user
    
TRADING widget table
    - ID
    - foreign key -> Cards_name
    - set (auto from Cards_name) -> NOPE, per SELECT in the tool
    - condition
    - price
    - sell/buy
    - user
    - date entered

These are the tables I came up with so far.
If anyone knows what this is and has some more input on this, feel free to comment.
If you want to know more about specifics or what this is, just ask...I just didnt want to post a text wall if nobody reads it anyway.

Looking for rare/SE/AA/collab cards? -> my sales thread

If you want to support my work, send me some gems and/or leave some feedback Smile

 
Reply
  


Possibly Related Threads...
Thread Author Replies Views Last Post
  Arena Viewer (Top 10 decks) feedback thread sicut 5 778 03-28-2017, 09:40 AM
Last Post: sicut
Bug New Trading Widget - Suggestion, feedback & discussion thread (Phase: Brainstorming) sicut 34 5,245 02-01-2017, 06:35 PM
Last Post: sicut
Lightbulb Chat/Shoutbox - Suggestion, feedback & discussion thread InfiniteEvil 16 2,227 01-06-2017, 05:41 PM
Last Post: Khang
  Pricing Widget - Suggestion, feedback & discussion thread (Phase: Brainstorming) sicut 0 300 11-29-2016, 11:27 AM
Last Post: sicut
  [Suggestion] Card Color Camp Exclusivity Kasmot 5 947 08-08-2016, 05:30 AM
Last Post: sicut

Forum Jump:


Browsing: 1 Guest(s)