function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->person_id = new TableColumn('int', '11', true, '', '');
$this->guardian_id = new TableColumn('int', '11', true, '', '');
$this->class_id = new TableColumn('int', '11', true, '', '');
$this->section = new TableColumn('int', '11', false, '', '');
$this->roll_num = new TableColumn('int', '11', true, '', '');
$this->subj_combination = new TableColumn('int', '11', true, '', '');
$this->status = new TableColumn('enum', '0', true, '', '', array('enrolled', 'expelled', 'left'));
$this->annual_dues = new TableColumn('int', '11', true, '', '');
$this->last_class_arrears = new TableColumn('int', '11', false, '0', '');
$this->start_date = new TableColumn('date', '0', true, '', '');
$this->end_date = new TableColumn('date', '0', true, '', '');
$this->admission_date = new TableColumn('date', '0', true, '', '');
$this->last_date_for_fee_submission = new TableColumn('int', '2', true, '', '');
$this->comments = new TableColumn('text', '0', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'students';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->first_name = new TableColumn('varchar', '30', true, '', 'MUL');
$this->last_name = new TableColumn('varchar', '30', true, '', '');
$this->dob = new TableColumn('date', '0', false, '', '');
$this->gender = new TableColumn('enum', '0', false, '', '', array('Male', 'Female'));
$this->religion = new TableColumn('varchar', '30', false, '', '');
$this->phone = new TableColumn('varchar', '11', true, '', '');
$this->cnic = new TableColumn('varchar', '13', false, '', '');
$this->city = new TableColumn('varchar', '25', false, '', '');
$this->tehsil = new TableColumn('varchar', '25', false, '', '');
$this->district = new TableColumn('varchar', '25', false, '', '');
$this->address = new TableColumn('text', '0', false, '', '');
$this->father_id = new TableColumn('int', '11', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'persons';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->user_roles_id = new TableColumn('int', '11', true, '', '');
$this->pages_id = new TableColumn('int', '11', true, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'user_roles__pages';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->title = new TableColumn('varchar', '30', true, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'exams';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->config_classes_id = new TableColumn('int', '11', true, '', '');
$this->subject_combinations_id = new TableColumn('int', '11', true, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'config_classes__subject_combinations';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->action = new TableColumn('text', '0', true, '', '');
$this->user_id = new TableColumn('int', '11', true, '', '');
$this->time = new TableColumn('timestamp', '0', false, 'CURRENT_TIMESTAMP', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'log_messages';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->key_name = new TableColumn('varchar', '100', true, '', '');
$this->value = new TableColumn('text', '0', true, '', '');
$this->comments = new TableColumn('text', '0', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'default_values';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->advance_record_id = new TableColumn('int', '11', true, '', '');
$this->date = new TableColumn('date', '0', true, '', '');
$this->amount = new TableColumn('int', '11', true, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'advance_return_records';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->category = new TableColumn('varchar', '40', true, '', '');
$this->depreciation = new TableColumn('int', '11', true, '', '');
$this->depreciation_schedule = new TableColumn('int', '11', true, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'config_asset_categories';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->class_attendance_record_id = new TableColumn('int', '11', true, '', '');
$this->student_id = new TableColumn('int', '11', true, '', '');
$this->lectures_attended = new TableColumn('int', '1', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'student_attendance_records';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->employee_id = new TableColumn('int', '11', true, '', '');
$this->date = new TableColumn('date', '0', true, '', '');
$this->status = new TableColumn('enum', '0', true, '', '', array('Present', 'Absent', 'Leave'));
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'emplyee_attendance_records';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->config_class_id = new TableColumn('int', '11', true, '', '');
$this->month = new TableColumn('int', '2', true, '', '');
$this->fee_category_id = new TableColumn('int', '11', true, '', '');
$this->amount = new TableColumn('int', '6', true, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'default_installments';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->test_id = new TableColumn('int', '11', true, '', '');
$this->student_id = new TableColumn('int', '11', true, '', '');
$this->obtained_marks = new TableColumn('varchar', '3', false, '0', '');
$this->comments = new TableColumn('text', '0', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'test_records';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->fee_voucher_id = new TableColumn('int', '11', true, '', '');
$this->fee_category_id = new TableColumn('int', '11', true, '', '');
$this->amount = new TableColumn('int', '11', true, '', '');
$this->comments = new TableColumn('text', '0', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'fee_voucher_datails';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->loan_id = new TableColumn('int', '11', true, '', '');
$this->interest_rate = new TableColumn('int', '11', true, '', '');
$this->repayment_schedule = new TableColumn('int', '11', true, '', '');
$this->comments = new TableColumn('text', '0', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'loan_interest_rates';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->title = new TableColumn('varchar', '60', true, '', '');
$this->url = new TableColumn('text', '0', true, '', '');
$this->parent_id = new TableColumn('int', '11', false, '', '');
$this->position = new TableColumn('int', '11', false, '', '');
$this->show_in_nav = new TableColumn('enum', '0', true, '', '', array('Yes', 'No'));
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'pages';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->text = new TableColumn('text', '0', true, '', '');
$this->date = new TableColumn('date', '0', true, '', '');
$this->user_id = new TableColumn('int', '11', true, '', '');
$this->status = new TableColumn('enum', '0', true, '', '', array('read', 'unread'));
$this->user_id_for = new TableColumn('int', '11', true, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'reminders';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->person_id = new TableColumn('int', '11', true, '', '');
$this->profession = new TableColumn('varchar', '30', true, '', '');
$this->monthly_income = new TableColumn('int', '11', true, '', '');
$this->num_of_family_members = new TableColumn('int', '11', false, '', '');
$this->num_of_children = new TableColumn('int', '11', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'guardians';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->person_id = new TableColumn('int', '11', true, '', '');
$this->amount = new TableColumn('int', '11', true, '', '');
$this->expected_return_date = new TableColumn('date', '0', true, '', '');
$this->to_from = new TableColumn('enum', '0', true, '', '', array('to', 'from'));
$this->comments = new TableColumn('text', '0', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'loan_records';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->class = new TableColumn('varchar', '30', true, '', '');
$this->degree_id = new TableColumn('int', '11', true, '', '');
$this->annual_dues = new TableColumn('int', '11', true, '', '');
$this->total_lectures_per_day = new TableColumn('int', '11', true, '', '');
$this->starting_month = new TableColumn('int', '2', true, '', '');
$this->ending_month = new TableColumn('int', '2', true, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'config_classes';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->employee_id = new TableColumn('int', '11', true, '', '');
$this->month = new TableColumn('int', '2', true, '', '');
$this->year = new TableColumn('int', '4', true, '', '');
$this->amount = new TableColumn('int', '11', true, '', '');
$this->date = new TableColumn('date', '0', true, '', '');
$this->comments = new TableColumn('text', '0', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'pays_records';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->category_id = new TableColumn('int', '11', true, '', '');
$this->description = new TableColumn('text', '0', true, '', '');
$this->purchase_date = new TableColumn('date', '0', true, '', '');
$this->amount = new TableColumn('int', '11', true, '', '');
$this->bill_id = new TableColumn('int', '11', false, '', '');
$this->comments = new TableColumn('text', '0', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'assets';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->person_id = new TableColumn('int', '11', true, '', '');
$this->department_id = new TableColumn('int', '11', true, '', '');
$this->designation_id = new TableColumn('int', '11', true, '', '');
$this->pay = new TableColumn('int', '11', true, '', '');
$this->joining_date = new TableColumn('date', '0', true, '', '');
$this->leaving_date = new TableColumn('date', '0', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'employees';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->student_id = new TableColumn('int', '11', true, '', '');
$this->month = new TableColumn('int', '2', true, '', '');
$this->year = new TableColumn('year', '4', true, '', '');
$this->received_amount = new TableColumn('int', '11', false, '', '');
$this->issue_date = new TableColumn('date', '0', true, '', '');
$this->last_date = new TableColumn('date', '0', true, '', '');
$this->submission_date = new TableColumn('date', '0', false, '', '');
$this->comments = new TableColumn('text', '0', false, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'fee_vouchers';
}
}
parent::__construct($id);
}
function __construct($id = null)
{
$this->id = new TableColumn('int', '11', true, '', 'PRI');
$this->class_id = new TableColumn('int', '11', true, '', '');
$this->section = new TableColumn('int', '11', false, '', '');
$this->subject_id = new TableColumn('int', '11', true, '', '');
$this->syllabus = new TableColumn('varchar', '50', true, '', '');
$this->date = new TableColumn('date', '0', true, '', '');
$this->max_marks = new TableColumn('int', '11', true, '', '');
$this->min_marks = new TableColumn('int', '11', true, '', '');
$this->exam_id = new TableColumn('int', '11', true, '', '');
// get default value
foreach ($this as $field => $info) {
if ($info instanceof TableColumn) {
if ($def = getDefVal($field)) {
$this->{$field}->defValue = $def;
}
$this->{$field}->name = $field;
$this->{$field}->table = 'tests';
}
}
parent::__construct($id);
}
<?php
require_once '../libraries/tableobject_class.php';
require_once '../inc/pubfun.inc.php';
$cookie = isset($_COOKIE['smg_username']) ? $_COOKIE['smg_username'] : 0;
echo $cookie;
$commenter = $_REQUEST['commenter'];
$vowels = array("~", "!", "@", "#", "\$", "%", "^", "&", "*", "(", ")");
$commenter = str_replace($vowels, "", $commenter);
if ($commenter == "小番茄" || $commenter == "番茄小编") {
if ($cookie != "01004660" && $cookie != "01004645") {
echo '<script language=javascript>alert("特殊名字仅番茄网管理员才能使用！")</script>';
echo '<script language=javascript>window.location.href="/fqtg/fqtg.php?id=' . $_REQUEST['tgid'] . ';</script>';
exit;
}
}
$comment = new TableObject('smg_tg_comment');
$comment->commenter = $_REQUEST['commenter'];
$comment->content = $_REQUEST['content'];
$comment->createtime = Date('Y-m-d H:i:s');
$comment->ip = getenv('REMOTE_ADDR');
$comment->tg_id = $_REQUEST['tgid'];
//print_r($comment);
if (!$comment->Insert('id')) {
die(mysql_error());
}
redirecturl("/fqtg/fqtg.php?id=" . $_REQUEST['tgid']);
