Log in Register FAQ Memberlist Search Welcome to RCF - WHF Forum Index
alt : test.swf
Welcome to RCF - WHF
4fx3.gif 
Contact the Webmasters of RCFContact   Invite a friend to Join usRecommend   Chat in IRCChat   EZ Template Change OptionEZStyle   Listen to Internet Radio while you browse...iRadio   See your private message.Login for PMs   Important LinksLinks
Member Website LinksWeb Links   Play/View our GamesGames   Register.Register
calendar_open_closeCalendar 
Karma Q
Post new topic   Reply to topic View previous topic :: View next topic
Welcome to RCF - WHF Forum Index -> Area 51 - phpBB & Easymod Tech Support Add To Bookmarks
Karma Q
PostPosted: 11/13/2007 5:18 AM Reply with quote
Citation
Karen
Citation
Posts 1253
Word Cnt. 68,166
BDay Nov 9
Sign Scorpio
Sex Sex:Female
Joined: Jan 06, 2006
Local time: 3:21 PM
greatbrE.gif
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.  dontknow
Thanks  flower
Back to Top
View user's profile Find all posts by Karen Send private message   Visit poster's website Phoogle Map
Re: Karma Q
PostPosted: 11/13/2007 2:09 PM Reply with quote
Citation
abdulbasit
Citation
Posts 1017
Word Cnt. 64,643
BDay Apr 18
Sign Aries
Sex Sex:Male
Joined: Apr 01, 2007
Local time: 7:21 PM
Location: UNITED ARAB EMIRATES
unitedACa.gif
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 Smile
Back to Top
View user's profile Find all posts by abdulbasit Send private message [ Hidden ] Visit poster's website Yahoo Messenger MSN Messenger
Re: Karma Q
PostPosted: 11/14/2007 6:25 AM Reply with quote
Citation
Karen
Citation
Posts 1253
Word Cnt. 68,166
BDay Nov 9
Sign Scorpio
Sex Sex:Female
Joined: Jan 06, 2006
Local time: 3:21 PM
greatbrE.gif
Would you know what query I would run?

headbang
Back to Top
View user's profile Find all posts by Karen Send private message   Visit poster's website Phoogle Map
Re: Karma Q
PostPosted: 11/14/2007 6:57 AM Reply with quote
Citation
abdulbasit
Citation
Posts 1017
Word Cnt. 64,643
BDay Apr 18
Sign Aries
Sex Sex:Male
Joined: Apr 01, 2007
Local time: 7:21 PM
Location: UNITED ARAB EMIRATES
unitedACa.gif
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 Smile
Back to Top
View user's profile Find all posts by abdulbasit Send private message [ Hidden ] Visit poster's website Yahoo Messenger MSN Messenger
Re: Karma Q
PostPosted: 11/14/2007 7:03 AM Reply with quote
Citation
Karen
Citation
Posts 1253
Word Cnt. 68,166
BDay Nov 9
Sign Scorpio
Sex Sex:Female
Joined: Jan 06, 2006
Local time: 3:21 PM
greatbrE.gif
Here's what I had to do to install it  flower

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
View user's profile Find all posts by Karen Send private message   Visit poster's website Phoogle Map
Re: Karma Q
PostPosted: 11/14/2007 8:22 AM Reply with quote
Citation
abdulbasit
Citation
Posts 1017
Word Cnt. 64,643
BDay Apr 18
Sign Aries
Sex Sex:Male
Joined: Apr 01, 2007
Local time: 7:21 PM
Location: UNITED ARAB EMIRATES
unitedACa.gif
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  dontknow
Back to Top
View user's profile Find all posts by abdulbasit Send private message [ Hidden ] Visit poster's website Yahoo Messenger MSN Messenger
Re: Karma Q
PostPosted: 11/14/2007 9:02 AM Reply with quote
Citation
Karen
Citation
Posts 1253
Word Cnt. 68,166
BDay Nov 9
Sign Scorpio
Sex Sex:Female
Joined: Jan 06, 2006
Local time: 3:21 PM
greatbrE.gif
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  hysterical2
Sorry for the confusion!
Back to Top
View user's profile Find all posts by Karen Send private message   Visit poster's website Phoogle Map
Re: Karma Q
PostPosted: 11/14/2007 11:22 AM Reply with quote
Citation
abdulbasit
Citation
Posts 1017
Word Cnt. 64,643
BDay Apr 18
Sign Aries
Sex Sex:Male
Joined: Apr 01, 2007
Local time: 7:21 PM
Location: UNITED ARAB EMIRATES
unitedACa.gif
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.  Boo hoo!
Back to Top
View user's profile Find all posts by abdulbasit Send private message [ Hidden ] Visit poster's website Yahoo Messenger MSN Messenger
 Post new topic  Reply to topic
Information
Welcome to RCF - WHF Forum Index -> Area 51 - phpBB & Easymod Tech Support

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
All times are GMT - 5 Hours

Page 1 of 1


Add To Bookmarks

 
  
  


  Google

Powered by phpBB © 2001, 2005 phpBB Group
  ImageShack  
  Putfile  
  TinyURL  
  CommonDreams  
  Log in  

Page generation time: 0.113s (PHP: 79% - SQL: 21%) - SQL queries: 55 - GZIP enabled - Debug on