httpreffers in 6.5

Posted: Fri Jan 17, 2003 4:26 am

Yo friend, I have a new little problem for you to work on Smile

as I am not an advanced coder....maybe it is just my site but you never know...

When setting httpreffers in the preferences to 100 max, it won't stop at 100, guess it will go to 1000, checked the database and both nuke.sql's for version 6.0 and 6.5 and there isn't any difference, so why isn't this option not stopping at 100 reffers and start all over again with a new listing ??

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Yes I noticed this bug.. I"ll find time to investigate now.

Posted: Fri Jan 17, 2003 9:12 am

Wonderfull, I couldn't find it yet, also working on it.... Wink

Joined: Jan 31, 2004 Posts: -88

if there's a fix, we'll find it. This is the home of MIBF (Mission Impossible Bug Fixers) after all Wink

ArtificialIntel

Posted: Sat Jan 18, 2003 5:34 pm

Code:

Posted: Sun Jan 19, 2003 4:09 am

Okay will do that, I have add the new code and deleted all reffers, so now we have to wait until 100 is reached again, anyway thanks for your time Exclamation

Many will appriciate it, especially Mr. FB if it works Wink

I was searching in the wrong direction.... Wink

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

I haven't looked yet, but what I can type is that this site, nuke 6.5 b5 does seem to be working on the # of referers I set it to.

Posted: Sun Jan 19, 2003 10:57 am

Zhen-Xjell wrote:

I haven't looked yet, but what I can type is that this site, nuke 6.5 b5 does seem to be working on the # of referers I set it to.

Mmmm....I will tell you tomorrow the results of my little investigation on my site, can't say anything yet as I have about 50 reffers at this moment....so.... Wink

Posted: Sun Jan 19, 2003 11:10 am

Like i mentioned in my previous post this still needs to be confirmed as working, what i did to test it was make a backup of one of my site's referers table, delete it then re-create it with 100 referers, which i made the max setting in admin for the test, i then went to the site using links from at least 5 other sites and no referer was added to the table, i then set the max setting to 1000, went back to using the remote links and sure enough this time they were added, just hope it solves the problem for you.

Posted: Mon Jan 20, 2003 1:17 am

Well it worked half, it stops at 100 reffers now but didn't deleted this 100 to start all over again....funny Wink

I am back now to the original situation Exclamation

I like to continue testing this option if you guys have any other possibilities Wink

PS. Programming articles for the next day in 6.5 results in that it is written by a Anonymous user and no date and time are published by the article, this is new found bug by me, and the poster was an admin and it is post through the admin function add a story.....any ideas ??

Guess I am a good beta tester Wink

Posted: Mon Jan 20, 2003 7:28 am

Ok, let's give this one more try, hope you have your referers already at their max, that way you'll find out right away if this is what you want, what it'll do is keep adding referers till it reaches your max limit, once reached, it will wipe them all out and restart, kinda drastic but it's what i could come up with.

Code:

if ($httpref==1) {
$referer = getenv("HTTP_REFERER");
if ($referer=="" OR eregi("^unknown", $referer) OR substr("$referer",0,strlen($nukeurl))==$nukeurl OR eregi("^bookmark",$referer)) {
} else {
$result = sql_query("select * from ".$prefix."_referer", $dbi);
$numrows = sql_num_rows($result, $dbi);
if($numrows<$httprefmax) {
sql_query("insert into ".$prefix."_referer values (NULL, '$referer')", $dbi);
} else {
if($numrows==$httprefmax) {
sql_query("delete from ".$prefix."_referer", $dbi);
sql_query("insert into ".$prefix."_referer values (NULL, '$referer')", $dbi);
}
}
}
}

Posted: Mon Jan 20, 2003 2:03 pm

Okay didn't test your new fix, however I have done it myself this time,
the following is the code I am using right now and after 100 refers as
in the config it will be deleted and start all over again with 1.

find: between line 23 - 38 (index.php)

if ($httpref==1) {
$referer = getenv("HTTP_REFERER");
if ($referer=="" OR eregi("^unknown", $referer) OR substr("$referer",0,strlen($nukeurl))==$nukeurl OR eregi("^bookmark",$referer)) {
} else {
$sql = "INSERT INTO ".$prefix."_referer VALUES (NULL, '$referer')";
$result = $db->sql_query($sql);
}
$sql = "SELECT * FROM ".$prefix."_referer";
$result = $db->sql_query($sql);
$numrows = $db->sql_numrows($result);
if($numrows>=$httprefmax) {
$sql = "DELETE FROM from ".$prefix."_referer";
$result = $db->sql_query($sql);

With:
if ($httpref==1) {
$referer = getenv("HTTP_REFERER");
if ($referer=="" OR eregi("^unknown", $referer) OR substr("$referer",0,strlen($nukeurl))==$nukeurl OR eregi("^bookmark",$referer)) {
} else {
sql_query("insert into ".$prefix."_referer values (NULL, '$referer')", $dbi);
}
$result = sql_query("select * from ".$prefix."_referer", $dbi);
$numrows = sql_num_rows($result, $dbi);
if($numrows>=$httprefmax) {
sql_query("delete from ".$prefix."_referer", $dbi);
}
}

Above will work 100%...good luck with it Wink

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Ahh, just read this after your phpnuke.org forums post. Multiple solutions, cool!

Posted: Mon Jan 20, 2003 2:27 pm

Nice, now anyone having a similar problem can use any of both codes, i tested the last one i posted and it does just that, it reaches the max then starts all over at 1. Wink

Posted: Mon Jan 20, 2003 2:56 pm

Cool job guys, I am proud of discussing this here...but what about my
3th problem ?

When programming articles for the next day as an admin it appears
as written by anonymous and no dates and time with the articles Question

I didn't searched for it yet as I am busy with my Windows 2000 installation
as I will try to work with the microsoft IIS server....hihihi...and building a
intranet with phpnuke here....I have 4 computers....pfffffffffff.....keeps me
very busy Wink