blob: 81a13f4e2d6804dd07ae821f60d5ca61ec714188 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
<?php
if(sql_num_query("SHOW TABLES LIKE 'UserAngelTypes'") === 0) {
sql_query("CREATE TABLE `UserAngelTypes` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`user_id` INT NOT NULL ,
`angeltype_id` INT NOT NULL ,
`confirm_user_id` INT NULL ,
INDEX ( `user_id` , `angeltype_id` , `confirm_user_id` )
)");
sql_query("INSERT INTO `UserAngelTypes` (`user_id`, `angeltype_id`)
SELECT `User`.`UID`, `AngelTypes`.`id`
FROM `User`
INNER JOIN `AngelTypes`
ON TRIM(TRAILING 'Angel' FROM `User`.`Art`) = `AngelTypes`.`name`");
$applied = true;
}
|