回答編集履歴
1
会員のレコードも含まれてしまうため修正
answer
CHANGED
|
@@ -10,13 +10,16 @@
|
|
|
10
10
|
|
|
11
11
|
# 会員ID -> 紹介者
|
|
12
12
|
|
|
13
|
-
親ID = 会員ID
|
|
14
13
|
紹介者 = []
|
|
15
14
|
|
|
16
15
|
statement = connection.prepare('SELECT * FROM `会員` WHERE `会員ID` = ?;')
|
|
17
16
|
|
|
17
|
+
tuple = statement.execute( 会員ID ).fetch
|
|
18
|
+
|
|
19
|
+
紹介者ID = tuple.紹介者ID
|
|
20
|
+
|
|
18
21
|
while( 紹介者.length < 設定.紹介者Max )
|
|
19
|
-
if
|
|
22
|
+
if 紹介者ID.nil? then
|
|
20
23
|
break
|
|
21
24
|
end
|
|
22
25
|
|
|
@@ -27,7 +30,7 @@
|
|
|
27
30
|
end
|
|
28
31
|
|
|
29
32
|
紹介者.push( tuple )
|
|
30
|
-
|
|
33
|
+
紹介者ID = tuple.紹介者ID
|
|
31
34
|
end
|
|
32
35
|
|
|
33
36
|
statement.close
|