public function attemptDetails($id) { $attempt = Attempt::find($id); $category = Category::find($attempt->category_id) ? Category::find($attempt->category_id)->name : 'N/A'; $similar_domains = Domain::where('url', 'LIKE', '%' . $attempt->url . '%')->get(); return View::make('admin.attempt_details')->with(compact('attempt', 'category', 'similar_domains')); }
public function searchAjax() { $response = ''; $search_term = trim(e(Input::get('search_term'))); $domains = Domain::where('status', 1)->where('name', 'LIKE', '%' . $search_term . '%')->orWhere('url', 'LIKE', '%' . $search_term . '%')->orWhere('description', 'LIKE', '%' . $search_term . '%')->take(5)->get(['id', 'name', 'thumb']); if (count($domains)) { foreach ($domains as $domain) { $domain_name = strlen($domain->name) > 30 ? substr($domain->name, 0, 30) . '...' : $domain->name; $response .= '<div class="search-box"> <a class="search-result-row" href="' . Domain::seoURL($domain->id) . '"> <div class="col-lg-5 col-md-5 col-sm-5 col-xs-5"> <img class="img img-responsive thumbnail" src="' . URL::asset('assets/thumbs/' . $domain->thumb) . '" alt="site preview" /> </div> <div class="col-lg-7 col-md-7 col-sm-7 col-xs-7"> ' . $domain_name . ' </div> <div class="clearfix"></div> </a> </div>'; } } else { $response .= '<p>' . Lang::get('general.no_results', ['serch_term' => $search_term]) . '</p>'; } print $response; }
public static function insertSkipDupes($domains) { $query = sprintf('INSERT INTO domains (name) VALUES ("%s") ON DUPLICATE KEY UPDATE name=name', implode('"),("', $domains)); $status = DB::statement($query); Domain::where('created_at', '0000-00-00 00:00:00')->update(['created_at' => DB::raw('NOW()')]); Domain::where('created_at', '0000-00-00 00:00:00')->update(['updated_at' => DB::raw('NOW()')]); return $status; }
/** * Show the form for creating a new resource. * * @return Response */ public function getAdd() { $users = array(); if (Auth::user()->status == 2) { foreach (User::whereStatus(3)->get() as $user) { $users[$user['id']] = $user['username']; } } foreach (explode(",", str_replace(" ", "", Config::get('settings.available_css'))) as $css) { $available_css[$css] = $css; } if (Domain::where('user_id', Auth::user()->id)->count() >= Config::get('settings.domain_limit')) { return Output::push(array('path' => 'domain', 'messages' => array('fail' => _('You have reached limit domain')))); } return View::make('domain.create')->with('users', $users)->with('available_css', $available_css); }
public function action_query($domain) { $domain = strtolower($domain); $index_alpha = Sitemap::get_filters(); Log::write('check', 'whois: ' . $domain); //Cache::forget('whois.'.$domain); $whois = Cache::remember('whois.' . $domain, function () use($domain) { return new Whois\Whois($domain); }, 60 * 24); $data = $whois->get_all_data(); if ($data === 0) { $valid = 0; } else { $valid = $data[0]->valid(); } if (!$valid) { return View::make('whois.index')->with('valid', 0)->with('type', 'whois')->with('title', 'WHOIS Search')->with('index_alpha', $index_alpha); } $data = $whois->email_mask($data); $available = $whois->available(); $domain = $data[sizeof($data) - 1]; $domain = $domain->get_query_domain(); $meta = array('title' => '', 'ip' => ''); if ($valid && !$available) { if (!Domain::where('name', '=', $domain)->first()) { @Domain::create(array('name' => $domain)); } $meta['title'] = Domain::get_domain_title($domain); $ip = gethostbyname($domain); if ($ip != $domain) { $meta['ip'] = $ip; } } $expires_on = $whois->expires_on(); $created_on = $whois->created_on(); $updated_on = $whois->updated_on(); if (is_numeric(end($data)->get_body())) { Cache::forget('whois.' . $domain); } return View::make('whois.query', array('i' => 1, 'data' => $data, 'meta' => $meta, 'type' => 'whois', 'valid' => $valid, 'domain' => $domain, 'available' => $available, 'expires_on' => $expires_on, 'created_on' => $created_on, 'updated_on' => $updated_on, 'index_alpha' => $index_alpha, 'title' => $domain . '\'s whois info')); }
public function approveHandle($id) { $domain = Domain::find($id); $domain->status = 1; $domain->save(); $next_domain = Domain::where('status', 0)->first(); if ($next_domain) { $name = Domain::seoURL($next_domain->id); return $this->details($name, $next_domain->id); } return Redirect::route('home')->with('success', 'Yoohoo you\'re done!'); }
<?php echo '<?xml version="1.0" encoding="UTF-8"?>'; ?> <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xhtml="http://www.w3.org/1999/xhtml"> <?php $domains = Domain::where('status', 1)->orderBy('updated_at', 'DESC')->get(['id', 'updated_at']); if ($domains) { foreach ($domains as $domain) { $ro_url = LaravelLocalization::getLocalizedURL('ro', Domain::seoURL($domain->id), 'ro'); $en_url = LaravelLocalization::getLocalizedURL('en', Domain::seoURL($domain->id), 'en'); ?> <url> <loc><?php echo $ro_url; ?> </loc> <xhtml:link rel="alternate" hreflang="ro" href="<?php echo $ro_url; ?> " /> <xhtml:link rel="alternate" hreflang="en" href="<?php echo $en_url; ?> " /> <priority>1</priority> <lastmod><?php echo date('c', strtotime($domain->updated_at)); ?> </lastmod>
{{ $format_anchor($last_visited->name) }} </a> </p> <p>{{ trans('directory.domains_statistics_all') }}: {{ count(Domain::all()) }}</p> <p>{{ trans('directory.pending_domains') }}: {{ count(Domain::where('status', 0)->get()) }}</p> <p>{{ trans('directory.categories') }}: {{ count(Category::all()) }}</p> </div> <div class="col-lg-4 col-md-4 col-sm-4 col-xs-12"> <?php $prefered_domain = Domain::where('status', 1)->where('created_at', '>', \Carbon\Carbon::today())->orderBy('created_at')->first(); // if('5.2.200.90' == $_SERVER['REMOTE_ADDR']) // { // var_dump($prefered_domain->name); // } if (!$prefered_domain) { $prefered_domain = Domain::where('status', 1)->orderBy('created_at', 'DESC')->first(); } ?> <h4>Promovat</h4> <a class="a-no-dec" href="{{ Domain::seoURL($prefered_domain->id) }}"> <div class="weekly-promoted"> <p>{{ $prefered_domain->name }}</p> <p class="grey">{{ substr($prefered_domain->description, 0, 150) }} {{ trans('general.more') }}</p> </div> </a> </div> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 text-center"> Copyright © {{ date('Y'), ' ', Lang::get('general.main-url') }} </div> <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 text-center"> <a href="{{ URL::route('terms') }}">{{ trans('general.terms') }}</a>
<?php include __DIR__ . '/../start.php'; use Illuminate\Database\Capsule\Manager as DB; $total = Domain::count(); $totalCompleted = Domain::where('status', 'finished')->count(); $page = isset($_GET['page']) == true ? $_GET['page'] : 1; $perPage = 100; $totalPages = floor($total / $perPage); $sortBy = isset($_GET['sortBy']) == true ? $_GET['sortBy'] : 'tf'; $sortType = isset($_GET['sortType']) == true ? $_GET['sortType'] : 'desc'; $domains = Domain::take($perPage)->skip($perPage * ($page - 1))->orderBy($sortBy, $sortType)->get(); $newSortType = $sortType == 'desc' ? 'asc' : 'desc'; ?> <!DOCTYPE html> <html> <head> <title>Domain Metrics Checker</title> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap-theme.min.css"> <link rel="stylesheet" href="assets/style.css"> </head> <body> <?php include __DIR__ . '/menu.php'; ?> <div class='container'> <div class='clearfix'> <h2 class='pull-left'>Total <?php echo _e($total);
Route::get('domains/pending', ['as' => 'domains-pending', 'uses' => 'AdminController@getPendingDomains']); Route::get('domains/attempts', ['as' => 'domains-attempts', 'uses' => 'AdminController@getAttempts']); Route::get('attempt/{id}', ['as' => 'attempt.details', 'uses' => 'AdminController@attemptDetails']); Route::get('attempt-add/{id}', ['as' => 'attempt.add', 'uses' => 'AdminController@attemptAdd']); Route::get('attempt/delete/{id}', ['as' => 'attempt.delete', 'uses' => 'AdminController@attemptDelete']); Route::get('comments-all', ['before' => 'auth', 'uses' => 'AdminController@allComments', 'as' => 'comments-all']); }); }); Route::post('vote', ['as' => 'vote.site', 'uses' => 'DomainsController@vote']); Route::get('get/site/votes/{type}/{id}', ['as' => 'get.site.votes', function ($type, $id) { return Domain::find($id)->{$type}; }]); Route::post('search', ['as' => 'search.post', 'uses' => 'HomeController@searchAjax']); Route::get('generate-sitemap', function () { ini_set('memory_limit', '2048M'); $domains = Domain::where('status', 1)->get(['id', 'updated_at']); $categories = Category::where('status', 1)->get(['path', 'updated_at']); $langs = LaravelLocalization::getSupportedLocales(); // create new sitemap object $sitemap = App::make("sitemap"); // set cache (key (string), duration in minutes // (Carbon|Datetime|int), turn on/off (boolean)) // by default cache is disabled //$sitemap->setCache('laravel.sitemap', 3600); $i = 0; $ci = 0; foreach ($domains as $domain) { $translations = array(array('url' => LaravelLocalization::getLocalizedURL('ro', Domain::seoURL($domain->id), 'ro'), 'language' => 'ro'), array('url' => LaravelLocalization::getLocalizedURL('en', Domain::seoURL($domain->id), 'en'), 'language' => 'en')); foreach ($langs as $lang_code => $lang_details) { $sitemap->add(LaravelLocalization::getLocalizedURL($lang_code, Domain::seoURL($domain->id)), date('c', strtotime($domain->updated_at)), 1.0, 'daily', null, null, $translations); }
<?php include __DIR__ . '/../../start.php'; use Illuminate\Database\Capsule\Manager as DB; $config = (include __DIR__ . '/../../config/bots.php'); $bot = new Bot($config['majestic']['cookie']); if (!isset($argv[1]) or !($domainList = json_decode($argv[1]))) { die('Invalid argument!' . PHP_EOL); } $domains = []; foreach ($domainList as $key => $domain) { $domains[$domain->name] = $domain->id; $domainList[$key] = $domain->name; } $results = $bot->check($domainList); foreach ($results as $name => $metrics) { if (isset($domains[$name]) && isset($metrics['tf']) && isset($metrics['cf']) && $metrics['tf'] >= 0 && $metrics['cf'] >= 0) { if ($metrics['niche'] == '') { $metrics['niche'] = 'N/A'; } Domain::where('id', $domains[$name])->update(['tf' => $metrics['tf'], 'cf' => $metrics['cf'], 'rd' => $metrics['rd'], 'tf' => $metrics['tf'], 'topical' => $metrics['niche'], 'status' => 'finished']); } } echo PHP_EOL . PHP_EOL . PHP_EOL . PHP_EOL . PHP_EOL . 'Finish' . PHP_EOL;
private function _getUserId($email) { $domain = Domain::where('domain', Request::getHttpHost())->first(); $user = User::where('email', $email)->where('domain_id', $domain['id'])->first(); return $user['id']; }
public function getFilterori() { if (Request::segment(2) == 'filter') { $input = Session::get('search') && !Input::get('search_category') ? Session::get('search') : Input::only(array('search_category', 'search_keyword')); switch ($input['search_category']) { case '0': return Redirect::to('domain'); break; case 'owner': $domains = Domain::whereHas('user', function ($q) { $q->where('username', 'LIKE', '%' . Input::get('search_keyword') . '%'); })->get(); break; default: if (Auth::user()->status == 2) { $domains = Domain::where($input['search_category'], 'LIKE', '%' . $input['search_keyword'] . '%')->get(); } else { $domains = Domain::where('user_id', Auth::user()->id)->where($input['search_category'], 'LIKE', '%' . $input['search_keyword'] . '%')->get(); } break; } Session::set('search', $input); } else { Session::remove('search'); $input = array('search_category' => '', 'search_keyword' => ''); $domains = Auth::user()->status == 2 ? Domain::all() : Domain::where('user_id', Auth::user()->id)->get(); } return View::make('domain.index')->with('domains', $domains)->with('selected', $input); }
private function _getDomainsId($user_id) { if (Domain::where('user_id', $user_id)->exists()) { $domains = Domain::where('user_id', $user_id)->get(['id']); $domains_temp = $domains->toArray(); $domainids = []; foreach ($domains_temp as $doms) { array_push($domainids, $doms['id']); } return $domainids; } else { return false; } }