Yes, you will get paid. How much? No clue. Make me an offer. I just need something done and have no idea how to do it. My host said to get a web developer so here I am. My forum is malfunctioning because I'm storing my PHP sessions in MySQL database table, not files. I need someone who can change this for me. Someone who can store my PHP sessions in files and not MySql database table. Payment via PayPal. Here's the mail I got from them:
I believe that php sessions are stored in a user's browser cookie. I think you mean user databases. If so, MySQL databases are more secure to store sensitive information than regular text files.
Sessions are a cookie function, have nothng to do with MySQL (Unless login caches usre's last login session id or something)
Yeah friend ! Sessions are used for identifying a using. If someone login to a site/forum the server will put some cookies or start a session.This will get distroy when they logout !
Seems like the hosting company that hosts your website doesn't know what hes talking about. I suggest you change webhost. Other than that, try getting a log of your SQL queries. You may be experiencing DoS attack.
PHP sessions can be stored in MySQL database tables; in fact, several popular scripts such as SMF does that.
Ok, let say something: Sessions can be stored in the db, or file. Saving them in DB give better protection, but also increasing the database size, and queries per connection (each browser) Saving them in the /tmp or another folder, does not use so much the host processor and database connector. Note: if the mysql server's hard solicited, can happens to get timeout pages, caused of that sessions. Some of the websites use the mysql storage for sessions also for recording stats. Don't know if that's what you really need... And for a short resume: You mentioned a forum. Please PM me your url, and i'll tell you if it's possible and how long will take. I've also did another DP free job for somebody. Why can't you be the next (3rd?)
www.jerlene.net Using MyBB. I just started over from scratch and there's still problems. I still have my old databases though(my forums) which I'd like to use but I have no clue how to do this and my host is no help.
btw why are you not using Vbulletin? I can help you with this I need to take a close look. Storing sessions in PHP is not a great idea...
well... since I have a some experience with this I can give some advice... I don't think I will be interested in fixing it, simply because I do not have time. If any of the "web developers" will start working on this, my first recommendation will be to try converting a table... I noticed many packages like to store sessions in tables (this way is much better for load balancing in distributed environments), but a lot of the packages forget that the sessions table can be "MEMORY" type and not "MYISAM" or "INNODB". Since Session table never needs to carry info if the server reboots it is always safe to convert it to memory type. so first thing that I would of done is ... login to mysql and run ALTER TABLE `dbname`.`sessiontable` ENGINE = MEMORY; after that check for indexes in that table, but usually session table should have a session_id column char(32) that is indexed. after that check with host and see if things are any better. Storing sessions in the DB should not create a "big" load.... it can create a lot of small and fast queries, but it will not put a "big load" on the db server. I always preffer storing sessions in the db, but if you will have to change sessions to files, you probably will need to open manual for your software and see if there is a switch. I would look in config.php or even includes/sessions.php (or somethign like that - I do not know your software so obviously names are made up... I am simply trying to give you an idea). P.S. For people that started about cookies....you might find this interesting... Sessions are always created on the server.... Cookies are simply used to keep the state of the session. When in PHP you do "session_start()" server creates a session and sends the cookie to a broser with session id (browser never gets anything except that session id, all the session variables are stored on the server). Browser will keep the cookie until it is closed by the user. Browser will always continue the requests having the cookie in the http request header. When server receives the header it gets the session_id and find the session that corresponds to the client. In order for the server to store something in the "session" it needs to put it in file or in database or in any other storage avilable (if any).
what a kid? you might want to hide your url too bud! http://www.dnstools.com/?lookup=on&wwwhois=on&arin=on&portNum=80&target=jerlene.net+&submit=Get+Info