function mysql_session_read($SID) { $ip = $_SERVER['REMOTE_ADDR']; $sql = "\n SELECT data,refresh,playerid \n FROM l_session \n WHERE id = '{$SID}' \n and expire > now() \n "; $res = mysql_query($sql); if ($res) { $row = mysql_fetch_assoc($res); if ($row) { $session = stripslashes($row['data']); if ($row['refresh'] == 'Y' and !empty($row['playerid'])) { $_SESSION = unserialize_session_data($session); session_data_reload($row['playerid']); $session = session_encode(); unset($_SESSION); $sql = "UPDATE l_session SET refresh='N' WHERE id='{$SID}'"; mysql_query($sql); } return $session; } else { mysql_session_destroy($SID); } } sessionStaticInfo(); return ""; }
/** * This function returns the user ID of the logged in user on your site. Technical support will not * help you with this for stand-alone installations. You must purchase the professional installation * if you are having trouble. * * Suggestion: Check out the other integration files in the functions/integrations directory for * many examples of how this can be done. The easiest way is to get the user ID through a cookie. * * @return the user ID of the logged in user or NULL if not logged in */ function get_user_id() { global $db; $userid = NULL; $session_id = session_id(); if (!empty($session_id)) { $result = $db->execute("\n\t\t\t\tSELECT data\n\t\t\t\tFROM " . TABLE_PREFIX . "sessions\n\t\t\t\tWHERE id = '" . $db->escape_string($session_id) . "'\n\t\t\t"); if ($row = $db->fetch_array($result)) { if (!empty($row['data'])) { $data = unserialize_session_data($row['data']); if (!empty($data['Zend_Auth']['storage']->id)) { $userid = $data['Zend_Auth']['storage']->id; } } } } return $userid; }
<?php $heading = array(); $contents = array(); if ($info) { $heading[] = array('text' => '<b>' . TABLE_HEADING_SHOPPING_CART . '</b>'); if (STORE_SESSIONS == 'mysql') { $session_data = vam_db_query("select value from " . TABLE_SESSIONS . " WHERE sesskey = '" . $info . "'"); $session_data = vam_db_fetch_array($session_data); $session_data = trim($session_data['value']); } else { if (file_exists(vam_session_save_path() . '/sess_' . $info) && filesize(vam_session_save_path() . '/sess_' . $info) > 0) { $session_data = file(vam_session_save_path() . '/sess_' . $info); $session_data = trim(implode('', $session_data)); } } $user_session = unserialize_session_data($session_data); if ($user_session) { $products = vam_get_products($user_session); for ($i = 0, $n = sizeof($products); $i < $n; $i++) { $contents[] = array('text' => $products[$i]['quantity'] . ' x ' . $products[$i]['name']); } if (sizeof($products) > 0) { $contents[] = array('text' => vam_draw_separator('pixel_black.gif', '100%', '1')); $contents[] = array('align' => 'right', 'text' => TEXT_SHOPPING_CART_SUBTOTAL . ' ' . $user_session['cart']->total . ' ' . $user_session['currency']); } else { $contents[] = array('text' => ' '); } } } if (vam_not_null($heading) && vam_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n";