/* FILE tResourceImport 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 tresourceimportfunc.h while RAD is still to be used. */ #include "mysqlrad.h" //Table Variables //Table Variables //uResource: Primary Key static unsigned uResource=0; //uZone: Belongs to this tZone static unsigned uZone=0; //cName: Host name relative, full or emtpy=zone static char cName[101]={""}; //uTTL: Optional TTL for this record only static unsigned uTTL=0; //uRRType: Pulldown of resource record type table static unsigned uRRType=0; static char cuRRTypePullDown[256]={""}; //cParam1: Parameter 1 field static char cParam1[256]={""}; //cParam2: Parameter 2 field static char cParam2[256]={""}; //cComment: Optional comment static char *cComment={""}; //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_tResourceImport "tResourceImport.uResource,tResourceImport.uZone,tResourceImport.cName,tResourceImport.uTTL,tResourceImport.uRRType,tResourceImport.cParam1,tResourceImport.cParam2,tResourceImport.cComment,tResourceImport.uOwner,tResourceImport.uCreatedBy,tResourceImport.uCreatedDate,tResourceImport.uModBy,tResourceImport.uModDate" //Local only void Insert_tResourceImport(void); void Update_tResourceImport(char *cRowid); void ProcesstResourceImportListVars(pentry entries[], int x); //In tResourceImportfunc.h file included below void ExtProcesstResourceImportVars(pentry entries[], int x); void ExttResourceImportCommands(pentry entries[], int x); void ExttResourceImportButtons(void); void ExttResourceImportNavBar(void); void ExttResourceImportGetHook(entry gentries[], int x); void ExttResourceImportSelect(void); void ExttResourceImportSelectRow(void); void ExttResourceImportListSelect(void); void ExttResourceImportListFilter(void); void ExttResourceImportAuxTable(void); #include "tresourceimportfunc.h" //Table Variables Assignment Function void ProcesstResourceImportVars(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(""); ExttResourceImportButtons(); printf(""); // OpenFieldSet("tResourceImport Record Data",100); if(guMode==2000 || guMode==2002) tResourceImportInput(1); else tResourceImportInput(0); // CloseFieldSet(); //Bottom table printf(""); ExttResourceImportAuxTable(); Footer_ism3(); }//end of tResourceImport(); void tResourceImportInput(unsigned uMode) { //uResource OpenRow(LANG_FL_tResourceImport_uResource,"black"); printf("=20 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",uResource); } //uZone OpenRow(LANG_FL_tResourceImport_uZone,IsZero(uZone)); if(guPermLevel>=20 && uMode) { printf("%s\n",ForeignKey("tZoneImport","cZone",uZone),uZone); } else { printf("%s\n",ForeignKey("tZoneImport","cZone",uZone),uZone); } //cName OpenRow(LANG_FL_tResourceImport_cName,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cName)); } //uTTL OpenRow(LANG_FL_tResourceImport_uTTL,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",uTTL); } //uRRType OpenRow(LANG_FL_tResourceImport_uRRType,IsZero(uRRType)); if(guPermLevel>=0 && uMode) tTablePullDown("tRRType;cuRRTypePullDown","cLabel","cLabel",uRRType,1); else tTablePullDown("tRRType;cuRRTypePullDown","cLabel","cLabel",uRRType,0); //cParam1 OpenRow(LANG_FL_tResourceImport_cParam1,EmptyString(cParam1)); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam1)); } //cParam2 OpenRow(LANG_FL_tResourceImport_cParam2,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam2)); } //cComment OpenRow(LANG_FL_tResourceImport_cComment,"black"); printf("\n",cComment); } else { printf("disabled>%s\n",cComment); printf("\n",EncodeDoubleQuotes(cComment)); } //uOwner OpenRow(LANG_FL_tResourceImport_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_tResourceImport_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_tResourceImport_uCreatedDate,"black"); if(uCreatedDate) printf("%s\n\n",ctime(&uCreatedDate)); else printf("---\n\n"); printf("\n",uCreatedDate); //uModBy OpenRow(LANG_FL_tResourceImport_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_tResourceImport_uModDate,"black"); if(uModDate) printf("%s\n\n",ctime(&uModDate)); else printf("---\n\n"); printf("\n",uModDate); printf("\n"); }//void tResourceImportInput(unsigned uMode) void NewtResourceImport(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uResource FROM tResourceImport\ WHERE uResource=%u" ,uResource); mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); res=mysql_store_result(&gMysql); i=mysql_num_rows(res); if(i) //tResourceImport("Record already exists"); tResourceImport(LANG_NBR_RECEXISTS); //insert query Insert_tResourceImport(); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //sprintf(gcQuery,"New record %u added"); uResource=mysql_insert_id(&gMysql); #ifdef ISM3FIELDS uCreatedDate=luGetCreatedDate("tResourceImport",uResource); iDNSLog(uResource,"tResourceImport","New"); #endif if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uResource); tResourceImport(gcQuery); } }//NewtResourceImport(unsigned uMode) void DeletetResourceImport(void) { #ifdef ISM3FIELDS sprintf(gcQuery,"DELETE FROM tResourceImport WHERE uResource=%u AND ( uOwner=%u OR %u>9 )" ,uResource,guLoginClient,guPermLevel); #else sprintf(gcQuery,"DELETE FROM tResourceImport WHERE uResource=%u" ,uResource); #endif mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //tResourceImport("Record Deleted"); if(mysql_affected_rows(&gMysql)>0) { #ifdef ISM3FIELDS iDNSLog(uResource,"tResourceImport","Del"); #endif tResourceImport(LANG_NBR_RECDELETED); } else { #ifdef ISM3FIELDS iDNSLog(uResource,"tResourceImport","DelError"); #endif tResourceImport(LANG_NBR_RECNOTDELETED); } }//void DeletetResourceImport(void) void Insert_tResourceImport(void) { //insert query sprintf(gcQuery,"INSERT INTO tResourceImport SET uResource=%u,uZone=%u,cName='%s',uTTL=%u,uRRType=%u,cParam1='%s',cParam2='%s',cComment='%s',uOwner=%u,uCreatedBy=%u,uCreatedDate=UNIX_TIMESTAMP(NOW())", uResource ,uZone ,TextAreaSave(cName) ,uTTL ,uRRType ,TextAreaSave(cParam1) ,TextAreaSave(cParam2) ,TextAreaSave(cComment) ,uOwner ,uCreatedBy ); mysql_query(&gMysql,gcQuery); }//void Insert_tResourceImport(void) void Update_tResourceImport(char *cRowid) { //update query sprintf(gcQuery,"UPDATE tResourceImport SET uResource=%u,uZone=%u,cName='%s',uTTL=%u,uRRType=%u,cParam1='%s',cParam2='%s',cComment='%s',uModBy=%u,uModDate=UNIX_TIMESTAMP(NOW()) WHERE _rowid=%s", uResource ,uZone ,TextAreaSave(cName) ,uTTL ,uRRType ,TextAreaSave(cParam1) ,TextAreaSave(cParam2) ,TextAreaSave(cComment) ,uModBy ,cRowid); mysql_query(&gMysql,gcQuery); }//void Update_tResourceImport(void) void ModtResourceImport(void) { register int i=0; MYSQL_RES *res; MYSQL_ROW field; #ifdef ISM3FIELDS unsigned uPreModDate=0; sprintf(gcQuery,"SELECT uResource,uModDate FROM tResourceImport WHERE uResource=%u" ,uResource); #else sprintf(gcQuery,"SELECT uResource FROM tResourceImport WHERE uResource=%u" ,uResource); #endif 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) tResourceImport("Record does not exist"); if(i<1) tResourceImport(LANG_NBR_RECNOTEXIST); //if(i>1) tResourceImport("Multiple rows!"); if(i>1) tResourceImport(LANG_NBR_MULTRECS); field=mysql_fetch_row(res); #ifdef ISM3FIELDS sscanf(field[1],"%u",&uPreModDate); if(uPreModDate!=uModDate) tResourceImport(LANG_NBR_EXTMOD); #endif Update_tResourceImport(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("tResourceImport",uResource); iDNSLog(uResource,"tResourceImport","Mod"); #endif tResourceImport(gcQuery); }//ModtResourceImport(void) void tResourceImportList(void) { MYSQL_RES *res; MYSQL_ROW field; ExttResourceImportListSelect(); mysql_query(&gMysql,gcQuery); if(mysql_error(&gMysql)[0]) htmlPlainTextError(mysql_error(&gMysql)); res=mysql_store_result(&gMysql); guI=mysql_num_rows(res); PageMachine("tResourceImportList",1,"");//1 is auto header list guMode. Opens table! //Filter select drop down ExttResourceImportListFilter(); 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("
uResourceuZonecNameuTTLuRRTypecParam1cParam2cCommentuOwneruCreatedByuCreatedDateuModByuModDate
End of data
"); Footer_ism3(); } if(guN % 2) printf(""); else printf(""); long luTime10=strtoul(field[10],NULL,10); char cBuf10[32]; if(luTime10) ctime_r(&luTime10,cBuf10); else sprintf(cBuf10,"---"); long luTime12=strtoul(field[12],NULL,10); char cBuf12[32]; if(luTime12) ctime_r(&luTime12,cBuf12); else sprintf(cBuf12,"---"); printf(" %s%s%s%s%s%s%s%s%s%s%s%s" ,field[0] ,field[0] ,ForeignKey("tZone","cZone",strtoul(field[1],NULL,10)) ,field[2] ,field[3] ,ForeignKey("tRRType","cLabel",strtoul(field[4],NULL,10)) ,field[5] ,field[6] ,field[7] ,ForeignKey(TCLIENT,"cLabel",strtoul(field[8],NULL,10)) ,ForeignKey(TCLIENT,"cLabel",strtoul(field[9],NULL,10)) ,cBuf10 ,ForeignKey(TCLIENT,"cLabel",strtoul(field[11],NULL,10)) ,cBuf12 ); } printf("\n"); Footer_ism3(); }//tResourceImportList() void CreatetResourceImport(void) { sprintf(gcQuery,"CREATE TABLE IF NOT EXISTS tResourceImport ( uResource INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, cName VARCHAR(100) NOT NULL DEFAULT '', 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, uTTL INT UNSIGNED NOT NULL DEFAULT 0, uRRType INT UNSIGNED NOT NULL DEFAULT 0, cParam1 VARCHAR(255) NOT NULL DEFAULT '', cParam2 VARCHAR(255) NOT NULL DEFAULT '', cComment TEXT NOT NULL DEFAULT '', uZone INT UNSIGNED NOT NULL DEFAULT 0,index (uZone), cParam3 VARCHAR(255) NOT NULL DEFAULT '', cParam4 VARCHAR(255) NOT NULL DEFAULT '' )"); mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); }//CreatetResourceImport()