You are not logged in. Please login or register.
PunBB Forums → Posts by Chacmool
Sounds nice :)
I'm not really the "beer-type", so I don't know any good places for that. You have to be 18 to drink, but there might be other limits in some places, and I don't know what they have at O'Leary's.
You could always visit Liseberg, as everyone else :)
Huh!?
What are you talking about?
Jag svarade i den engelska tråden istället :)
*låser*
The reason is that there's an option (at the admin->options page) where you can change the ability for users to have multipolls or not. Though, it must be a bug or something that you have to edit the poll to make it multivote, I'll take a closer look at it.
Oh, thanks alot! I've made the changes in the code and put a new version here.
Download the file and replace message_list.php OR change it manually:
In message_list.php find:
// Set user
$result = $db->query('SELECT status FROM '.$db->prefix.'messages WHERE id='.$id) or error('Unable to get message status', __FILE__, __LINE__, $db->error());
list($status) = $db->fetch_row($result);
$status == 0 ? $where = 'u.id=m.sender_id' : $where = 'u.id=m.owner';
$result = $db->query('SELECT m.id AS mid,m.subject,m.sender_ip,m.message,m.smileys,m.posted,m.showed,u.id,username,registered,email,title,url,icq,msn,aim,yahoo,location,use_avatar,email_setting,num_posts FROM '.$db->prefix.'messages AS m,'.$db->prefix.'users AS u WHERE '.$where.' AND m.id='.$id) or error('Unable to fetch message and user info', __FILE__, __LINE__, $db->error());
$cur_post = $db->fetch_assoc($result);
if ($cur_post['showed'] == 0){
$db->query('UPDATE '.$db->prefix.'messages SET showed=1 WHERE id='.$id) or error('Unable to update message info', __FILE__, __LINE__, $db->error());
}Change to:
// Set user
$result = $db->query('SELECT status,owner FROM '.$db->prefix.'messages WHERE id='.$id) or error('Unable to get message status', __FILE__, __LINE__, $db->error());
list($status, $owner) = $db->fetch_row($result);
$status == 0 ? $where = 'u.id=m.sender_id' : $where = 'u.id=m.owner';
$result = $db->query('SELECT m.id AS mid,m.subject,m.sender_ip,m.message,m.smileys,m.posted,m.showed,u.id,username,registered,email,title,url,icq,msn,aim,yahoo,location,use_avatar,email_setting,num_posts FROM '.$db->prefix.'messages AS m,'.$db->prefix.'users AS u WHERE '.$where.' AND m.id='.$id) or error('Unable to fetch message and user info', __FILE__, __LINE__, $db->error());
$cur_post = $db->fetch_assoc($result);
if ($owner != $cur_user['id'])
message($lang_common['No permission']);
if ($cur_post['showed'] == 0){
$db->query('UPDATE '.$db->prefix.'messages SET showed=1 WHERE id='.$id) or error('Unable to update message info', __FILE__, __LINE__, $db->error());
}Done! :)
I really like how simple it is to transfer the money :) (Using the account number)
chemicals
I suppose you could use the punbb search function and make it search particular forum(s)...
I was a bit unclear there. I don't want to search anything, just list the topics in a forum (including the first post).
But the problem is solved now when Rickard showed be the secret trick (GROUP BY).
Hey there!
When you say news function, is it something similar to PunNewz (search in Mod Releases)?
You can retrieve first row only by adding ORDER BY p.id LIMIT 1 to your query ...
Yeah, it is. But I want to search the topics too, and with only one post.
This should do the trick:
SELECT t.*, p.message ...p ON p.topic_id=t.id GROUP BY t.id
Ohh, so that's what 'GROUP BY' is used for :) Makes this much easier, thanks!
I've been working on a news-function (yeah, me too :)). There's no problem making one with two querys, but can it be done using only one?
SELECT t.*, p.message FROM topics AS t, posts AS p WHERE p.topic_id=t.idThis query obviously returns one row for each post in the topic. Is there a way to prevent this from happening? I only want the first post for each topic, not all of them.
So your converter also converts the users as well?
It converters the users too.
And what about if I had off-site linking on phpbb. How does the converter handle that?
Then you would have to backup the forum there and install it on your local computer. As long as the database and webserver are located on the same machine it works fine.
SP2 for Windows XP will include a new version of IE. It has a popup stopper and refined security options. Not a big upgrade though.
I wonder if they have to stop using popups then... no one will ever see them. (This is maybe a bad thing for me, as it is now I don't see them, but meny other users do :))
Ack... having more problems. Uploaded and edited and installed, I get this:
Warning: main(./lang/en/en_pms.php): failed ... Warning: main(./lang/en/en_pms.php): failed ...
Are you sure the file en_pms.php is in the language-folder?
user status is always shown as "New member". status should be added to
$result = $db->query('SELECT m.id AS mid, m.subje...
Where and when does this happen?
Um, the whole point of this forum is to show off your punbb forums and your site. You are not running punbb.
Agree. Moved it to Generall discussions instead.
Yeah, it's possible. But I don't like it, so I've made the mod so they can't :D
There's a couple of solutions to the vote problem then. 1: Allowing one vite per IP-address, or 2: Set a cookie when someone votes. Both have their problems, but it will defenately work yes. Don't know how much of the code that must be altered though.
If i install this on the same machine as the one I have phpBB on currently, do you see any potential problems when trying to convert over using Chacmool's converter?
No, there's no problem at all. In fact, you must have the database and webserver on the same machine when running the converter.
Okay, seems like it's a database-error and not a PunBB-error. I've search google for a while and found the comment:
Error 28 does in fact mean that the host is out of space.
So check if your disk space/quota is full or not, it might solve the problem.
Change line ~27 in the file include/common.php.
Wallace & Gromit
Do you have a link to the forum? Please turn on debug-mode (in include/common.php). Do you have any mods installed, or did you change anything else yourself?
Yes, you can change whenever you want. Just take a look in you profile and you'll find some avatar-settings.
It's meant to be like that.. or something.. Anyway.. If you are looking for the files: http://punres.org/files/
Yeah, and that page is really easy to navigate on...
"Cactuz sends word that version 2.1 or the PunBB Resource is alive and kicking. The new version has lots of new features and he has assured me that the downtime will be kept at a minimum from now on."
Any thoughts on when the server is up again?
PunBB Forums → Posts by Chacmool
Powered by PunBB, supported by Informer Technologies, Inc.