PHPBB3 Autosubmitter

jomasaco · **PHPBB3 Autosubmitter -** 05-03-2010, 12:17 AM

Since i don't have the forum no longuer i will present you here whit my phpbb3 autosubmitter.
If have something wroung please say, this topic will be done from my head mistakes can happen.
Backup the edit files first.

$topic_type = $topic_info['topic_description'];
This i have used to autofill the type become from topic description mod. no prob if not used.

$checked
i have used to add an info on foter of topic "submitted ...." i will post this change later

On forum folder create 3 files, urls.txt, iplog.txt, submit.php
Urls.txt add

Code:

http:stugas-ddl.org/submit.php

iplog.txt
leave in blank chmod to 666
submit.php
[code=php:2jedusgt]<?php
//
//*Username*and*IP*Logging
//
$dt*=*date("j-F-Y**H:i:s");
$fp*=*fopen("IPlog.txt",*"a+");
$ip*=*$_SERVER['REMOTE_ADDR'];
//$surl*=*$surl['surl[]'];
$mg*=*"Date*and*Time:*$dt*|*From*IP *address*$ip*|*Submitted*url:*$_POST[surl]\n";
fwrite($fp,*"$mg\r\n");
//*change*the*above*line*to*fwrite($fp,*"$mg\n\n");* for*unix
//*or*leave*as-is*for*Windows
fclose($fp);
//
//*putt*your*html*above*here

set_time_limit(0);
ini_set('max_execution_time',*600);
ob_start();
function*get_micro()*{
****list($usec,*$sec)*=*explode("*",*microtime());
****return*((float)$usec*+*(float)$sec);
}
$start*=*get_micro();
function*submit($url,*$query)*{
***global*$errno,*$errstr;
***$uri*=*parse_url($url);
***if*(!isset($uri['port']))
******$uri['port']*=*80;

***$req*=*"POST*{$uri['path']}*HTTP/1.1\r\n"
*******.*"Host:*{$uri['host']}\r\n"
*******.*"Content-type:*application/x-www-form-urlencoded\r\n"
*******.*"User-Agent:*Mozilla*4.0\r\n"
*******.*"Content-length:*"*.*strlen($query)*.*"\r\n"
*******.*"Connection:*close\r\n\r\n"
*******.*$query;

***$errno*=*0;
***$errstr*=*'';

***if*(!$fp*=*@fsockopen($uri['host'],*$uri['port'],*$errno,*$errstr,*3))
******return*false;

***fputs($fp,*$req);

***$buff*=*fread($fp,*8192);
***$ret*=*strpos($buff,*'200*OK')*?*true*:*false;

***fclose($fp);
***return*$ret;
}

/***/
$urls*=*array_map('trim',*file('urls.txt'));

if($_POST)*{
**/**if(!$_POST['title'][0]*||*!$_POST['url'][0]*||*!$_POST['sname']*||*!$_POST['surl'])*{
******echo*"<span*style=\"font-weight:bold;color:#C00;font-size:16px;\">You*did*not*fill*in*all*required*fiel ds!<br*/><br*/>\r\n";
***}*else*/*{

******$compile*=*"sname={$_POST['sname']}&surl={$_POST['surl']}&email={$_POST['email']}";
******$i*=*$x*=*0;

******foreach*($_POST['title']*as*$key*=>*$val)*{
*********if($val*&&*$_POST['url'][$key]*&&*$_POST['type'][$key])*{
************$i++;
************$compile*.=*"&title[]=$val&url[]={$_POST['url'][$key]}&type[]={$_POST['type'][$key]}";
*********}
******}
******foreach*($_POST['submit_to']*as*$line)*{
*********if(submit($urls[--$line],*$compile))*{
************echo*"<span*style=\"color:green\"> Submitted*to*{$urls[$line]}<br*/>\r\n";
************$x++;
*********}*else*{
************$err*=*$errno*?*"*(failed*to*connect*to*serve r)"*:*"*(server*is*up*but*couldn't* submit)";
************echo*"<span*style=\"color:red\">Fa iled*to*submit*to*{$urls[$line]}*($err)<br*/>\r\n";
*********}**
******}

******echo*"<br*/>All*done*-*$i*downloads*submitted*to*$x*sites!";
***}

}*else*{
***//*show*form
***echo*'<form*name="add"*action="sub mitter.php"*method="POST">';
/*
***foreach*($urls*as*$id*=>*$url)*{
******if(!$url)
*********continue;
******echo*"<input*type=\"checkbox\"*name=\"submit _to[".*($id++)*."]\"*value=\"$id\"*checked=\"yes\"*/>$url<br*/>\r\n";
***}
*/
echo'<table>
****<tr>';
****$x=0;
****foreach*($urls*as*$id*=>*$url)*{
********if(!$url)
************continue;
********echo*"<td><input*type=\"checkbox\" *name=\"submit_to[".*($id++)*."]\"*value=\"$id\"*checked=\"yes\"*/></td><td>$url</td>";
********$x++;
********if($x*%*3*==*0)*echo*'</tr><tr>';
****}
****unset($x);
echo'****</tr>
****</table>';
***echo*'<br*/><table*border="0"*cellspacing="2"*cellpadding="2" *border="0">';

