qYSvgenC

1require_once(WEBSITE_ROOT.'/'.APP_DIRECTORY.'/functions/db_fns.php');
2
3$subreddits = subreddit_getir($db_user[category]);
4$posts = grab_reddit_picture($subreddits);
5
6foreach($posts as $post){
7        $hashtags = make_hashtag($db_user[category], $post[subreddit]); //#city #culture etc.
8
9        if($post[type]=='resim'){
10            $rawImage = file_get_contents($post[url]);
11            if(!$rawImage){break;}
12            $basename = preg_replace('/^.+[\\\/]/', '', $post[url]);
13
14            if(!is_picture_inserted($db_user[tw_id], $post[url])){
15                $pic_id = insert_picture($db_user[tw_id], $post[title], $post[url], $post[type]);
16
17                file_put_contents(WEBSITE_ROOT.'/'.APP_DIRECTORY.'/images/'.$basename, $rawImage);
18
19                //image_text($basename, $db_user[tw_name]);
20
21                // assign access token on each page load
22                $cb->setToken($db_user['oauth_token'], $db_user['oauth_token_secret']);
23
24                $reply = $cb->statuses_updateWithMedia(array(
25                    'status'  => substr(convert_hashtag($post[title]), 0, 72).' '.$hashtags.' ',
26                    'media[]' => WEBSITE_ROOT.'/'.APP_DIRECTORY.'/images/'.$basename
27                ));
28                print_r($reply);
29                //break;
30            }
31        }else{
32            if(!is_picture_inserted($db_user[tw_id], $post[url])){
33                insert_picture($db_user[tw_id], $post[title], $post[url], $post[type]);
34                $cb->setToken($db_user['oauth_token'], $db_user['oauth_token_secret']);
35
36                $reply = $cb->statuses_update(array(
37                    'status'  => substr(convert_hashtag($post[title]), 0, 100).' '.$post['url'].' '.$hashtags
38                ));
39                print_r($reply);        
40            }
41        }
42}
43	
44<?php
45    function db_connect() {
46        $connection = new mysqli(MYSQL_HOSTNAME, USERNAME, PASSWORD, DATABASE);
47
48        if (!$connection)
49        {
50          echo 'No connection!';
51          mysql_error(); 
52        }
53
54        if (!$connection->select_db(DATABASE))
55        {
56          echo 'No database!'; 
57          mysql_error();
58        }
59
60        $connection->query("SET NAMES UTF8");
61        return $connection;    
62    }
63
64    function db_result_to_array($result) 
65    {
66        $res_array = array();
67
68        for ($count = 0; $row = mysqli_fetch_assoc($result); $count++)
69        {
70            $res_array[$count] = $row;    
71        }
72        return $res_array;
73    }
74
75
76    function is_user_created($id, $tablo_adi)
77    {
78        $conn = db_connect();
79
80        $query = "SELECT id FROM ".$tablo_adi." WHERE tw_id = ".$id;
81
82        $result = $conn->query($query);
83
84        $result = $result->fetch_array();
85
86        if($result)
87        {
88            return $result;
89        }
90        else
91        {
92            return false;
93        }
94
95        if(mysqli_ping($conn))
96        {
97            $conn->close(); 
98        }
99    }
100
101    function create_user($user_id, $oauth_token, $oauth_token_secret){
102        $conn = db_connect();
103
104
105            $query = sprintf("INSERT into reddit_twitter SET 
106                tw_id = %s,
107                oauth_token = '%s',
108                oauth_token_secret = '%s'",
109                $user_id,
110                $oauth_token,
111                $oauth_token_secret);
112        $result = $conn->query($query);
113
114        if(!$result){
115            echo 'Dünyayı ele geçirmeye falan mı çalışıyorsun?';
116            echo $conn->error;
117        }else{
118            return $conn->insert_id;
119        }
120        $conn->close();
121    }
122
123    function select_users(){
124        $conn = db_connect();
125
126        $query = "SELECT * FROM reddit_twitter ORDER by id DESC";
127
128        $result = $conn->query($query);
129
130        $result = db_result_to_array($result);
131
132        return $result;
133        $conn->close();
134    }
135
136    function insert_picture($tw_id, $title, $picture, $type){
137        $conn = db_connect();
138
139        $query = sprintf("INSERT into pics SET 
140            tw_id = '%s',
141            title = '%s',
142            picture = '%s',
143            type = '%s'
144            ",
145            $tw_id,
146            $conn->real_escape_string($title),
147            $picture,
148            $type
149            );
150
151        $result = $conn->query($query);
152
153        if(!$result){
154            echo 'Dünyayı ele geçirmeye falan mı çalışıyorsun?';
155            echo $conn->error;
156        }else{
157            return $conn->insert_id;
158        }
159        $conn->close();
160    }
161
162
163    function is_picture_inserted($uid, $basename)
164    {
165        $conn = db_connect();
166
167        $query = "SELECT id FROM pics WHERE tw_id = ".$uid." AND picture = '".$basename."'";
168
169        $result = $conn->query($query);
170
171        $result = mysqli_fetch_assoc($result);
172
173        if($result)
174        {
175            return $result[id];
176        }
177        else
178        {
179            echo $conn->error;
180            return false;
181        }
182
183        if(mysqli_ping($conn))
184        {
185            $conn->close(); 
186        }
187    }
188?>
189	
190require_once(WEBSITE_ROOT.'/'.APP_DIRECTORY.'/functions/db_fns.php');
191$conn = db_connect();
192
193$subreddits = subreddit_getir($db_user[category]);
194$posts = grab_reddit_picture($subreddits);
195
196foreach($posts as $post){
197        $hashtags = make_hashtag($db_user[category], $post[subreddit]); //#city #culture etc.
198
199        if($post[type]=='resim'){
200            $rawImage = file_get_contents($post[url]);
201            if(!$rawImage){break;}
202            $basename = preg_replace('/^.+[\\\/]/', '', $post[url]);
203
204            if(!is_picture_inserted($db_user[tw_id], $post[url])){
205                $pic_id = insert_picture($db_user[tw_id], $post[title], $post[url], $post[type]);
206
207                file_put_contents(WEBSITE_ROOT.'/'.APP_DIRECTORY.'/images/'.$basename, $rawImage);
208
209                //image_text($basename, $db_user[tw_name]);
210
211                // assign access token on each page load
212                $cb->setToken($db_user['oauth_token'], $db_user['oauth_token_secret']);
213
214                $reply = $cb->statuses_updateWithMedia(array(
215                    'status'  => substr(convert_hashtag($post[title]), 0, 72).' '.$hashtags.' ',
216                    'media[]' => WEBSITE_ROOT.'/'.APP_DIRECTORY.'/images/'.$basename
217                ));
218                print_r($reply);
219                //break;
220            }
221        }else{
222            if(!is_picture_inserted($db_user[tw_id], $post[url])){
223                insert_picture($db_user[tw_id], $post[title], $post[url], $post[type]);
224                $cb->setToken($db_user['oauth_token'], $db_user['oauth_token_secret']);
225
226                $reply = $cb->statuses_update(array(
227                    'status'  => substr(convert_hashtag($post[title]), 0, 100).' '.$post['url'].' '.$hashtags
228                ));
229                print_r($reply);        
230            }
231        }
232}
233$conn->close();
234	
235<?php
236    function db_connect() {
237        $connection = new mysqli(MYSQL_HOSTNAME, USERNAME, PASSWORD, DATABASE);
238
239        if (!$connection)
240        {
241          echo 'No connection!';
242          mysql_error(); 
243        }
244
245        if (!$connection->select_db(DATABASE))
246        {
247          echo 'No database!'; 
248          mysql_error();
249        }
250
251        $connection->query("SET NAMES UTF8");
252        return $connection;    
253    }
254
255    function db_result_to_array($result) 
256    {
257        $res_array = array();
258
259        for ($count = 0; $row = mysqli_fetch_assoc($result); $count++)
260        {
261            $res_array[$count] = $row;    
262        }
263        return $res_array;
264    }
265
266
267    function is_user_created($id, $tablo_adi)
268    {
269
270        $query = "SELECT id FROM ".$tablo_adi." WHERE tw_id = ".$id;
271
272        $result = $conn->query($query);
273
274        $result = $result->fetch_array();
275
276        if($result)
277        {
278            return $result;
279        }
280        else
281        {
282            return false;
283        }
284
285    }
286
287    function create_user($user_id, $oauth_token, $oauth_token_secret){
288
289
290            $query = sprintf("INSERT into reddit_twitter SET 
291                tw_id = %s,
292                oauth_token = '%s',
293                oauth_token_secret = '%s'",
294                $user_id,
295                $oauth_token,
296                $oauth_token_secret);
297        $result = $conn->query($query);
298
299        if(!$result){
300            echo 'Dünyayı ele geçirmeye falan mı çalışıyorsun?';
301            echo $conn->error;
302        }else{
303            return $conn->insert_id;
304        }
305    }
306
307    function select_users(){
308
309        $query = "SELECT * FROM reddit_twitter ORDER by id DESC";
310
311        $result = $conn->query($query);
312
313        $result = db_result_to_array($result);
314
315        return $result;
316    }
317
318    function insert_picture($tw_id, $title, $picture, $type){
319
320        $query = sprintf("INSERT into pics SET 
321            tw_id = '%s',
322            title = '%s',
323            picture = '%s',
324            type = '%s'
325            ",
326            $tw_id,
327            $conn->real_escape_string($title),
328            $picture,
329            $type
330            );
331
332        $result = $conn->query($query);
333
334        if(!$result){
335            echo 'Dünyayı ele geçirmeye falan mı çalışıyorsun?';
336            echo $conn->error;
337        }else{
338            return $conn->insert_id;
339        }
340    }
341
342
343    function is_picture_inserted($uid, $basename)
344    {
345
346        $query = "SELECT id FROM pics WHERE tw_id = ".$uid." AND picture = '".$basename."'";
347
348        $result = $conn->query($query);
349
350        $result = mysqli_fetch_assoc($result);
351
352        if($result)
353        {
354            return $result[id];
355        }
356        else
357        {
358            echo $conn->error;
359            return false;
360        }
361
362    }
363?>