Warning: The author of this contribution does not provide support for it anymore.

Thanks for posts

DB question. - Thanks for posts

DB question.

by Zekvyrin » Fri Jun 11, 2010 11:20 am

Can you plz tell me what you alter/update/create/insert in the database with this mod?

I mean I want a quick "guide" of (for example) what happens in the db when someone presses the "thanks" button, (and what happens when he press the "remove").
I guess that will do the job.

or possibly what other changes are made in other entries (not the ones used in the previous "actions").

Sorry I can't explain it better, so I'll tell you how I want to use it:
In my forum, I have another "thanks mod" and I want to change it with yours, but keep the entries.

So I need to know some info I couldn't find for sure in the files.
(I'm not that experienced using php, and I found it quite confusing).

I can update them myself i guess, if I know the source and target tables/variables. (or other tables/variables that need to be altered). I know the source's, I need the target's ;)

Thanks in advance
Zekvyrin
Registered User
Posts: 1
Joined: Fri Jun 11, 2010 11:10 am
Contact:

Re: DB question.

by Палыч » Fri Jun 11, 2010 8:54 pm

Which mod you use?

In this table (three fields) stores all information

Code: Select all

CREATE TABLE phpbb_thanks (
         post_id mediumint(8) NOT NULL default '0',
         poster_id mediumint(8) NOT NULL default '0',
         user_id mediumint(8) NOT NULL default '0',
         PRIMARY KEY (post_id , user_id));

post_id - post id
poster_id - author by post
user_id - author THANKS
If THANKS removed - removed record
Sorry for my bad english
User avatar
Палыч
Translator
Posts: 1543
Joined: Sun Jul 01, 2007 7:59 pm
Location: St. Petersburg
Name: Сергей
Contact:

Re: DB question.

by Zekvyrin » Sun Jun 13, 2010 8:06 pm

Палыч wrote:Which mod you use?

I was using that:
viewtopic.php?f=70&t=1115275

Палыч wrote:In this table (three fields) stores all information

Code: Select all

CREATE TABLE phpbb_thanks (
         post_id mediumint(8) NOT NULL default '0',
         poster_id mediumint(8) NOT NULL default '0',
         user_id mediumint(8) NOT NULL default '0',
         PRIMARY KEY (post_id , user_id));

post_id - post id
poster_id - author by post
user_id - author THANKS
If THANKS removed - removed record


well.. I don't mean exactly only that one..
I'm aware of that table (since I've tested that mod and checked the db)

btw, where exactly did you found that?
i might find the info I need in the same file..

for example:
my old mod, has some entries in other tables:
user_thanked , thanks_post , user_thanks(in users table)
post_thanked (in posts table)

I need to find that ones. (although I know it's possible that it doesn't have any, as you can find the info you need from this by running queries in db when needed)

but I have to be sure, so it won't malfunction.
Zekvyrin
Registered User
Posts: 1
Joined: Fri Jun 11, 2010 11:10 am
Contact:

Re: DB question.

by Палыч » Sun Jun 13, 2010 10:43 pm

Zekvyrin wrote:for example: my old mod, has some entries in other tables:user_thanked , thanks_post , user_thanks(in users table)post_thanked (in posts table)

I do not understand the logic of MOD аnd I can not see the code
Impossible to download viewtopic.php?p=12802555#p12802555

The author believes that MODs is not compatible
viewtopic.php?p=12797861#p12797861
Sorry for my bad english
User avatar
Палыч
Translator
Posts: 1543
Joined: Sun Jul 01, 2007 7:59 pm
Location: St. Petersburg
Name: Сергей
Contact:

Re: DB question.

by Zekvyrin » Mon Jun 14, 2010 10:39 am

anyway, I don't want anything from the other mod.
I've found what I need from that.

tell me in which file you found that create table please.
i might find the info I need in the same file.
Zekvyrin
Registered User
Posts: 1
Joined: Fri Jun 11, 2010 11:10 am
Contact:

Re: DB question.

by Палыч » Mon Jun 14, 2010 12:28 pm

All the files you have :)
The table is created when performing a file install_thanks_mod.php
Sorry for my bad english
User avatar
Палыч
Translator
Posts: 1543
Joined: Sun Jul 01, 2007 7:59 pm
Location: St. Petersburg
Name: Сергей
Contact:

Re: DB question.

by cryptoevo.de » Sun Jan 13, 2019 2:39 pm

. pls delte
cryptoevo.de
Registered User
Posts: 18
Joined: Mon Dec 25, 2017 4:30 pm
Contact: