vb.org Archive
Page 7 of 9 « First 56 7 89
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   V3Arcade - Game Rating addon (https://vborg.vbsupport.ru/showthread.php?t=71460)

Slapp3r 01-09-2005 04:59 PM
cheers

MorrisMcD 01-17-2005 02:36 AM
Quote:
Originally Posted by nealparry
didn't work for me, came up with DB error (No number, just standard error) so had to remove it.

Same here.. Checked and double checked

sim tech 02-28-2005 06:44 PM
Quote:
Originally Posted by NightWalk8r
I keep getting this error when i try to run the query in Admincp =(



Query
ALTER TABLE `vb3_games` ADD `votetotal` smallint(5) UNSIGNED DEFAULT '0' NOT NULL ;

ALTER TABLE `vb3_games` ADD `votenum` smallint(5) UNSIGNED DEFAULT '0' NOT NULL ;

CREATE TABLE `vb3_game_rate` (
`gamerateid` int(11) NOT NULL auto_increment,
`gameid` int(11) NOT NULL default '0',
`userid` int(10) NOT NULL default '0',
`vote` smallint(5) default NULL,
`ipaddress` char(15) NOT NULL default '',
PRIMARY KEY (`gamerateid`)
) TYPE=MyISAM AUTO_INCREMENT=8

vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';

ALTER TABLE `vb3_games` ADD `votenum` smallint(5) UNSIGNED
I ran into the same problems, and being a php-noob it took a while to see the problems.

First of all, you can't run all of the queries at once (there's actually 3 there) and 2nd: if you are running version 3 or higher there is no table just called "games" (someone else pointed this out here - thanks!)

Here's the 3 that I ran separate:
PHP Code:
ALTER TABLE `vb3_games` ADD `votetotal` smallint(5)  UNSIGNED DEFAULT '0' NOT NULL ; 
PHP Code:
ALTER TABLE `vb3_games` ADD `votenum` smallint(5)  UNSIGNED DEFAULT '0' NOT NULL ; 

PHP Code:
CREATE TABLE `vb3_game_rate` (
  `gamerateid` int(11) NOT NULL auto_increment,
  `gameid` int(11) NOT NULL default '0',
  `userid` int(10) NOT NULL default '0',
  `vote` smallint(5) default NULL,
  `ipaddress` char(15) NOT NULL default '',
  PRIMARY KEY  (`gamerateid`)
) TYPE=MyISAM AUTO_INCREMENT=8 ; 
That part helped with my pucker-factor which was caused when the arcade would not run.

MicroLinux? 02-28-2005 07:33 PM
Does this work for vBulliten 3.0.7 with the categories mod installed?

sim tech 02-28-2005 08:21 PM
I don't know about the catagories mod, but the kind of works on mine and I'm running 3.0.7.

I say "kind of" because of several issues that I am pulling my hair out on (and I'm already going bald, so this is a bad thing):

I'd like the rating option to be available on the main arcade.php page, but the rate drop down screen only appears when someone selects a specific game.... at at that point it's labeled Rate Thread. I saw where someone else asked about this but did not see where to fix it.

I have the standard v3arcade layout - can the star ratings be placed on the main arcade page rather than the individual game page?

Is this an option that I screwed up on? :ermm: Other screenshots make it look like it's on the arcade.php page.

Thanks

Oblivion Knight 03-01-2005 07:57 AM
Quote:
Originally Posted by sim tech
at that point it's labeled Rate Thread. I saw where someone else asked about this but did not see where to fix it.
The mod was made that way for the "ease" factor. It's fairly easy to create your own phrases for it and update the code and templates to display this.. :)


Quote:
Originally Posted by sim tech
I have the standard v3arcade layout - can the star ratings be placed on the main arcade page rather than the individual game page?

Is this an option that I screwed up on? :ermm: Other screenshots make it look like it's on the arcade.php page.
By default, you can only rate games on an individual game's play page. If you've seen different elsewhere, it's likely to be a custom job that they've done themselves.

Polo 03-11-2005 02:55 PM
after playing around with it for a while, I finally got it working they way I wanted :) Thank you for sharing this with the community ;)

sim tech 03-24-2005 05:32 AM
Ditto here - thanks!

One (more) question though... is there a query to reset all of the existing game ratings? I had some bogus rates and I'd rather just wipe them all out.

mcoco1 03-30-2005 08:53 PM
Is there a way to change the display order on the arcade.php page? I would like to display the most played first so you don't have to dig through several pages for the games which are most fun.

Thanks! :)

Allan 04-14-2005 09:44 PM
thanks :)


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I am sorry, but I made all the changes explain and I do not have any rating which appears has to games, nor in the principal main, an idea of the problem??


All times are GMT. The time now is 07:50 AM.
Page 7 of 9 « First 56 7 89
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01257 seconds
  • Memory Usage 1,753KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete