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

[Eq4bits]

The admincp I'm talking about is the same place you go to edit your webpages, where you see all the vbulletin files ... where they are located...

When you installed vbulletin you had to add the name of the d/b for your forum(s) in the config.php... whatever that value is you could use to set a direct path to your d/b in the xml file for this product.
so wherever you saved the xml file on your computer, go to where it's listed, right click, open with>notepad (or whatever editor you use) then
look for

<installcode>

		$db->hide_errors();
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "post` ADD `dice` MEDIUMTEXT NOT NULL ;");
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` ADD `dice` MEDIUMTEXT NOT NULL ;");
		$db->show_errors();
		
</installcode>
-
	<uninstallcode>

		$db->hide_errors();
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "post` DROP `dice` ");
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` DROP `dice` ");
		$db->show_errors();
		
</uninstallcode>

THEN change it as follows... Making the asterisks the prefix you used for all your other tables (that you found in your config.php file)

<installcode>

		$db->hide_errors();
		$db->query_write("ALTER TABLE `****_ post` ADD `dice` MEDIUMTEXT NOT NULL ;");
		$db->query_write("ALTER TABLE `****_thread` ADD `dice` MEDIUMTEXT NOT NULL ;");
		$db->show_errors();
		
</installcode>
-
	<uninstallcode>

		$db->hide_errors();
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "post` DROP `dice` ");
		$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` DROP `dice` ");
		$db->show_errors();
		
</uninstallcode>

Hopefully THAT will work.

[soravok]

Okay I'll give that a shot, but not everyone runs thier web server through a control panel interface. Mines attached to my ~/ on my box's user account.

[soravok]

Okay thanks that did fix the problem, but it still won't let me post a roll on the first post of the forum. Any idea when / if that will be fixed?

[Eq4bits]

the roll in first post of new thread is fixed if you used the xml file provided on page 5 of this thread, post #69

[soravok]

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO vbthread
(postusername, postuserid, title, iconid, visible, forumid, dice, dateline, open, attach, lastpost, lastposter, replycount, hiddencount)
VALUES
('aaron', 1, 'Dice roller testing', 0, 1, 8, 'a:1:{i:0;a:3:{s:5:\"dices\";s:1:\"4\";s:5:\"faces \";s:1:\"5\";s:4:\"data\";a:4:{i:0;i:4;i:1;i:1;i:2 ;i:1;i:3;i:1;}}}', 1150725773, 1, 0, 1150725773, 'aaron', 0, 0);

MySQL Error : Unknown column 'dice' in 'field list'
Error Number : 1054
Date : Monday, June 19th 2006 @ 10:02:53 AM
Script : http://mouldyskull.com/newthread.php
Referrer : http://mouldyskull.com/newthread.php?do=newthread&f=8
IP Address : 207.6.57.62
Username : aaron
Classname : vb_database

I made the appropriate changes listed above to the new XML file provided in post #69 and I get this error when I try to roll on the first post of a thread.

[Eq4bits]

It still looks like the 'dice' field has NOT been added into your _thread table... Are all your tables vbtablename? usually from my experience the tables are preceeded with ****_tablename

Are you able to run a MySQL query to add the fields yourself?

Unless you have some way of accessing your vbulletin database and adding the 'dice' field yourself, or running the sql query, I'm not really sure what else to advise.

I must admit, I'm still trying to get used to the product and plug-in process since switching to vB from phpbb2 (where EVERYTHING was a find/copy/paste-before/after/replace and adding tables/fields/etc was 'done by hand') While I'm glad for that learning experience the products and plug-ins are such a time saving convenience.

[soravok]

Couple of bugs I noticed, if you preview a roll it deletes your roll syntax & if you edit a previous post with a roll it deletes your roll syntax. Any thoughts on if this is going to be fixed?

[Eq4bits]

no it shouldn't be fixed... keeps a player from ummmm 'cheating' by editing the roll if they don't like the result

[soravok]

Why not make it retain the syntax but reroll the values everytime the forum is edited or previewed then have the post say "Values were edited @ such and such time" and just have the preview values be rolled seperately from the submitted values. Makes sense to me that way you can't cheat.

[WNxWakko]

This mod totally crashed my server.

I strongly advise against this mod until he cleans up all the bad code.