[Doc-Holiday]

Originally Posted by thetwistedpanda They can, Doc-Holiday. You just have to add the necessary information into databases.cfg to connect to the table, then any MySQL action can be issued if formatted properly.

I know the plugin can just wasnt sure if that was the best method.

To the op. Do you know what tables need to be modified? Like the ones that change when you submit a thread?

[lyric]

Originally Posted by Doc-Holiday I know the plugin can just wasnt sure if that was the best method. To the op. Do you know what tables need to be modified? Like the ones that change when you submit a thread?

I will see if I can find that information out for you and post back once I find it.

[Doc-Holiday]

Originally Posted by lyric I will see if I can find that information out for you and post back once I find it.

If you can log in to PHPmyadmin a list of tables would be nice too lol I don't have an internet connection except on my phone so its hard for me to do the research on this one.

[lyric]

Originally Posted by Doc-Holiday If you can log in to PHPmyadmin a list of tables would be nice too lol I don't have an internet connection except on my phone so its hard for me to do the research on this one.

mysql> show tables;
+------------------------------+
| Tables_in_forums             |
+------------------------------+
| mybb_adminlog            |
| mybb_adminoptions        |
| mybb_adminsessions       |
| mybb_adminviews          |
| mybb_announcements       |
| mybb_attachments         |
| mybb_attachtypes         |
| mybb_awaitingactivation  |
| mybb_badwords            |
| mybb_banfilters          |
| mybb_banned              |
| mybb_calendarpermissions |
| mybb_calendars           |
| mybb_captcha             |
| mybb_datacache           |
| mybb_delayedmoderation   |
| mybb_events              |
| mybb_forumpermissions    |
| mybb_forums              |
| mybb_forumsread          |
| mybb_forumsubscriptions  |
| mybb_groupleaders        |
| mybb_helpdocs            |
| mybb_helpsections        |
| mybb_icons               |
| mybb_joinrequests        |
| mybb_mailerrors          |
| mybb_maillogs            |
| mybb_mailqueue           |
| mybb_massemails          |
| mybb_moderatorlog        |
| mybb_moderators          |
| mybb_modtools            |
| mybb_mycode              |
| mybb_polls               |
| mybb_pollvotes           |
| mybb_posts               |
| mybb_privatemessages     |
| mybb_profilefields       |
| mybb_promotionlogs       |
| mybb_promotions          |
| mybb_reportedposts       |
| mybb_reputation          |
| mybb_searchlog           |
| mybb_sessions            |
| mybb_settinggroups       |
| mybb_settings            |
| mybb_smilies             |
| mybb_spiders             |
| mybb_stats               |
| mybb_tasklog             |
| mybb_tasks               |
| mybb_templategroups      |
| mybb_templates           |
| mybb_templatesets        |
| mybb_themes              |
| mybb_themestylesheets    |
| mybb_threadprefixes      |
| mybb_threadratings       |
| mybb_threads             |
| mybb_threadsread         |
| mybb_threadsubscriptions |
| mybb_threadviews         |
| mybb_userfields          |
| mybb_usergroups          |
| mybb_users               |
| mybb_usertitles          |
| mybb_warninglevels       |
| mybb_warnings            |
| mybb_warningtypes        |
+------------------------------+
70 rows in set (0.00 sec)

I've also described what i think is the table that needs altering mybb_threads.

