NAVIGATION
This shows you the differences between two versions of the page.
english:technics:database:phpwcms_guestbook [2009/10/09 14:06] Knut Heermann (flip-flop) |
english:technics:database:phpwcms_guestbook [2018/06/03 18:09] (current) |
||
---|---|---|---|
Line 11: | Line 11: | ||
| //**TABLE**// ^ //TYPE// ^ //DESCRIPTION// ^ //EXAMPLE// ^ | | //**TABLE**// ^ //TYPE// ^ //DESCRIPTION// ^ //EXAMPLE// ^ | ||
^ guestbook_id | int(11) | running unique ID | 14 . . . | | ^ guestbook_id | int(11) | running unique ID | 14 . . . | | ||
- | ^ guestbook_cid | int(11) | alias ID used in contentpart | 2 | | + | ^ guestbook_cid | int(11) | alias ID used in guestbook contentpart | 2 | |
^ guestbook_msg | text | Text entry | TEST TEXT TEXT ... | | ^ guestbook_msg | text | Text entry | TEST TEXT TEXT ... | | ||
^ guestbook_name | text | User name | Sir Oblong-Fitz-Oblong| | ^ guestbook_name | text | User name | Sir Oblong-Fitz-Oblong| | ||
^ guestbook_email | text | eMail adress | s-o-f-o@example.com | | ^ guestbook_email | text | eMail adress | s-o-f-o@example.com | | ||
^ guestbook_created | int(11) | Date of entry created | 1251067220 | | ^ guestbook_created | int(11) | Date of entry created | 1251067220 | | ||
- | ^ guestbook_trashed | int(1) | Entry killed | 0/9 | | + | ^ guestbook_trashed | int(1) | 0=visible / 9=unvisble (killed) | 0/9 | |
- | ^ guestbook_url | text | user url | http://example.com | | + | ^ guestbook_url | text | user url | example.com | |
- | ^ guestbook_show | int(1) | visible | 0/1/2 | | + | ^ guestbook_show | int(1) | 0=show email / 1=hide email / 2=show email as "info at mail dot com" | 0/1/2 | |
^ guestbook_ip | varchar(20) | user ip | 123.345.678.91 | | ^ guestbook_ip | varchar(20) | user ip | 123.345.678.91 | | ||
- | ^ guestbook_useragent | varchar(255) | useragent | 7ee43b2c7cd249376... | | + | ^ guestbook_useragent | varchar(255) | md5 Server HTTP_USER_AGENT | 7ee43b2c7cd249376... | |
- | ^ guestbook_image | varchar(255) | User uploadet image | ------------ | | + | ^ guestbook_image | varchar(255) | User uploaded image in /filearchive/guestbook_ID/ | 8f9b6821990fc8a7....jpg | |
- | ^ guestbook_imagename | varchar(255) | Nmae of user uploadet image | landscape.jpg | | + | ^ guestbook_imagename | varchar(255) | Name of user uploaded image | imagename.jpg | |