Cash Mod not co-existing well with Merge Mod
-----
| Author | Message | |
|---|---|---|
|
LifeBlade |
||
| Sat Nov 25, 2006 8:44 pm Post subject: Cash Mod not co-existing well with Merge Mod | ||
|
Could you help me make the Cash mod and Merge Mod.. well co-exist without cancelling each other out?
If the Merge Mod is installed.. then .. all double posts get merged.. but if the Cash Mod is also turned on for the forum.. it gives me this error Code: Error retrieving group data
DEBUG MODE SELECT group_id FROM phpbb_user_group WHERE user_id = AND user_pending = 0 ORDER BY group_id ASC Line : 1227 File : functions_cash.php Thanks in Advance!! the link to the "Double Post Merge" Mod is here http://www.phpbbhacks.com/download/2206 |
||
|
LifeBlade |
||
| Tue Nov 28, 2006 4:13 pm Post subject: re: Cash Mod not co-existing well with Merge Mod | ||
|
Plz? A solution to this frustrating problem would be nice!
|
||
|
Thoul |
||
| Tue Nov 28, 2006 4:34 pm Post subject: re: Cash Mod not co-existing well with Merge Mod | ||
|
Please have some patience. We're coming out of a holiday weekend, so I've been away for a few days. I hadn't seen your problem until about an hour ago and you're starting to spam me about it both here and at phpBBHacks. I don't appreciate such behavior, especially when I've just spent a half hour looking at how these two mods interact and might be causing such a problem.
|
||
|
Thoul |
||
| Tue Nov 28, 2006 5:11 pm Post subject: re: Cash Mod not co-existing well with Merge Mod | ||
|
Now then. It looks like the Merge mod doesn't provide all the information that the Cash mod needs to function. Make these changes in posting.php:
Code: #
#-----[ FIND ]-------------------------------------- # $sql = "SELECT post_text, bbcode_uid FROM " . POSTS_TEXT_TABLE . " WHERE post_id = $post_id"; # #-----[ REPLACE WITH ]-------------------------------------- # $sql = "SELECT p.poster_id, pt.post_text, pt.bbcode_uid FROM " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt WHERE p.post_id = $post_id AND pt.post_id = p.post_id"; # #-----[ FIND ]-------------------------------------- # // i don't know much about parsing the message, so it may well be that, // there are some wrongs, anyway all seems to work fine # #-----[ AFTER, ADD ]-------------------------------------- # $post_data['poster_id'] = $last_message_row['poster_id']; That will hopefully pull the rest of the information the Cash mod needs. Last edited by Thoul on Tue Nov 28, 2006 6:33 pm; edited 2 times in total |
||
|
LifeBlade |
||
| Tue Nov 28, 2006 5:31 pm Post subject: | ||
|
Ok.. I'm sorry for spamming you.. I didn't mean to do that..
Hopefully you can accept my apology.. Well.. this time.. it came back with this error Code: Could not obtain forums information
DEBUG MODE SQL Error : 1054 Unknown column 'poster_id' in 'field list' SELECT poster_id, post_text, bbcode_uid FROM phpbb_posts_text WHERE post_id = 11 Line : 579 File : posting.php |
||
|
Thoul |
||
| Tue Nov 28, 2006 5:58 pm Post subject: re: Cash Mod not co-existing well with Merge Mod | ||
|
No problem, just don't let it happen again.
I've edited the code above to fix this error. Try the new version. |
||
|
LifeBlade |
||
| Tue Nov 28, 2006 6:09 pm Post subject: | ||
|
Ok! Will Do! I won't let it happen again!
This time.. this error occured.. Code: Error retrieving group data
DEBUG MODE SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND user_pending = 0 ORDER BY group_id ASC' at line 4 SELECT group_id FROM phpbb_user_group WHERE user_id = AND user_pending = 0 ORDER BY group_id ASC Line : 1227 File : functions_cash.php |
||
|
Thoul |
||
| Tue Nov 28, 2006 6:34 pm Post subject: re: Cash Mod not co-existing well with Merge Mod | ||
|
Okay, I edited the code above again (just the last step this time). Try this new version.
|
||
|
LifeBlade |
||
| Tue Nov 28, 2006 6:44 pm Post subject: | ||
 YyyEEP!! That did the trick!!
Thanks for all your help!! I would hug you through the internet to show you my gratitude.. if i could. lol But , Thanks for your help!!.. IT WORKS!! 
|
||
|
Thoul |
||
| Wed Nov 29, 2006 5:39 pm Post subject: re: Cash Mod not co-existing well with Merge Mod | ||
|
Excellent, I'm glad we got it sorted out.
|
||
Page 1 of 1