pwAdmin [web shop, item builder] v1.0

Page 1 of 3 123 LastLast
Results 1 to 15 of 42
  1. #1
    Account Upgraded | Title Enabled! shadowvzs is offline
    True MemberRank
    Jul 2007 Join Date
    RomaniaLocation
    659Posts

    pwAdmin [web shop, item builder] v1.1


    RaGEZONE Recommends

    RaGEZONE Recommends

    with 1.5.3


    with 1.4.1 (short trailer)


    Download from: https://drive.google.com/open?id=0Bz...UhPMndjUjRnSHc
    (.7z content same than .tar.gz)
    GIT:https://github.com/shadowvzs/pwAdmin...master/pwAdmin

    Screenshots:
    pwAdmin v1.0 - Album on Imgur

    Basic Description:
    • What used: CSS3, HTML5, PHP 5.3+, JavaScript (Ajax+JSON too) - Notepad++
    • What not used: JQuery, Frameworks etc
    • User data manageing (MySQL, Session, security and administration stuff)
    • Packet sending to ports (data sending to game database)
    • Data conversion (decimal to HexDec, Rev HexDecimal, Hex Floating Point etc) string, number and DOM element manipulation


    What it can do:

    • Server data settings wizard what help to setting, database creation and veryfication
    • Account manageing (registration, login, self data changeing, administration tools for admin)
    • Optional Web Config Panel, optional menus
    • Advanced and very detailed item XML builder with alot option customization
    • Advanced Web Shop (based mainly on web point[MySQL]), very much option (included timed item, timed discounts etc)



    Help for Password types:


    Notice if you useubuntu 16.04+php 7:
    - don't forget enable mysqli/sockets extension for normal page rendering
    /etc/php/7.0/apache2/php.ini

    - don't forget disable admin flag engine for phpmyadmin:
    /etc/apache2/mods-enabled/apache2/php7.0.conf



    Last Update:
    - added project to github: https://github.com/shadowvzs/pwAdmin...master/pwAdmin
    - tested on php7 and need to enable mysqli extension in etc/php/apache2/php.ini file if not enabled defaultly
    - fixed a minor issue (i fixed a function call in userdata changer php file)
    - rewrote everything and replaced iframe with Ajax+JSON (because more trendy), => the files restructured.
    - to understand how it's changed many thing, iframe was used for dom manipulation, secure back-end actions etc, now divided, separated with back-end actions and dom manipulation will executed in main .js after Ajax response with hanglers, content now loaded into main page div and not in iframe (example news.php content on index.php)
    - item builder don't use anymore file storage for webshop items, only MySQL.
    - Web shop item manageing is real time now, no load/save option, it is saved new item when you add to shop/update in mysql when you update it, delete from db when you click to delete and don't need save anymore (if somehow can't execute the mysql query then interface also not updated!)
    - added +1 password type, for HRace vmware pack
    - minor fixes
    - mini youtube trailer how its work with PW MS remake (1.4.1) difference is you need choose 1.4.1 (default), password type VarBin, item id limit to 32000


    More accurate description coming soon
    since ragezone not let me to add description so i wrote here
    Forum link 2
    Last edited by shadowvzs; 10-09-17 at 01:49 PM.
    PW retro package - PW MS, PWI, PW MY-EN, PW RU(1.3.1 - 1.4.2)
    PW MS Remake
    PhP based pwAdmin
    Adv. Octet Editor n Mailer


  2. #2
    Member gebryas is offline
    MemberRank
    Mar 2014 Join Date
    51Posts

    Re: pwAdmin [web shop, item builder] v1.0

    tkx for release , but why i cant find the config.php file :D

    ***
    edit >>>
    i see :)))))))))))))))))))

  3. #3
    Account Upgraded | Title Enabled! shadowvzs is offline
    True MemberRank
    Jul 2007 Join Date
    RomaniaLocation
    659Posts

    Re: pwAdmin [web shop, item builder] v1.0

    Quote Originally Posted by gebryas View Post
    tkx for release , but why i cant find the config.php file :D

    ***
    edit >>>
    i see :)))))))))))))))))))
    if missing then automatically redirecting to setup.php from index.php. its mean if no config.php then setup wizard starting what help in setup so if you done with setup that create the config.


    sadly i cant add more description because permission denied by ragezone:
    Error code 15

    This request was blocked by the security rules

    Last edited by shadowvzs; 22-06-17 at 05:39 AM.
    PW retro package - PW MS, PWI, PW MY-EN, PW RU(1.3.1 - 1.4.2)
    PW MS Remake
    PhP based pwAdmin
    Adv. Octet Editor n Mailer

  4. #4
    Hardcore Member jagayana is offline
    MemberRank
    Oct 2015 Join Date
    102Posts

    Re: pwAdmin [web shop, item builder] v1.0

    I can't go forward
    Setup: Step 2 - Database
    My database name authd
    Load from /var/www/SQL/authd.sql
    Password Type MD5
    Then Confirm
    and stop there, can't go forward

  5. #5
    Account Upgraded | Title Enabled! shadowvzs is offline
    True MemberRank
    Jul 2007 Join Date
    RomaniaLocation
    659Posts

    Re: pwAdmin [web shop, item builder] v1.0

    Maybe have something in your file what not let execute the .SQL, or wrong path or permission.

    Try create with the default SQL what is in this pack.
    PW retro package - PW MS, PWI, PW MY-EN, PW RU(1.3.1 - 1.4.2)
    PW MS Remake
    PhP based pwAdmin
    Adv. Octet Editor n Mailer

  6. #6
    Member gebryas is offline
    MemberRank
    Mar 2014 Join Date
    51Posts

    Re: pwAdmin [web shop, item builder] v1.0

    after creating database with ur sql files , the panel cant register user ! i check many times

  7. #7
    Account Upgraded | Title Enabled! shadowvzs is offline
    True MemberRank
    Jul 2007 Join Date
    RomaniaLocation
    659Posts

    Re: pwAdmin [web shop, item builder] v1.0

    It's very weird since everytime I checked it's worked.
    You did everything how it is in video?
    Script is on same host than MySQL?
    U use Ubuntu ?
    Do you have error?
    If you want I can check with TeamViewer since it's interesting.
    PW retro package - PW MS, PWI, PW MY-EN, PW RU(1.3.1 - 1.4.2)
    PW MS Remake
    PhP based pwAdmin
    Adv. Octet Editor n Mailer

  8. #8
    Hardcore Member jagayana is offline
    MemberRank
    Oct 2015 Join Date
    102Posts

    Re: pwAdmin [web shop, item builder] v1.0

    Quote Originally Posted by jagayana View Post
    I can't go forward
    Setup: Step 2 - Database
    My database name authd
    Load from /var/www/SQL/authd.sql
    Password Type MD5
    Then Confirm
    and stop there, can't go forward
    This is my authd.sql content :

    Spoiler:
    use pw;SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";CREATE TABLE IF NOT EXISTS `auth` ( `userid` int(11) NOT NULL DEFAULT '0', `zoneid` int(11) NOT NULL DEFAULT '0', `rid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`userid`,`zoneid`,`rid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE IF NOT EXISTS `forbid` ( `userid` int(11) NOT NULL DEFAULT '0', `type` int(11) NOT NULL DEFAULT '0', `ctime` datetime NOT NULL, `forbid_time` int(11) NOT NULL DEFAULT '0', `reason` blob NOT NULL, `gmroleid` int(11) DEFAULT '0', PRIMARY KEY (`userid`,`type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE IF NOT EXISTS `iplimit` ( `uid` int(11) NOT NULL DEFAULT '0', `ipaddr1` int(11) DEFAULT '0', `ipmask1` varchar(2) DEFAULT '', `ipaddr2` int(11) DEFAULT '0', `ipmask2` varchar(2) DEFAULT '', `ipaddr3` int(11) DEFAULT '0', `ipmask3` varchar(2) DEFAULT '', `enable` char(1) DEFAULT '', `lockstatus` char(1) DEFAULT '', PRIMARY KEY (`uid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE IF NOT EXISTS `point` ( `uid` int(11) NOT NULL DEFAULT '0', `aid` int(11) NOT NULL DEFAULT '0', `time` int(11) NOT NULL DEFAULT '0', `zoneid` int(11) DEFAULT '0', `zonelocalid` int(11) DEFAULT '0', `accountstart` datetime DEFAULT NULL, `lastlogin` datetime DEFAULT NULL, `enddate` datetime DEFAULT NULL, PRIMARY KEY (`uid`,`aid`), KEY `IX_point_aidzoneid` (`aid`,`zoneid`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE `roles` ( `account_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, `role_name` varchar(32) NOT NULL, `role_level` smallint(6) NOT NULL, `role_race` tinyint(4) NOT NULL, `role_occupation` tinyint(4) NOT NULL, `role_gender` tinyint(4) NOT NULL, `role_spouse` int(11) NOT NULL, `faction_id` int(11) NOT NULL, `faction_name` varchar(32) NOT NULL, `faction_level` int(11) NOT NULL, `faction_domains` varchar(132) NOT NULL, `role_faction_rank` int(11) NOT NULL, `pvp_time` int(11) NOT NULL, `pvp_kills` int(11) NOT NULL, `pvp_deads` int(11) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE IF NOT EXISTS `usecashlog` ( `userid` int(11) NOT NULL DEFAULT '0', `zoneid` int(11) NOT NULL DEFAULT '0', `sn` int(11) NOT NULL DEFAULT '0', `aid` int(11) NOT NULL DEFAULT '0', `point` int(11) NOT NULL DEFAULT '0', `cash` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', `creatime` datetime NOT NULL, `fintime` datetime NOT NULL, KEY `IX_usecashlog_creatime` (`creatime`), KEY `IX_usecashlog_uzs` (`userid`,`zoneid`,`sn`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE IF NOT EXISTS `usecashnow` ( `userid` int(11) NOT NULL DEFAULT '0', `zoneid` int(11) NOT NULL DEFAULT '0', `sn` int(11) NOT NULL DEFAULT '0', `aid` int(11) NOT NULL DEFAULT '0', `point` int(11) NOT NULL DEFAULT '0', `cash` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', `creatime` datetime NOT NULL, PRIMARY KEY (`userid`,`zoneid`,`sn`), KEY `IX_usecashnow_creatime` (`creatime`), KEY `IX_usecashnow_status` (`status`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE IF NOT EXISTS `users` ( `ID` int(11) NOT NULL DEFAULT '0', `name` varchar(32) NOT NULL DEFAULT '', `passwd` varchar(64) NOT NULL, `Prompt` varchar(32) NOT NULL DEFAULT '', `answer` varchar(32) NOT NULL DEFAULT '', `truename` varchar(32) NOT NULL DEFAULT '', `idnumber` varchar(32) NOT NULL DEFAULT '', `email` varchar(64) NOT NULL DEFAULT '', `mobilenumber` varchar(32) DEFAULT '', `province` varchar(32) DEFAULT '', `city` varchar(32) DEFAULT '', `phonenumber` varchar(32) DEFAULT '', `address` varchar(64) DEFAULT '', `postalcode` varchar(8) DEFAULT '', `gender` int(11) DEFAULT '0', `birthday` datetime DEFAULT NULL, `creatime` datetime NOT NULL, `qq` varchar(32) DEFAULT '', `passwd2` varchar(64) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `IX_users_name` (`name`), KEY `IX_users_creatime` (`creatime`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;DELIMITER $$CREATE PROCEDURE `acquireuserpasswd`(in name1 VARCHAR(64), out uid1 INTEGER, out passwd1 VARCHAR(64))BEGINDECLARE passwdtemp VARCHAR(64);START TRANSACTION;SELECT id, passwd INTO uid1, passwdtemp FROM users WHERE name = name1;SELECT passwdtemp INTO passwd1;COMMIT;END$$CREATE PROCEDURE `addForbid`(in userid1 INTEGER, in type1 INTEGER, in forbid_time1 INTEGER, in reason1 BINARY(255), in gmroleid1 INTEGER)BEGIN DECLARE rowcount INTEGER; START TRANSACTION; UPDATE forbid SET ctime = now(), forbid_time = forbid_time1, reason = reason1, gmroleid = gmroleid1 WHERE userid = userid1 AND type = type1; SET rowcount = ROW_COUNT(); IF rowcount = 0 THEN INSERT INTO forbid VALUES(userid1, type1, now(), forbid_time1, reason1, gmroleid); END IF; COMMIT;END$$CREATE PROCEDURE `addGM`(in userid INTEGER, in zoneid INTEGER)BEGIN DECLARE x INTEGER; START TRANSACTION; SET x = 0; WHILE x < 12 DO INSERT INTO auth VALUES (userid, zoneid, x); SET x = x + 1; END WHILE; SET x = 100; WHILE x < 106 DO INSERT INTO auth VALUES (userid, zoneid, x); SET x = x + 1; END WHILE; SET x = 200; WHILE x < 215 DO INSERT INTO auth VALUES (userid, zoneid, x); SET x = x + 1; END WHILE; SET x = 500; WHILE x < 519 DO INSERT INTO auth VALUES (userid, zoneid, x); SET x = x + 1; END WHILE; COMMIT;END$$CREATE PROCEDURE `adduser`( in name1 VARCHAR(64), in passwd1 VARCHAR(64), in prompt1 VARCHAR(32), in answer1 VARCHAR(32), in truename1 VARCHAR(32), in idnumber1 VARCHAR(32), in email1 VARCHAR(32), in mobilenumber1 VARCHAR(32), in province1 VARCHAR(32), in city1 VARCHAR(32), in phonenumber1 VARCHAR(32), in address1 VARCHAR(64), in postalcode1 VARCHAR(8), in gender1 INTEGER, in birthday1 VARCHAR(32), in qq1 VARCHAR(32), in passwd21 VARCHAR(64))BEGIN DECLARE idtemp INTEGER; SELECT IFNULL(MAX(id), 16) + 16 INTO idtemp FROM users; INSERT INTO users (id,name,passwd,prompt,answer,truename,idnumber,email,mobilenumber,province,city,phonenumber,address,postalcode,gender,birthday,creatime,qq,passwd2) VALUES( idtemp, name1, passwd1, prompt1, answer1, truename1, idnumber1, email1, mobilenumber1, province1, city1, phonenumber1, address1, postalcode1, gender1, birthday1, now(), qq1, passwd21 );END$$CREATE PROCEDURE `adduserpoint`(in uid1 INTEGER, in aid1 INTEGER, in time1 INTEGER)BEGIN DECLARE rowcount INTEGER; START TRANSACTION; UPDATE point SET time = IFNULL(time,0) + time1 WHERE uid1 = uid AND aid1 = aid; SET rowcount = ROW_COUNT(); IF rowcount = 0 THEN INSERT INTO point (uid,aid,time) VALUES (uid1,aid1,time1); END IF; COMMIT;END$$CREATE PROCEDURE `addUserPriv`(in userid INTEGER, in zoneid INTEGER, in rid INTEGER)BEGIN START TRANSACTION; INSERT INTO auth VALUES(userid, zoneid, rid); COMMIT;END$$CREATE PROCEDURE `changePasswd`(in name1 VARCHAR(64), in passwd1 VARCHAR(64))BEGIN START TRANSACTION; UPDATE users SET passwd = passwd1 WHERE name = name1; COMMIT;END$$CREATE PROCEDURE `changePasswd2`(in name1 VARCHAR(64), in passwd21 VARCHAR(64))BEGIN START TRANSACTION; UPDATE users SET passwd2 = passwd21 WHERE name = name1; COMMIT;END$$CREATE PROCEDURE `clearonlinerecords`(in zoneid1 INTEGER, in aid1 INTEGER)BEGIN START TRANSACTION; UPDATE point SET zoneid = NULL, zonelocalid = NULL WHERE aid = aid1 AND zoneid = zoneid1; COMMIT;END$$CREATE PROCEDURE `deleteTimeoutForbid`(in userid1 INTEGER)BEGIN START TRANSACTION; DELETE FROM forbid WHERE userid = userid1 AND timestampdiff(second, ctime, now()) > forbid_time; COMMIT;END$$CREATE PROCEDURE `delUserPriv`(in userid1 INTEGER, in zoneid1 INTEGER, in rid1 INTEGER, in deltype1 INTEGER)BEGINSTART TRANSACTION; IF deltype1 = 0 THEN DELETE FROM auth WHERE userid = userid1 AND zoneid = zoneid1 AND rid = rid1; ELSE IF deltype1 = 1 THEN DELETE FROM auth WHERE userid = userid1 AND zoneid = zoneid1; ELSE IF deltype1 = 2 THEN DELETE FROM auth WHERE userid = userid1; END IF; END IF; END IF;COMMIT;END$$CREATE PROCEDURE `enableiplimit`(in uid1 INTEGER, in enable1 CHAR(1))BEGIN DECLARE rowcount INTEGER; START TRANSACTION; UPDATE iplimit SET enable=enable1 WHERE uid=uid1; SET rowcount = ROW_COUNT(); IF rowcount = 0 THEN INSERT INTO iplimit (uid,enable) VALUES (uid1,enable1); END IF; COMMIT;END$$CREATE PROCEDURE `lockuser`(in uid1 INTEGER, in lockstatus1 CHAR(1))BEGIN DECLARE rowcount INTEGER; START TRANSACTION; UPDATE iplimit SET lockstatus=lockstatus1 WHERE uid=uid1; SET rowcount = ROW_COUNT(); IF rowcount = 0 THEN INSERT INTO iplimit (uid,lockstatus,enable) VALUES (uid1,lockstatus1,'t'); END IF; COMMIT;END$$CREATE PROCEDURE `recordoffline`(in uid1 INTEGER, in aid1 INTEGER, inout zoneid1 INTEGER, inout zonelocalid1 INTEGER, inout overwrite1 INTEGER)BEGIN DECLARE rowcount INTEGER; START TRANSACTION; UPDATE point SET zoneid = NULL, zonelocalid = NULL WHERE uid = uid1 AND aid = aid1 AND zoneid = zoneid1; SET rowcount = ROW_COUNT(); IF overwrite1 = rowcount THEN SELECT zoneid, zonelocalid INTO zoneid1, zonelocalid1 FROM point WHERE uid = uid1 AND aid = aid1; END IF; COMMIT;END$$CREATE PROCEDURE `recordonline`(in uid1 INTEGER, in aid1 INTEGER, inout zoneid1 INTEGER, inout zonelocalid1 INTEGER, inout overwrite INTEGER)BEGIN DECLARE tmp_zoneid INTEGER; DECLARE tmp_zonelocalid INTEGER; DECLARE rowcount INTEGER; START TRANSACTION; SELECT SQL_CALC_FOUND_ROWS zoneid, zonelocalid INTO tmp_zoneid, tmp_zonelocalid FROM point WHERE uid = uid1 and aid = aid1; SET rowcount = FOUND_ROWS(); IF rowcount = 0 THEN INSERT INTO point (uid, aid, time, zoneid, zonelocalid, lastlogin) VALUES (uid1, aid1, 0, zoneid1, zonelocalid1, now()); ELSE IF tmp_zoneid IS NULL OR overwrite = 1 THEN UPDATE point SET zoneid = zoneid1, zonelocalid = zonelocalid1, lastlogin = now() WHERE uid = uid1 AND aid = aid1; END IF; END IF; IF tmp_zoneid IS NULL THEN SET overwrite = 1; ELSE SET zoneid1 = tmp_zoneid; SET zonelocalid1 = tmp_zonelocalid; END IF; COMMIT;END$$CREATE PROCEDURE `remaintime`(in uid1 INTEGER, in aid1 INTEGER, out remain INTEGER, out freetimeleft INTEGER)BEGIN DECLARE enddate1 DATETIME; DECLARE now1 DATETIME; DECLARE rowcount INTEGER; START TRANSACTION; SET now1 = now(); IF aid1 = 0 THEN SET remain = 86313600; SET enddate1 = date_add(now1, INTERVAL '30' DAY); ELSE SELECT time, IFNULL(enddate, now1) INTO remain, enddate1 FROM point WHERE uid = uid1 AND aid = aid1; SET rowcount = ROW_COUNT(); IF rowcount = 0 THEN SET remain = 0; INSERT INTO point (uid,aid,time) VALUES (uid1, aid1, remain); END IF; END IF; SET freetimeleft = 0; IF enddate1 > now1 THEN SET freetimeleft = timestampdiff(second, now1, enddate1); END IF; COMMIT;END$$CREATE PROCEDURE `setiplimit`(in uid1 INTEGER, in ipaddr11 INTEGER, in ipmask11 VARCHAR(2), in ipaddr21 INTEGER, in ipmask21 VARCHAR(2), in ipaddr31 INTEGER, in ipmask31 VARCHAR(2), in enable1 CHAR(1))BEGIN DECLARE rowcount INTEGER; START TRANSACTION; UPDATE iplimit SET ipaddr1 = ipaddr11, ipmask1 = ipmask11, ipaddr2 = ipaddr21, ipmask2 = ipmask21, ipaddr3 = ipaddr31, ipmask3 = ipmask31 WHERE uid = uid1; SET rowcount = ROW_COUNT(); IF rowcount = 0 THEN INSERT INTO iplimit (uid, ipaddr1, ipmask1, ipaddr2, ipmask2, ipaddr3, ipmask3, enable1) VALUES (uid1, ipaddr11, ipmask11, ipaddr21, ipmask21, ipaddr31, ipmask31,'t'); END IF; COMMIT;END$$CREATE PROCEDURE `updateUserInfo`( in name1 VARCHAR(32), in prompt1 VARCHAR(32), in answer1 VARCHAR(32), in truename1 VARCHAR(32), in idnumber1 VARCHAR(32), in email1 VARCHAR(32), in mobilenumber1 VARCHAR(32), in province1 VARCHAR(32), in city1 VARCHAR(32), in phonenumber1 VARCHAR(32), in address1 VARCHAR(32), in postalcode1 VARCHAR(32), in gender1 INTEGER, in birthday1 VARCHAR(32), in qq1 VARCHAR(32) )BEGIN START TRANSACTION; UPDATE users SET prompt = prompt1, answer = answer1, truename = truename1, idnumber = idnumber1, email = email1, mobilenumber = mobilenumber1, province = province1, city = city1, phonenumber = phonenumber1, address = address1, postalcode = postalcode1, gender = gender1, birthday = birthda1, qq = qq1 WHERE name = name1; COMMIT;END$$CREATE PROCEDURE `usecash`( in userid1 INTEGER, in zoneid1 INTEGER, in sn1 INTEGER, in aid1 INTEGER, in point1 INTEGER, in cash1 INTEGER, in status1 INTEGER, out error INTEGER)BEGINDECLARE sn_old INTEGER;DECLARE aid_old INTEGER;DECLARE point_old INTEGER;DECLARE cash_old INTEGER;DECLARE status_old INTEGER;DECLARE createtime_old DATETIME;DECLARE time_old INTEGER;DECLARE need_restore INTEGER;DECLARE exists1 INTEGER;DECLARE rowcount INTEGER;START TRANSACTION; SET error = 0; SET need_restore = 0; SELECT SQL_CALC_FOUND_ROWS sn, aid, point, cash, status, creatime INTO sn_old, aid_old, point_old, cash_old, status_old, createtime_old FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND sn >= 0; SET rowcount = FOUND_ROWS(); IF rowcount = 1 THEN SET exists1 = 1; ELSE SET exists1 = 0; END IF; IF status1 = 0 THEN IF exists1 = 0 THEN SELECT aid, point INTO aid1, point1 FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn1; SET point1 = IFNULL(point1,0); UPDATE point SET time = time-point1 WHERE uid = userid1 AND aid = aid1 AND time >= point1; SET rowcount = ROW_COUNT(); IF rowcount = 1 THEN UPDATE usecashnow SET sn = 0, status = 1 WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn1; ELSE SET error = -8; END IF; END IF; ELSE IF status1 = 1 THEN IF exists1 = 0 THEN UPDATE point SET time = time-point1 WHERE uid = userid1 AND aid = aid1 AND time >= point1; SET rowcount = ROW_COUNT(); IF rowcount = 1 THEN INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES (userid1, zoneid1, sn1, aid1, point1, cash1, status1, now()); ELSE INSERT INTO usecashnow SELECT userid1, zoneid1, IFNULL(min(sn),0)-1, aid1, point1, cash1, 0, now() FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND 0 >= sn; SET error = -8; END IF; ELSE INSERT INTO usecashnow SELECT userid1, zoneid1, IFNULL(min(sn),0)-1, aid1, point1, cash1, 0, now() FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND 0 >= sn; SET error = -7; END IF; ELSE IF status1 = 2 THEN IF exists1 = 1 AND status_old = 1 AND sn_old = 0 THEN UPDATE usecashnow SET sn = sn1, status = status1 WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn_old; ELSE SET error = -9; END IF; ELSE IF status1 = 3 THEN IF exists1 = 1 AND status_old = 2 THEN UPDATE usecashnow SET status = status1 WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn_old; ELSE SET error = -10; END IF; ELSE IF status1 = 4 THEN IF exists1 = 1 THEN DELETE FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn_old; INSERT INTO usecashlog (userid, zoneid, sn, aid, point, cash, status, creatime, fintime) VALUES (userid1, zoneid1, sn_old, aid_old, point_old, cash_old, status1, createtime_old, now()); END IF; IF NOT (exists1 = 1 AND status_old = 3) THEN SET error = -11; END IF; ELSE SET error = -12; END IF; END IF; END IF; END IF; END IF; IF need_restore = 1 THEN UPDATE point SET time = time+point_old WHERE uid = userid1 AND aid = aid_old; DELETE FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn_old; INSERT INTO usecashlog (userid, zoneid, sn, aid, point, cash, status, creatime, fintime) VALUES (userid1, zoneid1, sn_old, aid_old, point_old, cash_old, status1, createtime_old, now()); END IF;COMMIT;END$$DELIMITER ;

  9. #9
    Account Upgraded | Title Enabled! shadowvzs is offline
    True MemberRank
    Jul 2007 Join Date
    RomaniaLocation
    659Posts

    Re: pwAdmin [web shop, item builder] v1.0

    i checked.

    MySQL part where u can create db is perfectly work, account creation aswell only problem is if you choose "skip vote settings" then don't will created +2 column and thats make a minor error so after reg not let autologin.

    i fixed this, also added NOICON version.
    my advice redownload it...

    your sql at 1st row say "use pw" but i use this

    $command="$mysqlP -u$user -p$passwd $db < $SQLpath 2>&1";
    $output=shell_exec($command);
    try remove 1st row since my shell command directly insert into selected database....
    PW retro package - PW MS, PWI, PW MY-EN, PW RU(1.3.1 - 1.4.2)
    PW MS Remake
    PhP based pwAdmin
    Adv. Octet Editor n Mailer

  10. #10
    Hardcore Member jagayana is offline
    MemberRank
    Oct 2015 Join Date
    102Posts

    Re: pwAdmin [web shop, item builder] v1.0

    Quote Originally Posted by shadowvzs View Post
    your sql at 1st row say "use pw" but i use this


    try remove 1st row since my shell command directly insert into selected database....
    Yes, i already remove 1st row
    Still can't go forward

    Thank you for the answer

  11. #11
    Account Upgraded | Title Enabled! shadowvzs is offline
    True MemberRank
    Jul 2007 Join Date
    RomaniaLocation
    659Posts

    Re: pwAdmin [web shop, item builder] v1.0

    Quote Originally Posted by jagayana View Post
    Yes, i already remove 1st row
    Still can't go forward

    Thank you for the answer
    Tryed my SQL?
    Because I tryed multiple times and it's work flawless, if you want then upload somewhere your sql and send the link to me, so I can check.
    PW retro package - PW MS, PWI, PW MY-EN, PW RU(1.3.1 - 1.4.2)
    PW MS Remake
    PhP based pwAdmin
    Adv. Octet Editor n Mailer

  12. #12
    Hardcore Member jagayana is offline
    MemberRank
    Oct 2015 Join Date
    102Posts

    Re: pwAdmin [web shop, item builder] v1.0

    Quote Originally Posted by shadowvzs View Post
    Tryed my SQL?
    Because I tryed multiple times and it's work flawless, if you want then upload somewhere your sql and send the link to me, so I can check.
    This is my authd.sql

  13. #13
    Account Upgraded | Title Enabled! shadowvzs is offline
    True MemberRank
    Jul 2007 Join Date
    RomaniaLocation
    659Posts

    Re: pwAdmin [web shop, item builder] v1.0

    Quote Originally Posted by jagayana View Post
    This is my authd.sql
    i removed first 2 non empty line from your sql and setted to base64 the password and can login with account on web ...
    PW retro package - PW MS, PWI, PW MY-EN, PW RU(1.3.1 - 1.4.2)
    PW MS Remake
    PhP based pwAdmin
    Adv. Octet Editor n Mailer

  14. #14
    Hardcore Member jagayana is offline
    MemberRank
    Oct 2015 Join Date
    102Posts

    Re: pwAdmin [web shop, item builder] v1.0

    Quote Originally Posted by shadowvzs View Post
    i removed first 2 non empty line from your sql and setted to base64 the password and can login with account on web ...
    Can you share it ?

  15. #15
    Account Upgraded | Title Enabled! crucifix is offline
    True MemberRank
    Jan 2012 Join Date
    205Posts

    Re: pwAdmin [web shop, item builder] v1.0

    cant wait to try this




Page 1 of 3 123 LastLast

Advertisement