vb.org Archive
Page 4 of 12 « First 23 4 56 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   e-steki Karma BETA (https://vborg.vbsupport.ru/showthread.php?t=109716)

Vizionz 03-08-2006 12:09 AM
Invalid SQL:
SELECT karma FROM user WHERE userid=358;

i get that when i try to view the posts now

tnguy3n 03-08-2006 12:12 AM
Quote:
Originally Posted by Vizionz
Invalid SQL:
SELECT karma FROM user WHERE userid=358;

i get that when i try to view the posts now
It means you don't have karma column in user table. Re-import the product xml and choose Overwrite option to insert necesary data.

Vizionz 03-08-2006 12:13 AM
same thing after importing it again with overwrite

Vizionz 03-08-2006 12:25 AM
i cant even uninstall it now either :(

Invalid SQL:
ALTER TABLE usergroup DROP userratingday, DROP userratingperm;

MySQL Error : Can't DROP 'userratingday'. Check that column/key exists

then if i overwrite it again it says installed same errors try to uninstall and go through the same thing ovr and over

Lea Verou 03-08-2006 02:49 AM
Quote:
Originally Posted by vissa
THANK YOU FOR YOUR BRILLIANT WORK!

Great mod! Will install once it gets ironed out a bit (or perhaps install on one of my smaller forums first). Ranked it a 5 * for now to show support. :)
You could install it in your test forum so that there are more beta-testers :)

Quote:
IDEA 1: I've modified some ratings systems (like for photos) so that, for example, if there are more than 3 votes the lowest scored vote gets dropped (or the highest, etc). Or the lowest score gets a boost of one point. So if you have a user with 25 votes and 4.99 score (because of one bad vote) they rank higher than a user with 2 votes at 5.0. This could be customizable somehow.
Very nice, but can you think of an algorithm for that?

Quote:
IDEA 2: The effects/weight of a karma vote could be modified by the voting member's stats in some way (like number of posts, registration date, their karma, etc). This would be a little more like the rep system, but not really because it is always an average with one vote per person. This would be a big change but would be a lot more accurate of "true karma."
Nah, I don't agree with this. It's not fair. For instance, how would you feel if in the elections your vote counted less than the president's?

Quote:
QUICK QUESTION: Are the stats only visible to admins? If they are visible to everyone, it would be nice to be able to turn some sections on/off (though I probably could do this with template changes if you used templates for the display of stats).
There are usergroup permissions for the stats. However strangely enough they don't work all the time :ermm: After some tries though the permissions gets stored at last (one of the known issues) :p

tnguy3n 03-08-2006 02:51 AM
Quote:
Originally Posted by Vizionz
i cant even uninstall it now either :(

Invalid SQL:
ALTER TABLE usergroup DROP userratingday, DROP userratingperm;

MySQL Error : Can't DROP 'userratingday'. Check that column/key exists

then if i overwrite it again it says installed same errors try to uninstall and go through the same thing ovr and over
Go to Maintenance -> Execute SQL Query, then run following queries (1 query a time).
Code:
ALTER TABLE usergroup ADD userratingday SMALLINT(4) NOT NULL DEFAULT '0'
Code:
ALTER TABLE usergroup ADD userratingperm INT(10) NOT NULL DEFAULT '0'
Code:
CREATE TABLE IF NOT EXISTS userrating (voteid) int(10) NOT NULL DEFAULT '0'
Code:
ALTER TABLE user ADD karma SMALLINT(1) NOT NULL DEFAULT '1'
Then uninstall the product.

Lea Verou 03-08-2006 02:52 AM
Quote:
Originally Posted by MissKalunji
Next question i dont want it to show has average 5 i want it show example

average 5 = 5 stars
average 4 = 4 stars etc

how can i do that?
In the postbit and memberinfo:
With conditionals that check $averating. But you will lose accuracy, as they will only show whole numbers.
You can put the actual rating as the alt text though :)
Also you can make half images, but I don't want to think about how complicated those conditionals will be :ermm:

Lea Verou 03-08-2006 02:54 AM
Quote:
Originally Posted by tnguy3n
Go to Maintenance -> Execute SQL Query, then run following queries (1 query a time).
...
Then uninstall the product.
Thanks a lot for helping with the support :) :)
But why wouldn't those fields be installed? The install code is supposed to install those too :(

Lea Verou 03-08-2006 02:56 AM
Quote:
Originally Posted by Vizionz
Invalid SQL:
SELECT karma FROM user WHERE userid=358;

i get that when i try to view the posts now
What exact error message do you get?
If you get "column karma does not exist" or something like that, your problem is what tnguy3n says.

MissKalunji 03-08-2006 03:12 AM
Quote:
Originally Posted by Michelle
In the postbit and memberinfo:
With conditionals that check $averating. But you will lose accuracy, as they will only show whole numbers.
You can put the actual rating as the alt text though :)
Also you can make half images, but I don't want to think about how complicated those conditionals will be :ermm:
lol ok i guess im stuck to be using the numbers til i figure it out

thanks!


All times are GMT. The time now is 07:56 PM.
Page 4 of 12 « First 23 4 56 Last »
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.01924 seconds
  • Memory Usage 1,747KB
  • 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
  • (4)bbcode_code_printable
  • (10)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