[MOD] PMv2 Tutorial Republished here

[mawenzi]

... try this ...
... http://www.4homepages.de/forum/index.php?topic=6692.msg86674#msg86674 ...

[jotabonfim]

Where 's
Step 1, 2 and 3?


Help me please

[Acidgod]

1) The structure is 90% different then in v1
2) Everything renamed to "pm" instead of "pms" (had to do that, because I was using "pm" from the beginning and every time I do some changes on my site, I'd have to do it twice to post it here...)
3) Admin can:
-turn on/off PM feature
-set limit of messages stored in inbox and sentbox, globaly or per user.
-alow/disalow use HTML, BBCode or [img] tags in messages.

[jotabonfim]

Excuse I did not understand?

[jotabonfim]

Please could you help me.....

DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM 4images_pm WHERE pm_to = 1 AND (pm_type = 2 OR pm_type = 1 OR pm_type = 3 OR pm_type = PM_USDLT)
Unknown column 'PM_USDLT' in 'where clause'

DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM 4images_pm WHERE pm_from = 1 AND (pm_type = 3 OR pm_type = PM_USDLT)
Unknown column 'PM_USDLT' in 'where clause'

DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS new FROM 4images_pm WHERE pm_to = 1 AND (pm_type = 3 OR pm_type = PM_USDLT) ORDER BY pm_date DESC
Unknown column 'PM_USDLT' in 'where clause'

DB Error: Bad SQL Query: SELECT pm_date FROM 4images_pm WHERE pm_to = 1 AND (pm_type = 3 OR pm_type = PM_USDLT) ORDER BY pm_date DESC
Unknown column 'PM_USDLT' in 'where clause'

DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS new FROM 4images_pm WHERE pm_to = 1 AND (pm_type = 3 OR pm_type = PM_USDLT)
Unknown column 'PM_USDLT' in 'where clause'

DB Error: Bad SQL Query: SELECT COUNT(p.pm_id) AS messages FROM 4images_pm p WHERE p.pm_to = 1 AND (p.pm_type = 1 OR p.pm_type = 2 OR p.pm_type = PM_USDLT OR p.pm_type = 3)
Unknown column 'PM_USDLT' in 'where clause'

DB Error: Bad SQL Query: SELECT COUNT(p.pm_id) AS messages FROM 4images_pm p LEFT JOIN 4images_users u ON (u.user_id = p.pm_from) WHERE p.pm_to = 1 AND (p.pm_type = 1 OR p.pm_type = 2 OR p.pm_type = PM_USDLT OR p.pm_type = 3) AND u.user_level <> 9
Unknown column 'PM_USDLT' in 'where clause'

[topdolla]

Hi, I got an error during pm_install.php and the error was "Sorry, can not continue, you missed some steps of the installation.." 

Im sure this is a wonderful mod and I have been trying to get it working for the past two weeks. I have installed a fresh 4images on my server numerious times, and repeated the same step, still I get the same error. 

In Step 6, Mark says to comment out that functoin but I can't seem to find return replace_badwords($text); . I am using the default 4images and and the closest thing to that is $text = replace_badwords($text);    . Im sure theres a major difference between the both and I think this is where my installation went wrong. A little help please          

[yoda]

ok...  use phpMyadmin and this sql

Code: [Select]

-- phpMyAdmin SQL Dump
-- version 2.6.1-rc2
-- http://www.phpmyadmin.net

