[TYPO3] Certificate Maker: GIFBUILDER with db access
Mark Gillingham
markgill at greatbooks.org
Mon Mar 27 20:28:22 CEST 2006
I'm in over my head and am just about ready to hire someone to help me.
I'll describe the situation. I want to create a self-serve certificate
maker in which a user can log-in to a page, see the courses they've
completed and click on a course title to view an image of a certificate
with details from the specific course.
Using the PHP Script extension I've written a few lines of PHP to access
a table to extract fe_user-like information about courses users have
taken (course_name, course_number, date, etc.).
Using GIFBUILDER (and sticking very close to the Casestory in TSRef),
I've created a mock-up of the certificate and placed sample data on it
(example follows).
Next I attempted to make the PHP script conform to PHP_SCRIPT (again,
following TSRef closely) complete with classes for accessing the db and
querying it (example follows).
Currently, I'm not getting data from the query, but can pass trivial
information from the included classes. However, even if I got all of the
data I wanted, I'm not sure how to place them in the image.
Any advice is appreciated including whom to hire. /mark
page.5 = PHP_SCRIPT
page.5 {
file = fileadmin/scripts/myquery.inc
cObj = TEXT
stdWrap.wrap = <font color="red"> | </font>
stdWrap.case = UPPER
}
page.10 = IMAGE
page.10.file = GIFBUILDER
page.10.file {
XY = 800, [10.h]
10 = IMAGE
10.file = fileadmin/template/images/certificate.png
10.file.width= 800
20 = TEXT
20.text = Great Books Foundation
# 20.text.field = title
20.maxWdith = 700
20.offset = 0,180
20.niceText = 1
20.align = center
20.fontSize= 30
20.angle = 0
20.fontFile = t3lib/fonts/ll.ttf
20.fontColor = blue
22 = TEXT
22 {
text = Course_Name
offset = 0,210
niceText = 1
align = center
fontSize= 24
angle = 0
fontFile = t3lib/fonts/llbold.ttf
fontColor = blue
}
More information about the TYPO3-english
mailing list