[Help]What to put in @GroupName

[Twilight]

1. Create a database named Billcrux30
2. Follow these steps

So..
Step 1
execute two SQL command

sp_configure 'allow updates', 1 
reconfigure with override

Step 2
Delete manual PS_Ncash linked server
Step 3
open SQLQueryNcash_Linked.sql
and change login and pass..if need and save
Step 4
execute SQLQueryNcash_Linked.sql

3. Run the scripts (attach)

[antiviru5]

doesn't work bro.. same problem ''No item located on that spot''

[Twilight]

log file report error?

[antiviru5]

Edited

[Twilight]

Rename items,skills,mobs,npc:
problems in names with 's
example
Legendary Fuma's Tooth -> rename Legendary Fumas Tooth
and others name..

[Josue1996143]

Twilight, Do you have a online.php script?

An script that shows online users? :O
If so, could you share? :P

[Twilight]

Twilight, Do you have a online.php script?

An script that shows online users? :O
If so, could you share? :P

Login

[antiviru5]

Oki thx twilight.. Um is there anyway you can create Login Php scritp? exemple like you need to log in to download client etc..i tried but no luck :(

[Twilight]

Oki thx twilight.. Um is there anyway you can create Login Php scritp? exemple like you need to log in to download client etc..i tried but no luck :(

I think any free CMS aka joomla..or other free cms

[Josue1996143]

That one isn't working tho..

[Twilight]

It just ... in the table char to create a column named LoginStatus (with default value - 0)
In this field, the stored procedure writes one - online or 0 - offline.
The script reads the current values


http://www.***********.de/forum/shai...rs-online.html

[cmaxlobo]

Download the file SQLQueryNcash_Linked.rar and follow the four steps above. Should work.
Check also the question of the PRC.

I heated the head for two days.

[antiviru5]

Hi twilight is there any sql query to fix this? becoz there is alot of items will be great if i can get query for that .. :D just too lazy to look 2000+ items..

Rename items,skills,mobs,npc:
problems in names with 's
example
Legendary Fuma's Tooth -> rename Legendary Fumas Tooth
and others name.

[Twilight]

-- Lazy Search

--Items
USE PS_GameDefs;
GO
SELECT  * FROM  Items WHERE  (ItemName = 'Long Sword');

USE PS_GameDefs;
GO

--Skills
SELECT * FROM  Skills WHERE (SkillName = 'NeedSkillName');

--Mobs

USE PS_GameDefs;
GO
SELECT * FROM  Mobs WHERE     (MobName = 'NeedMobName');

OR SQL LIKE
SQL LIKE - SQL Tutorial

USE PS_GameDefs;
GO
SELECT  * FROM  Items WHERE  (ItemName LIKE 'Legendary Fuma%');

[antiviru5]

i do know this code but still 1 by1 :D