";
$cp->set_id("response");
$cp->set_data($optdata);
}
return;
}
function extra_search_fields2($type)
{
global $db, $cp;
$sSQL = "SELECT optSub FROM `".PREFIX."fields_options`WHERE optValue='".mysql_real_escape_string($type)."'";
$test=$sSQL;
$result2 = $db->query($sSQL);
$rows=$result2->size();
if($rows>0)
{
$optdata2='
';
while($rs2=$result2->fetch())
{
$sql="SELECT fID,fName,fDefault,fType,fRequired FROM `".PREFIX."fields` WHERE fID='".$rs2['optSub']."' ORDER BY fOrder ASC";
$test.=" ".$sql;
$result3 = $db->query($sql);
$row = $result3->fetch();
if($row['fType']=="Y")
{
//it is a child select list//
$optdata2.="
".$row['fName'].":
";
}
elseif($row['fType']=="S")
{
//single text field
$optdata2.="
".$row['fName'].":
\n";
}
}
$optdata2.="
";
}
$cp->set_id("optResponse");
$cp->set_data($optdata2);
return;
}
?> administration/annual.png 0000644 0023433 0004734 00000025053 11051631425 015442 0 ustar xemion psacln PNG
IHDR X OG IDATx{\Te ?a* J8Y-/*y+onH%h%XoKj\3l%_*"0%~9<~=9g`0 6! ! ! ߭uWתwE͏`8/kJl[Z" ,jDiᠡZΛމS7D aWEח-Z&?}g<]/ohl:2eʃV\ooTn dJܦ7֕Q"?رӋfT~quuE@" aeɘl<:v_7?JXhL2eʔLBRtVJNN...~ >pӷ
c6 {V)2o㌐2hР-[|gǎ 3 /B^^op?xӧOϟ>}i.\xa++?~~~jڴkll>>Frtt1 H$ YoݺeV͛7
]]]+** ORu8Q۷ /w<+?ݽB{oQvzW!;w$B
!$++믿?VVV,X0uT7mtʕDǩS655 0 iivw/iTpw[kqRi yPׯYfSLa/ >! n|FC
|}} 0OPTk[?͑ǩ$_R]gnvٻwoΝ{
`S"lzTYڶsx).ZꜞVؗZ|yU LaĿ93: ̴̴eV>dj駟NKK#^zĉ111
6zz k}Q #fϘLԼ&vlз>O_$B7---b1u #wڕ1z{R'R{ !<6^Oojkk.\hZaƌNQ:UQQL&3= ЭV}9ȃُs?LCmB_~ڵ c^vѣG֭3 LmX[[iZ㉝V j}С[BZQ==GcbqppԖE}^!FtsW FGe3'~;00XiӦp_|qƌs?}p3gnٲeܸqǏ 75iҤ˗;y Z[KJJ Ov3.^6 ُ .:Uܸ7mzXD
`?~;mF[&BD"т :t !999˖-3
ĉ Vmf+777'''VkٳgSz*4v8***?T~ Fgsq3 '
u6 NQ~9vO u ltRrrrAA%Kuuu'NXlѣGoN744ݻzY$ :t(..cL={C!T5=`̙26"""?ò2ӳz}xxH$tRlllRRɓ'KJJN8 ]XXxqWW~ۙ+aVV}||Μ9CQՅ >ٳ
H$jjj" `XlcLn111"HպuҒ lmmMYv-U~ȑ`///BM'T*BHTTTCCRW
O DMMMn :tРAT1K,ikk{w; nݺgRɘ}ΝŋթꐐBH[['xظ[C 9ez קo VX1tŋ_t*7nL&;sW_}EM:Ʀuǎ
g&Lkk배0J'77Fikksrrrssxxxd{nĈkfffDDDKKKPP5 ̍ =oM 9bcc3={EEEuu+ -ROR9rH]Ǐ߽{wDD֭[=<< !'NTTN
VejjX,
VbN4:::10Ms }mtG?CPPСC^|Ŏ{u:Vcƌ1-/))qtt4~aJJJD"wijj dH ,[frssj @$B } @ ! ! ! ! ! ?ܻwfwqFo{w566^~;)o f͚:y{Q˗/W*-rssˣ
zK/8w
6_GEETRtuuuuuuppDP ! OSL!DFF:::{AB>?slj[ә}>?ɓIII}5k ?~ݺu v:tnݺ PYU__OmSYbmmmooOm 9rdʕgϞuVOfPz'̾ZhΚ5Z$i4QFBVZuB =J}UMYYJdZV8;;1 illKII:u*U>}!33ʔQFyxxx{{;w.&&f5ܸq#,,յ D9>#Tׯ_v횿RR|eeeeee/lo ,Y$<<ܘ$\{nmɒ%ɧN3a]~~~~#G,Z!pswQ\\ BVZP(
Űaè\\\.^(J+**nܸa<_e ~{%''wܕt Oرߟ2|D8;;_~Ʀ',))[ZZ<==gRv= 7766ٳ'%%YYYӓRYY)J !RB}?8(ԬY* }?#G =zd,>%ϟwppv^paĉ999...kϟ0a¨Qlmm\s;;;cm|}}Lg 3 /A-[ --ˋ*T*鑑iiiJҬ N 8Ύt!G 뻊GtWm, >\$QsNBSO=%mllө[*##5# F"0
k,SRR"^ZV&YZZ Dt U#dю\\\:ZZZvZNG D%=B dվJ h]_5>,4ns6"C wIG @X$B Kp: g,a;_ ,o # ˛Dٙ; q6bi ^' lE"lGK xM"6 } `y9;s ;X, w
H| >I_ ,o!gg | v8{ /a GDxcǚtR\nee}!EK x=Κ5Z$i4QFBT*L&jٹB# Q @k?Ӕ)S! !dҥ
"222999;;;99BBȥK!r~ E!v }aq;>FD@+,H*..5Z&nݺB#/a GeٓBXYY)J !RBj.Gc B{LXdIxxԩS{]g v>oX[[oذX"H***RiEESW
x
g q6D'>}ڴPTGFF)n
@ Xڟ >|H$&ܹD"0}}¬v (ӒћXMD">#|A1cjZLfiiMgg | ;@Fbii8^' l
@ X$B @ X$B Kp: g,a;_ ,o # ˛Dٙ; q6bi ^' lE"lGK xM"6 } `y9;s ;X, w
H| >I_ ,o!gg | v8{ /a G7PK xM" 8`Ҩ^4+6Lu:]ii\.2 8`H"ܷo͛
<==UV ?~Z>z3I_ ,o!gg | v8{ /a GD---MKt:]ii\.꾐"%l <Ҟ۷y梢OOOLRd2Vh*4 8`Y0 6/ :tܹDtRBU!!ҥK\Nk? "`^;>VиUx kD"ag&LXhj5!$44t֭ | ><,SYY)J !RBj.Gc g v >!H***RiEESW
x
g q6DT*###ҔJe7F_ ,O ((/$)!H222L_0+$)=B }j慨>FH@+'®zV+L_ﴐJ>}
@U7^Xh2F !...SH6 q6DS_ ,o_s ,o!gg | v8{ /a G7PK xM" 8`4g q6"#%l <&
| >I g,Fu ;X$v
@ X$B/a G73w lh;N | D؎ # ˛D(%l <&rv w
|iTSBNWZZ*˭̎u ;WZuqjUѣ< !LRd2VhMO6 } `YݻwΜ9%ё ɦ{
@ XaAAB6lUhj5!$44t֭fsv w
yiYYYӓRYY)J !Rr%BH^^ !D.U |eZ}=EK xeӧOSB*VTT899B
H/a GDx#GBҼBR T*N 8`ҨR666Ta||JJMM0; 8`r"KJJb˂cƌj2-{ # =B/a G5
t
yi8{ /a G7PK xM" 8`4g q6"#%l <&
| >I ]lkkkYY٘1cNICCݻwǎ ]h;}Nwqvv:1`>/Hlyy :vD"1ݛ[oUWW ;vl]vDha0h/Źwܙ7oSyyɓ'/e 1| @wVބDS _GuM2%"""%%%''g:~ ꄄ
aooߋo_/]lBXbŞ={w߽t0| wԿ慨^zEDRYYTX
BZrիW;- Hԋo zqٳgG }?O999;Nw 19ɪ}d,E
#G>Mt~;vؔ7tU
#lwKwy葍MEEOܰ 9uLO4$&&fyN DN_s1=we bw gu.t{G~!5H$f,_\R <866i!x{D"ihhW`>/T7cƌgϮXȑ#*DL4ѱuĉ'Nx饗7w3Ȑ: IDATcǎ-Y/f~u`>/T;gΜÇWWW>~Æ
joyԩS_yjoE=,#{q.cuu_|a crRa{WI[[[yySwVVVZYY 9w ̅M"{6Vf Z0| x{ `=Bn-tR\neee/K*9 Y b\cȽ:p(T*Lj5^ g^LNNNHHHNN6 w
KFVBBCCn8~Ǹ `u;: {:9+++ϥJdCiiY O>Jw gu;z H :tӁ#ո꾴m:nꫯġD }oR|w gu;t}D"ɉP({MMao]z0|[g>suưzMJezz:!$--MT PO>!H222^ fcƌMIIzj?fkWU=uݏ?璓 u ؽ{7 %`1} @2}5kP?ZiÆ
w$$$d|)NW[[[UU V_|E88 F^^^mm1 ~'/^b?OUUYÇ555C 1bĈ#RRR}Y#H =9d:;2? ;S r
X1uTiӦ ?͛YYY3w
:thx8 qƠٳg7662zO ! ]_nkkp
4i&[[_=<<^xVZ|H hX AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" AC" Aϯ%PG IENDB` administration/benchmark.php 0000644 0023433 0004734 00000002745 11051631425 016124 0 ustar xemion psacln title->Set("Benchmark Results");
$graph->title->SetFont($font, FS_BOLD, 12);
// The pie plot
$p1 = new PiePlot($data);
$p1->SetTheme('pastel');
// Move center of pie to the left to make better room
// for the legend
$p1->SetCenter(0.26,0.55);
// Label font and color setup
$p1->SetFont($font, FS_BOLD);
$p1->SetFontColor("black");
// Use absolute values (type==1)
$p1->SetLabelType(1);
// Label format
$p1->SetLabelFormat("%.5f");
// Size of pie in fraction of the width of the graph
$p1->SetSize(0.3);
// Legends
$p1->SetLegends($labels);
$graph->legend->SetFont($font);
$graph->legend->Pos(0.06,0.10);
$graph->Add($p1);
$graph->Stroke();
?>
administration/cache/ 0000755 0023433 0004734 00000000000 11036006023 014505 5 ustar xemion psacln administration/cache/c82285bdb00383c7d56baa6b30fe882c 0000644 0023433 0004734 00000015704 11051631427 021101 0 ustar xemion psacln O:9:"MagpieRSS":23:{s:6:"parser";i:0;s:12:"current_item";a:0:{}s:5:"items";a:3:{i:0;a:11:{s:5:"title";s:31:"68 Classifieds Holiday Schedule";s:4:"link";s:70:"http://www.68classifieds.com/forums/showthread.php?t=2117&goto=newpost";s:7:"pubdate";s:29:"Mon, 18 Dec 2006 13:33:48 GMT";s:11:"description";s:149:"First off I want to wish every one a Merry Christmas and happy holidays.
Our offices will be closed December 22nd through January 2nd.
Although...";s:7:"content";a:1:{s:7:"encoded";s:331:"
First off I want to wish every one a Merry Christmas and happy holidays.
Our offices will be closed December 22nd through January 2nd.
Although the offices will be closed we will be checking in occasionally.
";}s:8:"category";s:20:"News & Announcements";s:2:"dc";a:1:{s:7:"creator";s:6:"suzkaw";}s:4:"guid";s:57:"http://www.68classifieds.com/forums/showthread.php?t=2117";s:7:"summary";s:149:"First off I want to wish every one a Merry Christmas and happy holidays.
Our offices will be closed December 22nd through January 2nd.
Although...";s:12:"atom_content";s:331:"
First off I want to wish every one a Merry Christmas and happy holidays.
Our offices will be closed December 22nd through January 2nd.
Although the offices will be closed we will be checking in occasionally.
";s:14:"date_timestamp";i:1166448828;}i:1;a:11:{s:5:"title";s:23:"v3.1.5b is now released";s:4:"link";s:70:"http://www.68classifieds.com/forums/showthread.php?t=2029&goto=newpost";s:7:"pubdate";s:29:"Thu, 30 Nov 2006 16:19:45 GMT";s:11:"description";s:149:"Version 3.1.5b is now released and available from the members section:
https://www.68classifieds.com/members/index.php
This is a bug fix release...";s:7:"content";a:1:{s:7:"encoded";s:528:"
This is a bug fix release and the only changed files are:
contact.php
contactus.php
friendmail.php
It is recommended that everyone upgrade and at the very minimum replace those files.
";}s:8:"category";s:20:"News & Announcements";s:2:"dc";a:1:{s:7:"creator";s:6:"suzkaw";}s:4:"guid";s:57:"http://www.68classifieds.com/forums/showthread.php?t=2029";s:7:"summary";s:149:"Version 3.1.5b is now released and available from the members section:
https://www.68classifieds.com/members/index.php
This is a bug fix release...";s:12:"atom_content";s:528:"
This is a bug fix release and the only changed files are:
contact.php
contactus.php
friendmail.php
It is recommended that everyone upgrade and at the very minimum replace those files.
";s:14:"date_timestamp";i:1164903585;}i:2;a:11:{s:5:"title";s:18:"Google Code Search";s:4:"link";s:70:"http://www.68classifieds.com/forums/showthread.php?t=1971&goto=newpost";s:7:"pubdate";s:29:"Mon, 20 Nov 2006 13:54:13 GMT";s:11:"description";s:148:"With Google's new code search it is possible for them to index all the files that are in zip format and stored on your server. This means if you...";s:7:"content";a:1:{s:7:"encoded";s:773:"
With Google's new code search it is possible for them to index all the files that are in zip format and stored on your server. This means if you have a compressed site backup stored on your server that includes the connections file then someone could search and possible find this file with your database connection.
To avoid this please remove any compressed files. Also it will not be possible for them to read the contents of the connections/classifieds.php used in our system because it is processed by php before it is shown to the browser.
Also please note that is not explicitly for 68 Classifieds but any type of script you may be running.
";}s:8:"category";s:20:"News & Announcements";s:2:"dc";a:1:{s:7:"creator";s:6:"suzkaw";}s:4:"guid";s:57:"http://www.68classifieds.com/forums/showthread.php?t=1971";s:7:"summary";s:148:"With Google's new code search it is possible for them to index all the files that are in zip format and stored on your server. This means if you...";s:12:"atom_content";s:773:"
With Google's new code search it is possible for them to index all the files that are in zip format and stored on your server. This means if you have a compressed site backup stored on your server that includes the connections file then someone could search and possible find this file with your database connection.
To avoid this please remove any compressed files. Also it will not be possible for them to read the contents of the connections/classifieds.php used in our system because it is processed by php before it is shown to the browser.
Also please note that is not explicitly for 68 Classifieds but any type of script you may be running.
";s:14:"date_timestamp";i:1164030853;}}s:7:"channel";a:8:{s:5:"title";s:44:"68 Classifieds Forums - News & Announcements";s:4:"link";s:35:"http://www.68classifieds.com/forums";s:11:"description";s:32:"Important news and announcements";s:8:"language";s:2:"en";s:13:"lastbuilddate";s:29:"Wed, 20 Dec 2006 21:14:26 GMT";s:9:"generator";s:9:"vBulletin";s:3:"ttl";s:2:"60";s:7:"tagline";s:32:"Important news and announcements";}s:9:"textinput";a:0:{}s:5:"image";a:3:{s:3:"url";s:65:"http://www.68classifieds.com/forums/images/bluesaint/misc/rss.jpg";s:5:"title";s:44:"68 Classifieds Forums - News & Announcements";s:4:"link";s:35:"http://www.68classifieds.com/forums";}s:9:"feed_type";s:3:"RSS";s:12:"feed_version";s:3:"2.0";s:8:"encoding";s:10:"ISO-8859-1";s:16:"_source_encoding";s:0:"";s:5:"ERROR";s:0:"";s:7:"WARNING";s:0:"";s:19:"_CONTENT_CONSTRUCTS";a:6:{i:0;s:7:"content";i:1;s:7:"summary";i:2;s:4:"info";i:3;s:5:"title";i:4;s:7:"tagline";i:5;s:9:"copyright";}s:16:"_KNOWN_ENCODINGS";a:3:{i:0;s:5:"UTF-8";i:1;s:8:"US-ASCII";i:2;s:10:"ISO-8859-1";}s:5:"stack";a:0:{}s:9:"inchannel";b:0;s:6:"initem";b:0;s:9:"incontent";b:0;s:11:"intextinput";b:0;s:7:"inimage";b:0;s:17:"current_namespace";b:0;s:13:"last_modified";s:31:"Wed, 20 Dec 2006 21:14:26 GMT
";s:4:"etag";s:36:""bfe70a0666788ceb49c3e76e52f4bd58"
";} administration/cache/index.htm 0000644 0023433 0004734 00000000337 11051631427 016342 0 ustar xemion psacln
Untitled
administration/category.php 0000644 0023433 0004734 00000016604 11051631431 016003 0 ustar xemion psacln assign('body','notallowed.tpl');
$class_tpl->displayTemplate();
die;
}
//they have selected to delete the image
if ((isset($_GET['catimage'])) && ($_GET['catimage'] != ""))
{
$listingid=(int)$_GET['catimage'];
if($Categories->removeCatImage($listingid))
{
//sucessfull
$class_tpl->assign('success',TRUE);
}
else
{
//not successfull
$class_tpl->assign('success',FALSE);
}
}
// they have selected delete
if(isset($_POST["action"]) && $_POST["action"] == "delete" && isset($_POST["id"]))
{
$id=(int)trim(@$_POST['id']);
$newid=(int)trim(@$_POST['parent_id']);
$sSQL = "UPDATE ".PREFIX."listings SET section=".$newid." WHERE section=".$id;
$db->query($sSQL);
$sSQL = "DELETE FROM ".PREFIX."categories WHERE id=".$id." LIMIT 1";
$db->query($sSQL);
if(!$db->isError())
{
//sucessfull
$Categories->removeCatImage($id);
$location="category.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//not successfull
$location="category.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
// they have selected delete
elseif(isset($_REQUEST["action"]) && $_REQUEST["action"] == "deletecat" && isset($_REQUEST["id"]))
{
$id=(int)trim(@$_REQUEST['id']);
$tree=$Categories->getAdminCatTree("", 0);
$class_tpl->assign("getcats", $tree);
$class_tpl->assign('action','delete');
$class_tpl->assign('id', $id);
$class_tpl->assign('body','category/category_delete.tpl');
}
// they have selected modify
elseif(isset($_POST["action"]) && $_POST["action"] == "modifycat" && isset($_POST["id"]))
{
$id=(int)trim(@$_POST['id']);
if(isset($_GET['upload']) && @$_FILES['image']['name']<>"")
{
//first remove the original
$Categories->removeCatImage($id);
//now upload the new
#$DMX_debug = true; //uncomment for debugging
$ppu = new pureFileUpload();
$ppu->path = "../catimages";
$ppu->extensions = "GIF,JPG,JPEG,BMP,PNG";
$ppu->formName = "mainform";
$ppu->storeType = "file";
$ppu->sizeLimit = "";
$ppu->nameConflict = "uniq";
$ppu->requireUpload = "false";
$ppu->minWidth = "";
$ppu->minHeight = "";
$ppu->maxWidth = "400";
$ppu->maxHeight = "";
$ppu->saveWidth = "";
$ppu->saveHeight = "";
$ppu->timeout = "600";
$ppu->progressBar = "";
$ppu->progressWidth = "300";
$ppu->progressHeight = "100";
$ppu->checkVersion("2.1.2");
$ppu->doUpload();
}
if(@$_POST['image']=="")
{
$sSQL="SELECT image FROM ".PREFIX."categories WHERE id=".$id;
$result=$db->query($sSQL);
$rs=$result->fetch();
$image=$rs['image'];
}
else
{
$image=$_POST['image'];
}
$data['id']=$_POST['id'];
$data['parent_id']=$_POST['parent_id'];
$data['name']=$_POST['name'];
$data['slug']=$_POST['slug'];
$data['description']=$_POST['description'];
$data['image']=$_POST['image'];
$data['allowads']=$_POST['allowads'];
$data['display']=$_POST['display'];
$data['cKeywords']=$_POST['cKeywords'];
$data['cLink']=$_POST['cLink'];
$data['cOrder']=$_POST['cOrder'];
$data['cPromo']=$_POST['cPromo'];
$data['image']=$image;
if($Categories->editCategory($data))
{
//sucessfull
$location="category.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//not successfull
$location="category.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
// they have selected add page
elseif(isset($_POST["action"]) && $_POST["action"] == "addcat")
{
if(isset($_GET['upload']) && @$_FILES['image']['name']<>"")
{
//now upload the new
#$DMX_debug = true; //uncomment for debugging
$ppu = new pureFileUpload();
$ppu->path = "../catimages";
$ppu->extensions = "GIF,JPG,JPEG,BMP,PNG";
$ppu->formName = "mainform";
$ppu->storeType = "file";
$ppu->sizeLimit = "";
$ppu->nameConflict = "uniq";
$ppu->requireUpload = "false";
$ppu->minWidth = "";
$ppu->minHeight = "";
$ppu->maxWidth = "400";
$ppu->maxHeight = "";
$ppu->saveWidth = "";
$ppu->saveHeight = "";
$ppu->timeout = "600";
$ppu->progressBar = "";
$ppu->progressWidth = "300";
$ppu->progressHeight = "100";
$ppu->checkVersion("2.1.2");
$ppu->doUpload();
}
$data['parent_id']=$_POST['parent_id'];
$data['name']=$_POST['name'];
$data['slug']=$_POST['slug'];
$data['description']=$_POST['description'];
$data['image']=$_POST['image'];
$data['allowads']=$_POST['allowads'];
$data['display']=$_POST['display'];
$data['cKeywords']=$_POST['cKeywords'];
$data['cLink']=$_POST['cLink'];
$data['cOrder']=$_POST['cOrder'];
$data['cPromo']=$_POST['cPromo'];
if($Categories->addCategory($data))
{
//sucessfull
$location="category.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//not successfull
$location="category.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
// they have selected to add new page
elseif(isset($_REQUEST["action"]) && $_REQUEST["action"] == "addnew")
{
$tree=$Categories->getAdminCatTree("", 0);
$class_tpl->assign("getcats", $tree);
$class_tpl->assign('action','addcat');
$class_tpl->assign('body','category/category_form.tpl');
}
// they have selected to modify a category
elseif(isset($_REQUEST["action"]) && $_REQUEST["action"] == "modify" && isset($_REQUEST["id"]))
{
$Categories->getCategoryById(@$_REQUEST['id']);
$class_tpl->assign('action','modifycat');
$tree=$Categories->getAdminCatTree("", 0);
$class_tpl->assign("getcats", $tree);
$class_tpl->assign('body','category/category_form.tpl');
}
// they have selected to duplicate a category
elseif(isset($_REQUEST["action"]) && $_REQUEST["action"] == "duplicate" && isset($_REQUEST["id"]))
{
$Categories->getCategoryById(@$_REQUEST['id']);
$class_tpl->assign('action','addcat');
$tree=$Categories->getAdminCatTree("", 0);
$class_tpl->assign("getcats", $tree);
$class_tpl->assign('body','category/category_form.tpl');
}
else
{
$tree=$Categories->getAdminCatTree("", 0, TRUE);
$class_tpl->assign("results", $tree);
$class_tpl->assign('body', 'category/category_browse.tpl');
}
$class_tpl->displayTemplate();
?> administration/coupons.php 0000644 0023433 0004734 00000015175 11051631432 015657 0 ustar xemion psacln assign('body','notallowed.tpl');
$class_tpl->displayTemplate();
die;
}
if(isset($_POST["act"]) && $_POST["act"] == "delete" && isset($_POST["id"]) && $_POST['id']<>"")
{
//delete the coupon
$id=(int)trim(@$_POST['id']);
$sSQL = sprintf("DELETE FROM ".PREFIX."coupon WHERE cID=%s LIMIT 1",$id);
$db->query($sSQL);
if(!$db->isError())
{
//sucessfull
$location="coupons.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//not successfull
$location="coupons.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
elseif(isset($_POST["act"]) && $_POST["act"] == "modifycoupon" && isset($_POST["id"]))
{
// they have selected modify
$group='';
$id=(int)trim(@$_POST['id']);
$groups=@$_POST['groups'];
$total = count($groups);
$i=1;
if(is_array($groups))
{
foreach($groups as $groubObj)
{
if($i==$total)
{
$group .= $groubObj;
}
else
{
$group .= $groubObj.",";
}
$i++;
}
}
$sSQL = sprintf("UPDATE ".PREFIX."coupon SET cCoupon=%s, cName=%s, cNumber=%s, cEndDate=%s, cDiscount=%s, cType=%s, cNumAvailable=%s, cGroup=%s, cUserID=%s WHERE cID=%s",
GetSQLValueString($_POST['cCoupon'], "text"),
GetSQLValueString($_POST['cName'], "text"),
GetSQLValueString($_POST['cNumber'], "text"),
GetSQLValueString($_POST['cEndDate'], "text"),
GetSQLValueString($_POST['cDiscount'], "text"),
GetSQLValueString($_POST['cType'], "text"),
GetSQLValueString($_POST['cNumAvailable'], "text"),
GetSQLValueString($group, "text"),
GetSQLValueString($_POST['cUserID'], "int"),
GetSQLValueString($id, "int"));
$db->query($sSQL);
if(!$db->isError())
{
//sucessfull
$location="coupons.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//not successfull
$location="coupons.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
elseif(isset($_POST["act"]) && $_POST["act"] == "insertnew")
{
//insert a new coupon
$group='';
$groups=@$_POST['groups'];
$total = count($groups);
$i=1;
if(is_array($groups))
{
foreach($groups as $groubObj)
{
if($i==$total)
{
$group .= $groubObj;
}else
{
$group .= $groubObj.",";
}
$i++;
}
}
$sSQL = sprintf("INSERT INTO ".PREFIX."coupon (cName,cCoupon,cNumber,cEndDate,cDiscount,cType,cNumAvailable,cGroup,cUserID) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s)",
GetSQLValueString($_POST['cName'], "text"),
GetSQLValueString($_POST['cCoupon'], "text"),
GetSQLValueString($_POST['cNumber'], "text"),
GetSQLValueString($_POST['cEndDate'], "text"),
GetSQLValueString($_POST['cDiscount'], "text"),
GetSQLValueString($_POST['cType'], "text"),
GetSQLValueString($_POST['cNumAvailable'], "text"),
GetSQLValueString($group, "text"),
GetSQLValueString($_POST['cUserID'], "int"));
$db->query($sSQL);
if(!$db->isError())
{
//sucessfull
$location="coupons.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//not successfull
$location="coupons.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
elseif(isset($_REQUEST["act"]) && $_REQUEST["act"] == "modify" && isset($_REQUEST["id"]))
{
//show the modify page
$id=(int)trim(@$_REQUEST['id']);
$sSQL=sprintf("SELECT cID,cCoupon,cName,cNumber,cEndDate,cDiscount,cType,cNumAvailable,cGroup,cUserID FROM ".PREFIX."coupon WHERE cID=%s", $id);
$result=$db->query($sSQL);
$rs=$result->fetch();
$cGroup=explode(",", $rs['cGroup']);
$class_tpl->assign('act', 'modifycoupon');
$class_tpl->assign('cID', $rs['cID']);
$class_tpl->assign('cCoupon', $rs['cCoupon']);
$class_tpl->assign('cName', $rs['cName']);
$class_tpl->assign('cNumber', $rs['cNumber']);
$class_tpl->assign('cEndDate', $rs['cEndDate']);
$class_tpl->assign('cDiscount', $rs['cDiscount']);
$class_tpl->assign('cType', $rs['cType']);
$class_tpl->assign('cNumAvailable', $rs['cNumAvailable']);
$class_tpl->assign('cUserID', $rs['cUserID']);
//now the user groups
$sSQL="SELECT uGroupID, uTitle FROM ".PREFIX."user_groups ORDER BY uGroupID";
$result=$db->query($sSQL);
$getgroups=array();
while($rs=$result->fetch())
{
if(in_array($rs['uGroupID'], $cGroup))
{
$rs['selected']="Y";
}
$rs['uTitle']=safeStripSlashes($rs['uTitle']);
$getgroups[]=$rs;
}
$class_tpl->assign('getgroups', $getgroups);
$Users->getAllUsersForSelect();
$class_tpl->assign('body','coupons/couponsform.tpl');
}
elseif(isset($_REQUEST["act"]) && $_REQUEST["act"] == "addnew")
{
//show the coupon form so they can add a new one
$class_tpl->assign('act','insertnew');
//now the user groups
$sSQL="SELECT uGroupID, uTitle FROM ".PREFIX."user_groups ORDER BY uGroupID DESC";
$result=$db->query($sSQL);
$getgroups=array();
while($rs=$result->fetch())
{
$rs['uTitle']=safeStripSlashes($rs['uTitle']);
$getgroups[]=$rs;
}
$class_tpl->assign('getgroups', $getgroups);
$Users->getAllUsersForSelect();
$class_tpl->assign('body','coupons/couponsform.tpl');
}
else
{
// final else show all the coupons
$sSQL="SELECT cID,cCoupon,cName,cNumber,cEndDate,cDiscount,cType,cNumAvailable FROM ".PREFIX."coupon ORDER BY cEndDate DESC";
$result=$db->query($sSQL);
$results = array();
$i=0;
while($rs=$result->fetch())
{
$results[] = $rs;
}
$class_tpl->assign('results', $results);
$class_tpl->assign('body','coupons/coupons.tpl');
}
$class_tpl->displayTemplate();
?> administration/csv.php 0000644 0023433 0004734 00000002540 11051631433 014755 0 ustar xemion psacln addFormat();
$format_title->setBold();
$format_title->setColor('black');
$format_title->setPattern(2);
$format_title->setFgColor('silver');
// let's merge
$format_title->setAlign('merge');
// Creating a worksheet
$worksheet =& $workbook->addWorksheet('Classified Users');
//now the headings
$list=$Users->getAllUsers($options, $current_row, TRUE);
$i=0;
foreach ($list['list'][0] as $key => $value) {
//echo $key." ";
$worksheet->write(0, $i, ucwords($key), $format_title);
$i++;
}
//now the users
$i=1;
$next=0;
foreach ($list['list'] as $v1) {
foreach ($v1 as $key => $value) {
//echo "$key $value\n";
$worksheet->write($i, $next, $value);
$next++;
}
$next=0;
$i++;
}
$workbook->send('users.xls');
// Let's send the file
$workbook->close();
?> administration/documentation/ 0000755 0023433 0004734 00000000000 11036006043 016315 5 ustar xemion psacln administration/documentation/english.php 0000644 0023433 0004734 00000011546 11051631434 020473 0 ustar xemion psacln The min is the minimum number to start with. The max is the maximum number. The step is how much the numbers increment by.
So for example min 100 max 5000 step 1000 would cause the boxes to start at 100 and increment by 1000 until it reached 5000.");
define("DOC_SUB_ID", "The sub id field is used to enter the field id of the child option.");
define("DOC_VALID_EXTENSIONS", "Please enter the valid file extensions seperated by a comma. For example doc,pdf,txt.");
//Bad Words //
define("DOC_BAD_WORDS", "Whatever term you enter will be replaced by the replacement entered. The case does not matter but if you enter cat with the replacement of dog, then catalyst will become dogalyst.");
//Listing Packages //
define("DOC_LIST_PRICE", "This only appears so you can say the package is normally priced higher than it currently is.");
define("DOC_EXTERNAL_URL", "This allows the user to enter a url to their website.");
define("DOC_INTERNAL_NAME", "This is a title that is only displayed through the administration. This is helpful in distinguishing between two packages that are similar.");
//Memberships //
define("DOC_MEMBERSHIP_GROUP", "Once someone purchases a membership they will become a member of this usergroup while their membership is active.");
define("DOC_MEMBERSHIP_NUMBER", "Please enter the number of ads included with this membership.");
define("DOC_MEMBERSHIP_FEATURED", "Please enter the number of featured ads that are included with this membership.");
define("DOC_MEMBERSHIP_BOLD", "Please enter the number of bold ads that are included with this membership.");
define("DOC_MEMBERSHIP_HIGHLIGHTED", "Please enter the number of highlighted ads that are included with this membership.");
//Modules //
define("DOC_MODULES_GETMORE", "Get More Modules");
define("DOC_MODULES_GETMORE_TXT", "You can find additional modules for your site in the 68 Classifieds Extensions Pages. To install a plugin, you generally just need to upload the module files into your modules/ directory. Once a module is uploaded, you would click regenerate at the top of this page.");
?>
administration/documentation/french.php 0000644 0023433 0004734 00000011100 11051631435 020272 0 ustar xemion psacln The min is the minimum number to start width. The max is the maximum number. The step is how much the numbers increment by.
administration/templates/default/emails/ 0000755 0023433 0004734 00000000000 11036006413 020341 5 ustar xemion psacln administration/templates/default/emails/html/ 0000755 0023433 0004734 00000000000 11036006407 021310 5 ustar xemion psacln administration/templates/default/emails/html/newlisting.tpl.php 0000644 0023433 0004734 00000000746 11051631547 025017 0 ustar xemion psacln {*
This is the body of the email a friend email template.
You can edit the template below and if you wish to edit the
subject that is found in the language file.
*}
A new listing has been added to your classifieds website.
administration/templates/default/emails/text/ 0000755 0023433 0004734 00000000000 11036006417 021331 5 ustar xemion psacln administration/templates/default/emails/text/newlisting.tpl.php 0000644 0023433 0004734 00000000523 11051631552 025024 0 ustar xemion psacln {*
This is the body of the newlisting email template.
You can edit the template below and if you wish to edit the
subject that is found in the language file.
*}
{textformat wrap=40}
A new listing has been added to your classifieds website.
Title: {$title}
Price: {$price}
{$smarty.const.URL}/viewlisting.php?view={$id}
{/textformat}
administration/templates/default/fields/ 0000755 0023433 0004734 00000000000 11036006440 020335 5 ustar xemion psacln administration/templates/default/fields/fields.tpl 0000644 0023433 0004734 00000010634 11051631555 022340 0 ustar xemion psacln
{literal}
{/literal}
administration/templates/default/fields/fieldsform.tpl 0000644 0023433 0004734 00000020367 11051631556 023231 0 ustar xemion psacln {literal}
{/literal}
administration/usergroups.php 0000644 0023433 0004734 00000023472 11051631712 016407 0 ustar xemion psacln assign('body','notallowed.tpl');
$class_tpl->displayTemplate();
die;
}
// they have selected delete
if(isset($_POST["action"]) && $_POST["action"] == "delete" && isset($_POST["groupID"]))
{
$groupID=(int)trim(@$_POST['groupID']);
$sSQL = "DELETE FROM ".PREFIX."user_groups WHERE uGroupID=".$groupID." LIMIT 1";
$db->query($sSQL);
if(!$db->isError())
{
$sSQL="UPDATE ".PREFIX."users SET level=2 WHERE level=".$groupID;
$db->query($sSQL);
//sucessfull
$location="usergroups.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//not successfull
$location="usergroups.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
// they have selected modify
elseif(isset($_POST["action"]) && $_POST["action"] == "modifygroup" && isset($_POST["groupID"]))
{
$groupID=(int)trim(@$_POST['groupID']);
$sSQL = sprintf("UPDATE ".PREFIX."user_groups SET uTitle=%s,uDescription=%s,uBanned=%s,uAllowContact=%s,uAllowEmailFriend=%s,uViewSite=%s,uViewPhotos=%s,uViewPrice=%s,uViewSeller=%s,uViewAddress=%s,uViewCity=%s,uViewState=%s,uViewCountry=%s,uViewDateAdded=%s,uViewExpiration=%s,uViewHits=%s,uViewFavorites=%s,sDisPhoto=%s,sDisTitle=%s,sDisPrice=%s,sDisDateAdded=%s,sDisExpiration=%s,sDisCity=%s,sDisState=%s,sDisCountry=%s,uViewPhone=%s WHERE uGroupID=%s",
GetSQLValueString($_POST['uTitle'], "text"),
GetSQLValueString($_POST['uDescription'], "text"),
GetSQLValueString($_POST['uBanned'], "text"),
GetSQLValueString($_POST['uAllowContact'], "text"),
GetSQLValueString($_POST['uAllowEmailFriend'], "text"),
GetSQLValueString($_POST['uViewSite'], "text"),
GetSQLValueString($_POST['uViewPhotos'], "text"),
GetSQLValueString($_POST['uViewPrice'], "text"),
GetSQLValueString($_POST['uViewSeller'], "text"),
GetSQLValueString($_POST['uViewAddress'], "text"),
GetSQLValueString($_POST['uViewCity'], "text"),
GetSQLValueString($_POST['uViewState'], "text"),
GetSQLValueString($_POST['uViewCountry'], "text"),
GetSQLValueString($_POST['uViewDateAdded'], "text"),
GetSQLValueString($_POST['uViewExpiration'], "text"),
GetSQLValueString($_POST['uViewHits'], "text"),
GetSQLValueString($_POST['uViewFavorites'], "text"),
GetSQLValueString($_POST['sDisPhoto'], "text"),
GetSQLValueString($_POST['sDisTitle'], "text"),
GetSQLValueString($_POST['sDisPrice'], "text"),
GetSQLValueString($_POST['sDisDateAdded'], "text"),
GetSQLValueString($_POST['sDisExpiration'], "text"),
GetSQLValueString($_POST['sDisCity'], "text"),
GetSQLValueString($_POST['sDisState'], "text"),
GetSQLValueString($_POST['sDisCountry'], "text"),
GetSQLValueString($_POST['uViewPhone'], "text"),
GetSQLValueString($groupID, "int"));
$db->query($sSQL);
if(!$db->isError())
{
//sucessfull
$location="usergroups.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//not successfull
$location="usergroups.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
// they have selected add page
elseif(isset($_POST["action"]) && $_POST["action"] == "addgroup")
{
$sSQL = sprintf("INSERT INTO ".PREFIX."user_groups (uTitle,uDescription,uBanned,uAllowContact,uAllowEmailFriend,uViewSite,uViewPhotos,uViewPrice,uViewSeller,uViewAddress,uViewCity,uViewState,uViewCountry,uViewDateAdded,uViewExpiration,uViewHits,uViewFavorites,sDisPhoto,sDisTitle,sDisPrice,sDisDateAdded,sDisExpiration,sDisCity,sDisState,sDisCountry,uViewPhone) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",
GetSQLValueString($_POST['uTitle'], "text"),
GetSQLValueString($_POST['uDescription'], "text"),
GetSQLValueString($_POST['uBanned'], "text"),
GetSQLValueString($_POST['uAllowContact'], "text"),
GetSQLValueString($_POST['uAllowEmailFriend'], "text"),
GetSQLValueString($_POST['uViewSite'], "text"),
GetSQLValueString($_POST['uViewPhotos'], "text"),
GetSQLValueString($_POST['uViewPrice'], "text"),
GetSQLValueString($_POST['uViewSeller'], "text"),
GetSQLValueString($_POST['uViewAddress'], "text"),
GetSQLValueString($_POST['uViewCity'], "text"),
GetSQLValueString($_POST['uViewState'], "text"),
GetSQLValueString($_POST['uViewCountry'], "text"),
GetSQLValueString($_POST['uViewDateAdded'], "text"),
GetSQLValueString($_POST['uViewExpiration'], "text"),
GetSQLValueString($_POST['uViewHits'], "text"),
GetSQLValueString($_POST['uViewFavorites'], "text"),
GetSQLValueString($_POST['sDisPhoto'], "text"),
GetSQLValueString($_POST['sDisTitle'], "text"),
GetSQLValueString($_POST['sDisPrice'], "text"),
GetSQLValueString($_POST['sDisDateAdded'], "text"),
GetSQLValueString($_POST['sDisExpiration'], "text"),
GetSQLValueString($_POST['sDisCity'], "text"),
GetSQLValueString($_POST['sDisState'], "text"),
GetSQLValueString($_POST['sDisCountry'], "text"),
GetSQLValueString($_POST['uViewPhone'], "text"));
$db->query($sSQL);
if(!$db->isError())
{
//sucessfull
$location="usergroups.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//not successfull
$location="usergroups.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
// they have selected to add new page
elseif(isset($_POST["action"]) && $_POST["action"] == "addnew")
{
$class_tpl->assign('action','addgroup');
$class_tpl->assign('body','usergroups/usergroupsform.tpl');
}
// they have selected to modify a page
elseif(isset($_POST["action"]) && $_POST["action"] == "modify" && isset($_POST["groupID"]))
{
$groupID=(int)trim(@$_POST['groupID']);
$sSQL="SELECT uTitle,uDescription,uBanned,uAllowContact,uAllowEmailFriend,uViewSite,uViewPhotos,uViewPrice,uViewSeller,uViewAddress,uViewCity,uViewState,uViewCountry,uViewDateAdded,uViewExpiration,uViewHits,uViewFavorites,sDisPhoto,sDisTitle,sDisPrice,sDisDateAdded,sDisExpiration,sDisCity,sDisState,sDisCountry,uViewPhone FROM ".PREFIX."user_groups WHERE uGroupID=".$groupID;
$result=$db->query($sSQL);
$rs=$result->fetch();
$class_tpl->assign('action','modifygroup');
$class_tpl->assign('uGroupID',$groupID);
$class_tpl->assign('uTitle',safeStripSlashes($rs['uTitle']));
$class_tpl->assign('uDescription',safeStripSlashes($rs['uDescription']));
$class_tpl->assign('uBanned',$rs['uBanned']);
$class_tpl->assign('uAllowContact',$rs['uAllowContact']);
$class_tpl->assign('uAllowEmailFriend',$rs['uAllowEmailFriend']);
$class_tpl->assign('uViewSite',$rs['uViewSite']);
$class_tpl->assign('uViewPhotos',$rs['uViewPhotos']);
$class_tpl->assign('uViewPrice',$rs['uViewPrice']);
$class_tpl->assign('uViewSeller', $rs['uViewSeller']);
$class_tpl->assign('uViewAddress',$rs['uViewAddress']);
$class_tpl->assign('uViewCity',$rs['uViewCity']);
$class_tpl->assign('uViewState',$rs['uViewState']);
$class_tpl->assign('uViewPhone', $rs['uViewPhone']);
$class_tpl->assign('uViewCountry',$rs['uViewCountry']);
$class_tpl->assign('uViewDateAdded',$rs['uViewDateAdded']);
$class_tpl->assign('uViewExpiration',$rs['uViewExpiration']);
$class_tpl->assign('uViewHits',$rs['uViewHits']);
$class_tpl->assign('uViewFavorites',$rs['uViewFavorites']);
$class_tpl->assign('sDisPhoto',$rs['sDisPhoto']);
$class_tpl->assign('sDisTitle',$rs['sDisTitle']);
$class_tpl->assign('sDisPrice',$rs['sDisPrice']);
$class_tpl->assign('sDisDateAdded',$rs['sDisDateAdded']);
$class_tpl->assign('sDisExpiration',$rs['sDisExpiration']);
$class_tpl->assign('sDisCity',$rs['sDisCity']);
$class_tpl->assign('sDisState',$rs['sDisState']);
$class_tpl->assign('sDisCountry',$rs['sDisCountry']);
$class_tpl->assign('body','usergroups/usergroupsform.tpl');
}
// final else show all the pages
else
{
$sSQL="SELECT uGroupID,uTitle,uDescription FROM ".PREFIX."user_groups ORDER BY uGroupID";
$result=$db->query($sSQL);
$data=array();
while($rs=$result->fetch())
{
$rs['uTitle']=safeStripSlashes($rs['uTitle']);
$sSQL="SELECT COUNT(*) AS total FROM ".PREFIX."users WHERE level=".$rs['uGroupID'];
$result2=$db->query($sSQL);
$rs2=$result2->fetch();
$rs['total']=$rs2['total'];
$data[]=$rs;
}
$class_tpl->assign('results', $data);
$class_tpl->assign('body','usergroups/usergroups.tpl');
}
$class_tpl->displayTemplate();
?>
administration/users.php 0000644 0023433 0004734 00000017306 11051631713 015332 0 ustar xemion psacln assign('body','notallowed.tpl');
$class_tpl->displayTemplate();
die;
}
// they have selected to change the status
if(isset($_POST['act']) && $_POST['act'] == "changestatus")
{
$newstatus=$_POST["newstatus"];
foreach($_POST['userid'] AS $key)
{
if($newstatus=='Ban')
{
$Users->banUser($key);
}
elseif($newstatus=='Delete')
{
$Users->deleteUser($key);
}
}
}
if(isset($_POST['action']) && $_POST['action']=="add")
{
//the form has been submitted so lets validate it and update the info
$modules->call_hook('admin_users_add', ''); // Call any module functions
$password=trim(@$_POST['password']);
$passwordconfirm=trim($_POST['passwordconfirm']);
// Build an array from the submitted form values
$submitVars=array (
'username'=>trim($_POST['username']),
'password'=>trim($_POST['password']),
'email'=>trim($_POST['email']),
'firstname'=>trim($_POST['firstname']),
'lastname'=>trim($_POST['lastname']),
'address'=>trim($_POST['address']),
'city'=>trim($_POST['city']),
'state'=>trim(@$_POST['state']),
'zip'=>trim(@$_POST['zip']),
'country'=>trim(@$_POST['country']),
'email'=>trim($_POST['email']),
'phone'=>trim($_POST['phone']),
'b_same'=>trim($_POST['b_same']),
'b_firstname'=>trim($_POST['b_firstname']),
'b_lastname'=>trim($_POST['b_lastname']),
'b_address'=>trim($_POST['b_address']),
'b_city'=>trim($_POST['b_city']),
'b_state'=>trim(@$_POST['b_state']),
'b_zip'=>trim(@$_POST['b_zip']),
'b_country'=>trim(@$_POST['b_country']),
'b_phone'=>trim($_POST['b_phone']),
'newsletter'=>trim(@$_POST['newsletter']),
'extra'=>trim(@$_POST['extra']),
'extra2'=>trim(@$_POST['extra2']),
'extra3'=>trim(@$_POST['extra3']),
'level'=>trim(@$_POST['level']),
'adminCapabilities'=>$_POST['adminCapabilities']
);
$location="users.php";
$class_tpl->assign('forward',FALSE);
switch($Register->createSignup($submitVars))
{
case 4:
$title=LANG_FORWARD_ERROR;
$msg=LANG_USER_BLACKLISTED;
break;
case 3:
$title=LANG_FORWARD_ERROR;
$msg=LANG_ALREADY_REGISTERED;
break;
case 1:
$title=LANG_FORWARD_SUCESS;
$class_tpl->assign('forward',TRUE);
break;
default:
$title=LANG_FORWARD_ERROR;
}
$class_tpl->assign('title',$title);
$class_tpl->assign('location',$location);
$class_tpl->assign('msg', $msg);
$class_tpl->assign('body','forward.tpl');
}
elseif(isset($_POST['action']) && $_POST['action']=="modify" && @$_POST['member']<>"")
{
//the form has been submitted so lets validate it and update the info
$modules->call_hook('admin_users_modify', ''); // Call any module functions
$password=trim(@$_POST['password']);
$passwordconfirm=trim($_POST['passwordconfirm']);
// Build an array from the submitted form values
$submitVars=array (
'username'=>trim($_POST['username']),
'password'=>trim($_POST['password']),
'email'=>trim($_POST['email']),
'firstname'=>trim($_POST['firstname']),
'lastname'=>trim($_POST['lastname']),
'address'=>trim($_POST['address']),
'city'=>trim($_POST['city']),
'state'=>trim(@$_POST['state']),
'zip'=>trim(@$_POST['zip']),
'country'=>trim(@$_POST['country']),
'email'=>trim($_POST['email']),
'phone'=>trim($_POST['phone']),
'b_same'=>trim($_POST['b_same']),
'b_firstname'=>trim($_POST['b_firstname']),
'b_lastname'=>trim($_POST['b_lastname']),
'b_address'=>trim($_POST['b_address']),
'b_city'=>trim($_POST['b_city']),
'b_state'=>trim(@$_POST['b_state']),
'b_zip'=>trim(@$_POST['b_zip']),
'b_country'=>trim(@$_POST['b_country']),
'b_phone'=>trim($_POST['b_phone']),
'newsletter'=>trim(@$_POST['newsletter']),
'extra'=>trim(@$_POST['extra']),
'extra2'=>trim(@$_POST['extra2']),
'extra3'=>trim(@$_POST['extra3']),
'level'=>trim(@$_POST['level']),
'id'=>(int)$_POST['member'],
'notes'=>trim(@$_POST['notes']),
'adminCapabilities'=>$_POST['adminCapabilities']
);
if($Register->modifySignup($submitVars))
{
//sucess
$location="users.php?view=".(int)$_POST['member'];
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//no sucess
$location="users.php?uid=".$member;
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
elseif(isset($_GET['view']))
{
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = (int)$_GET['page'];
}
$Users->getUser($_GET['view']);
$options = array('owner' => $_GET['view']);
$list=$Listings->getAllListings($options, $pageNum, 9999);
$class_tpl->assign('results', $list["list"]);
$class_tpl->assign('userlevels', $Users->getUserGroupsList());
$class_tpl->assign('showstates', $Users->getStates());
$class_tpl->assign('showcountries', $Users->getCountries());
$class_tpl->assign('numberoflistings', $Users->getNumberOfListingsByUserID($_GET['view']));
$Register->createJavascriptValidation();
$class_tpl->assign('body', 'users/users_info.tpl');
$modules->call_hook('admin_users_view', ''); // Call any module functions
}
elseif(isset($_GET['action']) && $_GET['action']=="add")
{
$class_tpl->assign('userlevels', $Users->getUserGroupsList());
$class_tpl->assign('showstates', $Users->getStates());
$class_tpl->assign('showcountries', $Users->getCountries());
$Register->createJavascriptValidation();
$class_tpl->assign('body', 'users/users_add.tpl');
}
elseif(isset($_GET['action']) && $_GET['action']=="csv")
{
$pageNum = 1;
$list=$Users->getAllUsers($options, $pageNum, TRUE);
}
else
{
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = (int)$_GET['page'];
}
//$options = array('l_UID' => 1);
$options = '';
$list=$Users->getAllUsers($options, $pageNum);
$class_tpl->assign('results', $list["list"]);
$class_tpl->assign('sqlsort', $list["info"]["sqlsort"]);
$class_tpl->assign('sortorder', $list["info"]["sortorder"]);
$class_tpl->assign('oppositesort', $list["info"]["oppositesort"]);
$sSQL="SELECT uGroupID,uTitle FROM ".PREFIX."user_groups ORDER BY uGroupID";
$result=$db->query($sSQL);
$data=array();
while($rs=$result->fetch())
{
$rs['uTitle']=safeStripSlashes($rs['uTitle']);
switch($rs['uGroupID'])
{
case "1":
$rs['image']='flag_blue.png';
break;
case "2":
$rs['image']='flag_green.png';
break;
case 3:
$rs['image']='flag_orange.png';
break;
case 4:
$rs['image']='flag_red.png';
break;
case 5:
$rs['image']='flag_yellow.png';
break;
default:
$rs['image']='flag_purple.png';
}
$data[]=$rs;
}
$class_tpl->assign('group', $data);
$class_tpl->assign('body', 'users/users_browse.tpl');
}
$class_tpl->displayTemplate();
?>
administration/bulk_listings.php 0000644 0023433 0004734 00000023072 11244314662 017044 0 ustar xemion psacln query($sSQL);
while ($cat = $result->fetch()) {
$test = $db->query("select * from dirlistings where section = $cat[id] and owner = 25820");
$test2 = $test->fetch();
if (!$test2) {
echo "$cat[name] $cat[id] ";
}
}
exit;
*/
$sSQL = "select * from dirlistings where owner = 19751 and expiration = '2008-09-04 00:00:00'";
$result = $db->query($sSQL);
$cats = array();
while ($cat = $result->fetch()) {
$cats[] = $cat["section"];
}
//$cats = "Contractor Website Design";
//$cats = "Wyoming";
$cats = explode("\n", $cats);
//$real_name = explode(\"n", $catS);
/*
foreach ($cats as $id => $cat_name) {
$cat_name = trim($cat_name);
if ($cat_name) {
*/
//everything but international
/*
$result = $db->query("select * from dirlistings where id = 26980");
while($cat = $result->fetch()) {
var_dump($cat);
}
exit;
*/
// $sSQL = "select * from dircategories where parent_id = 735 or parent_id = 822 or parent_id = 818"; // id = $cat_name";
$sSQL = "select * from dircategories where id = 794
";
$result=$db->query($sSQL);
while($cat = $result->fetch()) {
// echo $sSQL . "\n";
//echo $cat["name"] . " ! " . $cat["parent_id"] . " ";
//$sSQL = "SELECT p.cFeaturedPrice FROM dirproducts_packages as p, dirproducts_packages_lookup as pl where pl.cID = p.pID AND pl.cCategoryID = " . $cat["id"];
// $result = $db->query($sSQL);
// $product = $result->fetch();
// $price += $product["cFeaturedPrice"];
//echo $cat["name"] . "\t" . $product["cFeaturedPrice"] . " ";
$order['userid']=27851;
$existing = $db->query("select * from dirlistings where section = $cat[id] and owner = $order[userid]");
$existing = $existing->fetch($existing);
// echo "select * from dirlistings where section = $cat[id] and owner = $order[userid] ";
// var_dump($existing);
if (!$existing) {
$order['oProductID']=25;
$order['oProduct']="Directory Listing";
$order['oType']=1;
$order['oTotal']=0;
$order['oSubTotal']=0;
$order['oBold']='N';
$order['oHighlighted']='N';
$order['oFeatured']='Y';
$order['oStatus']=1;
$order['oAddInfo']='Manually added by Xemion';
// var_dump($order);
$orderid=$Orders->generateOrder($order);
$data['owner']=$order['userid'];
//if ($cat["parent_id"] != 822 && $cat["parent_id"] != 818 && $cat["parent_id"] != 819) {
// $data['title']= $cat["name"] . " Web Design from Gravitate Design Studio";
//} else {
// $data['title']= $cat["name"] . " from Gravitate Design Studio";
//}
$data['title'] = "Build your own website with Website Builder 360!";
$data['price']=0;
$data['url']="http://www.WebsiteBuilder360.com";
$data['display']="Y";
$data['section']=$cat["id"];
$data['shortDescription']="";
$data['featured'] = "Y";
$data['pHighlighted']='N';
$data['description']="Website Builder 360 makes it easy for anyone to quickly create a professional and highly-functional website. All packages include e-commerce, video, photo galleries, member-only pages, contact forms and more. Sign up today for an instant free trial!";
$time=strftime("%H:%M:%S");
$expiration="2020-10-04"." ". $time;
$data['expiration']=$expiration;
$data['orderID']=$orderid;
//$_POST["opt1"] = "Anywhere";
//$_POST["opt2"] = "866.822.4335";
// var_dump($data);
echo "\n\n\n";
$listingid=$Listings->addListing($data);
echo $cat["name"] . " : " . $listingid . " ";
$sSQL = "insert into dirprodimages (pid, image) VALUES ($listingid, 'websitebuilder360.gif')";
$db->query($sSQL);
}
}
/*
}
}
*/
//echo $price;
?>
administration/bulk_pricing.php 0000644 0023433 0004734 00000017346 11450166712 016652 0 ustar xemion psacln query($sSQL);
while ($cat = $result->fetch()) {
$test = $db->query("select * from dirlistings where section = $cat[id] and owner = 25820");
$test2 = $test->fetch();
if (!$test2) {
echo "$cat[name] $cat[id] ";
}
}
exit;
*/
$sSQL = "select * from dirlistings where owner = 19751 and display='Y' and date(expiration) = '2010-10-04'";
$result = $db->query($sSQL);
$cats = array();
while ($cat = $result->fetch()) {
$sSQL = "SELECT cFeaturedPrice, c.name FROM dirproducts_packages as p, dirproducts_packages_lookup as pl, dircategories as c where pl.cID = p.pID AND pl.cCategoryID = $cat[section] and c.id = $cat[section]";
$result2 = $db->query($sSQL);
$product = $result2->fetch();
$price += $product["cFeaturedPrice"];
echo $product["name"] . "\t" . $product["cFeaturedPrice"] . "\n";
}
echo $price;
exit;
//$cats = "Contractor Website Design";
//$cats = "Wyoming";
//$cats = explode("\n", $cats);
//$real_name = explode(\"n", $catS);
/*foreach ($cats as $id => $cat_name) {
$cat_name = trim($cat_name);
if ($cat_name) {*/
$sSQL = "select * from dircategories where parent_id = 740";
$result=$db->query($sSQL);
while($cat = $result->fetch()) {
//echo $sSQL . " ";
//echo $cat["name"] . " ! " . $cat["parent_id"] . " ";
$sSQL = "SELECT * FROM dirproducts_packages as p, dirproducts_packages_lookup as pl where pl.cID = p.pID AND pl.cCategoryID = " . $cat["id"];
$result2 = $db->query($sSQL);
$product = $result2->fetch();
// var_dump($product);
$product["cFeaturedPrice"] = $cat["price"];
$price += $product["cFeaturedPrice"];
echo $cat["name"] . "\t" . $product["cFeaturedPrice"] . "\n";
}
/*
}
}*/
//echo $price;
?>
advertise.php 0000644 0023433 0004734 00000001037 11321003647 013123 0 ustar xemion psacln query($sSQL);
$category=$result->fetch();
$class_tpl->assign("category", $category);
$class_tpl->assign('body','advertise.tpl');
$class_tpl->display('layout.tpl',$page);
?> ajax.php 0000644 0023433 0004734 00000025670 11036011254 012065 0 ustar xemion psacln register('removeFavorite');
$cp->register('saveFavorite');
$cp->register('deleteUpload');
$cp->register('ajax_extra_search_fields');
$cp->register('extra_search_fields2');
$cp->register('extra_checkout_fields');
$cp->start();
$cp->return_data();
function removeFavorite($userid, $view)
{
global $db, $cp;
//first check//
$userid=(int)$userid;
$view = (int)$view;
$sSQL = sprintf("DELETE FROM ".PREFIX."favorites WHERE uID=%s AND pID=%s", $userid, $view);
$db->query($sSQL);
$output=LANG_FAV_REMOVED;
$cp->set_id("deleteResponse");
$cp->set_data();
$cp->set_data($output);
return;
}
function saveFavorite($userid, $view)
{
global $db, $cp;
//first check//
$userid=(int)$userid;
$view = (int)$view;
$sSQL = sprintf("SELECT pID FROM ".PREFIX."favorites WHERE uID=%s AND pID=%s", $userid, $view);
$result=$db->query($sSQL);
$rows=$result->size();
if($rows > 0)
{
//not sucessfull
$output=LANG_FAV_ALREADY_SAVED;
}
else
{
$sSQL = sprintf("INSERT INTO ".PREFIX."favorites SET uID=%s, pID=%s", $userid, $view);
$db->query($sSQL);
//sucessfull
$output=LANG_FAV_SAVED;
}
$cp->set_id("deleteResponse");
$cp->set_data();
$cp->set_data($output);
return;
}
function deleteUpload($id, $fid)
{
global $db, $cp;
$id=(int)$id;
$fid = (int)$fid;
$sSQL="SELECT sValue FROM ".PREFIX."products_fields WHERE pID=".$id." AND fID=".$fid;
$result=$db->query($sSQL);
$rs=$result->fetch();
@unlink(FILESYSTEM_PATH .'uploads/'.$rs['sValue']);
$sSQL="DELETE FROM ".PREFIX."products_fields WHERE pID=".$id." AND fID=".$fid;
$db->query($sSQL);
$cp->set_id("deleteResponse");
$cp->set_data();
return;
}
function ajax_extra_search_fields($type)
{
global $db, $cp;
$type=(int)$type;
$optdata='
';
//$sSQL = "SELECT fID, fOrder FROM `".PREFIX."fields`WHERE fSearch = 'Y' ORDER BY fOrder ASC";
$sSQL = "SELECT f.fID, f.fOrder FROM `".PREFIX."fields` AS f INNER JOIN ".PREFIX."fields_bindings AS fb ON fb.fieldID = f.fID AND fb.catID = ".$type." AND f.fSearch ='Y' ORDER BY fOrder ASC";
$test=$sSQL;
$result2 = $db->query($sSQL);
$rows=$result2->size();
if($rows>0)
{
while($rs2=$result2->fetch())
{
$sql="SELECT fID,fName,fDefault,fType,fRequired,fRange,fRangeValue FROM `".PREFIX."fields` WHERE fID='".$rs2['fID']."' ORDER BY fOrder ASC";
$result3 = $db->query($sql);
$row = $result3->fetch();
if($row['fType']=="D" || $row['fType']=="C")
{
if($row['fRange']=='Y')
{
if($row['fRangeValue']!="0|0|0")
{
$fRangeValue=explode("|", $row['fRangeValue']);
$optdata.="
";
$cp->set_id("response");
#$add_result_node =& $cp->add_node("add");
#$add_result_node->set_data($optdata);
$cp->set_data($optdata);
return;
}
function extra_search_fields2($type)
{
global $db, $cp;
$type=mysql_real_escape_string($type);
//$sSQL = "SELECT fID, fOrder FROM `".PREFIX."fields`WHERE fSearch = 'Y' ORDER BY fOrder ASC";
$sSQL = "SELECT optSub FROM `".PREFIX."fields_options`WHERE optValue='".$type."'";
$test=$sSQL;
$result2 = $db->query($sSQL);
$rows=$result2->size();
if($rows>0)
{
$optdata2='
';
while($rs2=$result2->fetch())
{
$sql="SELECT fID,fName,fDefault,fType,fRequired FROM `".PREFIX."fields` WHERE fID='".$rs2['optSub']."' ORDER BY fOrder ASC";
$test.=" ".$sql;
$result3 = $db->query($sql);
$row = $result3->fetch();
if($row['fType']=="Y")
{
//it is a child select list//
$optdata2.="
".$row['fName'].":
";
}
elseif($row['fType']=="S")
{
//single text field
$optdata2.="
".$row['fName'].":
\n";
}
}
$optdata2.="
";
}
$cp->set_id("optResponse");
#$add_result_node =& $cp->add_node("add");
#$add_result_node->set_data($optdata);
$cp->set_data($optdata2);
return;
}
function extra_checkout_fields($type)
{
global $db, $cp;
//$sSQL = "SELECT fID, fOrder FROM `".PREFIX."fields`WHERE fSearch = 'Y' ORDER BY fOrder ASC";
$sSQL = "SELECT optSub FROM `".PREFIX."fields_options`WHERE optValue='".mysql_real_escape_string($type)."'";
$test=$sSQL;
$result2 = $db->query($sSQL);
$rows=$result2->size();
if($rows>0)
{
$optdata2='
';
while($rs2=$result2->fetch())
{
$sql="SELECT fID,fName,fDefault,fType,fRequired FROM `".PREFIX."fields` WHERE fID='".$rs2['optSub']."' ORDER BY fOrder ASC";
$test.=" ".$sql;
$result3 = $db->query($sql);
$row = $result3->fetch();
if($row['fType']=="Y")
{
//it is a select list//
$optdata2.="
".LANG_STAR ." ".$row['fName'].":
";
}
elseif($row['fType']=="S")
{
//single text field
$optdata2.="
\n";
}
function uh_oh($title, $message, $info) {
echo "
$title
$message
$info
";
}
function auth() {
// We have a single-use token that must be upgraded to a session token.
$token = preg_replace( '/[^-_0-9a-zA-Z]/', '', $_GET['token'] );
$headers = array(
"GET /accounts/AuthSubSessionToken HTTP/1.0",
"Authorization: AuthSub token=\"$token\""
);
$request = join( "\r\n", $headers ) . "\r\n\r\n";
$sock = $this->_get_auth_sock( );
if ( ! $sock ) return false;
$response = $this->_txrx( $sock, $request );
preg_match( '/token=([-_0-9a-z]+)/i', $response, $matches );
if ( empty( $matches[1] ) ) {
$this->uh_oh(
__( 'Authorization failed' ),
__( 'Something went wrong. If the problem persists, send this info to support:' ),
htmlspecialchars($response)
);
return false;
}
$this->token = $matches[1];
wp_redirect( remove_query_arg( array( 'token', 'noheader' ) ) );
}
function get_token_info() {
$headers = array(
"GET /accounts/AuthSubTokenInfo HTTP/1.0",
"Authorization: AuthSub token=\"$this->token\""
);
$request = join( "\r\n", $headers ) . "\r\n\r\n";
$sock = $this->_get_auth_sock( );
if ( ! $sock ) return;
$response = $this->_txrx( $sock, $request );
return $this->parse_response($response);
}
function token_is_valid() {
$info = $this->get_token_info();
if ( $info['code'] == 200 )
return true;
return false;
}
function show_blogs($iter = 0) {
if ( empty($this->blogs) ) {
$headers = array(
"GET /feeds/default/blogs HTTP/1.0",
"Host: www.blogger.com",
"Authorization: AuthSub token=\"$this->token\""
);
$request = join( "\r\n", $headers ) . "\r\n\r\n";
$sock = $this->_get_blogger_sock( );
if ( ! $sock ) return;
$response = $this->_txrx( $sock, $request );
// Quick and dirty XML mining.
list( $headers, $xml ) = explode( "\r\n\r\n", $response );
$p = xml_parser_create();
xml_parse_into_struct($p, $xml, $vals, $index);
xml_parser_free($p);
$this->title = $vals[$index['TITLE'][0]]['value'];
// Give it a few retries... this step often flakes out the first time.
if ( empty( $index['ENTRY'] ) ) {
if ( $iter < 3 ) {
return $this->show_blogs($iter + 1);
} else {
$this->uh_oh(
__('Trouble signing in'),
__('We were not able to gain access to your account. Try starting over.'),
''
);
return false;
}
}
foreach ( $index['ENTRY'] as $i ) {
$blog = array();
while ( ( $tag = $vals[$i] ) && ! ( $tag['tag'] == 'ENTRY' && $tag['type'] == 'close' ) ) {
if ( $tag['tag'] == 'TITLE' ) {
$blog['title'] = $tag['value'];
} elseif ( $tag['tag'] == 'SUMMARY' ) {
$blog['summary'] == $tag['value'];
} elseif ( $tag['tag'] == 'LINK' ) {
if ( $tag['attributes']['REL'] == 'alternate' && $tag['attributes']['TYPE'] == 'text/html' ) {
$parts = parse_url( $tag['attributes']['HREF'] );
$blog['host'] = $parts['host'];
} elseif ( $tag['attributes']['REL'] == 'edit' )
$blog['gateway'] = $tag['attributes']['HREF'];
}
++$i;
}
if ( ! empty ( $blog ) ) {
$blog['total_posts'] = $this->get_total_results('posts', $blog['host']);
$blog['total_comments'] = $this->get_total_results('comments', $blog['host']);
$blog['mode'] = 'init';
$this->blogs[] = $blog;
}
}
if ( empty( $this->blogs ) ) {
$this->uh_oh(
__('No blogs found'),
__('We were able to log in but there were no blogs. Try a different account next time.'),
''
);
return false;
}
}
//echo '
'.print_r($this,1).'
';
$start = js_escape( __('Import') );
$continue = js_escape( __('Continue') );
$stop = js_escape( __('Importing...') );
$authors = js_escape( __('Set Authors') );
$loadauth = js_escape( __('Preparing author mapping form...') );
$authhead = js_escape( __('Final Step: Author Mapping') );
$nothing = js_escape( __('Nothing was imported. Had you already imported this blog?') );
$title = __('Blogger Blogs');
$name = __('Blog Name');
$url = __('Blog URL');
$action = __('The Magic Button');
$posts = __('Posts');
$comments = __('Comments');
$noscript = __('This feature requires Javascript but it seems to be disabled. Please enable Javascript and then reload this page. Don\'t worry, you can turn it back off when you\'re done.');
$interval = STATUS_INTERVAL * 1000;
foreach ( $this->blogs as $i => $blog ) {
if ( $blog['mode'] == 'init' )
$value = $start;
elseif ( $blog['mode'] == 'posts' || $blog['mode'] == 'comments' )
$value = $continue;
else
$value = $authors;
$blogtitle = js_escape( $blog['title'] );
$pdone = isset($blog['posts_done']) ? (int) $blog['posts_done'] : 0;
$cdone = isset($blog['comments_done']) ? (int) $blog['comments_done'] : 0;
$init .= "blogs[$i]=new blog($i,'$blogtitle','{$blog['mode']}'," . $this->get_js_status($i) . ');';
$pstat = "
$pdone/{$blog['total_posts']}
";
$cstat = "
$cdone/{$blog['total_comments']}
";
$rows .= "
$blogtitle
{$blog['host']}
$pstat
$cstat
\n";
}
echo "
$title
$name
$url
$posts
$comments
$action
\n$rows
";
echo "
\n";
}
// Handy function for stopping the script after a number of seconds.
function have_time() {
global $importer_started;
if ( time() - $importer_started > MAX_EXECUTION_TIME )
die('continue');
return true;
}
function get_total_results($type, $host) {
$headers = array(
"GET /feeds/$type/default?max-results=1&start-index=2 HTTP/1.0",
"Host: $host",
"Authorization: AuthSub token=\"$this->token\""
);
$request = join( "\r\n", $headers ) . "\r\n\r\n";
$sock = $this->_get_blogger_sock( $host );
if ( ! $sock ) return;
$response = $this->_txrx( $sock, $request );
$response = $this->parse_response( $response );
$parser = xml_parser_create();
xml_parse_into_struct($parser, $response['body'], $struct, $index);
xml_parser_free($parser);
$total_results = $struct[$index['OPENSEARCH:TOTALRESULTS'][0]]['value'];
return (int) $total_results;
}
function import_blog($blogID) {
global $importing_blog;
$importing_blog = $blogID;
if ( isset($_GET['authors']) )
return print($this->get_author_form());
header('Content-Type: text/plain');
if ( isset($_GET['status']) )
die($this->get_js_status());
if ( isset($_GET['saveauthors']) )
die($this->save_authors());
$blog = $this->blogs[$blogID];
$total_results = $this->get_total_results('posts', $blog['host']);
$this->blogs[$importing_blog]['total_posts'] = $total_results;
$start_index = $total_results - MAX_RESULTS + 1;
if ( isset( $this->blogs[$importing_blog]['posts_start_index'] ) )
$start_index = (int) $this->blogs[$importing_blog]['posts_start_index'];
elseif ( $total_results > MAX_RESULTS )
$start_index = $total_results - MAX_RESULTS + 1;
else
$start_index = 1;
// This will be positive until we have finished importing posts
if ( $start_index > 0 ) {
// Grab all the posts
$this->blogs[$importing_blog]['mode'] = 'posts';
$query = "start-index=$start_index&max-results=" . MAX_RESULTS;
do {
$index = $struct = $entries = array();
$headers = array(
"GET /feeds/posts/default?$query HTTP/1.0",
"Host: {$blog['host']}",
"Authorization: AuthSub token=\"$this->token\""
);
$request = join( "\r\n", $headers ) . "\r\n\r\n";
$sock = $this->_get_blogger_sock( $blog['host'] );
if ( ! $sock ) return; // TODO: Error handling
$response = $this->_txrx( $sock, $request );
$response = $this->parse_response( $response );
// Extract the entries and send for insertion
preg_match_all( '/]*>.*?<\/entry>/s', $response['body'], $matches );
if ( count( $matches[0] ) ) {
$entries = array_reverse($matches[0]);
foreach ( $entries as $entry ) {
$entry = "$entry";
$AtomParser = new AtomParser();
$AtomParser->parse( $entry );
$result = $this->import_post($AtomParser->entry);
if ( is_wp_error( $result ) )
return $result;
unset($AtomParser);
}
} else break;
// Get the 'previous' query string which we'll use on the next iteration
$query = '';
$links = preg_match_all('/]*)>/', $response['body'], $matches);
if ( count( $matches[1] ) )
foreach ( $matches[1] as $match )
if ( preg_match('/rel=.previous./', $match) )
$query = html_entity_decode( preg_replace('/^.*href=[\'"].*\?(.+)[\'"].*$/', '$1', $match) );
if ( $query ) {
parse_str($query, $q);
$this->blogs[$importing_blog]['posts_start_index'] = (int) $q['start-index'];
} else
$this->blogs[$importing_blog]['posts_start_index'] = 0;
$this->save_vars();
} while ( !empty( $query ) && $this->have_time() );
}
$total_results = $this->get_total_results( 'comments', $blog['host'] );
$this->blogs[$importing_blog]['total_comments'] = $total_results;
if ( isset( $this->blogs[$importing_blog]['comments_start_index'] ) )
$start_index = (int) $this->blogs[$importing_blog]['comments_start_index'];
elseif ( $total_results > MAX_RESULTS )
$start_index = $total_results - MAX_RESULTS + 1;
else
$start_index = 1;
if ( $start_index > 0 ) {
// Grab all the comments
$this->blogs[$importing_blog]['mode'] = 'comments';
$query = "start-index=$start_index&max-results=" . MAX_RESULTS;
do {
$index = $struct = $entries = array();
$headers = array(
"GET /feeds/comments/default?$query HTTP/1.0",
"Host: {$blog['host']}",
"Authorization: AuthSub token=\"$this->token\""
);
$request = join( "\r\n", $headers ) . "\r\n\r\n";
$sock = $this->_get_blogger_sock( $blog['host'] );
if ( ! $sock ) return; // TODO: Error handling
$response = $this->_txrx( $sock, $request );
$response = $this->parse_response( $response );
// Extract the comments and send for insertion
preg_match_all( '/]*>.*?<\/entry>/s', $response['body'], $matches );
if ( count( $matches[0] ) ) {
$entries = array_reverse( $matches[0] );
foreach ( $entries as $entry ) {
$entry = "$entry";
$AtomParser = new AtomParser();
$AtomParser->parse( $entry );
$this->import_comment($AtomParser->entry);
unset($AtomParser);
}
}
// Get the 'previous' query string which we'll use on the next iteration
$query = '';
$links = preg_match_all('/]*)>/', $response['body'], $matches);
if ( count( $matches[1] ) )
foreach ( $matches[1] as $match )
if ( preg_match('/rel=.previous./', $match) )
$query = html_entity_decode( preg_replace('/^.*href=[\'"].*\?(.+)[\'"].*$/', '$1', $match) );
parse_str($query, $q);
$this->blogs[$importing_blog]['comments_start_index'] = (int) $q['start-index'];
$this->save_vars();
} while ( !empty( $query ) && $this->have_time() );
}
$this->blogs[$importing_blog]['mode'] = 'authors';
$this->save_vars();
if ( !$this->blogs[$importing_blog]['posts_done'] && !$this->blogs[$importing_blog]['comments_done'] )
die('nothing');
do_action('import_done', 'blogger');
die('done');
}
function convert_date( $date ) {
preg_match('#([0-9]{4})-([0-9]{2})-([0-9]{2})T([0-9]{2}):([0-9]{2}):([0-9]{2})(?:\.[0-9]+)?(Z|[\+|\-][0-9]{2,4}){0,1}#', $date, $date_bits);
$offset = iso8601_timezone_to_offset( $date_bits[7] );
$timestamp = gmmktime($date_bits[4], $date_bits[5], $date_bits[6], $date_bits[2], $date_bits[3], $date_bits[1]);
$timestamp -= $offset; // Convert from Blogger local time to GMT
$timestamp += get_option('gmt_offset') * 3600; // Convert from GMT to WP local time
return gmdate('Y-m-d H:i:s', $timestamp);
}
function no_apos( $string ) {
return str_replace( ''', "'", $string);
}
function min_whitespace( $string ) {
return preg_replace( '|\s+|', ' ', $string );
}
function import_post( $entry ) {
global $wpdb, $importing_blog;
// The old permalink is all Blogger gives us to link comments to their posts.
if ( isset( $entry->draft ) )
$rel = 'self';
else
$rel = 'alternate';
foreach ( $entry->links as $link ) {
if ( $link['rel'] == $rel ) {
$parts = parse_url( $link['href'] );
$entry->old_permalink = $parts['path'];
break;
}
}
$post_date = $this->convert_date( $entry->published );
$post_content = trim( addslashes( $this->no_apos( html_entity_decode( $entry->content ) ) ) );
$post_title = trim( addslashes( $this->no_apos( $this->min_whitespace( $entry->title ) ) ) );
$post_status = isset( $entry->draft ) ? 'draft' : 'publish';
// Clean up content
$post_content = preg_replace('|<(/?[A-Z]+)|e', "'<' . strtolower('$1')", $post_content);
$post_content = str_replace(' ', ' ', $post_content);
$post_content = str_replace('', '', $post_content);
// Checks for duplicates
if ( isset( $this->blogs[$importing_blog]['posts'][$entry->old_permalink] ) ) {
++$this->blogs[$importing_blog]['posts_skipped'];
} elseif ( $post_id = post_exists( $post_title, $post_content, $post_date ) ) {
$this->blogs[$importing_blog]['posts'][$entry->old_permalink] = $post_id;
++$this->blogs[$importing_blog]['posts_skipped'];
} else {
$post = compact('post_date', 'post_content', 'post_title', 'post_status');
$post_id = wp_insert_post($post);
if ( is_wp_error( $post_id ) )
return $post_id;
wp_create_categories( array_map( 'addslashes', $entry->categories ), $post_id );
$author = $this->no_apos( strip_tags( $entry->author ) );
add_post_meta( $post_id, 'blogger_blog', $this->blogs[$importing_blog]['host'], true );
add_post_meta( $post_id, 'blogger_author', $author, true );
add_post_meta( $post_id, 'blogger_permalink', $entry->old_permalink, true );
$this->blogs[$importing_blog]['posts'][$entry->old_permalink] = $post_id;
++$this->blogs[$importing_blog]['posts_done'];
}
$this->save_vars();
return;
}
function import_comment( $entry ) {
global $importing_blog;
// Drop the #fragment and we have the comment's old post permalink.
foreach ( $entry->links as $link ) {
if ( $link['rel'] == 'alternate' ) {
$parts = parse_url( $link['href'] );
$entry->old_permalink = $parts['fragment'];
$entry->old_post_permalink = $parts['path'];
break;
}
}
$comment_post_ID = (int) $this->blogs[$importing_blog]['posts'][$entry->old_post_permalink];
preg_match('#(.+?).*(?:\(.+?))?#', $entry->author, $matches);
$comment_author = addslashes( $this->no_apos( strip_tags( (string) $matches[1] ) ) );
$comment_author_url = addslashes( $this->no_apos( strip_tags( (string) $matches[2] ) ) );
$comment_date = $this->convert_date( $entry->updated );
$comment_content = addslashes( $this->no_apos( html_entity_decode( $entry->content ) ) );
// Clean up content
$comment_content = preg_replace('|<(/?[A-Z]+)|e', "'<' . strtolower('$1')", $comment_content);
$comment_content = str_replace(' ', ' ', $comment_content);
$comment_content = str_replace('', '', $comment_content);
// Checks for duplicates
if (
isset( $this->blogs[$importing_blog]['comments'][$entry->old_permalink] ) ||
comment_exists( $comment_author, $comment_date )
) {
++$this->blogs[$importing_blog]['comments_skipped'];
} else {
$comment = compact('comment_post_ID', 'comment_author', 'comment_author_url', 'comment_date', 'comment_content');
$comment_id = wp_insert_comment($comment);
$this->blogs[$importing_blog]['comments'][$entry->old_permalink] = $comment_id;
++$this->blogs[$importing_blog]['comments_done'];
}
$this->save_vars();
}
function get_js_status($blog = false) {
global $importing_blog;
if ( $blog === false )
$blog = $this->blogs[$importing_blog];
else
$blog = $this->blogs[$blog];
$p1 = isset( $blog['posts_done'] ) ? (int) $blog['posts_done'] : 0;
$p2 = isset( $blog['total_posts'] ) ? (int) $blog['total_posts'] : 0;
$c1 = isset( $blog['comments_done'] ) ? (int) $blog['comments_done'] : 0;
$c2 = isset( $blog['total_comments'] ) ? (int) $blog['total_comments'] : 0;
return "{p1:$p1,p2:$p2,c1:$c1,c2:$c2}";
}
function get_author_form($blog = false) {
global $importing_blog, $wpdb, $current_user;
if ( $blog === false )
$blog = & $this->blogs[$importing_blog];
else
$blog = & $this->blogs[$blog];
if ( !isset( $blog['authors'] ) ) {
$post_ids = array_values($blog['posts']);
$authors = (array) $wpdb->get_col("SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = 'blogger_author' AND post_id IN (" . join( ',', $post_ids ) . ")");
$blog['authors'] = array_map(null, $authors, array_fill(0, count($authors), $current_user->ID));
$this->save_vars();
}
$directions = __('All posts were imported with the current user as author. Use this form to move each Blogger user\'s posts to a different WordPress user. You may add users and then return to this page and complete the user mapping. This form may be used as many times as you like until you activate the "Restart" function below.');
$heading = __('Author mapping');
$blogtitle = "{$blog['title']} ({$blog['host']})";
$mapthis = __('Blogger username');
$tothis = __('WordPress login');
$submit = js_escape( __('Save Changes') );
foreach ( $blog['authors'] as $i => $author )
$rows .= "
";
return "
$heading
$blogtitle
$directions
";
}
function get_user_options($current) {
global $wpdb, $importer_users;
if ( ! isset( $importer_users ) )
$importer_users = (array) get_users_of_blog();
foreach ( $importer_users as $user ) {
$sel = ( $user->user_id == $current ) ? " selected='selected'" : '';
$options .= "";
}
return $options;
}
function save_authors() {
global $importing_blog, $wpdb;
$authors = (array) $_POST['authors'];
$host = $this->blogs[$importing_blog]['host'];
// Get an array of posts => authors
$post_ids = (array) $wpdb->get_col( $wpdb->prepare("SELECT post_id FROM $wpdb->postmeta WHERE meta_key = 'blogger_blog' AND meta_value = %s", $host) );
$post_ids = join( ',', $post_ids );
$results = (array) $wpdb->get_results("SELECT post_id, meta_value FROM $wpdb->postmeta WHERE meta_key = 'blogger_author' AND post_id IN ($post_ids)");
foreach ( $results as $row )
$authors_posts[$row->post_id] = $row->meta_value;
foreach ( $authors as $author => $user_id ) {
$user_id = (int) $user_id;
// Skip authors that haven't been changed
if ( $user_id == $this->blogs[$importing_blog]['authors'][$author][1] )
continue;
// Get a list of the selected author's posts
$post_ids = (array) array_keys( $authors_posts, $this->blogs[$importing_blog]['authors'][$author][0] );
$post_ids = join( ',', $post_ids);
$wpdb->query( $wpdb->prepare("UPDATE $wpdb->posts SET post_author = %d WHERE id IN ($post_ids)", $user_id) );
$this->blogs[$importing_blog]['authors'][$author][1] = $user_id;
}
$this->save_vars();
wp_redirect('edit.php');
}
function _get_auth_sock() {
// Connect to https://www.google.com
if ( !$sock = @ fsockopen('ssl://www.google.com', 443, $errno, $errstr) ) {
$this->uh_oh(
__('Could not connect to https://www.google.com'),
__('There was a problem opening a secure connection to Google. This is what went wrong:'),
"$errstr ($errno)"
);
return false;
}
return $sock;
}
function _get_blogger_sock($host = 'www2.blogger.com') {
if ( !$sock = @ fsockopen($host, 80, $errno, $errstr) ) {
$this->uh_oh(
sprintf( __('Could not connect to %s'), $host ),
__('There was a problem opening a connection to Blogger. This is what went wrong:'),
"$errstr ($errno)"
);
return false;
}
return $sock;
}
function _txrx( $sock, $request ) {
fwrite( $sock, $request );
while ( ! feof( $sock ) )
$response .= @ fread ( $sock, 8192 );
fclose( $sock );
return $response;
}
function revoke($token) {
$headers = array(
"GET /accounts/AuthSubRevokeToken HTTP/1.0",
"Authorization: AuthSub token=\"$token\""
);
$request = join( "\r\n", $headers ) . "\r\n\r\n";
$sock = $this->_get_auth_sock( );
if ( ! $sock ) return false;
$this->_txrx( $sock, $request );
}
function restart() {
global $wpdb;
$options = get_option( 'blogger_importer' );
if ( isset( $options['token'] ) )
$this->revoke( $options['token'] );
delete_option('blogger_importer');
$wpdb->query("DELETE FROM $wpdb->postmeta WHERE meta_key = 'blogger_author'");
wp_redirect('?import=blogger');
}
// Returns associative array of code, header, cookies, body. Based on code from php.net.
function parse_response($this_response) {
// Split response into header and body sections
list($response_headers, $response_body) = explode("\r\n\r\n", $this_response, 2);
$response_header_lines = explode("\r\n", $response_headers);
// First line of headers is the HTTP response code
$http_response_line = array_shift($response_header_lines);
if(preg_match('@^HTTP/[0-9]\.[0-9] ([0-9]{3})@',$http_response_line, $matches)) { $response_code = $matches[1]; }
// put the rest of the headers in an array
$response_header_array = array();
foreach($response_header_lines as $header_line) {
list($header,$value) = explode(': ', $header_line, 2);
$response_header_array[$header] .= $value."\n";
}
$cookie_array = array();
$cookies = explode("\n", $response_header_array["Set-Cookie"]);
foreach($cookies as $this_cookie) { array_push($cookie_array, "Cookie: ".$this_cookie); }
return array("code" => $response_code, "header" => $response_header_array, "cookies" => $cookie_array, "body" => $response_body);
}
// Step 9: Congratulate the user
function congrats() {
$blog = (int) $_GET['blog'];
echo '
'.__('Congratulations!').'
'.__('Now that you have imported your Blogger blog into WordPress, what are you going to do? Here are some suggestions:').'
'.__('That was hard work! Take a break.').'
';
if ( count($this->import['blogs']) > 1 )
echo '
'.__('In case you haven\'t done it already, you can import the posts from your other blogs:'). $this->show_blogs() . '
';
if ( $n = count($this->import['blogs'][$blog]['newusers']) )
echo '
'.sprintf(__('Go to Authors & Users, where you can modify the new user(s) or delete them. If you want to make all of the imported posts yours, you will be given that option when you delete the new authors.'), 'users.php', '_parent').'
';
echo '
'.__('For security, click the link below to reset this importer.').'
';
echo '
';
}
// Figures out what to do, then does it.
function start() {
if ( isset($_POST['restart']) )
$this->restart();
$options = get_option('blogger_importer');
if ( is_array($options) )
foreach ( $options as $key => $value )
$this->$key = $value;
if ( isset( $_REQUEST['blog'] ) ) {
$blog = is_array($_REQUEST['blog']) ? array_shift( $keys = array_keys( $_REQUEST['blog'] ) ) : $_REQUEST['blog'];
$blog = (int) $blog;
$result = $this->import_blog( $blog );
if ( is_wp_error( $result ) )
echo $result->get_error_message();
} elseif ( isset($_GET['token']) )
$this->auth();
elseif ( $this->token && $this->token_is_valid() )
$this->show_blogs();
else
$this->greet();
$saved = $this->save_vars();
if ( $saved && !isset($_GET['noheader']) ) {
$restart = __('Restart');
$message = __('We have saved some information about your Blogger account in your WordPress database. Clearing this information will allow you to start over. Restarting will not affect any posts you have already imported. If you attempt to re-import a blog, duplicate posts and comments will be skipped.');
$submit = __('Clear account information');
echo "
';
}
function footer() {
echo '';
}
function unhtmlentities($string) { // From php.net for < 4.3 compat
$trans_tbl = get_html_translation_table(HTML_ENTITIES);
$trans_tbl = array_flip($trans_tbl);
return strtr($string, $trans_tbl);
}
function greet() {
echo '
';
echo '
'.__('Howdy! This importer allows you to extract posts from Blogware XML export file into your blog. Pick a Blogware file to upload and click Import.').'
' . sprintf( __ngettext('Done! %s post with tags were read.', 'Done! %s posts with tags were read.', $count), $count ) . '
';
echo '
';
foreach ( $metakeys as $post_meta ) {
if ( $post_meta->meta_value != '' ) {
$post_keys = explode(' ', $post_meta->meta_value);
foreach ( $post_keys as $keyword ) {
$keyword = addslashes(trim(str_replace('+',' ',$keyword)));
if ( '' != $keyword ) {
echo '
' . $post_meta->post_id . ' - ' . $keyword . '
';
if ( !$precheck )
wp_add_post_tags($post_meta->post_id, $keyword);
}
}
}
if ( !$precheck )
delete_post_meta($post_meta->post_id, 'tags');
}
echo '
';
}
echo '';
echo '
';
}
function done() {
echo '
';
echo '
'.__('Import Complete!').'
';
echo '
';
}
function BunnyTags_Import() {
}
}
// create the import object
$btt_import = new BunnyTags_Import();
// add it to the import page!
register_importer('btt', 'Bunny’s Technorati Tags', __('Import Bunny’s Technorati Tags into WordPress tags.'), array($btt_import, 'dispatch'));
?>
blog/wp-admin/import/dotclear.php 0000755 0023433 0004734 00000055253 11060470703 016720 0 ustar xemion psacln get_var( $wpdb->prepare("SELECT count(*) FROM $wpdb->comments WHERE comment_post_ID = %d", $post_ID) );
}
}
if(!function_exists('link_exists'))
{
function link_exists($linkname)
{
global $wpdb;
return $wpdb->get_var( $wpdb->prepare("SELECT link_id FROM $wpdb->links WHERE link_name = %s", $linkname) );
}
}
/*
Identify UTF-8 text
Taken from http://www.php.net/manual/fr/function.mb-detect-encoding.php#50087
*/
//
// utf8 encoding validation developed based on Wikipedia entry at:
// http://en.wikipedia.org/wiki/UTF-8
//
// Implemented as a recursive descent parser based on a simple state machine
// copyright 2005 Maarten Meijer
//
// This cries out for a C-implementation to be included in PHP core
//
function valid_1byte($char) {
if(!is_int($char)) return false;
return ($char & 0x80) == 0x00;
}
function valid_2byte($char) {
if(!is_int($char)) return false;
return ($char & 0xE0) == 0xC0;
}
function valid_3byte($char) {
if(!is_int($char)) return false;
return ($char & 0xF0) == 0xE0;
}
function valid_4byte($char) {
if(!is_int($char)) return false;
return ($char & 0xF8) == 0xF0;
}
function valid_nextbyte($char) {
if(!is_int($char)) return false;
return ($char & 0xC0) == 0x80;
}
function valid_utf8($string) {
$len = strlen($string);
$i = 0;
while( $i < $len ) {
$char = ord(substr($string, $i++, 1));
if(valid_1byte($char)) { // continue
continue;
} else if(valid_2byte($char)) { // check 1 byte
if(!valid_nextbyte(ord(substr($string, $i++, 1))))
return false;
} else if(valid_3byte($char)) { // check 2 bytes
if(!valid_nextbyte(ord(substr($string, $i++, 1))))
return false;
if(!valid_nextbyte(ord(substr($string, $i++, 1))))
return false;
} else if(valid_4byte($char)) { // check 3 bytes
if(!valid_nextbyte(ord(substr($string, $i++, 1))))
return false;
if(!valid_nextbyte(ord(substr($string, $i++, 1))))
return false;
if(!valid_nextbyte(ord(substr($string, $i++, 1))))
return false;
} // goto next char
}
return true; // done
}
function csc ($s) {
if (valid_utf8 ($s)) {
return $s;
} else {
return iconv(get_option ("dccharset"),"UTF-8",$s);
}
}
function textconv ($s) {
return csc (preg_replace ('|(?)\s*\n|', ' ', $s));
}
/**
The Main Importer Class
**/
class Dotclear_Import {
function header()
{
echo '
';
echo '
'.__('Import DotClear').'
';
echo '
'.__('Steps may take a few minutes depending on the size of your database. Please be patient.').'
';
}
function footer()
{
echo '
';
}
function greet()
{
echo '
'.__('Howdy! This importer allows you to extract posts from a DotClear database into your blog. Mileage may vary.').'
';
echo '
'.__('Your DotClear Configuration settings are as follows:').'
';
echo '
';
}
function get_dc_cats()
{
global $wpdb;
// General Housekeeping
$dcdb = new wpdb(get_option('dcuser'), get_option('dcpass'), get_option('dcname'), get_option('dchost'));
set_magic_quotes_runtime(0);
$dbprefix = get_option('dcdbprefix');
// Get Categories
return $dcdb->get_results('SELECT * FROM '.$dbprefix.'categorie', ARRAY_A);
}
function get_dc_users()
{
global $wpdb;
// General Housekeeping
$dcdb = new wpdb(get_option('dcuser'), get_option('dcpass'), get_option('dcname'), get_option('dchost'));
set_magic_quotes_runtime(0);
$dbprefix = get_option('dcdbprefix');
// Get Users
return $dcdb->get_results('SELECT * FROM '.$dbprefix.'user', ARRAY_A);
}
function get_dc_posts()
{
// General Housekeeping
$dcdb = new wpdb(get_option('dcuser'), get_option('dcpass'), get_option('dcname'), get_option('dchost'));
set_magic_quotes_runtime(0);
$dbprefix = get_option('dcdbprefix');
// Get Posts
return $dcdb->get_results('SELECT '.$dbprefix.'post.*, '.$dbprefix.'categorie.cat_libelle_url AS post_cat_name
FROM '.$dbprefix.'post INNER JOIN '.$dbprefix.'categorie
ON '.$dbprefix.'post.cat_id = '.$dbprefix.'categorie.cat_id', ARRAY_A);
}
function get_dc_comments()
{
global $wpdb;
// General Housekeeping
$dcdb = new wpdb(get_option('dcuser'), get_option('dcpass'), get_option('dcname'), get_option('dchost'));
set_magic_quotes_runtime(0);
$dbprefix = get_option('dcdbprefix');
// Get Comments
return $dcdb->get_results('SELECT * FROM '.$dbprefix.'comment', ARRAY_A);
}
function get_dc_links()
{
//General Housekeeping
$dcdb = new wpdb(get_option('dcuser'), get_option('dcpass'), get_option('dcname'), get_option('dchost'));
set_magic_quotes_runtime(0);
$dbprefix = get_option('dcdbprefix');
return $dcdb->get_results('SELECT * FROM '.$dbprefix.'link ORDER BY position', ARRAY_A);
}
function cat2wp($categories='')
{
// General Housekeeping
global $wpdb;
$count = 0;
$dccat2wpcat = array();
// Do the Magic
if(is_array($categories))
{
echo '
';
return true;
}// End if(is_array($users)
echo __('No Users to Import!');
return false;
}// End function user2wp()
function posts2wp($posts='')
{
// General Housekeeping
global $wpdb;
$count = 0;
$dcposts2wpposts = array();
$cats = array();
// Do the Magic
if(is_array($posts))
{
echo '
'.__('Welcome to WordPress. We hope (and expect!) that you will find this platform incredibly rewarding! As a new WordPress user coming from DotClear, there are some things that we would like to point out. Hopefully, they will help your transition go as smoothly as possible.').'
';
echo '
'.__('Users').'
';
echo '
'.sprintf(__('You have already setup WordPress and have been assigned an administrative login and password. Forget it. You didn\'t have that login in DotClear, why should you have it here? Instead we have taken care to import all of your users into our system. Unfortunately there is one downside. Because both WordPress and DotClear uses a strong encryption hash with passwords, it is impossible to decrypt it and we are forced to assign temporary passwords to all your users. Every user has the same username, but their passwords are reset to password123. So Login and change it.'), '/wp-login.php').'
';
echo '
'.__('Preserving Authors').'
';
echo '
'.__('Secondly, we have attempted to preserve post authors. If you are the only author or contributor to your blog, then you are safe. In most cases, we are successful in this preservation endeavor. However, if we cannot ascertain the name of the writer due to discrepancies between database tables, we assign it to you, the administrative user.').'
';
echo '
'.__('Textile').'
';
echo '
'.__('Also, since you\'re coming from DotClear, you probably have been using Textile to format your comments and posts. If this is the case, we recommend downloading and installing Textile for WordPress. Trust me... You\'ll want it.').'
';
echo '
'.__('WordPress Resources').'
';
echo '
'.__('Finally, there are numerous WordPress resources around the internet. Some of them are:').'
';
printf(__('All done. Have fun!'), get_option('home'));
echo '
';
}
function dispatch() {
if (empty ($_GET['step']))
$step = 0;
else
$step = (int) $_GET['step'];
$this->header();
switch ($step) {
case 0 :
$this->greet();
break;
case 1 :
check_admin_referer('import-upload');
$result = $this->import();
if ( is_wp_error( $result ) )
echo $result->get_error_message();
break;
}
$this->footer();
}
function LJ_Import() {
// Nothing.
}
}
$livejournal_import = new LJ_Import();
register_importer('livejournal', __('LiveJournal'), __('Import posts from a LiveJournal XML export file.'), array ($livejournal_import, 'dispatch'));
?>
blog/wp-admin/import/mt.php 0000755 0023433 0004734 00000035444 11060470706 015546 0 ustar xemion psacln ';
echo '
'.__('Import Movable Type or TypePad').'
';
}
function footer() {
echo '';
}
function greet() {
$this->header();
?>
mt-export.txt in your /wp-content/ directory and then click "Import mt-export.txt"'); ?>
out of memory error try splitting up the import file into pieces.'); ?>
footer();
}
function users_form($n) {
global $wpdb, $testing;
$users = $wpdb->get_results("SELECT * FROM $wpdb->users ORDER BY ID");
?>
mtnames))) { //a new mt author name is found
++ $this->j;
$this->mtnames[$this->j] = $author; //add that new mt author name to an array
$user_id = username_exists($this->newauthornames[$this->j]); //check if the new author name defined by the user is a pre-existing wp user
if (!$user_id) { //banging my head against the desk now.
if ($newauthornames[$this->j] == 'left_blank') { //check if the user does not want to change the authorname
$user_id = wp_create_user($author, $pass);
$this->newauthornames[$this->j] = $author; //now we have a name, in the place of left_blank.
} else {
$user_id = wp_create_user($this->newauthornames[$this->j], $pass);
}
} else {
return $user_id; // return pre-existing wp username if it exists
}
} else {
$key = array_search($author, $this->mtnames); //find the array key for $author in the $mtnames array
$user_id = username_exists($this->newauthornames[$key]); //use that key to get the value of the author's name from $newauthornames
}
return $user_id;
}
function get_mt_authors() {
$temp = array();
$authors = array();
$handle = fopen($this->file, 'r');
if ( $handle == null )
return false;
$in_comment = false;
while ( $line = fgets($handle) ) {
$line = trim($line);
if ( 'COMMENT:' == $line )
$in_comment = true;
else if ( '-----' == $line )
$in_comment = false;
if ( $in_comment || 0 !== strpos($line,"AUTHOR:") )
continue;
$temp[] = trim( substr($line, strlen("AUTHOR:")) );
}
//we need to find unique values of author names, while preserving the order, so this function emulates the unique_value(); php function, without the sorting.
$authors[0] = array_shift($temp);
$y = count($temp) + 1;
for ($x = 1; $x < $y; $x ++) {
$next = array_shift($temp);
if (!(in_array($next, $authors)))
array_push($authors, "$next");
}
fclose($handle);
return $authors;
}
function get_authors_from_post() {
$formnames = array ();
$selectnames = array ();
foreach ($_POST['user'] as $key => $line) {
$newname = trim(stripslashes($line));
if ($newname == '')
$newname = 'left_blank'; //passing author names from step 1 to step 2 is accomplished by using POST. left_blank denotes an empty entry in the form.
array_push($formnames, "$newname");
} // $formnames is the array with the form entered names
foreach ($_POST['userselect'] as $user => $key) {
$selected = trim(stripslashes($key));
array_push($selectnames, "$selected");
}
$count = count($formnames);
for ($i = 0; $i < $count; $i ++) {
if ($selectnames[$i] != '#NONE#') { //if no name was selected from the select menu, use the name entered in the form
array_push($this->newauthornames, "$selectnames[$i]");
} else {
array_push($this->newauthornames, "$formnames[$i]");
}
}
}
function mt_authors_form() {
?>
italics. For each of these names, you can either pick an author in your WordPress installation from the menu, or enter a name for the author in the textbox.'); ?>
get_mt_authors();
echo '';
echo '';
echo '
';
}
function select_authors() {
if ( $_POST['upload_type'] === 'ftp' ) {
$file['file'] = WP_CONTENT_DIR . '/mt-export.txt';
if ( !file_exists($file['file']) )
$file['error'] = __('mt-export.txt does not exist');
} else {
$file = wp_import_handle_upload();
}
if ( isset($file['error']) ) {
$this->header();
echo '
'.sprintf(__('All done. Have fun!'), get_option('home')).'
';
}
function import() {
$this->id = (int) $_GET['id'];
if ( $this->id == 0 )
$this->file = WP_CONTENT_DIR . '/mt-export.txt';
else
$this->file = get_attached_file($this->id);
$this->get_authors_from_post();
$result = $this->process_posts();
if ( is_wp_error( $result ) )
return $result;
}
function dispatch() {
if (empty ($_GET['step']))
$step = 0;
else
$step = (int) $_GET['step'];
switch ($step) {
case 0 :
$this->greet();
break;
case 1 :
check_admin_referer('import-upload');
$this->select_authors();
break;
case 2:
check_admin_referer('import-mt');
$result = $this->import();
if ( is_wp_error( $result ) )
echo $result->get_error_message();
break;
}
}
function MT_Import() {
// Nothing.
}
}
$mt_import = new MT_Import();
register_importer('mt', __('Movable Type and TypePad'), __('Import posts and comments from a Movable Type or Typepad blog.'), array ($mt_import, 'dispatch'));
?>
blog/wp-admin/import/rss.php 0000755 0023433 0004734 00000011662 11060470707 015732 0 ustar xemion psacln ';
echo '
'.__('Import RSS').'
';
}
function footer() {
echo '';
}
function unhtmlentities($string) { // From php.net for < 4.3 compat
$trans_tbl = get_html_translation_table(HTML_ENTITIES);
$trans_tbl = array_flip($trans_tbl);
return strtr($string, $trans_tbl);
}
function greet() {
echo '
';
echo '
'.__('Howdy! This importer allows you to extract posts from an RSS 2.0 file into your blog. This is useful if you want to import your posts from a system that is not handled by a custom import tool. Pick an RSS file to upload and click Import.').'
';
printf(__('All done. Have fun!'), get_option('home'));
echo '
';
}
function dispatch() {
if (empty ($_GET['step']))
$step = 0;
else
$step = (int) $_GET['step'];
$this->header();
switch ($step) {
case 0 :
$this->greet();
break;
case 1 :
check_admin_referer('import-upload');
$result = $this->import();
if ( is_wp_error( $result ) )
echo $result->get_error_message();
break;
}
$this->footer();
}
function RSS_Import() {
// Nothing.
}
}
$rss_import = new RSS_Import();
register_importer('rss', __('RSS'), __('Import posts from an RSS feed.'), array ($rss_import, 'dispatch'));
?>
blog/wp-admin/import/stp.php 0000755 0023433 0004734 00000011362 11060470707 015726 0 ustar xemion psacln ';
echo '
'.__('Import Simple Tagging').'
';
echo '
'.__('Steps may take a few minutes depending on the size of your database. Please be patient.').'
';
}
function footer() {
echo '';
}
function greet() {
echo '
';
echo '
'.__('Howdy! This imports tags from Simple Tagging 1.6.2 into WordPress tags.').'
';
echo '
'.__('This has not been tested on any other versions of Simple Tagging. Mileage may vary.').'
';
echo '
'.__('To accommodate larger databases for those tag-crazy authors out there, we have made this into an easy 4-step program to help you kick that nasty Simple Tagging habit. Just keep clicking along and we will let you know when you are in the clear!').'
';
echo '
'.__('Don’t be stupid - backup your database before proceeding!').'
';
echo '';
echo '
';
}
function dispatch () {
if ( empty( $_GET['step'] ) ) {
$step = 0;
} else {
$step = (int) $_GET['step'];
}
// load the header
$this->header();
switch ( $step ) {
case 0 :
$this->greet();
break;
case 1 :
check_admin_referer('import-stp');
$this->import_posts();
break;
case 2:
check_admin_referer('import-stp');
$this->import_t2p();
break;
case 3:
check_admin_referer('import-stp');
$this->cleanup_import();
break;
}
// load the footer
$this->footer();
}
function import_posts ( ) {
echo '
';
echo '
'.__('Reading STP Post Tags…').'
';
// read in all the STP tag -> post settings
$posts = $this->get_stp_posts();
// if we didn't get any tags back, that's all there is folks!
if ( !is_array($posts) ) {
echo '
' . __('No posts were found to have tags!') . '
';
return false;
}
else {
// if there's an existing entry, delete it
if ( get_option('stpimp_posts') ) {
delete_option('stpimp_posts');
}
add_option('stpimp_posts', $posts);
$count = count($posts);
echo '
' . sprintf( __ngettext('Done! %s tag to post relationships were read.', 'Done! %s tags to post relationships were read.', $count), $count ) . '
';
}
echo '';
echo '
';
}
function import_t2p ( ) {
echo '
';
echo '
'.__('Adding Tags to Posts…').'
';
// run that funky magic!
$tags_added = $this->tag2post();
echo '
' . sprintf( __ngettext('Done! %s tag was added!', 'Done! %s tags were added!', $tags_added), $tags_added ) . '
';
echo '';
echo '
';
}
function get_stp_posts ( ) {
global $wpdb;
// read in all the posts from the STP post->tag table: should be wp_post2tag
$posts_query = "SELECT post_id, tag_name FROM " . $wpdb->prefix . "stp_tags";
$posts = $wpdb->get_results($posts_query);
return $posts;
}
function tag2post ( ) {
global $wpdb;
// get the tags and posts we imported in the last 2 steps
$posts = get_option('stpimp_posts');
// null out our results
$tags_added = 0;
// loop through each post and add its tags to the db
foreach ( $posts as $this_post ) {
$the_post = (int) $this_post->post_id;
$the_tag = $wpdb->escape($this_post->tag_name);
// try to add the tag
wp_add_post_tags($the_post, $the_tag);
$tags_added++;
}
// that's it, all posts should be linked to their tags properly, pending any errors we just spit out!
return $tags_added;
}
function cleanup_import ( ) {
delete_option('stpimp_posts');
$this->done();
}
function done ( ) {
echo '
';
echo '
'.__('Import Complete!').'
';
echo '
' . __('OK, so we lied about this being a 4-step program! You’re done!') . '
';
echo '
' . __('Now wasn’t that easy?') . '
';
echo '
';
}
function STP_Import ( ) {
// Nothing.
}
}
// create the import object
$stp_import = new STP_Import();
// add it to the import page!
register_importer('stp', 'Simple Tagging', __('Import Simple Tagging tags into WordPress tags.'), array($stp_import, 'dispatch'));
?>
blog/wp-admin/import/textpattern.php 0000755 0023433 0004734 00000047527 11060470710 017510 0 ustar xemion psacln get_var( $wpdb->prepare("SELECT count(*) FROM $wpdb->comments WHERE comment_post_ID = %d", $post_ID) );
}
}
if(!function_exists('link_exists'))
{
function link_exists($linkname)
{
global $wpdb;
return $wpdb->get_var( $wpdb->prepare("SELECT link_id FROM $wpdb->links WHERE link_name = %s", $linkname) );
}
}
/**
The Main Importer Class
**/
class Textpattern_Import {
function header()
{
echo '
';
echo '
'.__('Import Textpattern').'
';
echo '
'.__('Steps may take a few minutes depending on the size of your database. Please be patient.').'
';
}
function footer()
{
echo '
';
}
function greet() {
echo '
';
echo '
'.__('Howdy! This imports categories, users, posts, comments, and links from any Textpattern 4.0.2+ into this blog.').'
';
echo '
'.__('This has not been tested on previous versions of Textpattern. Mileage may vary.').'
';
echo '
'.__('Your Textpattern Configuration settings are as follows:').'
';
echo '';
echo '
';
}
function get_txp_cats()
{
global $wpdb;
// General Housekeeping
$txpdb = new wpdb(get_option('txpuser'), get_option('txppass'), get_option('txpname'), get_option('txphost'));
set_magic_quotes_runtime(0);
$prefix = get_option('tpre');
// Get Categories
return $txpdb->get_results('SELECT
id,
name,
title
FROM '.$prefix.'txp_category
WHERE type = "article"',
ARRAY_A);
}
function get_txp_users()
{
global $wpdb;
// General Housekeeping
$txpdb = new wpdb(get_option('txpuser'), get_option('txppass'), get_option('txpname'), get_option('txphost'));
set_magic_quotes_runtime(0);
$prefix = get_option('tpre');
// Get Users
return $txpdb->get_results('SELECT
user_id,
name,
RealName,
email,
privs
FROM '.$prefix.'txp_users', ARRAY_A);
}
function get_txp_posts()
{
// General Housekeeping
$txpdb = new wpdb(get_option('txpuser'), get_option('txppass'), get_option('txpname'), get_option('txphost'));
set_magic_quotes_runtime(0);
$prefix = get_option('tpre');
// Get Posts
return $txpdb->get_results('SELECT
ID,
Posted,
AuthorID,
LastMod,
Title,
Body,
Excerpt,
Category1,
Category2,
Status,
Keywords,
url_title,
comments_count
FROM '.$prefix.'textpattern
', ARRAY_A);
}
function get_txp_comments()
{
global $wpdb;
// General Housekeeping
$txpdb = new wpdb(get_option('txpuser'), get_option('txppass'), get_option('txpname'), get_option('txphost'));
set_magic_quotes_runtime(0);
$prefix = get_option('tpre');
// Get Comments
return $txpdb->get_results('SELECT * FROM '.$prefix.'txp_discuss', ARRAY_A);
}
function get_txp_links()
{
//General Housekeeping
$txpdb = new wpdb(get_option('txpuser'), get_option('txppass'), get_option('txpname'), get_option('txphost'));
set_magic_quotes_runtime(0);
$prefix = get_option('tpre');
return $txpdb->get_results('SELECT
id,
date,
category,
url,
linkname,
description
FROM '.$prefix.'txp_link',
ARRAY_A);
}
function cat2wp($categories='')
{
// General Housekeeping
global $wpdb;
$count = 0;
$txpcat2wpcat = array();
// Do the Magic
if(is_array($categories))
{
echo '
';
return true;
}// End if(is_array($users)
echo __('No Users to Import!');
return false;
}// End function user2wp()
function posts2wp($posts='')
{
// General Housekeeping
global $wpdb;
$count = 0;
$txpposts2wpposts = array();
$cats = array();
// Do the Magic
if(is_array($posts))
{
echo '
'.__('Welcome to WordPress. We hope (and expect!) that you will find this platform incredibly rewarding! As a new WordPress user coming from Textpattern, there are some things that we would like to point out. Hopefully, they will help your transition go as smoothly as possible.').'
';
echo '
'.__('Users').'
';
echo '
'.sprintf(__('You have already setup WordPress and have been assigned an administrative login and password. Forget it. You didn’t have that login in Textpattern, why should you have it here? Instead we have taken care to import all of your users into our system. Unfortunately there is one downside. Because both WordPress and Textpattern uses a strong encryption hash with passwords, it is impossible to decrypt it and we are forced to assign temporary passwords to all your users. Every user has the same username, but their passwords are reset to password123. So Login and change it.'), get_bloginfo( 'wpurl' ) . '/wp-login.php').'
';
echo '
'.__('Preserving Authors').'
';
echo '
'.__('Secondly, we have attempted to preserve post authors. If you are the only author or contributor to your blog, then you are safe. In most cases, we are successful in this preservation endeavor. However, if we cannot ascertain the name of the writer due to discrepancies between database tables, we assign it to you, the administrative user.').'
';
echo '
'.__('Textile').'
';
echo '
'.__('Also, since you’re coming from Textpattern, you probably have been using Textile to format your comments and posts. If this is the case, we recommend downloading and installing Textile for WordPress. Trust me... You’ll want it.').'
';
echo '
'.__('WordPress Resources').'
';
echo '
'.__('Finally, there are numerous WordPress resources around the internet. Some of them are:').'
';
}
function dispatch()
{
if (empty ($_GET['step']))
$step = 0;
else
$step = (int) $_GET['step'];
$this->header();
if ( $step > 0 )
{
check_admin_referer('import-textpattern');
if($_POST['dbuser'])
{
if(get_option('txpuser'))
delete_option('txpuser');
add_option('txpuser', sanitize_user($_POST['dbuser'], true));
}
if($_POST['dbpass'])
{
if(get_option('txppass'))
delete_option('txppass');
add_option('txppass', sanitize_user($_POST['dbpass'], true));
}
if($_POST['dbname'])
{
if(get_option('txpname'))
delete_option('txpname');
add_option('txpname', sanitize_user($_POST['dbname'], true));
}
if($_POST['dbhost'])
{
if(get_option('txphost'))
delete_option('txphost');
add_option('txphost', sanitize_user($_POST['dbhost'], true));
}
if($_POST['dbprefix'])
{
if(get_option('tpre'))
delete_option('tpre');
add_option('tpre', sanitize_user($_POST['dbprefix']));
}
}
switch ($step)
{
default:
case 0 :
$this->greet();
break;
case 1 :
$this->import_categories();
break;
case 2 :
$this->import_users();
break;
case 3 :
$result = $this->import_posts();
if ( is_wp_error( $result ) )
echo $result->get_error_message();
break;
case 4 :
$this->import_comments();
break;
case 5 :
$this->import_links();
break;
case 6 :
$this->cleanup_txpimport();
break;
}
$this->footer();
}
function Textpattern_Import()
{
// Nothing.
}
}
$txp_import = new Textpattern_Import();
register_importer('textpattern', __('Textpattern'), __('Import categories, users, posts, comments, and links from a Textpattern blog.'), array ($txp_import, 'dispatch'));
?>
blog/wp-admin/import/utw.php 0000755 0023433 0004734 00000015042 11060470711 015731 0 ustar xemion psacln ';
echo '
'.__('Import Ultimate Tag Warrior').'
';
echo '
'.__('Steps may take a few minutes depending on the size of your database. Please be patient.').'
';
}
function footer() {
echo '';
}
function greet() {
echo '
';
echo '
'.__('Howdy! This imports tags from Ultimate Tag Warrior 3 into WordPress tags.').'
';
echo '
'.__('This has not been tested on any other versions of Ultimate Tag Warrior. Mileage may vary.').'
';
echo '
'.__('To accommodate larger databases for those tag-crazy authors out there, we have made this into an easy 5-step program to help you kick that nasty UTW habit. Just keep clicking along and we will let you know when you are in the clear!').'
';
echo '
'.__('Don’t be stupid - backup your database before proceeding!').'
';
echo '';
echo '
';
}
function dispatch () {
if ( empty( $_GET['step'] ) ) {
$step = 0;
} else {
$step = (int) $_GET['step'];
}
if ( $step > 1 )
check_admin_referer('import-utw');
// load the header
$this->header();
switch ( $step ) {
case 0 :
$this->greet();
break;
case 1 :
$this->import_tags();
break;
case 2 :
$this->import_posts();
break;
case 3:
$this->import_t2p();
break;
case 4:
$this->cleanup_import();
break;
}
// load the footer
$this->footer();
}
function import_tags ( ) {
echo '
';
echo '
'.__('Reading UTW Tags…').'
';
$tags = $this->get_utw_tags();
// if we didn't get any tags back, that's all there is folks!
if ( !is_array($tags) ) {
echo '
' . __('No Tags Found!') . '
';
return false;
}
else {
// if there's an existing entry, delete it
if ( get_option('utwimp_tags') ) {
delete_option('utwimp_tags');
}
add_option('utwimp_tags', $tags);
$count = count($tags);
echo '
' . sprintf( __ngettext('Done! %s tag were read.', 'Done! %s tags were read.', $count), $count ) . '
' . __('If you don’t want to import any of these tags, you should delete them from the UTW tag management page and then re-run this import.') . '
';
}
echo '';
echo '
';
}
function import_posts ( ) {
echo '
';
echo '
'.__('Reading UTW Post Tags…').'
';
// read in all the UTW tag -> post settings
$posts = $this->get_utw_posts();
// if we didn't get any tags back, that's all there is folks!
if ( !is_array($posts) ) {
echo '
' . __('No posts were found to have tags!') . '
';
return false;
}
else {
// if there's an existing entry, delete it
if ( get_option('utwimp_posts') ) {
delete_option('utwimp_posts');
}
add_option('utwimp_posts', $posts);
$count = count($posts);
echo '
' . sprintf( __ngettext('Done! %s tag to post relationships were read.', 'Done! %s tags to post relationships were read.', $count), $count ) . '
';
}
echo '';
echo '
';
}
function import_t2p ( ) {
echo '
';
echo '
'.__('Adding Tags to Posts…').'
';
// run that funky magic!
$tags_added = $this->tag2post();
echo '
' . sprintf( __ngettext( 'Done! %s tag were added!', 'Done! %s tags were added!', $tags_added ), $tags_added ) . '
';
echo '';
echo '
';
}
function get_utw_tags ( ) {
global $wpdb;
// read in all the tags from the UTW tags table: should be wp_tags
$tags_query = "SELECT tag_id, tag FROM " . $wpdb->prefix . "tags";
$tags = $wpdb->get_results($tags_query);
// rearrange these tags into something we can actually use
foreach ( $tags as $tag ) {
$new_tags[$tag->tag_id] = $tag->tag;
}
return $new_tags;
}
function get_utw_posts ( ) {
global $wpdb;
// read in all the posts from the UTW post->tag table: should be wp_post2tag
$posts_query = "SELECT tag_id, post_id FROM " . $wpdb->prefix . "post2tag";
$posts = $wpdb->get_results($posts_query);
return $posts;
}
function tag2post ( ) {
// get the tags and posts we imported in the last 2 steps
$tags = get_option('utwimp_tags');
$posts = get_option('utwimp_posts');
// null out our results
$tags_added = 0;
// loop through each post and add its tags to the db
foreach ( $posts as $this_post ) {
$the_post = (int) $this_post->post_id;
$the_tag = (int) $this_post->tag_id;
// what's the tag name for that id?
$the_tag = $tags[$the_tag];
// screw it, just try to add the tag
wp_add_post_tags($the_post, $the_tag);
$tags_added++;
}
// that's it, all posts should be linked to their tags properly, pending any errors we just spit out!
return $tags_added;
}
function cleanup_import ( ) {
delete_option('utwimp_tags');
delete_option('utwimp_posts');
$this->done();
}
function done ( ) {
echo '
';
echo '
'.__('Import Complete!').'
';
echo '
' . __('OK, so we lied about this being a 5-step program! You’re done!') . '
';
echo '
' . __('Now wasn’t that easy?') . '
';
echo '
';
}
function UTW_Import ( ) {
// Nothing.
}
}
// create the import object
$utw_import = new UTW_Import();
// add it to the import page!
register_importer('utw', 'Ultimate Tag Warrior', __('Import Ultimate Tag Warrior tags into WordPress tags.'), array($utw_import, 'dispatch'));
?>
blog/wp-admin/import/wordpress.php 0000755 0023433 0004734 00000056761 11060470712 017160 0 ustar xemion psacln ';
echo '
'.__('Import WordPress').'
';
}
function footer() {
echo '';
}
function unhtmlentities($string) { // From php.net for < 4.3 compat
$trans_tbl = get_html_translation_table(HTML_ENTITIES);
$trans_tbl = array_flip($trans_tbl);
return strtr($string, $trans_tbl);
}
function greet() {
echo '
';
echo '
'.__('Howdy! Upload your WordPress eXtended RSS (WXR) file and we’ll import the posts, comments, custom fields, and categories into this blog.').'
';
echo '
'.__('Choose a WordPress WXR file to upload, then click Upload file and import.').'
';
}
function get_tag( $string, $tag ) {
global $wpdb;
preg_match("|<$tag.*?>(.*?)|is", $string, $return);
$return = preg_replace('|^$|s', '$1', $return[1]);
$return = $wpdb->escape( trim( $return ) );
return $return;
}
function has_gzip() {
return is_callable('gzopen');
}
function fopen($filename, $mode='r') {
if ( $this->has_gzip() )
return gzopen($filename, $mode);
return fopen($filename, $mode);
}
function feof($fp) {
if ( $this->has_gzip() )
return gzeof($fp);
return feof($fp);
}
function fgets($fp, $len=8192) {
if ( $this->has_gzip() )
return gzgets($fp, $len);
return fgets($fp, $len);
}
function fclose($fp) {
if ( $this->has_gzip() )
return gzclose($fp);
return fclose($fp);
}
function get_entries($process_post_func=NULL) {
set_magic_quotes_runtime(0);
$doing_entry = false;
$is_wxr_file = false;
$fp = $this->fopen($this->file, 'r');
if ($fp) {
while ( !$this->feof($fp) ) {
$importline = rtrim($this->fgets($fp));
// this doesn't check that the file is perfectly valid but will at least confirm that it's not the wrong format altogether
if ( !$is_wxr_file && preg_match('|xmlns:wp="http://wordpress[.]org/export/\d+[.]\d+/"|', $importline) )
$is_wxr_file = true;
if ( false !== strpos($importline, '') ) {
preg_match('|(.*?)|is', $importline, $category);
$this->categories[] = $category[1];
continue;
}
if ( false !== strpos($importline, '') ) {
preg_match('|(.*?)|is', $importline, $tag);
$this->tags[] = $tag[1];
continue;
}
if ( false !== strpos($importline, '') ) {
$this->post = '';
$doing_entry = true;
continue;
}
if ( false !== strpos($importline, '') ) {
$doing_entry = false;
if ($process_post_func)
call_user_func($process_post_func, $this->post);
continue;
}
if ( $doing_entry ) {
$this->post .= $importline . "\n";
}
}
$this->fclose($fp);
}
return $is_wxr_file;
}
function get_wp_authors() {
// We need to find unique values of author names, while preserving the order, so this function emulates the unique_value(); php function, without the sorting.
$temp = $this->allauthornames;
$authors[0] = array_shift($temp);
$y = count($temp) + 1;
for ($x = 1; $x < $y; $x ++) {
$next = array_shift($temp);
if (!(in_array($next, $authors)))
array_push($authors, "$next");
}
return $authors;
}
function get_authors_from_post() {
global $current_user;
// this will populate $this->author_ids with a list of author_names => user_ids
foreach ( $_POST['author_in'] as $i => $in_author_name ) {
if ( !empty($_POST['user_select'][$i]) ) {
// an existing user was selected in the dropdown list
$user = get_userdata( intval($_POST['user_select'][$i]) );
if ( isset($user->ID) )
$this->author_ids[$in_author_name] = $user->ID;
}
elseif ( $this->allow_create_users() ) {
// nothing was selected in the dropdown list, so we'll use the name in the text field
$new_author_name = trim($_POST['user_create'][$i]);
// if the user didn't enter a name, assume they want to use the same name as in the import file
if ( empty($new_author_name) )
$new_author_name = $in_author_name;
$user_id = username_exists($new_author_name);
if ( !$user_id ) {
$user_id = wp_create_user($new_author_name, wp_generate_password());
}
$this->author_ids[$in_author_name] = $user_id;
}
// failsafe: if the user_id was invalid, default to the current user
if ( empty($this->author_ids[$in_author_name]) ) {
$this->author_ids[$in_author_name] = intval($current_user->ID);
}
}
}
function wp_authors_form() {
?>
admins entries.'); ?>
allow_create_users() ) {
echo '
'.__('If a new user is created by WordPress, a password will be randomly generated. Manually change the user\'s details if necessary.')."
\n";
}
$authors = $this->get_wp_authors();
echo '';
echo '';
}
function users_form($n, $author) {
if ( $this->allow_create_users() ) {
printf(' ');
}
else {
echo __('Map to existing').' ';
}
// keep track of $n => $author name
echo '';
$users = get_users_of_blog();
?>
get_entries(array(&$this, 'process_author'));
if ( $is_wxr_file ) {
$this->wp_authors_form();
}
else {
echo '
'.__('Invalid file').'
';
echo '
'.__('Please upload a valid WXR (WordPress eXtended RSS) export file.').'
';
}
}
// fetch the user ID for a given author name, respecting the mapping preferences
function checkauthor($author) {
global $current_user;
if ( !empty($this->author_ids[$author]) )
return $this->author_ids[$author];
// failsafe: map to the current user
return $current_user->ID;
}
function process_categories() {
global $wpdb;
$cat_names = (array) get_terms('category', 'fields=names');
while ( $c = array_shift($this->categories) ) {
$cat_name = trim($this->get_tag( $c, 'wp:cat_name' ));
// If the category exists we leave it alone
if ( in_array($cat_name, $cat_names) )
continue;
$category_nicename = $this->get_tag( $c, 'wp:category_nicename' );
$posts_private = (int) $this->get_tag( $c, 'wp:posts_private' );
$links_private = (int) $this->get_tag( $c, 'wp:links_private' );
$parent = $this->get_tag( $c, 'wp:category_parent' );
if ( empty($parent) )
$category_parent = '0';
else
$category_parent = category_exists($parent);
$catarr = compact('category_nicename', 'category_parent', 'posts_private', 'links_private', 'posts_private', 'cat_name');
$cat_ID = wp_insert_category($catarr);
}
}
function process_tags() {
global $wpdb;
$tag_names = (array) get_terms('post_tag', 'fields=names');
while ( $c = array_shift($this->tags) ) {
$tag_name = trim($this->get_tag( $c, 'wp:tag_name' ));
// If the category exists we leave it alone
if ( in_array($tag_name, $tag_names) )
continue;
$slug = $this->get_tag( $c, 'wp:tag_slug' );
$description = $this->get_tag( $c, 'wp:tag_description' );
$tagarr = compact('slug', 'description');
$tag_ID = wp_insert_term($tag_name, 'post_tag', $tagarr);
}
}
function process_author($post) {
$author = $this->get_tag( $post, 'dc:creator' );
if ($author)
$this->allauthornames[] = $author;
}
function process_posts() {
$i = -1;
echo '';
$this->get_entries(array(&$this, 'process_post'));
echo '';
wp_import_cleanup($this->id);
do_action('import_done', 'wordpress');
echo '
';
printf(__('Post %s already exists.'), stripslashes($post_title));
} else {
// If it has parent, process parent first.
$post_parent = (int) $post_parent;
if ($post_parent) {
// if we already know the parent, map it to the local ID
if ( $parent = $this->post_ids_processed[$post_parent] ) {
$post_parent = $parent; // new ID of the parent
}
else {
// record the parent for later
$this->orphans[intval($post_ID)] = $post_parent;
}
}
echo '
';
$post_author = $this->checkauthor($post_author); //just so that if a post already exists, new users are not created by checkauthor
$postdata = compact('post_author', 'post_date', 'post_date_gmt', 'post_content', 'post_excerpt', 'post_title', 'post_status', 'post_name', 'comment_status', 'ping_status', 'guid', 'post_parent', 'menu_order', 'post_type', 'post_password');
if ($post_type == 'attachment') {
$remote_url = $this->get_tag( $post, 'wp:attachment_url' );
if ( !$remote_url )
$remote_url = $guid;
$comment_post_ID = $post_id = $this->process_attachment($postdata, $remote_url);
if ( !$post_id or is_wp_error($post_id) )
return $post_id;
}
else {
printf(__('Importing post %s...'), stripslashes($post_title));
$comment_post_ID = $post_id = wp_insert_post($postdata);
}
if ( is_wp_error( $post_id ) )
return $post_id;
// Memorize old and new ID.
if ( $post_id && $post_ID ) {
$this->post_ids_processed[intval($post_ID)] = intval($post_id);
}
// Add categories.
if (count($categories) > 0) {
$post_cats = array();
foreach ($categories as $category) {
$slug = sanitize_term_field('slug', $category, 0, 'category', 'db');
$cat = get_term_by('slug', $slug, 'category');
$cat_ID = 0;
if ( ! empty($cat) )
$cat_ID = $cat->term_id;
if ($cat_ID == 0) {
$category = $wpdb->escape($category);
$cat_ID = wp_insert_category(array('cat_name' => $category));
}
$post_cats[] = $cat_ID;
}
wp_set_post_categories($post_id, $post_cats);
}
// Add tags.
if (count($tags) > 0) {
$post_tags = array();
foreach ($tags as $tag) {
$slug = sanitize_term_field('slug', $tag, 0, 'post_tag', 'db');
$tag_obj = get_term_by('slug', $slug, 'post_tag');
$tag_id = 0;
if ( ! empty($tag_obj) )
$tag_id = $tag_obj->term_id;
if ( $tag_id == 0 ) {
$tag = $wpdb->escape($tag);
$tag_id = wp_insert_term($tag, 'post_tag');
$tag_id = $tag_id['term_id'];
}
$post_tags[] = intval($tag_id);
}
wp_set_post_tags($post_id, $post_tags);
}
}
// Now for comments
preg_match_all('|(.*?)|is', $post, $comments);
$comments = $comments[1];
$num_comments = 0;
if ( $comments) { foreach ($comments as $comment) {
$comment_author = $this->get_tag( $comment, 'wp:comment_author');
$comment_author_email = $this->get_tag( $comment, 'wp:comment_author_email');
$comment_author_IP = $this->get_tag( $comment, 'wp:comment_author_IP');
$comment_author_url = $this->get_tag( $comment, 'wp:comment_author_url');
$comment_date = $this->get_tag( $comment, 'wp:comment_date');
$comment_date_gmt = $this->get_tag( $comment, 'wp:comment_date_gmt');
$comment_content = $this->get_tag( $comment, 'wp:comment_content');
$comment_approved = $this->get_tag( $comment, 'wp:comment_approved');
$comment_type = $this->get_tag( $comment, 'wp:comment_type');
$comment_parent = $this->get_tag( $comment, 'wp:comment_parent');
// if this is a new post we can skip the comment_exists() check
if ( !$post_exists || !comment_exists($comment_author, $comment_date) ) {
$commentdata = compact('comment_post_ID', 'comment_author', 'comment_author_url', 'comment_author_email', 'comment_author_IP', 'comment_date', 'comment_date_gmt', 'comment_content', 'comment_approved', 'comment_type', 'comment_parent');
wp_insert_comment($commentdata);
$num_comments++;
}
} }
if ( $num_comments )
printf(' '.__ngettext('(%s comment)', '(%s comments)', $num_comments), $num_comments);
// Now for post meta
preg_match_all('|(.*?)|is', $post, $postmeta);
$postmeta = $postmeta[1];
if ( $postmeta) { foreach ($postmeta as $p) {
$key = $this->get_tag( $p, 'wp:meta_key' );
$value = $this->get_tag( $p, 'wp:meta_value' );
$value = stripslashes($value); // add_post_meta() will escape.
$this->process_post_meta($post_id, $key, $value);
} }
do_action('import_post_added', $post_id);
print "
\n";
}
function process_post_meta($post_id, $key, $value) {
// the filter can return false to skip a particular metadata key
$_key = apply_filters('import_post_meta_key', $key);
if ( $_key ) {
add_post_meta( $post_id, $_key, $value );
do_action('import_post_meta', $post_id, $_key, $value);
}
}
function process_attachment($postdata, $remote_url) {
if ($this->fetch_attachments and $remote_url) {
printf( __('Importing attachment %s... '), htmlspecialchars($remote_url) );
$upload = $this->fetch_remote_file($postdata, $remote_url);
if ( is_wp_error($upload) ) {
printf( __('Remote file error: %s'), htmlspecialchars($upload->get_error_message()) );
return $upload;
}
else {
print '('.size_format(filesize($upload['file'])).')';
}
if ( $info = wp_check_filetype($upload['file']) ) {
$postdata['post_mime_type'] = $info['type'];
}
else {
print __('Invalid file type');
return;
}
$postdata['guid'] = $upload['url'];
// as per wp-admin/includes/upload.php
$post_id = wp_insert_attachment($postdata, $upload['file']);
wp_update_attachment_metadata( $post_id, wp_generate_attachment_metadata( $post_id, $upload['file'] ) );
// remap the thumbnail url. this isn't perfect because we're just guessing the original url.
if ( preg_match('@^image/@', $info['type']) && $thumb_url = wp_get_attachment_thumb_url($post_id) ) {
$parts = pathinfo($remote_url);
$ext = $parts['extension'];
$name = basename($parts['basename'], ".{$ext}");
$this->url_remap[$parts['dirname'] . '/' . $name . '.thumbnail.' . $ext] = $thumb_url;
}
return $post_id;
}
else {
printf( __('Skipping attachment %s'), htmlspecialchars($remote_url) );
}
}
function fetch_remote_file($post, $url) {
$upload = wp_upload_dir($post['post_date']);
// extract the file name and extension from the url
$file_name = basename($url);
// get placeholder file in the upload dir with a unique sanitized filename
$upload = wp_upload_bits( $file_name, 0, '', $post['post_date']);
if ( $upload['error'] ) {
echo $upload['error'];
return new WP_Error( 'upload_dir_error', $upload['error'] );
}
// fetch the remote url and write it to the placeholder file
$headers = wp_get_http($url, $upload['file']);
// make sure the fetch was successful
if ( $headers['response'] != '200' ) {
@unlink($upload['file']);
return new WP_Error( 'import_file_error', sprintf(__('Remote file returned error response %d'), intval($headers['response'])) );
}
elseif ( isset($headers['content-length']) && filesize($upload['file']) != $headers['content-length'] ) {
@unlink($upload['file']);
return new WP_Error( 'import_file_error', __('Remote file is incorrect size') );
}
$max_size = $this->max_attachment_size();
if ( !empty($max_size) and filesize($upload['file']) > $max_size ) {
@unlink($upload['file']);
return new WP_Error( 'import_file_error', sprintf(__('Remote file is too large, limit is %s', size_format($max_size))) );
}
// keep track of the old and new urls so we can substitute them later
$this->url_remap[$url] = $upload['url'];
// if the remote url is redirected somewhere else, keep track of the destination too
if ( $headers['x-final-location'] != $url )
$this->url_remap[$headers['x-final-location']] = $upload['url'];
return $upload;
}
// sort by strlen, longest string first
function cmpr_strlen($a, $b) {
return strlen($b) - strlen($a);
}
// update url references in post bodies to point to the new local files
function backfill_attachment_urls() {
// make sure we do the longest urls first, in case one is a substring of another
uksort($this->url_remap, array(&$this, 'cmpr_strlen'));
global $wpdb;
foreach ($this->url_remap as $from_url => $to_url) {
// remap urls in post_content
$wpdb->query( $wpdb->prepare("UPDATE {$wpdb->posts} SET post_content = REPLACE(post_content, '%s', '%s')", $from_url, $to_url) );
// remap enclosure urls
$result = $wpdb->query( $wpdb->prepare("UPDATE {$wpdb->postmeta} SET meta_value = REPLACE(meta_value, '%s', '%s') WHERE meta_key='enclosure'", $from_url, $to_url) );
}
}
// update the post_parent of orphans now that we know the local id's of all parents
function backfill_parents() {
global $wpdb;
foreach ($this->orphans as $child_id => $parent_id) {
$local_child_id = $this->post_ids_processed[$child_id];
$local_parent_id = $this->post_ids_processed[$parent_id];
if ($local_child_id and $local_parent_id) {
$wpdb->query( $wpdb->prepare("UPDATE {$wpdb->posts} SET post_parent = %d WHERE ID = %d", $local_parent_id, $local_child_id));
}
}
}
function is_valid_meta_key($key) {
// skip _wp_attached_file metadata since we'll regenerate it from scratch
if ( $key == '_wp_attached_file' )
return false;
return $key;
}
// give the user the option of creating new users to represent authors in the import file?
function allow_create_users() {
return apply_filters('import_allow_create_users', true);
}
// give the user the option of downloading and importing attached files
function allow_fetch_attachments() {
return apply_filters('import_allow_fetch_attachments', true);
}
function max_attachment_size() {
// can be overridden with a filter - 0 means no limit
return apply_filters('import_attachment_size_limit', 0);
}
function import_start() {
wp_defer_term_counting(true);
wp_defer_comment_counting(true);
do_action('import_start');
}
function import_end() {
do_action('import_end');
// clear the caches after backfilling
foreach ($this->post_ids_processed as $post_id)
clean_post_cache($post_id);
wp_defer_term_counting(false);
wp_defer_comment_counting(false);
}
function import($id, $fetch_attachments = false) {
$this->id = (int) $id;
$this->fetch_attachments = ($this->allow_fetch_attachments() && (bool) $fetch_attachments);
add_filter('import_post_meta_key', array($this, 'is_valid_meta_key'));
$file = get_attached_file($this->id);
$this->import_file($file);
}
function import_file($file) {
$this->file = $file;
$this->import_start();
$this->get_authors_from_post();
$this->get_entries();
$this->process_categories();
$this->process_tags();
$result = $this->process_posts();
$this->backfill_parents();
$this->backfill_attachment_urls();
$this->import_end();
if ( is_wp_error( $result ) )
return $result;
}
function handle_upload() {
$file = wp_import_handle_upload();
if ( isset($file['error']) ) {
echo '
'.__('Sorry, there has been an error.').'
';
echo '
' . $file['error'] . '
';
return false;
}
$this->file = $file['file'];
$this->id = (int) $file['id'];
return true;
}
function dispatch() {
if (empty ($_GET['step']))
$step = 0;
else
$step = (int) $_GET['step'];
$this->header();
switch ($step) {
case 0 :
$this->greet();
break;
case 1 :
check_admin_referer('import-upload');
if ( $this->handle_upload() )
$this->select_authors();
break;
case 2:
check_admin_referer('import-wordpress');
$result = $this->import( $_GET['id'], $_POST['attachments'] );
if ( is_wp_error( $result ) )
echo $result->get_error_message();
break;
}
$this->footer();
}
function WP_Import() {
// Nothing.
}
}
$wp_import = new WP_Import();
register_importer('wordpress', 'WordPress', __('Import posts, comments, custom fields, pages, and categories from a WordPress export file.'), array ($wp_import, 'dispatch'));
?>
blog/wp-admin/import/wp-cat2tag.php 0000755 0023433 0004734 00000041101 11060470713 017060 0 ustar xemion psacln ';
if ( ! current_user_can('manage_categories') ) {
echo '
';
echo '
' . __('Cheatin’ uh?') . '
';
echo '
';
} else { ?>
';
}
function populate_cats() {
$categories = get_categories('get=all');
foreach ( $categories as $category ) {
$this->all_categories[] = $category;
if ( is_term( $category->slug, 'post_tag' ) )
$this->hybrids_ids[] = $category->term_id;
}
}
function populate_tags() {
$tags = get_terms( array('post_tag'), 'get=all' );
foreach ( $tags as $tag ) {
$this->all_tags[] = $tag;
if ( is_term( $tag->slug, 'category' ) )
$this->hybrids_ids[] = $tag->term_id;
}
}
function categories_tab() {
$this->populate_cats();
$cat_num = count($this->all_categories);
echo ' ';
if ( $cat_num > 0 ) {
echo '
' . sprintf( __ngettext( 'Convert Category to Tag.', 'Convert Categories (%d) to Tags.', $cat_num ), $cat_num ) . '
';
echo '
';
echo '
' . __('Hey there. Here you can selectively convert existing categories to tags. To get started, check the categories you wish to be converted, then click the Convert button.') . '
';
echo '
' . __('Keep in mind that if you convert a category with child categories, the children become top-level orphans.') . '
' . sprintf( __ngettext( 'Convert Tag to Category.', 'Convert Tags (%d) to Categories.', $tags_num ), $tags_num ) . '
';
echo '
';
echo '
' . __('Here you can selectively converts existing tags to categories. To get started, check the tags you wish to be converted, then click the Convert button.') . '
';
echo '
' . __('The newly created categories will still be associated with the same posts.') . '
';
$this->tags_form();
} else {
echo '
'.__('You have no tags to convert!').'
';
}
}
function tags_form() { ?>
term_id] as $child_id) {
$child =& get_category($child_id); ?>
' . sprintf(__('Converting category %s ... '), $category->name);
// If the category is the default, leave category in place and create tag.
if ( $default_cat == $category->term_id ) {
if ( ! ($id = is_term( $category->slug, 'post_tag' ) ) )
$id = wp_insert_term($category->name, 'post_tag', array('slug' => $category->slug));
$id = $id['term_taxonomy_id'];
$posts = get_objects_in_term($category->term_id, 'category');
$term_order = 0;
foreach ( $posts as $post ) {
$values[] = $wpdb->prepare( "(%d, %d, %d)", $post, $id, $term_order);
clean_post_cache($post);
}
if ( $values ) {
$wpdb->query("INSERT INTO $wpdb->term_relationships (object_id, term_taxonomy_id, term_order) VALUES " . join(',', $values) . " ON DUPLICATE KEY UPDATE term_order = VALUES(term_order)");
$wpdb->query( $wpdb->prepare("UPDATE $wpdb->term_taxonomy SET count = %d WHERE term_id = %d AND taxonomy = 'post_tag'", $category->count, $category->term_id) );
}
echo __('Converted successfully.') . "
\n";
continue;
}
// if tag already exists, add it to all posts in the category
if ( $tag_ttid = $wpdb->get_var( $wpdb->prepare("SELECT term_taxonomy_id FROM $wpdb->term_taxonomy WHERE term_id = %d AND taxonomy = 'post_tag'", $category->term_id) ) ) {
$objects_ids = get_objects_in_term($category->term_id, 'category');
$tag_ttid = (int) $tag_ttid;
$term_order = 0;
foreach ( $objects_ids as $object_id )
$values[] = $wpdb->prepare( "(%d, %d, %d)", $object_id, $tag_ttid, $term_order);
if ( $values ) {
$wpdb->query("INSERT INTO $wpdb->term_relationships (object_id, term_taxonomy_id, term_order) VALUES " . join(',', $values) . " ON DUPLICATE KEY UPDATE term_order = VALUES(term_order)");
$count = $wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM $wpdb->term_relationships WHERE term_taxonomy_id = %d", $tag_ttid) );
$wpdb->query( $wpdb->prepare("UPDATE $wpdb->term_taxonomy SET count = %d WHERE term_id = %d AND taxonomy = 'post_tag'", $count, $category->term_id) );
}
echo __('Tag added to all posts in this category.') . " *\n";
$hybrid_cats = true;
$clean_term_cache[] = $category->term_id;
$clean_cat_cache[] = $category->term_id;
continue;
}
$tt_ids = $wpdb->get_col( $wpdb->prepare("SELECT term_taxonomy_id FROM $wpdb->term_taxonomy WHERE term_id = %d AND taxonomy = 'category'", $category->term_id) );
if ( $tt_ids ) {
$posts = $wpdb->get_col("SELECT object_id FROM $wpdb->term_relationships WHERE term_taxonomy_id IN (" . join(',', $tt_ids) . ") GROUP BY object_id");
foreach ( (array) $posts as $post )
clean_post_cache($post);
}
// Change the category to a tag.
$wpdb->query( $wpdb->prepare("UPDATE $wpdb->term_taxonomy SET taxonomy = 'post_tag' WHERE term_id = %d AND taxonomy = 'category'", $category->term_id) );
// Set all parents to 0 (root-level) if their parent was the converted tag
$parents = $wpdb->query( $wpdb->prepare("UPDATE $wpdb->term_taxonomy SET parent = 0 WHERE parent = %d AND taxonomy = 'category'", $category->term_id) );
if ( $parents ) $clear_parents = true;
$clean_cat_cache[] = $category->term_id;
echo __('Converted successfully.') . "\n";
}
}
echo '
';
if ( ! empty($clean_term_cache) ) {
$clean_term_cache = array_unique(array_values($clean_term_cache));
foreach ( $clean_term_cache as $id )
wp_cache_delete($id, 'post_tag');
}
if ( ! empty($clean_cat_cache) ) {
$clean_cat_cache = array_unique(array_values($clean_cat_cache));
foreach ( $clean_cat_cache as $id )
wp_cache_delete($id, 'category');
}
if ( $clear_parents ) delete_option('category_children');
if ( $hybrid_cats )
echo '
' . sprintf( __('* This category is also a tag. The converter has added that tag to all posts currently in the category. If you want to remove it, please confirm that all tags were added successfully, then delete it from the Manage Categories page.'), 'categories.php') . '
';
echo '
' . sprintf( __('We’re all done here, but you can always convert more.'), 'admin.php?import=wp-cat2tag' ) . '
';
}
function convert_tags() {
global $wpdb;
if ( (!isset($_POST['tags_to_convert']) || !is_array($_POST['tags_to_convert'])) && empty($this->tags_to_convert)) {
echo '
' . __('Converting tag %s ... '), $tag->name);
if ( $cat_ttid = $wpdb->get_var( $wpdb->prepare("SELECT term_taxonomy_id FROM $wpdb->term_taxonomy WHERE term_id = %d AND taxonomy = 'category'", $tag->term_id) ) ) {
$objects_ids = get_objects_in_term($tag->term_id, 'post_tag');
$cat_ttid = (int) $cat_ttid;
$term_order = 0;
foreach ( $objects_ids as $object_id ) {
$values[] = $wpdb->prepare( "(%d, %d, %d)", $object_id, $cat_ttid, $term_order);
clean_post_cache($object_id);
}
if ( $values ) {
$wpdb->query("INSERT INTO $wpdb->term_relationships (object_id, term_taxonomy_id, term_order) VALUES " . join(',', $values) . " ON DUPLICATE KEY UPDATE term_order = VALUES(term_order)");
if ( $default_cat != $tag->term_id ) {
$count = $wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM $wpdb->term_relationships WHERE term_taxonomy_id = %d", $tag->term_id) );
$wpdb->query( $wpdb->prepare("UPDATE $wpdb->term_taxonomy SET count = %d WHERE term_id = %d AND taxonomy = 'category'", $count, $tag->term_id) );
}
}
$hybrid_tags = true;
$clean_term_cache[] = $tag->term_id;
$clean_cat_cache[] = $tag->term_id;
echo __('All posts were added to the category with the same name.') . " *
\n";
continue;
}
// Change the tag to a category.
$parent = $wpdb->get_var( $wpdb->prepare("SELECT parent FROM $wpdb->term_taxonomy WHERE term_id = %d AND taxonomy = 'post_tag'", $tag->term_id) );
if ( 0 == $parent || (0 < (int) $parent && $this->_category_exists($parent)) ) {
$reset_parent = '';
$clear_parents = true;
} else
$reset_parent = ", parent = '0'";
$wpdb->query( $wpdb->prepare("UPDATE $wpdb->term_taxonomy SET taxonomy = 'category' $reset_parent WHERE term_id = %d AND taxonomy = 'post_tag'", $tag->term_id) );
$clean_term_cache[] = $tag->term_id;
$clean_cat_cache[] = $cat['term_id'];
echo __('Converted successfully.') . "\n";
} else {
printf( '
' . __('Tag #%s doesn\'t exist!') . "
\n", $tag_id );
}
}
if ( ! empty($clean_term_cache) ) {
$clean_term_cache = array_unique(array_values($clean_term_cache));
foreach ( $clean_term_cache as $id )
wp_cache_delete($id, 'post_tag');
}
if ( ! empty($clean_cat_cache) ) {
$clean_cat_cache = array_unique(array_values($clean_cat_cache));
foreach ( $clean_cat_cache as $id )
wp_cache_delete($id, 'category');
}
if ( $clear_parents ) delete_option('category_children');
echo '
';
if ( $hybrid_tags )
echo '
' . sprintf( __('* This tag is also a category. The converter has added all posts from it to the category. If you want to remove it, please confirm that all posts were added successfully, then delete it from the Manage Tags page.'), 'edit-tags.php') . '
';
echo '
' . sprintf( __('We’re all done here, but you can always convert more.'), 'admin.php?import=wp-cat2tag&step=3' ) . '
';
}
elseif($ext=="zip")
{
$icon='
';
}
else
{
$icon='
';
}
$optdata.="
../'.$back.'';
//first the folders
while ($file = readdir($dir_handle))
{
if($file == "." || $file == ".." || $file == "images" || $file == '.svn' )
{
continue;
}
if(is_dir($path.'/'.$file.'/'))
{
if(!empty($_GET['dir']))
{
$dirf = str_replace('.','',$_GET['dir']);
$dirf=$dirf.'/'.$file;
}
else
{
$dirf=$file;
}
$data[]['name']='
'.$file.'';
}
}
closedir($dir_handle);
$total=count($data);
$num=$total / 2;
$class_tpl->assign('split', round($num));
$class_tpl->assign('data',$data);
$class_tpl->assign('body','editor/editor.tpl');
$class_tpl->displayTemplate();
?>
administration/fields.php 0000644 0023433 0004734 00000043155 11051631440 015435 0 ustar xemion psacln assign('body','notallowed.tpl');
$class_tpl->displayTemplate();
die;
}
if(isset($_POST['act']) && $_POST['act']=="changeorder")
{
$currentorder = (int)@$_POST["selectedq"];
$neworder = (int)@$_POST["newval"];
$sSQL = "SELECT fID FROM ".PREFIX."fields ORDER BY fOrder";
$result=$db->query($sSQL);
$rowcounter=1;
while($rs=$result->fetch())
{
$theorder = $rowcounter;
if($currentorder == $theorder)
$theorder = $neworder;
elseif(($currentorder > $theorder) && ($neworder <= $theorder))
$theorder++;
elseif(($currentorder < $theorder) && ($neworder >= $theorder))
$theorder--;
$sSQL="UPDATE ".PREFIX."fields SET fOrder=" . $theorder . " WHERE fID=" . $rs["fID"];
mysql_query($sSQL) or print(mysql_error());
$rowcounter++;
}
$class_tpl->assign('success',TRUE);
}
if(isset($_POST['act']) && $_POST['act']=="delete" && isset($_POST['id']) && $_POST['id']<>"")
{ //delete a record//
$fid=(int)$_POST['id'];
if($fid<>"")
{
$sSQL="SELECT fOrder FROM `".PREFIX."fields`WHERE fID=".$fid;
$result=$db->query($sSQL);
$rs=$result->fetch();
$order=$rs['fOrder'];
$sSQL="DELETE FROM `".PREFIX."fields` WHERE fID=$fid LIMIT 1";
$db->query($sSQL);
if($db->isError())
{
//not successfull
$location="fields.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
$sSQL="DELETE FROM `".PREFIX."fields_options` WHERE fieldID=$fid";
$db->query($sSQL);
if($db->isError())
{
//not successfull
$location="fields.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//sucessfull
$sSQL="DELETE FROM ".PREFIX."fields_bindings WHERE fieldID=".$fid;
$db->query($sSQL);
$sSQL="UPDATE ".PREFIX."fields SET fOrder=fOrder-1 WHERE fOrder > ".$order;
$db->query($sSQL);
$location="fields.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
}
}
elseif(isset($_POST['mode']) && $_POST['mode']=="doadd")
{
//add new text field
$go=FALSE;
$fName = ( empty($_POST['fName']) ) ? '': $_POST['fName'];
$fInternal = ( empty($_POST['fInternal']) ) ? '': $_POST['fInternal'];
$fType = ( empty($_POST['fType']) ) ? '': $_POST['fType'];
$fRequired = ( empty($_POST['fRequired']) ) ? '': $_POST['fRequired'];
$fSeen = ( empty($_POST['fSeen']) ) ? 'N': $_POST['fSeen'];
$fSearch = ( empty($_POST['fSearch']) ) ? 'N': $_POST['fSearch'];
$fGlobal = ( empty($_POST['fGlobal']) ) ? 'N': $_POST['fGlobal'];
$fDefault = ( empty($_POST['fDefault']) ) ? '': $_POST['fDefault'];
$fRange = ( empty($_POST['fRange']) ) ? 'N': $_POST['fRange'];
$fRangeMin = ( empty($_POST['fRangeMin']) ) ? '0': floatval($_POST['fRangeMin']);
$fRangeMax = ( empty($_POST['fRangeMax']) ) ? '0': floatval($_POST['fRangeMax']);
$fRangeStep = ( empty($_POST['fRangeStep']) ) ? '0': floatval($_POST['fRangeStep']);
$fExtensions = ( empty($_POST['fExtensions']) ) ? '': $_POST['fExtensions'];
$fRangeValue=$fRangeMin.'|'.$fRangeMax.'|'.$fRangeStep;
//get the max order//
$sql="SELECT MAX(fOrder) AS max FROM `".PREFIX."fields`";
$result=$db->query($sql);
$rs=$result->fetch();
$max=($rs['max']+1);
$sSQL = "INSERT INTO `".PREFIX."fields` SET ";
//$sSQL.="fname='".trim($fName)."', ";
$sSQL.="fname=".GetSQLValueString($fName,"text").", ";
$sSQL.="fInternal=".GetSQLValueString($fInternal,"text").", ";
$sSQL.="fType='".trim($fType)."', ";
$sSQL.="fDefault='".trim($fDefault)."', ";
$sSQL.="fRequired='$fRequired', ";
$sSQL.="fSeen='$fSeen', ";
$sSQL.="fOrder='$max', ";
$sSQL.="fSearch='$fSearch', ";
$sSQL.="fGlobal='$fGlobal', ";
$sSQL.="fRange='$fRange',";
$sSQL.="fExtensions='$fExtensions',";
$sSQL.="fRangeValue='$fRangeValue' ";
$db->query($sSQL);
if (!$db->isError())
{
//sucessfull
//now insert the cats submitted//
$cat="";
$uid=$result->insertID();
if(is_array(@$_POST["cat"]))
{
foreach(@$_POST["cat"] as $catObj)
{
//$cat += $catObj;
$sSQL= sprintf("INSERT INTO ".PREFIX."fields_bindings (fieldID,catID ) VALUES (%s,%s)",
GetSQLValueString($uid, "int"),
GetSQLValueString($catObj, "int"));
$db->query($sSQL);
}
}
if( ($fType=="D" || $fType=="C" || $fType=="P" || $fType=="Y") && $fRange=="N")
{
//now insert the options//
$options=$_POST['optName'];
$sub=@$_POST['optSub'];
$counter=0;
while($counter <= count($options)) {
if($options[$counter]<>"")
{
$sSQL = "INSERT INTO `".PREFIX."fields_options` SET ";
$sSQL.="fieldID=".$uid.", ";
$sSQL.="optValue='".trim(mysql_real_escape_string($options[$counter]))."'";
if($sub[$counter]<>"") {
$sSQL.=", optSub=".(int)$sub[$counter];
}
$db->query($sSQL);
if ($db->isError()) {
die(mysql_error());
} else {
$go=TRUE;
}
}
$counter++;
}
}
else
{
//now forward
$location="fields.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
else
{
//not successfull
$location="fields.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
if($go==TRUE)
{
//sucessfull
$location="fields.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
elseif(isset($_POST['mode']) && $_POST['mode']=="domodify" && isset($_POST['fid']) && $_POST['fid']<>"")
{
//modify the database
$fid = ( empty($_POST['fid']) ) ? '0': (int)$_POST['fid'];
$fName = ( empty($_POST['fName']) ) ? '': $_POST['fName'];
$fInternal = ( empty($_POST['fInternal']) ) ? '': $_POST['fInternal'];
$fType = ( empty($_POST['fType']) ) ? '': $_POST['fType'];
$fRequired = ( empty($_POST['fRequired']) ) ? '': $_POST['fRequired'];
$fSeen = ( empty($_POST['fSeen']) ) ? 'N': $_POST['fSeen'];
$fSearch = ( empty($_POST['fSearch']) ) ? 'N': $_POST['fSearch'];
$fGlobal = ( empty($_POST['fGlobal']) ) ? 'N': $_POST['fGlobal'];
$fDefault = ( empty($_POST['fDefault']) ) ? '': $_POST['fDefault'];
$fRange = ( empty($_POST['fRange']) ) ? 'N': $_POST['fRange'];
$fRangeMin = ( empty($_POST['fRangeMin']) ) ? '0': floatval($_POST['fRangeMin']);
$fRangeMax = ( empty($_POST['fRangeMax']) ) ? '0': floatval($_POST['fRangeMax']);
$fRangeStep = ( empty($_POST['fRangeStep']) ) ? '0': floatval($_POST['fRangeStep']);
$fExtensions = ( empty($_POST['fExtensions']) ) ? '': $_POST['fExtensions'];
$fRangeValue=$fRangeMin.'|'.$fRangeMax.'|'.$fRangeStep;
$fExtensions=@$_POST['fExtensions'];
//handle the new categories//
$sSQL="DELETE FROM ".PREFIX."fields_bindings WHERE fieldID=".$fid;
$db->query($sSQL);
$cat="";
if(is_array(@$_POST["cat"]))
{
foreach(@$_POST["cat"] as $catObj)
{
$cat += $catObj;
$sSQL= sprintf("INSERT INTO ".PREFIX."fields_bindings (fieldID,catID ) VALUES (%s,%s)",
GetSQLValueString($fid, "int"),
GetSQLValueString($catObj, "int"));
$db->query($sSQL);
}
}
$sSQL = "UPDATE `".PREFIX."fields` SET ";
$sSQL.="fname=".GetSQLValueString($fName,"text").", ";
$sSQL.="fInternal=".GetSQLValueString($fInternal,"text").", ";
$sSQL.="fType='".trim($fType)."', ";
$sSQL.="fDefault='".trim(mysql_real_escape_string($fDefault))."', ";
$sSQL.="fRequired='$fRequired', ";
$sSQL.="fSeen='$fSeen', ";
$sSQL.="fSearch='$fSearch', ";
$sSQL.="fGlobal='$fGlobal', ";
$sSQL.="fRange='$fRange',";
$sSQL.="fRangeValue='$fRangeValue',";
$sSQL.="fExtensions='$fExtensions' ";
$sSQL.="WHERE fID=".$fid;
$db->query($sSQL);
if (!$db->isError())
{
$forward=TRUE;
$go=TRUE;
}
else
{
//not successfull
$location="fields.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
if($fType=="D" || $fType=="C" || $fType=="P" || $fType=="Y")
{
//DELETE all options //
$sSQL="DELETE FROM `".PREFIX."fields_options` WHERE fieldID=".$fid;
$db->query($sSQL);
if ($db->isError())
{
//not successfull
$location="fields.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//now insert the options//
$i=0;
$options=$_POST['optName'];
$sub=@$_POST['optSub'];
$counter=0;
while($counter <= count($options)) {
if($options[$counter]<>"")
{
$sSQL = "INSERT INTO `".PREFIX."fields_options` SET ";
$sSQL.="fieldID=".$fid.", ";
$sSQL.="optValue='".trim(mysql_real_escape_string($options[$counter]))."'";
if($sub[$counter]<>"") {
$sSQL.=", optSub=".(int)$sub[$counter];
}
$db->query($sSQL);
if ($db->isError()) {
die(mysql_error());
} else {
$go=TRUE;
}
}
$counter++;
}
//extra fields
$extra=array();
$sSQL = "SELECT f.fID,sValue FROM ".PREFIX."products_fields AS p, `".PREFIX."fields` AS f WHERE p.pID='".mysql_escape_string($view)."' AND f.fSeen='Y' AND p.fID=f.fID ORDER BY f.fOrder ASC";
$result=$db->query($sSQL);
$i=0;
while ($rs=$result->fetch())
{
$sql="SELECT fID,fName FROM `".PREFIX."fields` WHERE fID='".$rs['fID']."' AND fSeen='Y' ORDER BY fOrder ASC";
$result2=$db->query($sql);
$rs2=$result2->fetch();
if(strpos($rs['sValue'], "|"))
{
$rs['sValue'] = explode("|", $rs['sValue']);
}
$tmp = array(
'fID' => $rs['fID'],
'title' => $rs2['fName'],
'value'=> $rs['sValue'],
);
$extra[$i++] = $tmp;
$i++;
}
$class_tpl->assign('extra', $extra);
}
}
if($go==TRUE)
{
//sucessfull
$location="fields.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
elseif(isset($_POST['act']) && $_POST['act']=="newparentopt")
{
//add a record//
for($index=0; $index<=21; $index++)
{
$data[$index]['id']=$index;
$data[$index]['optnum']=$index;
$data[$index]['optValue']="";
$data[$index]['optSub']="";
}
$class_tpl->assign('data', $data);
$tree = $Categories->getCatTree("", 0);
$class_tpl->assign('getcats', $tree);
$class_tpl->assign('action', 'doadd');
$class_tpl->assign('body','fields/fieldsformparent.tpl');
}
elseif(isset($_POST['act']) && $_POST['act']=="newchildopt")
{
//add a record//
for($index=0; $index<=21; $index++)
{
$data[$index]['id']=$index;
$data[$index]['optnum']=$index;
$data[$index]['optValue']="";
$data[$index]['optSub']="";
}
$class_tpl->assign('data', $data);
$tree = $Categories->getCatTree("", 0);
$class_tpl->assign('getcats', $tree);
$class_tpl->assign('action', 'doadd');
$class_tpl->assign('body','fields/fieldsformchild.tpl');
}
elseif(isset($_POST['act']) && $_POST['act']=="addnew")
{
//add a record//
for($index=0; $index<=21; $index++)
{
$data[$index]['id']=$index;
$data[$index]['optnum']=$index;
$data[$index]['optValue']="";
$data[$index]['optSub']="";
}
$class_tpl->assign('data', $data);
$tree = $Categories->getCatTree("", 0);
$class_tpl->assign('getcats', $tree);
$class_tpl->assign('action', 'doadd');
$class_tpl->assign('body','fields/fieldsform.tpl');
}
elseif(isset($_POST['act']) && $_POST['act']=="addnewtext")
{
//add a record//
$tree = $Categories->getCatTree("", 0);
$class_tpl->assign('getcats', $tree);
$class_tpl->assign('action', 'doadd');
$class_tpl->assign('fRange', 'N');
$class_tpl->assign('body','fields/fieldsformtext.tpl');
}
elseif(isset($_POST['act']) && $_POST['act']=="modify" && isset($_POST['id']) && $_POST['id']<>"")
{
//modify a record//
$modify=(int)@$_POST['id'];
$sSQL = "SELECT fID,fName,fInternal,fType,fDefault,fRequired,fSeen,fOrder,fSearch,fRange,fRangeValue,fExtensions FROM `".PREFIX."fields` WHERE fID=".$modify;
$result=$db->query($sSQL);
$rs=$result->fetch();
$tree = $Categories->selected_cat_tree("", 0, $modify);
$class_tpl->assign('fid', $rs['fID']);
$class_tpl->assign('fName', safeStripSlashes($rs['fName']));
$class_tpl->assign('fInternal', safeStripSlashes($rs['fInternal']));
$class_tpl->assign('fType', $rs['fType']);
$class_tpl->assign('fDefault', safeStripSlashes($rs['fDefault']));
$class_tpl->assign('fRequired', $rs['fRequired']);
$class_tpl->assign('fSeen', $rs['fSeen']);
$class_tpl->assign('fOrder', $rs['fOrder']);
$class_tpl->assign('fSearch', $rs['fSearch']);
$class_tpl->assign('fRange', $rs['fRange']);
$fRangeValue=explode("|", $rs['fRangeValue']);
$class_tpl->assign('fRangeMin', $fRangeValue[0]);
$class_tpl->assign('fRangeMax', $fRangeValue[1]);
$class_tpl->assign('fRangeStep', $fRangeValue[2]);
$class_tpl->assign('fExtensions', $rs['fExtensions']);
$class_tpl->assign('getcats', $tree);
$class_tpl->assign('action', 'domodify');
if($rs['fType']=="P")
{
//parent
$sSQL="SELECT optID AS id,fieldID,optValue,optOrder,optSub FROM `".PREFIX."fields_options` WHERE fieldID=".$modify." ORDER BY optValue";
$result=$db->query($sSQL);
$size=$result->size();
$noptions=0;
$data=array();
while($rows = $result->fetch())
{
$rows['optnum']=$i;
$data[] = $rows;
$i++;
}
for($index=1; $index<=$size+21; $index++)
{
$data[$index]['optnum']=$index;
$data[$index]['optValue']=$data[$index]['optValue'];
$data[$index]['optValue']=$data[$index]['optValue'];
}
$class_tpl->assign('data', $data);
$class_tpl->assign('body','fields/fieldsformparent.tpl');
}
elseif($rs['fType']=="Y")
{
//child or youth
$sSQL="SELECT optID AS id,fieldID,optValue,optOrder,optSub FROM `".PREFIX."fields_options` WHERE fieldID=".$modify." ORDER BY optValue";
$result=$db->query($sSQL);
$size=$result->size();
$noptions=0;
$i=0;
$data=array();
while($rows = $result->fetch())
{
$rows['optnum']=$i;
$data[] = $rows;
$i++;
}
for($index=1; $index<=$size+21; $index++)
{
$data[$index]['optnum']=$index;
$data[$index]['optValue']=$data[$index]['optValue'];
$data[$index]['optSub']="";
}
$class_tpl->assign('data', $data);
$class_tpl->assign('body','fields/fieldsformchild.tpl');
}
elseif($rs['fType']=="D" || $rs['fType']=="C")
{
$sSQL="SELECT fieldID,optValue,optOrder,optSub FROM `".PREFIX."fields_options` WHERE fieldID=".$modify." ORDER BY optValue";
$result=$db->query($sSQL);
$size=$result->size();
$noptions=0;
$i=0;
$data=array();
while($rows = $result->fetch())
{
$rows['optnum']=$i;
$data[] = $rows;
$i++;
}
for($index=1; $index<=$size+21; $index++)
{
$data[$index]['optnum']=$index;
$data[$index]['optValue']=$data[$index]['optValue'];
$data[$index]['optSub']="";
}
$class_tpl->assign('data', $data);
$class_tpl->assign('body','fields/fieldsform.tpl');
}
elseif($rs['fType']=="C")
{
$class_tpl->assign('body','fields/fieldsform.tpl');
}
else
{
$class_tpl->assign('body','fields/fieldsformtext.tpl');
}
}
else
{ //show all fields
$sSQL = "SELECT fID,fName,fInternal,fType,fRequired,fOrder,fSearch FROM `".PREFIX."fields` ORDER BY fOrder ASC";
$result=$db->query($sSQL);
$max=$result->size();
$i=0;
$data=array();
while($rs=$result->fetch())
{
switch ($rs['fType'])
{
case "D":
$type=LANG_DPLIST;
break;
case "P":
$type=LANG_PARENT_FIELD;
break;
case "Y":
$type=LANG_CHILD_FIELD;
break;
case "S":
$type=LANG_TXTSINGLE;
break;
case "M":
$type=LANG_TXTMULTI;
break;
case "C":
$type=LANG_CHECKBOX;
break;
case "F":
$type=LANG_FILE_UPLOAD;
break;
case "B":
$type=LANG_DATE_FIELD;
break;
}
$tmp = array(
'fID' => $rs['fID'],
'fName'=> $rs['fName'],
'fInternal'=>$rs['fInternal'],
'fType' => $type,
'fRequired' => $rs['fRequired'],
'fOrder' => $rs['fOrder'],
'fSearch'=> $rs['fSearch'],
);
$data[$i++] = $tmp;
}
$class_tpl->assign('max', $max);
$class_tpl->assign('title',$title);
$class_tpl->assign('results', $data);
$class_tpl->assign('body','fields/fields.tpl');
}
$class_tpl->displayTemplate();
?> administration/gateways.php 0000644 0023433 0004734 00000006451 11051631440 016011 0 ustar xemion psacln regenerate())
{
$class_tpl->assign('msg',LANG_GATEWAY_REGENERATE_SUCCESS);
}
}
}
if(isset($_GET['do']) && isset($_GET['action']) && isset($_GET['id']))
{
if($_GET['do']=="changestate")
{
$Gateway->changeStatus($_GET['id'], $_GET['action']);
}
}
if(isset($_POST['act']) && $_POST['act']=="changeorder")
{
$currentorder = (int)@$_POST["selectedq"];
$neworder = (int)@$_POST["newval"];
$sSQL = "SELECT id FROM ".PREFIX."gateways ORDER BY gOrder";
$result=$db->query($sSQL);
$rowcounter=1;
while($rs=$result->fetch())
{
$theorder = $rowcounter;
if($currentorder == $theorder)
$theorder = $neworder;
elseif(($currentorder > $theorder) && ($neworder <= $theorder))
$theorder++;
elseif(($currentorder < $theorder) && ($neworder >= $theorder))
$theorder--;
$sSQL="UPDATE ".PREFIX."gateways SET gOrder=" . $theorder . " WHERE id=" . $rs["id"];
mysql_query($sSQL) or print(mysql_error());
$rowcounter++;
}
$class_tpl->assign('success',TRUE);
}
if(isset($_POST["action"]) && $_POST["action"] == "modifypage" && isset($_POST["id"]))
{
// they have selected modify
$id=(int)trim(@$_POST['id']);
$sSQL = sprintf("UPDATE ".PREFIX."gateways SET displayname=%s, showas=%s, active=%s, demo=%s, extra=%s, extra2=%s WHERE id=%s",
GetSQLValueString(@$_POST['displayname'], "text"),
GetSQLValueString(@$_POST['showas'], "text"),
GetSQLValueString(@$_POST['active'], "text"),
GetSQLValueString(@$_POST['demo'], "text"),
GetSQLValueString(@$_POST['extra'], "text"),
GetSQLValueString(@$_POST['extra2'], "text"),
GetSQLValueString($id, "int"));
$db->query($sSQL);
if(!$db->isError())
{
//sucessfull
$location="gateways.php";
$class_tpl->assign('title',LANG_FORWARD_SUCESS);
$class_tpl->assign('forward',TRUE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
else
{
//not successfull
$location="gateways.php";
$class_tpl->assign('title',LANG_FORWARD_ERROR);
$class_tpl->assign('forward',FALSE);
$class_tpl->assign('location',$location);
$class_tpl->assign('body','forward.tpl');
}
}
elseif(isset($_POST["action"]) && $_POST["action"] == "modify" && isset($_POST["id"]))
{
//show the modify page
$id=(int)trim(@$_POST['id']);
$sSQL=sprintf("SELECT * FROM ".PREFIX."gateways WHERE id=%s", $id);
$result=$db->query($sSQL);
$rs=$result->fetch();
foreach($rs as $key => $value)
{
//loop through the results and assign to the template
$class_tpl->assign($key, safeStripSlashes($value));
}
$class_tpl->assign('body','gateways/gatewaysform.tpl');
}
else
{
$results = $Gateway->getAllGateways();
$class_tpl->assign('results', $results);
$class_tpl->assign('max', count($results));
$class_tpl->assign('body', 'gateways/gateways.tpl');
}
$class_tpl->displayTemplate();
?>
administration/images/ 0000755 0023433 0004734 00000000000 11036006206 014712 5 ustar xemion psacln administration/images/add.png 0000644 0023433 0004734 00000001335 11051631442 016155 0 ustar xemion psacln PNG
IHDR a gAMA 7 tEXtSoftware Adobe ImageReadyqe< oIDAT8˥Ka[/Y()%X(olNۖskn.-h;8fEP"jïMGˈ }yພ羹$ I.tulu AX:ZHh1DnZJOJB{Z?`2`S=N$ő=;a &jw qJG#<"N2h8`6xցn_+ ~ Zto}`x%XЛ͈ hXѿƻ/}BJ_G&|Qr-6 Aރ EL⬡\U3:WUh[C6+ 6.f * KܝFq ou4܄? d|Xҥ MvD`
*_[
#A20liR|xq`4w=\uQ m+G|%$ 5 Թ5RO*YGMUO Gqj4ְ(X&
s1c ˭( LVf
RdjQ '-1ATA>U j 4,pV"4L$ e@.ArBY a~my Y])Q8t NLܞt2"I
o=CSd)__ AF ( IENDB` administration/images/ajax-loader.gif 0000644 0023433 0004734 00000003464 11051631442 017602 0 ustar xemion psacln GIF89a FFFzzz XXX$$$666hhh !Made by AjaxLoad.info !
! NETSCAPE2.0 , w !DBAH ¬aD@ ^AXP@"UQ# B\; 1 o:2$v@
$|,3
_#
d53" s5 e! !
, v i@e9DAA/`ph$Ca%@ pHxFuSx#
.݄YfL_"
p
3BW ]|L
\6{|z87[7! !
, x e9DE"2r,qP j`8@8bH, *0-
mFW9LPE3+
(B"
f{*BW_/
@_$~Kr7Ar7! !
, v 4e9!H"* Q/@-4ép4R+-pȧ`P(6U/ *,)(+/]"lO/*Ak K]A~666! !
, l ie9" * -80H=N; TEqe UoK2_WZV1jgWe@tuH//w`?f~#6#! !
, ~ ,e9"*
; pR%#0` 'c(J@@ /1i4`VBV
u}"caNi/ ] ))- Lel mi}
me[+! !
, y Ie9"M6*¨"7E͖@G((L&pqj@Z %@wZ) pl(
ԭqu*R&c `))( s_J>_\'Gm7$+! !
, w Ie9*, (*(B5[1 ZIah!GexzJ0e6@V|U4Dm%$͛p
\G x
} @+| =+
1- Ea5l)+! !
, y )䨞'AKڍ,E\(l&;5 5D0 3a0-- ÃpH4V %
i
p[R"| #
6iZwcw*! !
, y )䨞,K*0 a;аY8b`4n ¨Bb bx ,( Ƚ %
>
2*i* /:+$v*! !
, u )䨞l[$
Jq[q 3`Q[5:IX!0rAD8 CvHPfii QAP@pC
%D
PQ46
iciNj0w
)#! !
, y ). q
,G J r( J8 C*B,&<
h W~-`, ,>;
8RN<, <1T]
c'
qk$
@)#! ; administration/images/attach.png 0000644 0023433 0004734 00000001513 11051631443 016670 0 ustar xemion psacln PNG
IHDR h pHYs gAMA o3 cHRM l ro n A 1t l- IDATxb`@ b````hhhn0 &%%30000hkk7 b(//gbbbc````HOOI0yzz
{/if}
Sent on: {$datesent|date_format:$dateformat}