mysql> describe mybb_threads;
+-----------------+----------------------+------+-----+---------+---------------                                                                                                 -+
| Field           | Type                 | Null | Key | Default | Extra                                                                                                           |
+-----------------+----------------------+------+-----+---------+---------------                                                                                                 -+
| tid             | int(10) unsigned     | NO   | PRI | NULL    | auto_increment                                                                                                  |
| fid             | smallint(5) unsigned | NO   | MUL | 0       |                                                                                                                 |
| subject         | varchar(120)         | NO   | MUL |         |                                                                                                                 |
| prefix          | smallint(5) unsigned | NO   |     | 0       |                                                                                                                 |
| icon            | smallint(5) unsigned | NO   |     | 0       |                                                                                                                 |
| poll            | int(10) unsigned     | NO   |     | 0       |                                                                                                                 |
| uid             | int(10) unsigned     | NO   | MUL | 0       |                                                                                                                 |
| username        | varchar(80)          | NO   |     |         |                                                                                                                 |
| dateline        | bigint(30)           | NO   | MUL | 0       |                                                                                                                 |
| firstpost       | int(10) unsigned     | NO   | MUL | 0       |                                                                                                                 |
| lastpost        | bigint(30)           | NO   | MUL | 0       |                                                                                                                 |
| lastposter      | varchar(120)         | NO   |     |         |                                                                                                                 |
| lastposteruid   | int(10) unsigned     | NO   |     | 0       |                                                                                                                 |
| views           | int(100)             | NO   |     | 0       |                                                                                                                 |
| replies         | int(100)             | NO   |     | 0       |                                                                                                                 |
| closed          | varchar(30)          | NO   |     |         |                                                                                                                 |
| sticky          | int(1)               | NO   |     | 0       |                                                                                                                 |
| numratings      | smallint(5) unsigned | NO   |     | 0       |                                                                                                                 |
| totalratings    | smallint(5) unsigned | NO   |     | 0       |                                                                                                                 |
| notes           | text                 | NO   |     | NULL    |                                                                                                                 |
| visible         | int(1)               | NO   |     | 0       |                                                                                                                 |
| unapprovedposts | int(10) unsigned     | NO   |     | 0       |                                                                                                                 |
| attachmentcount | int(10) unsigned     | NO   |     | 0       |                                                                                                                 |
| deletetime      | int(10) unsigned     | NO   |     | 0       |                                                                                                                 |
+-----------------+----------------------+------+-----+---------+---------------                                                                                                 -+
24 rows in set (0.01 sec)

[Doc-Holiday]

Make a post int he section you want with the account you want and post that rows settings. In PHPmyadmin you would click on the specific row and show the details that way the only things that need to change are the subjuect/title things like that..

[lyric]

Originally Posted by Doc-Holiday Make a post int he section you want with the account you want and post that rows settings. In PHPmyadmin you would click on the specific row and show the details that way the only things that need to change are the subjuect/title things like that..

We don't have phpmyadmin installed. is there a way to do this via the command line?

What I do know is our user will have a uid of 3703 and will be posting in fid 20 if that helps.

[Doc-Holiday]

Originally Posted by lyric We don't have phpmyadmin installed. is there a way to do this via the command line? What I do know is our user will have a uid of 3703 and will be posting in fid 20 if that helps.

Yup. That should help. I'm not good with mysql but that should be the info needed to do this. If no one else tries I'll play with it see what I can do

[lyric]

Originally Posted by Doc-Holiday Yup. That should help. I'm not good with mysql but that should be the info needed to do this. If no one else tries I'll play with it see what I can do

awesome thanks.

just to clear my request up since im sure its terrible. it would be ideal if the plugin would allow the player to target a player they suspect is cheating or breaking rules via an in-game menu with !report

after they select the persons name from a list they will be given the chance to type in a message as to what the person is doing that's wrong.

when the report is submitted to the forum in a thread it will take the name of the player who is being reported + the reason so say I was reported for hacking the threads subject would be "lyric - hacking" and the contents of the thread would be like this..

lyric STEAM_0:1:62941394 62.98.110.197 Reported by ROTA wardemon STEAM_0:1:47098395 2.103.182.4 hacking

that's about it. hopefully that's more clear.

[Doc-Holiday]

im installing a copy of the forums on my test site so i can get a full write up of what that table looks like when a row is inserted... lol shouldn't take to long.

Do you allow HTML in posts? lol Not sure how to do the formatting but if i can get it to post maybe someone can do the formatting ill let you know what happens when i finish lol.

this is what I do at work... I work security but the job is so freaking boring i play around with scripting.

[Mr. Man]

Originally Posted by lyric i dont understand. are you saying i can do this with existing plugins or something?

Yes. With this: http://forums.alliedmods.net/showthread.php?p=510469 , you can create commands users can type in game to call up the link to your forum that handles reports.

Of course, the only downside is it won't work for those with HTML disabled.