Hi! I was wondering if this suggestion is possible?

I was wondering if you can add an option that allow us to create different purposes for these karmas. For example, users can participate a karma system for rating each other whether they are good or bad members in the forum . Then, some users can participate the other karma system for the purpose of whether they are trusted or not when they are selling, trading, etc, stuff. They can join different karma systems in the UserCP.

In short, I was wondering if you can add a feature where you can create different purpose/rating for this karma system. Hope i make sense =].

Thanks Michelle...

very nice.

That would be useful for some forums, but I don't have the time to do something I won't personally use, especially if it's time consuming, sorry :/

Thanks. Tell me how the install went :)

Hello,
No i havnt any e-steki version installed befor that .
Thanks

What hacks that involve DB changes do you have installed?

i have installed some templete mods and some others as like ,, dream,s chatbox , colour legend , paypal, Ajax Reg , Cyb - Advanced Forum Statistics , Global Announcement , Latest 10 PM Admin Index , Referrer Statistics , ibProArcade for vBulletin and Global Announcement.
Thanks

Are you alright? :eek:


Ok the whole idea is for users to vote on each other to make the top ten in 3 different categories lets say, I don't need the whole system/site...
I can give you 3 reasons [$$$] ;)

Well here 3 more samples to give you an idea...

@iogames: What do you mean by "are you allright?"? The quote was referring to another person :p
No thanks, at the moment I don't take custom jobs, I don't find that fullfilling, I only like coding for myself. :)
You can find a lot of talented coders here that can take that job though :)

Warning: implode() [function.implode]: Bad arguments. in /karma.php on line 125

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /karma.php on line 129

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /karma.php on line 342

and thats putting a 0 in the main karma setting

Hate to say it but after messing it simply dont work on 3.6.8

also i loaded the new karma.php that u had on the previous page and here is the error i get now

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /karma.php on line 342
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM userrating WHERE active=1 AND userid NOT IN () AND raterid NOT IN () ORDER BY `dateline` 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 ') AND raterid NOT IN () ORDER BY `dateline` DESC' at line 1
Error Number : 1064
Date : Sunday, August 5th 2007 @ 12:32:08 AM

finally look what happens if i try to uninstall the product from the admincp

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE user DROP karmatotal;

MySQL Error : Can't DROP 'karmatotal'; check that column/key exists
Error Number : 1091
Date : Sunday, August 5th 2007 @ 12:39:04 AM

Damn.
I'll try to fix this shortly.
For the time, disable the product.

lasto, do you have any banned users? (not karma-banned, generally banned)

Also, try putting a 0,0 instead of a 0 in that setting and tell me what happened

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE usergroup ADD userratingday SMALLINT(4) NOT NULL DEFAULT '0', ADD userratingperm INT(10) NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'userratingday'
Error Number : 1060
Date : Sunday, August 5th 2007 @ 01:47:30 AM
Script : http://www.theblackpoet.com/xxxxxx/a...=productimport
Referrer : http://www.theblackpoet.com/xxxxx/ad...?do=productadd
IP Address : xxxxxxx
Username : xxxxxx
Classname : vB_Database


this is my error.. i go to import... and get this.....

And I didn't have any of my templates changed.

Which hacks that involve DB changes do you have? It's quite weird to have this.
Anyway, that column is not needed in v2, its from the install code of v1. It then gets removed with the install code of v2, so perhaps I should remove it completely.

Huh? What do you mean?

PS: Nice avatar

i was jacking around with that commune hack and broke my dbase/site.... im reinstalling all my hacks now... after having to uninstall them all one by one...

i havent really been having any dbase issues since i took all my hacks off and ran tools.php...

i dont know why this one would give me any trouble

Since you are a coder, you can edit the product xml and remove any queries about that column (userratingday) in the install/uninstall code, its not needed at all, it gets added and then removed during install, in order to have consistency with users having v1 (v1 needed that column).
It's weird though that you have such a column in your db..
If you can't do the above, tell me to upload a product xml without it.

lasto (and others with problems with karma.php) try this karma.php and tell me what happened.

i took out the references.. and still had an error.. i could have done something wrong... and at this point i'm to chicken to risk losing the dbase again...... so, if you edited the xml, that would be fine with me... and appreciated.....

Black poet, which of those do you have installed? (since you have the same bug)

Ok, I will shortly :)
In the meantime, can you reply to my above question, so I can determine if there are any inconsistencies with a specific hack?

Cyb Donate
Ajax Reg
Cyb - Advanced Forum Statistics,
ibProArcade

i have these hacks installed

TheBlackPoet and anyone else with his problem, try the attached product instead of the original.

