| Karma Q | |
Posted: 11/13/2007 5:18 AM |
|
|
|
|
Citation |
Posts |
1253 |
Word Cnt. |
68,166 |
BDay |
Nov 9 |
Sign |
Scorpio |
Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 4:33 PM
|
|
|
|
|
|
I installed the advanced Karma hack and tested it out on my test board, but there's no way of resetting it. Is there anyway I can go into the database and do it or run an SQL query to do it? Its only for one person, no-one else has any karma at all.
Thanks |
|
|
|
|
Back to Top |
|
|
| Re: Karma Q | |
Posted: 11/13/2007 2:09 PM |
|
|
|
|
Citation |
Posts |
1017 |
Word Cnt. |
64,643 |
BDay |
Apr 18 |
Sign |
Aries |
Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 8:33 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
I haven't installed. But yes, you can run SQL query manually.
Go to Cpanel, MySQL Databases, PhpMyAdmin, select the database where you have installed this Karma MOD, and then on right side click SQL and an emtpy box will open, there you paste that SQL queries in it and Run it.
If you face any difficulty in between, do not hesitate to ask me |
|
|
|
|
Back to Top |
|
|
| Re: Karma Q | |
Posted: 11/14/2007 6:25 AM |
|
|
|
|
Citation |
Posts |
1253 |
Word Cnt. |
68,166 |
BDay |
Nov 9 |
Sign |
Scorpio |
Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 4:33 PM
|
|
|
|
|
|
Would you know what query I would run?
|
|
|
|
|
Back to Top |
|
|
| Re: Karma Q | |
Posted: 11/14/2007 6:57 AM |
|
|
|
|
Citation |
Posts |
1017 |
Word Cnt. |
64,643 |
BDay |
Apr 18 |
Sign |
Aries |
Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 8:33 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
The SQL Query will be mentioned in the Karma MOD.
If you don't find it, can you please provide me the download link of Karma MOD or attach it here so that I can look at it |
|
|
|
|
Back to Top |
|
|
| Re: Karma Q | |
Posted: 11/14/2007 7:03 AM |
|
|
|
|
Citation |
Posts |
1253 |
Word Cnt. |
68,166 |
BDay |
Nov 9 |
Sign |
Scorpio |
Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 4:33 PM
|
|
|
|
|
|
Here's what I had to do to install it
Code:
|
CREATE TABLE phpbb_karma_comments (
karma_id mediumint(8) NOT NULL auto_increment,
karma_to mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
karma_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
karma_desc char(255) NOT NULL,
karma_date int(11) DEFAULT '0' NOT NULL,
karma_key tinyint(1) DEFAULT '0' NOT NULL,
karma_viewed tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (karma_id)
);
INSERT INTO `phpbb_config` SET `config_name`='karma_comments', `config_value`='0';
INSERT INTO `phpbb_config` SET `config_name`='karma_comments_obligatory', `config_value`='0';
INSERT INTO `phpbb_config` SET `config_name`='karma_comments_max', `config_value`='3';
INSERT INTO `phpbb_config` SET `config_name`='karma_onoff', `config_value`='1';
INSERT INTO `phpbb_config` SET `config_name`='simple_karma', `config_value`='0';
INSERT INTO `phpbb_config` SET `config_name`='time_between_karma', `config_value`='24';
INSERT INTO `phpbb_config` SET `config_name`='admin_karma', `config_value`='1';
INSERT INTO `phpbb_config` SET `config_name`='min_post_karma', `config_value`='0';
INSERT INTO `phpbb_config` SET `config_name`='lag_karmer', `config_value`='1';
ALTER TABLE `phpbb_users` ADD `karma_plus` MEDIUMINT DEFAULT '0' NOT NULL ;
ALTER TABLE `phpbb_users` ADD `karma_minus` MEDIUMINT DEFAULT '0' NOT NULL ;
ALTER TABLE `phpbb_users` ADD `karma_time` BIGINT DEFAULT '0' NOT NULL ;
|
|
|
|
|
|
Back to Top |
|
|
| Re: Karma Q | |
Posted: 11/14/2007 8:22 AM |
|
|
|
|
Citation |
Posts |
1017 |
Word Cnt. |
64,643 |
BDay |
Apr 18 |
Sign |
Aries |
Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 8:33 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
Okay then go to Cpanel, MySQL Databases, PhpMyAdmin, select the database where you have installed this Karma MOD, and then on right side click SQL and an emtpy box will open, there you paste that SQL queries in it and Run this full SQL query in it and let me know whether your Karma MOD works or not |
|
|
|
|
Back to Top |
|
|
| Re: Karma Q | |
Posted: 11/14/2007 9:02 AM |
|
|
|
|
Citation |
Posts |
1253 |
Word Cnt. |
68,166 |
BDay |
Nov 9 |
Sign |
Scorpio |
Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 4:33 PM
|
|
|
|
|
|
Ohh it does work, what I was wanting was a way to reset it. I gave someone Karma to test it out and I want a way or re-setting that to 0. There isn't a way in the mod itself so I wondered if running an SQL query would do it? I have no idea what though
Sorry for the confusion! |
|
|
|
|
Back to Top |
|
|
| Re: Karma Q | |
Posted: 11/14/2007 11:22 AM |
|
|
|
|
Citation |
Posts |
1017 |
Word Cnt. |
64,643 |
BDay |
Apr 18 |
Sign |
Aries |
Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 8:33 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
I am happy it worked with you. All the credit goes to Nightrider from whom I have learnt this much. He is very intelligent and knowledgeable person. Hopefully he is alright and we will see him online sooner. |
|
|
|
|
Back to Top |
|
|
| Information | |
|