***for*($i=1;*$i<11;*$i++)*{
******echo*'<tr><td*style="border:1px*so lid*#4B4F62;*background-color:*#FFFFFF;*color:#7088B3">Download*Name*'*.*$i*.*($i==1?'*':'')*.*':*</td><td>
***********<input*type="text"*name="title[]"*style="border:1px*solid*#4B4F62;*background-color:*#FFFFFF;*color:#7088B3"*size="30"*maxlength ="38">
***********</td><td*style="border:1px*solid*#4B4F62;*background-color:*#FFFFFF;*color:#7088B3">*Download*Url*'*.*$i*.*($i==1?'*':'')*.*'
***********:</td><td><input*type="text"*name="url[]"*style="border:1px*solid*#4B4F62;*background-color:*#FFFFFF;*color:#7088B3"*size="30">
***********</td><td><select*name="type[]"*class=form><option>Game</option><option>App</option><option>Movie</option>
***********<option>Music</option><option>TV</option><option>XXX</option><option>Other</option><option>Script</option><option>Template</option><option>eBook</option></select></tr>';
***}

***echo*'<tr><td*class="form2">
Site*Name*:*</td><td>
<input*type="text"*name="sname"*style="border:1px* solid*#4B4F62;*background-color:*#FFFFFF;*color:#7088B3"*size="30">
***</td><td*class="form2">
*Site*Url*:*</td>

***<td>
<input*type="text"*name="surl"*style="border:1px*s olid*#4B4F62;*background-color:*#FFFFFF;*color:#66CC66"*size="30"></td></tr><tr><td*class="form2">E-mail:*</td>
***<td*colspan="4"><input*type="text"*name="email" *style="border:1px*solid*#4B4F62;*background-color:*#FFFFFF;*color:#7088B3"*size="30"></td></tr>
***<tr><td></td><td*colspan="4"*class="form2">
<input*type="Submit"*value="Submit*Download"*style ="border:1px*solid*#4B4F62;*background-color:*#FFFFFF;*color:#7088B3">

****-*Press*Only*Once!!*Submission*May*Take*Up*to*5*Min *!*Please*be*patient.</td></tr></form></table>';
}

//*and*html*below*here
?>[/code:2jedusgt]

Now open
Includes/mcp/mcp_main.php
find

Code:

		$quickmod = ($mode == 'quickmod') ? true : false;
		switch ($action)
		{

after add
[code=php:2jedusgt]**************************** ********//*START*phpBB3*Share-Rapid*AutoSubmitter
************case*'autosubmit':
****************$topic_ids*=*request_var('topic_id_list',*array(0));
****************submit($topic_ids);
************break;*[/code:2jedusgt]
find

Code:

			default:
				trigger_error('NO_MODE', E_USER_ERROR);
			break;
		}
	}
}