PS: Sorry for the delay, I had a problem on my forum with vba cmps 3.0 (btw DON'T upgrade to it its full of bugs :mad: better wait till its gold)

Attachment in the previous post updated (I had forgotten something).
Black Poet, if you have the userrating table in your database,you should probably drop it, otherwise the install will give you a db error. Same goes with columns 'karma' and 'karmatotal' in user table if you have them.

Black poet can you please tell me what happened because in less than half an hour I will be afk for a lot of hours so I will not be able to assist you?

i almost hate to bother you!!!!!

this is the new error:


Database error in vBulletin 3.6.8:

Invalid SQL:
CREATE TABLE userrating (
`voteid` int(10) NOT NULL auto_increment,
`userid` int(10) NOT NULL default '0',
`raterid` int(10) NOT NULL default '0',
`ratername` varchar(50) NOT NULL default '',
`rating` int(10) NOT NULL default '0',
`active` tinyint(1) NOT NULL default '1',
`dateline` int(10) NOT NULL default '0',
`ipaddress` varchar(25) NOT NULL default '',
PRIMARY KEY (`voteid`)
) TYPE=MyISAM AUTO_INCREMENT=1;

MySQL Error : Table 'userrating' already exists
Error Number : 1050
Date : Sunday, August 5th 2007 @ 07:12:02 AM
Script : http://www.theblackpoet.com/forum/ad...=productimport
Referrer : http://www.theblackpoet.com/forum/ad...?do=productadd
IP Address : 70.246.27.95
Username : theblackpoet
Classname : vB_Database


when i delete it..., it gives me an error for karma column... but i dont have that table....... and then... my next error is this userrating again... i assume it installed it back....

Hello,
I tried this karma.php file but still same error , here it is,

Thanks

the karma column is in the user table. Same for the karmatotal column.

You don't want to prevent any usergroup for participating in the karma? What about guests? Add usergroup 1 to the restricted usergroups list and this will most likely fix it.

Hello,
I am trying to uninstall but cant , getting this error now .

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE user DROP karmatotal;

MySQL Error : Can't DROP 'karmatotal'; check that column/key exists
Error Number : 1091
Date : Sunday, August 5th 2007 @ 10:15:29 AM
Script : http://www.domine.com/Forums/admincp...do=productkill
Referrer : http://www.domine.com/Forums/admincp...=userrating&s=
IP Address : xyz
Username : user
Classname : vb_database

Please helo.
How can uninstall ??
Thanks

using the karma.php u added on last page gives this error

MySQL Error : Table 'custom.userrating' doesn't exist
Error Number : 1146
Date : Sunday, August 5th 2007 @ 12:08:43 PM

also trying to uninstall throws up exactly the same error as the post before me.

Afraid this hack does not work or something is badly missing.

also using the new plugin u posted above gives this error

Warning: implode() [function.implode]: Bad arguments. in /member.php(838) : eval()'d code on line 71

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT karma FROM user WHERE (userid=1 OR userid=1) AND karma=1 AND userid NOT IN () AND usergroupid NOT IN (1);

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 ') AND usergroupid NOT IN (1)' at line 1
Error Number : 1064
Date : Sunday, August 5th 2007 @ 02:06:03 PM

BRB gonna try this on a fesh installed Board with HTTaccess (so i dont break licence agreement)

fresh install of vbulletin - no hacks installed at all
2 Users - 1 made when installing Vbulletin and another made for test purposes

going to karma.php brings up this error

Warning: Invalid argument supplied for foreach() in /karma.php on line 399

Warning: Invalid argument supplied for foreach() in /karma.php on line 407

Warning: Invalid argument supplied for foreach() in /karma.php on line 415

Warning: Invalid argument supplied for foreach() in /karma.php on line 422

Warning: Invalid argument supplied for foreach() in /karma.php on line 429

Warning: arsort() expects parameter 1 to be array, null given in /karma.php on line 437

Warning: Invalid argument supplied for foreach() in /karma.php on line 439

Warning: asort() expects parameter 1 to be array, null given in /karma.php on line 454

Warning: Invalid argument supplied for foreach() in /karma.php on line 456

Warning: arsort() expects parameter 1 to be array, null given in /karma.php on line 472

Warning: Invalid argument supplied for foreach() in /karma.php on line 474

Warning: array_count_values() [function.array-count-values]: The argument should be an array in /karma.php on line 491

Warning: Wrong parameter count for max() in /karma.php on line 494

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: Division by zero in /karma.php on line 507

Warning: array_count_values() [function.array-count-values]: The argument should be an array in /karma.php on line 575

Now going to look at member.php throws up another problem

Warning: implode() [function.implode]: Bad arguments. in /member.php(838) : eval()'d code on line 71
Invalid SQL:
SELECT karma FROM user WHERE (userid=2 OR userid=1) AND karma=1 AND userid NOT IN () AND usergroupid NOT IN (1,3,4);

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 ') AND usergroupid NOT IN (1,3,4)' at line 1
Error Number : 1064
Date : Sunday, August 5th 2007 @ 02:15:34 PM

So unsure wots going on but it aint working.Its a fresh installed board with only this hack added as a product and the command entered in memberinfo template.

I've got the same problems as everyone else. Too bad, seems like it could be a very nice mod.

pretty cool alternative to rep, these things can add alot to a forum

Good morning everyone, just woke up.
I'll look into these errors shortly. :(

PS: I swear, it worked fine (and still does) in my test board!! :( :(, I don't know why it caused you so many errors :( And I feel so bad for that :( Is there anyone of those 27 people that clicked install that got it working?