[Arkarr]

Originally Posted by oaaron99 Php function to convert the auth to steamid: PHP Code: function toSteamID($id) {     if (is_numeric($id) && strlen($id) >= 16) {         $z = bcdiv(bcsub($id, '76561197960265728'), '2');     } elseif (is_numeric($id)) {         $z = bcdiv($id, '2'); // Actually new User ID format     } else {         return $id; // We have no idea what this is, so just return it.     }     $y = bcmod($id, '2');     return 'STEAM_0:' . $y . ':' . floor($z); }

Thanks !!

EDIT: It's hard to go back to sql. Still doing it, but, yeah, will take a bit of time.

[Arkarr]

Woah... hudge jump in past (damn it, sql). Here we go, the SQL function to do to transfer the credits rom rederswolfe store to zephy store :

PHP Code:

SET @DATABASE_NAME_REDERWOLF = 'store';
SET @DATABASE_NAME_ZEPHYRUS = 'store2';

DELIMITER $$
DROP FUNCTION IF EXISTS `toSteamID`$$
CREATE FUNCTION toSteamID(id TEXT)
  RETURNS TEXT
  LANGUAGE SQL
BEGIN
  RETURN CONCAT("STEAM_0:",id%2,":",floor(id/2));
END;
$$
DELIMITER ;

SET @q = CONCAT('UPDATE ', @DATABASE_NAME_ZEPHYRUS, '.store_players, ', @DATABASE_NAME_REDERWOLF, '.store_users',
                ' SET ', @DATABASE_NAME_ZEPHYRUS, '.store_players.credits=', @DATABASE_NAME_REDERWOLF,'.store_users.credits',
                ' WHERE toSteamID(', @DATABASE_NAME_REDERWOLF, '.store_users.auth)', '=CONCAT("STEAM_0:",', @DATABASE_NAME_ZEPHYRUS, '.store_players.authid)');
select @q;
PREPARE stmt FROM @q;
EXECUTE stmt;
DEALLOCATE PREPARE stmt; 


Need to be executed on the server who have the both database.

EDIT:

OLD POST !
See this instend : https://forums.alliedmods.net/showpo...&postcount=132

[Addicted.]

Originally Posted by Arkarr Woah... hudge jump in past (damn it, sql). Here we go, the SQL function to do to transfer the credits rom rederswolfe store to zephy store : PHP Code: SET @DATABASE_NAME_REDERWOLF = 'store'; SET @DATABASE_NAME_ZEPHYRUS = 'store2'; DELIMITER $$ DROP FUNCTION IF EXISTS `toSteamID`$$ CREATE FUNCTION toSteamID(id TEXT)   RETURNS TEXT   LANGUAGE SQL BEGIN   RETURN CONCAT("STEAM_0:",id%2,":",floor(id/2)); END; $$ DELIMITER ; SET @q = CONCAT('UPDATE ', @DATABASE_NAME_ZEPHYRUS, '.store_players, ', @DATABASE_NAME_REDERWOLF, '.store_users',                 ' SET ', @DATABASE_NAME_ZEPHYRUS, '.store_players.credits=', @DATABASE_NAME_REDERWOLF,'.store_users.credits',                 ' WHERE toSteamID(', @DATABASE_NAME_REDERWOLF, '.store_users.auth)', '=CONCAT("STEAM_0:",', @DATABASE_NAME_ZEPHYRUS, '.store_players.authid)'); select @q; PREPARE stmt FROM @q; EXECUTE stmt; DEALLOCATE PREPARE stmt;  Need to be executed on the server who have the both database.

Be cool if you could make one to transfer all the users over too.

I would do it myself but I am horrible with sql

[shavit]

Originally Posted by Bara After you've enough money? and both cases it was you who released it on the russian forums

not just russian forums; i posted it on some other site for people who want to test skins on their private servers and i got this pm on the site


lol

[shavit]

Originally Posted by Arkarr Woah... hudge jump in past (damn it, sql). Here we go, the SQL function to do to transfer the credits rom rederswolfe store to zephy store : PHP Code: SET @DATABASE_NAME_REDERWOLF = 'store'; SET @DATABASE_NAME_ZEPHYRUS = 'store2'; DELIMITER $$ DROP FUNCTION IF EXISTS `toSteamID`$$ CREATE FUNCTION toSteamID(id TEXT)   RETURNS TEXT   LANGUAGE SQL BEGIN   RETURN CONCAT("STEAM_0:",id%2,":",floor(id/2)); END; $$ DELIMITER ; SET @q = CONCAT('UPDATE ', @DATABASE_NAME_ZEPHYRUS, '.store_players, ', @DATABASE_NAME_REDERWOLF, '.store_users',                 ' SET ', @DATABASE_NAME_ZEPHYRUS, '.store_players.credits=', @DATABASE_NAME_REDERWOLF,'.store_users.credits',                 ' WHERE toSteamID(', @DATABASE_NAME_REDERWOLF, '.store_users.auth)', '=CONCAT("STEAM_0:",', @DATABASE_NAME_ZEPHYRUS, '.store_players.authid)'); select @q; PREPARE stmt FROM @q; EXECUTE stmt; DEALLOCATE PREPARE stmt;  Need to be executed on the server who have the both database.

STEAM_0 >> STEAM_1 for CS:GO

[MrPriime]

I can't install it :C

[Arkarr]

Originally Posted by shavit STEAM_0 >> STEAM_1 for CS:GO

Yeah nope. It works.

[kiko.]

I tested the Module with the custom knifes.
The Models are invisible.
The Models are in my models/materials folders.

No Errorlogs.

Thanks

[Drixevel]

People saying my name incorrectly in all these posts should be a good enough reason for me to change it. lol

[MrPriime]

The store isn't working for me. I load the plugins and it only shows the store-trade.smx. I also get the error on !admins

I use linux Sourcemod and Metamod, plz help me bbe