Posts by Stefce

this is the website i was talking about that at the checkout was $1800

I solved it with dynamic sitemaps and as i have read on google docs these kind of sitemaps are way better than static ones because they get updated automatically when some link is inserted or updated.

Here is the code for sitemap1 which selects the first 40k lines from DB. And i have 3 more sitemaps with 40k lines each.

<?php 
require_once("../core/core.php");

$query = "SELECT url, posttime FROM tablename LIMIT 40000";
$result = $conn->query($query);
//$result = mysqli_query($connect, $query);

$base_url = "http://domain.com/sitemap/";

header("Content-Type: application/xml; charset=utf-8");

echo '<?xml version="1.0" encoding="UTF-8"?>'.PHP_EOL; 

echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">' . PHP_EOL;

while($row = mysqli_fetch_array($result))
{
 echo '<url>' . PHP_EOL;
 echo '<loc>'.$base_url. $row["url"] .'/</loc>' . PHP_EOL;
 echo '<lastmod>'.$row['posttime'].'</lastmod>' . PHP_EOL;
 echo '<changefreq>daily</changefreq>' . PHP_EOL;
 echo '</url>' . PHP_EOL;
}

echo '</urlset>' . PHP_EOL;

?>

and here is the .htaccess code that converts sitemap.php into sitemap.xml (this file needs to be inside the folder where the sitemaps are)

RewriteEngine ON

#show sitemap file with .xml
RewriteRule ^sitemap1\.xml/?$ sitemap1.php

Its build with PHP and yes the links are generated from database input

Question is solved.
The solution is:

RewriteEngine ON
##External redirect rules here.
RewriteCond %{THE_REQUEST} \s/(folder)/index\.php\?name=(\S+)\s [NC]
RewriteRule ^ /%1/%2? [R=301,L]

##Internal rewrite rules from here...
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^([^/]*)/([^/]*)/?$ $1/index.php?name=$2 [QSA,L]

Nope it doesn't work. It displays error "No profile found in this URL"
Wrong SQL: SELECT ID, name, url, profilepic, tags FROM modelprofile WHERE url = 'index.php'

this code works but only with alphanumeric words and not with symbols in the word

Options +FollowSymLinks
RewriteEngine on
RewriteRule ^([a-z0-9]+)/([a-z0-9]+)$     $1/index.php?name=$2 [L]

iI was searching the online "free/cheap" generators and i found out that they are not so cheap...
They advertise the PRO plan for just $3 and when i came to the checkout page it was $1800
So is there other free tool for this job or how do i manually create the sitemap my self. I read on google that one sitemap file should contain no more than 50k links. So in this case i should create sitemap index file.

Any recommendations ?

You can go with
https://plausible.io
Very very fast and lightweight

Now the .htaccess file is empty because i was not able to find the correct answer. And i have changed the folder name from model-profile to onewordname. I find it better for SEO purpose

I changed the folder model-profile into leaks
Anybody who want post a reply the link should look like this
https://domain.com/leaks/modelName

Try like this

if($expiry==0) { 
    echo "We're sorry but your contract has expired. Contact us immediately at propzmgmt@gmail.com"; 
} elseif($expiry >= 1) { 
    header("location:sysnav.html"); 
} 

And format the SQL correctly

$sql = "UPDATE `ctltbl` SET '$expiry' = `expiry` - 1 WHERE `id` = $id";

maybe somebody else have some solution about this problem?

WOW @Dani made the notification feature faster than Elon ruined twitter :D
Great job @dani :D

@rproffitt

So now it's filling with porn, Nazis and Qbots.

He just tweeted that the new tweeter policy will be freedom of speech, but not freedom of reach.
Negative/Hate tweets will be deboosted & demonetized.

You won't find the tweet unless you specifically seek it out. Which is no different from the rest of Internet.

Yes here is my exact code in the .htaccess file

Options +FollowSymLinks
RewriteEngine on
RewriteRule ^model-profile/(.+)$     model-profile/index.php?name=$1 [L]

And i would like to suggest a feature to be added in the forum "notification center/icon"
When somebody replied to a thread i posted or opened i should get an notification :)

For getting the job done and knowledge. Been posting here for years now.
I am glad i have found this place back than :)
BTW just mine two cents.
I think we should open a section for making money online
Since no forum out there have these two combined. (coding & making money)
And i think here have fair amount of people who are trying to achieve financial freedom from home.

I am just here to bumb this thread with this video

https://youtu.be/bheHjqvkaaI?t=83

I have questions.

1. You want to make bot for adding followers to profiles
2. You want to make bot for following other users followers

There are few tricks with this job so you don't have to develop from 0

