New Posting Features - Diceroller

Diceroller by PointSingularity, originally written for 2d4.org

Version 1.002

This feature adds the functionality to post dice rolls. The rolls are associated with posts but cannot be edited even if the post can.

No longer supported.

WARNING!!
It has been brought to my attention that a bug causes a MySQL error when using the pm system!
To fix this, edit the plugin that's connected to the postbit display complete hook and add at the very top:

if (!empty($post['postid'])) {

then add at the very bottom:

}

CHANGELOG

1.002
*Moved the dice roller itself into a more discreet area. Now works well with either postbit or postbit_legacy!
*Added user option in the user cp for appearance (forum default, full, compatibility mode). Appearance can be enforced in the settings, disabling the user cp options and overriding any personal settings already set.
*Added settings variable for main width.
*Changed the font-size in a few places to make it look a bit more discreet.
*Made the separate rolls lists collapsable.
*Removed the nevershowfulllist function since it was completely pointless due to the newly collapsable lists.
*Fixed bug that would claim description title was too long even if it wasn't when certain characters were entered.
*Design fixes and reorganizing. The border now looks like the rest of the postbit's.
*Added "roll" button.
*Added code for clearing up memory after database queries.
*Dice are now sorted by result (rolls are still sorted by id).
*Connected to template hooks to further simplify the installation process.
*Moved all of diceroller.php into the main plugin.

1.001
*Fixed counter error when dice list is in tooltip mode.
*Added complete vBulletin Language/Phrase support.
*Added low-profile mode. This will display entries as plain text, which is excellent if you want an uber-lite look or want better browser support since this turns off the java features.
*Sorting sorted out. ;p Lists now sort with the newest entry on top in vertical lists and the newest at the end in horizontal (tooltips and low-profile mode).
*Reorganized data and simplified installation process.
--Notes: If upgrading, remove everything except the database and reinstall, following the new installation process.



UPGRADE INSTRUCTIONS
From v1.001
Upgrade within vBulletin using the new product-diceroller.xml. Be sure to check "allow overwrite" or upgrade won't work. Then upload the roll.gif image into the /buttons directory. Finally revert your template changes you made for the last version (they are no longer needed) and delete diceroller.php (it's not needed anymore either).

From v1.0
Do NOT upgrade from v1.0. Instead delete the old templates, uninstall the plugins, etc. manually! You can keep the database if you'd like as that has not been changed.
Version 1.001 comes with a proper installer and is upgradable.


INSTALLATION INSTRUCTIONS
1. Upload and put roll.gif to your theme's "button" folder on the webserver (or make your own button ).
2. Import the product file product-diceroller.xml.
DONE!


CHANGE SETTINGS:
There's no addition to the admin cp, instead you can edit the settings by adjusting the values in the plugin called "Diceroller Settings". Be careful though!

ALSO IMPORTANT: Be sure to have plugins enabled in vBulletin or this won't work.


KNOWN ISSUES

v1.002
*Quote-box gets dropped down, leaving the title where it should be, if the dice roller is in the way.

[M-Tuning]

What is the purpose of this?

[Mike-D]

3. Import diceroller.sql into your database

Just because some few members doesn't know how to handle phpMyAdmin I'd put the SQL Code via <installcode>...</installcode><uninstallcode>...</uninstallcode> in your Product. Makes it more easier

Originally Posted by M-Tuning

What is the purpose of this?

Hmm... good question. Just wondering too

[PntSingularity]

Originally Posted by Mike-D

Just because some few members doesn't know how to handle phpMyAdmin I'd put the SQL Code via <installcode>...</installcode><uninstallcode>...</uninstallcode> in your Product. Makes it more easier

Thanks for the tip, I'll get right on that. I apologize for the unuserfriendly install. I'll use the fact that it's my first plugin as an excuse.

Originally Posted by M-Tuning

What is the purpose of this?

It's for play-by-post roleplaying.


EDIT:
I'll see about making a better install tomorrow that includes the css and extra templates. It'll also include a slight fix (when using tooltip-view for the separate dice the numbers for each value is the number of the current die in the current post rather than the current roll).

[PntSingularity]

v1.002 will use template hooks (not sure if I can fit everything into the hooks but I'm trying ) so installation/uninstallation/upgrade will be EVEN EASIER!

I'm also working on making it work better for regular postbit templates.

[Spank]

hi I'm not sure what it's supposed to do. What happens when you roll the dice? And will it work for 3.7?

[PntSingularity]

Originally Posted by Spank

hi I'm not sure what it's supposed to do. What happens when you roll the dice? And will it work for 3.7?

When you roll dice they will be stored for that specific post in the database, then be displayed for everyone to see when they view the post.
For example, in a play-by-post game I'm supposed to attack a vicious lizardman with my longsword. I make 1d8+3 damage and therefor use the diceroller to roll 1d8. The game master can then verify that I've my damage score is valid.

I'm not sure if it will work with 3.7 as it's written for 3.6.8. However I'd be happy if anyone would test it with that version and give me feedback on this.

[Spank]

Ah I see, sounds pretty swell. Thanks for explaining ^_^. I'll consult my staff, cos we have a battle roleplaying forum on my site, if it's something they'd like to see I'll install and test it.

[PntSingularity]

v1.002 is up!
It's still in beta, but I've done some quick tests in IE 7, Firefox 3 and Safari (think it's the latest version) and it seems to run at least.
Unless there are any special requests I think I'm done with adding features and will focus on cleaning up the code and fix any bugs. So expect some minor changes in 1.003.

[koxito]

This works fine in 3.7, but you'll need to add the security token, to all the inputs, i did this very easy.

whatever, i have problems with my PM's Now, i got a database error while viewing my recived..

This is the error:

Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT * FROM iaroll WHERE postid =  ORDER BY rollid DESC;

MySQL Error   : 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 'ORDER BY rollid DESC' at line 1
Error Number  : 1064
Request Date  : Monday, August 25th 2008 @ 08:00:16 PM
Error Date    : Monday, August 25th 2008 @ 08:00:17 PM
Script        : http://www.ia-family.com/foro/private.php?do=showpm&pmid=32282
Referrer      : http://www.ia-family.com/foro/private.php?
IP Address    : 189.202.19.200
Username      : LuMa-Kun
Classname     : vB_Database
MySQL Version : 5.0.41-community-log