<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "AG 2.2 - trying to do admin functions logs out"]]></title>
		<link>https://proxy2.de/forum/posts/list/5.php</link>
		<description><![CDATA[Latest messages posted in the topic "AG 2.2 - trying to do admin functions logs out"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ My hosting company evidently had a problem with the server I was on and moved me to a new server. Just for background info, the old server was PHP ver 4.4.9 and SQL 4.0.22 while the new server is PHP 5.3.5 and SQL 5.0.9.2 just in case this has any effect.<br /> <br /> At first I couldn't even log back into the GB. I found Carbonize's website and was able to use his password reset (beta ver) successfully but now if I was try do anything as an administrator it returns me back to the log in screen and I get an error in PHP.  Again searching Carbonize's site someone had a similar problem, but I never found a fix other than confirm that book_auth  the field LAST_VISIT is set to type TIMESTAMP.<br /> <br /> The PHP error I am getting is Warning: mktime() expects parameter 2 to be long, string given in /public_html/roster/lib/session.class.php on line 63   - this error appears directly above the administrator login.<br /> <br /> [i]edit:  It seems to be in this section [/i]<br /> <br /> function isValidSession($session,$user_id) {<br /> <br />         $this-&gt;query("SELECT session, LAST_VISIT from ".$this-&gt;table['auth']." WHERE session='$session' and ID='$user_id'");<br /> <br />         $row = $this-&gt;fetch_array($this-&gt;result);<br /> <br />         if ($row) {<br /> <br />             $year = substr($row["LAST_VISIT"],0,4);<br /> <br />             $date = substr($row["LAST_VISIT"],4,10);<br /> <br />             $date_strg = chunk_split($date,2,"-");<br /> <br />             list($month,$day,$hour,$minute,$second) = explode("-",$date_strg);<br /> <br />             [color=red]$tstamp = mktime($hour,$minute,$second,$month,$day,$year);[/color]<br />             return ($this-&gt;expire + $tstamp &gt; time()) ? $row["session"] : false;<br /> <br />         } else {<br /> <br />             return false;<br /> <br />         }<br /> <br /> And the line #63) I am showing in red.<br /> <br /> <br /> <br />  Any help would be appreciated.<br /> <br /> (I need to upgrade as soon as its working again) ]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25696.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25696.php</link>
				<pubDate><![CDATA[Sun, 13 Mar 2011 14:22:07]]> GMT</pubDate>
				<author><![CDATA[ cville22903]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ What version of the guestbook is it?]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25697.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25697.php</link>
				<pubDate><![CDATA[Sun, 13 Mar 2011 18:38:40]]> GMT</pubDate>
				<author><![CDATA[ Carbonize]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ version 2.2]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25698.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25698.php</link>
				<pubDate><![CDATA[Sun, 13 Mar 2011 19:38:47]]> GMT</pubDate>
				<author><![CDATA[ cville22903]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ Ah the version with the exploit. If you have phpMyAdmin and know how to use it can you check if last_visit in book_auth is in upper or lower case.]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25699.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25699.php</link>
				<pubDate><![CDATA[Sun, 13 Mar 2011 20:49:17]]> GMT</pubDate>
				<author><![CDATA[ Carbonize]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ last_vist is in uppercase]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25700.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25700.php</link>
				<pubDate><![CDATA[Sun, 13 Mar 2011 21:02:50]]> GMT</pubDate>
				<author><![CDATA[ cville22903]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ Are you comfortable doing some minor editing to a PHP file?]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25701.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25701.php</link>
				<pubDate><![CDATA[Mon, 14 Mar 2011 10:02:40]]> GMT</pubDate>
				<author><![CDATA[ Carbonize]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ Extremely limited on making changes by myself, I can however follow directions fairly well and if Im told what to look for and what to change I can do that.<br /> <br /> I do need to upgrade the guestbook. Would doing an upgrade fix the issue as it appears that I have to upload all new files.]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25702.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25702.php</link>
				<pubDate><![CDATA[Mon, 14 Mar 2011 10:54:50]]> GMT</pubDate>
				<author><![CDATA[ cville22903]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ Quite possibly but there was something that needed changing in the book_auth table manually to go from 2.2 to 2.4.<br /> <br /> As to the editing I simply need you to change<br /> [code]$date_strg = chunk_split($date,2,"-");<br /> <br /> list($month,$day,$hour,$minute,$second) = explode("-",$date_strg); [/code]<br /> <br /> to<br /> [code]$date_strg = chunk_split($date,2,"-");<br /> die("Date String = $date_strg");<br /> list($month,$day,$hour,$minute,$second) = explode("-",$date_strg); [/code]<br /> <br /> It should then stop and display the contents of $date_strg]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25703.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25703.php</link>
				<pubDate><![CDATA[Mon, 14 Mar 2011 11:10:51]]> GMT</pubDate>
				<author><![CDATA[ Carbonize]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ I added the string to the /lib/session.class.php so it now reads<br /> <br /> 		    $date_strg = chunk_split($date,2,"-");<br /> <br /> 			die("Date String = $date_strg");<br /> <br />             list($month,$day,$hour,$minute,$second) = explode("-",$date_strg);<br /> <br />             $tstamp = mktime($hour,$minute,$second,$month,$day,$year);<br /> <br />         <br /> <br /> and now instead of being kicked back to the log in I get a blank screen with on this displaying":<br /> <br /> Date String = -0-3--14- 0-6:-]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25704.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25704.php</link>
				<pubDate><![CDATA[Mon, 14 Mar 2011 11:39:48]]> GMT</pubDate>
				<author><![CDATA[ cville22903]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ Do it again but change it to<br /> <br /> die("Date = $date"); ]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25705.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25705.php</link>
				<pubDate><![CDATA[Mon, 14 Mar 2011 11:44:59]]> GMT</pubDate>
				<author><![CDATA[ Carbonize]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ I had to run off to my real job this morning to help pay for the web hosting that has this problem  <img src="https://proxy2.de/forum//images/smilies/136dd33cba83140c7ce38db096d05aed.gif" /> <br /> <br /> I changed out to your request.<br /> <br /> <br /> 		    $date_strg = chunk_split($date,2,"-");<br /> <br /> 			die("Date = $date");<br /> <br />             list($month,$day,$hour,$minute,$second) = explode("-",$date_strg);<br /> <br /> and now when I log in and go to any admin function I get:<br /> <br /> Date = -03-14 17:]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25706.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25706.php</link>
				<pubDate><![CDATA[Mon, 14 Mar 2011 22:57:20]]> GMT</pubDate>
				<author><![CDATA[ cville22903]]></author>
			</item>
			<item>
				<title>AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ Log in to phpMyAdmin and tell me the contents of last_visit.]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25707.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25707.php</link>
				<pubDate><![CDATA[Tue, 15 Mar 2011 01:21:17]]> GMT</pubDate>
				<author><![CDATA[ Carbonize]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ Pix of last_visit]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25708.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25708.php</link>
				<pubDate><![CDATA[Tue, 15 Mar 2011 02:12:24]]> GMT</pubDate>
				<author><![CDATA[ cville22903]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ Just to explain. How the last_visit is used changed as of AG 2.3 so I am not sure how 2.2 worked in this respect. I am going to use the information you have provided to work it out and to try and fix the problem.]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25709.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25709.php</link>
				<pubDate><![CDATA[Tue, 15 Mar 2011 09:46:32]]> GMT</pubDate>
				<author><![CDATA[ Carbonize]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ Would it be better and easier to upgrade since I'm going to have to do it at the end anyway?<br /> <br /> Also, I can't shake the feeling that it's something dealing with the move to a server running PHP 5.3.5. I have another small site on a different server (same hosting company) that is also running version 2.2 but that server has PHP 4.4.9 which is what I was on prior to the move and having no problems.  The move was necessitated by a requirement for a higher version of SQL so I could upgrade a forum board (went from SQL 4.0.22 to 5.0.9.2)]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25710.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25710.php</link>
				<pubDate><![CDATA[Tue, 15 Mar 2011 10:28:31]]> GMT</pubDate>
				<author><![CDATA[ cville22903]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ Back up all files and the database first though and you will need my 2.2 to 2.3 script from <a class="snap_shots" href="http://www.carbonize.co.uk/AG/" target="_blank" rel="nofollow">http://www.carbonize.co.uk/AG/</a> and after that you will need to also run the db_update script found in the misc folder of 2.4.]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25711.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25711.php</link>
				<pubDate><![CDATA[Tue, 15 Mar 2011 10:45:06]]> GMT</pubDate>
				<author><![CDATA[ Carbonize]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ OK - I'll work on it tonight after work - Thank you for all your hard work on this]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25712.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25712.php</link>
				<pubDate><![CDATA[Tue, 15 Mar 2011 11:28:26]]> GMT</pubDate>
				<author><![CDATA[ cville22903]]></author>
			</item>
			<item>
				<title>Re:AG 2.2 - trying to do admin functions logs out</title>
				<description><![CDATA[ Finally got time to do the upgrade to the guestbook this morning.<br /> <br /> I downloaded the script for 2.2 to 2.3 and ran that. I then downloaded the current 2.4 guestbook and uploaded that. There was no db_update script in he misc folder but there was a convert_tables_to_utf8 so I attempted to run that and got:<br /> <br /> Warning:  mysql_connect() [function.mysql-connect]: Access denied for user 'ov1_agbook1'@'localhost' (using password: YES)<br /> <br /> Attempting to pull up the guestbook resulted in connection error.<br /> <br /> So I restored the 2.2 files and the 2.2 db and my guestbook was back but I still had the same problem that started the thread.<br /> <br /> Reading on Carbonize'a site he had a patched sessions.class exploit fix so I uploaded that to my guestbook and still had the same issues.<br /> <br /> Figured I might as well play, so I used the session.class file from the 2.4 guestbook and uploaded to my guestbook. I logged into my site and the new file corrected my admin issues. I made some tests adding, editing and deleting and the GB seems to be working fine. A 2.2 guestbook with a 2.4 sessions.class file.<br /> <br /> And all I wanted when I started this was to upgrade to have a capatcha]]></description>
				<guid isPermaLink="true">https://proxy2.de/forum/posts/preList/7552/25714.php</guid>
				<link>https://proxy2.de/forum/posts/preList/7552/25714.php</link>
				<pubDate><![CDATA[Sat, 19 Mar 2011 16:58:56]]> GMT</pubDate>
				<author><![CDATA[ cville22903]]></author>
			</item>
	</channel>
</rss>