-
Notifications
You must be signed in to change notification settings - Fork 0
/
fetch_data.php
131 lines (87 loc) · 5.84 KB
/
fetch_data.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
<?php
//Technology application
$conn=mysql_connect("119.254.229.22","remoteuser","12345678");
$conn1=mysql_connect("localhost","root","csip123234345");
if(!$conn1)
{
echo mysql_error();
}
mysql_query("set names 'utf8'",$conn);
mysql_select_db("yp",$conn);
$sql="select resource_title, resource_id from sw_resource where resource_type=68";
$result=mysql_query($sql,$conn);
while($row=mysql_fetch_array($result))
{
$newstitle=$row["resource_title"];
$newsurl=$row["resource_id"];
mysql_query("set names 'utf8'",$conn1);
mysql_select_db("osscms",$conn1);
$sql=" INSERT INTO `oss_spaceitems` (`itemid`, `catid`, `uid`, `tid`, `username`, `itemtypeid`, `type`, `subtype`, `subject`, `dateline`, `lastpost`, `viewnum`, `replynum`, `trackbacknum`, `goodrate`, `badrate`, `digest`, `top`, `allowreply`, `hash`, `folder`, `haveattach`, `grade`, `gid`, `gdigest`, `password`, `styletitle`, `picid`, `fromtype`, `fromid`, `hot`, `click_1`, `click_2`, `click_3`, `click_4`, `click_5`, `click_6`, `click_7`, `click_8`, `click_9`, `click_10`, `click_11`, `click_12`, `click_13`, `click_14`, `click_15`, `click_16`, `click_17`, `click_18`, `click_19`, `click_20`, `click_21`, `click_22`, `click_23`, `click_24`, `click_25`, `click_26`, `click_27`, `click_28`, `click_29`, `click_30`, `click_31`, `click_32`) VALUES
(NULL, 41, 41424, 0, 'zhangy', 0, 'news', '', '".$newstitle."', 1096084446, 1096084446, 13, 0, 0, 0, 0, 0, 0, 1, '', 1, 0, 0, 0, 0, '', '', 0, 'adminpost', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) ";
$result1=mysql_query($sql,$conn1);
$newID=mysql_insert_id($conn1);
if(!$result1)
{
echo mysql_error();
}
$sql=" INSERT INTO `oss_spacenews` (`nid`, `itemid`, `message`, `relativetags`, `postip`, `relativeitemids`, `customfieldid`, `customfieldtext`, `includetags`, `newsauthor`, `newsfrom`, `newsfromurl`, `newsurl`, `pageorder`) VALUES
(NULL, '".$newID."', '', '', '172.16.23.52', '', 0, 'a:0:{}', '', '', '', '', 'http://yp.oss.org.cn/software/show_resource.php?resource_id=".$newsurl."', 1)";
$result2=mysql_query($sql,$conn1);
if(!$result2)
{
echo mysql_error();
}
}
//Open source blog
$sql="select resource_title, resource_id from sw_resource where resource_type=67";
$result=mysql_query($sql,$conn);
while($row=mysql_fetch_array($result))
{
$newstitle=$row["resource_title"];
$newsurl=$row["resource_id"];
mysql_query("set names 'utf8'",$conn1);
mysql_select_db("osscms",$conn1);
$sql=" INSERT INTO `oss_spaceitems` (`itemid`, `catid`, `uid`, `tid`, `username`, `itemtypeid`, `type`, `subtype`, `subject`, `dateline`, `lastpost`, `viewnum`, `replynum`, `trackbacknum`, `goodrate`, `badrate`, `digest`, `top`, `allowreply`, `hash`, `folder`, `haveattach`, `grade`, `gid`, `gdigest`, `password`, `styletitle`, `picid`, `fromtype`, `fromid`, `hot`, `click_1`, `click_2`, `click_3`, `click_4`, `click_5`, `click_6`, `click_7`, `click_8`, `click_9`, `click_10`, `click_11`, `click_12`, `click_13`, `click_14`, `click_15`, `click_16`, `click_17`, `click_18`, `click_19`, `click_20`, `click_21`, `click_22`, `click_23`, `click_24`, `click_25`, `click_26`, `click_27`, `click_28`, `click_29`, `click_30`, `click_31`, `click_32`) VALUES
(NULL, 42, 41424, 0, 'zhangy', 0, 'news', '', '".$newstitle."', 1096084446, 1096084446, 13, 0, 0, 0, 0, 0, 0, 1, '', 1, 0, 0, 0, 0, '', '', 0, 'adminpost', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) ";
$result1=mysql_query($sql,$conn1);
$newID=mysql_insert_id($conn1);
if(!$result1)
{
echo mysql_error();
}
$sql=" INSERT INTO `oss_spacenews` (`nid`, `itemid`, `message`, `relativetags`, `postip`, `relativeitemids`, `customfieldid`, `customfieldtext`, `includetags`, `newsauthor`, `newsfrom`, `newsfromurl`, `newsurl`, `pageorder`) VALUES
(NULL, '".$newID."', '', '', '172.16.23.52', '', 0, 'a:0:{}', '', '', '', '', 'http://yp.oss.org.cn/software/show_resource.php?resource_id=".$newsurl."', 1)";
$result2=mysql_query($sql,$conn1);
if(!$result2)
{
echo mysql_error();
}
}
//Hot experience
$sql="select demo_name1, sw_id from sw_demo";
$result=mysql_query($sql,$conn);
while($row=mysql_fetch_array($result))
{
$demotitle=$row["demo_name1"];
$demourl=$row["sw_id"];
mysql_query("set names 'utf8'",$conn1);
mysql_select_db("osscms",$conn1);
$sql=" INSERT INTO `oss_spaceitems` (`itemid`, `catid`, `uid`, `tid`, `username`, `itemtypeid`, `type`, `subtype`, `subject`, `dateline`, `lastpost`, `viewnum`, `replynum`, `trackbacknum`, `goodrate`, `badrate`, `digest`, `top`, `allowreply`, `hash`, `folder`, `haveattach`, `grade`, `gid`, `gdigest`, `password`, `styletitle`, `picid`, `fromtype`, `fromid`, `hot`, `click_1`, `click_2`, `click_3`, `click_4`, `click_5`, `click_6`, `click_7`, `click_8`, `click_9`, `click_10`, `click_11`, `click_12`, `click_13`, `click_14`, `click_15`, `click_16`, `click_17`, `click_18`, `click_19`, `click_20`, `click_21`, `click_22`, `click_23`, `click_24`, `click_25`, `click_26`, `click_27`, `click_28`, `click_29`, `click_30`, `click_31`, `click_32`) VALUES
(NULL, 43, 41424, 0, 'zhangy', 0, 'news', '', '".$demotitle."', 1096084446, 1096084446, 13, 0, 0, 0, 0, 0, 0, 1, '', 1, 0, 0, 0, 0, '', '', 0, 'adminpost', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) ";
$result1=mysql_query($sql,$conn1);
$newID=mysql_insert_id($conn1);
if(!$result1)
{
echo mysql_error();
}
$sql=" INSERT INTO `oss_spacenews` (`nid`, `itemid`, `message`, `relativetags`, `postip`, `relativeitemids`, `customfieldid`, `customfieldtext`, `includetags`, `newsauthor`, `newsfrom`, `newsfromurl`, `newsurl`, `pageorder`) VALUES
(NULL, '".$newID."', '', '', '172.16.23.52', '', 0, 'a:0:{}', '', '', '', '', 'http://yp.oss.org.cn/software/show_demo.php?sw_id=".$demourl."', 1)";
$result2=mysql_query($sql,$conn1);
if(!$result2)
{
echo mysql_error();
}
}
mysql_close($conn);
mysql_close($conn1);
?>