Sessions file

Posted: Fri Nov 21, 2003 9:10 am

Ok, heres my errors when i upload the sessions file

when i use my normal sessions file everything works i think expect for my shop mod and ported mods said to come here and ask so why not get sessions fixed to. so can someone help me out?

phpBB : Critical Error

Could not obtain ban information

DEBUG MODE

SQL Error : 1054 Unknown column 'ban_expire_time' in 'field list'

SELECT ban_ip, ban_userid, ban_email, ban_email, ban_expire_time, ban_priv_reason, ban_pub_reason_mode, ban_pub_reason FROM nuke_bbbanlist WHERE ban_ip IN ('40283788', '402837ff', '4028ffff', '40ffffff') OR ban_userid = 2 OR ban_email LIKE 'webmaster@smallsports.com' OR ban_email LIKE '@smallsports.com'

Line : 165
File : /home/smallspo/public_html/includes/sessions.php

Nuke Soldier Joined: Jun 25, 2003 Posts: 31

I had that one too today.

Looking at my site when I was at work I hgot exactly the same error when trying to visit the Forums.

Trying to fix it, there was no error when I looked at the Forums from home. Strange. Makes me wonder who can see my forums and who cannot.

Posted: Fri Nov 21, 2003 11:08 am

yea i am waiting for audioslaved to give us an answer

Posted: Fri Nov 21, 2003 1:00 pm

The only changes because of GT should be below, everything else should remain the same in your sessions file, since GT portion of the sessions.php is not actually running these queries, I am assuming it is not being caused by GT code, perhaps there is some additional code in there that is causing this. I would recommend using your existing sessions.php, making a copy of it, and appending these changes to it and seeing if that works:

Code:

------------------------------------------------------
# Find the following block of code in the append_sid function
------------------------------------------------------

if ( !empty($SID) && !eregi('sid=', $url) )
{
$url .= ( ( strpos($url, '?') != false ) ? ( ( $non_html_amp) ? '&' : '&' ) : '?' ) . $SID;
}
return($url);

------------------------------------------------------
# Replace With: #
------------------------------------------------------

if ( !empty($SID) && !eregi('sid=', $url) && !areyouabot() )
{
if ( !empty($SID) && !eregi('sid=', $url) ) {
$url .= ( ( strpos($url, '?') != false ) ? ( ( $non_html_amp ) ? '&' : '&' ) : '?' ) . $SID;
}
}
return($url);

---------------------------------------------------------------------
# Create a new function after the append_sid function by adding the
following code: #
---------------------------------------------------------------------

function areyouabot() {
global $HTTP_SERVER_VARS;
$RobotsList = array (
"antibot",
"appie",
"architext",
"bjaaland",
"digout4u",
"echo",
"fast-webcrawler",
"ferret",
"googlebot",
"gulliver",
"harvest",
"htdig",
"ia_archiver",
"jeeves",
"jennybot",
"linkwalker",
"lycos",
"mercator",
"moget",
"muscatferret",
"myweb",
"netcraft",
"nomad",
"petersnews",
"scooter",
"slurp",
"unlost_web_crawler",
"voila",
"voyager",
"webbase",
"weblayers",
"wget",
"wisenutbot",
"acme.spider",
"ahoythehomepagefinder",
"alkaline",
"arachnophilia",
"aretha",
"ariadne",
"arks",
"aspider",
"atn.txt",
"atomz",
"auresys",
"backrub",
"bigbrother",
"blackwidow",
"blindekuh",
"bloodhound",
"brightnet",
"bspider",
"cactvschemistryspider",
"cassandra",
"cgireader",
"checkbot",
"churl",
"cmc",
"collective",
"combine",
"conceptbot",
"coolbot",
"core",
"cosmos",
"cruiser",
"cusco",
"cyberspyder",
"deweb",
"dienstspider",
"digger",
"diibot",
"directhit",
"dnabot",
"download_express",
"dragonbot",
"dwcp",
"e-collector",
"ebiness",
"eit",
"elfinbot",
"emacs",
"emcspider",
"esther",
"evliyacelebi",
"nzexplorer",
"fdse",
"felix",
"fetchrover",
"fido",
"finnish",
"fireball",
"fouineur",
"francoroute",
"freecrawl",
"funnelweb",
"gama",
"gazz",
"gcreep",
"getbot",
"geturl",
"golem",
"grapnel",
"griffon",
"gromit",
"hambot",
"havindex",
"hometown",
"htmlgobble",
"hyperdecontextualizer",
"iajabot",
"ibm",
"iconoclast",
"ilse",
"imagelock",
"incywincy",
"informant",
"infoseek",
"infoseeksidewinder",
"infospider",
"inspectorwww",
"intelliagent",
"irobot",
"iron33",
"israelisearch",
"javabee",
"jbot",
"jcrawler",
"jobo",
"jobot",
"joebot",
"jubii",
"jumpstation",
"katipo",
"kdd",
"kilroy",
"ko_yappo_robot",
"labelgrabber.txt",
"larbin",
"legs",
"linkidator",
"linkscan",
"lockon",
"logo_gif",
"macworm",
"magpie",
"marvin",
"mattie",
"mediafox",
"merzscope",
"meshexplorer",
"mindcrawler",
"momspider",
"monster",
"motor",
"mwdsearch",
"netcarta",
"netmechanic",
"netscoop",
"newscan-online",
"nhse",
"northstar",
"occam",
"octopus",
"openfind",
"orb_search",
"packrat",
"pageboy",
"parasite",
"patric",
"pegasus",
"perignator",
"perlcrawler",
"phantom",
"piltdownman",
"pimptrain",
"pioneer",
"pitkow",
"pjspider",
"pka",
"plumtreewebaccessor",
"poppi",
"portalb",
"puu",
"python",
"raven",
"rbse",
"resumerobot",
"rhcs",
"roadrunner",
"robbie",
"robi",
"robofox",
"robozilla",
"roverbot",
"rules",
"safetynetrobot",
"search_au",
"searchprocess",
"senrigan",
"sgscout",
"shaggy",
"shaihulud",
"sift",
"simbot",
"site-valet",
"sitegrabber",
"sitetech",
"slcrawler",
"smartspider",
"snooper",
"solbot",
"spanner",
"speedy",
"spider_monkey",
"spiderbot",
"spiderline",
"spiderman",
"spiderview",
"spry",
"ssearcher",
"suke",
"suntek",
"sven",
"tach_bw",
"tarantula",
"tarspider",
"techbot",
"templeton",
"teoma_agent1",
"titin",
"titan",
"tkwww",
"tlspider",
"ucsd",
"udmsearch",
"urlck",
"valkyrie",
"victoria",
"visionsearch",
"vwbot",
"w3index",
"w3m2",
"wallpaper",
"wanderer",
"wapspider",
"webbandit",
"webcatcher",
"webcopy",
"webfetcher",
"webfoot",
"weblinker",
"webmirror",
"webmoose",
"webquest",
"webreader",
"webreaper",
"websnarf",
"webspider",
"webvac",
"webwalk",
"webwalker",
"webwatch",
"whatuseek",
"whowhere",
"wired-digital",
"wmir",
"wolp",
"wombat",
"worm",
"wwwc",
"wz101",
"xget",
"awbot",
"bobby",
"boris",
"bumblebee",
"cscrawler",
"daviesbot",
"ezresult",
"gigabot",
"gnodspider",
"internetseer",
"justview",
"linkbot",
"linkchecker",
"nederland.zoek",
"perman",
"pompos",
"psbot",
"redalert",
"shoutcast",
"slysearch",
"ultraseek",
"webcompass",
"yandex",
"robot",
"crawl"
);
$botID = strtolower($HTTP_SERVER_VARS['HTTP_USER_AGENT']);
for ($i = 0; $i < count($RobotsList); $i++)
{
if ( strstr($botID, $RobotsList[$i]) )
{
return TRUE;
}
}
return FALSE;

}

