darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 *pointup* Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629416 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 I'll try that thanks. Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629419 Share on other sites More sharing options...
darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 already done Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629423 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 Thanks, haha. Also, I'm still getting the errors. Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629427 Share on other sites More sharing options...
darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 gah add or die (mysql_error()."<br />Couldn't execute query: $result"); after $result then tell me what errors u get Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629438 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 This is the error I get: Table 'tullyl00_corn.hidtable' doesn't exist Couldn't execute query: Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629445 Share on other sites More sharing options...
darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 you sure hidtable exists in your database ??? Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629450 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 It doesn't...that was in the code when I got it from some guy...I told you I didn't write this code. Nowhere in the instructions at the top of the page does it say to create this table, and the code worked flawlessly before you started helping me secure it, so I'm quite sure I don't have to create that table on the database. But some of this code is a little above me so, I'm not sure. Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629454 Share on other sites More sharing options...
darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 this code is meant to work with a database i am not sure how it didnt error without it LOL. anyhow add that table see if it works Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629455 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 what fields do i add to that table? Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629458 Share on other sites More sharing options...
darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 actually its not a table just a field LOL Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629460 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 Alright, I was a little confused there, haha. So, any idea what to do? Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629461 Share on other sites More sharing options...
darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 create a field in your table called hidtable and set it to int(11) Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629466 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 Well, it uses multiple tables...do I add it to all of them? Blah..it doesn't work anyways. I tried adding it to the "coach" table. Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629467 Share on other sites More sharing options...
darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 what table is the hidtable field in ??? it has to be in one of those tables Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629472 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 I added it to "coach" in the database. Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629477 Share on other sites More sharing options...
darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 add it to the tully100_corn table Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629478 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 tullyl00_corn is the database. then it has tables "coach" "hscoach" "teams" "youthteams" Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629479 Share on other sites More sharing options...
darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 nvm im dumb lol $rowNum = mysql_num_rows($result,$database); $xnum = mysql_num_fields($resul,$database); replace those variables with the above code. it wasnt connecting to the database. Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629481 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 The whole point of the script is so that I can select any of the tables in the "tullyl00_corn" database. Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629484 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 No, it's not working still. Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629489 Share on other sites More sharing options...
darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 im not sure how your system works sorry. i do not know what hidtable is or does Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629491 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 neither do i...I'll just put it back to normal, and secure the page. If no one can access it, I think it will be fine. Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629493 Share on other sites More sharing options...
darkfreaks Posted August 30, 2008 Share Posted August 30, 2008 thats cool no biggie. also you could try protecting better against email spam if your worried Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629494 Share on other sites More sharing options...
skiingguru1611 Posted August 30, 2008 Author Share Posted August 30, 2008 Also, I have a page like insert.php but it has over 300 variables, so how could I do the if(!empty) function thing without having to type out all the variables? Link to comment https://forums.phpfreaks.com/topic/121497-test-security-please-non-destructive/page/3/#findComment-629495 Share on other sites More sharing options...
Recommended Posts