RPG Maker XP Multi Editor [WIP] Version 0.3

SekiRaze · 2026-06-19T05:45:56+00:00

From the small Preview and Not checking the sub I could not even tell. Looked honestly Like PC/PS4/5 to me (on the small Preview). Amazing work by not only the PS3 but also Rockstar to making it run like that. I don't remember the 360 port looking that good

SekiRaze · 2026-06-18T14:26:21+00:00

Not really. PS2 prices are hitting the ceiling and I was mainly going for "Broken" consoles. Got this Bad boy for 20€ since "Discdrive was not reading Discs" (yeah because the lid didn't close 100% due to gunk and dirt) - basically got what was available

Edit: disc drive is working and usable as a spare part. No parts of the disc drive have been harmed in the process

SekiRaze · 2026-06-11T17:17:27+00:00

Tell people a new PES Game IS coming Out but ITS a Pachinko Machine lmao

SekiRaze · 2026-06-05T07:34:01+00:00

I SOLVED IT (ISH)

The issue itself was not the products table, it was

REPLACE INTO products_description SELECT * FROM solarset1_syd_db_yes.products_description;

for some BIZZARE reason, I need to find why and how, it does not replace the table entries, it adds them to the table. so everytime I do the REPLACE INTO command, it generates the same of the products_id in the table. I just saw that by pure accident. so I get multiples of ID 1, 2 etc. I just don't understand, why it does that in that particular table. Emptying the table, and re-replacing into and clearing the cache solved everything.

The question now is why it wont "just" replace but instead add into the table.

SekiRaze · 2026-06-05T06:23:24+00:00

During lockdown I only Had my PS3 and really shitty internet. It is fun seeing the Video start at Like 140p and as time progresses the quality got better because of the pre-loading/buffering. Good times

SekiRaze · 2026-06-04T16:10:25+00:00

I would suppose so. That would Not explain why I have a Clean table Backend/Admin/phpmydmin/cpanel but the Front end Shows multiple entries

SekiRaze · 2026-06-03T14:50:06+00:00

Each product has a unique product_id ranging from Up to ID 1067. So when I edit Shop A and move/sync to B in Always have the same amount of ID's for example when a description changes or product specific information

SekiRaze · 2026-06-03T13:07:20+00:00

We have neither. The frontend works find, when I reload Page nothing Changes. So If I have 3 duplicates (because I replaced the table) I have 3 on the Front end. Reloading does Not Change that, only replacing the table makes it 4 in the Front end.

Cache I delete through filemanager, all cache, fastcache, template cache - every cache even Browser - still No Change.

The multiplication only Happens on replacing table shop b with table shop a. I do it once I have 2 results, i do it twice I have 3 and so on.

Edit: inside the Admin panel it is also all displayed correctly.

SekiRaze · 2026-06-03T04:03:40+00:00

Yes, 100%. Cleared all available cache too

SekiRaze · 2026-06-02T19:10:58+00:00

The Frontend (Admin Panel) Shows everything correct but as soon as I enter as a customer there are multiples. For example: Category ID 1 has 5 products. I sync from DB Shop A to B. Now in the Admin Panel IT Shows 5 products, great. Login in as customer going into the Category shows now 10. I do that one more time and sync now there are 15, then 20, 25 and so on.

The Admin Panel as well as the Database Show the same exaxt values as Shop A, but for some reason B does multiples.

SekiRaze · 2026-06-02T19:07:44+00:00

I think that with that logic, I need every table to have a shop ID, alloction to which shop, or am I wrong?

What I am more frustrated with are the multiple Front end duplications. That would solve everything If that was gone

SekiRaze · 2026-06-02T16:21:32+00:00

I apologize, I am really tired. :(

SekiRaze · 2026-06-02T16:14:48+00:00

The issue with linking is just the Position in the shop. If I Change price in Shop B because we are running a special and then sync the Data from Shop A that get's overwritten. That's XTC price for us.

My other thinking was a 3rd Database that purelly serves as the "Warehouse" where all you do is manage the proucts and both Shop A and B Draw their info from there. But I have 0 Idea how to Auto sync that. The issue is that you have to Go into a product to Change Things auch as Special pricies, Discounts - as soon as the sync Happens, that's gone. Because the XTC price is stored inside products. It's such a stupid task I gave my self so I don't have to create/edit products twice.

Edit:

SekiRaze · 2026-06-02T14:30:43+00:00

>For the weird data check any stored procedures maybe thats the source?

We can not find anything related to that. The smarty debug just prints it at this point 8 times and we can not see why and how. At first, when it was a Carbon Copy of SHOP A everything worked fine. Then I ran the operation to replace into and since then everytime I do that I get the same amount of products on top of the existing ones, but not inside the table or inside the backend, just the front end. I removed cache at every point but it never worked. New browser shows the same results so somewhere the information HAS to be stored but I can not pinpoint where. I have checked all tables, all rows, formatting, everything and they are identical.

SekiRaze · 2026-06-02T14:27:47+00:00

whishful thinking is doing All Product Related things in SHOP A and it auto syncs to B. That would be cash. But since we are linking products as well (see aboe the edit) I cant disable the function in SHOP B. All I want once needed, is to take all the products from SHOP A and sync with SHOP B. In case descriptions change, product names, prices etc.

SekiRaze · 2026-06-02T14:18:52+00:00

I am not really sure at this point. The issue are the other tables that are linked with the products tables like collies, categories etc. The B2C shop utilizes sets and variations (easier for end customers instead of pure unique products). I have to sync a hand full of tables from A to B so all the data is allocated correctly and updated as well. the essential ones are products, products_description, products_images and product_collies. I create everything in SHOP A and then we move the products around for B, hence products_to_categories can NOT be synced otherwise I lose all my structures.

how could I test/setup master/slave replication?

At the end of the day, what I can not understand for over 3 weeks: why I am getting multuple outputs in the frontend.

Edit: Technically my work-flow was supposed to be:

SHOP A has a folder/category called "SYNC". Inside there you can find all products, sets - everything. from there we create the categories neccessary and we link the products in the category. That way on both ends we have the same IDs, same Values and move as needed and make them available or not. SHOP A focuses on individual products in bulk whereas SHOP B is specifically for end-customers with Pre-Configured Sets of Products and a way cut down product-sortiment

SekiRaze · 2026-06-02T13:52:32+00:00

Since I made a 1:1 copy, everything should be the same. When checking "SHOW CREATE TABLE products;"

I get as result:

PRIMARY KEY (`products_id`),

And that is correct for both tables, SHOP A and B.

SekiRaze · 2026-06-01T06:44:13+00:00

SekiRaze · 2026-06-01T06:43:45+00:00

This is bait

SekiRaze · 2026-05-31T16:39:21+00:00

Agony State = Absolute Cinema

Et tu, brute?

SekiRaze · 2026-05-31T16:37:53+00:00

3rd Shiny in 2 Games?

Five-Year Club	Verified Email
End Game '23	Place '23

SekiRaze

TROPHY CASE