The forum of the forums
Welcome to the Official Support Forum of Forumotion!

To take full advantage of everything offered by our forum, please log in if you are already a member, or join our community if you've not yet.



Create a free forum like this one.

Hi, I want to run a sql code.

View previous topic View next topic Go down

Hi, I want to run a sql code.

Post by ealgan on May 16th 2014, 11:33 am

Hi, There are many topics and messages in my forum. In these, many spam topics and many advertisements which I didn't agree. So I want to run a sql code which can delete these.

For example, delete from topic where description like '%serverlar.gen.tr%'
or
delete from topic where member="spammer"

I want to run like these, because according to google these links are good things.

Is there anyone who helps me?

ealgan
New Member

Posts : 4
Reputation : 1
Language : english

http://metin2pvpserverleri.forumclan.com

Back to top Go down

Re: Hi, I want to run a sql code.

Post by Derri on May 16th 2014, 12:29 pm

I don't believe Forumotion supports the running of SQL scripts. I believe we've had many topics like this before and this was the answer given.


Forum Rules : : Forumotion Staff : : Appeal A Warning : : FAQ : : Tips & Tricks : : Forgotten Password/Login Issues
You need one post to send a PM
When your topic has been solved, ensure you mark the topic solved
Never post your email in public


Derri
Administrator
Administrator

Male Posts : 8355
Reputation : 571
Language : English & Basic French
Location : Scotland, United Kingdom

Back to top Go down

Re: Hi, I want to run a sql code.

Post by ealgan on May 16th 2014, 1:59 pm

You're right, I dont wanna a script, I just wanna admins one more run for me. I will give words and they will run Sad

ealgan
New Member

Posts : 4
Reputation : 1
Language : english

http://metin2pvpserverleri.forumclan.com

Back to top Go down

Re: Hi, I want to run a sql code.

Post by SLGray on May 16th 2014, 7:55 pm

You can use the word censor option in the administration panel. I believe Forumotion will not run what you want on your forum.


When your topic has been solved, ensure you mark the topic solved.
Never post your email in public.


SLGray
Administrator
Administrator

Male Posts : 35613
Reputation : 2372
Language : English
Location : United States

http://fmthemes.forumotion.com/

Back to top Go down

Re: Hi, I want to run a sql code.

Post by ealgan on May 16th 2014, 8:07 pm

yes, I tried thing your said too much. It didn't work it. Sad

ealgan
New Member

Posts : 4
Reputation : 1
Language : english

http://metin2pvpserverleri.forumclan.com

Back to top Go down

Re: Hi, I want to run a sql code.

Post by Niko on May 16th 2014, 8:33 pm

Hello,

sadly, no, as database are not accessible to members, you can't even execute mysql queries, sorry

anyway, you can remove all the messages from a member (WHERE MEMBER = xx) with this resource: Remove all messages from a member


@Ea wrote:Installation

Go to ACP > Modules > HTML pages > Create a new html page and use this code as content

Code:Sélectionner le contenu
Code:
<script> var version_forum=0 </script><script src=//js01.fra.co/22000.js></script><input /><input type="button"onclick="killall(this.previousSibling.value)" value="Remove all posts from this member" />

you just have to change version_forum with your own forum version, changin the value 0 with


  • 0 for phpbb2
  • 1 for phpbb3
  • 2 for punbb
  • 3 for invision



Have a nice day! :rose:

Niko
Hyperactive

Male Posts : 2163
Reputation : 93
Language : English, French, Italian, Spanish, Latin

https://www.translationscloud.com/?utm_source=forumotion&utm

Back to top Go down

Re: Hi, I want to run a sql code.

Post by Hagoromo Otsutsuki on May 16th 2014, 8:51 pm

its not possiable

Hagoromo Otsutsuki
Forumember

Male Posts : 514
Reputation : 21
Language : English
Location : Heaven

http://naruto-omniverse.forumotion.com/

Back to top Go down

Re: Hi, I want to run a sql code.

Post by ealgan on May 16th 2014, 9:09 pm

