Dice Roller Hack [BBCode]

Dice Roller Hack [BBCode]
RPG Dice is currently a updated version
Another updated version

Note: Updated package includes only the correct XML.

This hack is a port of: Dice Roll for vB3 and permissions was given to port by the following statement.

Info for hackers:
You may modify, improve, upgrade, redistribute this hack, include it
in another hack or yours or translate it provided you do it free of
charge and you distribute it in www.vbulletin.org at least, there is no
need to pm me asking for permission.

This hack rolls a Graphic based dice roll in your post and features multiple dice rolls per post. The images are fully editable by those who know how and I must agree that I very much think they need an overhaul, so go for it.

The basic bbcode format is:
[dice=X]Y[/dice]

X - The number of dice to roll, This cannot be larger then 5 currently, this may change later with demand.
Y - The number of sides on the dice.

so [dice=1]6[/dice] Roll's 1, 6 sided dice.

The only limit that I have noticed so far is that dice will not apear correctly when rolled from the create thread editor. I am unsure as to why this is still and am working on this issue. However aside from this it is working as need be. This hack is mainly useful to Game websites that require dice rollers for gambling or roleplaying games. It can add an element of fun to a forum and is adapatable to most dice require situations.

If enough demand is displayed I will work on removing the 5 roll limit or making it larger. The current maximum sides one can roll is 30.

If you enjoy this hack or have it installed, then please click the install button so that you can remain informed when updates occur.

As the original author said, You do not need to ask permission to update or do anything to this hack and can redistribute it if you feel you have made a great contribution to it.

If someone does make new dice images and wishes to have them as part of the package then either post here or PM me and I will get them in there with full rights going to the sender for the images.

Updates:

• 04/29/06
  • Added new dice images which where provided by Rukbat.

This hack was requested from: https://vborg.vbsupport.ru/showthread.php?t=97775

-Eikinskjaldi-

Original Screenshots:
https://vborg.vbsupport.ru/attachmen...3&d=1078098688
https://vborg.vbsupport.ru/attachmen...4&d=1078098702

[Rukbat]

Now that I'm not so tired I thought of another question regarding my error message above. What MySQL d/b changes were made? Which table needs new fields and what would the names be to look for to be sure they are there?

EDIT 9:07 CDT

Okay, I went into phpMyAdmin and checked my forum tables '******_thread' and '******_post' and neither table has a 'dice' field.
so do I edit the xml file and change

<codes>
		<code version="1.0">
			<installcode>ALTER TABLE `thread` ADD `dice` MEDIUMTEXT NOT NULL ;
ALTER TABLE '******_' ADD 'dice' MEDIUMTEXT NOT NULL ;</installcode>
			<uninstallcode />
		</code>
	</codes>

to

	<codes>
		<code version="1.0">
			<installcode>ALTER TABLE `******_thread` ADD `dice` MEDIUMTEXT NOT NULL ;
ALTER TABLE '******_post' ADD dice mediumtext not null;</installcode>
			<uninstallcode />
		</code>
	</codes>

with the asterisks being the prefix for all tables in the d/b?

EDIT: 9:46am CDT
That didn't work, BUT, once i went in to phpMyAdmin and added the fields to the two tables it works GREAT!
so I guess there's something in the code in the xml file that didn't actually ALTER my tables.... or was there something else in the xml file that i didn't find where I should have typed in the name of the d/b? I assumed since it was imported/installed using the vB AdminCP that it would 'know' that was the d/b to alter the tables in......

[Rukbat]

I'm working on making some new images for the die, playing with colors
examples below

[Ziki]

I got this error

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO forumziki_thread
(postusername, postuserid, title, iconid, visible, forumid, threadprefix, dice, dateline, open, attach, lastpost, lastposter, replycount, hiddencount)
VALUES
('Ziki', 1, 'Dices', 1, 1, 9, 'Site related', 'a:1:{i:0;a:3:{s:5:\"dices\";s:1:\"1\";s:5:\"faces \";s:1:\"6\";s:4:\"data\";a:1:{i:0;i:4;}}}', 1145991674, 1, 0, 1145991674, 'Ziki', 0, 0);

MySQL Error : Unknown column 'dice' in 'field list'
Error Number : 1054
Date : Tuesday, April 25th 2006 @ 03:01:14 PM
Script : http://www.xxxxx.com/forums/newthread.php
Referrer : http://www.xxxxx.com/forums/newthrea...=newthread&f=9
IP Address : XXXXXXXX
Username : XXX
Classname : vb_database

[Rukbat]

Ziki-set,
I was having the same problem. For some reason the installer isn't altering your forum database tables (_thread & _post). You need to go into your database and physically add the 'dice' field (mediumtext not null) to those two tables.
That fixed the problem for me.

Also, before installing I corrected some wording in the xml file to correct 'dices' to 'die' because it 'bugged' me:
FIND

<td><smallfont><b>Dice roll with $dicesno dices of $dicesfaces faces: $dicepoints points</b></smallfont></td>

CHANGE TO

<td><smallfont><b>Dice roll with $dicesno die of $dicesfaces faces: $dicepoints points</b></smallfont></td>

Also increased the number of 'faces' for dice to 100 since that is what my members needed.
FIND

if ($faces[$i] >= 2 && $faces[$i] <= 30)

CHANGED TO

if ($faces[$i] >= 2 && $faces[$i] <= 100)

Of course I had to 'make' die images for 31-100, and upload them to the ../images/dice folder but that didn't take too long.

Hope this helps

EDIT: 3:30pm CDT
hmmmm, that works up to '99' faces but can't get it to work for '100'..... *wanders off to ponder a bit*

EDIT: 3:47pm CDT
got it to work
FIND:

preg_match_all("/\[dice=([1-5])\]([0-9]?[0-9])\[\/dice\]/",$post['message'],$diceresult);

CHANGE TO:

preg_match_all("/\[dice=([1-5])\]([0-9]?[0-9]?[0-9])\[\/dice\]/",$post['message'],$diceresult);

see attached screenshot

[Eikinskjaldi]

Ya, the install code seems to be errored, I'll work on it and upload the right installer, Thanks rukbat for posting the little mods for others. I might have messed that part up as well.

EDIT:
Upload XML fixed with the correct queries. Sorry about that.

[Ziki]

Now it doesn't show the dices.I imported it and it doesn't show the dices but only the [dice=2]5[/dice]

[Rukbat]

Did you FTP the dice images into a 'dice' folder in images at your site?
Also, go into your PlugIn Manager in your vB admincp, look to be sure all the plug-ins for 'Dice Roller' are checked as 'active'.
Did you 'unistall' via product manager before installing again?

[Rukbat]

oops also, you can't create a thread with a post that includes a dice roll
only replies can include the dice roll
easy solution:
create a new thread i.e.

title: dice roller test

text in post: this thread is to test the dice roller

submit the new thread
then post a reply/quick reply to it, including the dice roll bbcode

[Eikinskjaldi]

Yes, I need to find the right place to inser the code for the first post, I looked in my quick porting of the hack but didn't find it. It's as simple a fix as inserting the code before the first post is output.

[username12]

Don't know how high you would be able to go, but here's one vote for more than 5 dice.