PDA

View Full Version : AutoSubmit from phpBB3 to ******** & Xenu


Golden Falcon
01-10-2009, 04:06 PM
This is the same exact script as Erratic's which can be found here: http://www.katzforums.com/showthread.php?t=153091

I take no credit for this, ALL credit goes to Erratic for this. These are modified to work for ******** & Xenu.

******** Forum Auto-Submitter

Open: /styles/___your_theme_name___/template/mcp_forum.html

Find: <!-- IF S_CAN_MAKE_ANNOUNCE -->
<option value="make_announce">{L_MAKE_ANNOUNCE}</option>
<option value="make_global">{L_MAKE_GLOBAL}</option>
<!-- ENDIF -->
After, Add: <option value="submitphaze">Submit to ********</option>

Open: /includes/mcp/mcp_main.php

Find: $quickmod = ($mode == 'quickmod') ? true : false;

switch ($action)
{

After, Add
//******** Forum Submitter
case 'submitphaze':
$topic_ids = request_var('topic_id_list', array(0));
submit2($topic_ids);
break;
//******** Forum Submitter
Find: /**
* Lock/Unlock Topic/Post
*/
function lock_unlock($action, $ids)

Before, Add: //
//PhazeStart
//
function submit2($topic_ids)
{
global $db;
$sql = 'SELECT topic_id, topic_title
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);

//Here's some basic settings.
$yoursite = "http://sitename.com/viewtopic.php?t="; //include link to the viewtopic, so everything is there except for the unique ID.
$yoursiteurl = "http://sitename.com/";
$youremail = "name@email.com";
$yoursitename = "SiteName";

//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=\"http://www.*************/submit.php\" method=\"POST\">";
print "<span style=\"font-size:18px;\">Downloads to Submit to ********:</span><br /><br />";
foreach($topic_info as $topic_info)
{
$topic_title = $topic_info['topic_title'];
$topic_url = $topic_info['topic_id'];
print "Download Title: <input type=\"text\" name=\"title[]\" class=\"form\" maxlength=\"70\" size=\"40\" value=\"$topic_title\"> ";
print "Download Url: <input type=\"text\" name=\"url[]\" class=\"form\" maxlength=\"70\" size=\"40\" value=\"$yoursite$topic_url\"> <select name=\"type[]\" class=form><option value=\"App\">App</option><option value=\"Game\">Game</option><option value=\"Movie\">Movie</option><option value=\"TV\">TV</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 />";
}
print "<br /><span style=\"font-size:18px;\">Settings:</span><br /><br />Site Name: <input type=\"text\" name=\"sname\" class=\"form\" size=\"30\" value=\"$yoursitename\"> Site URL: <input type=\"text\" name=\"surl\" class=\"form\" size=\"30\" value=\"$yoursiteurl\"> Email: <input type=\"text\" name=\"email\" class=\"form\" size=\"30\" value=\"$youremail\"><br />";
print "<br /><input type=\"Submit\" value=\"Submit Downloads\"></form>";
print "</tr></td></table>";

exit;
}
//
//PhazeEnd
//


And same one just for Xenu
Xenu Forum Auto-Submitter

Open: /styles/___your_theme_name___/template/mcp_forum.html

Find: <!-- IF S_CAN_MAKE_ANNOUNCE -->
<option value="make_announce">{L_MAKE_ANNOUNCE}</option>
<option value="make_global">{L_MAKE_GLOBAL}</option>
<!-- ENDIF -->
After, Add: <option value="submitxenu">Submit to Xenu</option>

Open: /includes/mcp/mcp_main.php

Find: $quickmod = ($mode == 'quickmod') ? true : false;

switch ($action)
{

After, Add
//Xenu Forum Submitter
case 'submitxenu':
$topic_ids = request_var('topic_id_list', array(0));
submit3($topic_ids);
break;
//Xenu Forum Submitter
Find: /**
* Lock/Unlock Topic/Post
*/
function lock_unlock($action, $ids)

Before, Add: //
//XenuStart
//
function submit3($topic_ids)
{
global $db;
$sql = 'SELECT topic_id, topic_title
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);

//Here's some basic settings.
$yoursite = "http://sitename.com/viewtopic.php?t="; //include link to the viewtopic, so everything is there except for the unique ID.
$yoursiteurl = "http://sitename.com/";
$youremail = "name@email.com";
$yoursitename = "SiteName";

//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=\"http://xenu.ws/submit.html\" method=\"POST\">";
print "<span style=\"font-size:18px;\">Downloads to Submit to Xenu:</span><br /><br />";
foreach($topic_info as $topic_info)
{
$topic_title = $topic_info['topic_title'];
$topic_url = $topic_info['topic_id'];
print "Download Title: <input type=\"text\" name=\"title[]\" class=\"form\" maxlength=\"70\" size=\"40\" value=\"$topic_title\"> ";
print "Download Url: <input type=\"text\" name=\"url[]\" class=\"form\" maxlength=\"70\" size=\"40\" value=\"$yoursite$topic_url\"> <select name=\"type[]\" class=form>

<option value=\"Software\">Software</option>
<option value=\"Game\">Game</option>
<option value=\"Movie\">Movie</option>
<option value=\"Music\">Music</option>
<option value=\"TV\">TV</option>
<option value=\"eBook\">eBook</option>
<option value=\"Other\">Other</option>
<option value=\"Porn\">Porn</option>


</select> <a href=\"$yoursite$topic_url\" target=\"_blank\" class=\"mainmenu\">Check Download</a><br />";
}
print "<br /><span style=\"font-size:18px;\">Settings:</span><br /><br />Site Name: <input type=\"text\" name=\"sname\" class=\"form\" size=\"30\" value=\"$yoursitename\"> Site URL: <input type=\"text\" name=\"surl\" class=\"form\" size=\"30\" value=\"$yoursiteurl\"> Email: <input type=\"text\" name=\"email\" class=\"form\" size=\"30\" value=\"$youremail\"><br />";
print "<br /><input type=\"Submit\" value=\"Submit Downloads\"></form>";
print "</tr></td></table>";


exit;
}
//
//XenuEnd
//

yais
01-10-2009, 10:59 PM
got this error when i tested it out:

General Error
SQL ERROR [ mysql4 ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

FILE: includes/db/dbal.php
LINE: 379
CALL: dbal->sql_error()

FILE: includes/mcp/mcp_main.php
LINE: 222
CALL: dbal->sql_in_set()

FILE: includes/mcp/mcp_main.php
LINE: 46
CALL: submit2()

FILE: includes/functions_module.php
LINE: 471
CALL: mcp_main->main()

FILE: mcp.php
LINE: 232
CALL: p_master->load_active()

Golden Falcon
01-11-2009, 04:55 AM
Hmm... This is same code copied pasted from my .php file.

I am running phpBB 3.0.4 with MySQL(i) 5.0.51a if that matters.

I see your running MySQL 4?

Not really a programmer. I just fiddled around and worked for me, because I see my posts on these sites after I use the script o.o.