нужна помощь Адаптация

SmartFon · 13 июля, 2014

<p><p>Уже часа 2 мучаюсь с адаптацией таблици к св 13 все н как рег не проходит кто может сделайте или помогите письменно.

-- ---------------------------
-- Table structure for accounts
-- ---------------------------
CREATE TABLE IF NOT EXISTS `accounts` (
`login` VARCHAR(45) NOT NULL DEFAULT '',
`password` VARCHAR(45) NOT NULL DEFAULT '',
`allowedIPs` varchar(255) NOT NULL default '', -- пишем айпи и разделяем чем хотим
`lastactive` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`access_level` SMALLINT NOT NULL DEFAULT 0,
`lastIP` VARCHAR(15) NOT NULL DEFAULT '',
`lastServer` TINYINT UNSIGNED NOT NULL DEFAULT 1,
`email` VARCHAR(50) NOT NULL DEFAULT '',
`BanReason` VARCHAR(250) NOT NULL DEFAULT '',
PRIMARY KEY (`login`)
) DEFAULT CHARSET=latin1;

<?php

/**

* STRESS WEB

* @author S.T.R.E.S.S.

* @version 13

* @web http://stressweb.ru

*/

if (!defined("STRESSWEB")) die ("Access denied...");

$qList["RT"] = array (

"fields" => array(

"accessLevel"=>"access_level",

"charID"=>"obj_Id",

),

"itemType" => array (

0 => "dress",

1 => "leftearring",

2 => "rightearring",

3 => "necklace",

4 => "leftring",

5 => "rightring",

6 => "helmet",

7 => "weapon",

8 => "shield",

9 => "gloves",

10 => "top",

11 => "lower",

12 => "bots",

13 => "lower",

14 => "weapon",

15 => "righthair",

16 => "weapon",

17 => "lefthair",

18 => "lefthair",

20 => "righthair",

22 => "braslet",

),

"insAccount" => "

INSERT INTO `accounts` (`login`,`password`,`access_level`,`l2email`)

VALUES ('{login}','{pass}','0','{l2email}')",

"insItem" => "

INSERT INTO `items` (`owner_id`,`object_id`,`item_id`,`count`,`enchant_level`,`loc`,`loc_data`)

VALUES ('{ownerID}', '{objectID}', '{itemID}', '{count}', '{enchant}', 'INVENTORY', '0')",

"setPassword" => "

UPDATE `accounts`

SET `password`='{pass}'

WHERE `login`='{login}'",

"setAccessLevelAccount" => "

UPDATE `accounts`

SET `access_level`='{level}'

WHERE `login`='{login}'",

"setAccessLevelCharacter" => "

UPDATE `characters`

SET `accesslevel`='{level}'

WHERE `obj_Id`='{charID}'",

"setTeleport" => "

UPDATE `characters`

SET `x`='{x}',`y`='{y}',`z`='{z}',`lastteleport`='{lastteleport}'

WHERE `obj_Id`='{charID}'",

"setItem" => "

UPDATE `items`

SET `count`='{count}', `enchant_level`='{enchant}'

WHERE `object_id`='{objectID}'",

"setItemCount" => "

UPDATE `items`

SET `count` = '{count}'

WHERE `owner_id` = '{ownerID}' AND `object_id` = '{objectID}'",

"getCountAccounts" => "

SELECT count(0)

FROM accounts {where}",

"getCountCharacters" => "

SELECT count(0)

FROM characters {where}",

"getCountClans" => "

SELECT count(0)

FROM clan_data",

"getCountHuman" => "

SELECT count(0)

FROM characters

WHERE race='0' AND accesslevel='0'",

"getCountElf" => "

SELECT count(0)

FROM characters

WHERE race='1' AND accesslevel='0'",

"getCountDElf" => "

SELECT count(0)

FROM characters

WHERE race='2' AND accesslevel='0'",

"getCountOrc" => "

SELECT count(0)

FROM characters

WHERE race='3' AND accesslevel='0'",

"getCountDwarf" => "

SELECT count(0)

FROM characters

WHERE race='4' AND accesslevel='0'",

"getCountKamael" => "

SELECT count(0)

FROM characters

WHERE race='5' AND accesslevel='0'",

"getCountDawn" => "

SELECT count(0)

FROM seven_signs

WHERE cabal='dawn'",

"getCountDusk" => "

SELECT count(0)

FROM seven_signs

WHERE cabal='dusk'",

"getAccount" => "

SELECT login,password,lastactive,access_level AS accessLevel,lastIP

FROM `accounts`

WHERE `login`='{login}' {where}

LIMIT 1",

"getAccounts" => "

SELECT login,lastactive,access_level,lastIP

FROM `accounts` {where}

ORDER BY {order}

LIMIT {limit}",

"getCharactersList" => "

SELECT characters.account_name, characters.obj_Id, characters.char_name, characters.level, characters.accesslevel, characters.lastAccess, char_templates.ClassName

FROM `characters`

LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId {where}

ORDER BY characters.char_name

LIMIT {limit}",

"getCharacter" => "

SELECT characters.account_name, characters.char_name, characters.level, characters.sex, characters.base_class, characters.online, characters.exp, characters.sp, characters.karma, characters.pvpkills, characters.pkkills, characters.accesslevel, characters.onlinetime, characters.lastAccess, char_templates.ClassName, clan_data.clan_name

FROM `characters`

LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

WHERE characters.obj_Id='{charID}'",

"getCharacterInfo" => "

SELECT characters.account_name, characters.char_name, characters.level, characters.maxHp, characters.maxCp, characters.maxMp, characters.sex, characters.exp, characters.sp, characters.pvpkills, characters.pkkills, characters.karma, characters.race, characters.base_class, characters.accesslevel, characters.lastAccess, char_templates.ClassName, char_templates.STR, char_templates.CON, char_templates.DEX, char_templates._INT, char_templates.WIT, char_templates.MEN

FROM `characters`

LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId

WHERE characters.obj_Id='{charID}'",

"getAccountCharacters" => "

SELECT characters.account_name, characters.obj_Id AS charID, characters.char_name, characters.level, characters.accesslevel, characters.lastAccess, characters.online, characters.onlinetime, characters.in_jail, char_templates.ClassName, clan_data.clan_name

FROM `characters`

LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

WHERE characters.account_name='{account}'

ORDER BY characters.char_name",

"getTopClan"=>"

SELECT clan_data.clan_name, clan_data.clan_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.hasCastle, characters.char_name, ccount

FROM `clan_data`

LEFT JOIN `characters` ON characters.obj_Id = clan_data.leader_id

LEFT JOIN (

SELECT clanid, count(level) AS ccount

FROM characters

WHERE clanid GROUP BY clanid

) AS levels ON clan_data.clan_id = levels.clanid

ORDER BY clan_data.clan_level DESC, clan_data.reputation_score DESC

LIMIT {limit}",

"getTop" => "

SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id

FROM `characters`

LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

WHERE characters.accesslevel='0'

ORDER BY characters.{order} DESC

LIMIT {limit}",

"getRich" => "

SELECT characters.char_name, characters.level, characters.sex, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id, count

FROM `characters`

LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

LEFT JOIN (SELECT owner_id,SUM(count) AS count FROM items WHERE items.item_id={item_id} GROUP BY owner_id) AS count ON characters.obj_Id=count.owner_id

WHERE characters.accesslevel='0'

ORDER BY count DESC, level DESC, onlinetime DESC

LIMIT {limit}",

"getClanCharacters" => "

SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id

FROM `characters`

LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

WHERE characters.clanid='{clanid}'

ORDER BY characters.level DESC",

"getOnline" => "

SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id

FROM `characters`

LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

WHERE characters.accesslevel='0' AND characters.online='1'

ORDER BY characters.level DESC, characters.onlinetime DESC",

"getEpicStatus" => "

SELECT grandboss_data.respawn_time, npc.name, npc.level

FROM grandboss_data

LEFT JOIN npc ON grandboss_data.boss_id = npc.id

ORDER BY npc.level DESC",

"getRaidStatus" => "

SELECT raidboss_spawnlist.respawn_time, npc.level, npc.name

FROM raidboss_spawnlist

LEFT JOIN npc ON raidboss_spawnlist.boss_id = npc.id

ORDER BY npc.level DESC, npc.name ASC",

"getClan" => "

SELECT clan_name

FROM clan_data

WHERE clan_id='{clanid}'",

"getCastles" => "

SELECT castle.name, castle.id, castle.taxPercent, castle.siegeDate, clan_data.clan_name, clan_data.clan_id

FROM castle

LEFT JOIN clan_data ON clan_data.hasCastle = castle.id",

"getSiege" => "

SELECT siege_clans.castle_id, siege_clans.clan_id, siege_clans.type, clan_data.clan_name

FROM siege_clans

LEFT JOIN clan_data ON clan_data.clan_id = siege_clans.clan_id

WHERE castle_id='{castle}'",

"getOlympiad" => "

SELECT olympiad_nobles.char_name, olympiad_nobles.olympiad_points, olympiad_nobles.competitions_done, char_templates.ClassName, characters.sex

FROM olympiad_nobles

LEFT JOIN char_templates ON olympiad_nobles.class_id = char_templates.ClassId

LEFT JOIN characters ON olympiad_nobles.char_id = characters.obj_Id

ORDER BY olympiad_nobles.class_id, olympiad_nobles.olympiad_points DESC",

"getInventory" => "

SELECT items.object_id,items.item_id,items.count,items.enchant_level,items.loc,

CASE WHEN armor.name != '' THEN armor.name

WHEN weapon.name != '' THEN weapon.name

WHEN etcitem.name != '' THEN etcitem.name

END AS name,

CASE WHEN armor.crystal_type != '' THEN 'armor'

WHEN weapon.crystal_type != '' THEN 'weapon'

WHEN etcitem.crystal_type != '' THEN 'etc'

END AS `type`

FROM `items`

LEFT JOIN `armor` ON armor.item_id = items.item_id

LEFT JOIN weapon ON weapon.item_id = items .item_id

LEFT JOIN etcitem ON etcitem.item_id = items.item_id

WHERE items.owner_id='{charID}'

ORDER BY {order}",

"getCharInventory" => "

SELECT items.object_id,items.item_id,items.count,items.enchant_level,items.loc,items.loc_data,armorName,weaponName,etcName,armorType,weaponType,etcType

FROM `items`

LEFT JOIN (

SELECT item_id, name AS armorName, crystal_type AS armorType

FROM `armor`

) AS aa ON aa.item_id = items.item_id

LEFT JOIN (

SELECT item_id, name AS weaponName, crystal_type AS weaponType

FROM `weapon`

) AS ww ON ww.item_id = items.item_id

LEFT JOIN (

SELECT item_id, name AS etcName, crystal_type AS etcType

FROM `etcitem`

) AS ee ON ee.item_id = items.item_id

WHERE items.owner_id='{charID}' AND items.loc='{loc}'

ORDER BY items.loc_data",

"getItemByObjectID" => "

SELECT `count`, `enchant_level`, `item_id`

FROM `items`

WHERE `object_id`='{objectID}'",

"getLastTeleport" => "

SELECT `char_name`,`online`,`accesslevel`,`in_jail`,`lastteleport`

FROM `characters`

WHERE `obj_Id`='{charID}'",

"getItem" => "

SELECT `object_id`, `count`

FROM `items`

WHERE `owner_id` = '{charID}' AND `item_id` = '{itemID}' AND `loc` = 'INVENTORY'

LIMIT 1",

"getMax" => "

SELECT MAX(`object_id`)+1 AS `max`

FROM `items`",

"delAccounts" => "

DELETE FROM accounts

WHERE login='{login}'",

"delItemByID" => "

DELETE FROM `items`

WHERE `item_id`='{item}'",

"delCharByID" => "

DELETE FROM `characters`

WHERE `obj_Id`='{charID}'",

"delItemByOwner" => "

DELETE FROM `items`

WHERE `owner_id`='{charID}'",

"delItemByObjectID" => "

DELETE FROM `items`

WHERE `object_id`='{objectID}'",

"delItemByIDOwner" => "

DELETE FROM `items`

WHERE `item_id`='{item}' AND `owner_id`='{charID}'",

"other" => array(

"DELETE FROM character_friends WHERE char_id='{charID}' OR friend_id='{charID}'",

"DELETE FROM character_hennas WHERE char_obj_id='{charID}'",

"DELETE FROM character_macroses WHERE char_obj_id='{charID}'",

"DELETE FROM character_quests WHERE char_id='{charID}'",

"DELETE FROM character_recipebook WHERE char_id='{charID}'",

"DELETE FROM character_shortcuts WHERE char_obj_id='{charID}'",

"DELETE FROM character_skills WHERE char_obj_id='{charID}'",

"DELETE FROM character_skills_save WHERE char_obj_id='{charID}'",

"DELETE FROM character_subclasses WHERE char_obj_id='{charID}'",

"DELETE FROM seven_signs WHERE char_obj_id='{charID}'",

"DELETE FROM items WHERE owner_id='{charID}'",

"DELETE FROM clan_data WHERE leader_id='{charID}'",

),

"l2top" => array(

"getChar" => "

SELECT account_name, obj_Id AS charID, online

FROM `characters`

WHERE `char_name`='{name}'",

"getItem" => "

SELECT `item_id`,`count`

FROM `items`

WHERE `owner_id`='{ownerID}' AND `item_id`='{itemID}' AND `loc`='INVENTORY'",

"getMax" => "

SELECT MAX(`object_id`)+1 AS `max`

FROM `items`",

"insItem" => "

INSERT INTO `items` (`owner_id`,`object_id`,`item_id`,`count`,`enchant_level`,`loc`,`loc_data`)

VALUES ('{charID}', '{objectID}', '{itemID}', '{count}', '0', 'INVENTORY', '0')",

"insl2top" => "

INSERT INTO `l2top` (`nick`,`ip`,`time`)

VALUES ('{nick}','{ip}','{time}')",

"setItem" => "

UPDATE `items`

SET `count`=`count`+'{count}'

WHERE `owner_id`='{ownerID}' AND `item_id`='{itemID}' AND `loc`='INVENTORY'",

),

);

?>

Изменено 13 июля, 2014 пользователем SmartFon

SmartFon · 13 июля, 2014

Решил проблему, тема закрыта.

Войти

нужна помощь Адаптация

Рекомендуемые сообщения

SmartFon 7

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

SmartFon 7

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Последние посетители 0 пользователей онлайн

Сайт

Активность

Магазин

My Details