/* FILE tDeletedResource 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 tdeletedresourcefunc.h while RAD is still to be used. */ #include "mysqlrad.h" //Table Variables //Table Variables //uDeletedResource: Primary Key static unsigned uDeletedResource=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_tDeletedResource "tDeletedResource.uDeletedResource,tDeletedResource.uZone,tDeletedResource.cName,tDeletedResource.uTTL,tDeletedResource.uRRType,tDeletedResource.cParam1,tDeletedResource.cParam2,tDeletedResource.cComment,tDeletedResource.uOwner,tDeletedResource.uCreatedBy,tDeletedResource.uCreatedDate,tDeletedResource.uModBy,tDeletedResource.uModDate" //Local only void Insert_tDeletedResource(void); void Update_tDeletedResource(char *cRowid); void ProcesstDeletedResourceListVars(pentry entries[], int x); //In tDeletedResourcefunc.h file included below void ExtProcesstDeletedResourceVars(pentry entries[], int x); void ExttDeletedResourceCommands(pentry entries[], int x); void ExttDeletedResourceButtons(void); void ExttDeletedResourceNavBar(void); void ExttDeletedResourceGetHook(entry gentries[], int x); void ExttDeletedResourceSelect(void); void ExttDeletedResourceSelectRow(void); void ExttDeletedResourceListSelect(void); void ExttDeletedResourceListFilter(void); void ExttDeletedResourceAuxTable(void); #include "tdeletedresourcefunc.h" //Table Variables Assignment Function void ProcesstDeletedResourceVars(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(""); ExttDeletedResourceButtons(); printf(""); // OpenFieldSet("tDeletedResource Record Data",100); if(guMode==2000 || guMode==2002) tDeletedResourceInput(1); else tDeletedResourceInput(0); // CloseFieldSet(); //Bottom table printf(""); ExttDeletedResourceAuxTable(); Footer_ism3(); }//end of tDeletedResource(); void tDeletedResourceInput(unsigned uMode) { //uDeletedResource OpenRow(LANG_FL_tDeletedResource_uDeletedResource,"black"); printf("=20 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",uDeletedResource); } //uZone OpenRow(LANG_FL_tDeletedResource_uZone,IsZero(uZone)); if(guPermLevel>=20 && uMode) { printf("%s\n",ForeignKey("tZone","cZone",uZone),uZone); } else { printf("%s\n",ForeignKey("tZone","cZone",uZone),uZone); } //cName OpenRow(LANG_FL_tDeletedResource_cName,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cName)); } //uTTL OpenRow(LANG_FL_tDeletedResource_uTTL,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",uTTL); } //uRRType OpenRow(LANG_FL_tDeletedResource_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_tDeletedResource_cParam1,EmptyString(cParam1)); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam1)); } //cParam2 OpenRow(LANG_FL_tDeletedResource_cParam2,"black"); printf("=0 && uMode) { printf(">\n"); } else { printf("disabled>\n"); printf("\n",EncodeDoubleQuotes(cParam2)); } //cComment OpenRow(LANG_FL_tDeletedResource_cComment,"black"); printf("\n",cComment); } else { printf("disabled>%s\n",cComment); printf("\n",EncodeDoubleQuotes(cComment)); } //uOwner OpenRow(LANG_FL_tDeletedResource_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_tDeletedResource_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_tDeletedResource_uCreatedDate,"black"); if(uCreatedDate) printf("%s\n\n",ctime(&uCreatedDate)); else printf("---\n\n"); printf("\n",uCreatedDate); //uModBy OpenRow(LANG_FL_tDeletedResource_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_tDeletedResource_uModDate,"black"); if(uModDate) printf("%s\n\n",ctime(&uModDate)); else printf("---\n\n"); printf("\n",uModDate); printf("\n"); }//void tDeletedResourceInput(unsigned uMode) void NewtDeletedResource(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uDeletedResource FROM tDeletedResource\ WHERE uDeletedResource=%u" ,uDeletedResource); mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); res=mysql_store_result(&gMysql); i=mysql_num_rows(res); if(i) //tDeletedResource("Record already exists"); tDeletedResource(LANG_NBR_RECEXISTS); //insert query Insert_tDeletedResource(); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //sprintf(gcQuery,"New record %u added"); uDeletedResource=mysql_insert_id(&gMysql); #ifdef ISM3FIELDS uCreatedDate=luGetCreatedDate("tDeletedResource",uDeletedResource); iDNSLog(uDeletedResource,"tDeletedResource","New"); #endif if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uDeletedResource); tDeletedResource(gcQuery); } }//NewtDeletedResource(unsigned uMode) void DeletetDeletedResource(void) { #ifdef ISM3FIELDS sprintf(gcQuery,"DELETE FROM tDeletedResource WHERE uDeletedResource=%u AND ( uOwner=%u OR %u>9 )" ,uDeletedResource,guLoginClient,guPermLevel); #else sprintf(gcQuery,"DELETE FROM tDeletedResource WHERE uDeletedResource=%u" ,uDeletedResource); #endif mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //tDeletedResource("Record Deleted"); if(mysql_affected_rows(&gMysql)>0) { #ifdef ISM3FIELDS iDNSLog(uDeletedResource,"tDeletedResource","Del"); #endif tDeletedResource(LANG_NBR_RECDELETED); } else { #ifdef ISM3FIELDS iDNSLog(uDeletedResource,"tDeletedResource","DelError"); #endif tDeletedResource(LANG_NBR_RECNOTDELETED); } }//void DeletetDeletedResource(void) void Insert_tDeletedResource(void) { //insert query sprintf(gcQuery,"INSERT INTO tDeletedResource SET uDeletedResource=%u,uZone=%u,cName='%s',uTTL=%u,uRRType=%u,cParam1='%s',cParam2='%s',cComment='%s',uOwner=%u,uCreatedBy=%u,uCreatedDate=UNIX_TIMESTAMP(NOW())", uDeletedResource ,uZone ,TextAreaSave(cName) ,uTTL ,uRRType ,TextAreaSave(cParam1) ,TextAreaSave(cParam2) ,TextAreaSave(cComment) ,uOwner ,uCreatedBy ); mysql_query(&gMysql,gcQuery); }//void Insert_tDeletedResource(void) void Update_tDeletedResource(char *cRowid) { //update query sprintf(gcQuery,"UPDATE tDeletedResource SET uDeletedResource=%u,uZone=%u,cName='%s',uTTL=%u,uRRType=%u,cParam1='%s',cParam2='%s',cComment='%s',uModBy=%u,uModDate=UNIX_TIMESTAMP(NOW()) WHERE _rowid=%s", uDeletedResource ,uZone ,TextAreaSave(cName) ,uTTL ,uRRType ,TextAreaSave(cParam1) ,TextAreaSave(cParam2) ,TextAreaSave(cComment) ,uModBy ,cRowid); mysql_query(&gMysql,gcQuery); }//void Update_tDeletedResource(void) void ModtDeletedResource(void) { register int i=0; MYSQL_RES *res; MYSQL_ROW field; #ifdef ISM3FIELDS unsigned uPreModDate=0; sprintf(gcQuery,"SELECT uDeletedResource,uModDate FROM tDeletedResource WHERE uDeletedResource=%u" ,uDeletedResource); #else sprintf(gcQuery,"SELECT uDeletedResource FROM tDeletedResource WHERE uDeletedResource=%u" ,uDeletedResource); #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) tDeletedResource("Record does not exist"); if(i<1) tDeletedResource(LANG_NBR_RECNOTEXIST); //if(i>1) tDeletedResource("Multiple rows!"); if(i>1) tDeletedResource(LANG_NBR_MULTRECS); field=mysql_fetch_row(res); #ifdef ISM3FIELDS sscanf(field[1],"%u",&uPreModDate); if(uPreModDate!=uModDate) tDeletedResource(LANG_NBR_EXTMOD); #endif Update_tDeletedResource(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("tDeletedResource",uDeletedResource); iDNSLog(uDeletedResource,"tDeletedResource","Mod"); #endif tDeletedResource(gcQuery); }//ModtDeletedResource(void) void tDeletedResourceList(void) { MYSQL_RES *res; MYSQL_ROW field; ExttDeletedResourceListSelect(); mysql_query(&gMysql,gcQuery); if(mysql_error(&gMysql)[0]) htmlPlainTextError(mysql_error(&gMysql)); res=mysql_store_result(&gMysql); guI=mysql_num_rows(res); PageMachine("tDeletedResourceList",1,"");//1 is auto header list guMode. Opens table! //Filter select drop down ExttDeletedResourceListFilter(); 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("
uDeletedResourceuZonecNameuTTLuRRTypecParam1cParam2cCommentuOwneruCreatedByuCreatedDateuModByuModDate
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(); }//tDeletedResourceList() void CreatetDeletedResource(void) { sprintf(gcQuery,"CREATE TABLE IF NOT EXISTS tDeletedResource ( uDeletedResource 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) )"); mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); }//CreatetDeletedResource()