[wbb2] Probleme mit Hacks

Dieses Thema im Forum "Webentwicklung" wurde erstellt von .hik, 8. Juni 2007 .

Schlagworte:
  1. 8. Juni 2007
    Hallo,

    und zwar war ich bei den Guthabenhack v1.9.5 zu installieren.
    Das hat soweit auch gut geklappt.

    Nun wollte ich dazu noch den RPG Shop 1.0 installieren, aber
    wenn ich die thread.php aufrufe kommt folgendes.


    Code:
    SQL-DATABASE ERROR
    
    Database error in WoltLab Burning Board (2.3.6): Invalid SQL: SELECT p.*, pc.cache, u.userposts, u.rpgshop_weapon, u.rpgshop_shield, u.rpgshop_armor, u.rpgshop_helmet, u.rpgshop_boots, u.rpgshop_assec, u.rpgshop_element, u.regdate, u.signature, u.email, u.homepage, u.icq, u.aim, u.yim, u.msn, u.showemail, u.receivepm, u.usercanemail, u.ratingcount, u.ratingpoints, u.gender, u.invisible, u.title, u.lastactivity, u.allowsigsmilies, u.allowsightml, u.allowsigbbcode, u.allowsigimages, u.disablesignature, u.guthaben, r.ranktitle, r.rankimages, i.iconpath, i.icontitle , uf.* , av.avatarid, av.avatarextension, av.width, av.height , g.useronlinemarking FROM bb25_posts p LEFT JOIN bb25_users u USING (userid) LEFT JOIN bb25_ranks r USING (rankid) LEFT JOIN bb25_icons i ON (p.iconid=i.iconid) LEFT JOIN bb25_postcache pc ON (p.postid=pc.postid) LEFT JOIN bb25_userfields uf ON (uf.userid=p.userid) LEFT JOIN bb25_avatars av ON (u.avatarid=av.avatarid) LEFT JOIN bb25_groups g ON (u.useronlinegroupid=g.groupid) WHERE p.postid IN (0,137,138)ORDER BY p.posttime ASC
    mysql error: Unknown column 'u.rpgshop_weapon' in 'field list'
    mysql error number: 1054
    mysql version: 4.1.22-log
    php version: 4.4.7
    Date: 08.06.2007 @ 22:06
    Script: /wbb2/thread.php?postid=138
    Referer:---
    Jetzt wollte ich fragen wo der Fehler sein könnte, ist ein wbb 2.3.6 pl2
    Die thread.php hatte ich jetzt mehrmals durchgecheckt, da dürfte er
    eigentlich nicht drinstecken.



    MfG
    .hik
     
  2. 8. Juni 2007
    AW: [wbb2] Probleme mit Hacks

    So wie ich das sehe steckt
    der Fehler in der mySQL Datenbank.
    Hast du da irgendwas verändert?

    Bzw haben die Hacks was an der mySQL verändert?
     
  3. 8. Juni 2007
    AW: [wbb2] Probleme mit Hacks

    ich denke eher das gegenteil
    du hast wahrscheinlich vergessen den mysql befehl auszuführen, der die spalte rpgshop_weapon (und wahrscheinlich noch mehr) in der tabelle bb1_users einfügt
    guck mal nach, vllt. ist irgentwo eine datei mit der endung .sql
     
  4. 8. Juni 2007
    AW: [wbb2] Probleme mit Hacks

    Stimmt, magst recht haben, darüber habe ich nicht nachgedacht
     
  5. 8. Juni 2007
    AW: [wbb2] Probleme mit Hacks

    Hm, eigentlich müssten die Tabellen soweit vorhanden sein, die sql Datei hab ich ausgeführt.

    Hab mal bei phpmyadmin geschaut:
    rpgshop_weapon | varchar(200) | latin1_german2_ci | Ja | NULL
    und das ist in der Tabelle bb1_users

    Hier mal das was in der sql Datei drinsteht:

    Code:
    DROP TABLE IF EXISTS bb1_rpgshop_armor;
    CREATE TABLE bb1_rpgshop_armor (
     id int(11) NOT NULL auto_increment,
     name varchar(250) NOT NULL default '',
     money int(15) NOT NULL default '0',
     PRIMARY KEY (id));
     
    DROP TABLE IF EXISTS bb1_rpgshop_assec;
    CREATE TABLE bb1_rpgshop_assec (
     id int(11) NOT NULL auto_increment,
     name varchar(250) NOT NULL default '',
     money int(15) NOT NULL default '0',
     PRIMARY KEY (id));
    
    
    DROP TABLE IF EXISTS bb1_rpgshop_boots;
    CREATE TABLE bb1_rpgshop_boots (
     id int(11) NOT NULL auto_increment,
     name varchar(250) NOT NULL default '',
     money int(15) NOT NULL default '0',
     PRIMARY KEY (id));
    
    DROP TABLE IF EXISTS bb1_rpgshop_element;
    CREATE TABLE bb1_rpgshop_element (
     id int(11) NOT NULL auto_increment,
     name varchar(250) NOT NULL default '',
     money int(15) NOT NULL default '0',
     PRIMARY KEY (id));
    
    
    DROP TABLE IF EXISTS bb1_rpgshop_helmet;
    CREATE TABLE bb1_rpgshop_helmet (
     id int(11) NOT NULL auto_increment,
     name varchar(250) NOT NULL default '',
     money int(15) NOT NULL default '0',
     PRIMARY KEY (id));
     
    DROP TABLE IF EXISTS bb1_rpgshop_shield;
    CREATE TABLE bb1_rpgshop_shield (
     id int(11) NOT NULL auto_increment,
     name varchar(250) NOT NULL default '',
     money int(15) NOT NULL default '0',
     PRIMARY KEY (id));
     
    DROP TABLE IF EXISTS bb1_rpgshop_weapon;
    CREATE TABLE bb1_rpgshop_weapon (
     id int(11) NOT NULL auto_increment,
     name varchar(250) NOT NULL default '',
     money int(15) NOT NULL default '0',
     PRIMARY KEY (id));
     
    
    INSERT INTO bb1_rpgshop_armor VALUES (1, 'Leder Ruestung', 100);
    INSERT INTO bb1_rpgshop_armor VALUES (2, 'Robe', 100);
    INSERT INTO bb1_rpgshop_armor VALUES (3, 'Feuer Robe', 230);
    INSERT INTO bb1_rpgshop_armor VALUES (4, 'Eis Robe', 230);
    INSERT INTO bb1_rpgshop_armor VALUES (5, 'Wind Robe', 230);
    INSERT INTO bb1_rpgshop_armor VALUES (6, 'Panzer', 250);
    INSERT INTO bb1_rpgshop_armor VALUES (7, 'Grim Ruestung', 500);
    INSERT INTO bb1_rpgshop_armor VALUES (8, 'Grim Robe', 500);
    INSERT INTO bb1_rpgshop_armor VALUES (9, 'Heilige Ruestung', 1250);
    INSERT INTO bb1_rpgshop_armor VALUES (10, 'Heilige Robe', 1250);
    INSERT INTO bb1_rpgshop_armor VALUES (11, 'Feld Platte', 2750);
    INSERT INTO bb1_rpgshop_armor VALUES (12, 'Volle Platte', 5000);
    INSERT INTO bb1_rpgshop_armor VALUES (13, 'Schatten Umhang', 8000);
    INSERT INTO bb1_rpgshop_armor VALUES (14, 'Gaia Robe', 12500);
    INSERT INTO bb1_rpgshop_armor VALUES (15, 'Mithrill Ruestung', 12500);
    INSERT INTO bb1_rpgshop_armor VALUES (16, 'Schwarze Zauberer Robe', 20000);
    INSERT INTO bb1_rpgshop_armor VALUES (17, 'Onyx Ruestung', 27500);
    INSERT INTO bb1_rpgshop_armor VALUES (18, 'Robe der Toten', 37500);
    INSERT INTO bb1_rpgshop_armor VALUES (19, 'Master Ruestung', 50000);
    INSERT INTO bb1_rpgshop_armor VALUES (20, 'Master Robe', 50000);
    
    INSERT INTO bb1_rpgshop_assec VALUES (1, 'Grim Kette', 500);
    INSERT INTO bb1_rpgshop_assec VALUES (2, 'Feuer Ring', 1000);
    INSERT INTO bb1_rpgshop_assec VALUES (3, 'Eis Ring', 1000);
    INSERT INTO bb1_rpgshop_assec VALUES (4, 'Wikinger Handschuhe', 4000);
    INSERT INTO bb1_rpgshop_assec VALUES (5, 'Gaia Ring', 10000);
    INSERT INTO bb1_rpgshop_assec VALUES (6, 'Drachen Auge', 12500);
    INSERT INTO bb1_rpgshop_assec VALUES (7, 'Kampf Handschuhe', 15000);
    INSERT INTO bb1_rpgshop_assec VALUES (8, 'Saphire Kette', 25000);
    INSERT INTO bb1_rpgshop_assec VALUES (9, 'Rubin Kette', 25000);
    INSERT INTO bb1_rpgshop_assec VALUES (10, 'Handschuhe der Macht', 30000);
    INSERT INTO bb1_rpgshop_assec VALUES (11, 'Drachen Kette', 37500);
    INSERT INTO bb1_rpgshop_assec VALUES (12, 'Master Ring', 50000);
    
    INSERT INTO bb1_rpgshop_boots VALUES (1, 'Leder Schuhe', 100);
    INSERT INTO bb1_rpgshop_boots VALUES (2, 'Hardleder Boots', 250);
    INSERT INTO bb1_rpgshop_boots VALUES (3, 'Grim Boots', 500);
    INSERT INTO bb1_rpgshop_boots VALUES (4, 'Heilige Boots', 1250);
    INSERT INTO bb1_rpgshop_boots VALUES (5, 'Kampf Boots', 5000);
    INSERT INTO bb1_rpgshop_boots VALUES (6, 'Titan Boots', 22500);
    INSERT INTO bb1_rpgshop_boots VALUES (7, 'Master Boots', 50000);
    
    INSERT INTO bb1_rpgshop_element VALUES (1, 'Erde', 250);
    INSERT INTO bb1_rpgshop_element VALUES (2, 'Feuer', 250);
    INSERT INTO bb1_rpgshop_element VALUES (3, 'Heilig', 250);
    INSERT INTO bb1_rpgshop_element VALUES (4, 'Eis', 250);
    INSERT INTO bb1_rpgshop_element VALUES (5, 'Gift', 250);
    INSERT INTO bb1_rpgshop_element VALUES (6, 'Schatten', 250);
    INSERT INTO bb1_rpgshop_element VALUES (7, 'Donner', 250);
    INSERT INTO bb1_rpgshop_element VALUES (8, 'Wasser', 250);
    INSERT INTO bb1_rpgshop_element VALUES (9, 'Wind', 250);
    INSERT INTO bb1_rpgshop_element VALUES (10, 'Kombiniert', 2500);
    
    INSERT INTO bb1_rpgshop_helmet VALUES (1, 'Leder Kappe', 100);
    INSERT INTO bb1_rpgshop_helmet VALUES (2, 'Bronze Helm', 300);
    INSERT INTO bb1_rpgshop_helmet VALUES (3, 'Grim Helm', 500);
    INSERT INTO bb1_rpgshop_helmet VALUES (4, 'Stahl Helm', 800);
    INSERT INTO bb1_rpgshop_helmet VALUES (5, 'Heilige Krone', 1250);
    INSERT INTO bb1_rpgshop_helmet VALUES (6, 'Voller Helm', 5000);
    INSERT INTO bb1_rpgshop_helmet VALUES (7, 'Drachen Helm', 8000);
    INSERT INTO bb1_rpgshop_helmet VALUES (8, 'Wikinger Helm', 12500);
    INSERT INTO bb1_rpgshop_helmet VALUES (9, 'Kristall Helm', 27500);
    INSERT INTO bb1_rpgshop_helmet VALUES (10, 'Master Helm', 50000);
    
    INSERT INTO bb1_rpgshop_shield VALUES (1, 'Hardleder Buckler', 100);
    INSERT INTO bb1_rpgshop_shield VALUES (2, 'Holz Schild', 250);
    INSERT INTO bb1_rpgshop_shield VALUES (3, 'Grim Schild', 500);
    INSERT INTO bb1_rpgshop_shield VALUES (4, 'Heiliges Schild', 1250);
    INSERT INTO bb1_rpgshop_shield VALUES (5, 'Emerald Schild', 10000);
    INSERT INTO bb1_rpgshop_shield VALUES (6, 'Kristall Schild', 27500);
    INSERT INTO bb1_rpgshop_shield VALUES (7, 'Master Schild', 50000);
    
    INSERT INTO bb1_rpgshop_weapon VALUES (1, 'Messer', 50);
    INSERT INTO bb1_rpgshop_weapon VALUES (2, 'Dolch', 80);
    INSERT INTO bb1_rpgshop_weapon VALUES (3, 'Holz Bogen', 100);
    INSERT INTO bb1_rpgshop_weapon VALUES (4, 'Holz Stab', 130);
    INSERT INTO bb1_rpgshop_weapon VALUES (5, 'Kurzes Schwert', 150);
    INSERT INTO bb1_rpgshop_weapon VALUES (6, 'Bambus Bogen', 230);
    INSERT INTO bb1_rpgshop_weapon VALUES (7, 'Hand Axt', 250);
    INSERT INTO bb1_rpgshop_weapon VALUES (8, 'Langes Schwert', 250);
    INSERT INTO bb1_rpgshop_weapon VALUES (9, 'Speer', 250);
    INSERT INTO bb1_rpgshop_weapon VALUES (10, 'Chirijiraden', 400);
    INSERT INTO bb1_rpgshop_weapon VALUES (11, 'Grim Bogen', 500);
    INSERT INTO bb1_rpgshop_weapon VALUES (12, 'Grim Stab', 500);
    INSERT INTO bb1_rpgshop_weapon VALUES (13, 'Grim Schwert', 500);
    INSERT INTO bb1_rpgshop_weapon VALUES (14, 'Kleiner Speer', 600);
    INSERT INTO bb1_rpgshop_weapon VALUES (15, 'Kleine Axt', 650);
    INSERT INTO bb1_rpgshop_weapon VALUES (16, 'Hiyimataraya', 800);
    INSERT INTO bb1_rpgshop_weapon VALUES (17, 'Scimitar', 850);
    INSERT INTO bb1_rpgshop_weapon VALUES (18, 'Grosse Axt', 1200);
    INSERT INTO bb1_rpgshop_weapon VALUES (19, 'Heiliger Bogen', 1250);
    INSERT INTO bb1_rpgshop_weapon VALUES (20, 'Heiliger Speer', 1250);
    INSERT INTO bb1_rpgshop_weapon VALUES (21, 'Heiliger Stab', 1250);
    INSERT INTO bb1_rpgshop_weapon VALUES (22, 'Heiliges Schwert', 1250);
    INSERT INTO bb1_rpgshop_weapon VALUES (23, 'Schwerer Speer', 1750);
    INSERT INTO bb1_rpgshop_weapon VALUES (24, 'Katana Klinge', 2000);
    INSERT INTO bb1_rpgshop_weapon VALUES (25, 'Doppel Axt', 2650);
    INSERT INTO bb1_rpgshop_weapon VALUES (26, '******d Schwert', 5000);
    INSERT INTO bb1_rpgshop_weapon VALUES (27, 'Lebens Stab', 5250);
    INSERT INTO bb1_rpgshop_weapon VALUES (28, 'Kikuichimoji', 6000);
    INSERT INTO bb1_rpgshop_weapon VALUES (29, 'Blut Axt', 7500);
    INSERT INTO bb1_rpgshop_weapon VALUES (30, 'Mithrill Speer', 7500);
    INSERT INTO bb1_rpgshop_weapon VALUES (31, 'Klinge', 10000);
    INSERT INTO bb1_rpgshop_weapon VALUES (32, 'Composite Bogen', 10000);
    INSERT INTO bb1_rpgshop_weapon VALUES (33, 'Koutetsu', 13000);
    INSERT INTO bb1_rpgshop_weapon VALUES (34, 'Metall Stab', 17500);
    INSERT INTO bb1_rpgshop_weapon VALUES (35, 'Saebel', 17500);
    INSERT INTO bb1_rpgshop_weapon VALUES (36, 'Kiyomori', 18750);
    INSERT INTO bb1_rpgshop_weapon VALUES (37, 'Komet Bogen', 22500);
    INSERT INTO bb1_rpgshop_weapon VALUES (38, 'Goddess Speer', 22500);
    INSERT INTO bb1_rpgshop_weapon VALUES (39, 'Kasanagi', 25000);
    INSERT INTO bb1_rpgshop_weapon VALUES (40, 'Master Axt', 50000);
    INSERT INTO bb1_rpgshop_weapon VALUES (41, 'Master Bogen', 50000);
    INSERT INTO bb1_rpgshop_weapon VALUES (42, 'Master Speer', 50000);
    INSERT INTO bb1_rpgshop_weapon VALUES (43, 'Master Stab', 50000);
    INSERT INTO bb1_rpgshop_weapon VALUES (44, 'Master Schwert', 50000);
    
    
    ALTER TABLE bb1_users
    ADD rpgshop_weapon VARCHAR(200) NULL,
    ADD rpgshop_shield VARCHAR(200) NULL,
    ADD rpgshop_armor VARCHAR(200) NULL,
    ADD rpgshop_helmet VARCHAR(200) NULL,
    ADD rpgshop_boots VARCHAR(200) NULL,
    ADD rpgshop_assec VARCHAR(200) NULL,
    ADD rpgshop_element VARCHAR(200) NULL;
    Hier nochmal ein Codeschnipsel aus der thread.php was wohl in
    Zusammenhang stehen könnte

    PHP:
    $result  $db -> query ( "SELECT p.*, pc.cache, 
            u.userposts, u.rpgshop_weapon, u.rpgshop_shield, u.rpgshop_armor, u.rpgshop_helmet, u.rpgshop_boots, u.rpgshop_assec, u.rpgshop_element, u.regdate, u.signature, u.email, u.homepage, u.icq, u.aim, u.yim, u.msn, u.showemail, u.receivepm, u.usercanemail, u.ratingcount, u.ratingpoints, u.gender, u.invisible, u.title, u.lastactivity, u.allowsigsmilies, u.allowsightml, u.allowsigbbcode, u.allowsigimages, u.disablesignature, u.guthaben, 
            r.ranktitle, r.rankimages,
            i.iconpath, i.icontitle
            
    $userfields
            
    $avatar
            
    $marking  
            FROM bb"
    . $n . "_posts p 
            LEFT JOIN bb"
    . $n . "_users u USING (userid)
            LEFT JOIN bb"
    . $n . "_ranks r USING (rankid)
            LEFT JOIN bb"
    . $n . "_icons i ON (p.iconid=i.iconid)
            LEFT JOIN bb"
    . $n . "_postcache pc ON (p.postid=pc.postid)
            
    $userfieldsjoin
            
    $avatarjoin
            
    $markingjoin
            WHERE p.postid IN (0"
    . $this -> postids . ")" . $this -> orderBy );
            
            return 
    $result ;
    MfG
    .hik
     
  6. Video Script

    Videos zum Themenbereich

    * gefundene Videos auf YouTube, anhand der Überschrift.