Now i have different problem... when i click some model url.. it redirects me to next page with the correct url format but somehow the sql query cannot find the model
It gives me this error

Fatal error: Wrong SQL: SELECT ID, name, url, profilepic, tags FROM modelprofile WHERE url = 'index.php' Error: in /home/appunloc/leakedof.us/model-profile/index.php on line 34
No profile found in this URL, please make sure it is the correct URL in the address bar!

Here is how i am getting the name parameter in the url at the beggining of the page

<?php
    $profile = $_GET['name'];

    if ($profile == null) {
      header("Location: ../index.php");
    }

$sql = "SELECT ID, name, url, profilepic, tags FROM modelprofile WHERE url = '$profile'"; 
$result = $conn->query($sql);
if(!$result){
  trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR);
  echo "Something went wrong, please try again.";
} else {
  if($result->num_rows == 0){
      trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR);
      echo "No profile found in this URL, please make sure it is the correct URL in the address bar!";
  }
?>

This actually works but it has a problem, when i open some of the links error page 404, usually the usernames that have ('.', '_', '-')

https://example.com/model-profile/blondie.sabrina
https://example.com/model-profile/sugar_daddy53
https://example.com/model-profile/woof-n-oink
These usernames have that problem. But when you visit them with the old way they work
https://example.com/model-profile/index.php?name=blondie.sabrina
https://example.com/model-profile/index.php?name=sugar_daddy53
https://example.com/model-profile/index.php?name=woof-n-oink

Please take a look at the website and try to open some of the profiles and you will see that some url's work and some dont. I have removed all the images i have placed this as a example image https://via.placeholder.com/350

Thank you very much for the help

I got reply from customer support saying that i need to:

"As this is a code-related issue, we have limitations to help you with. Please setup the code htaccess rule for it."

Its weird because this code again doesn't work. I copied and pasted exactly as you wrote it.
The path is automatically specified i contacted the support

Anyone can help me ?

I am sorry i cannot edit the answer above.
I just got reply from the admins of the hosting provider that is actually litespeed
I don't really understand whats the difference. But i need this URL shortened for SEO purposes.
Thank you all DANIWEB community

I just found out that i am using Apache

I am not sure how do i answer that question between Apache and Nginx :S

I am using cPanel and FileManager. I have these lines of code in my htaccess file
RewriteEngine on RewriteRule ^model-profile/(.*)$ https://leakedof.us/model-profile/index.php?name=$1 [L]

the exact url for the model profile is this
https://leakedof.us/model-profile/index.php?name=fitbryceadams

Feel free to visit the website there is 0 nudity. Its a fake website for "leaks"

BTW the website is hosted on KnownSRV.com

Thank you for your reply but this is redirecting me to a link like this
https://leakedof.us/model-profile/index.php?name=index.php

Which than gives me error "Model profile not found!"

I have a domain that looks like this when i visit certain link https://domain.com/model-profile/index.php?name=abbychampion
the site is written in php but i dont want to show this part index.php?name= because for SEO purposes and better human reading.
Is this possible to hide ? so the link looks like this https://domain.com/model-profile/abbychampion

I found even smaller HTML code inside the website i want to scrape

<span data-v-7102f77e="" class="b-profile__sections__count"> 57 </span>

Only this will be enough info to scrape about the user
The website is onlyfans.com/[username] and the above html code is loading on every profile visited, but its not unique.

I see there are few more <span> tags with the same class and data-v-7102f77e=""

How do i request a crawl on that link (to get the data) when user from my website opens the same girl/model? I have the models [username] stored in Database.

I want to get a string from different website and to display on mine.

The website have this HTML code inside it

<ul data-v-61cbae47="" class="b-tabs__nav m-tabs-default m-flex-width m-size-md m-mb-reset js-tabs-switchers m-over-separator">
   <li data-v-61cbae47="" class="b-tabs__nav__item m-current"><a data-v-61cbae47="" href="/jenawolfy" aria-current="page" class="b-tabs__nav__link m-with-rectangle-hover m-tb-sm router-link-exact-active router-link-active" id="profilePostTab"><span data-v-61cbae47="" class="b-tabs__nav__link__counter-title">130 posts</span></a></li>
   <li data-v-61cbae47="" class="b-tabs__nav__item"><a data-v-61cbae47="" href="/jenawolfy/media" class="b-tabs__nav__link m-with-rectangle-hover m-tb-sm"><span data-v-61cbae47="" class="b-tabs__nav__link__counter-title">132 Media</span></a></li>
   <!---->
</ul>

I want to get only these two strings 130 posts & 132 Media and to display on my website whenever is opened.

Is this possible to make in PHP or i need different language like python?

Wow very detailed answer thank you

How do you test this stuff to get the info you provided above?

Oh sorry i removed the 2nd while loop and it works. BIG thanks

Thank you for your answer but this doesnt solve. It again crashing my browser

OFF TOPIC
Through the years i asked so many questions here but never considered donating. Now, I promise if i succeed with this method, i am gonna pay a whole year hosting + donate;
Since i am seeing guys making crazy money per day with this method i though ill give it a try.

I am trying to make to display cells in a database that are not empty, i have URL links with images inside the table and i want to display only the cells that are not empty.

For example if there is only 2 pictures added in the database i want to display only those 2, and not the rest 3 with no images

I have this code but its going on forever and its crashing my browser.

<?php
$sql = "SELECT pic1, pic2, pic3, pic4, pic5 FROM modelprofile WHERE name='$name'";
$result = $conn->query($sql);

if($result === false) {
    trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR);
} else {
    while($row = $result->fetch_assoc()) {
        $pic1 = $row["pic1"];
        $pic2 = $row["pic2"];
        $pic3 = $row["pic3"];
        $pic4 = $row["pic4"];
        $pic5 = $row["pic5"];
        while(!empty($row)) {


        ?>
        <img class="card-img-top" src="<?= $pic1 ?>" alt="">
        <br><br>
        <img class="card-img-top" src="<?= $pic2 ?>" alt="">
        <br><br>
        <img class="card-img-top" src="<?= $pic3 ?>" alt="">
        <br><br>
        <img class="card-img-top" src="<?= $pic4 ?>" alt="">
        <br><br>
        <img class="card-img-top" src="<?= $pic5 ?>" alt="">
        <br><br><br>

        <?php
        }
    }
}
?>

There are no errors shown after i added the code in the core.php

BTW as you can see, at the bottom of the button it says " doesnt exist " without button is pressed, when you visit the website.

**

**

The problem was the sql query i got earlier?

But i have weird database INPUT tho. Look at the Primary ID in the table. why does it started to count column 50 from the 46 column and on ....

Here is a picture

https://prnt.sc/I6SUmbWlOeAE

I have updated it in my code and now only shows the echo "Table admins created successfully"

But doesn't update the database table when i add some text in the fields and press Submit button

Here is the core file

Please visit the link and see in real time, i cannot figure out whats the problem
P.S there is no pictures or adult stuff on the website

<?php
$conn = mysqli_connect($DBServer, $DBUser, $DBPass, $DBName);

// Check connection
if ($conn->connect_error) {
  die('Connect Error (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
}

  $sql = "CREATE TABLE modelprofile (
        ID INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
        name TEXT(64) NOT NULL,
        url VARCHAR(128),
        profilepic VARCHAR(128),
        pic1 VARCHAR(2048),
        pic2 VARCHAR(2048),
        pic3 VARCHAR(2048),
        pic4 VARCHAR(2048),
        pic5 VARCHAR(2048),
        tags VARCHAR(1024),
        posttime TIMESTAMP(),
        have_nude INT(1))";
if($conn->query($sql)) {
  echo "Table admins created successfully";
}
?>

Does anyone visited it yet? Or have a solution to this BIG problem

You can visit the website at https://leakedof.us/admin/index.php
the current code i have is like this

I have edited it but still doesnt give an info error i dont understand what is happening

<?php
    include '../core/core.php';
?>
<!DOCTYPE html>
<html lang="en">

  <head>

    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>Add Model</title>

    <!-- Bootstrap core CSS -->
    <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom styles for this template -->
    <style>
      body {
        padding-top: 54px;
      }
      @media (min-width: 992px) {
        body {
          padding-top: 56px;
        }
      }
    </style>

  </head>

  <body>

    <!-- Navigation -->
    <nav class="navbar navbar-expand-lg navbar-dark bg-dark fixed-top">
      <div class="container">
        <a class="navbar-brand" href="../">Leaked OnlyFans Girls</a>
        <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">
          <span class="navbar-toggler-icon"></span>
        </button>
        <div class="collapse navbar-collapse" id="navbarResponsive">
          <ul class="navbar-nav ml-auto">
            <li class="nav-item active">
              <a class="nav-link" href="http://leakedof.us">Home</a>
            </li>
            <li class="nav-item">
              <a class="nav-link" href="#">Add Girl</a>
            </li>
          </ul>
        </div>
      </div>
    </nav>

    <!-- Page Content -->
    <div class="container">
      <form method="POST" action="index.php">
      <div class="row">
          <div class="col-lg-12 text-center">
            <h3 class="mt-5">Copy the URL <font color="red">username</font> of the girl. Example: instagram.com/[<font color="red">xenia</font>]</h3>
            <div class="input-group mb-3">
              <div class="input-group-prepend">
                <span class="input-group-text" id="basic-addon3">https://instagram.com/</span>
              </div>
              <input type="text" placeholder="xenia" name="instaProfLink" class="form-control" id="basic-url" aria-describedby="basic-addon3">
              <div class="input-group-prepend">
                <span class="input-group-text" id="basic-addon3">Girl Name</span>
              </div>
              <input type="text" placeholder="Full Name" name="girlName" class="form-control" id="basic-url" aria-describedby="basic-addon3">
              <div class="input-group-prepend">
                <span class="input-group-text" id="basic-addon3">Profile Pic</span>
              </div>
              <input type="text" placeholder="Profile Picture" name="profilepic" class="form-control" id="basic-url" aria-describedby="basic-addon3">
            </div>
            <p class="lead">Add the images from the girl profile <b>(NOT REQUIRED)</b></p>
            <div class="input-group mb-3">
              <div class="input-group-prepend">
                <span class="input-group-text" id="basic-addon3">IMAGE</span>
              </div>
              <input type="text" name="pic1" placeholder="https://www.instagram.com/p/BedEtBog-DB/" class="form-control" id="basic-url" aria-describedby="basic-addon3">
            </div>
            <div class="input-group mb-3">
              <div class="input-group-prepend">
                <span …

I am trying to insert into table with PHP and MySQL but the page only refresh it self when i press the button.

I haven't done debugging, i have an IF statement that displays any errors that fires if the SQL query have errors. But the thing is even the trigger_error doesnt return anything back to me so i can see whats the problem is.

I never come to this kind of problem before and i have no left ideas in my head so i can fix this.

`

<?php

        if(isset($_POST["submitGirl"])) {
            $name = $_POST['girlName'];
            $url = $_POST['instaProfLink'];
            $profilepic = $_POST['profilepic'];
            $pic1 = $_POST["pic1"];
            $pic2 = $_POST["pic2"];
            $pic3 = $_POST["pic3"];
            $pic4 = $_POST["pic4"];
            $pic5 = $_POST["pic5"];
            $tags = $_POST["tags"];

            $sql = "INSERT INTO modelprofile VALUES ('', '".htmlentities($name)."', '".htmlentities($url)."', '".htmlentities($profilepic)."', '".htmlentities($pic1)."', '".htmlentities($pic2)."', '".htmlentities($pic3)."', '".htmlentities($pic4)."', '".htmlentities($pic5)."', '".htmlentities($tags)."')";
            $result = $conn->query($sql);
            if($result === false) {
                trigger_error("A required file did not exist!", E_USER_ERROR);
                trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR);
            } else {
                echo "model added";
            }
        }
    ?>

submitGirl is the name of the button. When user press, it should add the rest info into database table, from the fields above

Quick update: I just found out that imgur platform gives extraordinary speed and stability. I think ill go with these guys.

@dani
the cloudflare option is not free its $5/month. Which is not ideal for me
https://prnt.sc/TX5ssWQuZeyD

@rproffitt
Yes google drive sometimes makes errors.

I am using google drive to upload manually the images there and with sharing link to display them on my website. But it makes troubles sometimes the images doesn't load fully. Is this proper way of displaying the images faster on your website?
The website is coded using HTML only and doesn't have any functionality on it. Only showing pictures and text. i am planning to show 100+ images on one page.

I am using this link https://drive.google.com/uc?export=view&id=[google_drive_photo_id]

Thank you for the nice explanation about the SEO part. Yes, I can do this with PHP, but i dont want my url's to be ending with .php.

As for the files location. They are in the correct place AND with the correct filename, i have send pictures.

What i did to solve this. Is just removed the mobile header part from the menu.html and placed inside the other files, and its working.

<!-- Mobile Nav (max width 767px)-->
<div class="mobile-nav">
    <!-- Navbar Brand -->
    <div class="amado-navbar-brand">
        <a href="index.html"><img src="core/img/core-img/drveniproizvodi-logo.png" alt=""></a>
    </div>
    <!-- Navbar Toggler -->
    <div class="amado-navbar-toggler">
        <span></span><span></span><span></span>
    </div>
</div>

And i got another question, is this way good for SEO? Because i noticed, when i view the page source of index.html the code from menu.html doesn't appear. It's only the <div> element as <div id="menu"></div>

@jawassjunior sorry i am not sure what you mean by this?

Yes, this is free prebuild template its called Amado Furniture. I just deleted the <header> from index and place in menu.html just so i can make my code more cleaner and easy to use

@Dani the code is updated as well sorry i didnt posted the update, because i wasn't able to edit my post