/* FILE tRRType source code of iDNS.cgi Built by mysqlRAD2.cgi (C) Gary Wallis and Hugo Urquiza 2001-2009 $Id$ PURPOSE Schema dependent RAD generated file. Program app functionality in trrtypefunc.h while RAD is still to be used. */ #include "mysqlrad.h" //Table Variables //Table Variables //uRRType: Primary Key static unsigned uRRType=0; //cLabel: Short label static char cLabel[33]={""}; //uParam1: Requires parameter 1 static unsigned uParam1=0; static char cYesNouParam1[32]={""}; //uParam2: Requires parameter 2 static unsigned uParam2=0; static char cYesNouParam2[32]={""}; //cParam1Func: Input validation function static char cParam1Func[33]={""}; //cParam2Func: Input validation function static char cParam2Func[33]={""}; //cParam3Func: Input validation function static char cParam3Func[33]={""}; //cParam4Func: Input validation function static char cParam4Func[33]={""}; //cParam1Label: Label for interfaces static char cParam1Label[33]={""}; //cParam2Label: Label for interfaces static char cParam2Label[33]={""}; //cParam3Label: Label for interfaces static char cParam3Label[33]={""}; //cParam4Label: Label for interfaces static char cParam4Label[33]={""}; //cParam1Tip: Html title tool-tip for interfaces static char cParam1Tip[101]={""}; //cParam2Tip: Html title tool-tip for interfaces static char cParam2Tip[101]={""}; //cParam3Tip: Html title tool-tip for interfaces static char cParam3Tip[101]={""}; //cParam4Tip: Html title tool-tip for interfaces static char cParam4Tip[101]={""}; //uParam3: Requires parameter 3 static unsigned uParam3=0; static char cYesNouParam3[32]={""}; //uParam4: Requires parameter 4 static unsigned uParam4=0; static char cYesNouParam4[32]={""}; //uName: Requires tResource.cName static unsigned uName=0; static char cYesNouName[32]={""}; //cNameFunc: Input validation function static char cNameFunc[33]={""}; //cNameLabel: Label for interfaces static char cNameLabel[33]={""}; //cNameTip: Html title tool-tip for interfaces static char cNameTip[101]={""}; //uOwner: Record owner static unsigned uOwner=0; //uCreatedBy: uClient for last insert static unsigned uCreatedBy=0; #define ISM3FIELDS //uCreatedDate: Unix seconds date last insert static long uCreatedDate=0; //uModBy: uClient for last update static unsigned uModBy=0; //uModDate: Unix seconds date last update static long uModDate=0; #define VAR_LIST_tRRType "tRRType.uRRType,tRRType.cLabel,tRRType.uParam1,tRRType.uParam2,tRRType.cParam1Func,tRRType.cParam2Func,tRRType.cParam3Func,tRRType.cParam4Func,tRRType.cParam1Label,tRRType.cParam2Label,tRRType.cParam3Label,tRRType.cParam4Label,tRRType.cParam1Tip,tRRType.cParam2Tip,tRRType.cParam3Tip,tRRType.cParam4Tip,tRRType.uParam3,tRRType.uParam4,tRRType.uName,tRRType.cNameFunc,tRRType.cNameLabel,tRRType.cNameTip,tRRType.uOwner,tRRType.uCreatedBy,tRRType.uCreatedDate,tRRType.uModBy,tRRType.uModDate" //Local only void Insert_tRRType(void); void Update_tRRType(char *cRowid); void ProcesstRRTypeListVars(pentry entries[], int x); //In tRRTypefunc.h file included below void ExtProcesstRRTypeVars(pentry entries[], int x); void ExttRRTypeCommands(pentry entries[], int x); void ExttRRTypeButtons(void); void ExttRRTypeNavBar(void); void ExttRRTypeGetHook(entry gentries[], int x); void ExttRRTypeSelect(void); void ExttRRTypeSelectRow(void); void ExttRRTypeListSelect(void); void ExttRRTypeListFilter(void); void ExttRRTypeAuxTable(void); #include "trrtypefunc.h" //Table Variables Assignment Function void ProcesstRRTypeVars(pentry entries[], int x) { register int i; for(i=0;i\n"); printf(""); printf(""); printf("",gluRowid); if(guI) { if(guMode==6) //printf(" Found"); printf(LANG_NBR_FOUND); else if(guMode==5) //printf(" Modified"); printf(LANG_NBR_MODIFIED); else if(guMode==4) //printf(" New"); printf(LANG_NBR_NEW); printf(LANG_NBRF_SHOWING,gluRowid,guI); } else { if(!cResult[0]) //printf(" No records found"); printf(LANG_NBR_NORECS); } if(cResult[0]) printf("%s",cResult); printf(""); printf(""); ExttRRTypeButtons(); printf(""); // OpenFieldSet("tRRType Record Data",100); if(guMode==2000 || guMode==2002) tRRTypeInput(1); else tRRTypeInput(0); // CloseFieldSet(); //Bottom table printf(""); ExttRRTypeAuxTable(); Footer_ism3(); }//end of tRRType(); void tRRTypeInput(unsigned uMode) { //uRRType OpenRow(LANG_FL_tRRType_uRRType,"black"); printf("=20 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",uRRType); } //cLabel OpenRow(LANG_FL_tRRType_cLabel,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cLabel)); } //uParam1 OpenRow(LANG_FL_tRRType_uParam1,"black"); if(guPermLevel>=0 && uMode) YesNoPullDown("uParam1",uParam1,1); else YesNoPullDown("uParam1",uParam1,0); //uParam2 OpenRow(LANG_FL_tRRType_uParam2,"black"); if(guPermLevel>=0 && uMode) YesNoPullDown("uParam2",uParam2,1); else YesNoPullDown("uParam2",uParam2,0); //cParam1Func OpenRow(LANG_FL_tRRType_cParam1Func,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam1Func)); } //cParam2Func OpenRow(LANG_FL_tRRType_cParam2Func,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam2Func)); } //cParam3Func OpenRow(LANG_FL_tRRType_cParam3Func,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam3Func)); } //cParam4Func OpenRow(LANG_FL_tRRType_cParam4Func,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam4Func)); } //cParam1Label OpenRow(LANG_FL_tRRType_cParam1Label,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam1Label)); } //cParam2Label OpenRow(LANG_FL_tRRType_cParam2Label,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam2Label)); } //cParam3Label OpenRow(LANG_FL_tRRType_cParam3Label,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam3Label)); } //cParam4Label OpenRow(LANG_FL_tRRType_cParam4Label,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam4Label)); } //cParam1Tip OpenRow(LANG_FL_tRRType_cParam1Tip,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam1Tip)); } //cParam2Tip OpenRow(LANG_FL_tRRType_cParam2Tip,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam2Tip)); } //cParam3Tip OpenRow(LANG_FL_tRRType_cParam3Tip,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam3Tip)); } //cParam4Tip OpenRow(LANG_FL_tRRType_cParam4Tip,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam4Tip)); } //uParam3 OpenRow(LANG_FL_tRRType_uParam3,"black"); if(guPermLevel>=0 && uMode) YesNoPullDown("uParam3",uParam3,1); else YesNoPullDown("uParam3",uParam3,0); //uParam4 OpenRow(LANG_FL_tRRType_uParam4,"black"); if(guPermLevel>=0 && uMode) YesNoPullDown("uParam4",uParam4,1); else YesNoPullDown("uParam4",uParam4,0); //uName OpenRow(LANG_FL_tRRType_uName,"black"); if(guPermLevel>=0 && uMode) YesNoPullDown("uName",uName,1); else YesNoPullDown("uName",uName,0); //cNameFunc OpenRow(LANG_FL_tRRType_cNameFunc,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cNameFunc)); } //cNameLabel OpenRow(LANG_FL_tRRType_cNameLabel,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cNameLabel)); } //cNameTip OpenRow(LANG_FL_tRRType_cNameTip,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cNameTip)); } //uOwner OpenRow(LANG_FL_tRRType_uOwner,"black"); if(guPermLevel>=20 && uMode) { printf("%s\n",ForeignKey(TCLIENT,"cLabel",uOwner),uOwner); } else { printf("%s\n",ForeignKey(TCLIENT,"cLabel",uOwner),uOwner); } //uCreatedBy OpenRow(LANG_FL_tRRType_uCreatedBy,"black"); if(guPermLevel>=20 && uMode) { printf("%s\n",ForeignKey(TCLIENT,"cLabel",uCreatedBy),uCreatedBy); } else { printf("%s\n",ForeignKey(TCLIENT,"cLabel",uCreatedBy),uCreatedBy); } //uCreatedDate OpenRow(LANG_FL_tRRType_uCreatedDate,"black"); if(uCreatedDate) printf("%s\n\n",ctime(&uCreatedDate)); else printf("---\n\n"); printf("\n",uCreatedDate); //uModBy OpenRow(LANG_FL_tRRType_uModBy,"black"); if(guPermLevel>=20 && uMode) { printf("%s\n",ForeignKey(TCLIENT,"cLabel",uModBy),uModBy); } else { printf("%s\n",ForeignKey(TCLIENT,"cLabel",uModBy),uModBy); } //uModDate OpenRow(LANG_FL_tRRType_uModDate,"black"); if(uModDate) printf("%s\n\n",ctime(&uModDate)); else printf("---\n\n"); printf("\n",uModDate); printf("\n"); }//void tRRTypeInput(unsigned uMode) void NewtRRType(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uRRType FROM tRRType\ WHERE uRRType=%u" ,uRRType); mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); res=mysql_store_result(&gMysql); i=mysql_num_rows(res); if(i) //tRRType("Record already exists"); tRRType(LANG_NBR_RECEXISTS); //insert query Insert_tRRType(); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //sprintf(gcQuery,"New record %u added"); uRRType=mysql_insert_id(&gMysql); #ifdef ISM3FIELDS uCreatedDate=luGetCreatedDate("tRRType",uRRType); iDNSLog(uRRType,"tRRType","New"); #endif if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uRRType); tRRType(gcQuery); } }//NewtRRType(unsigned uMode) void DeletetRRType(void) { #ifdef ISM3FIELDS sprintf(gcQuery,"DELETE FROM tRRType WHERE uRRType=%u AND ( uOwner=%u OR %u>9 )" ,uRRType,guLoginClient,guPermLevel); #else sprintf(gcQuery,"DELETE FROM tRRType WHERE uRRType=%u" ,uRRType); #endif mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //tRRType("Record Deleted"); if(mysql_affected_rows(&gMysql)>0) { #ifdef ISM3FIELDS iDNSLog(uRRType,"tRRType","Del"); #endif tRRType(LANG_NBR_RECDELETED); } else { #ifdef ISM3FIELDS iDNSLog(uRRType,"tRRType","DelError"); #endif tRRType(LANG_NBR_RECNOTDELETED); } }//void DeletetRRType(void) void Insert_tRRType(void) { //insert query sprintf(gcQuery,"INSERT INTO tRRType SET uRRType=%u,cLabel='%s',uParam1=%u,uParam2=%u,cParam1Func='%s',cParam2Func='%s',cParam3Func='%s',cParam4Func='%s',cParam1Label='%s',cParam2Label='%s',cParam3Label='%s',cParam4Label='%s',cParam1Tip='%s',cParam2Tip='%s',cParam3Tip='%s',cParam4Tip='%s',uParam3=%u,uParam4=%u,uName=%u,cNameFunc='%s',cNameLabel='%s',cNameTip='%s',uOwner=%u,uCreatedBy=%u,uCreatedDate=UNIX_TIMESTAMP(NOW())", uRRType ,TextAreaSave(cLabel) ,uParam1 ,uParam2 ,TextAreaSave(cParam1Func) ,TextAreaSave(cParam2Func) ,TextAreaSave(cParam3Func) ,TextAreaSave(cParam4Func) ,TextAreaSave(cParam1Label) ,TextAreaSave(cParam2Label) ,TextAreaSave(cParam3Label) ,TextAreaSave(cParam4Label) ,TextAreaSave(cParam1Tip) ,TextAreaSave(cParam2Tip) ,TextAreaSave(cParam3Tip) ,TextAreaSave(cParam4Tip) ,uParam3 ,uParam4 ,uName ,TextAreaSave(cNameFunc) ,TextAreaSave(cNameLabel) ,TextAreaSave(cNameTip) ,uOwner ,uCreatedBy ); mysql_query(&gMysql,gcQuery); }//void Insert_tRRType(void) void Update_tRRType(char *cRowid) { //update query sprintf(gcQuery,"UPDATE tRRType SET uRRType=%u,cLabel='%s',uParam1=%u,uParam2=%u,cParam1Func='%s',cParam2Func='%s',cParam3Func='%s',cParam4Func='%s',cParam1Label='%s',cParam2Label='%s',cParam3Label='%s',cParam4Label='%s',cParam1Tip='%s',cParam2Tip='%s',cParam3Tip='%s',cParam4Tip='%s',uParam3=%u,uParam4=%u,uName=%u,cNameFunc='%s',cNameLabel='%s',cNameTip='%s',uModBy=%u,uModDate=UNIX_TIMESTAMP(NOW()) WHERE _rowid=%s", uRRType ,TextAreaSave(cLabel) ,uParam1 ,uParam2 ,TextAreaSave(cParam1Func) ,TextAreaSave(cParam2Func) ,TextAreaSave(cParam3Func) ,TextAreaSave(cParam4Func) ,TextAreaSave(cParam1Label) ,TextAreaSave(cParam2Label) ,TextAreaSave(cParam3Label) ,TextAreaSave(cParam4Label) ,TextAreaSave(cParam1Tip) ,TextAreaSave(cParam2Tip) ,TextAreaSave(cParam3Tip) ,TextAreaSave(cParam4Tip) ,uParam3 ,uParam4 ,uName ,TextAreaSave(cNameFunc) ,TextAreaSave(cNameLabel) ,TextAreaSave(cNameTip) ,uModBy ,cRowid); mysql_query(&gMysql,gcQuery); }//void Update_tRRType(void) void ModtRRType(void) { register int i=0; MYSQL_RES *res; MYSQL_ROW field; unsigned uPreModDate=0; //Mod select gcQuery sprintf(gcQuery,"SELECT uRRType,uModDate FROM tRRType WHERE uRRType=%u" ,uRRType); mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); res=mysql_store_result(&gMysql); i=mysql_num_rows(res); //if(i<1) tRRType("Record does not exist"); if(i<1) tRRType(LANG_NBR_RECNOTEXIST); //if(i>1) tRRType("Multiple rows!"); if(i>1) tRRType(LANG_NBR_MULTRECS); field=mysql_fetch_row(res); #ifdef ISM3FIELDS sscanf(field[1],"%u",&uPreModDate); if(uPreModDate!=uModDate) tRRType(LANG_NBR_EXTMOD); #endif Update_tRRType(field[0]); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //sprintf(query,"record %s modified",field[0]); sprintf(gcQuery,LANG_NBRF_REC_MODIFIED,field[0]); #ifdef ISM3FIELDS uModDate=luGetModDate("tRRType",uRRType); iDNSLog(uRRType,"tRRType","Mod"); #endif tRRType(gcQuery); }//ModtRRType(void) void tRRTypeList(void) { MYSQL_RES *res; MYSQL_ROW field; ExttRRTypeListSelect(); mysql_query(&gMysql,gcQuery); if(mysql_error(&gMysql)[0]) htmlPlainTextError(mysql_error(&gMysql)); res=mysql_store_result(&gMysql); guI=mysql_num_rows(res); PageMachine("tRRTypeList",1,"");//1 is auto header list guMode. Opens table! //Filter select drop down ExttRRTypeListFilter(); printf("",gcCommand); printf("\n"); printf("\n"); printf(""); mysql_data_seek(res,guStart-1); for(guN=0;guN<(guEnd-guStart+1);guN++) { field=mysql_fetch_row(res); if(!field) { printf("
uRRTypecLabeluParam1uParam2cParam1FunccParam2FunccParam3FunccParam4FunccParam1LabelcParam2LabelcParam3LabelcParam4LabelcParam1TipcParam2TipcParam3TipcParam4TipuParam3uParam4uNamecNameFunccNameLabelcNameTipuOwneruCreatedByuCreatedDateuModByuModDate
End of data
"); Footer_ism3(); } if(guN % 2) printf(""); else printf(""); long unsigned luYesNo2=strtoul(field[2],NULL,10); char cBuf2[4]; if(luYesNo2) sprintf(cBuf2,"Yes"); else sprintf(cBuf2,"No"); long unsigned luYesNo3=strtoul(field[3],NULL,10); char cBuf3[4]; if(luYesNo3) sprintf(cBuf3,"Yes"); else sprintf(cBuf3,"No"); long unsigned luYesNo16=strtoul(field[16],NULL,10); char cBuf16[4]; if(luYesNo16) sprintf(cBuf16,"Yes"); else sprintf(cBuf16,"No"); long unsigned luYesNo17=strtoul(field[17],NULL,10); char cBuf17[4]; if(luYesNo17) sprintf(cBuf17,"Yes"); else sprintf(cBuf17,"No"); long unsigned luYesNo18=strtoul(field[18],NULL,10); char cBuf18[4]; if(luYesNo18) sprintf(cBuf18,"Yes"); else sprintf(cBuf18,"No"); long luTime24=strtoul(field[24],NULL,10); char cBuf24[32]; if(luTime24) ctime_r(&luTime24,cBuf24); else sprintf(cBuf24,"---"); long luTime26=strtoul(field[26],NULL,10); char cBuf26[32]; if(luTime26) ctime_r(&luTime26,cBuf26); else sprintf(cBuf26,"---"); printf(" %s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s%s" ,field[0] ,field[0] ,field[1] ,cBuf2 ,cBuf3 ,field[4] ,field[5] ,field[6] ,field[7] ,field[8] ,field[9] ,field[10] ,field[11] ,field[12] ,field[13] ,field[14] ,field[15] ,cBuf16 ,cBuf17 ,cBuf18 ,field[19] ,field[20] ,field[21] ,ForeignKey(TCLIENT,"cLabel",strtoul(field[22],NULL,10)) ,ForeignKey(TCLIENT,"cLabel",strtoul(field[23],NULL,10)) ,cBuf24 ,ForeignKey(TCLIENT,"cLabel",strtoul(field[25],NULL,10)) ,cBuf26 ); } printf("\n"); Footer_ism3(); }//tRRTypeList() void CreatetRRType(void) { sprintf(gcQuery,"CREATE TABLE IF NOT EXISTS tRRType ( uRRType INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, cLabel VARCHAR(32) NOT NULL DEFAULT '', UNIQUE (cLabel), uOwner INT UNSIGNED NOT NULL DEFAULT 0,index (uOwner), uCreatedBy INT UNSIGNED NOT NULL DEFAULT 0, uCreatedDate INT UNSIGNED NOT NULL DEFAULT 0, uModBy INT UNSIGNED NOT NULL DEFAULT 0, uModDate INT UNSIGNED NOT NULL DEFAULT 0, uParam1 INT UNSIGNED NOT NULL DEFAULT 0, uParam2 INT UNSIGNED NOT NULL DEFAULT 0, cParam2Func VARCHAR(32) NOT NULL DEFAULT '', cParam1Func VARCHAR(32) NOT NULL DEFAULT '', cParam1Label VARCHAR(32) NOT NULL DEFAULT '', cParam2Label VARCHAR(32) NOT NULL DEFAULT '', cParam1Tip VARCHAR(100) NOT NULL DEFAULT '', cParam2Tip VARCHAR(100) NOT NULL DEFAULT '', cNameLabel VARCHAR(32) NOT NULL DEFAULT '', cNameTip VARCHAR(100) NOT NULL DEFAULT '', cNameFunc VARCHAR(32) NOT NULL DEFAULT '', uName INT UNSIGNED NOT NULL DEFAULT 0, cParam3Func VARCHAR(32) NOT NULL DEFAULT '', cParam4Func VARCHAR(32) NOT NULL DEFAULT '', cParam3Label VARCHAR(32) NOT NULL DEFAULT '', cParam4Label VARCHAR(32) NOT NULL DEFAULT '', cParam3Tip VARCHAR(100) NOT NULL DEFAULT '', cParam4Tip VARCHAR(100) NOT NULL DEFAULT '', uParam3 INT UNSIGNED NOT NULL DEFAULT 0, uParam4 INT UNSIGNED NOT NULL DEFAULT 0 )"); mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); }//CreatetRRType()