Temporarily Disabled MySQL Update for Man Pages Post: 303040464

Sponsored Content

The Lounge What is on Your Mind? Temporarily Disabled MySQL Update for Man Pages Post 303040464 by Neo on Wednesday 30th of October 2019 12:46:30 AM

10-30-2019

Administrator

If anyone (Akshay when back from vacation?) can improve this, please suggest something:

Code:

<?php

function updateDB($os, $section, $query, $text, $raw = '')
{
    global $vbulletin;
    $dateline = time();
    $string = substr($text, 0, 20);
    $snippet = trim(preg_replace('/\s+/', ' ', $string));
    $token = $os . '_' . $section . '_' . $query;
    if (strlen($token) >= 1) {
        $sql = 'INSERT INTO neo_man_page_entry
        (os, section, query, text, formatted,  token, strlen, dateline )
    VALUES
        ("' .
        htmlentities($os, ENT_QUOTES) . '","' .
        htmlentities($section, ENT_QUOTES) . '","' .
        htmlentities($query, ENT_QUOTES) . '","' .
        htmlentities($text, ENT_QUOTES) . '","' .
        htmlentities($raw, ENT_QUOTES) . '","' .
        htmlentities($token, ENT_QUOTES) . '",' .
        strlen($raw) . ',' .
            $dateline . ')
    ON DUPLICATE KEY UPDATE
        dateline = ' . $dateline . ',hits = hits +1';
        $status = $vbulletin->db->query_write($sql);
        return $status;

    } else {
        $file = '/var/log/apache2/debug/neo_update_mandb_entry_error.log';
        $uid = $vbulletin->userinfo['userid'];
        $text = $raw = "unknown";
        error_log(date(DATE_RFC822) . " UID " . $uid . ' token ' . $token . ' len ' . strlen($text) . ' snip ' . $snippet . "\n", 3, $file);
        return -1;
    }

}

and:

Code:

mysql> describe neo_man_page_entry;
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| manid     | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| token     | varchar(120)     | NO   | UNI | NULL    |                |
| dateline  | int(11) unsigned | NO   |     | NULL    |                |
| os        | varchar(16)      | NO   | MUL | NULL    |                |
| section   | varchar(8)       | NO   |     | NULL    |                |
| query     | varchar(64)      | NO   | MUL | NULL    |                |
| text      | mediumtext       | NO   | MUL | NULL    |                |
| formatted | mediumtext       | NO   |     | NULL    |                |
| strlen    | int(10) unsigned | NO   |     | 0       |                |
| hits      | int(10) unsigned | NO   |     | 1       |                |
+-----------+------------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

Neo

View Public Profile for Neo

Visit Neo's homepage!

Find all posts by Neo

4 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Man pages

Hello , I just installed openssh in my system . I actually tried to man sshd but it says no entry , though there is a man directory in the installation which have the man pages for sshd . Can anyone tell me how should i install these man pages . DP

2. UNIX for Dummies Questions & Answers

man pages

Hi, I've written now a man pages, but I don't knwo how to get 'man' to view them. Where have I to put this files, which directories are allowed?? THX Bensky

3. Programming

Man pages for C API for MySql

Hi, I am on Ubuntu 9.04 tweaking some programs demanding MySql queries. I got the program working by installing following package: sudo apt-get install libmysqlclient-dev and using proper include and library folder However I was unable to access any man pages for these C api's (Strangely...

4. HP-UX

Looking for some man pages.

Can anyone supply me with the man pages for: omnidatalist omnibarlist omnisap.exe I prefer the source man pages in nroff format. A clue about the software bundles which supply these man pages is fine as well. OS: HP-UX TIA

LEARN ABOUT SUSE

apache::session::store::mysql

Session::Store::MySQL(3)				User Contributed Perl Documentation				  Session::Store::MySQL(3)

NAME

       Apache::Session::Store::MySQL - Store persistent data in a MySQL database

SYNOPSIS

	use Apache::Session::Store::MySQL;

	my $store = new Apache::Session::Store::MySQL;

	$store->insert($ref);
	$store->update($ref);
	$store->materialize($ref);
	$store->remove($ref);

DESCRIPTION

       Apache::Session::Store::MySQL fulfills the storage interface of Apache::Session.  Session data is stored in a MySQL database.

SCHEMA

       To use this module, you will need at least these columns in a table called 'sessions', or another table name if you provide the TableName
       argument:

	id char(32)	# or however long your session IDs are.
	a_session text

       To create this schema, you can execute this command using the mysql program:

	CREATE TABLE sessions (
	   id char(32) not null primary key,
	   a_session text
	);

       If you use some other command, ensure that there is a unique index on the table's id column.

CONFIGURATION

       The module must know what datasource, username, and password to use when connecting to the database.  These values can be set using the
       options hash (see Apache::Session documentation).  The options are:

       DataSource
       UserName
       Password
       TableName
       Handle

       Example:

	tie %hash, 'Apache::Session::MySQL', $id, {
	    DataSource => 'dbi:mysql:database',
	    UserName   => 'database_user',
	    Password   => 'K00l',
	    TableName  => 'sessions'
	};

       Instead, you may pass in an already-opened DBI handle to your database.

	tie %hash, 'Apache::Session::MySQL', $id, {
	    Handle => $dbh
	};

AUTHOR

       This modules was written by Jeffrey William Baker <jwbaker@acm.org>

SEE ALSO

       Apache::Session

perl v5.12.1							    2007-09-28						  Session::Store::MySQL(3)