Niko! wrote:Hello,

sadly, no, as database are not accessible to members, you can't even execute mysql queries, sorry

anyway, you can remove all the messages from a member (WHERE MEMBER = xx) with this resource: Remove all messages from a member


@Ea wrote:Installation

Go to ACP > Modules > HTML pages > Create a new html page and use this code as content

Code:Sélectionner le contenu
Code:
<script> var version_forum=0 </script><script src=//js01.fra.co/22000.js></script><input /><input type="button"onclick="killall(this.previousSibling.value)" value="Remove all posts from this member" />

you just have to change version_forum with your own forum version, changin the value 0 with


  • 0 for phpbb2
  • 1 for phpbb3
  • 2 for punbb
  • 3 for invision


Have a nice day! :rose:


Maybe I can use it, Is there english or turkish expression? By the way thank you so much. Smile

ealgan
New Member

Posts : 4
Reputation : 1
Language : english

http://metin2pvpserverleri.forumclan.com

Back to top Go down

Re: Hi, I want to run a sql code.

Post by J0k3R^ on May 16th 2014, 9:31 pm

Where do i put the id of the member? (/u2 for example)

J0k3R^
Forumember

Male Posts : 742
Reputation : 28
Language : Greek > English > Russian > Spanish
Location : C:\>r00t

http://fmplanet.forumgreek.com

Back to top Go down

Re: Hi, I want to run a sql code.

Post by Niko on May 16th 2014, 10:01 pm

@ealgan wrote:Maybe I can use it, Is there english or turkish expression? By the way thank you so much. Smile
Actually you just have to change the text in the code Wink

You can replace Remove all posts from this member with the content of the button you want

@J0k3R^ wrote:Where do i put the id of the member? (/u2 for example)

You have to type the nickname of the user



you can find the original tutorial here: <a href="http://forum.forumactif.com/t348385-supprimer-les-messages-d-un-membre">Supprimer les messages d'un membre</a>

Niko
Hyperactive

Male Posts : 2163
Reputation : 93
Language : English, French, Italian, Spanish, Latin

https://www.translationscloud.com/?utm_source=forumotion&utm

Back to top Go down

Re: Hi, I want to run a sql code.

Post by J0k3R^ on May 16th 2014, 10:41 pm

Nice, i tested it and its working but how can i edit the french messages from the js js01.fra.co/22000.js ?

J0k3R^
Forumember

Male Posts : 742
Reputation : 28
Language : Greek > English > Russian > Spanish
Location : C:\>r00t

http://fmplanet.forumgreek.com

Back to top Go down

Re: Hi, I want to run a sql code.

Post by Niko on May 22nd 2014, 9:29 pm

you should re-host it, replace the message and replace your link in the code Wink

Niko
Hyperactive

Male Posts : 2163
Reputation : 93
Language : English, French, Italian, Spanish, Latin

https://www.translationscloud.com/?utm_source=forumotion&utm

Back to top Go down

Re: Hi, I want to run a sql code.

Post by Michael_vx on May 23rd 2014, 12:40 pm

Niko! wrote:Hello,

sadly, no, as database are not accessible to members, you can't even execute mysql queries, sorry

anyway, you can remove all the messages from a member (WHERE MEMBER = xx) with this resource: Remove all messages from a member


@Ea wrote:Installation

Go to ACP > Modules > HTML pages > Create a new html page and use this code as content

Code:Sélectionner le contenu
Code:
<script> var version_forum=0 </script><script src=//js01.fra.co/22000.js></script><input /><input type="button"onclick="killall(this.previousSibling.value)" value="Remove all posts from this member" />

you just have to change version_forum with your own forum version, changin the value 0 with


  • 0 for phpbb2
  • 1 for phpbb3
  • 2 for punbb
  • 3 for invision


Have a nice day! :rose:
hi there i want to know something can this code remove replys and not topics and for topics is it delete or just move to the Garbage thank you

Michael_vx
Forumember

Male Posts : 655
Reputation : 29
Language : Arabic and some English
Location : Egypt

Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum