Host: mysql.puroparty.com
Database: puroparty
Generation Time: Jun 08, 2024 at 04:01 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `bos_ad_types` ORDER BY `option1` ASC LIMIT 0, 30;
Rows: 8
type_id | type_title | type_required | type_use | option1 | def_option1 | option2 | def_option2 | option3 | def_option3 | option4 | def_option4 | option5 | def_option5 | option6 | def_option6 | option7 | def_option7 | option8 | def_option8 | option9 | def_option9 | option10 | def_option10 | template |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | Fundraiser Ad | 3609 | 7961 | state | 3|1|1|Texas | beneficiary | 2||| | contact #1 | 1||| | contact #2 | 1||| | <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtd" width="50%">%adTitle%</td> <td class="headtd" width="50%" align="right">%adNumber%</td> </tr> <tr> <td valign="top" width="50%"> <!--%adSeller%-------------------rrs-----------------> %adDescription% <!-- added rrs --> %adPrice% %adCondition% %adCity% %adState% %adPostal% %adCountry% %adTypeOpt1% %adTypeOpt2% %adTypeOpt3% %adTypeOpt4% %adTypeOpt5% %adTypeOpt6% %adTypeOpt7% %adTypeOpt8% %adTypeOpt9% %adTypeOpt10% %adCatOpt1% %adCatOpt2% %adCatOpt3% %adCatOpt4% %adCatOpt5% </td> <td valign="top" width="50%"> %adImages% </td> </tr> <!-- rrs <tr> <td colspan="2"> %adDescription% </td> </tr> --> </table> |
||||||||||||
22 | Artist Ad | 116249 | 124697 | state | 3|1|1|Texas | group name | 1||| | genre | 1||| | # members | 1||| | booking contact | 1||| | booking # | 1||| | <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtd" width="50%">%adTitle%</td> <td class="headtd" width="50%" align="right">%adNumber%</td> </tr> <tr> <td valign="top" width="50%"> <!--%adSeller%-------------------rrs-----------------> %adDescription% <!-- added rrs --> %adPrice% %adCondition% %adCity% %adState% %adPostal% %adCountry% %adTypeOpt1% %adTypeOpt2% %adTypeOpt3% %adTypeOpt4% %adTypeOpt5% %adTypeOpt6% %adTypeOpt7% %adTypeOpt8% %adTypeOpt9% %adTypeOpt10% %adCatOpt1% %adCatOpt2% %adCatOpt3% %adCatOpt4% %adCatOpt5% </td> <td valign="top" width="50%"> %adImages% </td> </tr> <!-- rrs <tr> <td colspan="2"> %adDescription% </td> </tr> --> </table> |
||||||||
23 | Clubs/Bars | 423449 | 524057 | state | 3|1|1|Texas| | cover charge | 1|||| | contact # | 1|||| | drink selection | 5|4||beer|draft|wine|liquor | food avail? | 4|2|2|yes|no | patio seating? | 4|2|2|yes|no | music | 5|5||piped|jukebox|karaoke|dj|band | other stuff | 5|2|pool|big screens | event mo | 3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec| | event date | 1|||| | <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtd" width="50%">%adTitle%</td> <td class="headtd" width="50%" align="right">%adNumber%</td> </tr> <tr> <td valign="top" width="50%"> <!--%adSeller%-------------------rrs-----------------> %adDescription% <!-- added rrs --> %adPrice% %adCondition% %adCity% %adState% %adPostal% %adCountry% %adTypeOpt1% %adTypeOpt2% %adTypeOpt3% %adTypeOpt4% %adTypeOpt5% %adTypeOpt6% %adTypeOpt7% %adTypeOpt8% %adTypeOpt9% %adTypeOpt10% %adCatOpt1% %adCatOpt2% %adCatOpt3% %adCatOpt4% %adCatOpt5% </td> <td valign="top" width="50%"> %adImages% </td> </tr> <!-- rrs <tr> <td colspan="2"> %adDescription% </td> </tr> --> </table> |
24 | Mariachis | 7705 | 7961 | state | 3|1|1|Texas | group name | 1||| | # members | 1||| | group gender | 4|2|2|all male|all female|mixed | <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtd" width="50%">%adTitle%</td> <td class="headtd" width="50%" align="right">%adNumber%</td> </tr> <tr> <td valign="top" width="50%"> <!--%adSeller%-------------------rrs-----------------> %adDescription% <!-- added rrs --> %adPrice% %adCondition% %adCity% %adState% %adPostal% %adCountry% %adTypeOpt1% %adTypeOpt2% %adTypeOpt3% %adTypeOpt4% %adTypeOpt5% %adTypeOpt6% %adTypeOpt7% %adTypeOpt8% %adTypeOpt9% %adTypeOpt10% %adCatOpt1% %adCatOpt2% %adCatOpt3% %adCatOpt4% %adCatOpt5% </td> <td valign="top" width="50%"> %adImages% </td> </tr> <!-- rrs <tr> <td colspan="2"> %adDescription% </td> </tr> --> </table> |
||||||||||||
25 | Halls | 5657 | 7961 | state | 3|1|1|Texas | contact# 1 | 1||| | contact #2 | 1||| | max capacity | 1||| | <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtd" width="50%">%adTitle%</td> <td class="headtd" width="50%" align="right">%adNumber%</td> </tr> <tr> <td valign="top" width="50%"> <!--%adSeller%-------------------rrs-----------------> %adDescription% <!-- added rrs --> %adPrice% %adCondition% %adCity% %adState% %adPostal% %adCountry% %adTypeOpt1% %adTypeOpt2% %adTypeOpt3% %adTypeOpt4% %adTypeOpt5% %adTypeOpt6% %adTypeOpt7% %adTypeOpt8% %adTypeOpt9% %adTypeOpt10% %adCatOpt1% %adCatOpt2% %adCatOpt3% %adCatOpt4% %adCatOpt5% </td> <td valign="top" width="50%"> %adImages% </td> </tr> <!-- rrs <tr> <td colspan="2"> %adDescription% </td> </tr> --> </table> |
||||||||||||
19 | Concert/Festival Ad | 32281 | 32537 | state | 3|1|1|Texas | ticket price | 2||| | headliner | 2||| | venue name | 1||| | seating | 4|3|2|indoor|outdoor|both | event month | 3|12||jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec| | <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtd" width="50%">%adTitle%</td> <td class="headtd" width="50%" align="right">%adNumber%</td> </tr> <tr> <td valign="top" width="50%"> <!--%adSeller%-------------------rrs-----------------> %adDescription% <!-- added rrs --> %adPrice% %adCondition% %adCity% %adState% %adPostal% %adCountry% %adTypeOpt1% %adTypeOpt2% %adTypeOpt3% %adTypeOpt4% %adTypeOpt5% %adTypeOpt6% %adTypeOpt7% %adTypeOpt8% %adTypeOpt9% %adTypeOpt10% %adCatOpt1% %adCatOpt2% %adCatOpt3% %adCatOpt4% %adCatOpt5% </td> <td valign="top" width="50%"> %adImages% </td> </tr> <!-- rrs <tr> <td colspan="2"> %adDescription% </td> </tr> --> </table> |
||||||||
20 | DJ Ad | 129049 | 523545 | state | 3|1|1|Texas | company name | 1||| | dj name(s) | 2||| | genre types | 2||| | genre specialties | 1||| | equip | 5|2|sound|lights | available area | 1||| | contact #1 | 1||| | contact #2 | 1||| | other comments | 2||| | <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtd" width="50%">%adTitle%</td> <td class="headtd" width="50%" align="right">%adNumber%</td> </tr> <tr> <td valign="top" width="50%"> <!--%adSeller%-------------------rrs-----------------> %adDescription% <!-- added rrs --> %adPrice% %adCondition% %adCity% %adState% %adPostal% %adCountry% %adTypeOpt1% %adTypeOpt2% %adTypeOpt3% %adTypeOpt4% %adTypeOpt5% %adTypeOpt6% %adTypeOpt7% %adTypeOpt8% %adTypeOpt9% %adTypeOpt10% %adCatOpt1% %adCatOpt2% %adCatOpt3% %adCatOpt4% %adCatOpt5% </td> <td valign="top" width="50%"> %adImages% </td> </tr> <!-- rrs <tr> <td colspan="2"> %adDescription% </td> </tr> --> </table> |
21 | Happy Hour Ad! | 249369 | 257817 | State | 3|1|1|Texas| | Cover Charge | 1|||| | Phone | 1|||| | Drinks Avail | 5|4||beer|draft|wine|liquor | Food Avail? | 4|2|2|yes|no | Patio Seating? | 4|2|2|yes|no | music | 5|5||piped|jukebox|karaoke|dj|band | other stuff | 5|2||pool|big screens | <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headtd" width="50%">%adTitle%</td> <td class="headtd" width="50%" align="right">%adNumber%</td> </tr> <tr> <td valign="top" width="50%"> <!--%adSeller%-------------------rrs-----------------> %adDescription% <!-- added rrs --> %adPrice% %adCondition% %adCity% %adState% %adPostal% %adCountry% %adTypeOpt1% %adTypeOpt2% %adTypeOpt3% %adTypeOpt4% %adTypeOpt5% %adTypeOpt6% %adTypeOpt7% %adTypeOpt8% %adTypeOpt9% %adTypeOpt10% %adCatOpt1% %adCatOpt2% %adCatOpt3% %adCatOpt4% %adCatOpt5% </td> <td valign="top" width="50%"> %adImages% </td> </tr> <!-- rrs <tr> <td colspan="2"> %adDescription% </td> </tr> --> </table> |