Register | Login | |||||
Main
| Memberlist
| Active users
| ACS
| Commons
| Calendar
| Online users Ranks | FAQ | Color Chart | Photo album | IRC Chat |
| |
0 user currently in Acmlmboard support?. |
Acmlm's Board - I2 Archive - Acmlmboard support? - 1.9 + abnews hack | | | |
Add to favorites | "RSS" Feed | Next newer thread | Next older thread |
User | Post | ||
sharkz i build a house Level: 10 Posts: 18/30 EXP: 4016 For next: 398 Since: 03-15-04 From: PA, US Since last post: 299 days Last activity: 66 days |
| ||
hey, since 1.9 uses seperate tables for post_layout, posts, and posts_text, is there any easy modification that I could do to this hack to make things work out? If you havn't guessed, the date and things work, and the title shows, but the post text is not to be seen of course because posts_text is not called. so more in detail, could anyone write a variable to show the text of the post? any help will be really appreciated. |
|||
Cellar Dweller Flurry !!! Level: 27 Posts: 82/269 EXP: 107817 For next: 8342 Since: 03-15-04 From: Arkansas Since last post: 16 days Last activity: 34 min. |
| ||
I don't have access to the AcmlmBoard 1.9 code(few do), but I can take a whack at it. I presume that you are using Weasel's news hack. Look for the SQL query that gets the posts. It should look like: SELECT * FROM posts WHERE thread=$news[id] ORDER BY id LIMIT 1 I presume that the posts_text table has two columns: id and text. If I'm right then you should be able to change the SQL query to: SELECT posts.*, posts_text.text AS text FROM posts,posts_text WHERE posts.thread=$news[id] AND posts.id=posts_text.id ORDER BY posts.id LIMIT 1 If it works, consider sending the 1.9 compatible version to Cymoro for the hack archive. |
|||
sharkz i build a house Level: 10 Posts: 20/30 EXP: 4016 For next: 398 Since: 03-15-04 From: PA, US Since last post: 299 days Last activity: 66 days |
| ||
hey cellar dwellar. thanks a lot for helping me out, though that query doesn't quite work. for your reference, here's the structure for postsand posts_text
|
|||
Cellar Dweller Flurry !!! Level: 27 Posts: 86/269 EXP: 107817 For next: 8342 Since: 03-15-04 From: Arkansas Since last post: 16 days Last activity: 34 min. |
| ||
Try changing "posts.id=posts_text.id" to "posts.id=posts_text.pid", if you have not already. | |||
sharkz i build a house Level: 10 Posts: 21/30 EXP: 4016 For next: 398 Since: 03-15-04 From: PA, US Since last post: 299 days Last activity: 66 days |
| ||
hey, working fine now. thanks much! |
Add to favorites | "RSS" Feed | Next newer thread | Next older thread |
Acmlm's Board - I2 Archive - Acmlmboard support? - 1.9 + abnews hack | | | |