-------------------------------------------------
# DONE! #
-------------------------------------------------

Try doing that and let me know if the problem still occurs, also, can you give me a link where I can see the problem, that may joggle the memory and give me some extra ideas. Hows your site going BTW Minne, haven't seen you in awhile.

-Bill (Audioslaved)

Posted: Fri Nov 21, 2003 1:26 pm

i gots it fixed. yea i had to start my site over. hosting problems. thats why i havent been around lately. i am trying to get my shop hack to work in google tap now but i get Shop Name Must Be Passed! for my effects shop and my sports shop it says No Shop Exists! and i take google tap off and it works

Posted: Fri Nov 21, 2003 1:35 pm

Which version of the tap are you using? I have fixed many of the forums mod issues in the new NExtGEn beta. You may want to try that avenue and see if it works well for you, and custom code you already have can be included in it, I can walk you through it if you decide to do so. I am sure the current problem is one of the URL's acting funky and not passing the correct variables for the hack. Was this working before when your site was up prior or is this a new hack you installed since you just came back online.

Posted: Fri Nov 21, 2003 1:43 pm

this was working fine before i did. I'll try to install the NExtGEn beta thing u did and get back

Posted: Fri Nov 21, 2003 1:49 pm

NExtGEn beta ok i did that. i uploaded the htaceess and header and footer for it and i am uploading the google tap folder in it rite now. but none of the things are .html there just regular stuff like smallsports.com/modules.php?name=Forums and w/e.

Posted: Fri Nov 21, 2003 3:08 pm

you have to read a little bit for the beta, the block files need to be edited manually, If you look in the beta distro thread, I have a list of nuke URL's (modules.php?name=Your_Account) to .html URL's (account.html). It takes a few minutes to make the changes. Since I moved to module based, all core modules get converted on the fly when they are called, this will cut down on most of the overhead associated with GoogleTap, unfortunately blocks will need to be done manually, I included instructions in the beta on doing most of this. If you get stuck and need some help, let me know, alright?

-Bill

Posted: Fri Nov 21, 2003 3:27 pm

i am a lil confused. i dont really care for the blocks rite now butthe whole modules thing. wheres the read me that says what to do

Posted: Fri Nov 21, 2003 8:53 pm

What is confusing about the modules thing. All modules are stored in the GoogleTap directory, the module files are named as their module (i.e GT-News.php is for News module, GT-Your_Account.php is for the Your Account module)

Are you confused on how to add to them? Give me a few questions about what you are confused about and I will spill the beans the best I can for ya.

-Bill (Audioslaved)