Changeset 1209 for trunk/unxsBind/tresource.c
- Timestamp:
- 03/05/10 08:25:06 (2 years ago)
- Files:
-
- 1 modified
-
trunk/unxsBind/tresource.c (modified) (18 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/unxsBind/tresource.c
r166 r1209 40 40 //uCreatedBy: uClient for last insert 41 41 static unsigned uCreatedBy=0; 42 #define ISM3FIELDS43 42 //uCreatedDate: Unix seconds date last insert 44 43 static long uCreatedDate=0; … … 290 289 OpenRow(LANG_FL_tResource_uResource,"black"); 291 290 printf("<input title='%s' type=text name=uResource value=%u size=16 maxlength=10 " 292 ,LANG_FT_tResource_uResource,uResource);291 ,LANG_FT_tResource_uResource,uResource); 293 292 if(guPermLevel>=20 && uMode) 294 293 { … … 312 311 //cName 313 312 OpenRow(LANG_FL_tResource_cName,"black"); 314 printf("<input title='%s' type=text name=cName value=\"%s\" size=40 maxlength=100 " 315 ,LANG_FT_tResource_cName,EncodeDoubleQuotes(cName));313 printf("<input title='%s' type=text name=cName value=\"%s\" size=40 maxlength=100 ", 314 LANG_FT_tResource_cName,EncodeDoubleQuotes(cName)); 316 315 if(guPermLevel>=0 && uMode) 317 316 { … … 326 325 OpenRow(LANG_FL_tResource_uTTL,"black"); 327 326 printf("<input title='%s' type=text name=uTTL value=%u size=16 maxlength=10 " 328 ,LANG_FT_tResource_uTTL,uTTL);327 ,LANG_FT_tResource_uTTL,uTTL); 329 328 if(guPermLevel>=0 && uMode) 330 329 { … … 345 344 OpenRow(LANG_FL_tResource_cParam1,EmptyString(cParam1)); 346 345 printf("<input title='%s' type=text name=cParam1 value=\"%s\" size=80 maxlength=255 " 347 ,LANG_FT_tResource_cParam1,EncodeDoubleQuotes(cParam1));346 ,LANG_FT_tResource_cParam1,EncodeDoubleQuotes(cParam1)); 348 347 if(guPermLevel>=0 && uMode) 349 348 { … … 358 357 OpenRow(LANG_FL_tResource_cParam2,"black"); 359 358 printf("<input title='%s' type=text name=cParam2 value=\"%s\" size=80 maxlength=255 " 360 ,LANG_FT_tResource_cParam2,EncodeDoubleQuotes(cParam2));359 ,LANG_FT_tResource_cParam2,EncodeDoubleQuotes(cParam2)); 361 360 if(guPermLevel>=0 && uMode) 362 361 { … … 371 370 OpenRow(LANG_FL_tResource_cParam3,"black"); 372 371 printf("<input title='%s' type=text name=cParam3 value=\"%s\" size=80 maxlength=255 " 373 ,LANG_FT_tResource_cParam3,EncodeDoubleQuotes(cParam3));372 ,LANG_FT_tResource_cParam3,EncodeDoubleQuotes(cParam3)); 374 373 if(guPermLevel>=0 && uMode) 375 374 { … … 384 383 OpenRow(LANG_FL_tResource_cParam4,"black"); 385 384 printf("<input title='%s' type=text name=cParam4 value=\"%s\" size=80 maxlength=255 " 386 ,LANG_FT_tResource_cParam4,EncodeDoubleQuotes(cParam4));385 ,LANG_FT_tResource_cParam4,EncodeDoubleQuotes(cParam4)); 387 386 if(guPermLevel>=0 && uMode) 388 387 { … … 397 396 OpenRow(LANG_FL_tResource_cComment,"black"); 398 397 printf("<textarea title='%s' cols=40 wrap=hard rows=3 name=cComment " 399 ,LANG_FT_tResource_cComment);398 ,LANG_FT_tResource_cComment); 400 399 if(guPermLevel>=0 && uMode) 401 400 { … … 410 409 OpenRow(LANG_FL_tResource_uOwner,"black"); 411 410 if(guPermLevel>=20 && uMode) 412 { 413 printf("%s<input type=hidden name=uOwner value=%u >\n",ForeignKey(TCLIENT,"cLabel",uOwner),uOwner); 414 } 415 else 416 { 417 printf("%s<input type=hidden name=uOwner value=%u >\n",ForeignKey(TCLIENT,"cLabel",uOwner),uOwner); 418 } 411 printf("%s<input type=hidden name=uOwner value=%u >\n",ForeignKey(TCLIENT,"cLabel",uOwner),uOwner); 412 else 413 printf("%s<input type=hidden name=uOwner value=%u >\n",ForeignKey(TCLIENT,"cLabel",uOwner),uOwner); 419 414 //uCreatedBy 420 415 OpenRow(LANG_FL_tResource_uCreatedBy,"black"); 421 416 if(guPermLevel>=20 && uMode) 422 { 423 printf("%s<input type=hidden name=uCreatedBy value=%u >\n",ForeignKey(TCLIENT,"cLabel",uCreatedBy),uCreatedBy); 424 } 425 else 426 { 427 printf("%s<input type=hidden name=uCreatedBy value=%u >\n",ForeignKey(TCLIENT,"cLabel",uCreatedBy),uCreatedBy); 428 } 417 printf("%s<input type=hidden name=uCreatedBy value=%u >\n", 418 ForeignKey(TCLIENT,"cLabel",uCreatedBy),uCreatedBy); 419 else 420 printf("%s<input type=hidden name=uCreatedBy value=%u >\n", 421 ForeignKey(TCLIENT,"cLabel",uCreatedBy),uCreatedBy); 429 422 //uCreatedDate 430 423 OpenRow(LANG_FL_tResource_uCreatedDate,"black"); … … 437 430 OpenRow(LANG_FL_tResource_uModBy,"black"); 438 431 if(guPermLevel>=20 && uMode) 439 { 440 printf("%s<input type=hidden name=uModBy value=%u >\n",ForeignKey(TCLIENT,"cLabel",uModBy),uModBy); 441 } 442 else 443 { 444 printf("%s<input type=hidden name=uModBy value=%u >\n",ForeignKey(TCLIENT,"cLabel",uModBy),uModBy); 445 } 432 printf("%s<input type=hidden name=uModBy value=%u >\n",ForeignKey(TCLIENT,"cLabel",uModBy),uModBy); 433 else 434 printf("%s<input type=hidden name=uModBy value=%u >\n",ForeignKey(TCLIENT,"cLabel",uModBy),uModBy); 446 435 //uModDate 447 436 OpenRow(LANG_FL_tResource_uModDate,"black"); … … 463 452 MYSQL_RES *res; 464 453 465 sprintf(gcQuery,"SELECT uResource FROM tResource\ 466 WHERE uResource=%u" 467 ,uResource); 454 sprintf(gcQuery,"SELECT uResource FROM tResource WHERE uResource=%u",uResource); 468 455 mysql_query(&gMysql,gcQuery); 469 456 if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); … … 480 467 //sprintf(gcQuery,"New record %u added"); 481 468 uResource=mysql_insert_id(&gMysql); 482 #ifdef ISM3FIELDS483 469 uCreatedDate=luGetCreatedDate("tResource",uResource); 484 470 iDNSLog(uResource,"tResource","New"); 485 #endif486 471 487 472 if(!uMode) 488 473 { 489 sprintf(gcQuery,LANG_NBR_NEWRECADDED,uResource);490 tResource(gcQuery);474 sprintf(gcQuery,LANG_NBR_NEWRECADDED,uResource); 475 tResource(gcQuery); 491 476 } 492 477 … … 496 481 void DeletetResource(void) 497 482 { 498 #ifdef ISM3FIELDS499 483 sprintf(gcQuery,"DELETE FROM tResource WHERE uResource=%u AND ( uOwner=%u OR %u>9 )" 500 484 ,uResource,guLoginClient,guPermLevel); 501 #else502 sprintf(gcQuery,"DELETE FROM tResource WHERE uResource=%u"503 ,uResource);504 #endif505 485 mysql_query(&gMysql,gcQuery); 506 486 if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); … … 509 489 if(mysql_affected_rows(&gMysql)>0) 510 490 { 511 #ifdef ISM3FIELDS512 491 iDNSLog(uResource,"tResource","Del"); 513 #endif514 492 tResource(LANG_NBR_RECDELETED); 515 493 } 516 494 else 517 495 { 518 #ifdef ISM3FIELDS519 496 iDNSLog(uResource,"tResource","DelError"); 520 #endif521 497 tResource(LANG_NBR_RECNOTDELETED); 522 498 } … … 577 553 MYSQL_RES *res; 578 554 MYSQL_ROW field; 579 #ifdef ISM3FIELDS580 555 unsigned uPreModDate=0; 581 556 582 sprintf(gcQuery,"SELECT uResource,uModDate FROM tResource WHERE uResource=%u" 583 ,uResource); 584 #else 585 sprintf(gcQuery,"SELECT uResource FROM tResource WHERE uResource=%u" 586 ,uResource); 587 #endif 588 557 sprintf(gcQuery,"SELECT uResource,uModDate FROM tResource WHERE uResource=%u",uResource); 589 558 mysql_query(&gMysql,gcQuery); 590 559 if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); … … 598 567 599 568 field=mysql_fetch_row(res); 600 #ifdef ISM3FIELDS601 569 sscanf(field[1],"%u",&uPreModDate); 602 570 if(uPreModDate!=uModDate) tResource(LANG_NBR_EXTMOD); 603 #endif604 605 571 Update_tResource(field[0]); 606 572 if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); 607 573 //sprintf(query,"record %s modified",field[0]); 608 574 sprintf(gcQuery,LANG_NBRF_REC_MODIFIED,field[0]); 609 #ifdef ISM3FIELDS610 575 uModDate=luGetModDate("tResource",uResource); 611 576 iDNSLog(uResource,"tResource","Mod"); 612 #endif613 577 tResource(gcQuery); 614 578 … … 668 632 else 669 633 sprintf(cBuf14,"---"); 670 printf("<td><input type=submit name=ED%s value=Edit> %s<td>%s<td>%s<td>%s<td>%s<td>%s<td>%s<td>%s<td>%s<td><textarea disabled>%s</textarea><td>%s<td>%s<td>%s<td>%s<td>%s</tr>" 634 printf("<td><input type=submit name=ED%s value=Edit> %s<td>%s<td>%s<td>%s<td>%s<td>%s<td>%s<td>%s<td>%s<td>" 635 "<textarea disabled>%s</textarea><td>%s<td>%s<td>%s<td>%s<td>%s</tr>" 671 636 ,field[0] 672 637 ,field[0]