after add
[code=php:2jedusgt]//*Start*phpBB3*Share-Rapid*AutoSubmitter
//
function*submit($topic_ids)
{
global*$db;
$sql*=*'SELECT*topic_id,*topic_title ,*topic_description
****FROM*'*.*TOPICS_TABLE*.*'
****WHERE*'*.*$db->sql_in_set('topic_id',*$topic_ids);
****$result*=*$db->sql_query($sql);
****$topic_info*=*$db->sql_fetchrowset($result);
****$db->sql_freeresult($result);

************$checked=date('F*jS,*Y,*g:i*a',*time());
************$sql*=*"UPDATE*"*.*POSTS_TABLE*.*"*
************SET*submited*=*'[Submited*to*DDL*at*".*$checked*."]'*
************WHERE*"*.*$db->sql_in_set('topic_id',*$topic_ids);
************$db->sql_query($sql);
************
//Here's*some*basic*settings.
$yoursite*=*"http://share-rapid.org/forum/viewtopic.php?t=";*//include*link*to*the*viewtopic,*so*everything*is*th ere*except*for*the*unique*ID.
$yoursiteurl*=*"http://share-rapid.org";
$youremail*=*"[email protected]";
$yoursitename*=*"Share-Rapid";
$urls*=*array_map('trim',*file('urls.txt'));

//Spit*out*the*page.
print*"<div*align=\"center\"><table *style=\"width:*900px;*border-style:solid;*font-family:tahoma;*font-size:11px;*padding:5px;\"><tr><td>";
print*"<br*/><form*name=\"add\"*action=\"submit.php\"*method=\ "POST\">";
print*"<span*style=\"font-size:18px;\">Downloads*to*Submit:<br*/>";
foreach($topic_info*as*$topic_info)
{
$topic_title*=*$topic_info['topic_title'];
$topic_url*=*$topic_info['topic_id'];
$topic_type*=*$topic_info['topic_description'];
print*"Download*Title:*<input*type= \"text\"*name=\"title[]\"*class=\"form\"*maxlength=\"70\"*size=\"40\"*val ue=\"$topic_title\">*";
print*"Download*Url:*<input*type=\" text\"*name=\"url[]\"*class=\"form\"*maxlength=\"70\"*size=\"40\"*val ue=\"$yoursite$topic_url\">";
print*"<select*name=\"type[]\"*class=form><option*value=\"$topic_type\">$topic _type</option><option*value=\"App\">App</option><option*value=\"Game\">Game</option><option*value=\"Movie\">Movie</option><option*value=\"TV\">TV</option><option*value=\"Music\">Music</option><option*value=\"XXX\">XXX</option><option*value=\"eBook\">eBook</option><option*value=\"Template\">Template</option><option*value=\"Script\">Script</option><option*value=\"Other\">Other</option></select>*<a*href=\"$yoursite$topic_url\"*target=\"_ blank\"*class=\"mainmenu\">Check*Download</a><br*/>";
}
echo'<table><tr>';
****$x=0;
****foreach*($urls*as*$id*=>*$url)*{
********if(!$url)
************continue;
********echo*"<td><input*type=\"checkbox\" *name=\"submit_to[".*($id++)*."]\"*value=\"$id\"*checked=\"yes\"*/>$url</td>";
********$x++;
********if($x*%*3*==*0)*echo*'</tr><tr>';
****}
****unset($x);
echo'****</tr></table>';

***echo*'<br*/><table*border="0"*cellspacing="2"*cellpadding="2" *border="0">';
***print*"<tr><td*class=\"form2\">
Site*Name*:*</td><td>
<input*type=\"text\"*name=\"sname\"*value=\"$yours itename\"*style=\"border:1px*solid*#4B4F62;*backgr ound-color:*#FFFFFF;*color:#7088B3\"*size=\"30\">
***</td><td*class=\"form2\">
*Site*Url*:*</td>

***<td>
<input*type=\"text\"*name=\"surl\"*value=\"$yoursi teurl\"*style=\"border:1px*solid*#4B4F62;*backgrou nd-color:*#FFFFFF;*color:#66CC66\"*size=\"30\"></td></tr><tr><td*class=\"form2\">E-mail:*</td>
***<td*colspan=\"4\"><input*type=\"text\"*name=\"e mail\"*value=\"$youremail\"*style=\"border:1px*sol id*#4B4F62;*background-color:*#FFFFFF;*color:#7088B3\"*size=\"30\"></td></tr>
***<tr><td></td><td*colspan=\"4\"*class=\"form2\">
<input*type=\"Submit\"*value=\"Submit*Download\"*s tyle=\"border:1px*solid*#4B4F62;*background-color:*#FFFFFF;*color:#7088B3\">

****-*Press*Only*Once!!*Submission*May*Take*Up*to*5*Min *!*Please*be*patient.</td></tr></form></table>";*******
exit;
}

//
//*END*phpBB3*Share-Rapid*AutoSubmitter***[/code:2jedusgt]
Open styles/subsilver/template/mcp_forum.html
find

Code:

				<option value="make_global">{L_MAKE_GLOBAL}
</option>

after add
[code=php:2jedusgt]****************<option*value="autosubmit">Autosubmit</option>*[/code:2jedusgt]

Please someone test to check if everthing are fine.

c0rrupt · **Re: PHPBB3 Autosubmitter -** 05-03-2010, 10:49 AM

works fine here mate just had to make a sql table 'submitted'

how do i pull this into posts
$checked
i have used to add an info on foter of topic "submitted ...." i will post this change later

jomasaco · **Re: PHPBB3 Autosubmitter -** 05-04-2010, 01:01 AM

SQL

Code:

ALTER TABLE phpbb_posts ADD `submited` varchar(255) NOT NULL;

Open: styles/~{Your Style}~/template/viewtopic_body.html
Find:

Quote:

{postrow.MESSAGE}</div>

After add:

Code:

<div class="notice">{postrow.SUBMITED}</div>

Open: viewtopic.php
Find:

Quote:

'BUMPED_MESSAGE' => $l_bumped_by,

After add:

Code:

'SUBMITED'            => $row['submited'],

Find:

Quote:

$sql = 'SELECT post_id, topic_id, forum_id

Replace by:

Code:

$sql = 'SELECT post_id, topic_id, forum_id, submited

Find:

Quote:

'post_edit_user' => $row['post_edit_user'],

After add:

Code:

'submited'                => $row['submited'],

c0rrupt · **Re: PHPBB3 Autosubmitter -** 05-04-2010, 01:50 PM

for any one with this error in SQL

SQL ERROR [ mysql4 ]

Field 'submited' doesn't have a default value [1364]

SQL

RUN THIS:

Code:

ALTER TABLE `phpbb_posts` CHANGE `submited` `submited` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0'

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode