| 1 | <?php
|
|---|
| 2 |
|
|---|
| 3 | include_once(dirname(__FILE__).'/Import/Seznamka.php');
|
|---|
| 4 | include_once(dirname(__FILE__).'/Import/TanecniSkola.php');
|
|---|
| 5 | include_once(dirname(__FILE__).'/Import/AstraPraha.php');
|
|---|
| 6 | include_once(dirname(__FILE__).'/Import/Vavruska.php');
|
|---|
| 7 | include_once(dirname(__FILE__).'/Import/SalsaDance.php');
|
|---|
| 8 | include_once(dirname(__FILE__).'/Import/Amblar.php');
|
|---|
| 9 | include_once(dirname(__FILE__).'/Import/MajkluvSvet.php');
|
|---|
| 10 | include_once(dirname(__FILE__).'/Import/Csts.php');
|
|---|
| 11 | include_once(dirname(__FILE__).'/Import/Facebook.php');
|
|---|
| 12 | include_once(dirname(__FILE__).'/Import/Eso.php');
|
|---|
| 13 | include_once(dirname(__FILE__).'/Import/Ella.php');
|
|---|
| 14 | include_once(dirname(__FILE__).'/Import/MgDance.php');
|
|---|
| 15 | include_once(dirname(__FILE__).'/Import/LaTropical.php');
|
|---|
| 16 |
|
|---|
| 17 | abstract class Gender
|
|---|
| 18 | {
|
|---|
| 19 | const Undefined = 0;
|
|---|
| 20 | const Male = 1;
|
|---|
| 21 | const Female = 2;
|
|---|
| 22 | }
|
|---|
| 23 |
|
|---|
| 24 | function GetTextBetween(string &$Text, string $Start, string $End): string
|
|---|
| 25 | {
|
|---|
| 26 | $Result = '';
|
|---|
| 27 | if ((strpos($Text, $Start) !== false) and (strpos($Text, $End) !== false))
|
|---|
| 28 | {
|
|---|
| 29 | $Text = substr($Text, strpos($Text, $Start) + strlen($Start));
|
|---|
| 30 | $Result = substr($Text, 0, strpos($Text, $End));
|
|---|
| 31 | $Text = substr($Text, strpos($Text, $End) + strlen($End));
|
|---|
| 32 | }
|
|---|
| 33 | return $Result;
|
|---|
| 34 | }
|
|---|
| 35 |
|
|---|
| 36 | function HumanDateTimeToTime(string $DateTime): ?int
|
|---|
| 37 | {
|
|---|
| 38 | if ($DateTime == '') return NULL;
|
|---|
| 39 | $DateTime = str_replace('. ', '.', $DateTime);
|
|---|
| 40 | $Parts = explode(' ', $DateTime);
|
|---|
| 41 | if (count($Parts) > 0)
|
|---|
| 42 | {
|
|---|
| 43 | $DateParts = explode('.', $Parts[0]);
|
|---|
| 44 | if (count($DateParts) == 1) $DateParts[1] = '0';
|
|---|
| 45 | if (count($DateParts) == 2) $DateParts[2] = '0';
|
|---|
| 46 | } else return NULL;
|
|---|
| 47 | if (count($Parts) > 1)
|
|---|
| 48 | {
|
|---|
| 49 | $TimeParts = explode(':', $Parts[1]);
|
|---|
| 50 | if (count($TimeParts) == 1) $TimeParts[1] = '0';
|
|---|
| 51 | if (count($TimeParts) == 2) $TimeParts[2] = '0';
|
|---|
| 52 | } else $TimeParts = array(0, 0, 0);
|
|---|
| 53 | $Result = mktime($TimeParts[0], $TimeParts[1], $TimeParts[2], $DateParts[1], $DateParts[0], $DateParts[2]);
|
|---|
| 54 | return $Result;
|
|---|
| 55 | }
|
|---|
| 56 |
|
|---|
| 57 | function HumanDateToTime(string $Date): ?int
|
|---|
| 58 | {
|
|---|
| 59 | if ($Date == '') return NULL;
|
|---|
| 60 | return HumanDateTimeToTime($Date.' 0:0:0');
|
|---|
| 61 | }
|
|---|
| 62 |
|
|---|
| 63 | function DecodeHtmlEnt(string $str): string
|
|---|
| 64 | {
|
|---|
| 65 | $prefix = '&#';
|
|---|
| 66 | $suffix = ';';
|
|---|
| 67 | $hexchar = 'x';
|
|---|
| 68 | $ret = html_entity_decode($str, ENT_COMPAT, 'UTF-8');
|
|---|
| 69 | $p2 = 0;
|
|---|
| 70 | for (;;)
|
|---|
| 71 | {
|
|---|
| 72 | $p = strpos($ret, $prefix, $p2);
|
|---|
| 73 | if ($p === FALSE)
|
|---|
| 74 | break;
|
|---|
| 75 | $p2 = strpos($ret, $suffix, $p);
|
|---|
| 76 | if ($p2 === FALSE)
|
|---|
| 77 | {
|
|---|
| 78 | $p2 = $p + strlen($prefix);
|
|---|
| 79 | while (($p2 < strlen($ret)) and is_numeric($ret[$p2]))
|
|---|
| 80 | $p2++;
|
|---|
| 81 | if ($p2 <= ($p + strlen($prefix))) break;
|
|---|
| 82 | $add = 0;
|
|---|
| 83 | } else $add = 1;
|
|---|
| 84 |
|
|---|
| 85 | if (substr($ret, $p + strlen($prefix), strlen($hexchar)) == $hexchar)
|
|---|
| 86 | $char = hexdec(substr($ret, $p + strlen($prefix) + strlen($hexchar), $p2 - $p - strlen($prefix) - strlen($hexchar)));
|
|---|
| 87 | else
|
|---|
| 88 | $char = intval(substr($ret, $p + strlen($prefix), $p2 - $p - strlen($prefix)));
|
|---|
| 89 |
|
|---|
| 90 | $newchar = iconv(
|
|---|
| 91 | 'UCS-4', 'UTF-8',
|
|---|
| 92 | chr(($char >> 24) & 0xFF).chr(($char >> 16) & 0xFF).chr(($char >> 8) & 0xFF).chr($char & 0xFF)
|
|---|
| 93 | );
|
|---|
| 94 | $ret = substr_replace($ret, $newchar, $p, $add + $p2 - $p);
|
|---|
| 95 | $p2 = $p + strlen($newchar) + $add;
|
|---|
| 96 | }
|
|---|
| 97 | return $ret;
|
|---|
| 98 | }
|
|---|
| 99 |
|
|---|
| 100 | function RemoveHtmlComments(string $Content): string
|
|---|
| 101 | {
|
|---|
| 102 | $Result = '';
|
|---|
| 103 | while (strpos($Content, '<!--') !== false)
|
|---|
| 104 | {
|
|---|
| 105 | $Result .= substr($Content, 0, strpos($Content, '<!--'));
|
|---|
| 106 | $Content = substr($Content, strpos($Content, '<!--') + 4);
|
|---|
| 107 | $Content = substr($Content, strpos($Content, '-->') + 3);
|
|---|
| 108 | }
|
|---|
| 109 | return $Result;
|
|---|
| 110 | //return preg_replace('/<!--(.|\s)*?-->/', '', $Content);
|
|---|
| 111 | }
|
|---|
| 112 |
|
|---|
| 113 | function is_alpha(string $Char): bool
|
|---|
| 114 | {
|
|---|
| 115 | return (($Char >= 'a') and ($Char <= 'z')) or (($Char >= 'A') and ($Char <= 'Z'));
|
|---|
| 116 | }
|
|---|
| 117 |
|
|---|
| 118 | function is_white_space(string $Char): bool
|
|---|
| 119 | {
|
|---|
| 120 | return ($Char == ' ') or ($Char == "\t");
|
|---|
| 121 | }
|
|---|
| 122 |
|
|---|
| 123 | function GetDefaultMeetFilter(string $Table = ''): string
|
|---|
| 124 | {
|
|---|
| 125 | global $Config;
|
|---|
| 126 |
|
|---|
| 127 | if ($Table != '') $Table = $Table.'.';
|
|---|
| 128 |
|
|---|
| 129 | return '('.$Table.'Hidden=0) AND ('.$Table.'Time > "'.TimeToMysqlDateTime(time() - (int)$Config['MeetInterval']).'")';
|
|---|
| 130 | }
|
|---|
| 131 |
|
|---|
| 132 | function GetNumberBeforeText(string $Text, string $Needle): string
|
|---|
| 133 | {
|
|---|
| 134 | $Result = '';
|
|---|
| 135 | for (;;)
|
|---|
| 136 | {
|
|---|
| 137 | $Pos = strpos($Text, $Needle);
|
|---|
| 138 | if ($Pos !== false)
|
|---|
| 139 | {
|
|---|
| 140 | if ((($Pos + strlen($Needle)) < strlen($Text)) and (is_alpha($Text[$Pos + strlen($Needle)])))
|
|---|
| 141 | {
|
|---|
| 142 | $Text = substr($Text, $Pos + 1);
|
|---|
| 143 | continue;
|
|---|
| 144 | }
|
|---|
| 145 | $Result = substr($Text, 0, $Pos);
|
|---|
| 146 | $Text = substr($Text, $Pos + 1);
|
|---|
| 147 | $Start = $Pos - 1;
|
|---|
| 148 | while (($Start >= 0) and (is_numeric($Result[$Start]) or is_white_space($Result[$Start])))
|
|---|
| 149 | $Start--;
|
|---|
| 150 | $Start++;
|
|---|
| 151 | $Result = trim(substr($Result, $Start, $Pos - $Start));
|
|---|
| 152 | if (is_numeric($Result)) break;
|
|---|
| 153 | } else break;
|
|---|
| 154 | }
|
|---|
| 155 | return $Result;
|
|---|
| 156 | }
|
|---|
| 157 |
|
|---|
| 158 | function GetNumberAfterText(string $Text, string $Needle): string
|
|---|
| 159 | {
|
|---|
| 160 | $Result = '';
|
|---|
| 161 | for (;;)
|
|---|
| 162 | {
|
|---|
| 163 | $Pos = strpos($Text, $Needle);
|
|---|
| 164 | if ($Pos !== false)
|
|---|
| 165 | {
|
|---|
| 166 | if ((($Pos - 1) >= 0) and (is_alpha($Text[$Pos - 1])))
|
|---|
| 167 | {
|
|---|
| 168 | $Text = substr($Text, $Pos + 1);
|
|---|
| 169 | continue;
|
|---|
| 170 | }
|
|---|
| 171 | $Result = substr($Text, $Pos + strlen($Needle));
|
|---|
| 172 | $Text = substr($Text, $Pos + 1);
|
|---|
| 173 | $End = 0;
|
|---|
| 174 | while (($End < strlen($Result)) and (is_numeric($Result[$End]) or is_white_space($Result[$End])))
|
|---|
| 175 | $End++;
|
|---|
| 176 | $End--;
|
|---|
| 177 |
|
|---|
| 178 | $Result = trim(substr($Result, 0, $End + 1));
|
|---|
| 179 | if (is_numeric($Result)) break;
|
|---|
| 180 | } else break;
|
|---|
| 181 | }
|
|---|
| 182 | return $Result;
|
|---|
| 183 | }
|
|---|
| 184 |
|
|---|
| 185 | function GetAgeFromText(string $Text): string
|
|---|
| 186 | {
|
|---|
| 187 | $Text = strtolower($Text);
|
|---|
| 188 | $Result = GetNumberAfterText($Text, 'je mi');
|
|---|
| 189 | if ($Result == '') $Result = GetNumberAfterText($Text, 'je mi přes');
|
|---|
| 190 | if ($Result == '') $Result = GetNumberBeforeText($Text, 'let');
|
|---|
| 191 | if ($Result == '') $Result = GetNumberBeforeText($Text, 'rokov');
|
|---|
| 192 | if ($Result == '') $Result = GetNumberBeforeText($Text, 'roků');
|
|---|
| 193 | if ($Result == '') $Result = GetNumberBeforeText($Text, 'letou');
|
|---|
| 194 | if ($Result == '') $Result = GetNumberAfterText($Text, 'čerstvých');
|
|---|
| 195 | if ($Result == '') {
|
|---|
| 196 | $Result = GetNumberAfterText($Text, 'jsem');
|
|---|
| 197 | if ($Result > 100) $Result = ''; // Age over 100 is probably not age but height
|
|---|
| 198 | }
|
|---|
| 199 | if ($Result == '') $Result = GetAgeHeightWeightFromText($Text)[0];
|
|---|
| 200 | if ($Result == '') {
|
|---|
| 201 | $Year = GetNumberAfterText($Text, 'ročník');
|
|---|
| 202 | if ($Year != '') $Result = date('Y', time()) - $Year;
|
|---|
| 203 | }
|
|---|
| 204 | if ($Result == '') {
|
|---|
| 205 | $Year = GetNumberAfterText($Text, 'ročník:');
|
|---|
| 206 | if ($Year != '') $Result = date('Y', time()) - $Year;
|
|---|
| 207 | }
|
|---|
| 208 | if ($Result == '') {
|
|---|
| 209 | $Year = GetNumberAfterText($Text, 'narozen roku');
|
|---|
| 210 | if ($Year != '') $Result = date('Y', time()) - $Year;
|
|---|
| 211 | }
|
|---|
| 212 | if ($Result == '') {
|
|---|
| 213 | $Year = GetNumberAfterText($Text, 'narozena roku');
|
|---|
| 214 | if ($Year != '') $Result = date('Y', time()) - $Year;
|
|---|
| 215 | }
|
|---|
| 216 | if ($Result == '') {
|
|---|
| 217 | $Result = GetNumberAfterText($Text, 'věk');
|
|---|
| 218 | }
|
|---|
| 219 | return $Result;
|
|---|
| 220 | }
|
|---|
| 221 |
|
|---|
| 222 | function GetHeightFromText(string $Text): string
|
|---|
| 223 | {
|
|---|
| 224 | $Text = strtolower($Text);
|
|---|
| 225 | $Result = GetNumberAfterText($Text, 'měřím');
|
|---|
| 226 | if ($Result == '') $Result = GetNumberAfterText($Text, 'merim');
|
|---|
| 227 | if ($Result == '') $Result = GetNumberAfterText($Text, 'výška');
|
|---|
| 228 | if ($Result == '') $Result = GetNumberBeforeText($Text, 'cm');
|
|---|
| 229 | if ($Result == '') $Result = GetNumberBeforeText($Text, 'bez podpatků');
|
|---|
| 230 | if ($Result == '') {
|
|---|
| 231 | $Result = GetNumberAfterText($Text, 'jsem');
|
|---|
| 232 | if ($Result < 150) $Result = ''; // Height below 150 is probably not height but age
|
|---|
| 233 | }
|
|---|
| 234 | if ($Result == '') $Result = GetAgeHeightWeightFromText($Text)[1];
|
|---|
| 235 | return $Result;
|
|---|
| 236 | }
|
|---|
| 237 |
|
|---|
| 238 | function GetWeightFromText(string $Text): string
|
|---|
| 239 | {
|
|---|
| 240 | $Text = strtolower($Text);
|
|---|
| 241 | $Result = GetNumberBeforeText($Text, 'kg');
|
|---|
| 242 | if ($Result == '') $Result = GetNumberAfterText($Text, 'vážím');
|
|---|
| 243 | if ($Result == '') $Result = GetNumberAfterText($Text, 'váha');
|
|---|
| 244 | if ($Result == '') $Result = GetAgeHeightWeightFromText($Text)[2];
|
|---|
| 245 | return $Result;
|
|---|
| 246 | }
|
|---|
| 247 |
|
|---|
| 248 | function GetAgeHeightWeightFromText(string $Text): array
|
|---|
| 249 | {
|
|---|
| 250 | $Result = array('', '', '');
|
|---|
| 251 | $Pattern = '/[0-9]+\/[0-9]+\/[0-9]+/i';
|
|---|
| 252 | if (preg_match_all($Pattern, $Text, $Matches))
|
|---|
| 253 | {
|
|---|
| 254 | $Result = explode('/', $Matches[0][0]);
|
|---|
| 255 | // Avoid dates in a form day/month/year
|
|---|
| 256 | if ($Result[2] > 150) $Result = array('', '', '');
|
|---|
| 257 | } else
|
|---|
| 258 | {
|
|---|
| 259 | $Pattern = '/[0-9]+\/[0-9]+/i';
|
|---|
| 260 | if (preg_match_all($Pattern, $Text, $Matches))
|
|---|
| 261 | {
|
|---|
| 262 | $Result = explode('/', $Matches[0][0]);
|
|---|
| 263 | // If first number is over 100 then its probably height/weight
|
|---|
| 264 | if ($Result[0] > 100) $Result = array('', $Result[0], $Result[1]);
|
|---|
| 265 | $Result[] = '';
|
|---|
| 266 | }
|
|---|
| 267 | }
|
|---|
| 268 | return $Result;
|
|---|
| 269 | }
|
|---|
| 270 |
|
|---|
| 271 | function GetNameFromText(string $Text): string
|
|---|
| 272 | {
|
|---|
| 273 | return '';
|
|---|
| 274 | }
|
|---|
| 275 |
|
|---|
| 276 | function GetEmailFromText(string $Text): string
|
|---|
| 277 | {
|
|---|
| 278 | $Result = '';
|
|---|
| 279 | if (strpos($Text, '@') !== false)
|
|---|
| 280 | {
|
|---|
| 281 | $Pattern = '/[a-z0-9_\-\+\.]+@[a-z0-9\-]+\.([a-z]{2,4})(?:\.[a-z]{2})?/i';
|
|---|
| 282 | preg_match_all($Pattern, $Text, $Matches);
|
|---|
| 283 | if ((count($Matches) > 0) and (count($Matches[0]) > 0) and ($Matches[0][0] != ''))
|
|---|
| 284 | {
|
|---|
| 285 | $Result = $Matches[0][0];
|
|---|
| 286 | }
|
|---|
| 287 | }
|
|---|
| 288 | return $Result;
|
|---|
| 289 | }
|
|---|
| 290 |
|
|---|
| 291 | $Locations = array(
|
|---|
| 292 | 'praha' => 'Praha',
|
|---|
| 293 | 'prahy' => 'Praha',
|
|---|
| 294 | 'praze' => 'Praha',
|
|---|
| 295 | 'brno' => 'Brno',
|
|---|
| 296 | 'brně' => 'Brno',
|
|---|
| 297 | 'ostrava' => 'Ostrava',
|
|---|
| 298 | 'ostravě' => 'Ostrava',
|
|---|
| 299 | 'ostravy' => 'Ostrava',
|
|---|
| 300 | 'olomouc' => 'Olomouc',
|
|---|
| 301 | 'liberec' => 'Liberec',
|
|---|
| 302 | 'opava' => 'Opava',
|
|---|
| 303 | 'opave' => 'Opava',
|
|---|
| 304 | 'plzeň' => 'Plzeň',
|
|---|
| 305 | 'plzni' => 'Plzeň',
|
|---|
| 306 | 'vyškov' => 'Vyškov',
|
|---|
| 307 | 'mladá boleslav' => 'Mladá Boleslav',
|
|---|
| 308 | 'mladé boleslavi' => 'Mladá Boleslav',
|
|---|
| 309 | 'litoměřice' => 'Litoměřice',
|
|---|
| 310 | 'sokolov' => 'Sokolov',
|
|---|
| 311 | 'mikulov' => 'Mikulov',
|
|---|
| 312 | 'havířov' => 'Havířov',
|
|---|
| 313 | 'kolín' => 'Kolín',
|
|---|
| 314 | 'kroměříž' => 'Kroměříž',
|
|---|
| 315 | 'hradec králové' => 'Hradec Králové',
|
|---|
| 316 | );
|
|---|
| 317 |
|
|---|
| 318 | function GetLocationFromText(string $Text): string
|
|---|
| 319 | {
|
|---|
| 320 | global $Locations;
|
|---|
| 321 |
|
|---|
| 322 | $Text = strtolower($Text);
|
|---|
| 323 |
|
|---|
| 324 | foreach ($Locations as $Index => $Location)
|
|---|
| 325 | {
|
|---|
| 326 | if (strpos($Text, $Index) !== false) return $Location;
|
|---|
| 327 | }
|
|---|
| 328 | return '';
|
|---|
| 329 | }
|
|---|
| 330 |
|
|---|
| 331 | function GetGenderFromName(string $Text): string
|
|---|
| 332 | {
|
|---|
| 333 | $Gender = Gender::Male;
|
|---|
| 334 | $Ending = substr($Text, -2);
|
|---|
| 335 | if (($Ending == 'na') or ($Ending == 'ta') or ($Ending == 'va') or
|
|---|
| 336 | ($Ending == 'ka') or ($Ending == 'ga') or ($Ending == 'ie') or
|
|---|
| 337 | ($Ending == 'la') or ($Ending == 'za') or ($Ending == 'še') or
|
|---|
| 338 | ($Ending == 'ra') or ($Ending == 'da') or ($Ending == 'sa') or
|
|---|
| 339 | ($Ending == 'ce') or ($Ending == 'id') or ($Ending == 'ša') or
|
|---|
| 340 | ($Ending == 'ma') or ($Ending == 'ja') or ($Ending == 'ia') or
|
|---|
| 341 | ($Ending == 'ha') or ($Ending == 'is'))
|
|---|
| 342 | return $Gender = Gender::Female;
|
|---|
| 343 | return $Gender;
|
|---|
| 344 | }
|
|---|
| 345 |
|
|---|
| 346 | class MeetSources
|
|---|
| 347 | {
|
|---|
| 348 | public Database $Database;
|
|---|
| 349 |
|
|---|
| 350 | function Parse(?int $Id = null): string
|
|---|
| 351 | {
|
|---|
| 352 | $Output = '';
|
|---|
| 353 | $Where = '1';
|
|---|
| 354 | if (($Id != null) and is_numeric($Id)) $Where .= ' AND (Id='.$Id.')';
|
|---|
| 355 | $DbResult = $this->Database->select('MeetSource', '*', $Where);
|
|---|
| 356 | while ($DbRow = $DbResult->fetch_assoc())
|
|---|
| 357 | {
|
|---|
| 358 | if ($DbRow['Enabled'] == 1)
|
|---|
| 359 | {
|
|---|
| 360 | $Method = $DbRow['Method'];
|
|---|
| 361 | if ($Method == 'hes') $Source = new MeetSourceTanecniSkola();
|
|---|
| 362 | else if ($Method == 'vavruska') $Source = new MeetSourceVavruska();
|
|---|
| 363 | else if ($Method == 'salsadance') $Source = new MeetSourceSalsaDance();
|
|---|
| 364 | else if ($Method == 'astra') $Source = new MeetSourceAstraPraha();
|
|---|
| 365 | else if ($Method == 'seznamka') $Source = new MeetSourceSeznamka();
|
|---|
| 366 | else if ($Method == 'amblar') $Source = new MeetSourceAmblar();
|
|---|
| 367 | else if ($Method == 'majkluvsvet') $Source = new MeetSourceMajkluvSvet();
|
|---|
| 368 | else if ($Method == 'csts') $Source = new MeetSourceCsts();
|
|---|
| 369 | else if ($Method == 'facebook') $Source = new MeetSourceFacebook();
|
|---|
| 370 | else if ($Method == 'eso') $Source = new MeetSourceEso();
|
|---|
| 371 | else if ($Method == 'ella') $Source = new MeetSourceElla();
|
|---|
| 372 | else if ($Method == 'mgdance') $Source = new MeetSourceMgDance();
|
|---|
| 373 | else if ($Method == 'latropical') $Source = new MeetSourceLaTropical();
|
|---|
| 374 | else {
|
|---|
| 375 | $Output .= 'Unsupported parse method: '.$Method.'<br/>';
|
|---|
| 376 | continue;
|
|---|
| 377 | }
|
|---|
| 378 | $Source->Database = $this->Database;
|
|---|
| 379 | $Source->Id = $DbRow['Id'];
|
|---|
| 380 | $Source->URL = $DbRow['URL'];
|
|---|
| 381 | $Source->Method = $Method;
|
|---|
| 382 | $Source->Name = $DbRow['Name'];
|
|---|
| 383 | $Output .= $Source->DoImport();
|
|---|
| 384 | } else $Output .= 'Parser '.$DbRow['Name'].' (#'.$DbRow['Id'].') disabled.<br/>'."\n";
|
|---|
| 385 | }
|
|---|
| 386 | return $Output;
|
|---|
| 387 | }
|
|---|
| 388 | }
|
|---|
| 389 |
|
|---|
| 390 | class MeetSource
|
|---|
| 391 | {
|
|---|
| 392 | public string $Name;
|
|---|
| 393 | public string $URL;
|
|---|
| 394 | public string $Method;
|
|---|
| 395 | public string $Id;
|
|---|
| 396 | public Database $Database;
|
|---|
| 397 | public array $MeetItems;
|
|---|
| 398 | public bool $AddCompareTime;
|
|---|
| 399 | public bool $AddCompareRemoteId;
|
|---|
| 400 | public int $AddTimeInterval;
|
|---|
| 401 | public int $AddedCount;
|
|---|
| 402 |
|
|---|
| 403 | function __construct()
|
|---|
| 404 | {
|
|---|
| 405 | $this->MeetItems = array();
|
|---|
| 406 | $this->AddedCount = 0;
|
|---|
| 407 | $this->AddCompareTime = true;
|
|---|
| 408 | $this->AddCompareRemoteId = false;
|
|---|
| 409 | $this->AddTimeInterval = 0;
|
|---|
| 410 | }
|
|---|
| 411 |
|
|---|
| 412 | function Import(): string
|
|---|
| 413 | {
|
|---|
| 414 | return '';
|
|---|
| 415 | }
|
|---|
| 416 |
|
|---|
| 417 | function DoImport(): string
|
|---|
| 418 | {
|
|---|
| 419 | $this->MeetItems = array();
|
|---|
| 420 | $this->AddedCount = 0;
|
|---|
| 421 | $Output = 'Parsing '.$this->Name.' (#'.$this->Id.')...';
|
|---|
| 422 | $Output .= $this->Import();
|
|---|
| 423 | $Output .= ' parsed: '.count($this->MeetItems);
|
|---|
| 424 | foreach ($this->MeetItems as $MeetItem)
|
|---|
| 425 | {
|
|---|
| 426 | if ($MeetItem->IsSpam()) continue;
|
|---|
| 427 | $this->AddedCount += $MeetItem->AddIfNotExist($this->AddTimeInterval, $this->AddCompareTime, $this->AddCompareRemoteId);
|
|---|
| 428 | }
|
|---|
| 429 | $Output .= ', new added: '.$this->AddedCount;
|
|---|
| 430 | $Output .= '</br>'."\n";
|
|---|
| 431 | return $Output;
|
|---|
| 432 | }
|
|---|
| 433 | }
|
|---|
| 434 |
|
|---|
| 435 | class MeetItem
|
|---|
| 436 | {
|
|---|
| 437 | public Database $Database;
|
|---|
| 438 | public string $Name = '';
|
|---|
| 439 | public string $Message = '';
|
|---|
| 440 | public ?int $Time = 0;
|
|---|
| 441 | public int $Gender = Gender::Undefined;
|
|---|
| 442 | public string $Phone = '';
|
|---|
| 443 | public string $Email = '';
|
|---|
| 444 | public string $Age = '';
|
|---|
| 445 | public string $Height = '';
|
|---|
| 446 | public int $Source = 0;
|
|---|
| 447 | public string $Weight = '';
|
|---|
| 448 | public string $Location = '';
|
|---|
| 449 | public string $Image = '';
|
|---|
| 450 | public string $Link = '';
|
|---|
| 451 | public string $Title = '';
|
|---|
| 452 | public string $Level = '';
|
|---|
| 453 | public string $RemoteId = '';
|
|---|
| 454 |
|
|---|
| 455 | function AddIfNotExist(int $TimeInterval = 0, bool $CompareTime = true, bool $CompareRemoteId = false): int
|
|---|
| 456 | {
|
|---|
| 457 | $Where = '(`Message` = "'.$this->Database->real_escape_string($this->Message).'") AND '.
|
|---|
| 458 | '(`Email` = "'.$this->Database->real_escape_string($this->Email).'") AND '.
|
|---|
| 459 | '(`Source` = '.$this->Source.')';
|
|---|
| 460 | if ($CompareTime)
|
|---|
| 461 | $Where .= ' AND (`Time` >= "'.$this->Database->real_escape_string(TimeToMysqlDateTime($this->Time - $TimeInterval)).'") AND '.
|
|---|
| 462 | '(`Time` <= "'.$this->Database->real_escape_string(TimeToMysqlDateTime($this->Time + $TimeInterval)).'")';
|
|---|
| 463 | if ($CompareRemoteId)
|
|---|
| 464 | $Where .= ' AND (`RemoteId` = "'.$this->Database->real_escape_string($this->RemoteId).'")';
|
|---|
| 465 | $DbResult = $this->Database->select('MeetItem', '*', $Where);
|
|---|
| 466 | if ($DbResult->num_rows == 0)
|
|---|
| 467 | {
|
|---|
| 468 | if ($this->Age == '') $Age = null;
|
|---|
| 469 | else $Age = $this->Age;
|
|---|
| 470 | if ($this->Height == '') $Height = null;
|
|---|
| 471 | else $Height = $this->Height;
|
|---|
| 472 | if ($this->Weight == '') $Weight = null;
|
|---|
| 473 | else $Weight = $this->Weight;
|
|---|
| 474 | $this->Database->insert('MeetItem', array(
|
|---|
| 475 | 'Source' => $this->Source,
|
|---|
| 476 | 'Link' => $this->Link,
|
|---|
| 477 | 'Email' => $this->Email,
|
|---|
| 478 | 'Message' => $this->Message,
|
|---|
| 479 | 'Time' => TimeToMysqlDateTime($this->Time),
|
|---|
| 480 | 'Gender' => $this->Gender,
|
|---|
| 481 | 'Age' => $Age,
|
|---|
| 482 | 'Phone' => $this->Phone,
|
|---|
| 483 | 'Name' => $this->Name,
|
|---|
| 484 | 'Height' => $Height,
|
|---|
| 485 | 'Weight' => $Weight,
|
|---|
| 486 | 'Location' => $this->Location,
|
|---|
| 487 | 'RemoteId' => $this->RemoteId,
|
|---|
| 488 | 'TimeImport' => 'NOW()',
|
|---|
| 489 | ));
|
|---|
| 490 | $Result = 1;
|
|---|
| 491 | } else $Result = 0;
|
|---|
| 492 | return $Result;
|
|---|
| 493 | }
|
|---|
| 494 |
|
|---|
| 495 | function IsSpam(): bool
|
|---|
| 496 | {
|
|---|
| 497 | $Keywords = array('půjčk', 'úvěr');
|
|---|
| 498 | foreach ($Keywords as $Keyword)
|
|---|
| 499 | {
|
|---|
| 500 | if (strpos($this->Message, $Keyword) !== false)
|
|---|
| 501 | {
|
|---|
| 502 | return true;
|
|---|
| 503 | }
|
|---|
| 504 | }
|
|---|
| 505 | return false;
|
|---|
| 506 | }
|
|---|
| 507 | }
|
|---|