$action = $_REQUEST['act']; $error = ''; $data = ''; $par_id = $_REQUEST['par_id']; switch ($action) { case 'get_add_page': $page = GetPage(); $data = array('page' => $page); break; case 'get_cat': $page = Get_Category('', $_REQUEST['ch_ubani']); $data = array('page' => $page); break; case 'get_edit_page': $cat_id = $_REQUEST['id']; $page = GetPage(GetCategory($cat_id)); $data = array('page' => $page); break; case 'get_list': $count = $_REQUEST['count']; $hidden = $_REQUEST['hidden']; $rResult = mysql_query("SELECT\t`info`.`id`,\r\n\t `info`.`id`,\r\n \t\tIF(info.parent_id = 0,`info`.`name`,(SELECT `name` FROM `service_center` WHERE `id` = `info`.`parent_id`)),\r\n IF(info.parent_id = 0,'',(SELECT `name` FROM `service_center` WHERE `id` = `info`.`id`)),\r\n\t `branch`.`name`\r\n\t\t\t\t\t\t\t FROM\t`service_center` AS `info`\r\n\t LEFT JOIN branch ON branch.id = info.branch_id\r\n\t \t\t\t\t\t\tWHERE\t`info`.`actived` = 1"); $data = array("aaData" => array()); while ($aRow = mysql_fetch_array($rResult)) { $row = array(); for ($i = 0; $i < $count; $i++) { /* General output */ $row[] = $aRow[$i]; if ($i == $count - 1) { $row[] = '<div class="callapp_checkbox"> <input type="checkbox" id="callapp_checkbox_' . $aRow[$hidden] . '" name="check_' . $aRow[$hidden] . '" value="' . $aRow[$hidden] . '" class="check" />
function free_catgorized_save(){ $sock=new sockets(); $uuid=base64_decode($sock->getFrameWork("cmd.php?system-unique-id=yes")); if(!preg_match_all("#http.*?:\/\/(.+?)[\/\s]+#",$_POST["textToParseCats"]."\n",$re)){echo "No webistes\n";} while (list ($num, $www) = each ($re[1]) ){ $www=strtolower($www); $www=replace_accents($www); if(preg_match("#^www\.(.+?)$#i",$www,$ri)){$www=$ri[1];} $sites[$www]=$www; } $q=new mysql(); $q->CheckTable_dansguardian(); if(count($sites)==0){echo "NO websites\n";return;} $category=$_POST["category"]; echo "analyze ".count($sites)." websites into $category\n"; while (list ($num, $www) = each ($sites) ){ $md5=md5($www.$category); $sql="SELECT zmd5 FROM dansguardian_community_categories WHERE pattern='$www' AND category='$category'"; $ligne=@mysql_fetch_array($q->QUERY_SQL($sql,"artica_backup")); $sql_add="INSERT INTO dansguardian_community_categories (zmd5,zDate,category,pattern,uuid) VALUES('$md5',NOW(),'$category','$www','$uuid')"; if($ligne["zmd5"]<>null){continue;} echo "Added $www\n"; $q->QUERY_SQL($sql_add,"artica_backup"); if(!$q->ok){echo $q->mysql_error;return;} $cats=GetCategory($www); $sql="UPDATE dansguardian_sitesinfos SET category='$cats', dbpath='$cats' WHERE website='$www'"; writelogs("$sql",__FUNCTION__,__FILE__,__LINE__); $q->QUERY_SQL($sql,"artica_backup"); if(!$q->ok){echo $q->mysql_error."\n";echo $sql;} $sql="UPDATE squid_events_sites SET category='$cats' WHERE website='$www'"; writelogs("$sql",__FUNCTION__,__FILE__,__LINE__); $q->QUERY_SQL($sql,"artica_events"); if(!$q->ok){echo $q->mysql_error."\n";echo $sql;} } $sock=new sockets(); $sock->getFrameWork("cmd.php?export-community-categories=yes"); }
function GetPage($res = '') { $image = $res[image]; if (empty($image)) { $image = '0.jpg'; } $data = ' <!-- jQuery Dialog --> <div id="add-edit-prod-form-field" title="შემადგენლობა"> <!-- aJax --> </div> <div id="dialog-form"> <fieldset style="width: 300px; float: left;"> <legend>ძირითადი ინფორმაცია</legend> <table class="dialog-form-table"> <tr> <td style="width: 170px;"><label for="code">კოდი</label></td> <td> <input type="text" id="code" class="idle" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $res['code'] . '" /> </td> </tr> <tr> <td style="width: 170px;"><label for="name">დასახელება</label></td> <td> <input type="text" id="name" class="idle" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $res['name'] . '" /> </td> </tr> <tr> <td style="width: 170px;"><label for="category">კატეგორია</label></td> <td> <select id="category" class="idls">' . GetCategory($res[pos_menu_category]) . '</select> </td> </tr> <tr> <td style="width: 170px;"><label for="unit">ზომის ერთეული</label></td> <td> <select id="unit" class="idls num" style = " width: 165px !important;">' . GetSize($res[unit]) . '</select> </td> </tr> <tr> <td style="width: 170px;"><label for="unit">შენიშვნა</label></td> <td> <textarea id="comment" class="idle large" cols="30" rows="1" style="width:159px !important; height:50px !important;">' . $res['comment'] . '</textarea> </td> </tr> </table> </fieldset> <fieldset style="width: 300px; float: left; margin-left:6px !important; height:190px !important;"> <legend>პროდუქტის სურათი</legend> <table class="dialog-form-table" width="100%"> <tr> <td id="img_colum" colspan="2"> <img id="upload_img" src="media/uploads/images/production/' . $image . '"> </td> </tr> <tr><!-- Upload Image --> <td id="act"> <span> <a href="#" id="view_image" class="complate" style="float:left; margin-left:14px;">View</a> <p style="float:left; margin-left:5px;">|</p> <a href="#" id="delete_image" class="delete" style="float:left; margin-left:5px;">Delete</a> </span> </td> <td> <div class="file-uploader"> <input id="choose_file" type="file" name="choose_file" class="input" style="display: none;"> <button id="choose_button" class="center">აირჩიეთ ფაილი</button> </div> </td> </tr> </table> </fieldset> <fieldset> <legend>პროდუქტი</legend> <div class="inner-table"> <div id="dt_example" class="ex_highlight_row"> <div id="container" class="overhead_container"> <div id="button_area"> <button id="add_button_prod">დამატება</button><button id="delete_button_prod">წაშლა</button> </div> <div id="dynamic"> <table class="display" id="prod_list"> <thead> <tr id="datatable_header"> <th>ID</th> <th style="width : 100%">პროდუქტი</th> <th class="min" style="width:90px !important;">რაოდენობა</th> <th class="min" style="width:100px !important;">თვითღირებ.</th> <th class="min" style="width:90px !important;">ნამ. ფასი</th> <th class="check">#</th> </tr> </thead> <thead> <tr class="search_header"> <th class="colum_hidden"> <input type="text" name="search_id" value="ფილტრი" class="search_init" /> </th> <th> <input type="text" name="search_prod" value="ფილტრი" class="search_init" /> </th> <th></th> <th></th> <th></th> <th> <input type="checkbox" name="check-all" id="check-all-prod" style="margin-left: 13px;"> </th> </tr> </thead> </table> </div> </div> </div> </div> </fieldset> <!-- ID --> <input type="hidden" id="rec_id" value="' . $res['id'] . '" /> <input type="hidden" id="local_rec_id"/> </div> '; return $data; }
<li> <em class="w80">邀请人ID</em> <input id="invite" name="invite" value="0" class="input_ w100" type="text" /> <div class="clear warning">填写<?php echo $siteweb['siteName']; ?> 员工的推广数字ID ,并非QQ,可选填,方便专员审核。</div> </li> <li> <em class="w80">商品 ID</em> <input id="taobaoid" name="taobaoid" class="input_ w200" type="text" error="请输入商品ID!" reg="非空"/> <a id="search" class="button_y2" style="float: left;cursor: pointer;">一键获取</a> <span class="red">*</span> <div class="clear warning">填写商品宝贝ID,一键获取。(不可重复添加同一商品)</div> </li> <li> <em class="w80">商品分类</em> <select style="height: 28px; line-height: 28px;" id="goodstype" name="goodstype"> <?php foreach (GetCategory() as $Category) { ?> <option value="<?php echo $Category['id']; ?> "><?php echo $Category['name']; ?> </option> <?php } ?> </select> <?php if ($acid == 2) { echo '<div style="display:none"> ';
function fillSitesInfos(){ $sql="SELECT website FROM dansguardian_sitesinfos WHERE LENGTH(dbpath)=0"; $q=new mysql(); $results=$q->QUERY_SQL($sql,"artica_backup"); while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){ $ligne["website"]=trim($ligne["website"]); if($ligne["website"]==null){continue;} $cat=trim(GetCategory($ligne["website"])); if($GLOBALS["VERBOSE"]){echo "{$ligne["website"]} = \"$cat\"\n";} if($cat<>null){ echo "Starting......: Artica database update {$ligne["website"]} to $cat\n"; $sql="UPDATE dansguardian_sitesinfos SET dbpath='$cat' WHERE website='{$ligne["website"]}'"; $q->QUERY_SQL($sql,"artica_backup"); } } }
function GetPage($res = '') { $image = $res[image]; if (empty($image)) { $image = '0.jpg'; } $data = ' <div id="dialog-form"> <fieldset style="width: 350px; float: left;"> <legend>ძირითადი ინფორმაცია</legend> <table class="dialog-form-table"> <tr> <td style="width: 170px;"><label for="code">კოდი</label></td> <td> <input type="text" id="code" class="idle" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $res['code'] . '" /> </td> </tr> <tr> <td style="width: 170px;"><label for="name">დასახელება</label></td> <td> <input type="text" id="name" class="idle" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $res['name'] . '" /> </td> </tr> <tr> <td style="width: 170px;"><label for="category">კატეგორია</label></td> <td> <select id="category" class="idls">' . GetCategory($res[category]) . '</select> </td> </tr> <tr> <td style="width: 170px;"><label for="unit">ზომის ერთეული</label></td> <td> <select id="unit" class="idls num" style="width: 165px !important;">' . GetSize($res[unit]) . '</select> </td> </tr> <tr> <td style="width: 170px;"><label for="unit">მინ. რაოდენობა</label></td> <td> <input type="text" id="min" class="idle" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $res['min_amount'] . '" /> </td> </tr> <tr> <td style="width: 170px;"><label for="unit">შენიშვნა</label></td> <td> <textarea id="comment" class="idle large" cols="30" rows="1" style="width:159px !important; height:50px !important;">' . $res['comment'] . '</textarea> </td> </tr> </table> </fieldset> <fieldset style="width: 350px;"> <legend>პროდუქტის სურათი</legend> <table class="dialog-form-table" width="100%"> <tr> <td id="img_colum" colspan="2"> <img id="upload_img" src="media/uploads/images/production/' . $image . '"> </td> </tr> <tr><!-- Upload Image --> <td id="act"> <span> <a href="#" id="view_image" class="complate">View</a> | <a href="#" id="delete_image" class="delete">Delete</a> </span> </td> <td> <div class="file-uploader"> <input id="choose_file" type="file" name="choose_file" class="input" style="display: none;"> <button id="choose_button" class="center">აირჩიეთ ფაილი</button> </div> </td> </tr> </table> </fieldset> <div class="clear"></div> <!-- ID --> <input type="hidden" id="prod_id" value="' . $res['id'] . '" /> </div> '; return $data; }
function BuildEmptyCategories() { $unix = new unix(); $table = "Kav4Proxy_" . date("Ym"); $sql = "SELECT sitename FROM {$table} WHERE LENGTH( category ) = 0 GROUP BY sitename"; $q = new mysql(); $results = $q->QUERY_SQL($sql, "artica_events"); if (!$q->ok) { if ($GLOBALS["VERBOSE"]) { echo "{$q->mysql_error}\n"; return; } $unix->send_email_events("Kav4Proxy:[statistics] MySQL statistics error", "{$q->mysql_error}\n{$sql}\n", "proxy"); return; } $t1 = time(); $count = mysql_num_rows($results); $c = 0; while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { $sitename = $ligne["sitename"]; $cat = GetCategory($sitename); if ($cat != null) { $cat = str_replace("forum,forums", "forums", $cat); $sql = "UPDATE `{$table}` SET `category`='{$cat}' WHERE `sitename`='{$sitename}'"; $q->QUERY_SQL($sql, "artica_events"); if (!$q->ok) { $unix->send_email_events("Kav4Proxy:[statistics] MySQL statistics error ", "Errors: {$sql}\n{$q->mysql_error}\nTable {$table}, database artica_events", "proxy"); return; } $q->QUERY_SQL("UPDATE `kav4proxyDays` SET `category`='{$cat}' WHERE `websites`='{$sitename}'", "artica_events"); $q->QUERY_SQL("UPDATE `kav4proxyVirus` SET `category`='{$cat}' WHERE `sitename`='{$sitename}'", "artica_events"); $c++; } } if ($c > 0) { $distanceOfTimeInWords = $unix->distanceOfTimeInWords($t1, time()); $unix->send_email_events("Kav4Proxy:[statistics] MySQL statistics {$c}/{$count} categorized for {$table} table", "took {$distanceOfTimeInWords}", "proxy"); } }
<?php include_once dirname(__FILE__) . '/ressources/class.templates.inc'; include_once dirname(__FILE__) . '/ressources/class.ldap.inc'; include_once dirname(__FILE__) . '/ressources/class.users.menus.inc'; include_once dirname(__FILE__) . '/ressources/class.artica.inc'; include_once dirname(__FILE__) . '/ressources/class.rtmm.tools.inc'; include_once dirname(__FILE__) . '/ressources/class.squid.inc'; include_once dirname(__FILE__) . '/ressources/class.dansguardian.inc'; include_once dirname(__FILE__) . '/ressources/class.ccurl.inc'; include_once dirname(__FILE__) . '/framework/class.unix.inc'; include_once dirname(__FILE__) . '/framework/frame.class.inc'; include_once dirname(__FILE__) . "/ressources/class.categorize.externals.inc"; if ($argv[1] = "--scan") { GetCategory($argv[2], $argv[3]); exit; } $array["casinos"] = "gamble"; $array["chaines-tv-internet"] = "webtv"; $array["telecharger-films"] = "movies"; $array["arnaque-escroquerie-par-email"] = "mailing"; $array["escroquerie-faux-anti-virus"] = "malware"; $array["tabac"] = "tobacco"; $array["contrefacon"] = "suspicious"; function GetCategory($source, $dest) { for ($i = 1; $i < 13; $i++) { echo "Checking page number {$i}\n"; $curl = new ccurl("http://cacaweb.com/category/{$source}/page/{$i}"); $curl->NoHTTP_POST = true; $curl->UserAgent = "Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:10.0) Gecko/20100101 Firefox/10.0";
function GetCategory($uri) { $CATZ["business"] = "industry"; $CATZ["advertising"] = "publicite"; $CATZ["search engines and portals"] = "searchengines"; $CATZ["unrated"] = ""; $CATZ["global"] = ""; $CATZ["finance"] = "financial"; $CATZ["news and media"] = "news"; $CATZ["pornography"] = "p**n"; $CATZ["education"] = "recreation/schools"; $CATZ["personal websites and blogs"] = "blog"; $CATZ["shopping and auction"] = "shopping"; $CATZ["sports"] = "recreation/sports"; $CATZ["real estate"] = "finance/realestate"; $CATZ["reference"] = "dictionaries"; $CATZ["information technology"] = "science/computing"; $CATZ["restaurant and dining"] = "recreation/nightout"; $CATZ["weapons"] = "weapons"; $CATZ["personal vehicles"] = "automobile/cars"; $CATZ["health and wellness"] = "health"; $CATZ["travel"] = "recreation/travel"; $CATZ["lingerie and swimsuit"] = "sex/lingerie"; $CATZ["freeware and software downloads"] = "downloads"; $CATZ["advocacy organizations"] = "justice"; $CATZ["entertainment"] = "hobby/other"; $CATZ["finance and banking"] = "finance/banking"; $CATZ["content servers"] = "science/computing"; $CATZ["web hosting"] = "isp"; $CATZ["arts and culture"] = "hobby/arts"; $CATZ["newsgroups and message boards"] = "forums"; $CATZ["society and lifestyles"] = "society"; $CATZ["malicious websites"] = "malware"; $CATZ["meaningless content"] = "society"; $CATZ["government and legal organizations"] = "governments"; $CATZ["general organizations"] = "associations"; $CATZ["social networking"] = "socialnet"; $CATZ["alcohol"] = "alcohol"; $CATZ["job search"] = "jobsearch"; $CATZ["games"] = "games"; $CATZ["illegal or unethical"] = "suspicious"; $CATZ["web-based applications"] = "webapps"; $CATZ["web-based email"] = "webmail"; $CATZ["domain parking"] = "reaffected"; $CATZ["gambling"] = "gamble"; $CATZ["dynamic content"] = "redirector"; $CATZ["other adult materials"] = "mixed/adult"; $CATZ["proxy avoidance"] = "proxy"; $CATZ["armed forces"] = "weapons"; $CATZ["secure websites"] = "sslsites"; $CATZ["file sharing and storage"] = "filehosting"; $CATZ["streaming media and download"] = "audio-video"; $CATZ["sex education"] = "sexual_education"; $CATZ["abortion"] = "abortion"; $CATZ["nudity and risque"] = "mixed/adult"; $CATZ["dating"] = "dating"; $CATZ["marijuana"] = "drugs"; $CATZ["tobacco"] = "tobacco"; $CATZ["explicit violence"] = "violence"; $CATZ["internet radio and tv"] = "webradio"; $CATZ["folklore"] = ""; $CATZ["global religion"] = "religion"; $CATZ["political organizations"] = "politic"; $CATZ["child education"] = "children"; $CATZ["brokerage and trading"] = "stockexchange"; $CATZ["digital postcards"] = "gifts"; $CATZ["instant messaging"] = "chat"; $CATZ["hacking"] = "hacking"; $CATZ["internet telephony"] = "webphone"; $CATZ["phishing"] = "phishing"; $CATZ["spam urls"] = "mailing"; $CATZ["medicine"] = "medical"; $CATZ["sports hunting and war games"] = "violence"; $curl = new ccurl($uri); $curl->noproxyload = true; $curl->NoHTTP_POST = true; $curl->ArticaProxyServerEnabled = "no"; $curl->interface = "10.32.0.36"; $curl->Timeout = 5; if (!$curl->get()) { if (preg_match("#Category:\\s+([A-Za-z\\_\\-0-9\\s]+)#is", $curl->orginal_data, $re)) { $category = trim(strtolower($re[1])); if ($category == "unrated") { return null; } $newcategory = $CATZ[$category]; if ($newcategory == null) { echo "{$uri} \"{$category}\" not translated\n"; return 1; } return $newcategory; } echo $curl->orginal_data; } if (isset($curl->CURL_ALL_INFOS["redirect_url"])) { $curl->CURL_ALL_INFOS["redirect_url"] = trim($curl->CURL_ALL_INFOS["redirect_url"]); if ($curl->CURL_ALL_INFOS["redirect_url"] != null) { $GLOBALS["COUNTTR"]++; if ($GLOBALS["COUNTTR"] < 4) { return GetCategory($curl->CURL_ALL_INFOS["redirect_url"]); } } } return null; }
function save_category(){ $www=trim(strtolower(base64_decode($_GET["website"]))); if(preg_match("#^www\.(.+?)$#i",$www,$re)){$www=$re[1];} $category=$_GET["category"]; $md5=md5($www.$category); $sock=new sockets(); $uuid=base64_decode($sock->getFrameWork("cmd.php?system-unique-id=yes")); $enabled=$_GET["enabled"]; $sql="SELECT zmd5 FROM dansguardian_community_categories WHERE pattern='$www' AND category='$category'"; $q=new mysql(); $q->CheckTable_dansguardian(); $ligne=@mysql_fetch_array($q->QUERY_SQL($sql,"artica_backup")); $sql_add="INSERT INTO dansguardian_community_categories (zmd5,zDate,category,pattern,uuid) VALUES('$md5',NOW(),'$category','$www','$uuid')"; $sql_edit="UPDATE dansguardian_community_categories SET enabled='$enabled' WHERE category='$category' AND pattern='$www'"; writelogs("$www/$category = {$ligne["zmd5"]}",__FUNCTION__,__FILE__,__LINE__); if($ligne["zmd5"]==null){$q->QUERY_SQL($sql_add,"artica_backup");} else{ writelogs("$sql_edit",__FUNCTION__,__FILE__,__LINE__); $q->QUERY_SQL($sql_edit,"artica_backup"); } if(!$q->ok){ echo $q->mysql_error; return; } $cats=GetCategory($www); $sql="UPDATE dansguardian_sitesinfos SET category='$cats', dbpath='$cats' WHERE website='$www'"; writelogs("$sql",__FUNCTION__,__FILE__,__LINE__); $q->QUERY_SQL($sql,"artica_backup"); if(!$q->ok){ echo $q->mysql_error."\n"; echo $sql; } $sql="UPDATE squid_events_sites SET category='$cats' WHERE website='$www'"; writelogs("$sql",__FUNCTION__,__FILE__,__LINE__); $q->QUERY_SQL($sql,"artica_events"); if(!$q->ok){ echo $q->mysql_error."\n"; echo $sql; } $sock=new sockets(); $sock->getFrameWork("cmd.php?export-community-categories=yes"); }
function FillCategories(){ $unix=new unix(); $cachetime="/etc/artica/postfix/pids/".basename(__FILE__).".".__FUNCTION__.".time"; if($cachetime>2880){ $sql="SELECT websites FROM `squid_events_sites_day` GROUP BY websites"; }else{ $sql="SELECT websites FROM `squid_events_sites_day` WHERE LENGTH( category ) =0 GROUP BY websites"; } $q=new mysql(); $results=$q->QUERY_SQL($sql,"artica_events"); if(!$q->ok){ if($GLOBALS["VERBOSE"]){echo $q->mysql_error."\n";} $unix->send_email_events("Error: Web Proxy Category statistics ","Errors: $sql\n$q->mysql_error","proxy"); return; } @unlink($cachetime); @file_put_contents($cachetime,"#"); while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){ $website=$ligne["websites"]; $cat=GetCategory($website); if($cat<>null){ $sql="UPDATE `squid_events_sites_day` SET `category`='$cat' WHERE `websites`='$website'"; $q->QUERY_SQL($sql,"artica_events"); if(!$q->ok){ $unix->send_email_events("Error: Web Proxy Category statistics ","Errors: $sql\n$q->mysql_error\nTable squid_events_sites_day, database artica_events","proxy"); return; } $sql="UPDATE `squid_events_clients_sites` SET `category`='$cat' WHERE `websites`='$website'"; $q->QUERY_SQL($sql,"artica_events"); if(!$q->ok){ $unix->send_email_events("Error: Web Proxy Category statistics ","Errors: $sql\n$q->mysql_error\nTable squid_events_clients_sites, database artica_events","proxy"); return; } } } }