+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: how to create video game mission chart?[SOLVED] (/thread-42334.html)
how to create video game mission chart?[SOLVED] - kucingkembar - Jun-18-2024
sorry for my bad English,
if you would like to know what [video game mission chart] is, look this page:
GTA San Andreas Mission Chart
i like to create something like that,
but i don't know what package to use,
the file result is PDF,JPG, HTML, Excel Spreadsheet, or any common file
this is sample data i got from fandom.com for cyberpunk 2077 game in CSV format:
Output:The Nomad The Rescue
The Streetkid The Rescue
The Corpo-Rat The Rescue
Practice Makes Perfect The Rescue
The Rescue The Ripperdoc
The Rescue The Gig
The Rescue The Gift
The Nomad Practice Makes Perfect
The Streetkid Practice Makes Perfect
The Corpo-Rat Practice Makes Perfect
The Ripperdoc The Ride
The Ripperdoc Psycho Killer
The Ripperdoc Paid In Full
Love Like Fire The Gig
The Ride The Information
The Ride The Pickup
The Ripperdoc Paid in Fullthank you for reading, have a nice day
RE: how to create video game mission chart? - kucingkembar - Jun-19-2024
after i research, i get what i aim
#the data created by other py, this only show how to produce graph
from graphviz import Digraph
import sqlite3
f = Digraph('neato', format='png', encoding='utf8', filename='cp2077', node_attr={'color': 'lightblue2', 'style': 'filled'})
f.attr('node', shape='box')
con = sqlite3.connect("CB2077.db")
cur = con.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS TbFlow (PreviousQuest TEXT, NextQuest TEXT)")
command = "SELECT * FROM TbFlow"
results = cur.execute(command).fetchall()
for result in results:
print(result)
f.edge(result[0], result[1], label='')
f.view()[attachment=2919]