CREATE TABLE `4images_pm` (
  `pm_id` mediumint(10) unsigned NOT NULL auto_increment,
  `pm_type` tinyint(2) NOT NULL default '0',
  `pm_to` mediumint(8) NOT NULL default '0',
  `pm_from` mediumint(8) NOT NULL default '0',
  `pm_subject` varchar(255) NOT NULL default '',
  `pm_text` text,
  `pm_date` int(11) NOT NULL default '0',
  `pm_date_rcvd` int(11) NOT NULL default '0',
  `pm_ip` varchar(20) NOT NULL default '0',
  `pm_html` tinyint(1) NOT NULL default '0',
  `pm_bbcode` tinyint(1) NOT NULL default '0',
  `pm_smiles` tinyint(1) NOT NULL default '0',
  KEY `pm_id` (`pm_id`,`pm_to`,`pm_from`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
       

Hi - I'm using 4images 1.7.4 and trying to implement this great MOD.

The script pm_install.php isn't working and so I used your script above.

I have now the table 4images_pm in my database

But now I have the following error

DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM PM_TABLE WHERE pm_to = 1 AND (pm_type = PM_SENT OR pm_type = PM_SDLT OR pm_type = PM_UNREAD OR pm_type = PM_USDLT)
Table 'yoda_db.PM_TABLE' doesn't exist

DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM PM_TABLE WHERE pm_from = 1 AND (pm_type = PM_UNREAD OR pm_type = PM_USDLT)
Table 'yoda_db.PM_TABLE' doesn't exist

DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS total FROM PM_TABLE WHERE pm_from = 1 AND (pm_type = PM_SENT OR pm_type = PM_RDLT)
Table 'yoda_db.PM_TABLE' doesn't exist

DB Error: Bad SQL Query: SELECT COUNT(pm_id) AS new FROM PM_TABLE WHERE pm_to = 1 AND (pm_type = PM_UNREAD OR pm_type = PM_USDLT) ORDER BY pm_date DESC
Table 'yoda_db.PM_TABLE' doesn't exist

DB Error: Bad SQL Query: SELECT pm_date FROM PM_TABLE WHERE pm_to = 1 AND (pm_type = PM_UNREAD OR pm_type = PM_USDLT) ORDER BY pm_date DESC
Table 'yoda_db.PM_TABLE' doesn't exist



I'm a little bit helpness now - it seems that there's an issue in the code for page_header.php

please help - many many thanks!

[Acidgod]

are you sure that you use the right prefix?
CREATE TABLE `4images_pm` (

[yoda]

are you sure that you use the right prefix?
CREATE TABLE `4images_pm` (

Yes - I checked it again.

[yoda]

I started another try today and made a fresh 4images 1.7.4 installation.

After this I started with the PM (2.5.4) implementation.

Step9 - the pm_install.php isn't running and so I use your sql again
for creating the table. There is now a table "4images_pm" in the database.

The user and the setting table I changed/added with PHPmyadmin.

When making the check in step 9 with 4images/pm.php , I got the same error again that the
table xxxxxx.PM_TABLE is missing, see my post 395

I think there's an error in the page_header/function code or creating the pm_table, hope that anybody can help.

thanks in advance!

[myr2904]

Not working with version 1.7.4



When making the check in step 9 with 4images/pm.php


>>>>

Registered users
Logged in as: admin

» Lightbox
» Control Panel
» Log Out
         
Error

You are not logged in or do not have permissions to enter this site!


Why?

[Joss]

I've both problems in 1.7.4:

1. "Sorry, can not continue, you missed some steps of the installation..", after running pm_install.php
2. "You are not logged in or do not have permissions to enter this site!", after manual db update on 4images/pm.php page.

[yoda]

still waiting for a sign here  

This gret mod isn't working with the 1.7.4 version - a lot of people need help for this.

[fotoblitz]

Wäre cool wenn jemand weiterhelfen könnte wie man diesen mod für die Version 1.7.4 benützen kann!!

[Heinrich-Uwe]

Also Fehler Fehler Fehler
Nach 16 Stunden habe ich es nun aufgegeben.
das Forum durch gefrostet aber kein Ergebnis bekommen....

Kann nicht einer mal möglichst in DEUTSCH mal einen Leihen erklären wie man das Mod zum laufen bekommt ohne das man das ganze Skript zerstört ??
also mal am Beispiel an der Version 1.7.4  und das dann mal als Anleitung hier hinterlegt wird....

Nicht nur ich wer da Dank paar...

Danke Uwe